[pgpool-general: 3704] Re: Importing a full dump as postgres user
Tatsuo Ishii
ishii at postgresql.org
Wed May 13 08:12:36 JST 2015
This might be related to a bug found and fixed after 3.4.2 was out.
http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=7a8b27b410c61d0c651e160e7cf47fff62298316
Although the bug was linked to cache invalidation problem, the bug
corrupts random memory, and I suspect it may cause a problem you have.
Can you try to grab the 3.4-stable head (it will be 3.4.3
in the future) to see if your problem is fixed?
A tar ball can be obtained from:
http://git.postgresql.org/gitweb/?p=pgpool2.git;a=snapshot;h=535b4e313d383f2ba29ff55673903ff34f819515;sf=tgz
x
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> Good morning my friend.
>
> If I disable the memory query cache, it works fine.
>
> My pgpool-II is pgpool-II version 3.4.2 (tataraboshi).
>
> I'm using load balance, replication and query cache (shmem) with 64 MB.
>
> My OS is CentOS 7 with kernel 3.10.0-229.1.2.el7.x86_64, 32GB of RAM and 24 cores. It runs only pgpool-II.
>
> This is the backtrace:
>
> { "signal": 11
> , "executable": "/usr/pgpool-9.3/bin/pgpool"
> , "stacktrace":
> [ { "crash_thread": true
> , "frames":
> [ { "address": 4627865
> , "build_id": "9837aefdc97b50694853f70514db1046635c11d7"
> , "build_id_offset": 433561
> , "function_name": "AllocSetAlloc"
> , "file_name": "/usr/pgpool-9.3/bin/pgpool"
> }
> , { "address": 4793787
> , "build_id": "9837aefdc97b50694853f70514db1046635c11d7"
> , "build_id_offset": 599483
> , "function_name": "makeStringInfo"
> , "file_name": "/usr/pgpool-9.3/bin/pgpool"
> }
> , { "address": 4376244
> , "build_id": "9837aefdc97b50694853f70514db1046635c11d7"
> , "build_id_offset": 181940
> , "function_name": "pool_extract_error_message"
> , "file_name": "/usr/pgpool-9.3/bin/pgpool"
> }
> , { "address": 4420675
> , "build_id": "9837aefdc97b50694853f70514db1046635c11d7"
> , "build_id_offset": 226371
> , "function_name": "per_node_error_log"
> , "file_name": "/usr/pgpool-9.3/bin/pgpool"
> }
> , { "address": 4462387
> , "build_id": "9837aefdc97b50694853f70514db1046635c11d7"
> , "build_id_offset": 268083
> , "function_name": "pool_send_and_wait"
> , "file_name": "/usr/pgpool-9.3/bin/pgpool"
> }
> , { "address": 4401444
> , "build_id": "9837aefdc97b50694853f70514db1046635c11d7"
> , "build_id_offset": 207140
> , "function_name": "SimpleQuery"
> , "file_name": "/usr/pgpool-9.3/bin/pgpool"
> }
> , { "address": 4423660
> , "build_id": "9837aefdc97b50694853f70514db1046635c11d7"
> , "build_id_offset": 229356
> , "function_name": "ProcessFrontendResponse"
> , "file_name": "/usr/pgpool-9.3/bin/pgpool"
> }
> , { "address": 4372473
> , "build_id": "9837aefdc97b50694853f70514db1046635c11d7"
> , "build_id_offset": 178169
> , "function_name": "read_packets_and_process.constprop.9"
> , "file_name": "/usr/pgpool-9.3/bin/pgpool"
> }
> , { "address": 4374419
> , "build_id": "9837aefdc97b50694853f70514db1046635c11d7"
> , "build_id_offset": 180115
> , "function_name": "pool_process_query"
> , "file_name": "/usr/pgpool-9.3/bin/pgpool"
> }
> , { "address": 4352425
> , "build_id": "9837aefdc97b50694853f70514db1046635c11d7"
> , "build_id_offset": 158121
> , "function_name": "do_child"
> , "file_name": "/usr/pgpool-9.3/bin/pgpool"
> }
> , { "address": 4223772
> , "build_id": "9837aefdc97b50694853f70514db1046635c11d7"
> , "build_id_offset": 29468
> , "function_name": "fork_a_child"
> , "file_name": "/usr/pgpool-9.3/bin/pgpool"
> }
> , { "address": 4227293
> , "build_id": "9837aefdc97b50694853f70514db1046635c11d7"
> , "build_id_offset": 32989
> , "function_name": "reaper"
> , "file_name": "/usr/pgpool-9.3/bin/pgpool"
> }
> , { "address": 4227949
> , "build_id": "9837aefdc97b50694853f70514db1046635c11d7"
> , "build_id_offset": 33645
> , "function_name": "pool_sleep"
> , "file_name": "/usr/pgpool-9.3/bin/pgpool"
> }
> , { "address": 4238895
> , "build_id": "9837aefdc97b50694853f70514db1046635c11d7"
> , "build_id_offset": 44591
> , "function_name": "PgpoolMain"
> , "file_name": "/usr/pgpool-9.3/bin/pgpool"
> }
> , { "address": 4214814
> , "build_id": "9837aefdc97b50694853f70514db1046635c11d7"
> , "build_id_offset": 20510
> , "function_name": "main"
> , "file_name": "/usr/pgpool-9.3/bin/pgpool"
> } ]
> } ]
> }
>
> =============================================================
> 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
> =============================================================
>
>
> ----- Mensagem original -----
> De: "Tatsuo Ishii" <ishii at postgresql.org>
> Para: jrcmilanez at unifei.edu.br
> Cc: pgpool-general at pgpool.net
> Enviadas: Terça-feira, 12 de maio de 2015 1:15:48
> Assunto: Re: [pgpool-general: 3700] Importing a full dump as postgres user
>
> 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
More information about the pgpool-general
mailing list