Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:12:03', STRUCTURED-DATA: '[DATABASE]', msg: '[96-1] sql_error_code = 00000 time_ms = "2026-11-11 19:12:03.635 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850538" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3188.906 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 19:12:03.635 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850538" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3188.906 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T19:12:03+00:00 host app postgres.2443031 - [DATABASE] [96-1] sql_error_code = 00000 time_ms = "2026-11-11 19:12:03.635 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850538" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3188.906 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": "1370", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "ade77584-f060-4496-bb63-7cb4edf2b277", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.7.169.209", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "c18ebe22-5975-d712-d9ed-3ed419acf217", "x-request-start": "1794424324633" }, "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 19:12:03.635 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850538\" tid=\"0\" log_line=\"4\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3188.906 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:12:03+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:12:03', STRUCTURED-DATA: '[DATABASE]', msg: '[96-2] sql_error_code = 00000 time_ms = "2026-11-11 19:12:03.635 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850538" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" 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 19:12:03.635 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850538" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T19:12:03+00:00 host app postgres.2443031 - [DATABASE] [96-2] sql_error_code = 00000 time_ms = "2026-11-11 19:12:03.635 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850538" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" 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": "1370", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "ade77584-f060-4496-bb63-7cb4edf2b277", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.7.169.209", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "c18ebe22-5975-d712-d9ed-3ed419acf217", "x-request-start": "1794424324633" }, "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 19:12:03.635 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850538\" tid=\"0\" log_line=\"5\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:12:03+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:27:36', STRUCTURED-DATA: '[DATABASE]', msg: '[101-1] sql_error_code = 00000 time_ms = "2026-11-11 19:27:36.814 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850559" tid="0" log_line="14" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3020.449 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[101-1] sql_error_code = 00000 time_ms = "2026-11-11 19:27:36.814 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850559" tid="0" log_line="14" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3020.449 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T19:27:36+00:00 host app postgres.2443031 - [DATABASE] [101-1] sql_error_code = 00000 time_ms = "2026-11-11 19:27:36.814 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850559" tid="0" log_line="14" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3020.449 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "055f5510-beea-458f-93a5-79ebe8deb185", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.225.253.144", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "7186c497-2a03-64cc-f2e0-81b6c5a5cd76", "x-request-start": "1794425257640" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[101-1] sql_error_code = 00000 time_ms = \"2026-11-11 19:27:36.814 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850559\" tid=\"0\" log_line=\"14\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3020.449 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:27:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:27:36', STRUCTURED-DATA: '[DATABASE]', msg: '[101-2] sql_error_code = 00000 time_ms = "2026-11-11 19:27:36.814 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850559" tid="0" log_line="15" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[101-2] sql_error_code = 00000 time_ms = "2026-11-11 19:27:36.814 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850559" tid="0" log_line="15" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T19:27:36+00:00 host app postgres.2443031 - [DATABASE] [101-2] sql_error_code = 00000 time_ms = "2026-11-11 19:27:36.814 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850559" tid="0" log_line="15" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "055f5510-beea-458f-93a5-79ebe8deb185", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.225.253.144", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "7186c497-2a03-64cc-f2e0-81b6c5a5cd76", "x-request-start": "1794425257640" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[101-2] sql_error_code = 00000 time_ms = \"2026-11-11 19:27:36.814 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850559\" tid=\"0\" log_line=\"15\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:27:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:30:08', STRUCTURED-DATA: '[DATABASE]', msg: '[103-1] sql_error_code = 00000 time_ms = "2026-11-11 19:30:08.897 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850566" tid="0" log_line="18" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2773.497 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: '[103-1] sql_error_code = 00000 time_ms = "2026-11-11 19:30:08.897 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850566" tid="0" log_line="18" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2773.497 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-11T19:30:08+00:00 host app postgres.2443031 - [DATABASE] [103-1] sql_error_code = 00000 time_ms = "2026-11-11 19:30:08.897 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850566" tid="0" log_line="18" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 2773.497 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": "1181", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "88f80fa8-b44d-49a1-81e4-d99714d64a47", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.199.71.125", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "b8c49e20-cade-91e5-733b-f840c49e7c81", "x-request-start": "1794425409757" }, "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 19:30:08.897 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850566\" tid=\"0\" log_line=\"18\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 2773.497 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-11T19:30:08+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:30:08', STRUCTURED-DATA: '[DATABASE]', msg: '[103-2] sql_error_code = 00000 time_ms = "2026-11-11 19:30:08.897 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850566" tid="0" log_line="19" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = '2026-11-11 19:25:00.087+00', $2 = '3'' escaped msg: '[103-2] sql_error_code = 00000 time_ms = "2026-11-11 19:30:08.897 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850566" tid="0" log_line="19" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = '2026-11-11 19:25:00.087+00', $2 = '3'' inputname: drain rawmsg: '<134>1 2026-11-11T19:30:08+00:00 host app postgres.2443031 - [DATABASE] [103-2] sql_error_code = 00000 time_ms = "2026-11-11 19:30:08.897 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850566" tid="0" log_line="19" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = '2026-11-11 19:25:00.087+00', $2 = '3'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1181", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "88f80fa8-b44d-49a1-81e4-d99714d64a47", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.199.71.125", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "b8c49e20-cade-91e5-733b-f840c49e7c81", "x-request-start": "1794425409757" }, "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 19:30:08.897 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850566\" tid=\"0\" log_line=\"19\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = '2026-11-11 19:25:00.087+00', $2 = '3'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:30:08+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:34:54', STRUCTURED-DATA: '[DATABASE]', msg: '[105-1] sql_error_code = 00000 time_ms = "2026-11-11 19:34:54.851 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850574" tid="0" log_line="22" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3093.827 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 19:34:54.851 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850574" tid="0" log_line="22" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3093.827 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T19:34:54+00:00 host app postgres.2443031 - [DATABASE] [105-1] sql_error_code = 00000 time_ms = "2026-11-11 19:34:54.851 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850574" tid="0" log_line="22" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3093.827 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "ef08249a-0a07-44a8-ad81-67c0a807ab13", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.232.0.151", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "30fe5bcf-36e5-b4e2-771b-27b3676f72e9", "x-request-start": "1794425695619" }, "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 19:34:54.851 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850574\" tid=\"0\" log_line=\"22\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3093.827 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:34:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:34:54', STRUCTURED-DATA: '[DATABASE]', msg: '[105-2] sql_error_code = 00000 time_ms = "2026-11-11 19:34:54.851 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850574" tid="0" log_line="23" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" 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 19:34:54.851 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850574" tid="0" log_line="23" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T19:34:54+00:00 host app postgres.2443031 - [DATABASE] [105-2] sql_error_code = 00000 time_ms = "2026-11-11 19:34:54.851 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850574" tid="0" log_line="23" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "ef08249a-0a07-44a8-ad81-67c0a807ab13", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.232.0.151", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "30fe5bcf-36e5-b4e2-771b-27b3676f72e9", "x-request-start": "1794425695619" }, "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 19:34:54.851 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850574\" tid=\"0\" log_line=\"23\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:34:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:35:07', STRUCTURED-DATA: '[DATABASE]', msg: '[106-1] sql_error_code = 00000 time_ms = "2026-11-11 19:35:07.552 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850578" tid="0" log_line="24" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3432.560 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[106-1] sql_error_code = 00000 time_ms = "2026-11-11 19:35:07.552 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850578" tid="0" log_line="24" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3432.560 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T19:35:07+00:00 host app postgres.2443031 - [DATABASE] [106-1] sql_error_code = 00000 time_ms = "2026-11-11 19:35:07.552 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850578" tid="0" log_line="24" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3432.560 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "6ba40d10-385d-4d11-bfe7-9348f16e6951", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.194.95.17", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "fdb3fe69-9e50-c471-3658-ef5935a35c8b", "x-request-start": "1794425708251" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[106-1] sql_error_code = 00000 time_ms = \"2026-11-11 19:35:07.552 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850578\" tid=\"0\" log_line=\"24\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3432.560 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:35:07+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:35:07', STRUCTURED-DATA: '[DATABASE]', msg: '[106-2] sql_error_code = 00000 time_ms = "2026-11-11 19:35:07.552 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850578" tid="0" log_line="25" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[106-2] sql_error_code = 00000 time_ms = "2026-11-11 19:35:07.552 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850578" tid="0" log_line="25" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T19:35:07+00:00 host app postgres.2443031 - [DATABASE] [106-2] sql_error_code = 00000 time_ms = "2026-11-11 19:35:07.552 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850578" tid="0" log_line="25" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "6ba40d10-385d-4d11-bfe7-9348f16e6951", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.194.95.17", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "fdb3fe69-9e50-c471-3658-ef5935a35c8b", "x-request-start": "1794425708251" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[106-2] sql_error_code = 00000 time_ms = \"2026-11-11 19:35:07.552 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850578\" tid=\"0\" log_line=\"25\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:35:07+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:39:19', STRUCTURED-DATA: '[DATABASE]', msg: '[110-1] sql_error_code = 00000 time_ms = "2026-11-11 19:39:19.709 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850590" tid="0" log_line="32" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3096.984 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[110-1] sql_error_code = 00000 time_ms = "2026-11-11 19:39:19.709 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850590" tid="0" log_line="32" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3096.984 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T19:39:19+00:00 host app postgres.2443031 - [DATABASE] [110-1] sql_error_code = 00000 time_ms = "2026-11-11 19:39:19.709 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850590" tid="0" log_line="32" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3096.984 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "d5638233-754f-4ed9-8117-7149c0fb3c77", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.194.95.17", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "b476958b-7ffe-45fe-bac4-6bff2120919e", "x-request-start": "1794425960253" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[110-1] sql_error_code = 00000 time_ms = \"2026-11-11 19:39:19.709 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850590\" tid=\"0\" log_line=\"32\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3096.984 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:39:19+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:39:19', STRUCTURED-DATA: '[DATABASE]', msg: '[110-2] sql_error_code = 00000 time_ms = "2026-11-11 19:39:19.709 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850590" tid="0" log_line="33" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[110-2] sql_error_code = 00000 time_ms = "2026-11-11 19:39:19.709 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850590" tid="0" log_line="33" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T19:39:19+00:00 host app postgres.2443031 - [DATABASE] [110-2] sql_error_code = 00000 time_ms = "2026-11-11 19:39:19.709 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850590" tid="0" log_line="33" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "d5638233-754f-4ed9-8117-7149c0fb3c77", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.194.95.17", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "b476958b-7ffe-45fe-bac4-6bff2120919e", "x-request-start": "1794425960253" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[110-2] sql_error_code = 00000 time_ms = \"2026-11-11 19:39:19.709 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850590\" tid=\"0\" log_line=\"33\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:39:19+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:46:19', STRUCTURED-DATA: '[DATABASE]', msg: '[111-1] sql_error_code = 00000 time_ms = "2026-11-11 19:46:19.270 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850596" tid="0" log_line="34" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3392.393 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[111-1] sql_error_code = 00000 time_ms = "2026-11-11 19:46:19.270 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850596" tid="0" log_line="34" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3392.393 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T19:46:19+00:00 host app postgres.2443031 - [DATABASE] [111-1] sql_error_code = 00000 time_ms = "2026-11-11 19:46:19.270 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850596" tid="0" log_line="34" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3392.393 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "122c0877-ad6a-4a08-86b2-851328970513", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.144.58.241", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "ba692dd6-4c3c-7df8-b082-bdf99b0fd6bf", "x-request-start": "1794426379793" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[111-1] sql_error_code = 00000 time_ms = \"2026-11-11 19:46:19.270 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850596\" tid=\"0\" log_line=\"34\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3392.393 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:46:19+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:46:19', STRUCTURED-DATA: '[DATABASE]', msg: '[111-2] sql_error_code = 00000 time_ms = "2026-11-11 19:46:19.270 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850596" tid="0" log_line="35" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[111-2] sql_error_code = 00000 time_ms = "2026-11-11 19:46:19.270 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850596" tid="0" log_line="35" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T19:46:19+00:00 host app postgres.2443031 - [DATABASE] [111-2] sql_error_code = 00000 time_ms = "2026-11-11 19:46:19.270 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850596" tid="0" log_line="35" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "122c0877-ad6a-4a08-86b2-851328970513", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.144.58.241", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "ba692dd6-4c3c-7df8-b082-bdf99b0fd6bf", "x-request-start": "1794426379793" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[111-2] sql_error_code = 00000 time_ms = \"2026-11-11 19:46:19.270 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850596\" tid=\"0\" log_line=\"35\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:46:19+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:46:24', STRUCTURED-DATA: '[DATABASE]', msg: '[112-1] sql_error_code = 00000 time_ms = "2026-11-11 19:46:24.837 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850599" tid="0" log_line="36" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3127.978 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[112-1] sql_error_code = 00000 time_ms = "2026-11-11 19:46:24.837 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850599" tid="0" log_line="36" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3127.978 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T19:46:24+00:00 host app postgres.2443031 - [DATABASE] [112-1] sql_error_code = 00000 time_ms = "2026-11-11 19:46:24.837 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850599" tid="0" log_line="36" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3127.978 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "ba3fe03f-e354-49e2-bfe9-8016a989b2ea", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.72.79.163", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "12924084-7abb-0c78-2305-9b9b5ce34ea2", "x-request-start": "1794426385639" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[112-1] sql_error_code = 00000 time_ms = \"2026-11-11 19:46:24.837 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850599\" tid=\"0\" log_line=\"36\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3127.978 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:46:24+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:46:24', STRUCTURED-DATA: '[DATABASE]', msg: '[112-2] sql_error_code = 00000 time_ms = "2026-11-11 19:46:24.837 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850599" tid="0" log_line="37" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[112-2] sql_error_code = 00000 time_ms = "2026-11-11 19:46:24.837 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850599" tid="0" log_line="37" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T19:46:24+00:00 host app postgres.2443031 - [DATABASE] [112-2] sql_error_code = 00000 time_ms = "2026-11-11 19:46:24.837 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850599" tid="0" log_line="37" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "ba3fe03f-e354-49e2-bfe9-8016a989b2ea", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.72.79.163", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "12924084-7abb-0c78-2305-9b9b5ce34ea2", "x-request-start": "1794426385639" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[112-2] sql_error_code = 00000 time_ms = \"2026-11-11 19:46:24.837 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850599\" tid=\"0\" log_line=\"37\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:46:24+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:48:03', STRUCTURED-DATA: '[DATABASE]', msg: '[113-1] sql_error_code = 00000 time_ms = "2026-11-11 19:48:03.673 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850603" tid="0" log_line="38" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3084.524 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[113-1] sql_error_code = 00000 time_ms = "2026-11-11 19:48:03.673 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850603" tid="0" log_line="38" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3084.524 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T19:48:03+00:00 host app postgres.2443031 - [DATABASE] [113-1] sql_error_code = 00000 time_ms = "2026-11-11 19:48:03.673 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850603" tid="0" log_line="38" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3084.524 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "ad5b599a-38de-459b-8957-f12ef3c34bbf", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "44.214.169.96", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "1bb1ed40-f2e0-3efa-cb64-49d200b4cc1e", "x-request-start": "1794426484505" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[113-1] sql_error_code = 00000 time_ms = \"2026-11-11 19:48:03.673 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850603\" tid=\"0\" log_line=\"38\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3084.524 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:48:03+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:48:03', STRUCTURED-DATA: '[DATABASE]', msg: '[113-2] sql_error_code = 00000 time_ms = "2026-11-11 19:48:03.673 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850603" tid="0" log_line="39" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[113-2] sql_error_code = 00000 time_ms = "2026-11-11 19:48:03.673 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850603" tid="0" log_line="39" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T19:48:03+00:00 host app postgres.2443031 - [DATABASE] [113-2] sql_error_code = 00000 time_ms = "2026-11-11 19:48:03.673 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850603" tid="0" log_line="39" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "ad5b599a-38de-459b-8957-f12ef3c34bbf", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "44.214.169.96", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "1bb1ed40-f2e0-3efa-cb64-49d200b4cc1e", "x-request-start": "1794426484505" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[113-2] sql_error_code = 00000 time_ms = \"2026-11-11 19:48:03.673 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850603\" tid=\"0\" log_line=\"39\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:48:03+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:49:37', STRUCTURED-DATA: '[DATABASE]', msg: '[114-1] sql_error_code = 00000 time_ms = "2026-11-11 19:49:37.192 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850606" tid="0" log_line="40" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 4616.983 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[114-1] sql_error_code = 00000 time_ms = "2026-11-11 19:49:37.192 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850606" tid="0" log_line="40" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 4616.983 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T19:49:37+00:00 host app postgres.2443031 - [DATABASE] [114-1] sql_error_code = 00000 time_ms = "2026-11-11 19:49:37.192 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850606" tid="0" log_line="40" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 4616.983 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "ca5471bb-e3ed-432f-a2f7-90eba1ae9840", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.226.19.197", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "e8cc695c-ec4b-7035-a583-085d07e42769", "x-request-start": "1794426578001" }, "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 19:49:37.192 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850606\" tid=\"0\" log_line=\"40\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 4616.983 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:49:37+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:49:37', STRUCTURED-DATA: '[DATABASE]', msg: '[114-2] sql_error_code = 00000 time_ms = "2026-11-11 19:49:37.192 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850606" tid="0" log_line="41" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[114-2] sql_error_code = 00000 time_ms = "2026-11-11 19:49:37.192 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850606" tid="0" log_line="41" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T19:49:37+00:00 host app postgres.2443031 - [DATABASE] [114-2] sql_error_code = 00000 time_ms = "2026-11-11 19:49:37.192 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850606" tid="0" log_line="41" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "ca5471bb-e3ed-432f-a2f7-90eba1ae9840", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.226.19.197", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "e8cc695c-ec4b-7035-a583-085d07e42769", "x-request-start": "1794426578001" }, "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 19:49:37.192 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850606\" tid=\"0\" log_line=\"41\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:49:37+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:58:15', STRUCTURED-DATA: '[DATABASE]', msg: '[116-1] sql_error_code = 00000 time_ms = "2026-11-11 19:58:15.286 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850616" tid="0" log_line="44" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3052.923 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[116-1] sql_error_code = 00000 time_ms = "2026-11-11 19:58:15.286 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850616" tid="0" log_line="44" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3052.923 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T19:58:15+00:00 host app postgres.2443031 - [DATABASE] [116-1] sql_error_code = 00000 time_ms = "2026-11-11 19:58:15.286 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850616" tid="0" log_line="44" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3052.923 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "718c69fb-7ca7-494a-9da2-f795aca63c36", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.147.88.38", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "b5296ee0-a2e6-4041-ab25-7f000a640f0e", "x-request-start": "1794427096137" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[116-1] sql_error_code = 00000 time_ms = \"2026-11-11 19:58:15.286 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850616\" tid=\"0\" log_line=\"44\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3052.923 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:58:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:58:15', STRUCTURED-DATA: '[DATABASE]', msg: '[116-2] sql_error_code = 00000 time_ms = "2026-11-11 19:58:15.286 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850616" tid="0" log_line="45" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[116-2] sql_error_code = 00000 time_ms = "2026-11-11 19:58:15.286 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850616" tid="0" log_line="45" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T19:58:15+00:00 host app postgres.2443031 - [DATABASE] [116-2] sql_error_code = 00000 time_ms = "2026-11-11 19:58:15.286 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850616" tid="0" log_line="45" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "718c69fb-7ca7-494a-9da2-f795aca63c36", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.147.88.38", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "b5296ee0-a2e6-4041-ab25-7f000a640f0e", "x-request-start": "1794427096137" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[116-2] sql_error_code = 00000 time_ms = \"2026-11-11 19:58:15.286 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850616\" tid=\"0\" log_line=\"45\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:58:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:59:28', STRUCTURED-DATA: '[DATABASE]', msg: '[117-1] sql_error_code = 00000 time_ms = "2026-11-11 19:59:28.944 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850619" tid="0" log_line="46" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3045.160 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[117-1] sql_error_code = 00000 time_ms = "2026-11-11 19:59:28.944 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850619" tid="0" log_line="46" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3045.160 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T19:59:28+00:00 host app postgres.2443031 - [DATABASE] [117-1] sql_error_code = 00000 time_ms = "2026-11-11 19:59:28.944 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850619" tid="0" log_line="46" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3045.160 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "8f3e1079-91ea-48b1-94ff-8b91bc00a665", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "44.195.145.39", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "f8ffbce1-4863-0ce9-1fca-190f705e4a22", "x-request-start": "1794427169880" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[117-1] sql_error_code = 00000 time_ms = \"2026-11-11 19:59:28.944 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850619\" tid=\"0\" log_line=\"46\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3045.160 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:59:28+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:59:28', STRUCTURED-DATA: '[DATABASE]', msg: '[117-2] sql_error_code = 00000 time_ms = "2026-11-11 19:59:28.944 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850619" tid="0" log_line="47" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[117-2] sql_error_code = 00000 time_ms = "2026-11-11 19:59:28.944 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850619" tid="0" log_line="47" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T19:59:28+00:00 host app postgres.2443031 - [DATABASE] [117-2] sql_error_code = 00000 time_ms = "2026-11-11 19:59:28.944 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850619" tid="0" log_line="47" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "8f3e1079-91ea-48b1-94ff-8b91bc00a665", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "44.195.145.39", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "f8ffbce1-4863-0ce9-1fca-190f705e4a22", "x-request-start": "1794427169880" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[117-2] sql_error_code = 00000 time_ms = \"2026-11-11 19:59:28.944 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850619\" tid=\"0\" log_line=\"47\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:59:28+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:59:36', STRUCTURED-DATA: '[DATABASE]', msg: '[118-1] sql_error_code = 00000 time_ms = "2026-11-11 19:59:36.643 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850622" tid="0" log_line="48" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3077.330 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: '[118-1] sql_error_code = 00000 time_ms = "2026-11-11 19:59:36.643 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850622" tid="0" log_line="48" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3077.330 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T19:59:36+00:00 host app postgres.2443031 - [DATABASE] [118-1] sql_error_code = 00000 time_ms = "2026-11-11 19:59:36.643 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850622" tid="0" log_line="48" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3077.330 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "35e4ee1d-7c4a-4325-a302-2f1561f4d4d6", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.147.88.38", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "b37b8273-a9d2-b19a-d94e-0dc3dbefe051", "x-request-start": "1794427177636" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[118-1] sql_error_code = 00000 time_ms = \"2026-11-11 19:59:36.643 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850622\" tid=\"0\" log_line=\"48\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3077.330 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:59:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 19:59:36', STRUCTURED-DATA: '[DATABASE]', msg: '[118-2] sql_error_code = 00000 time_ms = "2026-11-11 19:59:36.643 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850622" tid="0" log_line="49" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[118-2] sql_error_code = 00000 time_ms = "2026-11-11 19:59:36.643 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850622" tid="0" log_line="49" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T19:59:36+00:00 host app postgres.2443031 - [DATABASE] [118-2] sql_error_code = 00000 time_ms = "2026-11-11 19:59:36.643 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850622" tid="0" log_line="49" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "35e4ee1d-7c4a-4325-a302-2f1561f4d4d6", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "54.147.88.38", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "b37b8273-a9d2-b19a-d94e-0dc3dbefe051", "x-request-start": "1794427177636" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[118-2] sql_error_code = 00000 time_ms = \"2026-11-11 19:59:36.643 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850622\" tid=\"0\" log_line=\"49\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T19:59:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:00:49', STRUCTURED-DATA: '[DATABASE]', msg: '[119-1] sql_error_code = 00000 time_ms = "2026-11-11 20:00:49.877 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850641" tid="0" log_line="50" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3058.889 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[119-1] sql_error_code = 00000 time_ms = "2026-11-11 20:00:49.877 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850641" tid="0" log_line="50" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3058.889 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T20:00:49+00:00 host app postgres.2443031 - [DATABASE] [119-1] sql_error_code = 00000 time_ms = "2026-11-11 20:00:49.877 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850641" tid="0" log_line="50" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3058.889 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "389aca9c-7994-42af-8d36-69d55d7339b6", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "44.214.169.96", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "c840957b-1fc7-2239-2a6f-3e6027756a80", "x-request-start": "1794427250874" }, "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 20:00:49.877 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850641\" tid=\"0\" log_line=\"50\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3058.889 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:00:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:00:49', STRUCTURED-DATA: '[DATABASE]', msg: '[119-2] sql_error_code = 00000 time_ms = "2026-11-11 20:00:49.877 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850641" tid="0" log_line="51" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" 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 20:00:49.877 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850641" tid="0" log_line="51" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T20:00:49+00:00 host app postgres.2443031 - [DATABASE] [119-2] sql_error_code = 00000 time_ms = "2026-11-11 20:00:49.877 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850641" tid="0" log_line="51" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "389aca9c-7994-42af-8d36-69d55d7339b6", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "44.214.169.96", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "c840957b-1fc7-2239-2a6f-3e6027756a80", "x-request-start": "1794427250874" }, "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 20:00:49.877 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850641\" tid=\"0\" log_line=\"51\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:00:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:09:44', STRUCTURED-DATA: '[DATABASE]', msg: '[121-1] sql_error_code = 00000 time_ms = "2026-11-11 20:09:44.135 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850649" tid="0" log_line="54" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3048.230 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 20:09:44.135 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850649" tid="0" log_line="54" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3048.230 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T20:09:44+00:00 host app postgres.2443031 - [DATABASE] [121-1] sql_error_code = 00000 time_ms = "2026-11-11 20:09:44.135 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850649" tid="0" log_line="54" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3048.230 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "fbe39994-459f-4e4b-9cf1-5e9c72e6f3d3", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.203.149.166", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "4389bf0a-8839-2a25-940e-2252b686ab40", "x-request-start": "1794427785132" }, "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 20:09:44.135 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850649\" tid=\"0\" log_line=\"54\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3048.230 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:09:44+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:09:44', STRUCTURED-DATA: '[DATABASE]', msg: '[121-2] sql_error_code = 00000 time_ms = "2026-11-11 20:09:44.135 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850649" tid="0" log_line="55" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" 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 20:09:44.135 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850649" tid="0" log_line="55" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T20:09:44+00:00 host app postgres.2443031 - [DATABASE] [121-2] sql_error_code = 00000 time_ms = "2026-11-11 20:09:44.135 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850649" tid="0" log_line="55" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "fbe39994-459f-4e4b-9cf1-5e9c72e6f3d3", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.203.149.166", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "4389bf0a-8839-2a25-940e-2252b686ab40", "x-request-start": "1794427785132" }, "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 20:09:44.135 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850649\" tid=\"0\" log_line=\"55\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:09:44+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:11:59', STRUCTURED-DATA: '[DATABASE]', msg: '[123-1] sql_error_code = 00000 time_ms = "2026-11-11 20:11:59.081 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850655" tid="0" log_line="58" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3087.011 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 20:11:59.081 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850655" tid="0" log_line="58" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3087.011 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T20:11:59+00:00 host app postgres.2443031 - [DATABASE] [123-1] sql_error_code = 00000 time_ms = "2026-11-11 20:11:59.081 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850655" tid="0" log_line="58" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3087.011 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "ff180efa-cf2e-46ef-9fd7-58299959a0be", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.236.222.146", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "812097c4-d8e1-d72a-d2ce-561b01f6f78e", "x-request-start": "1794427919888" }, "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 20:11:59.081 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850655\" tid=\"0\" log_line=\"58\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3087.011 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:11:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:11:59', STRUCTURED-DATA: '[DATABASE]', msg: '[123-2] sql_error_code = 00000 time_ms = "2026-11-11 20:11:59.081 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850655" tid="0" log_line="59" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" 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 20:11:59.081 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850655" tid="0" log_line="59" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T20:11:59+00:00 host app postgres.2443031 - [DATABASE] [123-2] sql_error_code = 00000 time_ms = "2026-11-11 20:11:59.081 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850655" tid="0" log_line="59" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "ff180efa-cf2e-46ef-9fd7-58299959a0be", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.236.222.146", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "812097c4-d8e1-d72a-d2ce-561b01f6f78e", "x-request-start": "1794427919888" }, "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 20:11:59.081 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850655\" tid=\"0\" log_line=\"59\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:11:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:23:42', STRUCTURED-DATA: '[DATABASE]', msg: '[125-1] sql_error_code = 00000 time_ms = "2026-11-11 20:23:42.148 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850669" tid="0" log_line="62" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3164.135 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[125-1] sql_error_code = 00000 time_ms = "2026-11-11 20:23:42.148 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850669" tid="0" log_line="62" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3164.135 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T20:23:42+00:00 host app postgres.2443031 - [DATABASE] [125-1] sql_error_code = 00000 time_ms = "2026-11-11 20:23:42.148 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850669" tid="0" log_line="62" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3164.135 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "33af9cf7-363f-4698-89a5-47ebcdf85616", "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": "977257c1-e06b-d91c-2a7b-9ac576577fa9", "x-request-start": "1794428623002" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[125-1] sql_error_code = 00000 time_ms = \"2026-11-11 20:23:42.148 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850669\" tid=\"0\" log_line=\"62\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3164.135 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:23:42+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:23:42', STRUCTURED-DATA: '[DATABASE]', msg: '[125-2] sql_error_code = 00000 time_ms = "2026-11-11 20:23:42.148 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850669" tid="0" log_line="63" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[125-2] sql_error_code = 00000 time_ms = "2026-11-11 20:23:42.148 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850669" tid="0" log_line="63" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T20:23:42+00:00 host app postgres.2443031 - [DATABASE] [125-2] sql_error_code = 00000 time_ms = "2026-11-11 20:23:42.148 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850669" tid="0" log_line="63" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "33af9cf7-363f-4698-89a5-47ebcdf85616", "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": "977257c1-e06b-d91c-2a7b-9ac576577fa9", "x-request-start": "1794428623002" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[125-2] sql_error_code = 00000 time_ms = \"2026-11-11 20:23:42.148 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850669\" tid=\"0\" log_line=\"63\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:23:42+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:25:49', STRUCTURED-DATA: '[DATABASE]', msg: '[126-1] sql_error_code = 00000 time_ms = "2026-11-11 20:25:49.364 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850674" tid="0" log_line="64" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3457.878 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 20:25:49.364 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850674" tid="0" log_line="64" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3457.878 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T20:25:49+00:00 host app postgres.2443031 - [DATABASE] [126-1] sql_error_code = 00000 time_ms = "2026-11-11 20:25:49.364 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850674" tid="0" log_line="64" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3457.878 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "5eacdfbc-6f88-42ac-8d73-6dd1bd118a03", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.55.19.186", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "17bb7856-f1d5-1d10-8ab9-4532f110ea2e", "x-request-start": "1794428750131" }, "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 20:25:49.364 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850674\" tid=\"0\" log_line=\"64\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3457.878 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:25:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:25:49', STRUCTURED-DATA: '[DATABASE]', msg: '[126-2] sql_error_code = 00000 time_ms = "2026-11-11 20:25:49.364 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850674" tid="0" log_line="65" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" 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 20:25:49.364 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850674" tid="0" log_line="65" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T20:25:49+00:00 host app postgres.2443031 - [DATABASE] [126-2] sql_error_code = 00000 time_ms = "2026-11-11 20:25:49.364 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850674" tid="0" log_line="65" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "5eacdfbc-6f88-42ac-8d73-6dd1bd118a03", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.55.19.186", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "17bb7856-f1d5-1d10-8ab9-4532f110ea2e", "x-request-start": "1794428750131" }, "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 20:25:49.364 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850674\" tid=\"0\" log_line=\"65\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:25:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:32:50', STRUCTURED-DATA: '[DATABASE]', msg: '[127-1] sql_error_code = 00000 time_ms = "2026-11-11 20:32:50.938 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850681" tid="0" log_line="66" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3270.671 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[127-1] sql_error_code = 00000 time_ms = "2026-11-11 20:32:50.938 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850681" tid="0" log_line="66" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3270.671 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T20:32:50+00:00 host app postgres.2443031 - [DATABASE] [127-1] sql_error_code = 00000 time_ms = "2026-11-11 20:32:50.938 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850681" tid="0" log_line="66" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3270.671 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "a477082a-b166-4aec-9cc5-0ae7fb310046", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.199.71.125", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "864d29e0-5474-915c-240e-be8f34882d9a", "x-request-start": "1794429171760" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[127-1] sql_error_code = 00000 time_ms = \"2026-11-11 20:32:50.938 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850681\" tid=\"0\" log_line=\"66\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3270.671 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:32:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:32:50', STRUCTURED-DATA: '[DATABASE]', msg: '[127-2] sql_error_code = 00000 time_ms = "2026-11-11 20:32:50.938 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850681" tid="0" log_line="67" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[127-2] sql_error_code = 00000 time_ms = "2026-11-11 20:32:50.938 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850681" tid="0" log_line="67" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T20:32:50+00:00 host app postgres.2443031 - [DATABASE] [127-2] sql_error_code = 00000 time_ms = "2026-11-11 20:32:50.938 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850681" tid="0" log_line="67" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "a477082a-b166-4aec-9cc5-0ae7fb310046", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.199.71.125", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "864d29e0-5474-915c-240e-be8f34882d9a", "x-request-start": "1794429171760" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[127-2] sql_error_code = 00000 time_ms = \"2026-11-11 20:32:50.938 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850681\" tid=\"0\" log_line=\"67\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:32:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:33:47', STRUCTURED-DATA: '[DATABASE]', msg: '[128-1] sql_error_code = 00000 time_ms = "2026-11-11 20:33:47.365 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850684" tid="0" log_line="68" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3458.875 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[128-1] sql_error_code = 00000 time_ms = "2026-11-11 20:33:47.365 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850684" tid="0" log_line="68" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3458.875 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T20:33:47+00:00 host app postgres.2443031 - [DATABASE] [128-1] sql_error_code = 00000 time_ms = "2026-11-11 20:33:47.365 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850684" tid="0" log_line="68" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3458.875 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "660a29a9-a427-4b94-9019-0fd3a0645158", "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": "b0d3e537-b05a-1831-9191-e0975f919730", "x-request-start": "1794429228147" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[128-1] sql_error_code = 00000 time_ms = \"2026-11-11 20:33:47.365 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850684\" tid=\"0\" log_line=\"68\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3458.875 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:33:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:33:47', STRUCTURED-DATA: '[DATABASE]', msg: '[128-2] sql_error_code = 00000 time_ms = "2026-11-11 20:33:47.365 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850684" tid="0" log_line="69" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[128-2] sql_error_code = 00000 time_ms = "2026-11-11 20:33:47.365 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850684" tid="0" log_line="69" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T20:33:47+00:00 host app postgres.2443031 - [DATABASE] [128-2] sql_error_code = 00000 time_ms = "2026-11-11 20:33:47.365 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850684" tid="0" log_line="69" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "660a29a9-a427-4b94-9019-0fd3a0645158", "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": "b0d3e537-b05a-1831-9191-e0975f919730", "x-request-start": "1794429228147" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[128-2] sql_error_code = 00000 time_ms = \"2026-11-11 20:33:47.365 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850684\" tid=\"0\" log_line=\"69\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:33:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:36:50', STRUCTURED-DATA: '[DATABASE]', msg: '[130-1] sql_error_code = 00000 time_ms = "2026-11-11 20:36:50.068 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850690" tid="0" log_line="72" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3079.785 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 20:36:50.068 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850690" tid="0" log_line="72" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3079.785 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T20:36:50+00:00 host app postgres.2443031 - [DATABASE] [130-1] sql_error_code = 00000 time_ms = "2026-11-11 20:36:50.068 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850690" tid="0" log_line="72" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3079.785 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "c9b607da-ceed-40a2-8970-9b1a9dd47d49", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.2.123.73", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d904c4fb-e459-4b3d-ec7b-9fd0dfa286bb", "x-request-start": "1794429410887" }, "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 20:36:50.068 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850690\" tid=\"0\" log_line=\"72\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3079.785 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:36:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:36:50', STRUCTURED-DATA: '[DATABASE]', msg: '[130-2] sql_error_code = 00000 time_ms = "2026-11-11 20:36:50.068 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850690" tid="0" log_line="73" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" 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 20:36:50.068 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850690" tid="0" log_line="73" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T20:36:50+00:00 host app postgres.2443031 - [DATABASE] [130-2] sql_error_code = 00000 time_ms = "2026-11-11 20:36:50.068 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850690" tid="0" log_line="73" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "c9b607da-ceed-40a2-8970-9b1a9dd47d49", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.2.123.73", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d904c4fb-e459-4b3d-ec7b-9fd0dfa286bb", "x-request-start": "1794429410887" }, "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 20:36:50.068 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850690\" tid=\"0\" log_line=\"73\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:36:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:45:07', STRUCTURED-DATA: '[DATABASE]', msg: '[132-1] sql_error_code = 00000 time_ms = "2026-11-11 20:45:07.942 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850700" tid="0" log_line="76" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3994.696 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[132-1] sql_error_code = 00000 time_ms = "2026-11-11 20:45:07.942 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850700" tid="0" log_line="76" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3994.696 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T20:45:07+00:00 host app postgres.2443031 - [DATABASE] [132-1] sql_error_code = 00000 time_ms = "2026-11-11 20:45:07.942 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850700" tid="0" log_line="76" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3994.696 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "25a981ef-01f1-48ec-a4c3-a402572505c3", "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": "b409588c-cb85-844c-1539-1226e83d2855", "x-request-start": "1794429908752" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[132-1] sql_error_code = 00000 time_ms = \"2026-11-11 20:45:07.942 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850700\" tid=\"0\" log_line=\"76\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3994.696 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:45:07+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:45:07', STRUCTURED-DATA: '[DATABASE]', msg: '[132-2] sql_error_code = 00000 time_ms = "2026-11-11 20:45:07.942 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850700" tid="0" log_line="77" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[132-2] sql_error_code = 00000 time_ms = "2026-11-11 20:45:07.942 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850700" tid="0" log_line="77" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T20:45:07+00:00 host app postgres.2443031 - [DATABASE] [132-2] sql_error_code = 00000 time_ms = "2026-11-11 20:45:07.942 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850700" tid="0" log_line="77" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "25a981ef-01f1-48ec-a4c3-a402572505c3", "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": "b409588c-cb85-844c-1539-1226e83d2855", "x-request-start": "1794429908752" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[132-2] sql_error_code = 00000 time_ms = \"2026-11-11 20:45:07.942 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850700\" tid=\"0\" log_line=\"77\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:45:07+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:46:24', STRUCTURED-DATA: '[DATABASE]', msg: '[133-1] sql_error_code = 00000 time_ms = "2026-11-11 20:46:24.133 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850703" tid="0" log_line="78" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3020.018 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: '[133-1] sql_error_code = 00000 time_ms = "2026-11-11 20:46:24.133 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850703" tid="0" log_line="78" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3020.018 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T20:46:24+00:00 host app postgres.2443031 - [DATABASE] [133-1] sql_error_code = 00000 time_ms = "2026-11-11 20:46:24.133 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850703" tid="0" log_line="78" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3020.018 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "0381842b-c8de-41e0-9677-3dae23554224", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.7.169.209", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d778dc61-6f12-467d-d331-37b08960eae2", "x-request-start": "1794429985124" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[133-1] sql_error_code = 00000 time_ms = \"2026-11-11 20:46:24.133 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850703\" tid=\"0\" log_line=\"78\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3020.018 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:46:24+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:46:24', STRUCTURED-DATA: '[DATABASE]', msg: '[133-2] sql_error_code = 00000 time_ms = "2026-11-11 20:46:24.133 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850703" tid="0" log_line="79" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[133-2] sql_error_code = 00000 time_ms = "2026-11-11 20:46:24.133 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850703" tid="0" log_line="79" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T20:46:24+00:00 host app postgres.2443031 - [DATABASE] [133-2] sql_error_code = 00000 time_ms = "2026-11-11 20:46:24.133 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850703" tid="0" log_line="79" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "0381842b-c8de-41e0-9677-3dae23554224", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.7.169.209", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d778dc61-6f12-467d-d331-37b08960eae2", "x-request-start": "1794429985124" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[133-2] sql_error_code = 00000 time_ms = \"2026-11-11 20:46:24.133 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850703\" tid=\"0\" log_line=\"79\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:46:24+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:46:32', STRUCTURED-DATA: '[DATABASE]', msg: '[134-1] sql_error_code = 00000 time_ms = "2026-11-11 20:46:32.494 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850706" tid="0" log_line="80" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3775.961 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[134-1] sql_error_code = 00000 time_ms = "2026-11-11 20:46:32.494 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850706" tid="0" log_line="80" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3775.961 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T20:46:32+00:00 host app postgres.2443031 - [DATABASE] [134-1] sql_error_code = 00000 time_ms = "2026-11-11 20:46:32.494 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850706" tid="0" log_line="80" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3775.961 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "b8c6f162-f2df-4f09-9db4-344abf8da743", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.238.100.87", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "56200c2e-c2e4-cef5-e9eb-6aa48e8cb028", "x-request-start": "1794429993394" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[134-1] sql_error_code = 00000 time_ms = \"2026-11-11 20:46:32.494 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850706\" tid=\"0\" log_line=\"80\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3775.961 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:46:32+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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.2443031]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2443031', MSGID: '-', TIMESTAMP: 'Nov 11 20:46:32', STRUCTURED-DATA: '[DATABASE]', msg: '[134-2] sql_error_code = 00000 time_ms = "2026-11-11 20:46:32.494 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850706" tid="0" log_line="81" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[134-2] sql_error_code = 00000 time_ms = "2026-11-11 20:46:32.494 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850706" tid="0" log_line="81" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T20:46:32+00:00 host app postgres.2443031 - [DATABASE] [134-2] sql_error_code = 00000 time_ms = "2026-11-11 20:46:32.494 UTC" pid="1118026" proc_start_time="2026-11-11 19:10:06 UTC" session_id="6af4bd8e.110f4a" vtid="6/850706" tid="0" log_line="81" database="ddvvgu681gm35p" connection_source="10.0.172.89(34416)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1374", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "b8c6f162-f2df-4f09-9db4-344abf8da743", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.238.100.87", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "56200c2e-c2e4-cef5-e9eb-6aa48e8cb028", "x-request-start": "1794429993394" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[134-2] sql_error_code = 00000 time_ms = \"2026-11-11 20:46:32.494 UTC\" pid=\"1118026\" proc_start_time=\"2026-11-11 19:10:06 UTC\" session_id=\"6af4bd8e.110f4a\" vtid=\"6\/850706\" tid=\"0\" log_line=\"81\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(34416)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T20:46:32+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2443031", "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.2443031", "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" } $/: