...like usually i forget some details:
Table type is MyISAM and was created with MySQL ver 3.23.47
But if i create the table with ver.4.1 the behaviour is the same.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Gelu Gogancea" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 24, 2003 8:49 PM
Subject: BUG:ALTER TABLE (MySQL 4.1)
> Hi,
> I guess is as a bug in ALTER TABLE with MySQL 4.1,compiled from BK TREE on
> 2003-01-22.
> Table schema :
> CREATE TABLE cmdlivrare(IDCMD INT(9) NOT NULL PRIMARY KEY DEFAULT
2000,mUser
> CHAR(16),Dep CHAR(4),IDCLI INT(16),FactExt CHAR(20),LivrFinish
> SMALLINT(1),DataIntro DATE,DataIese
>
DATE,INDEX(Dep),INDEX(FactExt),INDEX(IDCLI),INDEX(mUser),INDEX(LivrFinish),I
> NDEX(DataIntro),INDEX(DataIese));
>
> I wish to alter this table and modify the definition of IDCMD to "IDCMD
> INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 30000"
> For this i do :
> alter table cmdlivrare modify IDCMD INT(9) AUTO_INCREMENT NOT NULL
PRIMARY
> KEY DEFAULT 30000;
>
> MySQL daemon got signal 11.
>
> MySQL log "said":
>
============================================================================
> =================================
> 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=402653184
> read_buffer_size=2093056
> sort_buffer_size=2097144
> max_used_connections=0
> max_connections=100
> threads_connected=1
> It is possible that mysqld could use up to
> key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =
> 802415 K
> bytes of memory
> Hope that's ok; if not, decrease some variables in the equation.
>
> thd=0x865b0a0
> 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=0xbe7fd6f8, backtrace may not be correct.
> Stack range sanity check OK, backtrace follows:
> 0x8114078
> 0x40039951
> 0x816785a
> 0x8167167
> 0x81807ac
> 0x8182370
> 0x8121257
> 0x8124c45
> 0x811f8a7
> 0x811f4fe
> 0x811ee79
> 0x4003376e
> 0x402687da
> New value of fp=(nil) failed sanity check, terminating stack trace!
> Please read http://www.mysql.com/doc/U/s/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
> Trying to get some variables.
> Some pointers may be invalid and cause the dump to abort...
> thd->query at 0x865e3c8 = alter table cmdlivrare modify IDCMD INT(9)
> AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 30000
> thd->thread_id=1
>
> Successfully dumped variables, if you ran with --log, take a look at the
> details of what thread 1 did to cause the crash. In some cases of really
> bad corruption, the values shown above may be invalid.
>
> The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains
> information that should help you find out what is causing the crash.
>
============================================================================
> =================================
>
> resolve_stack_dump succesfully does :
>
> 0x8114078 handle_segfault + 416
> 0x40039951 _end + 936099857
> 0x816785a _Z11pack_fieldsiR4ListI12create_fieldE + 170
> 0x8167167
>
_Z16rea_create_tableP3THDPcP24st_ha_create_informationR4ListI12create_fieldE
> jP6st_key + 883
> 0x81807ac
>
_Z18mysql_create_tableP3THDPKcS2_P24st_ha_create_informationR4ListI12create_
> fieldERS5_I3KeyEbbj + 2500
> 0x8182370
>
_Z17mysql_alter_tableP3THDPcS1_P24st_ha_create_informationP13st_table_listR4
> ListI12create_fieldERS6_I3KeyERS6_I10Alter_dropERS6 + 2736
> 0x8121257 _Z21mysql_execute_commandP3THD + 2803
> 0x8124c45 _Z11mysql_parseP3THDPcj + 221
> 0x811f8a7 _Z16dispatch_command19enum_server_commandP3THDPcj + 879
> 0x811f4fe _Z10do_commandP3THD + 110
> 0x811ee79 handle_one_connection + 813
> 0x4003376e _end + 936074798
> 0x402687da _end + 938389146
>
>
> I has the bad inspiration to compile without debug option.I try to
recompile
> now and i will try to study to see what happened.
>
> Regards,
>
> Gelu
> _____________________________________________________
> G.NET SOFTWARE COMPANY
>
> Permanent e-mail address : [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
---------------------------------------------------------------------
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
