5.7 HeatWave Lakehouse Error Messages

See MySQL 9.0 Error Message Reference for Lakehouse error messages.

Some Lakehouse error and warning messages include the URL to the external object. The URL can contain up to 1024 characters, and exceed the error message limit of 512 characters. As of MySQL 9.0.1-u1, the truncated message will include a MySQL command to access the full error message. For example:

• Error message:

  ERROR HY000: Message was truncated, use 
  <SELECT data FROM performance_schema.error_log 
  WHERE thread_id=15 AND data LIKE 'ERR_LH_test.t1_long_name_6045%' 
  ORDER BY LOGGED DESC>
  to obtain more detailed information about the warning/error

• Warning message:

  Warning	6045	Message was truncated, use 
  <SELECT data FROM performance_schema.error_log 
  WHERE thread_id=15 AND data LIKE 'WARN_LH_test.t1_long_name_6045_0%' 
  ORDER BY LOGGED DESC>
  to obtain more detailed information about the warning/error

As of MySQL 9.0.1-u1, it is possible to filter out Lakehouse warning messages from the console, MySQL Shell and error log following a load command. The console Total Warnings will include both the displayed and the filtered warnings count. This does not filter error messages.

Use the lakehouse_filter_warning_codes_list session variable to filter warning messages by error code. For example:

mysql> SET @@session.lakehouse_filter_warning_codes_list = '6017,5099,6018';

Use the lakehouse_filter_warning_modes_list session variable to filter warning messages by mode. For example:

mysql> SET @@session.lakehouse_filter_warning_modes_list = 
       'NUMERIC_TRUNCATION,STRING_TRUNCATION,EMPTY_FILES,DUPLICATE_FILES';

The supported modes are:

• Mode: AVRO_FILE_BLOCK_HEADER filters the following warning messages:

  • ER_LH_AVRO_CANNOT_PARSE_HEADER

  • ER_LH_AVRO_HEADER_METADATA_ERR

  • ER_LH_FORMAT_HEADER_NO_MAGIC_BYTES

  • ER_LH_AVRO_HEADER_NO_SCHEMA

  • ER_LH_AVRO_INVALID_BLOCK_RECORD_COUNT

  • ER_LH_AVRO_INVALID_BLOCK_SIZE

  • ER_LH_AVRO_NO_CODEC_IN_HEADER

• Mode: DUPLICATE_FILES filters the following warning messages:

  • ER_LH_DUPLICATE_FILE

• Mode: EMPTY_FILES filters the following warning messages:

  • ER_LH_EMPTY_FILE

• Mode: EMPTY_MISSING_COLUMNS filters the following warning messages:

  • ER_LH_COLUMN_MISMATCH_ERR

  • ER_LH_COLUMN_MAX_ERR

  • ER_LH_WARN_COL_MISSING_NOT_NULLABLE

  • ER_LH_COL_IS_EMPTY_WARN

• Mode: INFER_SKIPPED filters the following warning messages:

  • ER_LH_INFER_FILE_HAS_NO_DATA

  • ER_LH_WARN_INFER_SKIPPED_FILES

  • ER_LH_WARN_INFER_SKIPPED_LINES

• Mode: MISSING_FILES filters the following warning messages:

  • ER_LH_NO_FILES_FOUND

• Mode: NULL_COLUMNS filters the following warning messages:

  • ER_LH_COL_NOT_NULLABLE

• Mode: NUMERIC_PARSING for the int, decimal, float, and double data types filters the following warning messages:

  • ER_LH_BAD_VALUE

  • ER_LH_DECIMAL_OOM_ERR

  • ER_LH_DECIMAL_UNKNOWN_ERR

  • ER_LH_PARQUET_DECIMAL_CONVERSION_ERR

  • ER_LH_REAL_IS_NAN

• Mode: NUMERIC_TRUNCATION for the int, decimal, float, and double data types filters the following warning messages:

  • ER_LH_DECIMAL_PRECISION_EXCEEDS_SCHEMA

  • ER_LH_EXCEEDS_MAX

  • ER_LH_EXCEEDS_MIN

  • ER_LH_OUT_OF_RANGE

  • ER_LH_WARN_DECIMAL_ROUNDING

  • ER_LH_WARN_EXCEEDS_MIN_TRUNCATING

  • ER_LH_WARN_EXCEEDS_MAX_TRUNCATING

  • ER_LH_WARN_TRUNCATED

• Mode: STRING_PARSING for the char, enum, text, and varchar data types filters the following warning messages:

  • ER_LH_BAD_VALUE

  • ER_LH_CANNOT_CONVERT_STRING

• Mode: STRING_TRUNCATION for the char, text, and varchar data types filters the following warning messages:

  • ER_LH_STRING_TOO_LONG

• Mode: TEMPORAL_PARSING for the date, datetime, time, and timestamp data types filters the following warning messages:

  • ER_LH_BAD_VALUE

  • ER_LH_DATETIME_FORMAT

• Mode: TEMPORAL_TRUNCATION for the date, datetime, time, and timestamp data types filters the following warning messages:

  • ER_LH_WARN_TRUNCATED

• Mode: PARQUET_SCHEMA filters the following warning messages:

  • ER_LH_PARQUET_CANNOT_LOCATE_SCHEMA

  • ER_LH_PARQUET_SCHEMA_MISMATCH