Announcement

Collapse
No announcement yet.

mysql error: Got error 28 from table handler (error number 1030)

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

  • mysql error: Got error 28 from table handler (error number 1030)

    Any ideas?

    Database error in vBulletin 3.0.4:
    Invalid SQL:
    SELECT pm.*, pmtext.*
    , icon.title AS icontitle, icon.iconpath
    FROM pm AS pm
    LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
    LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
    WHERE pm.userid=1 AND pm.folderid=0
    ORDER BY pmtext.dateline DESC
    LIMIT 0, 50

    mysql error: Got error 28 from table handler
    mysql error number: 1030
    Date: Monday 01st of August 2005 09:17:11 PM
    Script: http://www.sitename.com/board/private.php?

  • #2
    Resolved.

    tmp space filled. had to be cleared and sized up.

    Comment


    • #3
      yup error 28 = disk space lacking can occur in mysql data partition or tmp directory that mysql uses
      :: 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


      • #4
        What? I'm having this happen to me right now, how do I resolve it? But can you put it in simple terms?

        Comment


        • #5
          Error code 28: No space left on device

          One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums (if you can) and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.
          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


          • #6
            I have the same error

            Here is the message

            Database error in vBulletin 3.0.6:
            Invalid SQL:
            SELECT session.userid, username, usergroupid, (user.options & 512) AS invisible,
            IF(displaygroupid = 0, user.usergroupid, displaygroupid) AS displaygroupid
            FROM session AS session
            LEFT JOIN user AS user USING (userid)
            WHERE session.lastactivity > 1128427009
            ORDER BY invisible ASC, username ASC

            mysql error: Got error 12 from table handler
            mysql error number: 1030
            Date: Tuesday 04th of October 2005 07:11:49 AM
            Script: http://www.futuresprinting.com/


            Please help. My site has been down for a day now. It has 1500 members.

            Steve

            Comment


            • #7
              Main page

              I just noticed that the forums work OK and its only the main index page giving trouble look at http://www.futuresprinting.com/forum/index.php?

              Its fine.

              But the main home page is a problem

              Comment


              • #8
                Originally posted by oztrack
                Here is the message

                Database error in vBulletin 3.0.6:
                Invalid SQL:
                SELECT session.userid, username, usergroupid, (user.options & 512) AS invisible,
                IF(displaygroupid = 0, user.usergroupid, displaygroupid) AS displaygroupid
                FROM session AS session
                LEFT JOIN user AS user USING (userid)
                WHERE session.lastactivity > 1128427009
                ORDER BY invisible ASC, username ASC

                mysql error: Got error 12 from table handler
                mysql error number: 1030
                Date: Tuesday 04th of October 2005 07:11:49 AM
                Script: http://www.futuresprinting.com/


                Please help. My site has been down for a day now. It has 1500 members.

                Steve
                different error number yours means

                perror 12
                System error: 12 = Cannot allocate memory
                start a new thread with the following info asked at http://www.vbulletin.com/forum/showthread.php?t=70117
                :: 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


                • #9
                  I am getting error # 28 also. How can I clear the tmp file?

                  Comment


                  • #10
                    Originally posted by dragginblazer
                    I am getting error # 28 also. How can I clear the tmp file?
                    most likely the tmp file isn't exactly full after the error only during the the running of the query

                    your tmp file is usually empty and mysql needs at least 3x times the free space on tmp as the largest sized mysql database table you have

                    take a read of http://dev.mysql.com/doc/refman/5.0/...ary-files.html

                    easiest thing to do is set a a tmpdir path for mysql on a partition with more disk space

                    i.e. in ssh telnet type

                    df -h

                    look at your disk usage per partition

                    usually /home is the one with most free disk space

                    so

                    create a new directory at /home/mysqltmp

                    then in /etc/my.cnf under [mysqld]

                    add

                    [mysqld]
                    tmpdir = /home/mysqltmp



                    and restart mysql server
                    :: 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...
                    X