Not the answer you need?
Register and ask your own question!

getting warning on fresh PXC

GajendraGajendra ContributorCurrent User Role Patron
we have 3 node PXC and i just started 1st,2nd,third node now all nodes are in sync but getting few warning.




Node 1 (bootstrap)
grep "Warning" /var/log/mysqld.err.log

2018-08-24T13:57:28.287248Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-08-24T13:57:28.287248Z 0 [Warning] WSREP: Node is running in bootstrap/initialize mode. Disabling pxc_strict_mode checks
2018-08-24T13:57:28.503903Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-08-24T13:57:28.568242Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-08-24T13:57:28.645850Z 0 [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: a35856-67a5-78e8-a566-gj53er.
2018-08-24T13:57:28.647255Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-08-24T13:57:28.894914Z 0 [Warning] CA certificate ca.pem is self signed.
2018-08-24T13:57:38.585644Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-08-24T13:57:38.598178Z 0 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat'
2018-08-24T13:57:38.598188Z 0 [Warning] WSREP: No persistent state found. Bootstraping with default state
2018-08-24T13:57:38.621297Z 0 [Warning] WSREP: Fail to access the file (/var/lib/mysql//gvwstate.dat) error (No such file or directory). It is possible if node is booting for first time or re-booting after a graceful shutdown
2018-08-24T13:57:38.955669Z 0 [Warning] CA certificate ca.pem is self signed.

Node 2
grep "Warning" /var/log/mysqld.err.log
2018-08-24T14:17:55.966003Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-08-24T14:17:55.966089Z 0 [Warning] WSREP: Node is running in bootstrap/initialize mode. Disabling pxc_strict_mode checks
2018-08-24T14:17:56.199920Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-08-24T14:17:56.274206Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-08-24T14:17:56.354466Z 0 [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: 7f19d7d5-a7a8-11e8-8663-0050560100c8.
2018-08-24T14:17:56.359437Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-08-24T14:17:56.839239Z 0 [Warning] CA certificate ca.pem is self signed.
2018-08-24T14:18:05.206784Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-08-24T14:18:05.218176Z 0 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat'
2018-08-24T14:18:05.218187Z 0 [Warning] WSREP: No persistent state found. Bootstraping with default state
2018-08-24T14:18:05.246499Z 0 [Warning] WSREP: Fail to access the file (/var/lib/mysql//gvwstate.dat) error (No such file or directory). It is possible if node is booting for first time or re-booting after a graceful shutdown
2018-08-24T14:18:05.250184Z 0 [Warning] WSREP: (8466aa78, '') address '' points to own listening address, blacklisting
2018-08-24T14:18:06.251504Z 1 [Warning] WSREP: Gap in state sequence. Need state transfer.
2018-08-24T14:18:23.079954Z 0 [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: dfh566c-a7a8-11e8-8676-54654gh.
2018-08-24T14:18:23.100103Z 0 [Warning] CA certificate ca.pem is self signed.
8:04 PM

Node 3
grep "Warning" /var/log/mysqld.err.log

2018-08-24T14:22:09.860340Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-08-24T14:22:9.860420Z 0 [Warning] WSREP: Node is running in bootstrap/initialize mode. Disabling pxc_strict_mode checks
2018-08-24T14:22:10.075730Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-08-24T14:22:10.164686Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-08-24T14:22:10.239854Z 0 [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: 166dadc7-a7a9-11e8-8449-5656hhgrt6.
2018-08-24T14:22:10.241843Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-08-24T14:22:10.826605Z 0 [Warning] CA certificate ca.pem is self signed.
2018-08-24T14:22:20.104064Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-08-24T14:22:20.116997Z 0 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat'
2018-08-24T14:22:20.117007Z 0 [Warning] WSREP: No persistent state found. Bootstraping with default state
2018-08-24T14:22:020.141666Z 0 [Warning] WSREP: Fail to access the file (/var/lib/mysql//gvwstate.dat) error (No such file or directory). It is possible if node is booting for first time or re-booting after a graceful shutdown
2018-08-24T14:22:20.144486Z 0 [Warning] WSREP: (1c549521, '') address '' points to own listening address, blacklisting
2018-08-24T14:22:21.145597Z 2 [Warning] WSREP: Gap in state sequence. Need state transfer.
2018-08-24T14:22:37.730190Z 0 [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: 26d05eee-a7a9-11e8-9a62-546tryr65.
2018-08-24T14:22:37.737697Z 0 [Warning] CA certificate ca.pem is self signed.

configuration file

## my.cnf

log_bin =mysql-bin
expire_logs_days = 2
max_binlog_size = 104857600
server_id = 1
binlog_format = ROW
innodb_buffer_pool_size = 100M
innodb_flush_log_at_trx_commit = 1
innodb_flush_method = O_DIRECT
innodb_log_files_in_group = 2
innodb_log_file_size = 20M
innodb_file_per_table = 1
datadir = /var/lib/mysql
max_connections =200


wsrep_cluster_address = gcomm://nod1,node2,node3
wsrep_provider = /usr/lib64/galera3/libgalera_smm.so
wsrep_slave_threads = 8
wsrep_cluster_name = pxc cluster
wsrep_node_name = node1
wsrep_node_address = node1
wsrep_sst_method = xtrabackup-v2
wsrep_sst_auth = dummyuser:*******
#explicit_defaults_for_timestamp =1
innodb_autoinc_lock_mode = 2
log_error = /var/log/mysqld.err.log


[mysqld_safe]
pid-file = /var/run/mysqld/mysqld.pid
log_error = /var/log/mysqld.err.log


did i make any misconfiguration here ?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.