koji

#3594 schema update issue for 1.30->1.31 update
Closed: Fixed by tkopecek. Opened by arrfab.

Closed: Fixed
Reopen Issue

When trying to update schema, with the provided /usr/share/doc/koji/docs/schema-update-1.30-1.31.sql file : 

psql koji < /usr/share/doc/koji/docs/schema-update-1.30-1.31.sql
BEGIN
ERROR:  syntax error at or near "INCLUDE"
LINE 1: ...sion || '-' || release || '.' || arch || '.rpm')) INCLUDE (i...
                                                             ^
ROLLBACK

FWIW, it's on a RHEL 8 machine, running postgresql-server-10.19-1.module_el8.6.0+1047+4202cf9a.x86_64

(copied from #3595 duplicate) Update https://docs.pagure.org/koji/supported_platforms/ with minimum postgres version. Last sql update used CREATE INDEX INCLUDE option which is present there from PG11, so older dbs can't be updated. We should be aware of such problems.

Metadata Update from @tkopecek:
- Custom field Size adjusted to None

Metadata Update from @tkopecek:
- Issue set to the milestone: 1.31.1

Just FYI - it is safe to drop INCLUDE part as a workaround.

PR #3615

Metadata Update from @tkopecek:
- Issue tagged with: testing-ready

Metadata Update from @mfilip:
- Issue tagged with: testing-done

Commit 369d9292 fixes this issue

Commit c1105699 relates to this ticket

This issue has been migrated to Fedora Forge:
https://forge.fedoraproject.org/koji/koji/issues/3594

Please continue any further discussion there.
Metadata
None

testing-done testing-ready

None
None
Low
None
Related Pull Requests
Static archive. pagure.io was sunset in 2026; this is a read-only snapshot.
Red Hat Logo

Fedora is sponsored by Red Hat. Learn more about the relationship between Red Hat and Fedora »

© Red Hat, Inc. and others.