From owner-freebsd-bugs@FreeBSD.ORG  Mon Oct 11 07:40:28 2004
Return-Path: <owner-freebsd-bugs@FreeBSD.ORG>
Delivered-To: freebsd-bugs@hub.freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id B020D16A4CE
	for <freebsd-bugs@hub.freebsd.org>;
	Mon, 11 Oct 2004 07:40:28 +0000 (GMT)
Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21])
	by mx1.FreeBSD.org (Postfix) with ESMTP id A0DCF43D45
	for <freebsd-bugs@hub.freebsd.org>;
	Mon, 11 Oct 2004 07:40:28 +0000 (GMT)
	(envelope-from gnats@FreeBSD.org)
Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1])
	by freefall.freebsd.org (8.12.11/8.12.11) with ESMTP id i9B7eSMV055521
	for <freebsd-bugs@freefall.freebsd.org>; Mon, 11 Oct 2004 07:40:28 GMT
	(envelope-from gnats@freefall.freebsd.org)
Received: (from gnats@localhost)
	by freefall.freebsd.org (8.12.11/8.12.11/Submit) id i9B7eSoc055520;
	Mon, 11 Oct 2004 07:40:28 GMT
	(envelope-from gnats)
Date: Mon, 11 Oct 2004 07:40:28 GMT
Message-Id: <200410110740.i9B7eSoc055520@freefall.freebsd.org>
To: freebsd-bugs@FreeBSD.org
From: Uwe Doering <gemini@geminix.org>
Subject: Re: misc/72498: Libc timestamp code on jailed SMP machine generates
 incorrect results
X-BeenThere: freebsd-bugs@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
Reply-To: Uwe Doering <gemini@geminix.org>
List-Id: Bug reports <freebsd-bugs.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-bugs>,
	<mailto:freebsd-bugs-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-bugs>
List-Post: <mailto:freebsd-bugs@freebsd.org>
List-Help: <mailto:freebsd-bugs-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-bugs>,
	<mailto:freebsd-bugs-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 11 Oct 2004 07:40:28 -0000

The following reply was made to PR misc/72498; it has been noted by GNATS.

From: Uwe Doering <gemini@geminix.org>
To: Justin Clift <jc@telstra.net>
Cc: freebsd-gnats-submit@FreeBSD.org
Subject: Re: misc/72498: Libc timestamp code on jailed SMP machine generates
   incorrect results
Date: Mon, 11 Oct 2004 09:33:38 +0200

 Justin Clift wrote:
 > 
 >>Environment:
 > 
 > FreeBSD was-dev.telstra.net 4.10-RELEASE FreeBSD 4.10-RELEASE #0: Fri Jun 25 14:23:42 EST 2004     root@verdelho.telstra.net:/usr/src/sys/compile/1GB_SHARED_V3  i386
 > 
 >>Description:
 > 
 > We're using PostgreSQL 7.4.5 in an SMP jailed environment on FreeBSD 4.10.
 > 
 > Inside this jail PostgreSQL is configured to output timestamp information in it's log file entries.  There appears to be a bug in the timestamp generation code, as for hours above 9 oclock (10am and onwards) the timestamp's being generated are occasionally incorrect:
 > [...]
 
 Do you happen to run more than one instance of PostgreSQL on that 
 machine, each in its own jail?  If so, are you aware that jails don't 
 have separate SysV shared resources (memory regions etc.), at least not 
 in FreeBSD's original 4.x implementation?  In this scenario your problem 
 might be caused by clashing PostgreSQL instances, and you're likely to 
 be in for more serious problems than just time stamp corruption.
 
 Just an educated guess, of course.
 
     Uwe
 -- 
 Uwe Doering         |  EscapeBox - Managed On-Demand UNIX Servers
 gemini@geminix.org  |  http://www.escapebox.net