Syncing currency to PG fails
# contributing-to-airbyte
m
Syncing currency to PG fails
u
Copy code
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} - INFO METRIC: {"type": "counter", "metric": "record_count", "value": 0, "tags": {"count_type": "batch_rows_persisted", "path": ["exchange_rate"], "database": "db", "schema": ""}}
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} - INFO METRIC: {"type": "timer", "metric": "job_duration", "value": 0.011671066284179688, "tags": {"job_type": "batch", "path": ["exchange_rate"], "database": "db", "schema": "", "status": "failed"}}
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} - ERROR Exception writing records
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} - Traceback (most recent call last):
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} -   File "/singer/env/lib/python3.7/site-packages/target_postgres/postgres.py", line 300, in write_batch
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} -     {'version': target_table_version})
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} -   File "/singer/env/lib/python3.7/site-packages/target_postgres/sql_base.py", line 824, in write_batch_helper
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} -     metadata)
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} -   File "/singer/env/lib/python3.7/site-packages/target_postgres/sql_base.py", line 400, in upsert_table_helper
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} -     self.add_table(connection, table_path, table_name, _metadata)
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} -   File "/singer/env/lib/python3.7/site-packages/target_postgres/postgres.py", line 421, in add_table
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} -     cur.execute(sql.SQL('{} ();').format(create_table_sql))
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} -   File "/singer/env/lib/python3.7/site-packages/target_postgres/postgres.py", line 65, in execute
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} -     return super(_MillisLoggingCursor, self).execute(query, vars)
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} -   File "/singer/env/lib/python3.7/site-packages/psycopg2/extras.py", line 461, in execute
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} -     return super(LoggingCursor, self).execute(query, vars)
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} - psycopg2.errors.SyntaxError: zero-length delimited identifier at or near """"
airbyte-scheduler | 2020-09-23 01:03:39 ERROR i.a.c.i.LineGobbler(voidCall):60 - {} - LINE 1: CREATE TABLE ""."exchange_rate" ();
u
It looks like this is because we don't have defaults working?
u
it's using a "" postgres schema?
u
ok
u
this happened in demos too