View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000258Pgpool-IIGeneralpublic2016-10-30 07:542017-04-07 15:42
Reportertomka Assigned Topengbo  
PrioritylowSeverityminorReproducibilityalways
Status closedResolutionopen 
PlatformLinuxOSRHELOS Version7.2
Summary0000258: While attaching nodes in replication mode "show pool_nodes" is showing different values on each node
DescriptionHi All,

I have inherited a pgpool cluster in my company having (PostgreSQL) 9.2.14 with pgpool-II in replication and load balancing on.

Recently networks team cold rebooted the main switch causing replication to go to failover state (replication_stop_on_mismatch = on + failover_if_affected_tuples_mismatch = on).

I falloved tutorial in google translated japanese here http://lets.postgresql.jp/documents/technical/pgpool/2/ to make a recovery:

 
Stopped all services, stopped pgpool, stoped postgres, copied the data folder of postgres to degenerated node, started postgres, started pgpool.

 

How ever after making changes at port 9999 these are being transitioned only to node1 a 5432 because of that load balancing is not working and node1 is handling all the requests.

While trouble shooting attaching node2 with pcp_attach_node actually changes server status from 3 to 2. But this is only happening on node2

bash-4.2$ /usr/local/bin/pcp_attach_node -d 10 srvmtitatl02 9898 postgres postgres 1
 
show nodes on node1

 node_id | hostname | port | status | lb_weight | role
---------+----------------------------+------+--------+-----------+--------
 0 | srvmtitatl01 | 5432 | 2 | 0.500000 | master
 1 | srvmtitatl02 | 5432 | 3 | 0.500000 | slave
(2 rows)

show nodes on node2

 node_id | hostname | port | status | lb_weight | role
---------+----------------------------+------+--------+-----------+--------
 0 | srvmtitatl01 | 5432 | 2 | 0.500000 | master
 1 | srvmtitatl02 | 5432 | 2 | 0.500000 | slave
(2 rows)

Any help will be most appreciated.



Thanks,



Tom
Additional Information# ----------------------------

# pgPool-II configuration file

# ----------------------------

#

# This file consists of lines of the form:

#

# name = value

#

# Whitespace may be used. Comments are introduced with "#" anywhere on a line.

# The complete list of parameter names and allowed values can be found in the

# pgPool-II documentation.

#

# This file is read on server startup and when the server receives a SIGHUP

# signal. If you edit the file on a running system, you have to SIGHUP the

# server for the changes to take effect, or use "pgpool reload". Some

# parameters, which are marked below, require a server shutdown and restart to

# take effect.

#

 

 

#------------------------------------------------------------------------------

# CONNECTIONS

#------------------------------------------------------------------------------

 

# - pgpool Connection Settings -

 

listen_addresses = '*'

                                   # Host name or IP address to listen on:

                                   # '*' for all, '' for no TCP/IP connections

                                   # (change requires restart)

port = 9999

                                   # Port number

                                   # (change requires restart)

socket_dir = '/var/run/postgresql'

                                   # Unix domain socket path

                                   # The Debian package defaults to

                                   # /var/run/postgresql

                                   # (change requires restart)

listen_backlog_multiplier = 2

                                   # Set the backlog parameter of listen(2) to

                                                                                                                                   # num_init_children * listen_backlog_multiplier.

                                   # (change requires restart)

 

# - pgpool Communication Manager Connection Settings -

 

pcp_listen_addresses = '*'

                                   # Host name or IP address for pcp process to listen on:

                                   # '*' for all, '' for no TCP/IP connections

                                   # (change requires restart)

pcp_port = 9898

                                   # Port number for pcp

                                   # (change requires restart)

pcp_socket_dir = '/var/run/postgresql'

                                   # Unix domain socket path for pcp

                                   # The Debian package defaults to

                                   # /var/run/postgresql

                                   # (change requires restart)

 

# - Backend Connection Settings -

 

#backend_hostname0 = 'host1'

                                   # Host name or IP address to connect to for backend 0

#backend_port0 = 5432

                                   # Port number for backend 0

#backend_weight0 = 1

                                   # Weight for backend 0 (only in load balancing mode)

#backend_data_directory0 = '/data'

                                   # Data directory for backend 0

#backend_flag0 = 'ALLOW_TO_FAILOVER'

                                   # Controls various backend behavior

                                   # ALLOW_TO_FAILOVER or DISALLOW_TO_FAILOVER

#backend_hostname1 = 'host2'

#backend_port1 = 5433

#backend_weight1 = 1

#backend_data_directory1 = '/data1'

#backend_flag1 = 'ALLOW_TO_FAILOVER'

 

backend_hostname0 = 'srvmtitatl01'

backend_port0 = 5432

backend_weight0 = 1

 

backend_hostname1 = 'srvmtitatl02'

backend_port1 = 5432

backend_weight1 = 1

 

# - Authentication -

 

enable_pool_hba = off

                                   # Use pool_hba.conf for client authentication

pool_passwd = 'pool_passwd'

                                   # File name of pool_passwd for md5 authentication.

                                   # "" disables pool_passwd.

                                   # (change requires restart)

authentication_timeout = 60

                                   # Delay in seconds to complete client authentication

                                   # 0 means no timeout.

 

# - SSL Connections -

 

ssl = off

                                   # Enable SSL support

                                   # (change requires restart)

#ssl_key = './server.key'

                                   # Path to the SSL private key file

                                   # (change requires restart)

#ssl_cert = './server.cert'

                                   # Path to the SSL public certificate file

                                   # (change requires restart)

#ssl_ca_cert = ''

                                   # Path to a single PEM format file

                                   # containing CA root certificate(s)

                                   # (change requires restart)

#ssl_ca_cert_dir = ''

                                   # Directory containing CA root certificate(s)

                                   # (change requires restart)

 

 

#------------------------------------------------------------------------------

# POOLS

#------------------------------------------------------------------------------

 

# - Pool size -

 

num_init_children = 64

                                   # Number of pools

                                   # (change requires restart)

max_pool = 4

                                   # Number of connections per pool

                                   # (change requires restart)

 

# - Life time -

 

child_life_time = 300

                                   # Pool exits after being idle for this many seconds

child_max_connections = 0

                                   # Pool exits after receiving that many connections

                                   # 0 means no exit

connection_life_time = 0

                                   # Connection to backend closes after being idle for this many seconds

                                   # 0 means no close

client_idle_limit = 0

                                   # Client is disconnected after being idle for that many seconds

                                   # (even inside an explicit transactions!)

                                   # 0 means no disconnection

 

 

#------------------------------------------------------------------------------

# LOGS

#------------------------------------------------------------------------------

 

# - Where to log -

 

log_destination = 'stderr'

                                   # Where to log

                                   # Valid values are combinations of stderr,

                                   # and syslog. Default to stderr.

 

# - What to log -

 

log_line_prefix = '%t: pid %p: ' # printf-style string to output at beginning of each log line.

 

log_connections = off

                                   # Log connections

log_hostname = off

                                   # Hostname will be shown in ps status

                                   # and in logs if connections are logged

log_statement = off

                                   # Log all statements

log_per_node_statement = off

                                   # Log all statements

                                   # with node and backend informations

log_standby_delay = 'none'

                                   # Log standby delay

                                   # Valid values are combinations of always,

                                   # if_over_threshold, none

 

# - Syslog specific -

 

syslog_facility = 'LOCAL0'

                                   # Syslog local facility. Default to LOCAL0

syslog_ident = 'pgpool'

                                   # Syslog program identification string

                                   # Default to 'pgpool'

 

# - Debug -

 

debug_level = 0

                                   # Debug message verbosity level

                                   # 0 means no message, 1 or more mean verbose

 

#log_error_verbosity = default # terse, default, or verbose messages

 

#client_min_messages = notice # values in order of decreasing detail:

                                        # debug5

                                        # debug4

                                        # debug3

                                        # debug2

                                        # debug1

                                        # log

                                        # notice

                                        # warning

                                        # error

 

#log_min_messages = warning # values in order of decreasing detail:

                                        # debug5

                                        # debug4

                                        # debug3

                                        # debug2

                                        # debug1

                                        # info

                                        # notice

                                        # warning

                                        # error

                                        # log

                                        # fatal

                                        # panic

 

#------------------------------------------------------------------------------

# FILE LOCATIONS

#------------------------------------------------------------------------------

 

pid_file_name = '/tmp/pgpool.pid'

                                   # PID file name

                                   # (change requires restart)

logdir = '/tmp'

                                   # Directory of pgPool status file

                                   # (change requires restart)

 

 

#------------------------------------------------------------------------------

# CONNECTION POOLING

#------------------------------------------------------------------------------

 

connection_cache = on

                                   # Activate connection pools

                                   # (change requires restart)

 

                                   # Semicolon separated list of queries

                                   # to be issued at the end of a session

                                   # The default is for 8.3 and later

reset_query_list = 'ABORT; DISCARD ALL'

                                   # The following one is for 8.2 and before

#reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'

 

 

#------------------------------------------------------------------------------

# REPLICATION MODE

#------------------------------------------------------------------------------

 

replication_mode = on

                                   # Activate replication mode

                                   # (change requires restart)

replicate_select = off

                                   # Replicate SELECT statements

                                   # when in replication mode

                                   # replicate_select is higher priority than

                                   # load_balance_mode.

 

insert_lock = on

                                   # Automatically locks a dummy row or a table

                                   # with INSERT statements to keep SERIAL data

                                   # consistency

                                   # Without SERIAL, no lock will be issued

lobj_lock_table = ''

                                   # When rewriting lo_creat command in

                                   # replication mode, specify table name to

                                   # lock

 

# - Degenerate handling -

 

replication_stop_on_mismatch = on

                                   # On disagreement with the packet kind

                                   # sent from backend, degenerate the node

                                   # which is most likely "minority"

                                   # If off, just force to exit this session

 

failover_if_affected_tuples_mismatch = on

                                   # On disagreement with the number of affected

                                   # tuples in UPDATE/DELETE queries, then

                                   # degenerate the node which is most likely

                                   # "minority".

                                   # If off, just abort the transaction to

                                   # keep the consistency

 

 

#------------------------------------------------------------------------------

# LOAD BALANCING MODE

#------------------------------------------------------------------------------

 

load_balance_mode = on

                                   # Activate load balancing mode

                                   # (change requires restart)

ignore_leading_white_space = on

                                   # Ignore leading white spaces of each query

white_function_list = ''

                                   # Comma separated list of function names

                                   # that don't write to database

                                   # Regexp are accepted

black_function_list = 'nextval,setval'

                                   # Comma separated list of function names

                                   # that write to database

                                   # Regexp are accepted

 

database_redirect_preference_list = ''

                                                                                                                                   # comma separated list of pairs of database and node id.

                                                                                                                                   # example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'

                                                                                                                                   # valid for streaming replicaton mode only.

 

app_name_redirect_preference_list = ''

                                                                                                                                   # comma separated list of pairs of app name and node id.

                                                                                                                                   # example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'

                                                                                                                                   # valid for streaming replicaton mode only.

allow_sql_comments = off

                                                                                                                                   # if on, ignore SQL comments when judging if load balance or

                                                                                                                                   # query cache is possible.

                                                                                                                                   # If off, SQL comments effectively prevent the judgment

                                                                                                                                   # (pre 3.4 behavior).

 

#------------------------------------------------------------------------------

# MASTER/SLAVE MODE

#------------------------------------------------------------------------------

 

master_slave_mode = off

                                   # Activate master/slave mode

                                   # (change requires restart)

master_slave_sub_mode = 'slony'

                                   # Master/slave sub mode

                                   # Valid values are combinations slony or

                                   # stream. Default is slony.

                                   # (change requires restart)

 

# - Streaming -

 

sr_check_period = 0

                                   # Streaming replication check period

                                   # Disabled (0) by default

sr_check_user = 'nobody'

                                   # Streaming replication check user

                                   # This is neccessary even if you disable streaming

                                   # replication delay check by sr_check_period = 0

sr_check_password = ''

                                   # Password for streaming replication check user

delay_threshold = 0

                                   # Threshold before not dispatching query to standby node

                                   # Unit is in bytes

                                   # Disabled (0) by default

 

# - Special commands -

 

follow_master_command = ''

                                   # Executes this command after master failover

                                   # Special values:

                                   # %d = node id

                                   # %h = host name

                                   # %p = port number

                                   # %D = database cluster path

                                   # %m = new master node id

                                   # %H = hostname of the new master node

                                   # %M = old master node id

                                   # %P = old primary node id

                                                                                                                                   # %r = new master port number

                                                                                                                                   # %R = new master database cluster path

                                   # %% = '%' character

 

#------------------------------------------------------------------------------

# HEALTH CHECK

#------------------------------------------------------------------------------

 

health_check_period = 0

                                   # Health check period

                                   # Disabled (0) by default

health_check_timeout = 20

                                   # Health check timeout

                                   # 0 means no timeout

health_check_user = 'nobody'

                                   # Health check user

health_check_password = ''

                                   # Password for health check user

health_check_max_retries = 0

                                   # Maximum number of times to retry a failed health check before giving up.

health_check_retry_delay = 1

                                   # Amount of time to wait (in seconds) between retries.

connect_timeout = 10000

                                   # Timeout value in milliseconds before giving up to connect to backend.

                                                                                                                                   # Default is 10000 ms (10 second). Flaky network user may want to increase

                                                                                                                                   # the value. 0 means no timeout.

                                                                                                                                   # Note that this value is not only used for health check,

                                                                                                                                   # but also for ordinary conection to backend.

 

#------------------------------------------------------------------------------

# FAILOVER AND FAILBACK

#------------------------------------------------------------------------------

 

failover_command = ''

                                   # Executes this command at failover

                                   # Special values:

                                   # %d = node id

                                   # %h = host name

                                   # %p = port number

                                   # %D = database cluster path

                                   # %m = new master node id

                                   # %H = hostname of the new master node

                                   # %M = old master node id

                                   # %P = old primary node id

                                                                                                                                   # %r = new master port number

                                                                                                                                   # %R = new master database cluster path

                                   # %% = '%' character

failback_command = ''

                                   # Executes this command at failback.

                                   # Special values:

                                   # %d = node id

                                   # %h = host name

                                   # %p = port number

                                   # %D = database cluster path

                                   # %m = new master node id

                                   # %H = hostname of the new master node

                                   # %M = old master node id

                                   # %P = old primary node id

                                                                                                                                   # %r = new master port number

                                                                                                                                   # %R = new master database cluster path

                                   # %% = '%' character

 

fail_over_on_backend_error = on

                                   # Initiates failover when reading/writing to the

                                   # backend communication socket fails

                                   # If set to off, pgpool will report an

                                   # error and disconnect the session.

 

search_primary_node_timeout = 10

                                   # Timeout in seconds to search for the

                                   # primary node when a failover occurs.

                                   # 0 means no timeout, keep searching

                                   # for a primary node forever.

 

#------------------------------------------------------------------------------

# ONLINE RECOVERY

#------------------------------------------------------------------------------

 

recovery_user = 'nobody'

                                   # Online recovery user

recovery_password = ''

                                   # Online recovery password

recovery_1st_stage_command = ''

                                   # Executes a command in first stage

recovery_2nd_stage_command = ''

                                   # Executes a command in second stage

recovery_timeout = 90

                                   # Timeout in seconds to wait for the

                                   # recovering node's postmaster to start up

                                   # 0 means no wait

client_idle_limit_in_recovery = 0

                                   # Client is disconnected after being idle

                                   # for that many seconds in the second stage

                                   # of online recovery

                                   # 0 means no disconnection

                                   # -1 means immediate disconnection

 

 

#------------------------------------------------------------------------------

# WATCHDOG

#------------------------------------------------------------------------------

 

# - Enabling -

 

use_watchdog = off

                                    # Activates watchdog

                                    # (change requires restart)

 

# -Connection to up stream servers -

 

trusted_servers = ''

                                    # trusted server list which are used

                                    # to confirm network connection

                                    # (hostA,hostB,hostC,...)

                                    # (change requires restart)

ping_path = '/bin'

                                    # ping command path

                                    # (change requires restart)

 

# - Watchdog communication Settings -

 

