Can Percona XtraDB Cluster database be used with Red Hat Enterprise Linux Openstack Platform ?

Solution Unverified - Updated -

Issue

  • Percona XtraDB Cluster database provided by Percona.
  • Can Percona XtraDB Cluster database be used with Red Hat Enterprise Linux Openstack Platform 5 ?
  • mysqld crashed with the following error:
160210 21:11:08 [Note] WSREP: resuming provider at 334408962
160210 21:11:08 [Note] WSREP: Provider resumed.
BF-BF X lock conflict
RECORD LOCKS space id 1040 page no 46 n bits 184 index `PRIMARY` of table `neutron`.`ipallocations` trx id 281DE2FB lock_mode X locks rec but not gap
21:11:08 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 XtraDB Cluster better by reporting any
bugs at  https://bugs.launchpad.net/percona-xtradb-cluster

key_buffer_size=16777216
read_buffer_size=2097152
max_used_connections=63
max_threads=6002
thread_count=18
connection_count=9
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 24677698 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7f2868000990
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 = 7f2dd03ba9c8 thread_stack 0x80000
/usr/sbin/mysqld(my_print_stacktrace+0x35)[0x7ee025]
/usr/sbin/mysqld(handle_fatal_signal+0x4b4)[0x6c0db4]
/lib64/libpthread.so.0(+0xf130)[0x7f2de7ebb130]
/lib64/libc.so.6(gsignal+0x37)[0x7f2de64685d7]
/lib64/libc.so.6(abort+0x148)[0x7f2de6469cc8]
/usr/sbin/mysqld[0x8f7239]
/usr/sbin/mysqld[0x8f85b9]
/usr/sbin/mysqld[0x8fc28b]
/usr/sbin/mysqld[0x8fc53b]
/usr/sbin/mysqld[0x8fc651]
/usr/sbin/mysqld[0x933b5a]
/usr/sbin/mysqld[0x935243]
/usr/sbin/mysqld[0x839b13]
/usr/sbin/mysqld[0x83b462]
/usr/sbin/mysqld[0x83bbd1]
/usr/sbin/mysqld[0x8266c1]
/usr/sbin/mysqld[0x801f7f]
/usr/sbin/mysqld(_ZN7handler13ha_delete_rowEPKh+0x5e)[0x6c76de]
/usr/sbin/mysqld(_ZN21Delete_rows_log_event11do_exec_rowEPK14Relay_log_info+0x169)[0x766e89]
/usr/sbin/mysqld(_ZN14Rows_log_event14do_apply_eventEPK14Relay_log_info+0x267)[0x76d1c7]
/usr/sbin/mysqld(_Z14wsrep_apply_cbPvPKvmjPK14wsrep_trx_meta+0x6a5)[0x67d0b5]
/usr/lib64/libgalera_smm.so(+0x1a3699)[0x7f2dddb89699]
/usr/lib64/libgalera_smm.so(_ZN6galera13ReplicatorSMM9apply_trxEPvPNS_9TrxHandleE+0x273)[0x7f2dddb8ac13]
/usr/lib64/libgalera_smm.so(_ZN6galera13ReplicatorSMM11process_trxEPvPNS_9TrxHandleE+0x45)[0x7f2dddb8b4e5]
/usr/lib64/libgalera_smm.so(_ZN6galera15GcsActionSource8dispatchEPvRK10gcs_actionRb+0x2dc)[0x7f2dddb6586c]
/usr/lib64/libgalera_smm.so(_ZN6galera15GcsActionSource7processEPvRb+0x63)[0x7f2dddb65f13]
/usr/lib64/libgalera_smm.so(_ZN6galera13ReplicatorSMM10async_recvEPv+0x93)[0x7f2dddb851e3]
/usr/lib64/libgalera_smm.so(galera_recv+0x23)[0x7f2dddb985d3]
/usr/sbin/mysqld[0x67df11]
/usr/sbin/mysqld(start_wsrep_THD+0x2ee)[0x5215de]
/lib64/libpthread.so.0(+0x7df5)[0x7f2de7eb3df5]
/lib64/libc.so.6(clone+0x6d)[0x7f2de65291ad]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): is an invalid pointer
Connection ID (thread ID): 5
Status: NOT_KILLED

You may download the Percona XtraDB Cluster operations manual by visiting
http://www.percona.com/software/percona-xtradb-cluster/. You may find information
in the manual which will help you identify the cause of the crash.
160210 21:11:08 mysqld_safe Number of processes running now: 0
160210 21:11:08 mysqld_safe WSREP: not restarting wsrep node automatically
160210 21:11:08 mysqld_safe mysqld from pid file /var/lib/mysql/mysql.pid ended
160210 23:09:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160210 23:09:03 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.cdpl7j' --pid-file='/var/lib/mysql/XXXXX.pid'
160210 23:09:08 mysqld_safe WSREP: Recovered position 9c631d12-13c8-11e5-8b94-cb40a8b278cd:342414601
160210 23:09:08 [Note] WSREP: wsrep_start_position var submitted: '9c631d12-13c8-11e5-8b94-cb40a8b278cd:342414601'
160210 23:09:08 [Note] WSREP: Read nil XID from storage engines, skipping position init
160210 23:09:08 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/libgalera_smm.so'
160210 23:09:08 [Note] WSREP: wsrep_load(): Galera 2.11(r318911d) by Codership Oy <info@codership.com> loaded successfully.
160210 23:09:08 [Note] WSREP: Found saved state: 9c631d12-13c8-11e5-8b94-cb40a8b278cd:-1
160210 23:09:08 [Note] WSREP: Reusing existing '/var/lib/mysql//galera.cache'.
160210 23:09:08 [Note] WSREP: Passing config to GCS: base_host = XX.XX.XX.XX; base_port = 4567; cert.log_conflicts = no; debug = no; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1.0; 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.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = P30S; pc.weight = 1; protonet.backend = asio; pr
160210 23:09:08 [Note] WSREP: Assign initial position for certification: 342414601, protocol version: -1
160210 23:09:08 [Note] WSREP: wsrep_sst_grab()
160210 23:09:08 [Note] WSREP: Start replication
160210 23:09:08 [Note] WSREP: Setting initial position to 9c631d12-13c8-11e5-8b94-cb40a8b278cd:342414601
160210 23:09:08 [Note] WSREP: protonet asio version 0
160210 23:09:08 [Note] WSREP: backend: asio
160210 23:09:08 [Note] WSREP: GMCast version 0
160210 23:09:08 [Note] WSREP: (4a12b0ea, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
160210 23:09:08 [Note] WSREP: (4a12b0ea, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
160210 23:09:08 [Note] WSREP: EVS version 0
160210 23:09:08 [Note] WSREP: PC version 0

Environment

  • Red Hat Enterprise Linux OpenStack Enterprise Platform 5.
  • Percona XtraDB Cluster database 5.6
  • Red Hat Enterprise Linux 7

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content