Public bug reported: Running gourmand with a --database-url pointing to my postgres database fails immediately with the following backtrace. It is generating SQL that may be valid for sqlite but is not valid for postgresql.
ProblemType: Crash DistroRelease: Ubuntu 24.04 Package: gourmand 1.1.0+really1.1.0~rc3-3 ProcVersionSignature: Ubuntu 6.8.0-31.31-generic 6.8.1 Uname: Linux 6.8.0-31-generic x86_64 NonfreeKernelModules: zfs ApportVersion: 2.28.1-0ubuntu3 Architecture: amd64 CasperMD5CheckResult: unknown CurrentDesktop: ubuntu:GNOME Date: Fri May 24 08:48:52 2024 ExecutablePath: /usr/bin/gourmand InstallationDate: Installed on 2019-12-23 (1614 days ago) InstallationMedia: Ubuntu 19.10 "Eoan Ermine" - Release amd64 (20191017) InterpreterPath: /usr/bin/python3.12 JournalErrors: May 24 08:48:55 hostname NetworkManager[2893]: <warn> [1716565735.9215] device (veth01294ac0): Activation: failed for connection 'Auto Ethernet' PackageArchitecture: all ProcCmdline: /usr/bin/python3 /usr/bin/gourmand --database-url=postgresql://borges/recipes Python3Details: /usr/bin/python3.12, Python 3.12.3, python3-minimal, 3.12.3-0ubuntu1 PythonArgs: ['/usr/bin/gourmand', '--database-url=postgresql://borges/recipes'] PythonDetails: N/A SourcePackage: gourmand Title: gourmand crashed with (Background on this error at in do_execute(): https://sqlalche.me/e/14/f405) UpgradeStatus: Upgraded to noble on 2024-05-22 (2 days ago) UserGroups: adm cdrom dip libvirt lpadmin lxd plugdev sambashare sbuild src sudo modified.conffile..etc.apport.crashdb.conf: [modified] mtime.conffile..etc.apport.crashdb.conf: 2024-05-23T16:12:43.275502 ** Affects: gourmand (Ubuntu) Importance: Medium Status: New ** Tags: amd64 apport-crash noble third-party-packages ** Information type changed from Private to Public -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/2067088 Title: gourmand generates SQL that is invalid for postgresql gourmand crashed with (Background on this error at in do_execute(): https://sqlalche.me/e/14/f405) To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/gourmand/+bug/2067088/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs