{"action":"opened","issue":{"url":"https://api.github.com/repos/Chocobozzz/PeerTube/issues/1204","repository_url":"https://api.github.com/repos/Chocobozzz/PeerTube","labels_url":"https://api.github.com/repos/Chocobozzz/PeerTube/issues/1204/labels{/name}","comments_url":"https://api.github.com/repos/Chocobozzz/PeerTube/issues/1204/comments","events_url":"https://api.github.com/repos/Chocobozzz/PeerTube/issues/1204/events","html_url":"https://github.com/Chocobozzz/PeerTube/issues/1204","id":367395824,"node_id":"MDU6SXNzdWUzNjczOTU4MjQ=","number":1204,"title":"Dev server isn't working","user":{"login":"Jorropo","id":24391983,"node_id":"MDQ6VXNlcjI0MzkxOTgz","avatar_url":"https://avatars1.githubusercontent.com/u/24391983?v=4","gravatar_id":"","url":"https://api.github.com/users/Jorropo","html_url":"https://github.com/Jorropo","followers_url":"https://api.github.com/users/Jorropo/followers","following_url":"https://api.github.com/users/Jorropo/following{/other_user}","gists_url":"https://api.github.com/users/Jorropo/gists{/gist_id}","starred_url":"https://api.github.com/users/Jorropo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Jorropo/subscriptions","organizations_url":"https://api.github.com/users/Jorropo/orgs","repos_url":"https://api.github.com/users/Jorropo/repos","events_url":"https://api.github.com/users/Jorropo/events{/privacy}","received_events_url":"https://api.github.com/users/Jorropo/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-10-05T23:12:06Z","updated_at":"2018-10-05T23:12:06Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"**What happened?**\r\nI was developing then I stop my dev server, cleaned with `yarn run danger:clean:dev`\r\nDev server fail when lunching at migration 5.\r\n\r\n**What do you expect to happen instead?**\r\nServer should start.\r\n\r\n**Steps to reproduce:**\r\n\r\n1.\r\nOn a git repo : start a dev server, what until full boot, then shutdown it.\r\n2.\r\nMake a `yarn run danger:clean:dev`\r\n3.\r\nRestart a dev server\r\n\r\n**Additional information**\r\n* PeerTube version or URL: 35d50b7dd26b3cf646b8845784927bb1ef18dfb3\r\n* NodeJS version: v8.11.3\r\n\r\n* Link to server log if useful (journalctl or /var/www/peertube/storage/logs/):\r\n```\r\n[1] [0] [nodemon] 1.18.4\r\n[1] [0] [nodemon] to restart at any time, enter `rs`\r\n[1] [0] [nodemon] watching: $HOME/Documents/Scripts/PeerTube/dist/**/*\r\n[1] [0] [nodemon] starting `node dist/server`\r\n[1] [0] (node:3205) Warning: N-API is an experimental feature and could change at any time.\r\n[1] [0] [localhost:9000] 2018-10-06 01:04:59.642 debug: Executed (default): SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_type LIKE '%TABLE' AND table_name != 'spatial_ref_sys'; | 6ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:04:59.826 debug: Executed (default): SELECT true AS enabled FROM pg_available_extensions WHERE name = 'pg_trgm' AND installed_version IS NOT NULL; | 21ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:04:59.831 debug: Executed (default): SELECT true AS enabled FROM pg_available_extensions WHERE name = 'unaccent' AND installed_version IS NOT NULL; | 0ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:04:59.846 debug: Executed (default): CREATE OR REPLACE FUNCTION immutable_unaccent(text)\r\n[1] [0]   RETURNS text AS\r\n[1] [0] $func$\r\n[1] [0] SELECT public.unaccent('public.unaccent', $1::text)\r\n[1] [0] $func$  LANGUAGE sql IMMUTABLE; | 11ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:04:59.848 info: Database peertube_dev is ready.\r\n[1] [0] [localhost:9000] 2018-10-06 01:04:59.920 debug: Executed (default): CREATE TABLE IF NOT EXISTS \"application\" (\"id\"   SERIAL , \"migrationVersion\" INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (\"id\")); | 51ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:04:59.926 debug: Executed (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'application' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname; | 4ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:04:59.978 debug: Executed (default): CREATE TABLE IF NOT EXISTS \"avatar\" (\"id\"   SERIAL , \"filename\" VARCHAR(255) NOT NULL, \"createdAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"updatedAt\" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY (\"id\")); | 46ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:04:59.982 debug: Executed (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'avatar' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname; | 2ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.029 debug: Executed (default): CREATE TABLE IF NOT EXISTS \"server\" (\"id\"   SERIAL , \"host\" VARCHAR(255) NOT NULL, \"redundancyAllowed\" BOOLEAN NOT NULL DEFAULT false, \"createdAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"updatedAt\" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY (\"id\")); | 40ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.033 debug: Executed (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'server' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname; | 2ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.082 debug: Executed (default): CREATE UNIQUE INDEX \"server_host\" ON \"server\" (\"host\") | 41ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.090 debug: Executed (default): SELECT t.typname enum_name, array_agg(e.enumlabel ORDER BY enumsortorder) enum_value FROM pg_type t JOIN pg_enum e ON t.oid = e.enumtypid JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace WHERE n.nspname = 'public' AND t.typname='enum_actor_type' GROUP BY 1 | 2ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.117 debug: Executed (default): CREATE TYPE \"public\".\"enum_actor_type\" AS ENUM('Group', 'Person', 'Application'); | 17ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.121 debug: Executed (default): SELECT typname, typtype, oid, typarray FROM pg_type WHERE (typtype = 'b' AND typname IN ('hstore', 'geometry', 'geography')) OR (typtype = 'e') | 1ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.196 debug: Executed (default): CREATE TABLE IF NOT EXISTS \"actor\" (\"id\"   SERIAL , \"type\" \"public\".\"enum_actor_type\" NOT NULL, \"uuid\" UUID NOT NULL, \"preferredUsername\" VARCHAR(255) NOT NULL, \"url\" VARCHAR(2000) NOT NULL, \"publicKey\" VARCHAR(5000), \"privateKey\" VARCHAR(5000), \"followersCount\" INTEGER NOT NULL, \"followingCount\" INTEGER NOT NULL, \"inboxUrl\" VARCHAR(2000) NOT NULL, \"outboxUrl\" VARCHAR(2000) NOT NULL, \"sharedInboxUrl\" VARCHAR(2000) NOT NULL, \"followersUrl\" VARCHAR(2000) NOT NULL, \"followingUrl\" VARCHAR(2000) NOT NULL, \"avatarId\" INTEGER REFERENCES \"avatar\" (\"id\") ON DELETE SET NULL ON UPDATE CASCADE, \"serverId\" INTEGER REFERENCES \"server\" (\"id\") ON DELETE CASCADE ON UPDATE CASCADE, \"createdAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"updatedAt\" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY (\"id\")); | 71ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.200 debug: Executed (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'actor' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname; | 2ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.250 debug: Executed (default): CREATE UNIQUE INDEX \"actor_url\" ON \"actor\" (\"url\") | 30ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.330 debug: Executed (default): CREATE UNIQUE INDEX \"actor_preferred_username_server_id\" ON \"actor\" (\"preferredUsername\", \"serverId\") | 76ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.361 debug: Executed (default): CREATE INDEX \"actor_shared_inbox_url\" ON \"actor\" (\"sharedInboxUrl\") | 95ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.392 debug: Executed (default): CREATE INDEX \"actor_inbox_url_shared_inbox_url\" ON \"actor\" (\"inboxUrl\", \"sharedInboxUrl\") | 126ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.441 debug: Executed (default): CREATE INDEX \"actor_avatar_id\" ON \"actor\" (\"avatarId\") | 129ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.447 debug: Executed (default): CREATE INDEX \"actor_server_id\" ON \"actor\" (\"serverId\") | 135ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.455 debug: Executed (default): CREATE UNIQUE INDEX \"actor_uuid\" ON \"actor\" (\"uuid\") | 124ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.457 debug: Executed (default): CREATE INDEX \"actor_followers_url\" ON \"actor\" (\"followersUrl\") | 95ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.472 debug: Executed (default): SELECT t.typname enum_name, array_agg(e.enumlabel ORDER BY enumsortorder) enum_value FROM pg_type t JOIN pg_enum e ON t.oid = e.enumtypid JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace WHERE n.nspname = 'public' AND t.typname='enum_actorFollow_state' GROUP BY 1 | 1ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.479 debug: Executed (default): CREATE TYPE \"public\".\"enum_actorFollow_state\" AS ENUM('pending', 'accepted'); | 5ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.481 debug: Executed (default): SELECT typname, typtype, oid, typarray FROM pg_type WHERE (typtype = 'b' AND typname IN ('hstore', 'geometry', 'geography')) OR (typtype = 'e') | 1ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.538 debug: Executed (default): CREATE TABLE IF NOT EXISTS \"actorFollow\" (\"id\"   SERIAL , \"state\" \"public\".\"enum_actorFollow_state\" NOT NULL, \"score\" INTEGER NOT NULL DEFAULT 20, \"actorId\" INTEGER NOT NULL REFERENCES \"actor\" (\"id\") ON DELETE CASCADE ON UPDATE CASCADE, \"targetActorId\" INTEGER NOT NULL REFERENCES \"actor\" (\"id\") ON DELETE CASCADE ON UPDATE CASCADE, \"createdAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"updatedAt\" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY (\"id\")); | 54ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.547 debug: Executed (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'actorFollow' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname; | 8ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.605 debug: Executed (default): CREATE UNIQUE INDEX \"actor_follow_actor_id_target_actor_id\" ON \"actorFollow\" (\"actorId\", \"targetActorId\") | 53ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.613 debug: Executed (default): CREATE INDEX \"actor_follow_target_actor_id\" ON \"actorFollow\" (\"targetActorId\") | 62ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.613 debug: Executed (default): CREATE INDEX \"actor_follow_score\" ON \"actorFollow\" (\"score\") | 61ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.614 debug: Executed (default): CREATE INDEX \"actor_follow_actor_id\" ON \"actorFollow\" (\"actorId\") | 63ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.620 debug: Executed (default): SELECT t.typname enum_name, array_agg(e.enumlabel ORDER BY enumsortorder) enum_value FROM pg_type t JOIN pg_enum e ON t.oid = e.enumtypid JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace WHERE n.nspname = 'public' AND t.typname='enum_user_nsfwPolicy' GROUP BY 1 | 2ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.631 debug: Executed (default): CREATE TYPE \"public\".\"enum_user_nsfwPolicy\" AS ENUM('do_not_list', 'blur', 'display'); | 7ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.642 debug: Executed (default): SELECT typname, typtype, oid, typarray FROM pg_type WHERE (typtype = 'b' AND typname IN ('hstore', 'geometry', 'geography')) OR (typtype = 'e') | 2ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.730 debug: Executed (default): CREATE TABLE IF NOT EXISTS \"user\" (\"id\"   SERIAL , \"password\" VARCHAR(255) NOT NULL, \"username\" VARCHAR(255) NOT NULL, \"email\" VARCHAR(400) NOT NULL, \"emailVerified\" BOOLEAN DEFAULT NULL, \"nsfwPolicy\" \"public\".\"enum_user_nsfwPolicy\" NOT NULL, \"autoPlayVideo\" BOOLEAN NOT NULL DEFAULT true, \"blocked\" BOOLEAN NOT NULL DEFAULT false, \"blockedReason\" VARCHAR(255) DEFAULT NULL, \"role\" INTEGER NOT NULL, \"videoQuota\" BIGINT NOT NULL, \"videoQuotaDaily\" BIGINT NOT NULL, \"createdAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"updatedAt\" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY (\"id\")); | 80ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.735 debug: Executed (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'user' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname; | 1ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.789 debug: Executed (default): CREATE UNIQUE INDEX \"user_email\" ON \"user\" (\"email\") | 51ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.797 debug: Executed (default): CREATE UNIQUE INDEX \"user_username\" ON \"user\" (\"username\") | 59ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.897 debug: Executed (default): CREATE TABLE IF NOT EXISTS \"account\" (\"id\"   SERIAL , \"name\" VARCHAR(255) NOT NULL, \"description\" VARCHAR(255) DEFAULT NULL, \"actorId\" INTEGER REFERENCES \"actor\" (\"id\") ON DELETE CASCADE ON UPDATE CASCADE, \"userId\" INTEGER REFERENCES \"user\" (\"id\") ON DELETE CASCADE ON UPDATE CASCADE, \"applicationId\" INTEGER REFERENCES \"application\" (\"id\") ON DELETE CASCADE ON UPDATE CASCADE, \"createdAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"updatedAt\" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY (\"id\")); | 97ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.900 debug: Executed (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'account' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname; | 2ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.964 debug: Executed (default): CREATE INDEX \"account_user_id\" ON \"account\" (\"userId\") | 61ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.972 debug: Executed (default): CREATE INDEX \"account_application_id\" ON \"account\" (\"applicationId\") | 70ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:00.973 debug: Executed (default): CREATE UNIQUE INDEX \"account_actor_id\" ON \"account\" (\"actorId\") | 71ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.064 debug: Executed (default): CREATE TABLE IF NOT EXISTS \"oAuthClient\" (\"id\"   SERIAL , \"clientId\" VARCHAR(255) NOT NULL, \"clientSecret\" VARCHAR(255) NOT NULL, \"grants\" VARCHAR(255)[], \"redirectUris\" VARCHAR(255)[], \"createdAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"updatedAt\" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY (\"id\")); | 87ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.068 debug: Executed (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'oAuthClient' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname; | 3ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.131 debug: Executed (default): CREATE UNIQUE INDEX \"o_auth_client_client_id_client_secret\" ON \"oAuthClient\" (\"clientId\", \"clientSecret\") | 60ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.131 debug: Executed (default): CREATE UNIQUE INDEX \"o_auth_client_client_id\" ON \"oAuthClient\" (\"clientId\") | 61ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.239 debug: Executed (default): CREATE TABLE IF NOT EXISTS \"oAuthToken\" (\"id\"   SERIAL , \"accessToken\" VARCHAR(255) NOT NULL, \"accessTokenExpiresAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"refreshToken\" VARCHAR(255) NOT NULL, \"refreshTokenExpiresAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"userId\" INTEGER NOT NULL REFERENCES \"user\" (\"id\") ON DELETE CASCADE ON UPDATE CASCADE, \"oAuthClientId\" INTEGER REFERENCES \"oAuthClient\" (\"id\") ON DELETE CASCADE ON UPDATE CASCADE, \"createdAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"updatedAt\" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY (\"id\")); | 104ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.245 debug: Executed (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'oAuthToken' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname; | 2ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.347 debug: Executed (default): CREATE INDEX \"o_auth_token_o_auth_client_id\" ON \"oAuthToken\" (\"oAuthClientId\") | 97ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.348 debug: Executed (default): CREATE INDEX \"o_auth_token_user_id\" ON \"oAuthToken\" (\"userId\") | 99ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.349 debug: Executed (default): CREATE UNIQUE INDEX \"o_auth_token_access_token\" ON \"oAuthToken\" (\"accessToken\") | 99ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.349 debug: Executed (default): CREATE UNIQUE INDEX \"o_auth_token_refresh_token\" ON \"oAuthToken\" (\"refreshToken\") | 101ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.406 debug: Executed (default): CREATE TABLE IF NOT EXISTS \"tag\" (\"id\"   SERIAL , \"name\" VARCHAR(255) NOT NULL, PRIMARY KEY (\"id\")); | 53ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.409 debug: Executed (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'tag' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname; | 2ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.481 debug: Executed (default): CREATE UNIQUE INDEX \"tag_name\" ON \"tag\" (\"name\") | 70ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.598 debug: Executed (default): CREATE TABLE IF NOT EXISTS \"videoChannel\" (\"id\"   SERIAL , \"name\" VARCHAR(255) NOT NULL, \"description\" VARCHAR(500) DEFAULT NULL, \"support\" VARCHAR(500) DEFAULT NULL, \"actorId\" INTEGER REFERENCES \"actor\" (\"id\") ON DELETE CASCADE ON UPDATE CASCADE, \"accountId\" INTEGER NOT NULL REFERENCES \"account\" (\"id\") ON DELETE CASCADE ON UPDATE CASCADE, \"createdAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"updatedAt\" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY (\"id\")); | 114ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.601 debug: Executed (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'videoChannel' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname; | 2ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.662 debug: Executed (default): CREATE INDEX \"video_channel_name_trigram\" ON \"videoChannel\" USING gin (lower(immutable_unaccent(name)) gin_trgm_ops) | 57ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.665 debug: Executed (default): CREATE INDEX \"video_channel_actor_id\" ON \"videoChannel\" (\"actorId\") | 60ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.673 debug: Executed (default): CREATE INDEX \"video_channel_account_id\" ON \"videoChannel\" (\"accountId\") | 69ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.757 debug: Executed (default): CREATE TABLE IF NOT EXISTS \"video\" (\"id\"   SERIAL , \"uuid\" UUID NOT NULL, \"name\" VARCHAR(255) NOT NULL, \"category\" INTEGER DEFAULT NULL, \"licence\" INTEGER DEFAULT NULL, \"language\" VARCHAR(10) DEFAULT NULL, \"privacy\" INTEGER NOT NULL, \"nsfw\" BOOLEAN NOT NULL, \"description\" VARCHAR(10000) DEFAULT NULL, \"support\" VARCHAR(500) DEFAULT NULL, \"duration\" INTEGER NOT NULL, \"views\" INTEGER NOT NULL DEFAULT 0, \"likes\" INTEGER NOT NULL DEFAULT 0, \"dislikes\" INTEGER NOT NULL DEFAULT 0, \"remote\" BOOLEAN NOT NULL, \"url\" VARCHAR(2000) NOT NULL, \"commentsEnabled\" BOOLEAN NOT NULL, \"waitTranscoding\" BOOLEAN NOT NULL, \"state\" INTEGER NOT NULL DEFAULT NULL, \"publishedAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"channelId\" INTEGER NOT NULL REFERENCES \"videoChannel\" (\"id\") ON DELETE CASCADE ON UPDATE CASCADE, \"createdAt\" TIMESTAMP WITH TIME ZONE NOT NULL, \"updatedAt\" TIMESTAMP WITH TIME ZONE NOT NULL, PRIMARY KEY (\"id\")); | 76ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.762 debug: Executed (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'video' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname; | 0ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.823 debug: Executed (default): CREATE INDEX \"video_name_trigram\" ON \"video\" USING gin (lower(immutable_unaccent(name)) gin_trgm_ops) | 51ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.859 debug: Executed (default): CREATE INDEX \"video_wait_transcoding\" ON \"video\" (\"waitTranscoding\") | 90ms\r\n[1] [0] [nodemon] restarting due to changes...\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.884 debug: Executed (default): CREATE INDEX \"video_category\" ON \"video\" (\"category\") | 102ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.919 debug: Executed (default): CREATE INDEX \"video_duration\" ON \"video\" (\"duration\") | 137ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:01.920 debug: Executed (default): CREATE INDEX \"video_published_at\" ON \"video\" (\"publishedAt\") | 140ms\r\n[1] [0] [nodemon] starting `node dist/server`\r\n[1] [1] \r\n[1] [1] 01:05:02 - Found 0 errors. Watching for file changes.\r\n[1] [0] (node:3300) Warning: N-API is an experimental feature and could change at any time.\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:04.463 debug: Executed (default): SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_type LIKE '%TABLE' AND table_name != 'spatial_ref_sys'; | 1ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:04.468 debug: Executed (default): SELECT \"migrationVersion\" FROM \"application\" | 0ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:04.483 debug: Executed (default): INSERT INTO \"application\" (\"migrationVersion\") VALUES (0) | 11ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:04.483 info: Begin migrations.\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:04.487 info: Executing 0005-email-pod.js migration script.\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:04.491 debug: Executed (0d3a2a92-c651-45f5-9b85-d85f63014a52): START TRANSACTION; | 0ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:04.500 debug: Executed (0d3a2a92-c651-45f5-9b85-d85f63014a52): SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE; | 7ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:04.543 debug: Executed (0d3a2a92-c651-45f5-9b85-d85f63014a52): ROLLBACK; | 5ms\r\n[1] [0] [localhost:9000] 2018-10-06 01:05:04.544 error: Cannot execute migration 0005. {\r\n[1] [0]   \"meta\": {\r\n[1] [0]     \"err\": {\r\n[1] [0]       \"stack\": \"SequelizeDatabaseError: la relation « public.Pods » n'existe pas\\n    at Query.formatError ($HOME/Documents/Scripts/PeerTube/node_modules/sequelize/lib/dialects/postgres/query.js:363:16)\\n    at query.catch.err ($HOME/Documents/Scripts/PeerTube/node_modules/sequelize/lib/dialects/postgres/query.js:86:18)\\n    at tryCatcher ($HOME/Documents/Scripts/PeerTube/node_modules/bluebird/js/release/util.js:16:23)\\n    at Promise._settlePromiseFromHandler ($HOME/Documents/Scripts/PeerTube/node_modules/bluebird/js/release/promise.js:512:31)\\n    at Promise._settlePromise ($HOME/Documents/Scripts/PeerTube/node_modules/bluebird/js/release/promise.js:569:18)\\n    at Promise._settlePromise0 ($HOME/Documents/Scripts/PeerTube/node_modules/bluebird/js/release/promise.js:614:10)\\n    at Promise._settlePromises ($HOME/Documents/Scripts/PeerTube/node_modules/bluebird/js/release/promise.js:690:18)\\n    at _drainQueueStep ($HOME/Documents/Scripts/PeerTube/node_modules/bluebird/js/release/async.js:138:12)\\n    at _drainQueue ($HOME/Documents/Scripts/PeerTube/node_modules/bluebird/js/release/async.js:131:9)\\n    at Async._drainQueues ($HOME/Documents/Scripts/PeerTube/node_modules/bluebird/js/release/async.js:147:5)\\n    at Immediate.Async.drainQueues ($HOME/Documents/Scripts/PeerTube/node_modules/bluebird/js/release/async.js:17:14)\\n    at runCallback (timers.js:810:20)\\n    at tryOnImmediate (timers.js:768:5)\\n    at processImmediate [as _immediateCallback] (timers.js:745:5)\",\r\n[1] [0]       \"message\": \"la relation « public.Pods » n'existe pas\",\r\n[1] [0]       \"name\": \"SequelizeDatabaseError\",\r\n[1] [0]       \"parent\": {\r\n[1] [0]         \"stack\": \"error: la relation « public.Pods » n'existe pas\\n    at Connection.parseE ($HOME/Documents/Scripts/PeerTube/node_modules/pg/lib/connection.js:553:11)\\n    at Connection.parseMessage ($HOME/Documents/Scripts/PeerTube/node_modules/pg/lib/connection.js:378:19)\\n    at Socket.<anonymous> ($HOME/Documents/Scripts/PeerTube/node_modules/pg/lib/connection.js:119:22)\\n    at emitOne (events.js:116:13)\\n    at Socket.emit (events.js:211:7)\\n    at addChunk (_stream_readable.js:263:12)\\n    at readableAddChunk (_stream_readable.js:250:11)\\n    at Socket.Readable.push (_stream_readable.js:208:10)\\n    at TCP.onread (net.js:597:20)\",\r\n[1] [0]         \"message\": \"la relation « public.Pods » n'existe pas\",\r\n[1] [0]         \"name\": \"error\",\r\n[1] [0]         \"length\": 115,\r\n[1] [0]         \"severity\": \"ERREUR\",\r\n[1] [0]         \"code\": \"42P01\",\r\n[1] [0]         \"file\": \"namespace.c\",\r\n[1] [0]         \"line\": \"415\",\r\n[1] [0]         \"routine\": \"RangeVarGetRelidExtended\",\r\n[1] [0]         \"sql\": \"ALTER TABLE \\\"public\\\".\\\"Pods\\\" ADD COLUMN \\\"email\\\" VARCHAR(400) NOT NULL DEFAULT '';\"\r\n[1] [0]       },\r\n[1] [0]       \"original\": {\r\n[1] [0]         \"stack\": \"error: la relation « public.Pods » n'existe pas\\n    at Connection.parseE ($HOME/Documents/Scripts/PeerTube/node_modules/pg/lib/connection.js:553:11)\\n    at Connection.parseMessage ($HOME/Documents/Scripts/PeerTube/node_modules/pg/lib/connection.js:378:19)\\n    at Socket.<anonymous> ($HOME/Documents/Scripts/PeerTube/node_modules/pg/lib/connection.js:119:22)\\n    at emitOne (events.js:116:13)\\n    at Socket.emit (events.js:211:7)\\n    at addChunk (_stream_readable.js:263:12)\\n    at readableAddChunk (_stream_readable.js:250:11)\\n    at Socket.Readable.push (_stream_readable.js:208:10)\\n    at TCP.onread (net.js:597:20)\",\r\n[1] [0]         \"message\": \"la relation « public.Pods » n'existe pas\",\r\n[1] [0]         \"name\": \"error\",\r\n[1] [0]         \"length\": 115,\r\n[1] [0]         \"severity\": \"ERREUR\",\r\n[1] [0]         \"code\": \"42P01\",\r\n[1] [0]         \"file\": \"namespace.c\",\r\n[1] [0]         \"line\": \"415\",\r\n[1] [0]         \"routine\": \"RangeVarGetRelidExtended\",\r\n[1] [0]         \"sql\": \"ALTER TABLE \\\"public\\\".\\\"Pods\\\" ADD COLUMN \\\"email\\\" VARCHAR(400) NOT NULL DEFAULT '';\"\r\n[1] [0]       },\r\n[1] [0]       \"sql\": \"ALTER TABLE \\\"public\\\".\\\"Pods\\\" ADD COLUMN \\\"email\\\" VARCHAR(400) NOT NULL DEFAULT '';\"\r\n[1] [0]     }\r\n[1] [0]   }\r\n[1] [0] }\r\n[1] [0] [nodemon] app crashed - waiting for file changes before starting...\r\n```"}}
{"actor":{"display_login":"Jorropo"}}