[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 - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Cannot Reproduce
Affects Version/s: 10.1.14
Fix Version/s: N/A
Component/s: Galera
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

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.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

DBG01-DB-JH01.err_20160815
223 kB
2016-08-21 07:14

Activity

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Yao lin

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2016-08-21 06:55

Updated:: 2019-05-21 10:06

Resolved:: 2019-05-21 10:06

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.