zabbix with active agents and mysql partitioning

[cm2k]

Hi,
I'm using mysql partitioning and recently I moved agent to active mode and then I got the issue when zabbix cannot insert bulk insert in database.

query failed: [1526] Table has no partition for value 1407152213 [insert into history (itemid,clock,ns,value) values ...

Clock value in this example in the future for a week relatively local zabbix server time.

I suspect what zabbix use timestamp coming from agent.


Does anybody has the same issue? How to tell zabbix ignore the timestamp coming from agents if timestamp far in future or forced use local zabbix timestamp.

[tqtran]

I have the same problem... Can anyone please help?

[tqtran]

Of course, I finally realized that I forgot to create new partitions for the database... Duh!!! Problem is now taken care of.

[zabbixactive]

Hi,
I'm using mysql partitioning and recently I moved agent to active mode and then I got the issue when zabbix cannot insert bulk insert in database.

query failed: [1526] Table has no partition for value 1407152213 [insert into history (itemid,clock,ns,value) values ...

Clock value in this example in the future for a week relatively local zabbix server time.

I suspect what zabbix use timestamp coming from agent.


Does anybody has the same issue? How to tell zabbix ignore the timestamp coming from agents if timestamp far in future or forced use local zabbix timestamp.

hi, can you paste yours config with active agent? Whitch version is on agent and server? i have problem to connect on active mode :/