How to manually remove service in Jira

ARM Ltd. (old account) November 13, 2014

Hi

I am trying to figure out how to manually remove service from JIRA MySQL database?

I am cloning the Production JIRA instance for the QA Purposes using automates script.

During the Clone I am cleaning up a lot of stuff like changing the Name, URL, removing App links.

Also I would like to remove couple of services to be sure that they are not running on QA instance.

I can delete them manually but it will be nice to delete them prior starting instance after populating database from production dump.

Regards,

Areg

2 answers

2 votes
ARM Ltd. (old account) November 13, 2014

I hope that I figured it out:

 

SELECT ID
FROM serviceconfig
WHERE CLAZZ = 'com.onresolve.jira.groovy.GroovyService'

 

Based on "propertytype" field in "propertyentry" table determine which kind of entry it is - 5 is strings in "propertystring" table.

SELECT *
FROM propertyentry
WHERE ENTITY_NAME = 'ServiceConfig'
  AND ENTITY_ID IN
  (SELECT ID
   FROM serviceconfig
   WHERE CLAZZ = 'com.onresolve.jira.groovy.GroovyService'
  )
DELETE
from propertystring
where ID in
  (select ID
   from propertyentry
   where ENTITY_NAME = 'ServiceConfig'
     and ENTITY_ID in
     (select ID
      from serviceconfig
      where CLAZZ = 'com.onresolve.jira.groovy.GroovyService'
     )
  )
DELETE
FROM propertyentry
WHERE ENTITY_NAME = 'ServiceConfig'
  AND ENTITY_ID IN
  (SELECT ID
   FROM serviceconfig
   WHERE CLAZZ = 'com.onresolve.jira.groovy.GroovyService'
  );
DELETE
FROM serviceconfig
WHERE CLAZZ = 'com.onresolve.jira.groovy.GroovyService';

 

Hope this will help if anyone need to do this too.

 

Regards,

Areg

0 votes
ARM Ltd. (old account) November 13, 2014

The "serviceconfig" table is storing initial information. I would like to be sure that deleting the row from it will delete and disable service.

Suggest an answer

Log in or Sign up to answer