Mysql error after power outage

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

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

doesnt have any ext
using freepbx

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

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

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

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