Can you post us the last few lines in your /var/log/zarafa/server.log file after you try and start the service?

B.

Hi Ben

Thanks for your reply. I cannot recall exactly, when I tried to restart the server, but these were the error messages coming up:
Looks like LDAP connection problem and MySQL problem, also in connection to Zarafa search

Fri Sep 9 04:47:00 2016: [fatal ] Still waiting for 8 threads to exit
Fri Sep 9 04:47:08 2016: [error ] Not all objects in relation found for object 'user1'
Fri Sep 9 05:12:01 2016: [error ] Disconnect from LDAP because search error Can't contact LDAP server
Fri Sep 9 06:45:00 2016: [error ] Previous message logged 4 times

Fri Sep 9 09:34:15 2016: [error ] Error while connecting to search on file:///var/run/zarafa-search
Fri Sep 9 09:43:58 2016: [error ] Previous message logged 7 times
Fri Sep 9 09:43:58 2016: [fatal ] SQL [00134812] Failed: Duplicate entry '26080-\xC2\x1FO5.:C\xCF\x8A\xCES\x08\x0F\xF8 ...
Fri Sep 9 09:43:58 2016: [fatal ] ECDatabaseMySQL::_Update() query failed
Fri Sep 9 09:49:09 2016: [fatal ] SQL [00134805] Failed: Duplicate entry '26080-\xC2\x1FO5.:C\xCF\x8A\xCES\x08\x0F\xF8 ...
Fri Sep 9 09:49:09 2016: [fatal ] ECDatabaseMySQL::_Update() query failed
Fri Sep 9 09:52:00 2016: [error ] Disconnect from LDAP because search error Can't contact LDAP server
Fri Sep 9 09:56:30 2016: [error ] Error while connecting to search on file:///var/run/zarafa-search
Fri Sep 9 09:59:09 2016: [error ] Previous message logged 7 times
Fri Sep 9 09:59:09 2016: [fatal ] ECUserManagement::SearchObjectAndSync() unexpected id 17/15
Fri Sep 9 09:59:09 2016: [error ] Error while connecting to search on file:///var/run/zarafa-search

Fri Sep 9 22:35:43 2016: [fatal ] Still waiting for 8 threads to exit
Fri Sep 9 22:38:41 2016: [fatal ] ECDatabaseMySQL::Connect(): mysql connect fail 80000007
Fri Sep 9 22:38:41 2016: [fatal ] Unable to connect to database: Can't connect to MySQL server on '127.0.0.1' (111)
Fri Sep 9 22:39:00 2016: [error ] Not all objects in relation found for object 'user1'
Fri Sep 9 22:39:04 2016: [fatal ] Started to create store (userid=1, type=1)
Fri Sep 9 22:39:04 2016: [fatal ] createStore(): already exists
Fri Sep 9 22:39:04 2016: [fatal ] Failed to create store (id=1), errorcode=0x80000008
Fri Sep 9 22:45:01 2016: [error ] Disconnect from LDAP because search error Can't contact LDAP server
Fri Sep 9 22:52:02 2016: [fatal ] SQL [00000007] info: Try to reconnect
Fri Sep 9 22:52:02 2016: [fatal ] ECDatabaseMySQL::Connect(): mysql connect fail 80000007
Fri Sep 9 22:52:02 2016: [fatal ] ECDatabaseMySQL:oSelect(): query failed
Fri Sep 9 22:52:06 2016: [fatal ] Still waiting for 8 threads to exit

It is working now, but I still get these error messeges:


Sun Sep 11 22:38:16 2016: [error ] Previous message logged 61 times
Sun Sep 11 22:38:16 2016: [fatal ] ECDatabaseMySQL::_Update() query failed
Sun Sep 11 22:38:17 2016: [error ] Error while connecting to search on file:///var/run/zarafa-search

When I now (after it is working again) restart the service I get these messages:

Mon Sep 12 22:40:18 2016: [fatal ] Still waiting for 8 threads to exit
Mon Sep 12 22:40:36 2016: [error ] Not all objects in relation found for object 'user1'

and when I try to search someting:

Mon Sep 12 22:42:53 2016: [error ] Error while querying search on file:///var/run/zarafa-search, 0x80004005
Mon Sep 12 22:43:30 2016: [fatal ] RemoveStaleIndexedProp(): caller wanted to remove the entry, but we can't since it is in use

I have to say that Zarafa search was regularly not working as expected, but the server was normaly fine.

Thank you.

Best wishes,

Robert

p.s.: I reduced the number of users in the log file for better overview to user1.

That script you ran helps repair a table/trigger Zarafa uses that is susceptible to corruption.

Glad you got it working...Your search may improve by running the following:

V6

service zarafa-indexer stop

rm /var/lib/zarafa/index/*

service zarafa-indexer start

V7

service zarafa-search stop

rm /var/lib/zarafa/search/*

service zarafa-search  start

B

HI Ben,

Thanks a lot. This solved the search problem.

Best wishes,

Robert