Confluence Error after building Database

[Martin S.]

Server: Dell Poweredge T20
Hypervisor: Hyper-V
Memory: 8GB for confluence, 4GB for SQL
Processor: E3-1225v3 4 Quad-core CPU
OS: Debian 9.5
Database: PostgreSQL 9.6 or MySQL 5.7 both fail

The error:
Clean install of confluence on clean Debian along with a clean install of the database on a clean Debian. The linux 64-bit Installer was used for Confluence. These are two seperate hosts.
The database is created according the respective guides.
When connecting to the database it says no probs and I can click next. I click Next and it starts thinking for a while. Then it moves to the next step where you choose new site or restore from a backup, but this page looks as if all CSS has been lost. At this point the error has already occured.  

When accessing the page from this point it throws an error on the website saying "Oops an error occured" with the following error: 

java.lang.IllegalStateException: Cannot call sendError() after the response has been committed

The following is from the atlassian-confluence.log

2018-09-17 13:46:44,546 INFO [localhost-startStop-1] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve
2018-09-17 14:05:02,615 INFO [http-nio-8090-exec-4] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
2018-09-17 14:05:06,729 INFO [http-nio-8090-exec-4] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
2018-09-17 14:05:20,486 INFO [http-nio-8090-exec-4] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization completed in 17870 ms
2018-09-17 14:05:20,518 INFO [http-nio-8090-exec-4] [atlassian.plugin.manager.DefaultPluginManager] shutdown Preparing to shut down the plugin system
2018-09-17 14:05:20,519 INFO [http-nio-8090-exec-4] [atlassian.plugin.manager.DefaultPluginManager] shutdown Shutting down the plugin system
2018-09-17 14:05:20,591 INFO [http-nio-8090-exec-4] [atlassian.plugin.manager.DefaultPluginManager] earlyStartup Plugin system earlyStartup begun
2018-09-17 14:05:20,704 WARN [http-nio-8090-exec-4] [osgi.container.felix.ExportsBuilder] getUrlClassPath Cannot deep scan non file 'http://felix.extensions:9/'
 -- referer: http://192.168.10.105:8090/setup/setupdbtype-start.action | url: /setup/setupdbtype.action | traceId: 00cfcca6f5a6e7c1 | userName: anonymous | action: setupdbtype
2018-09-17 14:05:46,506 WARN [ThreadPoolAsyncTaskExecutor::Thread 7] [spring.scanner.util.ProductFilterUtil] detectProduct Couldn't detect product, will use ProductFilter.ALL
 -- referer: http://192.168.10.105:8090/setup/setupdbtype-start.action | url: /setup/setupdbtype.action | traceId: 00cfcca6f5a6e7c1 | userName: anonymous | action: setupdbtype
2018-09-17 14:05:46,708 WARN [ThreadPoolAsyncTaskExecutor::Thread 10] [spring.scanner.util.ProductFilterUtil] detectProduct Couldn't detect product, will use ProductFilter.ALL
 -- referer: http://192.168.10.105:8090/setup/setupdbtype-start.action | url: /setup/setupdbtype.action | traceId: 00cfcca6f5a6e7c1 | userName: anonymous | action: setupdbtype
2018-09-17 14:06:04,813 INFO [http-nio-8090-exec-4] [atlassian.plugin.manager.DefaultPluginManager] logTime Plugin system earlyStartup ended
2018-09-17 14:06:12,391 ERROR [http-nio-8090-exec-3] [engine.jdbc.spi.SqlExceptionHelper] logExceptions Table 'confluencedb.BANDANA' doesn't exist
 -- url: /bootstrap/selectsetupstep.action | traceId: 0039ef300e6a0a7a | userName: anonymous
2018-09-17 14:06:12,406 WARN [http-nio-8090-exec-3] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
 ->[com.atlassian.confluence.setup.bandana.ConfluenceDaoBandanaPersister.retrieve]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,readOnly (Session #1360333538)
 -- url: /bootstrap/selectsetupstep.action | traceId: 0039ef300e6a0a7a | userName: anonymous
2018-09-17 14:06:12,422 WARN [http-nio-8090-exec-3] [confluence.impl.vcache.SynchronousExternalCache] lambda$get$11 Failed to read entry from cache 'com.atlassian.bandana.BandanaPersister': Failed due to UNCLASSIFIED_FAILURE
 -- url: /bootstrap/selectsetupstep.action | traceId: 0039ef300e6a0a7a | userName: anonymous
2018-09-17 14:06:12,434 ERROR [http-nio-8090-exec-3] [engine.jdbc.spi.SqlExceptionHelper] logExceptions Table 'confluencedb.BANDANA' doesn't exist
 -- url: /bootstrap/selectsetupstep.action | traceId: 0039ef300e6a0a7a | userName: anonymous
2018-09-17 14:06:12,436 WARN [http-nio-8090-exec-3] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
 ->[com.atlassian.confluence.setup.bandana.ConfluenceDaoBandanaPersister.retrieve]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,readOnly (Session #1307137342)
 -- url: /bootstrap/selectsetupstep.action | traceId: 0039ef300e6a0a7a | userName: anonymous
2018-09-17 14:06:12,443 ERROR [http-nio-8090-exec-3] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action
 -- url: /bootstrap/selectsetupstep.action | traceId: 0039ef300e6a0a7a | userName: anonymous
java.util.concurrent.CompletionException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

When checking the database I can see that 105 tables have been created. 

Tried chmod -R 777 installation and home dirs before installing.

Any ideas? 

Thanks in advance

[Alexis Robert · Accepted solution]

Hi @Martin S., 

the logs aren't really telling much but I'm thinking that you could maybe check if your java binary is properly set to the one bundle with Jira (so not the openjdk one that is shipped by default with Debian).

I found that it sometimes helps to set the JAVA_PATH directly in your start-jira.sh script to point to the Oracle jre.

Let me know if this helps, 

--Alexis

[Martin S.]

Hello Alexis, that worked perfectly, thank you so much! :-)

For others:

I changed confluence file"/opt/atlassian/confluence/bin/setenv.sh" to point  $JRE_HOME to the bundled option: "/opt/atlassian/confluence/jre/" instead of the system default.

[Vikas Pandey]

For the record: Just letting confluence recreate entire tables again after removing existing confluence-cfg.xml should work next time.