List:General Discussion« Previous MessageNext Message »
From:JD Date:January 28 2009 12:56am
Subject:Re: Mysqld fails to start
View as plain text  
I stopped mysqld.
I removed those logfiles
I did not copy any databe between servers.
I only have one machine. I would not even know
what to copy, as I know nothing about databases.
I have no idea where the .pid and the .err files
came from.

I restarted the daemon, and this is what it wrote into
the /var/messages/mysqd.log

090127 16:54:15 mysqld_safe Starting mysqld daemon with databases from 
/var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090127 16:54:15 [ERROR] Can't open the mysql.plugin table. Please run 
mysql_upgrade to create it.
090127 16:54:15  InnoDB: Log file ./ib_logfile0 did not exist: new to be 
created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090127 16:54:15  InnoDB: Log file ./ib_logfile1 did not exist: new to be 
created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090127 16:54:15  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090127 16:54:15  InnoDB: Started; log sequence number 0 44044
090127 16:54:15 [ERROR] Can't open and lock privilege tables: Table 
'mysql.servers' doesn't exist
090127 16:54:15 [ERROR] Column count of mysql.db is wrong. Expected 22, 
found 20. Created with MySQL 50045, now running 50130. Please use 
mysql_upgrade to fix this error.
090127 16:54:15 [ERROR] mysql.user has no `Event_priv` column at position 29
090127 16:54:15 [ERROR] Cannot open mysql.event
090127 16:54:15 [ERROR] Event Scheduler: An error occurred when 
initializing system tables. Disabling the Event Scheduler.
090127 16:54:15 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.30'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  
MySQL Community Server (GPL) by Remi



