Hi! On Feb 23, Gelu Gogancea wrote: > Hi, > TABLE CREATE DESCRIPTION : > CREATE TABLE T1(IDAP INT(16),TVAL INT(2),CH_VAL_SEC > INT(16),INDEX(IDAP),INDEX(TVAL),INDEX(CH_VAL_SEC)); > > RUNNING CONDITIONS: > -use persistent connection.
What do you mean "persistent connection" ? Persistent PHP connections ? > RUNNING SEQUENCE: > 1-Open 1-st connection. > 2-insert in table many values at once time with "delayed" option; > "insert delayed into T1 (IDAP,TVAL,CH_VAL_SEC) > VALUES(1,-2,100),(2,-3,101),(3,-4,102);" > 3-I let 1-st connection open.Open 2-nd connection to execute the next 2 statement. > 4-delete all data from table : > "delete from T1;" > 5-optimize the table : > "optimize table T1;" > MySQL daemon crash on this last statement if i use PERSISTENT > CONNECTION, otherwise is OK. It doesn't crash for me when I use mysql command line client. What MySQL client do you use - PHP ? > >From the mysql daemon log: > > 040223 14:59:49 mysqld started > 040223 14:59:50 InnoDB: Started; log sequence number 0 43634 > 040223 14:59:50 /mysql/mysql-5.0.bin/libexec/mysqld: Can't create/write to file > '/var/run/mysqld/mysqld.pid' (Errcode: 2) > 040223 14:59:50 Found 4.1 style password for user '[EMAIL PROTECTED]'. Ignoring > user. You should change password for this user. > /mysql/mysql-5.0.bin/libexec/mysqld: ready for connections. > Version: '5.0.0-alpha' socket: '/mysql/mydatabase/mysql.sock' port: 3306 > mysqld got signal 11; > This could be because you hit a bug. It is also possible that this binary > or one of the libraries it was linked against is corrupt, improperly built, > or misconfigured. This error can also be caused by malfunctioning hardware. > We will try our best to scrape up some info that will hopefully help diagnose > the problem, but since we have already crashed, something is definitely wrong > and this may fail. > > key_buffer_size=8388600 > read_buffer_size=131072 > max_used_connections=2 > max_connections=100 > threads_connected=3 > It is possible that mysqld could use up to > key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K > bytes of memory > Hope that's ok; if not, decrease some variables in the equation. > > thd=0x85b00a8 > Attempting backtrace. You can use the following information to find out > where mysqld died. If you see no messages after this, something went > terribly wrong... > Cannot determine thread, fp=0x41da4ee4, backtrace may not be correct. > Stack range sanity check OK, backtrace follows: > 0x813c7c4 > 0x4004e618 > 0x40049dea > 0x4202726c > 0x40049dea > 0x8185301 > 0x400492b6 > 0x420de407 > New value of fp=(nil) failed sanity check, terminating stack trace! > Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow > instructions on how to resolve the stack trace. Resolved > stack trace is much more helpful in diagnosing the problem, so please do resolve it Could you please post a resolved stack trace as suggests the url above ? > Trying to get some variables. > Some pointers may be invalid and cause the dump to abort... > thd->query at 0x8584920 = O.H..B. > thd->thread_id=4 > The manual page at http://www.mysql.com/doc/en/Crashing.html contains > information that should help you find out what is causing the crash. > 040223 15:01:37 mysqld ended Thank you! Regards, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
