Avatar of amigan_99
amigan_99
Flag 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.
* MariaDB* CentOSMySQL ServerLinux Distributions

Avatar of undefined
Last Comment
amigan_99

8/22/2022 - Mon
David Favor

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
David Favor

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
amigan_99

ASKER
Thank you again David.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes