Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:38:47', STRUCTURED-DATA: '-', msg: '[DATABASE] [16-1] sql_error_code = 00000 time_ms = "2025-03-15 00:38:47.308 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763521" tid="2267403" log_line="8" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8654.500 ms statement:' escaped msg: '[DATABASE] [16-1] sql_error_code = 00000 time_ms = "2025-03-15 00:38:47.308 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763521" tid="2267403" log_line="8" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8654.500 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-15T00:38:47+00:00 ip-10-1-102-204 app postgres.3277931 - - [DATABASE] [16-1] sql_error_code = 00000 time_ms = "2025-03-15 00:38:47.308 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763521" tid="2267403" log_line="8" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8654.500 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": "b50c94cb-9418-42c3-919e-d747a979fbce", "x-request-start": "1741999127753" }, "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-15 00:38:47.308 UTC\" pid=\"1411542\" proc_start_time=\"2025-03-15 00:38:27 UTC\" session_id=\"67d4cc03.1589d6\" vtid=\"2\/1763521\" tid=\"2267403\" log_line=\"8\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(49722)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8654.500 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:38:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:38:47', 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-15T00:38:47+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "b50c94cb-9418-42c3-919e-d747a979fbce", "x-request-start": "1741999127753" }, "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-15T00:38:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:38:47', 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-15T00:38:47+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "b50c94cb-9418-42c3-919e-d747a979fbce", "x-request-start": "1741999127753" }, "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-15T00:38:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:38:47', 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-15T00:38:47+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "b50c94cb-9418-42c3-919e-d747a979fbce", "x-request-start": "1741999127753" }, "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-15T00:38:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:38:47', 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-15T00:38:47+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "b50c94cb-9418-42c3-919e-d747a979fbce", "x-request-start": "1741999127753" }, "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-15T00:38:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:38:47', STRUCTURED-DATA: '-', msg: '[DATABASE] [16-6]' escaped msg: '[DATABASE] [16-6]' inputname: drain rawmsg: '<134>1 2025-03-15T00:38:47+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "b50c94cb-9418-42c3-919e-d747a979fbce", "x-request-start": "1741999127753" }, "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-15T00:38:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:39:23', STRUCTURED-DATA: '-', msg: '[DATABASE] [20-1] sql_error_code = 00000 time_ms = "2025-03-15 00:39:23.323 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763529" tid="2267415" log_line="12" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8613.780 ms statement:' escaped msg: '[DATABASE] [20-1] sql_error_code = 00000 time_ms = "2025-03-15 00:39:23.323 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763529" tid="2267415" log_line="12" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8613.780 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-15T00:39:23+00:00 ip-10-1-102-204 app postgres.3277931 - - [DATABASE] [20-1] sql_error_code = 00000 time_ms = "2025-03-15 00:39:23.323 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763529" tid="2267415" log_line="12" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8613.780 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": "ec32c5b1-f815-47bc-a991-bba834b34602", "x-request-start": "1741999163895" }, "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-15 00:39:23.323 UTC\" pid=\"1411542\" proc_start_time=\"2025-03-15 00:38:27 UTC\" session_id=\"67d4cc03.1589d6\" vtid=\"2\/1763529\" tid=\"2267415\" log_line=\"12\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(49722)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8613.780 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:39:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:39:23', 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-15T00:39:23+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "ec32c5b1-f815-47bc-a991-bba834b34602", "x-request-start": "1741999163895" }, "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-15T00:39:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:39:23', 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-15T00:39:23+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "ec32c5b1-f815-47bc-a991-bba834b34602", "x-request-start": "1741999163895" }, "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-15T00:39:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:39:23', 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-15T00:39:23+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "ec32c5b1-f815-47bc-a991-bba834b34602", "x-request-start": "1741999163895" }, "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-15T00:39:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:39:23', 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-15T00:39:23+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "ec32c5b1-f815-47bc-a991-bba834b34602", "x-request-start": "1741999163895" }, "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-15T00:39:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:39:23', STRUCTURED-DATA: '-', msg: '[DATABASE] [20-6]' escaped msg: '[DATABASE] [20-6]' inputname: drain rawmsg: '<134>1 2025-03-15T00:39:23+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "ec32c5b1-f815-47bc-a991-bba834b34602", "x-request-start": "1741999163895" }, "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-15T00:39:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:39:59', STRUCTURED-DATA: '-', msg: '[DATABASE] [24-1] sql_error_code = 00000 time_ms = "2025-03-15 00:39:59.238 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763537" tid="2267427" log_line="16" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8592.196 ms statement:' escaped msg: '[DATABASE] [24-1] sql_error_code = 00000 time_ms = "2025-03-15 00:39:59.238 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763537" tid="2267427" log_line="16" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8592.196 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-15T00:39:59+00:00 ip-10-1-102-204 app postgres.3277931 - - [DATABASE] [24-1] sql_error_code = 00000 time_ms = "2025-03-15 00:39:59.238 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763537" tid="2267427" log_line="16" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8592.196 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": "51438d81-eeaa-4e35-813b-df57cc94862a", "x-request-start": "1741999199895" }, "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-15 00:39:59.238 UTC\" pid=\"1411542\" proc_start_time=\"2025-03-15 00:38:27 UTC\" session_id=\"67d4cc03.1589d6\" vtid=\"2\/1763537\" tid=\"2267427\" log_line=\"16\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(49722)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8592.196 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:39:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:39:59', 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-15T00:39:59+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "51438d81-eeaa-4e35-813b-df57cc94862a", "x-request-start": "1741999199895" }, "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-15T00:39:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:39:59', 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-15T00:39:59+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "51438d81-eeaa-4e35-813b-df57cc94862a", "x-request-start": "1741999199895" }, "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-15T00:39:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:39:59', 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-15T00:39:59+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "51438d81-eeaa-4e35-813b-df57cc94862a", "x-request-start": "1741999199895" }, "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-15T00:39:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:39:59', 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-15T00:39:59+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "51438d81-eeaa-4e35-813b-df57cc94862a", "x-request-start": "1741999199895" }, "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-15T00:39:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:39:59', STRUCTURED-DATA: '-', msg: '[DATABASE] [24-6]' escaped msg: '[DATABASE] [24-6]' inputname: drain rawmsg: '<134>1 2025-03-15T00:39:59+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "51438d81-eeaa-4e35-813b-df57cc94862a", "x-request-start": "1741999199895" }, "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-15T00:39:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:40:26', STRUCTURED-DATA: '-', msg: '[DATABASE] [27-1] sql_error_code = 00000 time_ms = "2025-03-15 00:40:26.386 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763543" tid="2267437" log_line="19" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8656.273 ms statement:' escaped msg: '[DATABASE] [27-1] sql_error_code = 00000 time_ms = "2025-03-15 00:40:26.386 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763543" tid="2267437" log_line="19" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8656.273 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-15T00:40:26+00:00 ip-10-1-102-204 app postgres.3277931 - - [DATABASE] [27-1] sql_error_code = 00000 time_ms = "2025-03-15 00:40:26.386 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763543" tid="2267437" log_line="19" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8656.273 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": "dfc9a81d-800f-4da7-b646-81518327cbc6", "x-request-start": "1741999227145" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [27-1] sql_error_code = 00000 time_ms = \"2025-03-15 00:40:26.386 UTC\" pid=\"1411542\" proc_start_time=\"2025-03-15 00:38:27 UTC\" session_id=\"67d4cc03.1589d6\" vtid=\"2\/1763543\" tid=\"2267437\" log_line=\"19\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(49722)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8656.273 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:40:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:40:26', STRUCTURED-DATA: '-', msg: '[DATABASE] [27-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] [27-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-15T00:40:26+00:00 ip-10-1-102-204 app postgres.3277931 - - [DATABASE] [27-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": "dfc9a81d-800f-4da7-b646-81518327cbc6", "x-request-start": "1741999227145" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [27-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-15T00:40:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:40:26', STRUCTURED-DATA: '-', msg: '[DATABASE] [27-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [27-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-15T00:40:26+00:00 ip-10-1-102-204 app postgres.3277931 - - [DATABASE] [27-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": "dfc9a81d-800f-4da7-b646-81518327cbc6", "x-request-start": "1741999227145" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [27-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-15T00:40:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:40:26', STRUCTURED-DATA: '-', msg: '[DATABASE] [27-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [27-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-15T00:40:26+00:00 ip-10-1-102-204 app postgres.3277931 - - [DATABASE] [27-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": "dfc9a81d-800f-4da7-b646-81518327cbc6", "x-request-start": "1741999227145" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [27-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-15T00:40:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:40:26', STRUCTURED-DATA: '-', msg: '[DATABASE] [27-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [27-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-15T00:40:26+00:00 ip-10-1-102-204 app postgres.3277931 - - [DATABASE] [27-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": "dfc9a81d-800f-4da7-b646-81518327cbc6", "x-request-start": "1741999227145" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [27-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-15T00:40:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:40:26', STRUCTURED-DATA: '-', msg: '[DATABASE] [27-6]' escaped msg: '[DATABASE] [27-6]' inputname: drain rawmsg: '<134>1 2025-03-15T00:40:26+00:00 ip-10-1-102-204 app postgres.3277931 - - [DATABASE] [27-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": "dfc9a81d-800f-4da7-b646-81518327cbc6", "x-request-start": "1741999227145" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [27-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:40:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:40:54', STRUCTURED-DATA: '-', msg: '[DATABASE] [30-1] sql_error_code = 00000 time_ms = "2025-03-15 00:40:54.568 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763549" tid="2267451" log_line="22" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8714.313 ms statement:' escaped msg: '[DATABASE] [30-1] sql_error_code = 00000 time_ms = "2025-03-15 00:40:54.568 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763549" tid="2267451" log_line="22" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8714.313 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-15T00:40:54+00:00 ip-10-1-102-204 app postgres.3277931 - - [DATABASE] [30-1] sql_error_code = 00000 time_ms = "2025-03-15 00:40:54.568 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763549" tid="2267451" log_line="22" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8714.313 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": "52794dda-eaf6-48e6-a0ed-ae54e9e50f51", "x-request-start": "1741999255145" }, "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-15 00:40:54.568 UTC\" pid=\"1411542\" proc_start_time=\"2025-03-15 00:38:27 UTC\" session_id=\"67d4cc03.1589d6\" vtid=\"2\/1763549\" tid=\"2267451\" log_line=\"22\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(49722)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8714.313 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:40:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:40:54', 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-15T00:40:54+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "52794dda-eaf6-48e6-a0ed-ae54e9e50f51", "x-request-start": "1741999255145" }, "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-15T00:40:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:40:54', 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-15T00:40:54+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "52794dda-eaf6-48e6-a0ed-ae54e9e50f51", "x-request-start": "1741999255145" }, "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-15T00:40:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:40:54', 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-15T00:40:54+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "52794dda-eaf6-48e6-a0ed-ae54e9e50f51", "x-request-start": "1741999255145" }, "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-15T00:40:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:40:54', 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-15T00:40:54+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "52794dda-eaf6-48e6-a0ed-ae54e9e50f51", "x-request-start": "1741999255145" }, "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-15T00:40:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:40:54', STRUCTURED-DATA: '-', msg: '[DATABASE] [30-6]' escaped msg: '[DATABASE] [30-6]' inputname: drain rawmsg: '<134>1 2025-03-15T00:40:54+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "52794dda-eaf6-48e6-a0ed-ae54e9e50f51", "x-request-start": "1741999255145" }, "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-15T00:40:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:41:30', STRUCTURED-DATA: '-', msg: '[DATABASE] [34-1] sql_error_code = 00000 time_ms = "2025-03-15 00:41:30.711 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763557" tid="2267464" log_line="26" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8625.955 ms statement:' escaped msg: '[DATABASE] [34-1] sql_error_code = 00000 time_ms = "2025-03-15 00:41:30.711 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763557" tid="2267464" log_line="26" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8625.955 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-15T00:41:30+00:00 ip-10-1-102-204 app postgres.3277931 - - [DATABASE] [34-1] sql_error_code = 00000 time_ms = "2025-03-15 00:41:30.711 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763557" tid="2267464" log_line="26" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8625.955 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": "b9ff3a6c-1751-4c04-9a94-e2964007b5f3", "x-request-start": "1741999291395" }, "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-15 00:41:30.711 UTC\" pid=\"1411542\" proc_start_time=\"2025-03-15 00:38:27 UTC\" session_id=\"67d4cc03.1589d6\" vtid=\"2\/1763557\" tid=\"2267464\" log_line=\"26\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(49722)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8625.955 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:41:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:41:30', 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-15T00:41:30+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "b9ff3a6c-1751-4c04-9a94-e2964007b5f3", "x-request-start": "1741999291395" }, "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-15T00:41:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:41:30', 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-15T00:41:30+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "b9ff3a6c-1751-4c04-9a94-e2964007b5f3", "x-request-start": "1741999291395" }, "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-15T00:41:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:41:30', 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-15T00:41:30+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "b9ff3a6c-1751-4c04-9a94-e2964007b5f3", "x-request-start": "1741999291395" }, "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-15T00:41:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:41:30', 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-15T00:41:30+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "b9ff3a6c-1751-4c04-9a94-e2964007b5f3", "x-request-start": "1741999291395" }, "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-15T00:41:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:41:30', STRUCTURED-DATA: '-', msg: '[DATABASE] [34-6]' escaped msg: '[DATABASE] [34-6]' inputname: drain rawmsg: '<134>1 2025-03-15T00:41:30+00:00 ip-10-1-102-204 app postgres.3277931 - - [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": "b9ff3a6c-1751-4c04-9a94-e2964007b5f3", "x-request-start": "1741999291395" }, "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-15T00:41:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:42:06', STRUCTURED-DATA: '-', msg: '[DATABASE] [38-1] sql_error_code = 00000 time_ms = "2025-03-15 00:42:06.069 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763565" tid="2267476" log_line="30" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 7867.075 ms statement:' escaped msg: '[DATABASE] [38-1] sql_error_code = 00000 time_ms = "2025-03-15 00:42:06.069 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763565" tid="2267476" log_line="30" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 7867.075 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-15T00:42:06+00:00 ip-10-1-102-204 app postgres.3277931 - - [DATABASE] [38-1] sql_error_code = 00000 time_ms = "2025-03-15 00:42:06.069 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763565" tid="2267476" log_line="30" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 7867.075 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": "b144a934-f7f1-450e-bb3f-ba899f43360b", "x-request-start": "1741999326606" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [38-1] sql_error_code = 00000 time_ms = \"2025-03-15 00:42:06.069 UTC\" pid=\"1411542\" proc_start_time=\"2025-03-15 00:38:27 UTC\" session_id=\"67d4cc03.1589d6\" vtid=\"2\/1763565\" tid=\"2267476\" log_line=\"30\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(49722)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 7867.075 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:42:06', STRUCTURED-DATA: '-', msg: '[DATABASE] [38-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] [38-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-15T00:42:06+00:00 ip-10-1-102-204 app postgres.3277931 - - [DATABASE] [38-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": "b144a934-f7f1-450e-bb3f-ba899f43360b", "x-request-start": "1741999326606" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [38-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-15T00:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:42:06', STRUCTURED-DATA: '-', msg: '[DATABASE] [38-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [38-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-15T00:42:06+00:00 ip-10-1-102-204 app postgres.3277931 - - [DATABASE] [38-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": "b144a934-f7f1-450e-bb3f-ba899f43360b", "x-request-start": "1741999326606" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [38-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-15T00:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:42:06', STRUCTURED-DATA: '-', msg: '[DATABASE] [38-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [38-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-15T00:42:06+00:00 ip-10-1-102-204 app postgres.3277931 - - [DATABASE] [38-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": "b144a934-f7f1-450e-bb3f-ba899f43360b", "x-request-start": "1741999326606" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [38-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-15T00:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:42:06', STRUCTURED-DATA: '-', msg: '[DATABASE] [38-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [38-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-15T00:42:06+00:00 ip-10-1-102-204 app postgres.3277931 - - [DATABASE] [38-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": "b144a934-f7f1-450e-bb3f-ba899f43360b", "x-request-start": "1741999326606" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [38-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-15T00:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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.3277931]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3277931', MSGID: '-', TIMESTAMP: 'Mar 15 00:42:06', STRUCTURED-DATA: '-', msg: '[DATABASE] [38-6]' escaped msg: '[DATABASE] [38-6]' inputname: drain rawmsg: '<134>1 2025-03-15T00:42:06+00:00 ip-10-1-102-204 app postgres.3277931 - - [DATABASE] [38-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": "b144a934-f7f1-450e-bb3f-ba899f43360b", "x-request-start": "1741999326606" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [38-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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.3277931", "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" } $/: