After finishing a very long running statement the transaction is rolled back after 10 minutes while this features is unchecked
- Dominant language
- Java
- Stars
- 51.8k
- Forks
- 4.4k
- Avg merge
- 3d 8h
- Merged PRs (30d)
- 188
Description
### Description
Now for third time, so it is a bug. Multiple version (happened first time 4 weeks ago).
Case:
Postgresql function runs for 1h45m. I come back, see a result in the Data Editor, Commit. No Error message or anything.
But: nothing has been done because the transaction has been rolled back.
From dbeaver_sql.log:
!ENTRY org.jkiss.dbeaver.model 1 53 2022-12-11 11:44:45.416
!MESSAGE select eyeint.createCoproductieCorporatie()
!SUBENTRY 1 org.jkiss.dbeaver.model 1 0 2022-12-11 13:29:51.435
!MESSAGE SUCCESS [-1]
In dbeaver-debug.log:
2022-12-11 13:39:48.817 - End idle 1 transactions for postgres-jdbc-1729e7ddbc1-66aad6f3e00553c4
Automatically end long idle transactions is unchecked, for dbeaver as well as the connection.
### DBeaver Version
Community edition Version 22.3.0.202212041619
### Operating System
Windows 10
### Database and driver
PostgreSQL 9.4.22
Driver: 42.5.0
### Steps to reproduce
Connect to the database
Execute a very long running function (1h45m)
Wait for 10 minutes after the function has finished running
Idle transaction is ended, all the work is lost
### Additional context
Office extension installed
Contributor guide
Assessment
This issue has not been assessed yet.