2023-07-06T01:51:44.449646Z [info ] 2023-07-06 01:51:44,449 | INFO | target-postgres | Initializing 'target-postgres' target sink... cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.450132Z [info ] 2023-07-06 01:51:44,449 | INFO | target-postgres | Initializing target sink for stream 'public-ChainEntityCollectionStage'... cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.650891Z [info ] 2023-07-06 01:51:44,650 | ERROR | target-postgres | Exception is being thrown for stream_name: public-ChainEntityCollectionStage cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.651361Z [info ] Traceback (most recent call last): cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.651700Z [info ] File "/home/ubuntu/meltano-test/.meltano/loaders/target-postgres/venv/bin/target-postgres", line 8, in cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.652090Z [info ] sys.exit(TargetPostgres.cli()) cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.652391Z [info ] File "/home/ubuntu/meltano-test/.meltano/loaders/target-postgres/venv/lib/python3.10/site-packages/click/core.py", line 1130, in __call__ cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.652693Z [info ] return self.main(*args, **kwargs) cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.652961Z [info ] File "/home/ubuntu/meltano-test/.meltano/loaders/target-postgres/venv/lib/python3.10/site-packages/click/core.py", line 1055, in main cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.653229Z [info ] rv = self.invoke(ctx) cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.653527Z [info ] File "/home/ubuntu/meltano-test/.meltano/loaders/target-postgres/venv/lib/python3.10/site-packages/click/core.py", line 1404, in invoke cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.653803Z [info ] return ctx.invoke(self.callback, **ctx.params) cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.654075Z [info ] File "/home/ubuntu/meltano-test/.meltano/loaders/target-postgres/venv/lib/python3.10/site-packages/click/core.py", line 760, in invoke cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.654343Z [info ] return __callback(*args, **kwargs) cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.654616Z [info ] File "/home/ubuntu/meltano-test/.meltano/loaders/target-postgres/venv/lib/python3.10/site-packages/singer_sdk/target_base.py", line 572, in cli cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.654891Z [info ] target.listen(file_input) cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.655168Z [info ] File "/home/ubuntu/meltano-test/.meltano/loaders/target-postgres/venv/lib/python3.10/site-packages/singer_sdk/io_base.py", line 34, in listen cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.655464Z [info ] self._process_lines(file_input) cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.655742Z [info ] File "/home/ubuntu/meltano-test/.meltano/loaders/target-postgres/venv/lib/python3.10/site-packages/singer_sdk/target_base.py", line 272, in _process_lines cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.656032Z [info ] counter = super()._process_lines(file_input) cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.656273Z [info ] File "/home/ubuntu/meltano-test/.meltano/loaders/target-postgres/venv/lib/python3.10/site-packages/singer_sdk/io_base.py", line 81, in _process_lines cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.656558Z [info ] self._process_record_message(line_dict) cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.656814Z [info ] File "/home/ubuntu/meltano-test/.meltano/loaders/target-postgres/venv/lib/python3.10/site-packages/target_postgres/target.py", line 283, in _process_record_message cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.657183Z [info ] raise e cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.657460Z [info ] File "/home/ubuntu/meltano-test/.meltano/loaders/target-postgres/venv/lib/python3.10/site-packages/target_postgres/target.py", line 278, in _process_record_message cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.657724Z [info ] super()._process_record_message(message_dict) cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.657985Z [info ] File "/home/ubuntu/meltano-test/.meltano/loaders/target-postgres/venv/lib/python3.10/site-packages/singer_sdk/target_base.py", line 315, in _process_record_message cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.658267Z [info ] sink._validate_and_parse(transformed_record) cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.658529Z [info ] File "/home/ubuntu/meltano-test/.meltano/loaders/target-postgres/venv/lib/python3.10/site-packages/singer_sdk/sinks/core.py", line 302, in _validate_and_parse cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.658790Z [info ] self._validator.validate(record) cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.659047Z [info ] File "/home/ubuntu/meltano-test/.meltano/loaders/target-postgres/venv/lib/python3.10/site-packages/jsonschema/validators.py", line 314, in validate cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.659301Z [info ] raise error cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.659565Z [info ] jsonschema.exceptions.ValidationError: 0.0 is not of type 'string' cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.659824Z [info ] cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.660151Z [info ] Failed validating 'type' in schema['properties']['price']: cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.660421Z [info ] {'type': ['string']} cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.660674Z [info ] cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.660928Z [info ] On instance['price']: cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:44.661182Z [info ] 0.0 cmd_type=elb consumer=True name=target-postgres producer=False stdio=stderr string_id=target-postgres 2023-07-06T01:51:45.346971Z [error ]