Ensure that the 'dir.root' property is pointing to the correct data location.

[rguduri]

After restarting the server where alfresco application got installed it stopped functioning. Ensured everything is fine with the tomcat and postgres but the issue didn't resolve, throwing CONTENT INTEGRITY ERROR. Attached the log file for the same. Version am using is 4.2.c. This application has been functioning from last couple of years without any problem and restarted the server where this application deployed several times in past also, but used to function without any issue. I did back up very long time ago, so I have to loose much of data if I go back and replace with my last backup.

From the community got to know that this integrity error occurs when there is inconsistency between databse and alf_data content, but am sure that except restarting the server did nothing. And  also followed the suggestion of similar instances i.e, changing the property index.recovery.mode to all modes i.e., FULL, AUTO, NONE but no resolution. Please suggest where to look for ?

[mehe]

I never tried to restore alfresco without contentstore, because there are also (system) files alfresco needs to work.

Alfresco partially checks the content store integrity on startup. I think that there is a config parameter to disable this check. But I don't think this is a good idea - also the repository does not make much sense without content.

[rocklee44]

Thanks for your reply Martin Ehe,

In this case I attempt to update my ECM to latest version 201707 (community) so I want to test it first.
I tried google how to disable content store integrity check but no results. I think forcing restore alfresco with full content store integrity for testing is quite complex.

Beside, how should content store integrity checking be good enough ? What if there are some in consistences exist between my database and my content store ?  1, 2, 3 or some files exist in my db but no longer in content store ?
My ECM has run since 2014, the content store size becomes bigger year by year,so if I don't need data from 2014 and 2015 anymore , I should remove them from ECM first then let trashcan cleaner does the rest ?

[mehe]

I have some repositories that are using content stores > 3TB and used a script that checks the integrity by going through the alf_content_url table and the filesystem. That takes some time, so it runs only once a week. But this is good enough to restore eventually missing files from the backup.

When test-upgrading, I usually use - at least - the oldest contentstore directories, because most of the system-files are there. But if you used dynamic models, it's also possible that your model xml is stored in the content store (I think, but I never checked that).

Also parts of your sites system files are stored there. 

Cleaning up your repository before the upgrade is a good idea . You can also delete the content store.deleted subdirs...  

By the way, how do you backup your content store? what about mounting an old backup as "Teststore" and fill it up with your newer files and dirs.

[rocklee44]

Here my "hot" backup schedule - I use bacula to get files from ECM server to backup server:

- /opt/alfresco-5.0.b and /opt/contentstore are backup full on 6:00 AM every Sunday , incremental on 5:00AM from Monday to Saturday .

- "alfresco" mysql database is backup full on 2:00 AM every Sunday , incremental on 2:00 AM from Monday to Saturday (binary log is enabled).

So I guess : /opt/alfresco-5.0.b and /opt/contentstore full backups and "alfresco" mysql database dump file on Sunday are good enough for testing . My content store is about 350 GB and I think it's unfavorable , you know , have at least - the oldest content store for test-upgrading.

But I will try again, restore Sunday backups (including content store) to test server and see if it works.

Thank you very much Martin.