lenz@thebe:/mypool/space/tmp/mysql-5.1.35-snapshot20090630/mysql-test> ./mysql-test-run gis.test subselect_gis.test Logging: ./mysql-test-run gis.test subselect_gis.test 090723 12:03:15 [Warning] Forcing shutdown of 1 plugins MySQL Version 5.1.35 Checking supported features... - skipping ndbcluster, mysqld not compiled with ndbcluster - SSL connections supported Collecting tests... vardir: /mypool/space/tmp/mysql-5.1.35-snapshot20090630/mysql-test/var Checking leftover processes... - found old pid 30193 in 'mysqld.1.pid', killing it... process did not exist! Removing old var directory... Creating var directory '/mypool/space/tmp/mysql-5.1.35-snapshot20090630/mysql-test/var'... Installing system database... Using server port 21089 ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ worker[1] Using MTR_BUILD_THREAD 250, with reserved ports 12500..12509 main.gis [ pass ] 2608 main.subselect_gis [ fail ] Test ended at 2009-07-23 12:03:28 CURRENT_TEST: main.subselect_gis mysqltest: At line 12: query 'select City from t1 where (select intersects(GeomFromText(AsText(Location)),GeomFromText('Polygon((2 50, 2.5 50, 2.5 47, 2 47, 2 50))'))=0)' failed: 2013: Lost connection to MySQL server during query The result from queries just before the failure was: drop table if exists t1; create table t1(City VARCHAR(30),Location geometry); insert into t1 values("Paris",GeomFromText('POINT(2.33 48.87)')); - saving '/mypool/space/tmp/mysql-5.1.35-snapshot20090630/mysql-test/var/log/main.subselect_gis/' to '/mypool/space/tmp/mysql-5.1.35-snapshot20090630/mysql-test/var/log/main.subselect_gis/' - found 'core.30400' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/mypool/space/tmp/mysql-5.1.35-snapshot20090630/sql/mysqld' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- warning: Can't read pathname for load map: Input/output error. Core was generated by `/mypool/space/tmp/mysql-5.1.35-snapshot20090630/sql/mysqld --defaults-group-suf'. Program terminated with signal 11, Segmentation fault. [New process 30433] [New process 30400] [New process 30402] #0 0xffffe430 in __kernel_vsyscall () #0 0xffffe430 in __kernel_vsyscall () #1 0xb7f67cf8 in pthread_kill () from /lib/libpthread.so.0 #2 0x084b0e7b in my_write_core (sig=11) at stacktrace.c:310 #3 0x08215ae0 in handle_segfault (sig=11) at mysqld.cc:2536 #4 #5 0x083705d4 in gcalc_scan_iterator::intersection_scan (this=0x87c2ea0) at gcalc_slicescan.h:226 #6 0x08371188 in gcalc_scan_iterator::normal_scan (this=0x87c2ea0) at gcalc_slicescan.cc:424 #7 0x08371653 in gcalc_function::find_function (this=0x87c2f18, scan_it=@0x87c2ea0) at gcalc_slicescan.h:252 #8 0x081dde00 in Item_func_spatial_rel::val_int (this=0x87c2d88) at item_geofunc.cc:682 #9 0x081a2aee in Arg_comparator::compare_int_signed (this=0x87c3028) at item_cmpfunc.cc:1260 #10 0x081aa2e2 in Item_func_eq::val_int (this=0x87c2fb0) at item_cmpfunc.h:71 #11 0x082812d4 in JOIN::optimize (this=0x87ccb10) at sql_select.cc:6060 #12 0x08283c7c in mysql_select (thd=0x8771b00, rref_pointer_array=0x8772f60, tables=0x87c21f8, wild_num=0, fields=@0x8772efc, conds=0x87c31a8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0x87c32d0, unit=0x8772bf8, select_lex=0x8772e68) at sql_select.cc:2364 #13 0x082895ce in handle_select (thd=0x8771b00, lex=0x8772b9c, result=0x87c32d0, setup_tables_done_option=0) at sql_select.cc:268 #14 0x0821f9e6 in execute_sqlcom_select (thd=0x8771b00, all_tables=0x87c21f8) at sql_parse.cc:5009 #15 0x08224407 in mysql_execute_command (thd=0x8771b00) at sql_parse.cc:2211 #16 0x08227b56 in mysql_parse (thd=0x8771b00, inBuf=0x87c1fd0 "select City from t1 where (select\nintersects(GeomFromText(AsText(Location)),GeomFromText('Polygon((2 50, 2.5\n50, 2.5 47, 2 47, 2 50))'))=0)", length=139, found_semicolon=0xb738c330) at sql_parse.cc:5929 #17 0x08229d30 in dispatch_command (command=COM_QUERY, thd=0x8771b00, packet=0x87bdfb1 "select City from t1 where (select\nintersects(GeomFromText(AsText(Location)),GeomFromText('Polygon((2 50, 2.5\n50, 2.5 47, 2 47, 2 50))'))=0)", packet_length=139) at sql_parse.cc:1216 #18 0x0822a57f in do_command (thd=0x8771b00) at sql_parse.cc:857 #19 0x0821bd86 in handle_one_connection (arg=0x8771b00) at sql_connect.cc:1115 #20 0xb7f63175 in start_thread () from /lib/libpthread.so.0 #21 0xb7d71dae in clone () from /lib/libc.so.6 Thread 3 (process 30402): #0 0xffffe430 in __kernel_vsyscall () #1 0xb7f6adea in do_sigwait () from /lib/libpthread.so.0 #2 0xb7f6ae8f in sigwait () from /lib/libpthread.so.0 #3 0x082154b4 in signal_hand (arg=0x0) at mysqld.cc:2738 #4 0xb7f63175 in start_thread () from /lib/libpthread.so.0 #5 0xb7d71dae in clone () from /lib/libc.so.6 Thread 2 (process 30400): #0 0xffffe430 in __kernel_vsyscall () #1 0xb7d6aed1 in select () from /lib/libc.so.6 #2 0x082139fa in handle_connections_sockets (arg=0x0) at mysqld.cc:4971 #3 0x082185fc in main (argc=384, argv=0x0) at mysqld.cc:4470 Thread 1 (process 30433): #0 0xffffe430 in __kernel_vsyscall () #1 0xb7f67cf8 in pthread_kill () from /lib/libpthread.so.0 #2 0x084b0e7b in my_write_core (sig=11) at stacktrace.c:310 #3 0x08215ae0 in handle_segfault (sig=11) at mysqld.cc:2536 #4 #5 0x083705d4 in gcalc_scan_iterator::intersection_scan (this=0x87c2ea0) at gcalc_slicescan.h:226 #6 0x08371188 in gcalc_scan_iterator::normal_scan (this=0x87c2ea0) at gcalc_slicescan.cc:424 #7 0x08371653 in gcalc_function::find_function (this=0x87c2f18, scan_it=@0x87c2ea0) at gcalc_slicescan.h:252 #8 0x081dde00 in Item_func_spatial_rel::val_int (this=0x87c2d88) at item_geofunc.cc:682 #9 0x081a2aee in Arg_comparator::compare_int_signed (this=0x87c3028) at item_cmpfunc.cc:1260 #10 0x081aa2e2 in Item_func_eq::val_int (this=0x87c2fb0) at item_cmpfunc.h:71 #11 0x082812d4 in JOIN::optimize (this=0x87ccb10) at sql_select.cc:6060 #12 0x08283c7c in mysql_select (thd=0x8771b00, rref_pointer_array=0x8772f60, tables=0x87c21f8, wild_num=0, fields=@0x8772efc, conds=0x87c31a8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0x87c32d0, unit=0x8772bf8, select_lex=0x8772e68) at sql_select.cc:2364 #13 0x082895ce in handle_select (thd=0x8771b00, lex=0x8772b9c, result=0x87c32d0, setup_tables_done_option=0) at sql_select.cc:268 #14 0x0821f9e6 in execute_sqlcom_select (thd=0x8771b00, all_tables=0x87c21f8) at sql_parse.cc:5009 #15 0x08224407 in mysql_execute_command (thd=0x8771b00) at sql_parse.cc:2211 #16 0x08227b56 in mysql_parse (thd=0x8771b00, inBuf=0x87c1fd0 "select City from t1 where (select\nintersects(GeomFromText(AsText(Location)),GeomFromText('Polygon((2 50, 2.5\n50, 2.5 47, 2 47, 2 50))'))=0)", length=139, found_semicolon=0xb738c330) at sql_parse.cc:5929 #17 0x08229d30 in dispatch_command (command=COM_QUERY, thd=0x8771b00, packet=0x87bdfb1 "select City from t1 where (select\nintersects(GeomFromText(AsText(Location)),GeomFromText('Polygon((2 50, 2.5\n50, 2.5 47, 2 47, 2 50))'))=0)", packet_length=139) at sql_parse.cc:1216 #18 0x0822a57f in do_command (thd=0x8771b00) at sql_parse.cc:857 #19 0x0821bd86 in handle_one_connection (arg=0x8771b00) at sql_connect.cc:1115 #20 0xb7f63175 in start_thread () from /lib/libpthread.so.0 #21 0xb7d71dae in clone () from /lib/libc.so.6 ------------------------------------------------------------ The servers were restarted 0 times Spent 2.608 of 17 seconds executing testcases Failed 1/2 tests, 50.00% were successful. Failing test(s): main.subselect_gis The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html mysql-test-run: *** ERROR: there were failing test cases