[MDEV-10623] mysqld got signal 11 have occurred on MariaDB-10.1.14-centos7-x86_64-server with galera-25.3.15-1.rhel7.el7.centos.x86_64 Created: 2016-08-21  Updated: 2019-05-21  Resolved: 2019-05-21

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.1.14
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Yao lin Assignee: Jan Lindström (Inactive)
Resolution: Cannot Reproduce Votes: 0
Labels: galera
Environment:

OS Version: CentOS-7-x86_64-DVD-1511.iso
DB Version: MariaDB-10.1.14-centos7-x86_64-server.rpm
Galera Version: galera-25.3.15-1.rhel7.el7.centos.x86_64.rpm


Attachments: File DBG01-DB-JH01.err_20160815    

 Description   

[root@DBG01-DB-JH01 ~]# cat /etc/my.cnf.d/server.cnf
#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#
 
# this is read by the standalone daemon and embedded servers
[server]
 
# this is only for the mysqld standalone daemon
[mysqld]
 
#
# * Galera-related settings
#
[galera]
# Mandatory settings
#wsrep_on=ON
#wsrep_provider=
#wsrep_cluster_address=
#binlog_format=row
#default_storage_engine=InnoDB
#innodb_autoinc_lock_mode=2
 
wsrep_on=ON
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_address=gcomm://172.22.4.173,172.20.3.173,172.20.3.186
binlog_format=ROW
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
wsrep_log_conflicts=ON
 
wsrep_provider_options="gcache.size = 10G;"
wsrep_slave_threads=8
wsrep_cluster_name='GC01'
wsrep_node_address='172.22.4.173'
wsrep_node_name='DBG01-DB-JH01'
wsrep_sst_method=rsync
wsrep_sst_auth=root:password
 
#
# Allow server to accept connections on all interfaces.
#
#bind-address=0.0.0.0
#
# Optional setting
#wsrep_slave_threads=1
#innodb_flush_log_at_trx_commit=0
 
# this is only for embedded server
[embedded]
 
# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]
 
# This group is only read by MariaDB-10.1 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.1]
 
basedir=/usr
datadir=/mysql/data
tmpdir=/mysql/tmp
log-error=/mysql/data/DBG01-DB-JH01.err
 
 
innodb_data_file_path=ibdata1:1G;ibdata2:1G;ibdata3:1G:autoextend:max:1G
innodb_log_files_in_group=3
innodb_log_file_size=64M
innodb_file_per_table=1
 
innodb_undo_directory=/mysql/undo
innodb_undo_tablespaces=126
innodb_undo_logs=128
 
skip-external-locking
innodb_lock_wait_timeout=600
 
max_allowed_packet=32M
 
innodb_buffer_pool_size=20GB
innodb_log_buffer_size=32M
innodb_flush_log_at_trx_commit=2
innodb_flush_method=O_DIRECT
 
innodb_read_io_threads=8
innodb_write_io_threads=8
 
tmp_table_size=32M
max_heap_table_size=32M
 
connect_timeout=60
max_connections=10000
max_user_connections=10000
 
wait_timeout=300
interactive_timeout=300
 
server-id=01
 
log-bin=/mysql/data/log-bin
binlog_format=ROW
expire_logs_days=14
log_bin_trust_function_creators=1
 
event_scheduler=ON
 
skip_name_resolve
 
lower_case_table_names=1
 
character-set-server=utf8
collation-server=utf8_general_ci

[root@DBG01-DB-JH01 ~]# cat /mysql/data/DBG01-DB-JH01.err
 
