[MDEV-20281] "[ERROR] Failed to write to mysql.slow_log:" without error reason Created: 2019-08-07  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.3.17, 10.4.7, 10.4.12, 10.6.9, 10.7.4
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Hartmut Holzgraefe Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 1
Labels: None

Issue Links:
Relates
relates to MDEV-24339 "[ERROR] Failed to write to mysql.slo... Closed

 Description   

There's at least one code path, maybe more, in Log_to_csv_event_handler::log_slow() that logs an error, but does not print an actuall error message so that the cause / reason of the error is unclear.

  /* check that all columns exist */
 
  if (table->s->fields < 13)
 
    goto err;



 Comments   
Comment by Oleksandr Byelkin [ 2019-10-11 ]

table->s->fields < 13 check (if it is users table) mean old system files earlier then 3.23 or the same (do not remember on the top of my head)

Comment by Hartmut Holzgraefe [ 2019-10-11 ]

sanja

This is current code still found in the 10.4 branch:

https://github.com/MariaDB/server/blob/10.4/sql/log.cc#L907

Comment by Mitchell Lee [ 2022-08-02 ]

Still here.
on 10.7.4.
It rarely occurred.
And I set the config for slowlog to Table type
on Windows 11.

Comment by Mitchell Lee [ 2022-11-17 ]

Update,
I havent seen the error with 10.7.6 for a while.
and
The 10.7.7 not yet occured within a week so far.

Generated at Thu Feb 08 08:58:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.