Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. 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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.1.14
    • N/A
    • Galera
    • 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

        Activity

          People

            jplindst Jan Lindström (Inactive)
            1qaz2wsx Yao lin
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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