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)

Most upvoted comments

Hoping to close this for now. Re-open if you see thr need to