[Info-Ingres] log writes vs dual log writes

This is a discussion on [Info-Ingres] log writes vs dual log writes within the Ingres Database forums in Other Databases category; 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 -...

Go Back   Database Forum > Other Databases > Ingres Database

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 10-23-2008, 06:30 AM
Default [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


Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 10:41 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Integrated by bbpixel2009 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.