confluence 5.5 and mysql : table after plugindata doesn't exist anymore ...

Dear community,

Yesterday, i attempted to upgrade my confluence 5.4 to 5.5. I was completely aware about the procedure, and ensure a backup was done ( mysqldump daily ). BUT, table plugindata was corrupted.. and from a moment the tables below plugindata was empty ..

During the migration, i saw the install block on plugindata table .. so.. i attempted after to restore a dump backup i had.

Result : tables spaces, credentials etc ... dissapear.. yesteray night was an headache for me. I also experimented the method described in https://confluence.atlassian.com/display/DOC/Site+Administrators+and+their+Permissions.

No acces, please, How can i reconstruct just one space with all the articles i had, and one user admin who have the full permission in all my datas inside ?

Thanks a lot for your patience,

Bests,

Guillaume.

6 answers

This widget could not be displayed.

just for information, after following the article relative to create a local admin, it didn't work for me ...

This widget could not be displayed.
Stephen Sifers Community Champion Apr 30, 2014

You can restore your DB to another server and bring up a "new" instance of confluence on your restored DB. From there you can then extract the space in question.

This widget could not be displayed.

all tables below plugindata don't exist, so : SPACEGROUPPERMISSIONS SPACEGROUPS SPACEPERMISSIONS SPACES TRACKBACKLINKS TRUSTEDAPP TRUSTEDAPPRESTRICTION cwd_app_dir_group_mapping cwd_app_dir_mapping cwd_app_dir_operation cwd_application cwd_application_address cwd_application_attribute cwd_directory cwd_directory_attribute cwd_directory_operation cwd_group cwd_group_attribute cwd_membership cwd_user cwd_user_attribute cwd_user_credential_record external_entities external_members groups hibernate_unique_key local_members logininfo os_group os_user os_user_group remembermetoken user_mapping users ... are empty ...

This widget could not be displayed.

What do you mean ? i create a new instance of confluence, then i merge my old db with the new one ?
My problem is that : How confluence use the DB ? where can i find a semantic diagram of the DB, with that i can understand witch tables i can merge for having more chance to recover... no ?

Stephen Sifers Community Champion Apr 30, 2014

No, you will create a new instance of confluence on a seperate server then restore your backed up database to that. From there you will access the newly restores confluence instance and recover your space.

I would not suggest merging your backup with your production instance as that may cause other issues since the versions are different.

ok, understood. Il will try. So, i install an instance in a other server.. and import my mysql dump into it , then i can recover my datas .. correct ?

Stephen Sifers Community Champion Apr 30, 2014

Yes.

Spin up a new instance, restore the backup from your production prior to the upgrade. Make sure the new instance matches the version prior to the upgrade.

This widget could not be displayed.

Ok, i do what you told me. I resintall a confluence 5.4.1, restore var, and inject my corrupted backup into it. Confluence works, i can see articles in research, but not possible to open them. any idea ? He says :

for some :

system error :

net.sf.hibernate.LazyInitializationException: Exception initializing proxy: [com.atlassian.confluence.spaces.Space#5472259]
at net.sf.hibernate.proxy.LazyInitializer.initializeWrapExceptions(LazyInitializer.java:64)

caused by: net.sf.hibernate.ObjectNotFoundException: No row with the given identifier exists: 5472259, of class: com.atlassian.confluence.spaces.Space
at net.sf.hibernate.ObjectNotFoundException.throwIfNull(ObjectNotFoundException.java:24)

for other : page not found..

This widget could not be displayed.

Ok, i do what you told me. I resintall a confluence 5.4.1, restore var, and inject my corrupted backup into it. Confluence works, i can see articles in research, but not possible to open them. any idea ? He says :

for some :

system error :

net.sf.hibernate.LazyInitializationException: Exception initializing proxy: [com.atlassian.confluence.spaces.Space#5472259]
at net.sf.hibernate.proxy.LazyInitializer.initializeWrapExceptions(LazyInitializer.java:64)

caused by: net.sf.hibernate.ObjectNotFoundException: No row with the given identifier exists: 5472259, of class: com.atlassian.confluence.spaces.Space
at net.sf.hibernate.ObjectNotFoundException.throwIfNull(ObjectNotFoundException.java:24)

for other : page not found..

Stephen Sifers Community Champion May 01, 2014

It sounds like the next step would be to open a case with atlassian support for them to check into the issue.

<cite>https://<strong< a="">>support.atlassian.com/</cite>

Sorry I could not be more help.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 17, 2018 in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

555 views 7 6
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