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]