[MARMOTTA-498] Database Connections remain in "Idle in Transaction"

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.2.1, 3.3.0
• Component/s: KiWi Triple Store
• Labels: database jdbc postgres
• Assignee: Sebastian Schaffert
• Reporter: Sebastian Schaffert
• Created: 15/May/14 12:36
• Updated: 16/Dec/14 09:59
• Resolved: 15/May/14 13:16

Description

After running for some time, some of the database connections remain in the state "idle in transaction" instead of "idle". This indicates they are not properly closed for some reason (or not committed/rolled back).

The bug can be observed by starting up Marmotta, connecting to Postgres and then running a SPARQL query (without any data). The connection state can be monitored in Postgres (e.g. using pgadmin)