Announcement

Collapse
No announcement yet.

Database error in vBulletin 5.1.0

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MDawg
    replied
    I am getting this with vb 5.2.4:

    http://www.vbulletin.com/forum/forum...44#post4354244


    Leave a comment:


  • Lynne
    replied
    I believe you are running into this bug which is fixed in 5.1.1 - http://tracker.vbulletin.com/browse/VBV-10306

    Leave a comment:


  • marky
    replied
    This has no fix?

    Leave a comment:


  • marky
    replied
    Another:

    [Showing truncated query, original length: 3952]
    [First 500 chars]
    Invalid SQL:
    (SELECT n.nodeid, n.routeid, n.publishdate, n.unpublishdate, n.userid , n.authorname, n.title, n.starter, n.lastcontent, n.lastcontentid,
    n.lastcontentauthor, n.lastauthorid, n.textcount, n.totalcount, n.ipaddress, text.rawtext, text.pagetext, text.previewtext, pm.msgtype, s.folderid, 'messages' AS titlephrase, u.username, starter.routeid,
    s.msgread, pm.about, pm.aboutid, n.routeid AS aboutrouteid, starter.title AS abouttitle, starter.userid AS starteruserid, starter.created
    [Last 500 chars]
    eid
    INNER JOIN node AS n ON n.nodeid = pm.nodeid
    INNER JOIN sentto AS s ON s.nodeid = pm.nodeid
    LEFT JOIN node AS about ON about.nodeid = pm.aboutid
    LEFT JOIN node AS starter ON about.starter = starter.nodeid
    LEFT JOIN user AS u ON u.userid = about.lastauthorid
    LEFT JOIN poll AS poll ON poll.nodeid = pm.aboutid
    WHERE s.userid = 35 AND s.msgread=0 AND s.deleted = 0 AND n.userid NOT IN (-1) AND pm.msgtype = 'notification'
    ORDER BY n.created DESC
    LIMIT 5)
    /**pmPreview**/;

    MySQL Error : Incorrect key file for table '/tmp/#sql_62f5_2.MYI'; try to repair it
    Error Number : 126
    Request Date : Saturday, May 3rd 2014 @ 05:59:19 PM
    Error Date : Saturday, May 3rd 2014 @ 05:59:20 PM
    Script : http:///privatemessage/index
    Referrer : webpage
    IP Address : x.x.x.x
    Username : username
    Classname : vB_Database_MySQLi
    MySQL Version :


    Seems to be getting more frequent now.

    Leave a comment:


  • marky
    replied
    This errors continue. A few minutes ago this one came up:

    Database error in vBulletin 5.1.0:

    Invalid SQL:
    DELETE FROM cacheevent
    WHERE `event` IN ('nodeChg_47662','nodeChg_2236','nodeChg_2225','nodeChg_3','nodeChg_2','nodeChg_1')
    /**cacheevent**/;

    MySQL Error : Deadlock found when trying to get lock; try restarting transaction
    Error Number : 1213
    Request Date : Thursday, May 1st 2014 @ 07:52:22 PM
    Error Date : Thursday, May 1st 2014 @ 07:52:27 PM
    Script : http:///create-content/Text/
    Referrer : url of site
    IP Address : x.x.x.x
    Username : username
    Classname : vB_Database_MySQLi
    MySQL Version :


    Should we making the habit of clearing the cache tables every time or is there a better solution for this?

    Leave a comment:


  • marky
    replied
    Ok, Thanks. We have truncate the suggested cache tables.

    Is this a common issue? Why is this happening?

    Leave a comment:


  • Zachery
    replied
    Truncate the cache table, and cacheevent. Issue should go away, for a bit anyway.

    Leave a comment:


  • marky
    started a topic Database error in vBulletin 5.1.0

    Database error in vBulletin 5.1.0

    Got an error today (everything is verbatim except the bolded part):

    Invalid SQL:
    /** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'node_10_lvl1data' AND event = 'nodeChg_10') OR
    (cacheid = 'node_11_lvl1data' AND event = 'nodeChg_11') OR
    (cacheid = 'node_12_lvl1data' AND event = 'nodeChg_12') OR
    (cacheid = 'node_14_lvl1data' AND event = 'nodeChg_14') OR
    (cacheid = 'node_18150_lvl1data' AND event = 'nodeChg_18150') OR
    (cacheid = 'node_193_lvl1data' AND event = 'nodeChg_193') OR
    (cacheid = 'node_1_lvl1data' AND event = 'nodeChg_1') OR
    (cacheid = 'node_36665_lvl1data' AND event = 'nodeChg_36665') OR
    (cacheid = 'node_42201_lvl1data' AND event = 'nodeChg_42201') OR
    (cacheid = 'node_4302_lvl1data' AND event = 'nodeChg_4302') OR
    (cacheid = 'node_44840_lvl1data' AND event = 'nodeChg_44840') OR
    (cacheid = 'node_45443_lvl1data' AND event = 'nodeChg_45443') OR
    (cacheid = 'node_47561_lvl1data' AND event = 'nodeChg_47561') OR
    (cacheid = 'node_48969_lvl1data' AND event = 'nodeChg_48969') OR
    (cacheid = 'node_5_lvl1data' AND event = 'nodeChg_5') OR
    (cacheid = 'node_6_lvl1data' AND event = 'nodeChg_6') OR
    (cacheid = 'node_7_lvl1data' AND event = 'nodeChg_7') OR
    (cacheid = 'node_8_lvl1data' AND event = 'nodeChg_8') OR
    (cacheid = 'vB_ChTreeWithLast' AND event = 'vB_ChannelStructure_chg') OR
    (cacheid = 'vB_ChannelTreeRaw_56' AND event = 'perms_changed') OR
    (cacheid = 'vB_ChannelTreeRaw_56' AND event = 'userPerms_56') OR
    (cacheid = 'vB_ChannelTreeRaw_56' AND event = 'vB_ChannelStructure_chg');

    MySQL Error : Deadlock found when trying to get lock; try restarting transaction
    Error Number : 1213
    Request Date : Tuesday, April 22nd 2014 @ 08:13:49 PM
    Error Date : Tuesday, April 22nd 2014 @ 08:13:50 PM
    Script : http:///forum/main-category/talk-networking/ideas
    Referrer :
    IP Address : userip
    Username : username
    Classname : vB_Database_MySQLi
    MySQL Version :

    ------------------------------------------------------------------------------------------------------

    A few days ago we got a similar error:

    [Showing truncated query, original length: 20233]
    [First 500 chars]
    Invalid SQL:
    /** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
    ('node_1_lvl1data','nodeChg_1'),
    ('getSearchResults_678c0384ffcf2c0e224be53858005a17','perms_changed'),
    ('getSearchResults_678c0384ffcf2c0e224be53858005a17','vB_ChannelStructure_chg'),
    ('getSearchResults_678c0384ffcf2c0e224be53858005a17','vB_SearchResults_chg_0'),
    ('SrchResults0872991455','nodeChg_47102'),
    ('SrchResults01561326027','nodeChg_47228'),
    ('SrchResults02627501302','nodeChg_47265'),
    ('SrchResults0378131356
    [Last 500 chars]
    'vbnodetext47761_1_0:787cefe106de1b3cdbce612ac3456f0d','nodeChg_2207'),
    ('vbnodetext47761_1_0:787cefe106de1b3cdbce612ac3456f0d','vB_Language_languageCache'),
    ('vbnodetext_pre_47761_1_0:787cefe106de1b3cdbce612ac3456f0d','nodeChg_47761'),
    ('vbnodetext_pre_47761_1_0:787cefe106de1b3cdbce612ac3456f0d','nodeChg_2207'),
    ('vbnodetext_pre_47761_1_0:787cefe106de1b3cdbce612ac3456f0d','vB_Language_languageCache'),
    ('vBPage_70929362c8cc980c5fab4b03da2cfc5f_1',''),
    ('vbPre_conversation292.279.2207.47101','');

    MySQL Error : Deadlock found when trying to get lock; try restarting transaction
    Error Number : 1213
    Request Date : Sunday, April 20th 2014 @ 08:48:12 AM
    Error Date : Sunday, April 20th 2014 @ 08:48:14 AM
    Script : http:///forum/main-category/talk-networking/ideas
    Referrer :
    IP Address : userip
    Username : Guest
    Classname : vB_Database_MySQLi
    MySQL Version :

    ------------------------------------------------------------------------------------------------------
    1. vBulletin Version: vBulletin 5.1.0
    2. PHP Version: 5.4.17
    3. MySQL Version: 5.5.31-log
    4. Any Addons installed: no
    5. Does the issue occur in a default style? n/a
    6. Error message on the screen: unsure (error came up in an email)
    7. Browser and Browser version used: n/a
    8. A list of steps that can be used to recreate the issue: unsure

    Please advise what can be done about this. We looked up this problem and I believe one of the older threads said to do a repair on the "cacheevent" table. We did that twice (since the first similar error), and once more just now. Anything else to be done to fix or minimize this error?

    Thanks.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X