Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 21:45:16', STRUCTURED-DATA: '[DATABASE]', msg: '[96-1] sql_error_code = 00000 time_ms = "2026-11-11 21:45:16.626 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364793" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3119.819 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[96-1] sql_error_code = 00000 time_ms = "2026-11-11 21:45:16.626 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364793" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3119.819 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-11T21:45:16+00:00 host app postgres.2471682 - [DATABASE] [96-1] sql_error_code = 00000 time_ms = "2026-11-11 21:45:16.626 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364793" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3119.819 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "95cc7c63-0f78-4b87-96f4-230c72d517fb", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "18.232.255.149", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "8490875e-0cff-1f60-6cd3-9aad4b949dc1", "x-request-start": "1794433517638" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[96-1] sql_error_code = 00000 time_ms = \"2026-11-11 21:45:16.626 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364793\" tid=\"0\" log_line=\"4\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3119.819 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-11T21:45:16+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 21:45:16', STRUCTURED-DATA: '[DATABASE]', msg: '[96-2] sql_error_code = 00000 time_ms = "2026-11-11 21:45:16.626 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364793" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[96-2] sql_error_code = 00000 time_ms = "2026-11-11 21:45:16.626 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364793" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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-11T21:45:16+00:00 host app postgres.2471682 - [DATABASE] [96-2] sql_error_code = 00000 time_ms = "2026-11-11 21:45:16.626 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364793" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "95cc7c63-0f78-4b87-96f4-230c72d517fb", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "18.232.255.149", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "8490875e-0cff-1f60-6cd3-9aad4b949dc1", "x-request-start": "1794433517638" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[96-2] sql_error_code = 00000 time_ms = \"2026-11-11 21:45:16.626 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364793\" tid=\"0\" log_line=\"5\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" 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-11T21:45:16+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 21:46:52', STRUCTURED-DATA: '[DATABASE]', msg: '[97-1] sql_error_code = 00000 time_ms = "2026-11-11 21:46:52.626 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364796" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2983.414 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 21:46:52.626 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364796" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2983.414 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-11T21:46:52+00:00 host app postgres.2471682 - [DATABASE] [97-1] sql_error_code = 00000 time_ms = "2026-11-11 21:46:52.626 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364796" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2983.414 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "e551be9d-6881-4732-ab2d-348c33f1f90c", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "204.236.228.198", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "903b7f87-cab3-5aac-919b-0442b5c69eb8", "x-request-start": "1794433613624" }, "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 21:46:52.626 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364796\" tid=\"0\" log_line=\"6\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 2983.414 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-11T21:46:52+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 21:46:52', STRUCTURED-DATA: '[DATABASE]', msg: '[97-2] sql_error_code = 00000 time_ms = "2026-11-11 21:46:52.626 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364796" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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 21:46:52.626 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364796" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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-11T21:46:52+00:00 host app postgres.2471682 - [DATABASE] [97-2] sql_error_code = 00000 time_ms = "2026-11-11 21:46:52.626 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364796" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "e551be9d-6881-4732-ab2d-348c33f1f90c", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "204.236.228.198", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "903b7f87-cab3-5aac-919b-0442b5c69eb8", "x-request-start": "1794433613624" }, "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 21:46:52.626 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364796\" tid=\"0\" log_line=\"7\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" 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-11T21:46:52+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 21:54:42', STRUCTURED-DATA: '[DATABASE]', msg: '[98-1] sql_error_code = 00000 time_ms = "2026-11-11 21:54:42.520 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364805" tid="0" log_line="8" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3034.798 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[98-1] sql_error_code = 00000 time_ms = "2026-11-11 21:54:42.520 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364805" tid="0" log_line="8" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3034.798 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-11T21:54:42+00:00 host app postgres.2471682 - [DATABASE] [98-1] sql_error_code = 00000 time_ms = "2026-11-11 21:54:42.520 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364805" tid="0" log_line="8" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3034.798 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "5e9e08ce-89a8-4b4f-98df-a7e8c640b077", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "18.210.124.108", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "9774fc44-de87-11a0-901a-560565b9d791", "x-request-start": "1794434083369" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[98-1] sql_error_code = 00000 time_ms = \"2026-11-11 21:54:42.520 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364805\" tid=\"0\" log_line=\"8\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3034.798 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-11T21:54:42+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 21:54:42', STRUCTURED-DATA: '[DATABASE]', msg: '[98-2] sql_error_code = 00000 time_ms = "2026-11-11 21:54:42.520 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364805" tid="0" log_line="9" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[98-2] sql_error_code = 00000 time_ms = "2026-11-11 21:54:42.520 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364805" tid="0" log_line="9" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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-11T21:54:42+00:00 host app postgres.2471682 - [DATABASE] [98-2] sql_error_code = 00000 time_ms = "2026-11-11 21:54:42.520 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364805" tid="0" log_line="9" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "5e9e08ce-89a8-4b4f-98df-a7e8c640b077", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "18.210.124.108", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "9774fc44-de87-11a0-901a-560565b9d791", "x-request-start": "1794434083369" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[98-2] sql_error_code = 00000 time_ms = \"2026-11-11 21:54:42.520 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364805\" tid=\"0\" log_line=\"9\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" 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-11T21:54:42+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:06:26', STRUCTURED-DATA: '[DATABASE]', msg: '[103-1] sql_error_code = 00000 time_ms = "2026-11-11 22:06:26.188 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364842" tid="0" log_line="18" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3072.214 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[103-1] sql_error_code = 00000 time_ms = "2026-11-11 22:06:26.188 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364842" tid="0" log_line="18" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3072.214 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-11T22:06:26+00:00 host app postgres.2471682 - [DATABASE] [103-1] sql_error_code = 00000 time_ms = "2026-11-11 22:06:26.188 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364842" tid="0" log_line="18" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3072.214 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": "84c04b20-6788-447f-a725-b61407bc93b5", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.237.99.82", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "7d0c7bca-a3b0-5433-8e34-c0cf729d9c03", "x-request-start": "1794434787136" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[103-1] sql_error_code = 00000 time_ms = \"2026-11-11 22:06:26.188 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364842\" tid=\"0\" log_line=\"18\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3072.214 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-11T22:06:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:06:26', STRUCTURED-DATA: '[DATABASE]', msg: '[103-2] sql_error_code = 00000 time_ms = "2026-11-11 22:06:26.188 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364842" tid="0" log_line="19" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[103-2] sql_error_code = 00000 time_ms = "2026-11-11 22:06:26.188 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364842" tid="0" log_line="19" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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-11T22:06:26+00:00 host app postgres.2471682 - [DATABASE] [103-2] sql_error_code = 00000 time_ms = "2026-11-11 22:06:26.188 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364842" tid="0" log_line="19" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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": "84c04b20-6788-447f-a725-b61407bc93b5", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.237.99.82", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "7d0c7bca-a3b0-5433-8e34-c0cf729d9c03", "x-request-start": "1794434787136" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[103-2] sql_error_code = 00000 time_ms = \"2026-11-11 22:06:26.188 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364842\" tid=\"0\" log_line=\"19\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" 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-11T22:06:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:06:38', STRUCTURED-DATA: '[DATABASE]', msg: '[105-1] sql_error_code = 00000 time_ms = "2026-11-11 22:06:38.140 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364848" tid="0" log_line="22" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3059.154 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[105-1] sql_error_code = 00000 time_ms = "2026-11-11 22:06:38.140 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364848" tid="0" log_line="22" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3059.154 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-11T22:06:38+00:00 host app postgres.2471682 - [DATABASE] [105-1] sql_error_code = 00000 time_ms = "2026-11-11 22:06:38.140 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364848" tid="0" log_line="22" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3059.154 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": "abd4264b-5932-4b7a-9846-9cbad1283511", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.90.93.201", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "7ea12853-6a5f-ae9c-36ca-908d77bb89ca", "x-request-start": "1794434799167" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[105-1] sql_error_code = 00000 time_ms = \"2026-11-11 22:06:38.140 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364848\" tid=\"0\" log_line=\"22\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3059.154 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-11T22:06:38+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:06:38', STRUCTURED-DATA: '[DATABASE]', msg: '[105-2] sql_error_code = 00000 time_ms = "2026-11-11 22:06:38.140 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364848" tid="0" log_line="23" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[105-2] sql_error_code = 00000 time_ms = "2026-11-11 22:06:38.140 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364848" tid="0" log_line="23" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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-11T22:06:38+00:00 host app postgres.2471682 - [DATABASE] [105-2] sql_error_code = 00000 time_ms = "2026-11-11 22:06:38.140 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364848" tid="0" log_line="23" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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": "abd4264b-5932-4b7a-9846-9cbad1283511", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.90.93.201", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "7ea12853-6a5f-ae9c-36ca-908d77bb89ca", "x-request-start": "1794434799167" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[105-2] sql_error_code = 00000 time_ms = \"2026-11-11 22:06:38.140 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364848\" tid=\"0\" log_line=\"23\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" 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-11T22:06:38+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:08:15', STRUCTURED-DATA: '[DATABASE]', msg: '[107-1] sql_error_code = 00000 time_ms = "2026-11-11 22:08:15.792 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364855" tid="0" log_line="26" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3067.897 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[107-1] sql_error_code = 00000 time_ms = "2026-11-11 22:08:15.792 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364855" tid="0" log_line="26" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3067.897 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-11T22:08:15+00:00 host app postgres.2471682 - [DATABASE] [107-1] sql_error_code = 00000 time_ms = "2026-11-11 22:08:15.792 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364855" tid="0" log_line="26" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3067.897 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": "1778", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "addcf6a2-0f7f-4d27-9617-fdc087e693f4", "logplex-msg-count": "3", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.147.211.142", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "024ec9ea-ee2b-cf5f-8a97-d281378af952", "x-request-start": "1794434896297" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[107-1] sql_error_code = 00000 time_ms = \"2026-11-11 22:08:15.792 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364855\" tid=\"0\" log_line=\"26\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3067.897 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-11T22:08:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:08:15', STRUCTURED-DATA: '[DATABASE]', msg: '[107-2] sql_error_code = 00000 time_ms = "2026-11-11 22:08:15.792 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364855" tid="0" log_line="27" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[107-2] sql_error_code = 00000 time_ms = "2026-11-11 22:08:15.792 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364855" tid="0" log_line="27" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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-11T22:08:15+00:00 host app postgres.2471682 - [DATABASE] [107-2] sql_error_code = 00000 time_ms = "2026-11-11 22:08:15.792 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364855" tid="0" log_line="27" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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": "1778", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "addcf6a2-0f7f-4d27-9617-fdc087e693f4", "logplex-msg-count": "3", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.147.211.142", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "024ec9ea-ee2b-cf5f-8a97-d281378af952", "x-request-start": "1794434896297" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[107-2] sql_error_code = 00000 time_ms = \"2026-11-11 22:08:15.792 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364855\" tid=\"0\" log_line=\"27\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" 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-11T22:08:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:17:39', STRUCTURED-DATA: '[DATABASE]', msg: '[109-1] sql_error_code = 00000 time_ms = "2026-11-11 22:17:39.914 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364870" tid="0" log_line="30" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3115.531 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 22:17:39.914 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364870" tid="0" log_line="30" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3115.531 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-11T22:17:39+00:00 host app postgres.2471682 - [DATABASE] [109-1] sql_error_code = 00000 time_ms = "2026-11-11 22:17:39.914 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364870" tid="0" log_line="30" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3115.531 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": "bafb6111-e8fc-4acc-878e-4f9a2b874567", "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": "30f025bd-aa0d-b61b-0a2a-2622c2da3737", "x-request-start": "1794435461001" }, "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 22:17:39.914 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364870\" tid=\"0\" log_line=\"30\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3115.531 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-11T22:17:39+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:17:39', STRUCTURED-DATA: '[DATABASE]', msg: '[109-2] sql_error_code = 00000 time_ms = "2026-11-11 22:17:39.914 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364870" tid="0" log_line="31" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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 22:17:39.914 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364870" tid="0" log_line="31" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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-11T22:17:39+00:00 host app postgres.2471682 - [DATABASE] [109-2] sql_error_code = 00000 time_ms = "2026-11-11 22:17:39.914 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364870" tid="0" log_line="31" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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": "bafb6111-e8fc-4acc-878e-4f9a2b874567", "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": "30f025bd-aa0d-b61b-0a2a-2622c2da3737", "x-request-start": "1794435461001" }, "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 22:17:39.914 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364870\" tid=\"0\" log_line=\"31\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" 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-11T22:17:39+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:19:47', STRUCTURED-DATA: '[DATABASE]', msg: '[112-1] sql_error_code = 00000 time_ms = "2026-11-11 22:19:47.435 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364879" tid="0" log_line="36" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3068.750 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 22:19:47.435 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364879" tid="0" log_line="36" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3068.750 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-11T22:19:47+00:00 host app postgres.2471682 - [DATABASE] [112-1] sql_error_code = 00000 time_ms = "2026-11-11 22:19:47.435 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364879" tid="0" log_line="36" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3068.750 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": "10276799-6b08-438e-9e80-cbbd24e1b49a", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "100.24.76.186", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "85117a3c-da0f-b53f-0623-543fce56760d", "x-request-start": "1794435588381" }, "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 22:19:47.435 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364879\" tid=\"0\" log_line=\"36\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3068.750 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-11T22:19:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:19:47', STRUCTURED-DATA: '[DATABASE]', msg: '[112-2] sql_error_code = 00000 time_ms = "2026-11-11 22:19:47.435 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364879" tid="0" log_line="37" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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 22:19:47.435 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364879" tid="0" log_line="37" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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-11T22:19:47+00:00 host app postgres.2471682 - [DATABASE] [112-2] sql_error_code = 00000 time_ms = "2026-11-11 22:19:47.435 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364879" tid="0" log_line="37" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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": "10276799-6b08-438e-9e80-cbbd24e1b49a", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "100.24.76.186", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "85117a3c-da0f-b53f-0623-543fce56760d", "x-request-start": "1794435588381" }, "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 22:19:47.435 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364879\" tid=\"0\" log_line=\"37\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" 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-11T22:19:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:30:08', STRUCTURED-DATA: '[DATABASE]', msg: '[114-1] sql_error_code = 00000 time_ms = "2026-11-11 22:30:08.606 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364892" tid="0" log_line="40" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 8434.966 ms execute : select "streams"."id", "streams"."projection_retries", "projections"."updated_at" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "projections"."version" = $1 and "streams"."updated_at" < $2 and "streams"."head_delta_id" != "projections"."delta_id" and "streams"."projection_retries" <= $3 order by "user_updated_at" desc' escaped msg: '[114-1] sql_error_code = 00000 time_ms = "2026-11-11 22:30:08.606 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364892" tid="0" log_line="40" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 8434.966 ms execute : select "streams"."id", "streams"."projection_retries", "projections"."updated_at" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "projections"."version" = $1 and "streams"."updated_at" < $2 and "streams"."head_delta_id" != "projections"."delta_id" and "streams"."projection_retries" <= $3 order by "user_updated_at" desc' inputname: drain rawmsg: '<134>1 2026-11-11T22:30:08+00:00 host app postgres.2471682 - [DATABASE] [114-1] sql_error_code = 00000 time_ms = "2026-11-11 22:30:08.606 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364892" tid="0" log_line="40" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 8434.966 ms execute : select "streams"."id", "streams"."projection_retries", "projections"."updated_at" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "projections"."version" = $1 and "streams"."updated_at" < $2 and "streams"."head_delta_id" != "projections"."delta_id" and "streams"."projection_retries" <= $3 order by "user_updated_at" desc' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "2641", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "a2f6f74d-5ec1-4b8f-94be-dfcd74ef39fc", "logplex-msg-count": "4", "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": "808f0834-61fa-bd7e-d37f-fd020a7848bb", "x-request-start": "1794436209376" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[114-1] sql_error_code = 00000 time_ms = \"2026-11-11 22:30:08.606 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364892\" tid=\"0\" log_line=\"40\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 8434.966 ms execute : select \"streams\".\"id\", \"streams\".\"projection_retries\", \"projections\".\"updated_at\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"projections\".\"version\" = $1 and \"streams\".\"updated_at\" < $2 and \"streams\".\"head_delta_id\" != \"projections\".\"delta_id\" and \"streams\".\"projection_retries\" <= $3 order by \"user_updated_at\" desc", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T22:30:08+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:30:08', STRUCTURED-DATA: '[DATABASE]', msg: '[114-2] sql_error_code = 00000 time_ms = "2026-11-11 22:30:08.606 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364892" tid="0" log_line="41" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'oafv1', $2 = '2026-11-11 22:25:00.165+00', $3 = '3'' escaped msg: '[114-2] sql_error_code = 00000 time_ms = "2026-11-11 22:30:08.606 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364892" tid="0" log_line="41" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'oafv1', $2 = '2026-11-11 22:25:00.165+00', $3 = '3'' inputname: drain rawmsg: '<134>1 2026-11-11T22:30:08+00:00 host app postgres.2471682 - [DATABASE] [114-2] sql_error_code = 00000 time_ms = "2026-11-11 22:30:08.606 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364892" tid="0" log_line="41" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'oafv1', $2 = '2026-11-11 22:25:00.165+00', $3 = '3'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "2641", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "a2f6f74d-5ec1-4b8f-94be-dfcd74ef39fc", "logplex-msg-count": "4", "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": "808f0834-61fa-bd7e-d37f-fd020a7848bb", "x-request-start": "1794436209376" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[114-2] sql_error_code = 00000 time_ms = \"2026-11-11 22:30:08.606 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364892\" tid=\"0\" log_line=\"41\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'oafv1', $2 = '2026-11-11 22:25:00.165+00', $3 = '3'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T22:30:08+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:30:12', STRUCTURED-DATA: '[DATABASE]', msg: '[115-1] sql_error_code = 00000 time_ms = "2026-11-11 22:30:12.595 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364893" tid="0" log_line="42" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3980.820 ms execute : select "streams"."id", "streams"."external_id", "streams"."type", "streams"."projection_retries" from "streams" left outer join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."updated_at" < $1 and "projections"."id" is null and "streams"."projection_retries" <= $2' escaped msg: '[115-1] sql_error_code = 00000 time_ms = "2026-11-11 22:30:12.595 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364893" tid="0" log_line="42" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3980.820 ms execute : select "streams"."id", "streams"."external_id", "streams"."type", "streams"."projection_retries" from "streams" left outer join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."updated_at" < $1 and "projections"."id" is null and "streams"."projection_retries" <= $2' inputname: drain rawmsg: '<134>1 2026-11-11T22:30:12+00:00 host app postgres.2471682 - [DATABASE] [115-1] sql_error_code = 00000 time_ms = "2026-11-11 22:30:12.595 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364893" tid="0" log_line="42" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3980.820 ms execute : select "streams"."id", "streams"."external_id", "streams"."type", "streams"."projection_retries" from "streams" left outer join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."updated_at" < $1 and "projections"."id" is null and "streams"."projection_retries" <= $2' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1183", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "c698bc8b-c4cc-4d3c-9d36-d945e48403e3", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.227.75.243", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "617c59d8-8c6d-236c-2a1c-d26f73a4b2f3", "x-request-start": "1794436213370" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[115-1] sql_error_code = 00000 time_ms = \"2026-11-11 22:30:12.595 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364893\" tid=\"0\" log_line=\"42\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3980.820 ms execute : select \"streams\".\"id\", \"streams\".\"external_id\", \"streams\".\"type\", \"streams\".\"projection_retries\" from \"streams\" left outer join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"updated_at\" < $1 and \"projections\".\"id\" is null and \"streams\".\"projection_retries\" <= $2", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T22:30:12+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:30:12', STRUCTURED-DATA: '[DATABASE]', msg: '[115-2] sql_error_code = 00000 time_ms = "2026-11-11 22:30:12.595 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364893" tid="0" log_line="43" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = '2026-11-11 22:25:00.165+00', $2 = '3'' escaped msg: '[115-2] sql_error_code = 00000 time_ms = "2026-11-11 22:30:12.595 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364893" tid="0" log_line="43" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = '2026-11-11 22:25:00.165+00', $2 = '3'' inputname: drain rawmsg: '<134>1 2026-11-11T22:30:12+00:00 host app postgres.2471682 - [DATABASE] [115-2] sql_error_code = 00000 time_ms = "2026-11-11 22:30:12.595 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364893" tid="0" log_line="43" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = '2026-11-11 22:25:00.165+00', $2 = '3'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1183", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "c698bc8b-c4cc-4d3c-9d36-d945e48403e3", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.227.75.243", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "617c59d8-8c6d-236c-2a1c-d26f73a4b2f3", "x-request-start": "1794436213370" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[115-2] sql_error_code = 00000 time_ms = \"2026-11-11 22:30:12.595 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364893\" tid=\"0\" log_line=\"43\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = '2026-11-11 22:25:00.165+00', $2 = '3'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T22:30:12+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:40:57', STRUCTURED-DATA: '[DATABASE]', msg: '[119-1] sql_error_code = 00000 time_ms = "2026-11-11 22:40:57.850 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364907" tid="0" log_line="50" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3055.908 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 22:40:57.850 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364907" tid="0" log_line="50" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3055.908 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-11T22:40:57+00:00 host app postgres.2471682 - [DATABASE] [119-1] sql_error_code = 00000 time_ms = "2026-11-11 22:40:57.850 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364907" tid="0" log_line="50" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3055.908 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": "28ccccce-753f-4f20-a859-0344e4c871f6", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "44.198.3.167", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "4672562c-a7ed-7aea-2c4f-51c26308de66", "x-request-start": "1794436858643" }, "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 22:40:57.850 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364907\" tid=\"0\" log_line=\"50\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3055.908 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-11T22:40:57+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:40:57', STRUCTURED-DATA: '[DATABASE]', msg: '[119-2] sql_error_code = 00000 time_ms = "2026-11-11 22:40:57.850 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364907" tid="0" log_line="51" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[119-2] sql_error_code = 00000 time_ms = "2026-11-11 22:40:57.850 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364907" tid="0" log_line="51" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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-11T22:40:57+00:00 host app postgres.2471682 - [DATABASE] [119-2] sql_error_code = 00000 time_ms = "2026-11-11 22:40:57.850 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364907" tid="0" log_line="51" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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": "28ccccce-753f-4f20-a859-0344e4c871f6", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "44.198.3.167", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "4672562c-a7ed-7aea-2c4f-51c26308de66", "x-request-start": "1794436858643" }, "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 22:40:57.850 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364907\" tid=\"0\" log_line=\"51\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" 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-11T22:40:57+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:42:20', STRUCTURED-DATA: '[DATABASE]', msg: '[120-1] sql_error_code = 00000 time_ms = "2026-11-11 22:42:20.824 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364912" tid="0" log_line="52" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3081.833 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: '[120-1] sql_error_code = 00000 time_ms = "2026-11-11 22:42:20.824 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364912" tid="0" log_line="52" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3081.833 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-11T22:42:20+00:00 host app postgres.2471682 - [DATABASE] [120-1] sql_error_code = 00000 time_ms = "2026-11-11 22:42:20.824 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364912" tid="0" log_line="52" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3081.833 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": "8ec4cd2c-041f-400b-82a9-c90727ea22ba", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "35.174.132.118", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "8db0cc6a-dea2-1e0f-12ef-ed06d8592a76", "x-request-start": "1794436941620" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[120-1] sql_error_code = 00000 time_ms = \"2026-11-11 22:42:20.824 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364912\" tid=\"0\" log_line=\"52\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3081.833 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-11T22:42:20+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:42:20', STRUCTURED-DATA: '[DATABASE]', msg: '[120-2] sql_error_code = 00000 time_ms = "2026-11-11 22:42:20.824 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364912" tid="0" log_line="53" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[120-2] sql_error_code = 00000 time_ms = "2026-11-11 22:42:20.824 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364912" tid="0" log_line="53" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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-11T22:42:20+00:00 host app postgres.2471682 - [DATABASE] [120-2] sql_error_code = 00000 time_ms = "2026-11-11 22:42:20.824 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364912" tid="0" log_line="53" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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": "8ec4cd2c-041f-400b-82a9-c90727ea22ba", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "35.174.132.118", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "8db0cc6a-dea2-1e0f-12ef-ed06d8592a76", "x-request-start": "1794436941620" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[120-2] sql_error_code = 00000 time_ms = \"2026-11-11 22:42:20.824 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364912\" tid=\"0\" log_line=\"53\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" 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-11T22:42:20+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:42:28', STRUCTURED-DATA: '[DATABASE]', msg: '[121-1] sql_error_code = 00000 time_ms = "2026-11-11 22:42:28.613 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364915" tid="0" log_line="54" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3564.649 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 22:42:28.613 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364915" tid="0" log_line="54" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3564.649 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-11T22:42:28+00:00 host app postgres.2471682 - [DATABASE] [121-1] sql_error_code = 00000 time_ms = "2026-11-11 22:42:28.613 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364915" tid="0" log_line="54" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3564.649 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": "7cd999c3-a028-45d1-888e-41de1f98407c", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "18.232.255.149", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "0a6ac45b-2ca7-9c42-113e-19321423fa2a", "x-request-start": "1794436949402" }, "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 22:42:28.613 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364915\" tid=\"0\" log_line=\"54\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3564.649 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-11T22:42:28+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:42:28', STRUCTURED-DATA: '[DATABASE]', msg: '[121-2] sql_error_code = 00000 time_ms = "2026-11-11 22:42:28.613 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364915" tid="0" log_line="55" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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 22:42:28.613 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364915" tid="0" log_line="55" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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-11T22:42:28+00:00 host app postgres.2471682 - [DATABASE] [121-2] sql_error_code = 00000 time_ms = "2026-11-11 22:42:28.613 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364915" tid="0" log_line="55" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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": "7cd999c3-a028-45d1-888e-41de1f98407c", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "18.232.255.149", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "0a6ac45b-2ca7-9c42-113e-19321423fa2a", "x-request-start": "1794436949402" }, "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 22:42:28.613 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364915\" tid=\"0\" log_line=\"55\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" 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-11T22:42:28+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:45:43', STRUCTURED-DATA: '[DATABASE]', msg: '[122-1] sql_error_code = 00000 time_ms = "2026-11-11 22:45:43.535 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364921" tid="0" log_line="56" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2980.586 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: '[122-1] sql_error_code = 00000 time_ms = "2026-11-11 22:45:43.535 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364921" tid="0" log_line="56" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2980.586 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-11T22:45:43+00:00 host app postgres.2471682 - [DATABASE] [122-1] sql_error_code = 00000 time_ms = "2026-11-11 22:45:43.535 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364921" tid="0" log_line="56" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2980.586 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": "d6585d6d-6fea-4994-83a0-e4bb0c5f8662", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "35.174.132.118", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "2ee478d2-9c26-93ea-c377-93d5dcae6c4f", "x-request-start": "1794437144378" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[122-1] sql_error_code = 00000 time_ms = \"2026-11-11 22:45:43.535 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364921\" tid=\"0\" log_line=\"56\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 2980.586 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-11T22:45:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:45:43', STRUCTURED-DATA: '[DATABASE]', msg: '[122-2] sql_error_code = 00000 time_ms = "2026-11-11 22:45:43.535 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364921" tid="0" log_line="57" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[122-2] sql_error_code = 00000 time_ms = "2026-11-11 22:45:43.535 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364921" tid="0" log_line="57" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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-11T22:45:43+00:00 host app postgres.2471682 - [DATABASE] [122-2] sql_error_code = 00000 time_ms = "2026-11-11 22:45:43.535 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364921" tid="0" log_line="57" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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": "d6585d6d-6fea-4994-83a0-e4bb0c5f8662", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "35.174.132.118", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "2ee478d2-9c26-93ea-c377-93d5dcae6c4f", "x-request-start": "1794437144378" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[122-2] sql_error_code = 00000 time_ms = \"2026-11-11 22:45:43.535 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364921\" tid=\"0\" log_line=\"57\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" 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-11T22:45:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:55:48', STRUCTURED-DATA: '[DATABASE]', msg: '[123-1] sql_error_code = 00000 time_ms = "2026-11-11 22:55:48.265 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364930" tid="0" log_line="58" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3028.342 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 22:55:48.265 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364930" tid="0" log_line="58" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3028.342 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-11T22:55:48+00:00 host app postgres.2471682 - [DATABASE] [123-1] sql_error_code = 00000 time_ms = "2026-11-11 22:55:48.265 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364930" tid="0" log_line="58" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3028.342 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": "1bffe904-7ffc-4be2-864b-5c93e9c00e41", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.202.0.194", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "7ab74924-c9e9-03d3-315b-00e3edc316e9", "x-request-start": "1794437748765" }, "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 22:55:48.265 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364930\" tid=\"0\" log_line=\"58\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3028.342 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-11T22:55:48+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:55:48', STRUCTURED-DATA: '[DATABASE]', msg: '[123-2] sql_error_code = 00000 time_ms = "2026-11-11 22:55:48.265 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364930" tid="0" log_line="59" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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 22:55:48.265 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364930" tid="0" log_line="59" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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-11T22:55:48+00:00 host app postgres.2471682 - [DATABASE] [123-2] sql_error_code = 00000 time_ms = "2026-11-11 22:55:48.265 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364930" tid="0" log_line="59" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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": "1bffe904-7ffc-4be2-864b-5c93e9c00e41", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.202.0.194", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "7ab74924-c9e9-03d3-315b-00e3edc316e9", "x-request-start": "1794437748765" }, "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 22:55:48.265 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364930\" tid=\"0\" log_line=\"59\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" 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-11T22:55:48+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:57:00', STRUCTURED-DATA: '[DATABASE]', msg: '[124-1] sql_error_code = 00000 time_ms = "2026-11-11 22:57:00.215 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364933" tid="0" log_line="60" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3043.043 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: '[124-1] sql_error_code = 00000 time_ms = "2026-11-11 22:57:00.215 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364933" tid="0" log_line="60" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3043.043 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-11T22:57:00+00:00 host app postgres.2471682 - [DATABASE] [124-1] sql_error_code = 00000 time_ms = "2026-11-11 22:57:00.215 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364933" tid="0" log_line="60" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3043.043 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": "c8ccfceb-f155-43fc-b21c-ee330e239282", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.202.0.194", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "afe1b00b-8cf9-75f2-0faf-07ea3f985b76", "x-request-start": "1794437821153" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[124-1] sql_error_code = 00000 time_ms = \"2026-11-11 22:57:00.215 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364933\" tid=\"0\" log_line=\"60\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3043.043 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-11T22:57:00+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 22:57:00', STRUCTURED-DATA: '[DATABASE]', msg: '[124-2] sql_error_code = 00000 time_ms = "2026-11-11 22:57:00.215 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364933" tid="0" log_line="61" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[124-2] sql_error_code = 00000 time_ms = "2026-11-11 22:57:00.215 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364933" tid="0" log_line="61" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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-11T22:57:00+00:00 host app postgres.2471682 - [DATABASE] [124-2] sql_error_code = 00000 time_ms = "2026-11-11 22:57:00.215 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364933" tid="0" log_line="61" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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": "c8ccfceb-f155-43fc-b21c-ee330e239282", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.202.0.194", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "afe1b00b-8cf9-75f2-0faf-07ea3f985b76", "x-request-start": "1794437821153" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[124-2] sql_error_code = 00000 time_ms = \"2026-11-11 22:57:00.215 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364933\" tid=\"0\" log_line=\"61\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" 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-11T22:57:00+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 23:04:57', STRUCTURED-DATA: '[DATABASE]', msg: '[126-1] sql_error_code = 00000 time_ms = "2026-11-11 23:04:57.456 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364950" tid="0" log_line="64" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3018.351 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: '[126-1] sql_error_code = 00000 time_ms = "2026-11-11 23:04:57.456 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364950" tid="0" log_line="64" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3018.351 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T23:04:57+00:00 host app postgres.2471682 - [DATABASE] [126-1] sql_error_code = 00000 time_ms = "2026-11-11 23:04:57.456 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364950" tid="0" log_line="64" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3018.351 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": "00bdb654-84c4-4668-b80a-ef33e918eb3f", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.230.29.170", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "f4e4977f-99e8-6947-d277-ac1c190f63bb", "x-request-start": "1794438298250" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[126-1] sql_error_code = 00000 time_ms = \"2026-11-11 23:04:57.456 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364950\" tid=\"0\" log_line=\"64\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3018.351 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T23:04:57+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 23:04:57', STRUCTURED-DATA: '[DATABASE]', msg: '[126-2] sql_error_code = 00000 time_ms = "2026-11-11 23:04:57.456 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364950" tid="0" log_line="65" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[126-2] sql_error_code = 00000 time_ms = "2026-11-11 23:04:57.456 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364950" tid="0" log_line="65" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T23:04:57+00:00 host app postgres.2471682 - [DATABASE] [126-2] sql_error_code = 00000 time_ms = "2026-11-11 23:04:57.456 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364950" tid="0" log_line="65" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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": "00bdb654-84c4-4668-b80a-ef33e918eb3f", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.230.29.170", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "f4e4977f-99e8-6947-d277-ac1c190f63bb", "x-request-start": "1794438298250" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[126-2] sql_error_code = 00000 time_ms = \"2026-11-11 23:04:57.456 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364950\" tid=\"0\" log_line=\"65\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T23:04:57+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 23:08:22', STRUCTURED-DATA: '[DATABASE]', msg: '[129-1] sql_error_code = 00000 time_ms = "2026-11-11 23:08:22.688 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364961" tid="0" log_line="70" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3043.797 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: '[129-1] sql_error_code = 00000 time_ms = "2026-11-11 23:08:22.688 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364961" tid="0" log_line="70" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3043.797 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T23:08:22+00:00 host app postgres.2471682 - [DATABASE] [129-1] sql_error_code = 00000 time_ms = "2026-11-11 23:08:22.688 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364961" tid="0" log_line="70" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3043.797 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": "6e1dafe2-20e2-4980-924e-eabd159925e7", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.229.158.102", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "960887bf-0ce7-e736-07f9-df1b64c1932d", "x-request-start": "1794438503642" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[129-1] sql_error_code = 00000 time_ms = \"2026-11-11 23:08:22.688 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364961\" tid=\"0\" log_line=\"70\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3043.797 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T23:08:22+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 23:08:22', STRUCTURED-DATA: '[DATABASE]', msg: '[129-2] sql_error_code = 00000 time_ms = "2026-11-11 23:08:22.688 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364961" tid="0" log_line="71" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[129-2] sql_error_code = 00000 time_ms = "2026-11-11 23:08:22.688 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364961" tid="0" log_line="71" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T23:08:22+00:00 host app postgres.2471682 - [DATABASE] [129-2] sql_error_code = 00000 time_ms = "2026-11-11 23:08:22.688 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364961" tid="0" log_line="71" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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": "6e1dafe2-20e2-4980-924e-eabd159925e7", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.229.158.102", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "960887bf-0ce7-e736-07f9-df1b64c1932d", "x-request-start": "1794438503642" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[129-2] sql_error_code = 00000 time_ms = \"2026-11-11 23:08:22.688 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364961\" tid=\"0\" log_line=\"71\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T23:08:22+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 23:15:53', STRUCTURED-DATA: '[DATABASE]', msg: '[130-1] sql_error_code = 00000 time_ms = "2026-11-11 23:15:53.689 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364967" tid="0" log_line="72" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3432.511 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: '[130-1] sql_error_code = 00000 time_ms = "2026-11-11 23:15:53.689 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364967" tid="0" log_line="72" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3432.511 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T23:15:53+00:00 host app postgres.2471682 - [DATABASE] [130-1] sql_error_code = 00000 time_ms = "2026-11-11 23:15:53.689 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364967" tid="0" log_line="72" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3432.511 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": "1bdbb1fa-502d-4363-a4f3-bfbc116b3bab", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.202.178.126", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d5e8831e-e642-2d11-fe69-0725aa499fe2", "x-request-start": "1794438954503" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[130-1] sql_error_code = 00000 time_ms = \"2026-11-11 23:15:53.689 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364967\" tid=\"0\" log_line=\"72\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3432.511 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T23:15:53+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 23:15:53', STRUCTURED-DATA: '[DATABASE]', msg: '[130-2] sql_error_code = 00000 time_ms = "2026-11-11 23:15:53.689 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364967" tid="0" log_line="73" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[130-2] sql_error_code = 00000 time_ms = "2026-11-11 23:15:53.689 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364967" tid="0" log_line="73" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T23:15:53+00:00 host app postgres.2471682 - [DATABASE] [130-2] sql_error_code = 00000 time_ms = "2026-11-11 23:15:53.689 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364967" tid="0" log_line="73" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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": "1bdbb1fa-502d-4363-a4f3-bfbc116b3bab", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.202.178.126", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d5e8831e-e642-2d11-fe69-0725aa499fe2", "x-request-start": "1794438954503" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[130-2] sql_error_code = 00000 time_ms = \"2026-11-11 23:15:53.689 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364967\" tid=\"0\" log_line=\"73\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T23:15:53+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 23:15:59', STRUCTURED-DATA: '[DATABASE]', msg: '[131-1] sql_error_code = 00000 time_ms = "2026-11-11 23:15:59.994 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364970" tid="0" log_line="74" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3057.496 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 23:15:59.994 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364970" tid="0" log_line="74" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3057.496 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T23:15:59+00:00 host app postgres.2471682 - [DATABASE] [131-1] sql_error_code = 00000 time_ms = "2026-11-11 23:15:59.994 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364970" tid="0" log_line="74" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3057.496 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": "d5bd1df3-49b3-47c9-b3b5-61cdcf4501e5", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.213.39.67", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "305d208c-8c62-6a32-45d7-1e3b23af2eea", "x-request-start": "1794438960887" }, "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 23:15:59.994 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364970\" tid=\"0\" log_line=\"74\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3057.496 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T23:15:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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.2471682]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2471682', MSGID: '-', TIMESTAMP: 'Nov 11 23:15:59', STRUCTURED-DATA: '[DATABASE]', msg: '[131-2] sql_error_code = 00000 time_ms = "2026-11-11 23:15:59.994 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364970" tid="0" log_line="75" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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 23:15:59.994 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364970" tid="0" log_line="75" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T23:15:59+00:00 host app postgres.2471682 - [DATABASE] [131-2] sql_error_code = 00000 time_ms = "2026-11-11 23:15:59.994 UTC" pid="1121082" proc_start_time="2026-11-11 21:40:05 UTC" session_id="6af4e0b5.111b3a" vtid="25/364970" tid="0" log_line="75" database="ddvvgu681gm35p" connection_source="10.0.173.48(48296)" 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": "d5bd1df3-49b3-47c9-b3b5-61cdcf4501e5", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.213.39.67", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "305d208c-8c62-6a32-45d7-1e3b23af2eea", "x-request-start": "1794438960887" }, "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 23:15:59.994 UTC\" pid=\"1121082\" proc_start_time=\"2026-11-11 21:40:05 UTC\" session_id=\"6af4e0b5.111b3a\" vtid=\"25\/364970\" tid=\"0\" log_line=\"75\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.173.48(48296)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T23:15:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2471682", "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.2471682", "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" } $/: