View Issue Details

IDProjectCategoryView StatusLast Update
0000452Pgpool-IIBugpublic2019-01-10 09:15
Reporterilya_sAssigned Topengbo 
PriorityhighSeveritymajorReproducibilityalways
Status assignedResolutionopen 
PlatformUnixOSCentosOS Version7.5.1804
Product Version4.0.2 
Target VersionFixed in Version 
Summary0000452: Child process exits with status 6 by signal 6
DescriptionHello,
Getting following messages in pgpool log:

Dec 27 14:57:34 hostname pgpool[2739]: [44290-1] 2018-12-27 14:57:34: pid 2739: LOG: child process with pid: 12172 exits with status 6 by signal 6
Dec 27 14:57:34 hostname pgpool[2739]: [44291-1] 2018-12-27 14:57:34: pid 2739: LOG: fork a new child process with pid: 12600
Dec 27 14:57:34 hostname pgpool[6145]: [42107-1] 2018-12-27 14:57:34: pid 6145: LOG: md5 authentication successful with frontend
Dec 27 14:57:56 hostname pgpool[2739]: [44292-1] 2018-12-27 14:57:56: pid 2739: LOG: child process with pid: 5529 exits with status 6 by signal 6
Dec 27 14:57:56 hostname pgpool[2739]: [44293-1] 2018-12-27 14:57:56: pid 2739: LOG: fork a new child process with pid: 12629
Dec 27 14:57:56 hostname pgpool[58519]: [41691-1] 2018-12-27 14:57:56: pid 58519: LOG: md5 authentication successful with frontend
Dec 27 14:58:05 hostname pgpool[2739]: [44294-1] 2018-12-27 14:58:05: pid 2739: LOG: child process with pid: 6635 exits with status 6 by signal 6
Dec 27 14:58:05 hostname pgpool[2739]: [44295-1] 2018-12-27 14:58:05: pid 2739: LOG: fork a new child process with pid: 12646
Dec 27 14:58:05 hostname pgpool[2739]: [44296-1] 2018-12-27 14:58:05: pid 2739: LOG: child process with pid: 10506 exits with status 6 by signal 6
Dec 27 14:58:05 hostname pgpool[2739]: [44297-1] 2018-12-27 14:58:05: pid 2739: LOG: fork a new child process with pid: 12647
Dec 27 14:58:05 hostname pgpool[7670]: [42147-1] 2018-12-27 14:58:05: pid 7670: LOG: md5 authentication successful with frontend
Dec 27 14:58:05 hostname pgpool[6326]: [42113-1] 2018-12-27 14:58:05: pid 6326: LOG: md5 authentication successful with frontend
Dec 27 14:58:08 hostname pgpool[2739]: [44298-1] 2018-12-27 14:58:08: pid 2739: LOG: child process with pid: 10109 exits with status 6 by signal 6

Issue has no time pattern and it happens since the 4.0.0 version (not sure about earlier releases).

Can you please help to find out the reason? The issue is that connection got terminated and we're getting an error in application.
Additional InformationPools settings are following:

child_life_time = 15
child_max_connections = 0
connection_life_time = 0
client_idle_limit = 0
TagsNo tags attached.

Activities

ilya_s

2018-12-27 23:20

reporter   ~0002311

Sorry, forget to mention, Postgresql is 11.1 installed from repos.

pengbo

2019-01-09 10:07

developer   ~0002314

Could you provide pgpool's debug log?
Start pgpool with "-d" option to log debug messages.

Issue History

Date Modified Username Field Change
2018-12-27 23:19 ilya_s New Issue
2018-12-27 23:20 ilya_s Note Added: 0002311
2019-01-09 10:07 pengbo Assigned To => pengbo
2019-01-09 10:07 pengbo Status new => feedback
2019-01-09 10:07 pengbo Note Added: 0002314
2019-01-09 22:41 ilya_s Status feedback => assigned