Registry Error on Database Schema Update
search cancel

Registry Error on Database Schema Update


Article ID: 131783


Updated On:


CA Application Test CA Continuous Application Insight (PathFinder)


When DevTest Registry is started, it fails with Schema upgrade failed error messages in registry.log.
2019-05-06 20:34:05,118Z (15:34) [main] INFO System.out - [DevTest AGENT:][INFO][1996][13][main][May 6, 2019 3:34:05 PM] Checking DevTest Agent schema 
2019-05-06 20:34:05,149Z (15:34) [main] ERROR System.err - [DevTest AGENT:][ERROR][1996][13][main][May 6, 2019 3:34:05 PM] !!!!!!!! Database upgrade in progress or failed !!!!!!!! 
2019-05-06 20:34:06,228Z (15:34) [main] ERROR System.err - [DevTest AGENT:][ERROR][1996][13][main][May 6, 2019 3:34:06 PM] Schema upgrade failed: java.sql.SQLException
2019-05-06 20:34:07,275Z (15:34) [main] ERROR System.err - [DevTest AGENT:][ERROR][1996][13][main][May 6, 2019 3:34:07 PM] DB error... No transactions will be saved there 
2019-05-06 20:34:08,306Z (15:34) [main] ERROR com.itko.lisa.coordinator.TestRegistryImpl - Schema upgrade failed 
java.sql.SQLException: Schema upgrade failed 
at com.itko.lisa.remote.persist.SchemaPersister.createOrUpgradeSchemaIfNeeded( 
at com.itko.lisa.remote.persist.PersistManager.createSchemaIfNeeded( 
at com.itko.lisa.remote.persist.PersistManager.getSafeConnection( 
at com.itko.lisa.coordinator.TestRegistryImpl.main( 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at sun.reflect.NativeMethodAccessorImpl.invoke( 
at sun.reflect.DelegatingMethodAccessorImpl.invoke( 
at java.lang.reflect.Method.invoke( 
at com.exe4j.runtime.LauncherEngine.launch(Unknown Source) 
at com.exe4j.runtime.WinLauncher$ Source) 


All Supported DevTest Environments.


When DevTest is upgraded to a new version , schema upgraded.  But, when the components  with earlier version of DevTest  were started , it caused Schema upgrade issues.


Once migrated to the new version, the schema is changed to new version of DevTest and no earlier releases of DevTest can be configured to go against that database again. This is by design.

Need to drop all of the DevTest tables on the DB and have them created again. Once the tables are dropped, start the Registry again and all of the tables will get re-created.