[#MDEV-20747] Add command to log any string to error log e.g.: LOG

[MDEV-20747] Add command to log any string to error log e.g.: LOG_ERROR(' Start ALTER TABLE'); Created: 2019-10-04 Updated: 2019-10-09
Status:	Open
Project:	MariaDB Server
Component/s:	None
Fix Version/s:	None

Type:

Task

Priority:

Major

Reporter:

Claudio Nanni

Assignee:

Unassigned

Resolution:

Unresolved

Votes:

Labels:

None

Description

I think it would be very welcome a function to have the server log an arbitrary (length limited) message in the error log.
Useful for debugging from SPs, checking log rotation, checking if connected to the proper instance, etc

It could be:

LOG_ERROR(<any string>);

SELECT COUNT(*) FROM t1 INTO @total_count;

LOG_ERROR(@total_count);

Timestamp generated by the server and category not sure, maybe 'user' ?

2019-10-04  9:45:03 139884892247808 [User] 23456

Currently to achieve something similar is a real pain of workarounds.

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

[MDEV-20747] Add command to log any string to error log e.g.: LOG_ERROR(' Start ALTER TABLE'); Created: 2019-10-04 Updated: 2019-10-09