View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004765 | SymmetricDS | Improvement | public | 2021-01-14 21:33 | 2021-02-25 21:33 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.12.7 | Fixed in Version | 3.12.7 | ||
| Summary | 0004765: Prevent blocking on Firebird with lock timeout | ||||
| Description | On Firebird, it is possible for a DML statement to block forever waiting for a row lock. Starting in Jaybird 2.2, it supports setting isc_tpb_lock_timeout as a database connection property. SymmetricDS allows the user to specify these in engine file with db.connection.properties, which are name=value pairs separated by semi-colons. Add support to pass an equal sign by escaping it with another equal sign. Then, in the engine file, user can specify: db.connection.properties=TRANSACTION_READ_COMMITTED=isc_tpb_read_committed,isc_tpb_rec_version,isc_tpb_write,isc_tpb_wait,isc_tpb_lock_timeout==50 For a lock timeout of 50 seconds (same default as MySQL). | ||||
| Tags | dialect: firebird | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-01-14 21:33 | elong | New Issue | |
| 2021-01-14 21:33 | elong | Status | new => assigned |
| 2021-01-14 21:33 | elong | Assigned To | => elong |
| 2021-01-14 21:33 | elong | Tag Attached: dialect: firebird | |
| 2021-01-14 21:33 | elong | Project | SymmetricDS Pro => SymmetricDS |
| 2021-01-14 21:35 | elong | Status | assigned => resolved |
| 2021-01-14 21:35 | elong | Resolution | open => fixed |
| 2021-01-14 21:35 | elong | Fixed in Version | => 3.12.7 |
| 2021-01-14 22:00 | admin | Changeset attached | => SymmetricDS 3.12 ed78ec3a |
| 2021-02-25 21:33 | admin | Status | resolved => closed |