Unable to delete compute context in Viya 3.5

AllanBowe — Fri, 25 Jun 2021 21:13:58 GMT

We are seeing the following message when trying to delete a custom context using SAS Environment Manager in Viya 3.5:

A data error occurred that prevented the successful completion of the operation.

Opening up the console, the following request is submitted:

With the following response:

{ "errorCode":1008, "message":"A data error occurred that prevented the successful completion of the operation.", "details":["traceId: 1e951e833e7ebb4b","path: /compute/contexts/7e258745-c716-42fd-b8ac-375f2f2b7065"], "links":[],"version":2,"httpStatusCode":500 }

Looking in the compute logs (/var/log/sas/viya/compute/default) for this event, the following is revealed:

2021-06-25 10:08:39.047 WARN 10609 --- [-auto-1-exec-49] o.h.engine.jdbc.spi.SqlExceptionHelper : allbow(7e30b736) [e40f73af84b0c415] SQL Error: 0, SQLState: 23503 2021-06-25 10:08:39.048 ERROR 10609 --- [-auto-1-exec-49] o.h.engine.jdbc.spi.SqlExceptionHelper : allbow(7e30b736) [e40f73af84b0c415] ERROR: update or delete on table "compute_server_context" violates foreign key constraint "compute_server_fk01" on table "compute_server" Detail: Key (compute_server_context_id)=(7e258745-c716-42fd-b8ac-375f2f2b7065) is still referenced from table "compute_server". 2021-06-25 10:08:39.053 INFO 10609 --- [-auto-1-exec-49] o.h.e.j.b.internal.AbstractBatchImpl : allbow(7e30b736) [e40f73af84b0c415] HHH000010: On release of batch it still contained JDBC statements 2021-06-25 10:08:39.053 ERROR 10609 --- [-auto-1-exec-49] o.h.i.ExceptionMapperStandardImpl : allbow(7e30b736) [e40f73af84b0c415] HHH000346: Error during managed flush [org.hibernate.exception.ConstraintViolationException: could not execute statement] 2021-06-25 10:08:39.061 ERROR 10609 --- [-auto-1-exec-49] com.sas.commons.rest.ExceptionLog : allbow(7e30b736) [e40f73af84b0c415] org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [compute_server_fk01]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement 2021-06-25 10:08:39.061 ERROR 10609 --- [-auto-1-exec-49] com.sas.commons.rest.ExceptionLog : allbow(7e30b736) [e40f73af84b0c415] caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement 2021-06-25 10:08:39.061 ERROR 10609 --- [-auto-1-exec-49] com.sas.commons.rest.ExceptionLog : allbow(7e30b736) [e40f73af84b0c415] caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "compute_server_context" violates foreign key constraint "compute_server_fk01" on table "compute_server" Detail: Key (compute_server_context_id)=(7e258745-c716-42fd-b8ac-375f2f2b7065) is still referenced from table "compute_server".

I am able to modify all attributes for this context EXCEPT the name (I can't rename or delete it).

This issue also appears to be severely affecting ALL other compute contexts by making them run very slowly, or not at all (due to timeouts), but ONLY when `reuseServerProcesses` is true. If reuseServerProcesses is false or not set, the jobs run fine (albeit under end user credentials).

How to rectify, or further troubleshoot?

Re: Unable to delete compute context in Viya 3.5

jcFranklin — Mon, 28 Jun 2021 14:44:28 GMT

The error you are getting is coming from the postgres database.

Have you tried deleting the compute context using EV yet?

https://go.documentation.sas.com/doc/en/calcdc/3.5/calcontexts/n03002viyaprgmsrvs00000admin.htm

Re: Unable to delete compute context in Viya 3.5

AllanBowe — Mon, 28 Jun 2021 20:36:18 GMT

Hi @jcFranklin - yes indeed, there appears to be a constraint issue in Postgres. The screenshots above are taken from SAS Environment Manager in Viya 3.5.

Are there any alternative mechanisms for removing compute contexts?

topic Re: Unable to delete compute context in Viya 3.5 in Administration and Deployment

Unable to delete compute context in Viya 3.5

Re: Unable to delete compute context in Viya 3.5

Re: Unable to delete compute context in Viya 3.5