1 |
Apparently, though unproven, at 18:10 on Sunday 28 November 2010, Grant did |
2 |
opine thusly: |
3 |
|
4 |
> mysql-5.1.51 crashed recently and needed to be restarted. This |
5 |
> doesn't happen often with mysql but does from time to time. Is this |
6 |
> part of life with mysql or can it be prevented? |
7 |
|
8 |
This is not normal. None of my mysql instances crash frequently |
9 |
|
10 |
|
11 |
> I don't think I've |
12 |
> changed the mysql config from default besides creating the necessary |
13 |
> tables although I could be wrong. /var/log/mysql/mysqld.err doesn't |
14 |
> contain info about the crash but here's info from the restart: |
15 |
> |
16 |
> [Warning] No argument was provided to --log-bin, and --log-bin-index |
17 |
> was not used; so replication may break when this MySQL server acts as |
18 |
> a master and has his hostname changed!! Please use |
19 |
> '--log-bin=mysqld-bin' to avoid this problem. /usr/sbin/mysqld: Table |
20 |
> 'mysql.plugin' doesn't exist |
21 |
> [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to |
22 |
> create it. |
23 |
> InnoDB: Started; log sequence number 0 43655 |
24 |
> [Note] Recovering after a crash using mysqld-bin |
25 |
> [Note] Starting crash recovery... |
26 |
> [Note] Crash recovery finished. |
27 |
> [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' |
28 |
> doesn't exist |
29 |
> [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. |
30 |
> Created with MySQL 50070, now running 50151. Please use mysql_upgrade |
31 |
> to fix this error. |
32 |
|
33 |
|
34 |
Did you ever run mysql_upgrade as mentioned here? |
35 |
|
36 |
With the last mysql upgrade, did you restart the service? It's quite important |
37 |
to always restart any service you have just upgraded. |
38 |
|
39 |
|
40 |
|
41 |
> [ERROR] mysql.user has no `Event_priv` column at position 29 |
42 |
> [ERROR] Cannot open mysql.event |
43 |
> [ERROR] Event Scheduler: An error occurred when initializing system |
44 |
> tables. Disabling the Event Scheduler. |
45 |
> [Note] /usr/sbin/mysqld: ready for connections. |
46 |
> |
47 |
> It looks like I should run mysql_upgrade for one thing. Is there a |
48 |
> Gentoo way to do that? Will I lose data? |
49 |
> |
50 |
> As I went over this I realized that I hadn't enabled skip-networking, |
51 |
> although nmap from the same system didn't show port 3306 open and I'm |
52 |
> not running a firewall on the machine. How could that be? |
53 |
> |
54 |
> - Grant |
55 |
|
56 |
-- |
57 |
alan dot mckinnon at gmail dot com |