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

Add column to a table after start the process #1

Closed
linanh opened this issue Feb 29, 2020 · 4 comments
Closed

Add column to a table after start the process #1

linanh opened this issue Feb 29, 2020 · 4 comments
Assignees
Labels
bug Something isn't working

Comments

@linanh
Copy link

linanh commented Feb 29, 2020

Add column to a table after start the proccess, and then insert the table, the process will be terminated.
Error: signal 11
./OpenLogReplicator[0x41b5e1]
/lib64/libc.so.6(+0x363f0)[0x7f4f1ed0a3f0]
/lib64/libstdc++.so.6(_ZNSsC1ERKSs+0x1b)[0x7f4f1f678f7b]
./OpenLogReplicator[0x4093f0]
./OpenLogReplicator[0x43bf21]
./OpenLogReplicator[0x435a5c]
./OpenLogReplicator[0x43697a]
./OpenLogReplicator[0x427c0a]
./OpenLogReplicator[0x43984a]
/lib64/libpthread.so.0(+0x7ea5)[0x7f4f22a21ea5]
/lib64/libc.so.6(clone+0x6d)[0x7f4f1edd28cd]

@bersler bersler self-assigned this Feb 29, 2020
@bersler bersler added the bug Something isn't working label Feb 29, 2020
@bersler
Copy link
Owner

bersler commented Feb 29, 2020

Alter table is not supported. The program should not crash but just ignore DML commands which appear after the alter table command. This has been fixed with the latest commit.

@bersler bersler closed this as completed Feb 29, 2020
@bersler
Copy link
Owner

bersler commented Feb 29, 2020

Issue fixed

@linanh
Copy link
Author

linanh commented Mar 1, 2020

Using the latest code, can't capture the change of the alter table, even restart the program.
When capture the event "alter", and then refresh the table columns?

@bersler
Copy link
Owner

bersler commented Mar 1, 2020

Yes, because ALTER TABLE is not supported. What you can do is switch logfile and reset replication (for example, delete the checkpoint JSON file). OpenLogReplicator will resume replication with the new schema and starting from a fresh redo log file.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants