Hi All,
I upgrade sonarqube from 8.2 to 8.3 and I have a trouble with running analyze of any of projects. I always receives this error.
errorMessage "\n### Error committing transaction. Cause: org.apache.ibatis.executor.BatchExecutorException: org.sonar.db.measure.LiveMeasureMapper.upsert (batch index #1) failed. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into live_measures (\n uuid,\n component_uuid,\n project_uuid,\n metric_id,\n value,\n text_value,\n variation,\n measure_data,\n created_at,\n updated_at\n ) values (\n 'AXRoLqfVrs09vy-XHvQy',\n 'AXGr9joo9id5DQJABnuF',\n 'AXGr9joo9id5DQJABnuF',\n 46,\n NULL,\n NULL,\n 37.5,\n NULL,\n 1599475722197,\n 1599475722197\n )\n on conflict(component_uuid, metric_id) do update set\n value = excluded.value,\n variation = excluded.variation,\n text_value = excluded.text_value,\n measure_data = excluded.measure_data,\n updated_at = excluded.updated_at\n where\n live_measures.value is distinct from excluded.value or\n live_measures.variation is distinct from excl"
Hi Rafal
We just updated our license and we’re suddenly getting a very similar if not identical error.
Blockquote * errorMessage: " ### Error committing transaction. Cause: org.apache.ibatis.executor.BatchExecutorException: org.sonar.db.measure.LiveMeasureMapper.upsert (batch index #1) failed. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into live_measures ( uuid, component_uuid, project_uuid, metric_id, value, text_value, variation, measure_data, created_at, updated_at ) values ( ‘AXZ21ATzJuDXOJnmtqN1’, ‘AWX3jRSZkzatdvha_4WT’, ‘AWX3jQagWGMK4q6NPaUv’, 43, 55.3, NULL, NULL, NULL, 1608311375091, 1608311375091 ) on conflict(component_uuid, metric_id) do update set value = excluded.value, variation = excluded.variation, text_value = excluded.text_value, measure_data = excluded.measure_data, updated_at = excluded.updated_at where live_measures.value is distinct from excluded.value or live_measures.variation is distinct from excl",
Are there any admins that can help with this please? I’ve tried restarting the server, still the same issue.
We’re now in a position where none of our build jobs will go through 
Hi. Any updated on this issue? Encountered same issue when executing Sonar analysis with Jenkins. Sonar 8.6.0.39681 & Postgres 12.5
### Error committing transaction. Cause: org.apache.ibatis.executor.BatchExecutorException: org.sonar.db.measure.LiveMeasureMapper.upsert (batch index #1) failed. Cause: java.sql.BatchUpdateException: Batch entry 0 insert into live_measures