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

Contributor

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

1 REPLY 1

Contributor

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