container-test-run-service-postgresql
default.checks.aarch64-linux.postgresql
· build #347
· raw
1Machine state will be reset. To keep it, pass --keep-machine-state2start all VLans3(finished: start all VLans, in 0.00 seconds)45Test will time out and terminate in 3600.0 seconds6run the VM test script7additionally exposed symbols:8 machine,9 vlan1,10 start_all, test_script, machines, machines_qemu, machines_nspawn, vlans, driver, log, os, create_machine, subtest, run_tests, join_all, retry, serial_stdout_off, serial_stdout_on, polling_condition, BaseMachine, QemuMachine, NspawnMachine, t, debug, dump_machine_ssh11start all VMs12machine: systemd-nspawn running (pid 51)13machine: Waiting for journal at /build/vm-state-machine/var/log/journal...14(finished: start all VMs, in 0.00 seconds)15machine: waiting for unit postgresql16nixos-nspawn(machine): TAP vde-tap1 not found; container will be isolated from VDE17nixos-nspawn(machine): A common reason for this is that /dev/net is not available in the Nix sandbox. Try adding /dev/net to extra-sandbox-paths.18Note: in a future version of systemd-nspawn the default set of permitted socket address families will be restricted to AF_INET, AF_INET6 and AF_UNIX. Use --restrict-address-families= to configure the set of permitted socket address families, or set RestrictAddressFamilies= in a .nspawn file.19░ Spawning container machine on /build/vm-state-machine.20machine # [5660961.590416] machine systemd-journald[69]: Journal started21machine # [5660961.590469] machine systemd-journald[69]: Runtime Journal (/run/log/journal/87f196e62f9845409b9a71df992d141b) is 8M, max 2.5G, 2.4G free.22machine # [5660961.597429] machine systemd[1]: Starting Flush Journal to Persistent Storage...23machine # [5660961.598346] machine systemd[1]: Starting Network Name Resolution...24machine # [5660961.598983] machine systemd[1]: Starting Create Static Device Nodes in /dev...25machine # [5660961.607994] machine systemd-journald[69]: Time spent on flushing to /var/log/journal/87f196e62f9845409b9a71df992d141b is 1.468ms for 5 entries.26machine # [5660961.607994] machine systemd-journald[69]: System Journal (/var/log/journal/87f196e62f9845409b9a71df992d141b) is 8M, max 4G, 3.9G free.27machine # [5660961.614474] machine systemd[1]: Finished Create Static Device Nodes in /dev.28machine # [5660961.614664] machine systemd[1]: Reached target Preparation for Local File Systems.29machine # [5660961.614743] machine systemd[1]: Reached target Local File Systems.30machine # [5660961.615424] machine systemd[1]: Listening on Boot Loader Control Service Socket.31machine # [5660961.615461] machine systemd[1]: Update Boot Loader Random Seed skipped, unmet condition check ConditionVirtualization=!container32machine # [5660961.616220] machine systemd[1]: Starting Save Transient machine-id to Disk...33machine # [5660961.616254] machine systemd[1]: Rule-based Manager for Device Events and Files skipped, unmet condition check ConditionPathIsReadWrite=/sys34machine # [5660961.649913] machine systemd[1]: Finished Flush Journal to Persistent Storage.35machine # [5660961.650991] machine systemd[1]: Starting Create System Files and Directories...36machine # [5660961.669327] machine systemd-tmpfiles[122]: Cannot set file attributes for '/var/empty', value=0x00000010, mask=0x00000010, ignoring: Operation not permitted37machine # [5660961.669532] machine systemd-tmpfiles[122]: fchmod() of /var/log/journal failed: Operation not permitted38machine # [5660961.669675] machine systemd-tmpfiles[122]: fchmod() of /var/log/journal/87f196e62f9845409b9a71df992d141b failed: Operation not permitted39machine # [5660961.669894] machine systemd-tmpfiles[122]: fchmod() of /run/log/journal failed: Operation not permitted40machine # [5660961.671689] machine systemd[1]: Finished Create System Files and Directories.41machine # [5660961.672904] machine systemd[1]: Starting Rebuild Journal Catalog...42machine # [5660961.673723] machine systemd[1]: Starting Record System Boot/Shutdown in UTMP...43machine # [5660961.688658] machine systemd[1]: Finished Record System Boot/Shutdown in UTMP.44machine # [5660961.695591] machine systemd[1]: Finished Rebuild Journal Catalog.45machine # [5660961.697223] machine systemd[1]: Starting Update is Completed...46machine # [5660961.707393] machine systemd[1]: Finished Update is Completed.47machine # [5660961.736073] machine systemd[1]: Finished Save Transient machine-id to Disk.48machine # [5660961.751888] machine systemd[1]: Finished Firewall.49machine # [5660961.752050] machine systemd[1]: Reached target Preparation for Network.50machine # [5660961.752271] machine systemd[1]: Listening on Network Management Resolve Hook Socket.51machine # [5660961.753427] machine systemd[1]: Starting Network Management...52machine # [5660962.100772] machine systemd-networkd[183]: Failed to increase receive buffer size for general netlink socket, ignoring: Operation not permitted53machine # [5660962.100859] machine systemd-networkd[183]: Failed to increase receive buffer size for nftables netlink socket, ignoring: Operation not permitted54machine # [5660962.109438] machine systemd-networkd[183]: /etc/systemd/network/99-ethernet-default-dhcp.network: No valid settings found in the [Match] section, ignoring file. To match all interfaces, add Name=* in the [Match] section.55machine # [5660962.109601] machine systemd-networkd[183]: /etc/systemd/network/99-wireless-client-dhcp.network: No valid settings found in the [Match] section, ignoring file. To match all interfaces, add Name=* in the [Match] section.56machine # [5660962.109755] machine systemd-networkd[183]: lo: Link UP57machine # [5660962.109759] machine systemd-networkd[183]: lo: Gained carrier58machine # [5660962.109955] machine systemd-networkd[183]: eth1: Configuring with /etc/systemd/network/40-eth1.network.59machine # [5660962.110327] machine systemd[1]: Started Network Management.60machine # [5660962.110409] machine systemd-networkd[183]: eth1: Link UP61machine # [5660962.110617] machine systemd-networkd[183]: eth1: Gained carrier62machine # [5660962.111395] machine systemd[1]: Starting Enable Persistent Storage in systemd-networkd...63machine # [5660962.142822] machine systemd[1]: Finished Enable Persistent Storage in systemd-networkd.64machine # [5660962.203052] machine systemd-resolved[88]: Positive Trust Anchors:65machine # [5660962.203064] machine systemd-resolved[88]: . IN DS 20326 8 2 e06d44b80b8f1d39a95c0b0d7c65d08458e880409bbc683457104237c7f8ec8d66machine # [5660962.203066] machine systemd-resolved[88]: . IN DS 38696 8 2 683d2d0acb8c9b712a1948b27f741219298d0a450d612c483af444a4c0fb2b1667machine # [5660962.203101] machine systemd-resolved[88]: Negative trust anchors: home.arpa 10.in-addr.arpa 16.172.in-addr.arpa 17.172.in-addr.arpa 18.172.in-addr.arpa 19.172.in-addr.arpa 20.172.in-addr.arpa 21.172.in-addr.arpa 22.172.in-addr.arpa 23.172.in-addr.arpa 24.172.in-addr.arpa 25.172.in-addr.arpa 26.172.in-addr.arpa 27.172.in-addr.arpa 28.172.in-addr.arpa 29.172.in-addr.arpa 30.172.in-addr.arpa 31.172.in-addr.arpa 170.0.0.192.in-addr.arpa 171.0.0.192.in-addr.arpa 168.192.in-addr.arpa d.f.ip6.arpa ipv4only.arpa resolver.arpa corp home internal intranet lan local private test68machine # [5660962.225138] machine systemd-resolved[88]: Using system hostname 'machine'.69machine # [5660962.226501] machine systemd[1]: Started Network Name Resolution.70machine # [5660962.226580] machine systemd[1]: Reached target Network.71machine # [5660962.226653] machine systemd[1]: Reached target System Initialization.72machine # [5660962.226708] machine systemd[1]: Discard unused filesystem blocks once a week skipped, unmet condition check ConditionVirtualization=!container73machine # [5660962.226735] machine systemd[1]: Started Daily Cleanup of Temporary Directories.74machine # [5660962.226753] machine systemd[1]: Reached target Timer Units.75machine # [5660962.226883] machine systemd[1]: Listening on D-Bus System Message Bus Socket.76machine # [5660962.227009] machine systemd[1]: Listening on Nix Daemon Socket.77machine # [5660962.227123] machine systemd[1]: Listening on Virtual Machine and Container Registration Service Socket.78machine # [5660962.227144] machine systemd[1]: Reached target Socket Units.79machine # [5660962.227185] machine systemd[1]: Reached target Basic System.80machine # [5660962.228955] machine systemd[1]: Starting Import lastlog data into lastlog2 database...81machine # [5660962.229766] machine systemd[1]: Starting Name Service Cache Daemon (nsncd)...82machine # [5660962.230670] machine systemd[1]: Starting PostgreSQL Server...83machine # [5660962.231982] machine systemd[1]: Starting D-Bus System Message Bus...84machine # [5660962.248456] machine systemd[1]: Finished Import lastlog data into lastlog2 database.85machine # [5660962.318490] machine nsncd[189]: Aug 13 11:53:08.371 INFO started, config: Config { ignored_request_types: {}, worker_count: 8, handoff_timeout: 10s }, path: "/var/run/nscd/socket"86machine # [5660962.318634] machine systemd[1]: Started Name Service Cache Daemon (nsncd).87machine # [5660962.318728] machine systemd[1]: Reached target Host and Network Name Lookups.88machine # [5660962.318829] machine systemd[1]: Reached target User and Group Name Lookups.89machine # [5660962.321028] machine systemd[1]: Starting User Login Management...90machine # [5660962.322295] machine systemd[1]: Starting Permit User Sessions...91machine # [5660962.334512] machine systemd[1]: Finished Permit User Sessions.92machine # [5660962.335758] machine systemd[1]: Started Console Getty.93machine # [5660962.335807] machine systemd[1]: Getty on tty1 skipped, unmet condition check ConditionPathExists=/dev/tty094machine # [5660962.335827] machine systemd[1]: Reached target Login Prompts.95machine # [5660962.395243] machine dbus-broker-launch[191]: Looking up NSS user entry for 'systemd-timesync'...96machine # [5660962.396773] machine dbus-broker-launch[191]: NSS returned no entry for 'systemd-timesync'97machine # [5660962.396773] machine dbus-broker-launch[191]: Invalid user-name in /nix/store/fwcs1dq4ph393ig9dj81f16043q8pcc9-system-path/share/dbus-1/system.d/org.freedesktop.timesync1.conf +16: user="systemd-timesync"98machine # [5660962.397262] machine systemd[1]: Started D-Bus System Message Bus.99machine # [5660962.405851] machine dbus-broker-launch[191]: Ready100machine # [5660962.585831] machine systemd[1]: etc-machine\x2did.mount: Deactivated successfully.101machine # [5660962.732975] machine postgresql-pre-start[221]: The files belonging to this database system will be owned by user "postgres".102machine # [5660962.732975] machine postgresql-pre-start[221]: This user must also own the server process.103machine # [5660962.733588] machine postgresql-pre-start[221]: The database cluster will be initialized with locale "en_US.UTF-8".104machine # [5660962.733588] machine postgresql-pre-start[221]: The default database encoding has accordingly been set to "UTF8".105machine # [5660962.733588] machine postgresql-pre-start[221]: The default text search configuration will be set to "english".106machine # [5660962.733588] machine postgresql-pre-start[221]: Data page checksums are enabled.107machine # [5660962.733588] machine postgresql-pre-start[221]: fixing permissions on existing directory /var/lib/postgresql/18 ... ok108machine # [5660962.733842] machine postgresql-pre-start[221]: creating subdirectories ... ok109machine # [5660962.733842] machine postgresql-pre-start[221]: selecting dynamic shared memory implementation ... posix110machine # [5660962.759943] machine postgresql-pre-start[221]: selecting default "max_connections" ... 100111machine # [5660962.767956] machine systemd-logind[209]: New seat seat0.112machine # [5660962.768178] machine systemd[1]: Started User Login Management.113machine # [5660962.784286] machine postgresql-pre-start[221]: selecting default "shared_buffers" ... 128MB114machine # [5660962.797486] machine systemd[1]: Starting linger-users.service...115machine # [5660962.811417] machine systemd[1]: linger-users.service: Deactivated successfully.116machine # [5660962.811689] machine systemd[1]: Finished linger-users.service.117machine # [5660963.056732] machine postgresql-pre-start[221]: selecting default time zone ... UTC118machine # [5660963.057755] machine postgresql-pre-start[221]: creating configuration files ... ok119machine # [5660963.168197] machine systemd-networkd[183]: eth1: Gained IPv6LL120machine # [5660963.192509] machine postgresql-pre-start[221]: running bootstrap script ... ok121machine # [5660963.578982] machine postgresql-pre-start[221]: performing post-bootstrap initialization ... ok122machine # [5660963.710812] machine postgresql-pre-start[221]: syncing data to disk ... ok123machine # [5660963.710812] machine postgresql-pre-start[221]: initdb: warning: enabling "trust" authentication for local connections124machine # [5660963.710812] machine postgresql-pre-start[221]: initdb: hint: 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.125machine # [5660963.710812] machine postgresql-pre-start[221]: Success. You can now start the database server using:126machine # [5660963.710812] machine postgresql-pre-start[221]: pg_ctl -D /var/lib/postgresql/18 -l logfile start127machine # [5660964.208902] machine postgres[237]: [237] LOG: starting PostgreSQL 18.4 on aarch64-unknown-linux-gnu, compiled by clang version 21.1.8, 64-bit128machine # [5660964.211683] machine postgres[237]: [237] LOG: listening on IPv6 address "::1", port 5432129machine # [5660964.211683] machine postgres[237]: [237] LOG: listening on IPv4 address "127.0.0.1", port 5432130machine # [5660964.212078] machine postgres[237]: [237] LOG: listening on Unix socket "/run/postgresql/.s.PGSQL.5432"131machine # [5660964.215328] machine postgres[246]: [246] LOG: database system was shut down at 2026-08-13 11:53:09 GMT132machine # [5660964.218934] machine postgres[237]: [237] LOG: database system is ready to accept connections133machine: (finished: waiting for unit postgresql, in 4.15 seconds)134machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -c 'CREATE TABLE test (id serial PRIMARY KEY);' test135machine: (finished: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -c 'CREATE TABLE test (id serial PRIMARY KEY);' test, in 0.03 seconds)136machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'INSERT INTO test DEFAULT VALUES;'137machine: (finished: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'INSERT INTO test DEFAULT VALUES;', in 0.02 seconds)138machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'SELECT * FROM test;'139machine # [5660964.705468] machine postgresql-post-start[259]: CREATE ROLE140machine # [5660964.790300] machine postgresql-post-start[264]: CREATE DATABASE141machine # [5660964.793293] machine systemd[1]: Started PostgreSQL Server.142machine # [5660964.796161] machine systemd[1]: Starting PostgreSQL Setup Scripts...143machine # [5660964.852531] machine systemd[1]: Finished PostgreSQL Setup Scripts.144machine # [5660964.852866] machine systemd[1]: Reached target PostgreSQL.145machine # [5660964.852987] machine systemd[1]: Reached target Multi-User System.146machine # [5660964.853240] machine systemd[1]: Startup finished in 3.688s.147machine # [5660964.905507] machine runuser[273]: pam_unix(runuser:session): session opened for user postgres(uid=71) by (uid=0)148machine # [5660964.921985] machine runuser[273]: pam_unix(runuser:session): session closed for user postgres149machine # [5660964.931083] machine runuser[276]: pam_unix(runuser:session): session opened for user postgres(uid=71) by (uid=0)150machine # [5660964.939449] machine runuser[276]: pam_unix(runuser:session): session closed for user postgres151machine: (finished: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'SELECT * FROM test;', in 0.02 seconds)152machine # [5660964.949309] machine runuser[279]: pam_unix(runuser:session): session opened for user postgres(uid=71) by (uid=0)153(finished: run the VM test script, in 4.22 seconds)154machine # [5660964.958725] machine runuser[279]: pam_unix(runuser:session): session closed for user postgres155test script finished in 4.25s156cleanup157kill NspawnMachine (pid 51)158Container machine terminated by signal KILL.159(finished: cleanup, in 0.21 seconds)