View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006510 | SymmetricDS | Bug | public | 2024-06-21 16:27 | 2024-08-01 14:00 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.8 | Fixed in Version | 3.15.8 | ||
| Summary | 0006510: SQLite with initial load in background can hang | ||||
| Description | When using SQLite with large tables, the initial load in background can hang because the writer thread update to batch status is blocked by the reader thread's database lock. Queries or updates can be on separate threads, but then they can't also depend on one another because they lock the SQLite database. If jobs.synchronized.enable=true parameter, then the background extract writer should wait to update all batch statuses when the process is closed. | ||||
| Tags | dialect: sqlite, initial/partial load | ||||
|
SymmetricDS: 3.15 3142da29 2024-06-21 16:39:59 Details Diff |
0006510: SQLite with initial load in background can hang |
Affected Issues 0006510 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/extract/MultiBatchStagingWriter.java | Diff File | ||
|
SymmetricDS: 3.16 4f8b8040 2024-06-21 16:39:59 Details Diff |
0006510: SQLite with initial load in background can hang |
Affected Issues 0006510 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/extract/MultiBatchStagingWriter.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-06-21 16:27 | elong | New Issue | |
| 2024-06-21 16:27 | elong | Status | new => assigned |
| 2024-06-21 16:27 | elong | Assigned To | => elong |
| 2024-06-21 16:27 | elong | Tag Attached: dialect: sqlite | |
| 2024-06-21 16:27 | elong | Tag Attached: initial/partial load | |
| 2024-06-21 16:43 | elong | Status | assigned => resolved |
| 2024-06-21 16:43 | elong | Resolution | open => fixed |
| 2024-06-21 16:43 | elong | Fixed in Version | => 3.15.8 |
| 2024-06-21 17:00 | admin | Changeset attached | => SymmetricDS 3.15 3142da29 |
| 2024-08-01 14:00 | admin | Changeset attached | => SymmetricDS 3.16 4f8b8040 |
| 2024-08-16 17:45 | admin | Status | resolved => closed |