View previous topic :: View next topic |
Author |
Message |
Vextor
Joined: 09 Mar 2004
Post Count: 12086
Location: Hell
11331071 Potch
23689 Soldiers
160 Nation Points
|
Posted: Sat May 21, 2005 2:09 pm Post subject: Databse corruption |
|
|
One of the tables within the databse has been corrupted while I slept. I repaied this so now hings should be working fine. |
|
Back to top |
|
|
Earthquake923
SB90's Mechanized Monsters
Joined: 16 Apr 2005
Post Count: 1982
Location: Terana Plains
179201 Potch
0 Soldiers
778121 Nation Points
|
Posted: Sat May 21, 2005 2:27 pm Post subject: |
|
|
Err I still had an error when I tried to get in around 2:27pm _________________ If anybody asks about the avatar, I did it for Jess. |
|
Back to top |
|
|
Daniel Blackhand
siswai'aman Brotherhood of Pain
Joined: 18 Jun 2004
Post Count: 4503
Location: Yashuna
330059 Potch
0 Soldiers
5731866 Nation Points
|
Posted: Sat May 21, 2005 2:30 pm Post subject: |
|
|
I would just give it time and since SARS is aware of the problem, there is only one thing to do and that is try to be patient and wait. _________________
|
|
Back to top |
|
|
Elc
Rebel of Babylon
Joined: 24 May 2004
Post Count: 5757
Location: Blight's Bay
1133304 Potch
0 Soldiers
0 Nation Points
|
Posted: Sat May 21, 2005 2:37 pm Post subject: |
|
|
If it's a server issue rather than a database issue, then there's nothing SARSadmin can do about the problem. Like Lord Dredd has said, all we can do is wait it out and hope the server issues are dealt with quickly. _________________
"You make me smash the clock and feel, I'd rather die behind the wheel.
Time was never on my side, So on I wait my whole lifetime." |
|
Back to top |
|
|
Vextor
Joined: 09 Mar 2004
Post Count: 12086
Location: Hell
11331071 Potch
23689 Soldiers
160 Nation Points
|
Posted: Sat May 21, 2005 3:05 pm Post subject: |
|
|
Earthquake923 wrote: |
Err I still had an error when I tried to get in around 2:27pm |
You'll have to specify a timezone. It's not even 2:00pm where I am. |
|
Back to top |
|
|
Providence Luc
The Millenium Swords
Joined: 16 Mar 2005
Post Count: 1011
Location: Unknown
109035 Potch
275 Soldiers
71 Nation Points
|
Posted: Sat May 21, 2005 5:03 pm Post subject: |
|
|
I got an error... around 4:45am [+8:00] _________________ Why don't you drop by the Seraphim Garden and spend your Cabal Nights with me? |
|
Back to top |
|
|
Thief
Truth
Joined: 18 May 2004
Post Count: 929
213998 Potch
200 Soldiers
0 Nation Points
|
Posted: Sat May 21, 2005 5:06 pm Post subject: |
|
|
I'm still getting the error one or two minutes ago, though it's less frequent than earlier today. |
|
Back to top |
|
|
Vextor
Joined: 09 Mar 2004
Post Count: 12086
Location: Hell
11331071 Potch
23689 Soldiers
160 Nation Points
|
Posted: Sat May 21, 2005 5:53 pm Post subject: |
|
|
Pasting the exact text would also help. I assume everyone is just getting the server-side error, which is separate from the database corruption error that made the forum inaccessible. |
|
Back to top |
|
|
Daniel Blackhand
siswai'aman Brotherhood of Pain
Joined: 18 Jun 2004
Post Count: 4503
Location: Yashuna
330059 Potch
0 Soldiers
5731866 Nation Points
|
Posted: Sat May 21, 2005 7:35 pm Post subject: |
|
|
Quote: |
phpBB : Critical Error
Error clearing sessions table
DEBUG MODE
SQL Error : 1034 Incorrect key file for table: 'phpbb_sessions'. Try to repair it
DELETE FROM phpbb_sessions WHERE session_time < 1116714470 AND session_id <> '9647a4c807100f3abe7a5228a8c86f4e'
Line : 320
File : /forum/includes/sessions.php |
This is another one of the errors that has popped up. _________________
|
|
Back to top |
|
|
Vextor
Joined: 09 Mar 2004
Post Count: 12086
Location: Hell
11331071 Potch
23689 Soldiers
160 Nation Points
|
Posted: Sat May 21, 2005 9:22 pm Post subject: |
|
|
That information helped. Hopefully that is fixed now. It was another databse corruption issue. |
|
Back to top |
|
|
Drizzt
Rangers Of Mielikki
Joined: 12 Oct 2004
Post Count: 1434
250081 Potch
0 Soldiers
0 Nation Points
|
Posted: Sat May 21, 2005 10:17 pm Post subject: |
|
|
Quote: |
phpBB : Critical Error
Could not obtain lastvisit data from user table
DEBUG MODE
SQL Error : 1016 Can't open file: 'phpbb_users.MYD'. (errno: 145)
SELECT * FROM phpbb_users WHERE user_id = 1026
Line : 68
File : /forum/includes/sessions.php
|
OKay, just since the message I was getting last night differs slightly from Lord Dredd's, I posted it as well. Things seem okay now, and just on occassion I get the basic:
phpBB : Critical Error
Could not connect to the database
Not to worry though, things always fix themselves or go back to normal, so it does not bother me at all. _________________ “Firbolgs die with honor,” Morten explained as the logs beneath Tavis began to burn. “We don’t beg for mercy. We don’t show pain. We just die.”
“Maybe we skin you alive,” Noote warned. “That hurt plenty." - The Twilight Giants, Book I. |
|
Back to top |
|
|
Vextor
Joined: 09 Mar 2004
Post Count: 12086
Location: Hell
11331071 Potch
23689 Soldiers
160 Nation Points
|
Posted: Sat May 21, 2005 11:32 pm Post subject: |
|
|
Yeah, that error would have been caused by the database corruption. That problem I can fix from my side (and has been fixed). However, the current problem with the server's mySQL being flaky is probably caused by tremendous traffic at one of the other sites hosted on the same server or something. I have no idea. |
|
Back to top |
|
|
Daniel Blackhand
siswai'aman Brotherhood of Pain
Joined: 18 Jun 2004
Post Count: 4503
Location: Yashuna
330059 Potch
0 Soldiers
5731866 Nation Points
|
Posted: Sat May 21, 2005 11:34 pm Post subject: |
|
|
Well than all we can do is be patient and hope that they can cain control of the problem on the server. _________________
|
|
Back to top |
|
|
Dakota
Protectors of the Deeper Well
Joined: 21 Aug 2004
Post Count: 1499
Location: Vinal Del Zexay
1300636 Potch
69 Soldiers
0 Nation Points
|
Posted: Sun May 22, 2005 12:30 am Post subject: |
|
|
The corruption is fially over Im glad cause I was typing something in a forum for a good while it was pretty long & I submitted it & to my horror that white screen popped up I cussed like a sailor but im glad its better now. _________________ Its height. |
|
Back to top |
|
|
Daniel Blackhand
siswai'aman Brotherhood of Pain
Joined: 18 Jun 2004
Post Count: 4503
Location: Yashuna
330059 Potch
0 Soldiers
5731866 Nation Points
|
Posted: Sun May 22, 2005 12:42 am Post subject: |
|
|
Quote: |
phpBB : Critical Error
Error doing DB query userdata row fetch
DEBUG MODE
SQL Error : 1016 Can't open file: 'phpbb_sessions.MYD'. (errno: 145)
SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '399b4e4df6a0fb9e20bf3b0075cd5816' AND u.user_id = s.session_user_id
Line : 265
File : /forum/includes/sessions.php |
Here is another of those annoying messages.
Quote: |
phpBB : Critical Error
Error doing DB query userdata row fetch
DEBUG MODE
SQL Error : 1016 Can't open file: 'phpbb_sessions.MYD'. (errno: 145)
SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = 'c09120ca88604f6fa706bc2c8f464826' AND u.user_id = s.session_user_id
Line : 265
File : /forum/includes/sessions.php |
And another. _________________
Last edited by Daniel Blackhand on Sun May 22, 2005 12:58 am; edited 1 time in total |
|
Back to top |
|
|
|
|