Skip to content

Instantly share code, notes, and snippets.

@JLDLaughlin
Created September 3, 2020 18:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save JLDLaughlin/5b3b70012d66b40c76919b37dbcb8df5 to your computer and use it in GitHub Desktop.
Save JLDLaughlin/5b3b70012d66b40c76919b37dbcb8df5 to your computer and use it in GitHub Desktop.
2020-09-03 14:50:39.705 EDT root jessicalaughlin 82223 127.0.0.1:54813 5f513aff.1412f 1 startup 2020-09-03 14:50:39 EDT 4/853 0 FATAL 28000 role "root" does not exist
2020-09-03 14:50:39.813 EDT root jessicalaughlin 82224 127.0.0.1:54814 5f513aff.14130 1 startup 2020-09-03 14:50:39 EDT 4/854 0 FATAL 28000 role "root" does not exist
2020-09-03 14:52:46.870 EDT jessicalaughlin jessicalaughlin 62561 [local] 5f500d7b.f461 4 idle 2020-09-02 17:24:11 EDT 3/5 0 ERROR 42601 syntax error at or near "/" /conninfo ; 1 psql
2020-09-03 14:52:48.086 EDT jessicalaughlin jessicalaughlin 62561 [local] 5f500d7b.f461 5 idle 2020-09-02 17:24:11 EDT 3/6 0 LOG 00000 statement: ; psql
2020-09-03 14:52:56.177 EDT jessicalaughlin jessicalaughlin 62561 [local] 5f500d7b.f461 6 idle 2020-09-02 17:24:11 EDT 3/7 0 LOG 00000 statement: select current_user; psql
2020-09-03 14:53:06.367 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 1 idle 2020-09-03 14:53:06 EDT 4/862 0 LOG 00000 statement: SET client_encoding = 'UTF8';SET client_min_messages TO WARNING;
2020-09-03 14:53:06.368 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 2 BEGIN 2020-09-03 14:53:06 EDT 4/864 0 LOG 00000 execute 0: BEGIN ISOLATION LEVEL SERIALIZABLE READ WRITE
2020-09-03 14:53:06.371 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 3 SET 2020-09-03 14:53:06 EDT 4/864 0 LOG 00000 execute <unnamed>: SET LOCAL "hasura.user" = '{}'
2020-09-03 14:53:06.389 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 4 SELECT 2020-09-03 14:53:06 EDT 4/864 0 LOG 00000 execute <unnamed>: SELECT EXISTS ( SELECT 1 FROM information_schema.schemata WHERE schema_name = $1 ) parameters: $1 = 'hdb_catalog'
2020-09-03 14:53:06.389 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 5 CREATE SCHEMA 2020-09-03 14:53:06 EDT 4/864 0 LOG 00000 execute <unnamed>: CREATE SCHEMA hdb_catalog
2020-09-03 14:53:06.392 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 6 CREATE SCHEMA 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: CREATE SCHEMA hdb_views
2020-09-03 14:53:06.395 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 7 SELECT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: SELECT EXISTS ( SELECT 1 FROM pg_catalog.pg_available_extensions WHERE name = $1 ) parameters: $1 = 'pgcrypto'
2020-09-03 14:53:06.412 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 8 CREATE EXTENSION 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: CREATE EXTENSION IF NOT EXISTS pgcrypto SCHEMA public
2020-09-03 14:53:06.538 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 9 idle in transaction 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 statement: CREATE TABLE hdb_catalog.hdb_version ( hasura_uuid UUID PRIMARY KEY DEFAULT gen_random_uuid(), version TEXT NOT NULL, upgraded_on TIMESTAMPTZ NOT NULL, cli_state JSONB NOT NULL DEFAULT '{}'::jsonb, console_state JSONB NOT NULL DEFAULT '{}'::jsonb ); CREATE UNIQUE INDEX hdb_version_one_row ON hdb_catalog.hdb_version((version IS NOT NULL)); /* Note [Reference system columns using type name] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ While working on #3394, I (Alexis) discovered that Postgres seems to sometimes generate very bad query plans when joining against the system catalogs if we store things like table/schema names using type `text` rather than type `name`, the latter of which is used internally. The two types are compatible in the sense that Postgres will willingly widen `name` to `type` automatically, but `name`s are restricted to 64 bytes. Using `name` for ordinary user data would be a deep sin, but using it to store references to actual Postgres identifiers makes a lot of sense, so using `name` in those places is alright. And by doing so, we make Postgres much more likely to take advantage of certain indexes that can significantly improve query performance. */ CREATE TABLE hdb_catalog.hdb_table ( table_schema name, -- See Note [Reference system columns using type name] table_name name, configuration jsonb, is_system_defined boolean default false, is_enum boolean NOT NULL DEFAULT false, PRIMARY KEY (table_schema, table_name) ); CREATE TABLE hdb_catalog.hdb_relationship ( table_schema name, -- See Note [Reference system columns using type name] table_name name, rel_name TEXT, rel_type TEXT CHECK (rel_type IN ('object', 'array')), rel_def JSONB NOT NULL, comment TEXT NULL, is_system_defined boolean default false, PRIMARY KEY (table_schema, table_name, rel_name), FOREIGN KEY (table_schema, table_name) REFERENCES hdb_catalog.hdb_table(table_schema, table_name) ON UPDATE CASCADE ); CREATE TABLE hdb_catalog.hdb_remote_relationship ( remote_relationship_name TEXT NOT NULL, table_schema name NOT NULL, table_name name NOT NULL, definition JSONB NOT NULL, PRIMARY KEY (remote_relationship_name, table_schema, table_name), FOREIGN KEY (table_schema, table_name) REFERENCES hdb_catalog.hdb_table(table_schema, table_name) ON UPDATE CASCADE ); CREATE TABLE hdb_catalog.hdb_permission ( table_schema name, -- See Note [Reference system columns using type name] table_name name, role_name TEXT, perm_type TEXT CHECK(perm_type IN ('insert', 'select', 'update', 'delete')), perm_def JSONB NOT NULL, comment TEXT NULL, is_system_defined boolean default false, PRIMARY KEY (table_schema, table_name, role_name, perm_type), FOREIGN KEY (table_schema, table_name) REFERENCES hdb_catalog.hdb_table(table_schema, table_name) ON UPDATE CASCADE ); CREATE VIEW hdb_catalog.hdb_permission_agg AS SELECT table_schema, table_name, role_name, json_object_agg(perm_type, perm_def) as permissions FROM hdb_catalog.hdb_permission GROUP BY table_schema, table_name, role_name; CREATE VIEW hdb_catalog.hdb_foreign_key_constraint AS SELECT q.table_schema :: text, q.table_name :: text, q.constraint_name :: text, min(q.constraint_oid) :: integer as constraint_oid, min(q.ref_table_table_schema) :: text as ref_table_table_schema, min(q.ref_table) :: text as ref_table, json_object_agg(ac.attname, afc.attname) as column_mapping, min(q.confupdtype) :: text as on_update, min(q.confdeltype) :: text as on_delete, json_agg(ac.attname) as columns, json_agg(afc.attname) as ref_columns FROM (SELECT ctn.nspname AS table_schema, ct.relname AS table_name, r.conrelid AS table_id, r.conname as constraint_name, r.oid as constraint_oid, cftn.nspname AS ref_table_table_schema, cft.relname as ref_table, r.confrelid as ref_table_id, r.confupdtype, r.confdeltype, UNNEST (r.conkey) AS column_id, UNNEST (r.confkey) AS ref_column_id FROM pg_catalog.pg_constraint r JOIN pg_catalog.pg_class ct ON r.conrelid = ct.oid JOIN pg_catalog.pg_namespace ctn ON ct.relnamespace = ctn.oid JOIN pg_catalog.pg_class cft ON r.confrelid = cft.oid JOIN pg_catalog.pg_namespace cftn ON cft.relnamespace = cftn.oid WHERE r.contype = 'f' ) q JOIN pg_catalog.pg_attribute ac ON q.column_id = ac.attnum AND q.table_id = ac.attrelid JOIN pg_catalog.pg_attribute afc ON q.ref_column_id = afc.attnum AND q.ref_table_id = afc.attrelid GROUP BY q.table_schema, q.table_name, q.constraint_name; CREATE VIEW hdb_catalog.hdb_check_constraint AS SELECT n.nspname :: text AS table_schema, ct.relname :: text AS table_name, r.conname :: text as constraint_name, pg_catalog.pg_get_constraintdef(r.oid, true) as check FROM pg_catalog.pg_constraint r JOIN pg_catalog.pg_class ct ON r.conrelid = ct.oid JOIN pg_catalog.pg_namespace n ON ct.relnamespace = n.oid WHERE r.contype = 'c'; CREATE VIEW hdb_catalog.hdb_unique_constraint AS SELECT tc.table_name, tc.constraint_schema AS table_schema, tc.constraint_name as constraint_name, json_agg(kcu.column_name) AS columns FROM information_schema.table_constraints tc JOIN information_schema.key_column_usage AS kcu USING (constraint_schema, constraint_name) WHERE constraint_type = 'UNIQUE' GROUP BY tc.table_name, tc.constraint_schema, tc.constraint_name; CREATE VIEW hdb_catalog.hdb_primary_key AS SELECT tc.table_schema, tc.table_name, tc.constraint_name, json_agg(constraint_column_usage.column_name) AS columns FROM ( information_schema.table_constraints tc JOIN ( SELECT x.tblschema AS table_schema, x.tblname AS table_name, x.colname AS column_name, x.cstrname AS constraint_name FROM ( SELECT DISTINCT nr.nspname, r.relname, a.attname, c.conname FROM pg_namespace nr, pg_class r, pg_attribute a, pg_depend d, pg_namespace nc, pg_constraint c WHERE ( (nr.oid = r.relnamespace) AND (r.oid = a.attrelid) AND (d.refclassid = ('pg_class' :: regclass) :: oid) AND (d.refobjid = r.oid) AND (d.refobjsubid = a.attnum) AND (d.classid = ('pg_constraint' :: regclass) :: oid) AND (d.objid = c.oid) AND (c.connamespace = nc.oid) AND (c.contype = 'c' :: "char") AND ( r.relkind = ANY (ARRAY ['r'::"char", 'p'::"char"]) ) AND (NOT a.attisdropped) ) UNION ALL SELECT nr.nspname, r.relname, a.attname, c.conname FROM pg_namespace nr, pg_class r, pg_attribute a, pg_namespace nc, pg_constraint c WHERE ( (nr.oid = r.relnamespace) AND (r.oid = a.attrelid) AND (nc.oid = c.connamespace) AND ( r.oid = CASE c.contype WHEN 'f' :: "char" THEN c.confrelid ELSE c.conrelid END ) AND ( a.attnum = ANY ( CASE c.contype WHEN 'f' :: "char" THEN c.confkey ELSE c.conkey END ) ) AND (NOT a.attisdropped) AND ( c.contype = ANY (ARRAY ['p'::"char", 'u'::"char", 'f'::"char"]) ) AND ( r.relkind = ANY (ARRAY ['r'::"char", 'p'::"char"]) ) ) ) x( tblschema, tblname, colname, cstrname ) ) constraint_column_usage ON ( ( (tc.constraint_name) :: text = (constraint_column_usage.constraint_name) :: text AND (tc.table_schema) :: text = (constraint_column_usage.table_schema) :: text AND (tc.table_name) :: text = (constraint_column_usage.table_name) :: text ) ) ) WHERE ((tc.constraint_type) :: text = 'PRIMARY KEY' :: text) GROUP BY tc.table_schema, tc.table_name, tc.constraint_name; CREATE FUNCTION hdb_catalog.inject_table_defaults(view_schema text, view_name text, tab_schema text, tab_name text) RETURNS void LANGUAGE plpgsql AS $$ DECLARE r RECORD; BEGIN FOR r IN SELECT column_name, column_default FROM information_schema.columns WHERE table_schema = tab_schema AND table_name = tab_name AND column_default IS NOT NULL LOOP EXECUTE format('ALTER VIEW %I.%I ALTER COLUMN %I SET DEFAULT %s;', view_schema, view_name, r.column_name, r.column_default); END LOOP; END; $$; CREATE TABLE hdb_catalog.event_triggers ( name TEXT PRIMARY KEY, type TEXT NOT NULL, schema_name TEXT NOT NULL, table_name TEXT NOT NULL, configuration JSON, comment TEXT, FOREIGN KEY (schema_name, table_name) REFERENCES hdb_catalog.hdb_table(table_schema, table_name) ON UPDATE CASCADE ); CREATE TABLE hdb_catalog.event_log ( id TEXT DEFAULT gen_random_uuid() PRIMARY KEY, schema_name TEXT NOT NULL, table_name TEXT NOT NULL, trigger_name TEXT NOT NULL, payload JSONB NOT NULL, delivered BOOLEAN NOT NULL DEFAULT FALSE, error BOOLEAN NOT NULL DEFAULT FALSE, tries INTEGER NOT NULL DEFAULT 0, created_at TIMESTAMP DEFAULT NOW(), locked BOOLEAN NOT NULL DEFAULT FALSE, next_retry_at TIMESTAMP, archived BOOLEAN NOT NULL DEFAULT FALSE ); CREATE INDEX ON hdb_catalog.event_log (trigger_name); CREATE INDEX ON hdb_catalog.event_log (locked); CREATE INDEX ON hdb_catalog.event_log (delivered); CREATE INDEX ON hdb_catalog.event_log (created_at); CREATE TABLE hdb_catalog.event_invocation_logs ( id TEXT DEFAULT gen_random_uuid() PRIMARY KEY, event_id TEXT, status INTEGER, request JSON, response JSON, created_at TIMESTAMP DEFAULT NOW(), FOREIGN KEY (event_id) REFERENCES hdb_catalog.event_log (id) ); CREATE INDEX ON hdb_catalog.event_invocation_logs (event_id); CREATE TABLE hdb_catalog.hdb_function ( function_schema TEXT, function_name TEXT, configuration JSONB NOT NULL DEFAULT '{}'::jsonb, is_system_defined boolean default false, PRIMARY KEY (function_schema, function_name) ); CREATE VIEW hdb_catalog.hdb_function_agg AS ( SELECT p.proname::text AS function_name, pn.nspname::text AS function_schema, pd.description, CASE WHEN (p.provariadic = (0) :: oid) THEN false ELSE true END AS has_variadic, CASE WHEN ( (p.provolatile) :: text = ('i' :: character(1)) :: text ) THEN 'IMMUTABLE' :: text WHEN ( (p.provolatile) :: text = ('s' :: character(1)) :: text ) THEN 'STABLE' :: text WHEN ( (p.provolatile) :: text = ('v' :: character(1)) :: text ) THEN 'VOLATILE' :: text ELSE NULL :: text END AS function_type, pg_get_functiondef(p.oid) AS function_definition, rtn.nspname::text as return_type_schema, rt.typname::text as return_type_name, rt.typtype::text as return_type_type, p.proretset AS returns_set, ( SELECT COALESCE(json_agg( json_build_object('schema', q."schema", 'name', q."name", 'type', q."type" ) ), '[]') FROM ( SELECT pt.typname AS "name", pns.nspname AS "schema", pt.typtype AS "type", pat.ordinality FROM unnest( COALESCE(p.proallargtypes, (p.proargtypes) :: oid []) ) WITH ORDINALITY pat(oid, ordinality) LEFT JOIN pg_type pt ON ((pt.oid = pat.oid)) LEFT JOIN pg_namespace pns ON (pt.typnamespace = pns.oid) ORDER BY pat.ordinality ASC ) q ) AS input_arg_types, to_json(COALESCE(p.proargnames, ARRAY [] :: text [])) AS input_arg_names, p.pronargdefaults AS default_args, p.oid::integer AS function_oid FROM pg_proc p JOIN pg_namespace pn ON (pn.oid = p.pronamespace) JOIN pg_type rt ON (rt.oid = p.prorettype) JOIN pg_namespace rtn ON (rtn.oid = rt.typnamespace) LEFT JOIN pg_description pd ON p.oid = pd.objoid WHERE pn.nspname :: text NOT LIKE 'pg_%' AND pn.nspname :: text NOT IN ('information_schema', 'hdb_catalog', 'hdb_views') AND (NOT EXISTS ( SELECT 1 FROM pg_aggregate WHERE ((pg_aggregate.aggfnoid) :: oid = p.oid) ) ) ); CREATE TABLE hdb_catalog.remote_schemas ( id BIGSERIAL PRIMARY KEY, name TEXT UNIQUE, definition JSON, comment TEXT ); CREATE TABLE hdb_catalog.hdb_schema_update_event ( instance_id uuid NOT NULL, occurred_at timestamptz NOT NULL DEFAULT NOW(), invalidations json NOT NULL ); CREATE UNIQUE INDEX hdb_schema_update_event_one_row ON hdb_catalog.hdb_schema_update_event ((occurred_at IS NOT NULL)); CREATE FUNCTION hdb_catalog.hdb_schema_update_event_notifier() RETURNS trigger AS $function$ DECLARE instance_id uuid; occurred_at timestamptz; invalidations json; curr_rec record; BEGIN instance_id = NEW.instance_id; occurred_at = NEW.occurred_at; invalidations = NEW.invalidations; PERFORM pg_notify('hasura_schema_update', json_build_object( 'instance_id', instance_id, 'occurred_at', occurred_at, 'invalidations', invalidations )::text); RETURN curr_rec; END; $function$ LANGUAGE plpgsql; CREATE TRIGGER hdb_schema_update_event_notifier AFTER INSERT OR UPDATE ON hdb_catalog.hdb_schema_update_event FOR EACH ROW EXECUTE PROCEDURE hdb_catalog.hdb_schema_update_event_notifier(); CREATE VIEW hdb_catalog.hdb_table_info_agg AS SELECT schema.nspname AS table_schema, "table".relname AS table_name, -- This field corresponds to the `CatalogTableInfo` Haskell type jsonb_build_object( 'oid',"table".oid :: integer, 'columns', coalesce(columns.info, '[]'), 'primary_key', primary_key.info, -- Note: unique_constraints does NOT include primary key constraints! 'unique_constraints', coalesce(unique_constraints.info, '[]'), 'foreign_keys', coalesce(foreign_key_constraints.info, '[]'), 'view_info', CASE "table".relkind WHEN 'v' THEN jsonb_build_object( 'is_updatable', ((pg_catalog.pg_relation_is_updatable("table".oid, true) & 4) = 4), 'is_insertable', ((pg_catalog.pg_relation_is_updatable("table".oid, true) & 8) = 8), 'is_deletable', ((pg_catalog.pg_relation_is_updatable("table".oid, true) & 16) = 16) ) END, 'description', description.description ) AS info -- table & schema FROM pg_catalog.pg_class "table" JOIN pg_catalog.pg_namespace schema ON schema.oid = "table".relnamespace -- description LEFT JOIN pg_catalog.pg_description description ON description.classoid = 'pg_catalog.pg_class'::regclass AND description.objoid = "table".oid AND description.objsubid = 0 -- columns LEFT JOIN LATERAL ( SELECT jsonb_agg(jsonb_build_object( 'name',"column".attname, 'position',"column".attnum, 'type', coalesce(base_type.typname,"type".typname), 'is_nullable', NOT "column".attnotnull, 'description', pg_catalog.col_description("table".oid,"column".attnum) )) AS info FROM pg_catalog.pg_attribute "column" LEFT JOIN pg_catalog.pg_type "type" ON "type".oid = "column".atttypid LEFT JOIN pg_catalog.pg_type base_type ON "type".typtype = 'd' AND base_type.oid = "type".typbasetype WHERE "column".attrelid = "table".oid -- columns where attnum <= 0 are special, system-defined columns AND "column".attnum > 0 -- dropped columns still exist in the system catalog as “zombie” columns, so ignore those AND NOT "column".attisdropped ) columns ON true -- primary key LEFT JOIN LATERAL ( SELECT jsonb_build_object( 'constraint', jsonb_build_object('name', class.relname, 'oid', class.oid :: integer), 'columns', coalesce(columns.info, '[]') ) AS info FROM pg_catalog.pg_index index JOIN pg_catalog.pg_class class ON class.oid = index.indexrelid LEFT JOIN LATERAL ( SELECT jsonb_agg("column".attname) AS info FROM pg_catalog.pg_attribute "column" WHERE "column".attrelid = "table".oid AND "column".attnum = ANY (index.indkey) ) AS columns ON true WHERE index.indrelid = "table".oid AND index.indisprimary ) primary_key ON true -- unique constraints LEFT JOIN LATERAL ( SELECT jsonb_agg(jsonb_build_object('name', class.relname, 'oid', class.oid :: integer)) AS info FROM pg_catalog.pg_index index JOIN pg_catalog.pg_class class ON class.oid = index.indexrelid WHERE index.indrelid = "table".oid AND index.indisunique AND NOT index.indisprimary ) unique_constraints ON true -- foreign keys LEFT JOIN LATERAL ( SELECT jsonb_agg(jsonb_build_object( 'constraint', jsonb_build_object( 'name', foreign_key.constraint_name, 'oid', foreign_key.constraint_oid :: integer ), 'columns', foreign_key.columns, 'foreign_table', jsonb_build_object( 'schema', foreign_key.ref_table_table_schema, 'name', foreign_key.ref_table ), 'foreign_columns', foreign_key.ref_columns )) AS info FROM hdb_catalog.hdb_foreign_key_constraint foreign_key WHERE foreign_key.table_schema = schema.nspname AND foreign_key.table_name = "table".relname ) foreign_key_constraints ON true -- all these identify table-like things WHERE "table".relkind IN ('r', 't', 'v', 'm', 'f', 'p'); CREATE VIEW hdb_catalog.hdb_function_info_agg AS ( SELECT function_name, function_schema, row_to_json ( ( SELECT e FROM ( SELECT description, has_variadic, function_type, return_type_schema, return_type_name, return_type_type, returns_set, input_arg_types, input_arg_names, default_args, exists( SELECT 1 FROM information_schema.tables WHERE table_schema = return_type_schema AND table_name = return_type_name ) AS returns_table ) AS e ) ) AS "function_info" FROM hdb_catalog.hdb_function_agg ); CREATE OR REPLACE FUNCTION hdb_catalog.insert_event_log(schema_name text, table_name text, trigger_name text, op text, row_data json) RETURNS text AS $$ DECLARE id text; payload json; session_variables json; server_version_num int; trace_context json; BEGIN id := gen_random_uuid(); server_version_num := current_setting('server_version_num'); IF server_version_num >= 90600 THEN session_variables := current_setting('hasura.user', 't'); trace_context := current_setting('hasura.tracecontext', 't'); ELSE BEGIN session_variables := current_setting('hasura.user'); EXCEPTION WHEN OTHERS THEN session_variables := NULL; END; BEGIN trace_context := current_setting('hasura.tracecontext'); EXCEPTION WHEN OTHERS THEN trace_context := NULL; END; END IF; payload := json_build_object( 'op', op, 'data', row_data, 'session_variables', session_variables, 'trace_context', trace_context ); INSERT INTO hdb_catalog.event_log (id, schema_name, table_name, trigger_name, payload) VALUES (id, schema_name, table_name, trigger_name, payload); RETURN id; END; $$ LANGUAGE plpgsql; CREATE TABLE hdb_catalog.hdb_query_collection ( collection_name TEXT PRIMARY KEY, collection_defn JSONB NOT NULL, comment TEXT NULL, is_system_defined boolean default false ); CREATE TABLE hdb_catalog.hdb_allowlist ( collection_name TEXT UNIQUE REFERENCES hdb_catalog.hdb_query_collection(collection_name) ); CREATE TABLE hdb_catalog.hdb_computed_field ( table_schema TEXT, table_name TEXT, computed_field_name TEXT, definition JSONB NOT NULL, comment TEXT NULL, PRIMARY KEY (table_schema, table_name, computed_field_name), FOREIGN KEY (table_schema, table_name) REFERENCES hdb_catalog.hdb_table(table_schema, table_name) ON UPDATE CASCADE ); CREATE VIEW hdb_catalog.hdb_computed_field_function AS ( SELECT table_schema, table_name, computed_field_name, CASE WHEN (definition::jsonb -> 'function')::jsonb ->> 'name' IS NULL THEN definition::jsonb ->> 'function' ELSE (definition::jsonb -> 'function')::jsonb ->> 'name' END AS function_name, CASE WHEN (definition::jsonb -> 'function')::jsonb ->> 'schema' IS NULL THEN 'public' ELSE (definition::jsonb -> 'function')::jsonb ->> 'schema' END AS function_schema FROM hdb_catalog.hdb_computed_field ); CREATE OR REPLACE FUNCTION hdb_catalog.check_violation(msg text) RETURNS bool AS $$ BEGIN RAISE check_violation USING message=msg; END; $$ LANGUAGE plpgsql; CREATE TABLE hdb_catalog.hdb_action ( action_name TEXT PRIMARY KEY, action_defn JSONB NOT NULL, comment TEXT NULL, is_system_defined boolean default false ); CREATE TABLE hdb_catalog.hdb_action_permission ( action_name TEXT NOT NULL, role_name TEXT NOT NULL, definition JSONB NOT NULL DEFAULT '{}'::jsonb, comment TEXT NULL, PRIMARY KEY (action_name, role_name), FOREIGN KEY (action_name) REFERENCES hdb_catalog.hdb_action(action_name) ON UPDATE CASCADE ); CREATE TABLE hdb_catalog.hdb_action_log ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), -- we deliberately do not reference the action name -- because sometimes we may want to retain history -- after dropping the action action_name TEXT, input_payload JSONB NOT NULL, request_headers JSONB NOT NULL, session_variables JSONB NOT NULL, response_payload JSONB NULL, errors JSONB NULL, created_at timestamptz NOT NULL default now(), response_received_at timestamptz NULL, status text NOT NULL, CHECK (status IN ('created', 'processing', 'completed', 'error')) ); CREATE TABLE hdb_catalog.hdb_custom_types ( custom_types jsonb NOT NULL ); CREATE VIEW hdb_catalog.hdb_role AS ( SELECT DISTINCT role_name FROM ( SELECT role_name FROM hdb_catalog.hdb_permission UNION ALL SELECT role_name FROM hdb_catalog.hdb_action_permission ) q ); CREATE TABLE hdb_catalog.hdb_cron_triggers ( name TEXT PRIMARY KEY, webhook_conf JSON NOT NULL, cron_schedule TEXT NOT NULL, payload JSON, retry_conf JSON, header_conf JSON, include_in_metadata BOOLEAN NOT NULL DEFAULT FALSE, comment TEXT ); CREATE TABLE hdb_catalog.hdb_cron_events ( id TEXT DEFAULT gen_random_uuid() PRIMARY KEY, trigger_name TEXT NOT NULL, scheduled_time TIMESTAMPTZ NOT NULL, status TEXT NOT NULL DEFAULT 'scheduled', tries INTEGER NOT NULL DEFAULT 0, created_at TIMESTAMP DEFAULT NOW(), next_retry_at TIMESTAMPTZ, FOREIGN KEY (trigger_name) REFERENCES hdb_catalog.hdb_cron_triggers(name) ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT valid_status CHECK (status IN ('scheduled','locked','delivered','error','dead')) ); CREATE INDEX hdb_cron_event_status ON hdb_catalog.hdb_cron_events (status); CREATE TABLE hdb_catalog.hdb_cron_event_invocation_logs ( id TEXT DEFAULT gen_random_uuid() PRIMARY KEY, event_id TEXT, status INTEGER, request JSON, response JSON, created_at TIMESTAMP DEFAULT NOW(), FOREIGN KEY (event_id) REFERENCES hdb_catalog.hdb_cron_events (id) ON UPDATE CASCADE ON DELETE CASCADE ); CREATE VIEW hdb_catalog.hdb_cron_events_stats AS SELECT ct.name, COALESCE(ce.upcoming_events_count,0) as upcoming_events_count, COALESCE(ce.max_scheduled_time, now()) as max_scheduled_time FROM hdb_catalog.hdb_cron_triggers ct LEFT JOIN ( SELECT trigger_name, count(*) as upcoming_events_count, max(scheduled_time) as max_scheduled_time FROM hdb_catalog.hdb_cron_events WHERE tries = 0 and status = 'scheduled' GROUP BY trigger_name ) ce ON ct.name = ce.trigger_name; CREATE TABLE hdb_catalog.hdb_scheduled_events ( id TEXT DEFAULT gen_random_uuid() PRIMARY KEY, webhook_conf JSON NOT NULL, scheduled_time TIMESTAMPTZ NOT NULL, retry_conf JSON, payload JSON, header_conf JSON, status TEXT NOT NULL DEFAULT 'scheduled', tries INTEGER NOT NULL DEFAULT 0, created_at TIMESTAMP DEFAULT NOW(), next_retry_at TIMESTAMPTZ, comment TEXT, CONSTRAINT valid_status CHECK (status IN ('scheduled','locked','delivered','error','dead')) ); CREATE INDEX hdb_scheduled_event_status ON hdb_catalog.hdb_scheduled_events (status); CREATE TABLE hdb_catalog.hdb_scheduled_event_invocation_logs ( id TEXT DEFAULT gen_random_uuid() PRIMARY KEY, event_id TEXT, status INTEGER, request JSON, response JSON, created_at TIMESTAMP DEFAULT NOW(), FOREIGN KEY (event_id) REFERENCES hdb_catalog.hdb_scheduled_events (id) ON DELETE CASCADE ON UPDATE CASCADE );
2020-09-03 14:53:06.722 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 10 SELECT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 1: select json_build_object( 'tables', tables.items :: json, 'relations', relations.items, 'permissions', permissions.items, 'event_triggers', event_triggers.items, 'remote_schemas', remote_schemas.items, 'functions', functions.items, 'allowlist_collections', allowlist.item, 'computed_fields', computed_field.items, 'custom_types', custom_types.item, 'actions', actions.items, 'remote_relationships', remote_relationships.items, 'cron_triggers', cron_triggers.items ) from ( select coalesce(jsonb_agg( jsonb_build_object( 'name', jsonb_build_object( 'name', ht.table_name, 'schema', ht.table_schema ), 'is_enum', ht.is_enum, 'is_system_defined', ht.is_system_defined, 'configuration', ht.configuration, 'info', t.info ) ), '[]') as items from hdb_catalog.hdb_table ht left join hdb_catalog.hdb_table_info_agg t using (table_schema, table_name) ) as tables, ( select coalesce( json_agg( json_build_object( 'table', json_build_object( 'schema', table_schema, 'name', table_name ), 'rel_name', rel_name, 'rel_type', rel_type, 'def', rel_def :: json, 'comment', comment ) ), '[]' ) as items from hdb_catalog.hdb_relationship ) as relations, ( select coalesce( json_agg( json_build_object( 'table', json_build_object( 'schema', table_schema, 'name', table_name ), 'role', role_name, 'perm_type', perm_type, 'def', perm_def :: json, 'comment', comment ) ), '[]' ) as items from hdb_catalog.hdb_permission ) as permissions, ( select coalesce( json_agg( json_build_object( 'table', json_build_object( 'schema', schema_name, 'name', table_name ), 'name', name, 'def', configuration :: json ) ), '[]' ) as items from hdb_catalog.event_triggers ) as event_triggers, ( select coalesce( json_agg( json_build_object( 'name', name, 'definition', definition :: json, 'comment', comment ) ), '[]' ) as items from hdb_catalog.remote_schemas ) as remote_schemas, ( select coalesce(json_agg(q.info), '[]') as items from ( select json_build_object( 'function', json_build_object( 'schema', hf.function_schema, 'name', hf.function_name ), 'configuration', hf.configuration, 'is_system_defined', hf.is_system_defined, 'info', hf_agg.function_info ) as info from hdb_catalog.hdb_function hf left join lateral ( select coalesce(json_agg(function_info), '[]') as function_info from hdb_catalog.hdb_function_info_agg where function_name = hf.function_name and function_schema = hf.function_schema ) hf_agg on 'true' ) as q ) as functions, ( select coalesce(json_agg(hqc.collection_defn), '[]') as item from hdb_catalog.hdb_allowlist ha left outer join hdb_catalog.hdb_query_collection hqc on (hqc.collection_name = ha.collection_name) ) as allowlist, ( select coalesce(json_agg( json_build_object('computed_field', cc.computed_field, 'function_info', fi.function_info ) ), '[]') as items from ( select json_build_object( 'table', jsonb_build_object('name', hcc.table_name,'schema', hcc.table_schema), 'name', hcc.computed_field_name, 'definition', hcc.definition, 'comment', hcc.comment ) as computed_field, hccf.function_name, hccf.function_schema from hdb_catalog.hdb_computed_field hcc left outer join hdb_catalog.hdb_computed_field_function hccf on ( hcc.table_name = hccf.table_name and hcc.table_schema = hccf.table_schema and hcc.computed_field_name = hccf.computed_field_name ) ) cc left join lateral ( select coalesce(json_agg(function_info), '[]') as function_info from hdb_catalog.hdb_function_info_agg where function_name = cc.function_name and function_schema = cc.function_schema ) fi on 'true' ) as computed_field, ( select json_build_object( 'custom_types', coalesce((select custom_types from hdb_catalog.hdb_custom_types), '{}'), 'pg_scalars', -- See Note [Postgres scalars in custom types] coalesce((select json_agg(typname) from pg_catalog.pg_type where typtype = 'b'), '[]') ) as item ) as custom_types, ( select coalesce( json_agg( json_build_object( 'name', ha.action_name, 'definition', ha.action_defn :: json, 'comment', ha.comment, 'permissions', p.items ) ), '[]' ) as items from hdb_catalog.hdb_action ha left join lateral ( select coalesce( json_agg( json_build_object( 'action', hap.action_name, 'role', hap.role_name, 'comment', hap.comment ) ), '[]' ) as items from hdb_catalog.hdb_action_permission hap where hap.action_name = ha.action_name ) p on 'true' ) as actions, ( select coalesce(json_agg( json_build_object( 'name', remote_relationship_name, 'table', json_build_object('schema', table_schema, 'name', table_name), 'hasura_fields', definition -> 'hasura_fields', 'remote_schema', definition -> 'remote_schema', 'remote_field', definition -> 'remote_field' ) ),'[]') as items from hdb_catalog.hdb_remote_relationship ) as remote_relationships, ( select coalesce( json_agg( json_build_object( 'name', name, 'webhook_conf', webhook_conf :: json, 'cron_schedule', cron_schedule, 'payload', payload :: json, 'retry_conf', retry_conf :: json, 'header_conf', header_conf :: json, 'comment', comment ) ), '[]' ) as items from hdb_catalog.hdb_cron_triggers ) as cron_triggers
2020-09-03 14:53:06.726 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 11 idle in transaction 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 statement: DELETE FROM hdb_catalog.hdb_function WHERE is_system_defined = 'true'; DELETE FROM hdb_catalog.hdb_permission WHERE is_system_defined = 'true'; DELETE FROM hdb_catalog.hdb_relationship WHERE is_system_defined = 'true'; DELETE FROM hdb_catalog.hdb_table WHERE is_system_defined = 'true'; DELETE FROM hdb_catalog.hdb_query_collection WHERE is_system_defined = 'true';
2020-09-03 14:53:06.727 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 12 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'information_schema', $2 = 'tables', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.727 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 13 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'information_schema', $2 = 'schemata', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.728 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 14 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'information_schema', $2 = 'views', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.728 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 15 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'information_schema', $2 = 'columns', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.729 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 16 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_table', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.729 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 17 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_table', $3 = 'detail', $4 = 'object', $5 = '{"manual_configuration":{"remote_table":{"schema":"information_schema","name":"tables"},"column_mapping":{"table_schema":"table_schema","table_name":"table_name"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.730 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 18 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_table', $3 = 'primary_key', $4 = 'object', $5 = '{"manual_configuration":{"remote_table":{"schema":"hdb_catalog","name":"hdb_primary_key"},"column_mapping":{"table_schema":"table_schema","table_name":"table_name"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.731 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 19 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_table', $3 = 'columns', $4 = 'array', $5 = '{"manual_configuration":{"remote_table":{"schema":"information_schema","name":"columns"},"column_mapping":{"table_schema":"table_schema","table_name":"table_name"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.731 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 20 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_table', $3 = 'foreign_key_constraints', $4 = 'array', $5 = '{"manual_configuration":{"remote_table":{"schema":"hdb_catalog","name":"hdb_foreign_key_constraint"},"column_mapping":{"table_schema":"table_schema","table_name":"table_name"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.732 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 21 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_table', $3 = 'relationships', $4 = 'array', $5 = '{"manual_configuration":{"remote_table":{"schema":"hdb_catalog","name":"hdb_relationship"},"column_mapping":{"table_schema":"table_schema","table_name":"table_name"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.732 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 22 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_table', $3 = 'permissions', $4 = 'array', $5 = '{"manual_configuration":{"remote_table":{"schema":"hdb_catalog","name":"hdb_permission_agg"},"column_mapping":{"table_schema":"table_schema","table_name":"table_name"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.733 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 23 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_table', $3 = 'computed_fields', $4 = 'array', $5 = '{"manual_configuration":{"remote_table":{"schema":"hdb_catalog","name":"hdb_computed_field"},"column_mapping":{"table_schema":"table_schema","table_name":"table_name"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.733 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 24 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_table', $3 = 'check_constraints', $4 = 'array', $5 = '{"manual_configuration":{"remote_table":{"schema":"hdb_catalog","name":"hdb_check_constraint"},"column_mapping":{"table_schema":"table_schema","table_name":"table_name"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.733 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 25 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_table', $3 = 'unique_constraints', $4 = 'array', $5 = '{"manual_configuration":{"remote_table":{"schema":"hdb_catalog","name":"hdb_unique_constraint"},"column_mapping":{"table_schema":"table_schema","table_name":"table_name"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.734 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 26 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_primary_key', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.734 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 27 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_foreign_key_constraint', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.735 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 28 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_relationship', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.735 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 29 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_permission_agg', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.736 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 30 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_computed_field', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.736 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 31 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_check_constraint', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.737 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 32 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_unique_constraint', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.737 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 33 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_remote_relationship', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.737 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 34 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'event_triggers', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.738 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 35 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'event_triggers', $3 = 'events', $4 = 'array', $5 = '{"manual_configuration":{"remote_table":{"schema":"hdb_catalog","name":"event_log"},"column_mapping":{"name":"trigger_name"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.738 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 36 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'event_log', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.739 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 37 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'event_log', $3 = 'trigger', $4 = 'object', $5 = '{"manual_configuration":{"remote_table":{"schema":"hdb_catalog","name":"event_triggers"},"column_mapping":{"trigger_name":"name"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.739 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 38 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'event_log', $3 = 'logs', $4 = 'array', $5 = '{"foreign_key_constraint_on":{"column":"event_id","table":{"schema":"hdb_catalog","name":"event_invocation_logs"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.739 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 39 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'event_invocation_logs', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.739 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 40 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'event_invocation_logs', $3 = 'event', $4 = 'object', $5 = '{"foreign_key_constraint_on":"event_id"}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.740 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 41 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_function', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.740 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 42 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_function_agg', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.740 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 43 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_function_agg', $3 = 'return_table_info', $4 = 'object', $5 = '{"manual_configuration":{"remote_table":{"schema":"hdb_catalog","name":"hdb_table"},"column_mapping":{"return_type_schema":"table_schema","return_type_name":"table_name"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.741 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 44 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'remote_schemas', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.741 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 45 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_version', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.741 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 46 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_query_collection', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.741 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 47 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_allowlist', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.742 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 48 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_custom_types', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.742 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 49 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_action_permission', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.742 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 50 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_action', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.743 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 51 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_action', $3 = 'permissions', $4 = 'array', $5 = '{"manual_configuration":{"remote_table":{"schema":"hdb_catalog","name":"hdb_action_permission"},"column_mapping":{"action_name":"action_name"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.743 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 52 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_action_log', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.743 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 53 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_role', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.744 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 54 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_role', $3 = 'action_permissions', $4 = 'array', $5 = '{"manual_configuration":{"remote_table":{"schema":"hdb_catalog","name":"hdb_action_permission"},"column_mapping":{"role_name":"role_name"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.744 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 55 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_role', $3 = 'permissions', $4 = 'array', $5 = '{"manual_configuration":{"remote_table":{"schema":"hdb_catalog","name":"hdb_permission_agg"},"column_mapping":{"role_name":"role_name"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.744 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 56 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_cron_triggers', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.744 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 57 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_cron_triggers', $3 = 'cron_events', $4 = 'array', $5 = '{"foreign_key_constraint_on":{"column":"trigger_name","table":{"schema":"hdb_catalog","name":"hdb_cron_events"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.745 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 58 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_cron_events', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.745 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 59 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_cron_events', $3 = 'cron_trigger', $4 = 'object', $5 = '{"foreign_key_constraint_on":"trigger_name"}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.745 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 60 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_cron_events', $3 = 'cron_event_logs', $4 = 'array', $5 = '{"foreign_key_constraint_on":{"column":"event_id","table":{"schema":"hdb_catalog","name":"hdb_cron_event_invocation_logs"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.746 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 61 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_cron_event_invocation_logs', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.746 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 62 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_cron_event_invocation_logs', $3 = 'cron_event', $4 = 'object', $5 = '{"foreign_key_constraint_on":"event_id"}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.746 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 63 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_scheduled_events', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.747 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 64 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_scheduled_events', $3 = 'scheduled_event_logs', $4 = 'array', $5 = '{"foreign_key_constraint_on":{"column":"event_id","table":{"schema":"hdb_catalog","name":"hdb_scheduled_event_invocation_logs"}}}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.747 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 65 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO "hdb_catalog"."hdb_table" (table_schema, table_name, is_system_defined, is_enum, configuration) VALUES ($1, $2, $3, $4, $5) parameters: $1 = 'hdb_catalog', $2 = 'hdb_scheduled_event_invocation_logs', $3 = 't', $4 = 'f', $5 = '{"custom_root_fields":{},"custom_column_names":{}}'
2020-09-03 14:53:06.747 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 66 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 2: INSERT INTO hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) VALUES ($1, $2, $3, $4, $5 :: jsonb, $6, $7) parameters: $1 = 'hdb_catalog', $2 = 'hdb_scheduled_event_invocation_logs', $3 = 'scheduled_event', $4 = 'object', $5 = '{"foreign_key_constraint_on":"event_id"}', $6 = NULL, $7 = 't'
2020-09-03 14:53:06.748 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 67 SELECT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 1: select json_build_object( 'tables', tables.items :: json, 'relations', relations.items, 'permissions', permissions.items, 'event_triggers', event_triggers.items, 'remote_schemas', remote_schemas.items, 'functions', functions.items, 'allowlist_collections', allowlist.item, 'computed_fields', computed_field.items, 'custom_types', custom_types.item, 'actions', actions.items, 'remote_relationships', remote_relationships.items, 'cron_triggers', cron_triggers.items ) from ( select coalesce(jsonb_agg( jsonb_build_object( 'name', jsonb_build_object( 'name', ht.table_name, 'schema', ht.table_schema ), 'is_enum', ht.is_enum, 'is_system_defined', ht.is_system_defined, 'configuration', ht.configuration, 'info', t.info ) ), '[]') as items from hdb_catalog.hdb_table ht left join hdb_catalog.hdb_table_info_agg t using (table_schema, table_name) ) as tables, ( select coalesce( json_agg( json_build_object( 'table', json_build_object( 'schema', table_schema, 'name', table_name ), 'rel_name', rel_name, 'rel_type', rel_type, 'def', rel_def :: json, 'comment', comment ) ), '[]' ) as items from hdb_catalog.hdb_relationship ) as relations, ( select coalesce( json_agg( json_build_object( 'table', json_build_object( 'schema', table_schema, 'name', table_name ), 'role', role_name, 'perm_type', perm_type, 'def', perm_def :: json, 'comment', comment ) ), '[]' ) as items from hdb_catalog.hdb_permission ) as permissions, ( select coalesce( json_agg( json_build_object( 'table', json_build_object( 'schema', schema_name, 'name', table_name ), 'name', name, 'def', configuration :: json ) ), '[]' ) as items from hdb_catalog.event_triggers ) as event_triggers, ( select coalesce( json_agg( json_build_object( 'name', name, 'definition', definition :: json, 'comment', comment ) ), '[]' ) as items from hdb_catalog.remote_schemas ) as remote_schemas, ( select coalesce(json_agg(q.info), '[]') as items from ( select json_build_object( 'function', json_build_object( 'schema', hf.function_schema, 'name', hf.function_name ), 'configuration', hf.configuration, 'is_system_defined', hf.is_system_defined, 'info', hf_agg.function_info ) as info from hdb_catalog.hdb_function hf left join lateral ( select coalesce(json_agg(function_info), '[]') as function_info from hdb_catalog.hdb_function_info_agg where function_name = hf.function_name and function_schema = hf.function_schema ) hf_agg on 'true' ) as q ) as functions, ( select coalesce(json_agg(hqc.collection_defn), '[]') as item from hdb_catalog.hdb_allowlist ha left outer join hdb_catalog.hdb_query_collection hqc on (hqc.collection_name = ha.collection_name) ) as allowlist, ( select coalesce(json_agg( json_build_object('computed_field', cc.computed_field, 'function_info', fi.function_info ) ), '[]') as items from ( select json_build_object( 'table', jsonb_build_object('name', hcc.table_name,'schema', hcc.table_schema), 'name', hcc.computed_field_name, 'definition', hcc.definition, 'comment', hcc.comment ) as computed_field, hccf.function_name, hccf.function_schema from hdb_catalog.hdb_computed_field hcc left outer join hdb_catalog.hdb_computed_field_function hccf on ( hcc.table_name = hccf.table_name and hcc.table_schema = hccf.table_schema and hcc.computed_field_name = hccf.computed_field_name ) ) cc left join lateral ( select coalesce(json_agg(function_info), '[]') as function_info from hdb_catalog.hdb_function_info_agg where function_name = cc.function_name and function_schema = cc.function_schema ) fi on 'true' ) as computed_field, ( select json_build_object( 'custom_types', coalesce((select custom_types from hdb_catalog.hdb_custom_types), '{}'), 'pg_scalars', -- See Note [Postgres scalars in custom types] coalesce((select json_agg(typname) from pg_catalog.pg_type where typtype = 'b'), '[]') ) as item ) as custom_types, ( select coalesce( json_agg( json_build_object( 'name', ha.action_name, 'definition', ha.action_defn :: json, 'comment', ha.comment, 'permissions', p.items ) ), '[]' ) as items from hdb_catalog.hdb_action ha left join lateral ( select coalesce( json_agg( json_build_object( 'action', hap.action_name, 'role', hap.role_name, 'comment', hap.comment ) ), '[]' ) as items from hdb_catalog.hdb_action_permission hap where hap.action_name = ha.action_name ) p on 'true' ) as actions, ( select coalesce(json_agg( json_build_object( 'name', remote_relationship_name, 'table', json_build_object('schema', table_schema, 'name', table_name), 'hasura_fields', definition -> 'hasura_fields', 'remote_schema', definition -> 'remote_schema', 'remote_field', definition -> 'remote_field' ) ),'[]') as items from hdb_catalog.hdb_remote_relationship ) as remote_relationships, ( select coalesce( json_agg( json_build_object( 'name', name, 'webhook_conf', webhook_conf :: json, 'cron_schedule', cron_schedule, 'payload', payload :: json, 'retry_conf', retry_conf :: json, 'header_conf', header_conf :: json, 'comment', comment ) ), '[]' ) as items from hdb_catalog.hdb_cron_triggers ) as cron_triggers
2020-09-03 14:53:06.805 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 68 INSERT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute <unnamed>: INSERT INTO hdb_catalog.hdb_version (version, upgraded_on) VALUES ($1, $2) ON CONFLICT ((version IS NOT NULL)) DO UPDATE SET version = $1, upgraded_on = $2 parameters: $1 = '37', $2 = '2020-09-03 14:53:06.376986-04'
2020-09-03 14:53:06.806 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 69 SELECT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 3: SELECT instance_id::text, occurred_at, invalidations FROM hdb_catalog.hdb_schema_update_event ORDER BY occurred_at DESC LIMIT 1
2020-09-03 14:53:06.807 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 70 COMMIT 2020-09-03 14:53:06 EDT 4/864 2093 LOG 00000 execute 4: COMMIT
2020-09-03 14:53:06.810 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 71 BEGIN 2020-09-03 14:53:06 EDT 4/867 0 LOG 00000 execute 5: BEGIN ISOLATION LEVEL READ COMMITTED
2020-09-03 14:53:06.811 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 72 UPDATE 2020-09-03 14:53:06 EDT 4/867 0 LOG 00000 execute 6: UPDATE hdb_catalog.event_log SET locked = 'f' WHERE locked = 't'
2020-09-03 14:53:06.811 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 73 COMMIT 2020-09-03 14:53:06 EDT 4/867 0 LOG 00000 execute 4: COMMIT
2020-09-03 14:53:06.811 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 74 BEGIN 2020-09-03 14:53:06 EDT 4/868 0 LOG 00000 execute 5: BEGIN ISOLATION LEVEL READ COMMITTED
2020-09-03 14:53:06.812 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 75 UPDATE 2020-09-03 14:53:06 EDT 4/868 0 LOG 00000 execute 7: UPDATE hdb_catalog.hdb_cron_events SET status = 'scheduled' WHERE status = 'locked'
2020-09-03 14:53:06.813 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 76 UPDATE 2020-09-03 14:53:06 EDT 4/868 0 LOG 00000 execute 8: UPDATE hdb_catalog.hdb_scheduled_events SET status = 'scheduled' WHERE status = 'locked'
2020-09-03 14:53:06.814 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 77 COMMIT 2020-09-03 14:53:06 EDT 4/868 0 LOG 00000 execute 4: COMMIT
2020-09-03 14:53:06.814 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 78 BEGIN 2020-09-03 14:53:06 EDT 4/869 0 LOG 00000 execute 5: BEGIN ISOLATION LEVEL READ COMMITTED
2020-09-03 14:53:06.814 EDT jessicalaughlin jessicalaughlin 82260 127.0.0.1:54863 5f513b92.14154 1 idle 2020-09-03 14:53:06 EDT 5/2 0 LOG 00000 statement: SET client_encoding = 'UTF8';SET client_min_messages TO WARNING;
2020-09-03 14:53:06.815 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 79 SELECT 2020-09-03 14:53:06 EDT 4/869 0 LOG 00000 execute <unnamed>: SELECT (hasura_uuid :: text) FROM hdb_catalog.hdb_version
2020-09-03 14:53:06.815 EDT jessicalaughlin jessicalaughlin 82255 127.0.0.1:54861 5f513b92.1414f 80 COMMIT 2020-09-03 14:53:06 EDT 4/869 0 LOG 00000 execute 4: COMMIT
2020-09-03 14:53:06.815 EDT jessicalaughlin jessicalaughlin 82260 127.0.0.1:54863 5f513b92.14154 2 idle 2020-09-03 14:53:06 EDT 5/3 0 LOG 00000 statement: LISTEN hasura_schema_update;
2020-09-03 14:53:06.817 EDT jessicalaughlin jessicalaughlin 82261 127.0.0.1:54864 5f513b92.14155 1 idle 2020-09-03 14:53:06 EDT 6/2 0 LOG 00000 statement: SET client_encoding = 'UTF8';SET client_min_messages TO WARNING;
2020-09-03 14:53:06.818 EDT jessicalaughlin jessicalaughlin 82261 127.0.0.1:54864 5f513b92.14155 2 BEGIN 2020-09-03 14:53:06 EDT 6/4 0 LOG 00000 execute 0: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:06.818 EDT jessicalaughlin jessicalaughlin 82262 127.0.0.1:54865 5f513b92.14156 1 idle 2020-09-03 14:53:06 EDT 7/2 0 LOG 00000 statement: SET client_encoding = 'UTF8';SET client_min_messages TO WARNING;
2020-09-03 14:53:06.819 EDT jessicalaughlin jessicalaughlin 82262 127.0.0.1:54865 5f513b92.14156 2 BEGIN 2020-09-03 14:53:06 EDT 7/4 0 LOG 00000 execute 0: BEGIN ISOLATION LEVEL READ COMMITTED READ ONLY
2020-09-03 14:53:06.820 EDT jessicalaughlin jessicalaughlin 82263 127.0.0.1:54866 5f513b92.14157 1 idle 2020-09-03 14:53:06 EDT 8/2 0 LOG 00000 statement: SET client_encoding = 'UTF8';SET client_min_messages TO WARNING;
2020-09-03 14:53:06.821 EDT jessicalaughlin jessicalaughlin 82261 127.0.0.1:54864 5f513b92.14155 3 UPDATE 2020-09-03 14:53:06 EDT 6/4 0 LOG 00000 execute 1: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:06.821 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 1 idle 2020-09-03 14:53:06 EDT 9/2 0 LOG 00000 statement: SET client_encoding = 'UTF8';SET client_min_messages TO WARNING;
2020-09-03 14:53:06.822 EDT jessicalaughlin jessicalaughlin 82261 127.0.0.1:54864 5f513b92.14155 4 COMMIT 2020-09-03 14:53:06 EDT 6/4 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:06.822 EDT jessicalaughlin jessicalaughlin 82263 127.0.0.1:54866 5f513b92.14157 2 UPDATE 2020-09-03 14:53:06 EDT 8/3 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:06.822 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 2 BEGIN 2020-09-03 14:53:06 EDT 9/4 0 LOG 00000 execute 0: BEGIN ISOLATION LEVEL READ COMMITTED READ WRITE
2020-09-03 14:53:06.822 EDT jessicalaughlin jessicalaughlin 82262 127.0.0.1:54865 5f513b92.14156 3 SELECT 2020-09-03 14:53:06 EDT 7/4 0 LOG 00000 execute 1: SELECT name, upcoming_events_count, max_scheduled_time FROM hdb_catalog.hdb_cron_events_stats WHERE upcoming_events_count < 100
2020-09-03 14:53:06.823 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 1 idle 2020-09-03 14:53:06 EDT 10/2 0 LOG 00000 statement: SET client_encoding = 'UTF8';SET client_min_messages TO WARNING;
2020-09-03 14:53:06.823 EDT jessicalaughlin jessicalaughlin 82262 127.0.0.1:54865 5f513b92.14156 4 COMMIT 2020-09-03 14:53:06 EDT 7/4 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:06.823 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 2 BEGIN 2020-09-03 14:53:06 EDT 10/4 0 LOG 00000 execute 0: BEGIN ISOLATION LEVEL SERIALIZABLE
2020-09-03 14:53:06.823 EDT jessicalaughlin jessicalaughlin 82262 127.0.0.1:54865 5f513b92.14156 5 BEGIN 2020-09-03 14:53:06 EDT 7/6 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL READ COMMITTED READ WRITE
2020-09-03 14:53:06.824 EDT jessicalaughlin jessicalaughlin 82262 127.0.0.1:54865 5f513b92.14156 6 COMMIT 2020-09-03 14:53:06 EDT 7/6 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:06.824 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 3 UPDATE 2020-09-03 14:53:06 EDT 9/4 0 LOG 00000 execute 1: UPDATE hdb_catalog.hdb_cron_events SET status = 'locked' WHERE id IN ( SELECT t.id FROM hdb_catalog.hdb_cron_events t WHERE ( t.status = 'scheduled' and ( (t.next_retry_at is NULL and t.scheduled_time <= now()) or (t.next_retry_at is not NULL and t.next_retry_at <= now()) ) ) FOR UPDATE SKIP LOCKED ) RETURNING id, trigger_name, scheduled_time, tries
2020-09-03 14:53:06.825 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 3 SELECT 2020-09-03 14:53:06 EDT 10/4 0 LOG 00000 execute 1: SELECT instance_id::text, occurred_at, invalidations FROM hdb_catalog.hdb_schema_update_event ORDER BY occurred_at DESC LIMIT 1
2020-09-03 14:53:06.825 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 4 COMMIT 2020-09-03 14:53:06 EDT 9/4 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:06.825 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 5 BEGIN 2020-09-03 14:53:06 EDT 9/5 0 LOG 00000 execute 0: BEGIN ISOLATION LEVEL READ COMMITTED READ WRITE
2020-09-03 14:53:06.825 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 4 COMMIT 2020-09-03 14:53:06 EDT 10/4 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:06.826 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 6 UPDATE 2020-09-03 14:53:06 EDT 9/5 0 LOG 00000 execute <unnamed>: UPDATE hdb_catalog.hdb_scheduled_events SET status = 'locked' WHERE id IN ( SELECT t.id FROM hdb_catalog.hdb_scheduled_events t WHERE ( t.status = 'scheduled' and ( (t.next_retry_at is NULL and t.scheduled_time <= now()) or (t.next_retry_at is not NULL and t.next_retry_at <= now()) ) ) FOR UPDATE SKIP LOCKED ) RETURNING id, webhook_conf, scheduled_time, retry_conf, payload, header_conf, tries, comment
2020-09-03 14:53:06.826 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 7 COMMIT 2020-09-03 14:53:06 EDT 9/5 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:07.825 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 5 BEGIN 2020-09-03 14:53:06 EDT 10/6 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:07.825 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 8 UPDATE 2020-09-03 14:53:06 EDT 9/6 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:07.828 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 6 UPDATE 2020-09-03 14:53:06 EDT 10/6 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:07.829 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 7 COMMIT 2020-09-03 14:53:06 EDT 10/6 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:08.828 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 8 UPDATE 2020-09-03 14:53:06 EDT 10/7 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:08.829 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 9 BEGIN 2020-09-03 14:53:06 EDT 10/8 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:08.830 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 10 UPDATE 2020-09-03 14:53:06 EDT 10/8 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:08.831 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 11 COMMIT 2020-09-03 14:53:06 EDT 10/8 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:09.834 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 12 UPDATE 2020-09-03 14:53:06 EDT 10/9 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:09.835 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 9 BEGIN 2020-09-03 14:53:06 EDT 9/8 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:09.839 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 10 UPDATE 2020-09-03 14:53:06 EDT 9/8 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:09.840 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 11 COMMIT 2020-09-03 14:53:06 EDT 9/8 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:10.838 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 12 UPDATE 2020-09-03 14:53:06 EDT 9/9 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:10.840 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 13 BEGIN 2020-09-03 14:53:06 EDT 9/10 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:10.842 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 14 UPDATE 2020-09-03 14:53:06 EDT 9/10 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:10.842 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 15 COMMIT 2020-09-03 14:53:06 EDT 9/10 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:11.844 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 13 BEGIN 2020-09-03 14:53:06 EDT 10/10 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:11.844 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 16 UPDATE 2020-09-03 14:53:06 EDT 9/11 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:11.844 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 14 UPDATE 2020-09-03 14:53:06 EDT 10/10 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:11.845 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 15 COMMIT 2020-09-03 14:53:06 EDT 10/10 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:12.850 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 16 BEGIN 2020-09-03 14:53:06 EDT 10/11 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:12.851 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 17 UPDATE 2020-09-03 14:53:06 EDT 9/12 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:12.852 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 17 UPDATE 2020-09-03 14:53:06 EDT 10/11 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:12.853 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 18 COMMIT 2020-09-03 14:53:06 EDT 10/11 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:13.853 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 19 UPDATE 2020-09-03 14:53:06 EDT 10/12 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:13.854 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 18 BEGIN 2020-09-03 14:53:06 EDT 9/13 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:13.855 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 19 UPDATE 2020-09-03 14:53:06 EDT 9/13 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:13.855 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 20 COMMIT 2020-09-03 14:53:06 EDT 9/13 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:14.856 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 21 BEGIN 2020-09-03 14:53:06 EDT 9/14 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:14.857 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 20 UPDATE 2020-09-03 14:53:06 EDT 10/13 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:14.857 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 22 UPDATE 2020-09-03 14:53:06 EDT 9/14 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:14.858 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 23 COMMIT 2020-09-03 14:53:06 EDT 9/14 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:15.858 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 21 BEGIN 2020-09-03 14:53:06 EDT 10/14 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:15.859 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 24 UPDATE 2020-09-03 14:53:06 EDT 9/15 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:15.859 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 22 UPDATE 2020-09-03 14:53:06 EDT 10/14 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:15.860 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 23 COMMIT 2020-09-03 14:53:06 EDT 10/14 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:16.860 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 25 BEGIN 2020-09-03 14:53:06 EDT 9/16 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:16.861 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 24 UPDATE 2020-09-03 14:53:06 EDT 10/15 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:16.862 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 26 UPDATE 2020-09-03 14:53:06 EDT 9/16 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:16.863 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 27 COMMIT 2020-09-03 14:53:06 EDT 9/16 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:17.864 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 25 BEGIN 2020-09-03 14:53:06 EDT 10/16 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:17.865 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 28 UPDATE 2020-09-03 14:53:06 EDT 9/17 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:17.866 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 26 UPDATE 2020-09-03 14:53:06 EDT 10/16 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:17.866 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 27 COMMIT 2020-09-03 14:53:06 EDT 10/16 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:18.868 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 29 BEGIN 2020-09-03 14:53:06 EDT 9/18 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:18.868 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 28 UPDATE 2020-09-03 14:53:06 EDT 10/17 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:18.869 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 30 UPDATE 2020-09-03 14:53:06 EDT 9/18 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:18.870 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 31 COMMIT 2020-09-03 14:53:06 EDT 9/18 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:19.870 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 32 UPDATE 2020-09-03 14:53:06 EDT 9/19 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:19.871 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 33 BEGIN 2020-09-03 14:53:06 EDT 9/20 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:19.872 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 34 UPDATE 2020-09-03 14:53:06 EDT 9/20 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:19.873 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 35 COMMIT 2020-09-03 14:53:06 EDT 9/20 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:20.873 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 36 UPDATE 2020-09-03 14:53:06 EDT 9/21 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:20.874 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 29 BEGIN 2020-09-03 14:53:06 EDT 10/18 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:20.875 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 30 UPDATE 2020-09-03 14:53:06 EDT 10/18 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:20.875 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 31 COMMIT 2020-09-03 14:53:06 EDT 10/18 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:21.875 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 32 UPDATE 2020-09-03 14:53:06 EDT 10/19 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:21.876 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 37 BEGIN 2020-09-03 14:53:06 EDT 9/22 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:21.877 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 38 UPDATE 2020-09-03 14:53:06 EDT 9/22 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:21.878 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 39 COMMIT 2020-09-03 14:53:06 EDT 9/22 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:22.877 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 40 UPDATE 2020-09-03 14:53:06 EDT 9/23 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:22.879 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 41 BEGIN 2020-09-03 14:53:06 EDT 9/24 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:22.880 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 42 UPDATE 2020-09-03 14:53:06 EDT 9/24 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:22.881 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 43 COMMIT 2020-09-03 14:53:06 EDT 9/24 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:23.881 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 33 BEGIN 2020-09-03 14:53:06 EDT 10/20 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:23.882 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 44 UPDATE 2020-09-03 14:53:06 EDT 9/25 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:23.882 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 34 UPDATE 2020-09-03 14:53:06 EDT 10/20 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:23.883 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 35 COMMIT 2020-09-03 14:53:06 EDT 10/20 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:24.888 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 36 BEGIN 2020-09-03 14:53:06 EDT 10/21 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:24.888 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 45 UPDATE 2020-09-03 14:53:06 EDT 9/26 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:24.889 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 37 UPDATE 2020-09-03 14:53:06 EDT 10/21 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:24.890 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 38 COMMIT 2020-09-03 14:53:06 EDT 10/21 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:25.896 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 46 BEGIN 2020-09-03 14:53:06 EDT 9/27 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:25.896 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 39 UPDATE 2020-09-03 14:53:06 EDT 10/22 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:25.896 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 47 UPDATE 2020-09-03 14:53:06 EDT 9/27 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:25.897 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 48 COMMIT 2020-09-03 14:53:06 EDT 9/27 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:26.897 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 40 BEGIN 2020-09-03 14:53:06 EDT 10/23 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:26.898 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 49 UPDATE 2020-09-03 14:53:06 EDT 9/28 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:26.898 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 41 UPDATE 2020-09-03 14:53:06 EDT 10/23 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:26.899 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 42 COMMIT 2020-09-03 14:53:06 EDT 10/23 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:27.902 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 50 BEGIN 2020-09-03 14:53:06 EDT 9/29 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:27.902 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 43 UPDATE 2020-09-03 14:53:06 EDT 10/24 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:27.903 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 51 UPDATE 2020-09-03 14:53:06 EDT 9/29 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:27.903 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 52 COMMIT 2020-09-03 14:53:06 EDT 9/29 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:28.905 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 53 BEGIN 2020-09-03 14:53:06 EDT 9/30 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:28.905 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 44 UPDATE 2020-09-03 14:53:06 EDT 10/25 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:28.906 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 54 UPDATE 2020-09-03 14:53:06 EDT 9/30 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:28.907 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 55 COMMIT 2020-09-03 14:53:06 EDT 9/30 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:29.908 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 45 BEGIN 2020-09-03 14:53:06 EDT 10/26 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:29.909 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 56 UPDATE 2020-09-03 14:53:06 EDT 9/31 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:29.909 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 46 UPDATE 2020-09-03 14:53:06 EDT 10/26 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:29.910 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 47 COMMIT 2020-09-03 14:53:06 EDT 10/26 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:30.914 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 57 BEGIN 2020-09-03 14:53:06 EDT 9/32 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:30.914 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 48 UPDATE 2020-09-03 14:53:06 EDT 10/27 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:30.915 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 58 UPDATE 2020-09-03 14:53:06 EDT 9/32 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:30.915 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 59 COMMIT 2020-09-03 14:53:06 EDT 9/32 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:31.919 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 49 BEGIN 2020-09-03 14:53:06 EDT 10/28 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:31.919 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 60 UPDATE 2020-09-03 14:53:06 EDT 9/33 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:31.920 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 50 UPDATE 2020-09-03 14:53:06 EDT 10/28 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:31.921 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 51 COMMIT 2020-09-03 14:53:06 EDT 10/28 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:32.922 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 52 UPDATE 2020-09-03 14:53:06 EDT 10/29 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:32.922 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 53 BEGIN 2020-09-03 14:53:06 EDT 10/30 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:32.923 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 54 UPDATE 2020-09-03 14:53:06 EDT 10/30 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:32.923 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 55 COMMIT 2020-09-03 14:53:06 EDT 10/30 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:33.924 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 61 BEGIN 2020-09-03 14:53:06 EDT 9/34 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:33.924 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 56 UPDATE 2020-09-03 14:53:06 EDT 10/31 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:33.925 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 62 UPDATE 2020-09-03 14:53:06 EDT 9/34 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:33.926 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 63 COMMIT 2020-09-03 14:53:06 EDT 9/34 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:34.928 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 57 BEGIN 2020-09-03 14:53:06 EDT 10/32 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:34.929 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 64 UPDATE 2020-09-03 14:53:06 EDT 9/35 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:34.929 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 58 UPDATE 2020-09-03 14:53:06 EDT 10/32 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:34.930 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 59 COMMIT 2020-09-03 14:53:06 EDT 10/32 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:35.933 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 65 BEGIN 2020-09-03 14:53:06 EDT 9/36 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:35.933 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 60 UPDATE 2020-09-03 14:53:06 EDT 10/33 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:35.934 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 66 UPDATE 2020-09-03 14:53:06 EDT 9/36 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:35.934 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 67 COMMIT 2020-09-03 14:53:06 EDT 9/36 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:36.935 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 61 BEGIN 2020-09-03 14:53:06 EDT 10/34 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:36.936 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 68 UPDATE 2020-09-03 14:53:06 EDT 9/37 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:36.936 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 62 UPDATE 2020-09-03 14:53:06 EDT 10/34 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:36.937 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 63 COMMIT 2020-09-03 14:53:06 EDT 10/34 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:37.938 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 69 BEGIN 2020-09-03 14:53:06 EDT 9/38 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:37.939 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 64 UPDATE 2020-09-03 14:53:06 EDT 10/35 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:37.940 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 70 UPDATE 2020-09-03 14:53:06 EDT 9/38 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:37.941 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 71 COMMIT 2020-09-03 14:53:06 EDT 9/38 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:38.943 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 65 BEGIN 2020-09-03 14:53:06 EDT 10/36 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:38.944 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 72 UPDATE 2020-09-03 14:53:06 EDT 9/39 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:38.945 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 66 UPDATE 2020-09-03 14:53:06 EDT 10/36 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:38.946 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 67 COMMIT 2020-09-03 14:53:06 EDT 10/36 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:39.948 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 73 BEGIN 2020-09-03 14:53:06 EDT 9/40 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:39.948 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 68 UPDATE 2020-09-03 14:53:06 EDT 10/37 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:39.949 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 74 UPDATE 2020-09-03 14:53:06 EDT 9/40 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:39.950 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 75 COMMIT 2020-09-03 14:53:06 EDT 9/40 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:40.953 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 69 BEGIN 2020-09-03 14:53:06 EDT 10/38 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:40.953 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 76 UPDATE 2020-09-03 14:53:06 EDT 9/41 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:40.953 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 70 UPDATE 2020-09-03 14:53:06 EDT 10/38 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:40.953 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 71 COMMIT 2020-09-03 14:53:06 EDT 10/38 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:41.955 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 77 BEGIN 2020-09-03 14:53:06 EDT 9/42 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:41.955 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 72 UPDATE 2020-09-03 14:53:06 EDT 10/39 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:41.955 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 78 UPDATE 2020-09-03 14:53:06 EDT 9/42 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:41.956 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 79 COMMIT 2020-09-03 14:53:06 EDT 9/42 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:42.957 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 73 BEGIN 2020-09-03 14:53:06 EDT 10/40 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:42.957 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 80 UPDATE 2020-09-03 14:53:06 EDT 9/43 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:42.958 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 74 UPDATE 2020-09-03 14:53:06 EDT 10/40 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:42.959 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 75 COMMIT 2020-09-03 14:53:06 EDT 10/40 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:43.960 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 76 UPDATE 2020-09-03 14:53:06 EDT 10/41 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:43.961 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 81 BEGIN 2020-09-03 14:53:06 EDT 9/44 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:43.962 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 82 UPDATE 2020-09-03 14:53:06 EDT 9/44 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:43.963 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 83 COMMIT 2020-09-03 14:53:06 EDT 9/44 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:44.964 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 77 BEGIN 2020-09-03 14:53:06 EDT 10/42 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:44.964 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 84 UPDATE 2020-09-03 14:53:06 EDT 9/45 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:44.965 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 78 UPDATE 2020-09-03 14:53:06 EDT 10/42 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:44.966 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 79 COMMIT 2020-09-03 14:53:06 EDT 10/42 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:45.969 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 80 BEGIN 2020-09-03 14:53:06 EDT 10/43 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:45.969 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 85 UPDATE 2020-09-03 14:53:06 EDT 9/46 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:45.970 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 81 UPDATE 2020-09-03 14:53:06 EDT 10/43 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:45.971 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 82 COMMIT 2020-09-03 14:53:06 EDT 10/43 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:46.972 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 86 BEGIN 2020-09-03 14:53:06 EDT 9/47 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:46.973 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 83 UPDATE 2020-09-03 14:53:06 EDT 10/44 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:46.973 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 87 UPDATE 2020-09-03 14:53:06 EDT 9/47 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:46.974 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 88 COMMIT 2020-09-03 14:53:06 EDT 9/47 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:47.978 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 84 BEGIN 2020-09-03 14:53:06 EDT 10/45 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:47.978 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 89 UPDATE 2020-09-03 14:53:06 EDT 9/48 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:47.979 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 85 UPDATE 2020-09-03 14:53:06 EDT 10/45 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:47.979 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 86 COMMIT 2020-09-03 14:53:06 EDT 10/45 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:48.980 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 90 BEGIN 2020-09-03 14:53:06 EDT 9/49 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:48.980 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 87 UPDATE 2020-09-03 14:53:06 EDT 10/46 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:48.981 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 91 UPDATE 2020-09-03 14:53:06 EDT 9/49 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:48.982 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 92 COMMIT 2020-09-03 14:53:06 EDT 9/49 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:49.984 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 93 UPDATE 2020-09-03 14:53:06 EDT 9/50 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:49.984 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 88 BEGIN 2020-09-03 14:53:06 EDT 10/47 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:49.985 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 89 UPDATE 2020-09-03 14:53:06 EDT 10/47 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:49.985 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 90 COMMIT 2020-09-03 14:53:06 EDT 10/47 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:50.986 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 91 UPDATE 2020-09-03 14:53:06 EDT 10/48 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:50.987 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 92 BEGIN 2020-09-03 14:53:06 EDT 10/49 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:50.988 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 93 UPDATE 2020-09-03 14:53:06 EDT 10/49 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:50.989 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 94 COMMIT 2020-09-03 14:53:06 EDT 10/49 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:51.989 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 95 UPDATE 2020-09-03 14:53:06 EDT 10/50 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:51.991 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 96 BEGIN 2020-09-03 14:53:06 EDT 10/51 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:51.991 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 97 UPDATE 2020-09-03 14:53:06 EDT 10/51 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:51.992 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 98 COMMIT 2020-09-03 14:53:06 EDT 10/51 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:52.991 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 99 UPDATE 2020-09-03 14:53:06 EDT 10/52 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:52.993 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 100 BEGIN 2020-09-03 14:53:06 EDT 10/53 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:52.993 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 101 UPDATE 2020-09-03 14:53:06 EDT 10/53 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:52.994 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 102 COMMIT 2020-09-03 14:53:06 EDT 10/53 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:53.993 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 103 UPDATE 2020-09-03 14:53:06 EDT 10/54 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:53.995 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 104 BEGIN 2020-09-03 14:53:06 EDT 10/55 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:53.996 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 105 UPDATE 2020-09-03 14:53:06 EDT 10/55 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:53.996 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 106 COMMIT 2020-09-03 14:53:06 EDT 10/55 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:54.997 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 107 UPDATE 2020-09-03 14:53:06 EDT 10/56 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:54.997 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 94 BEGIN 2020-09-03 14:53:06 EDT 9/51 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:54.997 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 95 UPDATE 2020-09-03 14:53:06 EDT 9/51 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:54.998 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 96 COMMIT 2020-09-03 14:53:06 EDT 9/51 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:55.998 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 97 UPDATE 2020-09-03 14:53:06 EDT 9/52 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:55.999 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 98 BEGIN 2020-09-03 14:53:06 EDT 9/53 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:56.000 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 99 UPDATE 2020-09-03 14:53:06 EDT 9/53 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:56.000 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 100 COMMIT 2020-09-03 14:53:06 EDT 9/53 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:57.000 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 101 BEGIN 2020-09-03 14:53:06 EDT 9/54 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:57.000 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 108 UPDATE 2020-09-03 14:53:06 EDT 10/57 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:57.001 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 102 UPDATE 2020-09-03 14:53:06 EDT 9/54 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:57.001 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 103 COMMIT 2020-09-03 14:53:06 EDT 9/54 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:58.003 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 104 BEGIN 2020-09-03 14:53:06 EDT 9/55 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:58.003 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 109 UPDATE 2020-09-03 14:53:06 EDT 10/58 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:58.003 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 105 UPDATE 2020-09-03 14:53:06 EDT 9/55 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:58.004 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 106 COMMIT 2020-09-03 14:53:06 EDT 9/55 0 LOG 00000 execute 2: COMMIT
2020-09-03 14:53:59.006 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 107 BEGIN 2020-09-03 14:53:06 EDT 9/56 0 LOG 00000 execute 3: BEGIN ISOLATION LEVEL REPEATABLE READ READ WRITE
2020-09-03 14:53:59.007 EDT jessicalaughlin jessicalaughlin 82265 127.0.0.1:54868 5f513b92.14159 110 UPDATE 2020-09-03 14:53:06 EDT 10/59 0 LOG 00000 execute <unnamed>: update hdb_catalog.hdb_action_log set status = 'processing' where id in ( select id from hdb_catalog.hdb_action_log where status = 'created' for update skip locked limit 10 ) returning id, action_name, request_headers::json, session_variables::json, input_payload::json
2020-09-03 14:53:59.007 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 108 UPDATE 2020-09-03 14:53:06 EDT 9/56 0 LOG 00000 execute 4: UPDATE hdb_catalog.event_log SET locked = 't' WHERE id IN ( SELECT l.id FROM hdb_catalog.event_log l WHERE l.delivered = 'f' and l.error = 'f' and l.locked = 'f' and (l.next_retry_at is NULL or l.next_retry_at <= now()) and l.archived = 'f' ORDER BY created_at LIMIT $1 FOR UPDATE SKIP LOCKED ) RETURNING id, schema_name, table_name, trigger_name, payload::json, tries, created_at parameters: $1 = '100'
2020-09-03 14:53:59.008 EDT jessicalaughlin jessicalaughlin 82264 127.0.0.1:54867 5f513b92.14158 109 COMMIT 2020-09-03 14:53:06 EDT 9/56 0 LOG 00000 execute 2: COMMIT
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment