pg.ddx.io  pgaudit/pgaudit GitHub issues and pull requests  
help / color / mirror / Atom feed
[pgaudit/pgaudit] issue #329: 19beta2: Regression tests fail
6+ messages / 2 participants
[nested] [flat]

* [pgaudit/pgaudit] issue #329: 19beta2: Regression tests fail
@ 2026-07-30 08:18  "df7cb (@df7cb)" <noreply+df7cb@github.com>
  0 siblings, 0 replies; 6+ messages in thread

From: df7cb (@df7cb) @ 2026-07-30 08:18 UTC (permalink / raw)
  To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>

Hi,
on Debian unstable/amd64 during the package build:
```
   debian/rules override_dh_pgxs_test
make[1]: Verzeichnis „/home/myon/projects/postgresql/pgaudit/pgaudit“ wird betreten
pg_buildext -i '--auth=trust' -o'shared_preload_libraries=pgaudit' installcheck . . postgresql-%v-pgaudit
### PostgreSQL 19 installcheck ###
Creating new PostgreSQL cluster 19/regress ...
make[2]: Verzeichnis „/home/myon/projects/postgresql/pgaudit/pgaudit“ wird betreten
echo "# +++ regress install-check in /home/myon/postgresql/pgaudit/pgaudit +++" && /usr/lib/postgresql/19/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=./ --bindir='/usr/lib/postgresql/19/bin'   --temp-config=/home/myon/tmp/pg_virtualenv.UDsLVT/regress.conf --temp-config=/usr/lib/postgresql/19/lib/pgxs/src/makefiles/../../contrib/pgaudit/pgaudit.conf --dbname=contrib_regression pgaudit
# +++ regress install-check in /home/myon/postgresql/pgaudit/pgaudit +++
# using postmaster on localhost, port 5433
ok 1         - pgaudit                                   524 ms
1..1
# All 1 tests passed.
echo "# +++ tap install-check in /home/myon/postgresql/pgaudit/pgaudit +++" && rm -rf '/home/myon/projects/postgresql/pgaudit/pgaudit'/tmp_check && /bin/mkdir -p '/home/myon/projects/postgresql/pgaudit/pgaudit'/tmp_check && cd ./ && TESTLOGDIR='/home/myon/projects/postgresql/pgaudit/pgaudit/tmp_check/log' TESTDATADIR='/home/myon/projects/postgresql/pgaudit/pgaudit/tmp_check' PATH="/usr/lib/postgresql/19/bin:/home/myon/projects/postgresql/pgaudit/pgaudit:$PATH" PGPORT='65432' PG_REGRESS='/usr/lib/postgresql/19/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress' /usr/bin/prove -I /usr/lib/postgresql/19/lib/pgxs/src/makefiles/../../src/test/perl/ -I ./ --verbose t/*.pl
# +++ tap install-check in /home/myon/postgresql/pgaudit/pgaudit +++
t/010_check_stack.pl .. 
# initializing database system by running initdb
# die: unexpected EOF from server at t/010_check_stack.pl line 86.
1..0
skipped: (no reason given)

Test Summary Report
-------------------
t/010_check_stack.pl (Wstat: 65280 (exited 255) Tests: 0 Failed: 0)
  Non-zero exit status: 255
Files=1, Tests=0,  1 wallclock secs ( 0.02 usr  0.00 sys +  0.64 cusr  0.25 csys =  0.91 CPU)
Result: FAIL
make[2]: *** [/usr/lib/postgresql/19/lib/pgxs/src/makefiles/pgxs.mk:434: installcheck] Fehler 1
make[2]: Verzeichnis „/home/myon/projects/postgresql/pgaudit/pgaudit“ wird verlassen
*** /home/myon/tmp/pg_virtualenv.UDsLVT/log/postgresql-19-regress.log (last 100 lines) ***
	SELECT id
	  FROM cte",<not logged>
2026-07-30 10:09:15.070 CEST [3218995] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,3,1,WRITE,INSERT,TABLE,public.test3,<previously logged>,<previously logged>
2026-07-30 10:09:15.070 CEST [3218995] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,3,1,READ,SELECT,TABLE,public.test2,<previously logged>,<previously logged>
2026-07-30 10:09:15.070 CEST [3218995] regress_user2@contrib_regression WARNING:  AUDIT: SESSION,4,1,WRITE,INSERT,,,"WITH CTE AS
	(
		INSERT INTO test3 VALUES (1)
					   RETURNING id
	)
	INSERT INTO test2
	SELECT id
	  FROM cte",<not logged>
2026-07-30 10:09:15.071 CEST [3218995] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,4,1,WRITE,INSERT,TABLE,public.test3,<previously logged>,<previously logged>
2026-07-30 10:09:15.072 CEST [3218995] regress_user2@contrib_regression WARNING:  AUDIT: SESSION,5,1,READ,SELECT,,,SELECT test2_change(91),<not logged>
2026-07-30 10:09:15.072 CEST [3218995] regress_user2@contrib_regression WARNING:  AUDIT: SESSION,5,2,WRITE,UPDATE,,,"UPDATE test2
		   SET id = id + 1
		 WHERE id = change_id",<not logged>
2026-07-30 10:09:15.072 CEST [3218995] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,5,2,WRITE,UPDATE,TABLE,public.test2,<previously logged>,<previously logged>
2026-07-30 10:09:15.073 CEST [3218995] regress_user2@contrib_regression WARNING:  AUDIT: SESSION,6,1,WRITE,INSERT,,,"WITH CTE AS
	(
		UPDATE test2
		   SET id = 45
		 WHERE id = 92
		RETURNING id
	)
	INSERT INTO test3
	SELECT id
	  FROM cte",<not logged>
2026-07-30 10:09:15.073 CEST [3218995] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,6,1,WRITE,INSERT,TABLE,public.test3,<previously logged>,<previously logged>
2026-07-30 10:09:15.073 CEST [3218995] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,6,1,WRITE,UPDATE,TABLE,public.test2,<previously logged>,<previously logged>
2026-07-30 10:09:15.073 CEST [3218995] regress_user2@contrib_regression WARNING:  AUDIT: SESSION,7,1,WRITE,UPDATE,,,"WITH CTE AS
	(
		INSERT INTO test2 VALUES (37)
					   RETURNING id
	)
	UPDATE test3
	   SET id = cte.id
	  FROM cte
	 WHERE test3.id <> cte.id",<not logged>
2026-07-30 10:09:15.073 CEST [3218995] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,7,1,WRITE,INSERT,TABLE,public.test2,<previously logged>,<previously logged>
2026-07-30 10:09:15.074 CEST [3218995] regress_user2@contrib_regression WARNING:  AUDIT: SESSION,8,1,READ,SELECT,,,"SELECT *
	  FROM test2
	 ORDER BY ID",<not logged>
2026-07-30 10:09:15.074 CEST [3218995] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,8,1,READ,SELECT,TABLE,public.test2,<previously logged>,<previously logged>
2026-07-30 10:09:15.086 CEST [3218997] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,1,1,READ,SELECT,TABLE,public.test4,"SELECT name
	  FROM public.test4",<not logged>
2026-07-30 10:09:15.086 CEST [3218997] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,2,1,WRITE,INSERT,TABLE,public.test4,"INSERT INTO public.test4 (name)
					  VALUES ('test')",<not logged>
2026-07-30 10:09:15.087 CEST [3218997] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,3,1,WRITE,UPDATE,TABLE,public.test4,"UPDATE public.test4
	   SET id = 1",<not logged>
2026-07-30 10:09:15.087 CEST [3218997] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,4,1,WRITE,UPDATE,TABLE,public.test4,update public.test4 set name = 'foo' where name = 'bar',<not logged>
2026-07-30 10:09:15.089 CEST [3218997] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,5,1,WRITE,INSERT,TABLE,public.test5,"INSERT INTO public.test5 (col1, col2)
					  VALUES (1, 'bar')
				   RETURNING col2",<not logged>
2026-07-30 10:09:15.089 CEST [3218997] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,6,1,WRITE,UPDATE,TABLE,public.test5,"UPDATE public.test5
	   SET col1 = 2
	 RETURNING col2",<not logged>
2026-07-30 10:09:15.089 CEST [3218997] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,7,1,WRITE,UPDATE,TABLE,public.test5,"UPDATE public.test5
	   SET col2 = 'baz'
	 RETURNING col2",<not logged>
2026-07-30 10:09:15.090 CEST [3218997] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,8,1,WRITE,UPDATE,TABLE,public.test5,"UPDATE public.test5
	   SET col1 = 3
	 RETURNING old.col2, new.col2",<not logged>
2026-07-30 10:09:15.100 CEST [3218999] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,1,1,WRITE,INSERT,TABLE,public.test4,"PREPARE testinsert(int, text) AS
	    INSERT INTO test4 VALUES($1, $2)","1,<long param suppressed>"
2026-07-30 10:09:15.110 CEST [3219001] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,1,1,WRITE,INSERT,TABLE,public.test4,"PREPARE testinsert(int, text) AS
	    INSERT INTO test4 VALUES($1, $2)","2,*******************************************************"
2026-07-30 10:09:15.182 CEST [3219011] myon@contrib_regression ERROR:  schema "bogus" does not exist at character 14
2026-07-30 10:09:15.182 CEST [3219011] myon@contrib_regression QUERY:  CREATE TABLE bogus.test_block
		(
			id INT
		)
2026-07-30 10:09:15.182 CEST [3219011] myon@contrib_regression CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
2026-07-30 10:09:15.182 CEST [3219011] myon@contrib_regression STATEMENT:  DO $$
	BEGIN
		CREATE TABLE bogus.test_block
		(
			id INT
		);
	END $$;
2026-07-30 10:09:15.227 CEST [3218940] LOG:  checkpoint starting: fast force wait
2026-07-30 10:09:15.234 CEST [3218940] LOG:  checkpoint complete: fast force wait: wrote 1016 buffers (6.2%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 1 recycled; write=0.007 s, sync=0.001 s, total=0.008 s; sync files=0, longest=0.000 s, average=0.000 s; distance=9437 kB, estimate=9437 kB; lsn=0/020F8F38, redo lsn=0/020F8ED8
2026-07-30 10:09:15.338 CEST [3219012] myon@contrib_regression ERROR:  schema "bogus" does not exist at character 14
2026-07-30 10:09:15.338 CEST [3219012] myon@contrib_regression QUERY:  CREATE TABLE bogus.test_block
		(
			id INT
		)
2026-07-30 10:09:15.338 CEST [3219012] myon@contrib_regression CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
2026-07-30 10:09:15.338 CEST [3219012] myon@contrib_regression STATEMENT:  DO $$
	BEGIN
		CREATE TABLE bogus.test_block
		(
			id INT
		);
	END $$;
2026-07-30 10:09:15.367 CEST [3218940] LOG:  checkpoint starting: fast force wait
2026-07-30 10:09:15.369 CEST [3218940] LOG:  checkpoint complete: fast force wait: wrote 118 buffers (0.7%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.002 s; sync files=0, longest=0.000 s, average=0.000 s; distance=5375 kB, estimate=9031 kB; lsn=0/02638D48, redo lsn=0/02638CE8
2026-07-30 10:09:15.435 CEST [3219015] myon@contrib_regression WARNING:  AUDIT: SESSION,3,1,DDL,CREATE EXTENSION,,,CREATE EXTENSION pg_stat_statements,<not logged>
2026-07-30 10:09:15.463 CEST [3219015] myon@contrib_regression WARNING:  AUDIT: SESSION,4,1,DDL,ALTER EXTENSION,,,ALTER EXTENSION pg_stat_statements UPDATE TO '1.13',<not logged>
2026-07-30 10:09:15.464 CEST [3219015] myon@contrib_regression WARNING:  AUDIT: SESSION,5,1,DDL,DROP EXTENSION,,,DROP EXTENSION pg_stat_statements,<not logged>
Dropping cluster 19/regress ...
### End 19 installcheck (FAILED with exit code 1) ###
```

