container-test-run-mobilizon
checks.aarch64-linux.nixosTest
· build #12
· 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 # [699393.339239] server systemd-journald[57]: Journal started21server # [699393.339294] server systemd-journald[57]: Runtime Journal (/run/log/journal/ee2eb27d73aa48719b285a224f42ffa4) is 8M, max 311.2M, 303.2M free.22server # [699393.370411] server systemd[1]: Listening on Journal Log Access Socket.23server # [699393.370962] server systemd[1]: Finished Apply Kernel Variables.24server # [699393.387682] server systemd[1]: Finished Create Static Device Nodes in /dev gracefully.25server # [699393.407093] server systemd[1]: Starting Flush Journal to Persistent Storage...26server # [699393.408272] server systemd[1]: Starting Create Static Device Nodes in /dev...27server # [699393.440755] server systemd-journald[57]: Time spent on flushing to /var/log/journal/ee2eb27d73aa48719b285a224f42ffa4 is 2.737ms for 7 entries.28server # [699393.440755] server systemd-journald[57]: System Journal (/var/log/journal/ee2eb27d73aa48719b285a224f42ffa4) is 512B, max 4G, 3.9G free.29server # [699393.460610] server systemd[1]: Finished Flush Journal to Persistent Storage.30server # [699393.461075] server systemd[1]: Finished Create Static Device Nodes in /dev.31server # [699393.462671] server systemd[1]: Reached target Preparation for Local File Systems.32server # [699393.462868] server systemd[1]: Rule-based Manager for Device Events and Files skipped, unmet condition check ConditionPathIsReadWrite=/sys33server # [699393.567144] server systemd[1]: Finished Firewall.34server # [699394.344568] server systemd[1]: Mounting /run/wrappers...35server # [699394.401471] server systemd[1]: Mounted /run/wrappers.36server # [699394.402362] server systemd[1]: Reached target Local File Systems.37server # [699394.405076] server systemd[1]: Listening on Boot Loader Control Service Socket.38server # [699394.406307] server systemd[1]: Starting Create SUID/SGID Wrappers...39server # [699394.406359] server systemd[1]: Update Boot Loader Random Seed skipped, unmet condition check ConditionVirtualization=!container40server # [699394.407435] server systemd[1]: Starting Save Transient machine-id to Disk...41server # [699394.411197] server systemd[1]: Starting Create System Files and Directories...42server # [699394.429154] server systemd-tmpfiles[161]: Cannot set file attributes for '/var/empty', value=0x00000010, mask=0x00000010, ignoring: Operation not permitted43server # [699394.429572] server systemd-tmpfiles[161]: fchmod() of /var/log/journal failed: Operation not permitted44server # [699394.429700] server systemd-tmpfiles[161]: fchmod() of /var/log/journal/ee2eb27d73aa48719b285a224f42ffa4 failed: Operation not permitted45server # [699394.429856] server systemd-tmpfiles[161]: fchmod() of /run/log/journal failed: Operation not permitted46server # [699394.436999] server suid-sgid-wrappers-start[168]: chmod: changing permissions of '/run/wrappers/wrappers.7qPwQd4055/chsh': Operation not permitted47server # [699394.448327] server systemd[1]: suid-sgid-wrappers.service: Main process exited, code=exited, status=1/FAILURE48server # [699394.448424] server systemd[1]: suid-sgid-wrappers.service: Failed with result 'exit-code'.49server # [699394.448614] server systemd[1]: Failed to start Create SUID/SGID Wrappers.50server # [699394.449060] server systemd[1]: Finished Create System Files and Directories.51server # [699394.477099] server systemd[1]: Starting Rebuild Journal Catalog...52server # [699394.478729] server systemd[1]: Starting Record System Boot/Shutdown in UTMP...53server # [699394.497476] server systemd[1]: Finished Record System Boot/Shutdown in UTMP.54server # [699394.517785] server systemd[1]: Finished Rebuild Journal Catalog.55server # [699394.520336] server systemd[1]: Starting Update is Completed...56server # [699394.533053] server systemd[1]: Finished Update is Completed.57server # [699394.534081] server systemd[1]: Reached target System Initialization.58server # [699394.534253] server systemd[1]: Discard unused filesystem blocks once a week skipped, unmet condition check ConditionVirtualization=!container59server # [699394.534306] server systemd[1]: Started Daily Cleanup of Temporary Directories.60server # [699394.534335] server systemd[1]: Reached target Timer Units.61server # [699394.534490] server systemd[1]: Listening on D-Bus System Message Bus Socket.62server # [699394.534745] server systemd[1]: Listening on Nix Daemon Socket.63server # [699394.534905] server systemd[1]: Listening on Virtual Machine and Container Registration Service Socket.64server # [699394.534940] server systemd[1]: Reached target Socket Units.65server # [699394.534994] server systemd[1]: Reached target Basic System.66server # [699394.536636] server systemd[1]: Starting Import lastlog data into lastlog2 database...67server # [699394.537955] server systemd[1]: Starting Name Service Cache Daemon (nsncd)...68server # [699394.540838] server systemd[1]: Starting resolvconf update...69server # [699394.563878] server systemd[1]: Finished Import lastlog data into lastlog2 database.70server # [699394.628090] server systemd[1]: etc-machine\x2did.mount: Deactivated successfully.71server # [699394.629760] server systemd[1]: Finished Save Transient machine-id to Disk.72server # [699394.637722] server systemd[1]: nscd.service: Deactivated successfully.73server # [699394.637888] server systemd[1]: Stopped Name Service Cache Daemon (nsncd).74server # [699394.642720] server systemd[1]: Starting Name Service Cache Daemon (nsncd)...75server # [699394.668742] server resolvconf-start[236]: setfacl: /run/resolvconf: Operation not supported76server # [699394.670108] server systemd[1]: resolvconf.service: Main process exited, code=exited, status=1/FAILURE77server # [699394.670236] server systemd[1]: resolvconf.service: Failed with result 'exit-code'.78server # [699394.670405] server systemd[1]: Failed to start resolvconf update.79server # [699394.670680] server systemd[1]: Reached target Preparation for Network.80server # [699394.672183] server systemd[1]: Starting Address configuration of eth1...81server # [699394.673466] server systemd[1]: Starting Extra networking commands....82server # [699394.696694] server network-addresses-eth1-start[238]: adding address 192.168.1.1/24... done83server # [699394.700417] server network-addresses-eth1-start[238]: adding address 2001:db8:1::1/64... done84server # [699394.705999] server systemd[1]: Finished Address configuration of eth1.85server # [699394.756935] server systemd[1]: Finished Extra networking commands..86server # [699394.757074] server systemd[1]: Reached target Network.87server # [699394.758648] server systemd[1]: Starting Nginx Web Server...88server # [699394.759996] server systemd[1]: Starting PostgreSQL Server...89server # [699394.891758] server nsncd[224]: Sep 28 16:50:09.612 INFO started, config: Config { ignored_request_types: {}, worker_count: 8, handoff_timeout: 10s }, path: "/var/run/nscd/socket"90server # [699394.891794] server systemd[1]: Started Name Service Cache Daemon (nsncd).91server # [699394.892321] server systemd[1]: Reached target Host and Network Name Lookups.92server # [699394.892415] server systemd[1]: Reached target User and Group Name Lookups.93server # [699394.913143] server systemd[1]: Starting User Login Management...94server # [699394.915695] server systemd[1]: Starting Permit User Sessions...95server # [699394.926545] server systemd[1]: Finished Permit User Sessions.96server # [699394.928751] server systemd[1]: Started Console Getty.97server # [699394.928795] server systemd[1]: Getty on tty1 skipped, unmet condition check ConditionPathExists=/dev/tty098server # [699394.928815] server systemd[1]: Reached target Login Prompts.99server # [699396.242574] server systemd-logind[314]: New seat seat0.100server # [699396.244370] server systemd[1]: Starting D-Bus System Message Bus...101server # [699396.244493] server systemd[1]: Started User Login Management.102server # [699396.247448] server systemd[1]: Starting linger-users.service...103server # [699396.272305] server systemd[1]: linger-users.service: Deactivated successfully.104server # [699396.272484] server systemd[1]: Finished linger-users.service.105server # [699396.311097] server nginx-pre-start[328]: nginx: the configuration file /nix/store/9cl6v9vlqwp98sh6pkpsmqxkc0blkskg-nginx.conf syntax is ok106server # [699396.311828] server nginx-pre-start[328]: nginx: configuration file /nix/store/9cl6v9vlqwp98sh6pkpsmqxkc0blkskg-nginx.conf test is successful107server # [699396.319927] server systemd[1]: Started Nginx Web Server.108server # [699396.386915] server postgresql-pre-start[335]: The files belonging to this database system will be owned by user "postgres".109server # [699396.386915] server postgresql-pre-start[335]: This user must also own the server process.110server # [699396.387571] server postgresql-pre-start[335]: The database cluster will be initialized with locale "en_US.UTF-8".111server # [699396.387571] server postgresql-pre-start[335]: The default database encoding has accordingly been set to "UTF8".112server # [699396.387571] server postgresql-pre-start[335]: The default text search configuration will be set to "english".113server # [699396.387571] server postgresql-pre-start[335]: Data page checksums are disabled.114server # [699396.387571] server postgresql-pre-start[335]: fixing permissions on existing directory /var/lib/postgresql/17 ... ok115server # [699396.388311] server postgresql-pre-start[335]: creating subdirectories ... ok116server # [699396.388483] server postgresql-pre-start[335]: selecting dynamic shared memory implementation ... posix117server # [699396.414117] server postgresql-pre-start[335]: selecting default "max_connections" ... 100118server # [699396.441184] server postgresql-pre-start[335]: selecting default "shared_buffers" ... 128MB119server # [699396.760257] server dbus-broker-launch[324]: Looking up NSS user entry for 'systemd-timesync'...120server # [699396.761299] server dbus-broker-launch[324]: NSS returned no entry for 'systemd-timesync'121server # [699396.761299] server dbus-broker-launch[324]: Invalid user-name in /nix/store/4h0cgqkfbcd6hf0j42k7nxs6ccpdj6ax-system-path/share/dbus-1/system.d/org.freedesktop.timesync1.conf +16: user="systemd-timesync"122server # [699396.776905] server systemd[1]: Started D-Bus System Message Bus.123server # [699396.788247] server dbus-broker-launch[324]: Ready124server # [699398.001807] server postgresql-pre-start[335]: selecting default time zone ... UTC125server # [699398.002568] server postgresql-pre-start[335]: creating configuration files ... ok126server # [699398.169925] server postgresql-pre-start[335]: running bootstrap script ... ok127server # [699398.667339] server postgresql-pre-start[335]: performing post-bootstrap initialization ... ok128server # [699399.398051] server postgresql-pre-start[335]: syncing data to disk ... ok129server # [699399.398051] server postgresql-pre-start[335]: initdb: warning: enabling "trust" authentication for local connections130server # [699399.398051] server postgresql-pre-start[335]: 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.131server # [699399.398051] server postgresql-pre-start[335]: Success. You can now start the database server using:132server # [699399.398051] server postgresql-pre-start[335]: pg_ctl -D /var/lib/postgresql/17 -l logfile start133server # [699400.778921] server postgres[350]: [350] LOG: starting PostgreSQL 17.10 on aarch64-unknown-linux-gnu, compiled by clang version 21.1.8, 64-bit134server # [699400.780073] server postgres[350]: [350] LOG: listening on IPv6 address "::1", port 5432135server # [699400.780073] server postgres[350]: [350] LOG: listening on IPv4 address "127.0.0.1", port 5432136server # [699400.783609] server postgres[350]: [350] LOG: listening on Unix socket "/run/postgresql/.s.PGSQL.5432"137server # [699400.792322] server postgres[356]: [356] LOG: database system was shut down at 2026-09-28 16:50:13 GMT138server # [699400.802245] server postgres[350]: [350] LOG: database system is ready to accept connections139server # [699400.806697] server systemd[1]: Started PostgreSQL Server.140server # [699400.813224] server systemd[1]: Starting PostgreSQL Setup Scripts...141server # [699400.964503] server postgresql-setup-start[367]: CREATE DATABASE142server # [699400.996505] server postgresql-setup-start[372]: CREATE ROLE143server # [699400.997876] server systemd[1]: Finished PostgreSQL Setup Scripts.144server # [699400.999139] server systemd[1]: Reached target PostgreSQL.145server # [699401.000563] server systemd[1]: Starting Mobilizon PostgreSQL setup...146server # [699401.567118] server mobilizon-postgresql-start[376]: CREATE EXTENSION147server # [699401.567118] server mobilizon-postgresql-start[376]: CREATE EXTENSION148server # [699401.567118] server mobilizon-postgresql-start[376]: CREATE EXTENSION149server # [699401.582267] server mobilizon-postgresql-start[378]: ALTER DATABASE150server # [699401.585034] server systemd[1]: mobilizon-postgresql.service: Deactivated successfully.151server # [699401.605145] server systemd[1]: Finished Mobilizon PostgreSQL setup.152server # [699401.607665] server systemd[1]: Starting Mobilizon setup secrets...153server # [699401.621792] server mobilizon-setup-secrets-start[381]: + '[' '!' -f /var/lib/mobilizon/secret-env.sh ']'154server # [699401.621792] server mobilizon-setup-secrets-start[381]: + install -m 600 /dev/null /var/lib/mobilizon/secret-env.sh155server # [699401.624925] server mobilizon-setup-secrets-start[381]: + cat156server # [699401.626437] 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))'157server: still waiting for container 'server' to reach ready state...158server # [699402.122976] 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))'159server # [699402.613985] 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)))'160server # [699403.068606] server systemd[1]: mobilizon-setup-secrets.service: Deactivated successfully.161server # [699403.068873] server systemd[1]: Finished Mobilizon setup secrets.162server # [699403.069125] server systemd[1]: mobilizon-setup-secrets.service: Consumed 1.949s CPU time over 1.460s wall clock time.163server # [699403.071105] server systemd[1]: Starting Mobilizon federated organization and mobilization platform...164server # [699404.082448] server mobilizon_ctl[536]: Loading app..165server # [699404.084594] server mobilizon_ctl[536]: Starting dependencies..166server # [699407.393563] server mobilizon_ctl[536]: #########################################################167server # [699407.393563] server mobilizon_ctl[536]: # If the CREATE EXTENSION or DROP EXTENSION calls fail, #168server # [699407.393563] server mobilizon_ctl[536]: # please manually execute them with an authorized #169server # [699407.393563] server mobilizon_ctl[536]: # PostgreSQL user with SUPER USER role. #170server # [699407.393563] server mobilizon_ctl[536]: #########################################################171server # [699407.393563] server mobilizon_ctl[536]:172server # [699407.393563] server mobilizon_ctl[536]:173server # [699407.393563] server mobilizon_ctl[536]: 16:50:22.110 [info] == Running 20180109150000 Mobilizon.Repo.Migrations.Prerequites.up/0 forward174server # [699407.395099] server mobilizon_ctl[536]: 16:50:22.116 [info] execute "CREATE TYPE datetimetz AS (\n dt timestamptz,\n tz varchar\n);\n"175server # [699407.396521] server mobilizon_ctl[536]: 16:50:22.117 [info] execute "CREATE EXTENSION IF NOT EXISTS postgis"176server # [699407.397031] server mobilizon_ctl[536]: 16:50:22.118 [info] extension "postgis" already exists, skipping177server # [699407.397259] server mobilizon_ctl[536]: 16:50:22.118 [info] execute "CREATE EXTENSION IF NOT EXISTS pg_trgm"178server # [699407.397704] server mobilizon_ctl[536]: 16:50:22.118 [info] extension "pg_trgm" already exists, skipping179server # [699407.397704] server mobilizon_ctl[536]: 16:50:22.118 [info] execute "CREATE EXTENSION IF NOT EXISTS unaccent"180server # [699407.397704] server mobilizon_ctl[536]: 16:50:22.118 [info] extension "unaccent" already exists, skipping181server # [699407.399487] server mobilizon_ctl[536]: 16:50:22.120 [info] == Migrated 20180109150000 in 0.0s182server # [699407.443089] server mobilizon_ctl[536]: 16:50:22.164 [info] == Running 20180109165738 Mobilizon.Repo.Migrations.CreateAccounts.change/0 forward183server # [699407.443613] server mobilizon_ctl[536]: 16:50:22.164 [info] create table accounts184server # [699407.447970] server mobilizon_ctl[536]: 16:50:22.169 [info] create index accounts_username_domain_index185server # [699407.449638] server mobilizon_ctl[536]: 16:50:22.170 [info] == Migrated 20180109165738 in 0.0s186server # [699407.458510] server mobilizon_ctl[536]: 16:50:22.179 [info] == Running 20180109170315 Mobilizon.Repo.Migrations.CreateUsers.change/0 forward187server # [699407.458947] server mobilizon_ctl[536]: 16:50:22.180 [info] create table users188server # [699407.463301] server mobilizon_ctl[536]: 16:50:22.184 [info] create index users_email_index189server # [699407.464482] server mobilizon_ctl[536]: 16:50:22.185 [info] == Migrated 20180109170315 in 0.0s190server # [699407.469550] server mobilizon_ctl[536]: 16:50:22.190 [info] == Running 20180110091747 Mobilizon.Repo.Migrations.CreateCategories.change/0 forward191server # [699407.469908] server mobilizon_ctl[536]: 16:50:22.190 [info] create table categories192server # [699407.472838] server mobilizon_ctl[536]: 16:50:22.194 [info] create index categories_title_index193server # [699407.473921] server mobilizon_ctl[536]: 16:50:22.194 [info] == Migrated 20180110091747 in 0.0s194server # [699407.480122] server mobilizon_ctl[536]: 16:50:22.201 [info] == Running 20180110092400 Mobilizon.Repo.Migrations.CreateAddresses.change/0 forward195server # [699407.480403] server mobilizon_ctl[536]: 16:50:22.201 [info] create table addresses196server # [699407.483936] server mobilizon_ctl[536]: 16:50:22.204 [info] == Migrated 20180110092400 in 0.0s197server # [699407.492109] server mobilizon_ctl[536]: 16:50:22.213 [info] == Running 20180110092500 Mobilizon.Repo.Migrations.CreateGroups.change/0 forward198server # [699407.493273] server mobilizon_ctl[536]: 16:50:22.213 [info] create table groups199server # [699407.497405] server mobilizon_ctl[536]: 16:50:22.218 [info] create index groups_slug_index200server # [699407.498510] server mobilizon_ctl[536]: 16:50:22.219 [info] == Migrated 20180110092500 in 0.0s201server # [699407.504345] server mobilizon_ctl[536]: 16:50:22.225 [info] == Running 20180110092600 Mobilizon.Repo.Migrations.CreateEvents.change/0 forward202server # [699407.504718] server mobilizon_ctl[536]: 16:50:22.225 [info] create table events203server # [699407.511098] server mobilizon_ctl[536]: 16:50:22.232 [info] create index events_organizer_account_id_index204server # [699407.512271] server mobilizon_ctl[536]: 16:50:22.233 [info] create index events_organizer_group_id_index205server # [699407.513192] server mobilizon_ctl[536]: 16:50:22.234 [info] create index events_slug_index206server # [699407.513911] server mobilizon_ctl[536]: 16:50:22.235 [info] == Migrated 20180110092600 in 0.0s207server # [699407.521585] server mobilizon_ctl[536]: 16:50:22.242 [info] == Running 20180110093905 Mobilizon.Repo.Migrations.CreateTags.change/0 forward208server # [699407.521879] server mobilizon_ctl[536]: 16:50:22.243 [info] create table tags209server # [699407.525726] server mobilizon_ctl[536]: 16:50:22.246 [info] create index tags_slug_index210server # [699407.526192] server mobilizon_ctl[536]: 16:50:22.247 [info] == Migrated 20180110093905 in 0.0s211server # [699407.533915] server mobilizon_ctl[536]: 16:50:22.255 [info] == Running 20180110093906 Mobilizon.Repo.Migrations.CreateEventsTags.change/0 forward212server # [699407.534212] server mobilizon_ctl[536]: 16:50:22.255 [info] create table events_tags213server # [699407.536496] server mobilizon_ctl[536]: 16:50:22.257 [info] == Migrated 20180110093906 in 0.0s214server # [699407.543752] server mobilizon_ctl[536]: 16:50:22.264 [info] == Running 20180110094301 Mobilizon.Repo.Migrations.CreateParticipants.change/0 forward215server # [699407.544148] server mobilizon_ctl[536]: 16:50:22.265 [info] create table participants216server # [699407.547327] server mobilizon_ctl[536]: 16:50:22.268 [info] create index participants_event_id_index217server # [699407.548265] server mobilizon_ctl[536]: 16:50:22.269 [info] create index participants_account_id_index218server # [699407.549242] server mobilizon_ctl[536]: 16:50:22.270 [info] == Migrated 20180110094301 in 0.0s219server # [699407.560369] server mobilizon_ctl[536]: 16:50:22.281 [info] == Running 20180110094502 Mobilizon.Repo.Migrations.CreateEventRequests.change/0 forward220server # [699407.560931] server mobilizon_ctl[536]: 16:50:22.281 [info] create table event_requests221server # [699407.563890] server mobilizon_ctl[536]: 16:50:22.284 [info] create index event_requests_event_id_index222server # [699407.564424] server mobilizon_ctl[536]: 16:50:22.285 [info] create index event_requests_account_id_index223server # [699407.566203] server mobilizon_ctl[536]: 16:50:22.287 [info] == Migrated 20180110094502 in 0.0s224server # [699407.573470] server mobilizon_ctl[536]: 16:50:22.294 [info] == Running 20180110095317 Mobilizon.Repo.Migrations.CreateMembers.change/0 forward225server # [699407.573915] server mobilizon_ctl[536]: 16:50:22.295 [info] create table members226server # [699407.575926] server mobilizon_ctl[536]: 16:50:22.297 [info] create index members_group_id_index227server # [699407.576896] server mobilizon_ctl[536]: 16:50:22.298 [info] create index members_account_id_index228server # [699407.577727] server mobilizon_ctl[536]: 16:50:22.298 [info] == Migrated 20180110095317 in 0.0s229server # [699407.583555] server mobilizon_ctl[536]: 16:50:22.304 [info] == Running 20180110095515 Mobilizon.Repo.Migrations.CreateGroupRequests.change/0 forward230server # [699407.584048] server mobilizon_ctl[536]: 16:50:22.305 [info] create table group_requests231server # [699407.586840] server mobilizon_ctl[536]: 16:50:22.308 [info] create index group_requests_group_id_index232server # [699407.587731] server mobilizon_ctl[536]: 16:50:22.308 [info] create index group_requests_account_id_index233server # [699407.588782] server mobilizon_ctl[536]: 16:50:22.309 [info] == Migrated 20180110095515 in 0.0s234server # [699407.592969] server mobilizon_ctl[536]: 16:50:22.314 [info] == Running 20180110165029 Mobilizon.Repo.Migrations.Guardian.DB.change/0 forward235server # [699407.593148] server mobilizon_ctl[536]: 16:50:22.314 [info] create table guardian_tokens236server # [699407.595719] server mobilizon_ctl[536]: 16:50:22.316 [info] == Migrated 20180110165029 in 0.0s237server # [699407.601810] server mobilizon_ctl[536]: 16:50:22.322 [info] == Running 20180112100000 Mobilizon.Repo.Migrations.CreateTracks.change/0 forward238server # [699407.602174] server mobilizon_ctl[536]: 16:50:22.323 [info] create table tracks239server # [699407.605090] server mobilizon_ctl[536]: 16:50:22.326 [info] == Migrated 20180112100000 in 0.0s240server # [699407.610192] server mobilizon_ctl[536]: 16:50:22.331 [info] == Running 20180112105354 Mobilizon.Repo.Migrations.CreateSessions.change/0 forward241server # [699407.610646] server mobilizon_ctl[536]: 16:50:22.331 [info] create table sessions242server # [699407.614413] server mobilizon_ctl[536]: 16:50:22.335 [info] == Migrated 20180112105354 in 0.0s243server # [699407.623265] server mobilizon_ctl[536]: 16:50:22.344 [info] == Running 20180430071244 Mobilizon.Repo.Migrations.RemoveUri.up/0 forward244server # [699407.623619] server mobilizon_ctl[536]: 16:50:22.344 [info] alter table accounts245server # [699407.624732] server mobilizon_ctl[536]: 16:50:22.345 [info] alter table groups246server # [699407.625465] server mobilizon_ctl[536]: 16:50:22.346 [info] == Migrated 20180430071244 in 0.0s247server # [699407.631417] server mobilizon_ctl[536]: 16:50:22.352 [info] == Running 20180515091106 Mobilizon.Repo.Migrations.AddUrlFieldToEvents.up/0 forward248server # [699407.631720] server mobilizon_ctl[536]: 16:50:22.352 [info] alter table events249server # [699407.632750] server mobilizon_ctl[536]: 16:50:22.353 [info] == Migrated 20180515091106 in 0.0s250server # [699407.635645] server mobilizon_ctl[536]: 16:50:22.356 [info] == Running 20180515100237 Mobilizon.Repo.Migrations.CreateComments.change/0 forward251server # [699407.635933] server mobilizon_ctl[536]: 16:50:22.357 [info] create table comments252server # [699407.640748] server mobilizon_ctl[536]: 16:50:22.361 [info] == Migrated 20180515100237 in 0.0s253server # [699407.648119] server mobilizon_ctl[536]: 16:50:22.369 [info] == Running 20180515142835 Mobilizon.Repo.Migrations.AlterEventTimestampsToDateTimeWithTimeZone.up/0 forward254server # [699407.649191] server mobilizon_ctl[536]: 16:50:22.370 [info] alter table events255server # [699407.650352] server mobilizon_ctl[536]: 16:50:22.371 [info] == Migrated 20180515142835 in 0.0s256server # [699407.656696] server mobilizon_ctl[536]: 16:50:22.377 [info] == Running 20180515145438 Mobilizon.Repo.Migrations.AddLocalAttributeToEventsAndComments.up/0 forward257server # [699407.656920] server mobilizon_ctl[536]: 16:50:22.378 [info] alter table events258server # [699407.657766] server mobilizon_ctl[536]: 16:50:22.378 [info] alter table comments259server # [699407.658624] server mobilizon_ctl[536]: 16:50:22.379 [info] == Migrated 20180515145438 in 0.0s260server # [699407.664377] server mobilizon_ctl[536]: 16:50:22.385 [info] == Running 20180517100700 Mobilizon.Repo.Migrations.MoveFromAccountToActor.up/0 forward261server # [699407.667366] server mobilizon_ctl[536]: 16:50:22.388 [info] drop table event_requests262server # [699407.669552] server mobilizon_ctl[536]: 16:50:22.390 [info] drop table group_requests263server # [699407.670743] server mobilizon_ctl[536]: 16:50:22.391 [info] alter table events264server # [699407.671842] server mobilizon_ctl[536]: 16:50:22.393 [info] rename column account_id to actor_id on table members265server # [699407.672265] server mobilizon_ctl[536]: 16:50:22.393 [info] alter table members266server # [699407.674284] server mobilizon_ctl[536]: 16:50:22.395 [info] drop table groups267server # [699407.675644] server mobilizon_ctl[536]: 16:50:22.396 [info] rename table accounts to actors268server # [699407.675981] server mobilizon_ctl[536]: 16:50:22.397 [info] execute "CREATE TYPE public.actor_type AS ENUM ('Person', 'Application', 'Group', 'Organization', 'Service')"269server # [699407.677047] server mobilizon_ctl[536]: 16:50:22.398 [info] rename column username to name on table actors270server # [699407.678301] server mobilizon_ctl[536]: 16:50:22.399 [info] rename column description to summary on table actors271server # [699407.678923] server mobilizon_ctl[536]: 16:50:22.400 [info] rename column display_name to preferred_username on table actors272server # [699407.679467] server mobilizon_ctl[536]: 16:50:22.400 [info] alter table actors273server # [699407.682451] server mobilizon_ctl[536]: 16:50:22.403 [info] create index actors_preferred_username_domain_index274server # [699407.683691] server mobilizon_ctl[536]: 16:50:22.404 [info] rename column organizer_account_id to organizer_actor_id on table events275server # [699407.684108] server mobilizon_ctl[536]: 16:50:22.405 [info] rename column account_id to actor_id on table participants276server # [699407.684961] server mobilizon_ctl[536]: 16:50:22.405 [info] create table followers277server # [699407.689426] server mobilizon_ctl[536]: 16:50:22.410 [info] rename column account_id to actor_id on table comments278server # [699407.690157] server mobilizon_ctl[536]: 16:50:22.411 [info] rename column account_id to actor_id on table users279server # [699407.690860] server mobilizon_ctl[536]: 16:50:22.411 [info] == Migrated 20180517100700 in 0.0s280server # [699407.700777] server mobilizon_ctl[536]: 16:50:22.421 [info] == Running 20180522133844 Mobilizon.Repo.Migrations.AddBotsTable.up/0 forward281server # [699407.700964] server mobilizon_ctl[536]: 16:50:22.422 [info] create table bots282server # [699407.705845] server mobilizon_ctl[536]: 16:50:22.426 [info] == Migrated 20180522133844 in 0.0s283server # [699407.714721] server mobilizon_ctl[536]: 16:50:22.435 [info] == Running 20180530125159 Mobilizon.Repo.Migrations.AddAvatarAndBannerToActor.up/0 forward284server # [699407.714894] server mobilizon_ctl[536]: 16:50:22.435 [info] alter table actors285server # [699407.716273] server mobilizon_ctl[536]: 16:50:22.437 [info] == Migrated 20180530125159 in 0.0s286server # [699407.719502] server mobilizon_ctl[536]: 16:50:22.440 [info] == Running 20180530152323 Mobilizon.Repo.Migrations.MakeActorPublicKeyNullable.up/0 forward287server # [699407.719624] server mobilizon_ctl[536]: 16:50:22.440 [info] alter table actors288server # [699407.721099] server mobilizon_ctl[536]: 16:50:22.442 [info] == Migrated 20180530152323 in 0.0s289server # [699407.727653] server mobilizon_ctl[536]: 16:50:22.448 [info] == Running 20180530170808 Mobilizon.Repo.Migrations.AddUUIDIdToEvents.up/0 forward290server # [699407.727653] server mobilizon_ctl[536]: 16:50:22.448 [info] alter table events291server # [699407.728815] server mobilizon_ctl[536]: 16:50:22.449 [info] == Migrated 20180530170808 in 0.0s292server # [699407.732223] server mobilizon_ctl[536]: 16:50:22.453 [info] == Running 20180531162301 Mobilizon.Repo.Migrations.AddApprovedStatusToMember.up/0 forward293server # [699407.732436] server mobilizon_ctl[536]: 16:50:22.453 [info] alter table members294server # [699407.733479] server mobilizon_ctl[536]: 16:50:22.454 [info] == Migrated 20180531162301 in 0.0s295server # [699407.738666] server mobilizon_ctl[536]: 16:50:22.459 [info] == Running 20180607095732 Mobilizon.Repo.Migrations.AddUUIDToComments.up/0 forward296server # [699407.738879] server mobilizon_ctl[536]: 16:50:22.460 [info] alter table comments297server # [699407.739645] server mobilizon_ctl[536]: 16:50:22.460 [info] == Migrated 20180607095732 in 0.0s298server # [699407.745754] server mobilizon_ctl[536]: 16:50:22.466 [info] == Running 20180614094653 Mobilizon.Repo.Migrations.MakeSharedInboxUrlNullable.up/0 forward299server # [699407.745963] server mobilizon_ctl[536]: 16:50:22.467 [info] alter table actors300server # [699407.747765] server mobilizon_ctl[536]: 16:50:22.468 [info] == Migrated 20180614094653 in 0.0s301server # [699407.754187] server mobilizon_ctl[536]: 16:50:22.475 [info] == Running 20180614104618 Mobilizon.Repo.Migrations.FusionPublicPrivateKeyIntoKeysColumn.up/0 forward302server # [699407.754349] server mobilizon_ctl[536]: 16:50:22.475 [info] rename column private_key to keys on table actors303server # [699407.754859] server mobilizon_ctl[536]: 16:50:22.476 [info] alter table actors304server # [699407.755689] server mobilizon_ctl[536]: 16:50:22.476 [info] == Migrated 20180614104618 in 0.0s305server # [699407.760975] server mobilizon_ctl[536]: 16:50:22.482 [info] == Running 20180614131328 Mobilizon.Repo.Migrations.AddAttributedToFieldToEventsAndComments.up/0 forward306server # [699407.761280] server mobilizon_ctl[536]: 16:50:22.482 [info] alter table events307server # [699407.763349] server mobilizon_ctl[536]: 16:50:22.484 [info] alter table comments308server # [699407.765137] server mobilizon_ctl[536]: 16:50:22.486 [info] == Migrated 20180614131328 in 0.0s309server # [699407.771708] server mobilizon_ctl[536]: 16:50:22.492 [info] == Running 20180628091920 :"Elixir.Mobilizon.Repo.Migrations.Add-user-confirm-email-fields".up/0 forward310server # [699407.772054] server mobilizon_ctl[536]: 16:50:22.493 [info] alter table users311server # [699407.773039] server mobilizon_ctl[536]: 16:50:22.494 [info] create index index_unique_users_confirmation_token312server # [699407.774691] server mobilizon_ctl[536]: 16:50:22.495 [info] == Migrated 20180628091920 in 0.0s313server # [699407.779116] server mobilizon_ctl[536]: 16:50:22.500 [info] == Running 20180628130746 :"Elixir.Mobilizon.Repo.Migrations.Add-user-password-reset-fields".up/0 forward314server # [699407.779259] server mobilizon_ctl[536]: 16:50:22.500 [info] alter table users315server # [699407.779959] server mobilizon_ctl[536]: 16:50:22.501 [info] create index index_unique_users_reset_password_token316server # [699407.781504] server mobilizon_ctl[536]: 16:50:22.502 [info] == Migrated 20180628130746 in 0.0s317server # [699407.788257] server mobilizon_ctl[536]: 16:50:22.509 [info] == Running 20180628142835 Mobilizon.Repo.Migrations.RevertAlterEventTimestampsToDateTimeWithTimeZone.up/0 forward318server # [699407.788387] server mobilizon_ctl[536]: 16:50:22.509 [info] alter table events319server # [699407.789920] server mobilizon_ctl[536]: 16:50:22.510 [info] == Migrated 20180628142835 in 0.0s320server # [699407.796120] server mobilizon_ctl[536]: 16:50:22.517 [info] == Running 20180702150922 Mobilizon.Repo.Migrations.AddAddressType.up/0 forward321server # [699407.796234] server mobilizon_ctl[536]: 16:50:22.517 [info] alter table events322server # [699407.797398] server mobilizon_ctl[536]: 16:50:22.518 [info] drop constraint events_address_id_fkey from table events323server # [699407.798141] server mobilizon_ctl[536]: 16:50:22.519 [info] rename column address_id to physical_address_id on table events324server # [699407.798359] server mobilizon_ctl[536]: 16:50:22.519 [info] alter table events325server # [699407.799713] server mobilizon_ctl[536]: 16:50:22.520 [info] == Migrated 20180702150922 in 0.0s326server # [699407.806064] server mobilizon_ctl[536]: 16:50:22.527 [info] == Running 20180702154630 Mobilizon.Repo.Migrations.RemoveSlugForEvent.up/0 forward327server # [699407.806208] server mobilizon_ctl[536]: 16:50:22.527 [info] alter table events328server # [699407.807277] server mobilizon_ctl[536]: 16:50:22.528 [info] == Migrated 20180702154630 in 0.0s329server # [699407.813673] server mobilizon_ctl[536]: 16:50:22.534 [info] == Running 20180706082208 Mobilizon.Repo.Migrations.AlterEventsSetDescriptionAsText.up/0 forward330server # [699407.814661] server mobilizon_ctl[536]: 16:50:22.535 [info] alter table events331server # [699407.816079] server mobilizon_ctl[536]: 16:50:22.536 [info] == Migrated 20180706082208 in 0.0s332server # [699407.825051] server mobilizon_ctl[536]: 16:50:22.545 [info] == Running 20180709154152 Mobilizon.Repo.Migrations.AllowMultipleAccountsForUser.up/0 forward333server # [699407.825710] server mobilizon_ctl[536]: 16:50:22.546 [info] alter table actors334server # [699407.827418] server mobilizon_ctl[536]: 16:50:22.548 [info] alter table users335server # [699407.828658] server mobilizon_ctl[536]: 16:50:22.549 [info] == Migrated 20180709154152 in 0.0s336server # [699407.836175] server mobilizon_ctl[536]: 16:50:22.557 [info] == Running 20180802133951 Mobilizon.Repo.Migrations.MakeFollowerTableUnique.up/0 forward337server # [699407.836596] server mobilizon_ctl[536]: 16:50:22.557 [info] create index followers_actor_target_actor_unique_index338server # [699407.838856] server mobilizon_ctl[536]: 16:50:22.559 [info] == Migrated 20180802133951 in 0.0s339server # [699407.844416] server mobilizon_ctl[536]: 16:50:22.565 [info] == Running 20180816093446 Mobilizon.Repo.Migrations.AddPrimaryKeyToMember.up/0 forward340server # [699407.844693] server mobilizon_ctl[536]: 16:50:22.565 [info] execute "ALTER TABLE members DROP CONSTRAINT IF EXISTS members_pkey"341server # [699407.845428] server mobilizon_ctl[536]: 16:50:22.566 [info] constraint "members_pkey" of relation "members" does not exist, skipping342server # [699407.845480] server mobilizon_ctl[536]: 16:50:22.566 [info] drop index if exists members_members_account_id_index_index343server # [699407.845971] server mobilizon_ctl[536]: 16:50:22.567 [info] index "members_members_account_id_index_index" does not exist, skipping344server # [699407.846021] server mobilizon_ctl[536]: 16:50:22.567 [info] create index members_actor_parent_unique_index345server # [699407.847116] server mobilizon_ctl[536]: 16:50:22.568 [info] alter table members346server # [699407.850472] server mobilizon_ctl[536]: 16:50:22.571 [info] == Migrated 20180816093446 in 0.0s347server # [699407.856808] server mobilizon_ctl[536]: 16:50:22.577 [info] == Running 20181021161324 Mobilizon.Repo.Migrations.AddDefaultActorUserField.up/0 forward348server # [699407.856955] server mobilizon_ctl[536]: 16:50:22.578 [info] alter table users349server # [699407.858025] server mobilizon_ctl[536]: 16:50:22.579 [info] == Migrated 20181021161324 in 0.0s350server # [699407.864885] server mobilizon_ctl[536]: 16:50:22.585 [info] == Running 20181108165151 Mobilizon.Repo.Migrations.FixCommentsReferences.up/0 forward351server # [699407.865131] server mobilizon_ctl[536]: 16:50:22.586 [info] drop constraint comments_in_reply_to_comment_id_fkey from table comments352server # [699407.865951] server mobilizon_ctl[536]: 16:50:22.587 [info] drop constraint comments_origin_comment_id_fkey from table comments353server # [699407.866745] server mobilizon_ctl[536]: 16:50:22.587 [info] alter table comments354server # [699407.869104] server mobilizon_ctl[536]: 16:50:22.589 [info] == Migrated 20181108165151 in 0.0s355server # [699407.876282] server mobilizon_ctl[536]: 16:50:22.597 [info] == Running 20181203092128 Mobilizon.Repo.Migrations.ChangeActorsIndexes.up/0 forward356server # [699407.876754] server mobilizon_ctl[536]: 16:50:22.597 [info] drop index actors_preferred_username_domain_index357server # [699407.877608] server mobilizon_ctl[536]: 16:50:22.598 [info] drop index accounts_username_domain_index358server # [699407.878444] server mobilizon_ctl[536]: 16:50:22.599 [info] execute "ALTER INDEX accounts_pkey RENAME TO actors_pkey"359server # [699407.878939] server mobilizon_ctl[536]: 16:50:22.600 [info] create index actors_preferred_username_domain_type_index360server # [699407.880264] server mobilizon_ctl[536]: 16:50:22.601 [info] create index actors_url_index361server # [699407.881791] server mobilizon_ctl[536]: 16:50:22.602 [info] == Migrated 20181203092128 in 0.0s362server # [699407.890471] server mobilizon_ctl[536]: 16:50:22.611 [info] == Running 20190103150805 Mobilizon.Repo.Migrations.FixEventVisibility.up/0 forward363server # [699407.890641] server mobilizon_ctl[536]: 16:50:22.611 [info] execute "CREATE TYPE public.event_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')"364server # [699407.891268] server mobilizon_ctl[536]: 16:50:22.612 [info] execute "CREATE TYPE public.event_status AS ENUM ('tentative', 'confirmed', 'cancelled')"365server # [699407.892870] server mobilizon_ctl[536]: 16:50:22.613 [info] execute "CREATE TYPE public.comment_visibility AS ENUM ('public', 'unlisted', 'private', 'moderated', 'invite')"366server # [699407.893392] server mobilizon_ctl[536]: 16:50:22.614 [info] alter table events367server # [699407.894962] server mobilizon_ctl[536]: 16:50:22.616 [info] alter table comments368server # [699407.895640] server mobilizon_ctl[536]: 16:50:22.616 [info] == Migrated 20190103150805 in 0.0s369server # [699407.900076] server mobilizon_ctl[536]: 16:50:22.621 [info] == Running 20190114162055 Mobilizon.Repo.Migrations.RemoveAddressType.up/0 forward370server # [699407.900194] server mobilizon_ctl[536]: 16:50:22.621 [info] execute "ALTER TABLE \"events\" DROP COLUMN IF EXISTS address_type"371server # [699407.901402] server mobilizon_ctl[536]: 16:50:22.622 [info] column "address_type" of relation "events" does not exist, skipping372server # [699407.902590] server mobilizon_ctl[536]: 16:50:22.622 [info] execute "DROP TYPE IF EXISTS address_type"373server # [699407.902590] server mobilizon_ctl[536]: 16:50:22.623 [info] type "address_type" does not exist, skipping374server # [699407.902879] server mobilizon_ctl[536]: 16:50:22.623 [info] rename column phone to phone_address on table events375server # [699407.903497] server mobilizon_ctl[536]: 16:50:22.624 [info] == Migrated 20190114162055 in 0.0s376server # [699407.908883] server mobilizon_ctl[536]: 16:50:22.630 [info] == Running 20190125143718 Mobilizon.Repo.Migrations.GroupDeleteMembersCascade.change/0 forward377server # [699407.909081] server mobilizon_ctl[536]: 16:50:22.630 [info] drop constraint members_account_id_fkey from table members378server # [699407.910067] server mobilizon_ctl[536]: 16:50:22.631 [info] drop constraint members_parent_id_fkey from table members379server # [699407.911001] server mobilizon_ctl[536]: 16:50:22.632 [info] alter table members380server # [699407.914258] server mobilizon_ctl[536]: 16:50:22.635 [info] == Migrated 20190125143718 in 0.0s381server # [699407.920847] server mobilizon_ctl[536]: 16:50:22.642 [info] == Running 20190130151607 Mobilizon.Repo.Migrations.SplitEventVisibilityAndJoinOptions.up/0 forward382server # [699407.920973] server mobilizon_ctl[536]: 16:50:22.642 [info] execute "ALTER TABLE events ALTER COLUMN visibility TYPE VARCHAR USING visibility::text"383server # [699407.924636] server mobilizon_ctl[536]: 16:50:22.645 [info] execute "DROP TYPE public.event_visibility"384server # [699407.925125] server mobilizon_ctl[536]: 16:50:22.646 [info] execute "CREATE TYPE public.event_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')"385server # [699407.926202] server mobilizon_ctl[536]: 16:50:22.647 [info] execute "ALTER TABLE events ALTER COLUMN visibility TYPE event_visibility USING visibility::event_visibility"386server # [699407.929129] server mobilizon_ctl[536]: 16:50:22.650 [info] execute "CREATE TYPE public.join_options AS ENUM ('free', 'restricted', 'invite', 'external')"387server # [699407.929884] server mobilizon_ctl[536]: 16:50:22.650 [info] alter table events388server # [699407.930761] server mobilizon_ctl[536]: 16:50:22.651 [info] execute "UPDATE events SET visibility = 'public' WHERE visibility IS NULL"389server # [699407.931493] server mobilizon_ctl[536]: 16:50:22.652 [info] alter table events390server # [699407.932308] server mobilizon_ctl[536]: 16:50:22.653 [info] == Migrated 20190130151607 in 0.0s391server # [699407.940851] server mobilizon_ctl[536]: 16:50:22.661 [info] == Running 20190207134142 Mobilizon.Repo.Migrations.MoveParticipantRoleToEnum.up/0 forward392server # [699407.941019] server mobilizon_ctl[536]: 16:50:22.662 [info] execute "CREATE TYPE public.participant_role AS ENUM ('not_approved', 'not_confirmed', 'rejected', 'participant', 'moderator', 'administrator', 'creator')"393server # [699407.942330] server mobilizon_ctl[536]: 16:50:22.663 [info] alter table participants394server # [699407.943738] server mobilizon_ctl[536]: 16:50:22.664 [info] execute "UPDATE participants set role_tmp = 'not_approved' where role = 0"395server # [699407.944909] server mobilizon_ctl[536]: 16:50:22.666 [info] execute "UPDATE participants set role_tmp = 'participant' where role = 1"396server # [699407.945444] server mobilizon_ctl[536]: 16:50:22.666 [info] execute "UPDATE participants set role_tmp = 'moderator' where role = 2"397server # [699407.945783] server mobilizon_ctl[536]: 16:50:22.667 [info] execute "UPDATE participants set role_tmp = 'administrator' where role = 3"398server # [699407.946241] server mobilizon_ctl[536]: 16:50:22.667 [info] execute "UPDATE participants set role_tmp = 'creator' where role = 4"399server # [699407.946894] server mobilizon_ctl[536]: 16:50:22.668 [info] alter table participants400server # [699407.947548] server mobilizon_ctl[536]: 16:50:22.668 [info] rename column role_tmp to role on table participants401server # [699407.947998] server mobilizon_ctl[536]: 16:50:22.669 [info] == Migrated 20190207134142 in 0.0s402server # [699407.958594] server mobilizon_ctl[536]: 16:50:22.679 [info] == Running 20190208141700 Mobilizon.Repo.Migrations.TagsRelations.up/0 forward403server # [699407.958870] server mobilizon_ctl[536]: 16:50:22.680 [info] create table tag_relations404server # [699407.961277] server mobilizon_ctl[536]: 16:50:22.682 [info] create check constraint no_self_loops_check on table tag_relations405server # [699407.961949] server mobilizon_ctl[536]: 16:50:22.683 [info] create index index_tag_relations_tag_id406server # [699407.963042] server mobilizon_ctl[536]: 16:50:22.684 [info] create index index_tag_relations_link_id407server # [699407.964484] server mobilizon_ctl[536]: 16:50:22.685 [info] == Migrated 20190208141700 in 0.0s408server # [699407.973790] server mobilizon_ctl[536]: 16:50:22.694 [info] == Running 20190214100858 Mobilizon.Repo.Migrations.DropDatetimetz.up/0 forward409server # [699407.973974] server mobilizon_ctl[536]: 16:50:22.695 [info] alter table events410server # [699407.975126] server mobilizon_ctl[536]: 16:50:22.696 [info] alter table sessions411server # [699407.975809] server mobilizon_ctl[536]: 16:50:22.697 [info] execute "DROP TYPE datetimetz"412server # [699407.976649] server mobilizon_ctl[536]: 16:50:22.697 [info] == Migrated 20190214100858 in 0.0s413server # [699407.981987] server mobilizon_ctl[536]: #########################################################414server # [699407.981987] server mobilizon_ctl[536]: # If the CREATE EXTENSION or DROP EXTENSION calls fail, #415server # [699407.981987] server mobilizon_ctl[536]: # please manually execute them with an authorized #416server # [699407.981987] server mobilizon_ctl[536]: # PostgreSQL user with SUPER USER role. #417server # [699407.981987] server mobilizon_ctl[536]: #########################################################418server # [699407.981987] server mobilizon_ctl[536]:419server # [699407.981987] server mobilizon_ctl[536]:420server # [699407.982286] server mobilizon_ctl[536]: 16:50:22.703 [info] == Running 20190219164310 Mobilizon.Repo.Migrations.CreateSearchIndexes.change/0 forward421server # [699407.982493] server mobilizon_ctl[536]: 16:50:22.703 [info] execute "CREATE EXTENSION IF NOT EXISTS pg_trgm"422server # [699407.983074] server mobilizon_ctl[536]: 16:50:22.704 [info] extension "pg_trgm" already exists, skipping423server # [699407.983155] server mobilizon_ctl[536]: 16:50:22.704 [info] execute "CREATE EXTENSION IF NOT EXISTS unaccent"424server # [699407.983527] server mobilizon_ctl[536]: 16:50:22.704 [info] extension "unaccent" already exists, skipping425server # [699407.983693] server mobilizon_ctl[536]: 16:50:22.704 [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;"426server # [699407.984413] server mobilizon_ctl[536]: 16:50:22.705 [info] execute "CREATE INDEX \"event_title_trigram\" ON \"events\" USING GIN (f_unaccent(title) gin_trgm_ops)"427server # [699407.986411] server mobilizon_ctl[536]: 16:50:22.707 [info] execute "CREATE INDEX \"actor_preferred_username_trigram\" ON \"actors\"\n USING GIN (f_unaccent(preferred_username) gin_trgm_ops)"428server # [699407.987471] server mobilizon_ctl[536]: 16:50:22.708 [info] execute "CREATE INDEX \"actor_name_trigram\" ON \"actors\"\n USING GIN (f_unaccent(name) gin_trgm_ops)"429server # [699407.988532] server mobilizon_ctl[536]: 16:50:22.709 [info] == Migrated 20190219164310 in 0.0s430server # [699407.996678] server mobilizon_ctl[536]: 16:50:22.717 [info] == Running 20190222151449 Mobilizon.Repo.Migrations.DropCategories.up/0 forward431server # [699407.996953] server mobilizon_ctl[536]: 16:50:22.718 [info] alter table events432server # [699407.998053] server mobilizon_ctl[536]: 16:50:22.719 [info] drop table categories433server # [699407.999968] server mobilizon_ctl[536]: 16:50:22.720 [info] == Migrated 20190222151449 in 0.0s434server # [699408.015379] server mobilizon_ctl[536]: 16:50:22.736 [info] == Running 20190301141830 Mobilizon.Repo.Migrations.MoveMemberRoleToEnum.up/0 forward435server # [699408.015558] server mobilizon_ctl[536]: 16:50:22.736 [info] execute "CREATE TYPE public.member_role AS ENUM ('invited', 'not_approved', 'member', 'moderator', 'administrator', 'creator', 'rejected')"436server # [699408.016305] server mobilizon_ctl[536]: 16:50:22.737 [info] alter table members437server # [699408.017378] server mobilizon_ctl[536]: 16:50:22.738 [info] execute "UPDATE members set role_tmp = 'member' where role = 0"438server # [699408.018692] server mobilizon_ctl[536]: 16:50:22.739 [info] execute "UPDATE members set role_tmp = 'moderator' where role = 1"439server # [699408.019253] server mobilizon_ctl[536]: 16:50:22.740 [info] execute "UPDATE members set role_tmp = 'creator' where role = 2"440server # [699408.019776] server mobilizon_ctl[536]: 16:50:22.740 [info] execute "UPDATE members set role_tmp = 'not_approved' where approved is false"441server # [699408.020488] server mobilizon_ctl[536]: 16:50:22.741 [info] alter table members442server # [699408.021203] server mobilizon_ctl[536]: 16:50:22.742 [info] rename column role_tmp to role on table members443server # [699408.021691] server mobilizon_ctl[536]: 16:50:22.742 [info] == Migrated 20190301141830 in 0.0s444server # [699408.027823] server mobilizon_ctl[536]: 16:50:22.748 [info] == Running 20190301143831 Mobilizon.Repo.Migrations.ActorGroupOpenness.up/0 forward445server # [699408.030734] server mobilizon_ctl[536]: 16:50:22.751 [info] execute "CREATE TYPE public.actor_openness AS ENUM ('invite_only', 'moderated', 'open')"446server # [699408.031273] server mobilizon_ctl[536]: 16:50:22.752 [info] alter table actors447server # [699408.032580] server mobilizon_ctl[536]: 16:50:22.753 [info] == Migrated 20190301143831 in 0.0s448server # [699408.040048] server mobilizon_ctl[536]: 16:50:22.761 [info] == Running 20190307125009 Mobilizon.Repo.Migrations.MoveUserRoleToEnum.up/0 forward449server # [699408.040437] server mobilizon_ctl[536]: 16:50:22.761 [info] execute "CREATE TYPE public.user_role AS ENUM ('administrator', 'moderator', 'user', 'pending')"450server # [699408.040966] server mobilizon_ctl[536]: 16:50:22.762 [info] alter table users451server # [699408.041735] server mobilizon_ctl[536]: 16:50:22.762 [info] execute "UPDATE users set role_tmp = 'user' where role = 0"452server # [699408.042499] server mobilizon_ctl[536]: 16:50:22.763 [info] execute "UPDATE users set role_tmp = 'moderator' where role = 1"453server # [699408.042920] server mobilizon_ctl[536]: 16:50:22.764 [info] execute "UPDATE users set role_tmp = 'administrator' where role = 2"454server # [699408.043339] server mobilizon_ctl[536]: 16:50:22.764 [info] alter table users455server # [699408.043898] server mobilizon_ctl[536]: 16:50:22.765 [info] rename column role_tmp to role on table users456server # [699408.044371] server mobilizon_ctl[536]: 16:50:22.765 [info] == Migrated 20190307125009 in 0.0s457server # [699408.052687] server mobilizon_ctl[536]: 16:50:22.773 [info] == Running 20190307133518 Mobilizon.Repo.Migrations.FeedTokenTable.change/0 forward458server # [699408.057101] server mobilizon_ctl[536]: 16:50:22.778 [info] create table feed_tokens459server # [699408.060732] server mobilizon_ctl[536]: 16:50:22.781 [info] == Migrated 20190307133518 in 0.0s460server # [699408.070701] server mobilizon_ctl[536]: 16:50:22.791 [info] == Running 20190322143724 Mobilizon.Repo.Migrations.RenameAddressFields.change/0 forward461server # [699408.070976] server mobilizon_ctl[536]: 16:50:22.792 [info] rename column addressCountry to country on table addresses462server # [699408.071405] server mobilizon_ctl[536]: 16:50:22.792 [info] rename column addressLocality to locality on table addresses463server # [699408.071974] server mobilizon_ctl[536]: 16:50:22.793 [info] rename column addressRegion to region on table addresses464server # [699408.072701] server mobilizon_ctl[536]: 16:50:22.793 [info] rename column postalCode to postal_code on table addresses465server # [699408.072944] server mobilizon_ctl[536]: 16:50:22.794 [info] rename column streetAddress to street on table addresses466server # [699408.073238] server mobilizon_ctl[536]: 16:50:22.794 [info] == Migrated 20190322143724 in 0.0s467server # [699408.078584] server mobilizon_ctl[536]: 16:50:22.799 [info] == Running 20190411124138 Mobilizon.Repo.Migrations.EventAddDescriptionSlug.change/0 forward468server # [699408.078768] server mobilizon_ctl[536]: 16:50:22.799 [info] alter table events469server # [699408.080047] server mobilizon_ctl[536]: 16:50:22.800 [info] == Migrated 20190411124138 in 0.0s470server # [699408.084428] server mobilizon_ctl[536]: 16:50:22.805 [info] == Running 20190411161557 Mobilizon.Repo.Migrations.EventEventTagOnDelete.up/0 forward471server # [699408.084846] server mobilizon_ctl[536]: 16:50:22.805 [info] drop constraint events_tags_event_id_fkey from table events_tags472server # [699408.086700] server mobilizon_ctl[536]: 16:50:22.807 [info] drop constraint events_tags_tag_id_fkey from table events_tags473server # [699408.086794] server mobilizon_ctl[536]: 16:50:22.807 [info] alter table events_tags474server # [699408.089979] server mobilizon_ctl[536]: 16:50:22.810 [info] == Migrated 20190411161557 in 0.0s475server # [699408.098491] server mobilizon_ctl[536]: 16:50:22.819 [info] == Running 20190425075451 Mobilizon.Repo.Migrations.AddVisibilityToActor.up/0 forward476server # [699408.098641] server mobilizon_ctl[536]: 16:50:22.819 [info] execute "CREATE TYPE public.actor_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')"477server # [699408.099299] server mobilizon_ctl[536]: 16:50:22.820 [info] alter table actors478server # [699408.100336] server mobilizon_ctl[536]: 16:50:22.821 [info] == Migrated 20190425075451 in 0.0s479server # [699408.105909] server mobilizon_ctl[536]: 16:50:22.827 [info] == Running 20190426093202 Mobilizon.Repo.Migrations.CreatePictures.up/0 forward480server # [699408.106279] server mobilizon_ctl[536]: 16:50:22.827 [info] create table pictures481server # [699408.111130] server mobilizon_ctl[536]: 16:50:22.832 [info] alter table actors482server # [699408.112177] server mobilizon_ctl[536]: 16:50:22.833 [info] alter table events483server # [699408.114203] server mobilizon_ctl[536]: 16:50:22.835 [info] == Migrated 20190426093202 in 0.0s484server # [699408.123387] server mobilizon_ctl[536]: 16:50:22.844 [info] == Running 20190531131458 :"Elixir.Mobilizon.Repo.Migrations.Attach-pictures-to-actors".change/0 forward485server # [699408.123734] server mobilizon_ctl[536]: 16:50:22.844 [info] alter table pictures486server # [699408.126401] server mobilizon_ctl[536]: 16:50:22.847 [info] == Migrated 20190531131458 in 0.0s487server # [699408.132773] server mobilizon_ctl[536]: 16:50:22.853 [info] == Running 20190712125833 Mobilizon.Repo.Migrations.CreateReports.up/0 forward488server # [699408.135557] server mobilizon_ctl[536]: 16:50:22.856 [info] execute "CREATE TYPE public.report_status AS ENUM ('open', 'closed', 'resolved')"489server # [699408.136247] server mobilizon_ctl[536]: 16:50:22.857 [info] create table reports490server # [699408.141288] server mobilizon_ctl[536]: 16:50:22.862 [info] create table reports_comments491server # [699408.143065] server mobilizon_ctl[536]: 16:50:22.864 [info] == Migrated 20190712125833 in 0.0s492server # [699408.153881] server mobilizon_ctl[536]: 16:50:22.874 [info] == Running 20190712132438 Mobilizon.Repo.Migrations.CreateReportNotes.change/0 forward493server # [699408.154024] server mobilizon_ctl[536]: 16:50:22.875 [info] create table report_notes494server # [699408.156805] server mobilizon_ctl[536]: 16:50:22.877 [info] == Migrated 20190712132438 in 0.0s495server # [699408.163668] server mobilizon_ctl[536]: 16:50:22.884 [info] == Running 20190718122556 Mobilizon.Repo.Migrations.CreateAdminActionLogs.change/0 forward496server # [699408.163936] server mobilizon_ctl[536]: 16:50:22.885 [info] create table admin_action_logs497server # [699408.169014] server mobilizon_ctl[536]: 16:50:22.890 [info] == Migrated 20190718122556 in 0.0s498server # [699408.177102] server mobilizon_ctl[536]: 16:50:22.898 [info] == Running 20190729125532 :"Elixir.Mobilizon.Repo.Migrations.Add-url-to-addresses".change/0 forward499server # [699408.177280] server mobilizon_ctl[536]: 16:50:22.898 [info] alter table addresses500server # [699408.178453] server mobilizon_ctl[536]: 16:50:22.899 [info] == Migrated 20190729125532 in 0.0s501server # [699408.182859] server mobilizon_ctl[536]: 16:50:22.903 [info] == Running 20190806131306 Mobilizon.Repo.Migrations.AddUrlToFollowsAndMoveToUuid.up/0 forward502server # [699408.183071] server mobilizon_ctl[536]: 16:50:22.904 [info] alter table followers503server # [699408.185950] server mobilizon_ctl[536]: 16:50:22.906 [info] == Migrated 20190806131306 in 0.0s504server # [699408.191886] server mobilizon_ctl[536]: 16:50:22.913 [info] == Running 20190813160207 Mobilizon.Repo.Migrations.AddUrlAndUuidToParticipants.up/0 forward505server # [699408.192393] server mobilizon_ctl[536]: 16:50:22.913 [info] drop index participants_event_id_index506server # [699408.193006] server mobilizon_ctl[536]: 16:50:22.914 [info] drop index if exists participants_account_id_index507server # [699408.193628] server mobilizon_ctl[536]: 16:50:22.914 [info] drop index if exists participants_actor_id_index508server # [699408.194062] server mobilizon_ctl[536]: 16:50:22.915 [info] index "participants_actor_id_index" does not exist, skipping509server # [699408.194236] server mobilizon_ctl[536]: 16:50:22.915 [info] drop constraint participants_event_id_fkey from table participants510server # [699408.195045] server mobilizon_ctl[536]: 16:50:22.916 [info] drop constraint if exists participants_account_id_fkey from table participants511server # [699408.195911] server mobilizon_ctl[536]: 16:50:22.917 [info] drop constraint if exists participants_actor_id_fkey from table participants512server # [699408.196364] server mobilizon_ctl[536]: 16:50:22.917 [info] constraint "participants_actor_id_fkey" of relation "participants" does not exist, skipping513server # [699408.196364] server mobilizon_ctl[536]: 16:50:22.917 [info] drop constraint participants_pkey from table participants514server # [699408.196988] server mobilizon_ctl[536]: 16:50:22.918 [info] alter table participants515server # [699408.202046] server mobilizon_ctl[536]: 16:50:22.923 [info] create index participants_event_id_index516server # [699408.203031] server mobilizon_ctl[536]: 16:50:22.924 [info] create index participants_actor_id_index517server # [699408.204105] server mobilizon_ctl[536]: 16:50:22.924 [info] == Migrated 20190813160207 in 0.0s518server # [699408.214446] server mobilizon_ctl[536]: 16:50:22.935 [info] == Running 20190821161658 Mobilizon.Repo.Migrations.AddOriginIdToAddresses.change/0 forward519server # [699408.214837] server mobilizon_ctl[536]: 16:50:22.935 [info] alter table addresses520server # [699408.215362] server mobilizon_ctl[536]: 16:50:22.936 [info] create index addresses_origin_id_index521server # [699408.216463] server mobilizon_ctl[536]: 16:50:22.937 [info] == Migrated 20190821161658 in 0.0s522server # [699408.222177] server mobilizon_ctl[536]: 16:50:22.943 [info] == Running 20190823132816 Mobilizon.Repo.Migrations.RemoveEventsWhenDeletingOrganizer.up/0 forward523server # [699408.222327] server mobilizon_ctl[536]: 16:50:22.943 [info] drop constraint events_organizer_account_id_fkey from table events524server # [699408.223544] server mobilizon_ctl[536]: 16:50:22.944 [info] alter table events525server # [699408.226056] server mobilizon_ctl[536]: 16:50:22.946 [info] == Migrated 20190823132816 in 0.0s526server # [699408.229303] server mobilizon_ctl[536]: 16:50:22.950 [info] == Running 20190902082656 Mobilizon.Repo.Migrations.AddOptionsToEvent.change/0 forward527server # [699408.229582] server mobilizon_ctl[536]: 16:50:22.950 [info] alter table events528server # [699408.230211] server mobilizon_ctl[536]: 16:50:22.951 [info] == Migrated 20190902082656 in 0.0s529server # [699408.236721] server mobilizon_ctl[536]: 16:50:22.957 [info] == Running 20190929170817 Mobilizon.Storage.Repo.Migrations.RenamePostgresTypes.up/0 forward530server # [699408.242300] server mobilizon_ctl[536]: 16:50:22.963 [info] == Migrated 20190929170817 in 0.0s531server # [699408.248430] server mobilizon_ctl[536]: 16:50:22.969 [info] == Running 20190929175229 Mobilizon.Storage.Repo.Migrations.AddRejectedToParticipantRole.up/0 forward532server # [699408.248627] server mobilizon_ctl[536]: 16:50:22.969 [info] execute "ALTER TYPE public.participant_role ADD VALUE IF NOT EXISTS 'rejected'"533server # [699408.249531] server mobilizon_ctl[536]: 16:50:22.970 [info] enum label "rejected" already exists, skipping534server # [699408.249833] server mobilizon_ctl[536]: 16:50:22.970 [info] == Migrated 20190929175229 in 0.0s535server # [699408.255731] server mobilizon_ctl[536]: 16:50:22.976 [info] == Running 20191001074442 Mobilizon.Storage.Repo.Migrations.AddLocaleToUsers.change/0 forward536server # [699408.255972] server mobilizon_ctl[536]: 16:50:22.977 [info] alter table users537server # [699408.257686] server mobilizon_ctl[536]: 16:50:22.978 [info] == Migrated 20191001074442 in 0.0s538server # [699408.261467] server mobilizon_ctl[536]: 16:50:22.982 [info] == Running 20191002093208 Mobilizon.Storage.Repo.Migrations.AddDraftFlagToEvents.change/0 forward539server # [699408.261663] server mobilizon_ctl[536]: 16:50:22.982 [info] alter table events540server # [699408.262920] server mobilizon_ctl[536]: 16:50:22.983 [info] == Migrated 20191002093208 in 0.0s541server # [699408.269924] server mobilizon_ctl[536]: 16:50:22.991 [info] == Running 20191018075904 Mobilizon.Storage.Repo.Migrations.MoveSQLColumnsFromVarCharToText.up/0 forward542server # [699408.270476] server mobilizon_ctl[536]: 16:50:22.991 [info] alter table events543server # [699408.273074] server mobilizon_ctl[536]: 16:50:22.994 [info] alter table addresses544server # [699408.273879] server mobilizon_ctl[536]: 16:50:22.995 [info] alter table bots545server # [699408.274597] server mobilizon_ctl[536]: 16:50:22.995 [info] alter table report_notes546server # [699408.276028] server mobilizon_ctl[536]: 16:50:22.997 [info] alter table reports547server # [699408.276639] server mobilizon_ctl[536]: 16:50:22.997 [info] alter table sessions548server # [699408.277461] server mobilizon_ctl[536]: 16:50:22.998 [info] alter table tracks549server # [699408.278099] server mobilizon_ctl[536]: 16:50:22.999 [info] == Migrated 20191018075904 in 0.0s550server # [699408.281746] server mobilizon_ctl[536]: 16:50:23.002 [info] == Running 20191022083446 Mobilizon.Storage.Repo.Migrations.AddEagerMaterializedViewForSearchingEvents.up/0 forward551server # [699408.281987] server mobilizon_ctl[536]: 16:50:23.003 [info] create table event_search552server # [699408.285325] server mobilizon_ctl[536]: 16:50:23.005 [info] create index event_search_document_index553server # [699408.285813] server mobilizon_ctl[536]: 16:50:23.007 [info] execute "CREATE INDEX event_search_title_trgm_index ON event_search USING gin (title gin_trgm_ops)"554server # [699408.286782] server mobilizon_ctl[536]: 16:50:23.007 [info] create index event_search_id_index555server # [699408.287708] server mobilizon_ctl[536]: 16:50:23.008 [info] == Migrated 20191022083446 in 0.0s556server # [699408.295614] server mobilizon_ctl[536]: 16:50:23.016 [info] == Running 20191023133805 Mobilizon.Storage.Repo.Migrations.DeleteActorsCascadeToFollowers.up/0 forward557server # [699408.295844] server mobilizon_ctl[536]: 16:50:23.017 [info] drop constraint followers_actor_id_fkey from table followers558server # [699408.296951] server mobilizon_ctl[536]: 16:50:23.018 [info] drop constraint followers_target_actor_id_fkey from table followers559server # [699408.297948] server mobilizon_ctl[536]: 16:50:23.019 [info] alter table followers560server # [699408.301273] server mobilizon_ctl[536]: 16:50:23.022 [info] == Migrated 20191023133805 in 0.0s561server # [699408.306960] server mobilizon_ctl[536]: 16:50:23.028 [info] == Running 20191023143659 Mobilizon.Storage.Repo.Migrations.MoveParticipantsStatsToEvent.up/0 forward562server # [699408.307100] server mobilizon_ctl[536]: 16:50:23.028 [info] alter table events563server # [699408.308244] server mobilizon_ctl[536]: 16:50:23.029 [info] == Migrated 20191023143659 in 0.0s564server # [699408.315571] server mobilizon_ctl[536]: 16:50:23.036 [info] == Running 20191024204726 Mobilizon.Storage.Repo.Migrations.AddTagsToComments.up/0 forward565server # [699408.316120] server mobilizon_ctl[536]: 16:50:23.036 [info] create table comments_tags566server # [699408.318963] server mobilizon_ctl[536]: 16:50:23.039 [info] == Migrated 20191024204726 in 0.0s567server # [699408.328648] server mobilizon_ctl[536]: 16:50:23.049 [info] == Running 20191025083642 Mobilizon.Storage.Repo.Migrations.AddMentionTables.change/0 forward568server # [699408.329142] server mobilizon_ctl[536]: 16:50:23.050 [info] create table mentions569server # [699408.335253] server mobilizon_ctl[536]: 16:50:23.056 [info] create index mentions_actor_id_index570server # [699408.336567] server mobilizon_ctl[536]: 16:50:23.057 [info] == Migrated 20191025083642 in 0.0s571server # [699408.347478] server mobilizon_ctl[536]: 16:50:23.068 [info] == Running 20191025115537 Mobilizon.Storage.Repo.Migrations.AddUniqueIndexOnURLs.change/0 forward572server # [699408.347747] server mobilizon_ctl[536]: 16:50:23.068 [info] create index events_url_index573server # [699408.349247] server mobilizon_ctl[536]: 16:50:23.070 [info] create index comments_url_index574server # [699408.350411] server mobilizon_ctl[536]: 16:50:23.071 [info] == Migrated 20191025115537 in 0.0s575server # [699408.355912] server mobilizon_ctl[536]: 16:50:23.077 [info] == Running 20191031142145 Mobilizon.Storage.Repo.Migrations.AddUniqueIndexOnActorAndEventForParticipant.change/0 forward576server # [699408.356136] server mobilizon_ctl[536]: 16:50:23.077 [info] create index participants_event_id_actor_id_index577server # [699408.357993] server mobilizon_ctl[536]: 16:50:23.079 [info] == Migrated 20191031142145 in 0.0s578server # [699408.364581] server mobilizon_ctl[536]: 16:50:23.085 [info] == Running 20191104093447 Mobilizon.Storage.Repo.Migrations.AddObanJobsTable.up/0 forward579server # [699408.403311] server mobilizon_ctl[536]: 16:50:23.124 [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"580server # [699408.404982] server mobilizon_ctl[536]: 16:50:23.126 [info] create table if not exists public.oban_jobs581server # [699408.407855] server mobilizon_ctl[536]: 16:50:23.129 [info] create index if not exists public.oban_jobs_queue_index582server # [699408.408959] server mobilizon_ctl[536]: 16:50:23.130 [info] create index if not exists public.oban_jobs_state_index583server # [699408.409697] server mobilizon_ctl[536]: 16:50:23.130 [info] create index if not exists public.oban_jobs_scheduled_at_index584server # [699408.410620] server mobilizon_ctl[536]: 16:50:23.131 [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"585server # [699408.411961] server mobilizon_ctl[536]: 16:50:23.133 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs"586server # [699408.412303] server mobilizon_ctl[536]: 16:50:23.133 [info] trigger "oban_notify" for relation "public.oban_jobs" does not exist, skipping587server # [699408.412383] server mobilizon_ctl[536]: 16:50:23.133 [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"588server # [699408.412977] server mobilizon_ctl[536]: 16:50:23.134 [info] drop index if exists public.oban_jobs_scheduled_at_index589server # [699408.413540] server mobilizon_ctl[536]: 16:50:23.134 [info] create index public.oban_jobs_scheduled_at_index590server # [699408.414690] server mobilizon_ctl[536]: 16:50:23.135 [info] create check constraint worker_length on table public.oban_jobs591server # [699408.415573] server mobilizon_ctl[536]: 16:50:23.136 [info] create check constraint queue_length on table public.oban_jobs592server # [699408.416193] server mobilizon_ctl[536]: 16:50:23.137 [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"593server # [699408.416871] server mobilizon_ctl[536]: 16:50:23.138 [info] alter table public.oban_jobs594server # [699408.417280] server mobilizon_ctl[536]: 16:50:23.138 [info] execute "DROP FUNCTION IF EXISTS \"public\".oban_wrap_id(value bigint)"595server # [699408.417647] server mobilizon_ctl[536]: 16:50:23.138 [info] drop index if exists public.oban_jobs_scheduled_at_index596server # [699408.418068] server mobilizon_ctl[536]: 16:50:23.139 [info] drop index if exists public.oban_jobs_queue_index597server # [699408.418339] server mobilizon_ctl[536]: 16:50:23.139 [info] drop index if exists public.oban_jobs_state_index598server # [699408.418799] server mobilizon_ctl[536]: 16:50:23.139 [info] create index if not exists public.oban_jobs_queue_state_scheduled_at_id_index599server # [699408.419952] server mobilizon_ctl[536]: 16:50:23.141 [info] create index if not exists public.oban_jobs_attempted_at_id_index600server # [699408.420964] server mobilizon_ctl[536]: 16:50:23.142 [info] alter table public.oban_jobs601server # [699408.422028] server mobilizon_ctl[536]: 16:50:23.143 [info] alter table public.oban_jobs602server # [699408.422854] server mobilizon_ctl[536]: 16:50:23.144 [info] drop index if exists public.oban_jobs_queue_state_scheduled_at_id_index603server # [699408.423447] server mobilizon_ctl[536]: 16:50:23.144 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index604server # [699408.424768] server mobilizon_ctl[536]: 16:50:23.146 [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"605server # [699408.425352] server mobilizon_ctl[536]: 16:50:23.146 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs"606server # [699408.426050] server mobilizon_ctl[536]: 16:50:23.147 [info] execute "CREATE TRIGGER oban_notify\nAFTER INSERT ON \"public\".oban_jobs\nFOR EACH ROW EXECUTE PROCEDURE \"public\".oban_jobs_notify();\n"607server # [699408.426460] server mobilizon_ctl[536]: 16:50:23.147 [info] alter table public.oban_jobs608server # [699408.438920] server mobilizon_ctl[536]: 16:50:23.160 [info] execute "ALTER TYPE \"public\".oban_job_state ADD VALUE IF NOT EXISTS 'cancelled'"609server # [699408.439602] server mobilizon_ctl[536]: 16:50:23.160 [info] enum label "cancelled" already exists, skipping610server # [699408.439602] server mobilizon_ctl[536]: 16:50:23.160 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index611server # [699408.440176] server mobilizon_ctl[536]: 16:50:23.161 [info] relation "oban_jobs_state_queue_priority_scheduled_at_id_index" already exists, skipping612server # [699408.440176] server mobilizon_ctl[536]: 16:50:23.161 [info] alter table public.oban_jobs613server # [699408.441969] server mobilizon_ctl[536]: 16:50:23.163 [info] create check constraint priority_range on table public.oban_jobs614server # [699408.442636] server mobilizon_ctl[536]: 16:50:23.163 [info] create check constraint positive_max_attempts on table public.oban_jobs615server # [699408.443272] server mobilizon_ctl[536]: 16:50:23.164 [info] create check constraint attempt_range on table public.oban_jobs616server # [699408.443919] server mobilizon_ctl[536]: 16:50:23.165 [info] drop index if exists public.oban_jobs_args_vector617server # [699408.444302] server mobilizon_ctl[536]: 16:50:23.165 [info] index "oban_jobs_args_vector" does not exist, skipping618server # [699408.445830] server mobilizon_ctl[536]: 16:50:23.165 [info] drop index if exists public.oban_jobs_worker_gist619server # [699408.445927] server mobilizon_ctl[536]: 16:50:23.165 [info] index "oban_jobs_worker_gist" does not exist, skipping620server # [699408.445927] server mobilizon_ctl[536]: 16:50:23.165 [info] drop index if exists public.oban_jobs_attempted_at_id_index621server # [699408.445927] server mobilizon_ctl[536]: 16:50:23.166 [info] create index if not exists public.oban_jobs_args_index622server # [699408.445927] server mobilizon_ctl[536]: 16:50:23.167 [info] create index if not exists public.oban_jobs_meta_index623server # [699408.446988] server mobilizon_ctl[536]: 16:50:23.167 [info] create table if not exists public.oban_peers624server # [699408.449051] server mobilizon_ctl[536]: 16:50:23.170 [info] execute "ALTER TABLE \"public\".oban_peers SET UNLOGGED"625server # [699408.451371] server mobilizon_ctl[536]: 16:50:23.172 [info] drop constraint priority_range from table public.oban_jobs626server # [699408.452494] server mobilizon_ctl[536]: 16:50:23.173 [info] create check constraint non_negative_priority on table public.oban_jobs627server # [699408.453635] server mobilizon_ctl[536]: 16:50:23.174 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs"628server # [699408.454227] server mobilizon_ctl[536]: 16:50:23.175 [info] execute "DROP FUNCTION IF EXISTS \"public\".oban_jobs_notify()"629server # [699408.454913] server mobilizon_ctl[536]: 16:50:23.176 [info] create index if not exists public.oban_jobs_state_cancelled_at_index630server # [699408.455995] server mobilizon_ctl[536]: 16:50:23.177 [info] create index if not exists public.oban_jobs_state_discarded_at_index631server # [699408.457071] server mobilizon_ctl[536]: 16:50:23.178 [info] execute "ALTER TYPE \"public\".oban_job_state ADD VALUE IF NOT EXISTS 'suspended' BEFORE 'scheduled'\n"632server # [699408.457359] server mobilizon_ctl[536]: 16:50:23.178 [info] enum label "suspended" already exists, skipping633server # [699408.457448] server mobilizon_ctl[536]: 16:50:23.178 [info] execute "COMMENT ON TABLE \"public\".oban_jobs IS '14'"634server # [699408.457862] server mobilizon_ctl[536]: 16:50:23.178 [info] == Migrated 20191104093447 in 0.0s635server # [699408.474496] server mobilizon_ctl[536]: 16:50:23.195 [info] == Running 20191106114524 Mobilizon.Storage.Repo.Migrations.RemoveFloorFromAddresses.up/0 forward636server # [699408.474800] server mobilizon_ctl[536]: 16:50:23.195 [info] alter table addresses637server # [699408.475898] server mobilizon_ctl[536]: 16:50:23.196 [info] == Migrated 20191106114524 in 0.0s638server # [699408.481847] server mobilizon_ctl[536]: 16:50:23.202 [info] == Running 20191106141051 Mobilizon.Storage.Repo.Migrations.AddTypeToAddresses.change/0 forward639server # [699408.482046] server mobilizon_ctl[536]: 16:50:23.203 [info] alter table addresses640server # [699408.483086] server mobilizon_ctl[536]: 16:50:23.204 [info] == Migrated 20191106141051 in 0.0s641server # [699408.489682] server mobilizon_ctl[536]: 16:50:23.210 [info] == Running 20191114155534 Mobilizon.Storage.Repo.Migrations.CascadeCommentDeletion.up/0 forward642server # [699408.490036] server mobilizon_ctl[536]: 16:50:23.210 [info] drop constraint comments_in_reply_to_comment_id_fkey from table comments643server # [699408.490733] server mobilizon_ctl[536]: 16:50:23.211 [info] drop constraint comments_origin_comment_id_fkey from table comments644server # [699408.491713] server mobilizon_ctl[536]: 16:50:23.212 [info] alter table comments645server # [699408.494627] server mobilizon_ctl[536]: 16:50:23.215 [info] == Migrated 20191114155534 in 0.0s646server # [699408.502196] server mobilizon_ctl[536]: 16:50:23.223 [info] == Running 20191122154018 Mobilizon.Storage.Repo.Migrations.AddDeletedAtOnComments.up/0 forward647server # [699408.502432] server mobilizon_ctl[536]: 16:50:23.223 [info] drop constraint if exists comments_actor_id_fkey from table comments648server # [699408.503319] server mobilizon_ctl[536]: 16:50:23.224 [info] constraint "comments_actor_id_fkey" of relation "comments" does not exist, skipping649server # [699408.503429] server mobilizon_ctl[536]: 16:50:23.224 [info] alter table comments650server # [699408.505932] server mobilizon_ctl[536]: 16:50:23.226 [info] == Migrated 20191122154018 in 0.0s651server # [699408.514205] server mobilizon_ctl[536]: 16:50:23.235 [info] == Running 20191126173510 Mobilizon.Storage.Repo.Migrations.AddLocalFieldToReports.up/0 forward652server # [699408.514625] server mobilizon_ctl[536]: 16:50:23.235 [info] alter table reports653server # [699408.515243] server mobilizon_ctl[536]: 16:50:23.236 [info] rename column uri to url on table reports654server # [699408.515824] server mobilizon_ctl[536]: 16:50:23.236 [info] == Migrated 20191126173510 in 0.0s655server # [699408.521327] server mobilizon_ctl[536]: 16:50:23.242 [info] == Running 20191127163737 Mobilizon.Repo.Migrations.CreateTombstones.change/0 forward656server # [699408.522173] server mobilizon_ctl[536]: 16:50:23.242 [info] create table tombstones657server # [699408.525925] server mobilizon_ctl[536]: 16:50:23.247 [info] create index tombstones_uri_index658server # [699408.527065] server mobilizon_ctl[536]: 16:50:23.248 [info] == Migrated 20191127163737 in 0.0s659server # [699408.534482] server mobilizon_ctl[536]: 16:50:23.255 [info] == Running 20191129091227 Mobilizon.Storage.Repo.Migrations.AddTimestampsToFollowers.change/0 forward660server # [699408.534683] server mobilizon_ctl[536]: 16:50:23.255 [info] alter table followers661server # [699408.535609] server mobilizon_ctl[536]: 16:50:23.256 [info] == Migrated 20191129091227 in 0.0s662server # [699408.542433] server mobilizon_ctl[536]: 16:50:23.263 [info] == Running 20191204164224 Mobilizon.Storage.Repo.Migrations.DeleteEventCascadeToComments.up/0 forward663server # [699408.542683] server mobilizon_ctl[536]: 16:50:23.263 [info] drop constraint if exists comments_event_id_fkey from table comments664server # [699408.544247] server mobilizon_ctl[536]: 16:50:23.265 [info] alter table comments665server # [699408.546187] server mobilizon_ctl[536]: 16:50:23.267 [info] == Migrated 20191204164224 in 0.0s666server # [699408.552402] server mobilizon_ctl[536]: 16:50:23.273 [info] == Running 20191206144028 Mobilizon.Repo.Migrations.CreateShares.up/0 forward667server # [699408.552595] server mobilizon_ctl[536]: 16:50:23.273 [info] create table shares668server # [699408.555925] server mobilizon_ctl[536]: 16:50:23.277 [info] create index if not exists shares_uri_actor_id_index669server # [699408.557409] server mobilizon_ctl[536]: 16:50:23.278 [info] == Migrated 20191206144028 in 0.0s670server # [699408.565670] server mobilizon_ctl[536]: 16:50:23.286 [info] == Running 20191219172017 Mobilizon.Storage.Repo.Migrations.AddMetadataToParticipant.up/0 forward671server # [699408.565947] server mobilizon_ctl[536]: 16:50:23.287 [info] drop index if exists participants_event_id_actor_id_index672server # [699408.567085] server mobilizon_ctl[536]: 16:50:23.288 [info] alter table participants673server # [699408.569328] server mobilizon_ctl[536]: 16:50:23.290 [info] execute "CREATE UNIQUE INDEX participants_metadata_confirmation_token_index ON participants((metadata->>'confirmation_token'))"674server # [699408.570404] server mobilizon_ctl[536]: 16:50:23.291 [info] == Migrated 20191219172017 in 0.0s675server # [699408.576902] server mobilizon_ctl[536]: 16:50:23.297 [info] == Running 20191223173537 Mobilizon.Storage.Repo.Migrations.AddNotConfirmedStatusToParticipants.up/0 forward676server # [699408.577085] server mobilizon_ctl[536]: 16:50:23.298 [info] execute "ALTER TYPE participant_role ADD VALUE IF NOT EXISTS 'not_confirmed'"677server # [699408.577718] server mobilizon_ctl[536]: 16:50:23.298 [info] enum label "not_confirmed" already exists, skipping678server # [699408.578007] server mobilizon_ctl[536]: 16:50:23.298 [info] == Migrated 20191223173537 in 0.0s679server # [699408.585084] server mobilizon_ctl[536]: 16:50:23.306 [info] == Running 20200116095117 Mobilizon.Repo.Migrations.CreateAdminSettings.change/0 forward680server # [699408.585742] server mobilizon_ctl[536]: 16:50:23.306 [info] create table admin_settings681server # [699408.588813] server mobilizon_ctl[536]: 16:50:23.309 [info] create index admin_settings_group_name_index682server # [699408.589834] server mobilizon_ctl[536]: 16:50:23.310 [info] == Migrated 20200116095117 in 0.0s683server # [699408.600935] server mobilizon_ctl[536]: 16:50:23.321 [info] == Running 20200210100910 Mobilizon.Storage.Repo.Migrations.AddUnconfirmedEmailToUsersTable.change/0 forward684server # [699408.600935] server mobilizon_ctl[536]: 16:50:23.322 [info] alter table users685server # [699408.605174] server mobilizon_ctl[536]: 16:50:23.326 [info] == Migrated 20200210100910 in 0.0s686server # [699408.611394] server mobilizon_ctl[536]: 16:50:23.332 [info] == Running 20200213154309 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV8.up/0 forward687server # [699408.613097] server mobilizon_ctl[536]: 16:50:23.334 [info] == Migrated 20200213154309 in 0.0s688server # [699408.618814] server mobilizon_ctl[536]: 16:50:23.340 [info] == Running 20200214135231 Mobilizon.Storage.Repo.Migrations.AddLastRefreshedAtToActors.change/0 forward689server # [699408.618972] server mobilizon_ctl[536]: 16:50:23.340 [info] alter table actors690server # [699408.619838] server mobilizon_ctl[536]: 16:50:23.340 [info] == Migrated 20200214135231 in 0.0s691server # [699408.622539] server mobilizon_ctl[536]: 16:50:23.343 [info] == Running 20200218085757 Mobilizon.Storage.Repo.Migrations.AddNewRolesToMember.up/0 forward692server # [699408.622722] server mobilizon_ctl[536]: 16:50:23.343 [info] execute "ALTER TYPE member_role ADD VALUE IF NOT EXISTS 'invited'"693server # [699408.623133] server mobilizon_ctl[536]: 16:50:23.344 [info] enum label "invited" already exists, skipping694server # [699408.623169] server mobilizon_ctl[536]: 16:50:23.344 [info] execute "ALTER TYPE member_role ADD VALUE IF NOT EXISTS 'rejected'"695server # [699408.623478] server mobilizon_ctl[536]: 16:50:23.344 [info] enum label "rejected" already exists, skipping696server # [699408.623665] server mobilizon_ctl[536]: 16:50:23.344 [info] == Migrated 20200218085757 in 0.0s697server # [699408.629506] server mobilizon_ctl[536]: 16:50:23.350 [info] == Running 20200218170232 Mobilizon.Storage.Repo.Migrations.MoveMemberIdToUuid.up/0 forward698server # [699408.629844] server mobilizon_ctl[536]: 16:50:23.350 [info] alter table members699server # [699408.634173] server mobilizon_ctl[536]: 16:50:23.355 [info] == Migrated 20200218170232 in 0.0s700server # [699408.641234] server mobilizon_ctl[536]: 16:50:23.362 [info] == Running 20200219152611 Mobilizon.Storage.Repo.Migrations.AddMembersEndpointToActors.up/0 forward701server # [699408.641430] server mobilizon_ctl[536]: 16:50:23.362 [info] alter table actors702server # [699408.642446] server mobilizon_ctl[536]: 16:50:23.363 [info] == Migrated 20200219152611 in 0.0s703server # [699408.650954] server mobilizon_ctl[536]: 16:50:23.372 [info] == Running 20200221095721 Mobilizon.Repo.Migrations.CreateTodos.change/0 forward704server # [699408.651292] server mobilizon_ctl[536]: 16:50:23.372 [info] create table todo_lists705server # [699408.654628] server mobilizon_ctl[536]: 16:50:23.375 [info] create table todos706server # [699408.659059] server mobilizon_ctl[536]: 16:50:23.379 [info] == Migrated 20200221095721 in 0.0s707server # [699408.672874] server mobilizon_ctl[536]: 16:50:23.393 [info] == Running 20200221160744 Mobilizon.Repo.Migrations.CreateResources.change/0 forward708server # [699408.674070] server mobilizon_ctl[536]: 16:50:23.393 [info] create table resource709server # [699408.676527] server mobilizon_ctl[536]: 16:50:23.397 [info] == Migrated 20200221160744 in 0.0s710server # [699408.684741] server mobilizon_ctl[536]: 16:50:23.405 [info] == Running 20200406115807 Mobilizon.Storage.Repo.Migrations.AddConversations.change/0 forward711server # [699408.684992] server mobilizon_ctl[536]: 16:50:23.406 [info] create table conversations712server # [699408.689041] server mobilizon_ctl[536]: 16:50:23.409 [info] alter table comments713server # [699408.691694] server mobilizon_ctl[536]: 16:50:23.412 [info] == Migrated 20200406115807 in 0.0s714server # [699408.700559] server mobilizon_ctl[536]: 16:50:23.421 [info] == Running 20200410100554 Mobilizon.Storage.Repo.Migrations.AddNumberEditsToComment.change/0 forward715server # [699408.701024] server mobilizon_ctl[536]: 16:50:23.421 [info] alter table comments716server # [699408.702248] server mobilizon_ctl[536]: 16:50:23.423 [info] == Migrated 20200410100554 in 0.0s717server # [699408.709054] server mobilizon_ctl[536]: 16:50:23.430 [info] == Running 20200513142813 Mobilizon.Storage.Repo.Migrations.AddResourcesAndTodosEndpointsToActor.change/0 forward718server # [699408.709054] server mobilizon_ctl[536]: 16:50:23.430 [info] alter table actors719server # [699408.710100] server mobilizon_ctl[536]: 16:50:23.431 [info] == Migrated 20200513142813 in 0.0s720server # [699408.716161] server mobilizon_ctl[536]: 16:50:23.437 [info] == Running 20200514101612 Mobilizon.Storage.Repo.Migrations.AddLocalAttributeToResourcesAndTodos.change/0 forward721server # [699408.716830] server mobilizon_ctl[536]: 16:50:23.437 [info] alter table resource722server # [699408.717159] server mobilizon_ctl[536]: 16:50:23.438 [info] alter table todo_lists723server # [699408.718178] server mobilizon_ctl[536]: 16:50:23.439 [info] alter table todos724server # [699408.719903] server mobilizon_ctl[536]: 16:50:23.440 [info] == Migrated 20200514101612 in 0.0s725server # [699408.727671] server mobilizon_ctl[536]: 16:50:23.448 [info] == Running 20200518084949 Mobilizon.Storage.Repo.Migrations.MoveInviterFromMetadataToMemberTable.change/0 forward726server # [699408.727850] server mobilizon_ctl[536]: 16:50:23.449 [info] alter table members727server # [699408.731264] server mobilizon_ctl[536]: 16:50:23.452 [info] == Migrated 20200518084949 in 0.0s728server # [699408.738364] server mobilizon_ctl[536]: 16:50:23.459 [info] == Running 20200519082820 Mobilizon.Storage.Repo.Migrations.AddUniqueURLContraintToSomeTables.change/0 forward729server # [699408.738862] server mobilizon_ctl[536]: 16:50:23.459 [info] create index members_url_index730server # [699408.740610] server mobilizon_ctl[536]: 16:50:23.461 [info] create index resource_url_index731server # [699408.741746] server mobilizon_ctl[536]: 16:50:23.462 [info] create index todo_lists_url_index732server # [699408.743338] server mobilizon_ctl[536]: 16:50:23.464 [info] create index todos_url_index733server # [699408.744978] server mobilizon_ctl[536]: 16:50:23.466 [info] == Migrated 20200519082820 in 0.0s734server # [699408.748488] server mobilizon_ctl[536]: 16:50:23.469 [info] == Running 20200526131523 Mobilizon.Repo.Migrations.CreateUserSettings.change/0 forward735server # [699408.748784] server mobilizon_ctl[536]: 16:50:23.469 [info] create table user_settings736server # [699408.751744] server mobilizon_ctl[536]: 16:50:23.472 [info] == Migrated 20200526131523 in 0.0s737server # [699408.759103] server mobilizon_ctl[536]: 16:50:23.480 [info] == Running 20200605154921 Mobilizon.Storage.Repo.Migrations.AddNotificationPendingParticipationToSettings.change/0 forward738server # [699408.759267] server mobilizon_ctl[536]: 16:50:23.480 [info] alter table user_settings739server # [699408.760360] server mobilizon_ctl[536]: 16:50:23.481 [info] == Migrated 20200605154921 in 0.0s740server # [699408.766068] server mobilizon_ctl[536]: 16:50:23.487 [info] == Running 20200612155254 Mobilizon.Storage.Repo.Migrations.AddDisabledParameterToUsers.change/0 forward741server # [699408.766235] server mobilizon_ctl[536]: 16:50:23.487 [info] alter table users742server # [699408.767461] server mobilizon_ctl[536]: 16:50:23.488 [info] == Migrated 20200612155254 in 0.0s743server # [699408.771095] server mobilizon_ctl[536]: 16:50:23.492 [info] == Running 20200630123819 Mobilizon.Storage.Repo.Migrations.AddProviderToUserAndMakePasswordMandatory.up/0 forward744server # [699408.771214] server mobilizon_ctl[536]: 16:50:23.492 [info] alter table users745server # [699408.772296] server mobilizon_ctl[536]: 16:50:23.493 [info] == Migrated 20200630123819 in 0.0s746server # [699408.781820] server mobilizon_ctl[536]: 16:50:23.502 [info] == Running 20200708080516 Mobilizon.Repo.Migrations.CreatePosts.up/0 forward747server # [699408.788837] server mobilizon_ctl[536]: 16:50:23.509 [info] execute "CREATE TYPE public.post_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')"748server # [699408.789785] server mobilizon_ctl[536]: 16:50:23.510 [info] create table posts749server # [699408.794464] server mobilizon_ctl[536]: 16:50:23.515 [info] create table posts_tags750server # [699408.796697] server mobilizon_ctl[536]: 16:50:23.517 [info] alter table actors751server # [699408.797474] server mobilizon_ctl[536]: 16:50:23.518 [info] == Migrated 20200708080516 in 0.0s752server # [699408.806210] server mobilizon_ctl[536]: 16:50:23.527 [info] == Running 20200717142633 Mobilizon.Storage.Repo.Migrations.RenameConversationsToDiscussions.up/0 forward753server # [699408.806470] server mobilizon_ctl[536]: 16:50:23.527 [info] rename table conversations to discussions754server # [699408.807001] server mobilizon_ctl[536]: 16:50:23.528 [info] rename column conversation_id to discussion_id on table comments755server # [699408.807397] server mobilizon_ctl[536]: 16:50:23.528 [info] alter table actors756server # [699408.808034] server mobilizon_ctl[536]: 16:50:23.529 [info] == Migrated 20200717142633 in 0.0s757server # [699408.815028] server mobilizon_ctl[536]: 16:50:23.536 [info] == Running 20200721131521 Mobilizon.Storage.Repo.Migrations.AddUrlToConversation.up/0 forward758server # [699408.815269] server mobilizon_ctl[536]: 16:50:23.536 [info] drop constraint if exists comments_conversation_id_fkey from table comments759server # [699408.816553] server mobilizon_ctl[536]: 16:50:23.537 [info] drop constraint if exists comments_discussion_id_fkey from table comments760server # [699408.817046] server mobilizon_ctl[536]: 16:50:23.538 [info] constraint "comments_discussion_id_fkey" of relation "comments" does not exist, skipping761server # [699408.817161] server mobilizon_ctl[536]: 16:50:23.538 [info] alter table discussions762server # [699408.818813] server mobilizon_ctl[536]: 16:50:23.540 [info] alter table comments763server # [699408.820895] server mobilizon_ctl[536]: 16:50:23.541 [info] == Migrated 20200721131521 in 0.0s764server # [699408.826389] server mobilizon_ctl[536]: 16:50:23.547 [info] == Running 20200805124620 Mobilizon.Storage.Repo.Migrations.AddAddressToActors.change/0 forward765server # [699408.826554] server mobilizon_ctl[536]: 16:50:23.547 [info] alter table actors766server # [699408.828880] server mobilizon_ctl[536]: 16:50:23.549 [info] == Migrated 20200805124620 in 0.0s767server # [699408.837051] server mobilizon_ctl[536]: 16:50:23.558 [info] == Running 20200817080549 Mobilizon.Storage.Repo.Migrations.AddPublishedAtToEntities.up/0 forward768server # [699408.837182] server mobilizon_ctl[536]: 16:50:23.558 [info] alter table comments769server # [699408.838667] server mobilizon_ctl[536]: 16:50:23.559 [info] alter table resource770server # [699408.840102] server mobilizon_ctl[536]: 16:50:23.561 [info] alter table todo_lists771server # [699408.841406] server mobilizon_ctl[536]: 16:50:23.562 [info] alter table todos772server # [699408.843058] server mobilizon_ctl[536]: 16:50:23.563 [info] == Migrated 20200817080549 in 0.0s773server # [699408.850051] server mobilizon_ctl[536]: 16:50:23.570 [info] == Running 20200828071543 Mobilizon.Storage.Repo.Migrations.AddLoginInformationToUser.change/0 forward774server # [699408.850223] server mobilizon_ctl[536]: 16:50:23.571 [info] alter table users775server # [699408.851161] server mobilizon_ctl[536]: 16:50:23.572 [info] == Migrated 20200828071543 in 0.0s776server # [699408.859633] server mobilizon_ctl[536]: 16:50:23.580 [info] == Running 20200901101307 Mobilizon.Storage.Repo.Migrations.FixRelayVisibility.up/0 forward777server # [699408.866178] server mobilizon_ctl[536]: 16:50:23.587 [info] == Migrated 20200901101307 in 0.0s778server # [699408.872123] server mobilizon_ctl[536]: 16:50:23.593 [info] == Running 20200928150725 Mobilizon.Storage.Repo.Migrations.AddContactsToEvents.change/0 forward779server # [699408.872335] server mobilizon_ctl[536]: 16:50:23.593 [info] create table event_contacts780server # [699408.876026] server mobilizon_ctl[536]: 16:50:23.597 [info] == Migrated 20200928150725 in 0.0s781server # [699408.882062] server mobilizon_ctl[536]: 16:50:23.603 [info] == Running 20201006132530 Mobilizon.Storage.Repo.Migrations.ChangeDefaultNotificationPendingParticipation.up/0 forward782server # [699408.882202] server mobilizon_ctl[536]: 16:50:23.603 [info] alter table user_settings783server # [699408.883779] server mobilizon_ctl[536]: 16:50:23.604 [info] == Migrated 20201006132530 in 0.0s784server # [699408.892083] server mobilizon_ctl[536]: 16:50:23.613 [info] == Running 20201103141811 Mobilizon.Storage.Repo.Migrations.AddNotificationPendingMembershipToSettings.change/0 forward785server # [699408.892597] server mobilizon_ctl[536]: 16:50:23.613 [info] alter table user_settings786server # [699408.893384] server mobilizon_ctl[536]: 16:50:23.614 [info] == Migrated 20201103141811 in 0.0s787server # [699408.900367] server mobilizon_ctl[536]: 16:50:23.621 [info] == Running 20201105145719 Mobilizon.Storage.Repo.Migrations.RepairGroupsWithMissingURLs.up/0 forward788server # [699408.909594] server mobilizon_ctl[536]: 16:50:23.630 [info] == Migrated 20201105145719 in 0.0s789server # [699408.912449] server mobilizon_ctl[536]: 16:50:23.633 [info] == Running 20201114174929 Mobilizon.Storage.Repo.Migrations.FixObanMigrationsForOlderPostgreSQLVersions.up/0 forward790server # [699408.913060] server mobilizon_ctl[536]: 16:50:23.634 [info] == Migrated 20201114174929 in 0.0s791server # [699408.920075] server mobilizon_ctl[536]: 16:50:23.641 [info] == Running 20201114175249 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV9.up/0 forward792server # [699408.922015] server mobilizon_ctl[536]: 16:50:23.643 [info] == Migrated 20201114175249 in 0.0s793server # [699408.928020] server mobilizon_ctl[536]: 16:50:23.649 [info] == Running 20201120161229 Mobilizon.Storage.Repo.Migrations.FixPictureDeletion.up/0 forward794server # [699408.928265] server mobilizon_ctl[536]: 16:50:23.649 [info] drop constraint if exists posts_picture_id_fkey from table posts795server # [699408.929668] server mobilizon_ctl[536]: 16:50:23.650 [info] alter table posts796server # [699408.931256] server mobilizon_ctl[536]: 16:50:23.652 [info] drop constraint if exists events_picture_id_fkey from table events797server # [699408.932268] server mobilizon_ctl[536]: 16:50:23.653 [info] alter table events798server # [699408.934326] server mobilizon_ctl[536]: 16:50:23.655 [info] == Migrated 20201120161229 in 0.0s799server # [699408.940522] server mobilizon_ctl[536]: 16:50:23.661 [info] == Running 20201124094655 Mobilizon.Storage.Repo.Migrations.AddMediaTables.change/0 forward800server # [699408.940810] server mobilizon_ctl[536]: 16:50:23.662 [info] rename table pictures to medias801server # [699408.941593] server mobilizon_ctl[536]: 16:50:23.662 [info] create table events_medias802server # [699408.944204] server mobilizon_ctl[536]: 16:50:23.665 [info] create table posts_medias803server # [699408.946965] server mobilizon_ctl[536]: 16:50:23.668 [info] create table comments_medias804server # [699408.949659] server mobilizon_ctl[536]: 16:50:23.670 [info] == Migrated 20201124094655 in 0.0s805server # [699408.963948] server mobilizon_ctl[536]: 16:50:23.685 [info] == Running 20210127153325 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV10.up/0 forward806server # [699408.965658] server mobilizon_ctl[536]: 16:50:23.686 [info] == Migrated 20210127153325 in 0.0s807server # [699408.973420] server mobilizon_ctl[536]: 16:50:23.694 [info] == Running 20210210143432 Mobilizon.Storage.Repo.Migrations.AddLocationSettingsToUser.change/0 forward808server # [699408.973692] server mobilizon_ctl[536]: 16:50:23.694 [info] alter table user_settings809server # [699408.975469] server mobilizon_ctl[536]: 16:50:23.696 [info] == Migrated 20210210143432 in 0.0s810server # [699408.982263] server mobilizon_ctl[536]: 16:50:23.703 [info] == Running 20210215092515 Mobilizon.Storage.Repo.Migrations.AddActivityTable.change/0 forward811server # [699408.982534] server mobilizon_ctl[536]: 16:50:23.703 [info] create table activities812server # [699408.987424] server mobilizon_ctl[536]: 16:50:23.708 [info] == Migrated 20210215092515 in 0.0s813server # [699408.996883] server mobilizon_ctl[536]: 16:50:23.718 [info] == Running 20210217164549 Mobilizon.Storage.Repo.Migrations.AddMemberSinceToMembers.up/0 forward814server # [699408.997283] server mobilizon_ctl[536]: 16:50:23.718 [info] alter table members815server # [699408.999802] server mobilizon_ctl[536]: 16:50:23.720 [info] == Migrated 20210217164549 in 0.0s816server # [699409.006160] server mobilizon_ctl[536]: 16:50:23.727 [info] == Running 20210310084210 Mobilizon.Storage.Repo.Migrations.AddIndexesToActivities.change/0 forward817server # [699409.006274] server mobilizon_ctl[536]: 16:50:23.727 [info] create index activity_group_id818server # [699409.007642] server mobilizon_ctl[536]: 16:50:23.728 [info] create index activity_filter819server # [699409.009212] server mobilizon_ctl[536]: 16:50:23.730 [info] == Migrated 20210310084210 in 0.0s820server # [699409.015628] server mobilizon_ctl[536]: 16:50:23.736 [info] == Running 20210422140923 Mobilizon.Storage.Repo.Migrations.CleanupAddresses.up/0 forward821server # [699409.017714] server mobilizon_ctl[536]: 16:50:23.738 [info] == Migrated 20210422140923 in 0.0s822server # [699409.023751] server mobilizon_ctl[536]: 16:50:23.744 [info] == Running 20210422155913 Mobilizon.Storage.Repo.Migrations.AddIndexToAddresses.up/0 forward823server # [699409.024162] server mobilizon_ctl[536]: 16:50:23.745 [info] create index if not exists addresses_url_index824server # [699409.028502] server mobilizon_ctl[536]: 16:50:23.749 [info] == Migrated 20210422155913 in 0.0s825server # [699409.037559] server mobilizon_ctl[536]: 16:50:23.758 [info] == Running 20210427091034 Mobilizon.Storage.Repo.Migrations.RepairUsersDefaultActors.up/0 forward826server # [699409.039355] server mobilizon_ctl[536]: 16:50:23.760 [info] == Migrated 20210427091034 in 0.0s827server # [699409.046685] server mobilizon_ctl[536]: 16:50:23.767 [info] == Running 20210505172402 Mobilizon.Storage.Repo.Migrations.AddGroupNotificationAndLastNotificationDateSettings.change/0 forward828server # [699409.046889] server mobilizon_ctl[536]: 16:50:23.768 [info] alter table user_settings829server # [699409.047820] server mobilizon_ctl[536]: 16:50:23.768 [info] == Migrated 20210505172402 in 0.0s830server # [699409.054123] server mobilizon_ctl[536]: 16:50:23.775 [info] == Running 20210506080303 Mobilizon.Repo.Migrations.CreateUserPushSubscriptions.change/0 forward831server # [699409.054498] server mobilizon_ctl[536]: 16:50:23.775 [info] create table user_push_subscriptions832server # [699409.057683] server mobilizon_ctl[536]: 16:50:23.778 [info] create index user_push_subscriptions_user_id_digest_index833server # [699409.059111] server mobilizon_ctl[536]: 16:50:23.779 [info] == Migrated 20210506080303 in 0.0s834server # [699409.067968] server mobilizon_ctl[536]: 16:50:23.788 [info] == Running 20210512084824 Mobilizon.Storage.Repo.Migrations.RepairRelayAndAnonymousActors.up/0 forward835server # [699409.069826] server mobilizon_ctl[536]: 16:50:23.790 [info] == Migrated 20210512084824 in 0.0s836server # [699409.081035] server mobilizon_ctl[536]: 16:50:23.802 [info] == Running 20210526203337 Mobilizon.Storage.Repo.Migrations.AddUserActivitySettings.change/0 forward837server # [699409.081208] server mobilizon_ctl[536]: 16:50:23.802 [info] create table user_activity_settings838server # [699409.084613] server mobilizon_ctl[536]: 16:50:23.805 [info] create index user_activity_settings_user_id_key_method_index839server # [699409.086269] server mobilizon_ctl[536]: 16:50:23.806 [info] == Migrated 20210526203337 in 0.0s840server # [699409.094398] server mobilizon_ctl[536]: 16:50:23.815 [info] == Running 20210601082412 Mobilizon.Storage.Repo.Migrations.AddIsAnnouncementToComments.change/0 forward841server # [699409.094398] server mobilizon_ctl[536]: 16:50:23.815 [info] alter table comments842server # [699409.095560] server mobilizon_ctl[536]: 16:50:23.816 [info] == Migrated 20210601082412 in 0.0s843server # [699409.102088] server mobilizon_ctl[536]: 16:50:23.823 [info] == Running 20210601082613 Mobilizon.Storage.Repo.Migrations.FixUserSettingsNullableFields.change/0 forward844server # [699409.104077] server mobilizon_ctl[536]: 16:50:23.823 [info] alter table user_settings845server # [699409.105655] server mobilizon_ctl[536]: 16:50:23.826 [info] == Migrated 20210601082613 in 0.0s846server # [699409.110353] server mobilizon_ctl[536]: 16:50:23.831 [info] == Running 20210608133040 Mobilizon.Storage.Repo.Migrations.AddMetadataToMedia.change/0 forward847server # [699409.110489] server mobilizon_ctl[536]: 16:50:23.831 [info] alter table medias848server # [699409.111163] server mobilizon_ctl[536]: 16:50:23.832 [info] == Migrated 20210608133040 in 0.0s849server # [699409.120696] server mobilizon_ctl[536]: 16:50:23.841 [info] == Running 20210622133516 Mobilizon.Storage.Repo.Migrations.CleanupPosts.up/0 forward850server # [699409.122622] server mobilizon_ctl[536]: 16:50:23.843 [info] == Migrated 20210622133516 in 0.0s851server # [699409.129414] server mobilizon_ctl[536]: 16:50:23.850 [info] == Running 20210622133555 Mobilizon.Storage.Repo.Migrations.AddIndexToPosts.up/0 forward852server # [699409.130644] server mobilizon_ctl[536]: 16:50:23.850 [info] create index if not exists posts_url_index853server # [699409.131408] server mobilizon_ctl[536]: 16:50:23.852 [info] == Migrated 20210622133555 in 0.0s854server # [699409.138968] server mobilizon_ctl[536]: 16:50:23.860 [info] == Running 20210730143924 Mobilizon.Storage.Repo.Migrations.PutUniqueIndexOnParticipantsUrls.up/0 forward855server # [699409.139179] server mobilizon_ctl[536]: 16:50:23.860 [info] create index if not exists participants_url_index856server # [699409.141041] server mobilizon_ctl[536]: 16:50:23.861 [info] == Migrated 20210730143924 in 0.0s857server # [699409.147644] server mobilizon_ctl[536]: 16:50:23.868 [info] == Running 20210805142745 Mobilizon.Storage.Repo.Migrations.AddMetadataForEvents.change/0 forward858server # [699409.147644] server mobilizon_ctl[536]: 16:50:23.868 [info] alter table events859server # [699409.148676] server mobilizon_ctl[536]: 16:50:23.869 [info] == Migrated 20210805142745 in 0.0s860server # [699409.155607] server mobilizon_ctl[536]: 16:50:23.876 [info] == Running 20210819161507 Mobilizon.Storage.Repo.Migrations.AddLanguageToEntities.change/0 forward861server # [699409.155937] server mobilizon_ctl[536]: 16:50:23.877 [info] alter table events862server # [699409.157347] server mobilizon_ctl[536]: 16:50:23.878 [info] alter table comments863server # [699409.158604] server mobilizon_ctl[536]: 16:50:23.879 [info] alter table posts864server # [699409.160355] server mobilizon_ctl[536]: 16:50:23.881 [info] == Migrated 20210819161507 in 0.0s865server # [699409.168027] server mobilizon_ctl[536]: 16:50:23.889 [info] == Running 20211001101902 Mobilizon.Repo.Migrations.CreateExports.change/0 forward866server # [699409.168303] server mobilizon_ctl[536]: 16:50:23.889 [info] create table exports867server # [699409.171360] server mobilizon_ctl[536]: 16:50:23.892 [info] create index exports_file_path_index868server # [699409.172999] server mobilizon_ctl[536]: 16:50:23.893 [info] == Migrated 20211001101902 in 0.0s869server # [699409.182876] server mobilizon_ctl[536]: 16:50:23.903 [info] == Running 20211008084901 Mobilizon.Storage.Repo.Migrations.AddTimezoneToAddresses.change/0 forward870server # [699409.183044] server mobilizon_ctl[536]: 16:50:23.903 [info] alter table addresses871server # [699409.183722] server mobilizon_ctl[536]: 16:50:23.904 [info] == Migrated 20211008084901 in 0.0s872server # [699409.190026] server mobilizon_ctl[536]: 16:50:23.911 [info] == Running 20211013090405 Mobilizon.Storage.Repo.Migrations.AddCodeToParticipants.change/0 forward873server # [699409.190236] server mobilizon_ctl[536]: 16:50:23.911 [info] alter table participants874server # [699409.191196] server mobilizon_ctl[536]: 16:50:23.912 [info] == Migrated 20211013090405 in 0.0s875server # [699409.194375] server mobilizon_ctl[536]: 16:50:23.915 [info] == Running 20211022093530 Mobilizon.Storage.Repo.Migrations.AddNotifyToFollowers.change/0 forward876server # [699409.194495] server mobilizon_ctl[536]: 16:50:23.915 [info] alter table followers877server # [699409.196168] server mobilizon_ctl[536]: 16:50:23.917 [info] == Migrated 20211022093530 in 0.0s878server # [699409.201858] server mobilizon_ctl[536]: 16:50:23.923 [info] == Running 20211223141104 Mobilizon.Storage.Repo.Migrations.AddInstanceMaterializedView.up/0 forward879server # [699409.204500] server mobilizon_ctl[536]: 16:50:23.925 [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"880server # [699409.218017] server mobilizon_ctl[536]: 16:50:23.939 [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"881server # [699409.218639] server mobilizon_ctl[536]: 16:50:23.939 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger ON actors;\n"882server # [699409.219084] server mobilizon_ctl[536]: 16:50:23.940 [info] trigger "refresh_instances_trigger" for relation "actors" does not exist, skipping883server # [699409.219084] server mobilizon_ctl[536]: 16:50:23.940 [info] execute "CREATE TRIGGER refresh_instances_trigger\nAFTER INSERT OR UPDATE OR DELETE\nON actors\nFOR EACH STATEMENT\nEXECUTE PROCEDURE refresh_instances();\n"884server # [699409.219611] server mobilizon_ctl[536]: 16:50:23.940 [info] create index if not exists instances_domain_index885server # [699409.222952] server mobilizon_ctl[536]: 16:50:23.943 [info] == Migrated 20211223141104 in 0.0s886server # [699409.232592] server mobilizon_ctl[536]: 16:50:23.953 [info] == Running 20220321154138 Mobilizon.Storage.Repo.Migrations.CreateObanPeers.up/0 forward887server # [699409.234429] server mobilizon_ctl[536]: 16:50:23.955 [info] == Migrated 20220321154138 in 0.0s888server # [699409.239566] server mobilizon_ctl[536]: 16:50:23.960 [info] == Running 20220321154142 Mobilizon.Storage.Repo.Migrations.SwapPrimaryObanIndexes.change/0 forward889server # [699409.239852] server mobilizon_ctl[536]: 16:50:23.960 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index890server # [699409.241138] server mobilizon_ctl[536]: 16:50:23.962 [info] relation "oban_jobs_state_queue_priority_scheduled_at_id_index" already exists, skipping891server # [699409.241138] server mobilizon_ctl[536]: 16:50:23.962 [info] drop index if exists public.oban_jobs_queue_state_priority_scheduled_at_id_index892server # [699409.241848] server mobilizon_ctl[536]: 16:50:23.962 [info] index "oban_jobs_queue_state_priority_scheduled_at_id_index" does not exist, skipping893server # [699409.242063] server mobilizon_ctl[536]: 16:50:23.963 [info] == Migrated 20220321154142 in 0.0s894server # [699409.247774] server mobilizon_ctl[536]: 16:50:23.968 [info] == Running 20220328153640 Mobilizon.Storage.Repo.Migrations.SetAllEventsCategoryToMeeting.up/0 forward895server # [699409.247774] server mobilizon_ctl[536]: 16:50:23.969 [info] execute "UPDATE events SET category = 'MEETING'"896server # [699409.248906] server mobilizon_ctl[536]: 16:50:23.969 [info] == Migrated 20220328153640 in 0.0s897server # [699409.256037] server mobilizon_ctl[536]: 16:50:23.977 [info] == Running 20220407083712 Mobilizon.Storage.Repo.Migrations.AddIndexesToAddresses.up/0 forward898server # [699409.256336] server mobilizon_ctl[536]: 16:50:23.977 [info] create index if not exists idx_addresses_geom_x899server # [699409.258216] server mobilizon_ctl[536]: 16:50:23.979 [info] create index if not exists idx_addresses_geom_y900server # [699409.259719] server mobilizon_ctl[536]: 16:50:23.980 [info] == Migrated 20220407083712 in 0.0s901server # [699409.267264] server mobilizon_ctl[536]: 16:50:23.988 [info] == Running 20220505091224 Mobilizon.Storage.Repo.Migrations.ChangeRefreshInstanceTriggerToOnlyExecuteOnRelays.up/0 forward902server # [699409.267473] server mobilizon_ctl[536]: 16:50:23.988 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger ON actors;\n"903server # [699409.268361] server mobilizon_ctl[536]: 16:50:23.989 [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"904server # [699409.269438] server mobilizon_ctl[536]: 16:50:23.990 [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"905server # [699409.270290] server mobilizon_ctl[536]: 16:50:23.991 [info] == Migrated 20220505091224 in 0.0s906server # [699409.276633] server mobilizon_ctl[536]: 16:50:23.997 [info] == Running 20220506105150 Mobilizon.Storage.Repo.Migrations.RemoveRefreshInstanceTriggers.up/0 forward907server # [699409.276843] server mobilizon_ctl[536]: 16:50:23.997 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger_new ON actors;\n"908server # [699409.277646] server mobilizon_ctl[536]: 16:50:23.998 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger_old ON actors;\n"909server # [699409.278494] server mobilizon_ctl[536]: 16:50:23.999 [info] == Migrated 20220506105150 in 0.0s910server # [699409.286071] server mobilizon_ctl[536]: 16:50:24.007 [info] == Running 20230208101626 Mobilizon.Repo.Migrations.CreateApplications.change/0 forward911server # [699409.286374] server mobilizon_ctl[536]: 16:50:24.007 [info] create table applications912server # [699409.289850] server mobilizon_ctl[536]: 16:50:24.010 [info] create index applications_owner_id_owner_type_index913server # [699409.291389] server mobilizon_ctl[536]: 16:50:24.012 [info] == Migrated 20230208101626 in 0.0s914server # [699409.298606] server mobilizon_ctl[536]: 16:50:24.019 [info] == Running 20230215125801 Mobilizon.Repo.Migrations.CreateApplicationTokens.change/0 forward915server # [699409.298862] server mobilizon_ctl[536]: 16:50:24.020 [info] create table application_tokens916server # [699409.305977] server mobilizon_ctl[536]: 16:50:24.026 [info] create index application_tokens_user_id_application_id_index917server # [699409.307166] server mobilizon_ctl[536]: 16:50:24.028 [info] == Migrated 20230215125801 in 0.0s918server # [699409.314198] server mobilizon_ctl[536]: 16:50:24.035 [info] == Running 20230217084253 Mobilizon.Repo.Migrations.CreateApplicationDeviceActivation.change/0 forward919server # [699409.314682] server mobilizon_ctl[536]: 16:50:24.035 [info] create table application_device_activation920server # [699409.319872] server mobilizon_ctl[536]: 16:50:24.040 [info] == Migrated 20230217084253 in 0.0s921server # [699409.329565] server mobilizon_ctl[536]: 16:50:24.050 [info] == Running 20230605143534 Mobilizon.Storage.Repo.Migrations.AllowMultipleEventsToBeReported.up/0 forward922server # [699409.329973] server mobilizon_ctl[536]: 16:50:24.051 [info] create table reports_events923server # [699409.332367] server mobilizon_ctl[536]: 16:50:24.053 [info] == Migrated 20230605143534 in 0.0s924server # [699409.341382] server mobilizon_ctl[536]: 16:50:24.062 [info] == Running 20230605153836 Mobilizon.Storage.Repo.Migrations.BackfillReportEventsWithOldEvents.up/0 forward925server # [699409.342282] server mobilizon_ctl[536]: 16:50:24.063 [info] == Migrated 20230605153836 in 0.0s926server # [699409.347990] server mobilizon_ctl[536]: 16:50:24.069 [info] == Running 20230605154106 Mobilizon.Storage.Repo.Migrations.RemoveObsoleteEventIdOnReports.up/0 forward927server # [699409.348121] server mobilizon_ctl[536]: 16:50:24.069 [info] alter table reports928server # [699409.349151] server mobilizon_ctl[536]: 16:50:24.070 [info] == Migrated 20230605154106 in 0.0s929server # [699409.356701] server mobilizon_ctl[536]: 16:50:24.077 [info] == Running 20230831153358 Mobilizon.Storage.Repo.Migrations.RemoveOnDeleteCascadeForReports.up/0 forward930server # [699409.357273] server mobilizon_ctl[536]: 16:50:24.078 [info] execute "DROP MATERIALIZED VIEW IF EXISTS instances;\n"931server # [699409.359967] server mobilizon_ctl[536]: 16:50:24.081 [info] drop constraint reports_reported_id_fkey from table reports932server # [699409.361309] server mobilizon_ctl[536]: 16:50:24.082 [info] drop constraint reports_reporter_id_fkey from table reports933server # [699409.362284] server mobilizon_ctl[536]: 16:50:24.083 [info] drop constraint reports_manager_id_fkey from table reports934server # [699409.363398] server mobilizon_ctl[536]: 16:50:24.084 [info] alter table reports935server # [699409.366290] server mobilizon_ctl[536]: 16:50:24.087 [info] drop constraint report_notes_moderator_id_fkey from table report_notes936server # [699409.367073] server mobilizon_ctl[536]: 16:50:24.088 [info] alter table report_notes937server # [699409.368916] server mobilizon_ctl[536]: 16:50:24.090 [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"938server # [699409.391048] server mobilizon_ctl[536]: 16:50:24.105 [info] == Migrated 20230831153358 in 0.0s939server # [699409.421224] server mobilizon_ctl[536]: 16:50:24.142 [info] == Running 20230901160000 Mobilizon.Storage.Repo.Migrations.AddExternalUrlForEvents.up/0 forward940server # [699409.421224] server mobilizon_ctl[536]: 16:50:24.142 [info] alter table events941server # [699409.422396] server mobilizon_ctl[536]: 16:50:24.143 [info] execute "ALTER TABLE events ALTER COLUMN join_options TYPE VARCHAR USING join_options::text"942server # [699409.428256] server mobilizon_ctl[536]: 16:50:24.148 [info] execute "ALTER TABLE events ALTER COLUMN join_options DROP DEFAULT"943server # [699409.429044] server mobilizon_ctl[536]: 16:50:24.150 [info] execute "DROP TYPE public.join_options"944server # [699409.430978] server mobilizon_ctl[536]: 16:50:24.151 [info] execute "CREATE TYPE public.join_options AS ENUM ('free', 'restricted', 'invite', 'external')"945server # [699409.431571] server mobilizon_ctl[536]: 16:50:24.152 [info] execute "ALTER TABLE events ALTER COLUMN join_options TYPE join_options USING join_options::join_options"946server # [699409.436831] server mobilizon_ctl[536]: 16:50:24.157 [info] execute "ALTER TABLE events ALTER COLUMN join_options SET DEFAULT 'free'::join_options"947server # [699409.437689] server mobilizon_ctl[536]: 16:50:24.158 [info] == Migrated 20230901160000 in 0.0s948server # [699409.466841] server mobilizon_ctl[536]: 16:50:24.188 [info] == Running 20230920071502 Mobilizon.Storage.Repo.Migrations.AddActorConversations.up/0 forward949server # [699409.467142] server mobilizon_ctl[536]: 16:50:24.188 [info] create table conversations950server # [699409.473416] server mobilizon_ctl[536]: 16:50:24.194 [info] create table conversation_participants951server # [699409.476251] server mobilizon_ctl[536]: 16:50:24.197 [info] alter table comments952server # [699409.477759] server mobilizon_ctl[536]: 16:50:24.198 [info] == Migrated 20230920071502 in 0.0s953server # [699409.502132] server mobilizon_ctl[536]: 16:50:24.223 [info] == Running 20231220092536 Mobilizon.Storage.Repo.Migrations.AddActorInstances.change/0 forward954server # [699409.502479] server mobilizon_ctl[536]: 16:50:24.223 [info] create table instance_actors955server # [699409.506150] server mobilizon_ctl[536]: 16:50:24.227 [info] create index instance_actors_domain_index956server # [699409.507451] server mobilizon_ctl[536]: 16:50:24.228 [info] == Migrated 20231220092536 in 0.0s957server # [699409.528090] server mobilizon_ctl[536]: 16:50:24.248 [info] == Running 20240104103036 Mobilizon.Storage.Repo.Migrations.ChangeActorInstanceDescriptionTypeToText.up/0 forward958server # [699409.528531] server mobilizon_ctl[536]: 16:50:24.249 [info] alter table instance_actors959server # [699409.532700] server mobilizon_ctl[536]: 16:50:24.253 [info] == Migrated 20240104103036 in 0.0s960server # [699409.540870] server mobilizon_ctl[536]: 16:50:24.262 [info] == Running 20240222121054 Mobilizon.Storage.Repo.Migrations.CreateAdminSettingsMedias.change/0 forward961server # [699409.541157] server mobilizon_ctl[536]: 16:50:24.262 [info] create table admin_settings_medias962server # [699409.544969] server mobilizon_ctl[536]: 16:50:24.266 [info] create index admin_settings_medias_group_name_index963server # [699409.546128] server mobilizon_ctl[536]: 16:50:24.267 [info] == Migrated 20240222121054 in 0.0s964server # [699409.559901] server mobilizon_ctl[536]: 16:50:24.281 [info] == Running 20240725130410 Mobilizon.Storage.Repo.Migrations.AddEventPhysicalAddressIndex.up/0 forward965server # [699409.560295] server mobilizon_ctl[536]: 16:50:24.281 [info] create index events_phys_addr_id966server # [699409.564086] server mobilizon_ctl[536]: 16:50:24.283 [info] == Migrated 20240725130410 in 0.0s967server # [699409.575257] server mobilizon_ctl[536]: 16:50:24.296 [info] == Running 20250521145952 Mobilizon.Storage.Repo.Migrations.AddUuidToMedia.change/0 forward968server # [699409.575420] server mobilizon_ctl[536]: 16:50:24.296 [info] alter table medias969server # [699409.579181] server mobilizon_ctl[536]: 16:50:24.300 [info] create index medias_uuid_index970server # [699409.580687] server mobilizon_ctl[536]: 16:50:24.301 [info] == Migrated 20250521145952 in 0.0s971server # [699409.595346] server mobilizon_ctl[536]: 16:50:24.316 [info] == Running 20250911120910 Mobilizon.Storage.Repo.Migrations.AddModerationToUser.change/0 forward972server # [699409.595579] server mobilizon_ctl[536]: 16:50:24.316 [info] alter table users973server # [699409.598047] server mobilizon_ctl[536]: 16:50:24.318 [info] == Migrated 20250911120910 in 0.0s974server # [699409.604752] server mobilizon_ctl[536]: 16:50:24.325 [info] == Running 20250919143627 Mobilizon.Storage.Repo.Migrations.UpdateRoleToUser.change/0 forward975server # [699409.605035] server mobilizon_ctl[536]: 16:50:24.326 [info] execute "ALTER TYPE user_role ADD VALUE IF NOT EXISTS 'pending';"976server # [699409.605453] server mobilizon_ctl[536]: 16:50:24.326 [info] enum label "pending" already exists, skipping977server # [699409.605732] server mobilizon_ctl[536]: 16:50:24.326 [info] == Migrated 20250919143627 in 0.0s978server # [699409.610744] server mobilizon_ctl[536]: 16:50:24.331 [info] == Running 20251027133219 Mobilizon.Storage.Repo.Migrations.CreateInvitations.change/0 forward979server # [699409.610954] server mobilizon_ctl[536]: 16:50:24.332 [info] create table invitations980server # [699409.615943] server mobilizon_ctl[536]: 16:50:24.337 [info] create index invitations_token_index981server # [699409.616959] server mobilizon_ctl[536]: 16:50:24.338 [info] == Migrated 20251027133219 in 0.0s982server # [699409.623838] server mobilizon_ctl[536]: 16:50:24.345 [info] == Running 20251111093015 Mobilizon.Storage.Repo.Migrations.AddAllowToGroup.change/0 forward983server # [699409.624255] server mobilizon_ctl[536]: 16:50:24.345 [info] alter table actors984server # [699409.625323] server mobilizon_ctl[536]: 16:50:24.346 [info] == Migrated 20251111093015 in 0.0s985server # [699409.653145] server systemd[1]: Started Mobilizon federated organization and mobilization platform.986server # [699409.653874] server systemd[1]: Reached target Multi-User System.987server # [699409.654541] server systemd[1]: Startup finished in 16.940s.988server: (finished: waiting for unit mobilizon.service, in 17.71 seconds)989server: waiting for TCP port 41395 on localhost990Connection to localhost (::1) 41395 port [tcp/*] succeeded!991server: (finished: waiting for TCP port 41395 on localhost, in 4.07 seconds)992server: must succeed: curl --fail https://acme.test/993 % Total % Received % Xferd Average Speed Time Time Time Current994 Dload Upload Total Spent Left Speed995100 2289 100 2289 0 0 68608 0 0996server: (finished: must succeed: curl --fail https://acme.test/, in 0.05 seconds)997(finished: run the VM test script, in 21.83 seconds)998server # [699413.729120] server mobilizon[599]: 16:50:28.450 [info] No tzdata release files found in custom data dir. Copying release file from tzdata priv dir.999server # [699413.846473] server mobilizon[599]: 16:50:28.566 [info] Source for database :city not found: "/var/lib/mobilizon/geo/GeoLite2-City.mmdb"1000server # [699413.893229] server mobilizon[599]: 16:50:28.614 [info] Loading 122 CA(s) from :otp store1001server # [699413.914743] server mobilizon[599]: 16:50:28.635 [info] Running Mobilizon.Web.Endpoint with Bandit 1.12.0 at ::1:41395 (http)1002server # [699413.916342] server mobilizon[599]: 16:50:28.636 [info] Access Mobilizon.Web.Endpoint at https://acme.test1003server # [699413.931508] server mobilizon[599]: 16:50:28.652 [info] {"message":"notifier only receiving messages from its own node, functionality may be degraded","source":"oban","event":"notifier:switch","connectivity_status":"solitary"}1004server # [699413.931790] server mobilizon[599]: 16:50:28.652 [info] {"message":"peer became leader","node":"mobilizon@server","source":"oban","event":"peer:election","leader":true,"was_leader":false}1005server # [699413.965995] server mobilizon[599]: 16:50:28.687 request_id=GNmKJ2anQtHinBAAAAAC [info] GET /1006server # [699413.970789] server mobilizon[599]: 16:50:28.691 request_id=GNmKJ2anQtHinBAAAAAC [info] Sent 200 in 4ms1007test script finished in 21.96s1008cleanup1009kill NspawnMachine (pid 50)1010Container server terminated by signal KILL.1011(finished: cleanup, in 0.16 seconds)