/**
* Reproducing the issue #29 in cassandra-sharp
* https://github.com/pchalamet/cassandra-sharp/issues/29
* malformed prepared query cause issues to be swallwoed and hold indefinelty to stream_id.
* */
public void FailingThread(IPreparedQuery <NonQuery> prepared)
{
logger.Debug("Starting Failing thread ");
Thread.Sleep(5000);
for (int i = 0; i < NUM_UPDATES; i++)
{
logger.Debug("start fail update #" + i);
try
{
if (0 == (i % 2))
{
prepared.Execute(new { bar = "bar" + 1, strid = "1" }).AsFuture().Wait();
Assert.IsTrue(false, "Update should have failed");
}
else
{
prepared.Execute(new { bar = "bar" + 1, intid = i, strid = "1" }).AsFuture().Wait();
Console.WriteLine("Update {0} sucessful", i);
}
}
catch (Exception ex)
{
Console.WriteLine("Update {0} failed with error {1}", i, ex.Message);
}
logger.Debug("end fail update #" + i);
//Thread.Sleep(2000);
}
}
private static long InsertData(string data, IPreparedQuery<NonQuery> preparedQuery)
{
Console.WriteLine("Buffer size {0}", data.Length);
Stopwatch totalwatch = Stopwatch.StartNew();
// warmup
for (int i = 0; i < 10; ++i)
{
preparedQuery.Execute(new {x = "abc", y = data}).AsFuture().Wait();
}
const long nbQueries = 5000;
for (var i = 0; i < nbQueries; ++i)
{
Stopwatch stopwatch = Stopwatch.StartNew();
preparedQuery.Execute(new {x = "abc", y = data}).AsFuture().Wait();
stopwatch.Stop();
//Console.WriteLine("Insert: {0}", stopwatch.ElapsedMilliseconds);
}
totalwatch.Stop();
Console.WriteLine("Total inserts time ms: {0}", totalwatch.ElapsedMilliseconds);
Console.WriteLine("Total inserts/s: {0}", (1000.0*nbQueries)/totalwatch.ElapsedMilliseconds);
return totalwatch.ElapsedMilliseconds;
}
private static long InsertData(string data, IPreparedQuery <NonQuery> preparedQuery)
{
Console.WriteLine("Buffer size {0}", data.Length);
Stopwatch totalwatch = Stopwatch.StartNew();
// warmup
for (int i = 0; i < 10; ++i)
{
preparedQuery.Execute(new { x = "abc", y = data }).AsFuture().Wait();
}
const long nbQueries = 5000;
for (var i = 0; i < nbQueries; ++i)
{
Stopwatch stopwatch = Stopwatch.StartNew();
preparedQuery.Execute(new { x = "abc", y = data }).AsFuture().Wait();
stopwatch.Stop();
//Console.WriteLine("Insert: {0}", stopwatch.ElapsedMilliseconds);
}
totalwatch.Stop();
Console.WriteLine("Total inserts time ms: {0}", totalwatch.ElapsedMilliseconds);
Console.WriteLine("Total inserts/s: {0}", (1000.0 * nbQueries) / totalwatch.ElapsedMilliseconds);
return(totalwatch.ElapsedMilliseconds);
}
private IPreparedQuery <PropertyBag> BuildInsertQuery(IDataReader reader)
{
StringBuilder sbCols = new StringBuilder();
StringBuilder sbJokers = new StringBuilder();
string sep = "";
for (int i = 0; i < reader.FieldCount; ++i)
{
string name = reader.GetName(i);
sbCols.AppendFormat("{0}{1}", sep, name);
sbJokers.AppendFormat("{0}?", sep);
sep = ",";
}
string cqlInsert = string.Format("insert into {0}.{1} ({2}) values ({3})", Keyspace, Table, sbCols, sbJokers);
var ccmd = CommandContext.Cluster.CreatePropertyBagCommand().WithConsistencyLevel(CL);
IPreparedQuery <PropertyBag> insertQuery = ccmd.Prepare(cqlInsert);
return(insertQuery);
}
public override void ActivateOptions()
{
_cluster = ClusterManager.GetCluster(ClusterName);
string insertCQL =
string.Format(
"insert into {0}.{1} " +
"(id," +
"app_name," +
"app_start_time," +
"class_name," +
"file_name," +
"host_ip," +
"host_name," +
"level," +
"line_number," +
"log_timestamp," +
"logger_name," +
"message," +
"method_name," +
"thread_name," +
"throwable_str_rep) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",
Keyspace, ColumnFamily);
_insert = _cluster.CreatePocoCommand()
.WithConsistencyLevel(ConsistencyLevel)
.Prepare(insertCQL);
}
/**
* Reproducing the issue #29 in cassandra-sharp
* https://github.com/pchalamet/cassandra-sharp/issues/29
* malformed prepared query cause issues to be swallwoed and hold indefinelty to stream_id.
* */
public void FailingThread(IPreparedQuery prepared)
{
logger.Debug("Starting Failing thread ");
Thread.Sleep(5000);
for (int i = 0; i < NUM_UPDATES; i++)
{
logger.Debug("start fail update #" + i);
try
{
if (0 == (i%2))
{
prepared.ExecuteNonQuery(new {bar = "bar" + 1, strid = "1"}, ConsistencyLevel.ONE).Wait();
Assert.IsTrue(false, "Update should have failed");
}
else
{
prepared.ExecuteNonQuery(new { bar = "bar" + 1, intid = i, strid = "1" }, ConsistencyLevel.ONE).Wait();
Console.WriteLine("Update {0} sucessful", i);
}
}
catch (Exception ex)
{
Console.WriteLine("Update {0} failed with error {1}", i, ex.Message);
}
logger.Debug("end fail update #" + i);
//Thread.Sleep(2000);
}
}
public override void Prepare(string cmd)
{
_prepared = _cmd.WithExecutionFlags(ExecutionFlags.ServerTracing).Prepare(cmd);
}
public override void Prepare(string cmd)
{
_prepared = _cmd.WithExecutionFlags(ExecutionFlags.ServerTracing).Prepare(cmd);
}
