Description
Hello,
I've downloaded the Download Linux binary x86_64 of (MySQL 5.7.34 with wsrep Patch Version 25.26).
If log-error-verbosity=2, then the instance won't start.
If log-error-verbosity=3, then we are good.
This happens every single time....
---- Starting with log_error_verbosity=2 (Does NOT work) ---
mysql> bin/mysqld_safe --defaults-file=$MYSQL_HOME/my.cnf --log-error=/mysql/admin/logs/mysqld_$MYSQL_SVR.log --log-error-verbosity=2 &
[2] 36728
mysql[grouper1GC]> sed: -e expression #1, char 26: unknown option to `s'
2021-07-27T20:05:06.587551Z mysqld_safe Logging to '/mysql/admin/logs/mysqld_grouper1GC.log'.
2021-07-27T20:05:06.616384Z mysqld_safe Starting mysqld daemon with databases from /mysql/data/grouper1GC
2021-07-27T20:05:06.623773Z mysqld_safe WSREP: Running position recovery with --log_error='/mysql/data/grouper1GC/wsrep_recovery.NxStoe' --pid-file='/mysql/data/grouper1GC/ dba-mdb-d05.andrew.local.cmu.edu-recover.pid'
mysql[grouper1GC]> 2021-07-27T20:05:08.848888Z mysqld_safe WSREP: Failed to recover position: 2021-07-27T16:05:06.836268-05:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-07-27T16:05:06.836344-05:00 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2021-07-27T16:05:06.836348-05:00 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2021-07-27T16:05:06.843320-05:00 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
---- Starting with log_error_verbosity=3 (Does work) ---
mysql[grouper1GC]> bin/mysqld_safe --defaults-file=$MYSQL_HOME/my.cnf --log-error=/mysql/admin/logs/mysqld_$MYSQL_SVR.log --log-error-verbosity=3 &
[2] 38410
dba-mdb-d05[~/product/MySQLGalera5.7-grouper]
mysql[grouper1GC]> sed: -e expression #1, char 26: unknown option to `s'
2021-07-27T20:12:35.073208Z mysqld_safe Logging to '/mysql/admin/logs/mysqld_grouper1GC.log'.
2021-07-27T20:12:35.103744Z mysqld_safe Starting mysqld daemon with databases from /mysql/data/grouper1GC
2021-07-27T20:12:35.111699Z mysqld_safe WSREP: Running position recovery with --log_error='/mysql/data/grouper1GC/wsrep_recovery.IQvhRo' --pid-file='/mysql/data/grouper1GC/dba-mdb-d05.andrew.local.cmu.edu-recover.pid'
2021-07-27T20:12:37.560997Z mysqld_safe WSREP: Recovered position 7b6a47c3-ee26-11eb-bcdd-5293b90fb548:5
Thanks,
Jenn