topic JDBC Error every day at 3:00 am in Alfresco Archive

JDBC Error every day at 3:00 am

tonytony — Thu, 13 Sep 2007 18:45:47 GMT

I get this error every day for the last two weeks or so.03:01:15,406 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC commit failedcom.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Communications link failure during commit(). Transaction resolution unknown. at com.mysql.jdbc.SQ

Re: JDBC Error every day at 3:00 am

mikeh — Thu, 13 Sep 2007 19:19:19 GMT

Hi,

Bit of a guess, but Windows Update tends to schedule itself for 3am. Have you also got anything like a firewall or anti-virus that might be updating overnight too? i.e. something that might reset the network connection.

Thanks,
Mike

Re: JDBC Error every day at 3:00 am

tonytony — Tue, 18 Sep 2007 12:16:12 GMT

I thought I had it licked, but I'm still getting this error.

My question is, what exactly is Alfresco doing at exactly 3am every night? rebuilding indexes?

Re: JDBC Error every day at 3:00 am

mikeh — Tue, 18 Sep 2007 14:25:04 GMT

The indexes get backed up at 3am, but I wonder if this is clashing with something else happening on your system?

You can try changing the time this happens by overriding/editing the job in scheduled-jobs-context.xml

Thanks,
Mike

Re: JDBC Error every day at 3:00 am

tonytony — Wed, 19 Sep 2007 11:55:08 GMT

mike:

I traced this to a flaky mySQL implementation.
Thanks for your help and insight.

My other question is, should an intermittent loss of the database be fatal to the application? (It appears it only crashes alfresco when backing up the indexes)

Thanks again for your help.

Re: JDBC Error every day at 3:00 am

mikeh — Wed, 19 Sep 2007 12:59:53 GMT

My other question is, should an intermittent loss of the database be fatal to the application? (It appears it only crashes alfresco when backing up the indexes)

Losing the database connection temporarily shouldn't be fatal to the application during normal use, as we use transactions throughout (you may see an exception in the web client).

If you're seeing the whole application crash during the backup procedure, then that sound like a problem that should be raised in JIRA

thanks,
Mike

Re: JDBC Error every day at 3:00 am

tonytony — Tue, 25 Sep 2007 13:21:06 GMT

Tomcat and MySQL are running on the same partition (server).

The alfresco repository is on another larger partition.

It looks like during the backup procedure, the 'server' partition ran out of disk space.

Solution: move the mysql data folders to the larger partition.

seems to be working ok now. Looks like it was specific to my environment.

Thanks for all your help troubleshooting.