2017-09-20 21:26:48 15659 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-09-20 21:26:48 15659 [Note] WSREP: wsrep_load(): loading provider library 'none'
2017-09-20 21:26:48 15659 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-09-20 21:26:48 15659 [Note] InnoDB: The InnoDB memory heap is disabled
2017-09-20 21:26:48 15659 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-20 21:26:48 15659 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-09-20 21:26:48 15659 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-09-20 21:26:48 15659 [Note] InnoDB: Using Linux native AIO
2017-09-20 21:26:48 15659 [Note] InnoDB: Not using CPU crc32 instructions
2017-09-20 21:26:48 15659 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-09-20 21:26:48 15659 [Note] InnoDB: Completed initialization of buffer pool
2017-09-20 21:26:48 15659 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2017-09-20 21:26:48 15659 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2017-09-20 21:26:48 15659 [Note] InnoDB: Database physically writes the file full: wait...
2017-09-20 21:26:49 15659 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2017-09-20 21:26:49 15659 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2017-09-20 21:26:50 15659 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2017-09-20 21:26:50 15659 [Warning] InnoDB: New log files created, LSN=45781
2017-09-20 21:26:50 15659 [Note] InnoDB: Doublewrite buffer not found: creating new
2017-09-20 21:26:51 15659 [Note] InnoDB: Doublewrite buffer created
2017-09-20 21:26:51 15659 [Note] InnoDB: 128 rollback segment(s) are active.
2017-09-20 21:26:51 15659 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-09-20 21:26:51 15659 [Note] InnoDB: Foreign key constraint system tables created
2017-09-20 21:26:51 15659 [Note] InnoDB: Creating tablespace and datafile system tables.
2017-09-20 21:26:51 15659 [Note] InnoDB: Tablespace and datafile system tables created.
2017-09-20 21:26:51 15659 [Note] InnoDB: Creating zip_dict and zip_dict_cols system tables.
2017-09-20 21:26:51 15659 [Note] InnoDB: zip_dict and zip_dict_cols system tables created.
2017-09-20 21:26:51 15659 [Note] InnoDB: Waiting for purge to start
2017-09-20 21:26:51 15659 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 0
2017-09-20 21:26:51 15659 [Note] RSA private key file not found: /var/lib/percona-xtradb-cluster//private_key.pem. Some authentication plugins will not work.
2017-09-20 21:26:51 15659 [Note] RSA public key file not found: /var/lib/percona-xtradb-cluster//public_key.pem. Some authentication plugins will not work.
2017-09-20 21:26:59 15659 [Note] WSREP: Service disconnected.
2017-09-20 21:27:00 15659 [Note] WSREP: Some threads may fail to exit.
2017-09-20 21:27:00 15659 [Note] Binlog end
2017-09-20 21:27:00 15659 [Note] InnoDB: FTS optimize thread exiting.
2017-09-20 21:27:00 15659 [Note] InnoDB: Starting shutdown...
2017-09-20 21:27:00 15659 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-20 21:27:02 15659 [Note] InnoDB: Shutdown completed; log sequence number 1631996
2017-09-20 21:27:02 15686 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-09-20 21:27:02 15686 [Note] WSREP: wsrep_load(): loading provider library 'none'
2017-09-20 21:27:02 15686 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-09-20 21:27:02 15686 [Note] InnoDB: The InnoDB memory heap is disabled
2017-09-20 21:27:02 15686 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-20 21:27:02 15686 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-09-20 21:27:02 15686 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-09-20 21:27:02 15686 [Note] InnoDB: Using Linux native AIO
2017-09-20 21:27:02 15686 [Note] InnoDB: Not using CPU crc32 instructions
2017-09-20 21:27:02 15686 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-09-20 21:27:02 15686 [Note] InnoDB: Completed initialization of buffer pool
2017-09-20 21:27:02 15686 [Note] InnoDB: Highest supported file format is Barracuda.
2017-09-20 21:27:02 15686 [Note] InnoDB: 128 rollback segment(s) are active.
2017-09-20 21:27:02 15686 [Note] InnoDB: Waiting for purge to start
2017-09-20 21:27:02 15686 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1631996
2017-09-20 21:27:02 15686 [Note] RSA private key file not found: /var/lib/percona-xtradb-cluster//private_key.pem. Some authentication plugins will not work.
2017-09-20 21:27:02 15686 [Note] RSA public key file not found: /var/lib/percona-xtradb-cluster//public_key.pem. Some authentication plugins will not work.
2017-09-20 21:27:02 15686 [Note] WSREP: Service disconnected.
2017-09-20 21:27:03 15686 [Note] WSREP: Some threads may fail to exit.
2017-09-20 21:27:03 15686 [Note] Binlog end
2017-09-20 21:27:03 15686 [Note] InnoDB: FTS optimize thread exiting.
2017-09-20 21:27:03 15686 [Note] InnoDB: Starting shutdown...
2017-09-20 21:27:04 15686 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-20 21:27:06 15686 [Note] InnoDB: Shutdown completed; log sequence number 1632006
2017-09-20 21:27:06 15723 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-09-20 21:27:06 15723 [Note] WSREP: wsrep_load(): loading provider library 'none'
2017-09-20 21:27:06 15723 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2017-09-20 21:27:06 15723 [Note] Plugin 'FEDERATED' is disabled.
2017-09-20 21:27:06 15723 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-09-20 21:27:06 15723 [Note] InnoDB: The InnoDB memory heap is disabled
2017-09-20 21:27:06 15723 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-20 21:27:06 15723 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-09-20 21:27:06 15723 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-09-20 21:27:06 15723 [Note] InnoDB: Using Linux native AIO
2017-09-20 21:27:06 15723 [Note] InnoDB: Not using CPU crc32 instructions
2017-09-20 21:27:06 15723 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-09-20 21:27:06 15723 [Note] InnoDB: Completed initialization of buffer pool
2017-09-20 21:27:06 15723 [Note] InnoDB: Highest supported file format is Barracuda.
2017-09-20 21:27:06 15723 [Note] InnoDB: 128 rollback segment(s) are active.
2017-09-20 21:27:06 15723 [Note] InnoDB: Waiting for purge to start
2017-09-20 21:27:06 15723 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1632006
2017-09-20 21:27:06 15723 [Note] RSA private key file not found: /var/lib/percona-xtradb-cluster//private_key.pem. Some authentication plugins will not work.
2017-09-20 21:27:06 15723 [Note] RSA public key file not found: /var/lib/percona-xtradb-cluster//public_key.pem. Some authentication plugins will not work.
2017-09-20 21:27:06 15723 [Note] WSREP: Service disconnected.
2017-09-20 21:27:07 15723 [Note] WSREP: Some threads may fail to exit.
2017-09-20 21:27:07 15723 [Note] Binlog end
2017-09-20 21:27:07 15723 [Note] InnoDB: FTS optimize thread exiting.
2017-09-20 21:27:07 15723 [Note] InnoDB: Starting shutdown...
2017-09-20 21:27:07 15723 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-20 21:27:09 15723 [Note] InnoDB: Shutdown completed; log sequence number 1632016
2017-09-20 21:27:09 15750 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-09-20 21:27:09 15750 [Note] WSREP: wsrep_load(): loading provider library 'none'
2017-09-20 21:27:09 15750 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2017-09-20 21:27:09 15750 [Note] Plugin 'FEDERATED' is disabled.
2017-09-20 21:27:09 15750 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-09-20 21:27:09 15750 [Note] InnoDB: The InnoDB memory heap is disabled
2017-09-20 21:27:09 15750 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-20 21:27:09 15750 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-09-20 21:27:09 15750 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-09-20 21:27:09 15750 [Note] InnoDB: Using Linux native AIO
2017-09-20 21:27:09 15750 [Note] InnoDB: Not using CPU crc32 instructions
2017-09-20 21:27:09 15750 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-09-20 21:27:09 15750 [Note] InnoDB: Completed initialization of buffer pool
2017-09-20 21:27:09 15750 [Note] InnoDB: Highest supported file format is Barracuda.
2017-09-20 21:27:09 15750 [Note] InnoDB: 128 rollback segment(s) are active.
2017-09-20 21:27:09 15750 [Note] InnoDB: Waiting for purge to start
2017-09-20 21:27:09 15750 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1632016
2017-09-20 21:27:09 15750 [Note] RSA private key file not found: /var/lib/percona-xtradb-cluster//private_key.pem. Some authentication plugins will not work.
2017-09-20 21:27:09 15750 [Note] RSA public key file not found: /var/lib/percona-xtradb-cluster//public_key.pem. Some authentication plugins will not work.
2017-09-20 21:27:09 15750 [Note] WSREP: Service disconnected.
2017-09-20 21:27:10 15750 [Note] WSREP: Some threads may fail to exit.
2017-09-20 21:27:10 15750 [Note] Binlog end
2017-09-20 21:27:10 15750 [Note] InnoDB: FTS optimize thread exiting.
2017-09-20 21:27:10 15750 [Note] InnoDB: Starting shutdown...
2017-09-20 21:27:11 15750 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-20 21:27:13 15750 [Note] InnoDB: Shutdown completed; log sequence number 1632026
170920 21:27:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/percona-xtradb-cluster
170920 21:27:14 mysqld_safe Skipping wsrep-recover for empty datadir: /var/lib/percona-xtradb-cluster
170920 21:27:14 mysqld_safe Assigning 00000000-0000-0000-0000-000000000000:-1 to wsrep_start_position
2017-09-20 21:27:14 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2017-09-20 21:27:14 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-09-20 21:27:14 0 [Note] /usr/sbin/mysqld (mysqld 5.6.34-79.1-79.1) starting as process 16217 ...
2017-09-20 21:27:14 16217 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2017-09-20 21:27:14 16217 [Note] Plugin 'FEDERATED' is disabled.
2017-09-20 21:27:14 16217 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-09-20 21:27:14 16217 [Note] InnoDB: The InnoDB memory heap is disabled
2017-09-20 21:27:14 16217 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-20 21:27:14 16217 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-09-20 21:27:14 16217 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-09-20 21:27:14 16217 [Note] InnoDB: Using Linux native AIO
2017-09-20 21:27:14 16217 [Note] InnoDB: Not using CPU crc32 instructions
2017-09-20 21:27:14 16217 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-09-20 21:27:14 16217 [Note] InnoDB: Completed initialization of buffer pool
2017-09-20 21:27:14 16217 [Note] InnoDB: Highest supported file format is Barracuda.
2017-09-20 21:27:14 16217 [Note] InnoDB: 128 rollback segment(s) are active.
2017-09-20 21:27:14 16217 [Note] InnoDB: Waiting for purge to start
2017-09-20 21:27:14 16217 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1632026
2017-09-20 21:27:14 16217 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 785cf3f2-9e4a-11e7-a061-00163ec1d898.
2017-09-20 21:27:14 16217 [Note] RSA private key file not found: /var/lib/percona-xtradb-cluster//private_key.pem. Some authentication plugins will not work.
2017-09-20 21:27:14 16217 [Note] RSA public key file not found: /var/lib/percona-xtradb-cluster//public_key.pem. Some authentication plugins will not work.
2017-09-20 21:27:14 16217 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-09-20 21:27:14 16217 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2017-09-20 21:27:14 16217 [Note] Server socket created on IP: '127.0.0.1'.
2017-09-20 21:27:14 16217 [Note] Event Scheduler: Loaded 0 events
2017-09-20 21:27:14 16217 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-09-20 21:27:14 16217 [Note] WSREP: wsrep_load(): loading provider library 'none'
2017-09-20 21:27:14 16217 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.34-79.1-79.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Percona XtraDB Cluster (GPL), Release 5.6.34-26.19.4c779b7, wsrep_26.19
2017-09-20 21:27:29 16217 [Note] /usr/sbin/mysqld: Normal shutdown

2017-09-20 21:27:29 16217 [Note] Giving 0 client threads a chance to die gracefully
2017-09-20 21:27:29 16217 [Note] Event Scheduler: Purging the queue. 0 events
2017-09-20 21:27:29 16217 [Note] Shutting down slave threads
2017-09-20 21:27:29 16217 [Note] Forcefully disconnecting 0 remaining clients
2017-09-20 21:27:29 16217 [Note] Binlog end
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'partition'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'BLACKHOLE'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_METRICS'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_CMP'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'INNODB_TRX'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'XTRADB_ZIP_DICT'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'XTRADB_RSEG'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
2017-09-20 21:27:29 16217 [Note] Shutting down plugin 'InnoDB'
2017-09-20 21:27:29 16217 [Note] InnoDB: FTS optimize thread exiting.
2017-09-20 21:27:29 16217 [Note] InnoDB: Starting shutdown...
2017-09-20 21:27:29 16217 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-20 21:27:31 16217 [Note] InnoDB: Shutdown completed; log sequence number 1632204
2017-09-20 21:27:31 16217 [Note] Shutting down plugin 'ARCHIVE'
2017-09-20 21:27:31 16217 [Note] Shutting down plugin 'CSV'
2017-09-20 21:27:31 16217 [Note] Shutting down plugin 'MRG_MYISAM'
2017-09-20 21:27:31 16217 [Note] Shutting down plugin 'MEMORY'
2017-09-20 21:27:31 16217 [Note] Shutting down plugin 'MyISAM'
2017-09-20 21:27:31 16217 [Note] Shutting down plugin 'sha256_password'
2017-09-20 21:27:31 16217 [Note] Shutting down plugin 'mysql_old_password'
2017-09-20 21:27:31 16217 [Note] Shutting down plugin 'mysql_native_password'
2017-09-20 21:27:31 16217 [Note] Shutting down plugin 'wsrep'
2017-09-20 21:27:31 16217 [Note] Shutting down plugin 'binlog'
2017-09-20 21:27:31 16217 [Note] /usr/sbin/mysqld: Shutdown complete

170920 21:27:31 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170920 21:27:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/percona-xtradb-cluster
170920 21:27:32 mysqld_safe Skipping wsrep-recover for empty datadir: /var/lib/percona-xtradb-cluster
170920 21:27:32 mysqld_safe Assigning 00000000-0000-0000-0000-000000000000:-1 to wsrep_start_position
2017-09-20 21:27:32 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-09-20 21:27:32 0 [Note] /usr/sbin/mysqld (mysqld 5.6.34-79.1-79.1) starting as process 17783 ...
2017-09-20 21:27:32 17783 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-09-20 21:27:32 17783 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/libgalera_smm.so'
2017-09-20 21:27:32 17783 [Note] WSREP: wsrep_load(): Galera 3.19(rXXXX) by Codership Oy <info@codership.com> loaded successfully.
2017-09-20 21:27:32 17783 [Note] WSREP: CRC-32C: using "slicing-by-8" algorithm.
2017-09-20 21:27:32 17783 [Warning] WSREP: Could not open state file for reading: '/var/lib/percona-xtradb-cluster//grastate.dat'
2017-09-20 21:27:32 17783 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootsrap: 1
2017-09-20 21:27:32 17783 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/percona-xtradb-cluster/; base_host = 10.228.66.59; base_port = 4567; cert.log_conflicts = no; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/percona-xtradb-cluster/; gcache.keep_pages_count = 0; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/percona-xtradb-cluster//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segmen
2017-09-20 21:27:32 17783 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(00000000-0000-0000-0000-000000000000:-1)
2017-09-20 21:27:32 17783 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
2017-09-20 21:27:32 17783 [Note] WSREP: wsrep_sst_grab()
2017-09-20 21:27:32 17783 [Note] WSREP: Start replication
2017-09-20 21:27:32 17783 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
2017-09-20 21:27:32 17783 [Note] WSREP: protonet asio version 0
2017-09-20 21:27:32 17783 [Note] WSREP: Using CRC-32C for message checksums.
2017-09-20 21:27:32 17783 [Note] WSREP: backend: asio
2017-09-20 21:27:32 17783 [Note] WSREP: gcomm thread scheduling priority set to other:0 
2017-09-20 21:27:32 17783 [Warning] WSREP: access file(/var/lib/percona-xtradb-cluster//gvwstate.dat) failed(No such file or directory)
2017-09-20 21:27:32 17783 [Note] WSREP: restore pc from disk failed
2017-09-20 21:27:32 17783 [Note] WSREP: GMCast version 0
2017-09-20 21:27:32 17783 [Note] WSREP: (83233218, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2017-09-20 21:27:32 17783 [Note] WSREP: (83233218, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2017-09-20 21:27:32 17783 [Note] WSREP: EVS version 0
2017-09-20 21:27:32 17783 [Note] WSREP: gcomm: bootstrapping new group 'juju_cluster'
2017-09-20 21:27:32 17783 [Note] WSREP: start_prim is enabled, turn off pc_recovery
2017-09-20 21:27:32 17783 [Note] WSREP: Node 83233218 state prim
2017-09-20 21:27:32 17783 [Note] WSREP: view(view_id(PRIM,83233218,1) memb {
	83233218,0
} joined {
} left {
} partitioned {
})
2017-09-20 21:27:32 17783 [Note] WSREP: save pc into disk
2017-09-20 21:27:32 17783 [Note] WSREP: gcomm: connected
2017-09-20 21:27:32 17783 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2017-09-20 21:27:32 17783 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2017-09-20 21:27:32 17783 [Note] WSREP: Opened channel 'juju_cluster'
2017-09-20 21:27:32 17783 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2017-09-20 21:27:32 17783 [Note] WSREP: Waiting for SST to complete.
2017-09-20 21:27:32 17783 [Note] WSREP: Starting new group from scratch: 83238286-9e4a-11e7-9e1e-4edf30abec62
2017-09-20 21:27:32 17783 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 83238451-9e4a-11e7-b959-aeef33f29a51
2017-09-20 21:27:32 17783 [Note] WSREP: STATE EXCHANGE: sent state msg: 83238451-9e4a-11e7-b959-aeef33f29a51
2017-09-20 21:27:32 17783 [Note] WSREP: STATE EXCHANGE: got state msg: 83238451-9e4a-11e7-b959-aeef33f29a51 from 0 (juju-24a047-0-lxd-1)
2017-09-20 21:27:32 17783 [Note] WSREP: Quorum results:
	version    = 4,
	component  = PRIMARY,
	conf_id    = 0,
	members    = 1/1 (joined/total),
	act_id     = 0,
	last_appl. = -1,
	protocols  = 0/7/3 (gcs/repl/appl),
	group UUID = 83238286-9e4a-11e7-9e1e-4edf30abec62
2017-09-20 21:27:32 17783 [Note] WSREP: Flow-control interval: [16, 16]
2017-09-20 21:27:32 17783 [Note] WSREP: Restored state OPEN -> JOINED (0)
2017-09-20 21:27:32 17783 [Note] WSREP: Member 0.0 (juju-24a047-0-lxd-1) synced with group.
2017-09-20 21:27:32 17783 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
2017-09-20 21:27:32 17783 [Note] WSREP: New cluster view: global state: 83238286-9e4a-11e7-9e1e-4edf30abec62:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3
2017-09-20 21:27:32 17783 [Note] WSREP: SST complete, seqno: 0
2017-09-20 21:27:32 17783 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2017-09-20 21:27:32 17783 [Note] Plugin 'FEDERATED' is disabled.
2017-09-20 21:27:32 17783 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-09-20 21:27:32 17783 [Note] InnoDB: The InnoDB memory heap is disabled
2017-09-20 21:27:32 17783 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-20 21:27:32 17783 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-09-20 21:27:32 17783 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-09-20 21:27:32 17783 [Note] InnoDB: Using Linux native AIO
2017-09-20 21:27:32 17783 [Note] InnoDB: Not using CPU crc32 instructions
2017-09-20 21:27:32 17783 [Note] InnoDB: Initializing buffer pool, size = 256.0M
2017-09-20 21:27:32 17783 [Note] InnoDB: Completed initialization of buffer pool
2017-09-20 21:27:32 17783 [Note] InnoDB: Highest supported file format is Barracuda.
2017-09-20 21:27:32 17783 [Note] InnoDB: 128 rollback segment(s) are active.
2017-09-20 21:27:32 17783 [Note] InnoDB: Waiting for purge to start
2017-09-20 21:27:32 17783 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1632204
2017-09-20 21:27:32 17783 [Note] RSA private key file not found: /var/lib/percona-xtradb-cluster//private_key.pem. Some authentication plugins will not work.
2017-09-20 21:27:32 17783 [Note] RSA public key file not found: /var/lib/percona-xtradb-cluster//public_key.pem. Some authentication plugins will not work.
2017-09-20 21:27:32 17783 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2017-09-20 21:27:32 17783 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2017-09-20 21:27:32 17783 [Note] Server socket created on IP: '0.0.0.0'.
2017-09-20 21:27:32 17783 [Warning] 'user' entry 'root@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:27:32 17783 [Warning] 'user' entry '@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:27:32 17783 [Warning] 'user' entry 'sstuser@ip6-localhost' ignored in --skip-name-resolve mode.
2017-09-20 21:27:32 17783 [Warning] 'proxies_priv' entry '@ root@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:27:32 17783 [Note] Event Scheduler: Loaded 0 events
2017-09-20 21:27:32 17783 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.34-79.1-79.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Percona XtraDB Cluster (GPL), Release 5.6.34-26.19.4c779b7, wsrep_26.19
2017-09-20 21:27:32 17783 [Note] WSREP: Initialized wsrep sidno 1
2017-09-20 21:27:32 17783 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2017-09-20 21:27:32 17783 [Note] WSREP: REPL Protocols: 7 (3, 2)
2017-09-20 21:27:32 17783 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3
2017-09-20 21:27:32 17783 [Note] WSREP: Service thread queue flushed.
2017-09-20 21:27:32 17783 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(83238286-9e4a-11e7-9e1e-4edf30abec62:0)
2017-09-20 21:27:32 17783 [Note] WSREP: Synchronized with group, ready for connections
2017-09-20 21:27:32 17783 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2017-09-20 21:38:39 17783 [Warning] 'user' entry 'root@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:38:39 17783 [Warning] 'user' entry '@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:38:39 17783 [Warning] 'user' entry 'sstuser@ip6-localhost' ignored in --skip-name-resolve mode.
2017-09-20 21:38:39 17783 [Warning] 'proxies_priv' entry '@ root@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:39:02 17783 [Warning] 'user' entry 'root@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:39:02 17783 [Warning] 'user' entry '@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:39:02 17783 [Warning] 'user' entry 'sstuser@ip6-localhost' ignored in --skip-name-resolve mode.
2017-09-20 21:39:02 17783 [Warning] 'proxies_priv' entry '@ root@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:39:20 17783 [Warning] 'user' entry 'root@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:39:20 17783 [Warning] 'user' entry '@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:39:20 17783 [Warning] 'user' entry 'sstuser@ip6-localhost' ignored in --skip-name-resolve mode.
2017-09-20 21:39:20 17783 [Warning] 'proxies_priv' entry '@ root@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:39:41 17783 [Warning] 'user' entry 'root@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:39:41 17783 [Warning] 'user' entry '@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:39:41 17783 [Warning] 'user' entry 'sstuser@ip6-localhost' ignored in --skip-name-resolve mode.
2017-09-20 21:39:41 17783 [Warning] 'proxies_priv' entry '@ root@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:40:53 17783 [Warning] 'user' entry 'root@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:40:53 17783 [Warning] 'user' entry '@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:40:53 17783 [Warning] 'user' entry 'sstuser@ip6-localhost' ignored in --skip-name-resolve mode.
2017-09-20 21:40:53 17783 [Warning] 'proxies_priv' entry '@ root@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:40:56 17783 [Warning] 'user' entry 'root@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:40:56 17783 [Warning] 'user' entry '@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:40:56 17783 [Warning] 'user' entry 'sstuser@ip6-localhost' ignored in --skip-name-resolve mode.
2017-09-20 21:40:56 17783 [Warning] 'proxies_priv' entry '@ root@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:40:58 17783 [Warning] 'user' entry 'root@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:40:58 17783 [Warning] 'user' entry '@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 21:40:58 17783 [Warning] 'user' entry 'sstuser@ip6-localhost' ignored in --skip-name-resolve mode.
2017-09-20 21:40:58 17783 [Warning] 'proxies_priv' entry '@ root@juju-24a047-0-lxd-1' ignored in --skip-name-resolve mode.
2017-09-20 22:05:59 ffff583fa1e0  InnoDB: Assertion failure in thread 281472162308576 in file ut0lst.h line 271
InnoDB: Failing assertion: list.count > 0
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
22:05:59 UTC - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.
Please help us make Percona XtraDB Cluster better by reporting any
bugs at https://bugs.launchpad.net/percona-xtradb-cluster

key_buffer_size=33554432
read_buffer_size=131072
max_used_connections=120
max_threads=1002
thread_count=121
connection_count=119
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 432019 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x127e4a10
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 = ffff583f9960 thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x44)[0x8e3b7c]

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

You may download the Percona XtraDB Cluster operations manual by visiting
http://www.percona.com/software/percona-xtradb-cluster/. You may find information
in the manual which will help you identify the cause of the crash.
170920 22:05:59 mysqld_safe Number of processes running now: 0
170920 22:05:59 mysqld_safe WSREP: not restarting wsrep node automatically
170920 22:05:59 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170920 22:24:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/percona-xtradb-cluster
170920 22:24:29 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/percona-xtradb-cluster/wsrep_recovery.XE5CXn' --pid-file='/var/lib/percona-xtradb-cluster/juju-24a047-0-lxd-1-recover.pid'
2017-09-20 22:24:29 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-09-20 22:24:29 0 [Note] /usr/sbin/mysqld (mysqld 5.6.34-79.1-79.1) starting as process 6880 ...
170920 22:24:33 mysqld_safe WSREP: Failed to recover position: 
Log of wsrep recovery (--wsrep-recover):
2017-09-20 22:24:29 6880 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2017-09-20 22:24:29 6880 [Note] Plugin 'FEDERATED' is disabled.
2017-09-20 22:24:29 6880 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-09-20 22:24:29 6880 [Note] InnoDB: The InnoDB memory heap is disabled
2017-09-20 22:24:29 6880 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-20 22:24:29 6880 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-09-20 22:24:29 6880 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-09-20 22:24:29 6880 [Note] InnoDB: Using Linux native AIO
2017-09-20 22:24:29 6880 [Note] InnoDB: Not using CPU crc32 instructions
2017-09-20 22:24:29 6880 [Note] InnoDB: Initializing buffer pool, size = 256.0M
2017-09-20 22:24:29 6880 [Note] InnoDB: Completed initialization of buffer pool
2017-09-20 22:24:29 6880 [Note] InnoDB: Highest supported file format is Barracuda.
2017-09-20 22:24:29 6880 [Note] InnoDB: Log scan progressed past the checkpoint lsn 24060234
2017-09-20 22:24:29 6880 [Note] InnoDB: Database was not shutdown normally!
2017-09-20 22:24:29 6880 [Note] InnoDB: Starting crash recovery.
2017-09-20 22:24:29 6880 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-09-20 22:24:29 6880 [Note] InnoDB: Restoring possible half-written data pages 
2017-09-20 22:24:29 6880 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 24065591
InnoDB: Transaction 31142 was in the XA prepared state.
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 0 row operations to undo
InnoDB: Trx id counter is 31488
2017-09-20 22:24:29 6880 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
2017-09-20 22:24:30 6880 [Note] InnoDB: 128 rollback segment(s) are active.
InnoDB: Starting in background the rollback of uncommitted transactions
2017-09-20 22:24:30 ffff784a51e0  InnoDB: Rollback of non-prepared transactions completed
2017-09-20 22:24:30 6880 [Note] InnoDB: Waiting for purge to start
2017-09-20 22:24:30 6880 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 24065591
2017-09-20 22:24:30 6880 [Warning] InnoDB: Skipping buffer pool dump/restore during wsrep recovery.
2017-09-20 22:24:30 ffff982da000  InnoDB: Starting recovery for XA transactions...
2017-09-20 22:24:30 ffff982da000  InnoDB: Transaction 31142 in prepared state after recovery
2017-09-20 22:24:30 ffff982da000  InnoDB: Transaction contains changes to 1 rows
2017-09-20 22:24:30 ffff982da000  InnoDB: 1 transactions in prepared state after recovery
2017-09-20 22:24:30 6880 [Note] Found 1 prepared transaction(s) in InnoDB
2017-09-20 22:24:30 6880 [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions.
2017-09-20 22:24:30 6880 [ERROR] Aborting

2017-09-20 22:24:30 6880 [Note] Binlog end
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'partition'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'BLACKHOLE'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_METRICS'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_CMP'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'INNODB_TRX'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'XTRADB_ZIP_DICT'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'XTRADB_RSEG'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
2017-09-20 22:24:30 6880 [Note] Shutting down plugin 'InnoDB'
2017-09-20 22:24:30 6880 [Note] InnoDB: FTS optimize thread exiting.
2017-09-20 22:24:30 6880 [Note] InnoDB: Starting shutdown...
2017-09-20 22:24:31 6880 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-20 22:24:33 6880 [Note] InnoDB: Shutdown completed; log sequence number 24065815
2017-09-20 22:24:33 6880 [Note] Shutting down plugin 'ARCHIVE'
2017-09-20 22:24:33 6880 [Note] Shutting down plugin 'CSV'
2017-09-20 22:24:33 6880 [Note] Shutting down plugin 'MRG_MYISAM'
2017-09-20 22:24:33 6880 [Note] Shutting down plugin 'MEMORY'
2017-09-20 22:24:33 6880 [Note] Shutting down plugin 'MyISAM'
2017-09-20 22:24:33 6880 [Note] Shutting down plugin 'sha256_password'
2017-09-20 22:24:33 6880 [Note] Shutting down plugin 'mysql_old_password'
2017-09-20 22:24:33 6880 [Note] Shutting down plugin 'mysql_native_password'
2017-09-20 22:24:33 6880 [Note] Shutting down plugin 'wsrep'
2017-09-20 22:24:33 6880 [Note] Shutting down plugin 'binlog'
2017-09-20 22:24:33 6880 [Note] /usr/sbin/mysqld: Shutdown complete

170920 22:24:33 mysqld_safe wsrep-recovery has failed to recover, continuing with startup
2017-09-20 22:24:33 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-09-20 22:24:33 0 [Note] /usr/sbin/mysqld (mysqld 5.6.34-79.1-79.1) starting as process 6924 ...
2017-09-20 22:24:33 6924 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-09-20 22:24:33 6924 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/libgalera_smm.so'
2017-09-20 22:24:33 6924 [Note] WSREP: wsrep_load(): Galera 3.19(rXXXX) by Codership Oy <info@codership.com> loaded successfully.
2017-09-20 22:24:33 6924 [Note] WSREP: CRC-32C: using "slicing-by-8" algorithm.
2017-09-20 22:24:33 6924 [Note] WSREP: Found saved state: 83238286-9e4a-11e7-9e1e-4edf30abec62:-1, safe_to_bootsrap: 1
2017-09-20 22:24:33 6924 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/percona-xtradb-cluster/; base_host = 10.228.66.59; base_port = 4567; cert.log_conflicts = no; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/percona-xtradb-cluster/; gcache.keep_pages_count = 0; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/percona-xtradb-cluster//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segmen
2017-09-20 22:24:33 6924 [Note] WSREP: GCache history reset: old(83238286-9e4a-11e7-9e1e-4edf30abec62:0) -> new(83238286-9e4a-11e7-9e1e-4edf30abec62:-1)
2017-09-20 22:24:33 6924 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
2017-09-20 22:24:33 6924 [Note] WSREP: wsrep_sst_grab()
2017-09-20 22:24:33 6924 [Note] WSREP: Start replication
2017-09-20 22:24:33 6924 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
2017-09-20 22:24:33 6924 [Note] WSREP: protonet asio version 0
2017-09-20 22:24:33 6924 [Note] WSREP: Using CRC-32C for message checksums.
2017-09-20 22:24:33 6924 [Note] WSREP: backend: asio
2017-09-20 22:24:33 6924 [Note] WSREP: gcomm thread scheduling priority set to other:0 
2017-09-20 22:24:33 6924 [Note] WSREP: restore pc from disk successfully
2017-09-20 22:24:33 6924 [Note] WSREP: GMCast version 0
2017-09-20 22:24:33 6924 [Note] WSREP: (83233218, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2017-09-20 22:24:33 6924 [Note] WSREP: (83233218, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2017-09-20 22:24:33 6924 [Note] WSREP: EVS version 0
2017-09-20 22:24:33 6924 [Note] WSREP: gcomm: connecting to group 'juju_cluster', peer ''
2017-09-20 22:24:33 6924 [Note] WSREP: start_prim is enabled, turn off pc_recovery
2017-09-20 22:24:33 6924 [Note] WSREP: Node 83233218 state prim
2017-09-20 22:24:33 6924 [Note] WSREP: view(view_id(PRIM,83233218,3) memb {
	83233218,0
} joined {
} left {
} partitioned {
})
2017-09-20 22:24:33 6924 [Note] WSREP: save pc into disk
2017-09-20 22:24:33 6924 [Note] WSREP: clear restored view
2017-09-20 22:24:33 6924 [Note] WSREP: gcomm: connected
2017-09-20 22:24:33 6924 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2017-09-20 22:24:33 6924 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2017-09-20 22:24:33 6924 [Note] WSREP: Opened channel 'juju_cluster'
2017-09-20 22:24:33 6924 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2017-09-20 22:24:33 6924 [Note] WSREP: Starting new group from scratch: 7a308206-9e52-11e7-adb4-46320cb17d9e
2017-09-20 22:24:33 6924 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 7a308447-9e52-11e7-8758-07ab41b2fb2a
2017-09-20 22:24:33 6924 [Note] WSREP: STATE EXCHANGE: sent state msg: 7a308447-9e52-11e7-8758-07ab41b2fb2a
2017-09-20 22:24:33 6924 [Note] WSREP: STATE EXCHANGE: got state msg: 7a308447-9e52-11e7-8758-07ab41b2fb2a from 0 (juju-24a047-0-lxd-1)
2017-09-20 22:24:33 6924 [Note] WSREP: Quorum results:
	version    = 4,
	component  = PRIMARY,
	conf_id    = 0,
	members    = 1/1 (joined/total),
	act_id     = 0,
	last_appl. = -1,
	protocols  = 0/7/3 (gcs/repl/appl),
	group UUID = 7a308206-9e52-11e7-adb4-46320cb17d9e
2017-09-20 22:24:33 6924 [Note] WSREP: Flow-control interval: [16, 16]
2017-09-20 22:24:33 6924 [Note] WSREP: Restored state OPEN -> JOINED (0)
2017-09-20 22:24:33 6924 [Note] WSREP: Member 0.0 (juju-24a047-0-lxd-1) synced with group.
2017-09-20 22:24:33 6924 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
2017-09-20 22:24:33 6924 [Note] WSREP: Waiting for SST to complete.
2017-09-20 22:24:33 6924 [Note] WSREP: New cluster view: global state: 7a308206-9e52-11e7-adb4-46320cb17d9e:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3
2017-09-20 22:24:33 6924 [Note] WSREP: SST complete, seqno: 0
2017-09-20 22:24:33 6924 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2017-09-20 22:24:33 6924 [Note] Plugin 'FEDERATED' is disabled.
2017-09-20 22:24:33 6924 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-09-20 22:24:33 6924 [Note] InnoDB: The InnoDB memory heap is disabled
2017-09-20 22:24:33 6924 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-20 22:24:33 6924 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-09-20 22:24:33 6924 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-09-20 22:24:33 6924 [Note] InnoDB: Using Linux native AIO
2017-09-20 22:24:33 6924 [Note] InnoDB: Not using CPU crc32 instructions
2017-09-20 22:24:33 6924 [Note] InnoDB: Initializing buffer pool, size = 256.0M
2017-09-20 22:24:33 6924 [Note] InnoDB: Completed initialization of buffer pool
2017-09-20 22:24:33 6924 [Note] InnoDB: Highest supported file format is Barracuda.
InnoDB: Transaction 31142 was in the XA prepared state.
2017-09-20 22:24:33 6924 [ERROR] InnoDB: Failed to find tablespace for table '"neutron"."bgp_speaker_dragent_bindings"' in the cache. Attempting to load the tablespace with space id 381.
2017-09-20 22:24:33 6924 [ERROR] InnoDB: Failed to find tablespace for table '"neutron"."cisco_hosting_devices"' in the cache. Attempting to load the tablespace with space id 279.
2017-09-20 22:24:33 6924 [ERROR] InnoDB: Failed to find tablespace for table '"neutron"."cisco_router_mappings"' in the cache. Attempting to load the tablespace with space id 281.
2017-09-20 22:24:33 6924 [ERROR] InnoDB: Failed to find tablespace for table '"neutron"."ha_router_agent_port_bindings"' in the cache. Attempting to load the tablespace with space id 197.
2017-09-20 22:24:33 6924 [ERROR] InnoDB: Failed to find tablespace for table '"neutron"."lbaas_loadbalanceragentbindings"' in the cache. Attempting to load the tablespace with space id 473.
2017-09-20 22:24:33 6924 [ERROR] InnoDB: Failed to find tablespace for table '"neutron"."networkdhcpagentbindings"' in the cache. Attempting to load the tablespace with space id 188.
2017-09-20 22:24:33 6924 [ERROR] InnoDB: Failed to find tablespace for table '"neutron"."routerl3agentbindings"' in the cache. Attempting to load the tablespace with space id 439.
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 0 row operations to undo
InnoDB: Trx id counter is 32000
2017-09-20 22:24:33 6924 [Note] InnoDB: 128 rollback segment(s) are active.
InnoDB: Starting in background the rollback of uncommitted transactions
2017-09-20 22:24:33 ffff7831a1e0  InnoDB: Rollback of non-prepared transactions completed
2017-09-20 22:24:33 6924 [Note] InnoDB: Waiting for purge to start
2017-09-20 22:24:33 6924 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 24065815
2017-09-20 22:24:33 ffffb3825000  InnoDB: Starting recovery for XA transactions...
2017-09-20 22:24:33 ffffb3825000  InnoDB: Transaction 31142 in prepared state after recovery
2017-09-20 22:24:33 ffffb3825000  InnoDB: Transaction contains changes to 1 rows
2017-09-20 22:24:33 ffffb3825000  InnoDB: 1 transactions in prepared state after recovery
2017-09-20 22:24:33 6924 [Note] Found 1 prepared transaction(s) in InnoDB
2017-09-20 22:24:33 6924 [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions.
2017-09-20 22:24:33 6924 [ERROR] Aborting

2017-09-20 22:24:35 6924 [Note] WSREP: Closing send monitor...
2017-09-20 22:24:35 6924 [Note] WSREP: Closed send monitor.
2017-09-20 22:24:35 6924 [Note] WSREP: gcomm: terminating thread
2017-09-20 22:24:35 6924 [Note] WSREP: gcomm: joining thread
2017-09-20 22:24:35 6924 [Note] WSREP: gcomm: closing backend
2017-09-20 22:24:35 6924 [Note] WSREP: view((empty))
2017-09-20 22:24:35 6924 [Note] WSREP: gcomm: closed
2017-09-20 22:24:35 6924 [Note] WSREP: Received self-leave message.
2017-09-20 22:24:35 6924 [Note] WSREP: Flow-control interval: [0, 0]
2017-09-20 22:24:35 6924 [Note] WSREP: Received SELF-LEAVE. Closing connection.
2017-09-20 22:24:35 6924 [Note] WSREP: Shifting SYNCED -> CLOSED (TO: 0)
2017-09-20 22:24:35 6924 [Note] WSREP: RECV thread exiting 0: Success
2017-09-20 22:24:35 6924 [Note] WSREP: recv_thread() joined.
2017-09-20 22:24:35 6924 [Note] WSREP: Closing replication queue.
2017-09-20 22:24:35 6924 [Note] WSREP: Closing slave action queue.
2017-09-20 22:24:35 6924 [Note] WSREP: Service disconnected.
2017-09-20 22:24:35 6924 [Note] WSREP: rollbacker thread exiting
2017-09-20 22:24:36 6924 [Note] WSREP: Some threads may fail to exit.
2017-09-20 22:24:36 6924 [Note] Binlog end
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'partition'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'BLACKHOLE'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_METRICS'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_CMP'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'INNODB_TRX'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'XTRADB_ZIP_DICT'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'XTRADB_RSEG'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
2017-09-20 22:24:36 6924 [Note] Shutting down plugin 'InnoDB'
2017-09-20 22:24:36 6924 [Note] InnoDB: FTS optimize thread exiting.
2017-09-20 22:24:36 6924 [Note] InnoDB: Starting shutdown...
2017-09-20 22:24:36 6924 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-20 22:24:38 6924 [Note] InnoDB: Shutdown completed; log sequence number 24065825
2017-09-20 22:24:38 6924 [Note] Shutting down plugin 'ARCHIVE'
2017-09-20 22:24:38 6924 [Note] Shutting down plugin 'CSV'
2017-09-20 22:24:38 6924 [Note] Shutting down plugin 'MRG_MYISAM'
2017-09-20 22:24:38 6924 [Note] Shutting down plugin 'MEMORY'
2017-09-20 22:24:38 6924 [Note] Shutting down plugin 'MyISAM'
2017-09-20 22:24:38 6924 [Note] Shutting down plugin 'sha256_password'
2017-09-20 22:24:38 6924 [Note] Shutting down plugin 'mysql_old_password'
2017-09-20 22:24:38 6924 [Note] Shutting down plugin 'mysql_native_password'
2017-09-20 22:24:38 6924 [Note] Shutting down plugin 'wsrep'
2017-09-20 22:24:38 6924 [Note] Shutting down plugin 'binlog'
2017-09-20 22:24:38 6924 [Note] /usr/sbin/mysqld: Shutdown complete

Error in my_thread_global_end(): 1 threads didn't exit
170920 22:24:43 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended