@BenB : No, its again consuming 100%+ CPU, I removed the the sql enrichment due to which records are getting failed and check the usage it b/w 100-200% CPU Utilization.
Below is the error I am getting for which SQL enrichment is getting failed… Same messages are getting passed in old enricher.
{“enrichment”:{“schemaKey”:“iglu:com.snowplowanalytics.snowplow.enrichments/sql_query_enrichment_config/jsonschema/1-0-0”,“identifier”:“sql-query”},“message”:{“error”:“The placeholder map error. The map: Some(IntMap()), where count is: 1”}}]}
To be precise every message is getting failed for SQL enrichment.
Below is my sql enrichment config
{
"schema": "iglu:com.snowplowanalytics.snowplow.enrichments/sql_query_enrichment_config/jsonschema/1-0-0",
"data": {
"name": "sql_query_enrichment_config",
"vendor": "com.snowplowanalytics.snowplow.enrichments",
"enabled": true,
"parameters": {
"inputs": [
{
"placeholder": 1,
"json": {
"field": "contexts",
"schemaCriterion": "iglu:com.snowplowanalytics.iglu/anything-a/jsonschema/1-*-*",
"jsonPath": "$.question_id"
}
}
],
"database": {
"mysql": {
"host": "host",
"port": port,
"sslMode": false,
"username": "user",
"password": "password",
"database": "database"
}
},
"query": {
"sql": "select field1,field2... fieldn from questions_meta a inner join questions b on a.question_id = b.question_id AND a.question_id = ?"
},
"output": {
"expectedRows": "AT_MOST_ONE",
"json": {
"schema": "iglu:com.snowplowanalytics.iglu/anything-b/jsonschema/1-0-0",
"describes": "EVERY_ROW",
"propertyNames": "AS_IS"
}
},
"cache": {
"size": 3000,
"ttl": 60
}
}
}
}