[jira] [Updated] (PHOENIX-3336) get the wrong results when using the local secondary index
[ https://issues.apache.org/jira/browse/PHOENIX-3336?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Houliang Qi updated PHOENIX-3336: - Description: When using phoenix local secondary index, two clients concurrent upsert data to the same row key, while the other client using the index column to retrieve data, it gets the wrong results. Just like the attachments, I create one table called orders_5, and create one local index on table orders_5, called clerk_5; then I use two clients to upsert data to the same row key of table orders_5, and you will see that, the local index clerk_5 have some stale record (maybe its OK for eventual consistency), however, when you use the previous value to retrieve the record, you can still get the result, even more serious, the result is wrong, namely it not the record which you have insert before, and also not the record in the primary table(in the case ,is the table orders_5) was: When using phoenix local secondary index, two clients concurrent upsert data to the same row key, while using the index column to retrieve data, it gets the wrong results. Just like the attachments, I create one table called orders_5, and create one local index on table orders_5, called clerk_5; then I use two clients to upsert data to the same row key of table orders_5, and you will see that, the local index clerk_5 have some stale record (maybe its OK for eventual consistency), however, when you use the previous value to retrieve the record, you can still get the result, even more serious, the result is wrong, namely it not the record which you have insert before, and also not the record in the primary table(in the case ,is the table orders_5) > get the wrong results when using the local secondary index > -- > > Key: PHOENIX-3336 > URL: https://issues.apache.org/jira/browse/PHOENIX-3336 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.8.0 > Environment: hbase-1.1.2 >Reporter: Houliang Qi > Labels: phoenix, secondaryIndex > Attachments: create_table_orders.sql, readme.txt, sample_1.csv, > sample_2.csv, wrong-index-2.png > > Original Estimate: 120h > Remaining Estimate: 120h > > When using phoenix local secondary index, two clients concurrent upsert data > to the same row key, while the other client using the index column to > retrieve data, it gets the wrong results. > Just like the attachments, I create one table called orders_5, and create one > local index on table orders_5, called clerk_5; then I use two clients to > upsert data to the same row key of table orders_5, and you will see that, > the local index clerk_5 have some stale record (maybe its OK for eventual > consistency), however, when you use the previous value to retrieve the > record, you can still get the result, even more serious, the result is wrong, > namely it not the record which you have insert before, and also not the > record in the primary table(in the case ,is the table orders_5) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (PHOENIX-3336) get the wrong results when using the local secondary index
[ https://issues.apache.org/jira/browse/PHOENIX-3336?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Houliang Qi updated PHOENIX-3336: - Attachment: (was: wrong-index.png) > get the wrong results when using the local secondary index > -- > > Key: PHOENIX-3336 > URL: https://issues.apache.org/jira/browse/PHOENIX-3336 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.8.0 > Environment: hbase-1.1.2 >Reporter: Houliang Qi > Labels: phoenix, secondaryIndex > Attachments: create_table_orders.sql, readme.txt, sample_1.csv, > sample_2.csv, wrong-index-2.png > > Original Estimate: 120h > Remaining Estimate: 120h > > When using phoenix local secondary index, two clients concurrent upsert data > to the same row key, while using the index column to retrieve data, it gets > the wrong results. > Just like the attachments, I create one table called orders_5, and create one > local index on table orders_5, called clerk_5; then I use two clients to > upsert data to the same row key of table orders_5, and you will see that, > the local index clerk_5 have some stale record (maybe its OK for eventual > consistency), however, when you use the previous value to retrieve the > record, you can still get the result, even more serious, the result is wrong, > namely it not the record which you have insert before, and also not the > record in the primary table(in the case ,is the table orders_5) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (PHOENIX-3336) get the wrong results when using the local secondary index
[ https://issues.apache.org/jira/browse/PHOENIX-3336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15531626#comment-15531626 ] Houliang Qi commented on PHOENIX-3336: -- I have added the ddl statements and the test case in the readme.txt, the attachment file illustrates the steps which I have taken,I hope this will be helpful to you. > get the wrong results when using the local secondary index > -- > > Key: PHOENIX-3336 > URL: https://issues.apache.org/jira/browse/PHOENIX-3336 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.8.0 > Environment: hbase-1.1.2 >Reporter: Houliang Qi > Labels: phoenix, secondaryIndex > Attachments: create_table_orders.sql, readme.txt, sample_1.csv, > sample_2.csv, wrong-index-2.png, wrong-index.png > > Original Estimate: 120h > Remaining Estimate: 120h > > When using phoenix local secondary index, two clients concurrent upsert data > to the same row key, while using the index column to retrieve data, it gets > the wrong results. > Just like the attachments, I create one table called orders_5, and create one > local index on table orders_5, called clerk_5; then I use two clients to > upsert data to the same row key of table orders_5, and you will see that, > the local index clerk_5 have some stale record (maybe its OK for eventual > consistency), however, when you use the previous value to retrieve the > record, you can still get the result, even more serious, the result is wrong, > namely it not the record which you have insert before, and also not the > record in the primary table(in the case ,is the table orders_5) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (PHOENIX-3336) get the wrong results when using the local secondary index
[ https://issues.apache.org/jira/browse/PHOENIX-3336?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Houliang Qi updated PHOENIX-3336: - Attachment: sample_2.csv sample_1.csv readme.txt create_table_orders.sql > get the wrong results when using the local secondary index > -- > > Key: PHOENIX-3336 > URL: https://issues.apache.org/jira/browse/PHOENIX-3336 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.8.0 > Environment: hbase-1.1.2 >Reporter: Houliang Qi > Labels: phoenix, secondaryIndex > Attachments: create_table_orders.sql, readme.txt, sample_1.csv, > sample_2.csv, wrong-index-2.png, wrong-index.png > > Original Estimate: 120h > Remaining Estimate: 120h > > When using phoenix local secondary index, two clients concurrent upsert data > to the same row key, while using the index column to retrieve data, it gets > the wrong results. > Just like the attachments, I create one table called orders_5, and create one > local index on table orders_5, called clerk_5; then I use two clients to > upsert data to the same row key of table orders_5, and you will see that, > the local index clerk_5 have some stale record (maybe its OK for eventual > consistency), however, when you use the previous value to retrieve the > record, you can still get the result, even more serious, the result is wrong, > namely it not the record which you have insert before, and also not the > record in the primary table(in the case ,is the table orders_5) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (PHOENIX-3336) get the wrong results when using the local secondary index
[ https://issues.apache.org/jira/browse/PHOENIX-3336?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Houliang Qi updated PHOENIX-3336: - Attachment: wrong-index-2.png > get the wrong results when using the local secondary index > -- > > Key: PHOENIX-3336 > URL: https://issues.apache.org/jira/browse/PHOENIX-3336 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.8.0 > Environment: hbase-1.1.2 >Reporter: Houliang Qi > Labels: phoenix, secondaryIndex > Attachments: wrong-index-2.png, wrong-index.png > > Original Estimate: 120h > Remaining Estimate: 120h > > When using phoenix local secondary index, two clients concurrent upsert data > to the same row key, while using the index column to retrieve data, it gets > the wrong results. > Just like the attachments, I create one table called orders_5, and create one > local index on table orders_5, called clerk_5; then I use two clients to > upsert data to the same row key of table orders_5, and you will see that, > the local index clerk_5 have some stale record (maybe its OK for eventual > consistency), however, when you use the previous value to retrieve the > record, you can still get the result, even more serious, the result is wrong, > namely it not the record which you have insert before, and also not the > record in the primary table(in the case ,is the table orders_5) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (PHOENIX-3336) get the wrong results when using the local secondary index
[ https://issues.apache.org/jira/browse/PHOENIX-3336?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Houliang Qi updated PHOENIX-3336: - Description: When using phoenix local secondary index, two clients concurrent upsert data to the same row key, while using the index column to retrieve data, it gets the wrong results. Just like the attachments, I create one table called orders_5, and create one local index on table orders_5, called clerk_5; then I use two clients to upsert data to the same row key of table orders_5, and you will see that, the local index clerk_5 have some stale record (maybe its OK for eventual consistency), however, when you use the previous value to retrieve the record, you can still get the result, even more serious, the result is wrong, namely it not the record which you have insert before, and also not the record in the primary table(in the case ,is the table orders_5) was:when using phoenix local secondary index, two clients concurrent upsert data to the same row key, while using the index column to retrieve data, it gets the wrong results. > get the wrong results when using the local secondary index > -- > > Key: PHOENIX-3336 > URL: https://issues.apache.org/jira/browse/PHOENIX-3336 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.8.0 > Environment: hbase-1.1.2 >Reporter: Houliang Qi > Labels: phoenix, secondaryIndex > Attachments: wrong-index.png > > Original Estimate: 120h > Remaining Estimate: 120h > > When using phoenix local secondary index, two clients concurrent upsert data > to the same row key, while using the index column to retrieve data, it gets > the wrong results. > Just like the attachments, I create one table called orders_5, and create one > local index on table orders_5, called clerk_5; then I use two clients to > upsert data to the same row key of table orders_5, and you will see that, > the local index clerk_5 have some stale record (maybe its OK for eventual > consistency), however, when you use the previous value to retrieve the > record, you can still get the result, even more serious, the result is wrong, > namely it not the record which you have insert before, and also not the > record in the primary table(in the case ,is the table orders_5) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (PHOENIX-3336) get the wrong results when using the local secondary index
[ https://issues.apache.org/jira/browse/PHOENIX-3336?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Houliang Qi updated PHOENIX-3336: - Attachment: wrong-index.png > get the wrong results when using the local secondary index > -- > > Key: PHOENIX-3336 > URL: https://issues.apache.org/jira/browse/PHOENIX-3336 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.8.0 > Environment: hbase-1.1.2 >Reporter: Houliang Qi > Labels: phoenix, secondaryIndex > Attachments: wrong-index.png > > Original Estimate: 120h > Remaining Estimate: 120h > > when using phoenix local secondary index, two clients concurrent upsert data > to the same row key, while using the index column to retrieve data, it gets > the wrong results. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (PHOENIX-3336) get the wrong results when using the local secondary index
Houliang Qi created PHOENIX-3336: Summary: get the wrong results when using the local secondary index Key: PHOENIX-3336 URL: https://issues.apache.org/jira/browse/PHOENIX-3336 Project: Phoenix Issue Type: Bug Affects Versions: 4.8.0 Environment: hbase-1.1.2 Reporter: Houliang Qi when using phoenix local secondary index, two clients concurrent upsert data to the same row key, while using the index column to retrieve data, it gets the wrong results. -- This message was sent by Atlassian JIRA (v6.3.4#6332)