error on suite database

Hi

every day i have an error in my suite instance. when a user access to a lead or contact, the history panel dont appear and it says: "database error, please refer to sugarcrm.log

in the log i have the following

Sun May 29 17:05:01 2016 [5604][e8df21fa-2341-5141-3a67-55db4b6d72a0][FATAL] Error retrieving Lead list: Query Failed: (SELECT meetings.id , meetings.name , meetings.status , ’ ’ contact_name , ’ ’ contact_id , meetings.date_modified , meetings.date_entered , meetings.date_start , jt1.user_name assigned_user_name , meetings.assigned_user_id , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, 0 reply_to_status , ’ ’ contact_name_owner , ’ ’ contact_name_mod , meetings.parent_id , meetings.parent_type , ’ ’ filename , meetings.recurring_source , ’ ’ assigned_user_owner , ’ ’ assigned_user_mod , meetings.created_by , ‘meetings’ panel_name FROM meetings LEFT JOIN meetings_cstm ON meetings.id = meetings_cstm.id_c LEFT JOIN users jt1 ON meetings.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 INNER JOIN meetings_leads ON meetings.id=meetings_leads.meeting_id AND meetings_leads.lead_id=‘dbdcfbce-6b00-c709-611c-574a4a44f738’ AND meetings_leads.deleted=0

where ((meetings.status=‘Held’ OR meetings.status=‘Not Held’)) AND meetings.deleted=0) UNION ALL ( SELECT meetings.id , meetings.name , meetings.status , ’ ’ contact_name , ’ ’ contact_id , meetings.date_modified , meetings.date_entered , meetings.date_start , jt1.user_name assigned_user_name , meetings.assigned_user_id , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, 0 reply_to_status , ’ ’ contact_name_owner , ’ ’ contact_name_mod , meetings.parent_id , meetings.parent_type , ’ ’ filename , meetings.recurring_source , ’ ’ assigned_user_owner , ’ ’ assigned_user_mod , meetings.created_by , ‘oldmeetings’ panel_name FROM meetings LEFT JOIN meetings_cstm ON meetings.id = meetings_cstm.id_c LEFT JOIN users jt1 ON meetings.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 where ( meetings.parent_id = ‘dbdcfbce-6b00-c709-611c-574a4a44f738’
AND meetings.parent_type = ‘Leads’ AND meetings.id NOT IN ( SELECT meeting_id FROM meetings_leads ) AND (meetings.status=‘Held’ OR meetings.status=‘Not Held’)) AND meetings.deleted=0 ) UNION ALL ( SELECT tasks.id , tasks.name , tasks.status , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , tasks.contact_id , tasks.date_modified , tasks.date_entered , tasks.date_due as date_start , jt1.user_name assigned_user_name , tasks.assigned_user_id , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, 0 reply_to_status , ’ ’ contact_name_owner , ’ ’ contact_name_mod , tasks.parent_id , tasks.parent_type , ’ ’ filename , NULL recurring_source, ’ ’ assigned_user_owner , ’ ’ assigned_user_mod , tasks.created_by , ‘tasks’ panel_name FROM tasks LEFT JOIN contacts contacts ON tasks.contact_id=contacts.id AND contacts.deleted=0

AND contacts.deleted=0 LEFT JOIN users jt1 ON tasks.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 INNER JOIN leads tasks_rel ON tasks.parent_id=tasks_rel.id AND tasks_rel.deleted=0
AND tasks.parent_type = ‘Leads’
where ( tasks.parent_id=‘dbdcfbce-6b00-c709-611c-574a4a44f738’ AND (tasks.status=‘Completed’ OR tasks.status=‘Deferred’)) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.name , calls.status , ’ ’ contact_name , ’ ’ contact_id , calls.date_modified , calls.date_entered , calls.date_start , jt1.user_name assigned_user_name , calls.assigned_user_id , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, 0 reply_to_status , ’ ’ contact_name_owner , ’ ’ contact_name_mod , calls.parent_id , calls.parent_type , ’ ’ filename , calls.recurring_source , ’ ’ assigned_user_owner , ’ ’ assigned_user_mod , calls.created_by , ‘calls’ panel_name FROM calls LEFT JOIN calls_cstm ON calls.id = calls_cstm.id_c LEFT JOIN users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 INNER JOIN calls_leads ON calls.id=calls_leads.call_id AND calls_leads.lead_id=‘dbdcfbce-6b00-c709-611c-574a4a44f738’ AND calls_leads.deleted=0

where ((calls.status=‘Held’ OR calls.status=‘Not Held’)) AND calls.deleted=0 ) UNION ALL ( SELECT calls.id , calls.name , calls.status , ’ ’ contact_name , ’ ’ contact_id , calls.date_modified , calls.date_entered , calls.date_start , jt1.user_name assigned_user_name , calls.assigned_user_id , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, 0 reply_to_status , ’ ’ contact_name_owner , ’ ’ contact_name_mod , calls.parent_id , calls.parent_type , ’ ’ filename , calls.recurring_source , ’ ’ assigned_user_owner , ’ ’ assigned_user_mod , calls.created_by , ‘oldcalls’ panel_name FROM calls LEFT JOIN calls_cstm ON calls.id = calls_cstm.id_c LEFT JOIN users jt1 ON calls.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 where ( calls.parent_id = ‘dbdcfbce-6b00-c709-611c-574a4a44f738’
AND calls.parent_type = ‘Leads’ AND calls.id NOT IN ( SELECT call_id FROM calls_leads ) AND (calls.status=‘Held’ OR calls.status=‘Not Held’)) AND calls.deleted=0 ) UNION ALL ( SELECT notes.id , notes.name , ’ ’ status , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,’’),’ ‘,IFNULL(contacts.last_name,’’)))) contact_name , notes.contact_id , notes.date_modified , notes.date_entered , NULL date_start, jt1.user_name assigned_user_name , notes.assigned_user_id , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, 0 reply_to_status , ’ ’ contact_name_owner , ’ ’ contact_name_mod , notes.parent_id , notes.parent_type , notes.filename , NULL recurring_source, ’ ’ assigned_user_owner , ’ ’ assigned_user_mod , notes.created_by , ‘notes’ panel_name FROM notes LEFT JOIN notes_cstm ON notes.id = notes_cstm.id_c LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0

AND contacts.deleted=0 LEFT JOIN users jt1 ON notes.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 INNER JOIN leads notes_rel ON notes.parent_id=notes_rel.id AND notes_rel.deleted=0
AND notes.parent_type = ‘Leads’
where ( notes.parent_id=‘dbdcfbce-6b00-c709-611c-574a4a44f738’) AND notes.deleted=0 ) UNION ALL ( SELECT emails.id , emails.name , emails.status , ’ ’ contact_name , ’ ’ contact_id , emails.date_modified , emails.date_entered , NULL date_start, jt0.user_name assigned_user_name , emails.assigned_user_id , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, emails.reply_to_status , ’ ’ contact_name_owner , ’ ’ contact_name_mod , emails.parent_id , emails.parent_type , ’ ’ filename , NULL recurring_source, ’ ’ assigned_user_owner , ’ ’ assigned_user_mod , emails.created_by , ‘emails’ panel_name FROM emails LEFT JOIN users jt0 ON emails.assigned_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 INNER JOIN emails_beans ON emails.id=emails_beans.email_id AND emails_beans.bean_id=‘dbdcfbce-6b00-c709-611c-574a4a44f738’ AND emails_beans.deleted=0
AND emails_beans.bean_module = ‘Leads’
where emails.deleted=0 ) UNION ALL ( SELECT emails.id , emails.name , emails.status , ’ ’ contact_name , ’ ’ contact_id , emails.date_modified , emails.date_entered , NULL date_start, jt0.user_name assigned_user_name , emails.assigned_user_id , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, emails.reply_to_status , ’ ’ contact_name_owner , ’ ’ contact_name_mod , emails.parent_id , emails.parent_type , ’ ’ filename , NULL recurring_source, ’ ’ assigned_user_owner , ’ ’ assigned_user_mod , emails.created_by , ‘linkedemails’ panel_name FROM emails LEFT JOIN users jt0 ON emails.assigned_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 JOIN (select DISTINCT email_id from emails_email_addr_rel eear

join email_addr_bean_rel eabr on eabr.bean_id ='dbdcfbce-6b00-c709-611c-574a4a44f738' and eabr.bean_module = 'Leads' and
eabr.email_address_id = eear.email_address_id and eabr.deleted=0
where eear.deleted=0 and eear.email_id not in
(select eb.email_id from emails_beans eb where eb.bean_module ='Leads' and eb.bean_id = 'dbdcfbce-6b00-c709-611c-574a4a44f738')
) derivedemails on derivedemails.email_id = emails.id  where emails.deleted=0 ) ORDER BY date_entered desc LIMIT 0,11: MySQL error 1153: Got a packet bigger than 'max_allowed_packet' bytes

i was modify the my.cnf file increasing the max_allowed_packet value to 100M but the error still appears, the oly thing to do to fix this is to restart mysql service, but a few hours later , error appears again

I was do a clean install of the mysql database in a new server but the error still happening, can you help me?

Thanks