I am on a clean install of 4.5.3 trying to migrate from the default database to PostgreSQL. The connection test works and the operation says Database migration successful with the following error (possibly unrelated):
Adding database constraints...
Updating database to latest version...
Switching to new database at: jdbc:postgresql://localhost:5432/crucible...
Complete
Failed to restore ActiveObjects backup :org.postgresql.util.PSQLException: This ResultSet is closed.
After clicking OK, the page refreshes to blank (URL is http://server:8060/admin/database.do) with title FishEye and Crucible - 500 Server Error. On restarting the service I get the following from stderr.txt
2019-10-22 12:50:22 Commons Daemon procrun stderr initialized
Exception in thread "Thread-2" org.springframework.context.ApplicationContextException: Application Context not initialised.
at com.cenqua.fisheye.config.SpringContext.getApplicationContext(SpringContext.java:51)
at com.cenqua.fisheye.config.SpringContext.getComponentByClass(SpringContext.java:90)
at com.cenqua.fisheye.config.RootConfig.getRepositoryManager(RootConfig.java:600)
at com.cenqua.fisheye.config.RootConfig.shutDownRepositories(RootConfig.java:1287)
at com.cenqua.fisheye.ctl.ShutdownService.stopImpl(ShutdownService.java:281)
at com.cenqua.fisheye.ctl.ShutdownService.access$000(ShutdownService.java:35)
at com.cenqua.fisheye.ctl.ShutdownService$1.run(ShutdownService.java:59)
and stdout.txt
2019-10-22 12:51:06,133 INFO - Your license expires in 29 days
2019-10-22 12:51:08,021 INFO - Adding secondary content dir of C:\Program Files\Atlassian\Application Data\Crucible\content
2019-10-22 12:51:19,813 INFO - Starting database...
2019-10-22 12:51:21,033 INFO - BoneCP - tracking statements enabled for pool [mainPool]
2019-10-22 12:51:24,398 INFO - BoneCP - tracking statements enabled for pool [retriablePool]
2019-10-22 12:51:26,137 INFO - Database started.
2019-10-22 12:51:30,250 INFO - Using synchronous global permission cache reload policy
2019-10-22 12:51:30,516 INFO - Starting plugin system...
2019-10-22 12:51:37,928 ERROR - The Web context could not be started
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quickSearchService': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userSearcher' defined in URL [jar:file:/C:/Program%20Files/Atlassian/Crucible/fisheye.jar!/com/atlassian/fecru/search/quicknav/UserSearcher.class]: Unsatisfied dependency expressed through constructor argument with index 0 of type [com.cenqua.fisheye.user.UserManager]: : Error creating bean with name 'userManager': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire method: public void com.cenqua.fisheye.user.DefaultUserManager.setCommitterUserMappingManager(com.cenqua.fisheye.model.manager.CommitterUserMappingManager); nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'committerUserMappingManager': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.cenqua.fisheye.config.RepositoryManager com.cenqua.fisheye.model.manager.CommitterUserMappingManagerImpl.repositoryManager; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repositoryManager': Invocation of init method failed; nested exception is org.hibernate.exception.JDBCConnectionException: Could not open connection; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userManager': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire method: public void com.cenqua.fisheye.user.DefaultUserManager.setCommitterUserMappingManager(com.cenqua.fisheye.model.manager.CommitterUserMappingManager); nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'committerUserMappingManager': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.cenqua.fisheye.config.RepositoryManager com.cenqua.fisheye.model.manager.CommitterUserMappingManagerImpl.repositoryManager; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repositoryManager': Invocation of init method failed; nested exception is org.hibernate.exception.JDBCConnectionException: Could not open connection
Related cause: org.springframework.beans.factory.BeanCurrentlyInCreationException: Error creating bean with name 'backup': Requested bean is currently in creation: Is there an unresolvable circular reference?
If there is a way to initialize with a PostgreSQL database, instead of being forced to one and then migrating, I may be able to avoid this problem. Anyone have any ideas? Thank you
Update: I tried backup/restore via fisheyectl.bat with similar results. I no longer got the "Failed to restore ActiveObjects backup" error, but the restore operation still throws the above exception (from stdout.txt).
Update 2: Maybe similar to https://community.atlassian.com/t5/Fisheye-Crucible-questions/Crucible-4-3-crash-on-service-start-Application-Context-not/qaq-p/459120