View Issue Details

IDProjectCategoryView StatusLast Update
0000525Pgpool-IIBugpublic2019-08-15 19:15
Reporterguobo507Assigned Tot-ishii 
PrioritynormalSeveritymajorReproducibilitysometimes
Status resolvedResolutionopen 
Platformx86_64OSCentOSOS Version7.6.1810 (Core)
Product Version4.0.3 
Target Version4.0.6Fixed in Version4.0.6 
Summary0000525: Segmentation fault occurs when memory_cache_enable is set to on
DescriptionHi there,
When memory_cache_enable = on , whether using shm or memcacahed,my java project always has the following error:

org.hibernate.exception.JDBCConnectionException: could not execute query
        at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:115)
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
        at org.hibernate.loader.Loader.doList(Loader.java:2614)
        at org.hibernate.loader.Loader.doList(Loader.java:2594)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2423)
        at org.hibernate.loader.Loader.list(Loader.java:2418)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)
        at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
        at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
        at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1326)
        at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
        at com.yinhai.core.service.ta3.domain.dao.HibernateDAO.selectFildsList(HibernateDAO.java:439)
        at com.yinhai.modules.codetable.domain.dao.impl.Aa10a1DaoImpl.selectCodeList(Aa10a1DaoImpl.java:60)
        at com.yinhai.modules.codetable.domain.dao.impl.Aa10a1DaoImpl$$FastClassBySpringCGLIB$$6fcdd538.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:721)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:656)
        at com.yinhai.modules.codetable.domain.dao.impl.Aa10a1DaoImpl$$EnhancerBySpringCGLIB$$a9bb5f6d.selectCodeList(<generated>)
        at com.yinhai.modules.codetable.domain.bpo.AppCodeBpoImpl.queryAppCode(AppCodeBpoImpl.java:67)
        at com.yinhai.modules.codetable.domain.bpo.AppCodeBpoImpl$$FastClassBySpringCGLIB$$e718e8c7.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:721)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:47)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:656)
        at com.yinhai.modules.codetable.domain.bpo.AppCodeBpoImpl$$EnhancerBySpringCGLIB$$f581cb7a.queryAppCode(<generated>)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
        at com.sun.proxy.$Proxy77.queryAppCode(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:47)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
        at com.sun.proxy.$Proxy77.queryAppCode(Unknown Source)
        at com.yinhai.modules.codetable.domain.bpo.AppCodeCacheBpoImpl.refreshAll(AppCodeCacheBpoImpl.java:141)
        at com.yinhai.modules.codetable.domain.bpo.AppCodeCacheBpoImpl$$FastClassBySpringCGLIB$$1b9a2859.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:721)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:47)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:656)
        at com.yinhai.modules.codetable.domain.bpo.AppCodeCacheBpoImpl$$EnhancerBySpringCGLIB$$2bf86ec2.refreshAll(<generated>)
        at com.yinhai.modules.codetable.domain.bpo.CodeTableInitService.initAppCode(CodeTableInitService.java:38)
        at com.yinhai.modules.codetable.domain.bpo.CodeTableInitService.init(CodeTableInitService.java:27)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1758)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1695)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:866)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542)
        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)
        at com.yinhai.project.listener.StartupListener.contextInitialized(StartupListener.java:18)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4861)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5322)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:753)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:729)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:974)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1850)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
        at org.postgresql.core.v3.QueryExecutorImpl.fetch(QueryExecutorImpl.java:2377)
        at org.postgresql.jdbc.PgResultSet.next(PgResultSet.java:1856)
        at com.alibaba.druid.filter.FilterChainImpl.resultSet_next(FilterChainImpl.java:654)
        at com.alibaba.druid.filter.FilterAdapter.resultSet_next(FilterAdapter.java:1885)
        at com.alibaba.druid.filter.FilterChainImpl.resultSet_next(FilterChainImpl.java:651)
        at com.alibaba.druid.proxy.jdbc.ResultSetProxyImpl.next(ResultSetProxyImpl.java:882)
        at com.alibaba.druid.pool.DruidPooledResultSet.next(DruidPooledResultSet.java:69)
        at org.hibernate.loader.Loader.processResultSet(Loader.java:968)
        at org.hibernate.loader.Loader.doQuery(Loader.java:930)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
        at org.hibernate.loader.Loader.doList(Loader.java:2611)
        ... 101 common frames omitted
Caused by: java.io.EOFException: null
        at org.postgresql.core.PGStream.receiveChar(PGStream.java:308)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1952)
        at org.postgresql.core.v3.QueryExecutorImpl.fetch(QueryExecutorImpl.java:2372)
        ... 111 common frames omitted
......

The system dmesg message shows the following information when error occur:

Jun 20 06:25:24 localhost kernel: pgpool[8971]: segfault at ffffffff00000272 ip 00007f967eae06e7 sp 00007ffce13c4c58 error 6 in libc-2.12.so[7f967ea57000+18a000]
Jun 20 06:25:27 localhost abrt[9163]: Saved core dump of pid 8971 (/usr/pgpool-11/bin/pgpool) to /var/spool/abrt/ccpp-2019-06-20-06:25:24-8971 (1048576000 bytes)
Jun 20 06:25:27 localhost abrtd: Directory 'ccpp-2019-06-20-06:25:24-8971' creation detected
Jun 20 06:25:27 localhost pgpool[8958]: [7-1] 2019-06-20 14:25:27: pid 8958: WARNING: child process with pid: 8971 was terminated by segmentation fault
Jun 20 06:25:27 localhost pgpool[8958]: [8-1] 2019-06-20 14:25:27: pid 8958: LOG: fork a new child process with pid: 9165
Jun 20 06:25:27 localhost pgpool[8974]: [6-1] 2019-06-20 14:25:27: pid 8974: LOG: new connection received
Jun 20 06:25:27 localhost pgpool[8974]: [6-2] 2019-06-20 14:25:27: pid 8974: DETAIL: connecting host=localhost port=59906
Jun 20 06:25:27 localhost pgpool[8974]: [7-1] 2019-06-20 14:25:27: pid 8974: LOG: Parse message from frontend.
Jun 20 06:25:27 localhost pgpool[8974]: [7-2] 2019-06-20 14:25:27: pid 8974: DETAIL: statement: "", query: "SET extra_float_digits = 3"
Jun 20 06:25:27 localhost pgpool[8974]: [8-1] 2019-06-20 14:25:27: pid 8974: LOG: DB node id: 0 backend pid: 9167 statement: Parse: SET extra_float_digits = 3
Jun 20 06:25:27 localhost pgpool[8974]: [9-1] 2019-06-20 14:25:27: pid 8974: LOG: Bind message from frontend.
......

My web page prompt error 500 message.

My system logs (messages) is: messages.2_with-memory_cache_enabled-on.txt, which also contains the pgpool-II log.

By the way, when memory_cache_enable = off, everything works fine. The rpm packages we use are all from the pgdg yum repository.

can somebody help?


TagsNo tags attached.

Activities

guobo507

2019-06-21 12:06

reporter  

catalina.out.2_with-memory_cache_enabled-on (114,907 bytes)
messages.2_with-memory_cache_enabled-on (261,770 bytes)

t-ishii

2019-06-25 14:38

developer   ~0002674

Can you share Pgpool-II log with log_client_messages = on? Also stack trace of Pgpool-II would be valuable info.

guobo507

2019-06-25 18:13

reporter   ~0002676

In my pgpool.conf, log_client_messages is already enabled.

When error occur, the root user received an email message and I have uploaded the file(mail-info.txt).

stack-trace-pgpool.txt (8,307 bytes)
 # gdb pgpool ./coredump 
GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-114.el7
Copyright (C) 2013 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu".
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>...
Reading symbols from /usr/pgpool-11/bin/pgpool...Reading symbols from /usr/lib/debug/usr/pgpool-11/bin/pgpool.debug...done.
done.
[New LWP 12516]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Core was generated by `pgpool: postgres testdb 192.168.25.111(63890) idle in transaction'.
Program terminated with signal 11, Segmentation fault.
#0  0x000000000043a9c8 in Execute (frontend=frontend@entry=0x2166fa8, backend=backend@entry=0x7f0cc1daf568, len=<optimized out>, contents=contents@entry=0x216d828 "C_5")
    at protocol/pool_proto_modules.c:889
889				session_context->query_context->skip_cache_commit = false;
(gdb) bt full
#0  0x000000000043a9c8 in Execute (frontend=frontend@entry=0x2166fa8, backend=backend@entry=0x7f0cc1daf568, len=<optimized out>, contents=contents@entry=0x216d828 "C_5")
    at protocol/pool_proto_modules.c:889
        status = <optimized out>
        search_query = 0x21ba4a0 "select aa10a1po0_.AAA100 as col_0_0_, aa10a1po0_.AAA101 as col_1_0_, aa10a1po0_.AAA102 as col_2_0_, aa10a1po0_.AAA103 as col_3_0_, aa10a1po0_.YAB003 as col_4_0_, aa10a1po0_.AAE120 as col_5_0_, aa10a1p"...
        len = <optimized out>
        commit = 0
        query = <optimized out>
        node = <optimized out>
        specific_error = 0
        session_context = 0x77aae0 <session_context_d>
        query_context = <optimized out>
        bind_msg = <optimized out>
        foundp = 0 '\000'
#1  0x000000000043f08e in ProcessFrontendResponse (frontend=frontend@entry=0x2166fa8, backend=backend@entry=0x7f0cc1daf568) at protocol/pool_proto_modules.c:2517
        node = <optimized out>
        parse_tree_list = <optimized out>
        old_context = 0x1
        query_context = <optimized out>
        query = <optimized out>
        error = 0 '\000'
        fkind = 69 'E'
        bufp = <optimized out>
        contents = 0x216d828 "C_5"
        status = <optimized out>
        len = 8
#2  0x0000000000431bd9 in read_packets_and_process (frontend=frontend@entry=0x2166fa8, backend=backend@entry=0x7f0cc1daf568, reset_request=reset_request@entry=0, 
    state=state@entry=0x7ffeae43d544, num_fields=num_fields@entry=0x7ffeae43d542, cont=cont@entry=0x7ffeae43d54c "\001") at protocol/pool_process_query.c:4922
        readmask = {fds_bits = {256, 0 <repeats 15 times>}}
        writemask = {fds_bits = {0 <repeats 16 times>}}
        exceptmask = {fds_bits = {0 <repeats 16 times>}}
        fds = <optimized out>
        timeoutdata = {tv_sec = 2, tv_usec = 35024808}
        timeout = <optimized out>
        num_fds = <optimized out>
        was_error = 0
        status = <optimized out>
        i = <optimized out>
        idle_count = 0
---Type <return> to continue, or q <return> to quit--- 
        idle_count_in_recovery = 0
#3  0x000000000043271b in pool_process_query (frontend=0x2166fa8, backend=0x7f0cc1daf568, reset_request=reset_request@entry=0) at protocol/pool_process_query.c:286
        cont = 1 '\001'
        num_fields = 0
        status = <optimized out>
        qcnt = 0
        i = <optimized out>
        ProcessQueryContext = 0x7f0cc1db6dc8
        state = 0
#4  0x000000000042cf39 in do_child (fds=fds@entry=0x2161020) at protocol/child.c:392
        status = <optimized out>
        sp = <optimized out>
        saddr = {addr = {ss_family = 2, __ss_padding = "\371\222\300\250\031o", '\000' <repeats 111 times>, __ss_align = 0}, salen = 16}
        local_sigjmp_buf = {{__jmpbuf = {35000364, -4696962468673907309, 2, 0, 139692768874560, 2, 4696217772541711763, -4696958451181841005}, __mask_was_saved = 1, __saved_mask = {
              __val = {0, 139692738224130, 139692737082199, 140733120872449, 35010677, 35010677, 35010676, 35010676, 35010676, 35010676, 35010676, 35010677, 0, 0, 0, 0}}}}
        backend = 0x7f0cc1daf568
        now = {tv_sec = 1561452147, tv_usec = 806439}
        tz = {tz_minuteswest = 0, tz_dsttime = 0}
        timeout = {tv_sec = 0, tv_usec = 0}
        connected = 1
        connections_count = <optimized out>
        psbuf = "postgres testdb 192.168.25.111(63890) idle\000\256\376\177\000\000\002 \n\300\f\177\000\000W\263\370\277\f\177\000\000\001\200\255\373\000\000\000\000u8\026\002\000\000\000\000u8\026\002\000\000\000\000t8\026\002\000\000\000\000t8\026\002\000\000\000\000t8\026\002\000\000\000\000t8\026\002\000\000\000\000t8\026\002\000\000\000\000u8\026\002\000\000\000\000\305HF\000\000\000\000\000\000\000\000\061\061\061\060\070\005\000\000\000\n\000\000\000\062\060\061\071-06-25 16:42:27: pid 11108: WARNING:"...
        walk = <optimized out>
#5  0x00000000004090f5 in fork_a_child (fds=0x2161020, id=2) at main/pgpool_main.c:665
        pid = 0
#6  0x000000000040992f in reaper () at main/pgpool_main.c:2696
        new_pid = 0
        shutdown_system = 0 '\000'
        restart_child = 1 '\001'
        found = 1 '\001'
        status = 139
        i = 2
#7  0x000000000041041f in PgpoolMain (discard_status=discard_status@entry=1 '\001', clear_memcache_oidmaps=clear_memcache_oidmaps@entry=0 '\000') at main/pgpool_main.c:457
        i = 2
        local_sigjmp_buf = {{__jmpbuf = {1, -4696962475152009837, 9902, 140731822105168, 7, 2, 4696217772942267795, -4696958457666759277}, __mask_was_saved = 1, __saved_mask = {__val = {
                18446744066192964103, 0, 1, 16, 0, 262144, 5019159, 0, 139692766800170, 29, 140731822147424, 0, 281470681751424, 140731822139232, 4294967239, 139692736934221}}}}
        first = 0 '\000'
---Type <return> to continue, or q <return> to quit---
#8  0x00000000004077b7 in main (argc=<optimized out>, argv=<optimized out>) at main/main.c:349
        opt = <optimized out>
        debug_level = <optimized out>
        optindex = 0
        discard_status = 1 '\001'
        clear_memcache_oidmaps = 0 '\000'
        pcp_conf_file_path = "/etc/pgpool-II-11/pcp.conf", '\000' <repeats 8166 times>
        conf_file_path = "/etc/pgpool-II-11/pgpool.conf", '\000' <repeats 8163 times>
        hba_file_path = "/etc/pgpool-II-11/pool_hba.conf", '\000' <repeats 8161 times>
        pool_passwd_key_file_path = "/home/postgres/.pgpoolkey\000\321\037\001\213\356\267\031ͳK\350\000\277\026A5\r\n\000\000\000\000\021\000\000\000\034\000\000\000\004\000\000\000\b\000\000\000@\204\t\000\202!\020\240\250@\000\023\304Ё\030\002\"\030@\030\"D\v\200\030\b\001\">\226\002\034\000\000\000\035\000\000\000\037\000\000\000\"\000\000\000$\000\000\000'\000\000\000+\000\000\000\060\000\000\000\061\000\000\000\062\000\000\000\065\000\000\000\000\000\000\000\066\000\000\000\000\000\000\000\071\000\000\000<\000\000\000=\000\000\000\271\201\272\305\352\323\357\016\021\177\027\257\354\a\262\236\370\262E2\271\215\361\016f\267\251\177\331qX\034ʇ\345 bG\032"...
        long_options = {{name = 0x4abe72 "hba-file", has_arg = 1, flag = 0x0, val = 97}, {name = 0x4abe7b "debug", has_arg = 0, flag = 0x0, val = 100}, {name = 0x4abe81 "config-file", 
            has_arg = 1, flag = 0x0, val = 102}, {name = 0x4abe8d "key-file", has_arg = 1, flag = 0x0, val = 107}, {name = 0x4abe96 "pcp-file", has_arg = 1, flag = 0x0, val = 70}, {
            name = 0x4abe9f "help", has_arg = 0, flag = 0x0, val = 104}, {name = 0x4b0ded "mode", has_arg = 1, flag = 0x0, val = 109}, {name = 0x4abea4 "dont-detach", has_arg = 0, 
            flag = 0x0, val = 110}, {name = 0x4abeb0 "discard-status", has_arg = 0, flag = 0x0, val = 68}, {name = 0x4abebf "clear-oidmaps", has_arg = 0, flag = 0x0, val = 67}, {
            name = 0x4abecd "debug-assertions", has_arg = 0, flag = 0x0, val = 120}, {name = 0x4c93c8 "version", has_arg = 0, flag = 0x0, val = 118}, {name = 0x0, has_arg = 0, flag = 0x0, 
            val = 0}}
stack-trace-pgpool.txt (8,307 bytes)
mail-info.txt (61,873 bytes)
& 13
Message 13:
From user@localhost.localdomain  Tue Jun 25 16:34:24 2019
Return-Path: <user@localhost.localdomain>
X-Original-To: root@localhost
Delivered-To: root@localhost.localdomain
Date: Tue, 25 Jun 2019 16:34:24 +0800
From: user@localhost.localdomain
To: root@localhost.localdomain
Subject: [abrt] pgpool-II-11: pgpool killed by SIGSEGV
User-Agent: Heirloom mailx 12.5 7/5/10
Content-Type: text/plain; charset=us-ascii
Status: RO

reason:         pgpool killed by SIGSEGV
cmdline:        'pgpool: postgres testdb 192.168.25.111(61549) idle in transaction'
executable:     /usr/pgpool-11/bin/pgpool
package:        pgpool-II-11-4.0.5-1.rhel7
component:      pgpool-II-11
pid:            11117
pwd:            /
hostname:       pgsql1
count:          1
abrt_version:   2.1.11
analyzer:       CCpp
architecture:   x86_64
event_log:
global_pid:     11117
kernel:         3.10.0-957.21.3.el7.x86_64
last_occurrence: 1561451657
os_release:     CentOS Linux release 7.6.1810 (Core)
pkg_arch:       x86_64
pkg_epoch:      0
pkg_fingerprint: 1F16 D2E1 442D F0F8
pkg_name:       pgpool-II-11
pkg_release:    1.rhel7
pkg_vendor:     PostgreSQL Global Development Group
pkg_version:    4.0.5
runlevel:       N 5
time:           Tue 25 Jun 2019 04:34:17 PM CST
type:           CCpp
uid:            5432
username:       postgres
uuid:           b199b6e7b91db894c678439d98fe7f1ea7df62ab

core_backtrace:
:{   "signal": 11
:,   "executable": "/usr/pgpool-11/bin/pgpool"
:,   "stacktrace":
:      [ {   "crash_thread": true
:        ,   "frames":
:              [ {   "address": 4434376
:                ,   "build_id": "6421445dad42d6af2f3157061d35b7f7b2e0e324"
:                ,   "build_id_offset": 240072
:                ,   "function_name": "Execute"
:                ,   "file_name": "/usr/pgpool-11/bin/pgpool"
:                }
:              , {   "address": 4452494
:                ,   "build_id": "6421445dad42d6af2f3157061d35b7f7b2e0e324"
:                ,   "build_id_offset": 258190
:                ,   "function_name": "ProcessFrontendResponse"
:                ,   "file_name": "/usr/pgpool-11/bin/pgpool"
:                }
:              , {   "address": 4398041
:                ,   "build_id": "6421445dad42d6af2f3157061d35b7f7b2e0e324"
:                ,   "build_id_offset": 203737
:                ,   "function_name": "read_packets_and_process.constprop.5"
:                ,   "file_name": "/usr/pgpool-11/bin/pgpool"
:                }
:              , {   "address": 4400923
:                ,   "build_id": "6421445dad42d6af2f3157061d35b7f7b2e0e324"
:                ,   "build_id_offset": 206619
:                ,   "function_name": "pool_process_query"
:                ,   "file_name": "/usr/pgpool-11/bin/pgpool"
:                }
:              , {   "address": 4378425
:                ,   "build_id": "6421445dad42d6af2f3157061d35b7f7b2e0e324"
:                ,   "build_id_offset": 184121
:                ,   "function_name": "do_child"
:                ,   "file_name": "/usr/pgpool-11/bin/pgpool"
:                }
:              , {   "address": 4231413
:                ,   "build_id": "6421445dad42d6af2f3157061d35b7f7b2e0e324"
:                ,   "build_id_offset": 37109
:                ,   "function_name": "fork_a_child"
:                ,   "file_name": "/usr/pgpool-11/bin/pgpool"
:                }
:              , {   "address": 4259027
:                ,   "build_id": "6421445dad42d6af2f3157061d35b7f7b2e0e324"
:                ,   "build_id_offset": 64723
:                ,   "function_name": "PgpoolMain"
:                ,   "file_name": "/usr/pgpool-11/bin/pgpool"
:                }
:              , {   "address": 4224951
:                ,   "build_id": "6421445dad42d6af2f3157061d35b7f7b2e0e324"
:                ,   "build_id_offset": 30647
:                ,   "function_name": "main"
:                ,   "file_name": "/usr/pgpool-11/bin/pgpool"
:                } ]
:        } ]
:}
cgroup:
:11:cpuset:/
:10:cpuacct,cpu:/
:9:memory:/
:8:hugetlb:/
:7:devices:/system.slice
:6:net_prio,net_cls:/
:5:blkio:/
:4:freezer:/
:3:pids:/
:2:perf_event:/
:1:name=systemd:/system.slice/pgpool-II-11.service
dso_list:
:/usr/lib64/libplc4.so nspr-4.19.0-1.el7_5.x86_64 (CentOS) 1550825269
:/usr/lib64/libc-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libattr.so.1.1.0 libattr-2.4.46-13.el7.x86_64 (CentOS) 1550825269
:/usr/lib64/libgcc_s-4.8.5-20150702.so.1 libgcc-4.8.5-36.el7.x86_64 (CentOS) 1550825240
:/usr/lib64/libnssutil3.so nss-util-3.36.0-1.el7_5.x86_64 (CentOS) 1550825269
:/usr/lib64/libcrypto.so.1.0.2k openssl-libs-1:1.0.2k-16.el7.x86_64 (CentOS) 1550825275
:/usr/lib64/libpcre.so.1.2.0 pcre-8.32-17.el7.x86_64 (CentOS) 1550825269
:/usr/lib64/libdw-0.172.so elfutils-libs-0.172-2.el7.x86_64 (CentOS) 1550825381
:/usr/lib64/librt-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libdl-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libmemcached.so.11.0.0 libmemcached-1.0.16-5.el7.x86_64 (CentOS) 1560319827
:/usr/lib64/libcap.so.2.22 libcap-2.22-9.el7.x86_64 (CentOS) 1550825269
:/usr/lib64/libssl3.so nss-3.36.0-7.el7_5.x86_64 (CentOS) 1550825289
:/usr/lib64/libkrb5.so.3.3 krb5-libs-1.15.1-34.el7.x86_64 (CentOS) 1550825275
:/usr/lib64/libbz2.so.1.0.6 bzip2-libs-1.0.6-13.el7.x86_64 (CentOS) 1550825276
:/usr/lib64/ld-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libresolv-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libnss3.so nss-3.36.0-7.el7_5.x86_64 (CentOS) 1550825289
:/usr/lib64/libsmime3.so nss-3.36.0-7.el7_5.x86_64 (CentOS) 1550825289
:/usr/lib64/libldap_r-2.4.so.2.10.7 openldap-2.4.44-20.el7.x86_64 (CentOS) 1550825355
:/usr/lib64/libnss_myhostname.so.2 systemd-libs-219-62.el7.x86_64 (CentOS) 1550825381
:/usr/lib64/libgssapi_krb5.so.2.2 krb5-libs-1.15.1-34.el7.x86_64 (CentOS) 1550825275
:/usr/lib64/liblber-2.4.so.2.10.7 openldap-2.4.44-20.el7.x86_64 (CentOS) 1550825355
:/usr/pgpool-11/bin/pgpool pgpool-II-11-4.0.5-1.rhel7.x86_64 (PostgreSQL Global Development Group) 1560930507
:/usr/lib64/libcap-ng.so.0.0.0 libcap-ng-0.7.5-4.el7.x86_64 (CentOS) 1550825275
:/usr/lib64/libcrypt-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libnss_dns-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libaudit.so.1.0.0 audit-libs-2.8.4-4.el7.x86_64 (CentOS) 1550825276
:/usr/lib64/libkrb5support.so.0.1 krb5-libs-1.15.1-34.el7.x86_64 (CentOS) 1550825275
:/usr/lib64/libssl.so.1.0.2k openssl-libs-1:1.0.2k-16.el7.x86_64 (CentOS) 1550825275
:/usr/lib64/libpthread-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libfreebl3.so nss-softokn-freebl-3.36.0-5.el7_5.x86_64 (CentOS) 1550825258
:/usr/lib64/libselinux.so.1 libselinux-2.5-14.1.el7.x86_64 (CentOS) 1550825270
:/usr/lib64/libpam.so.0.83.1 pam-1.1.8-22.el7.x86_64 (CentOS) 1550825306
:/usr/lib64/libcom_err.so.2.1 libcom_err-1.42.9-13.el7.x86_64 (CentOS) 1550825269
:/usr/lib64/libplds4.so nspr-4.19.0-1.el7_5.x86_64 (CentOS) 1550825269
:/usr/lib64/libnsl-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libelf-0.172.so elfutils-libelf-0.172-2.el7.x86_64 (CentOS) 1550825276
:/usr/lib64/liblzma.so.5.2.2 xz-libs-5.2.2-1.el7.x86_64 (CentOS) 1550825276
:/usr/lib64/libz.so.1.2.7 zlib-1.2.7-18.el7.x86_64 (CentOS) 1550825269
:/usr/pgsql-11/lib/libpq.so.5.11 postgresql11-libs-11.2-2PGDG.rhel7.x86_64 (PostgreSQL Global Development Group) 1560310269
:/usr/lib64/libnspr4.so nspr-4.19.0-1.el7_5.x86_64 (CentOS) 1550825269
:/usr/lib64/libstdc++.so.6.0.19 libstdc++-4.8.5-36.el7.x86_64 (CentOS) 1550825269
:/usr/lib64/libkeyutils.so.1.5 keyutils-libs-1.5.8-3.el7.x86_64 (CentOS) 1550825270
:/usr/lib64/libk5crypto.so.3.1 krb5-libs-1.15.1-34.el7.x86_64 (CentOS) 1550825275
:/usr/lib64/libnss_files-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libm-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libsasl2.so.3.0.0 cyrus-sasl-lib-2.1.26-23.el7.x86_64 (CentOS) 1550825277
environ:
:''
:''
:''
exploitable:
:Likely crash reason: Write to an invalid address
:Exploitable rating (0-9 scale): 6
:Current instruction: movb   $0x0,0x2d8(%rax)
limits:
:Limit                     Soft Limit           Hard Limit           Units
:Max cpu time              unlimited            unlimited            seconds
:Max file size             unlimited            unlimited            bytes
:Max data size             unlimited            unlimited            bytes
:Max stack size            8388608              unlimited            bytes
:Max core file size        0                    unlimited            bytes
:Max resident set          unlimited            unlimited            bytes
:Max processes             128492               128492               processes
:Max open files            1024                 4096                 files
:Max locked memory         65536                65536                bytes
:Max address space         unlimited            unlimited            bytes
:Max file locks            unlimited            unlimited            locks
:Max pending signals       128492               128492               signals
:Max msgqueue size         819200               819200               bytes
:Max nice priority         0                    0
:Max realtime priority     0                    0
:Max realtime timeout      unlimited            unlimited            us
machineid:
:systemd=06e79615550549e8b156fd87f7ea8be2
:sosreport_uploader-dmidecode=7f639dc6f0478c9673942600b6d1f8af67ecbca9d7b66f1cc182f56231ad50df
maps:
:00400000-00564000 r-xp 00000000 fd:02 1877110                            /usr/pgpool-11/bin/pgpool
:00763000-00764000 r--p 00163000 fd:02 1877110                            /usr/pgpool-11/bin/pgpool
:00764000-0076c000 rw-p 00164000 fd:02 1877110                            /usr/pgpool-11/bin/pgpool
:0076c000-0078e000 rw-p 00000000 00:00 0
:02138000-0217a000 rw-p 00000000 00:00 0                                  [heap]
:0217a000-021d9000 rw-p 00000000 00:00 0                                  [heap]
:7f0c76da8000-7f0c7723a000 rw-p 00000000 00:00 0
:7f0c7723a000-7f0c77249000 r-xp 00000000 fd:02 16874103                   /usr/lib64/libbz2.so.1.0.6
:7f0c77249000-7f0c77448000 ---p 0000f000 fd:02 16874103                   /usr/lib64/libbz2.so.1.0.6
:7f0c77448000-7f0c77449000 r--p 0000e000 fd:02 16874103                   /usr/lib64/libbz2.so.1.0.6
:7f0c77449000-7f0c7744a000 rw-p 0000f000 fd:02 16874103                   /usr/lib64/libbz2.so.1.0.6
:7f0c7744a000-7f0c7746f000 r-xp 00000000 fd:02 16874092                   /usr/lib64/liblzma.so.5.2.2
:7f0c7746f000-7f0c7766e000 ---p 00025000 fd:02 16874092                   /usr/lib64/liblzma.so.5.2.2
:7f0c7766e000-7f0c7766f000 r--p 00024000 fd:02 16874092                   /usr/lib64/liblzma.so.5.2.2
:7f0c7766f000-7f0c77670000 rw-p 00025000 fd:02 16874092                   /usr/lib64/liblzma.so.5.2.2
:7f0c77670000-7f0c77687000 r-xp 00000000 fd:02 16874122                   /usr/lib64/libelf-0.172.so
:7f0c77687000-7f0c77886000 ---p 00017000 fd:02 16874122                   /usr/lib64/libelf-0.172.so
:7f0c77886000-7f0c77887000 r--p 00016000 fd:02 16874122                   /usr/lib64/libelf-0.172.so
:7f0c77887000-7f0c77888000 rw-p 00017000 fd:02 16874122                   /usr/lib64/libelf-0.172.so
:7f0c77888000-7f0c7788c000 r-xp 00000000 fd:02 16823949                   /usr/lib64/libattr.so.1.1.0
:7f0c7788c000-7f0c77a8b000 ---p 00004000 fd:02 16823949                   /usr/lib64/libattr.so.1.1.0
:7f0c77a8b000-7f0c77a8c000 r--p 00003000 fd:02 16823949                   /usr/lib64/libattr.so.1.1.0
:7f0c77a8c000-7f0c77a8d000 rw-p 00004000 fd:02 16823949                   /usr/lib64/libattr.so.1.1.0
:7f0c77a8d000-7f0c77ad9000 r-xp 00000000 fd:02 17545173                   /usr/lib64/libdw-0.172.so
:7f0c77ad9000-7f0c77cd9000 ---p 0004c000 fd:02 17545173                   /usr/lib64/libdw-0.172.so
:7f0c77cd9000-7f0c77cdb000 r--p 0004c000 fd:02 17545173                   /usr/lib64/libdw-0.172.so
:7f0c77cdb000-7f0c77cdc000 rw-p 0004e000 fd:02 17545173                   /usr/lib64/libdw-0.172.so
:7f0c77cdc000-7f0c77ce0000 r-xp 00000000 fd:02 16823953                   /usr/lib64/libcap.so.2.22
:7f0c77ce0000-7f0c77edf000 ---p 00004000 fd:02 16823953                   /usr/lib64/libcap.so.2.22
:7f0c77edf000-7f0c77ee0000 r--p 00003000 fd:02 16823953                   /usr/lib64/libcap.so.2.22
:7f0c77ee0000-7f0c77ee1000 rw-p 00004000 fd:02 16823953                   /usr/lib64/libcap.so.2.22
:7f0c77ee1000-7f0c77ef3000 r-xp 00000000 fd:02 17545175                   /usr/lib64/libnss_myhostname.so.2
:7f0c77ef3000-7f0c780f2000 ---p 00012000 fd:02 17545175                   /usr/lib64/libnss_myhostname.so.2
:7f0c780f2000-7f0c780f5000 r--p 00011000 fd:02 17545175                   /usr/lib64/libnss_myhostname.so.2
:7f0c780f5000-7f0c780f6000 rw-p 00014000 fd:02 17545175                   /usr/lib64/libnss_myhostname.so.2
:7f0c780f6000-7f0c780fb000 r-xp 00000000 fd:02 16823821                   /usr/lib64/libnss_dns-2.17.so
:7f0c780fb000-7f0c782fb000 ---p 00005000 fd:02 16823821                   /usr/lib64/libnss_dns-2.17.so
:7f0c782fb000-7f0c782fc000 r--p 00005000 fd:02 16823821                   /usr/lib64/libnss_dns-2.17.so
:7f0c782fc000-7f0c782fd000 rw-p 00006000 fd:02 16823821                   /usr/lib64/libnss_dns-2.17.so
:7f0c782fd000-7f0c7b2fd000 rw-s 00000000 00:04 1933325                    /SYSV00000000 (deleted)
:7f0c7b2fd000-7f0c7c2fe000 rw-s 00000000 00:04 1900556                    /SYSV00000000 (deleted)
:7f0c7c2fe000-7f0cbc2fe000 rw-s 00000000 00:04 1802249                    /SYSV00000000 (deleted)
:7f0cbc2fe000-7f0cbc30a000 r-xp 00000000 fd:02 16823823                   /usr/lib64/libnss_files-2.17.so
:7f0cbc30a000-7f0cbc509000 ---p 0000c000 fd:02 16823823                   /usr/lib64/libnss_files-2.17.so
:7f0cbc509000-7f0cbc50a000 r--p 0000b000 fd:02 16823823                   /usr/lib64/libnss_files-2.17.so
:7f0cbc50a000-7f0cbc50b000 rw-p 0000c000 fd:02 16823823                   /usr/lib64/libnss_files-2.17.so
:7f0cbc50b000-7f0cbc511000 rw-p 00000000 00:00 0
:7f0cbc511000-7f0cbc571000 r-xp 00000000 fd:02 16823912                   /usr/lib64/libpcre.so.1.2.0
:7f0cbc571000-7f0cbc771000 ---p 00060000 fd:02 16823912                   /usr/lib64/libpcre.so.1.2.0
:7f0cbc771000-7f0cbc772000 r--p 00060000 fd:02 16823912                   /usr/lib64/libpcre.so.1.2.0
:7f0cbc772000-7f0cbc773000 rw-p 00061000 fd:02 16823912                   /usr/lib64/libpcre.so.1.2.0
:7f0cbc773000-7f0cbc77a000 r-xp 00000000 fd:02 16823835                   /usr/lib64/librt-2.17.so
:7f0cbc77a000-7f0cbc979000 ---p 00007000 fd:02 16823835                   /usr/lib64/librt-2.17.so
:7f0cbc979000-7f0cbc97a000 r--p 00006000 fd:02 16823835                   /usr/lib64/librt-2.17.so
:7f0cbc97a000-7f0cbc97b000 rw-p 00007000 fd:02 16823835                   /usr/lib64/librt-2.17.so
:7f0cbc97b000-7f0cbc99f000 r-xp 00000000 fd:02 16823970                   /usr/lib64/libselinux.so.1
:7f0cbc99f000-7f0cbcb9e000 ---p 00024000 fd:02 16823970                   /usr/lib64/libselinux.so.1
:7f0cbcb9e000-7f0cbcb9f000 r--p 00023000 fd:02 16823970                   /usr/lib64/libselinux.so.1
:7f0cbcb9f000-7f0cbcba0000 rw-p 00024000 fd:02 16823970                   /usr/lib64/libselinux.so.1
:7f0cbcba0000-7f0cbcba2000 rw-p 00000000 00:00 0
:7f0cbcba2000-7f0cbcba6000 r-xp 00000000 fd:02 16874085                   /usr/lib64/libcap-ng.so.0.0.0
:7f0cbcba6000-7f0cbcda6000 ---p 00004000 fd:02 16874085                   /usr/lib64/libcap-ng.so.0.0.0
:7f0cbcda6000-7f0cbcda7000 r--p 00004000 fd:02 16874085                   /usr/lib64/libcap-ng.so.0.0.0
:7f0cbcda7000-7f0cbcda8000 rw-p 00005000 fd:02 16874085                   /usr/lib64/libcap-ng.so.0.0.0
:7f0cbcda8000-7f0cbcde2000 r-xp 00000000 fd:02 16823867                   /usr/lib64/libnspr4.so
:7f0cbcde2000-7f0cbcfe1000 ---p 0003a000 fd:02 16823867                   /usr/lib64/libnspr4.so
:7f0cbcfe1000-7f0cbcfe2000 r--p 00039000 fd:02 16823867                   /usr/lib64/libnspr4.so
:7f0cbcfe2000-7f0cbcfe4000 rw-p 0003a000 fd:02 16823867                   /usr/lib64/libnspr4.so
:7f0cbcfe4000-7f0cbcfe6000 rw-p 00000000 00:00 0
:7f0cbcfe6000-7f0cbcfea000 r-xp 00000000 fd:02 16823868                   /usr/lib64/libplc4.so
:7f0cbcfea000-7f0cbd1e9000 ---p 00004000 fd:02 16823868                   /usr/lib64/libplc4.so
:7f0cbd1e9000-7f0cbd1ea000 r--p 00003000 fd:02 16823868                   /usr/lib64/libplc4.so
:7f0cbd1ea000-7f0cbd1eb000 rw-p 00004000 fd:02 16823868                   /usr/lib64/libplc4.so
:7f0cbd1eb000-7f0cbd1ee000 r-xp 00000000 fd:02 16823869                   /usr/lib64/libplds4.so
:7f0cbd1ee000-7f0cbd3ed000 ---p 00003000 fd:02 16823869                   /usr/lib64/libplds4.so
:7f0cbd3ed000-7f0cbd3ee000 r--p 00002000 fd:02 16823869                   /usr/lib64/libplds4.so
:7f0cbd3ee000-7f0cbd3ef000 rw-p 00003000 fd:02 16823869                   /usr/lib64/libplds4.so
:7f0cbd3ef000-7f0cbd417000 r-xp 00000000 fd:02 16823896                   /usr/lib64/libnssutil3.so
:7f0cbd417000-7f0cbd616000 ---p 00028000 fd:02 16823896                   /usr/lib64/libnssutil3.so
:7f0cbd616000-7f0cbd61d000 r--p 00027000 fd:02 16823896                   /usr/lib64/libnssutil3.so
:7f0cbd61d000-7f0cbd61e000 rw-p 0002e000 fd:02 16823896                   /usr/lib64/libnssutil3.so
:7f0cbd61e000-7f0cbd742000 r-xp 00000000 fd:02 16875101                   /usr/lib64/libnss3.so
:7f0cbd742000-7f0cbd942000 ---p 00124000 fd:02 16875101                   /usr/lib64/libnss3.so
:7f0cbd942000-7f0cbd947000 r--p 00124000 fd:02 16875101                   /usr/lib64/libnss3.so
:7f0cbd947000-7f0cbd949000 rw-p 00129000 fd:02 16875101                   /usr/lib64/libnss3.so
:7f0cbd949000-7f0cbd94b000 rw-p 00000000 00:00 0
:7f0cbd94b000-7f0cbd96f000 r-xp 00000000 fd:02 16875102                   /usr/lib64/libsmime3.so
:7f0cbd96f000-7f0cbdb6e000 ---p 00024000 fd:02 16875102                   /usr/lib64/libsmime3.so
:7f0cbdb6e000-7f0cbdb71000 r--p 00023000 fd:02 16875102                   /usr/lib64/libsmime3.so
:7f0cbdb71000-7f0cbdb72000 rw-p 00026000 fd:02 16875102                   /usr/lib64/libsmime3.so
:7f0cbdb72000-7f0cbdbbf000 r-xp 00000000 fd:02 16875103                   /usr/lib64/libssl3.so
:7f0cbdbbf000-7f0cbddbe000 ---p 0004d000 fd:02 16875103                   /usr/lib64/libssl3.so
:7f0cbddbe000-7f0cbddc2000 r--p 0004c000 fd:02 16875103                   /usr/lib64/libssl3.so
:7f0cbddc2000-7f0cbddc3000 rw-p 00050000 fd:02 16875103                   /usr/lib64/libssl3.so
:7f0cbddc3000-7f0cbddc4000 rw-p 00000000 00:00 0
:7f0cbddc4000-7f0cbddd2000 r-xp 00000000 fd:02 17404392                   /usr/lib64/liblber-2.4.so.2.10.7
:7f0cbddd2000-7f0cbdfd1000 ---p 0000e000 fd:02 17404392                   /usr/lib64/liblber-2.4.so.2.10.7
:7f0cbdfd1000-7f0cbdfd2000 r--p 0000d000 fd:02 17404392                   /usr/lib64/liblber-2.4.so.2.10.7
:7f0cbdfd2000-7f0cbdfd3000 rw-p 0000e000 fd:02 17404392                   /usr/lib64/liblber-2.4.so.2.10.7
:7f0cbdfd3000-7f0cbdfd6000 r-xp 00000000 fd:02 16823959                   /usr/lib64/libkeyutils.so.1.5
:7f0cbdfd6000-7f0cbe1d5000 ---p 00003000 fd:02 16823959                   /usr/lib64/libkeyutils.so.1.5
:7f0cbe1d5000-7f0cbe1d6000 r--p 00002000 fd:02 16823959                   /usr/lib64/libkeyutils.so.1.5
:7f0cbe1d6000-7f0cbe1d7000 rw-p 00003000 fd:02 16823959                   /usr/lib64/libkeyutils.so.1.5
:7f0cbe1d7000-7f0cbe1e4000 r-xp 00000000 fd:02 16874055                   /usr/lib64/libkrb5support.so.0.1
:7f0cbe1e4000-7f0cbe3e4000 ---p 0000d000 fd:02 16874055                   /usr/lib64/libkrb5support.so.0.1
:7f0cbe3e4000-7f0cbe3e5000 r--p 0000d000 fd:02 16874055                   /usr/lib64/libkrb5support.so.0.1
:7f0cbe3e5000-7f0cbe3e6000 rw-p 0000e000 fd:02 16874055                   /usr/lib64/libkrb5support.so.0.1
:7f0cbe3e6000-7f0cbe3e8000 r-xp 00000000 fd:02 16818345                   /usr/lib64/libfreebl3.so
:7f0cbe3e8000-7f0cbe5e7000 ---p 00002000 fd:02 16818345                   /usr/lib64/libfreebl3.so
:7f0cbe5e7000-7f0cbe5e8000 r--p 00001000 fd:02 16818345                   /usr/lib64/libfreebl3.so
:7f0cbe5e8000-7f0cbe5e9000 rw-p 00002000 fd:02 16818345                   /usr/lib64/libfreebl3.so
:7f0cbe5e9000-7f0cbe5fe000 r-xp 00000000 fd:02 16823850                   /usr/lib64/libz.so.1.2.7
:7f0cbe5fe000-7f0cbe7fd000 ---p 00015000 fd:02 16823850                   /usr/lib64/libz.so.1.2.7
:7f0cbe7fd000-7f0cbe7fe000 r--p 00014000 fd:02 16823850                   /usr/lib64/libz.so.1.2.7
:7f0cbe7fe000-7f0cbe7ff000 rw-p 00015000 fd:02 16823850                   /usr/lib64/libz.so.1.2.7
:7f0cbe7ff000-7f0cbe818000 r-xp 00000000 fd:02 16824063                   /usr/lib64/libk5crypto.so.3.1
:7f0cbe818000-7f0cbea17000 ---p 00019000 fd:02 16824063                   /usr/lib64/libk5crypto.so.3.1
:7f0cbea17000-7f0cbea19000 r--p 00018000 fd:02 16824063                   /usr/lib64/libk5crypto.so.3.1
:7f0cbea19000-7f0cbea1a000 rw-p 0001a000 fd:02 16824063                   /usr/lib64/libk5crypto.so.3.1
:7f0cbea1a000-7f0cbea1d000 r-xp 00000000 fd:02 16823866                   /usr/lib64/libcom_err.so.2.1
:7f0cbea1d000-7f0cbec1c000 ---p 00003000 fd:02 16823866                   /usr/lib64/libcom_err.so.2.1
:7f0cbec1c000-7f0cbec1d000 r--p 00002000 fd:02 16823866                   /usr/lib64/libcom_err.so.2.1
:7f0cbec1d000-7f0cbec1e000 rw-p 00003000 fd:02 16823866                   /usr/lib64/libcom_err.so.2.1
:7f0cbec1e000-7f0cbecf7000 r-xp 00000000 fd:02 16874053                   /usr/lib64/libkrb5.so.3.3
:7f0cbecf7000-7f0cbeef6000 ---p 000d9000 fd:02 16874053                   /usr/lib64/libkrb5.so.3.3
:7f0cbeef6000-7f0cbef04000 r--p 000d8000 fd:02 16874053                   /usr/lib64/libkrb5.so.3.3
:7f0cbef04000-7f0cbef07000 rw-p 000e6000 fd:02 16874053                   /usr/lib64/libkrb5.so.3.3
:7f0cbef07000-7f0cbef25000 r-xp 00000000 fd:02 16874087                   /usr/lib64/libaudit.so.1.0.0
:7f0cbef25000-7f0cbf124000 ---p 0001e000 fd:02 16874087                   /usr/lib64/libaudit.so.1.0.0
:7f0cbf124000-7f0cbf125000 r--p 0001d000 fd:02 16874087                   /usr/lib64/libaudit.so.1.0.0
:7f0cbf125000-7f0cbf126000 rw-p 0001e000 fd:02 16874087                   /usr/lib64/libaudit.so.1.0.0
:7f0cbf126000-7f0cbf130000 rw-p 00000000 00:00 0
:7f0cbf130000-7f0cbf145000 r-xp 00000000 fd:02 16777283                   /usr/lib64/libgcc_s-4.8.5-20150702.so.1
:7f0cbf145000-7f0cbf344000 ---p 00015000 fd:02 16777283                   /usr/lib64/libgcc_s-4.8.5-20150702.so.1
:7f0cbf344000-7f0cbf345000 r--p 00014000 fd:02 16777283                   /usr/lib64/libgcc_s-4.8.5-20150702.so.1
:7f0cbf345000-7f0cbf346000 rw-p 00015000 fd:02 16777283                   /usr/lib64/libgcc_s-4.8.5-20150702.so.1
:7f0cbf346000-7f0cbf42f000 r-xp 00000000 fd:02 16823856                   /usr/lib64/libstdc++.so.6.0.19
:7f0cbf42f000-7f0cbf62e000 ---p 000e9000 fd:02 16823856                   /usr/lib64/libstdc++.so.6.0.19
:7f0cbf62e000-7f0cbf636000 r--p 000e8000 fd:02 16823856                   /usr/lib64/libstdc++.so.6.0.19
:7f0cbf636000-7f0cbf638000 rw-p 000f0000 fd:02 16823856                   /usr/lib64/libstdc++.so.6.0.19
:7f0cbf638000-7f0cbf64d000 rw-p 00000000 00:00 0
:7f0cbf64d000-7f0cbf669000 r-xp 00000000 fd:02 16874148                   /usr/lib64/libsasl2.so.3.0.0
:7f0cbf669000-7f0cbf868000 ---p 0001c000 fd:02 16874148                   /usr/lib64/libsasl2.so.3.0.0
:7f0cbf868000-7f0cbf869000 r--p 0001b000 fd:02 16874148                   /usr/lib64/libsasl2.so.3.0.0
:7f0cbf869000-7f0cbf86a000 rw-p 0001c000 fd:02 16874148                   /usr/lib64/libsasl2.so.3.0.0
:7f0cbf86a000-7f0cbf86c000 r-xp 00000000 fd:02 16823811                   /usr/lib64/libdl-2.17.so
:7f0cbf86c000-7f0cbfa6c000 ---p 00002000 fd:02 16823811                   /usr/lib64/libdl-2.17.so
:7f0cbfa6c000-7f0cbfa6d000 r--p 00002000 fd:02 16823811                   /usr/lib64/libdl-2.17.so
:7f0cbfa6d000-7f0cbfa6e000 rw-p 00003000 fd:02 16823811                   /usr/lib64/libdl-2.17.so
:7f0cbfa6e000-7f0cbfac7000 r-xp 00000000 fd:02 17404396                   /usr/lib64/libldap_r-2.4.so.2.10.7
:7f0cbfac7000-7f0cbfcc7000 ---p 00059000 fd:02 17404396                   /usr/lib64/libldap_r-2.4.so.2.10.7
:7f0cbfcc7000-7f0cbfcc9000 r--p 00059000 fd:02 17404396                   /usr/lib64/libldap_r-2.4.so.2.10.7
:7f0cbfcc9000-7f0cbfcca000 rw-p 0005b000 fd:02 17404396                   /usr/lib64/libldap_r-2.4.so.2.10.7
:7f0cbfcca000-7f0cbfccd000 rw-p 00000000 00:00 0
:7f0cbfccd000-7f0cbfd17000 r-xp 00000000 fd:02 16824059                   /usr/lib64/libgssapi_krb5.so.2.2
:7f0cbfd17000-7f0cbff17000 ---p 0004a000 fd:02 16824059                   /usr/lib64/libgssapi_krb5.so.2.2
:7f0cbff17000-7f0cbff18000 r--p 0004a000 fd:02 16824059                   /usr/lib64/libgssapi_krb5.so.2.2
:7f0cbff18000-7f0cbff1a000 rw-p 0004b000 fd:02 16824059                   /usr/lib64/libgssapi_krb5.so.2.2
:7f0cbff1a000-7f0cc00dc000 r-xp 00000000 fd:02 16818973                   /usr/lib64/libc-2.17.so
:7f0cc00dc000-7f0cc02dc000 ---p 001c2000 fd:02 16818973                   /usr/lib64/libc-2.17.so
:7f0cc02dc000-7f0cc02e0000 r--p 001c2000 fd:02 16818973                   /usr/lib64/libc-2.17.so
:7f0cc02e0000-7f0cc02e2000 rw-p 001c6000 fd:02 16818973                   /usr/lib64/libc-2.17.so
:7f0cc02e2000-7f0cc02e7000 rw-p 00000000 00:00 0
:7f0cc02e7000-7f0cc03e8000 r-xp 00000000 fd:02 16823813                   /usr/lib64/libm-2.17.so
:7f0cc03e8000-7f0cc05e7000 ---p 00101000 fd:02 16823813                   /usr/lib64/libm-2.17.so
:7f0cc05e7000-7f0cc05e8000 r--p 00100000 fd:02 16823813                   /usr/lib64/libm-2.17.so
:7f0cc05e8000-7f0cc05e9000 rw-p 00101000 fd:02 16823813                   /usr/lib64/libm-2.17.so
:7f0cc05e9000-7f0cc05ff000 r-xp 00000000 fd:02 16823815                   /usr/lib64/libnsl-2.17.so
:7f0cc05ff000-7f0cc07ff000 ---p 00016000 fd:02 16823815                   /usr/lib64/libnsl-2.17.so
:7f0cc07ff000-7f0cc0800000 r--p 00016000 fd:02 16823815                   /usr/lib64/libnsl-2.17.so
:7f0cc0800000-7f0cc0801000 rw-p 00017000 fd:02 16823815                   /usr/lib64/libnsl-2.17.so
:7f0cc0801000-7f0cc0803000 rw-p 00000000 00:00 0
:7f0cc0803000-7f0cc0819000 r-xp 00000000 fd:02 16823833                   /usr/lib64/libresolv-2.17.so
:7f0cc0819000-7f0cc0a18000 ---p 00016000 fd:02 16823833                   /usr/lib64/libresolv-2.17.so
:7f0cc0a18000-7f0cc0a19000 r--p 00015000 fd:02 16823833                   /usr/lib64/libresolv-2.17.so
:7f0cc0a19000-7f0cc0a1a000 rw-p 00016000 fd:02 16823833                   /usr/lib64/libresolv-2.17.so
:7f0cc0a1a000-7f0cc0a1c000 rw-p 00000000 00:00 0
:7f0cc0a1c000-7f0cc0a24000 r-xp 00000000 fd:02 16823809                   /usr/lib64/libcrypt-2.17.so
:7f0cc0a24000-7f0cc0c23000 ---p 00008000 fd:02 16823809                   /usr/lib64/libcrypt-2.17.so
:7f0cc0c23000-7f0cc0c24000 r--p 00007000 fd:02 16823809                   /usr/lib64/libcrypt-2.17.so
:7f0cc0c24000-7f0cc0c25000 rw-p 00008000 fd:02 16823809                   /usr/lib64/libcrypt-2.17.so
:7f0cc0c25000-7f0cc0c53000 rw-p 00000000 00:00 0
:7f0cc0c53000-7f0cc0e87000 r-xp 00000000 fd:02 16874067                   /usr/lib64/libcrypto.so.1.0.2k
:7f0cc0e87000-7f0cc1087000 ---p 00234000 fd:02 16874067                   /usr/lib64/libcrypto.so.1.0.2k
:7f0cc1087000-7f0cc10a3000 r--p 00234000 fd:02 16874067                   /usr/lib64/libcrypto.so.1.0.2k
:7f0cc10a3000-7f0cc10b0000 rw-p 00250000 fd:02 16874067                   /usr/lib64/libcrypto.so.1.0.2k
:7f0cc10b0000-7f0cc10b4000 rw-p 00000000 00:00 0
:7f0cc10b4000-7f0cc111b000 r-xp 00000000 fd:02 16874069                   /usr/lib64/libssl.so.1.0.2k
:7f0cc111b000-7f0cc131b000 ---p 00067000 fd:02 16874069                   /usr/lib64/libssl.so.1.0.2k
:7f0cc131b000-7f0cc131f000 r--p 00067000 fd:02 16874069                   /usr/lib64/libssl.so.1.0.2k
:7f0cc131f000-7f0cc1326000 rw-p 0006b000 fd:02 16874069                   /usr/lib64/libssl.so.1.0.2k
:7f0cc1326000-7f0cc1333000 r-xp 00000000 fd:02 16910166                   /usr/lib64/libpam.so.0.83.1
:7f0cc1333000-7f0cc1533000 ---p 0000d000 fd:02 16910166                   /usr/lib64/libpam.so.0.83.1
:7f0cc1533000-7f0cc1534000 r--p 0000d000 fd:02 16910166                   /usr/lib64/libpam.so.0.83.1
:7f0cc1534000-7f0cc1535000 rw-p 0000e000 fd:02 16910166                   /usr/lib64/libpam.so.0.83.1
:7f0cc1535000-7f0cc1565000 r-xp 00000000 fd:02 19110499                   /usr/lib64/libmemcached.so.11.0.0
:7f0cc1565000-7f0cc1765000 ---p 00030000 fd:02 19110499                   /usr/lib64/libmemcached.so.11.0.0
:7f0cc1765000-7f0cc1766000 r--p 00030000 fd:02 19110499                   /usr/lib64/libmemcached.so.11.0.0
:7f0cc1766000-7f0cc1767000 rw-p 00031000 fd:02 19110499                   /usr/lib64/libmemcached.so.11.0.0
:7f0cc1767000-7f0cc177e000 r-xp 00000000 fd:02 16823831                   /usr/lib64/libpthread-2.17.so
:7f0cc177e000-7f0cc197d000 ---p 00017000 fd:02 16823831                   /usr/lib64/libpthread-2.17.so
:7f0cc197d000-7f0cc197e000 r--p 00016000 fd:02 16823831                   /usr/lib64/libpthread-2.17.so
:7f0cc197e000-7f0cc197f000 rw-p 00017000 fd:02 16823831                   /usr/lib64/libpthread-2.17.so
:7f0cc197f000-7f0cc1983000 rw-p 00000000 00:00 0
:7f0cc1983000-7f0cc19c9000 r-xp 00000000 fd:02 18074429                   /usr/pgsql-11/lib/libpq.so.5.11
:7f0cc19c9000-7f0cc1bc8000 ---p 00046000 fd:02 18074429                   /usr/pgsql-11/lib/libpq.so.5.11
:7f0cc1bc8000-7f0cc1bcb000 r--p 00045000 fd:02 18074429                   /usr/pgsql-11/lib/libpq.so.5.11
:7f0cc1bcb000-7f0cc1bcc000 rw-p 00048000 fd:02 18074429                   /usr/pgsql-11/lib/libpq.so.5.11
:7f0cc1bcc000-7f0cc1bee000 r-xp 00000000 fd:02 16818966                   /usr/lib64/ld-2.17.so
:7f0cc1c56000-7f0cc1d5b000 rw-p 00000000 00:00 0
:7f0cc1d5b000-7f0cc1d5d000 rw-s 00000000 00:04 1998863                    /SYSV00000000 (deleted)
:7f0cc1d5d000-7f0cc1da1000 rw-s 00000000 00:04 1638404                    /SYSV00000000 (deleted)
:7f0cc1da1000-7f0cc1dd6000 rw-p 00000000 00:00 0
:7f0cc1dd6000-7f0cc1dd7000 rw-s 00000000 00:04 1966094                    /SYSV00000000 (deleted)
:7f0cc1dd7000-7f0cc1dd8000 rw-s 00000000 00:04 1867787                    /SYSV00000000 (deleted)
:7f0cc1dd8000-7f0cc1dd9000 rw-s 00000000 00:04 1835018                    /SYSV00000000 (deleted)
:7f0cc1dd9000-7f0cc1dda000 rw-s 00000000 00:04 1769480                    /SYSV00000000 (deleted)
:7f0cc1dda000-7f0cc1ddc000 rw-s 00000000 00:04 1736711                    /SYSV00000000 (deleted)
:7f0cc1ddc000-7f0cc1ddd000 rw-s 00000000 00:04 1703942                    /SYSV00000000 (deleted)
:7f0cc1ddd000-7f0cc1dde000 rw-s 00000000 00:04 1671173                    /SYSV00000000 (deleted)
:7f0cc1dde000-7f0cc1dec000 rw-s 00000000 00:04 1605635                    /SYSV00000000 (deleted)
:7f0cc1dec000-7f0cc1ded000 rw-p 00000000 00:00 0
:7f0cc1ded000-7f0cc1dee000 r--p 00021000 fd:02 16818966                   /usr/lib64/ld-2.17.so
:7f0cc1dee000-7f0cc1def000 rw-p 00022000 fd:02 16818966                   /usr/lib64/ld-2.17.so
:7f0cc1def000-7f0cc1df0000 rw-p 00000000 00:00 0
:7ffeae42b000-7ffeae44c000 rw-p 00000000 00:00 0                          [stack]
:7ffeae5d2000-7ffeae5d4000 r-xp 00000000 00:00 0                          [vdso]
:ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0                  [vsyscall]
open_fds:
:0:/dev/null
:pos:   0
:flags: 0100000
:mnt_id:        20
:1:socket:[52049]
:pos:   0
:flags: 02
:mnt_id:        7
:2:socket:[52049]
:pos:   0
:flags: 02
:mnt_id:        7
:3:/etc/pgpool-II-11/pool_passwd
:pos:   132
:flags: 0100000
:mnt_id:        40
:4:socket:[63509]
:pos:   0
:flags: 02000002
:mnt_id:        7
:5:socket:[49059]
:pos:   0
:flags: 04002
:mnt_id:        7
:6:socket:[49063]
:pos:   0
:flags: 04002
:mnt_id:        7
:7:socket:[49064]
:pos:   0
:flags: 04002
:mnt_id:        7
:8:socket:[60301]
:pos:   0
:flags: 02
:mnt_id:        7
:9:socket:[71916]
:pos:   0
:flags: 02
:mnt_id:        7
:10:socket:[71917]
:pos:   0
:flags: 02
:mnt_id:        7
os_info:
:NAME="CentOS Linux"
:VERSION="7 (Core)"
:ID="centos"
:ID_LIKE="rhel fedora"
:VERSION_ID="7"
:PRETTY_NAME="CentOS Linux 7 (Core)"
:ANSI_COLOR="0;31"
:CPE_NAME="cpe:/o:centos:centos:7"
:HOME_URL="https://www.centos.org/"
:BUG_REPORT_URL="https://bugs.centos.org/"
:
:CENTOS_MANTISBT_PROJECT="CentOS-7"
:CENTOS_MANTISBT_PROJECT_VERSION="7"
:REDHAT_SUPPORT_PRODUCT="centos"
:REDHAT_SUPPORT_PRODUCT_VERSION="7"
:
proc_pid_status:
:Name:  pgpool
:Umask: 0022
:State: S (sleeping)
:Tgid:  11117
:Ngid:  0
:Pid:   11117
:PPid:  11108
:TracerPid:     0
:Uid:   5432    5432    5432    5432
:Gid:   5432    5432    5432    5432
:FDSize:        64
:Groups:        5432
:VmPeak:         1231052 kB
:VmSize:         1231052 kB
:VmLck:        0 kB
:VmPin:        0 kB
:VmHWM:     9832 kB
:VmRSS:     9832 kB
:RssAnon:           7464 kB
:RssFile:           2184 kB
:RssShmem:           184 kB
:VmData:            7172 kB
:VmStk:      132 kB
:VmExe:     1424 kB
:VmLib:    12944 kB
:VmPTE:      272 kB
:VmSwap:               0 kB
:Threads:       1
:SigQ:  0/128492
:SigPnd:        0000000000000000
:ShdPnd:        0000000000000000
:SigBlk:        0000000000000000
:SigIgn:        0000000000003000
:SigCgt:        0000000180004a07
:CapInh:        0000000000000000
:CapPrm:        0000000000000000
:CapEff:        0000000000000000
:CapBnd:        0000001fffffffff
:CapAmb:        0000000000000000
:Seccomp:       0
:Speculation_Store_Bypass:      vulnerable
:Cpus_allowed:  ffffffff,ffffffff,ffffffff,ffffffff
:Cpus_allowed_list:     0-127
:Mems_allowed:  00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
:Mems_allowed_list:     0
:voluntary_ctxt_switches:       1243
:nonvoluntary_ctxt_switches:    0
var_log_messages:
:[System Logs]:
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2455-1] 2019-06-25 16:34:17: pid 11117: LOG:  Sync message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2456-1] 2019-06-25 16:34:17: pid 11117: LOG:  Parse message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2456-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  statement: "", query: "SELECT 'x'"
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2457-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: Parse: SELECT 'x'
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2458-1] 2019-06-25 16:34:17: pid 11117: LOG:  Bind message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2458-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: "", statement: ""
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2459-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: B message
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2460-1] 2019-06-25 16:34:17: pid 11117: LOG:  Describe message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2460-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: ""
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2461-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: D message
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2462-1] 2019-06-25 16:34:17: pid 11117: LOG:  Execute message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2462-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: ""
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2463-1] 2019-06-25 16:34:17: pid 11117: LOG:  fetch from memory cache
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2463-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  query result fetched from cache. statement: SELECT 'x' 000000000000
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2464-1] 2019-06-25 16:34:17: pid 11117: LOG:  Sync message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2465-1] 2019-06-25 16:34:17: pid 11117: LOG:  Parse message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2465-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  statement: "", query: "BEGIN"
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2466-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: Parse: BEGIN
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2467-1] 2019-06-25 16:34:17: pid 11117: LOG:  Bind message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2467-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: "", statement: ""
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2468-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: B message
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2469-1] 2019-06-25 16:34:17: pid 11117: LOG:  Execute message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2469-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: ""
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2470-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: Execute: BEGIN
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2471-1] 2019-06-25 16:34:17: pid 11117: LOG:  Parse message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2471-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  statement: "", query: "select aa10a1po0_.AAA100 as col_0_0_, aa10a1po0_.AAA101 as col_1_0_, aa10a1po0_.AAA102 as col_2_0_, aa10a1po0_.AAA103 as col_3_0_, aa10a1po0_.YAB003 as col_4_0_, aa10a1po0_.AAE120 as col_5_0_, aa10a1po0_.VER as col_6_0_ from AA10A1 aa10a1po0_ where aa10a1po0_.AAE120=$1 and aa10a1po0_.YAB003=$2 order by aa10a1po0_.AAA100, aa10a1po0_.AAA102":Jun 25 16:34:17 pgsql1 pgpool[11117]: [2472-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: Parse: select aa10a1po0_.AAA100 as col_0_0_, aa10a1po0_.AAA101 as col_1_0_, aa10a1po0_.AAA102 as col_2_0_, aa10a1po0_.AAA103 as col_3_0_, aa10a1po0_.YAB003 as col_4_0_, aa10a1po0_.AAE120 as col_5_0_, aa10a1po0_.VER as col_6_0_ from AA10A1 aa10a1po0_ where aa10a1po0_.AAE120=$1 and aa10a1po0_.YAB003=$2 order by aa10a1po0_.AAA100, aa10a1po0_.AAA102
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2473-1] 2019-06-25 16:34:17: pid 11117: LOG:  Bind message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2473-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: "C_5", statement: ""
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2474-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: B message
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2475-1] 2019-06-25 16:34:17: pid 11117: LOG:  Describe message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2475-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: "C_5"
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2476-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: D message
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2477-1] 2019-06-25 16:34:17: pid 11117: LOG:  Execute message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2477-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: "C_5"
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2478-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: Execute: select aa10a1po0_.AAA100 as col_0_0_, aa10a1po0_.AAA101 as col_1_0_, aa10a1po0_.AAA102 as col_2_0_, aa10a1po0_.AAA103 as col_3_0_, aa10a1po0_.YAB003 as col_4_0_, aa10a1po0_.AAE120 as col_5_0_, aa10a1po0_.VER as col_6_0_ from AA10A1 aa10a1po0_ where aa10a1po0_.AAE120=$1 and aa10a1po0_.YAB003=$2 order by aa10a1po0_.AAA100, aa10a1po0_.AAA102
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2479-1] 2019-06-25 16:34:17: pid 11117: LOG:  Sync message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2480-1] 2019-06-25 16:34:17: pid 11117: LOG:  checking zapping sent message: 0x216d078 query_context: 0x2177c68
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2481-1] 2019-06-25 16:34:17: pid 11117: LOG:  checking zapping sent message: 0x216d080 query_context: 0x2172c48
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2482-1] 2019-06-25 16:34:17: pid 11117: LOG:  checking zapping sent message: 0x216d088 query_context: 0x217ac88
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2483-1] 2019-06-25 16:34:17: pid 11117: LOG:  Zap sent message: 0x216d088
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2484-1] 2019-06-25 16:34:17: pid 11117: LOG:  checking zapping sent message: 0x216d090 query_context: 0x21791f8
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2485-1] 2019-06-25 16:34:17: pid 11117: LOG:  checking zapping sent message: 0x216d098 query_context: 0x21791f8
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2486-1] 2019-06-25 16:34:17: pid 11117: LOG:  Execute message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2486-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: "C_5"
:Jun 25 16:34:17 pgsql1 kernel: pgpool[11117]: segfault at 2d8 ip 000000000043a9c8 sp 00007ffeae43ce70 error 6 in pgpool[400000+164000]
:Jun 25 16:34:17 pgsql1 abrt-hook-ccpp[12165]: Process 11117 (pgpool) of user 5432 killed by SIGSEGV - dumping core
:Jun 25 16:34:23 pgsql1 pgpool[11108]: [16-1] 2019-06-25 16:34:23: pid 11108: WARNING:  child process with pid: 11117 was terminated by segmentation fault
:Jun 25 16:34:23 pgsql1 pgpool[11108]: [17-1] 2019-06-25 16:34:23: pid 11108: LOG:  fork a new child process with pid: 12168
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [17-1] 2019-06-25 16:34:23: pid 12168: LOG:  new connection received
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [17-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  connecting host=192.168.25.111 port=61627
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [18-1] 2019-06-25 16:34:23: pid 12168: LOG:  md5 authentication successful with frontend
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [19-1] 2019-06-25 16:34:23: pid 12168: LOG:  Parse message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [19-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  statement: "", query: "SET extra_float_digits = 3"
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [20-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: Parse: SET extra_float_digits = 3
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [21-1] 2019-06-25 16:34:23: pid 12168: LOG:  Bind message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [21-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: "", statement: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [22-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: B message
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [23-1] 2019-06-25 16:34:23: pid 12168: LOG:  Execute message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [23-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [24-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: Execute: SET extra_float_digits = 3
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [25-1] 2019-06-25 16:34:23: pid 12168: LOG:  Sync message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [26-1] 2019-06-25 16:34:23: pid 12168: LOG:  Parse message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [26-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  statement: "", query: "SET application_name = 'PostgreSQL JDBC Driver'"
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [27-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: Parse: SET application_na
me = 'PostgreSQL JDBC Driver'
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [28-1] 2019-06-25 16:34:23: pid 12168: LOG:  Bind message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [28-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: "", statement: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [29-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: B message
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [30-1] 2019-06-25 16:34:23: pid 12168: LOG:  Execute message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [30-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [31-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: Execute: SET application_name = 'PostgreSQL JDBC Driver'
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [32-1] 2019-06-25 16:34:23: pid 12168: LOG:  Sync message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [33-1] 2019-06-25 16:34:23: pid 12168: LOG:  Parse message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [33-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  statement: "", query: "SELECT 'x'"
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [34-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: Parse: SELECT 'x'
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [35-1] 2019-06-25 16:34:23: pid 12168: LOG:  Bind message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [35-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: "", statement: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [36-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: B message
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [37-1] 2019-06-25 16:34:23: pid 12168: LOG:  Describe message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [37-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [38-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: D message
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [39-1] 2019-06-25 16:34:23: pid 12168: LOG:  Execute message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [39-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [40-1] 2019-06-25 16:34:23: pid 12168: LOG:  fetch from memory cache
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [40-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  query result fetched from cache. statement: SELECT 'x' 000000000000
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [41-1] 2019-06-25 16:34:23: pid 12168: LOG:  Sync message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [42-1] 2019-06-25 16:34:23: pid 12168: LOG:  Parse message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [42-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  statement: "", query: "SHOW TRANSACTION ISOLATION LEVEL"
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [43-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: Parse: SHOW TRANSACTION ISOLATION LEVEL
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [44-1] 2019-06-25 16:34:23: pid 12168: LOG:  Bind message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [44-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: "", statement: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [45-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: B message
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [46-1] 2019-06-25 16:34:23: pid 12168: LOG:  Describe message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [46-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [47-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: D message
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [48-1] 2019-06-25 16:34:23: pid 12168: LOG:  Execute message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [48-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [49-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: Execute: SHOW TRANSACTION ISOLATION LEVEL
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [50-1] 2019-06-25 16:34:23: pid 12168: LOG:  Sync message from frontend.:[User Logs]:
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2454-1] 2019-06-25 16:34:17: pid 11117: LOG:  fetch from memory cache
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2454-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  query result fetched from cache. statement: SELECT 'x' 000000000000
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2455-1] 2019-06-25 16:34:17: pid 11117: LOG:  Sync message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2456-1] 2019-06-25 16:34:17: pid 11117: LOG:  Parse message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2456-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  statement: "", query: "SELECT 'x'"
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2457-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: Parse: SELECT 'x'
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2458-1] 2019-06-25 16:34:17: pid 11117: LOG:  Bind message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2458-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: "", statement: ""
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2459-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: B message
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2460-1] 2019-06-25 16:34:17: pid 11117: LOG:  Describe message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2460-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: ""
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2461-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: D message
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2462-1] 2019-06-25 16:34:17: pid 11117: LOG:  Execute message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2462-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: ""
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2463-1] 2019-06-25 16:34:17: pid 11117: LOG:  fetch from memory cache
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2463-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  query result fetched from cache. statement: SELECT 'x' 000000000000
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2464-1] 2019-06-25 16:34:17: pid 11117: LOG:  Sync message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2465-1] 2019-06-25 16:34:17: pid 11117: LOG:  Parse message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2465-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  statement: "", query: "BEGIN"
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2466-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: Parse: BEGIN
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2467-1] 2019-06-25 16:34:17: pid 11117: LOG:  Bind message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2467-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: "", statement: ""
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2468-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: B message
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2469-1] 2019-06-25 16:34:17: pid 11117: LOG:  Execute message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2469-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: ""
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2470-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: Execute: BEGIN
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2471-1] 2019-06-25 16:34:17: pid 11117: LOG:  Parse message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2471-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  statement: "", query: "select aa10a1po0_.AAA100 as col_0_0_, aa10a1po0_.AAA101 as col_1_0_, aa10a1po0_.AAA102 as col_2_0_, aa10a1po0_.AAA103 as col_3_0_, aa10a1po0_.YAB003 as col_4_0_, aa10a1po0_.AAE120 as col_5_0_, a
a10a1po0_.VER as col_6_0_ from AA10A1 aa10a1po0_ where aa10a1po0_.AAE120=$1 and aa10a1po0_.YAB003=$2 order by aa10a1po0_.AAA100, aa10a1po0_.AAA102":Jun 25 16:34:17 pgsql1 pgpool[11117]: [2472-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: Parse: select aa10a1po0
_.AAA100 as col_0_0_, aa10a1po0_.AAA101 as col_1_0_, aa10a1po0_.AAA102 as col_2_0_, aa10a1po0_.AAA103 as col_3_0_, aa10a1po0_.YAB003 as col_4_0_, aa10a1po0_.AAE120 as col_5_0_, aa10a1po0_.VER as col_6_0_ from AA10A1 aa10a1po0_ where aa10a1po0_.AAE120=$1 and aa10a1po0_.YAB003=$2 order by aa10a1po0_.AAA100,
 aa10a1po0_.AAA102
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2473-1] 2019-06-25 16:34:17: pid 11117: LOG:  Bind message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2473-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: "C_5", statement: ""
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2474-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: B message
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2475-1] 2019-06-25 16:34:17: pid 11117: LOG:  Describe message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2475-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: "C_5"
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2476-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: D message
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2477-1] 2019-06-25 16:34:17: pid 11117: LOG:  Execute message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2477-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: "C_5"
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2478-1] 2019-06-25 16:34:17: pid 11117: LOG:  DB node id: 0 backend pid: 12146 statement: Execute: select aa10a1po0_.AAA100 as col_0_0_, aa10a1po0_.AAA101 as col_1_0_, aa10a1po0_.AAA102 as col_2_0_, aa10a1po0_.AAA103 as col_3_0_, aa10a1po0_.YAB003 as col_4_0_, aa10a1po0_.AAE120 as col_5_0_, aa10a1po0_.VER as col_6_0_ from AA10A1 aa10a1po0_ where aa10a1po0_.AAE120=$1 and aa10a1po0_.YAB003=$2 order by aa10a1po0_.AAA100, aa10a1po0_.AAA102
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2479-1] 2019-06-25 16:34:17: pid 11117: LOG:  Sync message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2480-1] 2019-06-25 16:34:17: pid 11117: LOG:  checking zapping sent message: 0x216d078 query_context: 0x2177c68
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2481-1] 2019-06-25 16:34:17: pid 11117: LOG:  checking zapping sent message: 0x216d080 query_context: 0x2172c48
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2482-1] 2019-06-25 16:34:17: pid 11117: LOG:  checking zapping sent message: 0x216d088 query_context: 0x217ac88
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2483-1] 2019-06-25 16:34:17: pid 11117: LOG:  Zap sent message: 0x216d088
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2484-1] 2019-06-25 16:34:17: pid 11117: LOG:  checking zapping sent message: 0x216d090 query_context: 0x21791f8
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2485-1] 2019-06-25 16:34:17: pid 11117: LOG:  checking zapping sent message: 0x216d098 query_context: 0x21791f8
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2486-1] 2019-06-25 16:34:17: pid 11117: LOG:  Execute message from frontend.
:Jun 25 16:34:17 pgsql1 pgpool[11117]: [2486-2] 2019-06-25 16:34:17: pid 11117: DETAIL:  portal: "C_5"
:Jun 25 16:34:23 pgsql1 pgpool[11108]: [16-1] 2019-06-25 16:34:23: pid 11108: WARNING:  child process with pid: 11117 was terminated by segmentation fault
:Jun 25 16:34:23 pgsql1 pgpool[11108]: [17-1] 2019-06-25 16:34:23: pid 11108: LOG:  fork a new child process with pid: 12168
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [17-1] 2019-06-25 16:34:23: pid 12168: LOG:  new connection received
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [17-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  connecting host=192.168.25.111 port=61627
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [18-1] 2019-06-25 16:34:23: pid 12168: LOG:  md5 authentication successful with frontend
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [19-1] 2019-06-25 16:34:23: pid 12168: LOG:  Parse message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [19-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  statement: "", query: "SET extra_float_digits = 3"
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [20-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: Parse: SET extra_float_digits = 3
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [21-1] 2019-06-25 16:34:23: pid 12168: LOG:  Bind message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [21-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: "", statement: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [22-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: B message
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [23-1] 2019-06-25 16:34:23: pid 12168: LOG:  Execute message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [23-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [24-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: Execute: SET extra_float_digits = 3
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [25-1] 2019-06-25 16:34:23: pid 12168: LOG:  Sync message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [26-1] 2019-06-25 16:34:23: pid 12168: LOG:  Parse message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [26-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  statement: "", query: "SET application_name = 'PostgreSQL JDBC Driver'"
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [27-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: Parse: SET application_name = 'PostgreSQL JDBC Driver'
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [28-1] 2019-06-25 16:34:23: pid 12168: LOG:  Bind message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [28-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: "", statement: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [29-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: B message
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [30-1] 2019-06-25 16:34:23: pid 12168: LOG:  Execute message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [30-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [31-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: Execute: SET application_name = 'PostgreSQL JDBC Driver'
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [32-1] 2019-06-25 16:34:23: pid 12168: LOG:  Sync message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [33-1] 2019-06-25 16:34:23: pid 12168: LOG:  Parse message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [33-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  statement: "", query: "SELECT 'x'"
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [34-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: Parse: SELECT 'x'
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [35-1] 2019-06-25 16:34:23: pid 12168: LOG:  Bind message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [35-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: "", statement: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [36-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: B message
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [37-1] 2019-06-25 16:34:23: pid 12168: LOG:  Describe message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [37-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [38-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: D message
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [39-1] 2019-06-25 16:34:23: pid 12168: LOG:  Execute message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [39-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [40-1] 2019-06-25 16:34:23: pid 12168: LOG:  fetch from memory cache
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [40-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  query result fetched from cache. statement: SELECT 'x' 000000000000
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [41-1] 2019-06-25 16:34:23: pid 12168: LOG:  Sync message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [42-1] 2019-06-25 16:34:23: pid 12168: LOG:  Parse message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [42-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  statement: "", query: "SHOW TRANSACTION ISOLATION LEVEL"
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [43-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: Parse: SHOW TRANSACTION ISOLATION LEVEL
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [44-1] 2019-06-25 16:34:23: pid 12168: LOG:  Bind message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [44-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: "", statement: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [45-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: B message
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [46-1] 2019-06-25 16:34:23: pid 12168: LOG:  Describe message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [46-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [47-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: D message
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [48-1] 2019-06-25 16:34:23: pid 12168: LOG:  Execute message from frontend.
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [48-2] 2019-06-25 16:34:23: pid 12168: DETAIL:  portal: ""
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [49-1] 2019-06-25 16:34:23: pid 12168: LOG:  DB node id: 0 backend pid: 12169 statement: Execute: SHOW TRANSACTION ISOLATION LEVEL
:Jun 25 16:34:23 pgsql1 pgpool[12168]: [50-1] 2019-06-25 16:34:23: pid 12168: LOG:  Sync message from frontend.

mail-info.txt (61,873 bytes)

t-ishii

2019-06-26 10:58

developer   ~0002681

Thanks for the logs. I will look into them.

t-ishii

2019-07-02 14:56

developer   ~0002686

Still struggling to find the cause of the segfault. It seems your stack trace's pid (12516) is different from the ones (8971, 8974) and appeared in the pgpool log (messages.2_with-memory_cache_enabled-on). Do you have minimum test data to reproduce the problem?
I was not able to reproduce the segfault.

guobo507

2019-07-02 16:10

reporter   ~0002687

TKS for the reply. i will reproduce the segfault and collect the information you need later... thanks again!

guobo507

2019-07-02 18:25

reporter   ~0002688

Hi, it may be difficult for you to reproduce the segfaul, because at the moment I noticed that the error only appeared on one of our java projects. And, only appeared when we set memory_cache_enable = on.

 I have reproduced the segfault, the stack trace information is in the trace.txt file. The pgpool-II log is in mail.txt, which is the mail received by the root user when error occur. Apache server log is in java-log.txt file, which only include the error info.

TKS a lot!

mail.txt (61,841 bytes)
reason:         pgpool killed by SIGSEGV
cmdline:        'pgpool: postgres testdb 192.168.28.71(58906) idle in transaction'
executable:     /usr/pgpool-11/bin/pgpool
package:        pgpool-II-11-4.0.5-1.rhel7
component:      pgpool-II-11
pid:            13955
pwd:            /
hostname:       pgsql1
count:          1
abrt_version:   2.1.11
analyzer:       CCpp
architecture:   x86_64
event_log:      
global_pid:     13955
kernel:         3.10.0-957.21.3.el7.x86_64
last_occurrence: 1562056942
os_release:     CentOS Linux release 7.6.1810 (Core) 
pkg_arch:       x86_64
pkg_epoch:      0
pkg_fingerprint: 1F16 D2E1 442D F0F8
pkg_name:       pgpool-II-11
pkg_release:    1.rhel7
pkg_vendor:     PostgreSQL Global Development Group
pkg_version:    4.0.5
runlevel:       N 5
time:           Tue 02 Jul 2019 04:42:22 PM CST
type:           CCpp
uid:            5432
username:       postgres
uuid:           b199b6e7b91db894c678439d98fe7f1ea7df62ab

core_backtrace:
:{   "signal": 11
:,   "executable": "/usr/pgpool-11/bin/pgpool"
:,   "stacktrace":
:      [ {   "crash_thread": true
:        ,   "frames":
:              [ {   "address": 4434376
:                ,   "build_id": "6421445dad42d6af2f3157061d35b7f7b2e0e324"
:                ,   "build_id_offset": 240072
:                ,   "function_name": "Execute"
:                ,   "file_name": "/usr/pgpool-11/bin/pgpool"
:                }
:              , {   "address": 4452494
:                ,   "build_id": "6421445dad42d6af2f3157061d35b7f7b2e0e324"
:                ,   "build_id_offset": 258190
:                ,   "function_name": "ProcessFrontendResponse"
:                ,   "file_name": "/usr/pgpool-11/bin/pgpool"
:                }
:              , {   "address": 4398041
:                ,   "build_id": "6421445dad42d6af2f3157061d35b7f7b2e0e324"
:                ,   "build_id_offset": 203737
:                ,   "function_name": "read_packets_and_process.constprop.5"
:                ,   "file_name": "/usr/pgpool-11/bin/pgpool"
:                }
:              , {   "address": 4400923
:                ,   "build_id": "6421445dad42d6af2f3157061d35b7f7b2e0e324"
:                ,   "build_id_offset": 206619
:                ,   "function_name": "pool_process_query"
:                ,   "file_name": "/usr/pgpool-11/bin/pgpool"
:                }
:              , {   "address": 4378425
:                ,   "build_id": "6421445dad42d6af2f3157061d35b7f7b2e0e324"
:                ,   "build_id_offset": 184121
:                ,   "function_name": "do_child"
:                ,   "file_name": "/usr/pgpool-11/bin/pgpool"
:                }
:              , {   "address": 4231413
:                ,   "build_id": "6421445dad42d6af2f3157061d35b7f7b2e0e324"
:                ,   "build_id_offset": 37109
:                ,   "function_name": "fork_a_child"
:                ,   "file_name": "/usr/pgpool-11/bin/pgpool"
:                }
:              , {   "address": 4233519
:                ,   "build_id": "6421445dad42d6af2f3157061d35b7f7b2e0e324"
:                ,   "build_id_offset": 39215
:                ,   "function_name": "reaper"
:                ,   "file_name": "/usr/pgpool-11/bin/pgpool"
:                }
:              , {   "address": 4260895
:                ,   "build_id": "6421445dad42d6af2f3157061d35b7f7b2e0e324"
:                ,   "build_id_offset": 66591
:                ,   "function_name": "PgpoolMain"
:                ,   "file_name": "/usr/pgpool-11/bin/pgpool"
:                }
:              , {   "address": 4224951
:                ,   "build_id": "6421445dad42d6af2f3157061d35b7f7b2e0e324"
:                ,   "build_id_offset": 30647
:                ,   "function_name": "main"
:                ,   "file_name": "/usr/pgpool-11/bin/pgpool"
:                } ]
:        } ]
:}
cgroup:
:11:cpuset:/
:10:cpuacct,cpu:/
:9:memory:/
:8:hugetlb:/
:7:devices:/system.slice
:6:net_prio,net_cls:/
:5:blkio:/
:4:freezer:/
:3:pids:/
:2:perf_event:/
:1:name=systemd:/system.slice/pgpool-II-11.service
dso_list:
:/usr/lib64/libplc4.so nspr-4.19.0-1.el7_5.x86_64 (CentOS) 1550825269
:/usr/lib64/libc-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libattr.so.1.1.0 libattr-2.4.46-13.el7.x86_64 (CentOS) 1550825269
:/usr/lib64/libgcc_s-4.8.5-20150702.so.1 libgcc-4.8.5-36.el7.x86_64 (CentOS) 1550825240
:/usr/lib64/libnssutil3.so nss-util-3.36.0-1.el7_5.x86_64 (CentOS) 1550825269
:/usr/lib64/libcrypto.so.1.0.2k openssl-libs-1:1.0.2k-16.el7.x86_64 (CentOS) 1550825275
:/usr/lib64/libpcre.so.1.2.0 pcre-8.32-17.el7.x86_64 (CentOS) 1550825269
:/usr/lib64/libdw-0.172.so elfutils-libs-0.172-2.el7.x86_64 (CentOS) 1550825381
:/usr/lib64/librt-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libdl-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libmemcached.so.11.0.0 libmemcached-1.0.16-5.el7.x86_64 (CentOS) 1560319827
:/usr/lib64/libcap.so.2.22 libcap-2.22-9.el7.x86_64 (CentOS) 1550825269
:/usr/lib64/libssl3.so nss-3.36.0-7.el7_5.x86_64 (CentOS) 1550825289
:/usr/lib64/libkrb5.so.3.3 krb5-libs-1.15.1-34.el7.x86_64 (CentOS) 1550825275
:/usr/lib64/libbz2.so.1.0.6 bzip2-libs-1.0.6-13.el7.x86_64 (CentOS) 1550825276
:/usr/lib64/ld-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libresolv-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libnss3.so nss-3.36.0-7.el7_5.x86_64 (CentOS) 1550825289
:/usr/lib64/libsmime3.so nss-3.36.0-7.el7_5.x86_64 (CentOS) 1550825289
:/usr/lib64/libldap_r-2.4.so.2.10.7 openldap-2.4.44-20.el7.x86_64 (CentOS) 1550825355
:/usr/lib64/libnss_myhostname.so.2 systemd-libs-219-62.el7.x86_64 (CentOS) 1550825381
:/usr/lib64/libgssapi_krb5.so.2.2 krb5-libs-1.15.1-34.el7.x86_64 (CentOS) 1550825275
:/usr/lib64/liblber-2.4.so.2.10.7 openldap-2.4.44-20.el7.x86_64 (CentOS) 1550825355
:/usr/pgpool-11/bin/pgpool pgpool-II-11-4.0.5-1.rhel7.x86_64 (PostgreSQL Global Development Group) 1560930507
:/usr/lib64/libcap-ng.so.0.0.0 libcap-ng-0.7.5-4.el7.x86_64 (CentOS) 1550825275
:/usr/lib64/libcrypt-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libnss_dns-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libaudit.so.1.0.0 audit-libs-2.8.4-4.el7.x86_64 (CentOS) 1550825276
:/usr/lib64/libkrb5support.so.0.1 krb5-libs-1.15.1-34.el7.x86_64 (CentOS) 1550825275
:/usr/lib64/libssl.so.1.0.2k openssl-libs-1:1.0.2k-16.el7.x86_64 (CentOS) 1550825275
:/usr/lib64/libpthread-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libfreebl3.so nss-softokn-freebl-3.36.0-5.el7_5.x86_64 (CentOS) 1550825258
:/usr/lib64/libselinux.so.1 libselinux-2.5-14.1.el7.x86_64 (CentOS) 1550825270
:/usr/lib64/libpam.so.0.83.1 pam-1.1.8-22.el7.x86_64 (CentOS) 1550825306
:/usr/lib64/libcom_err.so.2.1 libcom_err-1.42.9-13.el7.x86_64 (CentOS) 1550825269
:/usr/lib64/libplds4.so nspr-4.19.0-1.el7_5.x86_64 (CentOS) 1550825269
:/usr/lib64/libnsl-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libelf-0.172.so elfutils-libelf-0.172-2.el7.x86_64 (CentOS) 1550825276
:/usr/lib64/liblzma.so.5.2.2 xz-libs-5.2.2-1.el7.x86_64 (CentOS) 1550825276
:/usr/lib64/libz.so.1.2.7 zlib-1.2.7-18.el7.x86_64 (CentOS) 1550825269
:/usr/pgsql-11/lib/libpq.so.5.11 postgresql11-libs-11.2-2PGDG.rhel7.x86_64 (PostgreSQL Global Development Group) 1560310269
:/usr/lib64/libnspr4.so nspr-4.19.0-1.el7_5.x86_64 (CentOS) 1550825269
:/usr/lib64/libstdc++.so.6.0.19 libstdc++-4.8.5-36.el7.x86_64 (CentOS) 1550825269
:/usr/lib64/libkeyutils.so.1.5 keyutils-libs-1.5.8-3.el7.x86_64 (CentOS) 1550825270
:/usr/lib64/libk5crypto.so.3.1 krb5-libs-1.15.1-34.el7.x86_64 (CentOS) 1550825275
:/usr/lib64/libnss_files-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libm-2.17.so glibc-2.17-260.el7.x86_64 (CentOS) 1550825267
:/usr/lib64/libsasl2.so.3.0.0 cyrus-sasl-lib-2.1.26-23.el7.x86_64 (CentOS) 1550825277
environ:
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
:''
exploitable:
:Likely crash reason: Write to an invalid address
:Exploitable rating (0-9 scale): 6
:Current instruction: movb   $0x0,0x2d8(%rax)
limits:
:Limit                     Soft Limit           Hard Limit           Units     
:Max cpu time              unlimited            unlimited            seconds   
:Max file size             unlimited            unlimited            bytes     
:Max data size             unlimited            unlimited            bytes     
:Max stack size            8388608              unlimited            bytes     
:Max core file size        0                    unlimited            bytes     
:Max resident set          unlimited            unlimited            bytes     
:Max processes             128492               128492               processes 
:Max open files            1024                 4096                 files     
:Max locked memory         65536                65536                bytes     
:Max address space         unlimited            unlimited            bytes     
:Max file locks            unlimited            unlimited            locks     
:Max pending signals       128492               128492               signals   
:Max msgqueue size         819200               819200               bytes     
:Max nice priority         0                    0                    
:Max realtime priority     0                    0                    
:Max realtime timeout      unlimited            unlimited            us        
machineid:
:systemd=06e79615550549e8b156fd87f7ea8be2
:sosreport_uploader-dmidecode=7f639dc6f0478c9673942600b6d1f8af67ecbca9d7b66f1cc182f56231ad50df
maps:
:00400000-00564000 r-xp 00000000 fd:02 1877110                            /usr/pgpool-11/bin/pgpool
:00763000-00764000 r--p 00163000 fd:02 1877110                            /usr/pgpool-11/bin/pgpool
:00764000-0076c000 rw-p 00164000 fd:02 1877110                            /usr/pgpool-11/bin/pgpool
:0076c000-0078e000 rw-p 00000000 00:00 0 
:02138000-0217a000 rw-p 00000000 00:00 0                                  [heap]
:0217a000-021d9000 rw-p 00000000 00:00 0                                  [heap]
:7f0c76da8000-7f0c7723a000 rw-p 00000000 00:00 0 
:7f0c7723a000-7f0c77249000 r-xp 00000000 fd:02 16874103                   /usr/lib64/libbz2.so.1.0.6
:7f0c77249000-7f0c77448000 ---p 0000f000 fd:02 16874103                   /usr/lib64/libbz2.so.1.0.6
:7f0c77448000-7f0c77449000 r--p 0000e000 fd:02 16874103                   /usr/lib64/libbz2.so.1.0.6
:7f0c77449000-7f0c7744a000 rw-p 0000f000 fd:02 16874103                   /usr/lib64/libbz2.so.1.0.6
:7f0c7744a000-7f0c7746f000 r-xp 00000000 fd:02 16874092                   /usr/lib64/liblzma.so.5.2.2
:7f0c7746f000-7f0c7766e000 ---p 00025000 fd:02 16874092                   /usr/lib64/liblzma.so.5.2.2
:7f0c7766e000-7f0c7766f000 r--p 00024000 fd:02 16874092                   /usr/lib64/liblzma.so.5.2.2
:7f0c7766f000-7f0c77670000 rw-p 00025000 fd:02 16874092                   /usr/lib64/liblzma.so.5.2.2
:7f0c77670000-7f0c77687000 r-xp 00000000 fd:02 16874122                   /usr/lib64/libelf-0.172.so
:7f0c77687000-7f0c77886000 ---p 00017000 fd:02 16874122                   /usr/lib64/libelf-0.172.so
:7f0c77886000-7f0c77887000 r--p 00016000 fd:02 16874122                   /usr/lib64/libelf-0.172.so
:7f0c77887000-7f0c77888000 rw-p 00017000 fd:02 16874122                   /usr/lib64/libelf-0.172.so
:7f0c77888000-7f0c7788c000 r-xp 00000000 fd:02 16823949                   /usr/lib64/libattr.so.1.1.0
:7f0c7788c000-7f0c77a8b000 ---p 00004000 fd:02 16823949                   /usr/lib64/libattr.so.1.1.0
:7f0c77a8b000-7f0c77a8c000 r--p 00003000 fd:02 16823949                   /usr/lib64/libattr.so.1.1.0
:7f0c77a8c000-7f0c77a8d000 rw-p 00004000 fd:02 16823949                   /usr/lib64/libattr.so.1.1.0
:7f0c77a8d000-7f0c77ad9000 r-xp 00000000 fd:02 17545173                   /usr/lib64/libdw-0.172.so
:7f0c77ad9000-7f0c77cd9000 ---p 0004c000 fd:02 17545173                   /usr/lib64/libdw-0.172.so
:7f0c77cd9000-7f0c77cdb000 r--p 0004c000 fd:02 17545173                   /usr/lib64/libdw-0.172.so
:7f0c77cdb000-7f0c77cdc000 rw-p 0004e000 fd:02 17545173                   /usr/lib64/libdw-0.172.so
:7f0c77cdc000-7f0c77ce0000 r-xp 00000000 fd:02 16823953                   /usr/lib64/libcap.so.2.22
:7f0c77ce0000-7f0c77edf000 ---p 00004000 fd:02 16823953                   /usr/lib64/libcap.so.2.22
:7f0c77edf000-7f0c77ee0000 r--p 00003000 fd:02 16823953                   /usr/lib64/libcap.so.2.22
:7f0c77ee0000-7f0c77ee1000 rw-p 00004000 fd:02 16823953                   /usr/lib64/libcap.so.2.22
:7f0c77ee1000-7f0c77ef3000 r-xp 00000000 fd:02 17545175                   /usr/lib64/libnss_myhostname.so.2
:7f0c77ef3000-7f0c780f2000 ---p 00012000 fd:02 17545175                   /usr/lib64/libnss_myhostname.so.2
:7f0c780f2000-7f0c780f5000 r--p 00011000 fd:02 17545175                   /usr/lib64/libnss_myhostname.so.2
:7f0c780f5000-7f0c780f6000 rw-p 00014000 fd:02 17545175                   /usr/lib64/libnss_myhostname.so.2
:7f0c780f6000-7f0c780fb000 r-xp 00000000 fd:02 16823821                   /usr/lib64/libnss_dns-2.17.so
:7f0c780fb000-7f0c782fb000 ---p 00005000 fd:02 16823821                   /usr/lib64/libnss_dns-2.17.so
:7f0c782fb000-7f0c782fc000 r--p 00005000 fd:02 16823821                   /usr/lib64/libnss_dns-2.17.so
:7f0c782fc000-7f0c782fd000 rw-p 00006000 fd:02 16823821                   /usr/lib64/libnss_dns-2.17.so
:7f0c782fd000-7f0c7b2fd000 rw-s 00000000 00:04 1933325                    /SYSV00000000 (deleted)
:7f0c7b2fd000-7f0c7c2fe000 rw-s 00000000 00:04 1900556                    /SYSV00000000 (deleted)
:7f0c7c2fe000-7f0cbc2fe000 rw-s 00000000 00:04 1802249                    /SYSV00000000 (deleted)
:7f0cbc2fe000-7f0cbc30a000 r-xp 00000000 fd:02 16823823                   /usr/lib64/libnss_files-2.17.so
:7f0cbc30a000-7f0cbc509000 ---p 0000c000 fd:02 16823823                   /usr/lib64/libnss_files-2.17.so
:7f0cbc509000-7f0cbc50a000 r--p 0000b000 fd:02 16823823                   /usr/lib64/libnss_files-2.17.so
:7f0cbc50a000-7f0cbc50b000 rw-p 0000c000 fd:02 16823823                   /usr/lib64/libnss_files-2.17.so
:7f0cbc50b000-7f0cbc511000 rw-p 00000000 00:00 0 
:7f0cbc511000-7f0cbc571000 r-xp 00000000 fd:02 16823912                   /usr/lib64/libpcre.so.1.2.0
:7f0cbc571000-7f0cbc771000 ---p 00060000 fd:02 16823912                   /usr/lib64/libpcre.so.1.2.0
:7f0cbc771000-7f0cbc772000 r--p 00060000 fd:02 16823912                   /usr/lib64/libpcre.so.1.2.0
:7f0cbc772000-7f0cbc773000 rw-p 00061000 fd:02 16823912                   /usr/lib64/libpcre.so.1.2.0
:7f0cbc773000-7f0cbc77a000 r-xp 00000000 fd:02 16823835                   /usr/lib64/librt-2.17.so
:7f0cbc77a000-7f0cbc979000 ---p 00007000 fd:02 16823835                   /usr/lib64/librt-2.17.so
:7f0cbc979000-7f0cbc97a000 r--p 00006000 fd:02 16823835                   /usr/lib64/librt-2.17.so
:7f0cbc97a000-7f0cbc97b000 rw-p 00007000 fd:02 16823835                   /usr/lib64/librt-2.17.so
:7f0cbc97b000-7f0cbc99f000 r-xp 00000000 fd:02 16823970                   /usr/lib64/libselinux.so.1
:7f0cbc99f000-7f0cbcb9e000 ---p 00024000 fd:02 16823970                   /usr/lib64/libselinux.so.1
:7f0cbcb9e000-7f0cbcb9f000 r--p 00023000 fd:02 16823970                   /usr/lib64/libselinux.so.1
:7f0cbcb9f000-7f0cbcba0000 rw-p 00024000 fd:02 16823970                   /usr/lib64/libselinux.so.1
:7f0cbcba0000-7f0cbcba2000 rw-p 00000000 00:00 0 
:7f0cbcba2000-7f0cbcba6000 r-xp 00000000 fd:02 16874085                   /usr/lib64/libcap-ng.so.0.0.0
:7f0cbcba6000-7f0cbcda6000 ---p 00004000 fd:02 16874085                   /usr/lib64/libcap-ng.so.0.0.0
:7f0cbcda6000-7f0cbcda7000 r--p 00004000 fd:02 16874085                   /usr/lib64/libcap-ng.so.0.0.0
:7f0cbcda7000-7f0cbcda8000 rw-p 00005000 fd:02 16874085                   /usr/lib64/libcap-ng.so.0.0.0
:7f0cbcda8000-7f0cbcde2000 r-xp 00000000 fd:02 16823867                   /usr/lib64/libnspr4.so
:7f0cbcde2000-7f0cbcfe1000 ---p 0003a000 fd:02 16823867                   /usr/lib64/libnspr4.so
:7f0cbcfe1000-7f0cbcfe2000 r--p 00039000 fd:02 16823867                   /usr/lib64/libnspr4.so
:7f0cbcfe2000-7f0cbcfe4000 rw-p 0003a000 fd:02 16823867                   /usr/lib64/libnspr4.so
:7f0cbcfe4000-7f0cbcfe6000 rw-p 00000000 00:00 0 
:7f0cbcfe6000-7f0cbcfea000 r-xp 00000000 fd:02 16823868                   /usr/lib64/libplc4.so
:7f0cbcfea000-7f0cbd1e9000 ---p 00004000 fd:02 16823868                   /usr/lib64/libplc4.so
:7f0cbd1e9000-7f0cbd1ea000 r--p 00003000 fd:02 16823868                   /usr/lib64/libplc4.so
:7f0cbd1ea000-7f0cbd1eb000 rw-p 00004000 fd:02 16823868                   /usr/lib64/libplc4.so
:7f0cbd1eb000-7f0cbd1ee000 r-xp 00000000 fd:02 16823869                   /usr/lib64/libplds4.so
:7f0cbd1ee000-7f0cbd3ed000 ---p 00003000 fd:02 16823869                   /usr/lib64/libplds4.so
:7f0cbd3ed000-7f0cbd3ee000 r--p 00002000 fd:02 16823869                   /usr/lib64/libplds4.so
:7f0cbd3ee000-7f0cbd3ef000 rw-p 00003000 fd:02 16823869                   /usr/lib64/libplds4.so
:7f0cbd3ef000-7f0cbd417000 r-xp 00000000 fd:02 16823896                   /usr/lib64/libnssutil3.so
:7f0cbd417000-7f0cbd616000 ---p 00028000 fd:02 16823896                   /usr/lib64/libnssutil3.so
:7f0cbd616000-7f0cbd61d000 r--p 00027000 fd:02 16823896                   /usr/lib64/libnssutil3.so
:7f0cbd61d000-7f0cbd61e000 rw-p 0002e000 fd:02 16823896                   /usr/lib64/libnssutil3.so
:7f0cbd61e000-7f0cbd742000 r-xp 00000000 fd:02 16875101                   /usr/lib64/libnss3.so
:7f0cbd742000-7f0cbd942000 ---p 00124000 fd:02 16875101                   /usr/lib64/libnss3.so
:7f0cbd942000-7f0cbd947000 r--p 00124000 fd:02 16875101                   /usr/lib64/libnss3.so
:7f0cbd947000-7f0cbd949000 rw-p 00129000 fd:02 16875101                   /usr/lib64/libnss3.so
:7f0cbd949000-7f0cbd94b000 rw-p 00000000 00:00 0 
:7f0cbd94b000-7f0cbd96f000 r-xp 00000000 fd:02 16875102                   /usr/lib64/libsmime3.so
:7f0cbd96f000-7f0cbdb6e000 ---p 00024000 fd:02 16875102                   /usr/lib64/libsmime3.so
:7f0cbdb6e000-7f0cbdb71000 r--p 00023000 fd:02 16875102                   /usr/lib64/libsmime3.so
:7f0cbdb71000-7f0cbdb72000 rw-p 00026000 fd:02 16875102                   /usr/lib64/libsmime3.so
:7f0cbdb72000-7f0cbdbbf000 r-xp 00000000 fd:02 16875103                   /usr/lib64/libssl3.so
:7f0cbdbbf000-7f0cbddbe000 ---p 0004d000 fd:02 16875103                   /usr/lib64/libssl3.so
:7f0cbddbe000-7f0cbddc2000 r--p 0004c000 fd:02 16875103                   /usr/lib64/libssl3.so
:7f0cbddc2000-7f0cbddc3000 rw-p 00050000 fd:02 16875103                   /usr/lib64/libssl3.so
:7f0cbddc3000-7f0cbddc4000 rw-p 00000000 00:00 0 
:7f0cbddc4000-7f0cbddd2000 r-xp 00000000 fd:02 17404392                   /usr/lib64/liblber-2.4.so.2.10.7
:7f0cbddd2000-7f0cbdfd1000 ---p 0000e000 fd:02 17404392                   /usr/lib64/liblber-2.4.so.2.10.7
:7f0cbdfd1000-7f0cbdfd2000 r--p 0000d000 fd:02 17404392                   /usr/lib64/liblber-2.4.so.2.10.7
:7f0cbdfd2000-7f0cbdfd3000 rw-p 0000e000 fd:02 17404392                   /usr/lib64/liblber-2.4.so.2.10.7
:7f0cbdfd3000-7f0cbdfd6000 r-xp 00000000 fd:02 16823959                   /usr/lib64/libkeyutils.so.1.5
:7f0cbdfd6000-7f0cbe1d5000 ---p 00003000 fd:02 16823959                   /usr/lib64/libkeyutils.so.1.5
:7f0cbe1d5000-7f0cbe1d6000 r--p 00002000 fd:02 16823959                   /usr/lib64/libkeyutils.so.1.5
:7f0cbe1d6000-7f0cbe1d7000 rw-p 00003000 fd:02 16823959                   /usr/lib64/libkeyutils.so.1.5
:7f0cbe1d7000-7f0cbe1e4000 r-xp 00000000 fd:02 16874055                   /usr/lib64/libkrb5support.so.0.1
:7f0cbe1e4000-7f0cbe3e4000 ---p 0000d000 fd:02 16874055                   /usr/lib64/libkrb5support.so.0.1
:7f0cbe3e4000-7f0cbe3e5000 r--p 0000d000 fd:02 16874055                   /usr/lib64/libkrb5support.so.0.1
:7f0cbe3e5000-7f0cbe3e6000 rw-p 0000e000 fd:02 16874055                   /usr/lib64/libkrb5support.so.0.1
:7f0cbe3e6000-7f0cbe3e8000 r-xp 00000000 fd:02 16818345                   /usr/lib64/libfreebl3.so
:7f0cbe3e8000-7f0cbe5e7000 ---p 00002000 fd:02 16818345                   /usr/lib64/libfreebl3.so
:7f0cbe5e7000-7f0cbe5e8000 r--p 00001000 fd:02 16818345                   /usr/lib64/libfreebl3.so
:7f0cbe5e8000-7f0cbe5e9000 rw-p 00002000 fd:02 16818345                   /usr/lib64/libfreebl3.so
:7f0cbe5e9000-7f0cbe5fe000 r-xp 00000000 fd:02 16823850                   /usr/lib64/libz.so.1.2.7
:7f0cbe5fe000-7f0cbe7fd000 ---p 00015000 fd:02 16823850                   /usr/lib64/libz.so.1.2.7
:7f0cbe7fd000-7f0cbe7fe000 r--p 00014000 fd:02 16823850                   /usr/lib64/libz.so.1.2.7
:7f0cbe7fe000-7f0cbe7ff000 rw-p 00015000 fd:02 16823850                   /usr/lib64/libz.so.1.2.7
:7f0cbe7ff000-7f0cbe818000 r-xp 00000000 fd:02 16824063                   /usr/lib64/libk5crypto.so.3.1
:7f0cbe818000-7f0cbea17000 ---p 00019000 fd:02 16824063                   /usr/lib64/libk5crypto.so.3.1
:7f0cbea17000-7f0cbea19000 r--p 00018000 fd:02 16824063                   /usr/lib64/libk5crypto.so.3.1
:7f0cbea19000-7f0cbea1a000 rw-p 0001a000 fd:02 16824063                   /usr/lib64/libk5crypto.so.3.1
:7f0cbea1a000-7f0cbea1d000 r-xp 00000000 fd:02 16823866                   /usr/lib64/libcom_err.so.2.1
:7f0cbea1d000-7f0cbec1c000 ---p 00003000 fd:02 16823866                   /usr/lib64/libcom_err.so.2.1
:7f0cbec1c000-7f0cbec1d000 r--p 00002000 fd:02 16823866                   /usr/lib64/libcom_err.so.2.1
:7f0cbec1d000-7f0cbec1e000 rw-p 00003000 fd:02 16823866                   /usr/lib64/libcom_err.so.2.1
:7f0cbec1e000-7f0cbecf7000 r-xp 00000000 fd:02 16874053                   /usr/lib64/libkrb5.so.3.3
:7f0cbecf7000-7f0cbeef6000 ---p 000d9000 fd:02 16874053                   /usr/lib64/libkrb5.so.3.3
:7f0cbeef6000-7f0cbef04000 r--p 000d8000 fd:02 16874053                   /usr/lib64/libkrb5.so.3.3
:7f0cbef04000-7f0cbef07000 rw-p 000e6000 fd:02 16874053                   /usr/lib64/libkrb5.so.3.3
:7f0cbef07000-7f0cbef25000 r-xp 00000000 fd:02 16874087                   /usr/lib64/libaudit.so.1.0.0
:7f0cbef25000-7f0cbf124000 ---p 0001e000 fd:02 16874087                   /usr/lib64/libaudit.so.1.0.0
:7f0cbf124000-7f0cbf125000 r--p 0001d000 fd:02 16874087                   /usr/lib64/libaudit.so.1.0.0
:7f0cbf125000-7f0cbf126000 rw-p 0001e000 fd:02 16874087                   /usr/lib64/libaudit.so.1.0.0
:7f0cbf126000-7f0cbf130000 rw-p 00000000 00:00 0 
:7f0cbf130000-7f0cbf145000 r-xp 00000000 fd:02 16777283                   /usr/lib64/libgcc_s-4.8.5-20150702.so.1
:7f0cbf145000-7f0cbf344000 ---p 00015000 fd:02 16777283                   /usr/lib64/libgcc_s-4.8.5-20150702.so.1
:7f0cbf344000-7f0cbf345000 r--p 00014000 fd:02 16777283                   /usr/lib64/libgcc_s-4.8.5-20150702.so.1
:7f0cbf345000-7f0cbf346000 rw-p 00015000 fd:02 16777283                   /usr/lib64/libgcc_s-4.8.5-20150702.so.1
:7f0cbf346000-7f0cbf42f000 r-xp 00000000 fd:02 16823856                   /usr/lib64/libstdc++.so.6.0.19
:7f0cbf42f000-7f0cbf62e000 ---p 000e9000 fd:02 16823856                   /usr/lib64/libstdc++.so.6.0.19
:7f0cbf62e000-7f0cbf636000 r--p 000e8000 fd:02 16823856                   /usr/lib64/libstdc++.so.6.0.19
:7f0cbf636000-7f0cbf638000 rw-p 000f0000 fd:02 16823856                   /usr/lib64/libstdc++.so.6.0.19
:7f0cbf638000-7f0cbf64d000 rw-p 00000000 00:00 0 
:7f0cbf64d000-7f0cbf669000 r-xp 00000000 fd:02 16874148                   /usr/lib64/libsasl2.so.3.0.0
:7f0cbf669000-7f0cbf868000 ---p 0001c000 fd:02 16874148                   /usr/lib64/libsasl2.so.3.0.0
:7f0cbf868000-7f0cbf869000 r--p 0001b000 fd:02 16874148                   /usr/lib64/libsasl2.so.3.0.0
:7f0cbf869000-7f0cbf86a000 rw-p 0001c000 fd:02 16874148                   /usr/lib64/libsasl2.so.3.0.0
:7f0cbf86a000-7f0cbf86c000 r-xp 00000000 fd:02 16823811                   /usr/lib64/libdl-2.17.so
:7f0cbf86c000-7f0cbfa6c000 ---p 00002000 fd:02 16823811                   /usr/lib64/libdl-2.17.so
:7f0cbfa6c000-7f0cbfa6d000 r--p 00002000 fd:02 16823811                   /usr/lib64/libdl-2.17.so
:7f0cbfa6d000-7f0cbfa6e000 rw-p 00003000 fd:02 16823811                   /usr/lib64/libdl-2.17.so
:7f0cbfa6e000-7f0cbfac7000 r-xp 00000000 fd:02 17404396                   /usr/lib64/libldap_r-2.4.so.2.10.7
:7f0cbfac7000-7f0cbfcc7000 ---p 00059000 fd:02 17404396                   /usr/lib64/libldap_r-2.4.so.2.10.7
:7f0cbfcc7000-7f0cbfcc9000 r--p 00059000 fd:02 17404396                   /usr/lib64/libldap_r-2.4.so.2.10.7
:7f0cbfcc9000-7f0cbfcca000 rw-p 0005b000 fd:02 17404396                   /usr/lib64/libldap_r-2.4.so.2.10.7
:7f0cbfcca000-7f0cbfccd000 rw-p 00000000 00:00 0 
:7f0cbfccd000-7f0cbfd17000 r-xp 00000000 fd:02 16824059                   /usr/lib64/libgssapi_krb5.so.2.2
:7f0cbfd17000-7f0cbff17000 ---p 0004a000 fd:02 16824059                   /usr/lib64/libgssapi_krb5.so.2.2
:7f0cbff17000-7f0cbff18000 r--p 0004a000 fd:02 16824059                   /usr/lib64/libgssapi_krb5.so.2.2
:7f0cbff18000-7f0cbff1a000 rw-p 0004b000 fd:02 16824059                   /usr/lib64/libgssapi_krb5.so.2.2
:7f0cbff1a000-7f0cc00dc000 r-xp 00000000 fd:02 16818973                   /usr/lib64/libc-2.17.so
:7f0cc00dc000-7f0cc02dc000 ---p 001c2000 fd:02 16818973                   /usr/lib64/libc-2.17.so
:7f0cc02dc000-7f0cc02e0000 r--p 001c2000 fd:02 16818973                   /usr/lib64/libc-2.17.so
:7f0cc02e0000-7f0cc02e2000 rw-p 001c6000 fd:02 16818973                   /usr/lib64/libc-2.17.so
:7f0cc02e2000-7f0cc02e7000 rw-p 00000000 00:00 0 
:7f0cc02e7000-7f0cc03e8000 r-xp 00000000 fd:02 16823813                   /usr/lib64/libm-2.17.so
:7f0cc03e8000-7f0cc05e7000 ---p 00101000 fd:02 16823813                   /usr/lib64/libm-2.17.so
:7f0cc05e7000-7f0cc05e8000 r--p 00100000 fd:02 16823813                   /usr/lib64/libm-2.17.so
:7f0cc05e8000-7f0cc05e9000 rw-p 00101000 fd:02 16823813                   /usr/lib64/libm-2.17.so
:7f0cc05e9000-7f0cc05ff000 r-xp 00000000 fd:02 16823815                   /usr/lib64/libnsl-2.17.so
:7f0cc05ff000-7f0cc07ff000 ---p 00016000 fd:02 16823815                   /usr/lib64/libnsl-2.17.so
:7f0cc07ff000-7f0cc0800000 r--p 00016000 fd:02 16823815                   /usr/lib64/libnsl-2.17.so
:7f0cc0800000-7f0cc0801000 rw-p 00017000 fd:02 16823815                   /usr/lib64/libnsl-2.17.so
:7f0cc0801000-7f0cc0803000 rw-p 00000000 00:00 0 
:7f0cc0803000-7f0cc0819000 r-xp 00000000 fd:02 16823833                   /usr/lib64/libresolv-2.17.so
:7f0cc0819000-7f0cc0a18000 ---p 00016000 fd:02 16823833                   /usr/lib64/libresolv-2.17.so
:7f0cc0a18000-7f0cc0a19000 r--p 00015000 fd:02 16823833                   /usr/lib64/libresolv-2.17.so
:7f0cc0a19000-7f0cc0a1a000 rw-p 00016000 fd:02 16823833                   /usr/lib64/libresolv-2.17.so
:7f0cc0a1a000-7f0cc0a1c000 rw-p 00000000 00:00 0 
:7f0cc0a1c000-7f0cc0a24000 r-xp 00000000 fd:02 16823809                   /usr/lib64/libcrypt-2.17.so
:7f0cc0a24000-7f0cc0c23000 ---p 00008000 fd:02 16823809                   /usr/lib64/libcrypt-2.17.so
:7f0cc0c23000-7f0cc0c24000 r--p 00007000 fd:02 16823809                   /usr/lib64/libcrypt-2.17.so
:7f0cc0c24000-7f0cc0c25000 rw-p 00008000 fd:02 16823809                   /usr/lib64/libcrypt-2.17.so
:7f0cc0c25000-7f0cc0c53000 rw-p 00000000 00:00 0 
:7f0cc0c53000-7f0cc0e87000 r-xp 00000000 fd:02 16874067                   /usr/lib64/libcrypto.so.1.0.2k
:7f0cc0e87000-7f0cc1087000 ---p 00234000 fd:02 16874067                   /usr/lib64/libcrypto.so.1.0.2k
:7f0cc1087000-7f0cc10a3000 r--p 00234000 fd:02 16874067                   /usr/lib64/libcrypto.so.1.0.2k
:7f0cc10a3000-7f0cc10b0000 rw-p 00250000 fd:02 16874067                   /usr/lib64/libcrypto.so.1.0.2k
:7f0cc10b0000-7f0cc10b4000 rw-p 00000000 00:00 0 
:7f0cc10b4000-7f0cc111b000 r-xp 00000000 fd:02 16874069                   /usr/lib64/libssl.so.1.0.2k
:7f0cc111b000-7f0cc131b000 ---p 00067000 fd:02 16874069                   /usr/lib64/libssl.so.1.0.2k
:7f0cc131b000-7f0cc131f000 r--p 00067000 fd:02 16874069                   /usr/lib64/libssl.so.1.0.2k
:7f0cc131f000-7f0cc1326000 rw-p 0006b000 fd:02 16874069                   /usr/lib64/libssl.so.1.0.2k
:7f0cc1326000-7f0cc1333000 r-xp 00000000 fd:02 16910166                   /usr/lib64/libpam.so.0.83.1
:7f0cc1333000-7f0cc1533000 ---p 0000d000 fd:02 16910166                   /usr/lib64/libpam.so.0.83.1
:7f0cc1533000-7f0cc1534000 r--p 0000d000 fd:02 16910166                   /usr/lib64/libpam.so.0.83.1
:7f0cc1534000-7f0cc1535000 rw-p 0000e000 fd:02 16910166                   /usr/lib64/libpam.so.0.83.1
:7f0cc1535000-7f0cc1565000 r-xp 00000000 fd:02 19110499                   /usr/lib64/libmemcached.so.11.0.0
:7f0cc1565000-7f0cc1765000 ---p 00030000 fd:02 19110499                   /usr/lib64/libmemcached.so.11.0.0
:7f0cc1765000-7f0cc1766000 r--p 00030000 fd:02 19110499                   /usr/lib64/libmemcached.so.11.0.0
:7f0cc1766000-7f0cc1767000 rw-p 00031000 fd:02 19110499                   /usr/lib64/libmemcached.so.11.0.0
:7f0cc1767000-7f0cc177e000 r-xp 00000000 fd:02 16823831                   /usr/lib64/libpthread-2.17.so
:7f0cc177e000-7f0cc197d000 ---p 00017000 fd:02 16823831                   /usr/lib64/libpthread-2.17.so
:7f0cc197d000-7f0cc197e000 r--p 00016000 fd:02 16823831                   /usr/lib64/libpthread-2.17.so
:7f0cc197e000-7f0cc197f000 rw-p 00017000 fd:02 16823831                   /usr/lib64/libpthread-2.17.so
:7f0cc197f000-7f0cc1983000 rw-p 00000000 00:00 0 
:7f0cc1983000-7f0cc19c9000 r-xp 00000000 fd:02 18074429                   /usr/pgsql-11/lib/libpq.so.5.11
:7f0cc19c9000-7f0cc1bc8000 ---p 00046000 fd:02 18074429                   /usr/pgsql-11/lib/libpq.so.5.11
:7f0cc1bc8000-7f0cc1bcb000 r--p 00045000 fd:02 18074429                   /usr/pgsql-11/lib/libpq.so.5.11
:7f0cc1bcb000-7f0cc1bcc000 rw-p 00048000 fd:02 18074429                   /usr/pgsql-11/lib/libpq.so.5.11
:7f0cc1bcc000-7f0cc1bee000 r-xp 00000000 fd:02 16818966                   /usr/lib64/ld-2.17.so
:7f0cc1c56000-7f0cc1d5b000 rw-p 00000000 00:00 0 
:7f0cc1d5b000-7f0cc1d5d000 rw-s 00000000 00:04 1998863                    /SYSV00000000 (deleted)
:7f0cc1d5d000-7f0cc1da1000 rw-s 00000000 00:04 1638404                    /SYSV00000000 (deleted)
:7f0cc1da1000-7f0cc1dd6000 rw-p 00000000 00:00 0 
:7f0cc1dd6000-7f0cc1dd7000 rw-s 00000000 00:04 1966094                    /SYSV00000000 (deleted)
:7f0cc1dd7000-7f0cc1dd8000 rw-s 00000000 00:04 1867787                    /SYSV00000000 (deleted)
:7f0cc1dd8000-7f0cc1dd9000 rw-s 00000000 00:04 1835018                    /SYSV00000000 (deleted)
:7f0cc1dd9000-7f0cc1dda000 rw-s 00000000 00:04 1769480                    /SYSV00000000 (deleted)
:7f0cc1dda000-7f0cc1ddc000 rw-s 00000000 00:04 1736711                    /SYSV00000000 (deleted)
:7f0cc1ddc000-7f0cc1ddd000 rw-s 00000000 00:04 1703942                    /SYSV00000000 (deleted)
:7f0cc1ddd000-7f0cc1dde000 rw-s 00000000 00:04 1671173                    /SYSV00000000 (deleted)
:7f0cc1dde000-7f0cc1dec000 rw-s 00000000 00:04 1605635                    /SYSV00000000 (deleted)
:7f0cc1dec000-7f0cc1ded000 rw-p 00000000 00:00 0 
:7f0cc1ded000-7f0cc1dee000 r--p 00021000 fd:02 16818966                   /usr/lib64/ld-2.17.so
:7f0cc1dee000-7f0cc1def000 rw-p 00022000 fd:02 16818966                   /usr/lib64/ld-2.17.so
:7f0cc1def000-7f0cc1df0000 rw-p 00000000 00:00 0 
:7ffeae42b000-7ffeae44c000 rw-p 00000000 00:00 0                          [stack]
:7ffeae5d2000-7ffeae5d4000 r-xp 00000000 00:00 0                          [vdso]
:ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0                  [vsyscall]
open_fds:
:0:/dev/null
:pos:	0
:flags:	0100000
:mnt_id:	20
:1:socket:[52049]
:pos:	0
:flags:	02
:mnt_id:	7
:2:socket:[52049]
:pos:	0
:flags:	02
:mnt_id:	7
:3:/etc/pgpool-II-11/pool_passwd
:pos:	132
:flags:	0100000
:mnt_id:	40
:4:socket:[63509]
:pos:	0
:flags:	02000002
:mnt_id:	7
:5:socket:[49059]
:pos:	0
:flags:	04002
:mnt_id:	7
:6:socket:[49063]
:pos:	0
:flags:	04002
:mnt_id:	7
:7:socket:[49064]
:pos:	0
:flags:	04002
:mnt_id:	7
:8:socket:[1590478]
:pos:	0
:flags:	02
:mnt_id:	7
:9:socket:[152589]
:pos:	0
:flags:	02
:mnt_id:	7
:10:socket:[62049]
:pos:	0
:flags:	02
:mnt_id:	7
:11:socket:[62050]
:pos:	0
:flags:	02
:mnt_id:	7
:12:socket:[152590]
:pos:	0
:flags:	02
:mnt_id:	7
os_info:
:NAME="CentOS Linux"
:VERSION="7 (Core)"
:ID="centos"
:ID_LIKE="rhel fedora"
:VERSION_ID="7"
:PRETTY_NAME="CentOS Linux 7 (Core)"
:ANSI_COLOR="0;31"
:CPE_NAME="cpe:/o:centos:centos:7"
:HOME_URL="https://www.centos.org/"
:BUG_REPORT_URL="https://bugs.centos.org/"
:
:CENTOS_MANTISBT_PROJECT="CentOS-7"
:CENTOS_MANTISBT_PROJECT_VERSION="7"
:REDHAT_SUPPORT_PRODUCT="centos"
:REDHAT_SUPPORT_PRODUCT_VERSION="7"
:
proc_pid_status:
:Name:	pgpool
:Umask:	0022
:State:	S (sleeping)
:Tgid:	13955
:Ngid:	0
:Pid:	13955
:PPid:	11108
:TracerPid:	0
:Uid:	5432	5432	5432	5432
:Gid:	5432	5432	5432	5432
:FDSize:	64
:Groups:	5432 
:VmPeak:	 1231068 kB
:VmSize:	 1231052 kB
:VmLck:	       0 kB
:VmPin:	       0 kB
:VmHWM:	    9548 kB
:VmRSS:	    8600 kB
:RssAnon:	    6544 kB
:RssFile:	    1856 kB
:RssShmem:	     200 kB
:VmData:	    7172 kB
:VmStk:	     132 kB
:VmExe:	    1424 kB
:VmLib:	   12944 kB
:VmPTE:	     276 kB
:VmSwap:	     932 kB
:Threads:	1
:SigQ:	0/128492
:SigPnd:	0000000000000000
:ShdPnd:	0000000000000000
:SigBlk:	0000000000000000
:SigIgn:	0000000000003000
:SigCgt:	0000000180004a07
:CapInh:	0000000000000000
:CapPrm:	0000000000000000
:CapEff:	0000000000000000
:CapBnd:	0000001fffffffff
:CapAmb:	0000000000000000
:Seccomp:	0
:Speculation_Store_Bypass:	vulnerable
:Cpus_allowed:	ffffffff,ffffffff,ffffffff,ffffffff
:Cpus_allowed_list:	0-127
:Mems_allowed:	00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00
000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001
:Mems_allowed_list:	0
:voluntary_ctxt_switches:	1458
:nonvoluntary_ctxt_switches:	1
var_log_messages:
:[System Logs]:
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [743-1] 2019-07-02 16:42:54: pid 12617: LOG:  Sync message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [744-1] 2019-07-02 16:42:54: pid 12617: LOG:  Parse message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [744-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  statement: "", query: "BEGIN"
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [745-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: Parse: BEGIN
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [746-1] 2019-07-02 16:42:54: pid 12617: LOG:  Bind message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [746-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: "", statement: ""
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [747-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: B message
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [748-1] 2019-07-02 16:42:54: pid 12617: LOG:  Execute message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [748-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [749-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: Execute: BEGIN
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [750-1] 2019-07-02 16:42:54: pid 12617: LOG:  Parse message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [750-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  statement: "", query: "SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM QRTZ_TRIGGER
S WHERE SCHED_NAME = 'MY_JOB_SCHEDULER' AND TRIGGER_STATE = $1 AND NEXT_FIRE_TIME <= $2 AND (MISFIRE_INSTR = -1 OR (MISFIRE_INSTR != -1 AND NEXT_FIRE_TIME >= $3)) ORDER BY NEXT_FIRE_TIME AS
C, PRIORITY DESC"
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [751-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: Parse: SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, P
RIORITY FROM QRTZ_TRIGGERS WHERE SCHED_NAME = 'MY_JOB_SCHEDULER' AND TRIGGER_STATE = $1 AND NEXT_FIRE_TIME <= $2 AND (MISFIRE_INSTR = -1 OR (MISFIRE_INSTR != -1 AND NEXT_FIRE_TIME >= $3)) O
RDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [752-1] 2019-07-02 16:42:54: pid 12617: LOG:  Bind message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [752-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: "C_3", statement: ""
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [753-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: B message
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [754-1] 2019-07-02 16:42:54: pid 12617: LOG:  Describe message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [754-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: "C_3"
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [755-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: D message
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [756-1] 2019-07-02 16:42:54: pid 12617: LOG:  Execute message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [756-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: "C_3"
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [757-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: Execute: SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME,
 PRIORITY FROM QRTZ_TRIGGERS WHERE SCHED_NAME = 'MY_JOB_SCHEDULER' AND TRIGGER_STATE = $1 AND NEXT_FIRE_TIME <= $2 AND (MISFIRE_INSTR = -1 OR (MISFIRE_INSTR != -1 AND NEXT_FIRE_TIME >= $3))
 ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [758-1] 2019-07-02 16:42:54: pid 12617: LOG:  Sync message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [759-1] 2019-07-02 16:42:54: pid 12617: LOG:  checking zapping sent message: 0x216cfc8 query_context: 0x2170048
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [760-1] 2019-07-02 16:42:54: pid 12617: LOG:  checking zapping sent message: 0x216cfd0 query_context: 0x216f838
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [761-1] 2019-07-02 16:42:54: pid 12617: LOG:  Zap sent message: 0x216cfd0
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [762-1] 2019-07-02 16:42:54: pid 12617: LOG:  checking zapping sent message: 0x216cfd8 query_context: 0x2172b98
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [763-1] 2019-07-02 16:42:54: pid 12617: LOG:  checking zapping sent message: 0x216cfe0 query_context: 0x2172b98
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [764-1] 2019-07-02 16:42:54: pid 12617: LOG:  Close message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [764-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: "C_3"
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [765-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: C message
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [766-1] 2019-07-02 16:42:54: pid 12617: LOG:  Bind message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [766-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: "", statement: "S_2"
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [767-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: B message
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [768-1] 2019-07-02 16:42:54: pid 12617: LOG:  Execute message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [768-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [769-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: Execute: COMMIT
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [770-1] 2019-07-02 16:42:54: pid 12617: LOG:  Sync message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [771-1] 2019-07-02 16:42:54: pid 12617: LOG:  Parse message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [771-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  statement: "", query: "SELECT 'x'"
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [772-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: Parse: SELECT 'x'
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [773-1] 2019-07-02 16:42:54: pid 12617: LOG:  Bind message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [773-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: "", statement: ""
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [774-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: B message
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [775-1] 2019-07-02 16:42:54: pid 12617: LOG:  Describe message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [775-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [776-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: D message
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [777-1] 2019-07-02 16:42:54: pid 12617: LOG:  Execute message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [777-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [778-1] 2019-07-02 16:42:54: pid 12617: LOG:  fetch from memory cache
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [778-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  query result fetched from cache. statement: SELECT 'x' 000000000000
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [779-1] 2019-07-02 16:42:54: pid 12617: LOG:  Sync message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [31-1] 2019-07-02 16:42:54: pid 26379: LOG:  Parse message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [31-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  statement: "", query: "SET extra_float_digits = 3"
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [32-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: Parse: SET extra_float_digits = 3
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [33-1] 2019-07-02 16:42:54: pid 26379: LOG:  Bind message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [33-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: "", statement: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [34-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: B message
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [35-1] 2019-07-02 16:42:54: pid 26379: LOG:  Execute message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [35-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [36-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: Execute: SET extra_float_digits = 3
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [37-1] 2019-07-02 16:42:54: pid 26379: LOG:  Sync message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [38-1] 2019-07-02 16:42:54: pid 26379: LOG:  Parse message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [38-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  statement: "", query: "SET application_name = 'PostgreSQL JDBC Driver'"
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [39-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: Parse: SET application_name = 'PostgreSQL JDBC Driver'
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [40-1] 2019-07-02 16:42:54: pid 26379: LOG:  Bind message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [40-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: "", statement: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [41-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: B message
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [42-1] 2019-07-02 16:42:54: pid 26379: LOG:  Execute message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [42-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [43-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: Execute: SET application_name = 'PostgreSQL JDBC Driver'
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [44-1] 2019-07-02 16:42:54: pid 26379: LOG:  Sync message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [45-1] 2019-07-02 16:42:54: pid 26379: LOG:  Parse message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [45-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  statement: "", query: "SELECT 'x'"
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [46-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: Parse: SELECT 'x'
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [47-1] 2019-07-02 16:42:54: pid 26379: LOG:  Bind message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [47-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: "", statement: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [48-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: B message
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [49-1] 2019-07-02 16:42:54: pid 26379: LOG:  Describe message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [49-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [50-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: D message
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [51-1] 2019-07-02 16:42:54: pid 26379: LOG:  Execute message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [51-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [52-1] 2019-07-02 16:42:54: pid 26379: LOG:  fetch from memory cache
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [52-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  query result fetched from cache. statement: SELECT 'x' 000000000000
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [53-1] 2019-07-02 16:42:54: pid 26379: LOG:  Sync message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [54-1] 2019-07-02 16:42:54: pid 26379: LOG:  Parse message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [54-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  statement: "", query: "SHOW TRANSACTION ISOLATION LEVEL"
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [55-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: Parse: SHOW TRANSACTION ISOLATION LEVEL
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [56-1] 2019-07-02 16:42:54: pid 26379: LOG:  Bind message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [56-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: "", statement: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [57-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: B message
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [58-1] 2019-07-02 16:42:54: pid 26379: LOG:  Describe message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [58-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [59-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: D message
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [60-1] 2019-07-02 16:42:54: pid 26379: LOG:  Execute message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [60-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [61-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: Execute: SHOW TRANSACTION ISOLATION LEVEL
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [62-1] 2019-07-02 16:42:54: pid 26379: LOG:  Sync message from frontend.
:[User Logs]:
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [743-1] 2019-07-02 16:42:54: pid 12617: LOG:  Sync message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [744-1] 2019-07-02 16:42:54: pid 12617: LOG:  Parse message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [744-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  statement: "", query: "BEGIN"
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [745-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: Parse: BEGIN
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [746-1] 2019-07-02 16:42:54: pid 12617: LOG:  Bind message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [746-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: "", statement: ""
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [747-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: B message
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [748-1] 2019-07-02 16:42:54: pid 12617: LOG:  Execute message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [748-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [749-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: Execute: BEGIN
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [750-1] 2019-07-02 16:42:54: pid 12617: LOG:  Parse message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [750-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  statement: "", query: "SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM QRTZ_TRIGGER
S WHERE SCHED_NAME = 'MY_JOB_SCHEDULER' AND TRIGGER_STATE = $1 AND NEXT_FIRE_TIME <= $2 AND (MISFIRE_INSTR = -1 OR (MISFIRE_INSTR != -1 AND NEXT_FIRE_TIME >= $3)) ORDER BY NEXT_FIRE_TIME AS
C, PRIORITY DESC"
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [751-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: Parse: SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, P
RIORITY FROM QRTZ_TRIGGERS WHERE SCHED_NAME = 'MY_JOB_SCHEDULER' AND TRIGGER_STATE = $1 AND NEXT_FIRE_TIME <= $2 AND (MISFIRE_INSTR = -1 OR (MISFIRE_INSTR != -1 AND NEXT_FIRE_TIME >= $3)) O
RDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [752-1] 2019-07-02 16:42:54: pid 12617: LOG:  Bind message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [752-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: "C_3", statement: ""
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [753-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: B message
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [754-1] 2019-07-02 16:42:54: pid 12617: LOG:  Describe message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [754-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: "C_3"
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [755-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: D message
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [756-1] 2019-07-02 16:42:54: pid 12617: LOG:  Execute message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [756-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: "C_3"
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [757-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: Execute: SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME,
 PRIORITY FROM QRTZ_TRIGGERS WHERE SCHED_NAME = 'MY_JOB_SCHEDULER' AND TRIGGER_STATE = $1 AND NEXT_FIRE_TIME <= $2 AND (MISFIRE_INSTR = -1 OR (MISFIRE_INSTR != -1 AND NEXT_FIRE_TIME >= $3))
 ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [758-1] 2019-07-02 16:42:54: pid 12617: LOG:  Sync message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [759-1] 2019-07-02 16:42:54: pid 12617: LOG:  checking zapping sent message: 0x216cfc8 query_context: 0x2170048
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [760-1] 2019-07-02 16:42:54: pid 12617: LOG:  checking zapping sent message: 0x216cfd0 query_context: 0x216f838
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [761-1] 2019-07-02 16:42:54: pid 12617: LOG:  Zap sent message: 0x216cfd0
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [762-1] 2019-07-02 16:42:54: pid 12617: LOG:  checking zapping sent message: 0x216cfd8 query_context: 0x2172b98
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [763-1] 2019-07-02 16:42:54: pid 12617: LOG:  checking zapping sent message: 0x216cfe0 query_context: 0x2172b98
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [764-1] 2019-07-02 16:42:54: pid 12617: LOG:  Close message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [764-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: "C_3"
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [765-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: C message
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [766-1] 2019-07-02 16:42:54: pid 12617: LOG:  Bind message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [766-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: "", statement: "S_2"
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [767-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: B message
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [768-1] 2019-07-02 16:42:54: pid 12617: LOG:  Execute message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [768-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [769-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: Execute: COMMIT
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [770-1] 2019-07-02 16:42:54: pid 12617: LOG:  Sync message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [771-1] 2019-07-02 16:42:54: pid 12617: LOG:  Parse message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [771-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  statement: "", query: "SELECT 'x'"
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [772-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: Parse: SELECT 'x'
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [773-1] 2019-07-02 16:42:54: pid 12617: LOG:  Bind message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [773-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: "", statement: ""
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [774-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: B message
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [775-1] 2019-07-02 16:42:54: pid 12617: LOG:  Describe message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [775-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [776-1] 2019-07-02 16:42:54: pid 12617: LOG:  DB node id: 0 backend pid: 26381 statement: D message
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [777-1] 2019-07-02 16:42:54: pid 12617: LOG:  Execute message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [777-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [778-1] 2019-07-02 16:42:54: pid 12617: LOG:  fetch from memory cache
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [778-2] 2019-07-02 16:42:54: pid 12617: DETAIL:  query result fetched from cache. statement: SELECT 'x' 000000000000
:Jul 02 16:42:54 pgsql1 pgpool[12617]: [779-1] 2019-07-02 16:42:54: pid 12617: LOG:  Sync message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [31-1] 2019-07-02 16:42:54: pid 26379: LOG:  Parse message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [31-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  statement: "", query: "SET extra_float_digits = 3"
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [32-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: Parse: SET extra_float_digits = 3
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [33-1] 2019-07-02 16:42:54: pid 26379: LOG:  Bind message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [33-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: "", statement: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [34-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: B message
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [35-1] 2019-07-02 16:42:54: pid 26379: LOG:  Execute message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [35-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [36-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: Execute: SET extra_float_digits = 3
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [37-1] 2019-07-02 16:42:54: pid 26379: LOG:  Sync message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [38-1] 2019-07-02 16:42:54: pid 26379: LOG:  Parse message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [38-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  statement: "", query: "SET application_name = 'PostgreSQL JDBC Driver'"
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [39-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: Parse: SET application_name = 'PostgreSQL JDBC Driver'
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [40-1] 2019-07-02 16:42:54: pid 26379: LOG:  Bind message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [40-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: "", statement: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [41-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: B message
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [42-1] 2019-07-02 16:42:54: pid 26379: LOG:  Execute message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [42-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [43-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: Execute: SET application_name = 'PostgreSQL JDBC Driver'
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [44-1] 2019-07-02 16:42:54: pid 26379: LOG:  Sync message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [45-1] 2019-07-02 16:42:54: pid 26379: LOG:  Parse message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [45-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  statement: "", query: "SELECT 'x'"
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [46-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: Parse: SELECT 'x'
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [47-1] 2019-07-02 16:42:54: pid 26379: LOG:  Bind message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [47-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: "", statement: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [48-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: B message
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [49-1] 2019-07-02 16:42:54: pid 26379: LOG:  Describe message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [49-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [50-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: D message
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [51-1] 2019-07-02 16:42:54: pid 26379: LOG:  Execute message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [51-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [52-1] 2019-07-02 16:42:54: pid 26379: LOG:  fetch from memory cache
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [52-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  query result fetched from cache. statement: SELECT 'x' 000000000000
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [53-1] 2019-07-02 16:42:54: pid 26379: LOG:  Sync message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [54-1] 2019-07-02 16:42:54: pid 26379: LOG:  Parse message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [54-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  statement: "", query: "SHOW TRANSACTION ISOLATION LEVEL"
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [55-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: Parse: SHOW TRANSACTION ISOLATION LEVEL
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [56-1] 2019-07-02 16:42:54: pid 26379: LOG:  Bind message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [56-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: "", statement: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [57-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: B message
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [58-1] 2019-07-02 16:42:54: pid 26379: LOG:  Describe message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [58-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [59-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: D message
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [60-1] 2019-07-02 16:42:54: pid 26379: LOG:  Execute message from frontend.
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [60-2] 2019-07-02 16:42:54: pid 26379: DETAIL:  portal: ""
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [61-1] 2019-07-02 16:42:54: pid 26379: LOG:  DB node id: 0 backend pid: 26418 statement: Execute: SHOW TRANSACTION ISOLATION LEVEL
:Jul 02 16:42:54 pgsql1 pgpool[26379]: [62-1] 2019-07-02 16:42:54: pid 26379: LOG:  Sync message from frontend.
mail.txt (61,841 bytes)
trace.txt (8,351 bytes)
[root@pgsql1 ccpp-2019-07-02-16:42:22-13955]# gdb pgpool ./coredump
GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-114.el7
Copyright (C) 2013 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu".
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>...
Reading symbols from /usr/pgpool-11/bin/pgpool...Reading symbols from /usr/lib/debug/usr/pgpool-11/bin/pgpool.debug...done.
done.
[New LWP 13955]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Core was generated by `pgpool: postgres testdb 192.168.28.71(58906) idle in transaction'.
Program terminated with signal 11, Segmentation fault.
#0  0x000000000043a9c8 in Execute (frontend=frontend@entry=0x2166fa8, backend=backend@entry=0x7f0cc1daf568, len=<optimized out>, contents=contents@entry=0x216d828 "C_5")
    at protocol/pool_proto_modules.c:889
