container-test-run-mobilizon
checks.aarch64-linux.nixosTest
· build #13
· 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.340329] server systemd-journald[57]: Journal started21server # [699393.340379] server systemd-journald[57]: Runtime Journal (/run/log/journal/d263007ad05b41b4a0545bf9b496f64a) is 8M, max 311.2M, 303.2M free.22server # [699393.365920] server systemd[1]: Listening on Journal Log Access Socket.23server # [699393.366883] server systemd[1]: Finished Apply Kernel Variables.24server # [699393.384678] server systemd[1]: Finished Create Static Device Nodes in /dev gracefully.25server # [699393.403918] server systemd[1]: Starting Flush Journal to Persistent Storage...26server # [699393.404965] server systemd[1]: Starting Create Static Device Nodes in /dev...27server # [699393.442059] server systemd-journald[57]: Time spent on flushing to /var/log/journal/d263007ad05b41b4a0545bf9b496f64a is 1.780ms for 7 entries.28server # [699393.442059] server systemd-journald[57]: System Journal (/var/log/journal/d263007ad05b41b4a0545bf9b496f64a) is 512B, max 4G, 3.9G free.29server # [699393.454412] server systemd[1]: Finished Create Static Device Nodes in /dev.30server # [699393.455466] server systemd[1]: Reached target Preparation for Local File Systems.31server # [699393.455729] server systemd[1]: Rule-based Manager for Device Events and Files skipped, unmet condition check ConditionPathIsReadWrite=/sys32server # [699393.487910] server systemd[1]: Finished Flush Journal to Persistent Storage.33server # [699393.561408] server systemd[1]: Finished Firewall.34server # [699394.347311] server systemd[1]: Mounting /run/wrappers...35server # [699394.401471] server systemd[1]: Mounted /run/wrappers.36server # [699394.402337] server systemd[1]: Reached target Local File Systems.37server # [699394.405076] server systemd[1]: Listening on Boot Loader Control Service Socket.38server # [699394.406331] server systemd[1]: Starting Create SUID/SGID Wrappers...39server # [699394.406378] server systemd[1]: Update Boot Loader Random Seed skipped, unmet condition check ConditionVirtualization=!container40server # [699394.407414] server systemd[1]: Starting Save Transient machine-id to Disk...41server # [699394.408496] server systemd[1]: Starting Create System Files and Directories...42server # [699394.425465] server systemd-tmpfiles[161]: Cannot set file attributes for '/var/empty', value=0x00000010, mask=0x00000010, ignoring: Operation not permitted43server # [699394.425865] server systemd-tmpfiles[161]: fchmod() of /var/log/journal failed: Operation not permitted44server # [699394.425983] server systemd-tmpfiles[161]: fchmod() of /var/log/journal/d263007ad05b41b4a0545bf9b496f64a failed: Operation not permitted45server # [699394.426130] server systemd-tmpfiles[161]: fchmod() of /run/log/journal failed: Operation not permitted46server # [699394.435607] server systemd[1]: Finished Create System Files and Directories.47server # [699394.436811] server suid-sgid-wrappers-start[168]: chmod: changing permissions of '/run/wrappers/wrappers.rZWAbHegqx/chsh': Operation not permitted48server # [699394.453146] server systemd[1]: suid-sgid-wrappers.service: Main process exited, code=exited, status=1/FAILURE49server # [699394.453245] server systemd[1]: suid-sgid-wrappers.service: Failed with result 'exit-code'.50server # [699394.453377] server systemd[1]: Failed to start Create SUID/SGID Wrappers.51server # [699394.455822] server systemd[1]: Starting Rebuild Journal Catalog...52server # [699394.456737] server systemd[1]: Starting Record System Boot/Shutdown in UTMP...53server # [699394.489718] server systemd[1]: Finished Record System Boot/Shutdown in UTMP.54server # [699394.517802] server systemd[1]: Finished Rebuild Journal Catalog.55server # [699394.520862] server systemd[1]: Starting Update is Completed...56server # [699394.533088] server systemd[1]: Finished Update is Completed.57server # [699394.533470] server systemd[1]: Reached target System Initialization.58server # [699394.533851] server systemd[1]: Discard unused filesystem blocks once a week skipped, unmet condition check ConditionVirtualization=!container59server # [699394.534188] server systemd[1]: Started Daily Cleanup of Temporary Directories.60server # [699394.534245] server systemd[1]: Reached target Timer Units.61server # [699394.534431] server systemd[1]: Listening on D-Bus System Message Bus Socket.62server # [699394.534674] server systemd[1]: Listening on Nix Daemon Socket.63server # [699394.534818] server systemd[1]: Listening on Virtual Machine and Container Registration Service Socket.64server # [699394.534856] server systemd[1]: Reached target Socket Units.65server # [699394.534909] server systemd[1]: Reached target Basic System.66server # [699394.536495] server systemd[1]: Starting Import lastlog data into lastlog2 database...67server # [699394.537955] server systemd[1]: Starting Name Service Cache Daemon (nsncd)...68server # [699394.540213] server systemd[1]: Starting resolvconf update...69server # [699394.561495] server systemd[1]: Finished Import lastlog data into lastlog2 database.70server # [699394.633625] server systemd[1]: etc-machine\x2did.mount: Deactivated successfully.71server # [699394.635702] server systemd[1]: Finished Save Transient machine-id to Disk.72server # [699394.644977] server systemd[1]: nscd.service: Deactivated successfully.73server # [699394.645172] server systemd[1]: Stopped Name Service Cache Daemon (nsncd).74server # [699394.657321] server systemd[1]: Starting Name Service Cache Daemon (nsncd)...75server # [699394.670456] server resolvconf-start[236]: setfacl: /run/resolvconf: Operation not supported76server # [699394.671564] server systemd[1]: resolvconf.service: Main process exited, code=exited, status=1/FAILURE77server # [699394.671685] server systemd[1]: resolvconf.service: Failed with result 'exit-code'.78server # [699394.671899] server systemd[1]: Failed to start resolvconf update.79server # [699394.672690] server systemd[1]: Reached target Preparation for Network.80server # [699394.674071] server systemd[1]: Starting Address configuration of eth1...81server # [699394.675467] server systemd[1]: Starting Extra networking commands....82server # [699394.697370] server network-addresses-eth1-start[238]: adding address 192.168.1.1/24... done83server # [699394.702844] server network-addresses-eth1-start[238]: adding address 2001:db8:1::1/64... done84server # [699394.707129] server systemd[1]: Finished Address configuration of eth1.85server # [699394.756588] server systemd[1]: Finished Extra networking commands..86server # [699394.756792] server systemd[1]: Reached target Network.87server # [699394.758403] server systemd[1]: Starting Nginx Web Server...88server # [699394.760938] server systemd[1]: Starting PostgreSQL Server...89server # [699394.885586] server systemd[1]: Started Name Service Cache Daemon (nsncd).90server # [699394.885659] server systemd[1]: Reached target Host and Network Name Lookups.91server # [699394.885714] server systemd[1]: Reached target User and Group Name Lookups.92server # [699394.887161] server systemd[1]: Starting User Login Management...93server # [699394.888096] server nsncd[230]: Sep 28 16:50:09.606 INFO started, config: Config { ignored_request_types: {}, worker_count: 8, handoff_timeout: 10s }, path: "/var/run/nscd/socket"94server # [699394.888172] server systemd[1]: Starting Permit User Sessions...95server # [699394.917351] server systemd[1]: Finished Permit User Sessions.96server # [699394.920107] server systemd[1]: Started Console Getty.97server # [699394.921032] server systemd[1]: Getty on tty1 skipped, unmet condition check ConditionPathExists=/dev/tty098server # [699394.921208] server systemd[1]: Reached target Login Prompts.99server # [699396.292877] server systemd[1]: Starting D-Bus System Message Bus...100server # [699396.293257] server systemd-logind[305]: New seat seat0.101server # [699396.300245] server systemd[1]: Started User Login Management.102server # [699396.301576] server systemd[1]: Starting linger-users.service...103server # [699396.316786] server postgresql-pre-start[326]: The files belonging to this database system will be owned by user "postgres".104server # [699396.316786] server postgresql-pre-start[326]: This user must also own the server process.105server # [699396.317282] server postgresql-pre-start[326]: The database cluster will be initialized with locale "en_US.UTF-8".106server # [699396.317282] server postgresql-pre-start[326]: The default database encoding has accordingly been set to "UTF8".107server # [699396.317282] server postgresql-pre-start[326]: The default text search configuration will be set to "english".108server # [699396.317282] server postgresql-pre-start[326]: Data page checksums are disabled.109server # [699396.317282] server postgresql-pre-start[326]: fixing permissions on existing directory /var/lib/postgresql/17 ... ok110server # [699396.317964] server postgresql-pre-start[326]: creating subdirectories ... ok111server # [699396.318086] server postgresql-pre-start[326]: selecting dynamic shared memory implementation ... posix112server # [699396.326209] server systemd[1]: linger-users.service: Deactivated successfully.113server # [699396.326380] server systemd[1]: Finished linger-users.service.114server # [699396.346748] server postgresql-pre-start[326]: selecting default "max_connections" ... 100115server # [699396.356627] server nginx-pre-start[333]: nginx: the configuration file /nix/store/qki08h1qws5r1c412wgkrmjcij7i9qdr-nginx.conf syntax is ok116server # [699396.357320] server nginx-pre-start[333]: nginx: configuration file /nix/store/qki08h1qws5r1c412wgkrmjcij7i9qdr-nginx.conf test is successful117server # [699396.363594] server systemd[1]: Started Nginx Web Server.118server # [699396.375622] server postgresql-pre-start[326]: selecting default "shared_buffers" ... 128MB119server # [699396.787659] server dbus-broker-launch[324]: Looking up NSS user entry for 'systemd-timesync'...120server # [699396.788641] server dbus-broker-launch[324]: NSS returned no entry for 'systemd-timesync'121server # [699396.788744] server dbus-broker-launch[324]: Invalid user-name in /nix/store/732kjl1756b4hpzk62lg7sgzswc6fkfr-system-path/share/dbus-1/system.d/org.freedesktop.timesync1.conf +16: user="systemd-timesync"122server # [699396.789375] server systemd[1]: Started D-Bus System Message Bus.123server # [699396.802651] server dbus-broker-launch[324]: Ready124server # [699397.999718] server postgresql-pre-start[326]: selecting default time zone ... UTC125server # [699398.002636] server postgresql-pre-start[326]: creating configuration files ... ok126server # [699398.173093] server postgresql-pre-start[326]: running bootstrap script ... ok127server # [699398.671637] server postgresql-pre-start[326]: performing post-bootstrap initialization ... ok128server # [699399.399359] server postgresql-pre-start[326]: syncing data to disk ... ok129server # [699399.399359] server postgresql-pre-start[326]: initdb: warning: enabling "trust" authentication for local connections130server # [699399.399359] server postgresql-pre-start[326]: 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.399359] server postgresql-pre-start[326]: Success. You can now start the database server using:132server # [699399.399359] server postgresql-pre-start[326]: pg_ctl -D /var/lib/postgresql/17 -l logfile start133server # [699400.756814] server postgres[349]: [349] LOG: starting PostgreSQL 17.10 on aarch64-unknown-linux-gnu, compiled by clang version 21.1.8, 64-bit134server # [699400.757787] server postgres[349]: [349] LOG: listening on IPv6 address "::1", port 5432135server # [699400.757787] server postgres[349]: [349] LOG: listening on IPv4 address "127.0.0.1", port 5432136server # [699400.759591] server postgres[349]: [349] LOG: listening on Unix socket "/run/postgresql/.s.PGSQL.5432"137server # [699400.772429] server postgres[356]: [356] LOG: database system was shut down at 2026-09-28 16:50:13 GMT138server # [699400.780986] server postgres[349]: [349] LOG: database system is ready to accept connections139server # [699400.785898] server systemd[1]: Started PostgreSQL Server.140server # [699400.788291] server systemd[1]: Starting PostgreSQL Setup Scripts...141server # [699400.963771] server postgresql-setup-start[367]: CREATE DATABASE142server # [699400.995322] server postgresql-setup-start[372]: CREATE ROLE143server # [699400.997899] server systemd[1]: Finished PostgreSQL Setup Scripts.144server # [699400.998575] server systemd[1]: Reached target PostgreSQL.145server # [699401.000491] server systemd[1]: Starting Mobilizon PostgreSQL setup...146server # [699401.557875] server mobilizon-postgresql-start[376]: CREATE EXTENSION147server # [699401.557875] server mobilizon-postgresql-start[376]: CREATE EXTENSION148server # [699401.557875] server mobilizon-postgresql-start[376]: CREATE EXTENSION149server # [699401.573436] server mobilizon-postgresql-start[378]: ALTER DATABASE150server # [699401.575623] server systemd[1]: mobilizon-postgresql.service: Deactivated successfully.151server # [699401.575885] server systemd[1]: Finished Mobilizon PostgreSQL setup.152server # [699401.577602] server systemd[1]: Starting Mobilizon setup secrets...153server # [699401.615890] server mobilizon-setup-secrets-start[381]: + '[' '!' -f /var/lib/mobilizon/secret-env.sh ']'154server # [699401.615890] server mobilizon-setup-secrets-start[381]: + install -m 600 /dev/null /var/lib/mobilizon/secret-env.sh155server # [699401.618922] server mobilizon-setup-secrets-start[381]: + cat156server # [699401.620063] 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.114316] 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.623122] 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.117000] server systemd[1]: mobilizon-setup-secrets.service: Deactivated successfully.161server # [699403.117310] server systemd[1]: Finished Mobilizon setup secrets.162server # [699403.117596] server systemd[1]: mobilizon-setup-secrets.service: Consumed 1.994s CPU time over 1.539s wall clock time.163server # [699403.121088] server systemd[1]: Starting Mobilizon federated organization and mobilization platform...164server # [699404.117406] server mobilizon_ctl[536]: Loading app..165server # [699404.117406] server mobilizon_ctl[536]: Starting dependencies..166server # [699407.335554] server mobilizon_ctl[536]: #########################################################167server # [699407.335554] server mobilizon_ctl[536]: # If the CREATE EXTENSION or DROP EXTENSION calls fail, #168server # [699407.335554] server mobilizon_ctl[536]: # please manually execute them with an authorized #169server # [699407.335554] server mobilizon_ctl[536]: # PostgreSQL user with SUPER USER role. #170server # [699407.335554] server mobilizon_ctl[536]: #########################################################171server # [699407.335554] server mobilizon_ctl[536]:172server # [699407.335554] server mobilizon_ctl[536]:173server # [699407.335554] server mobilizon_ctl[536]: 16:50:22.054 [info] == Running 20180109150000 Mobilizon.Repo.Migrations.Prerequites.up/0 forward174server # [699407.338144] server mobilizon_ctl[536]: 16:50:22.059 [info] execute "CREATE TYPE datetimetz AS (\n dt timestamptz,\n tz varchar\n);\n"175server # [699407.341563] server mobilizon_ctl[536]: 16:50:22.062 [info] execute "CREATE EXTENSION IF NOT EXISTS postgis"176server # [699407.342879] server mobilizon_ctl[536]: 16:50:22.063 [info] extension "postgis" already exists, skipping177server # [699407.343130] server mobilizon_ctl[536]: 16:50:22.063 [info] execute "CREATE EXTENSION IF NOT EXISTS pg_trgm"178server # [699407.343558] server mobilizon_ctl[536]: 16:50:22.064 [info] extension "pg_trgm" already exists, skipping179server # [699407.343692] server mobilizon_ctl[536]: 16:50:22.064 [info] execute "CREATE EXTENSION IF NOT EXISTS unaccent"180server # [699407.344056] server mobilizon_ctl[536]: 16:50:22.065 [info] extension "unaccent" already exists, skipping181server # [699407.346358] server mobilizon_ctl[536]: 16:50:22.067 [info] == Migrated 20180109150000 in 0.0s182server # [699407.384497] server mobilizon_ctl[536]: 16:50:22.105 [info] == Running 20180109165738 Mobilizon.Repo.Migrations.CreateAccounts.change/0 forward183server # [699407.384987] server mobilizon_ctl[536]: 16:50:22.106 [info] create table accounts184server # [699407.390460] server mobilizon_ctl[536]: 16:50:22.111 [info] create index accounts_username_domain_index185server # [699407.391752] server mobilizon_ctl[536]: 16:50:22.112 [info] == Migrated 20180109165738 in 0.0s186server # [699407.401154] server mobilizon_ctl[536]: 16:50:22.122 [info] == Running 20180109170315 Mobilizon.Repo.Migrations.CreateUsers.change/0 forward187server # [699407.401545] server mobilizon_ctl[536]: 16:50:22.122 [info] create table users188server # [699407.406443] server mobilizon_ctl[536]: 16:50:22.127 [info] create index users_email_index189server # [699407.407656] server mobilizon_ctl[536]: 16:50:22.128 [info] == Migrated 20180109170315 in 0.0s190server # [699407.414994] server mobilizon_ctl[536]: 16:50:22.136 [info] == Running 20180110091747 Mobilizon.Repo.Migrations.CreateCategories.change/0 forward191server # [699407.415254] server mobilizon_ctl[536]: 16:50:22.136 [info] create table categories192server # [699407.418203] server mobilizon_ctl[536]: 16:50:22.139 [info] create index categories_title_index193server # [699407.419314] server mobilizon_ctl[536]: 16:50:22.140 [info] == Migrated 20180110091747 in 0.0s194server # [699407.424610] server mobilizon_ctl[536]: 16:50:22.145 [info] == Running 20180110092400 Mobilizon.Repo.Migrations.CreateAddresses.change/0 forward195server # [699407.424942] server mobilizon_ctl[536]: 16:50:22.146 [info] create table addresses196server # [699407.427922] server mobilizon_ctl[536]: 16:50:22.148 [info] == Migrated 20180110092400 in 0.0s197server # [699407.434905] server mobilizon_ctl[536]: 16:50:22.155 [info] == Running 20180110092500 Mobilizon.Repo.Migrations.CreateGroups.change/0 forward198server # [699407.435398] server mobilizon_ctl[536]: 16:50:22.156 [info] create table groups199server # [699407.440696] server mobilizon_ctl[536]: 16:50:22.161 [info] create index groups_slug_index200server # [699407.442023] server mobilizon_ctl[536]: 16:50:22.162 [info] == Migrated 20180110092500 in 0.0s201server # [699407.448753] server mobilizon_ctl[536]: 16:50:22.169 [info] == Running 20180110092600 Mobilizon.Repo.Migrations.CreateEvents.change/0 forward202server # [699407.449310] server mobilizon_ctl[536]: 16:50:22.170 [info] create table events203server # [699407.456860] server mobilizon_ctl[536]: 16:50:22.177 [info] create index events_organizer_account_id_index204server # [699407.458105] server mobilizon_ctl[536]: 16:50:22.179 [info] create index events_organizer_group_id_index205server # [699407.459130] server mobilizon_ctl[536]: 16:50:22.180 [info] create index events_slug_index206server # [699407.460286] server mobilizon_ctl[536]: 16:50:22.181 [info] == Migrated 20180110092600 in 0.0s207server # [699407.467493] server mobilizon_ctl[536]: 16:50:22.188 [info] == Running 20180110093905 Mobilizon.Repo.Migrations.CreateTags.change/0 forward208server # [699407.467897] server mobilizon_ctl[536]: 16:50:22.189 [info] create table tags209server # [699407.470261] server mobilizon_ctl[536]: 16:50:22.191 [info] create index tags_slug_index210server # [699407.471324] server mobilizon_ctl[536]: 16:50:22.192 [info] == Migrated 20180110093905 in 0.0s211server # [699407.479209] server mobilizon_ctl[536]: 16:50:22.200 [info] == Running 20180110093906 Mobilizon.Repo.Migrations.CreateEventsTags.change/0 forward212server # [699407.479733] server mobilizon_ctl[536]: 16:50:22.200 [info] create table events_tags213server # [699407.481826] server mobilizon_ctl[536]: 16:50:22.202 [info] == Migrated 20180110093906 in 0.0s214server # [699407.489029] server mobilizon_ctl[536]: 16:50:22.210 [info] == Running 20180110094301 Mobilizon.Repo.Migrations.CreateParticipants.change/0 forward215server # [699407.489480] server mobilizon_ctl[536]: 16:50:22.210 [info] create table participants216server # [699407.492197] server mobilizon_ctl[536]: 16:50:22.213 [info] create index participants_event_id_index217server # [699407.493874] server mobilizon_ctl[536]: 16:50:22.215 [info] create index participants_account_id_index218server # [699407.494997] server mobilizon_ctl[536]: 16:50:22.216 [info] == Migrated 20180110094301 in 0.0s219server # [699407.502963] server mobilizon_ctl[536]: 16:50:22.224 [info] == Running 20180110094502 Mobilizon.Repo.Migrations.CreateEventRequests.change/0 forward220server # [699407.503411] server mobilizon_ctl[536]: 16:50:22.224 [info] create table event_requests221server # [699407.506240] server mobilizon_ctl[536]: 16:50:22.227 [info] create index event_requests_event_id_index222server # [699407.507351] server mobilizon_ctl[536]: 16:50:22.228 [info] create index event_requests_account_id_index223server # [699407.508813] server mobilizon_ctl[536]: 16:50:22.229 [info] == Migrated 20180110094502 in 0.0s224server # [699407.519129] server mobilizon_ctl[536]: 16:50:22.240 [info] == Running 20180110095317 Mobilizon.Repo.Migrations.CreateMembers.change/0 forward225server # [699407.519968] server mobilizon_ctl[536]: 16:50:22.240 [info] create table members226server # [699407.521975] server mobilizon_ctl[536]: 16:50:22.243 [info] create index members_group_id_index227server # [699407.526604] server mobilizon_ctl[536]: 16:50:22.247 [info] create index members_account_id_index228server # [699407.528264] server mobilizon_ctl[536]: 16:50:22.249 [info] == Migrated 20180110095317 in 0.0s229server # [699407.533558] server mobilizon_ctl[536]: 16:50:22.254 [info] == Running 20180110095515 Mobilizon.Repo.Migrations.CreateGroupRequests.change/0 forward230server # [699407.533915] server mobilizon_ctl[536]: 16:50:22.255 [info] create table group_requests231server # [699407.538891] server mobilizon_ctl[536]: 16:50:22.259 [info] create index group_requests_group_id_index232server # [699407.539913] server mobilizon_ctl[536]: 16:50:22.260 [info] create index group_requests_account_id_index233server # [699407.541167] server mobilizon_ctl[536]: 16:50:22.262 [info] == Migrated 20180110095515 in 0.0s234server # [699407.548339] server mobilizon_ctl[536]: 16:50:22.269 [info] == Running 20180110165029 Mobilizon.Repo.Migrations.Guardian.DB.change/0 forward235server # [699407.548788] server mobilizon_ctl[536]: 16:50:22.269 [info] create table guardian_tokens236server # [699407.551395] server mobilizon_ctl[536]: 16:50:22.272 [info] == Migrated 20180110165029 in 0.0s237server # [699407.560932] server mobilizon_ctl[536]: 16:50:22.282 [info] == Running 20180112100000 Mobilizon.Repo.Migrations.CreateTracks.change/0 forward238server # [699407.561238] server mobilizon_ctl[536]: 16:50:22.282 [info] create table tracks239server # [699407.565803] server mobilizon_ctl[536]: 16:50:22.286 [info] == Migrated 20180112100000 in 0.0s240server # [699407.574870] server mobilizon_ctl[536]: 16:50:22.296 [info] == Running 20180112105354 Mobilizon.Repo.Migrations.CreateSessions.change/0 forward241server # [699407.575209] server mobilizon_ctl[536]: 16:50:22.296 [info] create table sessions242server # [699407.579628] server mobilizon_ctl[536]: 16:50:22.300 [info] == Migrated 20180112105354 in 0.0s243server # [699407.589360] server mobilizon_ctl[536]: 16:50:22.310 [info] == Running 20180430071244 Mobilizon.Repo.Migrations.RemoveUri.up/0 forward244server # [699407.589499] server mobilizon_ctl[536]: 16:50:22.310 [info] alter table accounts245server # [699407.590392] server mobilizon_ctl[536]: 16:50:22.311 [info] alter table groups246server # [699407.592179] server mobilizon_ctl[536]: 16:50:22.312 [info] == Migrated 20180430071244 in 0.0s247server # [699407.598364] server mobilizon_ctl[536]: 16:50:22.319 [info] == Running 20180515091106 Mobilizon.Repo.Migrations.AddUrlFieldToEvents.up/0 forward248server # [699407.598614] server mobilizon_ctl[536]: 16:50:22.319 [info] alter table events249server # [699407.599407] server mobilizon_ctl[536]: 16:50:22.320 [info] == Migrated 20180515091106 in 0.0s250server # [699407.608935] server mobilizon_ctl[536]: 16:50:22.330 [info] == Running 20180515100237 Mobilizon.Repo.Migrations.CreateComments.change/0 forward251server # [699407.609392] server mobilizon_ctl[536]: 16:50:22.330 [info] create table comments252server # [699407.614223] server mobilizon_ctl[536]: 16:50:22.335 [info] == Migrated 20180515100237 in 0.0s253server # [699407.623114] server mobilizon_ctl[536]: 16:50:22.344 [info] == Running 20180515142835 Mobilizon.Repo.Migrations.AlterEventTimestampsToDateTimeWithTimeZone.up/0 forward254server # [699407.623268] server mobilizon_ctl[536]: 16:50:22.344 [info] alter table events255server # [699407.624424] server mobilizon_ctl[536]: 16:50:22.345 [info] == Migrated 20180515142835 in 0.0s256server # [699407.630431] server mobilizon_ctl[536]: 16:50:22.351 [info] == Running 20180515145438 Mobilizon.Repo.Migrations.AddLocalAttributeToEventsAndComments.up/0 forward257server # [699407.630637] server mobilizon_ctl[536]: 16:50:22.351 [info] alter table events258server # [699407.632763] server mobilizon_ctl[536]: 16:50:22.353 [info] alter table comments259server # [699407.633840] server mobilizon_ctl[536]: 16:50:22.354 [info] == Migrated 20180515145438 in 0.0s260server # [699407.640033] server mobilizon_ctl[536]: 16:50:22.361 [info] == Running 20180517100700 Mobilizon.Repo.Migrations.MoveFromAccountToActor.up/0 forward261server # [699407.644888] server mobilizon_ctl[536]: 16:50:22.366 [info] drop table event_requests262server # [699407.648187] server mobilizon_ctl[536]: 16:50:22.369 [info] drop table group_requests263server # [699407.650065] server mobilizon_ctl[536]: 16:50:22.371 [info] alter table events264server # [699407.651276] server mobilizon_ctl[536]: 16:50:22.372 [info] rename column account_id to actor_id on table members265server # [699407.651759] server mobilizon_ctl[536]: 16:50:22.372 [info] alter table members266server # [699407.653801] server mobilizon_ctl[536]: 16:50:22.375 [info] drop table groups267server # [699407.655112] server mobilizon_ctl[536]: 16:50:22.376 [info] rename table accounts to actors268server # [699407.655449] server mobilizon_ctl[536]: 16:50:22.376 [info] execute "CREATE TYPE public.actor_type AS ENUM ('Person', 'Application', 'Group', 'Organization', 'Service')"269server # [699407.657449] server mobilizon_ctl[536]: 16:50:22.378 [info] rename column username to name on table actors270server # [699407.658116] server mobilizon_ctl[536]: 16:50:22.379 [info] rename column description to summary on table actors271server # [699407.658775] server mobilizon_ctl[536]: 16:50:22.379 [info] rename column display_name to preferred_username on table actors272server # [699407.659637] server mobilizon_ctl[536]: 16:50:22.380 [info] alter table actors273server # [699407.662201] server mobilizon_ctl[536]: 16:50:22.383 [info] create index actors_preferred_username_domain_index274server # [699407.663166] server mobilizon_ctl[536]: 16:50:22.384 [info] rename column organizer_account_id to organizer_actor_id on table events275server # [699407.663975] server mobilizon_ctl[536]: 16:50:22.385 [info] rename column account_id to actor_id on table participants276server # [699407.664625] server mobilizon_ctl[536]: 16:50:22.385 [info] create table followers277server # [699407.667878] server mobilizon_ctl[536]: 16:50:22.389 [info] rename column account_id to actor_id on table comments278server # [699407.669067] server mobilizon_ctl[536]: 16:50:22.390 [info] rename column account_id to actor_id on table users279server # [699407.669890] server mobilizon_ctl[536]: 16:50:22.390 [info] == Migrated 20180517100700 in 0.0s280server # [699407.679962] server mobilizon_ctl[536]: 16:50:22.401 [info] == Running 20180522133844 Mobilizon.Repo.Migrations.AddBotsTable.up/0 forward281server # [699407.680501] server mobilizon_ctl[536]: 16:50:22.401 [info] create table bots282server # [699407.684715] server mobilizon_ctl[536]: 16:50:22.405 [info] == Migrated 20180522133844 in 0.0s283server # [699407.689952] server mobilizon_ctl[536]: 16:50:22.411 [info] == Running 20180530125159 Mobilizon.Repo.Migrations.AddAvatarAndBannerToActor.up/0 forward284server # [699407.690064] server mobilizon_ctl[536]: 16:50:22.411 [info] alter table actors285server # [699407.691085] server mobilizon_ctl[536]: 16:50:22.412 [info] == Migrated 20180530125159 in 0.0s286server # [699407.697703] server mobilizon_ctl[536]: 16:50:22.418 [info] == Running 20180530152323 Mobilizon.Repo.Migrations.MakeActorPublicKeyNullable.up/0 forward287server # [699407.697908] server mobilizon_ctl[536]: 16:50:22.419 [info] alter table actors288server # [699407.699407] server mobilizon_ctl[536]: 16:50:22.420 [info] == Migrated 20180530152323 in 0.0s289server # [699407.704944] server mobilizon_ctl[536]: 16:50:22.426 [info] == Running 20180530170808 Mobilizon.Repo.Migrations.AddUUIDIdToEvents.up/0 forward290server # [699407.705112] server mobilizon_ctl[536]: 16:50:22.426 [info] alter table events291server # [699407.706139] server mobilizon_ctl[536]: 16:50:22.427 [info] == Migrated 20180530170808 in 0.0s292server # [699407.714372] server mobilizon_ctl[536]: 16:50:22.435 [info] == Running 20180531162301 Mobilizon.Repo.Migrations.AddApprovedStatusToMember.up/0 forward293server # [699407.714984] server mobilizon_ctl[536]: 16:50:22.435 [info] alter table members294server # [699407.716171] server mobilizon_ctl[536]: 16:50:22.437 [info] == Migrated 20180531162301 in 0.0s295server # [699407.722370] server mobilizon_ctl[536]: 16:50:22.443 [info] == Running 20180607095732 Mobilizon.Repo.Migrations.AddUUIDToComments.up/0 forward296server # [699407.722596] server mobilizon_ctl[536]: 16:50:22.443 [info] alter table comments297server # [699407.723661] server mobilizon_ctl[536]: 16:50:22.444 [info] == Migrated 20180607095732 in 0.0s298server # [699407.730357] server mobilizon_ctl[536]: 16:50:22.451 [info] == Running 20180614094653 Mobilizon.Repo.Migrations.MakeSharedInboxUrlNullable.up/0 forward299server # [699407.730574] server mobilizon_ctl[536]: 16:50:22.451 [info] alter table actors300server # [699407.732295] server mobilizon_ctl[536]: 16:50:22.453 [info] == Migrated 20180614094653 in 0.0s301server # [699407.739776] server mobilizon_ctl[536]: 16:50:22.460 [info] == Running 20180614104618 Mobilizon.Repo.Migrations.FusionPublicPrivateKeyIntoKeysColumn.up/0 forward302server # [699407.740045] server mobilizon_ctl[536]: 16:50:22.460 [info] rename column private_key to keys on table actors303server # [699407.740617] server mobilizon_ctl[536]: 16:50:22.461 [info] alter table actors304server # [699407.741191] server mobilizon_ctl[536]: 16:50:22.462 [info] == Migrated 20180614104618 in 0.0s305server # [699407.745439] server mobilizon_ctl[536]: 16:50:22.466 [info] == Running 20180614131328 Mobilizon.Repo.Migrations.AddAttributedToFieldToEventsAndComments.up/0 forward306server # [699407.745695] server mobilizon_ctl[536]: 16:50:22.466 [info] alter table events307server # [699407.748458] server mobilizon_ctl[536]: 16:50:22.469 [info] alter table comments308server # [699407.750213] server mobilizon_ctl[536]: 16:50:22.471 [info] == Migrated 20180614131328 in 0.0s309server # [699407.756947] server mobilizon_ctl[536]: 16:50:22.478 [info] == Running 20180628091920 :"Elixir.Mobilizon.Repo.Migrations.Add-user-confirm-email-fields".up/0 forward310server # [699407.757154] server mobilizon_ctl[536]: 16:50:22.478 [info] alter table users311server # [699407.758085] server mobilizon_ctl[536]: 16:50:22.479 [info] create index index_unique_users_confirmation_token312server # [699407.759712] server mobilizon_ctl[536]: 16:50:22.480 [info] == Migrated 20180628091920 in 0.0s313server # [699407.763316] server mobilizon_ctl[536]: 16:50:22.484 [info] == Running 20180628130746 :"Elixir.Mobilizon.Repo.Migrations.Add-user-password-reset-fields".up/0 forward314server # [699407.763587] server mobilizon_ctl[536]: 16:50:22.484 [info] alter table users315server # [699407.764482] server mobilizon_ctl[536]: 16:50:22.485 [info] create index index_unique_users_reset_password_token316server # [699407.765834] server mobilizon_ctl[536]: 16:50:22.486 [info] == Migrated 20180628130746 in 0.0s317server # [699407.772261] server mobilizon_ctl[536]: 16:50:22.493 [info] == Running 20180628142835 Mobilizon.Repo.Migrations.RevertAlterEventTimestampsToDateTimeWithTimeZone.up/0 forward318server # [699407.772412] server mobilizon_ctl[536]: 16:50:22.493 [info] alter table events319server # [699407.773319] server mobilizon_ctl[536]: 16:50:22.494 [info] == Migrated 20180628142835 in 0.0s320server # [699407.778312] server mobilizon_ctl[536]: 16:50:22.499 [info] == Running 20180702150922 Mobilizon.Repo.Migrations.AddAddressType.up/0 forward321server # [699407.778543] server mobilizon_ctl[536]: 16:50:22.499 [info] alter table events322server # [699407.779410] server mobilizon_ctl[536]: 16:50:22.500 [info] drop constraint events_address_id_fkey from table events323server # [699407.780168] server mobilizon_ctl[536]: 16:50:22.501 [info] rename column address_id to physical_address_id on table events324server # [699407.780583] server mobilizon_ctl[536]: 16:50:22.501 [info] alter table events325server # [699407.782567] server mobilizon_ctl[536]: 16:50:22.503 [info] == Migrated 20180702150922 in 0.0s326server # [699407.789632] server mobilizon_ctl[536]: 16:50:22.510 [info] == Running 20180702154630 Mobilizon.Repo.Migrations.RemoveSlugForEvent.up/0 forward327server # [699407.789781] server mobilizon_ctl[536]: 16:50:22.510 [info] alter table events328server # [699407.790909] server mobilizon_ctl[536]: 16:50:22.511 [info] == Migrated 20180702154630 in 0.0s329server # [699407.795654] server mobilizon_ctl[536]: 16:50:22.516 [info] == Running 20180706082208 Mobilizon.Repo.Migrations.AlterEventsSetDescriptionAsText.up/0 forward330server # [699407.796405] server mobilizon_ctl[536]: 16:50:22.517 [info] alter table events331server # [699407.797041] server mobilizon_ctl[536]: 16:50:22.518 [info] == Migrated 20180706082208 in 0.0s332server # [699407.802157] server mobilizon_ctl[536]: 16:50:22.523 [info] == Running 20180709154152 Mobilizon.Repo.Migrations.AllowMultipleAccountsForUser.up/0 forward333server # [699407.802157] server mobilizon_ctl[536]: 16:50:22.523 [info] alter table actors334server # [699407.803969] server mobilizon_ctl[536]: 16:50:22.525 [info] alter table users335server # [699407.805020] server mobilizon_ctl[536]: 16:50:22.526 [info] == Migrated 20180709154152 in 0.0s336server # [699407.814505] server mobilizon_ctl[536]: 16:50:22.535 [info] == Running 20180802133951 Mobilizon.Repo.Migrations.MakeFollowerTableUnique.up/0 forward337server # [699407.814931] server mobilizon_ctl[536]: 16:50:22.535 [info] create index followers_actor_target_actor_unique_index338server # [699407.816359] server mobilizon_ctl[536]: 16:50:22.537 [info] == Migrated 20180802133951 in 0.0s339server # [699407.823565] server mobilizon_ctl[536]: 16:50:22.544 [info] == Running 20180816093446 Mobilizon.Repo.Migrations.AddPrimaryKeyToMember.up/0 forward340server # [699407.823866] server mobilizon_ctl[536]: 16:50:22.544 [info] execute "ALTER TABLE members DROP CONSTRAINT IF EXISTS members_pkey"341server # [699407.824626] server mobilizon_ctl[536]: 16:50:22.545 [info] constraint "members_pkey" of relation "members" does not exist, skipping342server # [699407.824626] server mobilizon_ctl[536]: 16:50:22.545 [info] drop index if exists members_members_account_id_index_index343server # [699407.825291] server mobilizon_ctl[536]: 16:50:22.546 [info] index "members_members_account_id_index_index" does not exist, skipping344server # [699407.825423] server mobilizon_ctl[536]: 16:50:22.546 [info] create index members_actor_parent_unique_index345server # [699407.827053] server mobilizon_ctl[536]: 16:50:22.548 [info] alter table members346server # [699407.832702] server mobilizon_ctl[536]: 16:50:22.553 [info] == Migrated 20180816093446 in 0.0s347server # [699407.838726] server mobilizon_ctl[536]: 16:50:22.559 [info] == Running 20181021161324 Mobilizon.Repo.Migrations.AddDefaultActorUserField.up/0 forward348server # [699407.838937] server mobilizon_ctl[536]: 16:50:22.560 [info] alter table users349server # [699407.840583] server mobilizon_ctl[536]: 16:50:22.561 [info] == Migrated 20181021161324 in 0.0s350server # [699407.849644] server mobilizon_ctl[536]: 16:50:22.570 [info] == Running 20181108165151 Mobilizon.Repo.Migrations.FixCommentsReferences.up/0 forward351server # [699407.849986] server mobilizon_ctl[536]: 16:50:22.571 [info] drop constraint comments_in_reply_to_comment_id_fkey from table comments352server # [699407.851021] server mobilizon_ctl[536]: 16:50:22.572 [info] drop constraint comments_origin_comment_id_fkey from table comments353server # [699407.852058] server mobilizon_ctl[536]: 16:50:22.573 [info] alter table comments354server # [699407.855001] server mobilizon_ctl[536]: 16:50:22.575 [info] == Migrated 20181108165151 in 0.0s355server # [699407.865430] server mobilizon_ctl[536]: 16:50:22.586 [info] == Running 20181203092128 Mobilizon.Repo.Migrations.ChangeActorsIndexes.up/0 forward356server # [699407.865813] server mobilizon_ctl[536]: 16:50:22.586 [info] drop index actors_preferred_username_domain_index357server # [699407.867143] server mobilizon_ctl[536]: 16:50:22.588 [info] drop index accounts_username_domain_index358server # [699407.868810] server mobilizon_ctl[536]: 16:50:22.589 [info] execute "ALTER INDEX accounts_pkey RENAME TO actors_pkey"359server # [699407.868810] server mobilizon_ctl[536]: 16:50:22.589 [info] create index actors_preferred_username_domain_type_index360server # [699407.869836] server mobilizon_ctl[536]: 16:50:22.590 [info] create index actors_url_index361server # [699407.871172] server mobilizon_ctl[536]: 16:50:22.592 [info] == Migrated 20181203092128 in 0.0s362server # [699407.876326] server mobilizon_ctl[536]: 16:50:22.597 [info] == Running 20190103150805 Mobilizon.Repo.Migrations.FixEventVisibility.up/0 forward363server # [699407.877189] server mobilizon_ctl[536]: 16:50:22.597 [info] execute "CREATE TYPE public.event_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')"364server # [699407.877674] server mobilizon_ctl[536]: 16:50:22.598 [info] execute "CREATE TYPE public.event_status AS ENUM ('tentative', 'confirmed', 'cancelled')"365server # [699407.877880] server mobilizon_ctl[536]: 16:50:22.599 [info] execute "CREATE TYPE public.comment_visibility AS ENUM ('public', 'unlisted', 'private', 'moderated', 'invite')"366server # [699407.878309] server mobilizon_ctl[536]: 16:50:22.599 [info] alter table events367server # [699407.879561] server mobilizon_ctl[536]: 16:50:22.600 [info] alter table comments368server # [699407.880274] server mobilizon_ctl[536]: 16:50:22.601 [info] == Migrated 20190103150805 in 0.0s369server # [699407.887961] server mobilizon_ctl[536]: 16:50:22.609 [info] == Running 20190114162055 Mobilizon.Repo.Migrations.RemoveAddressType.up/0 forward370server # [699407.888369] server mobilizon_ctl[536]: 16:50:22.609 [info] execute "ALTER TABLE \"events\" DROP COLUMN IF EXISTS address_type"371server # [699407.889683] server mobilizon_ctl[536]: 16:50:22.610 [info] column "address_type" of relation "events" does not exist, skipping372server # [699407.890033] server mobilizon_ctl[536]: 16:50:22.610 [info] execute "DROP TYPE IF EXISTS address_type"373server # [699407.890391] server mobilizon_ctl[536]: 16:50:22.611 [info] type "address_type" does not exist, skipping374server # [699407.890612] server mobilizon_ctl[536]: 16:50:22.611 [info] rename column phone to phone_address on table events375server # [699407.892074] server mobilizon_ctl[536]: 16:50:22.613 [info] == Migrated 20190114162055 in 0.0s376server # [699407.898603] server mobilizon_ctl[536]: 16:50:22.619 [info] == Running 20190125143718 Mobilizon.Repo.Migrations.GroupDeleteMembersCascade.change/0 forward377server # [699407.898923] server mobilizon_ctl[536]: 16:50:22.620 [info] drop constraint members_account_id_fkey from table members378server # [699407.900268] server mobilizon_ctl[536]: 16:50:22.621 [info] drop constraint members_parent_id_fkey from table members379server # [699407.901590] server mobilizon_ctl[536]: 16:50:22.622 [info] alter table members380server # [699407.904918] server mobilizon_ctl[536]: 16:50:22.626 [info] == Migrated 20190125143718 in 0.0s381server # [699407.911555] server mobilizon_ctl[536]: 16:50:22.632 [info] == Running 20190130151607 Mobilizon.Repo.Migrations.SplitEventVisibilityAndJoinOptions.up/0 forward382server # [699407.911924] server mobilizon_ctl[536]: 16:50:22.633 [info] execute "ALTER TABLE events ALTER COLUMN visibility TYPE VARCHAR USING visibility::text"383server # [699407.915526] server mobilizon_ctl[536]: 16:50:22.636 [info] execute "DROP TYPE public.event_visibility"384server # [699407.916155] server mobilizon_ctl[536]: 16:50:22.637 [info] execute "CREATE TYPE public.event_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')"385server # [699407.916879] server mobilizon_ctl[536]: 16:50:22.638 [info] execute "ALTER TABLE events ALTER COLUMN visibility TYPE event_visibility USING visibility::event_visibility"386server # [699407.919740] server mobilizon_ctl[536]: 16:50:22.640 [info] execute "CREATE TYPE public.join_options AS ENUM ('free', 'restricted', 'invite', 'external')"387server # [699407.920291] server mobilizon_ctl[536]: 16:50:22.641 [info] alter table events388server # [699407.921285] server mobilizon_ctl[536]: 16:50:22.642 [info] execute "UPDATE events SET visibility = 'public' WHERE visibility IS NULL"389server # [699407.922322] server mobilizon_ctl[536]: 16:50:22.643 [info] alter table events390server # [699407.924067] server mobilizon_ctl[536]: 16:50:22.645 [info] == Migrated 20190130151607 in 0.0s391server # [699407.931122] server mobilizon_ctl[536]: 16:50:22.652 [info] == Running 20190207134142 Mobilizon.Repo.Migrations.MoveParticipantRoleToEnum.up/0 forward392server # [699407.931574] server mobilizon_ctl[536]: 16:50:22.652 [info] execute "CREATE TYPE public.participant_role AS ENUM ('not_approved', 'not_confirmed', 'rejected', 'participant', 'moderator', 'administrator', 'creator')"393server # [699407.931981] server mobilizon_ctl[536]: 16:50:22.653 [info] alter table participants394server # [699407.932891] server mobilizon_ctl[536]: 16:50:22.654 [info] execute "UPDATE participants set role_tmp = 'not_approved' where role = 0"395server # [699407.933837] server mobilizon_ctl[536]: 16:50:22.654 [info] execute "UPDATE participants set role_tmp = 'participant' where role = 1"396server # [699407.934231] server mobilizon_ctl[536]: 16:50:22.655 [info] execute "UPDATE participants set role_tmp = 'moderator' where role = 2"397server # [699407.934546] server mobilizon_ctl[536]: 16:50:22.655 [info] execute "UPDATE participants set role_tmp = 'administrator' where role = 3"398server # [699407.935144] server mobilizon_ctl[536]: 16:50:22.656 [info] execute "UPDATE participants set role_tmp = 'creator' where role = 4"399server # [699407.935327] server mobilizon_ctl[536]: 16:50:22.656 [info] alter table participants400server # [699407.935936] server mobilizon_ctl[536]: 16:50:22.657 [info] rename column role_tmp to role on table participants401server # [699407.936324] server mobilizon_ctl[536]: 16:50:22.657 [info] == Migrated 20190207134142 in 0.0s402server # [699407.942224] server mobilizon_ctl[536]: 16:50:22.663 [info] == Running 20190208141700 Mobilizon.Repo.Migrations.TagsRelations.up/0 forward403server # [699407.942502] server mobilizon_ctl[536]: 16:50:22.663 [info] create table tag_relations404server # [699407.945280] server mobilizon_ctl[536]: 16:50:22.666 [info] create check constraint no_self_loops_check on table tag_relations405server # [699407.946286] server mobilizon_ctl[536]: 16:50:22.667 [info] create index index_tag_relations_tag_id406server # [699407.947115] server mobilizon_ctl[536]: 16:50:22.668 [info] create index index_tag_relations_link_id407server # [699407.948127] server mobilizon_ctl[536]: 16:50:22.669 [info] == Migrated 20190208141700 in 0.0s408server # [699407.958156] server mobilizon_ctl[536]: 16:50:22.679 [info] == Running 20190214100858 Mobilizon.Repo.Migrations.DropDatetimetz.up/0 forward409server # [699407.958491] server mobilizon_ctl[536]: 16:50:22.679 [info] alter table events410server # [699407.959927] server mobilizon_ctl[536]: 16:50:22.681 [info] alter table sessions411server # [699407.960903] server mobilizon_ctl[536]: 16:50:22.682 [info] execute "DROP TYPE datetimetz"412server # [699407.961549] server mobilizon_ctl[536]: 16:50:22.682 [info] == Migrated 20190214100858 in 0.0s413server # [699407.965035] server mobilizon_ctl[536]: #########################################################414server # [699407.965035] server mobilizon_ctl[536]: # If the CREATE EXTENSION or DROP EXTENSION calls fail, #415server # [699407.965035] server mobilizon_ctl[536]: # please manually execute them with an authorized #416server # [699407.965035] server mobilizon_ctl[536]: # PostgreSQL user with SUPER USER role. #417server # [699407.965035] server mobilizon_ctl[536]: #########################################################418server # [699407.965035] server mobilizon_ctl[536]:419server # [699407.965035] server mobilizon_ctl[536]:420server # [699407.965035] server mobilizon_ctl[536]: 16:50:22.686 [info] == Running 20190219164310 Mobilizon.Repo.Migrations.CreateSearchIndexes.change/0 forward421server # [699407.965604] server mobilizon_ctl[536]: 16:50:22.686 [info] execute "CREATE EXTENSION IF NOT EXISTS pg_trgm"422server # [699407.965717] server mobilizon_ctl[536]: 16:50:22.686 [info] extension "pg_trgm" already exists, skipping423server # [699407.965999] server mobilizon_ctl[536]: 16:50:22.686 [info] execute "CREATE EXTENSION IF NOT EXISTS unaccent"424server # [699407.965999] server mobilizon_ctl[536]: 16:50:22.687 [info] extension "unaccent" already exists, skipping425server # [699407.966122] server mobilizon_ctl[536]: 16:50:22.687 [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.966781] server mobilizon_ctl[536]: 16:50:22.688 [info] execute "CREATE INDEX \"event_title_trigram\" ON \"events\" USING GIN (f_unaccent(title) gin_trgm_ops)"427server # [699407.969182] server mobilizon_ctl[536]: 16:50:22.690 [info] execute "CREATE INDEX \"actor_preferred_username_trigram\" ON \"actors\"\n USING GIN (f_unaccent(preferred_username) gin_trgm_ops)"428server # [699407.970350] server mobilizon_ctl[536]: 16:50:22.691 [info] execute "CREATE INDEX \"actor_name_trigram\" ON \"actors\"\n USING GIN (f_unaccent(name) gin_trgm_ops)"429server # [699407.971833] server mobilizon_ctl[536]: 16:50:22.692 [info] == Migrated 20190219164310 in 0.0s430server # [699407.980154] server mobilizon_ctl[536]: 16:50:22.701 [info] == Running 20190222151449 Mobilizon.Repo.Migrations.DropCategories.up/0 forward431server # [699407.980440] server mobilizon_ctl[536]: 16:50:22.701 [info] alter table events432server # [699407.981985] server mobilizon_ctl[536]: 16:50:22.703 [info] drop table categories433server # [699407.983695] server mobilizon_ctl[536]: 16:50:22.704 [info] == Migrated 20190222151449 in 0.0s434server # [699407.988090] server mobilizon_ctl[536]: 16:50:22.709 [info] == Running 20190301141830 Mobilizon.Repo.Migrations.MoveMemberRoleToEnum.up/0 forward435server # [699407.988355] server mobilizon_ctl[536]: 16:50:22.709 [info] execute "CREATE TYPE public.member_role AS ENUM ('invited', 'not_approved', 'member', 'moderator', 'administrator', 'creator', 'rejected')"436server # [699407.988962] server mobilizon_ctl[536]: 16:50:22.710 [info] alter table members437server # [699407.989664] server mobilizon_ctl[536]: 16:50:22.710 [info] execute "UPDATE members set role_tmp = 'member' where role = 0"438server # [699407.990471] server mobilizon_ctl[536]: 16:50:22.711 [info] execute "UPDATE members set role_tmp = 'moderator' where role = 1"439server # [699407.990920] server mobilizon_ctl[536]: 16:50:22.712 [info] execute "UPDATE members set role_tmp = 'creator' where role = 2"440server # [699407.991247] server mobilizon_ctl[536]: 16:50:22.712 [info] execute "UPDATE members set role_tmp = 'not_approved' where approved is false"441server # [699407.991511] server mobilizon_ctl[536]: 16:50:22.712 [info] alter table members442server # [699407.992228] server mobilizon_ctl[536]: 16:50:22.713 [info] rename column role_tmp to role on table members443server # [699407.992609] server mobilizon_ctl[536]: 16:50:22.713 [info] == Migrated 20190301141830 in 0.0s444server # [699407.998189] server mobilizon_ctl[536]: 16:50:22.719 [info] == Running 20190301143831 Mobilizon.Repo.Migrations.ActorGroupOpenness.up/0 forward445server # [699408.001053] server mobilizon_ctl[536]: 16:50:22.722 [info] execute "CREATE TYPE public.actor_openness AS ENUM ('invite_only', 'moderated', 'open')"446server # [699408.001776] server mobilizon_ctl[536]: 16:50:22.722 [info] alter table actors447server # [699408.002883] server mobilizon_ctl[536]: 16:50:22.723 [info] == Migrated 20190301143831 in 0.0s448server # [699408.014321] server mobilizon_ctl[536]: 16:50:22.735 [info] == Running 20190307125009 Mobilizon.Repo.Migrations.MoveUserRoleToEnum.up/0 forward449server # [699408.014654] server mobilizon_ctl[536]: 16:50:22.735 [info] execute "CREATE TYPE public.user_role AS ENUM ('administrator', 'moderator', 'user', 'pending')"450server # [699408.015328] server mobilizon_ctl[536]: 16:50:22.736 [info] alter table users451server # [699408.016711] server mobilizon_ctl[536]: 16:50:22.737 [info] execute "UPDATE users set role_tmp = 'user' where role = 0"452server # [699408.017615] server mobilizon_ctl[536]: 16:50:22.738 [info] execute "UPDATE users set role_tmp = 'moderator' where role = 1"453server # [699408.017936] server mobilizon_ctl[536]: 16:50:22.739 [info] execute "UPDATE users set role_tmp = 'administrator' where role = 2"454server # [699408.018360] server mobilizon_ctl[536]: 16:50:22.739 [info] alter table users455server # [699408.019852] server mobilizon_ctl[536]: 16:50:22.741 [info] rename column role_tmp to role on table users456server # [699408.020500] server mobilizon_ctl[536]: 16:50:22.741 [info] == Migrated 20190307125009 in 0.0s457server # [699408.028383] server mobilizon_ctl[536]: 16:50:22.749 [info] == Running 20190307133518 Mobilizon.Repo.Migrations.FeedTokenTable.change/0 forward458server # [699408.033196] server mobilizon_ctl[536]: 16:50:22.754 [info] create table feed_tokens459server # [699408.037468] server mobilizon_ctl[536]: 16:50:22.758 [info] == Migrated 20190307133518 in 0.0s460server # [699408.042858] server mobilizon_ctl[536]: 16:50:22.764 [info] == Running 20190322143724 Mobilizon.Repo.Migrations.RenameAddressFields.change/0 forward461server # [699408.043049] server mobilizon_ctl[536]: 16:50:22.764 [info] rename column addressCountry to country on table addresses462server # [699408.043642] server mobilizon_ctl[536]: 16:50:22.764 [info] rename column addressLocality to locality on table addresses463server # [699408.044218] server mobilizon_ctl[536]: 16:50:22.765 [info] rename column addressRegion to region on table addresses464server # [699408.044569] server mobilizon_ctl[536]: 16:50:22.765 [info] rename column postalCode to postal_code on table addresses465server # [699408.044880] server mobilizon_ctl[536]: 16:50:22.766 [info] rename column streetAddress to street on table addresses466server # [699408.045330] server mobilizon_ctl[536]: 16:50:22.766 [info] == Migrated 20190322143724 in 0.0s467server # [699408.052029] server mobilizon_ctl[536]: 16:50:22.773 [info] == Running 20190411124138 Mobilizon.Repo.Migrations.EventAddDescriptionSlug.change/0 forward468server # [699408.052286] server mobilizon_ctl[536]: 16:50:22.773 [info] alter table events469server # [699408.053663] server mobilizon_ctl[536]: 16:50:22.774 [info] == Migrated 20190411124138 in 0.0s470server # [699408.060444] server mobilizon_ctl[536]: 16:50:22.781 [info] == Running 20190411161557 Mobilizon.Repo.Migrations.EventEventTagOnDelete.up/0 forward471server # [699408.060785] server mobilizon_ctl[536]: 16:50:22.781 [info] drop constraint events_tags_event_id_fkey from table events_tags472server # [699408.061676] server mobilizon_ctl[536]: 16:50:22.782 [info] drop constraint events_tags_tag_id_fkey from table events_tags473server # [699408.062634] server mobilizon_ctl[536]: 16:50:22.783 [info] alter table events_tags474server # [699408.064741] server mobilizon_ctl[536]: 16:50:22.785 [info] == Migrated 20190411161557 in 0.0s475server # [699408.071244] server mobilizon_ctl[536]: 16:50:22.792 [info] == Running 20190425075451 Mobilizon.Repo.Migrations.AddVisibilityToActor.up/0 forward476server # [699408.071607] server mobilizon_ctl[536]: 16:50:22.792 [info] execute "CREATE TYPE public.actor_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')"477server # [699408.072241] server mobilizon_ctl[536]: 16:50:22.793 [info] alter table actors478server # [699408.073431] server mobilizon_ctl[536]: 16:50:22.794 [info] == Migrated 20190425075451 in 0.0s479server # [699408.079731] server mobilizon_ctl[536]: 16:50:22.800 [info] == Running 20190426093202 Mobilizon.Repo.Migrations.CreatePictures.up/0 forward480server # [699408.079942] server mobilizon_ctl[536]: 16:50:22.801 [info] create table pictures481server # [699408.083864] server mobilizon_ctl[536]: 16:50:22.804 [info] alter table actors482server # [699408.084697] server mobilizon_ctl[536]: 16:50:22.805 [info] alter table events483server # [699408.087209] server mobilizon_ctl[536]: 16:50:22.808 [info] == Migrated 20190426093202 in 0.0s484server # [699408.094675] server mobilizon_ctl[536]: 16:50:22.815 [info] == Running 20190531131458 :"Elixir.Mobilizon.Repo.Migrations.Attach-pictures-to-actors".change/0 forward485server # [699408.094837] server mobilizon_ctl[536]: 16:50:22.815 [info] alter table pictures486server # [699408.097411] server mobilizon_ctl[536]: 16:50:22.818 [info] == Migrated 20190531131458 in 0.0s487server # [699408.105798] server mobilizon_ctl[536]: 16:50:22.826 [info] == Running 20190712125833 Mobilizon.Repo.Migrations.CreateReports.up/0 forward488server # [699408.111953] server mobilizon_ctl[536]: 16:50:22.832 [info] execute "CREATE TYPE public.report_status AS ENUM ('open', 'closed', 'resolved')"489server # [699408.113537] server mobilizon_ctl[536]: 16:50:22.834 [info] create table reports490server # [699408.119633] server mobilizon_ctl[536]: 16:50:22.840 [info] create table reports_comments491server # [699408.121400] server mobilizon_ctl[536]: 16:50:22.842 [info] == Migrated 20190712125833 in 0.0s492server # [699408.128541] server mobilizon_ctl[536]: 16:50:22.849 [info] == Running 20190712132438 Mobilizon.Repo.Migrations.CreateReportNotes.change/0 forward493server # [699408.128885] server mobilizon_ctl[536]: 16:50:22.850 [info] create table report_notes494server # [699408.132407] server mobilizon_ctl[536]: 16:50:22.853 [info] == Migrated 20190712132438 in 0.0s495server # [699408.137044] server mobilizon_ctl[536]: 16:50:22.858 [info] == Running 20190718122556 Mobilizon.Repo.Migrations.CreateAdminActionLogs.change/0 forward496server # [699408.137380] server mobilizon_ctl[536]: 16:50:22.858 [info] create table admin_action_logs497server # [699408.141012] server mobilizon_ctl[536]: 16:50:22.862 [info] == Migrated 20190718122556 in 0.0s498server # [699408.153652] server mobilizon_ctl[536]: 16:50:22.874 [info] == Running 20190729125532 :"Elixir.Mobilizon.Repo.Migrations.Add-url-to-addresses".change/0 forward499server # [699408.153988] server mobilizon_ctl[536]: 16:50:22.874 [info] alter table addresses500server # [699408.154892] server mobilizon_ctl[536]: 16:50:22.875 [info] == Migrated 20190729125532 in 0.0s501server # [699408.161739] server mobilizon_ctl[536]: 16:50:22.882 [info] == Running 20190806131306 Mobilizon.Repo.Migrations.AddUrlToFollowsAndMoveToUuid.up/0 forward502server # [699408.161896] server mobilizon_ctl[536]: 16:50:22.883 [info] alter table followers503server # [699408.165271] server mobilizon_ctl[536]: 16:50:22.886 [info] == Migrated 20190806131306 in 0.0s504server # [699408.171401] server mobilizon_ctl[536]: 16:50:22.892 [info] == Running 20190813160207 Mobilizon.Repo.Migrations.AddUrlAndUuidToParticipants.up/0 forward505server # [699408.171809] server mobilizon_ctl[536]: 16:50:22.893 [info] drop index participants_event_id_index506server # [699408.172455] server mobilizon_ctl[536]: 16:50:22.893 [info] drop index if exists participants_account_id_index507server # [699408.172864] server mobilizon_ctl[536]: 16:50:22.894 [info] drop index if exists participants_actor_id_index508server # [699408.173108] server mobilizon_ctl[536]: 16:50:22.894 [info] index "participants_actor_id_index" does not exist, skipping509server # [699408.173203] server mobilizon_ctl[536]: 16:50:22.894 [info] drop constraint participants_event_id_fkey from table participants510server # [699408.173807] server mobilizon_ctl[536]: 16:50:22.895 [info] drop constraint if exists participants_account_id_fkey from table participants511server # [699408.174345] server mobilizon_ctl[536]: 16:50:22.895 [info] drop constraint if exists participants_actor_id_fkey from table participants512server # [699408.174613] server mobilizon_ctl[536]: 16:50:22.895 [info] constraint "participants_actor_id_fkey" of relation "participants" does not exist, skipping513server # [699408.174669] server mobilizon_ctl[536]: 16:50:22.895 [info] drop constraint participants_pkey from table participants514server # [699408.175085] server mobilizon_ctl[536]: 16:50:22.896 [info] alter table participants515server # [699408.178078] server mobilizon_ctl[536]: 16:50:22.899 [info] create index participants_event_id_index516server # [699408.179387] server mobilizon_ctl[536]: 16:50:22.900 [info] create index participants_actor_id_index517server # [699408.180499] server mobilizon_ctl[536]: 16:50:22.901 [info] == Migrated 20190813160207 in 0.0s518server # [699408.190322] server mobilizon_ctl[536]: 16:50:22.911 [info] == Running 20190821161658 Mobilizon.Repo.Migrations.AddOriginIdToAddresses.change/0 forward519server # [699408.190538] server mobilizon_ctl[536]: 16:50:22.911 [info] alter table addresses520server # [699408.191414] server mobilizon_ctl[536]: 16:50:22.912 [info] create index addresses_origin_id_index521server # [699408.192972] server mobilizon_ctl[536]: 16:50:22.914 [info] == Migrated 20190821161658 in 0.0s522server # [699408.201235] server mobilizon_ctl[536]: 16:50:22.922 [info] == Running 20190823132816 Mobilizon.Repo.Migrations.RemoveEventsWhenDeletingOrganizer.up/0 forward523server # [699408.201496] server mobilizon_ctl[536]: 16:50:22.922 [info] drop constraint events_organizer_account_id_fkey from table events524server # [699408.202801] server mobilizon_ctl[536]: 16:50:22.923 [info] alter table events525server # [699408.206109] server mobilizon_ctl[536]: 16:50:22.927 [info] == Migrated 20190823132816 in 0.0s526server # [699408.214395] server mobilizon_ctl[536]: 16:50:22.935 [info] == Running 20190902082656 Mobilizon.Repo.Migrations.AddOptionsToEvent.change/0 forward527server # [699408.214596] server mobilizon_ctl[536]: 16:50:22.935 [info] alter table events528server # [699408.215494] server mobilizon_ctl[536]: 16:50:22.936 [info] == Migrated 20190902082656 in 0.0s529server # [699408.221428] server mobilizon_ctl[536]: 16:50:22.942 [info] == Running 20190929170817 Mobilizon.Storage.Repo.Migrations.RenamePostgresTypes.up/0 forward530server # [699408.225971] server mobilizon_ctl[536]: 16:50:22.947 [info] == Migrated 20190929170817 in 0.0s531server # [699408.231669] server mobilizon_ctl[536]: 16:50:22.952 [info] == Running 20190929175229 Mobilizon.Storage.Repo.Migrations.AddRejectedToParticipantRole.up/0 forward532server # [699408.231834] server mobilizon_ctl[536]: 16:50:22.952 [info] execute "ALTER TYPE public.participant_role ADD VALUE IF NOT EXISTS 'rejected'"533server # [699408.232500] server mobilizon_ctl[536]: 16:50:22.953 [info] enum label "rejected" already exists, skipping534server # [699408.232684] server mobilizon_ctl[536]: 16:50:22.953 [info] == Migrated 20190929175229 in 0.0s535server # [699408.237792] server mobilizon_ctl[536]: 16:50:22.958 [info] == Running 20191001074442 Mobilizon.Storage.Repo.Migrations.AddLocaleToUsers.change/0 forward536server # [699408.237916] server mobilizon_ctl[536]: 16:50:22.959 [info] alter table users537server # [699408.238983] server mobilizon_ctl[536]: 16:50:22.960 [info] == Migrated 20191001074442 in 0.0s538server # [699408.243249] server mobilizon_ctl[536]: 16:50:22.964 [info] == Running 20191002093208 Mobilizon.Storage.Repo.Migrations.AddDraftFlagToEvents.change/0 forward539server # [699408.243249] server mobilizon_ctl[536]: 16:50:22.964 [info] alter table events540server # [699408.244320] server mobilizon_ctl[536]: 16:50:22.965 [info] == Migrated 20191002093208 in 0.0s541server # [699408.251587] server mobilizon_ctl[536]: 16:50:22.972 [info] == Running 20191018075904 Mobilizon.Storage.Repo.Migrations.MoveSQLColumnsFromVarCharToText.up/0 forward542server # [699408.252220] server mobilizon_ctl[536]: 16:50:22.973 [info] alter table events543server # [699408.256387] server mobilizon_ctl[536]: 16:50:22.977 [info] alter table addresses544server # [699408.257077] server mobilizon_ctl[536]: 16:50:22.978 [info] alter table bots545server # [699408.257838] server mobilizon_ctl[536]: 16:50:22.979 [info] alter table report_notes546server # [699408.259706] server mobilizon_ctl[536]: 16:50:22.980 [info] alter table reports547server # [699408.260511] server mobilizon_ctl[536]: 16:50:22.981 [info] alter table sessions548server # [699408.261340] server mobilizon_ctl[536]: 16:50:22.982 [info] alter table tracks549server # [699408.262382] server mobilizon_ctl[536]: 16:50:22.983 [info] == Migrated 20191018075904 in 0.0s550server # [699408.272090] server mobilizon_ctl[536]: 16:50:22.993 [info] == Running 20191022083446 Mobilizon.Storage.Repo.Migrations.AddEagerMaterializedViewForSearchingEvents.up/0 forward551server # [699408.272558] server mobilizon_ctl[536]: 16:50:22.993 [info] create table event_search552server # [699408.275037] server mobilizon_ctl[536]: 16:50:22.996 [info] create index event_search_document_index553server # [699408.275867] server mobilizon_ctl[536]: 16:50:22.997 [info] execute "CREATE INDEX event_search_title_trgm_index ON event_search USING gin (title gin_trgm_ops)"554server # [699408.276672] server mobilizon_ctl[536]: 16:50:22.997 [info] create index event_search_id_index555server # [699408.277722] server mobilizon_ctl[536]: 16:50:22.998 [info] == Migrated 20191022083446 in 0.0s556server # [699408.282902] server mobilizon_ctl[536]: 16:50:23.004 [info] == Running 20191023133805 Mobilizon.Storage.Repo.Migrations.DeleteActorsCascadeToFollowers.up/0 forward557server # [699408.283164] server mobilizon_ctl[536]: 16:50:23.004 [info] drop constraint followers_actor_id_fkey from table followers558server # [699408.284360] server mobilizon_ctl[536]: 16:50:23.005 [info] drop constraint followers_target_actor_id_fkey from table followers559server # [699408.285752] server mobilizon_ctl[536]: 16:50:23.006 [info] alter table followers560server # [699408.288962] server mobilizon_ctl[536]: 16:50:23.010 [info] == Migrated 20191023133805 in 0.0s561server # [699408.297386] server mobilizon_ctl[536]: 16:50:23.018 [info] == Running 20191023143659 Mobilizon.Storage.Repo.Migrations.MoveParticipantsStatsToEvent.up/0 forward562server # [699408.297561] server mobilizon_ctl[536]: 16:50:23.018 [info] alter table events563server # [699408.298362] server mobilizon_ctl[536]: 16:50:23.019 [info] == Migrated 20191023143659 in 0.0s564server # [699408.302383] server mobilizon_ctl[536]: 16:50:23.023 [info] == Running 20191024204726 Mobilizon.Storage.Repo.Migrations.AddTagsToComments.up/0 forward565server # [699408.302730] server mobilizon_ctl[536]: 16:50:23.023 [info] create table comments_tags566server # [699408.306045] server mobilizon_ctl[536]: 16:50:23.027 [info] == Migrated 20191024204726 in 0.0s567server # [699408.315699] server mobilizon_ctl[536]: 16:50:23.036 [info] == Running 20191025083642 Mobilizon.Storage.Repo.Migrations.AddMentionTables.change/0 forward568server # [699408.315875] server mobilizon_ctl[536]: 16:50:23.036 [info] create table mentions569server # [699408.319841] server mobilizon_ctl[536]: 16:50:23.040 [info] create index mentions_actor_id_index570server # [699408.321433] server mobilizon_ctl[536]: 16:50:23.042 [info] == Migrated 20191025083642 in 0.0s571server # [699408.329273] server mobilizon_ctl[536]: 16:50:23.050 [info] == Running 20191025115537 Mobilizon.Storage.Repo.Migrations.AddUniqueIndexOnURLs.change/0 forward572server # [699408.329629] server mobilizon_ctl[536]: 16:50:23.050 [info] create index events_url_index573server # [699408.330797] server mobilizon_ctl[536]: 16:50:23.052 [info] create index comments_url_index574server # [699408.331820] server mobilizon_ctl[536]: 16:50:23.052 [info] == Migrated 20191025115537 in 0.0s575server # [699408.338617] server mobilizon_ctl[536]: 16:50:23.059 [info] == Running 20191031142145 Mobilizon.Storage.Repo.Migrations.AddUniqueIndexOnActorAndEventForParticipant.change/0 forward576server # [699408.339177] server mobilizon_ctl[536]: 16:50:23.059 [info] create index participants_event_id_actor_id_index577server # [699408.340995] server mobilizon_ctl[536]: 16:50:23.061 [info] == Migrated 20191031142145 in 0.0s578server # [699408.346983] server mobilizon_ctl[536]: 16:50:23.067 [info] == Running 20191104093447 Mobilizon.Storage.Repo.Migrations.AddObanJobsTable.up/0 forward579server # [699408.381771] server mobilizon_ctl[536]: 16:50:23.102 [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.383499] server mobilizon_ctl[536]: 16:50:23.104 [info] create table if not exists public.oban_jobs581server # [699408.387545] server mobilizon_ctl[536]: 16:50:23.108 [info] create index if not exists public.oban_jobs_queue_index582server # [699408.388813] server mobilizon_ctl[536]: 16:50:23.109 [info] create index if not exists public.oban_jobs_state_index583server # [699408.389789] server mobilizon_ctl[536]: 16:50:23.110 [info] create index if not exists public.oban_jobs_scheduled_at_index584server # [699408.390559] server mobilizon_ctl[536]: 16:50:23.111 [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.391388] server mobilizon_ctl[536]: 16:50:23.112 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs"586server # [699408.391883] server mobilizon_ctl[536]: 16:50:23.113 [info] trigger "oban_notify" for relation "public.oban_jobs" does not exist, skipping587server # [699408.391883] server mobilizon_ctl[536]: 16:50:23.113 [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.392681] server mobilizon_ctl[536]: 16:50:23.113 [info] drop index if exists public.oban_jobs_scheduled_at_index589server # [699408.393145] server mobilizon_ctl[536]: 16:50:23.114 [info] create index public.oban_jobs_scheduled_at_index590server # [699408.394424] server mobilizon_ctl[536]: 16:50:23.115 [info] create check constraint worker_length on table public.oban_jobs591server # [699408.395353] server mobilizon_ctl[536]: 16:50:23.116 [info] create check constraint queue_length on table public.oban_jobs592server # [699408.396295] server mobilizon_ctl[536]: 16:50:23.117 [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.397450] server mobilizon_ctl[536]: 16:50:23.118 [info] alter table public.oban_jobs594server # [699408.398012] server mobilizon_ctl[536]: 16:50:23.119 [info] execute "DROP FUNCTION IF EXISTS \"public\".oban_wrap_id(value bigint)"595server # [699408.398653] server mobilizon_ctl[536]: 16:50:23.119 [info] drop index if exists public.oban_jobs_scheduled_at_index596server # [699408.398918] server mobilizon_ctl[536]: 16:50:23.120 [info] drop index if exists public.oban_jobs_queue_index597server # [699408.399470] server mobilizon_ctl[536]: 16:50:23.120 [info] drop index if exists public.oban_jobs_state_index598server # [699408.399758] server mobilizon_ctl[536]: 16:50:23.121 [info] create index if not exists public.oban_jobs_queue_state_scheduled_at_id_index599server # [699408.401142] server mobilizon_ctl[536]: 16:50:23.122 [info] create index if not exists public.oban_jobs_attempted_at_id_index600server # [699408.402265] server mobilizon_ctl[536]: 16:50:23.123 [info] alter table public.oban_jobs601server # [699408.402730] server mobilizon_ctl[536]: 16:50:23.123 [info] alter table public.oban_jobs602server # [699408.403380] server mobilizon_ctl[536]: 16:50:23.124 [info] drop index if exists public.oban_jobs_queue_state_scheduled_at_id_index603server # [699408.404022] server mobilizon_ctl[536]: 16:50:23.125 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index604server # [699408.405335] server mobilizon_ctl[536]: 16:50:23.126 [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.405994] server mobilizon_ctl[536]: 16:50:23.127 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs"606server # [699408.407319] server mobilizon_ctl[536]: 16:50:23.128 [info] execute "CREATE TRIGGER oban_notify\nAFTER INSERT ON \"public\".oban_jobs\nFOR EACH ROW EXECUTE PROCEDURE \"public\".oban_jobs_notify();\n"607server # [699408.407832] server mobilizon_ctl[536]: 16:50:23.129 [info] alter table public.oban_jobs608server # [699408.415475] server mobilizon_ctl[536]: 16:50:23.136 [info] execute "ALTER TYPE \"public\".oban_job_state ADD VALUE IF NOT EXISTS 'cancelled'"609server # [699408.415749] server mobilizon_ctl[536]: 16:50:23.136 [info] enum label "cancelled" already exists, skipping610server # [699408.415816] server mobilizon_ctl[536]: 16:50:23.137 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index611server # [699408.416697] server mobilizon_ctl[536]: 16:50:23.137 [info] relation "oban_jobs_state_queue_priority_scheduled_at_id_index" already exists, skipping612server # [699408.416811] server mobilizon_ctl[536]: 16:50:23.137 [info] alter table public.oban_jobs613server # [699408.418696] server mobilizon_ctl[536]: 16:50:23.139 [info] create check constraint priority_range on table public.oban_jobs614server # [699408.419615] server mobilizon_ctl[536]: 16:50:23.140 [info] create check constraint positive_max_attempts on table public.oban_jobs615server # [699408.421217] server mobilizon_ctl[536]: 16:50:23.142 [info] create check constraint attempt_range on table public.oban_jobs616server # [699408.422041] server mobilizon_ctl[536]: 16:50:23.143 [info] drop index if exists public.oban_jobs_args_vector617server # [699408.422528] server mobilizon_ctl[536]: 16:50:23.143 [info] index "oban_jobs_args_vector" does not exist, skipping618server # [699408.422631] server mobilizon_ctl[536]: 16:50:23.143 [info] drop index if exists public.oban_jobs_worker_gist619server # [699408.422842] server mobilizon_ctl[536]: 16:50:23.144 [info] index "oban_jobs_worker_gist" does not exist, skipping620server # [699408.423024] server mobilizon_ctl[536]: 16:50:23.144 [info] drop index if exists public.oban_jobs_attempted_at_id_index621server # [699408.423463] server mobilizon_ctl[536]: 16:50:23.144 [info] create index if not exists public.oban_jobs_args_index622server # [699408.424679] server mobilizon_ctl[536]: 16:50:23.145 [info] create index if not exists public.oban_jobs_meta_index623server # [699408.425814] server mobilizon_ctl[536]: 16:50:23.147 [info] create table if not exists public.oban_peers624server # [699408.428361] server mobilizon_ctl[536]: 16:50:23.149 [info] execute "ALTER TABLE \"public\".oban_peers SET UNLOGGED"625server # [699408.430755] server mobilizon_ctl[536]: 16:50:23.151 [info] drop constraint priority_range from table public.oban_jobs626server # [699408.431949] server mobilizon_ctl[536]: 16:50:23.152 [info] create check constraint non_negative_priority on table public.oban_jobs627server # [699408.432964] server mobilizon_ctl[536]: 16:50:23.154 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs"628server # [699408.433709] server mobilizon_ctl[536]: 16:50:23.154 [info] execute "DROP FUNCTION IF EXISTS \"public\".oban_jobs_notify()"629server # [699408.434348] server mobilizon_ctl[536]: 16:50:23.155 [info] create index if not exists public.oban_jobs_state_cancelled_at_index630server # [699408.435369] server mobilizon_ctl[536]: 16:50:23.156 [info] create index if not exists public.oban_jobs_state_discarded_at_index631server # [699408.436394] server mobilizon_ctl[536]: 16:50:23.157 [info] execute "ALTER TYPE \"public\".oban_job_state ADD VALUE IF NOT EXISTS 'suspended' BEFORE 'scheduled'\n"632server # [699408.436910] server mobilizon_ctl[536]: 16:50:23.158 [info] enum label "suspended" already exists, skipping633server # [699408.436910] server mobilizon_ctl[536]: 16:50:23.158 [info] execute "COMMENT ON TABLE \"public\".oban_jobs IS '14'"634server # [699408.437599] server mobilizon_ctl[536]: 16:50:23.158 [info] == Migrated 20191104093447 in 0.0s635server # [699408.448161] server mobilizon_ctl[536]: 16:50:23.169 [info] == Running 20191106114524 Mobilizon.Storage.Repo.Migrations.RemoveFloorFromAddresses.up/0 forward636server # [699408.448307] server mobilizon_ctl[536]: 16:50:23.169 [info] alter table addresses637server # [699408.449416] server mobilizon_ctl[536]: 16:50:23.170 [info] == Migrated 20191106114524 in 0.0s638server # [699408.453465] server mobilizon_ctl[536]: 16:50:23.174 [info] == Running 20191106141051 Mobilizon.Storage.Repo.Migrations.AddTypeToAddresses.change/0 forward639server # [699408.453638] server mobilizon_ctl[536]: 16:50:23.174 [info] alter table addresses640server # [699408.454887] server mobilizon_ctl[536]: 16:50:23.175 [info] == Migrated 20191106141051 in 0.0s641server # [699408.466173] server mobilizon_ctl[536]: 16:50:23.187 [info] == Running 20191114155534 Mobilizon.Storage.Repo.Migrations.CascadeCommentDeletion.up/0 forward642server # [699408.466433] server mobilizon_ctl[536]: 16:50:23.187 [info] drop constraint comments_in_reply_to_comment_id_fkey from table comments643server # [699408.467612] server mobilizon_ctl[536]: 16:50:23.188 [info] drop constraint comments_origin_comment_id_fkey from table comments644server # [699408.468764] server mobilizon_ctl[536]: 16:50:23.189 [info] alter table comments645server # [699408.471726] server mobilizon_ctl[536]: 16:50:23.192 [info] == Migrated 20191114155534 in 0.0s646server # [699408.477618] server mobilizon_ctl[536]: 16:50:23.198 [info] == Running 20191122154018 Mobilizon.Storage.Repo.Migrations.AddDeletedAtOnComments.up/0 forward647server # [699408.477744] server mobilizon_ctl[536]: 16:50:23.199 [info] drop constraint if exists comments_actor_id_fkey from table comments648server # [699408.478493] server mobilizon_ctl[536]: 16:50:23.199 [info] constraint "comments_actor_id_fkey" of relation "comments" does not exist, skipping649server # [699408.478493] server mobilizon_ctl[536]: 16:50:23.199 [info] alter table comments650server # [699408.482407] server mobilizon_ctl[536]: 16:50:23.203 [info] == Migrated 20191122154018 in 0.0s651server # [699408.486564] server mobilizon_ctl[536]: 16:50:23.207 [info] == Running 20191126173510 Mobilizon.Storage.Repo.Migrations.AddLocalFieldToReports.up/0 forward652server # [699408.486785] server mobilizon_ctl[536]: 16:50:23.207 [info] alter table reports653server # [699408.487615] server mobilizon_ctl[536]: 16:50:23.208 [info] rename column uri to url on table reports654server # [699408.488509] server mobilizon_ctl[536]: 16:50:23.209 [info] == Migrated 20191126173510 in 0.0s655server # [699408.496288] server mobilizon_ctl[536]: 16:50:23.217 [info] == Running 20191127163737 Mobilizon.Repo.Migrations.CreateTombstones.change/0 forward656server # [699408.496556] server mobilizon_ctl[536]: 16:50:23.217 [info] create table tombstones657server # [699408.499216] server mobilizon_ctl[536]: 16:50:23.220 [info] create index tombstones_uri_index658server # [699408.500984] server mobilizon_ctl[536]: 16:50:23.221 [info] == Migrated 20191127163737 in 0.0s659server # [699408.505102] server mobilizon_ctl[536]: 16:50:23.226 [info] == Running 20191129091227 Mobilizon.Storage.Repo.Migrations.AddTimestampsToFollowers.change/0 forward660server # [699408.505307] server mobilizon_ctl[536]: 16:50:23.226 [info] alter table followers661server # [699408.506116] server mobilizon_ctl[536]: 16:50:23.227 [info] == Migrated 20191129091227 in 0.0s662server # [699408.513288] server mobilizon_ctl[536]: 16:50:23.234 [info] == Running 20191204164224 Mobilizon.Storage.Repo.Migrations.DeleteEventCascadeToComments.up/0 forward663server # [699408.513446] server mobilizon_ctl[536]: 16:50:23.234 [info] drop constraint if exists comments_event_id_fkey from table comments664server # [699408.515020] server mobilizon_ctl[536]: 16:50:23.236 [info] alter table comments665server # [699408.517062] server mobilizon_ctl[536]: 16:50:23.238 [info] == Migrated 20191204164224 in 0.0s666server # [699408.522325] server mobilizon_ctl[536]: 16:50:23.243 [info] == Running 20191206144028 Mobilizon.Repo.Migrations.CreateShares.up/0 forward667server # [699408.522649] server mobilizon_ctl[536]: 16:50:23.243 [info] create table shares668server # [699408.525548] server mobilizon_ctl[536]: 16:50:23.246 [info] create index if not exists shares_uri_actor_id_index669server # [699408.526771] server mobilizon_ctl[536]: 16:50:23.247 [info] == Migrated 20191206144028 in 0.0s670server # [699408.534572] server mobilizon_ctl[536]: 16:50:23.255 [info] == Running 20191219172017 Mobilizon.Storage.Repo.Migrations.AddMetadataToParticipant.up/0 forward671server # [699408.534716] server mobilizon_ctl[536]: 16:50:23.255 [info] drop index if exists participants_event_id_actor_id_index672server # [699408.535306] server mobilizon_ctl[536]: 16:50:23.256 [info] alter table participants673server # [699408.536705] server mobilizon_ctl[536]: 16:50:23.257 [info] execute "CREATE UNIQUE INDEX participants_metadata_confirmation_token_index ON participants((metadata->>'confirmation_token'))"674server # [699408.538270] server mobilizon_ctl[536]: 16:50:23.259 [info] == Migrated 20191219172017 in 0.0s675server # [699408.542099] server mobilizon_ctl[536]: 16:50:23.263 [info] == Running 20191223173537 Mobilizon.Storage.Repo.Migrations.AddNotConfirmedStatusToParticipants.up/0 forward676server # [699408.542236] server mobilizon_ctl[536]: 16:50:23.263 [info] execute "ALTER TYPE participant_role ADD VALUE IF NOT EXISTS 'not_confirmed'"677server # [699408.542807] server mobilizon_ctl[536]: 16:50:23.264 [info] enum label "not_confirmed" already exists, skipping678server # [699408.543027] server mobilizon_ctl[536]: 16:50:23.264 [info] == Migrated 20191223173537 in 0.0s679server # [699408.549125] server mobilizon_ctl[536]: 16:50:23.270 [info] == Running 20200116095117 Mobilizon.Repo.Migrations.CreateAdminSettings.change/0 forward680server # [699408.549504] server mobilizon_ctl[536]: 16:50:23.270 [info] create table admin_settings681server # [699408.553414] server mobilizon_ctl[536]: 16:50:23.274 [info] create index admin_settings_group_name_index682server # [699408.554433] server mobilizon_ctl[536]: 16:50:23.275 [info] == Migrated 20200116095117 in 0.0s683server # [699408.566935] server mobilizon_ctl[536]: 16:50:23.288 [info] == Running 20200210100910 Mobilizon.Storage.Repo.Migrations.AddUnconfirmedEmailToUsersTable.change/0 forward684server # [699408.566935] server mobilizon_ctl[536]: 16:50:23.288 [info] alter table users685server # [699408.568346] server mobilizon_ctl[536]: 16:50:23.289 [info] == Migrated 20200210100910 in 0.0s686server # [699408.574765] server mobilizon_ctl[536]: 16:50:23.295 [info] == Running 20200213154309 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV8.up/0 forward687server # [699408.577095] server mobilizon_ctl[536]: 16:50:23.298 [info] == Migrated 20200213154309 in 0.0s688server # [699408.584852] server mobilizon_ctl[536]: 16:50:23.306 [info] == Running 20200214135231 Mobilizon.Storage.Repo.Migrations.AddLastRefreshedAtToActors.change/0 forward689server # [699408.585016] server mobilizon_ctl[536]: 16:50:23.306 [info] alter table actors690server # [699408.586195] server mobilizon_ctl[536]: 16:50:23.307 [info] == Migrated 20200214135231 in 0.0s691server # [699408.591936] server mobilizon_ctl[536]: 16:50:23.313 [info] == Running 20200218085757 Mobilizon.Storage.Repo.Migrations.AddNewRolesToMember.up/0 forward692server # [699408.592084] server mobilizon_ctl[536]: 16:50:23.313 [info] execute "ALTER TYPE member_role ADD VALUE IF NOT EXISTS 'invited'"693server # [699408.592796] server mobilizon_ctl[536]: 16:50:23.313 [info] enum label "invited" already exists, skipping694server # [699408.592796] server mobilizon_ctl[536]: 16:50:23.314 [info] execute "ALTER TYPE member_role ADD VALUE IF NOT EXISTS 'rejected'"695server # [699408.593282] server mobilizon_ctl[536]: 16:50:23.314 [info] enum label "rejected" already exists, skipping696server # [699408.593465] server mobilizon_ctl[536]: 16:50:23.314 [info] == Migrated 20200218085757 in 0.0s697server # [699408.600552] server mobilizon_ctl[536]: 16:50:23.321 [info] == Running 20200218170232 Mobilizon.Storage.Repo.Migrations.MoveMemberIdToUuid.up/0 forward698server # [699408.601610] server mobilizon_ctl[536]: 16:50:23.321 [info] alter table members699server # [699408.603998] server mobilizon_ctl[536]: 16:50:23.325 [info] == Migrated 20200218170232 in 0.0s700server # [699408.611963] server mobilizon_ctl[536]: 16:50:23.332 [info] == Running 20200219152611 Mobilizon.Storage.Repo.Migrations.AddMembersEndpointToActors.up/0 forward701server # [699408.612177] server mobilizon_ctl[536]: 16:50:23.333 [info] alter table actors702server # [699408.612945] server mobilizon_ctl[536]: 16:50:23.334 [info] == Migrated 20200219152611 in 0.0s703server # [699408.618824] server mobilizon_ctl[536]: 16:50:23.340 [info] == Running 20200221095721 Mobilizon.Repo.Migrations.CreateTodos.change/0 forward704server # [699408.619296] server mobilizon_ctl[536]: 16:50:23.340 [info] create table todo_lists705server # [699408.622369] server mobilizon_ctl[536]: 16:50:23.343 [info] create table todos706server # [699408.625412] server mobilizon_ctl[536]: 16:50:23.346 [info] == Migrated 20200221095721 in 0.0s707server # [699408.632215] server mobilizon_ctl[536]: 16:50:23.353 [info] == Running 20200221160744 Mobilizon.Repo.Migrations.CreateResources.change/0 forward708server # [699408.632806] server mobilizon_ctl[536]: 16:50:23.353 [info] create table resource709server # [699408.637298] server mobilizon_ctl[536]: 16:50:23.358 [info] == Migrated 20200221160744 in 0.0s710server # [699408.642559] server mobilizon_ctl[536]: 16:50:23.363 [info] == Running 20200406115807 Mobilizon.Storage.Repo.Migrations.AddConversations.change/0 forward711server # [699408.642753] server mobilizon_ctl[536]: 16:50:23.363 [info] create table conversations712server # [699408.647050] server mobilizon_ctl[536]: 16:50:23.368 [info] alter table comments713server # [699408.648394] server mobilizon_ctl[536]: 16:50:23.369 [info] == Migrated 20200406115807 in 0.0s714server # [699408.657986] server mobilizon_ctl[536]: 16:50:23.379 [info] == Running 20200410100554 Mobilizon.Storage.Repo.Migrations.AddNumberEditsToComment.change/0 forward715server # [699408.658142] server mobilizon_ctl[536]: 16:50:23.379 [info] alter table comments716server # [699408.659576] server mobilizon_ctl[536]: 16:50:23.380 [info] == Migrated 20200410100554 in 0.0s717server # [699408.672022] server mobilizon_ctl[536]: 16:50:23.393 [info] == Running 20200513142813 Mobilizon.Storage.Repo.Migrations.AddResourcesAndTodosEndpointsToActor.change/0 forward718server # [699408.672320] server mobilizon_ctl[536]: 16:50:23.393 [info] alter table actors719server # [699408.673474] server mobilizon_ctl[536]: 16:50:23.394 [info] == Migrated 20200513142813 in 0.0s720server # [699408.680340] server mobilizon_ctl[536]: 16:50:23.401 [info] == Running 20200514101612 Mobilizon.Storage.Repo.Migrations.AddLocalAttributeToResourcesAndTodos.change/0 forward721server # [699408.680672] server mobilizon_ctl[536]: 16:50:23.401 [info] alter table resource722server # [699408.682010] server mobilizon_ctl[536]: 16:50:23.402 [info] alter table todo_lists723server # [699408.682389] server mobilizon_ctl[536]: 16:50:23.403 [info] alter table todos724server # [699408.683823] server mobilizon_ctl[536]: 16:50:23.404 [info] == Migrated 20200514101612 in 0.0s725server # [699408.689848] server mobilizon_ctl[536]: 16:50:23.411 [info] == Running 20200518084949 Mobilizon.Storage.Repo.Migrations.MoveInviterFromMetadataToMemberTable.change/0 forward726server # [699408.690047] server mobilizon_ctl[536]: 16:50:23.411 [info] alter table members727server # [699408.693105] server mobilizon_ctl[536]: 16:50:23.413 [info] == Migrated 20200518084949 in 0.0s728server # [699408.701017] server mobilizon_ctl[536]: 16:50:23.422 [info] == Running 20200519082820 Mobilizon.Storage.Repo.Migrations.AddUniqueURLContraintToSomeTables.change/0 forward729server # [699408.701465] server mobilizon_ctl[536]: 16:50:23.422 [info] create index members_url_index730server # [699408.703315] server mobilizon_ctl[536]: 16:50:23.424 [info] create index resource_url_index731server # [699408.704332] server mobilizon_ctl[536]: 16:50:23.425 [info] create index todo_lists_url_index732server # [699408.705057] server mobilizon_ctl[536]: 16:50:23.426 [info] create index todos_url_index733server # [699408.706151] server mobilizon_ctl[536]: 16:50:23.427 [info] == Migrated 20200519082820 in 0.0s734server # [699408.710192] server mobilizon_ctl[536]: 16:50:23.431 [info] == Running 20200526131523 Mobilizon.Repo.Migrations.CreateUserSettings.change/0 forward735server # [699408.710583] server mobilizon_ctl[536]: 16:50:23.431 [info] create table user_settings736server # [699408.713250] server mobilizon_ctl[536]: 16:50:23.434 [info] == Migrated 20200526131523 in 0.0s737server # [699408.723691] server mobilizon_ctl[536]: 16:50:23.444 [info] == Running 20200605154921 Mobilizon.Storage.Repo.Migrations.AddNotificationPendingParticipationToSettings.change/0 forward738server # [699408.723962] server mobilizon_ctl[536]: 16:50:23.444 [info] alter table user_settings739server # [699408.724953] server mobilizon_ctl[536]: 16:50:23.445 [info] == Migrated 20200605154921 in 0.0s740server # [699408.728682] server mobilizon_ctl[536]: 16:50:23.449 [info] == Running 20200612155254 Mobilizon.Storage.Repo.Migrations.AddDisabledParameterToUsers.change/0 forward741server # [699408.729034] server mobilizon_ctl[536]: 16:50:23.450 [info] alter table users742server # [699408.730210] server mobilizon_ctl[536]: 16:50:23.451 [info] == Migrated 20200612155254 in 0.0s743server # [699408.737054] server mobilizon_ctl[536]: 16:50:23.458 [info] == Running 20200630123819 Mobilizon.Storage.Repo.Migrations.AddProviderToUserAndMakePasswordMandatory.up/0 forward744server # [699408.737339] server mobilizon_ctl[536]: 16:50:23.458 [info] alter table users745server # [699408.739053] server mobilizon_ctl[536]: 16:50:23.459 [info] == Migrated 20200630123819 in 0.0s746server # [699408.748665] server mobilizon_ctl[536]: 16:50:23.469 [info] == Running 20200708080516 Mobilizon.Repo.Migrations.CreatePosts.up/0 forward747server # [699408.752041] server mobilizon_ctl[536]: 16:50:23.473 [info] execute "CREATE TYPE public.post_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')"748server # [699408.752853] server mobilizon_ctl[536]: 16:50:23.473 [info] create table posts749server # [699408.757835] server mobilizon_ctl[536]: 16:50:23.478 [info] create table posts_tags750server # [699408.761191] server mobilizon_ctl[536]: 16:50:23.482 [info] alter table actors751server # [699408.762597] server mobilizon_ctl[536]: 16:50:23.483 [info] == Migrated 20200708080516 in 0.0s752server # [699408.770060] server mobilizon_ctl[536]: 16:50:23.491 [info] == Running 20200717142633 Mobilizon.Storage.Repo.Migrations.RenameConversationsToDiscussions.up/0 forward753server # [699408.770208] server mobilizon_ctl[536]: 16:50:23.491 [info] rename table conversations to discussions754server # [699408.771016] server mobilizon_ctl[536]: 16:50:23.492 [info] rename column conversation_id to discussion_id on table comments755server # [699408.771530] server mobilizon_ctl[536]: 16:50:23.492 [info] alter table actors756server # [699408.772282] server mobilizon_ctl[536]: 16:50:23.493 [info] == Migrated 20200717142633 in 0.0s757server # [699408.781657] server mobilizon_ctl[536]: 16:50:23.502 [info] == Running 20200721131521 Mobilizon.Storage.Repo.Migrations.AddUrlToConversation.up/0 forward758server # [699408.781801] server mobilizon_ctl[536]: 16:50:23.503 [info] drop constraint if exists comments_conversation_id_fkey from table comments759server # [699408.782869] server mobilizon_ctl[536]: 16:50:23.504 [info] drop constraint if exists comments_discussion_id_fkey from table comments760server # [699408.783391] server mobilizon_ctl[536]: 16:50:23.504 [info] constraint "comments_discussion_id_fkey" of relation "comments" does not exist, skipping761server # [699408.783448] server mobilizon_ctl[536]: 16:50:23.504 [info] alter table discussions762server # [699408.785267] server mobilizon_ctl[536]: 16:50:23.506 [info] alter table comments763server # [699408.787354] server mobilizon_ctl[536]: 16:50:23.508 [info] == Migrated 20200721131521 in 0.0s764server # [699408.794359] server mobilizon_ctl[536]: 16:50:23.515 [info] == Running 20200805124620 Mobilizon.Storage.Repo.Migrations.AddAddressToActors.change/0 forward765server # [699408.794493] server mobilizon_ctl[536]: 16:50:23.515 [info] alter table actors766server # [699408.797036] server mobilizon_ctl[536]: 16:50:23.518 [info] == Migrated 20200805124620 in 0.0s767server # [699408.803762] server mobilizon_ctl[536]: 16:50:23.524 [info] == Running 20200817080549 Mobilizon.Storage.Repo.Migrations.AddPublishedAtToEntities.up/0 forward768server # [699408.804102] server mobilizon_ctl[536]: 16:50:23.525 [info] alter table comments769server # [699408.805400] server mobilizon_ctl[536]: 16:50:23.526 [info] alter table resource770server # [699408.806889] server mobilizon_ctl[536]: 16:50:23.528 [info] alter table todo_lists771server # [699408.807911] server mobilizon_ctl[536]: 16:50:23.529 [info] alter table todos772server # [699408.809293] server mobilizon_ctl[536]: 16:50:23.530 [info] == Migrated 20200817080549 in 0.0s773server # [699408.816098] server mobilizon_ctl[536]: 16:50:23.537 [info] == Running 20200828071543 Mobilizon.Storage.Repo.Migrations.AddLoginInformationToUser.change/0 forward774server # [699408.816282] server mobilizon_ctl[536]: 16:50:23.537 [info] alter table users775server # [699408.817423] server mobilizon_ctl[536]: 16:50:23.538 [info] == Migrated 20200828071543 in 0.0s776server # [699408.824208] server mobilizon_ctl[536]: 16:50:23.545 [info] == Running 20200901101307 Mobilizon.Storage.Repo.Migrations.FixRelayVisibility.up/0 forward777server # [699408.828474] server mobilizon_ctl[536]: 16:50:23.549 [info] == Migrated 20200901101307 in 0.0s778server # [699408.834662] server mobilizon_ctl[536]: 16:50:23.555 [info] == Running 20200928150725 Mobilizon.Storage.Repo.Migrations.AddContactsToEvents.change/0 forward779server # [699408.835052] server mobilizon_ctl[536]: 16:50:23.556 [info] create table event_contacts780server # [699408.839716] server mobilizon_ctl[536]: 16:50:23.560 [info] == Migrated 20200928150725 in 0.0s781server # [699408.844408] server mobilizon_ctl[536]: 16:50:23.565 [info] == Running 20201006132530 Mobilizon.Storage.Repo.Migrations.ChangeDefaultNotificationPendingParticipation.up/0 forward782server # [699408.844527] server mobilizon_ctl[536]: 16:50:23.565 [info] alter table user_settings783server # [699408.845771] server mobilizon_ctl[536]: 16:50:23.566 [info] == Migrated 20201006132530 in 0.0s784server # [699408.852334] server mobilizon_ctl[536]: 16:50:23.573 [info] == Running 20201103141811 Mobilizon.Storage.Repo.Migrations.AddNotificationPendingMembershipToSettings.change/0 forward785server # [699408.852454] server mobilizon_ctl[536]: 16:50:23.573 [info] alter table user_settings786server # [699408.854825] server mobilizon_ctl[536]: 16:50:23.575 [info] == Migrated 20201103141811 in 0.0s787server # [699408.859203] server mobilizon_ctl[536]: 16:50:23.579 [info] == Running 20201105145719 Mobilizon.Storage.Repo.Migrations.RepairGroupsWithMissingURLs.up/0 forward788server # [699408.870495] server mobilizon_ctl[536]: 16:50:23.591 [info] == Migrated 20201105145719 in 0.0s789server # [699408.877982] server mobilizon_ctl[536]: 16:50:23.599 [info] == Running 20201114174929 Mobilizon.Storage.Repo.Migrations.FixObanMigrationsForOlderPostgreSQLVersions.up/0 forward790server # [699408.878687] server mobilizon_ctl[536]: 16:50:23.599 [info] == Migrated 20201114174929 in 0.0s791server # [699408.881849] server mobilizon_ctl[536]: 16:50:23.603 [info] == Running 20201114175249 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV9.up/0 forward792server # [699408.883884] server mobilizon_ctl[536]: 16:50:23.604 [info] == Migrated 20201114175249 in 0.0s793server # [699408.892101] server mobilizon_ctl[536]: 16:50:23.613 [info] == Running 20201120161229 Mobilizon.Storage.Repo.Migrations.FixPictureDeletion.up/0 forward794server # [699408.892425] server mobilizon_ctl[536]: 16:50:23.613 [info] drop constraint if exists posts_picture_id_fkey from table posts795server # [699408.893792] server mobilizon_ctl[536]: 16:50:23.614 [info] alter table posts796server # [699408.895450] server mobilizon_ctl[536]: 16:50:23.616 [info] drop constraint if exists events_picture_id_fkey from table events797server # [699408.896195] server mobilizon_ctl[536]: 16:50:23.617 [info] alter table events798server # [699408.898176] server mobilizon_ctl[536]: 16:50:23.618 [info] == Migrated 20201120161229 in 0.0s799server # [699408.904599] server mobilizon_ctl[536]: 16:50:23.625 [info] == Running 20201124094655 Mobilizon.Storage.Repo.Migrations.AddMediaTables.change/0 forward800server # [699408.905070] server mobilizon_ctl[536]: 16:50:23.626 [info] rename table pictures to medias801server # [699408.905956] server mobilizon_ctl[536]: 16:50:23.627 [info] create table events_medias802server # [699408.908356] server mobilizon_ctl[536]: 16:50:23.629 [info] create table posts_medias803server # [699408.912868] server mobilizon_ctl[536]: 16:50:23.633 [info] create table comments_medias804server # [699408.916539] server mobilizon_ctl[536]: 16:50:23.637 [info] == Migrated 20201124094655 in 0.0s805server # [699408.924636] server mobilizon_ctl[536]: 16:50:23.645 [info] == Running 20210127153325 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV10.up/0 forward806server # [699408.926148] server mobilizon_ctl[536]: 16:50:23.647 [info] == Migrated 20210127153325 in 0.0s807server # [699408.929547] server mobilizon_ctl[536]: 16:50:23.650 [info] == Running 20210210143432 Mobilizon.Storage.Repo.Migrations.AddLocationSettingsToUser.change/0 forward808server # [699408.929830] server mobilizon_ctl[536]: 16:50:23.650 [info] alter table user_settings809server # [699408.931286] server mobilizon_ctl[536]: 16:50:23.652 [info] == Migrated 20210210143432 in 0.0s810server # [699408.937525] server mobilizon_ctl[536]: 16:50:23.658 [info] == Running 20210215092515 Mobilizon.Storage.Repo.Migrations.AddActivityTable.change/0 forward811server # [699408.937771] server mobilizon_ctl[536]: 16:50:23.658 [info] create table activities812server # [699408.943309] server mobilizon_ctl[536]: 16:50:23.664 [info] == Migrated 20210215092515 in 0.0s813server # [699408.951603] server mobilizon_ctl[536]: 16:50:23.672 [info] == Running 20210217164549 Mobilizon.Storage.Repo.Migrations.AddMemberSinceToMembers.up/0 forward814server # [699408.951724] server mobilizon_ctl[536]: 16:50:23.672 [info] alter table members815server # [699408.954912] server mobilizon_ctl[536]: 16:50:23.675 [info] == Migrated 20210217164549 in 0.0s816server # [699408.962422] server mobilizon_ctl[536]: 16:50:23.683 [info] == Running 20210310084210 Mobilizon.Storage.Repo.Migrations.AddIndexesToActivities.change/0 forward817server # [699408.962682] server mobilizon_ctl[536]: 16:50:23.683 [info] create index activity_group_id818server # [699408.963704] server mobilizon_ctl[536]: 16:50:23.684 [info] create index activity_filter819server # [699408.964803] server mobilizon_ctl[536]: 16:50:23.685 [info] == Migrated 20210310084210 in 0.0s820server # [699408.972813] server mobilizon_ctl[536]: 16:50:23.693 [info] == Running 20210422140923 Mobilizon.Storage.Repo.Migrations.CleanupAddresses.up/0 forward821server # [699408.974160] server mobilizon_ctl[536]: 16:50:23.695 [info] == Migrated 20210422140923 in 0.0s822server # [699408.979162] server mobilizon_ctl[536]: 16:50:23.700 [info] == Running 20210422155913 Mobilizon.Storage.Repo.Migrations.AddIndexToAddresses.up/0 forward823server # [699408.979345] server mobilizon_ctl[536]: 16:50:23.700 [info] create index if not exists addresses_url_index824server # [699408.981053] server mobilizon_ctl[536]: 16:50:23.702 [info] == Migrated 20210422155913 in 0.0s825server # [699408.987623] server mobilizon_ctl[536]: 16:50:23.708 [info] == Running 20210427091034 Mobilizon.Storage.Repo.Migrations.RepairUsersDefaultActors.up/0 forward826server # [699408.989751] server mobilizon_ctl[536]: 16:50:23.710 [info] == Migrated 20210427091034 in 0.0s827server # [699408.996714] server mobilizon_ctl[536]: 16:50:23.717 [info] == Running 20210505172402 Mobilizon.Storage.Repo.Migrations.AddGroupNotificationAndLastNotificationDateSettings.change/0 forward828server # [699408.996906] server mobilizon_ctl[536]: 16:50:23.718 [info] alter table user_settings829server # [699408.997890] server mobilizon_ctl[536]: 16:50:23.719 [info] == Migrated 20210505172402 in 0.0s830server # [699409.003879] server mobilizon_ctl[536]: 16:50:23.725 [info] == Running 20210506080303 Mobilizon.Repo.Migrations.CreateUserPushSubscriptions.change/0 forward831server # [699409.004299] server mobilizon_ctl[536]: 16:50:23.725 [info] create table user_push_subscriptions832server # [699409.008183] server mobilizon_ctl[536]: 16:50:23.729 [info] create index user_push_subscriptions_user_id_digest_index833server # [699409.009978] server mobilizon_ctl[536]: 16:50:23.730 [info] == Migrated 20210506080303 in 0.0s834server # [699409.016354] server mobilizon_ctl[536]: 16:50:23.736 [info] == Running 20210512084824 Mobilizon.Storage.Repo.Migrations.RepairRelayAndAnonymousActors.up/0 forward835server # [699409.017461] server mobilizon_ctl[536]: 16:50:23.738 [info] == Migrated 20210512084824 in 0.0s836server # [699409.024382] server mobilizon_ctl[536]: 16:50:23.745 [info] == Running 20210526203337 Mobilizon.Storage.Repo.Migrations.AddUserActivitySettings.change/0 forward837server # [699409.025240] server mobilizon_ctl[536]: 16:50:23.745 [info] create table user_activity_settings838server # [699409.028409] server mobilizon_ctl[536]: 16:50:23.749 [info] create index user_activity_settings_user_id_key_method_index839server # [699409.029526] server mobilizon_ctl[536]: 16:50:23.750 [info] == Migrated 20210526203337 in 0.0s840server # [699409.037734] server mobilizon_ctl[536]: 16:50:23.758 [info] == Running 20210601082412 Mobilizon.Storage.Repo.Migrations.AddIsAnnouncementToComments.change/0 forward841server # [699409.037855] server mobilizon_ctl[536]: 16:50:23.759 [info] alter table comments842server # [699409.039145] server mobilizon_ctl[536]: 16:50:23.760 [info] == Migrated 20210601082412 in 0.0s843server # [699409.042319] server mobilizon_ctl[536]: 16:50:23.763 [info] == Running 20210601082613 Mobilizon.Storage.Repo.Migrations.FixUserSettingsNullableFields.change/0 forward844server # [699409.042536] server mobilizon_ctl[536]: 16:50:23.763 [info] alter table user_settings845server # [699409.044128] server mobilizon_ctl[536]: 16:50:23.765 [info] == Migrated 20210601082613 in 0.0s846server # [699409.050244] server mobilizon_ctl[536]: 16:50:23.771 [info] == Running 20210608133040 Mobilizon.Storage.Repo.Migrations.AddMetadataToMedia.change/0 forward847server # [699409.050546] server mobilizon_ctl[536]: 16:50:23.771 [info] alter table medias848server # [699409.051584] server mobilizon_ctl[536]: 16:50:23.772 [info] == Migrated 20210608133040 in 0.0s849server # [699409.056877] server mobilizon_ctl[536]: 16:50:23.777 [info] == Running 20210622133516 Mobilizon.Storage.Repo.Migrations.CleanupPosts.up/0 forward850server # [699409.058870] server mobilizon_ctl[536]: 16:50:23.779 [info] == Migrated 20210622133516 in 0.0s851server # [699409.067318] server mobilizon_ctl[536]: 16:50:23.788 [info] == Running 20210622133555 Mobilizon.Storage.Repo.Migrations.AddIndexToPosts.up/0 forward852server # [699409.067702] server mobilizon_ctl[536]: 16:50:23.788 [info] create index if not exists posts_url_index853server # [699409.069110] server mobilizon_ctl[536]: 16:50:23.790 [info] == Migrated 20210622133555 in 0.0s854server # [699409.080234] server mobilizon_ctl[536]: 16:50:23.800 [info] == Running 20210730143924 Mobilizon.Storage.Repo.Migrations.PutUniqueIndexOnParticipantsUrls.up/0 forward855server # [699409.080234] server mobilizon_ctl[536]: 16:50:23.800 [info] create index if not exists participants_url_index856server # [699409.081928] server mobilizon_ctl[536]: 16:50:23.802 [info] == Migrated 20210730143924 in 0.0s857server # [699409.090183] server mobilizon_ctl[536]: 16:50:23.811 [info] == Running 20210805142745 Mobilizon.Storage.Repo.Migrations.AddMetadataForEvents.change/0 forward858server # [699409.090480] server mobilizon_ctl[536]: 16:50:23.811 [info] alter table events859server # [699409.091474] server mobilizon_ctl[536]: 16:50:23.812 [info] == Migrated 20210805142745 in 0.0s860server # [699409.098151] server mobilizon_ctl[536]: 16:50:23.819 [info] == Running 20210819161507 Mobilizon.Storage.Repo.Migrations.AddLanguageToEntities.change/0 forward861server # [699409.098295] server mobilizon_ctl[536]: 16:50:23.819 [info] alter table events862server # [699409.100062] server mobilizon_ctl[536]: 16:50:23.821 [info] alter table comments863server # [699409.101412] server mobilizon_ctl[536]: 16:50:23.822 [info] alter table posts864server # [699409.102637] server mobilizon_ctl[536]: 16:50:23.823 [info] == Migrated 20210819161507 in 0.0s865server # [699409.108863] server mobilizon_ctl[536]: 16:50:23.830 [info] == Running 20211001101902 Mobilizon.Repo.Migrations.CreateExports.change/0 forward866server # [699409.109035] server mobilizon_ctl[536]: 16:50:23.830 [info] create table exports867server # [699409.111882] server mobilizon_ctl[536]: 16:50:23.833 [info] create index exports_file_path_index868server # [699409.112932] server mobilizon_ctl[536]: 16:50:23.833 [info] == Migrated 20211001101902 in 0.0s869server # [699409.120701] server mobilizon_ctl[536]: 16:50:23.841 [info] == Running 20211008084901 Mobilizon.Storage.Repo.Migrations.AddTimezoneToAddresses.change/0 forward870server # [699409.120996] server mobilizon_ctl[536]: 16:50:23.842 [info] alter table addresses871server # [699409.121952] server mobilizon_ctl[536]: 16:50:23.842 [info] == Migrated 20211008084901 in 0.0s872server # [699409.129233] server mobilizon_ctl[536]: 16:50:23.850 [info] == Running 20211013090405 Mobilizon.Storage.Repo.Migrations.AddCodeToParticipants.change/0 forward873server # [699409.129389] server mobilizon_ctl[536]: 16:50:23.850 [info] alter table participants874server # [699409.130488] server mobilizon_ctl[536]: 16:50:23.851 [info] == Migrated 20211013090405 in 0.0s875server # [699409.137400] server mobilizon_ctl[536]: 16:50:23.858 [info] == Running 20211022093530 Mobilizon.Storage.Repo.Migrations.AddNotifyToFollowers.change/0 forward876server # [699409.137723] server mobilizon_ctl[536]: 16:50:23.858 [info] alter table followers877server # [699409.138702] server mobilizon_ctl[536]: 16:50:23.859 [info] == Migrated 20211022093530 in 0.0s878server # [699409.146382] server mobilizon_ctl[536]: 16:50:23.867 [info] == Running 20211223141104 Mobilizon.Storage.Repo.Migrations.AddInstanceMaterializedView.up/0 forward879server # [699409.152701] server mobilizon_ctl[536]: 16:50:23.873 [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.166807] server mobilizon_ctl[536]: 16:50:23.887 [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.167989] server mobilizon_ctl[536]: 16:50:23.889 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger ON actors;\n"882server # [699409.168944] server mobilizon_ctl[536]: 16:50:23.889 [info] trigger "refresh_instances_trigger" for relation "actors" does not exist, skipping883server # [699409.169335] server mobilizon_ctl[536]: 16:50:23.890 [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.169726] server mobilizon_ctl[536]: 16:50:23.890 [info] create index if not exists instances_domain_index885server # [699409.174772] server mobilizon_ctl[536]: 16:50:23.895 [info] == Migrated 20211223141104 in 0.0s886server # [699409.183094] server mobilizon_ctl[536]: 16:50:23.904 [info] == Running 20220321154138 Mobilizon.Storage.Repo.Migrations.CreateObanPeers.up/0 forward887server # [699409.184893] server mobilizon_ctl[536]: 16:50:23.905 [info] == Migrated 20220321154138 in 0.0s888server # [699409.190295] server mobilizon_ctl[536]: 16:50:23.910 [info] == Running 20220321154142 Mobilizon.Storage.Repo.Migrations.SwapPrimaryObanIndexes.change/0 forward889server # [699409.190721] server mobilizon_ctl[536]: 16:50:23.911 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index890server # [699409.192567] server mobilizon_ctl[536]: 16:50:23.912 [info] relation "oban_jobs_state_queue_priority_scheduled_at_id_index" already exists, skipping891server # [699409.192723] server mobilizon_ctl[536]: 16:50:23.912 [info] drop index if exists public.oban_jobs_queue_state_priority_scheduled_at_id_index892server # [699409.192884] server mobilizon_ctl[536]: 16:50:23.913 [info] index "oban_jobs_queue_state_priority_scheduled_at_id_index" does not exist, skipping893server # [699409.193037] server mobilizon_ctl[536]: 16:50:23.913 [info] == Migrated 20220321154142 in 0.0s894server # [699409.197801] server mobilizon_ctl[536]: 16:50:23.918 [info] == Running 20220328153640 Mobilizon.Storage.Repo.Migrations.SetAllEventsCategoryToMeeting.up/0 forward895server # [699409.197801] server mobilizon_ctl[536]: 16:50:23.919 [info] execute "UPDATE events SET category = 'MEETING'"896server # [699409.198484] server mobilizon_ctl[536]: 16:50:23.919 [info] == Migrated 20220328153640 in 0.0s897server # [699409.205862] server mobilizon_ctl[536]: 16:50:23.926 [info] == Running 20220407083712 Mobilizon.Storage.Repo.Migrations.AddIndexesToAddresses.up/0 forward898server # [699409.206094] server mobilizon_ctl[536]: 16:50:23.927 [info] create index if not exists idx_addresses_geom_x899server # [699409.207360] server mobilizon_ctl[536]: 16:50:23.928 [info] create index if not exists idx_addresses_geom_y900server # [699409.208793] server mobilizon_ctl[536]: 16:50:23.929 [info] == Migrated 20220407083712 in 0.0s901server # [699409.212357] server mobilizon_ctl[536]: 16:50:23.933 [info] == Running 20220505091224 Mobilizon.Storage.Repo.Migrations.ChangeRefreshInstanceTriggerToOnlyExecuteOnRelays.up/0 forward902server # [699409.212533] server mobilizon_ctl[536]: 16:50:23.933 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger ON actors;\n"903server # [699409.213401] server mobilizon_ctl[536]: 16:50:23.934 [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.214287] server mobilizon_ctl[536]: 16:50:23.935 [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.214916] server mobilizon_ctl[536]: 16:50:23.936 [info] == Migrated 20220505091224 in 0.0s906server # [699409.221031] server mobilizon_ctl[536]: 16:50:23.942 [info] == Running 20220506105150 Mobilizon.Storage.Repo.Migrations.RemoveRefreshInstanceTriggers.up/0 forward907server # [699409.221327] server mobilizon_ctl[536]: 16:50:23.942 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger_new ON actors;\n"908server # [699409.222136] server mobilizon_ctl[536]: 16:50:23.943 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger_old ON actors;\n"909server # [699409.222954] server mobilizon_ctl[536]: 16:50:23.943 [info] == Migrated 20220506105150 in 0.0s910server # [699409.232256] server mobilizon_ctl[536]: 16:50:23.953 [info] == Running 20230208101626 Mobilizon.Repo.Migrations.CreateApplications.change/0 forward911server # [699409.232639] server mobilizon_ctl[536]: 16:50:23.953 [info] create table applications912server # [699409.236381] server mobilizon_ctl[536]: 16:50:23.957 [info] create index applications_owner_id_owner_type_index913server # [699409.237427] server mobilizon_ctl[536]: 16:50:23.958 [info] == Migrated 20230208101626 in 0.0s914server # [699409.242769] server mobilizon_ctl[536]: 16:50:23.963 [info] == Running 20230215125801 Mobilizon.Repo.Migrations.CreateApplicationTokens.change/0 forward915server # [699409.243036] server mobilizon_ctl[536]: 16:50:23.964 [info] create table application_tokens916server # [699409.247208] server mobilizon_ctl[536]: 16:50:23.968 [info] create index application_tokens_user_id_application_id_index917server # [699409.248889] server mobilizon_ctl[536]: 16:50:23.969 [info] == Migrated 20230215125801 in 0.0s918server # [699409.256841] server mobilizon_ctl[536]: 16:50:23.978 [info] == Running 20230217084253 Mobilizon.Repo.Migrations.CreateApplicationDeviceActivation.change/0 forward919server # [699409.257135] server mobilizon_ctl[536]: 16:50:23.978 [info] create table application_device_activation920server # [699409.262461] server mobilizon_ctl[536]: 16:50:23.983 [info] == Migrated 20230217084253 in 0.0s921server # [699409.268701] server mobilizon_ctl[536]: 16:50:23.989 [info] == Running 20230605143534 Mobilizon.Storage.Repo.Migrations.AllowMultipleEventsToBeReported.up/0 forward922server # [699409.269023] server mobilizon_ctl[536]: 16:50:23.989 [info] create table reports_events923server # [699409.271420] server mobilizon_ctl[536]: 16:50:23.992 [info] == Migrated 20230605143534 in 0.0s924server # [699409.279625] server mobilizon_ctl[536]: 16:50:24.000 [info] == Running 20230605153836 Mobilizon.Storage.Repo.Migrations.BackfillReportEventsWithOldEvents.up/0 forward925server # [699409.280995] server mobilizon_ctl[536]: 16:50:24.002 [info] == Migrated 20230605153836 in 0.0s926server # [699409.287394] server mobilizon_ctl[536]: 16:50:24.008 [info] == Running 20230605154106 Mobilizon.Storage.Repo.Migrations.RemoveObsoleteEventIdOnReports.up/0 forward927server # [699409.287807] server mobilizon_ctl[536]: 16:50:24.008 [info] alter table reports928server # [699409.289835] server mobilizon_ctl[536]: 16:50:24.010 [info] == Migrated 20230605154106 in 0.0s929server # [699409.299311] server mobilizon_ctl[536]: 16:50:24.020 [info] == Running 20230831153358 Mobilizon.Storage.Repo.Migrations.RemoveOnDeleteCascadeForReports.up/0 forward930server # [699409.299724] server mobilizon_ctl[536]: 16:50:24.020 [info] execute "DROP MATERIALIZED VIEW IF EXISTS instances;\n"931server # [699409.302555] server mobilizon_ctl[536]: 16:50:24.023 [info] drop constraint reports_reported_id_fkey from table reports932server # [699409.303445] server mobilizon_ctl[536]: 16:50:24.024 [info] drop constraint reports_reporter_id_fkey from table reports933server # [699409.304896] server mobilizon_ctl[536]: 16:50:24.025 [info] drop constraint reports_manager_id_fkey from table reports934server # [699409.306124] server mobilizon_ctl[536]: 16:50:24.027 [info] alter table reports935server # [699409.309454] server mobilizon_ctl[536]: 16:50:24.030 [info] drop constraint report_notes_moderator_id_fkey from table report_notes936server # [699409.310064] server mobilizon_ctl[536]: 16:50:24.031 [info] alter table report_notes937server # [699409.311509] server mobilizon_ctl[536]: 16:50:24.032 [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.324199] server mobilizon_ctl[536]: 16:50:24.044 [info] == Migrated 20230831153358 in 0.0s939server # [699409.334316] server mobilizon_ctl[536]: 16:50:24.055 [info] == Running 20230901160000 Mobilizon.Storage.Repo.Migrations.AddExternalUrlForEvents.up/0 forward940server # [699409.334621] server mobilizon_ctl[536]: 16:50:24.055 [info] alter table events941server # [699409.335718] server mobilizon_ctl[536]: 16:50:24.056 [info] execute "ALTER TABLE events ALTER COLUMN join_options TYPE VARCHAR USING join_options::text"942server # [699409.341014] server mobilizon_ctl[536]: 16:50:24.062 [info] execute "ALTER TABLE events ALTER COLUMN join_options DROP DEFAULT"943server # [699409.341615] server mobilizon_ctl[536]: 16:50:24.062 [info] execute "DROP TYPE public.join_options"944server # [699409.342469] server mobilizon_ctl[536]: 16:50:24.063 [info] execute "CREATE TYPE public.join_options AS ENUM ('free', 'restricted', 'invite', 'external')"945server # [699409.343641] server mobilizon_ctl[536]: 16:50:24.064 [info] execute "ALTER TABLE events ALTER COLUMN join_options TYPE join_options USING join_options::join_options"946server # [699409.347542] server mobilizon_ctl[536]: 16:50:24.068 [info] execute "ALTER TABLE events ALTER COLUMN join_options SET DEFAULT 'free'::join_options"947server # [699409.348421] server mobilizon_ctl[536]: 16:50:24.069 [info] == Migrated 20230901160000 in 0.0s948server # [699409.356973] server mobilizon_ctl[536]: 16:50:24.078 [info] == Running 20230920071502 Mobilizon.Storage.Repo.Migrations.AddActorConversations.up/0 forward949server # [699409.357312] server mobilizon_ctl[536]: 16:50:24.078 [info] create table conversations950server # [699409.361979] server mobilizon_ctl[536]: 16:50:24.083 [info] create table conversation_participants951server # [699409.365387] server mobilizon_ctl[536]: 16:50:24.086 [info] alter table comments952server # [699409.366818] server mobilizon_ctl[536]: 16:50:24.087 [info] == Migrated 20230920071502 in 0.0s953server # [699409.400073] server mobilizon_ctl[536]: 16:50:24.118 [info] == Running 20231220092536 Mobilizon.Storage.Repo.Migrations.AddActorInstances.change/0 forward954server # [699409.400073] server mobilizon_ctl[536]: 16:50:24.118 [info] create table instance_actors955server # [699409.407632] server mobilizon_ctl[536]: 16:50:24.128 [info] create index instance_actors_domain_index956server # [699409.411726] server mobilizon_ctl[536]: 16:50:24.132 [info] == Migrated 20231220092536 in 0.0s957server # [699409.418779] server mobilizon_ctl[536]: 16:50:24.139 [info] == Running 20240104103036 Mobilizon.Storage.Repo.Migrations.ChangeActorInstanceDescriptionTypeToText.up/0 forward958server # [699409.419151] server mobilizon_ctl[536]: 16:50:24.140 [info] alter table instance_actors959server # [699409.421665] server mobilizon_ctl[536]: 16:50:24.141 [info] == Migrated 20240104103036 in 0.0s960server # [699409.429617] server mobilizon_ctl[536]: 16:50:24.150 [info] == Running 20240222121054 Mobilizon.Storage.Repo.Migrations.CreateAdminSettingsMedias.change/0 forward961server # [699409.429893] server mobilizon_ctl[536]: 16:50:24.151 [info] create table admin_settings_medias962server # [699409.435381] server mobilizon_ctl[536]: 16:50:24.156 [info] create index admin_settings_medias_group_name_index963server # [699409.437439] server mobilizon_ctl[536]: 16:50:24.158 [info] == Migrated 20240222121054 in 0.0s964server # [699409.467414] server mobilizon_ctl[536]: 16:50:24.188 [info] == Running 20240725130410 Mobilizon.Storage.Repo.Migrations.AddEventPhysicalAddressIndex.up/0 forward965server # [699409.467548] server mobilizon_ctl[536]: 16:50:24.188 [info] create index events_phys_addr_id966server # [699409.470241] server mobilizon_ctl[536]: 16:50:24.190 [info] == Migrated 20240725130410 in 0.0s967server # [699409.480669] server mobilizon_ctl[536]: 16:50:24.201 [info] == Running 20250521145952 Mobilizon.Storage.Repo.Migrations.AddUuidToMedia.change/0 forward968server # [699409.481015] server mobilizon_ctl[536]: 16:50:24.202 [info] alter table medias969server # [699409.485737] server mobilizon_ctl[536]: 16:50:24.206 [info] create index medias_uuid_index970server # [699409.487328] server mobilizon_ctl[536]: 16:50:24.208 [info] == Migrated 20250521145952 in 0.0s971server # [699409.501084] server mobilizon_ctl[536]: 16:50:24.222 [info] == Running 20250911120910 Mobilizon.Storage.Repo.Migrations.AddModerationToUser.change/0 forward972server # [699409.501305] server mobilizon_ctl[536]: 16:50:24.222 [info] alter table users973server # [699409.502434] server mobilizon_ctl[536]: 16:50:24.223 [info] == Migrated 20250911120910 in 0.0s974server # [699409.511799] server mobilizon_ctl[536]: 16:50:24.231 [info] == Running 20250919143627 Mobilizon.Storage.Repo.Migrations.UpdateRoleToUser.change/0 forward975server # [699409.512052] server mobilizon_ctl[536]: 16:50:24.231 [info] execute "ALTER TYPE user_role ADD VALUE IF NOT EXISTS 'pending';"976server # [699409.512186] server mobilizon_ctl[536]: 16:50:24.232 [info] enum label "pending" already exists, skipping977server # [699409.512248] server mobilizon_ctl[536]: 16:50:24.232 [info] == Migrated 20250919143627 in 0.0s978server # [699409.527822] server mobilizon_ctl[536]: 16:50:24.248 [info] == Running 20251027133219 Mobilizon.Storage.Repo.Migrations.CreateInvitations.change/0 forward979server # [699409.529105] server mobilizon_ctl[536]: 16:50:24.249 [info] create table invitations980server # [699409.533547] server mobilizon_ctl[536]: 16:50:24.254 [info] create index invitations_token_index981server # [699409.534805] server mobilizon_ctl[536]: 16:50:24.255 [info] == Migrated 20251027133219 in 0.0s982server # [699409.548309] server mobilizon_ctl[536]: 16:50:24.269 [info] == Running 20251111093015 Mobilizon.Storage.Repo.Migrations.AddAllowToGroup.change/0 forward983server # [699409.548556] server mobilizon_ctl[536]: 16:50:24.269 [info] alter table actors984server # [699409.549735] server mobilizon_ctl[536]: 16:50:24.270 [info] == Migrated 20251111093015 in 0.0s985server # [699409.587446] server systemd[1]: Started Mobilizon federated organization and mobilization platform.986server # [699409.588090] server systemd[1]: Reached target Multi-User System.987server # [699409.588719] server systemd[1]: Startup finished in 16.875s.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.08 seconds)992server: must succeed: curl --fail https://acme.test/993 % Total % Received % Xferd Average Speed Time Time Time Current994 Dload Upload Total Spent Left Speed995 0 0 0 0 0 0 0 0 0server # [699413.619468] server mobilizon[599]: 16:50:28.340 [info] No tzdata release files found in custom data dir. Copying release file from tzdata priv dir.996server # [699413.731448] server mobilizon[599]: 16:50:28.449 [info] Source for database :city not found: "/var/lib/mobilizon/geo/GeoLite2-City.mmdb"997server # [699413.792463] server mobilizon[599]: 16:50:28.513 [info] Loading 122 CA(s) from :otp store998server # [699413.816039] server mobilizon[599]: 16:50:28.537 [info] Running Mobilizon.Web.Endpoint with Bandit 1.12.0 at ::1:41395 (http)999server # [699413.816255] server mobilizon[599]: 16:50:28.537 [info] Access Mobilizon.Web.Endpoint at https://acme.test1000server # [699413.827954] server mobilizon[599]: 16:50:28.549 [info] {"message":"notifier only receiving messages from its own node, functionality may be degraded","source":"oban","event":"notifier:switch","connectivity_status":"solitary"}1001server # [699413.829472] server mobilizon[599]: 16:50:28.550 [info] {"message":"peer became leader","node":"mobilizon@server","source":"oban","event":"peer:election","leader":true,"was_leader":false}1002100 2289 100 2289 0 0 70965 0 01003server: (finished: must succeed: curl --fail https://acme.test/, in 0.06 seconds)1004(finished: run the VM test script, in 21.84 seconds)1005test script finished in 21.96s1006cleanup1007kill NspawnMachine (pid 50)1008Container server terminated by signal KILL.1009(finished: cleanup, in 0.27 seconds)