Hi, Gurus.

(Our configuration: Ingres 2006 Version II 9.0.4 (int.w32/10500) on Windows Server 2003 R2 SP1)

After a crash, it seems that a lot of transactions were lost and that our main database comes back to its state at the moment of the last CP.

On restart, we find in the iircp.log, that 2 Databases need recovery. These 2 databases are "transfertvax" and "imadb". Why our main database is not listed?

There are, for sure, many transactions running on it at the crash time. We think that the message "54 Transactions must be Redone" concerns this database. No message indicates that these transactions have been redone. Why?

Someone can explain that?

Here is an abstract of the iircp.log:

!Wed Jan 17 08:36:21 2007 RCP: Marking Log File status VALID.
!Wed Jan 17 08:36:21 2007 RCP-P0: Offline Recovery: Build Recovery Context.
! Log File Window:   BOF <1149292415,442587,712> EOF <1149292415,443197,436>.
! Consistency Point: CP  <1149292415,443109,376>.
!Wed Jan 17 08:36:21 2007 RCP-P0: Reading Information from Consistency Point.
!Wed Jan 17 08:36:21 2007 RCP-P1: Start Analysis Pass.
! Analysis Window:  CP <1149292415,443109,376> to EOF <1149292415,443197,436>.
! <1149292415,443111,120> End CP  Record: New BOF: <1149292415,442587,712>
!Wed Jan 17 08:36:21 2007 RCP-P1: Analysis Pass Complete.
!Wed Jan 17 08:36:21 2007 RCP-P1: Initialize System for Recovery.
!Wed Jan 17 08:36:21 2007 RCP-P1: Check Recovery Context.
!Wed Jan 17 08:36:22 2007 RCP-P1: Recovery context complete:
! 2 Databases need recovery.
! 54 Transactions must be Redone.
! 0 Transactions must be Undone.
! 0 Transactions in Willing Commit state.
! Database transfertvax, ID 3ED75403: REDO from LGA <1149292415,443109,376>
!     0 completed transactions require REDO.
!     0 open transactions require REDO then UNDO.
! Database imadb, ID 4480CF7E: REDO from LGA <1149292415,443109,376>
!     0 completed transactions require REDO.
!     0 open transactions require REDO then UNDO.
! Non-Redo Operations: No REDO recovery on these tables prior to LSN.
!     DB 3ABB5CDA, Table (83454, 0)  at LSN (1149292376,295757096)
!     DB 3ABB5CDA, Table (83453, 0)  at LSN (1149292376,295757076)
!     DB 3ABB5CDA, Table (83452, 0)  at LSN (1149292376,295757013)
!     DB 3ABB5CDA, Table (83421, 0)  at LSN (1149292376,295756974)
!Wed Jan 17 08:36:22 2007 RCP-P1: Prepare Databases for Recovery.
!Wed Jan 17 08:36:22 2007 RCP Mark open  transfertvax ID: 00020001 ROOT: D:\IngresII\ingres\data\default\transfertvax
!Wed Jan 17 08:36:22 2007 RCP Mark open  imadb ID: 00040001 ROOT: d:\IngresII\ingres\data\default\imadb
!Wed Jan 17 08:36:22 2007 RCP-P2: Start Redo Pass.
! Redo Window:  CP <1149292415,443109,376> to EOF <1149292415,443197,436>.
!Wed Jan 17 08:36:22 2007 RCP-P2: Redo Pass Complete.
!Wed Jan 17 08:36:22 2007 RCP-P3: Start Undo Phase.
!Wed Jan 17 08:36:22 2007 RCP-P3: Undo Complete.
!Wed Jan 17 08:36:22 2007 UPDATE_BOF: BOF after Recovery: <1149292415,442587,712>
!Wed Jan 17 08:36:22 2007 RCP-P3: Begin Recovery Cleanup Phase.
! Database transfertvax successfully recovered
! Database imadb successfully recovered
!Wed Jan 17 08:36:22 2007 RCP Mark close transfertvax ID: 00020001 ROOT: D:\IngresII\ingres\data\default\transfertvax
!Wed Jan 17 08:36:22 2007 RCP Mark close imadb ID: 00040001 ROOT: d:\IngresII\ingres\data\default\imadb
!Wed Jan 17 08:36:22 2007 Recovery Operations Completed.
!Wed Jan 17 08:36:22 2007 RCP: BOF after recovery: <1149292415,442587,712>
!Alter the log-full-limit in percentage to 90
!Alter the consistency point interval block count to 10240
!Alter the force-abort-limit in percentage to 72
!Alter the maximum consistency point interval for invoking archiver to 1
!
!Wed Jan 17 08:36:22 2007 RCP Dual logging is ENABLED.
!Wed Jan 17 08:36:22 2007 RCP LOG IS ONLINE.

___________________________
Bernard Casgrain
Computer Analyst
Projet BALSAC
(418) 545-5011 (6525)
___________________________