nixbot

builds

succeeded container-test-run-mobilizon checks.aarch64-linux.nixosTest · build #20 · raw

1Machine state will be reset. To keep it, pass --keep-machine-state2start all VLans3(finished: start all VLans, in 0.00 seconds)45Test will time out and terminate in 3600 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 # [1130137.941202] server systemd-journald[57]: Journal started21server # [1130137.941257] server systemd-journald[57]: Runtime Journal (/run/log/journal/8882d57e96124d24a7c08c391f1fc4c2) is 8M, max 311.2M, 303.2M free.22server # [1130137.959657] server systemd[1]: Finished Apply Kernel Variables.23server # [1130137.979940] server systemd[1]: Finished Create Static Device Nodes in /dev gracefully.24server # [1130137.999065] server systemd[1]: Starting Flush Journal to Persistent Storage...25server # [1130138.000035] server systemd[1]: Starting Create Static Device Nodes in /dev...26server # [1130138.019612] server systemd-journald[57]: Time spent on flushing to /var/log/journal/8882d57e96124d24a7c08c391f1fc4c2 is 1.899ms for 6 entries.27server # [1130138.019612] server systemd-journald[57]: System Journal (/var/log/journal/8882d57e96124d24a7c08c391f1fc4c2) is 512B, max 4G, 3.9G free.28server # [1130138.034041] server systemd[1]: Finished Create Static Device Nodes in /dev.29server # [1130138.035594] server systemd[1]: Finished Flush Journal to Persistent Storage.30server # [1130138.036910] server systemd[1]: Reached target Preparation for Local File Systems.31server # [1130138.037206] server systemd[1]: Rule-based Manager for Device Events and Files skipped, unmet condition check ConditionPathIsReadWrite=/sys32server # [1130138.168814] server systemd[1]: Finished Firewall.33server # [1130138.942566] server systemd[1]: Mounting /run/wrappers...34server # [1130138.994660] server systemd[1]: Mounted /run/wrappers.35server # [1130138.995498] server systemd[1]: Reached target Local File Systems.36server # [1130138.996663] server systemd[1]: Listening on Boot Loader Control Service Socket.37server # [1130138.997810] server systemd[1]: Starting Create SUID/SGID Wrappers...38server # [1130138.997857] server systemd[1]: Update Boot Loader Random Seed skipped, unmet condition check ConditionVirtualization=!container39server # [1130138.998694] server systemd[1]: Starting Save Transient machine-id to Disk...40server # [1130138.999529] server systemd[1]: Starting Create System Files and Directories...41server # [1130139.048293] server systemd-tmpfiles[161]: Cannot set file attributes for '/var/empty', value=0x00000010, mask=0x00000010, ignoring: Operation not permitted42server # [1130139.048675] server systemd-tmpfiles[161]: fchmod() of /var/log/journal failed: Operation not permitted43server # [1130139.048817] server systemd-tmpfiles[161]: fchmod() of /var/log/journal/8882d57e96124d24a7c08c391f1fc4c2 failed: Operation not permitted44server # [1130139.048994] server systemd-tmpfiles[161]: fchmod() of /run/log/journal failed: Operation not permitted45server # [1130139.056041] server systemd[1]: Finished Create System Files and Directories.46server # [1130139.057319] server suid-sgid-wrappers-start[168]: chmod: changing permissions of '/run/wrappers/wrappers.Wt7JASk1BU/chsh': Operation not permitted47server # [1130139.071484] server systemd[1]: suid-sgid-wrappers.service: Main process exited, code=exited, status=1/FAILURE48server # [1130139.071622] server systemd[1]: suid-sgid-wrappers.service: Failed with result 'exit-code'.49server # [1130139.071786] server systemd[1]: Failed to start Create SUID/SGID Wrappers.50server # [1130139.074384] server systemd[1]: Starting Rebuild Journal Catalog...51server # [1130139.075597] server systemd[1]: Starting Record System Boot/Shutdown in UTMP...52server # [1130139.089579] server systemd[1]: Finished Record System Boot/Shutdown in UTMP.53server # [1130139.097875] server systemd[1]: Finished Rebuild Journal Catalog.54server # [1130139.102121] server systemd[1]: Starting Update is Completed...55server # [1130139.130688] server systemd[1]: Finished Update is Completed.56server # [1130139.131141] server systemd[1]: Reached target System Initialization.57server # [1130139.131316] server systemd[1]: Discard unused filesystem blocks once a week skipped, unmet condition check ConditionVirtualization=!container58server # [1130139.131394] server systemd[1]: Started Daily Cleanup of Temporary Directories.59server # [1130139.131456] server systemd[1]: Reached target Timer Units.60server # [1130139.131709] server systemd[1]: Listening on D-Bus System Message Bus Socket.61server # [1130139.132133] server systemd[1]: Listening on Nix Daemon Socket.62server # [1130139.132413] server systemd[1]: Listening on Virtual Machine and Container Registration Service Socket.63server # [1130139.132490] server systemd[1]: Reached target Socket Units.64server # [1130139.132622] server systemd[1]: Reached target Basic System.65server # [1130139.134318] server systemd[1]: Starting Import lastlog data into lastlog2 database...66server # [1130139.136141] server systemd[1]: Starting Name Service Cache Daemon (nsncd)...67server # [1130139.137124] server systemd[1]: Starting resolvconf update...68server # [1130139.159271] server systemd[1]: Finished Import lastlog data into lastlog2 database.69server # [1130139.209566] server systemd[1]: nscd.service: Deactivated successfully.70server # [1130139.210082] server systemd[1]: Stopped Name Service Cache Daemon (nsncd).71server # [1130139.214583] server systemd[1]: Starting Name Service Cache Daemon (nsncd)...72server # [1130139.230618] server resolvconf-start[234]: setfacl: /run/resolvconf: Operation not supported73server # [1130139.232252] server systemd[1]: resolvconf.service: Main process exited, code=exited, status=1/FAILURE74server # [1130139.232390] server systemd[1]: resolvconf.service: Failed with result 'exit-code'.75server # [1130139.232602] server systemd[1]: Failed to start resolvconf update.76server # [1130139.233038] server systemd[1]: Reached target Preparation for Network.77server # [1130139.234545] server systemd[1]: Starting Address configuration of eth1...78server # [1130139.236091] server systemd[1]: Starting Extra networking commands....79server # [1130139.257123] server network-addresses-eth1-start[237]: adding address 192.168.1.1/24... done80server # [1130139.260427] server network-addresses-eth1-start[237]: adding address 2001:db8:1::1/64... done81server # [1130139.265038] server systemd[1]: Finished Address configuration of eth1.82server # [1130139.315094] server systemd[1]: Finished Extra networking commands..83server # [1130139.315353] server systemd[1]: Reached target Network.84server # [1130139.317349] server systemd[1]: Starting Nginx Web Server...85server # [1130139.319143] server systemd[1]: Starting PostgreSQL Server...86server # [1130139.346689] server systemd[1]: etc-machine\x2did.mount: Deactivated successfully.87server # [1130139.348288] server systemd[1]: Finished Save Transient machine-id to Disk.88server # [1130139.421641] server systemd[1]: Started Name Service Cache Daemon (nsncd).89server # [1130139.421767] server systemd[1]: Reached target Host and Network Name Lookups.90server # [1130139.421990] server systemd[1]: Reached target User and Group Name Lookups.91server # [1130139.422139] server nsncd[225]: Oct 21 13:55:48.917 INFO started, config: Config { ignored_request_types: {}, worker_count: 8, handoff_timeout: 10s }, path: "/var/run/nscd/socket"92server # [1130139.424309] server systemd[1]: Starting User Login Management...93server # [1130139.425603] server systemd[1]: Starting Permit User Sessions...94server # [1130139.452419] server systemd[1]: Finished Permit User Sessions.95server # [1130139.455017] server systemd[1]: Started Console Getty.96server # [1130139.455289] server systemd[1]: Getty on tty1 skipped, unmet condition check ConditionPathExists=/dev/tty097server # [1130139.455493] server systemd[1]: Reached target Login Prompts.98server # [1130140.547782] server systemd-logind[314]: New seat seat0.99server # [1130140.550218] server systemd[1]: Starting D-Bus System Message Bus...100server # [1130140.550413] server systemd[1]: Started User Login Management.101server # [1130140.551437] server systemd[1]: Starting linger-users.service...102server # [1130140.587731] server systemd[1]: linger-users.service: Deactivated successfully.103server # [1130140.588049] server systemd[1]: Finished linger-users.service.104server # [1130140.657313] server nginx-pre-start[328]: nginx: the configuration file /nix/store/nf0wk98ajvcm6iqkh7xk53mlb7bpy9p4-nginx.conf syntax is ok105server # [1130140.658008] server nginx-pre-start[328]: nginx: configuration file /nix/store/nf0wk98ajvcm6iqkh7xk53mlb7bpy9p4-nginx.conf test is successful106server # [1130140.663387] server systemd[1]: Started Nginx Web Server.107server # [1130140.670287] server postgresql-pre-start[330]: The files belonging to this database system will be owned by user "postgres".108server # [1130140.670287] server postgresql-pre-start[330]: This user must also own the server process.109server # [1130140.670676] server postgresql-pre-start[330]: The database cluster will be initialized with locale "en_US.UTF-8".110server # [1130140.670676] server postgresql-pre-start[330]: The default database encoding has accordingly been set to "UTF8".111server # [1130140.670676] server postgresql-pre-start[330]: The default text search configuration will be set to "english".112server # [1130140.670676] server postgresql-pre-start[330]: Data page checksums are disabled.113server # [1130140.670808] server postgresql-pre-start[330]: fixing permissions on existing directory /var/lib/postgresql/17 ... ok114server # [1130140.672710] server postgresql-pre-start[330]: creating subdirectories ... ok115server # [1130140.673054] server postgresql-pre-start[330]: selecting dynamic shared memory implementation ... posix116server # [1130140.696537] server postgresql-pre-start[330]: selecting default "max_connections" ... 100117server # [1130140.723324] server postgresql-pre-start[330]: selecting default "shared_buffers" ... 128MB118server # [1130140.987120] server dbus-broker-launch[324]: Looking up NSS user entry for 'systemd-timesync'...119server # [1130140.988654] server dbus-broker-launch[324]: NSS returned no entry for 'systemd-timesync'120server # [1130140.988654] server dbus-broker-launch[324]: Invalid user-name in /nix/store/q91fmjm24qdg0rw7wxys62pzx2c1hvr4-system-path/share/dbus-1/system.d/org.freedesktop.timesync1.conf +16: user="systemd-timesync"121server # [1130140.990540] server systemd[1]: Started D-Bus System Message Bus.122server # [1130141.000833] server dbus-broker-launch[324]: Ready123server # [1130141.017086] server postgresql-pre-start[330]: selecting default time zone ... UTC124server # [1130141.018000] server postgresql-pre-start[330]: creating configuration files ... ok125server # [1130141.179414] server postgresql-pre-start[330]: running bootstrap script ... ok126server # [1130141.642236] server postgresql-pre-start[330]: performing post-bootstrap initialization ... ok127server # [1130144.502118] server postgresql-pre-start[330]: syncing data to disk ... ok128server # [1130144.502118] server postgresql-pre-start[330]: initdb: warning: enabling "trust" authentication for local connections129server # [1130144.502118] 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 # [1130144.502118] server postgresql-pre-start[330]: Success. You can now start the database server using:131server # [1130144.502118] server postgresql-pre-start[330]: pg_ctl -D /var/lib/postgresql/17 -l logfile start132server # [1130145.658564] server postgres[349]: [349] LOG: starting PostgreSQL 17.10 on aarch64-unknown-linux-gnu, compiled by clang version 21.1.8, 64-bit133server # [1130145.659623] server postgres[349]: [349] LOG: listening on IPv6 address "::1", port 5432134server # [1130145.659623] server postgres[349]: [349] LOG: listening on IPv4 address "127.0.0.1", port 5432135server # [1130145.663517] server postgres[349]: [349] LOG: listening on Unix socket "/run/postgresql/.s.PGSQL.5432"136server # [1130145.672449] server postgres[356]: [356] LOG: database system was shut down at 2026-10-21 13:55:51 GMT137server # [1130145.680148] server postgres[349]: [349] LOG: database system is ready to accept connections138server # [1130145.684345] server systemd[1]: Started PostgreSQL Server.139server # [1130145.686642] server systemd[1]: Starting PostgreSQL Setup Scripts...140server # [1130145.855604] server postgresql-setup-start[367]: CREATE DATABASE141server # [1130145.883483] server postgresql-setup-start[372]: CREATE ROLE142server # [1130145.885806] server systemd[1]: Finished PostgreSQL Setup Scripts.143server # [1130145.886399] server systemd[1]: Reached target PostgreSQL.144server # [1130145.888079] server systemd[1]: Starting Mobilizon PostgreSQL setup...145server # [1130146.403055] server mobilizon-postgresql-start[376]: CREATE EXTENSION146server # [1130146.403055] server mobilizon-postgresql-start[376]: CREATE EXTENSION147server # [1130146.403055] server mobilizon-postgresql-start[376]: CREATE EXTENSION148server # [1130146.417164] server mobilizon-postgresql-start[378]: ALTER DATABASE149server # [1130146.418688] server systemd[1]: mobilizon-postgresql.service: Deactivated successfully.150server # [1130146.418998] server systemd[1]: Finished Mobilizon PostgreSQL setup.151server # [1130146.422278] server systemd[1]: Starting Mobilizon setup secrets...152server # [1130146.450016] server mobilizon-setup-secrets-start[381]: + '[' '!' -f /var/lib/mobilizon/secret-env.sh ']'153server # [1130146.450016] server mobilizon-setup-secrets-start[381]: + install -m 600 /dev/null /var/lib/mobilizon/secret-env.sh154server # [1130146.452104] server mobilizon-setup-secrets-start[381]: + cat155server # [1130146.453139] 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: still waiting for container 'server' to reach ready state...157server # [1130146.927840] 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))'158server # [1130147.377155] 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)))'159server # [1130147.826707] server systemd[1]: mobilizon-setup-secrets.service: Deactivated successfully.160server # [1130147.826957] server systemd[1]: Finished Mobilizon setup secrets.161server # [1130147.827154] server systemd[1]: mobilizon-setup-secrets.service: Consumed 1.869s CPU time over 1.404s wall clock time.162server # [1130147.828798] server systemd[1]: Starting Mobilizon federated organization and mobilization platform...163server # [1130148.671594] server mobilizon_ctl[536]: Loading app..164server # [1130148.672675] server mobilizon_ctl[536]: Starting dependencies..165server # [1130151.776552] server mobilizon_ctl[536]: #########################################################166server # [1130151.776552] server mobilizon_ctl[536]: # If the CREATE EXTENSION or DROP EXTENSION calls fail, #167server # [1130151.776552] server mobilizon_ctl[536]: # please manually execute them with an authorized #168server # [1130151.776552] server mobilizon_ctl[536]: # PostgreSQL user with SUPER USER role. #169server # [1130151.776552] server mobilizon_ctl[536]: #########################################################170server # [1130151.776552] server mobilizon_ctl[536]:171server # [1130151.776552] server mobilizon_ctl[536]:172server # [1130151.777490] server mobilizon_ctl[536]: 13:56:01.264 [info] == Running 20180109150000 Mobilizon.Repo.Migrations.Prerequites.up/0 forward173server # [1130151.780493] server mobilizon_ctl[536]: 13:56:01.276 [info] execute "CREATE TYPE datetimetz AS (\n dt timestamptz,\n tz varchar\n);\n"174server # [1130151.782329] server mobilizon_ctl[536]: 13:56:01.278 [info] execute "CREATE EXTENSION IF NOT EXISTS postgis"175server # [1130151.782998] server mobilizon_ctl[536]: 13:56:01.278 [info] extension "postgis" already exists, skipping176server # [1130151.783095] server mobilizon_ctl[536]: 13:56:01.279 [info] execute "CREATE EXTENSION IF NOT EXISTS pg_trgm"177server # [1130151.783389] server mobilizon_ctl[536]: 13:56:01.279 [info] extension "pg_trgm" already exists, skipping178server # [1130151.783487] server mobilizon_ctl[536]: 13:56:01.279 [info] execute "CREATE EXTENSION IF NOT EXISTS unaccent"179server # [1130151.783757] server mobilizon_ctl[536]: 13:56:01.279 [info] extension "unaccent" already exists, skipping180server # [1130151.786039] server mobilizon_ctl[536]: 13:56:01.282 [info] == Migrated 20180109150000 in 0.0s181server # [1130151.834080] server mobilizon_ctl[536]: 13:56:01.330 [info] == Running 20180109165738 Mobilizon.Repo.Migrations.CreateAccounts.change/0 forward182server # [1130151.834703] server mobilizon_ctl[536]: 13:56:01.330 [info] create table accounts183server # [1130151.838603] server mobilizon_ctl[536]: 13:56:01.334 [info] create index accounts_username_domain_index184server # [1130151.839665] server mobilizon_ctl[536]: 13:56:01.335 [info] == Migrated 20180109165738 in 0.0s185server # [1130151.849197] server mobilizon_ctl[536]: 13:56:01.345 [info] == Running 20180109170315 Mobilizon.Repo.Migrations.CreateUsers.change/0 forward186server # [1130151.849626] server mobilizon_ctl[536]: 13:56:01.345 [info] create table users187server # [1130151.854310] server mobilizon_ctl[536]: 13:56:01.350 [info] create index users_email_index188server # [1130151.856060] server mobilizon_ctl[536]: 13:56:01.352 [info] == Migrated 20180109170315 in 0.0s189server # [1130151.866101] server mobilizon_ctl[536]: 13:56:01.362 [info] == Running 20180110091747 Mobilizon.Repo.Migrations.CreateCategories.change/0 forward190server # [1130151.866284] server mobilizon_ctl[536]: 13:56:01.362 [info] create table categories191server # [1130151.871221] server mobilizon_ctl[536]: 13:56:01.366 [info] create index categories_title_index192server # [1130151.872426] server mobilizon_ctl[536]: 13:56:01.368 [info] == Migrated 20180110091747 in 0.0s193server # [1130151.878986] server mobilizon_ctl[536]: 13:56:01.374 [info] == Running 20180110092400 Mobilizon.Repo.Migrations.CreateAddresses.change/0 forward194server # [1130151.879304] server mobilizon_ctl[536]: 13:56:01.375 [info] create table addresses195server # [1130151.883147] server mobilizon_ctl[536]: 13:56:01.379 [info] == Migrated 20180110092400 in 0.0s196server # [1130151.890710] server mobilizon_ctl[536]: 13:56:01.386 [info] == Running 20180110092500 Mobilizon.Repo.Migrations.CreateGroups.change/0 forward197server # [1130151.890987] server mobilizon_ctl[536]: 13:56:01.387 [info] create table groups198server # [1130151.895270] server mobilizon_ctl[536]: 13:56:01.391 [info] create index groups_slug_index199server # [1130151.896454] server mobilizon_ctl[536]: 13:56:01.392 [info] == Migrated 20180110092500 in 0.0s200server # [1130151.908080] server mobilizon_ctl[536]: 13:56:01.404 [info] == Running 20180110092600 Mobilizon.Repo.Migrations.CreateEvents.change/0 forward201server # [1130151.908452] server mobilizon_ctl[536]: 13:56:01.404 [info] create table events202server # [1130151.913411] server mobilizon_ctl[536]: 13:56:01.409 [info] create index events_organizer_account_id_index203server # [1130151.914337] server mobilizon_ctl[536]: 13:56:01.410 [info] create index events_organizer_group_id_index204server # [1130151.915730] server mobilizon_ctl[536]: 13:56:01.411 [info] create index events_slug_index205server # [1130151.916679] server mobilizon_ctl[536]: 13:56:01.412 [info] == Migrated 20180110092600 in 0.0s206server # [1130151.925011] server mobilizon_ctl[536]: 13:56:01.420 [info] == Running 20180110093905 Mobilizon.Repo.Migrations.CreateTags.change/0 forward207server # [1130151.925187] server mobilizon_ctl[536]: 13:56:01.421 [info] create table tags208server # [1130151.927856] server mobilizon_ctl[536]: 13:56:01.423 [info] create index tags_slug_index209server # [1130151.929366] server mobilizon_ctl[536]: 13:56:01.425 [info] == Migrated 20180110093905 in 0.0s210server # [1130151.943196] server mobilizon_ctl[536]: 13:56:01.439 [info] == Running 20180110093906 Mobilizon.Repo.Migrations.CreateEventsTags.change/0 forward211server # [1130151.943371] server mobilizon_ctl[536]: 13:56:01.439 [info] create table events_tags212server # [1130151.946864] server mobilizon_ctl[536]: 13:56:01.442 [info] == Migrated 20180110093906 in 0.0s213server # [1130151.952788] server mobilizon_ctl[536]: 13:56:01.448 [info] == Running 20180110094301 Mobilizon.Repo.Migrations.CreateParticipants.change/0 forward214server # [1130151.953062] server mobilizon_ctl[536]: 13:56:01.449 [info] create table participants215server # [1130151.956411] server mobilizon_ctl[536]: 13:56:01.452 [info] create index participants_event_id_index216server # [1130151.957531] server mobilizon_ctl[536]: 13:56:01.453 [info] create index participants_account_id_index217server # [1130151.958656] server mobilizon_ctl[536]: 13:56:01.454 [info] == Migrated 20180110094301 in 0.0s218server # [1130151.975317] server mobilizon_ctl[536]: 13:56:01.471 [info] == Running 20180110094502 Mobilizon.Repo.Migrations.CreateEventRequests.change/0 forward219server # [1130151.975835] server mobilizon_ctl[536]: 13:56:01.471 [info] create table event_requests220server # [1130151.979387] server mobilizon_ctl[536]: 13:56:01.475 [info] create index event_requests_event_id_index221server # [1130151.980476] server mobilizon_ctl[536]: 13:56:01.476 [info] create index event_requests_account_id_index222server # [1130151.982415] server mobilizon_ctl[536]: 13:56:01.478 [info] == Migrated 20180110094502 in 0.0s223server # [1130151.990397] server mobilizon_ctl[536]: 13:56:01.486 [info] == Running 20180110095317 Mobilizon.Repo.Migrations.CreateMembers.change/0 forward224server # [1130151.991021] server mobilizon_ctl[536]: 13:56:01.486 [info] create table members225server # [1130151.993586] server mobilizon_ctl[536]: 13:56:01.489 [info] create index members_group_id_index226server # [1130151.994704] server mobilizon_ctl[536]: 13:56:01.490 [info] create index members_account_id_index227server # [1130151.995958] server mobilizon_ctl[536]: 13:56:01.491 [info] == Migrated 20180110095317 in 0.0s228server # [1130152.002701] server mobilizon_ctl[536]: 13:56:01.498 [info] == Running 20180110095515 Mobilizon.Repo.Migrations.CreateGroupRequests.change/0 forward229server # [1130152.002991] server mobilizon_ctl[536]: 13:56:01.499 [info] create table group_requests230server # [1130152.006937] server mobilizon_ctl[536]: 13:56:01.502 [info] create index group_requests_group_id_index231server # [1130152.008423] server mobilizon_ctl[536]: 13:56:01.504 [info] create index group_requests_account_id_index232server # [1130152.009747] server mobilizon_ctl[536]: 13:56:01.505 [info] == Migrated 20180110095515 in 0.0s233server # [1130152.016326] server mobilizon_ctl[536]: 13:56:01.512 [info] == Running 20180110165029 Mobilizon.Repo.Migrations.Guardian.DB.change/0 forward234server # [1130152.016732] server mobilizon_ctl[536]: 13:56:01.512 [info] create table guardian_tokens235server # [1130152.020465] server mobilizon_ctl[536]: 13:56:01.516 [info] == Migrated 20180110165029 in 0.0s236server # [1130152.023791] server mobilizon_ctl[536]: 13:56:01.519 [info] == Running 20180112100000 Mobilizon.Repo.Migrations.CreateTracks.change/0 forward237server # [1130152.024302] server mobilizon_ctl[536]: 13:56:01.520 [info] create table tracks238server # [1130152.027623] server mobilizon_ctl[536]: 13:56:01.523 [info] == Migrated 20180112100000 in 0.0s239server # [1130152.035218] server mobilizon_ctl[536]: 13:56:01.531 [info] == Running 20180112105354 Mobilizon.Repo.Migrations.CreateSessions.change/0 forward240server # [1130152.035572] server mobilizon_ctl[536]: 13:56:01.531 [info] create table sessions241server # [1130152.040515] server mobilizon_ctl[536]: 13:56:01.536 [info] == Migrated 20180112105354 in 0.0s242server # [1130152.049690] server mobilizon_ctl[536]: 13:56:01.545 [info] == Running 20180430071244 Mobilizon.Repo.Migrations.RemoveUri.up/0 forward243server # [1130152.049998] server mobilizon_ctl[536]: 13:56:01.545 [info] alter table accounts244server # [1130152.050894] server mobilizon_ctl[536]: 13:56:01.546 [info] alter table groups245server # [1130152.051802] server mobilizon_ctl[536]: 13:56:01.547 [info] == Migrated 20180430071244 in 0.0s246server # [1130152.057578] server mobilizon_ctl[536]: 13:56:01.553 [info] == Running 20180515091106 Mobilizon.Repo.Migrations.AddUrlFieldToEvents.up/0 forward247server # [1130152.057782] server mobilizon_ctl[536]: 13:56:01.553 [info] alter table events248server # [1130152.059299] server mobilizon_ctl[536]: 13:56:01.555 [info] == Migrated 20180515091106 in 0.0s249server # [1130152.063380] server mobilizon_ctl[536]: 13:56:01.559 [info] == Running 20180515100237 Mobilizon.Repo.Migrations.CreateComments.change/0 forward250server # [1130152.063677] server mobilizon_ctl[536]: 13:56:01.559 [info] create table comments251server # [1130152.069394] server mobilizon_ctl[536]: 13:56:01.565 [info] == Migrated 20180515100237 in 0.0s252server # [1130152.086623] server mobilizon_ctl[536]: 13:56:01.582 [info] == Running 20180515142835 Mobilizon.Repo.Migrations.AlterEventTimestampsToDateTimeWithTimeZone.up/0 forward253server # [1130152.086841] server mobilizon_ctl[536]: 13:56:01.582 [info] alter table events254server # [1130152.087797] server mobilizon_ctl[536]: 13:56:01.583 [info] == Migrated 20180515142835 in 0.0s255server # [1130152.095294] server mobilizon_ctl[536]: 13:56:01.590 [info] == Running 20180515145438 Mobilizon.Repo.Migrations.AddLocalAttributeToEventsAndComments.up/0 forward256server # [1130152.095658] server mobilizon_ctl[536]: 13:56:01.591 [info] alter table events257server # [1130152.096540] server mobilizon_ctl[536]: 13:56:01.592 [info] alter table comments258server # [1130152.097670] server mobilizon_ctl[536]: 13:56:01.593 [info] == Migrated 20180515145438 in 0.0s259server # [1130152.106178] server mobilizon_ctl[536]: 13:56:01.602 [info] == Running 20180517100700 Mobilizon.Repo.Migrations.MoveFromAccountToActor.up/0 forward260server # [1130152.109665] server mobilizon_ctl[536]: 13:56:01.605 [info] drop table event_requests261server # [1130152.112226] server mobilizon_ctl[536]: 13:56:01.608 [info] drop table group_requests262server # [1130152.114432] server mobilizon_ctl[536]: 13:56:01.610 [info] alter table events263server # [1130152.115602] server mobilizon_ctl[536]: 13:56:01.611 [info] rename column account_id to actor_id on table members264server # [1130152.116150] server mobilizon_ctl[536]: 13:56:01.612 [info] alter table members265server # [1130152.119155] server mobilizon_ctl[536]: 13:56:01.615 [info] drop table groups266server # [1130152.120947] server mobilizon_ctl[536]: 13:56:01.616 [info] rename table accounts to actors267server # [1130152.123169] server mobilizon_ctl[536]: 13:56:01.617 [info] execute "CREATE TYPE public.actor_type AS ENUM ('Person', 'Application', 'Group', 'Organization', 'Service')"268server # [1130152.124148] server mobilizon_ctl[536]: 13:56:01.620 [info] rename column username to name on table actors269server # [1130152.124868] server mobilizon_ctl[536]: 13:56:01.620 [info] rename column description to summary on table actors270server # [1130152.125918] server mobilizon_ctl[536]: 13:56:01.621 [info] rename column display_name to preferred_username on table actors271server # [1130152.127183] server mobilizon_ctl[536]: 13:56:01.622 [info] alter table actors272server # [1130152.131627] server mobilizon_ctl[536]: 13:56:01.627 [info] create index actors_preferred_username_domain_index273server # [1130152.132034] server mobilizon_ctl[536]: 13:56:01.628 [info] rename column organizer_account_id to organizer_actor_id on table events274server # [1130152.132519] server mobilizon_ctl[536]: 13:56:01.628 [info] rename column account_id to actor_id on table participants275server # [1130152.133101] server mobilizon_ctl[536]: 13:56:01.629 [info] create table followers276server # [1130152.136509] server mobilizon_ctl[536]: 13:56:01.632 [info] rename column account_id to actor_id on table comments277server # [1130152.136921] server mobilizon_ctl[536]: 13:56:01.632 [info] rename column account_id to actor_id on table users278server # [1130152.137360] server mobilizon_ctl[536]: 13:56:01.633 [info] == Migrated 20180517100700 in 0.0s279server # [1130152.148645] server mobilizon_ctl[536]: 13:56:01.644 [info] == Running 20180522133844 Mobilizon.Repo.Migrations.AddBotsTable.up/0 forward280server # [1130152.148935] server mobilizon_ctl[536]: 13:56:01.644 [info] create table bots281server # [1130152.153306] server mobilizon_ctl[536]: 13:56:01.649 [info] == Migrated 20180522133844 in 0.0s282server # [1130152.164973] server mobilizon_ctl[536]: 13:56:01.660 [info] == Running 20180530125159 Mobilizon.Repo.Migrations.AddAvatarAndBannerToActor.up/0 forward283server # [1130152.165228] server mobilizon_ctl[536]: 13:56:01.661 [info] alter table actors284server # [1130152.166299] server mobilizon_ctl[536]: 13:56:01.662 [info] == Migrated 20180530125159 in 0.0s285server # [1130152.169200] server mobilizon_ctl[536]: 13:56:01.665 [info] == Running 20180530152323 Mobilizon.Repo.Migrations.MakeActorPublicKeyNullable.up/0 forward286server # [1130152.169382] server mobilizon_ctl[536]: 13:56:01.665 [info] alter table actors287server # [1130152.170705] server mobilizon_ctl[536]: 13:56:01.666 [info] == Migrated 20180530152323 in 0.0s288server # [1130152.176676] server mobilizon_ctl[536]: 13:56:01.672 [info] == Running 20180530170808 Mobilizon.Repo.Migrations.AddUUIDIdToEvents.up/0 forward289server # [1130152.176849] server mobilizon_ctl[536]: 13:56:01.672 [info] alter table events290server # [1130152.178075] server mobilizon_ctl[536]: 13:56:01.673 [info] == Migrated 20180530170808 in 0.0s291server # [1130152.184297] server mobilizon_ctl[536]: 13:56:01.680 [info] == Running 20180531162301 Mobilizon.Repo.Migrations.AddApprovedStatusToMember.up/0 forward292server # [1130152.184510] server mobilizon_ctl[536]: 13:56:01.680 [info] alter table members293server # [1130152.185684] server mobilizon_ctl[536]: 13:56:01.681 [info] == Migrated 20180531162301 in 0.0s294server # [1130152.193572] server mobilizon_ctl[536]: 13:56:01.689 [info] == Running 20180607095732 Mobilizon.Repo.Migrations.AddUUIDToComments.up/0 forward295server # [1130152.193572] server mobilizon_ctl[536]: 13:56:01.689 [info] alter table comments296server # [1130152.194485] server mobilizon_ctl[536]: 13:56:01.690 [info] == Migrated 20180607095732 in 0.0s297server # [1130152.198830] server mobilizon_ctl[536]: 13:56:01.694 [info] == Running 20180614094653 Mobilizon.Repo.Migrations.MakeSharedInboxUrlNullable.up/0 forward298server # [1130152.199027] server mobilizon_ctl[536]: 13:56:01.695 [info] alter table actors299server # [1130152.200475] server mobilizon_ctl[536]: 13:56:01.696 [info] == Migrated 20180614094653 in 0.0s300server # [1130152.211318] server mobilizon_ctl[536]: 13:56:01.707 [info] == Running 20180614104618 Mobilizon.Repo.Migrations.FusionPublicPrivateKeyIntoKeysColumn.up/0 forward301server # [1130152.211666] server mobilizon_ctl[536]: 13:56:01.707 [info] rename column private_key to keys on table actors302server # [1130152.212708] server mobilizon_ctl[536]: 13:56:01.708 [info] alter table actors303server # [1130152.213354] server mobilizon_ctl[536]: 13:56:01.709 [info] == Migrated 20180614104618 in 0.0s304server # [1130152.219535] server mobilizon_ctl[536]: 13:56:01.715 [info] == Running 20180614131328 Mobilizon.Repo.Migrations.AddAttributedToFieldToEventsAndComments.up/0 forward305server # [1130152.219776] server mobilizon_ctl[536]: 13:56:01.715 [info] alter table events306server # [1130152.223126] server mobilizon_ctl[536]: 13:56:01.719 [info] alter table comments307server # [1130152.224682] server mobilizon_ctl[536]: 13:56:01.720 [info] == Migrated 20180614131328 in 0.0s308server # [1130152.228211] server mobilizon_ctl[536]: 13:56:01.724 [info] == Running 20180628091920 :"Elixir.Mobilizon.Repo.Migrations.Add-user-confirm-email-fields".up/0 forward309server # [1130152.228460] server mobilizon_ctl[536]: 13:56:01.724 [info] alter table users310server # [1130152.229155] server mobilizon_ctl[536]: 13:56:01.725 [info] create index index_unique_users_confirmation_token311server # [1130152.230786] server mobilizon_ctl[536]: 13:56:01.726 [info] == Migrated 20180628091920 in 0.0s312server # [1130152.240394] server mobilizon_ctl[536]: 13:56:01.735 [info] == Running 20180628130746 :"Elixir.Mobilizon.Repo.Migrations.Add-user-password-reset-fields".up/0 forward313server # [1130152.240913] server mobilizon_ctl[536]: 13:56:01.736 [info] alter table users314server # [1130152.241732] server mobilizon_ctl[536]: 13:56:01.737 [info] create index index_unique_users_reset_password_token315server # [1130152.243246] server mobilizon_ctl[536]: 13:56:01.739 [info] == Migrated 20180628130746 in 0.0s316server # [1130152.249173] server mobilizon_ctl[536]: 13:56:01.745 [info] == Running 20180628142835 Mobilizon.Repo.Migrations.RevertAlterEventTimestampsToDateTimeWithTimeZone.up/0 forward317server # [1130152.249354] server mobilizon_ctl[536]: 13:56:01.745 [info] alter table events318server # [1130152.250443] server mobilizon_ctl[536]: 13:56:01.746 [info] == Migrated 20180628142835 in 0.0s319server # [1130152.256921] server mobilizon_ctl[536]: 13:56:01.752 [info] == Running 20180702150922 Mobilizon.Repo.Migrations.AddAddressType.up/0 forward320server # [1130152.257295] server mobilizon_ctl[536]: 13:56:01.753 [info] alter table events321server # [1130152.258622] server mobilizon_ctl[536]: 13:56:01.754 [info] drop constraint events_address_id_fkey from table events322server # [1130152.260102] server mobilizon_ctl[536]: 13:56:01.756 [info] rename column address_id to physical_address_id on table events323server # [1130152.260822] server mobilizon_ctl[536]: 13:56:01.756 [info] alter table events324server # [1130152.262417] server mobilizon_ctl[536]: 13:56:01.758 [info] == Migrated 20180702150922 in 0.0s325server # [1130152.265335] server mobilizon_ctl[536]: 13:56:01.761 [info] == Running 20180702154630 Mobilizon.Repo.Migrations.RemoveSlugForEvent.up/0 forward326server # [1130152.265487] server mobilizon_ctl[536]: 13:56:01.761 [info] alter table events327server # [1130152.266423] server mobilizon_ctl[536]: 13:56:01.762 [info] == Migrated 20180702154630 in 0.0s328server # [1130152.275728] server mobilizon_ctl[536]: 13:56:01.771 [info] == Running 20180706082208 Mobilizon.Repo.Migrations.AlterEventsSetDescriptionAsText.up/0 forward329server # [1130152.276068] server mobilizon_ctl[536]: 13:56:01.772 [info] alter table events330server # [1130152.277082] server mobilizon_ctl[536]: 13:56:01.772 [info] == Migrated 20180706082208 in 0.0s331server # [1130152.285753] server mobilizon_ctl[536]: 13:56:01.781 [info] == Running 20180709154152 Mobilizon.Repo.Migrations.AllowMultipleAccountsForUser.up/0 forward332server # [1130152.285914] server mobilizon_ctl[536]: 13:56:01.781 [info] alter table actors333server # [1130152.289790] server mobilizon_ctl[536]: 13:56:01.784 [info] alter table users334server # [1130152.290311] server mobilizon_ctl[536]: 13:56:01.786 [info] == Migrated 20180709154152 in 0.0s335server # [1130152.299169] server mobilizon_ctl[536]: 13:56:01.795 [info] == Running 20180802133951 Mobilizon.Repo.Migrations.MakeFollowerTableUnique.up/0 forward336server # [1130152.299371] server mobilizon_ctl[536]: 13:56:01.795 [info] create index followers_actor_target_actor_unique_index337server # [1130152.300968] server mobilizon_ctl[536]: 13:56:01.796 [info] == Migrated 20180802133951 in 0.0s338server # [1130152.304732] server mobilizon_ctl[536]: 13:56:01.800 [info] == Running 20180816093446 Mobilizon.Repo.Migrations.AddPrimaryKeyToMember.up/0 forward339server # [1130152.305096] server mobilizon_ctl[536]: 13:56:01.801 [info] execute "ALTER TABLE members DROP CONSTRAINT IF EXISTS members_pkey"340server # [1130152.305860] server mobilizon_ctl[536]: 13:56:01.801 [info] constraint "members_pkey" of relation "members" does not exist, skipping341server # [1130152.305961] server mobilizon_ctl[536]: 13:56:01.801 [info] drop index if exists members_members_account_id_index_index342server # [1130152.306465] server mobilizon_ctl[536]: 13:56:01.802 [info] index "members_members_account_id_index_index" does not exist, skipping343server # [1130152.306465] server mobilizon_ctl[536]: 13:56:01.802 [info] create index members_actor_parent_unique_index344server # [1130152.307876] server mobilizon_ctl[536]: 13:56:01.803 [info] alter table members345server # [1130152.310984] server mobilizon_ctl[536]: 13:56:01.806 [info] == Migrated 20180816093446 in 0.0s346server # [1130152.319281] server mobilizon_ctl[536]: 13:56:01.815 [info] == Running 20181021161324 Mobilizon.Repo.Migrations.AddDefaultActorUserField.up/0 forward347server # [1130152.319480] server mobilizon_ctl[536]: 13:56:01.815 [info] alter table users348server # [1130152.320791] server mobilizon_ctl[536]: 13:56:01.816 [info] == Migrated 20181021161324 in 0.0s349server # [1130152.326038] server mobilizon_ctl[536]: 13:56:01.822 [info] == Running 20181108165151 Mobilizon.Repo.Migrations.FixCommentsReferences.up/0 forward350server # [1130152.326248] server mobilizon_ctl[536]: 13:56:01.822 [info] drop constraint comments_in_reply_to_comment_id_fkey from table comments351server # [1130152.327249] server mobilizon_ctl[536]: 13:56:01.823 [info] drop constraint comments_origin_comment_id_fkey from table comments352server # [1130152.327903] server mobilizon_ctl[536]: 13:56:01.824 [info] alter table comments353server # [1130152.329802] server mobilizon_ctl[536]: 13:56:01.825 [info] == Migrated 20181108165151 in 0.0s354server # [1130152.337152] server mobilizon_ctl[536]: 13:56:01.833 [info] == Running 20181203092128 Mobilizon.Repo.Migrations.ChangeActorsIndexes.up/0 forward355server # [1130152.337575] server mobilizon_ctl[536]: 13:56:01.833 [info] drop index actors_preferred_username_domain_index356server # [1130152.338690] server mobilizon_ctl[536]: 13:56:01.834 [info] drop index accounts_username_domain_index357server # [1130152.339327] server mobilizon_ctl[536]: 13:56:01.835 [info] execute "ALTER INDEX accounts_pkey RENAME TO actors_pkey"358server # [1130152.339942] server mobilizon_ctl[536]: 13:56:01.836 [info] create index actors_preferred_username_domain_type_index359server # [1130152.341563] server mobilizon_ctl[536]: 13:56:01.837 [info] create index actors_url_index360server # [1130152.342728] server mobilizon_ctl[536]: 13:56:01.838 [info] == Migrated 20181203092128 in 0.0s361server # [1130152.348825] server mobilizon_ctl[536]: 13:56:01.844 [info] == Running 20190103150805 Mobilizon.Repo.Migrations.FixEventVisibility.up/0 forward362server # [1130152.349632] server mobilizon_ctl[536]: 13:56:01.845 [info] execute "CREATE TYPE public.event_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')"363server # [1130152.350260] server mobilizon_ctl[536]: 13:56:01.846 [info] execute "CREATE TYPE public.event_status AS ENUM ('tentative', 'confirmed', 'cancelled')"364server # [1130152.350811] server mobilizon_ctl[536]: 13:56:01.846 [info] execute "CREATE TYPE public.comment_visibility AS ENUM ('public', 'unlisted', 'private', 'moderated', 'invite')"365server # [1130152.351239] server mobilizon_ctl[536]: 13:56:01.847 [info] alter table events366server # [1130152.352503] server mobilizon_ctl[536]: 13:56:01.848 [info] alter table comments367server # [1130152.353258] server mobilizon_ctl[536]: 13:56:01.849 [info] == Migrated 20190103150805 in 0.0s368server # [1130152.359370] server mobilizon_ctl[536]: 13:56:01.855 [info] == Running 20190114162055 Mobilizon.Repo.Migrations.RemoveAddressType.up/0 forward369server # [1130152.359577] server mobilizon_ctl[536]: 13:56:01.855 [info] execute "ALTER TABLE \"events\" DROP COLUMN IF EXISTS address_type"370server # [1130152.360386] server mobilizon_ctl[536]: 13:56:01.856 [info] column "address_type" of relation "events" does not exist, skipping371server # [1130152.360477] server mobilizon_ctl[536]: 13:56:01.856 [info] execute "DROP TYPE IF EXISTS address_type"372server # [1130152.360885] server mobilizon_ctl[536]: 13:56:01.856 [info] type "address_type" does not exist, skipping373server # [1130152.361104] server mobilizon_ctl[536]: 13:56:01.856 [info] rename column phone to phone_address on table events374server # [1130152.361514] server mobilizon_ctl[536]: 13:56:01.857 [info] == Migrated 20190114162055 in 0.0s375server # [1130152.364562] server mobilizon_ctl[536]: 13:56:01.860 [info] == Running 20190125143718 Mobilizon.Repo.Migrations.GroupDeleteMembersCascade.change/0 forward376server # [1130152.364970] server mobilizon_ctl[536]: 13:56:01.860 [info] drop constraint members_account_id_fkey from table members377server # [1130152.365682] server mobilizon_ctl[536]: 13:56:01.861 [info] drop constraint members_parent_id_fkey from table members378server # [1130152.366448] server mobilizon_ctl[536]: 13:56:01.862 [info] alter table members379server # [1130152.370315] server mobilizon_ctl[536]: 13:56:01.866 [info] == Migrated 20190125143718 in 0.0s380server # [1130152.384491] server mobilizon_ctl[536]: 13:56:01.880 [info] == Running 20190130151607 Mobilizon.Repo.Migrations.SplitEventVisibilityAndJoinOptions.up/0 forward381server # [1130152.384757] server mobilizon_ctl[536]: 13:56:01.880 [info] execute "ALTER TABLE events ALTER COLUMN visibility TYPE VARCHAR USING visibility::text"382server # [1130152.389124] server mobilizon_ctl[536]: 13:56:01.884 [info] execute "DROP TYPE public.event_visibility"383server # [1130152.389630] server mobilizon_ctl[536]: 13:56:01.885 [info] execute "CREATE TYPE public.event_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')"384server # [1130152.390466] server mobilizon_ctl[536]: 13:56:01.886 [info] execute "ALTER TABLE events ALTER COLUMN visibility TYPE event_visibility USING visibility::event_visibility"385server # [1130152.393439] server mobilizon_ctl[536]: 13:56:01.889 [info] execute "CREATE TYPE public.join_options AS ENUM ('free', 'restricted', 'invite', 'external')"386server # [1130152.394072] server mobilizon_ctl[536]: 13:56:01.890 [info] alter table events387server # [1130152.395015] server mobilizon_ctl[536]: 13:56:01.890 [info] execute "UPDATE events SET visibility = 'public' WHERE visibility IS NULL"388server # [1130152.395884] server mobilizon_ctl[536]: 13:56:01.891 [info] alter table events389server # [1130152.396832] server mobilizon_ctl[536]: 13:56:01.892 [info] == Migrated 20190130151607 in 0.0s390server # [1130152.410242] server mobilizon_ctl[536]: 13:56:01.906 [info] == Running 20190207134142 Mobilizon.Repo.Migrations.MoveParticipantRoleToEnum.up/0 forward391server # [1130152.410635] server mobilizon_ctl[536]: 13:56:01.906 [info] execute "CREATE TYPE public.participant_role AS ENUM ('not_approved', 'not_confirmed', 'rejected', 'participant', 'moderator', 'administrator', 'creator')"392server # [1130152.411430] server mobilizon_ctl[536]: 13:56:01.907 [info] alter table participants393server # [1130152.412542] server mobilizon_ctl[536]: 13:56:01.908 [info] execute "UPDATE participants set role_tmp = 'not_approved' where role = 0"394server # [1130152.413560] server mobilizon_ctl[536]: 13:56:01.909 [info] execute "UPDATE participants set role_tmp = 'participant' where role = 1"395server # [1130152.413887] server mobilizon_ctl[536]: 13:56:01.910 [info] execute "UPDATE participants set role_tmp = 'moderator' where role = 2"396server # [1130152.414476] server mobilizon_ctl[536]: 13:56:01.910 [info] execute "UPDATE participants set role_tmp = 'administrator' where role = 3"397server # [1130152.415173] server mobilizon_ctl[536]: 13:56:01.911 [info] execute "UPDATE participants set role_tmp = 'creator' where role = 4"398server # [1130152.415775] server mobilizon_ctl[536]: 13:56:01.911 [info] alter table participants399server # [1130152.416262] server mobilizon_ctl[536]: 13:56:01.912 [info] rename column role_tmp to role on table participants400server # [1130152.416656] server mobilizon_ctl[536]: 13:56:01.912 [info] == Migrated 20190207134142 in 0.0s401server # [1130152.422334] server mobilizon_ctl[536]: 13:56:01.918 [info] == Running 20190208141700 Mobilizon.Repo.Migrations.TagsRelations.up/0 forward402server # [1130152.422843] server mobilizon_ctl[536]: 13:56:01.918 [info] create table tag_relations403server # [1130152.425637] server mobilizon_ctl[536]: 13:56:01.921 [info] create check constraint no_self_loops_check on table tag_relations404server # [1130152.426336] server mobilizon_ctl[536]: 13:56:01.922 [info] create index index_tag_relations_tag_id405server # [1130152.428089] server mobilizon_ctl[536]: 13:56:01.924 [info] create index index_tag_relations_link_id406server # [1130152.429412] server mobilizon_ctl[536]: 13:56:01.925 [info] == Migrated 20190208141700 in 0.0s407server # [1130152.438120] server mobilizon_ctl[536]: 13:56:01.934 [info] == Running 20190214100858 Mobilizon.Repo.Migrations.DropDatetimetz.up/0 forward408server # [1130152.438356] server mobilizon_ctl[536]: 13:56:01.934 [info] alter table events409server # [1130152.439466] server mobilizon_ctl[536]: 13:56:01.935 [info] alter table sessions410server # [1130152.440209] server mobilizon_ctl[536]: 13:56:01.936 [info] execute "DROP TYPE datetimetz"411server # [1130152.441038] server mobilizon_ctl[536]: 13:56:01.936 [info] == Migrated 20190214100858 in 0.0s412server # [1130152.446334] server mobilizon_ctl[536]: #########################################################413server # [1130152.446334] server mobilizon_ctl[536]: # If the CREATE EXTENSION or DROP EXTENSION calls fail, #414server # [1130152.446334] server mobilizon_ctl[536]: # please manually execute them with an authorized #415server # [1130152.446334] server mobilizon_ctl[536]: # PostgreSQL user with SUPER USER role. #416server # [1130152.446334] server mobilizon_ctl[536]: #########################################################417server # [1130152.446334] server mobilizon_ctl[536]:418server # [1130152.446334] server mobilizon_ctl[536]:419server # [1130152.446334] server mobilizon_ctl[536]: 13:56:01.942 [info] == Running 20190219164310 Mobilizon.Repo.Migrations.CreateSearchIndexes.change/0 forward420server # [1130152.446845] server mobilizon_ctl[536]: 13:56:01.942 [info] execute "CREATE EXTENSION IF NOT EXISTS pg_trgm"421server # [1130152.447351] server mobilizon_ctl[536]: 13:56:01.943 [info] extension "pg_trgm" already exists, skipping422server # [1130152.447439] server mobilizon_ctl[536]: 13:56:01.943 [info] execute "CREATE EXTENSION IF NOT EXISTS unaccent"423server # [1130152.447767] server mobilizon_ctl[536]: 13:56:01.943 [info] extension "unaccent" already exists, skipping424server # [1130152.447911] server mobilizon_ctl[536]: 13:56:01.943 [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 # [1130152.448764] server mobilizon_ctl[536]: 13:56:01.944 [info] execute "CREATE INDEX \"event_title_trigram\" ON \"events\" USING GIN (f_unaccent(title) gin_trgm_ops)"426server # [1130152.450625] server mobilizon_ctl[536]: 13:56:01.946 [info] execute "CREATE INDEX \"actor_preferred_username_trigram\" ON \"actors\"\n USING GIN (f_unaccent(preferred_username) gin_trgm_ops)"427server # [1130152.451595] server mobilizon_ctl[536]: 13:56:01.947 [info] execute "CREATE INDEX \"actor_name_trigram\" ON \"actors\"\n USING GIN (f_unaccent(name) gin_trgm_ops)"428server # [1130152.452605] server mobilizon_ctl[536]: 13:56:01.948 [info] == Migrated 20190219164310 in 0.0s429server # [1130152.457731] server mobilizon_ctl[536]: 13:56:01.953 [info] == Running 20190222151449 Mobilizon.Repo.Migrations.DropCategories.up/0 forward430server # [1130152.457951] server mobilizon_ctl[536]: 13:56:01.954 [info] alter table events431server # [1130152.459080] server mobilizon_ctl[536]: 13:56:01.955 [info] drop table categories432server # [1130152.460277] server mobilizon_ctl[536]: 13:56:01.956 [info] == Migrated 20190222151449 in 0.0s433server # [1130152.476625] server mobilizon_ctl[536]: 13:56:01.972 [info] == Running 20190301141830 Mobilizon.Repo.Migrations.MoveMemberRoleToEnum.up/0 forward434server # [1130152.477142] server mobilizon_ctl[536]: 13:56:01.973 [info] execute "CREATE TYPE public.member_role AS ENUM ('invited', 'not_approved', 'member', 'moderator', 'administrator', 'creator', 'rejected')"435server # [1130152.477947] server mobilizon_ctl[536]: 13:56:01.973 [info] alter table members436server # [1130152.478429] server mobilizon_ctl[536]: 13:56:01.974 [info] execute "UPDATE members set role_tmp = 'member' where role = 0"437server # [1130152.479117] server mobilizon_ctl[536]: 13:56:01.975 [info] execute "UPDATE members set role_tmp = 'moderator' where role = 1"438server # [1130152.479979] server mobilizon_ctl[536]: 13:56:01.976 [info] execute "UPDATE members set role_tmp = 'creator' where role = 2"439server # [1130152.480356] server mobilizon_ctl[536]: 13:56:01.976 [info] execute "UPDATE members set role_tmp = 'not_approved' where approved is false"440server # [1130152.480673] server mobilizon_ctl[536]: 13:56:01.976 [info] alter table members441server # [1130152.481287] server mobilizon_ctl[536]: 13:56:01.977 [info] rename column role_tmp to role on table members442server # [1130152.481714] server mobilizon_ctl[536]: 13:56:01.977 [info] == Migrated 20190301141830 in 0.0s443server # [1130152.484256] server mobilizon_ctl[536]: 13:56:01.980 [info] == Running 20190301143831 Mobilizon.Repo.Migrations.ActorGroupOpenness.up/0 forward444server # [1130152.486966] server mobilizon_ctl[536]: 13:56:01.982 [info] execute "CREATE TYPE public.actor_openness AS ENUM ('invite_only', 'moderated', 'open')"445server # [1130152.487653] server mobilizon_ctl[536]: 13:56:01.983 [info] alter table actors446server # [1130152.488684] server mobilizon_ctl[536]: 13:56:01.984 [info] == Migrated 20190301143831 in 0.0s447server # [1130152.495190] server mobilizon_ctl[536]: 13:56:01.991 [info] == Running 20190307125009 Mobilizon.Repo.Migrations.MoveUserRoleToEnum.up/0 forward448server # [1130152.495393] server mobilizon_ctl[536]: 13:56:01.991 [info] execute "CREATE TYPE public.user_role AS ENUM ('administrator', 'moderator', 'user', 'pending')"449server # [1130152.496525] server mobilizon_ctl[536]: 13:56:01.992 [info] alter table users450server # [1130152.498060] server mobilizon_ctl[536]: 13:56:01.994 [info] execute "UPDATE users set role_tmp = 'user' where role = 0"451server # [1130152.499165] server mobilizon_ctl[536]: 13:56:01.995 [info] execute "UPDATE users set role_tmp = 'moderator' where role = 1"452server # [1130152.499819] server mobilizon_ctl[536]: 13:56:01.995 [info] execute "UPDATE users set role_tmp = 'administrator' where role = 2"453server # [1130152.500586] server mobilizon_ctl[536]: 13:56:01.996 [info] alter table users454server # [1130152.501511] server mobilizon_ctl[536]: 13:56:01.997 [info] rename column role_tmp to role on table users455server # [1130152.501951] server mobilizon_ctl[536]: 13:56:01.997 [info] == Migrated 20190307125009 in 0.0s456server # [1130152.509267] server mobilizon_ctl[536]: 13:56:02.005 [info] == Running 20190307133518 Mobilizon.Repo.Migrations.FeedTokenTable.change/0 forward457server # [1130152.516598] server mobilizon_ctl[536]: 13:56:02.012 [info] create table feed_tokens458server # [1130152.521389] server mobilizon_ctl[536]: 13:56:02.017 [info] == Migrated 20190307133518 in 0.0s459server # [1130152.529015] server mobilizon_ctl[536]: 13:56:02.025 [info] == Running 20190322143724 Mobilizon.Repo.Migrations.RenameAddressFields.change/0 forward460server # [1130152.529211] server mobilizon_ctl[536]: 13:56:02.025 [info] rename column addressCountry to country on table addresses461server # [1130152.529719] server mobilizon_ctl[536]: 13:56:02.025 [info] rename column addressLocality to locality on table addresses462server # [1130152.530262] server mobilizon_ctl[536]: 13:56:02.026 [info] rename column addressRegion to region on table addresses463server # [1130152.530903] server mobilizon_ctl[536]: 13:56:02.026 [info] rename column postalCode to postal_code on table addresses464server # [1130152.531345] server mobilizon_ctl[536]: 13:56:02.027 [info] rename column streetAddress to street on table addresses465server # [1130152.531906] server mobilizon_ctl[536]: 13:56:02.027 [info] == Migrated 20190322143724 in 0.0s466server # [1130152.536022] server mobilizon_ctl[536]: 13:56:02.031 [info] == Running 20190411124138 Mobilizon.Repo.Migrations.EventAddDescriptionSlug.change/0 forward467server # [1130152.536261] server mobilizon_ctl[536]: 13:56:02.032 [info] alter table events468server # [1130152.537032] server mobilizon_ctl[536]: 13:56:02.032 [info] == Migrated 20190411124138 in 0.0s469server # [1130152.542635] server mobilizon_ctl[536]: 13:56:02.038 [info] == Running 20190411161557 Mobilizon.Repo.Migrations.EventEventTagOnDelete.up/0 forward470server # [1130152.542812] server mobilizon_ctl[536]: 13:56:02.038 [info] drop constraint events_tags_event_id_fkey from table events_tags471server # [1130152.543558] server mobilizon_ctl[536]: 13:56:02.039 [info] drop constraint events_tags_tag_id_fkey from table events_tags472server # [1130152.544164] server mobilizon_ctl[536]: 13:56:02.040 [info] alter table events_tags473server # [1130152.546855] server mobilizon_ctl[536]: 13:56:02.042 [info] == Migrated 20190411161557 in 0.0s474server # [1130152.552890] server mobilizon_ctl[536]: 13:56:02.048 [info] == Running 20190425075451 Mobilizon.Repo.Migrations.AddVisibilityToActor.up/0 forward475server # [1130152.553155] server mobilizon_ctl[536]: 13:56:02.049 [info] execute "CREATE TYPE public.actor_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')"476server # [1130152.553987] server mobilizon_ctl[536]: 13:56:02.050 [info] alter table actors477server # [1130152.555019] server mobilizon_ctl[536]: 13:56:02.051 [info] == Migrated 20190425075451 in 0.0s478server # [1130152.561058] server mobilizon_ctl[536]: 13:56:02.057 [info] == Running 20190426093202 Mobilizon.Repo.Migrations.CreatePictures.up/0 forward479server # [1130152.561766] server mobilizon_ctl[536]: 13:56:02.057 [info] create table pictures480server # [1130152.565127] server mobilizon_ctl[536]: 13:56:02.061 [info] alter table actors481server # [1130152.566177] server mobilizon_ctl[536]: 13:56:02.062 [info] alter table events482server # [1130152.568167] server mobilizon_ctl[536]: 13:56:02.064 [info] == Migrated 20190426093202 in 0.0s483server # [1130152.576302] server mobilizon_ctl[536]: 13:56:02.072 [info] == Running 20190531131458 :"Elixir.Mobilizon.Repo.Migrations.Attach-pictures-to-actors".change/0 forward484server # [1130152.576531] server mobilizon_ctl[536]: 13:56:02.072 [info] alter table pictures485server # [1130152.579720] server mobilizon_ctl[536]: 13:56:02.075 [info] == Migrated 20190531131458 in 0.0s486server # [1130152.585680] server mobilizon_ctl[536]: 13:56:02.081 [info] == Running 20190712125833 Mobilizon.Repo.Migrations.CreateReports.up/0 forward487server # [1130152.589506] server mobilizon_ctl[536]: 13:56:02.085 [info] execute "CREATE TYPE public.report_status AS ENUM ('open', 'closed', 'resolved')"488server # [1130152.590379] server mobilizon_ctl[536]: 13:56:02.086 [info] create table reports489server # [1130152.595685] server mobilizon_ctl[536]: 13:56:02.091 [info] create table reports_comments490server # [1130152.597669] server mobilizon_ctl[536]: 13:56:02.093 [info] == Migrated 20190712125833 in 0.0s491server # [1130152.607727] server mobilizon_ctl[536]: 13:56:02.103 [info] == Running 20190712132438 Mobilizon.Repo.Migrations.CreateReportNotes.change/0 forward492server # [1130152.608064] server mobilizon_ctl[536]: 13:56:02.104 [info] create table report_notes493server # [1130152.611972] server mobilizon_ctl[536]: 13:56:02.107 [info] == Migrated 20190712132438 in 0.0s494server # [1130152.621520] server mobilizon_ctl[536]: 13:56:02.117 [info] == Running 20190718122556 Mobilizon.Repo.Migrations.CreateAdminActionLogs.change/0 forward495server # [1130152.621940] server mobilizon_ctl[536]: 13:56:02.117 [info] create table admin_action_logs496server # [1130152.626142] server mobilizon_ctl[536]: 13:56:02.122 [info] == Migrated 20190718122556 in 0.0s497server # [1130152.633356] server mobilizon_ctl[536]: 13:56:02.129 [info] == Running 20190729125532 :"Elixir.Mobilizon.Repo.Migrations.Add-url-to-addresses".change/0 forward498server # [1130152.633604] server mobilizon_ctl[536]: 13:56:02.129 [info] alter table addresses499server # [1130152.634702] server mobilizon_ctl[536]: 13:56:02.130 [info] == Migrated 20190729125532 in 0.0s500server # [1130152.659205] server mobilizon_ctl[536]: 13:56:02.155 [info] == Running 20190806131306 Mobilizon.Repo.Migrations.AddUrlToFollowsAndMoveToUuid.up/0 forward501server # [1130152.659419] server mobilizon_ctl[536]: 13:56:02.155 [info] alter table followers502server # [1130152.662643] server mobilizon_ctl[536]: 13:56:02.158 [info] == Migrated 20190806131306 in 0.0s503server # [1130152.669642] server mobilizon_ctl[536]: 13:56:02.165 [info] == Running 20190813160207 Mobilizon.Repo.Migrations.AddUrlAndUuidToParticipants.up/0 forward504server # [1130152.670100] server mobilizon_ctl[536]: 13:56:02.166 [info] drop index participants_event_id_index505server # [1130152.670867] server mobilizon_ctl[536]: 13:56:02.166 [info] drop index if exists participants_account_id_index506server # [1130152.671329] server mobilizon_ctl[536]: 13:56:02.167 [info] drop index if exists participants_actor_id_index507server # [1130152.671974] server mobilizon_ctl[536]: 13:56:02.167 [info] index "participants_actor_id_index" does not exist, skipping508server # [1130152.672139] server mobilizon_ctl[536]: 13:56:02.168 [info] drop constraint participants_event_id_fkey from table participants509server # [1130152.673320] server mobilizon_ctl[536]: 13:56:02.169 [info] drop constraint if exists participants_account_id_fkey from table participants510server # [1130152.674180] server mobilizon_ctl[536]: 13:56:02.170 [info] drop constraint if exists participants_actor_id_fkey from table participants511server # [1130152.674618] server mobilizon_ctl[536]: 13:56:02.170 [info] constraint "participants_actor_id_fkey" of relation "participants" does not exist, skipping512server # [1130152.674618] server mobilizon_ctl[536]: 13:56:02.170 [info] drop constraint participants_pkey from table participants513server # [1130152.675558] server mobilizon_ctl[536]: 13:56:02.171 [info] alter table participants514server # [1130152.679056] server mobilizon_ctl[536]: 13:56:02.175 [info] create index participants_event_id_index515server # [1130152.679885] server mobilizon_ctl[536]: 13:56:02.175 [info] create index participants_actor_id_index516server # [1130152.680848] server mobilizon_ctl[536]: 13:56:02.176 [info] == Migrated 20190813160207 in 0.0s517server # [1130152.691091] server mobilizon_ctl[536]: 13:56:02.187 [info] == Running 20190821161658 Mobilizon.Repo.Migrations.AddOriginIdToAddresses.change/0 forward518server # [1130152.691389] server mobilizon_ctl[536]: 13:56:02.187 [info] alter table addresses519server # [1130152.692354] server mobilizon_ctl[536]: 13:56:02.188 [info] create index addresses_origin_id_index520server # [1130152.693514] server mobilizon_ctl[536]: 13:56:02.189 [info] == Migrated 20190821161658 in 0.0s521server # [1130152.696400] server mobilizon_ctl[536]: 13:56:02.192 [info] == Running 20190823132816 Mobilizon.Repo.Migrations.RemoveEventsWhenDeletingOrganizer.up/0 forward522server # [1130152.696600] server mobilizon_ctl[536]: 13:56:02.192 [info] drop constraint events_organizer_account_id_fkey from table events523server # [1130152.697551] server mobilizon_ctl[536]: 13:56:02.193 [info] alter table events524server # [1130152.699886] server mobilizon_ctl[536]: 13:56:02.195 [info] == Migrated 20190823132816 in 0.0s525server # [1130152.707099] server mobilizon_ctl[536]: 13:56:02.203 [info] == Running 20190902082656 Mobilizon.Repo.Migrations.AddOptionsToEvent.change/0 forward526server # [1130152.707295] server mobilizon_ctl[536]: 13:56:02.203 [info] alter table events527server # [1130152.707960] server mobilizon_ctl[536]: 13:56:02.203 [info] == Migrated 20190902082656 in 0.0s528server # [1130152.715591] server mobilizon_ctl[536]: 13:56:02.211 [info] == Running 20190929170817 Mobilizon.Storage.Repo.Migrations.RenamePostgresTypes.up/0 forward529server # [1130152.718879] server mobilizon_ctl[536]: 13:56:02.214 [info] == Migrated 20190929170817 in 0.0s530server # [1130152.730547] server mobilizon_ctl[536]: 13:56:02.226 [info] == Running 20190929175229 Mobilizon.Storage.Repo.Migrations.AddRejectedToParticipantRole.up/0 forward531server # [1130152.730547] server mobilizon_ctl[536]: 13:56:02.226 [info] execute "ALTER TYPE public.participant_role ADD VALUE IF NOT EXISTS 'rejected'"532server # [1130152.731508] server mobilizon_ctl[536]: 13:56:02.227 [info] enum label "rejected" already exists, skipping533server # [1130152.731893] server mobilizon_ctl[536]: 13:56:02.227 [info] == Migrated 20190929175229 in 0.0s534server # [1130152.734651] server mobilizon_ctl[536]: 13:56:02.230 [info] == Running 20191001074442 Mobilizon.Storage.Repo.Migrations.AddLocaleToUsers.change/0 forward535server # [1130152.734900] server mobilizon_ctl[536]: 13:56:02.230 [info] alter table users536server # [1130152.735779] server mobilizon_ctl[536]: 13:56:02.231 [info] == Migrated 20191001074442 in 0.0s537server # [1130152.741629] server mobilizon_ctl[536]: 13:56:02.237 [info] == Running 20191002093208 Mobilizon.Storage.Repo.Migrations.AddDraftFlagToEvents.change/0 forward538server # [1130152.741629] server mobilizon_ctl[536]: 13:56:02.237 [info] alter table events539server # [1130152.742773] server mobilizon_ctl[536]: 13:56:02.238 [info] == Migrated 20191002093208 in 0.0s540server # [1130152.750234] server mobilizon_ctl[536]: 13:56:02.246 [info] == Running 20191018075904 Mobilizon.Storage.Repo.Migrations.MoveSQLColumnsFromVarCharToText.up/0 forward541server # [1130152.750439] server mobilizon_ctl[536]: 13:56:02.246 [info] alter table events542server # [1130152.753460] server mobilizon_ctl[536]: 13:56:02.249 [info] alter table addresses543server # [1130152.754083] server mobilizon_ctl[536]: 13:56:02.250 [info] alter table bots544server # [1130152.754681] server mobilizon_ctl[536]: 13:56:02.250 [info] alter table report_notes545server # [1130152.756085] server mobilizon_ctl[536]: 13:56:02.251 [info] alter table reports546server # [1130152.756567] server mobilizon_ctl[536]: 13:56:02.252 [info] alter table sessions547server # [1130152.757342] server mobilizon_ctl[536]: 13:56:02.253 [info] alter table tracks548server # [1130152.757866] server mobilizon_ctl[536]: 13:56:02.253 [info] == Migrated 20191018075904 in 0.0s549server # [1130152.762166] server mobilizon_ctl[536]: 13:56:02.258 [info] == Running 20191022083446 Mobilizon.Storage.Repo.Migrations.AddEagerMaterializedViewForSearchingEvents.up/0 forward550server # [1130152.762634] server mobilizon_ctl[536]: 13:56:02.258 [info] create table event_search551server # [1130152.766153] server mobilizon_ctl[536]: 13:56:02.262 [info] create index event_search_document_index552server # [1130152.767089] server mobilizon_ctl[536]: 13:56:02.263 [info] execute "CREATE INDEX event_search_title_trgm_index ON event_search USING gin (title gin_trgm_ops)"553server # [1130152.767851] server mobilizon_ctl[536]: 13:56:02.263 [info] create index event_search_id_index554server # [1130152.768790] server mobilizon_ctl[536]: 13:56:02.264 [info] == Migrated 20191022083446 in 0.0s555server # [1130152.781264] server mobilizon_ctl[536]: 13:56:02.277 [info] == Running 20191023133805 Mobilizon.Storage.Repo.Migrations.DeleteActorsCascadeToFollowers.up/0 forward556server # [1130152.782161] server mobilizon_ctl[536]: 13:56:02.277 [info] drop constraint followers_actor_id_fkey from table followers557server # [1130152.783142] server mobilizon_ctl[536]: 13:56:02.279 [info] drop constraint followers_target_actor_id_fkey from table followers558server # [1130152.783799] server mobilizon_ctl[536]: 13:56:02.279 [info] alter table followers559server # [1130152.786266] server mobilizon_ctl[536]: 13:56:02.282 [info] == Migrated 20191023133805 in 0.0s560server # [1130152.797573] server mobilizon_ctl[536]: 13:56:02.293 [info] == Running 20191023143659 Mobilizon.Storage.Repo.Migrations.MoveParticipantsStatsToEvent.up/0 forward561server # [1130152.798194] server mobilizon_ctl[536]: 13:56:02.293 [info] alter table events562server # [1130152.798951] server mobilizon_ctl[536]: 13:56:02.294 [info] == Migrated 20191023143659 in 0.0s563server # [1130152.802133] server mobilizon_ctl[536]: 13:56:02.298 [info] == Running 20191024204726 Mobilizon.Storage.Repo.Migrations.AddTagsToComments.up/0 forward564server # [1130152.802443] server mobilizon_ctl[536]: 13:56:02.298 [info] create table comments_tags565server # [1130152.805753] server mobilizon_ctl[536]: 13:56:02.301 [info] == Migrated 20191024204726 in 0.0s566server # [1130152.813956] server mobilizon_ctl[536]: 13:56:02.309 [info] == Running 20191025083642 Mobilizon.Storage.Repo.Migrations.AddMentionTables.change/0 forward567server # [1130152.814443] server mobilizon_ctl[536]: 13:56:02.310 [info] create table mentions568server # [1130152.818669] server mobilizon_ctl[536]: 13:56:02.314 [info] create index mentions_actor_id_index569server # [1130152.819822] server mobilizon_ctl[536]: 13:56:02.315 [info] == Migrated 20191025083642 in 0.0s570server # [1130152.828218] server mobilizon_ctl[536]: 13:56:02.324 [info] == Running 20191025115537 Mobilizon.Storage.Repo.Migrations.AddUniqueIndexOnURLs.change/0 forward571server # [1130152.828480] server mobilizon_ctl[536]: 13:56:02.324 [info] create index events_url_index572server # [1130152.829901] server mobilizon_ctl[536]: 13:56:02.326 [info] create index comments_url_index573server # [1130152.831133] server mobilizon_ctl[536]: 13:56:02.327 [info] == Migrated 20191025115537 in 0.0s574server # [1130152.836978] server mobilizon_ctl[536]: 13:56:02.332 [info] == Running 20191031142145 Mobilizon.Storage.Repo.Migrations.AddUniqueIndexOnActorAndEventForParticipant.change/0 forward575server # [1130152.837111] server mobilizon_ctl[536]: 13:56:02.333 [info] create index participants_event_id_actor_id_index576server # [1130152.838675] server mobilizon_ctl[536]: 13:56:02.334 [info] == Migrated 20191031142145 in 0.0s577server # [1130152.841863] server mobilizon_ctl[536]: 13:56:02.337 [info] == Running 20191104093447 Mobilizon.Storage.Repo.Migrations.AddObanJobsTable.up/0 forward578server # [1130152.881298] server mobilizon_ctl[536]: 13:56:02.377 [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 # [1130152.884091] server mobilizon_ctl[536]: 13:56:02.380 [info] create table if not exists public.oban_jobs580server # [1130152.887460] server mobilizon_ctl[536]: 13:56:02.383 [info] create index if not exists public.oban_jobs_queue_index581server # [1130152.888772] server mobilizon_ctl[536]: 13:56:02.384 [info] create index if not exists public.oban_jobs_state_index582server # [1130152.889552] server mobilizon_ctl[536]: 13:56:02.385 [info] create index if not exists public.oban_jobs_scheduled_at_index583server # [1130152.890609] server mobilizon_ctl[536]: 13:56:02.386 [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 # [1130152.891559] server mobilizon_ctl[536]: 13:56:02.387 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs"585server # [1130152.892024] server mobilizon_ctl[536]: 13:56:02.388 [info] trigger "oban_notify" for relation "public.oban_jobs" does not exist, skipping586server # [1130152.892086] server mobilizon_ctl[536]: 13:56:02.388 [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 # [1130152.893020] server mobilizon_ctl[536]: 13:56:02.389 [info] drop index if exists public.oban_jobs_scheduled_at_index588server # [1130152.893594] server mobilizon_ctl[536]: 13:56:02.389 [info] create index public.oban_jobs_scheduled_at_index589server # [1130152.895107] server mobilizon_ctl[536]: 13:56:02.391 [info] create check constraint worker_length on table public.oban_jobs590server # [1130152.895858] server mobilizon_ctl[536]: 13:56:02.391 [info] create check constraint queue_length on table public.oban_jobs591server # [1130152.896379] server mobilizon_ctl[536]: 13:56:02.392 [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 # [1130152.896998] server mobilizon_ctl[536]: 13:56:02.393 [info] alter table public.oban_jobs593server # [1130152.897358] server mobilizon_ctl[536]: 13:56:02.393 [info] execute "DROP FUNCTION IF EXISTS \"public\".oban_wrap_id(value bigint)"594server # [1130152.897750] server mobilizon_ctl[536]: 13:56:02.393 [info] drop index if exists public.oban_jobs_scheduled_at_index595server # [1130152.897995] server mobilizon_ctl[536]: 13:56:02.394 [info] drop index if exists public.oban_jobs_queue_index596server # [1130152.898346] server mobilizon_ctl[536]: 13:56:02.394 [info] drop index if exists public.oban_jobs_state_index597server # [1130152.898536] server mobilizon_ctl[536]: 13:56:02.394 [info] create index if not exists public.oban_jobs_queue_state_scheduled_at_id_index598server # [1130152.899589] server mobilizon_ctl[536]: 13:56:02.395 [info] create index if not exists public.oban_jobs_attempted_at_id_index599server # [1130152.900555] server mobilizon_ctl[536]: 13:56:02.396 [info] alter table public.oban_jobs600server # [1130152.901239] server mobilizon_ctl[536]: 13:56:02.397 [info] alter table public.oban_jobs601server # [1130152.901992] server mobilizon_ctl[536]: 13:56:02.398 [info] drop index if exists public.oban_jobs_queue_state_scheduled_at_id_index602server # [1130152.902416] server mobilizon_ctl[536]: 13:56:02.398 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index603server # [1130152.903874] server mobilizon_ctl[536]: 13:56:02.399 [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 # [1130152.904486] server mobilizon_ctl[536]: 13:56:02.400 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs"605server # [1130152.904907] server mobilizon_ctl[536]: 13:56:02.401 [info] execute "CREATE TRIGGER oban_notify\nAFTER INSERT ON \"public\".oban_jobs\nFOR EACH ROW EXECUTE PROCEDURE \"public\".oban_jobs_notify();\n"606server # [1130152.905391] server mobilizon_ctl[536]: 13:56:02.401 [info] alter table public.oban_jobs607server # [1130152.918319] server mobilizon_ctl[536]: 13:56:02.413 [info] execute "ALTER TYPE \"public\".oban_job_state ADD VALUE IF NOT EXISTS 'cancelled'"608server # [1130152.918680] server mobilizon_ctl[536]: 13:56:02.414 [info] enum label "cancelled" already exists, skipping609server # [1130152.918875] server mobilizon_ctl[536]: 13:56:02.414 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index610server # [1130152.919458] server mobilizon_ctl[536]: 13:56:02.415 [info] relation "oban_jobs_state_queue_priority_scheduled_at_id_index" already exists, skipping611server # [1130152.919638] server mobilizon_ctl[536]: 13:56:02.415 [info] alter table public.oban_jobs612server # [1130152.921897] server mobilizon_ctl[536]: 13:56:02.417 [info] create check constraint priority_range on table public.oban_jobs613server # [1130152.922499] server mobilizon_ctl[536]: 13:56:02.418 [info] create check constraint positive_max_attempts on table public.oban_jobs614server # [1130152.923092] server mobilizon_ctl[536]: 13:56:02.419 [info] create check constraint attempt_range on table public.oban_jobs615server # [1130152.923963] server mobilizon_ctl[536]: 13:56:02.420 [info] drop index if exists public.oban_jobs_args_vector616server # [1130152.924429] server mobilizon_ctl[536]: 13:56:02.420 [info] index "oban_jobs_args_vector" does not exist, skipping617server # [1130152.924429] server mobilizon_ctl[536]: 13:56:02.420 [info] drop index if exists public.oban_jobs_worker_gist618server # [1130152.924823] server mobilizon_ctl[536]: 13:56:02.420 [info] index "oban_jobs_worker_gist" does not exist, skipping619server # [1130152.924823] server mobilizon_ctl[536]: 13:56:02.420 [info] drop index if exists public.oban_jobs_attempted_at_id_index620server # [1130152.925461] server mobilizon_ctl[536]: 13:56:02.421 [info] create index if not exists public.oban_jobs_args_index621server # [1130152.926496] server mobilizon_ctl[536]: 13:56:02.422 [info] create index if not exists public.oban_jobs_meta_index622server # [1130152.927490] server mobilizon_ctl[536]: 13:56:02.423 [info] create table if not exists public.oban_peers623server # [1130152.930161] server mobilizon_ctl[536]: 13:56:02.426 [info] execute "ALTER TABLE \"public\".oban_peers SET UNLOGGED"624server # [1130152.932594] server mobilizon_ctl[536]: 13:56:02.428 [info] drop constraint priority_range from table public.oban_jobs625server # [1130152.933263] server mobilizon_ctl[536]: 13:56:02.429 [info] create check constraint non_negative_priority on table public.oban_jobs626server # [1130152.933919] server mobilizon_ctl[536]: 13:56:02.430 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs"627server # [1130152.934433] server mobilizon_ctl[536]: 13:56:02.430 [info] execute "DROP FUNCTION IF EXISTS \"public\".oban_jobs_notify()"628server # [1130152.934767] server mobilizon_ctl[536]: 13:56:02.430 [info] create index if not exists public.oban_jobs_state_cancelled_at_index629server # [1130152.935663] server mobilizon_ctl[536]: 13:56:02.431 [info] create index if not exists public.oban_jobs_state_discarded_at_index630server # [1130152.936553] server mobilizon_ctl[536]: 13:56:02.432 [info] execute "ALTER TYPE \"public\".oban_job_state ADD VALUE IF NOT EXISTS 'suspended' BEFORE 'scheduled'\n"631server # [1130152.937188] server mobilizon_ctl[536]: 13:56:02.433 [info] enum label "suspended" already exists, skipping632server # [1130152.937316] server mobilizon_ctl[536]: 13:56:02.433 [info] execute "COMMENT ON TABLE \"public\".oban_jobs IS '14'"633server # [1130152.937860] server mobilizon_ctl[536]: 13:56:02.433 [info] == Migrated 20191104093447 in 0.0s634server # [1130152.961155] server mobilizon_ctl[536]: 13:56:02.457 [info] == Running 20191106114524 Mobilizon.Storage.Repo.Migrations.RemoveFloorFromAddresses.up/0 forward635server # [1130152.961349] server mobilizon_ctl[536]: 13:56:02.457 [info] alter table addresses636server # [1130152.962314] server mobilizon_ctl[536]: 13:56:02.458 [info] == Migrated 20191106114524 in 0.0s637server # [1130152.971382] server mobilizon_ctl[536]: 13:56:02.467 [info] == Running 20191106141051 Mobilizon.Storage.Repo.Migrations.AddTypeToAddresses.change/0 forward638server # [1130152.971560] server mobilizon_ctl[536]: 13:56:02.467 [info] alter table addresses639server # [1130152.972374] server mobilizon_ctl[536]: 13:56:02.468 [info] == Migrated 20191106141051 in 0.0s640server # [1130152.978696] server mobilizon_ctl[536]: 13:56:02.474 [info] == Running 20191114155534 Mobilizon.Storage.Repo.Migrations.CascadeCommentDeletion.up/0 forward641server # [1130152.979020] server mobilizon_ctl[536]: 13:56:02.475 [info] drop constraint comments_in_reply_to_comment_id_fkey from table comments642server # [1130152.980058] server mobilizon_ctl[536]: 13:56:02.476 [info] drop constraint comments_origin_comment_id_fkey from table comments643server # [1130152.980844] server mobilizon_ctl[536]: 13:56:02.476 [info] alter table comments644server # [1130152.983252] server mobilizon_ctl[536]: 13:56:02.479 [info] == Migrated 20191114155534 in 0.0s645server # [1130152.990536] server mobilizon_ctl[536]: 13:56:02.486 [info] == Running 20191122154018 Mobilizon.Storage.Repo.Migrations.AddDeletedAtOnComments.up/0 forward646server # [1130152.990719] server mobilizon_ctl[536]: 13:56:02.486 [info] drop constraint if exists comments_actor_id_fkey from table comments647server # [1130152.991432] server mobilizon_ctl[536]: 13:56:02.487 [info] constraint "comments_actor_id_fkey" of relation "comments" does not exist, skipping648server # [1130152.991432] server mobilizon_ctl[536]: 13:56:02.487 [info] alter table comments649server # [1130152.994576] server mobilizon_ctl[536]: 13:56:02.490 [info] == Migrated 20191122154018 in 0.0s650server # [1130153.000840] server mobilizon_ctl[536]: 13:56:02.496 [info] == Running 20191126173510 Mobilizon.Storage.Repo.Migrations.AddLocalFieldToReports.up/0 forward651server # [1130153.001076] server mobilizon_ctl[536]: 13:56:02.497 [info] alter table reports652server # [1130153.001951] server mobilizon_ctl[536]: 13:56:02.498 [info] rename column uri to url on table reports653server # [1130153.002475] server mobilizon_ctl[536]: 13:56:02.498 [info] == Migrated 20191126173510 in 0.0s654server # [1130153.007635] server mobilizon_ctl[536]: 13:56:02.503 [info] == Running 20191127163737 Mobilizon.Repo.Migrations.CreateTombstones.change/0 forward655server # [1130153.008046] server mobilizon_ctl[536]: 13:56:02.504 [info] create table tombstones656server # [1130153.011431] server mobilizon_ctl[536]: 13:56:02.507 [info] create index tombstones_uri_index657server # [1130153.012770] server mobilizon_ctl[536]: 13:56:02.508 [info] == Migrated 20191127163737 in 0.0s658server # [1130153.022201] server mobilizon_ctl[536]: 13:56:02.518 [info] == Running 20191129091227 Mobilizon.Storage.Repo.Migrations.AddTimestampsToFollowers.change/0 forward659server # [1130153.022409] server mobilizon_ctl[536]: 13:56:02.518 [info] alter table followers660server # [1130153.023669] server mobilizon_ctl[536]: 13:56:02.519 [info] == Migrated 20191129091227 in 0.0s661server # [1130153.027010] server mobilizon_ctl[536]: 13:56:02.523 [info] == Running 20191204164224 Mobilizon.Storage.Repo.Migrations.DeleteEventCascadeToComments.up/0 forward662server # [1130153.027010] server mobilizon_ctl[536]: 13:56:02.523 [info] drop constraint if exists comments_event_id_fkey from table comments663server # [1130153.027998] server mobilizon_ctl[536]: 13:56:02.524 [info] alter table comments664server # [1130153.029817] server mobilizon_ctl[536]: 13:56:02.525 [info] == Migrated 20191204164224 in 0.0s665server # [1130153.043255] server mobilizon_ctl[536]: 13:56:02.539 [info] == Running 20191206144028 Mobilizon.Repo.Migrations.CreateShares.up/0 forward666server # [1130153.043473] server mobilizon_ctl[536]: 13:56:02.539 [info] create table shares667server # [1130153.047387] server mobilizon_ctl[536]: 13:56:02.543 [info] create index if not exists shares_uri_actor_id_index668server # [1130153.048363] server mobilizon_ctl[536]: 13:56:02.544 [info] == Migrated 20191206144028 in 0.0s669server # [1130153.056834] server mobilizon_ctl[536]: 13:56:02.552 [info] == Running 20191219172017 Mobilizon.Storage.Repo.Migrations.AddMetadataToParticipant.up/0 forward670server # [1130153.057218] server mobilizon_ctl[536]: 13:56:02.553 [info] drop index if exists participants_event_id_actor_id_index671server # [1130153.057890] server mobilizon_ctl[536]: 13:56:02.553 [info] alter table participants672server # [1130153.059464] server mobilizon_ctl[536]: 13:56:02.555 [info] execute "CREATE UNIQUE INDEX participants_metadata_confirmation_token_index ON participants((metadata->>'confirmation_token'))"673server # [1130153.060878] server mobilizon_ctl[536]: 13:56:02.556 [info] == Migrated 20191219172017 in 0.0s674server # [1130153.067249] server mobilizon_ctl[536]: 13:56:02.563 [info] == Running 20191223173537 Mobilizon.Storage.Repo.Migrations.AddNotConfirmedStatusToParticipants.up/0 forward675server # [1130153.067380] server mobilizon_ctl[536]: 13:56:02.563 [info] execute "ALTER TYPE participant_role ADD VALUE IF NOT EXISTS 'not_confirmed'"676server # [1130153.068345] server mobilizon_ctl[536]: 13:56:02.564 [info] enum label "not_confirmed" already exists, skipping677server # [1130153.068656] server mobilizon_ctl[536]: 13:56:02.564 [info] == Migrated 20191223173537 in 0.0s678server # [1130153.071908] server mobilizon_ctl[536]: 13:56:02.568 [info] == Running 20200116095117 Mobilizon.Repo.Migrations.CreateAdminSettings.change/0 forward679server # [1130153.072290] server mobilizon_ctl[536]: 13:56:02.568 [info] create table admin_settings680server # [1130153.075434] server mobilizon_ctl[536]: 13:56:02.571 [info] create index admin_settings_group_name_index681server # [1130153.076657] server mobilizon_ctl[536]: 13:56:02.572 [info] == Migrated 20200116095117 in 0.0s682server # [1130153.087027] server mobilizon_ctl[536]: 13:56:02.583 [info] == Running 20200210100910 Mobilizon.Storage.Repo.Migrations.AddUnconfirmedEmailToUsersTable.change/0 forward683server # [1130153.087435] server mobilizon_ctl[536]: 13:56:02.583 [info] alter table users684server # [1130153.088438] server mobilizon_ctl[536]: 13:56:02.584 [info] == Migrated 20200210100910 in 0.0s685server # [1130153.094840] server mobilizon_ctl[536]: 13:56:02.590 [info] == Running 20200213154309 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV8.up/0 forward686server # [1130153.096789] server mobilizon_ctl[536]: 13:56:02.592 [info] == Migrated 20200213154309 in 0.0s687server # [1130153.103469] server mobilizon_ctl[536]: 13:56:02.599 [info] == Running 20200214135231 Mobilizon.Storage.Repo.Migrations.AddLastRefreshedAtToActors.change/0 forward688server # [1130153.103679] server mobilizon_ctl[536]: 13:56:02.599 [info] alter table actors689server # [1130153.104718] server mobilizon_ctl[536]: 13:56:02.600 [info] == Migrated 20200214135231 in 0.0s690server # [1130153.107951] server mobilizon_ctl[536]: 13:56:02.604 [info] == Running 20200218085757 Mobilizon.Storage.Repo.Migrations.AddNewRolesToMember.up/0 forward691server # [1130153.108121] server mobilizon_ctl[536]: 13:56:02.604 [info] execute "ALTER TYPE member_role ADD VALUE IF NOT EXISTS 'invited'"692server # [1130153.108802] server mobilizon_ctl[536]: 13:56:02.604 [info] enum label "invited" already exists, skipping693server # [1130153.108878] server mobilizon_ctl[536]: 13:56:02.604 [info] execute "ALTER TYPE member_role ADD VALUE IF NOT EXISTS 'rejected'"694server # [1130153.109354] server mobilizon_ctl[536]: 13:56:02.605 [info] enum label "rejected" already exists, skipping695server # [1130153.109536] server mobilizon_ctl[536]: 13:56:02.605 [info] == Migrated 20200218085757 in 0.0s696server # [1130153.114851] server mobilizon_ctl[536]: 13:56:02.610 [info] == Running 20200218170232 Mobilizon.Storage.Repo.Migrations.MoveMemberIdToUuid.up/0 forward697server # [1130153.115015] server mobilizon_ctl[536]: 13:56:02.611 [info] alter table members698server # [1130153.118575] server mobilizon_ctl[536]: 13:56:02.614 [info] == Migrated 20200218170232 in 0.0s699server # [1130153.129238] server mobilizon_ctl[536]: 13:56:02.625 [info] == Running 20200219152611 Mobilizon.Storage.Repo.Migrations.AddMembersEndpointToActors.up/0 forward700server # [1130153.129736] server mobilizon_ctl[536]: 13:56:02.625 [info] alter table actors701server # [1130153.130712] server mobilizon_ctl[536]: 13:56:02.626 [info] == Migrated 20200219152611 in 0.0s702server # [1130153.134262] server mobilizon_ctl[536]: 13:56:02.630 [info] == Running 20200221095721 Mobilizon.Repo.Migrations.CreateTodos.change/0 forward703server # [1130153.134594] server mobilizon_ctl[536]: 13:56:02.630 [info] create table todo_lists704server # [1130153.137826] server mobilizon_ctl[536]: 13:56:02.633 [info] create table todos705server # [1130153.141051] server mobilizon_ctl[536]: 13:56:02.636 [info] == Migrated 20200221095721 in 0.0s706server # [1130153.163227] server mobilizon_ctl[536]: 13:56:02.659 [info] == Running 20200221160744 Mobilizon.Repo.Migrations.CreateResources.change/0 forward707server # [1130153.163574] server mobilizon_ctl[536]: 13:56:02.659 [info] create table resource708server # [1130153.168560] server mobilizon_ctl[536]: 13:56:02.664 [info] == Migrated 20200221160744 in 0.0s709server # [1130153.177012] server mobilizon_ctl[536]: 13:56:02.672 [info] == Running 20200406115807 Mobilizon.Storage.Repo.Migrations.AddConversations.change/0 forward710server # [1130153.177539] server mobilizon_ctl[536]: 13:56:02.673 [info] create table conversations711server # [1130153.183089] server mobilizon_ctl[536]: 13:56:02.679 [info] alter table comments712server # [1130153.185255] server mobilizon_ctl[536]: 13:56:02.681 [info] == Migrated 20200406115807 in 0.0s713server # [1130153.193694] server mobilizon_ctl[536]: 13:56:02.689 [info] == Running 20200410100554 Mobilizon.Storage.Repo.Migrations.AddNumberEditsToComment.change/0 forward714server # [1130153.193867] server mobilizon_ctl[536]: 13:56:02.689 [info] alter table comments715server # [1130153.195010] server mobilizon_ctl[536]: 13:56:02.690 [info] == Migrated 20200410100554 in 0.0s716server # [1130153.203482] server mobilizon_ctl[536]: 13:56:02.699 [info] == Running 20200513142813 Mobilizon.Storage.Repo.Migrations.AddResourcesAndTodosEndpointsToActor.change/0 forward717server # [1130153.203684] server mobilizon_ctl[536]: 13:56:02.699 [info] alter table actors718server # [1130153.204964] server mobilizon_ctl[536]: 13:56:02.700 [info] == Migrated 20200513142813 in 0.0s719server # [1130153.212476] server mobilizon_ctl[536]: 13:56:02.708 [info] == Running 20200514101612 Mobilizon.Storage.Repo.Migrations.AddLocalAttributeToResourcesAndTodos.change/0 forward720server # [1130153.212808] server mobilizon_ctl[536]: 13:56:02.708 [info] alter table resource721server # [1130153.214191] server mobilizon_ctl[536]: 13:56:02.709 [info] alter table todo_lists722server # [1130153.214475] server mobilizon_ctl[536]: 13:56:02.710 [info] alter table todos723server # [1130153.216058] server mobilizon_ctl[536]: 13:56:02.711 [info] == Migrated 20200514101612 in 0.0s724server # [1130153.223841] server mobilizon_ctl[536]: 13:56:02.719 [info] == Running 20200518084949 Mobilizon.Storage.Repo.Migrations.MoveInviterFromMetadataToMemberTable.change/0 forward725server # [1130153.224402] server mobilizon_ctl[536]: 13:56:02.720 [info] alter table members726server # [1130153.226792] server mobilizon_ctl[536]: 13:56:02.722 [info] == Migrated 20200518084949 in 0.0s727server # [1130153.233125] server mobilizon_ctl[536]: 13:56:02.729 [info] == Running 20200519082820 Mobilizon.Storage.Repo.Migrations.AddUniqueURLContraintToSomeTables.change/0 forward728server # [1130153.233440] server mobilizon_ctl[536]: 13:56:02.729 [info] create index members_url_index729server # [1130153.236514] server mobilizon_ctl[536]: 13:56:02.732 [info] create index resource_url_index730server # [1130153.237571] server mobilizon_ctl[536]: 13:56:02.733 [info] create index todo_lists_url_index731server # [1130153.239438] server mobilizon_ctl[536]: 13:56:02.735 [info] create index todos_url_index732server # [1130153.240911] server mobilizon_ctl[536]: 13:56:02.736 [info] == Migrated 20200519082820 in 0.0s733server # [1130153.250203] server mobilizon_ctl[536]: 13:56:02.746 [info] == Running 20200526131523 Mobilizon.Repo.Migrations.CreateUserSettings.change/0 forward734server # [1130153.250618] server mobilizon_ctl[536]: 13:56:02.746 [info] create table user_settings735server # [1130153.253618] server mobilizon_ctl[536]: 13:56:02.749 [info] == Migrated 20200526131523 in 0.0s736server # [1130153.257853] server mobilizon_ctl[536]: 13:56:02.753 [info] == Running 20200605154921 Mobilizon.Storage.Repo.Migrations.AddNotificationPendingParticipationToSettings.change/0 forward737server # [1130153.258160] server mobilizon_ctl[536]: 13:56:02.754 [info] alter table user_settings738server # [1130153.259338] server mobilizon_ctl[536]: 13:56:02.755 [info] == Migrated 20200605154921 in 0.0s739server # [1130153.266048] server mobilizon_ctl[536]: 13:56:02.762 [info] == Running 20200612155254 Mobilizon.Storage.Repo.Migrations.AddDisabledParameterToUsers.change/0 forward740server # [1130153.266237] server mobilizon_ctl[536]: 13:56:02.762 [info] alter table users741server # [1130153.267573] server mobilizon_ctl[536]: 13:56:02.763 [info] == Migrated 20200612155254 in 0.0s742server # [1130153.274402] server mobilizon_ctl[536]: 13:56:02.770 [info] == Running 20200630123819 Mobilizon.Storage.Repo.Migrations.AddProviderToUserAndMakePasswordMandatory.up/0 forward743server # [1130153.274571] server mobilizon_ctl[536]: 13:56:02.770 [info] alter table users744server # [1130153.275732] server mobilizon_ctl[536]: 13:56:02.771 [info] == Migrated 20200630123819 in 0.0s745server # [1130153.283548] server mobilizon_ctl[536]: 13:56:02.779 [info] == Running 20200708080516 Mobilizon.Repo.Migrations.CreatePosts.up/0 forward746server # [1130153.286558] server mobilizon_ctl[536]: 13:56:02.782 [info] execute "CREATE TYPE public.post_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')"747server # [1130153.287359] server mobilizon_ctl[536]: 13:56:02.783 [info] create table posts748server # [1130153.291570] server mobilizon_ctl[536]: 13:56:02.787 [info] create table posts_tags749server # [1130153.293494] server mobilizon_ctl[536]: 13:56:02.789 [info] alter table actors750server # [1130153.294569] server mobilizon_ctl[536]: 13:56:02.790 [info] == Migrated 20200708080516 in 0.0s751server # [1130153.306195] server mobilizon_ctl[536]: 13:56:02.802 [info] == Running 20200717142633 Mobilizon.Storage.Repo.Migrations.RenameConversationsToDiscussions.up/0 forward752server # [1130153.306195] server mobilizon_ctl[536]: 13:56:02.802 [info] rename table conversations to discussions753server # [1130153.307276] server mobilizon_ctl[536]: 13:56:02.803 [info] rename column conversation_id to discussion_id on table comments754server # [1130153.307774] server mobilizon_ctl[536]: 13:56:02.803 [info] alter table actors755server # [1130153.308940] server mobilizon_ctl[536]: 13:56:02.804 [info] == Migrated 20200717142633 in 0.0s756server # [1130153.316439] server mobilizon_ctl[536]: 13:56:02.812 [info] == Running 20200721131521 Mobilizon.Storage.Repo.Migrations.AddUrlToConversation.up/0 forward757server # [1130153.316613] server mobilizon_ctl[536]: 13:56:02.812 [info] drop constraint if exists comments_conversation_id_fkey from table comments758server # [1130153.317668] server mobilizon_ctl[536]: 13:56:02.813 [info] drop constraint if exists comments_discussion_id_fkey from table comments759server # [1130153.318145] server mobilizon_ctl[536]: 13:56:02.814 [info] constraint "comments_discussion_id_fkey" of relation "comments" does not exist, skipping760server # [1130153.318194] server mobilizon_ctl[536]: 13:56:02.814 [info] alter table discussions761server # [1130153.319856] server mobilizon_ctl[536]: 13:56:02.815 [info] alter table comments762server # [1130153.322051] server mobilizon_ctl[536]: 13:56:02.817 [info] == Migrated 20200721131521 in 0.0s763server # [1130153.328260] server mobilizon_ctl[536]: 13:56:02.824 [info] == Running 20200805124620 Mobilizon.Storage.Repo.Migrations.AddAddressToActors.change/0 forward764server # [1130153.328681] server mobilizon_ctl[536]: 13:56:02.824 [info] alter table actors765server # [1130153.330542] server mobilizon_ctl[536]: 13:56:02.826 [info] == Migrated 20200805124620 in 0.0s766server # [1130153.337032] server mobilizon_ctl[536]: 13:56:02.833 [info] == Running 20200817080549 Mobilizon.Storage.Repo.Migrations.AddPublishedAtToEntities.up/0 forward767server # [1130153.337533] server mobilizon_ctl[536]: 13:56:02.833 [info] alter table comments768server # [1130153.339249] server mobilizon_ctl[536]: 13:56:02.835 [info] alter table resource769server # [1130153.340941] server mobilizon_ctl[536]: 13:56:02.837 [info] alter table todo_lists770server # [1130153.342995] server mobilizon_ctl[536]: 13:56:02.838 [info] alter table todos771server # [1130153.344047] server mobilizon_ctl[536]: 13:56:02.840 [info] == Migrated 20200817080549 in 0.0s772server # [1130153.347071] server mobilizon_ctl[536]: 13:56:02.843 [info] == Running 20200828071543 Mobilizon.Storage.Repo.Migrations.AddLoginInformationToUser.change/0 forward773server # [1130153.347214] server mobilizon_ctl[536]: 13:56:02.843 [info] alter table users774server # [1130153.349074] server mobilizon_ctl[536]: 13:56:02.844 [info] == Migrated 20200828071543 in 0.0s775server # [1130153.356835] server mobilizon_ctl[536]: 13:56:02.852 [info] == Running 20200901101307 Mobilizon.Storage.Repo.Migrations.FixRelayVisibility.up/0 forward776server # [1130153.362087] server mobilizon_ctl[536]: 13:56:02.858 [info] == Migrated 20200901101307 in 0.0s777server # [1130153.367822] server mobilizon_ctl[536]: 13:56:02.863 [info] == Running 20200928150725 Mobilizon.Storage.Repo.Migrations.AddContactsToEvents.change/0 forward778server # [1130153.368166] server mobilizon_ctl[536]: 13:56:02.864 [info] create table event_contacts779server # [1130153.370933] server mobilizon_ctl[536]: 13:56:02.866 [info] == Migrated 20200928150725 in 0.0s780server # [1130153.377685] server mobilizon_ctl[536]: 13:56:02.873 [info] == Running 20201006132530 Mobilizon.Storage.Repo.Migrations.ChangeDefaultNotificationPendingParticipation.up/0 forward781server # [1130153.377912] server mobilizon_ctl[536]: 13:56:02.873 [info] alter table user_settings782server # [1130153.378946] server mobilizon_ctl[536]: 13:56:02.874 [info] == Migrated 20201006132530 in 0.0s783server # [1130153.385764] server mobilizon_ctl[536]: 13:56:02.881 [info] == Running 20201103141811 Mobilizon.Storage.Repo.Migrations.AddNotificationPendingMembershipToSettings.change/0 forward784server # [1130153.386028] server mobilizon_ctl[536]: 13:56:02.882 [info] alter table user_settings785server # [1130153.387278] server mobilizon_ctl[536]: 13:56:02.883 [info] == Migrated 20201103141811 in 0.0s786server # [1130153.393493] server mobilizon_ctl[536]: 13:56:02.889 [info] == Running 20201105145719 Mobilizon.Storage.Repo.Migrations.RepairGroupsWithMissingURLs.up/0 forward787server # [1130153.407452] server mobilizon_ctl[536]: 13:56:02.903 [info] == Migrated 20201105145719 in 0.0s788server # [1130153.411022] server mobilizon_ctl[536]: 13:56:02.907 [info] == Running 20201114174929 Mobilizon.Storage.Repo.Migrations.FixObanMigrationsForOlderPostgreSQLVersions.up/0 forward789server # [1130153.411695] server mobilizon_ctl[536]: 13:56:02.907 [info] == Migrated 20201114174929 in 0.0s790server # [1130153.417384] server mobilizon_ctl[536]: 13:56:02.913 [info] == Running 20201114175249 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV9.up/0 forward791server # [1130153.419464] server mobilizon_ctl[536]: 13:56:02.915 [info] == Migrated 20201114175249 in 0.0s792server # [1130153.427500] server mobilizon_ctl[536]: 13:56:02.923 [info] == Running 20201120161229 Mobilizon.Storage.Repo.Migrations.FixPictureDeletion.up/0 forward793server # [1130153.427797] server mobilizon_ctl[536]: 13:56:02.923 [info] drop constraint if exists posts_picture_id_fkey from table posts794server # [1130153.428873] server mobilizon_ctl[536]: 13:56:02.924 [info] alter table posts795server # [1130153.431179] server mobilizon_ctl[536]: 13:56:02.927 [info] drop constraint if exists events_picture_id_fkey from table events796server # [1130153.431911] server mobilizon_ctl[536]: 13:56:02.928 [info] alter table events797server # [1130153.434114] server mobilizon_ctl[536]: 13:56:02.929 [info] == Migrated 20201120161229 in 0.0s798server # [1130153.440232] server mobilizon_ctl[536]: 13:56:02.936 [info] == Running 20201124094655 Mobilizon.Storage.Repo.Migrations.AddMediaTables.change/0 forward799server # [1130153.440462] server mobilizon_ctl[536]: 13:56:02.936 [info] rename table pictures to medias800server # [1130153.441327] server mobilizon_ctl[536]: 13:56:02.937 [info] create table events_medias801server # [1130153.443558] server mobilizon_ctl[536]: 13:56:02.939 [info] create table posts_medias802server # [1130153.445561] server mobilizon_ctl[536]: 13:56:02.941 [info] create table comments_medias803server # [1130153.448023] server mobilizon_ctl[536]: 13:56:02.943 [info] == Migrated 20201124094655 in 0.0s804server # [1130153.457808] server mobilizon_ctl[536]: 13:56:02.953 [info] == Running 20210127153325 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV10.up/0 forward805server # [1130153.459826] server mobilizon_ctl[536]: 13:56:02.955 [info] == Migrated 20210127153325 in 0.0s806server # [1130153.468472] server mobilizon_ctl[536]: 13:56:02.964 [info] == Running 20210210143432 Mobilizon.Storage.Repo.Migrations.AddLocationSettingsToUser.change/0 forward807server # [1130153.468665] server mobilizon_ctl[536]: 13:56:02.964 [info] alter table user_settings808server # [1130153.470244] server mobilizon_ctl[536]: 13:56:02.966 [info] == Migrated 20210210143432 in 0.0s809server # [1130153.480158] server mobilizon_ctl[536]: 13:56:02.976 [info] == Running 20210215092515 Mobilizon.Storage.Repo.Migrations.AddActivityTable.change/0 forward810server # [1130153.480657] server mobilizon_ctl[536]: 13:56:02.976 [info] create table activities811server # [1130153.485414] server mobilizon_ctl[536]: 13:56:02.981 [info] == Migrated 20210215092515 in 0.0s812server # [1130153.496149] server mobilizon_ctl[536]: 13:56:02.988 [info] == Running 20210217164549 Mobilizon.Storage.Repo.Migrations.AddMemberSinceToMembers.up/0 forward813server # [1130153.497802] server mobilizon_ctl[536]: 13:56:02.988 [info] alter table members814server # [1130153.498271] server mobilizon_ctl[536]: 13:56:02.991 [info] == Migrated 20210217164549 in 0.0s815server # [1130153.501789] server mobilizon_ctl[536]: 13:56:02.997 [info] == Running 20210310084210 Mobilizon.Storage.Repo.Migrations.AddIndexesToActivities.change/0 forward816server # [1130153.501919] server mobilizon_ctl[536]: 13:56:02.998 [info] create index activity_group_id817server # [1130153.505944] server mobilizon_ctl[536]: 13:56:03.001 [info] create index activity_filter818server # [1130153.507264] server mobilizon_ctl[536]: 13:56:03.003 [info] == Migrated 20210310084210 in 0.0s819server # [1130153.513539] server mobilizon_ctl[536]: 13:56:03.009 [info] == Running 20210422140923 Mobilizon.Storage.Repo.Migrations.CleanupAddresses.up/0 forward820server # [1130153.514685] server mobilizon_ctl[536]: 13:56:03.010 [info] == Migrated 20210422140923 in 0.0s821server # [1130153.520637] server mobilizon_ctl[536]: 13:56:03.016 [info] == Running 20210422155913 Mobilizon.Storage.Repo.Migrations.AddIndexToAddresses.up/0 forward822server # [1130153.521996] server mobilizon_ctl[536]: 13:56:03.016 [info] create index if not exists addresses_url_index823server # [1130153.522341] server mobilizon_ctl[536]: 13:56:03.018 [info] == Migrated 20210422155913 in 0.0s824server # [1130153.529970] server mobilizon_ctl[536]: 13:56:03.025 [info] == Running 20210427091034 Mobilizon.Storage.Repo.Migrations.RepairUsersDefaultActors.up/0 forward825server # [1130153.533127] server mobilizon_ctl[536]: 13:56:03.027 [info] == Migrated 20210427091034 in 0.0s826server # [1130153.541640] server mobilizon_ctl[536]: 13:56:03.037 [info] == Running 20210505172402 Mobilizon.Storage.Repo.Migrations.AddGroupNotificationAndLastNotificationDateSettings.change/0 forward827server # [1130153.541805] server mobilizon_ctl[536]: 13:56:03.037 [info] alter table user_settings828server # [1130153.543101] server mobilizon_ctl[536]: 13:56:03.038 [info] == Migrated 20210505172402 in 0.0s829server # [1130153.545537] server mobilizon_ctl[536]: 13:56:03.041 [info] == Running 20210506080303 Mobilizon.Repo.Migrations.CreateUserPushSubscriptions.change/0 forward830server # [1130153.545709] server mobilizon_ctl[536]: 13:56:03.041 [info] create table user_push_subscriptions831server # [1130153.551455] server mobilizon_ctl[536]: 13:56:03.045 [info] create index user_push_subscriptions_user_id_digest_index832server # [1130153.553808] server mobilizon_ctl[536]: 13:56:03.049 [info] == Migrated 20210506080303 in 0.0s833server # [1130153.565238] server mobilizon_ctl[536]: 13:56:03.061 [info] == Running 20210512084824 Mobilizon.Storage.Repo.Migrations.RepairRelayAndAnonymousActors.up/0 forward834server # [1130153.567504] server mobilizon_ctl[536]: 13:56:03.063 [info] == Migrated 20210512084824 in 0.0s835server # [1130153.574847] server mobilizon_ctl[536]: 13:56:03.070 [info] == Running 20210526203337 Mobilizon.Storage.Repo.Migrations.AddUserActivitySettings.change/0 forward836server # [1130153.575212] server mobilizon_ctl[536]: 13:56:03.071 [info] create table user_activity_settings837server # [1130153.578988] server mobilizon_ctl[536]: 13:56:03.075 [info] create index user_activity_settings_user_id_key_method_index838server # [1130153.580528] server mobilizon_ctl[536]: 13:56:03.076 [info] == Migrated 20210526203337 in 0.0s839server # [1130153.587735] server mobilizon_ctl[536]: 13:56:03.083 [info] == Running 20210601082412 Mobilizon.Storage.Repo.Migrations.AddIsAnnouncementToComments.change/0 forward840server # [1130153.587967] server mobilizon_ctl[536]: 13:56:03.084 [info] alter table comments841server # [1130153.589245] server mobilizon_ctl[536]: 13:56:03.085 [info] == Migrated 20210601082412 in 0.0s842server # [1130153.592815] server mobilizon_ctl[536]: 13:56:03.088 [info] == Running 20210601082613 Mobilizon.Storage.Repo.Migrations.FixUserSettingsNullableFields.change/0 forward843server # [1130153.593301] server mobilizon_ctl[536]: 13:56:03.089 [info] alter table user_settings844server # [1130153.594937] server mobilizon_ctl[536]: 13:56:03.090 [info] == Migrated 20210601082613 in 0.0s845server # [1130153.600815] server mobilizon_ctl[536]: 13:56:03.096 [info] == Running 20210608133040 Mobilizon.Storage.Repo.Migrations.AddMetadataToMedia.change/0 forward846server # [1130153.601018] server mobilizon_ctl[536]: 13:56:03.097 [info] alter table medias847server # [1130153.601710] server mobilizon_ctl[536]: 13:56:03.097 [info] == Migrated 20210608133040 in 0.0s848server # [1130153.606859] server mobilizon_ctl[536]: 13:56:03.102 [info] == Running 20210622133516 Mobilizon.Storage.Repo.Migrations.CleanupPosts.up/0 forward849server # [1130153.608362] server mobilizon_ctl[536]: 13:56:03.104 [info] == Migrated 20210622133516 in 0.0s850server # [1130153.610952] server mobilizon_ctl[536]: 13:56:03.107 [info] == Running 20210622133555 Mobilizon.Storage.Repo.Migrations.AddIndexToPosts.up/0 forward851server # [1130153.611084] server mobilizon_ctl[536]: 13:56:03.107 [info] create index if not exists posts_url_index852server # [1130153.613034] server mobilizon_ctl[536]: 13:56:03.108 [info] == Migrated 20210622133555 in 0.0s853server # [1130153.618942] server mobilizon_ctl[536]: 13:56:03.114 [info] == Running 20210730143924 Mobilizon.Storage.Repo.Migrations.PutUniqueIndexOnParticipantsUrls.up/0 forward854server # [1130153.619181] server mobilizon_ctl[536]: 13:56:03.115 [info] create index if not exists participants_url_index855server # [1130153.620810] server mobilizon_ctl[536]: 13:56:03.116 [info] == Migrated 20210730143924 in 0.0s856server # [1130153.628424] server mobilizon_ctl[536]: 13:56:03.124 [info] == Running 20210805142745 Mobilizon.Storage.Repo.Migrations.AddMetadataForEvents.change/0 forward857server # [1130153.628556] server mobilizon_ctl[536]: 13:56:03.124 [info] alter table events858server # [1130153.629714] server mobilizon_ctl[536]: 13:56:03.125 [info] == Migrated 20210805142745 in 0.0s859server # [1130153.633178] server mobilizon_ctl[536]: 13:56:03.129 [info] == Running 20210819161507 Mobilizon.Storage.Repo.Migrations.AddLanguageToEntities.change/0 forward860server # [1130153.633356] server mobilizon_ctl[536]: 13:56:03.129 [info] alter table events861server # [1130153.634521] server mobilizon_ctl[536]: 13:56:03.130 [info] alter table comments862server # [1130153.635405] server mobilizon_ctl[536]: 13:56:03.131 [info] alter table posts863server # [1130153.636271] server mobilizon_ctl[536]: 13:56:03.132 [info] == Migrated 20210819161507 in 0.0s864server # [1130153.643429] server mobilizon_ctl[536]: 13:56:03.139 [info] == Running 20211001101902 Mobilizon.Repo.Migrations.CreateExports.change/0 forward865server # [1130153.643676] server mobilizon_ctl[536]: 13:56:03.139 [info] create table exports866server # [1130153.651062] server mobilizon_ctl[536]: 13:56:03.144 [info] create index exports_file_path_index867server # [1130153.651062] server mobilizon_ctl[536]: 13:56:03.145 [info] == Migrated 20211001101902 in 0.0s868server # [1130153.659407] server mobilizon_ctl[536]: 13:56:03.155 [info] == Running 20211008084901 Mobilizon.Storage.Repo.Migrations.AddTimezoneToAddresses.change/0 forward869server # [1130153.660506] server mobilizon_ctl[536]: 13:56:03.155 [info] alter table addresses870server # [1130153.660655] server mobilizon_ctl[536]: 13:56:03.156 [info] == Migrated 20211008084901 in 0.0s871server # [1130153.666733] server mobilizon_ctl[536]: 13:56:03.162 [info] == Running 20211013090405 Mobilizon.Storage.Repo.Migrations.AddCodeToParticipants.change/0 forward872server # [1130153.667025] server mobilizon_ctl[536]: 13:56:03.163 [info] alter table participants873server # [1130153.667779] server mobilizon_ctl[536]: 13:56:03.163 [info] == Migrated 20211013090405 in 0.0s874server # [1130153.673882] server mobilizon_ctl[536]: 13:56:03.169 [info] == Running 20211022093530 Mobilizon.Storage.Repo.Migrations.AddNotifyToFollowers.change/0 forward875server # [1130153.674052] server mobilizon_ctl[536]: 13:56:03.170 [info] alter table followers876server # [1130153.675339] server mobilizon_ctl[536]: 13:56:03.171 [info] == Migrated 20211022093530 in 0.0s877server # [1130153.680370] server mobilizon_ctl[536]: 13:56:03.176 [info] == Running 20211223141104 Mobilizon.Storage.Repo.Migrations.AddInstanceMaterializedView.up/0 forward878server # [1130153.682875] server mobilizon_ctl[536]: 13:56:03.178 [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 # [1130153.696929] server mobilizon_ctl[536]: 13:56:03.192 [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 # [1130153.698081] server mobilizon_ctl[536]: 13:56:03.193 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger ON actors;\n"881server # [1130153.698530] server mobilizon_ctl[536]: 13:56:03.194 [info] trigger "refresh_instances_trigger" for relation "actors" does not exist, skipping882server # [1130153.698638] server mobilizon_ctl[536]: 13:56:03.194 [info] execute "CREATE TRIGGER refresh_instances_trigger\nAFTER INSERT OR UPDATE OR DELETE\nON actors\nFOR EACH STATEMENT\nEXECUTE PROCEDURE refresh_instances();\n"883server # [1130153.699142] server mobilizon_ctl[536]: 13:56:03.195 [info] create index if not exists instances_domain_index884server # [1130153.703252] server mobilizon_ctl[536]: 13:56:03.199 [info] == Migrated 20211223141104 in 0.0s885server # [1130153.719782] server mobilizon_ctl[536]: 13:56:03.215 [info] == Running 20220321154138 Mobilizon.Storage.Repo.Migrations.CreateObanPeers.up/0 forward886server # [1130153.721091] server mobilizon_ctl[536]: 13:56:03.217 [info] == Migrated 20220321154138 in 0.0s887server # [1130153.728878] server mobilizon_ctl[536]: 13:56:03.224 [info] == Running 20220321154142 Mobilizon.Storage.Repo.Migrations.SwapPrimaryObanIndexes.change/0 forward888server # [1130153.729286] server mobilizon_ctl[536]: 13:56:03.225 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index889server # [1130153.730241] server mobilizon_ctl[536]: 13:56:03.226 [info] relation "oban_jobs_state_queue_priority_scheduled_at_id_index" already exists, skipping890server # [1130153.730241] server mobilizon_ctl[536]: 13:56:03.226 [info] drop index if exists public.oban_jobs_queue_state_priority_scheduled_at_id_index891server # [1130153.730700] server mobilizon_ctl[536]: 13:56:03.226 [info] index "oban_jobs_queue_state_priority_scheduled_at_id_index" does not exist, skipping892server # [1130153.730844] server mobilizon_ctl[536]: 13:56:03.226 [info] == Migrated 20220321154142 in 0.0s893server # [1130153.736488] server mobilizon_ctl[536]: 13:56:03.232 [info] == Running 20220328153640 Mobilizon.Storage.Repo.Migrations.SetAllEventsCategoryToMeeting.up/0 forward894server # [1130153.736708] server mobilizon_ctl[536]: 13:56:03.232 [info] execute "UPDATE events SET category = 'MEETING'"895server # [1130153.737534] server mobilizon_ctl[536]: 13:56:03.233 [info] == Migrated 20220328153640 in 0.0s896server # [1130153.743285] server mobilizon_ctl[536]: 13:56:03.239 [info] == Running 20220407083712 Mobilizon.Storage.Repo.Migrations.AddIndexesToAddresses.up/0 forward897server # [1130153.743516] server mobilizon_ctl[536]: 13:56:03.239 [info] create index if not exists idx_addresses_geom_x898server # [1130153.745346] server mobilizon_ctl[536]: 13:56:03.241 [info] create index if not exists idx_addresses_geom_y899server # [1130153.746238] server mobilizon_ctl[536]: 13:56:03.242 [info] == Migrated 20220407083712 in 0.0s900server # [1130153.749620] server mobilizon_ctl[536]: 13:56:03.245 [info] == Running 20220505091224 Mobilizon.Storage.Repo.Migrations.ChangeRefreshInstanceTriggerToOnlyExecuteOnRelays.up/0 forward901server # [1130153.749855] server mobilizon_ctl[536]: 13:56:03.245 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger ON actors;\n"902server # [1130153.750591] server mobilizon_ctl[536]: 13:56:03.246 [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 # [1130153.751310] server mobilizon_ctl[536]: 13:56:03.247 [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 # [1130153.751963] server mobilizon_ctl[536]: 13:56:03.247 [info] == Migrated 20220505091224 in 0.0s905server # [1130153.760067] server mobilizon_ctl[536]: 13:56:03.256 [info] == Running 20220506105150 Mobilizon.Storage.Repo.Migrations.RemoveRefreshInstanceTriggers.up/0 forward906server # [1130153.760350] server mobilizon_ctl[536]: 13:56:03.256 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger_new ON actors;\n"907server # [1130153.761387] server mobilizon_ctl[536]: 13:56:03.257 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger_old ON actors;\n"908server # [1130153.762382] server mobilizon_ctl[536]: 13:56:03.258 [info] == Migrated 20220506105150 in 0.0s909server # [1130153.769006] server mobilizon_ctl[536]: 13:56:03.265 [info] == Running 20230208101626 Mobilizon.Repo.Migrations.CreateApplications.change/0 forward910server # [1130153.769355] server mobilizon_ctl[536]: 13:56:03.265 [info] create table applications911server # [1130153.772787] server mobilizon_ctl[536]: 13:56:03.268 [info] create index applications_owner_id_owner_type_index912server # [1130153.773897] server mobilizon_ctl[536]: 13:56:03.269 [info] == Migrated 20230208101626 in 0.0s913server # [1130153.780656] server mobilizon_ctl[536]: 13:56:03.276 [info] == Running 20230215125801 Mobilizon.Repo.Migrations.CreateApplicationTokens.change/0 forward914server # [1130153.781288] server mobilizon_ctl[536]: 13:56:03.277 [info] create table application_tokens915server # [1130153.785677] server mobilizon_ctl[536]: 13:56:03.281 [info] create index application_tokens_user_id_application_id_index916server # [1130153.787565] server mobilizon_ctl[536]: 13:56:03.283 [info] == Migrated 20230215125801 in 0.0s917server # [1130153.798771] server mobilizon_ctl[536]: 13:56:03.294 [info] == Running 20230217084253 Mobilizon.Repo.Migrations.CreateApplicationDeviceActivation.change/0 forward918server # [1130153.799179] server mobilizon_ctl[536]: 13:56:03.295 [info] create table application_device_activation919server # [1130153.803820] server mobilizon_ctl[536]: 13:56:03.299 [info] == Migrated 20230217084253 in 0.0s920server # [1130153.811119] server mobilizon_ctl[536]: 13:56:03.307 [info] == Running 20230605143534 Mobilizon.Storage.Repo.Migrations.AllowMultipleEventsToBeReported.up/0 forward921server # [1130153.811424] server mobilizon_ctl[536]: 13:56:03.307 [info] create table reports_events922server # [1130153.813600] server mobilizon_ctl[536]: 13:56:03.309 [info] == Migrated 20230605143534 in 0.0s923server # [1130153.819747] server mobilizon_ctl[536]: 13:56:03.315 [info] == Running 20230605153836 Mobilizon.Storage.Repo.Migrations.BackfillReportEventsWithOldEvents.up/0 forward924server # [1130153.820922] server mobilizon_ctl[536]: 13:56:03.316 [info] == Migrated 20230605153836 in 0.0s925server # [1130153.823990] server mobilizon_ctl[536]: 13:56:03.320 [info] == Running 20230605154106 Mobilizon.Storage.Repo.Migrations.RemoveObsoleteEventIdOnReports.up/0 forward926server # [1130153.824284] server mobilizon_ctl[536]: 13:56:03.320 [info] alter table reports927server # [1130153.825262] server mobilizon_ctl[536]: 13:56:03.321 [info] == Migrated 20230605154106 in 0.0s928server # [1130153.833141] server mobilizon_ctl[536]: 13:56:03.329 [info] == Running 20230831153358 Mobilizon.Storage.Repo.Migrations.RemoveOnDeleteCascadeForReports.up/0 forward929server # [1130153.833545] server mobilizon_ctl[536]: 13:56:03.329 [info] execute "DROP MATERIALIZED VIEW IF EXISTS instances;\n"930server # [1130153.836762] server mobilizon_ctl[536]: 13:56:03.332 [info] drop constraint reports_reported_id_fkey from table reports931server # [1130153.837676] server mobilizon_ctl[536]: 13:56:03.333 [info] drop constraint reports_reporter_id_fkey from table reports932server # [1130153.838724] server mobilizon_ctl[536]: 13:56:03.334 [info] drop constraint reports_manager_id_fkey from table reports933server # [1130153.839680] server mobilizon_ctl[536]: 13:56:03.335 [info] alter table reports934server # [1130153.842632] server mobilizon_ctl[536]: 13:56:03.338 [info] drop constraint report_notes_moderator_id_fkey from table report_notes935server # [1130153.843521] server mobilizon_ctl[536]: 13:56:03.339 [info] alter table report_notes936server # [1130153.845178] server mobilizon_ctl[536]: 13:56:03.341 [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 # [1130153.855474] server mobilizon_ctl[536]: 13:56:03.351 [info] == Migrated 20230831153358 in 0.0s938server # [1130153.865025] server mobilizon_ctl[536]: 13:56:03.361 [info] == Running 20230901160000 Mobilizon.Storage.Repo.Migrations.AddExternalUrlForEvents.up/0 forward939server # [1130153.865228] server mobilizon_ctl[536]: 13:56:03.361 [info] alter table events940server # [1130153.866499] server mobilizon_ctl[536]: 13:56:03.362 [info] execute "ALTER TABLE events ALTER COLUMN join_options TYPE VARCHAR USING join_options::text"941server # [1130153.872645] server mobilizon_ctl[536]: 13:56:03.368 [info] execute "ALTER TABLE events ALTER COLUMN join_options DROP DEFAULT"942server # [1130153.873100] server mobilizon_ctl[536]: 13:56:03.369 [info] execute "DROP TYPE public.join_options"943server # [1130153.873665] server mobilizon_ctl[536]: 13:56:03.369 [info] execute "CREATE TYPE public.join_options AS ENUM ('free', 'restricted', 'invite', 'external')"944server # [1130153.874055] server mobilizon_ctl[536]: 13:56:03.370 [info] execute "ALTER TABLE events ALTER COLUMN join_options TYPE join_options USING join_options::join_options"945server # [1130153.877736] server mobilizon_ctl[536]: 13:56:03.373 [info] execute "ALTER TABLE events ALTER COLUMN join_options SET DEFAULT 'free'::join_options"946server # [1130153.878936] server mobilizon_ctl[536]: 13:56:03.374 [info] == Migrated 20230901160000 in 0.0s947server # [1130153.891291] server mobilizon_ctl[536]: 13:56:03.387 [info] == Running 20230920071502 Mobilizon.Storage.Repo.Migrations.AddActorConversations.up/0 forward948server # [1130153.891728] server mobilizon_ctl[536]: 13:56:03.387 [info] create table conversations949server # [1130153.895374] server mobilizon_ctl[536]: 13:56:03.391 [info] create table conversation_participants950server # [1130153.898114] server mobilizon_ctl[536]: 13:56:03.394 [info] alter table comments951server # [1130153.899641] server mobilizon_ctl[536]: 13:56:03.395 [info] == Migrated 20230920071502 in 0.0s952server # [1130153.907775] server mobilizon_ctl[536]: 13:56:03.403 [info] == Running 20231220092536 Mobilizon.Storage.Repo.Migrations.AddActorInstances.change/0 forward953server # [1130153.908400] server mobilizon_ctl[536]: 13:56:03.404 [info] create table instance_actors954server # [1130153.912896] server mobilizon_ctl[536]: 13:56:03.408 [info] create index instance_actors_domain_index955server # [1130153.914153] server mobilizon_ctl[536]: 13:56:03.410 [info] == Migrated 20231220092536 in 0.0s956server # [1130153.923682] server mobilizon_ctl[536]: 13:56:03.419 [info] == Running 20240104103036 Mobilizon.Storage.Repo.Migrations.ChangeActorInstanceDescriptionTypeToText.up/0 forward957server # [1130153.923921] server mobilizon_ctl[536]: 13:56:03.419 [info] alter table instance_actors958server # [1130153.924717] server mobilizon_ctl[536]: 13:56:03.420 [info] == Migrated 20240104103036 in 0.0s959server # [1130153.931722] server mobilizon_ctl[536]: 13:56:03.427 [info] == Running 20240222121054 Mobilizon.Storage.Repo.Migrations.CreateAdminSettingsMedias.change/0 forward960server # [1130153.932272] server mobilizon_ctl[536]: 13:56:03.428 [info] create table admin_settings_medias961server # [1130153.937258] server mobilizon_ctl[536]: 13:56:03.433 [info] create index admin_settings_medias_group_name_index962server # [1130153.938519] server mobilizon_ctl[536]: 13:56:03.434 [info] == Migrated 20240222121054 in 0.0s963server # [1130153.951647] server mobilizon_ctl[536]: 13:56:03.447 [info] == Running 20240725130410 Mobilizon.Storage.Repo.Migrations.AddEventPhysicalAddressIndex.up/0 forward964server # [1130153.951647] server mobilizon_ctl[536]: 13:56:03.447 [info] create index events_phys_addr_id965server # [1130153.954030] server mobilizon_ctl[536]: 13:56:03.449 [info] == Migrated 20240725130410 in 0.0s966server # [1130153.961995] server mobilizon_ctl[536]: 13:56:03.457 [info] == Running 20250521145952 Mobilizon.Storage.Repo.Migrations.AddUuidToMedia.change/0 forward967server # [1130153.962226] server mobilizon_ctl[536]: 13:56:03.458 [info] alter table medias968server # [1130153.965643] server mobilizon_ctl[536]: 13:56:03.461 [info] create index medias_uuid_index969server # [1130153.967022] server mobilizon_ctl[536]: 13:56:03.462 [info] == Migrated 20250521145952 in 0.0s970server # [1130153.976978] server mobilizon_ctl[536]: 13:56:03.473 [info] == Running 20250911120910 Mobilizon.Storage.Repo.Migrations.AddModerationToUser.change/0 forward971server # [1130153.977147] server mobilizon_ctl[536]: 13:56:03.473 [info] alter table users972server # [1130153.978422] server mobilizon_ctl[536]: 13:56:03.474 [info] == Migrated 20250911120910 in 0.0s973server # [1130153.982770] server mobilizon_ctl[536]: 13:56:03.478 [info] == Running 20250919143627 Mobilizon.Storage.Repo.Migrations.UpdateRoleToUser.change/0 forward974server # [1130153.982925] server mobilizon_ctl[536]: 13:56:03.478 [info] execute "ALTER TYPE user_role ADD VALUE IF NOT EXISTS 'pending';"975server # [1130153.983419] server mobilizon_ctl[536]: 13:56:03.479 [info] enum label "pending" already exists, skipping976server # [1130153.983593] server mobilizon_ctl[536]: 13:56:03.479 [info] == Migrated 20250919143627 in 0.0s977server # [1130153.992209] server mobilizon_ctl[536]: 13:56:03.488 [info] == Running 20251027133219 Mobilizon.Storage.Repo.Migrations.CreateInvitations.change/0 forward978server # [1130153.992430] server mobilizon_ctl[536]: 13:56:03.488 [info] create table invitations979server # [1130153.997414] server mobilizon_ctl[536]: 13:56:03.493 [info] create index invitations_token_index980server # [1130153.998680] server mobilizon_ctl[536]: 13:56:03.494 [info] == Migrated 20251027133219 in 0.0s981server # [1130154.007195] server mobilizon_ctl[536]: 13:56:03.503 [info] == Running 20251111093015 Mobilizon.Storage.Repo.Migrations.AddAllowToGroup.change/0 forward982server # [1130154.007523] server mobilizon_ctl[536]: 13:56:03.503 [info] alter table actors983server # [1130154.008547] server mobilizon_ctl[536]: 13:56:03.504 [info] == Migrated 20251111093015 in 0.0s984server # [1130154.031031] server systemd[1]: Started Mobilizon federated organization and mobilization platform.985server # [1130154.031567] server systemd[1]: Reached target Multi-User System.986server # [1130154.031821] server systemd[1]: Startup finished in 16.556s.987server: (finished: waiting for unit mobilizon.service, in 17.19 seconds)988server: waiting for TCP port 41395 on localhost989server # [1130157.674699] server mobilizon[599]: 13:56:07.170 [info] No tzdata release files found in custom data dir. Copying release file from tzdata priv dir.990server # [1130157.782523] server mobilizon[599]: 13:56:07.278 [info] Source for database :city not found: "/var/lib/mobilizon/geo/GeoLite2-City.mmdb"991server # [1130157.835114] server mobilizon[599]: 13:56:07.330 [info] Loading 122 CA(s) from :otp store992server # [1130157.860295] server mobilizon[599]: 13:56:07.356 [info] Running Mobilizon.Web.Endpoint with Bandit 1.12.0 at ::1:41395 (http)993server # [1130157.860530] server mobilizon[599]: 13:56:07.356 [info] Access Mobilizon.Web.Endpoint at https://acme.test994server # [1130157.873427] server mobilizon[599]: 13:56:07.369 [info] {"message":"notifier only receiving messages from its own node, functionality may be degraded","source":"oban","event":"notifier:switch","connectivity_status":"solitary"}995server # [1130157.874233] server mobilizon[599]: 13:56:07.370 [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.06 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 62098 0 01002server: (finished: must succeed: curl --fail https://acme.test/, in 0.06 seconds)1003(finished: run the VM test script, in 21.31 seconds)1004test script finished in 21.39s1005cleanup1006kill NspawnMachine (pid 50)1007(finished: cleanup, in 0.11 seconds)1008Container server terminated by signal KILL.