> 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/7533062f17912424e1f859c5becaf3bf36bff7ac and https://github.com/MariaDB/server/commit/699cfee595b917ab05a99426bc6e9adbaa342e71). > 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 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. _______________________________________________ developers mailing list -- developers@lists.mariadb.org To unsubscribe send an email to developers-le...@lists.mariadb.org
