Announcement

Collapse
No announcement yet.

You broke my forum!

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • You broke my forum!

    I tried running a database optimize procedure from the admincp, and your software broke the database!

    That should not be allowed to happen.

    :
    PhotoCamel | PoetryCircle | KissMyCamel

  • #2
    Why did you run the table optimizer?
    anders | vbulletin team | check out the new vbulletin facebook app
    Proudly vBulletin'ing since 2001
    Please be my friend!
    http://www.twitter.com/inetskunkworks
    vBulletin Performance Articles:
    Click here to read

    Comment


    • #3
      Saying its broken doesnt really give anyone any kind of scope to try and help you. Whats the error you are getting ? have you tried logging in to cpanel / MySQL and repairing/optimising the database again incase a table crashed while you were optimising ?>
      The opinions expressed in forum posts are my own personal opinions and do not represent any companies that i am associated with.

      Comment


      • #4
        In addition; the error that you are receiving is "User photocam_admin already has more than 'max_user_connections' active connections" ; which means that the optimization task is probably still running and locking the database - which is why you are running out of the connections. It needs to finish.
        anders | vbulletin team | check out the new vbulletin facebook app
        Proudly vBulletin'ing since 2001
        Please be my friend!
        http://www.twitter.com/inetskunkworks
        vBulletin Performance Articles:
        Click here to read

        Comment


        • #5
          FYI the Tasks in the maintenance area should only be run if you have been told to, or know why you need to run them. Some functions in mysql, like repair and optimize can damage the forum.

          Comment


          • #6
            Originally posted by Zachery View Post
            FYI the Tasks in the maintenance area should only be run if you have been told to, or know why you need to run them. Some functions in mysql, like repair and optimize can damage the forum.
            Well thanks a lot! How is anyone supposed to know that from you admincp?
            PhotoCamel | PoetryCircle | KissMyCamel

            Comment


            • #7
              Its just a fact of life, mysql doesn't even tell you, but it is possible.

              LEt the mysql operations finish and your forums should be fine.

              Comment


              • #8
                Originally posted by IBxAnders View Post
                Why did you run the table optimizer?
                Because clicking on "last post" wasn't taking the user to the last post! I figured some database was messed up.
                PhotoCamel | PoetryCircle | KissMyCamel

                Comment


                • #9
                  Originally posted by Zachery View Post
                  Its just a fact of life, mysql doesn't even tell you, but it is possible.

                  LEt the mysql operations finish and your forums should be fine.
                  Well, cpanel is showing that Disk /dev/sda7 (/tmp) is at 100%
                  PhotoCamel | PoetryCircle | KissMyCamel

                  Comment


                  • #10
                    That is something you'd need to contact your webhost about. That is very bad

                    Comment


                    • #11
                      Originally posted by Zachery View Post
                      That is something you'd need to contact your webhost about. That is very bad
                      Well, I'll tell you what's very bad. What's very bad is your software. You have an option to optimize tables, but clicking it holds the potential to destroy six years worth of work. You guys suck. Your software sucks, and it sucks more with every release.
                      PhotoCamel | PoetryCircle | KissMyCamel

                      Comment


                      • #12
                        Correction, YOU broke your forum. As said above, that option shouldn't have even been run unless you were told to, or you know what you're doing.

                        Comment


                        • #13
                          That is a mysql function, not a function in vBulletin. We have it there, and if you know when and why you should use it, its fine.

                          http://dev.mysql.com/doc/refman/5.1/...ize-table.html
                          http://dev.mysql.com/doc/refman/5.1/...air-table.html

                          Right now, your issue is that your webhosts tmp partition is filled, which means mysql (and thus vBulletin) cannot operate. You need to get your webhost to fix the issue with tmp being full. Once they do mysql can finish its stuff, and your forum will come back.

                          I would tell you that most forums that run MySQL would have the same repair/optimize features in their software.

                          Comment


                          • #14
                            Okay, it's fixed. I'll not use that "feature" again.

                            Here's a plug for Hostgator, which got us up and running again on our dedicated server.
                            PhotoCamel | PoetryCircle | KissMyCamel

                            Comment


                            • #15
                              Originally posted by jdougher View Post
                              Well, I'll tell you what's very bad. What's very bad is your software. You have an option to optimize tables, but clicking it holds the potential to destroy six years worth of work. You guys suck. Your software sucks, and it sucks more with every release.
                              So, you ran an option you dont understand, in the hope it might fix something it wont, and then try to blame its effects on "the software" ?

                              Not entirely reasonable.
                              Baby, I was born this way

                              Comment

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