| 1 |
>> mysql-5.1.51 crashed recently and needed to be restarted. This |
| 2 |
>> doesn't happen often with mysql but does from time to time. Is this |
| 3 |
>> part of life with mysql or can it be prevented? |
| 4 |
> |
| 5 |
> This is not normal. None of my mysql instances crash frequently |
| 6 |
> |
| 7 |
> |
| 8 |
>> I don't think I've |
| 9 |
>> changed the mysql config from default besides creating the necessary |
| 10 |
>> tables although I could be wrong. /var/log/mysql/mysqld.err doesn't |
| 11 |
>> contain info about the crash but here's info from the restart: |
| 12 |
>> |
| 13 |
>> [Warning] No argument was provided to --log-bin, and --log-bin-index |
| 14 |
>> was not used; so replication may break when this MySQL server acts as |
| 15 |
>> a master and has his hostname changed!! Please use |
| 16 |
>> '--log-bin=mysqld-bin' to avoid this problem. /usr/sbin/mysqld: Table |
| 17 |
>> 'mysql.plugin' doesn't exist |
| 18 |
>> [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to |
| 19 |
>> create it. |
| 20 |
>> InnoDB: Started; log sequence number 0 43655 |
| 21 |
>> [Note] Recovering after a crash using mysqld-bin |
| 22 |
>> [Note] Starting crash recovery... |
| 23 |
>> [Note] Crash recovery finished. |
| 24 |
>> [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' |
| 25 |
>> doesn't exist |
| 26 |
>> [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. |
| 27 |
>> Created with MySQL 50070, now running 50151. Please use mysql_upgrade |
| 28 |
>> to fix this error. |
| 29 |
> |
| 30 |
> |
| 31 |
> Did you ever run mysql_upgrade as mentioned here? |
| 32 |
|
| 33 |
I'm told I need to run mysqld with --skip-grant-tables. I'm used to |
| 34 |
using Gentoo's mysql initscript. Should 'mysqld --skip-grant-tables' |
| 35 |
work? |
| 36 |
|
| 37 |
- Grant |
Archives