Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:03:23', STRUCTURED-DATA: '[DATABASE]', msg: '[86-1] sql_error_code = 00000 time_ms = "2026-11-11 16:03:23.043 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590903" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3370.957 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[86-1] sql_error_code = 00000 time_ms = "2026-11-11 16:03:23.043 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590903" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3370.957 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:03:23+00:00 host app postgres.2404000 - [DATABASE] [86-1] sql_error_code = 00000 time_ms = "2026-11-11 16:03:23.043 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590903" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3370.957 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "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": "372cd771-416e-4d70-9c80-6fdbead8f53d", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.54.65.165", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "9dd67337-bb2c-8853-3975-5c371829deff", "x-request-start": "1794413003872" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[86-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:03:23.043 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590903\" tid=\"0\" log_line=\"4\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3370.957 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:03:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:03:23', STRUCTURED-DATA: '[DATABASE]', msg: '[86-2] sql_error_code = 00000 time_ms = "2026-11-11 16:03:23.043 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590903" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[86-2] sql_error_code = 00000 time_ms = "2026-11-11 16:03:23.043 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590903" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:03:23+00:00 host app postgres.2404000 - [DATABASE] [86-2] sql_error_code = 00000 time_ms = "2026-11-11 16:03:23.043 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590903" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" 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": "372cd771-416e-4d70-9c80-6fdbead8f53d", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.54.65.165", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "9dd67337-bb2c-8853-3975-5c371829deff", "x-request-start": "1794413003872" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[86-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:03:23.043 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590903\" tid=\"0\" log_line=\"5\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:03:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:06:33', STRUCTURED-DATA: '[DATABASE]', msg: '[88-1] sql_error_code = 00000 time_ms = "2026-11-11 16:06:33.062 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590912" tid="0" log_line="8" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3513.012 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "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: '[88-1] sql_error_code = 00000 time_ms = "2026-11-11 16:06:33.062 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590912" tid="0" log_line="8" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3513.012 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:06:33+00:00 host app postgres.2404000 - [DATABASE] [88-1] sql_error_code = 00000 time_ms = "2026-11-11 16:06:33.062 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590912" tid="0" log_line="8" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3513.012 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "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": "89d9d631-a0f5-4325-8e2e-2b20545090f7", "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": "ca84788d-52ed-4756-7ba1-a1780c58db93", "x-request-start": "1794413193871" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[88-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:06:33.062 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590912\" tid=\"0\" log_line=\"8\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3513.012 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:06:33+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:06:33', STRUCTURED-DATA: '[DATABASE]', msg: '[88-2] sql_error_code = 00000 time_ms = "2026-11-11 16:06:33.062 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590912" tid="0" log_line="9" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[88-2] sql_error_code = 00000 time_ms = "2026-11-11 16:06:33.062 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590912" tid="0" log_line="9" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:06:33+00:00 host app postgres.2404000 - [DATABASE] [88-2] sql_error_code = 00000 time_ms = "2026-11-11 16:06:33.062 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590912" tid="0" log_line="9" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" 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": "89d9d631-a0f5-4325-8e2e-2b20545090f7", "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": "ca84788d-52ed-4756-7ba1-a1780c58db93", "x-request-start": "1794413193871" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[88-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:06:33.062 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590912\" tid=\"0\" log_line=\"9\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:06:33+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:06:42', STRUCTURED-DATA: '[DATABASE]', msg: '[89-1] sql_error_code = 00000 time_ms = "2026-11-11 16:06:42.734 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590915" tid="0" log_line="10" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3289.171 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "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: '[89-1] sql_error_code = 00000 time_ms = "2026-11-11 16:06:42.734 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590915" tid="0" log_line="10" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3289.171 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:06:42+00:00 host app postgres.2404000 - [DATABASE] [89-1] sql_error_code = 00000 time_ms = "2026-11-11 16:06:42.734 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590915" tid="0" log_line="10" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3289.171 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "835abca2-203c-47af-a6de-2ecbc194115e", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.239.200.69", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "a0a2cc79-13f0-1312-eb0b-1bf5f2c94daa", "x-request-start": "1794413203624" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[89-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:06:42.734 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590915\" tid=\"0\" log_line=\"10\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3289.171 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:06:42+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:06:42', STRUCTURED-DATA: '[DATABASE]', msg: '[89-2] sql_error_code = 00000 time_ms = "2026-11-11 16:06:42.734 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590915" tid="0" log_line="11" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[89-2] sql_error_code = 00000 time_ms = "2026-11-11 16:06:42.734 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590915" tid="0" log_line="11" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:06:42+00:00 host app postgres.2404000 - [DATABASE] [89-2] sql_error_code = 00000 time_ms = "2026-11-11 16:06:42.734 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590915" tid="0" log_line="11" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "835abca2-203c-47af-a6de-2ecbc194115e", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.239.200.69", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "a0a2cc79-13f0-1312-eb0b-1bf5f2c94daa", "x-request-start": "1794413203624" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[89-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:06:42.734 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590915\" tid=\"0\" log_line=\"11\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:06:42+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:07:56', STRUCTURED-DATA: '[DATABASE]', msg: '[90-1] sql_error_code = 00000 time_ms = "2026-11-11 16:07:56.967 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590918" tid="0" log_line="12" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3325.964 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "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: '[90-1] sql_error_code = 00000 time_ms = "2026-11-11 16:07:56.967 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590918" tid="0" log_line="12" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3325.964 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:07:56+00:00 host app postgres.2404000 - [DATABASE] [90-1] sql_error_code = 00000 time_ms = "2026-11-11 16:07:56.967 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590918" tid="0" log_line="12" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3325.964 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "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": "1889", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "dd20db02-00d0-4404-aa44-4d74277a843a", "logplex-msg-count": "3", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.239.200.69", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "e1cf244c-f3c2-7f0a-7e0b-1aed7d7aafef", "x-request-start": "1794413277753" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[90-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:07:56.967 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590918\" tid=\"0\" log_line=\"12\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3325.964 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:07:56+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:07:56', STRUCTURED-DATA: '[DATABASE]', msg: '[90-2] sql_error_code = 00000 time_ms = "2026-11-11 16:07:56.967 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590918" tid="0" log_line="13" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[90-2] sql_error_code = 00000 time_ms = "2026-11-11 16:07:56.967 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590918" tid="0" log_line="13" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:07:56+00:00 host app postgres.2404000 - [DATABASE] [90-2] sql_error_code = 00000 time_ms = "2026-11-11 16:07:56.967 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590918" tid="0" log_line="13" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" 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": "1889", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "dd20db02-00d0-4404-aa44-4d74277a843a", "logplex-msg-count": "3", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "34.239.200.69", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "e1cf244c-f3c2-7f0a-7e0b-1aed7d7aafef", "x-request-start": "1794413277753" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[90-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:07:56.967 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590918\" tid=\"0\" log_line=\"13\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:07:56+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:08:08', STRUCTURED-DATA: '[DATABASE]', msg: '[91-1] sql_error_code = 00000 time_ms = "2026-11-11 16:08:08.925 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590922" tid="0" log_line="14" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3309.914 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "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: '[91-1] sql_error_code = 00000 time_ms = "2026-11-11 16:08:08.925 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590922" tid="0" log_line="14" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3309.914 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:08:08+00:00 host app postgres.2404000 - [DATABASE] [91-1] sql_error_code = 00000 time_ms = "2026-11-11 16:08:08.925 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590922" tid="0" log_line="14" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3309.914 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "76963e53-4132-4d1e-b6d8-f543305b1653", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.54.65.165", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "1b55de7f-d181-99e5-2751-73078c665418", "x-request-start": "1794413289874" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[91-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:08:08.925 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590922\" tid=\"0\" log_line=\"14\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3309.914 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:08:08+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:08:08', STRUCTURED-DATA: '[DATABASE]', msg: '[91-2] sql_error_code = 00000 time_ms = "2026-11-11 16:08:08.925 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590922" tid="0" log_line="15" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[91-2] sql_error_code = 00000 time_ms = "2026-11-11 16:08:08.925 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590922" tid="0" log_line="15" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:08:08+00:00 host app postgres.2404000 - [DATABASE] [91-2] sql_error_code = 00000 time_ms = "2026-11-11 16:08:08.925 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590922" tid="0" log_line="15" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "76963e53-4132-4d1e-b6d8-f543305b1653", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "52.54.65.165", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "1b55de7f-d181-99e5-2751-73078c665418", "x-request-start": "1794413289874" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[91-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:08:08.925 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590922\" tid=\"0\" log_line=\"15\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:08:08+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:14:42', STRUCTURED-DATA: '[DATABASE]', msg: '[92-1] sql_error_code = 00000 time_ms = "2026-11-11 16:14:42.029 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590926" tid="0" log_line="16" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3615.306 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "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: '[92-1] sql_error_code = 00000 time_ms = "2026-11-11 16:14:42.029 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590926" tid="0" log_line="16" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3615.306 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:14:42+00:00 host app postgres.2404000 - [DATABASE] [92-1] sql_error_code = 00000 time_ms = "2026-11-11 16:14:42.029 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590926" tid="0" log_line="16" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3615.306 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "78c23dd3-bd00-4e46-a063-b5b414cb1b36", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "35.171.91.38", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "5d07cfc7-85f3-28f6-7388-13ec158ffa1b", "x-request-start": "1794413682890" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[92-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:14:42.029 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590926\" tid=\"0\" log_line=\"16\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3615.306 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:14:42+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:14:42', STRUCTURED-DATA: '[DATABASE]', msg: '[92-2] sql_error_code = 00000 time_ms = "2026-11-11 16:14:42.029 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590926" tid="0" log_line="17" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[92-2] sql_error_code = 00000 time_ms = "2026-11-11 16:14:42.029 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590926" tid="0" log_line="17" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:14:42+00:00 host app postgres.2404000 - [DATABASE] [92-2] sql_error_code = 00000 time_ms = "2026-11-11 16:14:42.029 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590926" tid="0" log_line="17" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "78c23dd3-bd00-4e46-a063-b5b414cb1b36", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "35.171.91.38", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "5d07cfc7-85f3-28f6-7388-13ec158ffa1b", "x-request-start": "1794413682890" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[92-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:14:42.029 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590926\" tid=\"0\" log_line=\"17\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:14:42+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:14:46', STRUCTURED-DATA: '[DATABASE]', msg: '[93-1] sql_error_code = 00000 time_ms = "2026-11-11 16:14:46.711 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590929" tid="0" log_line="18" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3495.231 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "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: '[93-1] sql_error_code = 00000 time_ms = "2026-11-11 16:14:46.711 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590929" tid="0" log_line="18" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3495.231 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:14:46+00:00 host app postgres.2404000 - [DATABASE] [93-1] sql_error_code = 00000 time_ms = "2026-11-11 16:14:46.711 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590929" tid="0" log_line="18" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3495.231 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "0292e216-6c0d-459d-ad24-9f535afd8d9d", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.82.88.250", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "2483184f-7f18-aeac-92d6-0042804afd65", "x-request-start": "1794413687653" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[93-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:14:46.711 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590929\" tid=\"0\" log_line=\"18\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3495.231 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:14:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:14:46', STRUCTURED-DATA: '[DATABASE]', msg: '[93-2] sql_error_code = 00000 time_ms = "2026-11-11 16:14:46.711 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590929" tid="0" log_line="19" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[93-2] sql_error_code = 00000 time_ms = "2026-11-11 16:14:46.711 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590929" tid="0" log_line="19" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:14:46+00:00 host app postgres.2404000 - [DATABASE] [93-2] sql_error_code = 00000 time_ms = "2026-11-11 16:14:46.711 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590929" tid="0" log_line="19" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "0292e216-6c0d-459d-ad24-9f535afd8d9d", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.82.88.250", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "2483184f-7f18-aeac-92d6-0042804afd65", "x-request-start": "1794413687653" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[93-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:14:46.711 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590929\" tid=\"0\" log_line=\"19\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:14:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:18:41', STRUCTURED-DATA: '[DATABASE]', msg: '[95-1] sql_error_code = 00000 time_ms = "2026-11-11 16:18:41.602 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590936" tid="0" log_line="22" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3285.022 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[95-1] sql_error_code = 00000 time_ms = "2026-11-11 16:18:41.602 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590936" tid="0" log_line="22" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3285.022 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:18:41+00:00 host app postgres.2404000 - [DATABASE] [95-1] sql_error_code = 00000 time_ms = "2026-11-11 16:18:41.602 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590936" tid="0" log_line="22" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3285.022 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "d4c87170-70c5-42c3-a689-a5df09c1f6fe", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "23.21.77.75", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "82a4b8f9-8b2c-1afe-a599-d66f7e292bf5", "x-request-start": "1794413922378" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[95-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:18:41.602 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590936\" tid=\"0\" log_line=\"22\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3285.022 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:18:41+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:18:41', STRUCTURED-DATA: '[DATABASE]', msg: '[95-2] sql_error_code = 00000 time_ms = "2026-11-11 16:18:41.602 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590936" tid="0" log_line="23" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[95-2] sql_error_code = 00000 time_ms = "2026-11-11 16:18:41.602 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590936" tid="0" log_line="23" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:18:41+00:00 host app postgres.2404000 - [DATABASE] [95-2] sql_error_code = 00000 time_ms = "2026-11-11 16:18:41.602 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590936" tid="0" log_line="23" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "d4c87170-70c5-42c3-a689-a5df09c1f6fe", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "23.21.77.75", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "82a4b8f9-8b2c-1afe-a599-d66f7e292bf5", "x-request-start": "1794413922378" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[95-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:18:41.602 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590936\" tid=\"0\" log_line=\"23\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:18:41+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:19:47', STRUCTURED-DATA: '[DATABASE]', msg: '[96-1] sql_error_code = 00000 time_ms = "2026-11-11 16:19:47.464 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590939" tid="0" log_line="24" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3457.679 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[96-1] sql_error_code = 00000 time_ms = "2026-11-11 16:19:47.464 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590939" tid="0" log_line="24" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3457.679 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:19:47+00:00 host app postgres.2404000 - [DATABASE] [96-1] sql_error_code = 00000 time_ms = "2026-11-11 16:19:47.464 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590939" tid="0" log_line="24" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3457.679 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "be5e4c9f-6411-4717-b440-88f11cbe71bf", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.82.88.250", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "2ff2808b-1171-cebf-42a7-7cdcc6a86f57", "x-request-start": "1794413988253" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[96-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:19:47.464 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590939\" tid=\"0\" log_line=\"24\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3457.679 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:19:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:19:47', STRUCTURED-DATA: '[DATABASE]', msg: '[96-2] sql_error_code = 00000 time_ms = "2026-11-11 16:19:47.464 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590939" tid="0" log_line="25" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[96-2] sql_error_code = 00000 time_ms = "2026-11-11 16:19:47.464 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590939" tid="0" log_line="25" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:19:47+00:00 host app postgres.2404000 - [DATABASE] [96-2] sql_error_code = 00000 time_ms = "2026-11-11 16:19:47.464 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590939" tid="0" log_line="25" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "be5e4c9f-6411-4717-b440-88f11cbe71bf", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "3.82.88.250", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "2ff2808b-1171-cebf-42a7-7cdcc6a86f57", "x-request-start": "1794413988253" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[96-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:19:47.464 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590939\" tid=\"0\" log_line=\"25\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:19:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:27:09', STRUCTURED-DATA: '[DATABASE]', msg: '[98-1] sql_error_code = 00000 time_ms = "2026-11-11 16:27:09.249 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590949" tid="0" log_line="28" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3383.268 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' escaped msg: '[98-1] sql_error_code = 00000 time_ms = "2026-11-11 16:27:09.249 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590949" tid="0" log_line="28" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3383.268 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:27:09+00:00 host app postgres.2404000 - [DATABASE] [98-1] sql_error_code = 00000 time_ms = "2026-11-11 16:27:09.249 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590949" tid="0" log_line="28" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3383.268 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "5101a0e3-3c52-4f78-b260-1b6c0da1a97f", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "98.85.195.47", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "193eb182-3650-803f-891f-c9ecd928b25c", "x-request-start": "1794414430136" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[98-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:27:09.249 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590949\" tid=\"0\" log_line=\"28\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3383.268 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:27:09+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:27:09', STRUCTURED-DATA: '[DATABASE]', msg: '[98-2] sql_error_code = 00000 time_ms = "2026-11-11 16:27:09.249 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590949" tid="0" log_line="29" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' escaped msg: '[98-2] sql_error_code = 00000 time_ms = "2026-11-11 16:27:09.249 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590949" tid="0" log_line="29" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:27:09+00:00 host app postgres.2404000 - [DATABASE] [98-2] sql_error_code = 00000 time_ms = "2026-11-11 16:27:09.249 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590949" tid="0" log_line="29" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1372", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "5101a0e3-3c52-4f78-b260-1b6c0da1a97f", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (0b8a9a9e03f1)", "x-forwarded-for": "98.85.195.47", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "193eb182-3650-803f-891f-c9ecd928b25c", "x-request-start": "1794414430136" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "data": { "event": "[98-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:27:09.249 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590949\" tid=\"0\" log_line=\"29\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:27:09+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:39:29', STRUCTURED-DATA: '[DATABASE]', msg: '[101-1] sql_error_code = 00000 time_ms = "2026-11-11 16:39:29.316 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590973" tid="0" log_line="34" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3210.551 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "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 16:39:29.316 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590973" tid="0" log_line="34" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3210.551 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and "streams"."updated_at" >= $4) as "temp"' inputname: drain rawmsg: '<134>1 2026-11-11T16:39:29+00:00 host app postgres.2404000 - [DATABASE] [101-1] sql_error_code = 00000 time_ms = "2026-11-11 16:39:29.316 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590973" tid="0" log_line="34" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" LOG: duration: 3210.551 ms execute : select count(*) as "count" from (select "streams"."external_id", "streams"."id", "streams"."owner_id", "streams"."updated_at", "streams"."type", "projections"."projection" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" where "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": "ac845b09-7d76-4c47-8b9c-6be14e111a71", "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": "e60aaab5-75f0-641d-cfc5-a0f0bb6a1814", "x-request-start": "1794415170123" }, "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 16:39:29.316 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590973\" tid=\"0\" log_line=\"34\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3210.551 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:39:29+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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.2404000]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.2404000', MSGID: '-', TIMESTAMP: 'Nov 11 16:39:29', STRUCTURED-DATA: '[DATABASE]', msg: '[101-2] sql_error_code = 00000 time_ms = "2026-11-11 16:39:29.316 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590973" tid="0" log_line="35" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" 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 16:39:29.316 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590973" tid="0" log_line="35" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'' inputname: drain rawmsg: '<134>1 2026-11-11T16:39:29+00:00 host app postgres.2404000 - [DATABASE] [101-2] sql_error_code = 00000 time_ms = "2026-11-11 16:39:29.316 UTC" pid="1113828" proc_start_time="2026-11-11 15:50:06 UTC" session_id="6af48eae.10fee4" vtid="9/590973" tid="0" log_line="35" database="ddvvgu681gm35p" connection_source="10.0.172.89(44264)" 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": "ac845b09-7d76-4c47-8b9c-6be14e111a71", "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": "e60aaab5-75f0-641d-cfc5-a0f0bb6a1814", "x-request-start": "1794415170123" }, "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 16:39:29.316 UTC\" pid=\"1113828\" proc_start_time=\"2026-11-11 15:50:06 UTC\" session_id=\"6af48eae.10fee4\" vtid=\"9\/590973\" tid=\"0\" log_line=\"35\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.172.89(44264)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:39:29+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2404000", "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.2404000", "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" } $/: