[Maria-discuss] New Question: can't get mariadb to start in Slackware
Hello, A new question has been asked in "MariaDB community" by boomhower182: -------------------------------- After my fresh install it was starting just fine and the only thing I changed was my apache config files to get php to work and then I did some updates and it was still working, then all of a sudden it stopped working. this is what my .err file states.. 140324 16:49:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140324 16:49:05 InnoDB: The InnoDB memory heap is disabled 140324 16:49:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140324 16:49:05 InnoDB: Compressed tables use zlib 1.2.8 140324 16:49:05 InnoDB: Using Linux native AIO 140324 16:49:05 InnoDB: Initializing buffer pool, size = 128.0M 140324 16:49:05 InnoDB: Completed initialization of buffer pool 140324 16:49:05 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140324 16:49:05 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... 140324 16:49:05 InnoDB: Waiting for the background threads to start 140324 16:49:06 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 1597945 140324 16:49:06 [Note] Plugin 'FEEDBACK' is disabled. 140324 16:49:06 [ERROR] mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 140324 16:49:06 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 140324 16:49:06 [ERROR] mysqld: Can't find file: './mysql/host.frm' (errno: 13) 140324 16:49:06 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 140324 16:49:06 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cant-get-mariadb-to-start-in-slackware/
I will endeavour to answer this It looks like something has taken out some of your mysql tables. Did you run a yum update and update the version of MySQL? is there something that could have run the mysql folder it is referring to, probably /var/lib/mysql/mysql. Did your database get copied there for anotehr server that ran an older version of the MySQL software? You can run the mysql_upgrade script as recommended to fix this mysql database tables Cheers Peter On Tue, Mar 25, 2014 at 6:55 AM, AskMonty KB <noreply@askmonty.org> wrote:
Hello,
A new question has been asked in "MariaDB community" by boomhower182: -------------------------------- After my fresh install it was starting just fine and the only thing I changed was my apache config files to get php to work and then I did some updates and it was still working, then all of a sudden it stopped working. this is what my .err file states..
140324 16:49:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140324 16:49:05 InnoDB: The InnoDB memory heap is disabled 140324 16:49:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140324 16:49:05 InnoDB: Compressed tables use zlib 1.2.8 140324 16:49:05 InnoDB: Using Linux native AIO 140324 16:49:05 InnoDB: Initializing buffer pool, size = 128.0M 140324 16:49:05 InnoDB: Completed initialization of buffer pool 140324 16:49:05 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140324 16:49:05 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... 140324 16:49:05 InnoDB: Waiting for the background threads to start 140324 16:49:06 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 1597945 140324 16:49:06 [Note] Plugin 'FEEDBACK' is disabled. 140324 16:49:06 [ERROR] mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 140324 16:49:06 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 140324 16:49:06 [ERROR] mysqld: Can't find file: './mysql/host.frm' (errno: 13) 140324 16:49:06 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 140324 16:49:06 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended --------------------------------
To view or answer this question please visit: http://mariadb.com/kb/en/cant-get-mariadb-to-start-in-slackware/
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- *Peter McLarty* *Data Analyst DBA* Compare The Market P: +61 7 3377 8952 M: +61 4 0209 4238 http://www.comparethemarket.com.au -- Compare The Market is a brand and trading name of Compare The Market (Pty) Ltd (CTM). This email is for the intended addressee and is confidential and subject to copyright. If you are not the intended addressee, confidentiality has not been waived and any use, interference with, or disclosure of this email is unauthorised. If you are not the intended addressee please immediately notify CTM and then delete the email. CTM does not warrant that this email is error or virus free.
participants (2)
-
AskMonty KB
-
Peter Mclarty