Diagnostics_area::set_error_status(THD*, uint, const char*, const char*): Assertion `! is_set() || can_overwrite_status' failed | CTAS-based | lp:1162421 regression
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL patches by Codership |
New
|
Undecided
|
Unassigned | |||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC | Status tracked in 5.6 | |||||
5.5 |
Incomplete
|
High
|
Unassigned | |||
5.6 |
Incomplete
|
High
|
Unassigned |
Bug Description
Cmdline:
perl runall-new.pl --basedir=/chip --galera=ms --grammar=
Log:
# 2013-08-06T23:07:34 [56304] Query: REPLACE INTO `table500_
sh: line 1: 55723 Aborted (core dumped) "/chip/bin/mysqld" "--no-defaults" "--basedir=/chip" "--datadir=
# 2013-08-06T23:07:34 [56304] Server crash reported at dsn dbi:mysql:
# 2013-08-06T23:07:34 [56306] Query: DROP VIEW IF EXISTS s failed: 2013 Lost connection to MySQL server during query
# 2013-08-06T23:07:34 [56306] Server crash reported at dsn dbi:mysql:
# 2013-08-06T23:07:34 [56306] Query: CREATE TABLE s SELECT * FROM `table100_
# 2013-08-06T23:07:34 [56306] Server crash reported at dsn dbi:mysql:
# 2013-08-06T23:07:34 [56298] Query: INSERT INTO n SELECT * FROM `table500_
# 2013-08-06T23:07:34 [56298] Server crash reported at dsn dbi:mysql:
# 2013-08-06T23:07:34 [55356] Killing remaining worker process with pid 56302...
# 2013-08-06T23:07:34 [55356] Killing remaining worker process with pid 56304...
# 2013-08-06T23:07:34 [55356] Killing remaining worker process with pid 56287...
# 2013-08-06T23:07:34 [55356] Killing remaining worker process with pid 56279...
# 2013-08-06T23:07:34 [55356] Killing remaining worker process with pid 56298...
# 2013-08-06T23:07:34 [55356] Killing remaining worker process with pid 56308...
# 2013-08-06T23:07:34 [55356] Killing remaining worker process with pid 56296...
# 2013-08-06T23:07:34 [55356] Killing remaining worker process with pid 56294...
# 2013-08-06T23:07:34 [55356] Killing remaining worker process with pid 56306...
# 2013-08-06T23:07:35 [55356] Killing periodic reporting process with pid 56278...
# 2013-08-06T23:07:35 [55356] Kill GenTest:
# 2013-08-06T23:07:35 [55356] Server crash reported, initiating post-crash analysis...
# 2013-08-06T23:07:35 [55356] The last 100 lines from /chip/mysql-
} joined {
} left {
} partitioned {
})
130806 23:03:53 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2
130806 23:03:53 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 5d54d93b-
130806 23:03:53 [Note] WSREP: STATE EXCHANGE: sent state msg: 5d54d93b-
130806 23:03:53 [Note] WSREP: STATE EXCHANGE: got state msg: 5d54d93b-
130806 23:03:54 [Note] WSREP: STATE EXCHANGE: got state msg: 5d54d93b-
130806 23:03:54 [Note] WSREP: Quorum results:
version = 2,
component = PRIMARY,
conf_id = 1,
members = 1/2 (joined/total),
act_id = 0,
last_appl. = 0,
protocols = 0/4/2 (gcs/repl/appl),
group UUID = 5c2397fd-
130806 23:03:54 [Note] WSREP: Flow-control interval: [23, 23]
130806 23:03:54 [Note] WSREP: New cluster view: global state: 5c2397fd-
130806 23:03:54 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130806 23:03:54 [Note] WSREP: Assign initial position for certification: 0, protocol version: 2
130806 23:03:56 [Note] WSREP: Node 1 (Archie) requested state transfer from '*any*'. Selected 0 (Archie)(SYNCED) as donor.
130806 23:03:56 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 0)
130806 23:03:56 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130806 23:03:56 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '192.168.
130806 23:03:56 [Note] WSREP: sst_donor_thread signaled with 0
130806 23:03:56 [Note] WSREP: Flushing tables for SST...
130806 23:03:56 [Note] WSREP: Provider paused at 5c2397fd-
130806 23:03:56 [Note] WSREP: Tables flushed.
130806 23:03:57 [Note] WSREP: Provider resumed.
130806 23:03:57 [Note] WSREP: 0 (Archie): State transfer to 1 (Archie) complete.
130806 23:03:57 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 0)
130806 23:03:57 [Note] WSREP: Member 0 (Archie) synced with group.
130806 23:03:57 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
130806 23:03:57 [Note] WSREP: Synchronized with group, ready for connections
130806 23:03:57 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130806 23:04:00 [Note] WSREP: 1 (Archie): State transfer from 0 (Archie) complete.
130806 23:04:00 [Note] WSREP: Member 1 (Archie) synced with group.
mysqld: /media/
17:37:34 UTC - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
key_buffer_
read_buffer_
max_used_
max_threads=151
thread_count=13
connection_count=13
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: 0x35c8670
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7fc6f8588e68 thread_stack 0x40000
/chip/bin/
/chip/bin/
/usr/lib/
/usr/lib/
/usr/lib/
/usr/lib/
/usr/lib/
/chip/bin/
/chip/bin/
/chip/bin/
/chip/bin/
/chip/bin/
/chip/bin/
/chip/bin/
/chip/bin/
/chip/bin/
/chip/bin/
/chip/bin/
/chip/bin/
/chip/bin/
/chip/bin/
/chip/bin/
/chip/bin/
/chip/bin/
/chip/bin/
/usr/lib/
/usr/lib/
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7fc6a0004c10): CREATE TABLE u SELECT * FROM `table100_
Connection ID (thread ID): 13
Status: NOT_KILLED
The manual page at http://
information that should help you find out what is causing the crash.
Writing a core file
# 2013-08-06T23:07:35 [55356] datadir is /chip/mysql-
# 2013-08-06T23:07:35 [55356] binary is /chip/.
# 2013-08-06T23:07:35 [55356] bindir is /chip/../chip/bin
# 2013-08-06T23:07:35 [55356] WARNING: Core file not found!
"/media/
backtrace.gdb:19: Error in sourced command file:
No stack.
# 2013-08-06T23:07:37 [55356] Whether to confirm potentially dangerous operations is on.
"/media/
# 2013-08-06T23:07:38 [55356] Whether to confirm potentially dangerous operations is on.
# 2013-08-06T23:07:38 [55356] Test completed with failure status STATUS_
# 2013-08-06T23:07:38 [55356] GenTest exited with exit status STATUS_
# 2013-08-06T23:07:38 [55356] Stopping server on port 19300
# 2013-08-06T23:07:38 [55356] Stale connection. Reconnecting
# 2013-08-06T23:07:38 [55356] Reconnect failed due to 2003:Can't connect to MySQL server on '127.0.0.1' (111)
# 2013-08-06T23:07:38 [55356] Server would not shut down properly. Terminate it
# 2013-08-06T23:07:38 [55356] Terminated process 55723
# 2013-08-06T23:07:38 [55356] Stopping server on port 19301
# 2013-08-06T23:07:38 [55356] Stale connection. Reconnecting
# 2013-08-06T23:07:38 [55356] [55356] runall-new.pl will exit with exit status STATUS_
perl runall-new.pl --basedir=/chip --galera=ms --threads=10 36.48s user 1.07s system 15% cpu 4:01.29 total
percona_qa.yy https:/
percona_qa.zz https:/
tags: | added: ctas |
Full log