JIRA duplicated none custom fields deletion

[tw]

Hi support team,

I have an issue of none-custom fields appearing on JIRA issues screen.

There are two fields called Attachments now, one which is right another one which might be left of recently add-on installed and uninstalled for trail reasons. Also, a 2nd field called Issue Deployment, that is left for same reason. Have a look at screenshots attached.

Both are none custom fields, so far cannot be eliminated easily. Even by JIRA update there is no chance of having vanished both.

Since they both appear in every project and every issue, those fields seem to be database persistent. I am still using the JIRA internal H2 db.

My question now would be how to eliminate both fields of the H2 db?

Thanks in advance for supporting.

Regards

tw

[Earl McCutcheon · Accepted solution]

Hi Tobias,

The H2 Database is highly volatile as susceptible to corruption as it is an in memory database, and any hiccup in the memory can completely cripple the data, which is why H2 is only recommended to front end system evaluation only.  When errors occur on a H2 database the best course of action is to delete the instance and start over.  And on the surface this looks like data corruption has occurred.

If this is production data accidentally stored on an H2 database, I would recomend attempting to migrate the data to an alternate database supported by the platform, the process to do this is covered in the documentation "Switching databases" as your best coarse of action.

Alternatively, and I do not have any specific examples of the syntax for this but if you wanted to attempt to correct the error in the h2 DB, steps to access the database can be found In this KB, and then refer to the H2 documentation for the syntax to do a Delete on the duplicate value from the 'customfield' table 'H2 Documentation can be found here'

Regards,
Earl

[tw]

Hi Earl,

thanks a lot for replying so fast. Appreciate.

Well, honestly, it's my fault to have had worked for so long on h2. But I need to repair prior to transfer.

I could manage to open the db by gui. But I could not find the right syntax neither for 'customfield' table nor for applying delete command, opening the documentation you suggested. Sorry, that's new to me.

Could you please assist once more where and how to check out this table? First, I need to check where the values are located, prior to deletion.

Regards

tw