Hello
I meet a strange problem:
when I create a new table, the mysql cleint loose connection with the server.
Synopsis:
$ mysqladmin -u mysql -pxxxxx create temp
(no problem reported, /var/lib/mysql got a new directory 'temp')
$ mysql -u mysql -pxxxxx temp
mysql> create table oups ( id bigint primary key auto_increment not null);
ERROR 2013: Lost connection to MySQL server during query
mysql> show tables;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 10
Current database: temp
Didn't find any fields in table 'oups'
+----------------+
| Tables_in_temp |
+----------------+
| oups |
+----------------+
When I look in the mysql log file:
Number of processes running now: 1
mysqld process hanging, pid 16137 - killed
021018 11:12:03 mysqld restarted
/usr/local/mysql-3.23.52/libexec/mysqld: ready for connections
And in the directory '/var/lib/mysql/temp', there is a file 'oups.frm', but no
'oups.MYI'
MySQL version is 3.23.52 handmade running on a RedHat 6.2 (linux 2.2.14)
The server has no big load.
Does someone know how to make it work again ?
--
NetClub'ment votre,
Mickael Bailly
---------------------------------------------------------------------
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
