View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000678 | Pgpool-II | Bug | public | 2020-12-25 15:49 | 2021-03-30 16:09 |
| Reporter | chenjiaoqian | Assigned To | pengbo | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | assigned | Resolution | open | ||
| Product Version | 4.1.3 | ||||
| Summary | 0000678: In replication mode, after inserting data into the foreign table, delete or update will cause the operation to wait. | ||||
| Description | I use "pgpool_setup" command to create an environment with two nodes in replication mode under the same host. Then connect to the pgpool server and create a foreign table. After inserting data into the foreign table, I delete foreign table, which causes the operation to wait and the table fails to be deleted. Execute log: postgres=# create table test(id int,create_time timestamp default '2020-01-01'); CREATE TABLE postgres=# create server srv FOREIGN DATA WRAPPER postgres_fdw OPTIONS; CREATE SERVER postgres=# create USER MAPPING FOR pgpool2 SERVER srv OPTIONS; CREATE USER MAPPING postgres=# CREATE FOREIGN TABLE ft_test (id int,create_time timestamp default '2020-01-01') SERVER srv OPTIONS (table_name 'test'); CREATE FOREIGN TABLE postgres=# insert into ft_test select generate_series(1,10); INSERT 0 10 postgres=# delete from ft_test; | ||||
| Tags | No tags attached. | ||||
|
|
Sorry for late response. Have you resolved this issue? It may related to https://www.pgpool.net/mantisbt/view.php?id=677 |
|
|
Thank you for your reply. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-12-25 15:49 | chenjiaoqian | New Issue | |
| 2021-03-17 17:11 | pengbo | Note Added: 0003771 | |
| 2021-03-17 18:10 | pengbo | Assigned To | => pengbo |
| 2021-03-17 18:10 | pengbo | Status | new => assigned |
| 2021-03-30 16:09 | chenjiaoqian | Note Added: 0003789 |
