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

Commit de44551 db migration error 31 -> 32 #514

Closed
coolsantino opened this issue Nov 26, 2024 · 0 comments · Fixed by #515
Closed

Commit de44551 db migration error 31 -> 32 #514

coolsantino opened this issue Nov 26, 2024 · 0 comments · Fixed by #515
Labels
bug Something isn't working

Comments

@coolsantino
Copy link

Current Behavior

db migration from 31 to 32

ALTER TABLE contracts_v2 ADD COLUMN proof_height INTEGER NOT NULL;
ALTER TABLE contracts_v2 ADD COLUMN expiration_height INTEGER NOT NULL;
ALTER TABLE contracts_v2 DROP COLUMN window_start;
ALTER TABLE contracts_v2 DROP COLUMN window_end;
DROP INDEX contracts_v2_window_start;
DROP INDEX contracts_v2_window_end;
DROP INDEX contracts_v2_confirmation_index_resolution_index_window_start;
DROP INDEX contracts_v2_confirmation_index_resolution_index_window_end;
DROP INDEX contracts_v2_confirmation_index_window_start;
CREATE INDEX contracts_v2_proof_height ON contracts_v2(proof_height);
CREATE INDEX contracts_v2_expiration_height ON contracts_v2(expiration_height);
CREATE INDEX contracts_v2_confirmation_index_resolution_index_proof_height ON contracts_v2(confirmation_index, resolution_index, proof_height);
CREATE INDEX contracts_v2_confirmation_index_resolution_index_expiration_height ON contracts_v2(confirmation_index, resolution_index, expiration_height);
CREATE INDEX contracts_v2_confirmation_index_proof_height ON contracts_v2(confirmation_index, proof_height);

Expected Behavior

indexes should be dropped before altering tables.

Steps to Reproduce

No response

Version

master

What operating system did the problem occur on (e.g. Ubuntu 22.04, macOS 12.0, Windows 11)?

Linux Docker

Anything else?

No response

@coolsantino coolsantino added the bug Something isn't working label Nov 26, 2024
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

Successfully merging a pull request may close this issue.

1 participant