2009-08-31 14:07:10.290 (3) [main]: Debug Level set to 3 2009-08-31 14:07:10.310 (3) [main]: DatabasePool with a limit of 80 created 2009-08-31 14:07:10.706 (3) [main]: getSEUserIDs distID=3, seUserID=null, accounts=(447) returned 1389,1391 2009-08-31 14:07:10.708 (3) [main]: =============== Starting Search Engine Updater ================ 2009-08-31 14:07:10.708 (3) [main]: ----------------SearchEngineSyncUserWorker starting 2009-08-31 14:07:10.937 (3) [main]: No licensing config file found, assuming TSA production environment 2009-08-31 14:07:11.115 (3) [main]: Created shared sesystem connection rw 2009-08-31 14:07:11.929 (3) [P0T1]: DatabasePool with a limit of 80 created 2009-08-31 14:07:11.982 (3) [P0T0]: -- Bulk downloads supported. 2009-08-31 14:07:12.041 (3) [P0T1]: -- Bulk downloads supported. 2009-08-31 14:07:12.065 (3) [P0T0]: DatabasePool with a limit of 80 created 2009-08-31 14:07:12.113 (3) [P0T0]: -- Begining search engine sync for user: (1391) "MingleMatch, Inc." 2009-08-31 14:07:12.116 (3) [P0T0]: validating report job... 2009-08-31 14:07:12.731 (3) [P0T1]: -- Begining search engine sync for user: (1389) "Adventist & Interracial" 2009-08-31 14:07:12.731 (3) [P0T1]: validating report job... 2009-08-31 14:07:15.415 (3) [P0T1]: ...success 2009-08-31 14:07:16.057 (3) [P0T1]: Scheduled report. Report Job ID = 752986253 2009-08-31 14:07:16.264 (2) [P0T1]: Command ScheduleReportJob, identifier null-P0T1-14 unable to release (or never acquired) searchEngineConnection row 2009-08-31 14:07:16.719 (3) [P0T0]: ...success 2009-08-31 14:07:18.672 (3) [P0T0]: Scheduled report. Report Job ID = 858273313 2009-08-31 14:07:18.836 (2) [P0T0]: Command ScheduleReportJob, identifier null-P0T0-13 unable to release (or never acquired) searchEngineConnection row 2009-08-31 14:07:48.870 (3) [P0T1]: Connected to URL "https://adwords.google.com/api/adwords/ReportDownload?t=AAAAACzhqI0AAAEjcn_puQEAAAAAmweGR1bdap70QC5atIm0xx6s53mtvLGR" 2009-08-31 14:07:50.862 (3) [P0T1]: validating report job... 2009-08-31 14:07:51.053 (3) [P0T1]: ...success 2009-08-31 14:07:51.324 (3) [P0T1]: Scheduled report. Report Job ID = 752986523 2009-08-31 14:07:52.765 (3) [P0T1]: Connected to URL "https://adwords.google.com/api/adwords/ReportDownload?t=AAAAACzhqZsAAAEjcn_5WQEAAAACILuNv0aHm4U3YGO0P_nW_zDhNEYNuXom" 2009-08-31 14:07:53.260 (3) [P0T1]: Downloaded to /var/local/tsa/google_sync_files/tsa-creative-structure-report--1389-2009-08-31 14:07:12.gz 2009-08-31 14:07:54.310 (3) [P0T1]: Writing temp infile... 2009-08-31 14:07:55.428 (3) [P0T1]: Writing temp infile... 2009-08-31 14:07:55.429 (3) [P0T1]: Columns already defined 2009-08-31 14:07:55.468 (3) [P0T1]: -- Data staging complete for seuser ((1389) "Adventist & Interracial") 2009-08-31 14:07:55.472 (3) [P0T1]: Loading data infile into temp table... 2009-08-31 14:07:55.944 (3) [P0T1]: LOAD TEMP SYNC TABLES COMPLETED 2009-08-31 14:07:56.485 (3) [P0T1]: Campaigns with new items:([]) 2009-08-31 14:07:56.485 (3) [P0T1]: DETECTION OF NEW CAMPAIGN ITEMS COMPLETED 2009-08-31 14:07:56.553 (3) [P0T1]: Campaigns with deleted items:([]) 2009-08-31 14:07:56.553 (3) [P0T1]: DETECTION OF DELETED CAMPAIGN ITEMS COMPLETED 2009-08-31 14:07:56.756 (3) [P0T1]: Campaigns with updated items:([]) 2009-08-31 14:07:56.757 (3) [P0T1]: DETECTION OF UPDATED CAMPAIGN ITEMS COMPLETED 2009-08-31 14:07:56.906 (3) [P0T1]: 14868 keyword records removed before re-loading staging table. 2009-08-31 14:07:57.248 (3) [P0T1]: 14868 keyword records loaded into staging table. 2009-08-31 14:07:57.258 (3) [P0T1]: 864 creative ad records removed from staging table before re-loading. 2009-08-31 14:07:57.274 (3) [P0T1]: 864 creative ad records loaded into staging table. 2009-08-31 14:07:57.274 (3) [P0T1]: UPDATE OF STAGING TABLES COMPLETED 2009-08-31 14:07:57.282 (3) [P0T1]: -- Keyword/Creative difference checks complete for seuser ((1389) "Adventist & Interracial") 2009-08-31 14:07:57.284 (3) [P0T1]: Passing seUserAcctId: 431 and seAcctAcctId: 447 2009-08-31 14:07:57.300 (3) [P0T1]: DETECTION OF CAMPAIGNS NEEDING FIRST SYNC COMPLETED 2009-08-31 14:07:57.309 (3) [P0T1]: DatabasePool with a limit of 80 created 2009-08-31 14:07:57.349 (3) [P0T1]: DETECTION OF CAMPAIGNS WITH CONTENT/NETWORK CHANGES COMPLETED 2009-08-31 14:07:57.349 (3) [P0T1]: -- Account-level operations complete for seuser ((1389) "Adventist & Interracial") and seAccount(447) 2009-08-31 14:07:57.391 (3) [P0T1]: Replicating 6129 rows... 2009-08-31 14:08:00.573 (3) [P0T1]: Keyword-level bidType changes: 0 2009-08-31 14:08:00.574 (3) [P0T1]: Keyword-level bidAmount changes: 1495 2009-08-31 14:08:00.574 (3) [P0T1]: COMPLETED KEYWORD-LEVEL BID DETECTION FOR: seUser (1389) and seAccount(447) 2009-08-31 14:08:00.637 (3) [P0T1]: Adgroup-level bidType changes: 0 2009-08-31 14:08:00.638 (3) [P0T1]: Adgroup-level bidAmount changes: 0 2009-08-31 14:08:00.638 (3) [P0T1]: COMPLETED ADGROUP-LEVEL BID DETECTION FOR: seUser (1389) and seAccount(447) 2009-08-31 14:08:00.658 (3) [P0T1]: Owning Account IDs: ("29754","31825","27074","31826","31824") 2009-08-31 14:08:00.659 (3) [P0T1]: -- Bid amount difference checks complete for seuser ((1389) "Adventist & Interracial") and seAccount(447) 2009-08-31 14:08:00.659 (3) [P0T1]: -- Out of sync seaccts found for se user: (1389) "Adventist & Interracial" : [29754, 31825, 27074, 31826, 31824] 2009-08-31 14:09:28.990 (3) [P0T0]: Connected to URL "https://adwords.google.com/api/adwords/ReportDownload?t=AAAAADMoNiEAAAEjcoFxDgEAAAAASEzYMXG8akY6vb-3Er721UOXkspcgy2k" 2009-08-31 14:09:59.758 (3) [P0T0]: validating report job... 2009-08-31 14:10:00.351 (3) [P0T0]: ...success 2009-08-31 14:10:00.897 (3) [P0T0]: Scheduled report. Report Job ID = 858275293 2009-08-31 14:10:11.584 (3) [P0T0]: Connected to URL "https://adwords.google.com/api/adwords/ReportDownload?t=AAAAADMoPd0AAAEjcoIXbQEAAAABFNKmMm2vbW0MYFOUbhW6SgALhAE6PsQM" 2009-08-31 14:10:13.181 (3) [P0T0]: Downloaded to /var/local/tsa/google_sync_files/tsa-creative-structure-report--1391-2009-08-31 14:07:12.gz 2009-08-31 14:10:19.003 (3) [P0T0]: Writing temp infile... 2009-08-31 14:10:42.167 (1) [P0T0]: Failure parsing keyword temp file /var/local/tsa/google_sync_files/tsa-creative-structure-report--1391-2009-08-31 14:07:1213650.tmp com.thesearchagency.searchengines.SearchEngineCommandException at com.thesearchagency.searchengines.google.GoogleStructureSync.createTempStructureFiles(GoogleStructureSync.java:410) at com.thesearchagency.searchengines.google.GoogleStructureSync.stageTempSyncData(GoogleStructureSync.java:144) at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineSyncUserWorker.run(SearchEngineUpdater.java:3266) at com.carldunham.jst.concurrency.ThreadPool$WorkerThread.run(ThreadPool.java:248) 2009-08-31 14:10:42.167 (3) [P0T0]: Google Sync: -- staging of sync data failed for acct: null 2009-08-31 14:10:42.167 (1) [P0T0]: Exception [Error syncing seaccounts for seacct: 457]:com.thesearchagency.searchengines.SearchEngineCommandException at com.thesearchagency.searchengines.google.GoogleStructureSync.createTempStructureFiles(GoogleStructureSync.java:410) at com.thesearchagency.searchengines.google.GoogleStructureSync.stageTempSyncData(GoogleStructureSync.java:144) at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineSyncUserWorker.run(SearchEngineUpdater.java:3266) at com.carldunham.jst.concurrency.ThreadPool$WorkerThread.run(ThreadPool.java:248) 2009-08-31 14:10:42.168 (1) [P0T0]: Exception [Failure in retieving out-of-sync SE accounts: ]:com.thesearchagency.searchengines.SearchEngineCommandException at com.thesearchagency.searchengines.google.GoogleStructureSync.createTempStructureFiles(GoogleStructureSync.java:410) at com.thesearchagency.searchengines.google.GoogleStructureSync.stageTempSyncData(GoogleStructureSync.java:144) at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineSyncUserWorker.run(SearchEngineUpdater.java:3266) at com.carldunham.jst.concurrency.ThreadPool$WorkerThread.run(ThreadPool.java:248) 2009-08-31 14:10:42.168 (3) [main]: ------------SearchEngineSyncUserWorker done 2009-08-31 14:10:42.168 (3) [main]: detected search engine accounts with differences ("29754","31825","27074","31826","31824")... 2009-08-31 14:10:42.168 (3) [main]: proceeding with listings sync... 2009-08-31 14:10:42.169 (3) [main]: =============== Completed Search Engine Updater ================ 2009-08-31 14:10:42.170 (3) [main]: Search Engine Updater: 3m 31.461s 2009-08-31 14:10:42.170 (3) [main]: by key: 2009-08-31 14:10:42.170 (3) [main]: google: 20.254s 2009-08-31 14:10:42.170 (3) [main]: by thread: 2009-08-31 14:10:42.171 (3) [main]: P0T1: 5.654s 2009-08-31 14:10:42.171 (3) [main]: P0T0: 14.600s 2009-08-31 14:10:42.171 (3) [main]: db: 4.542s 2009-08-31 14:10:42.171 (3) [main]: by thread: 2009-08-31 14:10:42.171 (3) [main]: P0T1: 4.149s 2009-08-31 14:10:42.171 (3) [main]: main: 0.011s 2009-08-31 14:10:42.171 (3) [main]: P0T0: 0.382s 2009-08-31 14:10:42.171 (3) [main]: google connection waiting: 4.396s 2009-08-31 14:10:42.171 (3) [main]: other: 3m 2.269s