[MDEV-8163] Table causes maria to crash repeatedly. Created: 2015-05-14  Updated: 2016-09-22  Resolved: 2016-09-22

Status: Closed
Project: MariaDB Server
Component/s: GIS, Storage Engine - MyISAM
Affects Version/s: 10.1.4
Fix Version/s: 10.1.9

Type: Bug Priority: Major
Reporter: Mark Dhas Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: verified
Environment:

Ubuntu running Trusty. Laptop dev box nothing terribly special.

Attachments: File geo.frm    
Issue Links:
Relates
relates to MDEV-8992 MariaDB crashes when accessing table ... Closed
Sprint: 10.1.18

 Description   

When accessing mysql without using the -A flag any query I would execute would fail immediately. The error I get using the console is:

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")

Any select doesn't work, even a

select 1;

However I could see the databases. Use any of the databases. Serg suggested the following:

[14:53:14] serg: so, try this. run mysql -A.
[14:53:29] serg: and then, say, SHOW CREATE TABLE for every table in this your database
[14:53:57] serg: when you get a crash - you know what frm causes it, create a bug report on mariadb.org/jira and attach
this frm file
[14:54:03] serg: 10.1.5 won't crash on it

FYI the date of this conversation was the 14th of May 2015.

I'm providing the url to the syslog information that I was getting at the time of the issue.

http://pastebin.com/s9nMQqzB

Hopefully this helps.

 Comments   
Comment by Elena Stepanova [ 2015-05-18 ]

Thanks for the report.

Stack trace from 10.1 commit 476dfb16

 
#3  <signal handler called>
 
#4  0x00007fb12273b31c in gis_field_options_read (buf=0x0, buf_len=520471232, st_type=0x7fb121fcbe98, precision=0x7fb121fcbe8c, scale=0x7fb121fcbe90, srid=0x7fb121fcbe94) at 10.1/sql/field.cc:7929
 
#5  0x00007fb12260aba8 in TABLE_SHARE::init_from_binary_frm_image (this=0x7fb11f135688, thd=0x7fb1037ef070, write=false, frm_image=0x7fb0fc679070 "\376\001\t\t\003", frm_length=8864) at 10.1/sql/table.cc:1503
 
#6  0x00007fb122608235 in open_table_def (thd=0x7fb1037ef070, share=0x7fb11f135688, flags=11) at 10.1/sql/table.cc:650
 
#7  0x00007fb1226dd62b in tdc_acquire_share (thd=0x7fb1037ef070, db=0x7fb0fc666740 "test", table_name=0x7fb0fc666128 "geo", key=0x7fb0fc6665a1 "test", key_length=9, hash_value=474670071, flags=3, out_table=0x7fb121fcc5c8) at 10.1/sql/table_cache.cc:639
 
#8  0x00007fb1224bc7db in open_table (thd=0x7fb1037ef070, table_list=0x7fb0fc666160, ot_ctx=0x7fb121fcc9f0) at 10.1/sql/sql_base.cc:2411
 
#9  0x00007fb1224bf500 in open_and_process_table (thd=0x7fb1037ef070, lex=0x7fb1037f2d28, tables=0x7fb0fc666160, counter=0x7fb121fccac4, flags=1024, prelocking_strategy=0x7fb121fcca70, has_prelocking_list=false, ot_ctx=0x7fb121fcc9f0) at 10.1/sql/sql_base.cc:4016
 
#10 0x00007fb1224c05f5 in open_tables (thd=0x7fb1037ef070, options=..., start=0x7fb121fccab0, counter=0x7fb121fccac4, flags=1024, prelocking_strategy=0x7fb121fcca70) at 10.1/sql/sql_base.cc:4526
 
#11 0x00007fb12250080f in open_tables (thd=0x7fb1037ef070, tables=0x7fb121fccab0, counter=0x7fb121fccac4, flags=1024) at 10.1/sql/sql_base.h:499
 
#12 0x00007fb1225a86c1 in mysqld_show_create (thd=0x7fb1037ef070, table_list=0x7fb0fc666160) at 10.1/sql/sql_show.cc:1120
 
#13 0x00007fb122525e81 in mysql_execute_command (thd=0x7fb1037ef070) at 10.1/sql/sql_parse.cc:3649
 
#14 0x00007fb122531234 in mysql_parse (thd=0x7fb1037ef070, rawbuf=0x7fb0fc666088 "show create table geo", length=21, parser_state=0x7fb121fce200) at 10.1/sql/sql_parse.cc:7161
 
#15 0x00007fb1225201e1 in dispatch_command (command=COM_QUERY, thd=0x7fb1037ef070, packet=0x7fb103793071 "show create table geo", packet_length=21) at 10.1/sql/sql_parse.cc:1462
 
#16 0x00007fb12251efb1 in do_command (thd=0x7fb1037ef070) at 10.1/sql/sql_parse.cc:1090
 
#17 0x00007fb122650cb3 in do_handle_one_connection (thd_arg=0x7fb1037ef070) at 10.1/sql/sql_connect.cc:1347
 
#18 0x00007fb1226509f8 in handle_one_connection (arg=0x7fb1037ef070) at 10.1/sql/sql_connect.cc:1258
 
#19 0x00007fb121c08b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#20 0x00007fb11fc9d95d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

Comment by Elena Stepanova [ 2015-10-27 ]

Hopefully it will be fixed in the scope of MDEV-8992

Comment by Alexey Botchkov [ 2016-09-22 ]

I belive this one was already fixed.

Comment by Elena Stepanova [ 2016-09-22 ]

Fixed in 10.1.9 by the patch for MDEV-8992.

Generated at Thu Feb 08 07:25:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.