Hi Sergei,
I just finish to compile the latest source code (Jan 25) from
http://mysql.bkbits.net/mysql-4.1
The problem persist.
Georg has right i was trying to alter table when the primary key was already
defined and i was trying:
ALTER TABLE cmdlivrare MODIFY IDCMD INT(9) AUTO_INCREMENT;
>From mysqld.log:
thd=0x865c0e0
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=0xbe7fd7d8, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x8114188
0x40039951
0x8167b06
0x8167413
0x8180a14
0x81825d8
0x812138f
0x8124d7d
0x811f9a7
0x811f612
0x811ef8d
0x4003376e
0x402687da
New value of fp=(nil) failed sanity check, terminating stack trace!
.......
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x865f408 = alter table cmdlivrare modify IDCMD INT(9)
AUTO_INCREMENT
...and from resolve_stack_dump:
0x8114188 handle_segfault + 416
0x40039951 _end + 936095697
0x8167b06 _Z11pack_fieldsiR4ListI12create_fieldE + 170
0x8167413
_Z16rea_create_tableP3THDPcP24st_ha_create_informationR4ListI12create_fieldE
jP6st_key + 883
0x8180a14
_Z18mysql_create_tableP3THDPKcS2_P24st_ha_create_informationR4ListI12create_
fieldERS5_I3KeyEbbj + 2500
0x81825d8
_Z17mysql_alter_tableP3THDPcS1_P24st_ha_create_informationP13st_table_listR4
ListI12create_fieldERS6_I3KeyERS6_I10Alter_dropERS6 + 2736
0x812138f _Z21mysql_execute_commandP3THD + 2803
0x8124d7d _Z11mysql_parseP3THDPcj + 221
0x811f9a7 _Z16dispatch_command19enum_server_commandP3THDPcj + 859
0x811f612 _Z10do_commandP3THD + 110
0x811ef8d handle_one_connection + 813
0x4003376e _end + 936070638
0x402687da _end + 938384986
Best regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Sergei Golubchik" <[EMAIL PROTECTED]>
To: "Gelu Gogancea" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, January 25, 2003 3:48 AM
Subject: Re: BUG:ALTER TABLE (MySQL 4.1)
> Hi!
>
> On Jan 24, Gelu Gogancea wrote:
> > 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;
>
> No crash for me on a recent bk tree (Jan 24, that is).
> Try a fresh pull.
>
> Regards,
> Sergei
>
> --
> MySQL Development Team
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
> /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
> <___/
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
