Content not getting deleted from DB after migrating to AdvanceFileSystemSto

[Henal Saraiya, modificado hace 9 años.]

Hi,

In our project we have migrated our content from JCRStore(DataBase) -> AdvanceFileSystemStore. After successful migration we are able to upload content via AdvanceFileSystemStore. Seems like migration was successful.

However after migration size of the database should get reduced as we have migrated content to AdvanceFileSystemStore. But size of the Database remains as it is. It seems that the data after migration should have been deleted from the origin, in this case, db. But its still there.

Has anyone faced similar problem? Is there any way available in Liferay which automatically deletes content from the database after successful migration? Or manually we need to delete content from Database?if so, which all table's we need to clean up?

Thanks in advance.

Regards,
Henal Saraiya

[Vilmos Papp, modificado hace 9 años.]

I think there's no delete after successful migration. You could delete the JCRStore's tables if you are sure.

Regards,
Vilmos

[Henal Saraiya, modificado hace 9 años.]

Hi Vilmos,

Thank you for the prompt reply.

I believe below are the tables we need to manually delete. Is this true?

dbo.J_FS_LIFERAY_FSENTRY
dbo.J_PM_LIFERAY_BINVAL
dbo.J_PM_LIFERAY_BUNDLE
dbo.J_PM_LIFERAY_NAMES
dbo.J_PM_LIFERAY_REFS
dbo.J_R_FS_FSENTRY
dbo.J_V_FS_FSENTRY
dbo.J_V_PM_BINVAL
dbo.J_V_PM_BUNDLE
dbo.J_V_PM_NAMES
dbo.J_V_PM_REFS

Can you please share your thoughts on same?

Thanks,
Henal Saraiya

[Vilmos Papp, modificado hace 9 años.]

Hi,

I would create a DB dump, just for sure, but if you checked that all of your documents are successfully copied to the new place, you can delete them. I think you can check the tables names from jackrabbit's workspace xml, but those table names you mentioned are look to be right.

[Henal Saraiya, modificado hace 9 años.]

Thanks Vilmos for your inputs.

Yes, migration was successful.

So far, it seems to be working fine after manually deleting tables and database shrink.

Thanks once again.

Regards,
Henal Saraiya