Author

Topic: I come across a Database Error (Read 189 times)

staff
Activity: 3248
Merit: 4110
August 16, 2022, 05:11:50 AM
#8
It seems that the error pop-up rather seldom, and has been doing so for over a decade on the forum. My gues it that it can’t write to the DB due to a temporary lock of some sort. These things normally get cleared rather quickly and kind of "self-cure" (well, rather, the DB engine takes care of it).

Normally it can occur when there are multiple simultaneous petition that need to access the same internal database page (i.e. concurrent write petitions, a longish read process that escalates to a page or table lock for a few seconds, and so forth).

Yeah, I run into errors like this quite frequently, and without really looking into it, I suspected it would be along these lines. Especially, when you're doing things quickly, it seems to happen a little more frequently, or taking actions which take a lot longer, like deleting a lot of replies at once.

I never contacted anyone about it, since I suspected that every staff user runs into the error, as I'm not doing anything particularly out of the ordinary. I don't think I've ever run into it outside of that though, except when maybe the old statistics were available to view, but they've been long disabled now.
legendary
Activity: 2730
Merit: 7065
Farewell, Leo. You will be missed!
August 16, 2022, 05:06:34 AM
#7
This one is different from the other ones you mentioned and the one DdmrDdmr linked to. Although the title says "Database error", it has got nothing to do with a database error of the forum. It's an error message the user Nekeni experienced when he was trying to open his Armory wallet.

Hello,

I got a database error message when trying to launch Armory

"The DB has returned the following error : command checksum failure. Armory will now shut down."
legendary
Activity: 2254
Merit: 1052
Leading Crypto Sports Betting & Casino Platform
August 14, 2022, 06:57:40 PM
#6
I believe, that too many people pressing the post button simultaneously may result in this database error.
You are right and this is exactly what I wanted to point out to op after reading the post.
I've had this same experience on several other platforms where so many users trying to use a feature at the same time,  and because the database could or can not handle that amount of request at the same time,  it causes that part of the platform, and sometimes,  the entire platform to crash.
So I believe ops experience is not possibly a database error per say since it was only a one time thing,  and he seems to be the only one that experienced this, this confirms the fact that it is possible that there were several other users clicking the "post" button when op click the button to publish his post.
hero member
Activity: 2632
Merit: 613
Leading Crypto Sports Betting & Casino Platform
August 12, 2022, 02:35:48 PM
#5
Found similar errors[1][2][3] but it's just rarely happens so i guess its just small downtime on the server side. Theymos could see it on the logs but probably won't explain what had happened.

[1] https://bitcointalksearch.org/topic/database-error-246674
[2] https://bitcointalksearch.org/topic/database-error-2486697
[3] https://bitcointalksearch.org/topic/database-error-2153452

I checked all of these threads but there has been no solid reason described anywhere. Since this does not happen often, there is no requirement of clarifications.
I believe, that too many people pressing the post button simultaneously may result in this database error.
hero member
Activity: 1428
Merit: 836
Top Crypto Casino
August 12, 2022, 06:43:58 AM
#4
Found similar errors[1][2][3] but it's just rarely happens so i guess its just small downtime on the server side. Theymos could see it on the logs but probably won't explain what had happened.

[1] https://bitcointalksearch.org/topic/database-error-246674
[2] https://bitcointalksearch.org/topic/database-error-2486697
[3] https://bitcointalksearch.org/topic/database-error-2153452
legendary
Activity: 2310
Merit: 10758
There are lies, damned lies and statistics. MTwain
August 12, 2022, 06:42:45 AM
#3
<...>
It seems that the error pop-up rather seldom, and has been doing so for over a decade on the forum. My gues it that it can’t write to the DB due to a temporary lock of some sort. These things normally get cleared rather quickly and kind of "self-cure" (well, rather, the DB engine takes care of it).

Normally it can occur when there are multiple simultaneous petition that need to access the same internal database page (i.e. concurrent write petitions, a longish read process that escalates to a page or table lock for a few seconds, and so forth).
copper member
Activity: 2856
Merit: 3071
https://bit.ly/387FXHi lightning theory
August 12, 2022, 06:30:08 AM
#2
I think it's one of those errors that's given if there's an error but the server can't diagnose it (or it's a risk to the security of the forum if it does).

It's probably the database receiving too many requests to process at once, an error writing your post on the database or the post not being parsed correctly by the scanner that checks posts for things that are suspicious that just stopped working or was interrupted.
legendary
Activity: 2954
Merit: 1159
August 12, 2022, 06:15:49 AM
#1
When i try to post, i see a database error. I wonder what is this error about as i did not saw this error before ?



However it was just one time error, the next time i pressed the post button, the post got published.
Jump to: