Fully managed cloud. 30-day FREE full featured trial. Start Now
cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with SYS.EXA_USER_COLUMNS

ronaldvr
SQL-Fighter
  • Suddenly every query on SYS.EXA_USER_COLUMNS gives reconnections and SQL Error [40005]: Successfully reconnected after internal server error, transaction was rolled back. (SessionID: XXXX)

EDIT The log shows the following:

2021-12-08 12:57:53.758101Warningexa_db1Controller(0.1): Process exited: SqlProcess 301.3 exited after signal 6.
2021-12-08 12:57:50.596224Warningexa_db1Controller(0.0): Process exited: SqlProcess 300.3 exited after signal 6.
2021-12-08 12:57:47.270797Warningexa_db1Controller(0.5): Process exited: SqlProcess 299.3 exited after signal 6.
2021-12-08 12:57:44.453900Warningexa_db1Controller(0.2): Process exited: SqlProcess 506.3 exited after signal 6.

 

Jira ticket is here: https://www.exasol.com/support/browse/EXA-37980

2 REPLIES 2

exa-Chris
Exasol Alumni

Hi Ronald, let me escalate that internally. Have you already sent that in as a ticket? Rgds Christian

ronaldvr
SQL-Fighter

Not yet made a ticket, but have the same issues with all _COLUMNS views, and not when using a WHERE clause. Thus a query as

SELECT * FROM SYS.EXA_ALL_COLUMNS
WHERE COLUMN_SCHEMA LIKE 'X'

Will run.