Yeah, the problem will have been temporarily "fixed" by wiping the table.

You indeed need to increase the MySQL heap size.

adam.

On 19/02/2016 14:36:33, Eduardo Schoedler <listas@esds.com.br> wrote:

Hi,

The 'ports_cbqos' is a memory table.

From Mysql manual:
"The maximum size of MEMORY tables is limited by the
max_heap_table_size system variable, which has a default value of
16MB."
http://dev.mysql.com/doc/refman/5.6/en/memory-storage-engine.html

You have to raise your 'max_heap_table_size' parameter.

Regards,


2016-02-19 11:20 GMT-02:00 Fältman, Mikael :
> Hi again.
>
> Increased innodb_buffer_pool_size and restarted mysqld – solved the problem.
>
> Buffer_pool_size has probably nothing to do with this issue but I was also
> getting warnings about
>
> buffer pool is occupied by InnoDB: lock heaps or the adaptive hash index.
>
>
>
> It is a good thing to sometimes keep a peek into /var/log/mysqld.log file
> (or where ever it is stored).
>
>
>
> BR
>
> Mikael
>
>
>
>
>
>
>
> From: observium [mailto:observium-bounces@observium.org] On Behalf Of
> Fältman, Mikael
> Sent: den 18 februari 2016 10:27
> To: Observium Network Observation System
> Subject: [Observium] mysqld: The table 'ports_cbqos' is full
>
>
>
> Hello.
>
>
>
> Running: Observium CE 0.16.1.7533 on RedHat 6.4
>
>
>
> Keep getting this error msg in /var/log/mysqld.log
>
> 160218 10:21:28 [ERROR] /usr/libexec/mysqld: The table 'ports_cbqos' is full
>
>
>
> What can I do to fix it ?
>
> Disk space is available.
>
>
>
>
>
> BR
>
> Mikael
>
>
>
>
> _______________________________________________
> observium mailing list
> observium@observium.org
> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
>



--
Eduardo Schoedler
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium