getting error in Observium db.log, filling disk on observium server
Receiving this error in the Observium db.log, filling disk on observium server. How may I resolve it to be able to get the cbqos graphs for all devices capable.
poller.php(9989): Failed dbQuery (#1114 - The table 'ports_cbqos' is full), Query: INSERT INTO `ports_cbqos` (......
Observium version: 18.3.9073 (stable)
*Sam Jones*
Idaho State University
I don't think ports_cbqos is a memory based table, so I'm wildly guessing the disk/partition your mysql database is on is full...?
Or maybe it is a memory table after all... increasing max_heap_table_size in your mysql server may help then.
Tom
On 4/10/2018 8:04 PM, Sam Jones wrote:
Receiving this error in the Observium db.log, filling disk on observium server. How may I resolve it to be able to get the cbqos graphs for all devices capable.
poller.php(9989): Failed dbQuery (#1114 - The table 'ports_cbqos' is full), Query: INSERT INTO `ports_cbqos` (......
Observium version: 18.3.9073 (stable)
*Sam Jones**
Idaho State University
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
If it's bizarrely a memory table, it's explain why random people report this but I've never seen it myself.
Let me work out how to check dB schema from my phone...
Adam.
Sent from BlueMail
On 10 Apr 2018, 21:05, at 21:05, Tom Laermans tom.laermans@powersource.cx wrote:
I don't think ports_cbqos is a memory based table, so I'm wildly guessing the disk/partition your mysql database is on is full...?
Or maybe it is a memory table after all... increasing max_heap_table_size in your mysql server may help then.
Tom
On 4/10/2018 8:04 PM, Sam Jones wrote:
Receiving this error in the Observium db.log, filling disk on observium server. How may I resolve it to be able to get the cbqos graphs for all devices capable.
poller.php(9989): Failed dbQuery (#1114 - The table 'ports_cbqos' is full), Query: INSERT INTO `ports_cbqos` (......
Observium version: 18.3.9073 (stable)
*Sam Jones**
Idaho State University
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
So it is...
Will fix :D
Adam.
Sent from BlueMail
On 10 Apr 2018, 21:08, at 21:08, Adam Armstrong adama@memetic.org wrote:
If it's bizarrely a memory table, it's explain why random people report this but I've never seen it myself.
Let me work out how to check dB schema from my phone...
Adam.
Sent from BlueMail
On 10 Apr 2018, 21:05, at 21:05, Tom Laermans tom.laermans@powersource.cx wrote:
I don't think ports_cbqos is a memory based table, so I'm wildly guessing the disk/partition your mysql database is on is full...?
Or maybe it is a memory table after all... increasing max_heap_table_size in your mysql server may help then.
Tom
On 4/10/2018 8:04 PM, Sam Jones wrote:
Receiving this error in the Observium db.log, filling disk on observium server. How may I resolve it to be able to get the cbqos graphs for all devices capable.
poller.php(9989): Failed dbQuery (#1114 - The table 'ports_cbqos' is full), Query: INSERT INTO `ports_cbqos` (......
Observium version: 18.3.9073 (stable)
*Sam Jones**
Idaho State University
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Yeah, google brought it up for me that others have had this issue with this table as well, and upping that setting fixed it.
No idea why it'd be a memory table though :D
On 4/10/2018 10:10 PM, Adam Armstrong wrote:
So it is...
Will fix :D
Adam.
Sent from BlueMail http://www.bluemail.me/r?b=12687 On 10 Apr 2018, at 21:08, Adam Armstrong <adama@memetic.org mailto:adama@memetic.org> wrote:
If it's bizarrely a memory table, it's explain why random people report this but I've never seen it myself. Let me work out how to check dB schema from my phone... Adam. Sent from BlueMail <http://www.bluemail.me/r?b=12687> On 10 Apr 2018, at 21:05, Tom Laermans < tom.laermans@powersource.cx <mailto:tom.laermans@powersource.cx>> wrote: I don't think ports_cbqos is a memory based table, so I'm wildly guessing the disk/partition your mysql database is on is full...? Or maybe it is a memory table after all... increasing max_heap_table_size in your mysql server may help then. Tom On 4/10/2018 8:04 PM, Sam Jones wrote:Receiving this error in the Observium db.log, filling disk on observium server. How may I resolve it to be able to get the cbqos graphs for all devices capable. poller.php(9989): Failed dbQuery (#1114 - The table 'ports_cbqos' is full), Query: INSERT INTO `ports_cbqos` (...... Observium version: 18.3.9073 (stable) *Sam Jones** * Idaho State University _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium------------------------------------------------------------------------ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium ------------------------------------------------------------------------ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (3)
-
Adam Armstrong -
Sam Jones -
Tom Laermans