The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.

I am getting decompression OK, trailing garbage ignored Error

Dear Vertica,

I have some copy command which are failing with below error

$ more /var/opt/fast/tmp/fact_increment_staging.sh.20190418123527202651.FASTSF1868190412.4khkt.7175.log_vertica_SQL.sql.rejected
gzip: /var/opt/fast/extracts/STGNG_POSDS_FRCST_FCT_1868_20190412_20190412: decompression OK, trailing garbage ignored

Please suggest what can be reason?

Comments

  • Jim_KnicelyJim_Knicely Administrator

    I'm pretty sure that's a problem with your compressed files.

    Is this the file? "/var/opt/fast/extracts/STGNG_POSDS_FRCST_FCT_1868_20190412_20190412"

    Try unzipping it manually:

    gunzip /var/opt/fast/extracts/STGNG_POSDS_FRCST_FCT_1868_20190412_20190412
    

    Do you get that same warning?

  • Thanks Jim for response.

    I have tried above command and gets like below

    $ gunzip STGNG_POSDS_FRCST_FCT_1868_20190412_20190412
    gzip: STGNG_POSDS_FRCST_FCT_1868_20190412_20190412: unknown suffix -- ignored

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.