[opencms-dev] Failed to write locks to database

[Nuno Fernandes]

On Tuesday 22 January 2008 23:13:43 RuiXian BAO wrote:
> Hello,
>
> On 1/22/08, Nuno Fernandes <npf-mlists at eurotux.com> wrote:
> > Hi,
> >
> > I'm having this problem:
> >
> > 21 Jan 2008 19:06:40,146 ERROR [rg.opencms.main.CmsThreadStore: 190]
> > Failed to
> >
> > write locks to database.
>
> Is your database still up and running? Can you connect to it from the
> command line?
>
Yes.. It's running. When i stop and start tomcat the website works again but 
after sometime i see the error again and the website turns inacessible.

 I do a processlist at that time but nothing is connected to the database. 

Thanks for any info.
Nuno Fernandes

> Best
>
> - RuiXian
>
>
> org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the
>
> > following query: com.mysql.jdbc.PreparedStatement at 4904c8: statement has
> > been
> >
> > close
> >
> > d, no further internal information available.
> >
> > at
> >
> > org.opencms.db.generic.CmsProjectDriver.writeLocks(CmsProjectDriver.java
> >
> > :2177)
> >
> > at org.opencms.lock.CmsLockManager.writeLocks(CmsLockManager.java:582)
> >
> > at
> >
> > org.opencms.db.CmsDriverManager.writeLocks(CmsDriverManager.java:7920)
> >
> > at
> >
> > org.opencms.db.CmsSecurityManager.writeLocks(CmsSecurityManager.java:5091
> >)
> >
> > at org.opencms.main.CmsThreadStore.run(CmsThreadStore.java:187)
> >
> > Caused by: com.mysql.jdbc.CommunicationsException: Communications link
> > failure
> >
> > due to underlying exception:
> >
> > ** BEGIN NESTED EXCEPTION **
> >
> > java.io.EOFException
> >
> > MESSAGE: Can not read response from server. Expected to read 4 bytes,
> > read 0
> >
> > bytes before connection was unexpectedly lost.
> >
> > STACKTRACE:
> >
> > java.io.EOFException: Can not read response from server. Expected to read
> > 4
> >
> > bytes, read 0 bytes before connection was unexpectedly lost.
> >
> > at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1997)
> >
> > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2411)
> >
> > ..
> >
> > I've googled around and didn't find anything related. I'm using two
> > machines
> >
> > 1 - webserver
> >
> > centos5 (i386)
> >
> > apache-tomcat-6.0.14
> >
> > jdk-1.6.0_03-fcs
> >
> > opencms 7.0.3
> >
> > 2 - db server
> >
> > centos5 (x86_64)
> >
> > mysql 5
> >
> > Any info?
> >
> > Thanks,
> >
> > Nuno Fernandes
> >
> >
> > _______________________________________________
> > This mail is sent to you from the opencms-dev mailing list
> > To change your list options, or to unsubscribe from the list, please
> > visit http://lists.opencms.org/mailman/listinfo/opencms-dev