Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5.8
-
None
-
None
-
Linux
Description
We see in the MariaDB Error Log from time to time the message:
2021-02-14 19:21:43 53526568 [ERROR] Got error 128 when reading table './enswitch/active'
No other message before or after for a while. Mostly it does not harm. But sometimes the system piles up until max connection is reached and then we have to failover to the slave.
The system configuration is not optimal. We still have to tune it.
RAM: 512G, InnoDB Buffer Pool: 320G (50% pages free!) other variables are some sub-optimal.
Connection causing this should be running the following queries:
select count(*) as existing from active where server='?' and callid='?' limit 1 |
select recording from active where server='?' and uniqueid='?' limit 1 |
select uniqueid from active where ( stype='?' and snumber='?' and stransferred=? and processing=? and park='?' ) or ( dtype='?' and dnumber='?' and dtransferred=? and processing=? and park='?' ) for update |
insert ignore into active ( server, uniqueid, callid, sip_callid, start, answered, scustomer, stype, snumber, spresent, stransferred, ctype, cnumber, dcustomer, dtype, dnumber, callerid_internal, callerid_external, callername, ingroup, outgroup, peer, channel, recording, queue, queue_status, card, overmax, note ) values ( '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?') |
select server, delivery_server, dtype, dnumber from active where ( ( stype='?' and snumber='?' and stransferred=? ) or ( dtype='?' and dnumber='?' and dtransferred=? ) ) and ( server!='?' or uniqueid!='?' ) and processing=? order by start desc limit 1 |
When we have some more information I will update the ticket.