maria-discuss team mailing list archive

[Peter Mclarty <peter.mclarty@xxxxxxxxxxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> 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.