Claudio Nanni wrote:
> Hi JD,
> just try a simple thing,
>
> rm /var/lib/mysql/ib_logfile1
> rm /var/lib/mysql/ib_logfile2
>
>
> to remove the innodb log files, sometimes you can have this problems,
> did you copy the database between servers?
> where are the .pid and .err files?
>
> Claudio
>
>
>
>
>
>
> 2009/1/28 JD <jd1008@stripped <mailto:jd1008@stripped>>
>
>     ls -altr /var/lib/mysql
>     total 20548K
>     drwxr-xr-x  2 mysql mysql     4096 2007-12-15 15:36 test/
>     -rw-r--r--  1 mysql mysql  5242880 2007-12-15 15:36 ib_logfile1
>     drwxr-xr-x  2 mysql mysql     4096 2007-12-15 16:10 ampache/
>     -rw-r--r--  1 mysql mysql 10485760 2007-12-17 00:03 ibdata1
>     drwxr-xr-x  2 mysql mysql     4096 2009-01-21 14:12 mysql/
>     srwxrwxrwx  1 mysql mysql        0 2009-01-27 14:13 mysql.sock=
>     -rw-r--r--  1 mysql mysql  5242880 2009-01-27 14:13 ib_logfile0
>     drwxr-xr-x 53 root  root      4096 2009-01-27 14:14 ../
>     drwxr-xr-x  5 mysql mysql     4096 2009-01-27 15:48 ./
>
>
>
>     Claudio Nanni wrote:
>
>         JD,
>         please post the ouput from:
>
>         ls -altr /var/lib/mysql
>
>         thanks
>
>         Claudio
>
>
>
>
>         JD wrote:
>
>             Deamon runs as root.
>             ls -ld /var/lib/mysql/
>             drwxr-xr-x 5 mysql mysql 4096 2009-01-27 10:00 /var/lib/mysql/
>
>             So what other perms does root need?
>
>
>
>
>             Andy Shellam wrote:
>
>                 Hi JD,
>
>                 I believe the error about mysql.plugin is a red
>                 herring - it needs fixing, but it's not the reason
>                 MySQL isn't starting.  The second error is the one
>                 about InnoDB not having access rights to the directory.
>
>                 Check that /var/lib/mysql is writeable by the MySQL
>                 user (usually MySQL.)  Make sure this is done, then
>                 MySQL will start, then you can run mysql_upgrade.
>
>                 HTH,
>
>                 Andy
>
>                 JD wrote:
>
>                     Hello List,
>
>                     mysqld fails to start, and emits the following
>                     error messages in /var/log/mysqld.log
>
>                     090127 10:00:30 mysqld_safe Starting mysqld daemon
>                     with databases from /var/lib/mysql
>                     /usr/libexec/mysqld: Table 'mysql.plugin' doesn't
>                     exist
>                     090127 10:00:30 [ERROR] Can't open the
>                     mysql.plugin table. Please run mysql_upgrade to
>                     create it.
>                     090127 10:00:30  InnoDB: Operating system error
>                     number 13 in a file operation.
>                     InnoDB: The error means mysqld does not have the
>                     access rights to
>                     InnoDB: the directory.
>                     InnoDB: File name ./ibdata1
>                     InnoDB: File operation call: 'open'.
>                     InnoDB: Cannot continue operation.
>                     090127 10:00:30 mysqld_safe mysqld from pid file
>                     /var/run/mysqld/mysqld.pid ended
>
>                     So, I tried to run mysql_upgrade:
>                     # mysql_upgrade
>                     Looking for 'mysql' as: mysql
>                     Looking for 'mysqlcheck' as: mysqlcheck
>                     Running 'mysqlcheck'...
>                     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
>
>                     So, it seems like a chicken and egg thing???
>                     Cannot run mysql_upgrade bcause the server is not
>                     running.
>                     Cannot run the server because I must first run
>                     mysql_upgrade.
>
>                     PS: I know nothing about configuring and setting
>                     up mysql.
>                     Amarok2 needs a running mysqld in order to organize
>                     music tracks collections ... etc.
>
>                     I need help to get mysqld  started and running and
>                     to add users
>                     that are allowed to access and modify their databases.
>
>                     Could someone send me a set of user commands to
>                     get thing going?
>
>                     These are all the "mysql" related packages on my
>                     system:
>                     mysql-5.1.30-1.fc7.remi
>                     mysql-libs-5.1.30-1.fc7.remi
>                     sqlite-3.4.2-1.fc7
>                     libdbi-dbd-pgsql-0.8.1a-2.fc7
>                     sqlite-3.4.2-1.fc7
>                     postgresql-libs-8.2.9-1.fc7
>                     hsqldb-1.8.0.8-1jpp.5.fc7
>                     postgresql-libs-8.2.9-1.fc7
>                     mysql-server-5.1.30-1.fc7.remi
>                     mysqlclient15-5.0.67-1.fc7.remi
>                     mod_auth_mysql-3.0.0-3.1
>                     mysqlclient15-5.0.67-1.fc7.remi
>                     sqlite2-2.8.17-1.fc6
>                     php-pgsql-5.2.8-1.fc7.remi
>                     sqlite-devel-3.4.2-1.fc7
>                     postgresql-python-8.2.9-1.fc7
>                     postgresql-8.2.9-1.fc7
>                     postgresql-server-8.2.9-1.fc7
>                     mono-data-sqlite-1.2.3-5.fc7
>                     mysql-devel-5.1.30-1.fc7.remi
>                     mysqlclient15-devel-5.0.67-1.fc7.remi
>                     mod_auth_pgsql-2.0.3-3
>                     mysql-connector-odbc-3.51.12-2.2
>                     libdbi-dbd-mysql-0.8.1a-2.fc7
>                     mysqlclient15-devel-5.0.67-1.fc7.remi
>                     php-mysql-5.2.8-1.fc7.remi
>
>
>                     Cheers,
>
>                     JD
>
>
>
>
>
>
>     -- 
>     MySQL General Mailing List
>     For list archives: http://lists.mysql.com/mysql
>     To unsubscribe:  
>      http://lists.mysql.com/mysql?unsub=1
>
>

Thread
Mysqld fails to startJD27 Jan
  • Re: Mysqld fails to startBaron Schwartz27 Jan
    • Re: Mysqld fails to startJD27 Jan
  • Re: Mysqld fails to startAndy Shellam27 Jan
    • Re: Mysqld fails to startJD27 Jan
      • Re: Mysqld fails to startClaudio Nanni27 Jan
        • Re: Mysqld fails to startJD28 Jan
          • Re: Mysqld fails to startWalter Heck28 Jan
            • Re: Mysqld fails to startJD28 Jan
          • Re: Mysqld fails to startClaudio Nanni28 Jan
            • Re: Mysqld fails to startJD28 Jan
  • Re: Mysqld fails to startMark Goodge27 Jan
Re: Mysqld fails to startJD28 Jan
  • Re: Mysqld fails to startWalter Heck28 Jan
    • Re: Mysqld fails to startJD28 Jan
      • Re: Mysqld fails to startWalter Heck28 Jan
    • Re: Mysqld fails to startJD28 Jan