WAIT FOR COMMIT on single SELECT

[stefan]

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?

[kristof · Accepted solution]

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