Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:03:55', STRUCTURED-DATA: '[DATABASE]', msg: '[96-1] sql_error_code = 00000 time_ms = "2026-11-11 23:03:55.879 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498381" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3084.933 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 23:03:55.879 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498381" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3084.933 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-11T23:03:55+00:00 host app postgres.2485172 - [DATABASE] [96-1] sql_error_code = 00000 time_ms = "2026-11-11 23:03:55.879 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498381" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3084.933 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": "13e0c837-63cc-4449-93dc-3b62b91835d0", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.230.29.170", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "a481cb2c-dcab-7ff3-c7f5-8edb177bb857", "x-request-start": "1794438236763" }, "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 23:03:55.879 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498381\" tid=\"0\" log_line=\"4\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3084.933 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-11T23:03:55+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:03:55', STRUCTURED-DATA: '[DATABASE]', msg: '[96-2] sql_error_code = 00000 time_ms = "2026-11-11 23:03:55.879 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498381" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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 23:03:55.879 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498381" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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-11T23:03:55+00:00 host app postgres.2485172 - [DATABASE] [96-2] sql_error_code = 00000 time_ms = "2026-11-11 23:03:55.879 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498381" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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": "13e0c837-63cc-4449-93dc-3b62b91835d0", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.230.29.170", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "a481cb2c-dcab-7ff3-c7f5-8edb177bb857", "x-request-start": "1794438236763" }, "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 23:03:55.879 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498381\" tid=\"0\" log_line=\"5\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" 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-11T23:03:55+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:04:00', STRUCTURED-DATA: '[DATABASE]', msg: '[97-1] sql_error_code = 00000 time_ms = "2026-11-11 23:04:00.077 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498384" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2980.451 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 23:04:00.077 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498384" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2980.451 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-11T23:04:00+00:00 host app postgres.2485172 - [DATABASE] [97-1] sql_error_code = 00000 time_ms = "2026-11-11 23:04:00.077 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498384" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2980.451 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": "244dbfcc-33b8-4b1b-ae8e-568978aa3669", "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": "bed79e2a-b581-dd39-2d78-778bd2ad08af", "x-request-start": "1794438240887" }, "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 23:04:00.077 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498384\" tid=\"0\" log_line=\"6\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 2980.451 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-11T23:04:00+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:04:00', STRUCTURED-DATA: '[DATABASE]', msg: '[97-2] sql_error_code = 00000 time_ms = "2026-11-11 23:04:00.077 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498384" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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 23:04:00.077 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498384" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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-11T23:04:00+00:00 host app postgres.2485172 - [DATABASE] [97-2] sql_error_code = 00000 time_ms = "2026-11-11 23:04:00.077 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498384" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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": "244dbfcc-33b8-4b1b-ae8e-568978aa3669", "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": "bed79e2a-b581-dd39-2d78-778bd2ad08af", "x-request-start": "1794438240887" }, "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 23:04:00.077 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498384\" tid=\"0\" log_line=\"7\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" 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-11T23:04:00+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:04:09', STRUCTURED-DATA: '[DATABASE]', msg: '[99-1] sql_error_code = 00000 time_ms = "2026-11-11 23:04:09.275 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498390" tid="0" log_line="10" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2986.576 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: '[99-1] sql_error_code = 00000 time_ms = "2026-11-11 23:04:09.275 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498390" tid="0" log_line="10" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2986.576 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-11T23:04:09+00:00 host app postgres.2485172 - [DATABASE] [99-1] sql_error_code = 00000 time_ms = "2026-11-11 23:04:09.275 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498390" tid="0" log_line="10" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2986.576 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": "8646eb24-c6e8-4297-998a-ed425e38a708", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.215.101.13", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "b789d10f-a536-46b2-bc86-9f1d1654cf7e", "x-request-start": "1794438250135" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[99-1] sql_error_code = 00000 time_ms = \"2026-11-11 23:04:09.275 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498390\" tid=\"0\" log_line=\"10\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 2986.576 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-11T23:04:09+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:04:09', STRUCTURED-DATA: '[DATABASE]', msg: '[99-2] sql_error_code = 00000 time_ms = "2026-11-11 23:04:09.275 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498390" tid="0" log_line="11" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[99-2] sql_error_code = 00000 time_ms = "2026-11-11 23:04:09.275 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498390" tid="0" log_line="11" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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-11T23:04:09+00:00 host app postgres.2485172 - [DATABASE] [99-2] sql_error_code = 00000 time_ms = "2026-11-11 23:04:09.275 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498390" tid="0" log_line="11" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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": "8646eb24-c6e8-4297-998a-ed425e38a708", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.215.101.13", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "b789d10f-a536-46b2-bc86-9f1d1654cf7e", "x-request-start": "1794438250135" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[99-2] sql_error_code = 00000 time_ms = \"2026-11-11 23:04:09.275 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498390\" tid=\"0\" log_line=\"11\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" 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-11T23:04:09+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:06:34', STRUCTURED-DATA: '[DATABASE]', msg: '[100-1] sql_error_code = 00000 time_ms = "2026-11-11 23:06:34.425 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498393" tid="0" log_line="12" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3077.322 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: '[100-1] sql_error_code = 00000 time_ms = "2026-11-11 23:06:34.425 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498393" tid="0" log_line="12" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3077.322 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-11T23:06:34+00:00 host app postgres.2485172 - [DATABASE] [100-1] sql_error_code = 00000 time_ms = "2026-11-11 23:06:34.425 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498393" tid="0" log_line="12" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3077.322 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": "792344e7-d587-4bff-9e14-ef5e6c806cd3", "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": "2a4b23ce-025d-c74a-5a57-eb762ba53224", "x-request-start": "1794438395121" }, "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 23:06:34.425 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498393\" tid=\"0\" log_line=\"12\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3077.322 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-11T23:06:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:06:34', STRUCTURED-DATA: '[DATABASE]', msg: '[100-2] sql_error_code = 00000 time_ms = "2026-11-11 23:06:34.425 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498393" tid="0" log_line="13" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[100-2] sql_error_code = 00000 time_ms = "2026-11-11 23:06:34.425 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498393" tid="0" log_line="13" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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-11T23:06:34+00:00 host app postgres.2485172 - [DATABASE] [100-2] sql_error_code = 00000 time_ms = "2026-11-11 23:06:34.425 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498393" tid="0" log_line="13" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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": "792344e7-d587-4bff-9e14-ef5e6c806cd3", "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": "2a4b23ce-025d-c74a-5a57-eb762ba53224", "x-request-start": "1794438395121" }, "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 23:06:34.425 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498393\" tid=\"0\" log_line=\"13\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" 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-11T23:06:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:06:43', STRUCTURED-DATA: '[DATABASE]', msg: '[101-1] sql_error_code = 00000 time_ms = "2026-11-11 23:06:43.520 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498396" tid="0" log_line="14" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3611.880 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: '[101-1] sql_error_code = 00000 time_ms = "2026-11-11 23:06:43.520 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498396" tid="0" log_line="14" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3611.880 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-11T23:06:43+00:00 host app postgres.2485172 - [DATABASE] [101-1] sql_error_code = 00000 time_ms = "2026-11-11 23:06:43.520 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498396" tid="0" log_line="14" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3611.880 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": "8a874157-813a-4fa6-ab6a-4b6ac7a01f0d", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "100.25.187.113", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "306a7883-a260-d41a-af80-adafb1f40ec9", "x-request-start": "1794438404391" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[101-1] sql_error_code = 00000 time_ms = \"2026-11-11 23:06:43.520 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498396\" tid=\"0\" log_line=\"14\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3611.880 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-11T23:06:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:06:43', STRUCTURED-DATA: '[DATABASE]', msg: '[101-2] sql_error_code = 00000 time_ms = "2026-11-11 23:06:43.520 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498396" tid="0" log_line="15" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[101-2] sql_error_code = 00000 time_ms = "2026-11-11 23:06:43.520 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498396" tid="0" log_line="15" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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-11T23:06:43+00:00 host app postgres.2485172 - [DATABASE] [101-2] sql_error_code = 00000 time_ms = "2026-11-11 23:06:43.520 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498396" tid="0" log_line="15" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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": "8a874157-813a-4fa6-ab6a-4b6ac7a01f0d", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "100.25.187.113", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "306a7883-a260-d41a-af80-adafb1f40ec9", "x-request-start": "1794438404391" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[101-2] sql_error_code = 00000 time_ms = \"2026-11-11 23:06:43.520 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498396\" tid=\"0\" log_line=\"15\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" 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-11T23:06:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:17:07', STRUCTURED-DATA: '[DATABASE]', msg: '[103-1] sql_error_code = 00000 time_ms = "2026-11-11 23:17:07.025 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498410" tid="0" log_line="18" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3038.695 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: '[103-1] sql_error_code = 00000 time_ms = "2026-11-11 23:17:07.025 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498410" tid="0" log_line="18" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3038.695 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-11T23:17:07+00:00 host app postgres.2485172 - [DATABASE] [103-1] sql_error_code = 00000 time_ms = "2026-11-11 23:17:07.025 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498410" tid="0" log_line="18" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3038.695 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": "9917ea10-5ad1-4431-b31b-20f47d3f7139", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.202.178.126", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "5825b8f7-c1d6-42f8-9c0e-3e0914d178b5", "x-request-start": "1794439027753" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[103-1] sql_error_code = 00000 time_ms = \"2026-11-11 23:17:07.025 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498410\" tid=\"0\" log_line=\"18\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3038.695 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-11T23:17:07+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:17:07', STRUCTURED-DATA: '[DATABASE]', msg: '[103-2] sql_error_code = 00000 time_ms = "2026-11-11 23:17:07.025 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498410" tid="0" log_line="19" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[103-2] sql_error_code = 00000 time_ms = "2026-11-11 23:17:07.025 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498410" tid="0" log_line="19" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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-11T23:17:07+00:00 host app postgres.2485172 - [DATABASE] [103-2] sql_error_code = 00000 time_ms = "2026-11-11 23:17:07.025 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498410" tid="0" log_line="19" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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": "9917ea10-5ad1-4431-b31b-20f47d3f7139", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.202.178.126", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "5825b8f7-c1d6-42f8-9c0e-3e0914d178b5", "x-request-start": "1794439027753" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[103-2] sql_error_code = 00000 time_ms = \"2026-11-11 23:17:07.025 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498410\" tid=\"0\" log_line=\"19\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" 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-11T23:17:07+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:27:26', STRUCTURED-DATA: '[DATABASE]', msg: '[105-1] sql_error_code = 00000 time_ms = "2026-11-11 23:27:26.035 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498421" tid="0" log_line="22" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3020.844 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: '[105-1] sql_error_code = 00000 time_ms = "2026-11-11 23:27:26.035 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498421" tid="0" log_line="22" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3020.844 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-11T23:27:26+00:00 host app postgres.2485172 - [DATABASE] [105-1] sql_error_code = 00000 time_ms = "2026-11-11 23:27:26.035 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498421" tid="0" log_line="22" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3020.844 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": "1d172a69-30c9-4267-8b3c-b25e84948cb5", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.159.106.149", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d1958765-0445-f614-912d-90f83c744c73", "x-request-start": "1794439646906" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[105-1] sql_error_code = 00000 time_ms = \"2026-11-11 23:27:26.035 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498421\" tid=\"0\" log_line=\"22\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3020.844 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-11T23:27:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:27:26', STRUCTURED-DATA: '[DATABASE]', msg: '[105-2] sql_error_code = 00000 time_ms = "2026-11-11 23:27:26.035 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498421" tid="0" log_line="23" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[105-2] sql_error_code = 00000 time_ms = "2026-11-11 23:27:26.035 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498421" tid="0" log_line="23" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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-11T23:27:26+00:00 host app postgres.2485172 - [DATABASE] [105-2] sql_error_code = 00000 time_ms = "2026-11-11 23:27:26.035 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498421" tid="0" log_line="23" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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": "1d172a69-30c9-4267-8b3c-b25e84948cb5", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.159.106.149", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d1958765-0445-f614-912d-90f83c744c73", "x-request-start": "1794439646906" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[105-2] sql_error_code = 00000 time_ms = \"2026-11-11 23:27:26.035 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498421\" tid=\"0\" log_line=\"23\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" 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-11T23:27:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:30:40', STRUCTURED-DATA: '[DATABASE]', msg: '[106-1] sql_error_code = 00000 time_ms = "2026-11-11 23:30:40.272 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498425" tid="0" log_line="24" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3193.467 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 23:30:40.272 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498425" tid="0" log_line="24" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3193.467 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-11T23:30:40+00:00 host app postgres.2485172 - [DATABASE] [106-1] sql_error_code = 00000 time_ms = "2026-11-11 23:30:40.272 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498425" tid="0" log_line="24" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3193.467 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": "75e09dd3-a7df-4416-8cfa-91dfd2ce2247", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.70.150.1", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "4a3a60b1-28df-dedb-7af1-9805fc1a6e89", "x-request-start": "1794439841150" }, "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 23:30:40.272 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498425\" tid=\"0\" log_line=\"24\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3193.467 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-11T23:30:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:30:40', STRUCTURED-DATA: '[DATABASE]', msg: '[106-2] sql_error_code = 00000 time_ms = "2026-11-11 23:30:40.272 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498425" tid="0" log_line="25" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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 23:30:40.272 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498425" tid="0" log_line="25" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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-11T23:30:40+00:00 host app postgres.2485172 - [DATABASE] [106-2] sql_error_code = 00000 time_ms = "2026-11-11 23:30:40.272 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498425" tid="0" log_line="25" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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": "75e09dd3-a7df-4416-8cfa-91dfd2ce2247", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.70.150.1", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "4a3a60b1-28df-dedb-7af1-9805fc1a6e89", "x-request-start": "1794439841150" }, "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 23:30:40.272 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498425\" tid=\"0\" log_line=\"25\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" 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-11T23:30:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:31:46', STRUCTURED-DATA: '[DATABASE]', msg: '[107-1] sql_error_code = 00000 time_ms = "2026-11-11 23:31:46.481 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498428" tid="0" log_line="26" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 4952.913 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: '[107-1] sql_error_code = 00000 time_ms = "2026-11-11 23:31:46.481 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498428" tid="0" log_line="26" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 4952.913 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-11T23:31:46+00:00 host app postgres.2485172 - [DATABASE] [107-1] sql_error_code = 00000 time_ms = "2026-11-11 23:31:46.481 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498428" tid="0" log_line="26" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 4952.913 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": "2c407e77-43d3-4de0-ac25-c5c392630db3", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.70.150.1", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "001d0a44-2196-dc28-f8ff-ed393b0d80a8", "x-request-start": "1794439907272" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[107-1] sql_error_code = 00000 time_ms = \"2026-11-11 23:31:46.481 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498428\" tid=\"0\" log_line=\"26\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 4952.913 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-11T23:31:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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.2485172]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2485172', MSGID: '-', TIMESTAMP: 'Nov 11 23:31:46', STRUCTURED-DATA: '[DATABASE]', msg: '[107-2] sql_error_code = 00000 time_ms = "2026-11-11 23:31:46.481 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498428" tid="0" log_line="27" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[107-2] sql_error_code = 00000 time_ms = "2026-11-11 23:31:46.481 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498428" tid="0" log_line="27" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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-11T23:31:46+00:00 host app postgres.2485172 - [DATABASE] [107-2] sql_error_code = 00000 time_ms = "2026-11-11 23:31:46.481 UTC" pid="1122430" proc_start_time="2026-11-11 22:50:07 UTC" session_id="6af4f11f.11207e" vtid="12/498428" tid="0" log_line="27" database="ddvvgu681gm35p" connection_source="10.0.173.48(47686)" 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": "2c407e77-43d3-4de0-ac25-c5c392630db3", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.70.150.1", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "001d0a44-2196-dc28-f8ff-ed393b0d80a8", "x-request-start": "1794439907272" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[107-2] sql_error_code = 00000 time_ms = \"2026-11-11 23:31:46.481 UTC\" pid=\"1122430\" proc_start_time=\"2026-11-11 22:50:07 UTC\" session_id=\"6af4f11f.11207e\" vtid=\"12\/498428\" tid=\"0\" log_line=\"27\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(47686)\" 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-11T23:31:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2485172", "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.2485172", "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" } $/: