Skip to content

Repair Regression test action and add tests #14

@susan-pgedge

Description

@susan-pgedge

After building the lolor extension and adding it to the shared_preload_libraries parameter, the server won't start; it was running before the extension was added, so I may have overlooked something when building the extension.

Could you please see if you can debug this Action and then add some test cases:

An example of the error follows:

PostgreSQL is not ready. Starting it now...
waiting for server to start....2025-03-05 14:23:42.023 UTC [10753] LOG: starting PostgreSQL 16.8 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
2025-03-05 14:23:42.024 UTC [10753] LOG: listening on IPv6 address "::1", port 5416
2025-03-05 14:23:42.024 UTC [10753] LOG: listening on IPv4 address "127.0.0.1", port 5416
2025-03-05 14:23:42.025 UTC [10753] LOG: listening on Unix socket "/tmp/.s.PGSQL.5416"
2025-03-05 14:23:42.027 UTC [10756] LOG: database system was shut down at 2025-03-05 14:23:40 UTC
2025-03-05 14:23:42.029 UTC [10753] LOG: database system is ready to accept connections
done
server started
PostgreSQL is running. Listing available extensions:
name | default_version | installed_version | comment
---------+-----------------+-------------------+-----------------------------------------------
plpgsql | 1.0 | 1.0 | PL/pgSQL procedural language
lolor | 1.0 | | Large Objects support for logical replication
(2 rows)

Adding lolor to shared_preload_libraries...
ALTER SYSTEM
Restarting PostgreSQL to apply changes...
waiting for server to shut down...2025-03-05 14:23:47.126 UTC [10753] LOG: received fast shutdown request
.2025-03-05 14:23:47.126 UTC [10753] LOG: aborting any active transactions
2025-03-05 14:23:47.126 UTC [10753] LOG: background worker "logical replication launcher" (PID 10759) exited with exit code 1
2025-03-05 14:23:47.127 UTC [10754] LOG: shutting down
2025-03-05 14:23:47.127 UTC [10754] LOG: checkpoint starting: shutdown immediate
2025-03-05 14:23:47.130 UTC [10754] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.004 s; sync files=2, longest=0.001 s, average=0.001 s; distance=0 kB, estimate=0 kB; lsn=0/147FC20, redo lsn=0/147FC20
2025-03-05 14:23:47.134 UTC [10753] LOG: database system is shut down
done
server stopped
pg_ctl: could not start server
Examine the log output.
waiting for server to start.... stopped waiting
PostgreSQL failed to restart! Checking logs:
cat: /var/lib/postgresql/data-16/postgresql.log: No such file or directory
Error: Process completed with exit code 1.

Metadata

Metadata

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions