Got an other report with this issue: "Search Leads Logs"
same problem as in issue
http://www.vicidial.org/VICIDIALmantis/view.php?id=619* setup slave database
* use slave database for reports
* run a "Search Leads Logs" that uses slave + some other report that uses master later
then it uses the slave database for every query in admin_search_lead.php including "INSERT INTO vicidial_admin_log ...."
and when the master database does an other insert into vicidial_admin_log and the replication process copy it over to the slave then the slave complains when the private key id already exists:
Error 'Duplicate entry '23107' for key 'PRIMARY'' on query. Default database: 'asterisk'. Query: 'INSERT INTO vicidial_admin_log set event_date='2014-08-29 10:06:42', user='1234', ip_address='1.1.1.1', event_section='LEADS', event_type='SEARCH', record_id='616387', event_code='ADMIN SEARCH LEAD', event_sql="SELECT lead_id,entry_date,modify_date,status,user,vendor_lead_code,source_id,list_id,gmt_offset_now,called_since_last_reset,phone_code,phone_number,title,first_name,middle_initial,last_name,address1,address2,address3,city,state,province,postal_code,country_code,gender,date_of_birth,alt_phone,email,security_phrase,comments,called_count,last_local_call_time,rank,owner from vicidial_list where first_name=\\'eddie\\' and last_name=\\'meduza\\' order by last_local_call_time desc limit 1000|", event_notes='''
and the slave stops and all reports using slave seams to get stuck in time
Posted: Tue Nov 13, 2012 5:43 am