2016-08-08 23:49:49 140221578950784 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-08-08 23:49:49 140221578950784 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-08 23:49:49 140221578950784 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-08-08 23:49:49 140221578950784 [Note] InnoDB: Memory barrier is not used
2016-08-08 23:49:49 140221578950784 [Note] InnoDB: Compressed tables use zlib 1.2.7
2016-08-08 23:49:49 140221578950784 [Note] InnoDB: Using Linux native AIO
2016-08-08 23:49:49 140221578950784 [Note] InnoDB: Using SSE crc32 instructions
2016-08-08 23:49:49 140221578950784 [Note] InnoDB: Initializing buffer pool, size = 30.0G
2016-08-08 23:49:50 140221578950784 [Note] InnoDB: Completed initialization of buffer pool
2016-08-08 23:49:50 140221578950784 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2016-08-08 23:49:50 140221578950784 [Note] InnoDB: Setting file ./ibdata1 size to 1024 MB
2016-08-08 23:49:50 140221578950784 [Note] InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000
2016-08-08 23:49:56 140221578950784 [Note] InnoDB: Data file ./ibdata2 did not exist: new to be created
2016-08-08 23:49:56 140221578950784 [Note] InnoDB: Setting file ./ibdata2 size to 1024 MB
2016-08-08 23:49:56 140221578950784 [Note] InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000
2016-08-08 23:50:02 140221578950784 [Note] InnoDB: Data file ./ibdata3 did not exist: new to be created
2016-08-08 23:50:02 140221578950784 [Note] InnoDB: Setting file ./ibdata3 size to 1024 MB
2016-08-08 23:50:02 140221578950784 [Note] InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000
2016-08-08 23:50:08 140221578950784 [Note] InnoDB: Setting log file ./ib_logfile101 size to 1024 MB
InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000
2016-08-08 23:50:10 140221578950784 [Note] InnoDB: Setting log file ./ib_logfile1 size to 1024 MB
InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000
2016-08-08 23:50:12 140221578950784 [Note] InnoDB: Setting log file ./ib_logfile2 size to 1024 MB
InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000
2016-08-08 23:50:13 140221578950784 [Note] InnoDB: Data file /mysql/undo/undo001 did not exist: new to be created
2016-08-08 23:50:13 140221578950784 [Note] InnoDB: Setting file /mysql/undo/undo001 size to 10 MB
2016-08-08 23:50:13 140221578950784 [Note] InnoDB: Database physically writes the file full: wait...
...
...
...
2016-08-08 23:50:20 140221578950784 [Note] InnoDB: Database physically writes the file full: wait...
2016-08-08 23:50:20 140221578950784 [Note] InnoDB: Opened 126 undo tablespaces
2016-08-08 23:50:20 140221578950784 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2016-08-08 23:50:20 140221578950784 [Warning] InnoDB: New log files created, LSN=156961
2016-08-08 23:50:20 140221578950784 [Note] InnoDB: Doublewrite buffer not found: creating new
2016-08-08 23:50:20 140221578950784 [Note] InnoDB: Doublewrite buffer created
2016-08-08 23:50:21 140221578950784 [Note] InnoDB: 128 rollback segment(s) are active.
2016-08-08 23:50:21 140221578950784 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-08-08 23:50:21 140221578950784 [Note] InnoDB: Foreign key constraint system tables created
2016-08-08 23:50:21 140221578950784 [Note] InnoDB: Creating tablespace and datafile system tables.
2016-08-08 23:50:21 140221578950784 [Note] InnoDB: Tablespace and datafile system tables created.
2016-08-08 23:50:21 140221578950784 [Note] InnoDB: Waiting for purge to start
2016-08-08 23:50:21 140221578950784 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.29-76.2 started; log sequence number 0
2016-08-08 23:50:21 140185585055488 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-08-08 23:50:25 139709153716352 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-08-08 23:50:25 139709153716352 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-08 23:50:25 139709153716352 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-08-08 23:50:25 139709153716352 [Note] InnoDB: Memory barrier is not used
2016-08-08 23:50:25 139709153716352 [Note] InnoDB: Compressed tables use zlib 1.2.7
2016-08-08 23:50:25 139709153716352 [Note] InnoDB: Using Linux native AIO
2016-08-08 23:50:25 139709153716352 [Note] InnoDB: Using SSE crc32 instructions
2016-08-08 23:50:25 139709153716352 [Note] InnoDB: Initializing buffer pool, size = 30.0G
2016-08-08 23:50:26 139709153716352 [Note] InnoDB: Completed initialization of buffer pool
2016-08-08 23:50:26 139709153716352 [Note] InnoDB: Opened 126 undo tablespaces
2016-08-08 23:50:26 139709153716352 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-08 23:50:27 139709153716352 [Note] InnoDB: 128 rollback segment(s) are active.
2016-08-08 23:50:27 139709153716352 [Note] InnoDB: Waiting for purge to start
2016-08-08 23:50:27 139709153716352 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.29-76.2 started; log sequence number 1727329
2016-08-08 23:50:27 139673166907136 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-08-08 23:50:30 139910871382144 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-08-08 23:50:30 139910871382144 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-08 23:50:30 139910871382144 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-08-08 23:50:30 139910871382144 [Note] InnoDB: Memory barrier is not used
2016-08-08 23:50:30 139910871382144 [Note] InnoDB: Compressed tables use zlib 1.2.7
2016-08-08 23:50:30 139910871382144 [Note] InnoDB: Using Linux native AIO
2016-08-08 23:50:30 139910871382144 [Note] InnoDB: Using SSE crc32 instructions
2016-08-08 23:50:30 139910871382144 [Note] InnoDB: Initializing buffer pool, size = 30.0G
2016-08-08 23:50:32 139910871382144 [Note] InnoDB: Completed initialization of buffer pool
2016-08-08 23:50:32 139910871382144 [Note] InnoDB: Opened 126 undo tablespaces
2016-08-08 23:50:32 139910871382144 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-08 23:50:32 139910871382144 [Note] InnoDB: 128 rollback segment(s) are active.
2016-08-08 23:50:32 139910871382144 [Note] InnoDB: Waiting for purge to start
2016-08-08 23:50:33 139910871382144 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.29-76.2 started; log sequence number 1727339
2016-08-08 23:50:33 139874883569408 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-08-08 23:51:04 140600984860800 [Note] CONNECT: Version 1.04.0006 March 12, 2016
2016-08-08 23:51:04 140600984860800 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-08-08 23:51:04 140600984860800 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-08 23:51:04 140600984860800 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-08-08 23:51:04 140600984860800 [Note] InnoDB: Memory barrier is not used
2016-08-08 23:51:04 140600984860800 [Note] InnoDB: Compressed tables use zlib 1.2.7
2016-08-08 23:51:04 140600984860800 [Note] InnoDB: Using Linux native AIO
2016-08-08 23:51:04 140600984860800 [Note] InnoDB: Using SSE crc32 instructions
2016-08-08 23:51:04 140600984860800 [Note] InnoDB: Initializing buffer pool, size = 30.0G
2016-08-08 23:51:05 140600984860800 [Note] InnoDB: Completed initialization of buffer pool
2016-08-08 23:51:05 140600984860800 [Note] InnoDB: Opened 126 undo tablespaces
2016-08-08 23:51:05 140600984860800 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-08 23:51:06 140600984860800 [Note] InnoDB: 128 rollback segment(s) are active.
2016-08-08 23:51:06 140600984860800 [Note] InnoDB: Waiting for purge to start
2016-08-08 23:51:06 140600984860800 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.29-76.2 started; log sequence number 1727349
2016-08-08 23:51:06 140564989183744 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-08-08 23:51:06 140600984860800 [Note] Plugin 'FEEDBACK' is disabled.
2016-08-08 23:51:06 140600984860800 [Note] Server socket created on IP: '::'.
2016-08-08 23:51:06 140600984860800 [Warning] 'user' entry 'root@dbg01-db-jh01' ignored in --skip-name-resolve mode.
2016-08-08 23:51:06 140600984860800 [Warning] 'user' entry '@dbg01-db-jh01' ignored in --skip-name-resolve mode.
2016-08-08 23:51:06 140600984860800 [Warning] 'proxies_priv' entry '@% root@dbg01-db-jh01' ignored in --skip-name-resolve mode.
2016-08-08 23:51:06 140600984860800 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.14-MariaDB'  socket: '/mysql/tmp/mysql.sock'  port: 3306  MariaDB Server
2016-08-08 23:51:27 140600984058624 [Note] /usr/sbin/mysqld: Normal shutdown
...
...
...
2016-08-09  0:14:12 140377041262720 [Note] Server socket created on IP: '::'.
2016-08-09  0:14:12 140377041262720 [Warning] 'user' entry 'root@dbg01-db-sx01' ignored in --skip-name-resolve mode.
2016-08-09  0:14:12 140377041262720 [Warning] 'user' entry '@dbg01-db-sx01' ignored in --skip-name-resolve mode.
2016-08-09  0:14:12 140377041262720 [Warning] 'proxies_priv' entry '@% root@dbg01-db-sx01' ignored in --skip-name-resolve mode.
2016-08-09  0:14:12 140377040947968 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2016-08-09  0:14:12 140377040947968 [Note] WSREP: REPL Protocols: 7 (3, 2)
2016-08-09  0:14:12 140366191785728 [Note] WSREP: Service thread queue flushed.
2016-08-09  0:14:12 140377040947968 [Note] WSREP: Assign initial position for certification: 427614158, protocol version: 3
2016-08-09  0:14:12 140366191785728 [Note] WSREP: Service thread queue flushed.
2016-08-09  0:14:12 140377040947968 [Note] WSREP: Synchronized with group, ready for connections
2016-08-09  0:14:12 140377040947968 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2016-08-09  0:14:12 140377041262720 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.14-MariaDB'  socket: '/mysql/tmp/mysql.sock'  port: 3306  MariaDB Server
2016-08-09  0:14:12 140366137259776 [Note] WSREP: (22d5ebda, 'tcp://0.0.0.0:4567') turning message relay requesting off
2016-08-09  0:21:10 140366137259776 [Note] WSREP: (22d5ebda, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://172.20.3.173:4567 
2016-08-09  0:21:10 140366137259776 [Note] WSREP: declaring 1dff390b at tcp://172.20.3.173:4567 stable
2016-08-09  0:21:10 140366137259776 [Note] WSREP: declaring 9bf371c2 at tcp://172.20.3.186:4567 stable
2016-08-09  0:21:10 140366137259776 [Note] WSREP: Node 22d5ebda state prim
2016-08-09  0:21:10 140366137259776 [Note] WSREP: view(view_id(PRIM,1dff390b,5) memb {
 1dff390b,0
 22d5ebda,0
 9bf371c2,0
} joined {
} left {
} partitioned {
})
2016-08-09  0:21:10 140366137259776 [Note] WSREP: save pc into disk
2016-08-09  0:21:10 140366128867072 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3
2016-08-09  0:21:10 140366128867072 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2016-08-09  0:21:10 140366128867072 [Note] WSREP: STATE EXCHANGE: sent state msg: 1e4c7102-5d84-11e6-aff6-ba626bfd1e15
2016-08-09  0:21:10 140366128867072 [Note] WSREP: STATE EXCHANGE: got state msg: 1e4c7102-5d84-11e6-aff6-ba626bfd1e15 from 0 (DBG01-DB-SX01)
2016-08-09  0:21:10 140366128867072 [Note] WSREP: STATE EXCHANGE: got state msg: 1e4c7102-5d84-11e6-aff6-ba626bfd1e15 from 1 (DBG01-DB-JH01)
2016-08-09  0:21:10 140366128867072 [Note] WSREP: STATE EXCHANGE: got state msg: 1e4c7102-5d84-11e6-aff6-ba626bfd1e15 from 2 (DBG01-DB-SX02)
2016-08-09  0:21:10 140366128867072 [Note] WSREP: Quorum results:
 version    = 3,
 component  = PRIMARY,
 conf_id    = 4,
 members    = 2/3 (joined/total),
 act_id     = 427614158,
 last_appl. = 0,
 protocols  = 0/7/3 (gcs/repl/appl),
 group UUID = f1939083-4f54-11e6-b062-f668e8937e5a
2016-08-09  0:21:10 140366128867072 [Note] WSREP: Flow-control interval: [28, 28]
2016-08-09  0:21:10 140377040947968 [Note] WSREP: New cluster view: global state: f1939083-4f54-11e6-b062-f668e8937e5a:427614158, view# 5: Primary, number of nodes: 3, my index: 1, protocol version 3
2016-08-09  0:21:10 140377040947968 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2016-08-09  0:21:10 140377040947968 [Note] WSREP: REPL Protocols: 7 (3, 2)
2016-08-09  0:21:10 140366191785728 [Note] WSREP: Service thread queue flushed.
2016-08-09  0:21:10 140377040947968 [Note] WSREP: Assign initial position for certification: 427614158, protocol version: 3
2016-08-09  0:21:10 140366191785728 [Note] WSREP: Service thread queue flushed.
2016-08-09  0:21:10 140366128867072 [Note] WSREP: Member 0.0 (DBG01-DB-SX01) requested state transfer from '*any*'. Selected 1.0 (DBG01-DB-JH01)(SYNCED) as donor.
2016-08-09  0:21:10 140366128867072 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 427614158)
2016-08-09  0:21:10 140377040947968 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2016-08-09  0:21:10 140330183640832 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '172.20.3.173:4444/rsync_sst' --socket '/mysql/tmp/mysql.sock' --datadir '/mysql/data/'    --binlog '/mysql/data/log-bin' --gtid 'f1939083-4f54-11e6-b062-f668e8937e5a:427614158' --gtid-domain-id '0''
2016-08-09  0:21:10 140377040947968 [Note] WSREP: sst_donor_thread signaled with 0
2016-08-09  0:21:10 140330183640832 [Note] WSREP: Flushing tables for SST...
2016-08-09  0:21:10 140330183640832 [Note] WSREP: Provider paused at f1939083-4f54-11e6-b062-f668e8937e5a:427614158 (5)
2016-08-09  0:21:10 140330183640832 [Note] WSREP: Tables flushed.
WSREP_SST: [INFO] Preparing binlog files for transfer: (20160809 00:21:11.115)
log-bin.000064
2016-08-09  0:21:13 140366137259776 [Note] WSREP: (22d5ebda, 'tcp://0.0.0.0:4567') turning message relay requesting off
2016-08-09  0:30:57 140330183640832 [Note] WSREP: resuming provider at 5
2016-08-09  0:30:57 140330183640832 [Note] WSREP: Provider resumed.
2016-08-09  0:30:57 140366128867072 [Note] WSREP: 1.0 (DBG01-DB-JH01): State transfer to 0.0 (DBG01-DB-SX01) complete.
2016-08-09  0:30:57 140366128867072 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 427614158)
2016-08-09  0:30:57 140366128867072 [Note] WSREP: Member 1.0 (DBG01-DB-JH01) synced with group.
2016-08-09  0:30:57 140366128867072 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 427614158)
2016-08-09  0:30:57 140376967973632 [Note] WSREP: Synchronized with group, ready for connections
2016-08-09  0:30:57 140376967973632 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2016-08-09  0:31:12 140366137259776 [Note] WSREP: declaring 9bf371c2 at tcp://172.20.3.186:4567 stable
2016-08-09  0:31:12 140366137259776 [Note] WSREP: forgetting 1dff390b (tcp://172.20.3.173:4567)
2016-08-09  0:31:12 140366137259776 [Note] WSREP: Node 22d5ebda state prim
2016-08-09  0:31:12 140366137259776 [Note] WSREP: view(view_id(PRIM,22d5ebda,6) memb {
 22d5ebda,0
 9bf371c2,0
} joined {
} left {
} partitioned {
 1dff390b,0
})
2016-08-09  0:31:12 140366137259776 [Note] WSREP: save pc into disk
2016-08-09  0:31:12 140366137259776 [Note] WSREP: forgetting 1dff390b (tcp://172.20.3.173:4567)
2016-08-09  0:31:12 140366128867072 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2
2016-08-09  0:31:12 140366128867072 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 84ec04b1-5d85-11e6-9b4e-b2752f44a323
2016-08-09  0:31:12 140366128867072 [Note] WSREP: STATE EXCHANGE: sent state msg: 84ec04b1-5d85-11e6-9b4e-b2752f44a323
2016-08-09  0:31:12 140366128867072 [Note] WSREP: STATE EXCHANGE: got state msg: 84ec04b1-5d85-11e6-9b4e-b2752f44a323 from 0 (DBG01-DB-JH01)
2016-08-09  0:31:12 140366128867072 [Note] WSREP: STATE EXCHANGE: got state msg: 84ec04b1-5d85-11e6-9b4e-b2752f44a323 from 1 (DBG01-DB-SX02)
2016-08-09  0:31:12 140366128867072 [Note] WSREP: Quorum results:
 version    = 3,
 component  = PRIMARY,
 conf_id    = 5,
 members    = 2/2 (joined/total),
 act_id     = 427614158,
 last_appl. = 0,
 protocols  = 0/7/3 (gcs/repl/appl),
 group UUID = f1939083-4f54-11e6-b062-f668e8937e5a
2016-08-09  0:31:12 140366128867072 [Note] WSREP: Flow-control interval: [23, 23]
2016-08-09  0:31:12 140376968276736 [Note] WSREP: New cluster view: global state: f1939083-4f54-11e6-b062-f668e8937e5a:427614158, view# 6: Primary, number of nodes: 2, my index: 0, protocol version 3
2016-08-09  0:31:12 140376968276736 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2016-08-09  0:31:12 140376968276736 [Note] WSREP: REPL Protocols: 7 (3, 2)
2016-08-09  0:31:12 140366191785728 [Note] WSREP: Service thread queue flushed.
2016-08-09  0:31:12 140376968276736 [Note] WSREP: Assign initial position for certification: 427614158, protocol version: 3
2016-08-09  0:31:12 140366191785728 [Note] WSREP: Service thread queue flushed.
2016-08-09  0:31:17 140366137259776 [Note] WSREP:  cleaning up 1dff390b (tcp://172.20.3.173:4567)
2016-08-09  0:32:13 140366137259776 [Note] WSREP: (22d5ebda, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://172.20.3.173:4567 
2016-08-09  0:32:14 140366137259776 [Note] WSREP: declaring 9bf371c2 at tcp://172.20.3.186:4567 stable
2016-08-09  0:32:14 140366137259776 [Note] WSREP: declaring a9956be2 at tcp://172.20.3.173:4567 stable
2016-08-09  0:32:14 140366137259776 [Note] WSREP: Node 22d5ebda state prim
2016-08-09  0:32:14 140366137259776 [Note] WSREP: view(view_id(PRIM,22d5ebda,7) memb {
 22d5ebda,0
 9bf371c2,0
 a9956be2,0
} joined {
} left {
} partitioned {
})
2016-08-09  0:32:14 140366137259776 [Note] WSREP: save pc into disk
2016-08-09  0:32:14 140366128867072 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3
2016-08-09  0:32:14 140366128867072 [Note] WSREP: STATE_EXCHANGE: sent state UUID: a9e39869-5d85-11e6-ae5b-72997698c994
2016-08-09  0:32:14 140366128867072 [Note] WSREP: STATE EXCHANGE: sent state msg: a9e39869-5d85-11e6-ae5b-72997698c994
2016-08-09  0:32:14 140366128867072 [Note] WSREP: STATE EXCHANGE: got state msg: a9e39869-5d85-11e6-ae5b-72997698c994 from 0 (DBG01-DB-JH01)
2016-08-09  0:32:14 140366128867072 [Note] WSREP: STATE EXCHANGE: got state msg: a9e39869-5d85-11e6-ae5b-72997698c994 from 1 (DBG01-DB-SX02)
2016-08-09  0:32:14 140366128867072 [Note] WSREP: STATE EXCHANGE: got state msg: a9e39869-5d85-11e6-ae5b-72997698c994 from 2 (DBG01-DB-SX01)
2016-08-09  0:32:14 140366128867072 [Note] WSREP: Quorum results:
 version    = 3,
 component  = PRIMARY,
 conf_id    = 6,
 members    = 3/3 (joined/total),
 act_id     = 427614158,
 last_appl. = 0,
 protocols  = 0/7/3 (gcs/repl/appl),
 group UUID = f1939083-4f54-11e6-b062-f668e8937e5a
2016-08-09  0:32:14 140366128867072 [Note] WSREP: Flow-control interval: [28, 28]
2016-08-09  0:32:14 140376968276736 [Note] WSREP: New cluster view: global state: f1939083-4f54-11e6-b062-f668e8937e5a:427614158, view# 7: Primary, number of nodes: 3, my index: 0, protocol version 3
2016-08-09  0:32:14 140376968276736 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2016-08-09  0:32:14 140376968276736 [Note] WSREP: REPL Protocols: 7 (3, 2)
2016-08-09  0:32:14 140366191785728 [Note] WSREP: Service thread queue flushed.
2016-08-09  0:32:14 140376968276736 [Note] WSREP: Assign initial position for certification: 427614158, protocol version: 3
2016-08-09  0:32:14 140366191785728 [Note] WSREP: Service thread queue flushed.
2016-08-09  0:32:14 140366128867072 [Note] WSREP: Member 2.0 (DBG01-DB-SX01) synced with group.
2016-08-09  0:32:17 140366137259776 [Note] WSREP: (22d5ebda, 'tcp://0.0.0.0:4567') turning message relay requesting off
2016-08-09 18:53:04 140330167667456 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=8 solved by abort
2016-08-09 18:53:04 140330140388096 [Note] InnoDB: Online DDL : Start
2016-08-09 18:53:04 140330140388096 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
2016-08-09 18:53:05 140330126748416 [Note] WSREP: cluster conflict due to certification failure for threads:
2016-08-09 18:53:05 140330126748416 [Note] WSREP: Victim thread: 
   THD: 18123, mode: local, state: executing, conflict: cert failure, seqno: 446897287
   SQL: commit
2016-08-09 18:53:05 140366179957504 [Note] WSREP: cluster conflict due to certification failure for threads:
2016-08-09 18:53:05 140366179957504 [Note] WSREP: Victim thread: 
   THD: 18128, mode: local, state: executing, conflict: cert failure, seqno: 446897291
   SQL: commit
2016-08-09 18:53:16 140330140388096 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
2016-08-09 18:53:16 140330140388096 [Note] InnoDB: Online DDL : Start merge-sorting index `PRIMARY` (1 / 13), estimated cost : 10.0510
2016-08-09 18:53:16 140330140388096 [Note] InnoDB: Online DDL : merge-sorting has estimated 143 runs
2016-08-09 18:53:19 140330140388096 [Note] InnoDB: Online DDL : End of  merge-sorting index `PRIMARY` (1 / 13)
2016-08-09 18:53:19 140330140388096 [Note] InnoDB: Online DDL : Start building index `PRIMARY` (1 / 13), estimated cost : 15.0765
2016-08-09 18:53:25 140330140388096 [Note] InnoDB: Online DDL : End of building index `PRIMARY` (1 / 13)
2016-08-09 18:53:25 140330140388096 [Note] InnoDB: Online DDL : Completed
2016-08-09 18:53:25 140330140388096 [Note] InnoDB: Online DDL : Start merge-sorting index `ind_cpe_parId` (2 / 13), estimated cost : 1.9712
2016-08-09 18:53:25 140330140388096 [Note] InnoDB: Online DDL : merge-sorting has estimated 9 runs
2016-08-09 18:53:25 140330140388096 [Note] InnoDB: Online DDL : End of  merge-sorting index `ind_cpe_parId` (2 / 13)
2016-08-09 18:53:25 140330140388096 [Note] InnoDB: Online DDL : Start building index `ind_cpe_parId` (2 / 13), estimated cost : 2.9569
2016-08-09 18:53:26 140330140388096 [Note] InnoDB: Online DDL : End of building index `ind_cpe_parId` (2 / 13)
2016-08-09 18:53:26 140330140388096 [Note] InnoDB: Online DDL : Completed
2016-08-09 18:53:26 140330140388096 [Note] InnoDB: Online DDL : Start merge-sorting index `ind_cpe.ipaddr` (3 / 13), estimated cost : 2.0315
2016-08-09 18:53:26 140330140388096 [Note] InnoDB: Online DDL : merge-sorting has estimated 10 runs
2016-08-09 18:53:27 140330140388096 [Note] InnoDB: Online DDL : End of  merge-sorting index `ind_cpe.ipaddr` (3 / 13)
2016-08-09 18:53:27 140330140388096 [Note] InnoDB: Online DDL : Start building index `ind_cpe.ipaddr` (3 / 13), estimated cost : 3.0473
2016-08-09 18:53:28 140330140388096 [Note] InnoDB: Online DDL : End of building index `ind_cpe.ipaddr` (3 / 13)
2016-08-09 18:53:28 140330140388096 [Note] InnoDB: Online DDL : Completed
2016-08-09 18:53:28 140330140388096 [Note] InnoDB: Online DDL : Start merge-sorting index `ind_cpe.cm` (4 / 13), estimated cost : 2.3933
2016-08-09 18:53:28 140330140388096 [Note] InnoDB: Online DDL : merge-sorting has estimated 16 runs
2016-08-09 18:53:29 140330140388096 [Note] InnoDB: Online DDL : End of  merge-sorting index `ind_cpe.cm` (4 / 13)
2016-08-09 18:53:29 140330140388096 [Note] InnoDB: Online DDL : Start building index `ind_cpe.cm` (4 / 13), estimated cost : 3.5900
2016-08-09 18:53:30 140330140388096 [Note] InnoDB: Online DDL : End of building index `ind_cpe.cm` (4 / 13)
2016-08-09 18:53:30 140330140388096 [Note] InnoDB: Online DDL : Completed
2016-08-09 18:53:30 140330140388096 [Note] InnoDB: Online DDL : Start merge-sorting index `ind_cpe.hotareaid` (5 / 13), estimated cost : 1.9712
2016-08-09 18:53:30 140330140388096 [Note] InnoDB: Online DDL : merge-sorting has estimated 9 runs
2016-08-09 18:53:30 140330140388096 [Note] InnoDB: Online DDL : End of  merge-sorting index `ind_cpe.hotareaid` (5 / 13)
2016-08-09 18:53:30 140330140388096 [Note] InnoDB: Online DDL : Start building index `ind_cpe.hotareaid` (5 / 13), estimated cost : 2.9569
2016-08-09 18:53:32 140330140388096 [Note] InnoDB: Online DDL : End of building index `ind_cpe.hotareaid` (5 / 13)
2016-08-09 18:53:32 140330140388096 [Note] InnoDB: Online DDL : Completed
2016-08-09 18:53:32 140330140388096 [Note] InnoDB: Online DDL : Start merge-sorting index `ind_cpe.acpoolId` (6 / 13), estimated cost : 1.9109
2016-08-09 18:53:32 140330140388096 [Note] InnoDB: Online DDL : merge-sorting has estimated 8 runs
2016-08-09 18:53:32 140330140388096 [Note] InnoDB: Online DDL : End of  merge-sorting index `ind_cpe.acpoolId` (6 / 13)
2016-08-09 18:53:32 140330140388096 [Note] InnoDB: Online DDL : Start building index `ind_cpe.acpoolId` (6 / 13), estimated cost : 2.8664
2016-08-09 18:53:33 140330140388096 [Note] InnoDB: Online DDL : End of building index `ind_cpe.acpoolId` (6 / 13)
2016-08-09 18:53:33 140330140388096 [Note] InnoDB: Online DDL : Completed
2016-08-09 18:53:33 140330140388096 [Note] InnoDB: Online DDL : Start merge-sorting index `ind_cpe.area` (7 / 13), estimated cost : 2.5139
2016-08-09 18:53:33 140330140388096 [Note] InnoDB: Online DDL : merge-sorting has estimated 18 runs
2016-08-09 18:53:34 140330140388096 [Note] InnoDB: Online DDL : End of  merge-sorting index `ind_cpe.area` (7 / 13)
2016-08-09 18:53:34 140330140388096 [Note] InnoDB: Online DDL : Start building index `ind_cpe.area` (7 / 13), estimated cost : 3.7709
2016-08-09 18:53:35 140330140388096 [Note] InnoDB: Online DDL : End of building index `ind_cpe.area` (7 / 13)
2016-08-09 18:53:35 140330140388096 [Note] InnoDB: Online DDL : Completed
2016-08-09 18:53:35 140330140388096 [Note] InnoDB: Online DDL : Start merge-sorting index `ind_cpe.batchNum` (8 / 13), estimated cost : 2.0315
2016-08-09 18:53:35 140330140388096 [Note] InnoDB: Online DDL : merge-sorting has estimated 10 runs
2016-08-09 18:53:36 140330140388096 [Note] InnoDB: Online DDL : End of  merge-sorting index `ind_cpe.batchNum` (8 / 13)
2016-08-09 18:53:36 140330140388096 [Note] InnoDB: Online DDL : Start building index `ind_cpe.batchNum` (8 / 13), estimated cost : 3.0473
2016-08-09 18:53:37 140330140388096 [Note] InnoDB: Online DDL : End of building index `ind_cpe.batchNum` (8 / 13)
2016-08-09 18:53:37 140330140388096 [Note] InnoDB: Online DDL : Completed
2016-08-09 18:53:37 140330140388096 [Note] InnoDB: Online DDL : Start merge-sorting index `ind_cpe_macaddr` (9 / 13), estimated cost : 2.5742
2016-08-09 18:53:37 140330140388096 [Note] InnoDB: Online DDL : merge-sorting has estimated 19 runs
2016-08-09 18:53:37 140330140388096 [Note] InnoDB: Online DDL : End of  merge-sorting index `ind_cpe_macaddr` (9 / 13)
2016-08-09 18:53:37 140330140388096 [Note] InnoDB: Online DDL : Start building index `ind_cpe_macaddr` (9 / 13), estimated cost : 3.8613
2016-08-09 18:53:39 140330140388096 [Note] InnoDB: Online DDL : End of building index `ind_cpe_macaddr` (9 / 13)
2016-08-09 18:53:39 140330140388096 [Note] InnoDB: Online DDL : Completed
2016-08-09 18:53:39 140330140388096 [Note] InnoDB: Online DDL : Start merge-sorting index `ind_cpe_id` (10 / 13), estimated cost : 1.8506
2016-08-09 18:53:39 140330140388096 [Note] InnoDB: Online DDL : merge-sorting has estimated 7 runs
2016-08-09 18:53:39 140330140388096 [Note] InnoDB: Online DDL : End of  merge-sorting index `ind_cpe_id` (10 / 13)
2016-08-09 18:53:39 140330140388096 [Note] InnoDB: Online DDL : Start building index `ind_cpe_id` (10 / 13), estimated cost : 2.7760
2016-08-09 18:53:41 140330140388096 [Note] InnoDB: Online DDL : End of building index `ind_cpe_id` (10 / 13)
2016-08-09 18:53:41 140330140388096 [Note] InnoDB: Online DDL : Completed
2016-08-09 18:53:41 140330140388096 [Note] InnoDB: Online DDL : Start merge-sorting index `ind_cpe_entityName` (11 / 13), estimated cost : 3.4787
2016-08-09 18:53:41 140330140388096 [Note] InnoDB: Online DDL : merge-sorting has estimated 34 runs
2016-08-09 18:53:41 140330140388096 [Note] InnoDB: Online DDL : End of  merge-sorting index `ind_cpe_entityName` (11 / 13)
2016-08-09 18:53:41 140330140388096 [Note] InnoDB: Online DDL : Start building index `ind_cpe_entityName` (11 / 13), estimated cost : 5.2180
2016-08-09 18:53:43 140330140388096 [Note] InnoDB: Online DDL : End of building index `ind_cpe_entityName` (11 / 13)
2016-08-09 18:53:43 140330140388096 [Note] InnoDB: Online DDL : Completed
2016-08-09 18:53:43 140330140388096 [Note] InnoDB: Online DDL : Start merge-sorting index `ind_cpe_entityType` (12 / 13), estimated cost : 2.1521
2016-08-09 18:53:43 140330140388096 [Note] InnoDB: Online DDL : merge-sorting has estimated 12 runs
2016-08-09 18:53:43 140330140388096 [Note] InnoDB: Online DDL : End of  merge-sorting index `ind_cpe_entityType` (12 / 13)
2016-08-09 18:53:43 140330140388096 [Note] InnoDB: Online DDL : Start building index `ind_cpe_entityType` (12 / 13), estimated cost : 3.2282
2016-08-09 18:53:45 140330140388096 [Note] InnoDB: Online DDL : End of building index `ind_cpe_entityType` (12 / 13)
2016-08-09 18:53:45 140330140388096 [Note] InnoDB: Online DDL : Completed
2016-08-09 18:53:45 140330140388096 [Note] InnoDB: Online DDL : Start merge-sorting index `idx_cpe_createdate` (13 / 13), estimated cost : 2.2124
2016-08-09 18:53:45 140330140388096 [Note] InnoDB: Online DDL : merge-sorting has estimated 13 runs
2016-08-09 18:53:45 140330140388096 [Note] InnoDB: Online DDL : End of  merge-sorting index `idx_cpe_createdate` (13 / 13)
2016-08-09 18:53:45 140330140388096 [Note] InnoDB: Online DDL : Start building index `idx_cpe_createdate` (13 / 13), estimated cost : 3.3186
2016-08-09 18:53:46 140330140388096 [Note] InnoDB: Online DDL : End of building index `idx_cpe_createdate` (13 / 13)
2016-08-09 18:53:46 140330140388096 [Note] InnoDB: Online DDL : Completed
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18138, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18141, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18139, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18161, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18162, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18167, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18166, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18171, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18170, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18175, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18178, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18177, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18186, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18193, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18198, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18213, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18221, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18223, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18228, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18237, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18258, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18261, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18266, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18275, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18278, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18281, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18287, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18293, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18292, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18294, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18291, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18305, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18309, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18317, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18318, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18320, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18355, mode: local, state: idle, conflict: no conflict, seqno: -1
   SQL: (null)
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
2016-08-09 18:53:46 140330140388096 [Warning] WSREP: Cannot abort transaction.
2016-08-09 18:53:46 140330140388096 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Winning thread: 
   THD: 18116, mode: total order, state: executing, conflict: no conflict, seqno: 446897267
   SQL: ALTER TABLE `center_pub_entity`ADD COLUMN `AC_STATUS` VARCHAR(20) NULL DEFAULT NULL AFTER `REMARKS`
2016-08-09 18:53:46 140330140388096 [Note] WSREP: Victim thread: 
   THD: 18362, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: commit
2016-08-09 18:53:46 140330140388096 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=4 solved by abort
...
...
...
2016-08-09 18:53:47 140329019132672 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=8 solved by abort
2016-08-09 18:53:47 140329018223360 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=8 solved by abort
2016-08-09 18:53:47 140330131598080 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=8 solved by abort
2016-08-09 18:53:49 140366191785728 [Warning] WSREP: Failed to report last committed 446897265, -4 (Interrupted system call)
2016-08-09 20:57:33 140329013070592 [Note] WSREP: MDL conflict db=awifi_dc table=center_pub_entity ticket=8 solved by abort
 
*** Priority TRANSACTION:
TRANSACTION 674271512, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 8, OS thread handle 0x7fac0f464b00, query id 44171311 Write_rows_log_event::write_row(451253554)
 
*** Victim TRANSACTION:
TRANSACTION 674271510, ACTIVE 0 sec
mysql tables in use 1, locked 1
2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1
MySQL thread id 21164, OS thread handle 0x7fa0e5158b00, query id 44171309 172.22.4.172 DBcenter query end
insert into center_pub_merchant_visit_count 
   (merchant_id, device_id, user_id, page_flag, visit_date, visit_num)
    values 
    (57685, 'RADIUS-RADIUS-20150204-3a6e1b88', 
    'BC448657B0C4', '2', 
    '2016080922', 1)
   ON DUPLICATE KEY UPDATE
   visit_num = visit_num+1
*** WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 212 page no 245175 n bits 272 index `udx_cpmvc_mudvp` of table `awifi_dc`.`center_pub_merchant_visit_count` trx table locks 1 total table locks 2  trx id 674271510 lock_mode X locks rec but not gap lock hold time 0 wait time before grant 0 
2016-08-09 22:06:01 140376967367424 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-09 22:06:01 140376967367424 [Note] WSREP: Winning thread: 
   THD: 8, mode: applier, state: executing, conflict: no conflict, seqno: 451253554
   SQL: (null)
2016-08-09 22:06:01 140376967367424 [Note] WSREP: Victim thread: 
   THD: 21164, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: insert into center_pub_merchant_visit_count 
   (merchant_id, device_id, user_id, page_flag, visit_date, visit_num)
    values 
    (57685, 'RADIUS-RADIUS-20150204-3a6e1b88', 
    'BC448657B0C4', '2', 
    '2016080922', 1)
   ON DUPLICATE KEY UPDATE
   visit_num = visit_num+1
2016-08-10  8:38:59 140366191785728 [Warning] WSREP: Failed to report last committed 461511565, -4 (Interrupted system call)
2016-08-10 12:08:04 140366191785728 [Warning] WSREP: Failed to report last committed 465926507, -4 (Interrupted system call)
2016-08-10 16:03:22 140366191785728 [Warning] WSREP: Failed to report last committed 470323298, -4 (Interrupted system call)
 
*** Priority TRANSACTION:
TRANSACTION 709611022, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 9, OS thread handle 0x7fac0e098b00, query id 92371088 Write_rows_log_event::write_row(476583442)
 
*** Victim TRANSACTION:
TRANSACTION 709611020, ACTIVE 0 sec
mysql tables in use 1, locked 1
2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1
MySQL thread id 43081, OS thread handle 0x7fa1296a6b00, query id 92371086 172.22.4.172 DBcenter query end
insert into center_pub_merchant_visit_count 
   (merchant_id, device_id, user_id, page_flag, visit_date, visit_num)
    values 
    (188127, 'RADIUS-RADIUS-20150203-641eb815', 
    '0C1DAF5011EC', '2', 
    '2016081021', 1)
   ON DUPLICATE KEY UPDATE
   visit_num = visit_num+1
*** WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 212 page no 467010 n bits 152 index `udx_cpmvc_mudvp` of table `awifi_dc`.`center_pub_merchant_visit_count` trx table locks 1 total table locks 2  trx id 709611020 lock_mode X locks rec but not gap lock hold time 0 wait time before grant 0 
2016-08-10 21:40:01 140376946608896 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-10 21:40:01 140376946608896 [Note] WSREP: Winning thread: 
   THD: 9, mode: applier, state: executing, conflict: no conflict, seqno: 476583442
   SQL: (null)
2016-08-10 21:40:01 140376946608896 [Note] WSREP: Victim thread: 
   THD: 43081, mode: local, state: committing, conflict: no conflict, seqno: -1
   SQL: insert into center_pub_merchant_visit_count 
   (merchant_id, device_id, user_id, page_flag, visit_date, visit_num)
    values 
    (188127, 'RADIUS-RADIUS-20150203-641eb815', 
    '0C1DAF5011EC', '2', 
    '2016081021', 1)
   ON DUPLICATE KEY UPDATE
   visit_num = visit_num+1
 
*** Priority TRANSACTION:
TRANSACTION 709611022, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1184, 1 row lock(s), undo log entries 1
MySQL thread id 9, OS thread handle 0x7fac0e098b00, query id 92371088 Write_rows_log_event::write_row(476583442)
 
*** Victim TRANSACTION:
TRANSACTION 709611020, ACTIVE 0 sec rollback
mysql tables in use 1, locked 1
ROLLING BACK 2 lock struct(s), heap size 1184, 1 row lock(s)
MySQL thread id 43081, OS thread handle 0x7fa1296a6b00, query id 92371086 172.22.4.172 DBcenter query end
insert into center_pub_merchant_visit_count 
   (merchant_id, device_id, user_id, page_flag, visit_date, visit_num)
    values 
    (188127, 'RADIUS-RADIUS-20150203-641eb815', 
    '0C1DAF5011EC', '2', 
    '2016081021', 1)
   ON DUPLICATE KEY UPDATE
   visit_num = visit_num+1
*** WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 212 page no 467009 n bits 160 index `udx_cpmvc_mudvp` of table `awifi_dc`.`center_pub_merchant_visit_count` trx table locks 1 total table locks 3  trx id 709611020 lock_mode X locks gap before rec lock hold time 0 wait time before grant 0 
2016-08-10 21:40:01 140376946608896 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-10 21:40:01 140376946608896 [Note] WSREP: Winning thread: 
   THD: 9, mode: applier, state: executing, conflict: no conflict, seqno: 476583442
   SQL: (null)
2016-08-10 21:40:01 140376946608896 [Note] WSREP: Victim thread: 
   THD: 43081, mode: local, state: executing, conflict: void, seqno: -1
   SQL: insert into center_pub_merchant_visit_count 
   (merchant_id, device_id, user_id, page_flag, visit_date, visit_num)
    values 
    (188127, 'RADIUS-RADIUS-20150203-641eb815', 
    '0C1DAF5011EC', '2', 
    '2016081021', 1)
   ON DUPLICATE KEY UPDATE
   visit_num = visit_num+1
2016-08-11 18:31:43 140366191785728 [Warning] WSREP: Failed to report last committed 498122518, -4 (Interrupted system call)
2016-08-12 15:22:53 140366191785728 [Warning] WSREP: Failed to report last committed 512630314, -4 (Interrupted system call)
2016-08-12 15:31:58 140366191785728 [Warning] WSREP: Failed to report last committed 512702843, -4 (Interrupted system call)
 
*** Priority TRANSACTION:
TRANSACTION 781648649, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 10, OS thread handle 0x7fac0e04eb00, query id 201148955 Write_rows_log_event::write_row(523807211)
 
*** Victim TRANSACTION:
TRANSACTION 781648647, ACTIVE 0 sec
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1
MySQL thread id 107616, OS thread handle 0x7fa129d02b00, query id 201148953 172.22.4.171 DBcenter query end
insert into center_pub_merchant_visit_count 
   (merchant_id, device_id, user_id, page_flag, visit_date, visit_num)
    values 
    (59743, 'VLAN_20150609ec9e8625-5e31-4147-8fe7-406b3bc7c548', 
    '18DC56F05635', '4', 
    '2016081400', 1)
   ON DUPLICATE KEY UPDATE
   visit_num = visit_num+1
*** WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 212 page no 321782 n bits 168 index `udx_cpmvc_mudvp` of table `awifi_dc`.`center_pub_merchant_visit_count` trx table locks 1 total table locks 4  trx id 781648647 lock_mode X lock hold time 0 wait time before grant 0 
2016-08-14  0:14:01 140376946305792 [Note] WSREP: cluster conflict due to high priority abort for threads:
2016-08-14  0:14:01 140376946305792 [Note] WSREP: Winning thread: 
   THD: 10, mode: applier, state: executing, conflict: no conflict, seqno: 523807211
   SQL: (null)
2016-08-14  0:14:01 140376946305792 [Note] WSREP: Victim thread: 
   THD: 107616, mode: local, state: committing, conflict: no conflict, seqno: 523807209
   SQL: insert into center_pub_merchant_visit_count 
   (merchant_id, device_id, user_id, page_flag, visit_date, visit_num)
    values 
    (59743, 'VLAN_20150609ec9e8625-5e31-4147-8fe7-406b3bc7c548', 
    '18DC56F05635', '4', 
    '2016081400', 1)
   ON DUPLICATE KEY UPDATE
   visit_num = visit_num+1

160814  1:07:44  [ERROR] mysqld got signal 11 ;
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.
 
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
 
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.
 
Server version: 10.1.14-MariaDB
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=299
max_threads=5002
thread_count=69
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11117866 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
 
Thread pointer: 0x0x7fa139412008
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 = 0x7fac13a18150 thread_stack 0x48400
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x7fac145881be]
/usr/sbin/mysqld(handle_fatal_signal+0x38d)[0x7fac140b3f0d]
/lib64/libpthread.so.0(+0xf100)[0x7fac136d2100]
/usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG13mark_xid_doneEmb+0xc7)[0x7fac14175447]
/usr/sbin/mysqld(binlog_background_thread+0x2b5)[0x7fac14175a05]
/lib64/libpthread.so.0(+0x7dc5)[0x7fac136cadc5]
/lib64/libc.so.6(clone+0x6d)[0x7fac11aecced]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x0): 
Connection ID (thread ID): 3
Status: NOT_KILLED
 
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on
 
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.



 Comments   
Comment by Jan Lindström (Inactive) [ 2019-05-21 ]

Can you try with more recent version and if this is still reproducible please provide cluster configuration and full unedited error log.

Generated at Thu Feb 08 07:43:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.