pgsync: list index out of range
PGSync version: 1.1.24 Postgres version: 9.6.18 Elasticsearch version:
Redis version:
Python version: 3.7.9 Problem Description: When pgsync first starts everything seems fine. I only have one table and a very simple schema which shows up in elastic search. The postgres target is on AWS RDS. It actually has many tables but I am only using one of them in my schema.json. After a few seconds I get a list index out of range followed by a number of
Exception (psycopg2.errors.UndefinedObject) replication slot "my_table" does not exist
Is the error related to the warnings that occur just before?
Error Message (if any):
pgsync_1 | /usr/local/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/base.py:3186: SAWarning: Did not recognize type 'citext' of column 'email'
pgsync_1 | "Did not recognize type '%s' of column '%s'" % (attype, name)
pgsync_1 | /usr/local/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/base.py:3186: SAWarning: Did not recognize type 'meta_tag' of column 'path'
pgsync_1 | "Did not recognize type '%s' of column '%s'" % (attype, name)
pgsync_1 | - my_table
pgsync_1 | Traceback (most recent call last):
pgsync_1 | File "/usr/local/bin/bootstrap", line 71, in <module>
pgsync_1 | main()
pgsync_1 | File "/usr/local/lib/python3.7/site-packages/click/core.py", line 829, in __call__
pgsync_1 | return self.main(*args, **kwargs)
pgsync_1 | File "/usr/local/lib/python3.7/site-packages/click/core.py", line 782, in main
pgsync_1 | rv = self.invoke(ctx)
pgsync_1 | File "/usr/local/lib/python3.7/site-packages/click/core.py", line 1066, in invoke
pgsync_1 | return ctx.invoke(self.callback, **ctx.params)
pgsync_1 | File "/usr/local/lib/python3.7/site-packages/click/core.py", line 610, in invoke
pgsync_1 | return callback(*args, **kwargs)
pgsync_1 | File "/usr/local/bin/bootstrap", line 66, in main
pgsync_1 | sync.setup()
pgsync_1 | File "/usr/local/lib/python3.7/site-packages/pgsync/sync.py", line 138, in setup
pgsync_1 | self.teardown()
pgsync_1 | File "/usr/local/lib/python3.7/site-packages/pgsync/sync.py", line 163, in teardown
pgsync_1 | self.drop_triggers(self.database, schema=schema, tables=tables)
pgsync_1 | File "/usr/local/lib/python3.7/site-packages/pgsync/base.py", line 376, in drop_triggers
pgsync_1 | schema, table = pairs[0], pairs[1]
pgsync_1 | IndexError: list index out of range
pgsync_1 | - my_table
About this issue
- Original URL
- State: closed
- Created 3 years ago
- Comments: 22 (10 by maintainers)
Hoping to close this for now. Re-open if you see thr need to