Bug #82874 MySQL 8.0 Upgrade - messages in mysqld log without datetime [Note] info

• Submitted: 6 Sep 2016 18:20
• Modified: 23 Sep 2016 13:36
• Reporter: Susan Koerner
• Status: Closed
• Category: MySQL Server: Errors
• Severity: S3 (Non-critical)
• Version: 8.0.0
• OS: Any
• CPU Architecture: Any

[6 Sep 2016 18:20] Susan Koerner

Description:
When performing a live/inplace upgrade from 5.7.x to 8.0.0, messages are written to the mysqld log without standard date format:

mysqld: Table 'mysql.version' doesn't exist
2016-08-26T17:42:38.734167Z 1 [Note] Created Data Dictionary for upgrade
mysqld: Table 'information_schema.COLUMNS' doesn't exist
mysqld: Table 'information_schema.TABLES' doesn't exist
mysqld: Table 'information_schema.STATISTICS' doesn't exist
mysqld: Table 'information_schema.STATISTICS' doesn't exist
2016-08-26T17:42:41.127664Z 3 [Note] Finished populating Data Dictionary tables with data.

How to repeat:
Perform a basic Live Upgrade and check error log

1 initialize 5.7 mysqld
2 startup mysqld on 5.7
3 shutdown mysqld
4 startup mysqld on 8.0 using 5.7 data directory
5 review mysqld log

Suggested fix:
add appropriate "2016-08-26T17:42:41.127664Z 3 [Note]" to the beginning of the message to match the TZ and format of the rest of the mysqld log.

[23 Sep 2016 13:36] Paul DuBois

Posted by developer:
 
Noted in 8.0.1 changelog.

Some messages written by the server to the error log while upgrading
the data directory were missing the standard timestamp and process ID
information.