That's the TAP part failing.

Sometimes the pg_regress part is also failing:

```
$ debian/tests/installcheck 
### PostgreSQL 18 installcheck ###
Creating new PostgreSQL cluster 18/regress ...
echo "# +++ regress install-check in /home/myon/postgresql/pgaudit/pgaudit +++" && /usr/lib/postgresql/18/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=./ --bindir='/usr/lib/postgresql/18/bin'    --temp-config=/usr/lib/postgresql/18/lib/pgxs/src/makefiles/../../contrib/pgaudit/pgaudit.conf --dbname=contrib_regression pgaudit
# +++ regress install-check in /home/myon/postgresql/pgaudit/pgaudit +++
# using postmaster on localhost, port 5433
not ok 1     - pgaudit                                   455 ms
1..1
# 1 of 1 tests failed.
# The differences that caused some tests to fail can be viewed in the file "/home/myon/projects/postgresql/pgaudit/pgaudit/regression.diffs".
# A copy of the test summary that you see above is saved in the file "/home/myon/projects/postgresql/pgaudit/pgaudit/regression.out".
make: *** [/usr/lib/postgresql/18/lib/pgxs/src/makefiles/pgxs.mk:433: installcheck] Fehler 1
*** /home/myon/tmp/pg_virtualenv.dulJxM/log/postgresql-18-regress.log (last 100 lines) ***
		 WHERE id = 92
		RETURNING id
	)
	INSERT INTO test3
	SELECT id
	  FROM cte",<not logged>
2026-07-30 10:12:26.222 CEST [3221962] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,6,1,WRITE,INSERT,TABLE,public.test3,<previously logged>,<previously logged>
2026-07-30 10:12:26.222 CEST [3221962] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,6,1,WRITE,UPDATE,TABLE,public.test2,<previously logged>,<previously logged>
2026-07-30 10:12:26.222 CEST [3221962] regress_user2@contrib_regression WARNING:  AUDIT: SESSION,7,1,WRITE,UPDATE,,,"WITH CTE AS
	(
		INSERT INTO test2 VALUES (37)
					   RETURNING id
	)
	UPDATE test3
	   SET id = cte.id
	  FROM cte
	 WHERE test3.id <> cte.id",<not logged>
2026-07-30 10:12:26.222 CEST [3221962] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,7,1,WRITE,INSERT,TABLE,public.test2,<previously logged>,<previously logged>
2026-07-30 10:12:26.222 CEST [3221962] regress_user2@contrib_regression WARNING:  AUDIT: SESSION,8,1,READ,SELECT,,,"SELECT *
	  FROM test2
	 ORDER BY ID",<not logged>
2026-07-30 10:12:26.222 CEST [3221962] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,8,1,READ,SELECT,TABLE,public.test2,<previously logged>,<previously logged>
2026-07-30 10:12:26.233 CEST [3221964] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,1,1,READ,SELECT,TABLE,public.test4,"SELECT name
	  FROM public.test4",<not logged>
2026-07-30 10:12:26.234 CEST [3221964] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,2,1,WRITE,INSERT,TABLE,public.test4,"INSERT INTO public.test4 (name)
					  VALUES ('test')",<not logged>
2026-07-30 10:12:26.234 CEST [3221964] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,3,1,WRITE,UPDATE,TABLE,public.test4,"UPDATE public.test4
	   SET id = 1",<not logged>
2026-07-30 10:12:26.234 CEST [3221964] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,4,1,WRITE,UPDATE,TABLE,public.test4,update public.test4 set name = 'foo' where name = 'bar',<not logged>
2026-07-30 10:12:26.235 CEST [3221964] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,5,1,WRITE,INSERT,TABLE,public.test5,"INSERT INTO public.test5 (col1, col2)
					  VALUES (1, 'bar')
				   RETURNING col1",<not logged>
2026-07-30 10:12:26.235 CEST [3221964] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,6,1,WRITE,INSERT,TABLE,public.test5,"INSERT INTO public.test5 (col1, col2)
					  VALUES (1, 'bar')
				   RETURNING col2",<not logged>
2026-07-30 10:12:26.236 CEST [3221964] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,7,1,WRITE,UPDATE,TABLE,public.test5,"UPDATE public.test5
	   SET col2 = 'baz'
	 RETURNING col1",<not logged>
2026-07-30 10:12:26.236 CEST [3221964] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,8,1,WRITE,UPDATE,TABLE,public.test5,"UPDATE public.test5
	   SET col1 = 2
	 RETURNING col2",<not logged>
2026-07-30 10:12:26.236 CEST [3221964] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,9,1,WRITE,UPDATE,TABLE,public.test5,"UPDATE public.test5
	   SET col2 = 'baz'
	 RETURNING col2",<not logged>
2026-07-30 10:12:26.236 CEST [3221964] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,10,1,WRITE,UPDATE,TABLE,public.test5,"UPDATE public.test5
	   SET col1 = 3
	 RETURNING old.col2, new.col2",<not logged>
2026-07-30 10:12:26.247 CEST [3221966] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,1,1,WRITE,INSERT,TABLE,public.test4,"PREPARE testinsert(int, text) AS
	    INSERT INTO test4 VALUES($1, $2)","1,<long param suppressed>"
2026-07-30 10:12:26.256 CEST [3221968] regress_user2@contrib_regression WARNING:  AUDIT: OBJECT,1,1,WRITE,INSERT,TABLE,public.test4,"PREPARE testinsert(int, text) AS
	    INSERT INTO test4 VALUES($1, $2)","2,*******************************************************"
2026-07-30 10:12:26.330 CEST [3221978] myon@contrib_regression ERROR:  schema "bogus" does not exist at character 14
2026-07-30 10:12:26.330 CEST [3221978] myon@contrib_regression QUERY:  CREATE TABLE bogus.test_block
		(
			id INT
		)
2026-07-30 10:12:26.330 CEST [3221978] myon@contrib_regression CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
2026-07-30 10:12:26.330 CEST [3221978] myon@contrib_regression STATEMENT:  DO $$
	BEGIN
		CREATE TABLE bogus.test_block
		(
			id INT
		);
	END $$;
2026-07-30 10:12:26.371 CEST [3221914] LOG:  Checkpoint beginnt: immediate force wait
2026-07-30 10:12:26.377 CEST [3221914] LOG:  Checkpoint komplett: 991 Puffer geschrieben (6.0%), 3 SLRU-Puffer geschrieben; 0 WAL-Datei(en) hinzugefügt, 0 entfernt, 1 wiederverwendet; Schreiben=0,006 s, Sync=0,001 s, gesamt=0,007 s; sync. Dateien=0, längste=0,000 s, Durchschnitt=0.000 s; Entfernung=9181 kB, Schätzung=9181 kB; LSN=0/209BA98, Redo-LSN=0/209BA40
2026-07-30 10:12:26.404 CEST [3221978] myon@contrib_regression ERROR:  cannot copy from partitioned table "h"
2026-07-30 10:12:26.404 CEST [3221978] myon@contrib_regression HINT:  Try the COPY (SELECT ...) TO variant.
2026-07-30 10:12:26.404 CEST [3221978] myon@contrib_regression STATEMENT:  COPY h TO stdout;
2026-07-30 10:12:26.465 CEST [3221980] myon@contrib_regression ERROR:  schema "bogus" does not exist at character 14
2026-07-30 10:12:26.465 CEST [3221980] myon@contrib_regression QUERY:  CREATE TABLE bogus.test_block
		(
			id INT
		)
2026-07-30 10:12:26.465 CEST [3221980] myon@contrib_regression CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
2026-07-30 10:12:26.465 CEST [3221980] myon@contrib_regression STATEMENT:  DO $$
	BEGIN
		CREATE TABLE bogus.test_block
		(
			id INT
		);
	END $$;
2026-07-30 10:12:26.491 CEST [3221914] LOG:  Checkpoint beginnt: immediate force wait
2026-07-30 10:12:26.494 CEST [3221914] LOG:  Checkpoint komplett: 114 Puffer geschrieben (0.7%), 1 SLRU-Puffer geschrieben; 0 WAL-Datei(en) hinzugefügt, 0 entfernt, 0 wiederverwendet; Schreiben=0,002 s, Sync=0,001 s, gesamt=0,003 s; sync. Dateien=0, längste=0,000 s, Durchschnitt=0.000 s; Entfernung=5206 kB, Schätzung=8783 kB; LSN=0/25B1538, Redo-LSN=0/25B14E0
2026-07-30 10:12:26.523 CEST [3221980] myon@contrib_regression ERROR:  cannot copy from partitioned table "h"
2026-07-30 10:12:26.523 CEST [3221980] myon@contrib_regression HINT:  Try the COPY (SELECT ...) TO variant.
2026-07-30 10:12:26.523 CEST [3221980] myon@contrib_regression STATEMENT:  COPY h TO stdout;
2026-07-30 10:12:26.543 CEST [3221983] myon@contrib_regression WARNING:  AUDIT: SESSION,3,1,DDL,CREATE EXTENSION,,,CREATE EXTENSION pg_stat_statements,<not logged>
2026-07-30 10:12:26.557 CEST [3221983] myon@contrib_regression WARNING:  AUDIT: SESSION,4,1,DDL,ALTER EXTENSION,,,ALTER EXTENSION pg_stat_statements UPDATE TO '1.13',<not logged>
2026-07-30 10:12:26.557 CEST [3221983] myon@contrib_regression ERROR:  extension "pg_stat_statements" has no update path from version "1.12" to version "1.13"
2026-07-30 10:12:26.557 CEST [3221983] myon@contrib_regression STATEMENT:  ALTER EXTENSION pg_stat_statements UPDATE TO '1.13';
2026-07-30 10:12:26.558 CEST [3221983] myon@contrib_regression WARNING:  AUDIT: SESSION,5,1,DDL,DROP EXTENSION,,,DROP EXTENSION pg_stat_statements,<not logged>
2026-07-30 10:12:26.592 CEST [3221983] myon@contrib_regression ERROR:  syntax error at or near "PROPERTY" at character 8
2026-07-30 10:12:26.592 CEST [3221983] myon@contrib_regression STATEMENT:  CREATE PROPERTY GRAPH graph_test VERTEX TABLES (graph_vertex);
2026-07-30 10:12:26.592 CEST [3221983] myon@contrib_regression ERROR:  syntax error at or near "MATCH" at character 44
2026-07-30 10:12:26.592 CEST [3221983] myon@contrib_regression STATEMENT:  SELECT name
	  FROM GRAPH_TABLE (graph_test MATCH (v IS graph_vertex) COLUMNS (v.name))
	 ORDER BY name;
2026-07-30 10:12:26.592 CEST [3221983] myon@contrib_regression ERROR:  syntax error at or near "PROPERTY" at character 6
2026-07-30 10:12:26.592 CEST [3221983] myon@contrib_regression STATEMENT:  DROP PROPERTY GRAPH graph_test;
Dropping cluster 18/regress ...
**** regression.diffs ****
inline patch 1: /home/myon/projects/postgresql/pgaudit/pgaudit/results/pgaudit.out (+63/-52 lines) download inline-1.patchdiff -U3 /home/myon/projects/postgresql/pgaudit/pgaudit/expected/pgaudit.out /home/myon/projects/postgresql/pgaudit/pgaudit/results/pgaudit.out --- /home/myon/projects/postgresql/pgaudit/pgaudit/expected/pgaudit.out 2026-07-29 03:47:28.000000000 +0200 +++ /home/myon/projects/postgresql/pgaudit/pgaudit/results/pgaudit.out 2026-07-30 10:12:26.606297926 +0200 @@ -399,6 +399,9 @@ INSERT INTO public.test5 (col1, col2) VALUES (1, 'bar') RETURNING col1; +WARNING: AUDIT: OBJECT,5,1,WRITE,INSERT,TABLE,public.test5,"INSERT INTO public.test5 (col1, col2) + VALUES (1, 'bar') + RETURNING col1",<not logged> col1 ------ 1 @@ -410,7 +413,7 @@ INSERT INTO public.test5 (col1, col2) VALUES (1, 'bar') RETURNING col2; -WARNING: AUDIT: OBJECT,5,1,WRITE,INSERT,TABLE,public.test5,"INSERT INTO public.test5 (col1, col2) +WARNING: AUDIT: OBJECT,6,1,WRITE,INSERT,TABLE,public.test5,"INSERT INTO public.test5 (col1, col2) VALUES (1, 'bar') RETURNING col2",<not logged> col2 @@ -424,6 +427,9 @@ UPDATE public.test5 SET col2 = 'baz' RETURNING col1; +WARNING: AUDIT: OBJECT,7,1,WRITE,UPDATE,TABLE,public.test5,"UPDATE public.test5 + SET col2 = 'baz' + RETURNING col1",<not logged> col1 ------ 1 @@ -436,7 +442,7 @@ UPDATE public.test5 SET col1 = 2 RETURNING col2; -WARNING: AUDIT: OBJECT,6,1,WRITE,UPDATE,TABLE,public.test5,"UPDATE public.test5 +WARNING: AUDIT: OBJECT,8,1,WRITE,UPDATE,TABLE,public.test5,"UPDATE public.test5 SET col1 = 2 RETURNING col2",<not logged> col2 @@ -452,7 +458,7 @@ UPDATE public.test5 SET col2 = 'baz' RETURNING col2; -WARNING: AUDIT: OBJECT,7,1,WRITE,UPDATE,TABLE,public.test5,"UPDATE public.test5 +WARNING: AUDIT: OBJECT,9,1,WRITE,UPDATE,TABLE,public.test5,"UPDATE public.test5 SET col2 = 'baz' RETURNING col2",<not logged> col2 @@ -468,7 +474,7 @@ UPDATE public.test5 SET col1 = 3 RETURNING old.col2, new.col2; -WARNING: AUDIT: OBJECT,8,1,WRITE,UPDATE,TABLE,public.test5,"UPDATE public.test5 +WARNING: AUDIT: OBJECT,10,1,WRITE,UPDATE,TABLE,public.test5,"UPDATE public.test5 SET col1 = 3 RETURNING old.col2, new.col2",<not logged> col2 | col2 @@ -781,7 +787,7 @@ -- -- Copy account to stdout COPY account TO stdout; -NOTICE: AUDIT: SESSION,8,1,READ,COPY,TABLE,public.account,COPY account TO stdout,<none> +NOTICE: AUDIT: SESSION,8,1,READ,SELECT,TABLE,public.account,COPY account TO stdout,<none> 1 regress_user1 HASH2 yada, yada -- -- Create a table from a query @@ -797,7 +803,7 @@ -- -- Copy from stdin to account copy COPY test.account_copy from stdin; -NOTICE: AUDIT: SESSION,10,1,WRITE,COPY,TABLE,test.account_copy,COPY test.account_copy from stdin,<none> +NOTICE: AUDIT: SESSION,10,1,WRITE,INSERT,TABLE,test.account_copy,COPY test.account_copy from stdin,<none> -- -- Test prepared statement PREPARE pgclassstmt (oid) AS @@ -984,6 +990,7 @@ END $$",<none> NOTICE: AUDIT: SESSION,29,2,READ,SELECT,,,"SELECT 1, substring('Thomas' from 2 for 3)",<none> +NOTICE: AUDIT: SESSION,29,3,READ,SELECT,,,SELECT 56 * 89,<none> explain select 1; NOTICE: AUDIT: SESSION,30,1,READ,SELECT,,,explain select 1,<none> NOTICE: AUDIT: SESSION,30,2,MISC,EXPLAIN,,,explain select 1,<none> @@ -1326,8 +1333,12 @@ SET pgaudit.log_parameter TO OFF; INSERT INTO bbb VALUES (1); NOTICE: AUDIT: SESSION,67,1,WRITE,INSERT,TABLE,public.bbb,INSERT INTO bbb VALUES (1),<not logged> -NOTICE: AUDIT: OBJECT,67,2,WRITE,UPDATE,TABLE,public.bbb,UPDATE bbb set id = new.id + 1,<not logged> -NOTICE: AUDIT: SESSION,67,2,WRITE,UPDATE,TABLE,public.bbb,UPDATE bbb set id = new.id + 1,<not logged> +NOTICE: AUDIT: OBJECT,67,2,READ,SELECT,TABLE,public.aaa,"SELECT 1 FROM ONLY ""public"".""aaa"" x WHERE ""id"" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x",<not logged> +NOTICE: AUDIT: SESSION,67,2,READ,SELECT,TABLE,public.aaa,"SELECT 1 FROM ONLY ""public"".""aaa"" x WHERE ""id"" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x",<not logged> +NOTICE: AUDIT: OBJECT,67,3,WRITE,UPDATE,TABLE,public.bbb,UPDATE bbb set id = new.id + 1,<not logged> +NOTICE: AUDIT: SESSION,67,3,WRITE,UPDATE,TABLE,public.bbb,UPDATE bbb set id = new.id + 1,<not logged> +NOTICE: AUDIT: OBJECT,67,4,READ,SELECT,TABLE,public.aaa,"SELECT 1 FROM ONLY ""public"".""aaa"" x WHERE ""id"" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x",<not logged> +NOTICE: AUDIT: SESSION,67,4,READ,SELECT,TABLE,public.aaa,"SELECT 1 FROM ONLY ""public"".""aaa"" x WHERE ""id"" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x",<not logged> SET pgaudit.log_parameter TO ON; DROP TABLE bbb; DROP TABLE aaa; @@ -1413,12 +1424,10 @@ (1 row) COPY h FROM stdin; -NOTICE: AUDIT: SESSION,94,1,WRITE,COPY,TABLE,public.h,COPY h FROM stdin,<none> +NOTICE: AUDIT: SESSION,94,1,WRITE,INSERT,TABLE,public.h,COPY h FROM stdin,<none> COPY h TO stdout; -NOTICE: AUDIT: SESSION,95,1,READ,COPY,TABLE,public.h,COPY h TO stdout,<none> -1 1 -2 2 -3 3 +NOTICE: AUDIT: SESSION,95,1,READ,SELECT,TABLE,public.h,COPY h TO stdout,<none> +ERROR: cannot copy from partitioned table "h" COPY (SELECT * FROM h) TO stdout; NOTICE: AUDIT: SESSION,96,1,READ,SELECT,TABLE,public.h,COPY (SELECT * FROM h) TO stdout,<none> 1 1 @@ -1446,15 +1455,17 @@ INSERT INTO fk_fk VALUES (1); NOTICE: AUDIT: SESSION,103,1,WRITE,INSERT,TABLE,public.fk_fk,INSERT INTO fk_fk VALUES (1),<none> ALTER TABLE fk_fk ADD CONSTRAINT fk_fk_id_fkey FOREIGN KEY (id) REFERENCES fk_pk(id); -NOTICE: AUDIT: SESSION,104,1,READ,SELECT,TABLE,public.fk_fk,"SELECT fk.""id"" FROM ONLY ""public"".""fk_fk"" fk LEFT OUTER JOIN ONLY ""public"".""fk_pk"" pk ON ( pk.""id"" OPERATOR(pg_catalog.=) fk.""id"") WHERE pk.""id"" IS NULL AND (fk.""id"" IS NOT NULL)",<none> -NOTICE: AUDIT: SESSION,104,1,READ,SELECT,TABLE,public.fk_pk,"SELECT fk.""id"" FROM ONLY ""public"".""fk_fk"" fk LEFT OUTER JOIN ONLY ""public"".""fk_pk"" pk ON ( pk.""id"" OPERATOR(pg_catalog.=) fk.""id"") WHERE pk.""id"" IS NULL AND (fk.""id"" IS NOT NULL)",<none> -NOTICE: AUDIT: SESSION,104,2,DDL,ALTER TABLE,,,ALTER TABLE fk_fk ADD CONSTRAINT fk_fk_id_fkey FOREIGN KEY (id) REFERENCES fk_pk(id),<none> +NOTICE: AUDIT: SESSION,104,1,READ,SELECT,TABLE,public.fk_pk,ALTER TABLE fk_fk ADD CONSTRAINT fk_fk_id_fkey FOREIGN KEY (id) REFERENCES fk_pk(id),<none> +NOTICE: AUDIT: SESSION,104,1,READ,SELECT,TABLE,public.fk_fk,ALTER TABLE fk_fk ADD CONSTRAINT fk_fk_id_fkey FOREIGN KEY (id) REFERENCES fk_pk(id),<none> +NOTICE: AUDIT: SESSION,104,2,READ,SELECT,TABLE,public.fk_fk,"SELECT fk.""id"" FROM ONLY ""public"".""fk_fk"" fk LEFT OUTER JOIN ONLY ""public"".""fk_pk"" pk ON ( pk.""id"" OPERATOR(pg_catalog.=) fk.""id"") WHERE pk.""id"" IS NULL AND (fk.""id"" IS NOT NULL)",<none> +NOTICE: AUDIT: SESSION,104,2,READ,SELECT,TABLE,public.fk_pk,"SELECT fk.""id"" FROM ONLY ""public"".""fk_fk"" fk LEFT OUTER JOIN ONLY ""public"".""fk_pk"" pk ON ( pk.""id"" OPERATOR(pg_catalog.=) fk.""id"") WHERE pk.""id"" IS NULL AND (fk.""id"" IS NOT NULL)",<none> ALTER TABLE fk_fk ADD CONSTRAINT fk_fk_id_fkey_nv FOREIGN KEY (id) REFERENCES fk_pk(id) NOT VALID; NOTICE: AUDIT: SESSION,105,1,DDL,ALTER TABLE,,,ALTER TABLE fk_fk ADD CONSTRAINT fk_fk_id_fkey_nv FOREIGN KEY (id) REFERENCES fk_pk(id) NOT VALID,<none> ALTER TABLE fk_fk VALIDATE CONSTRAINT fk_fk_id_fkey_nv; -NOTICE: AUDIT: SESSION,106,1,READ,SELECT,TABLE,public.fk_fk,"SELECT fk.""id"" FROM ONLY ""public"".""fk_fk"" fk LEFT OUTER JOIN ONLY ""public"".""fk_pk"" pk ON ( pk.""id"" OPERATOR(pg_catalog.=) fk.""id"") WHERE pk.""id"" IS NULL AND (fk.""id"" IS NOT NULL)",<none> -NOTICE: AUDIT: SESSION,106,1,READ,SELECT,TABLE,public.fk_pk,"SELECT fk.""id"" FROM ONLY ""public"".""fk_fk"" fk LEFT OUTER JOIN ONLY ""public"".""fk_pk"" pk ON ( pk.""id"" OPERATOR(pg_catalog.=) fk.""id"") WHERE pk.""id"" IS NULL AND (fk.""id"" IS NOT NULL)",<none> -NOTICE: AUDIT: SESSION,106,2,DDL,ALTER TABLE,,,ALTER TABLE fk_fk VALIDATE CONSTRAINT fk_fk_id_fkey_nv,<none> +NOTICE: AUDIT: SESSION,106,1,READ,SELECT,TABLE,public.fk_pk,ALTER TABLE fk_fk VALIDATE CONSTRAINT fk_fk_id_fkey_nv,<none> +NOTICE: AUDIT: SESSION,106,1,READ,SELECT,TABLE,public.fk_fk,ALTER TABLE fk_fk VALIDATE CONSTRAINT fk_fk_id_fkey_nv,<none> +NOTICE: AUDIT: SESSION,106,2,READ,SELECT,TABLE,public.fk_fk,"SELECT fk.""id"" FROM ONLY ""public"".""fk_fk"" fk LEFT OUTER JOIN ONLY ""public"".""fk_pk"" pk ON ( pk.""id"" OPERATOR(pg_catalog.=) fk.""id"") WHERE pk.""id"" IS NULL AND (fk.""id"" IS NOT NULL)",<none> +NOTICE: AUDIT: SESSION,106,2,READ,SELECT,TABLE,public.fk_pk,"SELECT fk.""id"" FROM ONLY ""public"".""fk_fk"" fk LEFT OUTER JOIN ONLY ""public"".""fk_pk"" pk ON ( pk.""id"" OPERATOR(pg_catalog.=) fk.""id"") WHERE pk.""id"" IS NULL AND (fk.""id"" IS NOT NULL)",<none> DROP TABLE fk_fk; NOTICE: AUDIT: SESSION,107,1,DDL,DROP TABLE,,,DROP TABLE fk_fk,<none> DROP TABLE fk_pk; @@ -1967,8 +1978,7 @@ 1 regress_user1 HASH4 yada, yada3 1 regress_user2 HASH4 yada, yada3 1 user3 HASH4 yada, yada3 -NOTICE: AUDIT: OBJECT,51,1,READ,COPY,TABLE,public.account,COPY account TO stdout,<none>,3 -NOTICE: AUDIT: SESSION,51,1,READ,COPY,TABLE,public.account,COPY account TO stdout,<none>,3 +NOTICE: AUDIT: SESSION,51,1,READ,COPY,,,COPY account TO stdout,<none>,0 -- -- Drop a table from a query DROP TABLE test.account_copy; @@ -1990,7 +2000,7 @@ -- -- Copy from stdin to account copy COPY test.account_copy from stdin; -NOTICE: AUDIT: SESSION,54,1,WRITE,COPY,TABLE,test.account_copy,COPY test.account_copy from stdin,<none>,1 +NOTICE: AUDIT: SESSION,54,1,WRITE,COPY,,,COPY test.account_copy from stdin,<none>,0 -- -- Test prepared statement PREPARE pgclassstmt1 (oid) AS @@ -2552,9 +2562,13 @@ NOTICE: AUDIT: SESSION,120,1,WRITE,INSERT,TABLE,public.aaa,"INSERT INTO aaa VALUES (generate_series(1,100))",<none>,100 SET pgaudit.log_parameter TO OFF; INSERT INTO bbb VALUES (1); -NOTICE: AUDIT: OBJECT,121,1,WRITE,UPDATE,TABLE,public.bbb,UPDATE bbb set id = new.id + 1,<not logged>,1 -NOTICE: AUDIT: SESSION,121,1,WRITE,UPDATE,TABLE,public.bbb,UPDATE bbb set id = new.id + 1,<not logged>,1 -NOTICE: AUDIT: SESSION,121,2,WRITE,INSERT,TABLE,public.bbb,INSERT INTO bbb VALUES (1),<not logged>,1 +NOTICE: AUDIT: OBJECT,121,1,READ,SELECT,TABLE,public.aaa,"SELECT 1 FROM ONLY ""public"".""aaa"" x WHERE ""id"" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x",<not logged>,1 +NOTICE: AUDIT: SESSION,121,1,READ,SELECT,TABLE,public.aaa,"SELECT 1 FROM ONLY ""public"".""aaa"" x WHERE ""id"" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x",<not logged>,1 +NOTICE: AUDIT: OBJECT,121,2,READ,SELECT,TABLE,public.aaa,"SELECT 1 FROM ONLY ""public"".""aaa"" x WHERE ""id"" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x",<not logged>,1 +NOTICE: AUDIT: SESSION,121,2,READ,SELECT,TABLE,public.aaa,"SELECT 1 FROM ONLY ""public"".""aaa"" x WHERE ""id"" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x",<not logged>,1 +NOTICE: AUDIT: OBJECT,121,3,WRITE,UPDATE,TABLE,public.bbb,UPDATE bbb set id = new.id + 1,<not logged>,1 +NOTICE: AUDIT: SESSION,121,3,WRITE,UPDATE,TABLE,public.bbb,UPDATE bbb set id = new.id + 1,<not logged>,1 +NOTICE: AUDIT: SESSION,121,4,WRITE,INSERT,TABLE,public.bbb,INSERT INTO bbb VALUES (1),<not logged>,1 SET pgaudit.log_parameter TO ON; DROP TABLE bbb; DROP TABLE aaa; @@ -2631,24 +2645,21 @@ (1 row) COPY h FROM stdin; -NOTICE: AUDIT: SESSION,146,1,WRITE,COPY,TABLE,public.h,COPY h FROM stdin,<none>,2 +NOTICE: AUDIT: SESSION,146,1,WRITE,COPY,,,COPY h FROM stdin,<none>,0 COPY h TO stdout; -1 1 -2 2 -3 3 -NOTICE: AUDIT: SESSION,147,1,READ,COPY,TABLE,public.h,COPY h TO stdout,<none>,3 +ERROR: cannot copy from partitioned table "h" COPY (SELECT * FROM h) TO stdout; 1 1 2 2 3 3 -NOTICE: AUDIT: SESSION,148,1,READ,SELECT,TABLE,public.h,COPY (SELECT * FROM h) TO stdout,<none>,3 -NOTICE: AUDIT: SESSION,148,2,READ,COPY,,,COPY (SELECT * FROM h) TO stdout,<none>,3 +NOTICE: AUDIT: SESSION,147,1,READ,SELECT,TABLE,public.h,COPY (SELECT * FROM h) TO stdout,<none>,3 +NOTICE: AUDIT: SESSION,147,2,READ,COPY,,,COPY (SELECT * FROM h) TO stdout,<none>,0 CREATE INDEX h_idx ON h (x); -NOTICE: AUDIT: SESSION,149,1,DDL,CREATE INDEX,,,CREATE INDEX h_idx ON h (x),<none>,0 +NOTICE: AUDIT: SESSION,148,1,DDL,CREATE INDEX,,,CREATE INDEX h_idx ON h (x),<none>,0 DROP INDEX h_idx; -NOTICE: AUDIT: SESSION,150,1,DDL,DROP INDEX,,,DROP INDEX h_idx,<none>,0 +NOTICE: AUDIT: SESSION,149,1,DDL,DROP INDEX,,,DROP INDEX h_idx,<none>,0 DROP TABLE h; -NOTICE: AUDIT: SESSION,151,1,DDL,DROP TABLE,,,DROP TABLE h,<none>,0 +NOTICE: AUDIT: SESSION,150,1,DDL,DROP TABLE,,,DROP TABLE h,<none>,0 -- -- Change configuration of user 1 so that full statements are not logged \connect - :current_user @@ -2708,7 +2719,7 @@ WARNING: AUDIT: SESSION,3,1,DDL,CREATE EXTENSION,,,CREATE EXTENSION pg_stat_statements,<not logged> ALTER EXTENSION pg_stat_statements UPDATE TO '1.13'; WARNING: AUDIT: SESSION,4,1,DDL,ALTER EXTENSION,,,ALTER EXTENSION pg_stat_statements UPDATE TO '1.13',<not logged> -NOTICE: version "1.13" of extension "pg_stat_statements" is already installed +ERROR: extension "pg_stat_statements" has no update path from version "1.12" to version "1.13" DROP EXTENSION pg_stat_statements; WARNING: AUDIT: SESSION,5,1,DDL,DROP EXTENSION,,,DROP EXTENSION pg_stat_statements,<not logged> SET pgaudit.log_level = 'notice'; @@ -2763,25 +2774,16 @@ CREATE TABLE graph_vertex (id int PRIMARY KEY, name text); INSERT INTO graph_vertex VALUES (1, 'alice'), (2, 'bob'); CREATE PROPERTY GRAPH graph_test VERTEX TABLES (graph_vertex); +ERROR: syntax error at or near "PROPERTY" at character 8 -- -- Session logged on the property graph (object type PROPERTY GRAPH) and on the -- underlying vertex table because log = read and log_relation = on SELECT name FROM GRAPH_TABLE (graph_test MATCH (v IS graph_vertex) COLUMNS (v.name)) ORDER BY name; -NOTICE: AUDIT: SESSION,14,1,READ,SELECT,PROPERTY GRAPH,public.graph_test,"SELECT name - FROM GRAPH_TABLE (graph_test MATCH (v IS graph_vertex) COLUMNS (v.name)) - ORDER BY name",<not logged> -NOTICE: AUDIT: SESSION,14,1,READ,SELECT,TABLE,public.graph_vertex,"SELECT name - FROM GRAPH_TABLE (graph_test MATCH (v IS graph_vertex) COLUMNS (v.name)) - ORDER BY name",<not logged> - name -------- - alice - bob -(2 rows) - +ERROR: syntax error at or near "MATCH" at character 44 DROP PROPERTY GRAPH graph_test; +ERROR: syntax error at or near "PROPERTY" at character 6 DROP TABLE graph_vertex; -- -- Test that a role substatement (GRANT) collected as the last command of a DDL @@ -2795,13 +2797,17 @@ SET pgaudit.log_relation = off; SET pgaudit.log = 'ddl'; CREATE TABLE schema_grant_tbl (id int); -NOTICE: AUDIT: SESSION,15,1,DDL,CREATE TABLE,TABLE,public.schema_grant_tbl,CREATE TABLE schema_grant_tbl (id int),<not logged> +NOTICE: AUDIT: SESSION,14,1,DDL,CREATE TABLE,TABLE,public.schema_grant_tbl,CREATE TABLE schema_grant_tbl (id int),<not logged> CREATE ROLE regress_schema_grant; CREATE SCHEMA schema_grant GRANT SELECT ON public.schema_grant_tbl TO regress_schema_grant; -NOTICE: AUDIT: SESSION,16,1,DDL,CREATE SCHEMA,SCHEMA,schema_grant,"CREATE SCHEMA schema_grant +NOTICE: AUDIT: SESSION,15,1,DDL,CREATE SCHEMA,SCHEMA,schema_grant,"CREATE SCHEMA schema_grant + GRANT SELECT + ON public.schema_grant_tbl + TO regress_schema_grant",<not logged> +NOTICE: AUDIT: SESSION,15,1,DDL,GRANT, ,,"CREATE SCHEMA schema_grant GRANT SELECT ON public.schema_grant_tbl TO regress_schema_grant",<not logged> @@ -2815,12 +2821,17 @@ GRANT SELECT ON schema_auth_tbl TO PUBLIC; -NOTICE: AUDIT: SESSION,17,1,DDL,CREATE SCHEMA,SCHEMA,regress_schema_auth,"CREATE SCHEMA AUTHORIZATION regress_schema_auth +NOTICE: AUDIT: SESSION,16,1,DDL,CREATE SCHEMA,SCHEMA,regress_schema_auth,"CREATE SCHEMA AUTHORIZATION regress_schema_auth + CREATE TABLE schema_auth_tbl (id int) + GRANT SELECT + ON schema_auth_tbl + TO PUBLIC",<not logged> +NOTICE: AUDIT: SESSION,16,1,DDL,CREATE TABLE,TABLE,regress_schema_auth.schema_auth_tbl,"CREATE SCHEMA AUTHORIZATION regress_schema_auth CREATE TABLE schema_auth_tbl (id int) GRANT SELECT ON schema_auth_tbl TO PUBLIC",<not logged> -NOTICE: AUDIT: SESSION,17,1,DDL,CREATE TABLE,TABLE,regress_schema_auth.schema_auth_tbl,"CREATE SCHEMA AUTHORIZATION regress_schema_auth +NOTICE: AUDIT: SESSION,16,1,DDL,GRANT,!@,,"CREATE SCHEMA AUTHORIZATION regress_schema_auth CREATE TABLE schema_auth_tbl (id int) GRANT SELECT ON schema_auth_tbl
### End 18 installcheck (FAILED with exit code 1) ### ### PostgreSQL 19 installcheck ### Creating new PostgreSQL cluster 19/regress ... echo "# +++ regress install-check in /home/myon/postgresql/pgaudit/pgaudit +++" && /usr/lib/postgresql/19/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=./ --bindir='/usr/lib/postgresql/19/bin' --temp-config=/usr/lib/postgresql/19/lib/pgxs/src/makefiles/../../contrib/pgaudit/pgaudit.conf --dbname=contrib_regression pgaudit # +++ regress install-check in /home/myon/postgresql/pgaudit/pgaudit +++ # using postmaster on localhost, port 5433 ok 1 - pgaudit 433 ms 1..1 # All 1 tests passed. echo "# +++ tap install-check in /home/myon/postgresql/pgaudit/pgaudit +++" && rm -rf '/home/myon/projects/postgresql/pgaudit/pgaudit'/tmp_check && /bin/mkdir -p '/home/myon/projects/postgresql/pgaudit/pgaudit'/tmp_check && cd ./ && TESTLOGDIR='/home/myon/projects/postgresql/pgaudit/pgaudit/tmp_check/log' TESTDATADIR='/home/myon/projects/postgresql/pgaudit/pgaudit/tmp_check' PATH="/usr/lib/postgresql/19/bin:/home/myon/projects/postgresql/pgaudit/pgaudit:$PATH" PGPORT='65432' PG_REGRESS='/usr/lib/postgresql/19/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress' /usr/bin/prove -I /usr/lib/postgresql/19/lib/pgxs/src/makefiles/../../src/test/perl/ -I ./ --verbose t/*.pl # +++ tap install-check in /home/myon/postgresql/pgaudit/pgaudit +++ t/010_check_stack.pl .. # initializing database system by running initdb # die: unexpected EOF from server at t/010_check_stack.pl line 86. 1..0 skipped: (no reason given) Test Summary Report ------------------- t/010_check_stack.pl (Wstat: 65280 (exited 255) Tests: 0 Failed: 0) Non-zero exit status: 255 Files=1, Tests=0, 1 wallclock secs ( 0.02 usr 0.00 sys + 0.51 cusr 0.18 csys = 0.71 CPU) Result: FAIL make: *** [/usr/lib/postgresql/19/lib/pgxs/src/makefiles/pgxs.mk:434: installcheck] Fehler 1 *** /home/myon/tmp/pg_virtualenv.kkIa3Y/log/postgresql-19-regress.log (last 100 lines) *** SELECT id FROM cte",<not logged> 2026-07-30 10:12:29.850 CEST [3222095] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,3,1,WRITE,INSERT,TABLE,public.test3,<previously logged>,<previously logged> 2026-07-30 10:12:29.850 CEST [3222095] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,3,1,READ,SELECT,TABLE,public.test2,<previously logged>,<previously logged> 2026-07-30 10:12:29.850 CEST [3222095] regress_user2@contrib_regression WARNING: AUDIT: SESSION,4,1,WRITE,INSERT,,,"WITH CTE AS ( INSERT INTO test3 VALUES (1) RETURNING id ) INSERT INTO test2 SELECT id FROM cte",<not logged> 2026-07-30 10:12:29.850 CEST [3222095] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,4,1,WRITE,INSERT,TABLE,public.test3,<previously logged>,<previously logged> 2026-07-30 10:12:29.852 CEST [3222095] regress_user2@contrib_regression WARNING: AUDIT: SESSION,5,1,READ,SELECT,,,SELECT test2_change(91),<not logged> 2026-07-30 10:12:29.852 CEST [3222095] regress_user2@contrib_regression WARNING: AUDIT: SESSION,5,2,WRITE,UPDATE,,,"UPDATE test2 SET id = id + 1 WHERE id = change_id",<not logged> 2026-07-30 10:12:29.852 CEST [3222095] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,5,2,WRITE,UPDATE,TABLE,public.test2,<previously logged>,<previously logged> 2026-07-30 10:12:29.852 CEST [3222095] regress_user2@contrib_regression WARNING: AUDIT: SESSION,6,1,WRITE,INSERT,,,"WITH CTE AS ( UPDATE test2 SET id = 45 WHERE id = 92 RETURNING id ) INSERT INTO test3 SELECT id FROM cte",<not logged> 2026-07-30 10:12:29.852 CEST [3222095] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,6,1,WRITE,INSERT,TABLE,public.test3,<previously logged>,<previously logged> 2026-07-30 10:12:29.852 CEST [3222095] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,6,1,WRITE,UPDATE,TABLE,public.test2,<previously logged>,<previously logged> 2026-07-30 10:12:29.853 CEST [3222095] regress_user2@contrib_regression WARNING: AUDIT: SESSION,7,1,WRITE,UPDATE,,,"WITH CTE AS ( INSERT INTO test2 VALUES (37) RETURNING id ) UPDATE test3 SET id = cte.id FROM cte WHERE test3.id <> cte.id",<not logged> 2026-07-30 10:12:29.853 CEST [3222095] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,7,1,WRITE,INSERT,TABLE,public.test2,<previously logged>,<previously logged> 2026-07-30 10:12:29.853 CEST [3222095] regress_user2@contrib_regression WARNING: AUDIT: SESSION,8,1,READ,SELECT,,,"SELECT * FROM test2 ORDER BY ID",<not logged> 2026-07-30 10:12:29.853 CEST [3222095] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,8,1,READ,SELECT,TABLE,public.test2,<previously logged>,<previously logged> 2026-07-30 10:12:29.866 CEST [3222097] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,1,1,READ,SELECT,TABLE,public.test4,"SELECT name FROM public.test4",<not logged> 2026-07-30 10:12:29.867 CEST [3222097] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,2,1,WRITE,INSERT,TABLE,public.test4,"INSERT INTO public.test4 (name) VALUES ('test')",<not logged> 2026-07-30 10:12:29.868 CEST [3222097] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,3,1,WRITE,UPDATE,TABLE,public.test4,"UPDATE public.test4 SET id = 1",<not logged> 2026-07-30 10:12:29.868 CEST [3222097] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,4,1,WRITE,UPDATE,TABLE,public.test4,update public.test4 set name = 'foo' where name = 'bar',<not logged> 2026-07-30 10:12:29.870 CEST [3222097] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,5,1,WRITE,INSERT,TABLE,public.test5,"INSERT INTO public.test5 (col1, col2) VALUES (1, 'bar') RETURNING col2",<not logged> 2026-07-30 10:12:29.871 CEST [3222097] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,6,1,WRITE,UPDATE,TABLE,public.test5,"UPDATE public.test5 SET col1 = 2 RETURNING col2",<not logged> 2026-07-30 10:12:29.871 CEST [3222097] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,7,1,WRITE,UPDATE,TABLE,public.test5,"UPDATE public.test5 SET col2 = 'baz' RETURNING col2",<not logged> 2026-07-30 10:12:29.871 CEST [3222097] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,8,1,WRITE,UPDATE,TABLE,public.test5,"UPDATE public.test5 SET col1 = 3 RETURNING old.col2, new.col2",<not logged> 2026-07-30 10:12:29.881 CEST [3222099] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,1,1,WRITE,INSERT,TABLE,public.test4,"PREPARE testinsert(int, text) AS INSERT INTO test4 VALUES($1, $2)","1,<long param suppressed>" 2026-07-30 10:12:29.892 CEST [3222101] regress_user2@contrib_regression WARNING: AUDIT: OBJECT,1,1,WRITE,INSERT,TABLE,public.test4,"PREPARE testinsert(int, text) AS INSERT INTO test4 VALUES($1, $2)","2,*******************************************************" 2026-07-30 10:12:29.972 CEST [3222111] myon@contrib_regression ERROR: schema "bogus" does not exist at character 14 2026-07-30 10:12:29.972 CEST [3222111] myon@contrib_regression QUERY: CREATE TABLE bogus.test_block ( id INT ) 2026-07-30 10:12:29.972 CEST [3222111] myon@contrib_regression CONTEXT: PL/pgSQL function inline_code_block line 3 at SQL statement 2026-07-30 10:12:29.972 CEST [3222111] myon@contrib_regression STATEMENT: DO $$ BEGIN CREATE TABLE bogus.test_block ( id INT ); END $$; 2026-07-30 10:12:30.020 CEST [3222042] LOG: checkpoint starting: fast force wait 2026-07-30 10:12:30.026 CEST [3222042] LOG: checkpoint complete: fast force wait: wrote 1016 buffers (6.2%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 1 recycled; write=0.006 s, sync=0.001 s, total=0.007 s; sync files=0, longest=0.000 s, average=0.000 s; distance=9437 kB, estimate=9437 kB; lsn=0/020F8F38, redo lsn=0/020F8ED8 2026-07-30 10:12:30.093 CEST [3222112] myon@contrib_regression ERROR: schema "bogus" does not exist at character 14 2026-07-30 10:12:30.093 CEST [3222112] myon@contrib_regression QUERY: CREATE TABLE bogus.test_block ( id INT ) 2026-07-30 10:12:30.093 CEST [3222112] myon@contrib_regression CONTEXT: PL/pgSQL function inline_code_block line 3 at SQL statement 2026-07-30 10:12:30.093 CEST [3222112] myon@contrib_regression STATEMENT: DO $$ BEGIN CREATE TABLE bogus.test_block ( id INT ); END $$; 2026-07-30 10:12:30.114 CEST [3222042] LOG: checkpoint starting: fast force wait 2026-07-30 10:12:30.115 CEST [3222042] LOG: checkpoint complete: fast force wait: wrote 118 buffers (0.7%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.002 s; sync files=0, longest=0.000 s, average=0.000 s; distance=5375 kB, estimate=9031 kB; lsn=0/02638D48, redo lsn=0/02638CE8 2026-07-30 10:12:30.172 CEST [3222115] myon@contrib_regression WARNING: AUDIT: SESSION,3,1,DDL,CREATE EXTENSION,,,CREATE EXTENSION pg_stat_statements,<not logged> 2026-07-30 10:12:30.186 CEST [3222115] myon@contrib_regression WARNING: AUDIT: SESSION,4,1,DDL,ALTER EXTENSION,,,ALTER EXTENSION pg_stat_statements UPDATE TO '1.13',<not logged> 2026-07-30 10:12:30.187 CEST [3222115] myon@contrib_regression WARNING: AUDIT: SESSION,5,1,DDL,DROP EXTENSION,,,DROP EXTENSION pg_stat_statements,<not logged> Dropping cluster 19/regress ... ### End 19 installcheck (FAILED with exit code 1) ### ``` ^ permalink raw [nested|flat] 6+ messages in thread

