You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by yangjiajun <13...@qq.com> on 2018/11/21 03:23:34 UTC
Strange issue while call ddl
I have a ignite cluster which is version 2.6 and has two nodes.I can't do any
ddl operations on it since today.The cluster responses " Table already
exists" when I call create table statement to create a new table but it
response "Table doesn't exist" when I call drop table statement.When I try
to drop a table which certain exists,the statement just blocks.
What's wrong with my cluster?
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Strange issue while call ddl
Posted by yangjiajun <13...@qq.com>.
Hello.
I have created it:
https://issues.apache.org/jira/browse/IGNITE-10897
ilya.kasnacheev wrote
> Hello!
>
> Turns out this issue isn't known yet. Can you file a ticket against Apache
> Ignite JIRA?
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> вс, 6 янв. 2019 г. в 10:39, yangjiajun <
> 1371549332@
>>:
>
>> Hello.
>>
>> I experiment on Ignite 2.7.The issue still appears.
>>
>>
>> Denis Magda-2 wrote
>> > Hello,
>> >
>> > Is the same issue reproduced on Ignite 2.7? There were a lot of
>> > optimizations and fixes pertaining DDL.
>> >
>> > --
>> > Denis
>> >
>> >
>> > On Sat, Jan 5, 2019 at 8:23 AM yangjiajun <
>>
>> > 1371549332@
>>
>> >> wrote:
>> >
>> >> Hello.Community.
>> >>
>> >> Any update about this issue?Do you consider it as an issue or not?
>> >>
>> >> I may consider this issue as a bug.Because blocked drop table
>> operations
>> >> can
>> >> cause many strange issues like this one.
>> >>
>> >> I notice that ignite 2.8 is implementing queries management feature.Is
>> >> that
>> >> true? Maybe this feature can help us to solve this issue manually.
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> --
>> >> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>> >>
>>
>>
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Strange issue while call ddl
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
Turns out this issue isn't known yet. Can you file a ticket against Apache
Ignite JIRA?
Regards,
--
Ilya Kasnacheev
вс, 6 янв. 2019 г. в 10:39, yangjiajun <13...@qq.com>:
> Hello.
>
> I experiment on Ignite 2.7.The issue still appears.
>
>
> Denis Magda-2 wrote
> > Hello,
> >
> > Is the same issue reproduced on Ignite 2.7? There were a lot of
> > optimizations and fixes pertaining DDL.
> >
> > --
> > Denis
> >
> >
> > On Sat, Jan 5, 2019 at 8:23 AM yangjiajun <
>
> > 1371549332@
>
> >> wrote:
> >
> >> Hello.Community.
> >>
> >> Any update about this issue?Do you consider it as an issue or not?
> >>
> >> I may consider this issue as a bug.Because blocked drop table operations
> >> can
> >> cause many strange issues like this one.
> >>
> >> I notice that ignite 2.8 is implementing queries management feature.Is
> >> that
> >> true? Maybe this feature can help us to solve this issue manually.
> >>
> >>
> >>
> >>
> >>
> >> --
> >> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
> >>
>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
Re: Strange issue while call ddl
Posted by yangjiajun <13...@qq.com>.
Hello.
I experiment on Ignite 2.7.The issue still appears.
Denis Magda-2 wrote
> Hello,
>
> Is the same issue reproduced on Ignite 2.7? There were a lot of
> optimizations and fixes pertaining DDL.
>
> --
> Denis
>
>
> On Sat, Jan 5, 2019 at 8:23 AM yangjiajun <
> 1371549332@
>> wrote:
>
>> Hello.Community.
>>
>> Any update about this issue?Do you consider it as an issue or not?
>>
>> I may consider this issue as a bug.Because blocked drop table operations
>> can
>> cause many strange issues like this one.
>>
>> I notice that ignite 2.8 is implementing queries management feature.Is
>> that
>> true? Maybe this feature can help us to solve this issue manually.
>>
>>
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Strange issue while call ddl
Posted by Denis Magda <dm...@apache.org>.
Hello,
Is the same issue reproduced on Ignite 2.7? There were a lot of
optimizations and fixes pertaining DDL.
--
Denis
On Sat, Jan 5, 2019 at 8:23 AM yangjiajun <13...@qq.com> wrote:
> Hello.Community.
>
> Any update about this issue?Do you consider it as an issue or not?
>
> I may consider this issue as a bug.Because blocked drop table operations
> can
> cause many strange issues like this one.
>
> I notice that ignite 2.8 is implementing queries management feature.Is that
> true? Maybe this feature can help us to solve this issue manually.
>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
Re: Strange issue while call ddl
Posted by yangjiajun <13...@qq.com>.
Hello.Community.
Any update about this issue?Do you consider it as an issue or not?
I may consider this issue as a bug.Because blocked drop table operations can
cause many strange issues like this one.
I notice that ignite 2.8 is implementing queries management feature.Is that
true? Maybe this feature can help us to solve this issue manually.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Strange issue while call ddl
Posted by yangjiajun <13...@qq.com>.
Hello.Sorry for so late to reply to you.
I think I reproduce this issue.Here are my reproduce steps:
1.start a version 2.6 node with persistence enabled.
2.create 2 tables with "template=replicated".
3.Insert data to 2 tables.
4.Open a connection to make a long time query targeting on first table.This
query should not end until we
finish our experiment.
5.Open another connection and try to drop first table.This drop operation
will be blocked by the long query.
6.Open another connection try to drop second table.This operation will also
be blocked.
7.Open another connection try to create second table.Then you can see "table
already exists" exception.
8.Open another connection try to drop second table again.Then you can see
"Table doesn't exist" exception.
I use dbeaver to do most above steps.
I suggested to make drop table operation be first priority in another
post:http://apache-ignite-users.70518.x6.nabble.com/Drop-table-operation-should-be-first-priority-td25546.html.
Maxim.Pudov wrote
> Looks like a bug to me. If you have a reproducer of this issue, please,
> share
> it.
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Strange issue while call ddl
Posted by "Maxim.Pudov" <pu...@gmail.com>.
Looks like a bug to me. If you have a reproducer of this issue, please, share
it.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Strange issue while call ddl
Posted by yangjiajun <13...@qq.com>.
The cluster recovered after I killed a node.
yangjiajun wrote
> We can not do update operations either.But select queries are ok.
>
>
> yangjiajun wrote
>> I have a ignite cluster which is version 2.6 and has two nodes.I can't do
>> any
>> ddl operations on it since today.The cluster responses " Table already
>> exists" when I call create table statement to create a new table but it
>> response "Table doesn't exist" when I call drop table statement.When I
>> try
>> to drop a table which certain exists,the statement just blocks.
>>
>> What's wrong with my cluster?
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Strange issue while call ddl
Posted by yangjiajun <13...@qq.com>.
We can not do update operations either.But select queries are ok.
yangjiajun wrote
> I have a ignite cluster which is version 2.6 and has two nodes.I can't do
> any
> ddl operations on it since today.The cluster responses " Table already
> exists" when I call create table statement to create a new table but it
> response "Table doesn't exist" when I call drop table statement.When I try
> to drop a table which certain exists,the statement just blocks.
>
> What's wrong with my cluster?
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/