On Thu, Nov 30, 2023 at 5:29 PM Otto Kekäläinen <otto@kekalainen.net> wrote:
armhf/powerpc/sparc
So the problem is more than slow query in the table mysq.slow_log. Patches welcome.
CURRENT_TEST: main.subselect /<<PKGBUILDDIR>>/builddir/client//mariadb-test: Error on delete of '/<<PKGBUILDDIR>>/builddir/mysql-test/var/1/tmp/subselect.out.file.1' (Errcode: 2 "No such file or directory") mysqltest: At line 6003: query 'Select (Select Sum(`TestCase`.Revenue) From mysql.slow_log E Where TestCase.TemplateID not in (Select 1 from mysql.slow_log where 2=2) ) As `ControlRev` From (Select 3 as Revenue, 4 as TemplateID) As `TestCase` Group By TestCase.Revenue, TestCase.TemplateID' failed: ER_SUBQUERY_NO_1_ROW (1242): Subquery returns more than 1 row
Indeed, these archs show regression in the various subselect tests. I will dig more into this one.
Potentially related: https://jira.mariadb.org/browse/MDEV-32514 / https://jira.mariadb.org/browse/MDEV-32518 (which was on 10.11.6 as https://github.com/MariaDB/server/commit/7533062f17912424e1f859c5becaf3bf36b... and https://github.com/MariaDB/server/commit/699cfee595b917ab05a99426bc6e9adbaa3...).
possibly fixed, yes it was a good one to raise. https://github.com/MariaDB/server/pull/2883 MDEV-32843) main.subselect, main.subselect_no_exists_to_in often fails on CI with ER_SUBQUERY_NO_1_ROW
sh4
dependency problem
Comparing latest build log to the previous that passed in 10.11.5-3 I see this line is now present that is different:
CMake Error: Generator: execution of make failed. Make command was: /usr/bin/cmake -E env VERBOSE=1 /usr/bin/gmake -f Makefile cmTC_cc6d8/fast -- Looking for sigset - not found
sounds like an environmental problem.
https://buildd.debian.org/status/fetch.php?pkg=mariadb&arch=sh4&ver=1%3A10.11.5-3&stamp=1697366222&raw=0 vs https://buildd.debian.org/status/fetch.php?pkg=mariadb&arch=sh4&ver=1%3A10.11.6-1&stamp=1701153270&raw=0
sparc
something threadpool related. Need arch advice.
In https://buildd.debian.org/status/fetch.php?pkg=mariadb&arch=sparc64&ver=1%3A10.11.6-1&stamp=1701155365&raw=0 we see errors like:
main.index_merge_innodb 'innodb' w16 [ retry-fail ] Found warnings/errors in server log file! Test ended at 2023-11-28 07:04:20 line Warning : threadpool thread could not be created :Bad address,current number of threads in pool 5
I suspect it is most likely related to https://jira.mariadb.org/browse/MDEV-30728 as that same test has been failing on multiple architectures randomly for a long time.
It hasn't failed on non-ppc64le for quite a while https://buildbot.mariadb.org/cr/?branch=10.6&revision=&platform=&dt=&bbnum=&typ=&info=&test_name=main.index_merge_innodb&test_variant=&info_text=&failure_text=&limit=100#