[pgpool-general: 2741] Re: CREATE ROLE fails in replication mode

[Yugo Nagata]

Hi,

Please confirm that the role doesn't exist in any of the backends,
otherwise this error would occur.

BTY, pgpool 3.3.0 is too old and 3.3.3 is released now. Many bugs
including a bug load-balance behavior in replication mode are fixed.
I recommend to use the latest pgpool.

On Wed, 09 Apr 2014 10:50:33 +0200
Rypl Lukas <rypl at marconi.ttc.cz> wrote:

>   Hello,
> 
>   We are using pgpool 3.3.0 and postges 9.1 in replication mode with 
> queries send to master db, without parallel queries or load balancing. 
> There seems to be some kind of problem related to creating new database 
> roles via pgpool. The new role does not exist but CREATE ROLE command 
> fails with error message telling that it already exists.
> 
> Example:
> 
> postgres=# SELECT rolname FROM pg_roles WHERE rolname='export';
>   rolname
> ---------
> (0 rows)
> 
> postgres=# CREATE ROLE export;
> ERROR:  kind mismatch among backends. Possible last query was: "CREATE 
> ROLE export;" kind details are: 0[C] 1[E: role "export" already exists]
> HINT:  check data consistency among db nodes
> ERROR:  kind mismatch among backends. Possible last query was: "CREATE 
> ROLE export;" kind details are: 0[C] 1[E: role "export" already exists]
> HINT:  check data consistency among db nodes
> The connection to the server was lost. Attempting reset: Succeeded.
> 
> 
> I could not find any information related to creating new user roles via 
> pgpool. So maybe the right question is: Is it supposed to work or not?
> 
> 
>   Thanks and Regards,
>   Lukas Rypl
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


-- 
Yugo Nagata <nagata at sraoss.co.jp>