Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.1.14
-
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.
|