PDA

View Full Version : Database Error



oneightoo
17th January 2007, 06:18 PM
Have gotten the below message quite a few times in the last 15 minutes....




Database Error Database error
The database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the www.opelaus.com home page, then try to open another page.
* Click the Back button to try another link.

The www.opelaus.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

did we break it?

PaulyJ
17th January 2007, 06:20 PM
Its been fine with me...

oneightoo
17th January 2007, 06:21 PM
might be my internetz

Dee
17th January 2007, 06:21 PM
i saw that once last night..

i think you broke it matchu

oneightoo
17th January 2007, 06:24 PM
i think you broke it matchu

http://www.myteespot.com/images/thumbs/t_6430_01.jpg

Dee
17th January 2007, 06:26 PM
http://www.myteespot.com/images/thumbs/t_6430_01.jpg

ummm no


and on topic: i just got that message again

Turblue
17th January 2007, 06:27 PM
I have had a lot of this turn up in my admin email.

I notice this when the provider is doing the fiddle/upgrade thing. Normally I cop it for a couple of weeks and then it goes away.

oneightoo
17th January 2007, 06:28 PM
ahh there we go, a reasonable answer..

case closed..

SSS_Hoon
24th January 2007, 09:00 AM
i just got this message then, and i had too re login.


SSS_Hoon

Turblue
24th January 2007, 06:26 PM
I have just contacted vBulletin Support for advice.

Awaiting a response.

auzvectra
24th January 2007, 07:38 PM
i've had it heaps too, but just refresh n it goes away.

Turblue
25th January 2007, 06:26 PM
Job ticket has been submitted to the Provider.

Now I'm sick of this......

Turblue
26th January 2007, 09:31 AM
Let's see what happens......

It looks to me as though the SQL database program was stopping and starting.

- It started up on Jan 24, 2007 at 12:30 AM.
- It started up on Jan 24, 2007 at 01:05 PM.
- It started up on Jan 25, 2007 at 12:06 AM.
- It started up on Jan 25, 2007 at 12:24 AM.
- It started up on Jan 25, 2007 at 12:30 AM.
- It started up on Jan 25, 2007 at 09:14 AM.
- It started up on Jan 25, 2007 at 01:05 PM.

Taking into account this is server time, 12:30am = 7:30 pm here in Vic. The db errors all align with these times. Funny thing is, the times are the same each day. Took a bit to explain this to them. But we got there!!

They have contacted me back, and indicated they have changed some setting.

Turblue
26th January 2007, 06:38 PM
Hmm... tweaked....sure....

Here is my last reply to them....

Hello there.

Sorry I still get errors. And they match the times the sql process restarts.

In the last 30 minutes I have logged this data from myphpadmin. It has restarted at least 8 times.

- It started up on Jan 26, 2007 at 12:00 AM.
- It started up on Jan 26, 2007 at 12:03 AM.
- It started up on Jan 26, 2007 at 12:09 AM.
- It started up on Jan 26, 2007 at 12:12 AM.
- It started up on Jan 26, 2007 at 12:15 AM.
- It started up on Jan 26, 2007 at 12:21 AM.
- It started up on Jan 26, 2007 at 12:27 AM.
- It started up on Jan 26, 2007 at 12:30 AM.

Sample of the errors. Please compare the times.

One error even states that the sql server is shutting down. Not only is the error occuring on the database running the www.opelaus.com (http://www.opelaus.com/forum/../) forum, I am now logging errors from the vic.opelaus.com forum.

Even phpmyadmin is failing, please check listed error. There is something wrong with the sql server process. It is affecting more than one databases.

Please investigate before the databases are permanently corrupted.!!!!!


-----------------------------------------------------------------------------------
Database error in vBulletin :

mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/turblu84/public_html/opelaus/forum/includes/class_core.php on line 273

MySQL Error :
Error Number :
Date : Friday, January 26th 2007 @ 12:00:19 AM
-----------------------------------------------------------------------------------
Database error in vBulletin 3.6.4:

Invalid SQL:

UPDATE datastore SET
data = data - 1,
data = IF(data < 0, 0, data)
WHERE title = 'mailqueue';

MySQL Error : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error Number : 2002
Date : Friday, January 26th 2007 @ 12:03:07 AM
-----------------------------------------------------------------------------------
Database error in vBulletin :

mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/turblu84/public_html/opelaus/forum/includes/class_core.php on line 273

MySQL Error :
Error Number :
Date : Friday, January 26th 2007 @ 12:12:08 AM
-----------------------------------------------------------------------------------
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,

editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid


FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)

LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 1)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 1 AND sigparsed.languageid = 1)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)

WHERE post.postid IN (0,194000,194001,194002,194031,194808,194809,19481 0,194811,194812,194823,194829,194882,194908,195027 ,195050)
ORDER BY post.dateline;

MySQL Error : Server shutdown in progress
Error Number : 1053
Date : Friday, January 26th 2007 @ 12:15:07 AM
-----------------------------------------------------------------------------------
Database error in vBulletin :

mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/turblu84/public_html/opelaus/forum/includes/class_core.php on line 273

MySQL Error :
Error Number :
Date : Friday, January 26th 2007 @ 12:18:07 AM
-----------------------------------------------------------------------------------
Database error in vBulletin :

mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/turblu84/public_html/vic/forum/includes/class_core.php on line 273

MySQL Error :
Error Number :
Date : Friday, January 26th 2007 @ 12:21:33 AM
-----------------------------------------------------------------------------------
Database error in vBulletin :

mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/turblu84/public_html/vic/forum/includes/class_core.php on line 273

MySQL Error :
Error Number :
Date : Friday, January 26th 2007 @ 12:24:09 AM
-----------------------------------------------------------------------------------
Database error in vBulletin 3.6.4:

Invalid SQL:

INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('f2c07213df40c92240fe40cd9b0839d2', 0, '211.195.38.163', '8092c6321cb2936662cba9f190077a76', 1169800026, '/forum/faq.php', 0, 0, 0, 0, 0, 0, 0, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)', 0, 0);

MySQL Error : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error Number : 2002
Date : Friday, January 26th 2007 @ 12:27:06 AM
-----------------------------------------------------------------------------------
phpMyAdmin - error

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
-------------------------------------- ---------------------------------------------

MK
27th January 2007, 06:13 PM
got one error now...

KID_SRi
27th January 2007, 06:21 PM
I get that Database Error in Yellow everytime i log on in the past 48hours.