maria-discuss team mailing list archive

[Frank Röhm <francwalter@xxxxxxx>]

> Am 20.12.2013 um 20:28 schrieb Reindl Harald:
> ...
> But I found in the syslog since yesterday noon every 2 minutes (!!!)
> these entries:
> 
> Dec 19 12:02:12 myserver kernel: [1315576.363594] init: mysql main
> process (9025) terminated with status 1
> Dec 19 12:02:12 myserver kernel: [1315576.363659] init: mysql main
> process ended, respawning
> Dec 19 12:02:12 myserver /etc/mysql/debian-start[10200]: Upgrading MySQL
> tables if necessary.
> Dec 19 12:02:12 myserver /etc/mysql/debian-start[10203]:
> /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
> Dec 19 12:02:12 myserver /etc/mysql/debian-start[10203]: Looking for
> 'mysql' as: /usr/bin/mysql
> Dec 19 12:02:12 myserver /etc/mysql/debian-start[10203]: Looking for
> 'mysqlcheck' as: /usr/bin/mysqlcheck
> Dec 19 12:02:12 myserver /etc/mysql/debian-start[10203]: This
> installation of MySQL is already upgraded to 5.5.34-MariaDB, use --force
> if you still need to run mysql_upgrade
> Dec 19 12:02:12 myserver /etc/mysql/debian-start[10214]: Checking for
> insecure root accounts.
> Dec 19 12:02:12 myserver /etc/mysql/debian-start[10219]: Triggering
> myisam-recover for all MyISAM tables
> 
> (I replaced my server's name with myserver)
> 
> Do I understand this right, that every 2 minutes mysql server is
> crashing (terminated with status 1)???
> I don't find a hint in the syslog what could crash mysql.
> 
> And to restart mysql (service mysql restart) it takes about a minute!
> This seems unnormal too.
> I think I have a problem.
> 

Oh my god!
I my trouble I just restarted the server (I know this "trick" from
Windows OS) and look here! Now it is working!!!

No more errors when I questionize the EVENT table in information_schema,
no more error entries like above in syslog.

Heurekah!

Uff.

Thanks for the helps.

franks