Machine state will be reset. To keep it, pass --keep-machine-state start all VLans (finished: start all VLans, in 0.01 seconds) Test will time out and terminate in 3600 seconds run the VM test script additionally exposed symbols: server, vlan1, 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_ssh server: waiting for unit mobilizon.service server: systemd-nspawn running (pid 50) server: Waiting for journal at /build/vm-state-server/var/log/journal... nixos-nspawn(server): TAP vde-tap1 not found; container will be isolated from VDE nixos-nspawn(server): A common reason for this is that /dev/net is not available in the Nix sandbox. Try adding /dev/net to extra-sandbox-paths. Note: 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. ░ Spawning container server on /build/vm-state-server. server # No journal files were found. server # No journal boot entry found for the specified boot (+0). server # [694398.741105] server systemd-journald[57]: Journal started server # [694398.741231] server systemd-journald[57]: Runtime Journal (/run/log/journal/97d2613ceb7141c38233db1cffc2479a) is 8M, max 311.2M, 303.2M free. server # [694398.754570] server systemd[1]: Finished Apply Kernel Variables. server # [694398.771259] server systemd[1]: Finished Create Static Device Nodes in /dev gracefully. server # [694398.791186] server systemd[1]: Starting Flush Journal to Persistent Storage... server # [694398.792107] server systemd[1]: Starting Create Static Device Nodes in /dev... server # [694398.816404] server systemd-journald[57]: Time spent on flushing to /var/log/journal/97d2613ceb7141c38233db1cffc2479a is 1.618ms for 6 entries. server # [694398.816404] server systemd-journald[57]: System Journal (/var/log/journal/97d2613ceb7141c38233db1cffc2479a) is 512B, max 4G, 3.9G free. server # [694398.830575] server systemd[1]: Finished Create Static Device Nodes in /dev. server # [694398.831343] server systemd[1]: Reached target Preparation for Local File Systems. server # [694398.831567] server systemd[1]: Rule-based Manager for Device Events and Files skipped, unmet condition check ConditionPathIsReadWrite=/sys server # [694398.977960] server systemd[1]: Finished Firewall. server # [694398.986298] server systemd[1]: Finished Flush Journal to Persistent Storage. server # [694399.739780] server systemd[1]: Mounting /run/wrappers... server # [694399.818516] server systemd[1]: Mounted /run/wrappers. server # [694399.819308] server systemd[1]: Reached target Local File Systems. server # [694399.820452] server systemd[1]: Listening on Boot Loader Control Service Socket. server # [694399.821588] server systemd[1]: Starting Create SUID/SGID Wrappers... server # [694399.821644] server systemd[1]: Update Boot Loader Random Seed skipped, unmet condition check ConditionVirtualization=!container server # [694399.822508] server systemd[1]: Starting Save Transient machine-id to Disk... server # [694399.823442] server systemd[1]: Starting Create System Files and Directories... server # [694399.847731] server systemd-tmpfiles[161]: Cannot set file attributes for '/var/empty', value=0x00000010, mask=0x00000010, ignoring: Operation not permitted server # [694399.849564] server systemd-tmpfiles[161]: fchmod() of /var/log/journal failed: Operation not permitted server # [694399.850048] server systemd-tmpfiles[161]: fchmod() of /var/log/journal/97d2613ceb7141c38233db1cffc2479a failed: Operation not permitted server # [694399.850332] server systemd-tmpfiles[161]: fchmod() of /run/log/journal failed: Operation not permitted server # [694399.853678] server systemd[1]: Finished Create System Files and Directories. server # [694399.858477] server suid-sgid-wrappers-start[169]: chmod: changing permissions of '/run/wrappers/wrappers.dBoOAa8UyN/chsh': Operation not permitted server # [694399.872258] server systemd[1]: suid-sgid-wrappers.service: Main process exited, code=exited, status=1/FAILURE server # [694399.872364] server systemd[1]: suid-sgid-wrappers.service: Failed with result 'exit-code'. server # [694399.872542] server systemd[1]: Failed to start Create SUID/SGID Wrappers. server # [694399.875126] server systemd[1]: Starting Rebuild Journal Catalog... server # [694399.876124] server systemd[1]: Starting Record System Boot/Shutdown in UTMP... server # [694399.892408] server systemd[1]: Finished Record System Boot/Shutdown in UTMP. server # [694399.897822] server systemd[1]: Finished Rebuild Journal Catalog. server # [694399.899730] server systemd[1]: Starting Update is Completed... server # [694399.912427] server systemd[1]: Finished Update is Completed. server # [694399.913315] server systemd[1]: Reached target System Initialization. server # [694399.913602] server systemd[1]: Discard unused filesystem blocks once a week skipped, unmet condition check ConditionVirtualization=!container server # [694399.913747] server systemd[1]: Started Daily Cleanup of Temporary Directories. server # [694399.913777] server systemd[1]: Reached target Timer Units. server # [694399.914003] server systemd[1]: Listening on D-Bus System Message Bus Socket. server # [694399.914306] server systemd[1]: Listening on Nix Daemon Socket. server # [694399.914470] server systemd[1]: Listening on Virtual Machine and Container Registration Service Socket. server # [694399.914505] server systemd[1]: Reached target Socket Units. server # [694399.914574] server systemd[1]: Reached target Basic System. server # [694399.916471] server systemd[1]: Starting Import lastlog data into lastlog2 database... server # [694399.917602] server systemd[1]: Starting Name Service Cache Daemon (nsncd)... server # [694399.918655] server systemd[1]: Starting resolvconf update... server # [694399.943402] server systemd[1]: Finished Import lastlog data into lastlog2 database. server # [694399.989161] server systemd[1]: nscd.service: Deactivated successfully. server # [694399.989546] server systemd[1]: Stopped Name Service Cache Daemon (nsncd). server # [694399.992303] server systemd[1]: Starting Name Service Cache Daemon (nsncd)... server # [694400.011775] server resolvconf-start[235]: setfacl: /run/resolvconf: Operation not supported server # [694400.012598] server systemd[1]: resolvconf.service: Main process exited, code=exited, status=1/FAILURE server # [694400.012726] server systemd[1]: resolvconf.service: Failed with result 'exit-code'. server # [694400.012933] server systemd[1]: Failed to start resolvconf update. server # [694400.013845] server systemd[1]: Reached target Preparation for Network. server # [694400.016654] server systemd[1]: Starting Address configuration of eth1... server # [694400.018935] server systemd[1]: Starting Extra networking commands.... server # [694400.036183] server network-addresses-eth1-start[237]: adding address 192.168.1.1/24... done server # [694400.039577] server network-addresses-eth1-start[237]: adding address 2001:db8:1::1/64... done server # [694400.060033] server systemd[1]: etc-machine\x2did.mount: Deactivated successfully. server # [694400.061576] server systemd[1]: Finished Save Transient machine-id to Disk. server # [694400.061773] server systemd[1]: Finished Address configuration of eth1. server # [694400.099791] server systemd[1]: Finished Extra networking commands.. server # [694400.100116] server systemd[1]: Reached target Network. server # [694400.102050] server systemd[1]: Starting Nginx Web Server... server # [694400.103723] server systemd[1]: Starting PostgreSQL Server... server # [694400.198480] server nsncd[224]: Sep 28 15:26:54.919 INFO started, config: Config { ignored_request_types: {}, worker_count: 8, handoff_timeout: 10s }, path: "/var/run/nscd/socket" server # [694400.198626] server systemd[1]: Started Name Service Cache Daemon (nsncd). server # [694400.198709] server systemd[1]: Reached target Host and Network Name Lookups. server # [694400.198795] server systemd[1]: Reached target User and Group Name Lookups. server # [694400.201008] server systemd[1]: Starting User Login Management... server # [694400.202351] server systemd[1]: Starting Permit User Sessions... server # [694400.245581] server systemd[1]: Finished Permit User Sessions. server # [694400.252406] server systemd[1]: Started Console Getty. server # [694400.252513] server systemd[1]: Getty on tty1 skipped, unmet condition check ConditionPathExists=/dev/tty0 server # [694400.252557] server systemd[1]: Reached target Login Prompts. server # [694401.525659] server systemd-logind[314]: New seat seat0. server # [694401.528591] server systemd[1]: Starting D-Bus System Message Bus... server # [694401.529044] server systemd[1]: Started User Login Management. server # [694401.552269] server systemd[1]: Starting linger-users.service... server # [694401.610396] server systemd[1]: linger-users.service: Deactivated successfully. server # [694401.610609] server systemd[1]: Finished linger-users.service. server # [694401.754009] server nginx-pre-start[328]: nginx: the configuration file /nix/store/rk49i8nmqyr6ws20g0567x6s5rn0bynd-nginx.conf syntax is ok server # [694401.754393] server nginx-pre-start[328]: nginx: configuration file /nix/store/rk49i8nmqyr6ws20g0567x6s5rn0bynd-nginx.conf test is successful server # [694401.760182] server systemd[1]: Started Nginx Web Server. server # [694401.770810] server postgresql-pre-start[330]: The files belonging to this database system will be owned by user "postgres". server # [694401.772096] server postgresql-pre-start[330]: This user must also own the server process. server # [694401.772096] server postgresql-pre-start[330]: The database cluster will be initialized with locale "en_US.UTF-8". server # [694401.772096] server postgresql-pre-start[330]: The default database encoding has accordingly been set to "UTF8". server # [694401.772096] server postgresql-pre-start[330]: The default text search configuration will be set to "english". server # [694401.772096] server postgresql-pre-start[330]: Data page checksums are disabled. server # [694401.772096] server postgresql-pre-start[330]: fixing permissions on existing directory /var/lib/postgresql/17 ... ok server # [694401.772658] server postgresql-pre-start[330]: creating subdirectories ... ok server # [694401.773179] server postgresql-pre-start[330]: selecting dynamic shared memory implementation ... posix server # [694401.806030] server postgresql-pre-start[330]: selecting default "max_connections" ... 100 server # [694401.837831] server postgresql-pre-start[330]: selecting default "shared_buffers" ... 128MB server # [694402.160532] server dbus-broker-launch[324]: Looking up NSS user entry for 'systemd-timesync'... server # [694402.161194] server dbus-broker-launch[324]: NSS returned no entry for 'systemd-timesync' server # [694402.161194] server dbus-broker-launch[324]: Invalid user-name in /nix/store/adzqynk6f50i3v9gvfwrc79pmzrqv4zn-system-path/share/dbus-1/system.d/org.freedesktop.timesync1.conf +16: user="systemd-timesync" server # [694402.163273] server systemd[1]: Started D-Bus System Message Bus. server # [694402.176339] server dbus-broker-launch[324]: Ready server # [694403.530155] server postgresql-pre-start[330]: selecting default time zone ... UTC server # [694403.531084] server postgresql-pre-start[330]: creating configuration files ... ok server # [694403.714467] server postgresql-pre-start[330]: running bootstrap script ... ok server # [694404.299517] server postgresql-pre-start[330]: performing post-bootstrap initialization ... ok server: still waiting for container 'server' to reach ready state... server # [694407.440777] server postgresql-pre-start[330]: syncing data to disk ... ok server # [694407.440777] server postgresql-pre-start[330]: initdb: warning: enabling "trust" authentication for local connections server # [694407.440777] server postgresql-pre-start[330]: 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. server # [694407.440777] server postgresql-pre-start[330]: Success. You can now start the database server using: server # [694407.440777] server postgresql-pre-start[330]: pg_ctl -D /var/lib/postgresql/17 -l logfile start server # [694408.859697] server postgres[350]: [350] LOG: starting PostgreSQL 17.10 on aarch64-unknown-linux-gnu, compiled by clang version 21.1.8, 64-bit server # [694408.863376] server postgres[350]: [350] LOG: listening on IPv6 address "::1", port 5432 server # [694408.863376] server postgres[350]: [350] LOG: listening on IPv4 address "127.0.0.1", port 5432 server # [694408.864890] server postgres[350]: [350] LOG: listening on Unix socket "/run/postgresql/.s.PGSQL.5432" server # [694408.876986] server postgres[356]: [356] LOG: database system was shut down at 2026-09-28 15:26:59 GMT server # [694408.890297] server postgres[350]: [350] LOG: database system is ready to accept connections server # [694408.896651] server systemd[1]: Started PostgreSQL Server. server # [694408.898832] server systemd[1]: Starting PostgreSQL Setup Scripts... server # [694409.134088] server postgresql-setup-start[367]: CREATE DATABASE server # [694409.169609] server postgresql-setup-start[372]: CREATE ROLE server # [694409.172491] server systemd[1]: Finished PostgreSQL Setup Scripts. server # [694409.173342] server systemd[1]: Reached target PostgreSQL. server # [694409.175013] server systemd[1]: Starting Mobilizon PostgreSQL setup... server # [694409.820300] server mobilizon-postgresql-start[376]: CREATE EXTENSION server # [694409.821062] server mobilizon-postgresql-start[376]: CREATE EXTENSION server # [694409.821062] server mobilizon-postgresql-start[376]: CREATE EXTENSION server # [694409.835777] server mobilizon-postgresql-start[378]: ALTER DATABASE server # [694409.837303] server systemd[1]: mobilizon-postgresql.service: Deactivated successfully. server # [694409.868308] server systemd[1]: Finished Mobilizon PostgreSQL setup. server # [694409.871507] server systemd[1]: Starting Mobilizon setup secrets... server # [694409.888199] server mobilizon-setup-secrets-start[381]: + '[' '!' -f /var/lib/mobilizon/secret-env.sh ']' server # [694409.888842] server mobilizon-setup-secrets-start[381]: + install -m 600 /dev/null /var/lib/mobilizon/secret-env.sh server # [694409.891144] server mobilizon-setup-secrets-start[381]: + cat server # [694409.892501] server mobilizon-setup-secrets-start[385]: ++ /nix/store/78jap01pznr5vx54mw7vxy2i850sjfmi-elixir-1.18.4/bin/elixir --eval 'IO.puts(:crypto.strong_rand_bytes(64)|> Base.encode64()|> binary_part(0, 64))' server # [694410.368672] server mobilizon-setup-secrets-start[433]: ++ /nix/store/78jap01pznr5vx54mw7vxy2i850sjfmi-elixir-1.18.4/bin/elixir --eval 'IO.puts(:crypto.strong_rand_bytes(64)|> Base.encode64()|> binary_part(0, 64))' server # [694410.854617] server mobilizon-setup-secrets-start[481]: ++ /nix/store/78jap01pznr5vx54mw7vxy2i850sjfmi-elixir-1.18.4/bin/elixir --eval 'IO.puts(Base.encode32(:crypto.strong_rand_bytes(32)))' server # [694411.340807] server systemd[1]: mobilizon-setup-secrets.service: Deactivated successfully. server # [694411.341132] server systemd[1]: Finished Mobilizon setup secrets. server # [694411.341433] server systemd[1]: mobilizon-setup-secrets.service: Consumed 1.894s CPU time over 1.469s wall clock time. server # [694411.344307] server systemd[1]: Starting Mobilizon federated organization and mobilization platform... server # [694412.342729] server mobilizon_ctl[536]: Loading app.. server # [694412.343848] server mobilizon_ctl[536]: Starting dependencies.. server # [694415.244247] server mobilizon_ctl[536]: ######################################################### server # [694415.244247] server mobilizon_ctl[536]: # If the CREATE EXTENSION or DROP EXTENSION calls fail, # server # [694415.244247] server mobilizon_ctl[536]: # please manually execute them with an authorized # server # [694415.244247] server mobilizon_ctl[536]: # PostgreSQL user with SUPER USER role. # server # [694415.244247] server mobilizon_ctl[536]: ######################################################### server # [694415.244247] server mobilizon_ctl[536]: server # [694415.244247] server mobilizon_ctl[536]: server # [694415.244247] server mobilizon_ctl[536]: 15:27:09.963 [info] == Running 20180109150000 Mobilizon.Repo.Migrations.Prerequites.up/0 forward server # [694415.245777] server mobilizon_ctl[536]: 15:27:09.966 [info] execute "CREATE TYPE datetimetz AS (\n dt timestamptz,\n tz varchar\n);\n" server # [694415.247354] server mobilizon_ctl[536]: 15:27:09.968 [info] execute "CREATE EXTENSION IF NOT EXISTS postgis" server # [694415.247938] server mobilizon_ctl[536]: 15:27:09.969 [info] extension "postgis" already exists, skipping server # [694415.248241] server mobilizon_ctl[536]: 15:27:09.969 [info] execute "CREATE EXTENSION IF NOT EXISTS pg_trgm" server # [694415.248443] server mobilizon_ctl[536]: 15:27:09.969 [info] extension "pg_trgm" already exists, skipping server # [694415.248443] server mobilizon_ctl[536]: 15:27:09.969 [info] execute "CREATE EXTENSION IF NOT EXISTS unaccent" server # [694415.248631] server mobilizon_ctl[536]: 15:27:09.969 [info] extension "unaccent" already exists, skipping server # [694415.250749] server mobilizon_ctl[536]: 15:27:09.971 [info] == Migrated 20180109150000 in 0.0s server # [694415.293236] server mobilizon_ctl[536]: 15:27:10.014 [info] == Running 20180109165738 Mobilizon.Repo.Migrations.CreateAccounts.change/0 forward server # [694415.293556] server mobilizon_ctl[536]: 15:27:10.014 [info] create table accounts server # [694415.297405] server mobilizon_ctl[536]: 15:27:10.018 [info] create index accounts_username_domain_index server # [694415.298301] server mobilizon_ctl[536]: 15:27:10.019 [info] == Migrated 20180109165738 in 0.0s server # [694415.305277] server mobilizon_ctl[536]: 15:27:10.026 [info] == Running 20180109170315 Mobilizon.Repo.Migrations.CreateUsers.change/0 forward server # [694415.305509] server mobilizon_ctl[536]: 15:27:10.026 [info] create table users server # [694415.309895] server mobilizon_ctl[536]: 15:27:10.031 [info] create index users_email_index server # [694415.311181] server mobilizon_ctl[536]: 15:27:10.032 [info] == Migrated 20180109170315 in 0.0s server # [694415.315067] server mobilizon_ctl[536]: 15:27:10.036 [info] == Running 20180110091747 Mobilizon.Repo.Migrations.CreateCategories.change/0 forward server # [694415.315310] server mobilizon_ctl[536]: 15:27:10.036 [info] create table categories server # [694415.318439] server mobilizon_ctl[536]: 15:27:10.039 [info] create index categories_title_index server # [694415.319884] server mobilizon_ctl[536]: 15:27:10.041 [info] == Migrated 20180110091747 in 0.0s server # [694415.325273] server mobilizon_ctl[536]: 15:27:10.046 [info] == Running 20180110092400 Mobilizon.Repo.Migrations.CreateAddresses.change/0 forward server # [694415.325498] server mobilizon_ctl[536]: 15:27:10.046 [info] create table addresses server # [694415.329275] server mobilizon_ctl[536]: 15:27:10.050 [info] == Migrated 20180110092400 in 0.0s server # [694415.336341] server mobilizon_ctl[536]: 15:27:10.057 [info] == Running 20180110092500 Mobilizon.Repo.Migrations.CreateGroups.change/0 forward server # [694415.336868] server mobilizon_ctl[536]: 15:27:10.057 [info] create table groups server # [694415.341220] server mobilizon_ctl[536]: 15:27:10.062 [info] create index groups_slug_index server # [694415.342532] server mobilizon_ctl[536]: 15:27:10.063 [info] == Migrated 20180110092500 in 0.0s server # [694415.354632] server mobilizon_ctl[536]: 15:27:10.075 [info] == Running 20180110092600 Mobilizon.Repo.Migrations.CreateEvents.change/0 forward server # [694415.355399] server mobilizon_ctl[536]: 15:27:10.076 [info] create table events server # [694415.361290] server mobilizon_ctl[536]: 15:27:10.082 [info] create index events_organizer_account_id_index server # [694415.362192] server mobilizon_ctl[536]: 15:27:10.083 [info] create index events_organizer_group_id_index server # [694415.363077] server mobilizon_ctl[536]: 15:27:10.084 [info] create index events_slug_index server # [694415.364156] server mobilizon_ctl[536]: 15:27:10.085 [info] == Migrated 20180110092600 in 0.0s server # [694415.371481] server mobilizon_ctl[536]: 15:27:10.092 [info] == Running 20180110093905 Mobilizon.Repo.Migrations.CreateTags.change/0 forward server # [694415.371786] server mobilizon_ctl[536]: 15:27:10.092 [info] create table tags server # [694415.374998] server mobilizon_ctl[536]: 15:27:10.096 [info] create index tags_slug_index server # [694415.376065] server mobilizon_ctl[536]: 15:27:10.097 [info] == Migrated 20180110093905 in 0.0s server # [694415.384996] server mobilizon_ctl[536]: 15:27:10.106 [info] == Running 20180110093906 Mobilizon.Repo.Migrations.CreateEventsTags.change/0 forward server # [694415.385205] server mobilizon_ctl[536]: 15:27:10.106 [info] create table events_tags server # [694415.389148] server mobilizon_ctl[536]: 15:27:10.109 [info] == Migrated 20180110093906 in 0.0s server # [694415.394639] server mobilizon_ctl[536]: 15:27:10.115 [info] == Running 20180110094301 Mobilizon.Repo.Migrations.CreateParticipants.change/0 forward server # [694415.395108] server mobilizon_ctl[536]: 15:27:10.116 [info] create table participants server # [694415.398845] server mobilizon_ctl[536]: 15:27:10.119 [info] create index participants_event_id_index server # [694415.399845] server mobilizon_ctl[536]: 15:27:10.120 [info] create index participants_account_id_index server # [694415.401272] server mobilizon_ctl[536]: 15:27:10.122 [info] == Migrated 20180110094301 in 0.0s server # [694415.406105] server mobilizon_ctl[536]: 15:27:10.127 [info] == Running 20180110094502 Mobilizon.Repo.Migrations.CreateEventRequests.change/0 forward server # [694415.406437] server mobilizon_ctl[536]: 15:27:10.127 [info] create table event_requests server # [694415.410167] server mobilizon_ctl[536]: 15:27:10.131 [info] create index event_requests_event_id_index server # [694415.411416] server mobilizon_ctl[536]: 15:27:10.132 [info] create index event_requests_account_id_index server # [694415.412459] server mobilizon_ctl[536]: 15:27:10.133 [info] == Migrated 20180110094502 in 0.0s server # [694415.420606] server mobilizon_ctl[536]: 15:27:10.141 [info] == Running 20180110095317 Mobilizon.Repo.Migrations.CreateMembers.change/0 forward server # [694415.420796] server mobilizon_ctl[536]: 15:27:10.142 [info] create table members server # [694415.423373] server mobilizon_ctl[536]: 15:27:10.144 [info] create index members_group_id_index server # [694415.424326] server mobilizon_ctl[536]: 15:27:10.145 [info] create index members_account_id_index server # [694415.425349] server mobilizon_ctl[536]: 15:27:10.146 [info] == Migrated 20180110095317 in 0.0s server # [694415.433367] server mobilizon_ctl[536]: 15:27:10.154 [info] == Running 20180110095515 Mobilizon.Repo.Migrations.CreateGroupRequests.change/0 forward server # [694415.433762] server mobilizon_ctl[536]: 15:27:10.154 [info] create table group_requests server # [694415.436977] server mobilizon_ctl[536]: 15:27:10.158 [info] create index group_requests_group_id_index server # [694415.437992] server mobilizon_ctl[536]: 15:27:10.159 [info] create index group_requests_account_id_index server # [694415.439377] server mobilizon_ctl[536]: 15:27:10.160 [info] == Migrated 20180110095515 in 0.0s server # [694415.446534] server mobilizon_ctl[536]: 15:27:10.167 [info] == Running 20180110165029 Mobilizon.Repo.Migrations.Guardian.DB.change/0 forward server # [694415.446856] server mobilizon_ctl[536]: 15:27:10.168 [info] create table guardian_tokens server # [694415.449909] server mobilizon_ctl[536]: 15:27:10.171 [info] == Migrated 20180110165029 in 0.0s server # [694415.455586] server mobilizon_ctl[536]: 15:27:10.176 [info] == Running 20180112100000 Mobilizon.Repo.Migrations.CreateTracks.change/0 forward server # [694415.455869] server mobilizon_ctl[536]: 15:27:10.177 [info] create table tracks server # [694415.459359] server mobilizon_ctl[536]: 15:27:10.180 [info] == Migrated 20180112100000 in 0.0s server # [694415.466727] server mobilizon_ctl[536]: 15:27:10.187 [info] == Running 20180112105354 Mobilizon.Repo.Migrations.CreateSessions.change/0 forward server # [694415.467209] server mobilizon_ctl[536]: 15:27:10.188 [info] create table sessions server # [694415.472115] server mobilizon_ctl[536]: 15:27:10.193 [info] == Migrated 20180112105354 in 0.0s server # [694415.479465] server mobilizon_ctl[536]: 15:27:10.200 [info] == Running 20180430071244 Mobilizon.Repo.Migrations.RemoveUri.up/0 forward server # [694415.479631] server mobilizon_ctl[536]: 15:27:10.200 [info] alter table accounts server # [694415.480569] server mobilizon_ctl[536]: 15:27:10.201 [info] alter table groups server # [694415.481209] server mobilizon_ctl[536]: 15:27:10.202 [info] == Migrated 20180430071244 in 0.0s server # [694415.486932] server mobilizon_ctl[536]: 15:27:10.208 [info] == Running 20180515091106 Mobilizon.Repo.Migrations.AddUrlFieldToEvents.up/0 forward server # [694415.487220] server mobilizon_ctl[536]: 15:27:10.208 [info] alter table events server # [694415.488550] server mobilizon_ctl[536]: 15:27:10.209 [info] == Migrated 20180515091106 in 0.0s server # [694415.494726] server mobilizon_ctl[536]: 15:27:10.215 [info] == Running 20180515100237 Mobilizon.Repo.Migrations.CreateComments.change/0 forward server # [694415.495348] server mobilizon_ctl[536]: 15:27:10.216 [info] create table comments server # [694415.499950] server mobilizon_ctl[536]: 15:27:10.220 [info] == Migrated 20180515100237 in 0.0s server # [694415.507342] server mobilizon_ctl[536]: 15:27:10.228 [info] == Running 20180515142835 Mobilizon.Repo.Migrations.AlterEventTimestampsToDateTimeWithTimeZone.up/0 forward server # [694415.507512] server mobilizon_ctl[536]: 15:27:10.228 [info] alter table events server # [694415.508402] server mobilizon_ctl[536]: 15:27:10.229 [info] == Migrated 20180515142835 in 0.0s server # [694415.513912] server mobilizon_ctl[536]: 15:27:10.235 [info] == Running 20180515145438 Mobilizon.Repo.Migrations.AddLocalAttributeToEventsAndComments.up/0 forward server # [694415.514134] server mobilizon_ctl[536]: 15:27:10.235 [info] alter table events server # [694415.515194] server mobilizon_ctl[536]: 15:27:10.236 [info] alter table comments server # [694415.517012] server mobilizon_ctl[536]: 15:27:10.238 [info] == Migrated 20180515145438 in 0.0s server # [694415.524835] server mobilizon_ctl[536]: 15:27:10.245 [info] == Running 20180517100700 Mobilizon.Repo.Migrations.MoveFromAccountToActor.up/0 forward server # [694415.528176] server mobilizon_ctl[536]: 15:27:10.249 [info] drop table event_requests server # [694415.530187] server mobilizon_ctl[536]: 15:27:10.251 [info] drop table group_requests server # [694415.531692] server mobilizon_ctl[536]: 15:27:10.252 [info] alter table events server # [694415.532888] server mobilizon_ctl[536]: 15:27:10.253 [info] rename column account_id to actor_id on table members server # [694415.533737] server mobilizon_ctl[536]: 15:27:10.254 [info] alter table members server # [694415.535961] server mobilizon_ctl[536]: 15:27:10.256 [info] drop table groups server # [694415.537321] server mobilizon_ctl[536]: 15:27:10.258 [info] rename table accounts to actors server # [694415.537626] server mobilizon_ctl[536]: 15:27:10.258 [info] execute "CREATE TYPE public.actor_type AS ENUM ('Person', 'Application', 'Group', 'Organization', 'Service')" server # [694415.538558] server mobilizon_ctl[536]: 15:27:10.259 [info] rename column username to name on table actors server # [694415.539054] server mobilizon_ctl[536]: 15:27:10.260 [info] rename column description to summary on table actors server # [694415.539564] server mobilizon_ctl[536]: 15:27:10.260 [info] rename column display_name to preferred_username on table actors server # [694415.539711] server mobilizon_ctl[536]: 15:27:10.260 [info] alter table actors server # [694415.541696] server mobilizon_ctl[536]: 15:27:10.262 [info] create index actors_preferred_username_domain_index server # [694415.542776] server mobilizon_ctl[536]: 15:27:10.263 [info] rename column organizer_account_id to organizer_actor_id on table events server # [694415.543293] server mobilizon_ctl[536]: 15:27:10.264 [info] rename column account_id to actor_id on table participants server # [694415.543626] server mobilizon_ctl[536]: 15:27:10.264 [info] create table followers server # [694415.546531] server mobilizon_ctl[536]: 15:27:10.267 [info] rename column account_id to actor_id on table comments server # [694415.546925] server mobilizon_ctl[536]: 15:27:10.268 [info] rename column account_id to actor_id on table users server # [694415.547416] server mobilizon_ctl[536]: 15:27:10.268 [info] == Migrated 20180517100700 in 0.0s server # [694415.557464] server mobilizon_ctl[536]: 15:27:10.278 [info] == Running 20180522133844 Mobilizon.Repo.Migrations.AddBotsTable.up/0 forward server # [694415.558117] server mobilizon_ctl[536]: 15:27:10.279 [info] create table bots server # [694415.564897] server mobilizon_ctl[536]: 15:27:10.285 [info] == Migrated 20180522133844 in 0.0s server # [694415.574527] server mobilizon_ctl[536]: 15:27:10.294 [info] == Running 20180530125159 Mobilizon.Repo.Migrations.AddAvatarAndBannerToActor.up/0 forward server # [694415.574937] server mobilizon_ctl[536]: 15:27:10.294 [info] alter table actors server # [694415.575776] server mobilizon_ctl[536]: 15:27:10.296 [info] == Migrated 20180530125159 in 0.0s server # [694415.579856] server mobilizon_ctl[536]: 15:27:10.301 [info] == Running 20180530152323 Mobilizon.Repo.Migrations.MakeActorPublicKeyNullable.up/0 forward server # [694415.580029] server mobilizon_ctl[536]: 15:27:10.301 [info] alter table actors server # [694415.580982] server mobilizon_ctl[536]: 15:27:10.302 [info] == Migrated 20180530152323 in 0.0s server # [694415.589475] server mobilizon_ctl[536]: 15:27:10.310 [info] == Running 20180530170808 Mobilizon.Repo.Migrations.AddUUIDIdToEvents.up/0 forward server # [694415.589649] server mobilizon_ctl[536]: 15:27:10.310 [info] alter table events server # [694415.590378] server mobilizon_ctl[536]: 15:27:10.311 [info] == Migrated 20180530170808 in 0.0s server # [694415.596238] server mobilizon_ctl[536]: 15:27:10.317 [info] == Running 20180531162301 Mobilizon.Repo.Migrations.AddApprovedStatusToMember.up/0 forward server # [694415.596435] server mobilizon_ctl[536]: 15:27:10.317 [info] alter table members server # [694415.598179] server mobilizon_ctl[536]: 15:27:10.319 [info] == Migrated 20180531162301 in 0.0s server # [694415.604658] server mobilizon_ctl[536]: 15:27:10.325 [info] == Running 20180607095732 Mobilizon.Repo.Migrations.AddUUIDToComments.up/0 forward server # [694415.604841] server mobilizon_ctl[536]: 15:27:10.326 [info] alter table comments server # [694415.605769] server mobilizon_ctl[536]: 15:27:10.326 [info] == Migrated 20180607095732 in 0.0s server # [694415.611190] server mobilizon_ctl[536]: 15:27:10.332 [info] == Running 20180614094653 Mobilizon.Repo.Migrations.MakeSharedInboxUrlNullable.up/0 forward server # [694415.611394] server mobilizon_ctl[536]: 15:27:10.332 [info] alter table actors server # [694415.612723] server mobilizon_ctl[536]: 15:27:10.333 [info] == Migrated 20180614094653 in 0.0s server # [694415.617753] server mobilizon_ctl[536]: 15:27:10.338 [info] == Running 20180614104618 Mobilizon.Repo.Migrations.FusionPublicPrivateKeyIntoKeysColumn.up/0 forward server # [694415.617912] server mobilizon_ctl[536]: 15:27:10.339 [info] rename column private_key to keys on table actors server # [694415.618715] server mobilizon_ctl[536]: 15:27:10.339 [info] alter table actors server # [694415.619394] server mobilizon_ctl[536]: 15:27:10.340 [info] == Migrated 20180614104618 in 0.0s server # [694415.628854] server mobilizon_ctl[536]: 15:27:10.349 [info] == Running 20180614131328 Mobilizon.Repo.Migrations.AddAttributedToFieldToEventsAndComments.up/0 forward server # [694415.629124] server mobilizon_ctl[536]: 15:27:10.350 [info] alter table events server # [694415.632683] server mobilizon_ctl[536]: 15:27:10.353 [info] alter table comments server # [694415.634430] server mobilizon_ctl[536]: 15:27:10.355 [info] == Migrated 20180614131328 in 0.0s server # [694415.640438] server mobilizon_ctl[536]: 15:27:10.361 [info] == Running 20180628091920 :"Elixir.Mobilizon.Repo.Migrations.Add-user-confirm-email-fields".up/0 forward server # [694415.640746] server mobilizon_ctl[536]: 15:27:10.361 [info] alter table users server # [694415.641534] server mobilizon_ctl[536]: 15:27:10.362 [info] create index index_unique_users_confirmation_token server # [694415.642708] server mobilizon_ctl[536]: 15:27:10.363 [info] == Migrated 20180628091920 in 0.0s server # [694415.650939] server mobilizon_ctl[536]: 15:27:10.372 [info] == Running 20180628130746 :"Elixir.Mobilizon.Repo.Migrations.Add-user-password-reset-fields".up/0 forward server # [694415.651145] server mobilizon_ctl[536]: 15:27:10.372 [info] alter table users server # [694415.651849] server mobilizon_ctl[536]: 15:27:10.372 [info] create index index_unique_users_reset_password_token server # [694415.653281] server mobilizon_ctl[536]: 15:27:10.374 [info] == Migrated 20180628130746 in 0.0s server # [694415.659401] server mobilizon_ctl[536]: 15:27:10.380 [info] == Running 20180628142835 Mobilizon.Repo.Migrations.RevertAlterEventTimestampsToDateTimeWithTimeZone.up/0 forward server # [694415.659794] server mobilizon_ctl[536]: 15:27:10.380 [info] alter table events server # [694415.660756] server mobilizon_ctl[536]: 15:27:10.381 [info] == Migrated 20180628142835 in 0.0s server # [694415.666169] server mobilizon_ctl[536]: 15:27:10.387 [info] == Running 20180702150922 Mobilizon.Repo.Migrations.AddAddressType.up/0 forward server # [694415.666487] server mobilizon_ctl[536]: 15:27:10.387 [info] alter table events server # [694415.667402] server mobilizon_ctl[536]: 15:27:10.388 [info] drop constraint events_address_id_fkey from table events server # [694415.668454] server mobilizon_ctl[536]: 15:27:10.389 [info] rename column address_id to physical_address_id on table events server # [694415.668888] server mobilizon_ctl[536]: 15:27:10.390 [info] alter table events server # [694415.670504] server mobilizon_ctl[536]: 15:27:10.391 [info] == Migrated 20180702150922 in 0.0s server # [694415.676607] server mobilizon_ctl[536]: 15:27:10.397 [info] == Running 20180702154630 Mobilizon.Repo.Migrations.RemoveSlugForEvent.up/0 forward server # [694415.676842] server mobilizon_ctl[536]: 15:27:10.397 [info] alter table events server # [694415.677650] server mobilizon_ctl[536]: 15:27:10.398 [info] == Migrated 20180702154630 in 0.0s server # [694415.685178] server mobilizon_ctl[536]: 15:27:10.406 [info] == Running 20180706082208 Mobilizon.Repo.Migrations.AlterEventsSetDescriptionAsText.up/0 forward server # [694415.685371] server mobilizon_ctl[536]: 15:27:10.406 [info] alter table events server # [694415.686312] server mobilizon_ctl[536]: 15:27:10.407 [info] == Migrated 20180706082208 in 0.0s server # [694415.689573] server mobilizon_ctl[536]: 15:27:10.410 [info] == Running 20180709154152 Mobilizon.Repo.Migrations.AllowMultipleAccountsForUser.up/0 forward server # [694415.689767] server mobilizon_ctl[536]: 15:27:10.411 [info] alter table actors server # [694415.691872] server mobilizon_ctl[536]: 15:27:10.413 [info] alter table users server # [694415.692951] server mobilizon_ctl[536]: 15:27:10.414 [info] == Migrated 20180709154152 in 0.0s server # [694415.699171] server mobilizon_ctl[536]: 15:27:10.420 [info] == Running 20180802133951 Mobilizon.Repo.Migrations.MakeFollowerTableUnique.up/0 forward server # [694415.699359] server mobilizon_ctl[536]: 15:27:10.420 [info] create index followers_actor_target_actor_unique_index server # [694415.701279] server mobilizon_ctl[536]: 15:27:10.422 [info] == Migrated 20180802133951 in 0.0s server # [694415.708841] server mobilizon_ctl[536]: 15:27:10.430 [info] == Running 20180816093446 Mobilizon.Repo.Migrations.AddPrimaryKeyToMember.up/0 forward server # [694415.709047] server mobilizon_ctl[536]: 15:27:10.430 [info] execute "ALTER TABLE members DROP CONSTRAINT IF EXISTS members_pkey" server # [694415.709663] server mobilizon_ctl[536]: 15:27:10.430 [info] constraint "members_pkey" of relation "members" does not exist, skipping server # [694415.709663] server mobilizon_ctl[536]: 15:27:10.430 [info] drop index if exists members_members_account_id_index_index server # [694415.710198] server mobilizon_ctl[536]: 15:27:10.431 [info] index "members_members_account_id_index_index" does not exist, skipping server # [694415.710198] server mobilizon_ctl[536]: 15:27:10.431 [info] create index members_actor_parent_unique_index server # [694415.711775] server mobilizon_ctl[536]: 15:27:10.432 [info] alter table members server # [694415.715892] server mobilizon_ctl[536]: 15:27:10.436 [info] == Migrated 20180816093446 in 0.0s server # [694415.721776] server mobilizon_ctl[536]: 15:27:10.442 [info] == Running 20181021161324 Mobilizon.Repo.Migrations.AddDefaultActorUserField.up/0 forward server # [694415.722010] server mobilizon_ctl[536]: 15:27:10.443 [info] alter table users server # [694415.722719] server mobilizon_ctl[536]: 15:27:10.443 [info] == Migrated 20181021161324 in 0.0s server # [694415.725201] server mobilizon_ctl[536]: 15:27:10.446 [info] == Running 20181108165151 Mobilizon.Repo.Migrations.FixCommentsReferences.up/0 forward server # [694415.725349] server mobilizon_ctl[536]: 15:27:10.446 [info] drop constraint comments_in_reply_to_comment_id_fkey from table comments server # [694415.725964] server mobilizon_ctl[536]: 15:27:10.447 [info] drop constraint comments_origin_comment_id_fkey from table comments server # [694415.727707] server mobilizon_ctl[536]: 15:27:10.447 [info] alter table comments server # [694415.728871] server mobilizon_ctl[536]: 15:27:10.450 [info] == Migrated 20181108165151 in 0.0s server # [694415.735988] server mobilizon_ctl[536]: 15:27:10.457 [info] == Running 20181203092128 Mobilizon.Repo.Migrations.ChangeActorsIndexes.up/0 forward server # [694415.736314] server mobilizon_ctl[536]: 15:27:10.457 [info] drop index actors_preferred_username_domain_index server # [694415.737281] server mobilizon_ctl[536]: 15:27:10.458 [info] drop index accounts_username_domain_index server # [694415.737808] server mobilizon_ctl[536]: 15:27:10.458 [info] execute "ALTER INDEX accounts_pkey RENAME TO actors_pkey" server # [694415.739116] server mobilizon_ctl[536]: 15:27:10.459 [info] create index actors_preferred_username_domain_type_index server # [694415.740500] server mobilizon_ctl[536]: 15:27:10.461 [info] create index actors_url_index server # [694415.741537] server mobilizon_ctl[536]: 15:27:10.462 [info] == Migrated 20181203092128 in 0.0s server # [694415.749306] server mobilizon_ctl[536]: 15:27:10.470 [info] == Running 20190103150805 Mobilizon.Repo.Migrations.FixEventVisibility.up/0 forward server # [694415.749471] server mobilizon_ctl[536]: 15:27:10.470 [info] execute "CREATE TYPE public.event_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')" server # [694415.750278] server mobilizon_ctl[536]: 15:27:10.471 [info] execute "CREATE TYPE public.event_status AS ENUM ('tentative', 'confirmed', 'cancelled')" server # [694415.750854] server mobilizon_ctl[536]: 15:27:10.472 [info] execute "CREATE TYPE public.comment_visibility AS ENUM ('public', 'unlisted', 'private', 'moderated', 'invite')" server # [694415.751570] server mobilizon_ctl[536]: 15:27:10.472 [info] alter table events server # [694415.754943] server mobilizon_ctl[536]: 15:27:10.476 [info] alter table comments server # [694415.755616] server mobilizon_ctl[536]: 15:27:10.476 [info] == Migrated 20190103150805 in 0.0s server # [694415.758512] server mobilizon_ctl[536]: 15:27:10.479 [info] == Running 20190114162055 Mobilizon.Repo.Migrations.RemoveAddressType.up/0 forward server # [694415.758628] server mobilizon_ctl[536]: 15:27:10.479 [info] execute "ALTER TABLE \"events\" DROP COLUMN IF EXISTS address_type" server # [694415.759215] server mobilizon_ctl[536]: 15:27:10.480 [info] column "address_type" of relation "events" does not exist, skipping server # [694415.759286] server mobilizon_ctl[536]: 15:27:10.480 [info] execute "DROP TYPE IF EXISTS address_type" server # [694415.759574] server mobilizon_ctl[536]: 15:27:10.480 [info] type "address_type" does not exist, skipping server # [694415.759574] server mobilizon_ctl[536]: 15:27:10.480 [info] rename column phone to phone_address on table events server # [694415.759947] server mobilizon_ctl[536]: 15:27:10.481 [info] == Migrated 20190114162055 in 0.0s server # [694415.773851] server mobilizon_ctl[536]: 15:27:10.495 [info] == Running 20190125143718 Mobilizon.Repo.Migrations.GroupDeleteMembersCascade.change/0 forward server # [694415.774173] server mobilizon_ctl[536]: 15:27:10.495 [info] drop constraint members_account_id_fkey from table members server # [694415.775592] server mobilizon_ctl[536]: 15:27:10.496 [info] drop constraint members_parent_id_fkey from table members server # [694415.777112] server mobilizon_ctl[536]: 15:27:10.498 [info] alter table members server # [694415.780430] server mobilizon_ctl[536]: 15:27:10.501 [info] == Migrated 20190125143718 in 0.0s server # [694415.788483] server mobilizon_ctl[536]: 15:27:10.509 [info] == Running 20190130151607 Mobilizon.Repo.Migrations.SplitEventVisibilityAndJoinOptions.up/0 forward server # [694415.788722] server mobilizon_ctl[536]: 15:27:10.509 [info] execute "ALTER TABLE events ALTER COLUMN visibility TYPE VARCHAR USING visibility::text" server # [694415.796543] server mobilizon_ctl[536]: 15:27:10.517 [info] execute "DROP TYPE public.event_visibility" server # [694415.796884] server mobilizon_ctl[536]: 15:27:10.518 [info] execute "CREATE TYPE public.event_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')" server # [694415.797876] server mobilizon_ctl[536]: 15:27:10.518 [info] execute "ALTER TABLE events ALTER COLUMN visibility TYPE event_visibility USING visibility::event_visibility" server # [694415.800692] server mobilizon_ctl[536]: 15:27:10.521 [info] execute "CREATE TYPE public.join_options AS ENUM ('free', 'restricted', 'invite', 'external')" server # [694415.801441] server mobilizon_ctl[536]: 15:27:10.522 [info] alter table events server # [694415.802970] server mobilizon_ctl[536]: 15:27:10.524 [info] execute "UPDATE events SET visibility = 'public' WHERE visibility IS NULL" server # [694415.803489] server mobilizon_ctl[536]: 15:27:10.524 [info] alter table events server # [694415.804720] server mobilizon_ctl[536]: 15:27:10.525 [info] == Migrated 20190130151607 in 0.0s server # [694415.810300] server mobilizon_ctl[536]: 15:27:10.531 [info] == Running 20190207134142 Mobilizon.Repo.Migrations.MoveParticipantRoleToEnum.up/0 forward server # [694415.810547] server mobilizon_ctl[536]: 15:27:10.531 [info] execute "CREATE TYPE public.participant_role AS ENUM ('not_approved', 'not_confirmed', 'rejected', 'participant', 'moderator', 'administrator', 'creator')" server # [694415.811207] server mobilizon_ctl[536]: 15:27:10.532 [info] alter table participants server # [694415.811976] server mobilizon_ctl[536]: 15:27:10.533 [info] execute "UPDATE participants set role_tmp = 'not_approved' where role = 0" server # [694415.813023] server mobilizon_ctl[536]: 15:27:10.534 [info] execute "UPDATE participants set role_tmp = 'participant' where role = 1" server # [694415.813774] server mobilizon_ctl[536]: 15:27:10.534 [info] execute "UPDATE participants set role_tmp = 'moderator' where role = 2" server # [694415.814133] server mobilizon_ctl[536]: 15:27:10.535 [info] execute "UPDATE participants set role_tmp = 'administrator' where role = 3" server # [694415.814599] server mobilizon_ctl[536]: 15:27:10.535 [info] execute "UPDATE participants set role_tmp = 'creator' where role = 4" server # [694415.814922] server mobilizon_ctl[536]: 15:27:10.536 [info] alter table participants server # [694415.816428] server mobilizon_ctl[536]: 15:27:10.536 [info] rename column role_tmp to role on table participants server # [694415.816428] server mobilizon_ctl[536]: 15:27:10.536 [info] == Migrated 20190207134142 in 0.0s server # [694415.821231] server mobilizon_ctl[536]: 15:27:10.542 [info] == Running 20190208141700 Mobilizon.Repo.Migrations.TagsRelations.up/0 forward server # [694415.821525] server mobilizon_ctl[536]: 15:27:10.542 [info] create table tag_relations server # [694415.824234] server mobilizon_ctl[536]: 15:27:10.545 [info] create check constraint no_self_loops_check on table tag_relations server # [694415.825043] server mobilizon_ctl[536]: 15:27:10.546 [info] create index index_tag_relations_tag_id server # [694415.826711] server mobilizon_ctl[536]: 15:27:10.547 [info] create index index_tag_relations_link_id server # [694415.827971] server mobilizon_ctl[536]: 15:27:10.549 [info] == Migrated 20190208141700 in 0.0s server # [694415.834032] server mobilizon_ctl[536]: 15:27:10.555 [info] == Running 20190214100858 Mobilizon.Repo.Migrations.DropDatetimetz.up/0 forward server # [694415.834463] server mobilizon_ctl[536]: 15:27:10.555 [info] alter table events server # [694415.835961] server mobilizon_ctl[536]: 15:27:10.557 [info] alter table sessions server # [694415.836837] server mobilizon_ctl[536]: 15:27:10.558 [info] execute "DROP TYPE datetimetz" server # [694415.837550] server mobilizon_ctl[536]: 15:27:10.558 [info] == Migrated 20190214100858 in 0.0s server # [694415.844092] server mobilizon_ctl[536]: ######################################################### server # [694415.844092] server mobilizon_ctl[536]: # If the CREATE EXTENSION or DROP EXTENSION calls fail, # server # [694415.844092] server mobilizon_ctl[536]: # please manually execute them with an authorized # server # [694415.844092] server mobilizon_ctl[536]: # PostgreSQL user with SUPER USER role. # server # [694415.844092] server mobilizon_ctl[536]: ######################################################### server # [694415.844092] server mobilizon_ctl[536]: server # [694415.844092] server mobilizon_ctl[536]: server # [694415.844694] server mobilizon_ctl[536]: 15:27:10.565 [info] == Running 20190219164310 Mobilizon.Repo.Migrations.CreateSearchIndexes.change/0 forward server # [694415.844885] server mobilizon_ctl[536]: 15:27:10.566 [info] execute "CREATE EXTENSION IF NOT EXISTS pg_trgm" server # [694415.845236] server mobilizon_ctl[536]: 15:27:10.566 [info] extension "pg_trgm" already exists, skipping server # [694415.845496] server mobilizon_ctl[536]: 15:27:10.566 [info] execute "CREATE EXTENSION IF NOT EXISTS unaccent" server # [694415.845623] server mobilizon_ctl[536]: 15:27:10.566 [info] extension "unaccent" already exists, skipping server # [694415.845623] server mobilizon_ctl[536]: 15:27:10.566 [info] execute "CREATE OR REPLACE FUNCTION public.f_unaccent(text)\n RETURNS text AS\n$func$\nSELECT public.unaccent('public.unaccent', $1)\n$func$ LANGUAGE sql IMMUTABLE;" server # [694415.846519] server mobilizon_ctl[536]: 15:27:10.567 [info] execute "CREATE INDEX \"event_title_trigram\" ON \"events\" USING GIN (f_unaccent(title) gin_trgm_ops)" server # [694415.848558] server mobilizon_ctl[536]: 15:27:10.569 [info] execute "CREATE INDEX \"actor_preferred_username_trigram\" ON \"actors\"\n USING GIN (f_unaccent(preferred_username) gin_trgm_ops)" server # [694415.849812] server mobilizon_ctl[536]: 15:27:10.570 [info] execute "CREATE INDEX \"actor_name_trigram\" ON \"actors\"\n USING GIN (f_unaccent(name) gin_trgm_ops)" server # [694415.850979] server mobilizon_ctl[536]: 15:27:10.572 [info] == Migrated 20190219164310 in 0.0s server # [694415.854466] server mobilizon_ctl[536]: 15:27:10.575 [info] == Running 20190222151449 Mobilizon.Repo.Migrations.DropCategories.up/0 forward server # [694415.854670] server mobilizon_ctl[536]: 15:27:10.575 [info] alter table events server # [694415.856140] server mobilizon_ctl[536]: 15:27:10.577 [info] drop table categories server # [694415.857472] server mobilizon_ctl[536]: 15:27:10.578 [info] == Migrated 20190222151449 in 0.0s server # [694415.863966] server mobilizon_ctl[536]: 15:27:10.585 [info] == Running 20190301141830 Mobilizon.Repo.Migrations.MoveMemberRoleToEnum.up/0 forward server # [694415.864205] server mobilizon_ctl[536]: 15:27:10.585 [info] execute "CREATE TYPE public.member_role AS ENUM ('invited', 'not_approved', 'member', 'moderator', 'administrator', 'creator', 'rejected')" server # [694415.864974] server mobilizon_ctl[536]: 15:27:10.586 [info] alter table members server # [694415.865716] server mobilizon_ctl[536]: 15:27:10.586 [info] execute "UPDATE members set role_tmp = 'member' where role = 0" server # [694415.866546] server mobilizon_ctl[536]: 15:27:10.587 [info] execute "UPDATE members set role_tmp = 'moderator' where role = 1" server # [694415.867052] server mobilizon_ctl[536]: 15:27:10.588 [info] execute "UPDATE members set role_tmp = 'creator' where role = 2" server # [694415.867786] server mobilizon_ctl[536]: 15:27:10.588 [info] execute "UPDATE members set role_tmp = 'not_approved' where approved is false" server # [694415.868321] server mobilizon_ctl[536]: 15:27:10.589 [info] alter table members server # [694415.869106] server mobilizon_ctl[536]: 15:27:10.590 [info] rename column role_tmp to role on table members server # [694415.869620] server mobilizon_ctl[536]: 15:27:10.590 [info] == Migrated 20190301141830 in 0.0s server # [694415.875745] server mobilizon_ctl[536]: 15:27:10.596 [info] == Running 20190301143831 Mobilizon.Repo.Migrations.ActorGroupOpenness.up/0 forward server # [694415.878982] server mobilizon_ctl[536]: 15:27:10.600 [info] execute "CREATE TYPE public.actor_openness AS ENUM ('invite_only', 'moderated', 'open')" server # [694415.879568] server mobilizon_ctl[536]: 15:27:10.600 [info] alter table actors server # [694415.880635] server mobilizon_ctl[536]: 15:27:10.601 [info] == Migrated 20190301143831 in 0.0s server # [694415.886290] server mobilizon_ctl[536]: 15:27:10.607 [info] == Running 20190307125009 Mobilizon.Repo.Migrations.MoveUserRoleToEnum.up/0 forward server # [694415.886462] server mobilizon_ctl[536]: 15:27:10.607 [info] execute "CREATE TYPE public.user_role AS ENUM ('administrator', 'moderator', 'user', 'pending')" server # [694415.887101] server mobilizon_ctl[536]: 15:27:10.608 [info] alter table users server # [694415.887892] server mobilizon_ctl[536]: 15:27:10.609 [info] execute "UPDATE users set role_tmp = 'user' where role = 0" server # [694415.889096] server mobilizon_ctl[536]: 15:27:10.610 [info] execute "UPDATE users set role_tmp = 'moderator' where role = 1" server # [694415.889578] server mobilizon_ctl[536]: 15:27:10.610 [info] execute "UPDATE users set role_tmp = 'administrator' where role = 2" server # [694415.890298] server mobilizon_ctl[536]: 15:27:10.611 [info] alter table users server # [694415.890810] server mobilizon_ctl[536]: 15:27:10.612 [info] rename column role_tmp to role on table users server # [694415.891543] server mobilizon_ctl[536]: 15:27:10.612 [info] == Migrated 20190307125009 in 0.0s server # [694415.894215] server mobilizon_ctl[536]: 15:27:10.615 [info] == Running 20190307133518 Mobilizon.Repo.Migrations.FeedTokenTable.change/0 forward server # [694415.900826] server mobilizon_ctl[536]: 15:27:10.621 [info] create table feed_tokens server # [694415.904170] server mobilizon_ctl[536]: 15:27:10.625 [info] == Migrated 20190307133518 in 0.0s server # [694415.911065] server mobilizon_ctl[536]: 15:27:10.632 [info] == Running 20190322143724 Mobilizon.Repo.Migrations.RenameAddressFields.change/0 forward server # [694415.911289] server mobilizon_ctl[536]: 15:27:10.632 [info] rename column addressCountry to country on table addresses server # [694415.911975] server mobilizon_ctl[536]: 15:27:10.633 [info] rename column addressLocality to locality on table addresses server # [694415.912461] server mobilizon_ctl[536]: 15:27:10.633 [info] rename column addressRegion to region on table addresses server # [694415.912805] server mobilizon_ctl[536]: 15:27:10.634 [info] rename column postalCode to postal_code on table addresses server # [694415.913662] server mobilizon_ctl[536]: 15:27:10.634 [info] rename column streetAddress to street on table addresses server # [694415.914485] server mobilizon_ctl[536]: 15:27:10.635 [info] == Migrated 20190322143724 in 0.0s server # [694415.917476] server mobilizon_ctl[536]: 15:27:10.638 [info] == Running 20190411124138 Mobilizon.Repo.Migrations.EventAddDescriptionSlug.change/0 forward server # [694415.917662] server mobilizon_ctl[536]: 15:27:10.638 [info] alter table events server # [694415.918719] server mobilizon_ctl[536]: 15:27:10.639 [info] == Migrated 20190411124138 in 0.0s server # [694415.923918] server mobilizon_ctl[536]: 15:27:10.645 [info] == Running 20190411161557 Mobilizon.Repo.Migrations.EventEventTagOnDelete.up/0 forward server # [694415.924151] server mobilizon_ctl[536]: 15:27:10.645 [info] drop constraint events_tags_event_id_fkey from table events_tags server # [694415.925297] server mobilizon_ctl[536]: 15:27:10.646 [info] drop constraint events_tags_tag_id_fkey from table events_tags server # [694415.926177] server mobilizon_ctl[536]: 15:27:10.647 [info] alter table events_tags server # [694415.928648] server mobilizon_ctl[536]: 15:27:10.649 [info] == Migrated 20190411161557 in 0.0s server # [694415.935362] server mobilizon_ctl[536]: 15:27:10.656 [info] == Running 20190425075451 Mobilizon.Repo.Migrations.AddVisibilityToActor.up/0 forward server # [694415.935603] server mobilizon_ctl[536]: 15:27:10.656 [info] execute "CREATE TYPE public.actor_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')" server # [694415.936561] server mobilizon_ctl[536]: 15:27:10.657 [info] alter table actors server # [694415.937545] server mobilizon_ctl[536]: 15:27:10.658 [info] == Migrated 20190425075451 in 0.0s server # [694415.943246] server mobilizon_ctl[536]: 15:27:10.664 [info] == Running 20190426093202 Mobilizon.Repo.Migrations.CreatePictures.up/0 forward server # [694415.943894] server mobilizon_ctl[536]: 15:27:10.664 [info] create table pictures server # [694415.946981] server mobilizon_ctl[536]: 15:27:10.668 [info] alter table actors server # [694415.947834] server mobilizon_ctl[536]: 15:27:10.668 [info] alter table events server # [694415.950038] server mobilizon_ctl[536]: 15:27:10.671 [info] == Migrated 20190426093202 in 0.0s server # [694415.957349] server mobilizon_ctl[536]: 15:27:10.678 [info] == Running 20190531131458 :"Elixir.Mobilizon.Repo.Migrations.Attach-pictures-to-actors".change/0 forward server # [694415.957654] server mobilizon_ctl[536]: 15:27:10.678 [info] alter table pictures server # [694415.960065] server mobilizon_ctl[536]: 15:27:10.681 [info] == Migrated 20190531131458 in 0.0s server # [694415.965483] server mobilizon_ctl[536]: 15:27:10.686 [info] == Running 20190712125833 Mobilizon.Repo.Migrations.CreateReports.up/0 forward server # [694415.972573] server mobilizon_ctl[536]: 15:27:10.693 [info] execute "CREATE TYPE public.report_status AS ENUM ('open', 'closed', 'resolved')" server # [694415.973697] server mobilizon_ctl[536]: 15:27:10.694 [info] create table reports server # [694415.979534] server mobilizon_ctl[536]: 15:27:10.700 [info] create table reports_comments server # [694415.981270] server mobilizon_ctl[536]: 15:27:10.702 [info] == Migrated 20190712125833 in 0.0s server # [694415.991769] server mobilizon_ctl[536]: 15:27:10.712 [info] == Running 20190712132438 Mobilizon.Repo.Migrations.CreateReportNotes.change/0 forward server # [694415.992072] server mobilizon_ctl[536]: 15:27:10.713 [info] create table report_notes server # [694415.995771] server mobilizon_ctl[536]: 15:27:10.716 [info] == Migrated 20190712132438 in 0.0s server # [694416.002590] server mobilizon_ctl[536]: 15:27:10.723 [info] == Running 20190718122556 Mobilizon.Repo.Migrations.CreateAdminActionLogs.change/0 forward server # [694416.002759] server mobilizon_ctl[536]: 15:27:10.723 [info] create table admin_action_logs server # [694416.006513] server mobilizon_ctl[536]: 15:27:10.727 [info] == Migrated 20190718122556 in 0.0s server # [694416.015599] server mobilizon_ctl[536]: 15:27:10.736 [info] == Running 20190729125532 :"Elixir.Mobilizon.Repo.Migrations.Add-url-to-addresses".change/0 forward server # [694416.015824] server mobilizon_ctl[536]: 15:27:10.736 [info] alter table addresses server # [694416.016680] server mobilizon_ctl[536]: 15:27:10.737 [info] == Migrated 20190729125532 in 0.0s server # [694416.022139] server mobilizon_ctl[536]: 15:27:10.743 [info] == Running 20190806131306 Mobilizon.Repo.Migrations.AddUrlToFollowsAndMoveToUuid.up/0 forward server # [694416.022371] server mobilizon_ctl[536]: 15:27:10.743 [info] alter table followers server # [694416.024735] server mobilizon_ctl[536]: 15:27:10.745 [info] == Migrated 20190806131306 in 0.0s server # [694416.031610] server mobilizon_ctl[536]: 15:27:10.752 [info] == Running 20190813160207 Mobilizon.Repo.Migrations.AddUrlAndUuidToParticipants.up/0 forward server # [694416.032512] server mobilizon_ctl[536]: 15:27:10.753 [info] drop index participants_event_id_index server # [694416.033354] server mobilizon_ctl[536]: 15:27:10.754 [info] drop index if exists participants_account_id_index server # [694416.034301] server mobilizon_ctl[536]: 15:27:10.755 [info] drop index if exists participants_actor_id_index server # [694416.034757] server mobilizon_ctl[536]: 15:27:10.755 [info] index "participants_actor_id_index" does not exist, skipping server # [694416.034880] server mobilizon_ctl[536]: 15:27:10.755 [info] drop constraint participants_event_id_fkey from table participants server # [694416.035954] server mobilizon_ctl[536]: 15:27:10.757 [info] drop constraint if exists participants_account_id_fkey from table participants server # [694416.037554] server mobilizon_ctl[536]: 15:27:10.758 [info] drop constraint if exists participants_actor_id_fkey from table participants server # [694416.038073] server mobilizon_ctl[536]: 15:27:10.759 [info] constraint "participants_actor_id_fkey" of relation "participants" does not exist, skipping server # [694416.038170] server mobilizon_ctl[536]: 15:27:10.759 [info] drop constraint participants_pkey from table participants server # [694416.038762] server mobilizon_ctl[536]: 15:27:10.759 [info] alter table participants server # [694416.042857] server mobilizon_ctl[536]: 15:27:10.763 [info] create index participants_event_id_index server # [694416.043684] server mobilizon_ctl[536]: 15:27:10.764 [info] create index participants_actor_id_index server # [694416.045358] server mobilizon_ctl[536]: 15:27:10.766 [info] == Migrated 20190813160207 in 0.0s server # [694416.053407] server mobilizon_ctl[536]: 15:27:10.774 [info] == Running 20190821161658 Mobilizon.Repo.Migrations.AddOriginIdToAddresses.change/0 forward server # [694416.053660] server mobilizon_ctl[536]: 15:27:10.774 [info] alter table addresses server # [694416.054532] server mobilizon_ctl[536]: 15:27:10.775 [info] create index addresses_origin_id_index server # [694416.055772] server mobilizon_ctl[536]: 15:27:10.776 [info] == Migrated 20190821161658 in 0.0s server # [694416.061741] server mobilizon_ctl[536]: 15:27:10.782 [info] == Running 20190823132816 Mobilizon.Repo.Migrations.RemoveEventsWhenDeletingOrganizer.up/0 forward server # [694416.062010] server mobilizon_ctl[536]: 15:27:10.783 [info] drop constraint events_organizer_account_id_fkey from table events server # [694416.063424] server mobilizon_ctl[536]: 15:27:10.784 [info] alter table events server # [694416.066159] server mobilizon_ctl[536]: 15:27:10.787 [info] == Migrated 20190823132816 in 0.0s server # [694416.075013] server mobilizon_ctl[536]: 15:27:10.796 [info] == Running 20190902082656 Mobilizon.Repo.Migrations.AddOptionsToEvent.change/0 forward server # [694416.075172] server mobilizon_ctl[536]: 15:27:10.796 [info] alter table events server # [694416.076370] server mobilizon_ctl[536]: 15:27:10.797 [info] == Migrated 20190902082656 in 0.0s server # [694416.086303] server mobilizon_ctl[536]: 15:27:10.807 [info] == Running 20190929170817 Mobilizon.Storage.Repo.Migrations.RenamePostgresTypes.up/0 forward server # [694416.093353] server mobilizon_ctl[536]: 15:27:10.814 [info] == Migrated 20190929170817 in 0.0s server # [694416.099853] server mobilizon_ctl[536]: 15:27:10.820 [info] == Running 20190929175229 Mobilizon.Storage.Repo.Migrations.AddRejectedToParticipantRole.up/0 forward server # [694416.100076] server mobilizon_ctl[536]: 15:27:10.821 [info] execute "ALTER TYPE public.participant_role ADD VALUE IF NOT EXISTS 'rejected'" server # [694416.100676] server mobilizon_ctl[536]: 15:27:10.821 [info] enum label "rejected" already exists, skipping server # [694416.101059] server mobilizon_ctl[536]: 15:27:10.821 [info] == Migrated 20190929175229 in 0.0s server # [694416.107628] server mobilizon_ctl[536]: 15:27:10.828 [info] == Running 20191001074442 Mobilizon.Storage.Repo.Migrations.AddLocaleToUsers.change/0 forward server # [694416.107870] server mobilizon_ctl[536]: 15:27:10.829 [info] alter table users server # [694416.109659] server mobilizon_ctl[536]: 15:27:10.830 [info] == Migrated 20191001074442 in 0.0s server # [694416.115152] server mobilizon_ctl[536]: 15:27:10.836 [info] == Running 20191002093208 Mobilizon.Storage.Repo.Migrations.AddDraftFlagToEvents.change/0 forward server # [694416.115314] server mobilizon_ctl[536]: 15:27:10.836 [info] alter table events server # [694416.116659] server mobilizon_ctl[536]: 15:27:10.837 [info] == Migrated 20191002093208 in 0.0s server # [694416.123115] server mobilizon_ctl[536]: 15:27:10.844 [info] == Running 20191018075904 Mobilizon.Storage.Repo.Migrations.MoveSQLColumnsFromVarCharToText.up/0 forward server # [694416.123388] server mobilizon_ctl[536]: 15:27:10.844 [info] alter table events server # [694416.127057] server mobilizon_ctl[536]: 15:27:10.848 [info] alter table addresses server # [694416.128051] server mobilizon_ctl[536]: 15:27:10.849 [info] alter table bots server # [694416.128698] server mobilizon_ctl[536]: 15:27:10.849 [info] alter table report_notes server # [694416.129863] server mobilizon_ctl[536]: 15:27:10.851 [info] alter table reports server # [694416.130330] server mobilizon_ctl[536]: 15:27:10.851 [info] alter table sessions server # [694416.131809] server mobilizon_ctl[536]: 15:27:10.852 [info] alter table tracks server # [694416.132842] server mobilizon_ctl[536]: 15:27:10.853 [info] == Migrated 20191018075904 in 0.0s server # [694416.146050] server mobilizon_ctl[536]: 15:27:10.867 [info] == Running 20191022083446 Mobilizon.Storage.Repo.Migrations.AddEagerMaterializedViewForSearchingEvents.up/0 forward server # [694416.146373] server mobilizon_ctl[536]: 15:27:10.867 [info] create table event_search server # [694416.149425] server mobilizon_ctl[536]: 15:27:10.870 [info] create index event_search_document_index server # [694416.150490] server mobilizon_ctl[536]: 15:27:10.871 [info] execute "CREATE INDEX event_search_title_trgm_index ON event_search USING gin (title gin_trgm_ops)" server # [694416.151522] server mobilizon_ctl[536]: 15:27:10.872 [info] create index event_search_id_index server # [694416.152721] server mobilizon_ctl[536]: 15:27:10.873 [info] == Migrated 20191022083446 in 0.0s server # [694416.161577] server mobilizon_ctl[536]: 15:27:10.882 [info] == Running 20191023133805 Mobilizon.Storage.Repo.Migrations.DeleteActorsCascadeToFollowers.up/0 forward server # [694416.161797] server mobilizon_ctl[536]: 15:27:10.882 [info] drop constraint followers_actor_id_fkey from table followers server # [694416.162675] server mobilizon_ctl[536]: 15:27:10.883 [info] drop constraint followers_target_actor_id_fkey from table followers server # [694416.163423] server mobilizon_ctl[536]: 15:27:10.884 [info] alter table followers server # [694416.166977] server mobilizon_ctl[536]: 15:27:10.887 [info] == Migrated 20191023133805 in 0.0s server # [694416.174866] server mobilizon_ctl[536]: 15:27:10.896 [info] == Running 20191023143659 Mobilizon.Storage.Repo.Migrations.MoveParticipantsStatsToEvent.up/0 forward server # [694416.175066] server mobilizon_ctl[536]: 15:27:10.896 [info] alter table events server # [694416.175851] server mobilizon_ctl[536]: 15:27:10.896 [info] == Migrated 20191023143659 in 0.0s server # [694416.183324] server mobilizon_ctl[536]: 15:27:10.904 [info] == Running 20191024204726 Mobilizon.Storage.Repo.Migrations.AddTagsToComments.up/0 forward server # [694416.183805] server mobilizon_ctl[536]: 15:27:10.904 [info] create table comments_tags server # [694416.186984] server mobilizon_ctl[536]: 15:27:10.908 [info] == Migrated 20191024204726 in 0.0s server # [694416.192823] server mobilizon_ctl[536]: 15:27:10.913 [info] == Running 20191025083642 Mobilizon.Storage.Repo.Migrations.AddMentionTables.change/0 forward server # [694416.192823] server mobilizon_ctl[536]: 15:27:10.913 [info] create table mentions server # [694416.197278] server mobilizon_ctl[536]: 15:27:10.918 [info] create index mentions_actor_id_index server # [694416.198772] server mobilizon_ctl[536]: 15:27:10.919 [info] == Migrated 20191025083642 in 0.0s server # [694416.206345] server mobilizon_ctl[536]: 15:27:10.927 [info] == Running 20191025115537 Mobilizon.Storage.Repo.Migrations.AddUniqueIndexOnURLs.change/0 forward server # [694416.206610] server mobilizon_ctl[536]: 15:27:10.927 [info] create index events_url_index server # [694416.208217] server mobilizon_ctl[536]: 15:27:10.929 [info] create index comments_url_index server # [694416.209428] server mobilizon_ctl[536]: 15:27:10.930 [info] == Migrated 20191025115537 in 0.0s server # [694416.215310] server mobilizon_ctl[536]: 15:27:10.936 [info] == Running 20191031142145 Mobilizon.Storage.Repo.Migrations.AddUniqueIndexOnActorAndEventForParticipant.change/0 forward server # [694416.215534] server mobilizon_ctl[536]: 15:27:10.936 [info] create index participants_event_id_actor_id_index server # [694416.216789] server mobilizon_ctl[536]: 15:27:10.937 [info] == Migrated 20191031142145 in 0.0s server # [694416.221925] server mobilizon_ctl[536]: 15:27:10.943 [info] == Running 20191104093447 Mobilizon.Storage.Repo.Migrations.AddObanJobsTable.up/0 forward server # [694416.259688] server mobilizon_ctl[536]: 15:27:10.980 [info] execute "DO $$\nBEGIN\nIF NOT EXISTS (SELECT 1 FROM pg_type\n WHERE typname = 'oban_job_state'\n AND typnamespace = 'public'::regnamespace::oid) THEN\n CREATE TYPE \"public\".oban_job_state AS ENUM (\n 'available',\n 'suspended',\n 'scheduled',\n 'executing',\n 'retryable',\n 'completed',\n 'discarded',\n 'cancelled'\n );\n END IF;\nEND$$;\n" server # [694416.261301] server mobilizon_ctl[536]: 15:27:10.982 [info] create table if not exists public.oban_jobs server # [694416.264682] server mobilizon_ctl[536]: 15:27:10.985 [info] create index if not exists public.oban_jobs_queue_index server # [694416.265796] server mobilizon_ctl[536]: 15:27:10.986 [info] create index if not exists public.oban_jobs_state_index server # [694416.266841] server mobilizon_ctl[536]: 15:27:10.987 [info] create index if not exists public.oban_jobs_scheduled_at_index server # [694416.267660] server mobilizon_ctl[536]: 15:27:10.988 [info] execute "CREATE OR REPLACE FUNCTION \"public\".oban_jobs_notify() RETURNS trigger AS $$\nDECLARE\n channel text;\n notice json;\nBEGIN\n IF (TG_OP = 'INSERT') THEN\n channel = 'public.oban_insert';\n notice = json_build_object('queue', NEW.queue, 'state', NEW.state);\n\n -- No point triggering for a job that isn't scheduled to run now\n IF NEW.scheduled_at IS NOT NULL AND NEW.scheduled_at > now() AT TIME ZONE 'utc' THEN\n RETURN null;\n END IF;\n ELSE\n channel = 'public.oban_update';\n notice = json_build_object('queue', NEW.queue, 'new_state', NEW.state, 'old_state', OLD.state);\n END IF;\n\n PERFORM pg_notify(channel, notice::text);\n\n RETURN NULL;\nEND;\n$$ LANGUAGE plpgsql;\n" server # [694416.268605] server mobilizon_ctl[536]: 15:27:10.989 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs" server # [694416.268820] server mobilizon_ctl[536]: 15:27:10.990 [info] trigger "oban_notify" for relation "public.oban_jobs" does not exist, skipping server # [694416.268820] server mobilizon_ctl[536]: 15:27:10.990 [info] execute "CREATE TRIGGER oban_notify\nAFTER INSERT OR UPDATE OF state ON \"public\".oban_jobs\nFOR EACH ROW EXECUTE PROCEDURE \"public\".oban_jobs_notify();\n" server # [694416.269415] server mobilizon_ctl[536]: 15:27:10.990 [info] drop index if exists public.oban_jobs_scheduled_at_index server # [694416.269748] server mobilizon_ctl[536]: 15:27:10.990 [info] create index public.oban_jobs_scheduled_at_index server # [694416.270749] server mobilizon_ctl[536]: 15:27:10.992 [info] create check constraint worker_length on table public.oban_jobs server # [694416.271501] server mobilizon_ctl[536]: 15:27:10.992 [info] create check constraint queue_length on table public.oban_jobs server # [694416.272561] server mobilizon_ctl[536]: 15:27:10.993 [info] execute "CREATE OR REPLACE FUNCTION \"public\".oban_wrap_id(value bigint) RETURNS int AS $$\nBEGIN\n RETURN (CASE WHEN value > 2147483647 THEN mod(value, 2147483647) ELSE value END)::int;\nEND;\n$$ LANGUAGE plpgsql IMMUTABLE;\n" server # [694416.273345] server mobilizon_ctl[536]: 15:27:10.994 [info] alter table public.oban_jobs server # [694416.273685] server mobilizon_ctl[536]: 15:27:10.994 [info] execute "DROP FUNCTION IF EXISTS \"public\".oban_wrap_id(value bigint)" server # [694416.274056] server mobilizon_ctl[536]: 15:27:10.995 [info] drop index if exists public.oban_jobs_scheduled_at_index server # [694416.274561] server mobilizon_ctl[536]: 15:27:10.995 [info] drop index if exists public.oban_jobs_queue_index server # [694416.274919] server mobilizon_ctl[536]: 15:27:10.996 [info] drop index if exists public.oban_jobs_state_index server # [694416.275398] server mobilizon_ctl[536]: 15:27:10.996 [info] create index if not exists public.oban_jobs_queue_state_scheduled_at_id_index server # [694416.276467] server mobilizon_ctl[536]: 15:27:10.997 [info] create index if not exists public.oban_jobs_attempted_at_id_index server # [694416.277589] server mobilizon_ctl[536]: 15:27:10.998 [info] alter table public.oban_jobs server # [694416.278467] server mobilizon_ctl[536]: 15:27:10.999 [info] alter table public.oban_jobs server # [694416.279324] server mobilizon_ctl[536]: 15:27:11.000 [info] drop index if exists public.oban_jobs_queue_state_scheduled_at_id_index server # [694416.279923] server mobilizon_ctl[536]: 15:27:11.001 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index server # [694416.281558] server mobilizon_ctl[536]: 15:27:11.002 [info] execute "CREATE OR REPLACE FUNCTION \"public\".oban_jobs_notify() RETURNS trigger AS $$\nDECLARE\n channel text;\n notice json;\nBEGIN\n IF NEW.state = 'available' THEN\n channel = 'public.oban_insert';\n notice = json_build_object('queue', NEW.queue);\n\n PERFORM pg_notify(channel, notice::text);\n END IF;\n\n RETURN NULL;\nEND;\n$$ LANGUAGE plpgsql;\n" server # [694416.282177] server mobilizon_ctl[536]: 15:27:11.003 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs" server # [694416.282721] server mobilizon_ctl[536]: 15:27:11.003 [info] execute "CREATE TRIGGER oban_notify\nAFTER INSERT ON \"public\".oban_jobs\nFOR EACH ROW EXECUTE PROCEDURE \"public\".oban_jobs_notify();\n" server # [694416.283072] server mobilizon_ctl[536]: 15:27:11.004 [info] alter table public.oban_jobs server # [694416.292335] server mobilizon_ctl[536]: 15:27:11.013 [info] execute "ALTER TYPE \"public\".oban_job_state ADD VALUE IF NOT EXISTS 'cancelled'" server # [694416.292764] server mobilizon_ctl[536]: 15:27:11.013 [info] enum label "cancelled" already exists, skipping server # [694416.292845] server mobilizon_ctl[536]: 15:27:11.014 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index server # [694416.293416] server mobilizon_ctl[536]: 15:27:11.014 [info] relation "oban_jobs_state_queue_priority_scheduled_at_id_index" already exists, skipping server # [694416.293477] server mobilizon_ctl[536]: 15:27:11.014 [info] alter table public.oban_jobs server # [694416.294974] server mobilizon_ctl[536]: 15:27:11.016 [info] create check constraint priority_range on table public.oban_jobs server # [694416.295556] server mobilizon_ctl[536]: 15:27:11.016 [info] create check constraint positive_max_attempts on table public.oban_jobs server # [694416.296110] server mobilizon_ctl[536]: 15:27:11.017 [info] create check constraint attempt_range on table public.oban_jobs server # [694416.296870] server mobilizon_ctl[536]: 15:27:11.018 [info] drop index if exists public.oban_jobs_args_vector server # [694416.297183] server mobilizon_ctl[536]: 15:27:11.018 [info] index "oban_jobs_args_vector" does not exist, skipping server # [694416.297254] server mobilizon_ctl[536]: 15:27:11.018 [info] drop index if exists public.oban_jobs_worker_gist server # [694416.297582] server mobilizon_ctl[536]: 15:27:11.018 [info] index "oban_jobs_worker_gist" does not exist, skipping server # [694416.297626] server mobilizon_ctl[536]: 15:27:11.018 [info] drop index if exists public.oban_jobs_attempted_at_id_index server # [694416.298013] server mobilizon_ctl[536]: 15:27:11.019 [info] create index if not exists public.oban_jobs_args_index server # [694416.298859] server mobilizon_ctl[536]: 15:27:11.020 [info] create index if not exists public.oban_jobs_meta_index server # [694416.299739] server mobilizon_ctl[536]: 15:27:11.020 [info] create table if not exists public.oban_peers server # [694416.301992] server mobilizon_ctl[536]: 15:27:11.023 [info] execute "ALTER TABLE \"public\".oban_peers SET UNLOGGED" server # [694416.304280] server mobilizon_ctl[536]: 15:27:11.025 [info] drop constraint priority_range from table public.oban_jobs server # [694416.304616] server mobilizon_ctl[536]: 15:27:11.025 [info] create check constraint non_negative_priority on table public.oban_jobs server # [694416.305670] server mobilizon_ctl[536]: 15:27:11.026 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs" server # [694416.306246] server mobilizon_ctl[536]: 15:27:11.027 [info] execute "DROP FUNCTION IF EXISTS \"public\".oban_jobs_notify()" server # [694416.306870] server mobilizon_ctl[536]: 15:27:11.027 [info] create index if not exists public.oban_jobs_state_cancelled_at_index server # [694416.307791] server mobilizon_ctl[536]: 15:27:11.029 [info] create index if not exists public.oban_jobs_state_discarded_at_index server # [694416.309109] server mobilizon_ctl[536]: 15:27:11.030 [info] execute "ALTER TYPE \"public\".oban_job_state ADD VALUE IF NOT EXISTS 'suspended' BEFORE 'scheduled'\n" server # [694416.309404] server mobilizon_ctl[536]: 15:27:11.030 [info] enum label "suspended" already exists, skipping server # [694416.309510] server mobilizon_ctl[536]: 15:27:11.030 [info] execute "COMMENT ON TABLE \"public\".oban_jobs IS '14'" server # [694416.309960] server mobilizon_ctl[536]: 15:27:11.031 [info] == Migrated 20191104093447 in 0.0s server # [694416.318486] server mobilizon_ctl[536]: 15:27:11.039 [info] == Running 20191106114524 Mobilizon.Storage.Repo.Migrations.RemoveFloorFromAddresses.up/0 forward server # [694416.318623] server mobilizon_ctl[536]: 15:27:11.039 [info] alter table addresses server # [694416.319361] server mobilizon_ctl[536]: 15:27:11.040 [info] == Migrated 20191106114524 in 0.0s server # [694416.325089] server mobilizon_ctl[536]: 15:27:11.046 [info] == Running 20191106141051 Mobilizon.Storage.Repo.Migrations.AddTypeToAddresses.change/0 forward server # [694416.325264] server mobilizon_ctl[536]: 15:27:11.046 [info] alter table addresses server # [694416.326010] server mobilizon_ctl[536]: 15:27:11.047 [info] == Migrated 20191106141051 in 0.0s server # [694416.331370] server mobilizon_ctl[536]: 15:27:11.052 [info] == Running 20191114155534 Mobilizon.Storage.Repo.Migrations.CascadeCommentDeletion.up/0 forward server # [694416.331565] server mobilizon_ctl[536]: 15:27:11.052 [info] drop constraint comments_in_reply_to_comment_id_fkey from table comments server # [694416.333139] server mobilizon_ctl[536]: 15:27:11.054 [info] drop constraint comments_origin_comment_id_fkey from table comments server # [694416.333985] server mobilizon_ctl[536]: 15:27:11.055 [info] alter table comments server # [694416.336013] server mobilizon_ctl[536]: 15:27:11.057 [info] == Migrated 20191114155534 in 0.0s server # [694416.341551] server mobilizon_ctl[536]: 15:27:11.062 [info] == Running 20191122154018 Mobilizon.Storage.Repo.Migrations.AddDeletedAtOnComments.up/0 forward server # [694416.341713] server mobilizon_ctl[536]: 15:27:11.062 [info] drop constraint if exists comments_actor_id_fkey from table comments server # [694416.342301] server mobilizon_ctl[536]: 15:27:11.063 [info] constraint "comments_actor_id_fkey" of relation "comments" does not exist, skipping server # [694416.342301] server mobilizon_ctl[536]: 15:27:11.063 [info] alter table comments server # [694416.344920] server mobilizon_ctl[536]: 15:27:11.065 [info] == Migrated 20191122154018 in 0.0s server # [694416.350565] server mobilizon_ctl[536]: 15:27:11.071 [info] == Running 20191126173510 Mobilizon.Storage.Repo.Migrations.AddLocalFieldToReports.up/0 forward server # [694416.350874] server mobilizon_ctl[536]: 15:27:11.071 [info] alter table reports server # [694416.351672] server mobilizon_ctl[536]: 15:27:11.072 [info] rename column uri to url on table reports server # [694416.352241] server mobilizon_ctl[536]: 15:27:11.073 [info] == Migrated 20191126173510 in 0.0s server # [694416.357566] server mobilizon_ctl[536]: 15:27:11.078 [info] == Running 20191127163737 Mobilizon.Repo.Migrations.CreateTombstones.change/0 forward server # [694416.357937] server mobilizon_ctl[536]: 15:27:11.078 [info] create table tombstones server # [694416.361725] server mobilizon_ctl[536]: 15:27:11.082 [info] create index tombstones_uri_index server # [694416.362793] server mobilizon_ctl[536]: 15:27:11.083 [info] == Migrated 20191127163737 in 0.0s server # [694416.369038] server mobilizon_ctl[536]: 15:27:11.090 [info] == Running 20191129091227 Mobilizon.Storage.Repo.Migrations.AddTimestampsToFollowers.change/0 forward server # [694416.369430] server mobilizon_ctl[536]: 15:27:11.090 [info] alter table followers server # [694416.370185] server mobilizon_ctl[536]: 15:27:11.091 [info] == Migrated 20191129091227 in 0.0s server # [694416.374853] server mobilizon_ctl[536]: 15:27:11.096 [info] == Running 20191204164224 Mobilizon.Storage.Repo.Migrations.DeleteEventCascadeToComments.up/0 forward server # [694416.375063] server mobilizon_ctl[536]: 15:27:11.096 [info] drop constraint if exists comments_event_id_fkey from table comments server # [694416.376509] server mobilizon_ctl[536]: 15:27:11.097 [info] alter table comments server # [694416.378649] server mobilizon_ctl[536]: 15:27:11.099 [info] == Migrated 20191204164224 in 0.0s server # [694416.389189] server mobilizon_ctl[536]: 15:27:11.110 [info] == Running 20191206144028 Mobilizon.Repo.Migrations.CreateShares.up/0 forward server # [694416.389545] server mobilizon_ctl[536]: 15:27:11.110 [info] create table shares server # [694416.392172] server mobilizon_ctl[536]: 15:27:11.113 [info] create index if not exists shares_uri_actor_id_index server # [694416.393343] server mobilizon_ctl[536]: 15:27:11.114 [info] == Migrated 20191206144028 in 0.0s server # [694416.397975] server mobilizon_ctl[536]: 15:27:11.119 [info] == Running 20191219172017 Mobilizon.Storage.Repo.Migrations.AddMetadataToParticipant.up/0 forward server # [694416.398204] server mobilizon_ctl[536]: 15:27:11.119 [info] drop index if exists participants_event_id_actor_id_index server # [694416.398782] server mobilizon_ctl[536]: 15:27:11.120 [info] alter table participants server # [694416.400169] server mobilizon_ctl[536]: 15:27:11.121 [info] execute "CREATE UNIQUE INDEX participants_metadata_confirmation_token_index ON participants((metadata->>'confirmation_token'))" server # [694416.401195] server mobilizon_ctl[536]: 15:27:11.122 [info] == Migrated 20191219172017 in 0.0s server # [694416.406891] server mobilizon_ctl[536]: 15:27:11.128 [info] == Running 20191223173537 Mobilizon.Storage.Repo.Migrations.AddNotConfirmedStatusToParticipants.up/0 forward server # [694416.407174] server mobilizon_ctl[536]: 15:27:11.128 [info] execute "ALTER TYPE participant_role ADD VALUE IF NOT EXISTS 'not_confirmed'" server # [694416.407424] server mobilizon_ctl[536]: 15:27:11.128 [info] enum label "not_confirmed" already exists, skipping server # [694416.407424] server mobilizon_ctl[536]: 15:27:11.128 [info] == Migrated 20191223173537 in 0.0s server # [694416.411827] server mobilizon_ctl[536]: 15:27:11.133 [info] == Running 20200116095117 Mobilizon.Repo.Migrations.CreateAdminSettings.change/0 forward server # [694416.412283] server mobilizon_ctl[536]: 15:27:11.133 [info] create table admin_settings server # [694416.414839] server mobilizon_ctl[536]: 15:27:11.135 [info] create index admin_settings_group_name_index server # [694416.415825] server mobilizon_ctl[536]: 15:27:11.136 [info] == Migrated 20200116095117 in 0.0s server # [694416.423508] server mobilizon_ctl[536]: 15:27:11.144 [info] == Running 20200210100910 Mobilizon.Storage.Repo.Migrations.AddUnconfirmedEmailToUsersTable.change/0 forward server # [694416.423699] server mobilizon_ctl[536]: 15:27:11.144 [info] alter table users server # [694416.424574] server mobilizon_ctl[536]: 15:27:11.145 [info] == Migrated 20200210100910 in 0.0s server # [694416.431459] server mobilizon_ctl[536]: 15:27:11.152 [info] == Running 20200213154309 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV8.up/0 forward server # [694416.433492] server mobilizon_ctl[536]: 15:27:11.154 [info] == Migrated 20200213154309 in 0.0s server # [694416.440196] server mobilizon_ctl[536]: 15:27:11.161 [info] == Running 20200214135231 Mobilizon.Storage.Repo.Migrations.AddLastRefreshedAtToActors.change/0 forward server # [694416.440371] server mobilizon_ctl[536]: 15:27:11.161 [info] alter table actors server # [694416.441279] server mobilizon_ctl[536]: 15:27:11.162 [info] == Migrated 20200214135231 in 0.0s server # [694416.443628] server mobilizon_ctl[536]: 15:27:11.164 [info] == Running 20200218085757 Mobilizon.Storage.Repo.Migrations.AddNewRolesToMember.up/0 forward server # [694416.443748] server mobilizon_ctl[536]: 15:27:11.165 [info] execute "ALTER TYPE member_role ADD VALUE IF NOT EXISTS 'invited'" server # [694416.444219] server mobilizon_ctl[536]: 15:27:11.165 [info] enum label "invited" already exists, skipping server # [694416.444292] server mobilizon_ctl[536]: 15:27:11.165 [info] execute "ALTER TYPE member_role ADD VALUE IF NOT EXISTS 'rejected'" server # [694416.444585] server mobilizon_ctl[536]: 15:27:11.165 [info] enum label "rejected" already exists, skipping server # [694416.444793] server mobilizon_ctl[536]: 15:27:11.165 [info] == Migrated 20200218085757 in 0.0s server # [694416.451995] server mobilizon_ctl[536]: 15:27:11.173 [info] == Running 20200218170232 Mobilizon.Storage.Repo.Migrations.MoveMemberIdToUuid.up/0 forward server # [694416.452305] server mobilizon_ctl[536]: 15:27:11.173 [info] alter table members server # [694416.455184] server mobilizon_ctl[536]: 15:27:11.176 [info] == Migrated 20200218170232 in 0.0s server # [694416.462394] server mobilizon_ctl[536]: 15:27:11.183 [info] == Running 20200219152611 Mobilizon.Storage.Repo.Migrations.AddMembersEndpointToActors.up/0 forward server # [694416.462543] server mobilizon_ctl[536]: 15:27:11.183 [info] alter table actors server # [694416.463646] server mobilizon_ctl[536]: 15:27:11.184 [info] == Migrated 20200219152611 in 0.0s server # [694416.469683] server mobilizon_ctl[536]: 15:27:11.190 [info] == Running 20200221095721 Mobilizon.Repo.Migrations.CreateTodos.change/0 forward server # [694416.469930] server mobilizon_ctl[536]: 15:27:11.191 [info] create table todo_lists server # [694416.473789] server mobilizon_ctl[536]: 15:27:11.194 [info] create table todos server # [694416.476728] server mobilizon_ctl[536]: 15:27:11.197 [info] == Migrated 20200221095721 in 0.0s server # [694416.482259] server mobilizon_ctl[536]: 15:27:11.203 [info] == Running 20200221160744 Mobilizon.Repo.Migrations.CreateResources.change/0 forward server # [694416.482515] server mobilizon_ctl[536]: 15:27:11.203 [info] create table resource server # [694416.486368] server mobilizon_ctl[536]: 15:27:11.207 [info] == Migrated 20200221160744 in 0.0s server # [694416.494537] server mobilizon_ctl[536]: 15:27:11.215 [info] == Running 20200406115807 Mobilizon.Storage.Repo.Migrations.AddConversations.change/0 forward server # [694416.495083] server mobilizon_ctl[536]: 15:27:11.216 [info] create table conversations server # [694416.498743] server mobilizon_ctl[536]: 15:27:11.219 [info] alter table comments server # [694416.500307] server mobilizon_ctl[536]: 15:27:11.221 [info] == Migrated 20200406115807 in 0.0s server # [694416.507226] server mobilizon_ctl[536]: 15:27:11.228 [info] == Running 20200410100554 Mobilizon.Storage.Repo.Migrations.AddNumberEditsToComment.change/0 forward server # [694416.507450] server mobilizon_ctl[536]: 15:27:11.228 [info] alter table comments server # [694416.508675] server mobilizon_ctl[536]: 15:27:11.229 [info] == Migrated 20200410100554 in 0.0s server # [694416.514220] server mobilizon_ctl[536]: 15:27:11.235 [info] == Running 20200513142813 Mobilizon.Storage.Repo.Migrations.AddResourcesAndTodosEndpointsToActor.change/0 forward server # [694416.514461] server mobilizon_ctl[536]: 15:27:11.235 [info] alter table actors server # [694416.516278] server mobilizon_ctl[536]: 15:27:11.237 [info] == Migrated 20200513142813 in 0.0s server # [694416.524663] server mobilizon_ctl[536]: 15:27:11.245 [info] == Running 20200514101612 Mobilizon.Storage.Repo.Migrations.AddLocalAttributeToResourcesAndTodos.change/0 forward server # [694416.524663] server mobilizon_ctl[536]: 15:27:11.245 [info] alter table resource server # [694416.526154] server mobilizon_ctl[536]: 15:27:11.247 [info] alter table todo_lists server # [694416.527235] server mobilizon_ctl[536]: 15:27:11.248 [info] alter table todos server # [694416.527979] server mobilizon_ctl[536]: 15:27:11.249 [info] == Migrated 20200514101612 in 0.0s server # [694416.533094] server mobilizon_ctl[536]: 15:27:11.254 [info] == Running 20200518084949 Mobilizon.Storage.Repo.Migrations.MoveInviterFromMetadataToMemberTable.change/0 forward server # [694416.533413] server mobilizon_ctl[536]: 15:27:11.254 [info] alter table members server # [694416.535846] server mobilizon_ctl[536]: 15:27:11.256 [info] == Migrated 20200518084949 in 0.0s server # [694416.541460] server mobilizon_ctl[536]: 15:27:11.262 [info] == Running 20200519082820 Mobilizon.Storage.Repo.Migrations.AddUniqueURLContraintToSomeTables.change/0 forward server # [694416.541704] server mobilizon_ctl[536]: 15:27:11.262 [info] create index members_url_index server # [694416.542971] server mobilizon_ctl[536]: 15:27:11.264 [info] create index resource_url_index server # [694416.544322] server mobilizon_ctl[536]: 15:27:11.265 [info] create index todo_lists_url_index server # [694416.545168] server mobilizon_ctl[536]: 15:27:11.266 [info] create index todos_url_index server # [694416.546163] server mobilizon_ctl[536]: 15:27:11.267 [info] == Migrated 20200519082820 in 0.0s server # [694416.552404] server mobilizon_ctl[536]: 15:27:11.273 [info] == Running 20200526131523 Mobilizon.Repo.Migrations.CreateUserSettings.change/0 forward server # [694416.552696] server mobilizon_ctl[536]: 15:27:11.273 [info] create table user_settings server # [694416.554616] server mobilizon_ctl[536]: 15:27:11.275 [info] == Migrated 20200526131523 in 0.0s server # [694416.561585] server mobilizon_ctl[536]: 15:27:11.282 [info] == Running 20200605154921 Mobilizon.Storage.Repo.Migrations.AddNotificationPendingParticipationToSettings.change/0 forward server # [694416.561708] server mobilizon_ctl[536]: 15:27:11.282 [info] alter table user_settings server # [694416.562716] server mobilizon_ctl[536]: 15:27:11.283 [info] == Migrated 20200605154921 in 0.0s server # [694416.571672] server mobilizon_ctl[536]: 15:27:11.292 [info] == Running 20200612155254 Mobilizon.Storage.Repo.Migrations.AddDisabledParameterToUsers.change/0 forward server # [694416.571808] server mobilizon_ctl[536]: 15:27:11.292 [info] alter table users server # [694416.572933] server mobilizon_ctl[536]: 15:27:11.293 [info] == Migrated 20200612155254 in 0.0s server # [694416.580238] server mobilizon_ctl[536]: 15:27:11.301 [info] == Running 20200630123819 Mobilizon.Storage.Repo.Migrations.AddProviderToUserAndMakePasswordMandatory.up/0 forward server # [694416.580453] server mobilizon_ctl[536]: 15:27:11.301 [info] alter table users server # [694416.581269] server mobilizon_ctl[536]: 15:27:11.302 [info] == Migrated 20200630123819 in 0.0s server # [694416.585858] server mobilizon_ctl[536]: 15:27:11.307 [info] == Running 20200708080516 Mobilizon.Repo.Migrations.CreatePosts.up/0 forward server # [694416.588642] server mobilizon_ctl[536]: 15:27:11.309 [info] execute "CREATE TYPE public.post_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')" server # [694416.589662] server mobilizon_ctl[536]: 15:27:11.310 [info] create table posts server # [694416.595047] server mobilizon_ctl[536]: 15:27:11.316 [info] create table posts_tags server # [694416.597207] server mobilizon_ctl[536]: 15:27:11.318 [info] alter table actors server # [694416.597801] server mobilizon_ctl[536]: 15:27:11.318 [info] == Migrated 20200708080516 in 0.0s server # [694416.607480] server mobilizon_ctl[536]: 15:27:11.328 [info] == Running 20200717142633 Mobilizon.Storage.Repo.Migrations.RenameConversationsToDiscussions.up/0 forward server # [694416.607822] server mobilizon_ctl[536]: 15:27:11.328 [info] rename table conversations to discussions server # [694416.608421] server mobilizon_ctl[536]: 15:27:11.329 [info] rename column conversation_id to discussion_id on table comments server # [694416.608952] server mobilizon_ctl[536]: 15:27:11.330 [info] alter table actors server # [694416.610180] server mobilizon_ctl[536]: 15:27:11.331 [info] == Migrated 20200717142633 in 0.0s server # [694416.614446] server mobilizon_ctl[536]: 15:27:11.335 [info] == Running 20200721131521 Mobilizon.Storage.Repo.Migrations.AddUrlToConversation.up/0 forward server # [694416.614446] server mobilizon_ctl[536]: 15:27:11.335 [info] drop constraint if exists comments_conversation_id_fkey from table comments server # [694416.615190] server mobilizon_ctl[536]: 15:27:11.336 [info] drop constraint if exists comments_discussion_id_fkey from table comments server # [694416.615642] server mobilizon_ctl[536]: 15:27:11.336 [info] constraint "comments_discussion_id_fkey" of relation "comments" does not exist, skipping server # [694416.615642] server mobilizon_ctl[536]: 15:27:11.336 [info] alter table discussions server # [694416.617622] server mobilizon_ctl[536]: 15:27:11.338 [info] alter table comments server # [694416.619542] server mobilizon_ctl[536]: 15:27:11.340 [info] == Migrated 20200721131521 in 0.0s server # [694416.627770] server mobilizon_ctl[536]: 15:27:11.348 [info] == Running 20200805124620 Mobilizon.Storage.Repo.Migrations.AddAddressToActors.change/0 forward server # [694416.628183] server mobilizon_ctl[536]: 15:27:11.349 [info] alter table actors server # [694416.630386] server mobilizon_ctl[536]: 15:27:11.351 [info] == Migrated 20200805124620 in 0.0s server # [694416.636469] server mobilizon_ctl[536]: 15:27:11.357 [info] == Running 20200817080549 Mobilizon.Storage.Repo.Migrations.AddPublishedAtToEntities.up/0 forward server # [694416.636632] server mobilizon_ctl[536]: 15:27:11.357 [info] alter table comments server # [694416.638024] server mobilizon_ctl[536]: 15:27:11.359 [info] alter table resource server # [694416.639315] server mobilizon_ctl[536]: 15:27:11.360 [info] alter table todo_lists server # [694416.641182] server mobilizon_ctl[536]: 15:27:11.362 [info] alter table todos server # [694416.643337] server mobilizon_ctl[536]: 15:27:11.364 [info] == Migrated 20200817080549 in 0.0s server # [694416.650075] server mobilizon_ctl[536]: 15:27:11.371 [info] == Running 20200828071543 Mobilizon.Storage.Repo.Migrations.AddLoginInformationToUser.change/0 forward server # [694416.650699] server mobilizon_ctl[536]: 15:27:11.371 [info] alter table users server # [694416.651556] server mobilizon_ctl[536]: 15:27:11.372 [info] == Migrated 20200828071543 in 0.0s server # [694416.658036] server mobilizon_ctl[536]: 15:27:11.379 [info] == Running 20200901101307 Mobilizon.Storage.Repo.Migrations.FixRelayVisibility.up/0 forward server # [694416.661733] server mobilizon_ctl[536]: 15:27:11.382 [info] == Migrated 20200901101307 in 0.0s server # [694416.674396] server mobilizon_ctl[536]: 15:27:11.395 [info] == Running 20200928150725 Mobilizon.Storage.Repo.Migrations.AddContactsToEvents.change/0 forward server # [694416.674684] server mobilizon_ctl[536]: 15:27:11.395 [info] create table event_contacts server # [694416.677560] server mobilizon_ctl[536]: 15:27:11.398 [info] == Migrated 20200928150725 in 0.0s server # [694416.686979] server mobilizon_ctl[536]: 15:27:11.407 [info] == Running 20201006132530 Mobilizon.Storage.Repo.Migrations.ChangeDefaultNotificationPendingParticipation.up/0 forward server # [694416.687241] server mobilizon_ctl[536]: 15:27:11.408 [info] alter table user_settings server # [694416.688270] server mobilizon_ctl[536]: 15:27:11.409 [info] == Migrated 20201006132530 in 0.0s server # [694416.692877] server mobilizon_ctl[536]: 15:27:11.413 [info] == Running 20201103141811 Mobilizon.Storage.Repo.Migrations.AddNotificationPendingMembershipToSettings.change/0 forward server # [694416.693184] server mobilizon_ctl[536]: 15:27:11.414 [info] alter table user_settings server # [694416.694345] server mobilizon_ctl[536]: 15:27:11.415 [info] == Migrated 20201103141811 in 0.0s server # [694416.701267] server mobilizon_ctl[536]: 15:27:11.422 [info] == Running 20201105145719 Mobilizon.Storage.Repo.Migrations.RepairGroupsWithMissingURLs.up/0 forward server # [694416.712529] server mobilizon_ctl[536]: 15:27:11.433 [info] == Migrated 20201105145719 in 0.0s server # [694416.718502] server mobilizon_ctl[536]: 15:27:11.439 [info] == Running 20201114174929 Mobilizon.Storage.Repo.Migrations.FixObanMigrationsForOlderPostgreSQLVersions.up/0 forward server # [694416.719269] server mobilizon_ctl[536]: 15:27:11.440 [info] == Migrated 20201114174929 in 0.0s server # [694416.723310] server mobilizon_ctl[536]: 15:27:11.444 [info] == Running 20201114175249 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV9.up/0 forward server # [694416.726578] server mobilizon_ctl[536]: 15:27:11.447 [info] == Migrated 20201114175249 in 0.0s server # [694416.732511] server mobilizon_ctl[536]: 15:27:11.453 [info] == Running 20201120161229 Mobilizon.Storage.Repo.Migrations.FixPictureDeletion.up/0 forward server # [694416.732825] server mobilizon_ctl[536]: 15:27:11.454 [info] drop constraint if exists posts_picture_id_fkey from table posts server # [694416.734156] server mobilizon_ctl[536]: 15:27:11.455 [info] alter table posts server # [694416.736068] server mobilizon_ctl[536]: 15:27:11.457 [info] drop constraint if exists events_picture_id_fkey from table events server # [694416.736810] server mobilizon_ctl[536]: 15:27:11.457 [info] alter table events server # [694416.738195] server mobilizon_ctl[536]: 15:27:11.459 [info] == Migrated 20201120161229 in 0.0s server # [694416.740807] server mobilizon_ctl[536]: 15:27:11.462 [info] == Running 20201124094655 Mobilizon.Storage.Repo.Migrations.AddMediaTables.change/0 forward server # [694416.741197] server mobilizon_ctl[536]: 15:27:11.462 [info] rename table pictures to medias server # [694416.741730] server mobilizon_ctl[536]: 15:27:11.462 [info] create table events_medias server # [694416.743946] server mobilizon_ctl[536]: 15:27:11.465 [info] create table posts_medias server # [694416.746904] server mobilizon_ctl[536]: 15:27:11.468 [info] create table comments_medias server # [694416.749929] server mobilizon_ctl[536]: 15:27:11.470 [info] == Migrated 20201124094655 in 0.0s server # [694416.757511] server mobilizon_ctl[536]: 15:27:11.478 [info] == Running 20210127153325 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV10.up/0 forward server # [694416.758774] server mobilizon_ctl[536]: 15:27:11.479 [info] == Migrated 20210127153325 in 0.0s server # [694416.767246] server mobilizon_ctl[536]: 15:27:11.488 [info] == Running 20210210143432 Mobilizon.Storage.Repo.Migrations.AddLocationSettingsToUser.change/0 forward server # [694416.767357] server mobilizon_ctl[536]: 15:27:11.488 [info] alter table user_settings server # [694416.769157] server mobilizon_ctl[536]: 15:27:11.490 [info] == Migrated 20210210143432 in 0.0s server # [694416.775761] server mobilizon_ctl[536]: 15:27:11.496 [info] == Running 20210215092515 Mobilizon.Storage.Repo.Migrations.AddActivityTable.change/0 forward server # [694416.775761] server mobilizon_ctl[536]: 15:27:11.496 [info] create table activities server # [694416.779867] server mobilizon_ctl[536]: 15:27:11.500 [info] == Migrated 20210215092515 in 0.0s server # [694416.786582] server mobilizon_ctl[536]: 15:27:11.507 [info] == Running 20210217164549 Mobilizon.Storage.Repo.Migrations.AddMemberSinceToMembers.up/0 forward server # [694416.786771] server mobilizon_ctl[536]: 15:27:11.507 [info] alter table members server # [694416.790326] server mobilizon_ctl[536]: 15:27:11.511 [info] == Migrated 20210217164549 in 0.0s server # [694416.797488] server mobilizon_ctl[536]: 15:27:11.518 [info] == Running 20210310084210 Mobilizon.Storage.Repo.Migrations.AddIndexesToActivities.change/0 forward server # [694416.797762] server mobilizon_ctl[536]: 15:27:11.518 [info] create index activity_group_id server # [694416.798613] server mobilizon_ctl[536]: 15:27:11.519 [info] create index activity_filter server # [694416.799554] server mobilizon_ctl[536]: 15:27:11.520 [info] == Migrated 20210310084210 in 0.0s server # [694416.806274] server mobilizon_ctl[536]: 15:27:11.527 [info] == Running 20210422140923 Mobilizon.Storage.Repo.Migrations.CleanupAddresses.up/0 forward server # [694416.807780] server mobilizon_ctl[536]: 15:27:11.528 [info] == Migrated 20210422140923 in 0.0s server # [694416.813252] server mobilizon_ctl[536]: 15:27:11.534 [info] == Running 20210422155913 Mobilizon.Storage.Repo.Migrations.AddIndexToAddresses.up/0 forward server # [694416.813401] server mobilizon_ctl[536]: 15:27:11.534 [info] create index if not exists addresses_url_index server # [694416.814768] server mobilizon_ctl[536]: 15:27:11.535 [info] == Migrated 20210422155913 in 0.0s server # [694416.818625] server mobilizon_ctl[536]: 15:27:11.539 [info] == Running 20210427091034 Mobilizon.Storage.Repo.Migrations.RepairUsersDefaultActors.up/0 forward server # [694416.820788] server mobilizon_ctl[536]: 15:27:11.541 [info] == Migrated 20210427091034 in 0.0s server # [694416.827651] server mobilizon_ctl[536]: 15:27:11.548 [info] == Running 20210505172402 Mobilizon.Storage.Repo.Migrations.AddGroupNotificationAndLastNotificationDateSettings.change/0 forward server # [694416.827966] server mobilizon_ctl[536]: 15:27:11.549 [info] alter table user_settings server # [694416.828860] server mobilizon_ctl[536]: 15:27:11.549 [info] == Migrated 20210505172402 in 0.0s server # [694416.836485] server mobilizon_ctl[536]: 15:27:11.557 [info] == Running 20210506080303 Mobilizon.Repo.Migrations.CreateUserPushSubscriptions.change/0 forward server # [694416.836804] server mobilizon_ctl[536]: 15:27:11.558 [info] create table user_push_subscriptions server # [694416.841123] server mobilizon_ctl[536]: 15:27:11.562 [info] create index user_push_subscriptions_user_id_digest_index server # [694416.842866] server mobilizon_ctl[536]: 15:27:11.563 [info] == Migrated 20210506080303 in 0.0s server # [694416.851227] server mobilizon_ctl[536]: 15:27:11.572 [info] == Running 20210512084824 Mobilizon.Storage.Repo.Migrations.RepairRelayAndAnonymousActors.up/0 forward server # [694416.853765] server mobilizon_ctl[536]: 15:27:11.574 [info] == Migrated 20210512084824 in 0.0s server # [694416.857265] server mobilizon_ctl[536]: 15:27:11.578 [info] == Running 20210526203337 Mobilizon.Storage.Repo.Migrations.AddUserActivitySettings.change/0 forward server # [694416.857529] server mobilizon_ctl[536]: 15:27:11.578 [info] create table user_activity_settings server # [694416.861385] server mobilizon_ctl[536]: 15:27:11.582 [info] create index user_activity_settings_user_id_key_method_index server # [694416.862950] server mobilizon_ctl[536]: 15:27:11.583 [info] == Migrated 20210526203337 in 0.0s server # [694416.869153] server mobilizon_ctl[536]: 15:27:11.590 [info] == Running 20210601082412 Mobilizon.Storage.Repo.Migrations.AddIsAnnouncementToComments.change/0 forward server # [694416.869566] server mobilizon_ctl[536]: 15:27:11.590 [info] alter table comments server # [694416.870619] server mobilizon_ctl[536]: 15:27:11.591 [info] == Migrated 20210601082412 in 0.0s server # [694416.878143] server mobilizon_ctl[536]: 15:27:11.599 [info] == Running 20210601082613 Mobilizon.Storage.Repo.Migrations.FixUserSettingsNullableFields.change/0 forward server # [694416.878384] server mobilizon_ctl[536]: 15:27:11.599 [info] alter table user_settings server # [694416.879867] server mobilizon_ctl[536]: 15:27:11.600 [info] == Migrated 20210601082613 in 0.0s server # [694416.888533] server mobilizon_ctl[536]: 15:27:11.609 [info] == Running 20210608133040 Mobilizon.Storage.Repo.Migrations.AddMetadataToMedia.change/0 forward server # [694416.888826] server mobilizon_ctl[536]: 15:27:11.609 [info] alter table medias server # [694416.889586] server mobilizon_ctl[536]: 15:27:11.610 [info] == Migrated 20210608133040 in 0.0s server # [694416.893196] server mobilizon_ctl[536]: 15:27:11.614 [info] == Running 20210622133516 Mobilizon.Storage.Repo.Migrations.CleanupPosts.up/0 forward server # [694416.894604] server mobilizon_ctl[536]: 15:27:11.615 [info] == Migrated 20210622133516 in 0.0s server # [694416.902400] server mobilizon_ctl[536]: 15:27:11.623 [info] == Running 20210622133555 Mobilizon.Storage.Repo.Migrations.AddIndexToPosts.up/0 forward server # [694416.902630] server mobilizon_ctl[536]: 15:27:11.623 [info] create index if not exists posts_url_index server # [694416.904021] server mobilizon_ctl[536]: 15:27:11.625 [info] == Migrated 20210622133555 in 0.0s server # [694416.912762] server mobilizon_ctl[536]: 15:27:11.633 [info] == Running 20210730143924 Mobilizon.Storage.Repo.Migrations.PutUniqueIndexOnParticipantsUrls.up/0 forward server # [694416.913038] server mobilizon_ctl[536]: 15:27:11.633 [info] create index if not exists participants_url_index server # [694416.913946] server mobilizon_ctl[536]: 15:27:11.635 [info] == Migrated 20210730143924 in 0.0s server # [694416.921576] server mobilizon_ctl[536]: 15:27:11.642 [info] == Running 20210805142745 Mobilizon.Storage.Repo.Migrations.AddMetadataForEvents.change/0 forward server # [694416.921812] server mobilizon_ctl[536]: 15:27:11.642 [info] alter table events server # [694416.922630] server mobilizon_ctl[536]: 15:27:11.643 [info] == Migrated 20210805142745 in 0.0s server # [694416.928986] server mobilizon_ctl[536]: 15:27:11.650 [info] == Running 20210819161507 Mobilizon.Storage.Repo.Migrations.AddLanguageToEntities.change/0 forward server # [694416.929293] server mobilizon_ctl[536]: 15:27:11.650 [info] alter table events server # [694416.930487] server mobilizon_ctl[536]: 15:27:11.651 [info] alter table comments server # [694416.931587] server mobilizon_ctl[536]: 15:27:11.652 [info] alter table posts server # [694416.932561] server mobilizon_ctl[536]: 15:27:11.653 [info] == Migrated 20210819161507 in 0.0s server # [694416.939851] server mobilizon_ctl[536]: 15:27:11.661 [info] == Running 20211001101902 Mobilizon.Repo.Migrations.CreateExports.change/0 forward server # [694416.940256] server mobilizon_ctl[536]: 15:27:11.661 [info] create table exports server # [694416.943944] server mobilizon_ctl[536]: 15:27:11.665 [info] create index exports_file_path_index server # [694416.945357] server mobilizon_ctl[536]: 15:27:11.666 [info] == Migrated 20211001101902 in 0.0s server # [694416.951727] server mobilizon_ctl[536]: 15:27:11.672 [info] == Running 20211008084901 Mobilizon.Storage.Repo.Migrations.AddTimezoneToAddresses.change/0 forward server # [694416.951964] server mobilizon_ctl[536]: 15:27:11.673 [info] alter table addresses server # [694416.952884] server mobilizon_ctl[536]: 15:27:11.673 [info] == Migrated 20211008084901 in 0.0s server # [694416.959011] server mobilizon_ctl[536]: 15:27:11.680 [info] == Running 20211013090405 Mobilizon.Storage.Repo.Migrations.AddCodeToParticipants.change/0 forward server # [694416.959223] server mobilizon_ctl[536]: 15:27:11.680 [info] alter table participants server # [694416.960400] server mobilizon_ctl[536]: 15:27:11.681 [info] == Migrated 20211013090405 in 0.0s server # [694416.979081] server mobilizon_ctl[536]: 15:27:11.700 [info] == Running 20211022093530 Mobilizon.Storage.Repo.Migrations.AddNotifyToFollowers.change/0 forward server # [694416.979257] server mobilizon_ctl[536]: 15:27:11.700 [info] alter table followers server # [694416.980254] server mobilizon_ctl[536]: 15:27:11.701 [info] == Migrated 20211022093530 in 0.0s server # [694416.987025] server mobilizon_ctl[536]: 15:27:11.708 [info] == Running 20211223141104 Mobilizon.Storage.Repo.Migrations.AddInstanceMaterializedView.up/0 forward server # [694416.990060] server mobilizon_ctl[536]: 15:27:11.711 [info] execute "CREATE MATERIALIZED VIEW instances AS\nSELECT\n a.domain,\n COUNT(DISTINCT(p.id)) AS person_count,\n COUNT(DISTINCT(g.id)) AS group_count,\n COUNT(DISTINCT(e.id)) AS event_count,\n COUNT(f1.id) AS followers_count,\n COUNT(f2.id) AS followings_count,\n COUNT(r.id) AS reports_count,\n SUM(COALESCE((m.file->>'size')::int, 0)) AS media_size\nFROM actors a\nLEFT JOIN actors p ON a.id = p.id AND p.type = 'Person'\nLEFT JOIN actors g ON a.id = g.id AND g.type = 'Group'\nLEFT JOIN events e ON a.id = e.organizer_actor_id\nLEFT JOIN followers f1 ON a.id = f1.actor_id\nLEFT JOIN followers f2 ON a.id = f2.target_actor_id\nLEFT JOIN reports r ON r.reported_id = a.id\nLEFT JOIN medias m ON m.actor_id = a.id\nWHERE a.domain IS NOT NULL\nGROUP BY a.domain;\n" server # [694417.003668] server mobilizon_ctl[536]: 15:27:11.724 [info] execute "CREATE OR REPLACE FUNCTION refresh_instances()\nRETURNS trigger AS $$\nBEGIN\n REFRESH MATERIALIZED VIEW instances;\n RETURN NULL;\nEND;\n$$ LANGUAGE plpgsql;\n" server # [694417.004619] server mobilizon_ctl[536]: 15:27:11.725 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger ON actors;\n" server # [694417.005811] server mobilizon_ctl[536]: 15:27:11.726 [info] trigger "refresh_instances_trigger" for relation "actors" does not exist, skipping server # [694417.005811] server mobilizon_ctl[536]: 15:27:11.727 [info] execute "CREATE TRIGGER refresh_instances_trigger\nAFTER INSERT OR UPDATE OR DELETE\nON actors\nFOR EACH STATEMENT\nEXECUTE PROCEDURE refresh_instances();\n" server # [694417.006706] server mobilizon_ctl[536]: 15:27:11.727 [info] create index if not exists instances_domain_index server # [694417.011536] server mobilizon_ctl[536]: 15:27:11.732 [info] == Migrated 20211223141104 in 0.0s server # [694417.021593] server mobilizon_ctl[536]: 15:27:11.742 [info] == Running 20220321154138 Mobilizon.Storage.Repo.Migrations.CreateObanPeers.up/0 forward server # [694417.022994] server mobilizon_ctl[536]: 15:27:11.744 [info] == Migrated 20220321154138 in 0.0s server # [694417.029041] server mobilizon_ctl[536]: 15:27:11.750 [info] == Running 20220321154142 Mobilizon.Storage.Repo.Migrations.SwapPrimaryObanIndexes.change/0 forward server # [694417.029780] server mobilizon_ctl[536]: 15:27:11.750 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index server # [694417.030750] server mobilizon_ctl[536]: 15:27:11.751 [info] relation "oban_jobs_state_queue_priority_scheduled_at_id_index" already exists, skipping server # [694417.030843] server mobilizon_ctl[536]: 15:27:11.751 [info] drop index if exists public.oban_jobs_queue_state_priority_scheduled_at_id_index server # [694417.031432] server mobilizon_ctl[536]: 15:27:11.752 [info] index "oban_jobs_queue_state_priority_scheduled_at_id_index" does not exist, skipping server # [694417.031719] server mobilizon_ctl[536]: 15:27:11.752 [info] == Migrated 20220321154142 in 0.0s server # [694417.038002] server mobilizon_ctl[536]: 15:27:11.759 [info] == Running 20220328153640 Mobilizon.Storage.Repo.Migrations.SetAllEventsCategoryToMeeting.up/0 forward server # [694417.038236] server mobilizon_ctl[536]: 15:27:11.759 [info] execute "UPDATE events SET category = 'MEETING'" server # [694417.038765] server mobilizon_ctl[536]: 15:27:11.759 [info] == Migrated 20220328153640 in 0.0s server # [694417.045340] server mobilizon_ctl[536]: 15:27:11.766 [info] == Running 20220407083712 Mobilizon.Storage.Repo.Migrations.AddIndexesToAddresses.up/0 forward server # [694417.045907] server mobilizon_ctl[536]: 15:27:11.766 [info] create index if not exists idx_addresses_geom_x server # [694417.047559] server mobilizon_ctl[536]: 15:27:11.768 [info] create index if not exists idx_addresses_geom_y server # [694417.049272] server mobilizon_ctl[536]: 15:27:11.770 [info] == Migrated 20220407083712 in 0.0s server # [694417.055545] server mobilizon_ctl[536]: 15:27:11.776 [info] == Running 20220505091224 Mobilizon.Storage.Repo.Migrations.ChangeRefreshInstanceTriggerToOnlyExecuteOnRelays.up/0 forward server # [694417.055688] server mobilizon_ctl[536]: 15:27:11.776 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger ON actors;\n" server # [694417.056429] server mobilizon_ctl[536]: 15:27:11.777 [info] execute "CREATE TRIGGER refresh_instances_trigger_new\nAFTER INSERT OR UPDATE\nON actors\nFOR EACH ROW\nWHEN (NEW.preferred_username = 'relay')\nEXECUTE PROCEDURE refresh_instances();\n" server # [694417.057016] server mobilizon_ctl[536]: 15:27:11.778 [info] execute "CREATE TRIGGER refresh_instances_trigger_old\nAFTER DELETE\nON actors\nFOR EACH ROW\nWHEN (OLD.preferred_username = 'relay')\nEXECUTE PROCEDURE refresh_instances();\n" server # [694417.057636] server mobilizon_ctl[536]: 15:27:11.778 [info] == Migrated 20220505091224 in 0.0s server # [694417.063670] server mobilizon_ctl[536]: 15:27:11.784 [info] == Running 20220506105150 Mobilizon.Storage.Repo.Migrations.RemoveRefreshInstanceTriggers.up/0 forward server # [694417.064145] server mobilizon_ctl[536]: 15:27:11.785 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger_new ON actors;\n" server # [694417.064919] server mobilizon_ctl[536]: 15:27:11.785 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger_old ON actors;\n" server # [694417.065397] server mobilizon_ctl[536]: 15:27:11.786 [info] == Migrated 20220506105150 in 0.0s server # [694417.071642] server mobilizon_ctl[536]: 15:27:11.792 [info] == Running 20230208101626 Mobilizon.Repo.Migrations.CreateApplications.change/0 forward server # [694417.072287] server mobilizon_ctl[536]: 15:27:11.793 [info] create table applications server # [694417.075361] server mobilizon_ctl[536]: 15:27:11.796 [info] create index applications_owner_id_owner_type_index server # [694417.077156] server mobilizon_ctl[536]: 15:27:11.798 [info] == Migrated 20230208101626 in 0.0s server # [694417.083755] server mobilizon_ctl[536]: 15:27:11.804 [info] == Running 20230215125801 Mobilizon.Repo.Migrations.CreateApplicationTokens.change/0 forward server # [694417.084252] server mobilizon_ctl[536]: 15:27:11.805 [info] create table application_tokens server # [694417.088523] server mobilizon_ctl[536]: 15:27:11.809 [info] create index application_tokens_user_id_application_id_index server # [694417.089547] server mobilizon_ctl[536]: 15:27:11.810 [info] == Migrated 20230215125801 in 0.0s server # [694417.095851] server mobilizon_ctl[536]: 15:27:11.816 [info] == Running 20230217084253 Mobilizon.Repo.Migrations.CreateApplicationDeviceActivation.change/0 forward server # [694417.096151] server mobilizon_ctl[536]: 15:27:11.817 [info] create table application_device_activation server # [694417.100578] server mobilizon_ctl[536]: 15:27:11.821 [info] == Migrated 20230217084253 in 0.0s server # [694417.109782] server mobilizon_ctl[536]: 15:27:11.830 [info] == Running 20230605143534 Mobilizon.Storage.Repo.Migrations.AllowMultipleEventsToBeReported.up/0 forward server # [694417.110064] server mobilizon_ctl[536]: 15:27:11.831 [info] create table reports_events server # [694417.111954] server mobilizon_ctl[536]: 15:27:11.832 [info] == Migrated 20230605143534 in 0.0s server # [694417.118874] server mobilizon_ctl[536]: 15:27:11.840 [info] == Running 20230605153836 Mobilizon.Storage.Repo.Migrations.BackfillReportEventsWithOldEvents.up/0 forward server # [694417.119702] server mobilizon_ctl[536]: 15:27:11.840 [info] == Migrated 20230605153836 in 0.0s server # [694417.126254] server mobilizon_ctl[536]: 15:27:11.847 [info] == Running 20230605154106 Mobilizon.Storage.Repo.Migrations.RemoveObsoleteEventIdOnReports.up/0 forward server # [694417.126570] server mobilizon_ctl[536]: 15:27:11.847 [info] alter table reports server # [694417.128216] server mobilizon_ctl[536]: 15:27:11.849 [info] == Migrated 20230605154106 in 0.0s server # [694417.135642] server mobilizon_ctl[536]: 15:27:11.856 [info] == Running 20230831153358 Mobilizon.Storage.Repo.Migrations.RemoveOnDeleteCascadeForReports.up/0 forward server # [694417.135854] server mobilizon_ctl[536]: 15:27:11.857 [info] execute "DROP MATERIALIZED VIEW IF EXISTS instances;\n" server # [694417.139756] server mobilizon_ctl[536]: 15:27:11.860 [info] drop constraint reports_reported_id_fkey from table reports server # [694417.140610] server mobilizon_ctl[536]: 15:27:11.861 [info] drop constraint reports_reporter_id_fkey from table reports server # [694417.141296] server mobilizon_ctl[536]: 15:27:11.862 [info] drop constraint reports_manager_id_fkey from table reports server # [694417.141992] server mobilizon_ctl[536]: 15:27:11.863 [info] alter table reports server # [694417.144836] server mobilizon_ctl[536]: 15:27:11.865 [info] drop constraint report_notes_moderator_id_fkey from table report_notes server # [694417.145540] server mobilizon_ctl[536]: 15:27:11.866 [info] alter table report_notes server # [694417.147824] server mobilizon_ctl[536]: 15:27:11.868 [info] execute "CREATE MATERIALIZED VIEW instances AS\nSELECT\n a.domain,\n COUNT(DISTINCT(p.id)) AS person_count,\n COUNT(DISTINCT(g.id)) AS group_count,\n COUNT(DISTINCT(e.id)) AS event_count,\n COUNT(f1.id) AS followers_count,\n COUNT(f2.id) AS followings_count,\n COUNT(r.id) AS reports_count,\n SUM(COALESCE((m.file->>'size')::int, 0)) AS media_size\nFROM actors a\nLEFT JOIN actors p ON a.id = p.id AND p.type = 'Person'\nLEFT JOIN actors g ON a.id = g.id AND g.type = 'Group'\nLEFT JOIN events e ON a.id = e.organizer_actor_id\nLEFT JOIN followers f1 ON a.id = f1.actor_id\nLEFT JOIN followers f2 ON a.id = f2.target_actor_id\nLEFT JOIN reports r ON r.reported_id = a.id\nLEFT JOIN medias m ON m.actor_id = a.id\nWHERE a.domain IS NOT NULL\nGROUP BY a.domain;\n" server # [694417.162291] server mobilizon_ctl[536]: 15:27:11.883 [info] == Migrated 20230831153358 in 0.0s server # [694417.175149] server mobilizon_ctl[536]: 15:27:11.896 [info] == Running 20230901160000 Mobilizon.Storage.Repo.Migrations.AddExternalUrlForEvents.up/0 forward server # [694417.175730] server mobilizon_ctl[536]: 15:27:11.896 [info] alter table events server # [694417.176407] server mobilizon_ctl[536]: 15:27:11.897 [info] execute "ALTER TABLE events ALTER COLUMN join_options TYPE VARCHAR USING join_options::text" server # [694417.181802] server mobilizon_ctl[536]: 15:27:11.902 [info] execute "ALTER TABLE events ALTER COLUMN join_options DROP DEFAULT" server # [694417.182305] server mobilizon_ctl[536]: 15:27:11.903 [info] execute "DROP TYPE public.join_options" server # [694417.182892] server mobilizon_ctl[536]: 15:27:11.904 [info] execute "CREATE TYPE public.join_options AS ENUM ('free', 'restricted', 'invite', 'external')" server # [694417.183589] server mobilizon_ctl[536]: 15:27:11.904 [info] execute "ALTER TABLE events ALTER COLUMN join_options TYPE join_options USING join_options::join_options" server # [694417.187566] server mobilizon_ctl[536]: 15:27:11.908 [info] execute "ALTER TABLE events ALTER COLUMN join_options SET DEFAULT 'free'::join_options" server # [694417.188303] server mobilizon_ctl[536]: 15:27:11.909 [info] == Migrated 20230901160000 in 0.0s server # [694417.196733] server mobilizon_ctl[536]: 15:27:11.917 [info] == Running 20230920071502 Mobilizon.Storage.Repo.Migrations.AddActorConversations.up/0 forward server # [694417.197141] server mobilizon_ctl[536]: 15:27:11.918 [info] create table conversations server # [694417.200289] server mobilizon_ctl[536]: 15:27:11.921 [info] create table conversation_participants server # [694417.203241] server mobilizon_ctl[536]: 15:27:11.924 [info] alter table comments server # [694417.204895] server mobilizon_ctl[536]: 15:27:11.925 [info] == Migrated 20230920071502 in 0.0s server # [694417.211770] server mobilizon_ctl[536]: 15:27:11.932 [info] == Running 20231220092536 Mobilizon.Storage.Repo.Migrations.AddActorInstances.change/0 forward server # [694417.211987] server mobilizon_ctl[536]: 15:27:11.932 [info] create table instance_actors server # [694417.216364] server mobilizon_ctl[536]: 15:27:11.937 [info] create index instance_actors_domain_index server # [694417.218161] server mobilizon_ctl[536]: 15:27:11.938 [info] == Migrated 20231220092536 in 0.0s server # [694417.227830] server mobilizon_ctl[536]: 15:27:11.948 [info] == Running 20240104103036 Mobilizon.Storage.Repo.Migrations.ChangeActorInstanceDescriptionTypeToText.up/0 forward server # [694417.227830] server mobilizon_ctl[536]: 15:27:11.948 [info] alter table instance_actors server # [694417.229128] server mobilizon_ctl[536]: 15:27:11.950 [info] == Migrated 20240104103036 in 0.0s server # [694417.233074] server mobilizon_ctl[536]: 15:27:11.954 [info] == Running 20240222121054 Mobilizon.Storage.Repo.Migrations.CreateAdminSettingsMedias.change/0 forward server # [694417.233420] server mobilizon_ctl[536]: 15:27:11.954 [info] create table admin_settings_medias server # [694417.238600] server mobilizon_ctl[536]: 15:27:11.959 [info] create index admin_settings_medias_group_name_index server # [694417.245767] server mobilizon_ctl[536]: 15:27:11.966 [info] == Migrated 20240222121054 in 0.0s server # [694417.254020] server mobilizon_ctl[536]: 15:27:11.975 [info] == Running 20240725130410 Mobilizon.Storage.Repo.Migrations.AddEventPhysicalAddressIndex.up/0 forward server # [694417.254177] server mobilizon_ctl[536]: 15:27:11.975 [info] create index events_phys_addr_id server # [694417.258987] server mobilizon_ctl[536]: 15:27:11.977 [info] == Migrated 20240725130410 in 0.0s server # [694417.265635] server mobilizon_ctl[536]: 15:27:11.986 [info] == Running 20250521145952 Mobilizon.Storage.Repo.Migrations.AddUuidToMedia.change/0 forward server # [694417.266153] server mobilizon_ctl[536]: 15:27:11.987 [info] alter table medias server # [694417.269320] server mobilizon_ctl[536]: 15:27:11.990 [info] create index medias_uuid_index server # [694417.270631] server mobilizon_ctl[536]: 15:27:11.991 [info] == Migrated 20250521145952 in 0.0s server # [694417.280922] server mobilizon_ctl[536]: 15:27:12.001 [info] == Running 20250911120910 Mobilizon.Storage.Repo.Migrations.AddModerationToUser.change/0 forward server # [694417.281130] server mobilizon_ctl[536]: 15:27:12.002 [info] alter table users server: (finished: waiting for unit mobilizon.service, in 20.20 seconds) server: waiting for TCP port 41395 on localhost server # [694417.283449] server mobilizon_ctl[536]: 15:27:12.004 [info] == Migrated 20250911120910 in 0.0s server # [694417.312745] server mobilizon_ctl[536]: 15:27:12.033 [info] == Running 20250919143627 Mobilizon.Storage.Repo.Migrations.UpdateRoleToUser.change/0 forward server # [694417.312945] server mobilizon_ctl[536]: 15:27:12.033 [info] execute "ALTER TYPE user_role ADD VALUE IF NOT EXISTS 'pending';" server # [694417.313439] server mobilizon_ctl[536]: 15:27:12.034 [info] enum label "pending" already exists, skipping server # [694417.313617] server mobilizon_ctl[536]: 15:27:12.034 [info] == Migrated 20250919143627 in 0.0s server # [694417.318916] server mobilizon_ctl[536]: 15:27:12.040 [info] == Running 20251027133219 Mobilizon.Storage.Repo.Migrations.CreateInvitations.change/0 forward server # [694417.319209] server mobilizon_ctl[536]: 15:27:12.040 [info] create table invitations server # [694417.323173] server mobilizon_ctl[536]: 15:27:12.044 [info] create index invitations_token_index server # [694417.324367] server mobilizon_ctl[536]: 15:27:12.045 [info] == Migrated 20251027133219 in 0.0s server # [694417.347211] server mobilizon_ctl[536]: 15:27:12.068 [info] == Running 20251111093015 Mobilizon.Storage.Repo.Migrations.AddAllowToGroup.change/0 forward server # [694417.347443] server mobilizon_ctl[536]: 15:27:12.068 [info] alter table actors server # [694417.348646] server mobilizon_ctl[536]: 15:27:12.069 [info] == Migrated 20251111093015 in 0.0s server # [694417.384606] server systemd[1]: Started Mobilizon federated organization and mobilization platform. server # [694417.386247] server systemd[1]: Reached target Multi-User System. server # [694417.388133] server systemd[1]: Startup finished in 19.150s. Connection to localhost (::1) 41395 port [tcp/*] succeeded! server: (finished: waiting for TCP port 41395 on localhost, in 4.07 seconds) server: must succeed: curl --fail https://acme.test/ server # [694421.266983] server mobilizon[598]: 15:27:15.988 [info] No tzdata release files found in custom data dir. Copying release file from tzdata priv dir. server # [694421.380346] server mobilizon[598]: 15:27:16.093 [info] Source for database :city not found: "/var/lib/mobilizon/geo/GeoLite2-City.mmdb" server # [694421.425240] server mobilizon[598]: 15:27:16.145 [info] Loading 122 CA(s) from :otp store server # [694421.451810] server mobilizon[598]: 15:27:16.172 [info] Running Mobilizon.Web.Endpoint with Bandit 1.12.0 at ::1:41395 (http) server # [694421.452094] server mobilizon[598]: 15:27:16.173 [info] Access Mobilizon.Web.Endpoint at https://acme.test server # [694421.463812] server mobilizon[598]: 15:27:16.184 [info] {"message":"notifier only receiving messages from its own node, functionality may be degraded","source":"oban","event":"notifier:switch","connectivity_status":"solitary"} server # [694421.464994] server mobilizon[598]: 15:27:16.186 [info] {"message":"peer became leader","node":"mobilizon@server","source":"oban","event":"peer:election","leader":true,"was_leader":false} % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 2289 100 2289 0 0 65366 0 0 server: (finished: must succeed: curl --fail https://acme.test/, in 0.06 seconds) (finished: run the VM test script, in 24.32 seconds) test script finished in 24.42s cleanup kill NspawnMachine (pid 50) Container server terminated by signal KILL. (finished: cleanup, in 0.27 seconds)