Job ticket has been submitted to the Provider.
Now I'm sick of this......
i've had it heaps too, but just refresh n it goes away.
'04 Sri-T Z23LET - latest stages underway - Slowly - Even slower - $5K over budget :-/
**Qld** Astra TS Turbo Tuner.
Job ticket has been submitted to the Provider.
Now I'm sick of this......
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.
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 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)
-------------------------------------- ---------------------------------------------
got one error now...
I get that Database Error in Yellow everytime i log on in the past 48hours.
There are currently 1 users browsing this thread. (0 members and 1 guests)