Announcement

Collapse
No announcement yet.

Repair failing

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

  • Repair failing

    Can anyone explain to me why when i try to run a repair on my attachment table i get this error.? No matter what I try it just won't budge.

    using: MySql 4.0.17 and PHP 4.3.4

    Table Op Msg_type Msg_text

    web.attachment repair error 12 when fixing table
    web.attachment repair warning Number of rows changed from 31 to 4075
    web.attachment repair status OK


    It seems to repair, but if i check the table right after it is still corrupted.

    Thanx

  • #2
    I think,
    Error 12:
    Not enough space

    So im guessing this is a server error, you should contact your host.

    Comment


    • #3
      Originally posted by Zachery
      I think,
      Error 12:
      Not enough space

      So im guessing this is a server error, you should contact your host.
      It's a dedicated server. The attachements table is 470megs. Trust me I have enough space. Any other ideas? Maybe there is something else i should look at?

      Comment


      • #4
        well i typed perror 12 into my command line for mysql and thats what it gave me :/

        Comment


        • #5
          Ok well if it is not enough space then tell me where is it that I need to increase the space?

          Comment


          • #6
            Error code 12: Cannot allocate memory

            It would appear that the server does not have enough available memory to complete this operation.

            Note also that you need free space equal to roughly 2.5-3 times the size of the table you are repairing in order for the operation to complete.
            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
              Error code 12: Cannot allocate memory

              It would appear that the server does not have enough available memory to complete this operation.

              Note also that you need free space equal to roughly 2.5-3 times the size of the table you are repairing in order for the operation to complete.
              The server has 1GB of Ram, I figure that woudl be more then enough to complete such operation.

              When you say that i need free space 3 times the size of the table that needs to be fixed, where exactly do you mean that space should be alocated. It is a 40 gig drive. Any help is appreciated, i am quite new to this stuff so any guidance is appreciated.

              Comment


              • #8
                When i try to dump the database through shell a few times it gave me this error.

                ./mysqldump: Error 5: Out of memory (Needed 6076256 bytes) when dumping table `attachment` at row: 31

                You sualy a second time aroudn it worked fine.

                Comment


                • #9
                  After changing the key_buffer varable to a higher number it seemed to have fixed.

                  Comment

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