Cannot load sample data in database with `dispatch database restore --dump-file dispatch-sample-data.dump`

[mogindi]

root@0ef891f171ee/-(o_o)-\0ef891f171ee:/usr/local/lib/python3.8/site-packages/dispatch# dispatch database restore --dump-file /root/dispatch-sample-data.dump
Traceback (most recent call last):
  File "/usr/local/bin/dispatch", line 8, in <module>                         
    sys.exit(entrypoint())   
  File "/usr/local/lib/python3.8/site-packages/dispatch/cli.py", line 843, in entrypoint
    dispatch_cli()                                        
  File "/usr/local/lib/python3.8/site-packages/click/core.py", line 829, in __call__
    return self.main(*args, **kwargs)               
  File "/usr/local/lib/python3.8/site-packages/click/core.py", line 782, in main                                          
    rv = self.invoke(ctx)
  File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1259, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1259, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/usr/local/lib/python3.8/site-packages/click/core.py", line 1066, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/usr/local/lib/python3.8/site-packages/click/core.py", line 610, in invoke
    return callback(*args, **kwargs)
  File "/usr/local/lib/python3.8/site-packages/dispatch/cli.py", line 511, in restore_database
    from sh import psql, createdb
ImportError: cannot import name 'psql' from 'sh' (/usr/local/lib/python3.8/site-packages/sh.py)

[diogomatsubara]

@mogindi Do you get this when you run the container using the Dockerfile or with docker-dispatch?
I opened PR #195 to add the postgresql-client to the Dockerfile so it gets installed in the main dispatch server container. When you use docker-compose.yaml from docker-dispatch I believe this dependency comes through the installation of the database.

The PR fixes the immediate problem of making psql command available in the container but I believe the dispatch database commands will still fail since when using only the Dockerfile to run the dispatch container, you don't get the database set up. I might be wrong though and missed something in the whole docker setup.

[mogindi]

hey @diogomatsubara ! Thanks for you help

so yes I am using dispatch-docker, and database commands were already running from dispatch container. for example dispatch database init creates database and tables.

I'll try to install the package manually and give it a shot.

Also just running import sh in python3.8 is having issues even when the right packages are installed, but works flawlessly in python3.7. dispatch-docker uses python version is 3.8, were you using python3.7 in ur environment?

[diogomatsubara]

I think database init uses python libs to access the database, while database {dump|restore} uses the command line utility psql to do the work. So once psql is installed you should be able to use the dump|restore commands.

I'm using the default that is installed by dispatch-docker. This is what I have from my dispatch container:

root@a7a1efba0904:/# /usr/local/bin/python --version
Python 3.8.2

[mogindi]

okay seems to have worked after installing postgresql-client, but still not getting any data in my tables.

root@3dbe9b43f885/-(o_o)-\3dbe9b43f885:/# dispatch database restore --dump-file /root/dispatch-sample-da
ta.dump
Database already exists.
SET
SET
SET
SET
SET
 set_config
------------

(1 row)

SET
SET
SET
SET
SET
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER SEQUENCE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
COPY 0
 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      4
(1 row)

 setval
--------
      6
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      6
(1 row)

 setval
--------
      6
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      2
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)

 setval
--------
      1
(1 row)


Success.

but the tables are still empty in the database

(Command to see row entries in each table)

dispatch=# SELECT schemaname,relname,n_live_tup 
  FROM pg_stat_user_tables 
  ORDER BY relname;
 schemaname |                  relname                   | n_live_tup 
------------+--------------------------------------------+------------
 public     | alembic_version                            |          0
 public     | assoc_incident_tags                        |          0
 public     | assoc_incident_terms                       |          0
 public     | assoc_individual_contact_incident_priority |          0
 public     | assoc_individual_contact_incident_type     |          0
 public     | assoc_individual_contact_terms             |          0
 public     | conference                                 |          0
 public     | conversation                               |          0
 public     | definition                                 |          0
 public     | definition_teams                           |          0
 public     | definition_terms                           |          0
 public     | document                                   |          0
 public     | document_incident                          |          0
 public     | document_incident_priority                 |          0
 public     | document_incident_type                     |          0
 public     | document_terms                             |          0
 public     | group                                      |          0
 public     | incident                                   |          0
 public     | incident_priority                          |          0
 public     | incident_type                              |          0
 public     | individual_contact                         |          0
 public     | participant                                |          0
 public     | participant_role                           |          0
 public     | policy                                     |          0
 public     | recommendation                             |          0
 public     | recommendation_accuracy                    |          0
 public     | recommendation_documents                   |          0
 public     | recommendation_incident_priorities         |          0
 public     | recommendation_incident_types              |          0
 public     | recommendation_individual_contacts         |          0
 public     | recommendation_services                    |          0
 public     | recommendation_team_contacts               |          0
 public     | recommendation_terms                       |          0
 public     | service                                    |          0
 public     | service_incident                           |          0
 public     | service_incident_priority                  |          0
 public     | service_incident_type                      |          0
 public     | service_terms                              |          0
 public     | status_report                              |          0
 public     | storage                                    |          0
 public     | tag                                        |          0
 public     | task                                       |          0
 public     | team_contact                               |          0
 public     | team_contact_incident                      |          0
 public     | team_contact_incident_priority             |          0
 public     | team_contact_incident_type                 |          0
 public     | team_contact_terms                         |          0
 public     | term                                       |          0
 public     | ticket                                     |          0
(49 rows)

[diogomatsubara]

@mogindi Do you have the logs from your database container? docker logs <db-container-id>

In my local environment the current dump is triggering database constraints so I think I'll need to update the dump file with data that matches the latest schema from the develop branch.

[mogindi]

ERROR:  database "dispatch" already exists
STATEMENT:  CREATE DATABASE dispatch;
ERROR:  type "tsq_state" already exists
STATEMENT:  CREATE TYPE public.tsq_state AS (
		search_query text,
		parentheses_stack integer,
		skip_for integer,
		current_token text,
		current_index integer,
		current_char text,
		previous_char text,
		tokens text[]
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TYPE public.tsq_state OWNER TO dispatch;
ERROR:  function "application_search_vector_update" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.application_search_vector_update() RETURNS trigger
	    LANGUAGE plpgsql
	    AS $$
	            BEGIN
	                NEW.search_vector = to_tsvector('pg_catalog.english', coalesce(NEW.name, ''));
	                RETURN NEW;
	            END
	            $$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.application_search_vector_update() OWNER TO dispatch;
ERROR:  function "array_nremove" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.array_nremove(anyarray, anyelement, integer) RETURNS anyarray
	    LANGUAGE sql IMMUTABLE
	    AS $_$
	    WITH replaced_positions AS (
	        SELECT UNNEST(
	            CASE
	            WHEN $2 IS NULL THEN
	                '{}'::int[]
	            WHEN $3 > 0 THEN
	                (array_positions($1, $2))[1:$3]
	            WHEN $3 < 0 THEN
	                (array_positions($1, $2))[
	                    (cardinality(array_positions($1, $2)) + $3 + 1):
	                ]
	            ELSE
	                '{}'::int[]
	            END
	        ) AS position
	    )
	    SELECT COALESCE((
	        SELECT array_agg(value)
	        FROM unnest($1) WITH ORDINALITY AS t(value, index)
	        WHERE index NOT IN (SELECT position FROM replaced_positions)
	    ), $1[1:0]);
	$_$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.array_nremove(anyarray, anyelement, integer) OWNER TO dispatch;
ERROR:  function "definition_search_vector_update" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.definition_search_vector_update() RETURNS trigger
	    LANGUAGE plpgsql
	    AS $$
	            BEGIN
	                NEW.search_vector = to_tsvector('pg_catalog.english', coalesce(NEW.text, ''));
	                RETURN NEW;
	            END
	            $$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.definition_search_vector_update() OWNER TO dispatch;
ERROR:  function "document_search_vector_update" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.document_search_vector_update() RETURNS trigger
	    LANGUAGE plpgsql
	    AS $$
	            BEGIN
	                NEW.search_vector = to_tsvector('pg_catalog.english', coalesce(NEW.name, ''));
	                RETURN NEW;
	            END
	            $$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.document_search_vector_update() OWNER TO dispatch;
ERROR:  function "incident_search_vector_update" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.incident_search_vector_update() RETURNS trigger
	    LANGUAGE plpgsql
	    AS $$
	            BEGIN
	                NEW.search_vector = (to_tsvector('pg_catalog.english', coalesce(NEW.name, '')) || to_tsvector('pg_catalog.english', coalesce(NEW.title, ''))) || to_tsvector('pg_catalog.english', coalesce(NEW.description, ''));
	                RETURN NEW;
	            END
	            $$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.incident_search_vector_update() OWNER TO dispatch;
ERROR:  function "incident_type_search_vector_update" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.incident_type_search_vector_update() RETURNS trigger
	    LANGUAGE plpgsql
	    AS $$
	            BEGIN
	                NEW.search_vector = to_tsvector('pg_catalog.english', coalesce(NEW.name, '')) || to_tsvector('pg_catalog.english', coalesce(NEW.description, ''));
	                RETURN NEW;
	            END
	            $$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.incident_type_search_vector_update() OWNER TO dispatch;
ERROR:  function "individual_contact_search_vector_update" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.individual_contact_search_vector_update() RETURNS trigger
	    LANGUAGE plpgsql
	    AS $$
	            BEGIN
	                NEW.search_vector = ((to_tsvector('pg_catalog.english', coalesce(NEW.name, '')) || to_tsvector('pg_catalog.english', coalesce(NEW.title, ''))) || to_tsvector('pg_catalog.english', coalesce(NEW.company, ''))) || to_tsvector('pg_catalog.english', coalesce(NEW.notes, ''));
	                RETURN NEW;
	            END
	            $$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.individual_contact_search_vector_update() OWNER TO dispatch;
ERROR:  function "policy_search_vector_update" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.policy_search_vector_update() RETURNS trigger
	    LANGUAGE plpgsql
	    AS $$
	            BEGIN
	                NEW.search_vector = to_tsvector('pg_catalog.english', coalesce(NEW.name, '')) || to_tsvector('pg_catalog.english', coalesce(NEW.description, ''));
	                RETURN NEW;
	            END
	            $$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.policy_search_vector_update() OWNER TO dispatch;
ERROR:  function "service_search_vector_update" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.service_search_vector_update() RETURNS trigger
	    LANGUAGE plpgsql
	    AS $$
	            BEGIN
	                NEW.search_vector = to_tsvector('pg_catalog.english', coalesce(NEW.name, ''));
	                RETURN NEW;
	            END
	            $$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.service_search_vector_update() OWNER TO dispatch;
ERROR:  function "task_search_vector_update" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.task_search_vector_update() RETURNS trigger
	    LANGUAGE plpgsql
	    AS $$
	            BEGIN
	                NEW.search_vector = to_tsvector('pg_catalog.english', coalesce(NEW.description, ''));
	                RETURN NEW;
	            END
	            $$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.task_search_vector_update() OWNER TO dispatch;
ERROR:  function "team_contact_search_vector_update" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.team_contact_search_vector_update() RETURNS trigger
	    LANGUAGE plpgsql
	    AS $$
	            BEGIN
	                NEW.search_vector = (to_tsvector('pg_catalog.english', coalesce(NEW.name, '')) || to_tsvector('pg_catalog.english', coalesce(NEW.company, ''))) || to_tsvector('pg_catalog.english', coalesce(NEW.notes, ''));
	                RETURN NEW;
	            END
	            $$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.team_contact_search_vector_update() OWNER TO dispatch;
ERROR:  function "term_search_vector_update" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.term_search_vector_update() RETURNS trigger
	    LANGUAGE plpgsql
	    AS $$
	            BEGIN
	                NEW.search_vector = to_tsvector('pg_catalog.english', coalesce(NEW.text, ''));
	                RETURN NEW;
	            END
	            $$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.term_search_vector_update() OWNER TO dispatch;
ERROR:  function "tsq_append_current_token" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.tsq_append_current_token(state public.tsq_state) RETURNS public.tsq_state
	    LANGUAGE plpgsql IMMUTABLE
	    AS $$
	BEGIN
	    IF state.current_token != '' THEN
	        state.tokens := array_append(state.tokens, state.current_token);
	        state.current_token := '';
	    END IF;
	    RETURN state;
	END;
	$$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.tsq_append_current_token(state public.tsq_state) OWNER TO dispatch;
ERROR:  function "tsq_parse" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.tsq_parse(search_query text) RETURNS tsquery
	    LANGUAGE sql IMMUTABLE
	    AS $$
	    SELECT tsq_parse(get_current_ts_config(), search_query);
	$$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.tsq_parse(search_query text) OWNER TO dispatch;
ERROR:  function "tsq_parse" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.tsq_parse(config regconfig, search_query text) RETURNS tsquery
	    LANGUAGE sql IMMUTABLE
	    AS $$
	    SELECT tsq_process_tokens(config, tsq_tokenize(search_query));
	$$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.tsq_parse(config regconfig, search_query text) OWNER TO dispatch;
ERROR:  function "tsq_parse" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.tsq_parse(config text, search_query text) RETURNS tsquery
	    LANGUAGE sql IMMUTABLE
	    AS $$
	    SELECT tsq_parse(config::regconfig, search_query);
	$$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.tsq_parse(config text, search_query text) OWNER TO dispatch;
ERROR:  function "tsq_process_tokens" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.tsq_process_tokens(tokens text[]) RETURNS tsquery
	    LANGUAGE sql IMMUTABLE
	    AS $$
	    SELECT tsq_process_tokens(get_current_ts_config(), tokens);
	$$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.tsq_process_tokens(tokens text[]) OWNER TO dispatch;
ERROR:  function "tsq_process_tokens" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.tsq_process_tokens(config regconfig, tokens text[]) RETURNS tsquery
	    LANGUAGE plpgsql IMMUTABLE
	    AS $$
	DECLARE
	    result_query text;
	    previous_value text;
	    value text;
	BEGIN
	    result_query := '';
	
	    FOREACH value IN ARRAY tokens LOOP
	        IF value = '"' THEN
	            CONTINUE;
	        END IF;
	
	        IF value = 'or' THEN
	            value := ' | ';
	        END IF;
	
	        IF left(value, 1) = '"' AND right(value, 1) = '"' THEN
	            value := phraseto_tsquery(config, value);
	        ELSIF value NOT IN ('(', ' | ', ')', '-') THEN
	            value := quote_literal(value) || ':*';
	        END IF;
	
	        IF previous_value = '-' THEN
	            IF value = '(' THEN
	                value := '!' || value;
	            ELSIF value = ' | ' THEN
	                CONTINUE;
	            ELSE
	                value := '!(' || value || ')';
	            END IF;
	        END IF;
	
	        SELECT
	            CASE
	                WHEN result_query = '' THEN value
	                WHEN previous_value = ' | ' AND value = ' | ' THEN result_query
	                WHEN previous_value = ' | ' THEN result_query || ' | ' || value
	                WHEN previous_value IN ('!(', '(') OR value = ')' THEN result_query || value
	                WHEN value != ' | ' THEN result_query || ' & ' || value
	                ELSE result_query
	            END
	        INTO result_query;
	        previous_value := value;
	    END LOOP;
	
	    IF result_query = ' | ' THEN
	        RETURN to_tsquery('');
	    END IF;
	
	    RETURN to_tsquery(config, result_query);
	END;
	$$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.tsq_process_tokens(config regconfig, tokens text[]) OWNER TO dispatch;
ERROR:  function "tsq_tokenize" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.tsq_tokenize(search_query text) RETURNS text[]
	    LANGUAGE plpgsql IMMUTABLE
	    AS $$
	DECLARE
	    state tsq_state;
	BEGIN
	    SELECT
	        search_query::text AS search_query,
	        0::int AS parentheses_stack,
	        0 AS skip_for,
	        ''::text AS current_token,
	        0 AS current_index,
	        ''::text AS current_char,
	        ''::text AS previous_char,
	        '{}'::text[] AS tokens
	    INTO state;
	
	    state.search_query := lower(trim(
	        regexp_replace(search_query, '""+', '""', 'g')
	    ));
	
	    FOR state.current_index IN (
	        SELECT generate_series(1, length(state.search_query))
	    ) LOOP
	        state.current_char := substring(
	            search_query FROM state.current_index FOR 1
	        );
	
	        IF state.skip_for > 0 THEN
	            state.skip_for := state.skip_for - 1;
	            CONTINUE;
	        END IF;
	
	        state := tsq_tokenize_character(state);
	        state.previous_char := state.current_char;
	    END LOOP;
	    state := tsq_append_current_token(state);
	
	    state.tokens := array_nremove(state.tokens, '(', -state.parentheses_stack);
	
	    RETURN state.tokens;
	END;
	$$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.tsq_tokenize(search_query text) OWNER TO dispatch;
ERROR:  function "tsq_tokenize_character" already exists with same argument types
STATEMENT:  CREATE FUNCTION public.tsq_tokenize_character(state public.tsq_state) RETURNS public.tsq_state
	    LANGUAGE plpgsql IMMUTABLE
	    AS $$
	BEGIN
	    IF state.current_char = '(' THEN
	        state.tokens := array_append(state.tokens, '(');
	        state.parentheses_stack := state.parentheses_stack + 1;
	        state := tsq_append_current_token(state);
	    ELSIF state.current_char = ')' THEN
	        IF (state.parentheses_stack > 0 AND state.current_token != '') THEN
	            state := tsq_append_current_token(state);
	            state.tokens := array_append(state.tokens, ')');
	            state.parentheses_stack := state.parentheses_stack - 1;
	        END IF;
	    ELSIF state.current_char = '"' THEN
	        state.skip_for := position('"' IN substring(
	            state.search_query FROM state.current_index + 1
	        ));
	
	        IF state.skip_for > 1 THEN
	            state.tokens = array_append(
	                state.tokens,
	                substring(
	                    state.search_query
	                    FROM state.current_index FOR state.skip_for + 1
	                )
	            );
	        ELSIF state.skip_for = 0 THEN
	            state.current_token := state.current_token || state.current_char;
	        END IF;
	    ELSIF (
	        state.current_char = '-' AND
	        (state.current_index = 1 OR state.previous_char = ' ')
	    ) THEN
	        state.tokens := array_append(state.tokens, '-');
	    ELSIF state.current_char = ' ' THEN
	        state := tsq_append_current_token(state);
	    ELSE
	        state.current_token = state.current_token || state.current_char;
	    END IF;
	    RETURN state;
	END;
	$$;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER FUNCTION public.tsq_tokenize_character(state public.tsq_state) OWNER TO dispatch;
ERROR:  relation "alembic_version" already exists
STATEMENT:  CREATE TABLE public.alembic_version (
	    version_num character varying(32) NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.alembic_version OWNER TO dispatch;
ERROR:  relation "application" already exists
STATEMENT:  CREATE TABLE public.application (
	    id integer NOT NULL,
	    name character varying,
	    description character varying,
	    uri character varying,
	    source character varying,
	    search_vector tsvector,
	    created_at timestamp without time zone,
	    updated_at timestamp without time zone
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.application OWNER TO dispatch;
ERROR:  relation "application_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.application_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.application_id_seq OWNER TO dispatch;
ERROR:  relation "applications_incidents" already exists
STATEMENT:  CREATE TABLE public.applications_incidents (
	    incident_id integer NOT NULL,
	    application_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.applications_incidents OWNER TO dispatch;
ERROR:  relation "assoc_incident_terms" already exists
STATEMENT:  CREATE TABLE public.assoc_incident_terms (
	    incident_id integer NOT NULL,
	    term_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.assoc_incident_terms OWNER TO dispatch;
ERROR:  relation "assoc_individual_contact_incident_priority" already exists
STATEMENT:  CREATE TABLE public.assoc_individual_contact_incident_priority (
	    incident_priority_id integer NOT NULL,
	    individual_contact_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.assoc_individual_contact_incident_priority OWNER TO dispatch;
ERROR:  relation "assoc_individual_contact_incident_type" already exists
STATEMENT:  CREATE TABLE public.assoc_individual_contact_incident_type (
	    incident_type_id integer NOT NULL,
	    individual_contact_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.assoc_individual_contact_incident_type OWNER TO dispatch;
ERROR:  relation "assoc_individual_contact_terms" already exists
STATEMENT:  CREATE TABLE public.assoc_individual_contact_terms (
	    term_id integer NOT NULL,
	    individual_contact_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.assoc_individual_contact_terms OWNER TO dispatch;
ERROR:  relation "conference" already exists
STATEMENT:  CREATE TABLE public.conference (
	    resource_type character varying,
	    resource_id character varying,
	    weblink character varying,
	    id integer NOT NULL,
	    conference_id character varying,
	    incident_id integer,
	    created_at timestamp without time zone,
	    updated_at timestamp without time zone
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.conference OWNER TO dispatch;
ERROR:  relation "conference_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.conference_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.conference_id_seq OWNER TO dispatch;
ERROR:  relation "conversation" already exists
STATEMENT:  CREATE TABLE public.conversation (
	    resource_type character varying,
	    resource_id character varying,
	    weblink character varying,
	    id integer NOT NULL,
	    channel_id character varying,
	    incident_id integer,
	    created_at timestamp without time zone,
	    updated_at timestamp without time zone
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.conversation OWNER TO dispatch;
ERROR:  relation "conversation_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.conversation_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.conversation_id_seq OWNER TO dispatch;
ERROR:  relation "definition" already exists
STATEMENT:  CREATE TABLE public.definition (
	    id integer NOT NULL,
	    text character varying,
	    source character varying,
	    search_vector tsvector
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.definition OWNER TO dispatch;
ERROR:  relation "definition_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.definition_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.definition_id_seq OWNER TO dispatch;
ERROR:  relation "definition_teams" already exists
STATEMENT:  CREATE TABLE public.definition_teams (
	    definition_id integer NOT NULL,
	    team_contact_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.definition_teams OWNER TO dispatch;
ERROR:  relation "definition_terms" already exists
STATEMENT:  CREATE TABLE public.definition_terms (
	    definition_id integer NOT NULL,
	    term_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.definition_terms OWNER TO dispatch;
ERROR:  relation "document" already exists
STATEMENT:  CREATE TABLE public.document (
	    resource_type character varying,
	    resource_id character varying,
	    weblink character varying,
	    id integer NOT NULL,
	    name character varying,
	    description character varying,
	    search_vector tsvector,
	    incident_id integer,
	    created_at timestamp without time zone,
	    updated_at timestamp without time zone
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.document OWNER TO dispatch;
ERROR:  relation "document_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.document_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.document_id_seq OWNER TO dispatch;
ERROR:  relation "document_incident" already exists
STATEMENT:  CREATE TABLE public.document_incident (
	    incident_id integer NOT NULL,
	    document_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.document_incident OWNER TO dispatch;
ERROR:  relation "document_incident_priority" already exists
STATEMENT:  CREATE TABLE public.document_incident_priority (
	    incident_priority_id integer NOT NULL,
	    document_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.document_incident_priority OWNER TO dispatch;
ERROR:  relation "document_incident_type" already exists
STATEMENT:  CREATE TABLE public.document_incident_type (
	    incident_type_id integer NOT NULL,
	    document_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.document_incident_type OWNER TO dispatch;
ERROR:  relation "document_terms" already exists
STATEMENT:  CREATE TABLE public.document_terms (
	    term_id integer NOT NULL,
	    document_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.document_terms OWNER TO dispatch;
ERROR:  relation "group" already exists
STATEMENT:  CREATE TABLE public."group" (
	    resource_type character varying,
	    resource_id character varying,
	    weblink character varying,
	    id integer NOT NULL,
	    name character varying,
	    email character varying,
	    incident_id integer,
	    created_at timestamp without time zone,
	    updated_at timestamp without time zone
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public."group" OWNER TO dispatch;
ERROR:  relation "group_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.group_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.group_id_seq OWNER TO dispatch;
ERROR:  relation "incident" already exists
STATEMENT:  CREATE TABLE public.incident (
	    id integer NOT NULL,
	    name character varying,
	    title character varying NOT NULL,
	    description character varying NOT NULL,
	    status character varying,
	    cost double precision,
	    visibility character varying,
	    reported_at timestamp without time zone,
	    stable_at timestamp without time zone,
	    closed_at timestamp without time zone,
	    search_vector tsvector,
	    incident_type_id integer,
	    incident_priority_id integer,
	    created_at timestamp without time zone,
	    updated_at timestamp without time zone
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.incident OWNER TO dispatch;
ERROR:  relation "incident_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.incident_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.incident_id_seq OWNER TO dispatch;
ERROR:  relation "incident_priority" already exists
STATEMENT:  CREATE TABLE public.incident_priority (
	    id integer NOT NULL,
	    name character varying,
	    description character varying
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.incident_priority OWNER TO dispatch;
ERROR:  relation "incident_priority_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.incident_priority_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.incident_priority_id_seq OWNER TO dispatch;
ERROR:  relation "incident_type" already exists
STATEMENT:  CREATE TABLE public.incident_type (
	    id integer NOT NULL,
	    name character varying,
	    slug character varying,
	    description character varying,
	    visibility character varying,
	    template_document_id integer,
	    commander_service_id integer,
	    search_vector tsvector
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.incident_type OWNER TO dispatch;
ERROR:  relation "incident_type_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.incident_type_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.incident_type_id_seq OWNER TO dispatch;
ERROR:  relation "individual_contact" already exists
STATEMENT:  CREATE TABLE public.individual_contact (
	    is_active boolean,
	    is_external boolean,
	    contact_type character varying,
	    email character varying,
	    company character varying,
	    notes character varying,
	    owner character varying,
	    id integer NOT NULL,
	    name character varying,
	    mobile_phone character varying,
	    office_phone character varying,
	    title character varying,
	    weblink character varying,
	    team_contact_id integer,
	    search_vector tsvector,
	    created_at timestamp without time zone,
	    updated_at timestamp without time zone
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.individual_contact OWNER TO dispatch;
ERROR:  relation "individual_contact_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.individual_contact_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.individual_contact_id_seq OWNER TO dispatch;
ERROR:  relation "participant" already exists
STATEMENT:  CREATE TABLE public.participant (
	    id integer NOT NULL,
	    is_active boolean,
	    active_at timestamp without time zone,
	    inactive_at timestamp without time zone,
	    incident_id integer,
	    individual_contact_id integer,
	    location character varying,
	    team character varying,
	    department character varying
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.participant OWNER TO dispatch;
ERROR:  relation "participant_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.participant_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.participant_id_seq OWNER TO dispatch;
ERROR:  relation "participant_role" already exists
STATEMENT:  CREATE TABLE public.participant_role (
	    id integer NOT NULL,
	    assume_at timestamp without time zone,
	    renounce_at timestamp without time zone,
	    role character varying,
	    participant_id integer
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.participant_role OWNER TO dispatch;
ERROR:  relation "participant_role_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.participant_role_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.participant_role_id_seq OWNER TO dispatch;
ERROR:  relation "policy" already exists
STATEMENT:  CREATE TABLE public.policy (
	    id integer NOT NULL,
	    name character varying,
	    description character varying,
	    expression character varying,
	    search_vector tsvector
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.policy OWNER TO dispatch;
ERROR:  relation "policy_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.policy_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.policy_id_seq OWNER TO dispatch;
ERROR:  relation "recommendation" already exists
STATEMENT:  CREATE TABLE public.recommendation (
	    id integer NOT NULL,
	    text character varying
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.recommendation OWNER TO dispatch;
ERROR:  relation "recommendation_accuracy" already exists
STATEMENT:  CREATE TABLE public.recommendation_accuracy (
	    id integer NOT NULL,
	    recommendation_id integer,
	    correct boolean,
	    resource_id integer,
	    resource_type character varying
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.recommendation_accuracy OWNER TO dispatch;
ERROR:  relation "recommendation_accuracy_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.recommendation_accuracy_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.recommendation_accuracy_id_seq OWNER TO dispatch;
ERROR:  relation "recommendation_documents" already exists
STATEMENT:  CREATE TABLE public.recommendation_documents (
	    document_id integer NOT NULL,
	    recommendation_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.recommendation_documents OWNER TO dispatch;
ERROR:  relation "recommendation_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.recommendation_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.recommendation_id_seq OWNER TO dispatch;
ERROR:  relation "recommendation_incident_priorities" already exists
STATEMENT:  CREATE TABLE public.recommendation_incident_priorities (
	    incident_priority_id integer NOT NULL,
	    recommendation_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.recommendation_incident_priorities OWNER TO dispatch;
ERROR:  relation "recommendation_incident_types" already exists
STATEMENT:  CREATE TABLE public.recommendation_incident_types (
	    incident_type_id integer NOT NULL,
	    recommendation_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.recommendation_incident_types OWNER TO dispatch;
ERROR:  relation "recommendation_individual_contacts" already exists
STATEMENT:  CREATE TABLE public.recommendation_individual_contacts (
	    individual_contact_id integer NOT NULL,
	    recommendation_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.recommendation_individual_contacts OWNER TO dispatch;
ERROR:  relation "recommendation_services" already exists
STATEMENT:  CREATE TABLE public.recommendation_services (
	    service_id integer NOT NULL,
	    recommendation_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.recommendation_services OWNER TO dispatch;
ERROR:  relation "recommendation_team_contacts" already exists
STATEMENT:  CREATE TABLE public.recommendation_team_contacts (
	    team_contact_id integer NOT NULL,
	    recommendation_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.recommendation_team_contacts OWNER TO dispatch;
ERROR:  relation "recommendation_terms" already exists
STATEMENT:  CREATE TABLE public.recommendation_terms (
	    term_id integer NOT NULL,
	    recommendation_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.recommendation_terms OWNER TO dispatch;
ERROR:  relation "service" already exists
STATEMENT:  CREATE TABLE public.service (
	    id integer NOT NULL,
	    is_active boolean,
	    name character varying,
	    type character varying,
	    external_id character varying,
	    search_vector tsvector,
	    created_at timestamp without time zone,
	    updated_at timestamp without time zone
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.service OWNER TO dispatch;
ERROR:  relation "service_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.service_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.service_id_seq OWNER TO dispatch;
ERROR:  relation "service_incident" already exists
STATEMENT:  CREATE TABLE public.service_incident (
	    incident_id integer NOT NULL,
	    service_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.service_incident OWNER TO dispatch;
ERROR:  relation "service_incident_priority" already exists
STATEMENT:  CREATE TABLE public.service_incident_priority (
	    incident_priority_id integer NOT NULL,
	    service_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.service_incident_priority OWNER TO dispatch;
ERROR:  relation "service_incident_type" already exists
STATEMENT:  CREATE TABLE public.service_incident_type (
	    incident_type_id integer NOT NULL,
	    service_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.service_incident_type OWNER TO dispatch;
ERROR:  relation "service_terms" already exists
STATEMENT:  CREATE TABLE public.service_terms (
	    term_id integer NOT NULL,
	    service_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.service_terms OWNER TO dispatch;
ERROR:  relation "status_report" already exists
STATEMENT:  CREATE TABLE public.status_report (
	    id integer NOT NULL,
	    created_at timestamp without time zone,
	    conditions character varying,
	    actions character varying,
	    needs character varying,
	    incident_id integer,
	    participant_id integer
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.status_report OWNER TO dispatch;
ERROR:  relation "status_report_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.status_report_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.status_report_id_seq OWNER TO dispatch;
ERROR:  relation "storage" already exists
STATEMENT:  CREATE TABLE public.storage (
	    resource_type character varying,
	    resource_id character varying,
	    weblink character varying,
	    id integer NOT NULL,
	    incident_id integer,
	    created_at timestamp without time zone,
	    updated_at timestamp without time zone
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.storage OWNER TO dispatch;
ERROR:  relation "storage_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.storage_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.storage_id_seq OWNER TO dispatch;
ERROR:  relation "task" already exists
STATEMENT:  CREATE TABLE public.task (
	    resource_type character varying,
	    resource_id character varying,
	    weblink character varying,
	    id integer NOT NULL,
	    resolved_at timestamp without time zone,
	    resolve_by timestamp without time zone,
	    last_reminder_at timestamp without time zone,
	    creator character varying,
	    assignees character varying,
	    description character varying,
	    source character varying,
	    priority character varying,
	    status character varying,
	    reminders boolean,
	    incident_id integer,
	    search_vector tsvector,
	    created_at timestamp without time zone,
	    updated_at timestamp without time zone
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.task OWNER TO dispatch;
ERROR:  relation "task_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.task_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.task_id_seq OWNER TO dispatch;
ERROR:  relation "team_contact" already exists
STATEMENT:  CREATE TABLE public.team_contact (
	    is_active boolean,
	    is_external boolean,
	    contact_type character varying,
	    email character varying,
	    company character varying,
	    owner character varying,
	    id integer NOT NULL,
	    name character varying,
	    notes character varying,
	    search_vector tsvector,
	    created_at timestamp without time zone,
	    updated_at timestamp without time zone
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.team_contact OWNER TO dispatch;
ERROR:  relation "team_contact_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.team_contact_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.team_contact_id_seq OWNER TO dispatch;
ERROR:  relation "team_contact_incident" already exists
STATEMENT:  CREATE TABLE public.team_contact_incident (
	    incident_id integer NOT NULL,
	    team_contact_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.team_contact_incident OWNER TO dispatch;
ERROR:  relation "team_contact_incident_priority" already exists
STATEMENT:  CREATE TABLE public.team_contact_incident_priority (
	    incident_priority_id integer NOT NULL,
	    team_contact_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.team_contact_incident_priority OWNER TO dispatch;
ERROR:  relation "team_contact_incident_type" already exists
STATEMENT:  CREATE TABLE public.team_contact_incident_type (
	    incident_type_id integer NOT NULL,
	    team_contact_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.team_contact_incident_type OWNER TO dispatch;
ERROR:  relation "team_contact_terms" already exists
STATEMENT:  CREATE TABLE public.team_contact_terms (
	    term_id integer NOT NULL,
	    team_contact_id integer NOT NULL
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.team_contact_terms OWNER TO dispatch;
ERROR:  relation "term" already exists
STATEMENT:  CREATE TABLE public.term (
	    id integer NOT NULL,
	    text character varying,
	    search_vector tsvector
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.term OWNER TO dispatch;
ERROR:  relation "term_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.term_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.term_id_seq OWNER TO dispatch;
ERROR:  relation "ticket" already exists
STATEMENT:  CREATE TABLE public.ticket (
	    resource_type character varying,
	    resource_id character varying,
	    weblink character varying,
	    id integer NOT NULL,
	    incident_id integer,
	    created_at timestamp without time zone,
	    updated_at timestamp without time zone
	);
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.ticket OWNER TO dispatch;
ERROR:  relation "ticket_id_seq" already exists
STATEMENT:  CREATE SEQUENCE public.ticket_id_seq
	    START WITH 1
	    INCREMENT BY 1
	    NO MINVALUE
	    NO MAXVALUE
	    CACHE 1;
ERROR:  role "dispatch" does not exist
STATEMENT:  ALTER TABLE public.ticket_id_seq OWNER TO dispatch;
ERROR:  duplicate key value violates unique constraint "alembic_version_pkc"
DETAIL:  Key (version_num)=(b12f7a59ced9) already exists.
CONTEXT:  COPY alembic_version, line 1
STATEMENT:  COPY public.alembic_version (version_num) FROM stdin;
ERROR:  duplicate key value violates unique constraint "application_name_key"
DETAIL:  Key (name)=(Application1) already exists.
CONTEXT:  COPY application, line 1: "1	Application1	Application1 description	https://example.com/application1	https://example.com/applica..."
STATEMENT:  COPY public.application (id, name, description, uri, source, search_vector, created_at, updated_at) FROM stdin;
ERROR:  duplicate key value violates unique constraint "definition_pkey"
DETAIL:  Key (id)=(1) already exists.
CONTEXT:  COPY definition, line 1: "1	foobar	dispatch	'foobar':1"
STATEMENT:  COPY public.definition (id, text, source, search_vector) FROM stdin;
ERROR:  duplicate key value violates unique constraint "definition_terms_pkey"
DETAIL:  Key (definition_id, term_id)=(1, 1) already exists.
CONTEXT:  COPY definition_terms, line 1
STATEMENT:  COPY public.definition_terms (definition_id, term_id) FROM stdin;
ERROR:  duplicate key value violates unique constraint "document_pkey"
DETAIL:  Key (id)=(2) already exists.
CONTEXT:  COPY document, line 1: "documentation	document-id1234	https://example.com/weblink/document	2	Document1	Some document descrip..."
STATEMENT:  COPY public.document (resource_type, resource_id, weblink, id, name, description, search_vector, incident_id, created_at, updated_at) FROM stdin;
ERROR:  duplicate key value violates unique constraint "document_terms_pkey"
DETAIL:  Key (term_id, document_id)=(1, 6) already exists.
CONTEXT:  COPY document_terms, line 1
STATEMENT:  COPY public.document_terms (term_id, document_id) FROM stdin;
ERROR:  duplicate key value violates unique constraint "incident_pkey"
DETAIL:  Key (id)=(1) already exists.
CONTEXT:  COPY incident, line 1: "1	\N	Incident1	Some incident	Active	0	Open	2020-03-23 11:46:16.096746	\N	\N	'incid':3 'incident1':1	..."
STATEMENT:  COPY public.incident (id, name, title, description, status, cost, visibility, reported_at, stable_at, closed_at, search_vector, incident_type_id, incident_priority_id, created_at, updated_at) FROM stdin;
ERROR:  duplicate key value violates unique constraint "incident_priority_name_key"
DETAIL:  Key (name)=(high) already exists.
CONTEXT:  COPY incident_priority, line 1
STATEMENT:  COPY public.incident_priority (id, name, description) FROM stdin;
ERROR:  duplicate key value violates unique constraint "incident_type_name_key"
DETAIL:  Key (name)=(IncidentType1) already exists.
CONTEXT:  COPY incident_type, line 1: "6	IncidentType1	\N	IncidentType description	Open	2	2	'descript':3 'incidenttyp':2 'incidenttype1':1"
STATEMENT:  COPY public.incident_type (id, name, slug, description, visibility, template_document_id, commander_service_id, search_vector) FROM stdin;
ERROR:  duplicate key value violates unique constraint "individual_contact_email_key"
DETAIL:  Key (email)=(foobar@example.com) already exists.
CONTEXT:  COPY individual_contact, line 1: "t	f	\N	foobar@example.com	Foobar Co.	\N	\N	1	Foobar	\N	\N	\N	\N	\N	'co':3 'foobar':1,2	2020-03-22 17..."
STATEMENT:  COPY public.individual_contact (is_active, is_external, contact_type, email, company, notes, owner, id, name, mobile_phone, office_phone, title, weblink, team_contact_id, search_vector, created_at, updated_at) FROM stdin;
ERROR:  duplicate key value violates unique constraint "policy_name_key"
DETAIL:  Key (name)=(Policy1) already exists.
CONTEXT:  COPY policy, line 1: "1	Policy1	some policy	foobar=foo	'polici':3 'policy1':1"
STATEMENT:  COPY public.policy (id, name, description, expression, search_vector) FROM stdin;
ERROR:  duplicate key value violates unique constraint "service_pkey"
DETAIL:  Key (id)=(2) already exists.
CONTEXT:  COPY service, line 1: "2	t	SomeService1	pagerduty-oncall	serviceID1	'someservice1':1	2020-03-22 17:55:03.755493	2020-03-22 ..."
STATEMENT:  COPY public.service (id, is_active, name, type, external_id, search_vector, created_at, updated_at) FROM stdin;
ERROR:  duplicate key value violates unique constraint "term_pkey"
DETAIL:  Key (id)=(1) already exists.
CONTEXT:  COPY term, line 1: "1	foobar	'foobar':1"
STATEMENT:  COPY public.term (id, text, search_vector) FROM stdin;
ERROR:  multiple primary keys for table "alembic_version" are not allowed
STATEMENT:  ALTER TABLE ONLY public.alembic_version
	    ADD CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num);
ERROR:  relation "application_name_key" already exists
STATEMENT:  ALTER TABLE ONLY public.application
	    ADD CONSTRAINT application_name_key UNIQUE (name);
ERROR:  multiple primary keys for table "application" are not allowed
STATEMENT:  ALTER TABLE ONLY public.application
	    ADD CONSTRAINT application_pkey PRIMARY KEY (id);
ERROR:  multiple primary keys for table "applications_incidents" are not allowed
STATEMENT:  ALTER TABLE ONLY public.applications_incidents
	    ADD CONSTRAINT applications_incidents_pkey PRIMARY KEY (incident_id, application_id);
ERROR:  multiple primary keys for table "assoc_incident_terms" are not allowed
STATEMENT:  ALTER TABLE ONLY public.assoc_incident_terms
	    ADD CONSTRAINT assoc_incident_terms_pkey PRIMARY KEY (incident_id, term_id);
ERROR:  multiple primary keys for table "assoc_individual_contact_incident_priority" are not allowed
STATEMENT:  ALTER TABLE ONLY public.assoc_individual_contact_incident_priority
	    ADD CONSTRAINT assoc_individual_contact_incident_priority_pkey PRIMARY KEY (incident_priority_id, individual_contact_id);
ERROR:  multiple primary keys for table "assoc_individual_contact_incident_type" are not allowed
STATEMENT:  ALTER TABLE ONLY public.assoc_individual_contact_incident_type
	    ADD CONSTRAINT assoc_individual_contact_incident_type_pkey PRIMARY KEY (incident_type_id, individual_contact_id);
ERROR:  multiple primary keys for table "assoc_individual_contact_terms" are not allowed
STATEMENT:  ALTER TABLE ONLY public.assoc_individual_contact_terms
	    ADD CONSTRAINT assoc_individual_contact_terms_pkey PRIMARY KEY (term_id, individual_contact_id);
ERROR:  multiple primary keys for table "conference" are not allowed
STATEMENT:  ALTER TABLE ONLY public.conference
	    ADD CONSTRAINT conference_pkey PRIMARY KEY (id);
ERROR:  multiple primary keys for table "conversation" are not allowed
STATEMENT:  ALTER TABLE ONLY public.conversation
	    ADD CONSTRAINT conversation_pkey PRIMARY KEY (id);
ERROR:  multiple primary keys for table "definition" are not allowed
STATEMENT:  ALTER TABLE ONLY public.definition
	    ADD CONSTRAINT definition_pkey PRIMARY KEY (id);
ERROR:  multiple primary keys for table "definition_teams" are not allowed
STATEMENT:  ALTER TABLE ONLY public.definition_teams
	    ADD CONSTRAINT definition_teams_pkey PRIMARY KEY (definition_id, team_contact_id);
ERROR:  multiple primary keys for table "definition_terms" are not allowed
STATEMENT:  ALTER TABLE ONLY public.definition_terms
	    ADD CONSTRAINT definition_terms_pkey PRIMARY KEY (definition_id, term_id);
ERROR:  relation "definition_text_key" already exists
STATEMENT:  ALTER TABLE ONLY public.definition
	    ADD CONSTRAINT definition_text_key UNIQUE (text);
ERROR:  multiple primary keys for table "document_incident" are not allowed
STATEMENT:  ALTER TABLE ONLY public.document_incident
	    ADD CONSTRAINT document_incident_pkey PRIMARY KEY (incident_id, document_id);
ERROR:  multiple primary keys for table "document_incident_priority" are not allowed
STATEMENT:  ALTER TABLE ONLY public.document_incident_priority
	    ADD CONSTRAINT document_incident_priority_pkey PRIMARY KEY (incident_priority_id, document_id);
ERROR:  multiple primary keys for table "document_incident_type" are not allowed
STATEMENT:  ALTER TABLE ONLY public.document_incident_type
	    ADD CONSTRAINT document_incident_type_pkey PRIMARY KEY (incident_type_id, document_id);
ERROR:  multiple primary keys for table "document" are not allowed
STATEMENT:  ALTER TABLE ONLY public.document
	    ADD CONSTRAINT document_pkey PRIMARY KEY (id);
ERROR:  multiple primary keys for table "document_terms" are not allowed
STATEMENT:  ALTER TABLE ONLY public.document_terms
	    ADD CONSTRAINT document_terms_pkey PRIMARY KEY (term_id, document_id);
ERROR:  multiple primary keys for table "group" are not allowed
STATEMENT:  ALTER TABLE ONLY public."group"
	    ADD CONSTRAINT group_pkey PRIMARY KEY (id);
ERROR:  multiple primary keys for table "incident" are not allowed
STATEMENT:  ALTER TABLE ONLY public.incident
	    ADD CONSTRAINT incident_pkey PRIMARY KEY (id);
ERROR:  relation "incident_priority_name_key" already exists
STATEMENT:  ALTER TABLE ONLY public.incident_priority
	    ADD CONSTRAINT incident_priority_name_key UNIQUE (name);
ERROR:  multiple primary keys for table "incident_priority" are not allowed
STATEMENT:  ALTER TABLE ONLY public.incident_priority
	    ADD CONSTRAINT incident_priority_pkey PRIMARY KEY (id);
ERROR:  relation "incident_type_name_key" already exists
STATEMENT:  ALTER TABLE ONLY public.incident_type
	    ADD CONSTRAINT incident_type_name_key UNIQUE (name);
ERROR:  multiple primary keys for table "incident_type" are not allowed
STATEMENT:  ALTER TABLE ONLY public.incident_type
	    ADD CONSTRAINT incident_type_pkey PRIMARY KEY (id);
ERROR:  relation "individual_contact_email_key" already exists
STATEMENT:  ALTER TABLE ONLY public.individual_contact
	    ADD CONSTRAINT individual_contact_email_key UNIQUE (email);
ERROR:  multiple primary keys for table "individual_contact" are not allowed
STATEMENT:  ALTER TABLE ONLY public.individual_contact
	    ADD CONSTRAINT individual_contact_pkey PRIMARY KEY (id);
ERROR:  multiple primary keys for table "participant" are not allowed
STATEMENT:  ALTER TABLE ONLY public.participant
	    ADD CONSTRAINT participant_pkey PRIMARY KEY (id);
ERROR:  multiple primary keys for table "participant_role" are not allowed
STATEMENT:  ALTER TABLE ONLY public.participant_role
	    ADD CONSTRAINT participant_role_pkey PRIMARY KEY (id);
ERROR:  relation "policy_name_key" already exists
STATEMENT:  ALTER TABLE ONLY public.policy
	    ADD CONSTRAINT policy_name_key UNIQUE (name);
ERROR:  multiple primary keys for table "policy" are not allowed
STATEMENT:  ALTER TABLE ONLY public.policy
	    ADD CONSTRAINT policy_pkey PRIMARY KEY (id);
ERROR:  multiple primary keys for table "recommendation_accuracy" are not allowed
STATEMENT:  ALTER TABLE ONLY public.recommendation_accuracy
	    ADD CONSTRAINT recommendation_accuracy_pkey PRIMARY KEY (id);
ERROR:  multiple primary keys for table "recommendation_documents" are not allowed
STATEMENT:  ALTER TABLE ONLY public.recommendation_documents
	    ADD CONSTRAINT recommendation_documents_pkey PRIMARY KEY (document_id, recommendation_id);
ERROR:  multiple primary keys for table "recommendation_incident_priorities" are not allowed
STATEMENT:  ALTER TABLE ONLY public.recommendation_incident_priorities
	    ADD CONSTRAINT recommendation_incident_priorities_pkey PRIMARY KEY (incident_priority_id, recommendation_id);
ERROR:  multiple primary keys for table "recommendation_incident_types" are not allowed
STATEMENT:  ALTER TABLE ONLY public.recommendation_incident_types
	    ADD CONSTRAINT recommendation_incident_types_pkey PRIMARY KEY (incident_type_id, recommendation_id);
ERROR:  multiple primary keys for table "recommendation_individual_contacts" are not allowed
STATEMENT:  ALTER TABLE ONLY public.recommendation_individual_contacts
	    ADD CONSTRAINT recommendation_individual_contacts_pkey PRIMARY KEY (individual_contact_id, recommendation_id);
ERROR:  multiple primary keys for table "recommendation" are not allowed
STATEMENT:  ALTER TABLE ONLY public.recommendation
	    ADD CONSTRAINT recommendation_pkey PRIMARY KEY (id);
ERROR:  multiple primary keys for table "recommendation_services" are not allowed
STATEMENT:  ALTER TABLE ONLY public.recommendation_services
	    ADD CONSTRAINT recommendation_services_pkey PRIMARY KEY (service_id, recommendation_id);
ERROR:  multiple primary keys for table "recommendation_team_contacts" are not allowed
STATEMENT:  ALTER TABLE ONLY public.recommendation_team_contacts
	    ADD CONSTRAINT recommendation_team_contacts_pkey PRIMARY KEY (team_contact_id, recommendation_id);
ERROR:  multiple primary keys for table "recommendation_terms" are not allowed
STATEMENT:  ALTER TABLE ONLY public.recommendation_terms
	    ADD CONSTRAINT recommendation_terms_pkey PRIMARY KEY (term_id, recommendation_id);
ERROR:  multiple primary keys for table "service_incident" are not allowed
STATEMENT:  ALTER TABLE ONLY public.service_incident
	    ADD CONSTRAINT service_incident_pkey PRIMARY KEY (incident_id, service_id);
ERROR:  multiple primary keys for table "service_incident_priority" are not allowed
STATEMENT:  ALTER TABLE ONLY public.service_incident_priority
	    ADD CONSTRAINT service_incident_priority_pkey PRIMARY KEY (incident_priority_id, service_id);
ERROR:  multiple primary keys for table "service_incident_type" are not allowed
STATEMENT:  ALTER TABLE ONLY public.service_incident_type
	    ADD CONSTRAINT service_incident_type_pkey PRIMARY KEY (incident_type_id, service_id);
ERROR:  multiple primary keys for table "service" are not allowed
STATEMENT:  ALTER TABLE ONLY public.service
	    ADD CONSTRAINT service_pkey PRIMARY KEY (id);
ERROR:  multiple primary keys for table "service_terms" are not allowed
STATEMENT:  ALTER TABLE ONLY public.service_terms
	    ADD CONSTRAINT service_terms_pkey PRIMARY KEY (term_id, service_id);
ERROR:  multiple primary keys for table "status_report" are not allowed
STATEMENT:  ALTER TABLE ONLY public.status_report
	    ADD CONSTRAINT status_report_pkey PRIMARY KEY (id);
ERROR:  multiple primary keys for table "storage" are not allowed
STATEMENT:  ALTER TABLE ONLY public.storage
	    ADD CONSTRAINT storage_pkey PRIMARY KEY (id);
ERROR:  multiple primary keys for table "task" are not allowed
STATEMENT:  ALTER TABLE ONLY public.task
	    ADD CONSTRAINT task_pkey PRIMARY KEY (id);
ERROR:  relation "team_contact_email_key" already exists
STATEMENT:  ALTER TABLE ONLY public.team_contact
	    ADD CONSTRAINT team_contact_email_key UNIQUE (email);
ERROR:  multiple primary keys for table "team_contact_incident" are not allowed
STATEMENT:  ALTER TABLE ONLY public.team_contact_incident
	    ADD CONSTRAINT team_contact_incident_pkey PRIMARY KEY (incident_id, team_contact_id);
ERROR:  multiple primary keys for table "team_contact_incident_priority" are not allowed
STATEMENT:  ALTER TABLE ONLY public.team_contact_incident_priority
	    ADD CONSTRAINT team_contact_incident_priority_pkey PRIMARY KEY (incident_priority_id, team_contact_id);
ERROR:  multiple primary keys for table "team_contact_incident_type" are not allowed
STATEMENT:  ALTER TABLE ONLY public.team_contact_incident_type
	    ADD CONSTRAINT team_contact_incident_type_pkey PRIMARY KEY (incident_type_id, team_contact_id);
ERROR:  multiple primary keys for table "team_contact" are not allowed
STATEMENT:  ALTER TABLE ONLY public.team_contact
	    ADD CONSTRAINT team_contact_pkey PRIMARY KEY (id);
ERROR:  multiple primary keys for table "team_contact_terms" are not allowed
STATEMENT:  ALTER TABLE ONLY public.team_contact_terms
	    ADD CONSTRAINT team_contact_terms_pkey PRIMARY KEY (term_id, team_contact_id);
ERROR:  multiple primary keys for table "term" are not allowed
STATEMENT:  ALTER TABLE ONLY public.term
	    ADD CONSTRAINT term_pkey PRIMARY KEY (id);
ERROR:  relation "term_text_key" already exists
STATEMENT:  ALTER TABLE ONLY public.term
	    ADD CONSTRAINT term_text_key UNIQUE (text);
ERROR:  multiple primary keys for table "ticket" are not allowed
STATEMENT:  ALTER TABLE ONLY public.ticket
	    ADD CONSTRAINT ticket_pkey PRIMARY KEY (id);
ERROR:  relation "ix_application_search_vector" already exists
STATEMENT:  CREATE INDEX ix_application_search_vector ON public.application USING gin (search_vector);
ERROR:  relation "ix_definition_search_vector" already exists
STATEMENT:  CREATE INDEX ix_definition_search_vector ON public.definition USING gin (search_vector);
ERROR:  relation "ix_document_search_vector" already exists
STATEMENT:  CREATE INDEX ix_document_search_vector ON public.document USING gin (search_vector);
ERROR:  relation "ix_incident_search_vector" already exists
STATEMENT:  CREATE INDEX ix_incident_search_vector ON public.incident USING gin (search_vector);
ERROR:  relation "ix_incident_type_search_vector" already exists
STATEMENT:  CREATE INDEX ix_incident_type_search_vector ON public.incident_type USING gin (search_vector);
ERROR:  relation "ix_individual_contact_search_vector" already exists
STATEMENT:  CREATE INDEX ix_individual_contact_search_vector ON public.individual_contact USING gin (search_vector);
ERROR:  relation "ix_policy_search_vector" already exists
STATEMENT:  CREATE INDEX ix_policy_search_vector ON public.policy USING gin (search_vector);
ERROR:  relation "ix_service_search_vector" already exists
STATEMENT:  CREATE INDEX ix_service_search_vector ON public.service USING gin (search_vector);
ERROR:  relation "ix_task_search_vector" already exists
STATEMENT:  CREATE INDEX ix_task_search_vector ON public.task USING gin (search_vector);
ERROR:  relation "ix_team_contact_search_vector" already exists
STATEMENT:  CREATE INDEX ix_team_contact_search_vector ON public.team_contact USING gin (search_vector);
ERROR:  relation "ix_term_search_vector" already exists
STATEMENT:  CREATE INDEX ix_term_search_vector ON public.term USING gin (search_vector);
ERROR:  trigger "application_search_vector_trigger" for relation "application" already exists
STATEMENT:  CREATE TRIGGER application_search_vector_trigger BEFORE INSERT OR UPDATE ON public.application FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('search_vector', 'pg_catalog.english', 'name');
ERROR:  trigger "definition_search_vector_trigger" for relation "definition" already exists
STATEMENT:  CREATE TRIGGER definition_search_vector_trigger BEFORE INSERT OR UPDATE ON public.definition FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('search_vector', 'pg_catalog.english', 'text');
ERROR:  trigger "document_search_vector_trigger" for relation "document" already exists
STATEMENT:  CREATE TRIGGER document_search_vector_trigger BEFORE INSERT OR UPDATE ON public.document FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('search_vector', 'pg_catalog.english', 'name');
ERROR:  trigger "incident_search_vector_trigger" for relation "incident" already exists
STATEMENT:  CREATE TRIGGER incident_search_vector_trigger BEFORE INSERT OR UPDATE ON public.incident FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('search_vector', 'pg_catalog.english', 'name', 'title', 'description');
ERROR:  trigger "incident_type_search_vector_trigger" for relation "incident_type" already exists
STATEMENT:  CREATE TRIGGER incident_type_search_vector_trigger BEFORE INSERT OR UPDATE ON public.incident_type FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('search_vector', 'pg_catalog.english', 'name', 'description');
ERROR:  trigger "individual_contact_search_vector_trigger" for relation "individual_contact" already exists
STATEMENT:  CREATE TRIGGER individual_contact_search_vector_trigger BEFORE INSERT OR UPDATE ON public.individual_contact FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('search_vector', 'pg_catalog.english', 'name', 'title', 'company', 'notes');
ERROR:  trigger "policy_search_vector_trigger" for relation "policy" already exists
STATEMENT:  CREATE TRIGGER policy_search_vector_trigger BEFORE INSERT OR UPDATE ON public.policy FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('search_vector', 'pg_catalog.english', 'name', 'description');
ERROR:  trigger "service_search_vector_trigger" for relation "service" already exists
STATEMENT:  CREATE TRIGGER service_search_vector_trigger BEFORE INSERT OR UPDATE ON public.service FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('search_vector', 'pg_catalog.english', 'name');
ERROR:  trigger "task_search_vector_trigger" for relation "task" already exists
STATEMENT:  CREATE TRIGGER task_search_vector_trigger BEFORE INSERT OR UPDATE ON public.task FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('search_vector', 'pg_catalog.english', 'description');
ERROR:  trigger "team_contact_search_vector_trigger" for relation "team_contact" already exists
STATEMENT:  CREATE TRIGGER team_contact_search_vector_trigger BEFORE INSERT OR UPDATE ON public.team_contact FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('search_vector', 'pg_catalog.english', 'name', 'company', 'notes');
ERROR:  trigger "term_search_vector_trigger" for relation "term" already exists
STATEMENT:  CREATE TRIGGER term_search_vector_trigger BEFORE INSERT OR UPDATE ON public.term FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('search_vector', 'pg_catalog.english', 'text');
ERROR:  constraint "applications_incidents_application_id_fkey" for relation "applications_incidents" already exists
STATEMENT:  ALTER TABLE ONLY public.applications_incidents
	    ADD CONSTRAINT applications_incidents_application_id_fkey FOREIGN KEY (application_id) REFERENCES public.application(id);
ERROR:  constraint "applications_incidents_incident_id_fkey" for relation "applications_incidents" already exists
STATEMENT:  ALTER TABLE ONLY public.applications_incidents
	    ADD CONSTRAINT applications_incidents_incident_id_fkey FOREIGN KEY (incident_id) REFERENCES public.incident(id);
ERROR:  constraint "assoc_incident_terms_incident_id_fkey" for relation "assoc_incident_terms" already exists
STATEMENT:  ALTER TABLE ONLY public.assoc_incident_terms
	    ADD CONSTRAINT assoc_incident_terms_incident_id_fkey FOREIGN KEY (incident_id) REFERENCES public.incident(id);
ERROR:  constraint "assoc_incident_terms_term_id_fkey" for relation "assoc_incident_terms" already exists
STATEMENT:  ALTER TABLE ONLY public.assoc_incident_terms
	    ADD CONSTRAINT assoc_incident_terms_term_id_fkey FOREIGN KEY (term_id) REFERENCES public.term(id);
ERROR:  constraint "assoc_individual_contact_incident_pr_individual_contact_id_fkey" for relation "assoc_individual_contact_incident_priority" already exists
STATEMENT:  ALTER TABLE ONLY public.assoc_individual_contact_incident_priority
	    ADD CONSTRAINT assoc_individual_contact_incident_pr_individual_contact_id_fkey FOREIGN KEY (individual_contact_id) REFERENCES public.individual_contact(id);
ERROR:  constraint "assoc_individual_contact_incident_pri_incident_priority_id_fkey" for relation "assoc_individual_contact_incident_priority" already exists
STATEMENT:  ALTER TABLE ONLY public.assoc_individual_contact_incident_priority
	    ADD CONSTRAINT assoc_individual_contact_incident_pri_incident_priority_id_fkey FOREIGN KEY (incident_priority_id) REFERENCES public.incident_priority(id);
ERROR:  constraint "assoc_individual_contact_incident_ty_individual_contact_id_fkey" for relation "assoc_individual_contact_incident_type" already exists
STATEMENT:  ALTER TABLE ONLY public.assoc_individual_contact_incident_type
	    ADD CONSTRAINT assoc_individual_contact_incident_ty_individual_contact_id_fkey FOREIGN KEY (individual_contact_id) REFERENCES public.individual_contact(id);
ERROR:  constraint "assoc_individual_contact_incident_type_incident_type_id_fkey" for relation "assoc_individual_contact_incident_type" already exists
STATEMENT:  ALTER TABLE ONLY public.assoc_individual_contact_incident_type
	    ADD CONSTRAINT assoc_individual_contact_incident_type_incident_type_id_fkey FOREIGN KEY (incident_type_id) REFERENCES public.incident_type(id);
ERROR:  constraint "assoc_individual_contact_terms_individual_contact_id_fkey" for relation "assoc_individual_contact_terms" already exists
STATEMENT:  ALTER TABLE ONLY public.assoc_individual_contact_terms
	    ADD CONSTRAINT assoc_individual_contact_terms_individual_contact_id_fkey FOREIGN KEY (individual_contact_id) REFERENCES public.individual_contact(id);
ERROR:  constraint "assoc_individual_contact_terms_term_id_fkey" for relation "assoc_individual_contact_terms" already exists
STATEMENT:  ALTER TABLE ONLY public.assoc_individual_contact_terms
	    ADD CONSTRAINT assoc_individual_contact_terms_term_id_fkey FOREIGN KEY (term_id) REFERENCES public.term(id);
ERROR:  constraint "conference_incident_id_fkey" for relation "conference" already exists
STATEMENT:  ALTER TABLE ONLY public.conference
	    ADD CONSTRAINT conference_incident_id_fkey FOREIGN KEY (incident_id) REFERENCES public.incident(id);
ERROR:  constraint "conversation_incident_id_fkey" for relation "conversation" already exists
STATEMENT:  ALTER TABLE ONLY public.conversation
	    ADD CONSTRAINT conversation_incident_id_fkey FOREIGN KEY (incident_id) REFERENCES public.incident(id);
ERROR:  constraint "definition_teams_definition_id_fkey" for relation "definition_teams" already exists
STATEMENT:  ALTER TABLE ONLY public.definition_teams
	    ADD CONSTRAINT definition_teams_definition_id_fkey FOREIGN KEY (definition_id) REFERENCES public.definition(id);
ERROR:  constraint "definition_teams_team_contact_id_fkey" for relation "definition_teams" already exists
STATEMENT:  ALTER TABLE ONLY public.definition_teams
	    ADD CONSTRAINT definition_teams_team_contact_id_fkey FOREIGN KEY (team_contact_id) REFERENCES public.team_contact(id);
ERROR:  constraint "definition_terms_definition_id_fkey" for relation "definition_terms" already exists
STATEMENT:  ALTER TABLE ONLY public.definition_terms
	    ADD CONSTRAINT definition_terms_definition_id_fkey FOREIGN KEY (definition_id) REFERENCES public.definition(id);
ERROR:  constraint "definition_terms_term_id_fkey" for relation "definition_terms" already exists
STATEMENT:  ALTER TABLE ONLY public.definition_terms
	    ADD CONSTRAINT definition_terms_term_id_fkey FOREIGN KEY (term_id) REFERENCES public.term(id);
ERROR:  constraint "document_incident_document_id_fkey" for relation "document_incident" already exists
STATEMENT:  ALTER TABLE ONLY public.document_incident
	    ADD CONSTRAINT document_incident_document_id_fkey FOREIGN KEY (document_id) REFERENCES public.document(id);
ERROR:  constraint "document_incident_id_fkey" for relation "document" already exists
STATEMENT:  ALTER TABLE ONLY public.document
	    ADD CONSTRAINT document_incident_id_fkey FOREIGN KEY (incident_id) REFERENCES public.incident(id);
ERROR:  constraint "document_incident_incident_id_fkey" for relation "document_incident" already exists
STATEMENT:  ALTER TABLE ONLY public.document_incident
	    ADD CONSTRAINT document_incident_incident_id_fkey FOREIGN KEY (incident_id) REFERENCES public.incident(id);
ERROR:  constraint "document_incident_priority_document_id_fkey" for relation "document_incident_priority" already exists
STATEMENT:  ALTER TABLE ONLY public.document_incident_priority
	    ADD CONSTRAINT document_incident_priority_document_id_fkey FOREIGN KEY (document_id) REFERENCES public.document(id);
ERROR:  constraint "document_incident_priority_incident_priority_id_fkey" for relation "document_incident_priority" already exists
STATEMENT:  ALTER TABLE ONLY public.document_incident_priority
	    ADD CONSTRAINT document_incident_priority_incident_priority_id_fkey FOREIGN KEY (incident_priority_id) REFERENCES public.incident_priority(id);
ERROR:  constraint "document_incident_type_document_id_fkey" for relation "document_incident_type" already exists
STATEMENT:  ALTER TABLE ONLY public.document_incident_type
	    ADD CONSTRAINT document_incident_type_document_id_fkey FOREIGN KEY (document_id) REFERENCES public.document(id);
ERROR:  constraint "document_incident_type_incident_type_id_fkey" for relation "document_incident_type" already exists
STATEMENT:  ALTER TABLE ONLY public.document_incident_type
	    ADD CONSTRAINT document_incident_type_incident_type_id_fkey FOREIGN KEY (incident_type_id) REFERENCES public.incident_type(id);
ERROR:  constraint "document_terms_document_id_fkey" for relation "document_terms" already exists
STATEMENT:  ALTER TABLE ONLY public.document_terms
	    ADD CONSTRAINT document_terms_document_id_fkey FOREIGN KEY (document_id) REFERENCES public.document(id);
ERROR:  constraint "document_terms_term_id_fkey" for relation "document_terms" already exists
STATEMENT:  ALTER TABLE ONLY public.document_terms
	    ADD CONSTRAINT document_terms_term_id_fkey FOREIGN KEY (term_id) REFERENCES public.term(id);
ERROR:  constraint "group_incident_id_fkey" for relation "group" already exists
STATEMENT:  ALTER TABLE ONLY public."group"
	    ADD CONSTRAINT group_incident_id_fkey FOREIGN KEY (incident_id) REFERENCES public.incident(id);
ERROR:  constraint "incident_incident_priority_id_fkey" for relation "incident" already exists
STATEMENT:  ALTER TABLE ONLY public.incident
	    ADD CONSTRAINT incident_incident_priority_id_fkey FOREIGN KEY (incident_priority_id) REFERENCES public.incident_priority(id);
ERROR:  constraint "incident_incident_type_id_fkey" for relation "incident" already exists
STATEMENT:  ALTER TABLE ONLY public.incident
	    ADD CONSTRAINT incident_incident_type_id_fkey FOREIGN KEY (incident_type_id) REFERENCES public.incident_type(id);
ERROR:  constraint "incident_type_commander_service_id_fkey" for relation "incident_type" already exists
STATEMENT:  ALTER TABLE ONLY public.incident_type
	    ADD CONSTRAINT incident_type_commander_service_id_fkey FOREIGN KEY (commander_service_id) REFERENCES public.service(id);
ERROR:  constraint "incident_type_template_document_id_fkey" for relation "incident_type" already exists
STATEMENT:  ALTER TABLE ONLY public.incident_type
	    ADD CONSTRAINT incident_type_template_document_id_fkey FOREIGN KEY (template_document_id) REFERENCES public.document(id);
ERROR:  constraint "individual_contact_team_contact_id_fkey" for relation "individual_contact" already exists
STATEMENT:  ALTER TABLE ONLY public.individual_contact
	    ADD CONSTRAINT individual_contact_team_contact_id_fkey FOREIGN KEY (team_contact_id) REFERENCES public.team_contact(id);
ERROR:  constraint "participant_incident_id_fkey" for relation "participant" already exists
STATEMENT:  ALTER TABLE ONLY public.participant
	    ADD CONSTRAINT participant_incident_id_fkey FOREIGN KEY (incident_id) REFERENCES public.incident(id);
ERROR:  constraint "participant_individual_contact_id_fkey" for relation "participant" already exists
STATEMENT:  ALTER TABLE ONLY public.participant
	    ADD CONSTRAINT participant_individual_contact_id_fkey FOREIGN KEY (individual_contact_id) REFERENCES public.individual_contact(id);
ERROR:  constraint "participant_role_participant_id_fkey" for relation "participant_role" already exists
STATEMENT:  ALTER TABLE ONLY public.participant_role
	    ADD CONSTRAINT participant_role_participant_id_fkey FOREIGN KEY (participant_id) REFERENCES public.participant(id);
ERROR:  constraint "recommendation_accuracy_recommendation_id_fkey" for relation "recommendation_accuracy" already exists
STATEMENT:  ALTER TABLE ONLY public.recommendation_accuracy
	    ADD CONSTRAINT recommendation_accuracy_recommendation_id_fkey FOREIGN KEY (recommendation_id) REFERENCES public.recommendation(id);
ERROR:  constraint "recommendation_documents_document_id_fkey" for relation "recommendation_documents" already exists
STATEMENT:  ALTER TABLE ONLY public.recommendation_documents
	    ADD CONSTRAINT recommendation_documents_document_id_fkey FOREIGN KEY (document_id) REFERENCES public.document(id);
ERROR:  constraint "recommendation_documents_recommendation_id_fkey" for relation "recommendation_documents" already exists
STATEMENT:  ALTER TABLE ONLY public.recommendation_documents
	    ADD CONSTRAINT recommendation_documents_recommendation_id_fkey FOREIGN KEY (recommendation_id) REFERENCES public.recommendation(id);
ERROR:  constraint "recommendation_incident_priorities_incident_priority_id_fkey" for relation "recommendation_incident_priorities" already exists
STATEMENT:  ALTER TABLE ONLY public.recommendation_incident_priorities
	    ADD CONSTRAINT recommendation_incident_priorities_incident_priority_id_fkey FOREIGN KEY (incident_priority_id) REFERENCES public.incident_priority(id);
ERROR:  constraint "recommendation_incident_priorities_recommendation_id_fkey" for relation "recommendation_incident_priorities" already exists
STATEMENT:  ALTER TABLE ONLY public.recommendation_incident_priorities
	    ADD CONSTRAINT recommendation_incident_priorities_recommendation_id_fkey FOREIGN KEY (recommendation_id) REFERENCES public.recommendation(id);
ERROR:  constraint "recommendation_incident_types_incident_type_id_fkey" for relation "recommendation_incident_types" already exists
STATEMENT:  ALTER TABLE ONLY public.recommendation_incident_types
	    ADD CONSTRAINT recommendation_incident_types_incident_type_id_fkey FOREIGN KEY (incident_type_id) REFERENCES public.incident_type(id);
ERROR:  constraint "recommendation_incident_types_recommendation_id_fkey" for relation "recommendation_incident_types" already exists
STATEMENT:  ALTER TABLE ONLY public.recommendation_incident_types
	    ADD CONSTRAINT recommendation_incident_types_recommendation_id_fkey FOREIGN KEY (recommendation_id) REFERENCES public.recommendation(id);
ERROR:  constraint "recommendation_individual_contacts_individual_contact_id_fkey" for relation "recommendation_individual_contacts" already exists
STATEMENT:  ALTER TABLE ONLY public.recommendation_individual_contacts
	    ADD CONSTRAINT recommendation_individual_contacts_individual_contact_id_fkey FOREIGN KEY (individual_contact_id) REFERENCES public.individual_contact(id);
ERROR:  constraint "recommendation_individual_contacts_recommendation_id_fkey" for relation "recommendation_individual_contacts" already exists
STATEMENT:  ALTER TABLE ONLY public.recommendation_individual_contacts
	    ADD CONSTRAINT recommendation_individual_contacts_recommendation_id_fkey FOREIGN KEY (recommendation_id) REFERENCES public.recommendation(id);
ERROR:  constraint "recommendation_services_recommendation_id_fkey" for relation "recommendation_services" already exists
STATEMENT:  ALTER TABLE ONLY public.recommendation_services
	    ADD CONSTRAINT recommendation_services_recommendation_id_fkey FOREIGN KEY (recommendation_id) REFERENCES public.recommendation(id);
ERROR:  constraint "recommendation_services_service_id_fkey" for relation "recommendation_services" already exists
STATEMENT:  ALTER TABLE ONLY public.recommendation_services
	    ADD CONSTRAINT recommendation_services_service_id_fkey FOREIGN KEY (service_id) REFERENCES public.service(id);
ERROR:  constraint "recommendation_team_contacts_recommendation_id_fkey" for relation "recommendation_team_contacts" already exists
STATEMENT:  ALTER TABLE ONLY public.recommendation_team_contacts
	    ADD CONSTRAINT recommendation_team_contacts_recommendation_id_fkey FOREIGN KEY (recommendation_id) REFERENCES public.recommendation(id);
ERROR:  constraint "recommendation_team_contacts_team_contact_id_fkey" for relation "recommendation_team_contacts" already exists
STATEMENT:  ALTER TABLE ONLY public.recommendation_team_contacts
	    ADD CONSTRAINT recommendation_team_contacts_team_contact_id_fkey FOREIGN KEY (team_contact_id) REFERENCES public.team_contact(id);
ERROR:  constraint "recommendation_terms_recommendation_id_fkey" for relation "recommendation_terms" already exists
STATEMENT:  ALTER TABLE ONLY public.recommendation_terms
	    ADD CONSTRAINT recommendation_terms_recommendation_id_fkey FOREIGN KEY (recommendation_id) REFERENCES public.recommendation(id);
ERROR:  constraint "recommendation_terms_term_id_fkey" for relation "recommendation_terms" already exists
STATEMENT:  ALTER TABLE ONLY public.recommendation_terms
	    ADD CONSTRAINT recommendation_terms_term_id_fkey FOREIGN KEY (term_id) REFERENCES public.term(id);
ERROR:  constraint "service_incident_incident_id_fkey" for relation "service_incident" already exists
STATEMENT:  ALTER TABLE ONLY public.service_incident
	    ADD CONSTRAINT service_incident_incident_id_fkey FOREIGN KEY (incident_id) REFERENCES public.incident(id);
ERROR:  constraint "service_incident_priority_incident_priority_id_fkey" for relation "service_incident_priority" already exists
STATEMENT:  ALTER TABLE ONLY public.service_incident_priority
	    ADD CONSTRAINT service_incident_priority_incident_priority_id_fkey FOREIGN KEY (incident_priority_id) REFERENCES public.incident_priority(id);
ERROR:  constraint "service_incident_priority_service_id_fkey" for relation "service_incident_priority" already exists
STATEMENT:  ALTER TABLE ONLY public.service_incident_priority
	    ADD CONSTRAINT service_incident_priority_service_id_fkey FOREIGN KEY (service_id) REFERENCES public.service(id);
ERROR:  constraint "service_incident_service_id_fkey" for relation "service_incident" already exists
STATEMENT:  ALTER TABLE ONLY public.service_incident
	    ADD CONSTRAINT service_incident_service_id_fkey FOREIGN KEY (service_id) REFERENCES public.service(id);
ERROR:  constraint "service_incident_type_incident_type_id_fkey" for relation "service_incident_type" already exists
STATEMENT:  ALTER TABLE ONLY public.service_incident_type
	    ADD CONSTRAINT service_incident_type_incident_type_id_fkey FOREIGN KEY (incident_type_id) REFERENCES public.incident_type(id);
ERROR:  constraint "service_incident_type_service_id_fkey" for relation "service_incident_type" already exists
STATEMENT:  ALTER TABLE ONLY public.service_incident_type
	    ADD CONSTRAINT service_incident_type_service_id_fkey FOREIGN KEY (service_id) REFERENCES public.service(id);
ERROR:  constraint "service_terms_service_id_fkey" for relation "service_terms" already exists
STATEMENT:  ALTER TABLE ONLY public.service_terms
	    ADD CONSTRAINT service_terms_service_id_fkey FOREIGN KEY (service_id) REFERENCES public.service(id);
ERROR:  constraint "service_terms_term_id_fkey" for relation "service_terms" already exists
STATEMENT:  ALTER TABLE ONLY public.service_terms
	    ADD CONSTRAINT service_terms_term_id_fkey FOREIGN KEY (term_id) REFERENCES public.term(id);
ERROR:  constraint "status_report_incident_id_fkey" for relation "status_report" already exists
STATEMENT:  ALTER TABLE ONLY public.status_report
	    ADD CONSTRAINT status_report_incident_id_fkey FOREIGN KEY (incident_id) REFERENCES public.incident(id);
ERROR:  constraint "status_report_participant_id_fkey" for relation "status_report" already exists
STATEMENT:  ALTER TABLE ONLY public.status_report
	    ADD CONSTRAINT status_report_participant_id_fkey FOREIGN KEY (participant_id) REFERENCES public.participant(id);
ERROR:  constraint "storage_incident_id_fkey" for relation "storage" already exists
STATEMENT:  ALTER TABLE ONLY public.storage
	    ADD CONSTRAINT storage_incident_id_fkey FOREIGN KEY (incident_id) REFERENCES public.incident(id);
ERROR:  constraint "task_incident_id_fkey" for relation "task" already exists
STATEMENT:  ALTER TABLE ONLY public.task
	    ADD CONSTRAINT task_incident_id_fkey FOREIGN KEY (incident_id) REFERENCES public.incident(id);
ERROR:  constraint "team_contact_incident_incident_id_fkey" for relation "team_contact_incident" already exists
STATEMENT:  ALTER TABLE ONLY public.team_contact_incident
	    ADD CONSTRAINT team_contact_incident_incident_id_fkey FOREIGN KEY (incident_id) REFERENCES public.incident(id);
ERROR:  constraint "team_contact_incident_priority_incident_priority_id_fkey" for relation "team_contact_incident_priority" already exists
STATEMENT:  ALTER TABLE ONLY public.team_contact_incident_priority
	    ADD CONSTRAINT team_contact_incident_priority_incident_priority_id_fkey FOREIGN KEY (incident_priority_id) REFERENCES public.incident_priority(id);
ERROR:  constraint "team_contact_incident_priority_team_contact_id_fkey" for relation "team_contact_incident_priority" already exists
STATEMENT:  ALTER TABLE ONLY public.team_contact_incident_priority
	    ADD CONSTRAINT team_contact_incident_priority_team_contact_id_fkey FOREIGN KEY (team_contact_id) REFERENCES public.team_contact(id);
ERROR:  constraint "team_contact_incident_team_contact_id_fkey" for relation "team_contact_incident" already exists
STATEMENT:  ALTER TABLE ONLY public.team_contact_incident
	    ADD CONSTRAINT team_contact_incident_team_contact_id_fkey FOREIGN KEY (team_contact_id) REFERENCES public.team_contact(id);
ERROR:  constraint "team_contact_incident_type_incident_type_id_fkey" for relation "team_contact_incident_type" already exists
STATEMENT:  ALTER TABLE ONLY public.team_contact_incident_type
	    ADD CONSTRAINT team_contact_incident_type_incident_type_id_fkey FOREIGN KEY (incident_type_id) REFERENCES public.incident_type(id);
ERROR:  constraint "team_contact_incident_type_team_contact_id_fkey" for relation "team_contact_incident_type" already exists
STATEMENT:  ALTER TABLE ONLY public.team_contact_incident_type
	    ADD CONSTRAINT team_contact_incident_type_team_contact_id_fkey FOREIGN KEY (team_contact_id) REFERENCES public.team_contact(id);
ERROR:  constraint "team_contact_terms_team_contact_id_fkey" for relation "team_contact_terms" already exists
STATEMENT:  ALTER TABLE ONLY public.team_contact_terms
	    ADD CONSTRAINT team_contact_terms_team_contact_id_fkey FOREIGN KEY (team_contact_id) REFERENCES public.team_contact(id);
ERROR:  constraint "team_contact_terms_term_id_fkey" for relation "team_contact_terms" already exists
STATEMENT:  ALTER TABLE ONLY public.team_contact_terms
	    ADD CONSTRAINT team_contact_terms_term_id_fkey FOREIGN KEY (term_id) REFERENCES public.term(id);
ERROR:  constraint "ticket_incident_id_fkey" for relation "ticket" already exists
STATEMENT:  ALTER TABLE ONLY public.ticket
	    ADD CONSTRAINT ticket_incident_id_fkey FOREIGN KEY (incident_id) REFERENCES public.incident(id);

That's the whole thing from just that command :D

[mogindi]

btw I ran the above after running dispatch database init, so looks like the tables were already there

[diogomatsubara]

Hi @mogindi, I think I found the issue. I just made PR #199 with a fix. When you drop the database, using dispatch database drop, dispatch uses sqlalchemy and drops the database configured by DATABASE_NAME. When we use restore without the patch above, psql correctly checks that the DATABASE_NAME exists but then it restores to the default database postgres. I think that's why we get the error the all the tables, functions, etc already exists.

So, in short, once you do docker-compose up, you can log into the dispatch container and run dispatch database restore --dump-fille data/dispatch-sample-data.dump
dispatch database upgrade

and you should be good to go.

In case you need to reset the db and start over from scratch without any sample data:
dispatch database drop
dispatch database init
dispatch database upgrade

I hope this helps. I successfully repeated the steps above using the branch in PR in the docker-compose.yaml context section. Let me know if it works or if you run into trouble and I'll help you out. Thanks a lot for the feedback!

[mogindi]

Hey! appreciate your help :)

I saw the PR(s) are merged so now I'm rebuilding and redeploying.

Would I still need run dispatch database upgrade ?

[diogomatsubara]

Yes, because then the upgrade will run the migrations to keep the schema up to date with the new changes. I didn't test with the latest changes on develop but if it breaks let me know and I'll try to fix.

[mogindi]

still having issues.

but another error just started appearing that blocking this

with dispatch database upgrade (even as part of dispatch-docker/install.sh):

alembic.util.exc.CommandError: Requested revision b12f7a59ced9 overlaps with other requested revisions 343bc4e6aa79

[diogomatsubara]

I'm unable to reproduce this. Could you share the exact steps? I also noticed that @kevgliss merged in cc47103b223838a30dc3d5ab22da33300fea2bdf a fix for multiple revision heads which might be related. I'm not super familiar with alembic so I'm not sure how to help out further.

[kevgliss]

@mogindi the issue with multiple heads issue was fixed in: cc47103

[mogindi]

I just tried to rebuild (just now) with ./install.sh
and when getting to the dispatch database upgrade command I still got
alembic.util.exc.CommandError: Requested revision b12f7a59ced9 overlaps with other requested revisions 343bc4e6aa79

[mogindi]

@kevgliss any ideas?
I could try to file a new bug report for it

fresh build after doing git pull of dispatch-docker results in:
alembic.util.exc.CommandError: Requested revision b12f7a59ced9 overlaps with other requested revisions 343bc4e6aa79