Strange issue while call ddl

classic Classic list List threaded Threaded
10 messages Options
yangjiajun yangjiajun
Reply | Threaded
Open this post in threaded view
|

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/
yangjiajun yangjiajun
Reply | Threaded
Open this post in threaded view
|

Re: Strange issue while call ddl

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/
yangjiajun yangjiajun
Reply | Threaded
Open this post in threaded view
|

Re: Strange issue while call ddl

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/
Maxim.Pudov Maxim.Pudov
Reply | Threaded
Open this post in threaded view
|

Re: Strange issue while call ddl

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/
yangjiajun yangjiajun
Reply | Threaded
Open this post in threaded view
|

Re: Strange issue while call ddl

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/
yangjiajun yangjiajun
Reply | Threaded
Open this post in threaded view
|

Re: Strange issue while call ddl

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/
Denis Magda-2 Denis Magda-2
Reply | Threaded
Open this post in threaded view
|

Re: Strange issue while call ddl

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 <[hidden email]> 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/
yangjiajun yangjiajun
Reply | Threaded
Open this post in threaded view
|

Re: Strange issue while call ddl

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/
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: Strange issue while call ddl

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 <[hidden email]>:
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/
yangjiajun yangjiajun
Reply | Threaded
Open this post in threaded view
|

Re: Strange issue while call ddl

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/