ZoneMinder Forums

Hello,

i use the ZoneMinder with a SuSe Linux 9 system, a noname BTTV-Card and a CCIR Camera. Since a few days, i got an error in log, when i generate a alarm - i think this is a database problem... Here are my logs:

Mar 16 18:38:15 vsrv zma-m3[15771]: INF [Initialised zone 1/Lane_1 - 1 - 266x91 - Rgb:000000, CM:3, MnAT:0, MxAT:0, MnAP:0, MxAP:0, FB:0x0, MnFP:0, MxFP:0, MnBS:0, MxBS:0, MnB:0, MxB:0]
Mar 16 18:38:15 vsrv zma-m3[15771]: INF [Loaded monitor 3(CCIR_1), 1 zones]
Mar 16 18:38:15 vsrv zma-m3[15771]: INF [Warming up]
Mar 16 18:38:15 vsrv zma-m3[15771]: INF [Generating blend table for transparency 10]
Mar 16 18:38:40 vsrv zma-m3[15771]: INF [CCIR_1: 622 - Gone into alarm state]
Mar 16 18:38:40 vsrv zma-m3[15771]: ERR [Can't insert event: Duplicate entry '3' for key 4]
Mar 16 18:38:45 vsrv zmc-d0[15265]: WAR [Buffer overrun at index 82 ]
Mar 16 18:39:19 vsrv last message repeated 8 times
Mar 16 18:39:20 vsrv zma-m3[15972]: INF [Debug Level = 0, Debug Log = ]
Mar 16 18:39:20 vsrv zma-m3[15972]: INF [Got 1 monitors]
Mar 16 18:39:20 vsrv zma-m3[15972]: INF [monitor purpose=2]
Mar 16 18:39:20 vsrv zma-m3[15972]: INF [shm.size=23040448]

Hi 'A',

This looks a little odd. I can't see a way of this happening unless you have managed to reset the autoincrement index on event Id to less than that used by existing events. Do you have events in your DB at all? Have you tried running mysqlcheck just in case there's something screwed up in the DB.

Phil,