dbeaver / dbeaver/dbeaver

After finishing a very long running statement the transaction is rolled back after 10 minutes while this features is unchecked

Open
#18,497 8 comments 0 reactions 1 assignee Claimed by @Matvey16 View on GitHub
can't reproduce x:postgresql
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.