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? I don't think I've |
4 |
changed the mysql config from default besides creating the necessary |
5 |
tables although I could be wrong. /var/log/mysql/mysqld.err doesn't |
6 |
contain info about the crash but here's info from the restart: |
7 |
|
8 |
[Warning] No argument was provided to --log-bin, and --log-bin-index |
9 |
was not used; so replication may break when this MySQL server acts as |
10 |
a master and has his hostname changed!! Please use |
11 |
'--log-bin=mysqld-bin' to avoid this problem. /usr/sbin/mysqld: Table |
12 |
'mysql.plugin' doesn't exist |
13 |
[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to |
14 |
create it. |
15 |
InnoDB: Started; log sequence number 0 43655 |
16 |
[Note] Recovering after a crash using mysqld-bin |
17 |
[Note] Starting crash recovery... |
18 |
[Note] Crash recovery finished. |
19 |
[ERROR] Can't open and lock privilege tables: Table 'mysql.servers' |
20 |
doesn't exist |
21 |
[ERROR] Column count of mysql.db is wrong. Expected 22, found 20. |
22 |
Created with MySQL 50070, now running 50151. Please use mysql_upgrade |
23 |
to fix this error. |
24 |
[ERROR] mysql.user has no `Event_priv` column at position 29 |
25 |
[ERROR] Cannot open mysql.event |
26 |
[ERROR] Event Scheduler: An error occurred when initializing system |
27 |
tables. Disabling the Event Scheduler. |
28 |
[Note] /usr/sbin/mysqld: ready for connections. |
29 |
|
30 |
It looks like I should run mysql_upgrade for one thing. Is there a |
31 |
Gentoo way to do that? Will I lose data? |
32 |
|
33 |
As I went over this I realized that I hadn't enabled skip-networking, |
34 |
although nmap from the same system didn't show port 3306 open and I'm |
35 |
not running a firewall on the machine. How could that be? |
36 |
|
37 |
- Grant |