phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From venk sham <shamv...@gmail.com>
Subject phoniex 4.6 to 4.8 upgrade SYSTEM.STATS issue
Date Tue, 31 Jan 2017 20:13:55 GMT
Hi,

   During the phoenix upgrade from 4.6 to 4.8 SYSTEM.STATS meta data is
getting deleted and recreated in SYSTEM.CATALOG, but SYSTEM.CATALOG actual
data is not getting cleared.

phioenix 4.6 SYSTEM.STATS has row key as physical_Table_name + column
family+ region name.

Since SYSTEM.STATS data is not deleted during the upgrade and not corrected
the data, once upgraded Parallel scans are not proper (as start key and
stop key are invalid) and returning multiple records.


Example:

in the below example

"startRow":
"CDS_TEST.MONITORED_QUEUE_MESSAGE_DETAILS,3,1463423431278.7efe47a97f737de2ed34690f453d06bf.",


CDS_TEST.MONITORED_QUEUE_MESSAGE_DETAILS  physical_name
region name  :  1463423431278.7efe47a97f737de2ed34690f453d06bf.




}, {
"loadColumnFamiliesOnDemand": null,
"filter": "default.MESSAGE_ID = 'c2f8d7fe-6e29-4f34-bc38-b61bce8424cc'",
"startRow":
"CDS_TEST.MONITORED_QUEUE_MESSAGE_DETAILS,3,1463423431278.7efe47a97f737de2ed34690f453d06bf.",
"stopRow":
"CDS_TEST.MONITORED_QUEUE_MESSAGE_DETAILS,4,1463423431278.0a1ac472674298a1c3cb03fb48458665.",
"batch": -1,
"cacheBlocks": true,
"totalColumns": 8,
"maxResultSize": -1,
"families": {
"default": ["CREATED_BY", "JMS_MESSAGE_ID", "MESSAGE_BYTES", "MESSAGE_ID"]
},
"caching": 2147483647,
"maxVersions": 1,
"timeRange": [0, 1485535243351]
}, {
"loadColumnFamiliesOnDemand": null,
"filter": "default.MESSAGE_ID = 'c2f8d7fe-6e29-4f34-bc38-b61bce8424cc'",
"startRow":
"CDS_TEST.MONITORED_QUEUE_MESSAGE_DETAILS,4,1463423431278.0a1ac472674298a1c3cb03fb48458665.",
"stopRow":
"CDS_TEST.MONITORED_QUEUE_MESSAGE_DETAILS,5,1463423431278.0f69b359c43fc1ce5f546ada80982ff7.",
"batch": -1,
"cacheBlocks": true,
"totalColumns": 8,
"maxResultSize": -1,
"families": {
"default": ["CREATED_BY", "JMS_MESSAGE_ID", "MESSAGE_BYTES", "MESSAGE_ID"]
},
"caching": 2147483647,
"maxVersions": 1,
"timeRange": [0, 1485535243351]
}, {
"loadColumnFamiliesOnDemand": null,
"filter": "default.MESSAGE_ID = 'c2f8d7fe-6e29-4f34-bc38-b61bce8424cc'",
"startRow":
"CDS_TEST.MONITORED_QUEUE_MESSAGE_DETAILS,5,1463423431278.0f69b359c43fc1ce5f546ada80982ff7.",
"stopRow":
"CDS_TEST.MONITORED_QUEUE_MESSAGE_DETAILS,6,1463423431278.761ad4a881f40fb34027b80008550821.",
"batch": -1,
"cacheBlocks": true,
"totalColumns": 8,
"maxResultSize": -1,
"families": {
"default": ["CREATED_BY", "JMS_MESSAGE_ID", "MESSAGE_BYTES", "MESSAGE_ID"]
},
"caching": 2147483647,
"maxVersions": 1,
"timeRange": [0, 1485535243351]
}, {



Thanks
Venkat

Mime
View raw message