Page 1 of 1

Zone Minder´s query crash mysql (v1.17)

Posted: Wed Jan 21, 2004 7:50 pm
by victor_diago
the log files say OUTOF MEMORY killed mysqld. im using 16 cameras at 1fps, 20 in buffer size.

"it says also - Cant call method "prepare cached" on an undefined value at /usr/local/bin/zmfilter.pl line 51"

BEGIN failed--compilation aborted at /usr/local/bin/zmfilter.pl line 59


i really think that is something very wrong, but what ?

also, the still watch mode doesnt work and i´ve checked the permissions thats ok.

Re: Zone Minder´s query crash mysql (v1.17)

Posted: Wed Jan 21, 2004 7:57 pm
by zoneminder
Hmm, that's a bit odd as the statement that the line 51 error is referring to is just 'select * from Config' and is pretty simple. I suspect there is a prior cause.

Can you post the full log entry that referred to out of memory?

Also if you use 'top' does it show mysqld processes growing?

Finally, are you using RH9 and using streamed views without a patched apache?

Cheers,

Phil,

Re: Zone Minder´s query crash mysql (v1.17)

Posted: Wed Jan 21, 2004 10:31 pm
by victor_diago
people, really it was not a zoneminder issue, i think that i was sharing too little memory with my kernel.

im not running redhat, but slackware 9.1, and sharing 83 MB with kernel now. im using 16 cameras, with 4 bttv cards. my problem, i think, is other, is the still watch mode. i just cant see the images.... the directory is world writable, but there is no images there.

i´ve tried everything, but id doesnt worked. im using 1.17.

please, i really want to understand it.

Re: Zone Minder´s query crash mysql (v1.17)

Posted: Wed Jan 21, 2004 10:47 pm
by zoneminder
Hi Victor,

If there are no images there at all then there is definately a problem. Can you run 'zmu -m <n> -i' interactively to generate an image in the current directory?

Also have you read the article in the Documentation section about running ZM on SlackWare as there are some important things to consider, most notably in running commands from php which is what is used to generate the images and which might be important.

Phil,

Re: Zone Minder´s query crash mysql (v1.17)

Posted: Wed Jan 21, 2004 10:56 pm
by victor_diago
now zoneminder says Out of MEMORY - killing zmc...

im with 256 MB of RAM, and sharing 67 MB,should i share more ?

Re: Zone Minder´s query crash mysql (v1.17)

Posted: Wed Jan 21, 2004 10:58 pm
by zoneminder
I don't think this is anything to do with shared memory. If you run 'top' and put in memory sort mode what does it say?

Phil,