container-test-run-service-postgresql
checks.aarch64-linux.postgresql
· build #964
· raw
1build01: building bfaf6zw38rpfhm19m23vm7nzagw2vwxk-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 files were found.22machine # No journal boot entry found for the specified boot (+0).23machine # [362021.171224] machine systemd-journald[72]: Journal started24machine # [362021.171284] machine systemd-journald[72]: Runtime Journal (/run/log/journal/dbbe2769cc9f460fbc35abed659270b7) is 8M, max 2.5G, 2.4G free.25machine # [362021.172655] machine systemd[1]: Finished Apply Kernel Variables.26machine # [362021.183083] machine systemd[1]: Finished Create Static Device Nodes in /dev gracefully.27machine # [362021.194985] machine systemd[1]: Starting Flush Journal to Persistent Storage...28machine # [362021.195876] machine systemd[1]: Starting Network Name Resolution...29machine # [362021.196511] machine systemd[1]: Starting Create Static Device Nodes in /dev...30machine # [362021.206884] machine systemd-journald[72]: Time spent on flushing to /var/log/journal/dbbe2769cc9f460fbc35abed659270b7 is 2.597ms for 7 entries.31machine # [362021.206884] machine systemd-journald[72]: System Journal (/var/log/journal/dbbe2769cc9f460fbc35abed659270b7) is 8M, max 4G, 3.9G free.32machine # [362021.213224] machine systemd[1]: Finished Create Static Device Nodes in /dev.33machine # [362021.213748] machine systemd[1]: Reached target Preparation for Local File Systems.34machine # [362021.213862] machine systemd[1]: Reached target Local File Systems.35machine # [362021.214693] machine systemd[1]: Listening on Boot Loader Control Service Socket.36machine # [362021.214748] machine systemd[1]: Update Boot Loader Random Seed skipped, unmet condition check ConditionVirtualization=!container37machine # [362021.215524] machine systemd[1]: Starting Save Transient machine-id to Disk...38machine # [362021.215557] machine systemd[1]: Rule-based Manager for Device Events and Files skipped, unmet condition check ConditionPathIsReadWrite=/sys39machine # [362021.224764] machine systemd[1]: Finished Flush Journal to Persistent Storage.40machine # [362021.226267] machine systemd[1]: Starting Create System Files and Directories...41machine # [362021.250763] machine systemd-tmpfiles[123]: Cannot set file attributes for '/var/empty', value=0x00000010, mask=0x00000010, ignoring: Operation not permitted42machine # [362021.250949] machine systemd-tmpfiles[123]: fchmod() of /var/log/journal failed: Operation not permitted43machine # [362021.251085] machine systemd-tmpfiles[123]: fchmod() of /var/log/journal/dbbe2769cc9f460fbc35abed659270b7 failed: Operation not permitted44machine # [362021.251282] machine systemd-tmpfiles[123]: fchmod() of /run/log/journal failed: Operation not permitted45machine # [362021.252701] machine systemd[1]: Finished Create System Files and Directories.46machine # [362021.253854] machine systemd[1]: Starting Rebuild Journal Catalog...47machine # [362021.254755] machine systemd[1]: Starting Record System Boot/Shutdown in UTMP...48machine # [362021.270149] machine systemd[1]: Finished Record System Boot/Shutdown in UTMP.49machine # [362021.278825] machine systemd[1]: Finished Rebuild Journal Catalog.50machine # [362021.280215] machine systemd[1]: Starting Update is Completed...51machine # [362021.292423] machine systemd[1]: Finished Update is Completed.52machine # [362021.337518] machine systemd[1]: Finished Firewall.53machine # [362021.337716] machine systemd[1]: Reached target Preparation for Network.54machine # [362021.337976] machine systemd[1]: Listening on Network Management Resolve Hook Socket.55machine # [362021.339299] machine systemd[1]: Starting Network Management...56machine # [362021.929086] machine systemd-networkd[185]: Failed to increase receive buffer size for general netlink socket, ignoring: Operation not permitted57machine # [362021.929173] machine systemd-networkd[185]: Failed to increase receive buffer size for nftables netlink socket, ignoring: Operation not permitted58machine # [362021.938014] machine systemd-networkd[185]: /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 # [362021.938180] machine systemd-networkd[185]: /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 # [362021.938317] machine systemd-networkd[185]: lo: Link UP61machine # [362021.938321] machine systemd-networkd[185]: lo: Gained carrier62machine # [362021.938495] machine systemd-networkd[185]: eth1: Configuring with /etc/systemd/network/40-eth1.network.63machine # [362021.938902] machine systemd[1]: Started Network Management.64machine # [362021.939166] machine systemd-networkd[185]: eth1: Link UP65machine # [362021.939389] machine systemd-networkd[185]: eth1: Gained carrier66machine # [362021.940762] machine systemd[1]: Starting Enable Persistent Storage in systemd-networkd...67machine # [362021.989869] machine systemd[1]: Finished Enable Persistent Storage in systemd-networkd.68machine # [362022.201534] machine systemd-resolved[101]: Positive Trust Anchors:69machine # [362022.201545] machine systemd-resolved[101]: . IN DS 20326 8 2 e06d44b80b8f1d39a95c0b0d7c65d08458e880409bbc683457104237c7f8ec8d70machine # [362022.201549] machine systemd-resolved[101]: . IN DS 38696 8 2 683d2d0acb8c9b712a1948b27f741219298d0a450d612c483af444a4c0fb2b1671machine # [362022.201585] machine systemd-resolved[101]: 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 test72machine # [362022.221818] machine systemd-resolved[101]: Using system hostname 'machine'.73machine # [362022.223154] machine systemd[1]: Started Network Name Resolution.74machine # [362022.223296] machine systemd[1]: Reached target Network.75machine # [362022.223416] machine systemd[1]: Reached target System Initialization.76machine # [362022.223508] machine systemd[1]: Discard unused filesystem blocks once a week skipped, unmet condition check ConditionVirtualization=!container77machine # [362022.223582] machine systemd[1]: Started Daily Cleanup of Temporary Directories.78machine # [362022.223624] machine systemd[1]: Reached target Timer Units.79machine # [362022.223850] machine systemd[1]: Listening on D-Bus System Message Bus Socket.80machine # [362022.224086] machine systemd[1]: Listening on Nix Daemon Socket.81machine # [362022.224307] machine systemd[1]: Listening on Virtual Machine and Container Registration Service Socket.82machine # [362022.224356] machine systemd[1]: Reached target Socket Units.83machine # [362022.224444] machine systemd[1]: Reached target Basic System.84machine # [362022.226219] machine systemd[1]: Starting Import lastlog data into lastlog2 database...85machine # [362022.227657] machine systemd[1]: Starting Name Service Cache Daemon (nsncd)...86machine # [362022.229228] machine systemd[1]: Starting PostgreSQL Server...87machine # [362022.256467] machine systemd[1]: Starting D-Bus System Message Bus...88machine # [362022.274629] machine systemd[1]: Finished Import lastlog data into lastlog2 database.89machine # [362022.423436] machine systemd[1]: Started Name Service Cache Daemon (nsncd).90machine # [362022.423533] machine systemd[1]: Reached target Host and Network Name Lookups.91machine # [362022.423633] machine systemd[1]: Reached target User and Group Name Lookups.92machine # [362022.423746] machine nsncd[191]: Oct 13 15:38:45.381 INFO started, config: Config { ignored_request_types: {}, worker_count: 8, handoff_timeout: 10s }, path: "/var/run/nscd/socket"93machine # [362022.425844] machine systemd[1]: Starting User Login Management...94machine # [362022.427187] machine systemd[1]: Starting Permit User Sessions...95machine # [362022.484286] machine systemd[1]: Finished Permit User Sessions.96machine # [362022.486007] machine systemd[1]: Started Console Getty.97machine # [362022.486080] machine systemd[1]: Getty on tty1 skipped, unmet condition check ConditionPathExists=/dev/tty098machine # [362022.486121] machine systemd[1]: Reached target Login Prompts.99machine # [362022.541973] machine dbus-broker-launch[193]: Looking up NSS user entry for 'systemd-timesync'...100machine # [362022.543114] machine dbus-broker-launch[193]: NSS returned no entry for 'systemd-timesync'101machine # [362022.543114] machine dbus-broker-launch[193]: Invalid user-name in /nix/store/xagcpxbvcrqh2j5yg1jbqpr78vxpm95g-system-path/share/dbus-1/system.d/org.freedesktop.timesync1.conf +16: user="systemd-timesync"102machine # [362022.543675] machine systemd[1]: Started D-Bus System Message Bus.103machine # [362022.552037] machine dbus-broker-launch[193]: Ready104machine # [362023.079619] machine postgresql-pre-start[223]: The files belonging to this database system will be owned by user "postgres".105machine # [362023.079619] machine postgresql-pre-start[223]: This user must also own the server process.106machine # [362023.080293] machine postgresql-pre-start[223]: The database cluster will be initialized with locale "en_US.UTF-8".107machine # [362023.080293] machine postgresql-pre-start[223]: The default database encoding has accordingly been set to "UTF8".108machine # [362023.080293] machine postgresql-pre-start[223]: The default text search configuration will be set to "english".109machine # [362023.080293] machine postgresql-pre-start[223]: Data page checksums are enabled.110machine # [362023.080293] machine postgresql-pre-start[223]: fixing permissions on existing directory /var/lib/postgresql/18 ... ok111machine # [362023.080536] machine postgresql-pre-start[223]: creating subdirectories ... ok112machine # [362023.080636] machine postgresql-pre-start[223]: selecting dynamic shared memory implementation ... posix113machine # [362023.106769] machine postgresql-pre-start[223]: selecting default "max_connections" ... 100114machine # [362023.141119] machine postgresql-pre-start[223]: selecting default "shared_buffers" ... 128MB115machine # [362023.157941] machine systemd-logind[211]: New seat seat0.116machine # [362023.158118] machine systemd[1]: Started User Login Management.117machine # [362023.159689] machine systemd[1]: Starting linger-users.service...118machine # [362023.198098] machine systemd[1]: linger-users.service: Deactivated successfully.119machine # [362023.198424] machine systemd[1]: Finished linger-users.service.120machine # [362023.324192] machine systemd-networkd[185]: eth1: Gained IPv6LL121machine # [362023.427688] machine postgresql-pre-start[223]: selecting default time zone ... UTC122machine # [362023.428362] machine postgresql-pre-start[223]: creating configuration files ... ok123machine # [362023.560405] machine postgresql-pre-start[223]: running bootstrap script ... ok124machine # [362023.938787] machine postgresql-pre-start[223]: performing post-bootstrap initialization ... ok125machine # [362024.046135] machine postgresql-pre-start[223]: syncing data to disk ... ok126machine # [362024.046135] machine postgresql-pre-start[223]: initdb: warning: enabling "trust" authentication for local connections127machine # [362024.046135] machine postgresql-pre-start[223]: 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.128machine # [362024.046135] machine postgresql-pre-start[223]: Success. You can now start the database server using:129machine # [362024.046135] machine postgresql-pre-start[223]: pg_ctl -D /var/lib/postgresql/18 -l logfile start130machine # [362024.683343] machine systemd[1]: etc-machine\x2did.mount: Deactivated successfully.131machine # [362024.685441] machine systemd[1]: Finished Save Transient machine-id to Disk.132machine # [362024.848864] machine postgres[239]: [239] LOG: starting PostgreSQL 18.6 on aarch64-unknown-linux-gnu, compiled by clang version 21.1.8, 64-bit133machine # [362024.851111] machine postgres[239]: [239] LOG: listening on IPv6 address "::1", port 5432134machine # [362024.851111] machine postgres[239]: [239] LOG: listening on IPv4 address "127.0.0.1", port 5432135machine # [362024.851621] machine postgres[239]: [239] LOG: listening on Unix socket "/run/postgresql/.s.PGSQL.5432"136machine # [362024.855674] machine postgres[249]: [249] LOG: database system was shut down at 2026-10-13 15:38:46 GMT137machine # [362024.859020] machine postgres[239]: [239] LOG: database system is ready to accept connections138machine # [362025.670626] machine postgresql-post-start[262]: CREATE ROLE139machine # [362025.772267] machine postgresql-post-start[267]: CREATE DATABASE140machine # [362025.777227] machine systemd[1]: Started PostgreSQL Server.141machine # [362025.780198] machine systemd[1]: Starting PostgreSQL Setup Scripts...142machine # [362025.844387] machine systemd[1]: Finished PostgreSQL Setup Scripts.143machine # [362025.845156] machine systemd[1]: Reached target PostgreSQL.144machine # [362025.845441] machine systemd[1]: Reached target Multi-User System.145machine # [362025.845734] machine systemd[1]: Startup finished in 5.226s.146machine: (finished: waiting for unit postgresql, in 6.16 seconds)147machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -c 'CREATE TABLE test (id serial PRIMARY KEY);' test148machine: (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)149machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'INSERT INTO test DEFAULT VALUES;'150machine: (finished: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'INSERT INTO test DEFAULT VALUES;', in 0.02 seconds)151machine: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'SELECT * FROM test;'152machine: (finished: must succeed: runuser -u postgres -- /run/current-system/sw/bin/psql -d test -c 'SELECT * FROM test;', in 0.02 seconds)153(finished: run the VM test script, in 6.25 seconds)154test script finished in 6.30s155cleanup156kill NspawnMachine (pid 51)157(finished: cleanup, in 0.16 seconds)158Container machine terminated by signal KILL.