Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

old pgsync ValueError: too many values to unpack (expected 3) #525

Open
fairworlds opened this issue Jan 19, 2024 · 0 comments
Open

old pgsync ValueError: too many values to unpack (expected 3) #525

fairworlds opened this issue Jan 19, 2024 · 0 comments

Comments

@fairworlds
Copy link

fairworlds commented Jan 19, 2024

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) 

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant