old pgsync ValueError: too many values to unpack (expected 3)
Opened this issue · 1 comments
fairworlds commented
PGSync version:
2.3.1
Postgres version:
16.1.0
Elasticsearch/OpenSearch version:
7.2.0
Redis version:
7.2.4
Python version:
3.7
Problem Description:
This is exactly the version of Elastic that is needed, and naturally under Elastic pgsin - maybe because of the database version we can switch to 14?
Need help :)
Error Message (if any):
│ Traceback (most recent call last): │
│ File "/usr/local/bin/bootstrap", line 70, in <module> │
│ main() │
│ File "/usr/local/lib/python3.7/site-packages/click/core.py", line 1130, in __call__ │
│ return self.main(*args, **kwargs) │
│ File "/usr/local/lib/python3.7/site-packages/click/core.py", line 1055, in main │
│ rv = self.invoke(ctx) │
│ File "/usr/local/lib/python3.7/site-packages/click/core.py", line 1404, in invoke │
│ return ctx.invoke(self.callback, **ctx.params) │
│ File "/usr/local/lib/python3.7/site-packages/click/core.py", line 760, in invoke │
│ return __callback(*args, **kwargs) │
│ File "/usr/local/bin/bootstrap", line 65, in main │
│ sync.setup() │
│ File "/usr/local/lib/python3.7/site-packages/pgsync/sync.py", line 302, in setup │
│ self.create_view(schema, tables, user_defined_fkey_tables) │
│ File "/usr/local/lib/python3.7/site-packages/pgsync/base.py", line 484, in create_view │
│ self._materialized_views(schema), │
│ File "/usr/local/lib/python3.7/site-packages/pgsync/view.py", line 240, in create_view │
│ sa.text(f"{schema}.{MATERIALIZED_VIEW}") │
│ ValueError: too many values to unpack (expected 3)
toluaina commented
This was fixed in a later version. I would advice updgrading to the latest stable.