container-test-run-mobilizon
checks.aarch64-linux.nixosTest
· build #7
· raw
1Machine state will be reset. To keep it, pass --keep-machine-state2start all VLans3(finished: start all VLans, in 0.01 seconds)45Test will time out and terminate in 3600 seconds6run the VM test script7additionally exposed symbols:8 server,9 vlan1,10 start_all, test_script, machines, machines_qemu, machines_nspawn, vlans, driver, log, os, create_machine, subtest, run_tests, join_all, retry, serial_stdout_off, serial_stdout_on, polling_condition, BaseMachine, QemuMachine, NspawnMachine, t, debug, dump_machine_ssh11server: waiting for unit mobilizon.service12server: systemd-nspawn running (pid 50)13server: Waiting for journal at /build/vm-state-server/var/log/journal...14nixos-nspawn(server): TAP vde-tap1 not found; container will be isolated from VDE15nixos-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.16Note: 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.17░ Spawning container server on /build/vm-state-server.18server # No journal files were found.19server # No journal boot entry found for the specified boot (+0).20server # [ 6425.364131] server systemd-journald[57]: Journal started21server # [ 6425.364292] server systemd-journald[57]: Runtime Journal (/run/log/journal/59c41af1f9c84d7c8f01951fe0898869) is 8M, max 311.2M, 303.2M free.22server # [ 6425.381079] server systemd[1]: Finished Apply Kernel Variables.23server # [ 6425.397536] server systemd[1]: Finished Create Static Device Nodes in /dev gracefully.24server # [ 6425.417017] server systemd[1]: Starting Flush Journal to Persistent Storage...25server # [ 6425.417971] server systemd[1]: Starting Create Static Device Nodes in /dev...26server # [ 6425.453580] server systemd-journald[57]: Time spent on flushing to /var/log/journal/59c41af1f9c84d7c8f01951fe0898869 is 1.760ms for 6 entries.27server # [ 6425.453580] server systemd-journald[57]: System Journal (/var/log/journal/59c41af1f9c84d7c8f01951fe0898869) is 512B, max 4G, 3.9G free.28server # [ 6425.465204] server systemd[1]: Finished Flush Journal to Persistent Storage.29server # [ 6425.465668] server systemd[1]: Finished Create Static Device Nodes in /dev.30server # [ 6425.466867] server systemd[1]: Reached target Preparation for Local File Systems.31server # [ 6425.467048] server systemd[1]: Rule-based Manager for Device Events and Files skipped, unmet condition check ConditionPathIsReadWrite=/sys32server # [ 6425.604434] server systemd[1]: Finished Firewall.33server # [ 6426.365288] server systemd[1]: Mounting /run/wrappers...34server # [ 6426.411368] server systemd[1]: Mounted /run/wrappers.35server # [ 6426.412212] server systemd[1]: Reached target Local File Systems.36server # [ 6426.413257] server systemd[1]: Listening on Boot Loader Control Service Socket.37server # [ 6426.415232] server systemd[1]: Starting Create SUID/SGID Wrappers...38server # [ 6426.415317] server systemd[1]: Update Boot Loader Random Seed skipped, unmet condition check ConditionVirtualization=!container39server # [ 6426.417718] server systemd[1]: Starting Save Transient machine-id to Disk...40server # [ 6426.419316] server systemd[1]: Starting Create System Files and Directories...41server # [ 6426.448121] server systemd-tmpfiles[161]: Cannot set file attributes for '/var/empty', value=0x00000010, mask=0x00000010, ignoring: Operation not permitted42server # [ 6426.448599] server systemd-tmpfiles[161]: fchmod() of /var/log/journal failed: Operation not permitted43server # [ 6426.448719] server systemd-tmpfiles[161]: fchmod() of /var/log/journal/59c41af1f9c84d7c8f01951fe0898869 failed: Operation not permitted44server # [ 6426.448870] server systemd-tmpfiles[161]: fchmod() of /run/log/journal failed: Operation not permitted45server # [ 6426.453146] server systemd[1]: Finished Create System Files and Directories.46server # [ 6426.463551] server suid-sgid-wrappers-start[168]: chmod: changing permissions of '/run/wrappers/wrappers.1okjuXgYBK/chsh': Operation not permitted47server # [ 6426.469856] server systemd[1]: suid-sgid-wrappers.service: Main process exited, code=exited, status=1/FAILURE48server # [ 6426.469959] server systemd[1]: suid-sgid-wrappers.service: Failed with result 'exit-code'.49server # [ 6426.470128] server systemd[1]: Failed to start Create SUID/SGID Wrappers.50server # [ 6426.472703] server systemd[1]: Starting Rebuild Journal Catalog...51server # [ 6426.473712] server systemd[1]: Starting Record System Boot/Shutdown in UTMP...52server # [ 6426.491918] server systemd[1]: Finished Record System Boot/Shutdown in UTMP.53server # [ 6426.498041] server systemd[1]: Finished Rebuild Journal Catalog.54server # [ 6426.499968] server systemd[1]: Starting Update is Completed...55server # [ 6426.535167] server systemd[1]: Finished Update is Completed.56server # [ 6426.535446] server systemd[1]: Reached target System Initialization.57server # [ 6426.535589] server systemd[1]: Discard unused filesystem blocks once a week skipped, unmet condition check ConditionVirtualization=!container58server # [ 6426.535718] server systemd[1]: Started Daily Cleanup of Temporary Directories.59server # [ 6426.535770] server systemd[1]: Reached target Timer Units.60server # [ 6426.535973] server systemd[1]: Listening on D-Bus System Message Bus Socket.61server # [ 6426.536284] server systemd[1]: Listening on Nix Daemon Socket.62server # [ 6426.536499] server systemd[1]: Listening on Virtual Machine and Container Registration Service Socket.63server # [ 6426.536548] server systemd[1]: Reached target Socket Units.64server # [ 6426.536615] server systemd[1]: Reached target Basic System.65server # [ 6426.538403] server systemd[1]: Starting Import lastlog data into lastlog2 database...66server # [ 6426.539687] server systemd[1]: Starting Name Service Cache Daemon (nsncd)...67server # [ 6426.540719] server systemd[1]: Starting resolvconf update...68server # [ 6426.565105] server systemd[1]: Finished Import lastlog data into lastlog2 database.69server # [ 6426.617956] server systemd[1]: nscd.service: Deactivated successfully.70server # [ 6426.618115] server systemd[1]: Stopped Name Service Cache Daemon (nsncd).71server # [ 6426.624729] server systemd[1]: Starting Name Service Cache Daemon (nsncd)...72server # [ 6426.640979] server resolvconf-start[234]: setfacl: /run/resolvconf: Operation not supported73server # [ 6426.642709] server systemd[1]: resolvconf.service: Main process exited, code=exited, status=1/FAILURE74server # [ 6426.642863] server systemd[1]: resolvconf.service: Failed with result 'exit-code'.75server # [ 6426.648510] server systemd[1]: Failed to start resolvconf update.76server # [ 6426.649002] server systemd[1]: Reached target Preparation for Network.77server # [ 6426.650807] server systemd[1]: Starting Address configuration of eth1...78server # [ 6426.652567] server systemd[1]: Starting Extra networking commands....79server # [ 6426.674494] server network-addresses-eth1-start[237]: adding address 192.168.1.1/24... done80server # [ 6426.678360] server network-addresses-eth1-start[237]: adding address 2001:db8:1::1/64... done81server # [ 6426.683902] server systemd[1]: Finished Address configuration of eth1.82server # [ 6426.742110] server systemd[1]: Finished Extra networking commands..83server # [ 6426.743489] server systemd[1]: Reached target Network.84server # [ 6426.746086] server systemd[1]: Starting Nginx Web Server...85server # [ 6426.747403] server systemd[1]: Starting PostgreSQL Server...86server # [ 6426.826812] server nsncd[225]: Sep 01 15:01:24.378 INFO started, config: Config { ignored_request_types: {}, worker_count: 8, handoff_timeout: 10s }, path: "/var/run/nscd/socket"87server # [ 6426.846576] server systemd[1]: etc-machine\x2did.mount: Deactivated successfully.88server # [ 6426.847904] server systemd[1]: Started Name Service Cache Daemon (nsncd).89server # [ 6426.848222] server systemd[1]: Finished Save Transient machine-id to Disk.90server # [ 6426.849008] server systemd[1]: Reached target Host and Network Name Lookups.91server # [ 6426.849139] server systemd[1]: Reached target User and Group Name Lookups.92server # [ 6426.850621] server systemd[1]: Starting User Login Management...93server # [ 6426.851601] server systemd[1]: Starting Permit User Sessions...94server # [ 6426.877959] server systemd[1]: Finished Permit User Sessions.95server # [ 6426.880379] server systemd[1]: Started Console Getty.96server # [ 6426.880451] server systemd[1]: Getty on tty1 skipped, unmet condition check ConditionPathExists=/dev/tty097server # [ 6426.880485] server systemd[1]: Reached target Login Prompts.98server # [ 6427.969314] server systemd-logind[314]: New seat seat0.99server # [ 6427.970768] server systemd[1]: Starting D-Bus System Message Bus...100server # [ 6427.970914] server systemd[1]: Started User Login Management.101server # [ 6427.972284] server systemd[1]: Starting linger-users.service...102server # [ 6427.998726] server systemd[1]: linger-users.service: Deactivated successfully.103server # [ 6427.998905] server systemd[1]: Finished linger-users.service.104server # [ 6428.128713] server postgresql-pre-start[330]: The files belonging to this database system will be owned by user "postgres".105server # [ 6428.128713] server postgresql-pre-start[330]: This user must also own the server process.106server # [ 6428.129517] server postgresql-pre-start[330]: The database cluster will be initialized with locale "en_US.UTF-8".107server # [ 6428.129517] server postgresql-pre-start[330]: The default database encoding has accordingly been set to "UTF8".108server # [ 6428.129517] server postgresql-pre-start[330]: The default text search configuration will be set to "english".109server # [ 6428.129517] server postgresql-pre-start[330]: Data page checksums are disabled.110server # [ 6428.129517] server postgresql-pre-start[330]: fixing permissions on existing directory /var/lib/postgresql/17 ... ok111server # [ 6428.130964] server postgresql-pre-start[330]: creating subdirectories ... ok112server # [ 6428.131222] server postgresql-pre-start[330]: selecting dynamic shared memory implementation ... posix113server # [ 6428.132594] server nginx-pre-start[328]: nginx: the configuration file /nix/store/aw0gpg1vmbjsq6946grbwyqx9nvm7ccp-nginx.conf syntax is ok114server # [ 6428.133089] server nginx-pre-start[328]: nginx: configuration file /nix/store/aw0gpg1vmbjsq6946grbwyqx9nvm7ccp-nginx.conf test is successful115server # [ 6428.139356] server systemd[1]: Started Nginx Web Server.116server # [ 6428.162998] server postgresql-pre-start[330]: selecting default "max_connections" ... 100117server # [ 6428.190734] server postgresql-pre-start[330]: selecting default "shared_buffers" ... 128MB118server # [ 6428.380124] server dbus-broker-launch[324]: Looking up NSS user entry for 'systemd-timesync'...119server # [ 6428.381553] server dbus-broker-launch[324]: NSS returned no entry for 'systemd-timesync'120server # [ 6428.381553] server dbus-broker-launch[324]: Invalid user-name in /nix/store/1gvqr1047764nyf71px412fj6aiq939g-system-path/share/dbus-1/system.d/org.freedesktop.timesync1.conf +16: user="systemd-timesync"121server # [ 6428.382560] server systemd[1]: Started D-Bus System Message Bus.122server # [ 6428.400744] server dbus-broker-launch[324]: Ready123server # [ 6428.492936] server postgresql-pre-start[330]: selecting default time zone ... UTC124server # [ 6428.493884] server postgresql-pre-start[330]: creating configuration files ... ok125server # [ 6428.653801] server postgresql-pre-start[330]: running bootstrap script ... ok126server # [ 6429.125431] server postgresql-pre-start[330]: performing post-bootstrap initialization ... ok127server # [ 6429.873576] server postgresql-pre-start[330]: syncing data to disk ... ok128server # [ 6429.873576] server postgresql-pre-start[330]: initdb: warning: enabling "trust" authentication for local connections129server # [ 6429.873576] 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.130server # [ 6429.873576] server postgresql-pre-start[330]: Success. You can now start the database server using:131server # [ 6429.873576] server postgresql-pre-start[330]: pg_ctl -D /var/lib/postgresql/17 -l logfile start132server # [ 6431.088171] server postgres[350]: [350] LOG: starting PostgreSQL 17.10 on aarch64-unknown-linux-gnu, compiled by clang version 21.1.8, 64-bit133server # [ 6431.094031] server postgres[350]: [350] LOG: listening on IPv6 address "::1", port 5432134server # [ 6431.094031] server postgres[350]: [350] LOG: listening on IPv4 address "127.0.0.1", port 5432135server # [ 6431.098227] server postgres[350]: [350] LOG: listening on Unix socket "/run/postgresql/.s.PGSQL.5432"136server # [ 6431.112042] server postgres[356]: [356] LOG: database system was shut down at 2026-09-01 15:01:26 GMT137server # [ 6431.118249] server postgres[350]: [350] LOG: database system is ready to accept connections138server # [ 6431.123703] server systemd[1]: Started PostgreSQL Server.139server # [ 6431.125403] server systemd[1]: Starting PostgreSQL Setup Scripts...140server # [ 6431.341086] server postgresql-setup-start[367]: CREATE DATABASE141server # [ 6431.373137] server postgresql-setup-start[372]: CREATE ROLE142server # [ 6431.374924] server systemd[1]: Finished PostgreSQL Setup Scripts.143server # [ 6431.376126] server systemd[1]: Reached target PostgreSQL.144server # [ 6431.380271] server systemd[1]: Starting Mobilizon PostgreSQL setup...145server # [ 6431.960068] server mobilizon-postgresql-start[376]: CREATE EXTENSION146server # [ 6431.960068] server mobilizon-postgresql-start[376]: CREATE EXTENSION147server # [ 6431.960068] server mobilizon-postgresql-start[376]: CREATE EXTENSION148server # [ 6431.979161] server mobilizon-postgresql-start[378]: ALTER DATABASE149server # [ 6431.981121] server systemd[1]: mobilizon-postgresql.service: Deactivated successfully.150server # [ 6431.981333] server systemd[1]: Finished Mobilizon PostgreSQL setup.151server # [ 6431.983711] server systemd[1]: Starting Mobilizon setup secrets...152server # [ 6432.016365] server mobilizon-setup-secrets-start[381]: + '[' '!' -f /var/lib/mobilizon/secret-env.sh ']'153server # [ 6432.016365] server mobilizon-setup-secrets-start[381]: + install -m 600 /dev/null /var/lib/mobilizon/secret-env.sh154server # [ 6432.019067] server mobilizon-setup-secrets-start[381]: + cat155server # [ 6432.020454] 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))'156server # [ 6432.488124] 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))'157server # [ 6432.933728] 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)))'158server # [ 6433.375471] server systemd[1]: mobilizon-setup-secrets.service: Deactivated successfully.159server # [ 6433.375799] server systemd[1]: Finished Mobilizon setup secrets.160server # [ 6433.376146] server systemd[1]: mobilizon-setup-secrets.service: Consumed 1.958s CPU time over 1.391s wall clock time.161server # [ 6433.378762] server systemd[1]: Starting Mobilizon federated organization and mobilization platform...162server: still waiting for container 'server' to reach ready state...163server # [ 6434.209543] server mobilizon_ctl[536]: Loading app..164server # [ 6434.209543] server mobilizon_ctl[536]: Starting dependencies..165server # [ 6436.758073] server mobilizon_ctl[536]: #########################################################166server # [ 6436.758073] server mobilizon_ctl[536]: # If the CREATE EXTENSION or DROP EXTENSION calls fail, #167server # [ 6436.758073] server mobilizon_ctl[536]: # please manually execute them with an authorized #168server # [ 6436.758073] server mobilizon_ctl[536]: # PostgreSQL user with SUPER USER role. #169server # [ 6436.758073] server mobilizon_ctl[536]: #########################################################170server # [ 6436.758073] server mobilizon_ctl[536]:171server # [ 6436.758073] server mobilizon_ctl[536]:172server # [ 6436.758073] server mobilizon_ctl[536]: 15:01:34.307 [info] == Running 20180109150000 Mobilizon.Repo.Migrations.Prerequites.up/0 forward173server # [ 6436.760082] server mobilizon_ctl[536]: 15:01:34.311 [info] execute "CREATE TYPE datetimetz AS (\n dt timestamptz,\n tz varchar\n);\n"174server # [ 6436.762039] server mobilizon_ctl[536]: 15:01:34.313 [info] execute "CREATE EXTENSION IF NOT EXISTS postgis"175server # [ 6436.763000] server mobilizon_ctl[536]: 15:01:34.314 [info] extension "postgis" already exists, skipping176server # [ 6436.763000] server mobilizon_ctl[536]: 15:01:34.314 [info] execute "CREATE EXTENSION IF NOT EXISTS pg_trgm"177server # [ 6436.763244] server mobilizon_ctl[536]: 15:01:34.314 [info] extension "pg_trgm" already exists, skipping178server # [ 6436.763305] server mobilizon_ctl[536]: 15:01:34.314 [info] execute "CREATE EXTENSION IF NOT EXISTS unaccent"179server # [ 6436.763482] server mobilizon_ctl[536]: 15:01:34.314 [info] extension "unaccent" already exists, skipping180server # [ 6436.765150] server mobilizon_ctl[536]: 15:01:34.316 [info] == Migrated 20180109150000 in 0.0s181server # [ 6436.803412] server mobilizon_ctl[536]: 15:01:34.354 [info] == Running 20180109165738 Mobilizon.Repo.Migrations.CreateAccounts.change/0 forward182server # [ 6436.803724] server mobilizon_ctl[536]: 15:01:34.355 [info] create table accounts183server # [ 6436.807230] server mobilizon_ctl[536]: 15:01:34.358 [info] create index accounts_username_domain_index184server # [ 6436.809060] server mobilizon_ctl[536]: 15:01:34.360 [info] == Migrated 20180109165738 in 0.0s185server # [ 6436.818102] server mobilizon_ctl[536]: 15:01:34.369 [info] == Running 20180109170315 Mobilizon.Repo.Migrations.CreateUsers.change/0 forward186server # [ 6436.818539] server mobilizon_ctl[536]: 15:01:34.369 [info] create table users187server # [ 6436.824459] server mobilizon_ctl[536]: 15:01:34.375 [info] create index users_email_index188server # [ 6436.825386] server mobilizon_ctl[536]: 15:01:34.376 [info] == Migrated 20180109170315 in 0.0s189server # [ 6436.835580] server mobilizon_ctl[536]: 15:01:34.386 [info] == Running 20180110091747 Mobilizon.Repo.Migrations.CreateCategories.change/0 forward190server # [ 6436.835875] server mobilizon_ctl[536]: 15:01:34.387 [info] create table categories191server # [ 6436.838503] server mobilizon_ctl[536]: 15:01:34.389 [info] create index categories_title_index192server # [ 6436.839586] server mobilizon_ctl[536]: 15:01:34.390 [info] == Migrated 20180110091747 in 0.0s193server # [ 6436.841989] server mobilizon_ctl[536]: 15:01:34.393 [info] == Running 20180110092400 Mobilizon.Repo.Migrations.CreateAddresses.change/0 forward194server # [ 6436.842114] server mobilizon_ctl[536]: 15:01:34.393 [info] create table addresses195server # [ 6436.844837] server mobilizon_ctl[536]: 15:01:34.396 [info] == Migrated 20180110092400 in 0.0s196server # [ 6436.850956] server mobilizon_ctl[536]: 15:01:34.402 [info] == Running 20180110092500 Mobilizon.Repo.Migrations.CreateGroups.change/0 forward197server # [ 6436.851775] server mobilizon_ctl[536]: 15:01:34.402 [info] create table groups198server # [ 6436.856156] server mobilizon_ctl[536]: 15:01:34.407 [info] create index groups_slug_index199server # [ 6436.857092] server mobilizon_ctl[536]: 15:01:34.408 [info] == Migrated 20180110092500 in 0.0s200server # [ 6436.864461] server mobilizon_ctl[536]: 15:01:34.415 [info] == Running 20180110092600 Mobilizon.Repo.Migrations.CreateEvents.change/0 forward201server # [ 6436.865104] server mobilizon_ctl[536]: 15:01:34.416 [info] create table events202server # [ 6436.870781] server mobilizon_ctl[536]: 15:01:34.422 [info] create index events_organizer_account_id_index203server # [ 6436.871652] server mobilizon_ctl[536]: 15:01:34.422 [info] create index events_organizer_group_id_index204server # [ 6436.872967] server mobilizon_ctl[536]: 15:01:34.424 [info] create index events_slug_index205server # [ 6436.874399] server mobilizon_ctl[536]: 15:01:34.425 [info] == Migrated 20180110092600 in 0.0s206server # [ 6436.882375] server mobilizon_ctl[536]: 15:01:34.433 [info] == Running 20180110093905 Mobilizon.Repo.Migrations.CreateTags.change/0 forward207server # [ 6436.882767] server mobilizon_ctl[536]: 15:01:34.434 [info] create table tags208server # [ 6436.885691] server mobilizon_ctl[536]: 15:01:34.437 [info] create index tags_slug_index209server # [ 6436.886571] server mobilizon_ctl[536]: 15:01:34.437 [info] == Migrated 20180110093905 in 0.0s210server # [ 6436.894300] server mobilizon_ctl[536]: 15:01:34.445 [info] == Running 20180110093906 Mobilizon.Repo.Migrations.CreateEventsTags.change/0 forward211server # [ 6436.894695] server mobilizon_ctl[536]: 15:01:34.445 [info] create table events_tags212server # [ 6436.896970] server mobilizon_ctl[536]: 15:01:34.448 [info] == Migrated 20180110093906 in 0.0s213server # [ 6436.903318] server mobilizon_ctl[536]: 15:01:34.454 [info] == Running 20180110094301 Mobilizon.Repo.Migrations.CreateParticipants.change/0 forward214server # [ 6436.903560] server mobilizon_ctl[536]: 15:01:34.454 [info] create table participants215server # [ 6436.906905] server mobilizon_ctl[536]: 15:01:34.458 [info] create index participants_event_id_index216server # [ 6436.908038] server mobilizon_ctl[536]: 15:01:34.459 [info] create index participants_account_id_index217server # [ 6436.908992] server mobilizon_ctl[536]: 15:01:34.460 [info] == Migrated 20180110094301 in 0.0s218server # [ 6436.918200] server mobilizon_ctl[536]: 15:01:34.469 [info] == Running 20180110094502 Mobilizon.Repo.Migrations.CreateEventRequests.change/0 forward219server # [ 6436.918791] server mobilizon_ctl[536]: 15:01:34.469 [info] create table event_requests220server # [ 6436.921871] server mobilizon_ctl[536]: 15:01:34.473 [info] create index event_requests_event_id_index221server # [ 6436.922787] server mobilizon_ctl[536]: 15:01:34.474 [info] create index event_requests_account_id_index222server # [ 6436.923849] server mobilizon_ctl[536]: 15:01:34.474 [info] == Migrated 20180110094502 in 0.0s223server # [ 6436.932108] server mobilizon_ctl[536]: 15:01:34.483 [info] == Running 20180110095317 Mobilizon.Repo.Migrations.CreateMembers.change/0 forward224server # [ 6436.932649] server mobilizon_ctl[536]: 15:01:34.483 [info] create table members225server # [ 6436.935214] server mobilizon_ctl[536]: 15:01:34.486 [info] create index members_group_id_index226server # [ 6436.936044] server mobilizon_ctl[536]: 15:01:34.487 [info] create index members_account_id_index227server # [ 6436.937005] server mobilizon_ctl[536]: 15:01:34.488 [info] == Migrated 20180110095317 in 0.0s228server # [ 6436.944246] server mobilizon_ctl[536]: 15:01:34.495 [info] == Running 20180110095515 Mobilizon.Repo.Migrations.CreateGroupRequests.change/0 forward229server # [ 6436.944760] server mobilizon_ctl[536]: 15:01:34.495 [info] create table group_requests230server # [ 6436.948415] server mobilizon_ctl[536]: 15:01:34.499 [info] create index group_requests_group_id_index231server # [ 6436.949475] server mobilizon_ctl[536]: 15:01:34.500 [info] create index group_requests_account_id_index232server # [ 6436.950341] server mobilizon_ctl[536]: 15:01:34.501 [info] == Migrated 20180110095515 in 0.0s233server # [ 6436.959362] server mobilizon_ctl[536]: 15:01:34.510 [info] == Running 20180110165029 Mobilizon.Repo.Migrations.Guardian.DB.change/0 forward234server # [ 6436.959729] server mobilizon_ctl[536]: 15:01:34.510 [info] create table guardian_tokens235server # [ 6436.963325] server mobilizon_ctl[536]: 15:01:34.514 [info] == Migrated 20180110165029 in 0.0s236server # [ 6436.968980] server mobilizon_ctl[536]: 15:01:34.520 [info] == Running 20180112100000 Mobilizon.Repo.Migrations.CreateTracks.change/0 forward237server # [ 6436.969243] server mobilizon_ctl[536]: 15:01:34.520 [info] create table tracks238server # [ 6436.973127] server mobilizon_ctl[536]: 15:01:34.524 [info] == Migrated 20180112100000 in 0.0s239server # [ 6436.980688] server mobilizon_ctl[536]: 15:01:34.531 [info] == Running 20180112105354 Mobilizon.Repo.Migrations.CreateSessions.change/0 forward240server # [ 6436.981316] server mobilizon_ctl[536]: 15:01:34.532 [info] create table sessions241server # [ 6436.985860] server mobilizon_ctl[536]: 15:01:34.536 [info] == Migrated 20180112105354 in 0.0s242server # [ 6436.995004] server mobilizon_ctl[536]: 15:01:34.546 [info] == Running 20180430071244 Mobilizon.Repo.Migrations.RemoveUri.up/0 forward243server # [ 6436.995176] server mobilizon_ctl[536]: 15:01:34.546 [info] alter table accounts244server # [ 6436.996423] server mobilizon_ctl[536]: 15:01:34.547 [info] alter table groups245server # [ 6436.997154] server mobilizon_ctl[536]: 15:01:34.548 [info] == Migrated 20180430071244 in 0.0s246server # [ 6437.002022] server mobilizon_ctl[536]: 15:01:34.553 [info] == Running 20180515091106 Mobilizon.Repo.Migrations.AddUrlFieldToEvents.up/0 forward247server # [ 6437.002164] server mobilizon_ctl[536]: 15:01:34.553 [info] alter table events248server # [ 6437.003543] server mobilizon_ctl[536]: 15:01:34.554 [info] == Migrated 20180515091106 in 0.0s249server # [ 6437.009302] server mobilizon_ctl[536]: 15:01:34.560 [info] == Running 20180515100237 Mobilizon.Repo.Migrations.CreateComments.change/0 forward250server # [ 6437.009603] server mobilizon_ctl[536]: 15:01:34.560 [info] create table comments251server # [ 6437.013934] server mobilizon_ctl[536]: 15:01:34.565 [info] == Migrated 20180515100237 in 0.0s252server # [ 6437.021329] server mobilizon_ctl[536]: 15:01:34.572 [info] == Running 20180515142835 Mobilizon.Repo.Migrations.AlterEventTimestampsToDateTimeWithTimeZone.up/0 forward253server # [ 6437.021500] server mobilizon_ctl[536]: 15:01:34.572 [info] alter table events254server # [ 6437.022383] server mobilizon_ctl[536]: 15:01:34.573 [info] == Migrated 20180515142835 in 0.0s255server # [ 6437.028920] server mobilizon_ctl[536]: 15:01:34.580 [info] == Running 20180515145438 Mobilizon.Repo.Migrations.AddLocalAttributeToEventsAndComments.up/0 forward256server # [ 6437.029178] server mobilizon_ctl[536]: 15:01:34.580 [info] alter table events257server # [ 6437.030057] server mobilizon_ctl[536]: 15:01:34.581 [info] alter table comments258server # [ 6437.030784] server mobilizon_ctl[536]: 15:01:34.582 [info] == Migrated 20180515145438 in 0.0s259server # [ 6437.035719] server mobilizon_ctl[536]: 15:01:34.586 [info] == Running 20180517100700 Mobilizon.Repo.Migrations.MoveFromAccountToActor.up/0 forward260server # [ 6437.039249] server mobilizon_ctl[536]: 15:01:34.590 [info] drop table event_requests261server # [ 6437.042248] server mobilizon_ctl[536]: 15:01:34.593 [info] drop table group_requests262server # [ 6437.043632] server mobilizon_ctl[536]: 15:01:34.594 [info] alter table events263server # [ 6437.044781] server mobilizon_ctl[536]: 15:01:34.595 [info] rename column account_id to actor_id on table members264server # [ 6437.045483] server mobilizon_ctl[536]: 15:01:34.596 [info] alter table members265server # [ 6437.047904] server mobilizon_ctl[536]: 15:01:34.599 [info] drop table groups266server # [ 6437.049283] server mobilizon_ctl[536]: 15:01:34.600 [info] rename table accounts to actors267server # [ 6437.049937] server mobilizon_ctl[536]: 15:01:34.601 [info] execute "CREATE TYPE public.actor_type AS ENUM ('Person', 'Application', 'Group', 'Organization', 'Service')"268server # [ 6437.050973] server mobilizon_ctl[536]: 15:01:34.602 [info] rename column username to name on table actors269server # [ 6437.051561] server mobilizon_ctl[536]: 15:01:34.602 [info] rename column description to summary on table actors270server # [ 6437.052110] server mobilizon_ctl[536]: 15:01:34.603 [info] rename column display_name to preferred_username on table actors271server # [ 6437.052404] server mobilizon_ctl[536]: 15:01:34.603 [info] alter table actors272server # [ 6437.054625] server mobilizon_ctl[536]: 15:01:34.605 [info] create index actors_preferred_username_domain_index273server # [ 6437.056055] server mobilizon_ctl[536]: 15:01:34.607 [info] rename column organizer_account_id to organizer_actor_id on table events274server # [ 6437.056647] server mobilizon_ctl[536]: 15:01:34.607 [info] rename column account_id to actor_id on table participants275server # [ 6437.057176] server mobilizon_ctl[536]: 15:01:34.608 [info] create table followers276server # [ 6437.061641] server mobilizon_ctl[536]: 15:01:34.612 [info] rename column account_id to actor_id on table comments277server # [ 6437.062328] server mobilizon_ctl[536]: 15:01:34.613 [info] rename column account_id to actor_id on table users278server # [ 6437.063013] server mobilizon_ctl[536]: 15:01:34.614 [info] == Migrated 20180517100700 in 0.0s279server # [ 6437.076127] server mobilizon_ctl[536]: 15:01:34.627 [info] == Running 20180522133844 Mobilizon.Repo.Migrations.AddBotsTable.up/0 forward280server # [ 6437.076127] server mobilizon_ctl[536]: 15:01:34.627 [info] create table bots281server # [ 6437.079679] server mobilizon_ctl[536]: 15:01:34.630 [info] == Migrated 20180522133844 in 0.0s282server # [ 6437.089574] server mobilizon_ctl[536]: 15:01:34.640 [info] == Running 20180530125159 Mobilizon.Repo.Migrations.AddAvatarAndBannerToActor.up/0 forward283server # [ 6437.089774] server mobilizon_ctl[536]: 15:01:34.641 [info] alter table actors284server # [ 6437.090938] server mobilizon_ctl[536]: 15:01:34.642 [info] == Migrated 20180530125159 in 0.0s285server # [ 6437.095920] server mobilizon_ctl[536]: 15:01:34.647 [info] == Running 20180530152323 Mobilizon.Repo.Migrations.MakeActorPublicKeyNullable.up/0 forward286server # [ 6437.096218] server mobilizon_ctl[536]: 15:01:34.647 [info] alter table actors287server # [ 6437.097482] server mobilizon_ctl[536]: 15:01:34.648 [info] == Migrated 20180530152323 in 0.0s288server # [ 6437.102505] server mobilizon_ctl[536]: 15:01:34.653 [info] == Running 20180530170808 Mobilizon.Repo.Migrations.AddUUIDIdToEvents.up/0 forward289server # [ 6437.102647] server mobilizon_ctl[536]: 15:01:34.653 [info] alter table events290server # [ 6437.103939] server mobilizon_ctl[536]: 15:01:34.655 [info] == Migrated 20180530170808 in 0.0s291server # [ 6437.109972] server mobilizon_ctl[536]: 15:01:34.661 [info] == Running 20180531162301 Mobilizon.Repo.Migrations.AddApprovedStatusToMember.up/0 forward292server # [ 6437.110138] server mobilizon_ctl[536]: 15:01:34.661 [info] alter table members293server # [ 6437.111085] server mobilizon_ctl[536]: 15:01:34.662 [info] == Migrated 20180531162301 in 0.0s294server # [ 6437.113940] server mobilizon_ctl[536]: 15:01:34.665 [info] == Running 20180607095732 Mobilizon.Repo.Migrations.AddUUIDToComments.up/0 forward295server # [ 6437.114280] server mobilizon_ctl[536]: 15:01:34.665 [info] alter table comments296server # [ 6437.115522] server mobilizon_ctl[536]: 15:01:34.666 [info] == Migrated 20180607095732 in 0.0s297server # [ 6437.121697] server mobilizon_ctl[536]: 15:01:34.672 [info] == Running 20180614094653 Mobilizon.Repo.Migrations.MakeSharedInboxUrlNullable.up/0 forward298server # [ 6437.121971] server mobilizon_ctl[536]: 15:01:34.673 [info] alter table actors299server # [ 6437.123250] server mobilizon_ctl[536]: 15:01:34.674 [info] == Migrated 20180614094653 in 0.0s300server # [ 6437.130193] server mobilizon_ctl[536]: 15:01:34.681 [info] == Running 20180614104618 Mobilizon.Repo.Migrations.FusionPublicPrivateKeyIntoKeysColumn.up/0 forward301server # [ 6437.130193] server mobilizon_ctl[536]: 15:01:34.681 [info] rename column private_key to keys on table actors302server # [ 6437.130877] server mobilizon_ctl[536]: 15:01:34.682 [info] alter table actors303server # [ 6437.131704] server mobilizon_ctl[536]: 15:01:34.682 [info] == Migrated 20180614104618 in 0.0s304server # [ 6437.134490] server mobilizon_ctl[536]: 15:01:34.685 [info] == Running 20180614131328 Mobilizon.Repo.Migrations.AddAttributedToFieldToEventsAndComments.up/0 forward305server # [ 6437.134661] server mobilizon_ctl[536]: 15:01:34.686 [info] alter table events306server # [ 6437.137633] server mobilizon_ctl[536]: 15:01:34.688 [info] alter table comments307server # [ 6437.139898] server mobilizon_ctl[536]: 15:01:34.691 [info] == Migrated 20180614131328 in 0.0s308server # [ 6437.149392] server mobilizon_ctl[536]: 15:01:34.700 [info] == Running 20180628091920 :"Elixir.Mobilizon.Repo.Migrations.Add-user-confirm-email-fields".up/0 forward309server # [ 6437.149667] server mobilizon_ctl[536]: 15:01:34.700 [info] alter table users310server # [ 6437.151266] server mobilizon_ctl[536]: 15:01:34.702 [info] create index index_unique_users_confirmation_token311server # [ 6437.152518] server mobilizon_ctl[536]: 15:01:34.703 [info] == Migrated 20180628091920 in 0.0s312server # [ 6437.159466] server mobilizon_ctl[536]: 15:01:34.710 [info] == Running 20180628130746 :"Elixir.Mobilizon.Repo.Migrations.Add-user-password-reset-fields".up/0 forward313server # [ 6437.159825] server mobilizon_ctl[536]: 15:01:34.711 [info] alter table users314server # [ 6437.160711] server mobilizon_ctl[536]: 15:01:34.712 [info] create index index_unique_users_reset_password_token315server # [ 6437.162459] server mobilizon_ctl[536]: 15:01:34.713 [info] == Migrated 20180628130746 in 0.0s316server # [ 6437.170154] server mobilizon_ctl[536]: 15:01:34.721 [info] == Running 20180628142835 Mobilizon.Repo.Migrations.RevertAlterEventTimestampsToDateTimeWithTimeZone.up/0 forward317server # [ 6437.170297] server mobilizon_ctl[536]: 15:01:34.721 [info] alter table events318server # [ 6437.171325] server mobilizon_ctl[536]: 15:01:34.722 [info] == Migrated 20180628142835 in 0.0s319server # [ 6437.174562] server mobilizon_ctl[536]: 15:01:34.725 [info] == Running 20180702150922 Mobilizon.Repo.Migrations.AddAddressType.up/0 forward320server # [ 6437.174757] server mobilizon_ctl[536]: 15:01:34.726 [info] alter table events321server # [ 6437.175481] server mobilizon_ctl[536]: 15:01:34.726 [info] drop constraint events_address_id_fkey from table events322server # [ 6437.176436] server mobilizon_ctl[536]: 15:01:34.727 [info] rename column address_id to physical_address_id on table events323server # [ 6437.177086] server mobilizon_ctl[536]: 15:01:34.728 [info] alter table events324server # [ 6437.178654] server mobilizon_ctl[536]: 15:01:34.729 [info] == Migrated 20180702150922 in 0.0s325server # [ 6437.184581] server mobilizon_ctl[536]: 15:01:34.735 [info] == Running 20180702154630 Mobilizon.Repo.Migrations.RemoveSlugForEvent.up/0 forward326server # [ 6437.184708] server mobilizon_ctl[536]: 15:01:34.736 [info] alter table events327server # [ 6437.185755] server mobilizon_ctl[536]: 15:01:34.737 [info] == Migrated 20180702154630 in 0.0s328server # [ 6437.191268] server mobilizon_ctl[536]: 15:01:34.742 [info] == Running 20180706082208 Mobilizon.Repo.Migrations.AlterEventsSetDescriptionAsText.up/0 forward329server # [ 6437.191518] server mobilizon_ctl[536]: 15:01:34.742 [info] alter table events330server # [ 6437.192594] server mobilizon_ctl[536]: 15:01:34.743 [info] == Migrated 20180706082208 in 0.0s331server # [ 6437.198436] server mobilizon_ctl[536]: 15:01:34.749 [info] == Running 20180709154152 Mobilizon.Repo.Migrations.AllowMultipleAccountsForUser.up/0 forward332server # [ 6437.198704] server mobilizon_ctl[536]: 15:01:34.750 [info] alter table actors333server # [ 6437.200517] server mobilizon_ctl[536]: 15:01:34.751 [info] alter table users334server # [ 6437.201575] server mobilizon_ctl[536]: 15:01:34.752 [info] == Migrated 20180709154152 in 0.0s335server # [ 6437.204744] server mobilizon_ctl[536]: 15:01:34.756 [info] == Running 20180802133951 Mobilizon.Repo.Migrations.MakeFollowerTableUnique.up/0 forward336server # [ 6437.204910] server mobilizon_ctl[536]: 15:01:34.756 [info] create index followers_actor_target_actor_unique_index337server # [ 6437.206325] server mobilizon_ctl[536]: 15:01:34.757 [info] == Migrated 20180802133951 in 0.0s338server # [ 6437.211688] server mobilizon_ctl[536]: 15:01:34.762 [info] == Running 20180816093446 Mobilizon.Repo.Migrations.AddPrimaryKeyToMember.up/0 forward339server # [ 6437.212068] server mobilizon_ctl[536]: 15:01:34.763 [info] execute "ALTER TABLE members DROP CONSTRAINT IF EXISTS members_pkey"340server # [ 6437.212574] server mobilizon_ctl[536]: 15:01:34.763 [info] constraint "members_pkey" of relation "members" does not exist, skipping341server # [ 6437.212685] server mobilizon_ctl[536]: 15:01:34.763 [info] drop index if exists members_members_account_id_index_index342server # [ 6437.212907] server mobilizon_ctl[536]: 15:01:34.764 [info] index "members_members_account_id_index_index" does not exist, skipping343server # [ 6437.212907] server mobilizon_ctl[536]: 15:01:34.764 [info] create index members_actor_parent_unique_index344server # [ 6437.213894] server mobilizon_ctl[536]: 15:01:34.765 [info] alter table members345server # [ 6437.216847] server mobilizon_ctl[536]: 15:01:34.767 [info] == Migrated 20180816093446 in 0.0s346server # [ 6437.225455] server mobilizon_ctl[536]: 15:01:34.776 [info] == Running 20181021161324 Mobilizon.Repo.Migrations.AddDefaultActorUserField.up/0 forward347server # [ 6437.225770] server mobilizon_ctl[536]: 15:01:34.777 [info] alter table users348server # [ 6437.226638] server mobilizon_ctl[536]: 15:01:34.777 [info] == Migrated 20181021161324 in 0.0s349server # [ 6437.229335] server mobilizon_ctl[536]: 15:01:34.780 [info] == Running 20181108165151 Mobilizon.Repo.Migrations.FixCommentsReferences.up/0 forward350server # [ 6437.229528] server mobilizon_ctl[536]: 15:01:34.780 [info] drop constraint comments_in_reply_to_comment_id_fkey from table comments351server # [ 6437.230265] server mobilizon_ctl[536]: 15:01:34.781 [info] drop constraint comments_origin_comment_id_fkey from table comments352server # [ 6437.230876] server mobilizon_ctl[536]: 15:01:34.782 [info] alter table comments353server # [ 6437.232648] server mobilizon_ctl[536]: 15:01:34.783 [info] == Migrated 20181108165151 in 0.0s354server # [ 6437.238433] server mobilizon_ctl[536]: 15:01:34.789 [info] == Running 20181203092128 Mobilizon.Repo.Migrations.ChangeActorsIndexes.up/0 forward355server # [ 6437.238869] server mobilizon_ctl[536]: 15:01:34.790 [info] drop index actors_preferred_username_domain_index356server # [ 6437.239796] server mobilizon_ctl[536]: 15:01:34.791 [info] drop index accounts_username_domain_index357server # [ 6437.240649] server mobilizon_ctl[536]: 15:01:34.791 [info] execute "ALTER INDEX accounts_pkey RENAME TO actors_pkey"358server # [ 6437.241341] server mobilizon_ctl[536]: 15:01:34.792 [info] create index actors_preferred_username_domain_type_index359server # [ 6437.243301] server mobilizon_ctl[536]: 15:01:34.794 [info] create index actors_url_index360server # [ 6437.244133] server mobilizon_ctl[536]: 15:01:34.795 [info] == Migrated 20181203092128 in 0.0s361server # [ 6437.254178] server mobilizon_ctl[536]: 15:01:34.805 [info] == Running 20190103150805 Mobilizon.Repo.Migrations.FixEventVisibility.up/0 forward362server # [ 6437.254545] server mobilizon_ctl[536]: 15:01:34.805 [info] execute "CREATE TYPE public.event_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')"363server # [ 6437.255304] server mobilizon_ctl[536]: 15:01:34.806 [info] execute "CREATE TYPE public.event_status AS ENUM ('tentative', 'confirmed', 'cancelled')"364server # [ 6437.255775] server mobilizon_ctl[536]: 15:01:34.807 [info] execute "CREATE TYPE public.comment_visibility AS ENUM ('public', 'unlisted', 'private', 'moderated', 'invite')"365server # [ 6437.256219] server mobilizon_ctl[536]: 15:01:34.807 [info] alter table events366server # [ 6437.257278] server mobilizon_ctl[536]: 15:01:34.808 [info] alter table comments367server # [ 6437.257920] server mobilizon_ctl[536]: 15:01:34.809 [info] == Migrated 20190103150805 in 0.0s368server # [ 6437.270236] server mobilizon_ctl[536]: 15:01:34.821 [info] == Running 20190114162055 Mobilizon.Repo.Migrations.RemoveAddressType.up/0 forward369server # [ 6437.270236] server mobilizon_ctl[536]: 15:01:34.821 [info] execute "ALTER TABLE \"events\" DROP COLUMN IF EXISTS address_type"370server # [ 6437.271350] server mobilizon_ctl[536]: 15:01:34.822 [info] column "address_type" of relation "events" does not exist, skipping371server # [ 6437.271845] server mobilizon_ctl[536]: 15:01:34.822 [info] execute "DROP TYPE IF EXISTS address_type"372server # [ 6437.272330] server mobilizon_ctl[536]: 15:01:34.822 [info] type "address_type" does not exist, skipping373server # [ 6437.272330] server mobilizon_ctl[536]: 15:01:34.822 [info] rename column phone to phone_address on table events374server # [ 6437.272330] server mobilizon_ctl[536]: 15:01:34.822 [info] == Migrated 20190114162055 in 0.0s375server # [ 6437.274616] server mobilizon_ctl[536]: 15:01:34.825 [info] == Running 20190125143718 Mobilizon.Repo.Migrations.GroupDeleteMembersCascade.change/0 forward376server # [ 6437.274870] server mobilizon_ctl[536]: 15:01:34.826 [info] drop constraint members_account_id_fkey from table members377server # [ 6437.275628] server mobilizon_ctl[536]: 15:01:34.827 [info] drop constraint members_parent_id_fkey from table members378server # [ 6437.276188] server mobilizon_ctl[536]: 15:01:34.827 [info] alter table members379server # [ 6437.278988] server mobilizon_ctl[536]: 15:01:34.830 [info] == Migrated 20190125143718 in 0.0s380server # [ 6437.287425] server mobilizon_ctl[536]: 15:01:34.838 [info] == Running 20190130151607 Mobilizon.Repo.Migrations.SplitEventVisibilityAndJoinOptions.up/0 forward381server # [ 6437.287752] server mobilizon_ctl[536]: 15:01:34.839 [info] execute "ALTER TABLE events ALTER COLUMN visibility TYPE VARCHAR USING visibility::text"382server # [ 6437.292528] server mobilizon_ctl[536]: 15:01:34.843 [info] execute "DROP TYPE public.event_visibility"383server # [ 6437.293230] server mobilizon_ctl[536]: 15:01:34.844 [info] execute "CREATE TYPE public.event_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')"384server # [ 6437.294085] server mobilizon_ctl[536]: 15:01:34.845 [info] execute "ALTER TABLE events ALTER COLUMN visibility TYPE event_visibility USING visibility::event_visibility"385server # [ 6437.296638] server mobilizon_ctl[536]: 15:01:34.847 [info] execute "CREATE TYPE public.join_options AS ENUM ('free', 'restricted', 'invite', 'external')"386server # [ 6437.297052] server mobilizon_ctl[536]: 15:01:34.848 [info] alter table events387server # [ 6437.298283] server mobilizon_ctl[536]: 15:01:34.849 [info] execute "UPDATE events SET visibility = 'public' WHERE visibility IS NULL"388server # [ 6437.299349] server mobilizon_ctl[536]: 15:01:34.850 [info] alter table events389server # [ 6437.300300] server mobilizon_ctl[536]: 15:01:34.851 [info] == Migrated 20190130151607 in 0.0s390server # [ 6437.308212] server mobilizon_ctl[536]: 15:01:34.859 [info] == Running 20190207134142 Mobilizon.Repo.Migrations.MoveParticipantRoleToEnum.up/0 forward391server # [ 6437.308651] server mobilizon_ctl[536]: 15:01:34.859 [info] execute "CREATE TYPE public.participant_role AS ENUM ('not_approved', 'not_confirmed', 'rejected', 'participant', 'moderator', 'administrator', 'creator')"392server # [ 6437.309252] server mobilizon_ctl[536]: 15:01:34.860 [info] alter table participants393server # [ 6437.310537] server mobilizon_ctl[536]: 15:01:34.861 [info] execute "UPDATE participants set role_tmp = 'not_approved' where role = 0"394server # [ 6437.311117] server mobilizon_ctl[536]: 15:01:34.862 [info] execute "UPDATE participants set role_tmp = 'participant' where role = 1"395server # [ 6437.311532] server mobilizon_ctl[536]: 15:01:34.862 [info] execute "UPDATE participants set role_tmp = 'moderator' where role = 2"396server # [ 6437.312025] server mobilizon_ctl[536]: 15:01:34.863 [info] execute "UPDATE participants set role_tmp = 'administrator' where role = 3"397server # [ 6437.312306] server mobilizon_ctl[536]: 15:01:34.863 [info] execute "UPDATE participants set role_tmp = 'creator' where role = 4"398server # [ 6437.312559] server mobilizon_ctl[536]: 15:01:34.863 [info] alter table participants399server # [ 6437.313050] server mobilizon_ctl[536]: 15:01:34.864 [info] rename column role_tmp to role on table participants400server # [ 6437.313481] server mobilizon_ctl[536]: 15:01:34.864 [info] == Migrated 20190207134142 in 0.0s401server # [ 6437.318995] server mobilizon_ctl[536]: 15:01:34.870 [info] == Running 20190208141700 Mobilizon.Repo.Migrations.TagsRelations.up/0 forward402server # [ 6437.319284] server mobilizon_ctl[536]: 15:01:34.870 [info] create table tag_relations403server # [ 6437.321797] server mobilizon_ctl[536]: 15:01:34.873 [info] create check constraint no_self_loops_check on table tag_relations404server # [ 6437.322529] server mobilizon_ctl[536]: 15:01:34.873 [info] create index index_tag_relations_tag_id405server # [ 6437.324110] server mobilizon_ctl[536]: 15:01:34.875 [info] create index index_tag_relations_link_id406server # [ 6437.325616] server mobilizon_ctl[536]: 15:01:34.876 [info] == Migrated 20190208141700 in 0.0s407server # [ 6437.337042] server mobilizon_ctl[536]: 15:01:34.888 [info] == Running 20190214100858 Mobilizon.Repo.Migrations.DropDatetimetz.up/0 forward408server # [ 6437.337336] server mobilizon_ctl[536]: 15:01:34.888 [info] alter table events409server # [ 6437.338580] server mobilizon_ctl[536]: 15:01:34.889 [info] alter table sessions410server # [ 6437.339277] server mobilizon_ctl[536]: 15:01:34.890 [info] execute "DROP TYPE datetimetz"411server # [ 6437.340030] server mobilizon_ctl[536]: 15:01:34.891 [info] == Migrated 20190214100858 in 0.0s412server # [ 6437.345983] server mobilizon_ctl[536]: #########################################################413server # [ 6437.345983] server mobilizon_ctl[536]: # If the CREATE EXTENSION or DROP EXTENSION calls fail, #414server # [ 6437.345983] server mobilizon_ctl[536]: # please manually execute them with an authorized #415server # [ 6437.345983] server mobilizon_ctl[536]: # PostgreSQL user with SUPER USER role. #416server # [ 6437.345983] server mobilizon_ctl[536]: #########################################################417server # [ 6437.345983] server mobilizon_ctl[536]:418server # [ 6437.345983] server mobilizon_ctl[536]:419server # [ 6437.345983] server mobilizon_ctl[536]: 15:01:34.897 [info] == Running 20190219164310 Mobilizon.Repo.Migrations.CreateSearchIndexes.change/0 forward420server # [ 6437.346567] server mobilizon_ctl[536]: 15:01:34.897 [info] execute "CREATE EXTENSION IF NOT EXISTS pg_trgm"421server # [ 6437.346805] server mobilizon_ctl[536]: 15:01:34.898 [info] extension "pg_trgm" already exists, skipping422server # [ 6437.346974] server mobilizon_ctl[536]: 15:01:34.898 [info] execute "CREATE EXTENSION IF NOT EXISTS unaccent"423server # [ 6437.347190] server mobilizon_ctl[536]: 15:01:34.898 [info] extension "unaccent" already exists, skipping424server # [ 6437.347190] server mobilizon_ctl[536]: 15:01:34.898 [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;"425server # [ 6437.348078] server mobilizon_ctl[536]: 15:01:34.899 [info] execute "CREATE INDEX \"event_title_trigram\" ON \"events\" USING GIN (f_unaccent(title) gin_trgm_ops)"426server # [ 6437.350060] server mobilizon_ctl[536]: 15:01:34.901 [info] execute "CREATE INDEX \"actor_preferred_username_trigram\" ON \"actors\"\n USING GIN (f_unaccent(preferred_username) gin_trgm_ops)"427server # [ 6437.351001] server mobilizon_ctl[536]: 15:01:34.902 [info] execute "CREATE INDEX \"actor_name_trigram\" ON \"actors\"\n USING GIN (f_unaccent(name) gin_trgm_ops)"428server # [ 6437.352382] server mobilizon_ctl[536]: 15:01:34.903 [info] == Migrated 20190219164310 in 0.0s429server # [ 6437.357939] server mobilizon_ctl[536]: 15:01:34.909 [info] == Running 20190222151449 Mobilizon.Repo.Migrations.DropCategories.up/0 forward430server # [ 6437.358101] server mobilizon_ctl[536]: 15:01:34.909 [info] alter table events431server # [ 6437.359328] server mobilizon_ctl[536]: 15:01:34.910 [info] drop table categories432server # [ 6437.360391] server mobilizon_ctl[536]: 15:01:34.911 [info] == Migrated 20190222151449 in 0.0s433server # [ 6437.363581] server mobilizon_ctl[536]: 15:01:34.914 [info] == Running 20190301141830 Mobilizon.Repo.Migrations.MoveMemberRoleToEnum.up/0 forward434server # [ 6437.363798] server mobilizon_ctl[536]: 15:01:34.915 [info] execute "CREATE TYPE public.member_role AS ENUM ('invited', 'not_approved', 'member', 'moderator', 'administrator', 'creator', 'rejected')"435server # [ 6437.364531] server mobilizon_ctl[536]: 15:01:34.915 [info] alter table members436server # [ 6437.365517] server mobilizon_ctl[536]: 15:01:34.916 [info] execute "UPDATE members set role_tmp = 'member' where role = 0"437server # [ 6437.366265] server mobilizon_ctl[536]: 15:01:34.917 [info] execute "UPDATE members set role_tmp = 'moderator' where role = 1"438server # [ 6437.366633] server mobilizon_ctl[536]: 15:01:34.918 [info] execute "UPDATE members set role_tmp = 'creator' where role = 2"439server # [ 6437.366960] server mobilizon_ctl[536]: 15:01:34.918 [info] execute "UPDATE members set role_tmp = 'not_approved' where approved is false"440server # [ 6437.367804] server mobilizon_ctl[536]: 15:01:34.919 [info] alter table members441server # [ 6437.368344] server mobilizon_ctl[536]: 15:01:34.919 [info] rename column role_tmp to role on table members442server # [ 6437.368780] server mobilizon_ctl[536]: 15:01:34.920 [info] == Migrated 20190301141830 in 0.0s443server # [ 6437.373300] server mobilizon_ctl[536]: 15:01:34.924 [info] == Running 20190301143831 Mobilizon.Repo.Migrations.ActorGroupOpenness.up/0 forward444server # [ 6437.376887] server mobilizon_ctl[536]: 15:01:34.928 [info] execute "CREATE TYPE public.actor_openness AS ENUM ('invite_only', 'moderated', 'open')"445server # [ 6437.377565] server mobilizon_ctl[536]: 15:01:34.928 [info] alter table actors446server # [ 6437.378459] server mobilizon_ctl[536]: 15:01:34.929 [info] == Migrated 20190301143831 in 0.0s447server # [ 6437.384816] server mobilizon_ctl[536]: 15:01:34.936 [info] == Running 20190307125009 Mobilizon.Repo.Migrations.MoveUserRoleToEnum.up/0 forward448server # [ 6437.385035] server mobilizon_ctl[536]: 15:01:34.936 [info] execute "CREATE TYPE public.user_role AS ENUM ('administrator', 'moderator', 'user', 'pending')"449server # [ 6437.385809] server mobilizon_ctl[536]: 15:01:34.937 [info] alter table users450server # [ 6437.386840] server mobilizon_ctl[536]: 15:01:34.938 [info] execute "UPDATE users set role_tmp = 'user' where role = 0"451server # [ 6437.387782] server mobilizon_ctl[536]: 15:01:34.939 [info] execute "UPDATE users set role_tmp = 'moderator' where role = 1"452server # [ 6437.388301] server mobilizon_ctl[536]: 15:01:34.939 [info] execute "UPDATE users set role_tmp = 'administrator' where role = 2"453server # [ 6437.388643] server mobilizon_ctl[536]: 15:01:34.940 [info] alter table users454server # [ 6437.389100] server mobilizon_ctl[536]: 15:01:34.940 [info] rename column role_tmp to role on table users455server # [ 6437.389480] server mobilizon_ctl[536]: 15:01:34.940 [info] == Migrated 20190307125009 in 0.0s456server # [ 6437.397337] server mobilizon_ctl[536]: 15:01:34.948 [info] == Running 20190307133518 Mobilizon.Repo.Migrations.FeedTokenTable.change/0 forward457server # [ 6437.402133] server mobilizon_ctl[536]: 15:01:34.953 [info] create table feed_tokens458server # [ 6437.406133] server mobilizon_ctl[536]: 15:01:34.957 [info] == Migrated 20190307133518 in 0.0s459server # [ 6437.415884] server mobilizon_ctl[536]: 15:01:34.967 [info] == Running 20190322143724 Mobilizon.Repo.Migrations.RenameAddressFields.change/0 forward460server # [ 6437.416213] server mobilizon_ctl[536]: 15:01:34.967 [info] rename column addressCountry to country on table addresses461server # [ 6437.417037] server mobilizon_ctl[536]: 15:01:34.968 [info] rename column addressLocality to locality on table addresses462server # [ 6437.418064] server mobilizon_ctl[536]: 15:01:34.969 [info] rename column addressRegion to region on table addresses463server # [ 6437.418466] server mobilizon_ctl[536]: 15:01:34.969 [info] rename column postalCode to postal_code on table addresses464server # [ 6437.419139] server mobilizon_ctl[536]: 15:01:34.970 [info] rename column streetAddress to street on table addresses465server # [ 6437.419530] server mobilizon_ctl[536]: 15:01:34.970 [info] == Migrated 20190322143724 in 0.0s466server # [ 6437.422068] server mobilizon_ctl[536]: 15:01:34.973 [info] == Running 20190411124138 Mobilizon.Repo.Migrations.EventAddDescriptionSlug.change/0 forward467server # [ 6437.422167] server mobilizon_ctl[536]: 15:01:34.973 [info] alter table events468server # [ 6437.422947] server mobilizon_ctl[536]: 15:01:34.974 [info] == Migrated 20190411124138 in 0.0s469server # [ 6437.428649] server mobilizon_ctl[536]: 15:01:34.979 [info] == Running 20190411161557 Mobilizon.Repo.Migrations.EventEventTagOnDelete.up/0 forward470server # [ 6437.428843] server mobilizon_ctl[536]: 15:01:34.979 [info] drop constraint events_tags_event_id_fkey from table events_tags471server # [ 6437.429854] server mobilizon_ctl[536]: 15:01:34.981 [info] drop constraint events_tags_tag_id_fkey from table events_tags472server # [ 6437.430709] server mobilizon_ctl[536]: 15:01:34.982 [info] alter table events_tags473server # [ 6437.432881] server mobilizon_ctl[536]: 15:01:34.984 [info] == Migrated 20190411161557 in 0.0s474server # [ 6437.438694] server mobilizon_ctl[536]: 15:01:34.989 [info] == Running 20190425075451 Mobilizon.Repo.Migrations.AddVisibilityToActor.up/0 forward475server # [ 6437.438919] server mobilizon_ctl[536]: 15:01:34.990 [info] execute "CREATE TYPE public.actor_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')"476server # [ 6437.439890] server mobilizon_ctl[536]: 15:01:34.991 [info] alter table actors477server # [ 6437.441506] server mobilizon_ctl[536]: 15:01:34.992 [info] == Migrated 20190425075451 in 0.0s478server # [ 6437.450540] server mobilizon_ctl[536]: 15:01:35.001 [info] == Running 20190426093202 Mobilizon.Repo.Migrations.CreatePictures.up/0 forward479server # [ 6437.451030] server mobilizon_ctl[536]: 15:01:35.002 [info] create table pictures480server # [ 6437.455191] server mobilizon_ctl[536]: 15:01:35.006 [info] alter table actors481server # [ 6437.456195] server mobilizon_ctl[536]: 15:01:35.007 [info] alter table events482server # [ 6437.457959] server mobilizon_ctl[536]: 15:01:35.008 [info] == Migrated 20190426093202 in 0.0s483server # [ 6437.467003] server mobilizon_ctl[536]: 15:01:35.018 [info] == Running 20190531131458 :"Elixir.Mobilizon.Repo.Migrations.Attach-pictures-to-actors".change/0 forward484server # [ 6437.467210] server mobilizon_ctl[536]: 15:01:35.018 [info] alter table pictures485server # [ 6437.469334] server mobilizon_ctl[536]: 15:01:35.020 [info] == Migrated 20190531131458 in 0.0s486server # [ 6437.480143] server mobilizon_ctl[536]: 15:01:35.031 [info] == Running 20190712125833 Mobilizon.Repo.Migrations.CreateReports.up/0 forward487server # [ 6437.483065] server mobilizon_ctl[536]: 15:01:35.034 [info] execute "CREATE TYPE public.report_status AS ENUM ('open', 'closed', 'resolved')"488server # [ 6437.483965] server mobilizon_ctl[536]: 15:01:35.035 [info] create table reports489server # [ 6437.489696] server mobilizon_ctl[536]: 15:01:35.040 [info] create table reports_comments490server # [ 6437.492822] server mobilizon_ctl[536]: 15:01:35.043 [info] == Migrated 20190712125833 in 0.0s491server # [ 6437.502603] server mobilizon_ctl[536]: 15:01:35.053 [info] == Running 20190712132438 Mobilizon.Repo.Migrations.CreateReportNotes.change/0 forward492server # [ 6437.502878] server mobilizon_ctl[536]: 15:01:35.054 [info] create table report_notes493server # [ 6437.506647] server mobilizon_ctl[536]: 15:01:35.057 [info] == Migrated 20190712132438 in 0.0s494server # [ 6437.514544] server mobilizon_ctl[536]: 15:01:35.065 [info] == Running 20190718122556 Mobilizon.Repo.Migrations.CreateAdminActionLogs.change/0 forward495server # [ 6437.514926] server mobilizon_ctl[536]: 15:01:35.066 [info] create table admin_action_logs496server # [ 6437.519232] server mobilizon_ctl[536]: 15:01:35.070 [info] == Migrated 20190718122556 in 0.0s497server # [ 6437.527313] server mobilizon_ctl[536]: 15:01:35.078 [info] == Running 20190729125532 :"Elixir.Mobilizon.Repo.Migrations.Add-url-to-addresses".change/0 forward498server # [ 6437.527556] server mobilizon_ctl[536]: 15:01:35.078 [info] alter table addresses499server # [ 6437.528455] server mobilizon_ctl[536]: 15:01:35.079 [info] == Migrated 20190729125532 in 0.0s500server # [ 6437.533864] server mobilizon_ctl[536]: 15:01:35.085 [info] == Running 20190806131306 Mobilizon.Repo.Migrations.AddUrlToFollowsAndMoveToUuid.up/0 forward501server # [ 6437.534062] server mobilizon_ctl[536]: 15:01:35.085 [info] alter table followers502server # [ 6437.536047] server mobilizon_ctl[536]: 15:01:35.087 [info] == Migrated 20190806131306 in 0.0s503server # [ 6437.543045] server mobilizon_ctl[536]: 15:01:35.094 [info] == Running 20190813160207 Mobilizon.Repo.Migrations.AddUrlAndUuidToParticipants.up/0 forward504server # [ 6437.543799] server mobilizon_ctl[536]: 15:01:35.095 [info] drop index participants_event_id_index505server # [ 6437.544760] server mobilizon_ctl[536]: 15:01:35.095 [info] drop index if exists participants_account_id_index506server # [ 6437.545315] server mobilizon_ctl[536]: 15:01:35.096 [info] drop index if exists participants_actor_id_index507server # [ 6437.545687] server mobilizon_ctl[536]: 15:01:35.096 [info] index "participants_actor_id_index" does not exist, skipping508server # [ 6437.545687] server mobilizon_ctl[536]: 15:01:35.096 [info] drop constraint participants_event_id_fkey from table participants509server # [ 6437.546742] server mobilizon_ctl[536]: 15:01:35.098 [info] drop constraint if exists participants_account_id_fkey from table participants510server # [ 6437.547413] server mobilizon_ctl[536]: 15:01:35.098 [info] drop constraint if exists participants_actor_id_fkey from table participants511server # [ 6437.547741] server mobilizon_ctl[536]: 15:01:35.099 [info] constraint "participants_actor_id_fkey" of relation "participants" does not exist, skipping512server # [ 6437.547741] server mobilizon_ctl[536]: 15:01:35.099 [info] drop constraint participants_pkey from table participants513server # [ 6437.548215] server mobilizon_ctl[536]: 15:01:35.099 [info] alter table participants514server # [ 6437.551719] server mobilizon_ctl[536]: 15:01:35.102 [info] create index participants_event_id_index515server # [ 6437.553052] server mobilizon_ctl[536]: 15:01:35.104 [info] create index participants_actor_id_index516server # [ 6437.554332] server mobilizon_ctl[536]: 15:01:35.105 [info] == Migrated 20190813160207 in 0.0s517server # [ 6437.565067] server mobilizon_ctl[536]: 15:01:35.116 [info] == Running 20190821161658 Mobilizon.Repo.Migrations.AddOriginIdToAddresses.change/0 forward518server # [ 6437.565378] server mobilizon_ctl[536]: 15:01:35.116 [info] alter table addresses519server # [ 6437.566292] server mobilizon_ctl[536]: 15:01:35.117 [info] create index addresses_origin_id_index520server # [ 6437.567542] server mobilizon_ctl[536]: 15:01:35.118 [info] == Migrated 20190821161658 in 0.0s521server # [ 6437.570678] server mobilizon_ctl[536]: 15:01:35.122 [info] == Running 20190823132816 Mobilizon.Repo.Migrations.RemoveEventsWhenDeletingOrganizer.up/0 forward522server # [ 6437.570850] server mobilizon_ctl[536]: 15:01:35.122 [info] drop constraint events_organizer_account_id_fkey from table events523server # [ 6437.572062] server mobilizon_ctl[536]: 15:01:35.123 [info] alter table events524server # [ 6437.574640] server mobilizon_ctl[536]: 15:01:35.125 [info] == Migrated 20190823132816 in 0.0s525server # [ 6437.580412] server mobilizon_ctl[536]: 15:01:35.131 [info] == Running 20190902082656 Mobilizon.Repo.Migrations.AddOptionsToEvent.change/0 forward526server # [ 6437.580761] server mobilizon_ctl[536]: 15:01:35.131 [info] alter table events527server # [ 6437.581889] server mobilizon_ctl[536]: 15:01:35.133 [info] == Migrated 20190902082656 in 0.0s528server # [ 6437.587638] server mobilizon_ctl[536]: 15:01:35.138 [info] == Running 20190929170817 Mobilizon.Storage.Repo.Migrations.RenamePostgresTypes.up/0 forward529server # [ 6437.592911] server mobilizon_ctl[536]: 15:01:35.144 [info] == Migrated 20190929170817 in 0.0s530server # [ 6437.595494] server mobilizon_ctl[536]: 15:01:35.146 [info] == Running 20190929175229 Mobilizon.Storage.Repo.Migrations.AddRejectedToParticipantRole.up/0 forward531server # [ 6437.595608] server mobilizon_ctl[536]: 15:01:35.146 [info] execute "ALTER TYPE public.participant_role ADD VALUE IF NOT EXISTS 'rejected'"532server # [ 6437.596447] server mobilizon_ctl[536]: 15:01:35.147 [info] enum label "rejected" already exists, skipping533server # [ 6437.596447] server mobilizon_ctl[536]: 15:01:35.147 [info] == Migrated 20190929175229 in 0.0s534server # [ 6437.605915] server mobilizon_ctl[536]: 15:01:35.157 [info] == Running 20191001074442 Mobilizon.Storage.Repo.Migrations.AddLocaleToUsers.change/0 forward535server # [ 6437.606238] server mobilizon_ctl[536]: 15:01:35.157 [info] alter table users536server # [ 6437.607431] server mobilizon_ctl[536]: 15:01:35.158 [info] == Migrated 20191001074442 in 0.0s537server # [ 6437.613036] server mobilizon_ctl[536]: 15:01:35.164 [info] == Running 20191002093208 Mobilizon.Storage.Repo.Migrations.AddDraftFlagToEvents.change/0 forward538server # [ 6437.613191] server mobilizon_ctl[536]: 15:01:35.164 [info] alter table events539server # [ 6437.614395] server mobilizon_ctl[536]: 15:01:35.165 [info] == Migrated 20191002093208 in 0.0s540server # [ 6437.620932] server mobilizon_ctl[536]: 15:01:35.172 [info] == Running 20191018075904 Mobilizon.Storage.Repo.Migrations.MoveSQLColumnsFromVarCharToText.up/0 forward541server # [ 6437.621507] server mobilizon_ctl[536]: 15:01:35.172 [info] alter table events542server # [ 6437.625179] server mobilizon_ctl[536]: 15:01:35.176 [info] alter table addresses543server # [ 6437.625859] server mobilizon_ctl[536]: 15:01:35.177 [info] alter table bots544server # [ 6437.626528] server mobilizon_ctl[536]: 15:01:35.177 [info] alter table report_notes545server # [ 6437.627565] server mobilizon_ctl[536]: 15:01:35.178 [info] alter table reports546server # [ 6437.628023] server mobilizon_ctl[536]: 15:01:35.179 [info] alter table sessions547server # [ 6437.628782] server mobilizon_ctl[536]: 15:01:35.180 [info] alter table tracks548server # [ 6437.629686] server mobilizon_ctl[536]: 15:01:35.180 [info] == Migrated 20191018075904 in 0.0s549server # [ 6437.632993] server mobilizon_ctl[536]: 15:01:35.184 [info] == Running 20191022083446 Mobilizon.Storage.Repo.Migrations.AddEagerMaterializedViewForSearchingEvents.up/0 forward550server # [ 6437.633289] server mobilizon_ctl[536]: 15:01:35.184 [info] create table event_search551server # [ 6437.637000] server mobilizon_ctl[536]: 15:01:35.188 [info] create index event_search_document_index552server # [ 6437.637925] server mobilizon_ctl[536]: 15:01:35.189 [info] execute "CREATE INDEX event_search_title_trgm_index ON event_search USING gin (title gin_trgm_ops)"553server # [ 6437.638827] server mobilizon_ctl[536]: 15:01:35.190 [info] create index event_search_id_index554server # [ 6437.639958] server mobilizon_ctl[536]: 15:01:35.191 [info] == Migrated 20191022083446 in 0.0s555server # [ 6437.652588] server mobilizon_ctl[536]: 15:01:35.203 [info] == Running 20191023133805 Mobilizon.Storage.Repo.Migrations.DeleteActorsCascadeToFollowers.up/0 forward556server # [ 6437.652728] server mobilizon_ctl[536]: 15:01:35.203 [info] drop constraint followers_actor_id_fkey from table followers557server # [ 6437.653786] server mobilizon_ctl[536]: 15:01:35.205 [info] drop constraint followers_target_actor_id_fkey from table followers558server # [ 6437.654681] server mobilizon_ctl[536]: 15:01:35.205 [info] alter table followers559server # [ 6437.657069] server mobilizon_ctl[536]: 15:01:35.208 [info] == Migrated 20191023133805 in 0.0s560server # [ 6437.663972] server mobilizon_ctl[536]: 15:01:35.215 [info] == Running 20191023143659 Mobilizon.Storage.Repo.Migrations.MoveParticipantsStatsToEvent.up/0 forward561server # [ 6437.664160] server mobilizon_ctl[536]: 15:01:35.215 [info] alter table events562server # [ 6437.665107] server mobilizon_ctl[536]: 15:01:35.216 [info] == Migrated 20191023143659 in 0.0s563server # [ 6437.668336] server mobilizon_ctl[536]: 15:01:35.219 [info] == Running 20191024204726 Mobilizon.Storage.Repo.Migrations.AddTagsToComments.up/0 forward564server # [ 6437.668594] server mobilizon_ctl[536]: 15:01:35.219 [info] create table comments_tags565server # [ 6437.671732] server mobilizon_ctl[536]: 15:01:35.222 [info] == Migrated 20191024204726 in 0.0s566server # [ 6437.683359] server mobilizon_ctl[536]: 15:01:35.234 [info] == Running 20191025083642 Mobilizon.Storage.Repo.Migrations.AddMentionTables.change/0 forward567server # [ 6437.683804] server mobilizon_ctl[536]: 15:01:35.235 [info] create table mentions568server # [ 6437.688260] server mobilizon_ctl[536]: 15:01:35.239 [info] create index mentions_actor_id_index569server # [ 6437.689325] server mobilizon_ctl[536]: 15:01:35.240 [info] == Migrated 20191025083642 in 0.0s570server # [ 6437.697594] server mobilizon_ctl[536]: 15:01:35.248 [info] == Running 20191025115537 Mobilizon.Storage.Repo.Migrations.AddUniqueIndexOnURLs.change/0 forward571server # [ 6437.697932] server mobilizon_ctl[536]: 15:01:35.249 [info] create index events_url_index572server # [ 6437.699548] server mobilizon_ctl[536]: 15:01:35.250 [info] create index comments_url_index573server # [ 6437.700829] server mobilizon_ctl[536]: 15:01:35.252 [info] == Migrated 20191025115537 in 0.0s574server # [ 6437.706345] server mobilizon_ctl[536]: 15:01:35.257 [info] == Running 20191031142145 Mobilizon.Storage.Repo.Migrations.AddUniqueIndexOnActorAndEventForParticipant.change/0 forward575server # [ 6437.706680] server mobilizon_ctl[536]: 15:01:35.257 [info] create index participants_event_id_actor_id_index576server # [ 6437.708210] server mobilizon_ctl[536]: 15:01:35.259 [info] == Migrated 20191031142145 in 0.0s577server # [ 6437.711421] server mobilizon_ctl[536]: 15:01:35.262 [info] == Running 20191104093447 Mobilizon.Storage.Repo.Migrations.AddObanJobsTable.up/0 forward578server # [ 6437.743815] server mobilizon_ctl[536]: 15:01:35.295 [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"579server # [ 6437.745988] server mobilizon_ctl[536]: 15:01:35.297 [info] create table if not exists public.oban_jobs580server # [ 6437.749133] server mobilizon_ctl[536]: 15:01:35.300 [info] create index if not exists public.oban_jobs_queue_index581server # [ 6437.750163] server mobilizon_ctl[536]: 15:01:35.301 [info] create index if not exists public.oban_jobs_state_index582server # [ 6437.751031] server mobilizon_ctl[536]: 15:01:35.302 [info] create index if not exists public.oban_jobs_scheduled_at_index583server # [ 6437.752334] server mobilizon_ctl[536]: 15:01:35.303 [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"584server # [ 6437.752978] server mobilizon_ctl[536]: 15:01:35.304 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs"585server # [ 6437.753396] server mobilizon_ctl[536]: 15:01:35.304 [info] trigger "oban_notify" for relation "public.oban_jobs" does not exist, skipping586server # [ 6437.753479] server mobilizon_ctl[536]: 15:01:35.304 [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"587server # [ 6437.753962] server mobilizon_ctl[536]: 15:01:35.305 [info] drop index if exists public.oban_jobs_scheduled_at_index588server # [ 6437.754346] server mobilizon_ctl[536]: 15:01:35.305 [info] create index public.oban_jobs_scheduled_at_index589server # [ 6437.755489] server mobilizon_ctl[536]: 15:01:35.306 [info] create check constraint worker_length on table public.oban_jobs590server # [ 6437.756204] server mobilizon_ctl[536]: 15:01:35.307 [info] create check constraint queue_length on table public.oban_jobs591server # [ 6437.756872] server mobilizon_ctl[536]: 15:01:35.308 [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"592server # [ 6437.757420] server mobilizon_ctl[536]: 15:01:35.308 [info] alter table public.oban_jobs593server # [ 6437.757756] server mobilizon_ctl[536]: 15:01:35.309 [info] execute "DROP FUNCTION IF EXISTS \"public\".oban_wrap_id(value bigint)"594server # [ 6437.758057] server mobilizon_ctl[536]: 15:01:35.309 [info] drop index if exists public.oban_jobs_scheduled_at_index595server # [ 6437.758313] server mobilizon_ctl[536]: 15:01:35.309 [info] drop index if exists public.oban_jobs_queue_index596server # [ 6437.758740] server mobilizon_ctl[536]: 15:01:35.309 [info] drop index if exists public.oban_jobs_state_index597server # [ 6437.758782] server mobilizon_ctl[536]: 15:01:35.310 [info] create index if not exists public.oban_jobs_queue_state_scheduled_at_id_index598server # [ 6437.759600] server mobilizon_ctl[536]: 15:01:35.310 [info] create index if not exists public.oban_jobs_attempted_at_id_index599server # [ 6437.760768] server mobilizon_ctl[536]: 15:01:35.312 [info] alter table public.oban_jobs600server # [ 6437.761195] server mobilizon_ctl[536]: 15:01:35.312 [info] alter table public.oban_jobs601server # [ 6437.761800] server mobilizon_ctl[536]: 15:01:35.313 [info] drop index if exists public.oban_jobs_queue_state_scheduled_at_id_index602server # [ 6437.762380] server mobilizon_ctl[536]: 15:01:35.313 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index603server # [ 6437.763417] server mobilizon_ctl[536]: 15:01:35.314 [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"604server # [ 6437.763943] server mobilizon_ctl[536]: 15:01:35.315 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs"605server # [ 6437.764148] server mobilizon_ctl[536]: 15:01:35.315 [info] execute "CREATE TRIGGER oban_notify\nAFTER INSERT ON \"public\".oban_jobs\nFOR EACH ROW EXECUTE PROCEDURE \"public\".oban_jobs_notify();\n"606server # [ 6437.764497] server mobilizon_ctl[536]: 15:01:35.315 [info] alter table public.oban_jobs607server # [ 6437.771542] server mobilizon_ctl[536]: 15:01:35.322 [info] execute "ALTER TYPE \"public\".oban_job_state ADD VALUE IF NOT EXISTS 'cancelled'"608server # [ 6437.772060] server mobilizon_ctl[536]: 15:01:35.323 [info] enum label "cancelled" already exists, skipping609server # [ 6437.772188] server mobilizon_ctl[536]: 15:01:35.323 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index610server # [ 6437.772761] server mobilizon_ctl[536]: 15:01:35.324 [info] relation "oban_jobs_state_queue_priority_scheduled_at_id_index" already exists, skipping611server # [ 6437.772847] server mobilizon_ctl[536]: 15:01:35.324 [info] alter table public.oban_jobs612server # [ 6437.775010] server mobilizon_ctl[536]: 15:01:35.326 [info] create check constraint priority_range on table public.oban_jobs613server # [ 6437.775812] server mobilizon_ctl[536]: 15:01:35.327 [info] create check constraint positive_max_attempts on table public.oban_jobs614server # [ 6437.776358] server mobilizon_ctl[536]: 15:01:35.327 [info] create check constraint attempt_range on table public.oban_jobs615server # [ 6437.777079] server mobilizon_ctl[536]: 15:01:35.328 [info] drop index if exists public.oban_jobs_args_vector616server # [ 6437.777440] server mobilizon_ctl[536]: 15:01:35.328 [info] index "oban_jobs_args_vector" does not exist, skipping617server # [ 6437.777440] server mobilizon_ctl[536]: 15:01:35.328 [info] drop index if exists public.oban_jobs_worker_gist618server # [ 6437.778017] server mobilizon_ctl[536]: 15:01:35.329 [info] index "oban_jobs_worker_gist" does not exist, skipping619server # [ 6437.778161] server mobilizon_ctl[536]: 15:01:35.329 [info] drop index if exists public.oban_jobs_attempted_at_id_index620server # [ 6437.778971] server mobilizon_ctl[536]: 15:01:35.330 [info] create index if not exists public.oban_jobs_args_index621server # [ 6437.780545] server mobilizon_ctl[536]: 15:01:35.331 [info] create index if not exists public.oban_jobs_meta_index622server # [ 6437.781999] server mobilizon_ctl[536]: 15:01:35.333 [info] create table if not exists public.oban_peers623server # [ 6437.786244] server mobilizon_ctl[536]: 15:01:35.337 [info] execute "ALTER TABLE \"public\".oban_peers SET UNLOGGED"624server # [ 6437.788502] server mobilizon_ctl[536]: 15:01:35.339 [info] drop constraint priority_range from table public.oban_jobs625server # [ 6437.789037] server mobilizon_ctl[536]: 15:01:35.340 [info] create check constraint non_negative_priority on table public.oban_jobs626server # [ 6437.789964] server mobilizon_ctl[536]: 15:01:35.341 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs"627server # [ 6437.790514] server mobilizon_ctl[536]: 15:01:35.341 [info] execute "DROP FUNCTION IF EXISTS \"public\".oban_jobs_notify()"628server # [ 6437.790906] server mobilizon_ctl[536]: 15:01:35.342 [info] create index if not exists public.oban_jobs_state_cancelled_at_index629server # [ 6437.792406] server mobilizon_ctl[536]: 15:01:35.343 [info] create index if not exists public.oban_jobs_state_discarded_at_index630server # [ 6437.793832] server mobilizon_ctl[536]: 15:01:35.345 [info] execute "ALTER TYPE \"public\".oban_job_state ADD VALUE IF NOT EXISTS 'suspended' BEFORE 'scheduled'\n"631server # [ 6437.794101] server mobilizon_ctl[536]: 15:01:35.345 [info] enum label "suspended" already exists, skipping632server # [ 6437.794235] server mobilizon_ctl[536]: 15:01:35.345 [info] execute "COMMENT ON TABLE \"public\".oban_jobs IS '14'"633server # [ 6437.794628] server mobilizon_ctl[536]: 15:01:35.345 [info] == Migrated 20191104093447 in 0.0s634server # [ 6437.803825] server mobilizon_ctl[536]: 15:01:35.355 [info] == Running 20191106114524 Mobilizon.Storage.Repo.Migrations.RemoveFloorFromAddresses.up/0 forward635server # [ 6437.803971] server mobilizon_ctl[536]: 15:01:35.355 [info] alter table addresses636server # [ 6437.805106] server mobilizon_ctl[536]: 15:01:35.356 [info] == Migrated 20191106114524 in 0.0s637server # [ 6437.810800] server mobilizon_ctl[536]: 15:01:35.362 [info] == Running 20191106141051 Mobilizon.Storage.Repo.Migrations.AddTypeToAddresses.change/0 forward638server # [ 6437.810993] server mobilizon_ctl[536]: 15:01:35.362 [info] alter table addresses639server # [ 6437.811820] server mobilizon_ctl[536]: 15:01:35.363 [info] == Migrated 20191106141051 in 0.0s640server # [ 6437.815161] server mobilizon_ctl[536]: 15:01:35.366 [info] == Running 20191114155534 Mobilizon.Storage.Repo.Migrations.CascadeCommentDeletion.up/0 forward641server # [ 6437.815475] server mobilizon_ctl[536]: 15:01:35.366 [info] drop constraint comments_in_reply_to_comment_id_fkey from table comments642server # [ 6437.816595] server mobilizon_ctl[536]: 15:01:35.367 [info] drop constraint comments_origin_comment_id_fkey from table comments643server # [ 6437.817364] server mobilizon_ctl[536]: 15:01:35.368 [info] alter table comments644server # [ 6437.819627] server mobilizon_ctl[536]: 15:01:35.370 [info] == Migrated 20191114155534 in 0.0s645server # [ 6437.826074] server mobilizon_ctl[536]: 15:01:35.377 [info] == Running 20191122154018 Mobilizon.Storage.Repo.Migrations.AddDeletedAtOnComments.up/0 forward646server # [ 6437.826251] server mobilizon_ctl[536]: 15:01:35.377 [info] drop constraint if exists comments_actor_id_fkey from table comments647server # [ 6437.826975] server mobilizon_ctl[536]: 15:01:35.378 [info] constraint "comments_actor_id_fkey" of relation "comments" does not exist, skipping648server # [ 6437.826975] server mobilizon_ctl[536]: 15:01:35.378 [info] alter table comments649server # [ 6437.830188] server mobilizon_ctl[536]: 15:01:35.381 [info] == Migrated 20191122154018 in 0.0s650server # [ 6437.836365] server mobilizon_ctl[536]: 15:01:35.387 [info] == Running 20191126173510 Mobilizon.Storage.Repo.Migrations.AddLocalFieldToReports.up/0 forward651server # [ 6437.836545] server mobilizon_ctl[536]: 15:01:35.387 [info] alter table reports652server # [ 6437.837513] server mobilizon_ctl[536]: 15:01:35.388 [info] rename column uri to url on table reports653server # [ 6437.838051] server mobilizon_ctl[536]: 15:01:35.389 [info] == Migrated 20191126173510 in 0.0s654server # [ 6437.843568] server mobilizon_ctl[536]: 15:01:35.394 [info] == Running 20191127163737 Mobilizon.Repo.Migrations.CreateTombstones.change/0 forward655server # [ 6437.843986] server mobilizon_ctl[536]: 15:01:35.395 [info] create table tombstones656server # [ 6437.847912] server mobilizon_ctl[536]: 15:01:35.399 [info] create index tombstones_uri_index657server # [ 6437.849117] server mobilizon_ctl[536]: 15:01:35.400 [info] == Migrated 20191127163737 in 0.0s658server # [ 6437.857051] server mobilizon_ctl[536]: 15:01:35.408 [info] == Running 20191129091227 Mobilizon.Storage.Repo.Migrations.AddTimestampsToFollowers.change/0 forward659server # [ 6437.857314] server mobilizon_ctl[536]: 15:01:35.408 [info] alter table followers660server # [ 6437.858464] server mobilizon_ctl[536]: 15:01:35.409 [info] == Migrated 20191129091227 in 0.0s661server # [ 6437.864894] server mobilizon_ctl[536]: 15:01:35.416 [info] == Running 20191204164224 Mobilizon.Storage.Repo.Migrations.DeleteEventCascadeToComments.up/0 forward662server # [ 6437.865134] server mobilizon_ctl[536]: 15:01:35.416 [info] drop constraint if exists comments_event_id_fkey from table comments663server # [ 6437.866445] server mobilizon_ctl[536]: 15:01:35.417 [info] alter table comments664server # [ 6437.868224] server mobilizon_ctl[536]: 15:01:35.419 [info] == Migrated 20191204164224 in 0.0s665server # [ 6437.871227] server mobilizon_ctl[536]: 15:01:35.422 [info] == Running 20191206144028 Mobilizon.Repo.Migrations.CreateShares.up/0 forward666server # [ 6437.871546] server mobilizon_ctl[536]: 15:01:35.422 [info] create table shares667server # [ 6437.875121] server mobilizon_ctl[536]: 15:01:35.426 [info] create index if not exists shares_uri_actor_id_index668server # [ 6437.876401] server mobilizon_ctl[536]: 15:01:35.427 [info] == Migrated 20191206144028 in 0.0s669server # [ 6437.883996] server mobilizon_ctl[536]: 15:01:35.435 [info] == Running 20191219172017 Mobilizon.Storage.Repo.Migrations.AddMetadataToParticipant.up/0 forward670server # [ 6437.884229] server mobilizon_ctl[536]: 15:01:35.435 [info] drop index if exists participants_event_id_actor_id_index671server # [ 6437.884986] server mobilizon_ctl[536]: 15:01:35.436 [info] alter table participants672server # [ 6437.886911] server mobilizon_ctl[536]: 15:01:35.438 [info] execute "CREATE UNIQUE INDEX participants_metadata_confirmation_token_index ON participants((metadata->>'confirmation_token'))"673server # [ 6437.887984] server mobilizon_ctl[536]: 15:01:35.439 [info] == Migrated 20191219172017 in 0.0s674server # [ 6437.893199] server mobilizon_ctl[536]: 15:01:35.444 [info] == Running 20191223173537 Mobilizon.Storage.Repo.Migrations.AddNotConfirmedStatusToParticipants.up/0 forward675server # [ 6437.893433] server mobilizon_ctl[536]: 15:01:35.444 [info] execute "ALTER TYPE participant_role ADD VALUE IF NOT EXISTS 'not_confirmed'"676server # [ 6437.894006] server mobilizon_ctl[536]: 15:01:35.445 [info] enum label "not_confirmed" already exists, skipping677server # [ 6437.894390] server mobilizon_ctl[536]: 15:01:35.445 [info] == Migrated 20191223173537 in 0.0s678server # [ 6437.899907] server mobilizon_ctl[536]: 15:01:35.451 [info] == Running 20200116095117 Mobilizon.Repo.Migrations.CreateAdminSettings.change/0 forward679server # [ 6437.900385] server mobilizon_ctl[536]: 15:01:35.451 [info] create table admin_settings680server # [ 6437.904284] server mobilizon_ctl[536]: 15:01:35.455 [info] create index admin_settings_group_name_index681server # [ 6437.905551] server mobilizon_ctl[536]: 15:01:35.456 [info] == Migrated 20200116095117 in 0.0s682server # [ 6437.915295] server mobilizon_ctl[536]: 15:01:35.466 [info] == Running 20200210100910 Mobilizon.Storage.Repo.Migrations.AddUnconfirmedEmailToUsersTable.change/0 forward683server # [ 6437.915534] server mobilizon_ctl[536]: 15:01:35.466 [info] alter table users684server # [ 6437.916393] server mobilizon_ctl[536]: 15:01:35.467 [info] == Migrated 20200210100910 in 0.0s685server # [ 6437.922969] server mobilizon_ctl[536]: 15:01:35.474 [info] == Running 20200213154309 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV8.up/0 forward686server # [ 6437.924977] server mobilizon_ctl[536]: 15:01:35.476 [info] == Migrated 20200213154309 in 0.0s687server # [ 6437.931670] server mobilizon_ctl[536]: 15:01:35.482 [info] == Running 20200214135231 Mobilizon.Storage.Repo.Migrations.AddLastRefreshedAtToActors.change/0 forward688server # [ 6437.931923] server mobilizon_ctl[536]: 15:01:35.483 [info] alter table actors689server # [ 6437.932908] server mobilizon_ctl[536]: 15:01:35.484 [info] == Migrated 20200214135231 in 0.0s690server # [ 6437.938463] server mobilizon_ctl[536]: 15:01:35.489 [info] == Running 20200218085757 Mobilizon.Storage.Repo.Migrations.AddNewRolesToMember.up/0 forward691server # [ 6437.938783] server mobilizon_ctl[536]: 15:01:35.490 [info] execute "ALTER TYPE member_role ADD VALUE IF NOT EXISTS 'invited'"692server # [ 6437.939489] server mobilizon_ctl[536]: 15:01:35.490 [info] enum label "invited" already exists, skipping693server # [ 6437.939489] server mobilizon_ctl[536]: 15:01:35.490 [info] execute "ALTER TYPE member_role ADD VALUE IF NOT EXISTS 'rejected'"694server # [ 6437.939998] server mobilizon_ctl[536]: 15:01:35.491 [info] enum label "rejected" already exists, skipping695server # [ 6437.940121] server mobilizon_ctl[536]: 15:01:35.491 [info] == Migrated 20200218085757 in 0.0s696server # [ 6437.942568] server mobilizon_ctl[536]: 15:01:35.493 [info] == Running 20200218170232 Mobilizon.Storage.Repo.Migrations.MoveMemberIdToUuid.up/0 forward697server # [ 6437.942681] server mobilizon_ctl[536]: 15:01:35.494 [info] alter table members698server # [ 6437.947189] server mobilizon_ctl[536]: 15:01:35.498 [info] == Migrated 20200218170232 in 0.0s699server # [ 6437.958145] server mobilizon_ctl[536]: 15:01:35.509 [info] == Running 20200219152611 Mobilizon.Storage.Repo.Migrations.AddMembersEndpointToActors.up/0 forward700server # [ 6437.958145] server mobilizon_ctl[536]: 15:01:35.509 [info] alter table actors701server # [ 6437.959196] server mobilizon_ctl[536]: 15:01:35.510 [info] == Migrated 20200219152611 in 0.0s702server # [ 6437.965323] server mobilizon_ctl[536]: 15:01:35.516 [info] == Running 20200221095721 Mobilizon.Repo.Migrations.CreateTodos.change/0 forward703server # [ 6437.966008] server mobilizon_ctl[536]: 15:01:35.517 [info] create table todo_lists704server # [ 6437.969302] server mobilizon_ctl[536]: 15:01:35.520 [info] create table todos705server # [ 6437.972233] server mobilizon_ctl[536]: 15:01:35.523 [info] == Migrated 20200221095721 in 0.0s706server # [ 6437.984046] server mobilizon_ctl[536]: 15:01:35.535 [info] == Running 20200221160744 Mobilizon.Repo.Migrations.CreateResources.change/0 forward707server # [ 6437.984643] server mobilizon_ctl[536]: 15:01:35.535 [info] create table resource708server # [ 6437.990578] server mobilizon_ctl[536]: 15:01:35.541 [info] == Migrated 20200221160744 in 0.0s709server # [ 6437.998115] server mobilizon_ctl[536]: 15:01:35.549 [info] == Running 20200406115807 Mobilizon.Storage.Repo.Migrations.AddConversations.change/0 forward710server # [ 6437.998423] server mobilizon_ctl[536]: 15:01:35.549 [info] create table conversations711server # [ 6438.005912] server mobilizon_ctl[536]: 15:01:35.557 [info] alter table comments712server # [ 6438.008350] server mobilizon_ctl[536]: 15:01:35.559 [info] == Migrated 20200406115807 in 0.0s713server # [ 6438.016656] server mobilizon_ctl[536]: 15:01:35.567 [info] == Running 20200410100554 Mobilizon.Storage.Repo.Migrations.AddNumberEditsToComment.change/0 forward714server # [ 6438.016824] server mobilizon_ctl[536]: 15:01:35.568 [info] alter table comments715server # [ 6438.018094] server mobilizon_ctl[536]: 15:01:35.569 [info] == Migrated 20200410100554 in 0.0s716server # [ 6438.023670] server mobilizon_ctl[536]: 15:01:35.574 [info] == Running 20200513142813 Mobilizon.Storage.Repo.Migrations.AddResourcesAndTodosEndpointsToActor.change/0 forward717server # [ 6438.023849] server mobilizon_ctl[536]: 15:01:35.575 [info] alter table actors718server # [ 6438.025039] server mobilizon_ctl[536]: 15:01:35.576 [info] == Migrated 20200513142813 in 0.0s719server # [ 6438.028103] server mobilizon_ctl[536]: 15:01:35.579 [info] == Running 20200514101612 Mobilizon.Storage.Repo.Migrations.AddLocalAttributeToResourcesAndTodos.change/0 forward720server # [ 6438.028338] server mobilizon_ctl[536]: 15:01:35.579 [info] alter table resource721server # [ 6438.029512] server mobilizon_ctl[536]: 15:01:35.580 [info] alter table todo_lists722server # [ 6438.030077] server mobilizon_ctl[536]: 15:01:35.581 [info] alter table todos723server # [ 6438.031246] server mobilizon_ctl[536]: 15:01:35.582 [info] == Migrated 20200514101612 in 0.0s724server # [ 6438.043478] server mobilizon_ctl[536]: 15:01:35.594 [info] == Running 20200518084949 Mobilizon.Storage.Repo.Migrations.MoveInviterFromMetadataToMemberTable.change/0 forward725server # [ 6438.043818] server mobilizon_ctl[536]: 15:01:35.595 [info] alter table members726server # [ 6438.046754] server mobilizon_ctl[536]: 15:01:35.597 [info] == Migrated 20200518084949 in 0.0s727server # [ 6438.052385] server mobilizon_ctl[536]: 15:01:35.603 [info] == Running 20200519082820 Mobilizon.Storage.Repo.Migrations.AddUniqueURLContraintToSomeTables.change/0 forward728server # [ 6438.052805] server mobilizon_ctl[536]: 15:01:35.604 [info] create index members_url_index729server # [ 6438.054426] server mobilizon_ctl[536]: 15:01:35.605 [info] create index resource_url_index730server # [ 6438.055747] server mobilizon_ctl[536]: 15:01:35.607 [info] create index todo_lists_url_index731server # [ 6438.057080] server mobilizon_ctl[536]: 15:01:35.608 [info] create index todos_url_index732server # [ 6438.058244] server mobilizon_ctl[536]: 15:01:35.609 [info] == Migrated 20200519082820 in 0.0s733server # [ 6438.061811] server mobilizon_ctl[536]: 15:01:35.613 [info] == Running 20200526131523 Mobilizon.Repo.Migrations.CreateUserSettings.change/0 forward734server # [ 6438.062072] server mobilizon_ctl[536]: 15:01:35.613 [info] create table user_settings735server # [ 6438.064759] server mobilizon_ctl[536]: 15:01:35.615 [info] == Migrated 20200526131523 in 0.0s736server # [ 6438.072380] server mobilizon_ctl[536]: 15:01:35.623 [info] == Running 20200605154921 Mobilizon.Storage.Repo.Migrations.AddNotificationPendingParticipationToSettings.change/0 forward737server # [ 6438.072675] server mobilizon_ctl[536]: 15:01:35.623 [info] alter table user_settings738server # [ 6438.073489] server mobilizon_ctl[536]: 15:01:35.624 [info] == Migrated 20200605154921 in 0.0s739server # [ 6438.079302] server mobilizon_ctl[536]: 15:01:35.630 [info] == Running 20200612155254 Mobilizon.Storage.Repo.Migrations.AddDisabledParameterToUsers.change/0 forward740server # [ 6438.080239] server mobilizon_ctl[536]: 15:01:35.630 [info] alter table users741server # [ 6438.081116] server mobilizon_ctl[536]: 15:01:35.632 [info] == Migrated 20200612155254 in 0.0s742server # [ 6438.087683] server mobilizon_ctl[536]: 15:01:35.638 [info] == Running 20200630123819 Mobilizon.Storage.Repo.Migrations.AddProviderToUserAndMakePasswordMandatory.up/0 forward743server # [ 6438.087903] server mobilizon_ctl[536]: 15:01:35.639 [info] alter table users744server # [ 6438.089077] server mobilizon_ctl[536]: 15:01:35.640 [info] == Migrated 20200630123819 in 0.0s745server # [ 6438.092431] server mobilizon_ctl[536]: 15:01:35.643 [info] == Running 20200708080516 Mobilizon.Repo.Migrations.CreatePosts.up/0 forward746server # [ 6438.095407] server mobilizon_ctl[536]: 15:01:35.646 [info] execute "CREATE TYPE public.post_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')"747server # [ 6438.096289] server mobilizon_ctl[536]: 15:01:35.647 [info] create table posts748server # [ 6438.100746] server mobilizon_ctl[536]: 15:01:35.651 [info] create table posts_tags749server # [ 6438.102352] server mobilizon_ctl[536]: 15:01:35.653 [info] alter table actors750server # [ 6438.103804] server mobilizon_ctl[536]: 15:01:35.654 [info] == Migrated 20200708080516 in 0.0s751server # [ 6438.112179] server mobilizon_ctl[536]: 15:01:35.663 [info] == Running 20200717142633 Mobilizon.Storage.Repo.Migrations.RenameConversationsToDiscussions.up/0 forward752server # [ 6438.112452] server mobilizon_ctl[536]: 15:01:35.663 [info] rename table conversations to discussions753server # [ 6438.113303] server mobilizon_ctl[536]: 15:01:35.664 [info] rename column conversation_id to discussion_id on table comments754server # [ 6438.113862] server mobilizon_ctl[536]: 15:01:35.665 [info] alter table actors755server # [ 6438.114807] server mobilizon_ctl[536]: 15:01:35.665 [info] == Migrated 20200717142633 in 0.0s756server # [ 6438.119995] server mobilizon_ctl[536]: 15:01:35.671 [info] == Running 20200721131521 Mobilizon.Storage.Repo.Migrations.AddUrlToConversation.up/0 forward757server # [ 6438.120240] server mobilizon_ctl[536]: 15:01:35.671 [info] drop constraint if exists comments_conversation_id_fkey from table comments758server # [ 6438.121788] server mobilizon_ctl[536]: 15:01:35.672 [info] drop constraint if exists comments_discussion_id_fkey from table comments759server # [ 6438.122505] server mobilizon_ctl[536]: 15:01:35.673 [info] constraint "comments_discussion_id_fkey" of relation "comments" does not exist, skipping760server # [ 6438.122505] server mobilizon_ctl[536]: 15:01:35.673 [info] alter table discussions761server # [ 6438.124217] server mobilizon_ctl[536]: 15:01:35.675 [info] alter table comments762server # [ 6438.126359] server mobilizon_ctl[536]: 15:01:35.677 [info] == Migrated 20200721131521 in 0.0s763server # [ 6438.133790] server mobilizon_ctl[536]: 15:01:35.685 [info] == Running 20200805124620 Mobilizon.Storage.Repo.Migrations.AddAddressToActors.change/0 forward764server # [ 6438.133967] server mobilizon_ctl[536]: 15:01:35.685 [info] alter table actors765server # [ 6438.135712] server mobilizon_ctl[536]: 15:01:35.686 [info] == Migrated 20200805124620 in 0.0s766server # [ 6438.138786] server mobilizon_ctl[536]: 15:01:35.690 [info] == Running 20200817080549 Mobilizon.Storage.Repo.Migrations.AddPublishedAtToEntities.up/0 forward767server # [ 6438.138897] server mobilizon_ctl[536]: 15:01:35.690 [info] alter table comments768server # [ 6438.140640] server mobilizon_ctl[536]: 15:01:35.691 [info] alter table resource769server # [ 6438.141867] server mobilizon_ctl[536]: 15:01:35.693 [info] alter table todo_lists770server # [ 6438.143107] server mobilizon_ctl[536]: 15:01:35.694 [info] alter table todos771server # [ 6438.143964] server mobilizon_ctl[536]: 15:01:35.695 [info] == Migrated 20200817080549 in 0.0s772server # [ 6438.152090] server mobilizon_ctl[536]: 15:01:35.703 [info] == Running 20200828071543 Mobilizon.Storage.Repo.Migrations.AddLoginInformationToUser.change/0 forward773server # [ 6438.152386] server mobilizon_ctl[536]: 15:01:35.703 [info] alter table users774server # [ 6438.153344] server mobilizon_ctl[536]: 15:01:35.704 [info] == Migrated 20200828071543 in 0.0s775server # [ 6438.159102] server mobilizon_ctl[536]: 15:01:35.710 [info] == Running 20200901101307 Mobilizon.Storage.Repo.Migrations.FixRelayVisibility.up/0 forward776server # [ 6438.162831] server mobilizon_ctl[536]: 15:01:35.713 [info] == Migrated 20200901101307 in 0.0s777server # [ 6438.169171] server mobilizon_ctl[536]: 15:01:35.720 [info] == Running 20200928150725 Mobilizon.Storage.Repo.Migrations.AddContactsToEvents.change/0 forward778server # [ 6438.169576] server mobilizon_ctl[536]: 15:01:35.720 [info] create table event_contacts779server # [ 6438.172818] server mobilizon_ctl[536]: 15:01:35.723 [info] == Migrated 20200928150725 in 0.0s780server # [ 6438.178714] server mobilizon_ctl[536]: 15:01:35.729 [info] == Running 20201006132530 Mobilizon.Storage.Repo.Migrations.ChangeDefaultNotificationPendingParticipation.up/0 forward781server # [ 6438.178714] server mobilizon_ctl[536]: 15:01:35.730 [info] alter table user_settings782server # [ 6438.180048] server mobilizon_ctl[536]: 15:01:35.731 [info] == Migrated 20201006132530 in 0.0s783server # [ 6438.186142] server mobilizon_ctl[536]: 15:01:35.737 [info] == Running 20201103141811 Mobilizon.Storage.Repo.Migrations.AddNotificationPendingMembershipToSettings.change/0 forward784server # [ 6438.186388] server mobilizon_ctl[536]: 15:01:35.737 [info] alter table user_settings785server # [ 6438.187162] server mobilizon_ctl[536]: 15:01:35.738 [info] == Migrated 20201103141811 in 0.0s786server # [ 6438.195628] server mobilizon_ctl[536]: 15:01:35.746 [info] == Running 20201105145719 Mobilizon.Storage.Repo.Migrations.RepairGroupsWithMissingURLs.up/0 forward787server # [ 6438.204329] server mobilizon_ctl[536]: 15:01:35.755 [info] == Migrated 20201105145719 in 0.0s788server # [ 6438.207111] server mobilizon_ctl[536]: 15:01:35.758 [info] == Running 20201114174929 Mobilizon.Storage.Repo.Migrations.FixObanMigrationsForOlderPostgreSQLVersions.up/0 forward789server # [ 6438.207590] server mobilizon_ctl[536]: 15:01:35.758 [info] == Migrated 20201114174929 in 0.0s790server # [ 6438.219056] server mobilizon_ctl[536]: 15:01:35.770 [info] == Running 20201114175249 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV9.up/0 forward791server # [ 6438.221526] server mobilizon_ctl[536]: 15:01:35.772 [info] == Migrated 20201114175249 in 0.0s792server # [ 6438.226857] server mobilizon_ctl[536]: 15:01:35.778 [info] == Running 20201120161229 Mobilizon.Storage.Repo.Migrations.FixPictureDeletion.up/0 forward793server # [ 6438.226980] server mobilizon_ctl[536]: 15:01:35.778 [info] drop constraint if exists posts_picture_id_fkey from table posts794server # [ 6438.228027] server mobilizon_ctl[536]: 15:01:35.779 [info] alter table posts795server # [ 6438.229398] server mobilizon_ctl[536]: 15:01:35.780 [info] drop constraint if exists events_picture_id_fkey from table events796server # [ 6438.230170] server mobilizon_ctl[536]: 15:01:35.781 [info] alter table events797server # [ 6438.232027] server mobilizon_ctl[536]: 15:01:35.783 [info] == Migrated 20201120161229 in 0.0s798server # [ 6438.239539] server mobilizon_ctl[536]: 15:01:35.790 [info] == Running 20201124094655 Mobilizon.Storage.Repo.Migrations.AddMediaTables.change/0 forward799server # [ 6438.239924] server mobilizon_ctl[536]: 15:01:35.791 [info] rename table pictures to medias800server # [ 6438.240885] server mobilizon_ctl[536]: 15:01:35.792 [info] create table events_medias801server # [ 6438.243939] server mobilizon_ctl[536]: 15:01:35.794 [info] create table posts_medias802server # [ 6438.246127] server mobilizon_ctl[536]: 15:01:35.797 [info] create table comments_medias803server # [ 6438.248733] server mobilizon_ctl[536]: 15:01:35.799 [info] == Migrated 20201124094655 in 0.0s804server # [ 6438.258817] server mobilizon_ctl[536]: 15:01:35.809 [info] == Running 20210127153325 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV10.up/0 forward805server # [ 6438.260463] server mobilizon_ctl[536]: 15:01:35.811 [info] == Migrated 20210127153325 in 0.0s806server # [ 6438.266359] server mobilizon_ctl[536]: 15:01:35.817 [info] == Running 20210210143432 Mobilizon.Storage.Repo.Migrations.AddLocationSettingsToUser.change/0 forward807server # [ 6438.266581] server mobilizon_ctl[536]: 15:01:35.817 [info] alter table user_settings808server # [ 6438.268131] server mobilizon_ctl[536]: 15:01:35.819 [info] == Migrated 20210210143432 in 0.0s809server # [ 6438.273629] server mobilizon_ctl[536]: 15:01:35.824 [info] == Running 20210215092515 Mobilizon.Storage.Repo.Migrations.AddActivityTable.change/0 forward810server # [ 6438.273975] server mobilizon_ctl[536]: 15:01:35.825 [info] create table activities811server # [ 6438.280100] server mobilizon_ctl[536]: 15:01:35.831 [info] == Migrated 20210215092515 in 0.0s812server # [ 6438.288740] server mobilizon_ctl[536]: 15:01:35.840 [info] == Running 20210217164549 Mobilizon.Storage.Repo.Migrations.AddMemberSinceToMembers.up/0 forward813server # [ 6438.288897] server mobilizon_ctl[536]: 15:01:35.840 [info] alter table members814server # [ 6438.292283] server mobilizon_ctl[536]: 15:01:35.843 [info] == Migrated 20210217164549 in 0.0s815server # [ 6438.295733] server mobilizon_ctl[536]: 15:01:35.847 [info] == Running 20210310084210 Mobilizon.Storage.Repo.Migrations.AddIndexesToActivities.change/0 forward816server # [ 6438.295883] server mobilizon_ctl[536]: 15:01:35.847 [info] create index activity_group_id817server # [ 6438.297234] server mobilizon_ctl[536]: 15:01:35.848 [info] create index activity_filter818server # [ 6438.298518] server mobilizon_ctl[536]: 15:01:35.849 [info] == Migrated 20210310084210 in 0.0s819server # [ 6438.304200] server mobilizon_ctl[536]: 15:01:35.855 [info] == Running 20210422140923 Mobilizon.Storage.Repo.Migrations.CleanupAddresses.up/0 forward820server # [ 6438.306566] server mobilizon_ctl[536]: 15:01:35.857 [info] == Migrated 20210422140923 in 0.0s821server # [ 6438.313621] server mobilizon_ctl[536]: 15:01:35.864 [info] == Running 20210422155913 Mobilizon.Storage.Repo.Migrations.AddIndexToAddresses.up/0 forward822server # [ 6438.313871] server mobilizon_ctl[536]: 15:01:35.865 [info] create index if not exists addresses_url_index823server # [ 6438.315177] server mobilizon_ctl[536]: 15:01:35.866 [info] == Migrated 20210422155913 in 0.0s824server # [ 6438.321891] server mobilizon_ctl[536]: 15:01:35.873 [info] == Running 20210427091034 Mobilizon.Storage.Repo.Migrations.RepairUsersDefaultActors.up/0 forward825server # [ 6438.323590] server mobilizon_ctl[536]: 15:01:35.874 [info] == Migrated 20210427091034 in 0.0s826server # [ 6438.326826] server mobilizon_ctl[536]: 15:01:35.878 [info] == Running 20210505172402 Mobilizon.Storage.Repo.Migrations.AddGroupNotificationAndLastNotificationDateSettings.change/0 forward827server # [ 6438.326997] server mobilizon_ctl[536]: 15:01:35.878 [info] alter table user_settings828server # [ 6438.328294] server mobilizon_ctl[536]: 15:01:35.879 [info] == Migrated 20210505172402 in 0.0s829server # [ 6438.333926] server mobilizon_ctl[536]: 15:01:35.885 [info] == Running 20210506080303 Mobilizon.Repo.Migrations.CreateUserPushSubscriptions.change/0 forward830server # [ 6438.334482] server mobilizon_ctl[536]: 15:01:35.885 [info] create table user_push_subscriptions831server # [ 6438.338019] server mobilizon_ctl[536]: 15:01:35.889 [info] create index user_push_subscriptions_user_id_digest_index832server # [ 6438.339610] server mobilizon_ctl[536]: 15:01:35.890 [info] == Migrated 20210506080303 in 0.0s833server # [ 6438.349171] server mobilizon_ctl[536]: 15:01:35.900 [info] == Running 20210512084824 Mobilizon.Storage.Repo.Migrations.RepairRelayAndAnonymousActors.up/0 forward834server # [ 6438.350727] server mobilizon_ctl[536]: 15:01:35.901 [info] == Migrated 20210512084824 in 0.0s835server # [ 6438.357048] server mobilizon_ctl[536]: 15:01:35.908 [info] == Running 20210526203337 Mobilizon.Storage.Repo.Migrations.AddUserActivitySettings.change/0 forward836server # [ 6438.357461] server mobilizon_ctl[536]: 15:01:35.908 [info] create table user_activity_settings837server # [ 6438.361130] server mobilizon_ctl[536]: 15:01:35.912 [info] create index user_activity_settings_user_id_key_method_index838server # [ 6438.362227] server mobilizon_ctl[536]: 15:01:35.913 [info] == Migrated 20210526203337 in 0.0s839server # [ 6438.369402] server mobilizon_ctl[536]: 15:01:35.920 [info] == Running 20210601082412 Mobilizon.Storage.Repo.Migrations.AddIsAnnouncementToComments.change/0 forward840server # [ 6438.369679] server mobilizon_ctl[536]: 15:01:35.920 [info] alter table comments841server # [ 6438.370999] server mobilizon_ctl[536]: 15:01:35.922 [info] == Migrated 20210601082412 in 0.0s842server # [ 6438.380041] server mobilizon_ctl[536]: 15:01:35.931 [info] == Running 20210601082613 Mobilizon.Storage.Repo.Migrations.FixUserSettingsNullableFields.change/0 forward843server # [ 6438.380209] server mobilizon_ctl[536]: 15:01:35.931 [info] alter table user_settings844server # [ 6438.381925] server mobilizon_ctl[536]: 15:01:35.932 [info] == Migrated 20210601082613 in 0.0s845server # [ 6438.387185] server mobilizon_ctl[536]: 15:01:35.938 [info] == Running 20210608133040 Mobilizon.Storage.Repo.Migrations.AddMetadataToMedia.change/0 forward846server # [ 6438.387310] server mobilizon_ctl[536]: 15:01:35.938 [info] alter table medias847server # [ 6438.388222] server mobilizon_ctl[536]: 15:01:35.939 [info] == Migrated 20210608133040 in 0.0s848server # [ 6438.393781] server mobilizon_ctl[536]: 15:01:35.945 [info] == Running 20210622133516 Mobilizon.Storage.Repo.Migrations.CleanupPosts.up/0 forward849server # [ 6438.395186] server mobilizon_ctl[536]: 15:01:35.946 [info] == Migrated 20210622133516 in 0.0s850server # [ 6438.398178] server mobilizon_ctl[536]: 15:01:35.949 [info] == Running 20210622133555 Mobilizon.Storage.Repo.Migrations.AddIndexToPosts.up/0 forward851server # [ 6438.398290] server mobilizon_ctl[536]: 15:01:35.949 [info] create index if not exists posts_url_index852server # [ 6438.399477] server mobilizon_ctl[536]: 15:01:35.950 [info] == Migrated 20210622133555 in 0.0s853server # [ 6438.404573] server mobilizon_ctl[536]: 15:01:35.955 [info] == Running 20210730143924 Mobilizon.Storage.Repo.Migrations.PutUniqueIndexOnParticipantsUrls.up/0 forward854server # [ 6438.404647] server mobilizon_ctl[536]: 15:01:35.956 [info] create index if not exists participants_url_index855server # [ 6438.406063] server mobilizon_ctl[536]: 15:01:35.957 [info] == Migrated 20210730143924 in 0.0s856server # [ 6438.412109] server mobilizon_ctl[536]: 15:01:35.963 [info] == Running 20210805142745 Mobilizon.Storage.Repo.Migrations.AddMetadataForEvents.change/0 forward857server # [ 6438.412318] server mobilizon_ctl[536]: 15:01:35.963 [info] alter table events858server # [ 6438.413072] server mobilizon_ctl[536]: 15:01:35.964 [info] == Migrated 20210805142745 in 0.0s859server # [ 6438.421673] server mobilizon_ctl[536]: 15:01:35.972 [info] == Running 20210819161507 Mobilizon.Storage.Repo.Migrations.AddLanguageToEntities.change/0 forward860server # [ 6438.421981] server mobilizon_ctl[536]: 15:01:35.973 [info] alter table events861server # [ 6438.422926] server mobilizon_ctl[536]: 15:01:35.974 [info] alter table comments862server # [ 6438.423754] server mobilizon_ctl[536]: 15:01:35.975 [info] alter table posts863server # [ 6438.424565] server mobilizon_ctl[536]: 15:01:35.975 [info] == Migrated 20210819161507 in 0.0s864server # [ 6438.427201] server mobilizon_ctl[536]: 15:01:35.978 [info] == Running 20211001101902 Mobilizon.Repo.Migrations.CreateExports.change/0 forward865server # [ 6438.427467] server mobilizon_ctl[536]: 15:01:35.978 [info] create table exports866server # [ 6438.430360] server mobilizon_ctl[536]: 15:01:35.981 [info] create index exports_file_path_index867server # [ 6438.431544] server mobilizon_ctl[536]: 15:01:35.982 [info] == Migrated 20211001101902 in 0.0s868server # [ 6438.443705] server mobilizon_ctl[536]: 15:01:35.994 [info] == Running 20211008084901 Mobilizon.Storage.Repo.Migrations.AddTimezoneToAddresses.change/0 forward869server # [ 6438.443850] server mobilizon_ctl[536]: 15:01:35.995 [info] alter table addresses870server # [ 6438.444621] server mobilizon_ctl[536]: 15:01:35.995 [info] == Migrated 20211008084901 in 0.0s871server # [ 6438.452035] server mobilizon_ctl[536]: 15:01:36.003 [info] == Running 20211013090405 Mobilizon.Storage.Repo.Migrations.AddCodeToParticipants.change/0 forward872server # [ 6438.452382] server mobilizon_ctl[536]: 15:01:36.003 [info] alter table participants873server # [ 6438.453135] server mobilizon_ctl[536]: 15:01:36.004 [info] == Migrated 20211013090405 in 0.0s874server # [ 6438.458676] server mobilizon_ctl[536]: 15:01:36.009 [info] == Running 20211022093530 Mobilizon.Storage.Repo.Migrations.AddNotifyToFollowers.change/0 forward875server # [ 6438.458860] server mobilizon_ctl[536]: 15:01:36.010 [info] alter table followers876server # [ 6438.459723] server mobilizon_ctl[536]: 15:01:36.010 [info] == Migrated 20211022093530 in 0.0s877server # [ 6438.462306] server mobilizon_ctl[536]: 15:01:36.013 [info] == Running 20211223141104 Mobilizon.Storage.Repo.Migrations.AddInstanceMaterializedView.up/0 forward878server # [ 6438.465053] server mobilizon_ctl[536]: 15:01:36.016 [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"879server # [ 6438.478223] server mobilizon_ctl[536]: 15:01:36.029 [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"880server # [ 6438.478938] server mobilizon_ctl[536]: 15:01:36.030 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger ON actors;\n"881server # [ 6438.479388] server mobilizon_ctl[536]: 15:01:36.030 [info] trigger "refresh_instances_trigger" for relation "actors" does not exist, skipping882server # [ 6438.479850] server mobilizon_ctl[536]: 15:01:36.030 [info] execute "CREATE TRIGGER refresh_instances_trigger\nAFTER INSERT OR UPDATE OR DELETE\nON actors\nFOR EACH STATEMENT\nEXECUTE PROCEDURE refresh_instances();\n"883server # [ 6438.479963] server mobilizon_ctl[536]: 15:01:36.031 [info] create index if not exists instances_domain_index884server # [ 6438.483100] server mobilizon_ctl[536]: 15:01:36.034 [info] == Migrated 20211223141104 in 0.0s885server # [ 6438.492952] server mobilizon_ctl[536]: 15:01:36.044 [info] == Running 20220321154138 Mobilizon.Storage.Repo.Migrations.CreateObanPeers.up/0 forward886server # [ 6438.494380] server mobilizon_ctl[536]: 15:01:36.045 [info] == Migrated 20220321154138 in 0.0s887server # [ 6438.499946] server mobilizon_ctl[536]: 15:01:36.051 [info] == Running 20220321154142 Mobilizon.Storage.Repo.Migrations.SwapPrimaryObanIndexes.change/0 forward888server # [ 6438.500320] server mobilizon_ctl[536]: 15:01:36.051 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index889server # [ 6438.501706] server mobilizon_ctl[536]: 15:01:36.052 [info] relation "oban_jobs_state_queue_priority_scheduled_at_id_index" already exists, skipping890server # [ 6438.501787] server mobilizon_ctl[536]: 15:01:36.053 [info] drop index if exists public.oban_jobs_queue_state_priority_scheduled_at_id_index891server # [ 6438.502363] server mobilizon_ctl[536]: 15:01:36.053 [info] index "oban_jobs_queue_state_priority_scheduled_at_id_index" does not exist, skipping892server # [ 6438.502582] server mobilizon_ctl[536]: 15:01:36.053 [info] == Migrated 20220321154142 in 0.0s893server # [ 6438.510280] server mobilizon_ctl[536]: 15:01:36.061 [info] == Running 20220328153640 Mobilizon.Storage.Repo.Migrations.SetAllEventsCategoryToMeeting.up/0 forward894server # [ 6438.510280] server mobilizon_ctl[536]: 15:01:36.061 [info] execute "UPDATE events SET category = 'MEETING'"895server # [ 6438.511304] server mobilizon_ctl[536]: 15:01:36.062 [info] == Migrated 20220328153640 in 0.0s896server # [ 6438.513929] server mobilizon_ctl[536]: 15:01:36.065 [info] == Running 20220407083712 Mobilizon.Storage.Repo.Migrations.AddIndexesToAddresses.up/0 forward897server # [ 6438.513929] server mobilizon_ctl[536]: 15:01:36.065 [info] create index if not exists idx_addresses_geom_x898server # [ 6438.515766] server mobilizon_ctl[536]: 15:01:36.067 [info] create index if not exists idx_addresses_geom_y899server # [ 6438.517148] server mobilizon_ctl[536]: 15:01:36.068 [info] == Migrated 20220407083712 in 0.0s900server # [ 6438.524189] server mobilizon_ctl[536]: 15:01:36.075 [info] == Running 20220505091224 Mobilizon.Storage.Repo.Migrations.ChangeRefreshInstanceTriggerToOnlyExecuteOnRelays.up/0 forward901server # [ 6438.524344] server mobilizon_ctl[536]: 15:01:36.075 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger ON actors;\n"902server # [ 6438.525334] server mobilizon_ctl[536]: 15:01:36.076 [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"903server # [ 6438.526473] server mobilizon_ctl[536]: 15:01:36.077 [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"904server # [ 6438.527240] server mobilizon_ctl[536]: 15:01:36.078 [info] == Migrated 20220505091224 in 0.0s905server # [ 6438.532586] server mobilizon_ctl[536]: 15:01:36.083 [info] == Running 20220506105150 Mobilizon.Storage.Repo.Migrations.RemoveRefreshInstanceTriggers.up/0 forward906server # [ 6438.532743] server mobilizon_ctl[536]: 15:01:36.083 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger_new ON actors;\n"907server # [ 6438.533704] server mobilizon_ctl[536]: 15:01:36.084 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger_old ON actors;\n"908server # [ 6438.534351] server mobilizon_ctl[536]: 15:01:36.085 [info] == Migrated 20220506105150 in 0.0s909server # [ 6438.540444] server mobilizon_ctl[536]: 15:01:36.091 [info] == Running 20230208101626 Mobilizon.Repo.Migrations.CreateApplications.change/0 forward910server # [ 6438.540789] server mobilizon_ctl[536]: 15:01:36.092 [info] create table applications911server # [ 6438.544577] server mobilizon_ctl[536]: 15:01:36.095 [info] create index applications_owner_id_owner_type_index912server # [ 6438.546570] server mobilizon_ctl[536]: 15:01:36.097 [info] == Migrated 20230208101626 in 0.0s913server # [ 6438.554757] server mobilizon_ctl[536]: 15:01:36.106 [info] == Running 20230215125801 Mobilizon.Repo.Migrations.CreateApplicationTokens.change/0 forward914server # [ 6438.555290] server mobilizon_ctl[536]: 15:01:36.106 [info] create table application_tokens915server # [ 6438.560649] server mobilizon_ctl[536]: 15:01:36.111 [info] create index application_tokens_user_id_application_id_index916server # [ 6438.561812] server mobilizon_ctl[536]: 15:01:36.112 [info] == Migrated 20230215125801 in 0.0s917server # [ 6438.573615] server mobilizon_ctl[536]: 15:01:36.124 [info] == Running 20230217084253 Mobilizon.Repo.Migrations.CreateApplicationDeviceActivation.change/0 forward918server # [ 6438.573781] server mobilizon_ctl[536]: 15:01:36.125 [info] create table application_device_activation919server # [ 6438.579447] server mobilizon_ctl[536]: 15:01:36.130 [info] == Migrated 20230217084253 in 0.0s920server # [ 6438.587227] server mobilizon_ctl[536]: 15:01:36.138 [info] == Running 20230605143534 Mobilizon.Storage.Repo.Migrations.AllowMultipleEventsToBeReported.up/0 forward921server # [ 6438.587507] server mobilizon_ctl[536]: 15:01:36.138 [info] create table reports_events922server # [ 6438.589847] server mobilizon_ctl[536]: 15:01:36.141 [info] == Migrated 20230605143534 in 0.0s923server # [ 6438.593749] server mobilizon_ctl[536]: 15:01:36.145 [info] == Running 20230605153836 Mobilizon.Storage.Repo.Migrations.BackfillReportEventsWithOldEvents.up/0 forward924server # [ 6438.594722] server mobilizon_ctl[536]: 15:01:36.145 [info] == Migrated 20230605153836 in 0.0s925server # [ 6438.605526] server mobilizon_ctl[536]: 15:01:36.156 [info] == Running 20230605154106 Mobilizon.Storage.Repo.Migrations.RemoveObsoleteEventIdOnReports.up/0 forward926server # [ 6438.605526] server mobilizon_ctl[536]: 15:01:36.156 [info] alter table reports927server # [ 6438.607410] server mobilizon_ctl[536]: 15:01:36.158 [info] == Migrated 20230605154106 in 0.0s928server # [ 6438.612935] server mobilizon_ctl[536]: 15:01:36.164 [info] == Running 20230831153358 Mobilizon.Storage.Repo.Migrations.RemoveOnDeleteCascadeForReports.up/0 forward929server # [ 6438.613362] server mobilizon_ctl[536]: 15:01:36.164 [info] execute "DROP MATERIALIZED VIEW IF EXISTS instances;\n"930server # [ 6438.617469] server mobilizon_ctl[536]: 15:01:36.168 [info] drop constraint reports_reported_id_fkey from table reports931server # [ 6438.618456] server mobilizon_ctl[536]: 15:01:36.169 [info] drop constraint reports_reporter_id_fkey from table reports932server # [ 6438.619036] server mobilizon_ctl[536]: 15:01:36.170 [info] drop constraint reports_manager_id_fkey from table reports933server # [ 6438.619651] server mobilizon_ctl[536]: 15:01:36.170 [info] alter table reports934server # [ 6438.622151] server mobilizon_ctl[536]: 15:01:36.173 [info] drop constraint report_notes_moderator_id_fkey from table report_notes935server # [ 6438.622699] server mobilizon_ctl[536]: 15:01:36.173 [info] alter table report_notes936server # [ 6438.624051] server mobilizon_ctl[536]: 15:01:36.175 [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"937server # [ 6438.634156] server mobilizon_ctl[536]: 15:01:36.185 [info] == Migrated 20230831153358 in 0.0s938server # [ 6438.643156] server mobilizon_ctl[536]: 15:01:36.194 [info] == Running 20230901160000 Mobilizon.Storage.Repo.Migrations.AddExternalUrlForEvents.up/0 forward939server # [ 6438.643502] server mobilizon_ctl[536]: 15:01:36.194 [info] alter table events940server # [ 6438.644395] server mobilizon_ctl[536]: 15:01:36.195 [info] execute "ALTER TABLE events ALTER COLUMN join_options TYPE VARCHAR USING join_options::text"941server # [ 6438.648942] server mobilizon_ctl[536]: 15:01:36.200 [info] execute "ALTER TABLE events ALTER COLUMN join_options DROP DEFAULT"942server # [ 6438.649773] server mobilizon_ctl[536]: 15:01:36.200 [info] execute "DROP TYPE public.join_options"943server # [ 6438.650188] server mobilizon_ctl[536]: 15:01:36.201 [info] execute "CREATE TYPE public.join_options AS ENUM ('free', 'restricted', 'invite', 'external')"944server # [ 6438.651694] server mobilizon_ctl[536]: 15:01:36.202 [info] execute "ALTER TABLE events ALTER COLUMN join_options TYPE join_options USING join_options::join_options"945server # [ 6438.657417] server mobilizon_ctl[536]: 15:01:36.206 [info] execute "ALTER TABLE events ALTER COLUMN join_options SET DEFAULT 'free'::join_options"946server # [ 6438.657417] server mobilizon_ctl[536]: 15:01:36.207 [info] == Migrated 20230901160000 in 0.0s947server # [ 6438.666289] server mobilizon_ctl[536]: 15:01:36.217 [info] == Running 20230920071502 Mobilizon.Storage.Repo.Migrations.AddActorConversations.up/0 forward948server # [ 6438.666913] server mobilizon_ctl[536]: 15:01:36.218 [info] create table conversations949server # [ 6438.671595] server mobilizon_ctl[536]: 15:01:36.222 [info] create table conversation_participants950server # [ 6438.674548] server mobilizon_ctl[536]: 15:01:36.225 [info] alter table comments951server # [ 6438.675804] server mobilizon_ctl[536]: 15:01:36.226 [info] == Migrated 20230920071502 in 0.0s952server # [ 6438.683045] server mobilizon_ctl[536]: 15:01:36.234 [info] == Running 20231220092536 Mobilizon.Storage.Repo.Migrations.AddActorInstances.change/0 forward953server # [ 6438.683290] server mobilizon_ctl[536]: 15:01:36.234 [info] create table instance_actors954server # [ 6438.688188] server mobilizon_ctl[536]: 15:01:36.239 [info] create index instance_actors_domain_index955server # [ 6438.689592] server mobilizon_ctl[536]: 15:01:36.240 [info] == Migrated 20231220092536 in 0.0s956server # [ 6438.698123] server mobilizon_ctl[536]: 15:01:36.249 [info] == Running 20240104103036 Mobilizon.Storage.Repo.Migrations.ChangeActorInstanceDescriptionTypeToText.up/0 forward957server # [ 6438.698317] server mobilizon_ctl[536]: 15:01:36.249 [info] alter table instance_actors958server # [ 6438.699395] server mobilizon_ctl[536]: 15:01:36.250 [info] == Migrated 20240104103036 in 0.0s959server # [ 6438.705458] server mobilizon_ctl[536]: 15:01:36.256 [info] == Running 20240222121054 Mobilizon.Storage.Repo.Migrations.CreateAdminSettingsMedias.change/0 forward960server # [ 6438.705796] server mobilizon_ctl[536]: 15:01:36.257 [info] create table admin_settings_medias961server # [ 6438.709243] server mobilizon_ctl[536]: 15:01:36.260 [info] create index admin_settings_medias_group_name_index962server # [ 6438.710534] server mobilizon_ctl[536]: 15:01:36.261 [info] == Migrated 20240222121054 in 0.0s963server # [ 6438.720402] server mobilizon_ctl[536]: 15:01:36.271 [info] == Running 20240725130410 Mobilizon.Storage.Repo.Migrations.AddEventPhysicalAddressIndex.up/0 forward964server # [ 6438.720626] server mobilizon_ctl[536]: 15:01:36.271 [info] create index events_phys_addr_id965server # [ 6438.722297] server mobilizon_ctl[536]: 15:01:36.273 [info] == Migrated 20240725130410 in 0.0s966server # [ 6438.727645] server mobilizon_ctl[536]: 15:01:36.278 [info] == Running 20250521145952 Mobilizon.Storage.Repo.Migrations.AddUuidToMedia.change/0 forward967server # [ 6438.727966] server mobilizon_ctl[536]: 15:01:36.279 [info] alter table medias968server # [ 6438.732396] server mobilizon_ctl[536]: 15:01:36.283 [info] create index medias_uuid_index969server # [ 6438.733491] server mobilizon_ctl[536]: 15:01:36.284 [info] == Migrated 20250521145952 in 0.0s970server # [ 6438.758311] server mobilizon_ctl[536]: 15:01:36.309 [info] == Running 20250911120910 Mobilizon.Storage.Repo.Migrations.AddModerationToUser.change/0 forward971server # [ 6438.759092] server mobilizon_ctl[536]: 15:01:36.309 [info] alter table users972server # [ 6438.759683] server mobilizon_ctl[536]: 15:01:36.310 [info] == Migrated 20250911120910 in 0.0s973server # [ 6438.765392] server mobilizon_ctl[536]: 15:01:36.316 [info] == Running 20250919143627 Mobilizon.Storage.Repo.Migrations.UpdateRoleToUser.change/0 forward974server # [ 6438.765564] server mobilizon_ctl[536]: 15:01:36.316 [info] execute "ALTER TYPE user_role ADD VALUE IF NOT EXISTS 'pending';"975server # [ 6438.765972] server mobilizon_ctl[536]: 15:01:36.317 [info] enum label "pending" already exists, skipping976server # [ 6438.766207] server mobilizon_ctl[536]: 15:01:36.317 [info] == Migrated 20250919143627 in 0.0s977server # [ 6438.769181] server mobilizon_ctl[536]: 15:01:36.320 [info] == Running 20251027133219 Mobilizon.Storage.Repo.Migrations.CreateInvitations.change/0 forward978server # [ 6438.769404] server mobilizon_ctl[536]: 15:01:36.320 [info] create table invitations979server # [ 6438.775189] server mobilizon_ctl[536]: 15:01:36.326 [info] create index invitations_token_index980server # [ 6438.776599] server mobilizon_ctl[536]: 15:01:36.327 [info] == Migrated 20251027133219 in 0.0s981server # [ 6438.783958] server mobilizon_ctl[536]: 15:01:36.335 [info] == Running 20251111093015 Mobilizon.Storage.Repo.Migrations.AddAllowToGroup.change/0 forward982server # [ 6438.783958] server mobilizon_ctl[536]: 15:01:36.335 [info] alter table actors983server # [ 6438.785101] server mobilizon_ctl[536]: 15:01:36.336 [info] == Migrated 20251111093015 in 0.0s984server: (finished: waiting for unit mobilizon.service, in 14.70 seconds)985server: waiting for TCP port 41395 on localhost986server # [ 6438.812559] server systemd[1]: Started Mobilizon federated organization and mobilization platform.987server # [ 6438.813039] server systemd[1]: Reached target Multi-User System.988server # [ 6438.813641] server systemd[1]: Startup finished in 13.937s.989server # [ 6441.991012] server mobilizon[599]: 15:01:39.542 [info] No tzdata release files found in custom data dir. Copying release file from tzdata priv dir.990server # [ 6442.108073] server mobilizon[599]: 15:01:39.654 [info] Source for database :city not found: "/var/lib/mobilizon/geo/GeoLite2-City.mmdb"991server # [ 6442.163486] server mobilizon[599]: 15:01:39.714 [info] Loading 122 CA(s) from :otp store992server # [ 6442.190441] server mobilizon[599]: 15:01:39.741 [info] Running Mobilizon.Web.Endpoint with Bandit 1.12.0 at ::1:41395 (http)993server # [ 6442.190652] server mobilizon[599]: 15:01:39.742 [info] Access Mobilizon.Web.Endpoint at https://acme.test994server # [ 6442.202044] server mobilizon[599]: 15:01:39.753 [info] {"message":"notifier only receiving messages from its own node, functionality may be degraded","source":"oban","event":"notifier:switch","connectivity_status":"solitary"}995server # [ 6442.202434] server mobilizon[599]: 15:01:39.753 [info] {"message":"peer became leader","node":"mobilizon@server","source":"oban","event":"peer:election","leader":true,"was_leader":false}996Connection to localhost (::1) 41395 port [tcp/*] succeeded!997server: (finished: waiting for TCP port 41395 on localhost, in 4.07 seconds)998server: must succeed: curl --fail https://acme.test/999 % Total % Received % Xferd Average Speed Time Time Time Current1000 Dload Upload Total Spent Left Speed1001100 2289 100 2289 0 0 54721 0 01002server: (finished: must succeed: curl --fail https://acme.test/, in 0.07 seconds)1003(finished: run the VM test script, in 18.84 seconds)1004test script finished in 18.92s1005cleanup1006kill NspawnMachine (pid 50)1007(finished: cleanup, in 0.16 seconds)1008Container server terminated by signal KILL.