Cassandra - Cannot proceed on repair because a neighbor is dead: session failed/Endpoint Died

Overview Many of you would have faced these error during nodetool repair - Repair session 2a703be0-7722-11e5-ac24-c5a3c7c6e3cf for range (5995916511884239066,6033116056473427945] failed with error java.io.IOException: Cannot proceed on repair because a neighbor (/<node IP>) is dead: session failed. Repair session 28c63560-7722-11e5-ac24-c5a3c7c6e3cf for range (-135025182178679597,-28481663575762586] failed with error java.io.IOException: Endpoint /<IP of node> died and By looking at this error...

Continue Reading →

Cassandra Cluster Migration to a New Cluster V2.2.4

Overview This page describe how to migrate from an existing cluster to a new cluster. Several times we have a situations where we want to move the entire cluster to a new cluster (reason could be anything; better hardware, moving away from existing data center etc.) without taking any downtime and ensuring all data gets migrated to new cluster, we had the same requirement and we decided to go with below mentioned strategy which worked like a charm. This whole process is online and without impacting client, Old DC...

Continue Reading →

Role Based Access Control (RBAC) Cassandra 2.2.4 Explained with Example

Overview Cassandra has recently launced most awaiting feature "Role based access control (RBAC)" but there are very limited information available on web and people actually stuck at practicle scenarios viz. 1. How to migrate from legacy authentication to RBAC. 2. Is there any changes need to be made in cassandra.yaml file. 3. What table structure changes been made to system_auth keyspaces. 4. What about legacy table. 5. We have legacy table as well as new table also and creating a new user doesnt work. 6. What...

Continue Reading →

SQL Server Bulk Session kill script

Ask for SQL server instance, login and hostname for which the sessions need to be killed and replace the value of @login and @host in below script and execute it on the servers where the session need to be killed. declare @login varchar (200) declare @host varchar (200) declare @id int declare @host_desc varchar(200) declare @login_desc varchar (200) declare @str nvarchar(200) /* Replace login and hostname value*/ SET @login = '<login-need-to-be-killed>' SET @host = '<login-from-which-host>' DECLARE...

Continue Reading →

In Order to run a trace against SQL Server you must be a member of sysadmin. (Enable trace access without granting sysadmin role)

Use below query to enable trace access without granting sysadmin role. Use Master; GRANT VIEW SERVER STATE TO [Domain\ADGroup or User]; GRANT SHOWPLAN TO [Domain\ADGroup or User]; GRANT ALTER TRACE TO [Domain\ADGroup or User]; Checkout Deal of the Day on Amazon....

Continue Reading →

SQL Query to get IP address of local & client machine

SELECT    CONNECTIONPROPERTY('net_transport') AS net_transport,    CONNECTIONPROPERTY('protocol_type') AS protocol_type,    CONNECTIONPROPERTY('auth_scheme') AS auth_scheme,    CONNECTIONPROPERTY('local_net_address') AS local_net_address,    CONNECTIONPROPERTY('local_tcp_port') AS local_tcp_port,    CONNECTIONPROPERTY('client_net_address') AS client_net_addres...

Continue Reading →

Facebook Feed is not getting displayed in latest release of Skype - version 6.3

Hi Guys, Yes i know this post is something out of the scope of this blog but still i though to write this as i believe most of us uses Skype for communication, and if you have upgraded to Skype latest version 6.3 then you must have noticed Facebook Feed Disconnection on Skype Home Page which is very annoying. I tried to dig it a bit deeper and found the reason, but don't be happy i do not have the fix for this :( When you...

Continue Reading →