Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21711

Log: "Server Version xx.xx.xx starting" as very first thing when an instance is starting

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    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

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-6873 On startup please make MariaDB report it's version number

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9593 Print the real version in the error log

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10967 Print the real version in the error log #2

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-17093 Print version_source_revision in the error log upon server startup

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21046 Print server version to error log instead of stderr during startup process

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10648 mysqld --log-error prints on stdout at start

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20287 Have the server process print a "starting mysql" message before first actual log message

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20344 startup messages belong in stderr/error-log not stdout

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              sanja Oleksandr Byelkin
              claudio.nanni Claudio Nanni
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.