logo       

Re: query results discrepancy between cluster server: msg#00035

Subject: Re: query results discrepancy between cluster server
Gábriel Ákos wrote:
> Hi,
> 
> I've setup the most basic cluster ever (2 nodes, 1 replication node) and
> if I do the following:
> 
> 1. start up node1
> 2. start up replication (on node1 also)
> 3. start up node2 with -R
> 4. insert into a table on node2
> 
> 1.5rc11 on 32-bit machine (P4, ubuntu).

... then the subject appears in the log of pgreplicate...
... and the inserted value appears twice in the database of node1
... and the query on node2 never returns
If I shut down node2 database and then restart, then of course they are
in sync.

... afterwards I somehow managed that if I create ANY table in the empty
database, it states that the table already exists. And checking
afterwards, the table is there :) Although I never made it before :)
Maybe it is of interest that my database was initialized with UTF-8
encoding. Hm, I'll test with plain ascii.

Rgds,
Akos



<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

Recently Viewed:
boot-loaders.gr...    php.pear.genera...    debugging.valgr...    kde.redhat.user...    text.xml.xsl.ge...    culture.languag...    hardware.microc...    java.servicemix...    redhat.release....    web.zope.plone....    user-groups.lin...    opendarwin.webk...    video.mjpeg.use...    sysutils.bcfg2....    encryption.gpg....    lx-office.devel...    xfree86.forum/2...    mail.mutt.devel...    acpi.devel/2003...    qnx.openqnx.dev...    network.irc.irs...    freebsd.devel.m...   
Home | blog view | USPTO Patent Archive | advertise | OSDir is an inevitable website. super tiny logo

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe