[MDEV-21711] Log: "Server Version xx.xx.xx starting" as very first thing when an instance is starting Created: 2020-02-12  Updated: 2020-07-23

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: Claudio Nanni Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 1
Labels: None

Issue Links:
Relates
relates to MDEV-6873 On startup please make MariaDB report... Closed
relates to MDEV-9593 Print the real version in the error log Closed
relates to MDEV-10967 Print the real version in the error l... Closed
relates to MDEV-17093 Print version_source_revision in the ... Closed
relates to MDEV-21046 Print server version to error log ins... Open
relates to MDEV-10648 mysqld --log-error prints on stdout a... Confirmed
relates to MDEV-20287 Have the server process print a "star... Open
relates to MDEV-20344 startup messages belong in stderr/err... Closed

 Description   

Still today it's not straightforward to spot the point in the log where an instance is started.
I think it would be extremely helpful to add a line as very first thing logged as:

2020-02-12 12:00:00 [note] SERVER XX.XX.XX STARTING

Or something like that.

Ideally not sure if possible, even a:

2020-02-12 13:00:00 [note] SERVER XX.XX.XX STOPPED

For example see here, there is a server shutdown and restart here:

020-02-11 16:50:24 17 [Note] WSREP: Applier thread exiting ret: 6 thd: 17
 
2020-02-11 16:50:24 1 [Note] WSREP: Applier thread exiting ret: 6 thd: 1
 
2020-02-11 16:50:24 17 [Warning] Aborted connection 17 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
 
2020-02-11 16:50:24 18 [Warning] Aborted connection 18 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
 
2020-02-11 16:50:24 24 [Warning] Aborted connection 24 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
 
2020-02-11 16:50:24 13 [Warning] Aborted connection 13 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
 
2020-02-11 16:50:24 15 [Warning] Aborted connection 15 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
 
2020-02-11 16:50:24 20 [Warning] Aborted connection 20 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
 
2020-02-11 16:50:24 16 [Warning] Aborted connection 16 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
 
2020-02-11 16:50:24 1 [Warning] Aborted connection 1 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
 
2020-02-11 16:52:29 0 [Note] WSREP: Loading provider /usr/lib64/galera-4/libgalera_smm.so initial position: 059a9557-9f3f-11e9-8bcc-93de23623d28:759142497
 
wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib64/galera-4/libgalera_smm.so'
 
wsrep loader: [INFO] wsrep_load(): Galera 26.4.3(r4535) by Codership Oy <info@codership.com> loaded successfully.
 
2020-02-11 16:52:29 0 [Note] WSREP: CRC-32C: using hardware acceleration.
 
2020-02-11 16:52:29 0 [Note] WSREP: Found saved state: 059a9557-9f3f-11e9-8bcc-93de23623d28:759142497, safe_to_bootstrap: 0
 
2020-02-11 16:52:29 0 [Note] WSREP: GCache DEBUG: opened preamble:
 
Version: 2
 
UUID: 059a9557-9f3f-11e9-8bcc-93de23623d28
 
Seqno: -1 - -1
 
Offset: -1
 
Synced: 0



 Comments   
Comment by Geoff Montee (Inactive) [ 2020-02-12 ]

This looks like a duplicate of MDEV-20287 and/or MDEV-21046.

Generated at Thu Feb 08 09:09:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.