Existing ORM datasource connections fail to time out after calling OrmReload()

Description

Calling OrmReload() seems to cause ORM datasource connections started before the call to become "detached" and fail to time out.

New connections created after the reload call time out correctly according to the Lucee datasource timeout setting (default=1 minute), but those started before the `OrmReload()` ignore that setting and continue until closed by the database (in MySQL/MariaDB the default is 8 hours later).

This can lead to a build-up of unused, "detached" connections.

Expected behaviour

`OrmReload()` should I believe cause all existing connections to be closed, but if not then existing connections should at least respect the Lucee datasource timeout settng.

Actual behaviour

Existing datasource connections fail to timeout and continue until closed by the database server.

Database

MariaDB 10.0.x (compatible with MySQL 5.6) using bundled Lucee MySQL connector.

Orm settings

Environment

None

Activity

Show:
Michael Offner
June 25, 2015, 2:58 PM

do you have multiple datasources? Or defined the datasource with the "datasource" attribute in the component?
This function has only affected the default datasource, this was fixed with ticket

Julian Halliwell
June 25, 2015, 3:20 PM

@Micha This was with a single datasource defined using this.datasource in application.cfc

Are you saying LDEV 405 fixes this but only with a single datasource?

Julian Halliwell
July 4, 2015, 3:45 PM
Edited

Having updated to 4.5.1.022, this issue still seems to be present. LDEV 405 doesn't appear to have fixed it.

Julian Halliwell
July 4, 2015, 4:34 PM
Edited

I've also tested this on 4.5.1.022 using multiple ORM datasources and the same thing happens: call OrmReload() and each original connection becomes "detached".

Luis Majano
March 8, 2016, 7:22 PM

This is the same issue dealing with the stack not releasing the thread. Basically, those connections are lost and will eventually kill the database. I beleive you have addressed this, so this issue could be linked to it. As this is a side-effect of the bug.

Assignee

Michael Offner

Reporter

Julian Halliwell

Priority

Major

Labels

Fix versions

None

Affects versions

Configure