View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0002250 | SymmetricDS | Bug | public | 2015-04-02 11:55 | 2015-04-08 12:12 |
Reporter | chenson | Assigned To | chenson | ||
Priority | normal | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.7.11 | ||||
Target Version | 3.7.12 | Fixed in Version | 3.7.12 | ||
Summary | 0002250: Bad purge query on sybase | ||||
Description | 2015-04-02 11:10:02,369 INFO [server] [PurgeService] [server-job-2] Purging extract requests that are older than Sat Mar 28 10:10:02 CET 2015 2015-04-02 11:10:02,380 INFO [server] [PurgeService] [server-job-2] The outgoing purge process has completed 2015-04-02 11:10:02,382 ERROR [server] [PurgeService] [server-job-2] org.jumpmind.db.sql.SqlException: Invalid column name 'end_batch_id'. at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:288) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:279) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:434) at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:299) at org.jumpmind.db.sql.AbstractSqlTemplate.update(AbstractSqlTemplate.java:212) at org.jumpmind.symmetric.service.impl.PurgeService.purgeExtractRequests(PurgeService.java:171) at org.jumpmind.symmetric.service.impl.PurgeService.purgeOutgoing(PurgeService.java:97) at org.jumpmind.symmetric.service.impl.PurgeService.purgeOutgoing(PurgeService.java:73) at org.jumpmind.symmetric.job.OutgoingPurgeJob.doJob(OutgoingPurgeJob.java:39) at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:180) at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:224) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: Invalid column name 'end_batch_id'. at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(SybConnection.java:2780) at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(SybStatement.java:2665) at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:295) at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:272) at com.sybase.jdbc4.jdbc.SybStatement.executeLoop(SybStatement.java:2594) at com.sybase.jdbc4.jdbc.SybStatement.execute(SybStatement.java:2581) at com.sybase.jdbc4.jdbc.SybPreparedStatement.execute(SybPreparedStatement.java:1363) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:322) at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:299) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:432) ... 17 more | ||||
Tags | No tags attached. | ||||
SymmetricDS: master a8b07c52 2015-04-02 07:57:00 Details Diff |
0002250: Bad purge query on sybase |
Affected Issues 0002250 |
|
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeServiceSqlMap.java | Diff File | ||
SymmetricDS: master 6761606f 2015-04-03 07:47:02 Details Diff |
0002250: Bad purge query on sybase |
Affected Issues 0002250 |
|
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeServiceSqlMap.java | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2015-04-02 11:55 | chenson | New Issue | |
2015-04-02 11:55 | chenson | Status | new => assigned |
2015-04-02 11:55 | chenson | Assigned To | => chenson |
2015-04-02 12:00 | chenson | Changeset attached | => SymmetricDS trunk r9427 |
2015-04-03 12:00 | chenson | Changeset attached | => SymmetricDS trunk r9428 |
2015-04-08 12:12 | chenson | Status | assigned => closed |
2015-04-08 12:12 | chenson | Fixed in Version | => 3.7.12 |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master 6761606f |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master a8b07c52 |