Bitcoin Forum
May 05, 2024, 04:26:17 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: I come across a Database Error  (Read 189 times)
virasog (OP)
Legendary
*
Offline Offline

Activity: 2982
Merit: 1159



View Profile
August 12, 2022, 10:15:49 AM
Merited by DdmrDdmr (3)
 #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.

.
.DuelbitsSPORTS.
▄▄▄███████▄▄▄
▄▄█████████████████▄▄
▄██████████████████████▄
██████████████████████████
███████████████████████████
██████████████████████████████
██████████████████████████████
█████████████████████████████
███████████████████████████
█████████████████████████
▀████████████████████████
▀▀███████████████████
██████████████████████████████
██
██
██
██

██
██
██
██

██
██
██
████████▄▄▄▄██▄▄▄██
███▄█▀▄▄▀███▄█████
█████████████▀▀▀██
██▀ ▀██████████████████
███▄███████████████████
███████████████████████
███████████████████████
███████████████████████
███████████████████████
███████████████████████
▀█████████████████████▀
▀▀███████████████▀▀
▀▀▀▀█▀▀▀▀
OFFICIAL EUROPEAN
BETTING PARTNER OF
ASTON VILLA FC
██
██
██
██

██
██
██
██

██
██
██
10%   CASHBACK   
          100%   MULTICHARGER   
1714926377
Hero Member
*
Offline Offline

Posts: 1714926377

View Profile Personal Message (Offline)

Ignore
1714926377
Reply with quote  #2

1714926377
Report to moderator
"This isn't the kind of software where we can leave so many unresolved bugs that we need a tracker for them." -- Satoshi
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1714926377
Hero Member
*
Offline Offline

Posts: 1714926377

View Profile Personal Message (Offline)

Ignore
1714926377
Reply with quote  #2

1714926377
Report to moderator
1714926377
Hero Member
*
Offline Offline

Posts: 1714926377

View Profile Personal Message (Offline)

Ignore
1714926377
Reply with quote  #2

1714926377
Report to moderator
1714926377
Hero Member
*
Offline Offline

Posts: 1714926377

View Profile Personal Message (Offline)

Ignore
1714926377
Reply with quote  #2

1714926377
Report to moderator
jackg
Copper Member
Legendary
*
Offline Offline

Activity: 2856
Merit: 3071


https://bit.ly/387FXHi lightning theory


View Profile
August 12, 2022, 10: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.
DdmrDdmr
Legendary
*
Offline Offline

Activity: 2310
Merit: 10758


There are lies, damned lies and statistics. MTwain


View Profile WWW
August 12, 2022, 10:42:45 AM
Merited by Welsh (2), Pmalek (2), Bitcoin_Arena (1)
 #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).
PX-Z
Hero Member
*****
Offline Offline

Activity: 1442
Merit: 842


Top Crypto Casino


View Profile WWW
August 12, 2022, 10:43:58 AM
Merited by Pmalek (2)
 #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://bitcointalk.org/index.php?topic=246674.0
[2] https://bitcointalk.org/index.php?topic=2486697.0
[3] https://bitcointalk.org/index.php?topic=2153452.0

█████████████████████████
████▐██▄█████████████████
████▐██████▄▄▄███████████
████▐████▄█████▄▄████████
████▐█████▀▀▀▀▀███▄██████
████▐███▀████████████████
████▐█████████▄█████▌████
████▐██▌█████▀██████▌████
████▐██████████▀████▌████
█████▀███▄█████▄███▀█████
███████▀█████████▀███████
██████████▀███▀██████████
█████████████████████████
.
BC.GAME
▄▄░░░▄▀▀▄████████
▄▄▄
██████████████
█████░░▄▄▄▄████████
▄▄▄▄▄▄▄▄▄██▄██████▄▄▄▄████
▄███▄█▄▄██████████▄████▄████
███████████████████████████▀███
▀████▄██▄██▄░░░░▄████████████
▀▀▀█████▄▄▄███████████▀██
███████████████████▀██
███████████████████▄██
▄███████████████████▄██
█████████████████████▀██
██████████████████████▄
.
..CASINO....SPORTS....RACING..
█░░░░░░█░░░░░░█
▀███▀░░▀███▀░░▀███▀
▀░▀░░░░▀░▀░░░░▀░▀
░░░░░░░░░░░░
▀██████████
░░░░░███░░░░
░░█░░░███▄█░░░
░░██▌░░███░▀░░██▌
░█░██░░███░░░█░██
░█▀▀▀█▌░███░░█▀▀▀█▌
▄█▄░░░██▄███▄█▄░░▄██▄
▄███▄
░░░░▀██▄▀


▄▄████▄▄
▄███▀▀███▄
██████████
▀███▄░▄██▀
▄▄████▄▄░▀█▀▄██▀▄▄████▄▄
▄███▀▀▀████▄▄██▀▄███▀▀███▄
███████▄▄▀▀████▄▄▀▀███████
▀███▄▄███▀░░░▀▀████▄▄▄███▀
▀▀████▀▀████████▀▀████▀▀
noormcs5
Hero Member
*****
Offline Offline

Activity: 2632
Merit: 613


Leading Crypto Sports Betting & Casino Platform


View Profile
August 12, 2022, 06: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://bitcointalk.org/index.php?topic=246674.0
[2] https://bitcointalk.org/index.php?topic=2486697.0
[3] https://bitcointalk.org/index.php?topic=2153452.0

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.

..Stake.com..   ▄████████████████████████████████████▄
   ██ ▄▄▄▄▄▄▄▄▄▄            ▄▄▄▄▄▄▄▄▄▄ ██  ▄████▄
   ██ ▀▀▀▀▀▀▀▀▀▀ ██████████ ▀▀▀▀▀▀▀▀▀▀ ██  ██████
   ██ ██████████ ██      ██ ██████████ ██   ▀██▀
   ██ ██      ██ ██████  ██ ██      ██ ██    ██
   ██ ██████  ██ █████  ███ ██████  ██ ████▄ ██
   ██ █████  ███ ████  ████ █████  ███ ████████
   ██ ████  ████ ██████████ ████  ████ ████▀
   ██ ██████████ ▄▄▄▄▄▄▄▄▄▄ ██████████ ██
   ██            ▀▀▀▀▀▀▀▀▀▀            ██ 
   ▀█████████▀ ▄████████████▄ ▀█████████▀
  ▄▄▄▄▄▄▄▄▄▄▄▄███  ██  ██  ███▄▄▄▄▄▄▄▄▄▄▄▄
 ██████████████████████████████████████████
▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄
█  ▄▀▄             █▀▀█▀▄▄
█  █▀█             █  ▐  ▐▌
█       ▄██▄       █  ▌  █
█     ▄██████▄     █  ▌ ▐▌
█    ██████████    █ ▐  █
█   ▐██████████▌   █ ▐ ▐▌
█    ▀▀██████▀▀    █ ▌ █
█     ▄▄▄██▄▄▄     █ ▌▐▌
█                  █▐ █
█                  █▐▐▌
█                  █▐█
▀▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀█
▄▄█████████▄▄
▄██▀▀▀▀█████▀▀▀▀██▄
▄█▀       ▐█▌       ▀█▄
██         ▐█▌         ██
████▄     ▄█████▄     ▄████
████████▄███████████▄████████
███▀    █████████████    ▀███
██       ███████████       ██
▀█▄       █████████       ▄█▀
▀█▄    ▄██▀▀▀▀▀▀▀██▄  ▄▄▄█▀
▀███████         ███████▀
▀█████▄       ▄█████▀
▀▀▀███▄▄▄███▀▀▀
..PLAY NOW..
Fivestar4everMVP
Legendary
*
Offline Offline

Activity: 2254
Merit: 1051


Leading Crypto Sports Betting & Casino Platform


View Profile
August 14, 2022, 10: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.

..Stake.com..   ▄████████████████████████████████████▄
   ██ ▄▄▄▄▄▄▄▄▄▄            ▄▄▄▄▄▄▄▄▄▄ ██  ▄████▄
   ██ ▀▀▀▀▀▀▀▀▀▀ ██████████ ▀▀▀▀▀▀▀▀▀▀ ██  ██████
   ██ ██████████ ██      ██ ██████████ ██   ▀██▀
   ██ ██      ██ ██████  ██ ██      ██ ██    ██
   ██ ██████  ██ █████  ███ ██████  ██ ████▄ ██
   ██ █████  ███ ████  ████ █████  ███ ████████
   ██ ████  ████ ██████████ ████  ████ ████▀
   ██ ██████████ ▄▄▄▄▄▄▄▄▄▄ ██████████ ██
   ██            ▀▀▀▀▀▀▀▀▀▀            ██ 
   ▀█████████▀ ▄████████████▄ ▀█████████▀
  ▄▄▄▄▄▄▄▄▄▄▄▄███  ██  ██  ███▄▄▄▄▄▄▄▄▄▄▄▄
 ██████████████████████████████████████████
▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄
█  ▄▀▄             █▀▀█▀▄▄
█  █▀█             █  ▐  ▐▌
█       ▄██▄       █  ▌  █
█     ▄██████▄     █  ▌ ▐▌
█    ██████████    █ ▐  █
█   ▐██████████▌   █ ▐ ▐▌
█    ▀▀██████▀▀    █ ▌ █
█     ▄▄▄██▄▄▄     █ ▌▐▌
█                  █▐ █
█                  █▐▐▌
█                  █▐█
▀▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀█
▄▄█████████▄▄
▄██▀▀▀▀█████▀▀▀▀██▄
▄█▀       ▐█▌       ▀█▄
██         ▐█▌         ██
████▄     ▄█████▄     ▄████
████████▄███████████▄████████
███▀    █████████████    ▀███
██       ███████████       ██
▀█▄       █████████       ▄█▀
▀█▄    ▄██▀▀▀▀▀▀▀██▄  ▄▄▄█▀
▀███████         ███████▀
▀█████▄       ▄█████▀
▀▀▀███▄▄▄███▀▀▀
..PLAY NOW..
Pmalek
Legendary
*
Offline Offline

Activity: 2758
Merit: 7132



View Profile
August 16, 2022, 09: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."

.
.BLACKJACK ♠ FUN.
█████████
██████████████
████████████
█████████████████
████████████████▄▄
░█████████████▀░▀▀
██████████████████
░██████████████
████████████████
░██████████████
████████████
███████████████░██
██████████
CRYPTO CASINO &
SPORTS BETTING
▄▄███████▄▄
▄███████████████▄
███████████████████
█████████████████████
███████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
███████████████████████
█████████████████████
███████████████████
▀███████████████▀
█████████
.
Welsh
Staff
Legendary
*
Offline Offline

Activity: 3262
Merit: 4110


View Profile
August 16, 2022, 09: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.
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!