[MDEV-32632] Add more fields to the SQL Error plugin Created: 2023-10-31 Updated: 2023-11-15 Resolved: 2023-11-15 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Server |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Major |
| Reporter: | Nilnandan Joshi | Assignee: | Michael Widenius |
| Resolution: | Duplicate | Votes: | 1 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||||||
| Description |
|
The current fields provided by the sql_error plugin are, in 10.11: Time User Type Error_code: Error_message : Query The 'User' includes the IP when connecting through TCP/IP The request is to add Thread_id directly after Time, similar to what we do in the error log. When doing this task, it would be good to also enhance perror to print the text for all MariaDB server error messages (at least the English ones) shell> perror 1000 This will be helpful as in the near future we will add a link to the perror output to a KB article that explains the reason for the error in more detail. As part of this task, we should also do MDEV-10295 Create a status counter for SQL_ERROR_LOG plugin as this is a trivial thing to do at the same time. |
| Comments |
| Comment by Oleksandr Byelkin [ 2023-11-15 ] |
|
niljoshi Are you sure that adding new field in the log will not create incompatibilities for existing clients/users? |
| Comment by Oleksandr Byelkin [ 2023-11-15 ] |
|
niljoshi why you need list of all errors of the server (what for?) (BTW this task doe not looks connected to the plugin at all so should be separated) |