Hi experts,
We are getting the following error in one of our transformations that contains the line "ALTER TABLE <TABLE_NAME> DROP COLUMN <COLUMN_NAME>":
Execution error: ROLLBACK: Cannot drop a table column when a node is down
Does anyone knows what is the root cause of this problem and how to solve it?
Thank you
Hello Guilherme,
Could you confirm if your cloud service is located on eu-3.celonis.cloud? It has status "degraded" on status page: https://status.celonis.com/.
Unfortunately i think you cannot solve such problem, because is a infrastructural one.
When a node recovers, it needs to get its recovery data from relevant buddy and replicated projections (tables in Vertica, but store data in collection of columns) from the up nodes.
Only option is to raise a case with support and wait. Could you let me know if problem will solved? One of our clients also has some performance problems.
Hi Mateusz, thank you for your answer.
Our client is hosted at us-2.celonis.cloud. I have opened a support ticket last week, and didn't receive any official response up to this moment. However, I was making some execution tests this morning, and it seems that it is working fine again.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
