View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000497 | Pgpool-II | General | public | 2019-04-15 13:35 | 2019-08-15 16:40 |
| Reporter | van | Assigned To | t-ishii | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 3.7.2 | ||||
| Summary | 0000497: FATAL: failed to read kind from backend | ||||
| Description | Hi , this is same as BugId :0000271 We are using pgpool v3.7.2 version. pgpool: mpsroot mpsdb ec2-54-82-43-225.compute-1.amazonaws.com(44721) idle[28747]: [115-1] 2019-01-30 18:34:52: pid 28747: LOG: DB node id: 1 backend pid: 18291 statement: Parse: SELECT id, memory_total, page_size, memory_free, memory_usage, disk_total_capacity, disk_total, disk_free, disk_used, disk_usage, cpu_usage, node_id FROM "mps_health" ORDER BY id ASC LIMIT 1000000 OFFSET 0 Jan 30 18:34:52 ip-10-20-5-46 pgpool: mpsroot mpsdb ec2-54-82-43-225.compute-1.amazonaws.com(44721) idle[28747]: [116-1] 2019-01-30 18:34:52: pid 28747: LOG: DB node id: 0 backend pid: 13607 statement: D message Jan 30 18:34:52 ip-10-20-5-46 pgpool: mpsroot mpsdb ec2-54-82-43-225.compute-1.amazonaws.com(44721) idle[28747]: [117-1] 2019-01-30 18:34:52: pid 28747: LOG: DB node id: 1 backend pid: 18291 statement: D message Jan 30 18:34:52 ip-10-20-5-46 pgpool: mpsroot mpsdb ec2-54-82-43-225.compute-1.amazonaws.com(44721) idle[28747]: [118-1] 2019-01-30 18:34:52: pid 28747: WARNING: packet kind of backend 1 ['t'] does not match with master/majority nodes packet kind ['E'] Jan 30 18:34:52 ip-10-20-5-46 pgpool: mpsroot mpsdb ec2-54-82-43-225.compute-1.amazonaws.com(44721) idle[28747]: [119-1] 2019-01-30 18:34:52: pid 28747: FATAL: failed to read kind from backend Jan 30 18:34:52 ip-10-20-5-46 pgpool: mpsroot mpsdb ec2-54-82-43-225.compute-1.amazonaws.com(44721) idle[28747]: [119-2] 2019-01-30 18:34:52: pid 28747: DETAIL: kind mismatch among backends. Possible last query was: "Parse: SELECT id, memory_total, page_size, memory_free, memory_usage, disk_total_capacity, disk_total, disk_free, disk_used, disk_usage, cpu_usage, node_id FROM "mps_health" ORDER BY id ASC LIMIT 1000000 OFFSET 0" kind details are: 0[E: prepared statement "_PLAN0x80fb40000" does not exist] 1[t] Jan 30 18:34:52 ip-10-20-5-46 pgpool: mpsroot mpsdb ec2-54-82-43-225.compute-1.amazonaws.com(44721) idle[28747]: [119-3] 2019-01-30 18:34:52: pid 28747: HINT: check data consistency among db nodes | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
Pgpool-II 3.7.2 is pretty old. Please upgrade to 3.7.9. And if you still errors please report back to us. |
|
|
Hi t-ishii, Thanks for quick reply , i will test with 3.7.9 version and get back to you . |
|
|
Hi , I am using 4.0.2 version and getting below error 2019-04-17 15:38:00: pid 85: LOG: DB node id: 1 backend pid: 4721 statement: C message 2019-04-17 15:38:00: pid 85: LOG: DB node id: 0 backend pid: 10222 statement: C message 2019-04-17 15:38:00: pid 85: LOG: statement: DEALLOCATE "_PLAN0x7f421019cf40" 2019-04-17 15:38:00: pid 85: LOG: DB node id: 1 backend pid: 4721 statement: DEALLOCATE "_PLAN0x7f421019cf40" 2019-04-17 15:38:00: pid 85: LOG: DB node id: 0 backend pid: 10222 statement: Parse: set schema 'Owner' 2019-04-17 15:38:00: pid 85: LOG: DB node id: 1 backend pid: 4721 statement: Parse: set schema 'Owner' 2019-04-17 15:38:00: pid 85: LOG: DB node id: 0 backend pid: 10222 statement: D message 2019-04-17 15:38:00: pid 85: LOG: DB node id: 1 backend pid: 4721 statement: D message 2019-04-17 15:38:00: pid 85: LOG: DB node id: 0 backend pid: 10222 statement: B message 2019-04-17 15:38:00: pid 85: LOG: DB node id: 1 backend pid: 4721 statement: B message 2019-04-17 15:38:00: pid 85: LOG: DB node id: 0 backend pid: 10222 statement: Execute: set schema 'Owner' 2019-04-17 15:38:00: pid 85: LOG: DB node id: 1 backend pid: 4721 statement: Execute: set schema 'Owner' 2019-04-17 15:38:00: pid 85: LOG: DB node id: 0 backend pid: 10222 statement: C message 2019-04-17 15:38:00: pid 85: LOG: DB node id: 1 backend pid: 4721 statement: C message 2019-04-17 15:38:00: pid 85: WARNING: packet kind of backend 1 ['1'] does not match with master/majority nodes packet kind ['E'] 2019-04-17 15:38:00: pid 85: FATAL: failed to read kind from backend 2019-04-17 15:38:00: pid 85: DETAIL: kind mismatch among backends. Possible last query was: "set schema 'Owner'" kind details are: 0[E: prepared statement "_PLAN0x7f421019cf40" already exists] 1[1] 2019-04-17 15:38:00: pid 85: HINT: check data consistency among db nodes 2019-04-17 15:38:00: pid 70: LOG: new connection received Please can you take a look. |
|
|
Can you share Pgpool-II with log_client_messages = on? |
|
|
No response from the reporter over 1 month. I am going to close this issue soon. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-04-15 13:35 | van | New Issue | |
| 2019-04-15 13:35 | van | File Added: pgpool.conf | |
| 2019-04-15 13:46 | t-ishii | Note Added: 0002551 | |
| 2019-04-15 13:46 | t-ishii | Status | new => feedback |
| 2019-04-15 13:46 | t-ishii | Description Updated | |
| 2019-04-15 14:03 | van | Note Added: 0002552 | |
| 2019-04-15 14:03 | van | Status | feedback => new |
| 2019-04-18 03:41 | van | Note Added: 0002567 | |
| 2019-04-18 11:40 | t-ishii | Assigned To | => t-ishii |
| 2019-04-18 11:40 | t-ishii | Status | new => assigned |
| 2019-04-18 11:42 | t-ishii | Note Added: 0002568 | |
| 2019-04-18 11:42 | t-ishii | Status | assigned => feedback |
| 2019-05-21 10:11 | t-ishii | Note Added: 0002607 | |
| 2019-05-21 10:11 | t-ishii | Note Edited: 0002607 | |
| 2019-08-15 16:40 | t-ishii | Status | feedback => closed |
