container-test-run-service-postgresql
default.checks.aarch64-linux.postgresql
· build #369
· 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 # [5896953.081786] machine systemd-journald[69]: Journal started21machine # [5896953.081845] machine systemd-journald[69]: Runtime Journal (/run/log/journal/a05d933c9c0b49b7bd0de8ffefc0975f) is 8M, max 2.5G, 2.4G free.22machine # [5896953.087335] machine systemd[1]: Finished Create Static Device Nodes in /dev gracefully.23machine # [5896953.095720] machine systemd[1]: Starting Flush Journal to Persistent Storage...24machine # [5896953.096652] machine systemd[1]: Starting Network Name Resolution...25machine # [5896953.097332] machine systemd[1]: Starting Create Static Device Nodes in /dev...26machine # [5896953.104620] machine systemd-journald[69]: Time spent on flushing to /var/log/journal/a05d933c9c0b49b7bd0de8ffefc0975f is 1.372ms for 6 entries.27machine # [5896953.104620] machine systemd-journald[69]: System Journal (/var/log/journal/a05d933c9c0b49b7bd0de8ffefc0975f) is 8M, max 4G, 3.9G free.28machine # [5896953.110868] machine systemd[1]: Finished Create Static Device Nodes in /dev.29machine # [5896953.111119] machine systemd[1]: Reached target Preparation for Local File Systems.30machine # [5896953.111200] machine systemd[1]: Reached target Local File Systems.31machine # [5896953.111917] machine systemd[1]: Listening on Boot Loader Control Service Socket.32machine # [5896953.111961] machine systemd[1]: Update Boot Loader Random Seed skipped, unmet condition check ConditionVirtualization=!container33machine # [5896953.112986] machine systemd[1]: Starting Save Transient machine-id to Disk...34machine # [5896953.113053] machine systemd[1]: Rule-based Manager for Device Events and Files skipped, unmet condition check ConditionPathIsReadWrite=/sys35machine # [5896953.129917] machine systemd[1]: Finished Flush Journal to Persistent Storage.36machine # [5896953.131381] machine systemd[1]: Starting Create System Files and Directories...37machine # [5896953.146046] machine systemd-tmpfiles[123]: Cannot set file attributes for '/var/empty', value=0x00000010, mask=0x00000010, ignoring: Operation not permitted38machine # [5896953.146206] machine systemd-tmpfiles[123]: fchmod() of /var/log/journal failed: Operation not permitted39machine # [5896953.146314] machine systemd-tmpfiles[123]: fchmod() of /var/log/journal/a05d933c9c0b49b7bd0de8ffefc0975f failed: Operation not permitted40machine # [5896953.146480] machine systemd-tmpfiles[123]: fchmod() of /run/log/journal failed: Operation not permitted41machine # [5896953.147872] machine systemd[1]: Finished Create System Files and Directories.42machine # [5896953.149001] machine systemd[1]: Starting Rebuild Journal Catalog...43machine # [5896953.149731] machine systemd[1]: Starting Record System Boot/Shutdown in UTMP...44machine # [5896953.160577] machine systemd[1]: Finished Record System Boot/Shutdown in UTMP.45machine # [5896953.168079] machine systemd[1]: Finished Rebuild Journal Catalog.46machine # [5896953.169216] machine systemd[1]: Starting Update is Completed...47machine # [5896953.179205] machine systemd[1]: Finished Update is Completed.48machine # [5896953.221039] machine systemd[1]: Finished Firewall.49machine # [5896953.221455] machine systemd[1]: Reached target Preparation for Network.50machine # [5896953.221664] machine systemd[1]: Listening on Network Management Resolve Hook Socket.51machine # [5896953.222645] machine systemd[1]: Starting Network Management...52machine # [5896953.601941] machine systemd-networkd[182]: Failed to increase receive buffer size for general netlink socket, ignoring: Operation not permitted53machine # [5896953.602031] machine systemd-networkd[182]: Failed to increase receive buffer size for nftables netlink socket, ignoring: Operation not permitted54machine # [5896953.614458] 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 # [5896953.614622] 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 # [5896953.614828] machine systemd-networkd[182]: lo: Link UP57machine # [5896953.614833] machine systemd-networkd[182]: lo: Gained carrier58machine # [5896953.615029] machine systemd-networkd[182]: eth1: Configuring with /etc/systemd/network/40-eth1.network.59machine # [5896953.615482] machine systemd-networkd[182]: eth1: Link UP60machine # [5896953.615626] machine systemd[1]: Started Network Management.61machine # [5896953.616829] machine systemd-networkd[182]: eth1: Gained carrier62machine # [5896953.616879] machine systemd[1]: Starting Enable Persistent Storage in systemd-networkd...63machine # [5896953.677995] machine systemd[1]: Finished Enable Persistent Storage in systemd-networkd.64machine # [5896953.760737] machine systemd-resolved[96]: Positive Trust Anchors:65machine # [5896953.760749] machine systemd-resolved[96]: . IN DS 20326 8 2 e06d44b80b8f1d39a95c0b0d7c65d08458e880409bbc683457104237c7f8ec8d66machine # [5896953.760752] machine systemd-resolved[96]: . IN DS 38696 8 2 683d2d0acb8c9b712a1948b27f741219298d0a450d612c483af444a4c0fb2b1667machine # [5896953.760787] machine systemd-resolved[96]: 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 # [5896953.782671] machine systemd-resolved[96]: Using system hostname 'machine'.69machine # [5896953.783978] machine systemd[1]: Started Network Name Resolution.70machine # [5896953.784070] machine systemd[1]: Reached target Network.71machine # [5896953.784138] machine systemd[1]: Reached target System Initialization.72machine # [5896953.784184] machine systemd[1]: Discard unused filesystem blocks once a week skipped, unmet condition check ConditionVirtualization=!container73machine # [5896953.784209] machine systemd[1]: Started Daily Cleanup of Temporary Directories.74machine # [5896953.784225] machine systemd[1]: Reached target Timer Units.75machine # [5896953.784329] machine systemd[1]: Listening on D-Bus System Message Bus Socket.76machine # [5896953.784445] machine systemd[1]: Listening on Nix Daemon Socket.77machine # [5896953.784545] machine systemd[1]: Listening on Virtual Machine and Container Registration Service Socket.78machine # [5896953.784564] machine systemd[1]: Reached target Socket Units.79machine # [5896953.784597] machine systemd[1]: Reached target Basic System.80machine # [5896953.829156] machine systemd[1]: Starting Import lastlog data into lastlog2 database...81machine # [5896953.830488] machine systemd[1]: Starting Name Service Cache Daemon (nsncd)...82machine # [5896953.832288] machine systemd[1]: Starting PostgreSQL Server...83machine # [5896953.834750] machine systemd[1]: Starting D-Bus System Message Bus...84machine # [5896953.849261] machine systemd[1]: Finished Import lastlog data into lastlog2 database.85machine # [5896953.872369] machine systemd[1]: Finished Save Transient machine-id to Disk.86machine # [5896954.052512] machine nsncd[188]: Aug 16 05:26:20.105 INFO started, config: Config { ignored_request_types: {}, worker_count: 8, handoff_timeout: 10s }, path: "/var/run/nscd/socket"87machine # [5896954.052644] machine systemd[1]: Started Name Service Cache Daemon (nsncd).88machine # [5896954.052709] machine systemd[1]: Reached target Host and Network Name Lookups.89machine # [5896954.052768] machine systemd[1]: Reached target User and Group Name Lookups.90machine # [5896954.053877] machine systemd[1]: Starting User Login Management...91machine # [5896954.055225] machine systemd[1]: Starting Permit User Sessions...92machine # [5896954.087040] machine systemd[1]: etc-machine\x2did.mount: Deactivated successfully.93machine # [5896954.088076] machine systemd[1]: Finished Permit User Sessions.94machine # [5896954.089556] machine systemd[1]: Started Console Getty.95machine # [5896954.089598] machine systemd[1]: Getty on tty1 skipped, unmet condition check ConditionPathExists=/dev/tty096machine # [5896954.089616] machine systemd[1]: Reached target Login Prompts.97machine # [5896954.256379] machine dbus-broker-launch[190]: Looking up NSS user entry for 'systemd-timesync'...98machine # [5896954.258171] machine dbus-broker-launch[190]: NSS returned no entry for 'systemd-timesync'99machine # [5896954.258171] machine dbus-broker-launch[190]: Invalid user-name in /nix/store/f8jx3wnrwmr9r8r7xv2sj61k3drc22gy-system-path/share/dbus-1/system.d/org.freedesktop.timesync1.conf +16: user="systemd-timesync"100machine # [5896954.258735] machine systemd[1]: Started D-Bus System Message Bus.101machine # [5896954.266079] machine dbus-broker-launch[190]: Ready102machine # [5896954.807665] machine postgresql-pre-start[221]: The files belonging to this database system will be owned by user "postgres".103machine # [5896954.807665] machine postgresql-pre-start[221]: This user must also own the server process.104machine # [5896954.808113] machine postgresql-pre-start[221]: The database cluster will be initialized with locale "en_US.UTF-8".105machine # [5896954.808113] machine postgresql-pre-start[221]: The default database encoding has accordingly been set to "UTF8".106machine # [5896954.808113] machine postgresql-pre-start[221]: The default text search configuration will be set to "english".107machine # [5896954.808113] machine postgresql-pre-start[221]: Data page checksums are enabled.108machine # [5896954.808113] machine postgresql-pre-start[221]: fixing permissions on existing directory /var/lib/postgresql/18 ... ok109machine # [5896954.808247] machine postgresql-pre-start[221]: creating subdirectories ... ok110machine # [5896954.808333] machine postgresql-pre-start[221]: selecting dynamic shared memory implementation ... posix111machine # [5896954.837726] machine systemd-logind[209]: New seat seat0.112machine # [5896954.837940] machine systemd[1]: Started User Login Management.113machine # [5896954.838146] machine postgresql-pre-start[221]: selecting default "max_connections" ... 100114machine # [5896954.839178] machine systemd[1]: Starting linger-users.service...115machine # [5896954.850312] machine systemd[1]: linger-users.service: Deactivated successfully.116machine # [5896954.850477] machine systemd[1]: Finished linger-users.service.117machine # [5896954.864798] machine postgresql-pre-start[221]: selecting default "shared_buffers" ... 128MB118machine # [5896955.152718] machine postgresql-pre-start[221]: selecting default time zone ... UTC119machine # [5896955.153389] machine postgresql-pre-start[221]: creating configuration files ... ok120machine # [5896955.280324] machine postgresql-pre-start[221]: running bootstrap script ... ok121machine # [5896955.488202] machine systemd-networkd[182]: eth1: Gained IPv6LL122machine # [5896955.669919] machine postgresql-pre-start[221]: performing post-bootstrap initialization ... ok123machine # [5896955.780468] machine postgresql-pre-start[221]: syncing data to disk ... ok124machine # [5896955.780468] machine postgresql-pre-start[221]: initdb: warning: enabling "trust" authentication for local connections125machine # [5896955.780468] 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.126machine # [5896955.780468] machine postgresql-pre-start[221]: Success. You can now start the database server using:127machine # [5896955.780468] machine postgresql-pre-start[221]: pg_ctl -D /var/lib/postgresql/18 -l logfile start128machine # [5896956.299543] machine postgres[237]: [237] LOG: starting PostgreSQL 18.4 on aarch64-unknown-linux-gnu, compiled by clang version 21.1.8, 64-bit129machine # [5896956.301150] machine postgres[237]: [237] LOG: listening on IPv6 address "::1", port 5432130machine # [5896956.301150] machine postgres[237]: [237] LOG: listening on IPv4 address "127.0.0.1", port 5432131machine # [5896956.301609] machine postgres[237]: [237] LOG: listening on Unix socket "/run/postgresql/.s.PGSQL.5432"132machine # [5896956.305821] machine postgres[246]: [246] LOG: database system was shut down at 2026-08-16 05:26:21 GMT133machine # [5896956.309335] machine postgres[237]: [237] LOG: database system is ready to accept connections134machine: (finished: waiting for unit postgresql, in 4.65 seconds)135machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -c 'CREATE TABLE test (id serial PRIMARY KEY);' test136machine: (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)137machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'INSERT INTO test DEFAULT VALUES;'138machine: (finished: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'INSERT INTO test DEFAULT VALUES;', in 0.02 seconds)139machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'SELECT * FROM test;'140machine: (finished: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'SELECT * FROM test;', in 0.02 seconds)141(finished: run the VM test script, in 4.72 seconds)142test script finished in 4.92s143cleanup144kill NspawnMachine (pid 51)145machine # [5896956.750747] machine postgresql-post-start[259]: CREATE ROLE146machine # [5896956.820610] machine postgresql-post-start[264]: CREATE DATABASE147machine # [5896956.824388] machine systemd[1]: Started PostgreSQL Server.148machine # [5896956.825577] machine systemd[1]: Starting PostgreSQL Setup Scripts...149machine # [5896956.874745] machine systemd[1]: Finished PostgreSQL Setup Scripts.150machine # [5896956.875212] machine systemd[1]: Reached target PostgreSQL.151machine # [5896956.875376] machine systemd[1]: Reached target Multi-User System.152machine # [5896956.875575] machine systemd[1]: Startup finished in 4.177s.153machine # [5896956.947318] machine runuser[273]: pam_unix(runuser:session): session opened for user postgres(uid=71) by (uid=0)154machine # [5896956.963376] machine runuser[273]: pam_unix(runuser:session): session closed for user postgres155machine # [5896956.972262] machine runuser[276]: pam_unix(runuser:session): session opened for user postgres(uid=71) by (uid=0)156machine # [5896956.983041] machine runuser[276]: pam_unix(runuser:session): session closed for user postgres157machine # [5896956.991317] machine runuser[279]: pam_unix(runuser:session): session opened for user postgres(uid=71) by (uid=0)158machine # [5896957.000246] machine runuser[279]: pam_unix(runuser:session): session closed for user postgres159(finished: cleanup, in 0.21 seconds)160Container machine terminated by signal KILL.