Bug 1225994

Summary: [Build 20240605-2] gnuhealth starts failed with "trytond" package version=6.0.46
Product: [openSUSE] openSUSE Distribution Reporter: Richard Fan <richard.fan>
Component: OtherAssignee: Axel Braun <axel.braun>
Status: IN_PROGRESS --- QA Contact: E-mail List <qa-bugs>
Severity: Normal    
Priority: P5 - None CC: jpupava, santiago.zarate
Version: Leap 15.5   
Target Milestone: ---   
Hardware: x86-64   
OS: Other   
URL: https://openqa.opensuse.org/tests/4249991/modules/gnuhealth_setup/steps/14
Whiteboard:
Found By: openQA Services Priority:
Business Priority: Blocker: Yes
Marketing QA Status: --- IT Deployment: ---
Attachments: screen shot

Description Richard Fan 2024-06-05 10:10:21 UTC 
Created attachment 875322 [details]
screen shot

## Description

With "trytond" package version= "6.0.46", I can see below error messages in gnuhealth tests, please see attached file.

I did some investigation and try to downgrade the package version to "6.0.38", the issue is gone.

see openqa result. can you please help confirm? please let me know if you need to access my setup to debug.

## Observation

openQA test in scenario opensuse-15.5-DVD-Updates-x86_64-gnuhealth@64bit fails in
[gnuhealth_setup](https://openqa.opensuse.org/tests/4249991/modules/gnuhealth_setup/steps/14)

## Test suite description
Maintainer: community packages
Test scenario for gnuhealth software stack.

* 2020-11-17: Temporarily added `QEMUCPU=host` needed to prevent openCV crashes within the SUT, see [boo#1178453](https://bugzilla.opensuse.org/show_bug.cgi?id=1178453) but I removed it again to not hide the product issue.
* 2021-03-12: Added `QEMUCPU=host` again as there was no better solution found so far.


## Reproducible

Fails since (at least) Build [20240520-3](https://openqa.opensuse.org/tests/4208876)


## Expected result

Last good: [20240520-2](https://openqa.opensuse.org/tests/4208599) (or more recent)


## Further details

Always latest result in this scenario: [latest](https://openqa.opensuse.org/tests/latest?arch=x86_64&distri=opensuse&flavor=DVD-Updates&machine=64bit&test=gnuhealth&version=15.5)
Comment 1 Richard Fan 2024-06-05 10:11:41 UTC 
Here comes the test with older trytond package.

https://openqa.opensuse.org/tests/4250364#
Comment 2 Axel Braun 2024-06-11 19:02:24 UTC 
I can confirm that his happens as well on an installation on a clean 15.5 system. Looks like a regression from upstream.
Do you know which was the last working trytond version?
Comment 3 Richard Fan 2024-06-12 01:23:16 UTC 
(In reply to Axel Braun from comment #2)
> I can confirm that his happens as well on an installation on a clean 15.5
> system. Looks like a regression from upstream.
> Do you know which was the last working trytond version?

The version I tested was `zypper_call "install --oldpackage trytond=6.0.38-bp155.2.15.1";`
Comment 4 Axel Braun 2024-06-12 14:12:25 UTC 
The issue is coming from a recent change that requires a newer python-sql.
I have created mr #1180234 for this. It builds against 15.5 in my repo
Comment 5 Axel Braun 2024-06-12 14:22:40 UTC 
Hang on, I just seen it creates a python 311-python-sql...thats not what we want!
Comment 6 Axel Braun 2024-06-12 16:23:20 UTC 
mr 1180252
Comment 7 OBSbugzilla Bot 2024-06-12 16:55:03 UTC 
This is an autogenerated message for OBS integration:
This bug (1225994) was mentioned in
https://build.opensuse.org/request/show/1180252 Backports:SLE-15-SP5 / python-python-sql
Comment 8 OBSbugzilla Bot 2024-06-14 10:35:01 UTC 
This is an autogenerated message for OBS integration:
This bug (1225994) was mentioned in
https://build.opensuse.org/request/show/1180857 Backports:SLE-15-SP6 / python-python-sql
Comment 9 Richard Fan 2024-07-02 07:27:43 UTC 
The issue is gone now, thanks much! please feel free to close this bug once everything is fine