MySQL database connectivity issue

zladuric — Tue, 01 Dec 2009 17:43:11 GMT

Hello, I have a working alfresco (3.0 I believe) and I've tried to do the backup_and_restore procedure to make a copy of alfresco on the development box. I'm constantly hitting the wall here with database connectivity.My problem is, I believe, that after hibernate (or whatever) makes its 10 connect

Re: MySQL database connectivity issue

sebp — Wed, 02 Dec 2009 07:48:37 GMT

I would concentrate on these lines in the error log:

18:23:16,715 Userystem WARN [node.index.FullIndexRecoveryComponent] The indexes are not synchronized with the database.
18:23:16,850 Userystem WARN [node.index.AVMFullIndexRecoveryComponent] Index for avm store sitestore is out of date
18:23:17,421 Userystem INFO [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /opt/alf_data
18:23:17,463 Userystem ERROR [repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: Indexes not found for 7 stores.
18:23:17,463 Userystem INFO [repo.admin.ConfigurationChecker] You may set 'index.recovery.mode=FULL' if you need to rebuild the indexes.
18:23:17,463 Userystem ERROR [repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: System content not found in content store.
18:23:17,463 Userystem ERROR [repo.admin.ConfigurationChecker] Ensure that the 'dir.root' property is pointing to the correct data location.

You have the hint "Ensure that the 'dir.root' property is pointing to the correct data location." in your error logs. This hint may also appear if the content of the dir.root directory does not match the contents of the database. Maybe you made some mistake while copying the dir.root directory or the database. Besides did you try to do a full index recovery?

Re: MySQL database connectivity issue

zladuric — Wed, 02 Dec 2009 16:26:38 GMT

Bah, I don't get this forum, I thought I posted the answer already!

Anyway, thanks for the assistance. I'll try with reindexing, hopefully it'll work (already did try, but got some OOM's on my devel machine).

topic Re: MySQL database connectivity issue in Alfresco Archive

MySQL database connectivity issue

Re: MySQL database connectivity issue

Re: MySQL database connectivity issue