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

LP:998028 - Server crashes on normal shutdown in closefrm after executing a query from MyISAM table

Details

    Description

      #4  <signal handler called>
      #5  0x082fe139 in closefrm (table=0x937bbd8, free_share=true) at table.cc:2019
      #6  0x082e7acd in intern_close_table (table=0x937bbd8) at sql_base.cc:793
      #7  0x082e7b73 in free_cache_entry (table=0x937bbd8) at sql_base.cc:815
      #8  0x08738d04 in my_hash_delete (hash=0x8a63720, 
          record=0x937bbd8 "\270\302\067\tp\a9\t\260\304\070\t8\334\067\t") at hash.c:566
      #9  0x082e7daf in close_cached_tables (thd=0x0, tables=0x0, have_lock=false, 
          wait_for_refresh=false, wait_for_placeholders=false) at sql_base.cc:877
      #10 0x082e6430 in table_cache_free () at sql_base.cc:142
      #11 0x082916ca in clean_up (print_message=true) at mysqld.cc:1367
      #12 0x0829151f in unireg_end () at mysqld.cc:1307
      #13 0x082914a7 in kill_server (sig_ptr=0x0) at mysqld.cc:1242
      #14 0x082914be in kill_server_thread (arg=0xaeaf7388) at mysqld.cc:1270
      #15 0xb779fb25 in start_thread () from /lib/libpthread.so.0

      maria-5.1
      bzr version-info
      revision-id: <email address hidden>
      date: 2012-04-24 17:29:03 +0200
      revno: 3147

      Also reproducible on maria-5.2 revno 3149.
      Could not reproduce on maria-5.3 revno 3519, maria-5.5 revno 3397, mysql-5.1.63.

      # Test case
      # If you use the client,
      # - start server with --core or --log-error;
      # - execute SQL below;
      # - stop server using mysqladmin shutdown (or sending SIGTERM).
      # if you run it via MTR, just make sure you don't have a result file with the same name as the test file.
       
      DROP TABLE IF EXISTS t1;
      CREATE TABLE t1 (a INT, b VARCHAR(1), KEY(b,a)) ENGINE=MyISAM;
      INSERT INTO t1 VALUES
      (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),
      (6,'f'),(7,'g'),(8,'h'),(NULL,'i');
      SELECT MIN(a), b FROM t1 WHERE a=7 OR b='z' GROUP BY b;

      Attachments

        Activity

          elenst Elena Stepanova created issue -
          ratzpo Rasmus Johansson (Inactive) made changes -
          Field Original Value New Value
          Labels Launchpad
          ratzpo Rasmus Johansson (Inactive) made changes -
          Labels Launchpad MariaDB_5.1
          ratzpo Rasmus Johansson (Inactive) made changes -
          Labels MariaDB_5.1 Launchpad MariaDB_5.1
          ratzpo Rasmus Johansson (Inactive) made changes -
          Fix Version/s Maria 5.1 [ 11600 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Key IMT-7757 MDEV-729
          Project ImportTest [ 10200 ] MariaDB Development [ 10000 ]
          Workflow jira [ 21406 ] defaullt [ 21573 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 5.5.29 [ 11701 ]
          Fix Version/s 5.3.10 [ 11500 ]
          Fix Version/s 5.2.13 [ 10800 ]
          Fix Version/s 5.1.65 [ 10801 ]
          serg Sergei Golubchik made changes -
          Labels Launchpad MariaDB_5.1 Launchpad
          elenst Elena Stepanova made changes -
          Fix Version/s 5.3.10 [ 11500 ]
          Fix Version/s 5.5.29 [ 11701 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 5.1.67 [ 12100 ]
          Fix Version/s 5.1.66 [ 10801 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 5.2.14 [ 12101 ]
          Fix Version/s 5.2.13 [ 10800 ]
          serg Sergei Golubchik made changes -
          Description #4 <signal handler called>
          #5 0x082fe139 in closefrm (table=0x937bbd8, free_share=true) at table.cc:2019
          #6 0x082e7acd in intern_close_table (table=0x937bbd8) at sql_base.cc:793
          #7 0x082e7b73 in free_cache_entry (table=0x937bbd8) at sql_base.cc:815
          #8 0x08738d04 in my_hash_delete (hash=0x8a63720,
              record=0x937bbd8 "\270\302\067\tp\a9\t\260\304\070\t8\334\067\t") at hash.c:566
          #9 0x082e7daf in close_cached_tables (thd=0x0, tables=0x0, have_lock=false,
              wait_for_refresh=false, wait_for_placeholders=false) at sql_base.cc:877
          #10 0x082e6430 in table_cache_free () at sql_base.cc:142
          #11 0x082916ca in clean_up (print_message=true) at mysqld.cc:1367
          #12 0x0829151f in unireg_end () at mysqld.cc:1307
          #13 0x082914a7 in kill_server (sig_ptr=0x0) at mysqld.cc:1242
          #14 0x082914be in kill_server_thread (arg=0xaeaf7388) at mysqld.cc:1270
          #15 0xb779fb25 in start_thread () from /lib/libpthread.so.0

          maria-5.1
          bzr version-info
          revision-id: <email address hidden>
          date: 2012-04-24 17:29:03 +0200
          revno: 3147

          Also reproducible on maria-5.2 revno 3149.
          Could not reproduce on maria-5.3 revno 3519, maria-5.5 revno 3397, mysql-5.1.63.

          # Test case
          # If you use the client,
          # - start server with --core or --log-error;
          # - execute SQL below;
          # - stop server using mysqladmin shutdown (or sending SIGTERM).
          # if you run it via MTR, just make sure you don't have a result file with the same name as the test file.

          DROP TABLE IF EXISTS t1;
          CREATE TABLE t1 (a INT, b VARCHAR(1), KEY(b,a)) ENGINE=MyISAM;
          INSERT INTO t1 VALUES
          (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),
          (6,'f'),(7,'g'),(8,'h'),(NULL,'i');
          SELECT MIN(a), b FROM t1 WHERE a=7 OR b='z' GROUP BY b;

          # End of test case
          {noformat}
          #4 <signal handler called>
          #5 0x082fe139 in closefrm (table=0x937bbd8, free_share=true) at table.cc:2019
          #6 0x082e7acd in intern_close_table (table=0x937bbd8) at sql_base.cc:793
          #7 0x082e7b73 in free_cache_entry (table=0x937bbd8) at sql_base.cc:815
          #8 0x08738d04 in my_hash_delete (hash=0x8a63720,
              record=0x937bbd8 "\270\302\067\tp\a9\t\260\304\070\t8\334\067\t") at hash.c:566
          #9 0x082e7daf in close_cached_tables (thd=0x0, tables=0x0, have_lock=false,
              wait_for_refresh=false, wait_for_placeholders=false) at sql_base.cc:877
          #10 0x082e6430 in table_cache_free () at sql_base.cc:142
          #11 0x082916ca in clean_up (print_message=true) at mysqld.cc:1367
          #12 0x0829151f in unireg_end () at mysqld.cc:1307
          #13 0x082914a7 in kill_server (sig_ptr=0x0) at mysqld.cc:1242
          #14 0x082914be in kill_server_thread (arg=0xaeaf7388) at mysqld.cc:1270
          #15 0xb779fb25 in start_thread () from /lib/libpthread.so.0
          {noformat}
          {noformat}
          maria-5.1
          bzr version-info
          revision-id: <email address hidden>
          date: 2012-04-24 17:29:03 +0200
          revno: 3147
          {noformat}
          Also reproducible on maria-5.2 revno 3149.
          Could not reproduce on maria-5.3 revno 3519, maria-5.5 revno 3397, mysql-5.1.63.
          {noformat}
          # Test case
          # If you use the client,
          # - start server with --core or --log-error;
          # - execute SQL below;
          # - stop server using mysqladmin shutdown (or sending SIGTERM).
          # if you run it via MTR, just make sure you don't have a result file with the same name as the test file.

          DROP TABLE IF EXISTS t1;
          CREATE TABLE t1 (a INT, b VARCHAR(1), KEY(b,a)) ENGINE=MyISAM;
          INSERT INTO t1 VALUES
          (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),
          (6,'f'),(7,'g'),(8,'h'),(NULL,'i');
          SELECT MIN(a), b FROM t1 WHERE a=7 OR b='z' GROUP BY b;
          {noformat}
          serg Sergei Golubchik made changes -
          Assignee Michael Widenius [ monty ] Sergei Golubchik [ serg ]
          serg Sergei Golubchik made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 5.3.12 [ 12000 ]
          serg Sergei Golubchik made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 21573 ] MariaDB v2 [ 46469 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 46469 ] MariaDB v3 [ 64407 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 64407 ] MariaDB v4 [ 146144 ]

          People

            serg Sergei Golubchik
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.