On Thu, Nov 30, 2023 at 5:29 PM Otto Kekäläinen <o...@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/7533062f17912424e1f859c5becaf3bf36bff7ac > and > https://github.com/MariaDB/server/commit/699cfee595b917ab05a99426bc6e9adbaa342e71).
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# _______________________________________________ developers mailing list -- developers@lists.mariadb.org To unsubscribe send an email to developers-le...@lists.mariadb.org
