cybertec-postgresql / pg_timetable

90%

master: 87%

LAST BUILD ON BRANCH 674_switch_txid_to_vxid

branch: 674_switch_txid_to_vxid

CHANGE BRANCH

x

Reset

• 674_switch_txid_to_vxid
• 690_run_interval_drift
• 725-fix-null-scan
• add-job-funcs
• bmp-pgx-5.7.6
• bump-go-1.24
• bump-go-1.25
• bump-pgx-5.7.4
• copy-tasks
• dependabot/github_actions/actions/checkout-5
• dependabot/github_actions/actions/configure-pages-5
• dependabot/github_actions/actions/deploy-pages-4
• dependabot/github_actions/actions/download-artifact-5
• dependabot/github_actions/actions/download-artifact-6
• dependabot/github_actions/actions/setup-go-6
• dependabot/github_actions/actions/setup-python-6
• dependabot/github_actions/actions/stale-10
• dependabot/github_actions/actions/upload-artifact-5
• dependabot/github_actions/actions/upload-pages-artifact-4
• dependabot/github_actions/github/codeql-action-4
• dependabot/github_actions/golangci/golangci-lint-action-7
• dependabot/github_actions/golangci/golangci-lint-action-8
• dependabot/go_modules/github.com/cybertec-postgresql/pgx-migrator-1.0.2
• dependabot/go_modules/github.com/cybertec-postgresql/pgx-migrator-1.1.0
• dependabot/go_modules/github.com/cybertec-postgresql/pgx-migrator-1.2.0
• dependabot/go_modules/github.com/go-viper/mapstructure/v2-2.3.0
• dependabot/go_modules/github.com/go-viper/mapstructure/v2-2.4.0
• dependabot/go_modules/github.com/jackc/pgx/v5-5.7.1
• dependabot/go_modules/github.com/jackc/pgx/v5-5.7.2
• dependabot/go_modules/github.com/jackc/pgx/v5-5.7.4
• dependabot/go_modules/github.com/jackc/pgx/v5-5.7.5
• dependabot/go_modules/github.com/jackc/pgx/v5-5.7.6
• dependabot/go_modules/github.com/jessevdk/go-flags-1.6.1
• dependabot/go_modules/github.com/pashagolub/pgxmock/v4-4.3.0
• dependabot/go_modules/github.com/pashagolub/pgxmock/v4-4.4.0
• dependabot/go_modules/github.com/pashagolub/pgxmock/v4-4.6.0
• dependabot/go_modules/github.com/pashagolub/pgxmock/v4-4.8.0
• dependabot/go_modules/github.com/sethvargo/go-retry-0.3.0
• dependabot/go_modules/github.com/spf13/viper-1.19.0
• dependabot/go_modules/github.com/spf13/viper-1.20.1
• dependabot/go_modules/github.com/spf13/viper-1.21.0
• dependabot/go_modules/github.com/stretchr/testify-1.10.0
• dependabot/go_modules/github.com/stretchr/testify-1.11.0
• dependabot/go_modules/github.com/stretchr/testify-1.11.1
• dependabot/go_modules/golang.org/x/crypto-0.31.0
• dependabot/go_modules/golang.org/x/crypto-0.35.0
• docker-gha-action
• fix-db-execution-log
• fix-deprecated-format
• master
• mkdocs
• use-native-pg-env-vars
• use-testcontainers
• yaml-chains

Build # 13143031448

Build Type

Pull #675

github

Committed by pashagolub

Commit Message

[+] switch to `VirtualXID` internally from `TransactionXID`, solves #674

Turned out issuing `txid_current()` at the beginning of every chain
transaction is creating a session that's sits idle in transaction for
the duration of the entire chain. In current case, with a single task
`{kind == PROGRAM}`, that idle transaction doesn't do anything aside
from pin the `xmin` horizon and block vacuum for 6+ hours.
The same issue occurs for SQL tasks that are `Remote` or `Autonomous`.

Pull Request Pull Request #675: [+] switch to `VirtualXID` internally from `TransactionXID`, solves #674

Run Details

10 of 10 new or added lines in 3 files covered. (100.0%)

1499 of 1667 relevant lines covered (89.92%)

1.03 hits per line