Link to home
Start Free TrialLog in
Avatar of amigan_99
amigan_99Flag for United States of America

asked on

Maria DB high volume of insert errors

When application observium is trying to write to mariadb there is a recurring error:

[2019/01/25 13:24:19 -0800] poller.php(142737): Failed dbQuery (#1114 - The table 'ports_cbqos' is full),
Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`,`PrePolicyPkt`,
`PrePolicyByte`,`PostPolicyByte`,`DropPkt`,`DropByte`,`NoBufDropPkt`)  
VALUES ('132','11977','301990276','301990277','output','0','0','0','0','0','')

This adds up to some 10GB of logging per day. This is running on centos. Any thoughts on how I could
fix this error? There appears to be plenty of disk space.
Avatar of David Favor
David Favor
Flag of United States of America image

The message The table 'ports_cbqos' is full suggests a disk is full or disk quota for user or database subsystem has been hit.

Take a look at /var/lib/mysql + look at ports_cbqos related file sizes, if that's the only table throwing the error.
ASKER CERTIFIED SOLUTION
Avatar of David Favor
David Favor
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of amigan_99

ASKER

Thank you again David.