Error 12 from storage engine

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • modular person
    New Member
    • Nov 2003
    • 6

    Error 12 from storage engine

    through reading some old posts, i've seen that this error pops up when mysql runs out of memory (for whatever reason). i have a question into my host about it, but i wanted to know if there's anything i'm missing. here are the emails i'm getting:
    Code:
    Database error in vBulletin 2.3.5:
    
    Invalid SQL: SELECT DISTINCT session.userid,username,invisible,usergroupid
    							 FROM session
    							 LEFT JOIN user ON (user.userid=session.userid)
    							 WHERE session.userid>0 AND session.lastactivity>1117212343
    							 ORDER BY invisible ASC, username ASC
    mysql error: Got error 12 from storage engine
    
    mysql error number: 1030
    
    Date: Friday 27th of May 2005 05:00:43 PM
    Script: http://www.domain.net/forum/forum/index.php?s=
    Referer: http://www.domain.net/forum/index.php?s=
    Code:
    Database error in vBulletin 2.3.5:
    
    Invalid SQL: 
    SELECT DISTINCT post.userid,  icon.title as icontitle,icon.iconpath,
    	thread.threadid,thread.title,lastpost, forumid,pollid,open,replycount,postusername,postuserid,
    	lastposter,thread.dateline,views,thread.iconid,notes,thread.visible,sticky,votetotal,attach
    	FROM thread
    	LEFT JOIN icon ON (icon.iconid = thread.iconid)
    	LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '27' AND post.visible = 1)
    	WHERE thread.threadid IN (0,3083,3082,3076,3060,3078,3081,3080,3062,3077,3079,2577,3039,3073,3074,3071,3072,3075,3022,3070,2208,3055,3068,3067,3069,3057,27)
    	ORDER BY sticky DESC, lastpost DESC
    	
    mysql error: Got error 12 from storage engine
    
    mysql error number: 1030
    
    Date: Friday 27th of May 2005 05:13:21 PM
    Script: http://www.domain.net/forum/forum/forumdisplay.php?s=&forumid=1
    Referer:
    one of the confusing things is how the script is at /forum/forum/ when my site is just at /forum/. it makes me think it's not just a memory issue with the host, but i'm not exactly sure what it means.

    thanks for any help.
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    This is a server error:

    System error: 12 = Cannot allocate memory

    I don't really know much more about this.

    The double 'forum' is an artifact of the error reporting and has no significance.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • Zachery
      Former vBulletin Support
      • Jul 2002
      • 59097

      #3
      To the best of my knowleged of dealing with this error once or twice before, the system is out of memory that is allowed for mysql to allocate...

      Chances are mySQLd needs to be restarted or the server does as well...

      Comment

      • modular person
        New Member
        • Nov 2003
        • 6

        #4
        thanks for the explanation on the double forum thing, that was really the main thing that made me want to check here as well.

        one of the admins at the host explained an error 12 from a different piece of software once before:
        Sure the error is an out of memory error, but it's the query that does it. Not the lack of RAM on a server that has 4GBs of it. And according to the log, the query ramped up to 2.6GB of RAM before it was killed off. A little query shouldn't do that.

        Comment

        • Zachery
          Former vBulletin Support
          • Jul 2002
          • 59097

          #5
          I very highly doubt there is any chance that query took 2GB of memory to execute...

          The only other thing I could think of for that error would be a heap error but since this wasn't an update or insert It wouldn't be that..

          who is your host?

          Comment

          • George L
            Former vBulletin Support
            • May 2000
            • 32996
            • 3.8.x

            #6
            can you post your server info asked at especially PHP and MySQL versions used.. it could be an out dated mysql version which has reported such a bug before

            Do you have innodb tables enabled ?
            :: Always Back Up Forum Database + Attachments BEFORE upgrading !
            :: Nginx SPDY SSL - World Flags Demo [video results]
            :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

            Comment

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