Announcement

Collapse
No announcement yet.

Recent mysql outage = Annoying Problem

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

  • Recent mysql outage = Annoying Problem

    Well the hard drive on the server I am on got full and MYSQL Crashed, my site was down for about 20 hours. When it returned there was a weird error when someone tried to post a thread but I ran the repair script in the admin panel and that fixed it.

    However now there are constant emails of MYSQL errors sent to me even though users aren't experiencing a problem.

    Here are the two errors I have received so far.

    Invalid SQL: SELECT threadid , COUNT(*) AS views FROM threadviews GROUP BY threadid
    mysql error: Can't find file: 'threadviews.MYD' (errno: 2)

    mysql error number: 1017

    and

    Invalid SQL: SELECT attachmentid, COUNT(*) AS views FROM attachmentviews GROUP BY attachmentid
    mysql error: Can't find file: 'attachmentviews.MYD' (errno: 2)

    mysql error number: 1017

    Again the user when they browse the forum post threads view attachments encounter no error what so ever. However I am emailed with the above.

    I do recall that when I ran the repair script that the MyAtachments.MYD wasn't found and I beleive PostSomething.MYD (don’t remember the name) said it had Crashed.



    Can anyone help?

  • #2
    http://www.vbulletin.com/forum/showp...98&postcount=4 Give that a shot

    Comment


    • #3
      Also one more problem that I have been having since we upgraded from 3.0 to 3.0.3

      The admin Panel just shows the Navigation and when I click on an option it opens a new window. If there is a fix for that it be great.

      Normally I would ask my PHP guy but he was forced to marry some chick and hasn't been on in a while.

      Comment


      • #4
        Originally posted by Zachery
        Will try that in a few, I want to back up my database first before I do anything and I can't seem to get it done am going to have to bother my host again.

        Will let you know if it works.

        Comment


        • #5
          I am sorry for bringing my old thread back to life but I still need help with this problem.

          I have not done what Zachery said to do because I wanted to back up the database first. However when ever we try to do the backup it fails after about 5MB.

          When I look at the tables in phpMyAdmin it says two tables are in use. The same two tables that are causing the MYSQL errors and not letting attachment views and threrad views not to update.

          I am really scared to do what Zachery with out backing up the database. Is there another option or do I need to cross my fingers and do what Zachery said?

          Below is what is shown in phpMyAdmin
          attachmentviews in use
          threadviews in use

          Comment


          • #6
            The only reliable method of backing up a database is with shell access via telnet or ssh. Please see the instructions here:

            http://www.vbulletin.com/docs/html/m...nce_ssh_backup
            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


            • #7
              Originally posted by Steve Machol
              The only reliable method of backing up a database is with shell access via telnet or ssh. Please see the instructions here:

              http://www.vbulletin.com/docs/html/m...nce_ssh_backup
              Ok thanks , will ask my host to do it for me then since I had trouble with it.

              Comment


              • #8
                Thoughs tables are not insanely vital and only hold temporary data just fyi

                Comment


                • #9
                  Originally posted by Zachery
                  Thoughs tables are not insanely vital and only hold temporary data just fyi
                  Yeah I know but I wan't the threadviews to display properly, the way it is now makes the forum seem to be less active then what it is.

                  BTW What could of caused this problem? So that I can explain it to my host and see if we can prevent it from happening again in the future.

                  Comment


                  • #10
                    This was an occasional problem with earlier versions of vB. You should upgrade to 3.0.6.
                    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

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