[Bug 26042] New: Koha/ItemTypes.t is failing with latest MariaDB
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26042 Bug ID: 26042 Summary: Koha/ItemTypes.t is failing with latest MariaDB Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Test Suite Assignee: chris@bigballofwax.co.nz Reporter: jonathan.druart@bugs.koha-community.org QA Contact: testopia@bugs.koha-community.org Failing on Master_D9_MDB_Latest https://jenkins.koha-community.org/job/Koha_Master_D9_MDB_Latest/346/console... But I recreate on D10 locally. The test is failing with: # Failed test 'item types should be sorted by translated description' # at t/db_dependent/Koha/ItemTypes.t line 137. # got: 'b translated itemtype desc' # expected: 'a translated itemtype desc' # Looks like you failed 1 test of 24. The generated query is (without the full field list): SELECT `me`.`itemtype`, COALESCE( `localization`.`translation`, `me`.`description` ) AS `translated_description` FROM `itemtypes` `me` LEFT JOIN (SELECT localization_id, code, lang, translation FROM localization WHERE entity='itemtypes') `localization` ON ( `localization`.`lang` = 'en' AND `me`.`itemtype` = `localization`.`code` ) ORDER BY `translated_description`; I have removed the transaction and run the query in the MariaDB CLI: *************************** 1. row *************************** itemtype: type1 translated_description: b translated itemtype desc *************************** 2. row *************************** itemtype: type2 translated_description: a translated itemtype desc *************************** 3. row *************************** itemtype: type3 translated_description: description *************************** 4. row *************************** itemtype: woR9bd5 translated_description: nlHDyp MariaDB version is: 10.5.4-MariaDB-1:10.5.4+maria~focal -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26042 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |julian.maurice@biblibre.com | |, | |martin.renvoize@ptfs-europe | |.com, tomascohen@gmail.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26042 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |25551 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25551 [Bug 25551] [OMNIBUS] Some tests are failing randomly -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26042 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=26056 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26042 --- Comment #1 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Note that Patrons.t is also failing # Failed test 'Return first guarantor alphabetically' # at t/db_dependent/Koha/Patrons.t line 233. # got: '2000000361' # expected: '2000000365' # Failed test 'Return second guarantor alphabetically' # at t/db_dependent/Koha/Patrons.t line 234. # got: '2000000362' # expected: '2000000364' # Failed test 'Return third guarantor alphabetically' # at t/db_dependent/Koha/Patrons.t line 235. # got: '2000000365' # expected: '2000000363' # Failed test 'Return fourth guarantor alphabetically' # at t/db_dependent/Koha/Patrons.t line 236. # got: '2000000364' # expected: '2000000362' # Failed test 'Return fifth guarantor alphabetically' # at t/db_dependent/Koha/Patrons.t line 237. # got: '2000000363' # expected: '2000000361' # Looks like you failed 5 tests of 13. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26042 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Koha/ItemTypes.t is failing |Koha/ItemTypes.t and |with latest MariaDB |Koha/Patrons.t are failing | |with latest MariaDB -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26042 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|major |normal -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26042 Victor Grousset/tuxayo <victor@tuxayo.net> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |victor@tuxayo.net --- Comment #2 from Victor Grousset/tuxayo <victor@tuxayo.net> --- It doesn't look random since all builds of Koha_Master_D9_MDB_Latest failed since the upgrade 10.4=>10.5. Should it be linked to an omnibus for MariaDB 10.5 support? (I can do it) If I'm not mistaken there is at least one other MariaDB 10.5 known bug. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26042 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #3 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- ("Auto")Fixed since today, version is now 10.5.5-MariaDB-1:10.5.5+maria~focal -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org