For full details check your web logs

Support and queries relating to all previous versions of ZoneMinder
Locked
craver84
Posts: 96
Joined: Sun Aug 31, 2008 7:35 am

For full details check your web logs

Post by craver84 »

Hi everyone,
when I try to see the list of the events I've this message error

Code: Select all

An error has occurred and this operation cannot continue.
For full details check your web logs for the code 'B83AB6'
The code number changes each time!

I'm sorry, I don't know where i can find le logs....
Top
User avatar
cordel
Posts: 5210
Joined: Fri Mar 05, 2004 4:47 pm
Location: /USA/Washington/Seattle

Post by cordel »

Check in /var/log/httpd or as described in http://www.zoneminder.com/forums/viewtopic.php?t=10820 and the FAQ
Top
craver84
Posts: 96
Joined: Sun Aug 31, 2008 7:35 am

Post by craver84 »

I'm wondering what I can tell you to help...
maybe this error could be related to my new axis 205. Before I installed it yesterday the system works great...


when I try to access to the zm database with webmin, this is the error that appears:

Code: Select all

SQL show index from `Frames` failed : Table './zm/Frames' is marked as crashed and should be repaired

this is var/log/apache2/error.log:

Code: Select all

[Tue Sep 16 09:27:36 2008] [error] [client 192.168.1.200] SQL-ERROR(CF136E): select * from Frames where EventId = '2267' and Score = '0' order by FrameId limit 0,1, referer: http://192.168.1.200/zm/index.php
[Tue Sep 16 09:27:36 2008] [error] [client 192.168.1.200] SQL-ERROR(CF136E): Table './zm/Frames' is marked as crashed and should be repaired, referer: http://192.168.1.200/zm/index.php
[Tue Sep 16 09:27:39 2008] [error] [client 192.168.1.200] SQL-ERROR(5E0F66): select * from Frames where EventId = '2267' and Score = '0' order by FrameId limit 0,1, referer: http://192.168.1.200/zm/index.php
[Tue Sep 16 09:27:39 2008] [error] [client 192.168.1.200] SQL-ERROR(5E0F66): Table './zm/Frames' is marked as crashed and should be repaired, referer: http://192.168.1.200/zm/index.php
[Tue Sep 16 13:25:37 2008] [error] [client 192.168.1.200] SQL-ERROR(C12DC2): select * from Frames where EventId = '2267' and Score = '0' order by FrameId limit 0,1, referer: http://192.168.1.200/zm/index.php
[Tue Sep 16 13:25:37 2008] [error] [client 192.168.1.200] SQL-ERROR(C12DC2): Table './zm/Frames' is marked as crashed and should be repaired, referer: http://192.168.1.200/zm/index.php
[Tue Sep 16 13:25:48 2008] [error] [client 192.168.1.200] SQL-ERROR(C8280A): select * from Frames where EventId = '2267' and Score = '0' order by FrameId limit 0,1, referer: http://192.168.1.200/zm/index.php
[Tue Sep 16 13:25:48 2008] [error] [client 192.168.1.200] SQL-ERROR(C8280A): Table './zm/Frames' is marked as crashed and should be repaired, referer: http://192.168.1.200/zm/index.php
[Tue Sep 16 13:25:54 2008] [error] [client 192.168.1.200] SQL-ERROR(C84C8C): select * from Frames where EventId = '2323' and Score = '0' order by FrameId limit 0,1, referer: http://192.168.1.200/zm/index.php
[Tue Sep 16 13:25:54 2008] [error] [client 192.168.1.200] SQL-ERROR(C84C8C): Table './zm/Frames' is marked as crashed and should be repaired, referer: http://192.168.1.200/zm/index.php

this is the beginning and the end of the file var/log/messages:
it you want the entire files, I'll send you!

Code: Select all

