Announcement

Collapse
No announcement yet.

Database error in vBulletin 5.1.0

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

  • 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.

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

    Comment


    • #3
      Ok, Thanks. We have truncate the suggested cache tables.

      Is this a common issue? Why is this happening?

      Comment


      • #4
        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?

        Comment


        • #5
          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.

          Comment


          • #6
            This has no fix?

            Comment


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

              Please don't PM or VM me for support - I only help out in the threads.
              vBulletin Manual & vBulletin 4.0 Code Documentation (API)
              Want help modifying your vbulletin forum? Head on over to vbulletin.org
              If I post CSS and you don't know where it goes, throw it into the additional.css template.

              W3Schools <- awesome site for html/css help

              Comment


              • #8
                I am getting this with vb 5.2.4:

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


                Comment

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