Announcement

Collapse
No announcement yet.

mysql error: Got error 28 from storage engine - mysql error number: 1030

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

  • mysql error: Got error 28 from storage engine - mysql error number: 1030

    Database error in vBulletin 3.0.6:

    Invalid SQL:
    SELECT session.userid, user.username, user.displaygroupid, user.usergroupid, (user.options & 512) AS invisible,userfield.field23
    FROM session AS session
    LEFT JOIN user AS user USING (userid)
    LEFT JOIN usergroup AS usergroup ON(usergroup.usergroupid=user.usergroupid)
    LEFT JOIN userfield AS userfield ON(userfield.userid=user.userid)
    WHERE session.lastactivity > 1115705709
    ORDER BY usergroup.orderid DESC, user.username ASC

    mysql error: Got error 28 from storage engine

    mysql error number: 1030

    Date: Tuesday 10th of May 2005 08:30:09 AM
    Script: showthread.php?goto=lastpost&t=996
    This goes for every connection to my board, anyone have any idea whats up with that? Ive been receiving em for almost 6 hours now (started when I was asleep).
    A bullet may have your name on it, but shrapnel is addressed "to whom it may concern"

  • #2
    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. You need to shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on disk space and either add more space or free up some.
    Bugdar: PHP bug tracking software that is beautiful, fast, and robust.

    Comment


    • #3
      During viewing? Then how come I can view it properly from phpmyadmin, and the phpbb2. thingy (that latest beta thing) board isnt having any problems?
      A bullet may have your name on it, but shrapnel is addressed "to whom it may concern"

      Comment


      • #4
        I have just started to get this same error, and our server has all of the space in the world.

        I have never saw these errors before, they just started happening last night. First I was trying to send a PM, and got the message. Now when I click to go to my PMs, the error comes up and I can't access them at all. So far nothing else I click will produce this error.

        Database error in vBulletin 3.0.7:

        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=3 AND pm.folderid=0
        ORDER BY pmtext.dateline DESC
        LIMIT 0, 50

        mysql error: Got error -1 from storage engine

        mysql error number: 1030

        EDIT: I am including proof that the server is fine.
        Attached Files
        Last edited by ceska; Tue 10th May '05, 5:19am.

        Comment


        • #5
          Getting it now in AdminCP.

          Database error in vBulletin 3.0.7:

          Invalid SQL:
          SELECT setting.*, settinggroup.grouptitle
          FROM settinggroup AS settinggroup
          LEFT JOIN setting AS setting USING(grouptitle)
          WHERE settinggroup.displayorder <> 0
          ORDER BY settinggroup.displayorder, setting.displayorder

          mysql error: Got error -1 from storage engine

          mysql error number: 1030



          We have PHP 4.3.11 (cli) (built: Apr 17 2005 23:59:16)
          MySQL 4.1.11

          Comment


          • #6
            I am going to shut down our forum, it is getting worse by the minute. Now new posts aren't recording in New Posts...

            Oh .. wait. I can't. Admin CP "vBulletin Options" doesn't work anymore. I will have to slip in an index file.

            Comment


            • #7
              oddly enough, it seems to have fixed itself (it was working again a few hours after I got home from school). And I am 100% positive the host hasn't been on yet so no clue as to whats going on...
              A bullet may have your name on it, but shrapnel is addressed "to whom it may concern"

              Comment


              • #8
                What I just found is that someone upgraded our server last night from MySQL 4 to 4.1. This is the problem! Slowly during the night the errors started surfacing.

                My next question would be, does this mean our database is messed up?
                The last backup we have is from 1 AM, and should be ok, I guess. The most errors happened in just the past hour, when the PM inbox returned an error, when I learned Admin CP vBulletin Options would not work, and when new posts stopped recording.

                I doubt we both have the same problem though (a MySQL upgrade) or that would just be a really strange coincidence.

                Comment


                • #9
                  MySQL version 4.1.11-standard

                  Dont know when it was upgraded though.

                  Note to self: bug the host
                  A bullet may have your name on it, but shrapnel is addressed "to whom it may concern"

                  Comment


                  • #10
                    @ceska

                    You would probably get better support/responses if you opened your own thread instead of "hijacking" someone elses thread.

                    You error message is NOT the same, you are getting an error -1 and not 28.
                    Want to take your board beyond the standard vBulletin features?
                    Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

                    Comment


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

                      Comment


                      • #12
                        The -1 error is most likely database corruption due to the earlier out of space error. If you have fixed the out of space condition, then you should now repair and optimize the database.
                        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


                        • #13
                          99.99% is because of the /tmp directory is full, so if anyone ever faces this, this is the cause! I just found out that's what our problem was today.
                          Where does it end?

                          Comment


                          • #14
                            How do I check the /tmp file & how to I empty it?

                            Comment


                            • #15
                              Do you have a dedicated that you manage? If so, I would just check the disk usage, and what file(s)/folder(s) may be causing it by using the du command If you need to know more about du go here: http://www.wtfnix.com/2009/01/man-du/

                              Hope this helps.
                              Where does it end?

                              Comment

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