Sep 16 07:48:59 ZMPC syslogd 1.5.0#1ubuntu1: restart.
Sep 16 07:48:59 ZMPC zma_m1[8087]: WAR [Waiting for capture daemon]
Sep 16 07:49:30 ZMPC last message repeated 31 times
Sep 16 07:50:31 ZMPC last message repeated 61 times
Sep 16 07:50:50 ZMPC last message repeated 19 times
Sep 16 07:50:51 ZMPC zmdc[8063]: INF [Starting pending process, zmc -m 1] 
Sep 16 07:50:51 ZMPC zmdc[8063]: INF ['zmc -m 1' starting at 08/09/16 07:50:51, pid = 7893] 
Sep 16 07:50:51 ZMPC zmdc[7893]: INF ['zmc -m 1' started at 08/09/16 07:50:51] 
Sep 16 07:50:51 ZMPC zmc_m1[7893]: INF [Debug Level = 0, Debug Log = <none>]
Sep 16 07:50:51 ZMPC zmc_m1[7893]: INF [Starting Capture]
Sep 16 07:50:51 ZMPC zma_m1[8087]: WAR [Waiting for capture daemon]
Sep 16 07:50:52 ZMPC zmdc[8063]: INF [Starting pending process, zmc -m 2] 
Sep 16 07:50:52 ZMPC zmdc[7894]: INF ['zmc -m 2' started at 08/09/16 07:50:52] 
Sep 16 07:50:52 ZMPC zmc_m2[7894]: INF [Debug Level = 0, Debug Log = <none>]
Sep 16 07:50:52 ZMPC zmc_m2[7894]: INF [Starting Capture]
Sep 16 07:50:52 ZMPC zmdc[8063]: INF ['zmc -m 2' starting at 08/09/16 07:50:52, pid = 7894] 
Sep 16 07:50:52 ZMPC zma_m1[8087]: WAR [Waiting for capture daemon]
........................
.......................
Sep 16 13:28:46 ZMPC zmc_m2[11318]: INF [DCS900: 233000 - Capturing at 15.38 fps]
Sep 16 13:28:46 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:28:47 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:28:48 ZMPC zmc_m3[11141]: INF [axis205: 354000 - Capturing at 22.73 fps]
Sep 16 13:28:48 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:29:19 ZMPC last message repeated 31 times
Sep 16 13:29:21 ZMPC last message repeated 2 times
Sep 16 13:29:21 ZMPC zma_m2[20802]: INF [DCS900: 7000 - Processing at 15.38 fps]
Sep 16 13:29:22 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:29:24 ZMPC last message repeated 2 times
Sep 16 13:29:24 ZMPC zma_m3[20985]: INF [axis205: 5000 - Processing at 22.73 fps]
Sep 16 13:29:25 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:29:31 ZMPC last message repeated 6 times
Sep 16 13:29:32 ZMPC zmc_m3[11141]: INF [axis205: 355000 - Capturing at 22.73 fps]
Sep 16 13:29:32 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:29:51 ZMPC last message repeated 19 times
Sep 16 13:29:52 ZMPC zmc_m2[11318]: INF [DCS900: 234000 - Capturing at 15.15 fps]
Sep 16 13:29:52 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:30:08 ZMPC last message repeated 16 times
Sep 16 13:30:09 ZMPC zma_m3[20985]: INF [axis205: 6000 - Processing at 22.22 fps]
Sep 16 13:30:09 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:30:15 ZMPC last message repeated 6 times
Sep 16 13:30:16 ZMPC zmc_m3[11141]: INF [axis205: 356000 - Capturing at 22.73 fps]
Sep 16 13:30:16 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:30:26 ZMPC last message repeated 10 times
Sep 16 13:30:27 ZMPC zma_m2[20802]: INF [DCS900: 8000 - Processing at 15.15 fps]
Sep 16 13:30:27 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:30:53 ZMPC last message repeated 25 times
Sep 16 13:30:53 ZMPC zma_m3[20985]: INF [axis205: 7000 - Processing at 22.73 fps]
Sep 16 13:30:54 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:30:57 ZMPC last message repeated 3 times
Sep 16 13:30:57 ZMPC zmc_m2[11318]: INF [DCS900: 235000 - Capturing at 15.38 fps]
Sep 16 13:30:58 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:31:00 ZMPC last message repeated 2 times
Sep 16 13:31:00 ZMPC zmc_m3[11141]: INF [axis205: 357000 - Capturing at 22.73 fps]
Sep 16 13:31:01 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:31:32 ZMPC last message repeated 31 times
Sep 16 13:31:32 ZMPC zma_m2[20802]: INF [DCS900: 9000 - Processing at 15.38 fps]
Sep 16 13:31:33 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:31:37 ZMPC last message repeated 4 times
Sep 16 13:31:37 ZMPC zma_m3[20985]: INF [axis205: 8000 - Processing at 22.73 fps]
Sep 16 13:31:38 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:31:44 ZMPC last message repeated 6 times
Sep 16 13:31:44 ZMPC zmc_m3[11141]: INF [axis205: 358000 - Capturing at 22.73 fps]
Sep 16 13:31:45 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:32:02 ZMPC last message repeated 17 times
Sep 16 13:32:02 ZMPC zmc_m2[11318]: INF [DCS900: 236000 - Capturing at 15.38 fps]
Sep 16 13:32:03 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:32:21 ZMPC last message repeated 18 times
Sep 16 13:32:21 ZMPC zma_m3[20985]: INF [axis205: 9000 - Processing at 22.73 fps]
Sep 16 13:32:22 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:32:28 ZMPC last message repeated 6 times
Sep 16 13:32:28 ZMPC zmc_m3[11141]: INF [axis205: 359000 - Capturing at 22.73 fps]
Sep 16 13:32:29 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:32:37 ZMPC last message repeated 8 times
Sep 16 13:32:38 ZMPC zmdc[11111]: INF [Starting pending process, zmaudit.pl -c] 
Sep 16 13:32:38 ZMPC zmdc[11111]: INF ['zmaudit.pl -c' starting at 08/09/16 13:32:38, pid = 21275] 
Sep 16 13:32:38 ZMPC zmdc[21275]: INF ['zmaudit.pl -c' started at 08/09/16 13:32:38] 
Sep 16 13:32:38 ZMPC zma_m2[20802]: INF [DCS900: 10000 - Processing at 15.15 fps]
Sep 16 13:32:38 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:33:05 ZMPC last message repeated 27 times
Sep 16 13:33:05 ZMPC zma_m3[20985]: INF [axis205: 10000 - Processing at 22.73 fps]
Sep 16 13:33:06 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:33:08 ZMPC last message repeated 2 times
Sep 16 13:33:08 ZMPC zmc_m2[11318]: INF [DCS900: 237000 - Capturing at 15.15 fps]
Sep 16 13:33:09 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Sep 16 13:33:12 ZMPC last message repeated 3 times
Sep 16 13:33:13 ZMPC zmc_m3[11141]: INF [axis205: 360000 - Capturing at 22.22 fps]
Sep 16 13:33:13 ZMPC zma_m1[11135]: WAR [Waiting for capture daemon]
Top
User avatar
cordel
Posts: 5210
Joined: Fri Mar 05, 2004 4:47 pm
Location: /USA/Washington/Seattle

Post by cordel »

Looks like the database is crashed. instructions are in the faq.
Top
craver84
Posts: 96
Joined: Sun Aug 31, 2008 7:35 am

Post by craver84 »

resolved, thanks!
Top
craver84
Posts: 96
Joined: Sun Aug 31, 2008 7:35 am

Post by craver84 »

it's the second time in few days that my mysql crashes:

Code: Select all

SQL show index from `Frames` failed : Table './zm/Frames' is marked as crashed and should be repaired
and the Stats table too

my HD was full so I deleted some events, after that the database crashed...


In my SQL administrator I clicked on repair. The results seems to be good...

Code: Select all

Table: zm.Frames  WARNING: Number of rows changed from 19377 to 19407
Table: zm.Frames  Status: OK


Table: zm.Stats  WARNING: Number of rows changed from 10256 to 10279
Table: zm.Stats  Status: OK
Top
coke
Posts: 518
Joined: Wed Jan 30, 2008 5:53 pm
Location: St. Louis, MO, USA

Post by coke »

Sounds like you need to do some faq and forum searching on purgewhenfull.
Top
Locked

Return to “ZoneMinder Previous Versions”