wd_hostname = ''

                                    # Host name or IP address of this watchdog

                                    # (change requires restart)

wd_port = 9000

                                    # port number for watchdog service

                                    # (change requires restart)

wd_authkey = ''

                                    # Authentication key for watchdog communication

                                    # (change requires restart)

 

# - Virtual IP control Setting -

 

delegate_IP = ''

                                    # delegate IP address

                                    # If this is empty, virtual IP never bring up.

                                    # (change requires restart)

ifconfig_path = '/sbin'

                                    # ifconfig command path

                                    # (change requires restart)

if_up_cmd = 'ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0'

                                    # startup delegate IP command

                                    # (change requires restart)

if_down_cmd = 'ifconfig eth0:0 down'

                                    # shutdown delegate IP command

                                    # (change requires restart)

 

arping_path = '/usr/sbin' # arping command path

                                    # (change requires restart)

 

arping_cmd = 'arping -U $_IP_$ -w 1'

                                    # arping command

                                    # (change requires restart)

 

# - Behaivor on escalation Setting -

 

clear_memqcache_on_escalation = on

                                    # Clear all the query cache on shared memory

                                    # when standby pgpool escalate to active pgpool

                                    # (= virtual IP holder).

                                    # This should be off if client connects to pgpool

                                    # not using virtual IP.

                                    # (change requires restart)

wd_escalation_command = ''

                                    # Executes this command at escalation on new active pgpool.

                                    # (change requires restart)

 

# - Lifecheck Setting -

 

# -- common --

 

wd_lifecheck_method = 'heartbeat'

                                    # Method of watchdog lifecheck ('heartbeat' or 'query')

                                    # (change requires restart)

wd_interval = 10

                                    # lifecheck interval (sec) > 0

                                    # (change requires restart)

 

# -- heartbeat mode --

 

wd_heartbeat_port = 9694

                                    # Port number for receiving heartbeat signal

                                    # (change requires restart)

wd_heartbeat_keepalive = 2

                                    # Interval time of sending heartbeat signal (sec)

                                    # (change requires restart)

wd_heartbeat_deadtime = 30

                                    # Deadtime interval for heartbeat signal (sec)

                                    # (change requires restart)

heartbeat_destination0 = 'host0_ip1'

                                    # Host name or IP address of destination 0

                                    # for sending heartbeat signal.

                                    # (change requires restart)

heartbeat_destination_port0 = 9694

                                    # Port number of destination 0 for sending

                                    # heartbeat signal. Usually this is the

                                    # same as wd_heartbeat_port.

                                    # (change requires restart)

heartbeat_device0 = ''

                                    # Name of NIC device (such like 'eth0')

                                    # used for sending/receiving heartbeat

                                    # signal to/from destination 0.

                                    # This works only when this is not empty

                                    # and pgpool has root privilege.

                                    # (change requires restart)

 

#heartbeat_destination1 = 'host0_ip2'

#heartbeat_destination_port1 = 9694

#heartbeat_device1 = ''

 

# -- query mode --

 

wd_life_point = 3

                                    # lifecheck retry times

                                    # (change requires restart)

wd_lifecheck_query = 'SELECT 1'

                                    # lifecheck query to pgpool from watchdog

                                    # (change requires restart)

wd_lifecheck_dbname = 'template1'

                                    # Database name connected for lifecheck

                                    # (change requires restart)

wd_lifecheck_user = 'nobody'

                                    # watchdog user monitoring pgpools in lifecheck

                                    # (change requires restart)

wd_lifecheck_password = ''

                                    # Password for watchdog user in lifecheck

                                    # (change requires restart)

 

# - Other pgpool Connection Settings -

 

#other_pgpool_hostname0 = 'host0'

                                    # Host name or IP address to connect to for other pgpool 0

                                    # (change requires restart)

#other_pgpool_port0 = 5432

                                    # Port number for othet pgpool 0

                                    # (change requires restart)

#other_wd_port0 = 9000

                                    # Port number for othet watchdog 0

                                    # (change requires restart)

#other_pgpool_hostname1 = 'host1'

#other_pgpool_port1 = 5432

#other_wd_port1 = 9000

 

 

#------------------------------------------------------------------------------

# OTHERS

#------------------------------------------------------------------------------

relcache_expire = 0

                                   # Life time of relation cache in seconds.

                                   # 0 means no cache expiration(the default).

                                   # The relation cache is used for cache the

                                   # query result against PostgreSQL system

                                  # catalog to obtain various information

                                   # including table structures or if it's a

                                   # temporary table or not. The cache is

                                   # maintained in a pgpool child local memory

                                   # and being kept as long as it survives.

                                   # If someone modify the table by using

                                   # ALTER TABLE or some such, the relcache is

                                   # not consistent anymore.

                                   # For this purpose, cache_expiration

                                   # controls the life time of the cache.

relcache_size = 256

                                   # Number of relation cache

                                   # entry. If you see frequently:

                                                                                                                                   # "pool_search_relcache: cache replacement happend"

                                                                                                                                   # in the pgpool log, you might want to increate this number.

 

check_temp_table = on

                                   # If on, enable temporary table check in SELECT statements.

                                   # This initiates queries against system catalog of primary/master

                                                                                                                                   # thus increases load of master.

                                                                                                                                   # If you are absolutely sure that your system never uses temporary tables

                                                                                                                                   # and you want to save access to primary/master, you could turn this off.

                                                                                                                                   # Default is on.

 

check_unlogged_table = on

                                   # If on, enable unlogged table check in SELECT statements.

                                   # This initiates queries against system catalog of primary/master

                                   # thus increases load of master.

                                   # If you are absolutely sure that your system never uses unlogged tables

                                   # and you want to save access to primary/master, you could turn this off.

                                   # Default is on.

 

#------------------------------------------------------------------------------

# IN MEMORY QUERY MEMORY CACHE

#------------------------------------------------------------------------------

memory_cache_enabled = off

                                                                                                                                   # If on, use the memory cache functionality, off by default

memqcache_method = 'shmem'

                                                                                                                                   # Cache storage method. either 'shmem'(shared memory) or

                                                                                                                                   # 'memcached'. 'shmem' by default

                                   # (change requires restart)

memqcache_memcached_host = 'localhost'

                                                                                                                                   # Memcached host name or IP address. Mandatory if

                                                                                                                                   # memqcache_method = 'memcached'.

                                                                                                                                   # Defaults to localhost.

                                   # (change requires restart)

memqcache_memcached_port = 11211

                                                                                                                                   # Memcached port number. Mondatory if memqcache_method = 'memcached'.

                                                                                                                                   # Defaults to 11211.

                                   # (change requires restart)

memqcache_total_size = 67108864

                                                                                                                                  # Total memory size in bytes for storing memory cache.

                                                                                                                                   # Mandatory if memqcache_method = 'shmem'.

                                                                                                                                   # Defaults to 64MB.

                                   # (change requires restart)

memqcache_max_num_cache = 1000000

                                                                                                                                   # Total number of cache entries. Mandatory

                                                                                                                                   # if memqcache_method = 'shmem'.

                                                                                                                                   # Each cache entry consumes 48 bytes on shared memory.

                                                                                                                                   # Defaults to 1,000,000(45.8MB).

                                   # (change requires restart)

memqcache_expire = 0

                                                                                                                                   # Memory cache entry life time specified in seconds.

                                                                                                                                   # 0 means infinite life time. 0 by default.

                                   # (change requires restart)

memqcache_auto_cache_invalidation = on

                                                                                                                                   # If on, invalidation of query cache is triggered by corresponding

                                                                                                                                   # DDL/DML/DCL(and memqcache_expire). If off, it is only triggered

                                                                                                                                   # by memqcache_expire. on by default.

                                   # (change requires restart)

memqcache_maxcache = 409600

                                                                                                                                   # Maximum SELECT result size in bytes.

                                                                                                                                   # Must be smaller than memqcache_cache_block_size. Defaults to 400KB.

                                   # (change requires restart)

memqcache_cache_block_size = 1048576

                                                                                                                                   # Cache block size in bytes. Mandatory if memqcache_method = 'shmem'.

                                                                                                                                   # Defaults to 1MB.

                                   # (change requires restart)

memqcache_oiddir = '/var/log/pgpool/oiddir'

                                                                                                                                   # Temporary work directory to record table oids

                                   # (change requires restart)

white_memqcache_table_list = ''

                                   # Comma separated list of table names to memcache

                                   # that don't write to database

                                   # Regexp are accepted

black_memqcache_table_list = ''

                                   # Comma separated list of table names not to memcache

                                   # that don't write to database

                                   # Regexp are accepted
TagsNo tags attached.

Activities

tomka

2016-10-30 07:58

reporter   ~0001142

2016-10-30 00:32:07: pid 4452: LOG: child process with pid: 4925 exits with status 0
2016-10-30 00:32:07: pid 4452: LOG: child process with pid: 4925 exited with success and will not be restarted
2016-10-30 00:32:07: pid 4452: DEBUG: child process with pid: 4926 exit with SUCCESS. child will not be restarted
2016-10-30 00:32:07: pid 4452: LOG: child process with pid: 4926 exits with status 0
2016-10-30 00:32:07: pid 4452: LOG: child process with pid: 4926 exited with success and will not be restarted
2016-10-30 00:32:07: pid 4452: LOG: worker child process with pid: 4928 exits with status 256
2016-10-30 00:32:07: pid 4452: LOG: fork a new worker child process with pid: 5004
2016-10-30 00:32:07: pid 4452: DEBUG: reaper handler: exiting normally
2016-10-30 00:32:07: pid 5004: DEBUG: I am 5004
2016-10-30 00:32:07: pid 5004: DEBUG: initializing backend status
2016-10-30 00:32:24: pid 4998: DEBUG: I am 4998 accept fd 7
2016-10-30 00:32:24: pid 4998: DEBUG: reading startup packet
2016-10-30 00:32:24: pid 4998: DETAIL: application_name: psql
2016-10-30 00:32:24: pid 4998: DEBUG: reading startup packet
2016-10-30 00:32:24: pid 4998: DETAIL: Protocol Major: 3 Minor: 0 database: postgres user: postgres
2016-10-30 00:32:24: pid 4998: DEBUG: creating new connection to backend
2016-10-30 00:32:24: pid 4998: DETAIL: connecting 0 backend
2016-10-30 00:32:24: pid 4998: DEBUG: creating new connection to backend
2016-10-30 00:32:24: pid 4998: DETAIL: connecting 1 backend
2016-10-30 00:32:24: pid 4998: DEBUG: creating new connection to backend
2016-10-30 00:32:24: pid 4998: DETAIL: skipping backend slot 1 because backend_status = 3
2016-10-30 00:32:24: pid 4998: DEBUG: SSL is requested but SSL support is not available
2016-10-30 00:32:24: pid 4998: DEBUG: reading message length
2016-10-30 00:32:24: pid 4998: DETAIL: slot: 0 length: 8
2016-10-30 00:32:24: pid 4998: DEBUG: authentication backend
2016-10-30 00:32:24: pid 4998: DETAIL: auth kind:0
2016-10-30 00:32:24: pid 4998: DEBUG: reading message length
2016-10-30 00:32:24: pid 4998: DETAIL: master slot: 0 length: 26
2016-10-30 00:32:24: pid 4998: DEBUG: process parameter status
2016-10-30 00:32:24: pid 4998: DETAIL: backend:0 name:"application_name" value:"psql"
2016-10-30 00:32:24: pid 4998: DEBUG: reading message length
2016-10-30 00:32:24: pid 4998: DETAIL: master slot: 0 length: 25
2016-10-30 00:32:24: pid 4998: DEBUG: process parameter status
2016-10-30 00:32:24: pid 4998: DETAIL: backend:0 name:"client_encoding" value:"UTF8"
2016-10-30 00:32:24: pid 4998: DEBUG: reading message length
2016-10-30 00:32:24: pid 4998: DETAIL: master slot: 0 length: 23
2016-10-30 00:32:24: pid 4998: DEBUG: process parameter status
2016-10-30 00:32:24: pid 4998: DETAIL: backend:0 name:"DateStyle" value:"ISO, DMY"
2016-10-30 00:32:24: pid 4998: DEBUG: reading message length
2016-10-30 00:32:24: pid 4998: DETAIL: master slot: 0 length: 25
2016-10-30 00:32:24: pid 4998: DEBUG: process parameter status
2016-10-30 00:32:24: pid 4998: DETAIL: backend:0 name:"integer_datetimes" value:"on"
2016-10-30 00:32:24: pid 4998: DEBUG: reading message length
2016-10-30 00:32:24: pid 4998: DETAIL: master slot: 0 length: 27
2016-10-30 00:32:24: pid 4998: DEBUG: process parameter status
2016-10-30 00:32:24: pid 4998: DETAIL: backend:0 name:"IntervalStyle" value:"postgres"
2016-10-30 00:32:24: pid 4998: DEBUG: reading message length
2016-10-30 00:32:24: pid 4998: DETAIL: master slot: 0 length: 20
2016-10-30 00:32:24: pid 4998: DEBUG: process parameter status
2016-10-30 00:32:24: pid 4998: DETAIL: backend:0 name:"is_superuser" value:"on"
2016-10-30 00:32:24: pid 4998: DEBUG: reading message length
2016-10-30 00:32:24: pid 4998: DETAIL: master slot: 0 length: 25
2016-10-30 00:32:24: pid 4998: DEBUG: process parameter status
2016-10-30 00:32:24: pid 4998: DETAIL: backend:0 name:"server_encoding" value:"UTF8"
2016-10-30 00:32:24: pid 4998: DEBUG: reading message length
2016-10-30 00:32:24: pid 4998: DETAIL: master slot: 0 length: 26
2016-10-30 00:32:24: pid 4998: DEBUG: process parameter status
2016-10-30 00:32:24: pid 4998: DETAIL: backend:0 name:"server_version" value:"9.2.14"
2016-10-30 00:32:24: pid 4998: DEBUG: reading message length
2016-10-30 00:32:24: pid 4998: DETAIL: master slot: 0 length: 35
2016-10-30 00:32:24: pid 4998: DEBUG: process parameter status
2016-10-30 00:32:24: pid 4998: DETAIL: backend:0 name:"session_authorization" value:"postgres"
2016-10-30 00:32:24: pid 4998: DEBUG: reading message length
2016-10-30 00:32:24: pid 4998: DETAIL: master slot: 0 length: 35
2016-10-30 00:32:24: pid 4998: DEBUG: process parameter status
2016-10-30 00:32:24: pid 4998: DETAIL: backend:0 name:"standard_conforming_strings" value:"on"
2016-10-30 00:32:24: pid 4998: DEBUG: reading message length
2016-10-30 00:32:24: pid 4998: DETAIL: master slot: 0 length: 26
2016-10-30 00:32:24: pid 4998: DEBUG: process parameter status
2016-10-30 00:32:24: pid 4998: DETAIL: backend:0 name:"TimeZone" value:"Europe/Malta"
2016-10-30 00:32:24: pid 4998: DEBUG: reading message length
2016-10-30 00:32:24: pid 4998: DETAIL: slot: 0 length: 12
2016-10-30 00:32:24: pid 4998: DEBUG: authentication backend
2016-10-30 00:32:24: pid 4998: DETAIL: cp->info[i]:0x7fe107adf000 pid:5009
2016-10-30 00:32:24: pid 4998: DEBUG: sending backend key data
2016-10-30 00:32:24: pid 4998: DETAIL: send pid 5009 to frontend
2016-10-30 00:32:24: pid 4998: DEBUG: selecting load balance node
2016-10-30 00:32:24: pid 4998: DETAIL: selected backend id is 0
2016-10-30 00:32:24: pid 4998: DEBUG: initializing session context
2016-10-30 00:32:24: pid 4998: DETAIL: selected load balancing node: 0
2016-10-30 00:32:24: pid 4998: DEBUG: session context: clearing transaction isolation. DONE
2016-10-30 00:32:24: pid 4998: DEBUG: session context: clearing writing transaction. DONE
2016-10-30 00:32:24: pid 4998: DEBUG: session context: clearing failed transaction. DONE
2016-10-30 00:32:24: pid 4998: DEBUG: session context: clearing failed transaction. DONE
2016-10-30 00:32:24: pid 4998: DEBUG: session context: clearing skip reading from backends. DONE
2016-10-30 00:32:24: pid 4998: DEBUG: session context: clearing ignore till sync. DONE
2016-10-30 00:32:24: pid 4998: DEBUG: reading backend data packet kind
2016-10-30 00:32:24: pid 4998: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:32:24: pid 4998: DEBUG: processing backend response
2016-10-30 00:32:24: pid 4998: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:32:24: pid 4998: DEBUG: processing backend response
2016-10-30 00:32:24: pid 4998: DETAIL: Ready For Query received
2016-10-30 00:32:24: pid 4998: DEBUG: reading message length
2016-10-30 00:32:24: pid 4998: DETAIL: slot: 0 length: 5
2016-10-30 00:32:24: pid 4998: DEBUG: processing ReadyForQuery
2016-10-30 00:32:24: pid 4998: DETAIL: transaction state '
2016-10-30 00:32:24: pid 4998: DEBUG: processing frontend response
2016-10-30 00:32:24: pid 4998: DETAIL: received kind 'Q'(51) from frontend
2016-10-30 00:32:24: pid 4998: DEBUG: session context: clearing doing extended query messaging. DONE
2016-10-30 00:32:24: pid 4998: DEBUG: session context: setting query in progress. DONE
2016-10-30 00:32:24: pid 4998: DEBUG: SimpleQuery
2016-10-30 00:32:24: pid 4998: DETAIL: nodes reporting
2016-10-30 00:32:24: pid 4998: DEBUG: session context: setting skip reading from backends. DONE
2016-10-30 00:32:24: pid 4998: DEBUG: processing frontend response
2016-10-30 00:32:24: pid 4998: DETAIL: received kind 'X'(58) from frontend
2016-10-30 00:32:24: pid 4998: DEBUG: session context: clearing doing extended query messaging. DONE
2016-10-30 00:32:24: pid 4998: DEBUG: Frontend terminated
2016-10-30 00:32:24: pid 4998: DETAIL: received message kind 'X' from frontend
2016-10-30 00:32:24: pid 4998: DEBUG: session context: setting query in progress. DONE
2016-10-30 00:32:24: pid 4998: DEBUG: waiting for query response
2016-10-30 00:32:24: pid 4998: DETAIL: waiting for backend:0 to complete the query
2016-10-30 00:32:24: pid 4998: DEBUG: detect error: kind: S
2016-10-30 00:32:24: pid 4998: DEBUG: detect error: kind: S
2016-10-30 00:32:24: pid 4998: DEBUG: detect error: kind: S
2016-10-30 00:32:24: pid 4998: DEBUG: detect error: kind: S
2016-10-30 00:32:24: pid 4998: DEBUG: session context: clearing skip reading from backends. DONE
2016-10-30 00:32:24: pid 4998: DEBUG: reading backend data packet kind
2016-10-30 00:32:24: pid 4998: DETAIL: parameter name: is_superuser value: "on"
2016-10-30 00:32:24: pid 4998: DEBUG: reading backend data packet kind
2016-10-30 00:32:24: pid 4998: DETAIL: parameter name: session_authorization value: "postgres"
2016-10-30 00:32:24: pid 4998: DEBUG: reading backend data packet kind
2016-10-30 00:32:24: pid 4998: DETAIL: backend:0 of 2 kind = 'C'
2016-10-30 00:32:24: pid 4998: DEBUG: processing backend response
2016-10-30 00:32:24: pid 4998: DETAIL: received kind 'C'(43) from backend
2016-10-30 00:32:24: pid 4998: DEBUG: session context: setting command success. DONE
2016-10-30 00:32:24: pid 4998: DEBUG: reading backend data packet kind
2016-10-30 00:32:24: pid 4998: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:32:24: pid 4998: DEBUG: processing backend response
2016-10-30 00:32:24: pid 4998: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:32:24: pid 4998: DEBUG: processing backend response
2016-10-30 00:32:24: pid 4998: DETAIL: Ready For Query received
2016-10-30 00:32:24: pid 4998: DEBUG: reading message length
2016-10-30 00:32:24: pid 4998: DETAIL: slot: 0 length: 5
2016-10-30 00:32:24: pid 4998: DEBUG: processing ReadyForQuery
2016-10-30 00:32:24: pid 4998: DETAIL: transaction state 'I'(49)
2016-10-30 00:32:24: pid 4998: DEBUG: setting backend connection close timer
2016-10-30 00:32:24: pid 4998: DETAIL: close time 1477780344
2016-10-30 00:33:09: pid 5003: DEBUG: received PCP packet
2016-10-30 00:33:09: pid 5003: DETAIL: PCP packet type of service 'M'
2016-10-30 00:33:09: pid 5003: DEBUG: PCP: sent md5 salt to client
2016-10-30 00:33:09: pid 5003: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5003: DEBUG: received PCP packet
2016-10-30 00:33:09: pid 5003: DETAIL: PCP packet type of service 'R'
2016-10-30 00:33:09: pid 5003: DEBUG: PCP: processing authentication request
2016-10-30 00:33:09: pid 5003: DETAIL: authentication OK
2016-10-30 00:33:09: pid 5003: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5003: DEBUG: received PCP packet
2016-10-30 00:33:09: pid 5003: DETAIL: PCP packet type of service 'D'
2016-10-30 00:33:09: pid 5003: DEBUG: PCP: processing detach node
2016-10-30 00:33:09: pid 5003: DETAIL: detaching Node ID 0
2016-10-30 00:33:09: pid 5003: LOG: received degenerate backend request for node_id: 0 from pid [5003]
2016-10-30 00:33:09: pid 5003: DEBUG: sending 10 to the parent process with PID:4452
2016-10-30 00:33:09: pid 5003: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler called
2016-10-30 00:33:09: pid 5003: DEBUG: received PCP packet
2016-10-30 00:33:09: pid 5003: DETAIL: PCP packet type of service 'X'
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: starting to select new master node
2016-10-30 00:33:09: pid 4452: LOG: starting degeneration. shutdown host srvmtitatl01.betsson.local(5432)
2016-10-30 00:33:09: pid 5003: DEBUG: PCP processing request, client disconnecting
2016-10-30 00:33:09: pid 5003: DETAIL: closing PCP connection
2016-10-30 00:33:09: pid 5003: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 4452: LOG: failover: no valid backends node found
2016-10-30 00:33:09: pid 4452: LOG: Restart all children
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4938
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4939
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4940
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4941
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4942
2016-10-30 00:33:09: pid 4939: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4943
2016-10-30 00:33:09: pid 4940: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4944
2016-10-30 00:33:09: pid 4938: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4945
2016-10-30 00:33:09: pid 4944: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4945: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4941: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4946
2016-10-30 00:33:09: pid 4942: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4947
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4948
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4949
2016-10-30 00:33:09: pid 4948: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4950
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4951
2016-10-30 00:33:09: pid 4950: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4952
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4953
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4954
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4955
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4956
2016-10-30 00:33:09: pid 4954: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4955: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4957
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4958
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4959
2016-10-30 00:33:09: pid 4958: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4960
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4961
2016-10-30 00:33:09: pid 4959: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4962
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4963
2016-10-30 00:33:09: pid 4960: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4962: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4964
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4965
2016-10-30 00:33:09: pid 4943: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4966
2016-10-30 00:33:09: pid 4963: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4946: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4967
2016-10-30 00:33:09: pid 4966: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4964: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4968
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4969
2016-10-30 00:33:09: pid 4961: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4970
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4971
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4972
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4973
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4974
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4975
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4976
2016-10-30 00:33:09: pid 4974: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4973: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4977
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4978
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4979
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4980
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4981
2016-10-30 00:33:09: pid 4975: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4982
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4983
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4984
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4985
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4986
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4987
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4988
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4989
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4990
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4991
2016-10-30 00:33:09: pid 4988: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4992
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4993
2016-10-30 00:33:09: pid 4990: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4994
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4995
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4996
2016-10-30 00:33:09: pid 4993: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4997
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4998
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:4999
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:5000
2016-10-30 00:33:09: pid 4452: DEBUG: failover handler
2016-10-30 00:33:09: pid 4452: DETAIL: kill process with PID:5001
2016-10-30 00:33:09: pid 4452: DEBUG: find_primary_node: not in streaming replication mode
2016-10-30 00:33:09: pid 4452: LOG: failover: set new primary node: -1
2016-10-30 00:33:09: pid 4996: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4967: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4978: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4997: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4994: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4965: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4991: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4989: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4979: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 5016: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 4947: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4951: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4952: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4949: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4953: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4957: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4956: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4998: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 5017: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 4976: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4999: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 5018: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5000: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 5001: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4995: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 5019: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 4969: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4971: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 5020: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 4987: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4981: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 5021: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5022: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 4985: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4982: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4983: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4986: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4972: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4984: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4970: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4977: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4968: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 5023: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 4980: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 4992: LOG: child process received shutdown request signal 3
2016-10-30 00:33:09: pid 5024: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5025: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5026: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5027: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5028: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5029: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5030: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5031: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5032: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5033: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5034: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5035: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5036: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5037: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5038: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5039: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5040: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5041: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5042: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5043: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5044: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5045: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5046: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5047: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5048: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5049: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5050: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5051: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5052: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5053: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5054: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5055: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5056: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5057: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5058: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5059: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5060: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5061: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5062: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5063: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5064: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5065: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5066: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5067: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5068: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5069: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5070: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5071: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5072: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5073: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5074: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5075: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5076: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5077: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5078: DEBUG: initializing backend status
failover done. shutdown host srvmtitatl01.betsson.local(5432)2016-10-30 00:33:09: pid 5004: LOG: worker process received restart request
2016-10-30 00:33:09: pid 4452: LOG: failover done. shutdown host srvmtitatl01.betsson.local(5432)
2016-10-30 00:33:09: pid 5003: DEBUG: initializing backend status
2016-10-30 00:33:09: pid 5079: DEBUG: initializing backend status
2016-10-30 00:33:10: pid 5003: LOG: restart request received in pcp child process
2016-10-30 00:33:10: pid 4452: LOG: PCP child 5003 exits with status 256 in failover()
2016-10-30 00:33:10: pid 4452: LOG: fork a new PCP child pid 5080 in failover()
2016-10-30 00:33:10: pid 4452: DEBUG: reaper handler
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4938 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4938 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4938 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4939 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 5080: DEBUG: I am PCP child with pid:5080
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4939 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4939 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4940 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4940 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4940 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4941 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4941 exits with status 0
2016-10-30 00:33:10: pid 5080: DEBUG: initializing backend status
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4941 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4942 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4942 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4942 exited with success and will not be restarted
2016-10-30 00:33:10: pid 5080: DEBUG: initializing backend status
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4943 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4943 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4943 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4944 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4944 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4944 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4945 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4945 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4945 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4946 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4946 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4946 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4947 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4947 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4947 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4948 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4948 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4948 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4949 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4949 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4949 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4950 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4950 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4950 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4951 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4951 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4951 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4952 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4952 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4952 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4953 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4953 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4953 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4954 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4954 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4954 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4955 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4955 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4955 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4956 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4956 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4956 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4957 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4957 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4957 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4958 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4958 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4958 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4959 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4959 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4959 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4960 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4960 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4960 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4961 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4961 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4961 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4962 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4962 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4962 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4963 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4963 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4963 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4964 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4964 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4964 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4965 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4965 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4965 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4966 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4966 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4966 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4967 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4967 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4967 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4968 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4968 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4968 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4969 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4969 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4969 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4970 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4970 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4970 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4971 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4971 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4971 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4972 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4972 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4972 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4973 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4973 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4973 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4974 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4974 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4974 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4975 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4975 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4975 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4976 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4976 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4976 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4977 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4977 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4977 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4978 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4978 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4978 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4979 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4979 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4979 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4980 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4980 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4980 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4981 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4981 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4981 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4982 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4982 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4982 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4983 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4983 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4983 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4984 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4984 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4984 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4985 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4985 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4985 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4986 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4986 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4986 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4987 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4987 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4987 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4988 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4988 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4988 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4989 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4989 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4989 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4990 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4990 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4990 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4991 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4991 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4991 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4992 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4992 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4992 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4993 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4993 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4993 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4994 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4994 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4994 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4995 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4995 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4995 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4996 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4996 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4996 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4997 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4997 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4997 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4998 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4998 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4998 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 4999 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4999 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 4999 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 5000 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 5000 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 5000 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: DEBUG: child process with pid: 5001 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 5001 exits with status 0
2016-10-30 00:33:10: pid 4452: LOG: child process with pid: 5001 exited with success and will not be restarted
2016-10-30 00:33:10: pid 4452: LOG: worker child process with pid: 5004 exits with status 256
2016-10-30 00:33:10: pid 4452: LOG: fork a new worker child process with pid: 5081
2016-10-30 00:33:10: pid 4452: DEBUG: reaper handler: exiting normally
2016-10-30 00:33:10: pid 5081: DEBUG: I am 5081
2016-10-30 00:33:10: pid 5081: DEBUG: initializing backend status
2016-10-30 00:33:11: pid 5076: DEBUG: reading startup packet
2016-10-30 00:33:11: pid 5076: DETAIL: application_name: psql
2016-10-30 00:33:11: pid 5076: DEBUG: reading startup packet
2016-10-30 00:33:11: pid 5076: DETAIL: Protocol Major: 3 Minor: 0 database: postgres user: postgres
2016-10-30 00:33:11: pid 5076: DEBUG: forwarding error message to frontend
2016-10-30 00:33:11: pid 5076: FATAL: pgpool is not accepting any new connections
2016-10-30 00:33:11: pid 5076: DETAIL: all backend nodes are down, pgpool requires atleast one valid node
2016-10-30 00:33:11: pid 5076: HINT: repair the backend nodes and restart pgpool
2016-10-30 00:33:11: pid 4452: DEBUG: reaper handler
2016-10-30 00:33:11: pid 4452: LOG: child process with pid: 5076 exits with status 256
2016-10-30 00:33:11: pid 4452: LOG: fork a new child process with pid: 5083
2016-10-30 00:33:11: pid 4452: DEBUG: reaper handler: exiting normally
2016-10-30 00:33:11: pid 5083: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5080: DEBUG: received PCP packet
2016-10-30 00:33:30: pid 5080: DETAIL: PCP packet type of service 'M'
2016-10-30 00:33:30: pid 5080: DEBUG: PCP: sent md5 salt to client
2016-10-30 00:33:30: pid 5080: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5080: DEBUG: received PCP packet
2016-10-30 00:33:30: pid 5080: DETAIL: PCP packet type of service 'R'
2016-10-30 00:33:30: pid 5080: DEBUG: PCP: processing authentication request
2016-10-30 00:33:30: pid 5080: DETAIL: authentication OK
2016-10-30 00:33:30: pid 5080: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5080: DEBUG: received PCP packet
2016-10-30 00:33:30: pid 5080: DETAIL: PCP packet type of service 'C'
2016-10-30 00:33:30: pid 5080: DEBUG: PCP: processing attach node
2016-10-30 00:33:30: pid 5080: DETAIL: attaching Node ID 0
2016-10-30 00:33:30: pid 5080: LOG: received failback request for node_id: 0 from pid [5080]
2016-10-30 00:33:30: pid 5080: DEBUG: sending 10 to the parent process with PID:4452
2016-10-30 00:33:30: pid 5080: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler called
2016-10-30 00:33:30: pid 5080: DEBUG: received PCP packet
2016-10-30 00:33:30: pid 5080: DETAIL: PCP packet type of service 'X'
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: starting to select new master node
2016-10-30 00:33:30: pid 5080: DEBUG: PCP processing request, client disconnecting
2016-10-30 00:33:30: pid 5080: DETAIL: closing PCP connection
2016-10-30 00:33:30: pid 4452: LOG: starting fail back. reconnect host srvmtitatl01.betsson.local(5432)
2016-10-30 00:33:30: pid 5080: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 4452: LOG: Restart all children
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5016
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5017
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5018
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5019
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5020
2016-10-30 00:33:30: pid 5016: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5017: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5021
2016-10-30 00:33:30: pid 5018: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5019: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5021: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5022: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5022
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5023
2016-10-30 00:33:30: pid 5020: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5024
2016-10-30 00:33:30: pid 5023: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5025
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5026
2016-10-30 00:33:30: pid 5024: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5025: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5027
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5028
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5029
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5030
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5031
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5032
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5033
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5034
2016-10-30 00:33:30: pid 5031: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5035
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5036
2016-10-30 00:33:30: pid 5033: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5037
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5038
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5039
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5040
2016-10-30 00:33:30: pid 5030: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5041
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5042
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5043
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5044
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5045
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5046
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5047
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5048
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5049
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5050
2016-10-30 00:33:30: pid 5048: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5051
2016-10-30 00:33:30: pid 5049: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5052
2016-10-30 00:33:30: pid 5050: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5053
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5054
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5055
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5056
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5057
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5058
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5059
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5060
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5061
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5062
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5063
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5064
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5065
2016-10-30 00:33:30: pid 5056: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5066
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5067
2016-10-30 00:33:30: pid 5051: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5041: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5068
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5069
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5070
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5071
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5072
2016-10-30 00:33:30: pid 5047: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5073
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5074
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5075
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5083
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5077
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5078
2016-10-30 00:33:30: pid 5075: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 4452: DEBUG: failover handler
2016-10-30 00:33:30: pid 4452: DETAIL: kill process with PID:5079
2016-10-30 00:33:30: pid 4452: DEBUG: find_primary_node: not in streaming replication mode
2016-10-30 00:33:30: pid 4452: LOG: failover: set new primary node: -1
2016-10-30 00:33:30: pid 4452: LOG: failover: set new master node: 0
2016-10-30 00:33:30: pid 5029: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5065: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5035: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5061: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5062: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5036: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5026: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5072: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5052: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5034: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5027: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5077: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5057: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5055: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5078: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5042: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5073: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5038: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5064: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5060: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5039: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5059: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5044: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5066: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5053: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5037: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5054: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5043: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5089: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5079: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5046: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5074: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5028: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5083: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5071: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5070: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5067: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5032: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5040: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5068: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5058: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5045: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5090: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5069: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5091: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5063: LOG: child process received shutdown request signal 3
2016-10-30 00:33:30: pid 5092: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5093: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5094: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5095: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5096: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5097: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5098: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5099: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5100: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5101: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5102: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5103: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5104: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5105: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5106: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5107: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5108: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5109: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5110: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5111: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5112: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5113: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5114: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5115: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5116: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5117: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5118: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5119: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5120: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5121: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5122: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5123: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5124: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5125: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5126: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5127: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5128: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5129: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5130: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5131: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5132: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5133: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5134: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5135: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5136: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5137: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5138: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5139: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5140: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5141: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5142: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5143: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5144: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5145: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5146: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5147: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5148: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5149: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5150: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5151: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5081: LOG: worker process received restart request
2016-10-30 00:33:30: pid 4452: LOG: failback done. reconnect host srvmtitatl01.betsson.local(5432)
2016-10-30 00:33:30: pid 5080: DEBUG: initializing backend status
2016-10-30 00:33:30: pid 5152: DEBUG: initializing backend status
2016-10-30 00:33:31: pid 5080: LOG: restart request received in pcp child process
2016-10-30 00:33:31: pid 4452: LOG: PCP child 5080 exits with status 256 in failover()
2016-10-30 00:33:31: pid 4452: LOG: fork a new PCP child pid 5153 in failover()
2016-10-30 00:33:31: pid 4452: DEBUG: reaper handler
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5016 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5016 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5016 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5017 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5017 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5017 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5018 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5018 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5018 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5019 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5019 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5019 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5020 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5020 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5020 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5021 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5021 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5021 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5022 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5022 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5022 exited with success and will not be restarted
2016-10-30 00:33:31: pid 5153: DEBUG: I am PCP child with pid:5153
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5023 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5023 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5023 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5024 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5024 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5024 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5025 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5025 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5025 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5026 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5026 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5026 exited with success and will not be restarted
2016-10-30 00:33:31: pid 5153: DEBUG: initializing backend status
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5027 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5027 exits with status 0
2016-10-30 00:33:31: pid 5153: DEBUG: initializing backend status
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5027 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5028 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5028 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5028 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5029 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5029 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5029 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5030 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5030 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5030 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5031 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5031 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5031 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5032 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5032 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5032 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5033 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5033 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5033 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5034 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5034 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5034 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5035 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5035 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5035 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5036 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5036 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5036 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5037 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5037 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5037 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5038 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5038 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5038 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5039 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5039 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5039 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5040 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5040 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5040 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5041 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5041 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5041 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5042 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5042 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5042 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5043 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5043 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5043 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5044 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5044 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5044 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5045 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5045 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5045 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5046 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5046 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5046 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5047 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5047 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5047 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5048 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5048 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5048 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5049 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5049 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5049 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5050 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5050 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5050 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5051 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5051 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5051 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5052 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5052 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5052 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5053 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5053 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5053 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5054 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5054 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5054 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5055 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5055 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5055 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5056 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5056 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5056 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5057 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5057 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5057 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5058 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5058 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5058 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5059 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5059 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5059 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5060 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5060 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5060 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5061 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5061 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5061 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5062 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5062 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5062 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5063 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5063 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5063 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5064 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5064 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5064 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5065 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5065 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5065 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5066 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5066 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5066 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5067 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5067 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5067 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5068 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5068 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5068 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5069 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5069 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5069 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5070 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5070 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5070 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5071 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5071 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5071 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5072 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5072 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5072 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5073 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5073 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5073 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5074 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5074 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5074 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5075 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5075 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5075 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5077 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5077 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5077 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5078 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5078 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5078 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5079 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5079 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5079 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: worker child process with pid: 5081 exits with status 256
2016-10-30 00:33:31: pid 4452: LOG: fork a new worker child process with pid: 5154
2016-10-30 00:33:31: pid 4452: DEBUG: child process with pid: 5083 exit with SUCCESS. child will not be restarted
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5083 exits with status 0
2016-10-30 00:33:31: pid 4452: LOG: child process with pid: 5083 exited with success and will not be restarted
2016-10-30 00:33:31: pid 4452: DEBUG: reaper handler: exiting normally
2016-10-30 00:33:31: pid 5154: DEBUG: I am 5154
2016-10-30 00:33:31: pid 5154: DEBUG: initializing backend status
2016-10-30 00:33:31: pid 5152: DEBUG: I am 5152 accept fd 7
2016-10-30 00:33:31: pid 5152: DEBUG: reading startup packet
2016-10-30 00:33:31: pid 5152: DETAIL: application_name: psql
2016-10-30 00:33:31: pid 5152: DEBUG: reading startup packet
2016-10-30 00:33:31: pid 5152: DETAIL: Protocol Major: 3 Minor: 0 database: postgres user: postgres
2016-10-30 00:33:31: pid 5152: DEBUG: creating new connection to backend
2016-10-30 00:33:31: pid 5152: DETAIL: connecting 0 backend
2016-10-30 00:33:31: pid 5152: DEBUG: creating new connection to backend
2016-10-30 00:33:31: pid 5152: DETAIL: connecting 1 backend
2016-10-30 00:33:31: pid 5152: DEBUG: creating new connection to backend
2016-10-30 00:33:31: pid 5152: DETAIL: skipping backend slot 1 because backend_status = 3
2016-10-30 00:33:31: pid 5152: DEBUG: SSL is requested but SSL support is not available
2016-10-30 00:33:31: pid 5152: DEBUG: reading message length
2016-10-30 00:33:31: pid 5152: DETAIL: slot: 0 length: 8
2016-10-30 00:33:31: pid 5152: DEBUG: authentication backend
2016-10-30 00:33:31: pid 5152: DETAIL: auth kind:0
2016-10-30 00:33:31: pid 5152: DEBUG: reading message length
2016-10-30 00:33:31: pid 5152: DETAIL: master slot: 0 length: 26
2016-10-30 00:33:31: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:31: pid 5152: DETAIL: backend:0 name:"application_name" value:"psql"
2016-10-30 00:33:31: pid 5152: DEBUG: reading message length
2016-10-30 00:33:31: pid 5152: DETAIL: master slot: 0 length: 25
2016-10-30 00:33:31: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:31: pid 5152: DETAIL: backend:0 name:"client_encoding" value:"UTF8"
2016-10-30 00:33:31: pid 5152: DEBUG: reading message length
2016-10-30 00:33:31: pid 5152: DETAIL: master slot: 0 length: 23
2016-10-30 00:33:31: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:31: pid 5152: DETAIL: backend:0 name:"DateStyle" value:"ISO, DMY"
2016-10-30 00:33:31: pid 5152: DEBUG: reading message length
2016-10-30 00:33:31: pid 5152: DETAIL: master slot: 0 length: 25
2016-10-30 00:33:31: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:31: pid 5152: DETAIL: backend:0 name:"integer_datetimes" value:"on"
2016-10-30 00:33:31: pid 5152: DEBUG: reading message length
2016-10-30 00:33:31: pid 5152: DETAIL: master slot: 0 length: 27
2016-10-30 00:33:31: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:31: pid 5152: DETAIL: backend:0 name:"IntervalStyle" value:"postgres"
2016-10-30 00:33:31: pid 5152: DEBUG: reading message length
2016-10-30 00:33:31: pid 5152: DETAIL: master slot: 0 length: 20
2016-10-30 00:33:31: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:31: pid 5152: DETAIL: backend:0 name:"is_superuser" value:"on"
2016-10-30 00:33:31: pid 5152: DEBUG: reading message length
2016-10-30 00:33:31: pid 5152: DETAIL: master slot: 0 length: 25
2016-10-30 00:33:31: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:31: pid 5152: DETAIL: backend:0 name:"server_encoding" value:"UTF8"
2016-10-30 00:33:31: pid 5152: DEBUG: reading message length
2016-10-30 00:33:31: pid 5152: DETAIL: master slot: 0 length: 26
2016-10-30 00:33:31: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:31: pid 5152: DETAIL: backend:0 name:"server_version" value:"9.2.14"
2016-10-30 00:33:31: pid 5152: DEBUG: reading message length
2016-10-30 00:33:31: pid 5152: DETAIL: master slot: 0 length: 35
2016-10-30 00:33:31: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:31: pid 5152: DETAIL: backend:0 name:"session_authorization" value:"postgres"
2016-10-30 00:33:31: pid 5152: DEBUG: reading message length
2016-10-30 00:33:31: pid 5152: DETAIL: master slot: 0 length: 35
2016-10-30 00:33:31: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:31: pid 5152: DETAIL: backend:0 name:"standard_conforming_strings" value:"on"
2016-10-30 00:33:31: pid 5152: DEBUG: reading message length
2016-10-30 00:33:31: pid 5152: DETAIL: master slot: 0 length: 26
2016-10-30 00:33:31: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:31: pid 5152: DETAIL: backend:0 name:"TimeZone" value:"Europe/Malta"
2016-10-30 00:33:31: pid 5152: DEBUG: reading message length
2016-10-30 00:33:31: pid 5152: DETAIL: slot: 0 length: 12
2016-10-30 00:33:31: pid 5152: DEBUG: authentication backend
2016-10-30 00:33:31: pid 5152: DETAIL: cp->info[i]:0x7fe107b12000 pid:5156
2016-10-30 00:33:31: pid 5152: DEBUG: sending backend key data
2016-10-30 00:33:31: pid 5152: DETAIL: send pid 5156 to frontend
2016-10-30 00:33:31: pid 5152: DEBUG: selecting load balance node
2016-10-30 00:33:31: pid 5152: DETAIL: selected backend id is 0
2016-10-30 00:33:31: pid 5152: DEBUG: initializing session context
2016-10-30 00:33:31: pid 5152: DETAIL: selected load balancing node: 0
2016-10-30 00:33:31: pid 5152: DEBUG: session context: clearing transaction isolation. DONE
2016-10-30 00:33:31: pid 5152: DEBUG: session context: clearing writing transaction. DONE
2016-10-30 00:33:31: pid 5152: DEBUG: session context: clearing failed transaction. DONE
2016-10-30 00:33:31: pid 5152: DEBUG: session context: clearing failed transaction. DONE
2016-10-30 00:33:31: pid 5152: DEBUG: session context: clearing skip reading from backends. DONE
2016-10-30 00:33:31: pid 5152: DEBUG: session context: clearing ignore till sync. DONE
2016-10-30 00:33:31: pid 5152: DEBUG: reading backend data packet kind
2016-10-30 00:33:31: pid 5152: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:33:31: pid 5152: DEBUG: processing backend response
2016-10-30 00:33:31: pid 5152: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:33:31: pid 5152: DEBUG: processing backend response
2016-10-30 00:33:31: pid 5152: DETAIL: Ready For Query received
2016-10-30 00:33:31: pid 5152: DEBUG: reading message length
2016-10-30 00:33:31: pid 5152: DETAIL: slot: 0 length: 5
2016-10-30 00:33:31: pid 5152: DEBUG: processing ReadyForQuery
2016-10-30 00:33:31: pid 5152: DETAIL: transaction state '
2016-10-30 00:33:31: pid 5152: DEBUG: processing frontend response
2016-10-30 00:33:31: pid 5152: DETAIL: received kind 'Q'(51) from frontend
2016-10-30 00:33:31: pid 5152: DEBUG: session context: clearing doing extended query messaging. DONE
2016-10-30 00:33:31: pid 5152: DEBUG: session context: setting query in progress. DONE
2016-10-30 00:33:31: pid 5152: DEBUG: SimpleQuery
2016-10-30 00:33:31: pid 5152: DETAIL: nodes reporting
2016-10-30 00:33:31: pid 5152: DEBUG: session context: setting skip reading from backends. DONE
2016-10-30 00:33:31: pid 5152: DEBUG: processing frontend response
2016-10-30 00:33:31: pid 5152: DETAIL: received kind 'X'(58) from frontend
2016-10-30 00:33:31: pid 5152: DEBUG: session context: clearing doing extended query messaging. DONE
2016-10-30 00:33:31: pid 5152: DEBUG: Frontend terminated
2016-10-30 00:33:31: pid 5152: DETAIL: received message kind 'X' from frontend
2016-10-30 00:33:31: pid 5152: DEBUG: session context: setting query in progress. DONE
2016-10-30 00:33:31: pid 5152: DEBUG: waiting for query response
2016-10-30 00:33:31: pid 5152: DETAIL: waiting for backend:0 to complete the query
2016-10-30 00:33:31: pid 5152: DEBUG: detect error: kind: S
2016-10-30 00:33:31: pid 5152: DEBUG: detect error: kind: S
2016-10-30 00:33:31: pid 5152: DEBUG: detect error: kind: S
2016-10-30 00:33:31: pid 5152: DEBUG: detect error: kind: S
2016-10-30 00:33:31: pid 5152: DEBUG: session context: clearing skip reading from backends. DONE
2016-10-30 00:33:31: pid 5152: DEBUG: reading backend data packet kind
2016-10-30 00:33:31: pid 5152: DETAIL: parameter name: is_superuser value: "on"
2016-10-30 00:33:31: pid 5152: DEBUG: reading backend data packet kind
2016-10-30 00:33:31: pid 5152: DETAIL: parameter name: session_authorization value: "postgres"
2016-10-30 00:33:31: pid 5152: DEBUG: reading backend data packet kind
2016-10-30 00:33:31: pid 5152: DETAIL: backend:0 of 2 kind = 'C'
2016-10-30 00:33:31: pid 5152: DEBUG: processing backend response
2016-10-30 00:33:31: pid 5152: DETAIL: received kind 'C'(43) from backend
2016-10-30 00:33:31: pid 5152: DEBUG: session context: setting command success. DONE
2016-10-30 00:33:31: pid 5152: DEBUG: reading backend data packet kind
2016-10-30 00:33:31: pid 5152: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:33:31: pid 5152: DEBUG: processing backend response
2016-10-30 00:33:31: pid 5152: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:33:31: pid 5152: DEBUG: processing backend response
2016-10-30 00:33:31: pid 5152: DETAIL: Ready For Query received
2016-10-30 00:33:31: pid 5152: DEBUG: reading message length
2016-10-30 00:33:31: pid 5152: DETAIL: slot: 0 length: 5
2016-10-30 00:33:31: pid 5152: DEBUG: processing ReadyForQuery
2016-10-30 00:33:31: pid 5152: DETAIL: transaction state 'I'(49)
2016-10-30 00:33:31: pid 5152: DEBUG: setting backend connection close timer
2016-10-30 00:33:31: pid 5152: DETAIL: close time 1477780411
2016-10-30 00:33:59: pid 5152: DEBUG: I am 5152 accept fd 7
2016-10-30 00:33:59: pid 5152: DEBUG: reading startup packet
2016-10-30 00:33:59: pid 5152: DETAIL: application_name: psql
2016-10-30 00:33:59: pid 5152: DEBUG: reading startup packet
2016-10-30 00:33:59: pid 5152: DETAIL: Protocol Major: 3 Minor: 0 database: postgres user: postgres
2016-10-30 00:33:59: pid 5152: DEBUG: creating new connection to backend
2016-10-30 00:33:59: pid 5152: DETAIL: connecting 0 backend
2016-10-30 00:33:59: pid 5152: DEBUG: creating new connection to backend
2016-10-30 00:33:59: pid 5152: DETAIL: connecting 1 backend
2016-10-30 00:33:59: pid 5152: DEBUG: creating new connection to backend
2016-10-30 00:33:59: pid 5152: DETAIL: skipping backend slot 1 because backend_status = 3
2016-10-30 00:33:59: pid 5152: DEBUG: SSL is requested but SSL support is not available
2016-10-30 00:33:59: pid 5152: DEBUG: reading message length
2016-10-30 00:33:59: pid 5152: DETAIL: slot: 0 length: 8
2016-10-30 00:33:59: pid 5152: DEBUG: authentication backend
2016-10-30 00:33:59: pid 5152: DETAIL: auth kind:0
2016-10-30 00:33:59: pid 5152: DEBUG: reading message length
2016-10-30 00:33:59: pid 5152: DETAIL: master slot: 0 length: 26
2016-10-30 00:33:59: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:59: pid 5152: DETAIL: backend:0 name:"application_name" value:"psql"
2016-10-30 00:33:59: pid 5152: DEBUG: reading message length
2016-10-30 00:33:59: pid 5152: DETAIL: master slot: 0 length: 25
2016-10-30 00:33:59: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:59: pid 5152: DETAIL: backend:0 name:"client_encoding" value:"UTF8"
2016-10-30 00:33:59: pid 5152: DEBUG: reading message length
2016-10-30 00:33:59: pid 5152: DETAIL: master slot: 0 length: 23
2016-10-30 00:33:59: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:59: pid 5152: DETAIL: backend:0 name:"DateStyle" value:"ISO, DMY"
2016-10-30 00:33:59: pid 5152: DEBUG: reading message length
2016-10-30 00:33:59: pid 5152: DETAIL: master slot: 0 length: 25
2016-10-30 00:33:59: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:59: pid 5152: DETAIL: backend:0 name:"integer_datetimes" value:"on"
2016-10-30 00:33:59: pid 5152: DEBUG: reading message length
2016-10-30 00:33:59: pid 5152: DETAIL: master slot: 0 length: 27
2016-10-30 00:33:59: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:59: pid 5152: DETAIL: backend:0 name:"IntervalStyle" value:"postgres"
2016-10-30 00:33:59: pid 5152: DEBUG: reading message length
2016-10-30 00:33:59: pid 5152: DETAIL: master slot: 0 length: 20
2016-10-30 00:33:59: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:59: pid 5152: DETAIL: backend:0 name:"is_superuser" value:"on"
2016-10-30 00:33:59: pid 5152: DEBUG: reading message length
2016-10-30 00:33:59: pid 5152: DETAIL: master slot: 0 length: 25
2016-10-30 00:33:59: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:59: pid 5152: DETAIL: backend:0 name:"server_encoding" value:"UTF8"
2016-10-30 00:33:59: pid 5152: DEBUG: reading message length
2016-10-30 00:33:59: pid 5152: DETAIL: master slot: 0 length: 26
2016-10-30 00:33:59: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:59: pid 5152: DETAIL: backend:0 name:"server_version" value:"9.2.14"
2016-10-30 00:33:59: pid 5152: DEBUG: reading message length
2016-10-30 00:33:59: pid 5152: DETAIL: master slot: 0 length: 35
2016-10-30 00:33:59: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:59: pid 5152: DETAIL: backend:0 name:"session_authorization" value:"postgres"
2016-10-30 00:33:59: pid 5152: DEBUG: reading message length
2016-10-30 00:33:59: pid 5152: DETAIL: master slot: 0 length: 35
2016-10-30 00:33:59: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:59: pid 5152: DETAIL: backend:0 name:"standard_conforming_strings" value:"on"
2016-10-30 00:33:59: pid 5152: DEBUG: reading message length
2016-10-30 00:33:59: pid 5152: DETAIL: master slot: 0 length: 26
2016-10-30 00:33:59: pid 5152: DEBUG: process parameter status
2016-10-30 00:33:59: pid 5152: DETAIL: backend:0 name:"TimeZone" value:"Europe/Malta"
2016-10-30 00:33:59: pid 5152: DEBUG: reading message length
2016-10-30 00:33:59: pid 5152: DETAIL: slot: 0 length: 12
2016-10-30 00:33:59: pid 5152: DEBUG: authentication backend
2016-10-30 00:33:59: pid 5152: DETAIL: cp->info[i]:0x7fe107b12000 pid:5162
2016-10-30 00:33:59: pid 5152: DEBUG: sending backend key data
2016-10-30 00:33:59: pid 5152: DETAIL: send pid 5162 to frontend
2016-10-30 00:33:59: pid 5152: DEBUG: selecting load balance node
2016-10-30 00:33:59: pid 5152: DETAIL: selected backend id is 0
2016-10-30 00:33:59: pid 5152: DEBUG: initializing session context
2016-10-30 00:33:59: pid 5152: DETAIL: selected load balancing node: 0
2016-10-30 00:33:59: pid 5152: DEBUG: session context: clearing transaction isolation. DONE
2016-10-30 00:33:59: pid 5152: DEBUG: session context: clearing writing transaction. DONE
2016-10-30 00:33:59: pid 5152: DEBUG: session context: clearing failed transaction. DONE
2016-10-30 00:33:59: pid 5152: DEBUG: session context: clearing failed transaction. DONE
2016-10-30 00:33:59: pid 5152: DEBUG: session context: clearing skip reading from backends. DONE
2016-10-30 00:33:59: pid 5152: DEBUG: session context: clearing ignore till sync. DONE
2016-10-30 00:33:59: pid 5152: DEBUG: reading backend data packet kind
2016-10-30 00:33:59: pid 5152: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:33:59: pid 5152: DEBUG: processing backend response
2016-10-30 00:33:59: pid 5152: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:33:59: pid 5152: DEBUG: processing backend response
2016-10-30 00:33:59: pid 5152: DETAIL: Ready For Query received
2016-10-30 00:33:59: pid 5152: DEBUG: reading message length
2016-10-30 00:33:59: pid 5152: DETAIL: slot: 0 length: 5
2016-10-30 00:33:59: pid 5152: DEBUG: processing ReadyForQuery
2016-10-30 00:33:59: pid 5152: DETAIL: transaction state '
2016-10-30 00:33:59: pid 5152: DEBUG: processing frontend response
2016-10-30 00:33:59: pid 5152: DETAIL: received kind 'Q'(51) from frontend
2016-10-30 00:33:59: pid 5152: DEBUG: session context: clearing doing extended query messaging. DONE
2016-10-30 00:33:59: pid 5152: DEBUG: session context: setting query in progress. DONE
2016-10-30 00:33:59: pid 5152: DEBUG: SimpleQuery
2016-10-30 00:33:59: pid 5152: DETAIL: nodes reporting
2016-10-30 00:33:59: pid 5152: DEBUG: session context: setting skip reading from backends. DONE
2016-10-30 00:33:59: pid 5152: DEBUG: processing frontend response
2016-10-30 00:33:59: pid 5152: DETAIL: received kind 'X'(58) from frontend
2016-10-30 00:33:59: pid 5152: DEBUG: session context: clearing doing extended query messaging. DONE
2016-10-30 00:33:59: pid 5152: DEBUG: Frontend terminated
2016-10-30 00:33:59: pid 5152: DETAIL: received message kind 'X' from frontend
2016-10-30 00:33:59: pid 5152: DEBUG: session context: setting query in progress. DONE
2016-10-30 00:33:59: pid 5152: DEBUG: waiting for query response
2016-10-30 00:33:59: pid 5152: DETAIL: waiting for backend:0 to complete the query
2016-10-30 00:33:59: pid 5152: DEBUG: detect error: kind: S
2016-10-30 00:33:59: pid 5152: DEBUG: detect error: kind: S
2016-10-30 00:33:59: pid 5152: DEBUG: detect error: kind: S
2016-10-30 00:33:59: pid 5152: DEBUG: detect error: kind: S
2016-10-30 00:33:59: pid 5152: DEBUG: session context: clearing skip reading from backends. DONE
2016-10-30 00:33:59: pid 5152: DEBUG: reading backend data packet kind
2016-10-30 00:33:59: pid 5152: DETAIL: parameter name: is_superuser value: "on"
2016-10-30 00:33:59: pid 5152: DEBUG: reading backend data packet kind
2016-10-30 00:33:59: pid 5152: DETAIL: parameter name: session_authorization value: "postgres"
2016-10-30 00:33:59: pid 5152: DEBUG: reading backend data packet kind
2016-10-30 00:33:59: pid 5152: DETAIL: backend:0 of 2 kind = 'C'
2016-10-30 00:33:59: pid 5152: DEBUG: processing backend response
2016-10-30 00:33:59: pid 5152: DETAIL: received kind 'C'(43) from backend
2016-10-30 00:33:59: pid 5152: DEBUG: session context: setting command success. DONE
2016-10-30 00:33:59: pid 5152: DEBUG: reading backend data packet kind
2016-10-30 00:33:59: pid 5152: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:33:59: pid 5152: DEBUG: processing backend response
2016-10-30 00:33:59: pid 5152: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:33:59: pid 5152: DEBUG: processing backend response
2016-10-30 00:33:59: pid 5152: DETAIL: Ready For Query received
2016-10-30 00:33:59: pid 5152: DEBUG: reading message length
2016-10-30 00:33:59: pid 5152: DETAIL: slot: 0 length: 5
2016-10-30 00:33:59: pid 5152: DEBUG: processing ReadyForQuery
2016-10-30 00:33:59: pid 5152: DETAIL: transaction state 'I'(49)
2016-10-30 00:33:59: pid 5152: DEBUG: setting backend connection close timer
2016-10-30 00:33:59: pid 5152: DETAIL: close time 1477780439
2016-10-30 00:38:59: pid 5152: DEBUG: child life 300 seconds expired
2016-10-30 00:38:59: pid 4452: DEBUG: reaper handler
2016-10-30 00:38:59: pid 4452: LOG: child process with pid: 5152 exits with status 512
2016-10-30 00:38:59: pid 4452: LOG: fork a new child process with pid: 5205
2016-10-30 00:38:59: pid 4452: DEBUG: reaper handler: exiting normally
2016-10-30 00:38:59: pid 5205: DEBUG: initializing backend status
2016-10-30 00:41:52: pid 5143: DEBUG: I am 5143 accept fd 7
2016-10-30 00:41:52: pid 5143: DEBUG: reading startup packet
2016-10-30 00:41:52: pid 5143: DETAIL: application_name: psql
2016-10-30 00:41:52: pid 5143: DEBUG: reading startup packet
2016-10-30 00:41:52: pid 5143: DETAIL: Protocol Major: 3 Minor: 0 database: postgres user: postgres
2016-10-30 00:41:52: pid 5143: DEBUG: creating new connection to backend
2016-10-30 00:41:52: pid 5143: DETAIL: connecting 0 backend
2016-10-30 00:41:52: pid 5143: DEBUG: creating new connection to backend
2016-10-30 00:41:52: pid 5143: DETAIL: connecting 1 backend
2016-10-30 00:41:52: pid 5143: DEBUG: creating new connection to backend
2016-10-30 00:41:52: pid 5143: DETAIL: skipping backend slot 1 because backend_status = 3
2016-10-30 00:41:52: pid 5143: DEBUG: SSL is requested but SSL support is not available
2016-10-30 00:41:52: pid 5143: DEBUG: reading message length
2016-10-30 00:41:52: pid 5143: DETAIL: slot: 0 length: 8
2016-10-30 00:41:52: pid 5143: DEBUG: authentication backend
2016-10-30 00:41:52: pid 5143: DETAIL: auth kind:0
2016-10-30 00:41:52: pid 5143: DEBUG: reading message length
2016-10-30 00:41:52: pid 5143: DETAIL: master slot: 0 length: 26
2016-10-30 00:41:52: pid 5143: DEBUG: process parameter status
2016-10-30 00:41:52: pid 5143: DETAIL: backend:0 name:"application_name" value:"psql"
2016-10-30 00:41:52: pid 5143: DEBUG: reading message length
2016-10-30 00:41:52: pid 5143: DETAIL: master slot: 0 length: 25
2016-10-30 00:41:52: pid 5143: DEBUG: process parameter status
2016-10-30 00:41:52: pid 5143: DETAIL: backend:0 name:"client_encoding" value:"UTF8"
2016-10-30 00:41:52: pid 5143: DEBUG: reading message length
2016-10-30 00:41:52: pid 5143: DETAIL: master slot: 0 length: 23
2016-10-30 00:41:52: pid 5143: DEBUG: process parameter status
2016-10-30 00:41:52: pid 5143: DETAIL: backend:0 name:"DateStyle" value:"ISO, DMY"
2016-10-30 00:41:52: pid 5143: DEBUG: reading message length
2016-10-30 00:41:52: pid 5143: DETAIL: master slot: 0 length: 25
2016-10-30 00:41:52: pid 5143: DEBUG: process parameter status
2016-10-30 00:41:52: pid 5143: DETAIL: backend:0 name:"integer_datetimes" value:"on"
2016-10-30 00:41:52: pid 5143: DEBUG: reading message length
2016-10-30 00:41:52: pid 5143: DETAIL: master slot: 0 length: 27
2016-10-30 00:41:52: pid 5143: DEBUG: process parameter status
2016-10-30 00:41:52: pid 5143: DETAIL: backend:0 name:"IntervalStyle" value:"postgres"
2016-10-30 00:41:52: pid 5143: DEBUG: reading message length
2016-10-30 00:41:52: pid 5143: DETAIL: master slot: 0 length: 20
2016-10-30 00:41:52: pid 5143: DEBUG: process parameter status
2016-10-30 00:41:52: pid 5143: DETAIL: backend:0 name:"is_superuser" value:"on"
2016-10-30 00:41:52: pid 5143: DEBUG: reading message length
2016-10-30 00:41:52: pid 5143: DETAIL: master slot: 0 length: 25
2016-10-30 00:41:52: pid 5143: DEBUG: process parameter status
2016-10-30 00:41:52: pid 5143: DETAIL: backend:0 name:"server_encoding" value:"UTF8"
2016-10-30 00:41:52: pid 5143: DEBUG: reading message length
2016-10-30 00:41:52: pid 5143: DETAIL: master slot: 0 length: 26
2016-10-30 00:41:52: pid 5143: DEBUG: process parameter status
2016-10-30 00:41:52: pid 5143: DETAIL: backend:0 name:"server_version" value:"9.2.14"
2016-10-30 00:41:52: pid 5143: DEBUG: reading message length
2016-10-30 00:41:52: pid 5143: DETAIL: master slot: 0 length: 35
2016-10-30 00:41:52: pid 5143: DEBUG: process parameter status
2016-10-30 00:41:52: pid 5143: DETAIL: backend:0 name:"session_authorization" value:"postgres"
2016-10-30 00:41:52: pid 5143: DEBUG: reading message length
2016-10-30 00:41:52: pid 5143: DETAIL: master slot: 0 length: 35
2016-10-30 00:41:52: pid 5143: DEBUG: process parameter status
2016-10-30 00:41:52: pid 5143: DETAIL: backend:0 name:"standard_conforming_strings" value:"on"
2016-10-30 00:41:52: pid 5143: DEBUG: reading message length
2016-10-30 00:41:52: pid 5143: DETAIL: master slot: 0 length: 26
2016-10-30 00:41:52: pid 5143: DEBUG: process parameter status
2016-10-30 00:41:52: pid 5143: DETAIL: backend:0 name:"TimeZone" value:"Europe/Malta"
2016-10-30 00:41:52: pid 5143: DEBUG: reading message length
2016-10-30 00:41:52: pid 5143: DETAIL: slot: 0 length: 12
2016-10-30 00:41:52: pid 5143: DEBUG: authentication backend
2016-10-30 00:41:52: pid 5143: DETAIL: cp->info[i]:0x7fe107a79000 pid:5226
2016-10-30 00:41:52: pid 5143: DEBUG: sending backend key data
2016-10-30 00:41:52: pid 5143: DETAIL: send pid 5226 to frontend
2016-10-30 00:41:52: pid 5143: DEBUG: selecting load balance node
2016-10-30 00:41:52: pid 5143: DETAIL: selected backend id is 0
2016-10-30 00:41:52: pid 5143: DEBUG: initializing session context
2016-10-30 00:41:52: pid 5143: DETAIL: selected load balancing node: 0
2016-10-30 00:41:52: pid 5143: DEBUG: session context: clearing transaction isolation. DONE
2016-10-30 00:41:52: pid 5143: DEBUG: session context: clearing writing transaction. DONE
2016-10-30 00:41:52: pid 5143: DEBUG: session context: clearing failed transaction. DONE
2016-10-30 00:41:52: pid 5143: DEBUG: session context: clearing failed transaction. DONE
2016-10-30 00:41:52: pid 5143: DEBUG: session context: clearing skip reading from backends. DONE
2016-10-30 00:41:52: pid 5143: DEBUG: session context: clearing ignore till sync. DONE
2016-10-30 00:41:52: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:41:52: pid 5143: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:41:52: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:52: pid 5143: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:41:52: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:52: pid 5143: DETAIL: Ready For Query received
2016-10-30 00:41:52: pid 5143: DEBUG: reading message length
2016-10-30 00:41:52: pid 5143: DETAIL: slot: 0 length: 5
2016-10-30 00:41:52: pid 5143: DEBUG: processing ReadyForQuery
2016-10-30 00:41:52: pid 5143: DETAIL: transaction state '
2016-10-30 00:41:55: pid 5143: DEBUG: processing frontend response
2016-10-30 00:41:55: pid 5143: DETAIL: received kind 'Q'(51) from frontend
2016-10-30 00:41:55: pid 5143: DEBUG: session context: clearing doing extended query messaging. DONE
2016-10-30 00:41:55: pid 5143: DEBUG: session context: setting query in progress. DONE
2016-10-30 00:41:55: pid 5143: DEBUG: function call walker, function name: "pg_get_userbyid"
2016-10-30 00:41:55: pid 5143: DEBUG: function call walker, function name: "pg_encoding_to_char"
2016-10-30 00:41:55: pid 5143: DEBUG: function call walker, function name: "array_to_string"
2016-10-30 00:41:55: pid 5143: DEBUG: waiting for query response
2016-10-30 00:41:55: pid 5143: DETAIL: waiting for backend:0 to complete the query
2016-10-30 00:41:55: pid 5143: DEBUG: detect error: kind: T
2016-10-30 00:41:55: pid 5143: DEBUG: detect error: kind: T
2016-10-30 00:41:55: pid 5143: DEBUG: detect error: kind: T
2016-10-30 00:41:55: pid 5143: DEBUG: detect error: kind: T
2016-10-30 00:41:55: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:41:55: pid 5143: DETAIL: backend:0 of 2 kind = 'T'
2016-10-30 00:41:55: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:55: pid 5143: DETAIL: received kind 'T'(54) from backend
2016-10-30 00:41:55: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:41:55: pid 5143: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:41:55: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:55: pid 5143: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:41:55: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:41:55: pid 5143: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:41:55: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:55: pid 5143: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:41:55: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:41:55: pid 5143: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:41:55: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:55: pid 5143: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:41:55: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:41:55: pid 5143: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:41:55: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:55: pid 5143: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:41:55: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:41:55: pid 5143: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:41:55: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:55: pid 5143: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:41:55: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:41:55: pid 5143: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:41:55: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:55: pid 5143: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:41:55: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:41:55: pid 5143: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:41:55: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:55: pid 5143: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:41:55: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:41:55: pid 5143: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:41:55: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:55: pid 5143: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:41:55: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:41:55: pid 5143: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:41:55: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:55: pid 5143: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:41:55: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:41:55: pid 5143: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:41:55: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:55: pid 5143: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:41:55: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:41:55: pid 5143: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:41:55: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:55: pid 5143: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:41:55: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:41:55: pid 5143: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:41:55: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:55: pid 5143: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:41:55: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:41:55: pid 5143: DETAIL: backend:0 of 2 kind = 'C'
2016-10-30 00:41:55: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:55: pid 5143: DETAIL: received kind 'C'(43) from backend
2016-10-30 00:41:55: pid 5143: DEBUG: session context: setting command success. DONE
2016-10-30 00:41:55: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:41:55: pid 5143: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:41:55: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:55: pid 5143: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:41:55: pid 5143: DEBUG: processing backend response
2016-10-30 00:41:55: pid 5143: DETAIL: Ready For Query received
2016-10-30 00:41:55: pid 5143: DEBUG: reading message length
2016-10-30 00:41:55: pid 5143: DETAIL: slot: 0 length: 5
2016-10-30 00:41:55: pid 5143: DEBUG: processing ReadyForQuery
2016-10-30 00:41:55: pid 5143: DETAIL: transaction state 'I'(49)
2016-10-30 00:42:11: pid 5143: DEBUG: processing frontend response
2016-10-30 00:42:11: pid 5143: DETAIL: received kind 'Q'(51) from frontend
2016-10-30 00:42:11: pid 5143: DEBUG: session context: clearing doing extended query messaging. DONE
2016-10-30 00:42:11: pid 5143: DEBUG: session context: setting query in progress. DONE
2016-10-30 00:42:11: pid 5143: DEBUG: waiting for query response
2016-10-30 00:42:11: pid 5143: DETAIL: waiting for backend:0 to complete the query
2016-10-30 00:42:11: pid 5143: DEBUG: detect error: kind: C
2016-10-30 00:42:11: pid 5143: DEBUG: detect error: kind: C
2016-10-30 00:42:11: pid 5143: DEBUG: detect error: kind: C
2016-10-30 00:42:11: pid 5143: DEBUG: detect error: kind: C
2016-10-30 00:42:11: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:42:11: pid 5143: DETAIL: backend:0 of 2 kind = 'C'
2016-10-30 00:42:11: pid 5143: DEBUG: processing backend response
2016-10-30 00:42:11: pid 5143: DETAIL: received kind 'C'(43) from backend
2016-10-30 00:42:11: pid 5143: DEBUG: session context: setting command success. DONE
2016-10-30 00:42:11: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:42:11: pid 5143: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:42:11: pid 5143: DEBUG: processing backend response
2016-10-30 00:42:11: pid 5143: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:42:11: pid 5143: DEBUG: processing backend response
2016-10-30 00:42:11: pid 5143: DETAIL: Ready For Query received
2016-10-30 00:42:11: pid 5143: DEBUG: reading message length
2016-10-30 00:42:11: pid 5143: DETAIL: slot: 0 length: 5
2016-10-30 00:42:11: pid 5143: DEBUG: processing ReadyForQuery
2016-10-30 00:42:11: pid 5143: DETAIL: transaction state 'I'(49)
2016-10-30 00:42:36: pid 5143: DEBUG: processing frontend response
2016-10-30 00:42:36: pid 5143: DETAIL: received kind 'X'(58) from frontend
2016-10-30 00:42:36: pid 5143: DEBUG: session context: clearing doing extended query messaging. DONE
2016-10-30 00:42:36: pid 5143: DEBUG: Frontend terminated
2016-10-30 00:42:36: pid 5143: DETAIL: received message kind 'X' from frontend
2016-10-30 00:42:36: pid 5143: DEBUG: session context: setting query in progress. DONE
2016-10-30 00:42:36: pid 5143: DEBUG: waiting for query response
2016-10-30 00:42:36: pid 5143: DETAIL: waiting for backend:0 to complete the query
2016-10-30 00:42:36: pid 5143: DEBUG: detect error: kind: S
2016-10-30 00:42:36: pid 5143: DEBUG: detect error: kind: S
2016-10-30 00:42:36: pid 5143: DEBUG: detect error: kind: S
2016-10-30 00:42:36: pid 5143: DEBUG: detect error: kind: S
2016-10-30 00:42:36: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:42:36: pid 5143: DETAIL: parameter name: is_superuser value: "on"
2016-10-30 00:42:36: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:42:36: pid 5143: DETAIL: parameter name: session_authorization value: "postgres"
2016-10-30 00:42:36: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:42:36: pid 5143: DETAIL: backend:0 of 2 kind = 'C'
2016-10-30 00:42:36: pid 5143: DEBUG: processing backend response
2016-10-30 00:42:36: pid 5143: DETAIL: received kind 'C'(43) from backend
2016-10-30 00:42:36: pid 5143: DEBUG: session context: setting command success. DONE
2016-10-30 00:42:36: pid 5143: DEBUG: reading backend data packet kind
2016-10-30 00:42:36: pid 5143: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:42:36: pid 5143: DEBUG: processing backend response
2016-10-30 00:42:36: pid 5143: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:42:36: pid 5143: DEBUG: processing backend response
2016-10-30 00:42:36: pid 5143: DETAIL: Ready For Query received
2016-10-30 00:42:36: pid 5143: DEBUG: reading message length
2016-10-30 00:42:36: pid 5143: DETAIL: slot: 0 length: 5
2016-10-30 00:42:36: pid 5143: DEBUG: processing ReadyForQuery
2016-10-30 00:42:36: pid 5143: DETAIL: transaction state 'I'(49)
2016-10-30 00:42:36: pid 5143: DEBUG: setting backend connection close timer
2016-10-30 00:42:36: pid 5143: DETAIL: close time 1477780956
2016-10-30 00:44:39: pid 5140: DEBUG: I am 5140 accept fd 7
2016-10-30 00:44:39: pid 5140: DEBUG: reading startup packet
2016-10-30 00:44:39: pid 5140: DETAIL: application_name: psql
2016-10-30 00:44:39: pid 5140: DEBUG: reading startup packet
2016-10-30 00:44:39: pid 5140: DETAIL: Protocol Major: 3 Minor: 0 database: postgres user: postgres
2016-10-30 00:44:39: pid 5140: DEBUG: creating new connection to backend
2016-10-30 00:44:39: pid 5140: DETAIL: connecting 0 backend
2016-10-30 00:44:39: pid 5140: DEBUG: creating new connection to backend
2016-10-30 00:44:39: pid 5140: DETAIL: connecting 1 backend
2016-10-30 00:44:39: pid 5140: DEBUG: creating new connection to backend
2016-10-30 00:44:39: pid 5140: DETAIL: skipping backend slot 1 because backend_status = 3
2016-10-30 00:44:39: pid 5140: DEBUG: SSL is requested but SSL support is not available
2016-10-30 00:44:39: pid 5140: DEBUG: reading message length
2016-10-30 00:44:39: pid 5140: DETAIL: slot: 0 length: 8
2016-10-30 00:44:39: pid 5140: DEBUG: authentication backend
2016-10-30 00:44:39: pid 5140: DETAIL: auth kind:0
2016-10-30 00:44:39: pid 5140: DEBUG: reading message length
2016-10-30 00:44:39: pid 5140: DETAIL: master slot: 0 length: 26
2016-10-30 00:44:39: pid 5140: DEBUG: process parameter status
2016-10-30 00:44:39: pid 5140: DETAIL: backend:0 name:"application_name" value:"psql"
2016-10-30 00:44:39: pid 5140: DEBUG: reading message length
2016-10-30 00:44:39: pid 5140: DETAIL: master slot: 0 length: 25
2016-10-30 00:44:39: pid 5140: DEBUG: process parameter status
2016-10-30 00:44:39: pid 5140: DETAIL: backend:0 name:"client_encoding" value:"UTF8"
2016-10-30 00:44:39: pid 5140: DEBUG: reading message length
2016-10-30 00:44:39: pid 5140: DETAIL: master slot: 0 length: 23
2016-10-30 00:44:39: pid 5140: DEBUG: process parameter status
2016-10-30 00:44:39: pid 5140: DETAIL: backend:0 name:"DateStyle" value:"ISO, DMY"
2016-10-30 00:44:39: pid 5140: DEBUG: reading message length
2016-10-30 00:44:39: pid 5140: DETAIL: master slot: 0 length: 25
2016-10-30 00:44:39: pid 5140: DEBUG: process parameter status
2016-10-30 00:44:39: pid 5140: DETAIL: backend:0 name:"integer_datetimes" value:"on"
2016-10-30 00:44:39: pid 5140: DEBUG: reading message length
2016-10-30 00:44:39: pid 5140: DETAIL: master slot: 0 length: 27
2016-10-30 00:44:39: pid 5140: DEBUG: process parameter status
2016-10-30 00:44:39: pid 5140: DETAIL: backend:0 name:"IntervalStyle" value:"postgres"
2016-10-30 00:44:39: pid 5140: DEBUG: reading message length
2016-10-30 00:44:39: pid 5140: DETAIL: master slot: 0 length: 20
2016-10-30 00:44:39: pid 5140: DEBUG: process parameter status
2016-10-30 00:44:39: pid 5140: DETAIL: backend:0 name:"is_superuser" value:"on"
2016-10-30 00:44:39: pid 5140: DEBUG: reading message length
2016-10-30 00:44:39: pid 5140: DETAIL: master slot: 0 length: 25
2016-10-30 00:44:39: pid 5140: DEBUG: process parameter status
2016-10-30 00:44:39: pid 5140: DETAIL: backend:0 name:"server_encoding" value:"UTF8"
2016-10-30 00:44:39: pid 5140: DEBUG: reading message length
2016-10-30 00:44:39: pid 5140: DETAIL: master slot: 0 length: 26
2016-10-30 00:44:39: pid 5140: DEBUG: process parameter status
2016-10-30 00:44:39: pid 5140: DETAIL: backend:0 name:"server_version" value:"9.2.14"
2016-10-30 00:44:39: pid 5140: DEBUG: reading message length
2016-10-30 00:44:39: pid 5140: DETAIL: master slot: 0 length: 35
2016-10-30 00:44:39: pid 5140: DEBUG: process parameter status
2016-10-30 00:44:39: pid 5140: DETAIL: backend:0 name:"session_authorization" value:"postgres"
2016-10-30 00:44:39: pid 5140: DEBUG: reading message length
2016-10-30 00:44:39: pid 5140: DETAIL: master slot: 0 length: 35
2016-10-30 00:44:39: pid 5140: DEBUG: process parameter status
2016-10-30 00:44:39: pid 5140: DETAIL: backend:0 name:"standard_conforming_strings" value:"on"
2016-10-30 00:44:39: pid 5140: DEBUG: reading message length
2016-10-30 00:44:39: pid 5140: DETAIL: master slot: 0 length: 26
2016-10-30 00:44:39: pid 5140: DEBUG: process parameter status
2016-10-30 00:44:39: pid 5140: DETAIL: backend:0 name:"TimeZone" value:"Europe/Malta"
2016-10-30 00:44:39: pid 5140: DEBUG: reading message length
2016-10-30 00:44:39: pid 5140: DETAIL: slot: 0 length: 12
2016-10-30 00:44:39: pid 5140: DEBUG: authentication backend
2016-10-30 00:44:39: pid 5140: DETAIL: cp->info[i]:0x7fe107a46000 pid:5248
2016-10-30 00:44:39: pid 5140: DEBUG: sending backend key data
2016-10-30 00:44:39: pid 5140: DETAIL: send pid 5248 to frontend
2016-10-30 00:44:39: pid 5140: DEBUG: selecting load balance node
2016-10-30 00:44:39: pid 5140: DETAIL: selected backend id is 0
2016-10-30 00:44:39: pid 5140: DEBUG: initializing session context
2016-10-30 00:44:39: pid 5140: DETAIL: selected load balancing node: 0
2016-10-30 00:44:39: pid 5140: DEBUG: session context: clearing transaction isolation. DONE
2016-10-30 00:44:39: pid 5140: DEBUG: session context: clearing writing transaction. DONE
2016-10-30 00:44:39: pid 5140: DEBUG: session context: clearing failed transaction. DONE
2016-10-30 00:44:39: pid 5140: DEBUG: session context: clearing failed transaction. DONE
2016-10-30 00:44:39: pid 5140: DEBUG: session context: clearing skip reading from backends. DONE
2016-10-30 00:44:39: pid 5140: DEBUG: session context: clearing ignore till sync. DONE
2016-10-30 00:44:39: pid 5140: DEBUG: reading backend data packet kind
2016-10-30 00:44:39: pid 5140: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:44:39: pid 5140: DEBUG: processing backend response
2016-10-30 00:44:39: pid 5140: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:44:39: pid 5140: DEBUG: processing backend response
2016-10-30 00:44:39: pid 5140: DETAIL: Ready For Query received
2016-10-30 00:44:39: pid 5140: DEBUG: reading message length
2016-10-30 00:44:39: pid 5140: DETAIL: slot: 0 length: 5
2016-10-30 00:44:39: pid 5140: DEBUG: processing ReadyForQuery
2016-10-30 00:44:39: pid 5140: DETAIL: transaction state '
2016-10-30 00:44:39: pid 5140: DEBUG: processing frontend response
2016-10-30 00:44:39: pid 5140: DETAIL: received kind 'Q'(51) from frontend
2016-10-30 00:44:39: pid 5140: DEBUG: session context: clearing doing extended query messaging. DONE
2016-10-30 00:44:39: pid 5140: DEBUG: session context: setting query in progress. DONE
2016-10-30 00:44:39: pid 5140: DEBUG: SimpleQuery
2016-10-30 00:44:39: pid 5140: DETAIL: nodes reporting
2016-10-30 00:44:39: pid 5140: DEBUG: session context: setting skip reading from backends. DONE
2016-10-30 00:44:39: pid 5140: DEBUG: processing frontend response
2016-10-30 00:44:39: pid 5140: DETAIL: received kind 'X'(58) from frontend
2016-10-30 00:44:39: pid 5140: DEBUG: session context: clearing doing extended query messaging. DONE
2016-10-30 00:44:39: pid 5140: DEBUG: Frontend terminated
2016-10-30 00:44:39: pid 5140: DETAIL: received message kind 'X' from frontend
2016-10-30 00:44:39: pid 5140: DEBUG: session context: setting query in progress. DONE
2016-10-30 00:44:39: pid 5140: DEBUG: waiting for query response
2016-10-30 00:44:39: pid 5140: DETAIL: waiting for backend:0 to complete the query
2016-10-30 00:44:39: pid 5140: DEBUG: detect error: kind: S
2016-10-30 00:44:39: pid 5140: DEBUG: detect error: kind: S
2016-10-30 00:44:39: pid 5140: DEBUG: detect error: kind: S
2016-10-30 00:44:39: pid 5140: DEBUG: detect error: kind: S
2016-10-30 00:44:39: pid 5140: DEBUG: session context: clearing skip reading from backends. DONE
2016-10-30 00:44:39: pid 5140: DEBUG: reading backend data packet kind
2016-10-30 00:44:39: pid 5140: DETAIL: parameter name: is_superuser value: "on"
2016-10-30 00:44:39: pid 5140: DEBUG: reading backend data packet kind
2016-10-30 00:44:39: pid 5140: DETAIL: parameter name: session_authorization value: "postgres"
2016-10-30 00:44:39: pid 5140: DEBUG: reading backend data packet kind
2016-10-30 00:44:39: pid 5140: DETAIL: backend:0 of 2 kind = 'C'
2016-10-30 00:44:39: pid 5140: DEBUG: processing backend response
2016-10-30 00:44:39: pid 5140: DETAIL: received kind 'C'(43) from backend
2016-10-30 00:44:39: pid 5140: DEBUG: session context: setting command success. DONE
2016-10-30 00:44:39: pid 5140: DEBUG: reading backend data packet kind
2016-10-30 00:44:39: pid 5140: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:44:39: pid 5140: DEBUG: processing backend response
2016-10-30 00:44:39: pid 5140: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:44:39: pid 5140: DEBUG: processing backend response
2016-10-30 00:44:39: pid 5140: DETAIL: Ready For Query received
2016-10-30 00:44:39: pid 5140: DEBUG: reading message length
2016-10-30 00:44:39: pid 5140: DETAIL: slot: 0 length: 5
2016-10-30 00:44:39: pid 5140: DEBUG: processing ReadyForQuery
2016-10-30 00:44:39: pid 5140: DETAIL: transaction state 'I'(49)
2016-10-30 00:44:39: pid 5140: DEBUG: setting backend connection close timer
2016-10-30 00:44:39: pid 5140: DETAIL: close time 1477781079
2016-10-30 00:47:36: pid 5143: DEBUG: child life 300 seconds expired
2016-10-30 00:47:36: pid 4452: DEBUG: reaper handler
2016-10-30 00:47:36: pid 4452: LOG: child process with pid: 5143 exits with status 512
2016-10-30 00:47:36: pid 4452: LOG: fork a new child process with pid: 5267
2016-10-30 00:47:36: pid 4452: DEBUG: reaper handler: exiting normally
2016-10-30 00:47:36: pid 5267: DEBUG: initializing backend status
2016-10-30 00:49:40: pid 5140: DEBUG: child life 300 seconds expired
2016-10-30 00:49:40: pid 4452: DEBUG: reaper handler
2016-10-30 00:49:40: pid 4452: LOG: child process with pid: 5140 exits with status 512
2016-10-30 00:49:40: pid 4452: LOG: fork a new child process with pid: 5282
2016-10-30 00:49:40: pid 4452: DEBUG: reaper handler: exiting normally
2016-10-30 00:49:40: pid 5282: DEBUG: initializing backend status
2016-10-30 00:56:26: pid 5282: DEBUG: I am 5282 accept fd 7
2016-10-30 00:56:26: pid 5282: DEBUG: reading startup packet
2016-10-30 00:56:26: pid 5282: DETAIL: application_name: psql
2016-10-30 00:56:26: pid 5282: DEBUG: reading startup packet
2016-10-30 00:56:26: pid 5282: DETAIL: Protocol Major: 3 Minor: 0 database: postgres user: postgres
2016-10-30 00:56:26: pid 5282: DEBUG: creating new connection to backend
2016-10-30 00:56:26: pid 5282: DETAIL: connecting 0 backend
2016-10-30 00:56:26: pid 5282: DEBUG: creating new connection to backend
2016-10-30 00:56:26: pid 5282: DETAIL: connecting 1 backend
2016-10-30 00:56:26: pid 5282: DEBUG: creating new connection to backend
2016-10-30 00:56:26: pid 5282: DETAIL: skipping backend slot 1 because backend_status = 3
2016-10-30 00:56:26: pid 5282: DEBUG: SSL is requested but SSL support is not available
2016-10-30 00:56:26: pid 5282: DEBUG: reading message length
2016-10-30 00:56:26: pid 5282: DETAIL: slot: 0 length: 8
2016-10-30 00:56:26: pid 5282: DEBUG: authentication backend
2016-10-30 00:56:26: pid 5282: DETAIL: auth kind:0
2016-10-30 00:56:26: pid 5282: DEBUG: reading message length
2016-10-30 00:56:26: pid 5282: DETAIL: master slot: 0 length: 26
2016-10-30 00:56:26: pid 5282: DEBUG: process parameter status
2016-10-30 00:56:26: pid 5282: DETAIL: backend:0 name:"application_name" value:"psql"
2016-10-30 00:56:26: pid 5282: DEBUG: reading message length
2016-10-30 00:56:26: pid 5282: DETAIL: master slot: 0 length: 25
2016-10-30 00:56:26: pid 5282: DEBUG: process parameter status
2016-10-30 00:56:26: pid 5282: DETAIL: backend:0 name:"client_encoding" value:"UTF8"
2016-10-30 00:56:26: pid 5282: DEBUG: reading message length
2016-10-30 00:56:26: pid 5282: DETAIL: master slot: 0 length: 23
2016-10-30 00:56:26: pid 5282: DEBUG: process parameter status
2016-10-30 00:56:26: pid 5282: DETAIL: backend:0 name:"DateStyle" value:"ISO, DMY"
2016-10-30 00:56:26: pid 5282: DEBUG: reading message length
2016-10-30 00:56:26: pid 5282: DETAIL: master slot: 0 length: 25
2016-10-30 00:56:26: pid 5282: DEBUG: process parameter status
2016-10-30 00:56:26: pid 5282: DETAIL: backend:0 name:"integer_datetimes" value:"on"
2016-10-30 00:56:26: pid 5282: DEBUG: reading message length
2016-10-30 00:56:26: pid 5282: DETAIL: master slot: 0 length: 27
2016-10-30 00:56:26: pid 5282: DEBUG: process parameter status
2016-10-30 00:56:26: pid 5282: DETAIL: backend:0 name:"IntervalStyle" value:"postgres"
2016-10-30 00:56:26: pid 5282: DEBUG: reading message length
2016-10-30 00:56:26: pid 5282: DETAIL: master slot: 0 length: 20
2016-10-30 00:56:26: pid 5282: DEBUG: process parameter status
2016-10-30 00:56:26: pid 5282: DETAIL: backend:0 name:"is_superuser" value:"on"
2016-10-30 00:56:26: pid 5282: DEBUG: reading message length
2016-10-30 00:56:26: pid 5282: DETAIL: master slot: 0 length: 25
2016-10-30 00:56:26: pid 5282: DEBUG: process parameter status
2016-10-30 00:56:26: pid 5282: DETAIL: backend:0 name:"server_encoding" value:"UTF8"
2016-10-30 00:56:26: pid 5282: DEBUG: reading message length
2016-10-30 00:56:26: pid 5282: DETAIL: master slot: 0 length: 26
2016-10-30 00:56:26: pid 5282: DEBUG: process parameter status
2016-10-30 00:56:26: pid 5282: DETAIL: backend:0 name:"server_version" value:"9.2.14"
2016-10-30 00:56:26: pid 5282: DEBUG: reading message length
2016-10-30 00:56:26: pid 5282: DETAIL: master slot: 0 length: 35
2016-10-30 00:56:26: pid 5282: DEBUG: process parameter status
2016-10-30 00:56:26: pid 5282: DETAIL: backend:0 name:"session_authorization" value:"postgres"
2016-10-30 00:56:26: pid 5282: DEBUG: reading message length
2016-10-30 00:56:26: pid 5282: DETAIL: master slot: 0 length: 35
2016-10-30 00:56:26: pid 5282: DEBUG: process parameter status
2016-10-30 00:56:26: pid 5282: DETAIL: backend:0 name:"standard_conforming_strings" value:"on"
2016-10-30 00:56:26: pid 5282: DEBUG: reading message length
2016-10-30 00:56:26: pid 5282: DETAIL: master slot: 0 length: 26
2016-10-30 00:56:26: pid 5282: DEBUG: process parameter status
2016-10-30 00:56:26: pid 5282: DETAIL: backend:0 name:"TimeZone" value:"Europe/Malta"
2016-10-30 00:56:26: pid 5282: DEBUG: reading message length
2016-10-30 00:56:26: pid 5282: DETAIL: slot: 0 length: 12
2016-10-30 00:56:26: pid 5282: DEBUG: authentication backend
2016-10-30 00:56:26: pid 5282: DETAIL: cp->info[i]:0x7fe107a46000 pid:5341
2016-10-30 00:56:26: pid 5282: DEBUG: sending backend key data
2016-10-30 00:56:26: pid 5282: DETAIL: send pid 5341 to frontend
2016-10-30 00:56:26: pid 5282: DEBUG: selecting load balance node
2016-10-30 00:56:26: pid 5282: DETAIL: selected backend id is 0
2016-10-30 00:56:26: pid 5282: DEBUG: initializing session context
2016-10-30 00:56:26: pid 5282: DETAIL: selected load balancing node: 0
2016-10-30 00:56:26: pid 5282: DEBUG: session context: clearing transaction isolation. DONE
2016-10-30 00:56:26: pid 5282: DEBUG: session context: clearing writing transaction. DONE
2016-10-30 00:56:26: pid 5282: DEBUG: session context: clearing failed transaction. DONE
2016-10-30 00:56:26: pid 5282: DEBUG: session context: clearing failed transaction. DONE
2016-10-30 00:56:26: pid 5282: DEBUG: session context: clearing skip reading from backends. DONE
2016-10-30 00:56:26: pid 5282: DEBUG: session context: clearing ignore till sync. DONE
2016-10-30 00:56:26: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:26: pid 5282: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:56:26: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:26: pid 5282: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:56:26: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:26: pid 5282: DETAIL: Ready For Query received
2016-10-30 00:56:26: pid 5282: DEBUG: reading message length
2016-10-30 00:56:26: pid 5282: DETAIL: slot: 0 length: 5
2016-10-30 00:56:26: pid 5282: DEBUG: processing ReadyForQuery
2016-10-30 00:56:26: pid 5282: DETAIL: transaction state '
2016-10-30 00:56:28: pid 5282: DEBUG: processing frontend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'Q'(51) from frontend
2016-10-30 00:56:28: pid 5282: DEBUG: session context: clearing doing extended query messaging. DONE
2016-10-30 00:56:28: pid 5282: DEBUG: session context: setting query in progress. DONE
2016-10-30 00:56:28: pid 5282: DEBUG: function call walker, function name: "pg_get_userbyid"
2016-10-30 00:56:28: pid 5282: DEBUG: function call walker, function name: "pg_encoding_to_char"
2016-10-30 00:56:28: pid 5282: DEBUG: function call walker, function name: "array_to_string"
2016-10-30 00:56:28: pid 5282: DEBUG: waiting for query response
2016-10-30 00:56:28: pid 5282: DETAIL: waiting for backend:0 to complete the query
2016-10-30 00:56:28: pid 5282: DEBUG: detect error: kind: T
2016-10-30 00:56:28: pid 5282: DEBUG: detect error: kind: T
2016-10-30 00:56:28: pid 5282: DEBUG: detect error: kind: T
2016-10-30 00:56:28: pid 5282: DEBUG: detect error: kind: T
2016-10-30 00:56:28: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:28: pid 5282: DETAIL: backend:0 of 2 kind = 'T'
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'T'(54) from backend
2016-10-30 00:56:28: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:28: pid 5282: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:56:28: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:28: pid 5282: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:56:28: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:28: pid 5282: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:56:28: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:28: pid 5282: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:56:28: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:28: pid 5282: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:56:28: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:28: pid 5282: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:56:28: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:28: pid 5282: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:56:28: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:28: pid 5282: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:56:28: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:28: pid 5282: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:56:28: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:28: pid 5282: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:56:28: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:28: pid 5282: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:56:28: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:28: pid 5282: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:56:28: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:28: pid 5282: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:56:28: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:28: pid 5282: DETAIL: backend:0 of 2 kind = 'D'
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'D'(44) from backend
2016-10-30 00:56:28: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:28: pid 5282: DETAIL: backend:0 of 2 kind = 'C'
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'C'(43) from backend
2016-10-30 00:56:28: pid 5282: DEBUG: session context: setting command success. DONE
2016-10-30 00:56:28: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:28: pid 5282: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:56:28: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:28: pid 5282: DETAIL: Ready For Query received
2016-10-30 00:56:28: pid 5282: DEBUG: reading message length
2016-10-30 00:56:28: pid 5282: DETAIL: slot: 0 length: 5
2016-10-30 00:56:28: pid 5282: DEBUG: processing ReadyForQuery
2016-10-30 00:56:28: pid 5282: DETAIL: transaction state 'I'(49)
2016-10-30 00:56:47: pid 5282: DEBUG: processing frontend response
2016-10-30 00:56:47: pid 5282: DETAIL: received kind 'Q'(51) from frontend
2016-10-30 00:56:47: pid 5282: DEBUG: session context: clearing doing extended query messaging. DONE
2016-10-30 00:56:47: pid 5282: DEBUG: session context: setting query in progress. DONE
2016-10-30 00:56:47: pid 5282: DEBUG: waiting for query response
2016-10-30 00:56:47: pid 5282: DETAIL: waiting for backend:0 to complete the query
2016-10-30 00:56:47: pid 5282: DEBUG: detect error: kind: C
2016-10-30 00:56:47: pid 5282: DEBUG: detect error: kind: C
2016-10-30 00:56:47: pid 5282: DEBUG: detect error: kind: C
2016-10-30 00:56:47: pid 5282: DEBUG: detect error: kind: C
2016-10-30 00:56:47: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:47: pid 5282: DETAIL: backend:0 of 2 kind = 'C'
2016-10-30 00:56:47: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:47: pid 5282: DETAIL: received kind 'C'(43) from backend
2016-10-30 00:56:47: pid 5282: DEBUG: session context: setting command success. DONE
2016-10-30 00:56:47: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:56:47: pid 5282: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:56:47: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:47: pid 5282: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:56:47: pid 5282: DEBUG: processing backend response
2016-10-30 00:56:47: pid 5282: DETAIL: Ready For Query received
2016-10-30 00:56:47: pid 5282: DEBUG: reading message length
2016-10-30 00:56:47: pid 5282: DETAIL: slot: 0 length: 5
2016-10-30 00:56:47: pid 5282: DEBUG: processing ReadyForQuery
2016-10-30 00:56:47: pid 5282: DETAIL: transaction state 'I'(49)
2016-10-30 00:57:02: pid 5282: DEBUG: processing frontend response
2016-10-30 00:57:02: pid 5282: DETAIL: received kind 'X'(58) from frontend
2016-10-30 00:57:02: pid 5282: DEBUG: session context: clearing doing extended query messaging. DONE
2016-10-30 00:57:02: pid 5282: DEBUG: Frontend terminated
2016-10-30 00:57:02: pid 5282: DETAIL: received message kind 'X' from frontend
2016-10-30 00:57:02: pid 5282: DEBUG: session context: setting query in progress. DONE
2016-10-30 00:57:02: pid 5282: DEBUG: waiting for query response
2016-10-30 00:57:02: pid 5282: DETAIL: waiting for backend:0 to complete the query
2016-10-30 00:57:02: pid 5282: DEBUG: detect error: kind: S
2016-10-30 00:57:02: pid 5282: DEBUG: detect error: kind: S
2016-10-30 00:57:02: pid 5282: DEBUG: detect error: kind: S
2016-10-30 00:57:02: pid 5282: DEBUG: detect error: kind: S
2016-10-30 00:57:02: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:57:02: pid 5282: DETAIL: parameter name: is_superuser value: "on"
2016-10-30 00:57:02: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:57:02: pid 5282: DETAIL: parameter name: session_authorization value: "postgres"
2016-10-30 00:57:02: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:57:02: pid 5282: DETAIL: backend:0 of 2 kind = 'C'
2016-10-30 00:57:02: pid 5282: DEBUG: processing backend response
2016-10-30 00:57:02: pid 5282: DETAIL: received kind 'C'(43) from backend
2016-10-30 00:57:02: pid 5282: DEBUG: session context: setting command success. DONE
2016-10-30 00:57:02: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:57:02: pid 5282: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:57:02: pid 5282: DEBUG: processing backend response
2016-10-30 00:57:02: pid 5282: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:57:02: pid 5282: DEBUG: processing backend response
2016-10-30 00:57:02: pid 5282: DETAIL: Ready For Query received
2016-10-30 00:57:02: pid 5282: DEBUG: reading message length
2016-10-30 00:57:02: pid 5282: DETAIL: slot: 0 length: 5
2016-10-30 00:57:02: pid 5282: DEBUG: processing ReadyForQuery
2016-10-30 00:57:02: pid 5282: DETAIL: transaction state 'I'(49)
2016-10-30 00:57:02: pid 5282: DEBUG: setting backend connection close timer
2016-10-30 00:57:02: pid 5282: DETAIL: close time 1477781822
2016-10-30 00:57:23: pid 5282: DEBUG: I am 5282 accept fd 7
2016-10-30 00:57:23: pid 5282: DEBUG: reading startup packet
2016-10-30 00:57:23: pid 5282: DETAIL: application_name: psql
2016-10-30 00:57:23: pid 5282: DEBUG: reading startup packet
2016-10-30 00:57:23: pid 5282: DETAIL: Protocol Major: 3 Minor: 0 database: postgres user: postgres
2016-10-30 00:57:23: pid 5282: DEBUG: creating new connection to backend
2016-10-30 00:57:23: pid 5282: DETAIL: connecting 0 backend
2016-10-30 00:57:23: pid 5282: DEBUG: creating new connection to backend
2016-10-30 00:57:23: pid 5282: DETAIL: connecting 1 backend
2016-10-30 00:57:23: pid 5282: DEBUG: creating new connection to backend
2016-10-30 00:57:23: pid 5282: DETAIL: skipping backend slot 1 because backend_status = 3
2016-10-30 00:57:23: pid 5282: DEBUG: SSL is requested but SSL support is not available
2016-10-30 00:57:23: pid 5282: DEBUG: reading message length
2016-10-30 00:57:23: pid 5282: DETAIL: slot: 0 length: 8
2016-10-30 00:57:23: pid 5282: DEBUG: authentication backend
2016-10-30 00:57:23: pid 5282: DETAIL: auth kind:0
2016-10-30 00:57:23: pid 5282: DEBUG: reading message length
2016-10-30 00:57:23: pid 5282: DETAIL: master slot: 0 length: 26
2016-10-30 00:57:23: pid 5282: DEBUG: process parameter status
2016-10-30 00:57:23: pid 5282: DETAIL: backend:0 name:"application_name" value:"psql"
2016-10-30 00:57:23: pid 5282: DEBUG: reading message length
2016-10-30 00:57:23: pid 5282: DETAIL: master slot: 0 length: 25
2016-10-30 00:57:23: pid 5282: DEBUG: process parameter status
2016-10-30 00:57:23: pid 5282: DETAIL: backend:0 name:"client_encoding" value:"UTF8"
2016-10-30 00:57:23: pid 5282: DEBUG: reading message length
2016-10-30 00:57:23: pid 5282: DETAIL: master slot: 0 length: 23
2016-10-30 00:57:23: pid 5282: DEBUG: process parameter status
2016-10-30 00:57:23: pid 5282: DETAIL: backend:0 name:"DateStyle" value:"ISO, DMY"
2016-10-30 00:57:23: pid 5282: DEBUG: reading message length
2016-10-30 00:57:23: pid 5282: DETAIL: master slot: 0 length: 25
2016-10-30 00:57:23: pid 5282: DEBUG: process parameter status
2016-10-30 00:57:23: pid 5282: DETAIL: backend:0 name:"integer_datetimes" value:"on"
2016-10-30 00:57:23: pid 5282: DEBUG: reading message length
2016-10-30 00:57:23: pid 5282: DETAIL: master slot: 0 length: 27
2016-10-30 00:57:23: pid 5282: DEBUG: process parameter status
2016-10-30 00:57:23: pid 5282: DETAIL: backend:0 name:"IntervalStyle" value:"postgres"
2016-10-30 00:57:23: pid 5282: DEBUG: reading message length
2016-10-30 00:57:23: pid 5282: DETAIL: master slot: 0 length: 20
2016-10-30 00:57:23: pid 5282: DEBUG: process parameter status
2016-10-30 00:57:23: pid 5282: DETAIL: backend:0 name:"is_superuser" value:"on"
2016-10-30 00:57:23: pid 5282: DEBUG: reading message length
2016-10-30 00:57:23: pid 5282: DETAIL: master slot: 0 length: 25
2016-10-30 00:57:23: pid 5282: DEBUG: process parameter status
2016-10-30 00:57:23: pid 5282: DETAIL: backend:0 name:"server_encoding" value:"UTF8"
2016-10-30 00:57:23: pid 5282: DEBUG: reading message length
2016-10-30 00:57:23: pid 5282: DETAIL: master slot: 0 length: 26
2016-10-30 00:57:23: pid 5282: DEBUG: process parameter status
2016-10-30 00:57:23: pid 5282: DETAIL: backend:0 name:"server_version" value:"9.2.14"
2016-10-30 00:57:23: pid 5282: DEBUG: reading message length
2016-10-30 00:57:23: pid 5282: DETAIL: master slot: 0 length: 35
2016-10-30 00:57:23: pid 5282: DEBUG: process parameter status
2016-10-30 00:57:23: pid 5282: DETAIL: backend:0 name:"session_authorization" value:"postgres"
2016-10-30 00:57:23: pid 5282: DEBUG: reading message length
2016-10-30 00:57:23: pid 5282: DETAIL: master slot: 0 length: 35
2016-10-30 00:57:23: pid 5282: DEBUG: process parameter status
2016-10-30 00:57:23: pid 5282: DETAIL: backend:0 name:"standard_conforming_strings" value:"on"
2016-10-30 00:57:23: pid 5282: DEBUG: reading message length
2016-10-30 00:57:23: pid 5282: DETAIL: master slot: 0 length: 26
2016-10-30 00:57:23: pid 5282: DEBUG: process parameter status
2016-10-30 00:57:23: pid 5282: DETAIL: backend:0 name:"TimeZone" value:"Europe/Malta"
2016-10-30 00:57:23: pid 5282: DEBUG: reading message length
2016-10-30 00:57:23: pid 5282: DETAIL: slot: 0 length: 12
2016-10-30 00:57:23: pid 5282: DEBUG: authentication backend
2016-10-30 00:57:23: pid 5282: DETAIL: cp->info[i]:0x7fe107a46000 pid:5351
2016-10-30 00:57:23: pid 5282: DEBUG: sending backend key data
2016-10-30 00:57:23: pid 5282: DETAIL: send pid 5351 to frontend
2016-10-30 00:57:23: pid 5282: DEBUG: selecting load balance node
2016-10-30 00:57:23: pid 5282: DETAIL: selected backend id is 0
2016-10-30 00:57:23: pid 5282: DEBUG: initializing session context
2016-10-30 00:57:23: pid 5282: DETAIL: selected load balancing node: 0
2016-10-30 00:57:23: pid 5282: DEBUG: session context: clearing transaction isolation. DONE
2016-10-30 00:57:23: pid 5282: DEBUG: session context: clearing writing transaction. DONE
2016-10-30 00:57:23: pid 5282: DEBUG: session context: clearing failed transaction. DONE
2016-10-30 00:57:23: pid 5282: DEBUG: session context: clearing failed transaction. DONE
2016-10-30 00:57:23: pid 5282: DEBUG: session context: clearing skip reading from backends. DONE
2016-10-30 00:57:23: pid 5282: DEBUG: session context: clearing ignore till sync. DONE
2016-10-30 00:57:23: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:57:23: pid 5282: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:57:23: pid 5282: DEBUG: processing backend response
2016-10-30 00:57:23: pid 5282: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:57:23: pid 5282: DEBUG: processing backend response
2016-10-30 00:57:23: pid 5282: DETAIL: Ready For Query received
2016-10-30 00:57:23: pid 5282: DEBUG: reading message length
2016-10-30 00:57:23: pid 5282: DETAIL: slot: 0 length: 5
2016-10-30 00:57:23: pid 5282: DEBUG: processing ReadyForQuery
2016-10-30 00:57:23: pid 5282: DETAIL: transaction state '
2016-10-30 00:57:23: pid 5282: DEBUG: processing frontend response
2016-10-30 00:57:23: pid 5282: DETAIL: received kind 'Q'(51) from frontend
2016-10-30 00:57:23: pid 5282: DEBUG: session context: clearing doing extended query messaging. DONE
2016-10-30 00:57:23: pid 5282: DEBUG: session context: setting query in progress. DONE
2016-10-30 00:57:23: pid 5282: DEBUG: SimpleQuery
2016-10-30 00:57:23: pid 5282: DETAIL: nodes reporting
2016-10-30 00:57:23: pid 5282: DEBUG: session context: setting skip reading from backends. DONE
2016-10-30 00:57:23: pid 5282: DEBUG: processing frontend response
2016-10-30 00:57:23: pid 5282: DETAIL: received kind 'X'(58) from frontend
2016-10-30 00:57:23: pid 5282: DEBUG: session context: clearing doing extended query messaging. DONE
2016-10-30 00:57:23: pid 5282: DEBUG: Frontend terminated
2016-10-30 00:57:23: pid 5282: DETAIL: received message kind 'X' from frontend
2016-10-30 00:57:23: pid 5282: DEBUG: session context: setting query in progress. DONE
2016-10-30 00:57:23: pid 5282: DEBUG: waiting for query response
2016-10-30 00:57:23: pid 5282: DETAIL: waiting for backend:0 to complete the query
2016-10-30 00:57:23: pid 5282: DEBUG: detect error: kind: S
2016-10-30 00:57:23: pid 5282: DEBUG: detect error: kind: S
2016-10-30 00:57:23: pid 5282: DEBUG: detect error: kind: S
2016-10-30 00:57:23: pid 5282: DEBUG: detect error: kind: S
2016-10-30 00:57:23: pid 5282: DEBUG: session context: clearing skip reading from backends. DONE
2016-10-30 00:57:23: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:57:23: pid 5282: DETAIL: parameter name: is_superuser value: "on"
2016-10-30 00:57:23: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:57:23: pid 5282: DETAIL: parameter name: session_authorization value: "postgres"
2016-10-30 00:57:23: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:57:23: pid 5282: DETAIL: backend:0 of 2 kind = 'C'
2016-10-30 00:57:23: pid 5282: DEBUG: processing backend response
2016-10-30 00:57:23: pid 5282: DETAIL: received kind 'C'(43) from backend
2016-10-30 00:57:23: pid 5282: DEBUG: session context: setting command success. DONE
2016-10-30 00:57:23: pid 5282: DEBUG: reading backend data packet kind
2016-10-30 00:57:23: pid 5282: DETAIL: backend:0 of 2 kind = 'Z'
2016-10-30 00:57:23: pid 5282: DEBUG: processing backend response
2016-10-30 00:57:23: pid 5282: DETAIL: received kind 'Z'(5a) from backend
2016-10-30 00:57:23: pid 5282: DEBUG: processing backend response
2016-10-30 00:57:23: pid 5282: DETAIL: Ready For Query received
2016-10-30 00:57:23: pid 5282: DEBUG: reading message length
2016-10-30 00:57:23: pid 5282: DETAIL: slot: 0 length: 5
2016-10-30 00:57:23: pid 5282: DEBUG: processing ReadyForQuery
2016-10-30 00:57:23: pid 5282: DETAIL: transaction state 'I'(49)
2016-10-30 00:57:23: pid 5282: DEBUG: setting backend connection close timer
2016-10-30 00:57:23: pid 5282: DETAIL: close time 1477781843

pengbo

2017-03-12 23:50

developer   ~0001375

| bash-4.2$ /usr/local/bin/pcp_attach_node -d 10 srvmtitatl02 9898 postgres postgres 1

If the pcp_attach_node command is executed only on srvmtitatl02, pgpool_status file on srvmtitatl01 will not be changed. You need also execute
pcp_attach_node on srvmtitatl01.

Also, when you start pgpool on both server after recovery, you can use the "-D" option to discard pgpool_status file like this:

  /usr/bin/pgpool -n -D -f /etc/pgpool-II/pgpool.conf > pgpool.log 2>&1 &

Could you try that?

Issue History

Date Modified Username Field Change
2016-10-30 07:54 tomka New Issue
2016-10-30 07:58 tomka Note Added: 0001142
2016-12-20 09:24 t-ishii Assigned To => pengbo
2016-12-20 09:24 t-ishii Status new => assigned
2017-03-12 23:50 pengbo Note Added: 0001375
2017-04-07 15:42 pengbo Status assigned => closed