container-test-run-service-postgresql
checks.aarch64-linux.postgresql
· build #692
· 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 # [1201427.050252] machine systemd-journald[72]: Journal started21machine # [1201427.050316] machine systemd-journald[72]: Runtime Journal (/run/log/journal/cd0e434a14d94153bd1574e98b73d397) is 8M, max 2.5G, 2.4G free.22machine # [1201427.065433] machine systemd[1]: Finished Create Static Device Nodes in /dev gracefully.23machine # [1201427.079693] machine systemd[1]: Starting Flush Journal to Persistent Storage...24machine # [1201427.080526] machine systemd[1]: Starting Network Name Resolution...25machine # [1201427.081209] machine systemd[1]: Starting Create Static Device Nodes in /dev...26machine # [1201427.090929] machine systemd-journald[72]: Time spent on flushing to /var/log/journal/cd0e434a14d94153bd1574e98b73d397 is 1.366ms for 6 entries.27machine # [1201427.090929] machine systemd-journald[72]: System Journal (/var/log/journal/cd0e434a14d94153bd1574e98b73d397) is 8M, max 4G, 3.9G free.28machine # [1201427.115734] machine systemd[1]: Finished Flush Journal to Persistent Storage.29machine # [1201427.116266] machine systemd[1]: Finished Create Static Device Nodes in /dev.30machine # [1201427.117630] machine systemd[1]: Reached target Preparation for Local File Systems.31machine # [1201427.117749] machine systemd[1]: Reached target Local File Systems.32machine # [1201427.118551] machine systemd[1]: Listening on Boot Loader Control Service Socket.33machine # [1201427.118602] machine systemd[1]: Update Boot Loader Random Seed skipped, unmet condition check ConditionVirtualization=!container34machine # [1201427.119476] machine systemd[1]: Starting Save Transient machine-id to Disk...35machine # [1201427.120449] machine systemd[1]: Starting Create System Files and Directories...36machine # [1201427.120480] machine systemd[1]: Rule-based Manager for Device Events and Files skipped, unmet condition check ConditionPathIsReadWrite=/sys37machine # [1201427.137806] machine systemd-tmpfiles[136]: Cannot set file attributes for '/var/empty', value=0x00000010, mask=0x00000010, ignoring: Operation not permitted38machine # [1201427.137986] machine systemd-tmpfiles[136]: fchmod() of /var/log/journal failed: Operation not permitted39machine # [1201427.138105] machine systemd-tmpfiles[136]: fchmod() of /var/log/journal/cd0e434a14d94153bd1574e98b73d397 failed: Operation not permitted40machine # [1201427.138279] machine systemd-tmpfiles[136]: fchmod() of /run/log/journal failed: Operation not permitted41machine # [1201427.139819] machine systemd[1]: Finished Create System Files and Directories.42machine # [1201427.141398] machine systemd[1]: Starting Rebuild Journal Catalog...43machine # [1201427.142282] machine systemd[1]: Starting Record System Boot/Shutdown in UTMP...44machine # [1201427.151623] machine systemd[1]: Finished Save Transient machine-id to Disk.45machine # [1201427.155847] machine systemd[1]: Finished Record System Boot/Shutdown in UTMP.46machine # [1201427.165762] machine systemd[1]: Finished Rebuild Journal Catalog.47machine # [1201427.166803] machine systemd[1]: Starting Update is Completed...48machine # [1201427.177392] machine systemd[1]: Finished Update is Completed.49machine # [1201427.199819] machine systemd[1]: Finished Firewall.50machine # [1201427.199934] machine systemd[1]: Reached target Preparation for Network.51machine # [1201427.200177] machine systemd[1]: Listening on Network Management Resolve Hook Socket.52machine # [1201427.201267] machine systemd[1]: Starting Network Management...53machine # [1201427.955671] machine systemd-networkd[186]: Failed to increase receive buffer size for general netlink socket, ignoring: Operation not permitted54machine # [1201427.955765] machine systemd-networkd[186]: Failed to increase receive buffer size for nftables netlink socket, ignoring: Operation not permitted55machine # [1201427.965248] machine systemd-networkd[186]: /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.56machine # [1201427.965414] machine systemd-networkd[186]: /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.57machine # [1201427.965577] machine systemd-networkd[186]: lo: Link UP58machine # [1201427.965581] machine systemd-networkd[186]: lo: Gained carrier59machine # [1201427.965753] machine systemd-networkd[186]: eth1: Configuring with /etc/systemd/network/40-eth1.network.60machine # [1201427.966217] machine systemd[1]: Started Network Management.61machine # [1201427.966449] machine systemd-networkd[186]: eth1: Link UP62machine # [1201427.966695] machine systemd-networkd[186]: eth1: Gained carrier63machine # [1201427.968057] machine systemd[1]: Starting Enable Persistent Storage in systemd-networkd...64machine # [1201427.998793] machine systemd[1]: Finished Enable Persistent Storage in systemd-networkd.65machine # [1201428.051555] machine systemd[1]: etc-machine\x2did.mount: Deactivated successfully.66machine # [1201428.315201] machine systemd-resolved[110]: Positive Trust Anchors:67machine # [1201428.315214] machine systemd-resolved[110]: . IN DS 20326 8 2 e06d44b80b8f1d39a95c0b0d7c65d08458e880409bbc683457104237c7f8ec8d68machine # [1201428.315218] machine systemd-resolved[110]: . IN DS 38696 8 2 683d2d0acb8c9b712a1948b27f741219298d0a450d612c483af444a4c0fb2b1669machine # [1201428.315250] machine systemd-resolved[110]: 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 test70machine # [1201428.337137] machine systemd-resolved[110]: Using system hostname 'machine'.71machine # [1201428.338545] machine systemd[1]: Started Network Name Resolution.72machine # [1201428.338676] machine systemd[1]: Reached target Network.73machine # [1201428.338782] machine systemd[1]: Reached target System Initialization.74machine # [1201428.338878] machine systemd[1]: Discard unused filesystem blocks once a week skipped, unmet condition check ConditionVirtualization=!container75machine # [1201428.338935] machine systemd[1]: Started Daily Cleanup of Temporary Directories.76machine # [1201428.338980] machine systemd[1]: Reached target Timer Units.77machine # [1201428.339221] machine systemd[1]: Listening on D-Bus System Message Bus Socket.78machine # [1201428.339443] machine systemd[1]: Listening on Nix Daemon Socket.79machine # [1201428.339652] machine systemd[1]: Listening on Virtual Machine and Container Registration Service Socket.80machine # [1201428.339697] machine systemd[1]: Reached target Socket Units.81machine # [1201428.339778] machine systemd[1]: Reached target Basic System.82machine # [1201428.342055] machine systemd[1]: Starting Import lastlog data into lastlog2 database...83machine # [1201428.343454] machine systemd[1]: Starting Name Service Cache Daemon (nsncd)...84machine # [1201428.345168] machine systemd[1]: Starting PostgreSQL Server...85machine # [1201428.393343] machine systemd[1]: Starting D-Bus System Message Bus...86machine # [1201428.409814] machine systemd[1]: Finished Import lastlog data into lastlog2 database.87machine # [1201428.696474] machine systemd[1]: Started Name Service Cache Daemon (nsncd).88machine # [1201428.696590] machine systemd[1]: Reached target Host and Network Name Lookups.89machine # [1201428.696725] machine nsncd[192]: Sep 18 05:10:48.682 INFO started, config: Config { ignored_request_types: {}, worker_count: 8, handoff_timeout: 10s }, path: "/var/run/nscd/socket"90machine # [1201428.696704] machine systemd[1]: Reached target User and Group Name Lookups.91machine # [1201428.705706] machine systemd[1]: Starting User Login Management...92machine # [1201428.707138] machine systemd[1]: Starting Permit User Sessions...93machine # [1201428.718971] machine systemd[1]: Finished Permit User Sessions.94machine # [1201428.720093] machine systemd[1]: Started Console Getty.95machine # [1201428.720142] machine systemd[1]: Getty on tty1 skipped, unmet condition check ConditionPathExists=/dev/tty096machine # [1201428.720164] machine systemd[1]: Reached target Login Prompts.97machine # [1201428.890859] machine dbus-broker-launch[196]: Looking up NSS user entry for 'systemd-timesync'...98machine # [1201428.891557] machine dbus-broker-launch[196]: NSS returned no entry for 'systemd-timesync'99machine # [1201428.891557] machine dbus-broker-launch[196]: Invalid user-name in /nix/store/00vsmrjb41cn6pgzzga5vlqid0rk8ms1-system-path/share/dbus-1/system.d/org.freedesktop.timesync1.conf +16: user="systemd-timesync"100machine # [1201428.891968] machine systemd[1]: Started D-Bus System Message Bus.101machine # [1201428.899230] machine dbus-broker-launch[196]: Ready102machine # [1201429.612753] machine postgresql-pre-start[224]: The files belonging to this database system will be owned by user "postgres".103machine # [1201429.612753] machine postgresql-pre-start[224]: This user must also own the server process.104machine # [1201429.613313] machine postgresql-pre-start[224]: The database cluster will be initialized with locale "en_US.UTF-8".105machine # [1201429.613313] machine postgresql-pre-start[224]: The default database encoding has accordingly been set to "UTF8".106machine # [1201429.613313] machine postgresql-pre-start[224]: The default text search configuration will be set to "english".107machine # [1201429.613313] machine postgresql-pre-start[224]: Data page checksums are enabled.108machine # [1201429.613313] machine postgresql-pre-start[224]: fixing permissions on existing directory /var/lib/postgresql/18 ... ok109machine # [1201429.613705] machine postgresql-pre-start[224]: creating subdirectories ... ok110machine # [1201429.613809] machine postgresql-pre-start[224]: selecting dynamic shared memory implementation ... posix111machine # [1201429.622185] machine systemd-logind[212]: New seat seat0.112machine # [1201429.622383] machine systemd[1]: Started User Login Management.113machine # [1201429.637359] machine systemd[1]: Starting linger-users.service...114machine # [1201429.650656] machine systemd[1]: linger-users.service: Deactivated successfully.115machine # [1201429.650847] machine systemd[1]: Finished linger-users.service.116machine # [1201429.651323] machine postgresql-pre-start[224]: selecting default "max_connections" ... 100117machine # [1201429.664187] machine systemd-networkd[186]: eth1: Gained IPv6LL118machine # [1201429.697583] machine postgresql-pre-start[224]: selecting default "shared_buffers" ... 128MB119machine # [1201429.994283] machine postgresql-pre-start[224]: selecting default time zone ... UTC120machine # [1201429.994965] machine postgresql-pre-start[224]: creating configuration files ... ok121machine # [1201430.129746] machine postgresql-pre-start[224]: running bootstrap script ... ok122machine # [1201430.523594] machine postgresql-pre-start[224]: performing post-bootstrap initialization ... ok123machine # [1201430.597589] machine postgresql-pre-start[224]: syncing data to disk ... ok124machine # [1201430.597589] machine postgresql-pre-start[224]: initdb: warning: enabling "trust" authentication for local connections125machine # [1201430.597589] machine postgresql-pre-start[224]: 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 # [1201430.597589] machine postgresql-pre-start[224]: Success. You can now start the database server using:127machine # [1201430.597589] machine postgresql-pre-start[224]: pg_ctl -D /var/lib/postgresql/18 -l logfile start128machine # [1201431.405956] machine postgres[240]: [240] LOG: starting PostgreSQL 18.6 on aarch64-unknown-linux-gnu, compiled by clang version 21.1.8, 64-bit129machine # [1201431.408572] machine postgres[240]: [240] LOG: listening on IPv6 address "::1", port 5432130machine # [1201431.408572] machine postgres[240]: [240] LOG: listening on IPv4 address "127.0.0.1", port 5432131machine # [1201431.409003] machine postgres[240]: [240] LOG: listening on Unix socket "/run/postgresql/.s.PGSQL.5432"132machine # [1201431.413041] machine postgres[249]: [249] LOG: database system was shut down at 2026-09-18 05:10:50 GMT133machine # [1201431.418331] machine postgres[240]: [240] LOG: database system is ready to accept connections134machine # [1201432.234430] machine postgresql-post-start[262]: CREATE ROLE135machine # [1201432.308785] machine postgresql-post-start[267]: CREATE DATABASE136machine # [1201432.315609] machine systemd[1]: Started PostgreSQL Server.137machine # [1201432.329161] machine systemd[1]: Starting PostgreSQL Setup Scripts...138machine # [1201432.353779] machine systemd[1]: Finished PostgreSQL Setup Scripts.139machine # [1201432.354240] machine systemd[1]: Reached target PostgreSQL.140machine # [1201432.354394] machine systemd[1]: Reached target Multi-User System.141machine # [1201432.354561] machine systemd[1]: Startup finished in 5.733s.142machine: (finished: waiting for unit postgresql, in 6.66 seconds)143machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -c 'CREATE TABLE test (id serial PRIMARY KEY);' test144machine: (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)145machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'INSERT INTO test DEFAULT VALUES;'146machine: (finished: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'INSERT INTO test DEFAULT VALUES;', in 0.02 seconds)147machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'SELECT * FROM test;'148machine: (finished: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'SELECT * FROM test;', in 0.02 seconds)149(finished: run the VM test script, in 6.72 seconds)150test script finished in 6.92s151cleanup152kill NspawnMachine (pid 51)153machine # [1201432.803910] machine runuser[276]: pam_unix(runuser:session): session opened for user postgres(uid=71) by (uid=0)154machine # [1201432.818430] machine runuser[276]: pam_unix(runuser:session): session closed for user postgres155machine # [1201432.827475] machine runuser[279]: pam_unix(runuser:session): session opened for user postgres(uid=71) by (uid=0)156machine # [1201432.837502] machine runuser[279]: pam_unix(runuser:session): session closed for user postgres157machine # [1201432.847045] machine runuser[282]: pam_unix(runuser:session): session opened for user postgres(uid=71) by (uid=0)158machine # [1201432.856442] machine runuser[282]: pam_unix(runuser:session): session closed for user postgres159Container machine terminated by signal KILL.160(finished: cleanup, in 0.21 seconds)