[MDEV-21717] buildbot.mariadb.org pc9-ubuntu-1804 permanent failure on csv.read_only main.flush_logs_not_windows Created: 2020-02-12  Updated: 2020-02-17  Resolved: 2020-02-17

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Otto Kekäläinen Assignee: Robert Bindar
Resolution: Fixed Votes: 0
Labels: None

Attachments: PNG File image-2020-02-12-17-53-49-637.png    

 Description   

I noticed that the buildbot.mariadb.org builder pc9-ubuntu-1804 is permanently failing at https://buildbot.mariadb.org/#/builders:

Failure is due to 2 test suite failures:

main.flush_logs_not_windows              w3 [ fail ]
        Test ended at 2020-02-12 14:59:47
 
CURRENT_TEST: main.flush_logs_not_windows
mysqltest: At line 10: query 'flush logs' succeeded - should have failed with errno 1004...
 
The result from queries just before the failure was:
flush logs;
 
 - skipping '/buildbot/pc9-ubuntu-1804/build/mysql-test/var/3/log/main.flush_logs_not_windows/'
 
 
csv.read_only                            w5 [ fail ]
        Test ended at 2020-02-12 14:59:13
 
CURRENT_TEST: csv.read_only
--- /buildbot/pc9-ubuntu-1804/build/mysql-test/suite/csv/read_only.result	2020-02-12 14:51:38.000000000 +0000
+++ /buildbot/pc9-ubuntu-1804/build/mysql-test/suite/csv/read_only.reject	2020-02-12 14:59:13.527963405 +0000
@@ -6,27 +6,23 @@
 TABLE_SCHEMA	test
 TABLE_NAME	t1
 TABLE_TYPE	BASE TABLE
-ENGINE	NULL
-VERSION	NULL
-ROW_FORMAT	NULL
-TABLE_ROWS	NULL
-AVG_ROW_LENGTH	NULL
-DATA_LENGTH	NULL
-MAX_DATA_LENGTH	NULL
-INDEX_LENGTH	NULL
-DATA_FREE	NULL
+ENGINE	CSV
+VERSION	10
+ROW_FORMAT	Fixed
+TABLE_ROWS	2
+AVG_ROW_LENGTH	0
+DATA_LENGTH	0
+MAX_DATA_LENGTH	0
+INDEX_LENGTH	0
+DATA_FREE	0
 AUTO_INCREMENT	NULL
 CREATE_TIME	NULL
 UPDATE_TIME	NULL
 CHECK_TIME	NULL
-TABLE_COLLATION	NULL
+TABLE_COLLATION	latin1_swedish_ci
 CHECKSUM	NULL
-CREATE_OPTIONS	NULL
-TABLE_COMMENT	File './test/t1.CSM' not found (Errcode: 13 "Permission denied")
-MAX_INDEX_LENGTH	NULL
-TEMPORARY	NULL
-Warnings:
-Level	Warning
-Code	29
-Message	File './test/t1.CSM' not found (Errcode: 13 "Permission denied")
+CREATE_OPTIONS	
+TABLE_COMMENT	
+MAX_INDEX_LENGTH	0
+TEMPORARY	N
 drop table t1;
 
mysqltest: Result length mismatch
 
 - saving '/buildbot/pc9-ubuntu-1804/build/mysql-test/var/5/log/csv.read_only/' to '/buildbot/pc9-ubuntu-1804/build/mysql-test/var/log/csv.read_only/'

These should be fixed or disabled from the tests.

Currently e.g. my https://github.com/MariaDB/server/pull/1444 cannot be accepted due to this unrelated test failure.



 Comments   
Comment by Robert Bindar [ 2020-02-17 ]

Hi otto, the problem with these two tests is that they are being run by a root user (and tests depend on some file privileges). I managed to make them green on the pc9 machine by running mtr from a non-privileged user. They should both turn green in upstream buildbot.mariadb.org once Vlad pushes the fix there.

Comment by Robert Bindar [ 2020-02-17 ]

Closing this as pc9 on buildbot.mariadb.org seems to be green now. Many thanks for keeping an eye on it

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