Error Logs

Overview

Error Logs record important database server output related to configuration and operation.

Despite being called "error logs", these logs typically contain both data related to errors and data which does not represent an error. The log is so named because this output is sent to stderr (standard error).

Compatibility

  • Multi-Node Analytics

  • Replicated Transactions

  • Single Node Analytics

  • Single Node Transactions

Configuration Manager

The log_warnings system variable defines error log verbosity:

  • This parameter can be set in Configuration Manager.

  • After a configuration has been prepared with the intended parameters, it must be applied to the desired service for this change to take effect.

  • The service will be restarted when the configuration is applied.

Log Archive

Error Log data is available in the Log Archive.

To download log data:

  1. Log in to the MariaDB SkySQL portal.

  2. Access "Monitoring" in left navigation.

  3. From SkySQL Monitoring, access "Logs" in left navigation.

  4. Select the desired server(s), log types (such as "Error Log"), and time frame, then click the "Download" button to download the logs.

    • Log files can be downloaded in your choice of JSON and/or plain text formats.

    • The downloaded .zip archive will contain one file per server, log, day, and format.

Data Retention

  • The Log Archive retains log data for 7 years. Data is retained even if the SkySQL service is deleted.

  • Logs are stored in GCS buckets with HTTPS data-in-transit encryption and Google default (AES256) data-at-rest encryption.

  • Logs are stored by day, by service, by server, by log type.

  • To request log data expungement, submit a Support Request.

  • Data retention requirements vary by business. A business process may be needed to download error log data in support of your data retention requirements.

Log Format

Fields

Error log lines vary in structure and content.

Most rows include as a first field the date in YYYY-MM-DD format.

Most rows state precedence of error, warning, or note.

Plain Text

When downloaded in plain text format, Error Log data is as outputted by the database server.

JSON

When downloaded in JSON format, Error Log data has this format for each line, incorporating the plain text format:

{"log":"PLAIN_TEXT","offset":OFFSET_VALUE}

One JSON object is produced for each logical line from the original plain text log file.

JSON key order is not guaranteed.