container-test-run-service-postgresql
default.checks.aarch64-linux.postgresql
· build #393
· 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 # [6018405.493965] machine systemd-journald[69]: Journal started21machine # [6018405.494021] machine systemd-journald[69]: Runtime Journal (/run/log/journal/b674bebdc1af4b61b3a9e077870d6aeb) is 8M, max 2.5G, 2.4G free.22machine # [6018405.498387] machine systemd[1]: Starting Flush Journal to Persistent Storage...23machine # [6018405.499175] machine systemd[1]: Starting Network Name Resolution...24machine # [6018405.499869] machine systemd[1]: Starting Create Static Device Nodes in /dev...25machine # [6018405.509827] machine systemd-journald[69]: Time spent on flushing to /var/log/journal/b674bebdc1af4b61b3a9e077870d6aeb is 1.373ms for 5 entries.26machine # [6018405.509827] machine systemd-journald[69]: System Journal (/var/log/journal/b674bebdc1af4b61b3a9e077870d6aeb) is 8M, max 4G, 3.9G free.27machine # [6018405.513827] machine systemd[1]: Finished Create Static Device Nodes in /dev.28machine # [6018405.514039] machine systemd[1]: Reached target Preparation for Local File Systems.29machine # [6018405.514126] machine systemd[1]: Reached target Local File Systems.30machine # [6018405.514873] machine systemd[1]: Listening on Boot Loader Control Service Socket.31machine # [6018405.514915] machine systemd[1]: Update Boot Loader Random Seed skipped, unmet condition check ConditionVirtualization=!container32machine # [6018405.515989] machine systemd[1]: Starting Save Transient machine-id to Disk...33machine # [6018405.516034] machine systemd[1]: Rule-based Manager for Device Events and Files skipped, unmet condition check ConditionPathIsReadWrite=/sys34machine # [6018405.585317] machine systemd[1]: Finished Flush Journal to Persistent Storage.35machine # [6018405.586491] machine systemd[1]: Starting Create System Files and Directories...36machine # [6018405.602886] machine systemd[1]: Finished Save Transient machine-id to Disk.37machine # [6018405.604192] machine systemd-tmpfiles[147]: Cannot set file attributes for '/var/empty', value=0x00000010, mask=0x00000010, ignoring: Operation not permitted38machine # [6018405.604404] machine systemd-tmpfiles[147]: fchmod() of /var/log/journal failed: Operation not permitted39machine # [6018405.604538] machine systemd-tmpfiles[147]: fchmod() of /var/log/journal/b674bebdc1af4b61b3a9e077870d6aeb failed: Operation not permitted40machine # [6018405.604745] machine systemd-tmpfiles[147]: fchmod() of /run/log/journal failed: Operation not permitted41machine # [6018405.606158] machine systemd[1]: Finished Create System Files and Directories.42machine # [6018405.607215] machine systemd[1]: Starting Rebuild Journal Catalog...43machine # [6018405.608039] machine systemd[1]: Starting Record System Boot/Shutdown in UTMP...44machine # [6018405.625678] machine systemd[1]: Finished Record System Boot/Shutdown in UTMP.45machine # [6018405.632130] machine systemd[1]: Finished Rebuild Journal Catalog.46machine # [6018405.633787] machine systemd[1]: Starting Update is Completed...47machine # [6018405.637129] machine systemd[1]: Finished Firewall.48machine # [6018405.637395] machine systemd[1]: Reached target Preparation for Network.49machine # [6018405.637821] machine systemd[1]: Listening on Network Management Resolve Hook Socket.50machine # [6018405.639715] machine systemd[1]: Starting Network Management...51machine # [6018405.644338] machine systemd[1]: Finished Update is Completed.52machine # [6018406.005135] machine systemd-networkd[182]: Failed to increase receive buffer size for general netlink socket, ignoring: Operation not permitted53machine # [6018406.005227] machine systemd-networkd[182]: Failed to increase receive buffer size for nftables netlink socket, ignoring: Operation not permitted54machine # [6018406.011553] machine systemd-networkd[182]: /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 # [6018406.011729] machine systemd-networkd[182]: /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 # [6018406.011891] machine systemd-networkd[182]: lo: Link UP57machine # [6018406.011900] machine systemd-networkd[182]: lo: Gained carrier58machine # [6018406.012253] machine systemd-networkd[182]: eth1: Configuring with /etc/systemd/network/40-eth1.network.59machine # [6018406.012920] machine systemd-networkd[182]: eth1: Link UP60machine # [6018406.013751] machine systemd-networkd[182]: eth1: Gained carrier61machine # [6018406.013761] machine systemd[1]: Started Network Management.62machine # [6018406.014894] machine systemd[1]: Starting Enable Persistent Storage in systemd-networkd...63machine # [6018406.073424] machine systemd[1]: Finished Enable Persistent Storage in systemd-networkd.64machine # [6018406.109285] machine systemd-resolved[92]: Positive Trust Anchors:65machine # [6018406.109298] machine systemd-resolved[92]: . IN DS 20326 8 2 e06d44b80b8f1d39a95c0b0d7c65d08458e880409bbc683457104237c7f8ec8d66machine # [6018406.109301] machine systemd-resolved[92]: . IN DS 38696 8 2 683d2d0acb8c9b712a1948b27f741219298d0a450d612c483af444a4c0fb2b1667machine # [6018406.109337] machine systemd-resolved[92]: 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 # [6018406.131698] machine systemd-resolved[92]: Using system hostname 'machine'.69machine # [6018406.215181] machine systemd[1]: Started Network Name Resolution.70machine # [6018406.215271] machine systemd[1]: Reached target Network.71machine # [6018406.215326] machine systemd[1]: Reached target System Initialization.72machine # [6018406.215371] machine systemd[1]: Discard unused filesystem blocks once a week skipped, unmet condition check ConditionVirtualization=!container73machine # [6018406.215397] machine systemd[1]: Started Daily Cleanup of Temporary Directories.74machine # [6018406.215411] machine systemd[1]: Reached target Timer Units.75machine # [6018406.215524] machine systemd[1]: Listening on D-Bus System Message Bus Socket.76machine # [6018406.215632] machine systemd[1]: Listening on Nix Daemon Socket.77machine # [6018406.215729] machine systemd[1]: Listening on Virtual Machine and Container Registration Service Socket.78machine # [6018406.215748] machine systemd[1]: Reached target Socket Units.79machine # [6018406.215792] machine systemd[1]: Reached target Basic System.80machine # [6018406.217057] machine systemd[1]: Starting Import lastlog data into lastlog2 database...81machine # [6018406.217974] machine systemd[1]: Starting Name Service Cache Daemon (nsncd)...82machine # [6018406.218956] machine systemd[1]: Starting PostgreSQL Server...83machine # [6018406.220221] machine systemd[1]: Starting D-Bus System Message Bus...84machine # [6018406.268102] machine systemd[1]: Finished Import lastlog data into lastlog2 database.85machine # [6018406.346702] machine systemd[1]: Started Name Service Cache Daemon (nsncd).86machine # [6018406.346769] machine systemd[1]: Reached target Host and Network Name Lookups.87machine # [6018406.347190] machine nsncd[189]: Aug 17 15:10:32.400 INFO started, config: Config { ignored_request_types: {}, worker_count: 8, handoff_timeout: 10s }, path: "/var/run/nscd/socket"88machine # [6018406.346818] machine systemd[1]: Reached target User and Group Name Lookups.89machine # [6018406.348195] machine systemd[1]: Starting User Login Management...90machine # [6018406.348948] machine systemd[1]: Starting Permit User Sessions...91machine # [6018406.408362] machine systemd[1]: Finished Permit User Sessions.92machine # [6018406.409814] machine systemd[1]: Started Console Getty.93machine # [6018406.409863] machine systemd[1]: Getty on tty1 skipped, unmet condition check ConditionPathExists=/dev/tty094machine # [6018406.409881] machine systemd[1]: Reached target Login Prompts.95machine # [6018406.445325] machine dbus-broker-launch[191]: Looking up NSS user entry for 'systemd-timesync'...96machine # [6018406.446887] machine dbus-broker-launch[191]: NSS returned no entry for 'systemd-timesync'97machine # [6018406.446887] machine dbus-broker-launch[191]: Invalid user-name in /nix/store/pwwdj01zxlmwb35dfy12civnlysbispm-system-path/share/dbus-1/system.d/org.freedesktop.timesync1.conf +16: user="systemd-timesync"98machine # [6018406.447356] machine systemd[1]: Started D-Bus System Message Bus.99machine # [6018406.456964] machine dbus-broker-launch[191]: Ready100machine # [6018406.486164] machine systemd[1]: etc-machine\x2did.mount: Deactivated successfully.101machine # [6018406.843976] machine postgresql-pre-start[221]: The files belonging to this database system will be owned by user "postgres".102machine # [6018406.843976] machine postgresql-pre-start[221]: This user must also own the server process.103machine # [6018406.844411] machine postgresql-pre-start[221]: The database cluster will be initialized with locale "en_US.UTF-8".104machine # [6018406.844411] machine postgresql-pre-start[221]: The default database encoding has accordingly been set to "UTF8".105machine # [6018406.844411] machine postgresql-pre-start[221]: The default text search configuration will be set to "english".106machine # [6018406.844411] machine postgresql-pre-start[221]: Data page checksums are enabled.107machine # [6018406.844411] machine postgresql-pre-start[221]: fixing permissions on existing directory /var/lib/postgresql/18 ... ok108machine # [6018406.844680] machine postgresql-pre-start[221]: creating subdirectories ... ok109machine # [6018406.844680] machine postgresql-pre-start[221]: selecting dynamic shared memory implementation ... posix110machine # [6018406.864372] machine postgresql-pre-start[221]: selecting default "max_connections" ... 100111machine # [6018406.896080] machine postgresql-pre-start[221]: selecting default "shared_buffers" ... 128MB112machine # [6018406.932118] machine systemd-logind[203]: New seat seat0.113machine # [6018406.932330] machine systemd[1]: Started User Login Management.114machine # [6018406.933558] machine systemd[1]: Starting linger-users.service...115machine # [6018407.013029] machine systemd[1]: linger-users.service: Deactivated successfully.116machine # [6018407.013193] machine systemd[1]: Finished linger-users.service.117machine # [6018407.182900] machine postgresql-pre-start[221]: selecting default time zone ... UTC118machine # [6018407.183605] machine postgresql-pre-start[221]: creating configuration files ... ok119machine # [6018407.309261] machine postgresql-pre-start[221]: running bootstrap script ... ok120machine # [6018407.695266] machine postgresql-pre-start[221]: performing post-bootstrap initialization ... ok121machine # [6018407.812204] machine systemd-networkd[182]: eth1: Gained IPv6LL122machine # [6018407.948720] machine postgresql-pre-start[221]: syncing data to disk ... ok123machine # [6018407.948720] machine postgresql-pre-start[221]: initdb: warning: enabling "trust" authentication for local connections124machine # [6018407.948720] 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 # [6018407.948720] machine postgresql-pre-start[221]: Success. You can now start the database server using:126machine # [6018407.948720] machine postgresql-pre-start[221]: pg_ctl -D /var/lib/postgresql/18 -l logfile start127machine # [6018408.485155] machine postgres[237]: [237] LOG: starting PostgreSQL 18.6 on aarch64-unknown-linux-gnu, compiled by clang version 21.1.8, 64-bit128machine # [6018408.486810] machine postgres[237]: [237] LOG: listening on IPv6 address "::1", port 5432129machine # [6018408.486844] machine postgres[237]: [237] LOG: listening on IPv4 address "127.0.0.1", port 5432130machine # [6018408.489383] machine postgres[237]: [237] LOG: listening on Unix socket "/run/postgresql/.s.PGSQL.5432"131machine # [6018408.494507] machine postgres[246]: [246] LOG: database system was shut down at 2026-08-17 15:10:33 GMT132machine # [6018408.497641] machine postgres[237]: [237] LOG: database system is ready to accept connections133machine: (finished: waiting for unit postgresql, in 4.65 seconds)134machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -c 'CREATE TABLE test (id serial PRIMARY KEY);' test135machine # [6018408.963573] machine postgresql-post-start[259]: CREATE ROLE136machine # [6018409.044502] machine postgresql-post-start[264]: CREATE DATABASE137machine # [6018409.047908] machine systemd[1]: Started PostgreSQL Server.138machine # [6018409.049170] machine systemd[1]: Starting PostgreSQL Setup Scripts...139machine # [6018409.070373] machine systemd[1]: Finished PostgreSQL Setup Scripts.140machine # [6018409.070771] machine systemd[1]: Reached target PostgreSQL.141machine # [6018409.070891] machine systemd[1]: Reached target Multi-User System.142machine # [6018409.071559] machine systemd[1]: Startup finished in 3.940s.143machine: (finished: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -c 'CREATE TABLE test (id serial PRIMARY KEY);' test, in 0.02 seconds)144machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'INSERT INTO test DEFAULT VALUES;'145machine: (finished: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'INSERT INTO test DEFAULT VALUES;', in 0.02 seconds)146machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'SELECT * FROM test;'147machine: (finished: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'SELECT * FROM test;', in 0.02 seconds)148(finished: run the VM test script, in 4.71 seconds)149test script finished in 4.91s150cleanup151kill NspawnMachine (pid 51)152machine # [6018409.284223] machine runuser[273]: pam_unix(runuser:session): session opened for user postgres(uid=71) by (uid=0)153machine # [6018409.297555] machine runuser[273]: pam_unix(runuser:session): session closed for user postgres154machine # [6018409.305345] machine runuser[276]: pam_unix(runuser:session): session opened for user postgres(uid=71) by (uid=0)155machine # [6018409.314087] machine runuser[276]: pam_unix(runuser:session): session closed for user postgres156machine # [6018409.323922] machine runuser[279]: pam_unix(runuser:session): session opened for user postgres(uid=71) by (uid=0)157machine # [6018409.332622] machine runuser[279]: pam_unix(runuser:session): session closed for user postgres158Container machine terminated by signal KILL.159(finished: cleanup, in 0.26 seconds)