Yoann Rodière (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%...
) *commented* on HSEARCH-4684 (
https://hibernate.atlassian.net/browse/HSEARCH-4684?atlOrigin=eyJpIjoiZmQ...
)
Re: Fix tests starting before postgresql/cockroachdb containers are ready on CI (
https://hibernate.atlassian.net/browse/HSEARCH-4684?atlOrigin=eyJpIjoiZmQ...
)
Weirdly, it seems postgres will display “database system is ready to accept connections“
in logs twice on startup:
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /var/lib/postgresql/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg_ctl -D /var/lib/postgresql/data -l logfile start
waiting for server to start....2022-08-25 16:50:05.411 UTC [47] LOG: starting PostgreSQL
13.1 (Debian 13.1-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6)
8.3.0, 64-bit
2022-08-25 16:50:05.422 UTC [47] LOG: listening on Unix socket
"/var/run/postgresql/.s.PGSQL.5432"
2022-08-25 16:50:05.443 UTC [48] LOG: database system was shut down at 2022-08-25
16:50:05 UTC
2022-08-25 16:50:05.454 UTC [47] LOG: database system is ready to accept connections
done
server started
CREATE DATABASE
/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
2022-08-25 16:50:05.824 UTC [47] LOG: received fast shutdown request
waiting for server to shut down....2022-08-25 16:50:05.831 UTC [47] LOG: aborting any
active transactions
2022-08-25 16:50:05.835 UTC [47] LOG: background worker "logical replication
launcher" (PID 54) exited with exit code 1
2022-08-25 16:50:05.836 UTC [49] LOG: shutting down
2022-08-25 16:50:05.886 UTC [47] LOG: database system is shut down
done
server stopped
PostgreSQL init process complete; ready for start up.
2022-08-25 16:50:05.976 UTC [1] LOG: starting PostgreSQL 13.1 (Debian 13.1-1.pgdg100+1)
on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
2022-08-25 16:50:05.977 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port
5432
2022-08-25 16:50:05.977 UTC [1] LOG: listening on IPv6 address "::", port 5432
2022-08-25 16:50:05.990 UTC [1] LOG: listening on Unix socket
"/var/run/postgresql/.s.PGSQL.5432"
2022-08-25 16:50:06.008 UTC [75] LOG: database system was shut down at 2022-08-25
16:50:05 UTC
2022-08-25 16:50:06.022 UTC [1] LOG: database system is ready to accept connections
Since it will restart before the first and second time it logs that sentence, we can’t
really rely on logs to determine if postgres is ready…
(
https://hibernate.atlassian.net/browse/HSEARCH-4684#add-comment?atlOrigin...
) Add Comment (
https://hibernate.atlassian.net/browse/HSEARCH-4684#add-comment?atlOrigin...
)
Get Jira notifications on your phone! Download the Jira Cloud app for Android (
https://play.google.com/store/apps/details?id=com.atlassian.android.jira....
) or iOS (
https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em...
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100206- sha1:9fe2ddf )