[opencms-dev] Failed to write locks to database

[Nuno Fernandes]

On Sunday 27 January 2008 21:36:08 RuiXian BAO wrote:
> Hello Nuno,
>
> On 1/23/08, Nuno Fernandes <npf-mlists at eurotux.com> wrote:
> > > 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.
>
> Have you tried the various suggestions in the following link?
>
> http://forums.mysql.com/read.php?39,16257,16257
Same thing.. i've increased wait timeout to 500 in mysql to see if there's 
problems now..

Best regards
./npf

>
> Best
>
> - RuiXian
>
>
> 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
> >
> > _______________________________________________
> > 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