Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8163

Table causes maria to crash repeatedly.

Details

    • 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.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8992 MariaDB crashes when accessing table with GIS features

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            mschandr Mark Dhas created issue -
            elenst Elena Stepanova added a comment -

            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

            elenst Elena Stepanova added a comment - 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
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Component/s GIS [ 10105 ]
            Assignee Sergei Golubchik [ serg ]
            Labels verified
            elenst Elena Stepanova made changes -
            Fix Version/s 10.1 [ 16100 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 60955 ] MariaDB v3 [ 65365 ]
            elenst Elena Stepanova added a comment -

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

            elenst Elena Stepanova added a comment - Hopefully it will be fixed in the scope of MDEV-8992
            elenst Elena Stepanova made changes -
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Alexey Botchkov [ holyfoot ]
            serg Sergei Golubchik made changes -
            Priority Minor [ 4 ] Major [ 3 ]
            holyfoot Alexey Botchkov made changes -
            Sprint 10.1.18 [ 98 ]
            holyfoot Alexey Botchkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            holyfoot Alexey Botchkov added a comment -

            I belive this one was already fixed.

            holyfoot Alexey Botchkov added a comment - I belive this one was already fixed.
            holyfoot Alexey Botchkov made changes -
            issue.field.resolutiondate 2016-09-22 07:46:20.0 2016-09-22 07:46:20.074
            holyfoot Alexey Botchkov made changes -
            Fix Version/s 10.1.18 [ 22110 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Cannot Reproduce [ 5 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            elenst Elena Stepanova made changes -
            Assignee Alexey Botchkov [ holyfoot ] Elena Stepanova [ elenst ]
            Resolution Cannot Reproduce [ 5 ]
            Status Closed [ 6 ] Stalled [ 10000 ]
            elenst Elena Stepanova added a comment -

            Fixed in 10.1.9 by the patch for MDEV-8992.

            elenst Elena Stepanova added a comment - Fixed in 10.1.9 by the patch for MDEV-8992 .
            elenst Elena Stepanova made changes -
            Fix Version/s 10.1.9 [ 20301 ]
            Fix Version/s 10.1.18 [ 22110 ]
            Assignee Elena Stepanova [ elenst ] Alexey Botchkov [ holyfoot ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 65365 ] MariaDB v4 [ 149174 ]

            People

              holyfoot Alexey Botchkov
              mschandr Mark Dhas
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.