Re: [ADMIN] [DBmirror Issue] recordchange() dies in packageData unless there is a PRIMARY KEY on DELETE and UPDATEs.
Hi Steven,
Your most recent version pending.c does not crashes
postmaster anymore when PRIMARY KEYS are missing.
Instead it raises notices and errors:
tradein_clients= BEGIN work; UPDATE iid_listing set city='DELHI testing' where
list_id=23312;
BEGIN
NOTICE: Could not select primary index key
NOTICE: Error obtaining primary key values
ERROR: Operation could not be mirrored
Regds
Mallah.
On Tuesday 24 September 2002 02:18, Steven Singer wrote:
On Mon, 23 Sep 2002, Rajesh Kumar Mallah. wrote:
Hi
Is anyone using dbmirror in production?
We've been using it in production for sometime now and haven't been having
any problems with it.
I Intend to replicate a set of tables between local and remote servers.
and plan to use dbmirror.
The speed of replicating edits over a WAN isn't that great.
If you perform a lot of edits in a short period of time there could be a
backlog.
I observe that unless a table has a primary key the trigger
recordchange() which is supposed to be attached to a replicated table
does not works properly and causes postmaster to crash.
dbmirror requires that all tables that you replicate have primary
keys(This should be said more explictly in the README)
However it still should not crash(In defence it will only crash the
postmaster when you compile dbmirror in debug mode).
The attatched patch to pending.c should prevent it from crashing the
postmaster. Let me know if it fixes the problem and I'll submit it to
pgpatches.
*** pending.c Mon Sep 23 20:24:04 2002
--- /tmp/pending.cMon Sep 23 20:23:43 2002
***
*** 226,232
/* pplan = SPI_saveplan(pplan); */
cpKeyData = packageData(tTupleData, tTupleDesc, tpTrigData,
PRIMARY);
#if defined DEBUG_OUTPUT
! elog(NOTICE, cpKeyData);
#endif
saPlanData[0] = PointerGetDatum(cpKeyData);
--- 226,235
/* pplan = SPI_saveplan(pplan); */
cpKeyData = packageData(tTupleData, tTupleDesc, tpTrigData,
PRIMARY);
#if defined DEBUG_OUTPUT
! if(cpKeyData != NULL )
! {
! elog(NOTICE, cpKeyData);
! }
#endif
saPlanData[0] = PointerGetDatum(cpKeyData);
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[ADMIN] hardware question
Hello *, I've got a question concerning hardware. We're planning to replace our SUNS (E3500,E3000,E450 etc) with multiprocessor XEON boards. Is there any recommendation or experience about this type of hardware ? kind regards -andreas -- Andreas Schmitz - Phone +49 201 8501 318 Cityweb-Technik-Service-Gesellschaft mbH Friedrichstr. 12 - Fax +49 201 8501 104 45128 Essen - email [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[ADMIN] Feature or Bug Questions
There are few items I was wondering if I could get an answer as to whether they are features or bugs and if they are bugs the release in which they might be rectified. Issue #1 If you drop a table and then recreate it. Trying to access a view on that table returns error about OID not being found. If you drop and recreate the view the problem goes away. Issue #2 This one is a bit more indepth but on updates it appears that implicit numeric conversion is not happening. Here is a link to some of our lengthy discussions on it... http://kt.zork.net/GNUe/gnue20020615_33.html#12 I can give exact query examples if the developers dont understand the issue. -- Derek Neighbors GNU Enterprise http://www.gnuenterprise.org [EMAIL PROTECTED] Was I helpful? Let others know: http://svcs.affero.net/rm.php?r=dneighbo signature.asc Description: This is a digitally signed message part
Re: [ADMIN] Feature or Bug Questions
On Thu, Sep 26, 2002 at 08:54:12AM -0700, Derek Neighbors wrote: If you drop a table and then recreate it. Trying to access a view on that table returns error about OID not being found. If you drop and recreate the view the problem goes away. Yes. This is a known problem. I _think_ 7.3 (currently in beta) is going to do something about it, but don't hold me to that. Issue #2 This one is a bit more indepth but on updates it appears that implicit numeric conversion is not happening. Here is a link to some of our lengthy discussions on it... There has been a great whack of discussion in -hackers recently about the implicit rules. The short answer is Here There Be Dragons. But you can probably try quoting everything; you may find it works fine for you. A Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] hardware question
I assume you'll be running Linux on this? We're running a 4x700 right now, it's very dependable. But be careful, you're getting yourself into (as far as Linux goes) very high end hardware. It's easy enough to find people who can support a uni or dual-proc box. Finding expertise on 4-way or higher systems is more difficult. A wide variety of kernel issues can present themselves. Memory addressing comes to mind. Not many Linux systems have 4+gb of ram, how did you set up bigmem? These things you may not even notice for a year until you grow to tbe point where you hit the choaker. But don't mind me, I've just run into one this last week and it's driving me nuts. (Some weird kernel bug, that is) Of course, none of this matters if you're not running Linux (go you) but then again, I've heard Slowaris x86 is.. well. slow. And you wouldn't be seriously considering NT would you? Does *BSD have those SMP bugs worked out? I would highly recommend you purchase your hardware through a solid company. Get Dell, IBM or Compaq to build you a machine. Xeon machines are very complex, you'll save yourself time, headaches and (lots) of money by going with the big guys. I am curious, why are you getting away from Sun? I've been under the impression that Sun hardware kills IA32 when it comes time to play. (eg. high load) Am I reading too much FUD these days? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andreas Schmitz Sent: Thursday, September 26, 2002 6:38 AM To: [EMAIL PROTECTED] Subject: [ADMIN] hardware question Hello *, I've got a question concerning hardware. We're planning to replace our SUNS (E3500,E3000,E450 etc) with multiprocessor XEON boards. Is there any recommendation or experience about this type of hardware ? kind regards -andreas -- Andreas Schmitz - Phone +49 201 8501 318 Cityweb-Technik-Service-Gesellschaft mbH Friedrichstr. 12 - Fax +49 201 8501 104 45128 Essen - email [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] hardware question
A note on your last point. We have a bunch of older SUN boxes around here. e450, e250, etc. The 2MB L2 cache un the UltraSparc 2 does allow for a high load. And for their era they were sweet chips, still are. But the #1 reason in my mind to move from Sun to an Lintel box would be cost. Sun is expensive. It seems to me that the Intel/AMD world has moved forward at a faster pace, definelty more bang for the buck (Althons are great). My 2 cents. On Thu, 2002-09-26 at 10:25, Adam Erickson wrote: I assume you'll be running Linux on this? We're running a 4x700 right now, it's very dependable. But be careful, you're getting yourself into (as far as Linux goes) very high end hardware. It's easy enough to find people who can support a uni or dual-proc box. Finding expertise on 4-way or higher systems is more difficult. A wide variety of kernel issues can present themselves. Memory addressing comes to mind. Not many Linux systems have 4+gb of ram, how did you set up bigmem? These things you may not even notice for a year until you grow to tbe point where you hit the choaker. But don't mind me, I've just run into one this last week and it's driving me nuts. (Some weird kernel bug, that is) Of course, none of this matters if you're not running Linux (go you) but then again, I've heard Slowaris x86 is.. well. slow. And you wouldn't be seriously considering NT would you? Does *BSD have those SMP bugs worked out? I would highly recommend you purchase your hardware through a solid company. Get Dell, IBM or Compaq to build you a machine. Xeon machines are very complex, you'll save yourself time, headaches and (lots) of money by going with the big guys. I am curious, why are you getting away from Sun? I've been under the impression that Sun hardware kills IA32 when it comes time to play. (eg. high load) Am I reading too much FUD these days? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andreas Schmitz Sent: Thursday, September 26, 2002 6:38 AM To: [EMAIL PROTECTED] Subject: [ADMIN] hardware question Hello *, I've got a question concerning hardware. We're planning to replace our SUNS (E3500,E3000,E450 etc) with multiprocessor XEON boards. Is there any recommendation or experience about this type of hardware ? kind regards -andreas -- Andreas Schmitz - Phone +49 201 8501 318 Cityweb-Technik-Service-Gesellschaft mbH Friedrichstr. 12 - Fax +49 201 8501 104 45128 Essen - email [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [ADMIN] hardware question
On Thu, Sep 26, 2002 at 12:25:51PM -0500, Adam Erickson wrote: I am curious, why are you getting away from Sun? I've been under the impression that Sun hardware kills IA32 when it comes time to play. (eg. high load) Am I reading too much FUD these days? Maybe. I can say for sure that an older PIII 2-way VA Linux box running FreeBSD that we had here was running cirles around a 2-way E450 we have. I think it sort of depends on the kind of load. The really _big_ advantage Sun is supposed to offer is the supreme hardware reliability. In the interests of not rousing any lawyers, I will refrain from commenting on the extent to which that advantage is realised in fact. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[ADMIN] compiling version 7.2.2 on AIX 4.3.1 can't find F_OIDEQ
Hi. I'm trying to install postgres 7.2.2 on AIX 4.3.1 (on a powerpc bull) and I get this message on gmake: gmake[4]: Entering directory `/desa/postgres/postgresql-7.2.2/src/backend/access/heap' xlc -O2 -qmaxmem=16384 -qsrcmsg -qlonglong -I../../../../src/include -c -o tuptoaste r.o tuptoaster.c 914 | (RegProcedure) F_OIDEQ, ..a...a - 1506-045 (S) Undeclared identifier F_OIDEQ. 997 | (RegProcedure) F_OIDEQ, ..a...a - 1506-045 (S) Undeclared identifier F_OIDEQ. Any ideas? ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] compiling version 7.2.2 on AIX 4.3.1 can't find F_OIDEQ
Ligia Pimentel [EMAIL PROTECTED] writes: I downloaded the tar files for version 7.2.1 and the problem doesn't exist in that versionso I already installed postgres and i'm testing it. So far, so good. It's hard to believe that there'd be any difference between 7.2.2 and 7.2.1 on this point. Ligia Pimentel [EMAIL PROTECTED] wrote in message an07k4$2f7u$[EMAIL PROTECTED]">news:an07k4$2f7u$[EMAIL PROTECTED]... Hi. I'm trying to install postgres 7.2.2 on AIX 4.3.1 (on a powerpc bull) and I get this message on gmake: gmake[4]: Entering directory `/desa/postgres/postgresql-7.2.2/src/backend/access/heap' xlc -O2 -qmaxmem=16384 -qsrcmsg -qlonglong -I../../../../src/include -c -o tuptoaste r.o tuptoaster.c 914 | (RegProcedure) F_OIDEQ, ..a...a - 1506-045 (S) Undeclared identifier F_OIDEQ. 997 | (RegProcedure) F_OIDEQ, I believe this is the first symptom that you get if the src/backend/utils/Gen_fmgrtab.sh script fails to make a valid fmgroids.h file. We've seen problems like that on systems with no awk program installed, for example. Check the archives for previous reports for more details. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
