Mysql error after power outage

benphone · August 28, 2019, 10:24am

getting this error
anyone has an idea of which table is this or where to check

Blockquote WARNING[41482][C-00027303]: res_config_mysql.c:861 store_mysql: MySQL RealTime: Failed to insert into database: Duplicate entry ‘72797072’ for key 'PRIMARY

bellow is console output

BlockquoteLine 136: [2019-08-28 14:56:04] VERBOSE[108142][C-0002789a] app_queue.c: Line 137: [2019-08-28 14:56:04] VERBOSE[108142][C-0002789a] app_queue.c: Line 372: [2019-08-28 14:56:04] VERBOSE[108142][C-0002789a] app_queue.c: Line 374: [2019-08-28 14:56:04] VERBOSE[108142][C-0002789a] app_queue.c: Line 378: [2019-08-28 14:56:04] WARNING[108142][C-0002789a] res_config_mysql.c: Line 385: [2019-08-28 14:56:04] VERBOSE[108142][C-0002789a] app_queue.c: Line 607: [2019-08-28 14:56:04] VERBOSE[108142][C-0002789a] app_queue.c: Line 609: [2019-08-28 14:56:04] VERBOSE[108142][C-0002789a] app_queue.c: Line 611: [2019-08-28 14:56:04] WARNING[108142][C-0002789a] res_config_mysql.c: Line 612: [2019-08-28 14:56:04] VERBOSE[108142][C-0002789a] app_queue.c: Line 1093: [2019-08-28 14:56:09] VERBOSE[108142][C-0002789a] app_queue.c: Line 1094: [2019-08-28 14:56:09] VERBOSE[108142][C-0002789a] app_queue.c: Line 1213: [2019-08-28 14:56:09] VERBOSE[108142][C-0002789a] app_queue.c: Line 1215: [2019-08-28 14:56:09] VERBOSE[108142][C-0002789a] app_queue.c: Line 1218: [2019-08-28 14:56:09] WARNING[108142][C-0002789a] res_config_mysql.c: Line 1225: [2019-08-28 14:56:09] VERBOSE[108142][C-0002789a] app_queue.c: Line 1451: [2019-08-28 14:56:09] VERBOSE[108142][C-0002789a] app_queue.c: Line 1453: [2019-08-28 14:56:09] VERBOSE[108142][C-0002789a] app_queue.c: Line 1456: [2019-08-28 14:56:09] WARNING[108142][C-0002789a] res_config_mysql.c: Line 1457: [2019-08-28 14:56:09] VERBOSE[108142][C-0002789a] app_queue.c: Line 2026: [2019-08-28 14:56:14] VERBOSE[108142][C-0002789a] app_queue.c: Line 2027: [2019-08-28 14:56:14] VERBOSE[108142][C-0002789a] app_queue.c: Line 2142: [2019-08-28 14:56:14] VERBOSE[108142][C-0002789a] app_queue.c: Line 2144: [2019-08-28 14:56:14] VERBOSE[108142][C-0002789a] app_queue.c: Line 2147: [2019-08-28 14:56:14] WARNING[108142][C-0002789a] res_config_mysql.c: Line 2152: [2019-08-28 14:56:14] VERBOSE[108142][C-0002789a] app_queue.c: Line 2380: [2019-08-28 14:56:14] VERBOSE[108142][C-0002789a] app_queue.c: Line 2383: [2019-08-28 14:56:14] VERBOSE[108142][C-0002789a] app_queue.c: Line 2385: [2019-08-28 14:56:14] WARNING[108142][C-0002789a] res_config_mysql.c: Line 2387: [2019-08-28 14:56:14] VERBOSE[108142][C-0002789a] app_queue.c: Line 3059: [2019-08-28 14:56:19] VERBOSE[108142][C-0002789a] app_queue.c: Line 3060: [2019-08-28 14:56:19] VERBOSE[108142][C-0002789a] app_queue.c: Line 3174: [2019-08-28 14:56:19] VERBOSE[108142][C-0002789a] app_queue.c: Line 3176: [2019-08-28 14:56:19] VERBOSE[108142][C-0002789a] app_queue.c: Line 3179: [2019-08-28 14:56:19] WARNING[108142][C-0002789a] res_config_mysql.c: Line 3184: [2019-08-28 14:56:19] VERBOSE[108142][C-0002789a] app_queue.c: Line 3407: [2019-08-28 14:56:19] VERBOSE[108142][C-0002789a] app_queue.c: Line 3412: [2019-08-28 14:56:19] VERBOSE[108142][C-0002789a] app_queue.c: Line 3413: [2019-08-28 14:56:19] WARNING[108142][C-0002789a] res_config_mysql.c: Line 3414: [2019-08-28 14:56:19] VERBOSE[108142][C-0002789a] app_queue.c: Line 3974: [2019-08-28 14:56:24] VERBOSE[108142][C-0002789a] res_musiconhold.c: Line 3975: [2019-08-28 14:56:24] WARNING[108142][C-0002789a] res_config_mysql.c: Line 3976: [2019-08-28 14:56:24] VERBOSE[108142][C-0002789a] pbx.c: Line 3977: [2019-08-28 14:56:24] VERBOSE[108142][C-0002789a] pbx.c: Line 3978: [2019-08-28 14:56:24] VERBOSE[108142][C-0002789a] pbx.c: Line 3979: [2019-08-28 14:56:24] VERBOSE[108142][C-0002789a] pbx.c: Line 3980: [2019-08-28 14:56:24] VERBOSE[108142][C-0002789a] pbx.c: Line 3981: [2019-08-28 14:56:24] VERBOSE[108142][C-0002789a] pbx.c: Line 3982: [2019-08-28 14:56:24] VERBOSE[108142][C-0002789a] app_macro.c: Line 3983: [2019-08-28 14:56:24] VERBOSE[108142][C-0002789a] pbx.c: – Called Local/380@from-internal/n
– LazyMembers debugging - Numbusies: 0, Nummems: 0
– Local/380@from-internal-00219530;1 is busy
– Nobody picked up in 0 ms
MySQL RealTime: Failed to insert into database: Duplicate entry ‘72797072’ for key ‘PRIMARY’
– Called Local/311@from-internal/n
– Local/311@from-internal-00219532;1 is busy
– Nobody picked up in 0 ms
MySQL RealTime: Failed to insert into database: Duplicate entry ‘72797072’ for key ‘PRIMARY’
– LazyMembers debugging - Numbusies: 0, Nummems: 0
– Called Local/380@from-internal/n
– LazyMembers debugging - Numbusies: 0, Nummems: 0
– Local/380@from-internal-00219537;1 is busy
– Nobody picked up in 0 ms
MySQL RealTime: Failed to insert into database: Duplicate entry ‘72797072’ for key ‘PRIMARY’
– Called Local/311@from-internal/n
– Local/311@from-internal-00219539;1 is busy
– Nobody picked up in 0 ms
MySQL RealTime: Failed to insert into database: Duplicate entry ‘72797072’ for key ‘PRIMARY’
– LazyMembers debugging - Numbusies: 0, Nummems: 0
– Called Local/380@from-internal/n
– LazyMembers debugging - Numbusies: 0, Nummems: 0
– Local/380@from-internal-0021953e;1 is busy
– Nobody picked up in 0 ms
MySQL RealTime: Failed to insert into database: Duplicate entry ‘72797072’ for key ‘PRIMARY’
– Called Local/311@from-internal/n
– Local/311@from-internal-00219540;1 is busy
– Nobody picked up in 0 ms
MySQL RealTime: Failed to insert into database: Duplicate entry ‘72797072’ for key ‘PRIMARY’
– LazyMembers debugging - Numbusies: 0, Nummems: 0
– Called Local/380@from-internal/n
– LazyMembers debugging - Numbusies: 0, Nummems: 0
– Local/380@from-internal-00219545;1 is busy
– Nobody picked up in 0 ms
MySQL RealTime: Failed to insert into database: Duplicate entry ‘72797072’ for key ‘PRIMARY’
– Called Local/311@from-internal/n
– Local/311@from-internal-00219547;1 is busy
– Nobody picked up in 0 ms
MySQL RealTime: Failed to insert into database: Duplicate entry ‘72797072’ for key ‘PRIMARY’
– LazyMembers debugging - Numbusies: 0, Nummems: 0
– Stopped music on hold on SIP/0003e62b
MySQL RealTime: Failed to insert into database: Duplicate entry ‘72797072’ for key ‘PRIMARY’
== Spawn extension (ext-queues, 8502, 40) exited non-zero on ‘SIP/-0003e62b’
– Executing [h@ext-queues:1] Macro(“SIP/-0003e62b”, “hangupcall,”) in new stack
– Executing [s@macro-hangupcall:1] ExecIf(“SIP/-0003e62b”, “0?Set(CDR(recordingfile)=in-778996325-0504153338-20190828-145429-1566993269.4657063.wav)”) in new stack
– Executing [s@macro-hangupcall:2] GotoIf(“SIP/-0003e62b”, “1?theend”) in new stack
– Goto (macro-hangupcall,s,4)
– Executing [s@macro-hangupcall:4] Hangup(“SIP/-0003e62b”, “”) in new stack
== Spawn extension (macro-hangupcall, s, 4) exited non-zero on ‘SIP/-0003e62b’ in macro ‘hangupcall’
== Spawn extension (ext-queues, h, 1) exited non-zero on ‘SIP/-0003e62b’

’

penguinpbx · August 28, 2019, 10:36pm

Is 72797072 the extension number ? Can you post filtered contents of /etc/asterisk/extconfig.conf ?

benphone · August 29, 2019, 9:03pm

doesnt have any ext
using freepbx

checked for extentions or did or anything else but could not find with this number

ambiorixg12 · August 30, 2019, 3:54am

That module it is deprecated, you should be using ODBC but it is something you cant change your self as you re using FreePBX, and that kind of change will breake your system, search on the DB tables for this key ‘7279707 and remove it also run a MYSQL check from the Linux command line

mysqlcheck -u root -p --auto-repair --all-databases

benphone · August 30, 2019, 8:24am

it is not an asterisk issue

iam useing asternic for queues in realtime sql ther is no key i will ask asternic if could truncate table

thanks for your help as it made me look again and found that it only after writing to queue log did i get the error

which hase a table

system · September 29, 2019, 8:32am

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.