Skip to main content

I am getting decompression OK, trailing garbage ignored Error

  • April 18, 2019
  • 2 replies
  • 2 views

rahul_vertica_infy

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?

2 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • April 18, 2019

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?


rahul_vertica_infy

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