[MDEV-27129] SQL Error Log plug-in lacks Connection ID Created: 2021-11-26  Updated: 2023-11-02  Resolved: 2023-11-01

Status: Closed
Project: MariaDB Server
Component/s: Plugin - SQL_ERROR_LOG
Fix Version/s: N/A

Type: Task Priority: Minor
Reporter: Oli Sennhauser Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-27087 Add thread ID and database / table, w... Closed
is duplicated by MDEV-32632 Add more fields to the SQL Error plugin Closed

 Description   

SQL Error Log plug-in lacks Connection ID.

All other MariaDB logs contain the Connection ID (sometimes also called thread_id) except the SQL Error Log plug-in. To track errors via the Connection ID it would be great having it as well there.

 Comments   
Comment by Oli Sennhauser [ 2021-11-26 ]

Probably this would do the job:
96 logger_printf(logfile, "%04d-%02d-%02d %2d:%02d:%02d "

  • "%d "*
    97 "%s ERROR %d: %s : %s\n",
    98 t.tm_year + 1900, t.tm_mon + 1,
    99 t.tm_mday, t.tm_hour, t.tm_min, t.tm_sec,
    event->general_thread_id,
    100 event->general_user, event->general_error_code,
    101 event->general_command, event->general_query);
Comment by Michael Widenius [ 2023-11-01 ]

Duplicate of MDEV-32632, which will be implemented shortly in 11.4

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