View Issue Details

IDProjectCategoryView StatusLast Update
0003563SymmetricDSImprovementpublic2021-11-17 16:00
Reporterwoehrl01 Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.9.7 
Target Version3.13.0Fixed in Version3.13.0 
Summary0003563: Purging large number of extract requests, query time out
Description2018-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)
Tagsperformance, purge

Activities

Related Changesets

SymmetricDS: 3.13 749dbddc

2021-10-11 14:55:13

admin

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

Issue History

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