889				session_context->query_context->skip_cache_commit = false;
(gdb) bt full
#0  0x000000000043a9c8 in Execute (frontend=frontend@entry=0x2166fa8, backend=backend@entry=0x7f0cc1daf568, len=<optimized out>, contents=contents@entry=0x216d828 "C_5")
    at protocol/pool_proto_modules.c:889
        status = <optimized out>
        search_query = 0x21ba4a0 "select aa10a1po0_.AAA100 as col_0_0_, aa10a1po0_.AAA101 as col_1_0_, aa10a1po0_.AAA102 as col_2_0_, aa10a1po0_.AAA103 as col_3_0_, aa10a1po0_.YAB003 as col_4_0_, aa10a1po0_.AAE120 as col_5_0_, aa10a1p"...
        len = <optimized out>
        commit = 0
        query = <optimized out>
        node = <optimized out>
        specific_error = 0
        session_context = 0x77aae0 <session_context_d>
        query_context = <optimized out>
        bind_msg = <optimized out>
        foundp = 0 '\000'
#1  0x000000000043f08e in ProcessFrontendResponse (frontend=frontend@entry=0x2166fa8, backend=backend@entry=0x7f0cc1daf568) at protocol/pool_proto_modules.c:2517
        node = <optimized out>
        parse_tree_list = <optimized out>
        old_context = 0x1
        query_context = <optimized out>
        query = <optimized out>
        error = 0 '\000'
        fkind = 69 'E'
        bufp = <optimized out>
        contents = 0x216d828 "C_5"
        status = <optimized out>
        len = 8
