› VitalPBX Community Support › Reporting an Issue › mysql replication stops every time we reboot server in Vital 3.0.6-2
Last_SQL_Error: Error ‘Duplicate entry ‘115846’ for key
‘PRIMARY” on query. Default database: ‘asterisk’. Query: ‘INSERT INTO …, …’
In order to better help you, we need the following information:
1.- In what environment is it replicated, if it is local or two separate data centers.
2.- What method did you use for the replication?
We recommend the following link:
MySQL last_sql_errno: 1062 —- classic error, primary key conflict
Before we put them in production, it didn’t happen as far as we have records. But after we migrated the live traffic, it happen every time we rebooted them.
The replication method was followed as per the VitalPBX 3.0 HA Script.
Tagged: mysql replication, vital 3.0