Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 18:40:15', STRUCTURED-DATA: '[DATABASE]', msg: '[97-1] sql_error_code = 00000 time_ms = "2026-11-11 18:40:15.996 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134075" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3089.747 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 18:40:15.996 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134075" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3089.747 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-11T18:40:15+00:00 host app postgres.2429413 - [DATABASE] [97-1] sql_error_code = 00000 time_ms = "2026-11-11 18:40:15.996 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134075" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3089.747 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": "5de2445f-2e82-4c35-be5f-a2eaa7854130", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.55.34.130", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "077ad4d3-13f9-ab61-3497-69e3a390d03f", "x-request-start": "1794422416866" }, "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 18:40:15.996 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134075\" tid=\"0\" log_line=\"6\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3089.747 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-11T18:40:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 18:40:15', STRUCTURED-DATA: '[DATABASE]', msg: '[97-2] sql_error_code = 00000 time_ms = "2026-11-11 18:40:15.996 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134075" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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 18:40:15.996 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134075" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T18:40:15+00:00 host app postgres.2429413 - [DATABASE] [97-2] sql_error_code = 00000 time_ms = "2026-11-11 18:40:15.996 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134075" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "5de2445f-2e82-4c35-be5f-a2eaa7854130", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.55.34.130", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "077ad4d3-13f9-ab61-3497-69e3a390d03f", "x-request-start": "1794422416866" }, "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 18:40:15.996 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134075\" tid=\"0\" log_line=\"7\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T18:40:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 18:48:45', STRUCTURED-DATA: '[DATABASE]', msg: '[99-1] sql_error_code = 00000 time_ms = "2026-11-11 18:48:45.286 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134085" tid="0" log_line="10" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3029.714 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 18:48:45.286 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134085" tid="0" log_line="10" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3029.714 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-11T18:48:45+00:00 host app postgres.2429413 - [DATABASE] [99-1] sql_error_code = 00000 time_ms = "2026-11-11 18:48:45.286 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134085" tid="0" log_line="10" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3029.714 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": "ff325e75-d807-41ef-9a0a-4873aa5c3090", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.224.180.60", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "38f05907-258a-d014-2d62-e97095ab08d0", "x-request-start": "1794422926137" }, "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 18:48:45.286 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134085\" tid=\"0\" log_line=\"10\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3029.714 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-11T18:48:45+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 18:48:45', STRUCTURED-DATA: '[DATABASE]', msg: '[99-2] sql_error_code = 00000 time_ms = "2026-11-11 18:48:45.286 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134085" tid="0" log_line="11" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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 18:48:45.286 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134085" tid="0" log_line="11" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T18:48:45+00:00 host app postgres.2429413 - [DATABASE] [99-2] sql_error_code = 00000 time_ms = "2026-11-11 18:48:45.286 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134085" tid="0" log_line="11" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "ff325e75-d807-41ef-9a0a-4873aa5c3090", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.224.180.60", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "38f05907-258a-d014-2d62-e97095ab08d0", "x-request-start": "1794422926137" }, "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 18:48:45.286 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134085\" tid=\"0\" log_line=\"11\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T18:48:45+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 18:48:51', STRUCTURED-DATA: '[DATABASE]', msg: '[100-1] sql_error_code = 00000 time_ms = "2026-11-11 18:48:51.970 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134088" tid="0" log_line="12" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3054.948 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 18:48:51.970 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134088" tid="0" log_line="12" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3054.948 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-11T18:48:51+00:00 host app postgres.2429413 - [DATABASE] [100-1] sql_error_code = 00000 time_ms = "2026-11-11 18:48:51.970 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134088" tid="0" log_line="12" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3054.948 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "cb083214-51dd-42c3-935c-64064843db9c", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.71.146.117", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "962c1b9c-3ec5-3af2-9fc8-d2cba94d863b", "x-request-start": "1794422932888" }, "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 18:48:51.970 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134088\" tid=\"0\" log_line=\"12\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3054.948 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-11T18:48:51+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 18:48:51', STRUCTURED-DATA: '[DATABASE]', msg: '[100-2] sql_error_code = 00000 time_ms = "2026-11-11 18:48:51.970 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134088" tid="0" log_line="13" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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 18:48:51.970 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134088" tid="0" log_line="13" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T18:48:51+00:00 host app postgres.2429413 - [DATABASE] [100-2] sql_error_code = 00000 time_ms = "2026-11-11 18:48:51.970 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134088" tid="0" log_line="13" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "cb083214-51dd-42c3-935c-64064843db9c", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.71.146.117", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "962c1b9c-3ec5-3af2-9fc8-d2cba94d863b", "x-request-start": "1794422932888" }, "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 18:48:51.970 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134088\" tid=\"0\" log_line=\"13\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T18:48:51+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 18:50:38', STRUCTURED-DATA: '[DATABASE]', msg: '[101-1] sql_error_code = 00000 time_ms = "2026-11-11 18:50:38.915 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134091" tid="0" log_line="14" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3157.685 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 18:50:38.915 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134091" tid="0" log_line="14" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3157.685 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-11T18:50:38+00:00 host app postgres.2429413 - [DATABASE] [101-1] sql_error_code = 00000 time_ms = "2026-11-11 18:50:38.915 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134091" tid="0" log_line="14" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3157.685 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "f299ceae-a24a-43b5-8a5f-6def5f92e293", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.3.104.233", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "23405bf3-381b-e7ca-8dab-e6f84ec80969", "x-request-start": "1794423039880" }, "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 18:50:38.915 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134091\" tid=\"0\" log_line=\"14\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3157.685 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-11T18:50:38+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 18:50:38', STRUCTURED-DATA: '[DATABASE]', msg: '[101-2] sql_error_code = 00000 time_ms = "2026-11-11 18:50:38.915 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134091" tid="0" log_line="15" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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 18:50:38.915 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134091" tid="0" log_line="15" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T18:50:38+00:00 host app postgres.2429413 - [DATABASE] [101-2] sql_error_code = 00000 time_ms = "2026-11-11 18:50:38.915 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134091" tid="0" log_line="15" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "f299ceae-a24a-43b5-8a5f-6def5f92e293", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.3.104.233", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "23405bf3-381b-e7ca-8dab-e6f84ec80969", "x-request-start": "1794423039880" }, "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 18:50:38.915 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134091\" tid=\"0\" log_line=\"15\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T18:50:38+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:02:38', STRUCTURED-DATA: '[DATABASE]', msg: '[106-1] sql_error_code = 00000 time_ms = "2026-11-11 19:02:38.622 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134123" tid="0" log_line="24" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3053.723 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 19:02:38.622 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134123" tid="0" log_line="24" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3053.723 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-11T19:02:38+00:00 host app postgres.2429413 - [DATABASE] [106-1] sql_error_code = 00000 time_ms = "2026-11-11 19:02:38.622 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134123" tid="0" log_line="24" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3053.723 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "48192061-6ccc-4a11-ada7-349650d59206", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.226.156.187", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "323a06b4-3226-b591-44b5-4e135fb501ee", "x-request-start": "1794423759631" }, "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 19:02:38.622 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134123\" tid=\"0\" log_line=\"24\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3053.723 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-11T19:02:38+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:02:38', STRUCTURED-DATA: '[DATABASE]', msg: '[106-2] sql_error_code = 00000 time_ms = "2026-11-11 19:02:38.622 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134123" tid="0" log_line="25" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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 19:02:38.622 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134123" tid="0" log_line="25" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T19:02:38+00:00 host app postgres.2429413 - [DATABASE] [106-2] sql_error_code = 00000 time_ms = "2026-11-11 19:02:38.622 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134123" tid="0" log_line="25" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "48192061-6ccc-4a11-ada7-349650d59206", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.226.156.187", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "323a06b4-3226-b591-44b5-4e135fb501ee", "x-request-start": "1794423759631" }, "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 19:02:38.622 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134123\" tid=\"0\" log_line=\"25\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T19:02:38+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:11:43', STRUCTURED-DATA: '[DATABASE]', msg: '[108-1] sql_error_code = 00000 time_ms = "2026-11-11 19:11:43.036 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134133" tid="0" log_line="28" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3163.585 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: '[108-1] sql_error_code = 00000 time_ms = "2026-11-11 19:11:43.036 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134133" tid="0" log_line="28" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3163.585 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-11T19:11:43+00:00 host app postgres.2429413 - [DATABASE] [108-1] sql_error_code = 00000 time_ms = "2026-11-11 19:11:43.036 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134133" tid="0" log_line="28" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3163.585 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "ed5fda63-8ed4-415e-8cdf-25bd0606ccf7", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "18.214.177.51", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "46bf175e-fcaf-628a-e14a-c551061fab2e", "x-request-start": "1794424303878" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[108-1] sql_error_code = 00000 time_ms = \"2026-11-11 19:11:43.036 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134133\" tid=\"0\" log_line=\"28\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3163.585 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-11T19:11:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:11:43', STRUCTURED-DATA: '[DATABASE]', msg: '[108-2] sql_error_code = 00000 time_ms = "2026-11-11 19:11:43.036 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134133" tid="0" log_line="29" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[108-2] sql_error_code = 00000 time_ms = "2026-11-11 19:11:43.036 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134133" tid="0" log_line="29" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T19:11:43+00:00 host app postgres.2429413 - [DATABASE] [108-2] sql_error_code = 00000 time_ms = "2026-11-11 19:11:43.036 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134133" tid="0" log_line="29" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "ed5fda63-8ed4-415e-8cdf-25bd0606ccf7", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "18.214.177.51", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "46bf175e-fcaf-628a-e14a-c551061fab2e", "x-request-start": "1794424303878" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[108-2] sql_error_code = 00000 time_ms = \"2026-11-11 19:11:43.036 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134133\" tid=\"0\" log_line=\"29\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T19:11:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:26:23', STRUCTURED-DATA: '[DATABASE]', msg: '[109-1] sql_error_code = 00000 time_ms = "2026-11-11 19:26:23.236 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134138" tid="0" log_line="30" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3046.519 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: '[109-1] sql_error_code = 00000 time_ms = "2026-11-11 19:26:23.236 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134138" tid="0" log_line="30" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3046.519 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-11T19:26:23+00:00 host app postgres.2429413 - [DATABASE] [109-1] sql_error_code = 00000 time_ms = "2026-11-11 19:26:23.236 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134138" tid="0" log_line="30" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3046.519 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "47352fe2-f1de-4649-9faf-6e080fbdfa4e", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.224.180.60", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "f47b6229-5244-7abc-b28e-d774f183fa1b", "x-request-start": "1794425184144" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[109-1] sql_error_code = 00000 time_ms = \"2026-11-11 19:26:23.236 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134138\" tid=\"0\" log_line=\"30\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3046.519 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-11T19:26:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:26:23', STRUCTURED-DATA: '[DATABASE]', msg: '[109-2] sql_error_code = 00000 time_ms = "2026-11-11 19:26:23.236 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134138" tid="0" log_line="31" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[109-2] sql_error_code = 00000 time_ms = "2026-11-11 19:26:23.236 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134138" tid="0" log_line="31" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T19:26:23+00:00 host app postgres.2429413 - [DATABASE] [109-2] sql_error_code = 00000 time_ms = "2026-11-11 19:26:23.236 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134138" tid="0" log_line="31" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "47352fe2-f1de-4649-9faf-6e080fbdfa4e", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.224.180.60", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "f47b6229-5244-7abc-b28e-d774f183fa1b", "x-request-start": "1794425184144" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[109-2] sql_error_code = 00000 time_ms = \"2026-11-11 19:26:23.236 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134138\" tid=\"0\" log_line=\"31\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T19:26:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:36:11', STRUCTURED-DATA: '[DATABASE]', msg: '[112-1] sql_error_code = 00000 time_ms = "2026-11-11 19:36:11.635 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134155" tid="0" log_line="36" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3056.687 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: '[112-1] sql_error_code = 00000 time_ms = "2026-11-11 19:36:11.635 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134155" tid="0" log_line="36" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3056.687 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-11T19:36:11+00:00 host app postgres.2429413 - [DATABASE] [112-1] sql_error_code = 00000 time_ms = "2026-11-11 19:36:11.635 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134155" tid="0" log_line="36" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3056.687 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "f7c1f5df-e15f-4b8f-b0a4-b97853fcaf47", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.238.100.87", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "5fa47a2c-082f-af84-3931-68b74422de57", "x-request-start": "1794425772643" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[112-1] sql_error_code = 00000 time_ms = \"2026-11-11 19:36:11.635 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134155\" tid=\"0\" log_line=\"36\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3056.687 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-11T19:36:11+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:36:11', STRUCTURED-DATA: '[DATABASE]', msg: '[112-2] sql_error_code = 00000 time_ms = "2026-11-11 19:36:11.635 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134155" tid="0" log_line="37" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[112-2] sql_error_code = 00000 time_ms = "2026-11-11 19:36:11.635 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134155" tid="0" log_line="37" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T19:36:11+00:00 host app postgres.2429413 - [DATABASE] [112-2] sql_error_code = 00000 time_ms = "2026-11-11 19:36:11.635 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134155" tid="0" log_line="37" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "f7c1f5df-e15f-4b8f-b0a4-b97853fcaf47", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.238.100.87", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "5fa47a2c-082f-af84-3931-68b74422de57", "x-request-start": "1794425772643" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[112-2] sql_error_code = 00000 time_ms = \"2026-11-11 19:36:11.635 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134155\" tid=\"0\" log_line=\"37\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T19:36:11+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:36:19', STRUCTURED-DATA: '[DATABASE]', msg: '[113-1] sql_error_code = 00000 time_ms = "2026-11-11 19:36:19.792 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134158" tid="0" log_line="38" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3073.611 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 19:36:19.792 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134158" tid="0" log_line="38" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3073.611 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-11T19:36:19+00:00 host app postgres.2429413 - [DATABASE] [113-1] sql_error_code = 00000 time_ms = "2026-11-11 19:36:19.792 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134158" tid="0" log_line="38" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3073.611 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "c2f35ac0-f60c-46ce-b6e5-00a45b132de8", "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": "963cf303-de0a-b938-b454-cb85d9087cd3", "x-request-start": "1794425780624" }, "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 19:36:19.792 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134158\" tid=\"0\" log_line=\"38\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3073.611 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-11T19:36:19+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:36:19', STRUCTURED-DATA: '[DATABASE]', msg: '[113-2] sql_error_code = 00000 time_ms = "2026-11-11 19:36:19.792 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134158" tid="0" log_line="39" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[113-2] sql_error_code = 00000 time_ms = "2026-11-11 19:36:19.792 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134158" tid="0" log_line="39" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T19:36:19+00:00 host app postgres.2429413 - [DATABASE] [113-2] sql_error_code = 00000 time_ms = "2026-11-11 19:36:19.792 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134158" tid="0" log_line="39" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "c2f35ac0-f60c-46ce-b6e5-00a45b132de8", "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": "963cf303-de0a-b938-b454-cb85d9087cd3", "x-request-start": "1794425780624" }, "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 19:36:19.792 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134158\" tid=\"0\" log_line=\"39\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T19:36:19+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:39:08', STRUCTURED-DATA: '[DATABASE]', msg: '[116-1] sql_error_code = 00000 time_ms = "2026-11-11 19:39:08.593 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134168" tid="0" log_line="44" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3066.537 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: '[116-1] sql_error_code = 00000 time_ms = "2026-11-11 19:39:08.593 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134168" tid="0" log_line="44" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3066.537 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-11T19:39:08+00:00 host app postgres.2429413 - [DATABASE] [116-1] sql_error_code = 00000 time_ms = "2026-11-11 19:39:08.593 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134168" tid="0" log_line="44" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3066.537 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "c2d563f0-741b-42ac-861b-1d3dcdd01f40", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.82.46.53", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "17f64208-ce7c-d291-1090-ff84aa1805ea", "x-request-start": "1794425949388" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[116-1] sql_error_code = 00000 time_ms = \"2026-11-11 19:39:08.593 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134168\" tid=\"0\" log_line=\"44\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3066.537 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-11T19:39:08+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:39:08', STRUCTURED-DATA: '[DATABASE]', msg: '[116-2] sql_error_code = 00000 time_ms = "2026-11-11 19:39:08.593 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134168" tid="0" log_line="45" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[116-2] sql_error_code = 00000 time_ms = "2026-11-11 19:39:08.593 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134168" tid="0" log_line="45" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T19:39:08+00:00 host app postgres.2429413 - [DATABASE] [116-2] sql_error_code = 00000 time_ms = "2026-11-11 19:39:08.593 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134168" tid="0" log_line="45" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "c2d563f0-741b-42ac-861b-1d3dcdd01f40", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.82.46.53", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "17f64208-ce7c-d291-1090-ff84aa1805ea", "x-request-start": "1794425949388" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[116-2] sql_error_code = 00000 time_ms = \"2026-11-11 19:39:08.593 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134168\" tid=\"0\" log_line=\"45\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T19:39:08+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:46:43', STRUCTURED-DATA: '[DATABASE]', msg: '[117-1] sql_error_code = 00000 time_ms = "2026-11-11 19:46:43.584 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134174" tid="0" log_line="46" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3303.794 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: '[117-1] sql_error_code = 00000 time_ms = "2026-11-11 19:46:43.584 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134174" tid="0" log_line="46" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3303.794 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-11T19:46:43+00:00 host app postgres.2429413 - [DATABASE] [117-1] sql_error_code = 00000 time_ms = "2026-11-11 19:46:43.584 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134174" tid="0" log_line="46" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3303.794 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "2d86807b-4317-4a74-8517-6d1f386b9257", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.144.58.241", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "7d79182c-2c70-eae6-4b82-dd939969814d", "x-request-start": "1794426404372" }, "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 19:46:43.584 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134174\" tid=\"0\" log_line=\"46\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3303.794 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-11T19:46:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:46:43', STRUCTURED-DATA: '[DATABASE]', msg: '[117-2] sql_error_code = 00000 time_ms = "2026-11-11 19:46:43.584 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134174" tid="0" log_line="47" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[117-2] sql_error_code = 00000 time_ms = "2026-11-11 19:46:43.584 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134174" tid="0" log_line="47" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T19:46:43+00:00 host app postgres.2429413 - [DATABASE] [117-2] sql_error_code = 00000 time_ms = "2026-11-11 19:46:43.584 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134174" tid="0" log_line="47" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "2d86807b-4317-4a74-8517-6d1f386b9257", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.144.58.241", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "7d79182c-2c70-eae6-4b82-dd939969814d", "x-request-start": "1794426404372" }, "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 19:46:43.584 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134174\" tid=\"0\" log_line=\"47\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T19:46:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:49:39', STRUCTURED-DATA: '[DATABASE]', msg: '[119-1] sql_error_code = 00000 time_ms = "2026-11-11 19:49:39.008 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134181" tid="0" log_line="50" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 4295.539 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 19:49:39.008 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134181" tid="0" log_line="50" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 4295.539 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-11T19:49:39+00:00 host app postgres.2429413 - [DATABASE] [119-1] sql_error_code = 00000 time_ms = "2026-11-11 19:49:39.008 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134181" tid="0" log_line="50" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 4295.539 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": "1375", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "a47a6a11-df2c-4249-ade9-0fe97aa6e2a1", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "44.214.169.96", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "e8bb87f7-a284-7733-d6fb-aa2302f775d9", "x-request-start": "1794426579869" }, "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 19:49:39.008 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134181\" tid=\"0\" log_line=\"50\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 4295.539 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-11T19:49:39+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:49:39', STRUCTURED-DATA: '[DATABASE]', msg: '[119-2] sql_error_code = 00000 time_ms = "2026-11-11 19:49:39.008 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134181" tid="0" log_line="51" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '1999-01-01 01:00:01+00'' escaped msg: '[119-2] sql_error_code = 00000 time_ms = "2026-11-11 19:49:39.008 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134181" tid="0" log_line="51" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T19:49:39+00:00 host app postgres.2429413 - [DATABASE] [119-2] sql_error_code = 00000 time_ms = "2026-11-11 19:49:39.008 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134181" tid="0" log_line="51" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1375", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "a47a6a11-df2c-4249-ade9-0fe97aa6e2a1", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "44.214.169.96", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "e8bb87f7-a284-7733-d6fb-aa2302f775d9", "x-request-start": "1794426579869" }, "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 19:49:39.008 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134181\" tid=\"0\" log_line=\"51\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T19:49:39+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:57:39', STRUCTURED-DATA: '[DATABASE]', msg: '[121-1] sql_error_code = 00000 time_ms = "2026-11-11 19:57:39.949 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134191" tid="0" log_line="54" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2997.327 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 19:57:39.949 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134191" tid="0" log_line="54" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2997.327 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-11T19:57:39+00:00 host app postgres.2429413 - [DATABASE] [121-1] sql_error_code = 00000 time_ms = "2026-11-11 19:57:39.949 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134191" tid="0" log_line="54" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2997.327 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "48e6d903-3b66-4fba-85c0-907f0c0ee9c3", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.209.91.58", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "9b6e21cd-3905-135b-d595-403ca8a9e550", "x-request-start": "1794427060887" }, "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 19:57:39.949 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134191\" tid=\"0\" log_line=\"54\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 2997.327 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-11T19:57:39+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:57:39', STRUCTURED-DATA: '[DATABASE]', msg: '[121-2] sql_error_code = 00000 time_ms = "2026-11-11 19:57:39.949 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134191" tid="0" log_line="55" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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 19:57:39.949 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134191" tid="0" log_line="55" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T19:57:39+00:00 host app postgres.2429413 - [DATABASE] [121-2] sql_error_code = 00000 time_ms = "2026-11-11 19:57:39.949 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134191" tid="0" log_line="55" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "48e6d903-3b66-4fba-85c0-907f0c0ee9c3", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.209.91.58", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "9b6e21cd-3905-135b-d595-403ca8a9e550", "x-request-start": "1794427060887" }, "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 19:57:39.949 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134191\" tid=\"0\" log_line=\"55\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T19:57:39+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:58:53', STRUCTURED-DATA: '[DATABASE]', msg: '[123-1] sql_error_code = 00000 time_ms = "2026-11-11 19:58:53.586 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134197" tid="0" log_line="58" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3015.257 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: '[123-1] sql_error_code = 00000 time_ms = "2026-11-11 19:58:53.586 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134197" tid="0" log_line="58" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3015.257 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-11T19:58:53+00:00 host app postgres.2429413 - [DATABASE] [123-1] sql_error_code = 00000 time_ms = "2026-11-11 19:58:53.586 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134197" tid="0" log_line="58" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3015.257 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "9c608edc-1d1f-47e8-a23b-ec532984b455", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "44.214.169.96", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d9bdc2e6-9cef-c5ef-ab11-e3ce9d58608b", "x-request-start": "1794427134369" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[123-1] sql_error_code = 00000 time_ms = \"2026-11-11 19:58:53.586 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134197\" tid=\"0\" log_line=\"58\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3015.257 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-11T19:58:53+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 19:58:53', STRUCTURED-DATA: '[DATABASE]', msg: '[123-2] sql_error_code = 00000 time_ms = "2026-11-11 19:58:53.586 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134197" tid="0" log_line="59" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[123-2] sql_error_code = 00000 time_ms = "2026-11-11 19:58:53.586 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134197" tid="0" log_line="59" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T19:58:53+00:00 host app postgres.2429413 - [DATABASE] [123-2] sql_error_code = 00000 time_ms = "2026-11-11 19:58:53.586 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134197" tid="0" log_line="59" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "9c608edc-1d1f-47e8-a23b-ec532984b455", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "44.214.169.96", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d9bdc2e6-9cef-c5ef-ab11-e3ce9d58608b", "x-request-start": "1794427134369" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[123-2] sql_error_code = 00000 time_ms = \"2026-11-11 19:58:53.586 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134197\" tid=\"0\" log_line=\"59\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T19:58:53+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 20:00:31', STRUCTURED-DATA: '[DATABASE]', msg: '[125-1] sql_error_code = 00000 time_ms = "2026-11-11 20:00:31.953 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134201" tid="0" log_line="62" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3214.453 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: '[125-1] sql_error_code = 00000 time_ms = "2026-11-11 20:00:31.953 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134201" tid="0" log_line="62" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3214.453 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-11T20:00:31+00:00 host app postgres.2429413 - [DATABASE] [125-1] sql_error_code = 00000 time_ms = "2026-11-11 20:00:31.953 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134201" tid="0" log_line="62" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3214.453 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "7e201820-a41e-4cc4-96eb-7e8b147dd5db", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.147.88.38", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "690000a6-6683-7de9-401a-90e7e2777e02", "x-request-start": "1794427232891" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[125-1] sql_error_code = 00000 time_ms = \"2026-11-11 20:00:31.953 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134201\" tid=\"0\" log_line=\"62\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3214.453 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-11T20:00:31+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 20:00:31', STRUCTURED-DATA: '[DATABASE]', msg: '[125-2] sql_error_code = 00000 time_ms = "2026-11-11 20:00:31.953 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134201" tid="0" log_line="63" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[125-2] sql_error_code = 00000 time_ms = "2026-11-11 20:00:31.953 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134201" tid="0" log_line="63" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T20:00:31+00:00 host app postgres.2429413 - [DATABASE] [125-2] sql_error_code = 00000 time_ms = "2026-11-11 20:00:31.953 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134201" tid="0" log_line="63" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "7e201820-a41e-4cc4-96eb-7e8b147dd5db", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.147.88.38", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "690000a6-6683-7de9-401a-90e7e2777e02", "x-request-start": "1794427232891" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[125-2] sql_error_code = 00000 time_ms = \"2026-11-11 20:00:31.953 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134201\" tid=\"0\" log_line=\"63\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T20:00:31+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 20:02:22', STRUCTURED-DATA: '[DATABASE]', msg: '[127-1] sql_error_code = 00000 time_ms = "2026-11-11 20:02:22.064 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134207" tid="0" log_line="66" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3003.355 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: '[127-1] sql_error_code = 00000 time_ms = "2026-11-11 20:02:22.064 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134207" tid="0" log_line="66" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3003.355 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-11T20:02:22+00:00 host app postgres.2429413 - [DATABASE] [127-1] sql_error_code = 00000 time_ms = "2026-11-11 20:02:22.064 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134207" tid="0" log_line="66" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3003.355 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "888c29c1-142a-4dc9-ba58-0ba667f1ae58", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.209.91.58", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "95210700-76be-875b-d101-91a71f43aad5", "x-request-start": "1794427342882" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[127-1] sql_error_code = 00000 time_ms = \"2026-11-11 20:02:22.064 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134207\" tid=\"0\" log_line=\"66\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3003.355 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-11T20:02:22+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 20:02:22', STRUCTURED-DATA: '[DATABASE]', msg: '[127-2] sql_error_code = 00000 time_ms = "2026-11-11 20:02:22.064 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134207" tid="0" log_line="67" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[127-2] sql_error_code = 00000 time_ms = "2026-11-11 20:02:22.064 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134207" tid="0" log_line="67" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T20:02:22+00:00 host app postgres.2429413 - [DATABASE] [127-2] sql_error_code = 00000 time_ms = "2026-11-11 20:02:22.064 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134207" tid="0" log_line="67" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "888c29c1-142a-4dc9-ba58-0ba667f1ae58", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.209.91.58", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "95210700-76be-875b-d101-91a71f43aad5", "x-request-start": "1794427342882" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[127-2] sql_error_code = 00000 time_ms = \"2026-11-11 20:02:22.064 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134207\" tid=\"0\" log_line=\"67\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T20:02:22+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 20:11:33', STRUCTURED-DATA: '[DATABASE]', msg: '[131-1] sql_error_code = 00000 time_ms = "2026-11-11 20:11:33.791 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134224" tid="0" log_line="74" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3117.661 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: '[131-1] sql_error_code = 00000 time_ms = "2026-11-11 20:11:33.791 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134224" tid="0" log_line="74" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3117.661 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-11T20:11:33+00:00 host app postgres.2429413 - [DATABASE] [131-1] sql_error_code = 00000 time_ms = "2026-11-11 20:11:33.791 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134224" tid="0" log_line="74" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3117.661 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "b8217174-ec6d-433b-a19b-9553ddd4f61b", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.203.149.166", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d43e04d1-808e-1242-a3a1-130c5e9df5e0", "x-request-start": "1794427894636" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[131-1] sql_error_code = 00000 time_ms = \"2026-11-11 20:11:33.791 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134224\" tid=\"0\" log_line=\"74\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3117.661 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-11T20:11:33+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 20:11:33', STRUCTURED-DATA: '[DATABASE]', msg: '[131-2] sql_error_code = 00000 time_ms = "2026-11-11 20:11:33.791 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134224" tid="0" log_line="75" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[131-2] sql_error_code = 00000 time_ms = "2026-11-11 20:11:33.791 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134224" tid="0" log_line="75" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T20:11:33+00:00 host app postgres.2429413 - [DATABASE] [131-2] sql_error_code = 00000 time_ms = "2026-11-11 20:11:33.791 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134224" tid="0" log_line="75" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "b8217174-ec6d-433b-a19b-9553ddd4f61b", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.203.149.166", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d43e04d1-808e-1242-a3a1-130c5e9df5e0", "x-request-start": "1794427894636" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[131-2] sql_error_code = 00000 time_ms = \"2026-11-11 20:11:33.791 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134224\" tid=\"0\" log_line=\"75\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T20:11:33+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 20:12:54', STRUCTURED-DATA: '[DATABASE]', msg: '[132-1] sql_error_code = 00000 time_ms = "2026-11-11 20:12:54.796 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134227" tid="0" log_line="76" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3028.358 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: '[132-1] sql_error_code = 00000 time_ms = "2026-11-11 20:12:54.796 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134227" tid="0" log_line="76" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3028.358 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-11T20:12:54+00:00 host app postgres.2429413 - [DATABASE] [132-1] sql_error_code = 00000 time_ms = "2026-11-11 20:12:54.796 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134227" tid="0" log_line="76" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3028.358 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "9cc7b901-1804-4e6d-983b-be7410ad5a6d", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.144.58.241", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "f68106ee-2b5b-3080-d666-4f978ecde84d", "x-request-start": "1794427975624" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[132-1] sql_error_code = 00000 time_ms = \"2026-11-11 20:12:54.796 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134227\" tid=\"0\" log_line=\"76\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3028.358 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-11T20:12:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 20:12:54', STRUCTURED-DATA: '[DATABASE]', msg: '[132-2] sql_error_code = 00000 time_ms = "2026-11-11 20:12:54.796 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134227" tid="0" log_line="77" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[132-2] sql_error_code = 00000 time_ms = "2026-11-11 20:12:54.796 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134227" tid="0" log_line="77" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T20:12:54+00:00 host app postgres.2429413 - [DATABASE] [132-2] sql_error_code = 00000 time_ms = "2026-11-11 20:12:54.796 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134227" tid="0" log_line="77" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "9cc7b901-1804-4e6d-983b-be7410ad5a6d", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.144.58.241", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "f68106ee-2b5b-3080-d666-4f978ecde84d", "x-request-start": "1794427975624" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[132-2] sql_error_code = 00000 time_ms = \"2026-11-11 20:12:54.796 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134227\" tid=\"0\" log_line=\"77\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T20:12:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 20:20:53', STRUCTURED-DATA: '[DATABASE]', msg: '[134-1] sql_error_code = 00000 time_ms = "2026-11-11 20:20:53.974 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134236" tid="0" log_line="80" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3096.807 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: '[134-1] sql_error_code = 00000 time_ms = "2026-11-11 20:20:53.974 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134236" tid="0" log_line="80" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3096.807 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-11T20:20:53+00:00 host app postgres.2429413 - [DATABASE] [134-1] sql_error_code = 00000 time_ms = "2026-11-11 20:20:53.974 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134236" tid="0" log_line="80" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3096.807 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "68dbe413-0abc-4779-b2a2-3a2bd3f65a46", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.86.193.78", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "49733fdb-19ee-2279-6e2c-df7e925a3efd", "x-request-start": "1794428454869" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[134-1] sql_error_code = 00000 time_ms = \"2026-11-11 20:20:53.974 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134236\" tid=\"0\" log_line=\"80\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3096.807 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-11T20:20:53+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 20:20:53', STRUCTURED-DATA: '[DATABASE]', msg: '[134-2] sql_error_code = 00000 time_ms = "2026-11-11 20:20:53.974 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134236" tid="0" log_line="81" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[134-2] sql_error_code = 00000 time_ms = "2026-11-11 20:20:53.974 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134236" tid="0" log_line="81" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T20:20:53+00:00 host app postgres.2429413 - [DATABASE] [134-2] sql_error_code = 00000 time_ms = "2026-11-11 20:20:53.974 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134236" tid="0" log_line="81" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "68dbe413-0abc-4779-b2a2-3a2bd3f65a46", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.86.193.78", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "49733fdb-19ee-2279-6e2c-df7e925a3efd", "x-request-start": "1794428454869" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[134-2] sql_error_code = 00000 time_ms = \"2026-11-11 20:20:53.974 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134236\" tid=\"0\" log_line=\"81\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T20:20:53+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 20:21:03', STRUCTURED-DATA: '[DATABASE]', msg: '[135-1] sql_error_code = 00000 time_ms = "2026-11-11 20:21:03.290 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134239" tid="0" log_line="82" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3200.308 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: '[135-1] sql_error_code = 00000 time_ms = "2026-11-11 20:21:03.290 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134239" tid="0" log_line="82" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3200.308 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-11T20:21:03+00:00 host app postgres.2429413 - [DATABASE] [135-1] sql_error_code = 00000 time_ms = "2026-11-11 20:21:03.290 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134239" tid="0" log_line="82" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3200.308 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "186f230f-0703-42c3-a242-99b9d4359c09", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.55.19.186", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "7b433ffc-965c-8eca-3180-0ecc8e64099f", "x-request-start": "1794428463812" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[135-1] sql_error_code = 00000 time_ms = \"2026-11-11 20:21:03.290 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134239\" tid=\"0\" log_line=\"82\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3200.308 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-11T20:21:03+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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.2429413]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2429413', MSGID: '-', TIMESTAMP: 'Nov 11 20:21:03', STRUCTURED-DATA: '[DATABASE]', msg: '[135-2] sql_error_code = 00000 time_ms = "2026-11-11 20:21:03.290 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134239" tid="0" log_line="83" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[135-2] sql_error_code = 00000 time_ms = "2026-11-11 20:21:03.290 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134239" tid="0" log_line="83" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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-11T20:21:03+00:00 host app postgres.2429413 - [DATABASE] [135-2] sql_error_code = 00000 time_ms = "2026-11-11 20:21:03.290 UTC" pid="1116662" proc_start_time="2026-11-11 18:00:04 UTC" session_id="6af4ad24.1109f6" vtid="54/134239" tid="0" log_line="83" database="ddvvgu681gm35p" connection_source="10.0.151.136(55150)" 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": "1378", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "186f230f-0703-42c3-a242-99b9d4359c09", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.55.19.186", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "7b433ffc-965c-8eca-3180-0ecc8e64099f", "x-request-start": "1794428463812" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[135-2] sql_error_code = 00000 time_ms = \"2026-11-11 20:21:03.290 UTC\" pid=\"1116662\" proc_start_time=\"2026-11-11 18:00:04 UTC\" session_id=\"6af4ad24.1109f6\" vtid=\"54\/134239\" tid=\"0\" log_line=\"83\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(55150)\" 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-11T20:21:03+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2429413", "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.2429413", "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" } $/: