Assertion `! is_set() || m_can_overwrite_status' failed in sql_error.cc:521 | sig6 in Diagnostics_area::set_error_status
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Won't Fix
|
Medium
|
Unassigned | |||
5.5 |
New
|
Medium
|
Unassigned | |||
5.6 |
New
|
Medium
|
Unassigned | |||
5.7 |
New
|
Medium
|
Unassigned |
Bug Description
2013-12-26 06:43:22 27565 [Note] /ssd/Percona-
Version: '5.6.14-
2013-12-26 06:43:22 27565 [Note] Event Scheduler: scheduler thread started with id 1
mysqld: /bzr/5.
19:44:07 UTC - mysqld got signal 6 ;
[...]
key_buffer_
read_buffer_
max_used_
max_threads=501
thread_count=2
connection_count=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x368fc00
no longer affects: | percona-xtradb-cluster |
Changed in percona-server: | |
status: | New → Confirmed |
importance: | Undecided → High |
assignee: | nobody → Roel Van de Paar (roel11) |
tags: | added: upstream |
tags: | removed: qablock |
Some Occurrences:
Query (7f94600162d0): UPDATE `table100_ innodb_ dynamic_ int` t1, `view_table100_ innodb_ default_ key_pk_ parts_2_ int_autoinc` t2 SET t1.`c26` = NULL WHERE t1.`c23` > 4513169776578658304
Connection ID (thread ID): 6
Status: NOT_KILLED
Query (7f0204014250): SET @id:=(SELECT id FROM INFORMATION_ SCHEMA. PROCESSLIST WHERE ID<>CONNECTION_ID() AND STATE<>'killed' AND TIME>90 ORDER BY TIME DESC LIMIT 1)
Connection ID (thread ID): 5
Status: NOT_KILLED
Assert is sporadic, SINGLE THREADED REPRODUCIBLE, seen about 1% of the time when executing about 1.1K lines of SQL.
Always on queries above, at least as far as that testcase is concerned.