RisingWave Community - Why am I getting a Foreign Key Constraint Violated error when trying to alter a table in Kubernetes pod?

troubleshooting

Why am I getting a Foreign Key Constraint Violated error when trying to alter a table in Kubernetes pod?

I am trying to run Alter table employee add adress string; in a Kubernetes pod, but I am getting a Foreign Key Constraint Violated error. The table creation query and the error message are provided in the discussion thread. What could be causing this issue?

Ro

Robert Gargalac

Asked on Apr 10, 2024

The error Foreign Key Constraint Violated is likely due to a constraint violation when trying to alter the table employee by adding a new column address.
The issue is a known bug in version 1.8, and it has been fixed in version 1.8.1.
In the meantime, you can try using etcd as the backend, which is supported from version 1.0 and is more stable than the SQL backend.

Apr 11, 2024Edited by