From: | "Yury Don" <yura(at)vpcit(dot)ru> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1691: Bug in DBMirror |
Date: | 2005-05-30 12:00:48 |
Message-ID: | 20050530120048.03612F0B12@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1691
Logged by: Yury Don
Email address: yura(at)vpcit(dot)ru
PostgreSQL version: 8.0.3
Operating system: Linux (Debian)
Description: Bug in DBMirror
Details:
DBMirror doesn't mirror changes in sequences.
I've executed query
select nextval('public."demand_id_seq"')
on master database and when run DBMirror.pl, I got an error
Error sending query 411241 to db
select setval('public."demand_id_seq"',2) at ./DBMirror.pl line 771.
I suppose an error is in function sendQueryToSlaves - resultStatus compares
only with PGRES_COMMAND_OK but query like "select setval(...)"
returns tuples, so it must be compared with PGRES_TUPLES_OK
I've changed line 699 in DBMirror.pl from
unless($queryResult->resultStatus == PGRES_COMMAND_OK) {
to
unless($queryResult->resultStatus == PGRES_COMMAND_OK or
$queryResult->resultStatus == PGRES_TUPLES_OK) {
and now dbmirror works fine
From | Date | Subject | |
---|---|---|---|
Next Message | Abhijeet Gupta | 2005-05-30 13:19:44 | pg_dump.exe is failing with a fatal error |
Previous Message | Ralph Moser | 2005-05-30 10:08:08 | BUG #1690: Problem with COPY command |