Re: oncheck error
Posted in 1997
In article <33c108a7.8633153@news.tel.hr>, Mario Kvesic
<mkvesic@open.hr> writes
>Hi !
> I am working with OnLine DS 7.22.UC1 on ULTRA Enterprise 3000
>with Solaris 2.5.1.I and disk space on SSA Model 112.
> Every night I run in script "oncheck -cD database_name -y" and
> "oncheck -cI database_name -y" procedure.
>From time to time error messages appears in my message log file.
> Below is part of my message log with errors.
>
>Thu Jun 19 03:33:25 1997
>
>03:33:25 Checkpoint Completed: duration was 0 seconds.
>03:43:25 Checkpoint Completed: duration was 0 seconds.
>03:53:25 Checkpoint Completed: duration was 0 seconds.
>04:13:25 Checkpoint Completed: duration was 0 seconds.
>04:23:25 Checkpoint Completed: duration was 0 seconds.
>04:33:39 Assert Failed: ptmap
>04:33:39 Who: Session(5286, informix@server_name, 11997, 675872652)
> Thread(23632, xchg_1.1, 265a9740, 4)
>04:33:39 Results: Could not complete operation on
>'database_name:"informix".table_name'
>04:33:39 Action: Run 'oncheck -cDI 3145730'
>04:33:39 See Also: /exp/tmp/af.5c509a83>Sun Jun 22 03:31:09 1997
>
>03:31:09 Checkpoint Completed: duration was 0 seconds.
>03:41:09 Checkpoint Completed: duration was 0 seconds.
>03:51:09 Checkpoint Completed: duration was 0 seconds.
>04:21:09 Checkpoint Completed: duration was 0 seconds.
>04:31:09 Checkpoint Completed: duration was 0 seconds.
>04:32:25 I/O bad request chunk 2051, pagenum 653447, pagecnt 1
>04:32:25 I/O bad request chunk 2051, pagenum 653447, pagecnt 1
>04:32:25 I/O bad request chunk 2051, pagenum 35162, pagecnt 1
>04:41:44 Checkpoint Completed: duration was 35 seconds.>
> ....
>
>Sun Jun 29 03:32:20 1997
>
>03:32:20 Checkpoint Completed: duration was 0 seconds.
>03:42:20 Checkpoint Completed: duration was 0 seconds.
>03:52:20 Checkpoint Completed: duration was 0 seconds.
>04:12:20 Checkpoint Completed: duration was 0 seconds.
>04:27:24 Checkpoint Completed: duration was 304 seconds.
>04:37:24 Checkpoint Completed: duration was 0 seconds.
>04:48:18 Checkpoint Completed: duration was 54 seconds.
>04:54:46 I/O bad request chunk 2050, pagenum 34231, pagecnt 1>
>Are these messages serious ?
Yes, either you have a corrupt Online instance or bad areas on the
disk. Talk to Informix and be prepared to restore from the last level 0
archive which is ok.
>What should I do ?
Talk to Informix.
>I have got duration of checkpoint 300+ seconds ( there is noone on
> the system in that time). Is it OK ?
>Should I run oncheck with some other options instead ?
>What are recomended procedures for daily check ?
>
>Any ideas or suggestions would be appreciated.
>
>
>Thanks in advance
> Mario Kvesic
> mkvesic@open.hr
>
--
David Williams