View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000503 | Pgpool-II | Bug | public | 2019-04-28 11:41 | 2019-08-15 16:37 |
| Reporter | zfuhao | Assigned To | t-ishii | ||
| Priority | immediate | Severity | crash | Reproducibility | always |
| Status | feedback | Resolution | open | ||
| Platform | Openstack/KVM | OS | Red Hat Enterprise Linux Server | OS Version | 6.8 |
| Product Version | 4.0.4 | ||||
| Summary | 0000503: 2019-04-28 09:43:14: pid 26332: WARNING: child process with pid: 26387 was terminated by segmentation fault | ||||
| Description | Every 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. | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
|
|
|
Which version of PostgreSQL are you using? |
|
|
Thank you for your reply, the version of our database is 9.5.16 |
|
|
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? |
|
|
No response from the reporter over 1 month. Issue will be closed. |
| 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 | |
| 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 |
