Page 1 of 1

Multi server setup. Power cut one server dead

Posted: Mon Jan 17, 2022 5:14 pm
by bovnet
Hi,
Power cut on a multiserver setup. 1of 3 zoneminder servers RIP. database and file-server ok.

I am getting the following :-
Jan 17 16:45:20 zmbase zmdc[62034]: ERR ['zmc -m 11' exited abnormally, exit status 255]
Jan 17 16:45:20 zmbase zmc_m9[63728]: ERR [zmc_m9] [Can't run query: Unknown column 'JanusEnabled' in 'field list']
Jan 17 16:45:20 zmbase zmc_m9[63728]: ERR [zmc_m9] [Can't use query result: Unknown column 'JanusEnabled' in 'field list']
Jan 17 16:45:20 zmbase zmc_m9[63728]: ERR [zmc_m9] [No monitors found]
Jan 17 16:45:20 zmbase zmdc[62034]: ERR ['zmc -m 8' exited abnormally, exit status 255]
Jan 17 16:45:20 zmbase zmdc[62034]: ERR ['zmc -m 9' exited abnormally, exit status 255]
Jan 17 16:45:20 zmbase zmc_m13[63730]: ERR [zmc_m13] [Can't run query: Unknown column 'JanusEnabled' in 'field list']
Jan 17 16:45:20 zmbase zmc_m13[63730]: ERR [zmc_m13] [Can't use query result: Unknown column 'JanusEnabled' in 'field list']
Jan 17 16:45:20 zmbase zmc_m13[63730]: ERR [zmc_m13] [No monitors found]
Jan 17 16:45:20 zmbase zmdc[62034]: ERR ['zmc -m 13' exited abnormally, exit status 255]

All config is visible and looks normal in webgui. I am unable to move a camera off the dead server. No cameras are working.

Any ideas ?

Re: Multi server setup. Power cut one server dead

Posted: Mon Jan 17, 2022 7:07 pm
by iconnor
Your db structure is not up to date.

sudo zmupdate.pl

or

mysql -u zmuser -p zm < /usr/share/zoneminder/db/zm_update-1.37.8.sql

Re: Multi server setup. Power cut one server dead

Posted: Mon Jan 17, 2022 7:20 pm
by bovnet
zmupdate.pl

states

Database already at version 1.37.7, update skipped.


however your 2nd suggestion has fixed. Now i just need a new psu! Thanks for fix and thanks for your service developing zm