autopkgtest fails with new postgresql-{10,12} on Bionic/Focal

Bug #1986714 reported by Sergio Durigan Junior
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
pgq (Ubuntu)
Invalid
Undecided
Unassigned
Bionic
Fix Released
High
Sergio Durigan Junior
Focal
Fix Released
High
Sergio Durigan Junior
pgq-node (Ubuntu)
Invalid
Undecided
Unassigned
Bionic
Fix Released
High
Sergio Durigan Junior
Focal
Fix Released
High
Sergio Durigan Junior

Bug Description

pgq's and pgq-node's autopkgtests are failing with the (upcoming) new release of postgresql-10 on Bionic (10.22-0ubuntu0.18.04.1) and postgresql-12 on Focal (12.12-0ubuntu0.20.04.1):

=======================
 5 of 33 tests failed.
=======================

The differences that caused some tests to fail can be viewed in the
file "/tmp/autopkgtest.CyfS6k/build.Owj/src/regression.diffs". A copy of the test summary that you see
above is saved in the file "/tmp/autopkgtest.CyfS6k/build.Owj/src/regression.out".

make: *** [installcheck] Error 1
/usr/lib/postgresql/10/lib/pgxs/src/makefiles/pgxs.mk:284: recipe for target 'installcheck' failed
*** /tmp/pg_virtualenv.aq4N9f/log/postgresql-10-regress.log (last 100 lines) ***
2022-08-12 10:57:02.857 UTC [3890] ubuntu@regression STATEMENT: update jsontriga_deny set dat1 = 'c';
2022-08-12 10:57:02.858 UTC [3890] ubuntu@regression ERROR: Table 'public.logutriga_deny' to queue 'logutriga': change not allowed (UPDATE)
2022-08-12 10:57:02.858 UTC [3890] ubuntu@regression CONTEXT: PL/pgSQL function pgq.logutriga() line 156 at RAISE
2022-08-12 10:57:02.858 UTC [3890] ubuntu@regression STATEMENT: update logutriga_deny set dat1 = 'c';
2022-08-12 10:57:02.859 UTC [3890] ubuntu@regression ERROR: Table 'public.sqltriga_deny' to queue 'sqltriga': change not allowed (UPDATE)
2022-08-12 10:57:02.859 UTC [3890] ubuntu@regression CONTEXT: PL/pgSQL function pgq.sqltriga() line 154 at RAISE
...

The problem is happening because of the fix for CVE-2022-2625:

https://github.com/postgres/postgres/commit/5919bb5a5

Tags: server-todo

Related branches

Revision history for this message
Sergio Durigan Junior (sergiodj) wrote :
Changed in pgq (Ubuntu):
assignee: Sergio Durigan Junior (sergiodj) → nobody
Changed in pgq (Ubuntu Bionic):
importance: Undecided → High
Changed in pgq (Ubuntu Focal):
importance: Undecided → High
Changed in pgq-node (Ubuntu Bionic):
importance: Undecided → High
Changed in pgq-node (Ubuntu Focal):
importance: Undecided → High
Changed in pgq (Ubuntu):
status: New → Invalid
Changed in pgq-node (Ubuntu):
status: New → Invalid
tags: added: server-todo
Changed in pgq (Ubuntu Bionic):
status: New → In Progress
Changed in pgq (Ubuntu Focal):
status: New → In Progress
Changed in pgq (Ubuntu Bionic):
assignee: nobody → Sergio Durigan Junior (sergiodj)
Changed in pgq (Ubuntu Focal):
assignee: nobody → Sergio Durigan Junior (sergiodj)
Changed in pgq-node (Ubuntu Bionic):
status: New → In Progress
Changed in pgq-node (Ubuntu Focal):
status: New → In Progress
Changed in pgq-node (Ubuntu Bionic):
assignee: nobody → Sergio Durigan Junior (sergiodj)
Changed in pgq-node (Ubuntu Focal):
assignee: nobody → Sergio Durigan Junior (sergiodj)
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package pgq - 3.2.6-34-g50068b2-2ubuntu0.1

---------------
pgq (3.2.6-34-g50068b2-2ubuntu0.1) focal-security; urgency=medium

  * d/p/Fix-modload-with-postgresql.patch: Fix module loading
    with new postgresql version. (LP: #1986714)

 -- Sergio Durigan Junior <email address hidden> Wed, 17 Aug 2022 12:12:41 -0400

Changed in pgq (Ubuntu Focal):
status: In Progress → Fix Released
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package pgq - 3.2.6-7ubuntu0.1

---------------
pgq (3.2.6-7ubuntu0.1) bionic-security; urgency=medium

  * d/p/Fix-modload-with-postgresql.patch: Fix module loading
    with new postgresql version. (LP: #1986714)

 -- Sergio Durigan Junior <email address hidden> Wed, 17 Aug 2022 10:58:06 -0400

Changed in pgq (Ubuntu Bionic):
status: In Progress → Fix Released
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package pgq-node - 3.2.5-1ubuntu0.1

---------------
pgq-node (3.2.5-1ubuntu0.1) bionic-security; urgency=medium

  * d/p/Fix-modload-with-postgresql.patch: Fix module loading
    with new postgresql version. (LP: #1986714)

 -- Sergio Durigan Junior <email address hidden> Wed, 17 Aug 2022 12:23:00 -0400

Changed in pgq-node (Ubuntu Bionic):
status: In Progress → Fix Released
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package pgq-node - 3.2.5-7ubuntu0.1

---------------
pgq-node (3.2.5-7ubuntu0.1) focal-security; urgency=medium

  * d/p/Fix-modload-with-postgresql.patch: Fix module loading
    with new postgresql version. (LP: #1986714)

 -- Sergio Durigan Junior <email address hidden> Wed, 17 Aug 2022 14:02:30 -0400

Changed in pgq-node (Ubuntu Focal):
status: In Progress → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.