Skip site navigation (1) Skip section navigation (2)

Re: dbmirror bug

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Hai-Chen Tu <hctu(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: dbmirror bug
Date: 2002-11-22 16:04:52
Message-ID: 200211221604.gAMG4q923813@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Good catch.  Fix will be in 7.3.

---------------------------------------------------------------------------

Hai-Chen Tu wrote:
> Your name               : Hai-Chen Tu    
> Your email address      : hctu(at)yahoo(dot)com
> 
> 
> System Configuration
> ---------------------
>   Architecture (example: Intel Pentium)         :
> 
>   Operating System (example: Linux 2.0.26 ELF)  :
> 
>   PostgreSQL version (example: PostgreSQL-7.3):  
> PostgreSQL-7.3
> 
>   Compiler used (example:  gcc 2.95.2)          :
> 
> 
> Please enter a FULL description of your problem:
> ------------------------------------------------
> dbmirror generates "out of memory" error in some
> cases when the DEBUG_OUTPUT is enabled.
> 
> 
> 
> 
> Please describe a way to repeat the problem.   Please
> try to provide a
> concise reproducible example, if at all possible: 
> ----------------------------------------------------------------------
> The cause of the problem is that pending.c in dbmirror
> uses
>     elog(NOTICE, cpKeyData)
> and
>     elog(NOTICE, cpFieldData)
> to print column data where elog
> interprets the second argument as sprintf
> format string, which fails if
> cpKeyData/cpFieldData contains '%'.
> 
> 
> 
> 
> If you know how this problem might be fixed, list the
> solution below:
> ---------------------------------------------------------------------
> 
> The solution is to change
>     elog(NOTICE, ...)
> to
>     elog(NOTICE, "%s", ...)
> 
> This applies to all cpKeyData and cpFieldData,
> and probably cpFieldName.
> 
> 
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus  Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-11-22 16:26:55
Subject: Re: dbmirror bug
Previous:From: Tom LaneDate: 2002-11-22 15:38:39
Subject: Re: Is this planner choice easily explained?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group