Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Database Error

  1. #11
    OpelAus Lurker auzvectra's Avatar
    Join Date
    Mar 2005
    Location
    Gold Coast
    Age
    41
    Posts
    7,299
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    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.

  2. #12
    OpelAus Enthusiast
    Join Date
    Dec 2003
    Posts
    1,936
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Job ticket has been submitted to the Provider.

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


  3. #13
    OpelAus Enthusiast
    Join Date
    Dec 2003
    Posts
    1,936
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.


  4. #14
    OpelAus Enthusiast
    Join Date
    Dec 2003
    Posts
    1,936
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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)
    --------------------------------------
    ---------------------------------------------


  5. #15
    OpelAus Enthusiast MK's Avatar
    Join Date
    Jul 2005
    Location
    Sydney & Niemcza
    Posts
    767
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    got one error now...
    Click here to enlarge

  6. #16
    OpelAus Forum Regular KID_SRi's Avatar
    Join Date
    Aug 2005
    Location
    Melburn City
    Age
    44
    Posts
    477
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I get that Database Error in Yellow everytime i log on in the past 48hours.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •