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 Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:8.0.0 OS:Any
Assigned to: CPU Architecture:Any

[6 Sep 2016 18:20] Susan Koerner
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