MySQL-related problem

Discussion in 'Server Operation' started by destinedjagold, Oct 5, 2012.

  1. destinedjagold

    destinedjagold New Member

    I don't understand what happened. I haven't touched the server in a while, and when I typed the code
    Code:
    service mysqld start
    CentOS 6.3 replies with an
    Code:
    MySQL Daemon failed to start.
    Starting mysqld: [FAILED]
    I looked though the log files, and it gave me this...
    Code:
    121005 18:05:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    121005 18:05:42 [Note] Plugin 'FEDERATED' is disabled.
    /usr/libexec/mysqld: Table 'plugin' is read only
    121005 18:05:42 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    121005 18:05:42 InnoDB: The InnoDB memory heap is disabled
    121005 18:05:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    121005 18:05:42 InnoDB: Compressed tables use zlib 1.2.3
    121005 18:05:42 InnoDB: Using Linux native AIO
    /usr/libexec/mysqld: Can't create/write to file '/tmp/ibwnGp95' (Errcode: 13)
    121005 18:05:43  InnoDB: Error: unable to create temporary file; errno: 13
    121005 18:05:43 [ERROR] Plugin 'InnoDB' init function returned error.
    121005 18:05:43 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    121005 18:05:43 [ERROR] Unknown/unsupported storage engine: InnoDB
    121005 18:05:43 [ERROR] Aborting
    I have been searching around Google for a day now, and every single solution I land upon, it didn't help me with my problem.

    Additional note...
    - typing mysql_upgrade results in this...
    Code:
    Looking for 'mysql' as: mysql
    Looking for 'mysqlcheck' as: mysqlcheck
    Running 'mysqlcheck with default connection arguments
    mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
    FATAL ERROR: Upgrade failed
    Another note...
    - the latest version of MySQL is version 5.5.28. Is there a way to let CentOS download and install MySQL version 5.5.25* ?

    Any help would be greatly appreciated. Thank you.
     
  2. falko

    falko Super Moderator

    Can you run
    Code:
    df -h
    to check if any of your partitions is full?
     
  3. destinedjagold

    destinedjagold New Member

    Thank you for the reply.
    And yes, I can check the partitions, but none of them are full. None are even beyond 20% of usage as of this moment.
     
  4. falko

    falko Super Moderator

    Can you post the output of
    Code:
     ls -la /tmp/
    ?
     
  5. destinedjagold

    destinedjagold New Member

    Thanks for the reply, and yes, here it is.
    Quite long though...

    Code:
    total 354772
    drwxrwxrwx.  8 root       root            4096 Oct  9 09:54 .
    drwx------. 28 apache     root            4096 Oct  9 09:54 ..
    -rw-r--r--.  1 root       root           14496 May 10 23:04 epel-release-6-7.noarch.rpm
    -rw-r--r--   1 root       root           14496 May 10 23:04 epel-release-6-7.noarch.rpm.1
    -rw-r--r--   1 root       root           14496 May 10 23:04 epel-release-6-7.noarch.rpm.2
    drwx------.  2 devuser    devuser         4096 Aug 17 12:05 .esd-500
    drwxrwxrwt   2 root       root            4096 Oct  9 09:54 .ICE-unix
    drwxr-xr-x.  8 root       root            4096 Jun 18 22:31 ispconfig3_install
    -rw-r--r--   1 root       root         2711250 Jun 18 22:31 ISPConfig-3-stable.tar.gz
    -rw-r--r--   1 root       root         2711250 Jun 18 22:31 ISPConfig-3-stable.tar.gz.1
    -rw-r--r--   1 root       root       357283840 Oct  4 18:36 mysql-5.5.2-m2-linux-i686-glibc23.tar
    drwxr-xr-x   6 root       root            4096 Oct  3 17:56 mysql_backup_oct3
    drwx------.  2 gdm        gdm             4096 Oct  2 09:14 pulse-DkNw0mZCgMcC
    -rw-r--r--   1 root       root           12700 Nov 13  2010 rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
    -rw-r--r--   1 root       root           12700 Nov 13  2010 rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm.1
    -r--r--r--   1 root       root              11 Oct  9 09:54 .X0-lock
    drwxrwxrwt   2 root       root            4096 Oct  9 09:54 .X11-unix
    -rw-------   1 root       root             303 Aug 31 12:01 yum_save_tx-2012-08-31-12-01QAuEn6.yumtx
    -rw-------   1 root       root             299 Sep 10 11:02 yum_save_tx-2012-09-10-11-02VjE7Sv.yumtx
    -rw-------   1 root       root             289 Sep 12 18:11 yum_save_tx-2012-09-12-18-11cqsiXI.yumtx
    -rw-------   1 root       root             304 Sep 13 12:39 yum_save_tx-2012-09-13-12-39bk4ED3.yumtx
    -rw-------   1 root       root            2841 Sep 20 14:32 yum_save_tx-2012-09-20-14-32E3Xg9z.yumtx
    -rw-------   1 root       root             300 Sep 20 16:14 yum_save_tx-2012-09-20-16-14kioNyQ.yumtx
    -rw-------   1 root       root           11322 Sep 21 11:16 yum_save_tx-2012-09-21-11-16Tl7fC8.yumtx
    -rw-------   1 root       root             299 Sep 21 13:02 yum_save_tx-2012-09-21-13-0222AwND.yumtx
    -rw-------   1 root       root             516 Sep 21 15:08 yum_save_tx-2012-09-21-15-08R9GxT6.yumtx
    -rw-------   1 root       root             516 Sep 21 15:10 yum_save_tx-2012-09-21-15-10YDd07F.yumtx
    -rw-------   1 root       root             516 Sep 21 15:13 yum_save_tx-2012-09-21-15-13sB_26z.yumtx
    -rw-------   1 root       root            1451 Sep 21 15:16 yum_save_tx-2012-09-21-15-16HXR_sp.yumtx
    -rw-------   1 root       root             516 Sep 21 15:17 yum_save_tx-2012-09-21-15-17ljS4V5.yumtx
    -rw-------   1 root       root           56199 Sep 21 15:22 yum_save_tx-2012-09-21-15-22tNzfmH.yumtx
    -rw-------   1 root       root            8131 Sep 28 11:56 yum_save_tx-2012-09-28-11-56RwBhCi.yumtx
    -rw-------   1 root       root            8343 Oct  3 16:22 yum_save_tx-2012-10-03-16-22yNzUUd.yumtx
    -rw-------   1 root       root            8343 Oct  3 16:31 yum_save_tx-2012-10-03-16-31RuiN93.yumtx
    -rw-------   1 root       root            8343 Oct  3 16:32 yum_save_tx-2012-10-03-16-32uOjqn2.yumtx
    -rw-------   1 root       root            8283 Oct  3 16:51 yum_save_tx-2012-10-03-16-51yGBWpl.yumtx
    -rw-------   1 root       root            8343 Oct  3 16:52 yum_save_tx-2012-10-03-16-52_0COYu.yumtx
    -rw-------   1 root       root            8307 Oct  3 16:55 yum_save_tx-2012-10-03-16-55ZmuVSv.yumtx
    -rw-------   1 root       root            8343 Oct  3 17:05 yum_save_tx-2012-10-03-17-05xDzPMJ.yumtx
    -rw-------   1 root       root            8307 Oct  3 17:18 yum_save_tx-2012-10-03-17-18eWeaxV.yumtx
    -rw-------   1 root       root           14991 Oct  3 17:31 yum_save_tx-2012-10-03-17-31E6pP33.yumtx
    -rw-------   1 root       root            8343 Oct  4 10:27 yum_save_tx-2012-10-04-10-27oVQjbA.yumtx
    -rw-------   1 root       root            8343 Oct  4 10:45 yum_save_tx-2012-10-04-10-452GW5ka.yumtx
    -rw-------   1 root       root            8307 Oct  4 12:01 yum_save_tx-2012-10-04-12-01WnzpoY.yumtx
    -rw-------   1 root       root           14991 Oct  4 12:02 yum_save_tx-2012-10-04-12-027MBN6v.yumtx
    -rw-------   1 root       root            8283 Oct  4 15:45 yum_save_tx-2012-10-04-15-45HTNkJA.yumtx
    -rw-------   1 root       root             291 Oct  4 16:31 yum_save_tx-2012-10-04-16-31eCnxtg.yumtx
    -rw-------   1 root       root            8283 Oct  4 18:21 yum_save_tx-2012-10-04-18-21DeCo1h.yumtx
    -rw-------   1 root       root            8283 Oct  4 18:25 yum_save_tx-2012-10-04-18-25xEeehY.yumtx
    -rw-------   1 root       root            8283 Oct  4 18:26 yum_save_tx-2012-10-04-18-26Ce2_pV.yumtx
    -rw-------   1 root       root             299 Oct  5 12:35 yum_save_tx-2012-10-05-12-35MyY3Rz.yumtx
    -rw-------   1 root       root             977 Oct  5 12:35 yum_save_tx-2012-10-05-12-35TDvVRy.yumtx
    -rw-------   1 root       root             995 Oct  5 13:56 yum_save_tx-2012-10-05-13-56qbqbCD.yumtx
    -rw-------   1 root       root             456 Oct  5 13:56 yum_save_tx-2012-10-05-13-56yrfhyR.yumtx
    -rw-------   1 root       root             890 Oct  5 14:00 yum_save_tx-2012-10-05-14-00BpI1J_.yumtx
    -rw-------   1 root       root            1548 Oct  5 14:02 yum_save_tx-2012-10-05-14-02AZmN9r.yumtx
    -rw-------   1 root       root             757 Oct  5 14:03 yum_save_tx-2012-10-05-14-03VN72l7.yumtx
    -rw-------   1 root       root             757 Oct  5 14:08 yum_save_tx-2012-10-05-14-08UIfLnN.yumtx
    -rw-------   1 root       root             522 Oct  5 14:11 yum_save_tx-2012-10-05-14-11wOufX9.yumtx
    -rw-------   1 root       root            3138 Oct  5 14:13 yum_save_tx-2012-10-05-14-13OUvUsz.yumtx
    -rw-------   1 root       root             634 Oct  8 12:50 yum_save_tx-2012-10-08-12-507pu1F7.yumtx
    -rw-------   1 root       root             616 Oct  8 12:55 yum_save_tx-2012-10-08-12-55x6nAlq.yumtx
    -rw-------   1 root       root             990 Oct  8 12:57 yum_save_tx-2012-10-08-12-57tfkVG2.yumtx
    -rw-------   1 root       root            2321 Oct  8 12:58 yum_save_tx-2012-10-08-12-58fbDbqH.yumtx
    -rw-------   1 root       root            1636 Oct  8 12:58 yum_save_tx-2012-10-08-12-58j1XSwY.yumtx
    -rw-------   1 root       root            2346 Oct  8 12:58 yum_save_tx-2012-10-08-12-58ZlMesz.yumtx
    -rw-------   1 root       root            2321 Oct  8 13:00 yum_save_tx-2012-10-08-13-007CNuna.yumtx
    -rw-------   1 root       root             990 Oct  8 13:00 yum_save_tx-2012-10-08-13-00PqUhTT.yumtx
    -rw-------   1 root       root             949 Oct  8 15:18 yum_save_tx-2012-10-08-15-18DNzsyi.yumtx
    -rw-------   1 root       root             585 Oct  8 15:33 yum_save_tx-2012-10-08-15-33hu4El1.yumtx
    -rw-------   1 root       root             585 Oct  8 15:33 yum_save_tx-2012-10-08-15-33ztJa1Z.yumtx
    -rw-------   1 root       root             586 Oct  8 15:56 yum_save_tx-2012-10-08-15-56oZDvnT.yumtx
    -rw-------   1 root       root             891 Oct  8 15:56 yum_save_tx-2012-10-08-15-56y1avnT.yumtx
    -rw-------   1 root       root             586 Oct  8 16:06 yum_save_tx-2012-10-08-16-06M6cEFl.yumtx
    -rw-------   1 root       root             586 Oct  8 16:40 yum_save_tx-2012-10-08-16-402COFDC.yumtx
    -rw-------   1 root       root             522 Oct  8 16:47 yum_save_tx-2012-10-08-16-47hx578d.yumtx
    -rw-------   1 root       root             522 Oct  8 16:47 yum_save_tx-2012-10-08-16-47KtluB1.yumtx
     
  6. falko

    falko Super Moderator

    Your / directory is owned by the user apache and has 700 permissions which is wrong. For me it looks like this:

    Code:
    drwxr-xr-x 22 root  root      4096 Oct  8 17:00 ..
    Did you do a chmod and chown on the / directory?
     
  7. destinedjagold

    destinedjagold New Member

    Thanks for the reply, and for your questions, yes, I think I did.
    Should I return it to root? If so, what would be the proper code to use?

    Thanks~

    ---edit---

    Okay, so I used
    Code:
    chmod 755 /
    and now it displays this...
    Code:
    total 354844
    drwxrwxrwx.  8 root       root            4096 Oct 10 11:22 .
    drwxr-xr-x.  28 root       root            4096 Oct 10 09:34 ..
    Is this okay now?
    I still cannot run MySQL...
    Code:
    MySQL Daemon failed to start.
    Starting mysqld: [FAILED]
    ---edit 2---

    Okay, I think I have fixed it. MySQL will now start when I type
    Code:
    service mysqld start
    .
    I think I should post here the things I did, for future reference?

    The first thing I did was reinstall both mysql and mysql-server through yum.
    And then, after reinstalling was done, I typed these following codes...
    Code:
    chown -R mysql.mysql /var/lib/mysql
    Code:
    su - mysql
    I am not sure if those set of codes really fixed it, but those are the ones I used, and the MySQL Daemon error message is no longer appearing, and MySQL is starting with no problems.
     
    Last edited: Oct 10, 2012

Share This Page