At 14:26 18/03/2003 -0500, Mark M. Ito wrote:
Hi,
>Indrek,
>
>I upgraded to 3.23.56 using the rpm's. Now I get
>
> > mysql -uroot test < create.sql
> > mysql -uroot test < insert.sql
> > mysql -uroot test < insert.sql
>ERROR 2013 at line 1: Lost connection to MySQL server during query
> > mysql -uroot test < insert.sql
> > mysql -uroot test < insert.sql
Yes you are right I was be able to repeat it with our 3.23.56
distribution tarball, below the backtrace. Thanks you for the
debug report:
/usr/local/mysql/libexec/mysqld: ready for connections
[New Thread 2051 (LWP 5987)]
[New Thread 3076 (LWP 5989)]
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 3076 (LWP 5989)]
0x082d06a8 in fn_format (to=0xbf3f900c "",
name=0x8464be8
"/usr/local/mysql/var/test/GPP_DC_WIRE_sector1_reg2.MYI", dsk=0x82e6071 "",
form=0x8306c1a ".MYD", flag=6) at mf_format.c:52
52 DBUG_ENTER("fn_format");
Current language: auto; currently c
(gdb) backtrace
#0 0x082d06a8 in fn_format (to=0xbf3f900c "",
name=0x8464be8
"/usr/local/mysql/var/test/GPP_DC_WIRE_sector1_reg2.MYI", dsk=0x82e6071 "",
form=0x8306c1a ".MYD", flag=6) at mf_format.c:52
#1 0x082a85ec in mi_open_datafile (info=0x0, share=0x84527d0)
at mi_open.c:1012
#2 0x082a5f62 in mi_open (
name=0xbf3fee3c "./test/GPP_DC_WIRE_sector1_reg2", mode=2,
open_flags=2) at mi_open.c:371
#3 0x08138014 in ha_myisam::open(char const*, int, unsigned) (
this=0x83a9ff8, name=0xbf3fee3c "./test/GPP_DC_WIRE_sector1_reg2",
mode=2, test_if_locked=2) at ha_myisam.cc:211
#4 0x08136507 in handler::ha_open(char const*, int, int) (
this=0x83a9ff8, name=0xbf3fee3c "./test/GPP_DC_WIRE_sector1_reg2",
mode=2, test_if_locked=2) at handler.cc:552
#5 0x08104584 in openfrm(char const*, char const*, unsigned, unsigned,
unsigned, st_table*) (name=0xbf3ff0cc "./test/GPP_DC_WIRE_sector1_reg2",
alias=0x83a5f88 "GPP_DC_WIRE_sector1_reg2", db_stat=39, prgflag=44,
ha_open_flags=0, outparam=0x83adfa0) at table.cc:546
#6 0x08100b38 in open_unireg_entry (thd=0x83ab6c8, entry=0x83adfa0,
db=0x83a7f60 "test", name=0x83a5f58 "GPP_DC_WIRE_sector1_reg2",
alias=0x83a5f88 "GPP_DC_WIRE_sector1_reg2") at sql_base.cc:1270
#7 0x080ffd74 in open_table(THD*, char const*, char const*, char const*,
bool*) (thd=0x83ab6c8, db=0x83a7f60 "test",
---Type <return> to continue, or q <return> to quit---
table_name=0x83a5f58 "GPP_DC_WIRE_sector1_reg2",
alias=0x83a5f88 "GPP_DC_WIRE_sector1_reg2", refresh=0xbf3ff597)
at sql_base.cc:853
#8 0x08100f77 in open_ltable(THD*, st_table_list*, thr_lock_type) (
thd=0x83ab6c8, table_list=0x83a5fa8,
lock_type=TL_WRITE_CONCURRENT_INSERT) at sql_base.cc:1407
#9 0x08116335 in mysql_insert(THD*, st_table_list*, List<Item>&,
List<List<Item> >&, enum_duplicates, thr_lock_type) (thd=0x83ab6c8,
table_list=0x83a5fa8, fields=@0x83ab8f0, values_list=@0x83ab854,
duplic=DUP_ERROR, lock_type=TL_WRITE_CONCURRENT_INSERT)
at sql_insert.cc:146
#10 0x080eda27 in mysql_execute_command() () at sql_parse.cc:1601
#11 0x080ef9a3 in mysql_parse(THD*, char*, unsigned) (thd=0x83ab6c8,
inBuf=0x83b89d8 "INSERT GPP_DC_WIRE_sector1_reg2 ( minRunSource,
maxRunSource, author, comment, v_0001, v_0002, v_0003, v_0004, v_0005,
v_0006, v_0007, v_0008, v_0009, v_0010, v_0011, v_0012, v_0013, v_0014,
v_0015, v"..., length=39310) at sql_parse.cc:2386
#12 0x080ebb70 in do_command(THD*) (thd=0x83ab6c8) at sql_parse.cc:840
#13 0x080eaedb in handle_one_connection(void*) (arg=0xbf3f7d68)
at sql_parse.cc:558
#14 0x4002a1b0 in pthread_start_thread () from /lib/libpthread.so.0
#15 0x4002a22f in pthread_start_thread_event () from /lib/libpthread.so.0
(gdb)
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Miguel Angel Solórzano <miguel@stripped>
/ /|_/ / // /\ \/ /_/ / /__ São Paulo - Brazil
/_/ /_/\_, /___/\___\_\___/
<___/ www.mysql.com
