Details
Description
Version: '5.5.31-MariaDB-valgrind-max-debug-log' socket: '/data/repo/bzr/5.5/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution 130514 3:43:29 [Note] Event Scheduler: scheduler thread started with id 8 mysqld: /home/elenst/bzr/5.5/sql/sql_cache.cc:1211: void Query_cache::end_of_result(THD*): Assertion `0' failed. 130514 3:43:29 [ERROR] mysqld got signal 6 ;
#7 0x00007f1574b1d192 in __GI___assert_fail (assertion=0xd615d2 "0", file=0xd61058 "/home/elenst/bzr/5.5/sql/sql_cache.cc", line=1211, function=0xd63b40 "void Query_cache::end_of_result(THD*)") at assert.c:103 #8 0x00000000005c7837 in Query_cache::end_of_result (this=0x14fd520, thd=0x7f1540001cc0) at /home/elenst/bzr/5.5/sql/sql_cache.cc:1211 #9 0x000000000090e66b in sp_instr_stmt::execute (this=0x7f1544002c98, thd=0x7f1540001cc0, nextp=0x7f1565ef34f8) at /home/elenst/bzr/5.5/sql/sp_head.cc:3134 #10 0x000000000090a22a in sp_head::execute (this=0x7f15440033b8, thd=0x7f1540001cc0, merge_da_on_success=true) at /home/elenst/bzr/5.5/sql/sp_head.cc:1428 #11 0x000000000090c0b8 in sp_head::execute_procedure (this=0x7f15440033b8, thd=0x7f1540001cc0, args=0x7f1565ef38a0) at /home/elenst/bzr/5.5/sql/sp_head.cc:2185 #12 0x00000000006fad17 in Event_job_data::execute (this=0x7f1565ef3d10, thd=0x7f1540001cc0, drop=false) at /home/elenst/bzr/5.5/sql/event_data_objects.cc:1433 #13 0x000000000094ec25 in Event_worker_thread::run (this=0x7f1565ef3e4f, thd=0x7f1540001cc0, event=0x7f1540001bf0) at /home/elenst/bzr/5.5/sql/event_scheduler.cc:317 #14 0x000000000094ea9d in event_worker_thread (arg=0x7f1540001bf0) at /home/elenst/bzr/5.5/sql/event_scheduler.cc:274 #15 0x0000000000977c3e in pfs_spawn_thread (arg=0x7f154000b190) at /home/elenst/bzr/5.5/storage/perfschema/pfs.cc:1015 #16 0x00007f15758ede9a in start_thread (arg=0x7f1565ef4700) at pthread_create.c:308 #17 0x00007f1574be1cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f51240031d8): select * from t28953 Connection ID (thread ID): 10 Status: NOT_KILLED
It's a race condition repeatable with some probability by running test rpl.rpl_events with query cache enabled:
perl ./mtr rpl.rpl_events --mysqld=--query-cache-size=1048576 --mysqld=--binlog-format=row --repeat=20
On my machine 3..5 attempts is usually enough to hit the failure.
bzr version-info
revision-id: sergii@pisem.net-20130513141139-vl0ehunm2bwgx1s9 revno: 3764 branch-nick: 5.5
1202: if (header->result() == 0)
1203: {
1204: DBUG_PRINT("error", ("End of data with no result blocks; "
1205: "Query '%s' removed from cache.", header->query()));
1206: /*
1207: Extra safety: empty result should not happen in the normal call
1208: to this function. In the release version that query should be ignored
1209: and removed from QC.
1210: */
1211: DBUG_ASSERT(0);
1212: free_query(query_block);
1213: unlock();
1214: DBUG_VOID_RETURN;
1215: }
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Problem was in absence net.vio so QC can't intercept data.
fix committed for review.