Bug 1973455

Summary: Unbundle sqlite and use system version
Product: [Fedora] Fedora Reporter: Ian McInerney <ian.s.mcinerney>
Component: audacityAssignee: Ian McInerney <ian.s.mcinerney>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 36CC: domfe, dtimms, gemi, gwync, ian.s.mcinerney, manpaz, moez.roy, ngompa13
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: audacity-3.1.3-1.fc35 audacity-3.1.3-1.fc36 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2022-04-17 22:42:42 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 1973454    
Bug Blocks:    

Description Ian McInerney 2021-06-17 21:10:12 UTC
Audacity version 3.0 includes a new dependency on sqlite for the new project format. They require that the sqlite library be built with the SQLITE_ENABLE_DBPAGE_VTAB feature, which Fedora's currently doesn't possess (when trying a test build using Fedora's version, I get the same error as https://github.com/flathub/org.audacityteam.Audacity/issues/62).

I have requested that sqlite in Fedora be built with that feature in https://bugzilla.redhat.com/show_bug.cgi?id=1973454.

Comment 1 Ben Cotton 2021-08-10 13:08:14 UTC
This bug appears to have been reported against 'rawhide' during the Fedora 35 development cycle.
Changing version to 35.

Comment 2 Ian McInerney 2021-08-15 20:40:15 UTC
Note, Audacity also uses a non-standard SQLite page size for improved reading/writing performance of the files. Upstream currently provides that as a compile-time constant in SQLite, but they have said they will work on moving it into a dynamic setting (https://github.com/audacity/audacity/issues/1459). That also needs to be done before SQLite can be unbundled.

Comment 3 Ian McInerney 2021-08-19 14:07:37 UTC
The dbpage table has been enabled in rawhide now, so the only remaining task is upstream Audacity switching to run-time page size changing instead of their current sqlite compile-time version. It looks to be part of their 3.1 milestone, but I am not sure what their timeline for releasing 3.1 is.

Comment 4 Neal Gompa 2021-08-20 01:55:19 UTC
It looks like Tenacity (the Audacity fork) has done significant work to switch to system dependencies on Linux: https://github.com/tenacityteam/tenacity/issues/90#issuecomment-901585714

Comment 5 Ben Cotton 2022-02-08 21:44:25 UTC
This bug appears to have been reported against 'rawhide' during the Fedora 36 development cycle.
Changing version to 36.

Comment 6 Fedora Update System 2022-04-10 01:46:24 UTC
FEDORA-2022-d435c74328 has been submitted as an update to Fedora 35. https://bodhi.fedoraproject.org/updates/FEDORA-2022-d435c74328

Comment 7 Fedora Update System 2022-04-10 02:04:16 UTC
FEDORA-2022-857f49ff15 has been submitted as an update to Fedora 36. https://bodhi.fedoraproject.org/updates/FEDORA-2022-857f49ff15

Comment 8 Fedora Update System 2022-04-10 16:33:25 UTC
FEDORA-2022-857f49ff15 has been pushed to the Fedora 36 testing repository.
Soon you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2022-857f49ff15`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2022-857f49ff15

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 9 Fedora Update System 2022-04-10 20:07:15 UTC
FEDORA-2022-d435c74328 has been pushed to the Fedora 35 testing repository.
Soon you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2022-d435c74328`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2022-d435c74328

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 10 Fedora Update System 2022-04-17 22:42:42 UTC
FEDORA-2022-d435c74328 has been pushed to the Fedora 35 stable repository.
If problem still persists, please make note of it in this bug report.

Comment 11 Fedora Update System 2022-05-07 04:21:13 UTC
FEDORA-2022-857f49ff15 has been pushed to the Fedora 36 stable repository.
If problem still persists, please make note of it in this bug report.