#2  0x0000000000431bd9 in read_packets_and_process (frontend=frontend@entry=0x2166fa8, backend=backend@entry=0x7f0cc1daf568, reset_request=reset_request@entry=0, 
    state=state@entry=0x7ffeae43d544, num_fields=num_fields@entry=0x7ffeae43d542, cont=cont@entry=0x7ffeae43d54c "\001") at protocol/pool_process_query.c:4922
        readmask = {fds_bits = {256, 0 <repeats 15 times>}}
        writemask = {fds_bits = {0 <repeats 16 times>}}
        exceptmask = {fds_bits = {0 <repeats 16 times>}}
        fds = <optimized out>
        timeoutdata = {tv_sec = 2, tv_usec = 35024808}
        timeout = <optimized out>
        num_fds = <optimized out>
        was_error = 0
        status = <optimized out>
        i = <optimized out>
        idle_count = 0
---Type <return> to continue, or q <return> to quit--- 
        idle_count_in_recovery = 0
#3  0x000000000043271b in pool_process_query (frontend=0x2166fa8, backend=0x7f0cc1daf568, reset_request=reset_request@entry=0) at protocol/pool_process_query.c:286
        cont = 1 '\001'
        num_fields = 0
        status = <optimized out>
        qcnt = 0
        i = <optimized out>
        ProcessQueryContext = 0x7f0cc1dbc468
        state = 0
