Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 15:28:50', STRUCTURED-DATA: '[DATABASE]', msg: '[86-1] sql_error_code = 00000 time_ms = "2026-11-11 15:28:50.538 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514528" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3140.911 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[86-1] sql_error_code = 00000 time_ms = "2026-11-11 15:28:50.538 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514528" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3140.911 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T15:28:50+00:00 host app postgres.2399400 - [DATABASE] [86-1] sql_error_code = 00000 time_ms = "2026-11-11 15:28:50.538 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514528" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3140.911 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "aae92bd3-c8ef-44b6-a10d-29b641f2a7f9", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.239.193.159", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "70ce8980-c788-d233-a9fb-433d84a209f6", "x-request-start": "1794410931372" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[86-1] sql_error_code = 00000 time_ms = \"2026-11-11 15:28:50.538 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514528\" tid=\"0\" log_line=\"4\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3140.911 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T15:28:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 15:28:50', STRUCTURED-DATA: '[DATABASE]', msg: '[86-2] sql_error_code = 00000 time_ms = "2026-11-11 15:28:50.538 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514528" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[86-2] sql_error_code = 00000 time_ms = "2026-11-11 15:28:50.538 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514528" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T15:28:50+00:00 host app postgres.2399400 - [DATABASE] [86-2] sql_error_code = 00000 time_ms = "2026-11-11 15:28:50.538 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514528" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "aae92bd3-c8ef-44b6-a10d-29b641f2a7f9", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.239.193.159", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "70ce8980-c788-d233-a9fb-433d84a209f6", "x-request-start": "1794410931372" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[86-2] sql_error_code = 00000 time_ms = \"2026-11-11 15:28:50.538 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514528\" tid=\"0\" log_line=\"5\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T15:28:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 15:28:57', STRUCTURED-DATA: '[DATABASE]', msg: '[87-1] sql_error_code = 00000 time_ms = "2026-11-11 15:28:57.287 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514531" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3077.130 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[87-1] sql_error_code = 00000 time_ms = "2026-11-11 15:28:57.287 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514531" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3077.130 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T15:28:57+00:00 host app postgres.2399400 - [DATABASE] [87-1] sql_error_code = 00000 time_ms = "2026-11-11 15:28:57.287 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514531" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3077.130 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "24170c9e-b4ba-4e59-9010-e95ee7cbcac1", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.72.94.5", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "22c9f9c5-17c4-6c82-0daa-f3072a780cbb", "x-request-start": "1794410938124" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[87-1] sql_error_code = 00000 time_ms = \"2026-11-11 15:28:57.287 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514531\" tid=\"0\" log_line=\"6\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3077.130 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T15:28:57+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 15:28:57', STRUCTURED-DATA: '[DATABASE]', msg: '[87-2] sql_error_code = 00000 time_ms = "2026-11-11 15:28:57.287 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514531" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[87-2] sql_error_code = 00000 time_ms = "2026-11-11 15:28:57.287 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514531" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T15:28:57+00:00 host app postgres.2399400 - [DATABASE] [87-2] sql_error_code = 00000 time_ms = "2026-11-11 15:28:57.287 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514531" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "24170c9e-b4ba-4e59-9010-e95ee7cbcac1", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.72.94.5", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "22c9f9c5-17c4-6c82-0daa-f3072a780cbb", "x-request-start": "1794410938124" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[87-2] sql_error_code = 00000 time_ms = \"2026-11-11 15:28:57.287 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514531\" tid=\"0\" log_line=\"7\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T15:28:57+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 15:30:09', STRUCTURED-DATA: '[DATABASE]', msg: '[88-1] sql_error_code = 00000 time_ms = "2026-11-11 15:30:09.803 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514536" tid="0" log_line="8" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 9715.050 ms execute : select "streams"."id", "streams"."projection_retries", "projections"."updated_at" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "projections"."version" = $1 and "streams"."updated_at" < $2 and "streams"."head_delta_id" != "projections"."delta_id" and "streams"."projection_retries" <= $3 order by "user_updated_at" desc' escaped msg: '[88-1] sql_error_code = 00000 time_ms = "2026-11-11 15:30:09.803 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514536" tid="0" log_line="8" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 9715.050 ms execute : select "streams"."id", "streams"."projection_retries", "projections"."updated_at" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "projections"."version" = $1 and "streams"."updated_at" < $2 and "streams"."head_delta_id" != "projections"."delta_id" and "streams"."projection_retries" <= $3 order by "user_updated_at" desc' inputname: drain rawmsg: '<134>1 2026-11-11T15:30:09+00:00 host app postgres.2399400 - [DATABASE] [88-1] sql_error_code = 00000 time_ms = "2026-11-11 15:30:09.803 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514536" tid="0" log_line="8" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 9715.050 ms execute : select "streams"."id", "streams"."projection_retries", "projections"."updated_at" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "projections"."version" = $1 and "streams"."updated_at" < $2 and "streams"."head_delta_id" != "projections"."delta_id" and "streams"."projection_retries" <= $3 order by "user_updated_at" desc' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1265", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "f651497f-70a8-4a47-ab5d-9168e6527c4a", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.72.94.5", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "e6eb626d-5814-a048-b74f-3c7e66716c5c", "x-request-start": "1794411010631" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[88-1] sql_error_code = 00000 time_ms = \"2026-11-11 15:30:09.803 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514536\" tid=\"0\" log_line=\"8\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 9715.050 ms execute : select \"streams\".\"id\", \"streams\".\"projection_retries\", \"projections\".\"updated_at\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"projections\".\"version\" = $1 and \"streams\".\"updated_at\" < $2 and \"streams\".\"head_delta_id\" != \"projections\".\"delta_id\" and \"streams\".\"projection_retries\" <= $3 order by \"user_updated_at\" desc", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T15:30:09+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 15:30:09', STRUCTURED-DATA: '[DATABASE]', msg: '[88-2] sql_error_code = 00000 time_ms = "2026-11-11 15:30:09.803 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514536" tid="0" log_line="9" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'oafv1', $2 = '2026-11-11 15:25:00.082+00', $3 = '3'' escaped msg: '[88-2] sql_error_code = 00000 time_ms = "2026-11-11 15:30:09.803 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514536" tid="0" log_line="9" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'oafv1', $2 = '2026-11-11 15:25:00.082+00', $3 = '3'' inputname: drain rawmsg: '<134>1 2026-11-11T15:30:09+00:00 host app postgres.2399400 - [DATABASE] [88-2] sql_error_code = 00000 time_ms = "2026-11-11 15:30:09.803 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514536" tid="0" log_line="9" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'oafv1', $2 = '2026-11-11 15:25:00.082+00', $3 = '3'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1265", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "f651497f-70a8-4a47-ab5d-9168e6527c4a", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.72.94.5", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "e6eb626d-5814-a048-b74f-3c7e66716c5c", "x-request-start": "1794411010631" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[88-2] sql_error_code = 00000 time_ms = \"2026-11-11 15:30:09.803 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514536\" tid=\"0\" log_line=\"9\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'oafv1', $2 = '2026-11-11 15:25:00.082+00', $3 = '3'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T15:30:09+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:03:07', STRUCTURED-DATA: '[DATABASE]', msg: '[94-1] sql_error_code = 00000 time_ms = "2026-11-11 16:03:07.706 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514589" tid="0" log_line="20" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3461.775 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[94-1] sql_error_code = 00000 time_ms = "2026-11-11 16:03:07.706 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514589" tid="0" log_line="20" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3461.775 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:03:07+00:00 host app postgres.2399400 - [DATABASE] [94-1] sql_error_code = 00000 time_ms = "2026-11-11 16:03:07.706 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514589" tid="0" log_line="20" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3461.775 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "c7b9a7da-8adf-4cf6-86b2-ab987e61900a", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.232.0.151", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "19612b9f-2b76-ba71-deb5-a277017683f3", "x-request-start": "1794412988641" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[94-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:03:07.706 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514589\" tid=\"0\" log_line=\"20\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3461.775 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:03:07+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:03:07', STRUCTURED-DATA: '[DATABASE]', msg: '[94-2] sql_error_code = 00000 time_ms = "2026-11-11 16:03:07.706 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514589" tid="0" log_line="21" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[94-2] sql_error_code = 00000 time_ms = "2026-11-11 16:03:07.706 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514589" tid="0" log_line="21" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:03:07+00:00 host app postgres.2399400 - [DATABASE] [94-2] sql_error_code = 00000 time_ms = "2026-11-11 16:03:07.706 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514589" tid="0" log_line="21" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "c7b9a7da-8adf-4cf6-86b2-ab987e61900a", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.232.0.151", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "19612b9f-2b76-ba71-deb5-a277017683f3", "x-request-start": "1794412988641" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[94-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:03:07.706 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514589\" tid=\"0\" log_line=\"21\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:03:07+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:04:11', STRUCTURED-DATA: '[DATABASE]', msg: '[95-1] sql_error_code = 00000 time_ms = "2026-11-11 16:04:11.533 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514592" tid="0" log_line="22" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 4003.973 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[95-1] sql_error_code = 00000 time_ms = "2026-11-11 16:04:11.533 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514592" tid="0" log_line="22" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 4003.973 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:04:11+00:00 host app postgres.2399400 - [DATABASE] [95-1] sql_error_code = 00000 time_ms = "2026-11-11 16:04:11.533 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514592" tid="0" log_line="22" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 4003.973 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "aea8d268-2e38-45a1-a60f-32f4073a0a13", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.54.65.165", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "cf55cb5a-7728-bb43-0f76-8695c2dc69c0", "x-request-start": "1794413052392" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[95-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:04:11.533 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514592\" tid=\"0\" log_line=\"22\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 4003.973 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:04:11+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:04:11', STRUCTURED-DATA: '[DATABASE]', msg: '[95-2] sql_error_code = 00000 time_ms = "2026-11-11 16:04:11.533 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514592" tid="0" log_line="23" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[95-2] sql_error_code = 00000 time_ms = "2026-11-11 16:04:11.533 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514592" tid="0" log_line="23" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:04:11+00:00 host app postgres.2399400 - [DATABASE] [95-2] sql_error_code = 00000 time_ms = "2026-11-11 16:04:11.533 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514592" tid="0" log_line="23" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "aea8d268-2e38-45a1-a60f-32f4073a0a13", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.54.65.165", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "cf55cb5a-7728-bb43-0f76-8695c2dc69c0", "x-request-start": "1794413052392" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[95-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:04:11.533 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514592\" tid=\"0\" log_line=\"23\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:04:11+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:04:18', STRUCTURED-DATA: '[DATABASE]', msg: '[96-1] sql_error_code = 00000 time_ms = "2026-11-11 16:04:18.127 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514595" tid="0" log_line="24" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3269.863 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[96-1] sql_error_code = 00000 time_ms = "2026-11-11 16:04:18.127 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514595" tid="0" log_line="24" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3269.863 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:04:18+00:00 host app postgres.2399400 - [DATABASE] [96-1] sql_error_code = 00000 time_ms = "2026-11-11 16:04:18.127 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514595" tid="0" log_line="24" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3269.863 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "3a7b36da-05e7-4048-85a3-cbdb51a73ccf", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.232.0.151", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "b3773c56-c3c0-51d1-de8e-b48c802e9e94", "x-request-start": "1794413058933" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[96-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:04:18.127 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514595\" tid=\"0\" log_line=\"24\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3269.863 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:04:18+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:04:18', STRUCTURED-DATA: '[DATABASE]', msg: '[96-2] sql_error_code = 00000 time_ms = "2026-11-11 16:04:18.127 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514595" tid="0" log_line="25" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[96-2] sql_error_code = 00000 time_ms = "2026-11-11 16:04:18.127 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514595" tid="0" log_line="25" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:04:18+00:00 host app postgres.2399400 - [DATABASE] [96-2] sql_error_code = 00000 time_ms = "2026-11-11 16:04:18.127 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514595" tid="0" log_line="25" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "3a7b36da-05e7-4048-85a3-cbdb51a73ccf", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.232.0.151", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "b3773c56-c3c0-51d1-de8e-b48c802e9e94", "x-request-start": "1794413058933" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[96-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:04:18.127 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514595\" tid=\"0\" log_line=\"25\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:04:18+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:05:47', STRUCTURED-DATA: '[DATABASE]', msg: '[97-1] sql_error_code = 00000 time_ms = "2026-11-11 16:05:47.088 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514598" tid="0" log_line="26" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3273.288 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[97-1] sql_error_code = 00000 time_ms = "2026-11-11 16:05:47.088 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514598" tid="0" log_line="26" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3273.288 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:05:47+00:00 host app postgres.2399400 - [DATABASE] [97-1] sql_error_code = 00000 time_ms = "2026-11-11 16:05:47.088 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514598" tid="0" log_line="26" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3273.288 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "a27945a8-2135-47e9-94f6-de5f23dd9383", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.54.65.165", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "289049e6-9ec3-402c-94fb-46b37c16ba7d", "x-request-start": "1794413147870" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[97-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:05:47.088 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514598\" tid=\"0\" log_line=\"26\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3273.288 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:05:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:05:47', STRUCTURED-DATA: '[DATABASE]', msg: '[97-2] sql_error_code = 00000 time_ms = "2026-11-11 16:05:47.088 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514598" tid="0" log_line="27" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[97-2] sql_error_code = 00000 time_ms = "2026-11-11 16:05:47.088 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514598" tid="0" log_line="27" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:05:47+00:00 host app postgres.2399400 - [DATABASE] [97-2] sql_error_code = 00000 time_ms = "2026-11-11 16:05:47.088 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514598" tid="0" log_line="27" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "a27945a8-2135-47e9-94f6-de5f23dd9383", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.54.65.165", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "289049e6-9ec3-402c-94fb-46b37c16ba7d", "x-request-start": "1794413147870" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[97-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:05:47.088 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514598\" tid=\"0\" log_line=\"27\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:05:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:07:13', STRUCTURED-DATA: '[DATABASE]', msg: '[98-1] sql_error_code = 00000 time_ms = "2026-11-11 16:07:13.634 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514601" tid="0" log_line="28" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3315.336 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[98-1] sql_error_code = 00000 time_ms = "2026-11-11 16:07:13.634 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514601" tid="0" log_line="28" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3315.336 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:07:13+00:00 host app postgres.2399400 - [DATABASE] [98-1] sql_error_code = 00000 time_ms = "2026-11-11 16:07:13.634 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514601" tid="0" log_line="28" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3315.336 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "237f1d11-9099-4f72-af7b-d934bff71cff", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.232.0.151", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "e87d36e1-5eb4-6805-e9a6-9aaf1fa62445", "x-request-start": "1794413234624" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[98-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:07:13.634 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514601\" tid=\"0\" log_line=\"28\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3315.336 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:07:13+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:07:13', STRUCTURED-DATA: '[DATABASE]', msg: '[98-2] sql_error_code = 00000 time_ms = "2026-11-11 16:07:13.634 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514601" tid="0" log_line="29" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[98-2] sql_error_code = 00000 time_ms = "2026-11-11 16:07:13.634 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514601" tid="0" log_line="29" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:07:13+00:00 host app postgres.2399400 - [DATABASE] [98-2] sql_error_code = 00000 time_ms = "2026-11-11 16:07:13.634 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514601" tid="0" log_line="29" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "237f1d11-9099-4f72-af7b-d934bff71cff", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.232.0.151", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "e87d36e1-5eb4-6805-e9a6-9aaf1fa62445", "x-request-start": "1794413234624" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[98-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:07:13.634 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514601\" tid=\"0\" log_line=\"29\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:07:13+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:16:32', STRUCTURED-DATA: '[DATABASE]', msg: '[100-1] sql_error_code = 00000 time_ms = "2026-11-11 16:16:32.969 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514612" tid="0" log_line="32" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3274.550 ms execute : select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4 limit $5 offset $6' escaped msg: '[100-1] sql_error_code = 00000 time_ms = "2026-11-11 16:16:32.969 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514612" tid="0" log_line="32" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3274.550 ms execute : select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4 limit $5 offset $6' inputname: drain rawmsg: '<134>1 2026-11-11T16:16:32+00:00 host app postgres.2399400 - [DATABASE] [100-1] sql_error_code = 00000 time_ms = "2026-11-11 16:16:32.969 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514612" tid="0" log_line="32" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3274.550 ms execute : select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4 limit $5 offset $6' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "7c89569e-d01a-49c6-99f8-2c76612ff4d0", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.229.158.102", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "46c00e89-079a-bc00-fb84-76654764d2fb", "x-request-start": "1794413793757" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[100-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:16:32.969 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514612\" tid=\"0\" log_line=\"32\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3274.550 ms execute : select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4 limit $5 offset $6", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:16:32+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:16:32', STRUCTURED-DATA: '[DATABASE]', msg: '[100-2] sql_error_code = 00000 time_ms = "2026-11-11 16:16:32.969 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514612" tid="0" log_line="33" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00', $5 = '2000', $6 = '36000'' escaped msg: '[100-2] sql_error_code = 00000 time_ms = "2026-11-11 16:16:32.969 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514612" tid="0" log_line="33" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00', $5 = '2000', $6 = '36000'' inputname: drain rawmsg: '<134>1 2026-11-11T16:16:32+00:00 host app postgres.2399400 - [DATABASE] [100-2] sql_error_code = 00000 time_ms = "2026-11-11 16:16:32.969 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514612" tid="0" log_line="33" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00', $5 = '2000', $6 = '36000'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "7c89569e-d01a-49c6-99f8-2c76612ff4d0", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.229.158.102", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "46c00e89-079a-bc00-fb84-76654764d2fb", "x-request-start": "1794413793757" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[100-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:16:32.969 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514612\" tid=\"0\" log_line=\"33\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00', $5 = '2000', $6 = '36000'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:16:32+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:19:14', STRUCTURED-DATA: '[DATABASE]', msg: '[102-1] sql_error_code = 00000 time_ms = "2026-11-11 16:19:14.304 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514617" tid="0" log_line="36" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3507.953 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[102-1] sql_error_code = 00000 time_ms = "2026-11-11 16:19:14.304 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514617" tid="0" log_line="36" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3507.953 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:19:14+00:00 host app postgres.2399400 - [DATABASE] [102-1] sql_error_code = 00000 time_ms = "2026-11-11 16:19:14.304 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514617" tid="0" log_line="36" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3507.953 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "7006e139-bec1-41f2-abf6-59ba1d77e9e8", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.229.158.102", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "ae7a4043-0f01-438b-f42c-ce9224065da8", "x-request-start": "1794413955010" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[102-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:19:14.304 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514617\" tid=\"0\" log_line=\"36\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3507.953 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:19:14+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:19:14', STRUCTURED-DATA: '[DATABASE]', msg: '[102-2] sql_error_code = 00000 time_ms = "2026-11-11 16:19:14.304 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514617" tid="0" log_line="37" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[102-2] sql_error_code = 00000 time_ms = "2026-11-11 16:19:14.304 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514617" tid="0" log_line="37" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:19:14+00:00 host app postgres.2399400 - [DATABASE] [102-2] sql_error_code = 00000 time_ms = "2026-11-11 16:19:14.304 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514617" tid="0" log_line="37" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "7006e139-bec1-41f2-abf6-59ba1d77e9e8", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.229.158.102", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "ae7a4043-0f01-438b-f42c-ce9224065da8", "x-request-start": "1794413955010" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[102-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:19:14.304 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514617\" tid=\"0\" log_line=\"37\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:19:14+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:31:13', STRUCTURED-DATA: '[DATABASE]', msg: '[106-1] sql_error_code = 00000 time_ms = "2026-11-11 16:31:13.109 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514634" tid="0" log_line="44" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3226.653 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[106-1] sql_error_code = 00000 time_ms = "2026-11-11 16:31:13.109 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514634" tid="0" log_line="44" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3226.653 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:31:13+00:00 host app postgres.2399400 - [DATABASE] [106-1] sql_error_code = 00000 time_ms = "2026-11-11 16:31:13.109 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514634" tid="0" log_line="44" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3226.653 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "97fe4ea4-3ba2-4a96-95b9-e6003458eccf", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.232.155.6", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "6a51ff62-f899-eac4-02ce-82a0a4f4baf7", "x-request-start": "1794414673888" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[106-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:31:13.109 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514634\" tid=\"0\" log_line=\"44\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3226.653 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:31:13+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:31:13', STRUCTURED-DATA: '[DATABASE]', msg: '[106-2] sql_error_code = 00000 time_ms = "2026-11-11 16:31:13.109 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514634" tid="0" log_line="45" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[106-2] sql_error_code = 00000 time_ms = "2026-11-11 16:31:13.109 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514634" tid="0" log_line="45" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:31:13+00:00 host app postgres.2399400 - [DATABASE] [106-2] sql_error_code = 00000 time_ms = "2026-11-11 16:31:13.109 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514634" tid="0" log_line="45" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "97fe4ea4-3ba2-4a96-95b9-e6003458eccf", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.232.155.6", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "6a51ff62-f899-eac4-02ce-82a0a4f4baf7", "x-request-start": "1794414673888" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[106-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:31:13.109 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514634\" tid=\"0\" log_line=\"45\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:31:13+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:40:26', STRUCTURED-DATA: '[DATABASE]', msg: '[110-1] sql_error_code = 00000 time_ms = "2026-11-11 16:40:26.226 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514650" tid="0" log_line="52" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3245.917 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[110-1] sql_error_code = 00000 time_ms = "2026-11-11 16:40:26.226 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514650" tid="0" log_line="52" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3245.917 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:40:26+00:00 host app postgres.2399400 - [DATABASE] [110-1] sql_error_code = 00000 time_ms = "2026-11-11 16:40:26.226 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514650" tid="0" log_line="52" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3245.917 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "363aa45a-6af0-4f74-90f0-d8d9fc151274", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "100.24.76.186", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "516c4cca-6565-eff0-4876-bbdf91c938f6", "x-request-start": "1794415227146" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[110-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:40:26.226 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514650\" tid=\"0\" log_line=\"52\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3245.917 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:40:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:40:26', STRUCTURED-DATA: '[DATABASE]', msg: '[110-2] sql_error_code = 00000 time_ms = "2026-11-11 16:40:26.226 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514650" tid="0" log_line="53" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[110-2] sql_error_code = 00000 time_ms = "2026-11-11 16:40:26.226 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514650" tid="0" log_line="53" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:40:26+00:00 host app postgres.2399400 - [DATABASE] [110-2] sql_error_code = 00000 time_ms = "2026-11-11 16:40:26.226 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514650" tid="0" log_line="53" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "363aa45a-6af0-4f74-90f0-d8d9fc151274", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "100.24.76.186", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "516c4cca-6565-eff0-4876-bbdf91c938f6", "x-request-start": "1794415227146" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[110-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:40:26.226 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514650\" tid=\"0\" log_line=\"53\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:40:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:40:34', STRUCTURED-DATA: '[DATABASE]', msg: '[111-1] sql_error_code = 00000 time_ms = "2026-11-11 16:40:34.094 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514653" tid="0" log_line="54" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3308.889 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[111-1] sql_error_code = 00000 time_ms = "2026-11-11 16:40:34.094 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514653" tid="0" log_line="54" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3308.889 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:40:34+00:00 host app postgres.2399400 - [DATABASE] [111-1] sql_error_code = 00000 time_ms = "2026-11-11 16:40:34.094 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514653" tid="0" log_line="54" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3308.889 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "403b24ff-7881-464c-afb6-d85feaf474dc", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.236.222.146", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "2127e168-50fd-2932-2ade-913e0de7d039", "x-request-start": "1794415234871" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[111-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:40:34.094 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514653\" tid=\"0\" log_line=\"54\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3308.889 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:40:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 16:40:34', STRUCTURED-DATA: '[DATABASE]', msg: '[111-2] sql_error_code = 00000 time_ms = "2026-11-11 16:40:34.094 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514653" tid="0" log_line="55" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[111-2] sql_error_code = 00000 time_ms = "2026-11-11 16:40:34.094 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514653" tid="0" log_line="55" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:40:34+00:00 host app postgres.2399400 - [DATABASE] [111-2] sql_error_code = 00000 time_ms = "2026-11-11 16:40:34.094 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514653" tid="0" log_line="55" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "403b24ff-7881-464c-afb6-d85feaf474dc", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.236.222.146", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "2127e168-50fd-2932-2ade-913e0de7d039", "x-request-start": "1794415234871" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[111-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:40:34.094 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514653\" tid=\"0\" log_line=\"55\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:40:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 17:03:23', STRUCTURED-DATA: '[DATABASE]', msg: '[113-1] sql_error_code = 00000 time_ms = "2026-11-11 17:03:23.099 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514695" tid="0" log_line="58" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 6381.859 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[113-1] sql_error_code = 00000 time_ms = "2026-11-11 17:03:23.099 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514695" tid="0" log_line="58" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 6381.859 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T17:03:23+00:00 host app postgres.2399400 - [DATABASE] [113-1] sql_error_code = 00000 time_ms = "2026-11-11 17:03:23.099 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514695" tid="0" log_line="58" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 6381.859 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "2749", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "0073526f-46b6-4801-9a11-1d83547dd8ed", "logplex-msg-count": "4", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.225.253.144", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "6ca29163-a16f-c69f-a3b5-040d0fc2fa45", "x-request-start": "1794416603894" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[113-1] sql_error_code = 00000 time_ms = \"2026-11-11 17:03:23.099 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514695\" tid=\"0\" log_line=\"58\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 6381.859 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:03:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 17:03:23', STRUCTURED-DATA: '[DATABASE]', msg: '[113-2] sql_error_code = 00000 time_ms = "2026-11-11 17:03:23.099 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514695" tid="0" log_line="59" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '1999-01-01 01:00:01+00'' escaped msg: '[113-2] sql_error_code = 00000 time_ms = "2026-11-11 17:03:23.099 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514695" tid="0" log_line="59" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '1999-01-01 01:00:01+00'' inputname: drain rawmsg: '<134>1 2026-11-11T17:03:23+00:00 host app postgres.2399400 - [DATABASE] [113-2] sql_error_code = 00000 time_ms = "2026-11-11 17:03:23.099 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514695" tid="0" log_line="59" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '1999-01-01 01:00:01+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "2749", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "0073526f-46b6-4801-9a11-1d83547dd8ed", "logplex-msg-count": "4", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.225.253.144", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "6ca29163-a16f-c69f-a3b5-040d0fc2fa45", "x-request-start": "1794416603894" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[113-2] sql_error_code = 00000 time_ms = \"2026-11-11 17:03:23.099 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514695\" tid=\"0\" log_line=\"59\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '1999-01-01 01:00:01+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:03:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 17:03:30', STRUCTURED-DATA: '[DATABASE]', msg: '[114-1] sql_error_code = 00000 time_ms = "2026-11-11 17:03:30.587 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514700" tid="0" log_line="60" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3492.902 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[114-1] sql_error_code = 00000 time_ms = "2026-11-11 17:03:30.587 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514700" tid="0" log_line="60" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3492.902 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T17:03:30+00:00 host app postgres.2399400 - [DATABASE] [114-1] sql_error_code = 00000 time_ms = "2026-11-11 17:03:30.587 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514700" tid="0" log_line="60" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3492.902 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "b6bd94ce-1d11-4062-94a1-8dba70602b79", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "35.173.110.193", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "09abbb72-55e3-628f-a586-a89004773f8b", "x-request-start": "1794416611393" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[114-1] sql_error_code = 00000 time_ms = \"2026-11-11 17:03:30.587 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514700\" tid=\"0\" log_line=\"60\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3492.902 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:03:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 17:03:30', STRUCTURED-DATA: '[DATABASE]', msg: '[114-2] sql_error_code = 00000 time_ms = "2026-11-11 17:03:30.587 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514700" tid="0" log_line="61" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[114-2] sql_error_code = 00000 time_ms = "2026-11-11 17:03:30.587 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514700" tid="0" log_line="61" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T17:03:30+00:00 host app postgres.2399400 - [DATABASE] [114-2] sql_error_code = 00000 time_ms = "2026-11-11 17:03:30.587 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514700" tid="0" log_line="61" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "b6bd94ce-1d11-4062-94a1-8dba70602b79", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "35.173.110.193", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "09abbb72-55e3-628f-a586-a89004773f8b", "x-request-start": "1794416611393" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[114-2] sql_error_code = 00000 time_ms = \"2026-11-11 17:03:30.587 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514700\" tid=\"0\" log_line=\"61\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:03:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 17:03:38', STRUCTURED-DATA: '[DATABASE]', msg: '[115-1] sql_error_code = 00000 time_ms = "2026-11-11 17:03:38.013 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514710" tid="0" log_line="62" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3475.696 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[115-1] sql_error_code = 00000 time_ms = "2026-11-11 17:03:38.013 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514710" tid="0" log_line="62" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3475.696 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T17:03:38+00:00 host app postgres.2399400 - [DATABASE] [115-1] sql_error_code = 00000 time_ms = "2026-11-11 17:03:38.013 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514710" tid="0" log_line="62" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3475.696 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "8fd607fc-ba38-4b03-a6f2-69f9aabc35ad", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.162.104.167", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "a9f37e0f-8eb4-6608-4b5f-e5842cdf898a", "x-request-start": "1794416618894" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[115-1] sql_error_code = 00000 time_ms = \"2026-11-11 17:03:38.013 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514710\" tid=\"0\" log_line=\"62\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3475.696 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:03:38+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 17:03:38', STRUCTURED-DATA: '[DATABASE]', msg: '[115-2] sql_error_code = 00000 time_ms = "2026-11-11 17:03:38.013 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514710" tid="0" log_line="63" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[115-2] sql_error_code = 00000 time_ms = "2026-11-11 17:03:38.013 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514710" tid="0" log_line="63" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T17:03:38+00:00 host app postgres.2399400 - [DATABASE] [115-2] sql_error_code = 00000 time_ms = "2026-11-11 17:03:38.013 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514710" tid="0" log_line="63" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "8fd607fc-ba38-4b03-a6f2-69f9aabc35ad", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.162.104.167", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "a9f37e0f-8eb4-6608-4b5f-e5842cdf898a", "x-request-start": "1794416618894" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[115-2] sql_error_code = 00000 time_ms = \"2026-11-11 17:03:38.013 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514710\" tid=\"0\" log_line=\"63\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:03:38+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 17:15:52', STRUCTURED-DATA: '[DATABASE]', msg: '[117-1] sql_error_code = 00000 time_ms = "2026-11-11 17:15:52.937 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514763" tid="0" log_line="66" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2494.433 ms execute : select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4 limit $5 offset $6' escaped msg: '[117-1] sql_error_code = 00000 time_ms = "2026-11-11 17:15:52.937 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514763" tid="0" log_line="66" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2494.433 ms execute : select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4 limit $5 offset $6' inputname: drain rawmsg: '<134>1 2026-11-11T17:15:52+00:00 host app postgres.2399400 - [DATABASE] [117-1] sql_error_code = 00000 time_ms = "2026-11-11 17:15:52.937 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514763" tid="0" log_line="66" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2494.433 ms execute : select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4 limit $5 offset $6' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "589f0fc1-be9f-4494-aa8e-1bc3a6caaf03", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.227.75.243", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "9d9c2683-bb98-b868-c84f-62b02bfeff53", "x-request-start": "1794417353871" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[117-1] sql_error_code = 00000 time_ms = \"2026-11-11 17:15:52.937 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514763\" tid=\"0\" log_line=\"66\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 2494.433 ms execute : select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4 limit $5 offset $6", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:15:52+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 17:15:52', STRUCTURED-DATA: '[DATABASE]', msg: '[117-2] sql_error_code = 00000 time_ms = "2026-11-11 17:15:52.937 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514763" tid="0" log_line="67" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00', $5 = '2000', $6 = '24000'' escaped msg: '[117-2] sql_error_code = 00000 time_ms = "2026-11-11 17:15:52.937 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514763" tid="0" log_line="67" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00', $5 = '2000', $6 = '24000'' inputname: drain rawmsg: '<134>1 2026-11-11T17:15:52+00:00 host app postgres.2399400 - [DATABASE] [117-2] sql_error_code = 00000 time_ms = "2026-11-11 17:15:52.937 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514763" tid="0" log_line="67" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00', $5 = '2000', $6 = '24000'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "589f0fc1-be9f-4494-aa8e-1bc3a6caaf03", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.227.75.243", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "9d9c2683-bb98-b868-c84f-62b02bfeff53", "x-request-start": "1794417353871" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[117-2] sql_error_code = 00000 time_ms = \"2026-11-11 17:15:52.937 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514763\" tid=\"0\" log_line=\"67\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00', $5 = '2000', $6 = '24000'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:15:52+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 17:16:17', STRUCTURED-DATA: '[DATABASE]', msg: '[119-1] sql_error_code = 00000 time_ms = "2026-11-11 17:16:17.389 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514769" tid="0" log_line="70" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3036.993 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[119-1] sql_error_code = 00000 time_ms = "2026-11-11 17:16:17.389 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514769" tid="0" log_line="70" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3036.993 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T17:16:17+00:00 host app postgres.2399400 - [DATABASE] [119-1] sql_error_code = 00000 time_ms = "2026-11-11 17:16:17.389 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514769" tid="0" log_line="70" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3036.993 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "f2a61e09-3e24-450a-8cc7-4e9aea876984", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.227.75.243", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "dbe60296-cb7f-ed77-6172-b53ac2503d41", "x-request-start": "1794417378123" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[119-1] sql_error_code = 00000 time_ms = \"2026-11-11 17:16:17.389 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514769\" tid=\"0\" log_line=\"70\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3036.993 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:16:17+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 17:16:17', STRUCTURED-DATA: '[DATABASE]', msg: '[119-2] sql_error_code = 00000 time_ms = "2026-11-11 17:16:17.389 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514769" tid="0" log_line="71" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[119-2] sql_error_code = 00000 time_ms = "2026-11-11 17:16:17.389 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514769" tid="0" log_line="71" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T17:16:17+00:00 host app postgres.2399400 - [DATABASE] [119-2] sql_error_code = 00000 time_ms = "2026-11-11 17:16:17.389 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514769" tid="0" log_line="71" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "f2a61e09-3e24-450a-8cc7-4e9aea876984", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.227.75.243", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "dbe60296-cb7f-ed77-6172-b53ac2503d41", "x-request-start": "1794417378123" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[119-2] sql_error_code = 00000 time_ms = \"2026-11-11 17:16:17.389 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514769\" tid=\"0\" log_line=\"71\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:16:17+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 17:16:44', STRUCTURED-DATA: '[DATABASE]', msg: '[121-1] sql_error_code = 00000 time_ms = "2026-11-11 17:16:44.706 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514787" tid="0" log_line="74" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3043.133 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[121-1] sql_error_code = 00000 time_ms = "2026-11-11 17:16:44.706 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514787" tid="0" log_line="74" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3043.133 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T17:16:44+00:00 host app postgres.2399400 - [DATABASE] [121-1] sql_error_code = 00000 time_ms = "2026-11-11 17:16:44.706 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514787" tid="0" log_line="74" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3043.133 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "40315d7c-1eca-42a2-9db5-fd3e4de2d51c", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.227.75.243", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "05a0c42f-7a24-0f22-24d3-c69f776fe2be", "x-request-start": "1794417405641" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[121-1] sql_error_code = 00000 time_ms = \"2026-11-11 17:16:44.706 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514787\" tid=\"0\" log_line=\"74\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3043.133 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:16:44+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 17:16:44', STRUCTURED-DATA: '[DATABASE]', msg: '[121-2] sql_error_code = 00000 time_ms = "2026-11-11 17:16:44.706 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514787" tid="0" log_line="75" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[121-2] sql_error_code = 00000 time_ms = "2026-11-11 17:16:44.706 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514787" tid="0" log_line="75" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T17:16:44+00:00 host app postgres.2399400 - [DATABASE] [121-2] sql_error_code = 00000 time_ms = "2026-11-11 17:16:44.706 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514787" tid="0" log_line="75" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "40315d7c-1eca-42a2-9db5-fd3e4de2d51c", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.227.75.243", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "05a0c42f-7a24-0f22-24d3-c69f776fe2be", "x-request-start": "1794417405641" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[121-2] sql_error_code = 00000 time_ms = \"2026-11-11 17:16:44.706 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514787\" tid=\"0\" log_line=\"75\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:16:44+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 17:38:25', STRUCTURED-DATA: '[DATABASE]', msg: '[128-1] sql_error_code = 00000 time_ms = "2026-11-11 17:38:25.146 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514819" tid="0" log_line="88" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3111.959 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[128-1] sql_error_code = 00000 time_ms = "2026-11-11 17:38:25.146 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514819" tid="0" log_line="88" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3111.959 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T17:38:25+00:00 host app postgres.2399400 - [DATABASE] [128-1] sql_error_code = 00000 time_ms = "2026-11-11 17:38:25.146 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514819" tid="0" log_line="88" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3111.959 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "fa2e6065-bf1d-420e-9280-b4f09618b36b", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.202.127.167", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "4841a302-6487-de81-072f-29a15e61586e", "x-request-start": "1794418706154" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[128-1] sql_error_code = 00000 time_ms = \"2026-11-11 17:38:25.146 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514819\" tid=\"0\" log_line=\"88\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3111.959 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:38:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 17:38:25', STRUCTURED-DATA: '[DATABASE]', msg: '[128-2] sql_error_code = 00000 time_ms = "2026-11-11 17:38:25.146 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514819" tid="0" log_line="89" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[128-2] sql_error_code = 00000 time_ms = "2026-11-11 17:38:25.146 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514819" tid="0" log_line="89" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T17:38:25+00:00 host app postgres.2399400 - [DATABASE] [128-2] sql_error_code = 00000 time_ms = "2026-11-11 17:38:25.146 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514819" tid="0" log_line="89" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1376", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "fa2e6065-bf1d-420e-9280-b4f09618b36b", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.202.127.167", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "4841a302-6487-de81-072f-29a15e61586e", "x-request-start": "1794418706154" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[128-2] sql_error_code = 00000 time_ms = \"2026-11-11 17:38:25.146 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514819\" tid=\"0\" log_line=\"89\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:38:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 18:00:04', STRUCTURED-DATA: '[DATABASE]', msg: '[133-1] sql_error_code = 00000 time_ms = "2026-11-11 18:00:04.381 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514840" tid="0" log_line="98" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 4275.977 ms execute : select "streams"."id", "streams"."external_id", "streams"."owner_id", "streams"."head_delta_id", "projections"."stream_id", "permGroups"."id" as "permGroupId" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" left join "permission_groups" as "permGroups" on "permGroups"."org62_account_id" = "projections".projection->>'org62AccountId' where "projections"."version" = $1 and CAST("projections"."type" AS text) in ($2, $3, $4, $5, $6, $7, $8) and "projections".projection->>'org62AccountId' in (Select' escaped msg: '[133-1] sql_error_code = 00000 time_ms = "2026-11-11 18:00:04.381 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514840" tid="0" log_line="98" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 4275.977 ms execute : select "streams"."id", "streams"."external_id", "streams"."owner_id", "streams"."head_delta_id", "projections"."stream_id", "permGroups"."id" as "permGroupId" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" left join "permission_groups" as "permGroups" on "permGroups"."org62_account_id" = "projections".projection->>'org62AccountId' where "projections"."version" = $1 and CAST("projections"."type" AS text) in ($2, $3, $4, $5, $6, $7, $8) and "projections".projection->>'org62AccountId' in (Select' inputname: drain rawmsg: '<134>1 2026-11-11T18:00:04+00:00 host app postgres.2399400 - [DATABASE] [133-1] sql_error_code = 00000 time_ms = "2026-11-11 18:00:04.381 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514840" tid="0" log_line="98" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 4275.977 ms execute : select "streams"."id", "streams"."external_id", "streams"."owner_id", "streams"."head_delta_id", "projections"."stream_id", "permGroups"."id" as "permGroupId" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" left join "permission_groups" as "permGroups" on "permGroups"."org62_account_id" = "projections".projection->>'org62AccountId' where "projections"."version" = $1 and CAST("projections"."type" AS text) in ($2, $3, $4, $5, $6, $7, $8) and "projections".projection->>'org62AccountId' in (Select' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1757", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "6a2fd006-45a3-4ebd-97fe-1f38f14731dc", "logplex-msg-count": "3", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "98.86.139.129", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "237fa4ce-512a-f9c5-aec4-5a57e4b20a1c", "x-request-start": "1794420006213" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[133-1] sql_error_code = 00000 time_ms = \"2026-11-11 18:00:04.381 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514840\" tid=\"0\" log_line=\"98\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 4275.977 ms execute : select \"streams\".\"id\", \"streams\".\"external_id\", \"streams\".\"owner_id\", \"streams\".\"head_delta_id\", \"projections\".\"stream_id\", \"permGroups\".\"id\" as \"permGroupId\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" left join \"permission_groups\" as \"permGroups\" on \"permGroups\".\"org62_account_id\" = \"projections\".projection->>'org62AccountId' where \"projections\".\"version\" = $1 and CAST(\"projections\".\"type\" AS text) in ($2, $3, $4, $5, $6, $7, $8) and \"projections\".projection->>'org62AccountId' in (Select", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T18:00:04+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 18:00:04', STRUCTURED-DATA: '[DATABASE]', msg: '[133-2] org62_account_id from permission_groups) and "projections".stream_id not in (select stream_id from permission_group_streams)' escaped msg: '[133-2] org62_account_id from permission_groups) and "projections".stream_id not in (select stream_id from permission_group_streams)' inputname: drain rawmsg: '<134>1 2026-11-11T18:00:04+00:00 host app postgres.2399400 - [DATABASE] [133-2] org62_account_id from permission_groups) and "projections".stream_id not in (select stream_id from permission_group_streams)' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1757", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "6a2fd006-45a3-4ebd-97fe-1f38f14731dc", "logplex-msg-count": "3", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "98.86.139.129", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "237fa4ce-512a-f9c5-aec4-5a57e4b20a1c", "x-request-start": "1794420006213" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[133-2] org62_account_id from permission_groups) and \"projections\".stream_id not in (select stream_id from permission_group_streams)", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T18:00:04+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2399400]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2399400', MSGID: '-', TIMESTAMP: 'Nov 11 18:00:04', STRUCTURED-DATA: '[DATABASE]', msg: '[133-3] sql_error_code = 00000 time_ms = "2026-11-11 18:00:04.381 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514840" tid="0" log_line="99" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'oafv1', $2 = 'listing', $3 = 'publisher', $4 = 'solution', $5 = 'publisher_force', $6 = 'pricing_plan', $7 = 'security_review', $8 = 'security_review_payment'' escaped msg: '[133-3] sql_error_code = 00000 time_ms = "2026-11-11 18:00:04.381 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514840" tid="0" log_line="99" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'oafv1', $2 = 'listing', $3 = 'publisher', $4 = 'solution', $5 = 'publisher_force', $6 = 'pricing_plan', $7 = 'security_review', $8 = 'security_review_payment'' inputname: drain rawmsg: '<134>1 2026-11-11T18:00:04+00:00 host app postgres.2399400 - [DATABASE] [133-3] sql_error_code = 00000 time_ms = "2026-11-11 18:00:04.381 UTC" pid="1113283" proc_start_time="2026-11-11 15:27:11 UTC" session_id="6af4894f.10fcc3" vtid="14/514840" tid="0" log_line="99" database="ddvvgu681gm35p" connection_source="10.0.172.89(42202)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'oafv1', $2 = 'listing', $3 = 'publisher', $4 = 'solution', $5 = 'publisher_force', $6 = 'pricing_plan', $7 = 'security_review', $8 = 'security_review_payment'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1757", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "6a2fd006-45a3-4ebd-97fe-1f38f14731dc", "logplex-msg-count": "3", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "98.86.139.129", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "237fa4ce-512a-f9c5-aec4-5a57e4b20a1c", "x-request-start": "1794420006213" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[133-3] sql_error_code = 00000 time_ms = \"2026-11-11 18:00:04.381 UTC\" pid=\"1113283\" proc_start_time=\"2026-11-11 15:27:11 UTC\" session_id=\"6af4894f.10fcc3\" vtid=\"14\/514840\" tid=\"0\" log_line=\"99\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(42202)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'oafv1', $2 = 'listing', $3 = 'publisher', $4 = 'solution', $5 = 'publisher_force', $6 = 'pricing_plan', $7 = 'security_review', $8 = 'security_review_payment'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T18:00:04+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "d.2257363d-e289-4fca-980f-d26509782992", "source": "app", "dyno": "postgres.2399400", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dynadir": "debug" } $/: