Package: mysql-server-4.1
Version: 4.1.11a-4sarge7
Severity: important
Tags: patch
-- System Information:
Debian Release: 3.1
Architecture: i386 (i686)
Kernel: Linux 2.6.9-023stab033.1-enterprise
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Versions of packages mysql-server-4.1 depends on:
ii adduser 3.63 Add and remove users and groups
ii debconf 1.4.30.13 Debian configuration management sy
ii libc6 2.3.2.ds1-22sarge4 GNU C Library: Shared libraries an
ii libdbi-perl 1.46-6 Perl5 database interface by Tim Bu
ii libgcc1 1:3.4.3-13sarge1 GCC support library
ii libmysqlclient14 4.1.11a-4sarge7 mysql database client library
ii libncurses5 5.4-4 Shared libraries for terminal hand
ii libreadline4 4.3-11 GNU readline and history libraries
ii libstdc++5 1:3.3.5-13 The GNU Standard C++ Library v3
ii libwrap0 7.6.dbs-8 Wietse Venema's TCP wrappers libra
ii mailx 1:8.1.2-0.20040524cvs-4 A simple mail user agent
ii mysql-client-4.1 4.1.11a-4sarge7 mysql database client binaries
ii mysql-common-4.1 4.1.11a-4sarge7 mysql database common files (e.g.
ii passwd 1:4.0.3-31sarge9 change and administer password and
ii perl 5.8.4-8sarge5 Larry Wall's Practical Extraction
ii psmisc 21.5-1 Utilities that use the proc filesy
ii zlib1g 1:1.2.2-4.sarge.2 compression library - runtime
-- debconf information:
mysql-server-4.1/start_on_boot: true
mysql-server-4.1/postrm_remove_databases: false
* mysql-server-4.1/mysql_install_db_notes:
mysql-server-4.1/mysql_update_hints1:
mysql-server-4.1/nis_warning:
Updating fields in mysql table (random entries) does result in "incorrect key
file for table" and this in syslog:
mysqld[18238]: 061116 8:15:06 [ERROR] /usr/sbin/mysqld: Can't open file:
'serendipity_entries.MYI' (errno: 145)
After restarting mysql this happens:
Nov 16 08:14:59 lvps87-230-14-47 /etc/mysql/debian-start[18271]: Checking for
crashed MySQL tables.
Nov 16 08:15:01 lvps87-230-14-47 /etc/mysql/debian-start[18310]: WARNING:
mysqlcheck has found corrupt tables
Nov 16 08:15:01 lvps87-230-14-47 /etc/mysql/debian-start[18310]:
serendipity.serendipity_entries
Nov 16 08:15:01 lvps87-230-14-47 /etc/mysql/debian-start[18310]: warning :
Table is marked as crashed
Nov 16 08:15:01 lvps87-230-14-47 /etc/mysql/debian-start[18310]: error :
Checksum for key: 3 doesn't match checksum for records
Nov 16 08:15:01 lvps87-230-14-47 /etc/mysql/debian-start[18310]: error :
Corrupt
Nov 16 08:15:01 lvps87-230-14-47 /etc/mysql/debian-start[18310]:
Nov 16 08:15:01 lvps87-230-14-47 /etc/mysql/debian-start[18310]: Improperly
closed tables are also reported if clients are accessing
Nov 16 08:15:01 lvps87-230-14-47 /etc/mysql/debian-start[18310]: the tables
*now*. A list of current connections is below.
Nov 16 08:15:01 lvps87-230-14-47 /etc/mysql/debian-start[18310]:
Nov 16 08:15:01 lvps87-230-14-47 /etc/mysql/debian-start[18310]:
+----+------------------+-----------+----+---------+------+-------+------------------+
Nov 16 08:15:01 lvps87-230-14-47 /etc/mysql/debian-start[18310]: | Id | User
| Host | db | Command | Time | State | Info |
Nov 16 08:15:01 lvps87-230-14-47 /etc/mysql/debian-start[18310]:
+----+------------------+-----------+----+---------+------+-------+------------------+
Nov 16 08:15:01 lvps87-230-14-47 /etc/mysql/debian-start[18310]: | 5 |
debian-sys-maint | localhost | | Query | 0 | | show processlist |
Nov 16 08:15:01 lvps87-230-14-47 /etc/mysql/debian-start[18310]:
+----+------------------+-----------+----+---------+------+-------+------------------+
Nov 16 08:15:01 lvps87-230-14-47 /etc/mysql/debian-start[18310]: Uptime: 2
Threads: 1 Questions: 398 Slow queries: 0 Opens: 367 Flush tables: 1 Open
tables: 64 Queries per second avg: 199.000
Nov 16 08:15:01 lvps87-230-14-47 CRON[18367]: (pam_unix) session opened for
user root by (uid=0)
Nov 16 08:15:01 lvps87-230-14-47 CRON[18367]: (pam_unix) session closed for
user root
Nov 16 08:15:06 lvps87-230-14-47 mysqld[18238]: 061116 8:15:06 [ERROR]
/usr/sbin/mysqld: Can't open file: 'serendipity_entries.MYI' (errno: 145)
Bug is described in mysql BUG 5686. Updating to 4.1.16 should help.
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
