Hello mysql,
Hello mysql,
I'm quite lucky with providing with bad tables which does not repear
properly or having other strange behavior.
Here is one more:
mysql 3.23.42
gnome:~ # mysqldump -d layers_st57 g01kw_engines
# MySQL dump 8.16
#
# Host: localhost Database: layers_st57
#--------------------------------------------------------
# Server version 3.23.42-log
#
# Table structure for table 'g01kw_engines'
#
CREATE TABLE g01kw_engines (
id int(10) unsigned NOT NULL auto_increment,
counter_id int(10) unsigned NOT NULL default '0',
engine_id smallint(5) unsigned NOT NULL default '0',
kw_id int(11) NOT NULL default '0',
PRIMARY KEY (id),
KEY search (counter_id,kw_id)
) TYPE=MyISAM PACK_KEYS=1;
Not id and counter_id are NOT NULL
Let's now select some data from the table:
mysql> select * from layers_st57.g01kw_engines;
+------+------------+-----------+-------+
| id | counter_id | engine_id | kw_id |
+------+------------+-----------+-------+
| NULL | NULL | 232 | 41895 |
+------+------------+-----------+-------+
1 row in set (1.33 sec)
mysql> select * from layers_st57.g01kw_engines;
ERROR 2013: Lost connection to MySQL server during query
... almost every query to this table crashes mysql (I have a back
trace but I think it's better to upload the table)
check table threats this table as good:
mysql> check table layers_st57.g01kw_engines type=EXTENDED;
+---------------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------------------------+-------+----------+----------+
| layers_st57.g01kw_engines | check | status | OK |
+---------------------------+-------+----------+----------+
1 row in set (0.31 sec)
mysql> repair table layers_st57.g01kw_engines;
+---------------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------------------------+--------+----------+----------+
| layers_st57.g01kw_engines | repair | status | OK |
+---------------------------+--------+----------+----------+
1 row in set (0.33 sec)
MYISAMCHK:
gnome:/home/pz/strange_table # myisamchk -ce *.MYI
myisamchk: error: 22 when opening MyISAM-table 'g01kw_pages.MYI'
Press any key to continue..
So I went really surprised.
I've copied MYI file from the table of the same structure and it got
repaired OK. So it looks like this is dammaged index definition
again.
I've uploaded the table as badtable.tar.gz so you may look at this.
P.S I was trying to send this message to BUGS but got a rejection from
the robot :(
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
