topic MySQLNonTransientConnectionException while doing FULL Re-indexing. in Alfresco Archive

MySQLNonTransientConnectionException while doing FULL Re-indexing.

faizaan — Mon, 18 Mar 2013 07:58:55 GMT

Hi,We are getting "com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException" while performing full re-indexing of repository.Full Error Logs : 16:16:47,698 INFO [node.index.FullIndexRecoveryComponent] Index recovery started: 156,296 transactions.16:18:15,900 INFO [node.index.FullInde

Re: MySQLNonTransientConnectionException while doing FULL Re-indexing.

mitpatoliya — Mon, 18 Mar 2013 09:00:15 GMT

It seems like mysql db server not responding after some time.
I suggest you one thing.
Just change the db connection properties which are required to be changed don't override all the properties.
Same with the lucene unless you are not sure about the property better go with default value.

Re: MySQLNonTransientConnectionException while doing FULL Re-indexing.

faizaan — Mon, 18 Mar 2013 09:32:15 GMT

Hi Mits,

Thanks for the quick reply !

We have not changed any properties related to db in repository.properties, I have added those just for information they are all having there default values that are set in OOTB alfresco 3.4.3.

Yes, we have overriden some lucene related properties by adding it to alfresco-global.properties that are mentioned in previous post.

Thanks !
Faizaan