I am getting an sql Exception Unique constraint violation SYS_IDX_57 in Jira 4.4.5

[srikanth Asoori maringanti]

Inside my program I have written the following statement

stmt.executeUpdate("INSERT INTO CUSTOMFIELDVALUE VALUES(10001,12800,12000,NULL,'0.46 Days',NULL,NULL,NULL,NULL)");

I think the error has came because I manually created the Id(10001).

My question is how in jira the id for CUSTOMFIELDVALUE TABLE IS CREATED

And also what is SYS_IDX_57?

[Naren · Accepted solution]

Hi Srikanth,

What is the error generated in the log? Please go through this link, you'll get a clear picture about JIRA Database Schema. Also check out the Example SQL Queries in JIRA.

[srikanth Asoori maringanti]

Thanks Naren for your help.

[Nic Brough -Adaptavist-]

You should also reverse out the SQL changes you made to restore functionality before you do anything else.

[srikanth Asoori maringanti]

Ok nic thanks a lot

[Renjith Pillai]

And Srikanth, to stress on the database part, please do not directly manipulate JIRA database. It can result in a broken JIRA installation and restore will be your only option.

[Nic Brough -Adaptavist-]

Could you please stop tagging things with "on demand" when you are NOT using OnDemand?

Anyway, yes, you should never update a Jira database with SQL unless you know exactly what you are doing. You probably have neglected to update the counter table sequence_value_item

Also, if you are going to use SQL on a Jira database, you MUST NOT have Jira running. I can't emphasise this enough - Jira MUST be offline, shutdown, inactive. When you restart it after executing the SQL, you will then need to re-index it

Stop your Jira now if it was running, update sequence_value_item, restart and reindex.