Can't delete custom field

igor m_n6p9ae

We are trying to delete custom field (Text Field (multi-line)) from Jira and it fails.

Seems like it is being stuck on DeleteCustomField.jspa page.  looks like it starts deleting the custom field and than just shows blank page. no errors in the log, no javascript errors on the page.

We do see that custom field context has been deleted, but the field itself still shows in the custom field list.

we did try to use direct link:  http://YourJiraBaseURL/secure/admin/DeleteCustomField!default.jspa?id=****, but that changes nothing. still can't delete the field.

What else can we do to resolve the problem?

Can we  delete the field directly from the database?

i assume we need to do something like this:

1. select * from customfield where cfname = '***' //   id =16142
2. delete from customfieldoption where customfield = 16142 // select returns  0 records
3. delete from customfieldvalue where customfield = 16142   // select returns 97,624 records
4. delete from customfield where cfname = '***'

is this safe to delete the field like this?  are there any other tables affected we need to look at?

Thanks for your help.

 

Italo Qualisoni [e-Core]

Hi @igor m ,

You should delete the custom field using the UI. It is not safe to do it directly on the database ( there is another question here)

The only reason I see you modifying database directly is following a knowledge base or when asked directly from the support, but with always a backup prior the change and running in a staging environment.

When you say : " looks like it starts deleting the custom field and than just shows blank page"

> In case you run JIRA behind a proxy, this could be the reason. This action usually takes time and if this time exceeds the proxy timeout limit you will have this behavior (sometimes you will have a 504 Gateway Timeout Error).

Notice that this won't stop the delete process, so if this is the case you can wait to see if the field has been deleted. You can check if with query if the field is being deleted, this should return 0

select count(*) from customfieldvalue where customfield = 16142 ;