container-test-run-service-postgresql
checks.aarch64-linux.postgresql
· build #999
· raw
1build01: building w61f4k54rqimk8lrzmqlfwwdk5k6rvbg-container-test-run-service-postgresql.drv2Machine state will be reset. To keep it, pass --keep-machine-state3start all VLans4(finished: start all VLans, in 0.00 seconds)56Test will time out and terminate in 3600.0 seconds7run the VM test script8additionally exposed symbols:9 machine,10 vlan1,11 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_ssh12start all VMs13machine: systemd-nspawn running (pid 51)14machine: Waiting for journal at /build/vm-state-machine/var/log/journal...15(finished: start all VMs, in 0.00 seconds)16machine: waiting for unit postgresql17nixos-nspawn(machine): TAP vde-tap1 not found; container will be isolated from VDE18nixos-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.19Note: 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.20░ Spawning container machine on /build/vm-state-machine.21machine # No journal boot entry found for the specified boot (+0).22machine # [533181.727203] machine systemd-journald[72]: Journal started23machine # [533181.727265] machine systemd-journald[72]: Runtime Journal (/run/log/journal/7a43fac1f06d43648697f962391b9646) is 8M, max 2.5G, 2.4G free.24machine # [533181.728575] machine systemd[1]: Finished Apply Kernel Variables.25machine # [533181.740046] machine systemd[1]: Finished Create Static Device Nodes in /dev gracefully.26machine # [533181.752874] machine systemd[1]: Starting Flush Journal to Persistent Storage...27machine # [533181.753724] machine systemd[1]: Starting Network Name Resolution...28machine # [533181.754410] machine systemd[1]: Starting Create Static Device Nodes in /dev...29machine # [533181.807800] machine systemd-journald[72]: Time spent on flushing to /var/log/journal/7a43fac1f06d43648697f962391b9646 is 2.067ms for 7 entries.30machine # [533181.807800] machine systemd-journald[72]: System Journal (/var/log/journal/7a43fac1f06d43648697f962391b9646) is 8M, max 4G, 3.9G free.31machine # [533181.824207] machine systemd[1]: Finished Create Static Device Nodes in /dev.32machine # [533181.824846] machine systemd[1]: Reached target Preparation for Local File Systems.33machine # [533181.824964] machine systemd[1]: Reached target Local File Systems.34machine # [533181.825833] machine systemd[1]: Listening on Boot Loader Control Service Socket.35machine # [533181.825884] machine systemd[1]: Update Boot Loader Random Seed skipped, unmet condition check ConditionVirtualization=!container36machine # [533181.826758] machine systemd[1]: Starting Save Transient machine-id to Disk...37machine # [533181.826793] machine systemd[1]: Rule-based Manager for Device Events and Files skipped, unmet condition check ConditionPathIsReadWrite=/sys38machine # [533181.861485] machine systemd[1]: Finished Flush Journal to Persistent Storage.39machine # [533181.862621] machine systemd[1]: Starting Create System Files and Directories...40machine # [533181.886453] machine systemd-tmpfiles[163]: Cannot set file attributes for '/var/empty', value=0x00000010, mask=0x00000010, ignoring: Operation not permitted41machine # [533181.886757] machine systemd-tmpfiles[163]: fchmod() of /var/log/journal failed: Operation not permitted42machine # [533181.886945] machine systemd-tmpfiles[163]: fchmod() of /var/log/journal/7a43fac1f06d43648697f962391b9646 failed: Operation not permitted43machine # [533181.887218] machine systemd-tmpfiles[163]: fchmod() of /run/log/journal failed: Operation not permitted44machine # [533181.887878] machine systemd[1]: Finished Firewall.45machine # [533181.888343] machine systemd[1]: Finished Create System Files and Directories.46machine # [533181.889046] machine systemd[1]: Reached target Preparation for Network.47machine # [533181.889364] machine systemd[1]: Listening on Network Management Resolve Hook Socket.48machine # [533181.890353] machine systemd[1]: Starting Rebuild Journal Catalog...49machine # [533181.891413] machine systemd[1]: Starting Network Management...50machine # [533181.892302] machine systemd[1]: Starting Record System Boot/Shutdown in UTMP...51machine # [533181.912398] machine systemd[1]: Finished Rebuild Journal Catalog.52machine # [533181.912659] machine systemd[1]: Finished Record System Boot/Shutdown in UTMP.53machine # [533181.914943] machine systemd[1]: Starting Update is Completed...54machine # [533181.930171] machine systemd[1]: Finished Update is Completed.55machine # [533181.960441] machine systemd[1]: Finished Save Transient machine-id to Disk.56machine # [533182.584499] machine systemd-networkd[180]: Failed to increase receive buffer size for general netlink socket, ignoring: Operation not permitted57machine # [533182.584595] machine systemd-networkd[180]: Failed to increase receive buffer size for nftables netlink socket, ignoring: Operation not permitted58machine # [533182.593764] machine systemd-networkd[180]: /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.59machine # [533182.593930] machine systemd-networkd[180]: /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.60machine # [533182.594106] machine systemd-networkd[180]: lo: Link UP61machine # [533182.594115] machine systemd-networkd[180]: lo: Gained carrier62machine # [533182.594338] machine systemd-networkd[180]: eth1: Configuring with /etc/systemd/network/40-eth1.network.63machine # [533182.594773] machine systemd[1]: Started Network Management.64machine # [533182.594823] machine systemd-networkd[180]: eth1: Link UP65machine # [533182.595106] machine systemd-networkd[180]: eth1: Gained carrier66machine # [533182.596716] machine systemd[1]: Starting Enable Persistent Storage in systemd-networkd...67machine # [533182.670315] machine systemd[1]: Finished Enable Persistent Storage in systemd-networkd.68machine # [533182.735051] machine systemd[1]: etc-machine\x2did.mount: Deactivated successfully.69machine # [533182.962202] machine systemd-resolved[106]: Positive Trust Anchors:70machine # [533182.962215] machine systemd-resolved[106]: . IN DS 20326 8 2 e06d44b80b8f1d39a95c0b0d7c65d08458e880409bbc683457104237c7f8ec8d71machine # [533182.962218] machine systemd-resolved[106]: . IN DS 38696 8 2 683d2d0acb8c9b712a1948b27f741219298d0a450d612c483af444a4c0fb2b1672machine # [533182.962252] machine systemd-resolved[106]: 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 test73machine # [533182.982570] machine systemd-resolved[106]: Using system hostname 'machine'.74machine # [533182.983965] machine systemd[1]: Started Network Name Resolution.75machine # [533182.984125] machine systemd[1]: Reached target Network.76machine # [533182.984236] machine systemd[1]: Reached target System Initialization.77machine # [533182.984331] machine systemd[1]: Discard unused filesystem blocks once a week skipped, unmet condition check ConditionVirtualization=!container78machine # [533182.984390] machine systemd[1]: Started Daily Cleanup of Temporary Directories.79machine # [533182.984433] machine systemd[1]: Reached target Timer Units.80machine # [533182.984654] machine systemd[1]: Listening on D-Bus System Message Bus Socket.81machine # [533182.984867] machine systemd[1]: Listening on Nix Daemon Socket.82machine # [533182.985091] machine systemd[1]: Listening on Virtual Machine and Container Registration Service Socket.83machine # [533182.985140] machine systemd[1]: Reached target Socket Units.84machine # [533182.985218] machine systemd[1]: Reached target Basic System.85machine # [533182.986844] machine systemd[1]: Starting Import lastlog data into lastlog2 database...86machine # [533182.988456] machine systemd[1]: Starting Name Service Cache Daemon (nsncd)...87machine # [533182.990115] machine systemd[1]: Starting PostgreSQL Server...88machine # [533182.992667] machine systemd[1]: Starting D-Bus System Message Bus...89machine # [533183.007359] machine systemd[1]: Finished Import lastlog data into lastlog2 database.90machine # [533183.150806] machine systemd[1]: Started Name Service Cache Daemon (nsncd).91machine # [533183.151404] machine nsncd[192]: Oct 15 15:11:26.108 INFO started, config: Config { ignored_request_types: {}, worker_count: 8, handoff_timeout: 10s }, path: "/var/run/nscd/socket"92machine # [533183.150932] machine systemd[1]: Reached target Host and Network Name Lookups.93machine # [533183.151034] machine systemd[1]: Reached target User and Group Name Lookups.94machine # [533183.169517] machine systemd[1]: Starting User Login Management...95machine # [533183.170719] machine systemd[1]: Starting Permit User Sessions...96machine # [533183.183276] machine systemd[1]: Finished Permit User Sessions.97machine # [533183.185152] machine systemd[1]: Started Console Getty.98machine # [533183.185229] machine systemd[1]: Getty on tty1 skipped, unmet condition check ConditionPathExists=/dev/tty099machine # [533183.185270] machine systemd[1]: Reached target Login Prompts.100machine # [533183.324555] machine dbus-broker-launch[194]: Looking up NSS user entry for 'systemd-timesync'...101machine # [533183.325730] machine dbus-broker-launch[194]: NSS returned no entry for 'systemd-timesync'102machine # [533183.325730] machine dbus-broker-launch[194]: Invalid user-name in /nix/store/qc12zkw7x5qpsb49myxpnflkcrawmf03-system-path/share/dbus-1/system.d/org.freedesktop.timesync1.conf +16: user="systemd-timesync"103machine # [533183.326468] machine systemd[1]: Started D-Bus System Message Bus.104machine # [533183.334146] machine dbus-broker-launch[194]: Ready105machine # [533183.898973] machine postgresql-pre-start[224]: The files belonging to this database system will be owned by user "postgres".106machine # [533183.898973] machine postgresql-pre-start[224]: This user must also own the server process.107machine # [533183.899413] machine postgresql-pre-start[224]: The database cluster will be initialized with locale "en_US.UTF-8".108machine # [533183.899413] machine postgresql-pre-start[224]: The default database encoding has accordingly been set to "UTF8".109machine # [533183.899413] machine postgresql-pre-start[224]: The default text search configuration will be set to "english".110machine # [533183.899413] machine postgresql-pre-start[224]: Data page checksums are enabled.111machine # [533183.899413] machine postgresql-pre-start[224]: fixing permissions on existing directory /var/lib/postgresql/18 ... ok112machine # [533183.899757] machine postgresql-pre-start[224]: creating subdirectories ... ok113machine # [533183.899863] machine postgresql-pre-start[224]: selecting dynamic shared memory implementation ... posix114machine # [533183.924241] machine postgresql-pre-start[224]: selecting default "max_connections" ... 100115machine # [533183.949353] machine postgresql-pre-start[224]: selecting default "shared_buffers" ... 128MB116machine # [533183.974797] machine systemd-logind[212]: New seat seat0.117machine # [533183.975011] machine systemd[1]: Started User Login Management.118machine # [533183.976263] machine systemd[1]: Starting linger-users.service...119machine # [533184.038079] machine systemd[1]: linger-users.service: Deactivated successfully.120machine # [533184.038298] machine systemd[1]: Finished linger-users.service.121machine # [533184.245279] machine postgresql-pre-start[224]: selecting default time zone ... UTC122machine # [533184.245978] machine postgresql-pre-start[224]: creating configuration files ... ok123machine # [533184.370608] machine postgresql-pre-start[224]: running bootstrap script ... ok124machine # [533184.476134] machine systemd-networkd[180]: eth1: Gained IPv6LL125machine # [533184.752970] machine postgresql-pre-start[224]: performing post-bootstrap initialization ... ok126machine # [533184.984462] machine postgresql-pre-start[224]: syncing data to disk ... ok127machine # [533184.984462] machine postgresql-pre-start[224]: initdb: warning: enabling "trust" authentication for local connections128machine # [533184.984462] 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.129machine # [533184.984462] machine postgresql-pre-start[224]: Success. You can now start the database server using:130machine # [533184.984462] machine postgresql-pre-start[224]: pg_ctl -D /var/lib/postgresql/18 -l logfile start131machine # [533185.847808] machine postgres[240]: [240] LOG: starting PostgreSQL 18.6 on aarch64-unknown-linux-gnu, compiled by clang version 21.1.8, 64-bit132machine # [533185.849607] machine postgres[240]: [240] LOG: listening on IPv6 address "::1", port 5432133machine # [533185.849607] machine postgres[240]: [240] LOG: listening on IPv4 address "127.0.0.1", port 5432134machine # [533185.850202] machine postgres[240]: [240] LOG: listening on Unix socket "/run/postgresql/.s.PGSQL.5432"135machine # [533185.854013] machine postgres[249]: [249] LOG: database system was shut down at 2026-10-15 15:11:27 GMT136machine # [533185.858145] machine postgres[240]: [240] LOG: database system is ready to accept connections137machine # [533186.774749] machine postgresql-post-start[262]: CREATE ROLE138machine # [533186.928184] machine postgresql-post-start[267]: CREATE DATABASE139machine # [533186.934456] machine systemd[1]: Started PostgreSQL Server.140machine # [533186.936903] machine systemd[1]: Starting PostgreSQL Setup Scripts...141machine # [533187.003346] machine systemd[1]: Finished PostgreSQL Setup Scripts.142machine # [533187.004139] machine systemd[1]: Reached target PostgreSQL.143machine # [533187.004434] machine systemd[1]: Reached target Multi-User System.144machine # [533187.004952] machine systemd[1]: Startup finished in 5.679s.145machine: (finished: waiting for unit postgresql, in 6.66 seconds)146machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -c 'CREATE TABLE test (id serial PRIMARY KEY);' test147machine: (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)148machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'INSERT INTO test DEFAULT VALUES;'149machine: (finished: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'INSERT INTO test DEFAULT VALUES;', in 0.02 seconds)150machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'SELECT * FROM test;'151machine: (finished: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'SELECT * FROM test;', in 0.02 seconds)152(finished: run the VM test script, in 6.74 seconds)153test script finished in 6.90s154cleanup155kill NspawnMachine (pid 51)156machine # [533187.481167] machine runuser[276]: pam_unix(runuser:session): session opened for user postgres(uid=71) by (uid=0)157machine # [533187.499146] machine runuser[276]: pam_unix(runuser:session): session closed for user postgres158machine # [533187.508984] machine runuser[279]: pam_unix(runuser:session): session opened for user postgres(uid=71) by (uid=0)159machine # [533187.521235] machine runuser[279]: pam_unix(runuser:session): session closed for user postgres160machine # [533187.531850] machine runuser[282]: pam_unix(runuser:session): session opened for user postgres(uid=71) by (uid=0)161machine # [533187.542341] machine runuser[282]: pam_unix(runuser:session): session closed for user postgres162machine # [533187.712848] machine systemd-networkd[180]: eth1: Link DOWN163machine # [533187.712881] machine systemd-networkd[180]: eth1: Lost carrier164machine # [533187.744725] machine systemd-networkd[180]: eth1: Lost IPv6LL address fe80::7849:65ff:fe3c:c782.165Container machine terminated by signal KILL.166(finished: cleanup, in 0.26 seconds)