Re: [Info-Ingres] log writes vs dual log writes

It did.



Interestingly, the shutdown was clean and yet cbf still said there were
uncommitted transaction in the log file.



Marty



From: info-ingres-bounces-at-kettleriverconsulting.com
[mailto:info-ingres-bounces-at-kettleriverconsulting.com] On Behalf Of
Martin Bowes
Sent: 23 October 2008 10:30
To: info-ingres-at-kettleriverconsulting.com
Subject: [Info-Ingres] log writes vs dual log writes



Hi All,



We've restarted an installation after a database went inconsistent, the
database was recovered from a checkpoint. The system was restarted OK.



Since then ... without any sign of a problem in the errlog... I'm seeing
a major disparity in the log writes and dual log writes as reported in
logstat.



write complete 1 dual write complete 554524

Status: ONLINE,ECPDONE,JSWITCHDONE

Active Log(s): II_LOG_FILE,II_DUAL_LOG



The complete lack of activity on the primary log since startup is
reinforced by a simple OS check.

flourish.ingres> cd /dbsystem/II/ingres/log/

flourish.ingres> ls -l

total 2001960

-rw------- 1 ingres ingres 2048000000 Oct 14 11:16 ingres_log.l01

flourish.ingres> cd /dbdual/II/ingres/log/

flourish.ingres> ls -l

total 2001960

-rw------- 1 ingres ingres 2048000000 Oct 23 10:18 dual_log.l01



Anyone seen anything like this before?



I'm going to shutdown and rebuild my primary log file and see if that
fixes the problem.



Martin Bowes