-
Notifications
You must be signed in to change notification settings - Fork 649
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
cannot complete operation on a table with identity column
error during create_distributed_table()
on 12.1
#7564
Comments
We have recreated one of the clusters with only one worker to test if the issue persists and we keep encountering it even in 1 coordinator + 1 worker setup. Using |
Could you share the definition of |
Unfortunately We have also encountered this same exact issue in similar table later on and looking at things in common:
|
Okay, so we can trigger on our clusters with just this:
|
@gokhangulbiz Could you have quick look at this to understand what is going on here? It seems related to the GENERATED AS IDENTITY work that you did. |
Hello, following code triggers an error
SQL Error [0A000]: ERROR: cannot complete operation on a table with identity column
:We are currently running into this issue on two clusters, both in configuration 1 coordinator + 2 workers (separate worker groups, no standbys).
Both are running Citus version 12.1 (verified that all nodes are reporting the same version), one is PG15, the other one is PG16.
Note that this SQL executes without any errors (and seems to achieve the desired state) when testing it locally on a cluster with 1 coordinator and 1 worker (tested both Citus 12.0 and 12.1).
Based on release notes I was under the assumption that this SQL is currently supported in 12.1. Is this correct? If so, let me know what other info could be useful for investigation.
The text was updated successfully, but these errors were encountered: