Skip to content

Instantly share code, notes, and snippets.

@ronin13
Created July 26, 2013 23:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ronin13/226ac21054cb48bba025 to your computer and use it in GitHub Desktop.
Save ronin13/226ac21054cb48bba025 to your computer and use it in GitHub Desktop.
130727 4:37:13 [Note] WSREP: Read nil XID from storage engines, skipping position init
130727 4:37:13 [Note] WSREP: wsrep_load(): loading provider library 'none'
130727 4:37:14 [Note] WSREP: Service disconnected.
130727 4:37:15 [Note] WSREP: Some threads may fail to exit.
130727 4:37:15 [Note] WSREP: Read nil XID from storage engines, skipping position init
130727 4:37:15 [Note] WSREP: wsrep_load(): loading provider library 'none'
130727 4:37:15 [Note] WSREP: Service disconnected.
130727 4:37:16 [Note] WSREP: Some threads may fail to exit.
130727 4:37:16 [Note] WSREP: Read nil XID from storage engines, skipping position init
130727 4:37:16 [Note] WSREP: wsrep_load(): loading provider library '/pxc/lib/libgalera_smm.so'
130727 4:37:16 [Note] WSREP: wsrep_load(): Galera 2.5(r148) by Codership Oy <info@codership.com> loaded succesfully.
130727 4:37:16 [Warning] WSREP: Could not open saved state file for reading: /media/Tintin/Work/code/percona-xtradb-cluster/trunk/tests/var/w1/var1/data//grastate.dat
130727 4:37:16 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1
130727 4:37:16 [Note] WSREP: Preallocating 134219048/134219048 bytes in '/media/Tintin/Work/code/percona-xtradb-cluster/trunk/tests/var/w1/var1/data//galera.cache'...
130727 4:37:16 [Note] WSREP: Passing config to GCS: base_host = 127.0.0.1; base_port = 4567; cert.log_conflicts = no; gcache.dir = /media/Tintin/Work/code/percona-xtradb-cluster/trunk/tests/var/w1/var1/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /media/Tintin/Work/code/percona-xtradb-cluster/trunk/tests/var/w1/var1/data//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; gmcast.listen_addr = tcp://127.0.0.1:16374; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
130727 4:37:16 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
130727 4:37:16 [Note] WSREP: wsrep_sst_grab()
130727 4:37:16 [Note] WSREP: Start replication
130727 4:37:16 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
130727 4:37:16 [Note] WSREP: protonet asio version 0
130727 4:37:16 [Note] WSREP: backend: asio
130727 4:37:16 [Note] WSREP: GMCast version 0
130727 4:37:16 [Note] WSREP: (1d73cdd8-f648-11e2-0800-287ddc0bd268, 'tcp://127.0.0.1:16374') listening at tcp://127.0.0.1:16374
130727 4:37:16 [Note] WSREP: (1d73cdd8-f648-11e2-0800-287ddc0bd268, 'tcp://127.0.0.1:16374') multicast: , ttl: 1
130727 4:37:16 [Note] WSREP: EVS version 0
130727 4:37:16 [Note] WSREP: PC version 0
130727 4:37:16 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer ''
130727 4:37:16 [Note] WSREP: Node 1d73cdd8-f648-11e2-0800-287ddc0bd268 state prim
130727 4:37:16 [Note] WSREP: view(view_id(PRIM,1d73cdd8-f648-11e2-0800-287ddc0bd268,1) memb {
1d73cdd8-f648-11e2-0800-287ddc0bd268,
} joined {
} left {
} partitioned {
})
130727 4:37:16 [Note] WSREP: gcomm: connected
130727 4:37:16 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
130727 4:37:16 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
130727 4:37:16 [Note] WSREP: Opened channel 'my_wsrep_cluster'
130727 4:37:16 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
130727 4:37:16 [Note] WSREP: Waiting for SST to complete.
130727 4:37:16 [Note] WSREP: Starting new group from scratch: 1d743af1-f648-11e2-0800-05a0d0f1299a
130727 4:37:16 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 1d746226-f648-11e2-0800-0a5e95cdbbcb
130727 4:37:16 [Note] WSREP: STATE EXCHANGE: sent state msg: 1d746226-f648-11e2-0800-0a5e95cdbbcb
130727 4:37:16 [Note] WSREP: STATE EXCHANGE: got state msg: 1d746226-f648-11e2-0800-0a5e95cdbbcb from 0 (Archie)
130727 4:37:16 [Note] WSREP: Quorum results:
version = 2,
component = PRIMARY,
conf_id = 0,
members = 1/1 (joined/total),
act_id = 0,
last_appl. = -1,
protocols = 0/4/2 (gcs/repl/appl),
group UUID = 1d743af1-f648-11e2-0800-05a0d0f1299a
130727 4:37:16 [Note] WSREP: Flow-control interval: [16, 16]
130727 4:37:16 [Note] WSREP: Restored state OPEN -> JOINED (0)
130727 4:37:16 [Note] WSREP: Member 0 (Archie) synced with group.
130727 4:37:16 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
130727 4:37:16 [Note] WSREP: New cluster view: global state: 1d743af1-f648-11e2-0800-05a0d0f1299a:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 2
130727 4:37:16 [Note] WSREP: SST complete, seqno: 0
130727 4:37:16 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
130727 4:37:16 InnoDB: The InnoDB memory heap is disabled
130727 4:37:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130727 4:37:16 InnoDB: Compressed tables use zlib 1.2.8
130727 4:37:16 InnoDB: Using Linux native AIO
130727 4:37:16 InnoDB: Initializing buffer pool, size = 128.0M
130727 4:37:16 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
130727 4:37:16 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130727 4:37:16 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130727 4:37:16 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130727 4:37:18 InnoDB: Waiting for the background threads to start
130727 4:37:19 Percona XtraDB (http://www.percona.com) 5.5.32-rel31.0 started; log sequence number 0
130727 4:37:19 [Note] Event Scheduler: Loaded 0 events
130727 4:37:19 [Note] /pxc/bin//mysqld: ready for connections.
Version: '5.5.32-23.7.5-debug' socket: '/tmp/xbtemp.ExD112/mysql.sock.mejIHY' port: 16048 Percona XtraDB Cluster (GPL) 5.5.32-23.7.5, Revision 432, wsrep_23.7.5.r432
130727 4:37:19 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
130727 4:37:19 [Note] WSREP: Assign initial position for certification: 0, protocol version: 2
130727 4:37:19 [Note] WSREP: Synchronized with group, ready for connections
130727 4:37:19 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
InnoDB: DEBUG: update_statistics for sakila/actor.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/category.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/country.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film_actor.
InnoDB: DEBUG: update_statistics for sakila/film_category.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/inventory.
InnoDB: DEBUG: update_statistics for sakila/language.
InnoDB: DEBUG: update_statistics for sakila/payment.
InnoDB: DEBUG: update_statistics for sakila/rental.
InnoDB: DEBUG: update_statistics for sakila/staff.
InnoDB: DEBUG: update_statistics for sakila/store.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/country.
InnoDB: DEBUG: update_statistics for sakila/category.
InnoDB: DEBUG: update_statistics for sakila/film_category.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film_actor.
InnoDB: DEBUG: update_statistics for sakila/actor.
InnoDB: DEBUG: update_statistics for sakila/staff.
InnoDB: DEBUG: update_statistics for sakila/payment.
InnoDB: DEBUG: update_statistics for sakila/rental.
InnoDB: DEBUG: update_statistics for sakila/inventory.
InnoDB: DEBUG: update_statistics for sakila/store.
InnoDB: DEBUG: update_statistics for sakila/film_actor.
InnoDB: DEBUG: update_statistics for sakila/film_category.
InnoDB: DEBUG: update_statistics for sakila/actor.
InnoDB: DEBUG: update_statistics for sakila/actor.
InnoDB: DEBUG: update_statistics for sakila/actor.
InnoDB: DEBUG: update_statistics for sakila/actor.
InnoDB: DEBUG: update_statistics for sakila/actor.
InnoDB: DEBUG: update_statistics for sakila/actor.
InnoDB: DEBUG: update_statistics for sakila/actor.
InnoDB: DEBUG: update_statistics for sakila/actor.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/address.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/city.
InnoDB: DEBUG: update_statistics for sakila/country.
InnoDB: DEBUG: update_statistics for sakila/country.
InnoDB: DEBUG: update_statistics for sakila/country.
InnoDB: DEBUG: update_statistics for sakila/country.
InnoDB: DEBUG: update_statistics for sakila/country.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/customer.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
InnoDB: DEBUG: update_statistics for sakila/film.
mysqld: /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/handler.h:1035: bool Ha_trx_info::is_trx_read_write() const: Assertion `is_started()' failed.
23:07:25 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://bugs.percona.com/
key_buffer_size=8388608
read_buffer_size=131072
max_used_connections=3
max_threads=153
thread_count=3
connection_count=3
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 343052 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x23c03b0
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 = 7f00241b8e68 thread_stack 0x40000
/pxc/bin//mysqld(my_print_stacktrace+0x2c)[0x810cda]
/pxc/bin//mysqld(handle_fatal_signal+0x30f)[0x6d0a0b]
/usr/lib/libpthread.so.0(+0xf0e0)[0x7f00371780e0]
/usr/lib/libc.so.6(gsignal+0x39)[0x7f00359271c9]
/usr/lib/libc.so.6(abort+0x148)[0x7f00359285c8]
/usr/lib/libc.so.6(+0x2e356)[0x7f0035920356]
/usr/lib/libc.so.6(+0x2e402)[0x7f0035920402]
/pxc/bin//mysqld(_Z28stmt_has_updated_trans_tablePK3THD+0x47)[0x7656a0]
/pxc/bin//mysqld(_ZN15Query_log_eventC2EP3THDPKcmbbbi+0x462)[0x77dd60]
/pxc/bin//mysqld[0x771c06]
/pxc/bin//mysqld[0x6d2846]
/pxc/bin//mysqld(_Z15ha_commit_transP3THDb+0x607)[0x6d46f7]
/pxc/bin//mysqld(_Z17trans_commit_stmtP3THD+0x76)[0x6663d8]
/pxc/bin//mysqld(_Z21mysql_execute_commandP3THD+0x7a43)[0x5a59fb]
/pxc/bin//mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x20a)[0x5a6bb1]
/pxc/bin//mysqld[0x5a7823]
/pxc/bin//mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xa62)[0x5a87f9]
/pxc/bin//mysqld(_Z10do_commandP3THD+0x6c0)[0x5aa704]
/pxc/bin//mysqld(_Z24do_handle_one_connectionP3THD+0x143)[0x6573ca]
/pxc/bin//mysqld(handle_one_connection+0x49)[0x6575fe]
/usr/lib/libpthread.so.0(+0x7dd2)[0x7f0037170dd2]
/usr/lib/libc.so.6(clone+0x6d)[0x7f00359d7cdd]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f00001e9f30): INSERT INTO film VALUES (1,'ACADEMY DINOSAUR','A Epic Drama of a Feminist And a Mad Scientist who must Battle a Teacher in The Canadian Rockies',2006,1,NULL,6,'0.99',86,'20.99','PG','Deleted Scenes,Behind the Scenes','2006-02-15 05:03:42'),(2,'ACE GOLDFINGER','A Astounding Epistle of a Database Administrator And a Explorer who must Find a Car in Ancient China',2006,1,NULL,3,'4.99',48,'12.99','G','Trailers,Deleted Scenes','2006-02-15 05:03:42'),(3,'ADAPTATION HOLES','A Astounding Reflection of a Lumberjack And a Car who must Sink a Lumberjack in A Baloon Factory',2006,1,NULL,7,'2.99',50,'18.99','NC-17','Trailers,Deleted Scenes','2006-02-15 05:03:42'),(4,'AFFAIR PREJUDICE','A Fanciful Documentary of a Frisbee And a Lumberjack who must Chase a Monkey in A Shark Tank',2006,1,NULL,5,'2.99',117,'26.99','G','Commentaries,Behind the Scenes','2006-02-15 05:03:42'),(5,'AFRICAN EGG','A Fast-Paced Documentary of a Pastry Chef And a Dentist who must Pursue a Forensic Psychologist in The Gulf of Mexico',2006,1,NULL,6,'2.99
Connection ID (thread ID): 6
Status: NOT_KILLED
You may download the Percona Server operations manual by visiting
http://www.percona.com/software/percona-server/. You may find information
in the manual which will help you identify the cause of the crash.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment