Results 1 to 2 of 2

Thread: IMAP stuck with "In Progress"

  1. 2010-11-09, 10:25 AM #1
    trader88888
    trader88888 is offline Member
    Join Date
    Nov 2010
    Posts
    9

    Default IMAP stuck with "In Progress"

    For some reason, IMAP works for gmail accounts, but not for my server account.

    Based on this log, can someone tell me why this might be the case? This is the log that is generated when the scheduler gets stuck with the "In Progress" message:

    Code:
    Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] ----->Scheduler found valid job (Check All IMAP) for time GMT(2010-11-09 11:16)
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] Retrieve User : SELECT users.* FROM users  WHERE users.id = '1'  AND users.deleted=0
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] Limit Query:SELECT users.* FROM users  WHERE users.id = '1'  AND users.deleted=0 Start: 0 count: 1
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query:SELECT users.* FROM users  WHERE users.id = '1'  AND users.deleted=0 LIMIT 0,1
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query Execution Time:0.00051307678222656
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query:SELECT u1.first_name, u1.last_name from users  u1, users  u2 where u1.id = u2.reports_to_id AND u2.id = '1' and u1.deleted=0
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query Execution Time:0.00047206878662109
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] additional detail query results: 
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] SugarBean.load_relationships, Loading relationship (reports_to_id).
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query:SELECT ea.*, ear.* FROM email_addresses ea
                LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
                WHERE ear.bean_module = 'Users'
                AND ear.bean_id = '1'
                AND ear.deleted = 0
                ORDER BY ear.reply_to_address, ear.primary_address DESC
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query Execution Time:0.00057005882263184
Tue Nov  9 06:16:02 2010 [24258][1][DEPRECATED] Formatting correction: SchedulersJobs->date_entered had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Nov  9 06:16:02 2010 [24258][1][DEPRECATED] Formatting correction: SchedulersJobs->date_modified had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Nov  9 06:16:02 2010 [24258][1][DEPRECATED] Formatting correction: SchedulersJobs->execute_time had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Nov  9 06:16:02 2010 [24258][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Insert: INSERT into schedulers_times set id='b4db0447-78c6-3fe8-3135-4cd92dbf77c5', deleted='0', date_entered='2010-11-09 11:16:02', date_modified='2010-11-09 11:16:02', scheduler_id='8ef62032-a8a0-2849-29b6-4cd92d16f5e7', execute_time='2010-11-09 11:16:00', status='ready'
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Save: INSERT into schedulers_times set id='b4db0447-78c6-3fe8-3135-4cd92dbf77c5', deleted='0', date_entered='2010-11-09 11:16:02', date_modified='2010-11-09 11:16:02', scheduler_id='8ef62032-a8a0-2849-29b6-4cd92d16f5e7', execute_time='2010-11-09 11:16:00', status='ready'
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query:INSERT into schedulers_times set id='b4db0447-78c6-3fe8-3135-4cd92dbf77c5', deleted='0', date_entered='2010-11-09 11:16:02', date_modified='2010-11-09 11:16:02', scheduler_id='8ef62032-a8a0-2849-29b6-4cd92d16f5e7', execute_time='2010-11-09 11:16:00', status='ready'
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query Execution Time:0.00047492980957031
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] Retrieve SchedulersJob : SELECT schedulers_times.* FROM schedulers_times  WHERE schedulers_times.id = 'b4db0447-78c6-3fe8-3135-4cd92dbf77c5'  AND schedulers_times.deleted=0
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] Limit Query:SELECT schedulers_times.* FROM schedulers_times  WHERE schedulers_times.id = 'b4db0447-78c6-3fe8-3135-4cd92dbf77c5'  AND schedulers_times.deleted=0 Start: 0 count: 1
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query:SELECT schedulers_times.* FROM schedulers_times  WHERE schedulers_times.id = 'b4db0447-78c6-3fe8-3135-4cd92dbf77c5'  AND schedulers_times.deleted=0 LIMIT 0,1
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query Execution Time:0.00037693977355957
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] ----->Scheduler found a job of type FUNCTION
Tue Nov  9 06:16:02 2010 [24258][1][INFO] -----> SchedulersJob setting Job flag: in progress AND setting Scheduler status to: In Progress
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] Retrieve schedulers : SELECT schedulers.* FROM schedulers  WHERE schedulers.id = '8ef62032-a8a0-2849-29b6-4cd92d16f5e7'  AND schedulers.deleted=0
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] Limit Query:SELECT schedulers.* FROM schedulers  WHERE schedulers.id = '8ef62032-a8a0-2849-29b6-4cd92d16f5e7'  AND schedulers.deleted=0 Start: 0 count: 1
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query:SELECT schedulers.* FROM schedulers  WHERE schedulers.id = '8ef62032-a8a0-2849-29b6-4cd92d16f5e7'  AND schedulers.deleted=0 LIMIT 0,1
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query Execution Time:0.00043082237243652
Tue Nov  9 06:16:02 2010 [24258][1][DEPRECATED] Formatting correction: Schedulers->date_entered had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Nov  9 06:16:02 2010 [24258][1][DEPRECATED] Formatting correction: Schedulers->date_modified had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Nov  9 06:16:02 2010 [24258][1][DEPRECATED] Formatting correction: Schedulers->date_time_start had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Nov  9 06:16:02 2010 [24258][1][DEPRECATED] Formatting correction: Schedulers->date_time_end had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Nov  9 06:16:02 2010 [24258][1][DEPRECATED] Formatting correction: Schedulers->last_run had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Nov  9 06:16:02 2010 [24258][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Update schedulers: Update schedulers set deleted='0', date_modified='2010-11-09 11:16:02', created_by='58521a0d-ed64-83fe-4b3e-4cd7671d1459', modified_user_id='1', name='Check All IMAP', job='function::pollMonitoredInboxes', date_time_start='2005-01-01 06:00:00', date_time_end=null, job_interval='*/30::*::*::*::*', time_from=null, time_to=null, last_run=null, status='In Progress', catch_up='1' WHERE ID = '8ef62032-a8a0-2849-29b6-4cd92d16f5e7'
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Save: Update schedulers set deleted='0', date_modified='2010-11-09 11:16:02', created_by='58521a0d-ed64-83fe-4b3e-4cd7671d1459', modified_user_id='1', name='Check All IMAP', job='function::pollMonitoredInboxes', date_time_start='2005-01-01 06:00:00', date_time_end=null, job_interval='*/30::*::*::*::*', time_from=null, time_to=null, last_run=null, status='In Progress', catch_up='1' WHERE ID = '8ef62032-a8a0-2849-29b6-4cd92d16f5e7'
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query:Update schedulers set deleted='0', date_modified='2010-11-09 11:16:02', created_by='58521a0d-ed64-83fe-4b3e-4cd7671d1459', modified_user_id='1', name='Check All IMAP', job='function::pollMonitoredInboxes', date_time_start='2005-01-01 06:00:00', date_time_end=null, job_interval='*/30::*::*::*::*', time_from=null, time_to=null, last_run=null, status='In Progress', catch_up='1' WHERE ID = '8ef62032-a8a0-2849-29b6-4cd92d16f5e7'
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query Execution Time:0.00042200088500977
Tue Nov  9 06:16:02 2010 [24258][1][DEPRECATED] Formatting correction: SchedulersJobs->date_entered had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Nov  9 06:16:02 2010 [24258][1][DEPRECATED] Formatting correction: SchedulersJobs->date_modified had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Nov  9 06:16:02 2010 [24258][1][DEPRECATED] Formatting correction: SchedulersJobs->execute_time had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Nov  9 06:16:02 2010 [24258][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Update SchedulersJob: Update schedulers_times set deleted='0', date_modified='2010-11-09 11:16:02', scheduler_id='8ef62032-a8a0-2849-29b6-4cd92d16f5e7', execute_time='2010-11-09 11:16:00', status='in progress' WHERE ID = 'b4db0447-78c6-3fe8-3135-4cd92dbf77c5'
    Reply With Quote Reply With Quote
  2. 2010-11-09, 10:26 AM #2
    trader88888
    trader88888 is offline Member
    Join Date
    Nov 2010
    Posts
    9

    Default Re: IMAP stuck with "In Progress"

    Rest of the log (to many characters to post it all)

    Code:
    Tue Nov  9 06:16:02 2010 [24258][1][INFO] Save: Update schedulers_times set deleted='0', date_modified='2010-11-09 11:16:02', scheduler_id='8ef62032-a8a0-2849-29b6-4cd92d16f5e7', execute_time='2010-11-09 11:16:00', status='in progress' WHERE ID = 'b4db0447-78c6-3fe8-3135-4cd92dbf77c5'
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query:Update schedulers_times set deleted='0', date_modified='2010-11-09 11:16:02', scheduler_id='8ef62032-a8a0-2849-29b6-4cd92d16f5e7', execute_time='2010-11-09 11:16:00', status='in progress' WHERE ID = 'b4db0447-78c6-3fe8-3135-4cd92dbf77c5'
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query Execution Time:0.00041413307189941
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] Retrieve SchedulersJob : SELECT schedulers_times.* FROM schedulers_times  WHERE schedulers_times.id = 'b4db0447-78c6-3fe8-3135-4cd92dbf77c5'  AND schedulers_times.deleted=0
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] Limit Query:SELECT schedulers_times.* FROM schedulers_times  WHERE schedulers_times.id = 'b4db0447-78c6-3fe8-3135-4cd92dbf77c5'  AND schedulers_times.deleted=0 Start: 0 count: 1
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query:SELECT schedulers_times.* FROM schedulers_times  WHERE schedulers_times.id = 'b4db0447-78c6-3fe8-3135-4cd92dbf77c5'  AND schedulers_times.deleted=0 LIMIT 0,1
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query Execution Time:0.00037884712219238
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] ----->SchedulersJob firing pollMonitoredInboxes
Tue Nov  9 06:16:02 2010 [24258][1][INFO] ----->Scheduler fired job of type pollMonitoredInboxes()
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] Loading Preferences DB chrish
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query:SELECT contents FROM user_preferences WHERE assigned_user_id='1' AND category = 'Emails' AND deleted = 0
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query Execution Time:0.00049495697021484
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query:SELECT id, name FROM inbound_email WHERE is_personal = 0 AND deleted=0 AND status='Active' AND mailbox_type != 'bounce'
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query Execution Time:0.00046586990356445
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] Just got Result from get all Inbounds of Inbound Emails
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] In while loop of Inbound Emails
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] Retrieve InboundEmail : SELECT inbound_email.* FROM inbound_email  WHERE inbound_email.id = '2ac97811-e4fc-0afc-92e2-4cd70a8285bc'  AND inbound_email.deleted=0
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] Limit Query:SELECT inbound_email.* FROM inbound_email  WHERE inbound_email.id = '2ac97811-e4fc-0afc-92e2-4cd70a8285bc'  AND inbound_email.deleted=0 Start: 0 count: 1
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query:SELECT inbound_email.* FROM inbound_email  WHERE inbound_email.id = '2ac97811-e4fc-0afc-92e2-4cd70a8285bc'  AND inbound_email.deleted=0 LIMIT 0,1
Tue Nov  9 06:16:02 2010 [24258][1][INFO] Query Execution Time:0.00049400329589844
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] Trying to connect to mailserver for [ John Dale ]
Tue Nov  9 06:16:02 2010 [24258][1][DEBUG] Connected to mailserver
Tue Nov  9 06:17:01 2010 [24289][-none-][INFO] using MysqliManager DBManager backend
Tue Nov  9 06:17:01 2010 [24289][-none-][INFO] using MysqliHelper DBHelper backend
Tue Nov  9 06:17:01 2010 [24289][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0
Tue Nov  9 06:17:01 2010 [24289][-none-][INFO] Query Execution Time:0.00037097930908203
Tue Nov  9 06:17:01 2010 [24289][-none-][INFO] Query:SELECT category, name, value FROM config
Tue Nov  9 06:17:01 2010 [24289][-none-][INFO] Query Execution Time:0.00037884712219238
Tue Nov  9 06:17:01 2010 [24289][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system'
Tue Nov  9 06:17:01 2010 [24289][-none-][INFO] Query Execution Time:0.0003821849822998
Tue Nov  9 06:17:01 2010 [24289][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = '40391ff6-6cc8-2d15-2681-4cd7058cc14c'
Tue Nov  9 06:17:01 2010 [24289][-none-][INFO] Query Execution Time:0.00040316581726074
Tue Nov  9 06:17:01 2010 [24289][-none-][DEBUG] Retrieve User : SELECT users.* FROM users  WHERE users.id = '1'  AND users.deleted=0
Tue Nov  9 06:17:01 2010 [24289][-none-][DEBUG] Limit Query:SELECT users.* FROM users  WHERE users.id = '1'  AND users.deleted=0 Start: 0 count: 1
Tue Nov  9 06:17:01 2010 [24289][-none-][INFO] Query:SELECT users.* FROM users  WHERE users.id = '1'  AND users.deleted=0 LIMIT 0,1
Tue Nov  9 06:17:01 2010 [24289][-none-][INFO] Query Execution Time:0.00049495697021484
Tue Nov  9 06:17:01 2010 [24289][1][DEBUG] Loading Preferences DB chrish
Tue Nov  9 06:17:01 2010 [24289][1][INFO] Query:SELECT contents FROM user_preferences WHERE assigned_user_id='1' AND category = 'global' AND deleted = 0
Tue Nov  9 06:17:01 2010 [24289][1][INFO] Query Execution Time:0.0004730224609375
Tue Nov  9 06:17:01 2010 [24289][1][INFO] Query:SELECT u1.first_name, u1.last_name from users  u1, users  u2 where u1.id = u2.reports_to_id AND u2.id = '1' and u1.deleted=0
Tue Nov  9 06:17:01 2010 [24289][1][INFO] Query Execution Time:0.00041389465332031
Tue Nov  9 06:17:01 2010 [24289][1][DEBUG] additional detail query results: 
Tue Nov  9 06:17:01 2010 [24289][1][DEBUG] SugarBean.load_relationships, Loading relationship (reports_to_id).
Tue Nov  9 06:17:01 2010 [24289][1][INFO] Query:SELECT ea.*, ear.* FROM email_addresses ea
                LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
                WHERE ear.bean_module = 'Users'
                AND ear.bean_id = '1'
                AND ear.deleted = 0
                ORDER BY ear.reply_to_address, ear.primary_address DESC
Tue Nov  9 06:17:01 2010 [24289][1][INFO] Query Execution Time:0.00061511993408203
Tue Nov  9 06:17:01 2010 [24289][1][DEBUG] --------------------------------------------> at cron.php <--------------------------------------------
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Incoming Email Schedule stuck "In Progress"
    By trader88888 in forum Help
    Replies: 1
    Last Post: 2010-11-09, 01:28 AM
  2. Scheduler for bounced campaigns remaining "In Progress", not completing
    By Hauke in forum Help
    Replies: 1
    Last Post: 2009-08-11, 01:12 PM
  3. 4.2 inbound email scheduler hangs with "In progress" ???
    By dudeer in forum Help
    Replies: 13
    Last Post: 2009-08-11, 01:10 PM
  4. Emails hold on "in progress" status
    By roberto.fabbri in forum Help
    Replies: 2
    Last Post: 2009-08-11, 01:06 PM
  5. Workflow scheduler stuck in "In Progress"
    By tenaciousd in forum Help
    Replies: 0
    Last Post: 2006-06-13, 11:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules