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

Drop statement leaves table in inconsistent state after rollback #216

Open
asdf-qwert opened this issue Sep 17, 2019 · 2 comments
Open

Drop statement leaves table in inconsistent state after rollback #216

asdf-qwert opened this issue Sep 17, 2019 · 2 comments

Comments

@asdf-qwert
Copy link

Hello, I have ran into issue with dropping cstore table and then rollbacking the transaction.
Rollback leaves the table in an inconsistent state as the table definition still exists (which is correct), but cstore data files are deleted and not rolled back with the rest of the transaction.
Steps to reproduce:

-- create empty cstore table
create foreign table cstore_drop_test()
    server cstore_server;

-- query without errors
select * from cstore_drop_test;

-- drop cstore table and then rollback
DO language plpgsql
$$
    DECLARE
    BEGIN
        drop foreign table cstore_drop_test;
        rollback;
    END
$$;

-- query fails on 'could not open file "xxx.footer" for reading'
select * from cstore_drop_test;
@mtuncer
Copy link
Member

mtuncer commented Sep 17, 2019

yes, unfortunately this is a known issue that won't be fixed. It involves a file operation that can not be rolled back.

@mtuncer
Copy link
Member

mtuncer commented Sep 17, 2019

We have added a different storage mechanism that is pending release under develop branch. This should solve the truncate issue you are having.

But it is not of release quality yet at this time

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

2 participants