#4  0x000000000042cf39 in do_child (fds=fds@entry=0x2161020) at protocol/child.c:392
        status = <optimized out>
        sp = <optimized out>
        saddr = {addr = {ss_family = 2, __ss_padding = "\346\032\300\250\034G", '\000' <repeats 111 times>, __ss_align = 0}, salen = 16}
        local_sigjmp_buf = {{__jmpbuf = {35000364, -4696962468673907309, 2, 0, 139692768874560, 2, 4696217772541711763, -4696958451181841005}, __mask_was_saved = 1, __saved_mask = {
              __val = {0, 139692738224130, 139692737082199, 140733120872449, 35010677, 35010677, 35010676, 35010676, 35010676, 35010676, 35010676, 35010677, 0, 0, 0, 0}}}}
        backend = 0x7f0cc1daf568
        now = {tv_sec = 1561453599, tv_usec = 681437}
        tz = {tz_minuteswest = 0, tz_dsttime = 0}
        timeout = {tv_sec = 0, tv_usec = 0}
        connected = 1
        connections_count = <optimized out>
        psbuf = "postgres testdb 192.168.28.71(58906) idle\000\000\256\376\177\000\000\002 \n\300\f\177\000\000W\263\370\277\f\177\000\000\001\200\255\373\000\000\000\000u8\026\002\000\000\000\000u8\026\002\000\000\000\000t8\026\002\000\000\000\000t8\026\002\000\000\000\000t8\026\002\000\000\000\000t8\026\002\000\000\000\000t8\026\002\000\000\000\000u8\026\002\000\000\000\000\305HF\000\000\000\000\000\000\000\000\061\061\061\060\070\005\000\000\000\n\000\000\000\062\060\061\071-06-25 17:06:39: pid 11108: WARNING:"...
        walk = <optimized out>
#5  0x00000000004090f5 in fork_a_child (fds=0x2161020, id=2) at main/pgpool_main.c:665
        pid = 0
#6  0x000000000040992f in reaper () at main/pgpool_main.c:2696
        new_pid = 0
        shutdown_system = 0 '\000'
        restart_child = 1 '\001'
        found = 1 '\001'
        status = 139
        i = 2
#7  0x000000000041041f in PgpoolMain (discard_status=discard_status@entry=1 '\001', clear_memcache_oidmaps=clear_memcache_oidmaps@entry=0 '\000') at main/pgpool_main.c:457
        i = 2
        local_sigjmp_buf = {{__jmpbuf = {1, -4696962475152009837, 9902, 140731822105168, 7, 2, 4696217772942267795, -4696958457666759277}, __mask_was_saved = 1, __saved_mask = {__val = {
                18446744066192964103, 0, 1, 16, 0, 262144, 5019159, 0, 139692766800170, 29, 140731822147424, 0, 281470681751424, 140731822139232, 4294967239, 139692736934221}}}}
        first = 0 '\000'
---Type <return> to continue, or q <return> to quit---
#8  0x00000000004077b7 in main (argc=<optimized out>, argv=<optimized out>) at main/main.c:349
        opt = <optimized out>
        debug_level = <optimized out>
        optindex = 0
        discard_status = 1 '\001'
        clear_memcache_oidmaps = 0 '\000'
        pcp_conf_file_path = "/etc/pgpool-II-11/pcp.conf", '\000' <repeats 8166 times>
        conf_file_path = "/etc/pgpool-II-11/pgpool.conf", '\000' <repeats 8163 times>
        hba_file_path = "/etc/pgpool-II-11/pool_hba.conf", '\000' <repeats 8161 times>
        pool_passwd_key_file_path = "/home/postgres/.pgpoolkey\000\321\037\001\213\356\267\031ͳK\350\000\277\026A5\r\n\000\000\000\000\021\000\000\000\034\000\000\000\004\000\000\000\b\000\000\000@\204\t\000\202!\020\240\250@\000\023\304Ё\030\002\"\030@\030\"D\v\200\030\b\001\">\226\002\034\000\000\000\035\000\000\000\037\000\000\000\"\000\000\000$\000\000\000'\000\000\000+\000\000\000\060\000\000\000\061\000\000\000\062\000\000\000\065\000\000\000\000\000\000\000\066\000\000\000\000\000\000\000\071\000\000\000<\000\000\000=\000\000\000\271\201\272\305\352\323\357\016\021\177\027\257\354\a\262\236\370\262E2\271\215\361\016f\267\251\177\331qX\034ʇ\345 bG\032"...
        long_options = {{name = 0x4abe72 "hba-file", has_arg = 1, flag = 0x0, val = 97}, {name = 0x4abe7b "debug", has_arg = 0, flag = 0x0, val = 100}, {name = 0x4abe81 "config-file", 
            has_arg = 1, flag = 0x0, val = 102}, {name = 0x4abe8d "key-file", has_arg = 1, flag = 0x0, val = 107}, {name = 0x4abe96 "pcp-file", has_arg = 1, flag = 0x0, val = 70}, {
            name = 0x4abe9f "help", has_arg = 0, flag = 0x0, val = 104}, {name = 0x4b0ded "mode", has_arg = 1, flag = 0x0, val = 109}, {name = 0x4abea4 "dont-detach", has_arg = 0, 
            flag = 0x0, val = 110}, {name = 0x4abeb0 "discard-status", has_arg = 0, flag = 0x0, val = 68}, {name = 0x4abebf "clear-oidmaps", has_arg = 0, flag = 0x0, val = 67}, {
            name = 0x4abecd "debug-assertions", has_arg = 0, flag = 0x0, val = 120}, {name = 0x4c93c8 "version", has_arg = 0, flag = 0x0, val = 118}, {name = 0x0, has_arg = 0, flag = 0x0, 
            val = 0}}
trace.txt (8,351 bytes)
java-log.txt (12,499 bytes)
org.hibernate.exception.JDBCConnectionException: could not execute query
        at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:115)
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
        at org.hibernate.loader.Loader.doList(Loader.java:2614)
        at org.hibernate.loader.Loader.doList(Loader.java:2594)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2423)
        at org.hibernate.loader.Loader.list(Loader.java:2418)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)
        at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
        at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
        at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1326)
        at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
        at com.yinhai.core.service.ta3.domain.dao.HibernateDAO.selectFildsList(HibernateDAO.java:439)
        at com.yinhai.modules.codetable.domain.dao.impl.Aa10a1DaoImpl.selectCodeList(Aa10a1DaoImpl.java:60)
        at com.yinhai.modules.codetable.domain.dao.impl.Aa10a1DaoImpl$$FastClassBySpringCGLIB$$6fcdd538.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:721)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:656)
        at com.yinhai.modules.codetable.domain.dao.impl.Aa10a1DaoImpl$$EnhancerBySpringCGLIB$$8f205e83.selectCodeList(<generated>)
        at com.yinhai.modules.codetable.domain.bpo.AppCodeBpoImpl.queryAppCode(AppCodeBpoImpl.java:67)
        at com.yinhai.modules.codetable.domain.bpo.AppCodeBpoImpl$$FastClassBySpringCGLIB$$e718e8c7.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:721)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:47)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:656)
        at com.yinhai.modules.codetable.domain.bpo.AppCodeBpoImpl$$EnhancerBySpringCGLIB$$dae6ca90.queryAppCode(<generated>)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
        at com.sun.proxy.$Proxy77.queryAppCode(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:47)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
        at com.sun.proxy.$Proxy77.queryAppCode(Unknown Source)
        at com.yinhai.modules.codetable.domain.bpo.AppCodeCacheBpoImpl.refreshAll(AppCodeCacheBpoImpl.java:141)
        at com.yinhai.modules.codetable.domain.bpo.AppCodeCacheBpoImpl$$FastClassBySpringCGLIB$$1b9a2859.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:721)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:47)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:656)
        at com.yinhai.modules.codetable.domain.bpo.AppCodeCacheBpoImpl$$EnhancerBySpringCGLIB$$7d05d2e3.refreshAll(<generated>)
        at com.yinhai.modules.codetable.domain.bpo.CodeTableInitService.initAppCode(CodeTableInitService.java:38)
        at com.yinhai.modules.codetable.domain.bpo.CodeTableInitService.init(CodeTableInitService.java:27)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1758)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1695)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:866)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542)
        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)
        at com.yinhai.project.listener.StartupListener.contextInitialized(StartupListener.java:18)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4861)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5322)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:753)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:729)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:974)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1850)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
        at org.postgresql.core.v3.QueryExecutorImpl.fetch(QueryExecutorImpl.java:2377)
        at org.postgresql.jdbc.PgResultSet.next(PgResultSet.java:1856)
        at com.alibaba.druid.filter.FilterChainImpl.resultSet_next(FilterChainImpl.java:654)
        at com.alibaba.druid.filter.FilterAdapter.resultSet_next(FilterAdapter.java:1885)
        at com.alibaba.druid.filter.FilterChainImpl.resultSet_next(FilterChainImpl.java:651)
        at com.alibaba.druid.proxy.jdbc.ResultSetProxyImpl.next(ResultSetProxyImpl.java:882)
        at com.alibaba.druid.pool.DruidPooledResultSet.next(DruidPooledResultSet.java:69)
        at org.hibernate.loader.Loader.processResultSet(Loader.java:968)
        at org.hibernate.loader.Loader.doQuery(Loader.java:930)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
        at org.hibernate.loader.Loader.doList(Loader.java:2611)
        ... 101 common frames omitted
Caused by: java.io.EOFException: null
        at org.postgresql.core.PGStream.receiveChar(PGStream.java:308)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1952)
        at org.postgresql.core.v3.QueryExecutorImpl.fetch(QueryExecutorImpl.java:2372)
        ... 111 common frames omitted
java-log.txt (12,499 bytes)

t-ishii

2019-07-02 18:50

developer   ~0002689

Thank for the info. It seems pgpool segfaults at the same place as before. Can you please try out attached patch?
It seems Pgpool-II may access wrong pointer.

t-ishii

2019-07-02 18:51

developer  

bug525.diff (790 bytes)
diff --git a/src/protocol/pool_proto_modules.c b/src/protocol/pool_proto_modules.c
index ac22f169..65788c34 100644
--- a/src/protocol/pool_proto_modules.c
+++ b/src/protocol/pool_proto_modules.c
@@ -872,7 +872,7 @@ Execute(POOL_CONNECTION * frontend, POOL_CONNECTION_POOL * backend,
 #endif
 			pool_ps_idle_display(backend);
 			pool_stats_count_up_num_cache_hits();
-			session_context->query_context->skip_cache_commit = true;
+			query_context->skip_cache_commit = true;
 #ifdef DEBUG
 			stop_now = true;
 #endif
@@ -886,7 +886,7 @@ Execute(POOL_CONNECTION * frontend, POOL_CONNECTION_POOL * backend,
 			}
 		}
 		else
-			session_context->query_context->skip_cache_commit = false;
+			query_context->skip_cache_commit = false;
 	}
 
 	session_context->query_context = query_context;
bug525.diff (790 bytes)

guobo507

2019-07-02 23:01

reporter   ~0002690

Thanks very much, but can you tell me how to use it? I have never patched pgpool-II...

t-ishii

2019-07-03 08:49

developer   ~0002691

Last edited: 2019-07-03 08:50

View 2 revisions

You need to install Pgpool-II from the source code. The instruction how to do it can be found in the manual:
http://www.pgpool.net/docs/latest/en/html/installation.html

Before going further, you can apply the patch like this:
tar xf pgpool-II-4.0.5.tar.gz
cd pgppool-II--4.0.5
patch -b -p1 < /path/to/bug525.diff
./configure ....

guobo507

2019-07-03 08:58

reporter   ~0002692

tks, i will try it later...

guobo507

2019-07-03 12:31

reporter   ~0002693

TKS for the patch, I have tested it on pgpool-II 4.0.3 and 4.0.5, both works fine.

t-ishii

2019-07-03 12:53

developer   ~0002694

Glad to hear that. I am going to commit the patch. Thanks!

Issue History

Date Modified Username Field Change
2019-06-25 14:28 guobo507 New Issue
2019-06-25 14:28 guobo507 Issue generated from: 0000523
2019-06-25 14:38 t-ishii Note Added: 0002674
2019-06-25 18:13 guobo507 File Added: mail-info.txt
2019-06-25 18:13 guobo507 File Added: stack-trace-pgpool.txt
2019-06-25 18:13 guobo507 Note Added: 0002676
2019-06-26 10:58 t-ishii Assigned To => t-ishii
2019-06-26 10:58 t-ishii Status new => assigned
2019-06-26 10:58 t-ishii Note Added: 0002681
2019-07-02 14:56 t-ishii Note Added: 0002686
2019-07-02 14:56 t-ishii Status assigned => feedback
2019-07-02 16:10 guobo507 Note Added: 0002687
2019-07-02 16:10 guobo507 Status feedback => assigned
2019-07-02 18:25 guobo507 File Added: mail.txt
2019-07-02 18:25 guobo507 File Added: trace.txt
2019-07-02 18:25 guobo507 File Added: java-log.txt
2019-07-02 18:25 guobo507 Note Added: 0002688
2019-07-02 18:50 t-ishii Note Added: 0002689
2019-07-02 18:51 t-ishii File Added: bug525.diff
2019-07-02 18:52 t-ishii Status assigned => feedback
2019-07-02 23:01 guobo507 Note Added: 0002690
2019-07-02 23:01 guobo507 Status feedback => assigned
2019-07-03 08:49 t-ishii Note Added: 0002691
2019-07-03 08:50 t-ishii Note Edited: 0002691 View Revisions
2019-07-03 08:51 t-ishii Status assigned => feedback
2019-07-03 08:58 guobo507 Note Added: 0002692
2019-07-03 08:58 guobo507 Status feedback => assigned
2019-07-03 12:31 guobo507 Note Added: 0002693
2019-07-03 12:53 t-ishii Note Added: 0002694
2019-07-03 12:54 t-ishii Status assigned => resolved
2019-07-03 12:54 t-ishii Target Version => 4.0.6
2019-08-15 19:15 administrator Fixed in Version => 4.0.6