Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    London
    Posts
    189

    bizarre error 28 from storage engine

    I am getting error28 from storage engine with every application using mysql. The issue started a few weeks ago so i thought emptying /tmp folder would solve the issue but it didn't . Problem seems to disappear when i reboot the server but problem comes back again after a few hours . I even got tmp partition deleted and recreated
    I enclosed some info from server below








    [email protected] [~]# stat /tmp
    File: `/tmp'
    Size: 81920 Blocks: 162 IO Block: 4096 directory
    Device: 700h/1792d Inode: 2 Links: 4
    Access: (1777/drwxrwxrwt) Uid: ( 0/ root) Gid: ( 0/ root)
    Access: 2009-10-28 22:39:38.000000000 +0000
    Modify: 2009-10-28 22:39:35.000000000 +0000
    Change: 2009-10-28 22:39:35.000000000 +0000

    [email protected] [~]# df -h
    Filesystem Size Used Avail Use% Mounted on
    /dev/sda1 143G 42G 94G 31% /
    tmpfs 502M 0 502M 0% /dev/shm
    /usr/tmpDSK 485M 12M 449M 3% /tmp

    [email protected] [~]# du -hsx /tmp
    1.2M /tmp

    [email protected] [~]# mysqladmin variables | grep -i "log_error"
    | log_error | |

    [email protected] [~]# find /var/lib/mysql -iname "*.err"
    /var/lib/mysql/latte.quicklyweb.net.err

    less /var/lib/mysql/latte.quicklyweb.net.err
    091028 2:13:57 [ERROR] /usr/sbin/mysqld: Disk is full writing '/tmp/STH2JAx1' (Errcode: 28). Waiting for someone to free space... (Expect u
    p to 60 secs delay for server to continue after freeing disk space)
    091028 2:13:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 2:23:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 2:33:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 2:43:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 2:53:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 3:03:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 3:13:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 3:23:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 3:33:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 3:43:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 3:53:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 4:02:57 [ERROR] /usr/sbin/mysqld: Disk is full writing '/tmp/STH2JAx1' (Errcode: 28). Waiting for someone to free space... (Expect u
    p to 60 secs delay for server to continue after freeing disk space)
    091028 4:02:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 4:12:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 4:22:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 4:32:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 4:42:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 4:52:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 5:02:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 5:12:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 5:22:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 5:32:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 5:42:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 5:52:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 6:02:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 6:12:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 6:22:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 6:32:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 6:42:57 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    091028 6:51:19 [Note] /usr/sbin/mysqld: Normal shutdown

    091028 6:51:21 [Warning] /usr/sbin/mysqld: Forcing close of thread 22596 user: 'root'

    091028 6:52:09 [Note] Retrying repair of: './jazzex_nuke1/nuke_bbsearch_wordmatch' with keycache
    091028 6:52:09 InnoDB: Starting shutdown...
    091028 6:52:10 InnoDB: Shutdown completed; log sequence number 0 86741786
    091028 6:52:10 [Note] /usr/sbin/mysqld: Shutdown complete

    091028 06:52:10 mysqld ended

    091028 06:53:39 mysqld started
    091028 6:53:39 InnoDB: Started; log sequence number 0 86741786
    091028 6:53:40 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.0.81-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
    091028 22:51:01 [ERROR] /usr/sbin/mysqld: Disk is full writing '/tmp/STtHQv9e' (Errcode: 28). Waiting for someone to free space... (Expect u
    p to 60 secs delay for server to continue after freeing disk space)
    091028 22:51:02 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
    (END)


    I wonder if anyone had same issue and what the solution was.

  2. #2
    Join Date
    May 2002
    Location
    Moscow
    Posts
    1,490
    your tmp folder has too lees free space and mysql cannot right temporary files there. just increase size of /tmp to 1 Gb or more. As it is tmpfs partition it should not be too hard for realizing...
    Rustelekom LLC Dedicated server since 2002, RIPE NCC member, LIR, AS51168

  3. #3
    Join Date
    May 2003
    Location
    London
    Posts
    189
    But my /tmp directory has only 3% used. So i am not sure if that is the case

Similar Threads

  1. MySQL Error : Got error -1 from storage engine Error Number : 1030
    By Linkdatacenter in forum Programming Discussion
    Replies: 2
    Last Post: 05-25-2008, 04:16 AM
  2. Bizarre Apache Compile Error
    By Dexqt in forum Hosting Security and Technology
    Replies: 10
    Last Post: 09-11-2007, 03:13 AM
  3. SQL error: Got error 28 from storage engine
    By ralphieb in forum Hosting Security and Technology
    Replies: 11
    Last Post: 12-13-2006, 12:35 AM
  4. MySQL storage engine error!
    By IR5 in forum Hosting Security and Technology
    Replies: 5
    Last Post: 04-14-2006, 04:33 PM
  5. JET Database Engine error, Need help
    By kami in forum Web Hosting
    Replies: 1
    Last Post: 02-11-2004, 06:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •