Support » Fixing WordPress » wp_811489daf7_options: Can’t create new tempfile

  • I am getting a “Error establishing a database connection” when I try to load my site. I ran the database repair function and then received the following error: “wp_811489daf7_options: Can’t create new tempfile: ‘./chem_ecol/wp_811489daf7_options.TMD'”. What do I do now?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    It sounds like your database may have run out of space. Check with your host to see if you’ve run into any quotas.

    Thread Starter zgall1

    (@zgall1)

    I am hosting the site. There is still significant space on the server and no other sites on the same server are experiencing any issues.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    How much space is left in your /tmp partition?

    df -h /tmp

    is there about twice the size of the wp_options table?

    Thread Starter zgall1

    (@zgall1)

    When I run that command, I get these results.

    Filesystem Size Used Avail Use% Mounted on
    /dev/vda1 155G 138G 18G 89% /

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    OK, then that’s not it, probably. What’s the size of your wp_options table when viewed from PHPMYADMIN or the command line?

    What happens if you try to repair the database from the command line using “mysqlcheck”?

    Thread Starter zgall1

    (@zgall1)

    The options table is 0B when viewed through PHPMyAdmin.

    This is what I see when I run mysqlcheck.

    chem_ecol.wp_811489daf7_options
    warning  : Table is marked as crashed and last repair failed
    warning  : 1 client is using or hasn't closed the table properly
    error    : Record at pos: 906060 is not remove-marked
    error    : record delete-link-chain corrupted
    error    : Corrupt
    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    It looks to me like you’ll need to restore your database from your most recent backup.

    But first, one more try:

    mysqlcheck --repair chem_ecol wp_811489daf7_options

    Thread Starter zgall1

    (@zgall1)

    This is what I got.

    chem_ecol.wp_811489daf7_options
    error : Can’t create new tempfile: ‘./chem_ecol/wp_811489daf7_options.TMD’
    status : Operation failed

    Can I restore only that table or do I need to restore the entire database?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Well, if the backup isn’t too old, try just the table.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘wp_811489daf7_options: Can’t create new tempfile’ is closed to new replies.