Доброго всем времени суток! случилась такая проблема, вырубили электричество по жести, сервер рухнул......полетели таблицы, вылечили но теперь через каждые 15 минут работы сервера вылетает такая ошибка и всё биллинг не работает вовсе.
подскажите у кого какие мысли и как это побороть
заранее благодарю, хотя бы то что сюда заглянули
?Debug : Jul 18 22:42:28 DBCtx: <146612296> MySQL query failed:<Duplicate entry '146178339' for key 'PRIMARY'> Trying to reconnect: 0
?Debug : Jul 18 22:42:30 DBCtx: <146612296> MySQL query failed:<Duplicate entry '146178339' for key 'PRIMARY'> Trying to reconnect: 1
?Debug : Jul 18 22:42:32 DBCtx: <146612296> MySQL query failed:<Duplicate entry '146178339' for key 'PRIMARY'> Trying to reconnect: 2
Ошибка мускула и UTM5
за ссылку большое спасибо....но чуточку не то
?Debug : Jul 19 18:56:42 BusLogic: BLM(37) pushed (comment: ruh block)
?Debug : Jul 19 18:56:42 DBCtx: <149530376> SQL query: INSERT INTO discount_transactions_iptraffic_all(id,account_id,discount,discount_with_tax,service_id,slink_id,discount_date,discount_date_hour,discount_date_day,discount_date_month,t_class,base_cost,ipid,bytes,discount_period_id) VALUES('146180986','3997','0','0','690','18081','1342709802','1342706400','1342641600','1341086400','10','0','1590155531','6511109','19242')
?Debug : Jul 19 18:56:42 DBCtx: <149530376> MySQL query failed:<Duplicate entry '146180986' for key 'PRIMARY'> Trying to reconnect: 0
?Debug : Jul 19 18:56:44 DBCtx: <149530376> MySQL query failed:<Duplicate entry '146180986' for key 'PRIMARY'> Trying to reconnect: 1
?Debug : Jul 19 18:56:45 FW@192.168.200.10: ping reply received
?Debug : Jul 19 18:56:46 DBCtx: <149530376> MySQL query failed:<Duplicate entry '146180986' for key 'PRIMARY'> Trying to reconnect: 2
может поможет
?Debug : Jul 19 18:56:42 BusLogic: BLM(37) pushed (comment: ruh block)
?Debug : Jul 19 18:56:42 DBCtx: <149530376> SQL query: INSERT INTO discount_transactions_iptraffic_all(id,account_id,discount,discount_with_tax,service_id,slink_id,discount_date,discount_date_hour,discount_date_day,discount_date_month,t_class,base_cost,ipid,bytes,discount_period_id) VALUES('146180986','3997','0','0','690','18081','1342709802','1342706400','1342641600','1341086400','10','0','1590155531','6511109','19242')
?Debug : Jul 19 18:56:42 DBCtx: <149530376> MySQL query failed:<Duplicate entry '146180986' for key 'PRIMARY'> Trying to reconnect: 0
?Debug : Jul 19 18:56:44 DBCtx: <149530376> MySQL query failed:<Duplicate entry '146180986' for key 'PRIMARY'> Trying to reconnect: 1
?Debug : Jul 19 18:56:45 FW@192.168.200.10: ping reply received
?Debug : Jul 19 18:56:46 DBCtx: <149530376> MySQL query failed:<Duplicate entry '146180986' for key 'PRIMARY'> Trying to reconnect: 2
может поможет
Прочитайте тред по ссылке внимательнее и скажите, почему "не то".basta писал(а):за ссылку большое спасибо....но чуточку не то
?Debug : Jul 19 18:56:42 BusLogic: BLM(37) pushed (comment: ruh block)
?Debug : Jul 19 18:56:42 DBCtx: <149530376> SQL query: INSERT INTO discount_transactions_iptraffic_all(id,account_id,discount,discount_with_tax,service_id,slink_id,discount_date,discount_date_hour,discount_date_day,discount_date_month,t_class,base_cost,ipid,bytes,discount_period_id) VALUES('146180986','3997','0','0','690','18081','1342709802','1342706400','1342641600','1341086400','10','0','1590155531','6511109','19242')
?Debug : Jul 19 18:56:42 DBCtx: <149530376> MySQL query failed:<Duplicate entry '146180986' for key 'PRIMARY'> Trying to reconnect: 0
?Debug : Jul 19 18:56:44 DBCtx: <149530376> MySQL query failed:<Duplicate entry '146180986' for key 'PRIMARY'> Trying to reconnect: 1
?Debug : Jul 19 18:56:45 FW@192.168.200.10: ping reply received
?Debug : Jul 19 18:56:46 DBCtx: <149530376> MySQL query failed:<Duplicate entry '146180986' for key 'PRIMARY'> Trying to reconnect: 2
может поможет