Падает Asterisk

[Yazov]

Здравствуйте, господа! В общем, рубанули мне питание на сервере (FreePBX 2.11), после этого начались странные проблемы - сервис астера падает и снова поднимается сам собой с различной периодичностью (от 10 минут до 2 часов). Покопался в логах и нашел ошибки мускуля, которых раньше, конечно же не было.

Код: Выделить всё

[2015-09-08 16:05:49] WARNING[29154] res_odbc.c: SQL Execute returned an error -1: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Duplicate entry '6692046' for key 'PRIMARY' (86)
[2015-09-08 16:05:49] WARNING[29154] res_odbc.c: SQL Execute error -1! Verifying connection to asteriskcdrdb [MySQL-asteriskcdrdb]...
[2015-09-08 16:05:49] WARNING[29154] res_odbc.c: Connection is down attempting to reconnect...
[2015-09-08 16:05:49] VERBOSE[439][C-0000004d] app_dial.c: -- Called SIP/Aloo_
[2015-09-08 16:05:49] NOTICE[29154] res_odbc.c: Connecting asteriskcdrdb
[2015-09-08 16:05:49] NOTICE[29154] res_odbc.c: res_odbc: Connected to asteriskcdrdb [MySQL-asteriskcdrdb]
[2015-09-08 16:05:49] WARNING[29154] res_odbc.c: SQL Execute returned an error -1: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Duplicate entry '6692046' for key 'PRIMARY' (86)
[2015-09-08 16:05:49] WARNING[29154] res_odbc.c: SQL Execute error -1! Verifying connection to asteriskcdrdb [MySQL-asteriskcdrdb]...
[2015-09-08 16:05:49] WARNING[29154] res_odbc.c: Connection is down attempting to reconnect...
[2015-09-08 16:05:49] NOTICE[29154] res_odbc.c: Connecting asteriskcdrdb
[2015-09-08 16:05:49] NOTICE[29154] res_odbc.c: res_odbc: Connected to asteriskcdrdb [MySQL-asteriskcdrdb]
[2015-09-08 16:05:49] WARNING[29154] cel_odbc.c: Insert failed on 'asteriskcdrdb:cel'. CEL failed: INSERT INTO cel (eventtype,eventtime,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,uniqueid,linkedid,peer,userdeftype,userfield) VALUES ('CHAN_START',{ts '2015-09-08 16:05:49'},'','','','','','s','from-trunk-sip-Aloo_Almaty','SIP/Aloo_Almaty-000000a7','','',3,'','1441706749.167','1441706749.166','','','')
[2015-09-08 16:05:50] VERBOSE[439][C-0000004d] app_dial.c: -- SIP/Aloo_Almaty-000000a7 is making progress passing it to SIP/207-000000a6
[2015-09-08 16:05:52] VERBOSE[433][C-0000004c] app_macro.c: == Spawn extension (macro-dialout-trunk, s, 22) exited non-zero on 'SIP/204-000000a4' in macro 'dialout-trunk'
[2015-09-08 16:05:52] VERBOSE[433][C-0000004c] pbx.c: == Spawn extension (from-internal, 87073791087, 6) exited non-zero on 'SIP/204-000000a4'
[2015-09-08 16:05:52] VERBOSE[433][C-0000004c] pbx.c: -- Executing [h@from-internal:1] Hangup("SIP/204-000000a4", "") in new stack
[2015-09-08 16:05:52] VERBOSE[433][C-0000004c] pbx.c: == Spawn extension (from-internal, h, 1) exited non-zero on 'SIP/204-000000a4'
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute returned an error -1: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Duplicate entry '6692046' for key 'PRIMARY' (86)
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute error -1! Verifying connection to asteriskcdrdb [MySQL-asteriskcdrdb]...
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: Connection is down attempting to reconnect...
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: Connecting asteriskcdrdb
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: res_odbc: Connected to asteriskcdrdb [MySQL-asteriskcdrdb]
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute returned an error -1: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Duplicate entry '6692046' for key 'PRIMARY' (86)
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute error -1! Verifying connection to asteriskcdrdb [MySQL-asteriskcdrdb]...
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: Connection is down attempting to reconnect...
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: Connecting asteriskcdrdb
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: res_odbc: Connected to asteriskcdrdb [MySQL-asteriskcdrdb]
[2015-09-08 16:05:52] WARNING[29154] cel_odbc.c: Insert failed on 'asteriskcdrdb:cel'. CEL failed: INSERT INTO cel (eventtype,eventtime,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,uniqueid,linkedid,peer,userdeftype,userfield) VALUES ('HANGUP',{ts '2015-09-08 16:05:52'},'CID:+77787460016','87073791087','','','','87073791087','from-trunk','SIP/Kcell2-000000a5','AppDial','(Outgoing Line)',3,'','1441706749.165','1441706749.164','','','')
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute returned an error -1: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Duplicate entry '6692046' for key 'PRIMARY' (86)
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute error -1! Verifying connection to asteriskcdrdb [MySQL-asteriskcdrdb]...
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: Connection is down attempting to reconnect...
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: Connecting asteriskcdrdb
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: res_odbc: Connected to asteriskcdrdb [MySQL-asteriskcdrdb]
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute returned an error -1: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Duplicate entry '6692046' for key 'PRIMARY' (86)
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute error -1! Verifying connection to asteriskcdrdb [MySQL-asteriskcdrdb]...
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: Connection is down attempting to reconnect...
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: Connecting asteriskcdrdb
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: res_odbc: Connected to asteriskcdrdb [MySQL-asteriskcdrdb]
[2015-09-08 16:05:52] WARNING[29154] cel_odbc.c: Insert failed on 'asteriskcdrdb:cel'. CEL failed: INSERT INTO cel (eventtype,eventtime,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,uniqueid,linkedid,peer,userdeftype,userfield) VALUES ('CHAN_END',{ts '2015-09-08 16:05:52'},'CID:+77787460016','87073791087','','','','87073791087','from-trunk','SIP/Kcell2-000000a5','AppDial','(Outgoing Line)',3,'','1441706749.165','1441706749.164','','','')
[2015-09-08 16:05:52] VERBOSE[436][C-0000004c] app_mixmonitor.c: == MixMonitor close filestream (mixed)
[2015-09-08 16:05:52] VERBOSE[436][C-0000004c] app_mixmonitor.c: == End MixMonitor Recording SIP/204-000000a4
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute returned an error -1: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Duplicate entry '6692046' for key 'PRIMARY' (86)
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute error -1! Verifying connection to asteriskcdrdb [MySQL-asteriskcdrdb]...
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: Connection is down attempting to reconnect...
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: Connecting asteriskcdrdb
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: res_odbc: Connected to asteriskcdrdb [MySQL-asteriskcdrdb]
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute returned an error -1: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Duplicate entry '6692046' for key 'PRIMARY' (86)
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute error -1! Verifying connection to asteriskcdrdb [MySQL-asteriskcdrdb]...
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: Connection is down attempting to reconnect...
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: Connecting asteriskcdrdb
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: res_odbc: Connected to asteriskcdrdb [MySQL-asteriskcdrdb]
[2015-09-08 16:05:52] WARNING[29154] cel_odbc.c: Insert failed on 'asteriskcdrdb:cel'. CEL failed: INSERT INTO cel (eventtype,eventtime,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,uniqueid,linkedid,peer,userdeftype,userfield) VALUES ('HANGUP',{ts '2015-09-08 16:05:52'},'','+77787460016','204','','87073791087','h','from-internal','SIP/204-000000a4','','',3,'','1441706749.164','1441706749.164','','','')
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute returned an error -1: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Duplicate entry '6692046' for key 'PRIMARY' (86)
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute error -1! Verifying connection to asteriskcdrdb [MySQL-asteriskcdrdb]...
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: Connection is down attempting to reconnect...
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: Connecting asteriskcdrdb
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: res_odbc: Connected to asteriskcdrdb [MySQL-asteriskcdrdb]
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute returned an error -1: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Duplicate entry '6692046' for key 'PRIMARY' (86)
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute error -1! Verifying connection to asteriskcdrdb [MySQL-asteriskcdrdb]...
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: Connection is down attempting to reconnect...
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: Connecting asteriskcdrdb
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: res_odbc: Connected to asteriskcdrdb [MySQL-asteriskcdrdb]
[2015-09-08 16:05:52] WARNING[29154] cel_odbc.c: Insert failed on 'asteriskcdrdb:cel'. CEL failed: INSERT INTO cel (eventtype,eventtime,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,uniqueid,linkedid,peer,userdeftype,userfield) VALUES ('CHAN_END',{ts '2015-09-08 16:05:52'},'','+77787460016','204','','87073791087','h','from-internal','SIP/204-000000a4','','',3,'','1441706749.164','1441706749.164','','','')
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute returned an error -1: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Duplicate entry '6692046' for key 'PRIMARY' (86)
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute error -1! Verifying connection to asteriskcdrdb [MySQL-asteriskcdrdb]...
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: Connection is down attempting to reconnect...
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: Connecting asteriskcdrdb
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: res_odbc: Connected to asteriskcdrdb [MySQL-asteriskcdrdb]
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute returned an error -1: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Duplicate entry '6692046' for key 'PRIMARY' (86)
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: SQL Execute error -1! Verifying connection to asteriskcdrdb [MySQL-asteriskcdrdb]...
[2015-09-08 16:05:52] WARNING[29154] res_odbc.c: Connection is down attempting to reconnect...
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: Connecting asteriskcdrdb
[2015-09-08 16:05:52] NOTICE[29154] res_odbc.c: res_odbc: Connected to asteriskcdrdb [MySQL-asteriskcdrdb]
[2015-09-08 16:05:52] WARNING[29154] cel_odbc.c: Insert failed on 'asteriskcdrdb:cel'. CEL failed: INSERT INTO cel (eventtype,eventtime,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,uniqueid,linkedid,peer,userdeftype,userfield) VALUES ('LINKEDID_END',{ts '2015-09-08 16:05:52'},'','+77787460016','204','','87073791087','h','from-internal','SIP/204-000000a4','','',3,'','1441706749.164','1441706749.164','','','')
[2015-09-08 16:05:57] VERBOSE[29174][C-0000004e] netsock2.c: == Using SIP RTP TOS bits 184
[2015-09-08 16:05:57] VERBOSE[29174][C-0000004e] netsock2.c: == Using SIP RTP CoS mark 5
[2015-09-08 16:05:57] WARNING[29154] res_odbc.c: SQL Execute returned an error -1: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Duplicate entry '6692046' for key 'PRIMARY' (86)
[2015-09-08 16:05:57] WARNING[29154] res_odbc.c: SQL Execute error -1! Verifying connection to asteriskcdrdb [MySQL-asteriskcdrdb]...
[2015-09-08 16:05:57] WARNING[29154] res_odbc.c: Connection is down attempting to reconnect...
[2015-09-08 16:05:57] NOTICE[29154] res_odbc.c: Connecting asteriskcdrdb

У меня есть бекапы всех баз пятидневной давности, но Я пока не решился базы восстанавливать.
К тому же не уверен, возможно ли будет просмотреть звонки за вчера, например.
Подскажите пожалуйста, куда копать?

[TVMaker]

Сначала мускул починить надо, не?

[Pechen]

CEL пишете? если нет то отрубите его

[Yazov]

Сначала мускул починить надо, не?

Починил все базы. Копаю мускуль.
CEL пишу конечно. Он мне нужен.

[Yazov]

Проблему решил. Восстановил битые таблицы из бэкапов и все заработало.