]
Luis Barreiro resolved WFLY-11037.
----------------------------------
Fix Version/s: 15.0.0.Alpha1
Resolution: Done
[~simkam] yes, thanks for pointing that out!
Intermittent Agroal warnings during startup
-------------------------------------------
Key: WFLY-11037
URL:
https://issues.jboss.org/browse/WFLY-11037
Project: WildFly
Issue Type: Bug
Components: Agroal
Affects Versions: 14.0.0.Final
Reporter: Rich DiCroce
Priority: Major
Fix For: 15.0.0.Alpha1
Sometimes during startup, Agroal spams the log with this:
{code}
2018-09-18 10:35:46,226 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state CHECKED_IN
2018-09-18 10:35:46,226 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,226 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,227 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,227 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,227 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,227 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,228 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,228 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,228 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,228 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,229 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,229 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,229 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,229 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,229 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,229 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,230 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,230 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,230 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,230 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,230 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,230 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,231 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,231 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,231 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,231 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,231 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,231 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,231 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,232 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,232 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,232 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,232 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,232 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,232 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,232 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,232 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
2018-09-18 10:35:46,233 WARN [io.agroal.pool] (Agroal_6738675721) WFLYAG0601: SciQ_DS:
Closing connection in incorrect state DESTROYED
{code}
I'm not sure why, and it doesn't always happen.
My pool configuration is:
{code}
<connection-pool max-size="${database.maxPool:20}"
background-validation="30000" idle-removal="30"/>
{code}
But this also occurs when background-validation and idle-removal are omitted.