Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Confluence Error after building Database Edited

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

2 answers

1 accepted

1 vote
Answer accepted
Alexis Robert Community Leader Sep 17, 2018

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

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.

0 votes
Vikas Pandey Atlassian Team Feb 06, 2020

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence Cloud

Please tell us how you use Confluence space settings

👋 Hi there, a few of us at Atlassian would love to learn about how you use "space settings" functionality in Confluence. A facelift to the space settings is long overdue and we want to start with im...

183 views 6 6
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you