[MDEV-3837] Assertion `table->read_set == &table->def_read_set' failed on updating a performance_schema table Created: 2012-11-05  Updated: 2012-12-16  Resolved: 2012-12-16

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.0
Fix Version/s: 10.0.1

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates

 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.


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