Обсуждение: AWS Database Migration Errors Post migration
Hi Team,
We are seeing this error after the migration from EC2 plain instance into RDS based Postgresql.
Version: 9.5
Error/Exception:
Occuring Frequently.
2018-02-05T20:12:19 [TARGET_LOAD ]E: Command failed to load data with exit error code 1, Command output: psql: /usr/lib64/libcom_err.so.2: no version information available (required by /rdsdbbin/attunity-2.4.0.R2/lib/libgssapi_krb5.so.2), psql: /usr/lib64/libcom_err.so.2: no version information available (required by /rdsdbbin/attunity-2.4.0.R2/lib/libkrb5.so.3), ERROR: date/time field value out of range: "0000-00-00 00:00:00.000000", CONTEXT: COPY ******, line 445050, column end_date: "0000-00-00 00:00:00.000000" [1020403] (csv_target.c:883)
Could you please comment on this?
Thanks
Bala
Hi, On 28/03/18 01:23, bala jayaram wrote: > Hi Team, > > We are seeing this error after the migration from EC2 plain instance > into RDS based Postgresql. > > Version: 9.5 > Error/Exception: > Occuring Frequently. > > 2018-02-05T20:12:19 [TARGET_LOAD ]E: Command failed to load data with > exit error code 1, Command output: psql: /usr/lib64/libcom_err.so.2: > no version information available (required by > /rdsdbbin/attunity-2.4.0.R2/lib/libgssapi_krb5.so.2), psql: > /usr/lib64/libcom_err.so.2: no version information available (required > by /rdsdbbin/attunity-2.4.0.R2/lib/libkrb5.so.3), ERROR: date/time > field value out of range: "0000-00-00 00:00:00.000000", CONTEXT: COPY > ******, line 445050, column end_date: "0000-00-00 00:00:00.000000" > [1020403] (csv_target.c:883) > > Could you please comment on this? > > This is the problem: ERROR: date/time field value out of range: "0000-00-00 00:00:00.000000", that 'all zero' date is not a valid date as far as Postgres is concerned. I don't think the error is specific to RDS - no Postgres version will load such a value into any actual date type field. regards Mark