deadlocked threads

[Chris Blackwell]

This is probably one for Micha...

I've started to see a number of deadlocked threads hanging our app occasionally.

The stack traces from the offending threads look like this

Sample stack trace RequestHandlerThread[#2]

            com.mysql.jdbc.ConnectionImpl.setAutoCommit (ConnectionImpl.java:5287)

  railo.runtime.db.driver.ConnectionProxy.setAutoCommit (ConnectionProxy.java:238)

      railo.runtime.db.DatasourceConnectionPool.isValid (DatasourceConnectionPool.java:146)

…me.db.DatasourceConnectionPool.getDatasourceConnection (DatasourceConnectionPool.java:55)

…runtime.orm.hibernate.HibernateORMEngine.createSession (HibernateORMEngine.java:128)

            railo.runtime.PageContextImpl.getORMSession (PageContextImpl.java:2964)

                   railo.runtime.orm.ORMUtil.getSession (ORMUtil.java:30)

                   railo.runtime.orm.ORMUtil.getSession (ORMUtil.java:26)

            railo.runtime.functions.orm.EntityLoad.call (EntityLoad.java:25)

Sample stack trace RequestHandlerThread[#6]

…me.db.DatasourceConnectionPool.getDatasourceConnection (DatasourceConnectionPool.java:41)

…runtime.orm.hibernate.HibernateORMEngine.createSession (HibernateORMEngine.java:128)

            railo.runtime.PageContextImpl.getORMSession (PageContextImpl.java:2964)

                   railo.runtime.orm.ORMUtil.getSession (ORMUtil.java:30)

                   railo.runtime.orm.ORMUtil.getSession (ORMUtil.java:26)

            railo.runtime.functions.orm.EntityLoad.call (EntityLoad.java:63)          

This can be generated from any part of our code where we have an entityLoad, not just the same cfc's over and over.

We're running 4.1.1.000

Anyone got any tips to help me debug this?

Cheers, Chris

[Igal @ getRailo.org]

@Chris,

was this same code running properly on previous versions of Railo? or is
that new code and you do not have such history?

On 8/27/2013 11:44 AM, Chris Blackwell wrote:
> This is probably one for Micha...
>
> I've started to see a number of deadlocked threads hanging our app
> occasionally.
> The stack traces from the offending threads look like this
>
> Sample stack trace RequestHandlerThread[#2]
> com.mysql.jdbc.ConnectionImpl.setAutoCommit
> (ConnectionImpl.java:5287)
> railo.runtime.db.driver.ConnectionProxy.setAutoCommit
> (ConnectionProxy.java:238)
> railo.runtime.db.DatasourceConnectionPool.isValid
> (DatasourceConnectionPool.java:146)

> �me.db.DatasourceConnectionPool.getDatasourceConnection
> (DatasourceConnectionPool.java:55)
> �runtime.orm.hibernate.HibernateORMEngine.createSession

> (HibernateORMEngine.java:128)
> railo.runtime.PageContextImpl.getORMSession
> (PageContextImpl.java:2964)
> railo.runtime.orm.ORMUtil.getSession (ORMUtil.java:30)
> railo.runtime.orm.ORMUtil.getSession (ORMUtil.java:26)
> railo.runtime.functions.orm.EntityLoad.call
> (EntityLoad.java:25)
>
>
> Sample stack trace RequestHandlerThread[#6]

> �me.db.DatasourceConnectionPool.getDatasourceConnection
> (DatasourceConnectionPool.java:41)
> �runtime.orm.hibernate.HibernateORMEngine.createSession

> (HibernateORMEngine.java:128)
> railo.runtime.PageContextImpl.getORMSession
> (PageContextImpl.java:2964)
> railo.runtime.orm.ORMUtil.getSession (ORMUtil.java:30)
> railo.runtime.orm.ORMUtil.getSession (ORMUtil.java:26)
> railo.runtime.functions.orm.EntityLoad.call
> (EntityLoad.java:63)
>
> This can be generated from any part of our code where we have an
> entityLoad, not just the same cfc's over and over.
>
> We're running 4.1.1.000
>
> Anyone got any tips to help me debug this?
>
> Cheers, Chris

> --
> Did you find this reply useful? Help the Railo community and add it to
> the Railo Server wiki at https://github.com/getrailo/railo/wiki
> ---
> You received this message because you are subscribed to the Google
> Groups "Railo" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/railo/CAB%3DtfTp0NS-hLJwR%2BqOky7kykaR2KR3RYhq6D5dfw0APNk57%3DA%40mail.gmail.com.
> For more options, visit https://groups.google.com/groups/opt_out.

--
Igal Sapir
Railo Core Developer
http://getRailo.org/