When using the SQLite database card dead-CodePudding

SQLite suddenly stuck phenomenon, and restart the process also useless, in the previous few months has been good, small database, data volume small!!!!!!

Database query without any problems, from the first time to add, add the unfinished, direct stuck behind another query, also all stuck, restart the process is still the same

CodePudding user response:

Amount of data more than the amount of ram

CodePudding user response:

You won't be wrote a infinite loop

CodePudding user response:

reference 1st floor huodexiangtiaogou123 response:

data quantity is more than the amount of ram.

Data is very small, is to add a title

CodePudding user response:

reference check on the second floor of wujiang south reply:

you wrote is not infinite loop

Infinite loop will cause of memory, but the program is stuck directly, don't move

CodePudding user response:

Well,,, at least you want to be clear,
Is connected to the first question,
Secondly what is you add code, etc.,,,,,,,

CodePudding user response:

reference 5 floor is nu month god reply:

well,,, at least you want to be clear,
Is connected to the first question,
Secondly what is you to add the code, and so on,,,,,,,

Stand-alone database, each customer has a running on their computer, then the code to run for a few months, is the old version, not the new version, is not a common phenomenon

CodePudding user response:

refer to the sixth floor, wu y reply:

Quote: refer to fifth floor is nu month god reply:
well,,, at least you want to be clear,
Is connected to the first question,
Secondly what is you to add the code, and so on,,,,,,,

Stand-alone database, each customer has a running on their computer, then the code to run for several months, is the old version, not the new version, not common

Do you have used in the system such as the lock control?

CodePudding user response:

references on 7th floor is wrath of god reply:

Quote: refer to the sixth floor, wu y reply:

Quote: refer to 5 floor is nu month god reply:
well,,, at least you want to be clear,
Is connected to the first question,
Secondly what is you to add the code, and so on,,,,,,,

Stand-alone database, each customer has a running on their computer, then the code to run for several months, is the old version, not the new version, not common

Do you have used in the system such as the lock control?

With the transaction, the lock to use c #

CodePudding user response:

refer to the eighth floor, wu y reply:

Quote: reference on 7th floor is wrath of god reply:

Quote: refer to the sixth floor, wu y reply:

Quote: refer to 5 floor is nu month god reply:
well,,, at least you want to be clear,
Is connected to the first question,
Secondly what is you to add the code, and so on,,,,,,,

Stand-alone database, each customer has a running on their computer, then the code to run for several months, is the old version, not the new version, not common

Do you have used in the system such as the lock control?

With the transaction, to use c # to the lock

Well, then you need to focus on trying to identify these transactions,
Probably is the result of the transaction data contention,

CodePudding user response:

references on 7th floor is wrath of god reply:

Quote: refer to the sixth floor, wu y reply:

Quote: refer to 5 floor is nu month god reply:
well,,, at least you want to be clear,
Is connected to the first question,
Secondly what is you to add the code, and so on,,,,,,,

Stand-alone database, each customer has a running on their computer, then the code to run for several months, is the old version, not the new version, not common

Do you have used in the system such as the lock control?

According to the most reasonable is by accident, but the user after a restart

CodePudding user response:

references to the tenth floor, wu y reply:

Quote: reference on 7th floor is wrath of god reply:

Quote: refer to the sixth floor, wu y reply:

Quote: refer to 5 floor is nu month god reply:
well,,, at least you want to be clear,
Is connected to the first question,
Secondly what is you to add the code, and so on,,,,,,,

Stand-alone database, each customer has a running on their computer, then the code to run for several months, is the old version, not the new version, not common

Do you have used in the system such as the lock control?

According to the most reasonable is by accident, but the user after a reboot is no use

I guess this may be a deadlock,

CodePudding user response:

11 references are nu month god reply:

Quote: reference to the tenth floor, wu y reply:

Quote: reference on 7th floor is wrath of god reply:

Quote: refer to the sixth floor, wu y reply:

Quote: refer to 5 floor is nu month god reply:
well,,, at least you want to be clear,
Is connected to the first question,
Secondly what is you to add the code, and so on,,,,,,,

Stand-alone database, each customer has a running on their computer, then the code to run for several months, is the old version, not the new version, not common

Do you have used in the system such as the lock control?

According to the most reasonable is by accident, but the user after a reboot is no use

I guess this may be a deadlock,

That is very troublesome, code simple, restart does not resolve the

CodePudding user response:

refer to 12th floor, wu y reply:

that is very troublesome, code simple, restart does not resolve the

You should ask about the specific operation of customer first,
Understands what the affairs of the business logic operations, leading to the problem of deadlock,
Then aiming at the two transactions, look at the specific situation,

CodePudding user response:

refer to the 13th floor is nu month god reply:

Quote: refer to 12th floor, wu y reply:

nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull