Bug 26042

Summary: Koha/ItemTypes.t and Koha/Patrons.t are failing with latest MariaDB
Product: Koha Reporter: Jonathan Druart <jonathan.druart>
Component: Test SuiteAssignee: Chris Cormack <chris>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: julian.maurice, martin.renvoize, tomascohen, victor
Version: unspecified   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26056
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on:    
Bug Blocks: 25551    

Description Jonathan Druart 2020-07-22 10:41:36 UTC
Failing on Master_D9_MDB_Latest
https://jenkins.koha-community.org/job/Koha_Master_D9_MDB_Latest/346/consoleFull

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
Comment 1 Jonathan Druart 2020-07-24 10:08:10 UTC
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.
Comment 2 Victor Grousset/tuxayo 2020-07-27 18:47:09 UTC
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.
Comment 3 Jonathan Druart 2020-08-13 07:02:31 UTC
("Auto")Fixed since today, version is now 10.5.5-MariaDB-1:10.5.5+maria~focal