Hello List, <br><br>on my PGPool 3.2.1 Cluster, replicating with load balanced mode on Postgres 9.2 Nodes, I tried to change the template1 database to UTF-8.<div><br></div><div>Changeing the database metadate so I can drop the database worked just fine, but when dropping the database once, I get a mismatch, when trying to drop it twice the cluster just gets completely disconnected(I had four online nodes when I started). <br>
<br>The following is what happened in the psql console: <br><br><br>postgres=# UPDATE pg_database SET datallowconn = TRUE WHERE datname = 'template0';<br>UPDATE 1<br>postgres=# \c template0 <br>You are now connected to database "template0" as user "postgres".<br>
template0=# DROP DATABASE template1;<br>ERROR: cannot drop a template database<br>template0=# UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1';<br>UPDATE 1<br>template0=# DROP DATABASE template1;<br>
ERROR: kind mismatch among backends. Possible last query was: "DROP DATABASE template1;" kind details are: 0[C] 1[E: database "template1" is being accessed by other users] 2[E: database "template1" is being accessed by other users] 3[C]<br>
HINT: check data consistency among db nodes<br>ERROR: kind mismatch among backends. Possible last query was: "DROP DATABASE template1;" kind details are: 0[C] 1[E: database "template1" is being accessed by other users] 2[E: database "template1" is being accessed by other users] 3[C]<br>
HINT: check data consistency among db nodes<br>The connection to the server was lost. Attempting reset: Succeeded.<br>template0=# DROP DATABASE template1;<br>ERROR: kind mismatch among backends. Possible last query was: "DROP DATABASE template1;" kind details are: 0[E: database "template1" does not exist] 1[C] 3[E: database "template1" does not exist]<br>
HINT: check data consistency among db nodes<br>ERROR: kind mismatch among backends. Possible last query was: "DROP DATABASE template1;" kind details are: 0[E: database "template1" does not exist] 1[C] 3[E: database "template1" does not exist]<br>
HINT: check data consistency among db nodes<br>The connection to the server was lost. Attempting reset: Failed.<br>!></div><div><br></div><div><br></div><div>Shouldn't there be at least some kind of mechanism in PGPool to check, if this DROP operation is possible instead of degrading the whole cluster with the failure of it?</div>