Ad Widget

Collapse

Table item full

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • opierre
    Junior Member
    • Oct 2005
    • 10

    #1

    Table item full

    Here is the result of adding an item in the database:

    SQL error: The table 'items' is full
    Query: insert into items (description,key_,hostid,delay,history,nextcheck,s tatus,type,snmp_community,snmp_oid,value_type,trap per_hosts,snmp_port,units,multiplier,delta,snmpv3_ securityname,snmpv3_securitylevel,snmpv3_authpassp hrase,snmpv3_privpassphrase,formula,trends,logtime fmt,valuemapid,templateid) values ('Percent space left on $1','vfs.fs.size[/home,pfree]',10008,3600,7,0, 0,0,'public','interfaces.ifTable.ifEntry.ifInOctet s.1',0,'',161,'vfs.fs.size[/home,pfree]',0,0,'',0,'','','1',365,'',0,17322)
    Maybe the key int(4) is too small ?
  • James Wells
    Senior Member
    • Jun 2005
    • 664

    #2
    Greetings,

    How many items do you currently have? I suspect the issue is not the number of items, but the DB size limits.
    Unofficial Zabbix Developer

    Comment

    • DiedX
      Senior Member
      • Oct 2004
      • 106

      #3
      This has to do with the size of MySQL. 4 does not support more then 4 GB of data.

      But how did YOU fix this?
      https://www.diederik.nl

      Comment

      Working...