OK The only thing I can see in the php directory is an LDAP Error that is coming up each and every minute more of a strict standards warning message
[14-Mar-2017 15:36:06 UTC] PHP Strict Standards: Declaration of SugarEmailAddress::save() should be compatible with SugarBean::save($check_notify = false) in /srv/www/htdocs/include/SugarEmailAddress/SugarEmailAddress.php on line 0
[14-Mar-2017 15:36:06 UTC] PHP Strict Standards: Declaration of LDAPAuthenticateUser::authenticateUser() should be compatible with SugarAuthenticateUser::authenticateUser($name, $password, $fallback = false) in /srv/www/htdocs/modules/Users/authentication/LDAPAuthenticate/LDAPAuthenticateUser.php on line 52
BUT this iâm sure is a red herring as it comes up every single minute if not twice a minute itâs not related iâm sure. So nothing in the PHP log?
Tue Mar 14 15:35:01 2017 [2433][-none-][INFO] Found language file: en_us.lang.php
Tue Mar 14 15:35:01 2017 [2433][-none-][INFO] Found extended language file: en_us.lang.ext.php
Tue Mar 14 15:35:01 2017 [2433][-none-][INFO] Found custom language file: en_us.lang.php
Tue Mar 14 15:35:01 2017 [2433][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = âActiveâ and deleted = 0
Tue Mar 14 15:35:01 2017 [2433][-none-][INFO] Query Execution Time:0.00032806396484375
Tue Mar 14 15:35:01 2017 [2433][-none-][INFO] Query:SELECT category, name, value FROM config
Tue Mar 14 15:35:01 2017 [2433][-none-][INFO] Query Execution Time:0.00028896331787109
Tue Mar 14 15:35:01 2017 [2433][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = âsystemâ
Tue Mar 14 15:35:01 2017 [2433][-none-][INFO] Query Execution Time:0.00017499923706055
Tue Mar 14 15:35:01 2017 [2433][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = âe9c81514-cffb-3988-262e-5630c1132f95â
Tue Mar 14 15:35:01 2017 [2433][-none-][INFO] Query Execution Time:0.00018000602722168
Tue Mar 14 15:35:01 2017 [2433][-none-][INFO] Found language file: en_us.lang.php
Tue Mar 14 15:35:01 2017 [2433][-none-][INFO] Found extended language file: en_us.lang.ext.php
Tue Mar 14 15:35:01 2017 [2433][-none-][INFO] Found custom language file: en_us.lang.php
Tue Mar 14 15:35:01 2017 [2433][-none-][INFO] Query:SELECT users.,users_cstm. FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c WHERE users.id = â1â AND users.deleted=0 LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][-none-][INFO] Query Execution Time:0.00031590461730957
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT contents FROM user_preferences WHERE assigned_user_id=â1â AND category = âglobalâ AND deleted = 0
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00026702880859375
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id, first_name, last_name, user_name FROM users WHERE 1=1 ORDER BY first_name, last_name ASC
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00037002563476562
Tue Mar 14 15:35:01 2017 [2433][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 Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00017309188842773
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified,
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00059103965759277
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id FROM job_queue WHERE status=ârunningâ AND date_modified <= â2017-03-13 15:35:01â
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00026392936706543
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query: SELECT schedulers.* , jt0.user_name created_by_name , jt0.created_by created_by_name_owner , âUsersâ created_by_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , âUsersâ modified_by_name_mod FROM schedulers LEFT JOIN users jt0 ON jt0.id=schedulers.created_by AND jt0.deleted=0
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00074315071105957
Tue Mar 14 15:35:01 2017 [2433][1][INFO] -----> Scheduler found [ 13 ] ACTIVE jobs
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Get One: |SELECT id FROM users WHERE id = â1â AND is_admin = 1 AND deleted = 0 AND status = âActiveâ|
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id FROM users WHERE id = â1â AND is_admin = 1 AND deleted = 0 AND status = âActiveâ LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00023102760314941
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT users.,users_cstm. FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c WHERE users.id = â1â AND users.deleted=0 LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00022411346435547
Tue Mar 14 15:35:01 2017 [2433][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 Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00016379356384277
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified,
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00035810470581055
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Get One: |SELECT id FROM users WHERE id = â1â AND is_admin = 1 AND deleted = 0 AND status = âActiveâ|
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id FROM users WHERE id = â1â AND is_admin = 1 AND deleted = 0 AND status = âActiveâ LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.0001530647277832
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT users.,users_cstm. FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c WHERE users.id = â1â AND users.deleted=0 LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.0001988410949707
Tue Mar 14 15:35:01 2017 [2433][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 Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00015497207641602
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified,
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00029182434082031
Tue Mar 14 15:35:01 2017 [2433][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:INSERT INTO job_queue (assigned_user_id,id,name,deleted,date_entered,date_modified,scheduler_id,execute_time,status,resolution,target,requeue,job_delay,client)
VALUES (â1â,â4a463e75-2a2f-2272-a7ce-58c80d26a6d7â,âProcess Workflow Tasksâ,0,â2017-03-14 15:35:01â,â2017-03-14 15:35:01â,â303c73c1-1e89-4616-eb47-57b6e57e14b5â,â2017-03-14 15:35:01â,âqueuedâ,âqueuedâ,âfunction::processAOW_Workflowâ,0,0,ââ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.0011510848999023
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00052714347839355
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.0004429817199707
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00049591064453125
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00043678283691406
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT aod_index.* FROM aod_index WHERE aod_index.id = â1â AND aod_index.deleted=0 LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00032615661621094
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = âSchedulersJobsâ AND aow_workflow.status = âActiveâ AND (aow_workflow.run_when = âAlwaysâ OR aow_workflow.run_when = âOn_Saveâ OR aow_workflow.run_when = âCreateâ) AND aow_workflow.deleted = 0
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00023603439331055
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Get One: |SELECT id FROM users WHERE id = â1â AND is_admin = 1 AND deleted = 0 AND status = âActiveâ|
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id FROM users WHERE id = â1â AND is_admin = 1 AND deleted = 0 AND status = âActiveâ LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00020313262939453
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT users.,users_cstm. FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c WHERE users.id = â1â AND users.deleted=0 LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00024104118347168
Tue Mar 14 15:35:01 2017 [2433][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 Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00016903877258301
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified,
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00032901763916016
Tue Mar 14 15:35:01 2017 [2433][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:INSERT INTO job_queue (assigned_user_id,id,name,deleted,date_entered,date_modified,scheduler_id,execute_time,status,resolution,target,requeue,job_delay,client)
VALUES (â1â,â537c899d-d9f1-96de-a0b0-58c80d6f9d2câ,âRun Report Generation Scheduled Tasksâ,0,â2017-03-14 15:35:01â,â2017-03-14 15:35:01â,â320bb59e-7d95-82ee-3a65-57b6e5d65f30â,â2017-03-14 15:35:01â,âqueuedâ,âqueuedâ,âfunction::aorRunScheduledReportsâ,0,0,ââ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00087809562683105
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00049781799316406
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00044894218444824
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00043320655822754
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.0004270076751709
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = âSchedulersJobsâ AND aow_workflow.status = âActiveâ AND (aow_workflow.run_when = âAlwaysâ OR aow_workflow.run_when = âOn_Saveâ OR aow_workflow.run_when = âCreateâ) AND aow_workflow.deleted = 0
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00018906593322754
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Get One: |SELECT id FROM users WHERE id = â1â AND is_admin = 1 AND deleted = 0 AND status = âActiveâ|
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id FROM users WHERE id = â1â AND is_admin = 1 AND deleted = 0 AND status = âActiveâ LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00016498565673828
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT users.,users_cstm. FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c WHERE users.id = â1â AND users.deleted=0 LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.0002131462097168
Tue Mar 14 15:35:01 2017 [2433][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 Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00015711784362793
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified,
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00030612945556641
Tue Mar 14 15:35:01 2017 [2433][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:INSERT INTO job_queue (assigned_user_id,id,name,deleted,date_entered,date_modified,scheduler_id,execute_time,status,resolution,target,requeue,job_delay,client)
VALUES (â1â,â5644be14-1758-956a-cd4b-58c80d4ebb27â,âCheck Inbound Mailboxesâ,0,â2017-03-14 15:35:01â,â2017-03-14 15:35:01â,â34097565-d5f9-7be6-1ae7-57b6e51edfd0â,â2017-03-14 15:35:01â,âqueuedâ,âqueuedâ,âfunction::pollMonitoredInboxesAOPâ,0,0,ââ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00069093704223633
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.0004580020904541
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00043010711669922
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00043702125549316
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.0004270076751709
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = âSchedulersJobsâ AND aow_workflow.status = âActiveâ AND (aow_workflow.run_when = âAlwaysâ OR aow_workflow.run_when = âOn_Saveâ OR aow_workflow.run_when = âCreateâ) AND aow_workflow.deleted = 0
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00019598007202148
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Get One: |SELECT id FROM users WHERE id = â1â AND is_admin = 1 AND deleted = 0 AND status = âActiveâ|
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id FROM users WHERE id = â1â AND is_admin = 1 AND deleted = 0 AND status = âActiveâ LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00017714500427246
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT users.,users_cstm. FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c WHERE users.id = â1â AND users.deleted=0 LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00020408630371094
Tue Mar 14 15:35:01 2017 [2433][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 Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00017499923706055
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified,
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00028896331787109
Tue Mar 14 15:35:01 2017 [2433][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:INSERT INTO job_queue (assigned_user_id,id,name,deleted,date_entered,date_modified,scheduler_id,execute_time,status,resolution,target,requeue,job_delay,client)
VALUES (â1â,â585d8ea2-7931-16c4-988f-58c80dc2e132â,âPrune Database on 1st of Monthâ,0,â2017-03-14 15:35:01â,â2017-03-14 15:35:01â,â37066481-bc11-f659-9775-57b6e5da6c25â,â2017-03-14 15:35:01â,âqueuedâ,âqueuedâ,âfunction::pruneDatabaseâ,0,0,ââ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00075912475585938
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00044894218444824
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00043106079101562
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.0004270076751709
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00042891502380371
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = âSchedulersJobsâ AND aow_workflow.status = âActiveâ AND (aow_workflow.run_when = âAlwaysâ OR aow_workflow.run_when = âOn_Saveâ OR aow_workflow.run_when = âCreateâ) AND aow_workflow.deleted = 0
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00018095970153809
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Get One: |SELECT id FROM users WHERE id = â1â AND is_admin = 1 AND deleted = 0 AND status = âActiveâ|
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id FROM users WHERE id = â1â AND is_admin = 1 AND deleted = 0 AND status = âActiveâ LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00015091896057129
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT users.,users_cstm. FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c WHERE users.id = â1â AND users.deleted=0 LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00020694732666016
Tue Mar 14 15:35:01 2017 [2433][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 Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00015616416931152
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified,
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00027680397033691
Tue Mar 14 15:35:01 2017 [2433][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:INSERT INTO job_queue (assigned_user_id,id,name,deleted,date_entered,date_modified,scheduler_id,execute_time,status,resolution,target,requeue,job_delay,client)
VALUES (â1â,â5b1f6b26-9907-9e4d-2b5e-58c80d11fd2bâ,âRun Email Reminder Notificationsâ,0,â2017-03-14 15:35:01â,â2017-03-14 15:35:01â,â3a3c05ed-2942-238d-5e96-57b6e54b6eebâ,â2017-03-14 15:35:01â,âqueuedâ,âqueuedâ,âfunction::sendEmailRemindersâ,0,0,ââ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00079703330993652
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00047802925109863
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00043702125549316
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00043106079101562
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00042510032653809
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = âSchedulersJobsâ AND aow_workflow.status = âActiveâ AND (aow_workflow.run_when = âAlwaysâ OR aow_workflow.run_when = âOn_Saveâ OR aow_workflow.run_when = âCreateâ) AND aow_workflow.deleted = 0
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.0002140998840332
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Get One: |SELECT id FROM job_queue WHERE execute_time <= â2017-03-14 15:35:01â AND status = âqueuedâ ORDER BY date_entered ASC|
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id FROM job_queue WHERE execute_time <= â2017-03-14 15:35:01â AND status = âqueuedâ ORDER BY date_entered ASC LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00029301643371582
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT job_queue.* FROM job_queue WHERE job_queue.id = â5b1f6b26-9907-9e4d-2b5e-58c80d11fd2bâ AND job_queue.deleted=0 LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00016999244689941
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:UPDATE job_queue SET status=ârunningâ, date_modified=â2017-03-14 15:35:01â, client=âCRON70785c528a9795a536968c27febffdc7:2433â WHERE id=â5b1f6b26-9907-9e4d-2b5e-58c80d11fd2bâ AND status=âqueuedâ
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00085115432739258
Tue Mar 14 15:35:01 2017 [2433][1][DEPRECATED] Formatting correction: SchedulersJobs->date_entered had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Mar 14 15:35:01 2017 [2433][1][DEPRECATED] Formatting correction: SchedulersJobs->date_modified had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Mar 14 15:35:01 2017 [2433][1][DEPRECATED] Formatting correction: SchedulersJobs->execute_time had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Mar 14 15:35:01 2017 [2433][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:UPDATE job_queue
SET assigned_user_id
=â1â,name
=âRun Email Reminder Notificationsâ,date_modified
=â2017-03-14 15:35:01â,scheduler_id
=â3a3c05ed-2942-238d-5e96-57b6e54b6eebâ,execute_time
=â2017-03-14 15:35:00â,status
=ârunningâ,resolution
=âqueuedâ,message
=NULL,target
=âfunction::sendEmailRemindersâ,data
=NULL,requeue
=0,retry_count
=NULL,failure_count
=NULL,job_delay
=0,client
=âCRON70785c528a9795a536968c27febffdc7:2433â,percent_complete
=NULL
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00080204010009766
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00043988227844238
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = âSchedulersJobsâ AND aow_workflow.status = âActiveâ AND (aow_workflow.run_when = âAlwaysâ OR aow_workflow.run_when = âOn_Saveâ OR aow_workflow.run_when = âCreateâ) AND aow_workflow.deleted = 0
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00019502639770508
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT users.,users_cstm. FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c WHERE users.id = â1â AND users.deleted=0 LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00026822090148926
Tue Mar 14 15:35:01 2017 [2433][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 Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00016498565673828
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified,
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00032591819763184
Tue Mar 14 15:35:01 2017 [2433][1][INFO] ----->Scheduler fired job of type sendEmailReminders()
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query: SELECT reminders.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , âUsersâ modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , âUsersâ created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , âUsersâ assigned_user_name_mod FROM reminders LEFT JOIN users jt0 ON reminders.modified_user_id=jt0.id AND jt0.deleted=0
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00075888633728027
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:
AND date_start >= â2017-03-14 15:35:01â
AND date_start <= â2017-03-15 15:35:01â
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00023603439331055
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:
AND date_start >= â2017-03-14 15:35:01â
AND date_start <= â2017-03-15 15:35:01â
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00026202201843262
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Resolving job 5b1f6b26-9907-9e4d-2b5e-58c80d11fd2b as success:
Tue Mar 14 15:35:01 2017 [2433][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:UPDATE job_queue
SET assigned_user_id
=â1â,name
=âRun Email Reminder Notificationsâ,date_modified
=â2017-03-14 15:35:01â,scheduler_id
=â3a3c05ed-2942-238d-5e96-57b6e54b6eebâ,execute_time
=â2017-03-14 15:35:00â,status
=âdoneâ,resolution
=âsuccessâ,message
=NULL,target
=âfunction::sendEmailRemindersâ,data
=NULL,requeue
=0,retry_count
=NULL,failure_count
=NULL,job_delay
=0,client
=âCRON70785c528a9795a536968c27febffdc7:2433â,percent_complete
=NULL
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00089287757873535
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.0004730224609375
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = âSchedulersJobsâ AND aow_workflow.status = âActiveâ AND (aow_workflow.run_when = âAlwaysâ OR aow_workflow.run_when = âOn_Saveâ OR aow_workflow.run_when = âCreateâ) AND aow_workflow.deleted = 0
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00018692016601562
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:UPDATE schedulers SET last_run=â2017-03-14 15:35:01â WHERE id=â3a3c05ed-2942-238d-5e96-57b6e54b6eebâ
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00068902969360352
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Get One: |SELECT id FROM job_queue WHERE execute_time <= â2017-03-14 15:35:01â AND status = âqueuedâ ORDER BY date_entered ASC|
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id FROM job_queue WHERE execute_time <= â2017-03-14 15:35:01â AND status = âqueuedâ ORDER BY date_entered ASC LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00024795532226562
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT job_queue.* FROM job_queue WHERE job_queue.id = â585d8ea2-7931-16c4-988f-58c80dc2e132â AND job_queue.deleted=0 LIMIT 0,1
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00019001960754395
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:UPDATE job_queue SET status=ârunningâ, date_modified=â2017-03-14 15:35:01â, client=âCRON70785c528a9795a536968c27febffdc7:2433â WHERE id=â585d8ea2-7931-16c4-988f-58c80dc2e132â AND status=âqueuedâ
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00070905685424805
Tue Mar 14 15:35:01 2017 [2433][1][DEPRECATED] Formatting correction: SchedulersJobs->date_entered had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Mar 14 15:35:01 2017 [2433][1][DEPRECATED] Formatting correction: SchedulersJobs->date_modified had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Mar 14 15:35:01 2017 [2433][1][DEPRECATED] Formatting correction: SchedulersJobs->execute_time had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Mar 14 15:35:01 2017 [2433][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:UPDATE job_queue
SET assigned_user_id
=â1â,name
=âPrune Database on 1st of Monthâ,date_modified
=â2017-03-14 15:35:01â,scheduler_id
=â37066481-bc11-f659-9775-57b6e5da6c25â,execute_time
=â2017-03-14 15:35:00â,status
=ârunningâ,resolution
=âqueuedâ,message
=NULL,target
=âfunction::pruneDatabaseâ,data
=NULL,requeue
=0,retry_count
=NULL,failure_count
=NULL,job_delay
=0,client
=âCRON70785c528a9795a536968c27febffdc7:2433â,percent_complete
=NULL
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.0032551288604736
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT lhs_module, rhs_module FROM relationships WHERE deleted=0 AND (lhs_module = âSecurityGroupsâ OR rhs_module=âSecurityGroupsâ)
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00043606758117676
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = âSchedulersJobsâ AND aow_workflow.status = âActiveâ AND (aow_workflow.run_when = âAlwaysâ OR aow_workflow.run_when = âOn_Saveâ OR aow_workflow.run_when = âCreateâ) AND aow_workflow.deleted = 0
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00018095970153809
Tue Mar 14 15:35:01 2017 [2433][1][INFO] ----->Scheduler fired job of type pruneDatabase()
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SHOW TABLES
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.0010130405426025
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:DESCRIBE accounts
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00059103965759277
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:DESCRIBE accounts_cstm
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query Execution Time:0.00073909759521484
Tue Mar 14 15:35:01 2017 [2433][1][INFO] Query:SELECT * FROM accounts WHERE deleted = 1
Tue Mar 14 15:35:16 2017 [2433][1][FATAL] Job 585d8ea2-7931-16c4-988f-58c80dc2e132 (Prune Database on 1st of Month) failed in CRON run
Tue Mar 14 15:35:16 2017 [2433][1][INFO] Resolving job 585d8ea2-7931-16c4-988f-58c80dc2e132 as failure: Unexpected failure, please check PHP logs and suitecrm.log
Tue Mar 14 15:35:16 2017 [2433][1][INFO] Query:SELECT contents FROM user_preferences WHERE assigned_user_id=â1â AND category = âglobalâ AND deleted = 0
Tue Mar 14 15:35:16 2017 [2433][1][INFO] Query Execution Time:0.00063514709472656
Tue Mar 14 15:35:16 2017 [2433][1][DEPRECATED] Formatting correction: SchedulersJobs->failure_count had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Tue Mar 14 15:35:16 2017 [2433][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Tue Mar 14 15:35:16 2017 [2433][1][INFO] Query:UPDATE job_queue
SET assigned_user_id
=â1â,name
=âPrune Database on 1st of Monthâ,date_modified
=â2017-03-14 15:35:01â,scheduler_id
=â37066481-bc11-f659-9775-57b6e5da6c25â,execute_time
=â2017-03-14 15:35:00â,status
=âdoneâ,resolution
=âfailureâ,message
=âUnexpected failure, please check PHP logs and suitecrm.log\nâ,target
=âfunction::pruneDatabaseâ,data
=NULL,requeue
=0,retry_count
=NULL,failure_count
=1,job_delay
=0,client
=âCRON70785c528a9795a536968c27febffdc7:2433â,percent_complete
=NULL
Tue Mar 14 15:35:16 2017 [2433][1][INFO] Query Execution Time:0.001924991607666