Cassandra 3.6 Repair issue with Reaper
Hi All, we tried sequential repair on very small table having only 20 Rows using the reaper tool. But the repair got stuck while generating the snapshot. Same when we tried with Parallel repair then run was working fine in the begining for few segments but later it got stuck in the compaction and never got completed and one of the node was shown down to other nodes due to gossip issue and we had to do rolling restart of all the nodes. In both the cases 2 nodes out of 6 nodes are getting stuck either in compaction or in generating snapshot. Abhishek Aggarwal *Senior Software Engineer* *M*: +91 8861212073 , 8588840304 *T*: 0124 6600600 *EXT*: 12128 ASF Center -A, ASF Center Udyog Vihar Phase IV, Download Our App [image: A] <https://play.google.com/store/apps/details?id=com.snapdeal.main_source=mobileAppLp_campaign=android> [image: A] <https://itunes.apple.com/in/app/snapdeal-mobile-shopping/id721124909?ls=1=8_source=mobileAppLp_campaign=ios> [image: W] <http://www.windowsphone.com/en-in/store/app/snapdeal/ee17fccf-40d0-4a59-80a3-04da47a5553f>
cluster creating problem due to same cluster name
Not able to create new cluster with existing name in reaper with diff seed. As per code firstly using the jmx cluster name is fetched and looked into DB if the cluster with same name exists or not. My point is if the seed ip is different then it should allow to create the new cluster.
Re: problem starting incremental repair using TheLastPicke Reaper
Hi Alex, that i already did and it worked but my question is if the passed value of incremental repair flag is different from the existing value then it should allow to create new repair_unit instead of getting repair_unit based on cluster name/ keyspace /column combination. and also if i delete the repair_unit then due to referential constraints i need to delete repair_segment and repair_run as well which will delete the run history corresponds to the repaid_unit. Abhishek Aggarwal *Senior Software Engineer* *M*: +91 8861212073 , 8588840304 *T*: 0124 6600600 *EXT*: 12128 ASF Center -A, ASF Center Udyog Vihar Phase IV, Download Our App [image: A] <https://play.google.com/store/apps/details?id=com.snapdeal.main_source=mobileAppLp_campaign=android> [image: A] <https://itunes.apple.com/in/app/snapdeal-mobile-shopping/id721124909?ls=1=8_source=mobileAppLp_campaign=ios> [image: W] <http://www.windowsphone.com/en-in/store/app/snapdeal/ee17fccf-40d0-4a59-80a3-04da47a5553f> On Wed, Oct 19, 2016 at 4:44 PM, Alexander Dejanovski < a...@thelastpickle.com> wrote: > Hi Abhishek, > > This shows you have two repair units for the same keyspace/table with > different incremental repair settings. > Can you delete your prior repair run (the one with incremental repair set > to false) and then create the new one with incremental repair set to true ? > > Let me know how that works, > > > On Wed, Oct 19, 2016 at 10:45 AM Abhishek Aggarwal < > abhishek.aggarwa...@snapdeal.com> wrote: > >> >> is there a way to start the incremental repair using the reaper. we >> completed full repair successfully and after that i tried to run the >> incremental run but getting the below error. >> >> >> A repair run already exist for the same cluster/keyspace/table but with a >> different incremental repair value.Requested value: true | Existing value: >> false >> >> >> -- > - > Alexander Dejanovski > France > @alexanderdeja > > Consultant > Apache Cassandra Consulting > http://www.thelastpickle.com >
problem starting incremental repair using TheLastPicke Reaper
is there a way to start the incremental repair using the reaper. we completed full repair successfully and after that i tried to run the incremental run but getting the below error. A repair run already exist for the same cluster/keyspace/table but with a different incremental repair value.Requested value: true | Existing value: false
Re: Cassandra sstable to Mysql
Thanks Bryan, I don't want to use the sstable as it will increase the load on Cassandra . I directly want to use the data file created using the CQLSSTablewriter for migrating to Mysql. Abhishek Aggarwal *Senior Software Engineer* *M*: +91 8861212073 , 8588840304 *T*: 0124 6600600 *EXT*: 12128 ASF Center -A, ASF Center Udyog Vihar Phase IV, Download Our App [image: A] <https://play.google.com/store/apps/details?id=com.snapdeal.main_source=mobileAppLp_campaign=android> [image: A] <https://itunes.apple.com/in/app/snapdeal-mobile-shopping/id721124909?ls=1=8_source=mobileAppLp_campaign=ios> [image: W] <http://www.windowsphone.com/en-in/store/app/snapdeal/ee17fccf-40d0-4a59-80a3-04da47a5553f> On Sun, Apr 3, 2016 at 12:30 AM, Bryan Cheng <br...@blockcypher.com> wrote: > You have SSTables and you want to get importable data? > > You could use a tool like sstabletojson to get json formatted data > directly from the sstables; however, unless they've been perfectly > compacted, there will be duplicates and updates interleaved that will be > properly ordered. > > If this is a full dump from a single machine that has a complete dataset > (eg. with RF=n) you could spin up a new machine with just itself as a seed > but all other configuration intact. If this new machine gets an identical > copy of the cassandra data directory, it will start itself as a clone of > the machine the dump came off of, but walled off from the previous cluster. > (I have tested this with vnodes, but I believe it is more involved without > vnodes). Then you can use CQL COPY or an application to bulk load into > MySQL. > > On Fri, Apr 1, 2016 at 2:55 AM, Abhishek Aggarwal < > abhishek.aggarwa...@snapdeal.com> wrote: > >> Hi , >> >> We have the data dump into directory taken from Mysql using the >> CQLSSTableWriter. >> >> Our requirement is to read this data and load it into MySql. We don't >> want to use Cassandra as it will lead to read traffic and this operation is >> just for some validation . >> >> Can anyone help us with the solution. >> >> Abhishek Aggarwal >> >> *Senior Software Engineer* >> *M*: +91 8861212073 , 8588840304 >> *T*: 0124 6600600 *EXT*: 12128 >> ASF Center -A, ASF Center Udyog Vihar Phase IV, >> Download Our App >> [image: A] >> <https://play.google.com/store/apps/details?id=com.snapdeal.main_source=mobileAppLp_campaign=android> >> [image: >> A] >> <https://itunes.apple.com/in/app/snapdeal-mobile-shopping/id721124909?ls=1=8_source=mobileAppLp_campaign=ios> >> [image: >> W] >> <http://www.windowsphone.com/en-in/store/app/snapdeal/ee17fccf-40d0-4a59-80a3-04da47a5553f> >> > >
Cassandra sstable to Mysql
Hi , We have the data dump into directory taken from Mysql using the CQLSSTableWriter. Our requirement is to read this data and load it into MySql. We don't want to use Cassandra as it will lead to read traffic and this operation is just for some validation . Can anyone help us with the solution. Abhishek Aggarwal *Senior Software Engineer* *M*: +91 8861212073 , 8588840304 *T*: 0124 6600600 *EXT*: 12128 ASF Center -A, ASF Center Udyog Vihar Phase IV, Download Our App [image: A] <https://play.google.com/store/apps/details?id=com.snapdeal.main_source=mobileAppLp_campaign=android> [image: A] <https://itunes.apple.com/in/app/snapdeal-mobile-shopping/id721124909?ls=1=8_source=mobileAppLp_campaign=ios> [image: W] <http://www.windowsphone.com/en-in/store/app/snapdeal/ee17fccf-40d0-4a59-80a3-04da47a5553f>
