Crash with debug build on PXC 5.6
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
Won't Fix
|
Undecided
|
Seppo Jaakola | ||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
Fix Released
|
Undecided
|
Raghavendra D Prabhu |
Bug Description
Log:
Detecting server version...
2013-09-20 13:11:30: run.sh: Starting server with id=1...
2013-09-20 13:11:30: run.sh: Creating server root directory: /mnt/workspace/
2013-09-20 13:11:30: run.sh: Creating server temporary directory: /mnt/workspace/
2013-09-20 13:11:30: run.sh: Creating server data directory: /mnt/workspace/
2013-09-20 13:11:30: run.sh: Calling mysql_install_db
Installing MySQL system tables...2013-09-20 13:11:30 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_
OK
Filling help tables...2013-09-20 13:11:34 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_
OK
To start mysqld at boot time you have to copy
support-
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/mnt/
/mnt/
Alternatively you can run:
/mnt/
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; /mnt/workspace/
You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl
Please report any problems with the ./bin/mysqlbug script!
The latest information about MySQL is available on the web at
Support MySQL by buying support/licenses at http://
New default config file was created as /mnt/workspace/
will be used by default by the server when you start it.
You may edit this file to change server settings
WARNING: Default config file /etc/my.cnf exists on the system
This file will be read by default by the MySQL server
If you do not want to use this, either remove it, or use the
--defaults-file argument to mysqld_safe when starting the server
Starting /mnt/workspace/
2013-09-20 13:11:38 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_
2013-09-20 13:11:39: run.sh: Made 1 attempts to connect to server
2013-09-20 13:11:40: run.sh: Server process PID=26382 died.
2013-09-20 13:11:40: run.sh: Can't start the server. Server log (if exists):
2013-09-20 13:11:40: run.sh: ----------------
2013-09-20 13:11:40: run.sh: Error log for server with id: 1
2013-09-20 13:11:30 26335 [Note] WSREP: Read nil XID from storage engines, skipping position init
2013-09-20 13:11:30 26335 [Note] WSREP: wsrep_load(): loading provider library 'none'
2013-09-20 13:11:30 7fe75bca07e0 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2013-09-20 13:11:30 7fe75bca07e0 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
2013-09-20 13:11:30 26335 [Note] InnoDB: The InnoDB memory heap is disabled
2013-09-20 13:11:30 26335 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2013-09-20 13:11:30 26335 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-09-20 13:11:30 26335 [Note] InnoDB: Using Linux native AIO
2013-09-20 13:11:30 26335 [Note] InnoDB: Using CPU crc32 instructions
2013-09-20 13:11:30 26335 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-09-20 13:11:30 26335 [Note] InnoDB: Completed initialization of buffer pool
2013-09-20 13:11:30 26335 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2013-09-20 13:11:30 26335 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2013-09-20 13:11:30 26335 [Note] InnoDB: Database physically writes the file full: wait...
2013-09-20 13:11:30 26335 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2013-09-20 13:11:31 26335 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2013-09-20 13:11:31 26335 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2013-09-20 13:11:31 26335 [Warning] InnoDB: New log files created, LSN=45781
2013-09-20 13:11:31 26335 [Note] InnoDB: Doublewrite buffer not found: creating new
2013-09-20 13:11:31 26335 [Note] InnoDB: Doublewrite buffer created
2013-09-20 13:11:31 26335 [Note] InnoDB: 128 rollback segment(s) are active.
2013-09-20 13:11:31 26335 [Warning] InnoDB: Creating foreign key constraint system tables.
2013-09-20 13:11:31 26335 [Note] InnoDB: Foreign key constraint system tables created
2013-09-20 13:11:31 26335 [Note] InnoDB: Creating tablespace and datafile system tables.
2013-09-20 13:11:31 26335 [Note] InnoDB: Tablespace and datafile system tables created.
2013-09-20 13:11:31 26335 [Note] InnoDB: Waiting for purge to start
2013-09-20 13:11:31 26335 [Note] InnoDB: Percona XtraDB (http://
2013-09-20 13:11:31 26335 [Note] RSA private key file not found: /mnt/workspace/
2013-09-20 13:11:31 26335 [Note] RSA public key file not found: /mnt/workspace/
2013-09-20 13:11:31 26335 [Note] WSREP: Service disconnected.
2013-09-20 13:11:32 26335 [Note] WSREP: Some threads may fail to exit.
2013-09-20 13:11:32 26335 [Note] Binlog end
2013-09-20 13:11:32 26335 [Note] InnoDB: FTS optimize thread exiting.
2013-09-20 13:11:32 26335 [Note] InnoDB: Starting shutdown...
2013-09-20 13:11:34 26335 [Note] InnoDB: Shutdown completed; log sequence number 1625977
2013-09-20 13:11:34 26358 [Note] WSREP: Read nil XID from storage engines, skipping position init
2013-09-20 13:11:34 26358 [Note] WSREP: wsrep_load(): loading provider library 'none'
2013-09-20 13:11:34 7f96cd6ce7e0 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2013-09-20 13:11:34 7f96cd6ce7e0 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
2013-09-20 13:11:34 26358 [Note] InnoDB: The InnoDB memory heap is disabled
2013-09-20 13:11:34 26358 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2013-09-20 13:11:34 26358 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-09-20 13:11:34 26358 [Note] InnoDB: Using Linux native AIO
2013-09-20 13:11:34 26358 [Note] InnoDB: Using CPU crc32 instructions
2013-09-20 13:11:34 26358 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-09-20 13:11:34 26358 [Note] InnoDB: Completed initialization of buffer pool
2013-09-20 13:11:34 26358 [Note] InnoDB: Highest supported file format is Barracuda.
2013-09-20 13:11:35 26358 [Note] InnoDB: 128 rollback segment(s) are active.
2013-09-20 13:11:35 26358 [Note] InnoDB: Waiting for purge to start
2013-09-20 13:11:35 26358 [Note] InnoDB: Percona XtraDB (http://
2013-09-20 13:11:35 26358 [Note] RSA private key file not found: /mnt/workspace/
2013-09-20 13:11:35 26358 [Note] RSA public key file not found: /mnt/workspace/
2013-09-20 13:11:35 26358 [Note] WSREP: Service disconnected.
2013-09-20 13:11:36 26358 [Note] WSREP: Some threads may fail to exit.
2013-09-20 13:11:36 26358 [Note] Binlog end
2013-09-20 13:11:36 26358 [Note] InnoDB: FTS optimize thread exiting.
2013-09-20 13:11:36 26358 [Note] InnoDB: Starting shutdown...
2013-09-20 13:11:38 26358 [Note] InnoDB: Shutdown completed; log sequence number 1625987
2013-09-20 13:11:38 26382 [Note] Plugin 'FEDERATED' is disabled.
2013-09-20 13:11:38 7fa5fa4197e0 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2013-09-20 13:11:38 7fa5fa4197e0 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
2013-09-20 13:11:38 26382 [Note] InnoDB: The InnoDB memory heap is disabled
2013-09-20 13:11:38 26382 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2013-09-20 13:11:38 26382 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-09-20 13:11:38 26382 [Note] InnoDB: Using Linux native AIO
2013-09-20 13:11:38 26382 [Note] InnoDB: Using CPU crc32 instructions
2013-09-20 13:11:38 26382 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-09-20 13:11:38 26382 [Note] InnoDB: Completed initialization of buffer pool
2013-09-20 13:11:38 26382 [Note] InnoDB: Highest supported file format is Barracuda.
2013-09-20 13:11:39 26382 [Note] InnoDB: 128 rollback segment(s) are active.
2013-09-20 13:11:39 26382 [Note] InnoDB: Waiting for purge to start
2013-09-20 13:11:39 26382 [Note] InnoDB: Percona XtraDB (http://
2013-09-20 13:11:39 26382 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 2fce591b-
2013-09-20 13:11:39 26382 [Note] RSA private key file not found: /mnt/workspace/
2013-09-20 13:11:39 26382 [Note] RSA public key file not found: /mnt/workspace/
2013-09-20 13:11:39 26382 [Note] Server hostname (bind-address): '*'; port: 28793
2013-09-20 13:11:39 26382 [Note] IPv6 is available.
2013-09-20 13:11:39 26382 [Note] - '::' resolves to '::';
2013-09-20 13:11:39 26382 [Note] Server socket created on IP: '::'.
2013-09-20 13:11:39 26382 [Note] Event Scheduler: Loaded 0 events
InnoDB: sync levels should be > 290 but a level is 290
-------------
RW-LATCH INFO
RW-LATCH: 0x7fa5d2cf7830
Locked: thread 140350844934112 file /mnt/workspace/
Locked: thread 140350844934112 file /mnt/workspace/
InnoDB: sync_thread_
2013-09-20 13:11:39 7fa5fa4197e0 InnoDB: Assertion failure in thread 140350844934112 in file sync0sync.cc line 1174
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://
InnoDB: about forcing recovery.
13:11:39 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.
Please help us make Percona Server better by reporting any
bugs at http://
key_buffer_
read_buffer_
max_used_
max_threads=153
thread_count=0
connection_count=0
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: 0x0
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 = 0 thread_stack 0x40000
/mnt/workspace/
/mnt/workspace/
/lib64/
/lib64/
/lib64/
/mnt/workspace/
/mnt/workspace/
/mnt/workspace/
/mnt/workspace/
/mnt/workspace/
/mnt/workspace/
/mnt/workspace/
/mnt/workspace/
/mnt/workspace/
/lib64/
/mnt/workspace/
You may download the Percona Server operations manual by visiting
http://
in the manual which will help you identify the cause of the crash.
2013-09-20 13:11:40: run.sh: ----------------
2013-09-20 13:11:40: run.sh: ----------------
2013-09-20 13:11:40: run.sh: Innobackupex log for server with id: 1
cat: /mnt/workspace/
2013-09-20 13:11:40: run.sh: ----------------
2013-09-20 13:11:40: run.sh: ----------------
2013-09-20 13:11:40: run.sh: Configuration for server with id: 1
[mysqld]
socket=
port=28793
server-id=1
basedir=
datadir=
tmpdir=
log-error=
pid-file=
[client]
socket=
user=root
2013-09-20 13:11:40: run.sh: ----------------
2013-09-20 13:11:40: run.sh: Found a leftover mysqld processes with PID 26382, stopping it
Related branches
Changed in percona-xtradb-cluster: | |
milestone: | none → 5.6.13-24.0 |
Changed in codership-mysql: | |
milestone: | none → 5.6.14-24.1 |
Changed in percona-xtradb-cluster: | |
assignee: | nobody → Raghavendra D Prabhu (raghavendra-prabhu) |
status: | New → In Progress |
Changed in percona-xtradb-cluster: | |
status: | In Progress → Fix Committed |
Changed in codership-mysql: | |
assignee: | nobody → Seppo Jaakola (seppo-jaakola) |
Changed in percona-xtradb-cluster: | |
status: | Fix Committed → Fix Released |
This crash seems to be associated with UNIV_SYNC_DEBUG.
PS added UNIV_DEBUG_SYNC back by removing the undef. For more details check: http:// bugs.mysql. com/bug. php?id= 69617&thanks= 3¬ify= 195
However, the codership tree (and its binaries) still retain it, hence may not see any crash associated with it (with debug builds), for now.