how do you get the database out of read only mode to run the delete?

[James Fox]

This question is in reference to Atlassian Documentation: Project Import fails with Unexpected import failure

how do you get the database out of read only mode to run the delete? I'm using the inbuilt DB

[Nic Brough -Adaptavist- · Accepted solution]

You don't.  There is no "read only" mode for the internal database (there isn't for external ones either - JIRA won't start if you hook it up to a database it can't get full read/write access to)

I suspect what you need to do is shut down JIRA completely, then connect your database editing tool to the hsql/h2 database in read/write mode (if the tool has any distinction) to do the edits.

[Saqib Ahmad]

while connecting to H2 db,  you need to set access mode in JDBC URL as:

jdbc:h2:file:C:\Program Files\Atlassian\Application Data\JIRA/database/h2db;ACCESS_MODE_DATA=rws

or

String url = "jdbc:h2:~/test;ACCESS_MODE_DATA=rws";

ACCESS_MODE_DATA=rws will enable your delete permission.

[Pierre KANOHA]

It is easy, run the application you're using to work on this DB in admin mode (you should have the admin rights of your session/system too)