Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:32', STRUCTURED-DATA: '-', msg: '[DATABASE] [17-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:32.319 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984787" tid="2273646" log_line="9" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8738.889 ms statement:' escaped msg: '[DATABASE] [17-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:32.319 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984787" tid="2273646" log_line="9" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8738.889 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:32+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [17-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:32.319 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984787" tid="2273646" log_line="9" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8738.889 ms statement:' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "753d68be-080d-438f-8152-e2199d486cd4", "x-request-start": "1742200772893" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [17-1] sql_error_code = 00000 time_ms = \"2025-03-17 08:39:32.319 UTC\" pid=\"1452421\" proc_start_time=\"2025-03-17 08:39:03 UTC\" session_id=\"67d7dfa7.162985\" vtid=\"6\/5984787\" tid=\"2273646\" log_line=\"9\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(40078)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8738.889 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:32+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:32', STRUCTURED-DATA: '-', msg: '[DATABASE] [17-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' escaped msg: '[DATABASE] [17-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:32+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [17-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "753d68be-080d-438f-8152-e2199d486cd4", "x-request-start": "1742200772893" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [17-2] #011 UPDATE \"salesforce\".\"goc__configuration_item__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"goc__configuration_item_type__c\"=s.\"goc__configuration_item_type__c\",\"goc__path__c\"=s.\"goc__path__c\",\"name\"=s.\"name\",\"goc__parent_configuration_item__c\"=s.\"goc__parent_configuration_item__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"createddate\"=s.\"createddate\",\"goc__status__c\"=s.\"goc__status__c\",\"goc__isactive__c\"=s.\"goc__isactive__c\",\"goc__root_node__c\"=s.\"goc__root_node__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:32+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:32', STRUCTURED-DATA: '-', msg: '[DATABASE] [17-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [17-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:32+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [17-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "753d68be-080d-438f-8152-e2199d486cd4", "x-request-start": "1742200772893" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [17-3] #011 FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:32+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:32', STRUCTURED-DATA: '-', msg: '[DATABASE] [17-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [17-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:32+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [17-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "753d68be-080d-438f-8152-e2199d486cd4", "x-request-start": "1742200772893" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [17-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t.\"systemmodstamp\" IS NULL OR s.\"systemmodstamp\" >= t.\"systemmodstamp\") AND", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:32+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:32', STRUCTURED-DATA: '-', msg: '[DATABASE] [17-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [17-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:32+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [17-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "753d68be-080d-438f-8152-e2199d486cd4", "x-request-start": "1742200772893" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [17-5] #011 ((t.\"sfid\" IS NOT NULL AND t.\"sfid\" = s.\"sfid\") )", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:32+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:32', STRUCTURED-DATA: '-', msg: '[DATABASE] [17-6]' escaped msg: '[DATABASE] [17-6]' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:32+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [17-6]' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "753d68be-080d-438f-8152-e2199d486cd4", "x-request-start": "1742200772893" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [17-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:32+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:09', STRUCTURED-DATA: '-', msg: '[DATABASE] [21-1] sql_error_code = 00000 time_ms = "2025-03-17 08:40:09.741 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984795" tid="2273670" log_line="13" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8515.906 ms statement:' escaped msg: '[DATABASE] [21-1] sql_error_code = 00000 time_ms = "2025-03-17 08:40:09.741 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984795" tid="2273670" log_line="13" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8515.906 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:09+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [21-1] sql_error_code = 00000 time_ms = "2025-03-17 08:40:09.741 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984795" tid="2273670" log_line="13" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8515.906 ms statement:' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "326bebbb-1f95-4a08-90a1-6e151cc9e3e8", "x-request-start": "1742200810393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [21-1] sql_error_code = 00000 time_ms = \"2025-03-17 08:40:09.741 UTC\" pid=\"1452421\" proc_start_time=\"2025-03-17 08:39:03 UTC\" session_id=\"67d7dfa7.162985\" vtid=\"6\/5984795\" tid=\"2273670\" log_line=\"13\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(40078)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8515.906 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:09+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:09', STRUCTURED-DATA: '-', msg: '[DATABASE] [21-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' escaped msg: '[DATABASE] [21-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:09+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [21-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "326bebbb-1f95-4a08-90a1-6e151cc9e3e8", "x-request-start": "1742200810393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [21-2] #011 UPDATE \"salesforce\".\"goc__configuration_item__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"goc__configuration_item_type__c\"=s.\"goc__configuration_item_type__c\",\"goc__path__c\"=s.\"goc__path__c\",\"name\"=s.\"name\",\"goc__parent_configuration_item__c\"=s.\"goc__parent_configuration_item__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"createddate\"=s.\"createddate\",\"goc__status__c\"=s.\"goc__status__c\",\"goc__isactive__c\"=s.\"goc__isactive__c\",\"goc__root_node__c\"=s.\"goc__root_node__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:09+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:09', STRUCTURED-DATA: '-', msg: '[DATABASE] [21-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [21-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:09+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [21-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "326bebbb-1f95-4a08-90a1-6e151cc9e3e8", "x-request-start": "1742200810393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [21-3] #011 FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:09+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:09', STRUCTURED-DATA: '-', msg: '[DATABASE] [21-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [21-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:09+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [21-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "326bebbb-1f95-4a08-90a1-6e151cc9e3e8", "x-request-start": "1742200810393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [21-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t.\"systemmodstamp\" IS NULL OR s.\"systemmodstamp\" >= t.\"systemmodstamp\") AND", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:09+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:09', STRUCTURED-DATA: '-', msg: '[DATABASE] [21-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [21-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:09+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [21-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "326bebbb-1f95-4a08-90a1-6e151cc9e3e8", "x-request-start": "1742200810393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [21-5] #011 ((t.\"sfid\" IS NOT NULL AND t.\"sfid\" = s.\"sfid\") )", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:09+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:09', STRUCTURED-DATA: '-', msg: '[DATABASE] [21-6]' escaped msg: '[DATABASE] [21-6]' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:09+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [21-6]' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "326bebbb-1f95-4a08-90a1-6e151cc9e3e8", "x-request-start": "1742200810393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [21-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:09+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [25-1] sql_error_code = 00000 time_ms = "2025-03-17 08:40:46.120 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984803" tid="2273689" log_line="17" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8599.407 ms statement:' escaped msg: '[DATABASE] [25-1] sql_error_code = 00000 time_ms = "2025-03-17 08:40:46.120 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984803" tid="2273689" log_line="17" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8599.407 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:46+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [25-1] sql_error_code = 00000 time_ms = "2025-03-17 08:40:46.120 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984803" tid="2273689" log_line="17" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8599.407 ms statement:' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d206f681-45ff-4657-838a-243bdc5b96a4", "x-request-start": "1742200846643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [25-1] sql_error_code = 00000 time_ms = \"2025-03-17 08:40:46.120 UTC\" pid=\"1452421\" proc_start_time=\"2025-03-17 08:39:03 UTC\" session_id=\"67d7dfa7.162985\" vtid=\"6\/5984803\" tid=\"2273689\" log_line=\"17\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(40078)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8599.407 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [25-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' escaped msg: '[DATABASE] [25-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:46+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [25-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d206f681-45ff-4657-838a-243bdc5b96a4", "x-request-start": "1742200846643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [25-2] #011 UPDATE \"salesforce\".\"goc__configuration_item__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"goc__configuration_item_type__c\"=s.\"goc__configuration_item_type__c\",\"goc__path__c\"=s.\"goc__path__c\",\"name\"=s.\"name\",\"goc__parent_configuration_item__c\"=s.\"goc__parent_configuration_item__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"createddate\"=s.\"createddate\",\"goc__status__c\"=s.\"goc__status__c\",\"goc__isactive__c\"=s.\"goc__isactive__c\",\"goc__root_node__c\"=s.\"goc__root_node__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [25-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [25-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:46+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [25-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d206f681-45ff-4657-838a-243bdc5b96a4", "x-request-start": "1742200846643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [25-3] #011 FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [25-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [25-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:46+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [25-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d206f681-45ff-4657-838a-243bdc5b96a4", "x-request-start": "1742200846643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [25-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t.\"systemmodstamp\" IS NULL OR s.\"systemmodstamp\" >= t.\"systemmodstamp\") AND", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [25-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [25-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:46+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [25-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d206f681-45ff-4657-838a-243bdc5b96a4", "x-request-start": "1742200846643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [25-5] #011 ((t.\"sfid\" IS NOT NULL AND t.\"sfid\" = s.\"sfid\") )", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [25-6]' escaped msg: '[DATABASE] [25-6]' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:46+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [25-6]' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d206f681-45ff-4657-838a-243bdc5b96a4", "x-request-start": "1742200846643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [25-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:22', STRUCTURED-DATA: '-', msg: '[DATABASE] [29-1] sql_error_code = 00000 time_ms = "2025-03-17 08:41:22.553 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984811" tid="2273702" log_line="21" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8672.811 ms statement:' escaped msg: '[DATABASE] [29-1] sql_error_code = 00000 time_ms = "2025-03-17 08:41:22.553 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984811" tid="2273702" log_line="21" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8672.811 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:22+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [29-1] sql_error_code = 00000 time_ms = "2025-03-17 08:41:22.553 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984811" tid="2273702" log_line="21" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8672.811 ms statement:' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "c5a61bf3-2a06-4938-8e71-70dc0e4ed5b5", "x-request-start": "1742200883143" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [29-1] sql_error_code = 00000 time_ms = \"2025-03-17 08:41:22.553 UTC\" pid=\"1452421\" proc_start_time=\"2025-03-17 08:39:03 UTC\" session_id=\"67d7dfa7.162985\" vtid=\"6\/5984811\" tid=\"2273702\" log_line=\"21\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(40078)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8672.811 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:22+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:22', STRUCTURED-DATA: '-', msg: '[DATABASE] [29-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' escaped msg: '[DATABASE] [29-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:22+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [29-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "c5a61bf3-2a06-4938-8e71-70dc0e4ed5b5", "x-request-start": "1742200883143" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [29-2] #011 UPDATE \"salesforce\".\"goc__configuration_item__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"goc__configuration_item_type__c\"=s.\"goc__configuration_item_type__c\",\"goc__path__c\"=s.\"goc__path__c\",\"name\"=s.\"name\",\"goc__parent_configuration_item__c\"=s.\"goc__parent_configuration_item__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"createddate\"=s.\"createddate\",\"goc__status__c\"=s.\"goc__status__c\",\"goc__isactive__c\"=s.\"goc__isactive__c\",\"goc__root_node__c\"=s.\"goc__root_node__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:22+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:22', STRUCTURED-DATA: '-', msg: '[DATABASE] [29-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [29-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:22+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [29-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "c5a61bf3-2a06-4938-8e71-70dc0e4ed5b5", "x-request-start": "1742200883143" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [29-3] #011 FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:22+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:22', STRUCTURED-DATA: '-', msg: '[DATABASE] [29-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [29-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:22+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [29-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "c5a61bf3-2a06-4938-8e71-70dc0e4ed5b5", "x-request-start": "1742200883143" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [29-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t.\"systemmodstamp\" IS NULL OR s.\"systemmodstamp\" >= t.\"systemmodstamp\") AND", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:22+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:22', STRUCTURED-DATA: '-', msg: '[DATABASE] [29-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [29-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:22+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [29-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "c5a61bf3-2a06-4938-8e71-70dc0e4ed5b5", "x-request-start": "1742200883143" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [29-5] #011 ((t.\"sfid\" IS NOT NULL AND t.\"sfid\" = s.\"sfid\") )", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:22+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:22', STRUCTURED-DATA: '-', msg: '[DATABASE] [29-6]' escaped msg: '[DATABASE] [29-6]' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:22+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [29-6]' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "c5a61bf3-2a06-4938-8e71-70dc0e4ed5b5", "x-request-start": "1742200883143" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [29-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:22+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:49', STRUCTURED-DATA: '-', msg: '[DATABASE] [32-1] sql_error_code = 00000 time_ms = "2025-03-17 08:41:49.693 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984817" tid="2273711" log_line="24" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8708.604 ms statement:' escaped msg: '[DATABASE] [32-1] sql_error_code = 00000 time_ms = "2025-03-17 08:41:49.693 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984817" tid="2273711" log_line="24" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8708.604 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:49+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [32-1] sql_error_code = 00000 time_ms = "2025-03-17 08:41:49.693 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984817" tid="2273711" log_line="24" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8708.604 ms statement:' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "88d6b1fa-cc02-4d1c-90f2-1d46b2e6578e", "x-request-start": "1742200910393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [32-1] sql_error_code = 00000 time_ms = \"2025-03-17 08:41:49.693 UTC\" pid=\"1452421\" proc_start_time=\"2025-03-17 08:39:03 UTC\" session_id=\"67d7dfa7.162985\" vtid=\"6\/5984817\" tid=\"2273711\" log_line=\"24\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(40078)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8708.604 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:49', STRUCTURED-DATA: '-', msg: '[DATABASE] [32-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' escaped msg: '[DATABASE] [32-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:49+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [32-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "88d6b1fa-cc02-4d1c-90f2-1d46b2e6578e", "x-request-start": "1742200910393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [32-2] #011 UPDATE \"salesforce\".\"goc__configuration_item__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"goc__configuration_item_type__c\"=s.\"goc__configuration_item_type__c\",\"goc__path__c\"=s.\"goc__path__c\",\"name\"=s.\"name\",\"goc__parent_configuration_item__c\"=s.\"goc__parent_configuration_item__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"createddate\"=s.\"createddate\",\"goc__status__c\"=s.\"goc__status__c\",\"goc__isactive__c\"=s.\"goc__isactive__c\",\"goc__root_node__c\"=s.\"goc__root_node__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:49', STRUCTURED-DATA: '-', msg: '[DATABASE] [32-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [32-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:49+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [32-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "88d6b1fa-cc02-4d1c-90f2-1d46b2e6578e", "x-request-start": "1742200910393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [32-3] #011 FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:49', STRUCTURED-DATA: '-', msg: '[DATABASE] [32-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [32-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:49+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [32-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "88d6b1fa-cc02-4d1c-90f2-1d46b2e6578e", "x-request-start": "1742200910393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [32-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t.\"systemmodstamp\" IS NULL OR s.\"systemmodstamp\" >= t.\"systemmodstamp\") AND", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:49', STRUCTURED-DATA: '-', msg: '[DATABASE] [32-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [32-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:49+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [32-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "88d6b1fa-cc02-4d1c-90f2-1d46b2e6578e", "x-request-start": "1742200910393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [32-5] #011 ((t.\"sfid\" IS NOT NULL AND t.\"sfid\" = s.\"sfid\") )", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:49', STRUCTURED-DATA: '-', msg: '[DATABASE] [32-6]' escaped msg: '[DATABASE] [32-6]' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:49+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [32-6]' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "88d6b1fa-cc02-4d1c-90f2-1d46b2e6578e", "x-request-start": "1742200910393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [32-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:42:25', STRUCTURED-DATA: '-', msg: '[DATABASE] [36-1] sql_error_code = 00000 time_ms = "2025-03-17 08:42:25.958 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984825" tid="2273723" log_line="28" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8509.479 ms statement:' escaped msg: '[DATABASE] [36-1] sql_error_code = 00000 time_ms = "2025-03-17 08:42:25.958 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984825" tid="2273723" log_line="28" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8509.479 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T08:42:25+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [36-1] sql_error_code = 00000 time_ms = "2025-03-17 08:42:25.958 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984825" tid="2273723" log_line="28" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8509.479 ms statement:' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "938aaa20-ba93-4a25-9b0c-c897cb3414a5", "x-request-start": "1742200946643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [36-1] sql_error_code = 00000 time_ms = \"2025-03-17 08:42:25.958 UTC\" pid=\"1452421\" proc_start_time=\"2025-03-17 08:39:03 UTC\" session_id=\"67d7dfa7.162985\" vtid=\"6\/5984825\" tid=\"2273723\" log_line=\"28\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(40078)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8509.479 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:42:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:42:25', STRUCTURED-DATA: '-', msg: '[DATABASE] [36-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' escaped msg: '[DATABASE] [36-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' inputname: drain rawmsg: '<134>1 2025-03-17T08:42:25+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [36-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "938aaa20-ba93-4a25-9b0c-c897cb3414a5", "x-request-start": "1742200946643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [36-2] #011 UPDATE \"salesforce\".\"goc__configuration_item__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"goc__configuration_item_type__c\"=s.\"goc__configuration_item_type__c\",\"goc__path__c\"=s.\"goc__path__c\",\"name\"=s.\"name\",\"goc__parent_configuration_item__c\"=s.\"goc__parent_configuration_item__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"createddate\"=s.\"createddate\",\"goc__status__c\"=s.\"goc__status__c\",\"goc__isactive__c\"=s.\"goc__isactive__c\",\"goc__root_node__c\"=s.\"goc__root_node__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:42:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:42:25', STRUCTURED-DATA: '-', msg: '[DATABASE] [36-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [36-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T08:42:25+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [36-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "938aaa20-ba93-4a25-9b0c-c897cb3414a5", "x-request-start": "1742200946643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [36-3] #011 FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:42:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:42:25', STRUCTURED-DATA: '-', msg: '[DATABASE] [36-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [36-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' inputname: drain rawmsg: '<134>1 2025-03-17T08:42:25+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [36-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "938aaa20-ba93-4a25-9b0c-c897cb3414a5", "x-request-start": "1742200946643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [36-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t.\"systemmodstamp\" IS NULL OR s.\"systemmodstamp\" >= t.\"systemmodstamp\") AND", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:42:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:42:25', STRUCTURED-DATA: '-', msg: '[DATABASE] [36-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [36-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T08:42:25+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [36-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "938aaa20-ba93-4a25-9b0c-c897cb3414a5", "x-request-start": "1742200946643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [36-5] #011 ((t.\"sfid\" IS NOT NULL AND t.\"sfid\" = s.\"sfid\") )", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:42:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:42:25', STRUCTURED-DATA: '-', msg: '[DATABASE] [36-6]' escaped msg: '[DATABASE] [36-6]' inputname: drain rawmsg: '<134>1 2025-03-17T08:42:25+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [36-6]' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "938aaa20-ba93-4a25-9b0c-c897cb3414a5", "x-request-start": "1742200946643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [36-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:42:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: