Zabbix DM configuration process failed

[davidisko]

Hi guys,
i have trouble to set up DM.
I had used zabbix server on my node 1 for a while.
Then i decided to set it up with other node to DM.

So i invoked conversion with
zabbix_server -n 1 -c /etc/zabbix/zabbix_server.conf

It died after while because of no free disk space.
My DB has 50GB.

I extended the filesystem and tried to continue with conversion but now i get
zabbix_server -n 1 -c /etc/zabbix/zabbix_server.conf
Unable to convert. Some of object IDs are out of range in table "events" ("eventid" = 100000000000001)

Can anyone help me?

Debian 7.4
Zabbix 2.2.2
PostgreSQL 9.1.12

[pc99096]

drop db, create db again?

[aib]

....restore previous version DB from backup and convert it again?

[davidisko]

ouch,
i'm backing up everything except the pg db... LOL... my bad...
therefore recovering from backup is not possible.

drop and create is not good idea...
that way i'll lost data and configuration...

isn't there any way how to continue converting process?

[vesal]

ouch,
i'm backing up everything except the pg db... LOL... my bad...
therefore recovering from backup is not possible.

drop and create is not good idea...
that way i'll lost data and configuration...

isn't there any way how to continue converting process?

Documentation says https://www.zabbix.com/documentation...nitoring/nodes

Run this command only once. Running it twice will corrupt the database, so make sure that you run it with the correct node id.

[davidisko]

Documentation says https://www.zabbix.com/documentation...nitoring/nodes

That's little bit half-baked...
What if conversion process fail for any reason?
Electricity, kernel crash, database crash, connection problem server-client while not running in screen, lack of free space whatever...
Then you have no way how to finish the process and have to drop all data???
Sorry but that's not half-baked.. That's stupid.

[vesal]

That's little bit half-baked...
What if conversion process fail for any reason?
Electricity, kernel crash, database crash, connection problem server-client while not running in screen, lack of free space whatever...
Then you have no way how to finish the process and have to drop all data???
Sorry but that's not half-baked.. That's stupid.

Because of those reasons you'd take full database backup before executing the command.

[davidisko]

I agree not to take backup of db it's stupid too.
I was sure that it's backing up everyday by rsnapshot but it failed somehow.
What exactly the command do?