Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:15', STRUCTURED-DATA: '-', msg: '[DATABASE] [15-1] sql_error_code = 00000 time_ms = "2025-03-17 10:39:15.956 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996772" tid="2274082" log_line="7" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9065.737 ms statement:' escaped msg: '[DATABASE] [15-1] sql_error_code = 00000 time_ms = "2025-03-17 10:39:15.956 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996772" tid="2274082" log_line="7" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9065.737 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T10:39:15+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [15-1] sql_error_code = 00000 time_ms = "2025-03-17 10:39:15.956 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996772" tid="2274082" log_line="7" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9065.737 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": "8513ac53-3027-420a-ac41-1ce656042bf7", "x-request-start": "1742207956544" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [15-1] sql_error_code = 00000 time_ms = \"2025-03-17 10:39:15.956 UTC\" pid=\"1454511\" proc_start_time=\"2025-03-17 10:39:04 UTC\" session_id=\"67d7fbc8.1631af\" vtid=\"6\/5996772\" tid=\"2274082\" log_line=\"7\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(36918)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 9065.737 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:39:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:15', STRUCTURED-DATA: '-', msg: '[DATABASE] [15-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] [15-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-17T10:39:15+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [15-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": "8513ac53-3027-420a-ac41-1ce656042bf7", "x-request-start": "1742207956544" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [15-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-17T10:39:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:15', STRUCTURED-DATA: '-', msg: '[DATABASE] [15-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [15-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T10:39:15+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [15-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": "8513ac53-3027-420a-ac41-1ce656042bf7", "x-request-start": "1742207956544" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [15-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-17T10:39:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:15', STRUCTURED-DATA: '-', msg: '[DATABASE] [15-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [15-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-17T10:39:15+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [15-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": "8513ac53-3027-420a-ac41-1ce656042bf7", "x-request-start": "1742207956544" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [15-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-17T10:39:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:15', STRUCTURED-DATA: '-', msg: '[DATABASE] [15-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [15-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T10:39:15+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [15-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": "8513ac53-3027-420a-ac41-1ce656042bf7", "x-request-start": "1742207956544" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [15-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-17T10:39:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:15', STRUCTURED-DATA: '-', msg: '[DATABASE] [15-6]' escaped msg: '[DATABASE] [15-6]' inputname: drain rawmsg: '<134>1 2025-03-17T10:39:15+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [15-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": "8513ac53-3027-420a-ac41-1ce656042bf7", "x-request-start": "1742207956544" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [15-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:39:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:25', STRUCTURED-DATA: '-', msg: '[DATABASE] [16-1] sql_error_code = 00000 time_ms = "2025-03-17 10:39:25.382 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996774" tid="2274085" log_line="8" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9019.331 ms statement:' escaped msg: '[DATABASE] [16-1] sql_error_code = 00000 time_ms = "2025-03-17 10:39:25.382 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996774" tid="2274085" log_line="8" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9019.331 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T10:39:25+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [16-1] sql_error_code = 00000 time_ms = "2025-03-17 10:39:25.382 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996774" tid="2274085" log_line="8" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9019.331 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": "c49dc907-18a1-481b-8297-a8fcf84b61ae", "x-request-start": "1742207966284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [16-1] sql_error_code = 00000 time_ms = \"2025-03-17 10:39:25.382 UTC\" pid=\"1454511\" proc_start_time=\"2025-03-17 10:39:04 UTC\" session_id=\"67d7fbc8.1631af\" vtid=\"6\/5996774\" tid=\"2274085\" log_line=\"8\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(36918)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 9019.331 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:39:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:25', STRUCTURED-DATA: '-', msg: '[DATABASE] [16-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] [16-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-17T10:39:25+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [16-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": "c49dc907-18a1-481b-8297-a8fcf84b61ae", "x-request-start": "1742207966284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [16-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-17T10:39:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:25', STRUCTURED-DATA: '-', msg: '[DATABASE] [16-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [16-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T10:39:25+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [16-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": "c49dc907-18a1-481b-8297-a8fcf84b61ae", "x-request-start": "1742207966284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [16-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-17T10:39:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:25', STRUCTURED-DATA: '-', msg: '[DATABASE] [16-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [16-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-17T10:39:25+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [16-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": "c49dc907-18a1-481b-8297-a8fcf84b61ae", "x-request-start": "1742207966284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [16-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-17T10:39:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:25', STRUCTURED-DATA: '-', msg: '[DATABASE] [16-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [16-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T10:39:25+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [16-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": "c49dc907-18a1-481b-8297-a8fcf84b61ae", "x-request-start": "1742207966284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [16-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-17T10:39:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:25', STRUCTURED-DATA: '-', msg: '[DATABASE] [16-6]' escaped msg: '[DATABASE] [16-6]' inputname: drain rawmsg: '<134>1 2025-03-17T10:39:25+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [16-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": "c49dc907-18a1-481b-8297-a8fcf84b61ae", "x-request-start": "1742207966284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [16-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:39:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:53', STRUCTURED-DATA: '-', msg: '[DATABASE] [19-1] sql_error_code = 00000 time_ms = "2025-03-17 10:39:53.482 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996780" tid="2274095" log_line="11" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8991.158 ms statement:' escaped msg: '[DATABASE] [19-1] sql_error_code = 00000 time_ms = "2025-03-17 10:39:53.482 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996780" tid="2274095" log_line="11" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8991.158 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T10:39:53+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [19-1] sql_error_code = 00000 time_ms = "2025-03-17 10:39:53.482 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996780" tid="2274095" log_line="11" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8991.158 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": "1c0f3161-8a0c-443c-a23c-0d6545cacd01", "x-request-start": "1742207994146" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [19-1] sql_error_code = 00000 time_ms = \"2025-03-17 10:39:53.482 UTC\" pid=\"1454511\" proc_start_time=\"2025-03-17 10:39:04 UTC\" session_id=\"67d7fbc8.1631af\" vtid=\"6\/5996780\" tid=\"2274095\" log_line=\"11\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(36918)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8991.158 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:39:53+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:53', STRUCTURED-DATA: '-', msg: '[DATABASE] [19-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] [19-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-17T10:39:53+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [19-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": "1c0f3161-8a0c-443c-a23c-0d6545cacd01", "x-request-start": "1742207994146" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [19-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-17T10:39:53+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:53', STRUCTURED-DATA: '-', msg: '[DATABASE] [19-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [19-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T10:39:53+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [19-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": "1c0f3161-8a0c-443c-a23c-0d6545cacd01", "x-request-start": "1742207994146" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [19-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-17T10:39:53+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:53', STRUCTURED-DATA: '-', msg: '[DATABASE] [19-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [19-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-17T10:39:53+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [19-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": "1c0f3161-8a0c-443c-a23c-0d6545cacd01", "x-request-start": "1742207994146" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [19-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-17T10:39:53+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:53', STRUCTURED-DATA: '-', msg: '[DATABASE] [19-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [19-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T10:39:53+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [19-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": "1c0f3161-8a0c-443c-a23c-0d6545cacd01", "x-request-start": "1742207994146" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [19-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-17T10:39:53+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:39:53', STRUCTURED-DATA: '-', msg: '[DATABASE] [19-6]' escaped msg: '[DATABASE] [19-6]' inputname: drain rawmsg: '<134>1 2025-03-17T10:39:53+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [19-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": "1c0f3161-8a0c-443c-a23c-0d6545cacd01", "x-request-start": "1742207994146" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [19-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:39:53+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:02', STRUCTURED-DATA: '-', msg: '[DATABASE] [20-1] sql_error_code = 00000 time_ms = "2025-03-17 10:40:02.872 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996782" tid="2274098" log_line="12" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8989.325 ms statement:' escaped msg: '[DATABASE] [20-1] sql_error_code = 00000 time_ms = "2025-03-17 10:40:02.872 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996782" tid="2274098" log_line="12" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8989.325 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:02+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [20-1] sql_error_code = 00000 time_ms = "2025-03-17 10:40:02.872 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996782" tid="2274098" log_line="12" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8989.325 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": "79791f24-fa91-4c36-8a81-35bcd1839839", "x-request-start": "1742208003644" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [20-1] sql_error_code = 00000 time_ms = \"2025-03-17 10:40:02.872 UTC\" pid=\"1454511\" proc_start_time=\"2025-03-17 10:39:04 UTC\" session_id=\"67d7fbc8.1631af\" vtid=\"6\/5996782\" tid=\"2274098\" log_line=\"12\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(36918)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8989.325 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:40:02+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:02', STRUCTURED-DATA: '-', msg: '[DATABASE] [20-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] [20-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-17T10:40:02+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [20-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": "79791f24-fa91-4c36-8a81-35bcd1839839", "x-request-start": "1742208003644" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [20-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-17T10:40:02+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:02', STRUCTURED-DATA: '-', msg: '[DATABASE] [20-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [20-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:02+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [20-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": "79791f24-fa91-4c36-8a81-35bcd1839839", "x-request-start": "1742208003644" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [20-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-17T10:40:02+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:02', STRUCTURED-DATA: '-', msg: '[DATABASE] [20-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [20-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-17T10:40:02+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [20-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": "79791f24-fa91-4c36-8a81-35bcd1839839", "x-request-start": "1742208003644" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [20-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-17T10:40:02+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:02', STRUCTURED-DATA: '-', msg: '[DATABASE] [20-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [20-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:02+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [20-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": "79791f24-fa91-4c36-8a81-35bcd1839839", "x-request-start": "1742208003644" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [20-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-17T10:40:02+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:02', STRUCTURED-DATA: '-', msg: '[DATABASE] [20-6]' escaped msg: '[DATABASE] [20-6]' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:02+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [20-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": "79791f24-fa91-4c36-8a81-35bcd1839839", "x-request-start": "1742208003644" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [20-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:40:02+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:30', STRUCTURED-DATA: '-', msg: '[DATABASE] [23-1] sql_error_code = 00000 time_ms = "2025-03-17 10:40:30.955 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996788" tid="2274107" log_line="15" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8936.245 ms statement:' escaped msg: '[DATABASE] [23-1] sql_error_code = 00000 time_ms = "2025-03-17 10:40:30.955 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996788" tid="2274107" log_line="15" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8936.245 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:30+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [23-1] sql_error_code = 00000 time_ms = "2025-03-17 10:40:30.955 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996788" tid="2274107" log_line="15" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8936.245 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": "899535e1-b998-4011-aefa-f30d62805e00", "x-request-start": "1742208031646" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [23-1] sql_error_code = 00000 time_ms = \"2025-03-17 10:40:30.955 UTC\" pid=\"1454511\" proc_start_time=\"2025-03-17 10:39:04 UTC\" session_id=\"67d7fbc8.1631af\" vtid=\"6\/5996788\" tid=\"2274107\" log_line=\"15\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(36918)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8936.245 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:40:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:30', STRUCTURED-DATA: '-', msg: '[DATABASE] [23-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] [23-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-17T10:40:30+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [23-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": "899535e1-b998-4011-aefa-f30d62805e00", "x-request-start": "1742208031646" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [23-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-17T10:40:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:30', STRUCTURED-DATA: '-', msg: '[DATABASE] [23-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [23-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:30+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [23-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": "899535e1-b998-4011-aefa-f30d62805e00", "x-request-start": "1742208031646" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [23-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-17T10:40:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:30', STRUCTURED-DATA: '-', msg: '[DATABASE] [23-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [23-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-17T10:40:30+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [23-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": "899535e1-b998-4011-aefa-f30d62805e00", "x-request-start": "1742208031646" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [23-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-17T10:40:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:30', STRUCTURED-DATA: '-', msg: '[DATABASE] [23-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [23-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:30+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [23-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": "899535e1-b998-4011-aefa-f30d62805e00", "x-request-start": "1742208031646" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [23-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-17T10:40:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:30', STRUCTURED-DATA: '-', msg: '[DATABASE] [23-6]' escaped msg: '[DATABASE] [23-6]' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:30+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [23-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": "899535e1-b998-4011-aefa-f30d62805e00", "x-request-start": "1742208031646" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [23-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:40:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:40', STRUCTURED-DATA: '-', msg: '[DATABASE] [24-1] sql_error_code = 00000 time_ms = "2025-03-17 10:40:40.402 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996790" tid="2274111" log_line="16" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9006.712 ms statement:' escaped msg: '[DATABASE] [24-1] sql_error_code = 00000 time_ms = "2025-03-17 10:40:40.402 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996790" tid="2274111" log_line="16" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9006.712 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:40+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [24-1] sql_error_code = 00000 time_ms = "2025-03-17 10:40:40.402 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996790" tid="2274111" log_line="16" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9006.712 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": "52ce31da-fe74-4aa3-b614-1909b80677aa", "x-request-start": "1742208041144" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [24-1] sql_error_code = 00000 time_ms = \"2025-03-17 10:40:40.402 UTC\" pid=\"1454511\" proc_start_time=\"2025-03-17 10:39:04 UTC\" session_id=\"67d7fbc8.1631af\" vtid=\"6\/5996790\" tid=\"2274111\" log_line=\"16\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(36918)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 9006.712 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:40:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:40', STRUCTURED-DATA: '-', msg: '[DATABASE] [24-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] [24-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-17T10:40:40+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [24-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": "52ce31da-fe74-4aa3-b614-1909b80677aa", "x-request-start": "1742208041144" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [24-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-17T10:40:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:40', STRUCTURED-DATA: '-', msg: '[DATABASE] [24-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [24-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:40+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [24-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": "52ce31da-fe74-4aa3-b614-1909b80677aa", "x-request-start": "1742208041144" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [24-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-17T10:40:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:40', STRUCTURED-DATA: '-', msg: '[DATABASE] [24-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [24-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-17T10:40:40+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [24-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": "52ce31da-fe74-4aa3-b614-1909b80677aa", "x-request-start": "1742208041144" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [24-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-17T10:40:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:40', STRUCTURED-DATA: '-', msg: '[DATABASE] [24-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [24-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:40+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [24-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": "52ce31da-fe74-4aa3-b614-1909b80677aa", "x-request-start": "1742208041144" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [24-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-17T10:40:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:40', STRUCTURED-DATA: '-', msg: '[DATABASE] [24-6]' escaped msg: '[DATABASE] [24-6]' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:40+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [24-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": "52ce31da-fe74-4aa3-b614-1909b80677aa", "x-request-start": "1742208041144" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [24-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:40:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:49', STRUCTURED-DATA: '-', msg: '[DATABASE] [25-1] sql_error_code = 00000 time_ms = "2025-03-17 10:40:49.876 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996792" tid="2274114" log_line="17" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9066.027 ms statement:' escaped msg: '[DATABASE] [25-1] sql_error_code = 00000 time_ms = "2025-03-17 10:40:49.876 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996792" tid="2274114" log_line="17" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9066.027 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:49+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [25-1] sql_error_code = 00000 time_ms = "2025-03-17 10:40:49.876 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996792" tid="2274114" log_line="17" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9066.027 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": "d845fde5-1bef-4788-8163-84872be57556", "x-request-start": "1742208050646" }, "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 10:40:49.876 UTC\" pid=\"1454511\" proc_start_time=\"2025-03-17 10:39:04 UTC\" session_id=\"67d7fbc8.1631af\" vtid=\"6\/5996792\" tid=\"2274114\" log_line=\"17\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(36918)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 9066.027 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:40:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:49', 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-17T10:40:49+00:00 ip-10-1-102-204 app postgres.3793516 - - [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": "d845fde5-1bef-4788-8163-84872be57556", "x-request-start": "1742208050646" }, "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-17T10:40:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:49', 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-17T10:40:49+00:00 ip-10-1-102-204 app postgres.3793516 - - [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": "d845fde5-1bef-4788-8163-84872be57556", "x-request-start": "1742208050646" }, "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-17T10:40:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:49', 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-17T10:40:49+00:00 ip-10-1-102-204 app postgres.3793516 - - [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": "d845fde5-1bef-4788-8163-84872be57556", "x-request-start": "1742208050646" }, "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-17T10:40:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:49', 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-17T10:40:49+00:00 ip-10-1-102-204 app postgres.3793516 - - [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": "d845fde5-1bef-4788-8163-84872be57556", "x-request-start": "1742208050646" }, "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-17T10:40:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:49', STRUCTURED-DATA: '-', msg: '[DATABASE] [25-6]' escaped msg: '[DATABASE] [25-6]' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:49+00:00 ip-10-1-102-204 app postgres.3793516 - - [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": "d845fde5-1bef-4788-8163-84872be57556", "x-request-start": "1742208050646" }, "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-17T10:40:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:59', STRUCTURED-DATA: '-', msg: '[DATABASE] [26-1] sql_error_code = 00000 time_ms = "2025-03-17 10:40:59.259 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996794" tid="2274123" log_line="18" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8977.080 ms statement:' escaped msg: '[DATABASE] [26-1] sql_error_code = 00000 time_ms = "2025-03-17 10:40:59.259 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996794" tid="2274123" log_line="18" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8977.080 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:59+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [26-1] sql_error_code = 00000 time_ms = "2025-03-17 10:40:59.259 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996794" tid="2274123" log_line="18" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8977.080 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": "266e947d-2e0f-4ff1-b650-545e9be4f173", "x-request-start": "1742208059894" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [26-1] sql_error_code = 00000 time_ms = \"2025-03-17 10:40:59.259 UTC\" pid=\"1454511\" proc_start_time=\"2025-03-17 10:39:04 UTC\" session_id=\"67d7fbc8.1631af\" vtid=\"6\/5996794\" tid=\"2274123\" log_line=\"18\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(36918)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8977.080 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:40:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:59', STRUCTURED-DATA: '-', msg: '[DATABASE] [26-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] [26-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-17T10:40:59+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [26-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": "266e947d-2e0f-4ff1-b650-545e9be4f173", "x-request-start": "1742208059894" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [26-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-17T10:40:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:59', STRUCTURED-DATA: '-', msg: '[DATABASE] [26-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [26-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:59+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [26-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": "266e947d-2e0f-4ff1-b650-545e9be4f173", "x-request-start": "1742208059894" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [26-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-17T10:40:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:59', STRUCTURED-DATA: '-', msg: '[DATABASE] [26-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [26-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-17T10:40:59+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [26-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": "266e947d-2e0f-4ff1-b650-545e9be4f173", "x-request-start": "1742208059894" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [26-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-17T10:40:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:59', STRUCTURED-DATA: '-', msg: '[DATABASE] [26-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [26-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:59+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [26-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": "266e947d-2e0f-4ff1-b650-545e9be4f173", "x-request-start": "1742208059894" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [26-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-17T10:40:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:40:59', STRUCTURED-DATA: '-', msg: '[DATABASE] [26-6]' escaped msg: '[DATABASE] [26-6]' inputname: drain rawmsg: '<134>1 2025-03-17T10:40:59+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [26-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": "266e947d-2e0f-4ff1-b650-545e9be4f173", "x-request-start": "1742208059894" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [26-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:40:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:41:27', STRUCTURED-DATA: '-', msg: '[DATABASE] [29-1] sql_error_code = 00000 time_ms = "2025-03-17 10:41:27.378 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996800" tid="2274132" log_line="21" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8953.467 ms statement:' escaped msg: '[DATABASE] [29-1] sql_error_code = 00000 time_ms = "2025-03-17 10:41:27.378 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996800" tid="2274132" log_line="21" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8953.467 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T10:41:27+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [29-1] sql_error_code = 00000 time_ms = "2025-03-17 10:41:27.378 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996800" tid="2274132" log_line="21" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8953.467 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": "3aceca31-006d-42cb-9128-b873c0134395", "x-request-start": "1742208088146" }, "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 10:41:27.378 UTC\" pid=\"1454511\" proc_start_time=\"2025-03-17 10:39:04 UTC\" session_id=\"67d7fbc8.1631af\" vtid=\"6\/5996800\" tid=\"2274132\" log_line=\"21\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(36918)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8953.467 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:41:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:41:27', 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-17T10:41:27+00:00 ip-10-1-102-204 app postgres.3793516 - - [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": "3aceca31-006d-42cb-9128-b873c0134395", "x-request-start": "1742208088146" }, "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-17T10:41:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:41:27', 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-17T10:41:27+00:00 ip-10-1-102-204 app postgres.3793516 - - [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": "3aceca31-006d-42cb-9128-b873c0134395", "x-request-start": "1742208088146" }, "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-17T10:41:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:41:27', 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-17T10:41:27+00:00 ip-10-1-102-204 app postgres.3793516 - - [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": "3aceca31-006d-42cb-9128-b873c0134395", "x-request-start": "1742208088146" }, "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-17T10:41:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:41:27', 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-17T10:41:27+00:00 ip-10-1-102-204 app postgres.3793516 - - [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": "3aceca31-006d-42cb-9128-b873c0134395", "x-request-start": "1742208088146" }, "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-17T10:41:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:41:27', STRUCTURED-DATA: '-', msg: '[DATABASE] [29-6]' escaped msg: '[DATABASE] [29-6]' inputname: drain rawmsg: '<134>1 2025-03-17T10:41:27+00:00 ip-10-1-102-204 app postgres.3793516 - - [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": "3aceca31-006d-42cb-9128-b873c0134395", "x-request-start": "1742208088146" }, "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-17T10:41:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:41:37', STRUCTURED-DATA: '-', msg: '[DATABASE] [30-1] sql_error_code = 00000 time_ms = "2025-03-17 10:41:37.926 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996802" tid="2274135" log_line="22" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9111.207 ms statement:' escaped msg: '[DATABASE] [30-1] sql_error_code = 00000 time_ms = "2025-03-17 10:41:37.926 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996802" tid="2274135" log_line="22" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9111.207 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T10:41:37+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [30-1] sql_error_code = 00000 time_ms = "2025-03-17 10:41:37.926 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996802" tid="2274135" log_line="22" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9111.207 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": "d9eac4a1-cdf6-4810-87aa-52db3719a8bc", "x-request-start": "1742208098218" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [30-1] sql_error_code = 00000 time_ms = \"2025-03-17 10:41:37.926 UTC\" pid=\"1454511\" proc_start_time=\"2025-03-17 10:39:04 UTC\" session_id=\"67d7fbc8.1631af\" vtid=\"6\/5996802\" tid=\"2274135\" log_line=\"22\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(36918)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 9111.207 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:41:37+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:41:37', STRUCTURED-DATA: '-', msg: '[DATABASE] [30-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] [30-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-17T10:41:37+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [30-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": "d9eac4a1-cdf6-4810-87aa-52db3719a8bc", "x-request-start": "1742208098218" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [30-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-17T10:41:37+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:41:37', STRUCTURED-DATA: '-', msg: '[DATABASE] [30-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [30-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T10:41:37+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [30-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": "d9eac4a1-cdf6-4810-87aa-52db3719a8bc", "x-request-start": "1742208098218" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [30-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-17T10:41:37+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:41:37', STRUCTURED-DATA: '-', msg: '[DATABASE] [30-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [30-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-17T10:41:37+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [30-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": "d9eac4a1-cdf6-4810-87aa-52db3719a8bc", "x-request-start": "1742208098218" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [30-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-17T10:41:37+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:41:37', STRUCTURED-DATA: '-', msg: '[DATABASE] [30-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [30-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T10:41:37+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [30-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": "d9eac4a1-cdf6-4810-87aa-52db3719a8bc", "x-request-start": "1742208098218" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [30-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-17T10:41:37+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:41:37', STRUCTURED-DATA: '-', msg: '[DATABASE] [30-6]' escaped msg: '[DATABASE] [30-6]' inputname: drain rawmsg: '<134>1 2025-03-17T10:41:37+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [30-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": "d9eac4a1-cdf6-4810-87aa-52db3719a8bc", "x-request-start": "1742208098218" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [30-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:41:37+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:06', STRUCTURED-DATA: '-', msg: '[DATABASE] [33-1] sql_error_code = 00000 time_ms = "2025-03-17 10:42:06.094 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996808" tid="2274145" log_line="25" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8959.609 ms statement:' escaped msg: '[DATABASE] [33-1] sql_error_code = 00000 time_ms = "2025-03-17 10:42:06.094 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996808" tid="2274145" log_line="25" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8959.609 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T10:42:06+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [33-1] sql_error_code = 00000 time_ms = "2025-03-17 10:42:06.094 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996808" tid="2274145" log_line="25" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8959.609 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": "9cf63a08-fb5d-4686-9585-6482c0b2e9c5", "x-request-start": "1742208126646" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [33-1] sql_error_code = 00000 time_ms = \"2025-03-17 10:42:06.094 UTC\" pid=\"1454511\" proc_start_time=\"2025-03-17 10:39:04 UTC\" session_id=\"67d7fbc8.1631af\" vtid=\"6\/5996808\" tid=\"2274145\" log_line=\"25\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(36918)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8959.609 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:06', STRUCTURED-DATA: '-', msg: '[DATABASE] [33-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] [33-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-17T10:42:06+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [33-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": "9cf63a08-fb5d-4686-9585-6482c0b2e9c5", "x-request-start": "1742208126646" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [33-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-17T10:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:06', STRUCTURED-DATA: '-', msg: '[DATABASE] [33-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [33-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T10:42:06+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [33-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": "9cf63a08-fb5d-4686-9585-6482c0b2e9c5", "x-request-start": "1742208126646" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [33-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-17T10:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:06', STRUCTURED-DATA: '-', msg: '[DATABASE] [33-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [33-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-17T10:42:06+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [33-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": "9cf63a08-fb5d-4686-9585-6482c0b2e9c5", "x-request-start": "1742208126646" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [33-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-17T10:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:06', STRUCTURED-DATA: '-', msg: '[DATABASE] [33-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [33-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T10:42:06+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [33-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": "9cf63a08-fb5d-4686-9585-6482c0b2e9c5", "x-request-start": "1742208126646" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [33-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-17T10:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:06', STRUCTURED-DATA: '-', msg: '[DATABASE] [33-6]' escaped msg: '[DATABASE] [33-6]' inputname: drain rawmsg: '<134>1 2025-03-17T10:42:06+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [33-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": "9cf63a08-fb5d-4686-9585-6482c0b2e9c5", "x-request-start": "1742208126646" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [33-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:15', STRUCTURED-DATA: '-', msg: '[DATABASE] [34-1] sql_error_code = 00000 time_ms = "2025-03-17 10:42:15.506 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996810" tid="2274148" log_line="26" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9008.142 ms statement:' escaped msg: '[DATABASE] [34-1] sql_error_code = 00000 time_ms = "2025-03-17 10:42:15.506 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996810" tid="2274148" log_line="26" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9008.142 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T10:42:15+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [34-1] sql_error_code = 00000 time_ms = "2025-03-17 10:42:15.506 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996810" tid="2274148" log_line="26" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 9008.142 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": "89ca8543-4231-490e-9d98-3193a10466b3", "x-request-start": "1742208136144" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [34-1] sql_error_code = 00000 time_ms = \"2025-03-17 10:42:15.506 UTC\" pid=\"1454511\" proc_start_time=\"2025-03-17 10:39:04 UTC\" session_id=\"67d7fbc8.1631af\" vtid=\"6\/5996810\" tid=\"2274148\" log_line=\"26\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(36918)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 9008.142 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:42:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:15', STRUCTURED-DATA: '-', msg: '[DATABASE] [34-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] [34-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-17T10:42:15+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [34-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": "89ca8543-4231-490e-9d98-3193a10466b3", "x-request-start": "1742208136144" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [34-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-17T10:42:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:15', STRUCTURED-DATA: '-', msg: '[DATABASE] [34-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [34-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T10:42:15+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [34-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": "89ca8543-4231-490e-9d98-3193a10466b3", "x-request-start": "1742208136144" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [34-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-17T10:42:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:15', STRUCTURED-DATA: '-', msg: '[DATABASE] [34-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [34-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-17T10:42:15+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [34-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": "89ca8543-4231-490e-9d98-3193a10466b3", "x-request-start": "1742208136144" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [34-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-17T10:42:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:15', STRUCTURED-DATA: '-', msg: '[DATABASE] [34-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [34-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T10:42:15+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [34-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": "89ca8543-4231-490e-9d98-3193a10466b3", "x-request-start": "1742208136144" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [34-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-17T10:42:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:15', STRUCTURED-DATA: '-', msg: '[DATABASE] [34-6]' escaped msg: '[DATABASE] [34-6]' inputname: drain rawmsg: '<134>1 2025-03-17T10:42:15+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [34-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": "89ca8543-4231-490e-9d98-3193a10466b3", "x-request-start": "1742208136144" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [34-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:42:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:34', STRUCTURED-DATA: '-', msg: '[DATABASE] [36-1] sql_error_code = 00000 time_ms = "2025-03-17 10:42:34.308 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996814" tid="2274154" log_line="28" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8965.343 ms statement:' escaped msg: '[DATABASE] [36-1] sql_error_code = 00000 time_ms = "2025-03-17 10:42:34.308 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996814" tid="2274154" log_line="28" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8965.343 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T10:42:34+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [36-1] sql_error_code = 00000 time_ms = "2025-03-17 10:42:34.308 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996814" tid="2274154" log_line="28" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8965.343 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": "92d96962-58a0-4381-95a0-10cfdd5fda90", "x-request-start": "1742208154896" }, "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 10:42:34.308 UTC\" pid=\"1454511\" proc_start_time=\"2025-03-17 10:39:04 UTC\" session_id=\"67d7fbc8.1631af\" vtid=\"6\/5996814\" tid=\"2274154\" log_line=\"28\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(36918)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8965.343 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:42:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:34', 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-17T10:42:34+00:00 ip-10-1-102-204 app postgres.3793516 - - [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": "92d96962-58a0-4381-95a0-10cfdd5fda90", "x-request-start": "1742208154896" }, "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-17T10:42:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:34', 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-17T10:42:34+00:00 ip-10-1-102-204 app postgres.3793516 - - [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": "92d96962-58a0-4381-95a0-10cfdd5fda90", "x-request-start": "1742208154896" }, "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-17T10:42:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:34', 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-17T10:42:34+00:00 ip-10-1-102-204 app postgres.3793516 - - [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": "92d96962-58a0-4381-95a0-10cfdd5fda90", "x-request-start": "1742208154896" }, "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-17T10:42:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:34', 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-17T10:42:34+00:00 ip-10-1-102-204 app postgres.3793516 - - [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": "92d96962-58a0-4381-95a0-10cfdd5fda90", "x-request-start": "1742208154896" }, "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-17T10:42:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:34', STRUCTURED-DATA: '-', msg: '[DATABASE] [36-6]' escaped msg: '[DATABASE] [36-6]' inputname: drain rawmsg: '<134>1 2025-03-17T10:42:34+00:00 ip-10-1-102-204 app postgres.3793516 - - [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": "92d96962-58a0-4381-95a0-10cfdd5fda90", "x-request-start": "1742208154896" }, "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-17T10:42:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:40', STRUCTURED-DATA: '-', msg: '[DATABASE] [37-1] sql_error_code = 00000 time_ms = "2025-03-17 10:42:40.294 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996816" tid="2274157" log_line="29" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 5679.905 ms statement:' escaped msg: '[DATABASE] [37-1] sql_error_code = 00000 time_ms = "2025-03-17 10:42:40.294 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996816" tid="2274157" log_line="29" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 5679.905 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T10:42:40+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [37-1] sql_error_code = 00000 time_ms = "2025-03-17 10:42:40.294 UTC" pid="1454511" proc_start_time="2025-03-17 10:39:04 UTC" session_id="67d7fbc8.1631af" vtid="6/5996816" tid="2274157" log_line="29" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(36918)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 5679.905 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": "36e21103-c8c9-41b1-b75e-6cc5642b6357", "x-request-start": "1742208160859" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [37-1] sql_error_code = 00000 time_ms = \"2025-03-17 10:42:40.294 UTC\" pid=\"1454511\" proc_start_time=\"2025-03-17 10:39:04 UTC\" session_id=\"67d7fbc8.1631af\" vtid=\"6\/5996816\" tid=\"2274157\" log_line=\"29\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(36918)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 5679.905 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:42:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:40', STRUCTURED-DATA: '-', msg: '[DATABASE] [37-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] [37-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-17T10:42:40+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [37-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": "36e21103-c8c9-41b1-b75e-6cc5642b6357", "x-request-start": "1742208160859" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [37-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-17T10:42:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:40', STRUCTURED-DATA: '-', msg: '[DATABASE] [37-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [37-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T10:42:40+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [37-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": "36e21103-c8c9-41b1-b75e-6cc5642b6357", "x-request-start": "1742208160859" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [37-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-17T10:42:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:40', STRUCTURED-DATA: '-', msg: '[DATABASE] [37-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [37-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-17T10:42:40+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [37-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": "36e21103-c8c9-41b1-b75e-6cc5642b6357", "x-request-start": "1742208160859" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [37-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-17T10:42:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:40', STRUCTURED-DATA: '-', msg: '[DATABASE] [37-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [37-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T10:42:40+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [37-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": "36e21103-c8c9-41b1-b75e-6cc5642b6357", "x-request-start": "1742208160859" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [37-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-17T10:42:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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.3793516]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3793516', MSGID: '-', TIMESTAMP: 'Mar 17 10:42:40', STRUCTURED-DATA: '-', msg: '[DATABASE] [37-6]' escaped msg: '[DATABASE] [37-6]' inputname: drain rawmsg: '<134>1 2025-03-17T10:42:40+00:00 ip-10-1-102-204 app postgres.3793516 - - [DATABASE] [37-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": "36e21103-c8c9-41b1-b75e-6cc5642b6357", "x-request-start": "1742208160859" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [37-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T10:42:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3793516", "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.3793516", "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" } $/: