Gentoo Archives: gentoo-user

From: Grant <emailgrant@×××××.com>
To: Gentoo mailing list <gentoo-user@l.g.o>
Subject: [gentoo-user] Should mysql crash sometimes?
Date: Sun, 28 Nov 2010 16:11:23
Message-Id: AANLkTi=Zhd3WUnkNbM17j-qCo6RdmDm=WzKcZuz-VbVh@mail.gmail.com
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

Replies

Subject Author
Re: [gentoo-user] Should mysql crash sometimes? Alan McKinnon <alan.mckinnon@×××××.com>