Machine state will be reset. To keep it, pass --keep-machine-state start all VLans (finished: start all VLans, in 0.00 seconds) Test will time out and terminate in 3600 seconds run the VM test script additionally exposed symbols: server, vlan1, start_all, test_script, machines, machines_qemu, machines_nspawn, vlans, driver, log, os, create_machine, subtest, run_tests, join_all, retry, serial_stdout_off, serial_stdout_on, polling_condition, BaseMachine, QemuMachine, NspawnMachine, t, debug, dump_machine_ssh server: waiting for unit mobilizon.service server: systemd-nspawn running (pid 50) server: Waiting for journal at /build/vm-state-server/var/log/journal... nixos-nspawn(server): TAP vde-tap1 not found; container will be isolated from VDE nixos-nspawn(server): A common reason for this is that /dev/net is not available in the Nix sandbox. Try adding /dev/net to extra-sandbox-paths. Note: in a future version of systemd-nspawn the default set of permitted socket address families will be restricted to AF_INET, AF_INET6 and AF_UNIX. Use --restrict-address-families= to configure the set of permitted socket address families, or set RestrictAddressFamilies= in a .nspawn file. ░ Spawning container server on /build/vm-state-server. server # No journal files were found. server # No journal boot entry found for the specified boot (+0). server # [699393.339239] server systemd-journald[57]: Journal started server # [699393.339294] server systemd-journald[57]: Runtime Journal (/run/log/journal/ee2eb27d73aa48719b285a224f42ffa4) is 8M, max 311.2M, 303.2M free. server # [699393.370411] server systemd[1]: Listening on Journal Log Access Socket. server # [699393.370962] server systemd[1]: Finished Apply Kernel Variables. server # [699393.387682] server systemd[1]: Finished Create Static Device Nodes in /dev gracefully. server # [699393.407093] server systemd[1]: Starting Flush Journal to Persistent Storage... server # [699393.408272] server systemd[1]: Starting Create Static Device Nodes in /dev... server # [699393.440755] server systemd-journald[57]: Time spent on flushing to /var/log/journal/ee2eb27d73aa48719b285a224f42ffa4 is 2.737ms for 7 entries. server # [699393.440755] server systemd-journald[57]: System Journal (/var/log/journal/ee2eb27d73aa48719b285a224f42ffa4) is 512B, max 4G, 3.9G free. server # [699393.460610] server systemd[1]: Finished Flush Journal to Persistent Storage. server # [699393.461075] server systemd[1]: Finished Create Static Device Nodes in /dev. server # [699393.462671] server systemd[1]: Reached target Preparation for Local File Systems. server # [699393.462868] server systemd[1]: Rule-based Manager for Device Events and Files skipped, unmet condition check ConditionPathIsReadWrite=/sys server # [699393.567144] server systemd[1]: Finished Firewall. server # [699394.344568] server systemd[1]: Mounting /run/wrappers... server # [699394.401471] server systemd[1]: Mounted /run/wrappers. server # [699394.402362] server systemd[1]: Reached target Local File Systems. server # [699394.405076] server systemd[1]: Listening on Boot Loader Control Service Socket. server # [699394.406307] server systemd[1]: Starting Create SUID/SGID Wrappers... server # [699394.406359] server systemd[1]: Update Boot Loader Random Seed skipped, unmet condition check ConditionVirtualization=!container server # [699394.407435] server systemd[1]: Starting Save Transient machine-id to Disk... server # [699394.411197] server systemd[1]: Starting Create System Files and Directories... server # [699394.429154] server systemd-tmpfiles[161]: Cannot set file attributes for '/var/empty', value=0x00000010, mask=0x00000010, ignoring: Operation not permitted server # [699394.429572] server systemd-tmpfiles[161]: fchmod() of /var/log/journal failed: Operation not permitted server # [699394.429700] server systemd-tmpfiles[161]: fchmod() of /var/log/journal/ee2eb27d73aa48719b285a224f42ffa4 failed: Operation not permitted server # [699394.429856] server systemd-tmpfiles[161]: fchmod() of /run/log/journal failed: Operation not permitted server # [699394.436999] server suid-sgid-wrappers-start[168]: chmod: changing permissions of '/run/wrappers/wrappers.7qPwQd4055/chsh': Operation not permitted server # [699394.448327] server systemd[1]: suid-sgid-wrappers.service: Main process exited, code=exited, status=1/FAILURE server # [699394.448424] server systemd[1]: suid-sgid-wrappers.service: Failed with result 'exit-code'. server # [699394.448614] server systemd[1]: Failed to start Create SUID/SGID Wrappers. server # [699394.449060] server systemd[1]: Finished Create System Files and Directories. server # [699394.477099] server systemd[1]: Starting Rebuild Journal Catalog... server # [699394.478729] server systemd[1]: Starting Record System Boot/Shutdown in UTMP... server # [699394.497476] server systemd[1]: Finished Record System Boot/Shutdown in UTMP. server # [699394.517785] server systemd[1]: Finished Rebuild Journal Catalog. server # [699394.520336] server systemd[1]: Starting Update is Completed... server # [699394.533053] server systemd[1]: Finished Update is Completed. server # [699394.534081] server systemd[1]: Reached target System Initialization. server # [699394.534253] server systemd[1]: Discard unused filesystem blocks once a week skipped, unmet condition check ConditionVirtualization=!container server # [699394.534306] server systemd[1]: Started Daily Cleanup of Temporary Directories. server # [699394.534335] server systemd[1]: Reached target Timer Units. server # [699394.534490] server systemd[1]: Listening on D-Bus System Message Bus Socket. server # [699394.534745] server systemd[1]: Listening on Nix Daemon Socket. server # [699394.534905] server systemd[1]: Listening on Virtual Machine and Container Registration Service Socket. server # [699394.534940] server systemd[1]: Reached target Socket Units. server # [699394.534994] server systemd[1]: Reached target Basic System. server # [699394.536636] server systemd[1]: Starting Import lastlog data into lastlog2 database... server # [699394.537955] server systemd[1]: Starting Name Service Cache Daemon (nsncd)... server # [699394.540838] server systemd[1]: Starting resolvconf update... server # [699394.563878] server systemd[1]: Finished Import lastlog data into lastlog2 database. server # [699394.628090] server systemd[1]: etc-machine\x2did.mount: Deactivated successfully. server # [699394.629760] server systemd[1]: Finished Save Transient machine-id to Disk. server # [699394.637722] server systemd[1]: nscd.service: Deactivated successfully. server # [699394.637888] server systemd[1]: Stopped Name Service Cache Daemon (nsncd). server # [699394.642720] server systemd[1]: Starting Name Service Cache Daemon (nsncd)... server # [699394.668742] server resolvconf-start[236]: setfacl: /run/resolvconf: Operation not supported server # [699394.670108] server systemd[1]: resolvconf.service: Main process exited, code=exited, status=1/FAILURE server # [699394.670236] server systemd[1]: resolvconf.service: Failed with result 'exit-code'. server # [699394.670405] server systemd[1]: Failed to start resolvconf update. server # [699394.670680] server systemd[1]: Reached target Preparation for Network. server # [699394.672183] server systemd[1]: Starting Address configuration of eth1... server # [699394.673466] server systemd[1]: Starting Extra networking commands.... server # [699394.696694] server network-addresses-eth1-start[238]: adding address 192.168.1.1/24... done server # [699394.700417] server network-addresses-eth1-start[238]: adding address 2001:db8:1::1/64... done server # [699394.705999] server systemd[1]: Finished Address configuration of eth1. server # [699394.756935] server systemd[1]: Finished Extra networking commands.. server # [699394.757074] server systemd[1]: Reached target Network. server # [699394.758648] server systemd[1]: Starting Nginx Web Server... server # [699394.759996] server systemd[1]: Starting PostgreSQL Server... server # [699394.891758] server nsncd[224]: Sep 28 16:50:09.612 INFO started, config: Config { ignored_request_types: {}, worker_count: 8, handoff_timeout: 10s }, path: "/var/run/nscd/socket" server # [699394.891794] server systemd[1]: Started Name Service Cache Daemon (nsncd). server # [699394.892321] server systemd[1]: Reached target Host and Network Name Lookups. server # [699394.892415] server systemd[1]: Reached target User and Group Name Lookups. server # [699394.913143] server systemd[1]: Starting User Login Management... server # [699394.915695] server systemd[1]: Starting Permit User Sessions... server # [699394.926545] server systemd[1]: Finished Permit User Sessions. server # [699394.928751] server systemd[1]: Started Console Getty. server # [699394.928795] server systemd[1]: Getty on tty1 skipped, unmet condition check ConditionPathExists=/dev/tty0 server # [699394.928815] server systemd[1]: Reached target Login Prompts. server # [699396.242574] server systemd-logind[314]: New seat seat0. server # [699396.244370] server systemd[1]: Starting D-Bus System Message Bus... server # [699396.244493] server systemd[1]: Started User Login Management. server # [699396.247448] server systemd[1]: Starting linger-users.service... server # [699396.272305] server systemd[1]: linger-users.service: Deactivated successfully. server # [699396.272484] server systemd[1]: Finished linger-users.service. server # [699396.311097] server nginx-pre-start[328]: nginx: the configuration file /nix/store/9cl6v9vlqwp98sh6pkpsmqxkc0blkskg-nginx.conf syntax is ok server # [699396.311828] server nginx-pre-start[328]: nginx: configuration file /nix/store/9cl6v9vlqwp98sh6pkpsmqxkc0blkskg-nginx.conf test is successful server # [699396.319927] server systemd[1]: Started Nginx Web Server. server # [699396.386915] server postgresql-pre-start[335]: The files belonging to this database system will be owned by user "postgres". server # [699396.386915] server postgresql-pre-start[335]: This user must also own the server process. server # [699396.387571] server postgresql-pre-start[335]: The database cluster will be initialized with locale "en_US.UTF-8". server # [699396.387571] server postgresql-pre-start[335]: The default database encoding has accordingly been set to "UTF8". server # [699396.387571] server postgresql-pre-start[335]: The default text search configuration will be set to "english". server # [699396.387571] server postgresql-pre-start[335]: Data page checksums are disabled. server # [699396.387571] server postgresql-pre-start[335]: fixing permissions on existing directory /var/lib/postgresql/17 ... ok server # [699396.388311] server postgresql-pre-start[335]: creating subdirectories ... ok server # [699396.388483] server postgresql-pre-start[335]: selecting dynamic shared memory implementation ... posix server # [699396.414117] server postgresql-pre-start[335]: selecting default "max_connections" ... 100 server # [699396.441184] server postgresql-pre-start[335]: selecting default "shared_buffers" ... 128MB server # [699396.760257] server dbus-broker-launch[324]: Looking up NSS user entry for 'systemd-timesync'... server # [699396.761299] server dbus-broker-launch[324]: NSS returned no entry for 'systemd-timesync' server # [699396.761299] server dbus-broker-launch[324]: Invalid user-name in /nix/store/4h0cgqkfbcd6hf0j42k7nxs6ccpdj6ax-system-path/share/dbus-1/system.d/org.freedesktop.timesync1.conf +16: user="systemd-timesync" server # [699396.776905] server systemd[1]: Started D-Bus System Message Bus. server # [699396.788247] server dbus-broker-launch[324]: Ready server # [699398.001807] server postgresql-pre-start[335]: selecting default time zone ... UTC server # [699398.002568] server postgresql-pre-start[335]: creating configuration files ... ok server # [699398.169925] server postgresql-pre-start[335]: running bootstrap script ... ok server # [699398.667339] server postgresql-pre-start[335]: performing post-bootstrap initialization ... ok server # [699399.398051] server postgresql-pre-start[335]: syncing data to disk ... ok server # [699399.398051] server postgresql-pre-start[335]: initdb: warning: enabling "trust" authentication for local connections server # [699399.398051] server postgresql-pre-start[335]: initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. server # [699399.398051] server postgresql-pre-start[335]: Success. You can now start the database server using: server # [699399.398051] server postgresql-pre-start[335]: pg_ctl -D /var/lib/postgresql/17 -l logfile start server # [699400.778921] server postgres[350]: [350] LOG: starting PostgreSQL 17.10 on aarch64-unknown-linux-gnu, compiled by clang version 21.1.8, 64-bit server # [699400.780073] server postgres[350]: [350] LOG: listening on IPv6 address "::1", port 5432 server # [699400.780073] server postgres[350]: [350] LOG: listening on IPv4 address "127.0.0.1", port 5432 server # [699400.783609] server postgres[350]: [350] LOG: listening on Unix socket "/run/postgresql/.s.PGSQL.5432" server # [699400.792322] server postgres[356]: [356] LOG: database system was shut down at 2026-09-28 16:50:13 GMT server # [699400.802245] server postgres[350]: [350] LOG: database system is ready to accept connections server # [699400.806697] server systemd[1]: Started PostgreSQL Server. server # [699400.813224] server systemd[1]: Starting PostgreSQL Setup Scripts... server # [699400.964503] server postgresql-setup-start[367]: CREATE DATABASE server # [699400.996505] server postgresql-setup-start[372]: CREATE ROLE server # [699400.997876] server systemd[1]: Finished PostgreSQL Setup Scripts. server # [699400.999139] server systemd[1]: Reached target PostgreSQL. server # [699401.000563] server systemd[1]: Starting Mobilizon PostgreSQL setup... server # [699401.567118] server mobilizon-postgresql-start[376]: CREATE EXTENSION server # [699401.567118] server mobilizon-postgresql-start[376]: CREATE EXTENSION server # [699401.567118] server mobilizon-postgresql-start[376]: CREATE EXTENSION server # [699401.582267] server mobilizon-postgresql-start[378]: ALTER DATABASE server # [699401.585034] server systemd[1]: mobilizon-postgresql.service: Deactivated successfully. server # [699401.605145] server systemd[1]: Finished Mobilizon PostgreSQL setup. server # [699401.607665] server systemd[1]: Starting Mobilizon setup secrets... server # [699401.621792] server mobilizon-setup-secrets-start[381]: + '[' '!' -f /var/lib/mobilizon/secret-env.sh ']' server # [699401.621792] server mobilizon-setup-secrets-start[381]: + install -m 600 /dev/null /var/lib/mobilizon/secret-env.sh server # [699401.624925] server mobilizon-setup-secrets-start[381]: + cat server # [699401.626437] server mobilizon-setup-secrets-start[385]: ++ /nix/store/78jap01pznr5vx54mw7vxy2i850sjfmi-elixir-1.18.4/bin/elixir --eval 'IO.puts(:crypto.strong_rand_bytes(64)|> Base.encode64()|> binary_part(0, 64))' server: still waiting for container 'server' to reach ready state... server # [699402.122976] server mobilizon-setup-secrets-start[433]: ++ /nix/store/78jap01pznr5vx54mw7vxy2i850sjfmi-elixir-1.18.4/bin/elixir --eval 'IO.puts(:crypto.strong_rand_bytes(64)|> Base.encode64()|> binary_part(0, 64))' server # [699402.613985] server mobilizon-setup-secrets-start[481]: ++ /nix/store/78jap01pznr5vx54mw7vxy2i850sjfmi-elixir-1.18.4/bin/elixir --eval 'IO.puts(Base.encode32(:crypto.strong_rand_bytes(32)))' server # [699403.068606] server systemd[1]: mobilizon-setup-secrets.service: Deactivated successfully. server # [699403.068873] server systemd[1]: Finished Mobilizon setup secrets. server # [699403.069125] server systemd[1]: mobilizon-setup-secrets.service: Consumed 1.949s CPU time over 1.460s wall clock time. server # [699403.071105] server systemd[1]: Starting Mobilizon federated organization and mobilization platform... server # [699404.082448] server mobilizon_ctl[536]: Loading app.. server # [699404.084594] server mobilizon_ctl[536]: Starting dependencies.. server # [699407.393563] server mobilizon_ctl[536]: ######################################################### server # [699407.393563] server mobilizon_ctl[536]: # If the CREATE EXTENSION or DROP EXTENSION calls fail, # server # [699407.393563] server mobilizon_ctl[536]: # please manually execute them with an authorized # server # [699407.393563] server mobilizon_ctl[536]: # PostgreSQL user with SUPER USER role. # server # [699407.393563] server mobilizon_ctl[536]: ######################################################### server # [699407.393563] server mobilizon_ctl[536]: server # [699407.393563] server mobilizon_ctl[536]: server # [699407.393563] server mobilizon_ctl[536]: 16:50:22.110 [info] == Running 20180109150000 Mobilizon.Repo.Migrations.Prerequites.up/0 forward server # [699407.395099] server mobilizon_ctl[536]: 16:50:22.116 [info] execute "CREATE TYPE datetimetz AS (\n dt timestamptz,\n tz varchar\n);\n" server # [699407.396521] server mobilizon_ctl[536]: 16:50:22.117 [info] execute "CREATE EXTENSION IF NOT EXISTS postgis" server # [699407.397031] server mobilizon_ctl[536]: 16:50:22.118 [info] extension "postgis" already exists, skipping server # [699407.397259] server mobilizon_ctl[536]: 16:50:22.118 [info] execute "CREATE EXTENSION IF NOT EXISTS pg_trgm" server # [699407.397704] server mobilizon_ctl[536]: 16:50:22.118 [info] extension "pg_trgm" already exists, skipping server # [699407.397704] server mobilizon_ctl[536]: 16:50:22.118 [info] execute "CREATE EXTENSION IF NOT EXISTS unaccent" server # [699407.397704] server mobilizon_ctl[536]: 16:50:22.118 [info] extension "unaccent" already exists, skipping server # [699407.399487] server mobilizon_ctl[536]: 16:50:22.120 [info] == Migrated 20180109150000 in 0.0s server # [699407.443089] server mobilizon_ctl[536]: 16:50:22.164 [info] == Running 20180109165738 Mobilizon.Repo.Migrations.CreateAccounts.change/0 forward server # [699407.443613] server mobilizon_ctl[536]: 16:50:22.164 [info] create table accounts server # [699407.447970] server mobilizon_ctl[536]: 16:50:22.169 [info] create index accounts_username_domain_index server # [699407.449638] server mobilizon_ctl[536]: 16:50:22.170 [info] == Migrated 20180109165738 in 0.0s server # [699407.458510] server mobilizon_ctl[536]: 16:50:22.179 [info] == Running 20180109170315 Mobilizon.Repo.Migrations.CreateUsers.change/0 forward server # [699407.458947] server mobilizon_ctl[536]: 16:50:22.180 [info] create table users server # [699407.463301] server mobilizon_ctl[536]: 16:50:22.184 [info] create index users_email_index server # [699407.464482] server mobilizon_ctl[536]: 16:50:22.185 [info] == Migrated 20180109170315 in 0.0s server # [699407.469550] server mobilizon_ctl[536]: 16:50:22.190 [info] == Running 20180110091747 Mobilizon.Repo.Migrations.CreateCategories.change/0 forward server # [699407.469908] server mobilizon_ctl[536]: 16:50:22.190 [info] create table categories server # [699407.472838] server mobilizon_ctl[536]: 16:50:22.194 [info] create index categories_title_index server # [699407.473921] server mobilizon_ctl[536]: 16:50:22.194 [info] == Migrated 20180110091747 in 0.0s server # [699407.480122] server mobilizon_ctl[536]: 16:50:22.201 [info] == Running 20180110092400 Mobilizon.Repo.Migrations.CreateAddresses.change/0 forward server # [699407.480403] server mobilizon_ctl[536]: 16:50:22.201 [info] create table addresses server # [699407.483936] server mobilizon_ctl[536]: 16:50:22.204 [info] == Migrated 20180110092400 in 0.0s server # [699407.492109] server mobilizon_ctl[536]: 16:50:22.213 [info] == Running 20180110092500 Mobilizon.Repo.Migrations.CreateGroups.change/0 forward server # [699407.493273] server mobilizon_ctl[536]: 16:50:22.213 [info] create table groups server # [699407.497405] server mobilizon_ctl[536]: 16:50:22.218 [info] create index groups_slug_index server # [699407.498510] server mobilizon_ctl[536]: 16:50:22.219 [info] == Migrated 20180110092500 in 0.0s server # [699407.504345] server mobilizon_ctl[536]: 16:50:22.225 [info] == Running 20180110092600 Mobilizon.Repo.Migrations.CreateEvents.change/0 forward server # [699407.504718] server mobilizon_ctl[536]: 16:50:22.225 [info] create table events server # [699407.511098] server mobilizon_ctl[536]: 16:50:22.232 [info] create index events_organizer_account_id_index server # [699407.512271] server mobilizon_ctl[536]: 16:50:22.233 [info] create index events_organizer_group_id_index server # [699407.513192] server mobilizon_ctl[536]: 16:50:22.234 [info] create index events_slug_index server # [699407.513911] server mobilizon_ctl[536]: 16:50:22.235 [info] == Migrated 20180110092600 in 0.0s server # [699407.521585] server mobilizon_ctl[536]: 16:50:22.242 [info] == Running 20180110093905 Mobilizon.Repo.Migrations.CreateTags.change/0 forward server # [699407.521879] server mobilizon_ctl[536]: 16:50:22.243 [info] create table tags server # [699407.525726] server mobilizon_ctl[536]: 16:50:22.246 [info] create index tags_slug_index server # [699407.526192] server mobilizon_ctl[536]: 16:50:22.247 [info] == Migrated 20180110093905 in 0.0s server # [699407.533915] server mobilizon_ctl[536]: 16:50:22.255 [info] == Running 20180110093906 Mobilizon.Repo.Migrations.CreateEventsTags.change/0 forward server # [699407.534212] server mobilizon_ctl[536]: 16:50:22.255 [info] create table events_tags server # [699407.536496] server mobilizon_ctl[536]: 16:50:22.257 [info] == Migrated 20180110093906 in 0.0s server # [699407.543752] server mobilizon_ctl[536]: 16:50:22.264 [info] == Running 20180110094301 Mobilizon.Repo.Migrations.CreateParticipants.change/0 forward server # [699407.544148] server mobilizon_ctl[536]: 16:50:22.265 [info] create table participants server # [699407.547327] server mobilizon_ctl[536]: 16:50:22.268 [info] create index participants_event_id_index server # [699407.548265] server mobilizon_ctl[536]: 16:50:22.269 [info] create index participants_account_id_index server # [699407.549242] server mobilizon_ctl[536]: 16:50:22.270 [info] == Migrated 20180110094301 in 0.0s server # [699407.560369] server mobilizon_ctl[536]: 16:50:22.281 [info] == Running 20180110094502 Mobilizon.Repo.Migrations.CreateEventRequests.change/0 forward server # [699407.560931] server mobilizon_ctl[536]: 16:50:22.281 [info] create table event_requests server # [699407.563890] server mobilizon_ctl[536]: 16:50:22.284 [info] create index event_requests_event_id_index server # [699407.564424] server mobilizon_ctl[536]: 16:50:22.285 [info] create index event_requests_account_id_index server # [699407.566203] server mobilizon_ctl[536]: 16:50:22.287 [info] == Migrated 20180110094502 in 0.0s server # [699407.573470] server mobilizon_ctl[536]: 16:50:22.294 [info] == Running 20180110095317 Mobilizon.Repo.Migrations.CreateMembers.change/0 forward server # [699407.573915] server mobilizon_ctl[536]: 16:50:22.295 [info] create table members server # [699407.575926] server mobilizon_ctl[536]: 16:50:22.297 [info] create index members_group_id_index server # [699407.576896] server mobilizon_ctl[536]: 16:50:22.298 [info] create index members_account_id_index server # [699407.577727] server mobilizon_ctl[536]: 16:50:22.298 [info] == Migrated 20180110095317 in 0.0s server # [699407.583555] server mobilizon_ctl[536]: 16:50:22.304 [info] == Running 20180110095515 Mobilizon.Repo.Migrations.CreateGroupRequests.change/0 forward server # [699407.584048] server mobilizon_ctl[536]: 16:50:22.305 [info] create table group_requests server # [699407.586840] server mobilizon_ctl[536]: 16:50:22.308 [info] create index group_requests_group_id_index server # [699407.587731] server mobilizon_ctl[536]: 16:50:22.308 [info] create index group_requests_account_id_index server # [699407.588782] server mobilizon_ctl[536]: 16:50:22.309 [info] == Migrated 20180110095515 in 0.0s server # [699407.592969] server mobilizon_ctl[536]: 16:50:22.314 [info] == Running 20180110165029 Mobilizon.Repo.Migrations.Guardian.DB.change/0 forward server # [699407.593148] server mobilizon_ctl[536]: 16:50:22.314 [info] create table guardian_tokens server # [699407.595719] server mobilizon_ctl[536]: 16:50:22.316 [info] == Migrated 20180110165029 in 0.0s server # [699407.601810] server mobilizon_ctl[536]: 16:50:22.322 [info] == Running 20180112100000 Mobilizon.Repo.Migrations.CreateTracks.change/0 forward server # [699407.602174] server mobilizon_ctl[536]: 16:50:22.323 [info] create table tracks server # [699407.605090] server mobilizon_ctl[536]: 16:50:22.326 [info] == Migrated 20180112100000 in 0.0s server # [699407.610192] server mobilizon_ctl[536]: 16:50:22.331 [info] == Running 20180112105354 Mobilizon.Repo.Migrations.CreateSessions.change/0 forward server # [699407.610646] server mobilizon_ctl[536]: 16:50:22.331 [info] create table sessions server # [699407.614413] server mobilizon_ctl[536]: 16:50:22.335 [info] == Migrated 20180112105354 in 0.0s server # [699407.623265] server mobilizon_ctl[536]: 16:50:22.344 [info] == Running 20180430071244 Mobilizon.Repo.Migrations.RemoveUri.up/0 forward server # [699407.623619] server mobilizon_ctl[536]: 16:50:22.344 [info] alter table accounts server # [699407.624732] server mobilizon_ctl[536]: 16:50:22.345 [info] alter table groups server # [699407.625465] server mobilizon_ctl[536]: 16:50:22.346 [info] == Migrated 20180430071244 in 0.0s server # [699407.631417] server mobilizon_ctl[536]: 16:50:22.352 [info] == Running 20180515091106 Mobilizon.Repo.Migrations.AddUrlFieldToEvents.up/0 forward server # [699407.631720] server mobilizon_ctl[536]: 16:50:22.352 [info] alter table events server # [699407.632750] server mobilizon_ctl[536]: 16:50:22.353 [info] == Migrated 20180515091106 in 0.0s server # [699407.635645] server mobilizon_ctl[536]: 16:50:22.356 [info] == Running 20180515100237 Mobilizon.Repo.Migrations.CreateComments.change/0 forward server # [699407.635933] server mobilizon_ctl[536]: 16:50:22.357 [info] create table comments server # [699407.640748] server mobilizon_ctl[536]: 16:50:22.361 [info] == Migrated 20180515100237 in 0.0s server # [699407.648119] server mobilizon_ctl[536]: 16:50:22.369 [info] == Running 20180515142835 Mobilizon.Repo.Migrations.AlterEventTimestampsToDateTimeWithTimeZone.up/0 forward server # [699407.649191] server mobilizon_ctl[536]: 16:50:22.370 [info] alter table events server # [699407.650352] server mobilizon_ctl[536]: 16:50:22.371 [info] == Migrated 20180515142835 in 0.0s server # [699407.656696] server mobilizon_ctl[536]: 16:50:22.377 [info] == Running 20180515145438 Mobilizon.Repo.Migrations.AddLocalAttributeToEventsAndComments.up/0 forward server # [699407.656920] server mobilizon_ctl[536]: 16:50:22.378 [info] alter table events server # [699407.657766] server mobilizon_ctl[536]: 16:50:22.378 [info] alter table comments server # [699407.658624] server mobilizon_ctl[536]: 16:50:22.379 [info] == Migrated 20180515145438 in 0.0s server # [699407.664377] server mobilizon_ctl[536]: 16:50:22.385 [info] == Running 20180517100700 Mobilizon.Repo.Migrations.MoveFromAccountToActor.up/0 forward server # [699407.667366] server mobilizon_ctl[536]: 16:50:22.388 [info] drop table event_requests server # [699407.669552] server mobilizon_ctl[536]: 16:50:22.390 [info] drop table group_requests server # [699407.670743] server mobilizon_ctl[536]: 16:50:22.391 [info] alter table events server # [699407.671842] server mobilizon_ctl[536]: 16:50:22.393 [info] rename column account_id to actor_id on table members server # [699407.672265] server mobilizon_ctl[536]: 16:50:22.393 [info] alter table members server # [699407.674284] server mobilizon_ctl[536]: 16:50:22.395 [info] drop table groups server # [699407.675644] server mobilizon_ctl[536]: 16:50:22.396 [info] rename table accounts to actors server # [699407.675981] server mobilizon_ctl[536]: 16:50:22.397 [info] execute "CREATE TYPE public.actor_type AS ENUM ('Person', 'Application', 'Group', 'Organization', 'Service')" server # [699407.677047] server mobilizon_ctl[536]: 16:50:22.398 [info] rename column username to name on table actors server # [699407.678301] server mobilizon_ctl[536]: 16:50:22.399 [info] rename column description to summary on table actors server # [699407.678923] server mobilizon_ctl[536]: 16:50:22.400 [info] rename column display_name to preferred_username on table actors server # [699407.679467] server mobilizon_ctl[536]: 16:50:22.400 [info] alter table actors server # [699407.682451] server mobilizon_ctl[536]: 16:50:22.403 [info] create index actors_preferred_username_domain_index server # [699407.683691] server mobilizon_ctl[536]: 16:50:22.404 [info] rename column organizer_account_id to organizer_actor_id on table events server # [699407.684108] server mobilizon_ctl[536]: 16:50:22.405 [info] rename column account_id to actor_id on table participants server # [699407.684961] server mobilizon_ctl[536]: 16:50:22.405 [info] create table followers server # [699407.689426] server mobilizon_ctl[536]: 16:50:22.410 [info] rename column account_id to actor_id on table comments server # [699407.690157] server mobilizon_ctl[536]: 16:50:22.411 [info] rename column account_id to actor_id on table users server # [699407.690860] server mobilizon_ctl[536]: 16:50:22.411 [info] == Migrated 20180517100700 in 0.0s server # [699407.700777] server mobilizon_ctl[536]: 16:50:22.421 [info] == Running 20180522133844 Mobilizon.Repo.Migrations.AddBotsTable.up/0 forward server # [699407.700964] server mobilizon_ctl[536]: 16:50:22.422 [info] create table bots server # [699407.705845] server mobilizon_ctl[536]: 16:50:22.426 [info] == Migrated 20180522133844 in 0.0s server # [699407.714721] server mobilizon_ctl[536]: 16:50:22.435 [info] == Running 20180530125159 Mobilizon.Repo.Migrations.AddAvatarAndBannerToActor.up/0 forward server # [699407.714894] server mobilizon_ctl[536]: 16:50:22.435 [info] alter table actors server # [699407.716273] server mobilizon_ctl[536]: 16:50:22.437 [info] == Migrated 20180530125159 in 0.0s server # [699407.719502] server mobilizon_ctl[536]: 16:50:22.440 [info] == Running 20180530152323 Mobilizon.Repo.Migrations.MakeActorPublicKeyNullable.up/0 forward server # [699407.719624] server mobilizon_ctl[536]: 16:50:22.440 [info] alter table actors server # [699407.721099] server mobilizon_ctl[536]: 16:50:22.442 [info] == Migrated 20180530152323 in 0.0s server # [699407.727653] server mobilizon_ctl[536]: 16:50:22.448 [info] == Running 20180530170808 Mobilizon.Repo.Migrations.AddUUIDIdToEvents.up/0 forward server # [699407.727653] server mobilizon_ctl[536]: 16:50:22.448 [info] alter table events server # [699407.728815] server mobilizon_ctl[536]: 16:50:22.449 [info] == Migrated 20180530170808 in 0.0s server # [699407.732223] server mobilizon_ctl[536]: 16:50:22.453 [info] == Running 20180531162301 Mobilizon.Repo.Migrations.AddApprovedStatusToMember.up/0 forward server # [699407.732436] server mobilizon_ctl[536]: 16:50:22.453 [info] alter table members server # [699407.733479] server mobilizon_ctl[536]: 16:50:22.454 [info] == Migrated 20180531162301 in 0.0s server # [699407.738666] server mobilizon_ctl[536]: 16:50:22.459 [info] == Running 20180607095732 Mobilizon.Repo.Migrations.AddUUIDToComments.up/0 forward server # [699407.738879] server mobilizon_ctl[536]: 16:50:22.460 [info] alter table comments server # [699407.739645] server mobilizon_ctl[536]: 16:50:22.460 [info] == Migrated 20180607095732 in 0.0s server # [699407.745754] server mobilizon_ctl[536]: 16:50:22.466 [info] == Running 20180614094653 Mobilizon.Repo.Migrations.MakeSharedInboxUrlNullable.up/0 forward server # [699407.745963] server mobilizon_ctl[536]: 16:50:22.467 [info] alter table actors server # [699407.747765] server mobilizon_ctl[536]: 16:50:22.468 [info] == Migrated 20180614094653 in 0.0s server # [699407.754187] server mobilizon_ctl[536]: 16:50:22.475 [info] == Running 20180614104618 Mobilizon.Repo.Migrations.FusionPublicPrivateKeyIntoKeysColumn.up/0 forward server # [699407.754349] server mobilizon_ctl[536]: 16:50:22.475 [info] rename column private_key to keys on table actors server # [699407.754859] server mobilizon_ctl[536]: 16:50:22.476 [info] alter table actors server # [699407.755689] server mobilizon_ctl[536]: 16:50:22.476 [info] == Migrated 20180614104618 in 0.0s server # [699407.760975] server mobilizon_ctl[536]: 16:50:22.482 [info] == Running 20180614131328 Mobilizon.Repo.Migrations.AddAttributedToFieldToEventsAndComments.up/0 forward server # [699407.761280] server mobilizon_ctl[536]: 16:50:22.482 [info] alter table events server # [699407.763349] server mobilizon_ctl[536]: 16:50:22.484 [info] alter table comments server # [699407.765137] server mobilizon_ctl[536]: 16:50:22.486 [info] == Migrated 20180614131328 in 0.0s server # [699407.771708] server mobilizon_ctl[536]: 16:50:22.492 [info] == Running 20180628091920 :"Elixir.Mobilizon.Repo.Migrations.Add-user-confirm-email-fields".up/0 forward server # [699407.772054] server mobilizon_ctl[536]: 16:50:22.493 [info] alter table users server # [699407.773039] server mobilizon_ctl[536]: 16:50:22.494 [info] create index index_unique_users_confirmation_token server # [699407.774691] server mobilizon_ctl[536]: 16:50:22.495 [info] == Migrated 20180628091920 in 0.0s server # [699407.779116] server mobilizon_ctl[536]: 16:50:22.500 [info] == Running 20180628130746 :"Elixir.Mobilizon.Repo.Migrations.Add-user-password-reset-fields".up/0 forward server # [699407.779259] server mobilizon_ctl[536]: 16:50:22.500 [info] alter table users server # [699407.779959] server mobilizon_ctl[536]: 16:50:22.501 [info] create index index_unique_users_reset_password_token server # [699407.781504] server mobilizon_ctl[536]: 16:50:22.502 [info] == Migrated 20180628130746 in 0.0s server # [699407.788257] server mobilizon_ctl[536]: 16:50:22.509 [info] == Running 20180628142835 Mobilizon.Repo.Migrations.RevertAlterEventTimestampsToDateTimeWithTimeZone.up/0 forward server # [699407.788387] server mobilizon_ctl[536]: 16:50:22.509 [info] alter table events server # [699407.789920] server mobilizon_ctl[536]: 16:50:22.510 [info] == Migrated 20180628142835 in 0.0s server # [699407.796120] server mobilizon_ctl[536]: 16:50:22.517 [info] == Running 20180702150922 Mobilizon.Repo.Migrations.AddAddressType.up/0 forward server # [699407.796234] server mobilizon_ctl[536]: 16:50:22.517 [info] alter table events server # [699407.797398] server mobilizon_ctl[536]: 16:50:22.518 [info] drop constraint events_address_id_fkey from table events server # [699407.798141] server mobilizon_ctl[536]: 16:50:22.519 [info] rename column address_id to physical_address_id on table events server # [699407.798359] server mobilizon_ctl[536]: 16:50:22.519 [info] alter table events server # [699407.799713] server mobilizon_ctl[536]: 16:50:22.520 [info] == Migrated 20180702150922 in 0.0s server # [699407.806064] server mobilizon_ctl[536]: 16:50:22.527 [info] == Running 20180702154630 Mobilizon.Repo.Migrations.RemoveSlugForEvent.up/0 forward server # [699407.806208] server mobilizon_ctl[536]: 16:50:22.527 [info] alter table events server # [699407.807277] server mobilizon_ctl[536]: 16:50:22.528 [info] == Migrated 20180702154630 in 0.0s server # [699407.813673] server mobilizon_ctl[536]: 16:50:22.534 [info] == Running 20180706082208 Mobilizon.Repo.Migrations.AlterEventsSetDescriptionAsText.up/0 forward server # [699407.814661] server mobilizon_ctl[536]: 16:50:22.535 [info] alter table events server # [699407.816079] server mobilizon_ctl[536]: 16:50:22.536 [info] == Migrated 20180706082208 in 0.0s server # [699407.825051] server mobilizon_ctl[536]: 16:50:22.545 [info] == Running 20180709154152 Mobilizon.Repo.Migrations.AllowMultipleAccountsForUser.up/0 forward server # [699407.825710] server mobilizon_ctl[536]: 16:50:22.546 [info] alter table actors server # [699407.827418] server mobilizon_ctl[536]: 16:50:22.548 [info] alter table users server # [699407.828658] server mobilizon_ctl[536]: 16:50:22.549 [info] == Migrated 20180709154152 in 0.0s server # [699407.836175] server mobilizon_ctl[536]: 16:50:22.557 [info] == Running 20180802133951 Mobilizon.Repo.Migrations.MakeFollowerTableUnique.up/0 forward server # [699407.836596] server mobilizon_ctl[536]: 16:50:22.557 [info] create index followers_actor_target_actor_unique_index server # [699407.838856] server mobilizon_ctl[536]: 16:50:22.559 [info] == Migrated 20180802133951 in 0.0s server # [699407.844416] server mobilizon_ctl[536]: 16:50:22.565 [info] == Running 20180816093446 Mobilizon.Repo.Migrations.AddPrimaryKeyToMember.up/0 forward server # [699407.844693] server mobilizon_ctl[536]: 16:50:22.565 [info] execute "ALTER TABLE members DROP CONSTRAINT IF EXISTS members_pkey" server # [699407.845428] server mobilizon_ctl[536]: 16:50:22.566 [info] constraint "members_pkey" of relation "members" does not exist, skipping server # [699407.845480] server mobilizon_ctl[536]: 16:50:22.566 [info] drop index if exists members_members_account_id_index_index server # [699407.845971] server mobilizon_ctl[536]: 16:50:22.567 [info] index "members_members_account_id_index_index" does not exist, skipping server # [699407.846021] server mobilizon_ctl[536]: 16:50:22.567 [info] create index members_actor_parent_unique_index server # [699407.847116] server mobilizon_ctl[536]: 16:50:22.568 [info] alter table members server # [699407.850472] server mobilizon_ctl[536]: 16:50:22.571 [info] == Migrated 20180816093446 in 0.0s server # [699407.856808] server mobilizon_ctl[536]: 16:50:22.577 [info] == Running 20181021161324 Mobilizon.Repo.Migrations.AddDefaultActorUserField.up/0 forward server # [699407.856955] server mobilizon_ctl[536]: 16:50:22.578 [info] alter table users server # [699407.858025] server mobilizon_ctl[536]: 16:50:22.579 [info] == Migrated 20181021161324 in 0.0s server # [699407.864885] server mobilizon_ctl[536]: 16:50:22.585 [info] == Running 20181108165151 Mobilizon.Repo.Migrations.FixCommentsReferences.up/0 forward server # [699407.865131] server mobilizon_ctl[536]: 16:50:22.586 [info] drop constraint comments_in_reply_to_comment_id_fkey from table comments server # [699407.865951] server mobilizon_ctl[536]: 16:50:22.587 [info] drop constraint comments_origin_comment_id_fkey from table comments server # [699407.866745] server mobilizon_ctl[536]: 16:50:22.587 [info] alter table comments server # [699407.869104] server mobilizon_ctl[536]: 16:50:22.589 [info] == Migrated 20181108165151 in 0.0s server # [699407.876282] server mobilizon_ctl[536]: 16:50:22.597 [info] == Running 20181203092128 Mobilizon.Repo.Migrations.ChangeActorsIndexes.up/0 forward server # [699407.876754] server mobilizon_ctl[536]: 16:50:22.597 [info] drop index actors_preferred_username_domain_index server # [699407.877608] server mobilizon_ctl[536]: 16:50:22.598 [info] drop index accounts_username_domain_index server # [699407.878444] server mobilizon_ctl[536]: 16:50:22.599 [info] execute "ALTER INDEX accounts_pkey RENAME TO actors_pkey" server # [699407.878939] server mobilizon_ctl[536]: 16:50:22.600 [info] create index actors_preferred_username_domain_type_index server # [699407.880264] server mobilizon_ctl[536]: 16:50:22.601 [info] create index actors_url_index server # [699407.881791] server mobilizon_ctl[536]: 16:50:22.602 [info] == Migrated 20181203092128 in 0.0s server # [699407.890471] server mobilizon_ctl[536]: 16:50:22.611 [info] == Running 20190103150805 Mobilizon.Repo.Migrations.FixEventVisibility.up/0 forward server # [699407.890641] server mobilizon_ctl[536]: 16:50:22.611 [info] execute "CREATE TYPE public.event_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')" server # [699407.891268] server mobilizon_ctl[536]: 16:50:22.612 [info] execute "CREATE TYPE public.event_status AS ENUM ('tentative', 'confirmed', 'cancelled')" server # [699407.892870] server mobilizon_ctl[536]: 16:50:22.613 [info] execute "CREATE TYPE public.comment_visibility AS ENUM ('public', 'unlisted', 'private', 'moderated', 'invite')" server # [699407.893392] server mobilizon_ctl[536]: 16:50:22.614 [info] alter table events server # [699407.894962] server mobilizon_ctl[536]: 16:50:22.616 [info] alter table comments server # [699407.895640] server mobilizon_ctl[536]: 16:50:22.616 [info] == Migrated 20190103150805 in 0.0s server # [699407.900076] server mobilizon_ctl[536]: 16:50:22.621 [info] == Running 20190114162055 Mobilizon.Repo.Migrations.RemoveAddressType.up/0 forward server # [699407.900194] server mobilizon_ctl[536]: 16:50:22.621 [info] execute "ALTER TABLE \"events\" DROP COLUMN IF EXISTS address_type" server # [699407.901402] server mobilizon_ctl[536]: 16:50:22.622 [info] column "address_type" of relation "events" does not exist, skipping server # [699407.902590] server mobilizon_ctl[536]: 16:50:22.622 [info] execute "DROP TYPE IF EXISTS address_type" server # [699407.902590] server mobilizon_ctl[536]: 16:50:22.623 [info] type "address_type" does not exist, skipping server # [699407.902879] server mobilizon_ctl[536]: 16:50:22.623 [info] rename column phone to phone_address on table events server # [699407.903497] server mobilizon_ctl[536]: 16:50:22.624 [info] == Migrated 20190114162055 in 0.0s server # [699407.908883] server mobilizon_ctl[536]: 16:50:22.630 [info] == Running 20190125143718 Mobilizon.Repo.Migrations.GroupDeleteMembersCascade.change/0 forward server # [699407.909081] server mobilizon_ctl[536]: 16:50:22.630 [info] drop constraint members_account_id_fkey from table members server # [699407.910067] server mobilizon_ctl[536]: 16:50:22.631 [info] drop constraint members_parent_id_fkey from table members server # [699407.911001] server mobilizon_ctl[536]: 16:50:22.632 [info] alter table members server # [699407.914258] server mobilizon_ctl[536]: 16:50:22.635 [info] == Migrated 20190125143718 in 0.0s server # [699407.920847] server mobilizon_ctl[536]: 16:50:22.642 [info] == Running 20190130151607 Mobilizon.Repo.Migrations.SplitEventVisibilityAndJoinOptions.up/0 forward server # [699407.920973] server mobilizon_ctl[536]: 16:50:22.642 [info] execute "ALTER TABLE events ALTER COLUMN visibility TYPE VARCHAR USING visibility::text" server # [699407.924636] server mobilizon_ctl[536]: 16:50:22.645 [info] execute "DROP TYPE public.event_visibility" server # [699407.925125] server mobilizon_ctl[536]: 16:50:22.646 [info] execute "CREATE TYPE public.event_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')" server # [699407.926202] server mobilizon_ctl[536]: 16:50:22.647 [info] execute "ALTER TABLE events ALTER COLUMN visibility TYPE event_visibility USING visibility::event_visibility" server # [699407.929129] server mobilizon_ctl[536]: 16:50:22.650 [info] execute "CREATE TYPE public.join_options AS ENUM ('free', 'restricted', 'invite', 'external')" server # [699407.929884] server mobilizon_ctl[536]: 16:50:22.650 [info] alter table events server # [699407.930761] server mobilizon_ctl[536]: 16:50:22.651 [info] execute "UPDATE events SET visibility = 'public' WHERE visibility IS NULL" server # [699407.931493] server mobilizon_ctl[536]: 16:50:22.652 [info] alter table events server # [699407.932308] server mobilizon_ctl[536]: 16:50:22.653 [info] == Migrated 20190130151607 in 0.0s server # [699407.940851] server mobilizon_ctl[536]: 16:50:22.661 [info] == Running 20190207134142 Mobilizon.Repo.Migrations.MoveParticipantRoleToEnum.up/0 forward server # [699407.941019] server mobilizon_ctl[536]: 16:50:22.662 [info] execute "CREATE TYPE public.participant_role AS ENUM ('not_approved', 'not_confirmed', 'rejected', 'participant', 'moderator', 'administrator', 'creator')" server # [699407.942330] server mobilizon_ctl[536]: 16:50:22.663 [info] alter table participants server # [699407.943738] server mobilizon_ctl[536]: 16:50:22.664 [info] execute "UPDATE participants set role_tmp = 'not_approved' where role = 0" server # [699407.944909] server mobilizon_ctl[536]: 16:50:22.666 [info] execute "UPDATE participants set role_tmp = 'participant' where role = 1" server # [699407.945444] server mobilizon_ctl[536]: 16:50:22.666 [info] execute "UPDATE participants set role_tmp = 'moderator' where role = 2" server # [699407.945783] server mobilizon_ctl[536]: 16:50:22.667 [info] execute "UPDATE participants set role_tmp = 'administrator' where role = 3" server # [699407.946241] server mobilizon_ctl[536]: 16:50:22.667 [info] execute "UPDATE participants set role_tmp = 'creator' where role = 4" server # [699407.946894] server mobilizon_ctl[536]: 16:50:22.668 [info] alter table participants server # [699407.947548] server mobilizon_ctl[536]: 16:50:22.668 [info] rename column role_tmp to role on table participants server # [699407.947998] server mobilizon_ctl[536]: 16:50:22.669 [info] == Migrated 20190207134142 in 0.0s server # [699407.958594] server mobilizon_ctl[536]: 16:50:22.679 [info] == Running 20190208141700 Mobilizon.Repo.Migrations.TagsRelations.up/0 forward server # [699407.958870] server mobilizon_ctl[536]: 16:50:22.680 [info] create table tag_relations server # [699407.961277] server mobilizon_ctl[536]: 16:50:22.682 [info] create check constraint no_self_loops_check on table tag_relations server # [699407.961949] server mobilizon_ctl[536]: 16:50:22.683 [info] create index index_tag_relations_tag_id server # [699407.963042] server mobilizon_ctl[536]: 16:50:22.684 [info] create index index_tag_relations_link_id server # [699407.964484] server mobilizon_ctl[536]: 16:50:22.685 [info] == Migrated 20190208141700 in 0.0s server # [699407.973790] server mobilizon_ctl[536]: 16:50:22.694 [info] == Running 20190214100858 Mobilizon.Repo.Migrations.DropDatetimetz.up/0 forward server # [699407.973974] server mobilizon_ctl[536]: 16:50:22.695 [info] alter table events server # [699407.975126] server mobilizon_ctl[536]: 16:50:22.696 [info] alter table sessions server # [699407.975809] server mobilizon_ctl[536]: 16:50:22.697 [info] execute "DROP TYPE datetimetz" server # [699407.976649] server mobilizon_ctl[536]: 16:50:22.697 [info] == Migrated 20190214100858 in 0.0s server # [699407.981987] server mobilizon_ctl[536]: ######################################################### server # [699407.981987] server mobilizon_ctl[536]: # If the CREATE EXTENSION or DROP EXTENSION calls fail, # server # [699407.981987] server mobilizon_ctl[536]: # please manually execute them with an authorized # server # [699407.981987] server mobilizon_ctl[536]: # PostgreSQL user with SUPER USER role. # server # [699407.981987] server mobilizon_ctl[536]: ######################################################### server # [699407.981987] server mobilizon_ctl[536]: server # [699407.981987] server mobilizon_ctl[536]: server # [699407.982286] server mobilizon_ctl[536]: 16:50:22.703 [info] == Running 20190219164310 Mobilizon.Repo.Migrations.CreateSearchIndexes.change/0 forward server # [699407.982493] server mobilizon_ctl[536]: 16:50:22.703 [info] execute "CREATE EXTENSION IF NOT EXISTS pg_trgm" server # [699407.983074] server mobilizon_ctl[536]: 16:50:22.704 [info] extension "pg_trgm" already exists, skipping server # [699407.983155] server mobilizon_ctl[536]: 16:50:22.704 [info] execute "CREATE EXTENSION IF NOT EXISTS unaccent" server # [699407.983527] server mobilizon_ctl[536]: 16:50:22.704 [info] extension "unaccent" already exists, skipping server # [699407.983693] server mobilizon_ctl[536]: 16:50:22.704 [info] execute "CREATE OR REPLACE FUNCTION public.f_unaccent(text)\n RETURNS text AS\n$func$\nSELECT public.unaccent('public.unaccent', $1)\n$func$ LANGUAGE sql IMMUTABLE;" server # [699407.984413] server mobilizon_ctl[536]: 16:50:22.705 [info] execute "CREATE INDEX \"event_title_trigram\" ON \"events\" USING GIN (f_unaccent(title) gin_trgm_ops)" server # [699407.986411] server mobilizon_ctl[536]: 16:50:22.707 [info] execute "CREATE INDEX \"actor_preferred_username_trigram\" ON \"actors\"\n USING GIN (f_unaccent(preferred_username) gin_trgm_ops)" server # [699407.987471] server mobilizon_ctl[536]: 16:50:22.708 [info] execute "CREATE INDEX \"actor_name_trigram\" ON \"actors\"\n USING GIN (f_unaccent(name) gin_trgm_ops)" server # [699407.988532] server mobilizon_ctl[536]: 16:50:22.709 [info] == Migrated 20190219164310 in 0.0s server # [699407.996678] server mobilizon_ctl[536]: 16:50:22.717 [info] == Running 20190222151449 Mobilizon.Repo.Migrations.DropCategories.up/0 forward server # [699407.996953] server mobilizon_ctl[536]: 16:50:22.718 [info] alter table events server # [699407.998053] server mobilizon_ctl[536]: 16:50:22.719 [info] drop table categories server # [699407.999968] server mobilizon_ctl[536]: 16:50:22.720 [info] == Migrated 20190222151449 in 0.0s server # [699408.015379] server mobilizon_ctl[536]: 16:50:22.736 [info] == Running 20190301141830 Mobilizon.Repo.Migrations.MoveMemberRoleToEnum.up/0 forward server # [699408.015558] server mobilizon_ctl[536]: 16:50:22.736 [info] execute "CREATE TYPE public.member_role AS ENUM ('invited', 'not_approved', 'member', 'moderator', 'administrator', 'creator', 'rejected')" server # [699408.016305] server mobilizon_ctl[536]: 16:50:22.737 [info] alter table members server # [699408.017378] server mobilizon_ctl[536]: 16:50:22.738 [info] execute "UPDATE members set role_tmp = 'member' where role = 0" server # [699408.018692] server mobilizon_ctl[536]: 16:50:22.739 [info] execute "UPDATE members set role_tmp = 'moderator' where role = 1" server # [699408.019253] server mobilizon_ctl[536]: 16:50:22.740 [info] execute "UPDATE members set role_tmp = 'creator' where role = 2" server # [699408.019776] server mobilizon_ctl[536]: 16:50:22.740 [info] execute "UPDATE members set role_tmp = 'not_approved' where approved is false" server # [699408.020488] server mobilizon_ctl[536]: 16:50:22.741 [info] alter table members server # [699408.021203] server mobilizon_ctl[536]: 16:50:22.742 [info] rename column role_tmp to role on table members server # [699408.021691] server mobilizon_ctl[536]: 16:50:22.742 [info] == Migrated 20190301141830 in 0.0s server # [699408.027823] server mobilizon_ctl[536]: 16:50:22.748 [info] == Running 20190301143831 Mobilizon.Repo.Migrations.ActorGroupOpenness.up/0 forward server # [699408.030734] server mobilizon_ctl[536]: 16:50:22.751 [info] execute "CREATE TYPE public.actor_openness AS ENUM ('invite_only', 'moderated', 'open')" server # [699408.031273] server mobilizon_ctl[536]: 16:50:22.752 [info] alter table actors server # [699408.032580] server mobilizon_ctl[536]: 16:50:22.753 [info] == Migrated 20190301143831 in 0.0s server # [699408.040048] server mobilizon_ctl[536]: 16:50:22.761 [info] == Running 20190307125009 Mobilizon.Repo.Migrations.MoveUserRoleToEnum.up/0 forward server # [699408.040437] server mobilizon_ctl[536]: 16:50:22.761 [info] execute "CREATE TYPE public.user_role AS ENUM ('administrator', 'moderator', 'user', 'pending')" server # [699408.040966] server mobilizon_ctl[536]: 16:50:22.762 [info] alter table users server # [699408.041735] server mobilizon_ctl[536]: 16:50:22.762 [info] execute "UPDATE users set role_tmp = 'user' where role = 0" server # [699408.042499] server mobilizon_ctl[536]: 16:50:22.763 [info] execute "UPDATE users set role_tmp = 'moderator' where role = 1" server # [699408.042920] server mobilizon_ctl[536]: 16:50:22.764 [info] execute "UPDATE users set role_tmp = 'administrator' where role = 2" server # [699408.043339] server mobilizon_ctl[536]: 16:50:22.764 [info] alter table users server # [699408.043898] server mobilizon_ctl[536]: 16:50:22.765 [info] rename column role_tmp to role on table users server # [699408.044371] server mobilizon_ctl[536]: 16:50:22.765 [info] == Migrated 20190307125009 in 0.0s server # [699408.052687] server mobilizon_ctl[536]: 16:50:22.773 [info] == Running 20190307133518 Mobilizon.Repo.Migrations.FeedTokenTable.change/0 forward server # [699408.057101] server mobilizon_ctl[536]: 16:50:22.778 [info] create table feed_tokens server # [699408.060732] server mobilizon_ctl[536]: 16:50:22.781 [info] == Migrated 20190307133518 in 0.0s server # [699408.070701] server mobilizon_ctl[536]: 16:50:22.791 [info] == Running 20190322143724 Mobilizon.Repo.Migrations.RenameAddressFields.change/0 forward server # [699408.070976] server mobilizon_ctl[536]: 16:50:22.792 [info] rename column addressCountry to country on table addresses server # [699408.071405] server mobilizon_ctl[536]: 16:50:22.792 [info] rename column addressLocality to locality on table addresses server # [699408.071974] server mobilizon_ctl[536]: 16:50:22.793 [info] rename column addressRegion to region on table addresses server # [699408.072701] server mobilizon_ctl[536]: 16:50:22.793 [info] rename column postalCode to postal_code on table addresses server # [699408.072944] server mobilizon_ctl[536]: 16:50:22.794 [info] rename column streetAddress to street on table addresses server # [699408.073238] server mobilizon_ctl[536]: 16:50:22.794 [info] == Migrated 20190322143724 in 0.0s server # [699408.078584] server mobilizon_ctl[536]: 16:50:22.799 [info] == Running 20190411124138 Mobilizon.Repo.Migrations.EventAddDescriptionSlug.change/0 forward server # [699408.078768] server mobilizon_ctl[536]: 16:50:22.799 [info] alter table events server # [699408.080047] server mobilizon_ctl[536]: 16:50:22.800 [info] == Migrated 20190411124138 in 0.0s server # [699408.084428] server mobilizon_ctl[536]: 16:50:22.805 [info] == Running 20190411161557 Mobilizon.Repo.Migrations.EventEventTagOnDelete.up/0 forward server # [699408.084846] server mobilizon_ctl[536]: 16:50:22.805 [info] drop constraint events_tags_event_id_fkey from table events_tags server # [699408.086700] server mobilizon_ctl[536]: 16:50:22.807 [info] drop constraint events_tags_tag_id_fkey from table events_tags server # [699408.086794] server mobilizon_ctl[536]: 16:50:22.807 [info] alter table events_tags server # [699408.089979] server mobilizon_ctl[536]: 16:50:22.810 [info] == Migrated 20190411161557 in 0.0s server # [699408.098491] server mobilizon_ctl[536]: 16:50:22.819 [info] == Running 20190425075451 Mobilizon.Repo.Migrations.AddVisibilityToActor.up/0 forward server # [699408.098641] server mobilizon_ctl[536]: 16:50:22.819 [info] execute "CREATE TYPE public.actor_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')" server # [699408.099299] server mobilizon_ctl[536]: 16:50:22.820 [info] alter table actors server # [699408.100336] server mobilizon_ctl[536]: 16:50:22.821 [info] == Migrated 20190425075451 in 0.0s server # [699408.105909] server mobilizon_ctl[536]: 16:50:22.827 [info] == Running 20190426093202 Mobilizon.Repo.Migrations.CreatePictures.up/0 forward server # [699408.106279] server mobilizon_ctl[536]: 16:50:22.827 [info] create table pictures server # [699408.111130] server mobilizon_ctl[536]: 16:50:22.832 [info] alter table actors server # [699408.112177] server mobilizon_ctl[536]: 16:50:22.833 [info] alter table events server # [699408.114203] server mobilizon_ctl[536]: 16:50:22.835 [info] == Migrated 20190426093202 in 0.0s server # [699408.123387] server mobilizon_ctl[536]: 16:50:22.844 [info] == Running 20190531131458 :"Elixir.Mobilizon.Repo.Migrations.Attach-pictures-to-actors".change/0 forward server # [699408.123734] server mobilizon_ctl[536]: 16:50:22.844 [info] alter table pictures server # [699408.126401] server mobilizon_ctl[536]: 16:50:22.847 [info] == Migrated 20190531131458 in 0.0s server # [699408.132773] server mobilizon_ctl[536]: 16:50:22.853 [info] == Running 20190712125833 Mobilizon.Repo.Migrations.CreateReports.up/0 forward server # [699408.135557] server mobilizon_ctl[536]: 16:50:22.856 [info] execute "CREATE TYPE public.report_status AS ENUM ('open', 'closed', 'resolved')" server # [699408.136247] server mobilizon_ctl[536]: 16:50:22.857 [info] create table reports server # [699408.141288] server mobilizon_ctl[536]: 16:50:22.862 [info] create table reports_comments server # [699408.143065] server mobilizon_ctl[536]: 16:50:22.864 [info] == Migrated 20190712125833 in 0.0s server # [699408.153881] server mobilizon_ctl[536]: 16:50:22.874 [info] == Running 20190712132438 Mobilizon.Repo.Migrations.CreateReportNotes.change/0 forward server # [699408.154024] server mobilizon_ctl[536]: 16:50:22.875 [info] create table report_notes server # [699408.156805] server mobilizon_ctl[536]: 16:50:22.877 [info] == Migrated 20190712132438 in 0.0s server # [699408.163668] server mobilizon_ctl[536]: 16:50:22.884 [info] == Running 20190718122556 Mobilizon.Repo.Migrations.CreateAdminActionLogs.change/0 forward server # [699408.163936] server mobilizon_ctl[536]: 16:50:22.885 [info] create table admin_action_logs server # [699408.169014] server mobilizon_ctl[536]: 16:50:22.890 [info] == Migrated 20190718122556 in 0.0s server # [699408.177102] server mobilizon_ctl[536]: 16:50:22.898 [info] == Running 20190729125532 :"Elixir.Mobilizon.Repo.Migrations.Add-url-to-addresses".change/0 forward server # [699408.177280] server mobilizon_ctl[536]: 16:50:22.898 [info] alter table addresses server # [699408.178453] server mobilizon_ctl[536]: 16:50:22.899 [info] == Migrated 20190729125532 in 0.0s server # [699408.182859] server mobilizon_ctl[536]: 16:50:22.903 [info] == Running 20190806131306 Mobilizon.Repo.Migrations.AddUrlToFollowsAndMoveToUuid.up/0 forward server # [699408.183071] server mobilizon_ctl[536]: 16:50:22.904 [info] alter table followers server # [699408.185950] server mobilizon_ctl[536]: 16:50:22.906 [info] == Migrated 20190806131306 in 0.0s server # [699408.191886] server mobilizon_ctl[536]: 16:50:22.913 [info] == Running 20190813160207 Mobilizon.Repo.Migrations.AddUrlAndUuidToParticipants.up/0 forward server # [699408.192393] server mobilizon_ctl[536]: 16:50:22.913 [info] drop index participants_event_id_index server # [699408.193006] server mobilizon_ctl[536]: 16:50:22.914 [info] drop index if exists participants_account_id_index server # [699408.193628] server mobilizon_ctl[536]: 16:50:22.914 [info] drop index if exists participants_actor_id_index server # [699408.194062] server mobilizon_ctl[536]: 16:50:22.915 [info] index "participants_actor_id_index" does not exist, skipping server # [699408.194236] server mobilizon_ctl[536]: 16:50:22.915 [info] drop constraint participants_event_id_fkey from table participants server # [699408.195045] server mobilizon_ctl[536]: 16:50:22.916 [info] drop constraint if exists participants_account_id_fkey from table participants server # [699408.195911] server mobilizon_ctl[536]: 16:50:22.917 [info] drop constraint if exists participants_actor_id_fkey from table participants server # [699408.196364] server mobilizon_ctl[536]: 16:50:22.917 [info] constraint "participants_actor_id_fkey" of relation "participants" does not exist, skipping server # [699408.196364] server mobilizon_ctl[536]: 16:50:22.917 [info] drop constraint participants_pkey from table participants server # [699408.196988] server mobilizon_ctl[536]: 16:50:22.918 [info] alter table participants server # [699408.202046] server mobilizon_ctl[536]: 16:50:22.923 [info] create index participants_event_id_index server # [699408.203031] server mobilizon_ctl[536]: 16:50:22.924 [info] create index participants_actor_id_index server # [699408.204105] server mobilizon_ctl[536]: 16:50:22.924 [info] == Migrated 20190813160207 in 0.0s server # [699408.214446] server mobilizon_ctl[536]: 16:50:22.935 [info] == Running 20190821161658 Mobilizon.Repo.Migrations.AddOriginIdToAddresses.change/0 forward server # [699408.214837] server mobilizon_ctl[536]: 16:50:22.935 [info] alter table addresses server # [699408.215362] server mobilizon_ctl[536]: 16:50:22.936 [info] create index addresses_origin_id_index server # [699408.216463] server mobilizon_ctl[536]: 16:50:22.937 [info] == Migrated 20190821161658 in 0.0s server # [699408.222177] server mobilizon_ctl[536]: 16:50:22.943 [info] == Running 20190823132816 Mobilizon.Repo.Migrations.RemoveEventsWhenDeletingOrganizer.up/0 forward server # [699408.222327] server mobilizon_ctl[536]: 16:50:22.943 [info] drop constraint events_organizer_account_id_fkey from table events server # [699408.223544] server mobilizon_ctl[536]: 16:50:22.944 [info] alter table events server # [699408.226056] server mobilizon_ctl[536]: 16:50:22.946 [info] == Migrated 20190823132816 in 0.0s server # [699408.229303] server mobilizon_ctl[536]: 16:50:22.950 [info] == Running 20190902082656 Mobilizon.Repo.Migrations.AddOptionsToEvent.change/0 forward server # [699408.229582] server mobilizon_ctl[536]: 16:50:22.950 [info] alter table events server # [699408.230211] server mobilizon_ctl[536]: 16:50:22.951 [info] == Migrated 20190902082656 in 0.0s server # [699408.236721] server mobilizon_ctl[536]: 16:50:22.957 [info] == Running 20190929170817 Mobilizon.Storage.Repo.Migrations.RenamePostgresTypes.up/0 forward server # [699408.242300] server mobilizon_ctl[536]: 16:50:22.963 [info] == Migrated 20190929170817 in 0.0s server # [699408.248430] server mobilizon_ctl[536]: 16:50:22.969 [info] == Running 20190929175229 Mobilizon.Storage.Repo.Migrations.AddRejectedToParticipantRole.up/0 forward server # [699408.248627] server mobilizon_ctl[536]: 16:50:22.969 [info] execute "ALTER TYPE public.participant_role ADD VALUE IF NOT EXISTS 'rejected'" server # [699408.249531] server mobilizon_ctl[536]: 16:50:22.970 [info] enum label "rejected" already exists, skipping server # [699408.249833] server mobilizon_ctl[536]: 16:50:22.970 [info] == Migrated 20190929175229 in 0.0s server # [699408.255731] server mobilizon_ctl[536]: 16:50:22.976 [info] == Running 20191001074442 Mobilizon.Storage.Repo.Migrations.AddLocaleToUsers.change/0 forward server # [699408.255972] server mobilizon_ctl[536]: 16:50:22.977 [info] alter table users server # [699408.257686] server mobilizon_ctl[536]: 16:50:22.978 [info] == Migrated 20191001074442 in 0.0s server # [699408.261467] server mobilizon_ctl[536]: 16:50:22.982 [info] == Running 20191002093208 Mobilizon.Storage.Repo.Migrations.AddDraftFlagToEvents.change/0 forward server # [699408.261663] server mobilizon_ctl[536]: 16:50:22.982 [info] alter table events server # [699408.262920] server mobilizon_ctl[536]: 16:50:22.983 [info] == Migrated 20191002093208 in 0.0s server # [699408.269924] server mobilizon_ctl[536]: 16:50:22.991 [info] == Running 20191018075904 Mobilizon.Storage.Repo.Migrations.MoveSQLColumnsFromVarCharToText.up/0 forward server # [699408.270476] server mobilizon_ctl[536]: 16:50:22.991 [info] alter table events server # [699408.273074] server mobilizon_ctl[536]: 16:50:22.994 [info] alter table addresses server # [699408.273879] server mobilizon_ctl[536]: 16:50:22.995 [info] alter table bots server # [699408.274597] server mobilizon_ctl[536]: 16:50:22.995 [info] alter table report_notes server # [699408.276028] server mobilizon_ctl[536]: 16:50:22.997 [info] alter table reports server # [699408.276639] server mobilizon_ctl[536]: 16:50:22.997 [info] alter table sessions server # [699408.277461] server mobilizon_ctl[536]: 16:50:22.998 [info] alter table tracks server # [699408.278099] server mobilizon_ctl[536]: 16:50:22.999 [info] == Migrated 20191018075904 in 0.0s server # [699408.281746] server mobilizon_ctl[536]: 16:50:23.002 [info] == Running 20191022083446 Mobilizon.Storage.Repo.Migrations.AddEagerMaterializedViewForSearchingEvents.up/0 forward server # [699408.281987] server mobilizon_ctl[536]: 16:50:23.003 [info] create table event_search server # [699408.285325] server mobilizon_ctl[536]: 16:50:23.005 [info] create index event_search_document_index server # [699408.285813] server mobilizon_ctl[536]: 16:50:23.007 [info] execute "CREATE INDEX event_search_title_trgm_index ON event_search USING gin (title gin_trgm_ops)" server # [699408.286782] server mobilizon_ctl[536]: 16:50:23.007 [info] create index event_search_id_index server # [699408.287708] server mobilizon_ctl[536]: 16:50:23.008 [info] == Migrated 20191022083446 in 0.0s server # [699408.295614] server mobilizon_ctl[536]: 16:50:23.016 [info] == Running 20191023133805 Mobilizon.Storage.Repo.Migrations.DeleteActorsCascadeToFollowers.up/0 forward server # [699408.295844] server mobilizon_ctl[536]: 16:50:23.017 [info] drop constraint followers_actor_id_fkey from table followers server # [699408.296951] server mobilizon_ctl[536]: 16:50:23.018 [info] drop constraint followers_target_actor_id_fkey from table followers server # [699408.297948] server mobilizon_ctl[536]: 16:50:23.019 [info] alter table followers server # [699408.301273] server mobilizon_ctl[536]: 16:50:23.022 [info] == Migrated 20191023133805 in 0.0s server # [699408.306960] server mobilizon_ctl[536]: 16:50:23.028 [info] == Running 20191023143659 Mobilizon.Storage.Repo.Migrations.MoveParticipantsStatsToEvent.up/0 forward server # [699408.307100] server mobilizon_ctl[536]: 16:50:23.028 [info] alter table events server # [699408.308244] server mobilizon_ctl[536]: 16:50:23.029 [info] == Migrated 20191023143659 in 0.0s server # [699408.315571] server mobilizon_ctl[536]: 16:50:23.036 [info] == Running 20191024204726 Mobilizon.Storage.Repo.Migrations.AddTagsToComments.up/0 forward server # [699408.316120] server mobilizon_ctl[536]: 16:50:23.036 [info] create table comments_tags server # [699408.318963] server mobilizon_ctl[536]: 16:50:23.039 [info] == Migrated 20191024204726 in 0.0s server # [699408.328648] server mobilizon_ctl[536]: 16:50:23.049 [info] == Running 20191025083642 Mobilizon.Storage.Repo.Migrations.AddMentionTables.change/0 forward server # [699408.329142] server mobilizon_ctl[536]: 16:50:23.050 [info] create table mentions server # [699408.335253] server mobilizon_ctl[536]: 16:50:23.056 [info] create index mentions_actor_id_index server # [699408.336567] server mobilizon_ctl[536]: 16:50:23.057 [info] == Migrated 20191025083642 in 0.0s server # [699408.347478] server mobilizon_ctl[536]: 16:50:23.068 [info] == Running 20191025115537 Mobilizon.Storage.Repo.Migrations.AddUniqueIndexOnURLs.change/0 forward server # [699408.347747] server mobilizon_ctl[536]: 16:50:23.068 [info] create index events_url_index server # [699408.349247] server mobilizon_ctl[536]: 16:50:23.070 [info] create index comments_url_index server # [699408.350411] server mobilizon_ctl[536]: 16:50:23.071 [info] == Migrated 20191025115537 in 0.0s server # [699408.355912] server mobilizon_ctl[536]: 16:50:23.077 [info] == Running 20191031142145 Mobilizon.Storage.Repo.Migrations.AddUniqueIndexOnActorAndEventForParticipant.change/0 forward server # [699408.356136] server mobilizon_ctl[536]: 16:50:23.077 [info] create index participants_event_id_actor_id_index server # [699408.357993] server mobilizon_ctl[536]: 16:50:23.079 [info] == Migrated 20191031142145 in 0.0s server # [699408.364581] server mobilizon_ctl[536]: 16:50:23.085 [info] == Running 20191104093447 Mobilizon.Storage.Repo.Migrations.AddObanJobsTable.up/0 forward server # [699408.403311] server mobilizon_ctl[536]: 16:50:23.124 [info] execute "DO $$\nBEGIN\nIF NOT EXISTS (SELECT 1 FROM pg_type\n WHERE typname = 'oban_job_state'\n AND typnamespace = 'public'::regnamespace::oid) THEN\n CREATE TYPE \"public\".oban_job_state AS ENUM (\n 'available',\n 'suspended',\n 'scheduled',\n 'executing',\n 'retryable',\n 'completed',\n 'discarded',\n 'cancelled'\n );\n END IF;\nEND$$;\n" server # [699408.404982] server mobilizon_ctl[536]: 16:50:23.126 [info] create table if not exists public.oban_jobs server # [699408.407855] server mobilizon_ctl[536]: 16:50:23.129 [info] create index if not exists public.oban_jobs_queue_index server # [699408.408959] server mobilizon_ctl[536]: 16:50:23.130 [info] create index if not exists public.oban_jobs_state_index server # [699408.409697] server mobilizon_ctl[536]: 16:50:23.130 [info] create index if not exists public.oban_jobs_scheduled_at_index server # [699408.410620] server mobilizon_ctl[536]: 16:50:23.131 [info] execute "CREATE OR REPLACE FUNCTION \"public\".oban_jobs_notify() RETURNS trigger AS $$\nDECLARE\n channel text;\n notice json;\nBEGIN\n IF (TG_OP = 'INSERT') THEN\n channel = 'public.oban_insert';\n notice = json_build_object('queue', NEW.queue, 'state', NEW.state);\n\n -- No point triggering for a job that isn't scheduled to run now\n IF NEW.scheduled_at IS NOT NULL AND NEW.scheduled_at > now() AT TIME ZONE 'utc' THEN\n RETURN null;\n END IF;\n ELSE\n channel = 'public.oban_update';\n notice = json_build_object('queue', NEW.queue, 'new_state', NEW.state, 'old_state', OLD.state);\n END IF;\n\n PERFORM pg_notify(channel, notice::text);\n\n RETURN NULL;\nEND;\n$$ LANGUAGE plpgsql;\n" server # [699408.411961] server mobilizon_ctl[536]: 16:50:23.133 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs" server # [699408.412303] server mobilizon_ctl[536]: 16:50:23.133 [info] trigger "oban_notify" for relation "public.oban_jobs" does not exist, skipping server # [699408.412383] server mobilizon_ctl[536]: 16:50:23.133 [info] execute "CREATE TRIGGER oban_notify\nAFTER INSERT OR UPDATE OF state ON \"public\".oban_jobs\nFOR EACH ROW EXECUTE PROCEDURE \"public\".oban_jobs_notify();\n" server # [699408.412977] server mobilizon_ctl[536]: 16:50:23.134 [info] drop index if exists public.oban_jobs_scheduled_at_index server # [699408.413540] server mobilizon_ctl[536]: 16:50:23.134 [info] create index public.oban_jobs_scheduled_at_index server # [699408.414690] server mobilizon_ctl[536]: 16:50:23.135 [info] create check constraint worker_length on table public.oban_jobs server # [699408.415573] server mobilizon_ctl[536]: 16:50:23.136 [info] create check constraint queue_length on table public.oban_jobs server # [699408.416193] server mobilizon_ctl[536]: 16:50:23.137 [info] execute "CREATE OR REPLACE FUNCTION \"public\".oban_wrap_id(value bigint) RETURNS int AS $$\nBEGIN\n RETURN (CASE WHEN value > 2147483647 THEN mod(value, 2147483647) ELSE value END)::int;\nEND;\n$$ LANGUAGE plpgsql IMMUTABLE;\n" server # [699408.416871] server mobilizon_ctl[536]: 16:50:23.138 [info] alter table public.oban_jobs server # [699408.417280] server mobilizon_ctl[536]: 16:50:23.138 [info] execute "DROP FUNCTION IF EXISTS \"public\".oban_wrap_id(value bigint)" server # [699408.417647] server mobilizon_ctl[536]: 16:50:23.138 [info] drop index if exists public.oban_jobs_scheduled_at_index server # [699408.418068] server mobilizon_ctl[536]: 16:50:23.139 [info] drop index if exists public.oban_jobs_queue_index server # [699408.418339] server mobilizon_ctl[536]: 16:50:23.139 [info] drop index if exists public.oban_jobs_state_index server # [699408.418799] server mobilizon_ctl[536]: 16:50:23.139 [info] create index if not exists public.oban_jobs_queue_state_scheduled_at_id_index server # [699408.419952] server mobilizon_ctl[536]: 16:50:23.141 [info] create index if not exists public.oban_jobs_attempted_at_id_index server # [699408.420964] server mobilizon_ctl[536]: 16:50:23.142 [info] alter table public.oban_jobs server # [699408.422028] server mobilizon_ctl[536]: 16:50:23.143 [info] alter table public.oban_jobs server # [699408.422854] server mobilizon_ctl[536]: 16:50:23.144 [info] drop index if exists public.oban_jobs_queue_state_scheduled_at_id_index server # [699408.423447] server mobilizon_ctl[536]: 16:50:23.144 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index server # [699408.424768] server mobilizon_ctl[536]: 16:50:23.146 [info] execute "CREATE OR REPLACE FUNCTION \"public\".oban_jobs_notify() RETURNS trigger AS $$\nDECLARE\n channel text;\n notice json;\nBEGIN\n IF NEW.state = 'available' THEN\n channel = 'public.oban_insert';\n notice = json_build_object('queue', NEW.queue);\n\n PERFORM pg_notify(channel, notice::text);\n END IF;\n\n RETURN NULL;\nEND;\n$$ LANGUAGE plpgsql;\n" server # [699408.425352] server mobilizon_ctl[536]: 16:50:23.146 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs" server # [699408.426050] server mobilizon_ctl[536]: 16:50:23.147 [info] execute "CREATE TRIGGER oban_notify\nAFTER INSERT ON \"public\".oban_jobs\nFOR EACH ROW EXECUTE PROCEDURE \"public\".oban_jobs_notify();\n" server # [699408.426460] server mobilizon_ctl[536]: 16:50:23.147 [info] alter table public.oban_jobs server # [699408.438920] server mobilizon_ctl[536]: 16:50:23.160 [info] execute "ALTER TYPE \"public\".oban_job_state ADD VALUE IF NOT EXISTS 'cancelled'" server # [699408.439602] server mobilizon_ctl[536]: 16:50:23.160 [info] enum label "cancelled" already exists, skipping server # [699408.439602] server mobilizon_ctl[536]: 16:50:23.160 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index server # [699408.440176] server mobilizon_ctl[536]: 16:50:23.161 [info] relation "oban_jobs_state_queue_priority_scheduled_at_id_index" already exists, skipping server # [699408.440176] server mobilizon_ctl[536]: 16:50:23.161 [info] alter table public.oban_jobs server # [699408.441969] server mobilizon_ctl[536]: 16:50:23.163 [info] create check constraint priority_range on table public.oban_jobs server # [699408.442636] server mobilizon_ctl[536]: 16:50:23.163 [info] create check constraint positive_max_attempts on table public.oban_jobs server # [699408.443272] server mobilizon_ctl[536]: 16:50:23.164 [info] create check constraint attempt_range on table public.oban_jobs server # [699408.443919] server mobilizon_ctl[536]: 16:50:23.165 [info] drop index if exists public.oban_jobs_args_vector server # [699408.444302] server mobilizon_ctl[536]: 16:50:23.165 [info] index "oban_jobs_args_vector" does not exist, skipping server # [699408.445830] server mobilizon_ctl[536]: 16:50:23.165 [info] drop index if exists public.oban_jobs_worker_gist server # [699408.445927] server mobilizon_ctl[536]: 16:50:23.165 [info] index "oban_jobs_worker_gist" does not exist, skipping server # [699408.445927] server mobilizon_ctl[536]: 16:50:23.165 [info] drop index if exists public.oban_jobs_attempted_at_id_index server # [699408.445927] server mobilizon_ctl[536]: 16:50:23.166 [info] create index if not exists public.oban_jobs_args_index server # [699408.445927] server mobilizon_ctl[536]: 16:50:23.167 [info] create index if not exists public.oban_jobs_meta_index server # [699408.446988] server mobilizon_ctl[536]: 16:50:23.167 [info] create table if not exists public.oban_peers server # [699408.449051] server mobilizon_ctl[536]: 16:50:23.170 [info] execute "ALTER TABLE \"public\".oban_peers SET UNLOGGED" server # [699408.451371] server mobilizon_ctl[536]: 16:50:23.172 [info] drop constraint priority_range from table public.oban_jobs server # [699408.452494] server mobilizon_ctl[536]: 16:50:23.173 [info] create check constraint non_negative_priority on table public.oban_jobs server # [699408.453635] server mobilizon_ctl[536]: 16:50:23.174 [info] execute "DROP TRIGGER IF EXISTS oban_notify ON \"public\".oban_jobs" server # [699408.454227] server mobilizon_ctl[536]: 16:50:23.175 [info] execute "DROP FUNCTION IF EXISTS \"public\".oban_jobs_notify()" server # [699408.454913] server mobilizon_ctl[536]: 16:50:23.176 [info] create index if not exists public.oban_jobs_state_cancelled_at_index server # [699408.455995] server mobilizon_ctl[536]: 16:50:23.177 [info] create index if not exists public.oban_jobs_state_discarded_at_index server # [699408.457071] server mobilizon_ctl[536]: 16:50:23.178 [info] execute "ALTER TYPE \"public\".oban_job_state ADD VALUE IF NOT EXISTS 'suspended' BEFORE 'scheduled'\n" server # [699408.457359] server mobilizon_ctl[536]: 16:50:23.178 [info] enum label "suspended" already exists, skipping server # [699408.457448] server mobilizon_ctl[536]: 16:50:23.178 [info] execute "COMMENT ON TABLE \"public\".oban_jobs IS '14'" server # [699408.457862] server mobilizon_ctl[536]: 16:50:23.178 [info] == Migrated 20191104093447 in 0.0s server # [699408.474496] server mobilizon_ctl[536]: 16:50:23.195 [info] == Running 20191106114524 Mobilizon.Storage.Repo.Migrations.RemoveFloorFromAddresses.up/0 forward server # [699408.474800] server mobilizon_ctl[536]: 16:50:23.195 [info] alter table addresses server # [699408.475898] server mobilizon_ctl[536]: 16:50:23.196 [info] == Migrated 20191106114524 in 0.0s server # [699408.481847] server mobilizon_ctl[536]: 16:50:23.202 [info] == Running 20191106141051 Mobilizon.Storage.Repo.Migrations.AddTypeToAddresses.change/0 forward server # [699408.482046] server mobilizon_ctl[536]: 16:50:23.203 [info] alter table addresses server # [699408.483086] server mobilizon_ctl[536]: 16:50:23.204 [info] == Migrated 20191106141051 in 0.0s server # [699408.489682] server mobilizon_ctl[536]: 16:50:23.210 [info] == Running 20191114155534 Mobilizon.Storage.Repo.Migrations.CascadeCommentDeletion.up/0 forward server # [699408.490036] server mobilizon_ctl[536]: 16:50:23.210 [info] drop constraint comments_in_reply_to_comment_id_fkey from table comments server # [699408.490733] server mobilizon_ctl[536]: 16:50:23.211 [info] drop constraint comments_origin_comment_id_fkey from table comments server # [699408.491713] server mobilizon_ctl[536]: 16:50:23.212 [info] alter table comments server # [699408.494627] server mobilizon_ctl[536]: 16:50:23.215 [info] == Migrated 20191114155534 in 0.0s server # [699408.502196] server mobilizon_ctl[536]: 16:50:23.223 [info] == Running 20191122154018 Mobilizon.Storage.Repo.Migrations.AddDeletedAtOnComments.up/0 forward server # [699408.502432] server mobilizon_ctl[536]: 16:50:23.223 [info] drop constraint if exists comments_actor_id_fkey from table comments server # [699408.503319] server mobilizon_ctl[536]: 16:50:23.224 [info] constraint "comments_actor_id_fkey" of relation "comments" does not exist, skipping server # [699408.503429] server mobilizon_ctl[536]: 16:50:23.224 [info] alter table comments server # [699408.505932] server mobilizon_ctl[536]: 16:50:23.226 [info] == Migrated 20191122154018 in 0.0s server # [699408.514205] server mobilizon_ctl[536]: 16:50:23.235 [info] == Running 20191126173510 Mobilizon.Storage.Repo.Migrations.AddLocalFieldToReports.up/0 forward server # [699408.514625] server mobilizon_ctl[536]: 16:50:23.235 [info] alter table reports server # [699408.515243] server mobilizon_ctl[536]: 16:50:23.236 [info] rename column uri to url on table reports server # [699408.515824] server mobilizon_ctl[536]: 16:50:23.236 [info] == Migrated 20191126173510 in 0.0s server # [699408.521327] server mobilizon_ctl[536]: 16:50:23.242 [info] == Running 20191127163737 Mobilizon.Repo.Migrations.CreateTombstones.change/0 forward server # [699408.522173] server mobilizon_ctl[536]: 16:50:23.242 [info] create table tombstones server # [699408.525925] server mobilizon_ctl[536]: 16:50:23.247 [info] create index tombstones_uri_index server # [699408.527065] server mobilizon_ctl[536]: 16:50:23.248 [info] == Migrated 20191127163737 in 0.0s server # [699408.534482] server mobilizon_ctl[536]: 16:50:23.255 [info] == Running 20191129091227 Mobilizon.Storage.Repo.Migrations.AddTimestampsToFollowers.change/0 forward server # [699408.534683] server mobilizon_ctl[536]: 16:50:23.255 [info] alter table followers server # [699408.535609] server mobilizon_ctl[536]: 16:50:23.256 [info] == Migrated 20191129091227 in 0.0s server # [699408.542433] server mobilizon_ctl[536]: 16:50:23.263 [info] == Running 20191204164224 Mobilizon.Storage.Repo.Migrations.DeleteEventCascadeToComments.up/0 forward server # [699408.542683] server mobilizon_ctl[536]: 16:50:23.263 [info] drop constraint if exists comments_event_id_fkey from table comments server # [699408.544247] server mobilizon_ctl[536]: 16:50:23.265 [info] alter table comments server # [699408.546187] server mobilizon_ctl[536]: 16:50:23.267 [info] == Migrated 20191204164224 in 0.0s server # [699408.552402] server mobilizon_ctl[536]: 16:50:23.273 [info] == Running 20191206144028 Mobilizon.Repo.Migrations.CreateShares.up/0 forward server # [699408.552595] server mobilizon_ctl[536]: 16:50:23.273 [info] create table shares server # [699408.555925] server mobilizon_ctl[536]: 16:50:23.277 [info] create index if not exists shares_uri_actor_id_index server # [699408.557409] server mobilizon_ctl[536]: 16:50:23.278 [info] == Migrated 20191206144028 in 0.0s server # [699408.565670] server mobilizon_ctl[536]: 16:50:23.286 [info] == Running 20191219172017 Mobilizon.Storage.Repo.Migrations.AddMetadataToParticipant.up/0 forward server # [699408.565947] server mobilizon_ctl[536]: 16:50:23.287 [info] drop index if exists participants_event_id_actor_id_index server # [699408.567085] server mobilizon_ctl[536]: 16:50:23.288 [info] alter table participants server # [699408.569328] server mobilizon_ctl[536]: 16:50:23.290 [info] execute "CREATE UNIQUE INDEX participants_metadata_confirmation_token_index ON participants((metadata->>'confirmation_token'))" server # [699408.570404] server mobilizon_ctl[536]: 16:50:23.291 [info] == Migrated 20191219172017 in 0.0s server # [699408.576902] server mobilizon_ctl[536]: 16:50:23.297 [info] == Running 20191223173537 Mobilizon.Storage.Repo.Migrations.AddNotConfirmedStatusToParticipants.up/0 forward server # [699408.577085] server mobilizon_ctl[536]: 16:50:23.298 [info] execute "ALTER TYPE participant_role ADD VALUE IF NOT EXISTS 'not_confirmed'" server # [699408.577718] server mobilizon_ctl[536]: 16:50:23.298 [info] enum label "not_confirmed" already exists, skipping server # [699408.578007] server mobilizon_ctl[536]: 16:50:23.298 [info] == Migrated 20191223173537 in 0.0s server # [699408.585084] server mobilizon_ctl[536]: 16:50:23.306 [info] == Running 20200116095117 Mobilizon.Repo.Migrations.CreateAdminSettings.change/0 forward server # [699408.585742] server mobilizon_ctl[536]: 16:50:23.306 [info] create table admin_settings server # [699408.588813] server mobilizon_ctl[536]: 16:50:23.309 [info] create index admin_settings_group_name_index server # [699408.589834] server mobilizon_ctl[536]: 16:50:23.310 [info] == Migrated 20200116095117 in 0.0s server # [699408.600935] server mobilizon_ctl[536]: 16:50:23.321 [info] == Running 20200210100910 Mobilizon.Storage.Repo.Migrations.AddUnconfirmedEmailToUsersTable.change/0 forward server # [699408.600935] server mobilizon_ctl[536]: 16:50:23.322 [info] alter table users server # [699408.605174] server mobilizon_ctl[536]: 16:50:23.326 [info] == Migrated 20200210100910 in 0.0s server # [699408.611394] server mobilizon_ctl[536]: 16:50:23.332 [info] == Running 20200213154309 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV8.up/0 forward server # [699408.613097] server mobilizon_ctl[536]: 16:50:23.334 [info] == Migrated 20200213154309 in 0.0s server # [699408.618814] server mobilizon_ctl[536]: 16:50:23.340 [info] == Running 20200214135231 Mobilizon.Storage.Repo.Migrations.AddLastRefreshedAtToActors.change/0 forward server # [699408.618972] server mobilizon_ctl[536]: 16:50:23.340 [info] alter table actors server # [699408.619838] server mobilizon_ctl[536]: 16:50:23.340 [info] == Migrated 20200214135231 in 0.0s server # [699408.622539] server mobilizon_ctl[536]: 16:50:23.343 [info] == Running 20200218085757 Mobilizon.Storage.Repo.Migrations.AddNewRolesToMember.up/0 forward server # [699408.622722] server mobilizon_ctl[536]: 16:50:23.343 [info] execute "ALTER TYPE member_role ADD VALUE IF NOT EXISTS 'invited'" server # [699408.623133] server mobilizon_ctl[536]: 16:50:23.344 [info] enum label "invited" already exists, skipping server # [699408.623169] server mobilizon_ctl[536]: 16:50:23.344 [info] execute "ALTER TYPE member_role ADD VALUE IF NOT EXISTS 'rejected'" server # [699408.623478] server mobilizon_ctl[536]: 16:50:23.344 [info] enum label "rejected" already exists, skipping server # [699408.623665] server mobilizon_ctl[536]: 16:50:23.344 [info] == Migrated 20200218085757 in 0.0s server # [699408.629506] server mobilizon_ctl[536]: 16:50:23.350 [info] == Running 20200218170232 Mobilizon.Storage.Repo.Migrations.MoveMemberIdToUuid.up/0 forward server # [699408.629844] server mobilizon_ctl[536]: 16:50:23.350 [info] alter table members server # [699408.634173] server mobilizon_ctl[536]: 16:50:23.355 [info] == Migrated 20200218170232 in 0.0s server # [699408.641234] server mobilizon_ctl[536]: 16:50:23.362 [info] == Running 20200219152611 Mobilizon.Storage.Repo.Migrations.AddMembersEndpointToActors.up/0 forward server # [699408.641430] server mobilizon_ctl[536]: 16:50:23.362 [info] alter table actors server # [699408.642446] server mobilizon_ctl[536]: 16:50:23.363 [info] == Migrated 20200219152611 in 0.0s server # [699408.650954] server mobilizon_ctl[536]: 16:50:23.372 [info] == Running 20200221095721 Mobilizon.Repo.Migrations.CreateTodos.change/0 forward server # [699408.651292] server mobilizon_ctl[536]: 16:50:23.372 [info] create table todo_lists server # [699408.654628] server mobilizon_ctl[536]: 16:50:23.375 [info] create table todos server # [699408.659059] server mobilizon_ctl[536]: 16:50:23.379 [info] == Migrated 20200221095721 in 0.0s server # [699408.672874] server mobilizon_ctl[536]: 16:50:23.393 [info] == Running 20200221160744 Mobilizon.Repo.Migrations.CreateResources.change/0 forward server # [699408.674070] server mobilizon_ctl[536]: 16:50:23.393 [info] create table resource server # [699408.676527] server mobilizon_ctl[536]: 16:50:23.397 [info] == Migrated 20200221160744 in 0.0s server # [699408.684741] server mobilizon_ctl[536]: 16:50:23.405 [info] == Running 20200406115807 Mobilizon.Storage.Repo.Migrations.AddConversations.change/0 forward server # [699408.684992] server mobilizon_ctl[536]: 16:50:23.406 [info] create table conversations server # [699408.689041] server mobilizon_ctl[536]: 16:50:23.409 [info] alter table comments server # [699408.691694] server mobilizon_ctl[536]: 16:50:23.412 [info] == Migrated 20200406115807 in 0.0s server # [699408.700559] server mobilizon_ctl[536]: 16:50:23.421 [info] == Running 20200410100554 Mobilizon.Storage.Repo.Migrations.AddNumberEditsToComment.change/0 forward server # [699408.701024] server mobilizon_ctl[536]: 16:50:23.421 [info] alter table comments server # [699408.702248] server mobilizon_ctl[536]: 16:50:23.423 [info] == Migrated 20200410100554 in 0.0s server # [699408.709054] server mobilizon_ctl[536]: 16:50:23.430 [info] == Running 20200513142813 Mobilizon.Storage.Repo.Migrations.AddResourcesAndTodosEndpointsToActor.change/0 forward server # [699408.709054] server mobilizon_ctl[536]: 16:50:23.430 [info] alter table actors server # [699408.710100] server mobilizon_ctl[536]: 16:50:23.431 [info] == Migrated 20200513142813 in 0.0s server # [699408.716161] server mobilizon_ctl[536]: 16:50:23.437 [info] == Running 20200514101612 Mobilizon.Storage.Repo.Migrations.AddLocalAttributeToResourcesAndTodos.change/0 forward server # [699408.716830] server mobilizon_ctl[536]: 16:50:23.437 [info] alter table resource server # [699408.717159] server mobilizon_ctl[536]: 16:50:23.438 [info] alter table todo_lists server # [699408.718178] server mobilizon_ctl[536]: 16:50:23.439 [info] alter table todos server # [699408.719903] server mobilizon_ctl[536]: 16:50:23.440 [info] == Migrated 20200514101612 in 0.0s server # [699408.727671] server mobilizon_ctl[536]: 16:50:23.448 [info] == Running 20200518084949 Mobilizon.Storage.Repo.Migrations.MoveInviterFromMetadataToMemberTable.change/0 forward server # [699408.727850] server mobilizon_ctl[536]: 16:50:23.449 [info] alter table members server # [699408.731264] server mobilizon_ctl[536]: 16:50:23.452 [info] == Migrated 20200518084949 in 0.0s server # [699408.738364] server mobilizon_ctl[536]: 16:50:23.459 [info] == Running 20200519082820 Mobilizon.Storage.Repo.Migrations.AddUniqueURLContraintToSomeTables.change/0 forward server # [699408.738862] server mobilizon_ctl[536]: 16:50:23.459 [info] create index members_url_index server # [699408.740610] server mobilizon_ctl[536]: 16:50:23.461 [info] create index resource_url_index server # [699408.741746] server mobilizon_ctl[536]: 16:50:23.462 [info] create index todo_lists_url_index server # [699408.743338] server mobilizon_ctl[536]: 16:50:23.464 [info] create index todos_url_index server # [699408.744978] server mobilizon_ctl[536]: 16:50:23.466 [info] == Migrated 20200519082820 in 0.0s server # [699408.748488] server mobilizon_ctl[536]: 16:50:23.469 [info] == Running 20200526131523 Mobilizon.Repo.Migrations.CreateUserSettings.change/0 forward server # [699408.748784] server mobilizon_ctl[536]: 16:50:23.469 [info] create table user_settings server # [699408.751744] server mobilizon_ctl[536]: 16:50:23.472 [info] == Migrated 20200526131523 in 0.0s server # [699408.759103] server mobilizon_ctl[536]: 16:50:23.480 [info] == Running 20200605154921 Mobilizon.Storage.Repo.Migrations.AddNotificationPendingParticipationToSettings.change/0 forward server # [699408.759267] server mobilizon_ctl[536]: 16:50:23.480 [info] alter table user_settings server # [699408.760360] server mobilizon_ctl[536]: 16:50:23.481 [info] == Migrated 20200605154921 in 0.0s server # [699408.766068] server mobilizon_ctl[536]: 16:50:23.487 [info] == Running 20200612155254 Mobilizon.Storage.Repo.Migrations.AddDisabledParameterToUsers.change/0 forward server # [699408.766235] server mobilizon_ctl[536]: 16:50:23.487 [info] alter table users server # [699408.767461] server mobilizon_ctl[536]: 16:50:23.488 [info] == Migrated 20200612155254 in 0.0s server # [699408.771095] server mobilizon_ctl[536]: 16:50:23.492 [info] == Running 20200630123819 Mobilizon.Storage.Repo.Migrations.AddProviderToUserAndMakePasswordMandatory.up/0 forward server # [699408.771214] server mobilizon_ctl[536]: 16:50:23.492 [info] alter table users server # [699408.772296] server mobilizon_ctl[536]: 16:50:23.493 [info] == Migrated 20200630123819 in 0.0s server # [699408.781820] server mobilizon_ctl[536]: 16:50:23.502 [info] == Running 20200708080516 Mobilizon.Repo.Migrations.CreatePosts.up/0 forward server # [699408.788837] server mobilizon_ctl[536]: 16:50:23.509 [info] execute "CREATE TYPE public.post_visibility AS ENUM ('public', 'unlisted', 'restricted', 'private')" server # [699408.789785] server mobilizon_ctl[536]: 16:50:23.510 [info] create table posts server # [699408.794464] server mobilizon_ctl[536]: 16:50:23.515 [info] create table posts_tags server # [699408.796697] server mobilizon_ctl[536]: 16:50:23.517 [info] alter table actors server # [699408.797474] server mobilizon_ctl[536]: 16:50:23.518 [info] == Migrated 20200708080516 in 0.0s server # [699408.806210] server mobilizon_ctl[536]: 16:50:23.527 [info] == Running 20200717142633 Mobilizon.Storage.Repo.Migrations.RenameConversationsToDiscussions.up/0 forward server # [699408.806470] server mobilizon_ctl[536]: 16:50:23.527 [info] rename table conversations to discussions server # [699408.807001] server mobilizon_ctl[536]: 16:50:23.528 [info] rename column conversation_id to discussion_id on table comments server # [699408.807397] server mobilizon_ctl[536]: 16:50:23.528 [info] alter table actors server # [699408.808034] server mobilizon_ctl[536]: 16:50:23.529 [info] == Migrated 20200717142633 in 0.0s server # [699408.815028] server mobilizon_ctl[536]: 16:50:23.536 [info] == Running 20200721131521 Mobilizon.Storage.Repo.Migrations.AddUrlToConversation.up/0 forward server # [699408.815269] server mobilizon_ctl[536]: 16:50:23.536 [info] drop constraint if exists comments_conversation_id_fkey from table comments server # [699408.816553] server mobilizon_ctl[536]: 16:50:23.537 [info] drop constraint if exists comments_discussion_id_fkey from table comments server # [699408.817046] server mobilizon_ctl[536]: 16:50:23.538 [info] constraint "comments_discussion_id_fkey" of relation "comments" does not exist, skipping server # [699408.817161] server mobilizon_ctl[536]: 16:50:23.538 [info] alter table discussions server # [699408.818813] server mobilizon_ctl[536]: 16:50:23.540 [info] alter table comments server # [699408.820895] server mobilizon_ctl[536]: 16:50:23.541 [info] == Migrated 20200721131521 in 0.0s server # [699408.826389] server mobilizon_ctl[536]: 16:50:23.547 [info] == Running 20200805124620 Mobilizon.Storage.Repo.Migrations.AddAddressToActors.change/0 forward server # [699408.826554] server mobilizon_ctl[536]: 16:50:23.547 [info] alter table actors server # [699408.828880] server mobilizon_ctl[536]: 16:50:23.549 [info] == Migrated 20200805124620 in 0.0s server # [699408.837051] server mobilizon_ctl[536]: 16:50:23.558 [info] == Running 20200817080549 Mobilizon.Storage.Repo.Migrations.AddPublishedAtToEntities.up/0 forward server # [699408.837182] server mobilizon_ctl[536]: 16:50:23.558 [info] alter table comments server # [699408.838667] server mobilizon_ctl[536]: 16:50:23.559 [info] alter table resource server # [699408.840102] server mobilizon_ctl[536]: 16:50:23.561 [info] alter table todo_lists server # [699408.841406] server mobilizon_ctl[536]: 16:50:23.562 [info] alter table todos server # [699408.843058] server mobilizon_ctl[536]: 16:50:23.563 [info] == Migrated 20200817080549 in 0.0s server # [699408.850051] server mobilizon_ctl[536]: 16:50:23.570 [info] == Running 20200828071543 Mobilizon.Storage.Repo.Migrations.AddLoginInformationToUser.change/0 forward server # [699408.850223] server mobilizon_ctl[536]: 16:50:23.571 [info] alter table users server # [699408.851161] server mobilizon_ctl[536]: 16:50:23.572 [info] == Migrated 20200828071543 in 0.0s server # [699408.859633] server mobilizon_ctl[536]: 16:50:23.580 [info] == Running 20200901101307 Mobilizon.Storage.Repo.Migrations.FixRelayVisibility.up/0 forward server # [699408.866178] server mobilizon_ctl[536]: 16:50:23.587 [info] == Migrated 20200901101307 in 0.0s server # [699408.872123] server mobilizon_ctl[536]: 16:50:23.593 [info] == Running 20200928150725 Mobilizon.Storage.Repo.Migrations.AddContactsToEvents.change/0 forward server # [699408.872335] server mobilizon_ctl[536]: 16:50:23.593 [info] create table event_contacts server # [699408.876026] server mobilizon_ctl[536]: 16:50:23.597 [info] == Migrated 20200928150725 in 0.0s server # [699408.882062] server mobilizon_ctl[536]: 16:50:23.603 [info] == Running 20201006132530 Mobilizon.Storage.Repo.Migrations.ChangeDefaultNotificationPendingParticipation.up/0 forward server # [699408.882202] server mobilizon_ctl[536]: 16:50:23.603 [info] alter table user_settings server # [699408.883779] server mobilizon_ctl[536]: 16:50:23.604 [info] == Migrated 20201006132530 in 0.0s server # [699408.892083] server mobilizon_ctl[536]: 16:50:23.613 [info] == Running 20201103141811 Mobilizon.Storage.Repo.Migrations.AddNotificationPendingMembershipToSettings.change/0 forward server # [699408.892597] server mobilizon_ctl[536]: 16:50:23.613 [info] alter table user_settings server # [699408.893384] server mobilizon_ctl[536]: 16:50:23.614 [info] == Migrated 20201103141811 in 0.0s server # [699408.900367] server mobilizon_ctl[536]: 16:50:23.621 [info] == Running 20201105145719 Mobilizon.Storage.Repo.Migrations.RepairGroupsWithMissingURLs.up/0 forward server # [699408.909594] server mobilizon_ctl[536]: 16:50:23.630 [info] == Migrated 20201105145719 in 0.0s server # [699408.912449] server mobilizon_ctl[536]: 16:50:23.633 [info] == Running 20201114174929 Mobilizon.Storage.Repo.Migrations.FixObanMigrationsForOlderPostgreSQLVersions.up/0 forward server # [699408.913060] server mobilizon_ctl[536]: 16:50:23.634 [info] == Migrated 20201114174929 in 0.0s server # [699408.920075] server mobilizon_ctl[536]: 16:50:23.641 [info] == Running 20201114175249 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV9.up/0 forward server # [699408.922015] server mobilizon_ctl[536]: 16:50:23.643 [info] == Migrated 20201114175249 in 0.0s server # [699408.928020] server mobilizon_ctl[536]: 16:50:23.649 [info] == Running 20201120161229 Mobilizon.Storage.Repo.Migrations.FixPictureDeletion.up/0 forward server # [699408.928265] server mobilizon_ctl[536]: 16:50:23.649 [info] drop constraint if exists posts_picture_id_fkey from table posts server # [699408.929668] server mobilizon_ctl[536]: 16:50:23.650 [info] alter table posts server # [699408.931256] server mobilizon_ctl[536]: 16:50:23.652 [info] drop constraint if exists events_picture_id_fkey from table events server # [699408.932268] server mobilizon_ctl[536]: 16:50:23.653 [info] alter table events server # [699408.934326] server mobilizon_ctl[536]: 16:50:23.655 [info] == Migrated 20201120161229 in 0.0s server # [699408.940522] server mobilizon_ctl[536]: 16:50:23.661 [info] == Running 20201124094655 Mobilizon.Storage.Repo.Migrations.AddMediaTables.change/0 forward server # [699408.940810] server mobilizon_ctl[536]: 16:50:23.662 [info] rename table pictures to medias server # [699408.941593] server mobilizon_ctl[536]: 16:50:23.662 [info] create table events_medias server # [699408.944204] server mobilizon_ctl[536]: 16:50:23.665 [info] create table posts_medias server # [699408.946965] server mobilizon_ctl[536]: 16:50:23.668 [info] create table comments_medias server # [699408.949659] server mobilizon_ctl[536]: 16:50:23.670 [info] == Migrated 20201124094655 in 0.0s server # [699408.963948] server mobilizon_ctl[536]: 16:50:23.685 [info] == Running 20210127153325 Mobilizon.Storage.Repo.Migrations.UpgradeObanJobsToV10.up/0 forward server # [699408.965658] server mobilizon_ctl[536]: 16:50:23.686 [info] == Migrated 20210127153325 in 0.0s server # [699408.973420] server mobilizon_ctl[536]: 16:50:23.694 [info] == Running 20210210143432 Mobilizon.Storage.Repo.Migrations.AddLocationSettingsToUser.change/0 forward server # [699408.973692] server mobilizon_ctl[536]: 16:50:23.694 [info] alter table user_settings server # [699408.975469] server mobilizon_ctl[536]: 16:50:23.696 [info] == Migrated 20210210143432 in 0.0s server # [699408.982263] server mobilizon_ctl[536]: 16:50:23.703 [info] == Running 20210215092515 Mobilizon.Storage.Repo.Migrations.AddActivityTable.change/0 forward server # [699408.982534] server mobilizon_ctl[536]: 16:50:23.703 [info] create table activities server # [699408.987424] server mobilizon_ctl[536]: 16:50:23.708 [info] == Migrated 20210215092515 in 0.0s server # [699408.996883] server mobilizon_ctl[536]: 16:50:23.718 [info] == Running 20210217164549 Mobilizon.Storage.Repo.Migrations.AddMemberSinceToMembers.up/0 forward server # [699408.997283] server mobilizon_ctl[536]: 16:50:23.718 [info] alter table members server # [699408.999802] server mobilizon_ctl[536]: 16:50:23.720 [info] == Migrated 20210217164549 in 0.0s server # [699409.006160] server mobilizon_ctl[536]: 16:50:23.727 [info] == Running 20210310084210 Mobilizon.Storage.Repo.Migrations.AddIndexesToActivities.change/0 forward server # [699409.006274] server mobilizon_ctl[536]: 16:50:23.727 [info] create index activity_group_id server # [699409.007642] server mobilizon_ctl[536]: 16:50:23.728 [info] create index activity_filter server # [699409.009212] server mobilizon_ctl[536]: 16:50:23.730 [info] == Migrated 20210310084210 in 0.0s server # [699409.015628] server mobilizon_ctl[536]: 16:50:23.736 [info] == Running 20210422140923 Mobilizon.Storage.Repo.Migrations.CleanupAddresses.up/0 forward server # [699409.017714] server mobilizon_ctl[536]: 16:50:23.738 [info] == Migrated 20210422140923 in 0.0s server # [699409.023751] server mobilizon_ctl[536]: 16:50:23.744 [info] == Running 20210422155913 Mobilizon.Storage.Repo.Migrations.AddIndexToAddresses.up/0 forward server # [699409.024162] server mobilizon_ctl[536]: 16:50:23.745 [info] create index if not exists addresses_url_index server # [699409.028502] server mobilizon_ctl[536]: 16:50:23.749 [info] == Migrated 20210422155913 in 0.0s server # [699409.037559] server mobilizon_ctl[536]: 16:50:23.758 [info] == Running 20210427091034 Mobilizon.Storage.Repo.Migrations.RepairUsersDefaultActors.up/0 forward server # [699409.039355] server mobilizon_ctl[536]: 16:50:23.760 [info] == Migrated 20210427091034 in 0.0s server # [699409.046685] server mobilizon_ctl[536]: 16:50:23.767 [info] == Running 20210505172402 Mobilizon.Storage.Repo.Migrations.AddGroupNotificationAndLastNotificationDateSettings.change/0 forward server # [699409.046889] server mobilizon_ctl[536]: 16:50:23.768 [info] alter table user_settings server # [699409.047820] server mobilizon_ctl[536]: 16:50:23.768 [info] == Migrated 20210505172402 in 0.0s server # [699409.054123] server mobilizon_ctl[536]: 16:50:23.775 [info] == Running 20210506080303 Mobilizon.Repo.Migrations.CreateUserPushSubscriptions.change/0 forward server # [699409.054498] server mobilizon_ctl[536]: 16:50:23.775 [info] create table user_push_subscriptions server # [699409.057683] server mobilizon_ctl[536]: 16:50:23.778 [info] create index user_push_subscriptions_user_id_digest_index server # [699409.059111] server mobilizon_ctl[536]: 16:50:23.779 [info] == Migrated 20210506080303 in 0.0s server # [699409.067968] server mobilizon_ctl[536]: 16:50:23.788 [info] == Running 20210512084824 Mobilizon.Storage.Repo.Migrations.RepairRelayAndAnonymousActors.up/0 forward server # [699409.069826] server mobilizon_ctl[536]: 16:50:23.790 [info] == Migrated 20210512084824 in 0.0s server # [699409.081035] server mobilizon_ctl[536]: 16:50:23.802 [info] == Running 20210526203337 Mobilizon.Storage.Repo.Migrations.AddUserActivitySettings.change/0 forward server # [699409.081208] server mobilizon_ctl[536]: 16:50:23.802 [info] create table user_activity_settings server # [699409.084613] server mobilizon_ctl[536]: 16:50:23.805 [info] create index user_activity_settings_user_id_key_method_index server # [699409.086269] server mobilizon_ctl[536]: 16:50:23.806 [info] == Migrated 20210526203337 in 0.0s server # [699409.094398] server mobilizon_ctl[536]: 16:50:23.815 [info] == Running 20210601082412 Mobilizon.Storage.Repo.Migrations.AddIsAnnouncementToComments.change/0 forward server # [699409.094398] server mobilizon_ctl[536]: 16:50:23.815 [info] alter table comments server # [699409.095560] server mobilizon_ctl[536]: 16:50:23.816 [info] == Migrated 20210601082412 in 0.0s server # [699409.102088] server mobilizon_ctl[536]: 16:50:23.823 [info] == Running 20210601082613 Mobilizon.Storage.Repo.Migrations.FixUserSettingsNullableFields.change/0 forward server # [699409.104077] server mobilizon_ctl[536]: 16:50:23.823 [info] alter table user_settings server # [699409.105655] server mobilizon_ctl[536]: 16:50:23.826 [info] == Migrated 20210601082613 in 0.0s server # [699409.110353] server mobilizon_ctl[536]: 16:50:23.831 [info] == Running 20210608133040 Mobilizon.Storage.Repo.Migrations.AddMetadataToMedia.change/0 forward server # [699409.110489] server mobilizon_ctl[536]: 16:50:23.831 [info] alter table medias server # [699409.111163] server mobilizon_ctl[536]: 16:50:23.832 [info] == Migrated 20210608133040 in 0.0s server # [699409.120696] server mobilizon_ctl[536]: 16:50:23.841 [info] == Running 20210622133516 Mobilizon.Storage.Repo.Migrations.CleanupPosts.up/0 forward server # [699409.122622] server mobilizon_ctl[536]: 16:50:23.843 [info] == Migrated 20210622133516 in 0.0s server # [699409.129414] server mobilizon_ctl[536]: 16:50:23.850 [info] == Running 20210622133555 Mobilizon.Storage.Repo.Migrations.AddIndexToPosts.up/0 forward server # [699409.130644] server mobilizon_ctl[536]: 16:50:23.850 [info] create index if not exists posts_url_index server # [699409.131408] server mobilizon_ctl[536]: 16:50:23.852 [info] == Migrated 20210622133555 in 0.0s server # [699409.138968] server mobilizon_ctl[536]: 16:50:23.860 [info] == Running 20210730143924 Mobilizon.Storage.Repo.Migrations.PutUniqueIndexOnParticipantsUrls.up/0 forward server # [699409.139179] server mobilizon_ctl[536]: 16:50:23.860 [info] create index if not exists participants_url_index server # [699409.141041] server mobilizon_ctl[536]: 16:50:23.861 [info] == Migrated 20210730143924 in 0.0s server # [699409.147644] server mobilizon_ctl[536]: 16:50:23.868 [info] == Running 20210805142745 Mobilizon.Storage.Repo.Migrations.AddMetadataForEvents.change/0 forward server # [699409.147644] server mobilizon_ctl[536]: 16:50:23.868 [info] alter table events server # [699409.148676] server mobilizon_ctl[536]: 16:50:23.869 [info] == Migrated 20210805142745 in 0.0s server # [699409.155607] server mobilizon_ctl[536]: 16:50:23.876 [info] == Running 20210819161507 Mobilizon.Storage.Repo.Migrations.AddLanguageToEntities.change/0 forward server # [699409.155937] server mobilizon_ctl[536]: 16:50:23.877 [info] alter table events server # [699409.157347] server mobilizon_ctl[536]: 16:50:23.878 [info] alter table comments server # [699409.158604] server mobilizon_ctl[536]: 16:50:23.879 [info] alter table posts server # [699409.160355] server mobilizon_ctl[536]: 16:50:23.881 [info] == Migrated 20210819161507 in 0.0s server # [699409.168027] server mobilizon_ctl[536]: 16:50:23.889 [info] == Running 20211001101902 Mobilizon.Repo.Migrations.CreateExports.change/0 forward server # [699409.168303] server mobilizon_ctl[536]: 16:50:23.889 [info] create table exports server # [699409.171360] server mobilizon_ctl[536]: 16:50:23.892 [info] create index exports_file_path_index server # [699409.172999] server mobilizon_ctl[536]: 16:50:23.893 [info] == Migrated 20211001101902 in 0.0s server # [699409.182876] server mobilizon_ctl[536]: 16:50:23.903 [info] == Running 20211008084901 Mobilizon.Storage.Repo.Migrations.AddTimezoneToAddresses.change/0 forward server # [699409.183044] server mobilizon_ctl[536]: 16:50:23.903 [info] alter table addresses server # [699409.183722] server mobilizon_ctl[536]: 16:50:23.904 [info] == Migrated 20211008084901 in 0.0s server # [699409.190026] server mobilizon_ctl[536]: 16:50:23.911 [info] == Running 20211013090405 Mobilizon.Storage.Repo.Migrations.AddCodeToParticipants.change/0 forward server # [699409.190236] server mobilizon_ctl[536]: 16:50:23.911 [info] alter table participants server # [699409.191196] server mobilizon_ctl[536]: 16:50:23.912 [info] == Migrated 20211013090405 in 0.0s server # [699409.194375] server mobilizon_ctl[536]: 16:50:23.915 [info] == Running 20211022093530 Mobilizon.Storage.Repo.Migrations.AddNotifyToFollowers.change/0 forward server # [699409.194495] server mobilizon_ctl[536]: 16:50:23.915 [info] alter table followers server # [699409.196168] server mobilizon_ctl[536]: 16:50:23.917 [info] == Migrated 20211022093530 in 0.0s server # [699409.201858] server mobilizon_ctl[536]: 16:50:23.923 [info] == Running 20211223141104 Mobilizon.Storage.Repo.Migrations.AddInstanceMaterializedView.up/0 forward server # [699409.204500] server mobilizon_ctl[536]: 16:50:23.925 [info] execute "CREATE MATERIALIZED VIEW instances AS\nSELECT\n a.domain,\n COUNT(DISTINCT(p.id)) AS person_count,\n COUNT(DISTINCT(g.id)) AS group_count,\n COUNT(DISTINCT(e.id)) AS event_count,\n COUNT(f1.id) AS followers_count,\n COUNT(f2.id) AS followings_count,\n COUNT(r.id) AS reports_count,\n SUM(COALESCE((m.file->>'size')::int, 0)) AS media_size\nFROM actors a\nLEFT JOIN actors p ON a.id = p.id AND p.type = 'Person'\nLEFT JOIN actors g ON a.id = g.id AND g.type = 'Group'\nLEFT JOIN events e ON a.id = e.organizer_actor_id\nLEFT JOIN followers f1 ON a.id = f1.actor_id\nLEFT JOIN followers f2 ON a.id = f2.target_actor_id\nLEFT JOIN reports r ON r.reported_id = a.id\nLEFT JOIN medias m ON m.actor_id = a.id\nWHERE a.domain IS NOT NULL\nGROUP BY a.domain;\n" server # [699409.218017] server mobilizon_ctl[536]: 16:50:23.939 [info] execute "CREATE OR REPLACE FUNCTION refresh_instances()\nRETURNS trigger AS $$\nBEGIN\n REFRESH MATERIALIZED VIEW instances;\n RETURN NULL;\nEND;\n$$ LANGUAGE plpgsql;\n" server # [699409.218639] server mobilizon_ctl[536]: 16:50:23.939 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger ON actors;\n" server # [699409.219084] server mobilizon_ctl[536]: 16:50:23.940 [info] trigger "refresh_instances_trigger" for relation "actors" does not exist, skipping server # [699409.219084] server mobilizon_ctl[536]: 16:50:23.940 [info] execute "CREATE TRIGGER refresh_instances_trigger\nAFTER INSERT OR UPDATE OR DELETE\nON actors\nFOR EACH STATEMENT\nEXECUTE PROCEDURE refresh_instances();\n" server # [699409.219611] server mobilizon_ctl[536]: 16:50:23.940 [info] create index if not exists instances_domain_index server # [699409.222952] server mobilizon_ctl[536]: 16:50:23.943 [info] == Migrated 20211223141104 in 0.0s server # [699409.232592] server mobilizon_ctl[536]: 16:50:23.953 [info] == Running 20220321154138 Mobilizon.Storage.Repo.Migrations.CreateObanPeers.up/0 forward server # [699409.234429] server mobilizon_ctl[536]: 16:50:23.955 [info] == Migrated 20220321154138 in 0.0s server # [699409.239566] server mobilizon_ctl[536]: 16:50:23.960 [info] == Running 20220321154142 Mobilizon.Storage.Repo.Migrations.SwapPrimaryObanIndexes.change/0 forward server # [699409.239852] server mobilizon_ctl[536]: 16:50:23.960 [info] create index if not exists public.oban_jobs_state_queue_priority_scheduled_at_id_index server # [699409.241138] server mobilizon_ctl[536]: 16:50:23.962 [info] relation "oban_jobs_state_queue_priority_scheduled_at_id_index" already exists, skipping server # [699409.241138] server mobilizon_ctl[536]: 16:50:23.962 [info] drop index if exists public.oban_jobs_queue_state_priority_scheduled_at_id_index server # [699409.241848] server mobilizon_ctl[536]: 16:50:23.962 [info] index "oban_jobs_queue_state_priority_scheduled_at_id_index" does not exist, skipping server # [699409.242063] server mobilizon_ctl[536]: 16:50:23.963 [info] == Migrated 20220321154142 in 0.0s server # [699409.247774] server mobilizon_ctl[536]: 16:50:23.968 [info] == Running 20220328153640 Mobilizon.Storage.Repo.Migrations.SetAllEventsCategoryToMeeting.up/0 forward server # [699409.247774] server mobilizon_ctl[536]: 16:50:23.969 [info] execute "UPDATE events SET category = 'MEETING'" server # [699409.248906] server mobilizon_ctl[536]: 16:50:23.969 [info] == Migrated 20220328153640 in 0.0s server # [699409.256037] server mobilizon_ctl[536]: 16:50:23.977 [info] == Running 20220407083712 Mobilizon.Storage.Repo.Migrations.AddIndexesToAddresses.up/0 forward server # [699409.256336] server mobilizon_ctl[536]: 16:50:23.977 [info] create index if not exists idx_addresses_geom_x server # [699409.258216] server mobilizon_ctl[536]: 16:50:23.979 [info] create index if not exists idx_addresses_geom_y server # [699409.259719] server mobilizon_ctl[536]: 16:50:23.980 [info] == Migrated 20220407083712 in 0.0s server # [699409.267264] server mobilizon_ctl[536]: 16:50:23.988 [info] == Running 20220505091224 Mobilizon.Storage.Repo.Migrations.ChangeRefreshInstanceTriggerToOnlyExecuteOnRelays.up/0 forward server # [699409.267473] server mobilizon_ctl[536]: 16:50:23.988 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger ON actors;\n" server # [699409.268361] server mobilizon_ctl[536]: 16:50:23.989 [info] execute "CREATE TRIGGER refresh_instances_trigger_new\nAFTER INSERT OR UPDATE\nON actors\nFOR EACH ROW\nWHEN (NEW.preferred_username = 'relay')\nEXECUTE PROCEDURE refresh_instances();\n" server # [699409.269438] server mobilizon_ctl[536]: 16:50:23.990 [info] execute "CREATE TRIGGER refresh_instances_trigger_old\nAFTER DELETE\nON actors\nFOR EACH ROW\nWHEN (OLD.preferred_username = 'relay')\nEXECUTE PROCEDURE refresh_instances();\n" server # [699409.270290] server mobilizon_ctl[536]: 16:50:23.991 [info] == Migrated 20220505091224 in 0.0s server # [699409.276633] server mobilizon_ctl[536]: 16:50:23.997 [info] == Running 20220506105150 Mobilizon.Storage.Repo.Migrations.RemoveRefreshInstanceTriggers.up/0 forward server # [699409.276843] server mobilizon_ctl[536]: 16:50:23.997 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger_new ON actors;\n" server # [699409.277646] server mobilizon_ctl[536]: 16:50:23.998 [info] execute "DROP TRIGGER IF EXISTS refresh_instances_trigger_old ON actors;\n" server # [699409.278494] server mobilizon_ctl[536]: 16:50:23.999 [info] == Migrated 20220506105150 in 0.0s server # [699409.286071] server mobilizon_ctl[536]: 16:50:24.007 [info] == Running 20230208101626 Mobilizon.Repo.Migrations.CreateApplications.change/0 forward server # [699409.286374] server mobilizon_ctl[536]: 16:50:24.007 [info] create table applications server # [699409.289850] server mobilizon_ctl[536]: 16:50:24.010 [info] create index applications_owner_id_owner_type_index server # [699409.291389] server mobilizon_ctl[536]: 16:50:24.012 [info] == Migrated 20230208101626 in 0.0s server # [699409.298606] server mobilizon_ctl[536]: 16:50:24.019 [info] == Running 20230215125801 Mobilizon.Repo.Migrations.CreateApplicationTokens.change/0 forward server # [699409.298862] server mobilizon_ctl[536]: 16:50:24.020 [info] create table application_tokens server # [699409.305977] server mobilizon_ctl[536]: 16:50:24.026 [info] create index application_tokens_user_id_application_id_index server # [699409.307166] server mobilizon_ctl[536]: 16:50:24.028 [info] == Migrated 20230215125801 in 0.0s server # [699409.314198] server mobilizon_ctl[536]: 16:50:24.035 [info] == Running 20230217084253 Mobilizon.Repo.Migrations.CreateApplicationDeviceActivation.change/0 forward server # [699409.314682] server mobilizon_ctl[536]: 16:50:24.035 [info] create table application_device_activation server # [699409.319872] server mobilizon_ctl[536]: 16:50:24.040 [info] == Migrated 20230217084253 in 0.0s server # [699409.329565] server mobilizon_ctl[536]: 16:50:24.050 [info] == Running 20230605143534 Mobilizon.Storage.Repo.Migrations.AllowMultipleEventsToBeReported.up/0 forward server # [699409.329973] server mobilizon_ctl[536]: 16:50:24.051 [info] create table reports_events server # [699409.332367] server mobilizon_ctl[536]: 16:50:24.053 [info] == Migrated 20230605143534 in 0.0s server # [699409.341382] server mobilizon_ctl[536]: 16:50:24.062 [info] == Running 20230605153836 Mobilizon.Storage.Repo.Migrations.BackfillReportEventsWithOldEvents.up/0 forward server # [699409.342282] server mobilizon_ctl[536]: 16:50:24.063 [info] == Migrated 20230605153836 in 0.0s server # [699409.347990] server mobilizon_ctl[536]: 16:50:24.069 [info] == Running 20230605154106 Mobilizon.Storage.Repo.Migrations.RemoveObsoleteEventIdOnReports.up/0 forward server # [699409.348121] server mobilizon_ctl[536]: 16:50:24.069 [info] alter table reports server # [699409.349151] server mobilizon_ctl[536]: 16:50:24.070 [info] == Migrated 20230605154106 in 0.0s server # [699409.356701] server mobilizon_ctl[536]: 16:50:24.077 [info] == Running 20230831153358 Mobilizon.Storage.Repo.Migrations.RemoveOnDeleteCascadeForReports.up/0 forward server # [699409.357273] server mobilizon_ctl[536]: 16:50:24.078 [info] execute "DROP MATERIALIZED VIEW IF EXISTS instances;\n" server # [699409.359967] server mobilizon_ctl[536]: 16:50:24.081 [info] drop constraint reports_reported_id_fkey from table reports server # [699409.361309] server mobilizon_ctl[536]: 16:50:24.082 [info] drop constraint reports_reporter_id_fkey from table reports server # [699409.362284] server mobilizon_ctl[536]: 16:50:24.083 [info] drop constraint reports_manager_id_fkey from table reports server # [699409.363398] server mobilizon_ctl[536]: 16:50:24.084 [info] alter table reports server # [699409.366290] server mobilizon_ctl[536]: 16:50:24.087 [info] drop constraint report_notes_moderator_id_fkey from table report_notes server # [699409.367073] server mobilizon_ctl[536]: 16:50:24.088 [info] alter table report_notes server # [699409.368916] server mobilizon_ctl[536]: 16:50:24.090 [info] execute "CREATE MATERIALIZED VIEW instances AS\nSELECT\n a.domain,\n COUNT(DISTINCT(p.id)) AS person_count,\n COUNT(DISTINCT(g.id)) AS group_count,\n COUNT(DISTINCT(e.id)) AS event_count,\n COUNT(f1.id) AS followers_count,\n COUNT(f2.id) AS followings_count,\n COUNT(r.id) AS reports_count,\n SUM(COALESCE((m.file->>'size')::int, 0)) AS media_size\nFROM actors a\nLEFT JOIN actors p ON a.id = p.id AND p.type = 'Person'\nLEFT JOIN actors g ON a.id = g.id AND g.type = 'Group'\nLEFT JOIN events e ON a.id = e.organizer_actor_id\nLEFT JOIN followers f1 ON a.id = f1.actor_id\nLEFT JOIN followers f2 ON a.id = f2.target_actor_id\nLEFT JOIN reports r ON r.reported_id = a.id\nLEFT JOIN medias m ON m.actor_id = a.id\nWHERE a.domain IS NOT NULL\nGROUP BY a.domain;\n" server # [699409.391048] server mobilizon_ctl[536]: 16:50:24.105 [info] == Migrated 20230831153358 in 0.0s server # [699409.421224] server mobilizon_ctl[536]: 16:50:24.142 [info] == Running 20230901160000 Mobilizon.Storage.Repo.Migrations.AddExternalUrlForEvents.up/0 forward server # [699409.421224] server mobilizon_ctl[536]: 16:50:24.142 [info] alter table events server # [699409.422396] server mobilizon_ctl[536]: 16:50:24.143 [info] execute "ALTER TABLE events ALTER COLUMN join_options TYPE VARCHAR USING join_options::text" server # [699409.428256] server mobilizon_ctl[536]: 16:50:24.148 [info] execute "ALTER TABLE events ALTER COLUMN join_options DROP DEFAULT" server # [699409.429044] server mobilizon_ctl[536]: 16:50:24.150 [info] execute "DROP TYPE public.join_options" server # [699409.430978] server mobilizon_ctl[536]: 16:50:24.151 [info] execute "CREATE TYPE public.join_options AS ENUM ('free', 'restricted', 'invite', 'external')" server # [699409.431571] server mobilizon_ctl[536]: 16:50:24.152 [info] execute "ALTER TABLE events ALTER COLUMN join_options TYPE join_options USING join_options::join_options" server # [699409.436831] server mobilizon_ctl[536]: 16:50:24.157 [info] execute "ALTER TABLE events ALTER COLUMN join_options SET DEFAULT 'free'::join_options" server # [699409.437689] server mobilizon_ctl[536]: 16:50:24.158 [info] == Migrated 20230901160000 in 0.0s server # [699409.466841] server mobilizon_ctl[536]: 16:50:24.188 [info] == Running 20230920071502 Mobilizon.Storage.Repo.Migrations.AddActorConversations.up/0 forward server # [699409.467142] server mobilizon_ctl[536]: 16:50:24.188 [info] create table conversations server # [699409.473416] server mobilizon_ctl[536]: 16:50:24.194 [info] create table conversation_participants server # [699409.476251] server mobilizon_ctl[536]: 16:50:24.197 [info] alter table comments server # [699409.477759] server mobilizon_ctl[536]: 16:50:24.198 [info] == Migrated 20230920071502 in 0.0s server # [699409.502132] server mobilizon_ctl[536]: 16:50:24.223 [info] == Running 20231220092536 Mobilizon.Storage.Repo.Migrations.AddActorInstances.change/0 forward server # [699409.502479] server mobilizon_ctl[536]: 16:50:24.223 [info] create table instance_actors server # [699409.506150] server mobilizon_ctl[536]: 16:50:24.227 [info] create index instance_actors_domain_index server # [699409.507451] server mobilizon_ctl[536]: 16:50:24.228 [info] == Migrated 20231220092536 in 0.0s server # [699409.528090] server mobilizon_ctl[536]: 16:50:24.248 [info] == Running 20240104103036 Mobilizon.Storage.Repo.Migrations.ChangeActorInstanceDescriptionTypeToText.up/0 forward server # [699409.528531] server mobilizon_ctl[536]: 16:50:24.249 [info] alter table instance_actors server # [699409.532700] server mobilizon_ctl[536]: 16:50:24.253 [info] == Migrated 20240104103036 in 0.0s server # [699409.540870] server mobilizon_ctl[536]: 16:50:24.262 [info] == Running 20240222121054 Mobilizon.Storage.Repo.Migrations.CreateAdminSettingsMedias.change/0 forward server # [699409.541157] server mobilizon_ctl[536]: 16:50:24.262 [info] create table admin_settings_medias server # [699409.544969] server mobilizon_ctl[536]: 16:50:24.266 [info] create index admin_settings_medias_group_name_index server # [699409.546128] server mobilizon_ctl[536]: 16:50:24.267 [info] == Migrated 20240222121054 in 0.0s server # [699409.559901] server mobilizon_ctl[536]: 16:50:24.281 [info] == Running 20240725130410 Mobilizon.Storage.Repo.Migrations.AddEventPhysicalAddressIndex.up/0 forward server # [699409.560295] server mobilizon_ctl[536]: 16:50:24.281 [info] create index events_phys_addr_id server # [699409.564086] server mobilizon_ctl[536]: 16:50:24.283 [info] == Migrated 20240725130410 in 0.0s server # [699409.575257] server mobilizon_ctl[536]: 16:50:24.296 [info] == Running 20250521145952 Mobilizon.Storage.Repo.Migrations.AddUuidToMedia.change/0 forward server # [699409.575420] server mobilizon_ctl[536]: 16:50:24.296 [info] alter table medias server # [699409.579181] server mobilizon_ctl[536]: 16:50:24.300 [info] create index medias_uuid_index server # [699409.580687] server mobilizon_ctl[536]: 16:50:24.301 [info] == Migrated 20250521145952 in 0.0s server # [699409.595346] server mobilizon_ctl[536]: 16:50:24.316 [info] == Running 20250911120910 Mobilizon.Storage.Repo.Migrations.AddModerationToUser.change/0 forward server # [699409.595579] server mobilizon_ctl[536]: 16:50:24.316 [info] alter table users server # [699409.598047] server mobilizon_ctl[536]: 16:50:24.318 [info] == Migrated 20250911120910 in 0.0s server # [699409.604752] server mobilizon_ctl[536]: 16:50:24.325 [info] == Running 20250919143627 Mobilizon.Storage.Repo.Migrations.UpdateRoleToUser.change/0 forward server # [699409.605035] server mobilizon_ctl[536]: 16:50:24.326 [info] execute "ALTER TYPE user_role ADD VALUE IF NOT EXISTS 'pending';" server # [699409.605453] server mobilizon_ctl[536]: 16:50:24.326 [info] enum label "pending" already exists, skipping server # [699409.605732] server mobilizon_ctl[536]: 16:50:24.326 [info] == Migrated 20250919143627 in 0.0s server # [699409.610744] server mobilizon_ctl[536]: 16:50:24.331 [info] == Running 20251027133219 Mobilizon.Storage.Repo.Migrations.CreateInvitations.change/0 forward server # [699409.610954] server mobilizon_ctl[536]: 16:50:24.332 [info] create table invitations server # [699409.615943] server mobilizon_ctl[536]: 16:50:24.337 [info] create index invitations_token_index server # [699409.616959] server mobilizon_ctl[536]: 16:50:24.338 [info] == Migrated 20251027133219 in 0.0s server # [699409.623838] server mobilizon_ctl[536]: 16:50:24.345 [info] == Running 20251111093015 Mobilizon.Storage.Repo.Migrations.AddAllowToGroup.change/0 forward server # [699409.624255] server mobilizon_ctl[536]: 16:50:24.345 [info] alter table actors server # [699409.625323] server mobilizon_ctl[536]: 16:50:24.346 [info] == Migrated 20251111093015 in 0.0s server # [699409.653145] server systemd[1]: Started Mobilizon federated organization and mobilization platform. server # [699409.653874] server systemd[1]: Reached target Multi-User System. server # [699409.654541] server systemd[1]: Startup finished in 16.940s. server: (finished: waiting for unit mobilizon.service, in 17.71 seconds) server: waiting for TCP port 41395 on localhost Connection to localhost (::1) 41395 port [tcp/*] succeeded! server: (finished: waiting for TCP port 41395 on localhost, in 4.07 seconds) server: must succeed: curl --fail https://acme.test/ % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 2289 100 2289 0 0 68608 0 0 server: (finished: must succeed: curl --fail https://acme.test/, in 0.05 seconds) (finished: run the VM test script, in 21.83 seconds) server # [699413.729120] server mobilizon[599]: 16:50:28.450 [info] No tzdata release files found in custom data dir. Copying release file from tzdata priv dir. server # [699413.846473] server mobilizon[599]: 16:50:28.566 [info] Source for database :city not found: "/var/lib/mobilizon/geo/GeoLite2-City.mmdb" server # [699413.893229] server mobilizon[599]: 16:50:28.614 [info] Loading 122 CA(s) from :otp store server # [699413.914743] server mobilizon[599]: 16:50:28.635 [info] Running Mobilizon.Web.Endpoint with Bandit 1.12.0 at ::1:41395 (http) server # [699413.916342] server mobilizon[599]: 16:50:28.636 [info] Access Mobilizon.Web.Endpoint at https://acme.test server # [699413.931508] server mobilizon[599]: 16:50:28.652 [info] {"message":"notifier only receiving messages from its own node, functionality may be degraded","source":"oban","event":"notifier:switch","connectivity_status":"solitary"} server # [699413.931790] server mobilizon[599]: 16:50:28.652 [info] {"message":"peer became leader","node":"mobilizon@server","source":"oban","event":"peer:election","leader":true,"was_leader":false} server # [699413.965995] server mobilizon[599]: 16:50:28.687 request_id=GNmKJ2anQtHinBAAAAAC [info] GET / server # [699413.970789] server mobilizon[599]: 16:50:28.691 request_id=GNmKJ2anQtHinBAAAAAC [info] Sent 200 in 4ms test script finished in 21.96s cleanup kill NspawnMachine (pid 50) Container server terminated by signal KILL. (finished: cleanup, in 0.16 seconds)