citusdata / citusdata/pg_shard

Worker commands omit target relation's schema

Open
#15 0 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
C
Stars
1.1k
Forks
62
PR merge metrics
No merged PRs in 30d

Description

_From @samay-sharma on November 21, 2014 15:23_

Steps to reproduce:

``` sql
# On master and worker nodes:
CREATE SCHEMA test_schema;
# CREATE SCHEMA

# On master node:
CREATE TABLE test_schema.customer_reviews
(
customer_id INTEGER,
review_date DATE,
review_rating INTEGER,
review_votes INTEGER,
review_helpful_votes INTEGER,
product_id CHAR(10),
product_title TEXT,
product_sales_rank BIGINT,
product_group TEXT,
product_category TEXT,
product_subcategory TEXT,
similar_product_ids CHAR(10)[]
);
# CREATE TABLE

SELECT master_create_distributed_table('test_schema.customer_reviews', 'customer_id');
# master_create_distributed_table
# ---------------------------------
#
# (1 row)

INSERT INTO test_schema.customer_reviews (customer_id, review_rating) VALUES (4687, 5);
# WARNING: Bad result from ip-10-181-241-37.ec2.internal:5432
# DETAIL: Remote message: relation "customer_reviews_86" does not exist
# WARNING: Bad result from ip-10-102-169-241.ec2.internal:5432
# DETAIL: Remote message: relation "customer_reviews_86" does not exist
# ERROR: could not modify any active placements
```

Worker node log:

``` sql
# LOG: statement: INSERT INTO customer_reviews_86 (customer_id, review_rating) VALUES (4687, 5)
# ERROR: relation "customer_reviews_86" does not exist at character 13
# STATEMENT: INSERT INTO customer_reviews_86 (customer_id, review_rating) VALUES (4687, 5)
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.