Bug 1808328
| Summary: | PyGreSQL fails to build with postgresql 12: pg.ProgrammingError: ERROR: syntax error at or near "oids" | ||
|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | Miro Hrončok <mhroncok> |
| Component: | PyGreSQL | Assignee: | Honza Horak <hhorak> |
| Status: | CLOSED ERRATA | QA Contact: | Fedora Extras Quality Assurance <extras-qa> |
| Severity: | unspecified | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | rawhide | CC: | cstratak, hhorak, jmlich83, mhroncok, mplch, odubaj, panovotn, pkajaba, pkubat, praiskup, tgl |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | PyGreSQL-5.1.1-1.fc32 | Doc Type: | If docs needed, set a value |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2020-03-16 20:36:28 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: | |||
| Bug Blocks: | 1750908, 1785415, 1801396, 1803234 | ||
> pg.ProgrammingError: ERROR: syntax error at or near "oids"
> LINE 1: ...te temporary table "arraytest" (i int[], t text[]) with oids
> ^
FYI, that's a Postgres issue not a Python issue. Postgres dropped support for "WITH OIDS" in v12,
so this test case will need to be rewritten. I have not looked at the test, but it seems unlikely
that it requires that feature in any fundamental way.
That's what I've thought. Dear Maintainer, your package has not been built successfully in 32. Action is required from you. If you can fix your package to build, perform a build in koji, and either create an update in bodhi, or close this bug without creating an update, if updating is not appropriate [1]. If you are working on a fix, set the status to ASSIGNED to acknowledge this. Following the latest policy for such packages [2], your package will be orphaned if this bug remains in NEW state more than 8 weeks. A week before the mass branching of Fedora 33 according to the schedule [3], any packages not successfully rebuilt at least on Fedora 31 will be retired regardless of the status of this bug. [1] https://fedoraproject.org/wiki/Updates_Policy [2] https://docs.fedoraproject.org/en-US/fesco/Fails_to_build_from_source_Fails_to_install/ [3] https://fedoraproject.org/wiki/Releases/33/Schedule Dear Maintainer, your package has an open Fails To Build From Source bug for Fedora 32. Action is required from you. If you can fix your package to build, perform a build in koji, and either create an update in bodhi, or close this bug without creating an update, if updating is not appropriate [1]. If you are working on a fix, set the status to ASSIGNED to acknowledge this. If you have already fixed this issue, please close this Bugzilla report. Following the policy for such packages [2], your package will be orphaned if this bug remains in NEW state more than 8 weeks (that's on 2020-04-24). A week before the mass branching of Fedora 33 according to the schedule [3], any packages not successfully rebuilt at least on Fedora 31 will be retired regardless of the status of this bug. [1] https://fedoraproject.org/wiki/Updates_Policy [2] https://docs.fedoraproject.org/en-US/fesco/Fails_to_build_from_source_Fails_to_install/ [3] https://fedorapeople.org/groups/schedule/f-33/f-33-key-tasks.html There is a new version 5.1.1 that seems to fixing this. Will take a look at rebasing. FEDORA-2020-dcd2ae748b has been submitted as an update to Fedora 32. https://bodhi.fedoraproject.org/updates/FEDORA-2020-dcd2ae748b PyGreSQL-5.1.1-1.fc32 has been pushed to the Fedora 32 testing repository. If problems still persist, please make note of it in this bug report. See https://fedoraproject.org/wiki/QA:Updates_Testing for instructions on how to install test updates. You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2020-dcd2ae748b PyGreSQL-5.1.1-1.fc32 has been pushed to the Fedora 32 stable repository. If problems still persist, please make note of it in this bug report. |
PyGreSQL fails to build with Python 3.9.0a4. ====================================================================== ERROR: testQuery (tests.test_classic_connection.TestSimpleQueries) ---------------------------------------------------------------------- Traceback (most recent call last): File "/builddir/build/BUILD/PyGreSQL-5.1/tests/test_classic_connection.py", line 620, in testQuery r = query(q) pg.ProgrammingError: ERROR: syntax error at or near "oids" LINE 1: create table test_table (n integer) with oids ^ ====================================================================== ERROR: testQuery (tests.test_classic_connection.TestSimpleQueries) ---------------------------------------------------------------------- pg.ProgrammingError: ERROR: table "test_table" does not exist ====================================================================== ERROR: testArrayLiteral (tests.test_classic_dbwrapper.TestDBClass) ---------------------------------------------------------------------- Traceback (most recent call last): File "/builddir/build/BUILD/PyGreSQL-5.1/tests/test_classic_dbwrapper.py", line 3411, in testArrayLiteral self.createTable('arraytest', 'i int[], t text[]', oids=True) File "/builddir/build/BUILD/PyGreSQL-5.1/tests/test_classic_dbwrapper.py", line 509, in createTable query(q) File "/builddir/build/BUILD/PyGreSQL-5.1/pg.py", line 1903, in query return self.db.query(command) pg.ProgrammingError: ERROR: syntax error at or near "oids" LINE 1: ...te temporary table "arraytest" (i int[], t text[]) with oids ^ ... I don't know if this is Python 3.9 related, might be postgres related instead. I've enabled tracking in https://koschei.fedoraproject.org/package/PyGreSQL?collection=f33 For the build logs, see: https://copr-be.cloud.fedoraproject.org/results/@python/python3.9/fedora-rawhide-x86_64/01255538-PyGreSQL/ For all our attempts to build PyGreSQL with Python 3.9, see: https://copr.fedorainfracloud.org/coprs/g/python/python3.9/package/PyGreSQL/ Testing and mass rebuild of packages is happening in copr. You can follow these instructions to test locally in mock if your package builds with Python 3.9: https://copr.fedorainfracloud.org/coprs/g/python/python3.9/ Let us know here if you have any questions. Python 3.9 will be included in Fedora 33. To make that update smoother, we're building Fedora packages with early pre-releases of Python 3.9. A build failure prevents us from testing all dependent packages (transitive [Build]Requires), so if this package is required a lot, it's important for us to get it fixed soon. We'd appreciate help from the people who know this package best, but if you don't want to work on this now, let us know so we can try to work around it on our side.