Description:
Test 'having' fails for me in current 5.0, when I run the test suite with '--ps-protocol'.
In a standard run, this test passes.
This is a non-debug build: 'compile-pentium-max'.
Failure report:
=== cut ===
having [ fail ]
Errors are (from /M50/push-5.0/mysql-test/var/log/mysqltest-time) :
/M50/push-5.0/client/.libs/mysqltest: At line 259: unable to execute statement 'select sum(col1) from t1
group by col_t1
having col_t1 in (select sum(t2.col1) from t2
group by t2.col2, t2.col1 having t2.col1 = col_t1)': Lost connection to MySQL server during query (mysql_stmt_errno=2013 returned=1)
(the last lines may be the most important ones)
Ending Tests
Shutting-down MySQL daemon
master not cooperating with mysqladmin, will try manual kill
./mysql-test-run: line 1289: kill: (23049) - Kein passender Prozess gefunden
master refused to die. Sending SIGKILL
./mysql-test-run: line 1293: kill: (23049) - Kein passender Prozess gefunden
=== cut ===
This here should be the backtrace:
(gdb) where
#0 0x4022d691 in kill () from /lib/libc.so.6
#1 0x40153511 in pthread_kill () from /lib/libpthread.so.0
#2 0x08295dcb in write_core (sig=23093) at stacktrace.c:220
#3 0x0819ab58 in handle_segfault (sig=23093) at mysqld.cc:1904
#4 0x40156895 in __pthread_sighandler () from /lib/libpthread.so.0
#5 <signal handler called>
#6 0x0811c881 in Item_ref::fix_fields(THD*, st_table_list*, Item**) (this=0x4015af40, thd=0x8be9260, tables=0x8c0c138, reference=0x8c0caec) at item.cc:2989
#7 0x0812d969 in Item_func::fix_fields(THD*, st_table_list*, Item**) (this=0x8c0c980, thd=0x8be9260, tables=0x8c0c138, ref=0x8c0caec) at item_func.cc:311
#8 0x0814282f in Item_cond::fix_fields(THD*, st_table_list*, Item**) (this=0x8c0ca40, thd=0x8be9260, tables=0x8c0c138, ref=0x8be0b68) at sql_list.h:323
#9 0x081dfc5e in JOIN::prepare(Item***, st_table_list*, unsigned, Item*, unsigned, st_order*, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*) (this=0x8c0c890, rref_pointer_array=0x8c0c9cc, tables_init=0x0, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, group_init=0x0, having_init=0x0,
proc_param_init=0x0, select_lex_arg=0xb, unit_arg=0x8c0be20) at sql_select.cc:468
#10 0x0816fe35 in subselect_single_select_engine::prepare() (this=0x8c0c9cc) at item_subselect.cc:1130
#11 0x0816cc2f in Item_subselect::fix_fields(THD*, st_table_list*, Item**) (this=0x8c0c890, thd_param=0x0, tables=0x40158bd0, ref=0x8be9260)
at item_subselect.cc:144
#12 0x081dfc5e in JOIN::prepare(Item***, st_table_list*, unsigned, Item*, unsigned, st_order*, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*) (this=0x8c0c890, rref_pointer_array=0x8c0c9cc, tables_init=0x0, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, group_init=0x0, having_init=0x0,
proc_param_init=0x0, select_lex_arg=0xb, unit_arg=0x8c0208c) at sql_select.cc:468
#13 0x081e39d1 in mysql_select (thd=0x8be9260, rref_pointer_array=0x8c0234c, tables=0x8c0ba60, wild_num=0, fields=@0x0, conds=0x0, og_num=1, order=0x0,
group=0x8c0bc38, having=0x8c0c5d8, proc_param=0x0, select_options=310659584, result=0x8be9260, unit=0x8c0208c, select_lex=0x8c02248)
at sql_select.cc:2016
#14 0x081df545 in handle_select (thd=0x8be9260, lex=0x8c02080, result=0x8c0c698) at sql_select.cc:220
#15 0x081b462e in mysql_execute_command (thd=0x8be9260) at sql_parse.cc:2196
#16 0x0820209e in mysql_stmt_execute (thd=0x8be9260, packet=0x8bd7122 "", packet_length=0) at sql_prepare.cc:1916
#17 0x081b0964 in dispatch_command (command=COM_EXECUTE, thd=0x8be9260, packet=0x8bd7119 "E", packet_length=10) at sql_parse.cc:1478
#18 0x081b0496 in do_command (thd=0x17) at sql_parse.cc:1320
#19 0x081af94c in handle_one_connection (arg=0xa) at sql_parse.cc:1052
#20 0x40150c60 in pthread_start_thread () from /lib/libpthread.so.0
(gdb)
Latest changeset on my PC:
ChangeSet@1.1738, 2004-12-14 13:41:32+03:00, gluh@gluh.mysql.r18.ru
Fix for bug #7223: information_schema: error in "views"
The error is older, as I got it already yesterday but did not yet report.
How to repeat:
Run the test suite with '--ps-protocol'.
Description: Test 'having' fails for me in current 5.0, when I run the test suite with '--ps-protocol'. In a standard run, this test passes. This is a non-debug build: 'compile-pentium-max'. Failure report: === cut === having [ fail ] Errors are (from /M50/push-5.0/mysql-test/var/log/mysqltest-time) : /M50/push-5.0/client/.libs/mysqltest: At line 259: unable to execute statement 'select sum(col1) from t1 group by col_t1 having col_t1 in (select sum(t2.col1) from t2 group by t2.col2, t2.col1 having t2.col1 = col_t1)': Lost connection to MySQL server during query (mysql_stmt_errno=2013 returned=1) (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon master not cooperating with mysqladmin, will try manual kill ./mysql-test-run: line 1289: kill: (23049) - Kein passender Prozess gefunden master refused to die. Sending SIGKILL ./mysql-test-run: line 1293: kill: (23049) - Kein passender Prozess gefunden === cut === This here should be the backtrace: (gdb) where #0 0x4022d691 in kill () from /lib/libc.so.6 #1 0x40153511 in pthread_kill () from /lib/libpthread.so.0 #2 0x08295dcb in write_core (sig=23093) at stacktrace.c:220 #3 0x0819ab58 in handle_segfault (sig=23093) at mysqld.cc:1904 #4 0x40156895 in __pthread_sighandler () from /lib/libpthread.so.0 #5 <signal handler called> #6 0x0811c881 in Item_ref::fix_fields(THD*, st_table_list*, Item**) (this=0x4015af40, thd=0x8be9260, tables=0x8c0c138, reference=0x8c0caec) at item.cc:2989 #7 0x0812d969 in Item_func::fix_fields(THD*, st_table_list*, Item**) (this=0x8c0c980, thd=0x8be9260, tables=0x8c0c138, ref=0x8c0caec) at item_func.cc:311 #8 0x0814282f in Item_cond::fix_fields(THD*, st_table_list*, Item**) (this=0x8c0ca40, thd=0x8be9260, tables=0x8c0c138, ref=0x8be0b68) at sql_list.h:323 #9 0x081dfc5e in JOIN::prepare(Item***, st_table_list*, unsigned, Item*, unsigned, st_order*, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*) (this=0x8c0c890, rref_pointer_array=0x8c0c9cc, tables_init=0x0, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0xb, unit_arg=0x8c0be20) at sql_select.cc:468 #10 0x0816fe35 in subselect_single_select_engine::prepare() (this=0x8c0c9cc) at item_subselect.cc:1130 #11 0x0816cc2f in Item_subselect::fix_fields(THD*, st_table_list*, Item**) (this=0x8c0c890, thd_param=0x0, tables=0x40158bd0, ref=0x8be9260) at item_subselect.cc:144 #12 0x081dfc5e in JOIN::prepare(Item***, st_table_list*, unsigned, Item*, unsigned, st_order*, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*) (this=0x8c0c890, rref_pointer_array=0x8c0c9cc, tables_init=0x0, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0xb, unit_arg=0x8c0208c) at sql_select.cc:468 #13 0x081e39d1 in mysql_select (thd=0x8be9260, rref_pointer_array=0x8c0234c, tables=0x8c0ba60, wild_num=0, fields=@0x0, conds=0x0, og_num=1, order=0x0, group=0x8c0bc38, having=0x8c0c5d8, proc_param=0x0, select_options=310659584, result=0x8be9260, unit=0x8c0208c, select_lex=0x8c02248) at sql_select.cc:2016 #14 0x081df545 in handle_select (thd=0x8be9260, lex=0x8c02080, result=0x8c0c698) at sql_select.cc:220 #15 0x081b462e in mysql_execute_command (thd=0x8be9260) at sql_parse.cc:2196 #16 0x0820209e in mysql_stmt_execute (thd=0x8be9260, packet=0x8bd7122 "", packet_length=0) at sql_prepare.cc:1916 #17 0x081b0964 in dispatch_command (command=COM_EXECUTE, thd=0x8be9260, packet=0x8bd7119 "E", packet_length=10) at sql_parse.cc:1478 #18 0x081b0496 in do_command (thd=0x17) at sql_parse.cc:1320 #19 0x081af94c in handle_one_connection (arg=0xa) at sql_parse.cc:1052 #20 0x40150c60 in pthread_start_thread () from /lib/libpthread.so.0 (gdb) Latest changeset on my PC: ChangeSet@1.1738, 2004-12-14 13:41:32+03:00, gluh@gluh.mysql.r18.ru Fix for bug #7223: information_schema: error in "views" The error is older, as I got it already yesterday but did not yet report. How to repeat: Run the test suite with '--ps-protocol'.