ZM 1.28.107 problems after upgrade

Forum for questions and support relating to the 1.28.x releases only.
User avatar
pete_c
Posts: 88
Joined: Thu Jan 24, 2008 3:21 am
Location: USA

Re: ZM 1.28.107 problems after upgrade

Post by pete_c »

Thank you bbunge for what you are doing documenting this stuff.

I apologize for complaining as I understand you are doing this voluntarily.

I used to post my concerns on the Isaac's build pages and I understand that he is busy and he did refer me to here relating to posting my concerns.

The above noted I think I contributed to Isaac's efforts way a long time ago and will contribute again shortly.

Is there a means / way to contribute to your efforts here?
Zoneminder User

Box #1 and # 2 - Intel Ubuntu 14.04 64 bit server - Most current beta 1.28 - XX HD IP cams
Box #3 - AMD Ubuntu 14.04 64 bit server - Most current beta 1.28 - XX HD IP cams
Moved rest of analogue cams to Axis Servers and Grandstream cams.
littlej
Posts: 68
Joined: Sun Oct 18, 2009 11:46 am

Re: ZM 1.28.107 problems after upgrade

Post by littlej »

Hi, i upgraded to 1.28.107 and now my mysql is using 100% from one of my cpu :

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1029 mysql 20 0 2401336 180956 4180 S 99.9 4.5 16411:37 mysqld

now my load went from ~1.25 to ~3.50,

also i have some vivotek pz6122 wich worked well on previous version and now i get a blue screen and this :

11/03/15 09:48:37.250763 zmc_m13[14941].ERR-zm_remote_camera_http.cpp/1040 [Unable to read content]
11/03/15 09:48:37.250843 zmc_m13[14941].ERR-zm_remote_camera_http.cpp/1141 [Unable to get response, disconnecting]

any ideea what could have hapend? and how can i solve at least the mysql cpu usage?

i am on :
#lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 14.04.3 LTS
Release: 14.04
Codename: trusty

thanks
bbunge
Posts: 2923
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: ZM 1.28.107 problems after upgrade

Post by bbunge »

Known issue. Easy fix.

run as sql query

CREATE INDEX `EventId_idx` ON `Frames` (`EventId`)

There are other forum topics that cover this in detail
Locked