Can’t repair wp_options table: Not enough memory for blob

  • Resolved bsdahl

    (@bsdahl)


    8 years, 5 months ago

    My WordPress database crashed last night and I can’t seem to repair it using the automatic options. I have a 4 day old backup, so its not the end of the world to restore, but before I tried that I was wondering if anyone has had this issue before and knows how to solve it? I believe the database crashed when the server ran out of memory and the mysqld crashed.

    mysql> repair table wp_options
    -> ;
+----------------------+--------+----------+-------------------------------------------------------+
| Table                | Op     | Msg_type | Msg_text                                              |
+----------------------+--------+----------+-------------------------------------------------------+
| wordpress.wp_options | repair | info     | Found block with too small length at 21372; Skipped   |
| wordpress.wp_options | repair | info     | Wrong block with wrong total length starting at 25512 |
| wordpress.wp_options | repair | error    | Not enough memory for blob at 26032 (need 1408528488) |
| wordpress.wp_options | repair | info     | Found block with too small length at 21372; Skipped   |
| wordpress.wp_options | repair | info     | Wrong block with wrong total length starting at 25512 |
| wordpress.wp_options | repair | error    | Not enough memory for blob at 26032 (need 1408528488) |
| wordpress.wp_options | repair | status   | Operation failed                                      |
+----------------------+--------+----------+-------------------------------------------------------+
    • This topic was modified 8 years, 5 months ago by bsdahl.
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Can’t repair wp_options table: Not enough memory for blob’ is closed to new replies.