View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003563 | SymmetricDS | Improvement | public | 2018-05-15 14:06 | 2021-11-17 16:00 |
| Reporter | woehrl01 | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.7 | ||||
| Target Version | 3.13.0 | Fixed in Version | 3.13.0 | ||
| Summary | 0003563: Purging large number of extract requests, query time out | ||||
| Description | 2018-05-15 15:55:28,424 INFO [central-0] [PurgeService] [qtp1093864783-4483] Failed to execute purge, but will try again, StackTraceKey.init [SqlException:695583935] org.jumpmind.db.sql.SqlException: The query has timed out. at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:300) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:291) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:503) at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:342) at org.jumpmind.db.sql.AbstractSqlTemplate.update(AbstractSqlTemplate.java:224) at org.jumpmind.symmetric.service.impl.PurgeService.purgeExtractRequests(PurgeService.java:288) at org.jumpmind.symmetric.service.impl.PurgeService.purgeOutgoing(PurgeService.java:133) at org.jumpmind.symmetric.service.impl.PurgeService.purgeOutgoing(PurgeService.java:83) at org.jumpmind.symmetric.job.OutgoingPurgeJob.doJob(OutgoingPurgeJob.java:49) at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:225) | ||||
| Tags | performance, purge | ||||
|
SymmetricDS: 3.13 749dbddc 2021-10-11 14:55:13 Details Diff |
0003563: The query has timed out. purgeExtractRequests |
Affected Issues 0003563 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeServiceSqlMap.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-05-15 14:06 | woehrl01 | New Issue | |
| 2018-05-15 14:30 | woehrl01 | Note Added: 0001183 | |
| 2018-10-10 12:51 | hanes | Target Version | => 3.10.0 |
| 2018-10-10 12:52 | hanes | Priority | normal => low |
| 2018-10-17 18:36 | hanes | Status | new => acknowledged |
| 2018-10-29 16:53 | hanes | Priority | low => normal |
| 2019-03-14 12:39 | admin | Target Version | 3.10.0 => 3.10.1 |
| 2019-04-23 13:46 | elong | Target Version | 3.10.1 => 3.10.2 |
| 2019-04-24 18:09 | elong | Tag Attached: performance | |
| 2019-04-24 18:10 | elong | Tag Attached: purge | |
| 2019-05-08 12:51 | admin | Target Version | 3.10.2 => 3.10.3 |
| 2019-06-24 17:45 | elong | Target Version | 3.10.3 => 3.10.4 |
| 2019-08-09 19:41 | elong | Target Version | 3.10.4 => 3.10.5 |
| 2019-10-31 14:59 | admin | Target Version | 3.10.5 => 3.10.6 |
| 2019-11-14 19:47 | elong | Target Version | 3.10.6 => 3.10.7 |
| 2019-12-09 15:25 | admin | Target Version | 3.10.7 => 3.10.8 |
| 2020-01-02 14:40 | admin | Target Version | 3.10.8 => 3.10.9 |
| 2020-01-22 19:03 | elong | Target Version | 3.10.9 => 3.10.10 |
| 2020-02-14 13:46 | elong | Target Version | 3.10.10 => 3.10.11 |
| 2020-03-16 20:14 | admin | Target Version | 3.10.11 => 3.10.12 |
| 2020-05-26 12:28 | elong | Target Version | 3.10.12 => 3.11.10 |
| 2020-06-24 20:14 | elong | Target Version | 3.11.10 => 3.12.2 |
| 2020-07-20 13:06 | elong | Target Version | 3.12.2 => 3.12.3 |
| 2020-08-31 19:47 | elong | Target Version | 3.12.3 => 3.12.4 |
| 2020-09-23 15:32 | admin | Target Version | 3.12.4 => 3.12.5 |
| 2020-11-09 13:45 | admin | Target Version | 3.12.5 => 3.12.6 |
| 2021-01-08 20:42 | admin | Target Version | 3.12.6 => 3.12.7 |
| 2021-02-25 13:01 | admin | Target Version | 3.12.7 => 3.12.8 |
| 2021-03-30 19:13 | admin | Target Version | 3.12.8 => 3.12.9 |
| 2021-04-28 14:41 | admin | Target Version | 3.12.9 => 3.12.10 |
| 2021-05-28 11:54 | admin | Target Version | 3.12.10 => 3.12.11 |
| 2021-07-13 12:43 | admin | Target Version | 3.12.11 => 3.12.12 |
| 2021-10-11 14:55 | elong | Assigned To | => elong |
| 2021-10-11 14:55 | elong | Status | acknowledged => resolved |
| 2021-10-11 14:55 | elong | Resolution | open => fixed |
| 2021-10-11 14:55 | elong | Fixed in Version | => 3.13.0 |
| 2021-10-11 14:55 | elong | Target Version | 3.12.12 => 3.13.0 |
| 2021-10-11 15:00 | admin | Changeset attached | => SymmetricDS 3.13 749dbddc |
| 2021-11-11 13:08 | elong | Summary | The query has timed out. purgeExtractRequests => Purging large number of extract requests, query time out |
| 2021-11-17 16:00 | admin | Status | resolved => closed |