Is there a way to import events?

[eldertoon]

Hi,

Well, question a bit strange. I believe we had a mounting issue on the event folder and the system decided to cleanup the database with all events that were not on the disk anymore. I corrected the mount, but now I have a lot of events that fill up the space and the system deletes all new events (it considers that the disk space limit is reached and delete the events it knows about).

My question: is there a way to reimport all those events? The workaround is to delete them but I would loose two months.

Thanks

[iconnor]

zmrecover.pl

[eldertoon]

Well, I'm too dumb. I did not try to have a look at the included scripts. I confirm, I tested a couple of them and that's OK. Still, it produces a lot of sql errors? See below. But anyway, that was not the subject and topic is now closed. Thank you a lot for your fast answer!

For dumb people as me, as I have a lot to recover and do not care a lot about what is recovered, I need to type Y or ENTER at the prompt, so I used:

Code: Select all

yes | zmrecover.pl

Code: Select all

 
06/21/2025 08:24:08.040088 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (FrameId,Delta,Score,Type,Id,EventId,TimeStamp) VALUES (00259,128.917081594467,0,Normal,undef,2438632,2025-03-30 03:42:19)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.040560 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (TimeStamp,EventId,Type,Id,Score,Delta,FrameId) VALUES (2025-03-30 03:42:19,2438632,Normal,undef,0,129.66508769989,00260)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.041032 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (Type,Id,TimeStamp,EventId,FrameId,Delta,Score) VALUES (Normal,undef,2025-03-30 03:42:20,2438632,00261,129.917089939117,0)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.041504 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (Delta,Score,FrameId,TimeStamp,EventId,Type,Id) VALUES (130.641095876694,0,00262,2025-03-30 03:42:20,2438632,Normal,undef)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.041981 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (FrameId,Delta,Score,Type,Id,EventId,TimeStamp) VALUES (00263,131.673104524612,0,Normal,undef,2438632,2025-03-30 03:42:21)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.042458 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (EventId,TimeStamp,Type,Id,Delta,Score,FrameId) VALUES (2438632,2025-03-30 03:42:21,Normal,undef,131.685104608536,0,00264)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.043391 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (FrameId,Delta,Score,Id,Type,EventId,TimeStamp) VALUES (00265,132.165108680725,0,undef,Normal,2438632,2025-03-30 03:42:22)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.044368 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (TimeStamp,EventId,Id,Type,Delta,Score,FrameId) VALUES (2025-03-30 03:42:22,2438632,undef,Normal,132.649112701416,0,00266)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.045150 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (Score,Delta,FrameId,EventId,TimeStamp,Type,Id) VALUES (0,133.145117044449,00267,2438632,2025-03-30 03:42:23,Normal,undef)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.045910 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (Type,Id,EventId,TimeStamp,FrameId,Delta,Score) VALUES (Normal,undef,2438632,2025-03-30 03:42:23,00268,133.429119348526,0)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.046605 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (Type,Id,EventId,TimeStamp,FrameId,Score,Delta) VALUES (Normal,undef,2438632,2025-03-30 03:42:24,00269,0,133.917123317719)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]

[iconnor]

There is -i=0 for turning off interactivity, THe yes | is another good way to do it.

Those errors means that the Event doesn't exist in the db, but it should have been just added. SOmething must have gone wrong inserting the event record.