Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[xCluster][DDL Replication] Create table with Partition throws OBJECT_NOT_FOUND #23897

Closed
1 task done
agsh-yb opened this issue Sep 12, 2024 · 0 comments
Closed
1 task done
Assignees
Labels
2024.2_blocker area/docdb YugabyteDB core features kind/bug This issue is a bug priority/high High Priority qa_automation Bugs identified via itest-system, LST, Stress automation or causing automation failures qa_itest-system Bugs identified in itest-system automation QA QA filed bugs

Comments

@agsh-yb
Copy link
Contributor

agsh-yb commented Sep 12, 2024

Jira Link: DB-12801

Description

After replication setup, if user tries to create table at source

Version

2.23.1.0-b160

Error:

db_ddl_non_col=# create table t1(id int, PRIMARY KEY (id))PARTITION BY RANGE (id);
ERROR:  Table with identifier 0000400000003000800000000000410b not found: OBJECT_NOT_FOUND

Steps to reproduce:

1. Setup DDL replication
2. At Source:
db_ddl_non_col=# create table t(id int);
CREATE TABLE
db_ddl_non_col=# create table t1(id int, PRIMARY KEY (id))PARTITION BY RANGE (id);
ERROR:  Table with identifier 0000400000003000800000000000410b not found: OBJECT_NOT_FOUND

db_ddl_non_col=# select * from yb_xcluster_ddl_replication.ddl_queue;
    start_time    | query_id  |                                                                               
        yb_data                                                                                       
------------------+-----------+-------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------
 1726074197549783 | 634315665 | {"user": "yugabyte", "query": "create table t(id int);", "schema": "public", "
version": 1, "command_tag": "CREATE TABLE", "new_rel_map": [{"rel_name": "t", "relfile_oid": 16640}]}
(1 row)

cc: @Arjun-yb

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

  • I confirm this issue does not contain any sensitive information.
@agsh-yb agsh-yb added area/docdb YugabyteDB core features status/awaiting-triage Issue awaiting triage labels Sep 12, 2024
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Sep 12, 2024
@agsh-yb agsh-yb added 2024.2_blocker QA QA filed bugs qa_automation Bugs identified via itest-system, LST, Stress automation or causing automation failures qa_itest-system Bugs identified in itest-system automation labels Sep 12, 2024
@github-project-automation github-project-automation bot moved this from To do to Done in xCluster DDL Replication Sep 16, 2024
jasonyb pushed a commit that referenced this issue Sep 17, 2024
Summary:
 f97d7d5 [#23770] [#23797] [#23837] YSQL: Fix most non-regress tests when run with Connection Manager
 ee2b108 [docs] reverted PR 23909 changes (#23941)
 bd80f4e [#23924] DocDB: Address recent flakiness of PgGetLockStatusTest.TestGetWaitStart
 Excluded: f0a5db7 [#20908] YSQL: Introduce interface to optimize index non-key column updates
 6556498 [#23897] xClusterDDLRepl: Support create table with partition by primary key
 e2b1d28 [#23363] Changing the default gflags of YSQL memory configuration.
 e717f43 [#23925] DocDB: Address recent regression of test PgWaitQueuesTest.MultiTabletFairness
 09b7702 [#23940] YSQL: Replace copyright string from YugaByteDB to YugabyteDB
 add83ef [#23947] Update callhome URL to use https
 69db717 Update faq page (#23704)
 Excluded: 063dbe5 [#23786] YSQL: yb_make_next_ddl_statement_nonincrementing
 Excluded: a913524 [#23859] YSQL: Remove redundant Bitmap Scan filters on partial indexes
 41f5afd [PLAT-15097]: Delete System platform DB table while disabling ysql
 d6bbf59 [#23890] docdb: Add filtering for bootstrap intent iterators based on min_replay_txn_start_ht
 0b37479 [#23770] YSQL: Stabalize TestPgExplainAnalyze#testExplainAnalyzeOptions the test with ysql connection manager

Test Plan: Jenkins: rebase: pg15-cherrypicks

Reviewers: jason, tfoucher

Subscribers: yql

Differential Revision: https://phorge.dev.yugabyte.com/D38123
@yugabyte-ci yugabyte-ci added priority/high High Priority and removed status/awaiting-triage Issue awaiting triage priority/medium Medium priority issue labels Sep 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
2024.2_blocker area/docdb YugabyteDB core features kind/bug This issue is a bug priority/high High Priority qa_automation Bugs identified via itest-system, LST, Stress automation or causing automation failures qa_itest-system Bugs identified in itest-system automation QA QA filed bugs
Projects
Development

No branches or pull requests

3 participants