View Issue Details

IDProjectCategoryView StatusLast Update
0000598Pgpool-IIBugpublic2020-05-21 11:30
ReporterXavok Assigned ToMuhammad Usama  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version4.1.0 
Target Version4.1.2Fixed in Version4.1.2 
Summary0000598: segmentation fault
DescriptionHi
I constantly get an error in the log:
WARNING: PCP process with pid: 23498 was terminated by segmentation fault
Is this normal?
In the attachment, my configuration file and extended log
I use 2xPostgreSQL 11.6 + 1 PgPool-II
Tagspcp, pgpool

Activities

Xavok

2020-03-20 13:06

reporter  

pgpool.conf (40,916 bytes)
pgpool.log (1,152,940 bytes)

t-ishii

2020-03-20 17:47

developer   ~0003273

Last edited: 2020-03-20 18:04

Of course it's not normal. Can you provide stack trace of the segfault process?

Xavok

2020-03-21 19:08

reporter   ~0003274

Added GBD, did you need this?
gdb.txt (11,863 bytes)   
gdb.txt (11,863 bytes)   

t-ishii

2020-03-31 13:57

developer   ~0003286

Sorry for delay. gdb.txt looks like a stack trace of Pgpool-II parent process. What I wanted was the stack trace of pgpool child process which segfaults. To get the stack trace, you need to let the pgpool child process produce a core dump file, and take a stack trace from the core file. Can you please do that?

Xavok

2020-04-03 02:49

reporter   ~0003297

In the attachment
gdb.log (6,999 bytes)

t-ishii

2020-04-03 15:10

developer   ~0003298

Thanks. It's pretty strange. Maybe someone broke memory...

Xavok

2020-04-03 15:25

reporter   ~0003299

I have 2 identical virtual servers running multiple instances of pgpool on different ports, could there be a problem because of this?

Xavok

2020-04-03 15:28

reporter   ~0003300

For clarity, added a screen with running pgpool in the attachment
Снимок.JPG (176,068 bytes)   
Снимок.JPG (176,068 bytes)   

t-ishii

2020-04-03 15:35

developer   ~0003301

> I have 2 identical virtual servers running multiple instances of pgpool on different ports, could there be a problem because of this?
No I don't think so. Pgpool-II's bult-in regression test regularly runs multiple pgpool instances on a physical/virtual machine without problem. I have asked help from Muhammad Usama who is an authority of PCP subsystem.

Xavok

2020-04-15 20:58

reporter   ~0003327

Is there new information?

t-ishii

2020-04-16 14:07

developer   ~0003329

I have changed the person in charge from me to Usama, who is the authority in this area.

Muhammad Usama

2020-04-16 19:27

developer   ~0003330

Thanks, Xavok for providing the gdb stack trace that really helped to quickly pinpoint the issue.

I have pushed the fix to all affected branches.

https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=75432c06bda37ff9c15e3e586624e21218a0a40c

cheers

Issue History

Date Modified Username Field Change
2020-03-20 13:06 Xavok New Issue
2020-03-20 13:06 Xavok File Added: pgpool.conf
2020-03-20 13:06 Xavok File Added: pgpool.log
2020-03-20 13:06 Xavok Tag Attached: pcp
2020-03-20 13:06 Xavok Tag Attached: pgpool
2020-03-20 17:47 t-ishii Note Added: 0003273
2020-03-20 17:48 t-ishii Assigned To => t-ishii
2020-03-20 17:48 t-ishii Status new => feedback
2020-03-20 17:48 t-ishii Description Updated
2020-03-20 18:04 t-ishii Note Edited: 0003273
2020-03-21 19:08 Xavok File Added: gdb.txt
2020-03-21 19:08 Xavok Note Added: 0003274
2020-03-21 19:08 Xavok Status feedback => assigned
2020-03-31 13:57 t-ishii Note Added: 0003286
2020-03-31 13:58 t-ishii Status assigned => feedback
2020-04-03 02:49 Xavok File Added: gdb.log
2020-04-03 02:49 Xavok Note Added: 0003297
2020-04-03 02:49 Xavok Status feedback => assigned
2020-04-03 15:10 t-ishii Note Added: 0003298
2020-04-03 15:25 Xavok Note Added: 0003299
2020-04-03 15:28 Xavok File Added: Снимок.JPG
2020-04-03 15:28 Xavok Note Added: 0003300
2020-04-03 15:35 t-ishii Note Added: 0003301
2020-04-15 20:58 Xavok Note Added: 0003327
2020-04-16 14:06 t-ishii Assigned To t-ishii => Muhammad Usama
2020-04-16 14:07 t-ishii Note Added: 0003329
2020-04-16 19:27 Muhammad Usama Status assigned => resolved
2020-04-16 19:27 Muhammad Usama Resolution open => fixed
2020-04-16 19:27 Muhammad Usama Note Added: 0003330
2020-05-21 11:22 administrator Fixed in Version => 4.1.2
2020-05-21 11:22 administrator Target Version => 4.1.2
2020-05-21 11:30 administrator Status resolved => closed