Hibernate error while trying to restore a site.

I have a 1.5GB zip file of a site that I'm trying to restore in another site. Both Confluence 3.3 (Yes, I know old...I'm setting up a site to test upgrade procedures).

The source site completed the backup, thus I have this zip file. Trying to import it into the other site (from a zip file on the file system) goes for a while, then dies with this the message below.

1. Did some googling/searching. My wait timeout and interactive timeout for MySQL are both eight hours (28,800 seconds)

2. My proxy timeout is set to 30 minutes, so that's not the issue.

3. Related: how do I reset my database so I can try again? Going to wiki.domain.com/ now gives me a redirect loop with messages in the logs about "2012-08-13 00:07:51,835 ERROR [TP-Processor8] [atlassian.confluence.servlet.ConfluenceServletDispatcher] serviceAction There is no Action mapped for namespace /setup and action name complete"

2012-08-12 22:38:52,429 ERROR [Importing data task] [confluence.importexport.actions.ImportLongRunningTask] runInternal Failure during import
 -- referer: http://wiki-up.lab.whamcloud.com/setup/setup-restore-start.action | url: /setup/setup-restore-local.action | userName: anonymous | action: setup-resto
re-local
org.springframework.dao.DataAccessResourceFailureException: Hibernate operation: could not insert: [com.atlassian.confluence.core.BodyContent#2785411]; SQL []; Com
munications link failure

The last packet successfully received from the server was 357,882 milliseconds ago.  The last packet sent successfully to the server was 19,646 milliseconds ago.; 
nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 357,882 milliseconds ago.  The last packet sent successfully to the server was 19,646 milliseconds ago.
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 357,882 milliseconds ago.  The last packet sent successfully to the server was 19,646 milliseconds ago.

1 answer

1 accepted

It seems that this KB is related: https://confluence.atlassian.com/display/CONFKB/Getting+'Communications+link+failure'+CommunicationsException+Error+when+Making+XML+Backup

However, it's strongly recommended to perform a production backup instead of using the XML backup as this is known to be unreliable for large instances. The general steps that you need to do is:

  1. Create a database dump of your Confluence db using the db tool
  2. Restore the database and name it to something else
  3. Copy the Home Directory and paste it to a new location
  4. Edit the confluence-init.properties file in <Installation-Directory>/confluence/WEB-INF/classes/ and update confluence.home to point to your Confluence Home directory (see step 3)
  5. Edit confluence.cfg.xml to update the database name (see step 2)

The import/export page mentions that archives larger than 2GB were not supported. I assumed archives smaller were supported. I sync'ed the database, and rsync'ed the attachment and thumbnail directories over (in ~/data) and that seemed to bring everything over properly.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Tuesday in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

478 views 19 9
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you