I tested with >10k writesets and didn't get a crash:
2014-03-17 20:08:22 29098 [Note] InnoDB: The InnoDB memory heap is disabled 2014-03-17 20:08:22 29098 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-03-17 20:08:22 29098 [Note] InnoDB: Compressed tables use zlib 1.2.8 2014-03-17 20:08:22 29098 [Note] InnoDB: Using Linux native AIO 2014-03-17 20:08:22 29098 [Note] InnoDB: Not using CPU crc32 instructions 2014-03-17 20:08:22 29098 [Note] InnoDB: Initializing buffer pool, size = 500.0M 2014-03-17 20:08:22 29098 [Note] InnoDB: Completed initialization of buffer pool 2014-03-17 20:08:22 29098 [Note] InnoDB: Highest supported file format is Barracuda. 2014-03-17 20:08:22 29098 [Note] InnoDB: 128 rollback segment(s) are active. 2014-03-17 20:08:22 29098 [Note] InnoDB: Waiting for purge to start 2014-03-17 20:08:22 29098 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.15-rel63.0 started; log sequence number 5485060234 2014-03-17 20:08:22 29098 [Note] WSREP: Initial TC log open: dummy 2014-03-17 20:08:22 29098 [Note] RSA private key file not found: /pxc56/datadir2//private_key.pem. Some authentication plugins will not work. 2014-03-17 20:08:22 29098 [Note] RSA public key file not found: /pxc56/datadir2//public_key.pem. Some authentication plugins will not work. 2014-03-17 20:08:22 29098 [Note] Server hostname (bind-address): '*'; port: 5000 2014-03-17 20:08:22 29098 [Note] IPv6 is not available. 2014-03-17 20:08:22 29098 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2014-03-17 20:08:22 29098 [Note] Server socket created on IP: '0.0.0.0'. 2014-03-17 20:08:22 29098 [Note] Event Scheduler: Loaded 0 events 2014-03-17 20:08:22 29098 [Note] WSREP: Signalling provider to continue. 2014-03-17 20:08:22 29098 [Note] WSREP: inited wsrep sidno 1 2014-03-17 20:08:22 29098 [Note] WSREP: SST received: f7e31510-9958-11e3-82f8-abba51ecd1d8:496459 2014-03-17 20:08:22 29098 [Note] WSREP: Receiving IST: 10416 writesets, seqnos 496459-506875 2014-03-17 20:08:22 29098 [Note] /pxc56/bin/mysqld: ready for connections. Version: '5.6.15-25.5' socket: '/pxc56/datadir2/pxc.sock' port: 5000 Percona XtraDB Cluster (GPL) 5.6.15-25.5, Revision 750, wsrep_25.5.r750 2014-03-17 20:08:53 29098 [Note] WSREP: IST received: f7e31510-9958-11e3-82f8-abba51ecd1d8:506875 2014-03-17 20:08:53 29098 [Note] WSREP: 0.0 (Arch1): State transfer to 1.0 (Arch2) complete. 2014-03-17 20:08:53 29098 [Note] WSREP: 1.0 (Arch2): State transfer from 0.0 (Arch1) complete. 2014-03-17 20:08:53 29098 [Note] WSREP: Shifting JOINER -> JOINED (TO: 511918) 2014-03-17 20:08:53 29098 [Note] WSREP: Member 0 (Arch1) synced with group.
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Can you test with latest PXC56/Galera3?
You can get them here:
http://www.percona.com/downloads/TESTING/Percona-XtraDB-Cluster-galera-56/galera-3.x/211/RPM/rhel6/x86_64/
http://www.percona.com/downloads/TESTING/Percona-XtraDB-Cluster-56/5.6.15-25.5/5.6/748/RPM/rhel6/x86_64/
I tested with >10k writesets and didn't get a crash:
2014-03-17 20:08:22 29098 [Note] InnoDB: The InnoDB memory heap is disabled www.percona. com) 5.6.15-rel63.0 started; log sequence number 5485060234 datadir2/ /private_ key.pem. Some authentication plugins will not work. datadir2/ /public_ key.pem. Some authentication plugins will not work. 9958-11e3- 82f8-abba51ecd1 d8:496459 datadir2/ pxc.sock' port: 5000 Percona XtraDB Cluster (GPL) 5.6.15-25.5, Revision 750, wsrep_25.5.r750 9958-11e3- 82f8-abba51ecd1 d8:506875
2014-03-17 20:08:22 29098 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-03-17 20:08:22 29098 [Note] InnoDB: Compressed tables use zlib 1.2.8
2014-03-17 20:08:22 29098 [Note] InnoDB: Using Linux native AIO
2014-03-17 20:08:22 29098 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-17 20:08:22 29098 [Note] InnoDB: Initializing buffer pool, size = 500.0M
2014-03-17 20:08:22 29098 [Note] InnoDB: Completed initialization of buffer pool
2014-03-17 20:08:22 29098 [Note] InnoDB: Highest supported file format is Barracuda.
2014-03-17 20:08:22 29098 [Note] InnoDB: 128 rollback segment(s) are active.
2014-03-17 20:08:22 29098 [Note] InnoDB: Waiting for purge to start
2014-03-17 20:08:22 29098 [Note] InnoDB: Percona XtraDB (http://
2014-03-17 20:08:22 29098 [Note] WSREP: Initial TC log open: dummy
2014-03-17 20:08:22 29098 [Note] RSA private key file not found: /pxc56/
2014-03-17 20:08:22 29098 [Note] RSA public key file not found: /pxc56/
2014-03-17 20:08:22 29098 [Note] Server hostname (bind-address): '*'; port: 5000
2014-03-17 20:08:22 29098 [Note] IPv6 is not available.
2014-03-17 20:08:22 29098 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2014-03-17 20:08:22 29098 [Note] Server socket created on IP: '0.0.0.0'.
2014-03-17 20:08:22 29098 [Note] Event Scheduler: Loaded 0 events
2014-03-17 20:08:22 29098 [Note] WSREP: Signalling provider to continue.
2014-03-17 20:08:22 29098 [Note] WSREP: inited wsrep sidno 1
2014-03-17 20:08:22 29098 [Note] WSREP: SST received: f7e31510-
2014-03-17 20:08:22 29098 [Note] WSREP: Receiving IST: 10416 writesets, seqnos 496459-506875
2014-03-17 20:08:22 29098 [Note] /pxc56/bin/mysqld: ready for connections.
Version: '5.6.15-25.5' socket: '/pxc56/
2014-03-17 20:08:53 29098 [Note] WSREP: IST received: f7e31510-
2014-03-17 20:08:53 29098 [Note] WSREP: 0.0 (Arch1): State transfer to 1.0 (Arch2) complete.
2014-03-17 20:08:53 29098 [Note] WSREP: 1.0 (Arch2): State transfer from 0.0 (Arch1) complete.
2014-03-17 20:08:53 29098 [Note] WSREP: Shifting JOINER -> JOINED (TO: 511918)
2014-03-17 20:08:53 29098 [Note] WSREP: Member 0 (Arch1) synced with group.
%%%%%%% %%%%%%% %%%%%%% %%%%%%% %%%%%%% %%%%%%% %%%%%
Can you test with latest PXC56/Galera3?
You can get them here:
http:// www.percona. com/downloads/ TESTING/ Percona- XtraDB- Cluster- galera- 56/galera- 3.x/211/ RPM/rhel6/ x86_64/
http:// www.percona. com/downloads/ TESTING/ Percona- XtraDB- Cluster- 56/5.6. 15-25.5/ 5.6/748/ RPM/rhel6/ x86_64/