[ https://issues.apache.org/jira/browse/CASSANDRA-9116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14487543#comment-14487543 ]
Yuki Morishita commented on CASSANDRA-9116: ------------------------------------------- +1 for the patch. [~mildewey] Can you also test the patch with your upgrade test? > Indexes lost on upgrading to 2.1.4 > ---------------------------------- > > Key: CASSANDRA-9116 > URL: https://issues.apache.org/jira/browse/CASSANDRA-9116 > Project: Cassandra > Issue Type: Bug > Components: Core > Reporter: Mark Dewey > Assignee: Sam Tunnicliffe > Priority: Blocker > Fix For: 2.1.5 > > Attachments: 9116.txt > > > How to reproduce: > # Create a 2.0.12 cluster > # Create the following keyspace/table (or something similar, it's primarily > the indexes that matter to this case afaict) > {noformat} > CREATE KEYSPACE tshirts WITH replication = {'class': > 'NetworkTopologyStrategy', 'datacenter1': '1'} AND durable_writes = true; > CREATE TABLE tshirts.tshirtorders ( > store text, > order_time timestamp, > order_number uuid, > color text, > qty int, > size text, > PRIMARY KEY (store, order_time, order_number) > ) WITH CLUSTERING ORDER BY (order_time ASC, order_number ASC) > AND bloom_filter_fp_chance = 0.01 > AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}' > AND comment = '' > AND compaction = {'min_threshold': '4', 'class': > 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', > 'max_threshold': '32'} > AND compression = {'sstable_compression': > 'org.apache.cassandra.io.compress.LZ4Compressor'} > AND dclocal_read_repair_chance = 0.1 > AND default_time_to_live = 0 > AND gc_grace_seconds = 864000 > AND max_index_interval = 2048 > AND memtable_flush_period_in_ms = 0 > AND min_index_interval = 128 > AND read_repair_chance = 0.0 > AND speculative_retry = '99.0PERCENTILE'; > CREATE INDEX color ON tshirts.tshirtorders (color); > CREATE INDEX size ON tshirts.tshirtorders (size); > {noformat} > # Load it with data > # Stop the node (one node cluster is enough to replicate) > # Upgrade the node to 2.1.4 > # Start the node > # Optional: Run nodetool upgradesstables > # Run the following queries: > {noformat} > SELECT * FROM tshirts.tshirtorders WHERE store = 'store 65'; > SELECT store, color, qty, size FROM tshirts.tshirtorders WHERE store = 'store > 65' AND color = 'red'; > {noformat} > No rows containing will appear in the indexed table. > Sample output: > {noformat} > cqlsh> SELECT * FROM tshirts.tshirtorders WHERE store = 'store 65'; > store | order_time | order_number | > color | qty | size > ----------+--------------------------+--------------------------------------+--------+------+------ > store 65 | 2000-01-03 18:20:20+0000 | 457e60e6-da39-11e4-add3-42010af08298 | > red | 1295 | M > store 65 | 2000-01-04 01:29:21+0000 | 45947304-da39-11e4-add3-42010af08298 | > grey | 2805 | M > store 65 | 2000-01-04 19:55:51+0000 | 45d69220-da39-11e4-add3-42010af08298 | > brown | 3380 | XXXL > store 65 | 2000-01-04 22:45:07+0000 | 45e16894-da39-11e4-add3-42010af08298 | > yellow | 7000 | XXL > store 65 | 2000-01-05 17:09:56+0000 | 46083bd6-da39-11e4-add3-42010af08298 | > purple | 2440 | S > store 65 | 2000-01-05 19:16:48+0000 | 460cadd8-da39-11e4-add3-42010af08298 | > green | 5690 | L > store 65 | 2000-01-06 00:26:06+0000 | 461ccdbc-da39-11e4-add3-42010af08298 | > brown | 9890 | P > store 65 | 2000-01-06 11:35:11+0000 | 4633aa00-da39-11e4-add3-42010af08298 | > black | 9350 | P > store 65 | 2000-01-07 06:07:20+0000 | 4658e0ea-da39-11e4-add3-42010af08298 | > black | 1300 | S > store 65 | 2000-01-07 06:47:40+0000 | 465be93e-da39-11e4-add3-42010af08298 | > purple | 9630 | XL > store 65 | 2000-01-09 12:42:38+0000 | 46bafdd4-da39-11e4-add3-42010af08298 | > purple | 1470 | M > store 65 | 2000-01-09 19:07:35+0000 | 46c43e08-da39-11e4-add3-42010af08298 | > pink | 6005 | S > store 65 | 2000-01-10 04:47:56+0000 | 46d4b170-da39-11e4-add3-42010af08298 | > red | 345 | XL > store 65 | 2000-01-10 20:25:44+0000 | 46ef7d52-da39-11e4-add3-42010af08298 | > pink | 420 | XXL > store 65 | 2000-01-11 00:55:27+0000 | 46f7a84c-da39-11e4-add3-42010af08298 | > purple | 9045 | S > store 65 | 2000-01-11 17:54:25+0000 | 4724ea00-da39-11e4-add3-42010af08298 | > green | 5030 | XXL > store 65 | 2000-01-12 08:21:15+0000 | 473c0370-da39-11e4-add3-42010af08298 | > white | 2860 | XL > store 65 | 2000-01-12 17:09:19+0000 | 47497d2a-da39-11e4-add3-42010af08298 | > red | 6425 | L > store 65 | 2000-01-14 07:27:37+0000 | 478662a8-da39-11e4-add3-42010af08298 | > pink | 330 | XXXL > store 65 | 2000-01-14 11:31:38+0000 | 478b43cc-da39-11e4-add3-42010af08298 | > pink | 3335 | XXL > store 65 | 2000-01-14 18:55:59+0000 | 47955a24-da39-11e4-add3-42010af08298 | > yellow | 500 | P > store 65 | 2000-01-15 01:59:52+0000 | 479f0c5e-da39-11e4-add3-42010af08298 | > red | 8415 | XL > store 65 | 2000-01-15 02:26:13+0000 | 47a00c08-da39-11e4-add3-42010af08298 | > green | 2265 | P > store 65 | 2000-01-15 14:31:50+0000 | 47b28c34-da39-11e4-add3-42010af08298 | > green | 8165 | M > store 65 | 2000-01-16 20:39:31+0000 | 47de6908-da39-11e4-add3-42010af08298 | > purple | 1330 | XXL > store 65 | 2000-01-17 06:02:33+0000 | 47eb832c-da39-11e4-add3-42010af08298 | > black | 9495 | M > store 65 | 2000-01-17 12:32:09+0000 | 47f4ca18-da39-11e4-add3-42010af08298 | > grey | 4645 | L > store 65 | 2000-01-18 02:46:05+0000 | 48080c9a-da39-11e4-add3-42010af08298 | > pink | 5220 | L > store 65 | 2000-01-18 22:38:49+0000 | 48271c0c-da39-11e4-add3-42010af08298 | > red | 3515 | XL > store 65 | 2000-01-19 05:14:17+0000 | 48311860-da39-11e4-add3-42010af08298 | > black | 8970 | P > store 65 | 2000-01-19 09:15:57+0000 | 48368a8e-da39-11e4-add3-42010af08298 | > red | 6110 | P > store 65 | 2000-01-20 07:48:34+0000 | 485a21ec-da39-11e4-add3-42010af08298 | > green | 9455 | XXXL > store 65 | 2000-01-22 23:03:05+0000 | 48b94686-da39-11e4-add3-42010af08298 | > red | 5370 | P > store 65 | 2000-01-23 00:15:27+0000 | 48bb7a32-da39-11e4-add3-42010af08298 | > green | 2465 | S > store 65 | 2000-01-23 03:40:35+0000 | 48c10eb6-da39-11e4-add3-42010af08298 | > red | 795 | P > store 65 | 2000-01-23 20:52:24+0000 | 48db904c-da39-11e4-add3-42010af08298 | > brown | 9690 | XL > store 65 | 2000-01-23 23:52:08+0000 | 48df5f24-da39-11e4-add3-42010af08298 | > blue | 9330 | S > store 65 | 2000-01-25 06:10:55+0000 | 490ae194-da39-11e4-add3-42010af08298 | > pink | 2380 | M > store 65 | 2000-01-25 14:04:42+0000 | 4914777c-da39-11e4-add3-42010af08298 | > purple | 8425 | S > store 65 | 2000-01-25 20:31:39+0000 | 491da19e-da39-11e4-add3-42010af08298 | > brown | 70 | M > store 65 | 2000-01-26 09:33:27+0000 | 4932033c-da39-11e4-add3-42010af08298 | > green | 8150 | L > store 65 | 2000-01-28 10:18:38+0000 | 4976c38c-da39-11e4-add3-42010af08298 | > pink | 3175 | XXL > store 65 | 2000-01-31 00:22:38+0000 | 49d37fbe-da39-11e4-add3-42010af08298 | > black | 8310 | XL > store 65 | 2000-01-31 11:21:25+0000 | 49e2fcdc-da39-11e4-add3-42010af08298 | > white | 6240 | XXXL > store 65 | 2000-01-31 16:22:50+0000 | 49e9904c-da39-11e4-add3-42010af08298 | > green | 8310 | XXXL > store 65 | 2000-01-31 17:12:11+0000 | 49eac6ce-da39-11e4-add3-42010af08298 | > grey | 4315 | XL > store 65 | 2000-02-01 13:42:19+0000 | 4a086486-da39-11e4-add3-42010af08298 | > white | 6955 | XXXL > store 65 | 2000-02-03 09:21:18+0000 | 4a47abbe-da39-11e4-add3-42010af08298 | > white | 5360 | P > store 65 | 2000-02-03 21:09:39+0000 | 4a58acde-da39-11e4-add3-42010af08298 | > pink | 8665 | P > store 65 | 2000-02-04 17:57:51+0000 | 4a77aa76-da39-11e4-add3-42010af08298 | > brown | 8550 | L > store 65 | 2000-02-04 21:37:13+0000 | 4a7cdc26-da39-11e4-add3-42010af08298 | > black | 9195 | P > store 65 | 2000-02-05 20:35:33+0000 | 4a9fc81c-da39-11e4-add3-42010af08298 | > brown | 4460 | M > store 65 | 2000-02-06 03:28:23+0000 | 4aaa30ae-da39-11e4-add3-42010af08298 | > pink | 4175 | M > store 65 | 2000-02-06 07:45:29+0000 | 4ab0cd4c-da39-11e4-add3-42010af08298 | > yellow | 5270 | M > store 65 | 2000-02-06 07:47:06+0000 | 4ab100d2-da39-11e4-add3-42010af08298 | > grey | 165 | P > store 65 | 2000-02-06 20:21:10+0000 | 4ac434e0-da39-11e4-add3-42010af08298 | > black | 5480 | P > store 65 | 2000-02-07 01:49:04+0000 | 4acca18e-da39-11e4-add3-42010af08298 | > green | 7520 | L > store 65 | 2000-02-07 17:02:03+0000 | 4ae1a2fa-da39-11e4-add3-42010af08298 | > purple | 5630 | P > store 65 | 2000-02-09 09:46:37+0000 | 4b1bcc28-da39-11e4-add3-42010af08298 | > yellow | 6985 | S > store 65 | 2000-02-09 19:08:30+0000 | 4b2a10bc-da39-11e4-add3-42010af08298 | > blue | 7505 | M > store 65 | 2000-02-10 02:23:35+0000 | 4b35e428-da39-11e4-add3-42010af08298 | > blue | 730 | M > store 65 | 2000-02-10 16:12:10+0000 | 4b49dad2-da39-11e4-add3-42010af08298 | > brown | 9940 | XL > store 65 | 2000-02-12 05:10:22+0000 | 4b7c430a-da39-11e4-add3-42010af08298 | > yellow | 3890 | S > store 65 | 2000-02-14 20:16:52+0000 | 4bd9cb42-da39-11e4-add3-42010af08298 | > green | 5335 | XL > store 65 | 2000-02-14 22:40:38+0000 | 4bdcfb3c-da39-11e4-add3-42010af08298 | > green | 2370 | XXXL > store 65 | 2000-02-15 17:30:08+0000 | 4bf6c45e-da39-11e4-add3-42010af08298 | > red | 6875 | L > store 65 | 2000-02-16 15:19:40+0000 | 4c16783a-da39-11e4-add3-42010af08298 | > pink | 7880 | XL > store 65 | 2000-02-17 05:01:18+0000 | 4c2aab20-da39-11e4-add3-42010af08298 | > white | 160 | XL > store 65 | 2000-02-17 06:45:08+0000 | 4c2d66d0-da39-11e4-add3-42010af08298 | > brown | 6005 | XXXL > store 65 | 2000-02-17 08:43:02+0000 | 4c302f8c-da39-11e4-add3-42010af08298 | > purple | 4970 | L > store 65 | 2000-02-17 21:10:53+0000 | 4c44dea0-da39-11e4-add3-42010af08298 | > white | 9530 | M > store 65 | 2000-02-18 01:57:35+0000 | 4c4c55e0-da39-11e4-add3-42010af08298 | > blue | 5695 | M > store 65 | 2000-02-18 06:56:21+0000 | 4c53c50a-da39-11e4-add3-42010af08298 | > red | 9705 | S > store 65 | 2000-02-18 07:52:10+0000 | 4c555f78-da39-11e4-add3-42010af08298 | > black | 5205 | XXL > store 65 | 2000-02-20 07:01:49+0000 | 4ca0db9c-da39-11e4-add3-42010af08298 | > pink | 2645 | S > store 65 | 2000-02-20 07:48:56+0000 | 4ca244be-da39-11e4-add3-42010af08298 | > brown | 2465 | XXXL > store 65 | 2000-02-21 03:55:08+0000 | 4cc08474-da39-11e4-add3-42010af08298 | > red | 4095 | M > store 65 | 2000-02-21 07:25:29+0000 | 4cc5c736-da39-11e4-add3-42010af08298 | > pink | 7200 | XXXL > store 65 | 2000-02-21 23:08:29+0000 | 4cdba1b4-da39-11e4-add3-42010af08298 | > brown | 9190 | M > store 65 | 2000-02-21 23:08:56+0000 | 4cdbd832-da39-11e4-add3-42010af08298 | > green | 7895 | XXL > store 65 | 2000-02-23 00:17:30+0000 | 4d021ba0-da39-11e4-add3-42010af08298 | > pink | 3955 | XXXL > store 65 | 2000-02-23 04:40:20+0000 | 4d083b5c-da39-11e4-add3-42010af08298 | > blue | 6435 | XXL > store 65 | 2000-02-23 13:23:49+0000 | 4d1651c4-da39-11e4-add3-42010af08298 | > purple | 2595 | S > store 65 | 2000-02-24 14:51:42+0000 | 4d3b4e3e-da39-11e4-add3-42010af08298 | > purple | 5685 | M > store 65 | 2000-02-24 15:07:04+0000 | 4d3b805c-da39-11e4-add3-42010af08298 | > brown | 5045 | S > store 65 | 2000-02-24 22:04:02+0000 | 4d44af74-da39-11e4-add3-42010af08298 | > pink | 6780 | L > store 65 | 2000-02-25 00:53:13+0000 | 4d4910be-da39-11e4-add3-42010af08298 | > green | 1285 | XXL > store 65 | 2000-02-26 03:48:24+0000 | 4d729498-da39-11e4-add3-42010af08298 | > red | 1895 | XXL > store 65 | 2000-02-26 08:17:34+0000 | 4d7a717c-da39-11e4-add3-42010af08298 | > brown | 6400 | M > store 65 | 2000-02-26 17:41:23+0000 | 4d897d02-da39-11e4-add3-42010af08298 | > white | 5870 | S > store 65 | 2000-02-26 21:18:35+0000 | 4d8fbfbe-da39-11e4-add3-42010af08298 | > green | 265 | P > store 65 | 2000-02-26 23:51:47+0000 | 4d93bc40-da39-11e4-add3-42010af08298 | > grey | 3950 | XXXL > store 65 | 2000-02-27 09:34:06+0000 | 4da1b480-da39-11e4-add3-42010af08298 | > white | 1150 | XXL > store 65 | 2000-02-27 13:22:07+0000 | 4da87716-da39-11e4-add3-42010af08298 | > pink | 3395 | XXL > store 65 | 2000-02-27 16:49:46+0000 | 4dada0f6-da39-11e4-add3-42010af08298 | > blue | 1430 | XXL > (97 rows) > cqlsh> SELECT store, color, qty, size FROM tshirts.tshirtorders WHERE store = > 'store 65' AND color = 'red'; > store | order_time | order_number | color | qty | size > -------+------------+--------------+-------+-----+------ > (0 rows) > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)