snowplow-rdb-loader icon indicating copy to clipboard operation
snowplow-rdb-loader copied to clipboard

Published 20 hours ago • verified publisher icon snowplow

RDB Loader: remove VACUUM from transaction block

Open abrenaut opened this issue 7 years ago • 2 comments

When running emr-etl-runner with the -i vacuum option I get the following error

Data loading error [Amazon](500310) Invalid operation: VACUUM cannot run inside a transaction block;

Redshift Cluster v 1.0.2058 emr-etl-runner r102_afontova_gora

Is this option still supported ?

abrenaut avatar May 25 '18 19:05 abrenaut

Hi @abrenaut! This is indeed a bug, thanks for reporting. Scheduling.

chuwy avatar May 29 '18 08:05 chuwy

From what I see in code - this should not be the case, as we run VACUUM outside of a transaction. I'll try to reproduce this later, but pushing back right now.

chuwy avatar Apr 21 '19 20:04 chuwy