[opencms-dev] Failed to write locks to database

[RuiXian BAO]

Hello Nuno,

On 1/28/08, Nuno Fernandes <npf at eurotux.com> wrote:
>
> Hi,
>
> I don't know where to find the tool..  Where is that tool?


It is the last one inside Additonal Tools at Administration View -> Database
Management.

Best

- RuiXian

Thanks
> Nuno Fernandes
>
> >
> > Best
> >
> > - RuiXian
> >
> >
> > Thanks
> >
> > > Nuno Fernandes
> > >
> > > On Wednesday 23 January 2008 16:16:06 Nuno Fernandes wrote:
> > > > 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.jav
> > >
> > > > > >a
> > > > > >
> > > > > > :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.jav
> > > > > >a
> > > :
> > > :50
> > > :
> > > > > >91 )
> > > > > >
> > > > > > 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
> > >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20080129/b7e2ba98/attachment.htm>