Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:05', STRUCTURED-DATA: '-', msg: '[DATABASE] [12-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:05.490 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984780" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement:' escaped msg: '[DATABASE] [12-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:05.490 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984780" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement:' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [12-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:05.490 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984780" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: 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": "11", "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": "ef1b891f-e6ee-4e2b-815e-d1c5a0f50576", "x-request-start": "1742200746293" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-1] sql_error_code = 00000 time_ms = \"2025-03-17 08:39:05.490 UTC\" pid=\"1452421\" proc_start_time=\"2025-03-17 08:39:03 UTC\" session_id=\"67d7dfa7.162985\" vtid=\"6\/5984780\" tid=\"0\" log_line=\"4\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(40078)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:05+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:05', STRUCTURED-DATA: '-', msg: '[DATABASE] [12-2] #011 CREATE TEMPORARY TABLE "_tmp_salesforce_goc__configuration_item__c"' escaped msg: '[DATABASE] [12-2] #011 CREATE TEMPORARY TABLE "_tmp_salesforce_goc__configuration_item__c"' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [12-2] #011 CREATE TEMPORARY TABLE "_tmp_salesforce_goc__configuration_item__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": "11", "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": "ef1b891f-e6ee-4e2b-815e-d1c5a0f50576", "x-request-start": "1742200746293" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-2] #011 CREATE TEMPORARY TABLE \"_tmp_salesforce_goc__configuration_item__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:05+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:05', STRUCTURED-DATA: '-', msg: '[DATABASE] [12-3] #011 ON COMMIT PRESERVE ROWS' escaped msg: '[DATABASE] [12-3] #011 ON COMMIT PRESERVE ROWS' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [12-3] #011 ON COMMIT PRESERVE ROWS' $!:{ "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": "11", "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": "ef1b891f-e6ee-4e2b-815e-d1c5a0f50576", "x-request-start": "1742200746293" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-3] #011 ON COMMIT PRESERVE ROWS", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:05+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:05', STRUCTURED-DATA: '-', msg: '[DATABASE] [12-4] #011 AS' escaped msg: '[DATABASE] [12-4] #011 AS' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [12-4] #011 AS' $!:{ "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": "11", "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": "ef1b891f-e6ee-4e2b-815e-d1c5a0f50576", "x-request-start": "1742200746293" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-4] #011 AS", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:05+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:05', STRUCTURED-DATA: '-', msg: '[DATABASE] [12-5] #011 SELECT "goc__configuration_item_type__c","goc__path__c","name","goc__parent_configuration_item__c","isdeleted","systemmodstamp","createddate","goc__status__c","goc__isactive__c","sfid","goc__root_node__c", now() as deleteddate,' escaped msg: '[DATABASE] [12-5] #011 SELECT "goc__configuration_item_type__c","goc__path__c","name","goc__parent_configuration_item__c","isdeleted","systemmodstamp","createddate","goc__status__c","goc__isactive__c","sfid","goc__root_node__c", now() as deleteddate,' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [12-5] #011 SELECT "goc__configuration_item_type__c","goc__path__c","name","goc__parent_configuration_item__c","isdeleted","systemmodstamp","createddate","goc__status__c","goc__isactive__c","sfid","goc__root_node__c", now() as deleteddate,' $!:{ "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": "11", "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": "ef1b891f-e6ee-4e2b-815e-d1c5a0f50576", "x-request-start": "1742200746293" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-5] #011 SELECT \"goc__configuration_item_type__c\",\"goc__path__c\",\"name\",\"goc__parent_configuration_item__c\",\"isdeleted\",\"systemmodstamp\",\"createddate\",\"goc__status__c\",\"goc__isactive__c\",\"sfid\",\"goc__root_node__c\", now() as deleteddate,", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:05+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:05', STRUCTURED-DATA: '-', msg: '[DATABASE] [12-6] #011 ''::varchar(20) AS __operation' escaped msg: '[DATABASE] [12-6] #011 ''::varchar(20) AS __operation' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [12-6] #011 ''::varchar(20) AS __operation' $!:{ "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": "11", "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": "ef1b891f-e6ee-4e2b-815e-d1c5a0f50576", "x-request-start": "1742200746293" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-6] #011 ''::varchar(20) AS __operation", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:05+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:05', STRUCTURED-DATA: '-', msg: '[DATABASE] [12-7] #011 FROM "salesforce"."goc__configuration_item__c" WITH NO DATA' escaped msg: '[DATABASE] [12-7] #011 FROM "salesforce"."goc__configuration_item__c" WITH NO DATA' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [12-7] #011 FROM "salesforce"."goc__configuration_item__c" WITH NO DATA' $!:{ "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": "11", "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": "ef1b891f-e6ee-4e2b-815e-d1c5a0f50576", "x-request-start": "1742200746293" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-7] #011 FROM \"salesforce\".\"goc__configuration_item__c\" WITH NO DATA", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:05+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:05', STRUCTURED-DATA: '-', msg: '[DATABASE] [12-8]' escaped msg: '[DATABASE] [12-8]' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [12-8]' $!:{ "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": "11", "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": "ef1b891f-e6ee-4e2b-815e-d1c5a0f50576", "x-request-start": "1742200746293" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-8]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:05+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:05', STRUCTURED-DATA: '-', msg: '[DATABASE] [13-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:05.497 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984781" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement: CREATE UNIQUE INDEX ON' escaped msg: '[DATABASE] [13-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:05.497 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984781" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement: CREATE UNIQUE INDEX ON' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [13-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:05.497 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984781" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement: CREATE UNIQUE INDEX ON' $!:{ "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": "11", "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": "ef1b891f-e6ee-4e2b-815e-d1c5a0f50576", "x-request-start": "1742200746293" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [13-1] sql_error_code = 00000 time_ms = \"2025-03-17 08:39:05.497 UTC\" pid=\"1452421\" proc_start_time=\"2025-03-17 08:39:03 UTC\" session_id=\"67d7dfa7.162985\" vtid=\"6\/5984781\" tid=\"0\" log_line=\"5\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(40078)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: statement: CREATE UNIQUE INDEX ON", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:05+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:05', STRUCTURED-DATA: '-', msg: '[DATABASE] [13-2] #011 "_tmp_salesforce_goc__configuration_item__c" ("sfid")' escaped msg: '[DATABASE] [13-2] #011 "_tmp_salesforce_goc__configuration_item__c" ("sfid")' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [13-2] #011 "_tmp_salesforce_goc__configuration_item__c" ("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": "11", "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": "ef1b891f-e6ee-4e2b-815e-d1c5a0f50576", "x-request-start": "1742200746293" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [13-2] #011 \"_tmp_salesforce_goc__configuration_item__c\" (\"sfid\")", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:05+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:05', STRUCTURED-DATA: '-', msg: '[DATABASE] [14-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:05.501 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984782" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement: CREATE INDEX ON "_tmp_salesforce_goc__configuration_item__c" (__operation, "sfid")' escaped msg: '[DATABASE] [14-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:05.501 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984782" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement: CREATE INDEX ON "_tmp_salesforce_goc__configuration_item__c" (__operation, "sfid")' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [14-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:05.501 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984782" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement: CREATE INDEX ON "_tmp_salesforce_goc__configuration_item__c" (__operation, "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": "11", "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": "ef1b891f-e6ee-4e2b-815e-d1c5a0f50576", "x-request-start": "1742200746293" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [14-1] sql_error_code = 00000 time_ms = \"2025-03-17 08:39:05.501 UTC\" pid=\"1452421\" proc_start_time=\"2025-03-17 08:39:03 UTC\" session_id=\"67d7dfa7.162985\" vtid=\"6\/5984782\" tid=\"0\" log_line=\"6\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(40078)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: statement: CREATE INDEX ON \"_tmp_salesforce_goc__configuration_item__c\" (__operation, \"sfid\")", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:05+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:42', STRUCTURED-DATA: '-', msg: '[DATABASE] [18-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:42.784 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984789" tid="2273657" log_line="10" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8614.884 ms statement:' escaped msg: '[DATABASE] [18-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:42.784 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984789" tid="2273657" log_line="10" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8614.884 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:42+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [18-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:42.784 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984789" tid="2273657" log_line="10" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8614.884 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": "7a4ea3fc-4215-4837-b7e8-31c6d1b9f8da", "x-request-start": "1742200783393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18-1] sql_error_code = 00000 time_ms = \"2025-03-17 08:39:42.784 UTC\" pid=\"1452421\" proc_start_time=\"2025-03-17 08:39:03 UTC\" session_id=\"67d7dfa7.162985\" vtid=\"6\/5984789\" tid=\"2273657\" log_line=\"10\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(40078)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8614.884 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:42+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:42', STRUCTURED-DATA: '-', msg: '[DATABASE] [18-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] [18-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:42+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [18-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": "7a4ea3fc-4215-4837-b7e8-31c6d1b9f8da", "x-request-start": "1742200783393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18-2] #011 UPDATE \"salesforce\".\"goc__configuration_item__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"goc__configuration_item_type__c\"=s.\"goc__configuration_item_type__c\",\"goc__path__c\"=s.\"goc__path__c\",\"name\"=s.\"name\",\"goc__parent_configuration_item__c\"=s.\"goc__parent_configuration_item__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"createddate\"=s.\"createddate\",\"goc__status__c\"=s.\"goc__status__c\",\"goc__isactive__c\"=s.\"goc__isactive__c\",\"goc__root_node__c\"=s.\"goc__root_node__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:42+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:42', STRUCTURED-DATA: '-', msg: '[DATABASE] [18-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [18-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:42+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [18-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": "7a4ea3fc-4215-4837-b7e8-31c6d1b9f8da", "x-request-start": "1742200783393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18-3] #011 FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:42+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:42', STRUCTURED-DATA: '-', msg: '[DATABASE] [18-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [18-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:42+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [18-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": "7a4ea3fc-4215-4837-b7e8-31c6d1b9f8da", "x-request-start": "1742200783393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t.\"systemmodstamp\" IS NULL OR s.\"systemmodstamp\" >= t.\"systemmodstamp\") AND", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:42+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:42', STRUCTURED-DATA: '-', msg: '[DATABASE] [18-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [18-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:42+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [18-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": "7a4ea3fc-4215-4837-b7e8-31c6d1b9f8da", "x-request-start": "1742200783393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18-5] #011 ((t.\"sfid\" IS NOT NULL AND t.\"sfid\" = s.\"sfid\") )", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:42+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:39:42', STRUCTURED-DATA: '-', msg: '[DATABASE] [18-6]' escaped msg: '[DATABASE] [18-6]' inputname: drain rawmsg: '<134>1 2025-03-17T08:39:42+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [18-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": "7a4ea3fc-4215-4837-b7e8-31c6d1b9f8da", "x-request-start": "1742200783393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:39:42+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:18', STRUCTURED-DATA: '-', msg: '[DATABASE] [22-1] sql_error_code = 00000 time_ms = "2025-03-17 08:40:18.866 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984797" tid="2273673" log_line="14" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8696.811 ms statement:' escaped msg: '[DATABASE] [22-1] sql_error_code = 00000 time_ms = "2025-03-17 08:40:18.866 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984797" tid="2273673" log_line="14" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8696.811 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:18+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [22-1] sql_error_code = 00000 time_ms = "2025-03-17 08:40:18.866 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984797" tid="2273673" log_line="14" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8696.811 ms statement:' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d0eadc03-75d1-4493-a284-856c4f5f3c13", "x-request-start": "1742200819643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [22-1] sql_error_code = 00000 time_ms = \"2025-03-17 08:40:18.866 UTC\" pid=\"1452421\" proc_start_time=\"2025-03-17 08:39:03 UTC\" session_id=\"67d7dfa7.162985\" vtid=\"6\/5984797\" tid=\"2273673\" log_line=\"14\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(40078)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8696.811 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:18+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:18', STRUCTURED-DATA: '-', msg: '[DATABASE] [22-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] [22-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:18+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [22-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": "d0eadc03-75d1-4493-a284-856c4f5f3c13", "x-request-start": "1742200819643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [22-2] #011 UPDATE \"salesforce\".\"goc__configuration_item__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"goc__configuration_item_type__c\"=s.\"goc__configuration_item_type__c\",\"goc__path__c\"=s.\"goc__path__c\",\"name\"=s.\"name\",\"goc__parent_configuration_item__c\"=s.\"goc__parent_configuration_item__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"createddate\"=s.\"createddate\",\"goc__status__c\"=s.\"goc__status__c\",\"goc__isactive__c\"=s.\"goc__isactive__c\",\"goc__root_node__c\"=s.\"goc__root_node__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:18+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:18', STRUCTURED-DATA: '-', msg: '[DATABASE] [22-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [22-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:18+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [22-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": "d0eadc03-75d1-4493-a284-856c4f5f3c13", "x-request-start": "1742200819643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [22-3] #011 FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:18+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:18', STRUCTURED-DATA: '-', msg: '[DATABASE] [22-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [22-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:18+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [22-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": "d0eadc03-75d1-4493-a284-856c4f5f3c13", "x-request-start": "1742200819643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [22-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t.\"systemmodstamp\" IS NULL OR s.\"systemmodstamp\" >= t.\"systemmodstamp\") AND", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:18+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:18', STRUCTURED-DATA: '-', msg: '[DATABASE] [22-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [22-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:18+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [22-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": "d0eadc03-75d1-4493-a284-856c4f5f3c13", "x-request-start": "1742200819643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [22-5] #011 ((t.\"sfid\" IS NOT NULL AND t.\"sfid\" = s.\"sfid\") )", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:18+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:18', STRUCTURED-DATA: '-', msg: '[DATABASE] [22-6]' escaped msg: '[DATABASE] [22-6]' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:18+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [22-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": "d0eadc03-75d1-4493-a284-856c4f5f3c13", "x-request-start": "1742200819643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [22-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:18+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:55', STRUCTURED-DATA: '-', msg: '[DATABASE] [26-1] sql_error_code = 00000 time_ms = "2025-03-17 08:40:55.229 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984805" tid="2273692" log_line="18" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8676.329 ms statement:' escaped msg: '[DATABASE] [26-1] sql_error_code = 00000 time_ms = "2025-03-17 08:40:55.229 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984805" tid="2273692" log_line="18" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8676.329 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:55+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [26-1] sql_error_code = 00000 time_ms = "2025-03-17 08:40:55.229 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984805" tid="2273692" log_line="18" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8676.329 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": "61eec711-2a55-4e74-89c7-4b0b142b78fe", "x-request-start": "1742200855894" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [26-1] sql_error_code = 00000 time_ms = \"2025-03-17 08:40:55.229 UTC\" pid=\"1452421\" proc_start_time=\"2025-03-17 08:39:03 UTC\" session_id=\"67d7dfa7.162985\" vtid=\"6\/5984805\" tid=\"2273692\" log_line=\"18\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(40078)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8676.329 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:55+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:55', STRUCTURED-DATA: '-', msg: '[DATABASE] [26-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' escaped msg: '[DATABASE] [26-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:55+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [26-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "61eec711-2a55-4e74-89c7-4b0b142b78fe", "x-request-start": "1742200855894" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [26-2] #011 UPDATE \"salesforce\".\"goc__configuration_item__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"goc__configuration_item_type__c\"=s.\"goc__configuration_item_type__c\",\"goc__path__c\"=s.\"goc__path__c\",\"name\"=s.\"name\",\"goc__parent_configuration_item__c\"=s.\"goc__parent_configuration_item__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"createddate\"=s.\"createddate\",\"goc__status__c\"=s.\"goc__status__c\",\"goc__isactive__c\"=s.\"goc__isactive__c\",\"goc__root_node__c\"=s.\"goc__root_node__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:55+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:55', STRUCTURED-DATA: '-', msg: '[DATABASE] [26-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [26-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:55+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [26-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "61eec711-2a55-4e74-89c7-4b0b142b78fe", "x-request-start": "1742200855894" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [26-3] #011 FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:55+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:55', STRUCTURED-DATA: '-', msg: '[DATABASE] [26-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [26-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:55+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [26-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "61eec711-2a55-4e74-89c7-4b0b142b78fe", "x-request-start": "1742200855894" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [26-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t.\"systemmodstamp\" IS NULL OR s.\"systemmodstamp\" >= t.\"systemmodstamp\") AND", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:55+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:55', STRUCTURED-DATA: '-', msg: '[DATABASE] [26-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [26-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:55+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [26-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "61eec711-2a55-4e74-89c7-4b0b142b78fe", "x-request-start": "1742200855894" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [26-5] #011 ((t.\"sfid\" IS NOT NULL AND t.\"sfid\" = s.\"sfid\") )", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:55+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:40:55', STRUCTURED-DATA: '-', msg: '[DATABASE] [26-6]' escaped msg: '[DATABASE] [26-6]' inputname: drain rawmsg: '<134>1 2025-03-17T08:40:55+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [26-6]' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "61eec711-2a55-4e74-89c7-4b0b142b78fe", "x-request-start": "1742200855894" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [26-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:40:55+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:31', STRUCTURED-DATA: '-', msg: '[DATABASE] [30-1] sql_error_code = 00000 time_ms = "2025-03-17 08:41:31.494 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984813" tid="2273705" log_line="22" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8517.792 ms statement:' escaped msg: '[DATABASE] [30-1] sql_error_code = 00000 time_ms = "2025-03-17 08:41:31.494 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984813" tid="2273705" log_line="22" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8517.792 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:31+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [30-1] sql_error_code = 00000 time_ms = "2025-03-17 08:41:31.494 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984813" tid="2273705" log_line="22" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8517.792 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": "c65faeef-5f54-4f78-8620-fb56b1af027b", "x-request-start": "1742200892143" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [30-1] sql_error_code = 00000 time_ms = \"2025-03-17 08:41:31.494 UTC\" pid=\"1452421\" proc_start_time=\"2025-03-17 08:39:03 UTC\" session_id=\"67d7dfa7.162985\" vtid=\"6\/5984813\" tid=\"2273705\" log_line=\"22\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(40078)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8517.792 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:31+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:31', 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-17T08:41:31+00:00 ip-10-1-102-204 app postgres.3775215 - - [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": "c65faeef-5f54-4f78-8620-fb56b1af027b", "x-request-start": "1742200892143" }, "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-17T08:41:31+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:31', 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-17T08:41:31+00:00 ip-10-1-102-204 app postgres.3775215 - - [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": "c65faeef-5f54-4f78-8620-fb56b1af027b", "x-request-start": "1742200892143" }, "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-17T08:41:31+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:31', 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-17T08:41:31+00:00 ip-10-1-102-204 app postgres.3775215 - - [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": "c65faeef-5f54-4f78-8620-fb56b1af027b", "x-request-start": "1742200892143" }, "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-17T08:41:31+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:31', 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-17T08:41:31+00:00 ip-10-1-102-204 app postgres.3775215 - - [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": "c65faeef-5f54-4f78-8620-fb56b1af027b", "x-request-start": "1742200892143" }, "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-17T08:41:31+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:31', STRUCTURED-DATA: '-', msg: '[DATABASE] [30-6]' escaped msg: '[DATABASE] [30-6]' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:31+00:00 ip-10-1-102-204 app postgres.3775215 - - [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": "c65faeef-5f54-4f78-8620-fb56b1af027b", "x-request-start": "1742200892143" }, "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-17T08:41:31+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:58', STRUCTURED-DATA: '-', msg: '[DATABASE] [33-1] sql_error_code = 00000 time_ms = "2025-03-17 08:41:58.771 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984819" tid="2273714" log_line="25" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8654.805 ms statement:' escaped msg: '[DATABASE] [33-1] sql_error_code = 00000 time_ms = "2025-03-17 08:41:58.771 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984819" tid="2273714" log_line="25" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8654.805 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:58+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [33-1] sql_error_code = 00000 time_ms = "2025-03-17 08:41:58.771 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984819" tid="2273714" log_line="25" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8654.805 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": "eacd2e2e-99dd-45a4-a39a-5ece4565758d", "x-request-start": "1742200919393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [33-1] sql_error_code = 00000 time_ms = \"2025-03-17 08:41:58.771 UTC\" pid=\"1452421\" proc_start_time=\"2025-03-17 08:39:03 UTC\" session_id=\"67d7dfa7.162985\" vtid=\"6\/5984819\" tid=\"2273714\" log_line=\"25\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(40078)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8654.805 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:58+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:58', STRUCTURED-DATA: '-', msg: '[DATABASE] [33-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' escaped msg: '[DATABASE] [33-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:58+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [33-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "eacd2e2e-99dd-45a4-a39a-5ece4565758d", "x-request-start": "1742200919393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [33-2] #011 UPDATE \"salesforce\".\"goc__configuration_item__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"goc__configuration_item_type__c\"=s.\"goc__configuration_item_type__c\",\"goc__path__c\"=s.\"goc__path__c\",\"name\"=s.\"name\",\"goc__parent_configuration_item__c\"=s.\"goc__parent_configuration_item__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"createddate\"=s.\"createddate\",\"goc__status__c\"=s.\"goc__status__c\",\"goc__isactive__c\"=s.\"goc__isactive__c\",\"goc__root_node__c\"=s.\"goc__root_node__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:58+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:58', STRUCTURED-DATA: '-', msg: '[DATABASE] [33-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [33-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:58+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [33-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "eacd2e2e-99dd-45a4-a39a-5ece4565758d", "x-request-start": "1742200919393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [33-3] #011 FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:58+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:58', STRUCTURED-DATA: '-', msg: '[DATABASE] [33-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [33-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:58+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [33-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "eacd2e2e-99dd-45a4-a39a-5ece4565758d", "x-request-start": "1742200919393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [33-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t.\"systemmodstamp\" IS NULL OR s.\"systemmodstamp\" >= t.\"systemmodstamp\") AND", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:58+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:58', STRUCTURED-DATA: '-', msg: '[DATABASE] [33-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [33-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:58+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [33-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "eacd2e2e-99dd-45a4-a39a-5ece4565758d", "x-request-start": "1742200919393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [33-5] #011 ((t.\"sfid\" IS NOT NULL AND t.\"sfid\" = s.\"sfid\") )", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:58+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:41:58', STRUCTURED-DATA: '-', msg: '[DATABASE] [33-6]' escaped msg: '[DATABASE] [33-6]' inputname: drain rawmsg: '<134>1 2025-03-17T08:41:58+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [33-6]' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "eacd2e2e-99dd-45a4-a39a-5ece4565758d", "x-request-start": "1742200919393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [33-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:41:58+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:42:30', STRUCTURED-DATA: '-', msg: '[DATABASE] [37-1] sql_error_code = 00000 time_ms = "2025-03-17 08:42:30.164 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984827" tid="2273726" log_line="29" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 3955.429 ms statement:' escaped msg: '[DATABASE] [37-1] sql_error_code = 00000 time_ms = "2025-03-17 08:42:30.164 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984827" tid="2273726" log_line="29" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 3955.429 ms statement:' inputname: drain rawmsg: '<134>1 2025-03-17T08:42:30+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [37-1] sql_error_code = 00000 time_ms = "2025-03-17 08:42:30.164 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984827" tid="2273726" log_line="29" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 3955.429 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": "57a056c5-6c6a-4bb8-95ae-ffd3ef53a5d7", "x-request-start": "1742200950728" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [37-1] sql_error_code = 00000 time_ms = \"2025-03-17 08:42:30.164 UTC\" pid=\"1452421\" proc_start_time=\"2025-03-17 08:39:03 UTC\" session_id=\"67d7dfa7.162985\" vtid=\"6\/5984827\" tid=\"2273726\" log_line=\"29\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(40078)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 3955.429 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:42:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:42:30', STRUCTURED-DATA: '-', msg: '[DATABASE] [37-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' escaped msg: '[DATABASE] [37-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' inputname: drain rawmsg: '<134>1 2025-03-17T08:42:30+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [37-2] #011 UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "57a056c5-6c6a-4bb8-95ae-ffd3ef53a5d7", "x-request-start": "1742200950728" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [37-2] #011 UPDATE \"salesforce\".\"goc__configuration_item__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"goc__configuration_item_type__c\"=s.\"goc__configuration_item_type__c\",\"goc__path__c\"=s.\"goc__path__c\",\"name\"=s.\"name\",\"goc__parent_configuration_item__c\"=s.\"goc__parent_configuration_item__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"createddate\"=s.\"createddate\",\"goc__status__c\"=s.\"goc__status__c\",\"goc__isactive__c\"=s.\"goc__isactive__c\",\"goc__root_node__c\"=s.\"goc__root_node__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:42:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:42:30', STRUCTURED-DATA: '-', msg: '[DATABASE] [37-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' escaped msg: '[DATABASE] [37-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' inputname: drain rawmsg: '<134>1 2025-03-17T08:42:30+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [37-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "57a056c5-6c6a-4bb8-95ae-ffd3ef53a5d7", "x-request-start": "1742200950728" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [37-3] #011 FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:42:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:42:30', STRUCTURED-DATA: '-', msg: '[DATABASE] [37-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' escaped msg: '[DATABASE] [37-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' inputname: drain rawmsg: '<134>1 2025-03-17T08:42:30+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [37-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "57a056c5-6c6a-4bb8-95ae-ffd3ef53a5d7", "x-request-start": "1742200950728" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [37-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t.\"systemmodstamp\" IS NULL OR s.\"systemmodstamp\" >= t.\"systemmodstamp\") AND", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:42:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:42:30', STRUCTURED-DATA: '-', msg: '[DATABASE] [37-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' escaped msg: '[DATABASE] [37-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' inputname: drain rawmsg: '<134>1 2025-03-17T08:42:30+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [37-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "57a056c5-6c6a-4bb8-95ae-ffd3ef53a5d7", "x-request-start": "1742200950728" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [37-5] #011 ((t.\"sfid\" IS NOT NULL AND t.\"sfid\" = s.\"sfid\") )", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:42:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3775215]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3775215', MSGID: '-', TIMESTAMP: 'Mar 17 08:42:30', STRUCTURED-DATA: '-', msg: '[DATABASE] [37-6]' escaped msg: '[DATABASE] [37-6]' inputname: drain rawmsg: '<134>1 2025-03-17T08:42:30+00:00 ip-10-1-102-204 app postgres.3775215 - - [DATABASE] [37-6]' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "6", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "57a056c5-6c6a-4bb8-95ae-ffd3ef53a5d7", "x-request-start": "1742200950728" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [37-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T08:42:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3775215", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: