# troubleshooting
- s
swetha
05/15/2023, 3:25 AMCopy code{ "type": "index_parallel", "id": "postgresql_mhere", "spec": { "dataSchema": { "dataSource": "postgresql_mhere", "timestampSpec": { "format": "iso", "column": "date" }, "dimensionsSpec": { "dimensions": [ "user_id", "app_id", "date" ] } }, "ioConfig": { "type": "index_parallel", "inputSource": { "type": "sql", "database": { "type": "postgresql", "connectorConfig": { "connectURI": "jdbc:<postgresql://127.0.0.1:5432/mhere>", "user": "postgres", "password": "postgres" } }, "sqls": [ "SELECT * FROM transactions limit 10" ] } }, "tuningConfig": { "type": "index_parallel", "partitionsSpec": { "type": "dynamic" } } } } - s
Slackbot
05/15/2023, 3:34 AMThis message was deleted.ks+2- 5
- 11
- s
swetha
05/15/2023, 3:34 AMCopy code`so I did add postgres-jar to all the lib folders to coordinator,broker,router pods` - s
swetha
05/15/2023, 3:37 AMbut didn't work, any suggestions would be appreciated. Thanks - s
Slackbot
05/15/2023, 11:44 AMThis message was deleted.gp- 3
- 4
- s
Slackbot
05/15/2023, 2:54 PMThis message was deleted.aj- 3
- 4
- s
Slackbot
05/15/2023, 2:54 PMThis message was deleted.ao+2- 5
- 18
- c
Charles Smith
05/15/2023, 4:05 PM@Priyanshu Jain This seems like a good topic for #C0309C9L90D. - s
Slackbot
05/16/2023, 12:36 AMThis message was deleted.gn+3- 6
- 19
- s
Slackbot
05/16/2023, 1:45 AMThis message was deleted.uv+4- 7
- 24
- s
Slackbot
05/17/2023, 12:27 AMThis message was deleted.gk+2- 5
- 8
- s
Slackbot
05/17/2023, 10:31 PMThis message was deleted.b- 2
- 1
- s
Slackbot
05/18/2023, 1:20 AMThis message was deleted.🆘 1hg- 3
- 4
- s
Slackbot
05/18/2023, 8:36 AMThis message was deleted.js+2- 5
- 10
- s
Slackbot
05/19/2023, 4:23 AMThis message was deleted.sg- 3
- 8
- p
Priyanshu Jain
05/19/2023, 5:50 AMHi All, Getting this error log on Cloudwatch Logs:Copy code
Any idea about it?2023-05-19T05:40:29,239 ERROR [ZKCoordinator--0] org.apache.druid.server.coordination.SegmentLoadDropHandler - Failed to load segment for dataSource: {class=org.apache.druid.server.coordination.SegmentLoadDropHandler, exceptionType=class org.apache.druid.segment.loading.SegmentLoadingException, exceptionMessage=Exception loading segment[sales_2023-02-07T00:00:00.000Z_2023-02-08T00:00:00.000Z_2023-03-25T12:04:39.987Z], segment=DataSegment{binaryVersion=9, id=sales_2023-02-07T00:00:00.000Z_2023-02-08T00:00:00.000Z_2023-03-25T12:04:39.987Z, loadSpec={type=>s3_zip, bucket=>crp-druid-data-v2-prod-us-west-2, key=>druid/segments/sales/2023-02-07T00:00:00.000Z_2023-02-08T00:00:00.000Z/2023-03-25T12:04:39.987Z/0/index.zip, S3Schema=>s3n}, dimensions=[site_id, category_desc, customer_count, total_units, OPS, order_count], metrics=[], shardSpec=NumberedShardSpec{partitionNum=0, partitions=1}, lastCompactionState=null, size=15866}} - s
Slackbot
05/19/2023, 9:39 AMThis message was deleted.jt- 3
- 2
- s
Slackbot
05/19/2023, 10:39 AMThis message was deleted.ug- 3
- 8
- s
Slackbot
05/21/2023, 2:10 PMThis message was deleted.jd- 3
- 2
- d
dongzhang
05/21/2023, 2:12 PMNo column data found - s
Slackbot
05/22/2023, 5:18 AMThis message was deleted.tb- 3
- 3
- s
Slackbot
05/22/2023, 9:59 AMThis message was deleted.g- 2
- 4
- s
Slackbot
05/22/2023, 10:24 AMThis message was deleted.j- 2
- 1
- s
Slackbot
05/22/2023, 4:33 PMThis message was deleted.oag- 4
- 9
- s
Slackbot
05/22/2023, 4:37 PMThis message was deleted.g- 2
- 3
- s
Slackbot
05/22/2023, 4:54 PMThis message was deleted.gp- 3
- 8
- s
Slackbot
05/22/2023, 6:21 PMThis message was deleted.aog- 4
- 22
- o
Oleg Yamin
05/22/2023, 6:34 PMtried also with this version and samet hing: https://repo1.maven.org/maven2/org/mariadb/jdbc/mariadb-java-client/2.7.3/mariadb-java-client-2.7.3.jar - o
Oleg Yamin
05/22/2023, 6:34 PMalso tried chaningCopy code
todruid.metadata.storage.connector.connectURI=jdbc:<mysql://servers.com:3115/druid>Copy code
and same errordruid.metadata.storage.connector.connectURI=jdbc:<mariadb://servers.com:3115/druid> - k
Krishna
05/23/2023, 12:33 AMHi, we are seeing this GC Pause immediately after starting historical (Version .25)