View Issue Details

IDProjectCategoryView StatusLast Update
0000572Pgpool-IIBugpublic2021-03-26 20:10
Reporterzhuguangzhi9527 Assigned Tohoshiai  
PriorityhighSeveritymajorReproducibilityrandom
Status feedbackResolutionopen 
Product Version3.6.6 
Summary0000572: ERROR: unable to read message kind. DETAIL: kind does not match between
DescriptionI seems got the same bug of No.000231 in pgpool3.6.6 & postgres9.6.5,how can i get patches of No.000231 to fix the bug
there are the keys of the bug :
        ERROR: unable to read message kind
        DETAIL: kind does not match between master(45) slot[1] (52)
Steps To Reproducelike No.000231
Additional Informationlike No.000231
Tagspgpool

Activities

hoshiai

2020-01-08 11:38

developer   ~0003047

OK ,I can't think only the above information.

Please share your pgpool.log when this problem is happend and if possible, set log_min_messages parameter to 'debug5'.

hoshiai

2020-04-14 15:41

developer   ~0003322

It's been more than a month since I replay to you ... Is your problem solved?
If you don't have any problems, I would like to close this issue.

bennett

2021-03-26 20:10

reporter   ~0003785

--database info
postgres=> select * from pg_database;
  oid | datname | datdba | encoding | datcollate | datctype | datistemplate | datallowconn | datconnlimit | datlastsysoid | datfrozen
xid | datminmxid | dattablespace | datacl
-------+-----------+--------+----------+------------+----------+---------------+--------------+--------------+---------------+----------
----+------------+---------------+----------------------------------------------------------
 12967 | postgres | 10 | 0 | C | C | f | t | -1 | 12966 |
532 | 1 | 1663 |
 12966 | template0 | 10 | 0 | C | C | t | f | -1 | 12966 |
532 | 1 | 1663 | {=c/postgres,postgres=CTc/postgres}
     1 | template1 | 10 | 0 | C | C | t | t | -1 | 12966 |
532 | 1 | 1663 | {=c/postgres,postgres=CTc/postgres,pgpool=CTc/postgres}
 32778 | kkk | 10 | 0 | C | C | f | t | -1 | 12966 |
532 | 1 | 1663 | {=Tc/postgres,postgres=CTc/postgres,pgpool=CTc/postgres}
(4 rows)


--log
2021-03-26 19:06:57: pid 513: LOG: pool_read_kind: error message from 1 th backend:database "kkk" does not exist
2021-03-26 19:06:57: pid 513: ERROR: unable to read message kind
2021-03-26 19:06:57: pid 513: DETAIL: kind does not match between main(53) slot[1] (45)
2021-03-26 19:06:57: pid 528: DEBUG: authenticate kind = 5
2021-03-26 19:06:57: pid 528: DEBUG: authenticate backend: key data received
2021-03-26 19:06:57: pid 528: DEBUG: authenticate backend: transaction state: I
2021-03-26 19:06:57: pid 528: DEBUG: authenticate kind = 5
2021-03-26 19:06:57: pid 528: DEBUG: authenticate backend: key data received
2021-03-26 19:06:57: pid 528: DEBUG: authenticate backend: transaction state: I
2021-03-26 19:06:57: pid 528: DEBUG: authenticate kind = 5
2021-03-26 19:06:57: pid 528: DEBUG: authenticate backend: key data received
2021-03-26 19:06:57: pid 528: DEBUG: authenticate backend: transaction state: I

Issue History

Date Modified Username Field Change
2020-01-05 16:37 zhuguangzhi9527 New Issue
2020-01-05 16:37 zhuguangzhi9527 Tag Attached: pgpool
2020-01-08 10:52 hoshiai Assigned To => hoshiai
2020-01-08 10:52 hoshiai Status new => assigned
2020-01-08 11:38 hoshiai Status assigned => feedback
2020-01-08 11:38 hoshiai Note Added: 0003047
2020-04-14 15:41 hoshiai Note Added: 0003322
2021-03-26 20:10 bennett Note Added: 0003785