Re: [Info-Ingres] Archiver Fails: Why are my journal files 2G +512bytes?

#1

On 6/29/11 8:12 AM, Martin Bowes wrote:

Quote:

Hi All,

II 10.0.0 (a64.lnx/132)NPTL + p14061

For God only knows what reason we have a database in which the system has decided to build
a 2G journal file.

Trouble is that once the journal gets to 2147484160 (=2G + 512) bytes the archiver fails.
....
Short of blowing away the log file is there anything else that an be done?

Maybe try alterdb -disable_journaling on that database. You might have to kill
off the archiver to run the alterdb, not sure.

Karl

#2

Done.

The alterdb had no problem. The log file is now back to zero and the database in question and all others involved in the log are not marked inconsistent.

Thanks Karl.

Marty

-----Original Message-----
From: Karl Schendel [mailto:karl.schendel (AT) ingres (DOT) com]
Sent: 29 June 2011 13:20
To: Martin Bowes
Cc: Ingres and related product discussion forum
Subject: Re: Archiver Fails: Why are my journal files 2G + 512bytes?

On 6/29/11 8:12 AM, Martin Bowes wrote:

Quote:

Hi All,

II 10.0.0 (a64.lnx/132)NPTL + p14061

For God only knows what reason we have a database in which the system has decided to build
a 2G journal file.

Trouble is that once the journal gets to 2147484160 (=2G + 512) bytes the archiver fails.
....
Short of blowing away the log file is there anything else that an be done?

Maybe try alterdb -disable_journaling on that database. You might have to kill
off the archiver to run the alterdb, not sure.

Karl

#3

This is known Bug 116605.
The workaround is to set the archiver_refresh parmeter to a smaller
value.

--
choch02

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [Info-Ingres] Archiver Fails: Why are my journal files 2G +512bytes?

comp.databases.ingres comp.databases.ingres

Re: [Info-Ingres] Archiver Fails: Why are my journal files 2G +512bytes? - 06-29-2011 , 07:19 AM

Re: [Info-Ingres] Archiver Fails: Why are my journal files 2G +512bytes? - 06-29-2011 , 07:27 AM

Re: [Info-Ingres] Archiver Fails: Why are my journal files 2G +512bytes? - 07-07-2011 , 10:14 AM