>Description: Hi all, I'm not exactly sure whether this is a bug or that I'm just the following proper procedures for starting and stoping the database and flushing logs. But I do have repeatable test cases below.(terminal screen dumps)
I'm using version 3.23.36 with BDB tables: Basically my data is sometimes deleted, sometimes all of it recoverable and sometimes only partially after a reboot, I'm not sure the exact cause. But in attempting to reproduce the errors which I think it is correlated with running an ALTER TABLE command, and possibly stopping and starting the server, and hence the following test cases. >How-To-Repeat: Basically the sequence of events I ran for my test case follows. case 4: create a table , insert some data, alter table to add a column, stop & restart database , select on the table shows up EMPTY. case 9: create a table , insert some data, alter table to add a column, flush logs, stop database, stop & restart database, select on table shows up WITH DATA case11: create a table, insert some data, alter table to add a column , insert some more data, stop & restart database, select on table shows up EMPTY, stop and restart database again , select on table shows up WITH DATA. case10: create a table, insert some data, alter table to add a column, insert some more data, flush logs, stop & restart database , table shows up with DATA. Is there something that I'm suppose to be doing administration wise when changing table structure or stoping or starting the server ? I'd appreciate any advice you can offer on how to get around this problem, and prevent random deletion of data. Thank you. Sincerely, Kalok Lo -------------------------case 4 begin---------------------------- Script started on Thu Jan 31 01:21:54 2002 [root@shop mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> create table crash_case4( -> test1 int auto_increment primary key not null, -> test2 varchar(50) -> )type=bdb; Query OK, 0 rows affected (0.15 sec) mysql> insert into crash_case4 values('', 'test1'); Query OK, 1 row affected (0.01 sec) mysql> insert into crash_case4 values('', 'test2'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case4 values('', 'test3'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case4 values('', 'test4'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case4 values('', 'test5'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case4 values('', 'test6'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case4 values('', 'test7'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case4 values('', 'test8'); Query OK, 1 row affected (0.09 sec) mysql> select * from crash_case4; +-------+-------+ | test1 | test2 | +-------+-------+ | 1 | test1 | | 2 | test2 | | 3 | test3 | | 4 | test4 | | 5 | test5 | | 6 | test6 | | 7 | test7 | | 8 | test8 | +-------+-------+ 8 rows in set (0.00 sec) mysql> alter table crash_case4 -> add test3 varchar(50); Query OK, 8 rows affected (0.26 sec) Records: 8 Duplicates: 0 Warnings: 0 mysql> desc crash_case4; +-------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+----------------+ | test1 | int(11) | | PRI | NULL | auto_increment | | test2 | varchar(50) | YES | | NULL | | | test3 | varchar(50) | YES | | NULL | | +-------+-------------+------+-----+---------+----------------+ 3 rows in set (0.00 sec) mysql> exit Bye [root@shop mysql]# /etc/rc.d/init.d/mysql stop Killing mysqld with pid 17900 [root@shop mysql]# /etc/rc.d/init.d/mysql start [root@shop mysql]# Starting mysqld daemon with databases from /var/lib/mysql [root@shop mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select * from crash_case4; Empty set (0.00 sec) mysql> exit Bye [root@shop mysql]# Script done on Thu Jan 31 01:23:29 2002 -----------------------case 9 begin------------------------------- Script started on Thu Jan 31 01:52:25 2002 [root@shop mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> create table crash_case9( -> test1 int auto_increment primary key not null, -> test2 varchar(50) -> )type=bdb; Query OK, 0 rows affected (0.15 sec) mysql> insert into crash_case9 values('', 'test1'); Query OK, 1 row affected (0.01 sec) mysql> insert into crash_case9 values('', 'test2'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case9 values('', 'test3'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case9 values('', 'test4'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case9 values('', 'test5'); Query OK, 1 row affected (0.01 sec) mysql> insert into crash_case9 values('', 'test6'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case9 values('', 'test7'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case9 values('', 'test8'); Query OK, 1 row affected (0.01 sec) mysql> select * from crash_case9; +-------+-------+ | test1 | test2 | +-------+-------+ | 1 | test1 | | 2 | test2 | | 3 | test3 | | 4 | test4 | | 5 | test5 | | 6 | test6 | | 7 | test7 | | 8 | test8 | +-------+-------+ 8 rows in set (0.00 sec) mysql> alter table crash_case9 -> add test3 varchar(50); flush logs;Query OK, 8 rows affected (0.24 sec) Records: 8 Duplicates: 0 Warnings: 0 mysql> desc crash_case9; +-------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+----------------+ | test1 | int(11) | | PRI | NULL | auto_increment | | test2 | varchar(50) | YES | | NULL | | | test3 | varchar(50) | YES | | NULL | | +-------+-------------+------+-----+---------+----------------+ 3 rows in set (0.01 sec) mysql> flush logs; Query OK, 0 rows affected (0.01 sec) mysql> exit; Bye [root@shop mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select * from crash_case9; +-------+-------+-------+ | test1 | test2 | test3 | +-------+-------+-------+ | 1 | test1 | NULL | | 2 | test2 | NULL | | 3 | test3 | NULL | | 4 | test4 | NULL | | 5 | test5 | NULL | | 6 | test6 | NULL | | 7 | test7 | NULL | | 8 | test8 | NULL | +-------+-------+-------+ 8 rows in set (0.00 sec) mysql> exit; Bye [root@shop mysql]# /etc/rc.d/init.d/mysql stop Killing mysqld with pid 18386 [root@shop mysql]# [root@shop mysql]# /etc/rc.d/init.d/mysql start [root@shop mysql]# [root@shop mysql]# Starting mysqld daemon with databases from /var/lib/mysql [root@shop mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> use test; </inpu* from crash_case9; +-------+-------+-------+ | test1 | test2 | test3 | +-------+-------+-------+ | 1 | test1 | NULL | | 2 | test2 | NULL | | 3 | test3 | NULL | | 4 | test4 | NULL | | 5 | test5 | NULL | | 6 | test6 | NULL | | 7 | test7 | NULL | | 8 | test8 | NULL | +-------+-------+-------+ 8 rows in set (0.00 sec) mysql> exit; Bye [root@shop mysql]# Script done on Thu Jan 31 01:54:27 2002 -----------------------case 10 begin----------------------------- Script started on Thu Jan 31 01:59:53 2002 [root@shop mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> create table crash_case10( -> test1 int auto_increment primary key not null, -> test2 varchar(50) -> )type=bdb; Query OK, 0 rows affected (0.14 sec) mysql> insert into crash_case10 values('', 'test1'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case10 values('', 'test2'); Query OK, 1 row affected (0.01 sec) mysql> insert into crash_case10 values('', 'test3'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case10 values('', 'test4'); Query OK, 1 row affected (0.01 sec) mysql> insert into crash_case10 values('', 'test5'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case10 values('', 'test6'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case10 values('', 'test7'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case10 values('', 'test8'); Query OK, 1 row affected (0.01 sec) mysql> select * from crash_case10; +-------+-------+ | test1 | test2 | +-------+-------+ | 1 | test1 | | 2 | test2 | | 3 | test3 | | 4 | test4 | | 5 | test5 | | 6 | test6 | | 7 | test7 | | 8 | test8 | +-------+-------+ 8 rows in set (0.00 sec) mysql> alter table crash_case10 -> add test3 varchar(50); Query OK, 8 rows affected (0.26 sec) Records: 8 Duplicates: 0 Warnings: 0 mysql> desc crash_case10; +-------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+----------------+ | test1 | int(11) | | PRI | NULL | auto_increment | | test2 | varchar(50) | YES | | NULL | | | test3 | varchar(50) | YES | | NULL | | +-------+-------------+------+-----+---------+----------------+ 3 rows in set (0.01 sec) mysql> insert into crash_case10 values('', 'test11', 'test11b'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case10 values('', 'test12', 'test12b'); Query OK, 1 row affected (0.01 sec) mysql> insert into crash_case10 values('', 'test13', 'test13b'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case10 values('', 'test14', 'test14b'); Query OK, 1 row affected (0.01 sec) mysql> insert into crash_case10 values('', 'test15', 'test15b'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case10 values('', 'test16', 'test16b'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case10 values('', 'test17', 'test17b'); Query OK, 1 row affected (0.01 sec) mysql> insert into crash_case10 values('', 'test18', 'test18b'); Query OK, 1 row affected (0.10 sec) mysql> select * from crash_case10; +-------+--------+---------+ | test1 | test2 | test3 | +-------+--------+---------+ | 1 | test1 | NULL | | 2 | test2 | NULL | | 3 | test3 | NULL | | 4 | test4 | NULL | | 5 | test5 | NULL | | 6 | test6 | NULL | | 7 | test7 | NULL | | 8 | test8 | NULL | | 9 | test11 | test11b | | 10 | test12 | test12b | | 11 | test13 | test13b | | 12 | test14 | test14b | | 13 | test15 | test15b | | 14 | test16 | test16b | | 15 | test17 | test17b | | 16 | test18 | test18b | +-------+--------+---------+ 16 rows in set (0.01 sec) mysql> flush logs; Query OK, 0 rows affected (0.01 sec) mysql> select * from crash_case1-; ERROR 1064: ou have an error in your SQL syntax near '-' at line 1 mysql> select * from crash_case10; +-------+--------+---------+ | test1 | test2 | test3 | +-------+--------+---------+ | 1 | test1 | NULL | | 2 | test2 | NULL | | 3 | test3 | NULL | | 4 | test4 | NULL | | 5 | test5 | NULL | | 6 | test6 | NULL | | 7 | test7 | NULL | | 8 | test8 | NULL | | 9 | test11 | test11b | | 10 | test12 | test12b | | 11 | test13 | test13b | | 12 | test14 | test14b | | 13 | test15 | test15b | | 14 | test16 | test16b | | 15 | test17 | test17b | | 16 | test18 | test18b | +-------+--------+---------+ 16 rows in set (0.00 sec) mysql> select * from crash_case10; +-------+--------+---------+ | test1 | test2 | test3 | +-------+--------+---------+ | 1 | test1 | NULL | | 2 | test2 | NULL | | 3 | test3 | NULL | | 4 | test4 | NULL | | 5 | test5 | NULL | | 6 | test6 | NULL | | 7 | test7 | NULL | | 8 | test8 | NULL | | 9 | test11 | test11b | | 10 | test12 | test12b | | 11 | test13 | test13b | | 12 | test14 | test14b | | 13 | test15 | test15b | | 14 | test16 | test16b | | 15 | test17 | test17b | | 16 | test18 | test18b | +-------+--------+---------+ 16 rows in set (0.01 sec) mysql> exit; Bye [root@shop mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> use test; mysql>t/activities reproduce th* from crash_case10; +-------+--------+---------+ | test1 | test2 | test3 | +-------+--------+---------+ | 1 | test1 | NULL | | 2 | test2 | NULL | | 3 | test3 | NULL | | 4 | test4 | NULL | | 5 | test5 | NULL | | 6 | test6 | NULL | | 7 | test7 | NULL | | 8 | test8 | NULL | | 9 | test11 | test11b | | 10 | test12 | test12b | | 11 | test13 | test13b | | 12 | test14 | test14b | | 13 | test15 | test15b | | 14 | test16 | test16b | | 15 | test17 | test17b | | 16 | test18 | test18b | +-------+--------+---------+ 16 rows in set (0.00 sec) mysql> exit Bye [root@shop mysql]# /etc/rc.d/init.d/mysql stop Killing mysqld with pid 18455 [root@shop mysql]# /etc/rc.d/init.d/mysql start [root@shop mysql]# [root@shop mysql]# Starting mysqld daemon with databases from /var/lib/mysql [root@shop mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> use test; mysql> problem * from crash_case10; +-------+--------+---------+ | test1 | test2 | test3 | +-------+--------+---------+ | 1 | test1 | NULL | | 2 | test2 | NULL | | 3 | test3 | NULL | | 4 | test4 | NULL | | 5 | test5 | NULL | | 6 | test6 | NULL | | 7 | test7 | NULL | | 8 | test8 | NULL | | 9 | test11 | test11b | | 10 | test12 | test12b | | 11 | test13 | test13b | | 12 | test14 | test14b | | 13 | test15 | test15b | | 14 | test16 | test16b | | 15 | test17 | test17b | | 16 | test18 | test18b | +-------+--------+---------+ 16 rows in set (0.01 sec) mysql> exit; Bye [root@shop mysql]# lines)> ot@shop mysql]# Script done on Thu Jan 31 02:01:33 2002 ---------------------case 11 begin--------------------------- Script started on Thu Jan 31 10:04:21 2002 [root@shop mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A create table crash_case11( Database changed mysql> create table crash_case11( -> test1 int auto_increment primary key not null, -> test2 varchar(50) -> )type=bdb; insert into crash_case11 values('', 'test2'); insert into crash_case11 values('', 'test3'); insert into crash_case11 values('', 'test4'); insert into crash_case11 values('', 'test5'); insert into crash_case11 values('', 'test6'); insert into crash_case11 values('', 'test7'); insert into crash_case11 values('', 'test8'); select * from crash_case11; alter table crash_case11 add test3 varchar(50); desc crash_case11; insert into crash_case11 values('', 'test11', 'test11b'); insert into crash_case11 values('', 'test12', 'test12b'); insert into crash_case11 values('', 'test13', 'test13b'); insert into crash_case11 values('', 'test14', 'test14b'); insert into crash_case11 values('', 'test15', 'test15b'); insert into crash_case11 values('', 'test16', 'test16b'); insert into crash_case11 values('', 'test17', 'test17b'); insert into crash_case11 values('', 'test18', 'test18b'); select * from crash_case11; Query OK, 0 rows affected (0.31 sec) mysql> insert into crash_case11 values('', 'test1'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case11 values('', 'test2'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case11 values('', 'test3'); Query OK, 1 row affected (0.01 sec) mysql> insert into crash_case11 values('', 'test4'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case11 values('', 'test5'); Query OK, 1 row affected (0.01 sec) mysql> insert into crash_case11 values('', 'test6'); Query OK, 1 row affected (0.01 sec) mysql> insert into crash_case11 values('', 'test7'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case11 values('', 'test8'); Query OK, 1 row affected (0.02 sec) mysql> select * from crash_case11; +-------+-------+ | test1 | test2 | +-------+-------+ | 1 | test1 | | 2 | test2 | | 3 | test3 | | 4 | test4 | | 5 | test5 | | 6 | test6 | | 7 | test7 | | 8 | test8 | +-------+-------+ 8 rows in set (0.01 sec) mysql> alter table crash_case11 -> add test3 varchar(50); Query OK, 8 rows affected (0.25 sec) Records: 8 Duplicates: 0 Warnings: 0 mysql> desc crash_case11; +-------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+----------------+ | test1 | int(11) | | PRI | NULL | auto_increment | | test2 | varchar(50) | YES | | NULL | | | test3 | varchar(50) | YES | | NULL | | +-------+-------------+------+-----+---------+----------------+ 3 rows in set (0.01 sec) mysql> mysql> insert into crash_case11 values('', 'test11', 'test11b'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case11 values('', 'test12', 'test12b'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case11 values('', 'test13', 'test13b'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case11 values('', 'test14', 'test14b'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case11 values('', 'test15', 'test15b'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case11 values('', 'test16', 'test16b'); Query OK, 1 row affected (0.00 sec) mysql> insert into crash_case11 values('', 'test17', 'test17b'); Query OK, 1 row affected (0.01 sec) mysql> insert into crash_case11 values('', 'test18', 'test18b'); Query OK, 1 row affected (0.00 sec) mysql> mysql> select * from crash_case11; +-------+--------+---------+ | test1 | test2 | test3 | +-------+--------+---------+ | 1 | test1 | NULL | | 2 | test2 | NULL | | 3 | test3 | NULL | | 4 | test4 | NULL | | 5 | test5 | NULL | | 6 | test6 | NULL | | 7 | test7 | NULL | | 8 | test8 | NULL | | 9 | test11 | test11b | | 10 | test12 | test12b | | 11 | test13 | test13b | | 12 | test14 | test14b | | 13 | test15 | test15b | | 14 | test16 | test16b | | 15 | test17 | test17b | | 16 | test18 | test18b | +-------+--------+---------+ 16 rows in set (0.00 sec) mysql> exit; Bye [root@shop mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> status -------------- mysql Ver 11.13 Distrib 3.23.36, for pc-linux-gnu (i686) Connection id: 6 Current database: Current user: root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.36 Protocol version: 10 Connection: Localhost via UNIX socket Client characterset: latin1 Server characterset: latin1 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 8 hours 3 min 38 sec Threads: 1 Questions: 162 Slow queries: 0 Opens: 95 Flush tables: 1 Open tables: 64 Queries per second avg: 0.006 -------------- mysql> show logs; +-------------------------------+------+--------+ | File | Type | Status | +-------------------------------+------+--------+ | /var/lib/mysql/log.0000000012 | BDB | IN USE | +-------------------------------+------+--------+ 1 row in set (0.00 sec) mysql> exit Bye [root@shop mysql]# /etc/rc.d/init.d/mysql stop Killing mysqld with pid 18534 [root@shop mysql]# [root@shop mysql]# /etc/rc.d/init.d/mysql start [root@shop mysql]# Starting mysqld daemon with databases from /var/lib/mysql [root@shop mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select * from crash_case11; Empty set (0.00 sec) mysql> exit; Bye [root@shop mysql]# /etc/rc.d/init.d/mysql stop Killing mysqld with pid 19522 020131 10:05:50 mysqld ended [root@shop mysql]# /etc/rc.d/init.d/mysql start [root@shop mysql]# Starting mysqld daemon with databases from /var/lib/mysql [root@shop mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select * from crash_case11; +-------+--------+---------+ | test1 | test2 | test3 | +-------+--------+---------+ | 1 | test1 | NULL | | 2 | test2 | NULL | | 3 | test3 | NULL | | 4 | test4 | NULL | | 5 | test5 | NULL | | 6 | test6 | NULL | | 7 | test7 | NULL | | 8 | test8 | NULL | | 9 | test11 | test11b | | 10 | test12 | test12b | | 11 | test13 | test13b | | 12 | test14 | test14b | | 13 | test15 | test15b | | 14 | test16 | test16b | | 15 | test17 | test17b | | 16 | test18 | test18b | +-------+--------+---------+ 16 rows in set (0.00 sec) mysql> exit; Bye [root@shop mysql]# /etc/rc.d/init.d/mysql stop Killing mysqld with pid 19563 020131 10:11:27 mysqld ended [root@shop mysql]# /etc/rc.d/init.d/mysql start [root@shop mysql]# Starting mysqld daemon with databases from /var/lib/mysql [root@shop mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select * from crash_case11; +-------+--------+---------+ | test1 | test2 | test3 | +-------+--------+---------+ | 1 | test1 | NULL | | 2 | test2 | NULL | | 3 | test3 | NULL | | 4 | test4 | NULL | | 5 | test5 | NULL | | 6 | test6 | NULL | | 7 | test7 | NULL | | 8 | test8 | NULL | | 9 | test11 | test11b | | 10 | test12 | test12b | | 11 | test13 | test13b | | 12 | test14 | test14b | | 13 | test15 | test15b | | 14 | test16 | test16b | | 15 | test17 | test17b | | 16 | test18 | test18b | +-------+--------+---------+ 16 rows in set (0.01 sec) mysql> show logs; +-------------------------------+------+--------+ | File | Type | Status | +-------------------------------+------+--------+ | /var/lib/mysql/log.0000000012 | BDB | IN USE | +-------------------------------+------+--------+ 1 row in set (0.01 sec) mysql> exit; Bye [root@shop mysql]# Script done on Thu Jan 31 10:11:51 2002 --------------case end-------------------------------------------------------------------- >Submitter-Id: <submitter ID> >Originator: root >Organization: mysql> >Fix: >Submitter-Id: <submitter ID> >Originator: root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: <bdb table data deleted> >Severity: >Priority: >Category: mysql >Class: >Release: mysql-3.23.36 (Linux-Mandrake MySQL RPM) >Server: /usr/bin/mysqladmin Ver 8.18 Distrib 3.23.36, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.36-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 3 hours 56 min 11 sec Threads: 7 Questions: 801 Slow queries: 0 Opens: 65 Flush tables: 1 Open tables: 59 Queries per second avg: 0.057 >Environment: System: Linux sdbl.teamshopa.com 2.4.3-20mdk #1 Sun Apr 15 23:03:10 CEST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.96/specs gcc version 2.96 20000731 (Linux-Mandrake 8.0 2.96-0.48mdk) Compilation info: CC='gcc' CFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math -fno-omit-frame-pointer' CXX='g++' CXXFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math -fno-omit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Nov 8 07:29 /lib/libc.so.6 -> libc-2.2.2.so -rwxr-xr-x 1 root root 1216268 Feb 21 2001 /lib/libc-2.2.2.so -rw-r--r-- 1 root root 26366908 Feb 21 2001 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Feb 21 2001 /usr/lib/libc.so Configure command: ./configure --enable-shared --enable-thread-safe-client --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man --with-berkeley-db --without-innobase '--with-comment=Linux-Mandrake MySQL RPM' --------------------------------------------------------------------- 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