full tables

[davidtaragonha]

I have a problem with other tables and I not can add items and triggers.
The message is:

[COLOR=Blue]SQL error: The table 'items' is full

Query: insert into items (description,key_,hostid,delay,history,nextcheck,status,type,snmp_community,snmp_oid,value_type,trapper_hosts,snmp_port,units,multiplier,delta,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,formula,trends,logtimefmt,valuemapid,templateid) 

values ('Servicio Legato (backup p2)','net.tcp.port[,7937]',10016,30,90,0, 0,0,'public','interfaces.ifTable.ifEntry.ifInOctets.1',0,'',161,'',0,0,'',0,'','','1',365,'',0,20194)[/COLOR]

solution?????

[erisan500]

SQL error: The table 'items' is full

You have a mySQL problem. Check if you table isn't space limited.
EriSan

[mwdiers]

The problem here is almost certainly caused by the default MySQL configuration for innodb.

Zabbix generates a lot of data, so the innodb defaults are inappropriate.

Open up your /etc/mysql/my.cnf file, and look for a line that looks like this:

innodb_data_file_path = ibdata1:10M:autoextend:max:128M

and change it to this:

innodb_data_file_path = ibdata1:10M:autoextend:max:1024M

Then restart your mysql server. That should solve your problem. Depending upon the amount of data you are generating, you may wish to increase this even more, but YMMV.