DBI statement still active

[neouser]

Hello,

I am getting this message in zmdc.log:

prepare_cached(select distinct EventId from Frames left join Events on Frames.EventId = Events.Id where isnull(Events.Id) group by EventId) statement handle DBI::st=HASH(0x8453fc0) still Active at /usr/local/bin/zmaudit.pl line 279
prepare_cached(select distinct EventId from Stats left join Events on Stats.EventId = Events.Id where isnull(Events.Id) group by EventId) statement handle DBI::st=HASH(0x8454080) still Active at /usr/local/bin/zmaudit.pl line 291
prepare_cached(select E.Id, max(F.TimeStamp) as EndTime, unix_timestamp(max(F.TimeStamp)) - unix_timestamp(E.StartTime) as Length, count(F.Id) as Frames, count(if(F.Score>0,1,NULL)) as AlarmFrames, sum(F.Score) as TotScore, max(F.Score) as MaxScore, M.EventPrefix as Prefix from Events as E left join Monitors as M on E.MonitorId = M.Id inner join Frames as F on E.Id = F.EventId where isnull(E.Frames) group by E.Id having EndTime < (now() - interval 300 second)) statement handle DBI::st=HASH(0x8454158) still Active at /usr/local/bin/zmaudit.pl line 304

This message is filling zmdc.log since we update to 1.22.2. If ZM is stopped, the message appears after the first execution of zmupdate.pl in every running of zmupdate.pl.

It seems related with DBI::mysql, but i am using last perl modules DBD 3.0006 and DBI::mysql 1.52, also i am running last ZM 1.22.2. I am a bit lost and any hints would be pleased.

Thanks

[zoneminder]

I think this is fixed for the next release. However it is not a bit issue eithe rway. It is only a warning and doesn't affect functionality.

[neouser]

Phil,

Thanks for your answer

Manuel