You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by newigniter <to...@gmail.com> on 2019/01/24 19:37:22 UTC
Cannot create table after I drop it
I have a 1 node cluster.
Ignite persistence turned on.
I create a bunch of tables with SQL.
At some point, I drop the table with SQL and try to create it again but it
says table already exists.
I try to execute Drop table once more, it says the table doesn't exist.
After I restart the cluster(I restart container, I deployed ignite via
docker) I am able to create table again.
Anyone experienced a similar problem and is able to help me?
Thank you.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Cannot create table after I drop it
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
There is this ticket https://issues.apache.org/jira/browse/IGNITE-10897
so it looks like a known issue.
As a work-around you could e.g. try to use different name for table in such
cases. And hope that the issue will be fixed in future releases.
Regards.
--
Ilya Kasnacheev
чт, 24 янв. 2019 г. в 22:37, newigniter <to...@gmail.com>:
> I have a 1 node cluster.
> Ignite persistence turned on.
> I create a bunch of tables with SQL.
> At some point, I drop the table with SQL and try to create it again but it
> says table already exists.
> I try to execute Drop table once more, it says the table doesn't exist.
> After I restart the cluster(I restart container, I deployed ignite via
> docker) I am able to create table again.
>
> Anyone experienced a similar problem and is able to help me?
>
> Thank you.
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
Re: Cannot create table after I drop it
Posted by yangjiajun <13...@qq.com>.
Hello.
I encountered such issue too.And from my experience and tests,you cluster
may have blocked drop operations that can cause such strange issues.You can
see more details in my previous post:
http://apache-ignite-users.70518.x6.nabble.com/Strange-issue-while-call-ddl-td25259.html#a26234
newigniter wrote
> I have a 1 node cluster.
> Ignite persistence turned on.
> I create a bunch of tables with SQL.
> At some point, I drop the table with SQL and try to create it again but it
> says table already exists.
> I try to execute Drop table once more, it says the table doesn't exist.
> After I restart the cluster(I restart container, I deployed ignite via
> docker) I am able to create table again.
>
> Anyone experienced a similar problem and is able to help me?
>
> Thank you.
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/