Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

My table contains 3299000 rows. My Mysql Cluster contains 2 storage nodes with NoOfReplicas=2. By default it contains 2 partitions and after that i added 3 partitions more one by one using command "alter table ap_perf_tbl10 add partition (partition p2);" . Now total partitions are 5. Now i tried to execute the following command "alter table ap_perf_tbl10 coalesce partition 1;" which gave me the following ERROR "ERROR 1025 (HY000): Error on rename of './spectramon/ap_perf_tbl10' to './spectramon/#sql2-3fd8-2' (errno: 140)" . Now i executed following command "show warnings;" which gave following output "+---------+------+---------------------------------------------------------------------------------------------+ | Level | Code | Message | +---------+------+---------------------------------------------------------------------------------------------+ | Warning | 1296 | Got error 790 'Invalid hashmap' from NDB | | Error | 1025 | Error on rename of './spectramon/ap_perf_tbl10' to './spectramon/#sql2-3fd8-2' (errno: 140) | +---------+------+---------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) "

Please can any tell me what have i done wrong and why am i not able to successfully perform coalesce partition . There was no problem in creation of the table. The table was successfully created without any warnings.

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.