How to manually remove service in Jira

Question

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

ARM Ltd. (old a · Answer

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

ARM Ltd. (old a · Answer

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