[MDEV-23401] main.backup_stages failed in buildbot with Failed to write to mysql.slow_log: Error writing file 'UNKNOWN' Created: 2020-08-04  Updated: 2023-11-17

Status: Stalled
Project: MariaDB Server
Component/s: Server, Tests
Affects Version/s: 10.4
Fix Version/s: 10.4

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-focal-ppc64le/builds/127/steps/mtr/logs/stdio

10.4 a4996f951d73

 
main.backup_stages 'innodb'              w4 [ fail ]  Found warnings/errors in server log file!
 
        Test ended at 2020-05-15 22:30:14
 
line
 
2020-05-15 22:30:14 36 [ERROR] Failed to write to mysql.slow_log: Error writing file 'UNKNOWN' (Errcode: 9 "Bad file descriptor")
 
^ Found warnings in /dev/shm/var/4/log/mysqld.1.err
 
ok



 Comments   
Comment by Daniel Black [ 2022-07-18 ]

win32 @ 10.5-a1974d1991f808146c11ca0ada3724e8bafd5fb8, also 2020-12-18 and test of the same form of failure since as of today.

The more recent occasional error not observed in <10.6 is:

10.6-dafc5fb9c17637c6233e8a73c890f158d645a37c (2022-03-15)

 
CURRENT_TEST: main.backup_stages
 
--- /buildbot/amd64-ubuntu-1804-debug/build/mysql-test/main/backup_stages.result	2022-03-15 03:00:27.000000000 +0000
 
+++ /buildbot/amd64-ubuntu-1804-debug/build/mysql-test/main/backup_stages.reject	2022-03-15 03:47:29.197834923 +0000
 
@@ -23,6 +23,7 @@
 
 SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA, TABLE_NAME FROM information_schema.metadata_lock_info;
 
 LOCK_MODE	LOCK_TYPE	TABLE_SCHEMA	TABLE_NAME
 
 MDL_BACKUP_START	Backup lock		
+MDL_SHARED	Table metadata lock	mysql	innodb_table_stats
 
 connect con2,localhost,root,,;
 
 # The connection con2 cannot continue the work of con1 by setting the
 
 # next BACKUP STAGE FLUSH.
 
 
 
mysqltest: Result length mismatch
 
 
 
 - saving '/buildbot/amd64-ubuntu-1804-debug/build/mysql-test/var/13/log/main.backup_stages-innodb/' to '/buildbot/amd64-ubuntu-1804-debug/build/mysql-test/var/log/main.backup_stages-innodb/'

Also shows up in other information_schema.metadata_lock_info tests:

Comment by Marko Mäkelä [ 2023-11-17 ]

thiru, please file separate tickets for the MDEV-16678 (10.5+) and MDEV-4750 (10.6+) related test failures and note them here.

I think that what needs to be fixed in this ticket is the EBADF that is reported for writing to the slow query log. That has nothing to do with InnoDB.

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