View Issue Details

IDProjectCategoryView StatusLast Update
0000609Pgpool-IIBugpublic2020-05-01 20:19
ReporterSeemaAssigned Tot-ishii 
PriorityurgentSeveritymajorReproducibilityalways
Status feedbackResolutionopen 
Product Version3.5.3 
Target VersionFixed in Version 
Summary0000609: server closed the connection unexpectedly
DescriptionWhen Application tries to insert data into a new DB created (Schema DB), the operation fails with error:
server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
Steps To ReproduceWe have created a DN with multiple Schemas ; around 80 schemas inside a single DB.

Insert operation on any schema fails with the above mentioned error.
TagsNo tags attached.

Activities

t-ishii

2020-05-01 17:33

developer   ~0003347

Can you share Pgpool-II log and pgpool.conf?

Seema

2020-05-01 19:39

reporter   ~0003348

Hi, Conf file and log files are shared

pgpool_may1.log (1,130 bytes)
pgpool.conf (34,826 bytes)

t-ishii

2020-05-01 20:18

developer   ~0003350

May 1 11:06:12 apgp1 pgpool[6445]: [12-1] 2020-05-01 11:06:12: pid 6445: LOG: child process with pid: 6555 exits with status 10 by signal 10

It seems your problem is related to this. Pgpool-II 3.5.3 is very old (released 4 years ago) and there have been multiple fixes related to SIGUSR1 (= signal 10) since then. I am not sure which of which is related to the problem but I suggest you to upgrade to the latest version of Pgpool-II 3.5 series. Currently it's 3.5.24.

Issue History

Date Modified Username Field Change
2020-04-30 20:45 Seema New Issue
2020-05-01 17:29 t-ishii Assigned To => t-ishii
2020-05-01 17:29 t-ishii Status new => assigned
2020-05-01 17:33 t-ishii Note Added: 0003347
2020-05-01 17:33 t-ishii Status assigned => feedback
2020-05-01 19:39 Seema File Added: pgpool.conf
2020-05-01 19:39 Seema File Added: pgpool_may1.log
2020-05-01 19:39 Seema Note Added: 0003348
2020-05-01 19:39 Seema Status feedback => assigned
2020-05-01 20:18 t-ishii Note Added: 0003350
2020-05-01 20:19 t-ishii Status assigned => feedback