View Issue Details

IDProjectCategoryView StatusLast Update
0000503Pgpool-IIBugpublic2019-08-15 16:37
ReporterzfuhaoAssigned Tot-ishii 
PriorityimmediateSeveritycrashReproducibilityalways
Status feedbackResolutionopen 
PlatformOpenstack/KVMOSRed Hat Enterprise Linux ServerOS Version6.8
Product Version4.0.4 
Target VersionFixed in Version 
Summary0000503: 2019-04-28 09:43:14: pid 26332: WARNING: child process with pid: 26387 was terminated by segmentation fault
DescriptionEvery time we do a stress test, we always get this error when simulating the concurrency of around 200 users.

019-04-28 09:58:51: pid 28450: WARNING: child process with pid: 28847 was terminated by segmentation fault
2019-04-28 09:58:51: pid 28450: LOG: fork a new child process with pid: 30567

But we have no problem connecting directly to the three instances in the background.

TagsNo tags attached.

Activities

zfuhao

2019-04-28 11:41

reporter  

gdb.log (10,844 bytes)
pgpool.conf (41,592 bytes)

zfuhao

2019-04-28 12:17

reporter  

core28847.rar (121,959 bytes)

t-ishii

2019-04-28 19:10

developer   ~0002577

Which version of PostgreSQL are you using?

zfuhao

2019-05-05 16:43

reporter   ~0002581

Thank you for your reply, the version of our database is 9.5.16

t-ishii

2019-05-06 10:00

developer   ~0002582

Last edited: 2019-05-06 10:02

View 2 revisions

Thank you for the info. From gdb.log,
    if (create_table_stmt->relation->relpersistence == 't')
access to a pointer (create_table_stmt->relation) seems to cause the segfault. Apparently this should not happen but I failed to see the cause from what I read the source code. So I tried to reproduce the error by running following simple script using pgbench:
$ cat ../create_table.sql
CREATE TEMP TABLE t1(i int);
SELECT * FROM t1;

$ pgbench -p 11000 -n -c 180 -C -T 300 -P 5 -f ../create_table.sql test

So far I see no error.

Can you provide a test case so that I could reproduce the problem?

t-ishii

2019-08-15 16:37

developer   ~0002783

No response from the reporter over 1 month. Issue will be closed.

Issue History

Date Modified Username Field Change
2019-04-28 11:41 zfuhao New Issue
2019-04-28 11:41 zfuhao File Added: pgpool.conf
2019-04-28 11:41 zfuhao File Added: gdb.log
2019-04-28 12:17 zfuhao File Added: core28847.rar
2019-04-28 19:10 t-ishii Note Added: 0002577
2019-05-05 16:43 zfuhao Note Added: 0002581
2019-05-06 10:00 t-ishii Note Added: 0002582
2019-05-06 10:02 t-ishii Note Edited: 0002582 View Revisions
2019-05-07 08:45 administrator Assigned To => t-ishii
2019-05-07 08:45 administrator Status new => assigned
2019-05-17 09:30 administrator Status assigned => feedback
2019-08-15 16:37 t-ishii Note Added: 0002783