[pgpool-general: 3702] Re: Importing a full dump as postgres user

[Tatsuo Ishii]

More details please. What version of pgpool-II. You can get the full
version number by typing "pgpool --help".

Also we need back trace:
gdb /usr/pgpool-9.3/bin/pgpool /var/tmp/abrt/ccpp-2015-05-11-14:47:56-1751
then type "bt".

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Hello friends, how are you?
> 
> I'm importing a full dump as postgres user. The dump contains the same user with the same password and was created with the pg_dumpall -c option.
> While importing, I got a crash with the output below. My question is: is it crash because it´s trying to drop the postgres role?
> 
> Thanks!
> 
> May 11 14:45:55 tarso pgpool[1759]: [260-1] 2015-05-11 14:45:55: pid 1759: LOG:  pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 19052 statement: "DROP ROLE postgres;" message: "usuário atual não pode ser removido"
> May 11 14:45:55 tarso pgpool[1759]: [261-1] 2015-05-11 14:45:55: pid 1759: LOG:  pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 21881 statement: "DROP ROLE postgres;" message: "usuário atual não pode ser removido"
> May 11 14:45:55 tarso pgpool: 2015-05-11 14:45:55: pid 1759: LOG:  pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 19052 statement: "DROP ROLE postgres;" message: "usuário atual não pode ser removido"
> May 11 14:45:55 tarso pgpool: 2015-05-11 14:45:55: pid 1759: LOG:  pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 21881 statement: "DROP ROLE postgres;" message: "usuário atual não pode ser removido"
> May 11 14:45:57 tarso pgpool[1759]: [262-1] 2015-05-11 14:45:57: pid 1759: LOG:  pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 19052 statement: "CREATE ROLE postgres;" message: "role "postgres" já existe"
> May 11 14:45:57 tarso pgpool: 2015-05-11 14:45:57: pid 1759: LOG:  pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 19052 statement: "CREATE ROLE postgres;" message: "role "postgres" já existe"
> May 11 14:45:57 tarso pgpool[1759]: [263-1] 2015-05-11 14:45:57: pid 1759: LOG:  pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 21881 statement: "CREATE ROLE postgres;" message: "role "postgres" já existe"
> May 11 14:45:57 tarso pgpool: 2015-05-11 14:45:57: pid 1759: LOG:  pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 21881 statement: "CREATE ROLE postgres;" message: "role "postgres" já existe"
> May 11 14:47:56 tarso kernel: pgpool[1751]: segfault at 61da ip 0000000000469d99 sp 00007fff20755e90 error 4 in pgpool[400000+134000]
> May 11 14:47:56 tarso abrt-hook-ccpp: Saved core dump of pid 1751 (/usr/pgpool-9.3/bin/pgpool) to /var/tmp/abrt/ccpp-2015-05-11-14:47:56-1751 (144973824 bytes)
> May 11 14:47:56 tarso pgpool[1186]: [329-1] 2015-05-11 14:47:56: pid 1186: WARNING:  child process with pid: 1751 was terminated by segmentation fault
> May 11 14:47:56 tarso pgpool[1186]: [330-1] 2015-05-11 14:47:56: pid 1186: LOG:  fork a new child process with pid: 1884
> May 11 14:47:56 tarso pgpool: 2015-05-11 14:47:56: pid 1186: WARNING:  child process with pid: 1751 was terminated by segmentation fault
> May 11 14:47:56 tarso pgpool: 2015-05-11 14:47:56: pid 1186: LOG:  fork a new child process with pid: 1884
> 
> 
> =============================================================
> M.Sc. José Renato Castro Milanez
> Analista de Tecnologia da Informação/TI Analist
> Diretoria de Suporte a Informática/Computer Support Direction
> Universidade Federal de Itajubá/Federal University of Itajubá
> Itajubá - Minas Gerais - Brasil
> Telefone/Phone (55) (35) 3629-1643
> E-mail jrcmilanez at unifei.edu.br - Skype jrcmilanez
> =============================================================
> 
> 
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general