# getting warning on fresh PXC **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [August 24, 2018, 10:00am UTC](https://forums.percona.com/t/getting-warning-on-fresh-pxc/6536 "2018-08-24T10:00:55Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![Gajendra](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gajendra/32/44_2.png) [@Gajendra](https://forums.percona.com/u/Gajendra)\ **Post date:** [August 24, 2018, 10:00am UTC](https://forums.percona.com/t/getting-warning-on-fresh-pxc/6536/1 "2018-08-24T10:00:55Z")
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 ?