Internal server error when calling a SET EMIT UDF with huge datatypes in non-standard database
Details
| Detail name | Value |
|---|---|
| Changelog Number | 9003 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0, Exasol 6.1.0 |
| Fix Versions | Exasol 6.1.8, Exasol 6.0.18 |
| Resolution Date | 2019-11-06 |
Description
Precondition: In order for this problem to occur the database parameter vectorsize has to be increased above 2200 (default is 2048).
A SET EMIT UDF that is called with big arguments (e.g. big varchars) can lead to an internal server error. The probability of this happening increases with the size of groups created (less groups – larger data sets):
SELECT my_set_emits_udf(big_char, big_varchar, very_big_varchar) FROM t GROUP BY iproc(), floor(random()*4)
Workarounds
- If possible use smaller datatypes
- Reset the vectorsize to its default of 2048
- Update to Exasol 6.2.0 or later
