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

[exa-John]

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