[AML-3421] Exceptions while running SEUpdate - Admax Local

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: Rushmore
Fix Version/s: Rushmore
Component/s: None
Labels:
None

Sprint:
Sprint 7

Description

The following exceptions are seen when seupdater tries to sync listings. This appears to be related to the columns that were dropped from the sources table. See attached log.

./seupdate.sh -d 3 --inactive --accountid 956 --accounts --seaccount 15982,15983 --groups --listings

2015-03-20 21:09:51.139 (2) [P3T1]: Exception [getting saved listings, returning]:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'sources.waypointID' in 'field list'
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732)
	at com.carldunham.jst.db.Database.execute(Database.java:285)
	at com.carldunham.jst.db.CreateTable.screate(CreateTable.java:341)
	at com.carldunham.jst.db.CreateTable.screate(CreateTable.java:262)
	at com.carldunham.jst.db.CreateTable.create(CreateTable.java:233)
	at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.getLocalListings(SearchEngineUpdater.java:2299)
	at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.syncListings(SearchEngineUpdater.java:1675)
	at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.call(SearchEngineUpdater.java:1580)
	at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.call(SearchEngineUpdater.java:1541)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)

2015-03-20 21:09:51.153 (2) [P3T1]: Exception [syncing listings, returning]:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'st-tracker.tmp14' doesn't exist
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
	at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)
	at com.carldunham.jst.db.Database.executeQuery(Database.java:367)
	at com.carldunham.jst.db.Database.executeQuery(Database.java:319)
	at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184)
	at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:149)
	at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker$NextSourceTableRow.selectLocal(SearchEngineUpdater.java:2756)
	at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.syncListings(SearchEngineUpdater.java:1729)
	at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.call(SearchEngineUpdater.java:1580)
	at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.call(SearchEngineUpdater.java:1541)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)

2015-03-20 21:09:51.181 (3) [P3T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2015-03-20 21:09:51.183 (2) [P3T2]: Exception [getting saved listings, returning]:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'sources.waypointID' in 'field list'
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732)
	at com.carldunham.jst.db.Database.execute(Database.java:285)
	at com.carldunham.jst.db.CreateTable.screate(CreateTable.java:341)
	at com.carldunham.jst.db.CreateTable.screate(CreateTable.java:262)
	at com.carldunham.jst.db.CreateTable.create(CreateTable.java:233)
	at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.getLocalListings(SearchEngineUpdater.java:2299)
	at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.syncListings(SearchEngineUpdater.java:1675)
	at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.call(SearchEngineUpdater.java:1580)
	at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.call(SearchEngineUpdater.java:1541)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)

2015-03-20 21:09:51.184 (3) [P3T1]: DatabasePool with a limit of 80 created
2015-03-20 21:09:51.197 (2) [P3T2]: Exception [syncing listings, returning]:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'st-tracker.tmp15' doesn't exist
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
	at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)
	at com.carldunham.jst.db.Database.executeQuery(Database.java:367)
	at com.carldunham.jst.db.Database.executeQuery(Database.java:319)
	at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184)
	at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:149)
	at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker$NextSourceTableRow.selectLocal(SearchEngineUpdater.java:2756)
	at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.syncListings(SearchEngineUpdater.java:1729)
	at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.call(SearchEngineUpdater.java:1580)
	at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.call(SearchEngineUpdater.java:1541)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)

2015-03-20 21:09:51.198 (3) [P3T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2015-03-20 21:09:51.202 (3) [P3T1]: Finished Account (15982) "45970667-c304-493f-9ab5-1c9cbd26f3f5_93046_18_16697_GT" for user (1060) "45970667-c304-493f-9ab5-1c9cbd26f3f5_1"
2015-03-20 21:09:51.210 (3) [P3T2]: Finished Account (15983) "45970667-c304-493f-9ab5-1c9cbd26f3f5_93046_18_16697_GM" for user (1060) "45970667-c304-493f-9ab5-1c9cbd26f3f5_1"
2015-03-20 21:09:51.211 (3) [main]: After joining threads, calling doPostJoinActions
2015-03-20 21:09:51.211 (3) [main]: =============== Completed Search Engine Updater ================

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

seupdate-account956.log
55 kB
20/Mar/15 6:03 PM

Activity

People

Assignee:

Sanjay Kumar Biswal

Reporter:

Stacie Waleyko (Inactive)

Votes:

0 Vote for this issue

Watchers:

2 Start watching this issue

Dates

Created:

20/Mar/15 5:21 PM

Updated:

23/Mar/15 8:08 AM

Resolved:

20/Mar/15 6:24 PM