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

postgres_cdc: fails miserably when there are less columns in RW table than in PG source table #20346

Closed
pkit opened this issue Jan 30, 2025 · 0 comments · Fixed by #20348
Closed
Labels
type/bug Something isn't working
Milestone

Comments

@pkit
Copy link

pkit commented Jan 30, 2025

Describe the bug

See title
I really hope you don't panic when a new column is added upstream.

Error message/log

ERROR:  Panicked when handling the request: assertion `left == right` failed
  left: 1
 right: 2
This is a bug. We would appreciate a bug report at:
  https://github.com/risingwavelabs/risingwave/issues/new?labels=type%2Fbug&template=bug_report.yml
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
psql (16.6 (Ubuntu 16.6-0ubuntu0.24.04.1), server 13.14.0)

To Reproduce

Postgres

CREATE TABLE IF NOT EXISTS test_52 (
                                       user_id UUID PRIMARY KEY,
                                       ar_col2 point[] NOT NULL
);

RW

CREATE SOURCE IF NOT EXISTS af_pg_src WITH (
                    connector='postgres-cdc',                                                                                          
                    hostname='host.docker.internal',
                    port=15432,
                    username='master',
                    password='password',
                    database.name='main'
                );
CREATE TABLE IF NOT EXISTS af_pg_test_57 (
                    user_id VARCHAR PRIMARY KEY

                )
                FROM af_pg_src TABLE 'public.test_52';

Expected behavior

I expect the "unknown" columns to be ignored.
And I do not expect PANIC at all

How did you deploy RisingWave?

docker compose

The version of RisingWave

PostgreSQL 13.14.0-RisingWave-2.1.2 (13d9285)

Additional context

No response

@pkit pkit added the type/bug Something isn't working label Jan 30, 2025
@github-actions github-actions bot added this to the release-2.3 milestone Jan 30, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant