[BUGS] BUG #1691: Bug in DBMirror

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

[BUGS] BUG #1691: Bug in DBMirror

Yury Don

The following bug has been logged online:

Bug reference:      1691
Logged by:          Yury Don
Email address:      [hidden email]
PostgreSQL version: 8.0.3
Operating system:   Linux (Debian)
Description:        Bug in DBMirror

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) {
unless($queryResult->resultStatus == PGRES_COMMAND_OK or
$queryResult->resultStatus == PGRES_TUPLES_OK) {
and now dbmirror works fine

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [hidden email] so that your
      message can get through to the mailing list cleanly