Page 1 of 1
type of data ID in table "Frames" INT
Posted: Mon Oct 10, 2005 2:07 pm
by Serg
Today I have received so long expected (I waited for this case 1.5 years
) :
ERR [Can't insert frames: Duplicate entry ' 4294967295 ' for key1]
It was necessary to change type of data ID in table "Frames" INT on BIGINT.
Serg,
(ZoneMinder LiveCD 1.17.0 ..... 1.21.0)
Posted: Mon Oct 10, 2005 9:02 pm
by zoneminder
Yikes! I though it would be ages before anyone got to that! How big does a bigint go? 4G x 4G? I didn't make it this originally as I was worried it might be a bit slower than just native int size.
Phil
Posted: Tue Oct 11, 2005 6:22 am
by Serg
zoneminder wrote:Yikes! I though it would be ages before anyone got to that! How big does a bigint go? 4G x 4G? I didn't make it this originally as I was worried it might be a bit slower than just native int size.
Phil
INT (10) (from 0 up to 4294967295) - turn out a little for my configuration of system.
BIGINT (11) for the table "FRAMES" - I think it will be enough!
I worried too, whether this change will affect speed of work. But the system works also quickly as well as with type INT.
My system (works since March, 2004):
6 videocameras - 2 work in mode MODECT; 4 work in mode MONITOR in the afternoon, and at night they work in mode MODECT.
Whit many thanks to creators ZoneMinder รจ ZM LiveCD,
Serg (Russia, St.Petersburg)
Posted: Tue Oct 11, 2005 4:01 pm
by zoneminder
So that's just double then. You've only got another 1.5 years left!
Phil