>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