WAIT FOR COMMIT on single SELECT

Padawan

I somtimes face a WAIT FOR COMMIT when executing a single SELECT statement.

There are other actions on th queried table.
However, I expected that a single select (as first statement within the transaction) should never have to wait as EXAsol uses multiple copies and ther should always be one valid version to query.

What am I missing?

How can I avoid this?

1 ACCEPTED SOLUTION

SQL-Fighter

Hi stefan,

I think your symptons are quite well explained in this article: https://www.exasol.com/support/browse/SOL-214

Hope this helps,

Kristof

View solution in original post

2 REPLIES 2

Team Exasol
Team Exasol

The SOL-214 is obsolete. Here is the current documentation: 

https://community.exasol.com/t5/database-features/wait-for-commit-on-select-statement/ta-p/1717

SQL-Fighter

Hi stefan,

I think your symptons are quite well explained in this article: https://www.exasol.com/support/browse/SOL-214

Hope this helps,

Kristof

View solution in original post