[Repeat(3)] // remove when propagtion of optimistic locking flag is done to slave database locations TO DO (issue caused by CopyAllDatabasdesTo that uses pessimistic locking)
public void multipleServersOK()
{
using (SessionNoServer session = new SessionNoServer(systemDir))
{
session.BeginRead();
foreach (DatabaseLocation loc in session.DatabaseLocations)
{
Console.WriteLine(loc.ToStringDetails(session, false));
}
session.Commit();
}
using (ServerClientSession session = new ServerClientSession(systemDir, systemHost))
{
session.SetTraceDbActivity(0);
DatabaseLocation localLocation = new DatabaseLocation(systemHost, location2Dir, 10000, 20000, session, PageInfo.compressionKind.LZ4, 0);
Placement place = new Placement(10000, 2);
session.BeginUpdate();
foreach (DatabaseLocation loc in session.DatabaseLocations)
{
Console.WriteLine(loc.ToStringDetails(session, false));
}
Console.WriteLine();
session.NewLocation(localLocation);
foreach (DatabaseLocation loc in session.DatabaseLocations)
{
Console.WriteLine(loc.ToStringDetails(session, false));
}
Man aMan = null;
Woman aWoman = null;
for (int j = 1; j <= 5; j++)
{
aMan = new Man(null, aMan, DateTime.UtcNow);
aMan.Persist(place, session);
aWoman = new Woman(aMan, aWoman);
aWoman.Persist(place, session);
aMan.m_spouse = new WeakIOptimizedPersistableReference <VelocityDbSchema.Person>(aWoman);
if (j % 1000 == 0)
{
session.FlushUpdates();
}
}
localLocation = new DatabaseLocation(systemHost2, systemDir, 20001, 30000, session, PageInfo.compressionKind.LZ4, 0);
session.NewLocation(localLocation);
foreach (DatabaseLocation loc in session.DatabaseLocations)
{
Console.WriteLine(loc.ToStringDetails(session, false));
}
place = new Placement(20001);
//localDatabase = session.NewDatabase(20001, localLocation);
for (int j = 1; j <= 5; j++)
{
aMan = new Man(null, aMan, DateTime.UtcNow);
aMan.Persist(place, session);
aWoman = new Woman(aMan, aWoman);
aWoman.Persist(place, session);
aMan.m_spouse = new WeakIOptimizedPersistableReference <VelocityDbSchema.Person>(aWoman);
if (j % 1000 == 0)
{
session.FlushUpdates();
}
}
DatabaseLocation serverLocation = new DatabaseLocation(systemHost2, location2Dir, 30001, 40000, session, PageInfo.compressionKind.LZ4, 0);
session.NewLocation(serverLocation);
foreach (DatabaseLocation loc in session.DatabaseLocations)
{
Console.WriteLine(loc.ToStringDetails(session, false));
}
place = new Placement(30001);
for (int j = 1; j <= 5; j++)
{
aMan = new Man(null, aMan, DateTime.UtcNow);
aMan.Persist(place, session);
aWoman = new Woman(aMan, aWoman);
aWoman.Persist(place, session);
aMan.m_spouse = new WeakIOptimizedPersistableReference <VelocityDbSchema.Person>(aWoman);
if (j % 1000 == 0)
{
session.FlushUpdates();
}
}
localLocation = new DatabaseLocation(systemHost3, systemDir, 40001, 50000, session, PageInfo.compressionKind.None, 0);
session.NewLocation(localLocation);
place = new Placement(40001);
//localDatabase = session.NewDatabase(20001, localLocation);
for (int j = 1; j <= 5; j++)
{
aMan = new Man(null, aMan, DateTime.UtcNow);
aMan.Persist(place, session);
aWoman = new Woman(aMan, aWoman);
aWoman.Persist(place, session);
aMan.m_spouse = new WeakIOptimizedPersistableReference <VelocityDbSchema.Person>(aWoman);
if (j % 1000 == 0)
{
session.FlushUpdates();
}
}
session.Commit();
}
using (ServerClientSession session = new ServerClientSession(systemDir, systemHost))
{
session.CopyAllDatabasesTo(copyDir);
using (SessionNoServer copySession = new SessionNoServer(copyDir))
{
copySession.Verify();
}
}
using (ServerClientSession session = new ServerClientSession(systemDir, systemHost, 2000, false)) // TO DO, change back to use optimistic locking
{
//session.SetTraceDbActivity(0);
session.BeginUpdate();
Database db = session.OpenDatabase(10000);
session.DeleteDatabase(db);
db = session.OpenDatabase(20001);
session.DeleteDatabase(db);
db = session.OpenDatabase(30001);
session.DeleteDatabase(db);
db = session.OpenDatabase(40001);
session.DeleteDatabase(db);
session.Commit();
Directory.Delete(copyDir, true);
}
System.GC.Collect();
System.GC.WaitForPendingFinalizers();
using (ServerClientSession session = new ServerClientSession(systemDir, systemHost))
{
Assert.True(session.OptimisticLocking);
}
}
[Repeat(3)] // remove when propagation of optimistic locking flag is done to slave database locations TO DO (issue caused by CopyAllDatabasdesTo that uses pessimistic locking)
public void multipleServersOK()
{
using (SessionNoServer session = new SessionNoServer(systemDir))
{
session.BeginRead();
foreach (DatabaseLocation loc in session.DatabaseLocations)
Console.WriteLine(loc.ToStringDetails(session, false));
session.Commit();
}
using (ServerClientSession session = new ServerClientSession(systemDir, systemHost))
{
session.SetTraceDbActivity(0);
DatabaseLocation localLocation = new DatabaseLocation(systemHost, location2Dir, 10000, 20000, session, PageInfo.compressionKind.LZ4, 0);
Placement place = new Placement(10000, 2);
session.BeginUpdate();
foreach (DatabaseLocation loc in session.DatabaseLocations)
Console.WriteLine(loc.ToStringDetails(session, false));
Console.WriteLine();
session.NewLocation(localLocation);
foreach (DatabaseLocation loc in session.DatabaseLocations)
Console.WriteLine(loc.ToStringDetails(session, false));
Man aMan = null;
Woman aWoman = null;
for (int j = 1; j <= 5; j++)
{
aMan = new Man(null, aMan, DateTime.UtcNow);
aMan.Persist(place, session);
aWoman = new Woman(aMan, aWoman);
aWoman.Persist(place, session);
aMan.m_spouse = new WeakIOptimizedPersistableReference<VelocityDbSchema.Person>(aWoman);
if (j % 1000 == 0)
{
session.FlushUpdates();
}
}
localLocation = new DatabaseLocation(systemHost2, systemDir, 20001, 30000, session, PageInfo.compressionKind.LZ4, 0);
session.NewLocation(localLocation);
foreach (DatabaseLocation loc in session.DatabaseLocations)
Console.WriteLine(loc.ToStringDetails(session, false));
place = new Placement(20001);
//localDatabase = session.NewDatabase(20001, localLocation);
for (int j = 1; j <= 5; j++)
{
aMan = new Man(null, aMan, DateTime.UtcNow);
aMan.Persist(place, session);
aWoman = new Woman(aMan, aWoman);
aWoman.Persist(place, session);
aMan.m_spouse = new WeakIOptimizedPersistableReference<VelocityDbSchema.Person>(aWoman);
if (j % 1000 == 0)
{
session.FlushUpdates();
}
}
DatabaseLocation serverLocation = new DatabaseLocation(systemHost2, location2Dir, 30001, 40000, session, PageInfo.compressionKind.LZ4, 0);
session.NewLocation(serverLocation);
foreach (DatabaseLocation loc in session.DatabaseLocations)
Console.WriteLine(loc.ToStringDetails(session, false));
place = new Placement(30001);
for (int j = 1; j <= 5; j++)
{
aMan = new Man(null, aMan, DateTime.UtcNow);
aMan.Persist(place, session);
aWoman = new Woman(aMan, aWoman);
aWoman.Persist(place, session);
aMan.m_spouse = new WeakIOptimizedPersistableReference<VelocityDbSchema.Person>(aWoman);
if (j % 1000 == 0)
{
session.FlushUpdates();
}
}
localLocation = new DatabaseLocation(systemHost3, systemDir, 40001, 50000, session, PageInfo.compressionKind.None, 0);
session.NewLocation(localLocation);
place = new Placement(40001);
//localDatabase = session.NewDatabase(20001, localLocation);
for (int j = 1; j <= 5; j++)
{
aMan = new Man(null, aMan, DateTime.UtcNow);
aMan.Persist(place, session);
aWoman = new Woman(aMan, aWoman);
aWoman.Persist(place, session);
aMan.m_spouse = new WeakIOptimizedPersistableReference<VelocityDbSchema.Person>(aWoman);
if (j % 1000 == 0)
{
session.FlushUpdates();
}
}
session.Commit();
}
using (ServerClientSession session = new ServerClientSession(systemDir, systemHost))
{
session.CopyAllDatabasesTo(copyDir);
using (SessionNoServer copySession = new SessionNoServer(copyDir))
{
copySession.Verify();
}
}
using (ServerClientSession session = new ServerClientSession(systemDir, systemHost, 2000, false)) // TO DO, change back to use optimistic locking
{
//session.SetTraceDbActivity(0);
session.BeginUpdate();
Database db = session.OpenDatabase(10000);
session.DeleteDatabase(db);
db = session.OpenDatabase(20001);
session.DeleteDatabase(db);
db = session.OpenDatabase(30001);
session.DeleteDatabase(db);
db = session.OpenDatabase(40001);
session.DeleteDatabase(db);
session.Commit();
Directory.Delete(copyDir, true);
}
System.GC.Collect();
System.GC.WaitForPendingFinalizers();
using (ServerClientSession session = new ServerClientSession(systemDir, systemHost))
{
Assert.True(session.OptimisticLocking);
}
}