Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Revise the MultithreadingTest to remove potential race conditions on slower systems. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
0ccc54331a6ae6f65e62993a94d526e2 |
| User & Date: | mistachkin 2011-07-23 04:01:47 |
Context
|
2011-07-23
| ||
| 04:39 | Show version information for the interop assembly during testing. check-in: 6e630b74b2 user: mistachkin tags: trunk | |
| 04:01 | Revise the MultithreadingTest to remove potential race conditions on slower systems. check-in: 0ccc54331a user: mistachkin tags: trunk | |
| 00:59 | Merge interop changes for debug SQLite core testing and updated SQLite core itself. check-in: ff19f6474c user: mistachkin tags: trunk | |
Changes
Changes to test/TestCases.cs.
6 7 8 9 10 11 12 13 14 15 16 17 18 19 .... 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 .... 1298 1299 1300 1301 1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312 1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 .... 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 .... 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 |
using System.Collections.Generic;
using System.Text;
namespace test
{
internal class TestCases : TestCaseBase
{
private List<string> droptables = new List<string>();
private List<string> maydroptable = new List<string>();
private long logevents = 0;
internal TestCases()
{
................................................................................
internal class MTTest
{
internal DbConnection cnn;
internal Exception e;
internal System.Threading.Thread t;
internal int value;
}
[Test(Sequence=11)]
internal void MultithreadingTest()
{
using (DbCommand cmd = _cnn.CreateCommand())
{
................................................................................
cmd.CommandText = "CREATE TABLE MultiThreadedTest(ID integer identity primary key, ThreadId integer, MyValue integer)";
else
cmd.CommandText = "CREATE TABLE MultiThreadedTest(ID integer primary key, ThreadId integer, MyValue integer)";
cmd.ExecuteNonQuery();
}
MTTest[] arr = new MTTest[8];
for (int n = 0; n < arr.Length; n++)
{
arr[n] = new MTTest();
arr[n].t = new System.Threading.Thread(new System.Threading.ParameterizedThreadStart(MultithreadedTestThread));
arr[n].t.IsBackground = true;
arr[n].cnn = ((ICloneable)_cnn).Clone() as DbConnection;
arr[n].t.Start(arr[n]);
}
System.Threading.Thread.Sleep(8000);
bool failed = false;
Exception e = null;
for (int n = 0; n < arr.Length; n++)
{
if (arr[n].t.Join(0) == false)
{
failed = true;
arr[n].t.Abort();
}
if (arr[n].e != null) e = arr[n].e;
arr[n].cnn.Dispose();
}
if (failed) throw new Exception("One or more threads deadlocked");
if (e != null)
throw e;
}
internal void MultithreadedTestThread(object obj)
................................................................................
test.cnn.Open();
int start = Environment.TickCount;
try
{
using (DbCommand cmd = test.cnn.CreateCommand())
{
while (Environment.TickCount - start < 2000)
{
using (DbTransaction trans = test.cnn.BeginTransaction())
{
cmd.CommandText = String.Format("SELECT * FROM MultiThreadedTest WHERE ThreadId = {0}", test.t.ManagedThreadId);
cmd.Transaction = trans;
using (DbDataReader reader = cmd.ExecuteReader())
{
................................................................................
}
}
cmd.CommandText = String.Format("INSERT INTO MultiThreadedTest(ThreadId, MyValue) VALUES({0}, {1})", test.t.ManagedThreadId, Environment.TickCount);
cmd.ExecuteNonQuery();
trans.Commit();
}
}
}
}
catch (Exception e)
{
test.e = e;
}
}
[Test]
internal void ParameterizedInsert()
{
using (DbCommand cmd = _cnn.CreateCommand())
{
|
> > > > > | > | > > > > > | > > > > > > |
6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 .... 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 1299 .... 1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312 1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 .... 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 .... 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 |
using System.Collections.Generic;
using System.Text;
namespace test
{
internal class TestCases : TestCaseBase
{
private const int NumThreads = 8;
private const int ThreadTimeout = 60000;
private List<string> droptables = new List<string>();
private List<string> maydroptable = new List<string>();
private long logevents = 0;
internal TestCases()
{
................................................................................
internal class MTTest
{
internal DbConnection cnn;
internal Exception e;
internal System.Threading.Thread t;
internal int value;
internal System.Threading.ManualResetEvent ev;
}
[Test(Sequence=11)]
internal void MultithreadingTest()
{
using (DbCommand cmd = _cnn.CreateCommand())
{
................................................................................
cmd.CommandText = "CREATE TABLE MultiThreadedTest(ID integer identity primary key, ThreadId integer, MyValue integer)";
else
cmd.CommandText = "CREATE TABLE MultiThreadedTest(ID integer primary key, ThreadId integer, MyValue integer)";
cmd.ExecuteNonQuery();
}
System.Threading.ManualResetEvent[] events = new System.Threading.ManualResetEvent[NumThreads];
MTTest[] arr = new MTTest[NumThreads];
for (int n = 0; n < arr.Length; n++)
{
arr[n] = new MTTest();
arr[n].t = new System.Threading.Thread(new System.Threading.ParameterizedThreadStart(MultithreadedTestThread));
arr[n].t.IsBackground = true;
arr[n].cnn = ((ICloneable)_cnn).Clone() as DbConnection;
arr[n].ev = events[n] = new System.Threading.ManualResetEvent(false);
arr[n].t.Start(arr[n]);
}
System.Threading.WaitHandle.WaitAll(events, ThreadTimeout);
bool failed = false;
Exception e = null;
for (int n = 0; n < arr.Length; n++)
{
if (arr[n].t.Join(0) == false)
{
failed = true;
arr[n].t.Abort();
arr[n].t.Join();
}
if (arr[n].e != null) e = arr[n].e;
arr[n].cnn.Dispose();
arr[n].ev.Close();
}
if (failed) throw new Exception("One or more threads deadlocked");
if (e != null)
throw e;
}
internal void MultithreadedTestThread(object obj)
................................................................................
test.cnn.Open();
int start = Environment.TickCount;
try
{
using (DbCommand cmd = test.cnn.CreateCommand())
{
bool once = false;
while (!once || ((Environment.TickCount - start) < 2000))
{
using (DbTransaction trans = test.cnn.BeginTransaction())
{
cmd.CommandText = String.Format("SELECT * FROM MultiThreadedTest WHERE ThreadId = {0}", test.t.ManagedThreadId);
cmd.Transaction = trans;
using (DbDataReader reader = cmd.ExecuteReader())
{
................................................................................
}
}
cmd.CommandText = String.Format("INSERT INTO MultiThreadedTest(ThreadId, MyValue) VALUES({0}, {1})", test.t.ManagedThreadId, Environment.TickCount);
cmd.ExecuteNonQuery();
trans.Commit();
}
once = true;
}
}
}
catch (Exception e)
{
test.e = e;
}
finally
{
test.ev.Set();
}
}
[Test]
internal void ParameterizedInsert()
{
using (DbCommand cmd = _cnn.CreateCommand())
{
|