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
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
The "serviceconfig" table is storing initial information. I would like to be sure that deleting the row from it will delete and disable service.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.