* Re: [pgaudit/pgaudit] issue #329: 19beta2: Regression tests fail
@ 2026-07-30 08:58  "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
  4 siblings, 0 replies; 6+ messages in thread

From: dwsteele (@dwsteele) @ 2026-07-30 08:58 UTC (permalink / raw)
  To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>

Hmm, weird. This looks like old code and/or Postgres against new tests, .e.g.
```
Creating new PostgreSQL cluster 18/regress ...
```
Are you sure all these tests are running against PG19?

I just ran against the pgAudit 19beta2 tag and Postgres 19beta2 and it looks good. This is aarch but CI runs x86_64 and that is also green.
```
starting PostgreSQL 19beta2 (Ubuntu 19~beta2-1.pgdg24.04+1) on aarch64-unknown-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0, 64-bit
```

^ permalink  raw  [nested|flat] 6+ messages in thread

* Re: [pgaudit/pgaudit] issue #329: 19beta2: Regression tests fail
@ 2026-07-30 09:14  "df7cb (@df7cb)" <noreply+df7cb@github.com>
  4 siblings, 0 replies; 6+ messages in thread

From: df7cb (@df7cb) @ 2026-07-30 09:14 UTC (permalink / raw)
  To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>

Ah the 18 part was failure on my side, that's interference from having more than one postgresql-xx-pgaudit package installed on that system. At that time I didn't have any clue yet where the bug is so I didn't catch that when dumping the log. Sorry, it's more clear now 😅.

^ permalink  raw  [nested|flat] 6+ messages in thread

* Re: [pgaudit/pgaudit] issue #329: 19beta2: Regression tests fail
@ 2026-07-30 09:44  "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
  4 siblings, 0 replies; 6+ messages in thread

From: dwsteele (@dwsteele) @ 2026-07-30 09:44 UTC (permalink / raw)
  To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>

@dwsteele assigned @dwsteele.

^ permalink  raw  [nested|flat] 6+ messages in thread

* Re: [pgaudit/pgaudit] issue #329: 19beta2: Regression tests fail
@ 2026-07-30 09:45  "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
  4 siblings, 0 replies; 6+ messages in thread

From: dwsteele (@dwsteele) @ 2026-07-30 09:45 UTC (permalink / raw)
  To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>

@dwsteele applied label "enhancement".

^ permalink  raw  [nested|flat] 6+ messages in thread

* Re: [pgaudit/pgaudit] issue #329: 19beta2: Regression tests fail
@ 2026-07-30 12:50  "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
  4 siblings, 0 replies; 6+ messages in thread

From: dwsteele (@dwsteele) @ 2026-07-30 12:50 UTC (permalink / raw)
  To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>

@dwsteele closed this.

^ permalink  raw  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2026-07-30 12:50 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-07-30 08:18 [pgaudit/pgaudit] issue #329: 19beta2: Regression tests fail "df7cb (@df7cb)" <noreply+df7cb@github.com>
2026-07-30 08:58 ` "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
2026-07-30 09:14 ` "df7cb (@df7cb)" <noreply+df7cb@github.com>
2026-07-30 09:44 ` "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
2026-07-30 09:45 ` "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
2026-07-30 12:50 ` "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox