Environment
Products:
Novell Data Synchronizer
Novell Data Synchronizer Connector for Mobility
Novell Data Synchronizer Connector for GroupWise
SUSE Linux Enterprise Server 11
Configuration:
/var/lib/pgsql is mounted using iSCSI
Postgres database on iSCSI partition
Situation
Connectors and syncengine loose connection to the database
Postgres crashes after running for sometime
"rcpostgresql status " shows failed
"ps -aux | grep sql | grep -v grep " does not give any output
ERROR: "No database connection" in the /var/log/datasync/connectors/default.pipeline1.groupwise-Appinterface.log
Mobility works and then stops working after some time
Mails stop flowing to the Device from GroupWise and from GroupWise to Device
Resolution
Postgres may run for sometime and crash in the background if the connection to the database has been lost due to Input/Output error. Make sure that the partition the database is on is accessible and have good connection to the database. If the partition is on iSCSI make sure that iSCSI connection is stable and does not disconnect in the background. Check /var/log/messages to make sure that iSCSI connection is not being lost.
Additional Information
Notes:
Error in the /var/log/datasync/default.pipeline1.groupwise-Appinterface.log
2010-10-01 16:04:40.623 ERROR_VERBOSE [Thread-22] [gwconnectorlogic:822] [userID:] [eventID:] [objectID:] []<result>
<status>
<code>10</code>
<desc>No database connection</desc>
</status>
<event>
<metadata/>
</event>
</result>
<status>
<code>10</code>
<desc>No database connection</desc>
</status>
<event>
<metadata/>
</event>
</result>