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

Assertion `table->read_set == &table->def_read_set' failed on updating a performance_schema table

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.0
    • Fix Version/s: 10.0.1
    • Component/s: None
    • Labels:
      None

      Description

      Query:

      UPDATE performance_schema.setup_instruments SET TIMED = 'YES' ORDER BY NAME;

      Failure:

      mysqld: 10.0-serg/sql/sql_update.cc:485: int mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, COND*,
       uint, ORDER*, ha_rows, enum_duplicates, bool, ha_rows*, ha_rows*): Assertion `table->read_set == &table->def_read_set' fa
      iled.
      [ERROR] mysqld got signal 6 ;

      #3  <signal handler called>
      #4  0x00007f16ed2ed3a5 in __GI_raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
      #5  0x00007f16ed2f0b0b in __GI_abort () at abort.c:92
      #6  0x00007f16ed2e5d4d in __GI___assert_fail (assertion=0xda16b8 "table->read_set == &table->def_read_set", file=<optimized out>, line=485, function=<optimized out>) at assert.c:81
      #7  0x00000000006c3a4c in mysql_update (thd=0x277e230, table_list=0x26375f8, fields=..., values=..., conds=0x0, order_num=1, order=0x2637ea8, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f16e0794010, updated_return=0x7f16e0794018) at 10.0-serg/sql/sql_update.cc:485
      #8  0x00000000006110eb in mysql_execute_command (thd=0x277e230) at 10.0-serg/sql/sql_parse.cc:3104
      #9  0x000000000061973c in mysql_parse (thd=0x277e230, rawbuf=0x2637478 "UPDATE performance_schema.setup_instruments SET TIMED = 'YES' ORDER BY NAME", length=75, parser_state=0x7f16e07944f0) at 10.0-serg/sql/sql_parse.cc:6056
      #10 0x000000000060c6e8 in dispatch_command (command=COM_QUERY, thd=0x277e230, packet=0x26417a1 "UPDATE performance_schema.setup_instruments SET TIMED = 'YES' ORDER BY NAME", packet_length=75) at 10.0-serg/sql/sql_parse.cc:1216
      #11 0x000000000060b8e1 in do_command (thd=0x277e230) at 10.0-serg/sql/sql_parse.cc:945
      #12 0x0000000000710a2c in do_handle_one_connection (thd_arg=0x277e230) at 10.0-serg/sql/sql_connect.cc:1254
      #13 0x00000000007103fc in handle_one_connection (arg=0x277e230) at 10.0-serg/sql/sql_connect.cc:1168
      #14 0x0000000000c5db93 in pfs_spawn_thread (arg=0x2755e60) at 10.0-serg/storage/perfschema/pfs.cc:1800
      #15 0x00007f16ee027efc in start_thread (arg=0x7f16e0795700) at pthread_create.c:304
      #16 0x00007f16ed39a59d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      bzr branch: 10.0-serg
      bzr version-info
      revision-id: sergii@pisem.net-20121105114017-is3ogac6l5k8345j
      date: 2012-11-05 12:40:17 +0100
      revno: 3475

      Not reproducible on mysql-server/5.6 revno 4229 and maria/5.5 revno 3567.
      No visible problems on a non-debug build.

        Attachments

          Activity

            People

            • Assignee:
              serg Sergei Golubchik
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: