def test_retry_txn_pool_full(self):
master_conn = vtdb_test.get_connection(db_type='master')
master_conn._execute("set vt_transaction_cap=1", {})
master_conn.begin()
master_conn2 = vtdb_test.get_connection(db_type='master')
master_conn2.begin()
master_conn.commit()
master_conn._execute("set vt_transaction_cap=20", {})
master_conn.begin()
master_conn._execute("delete from vt_insert_test", {})
master_conn.commit()
def test_retry_txn_pool_full(self):
master_conn = vtdb_test.get_connection(db_type='master')
master_conn._execute("set vt_transaction_cap=1", {})
master_conn.begin()
master_conn2 = vtdb_test.get_connection(db_type='master')
master_conn2.begin()
master_conn.commit()
master_conn._execute("set vt_transaction_cap=20", {})
master_conn.begin()
master_conn._execute("delete from vt_insert_test", {})
master_conn.commit()
def test_vtgate_restart_stream_execute(self):
try:
replica_conn = vtdb_test.get_connection(
db_type='replica', shard_index=self.shard_index)
except Exception, e:
self.fail("Connection to %s replica failed with error %s" %
(vtdb_test.shard_names[self.shard_index], str(e)))
def test_tablet_restart_read(self):
try:
replica_conn = vtdb_test.get_connection(
db_type='replica', shard_index=self.shard_index)
except Exception, e:
self.fail("Connection to shard %s replica failed with error %s" %
(vtdb_test.shard_names[self.shard_index], str(e)))
def test_restart_mysql_failure(self):
try:
replica_conn = vtdb_test.get_connection(
db_type='replica', shard_index=self.shard_index)
except Exception, e:
self.fail("Connection to shard0 replica failed with error %s" %
str(e))
def test_tablet_timeout(self):
try:
replica_conn = vtdb_test.get_connection(
db_type='replica', shard_index=self.shard_index)
except Exception, e:
self.fail("Connection to shard0 replica failed with error %s" %
str(e))
def test_tablet_restart_stream_execute(self):
try:
replica_conn = vtdb_test.get_connection(db_type='replica', shard_index=self.shard_index)
except Exception, e:
self.fail("Connection to shard0 replica failed with error %s" % str(e))
def test_tablet_restart_read(self):
try:
replica_conn = vtdb_test.get_connection(db_type='replica', shard_index=self.shard_index)
except Exception, e:
self.fail("Connection to shard %s replica failed with error %s" % (shard_names[self.shard_index], str(e)))
def test_restart_mysql_failure(self):
return
try:
replica_conn = vtdb_test.get_connection(db_type='replica', shard_index=self.shard_index)
except Exception, e:
self.fail("Connection to shard0 replica failed with error %s" % str(e))
master_conn.commit()
proc = self.master_tablet.start_vttablet()
master_conn.begin()
master_conn._execute("delete from vt_insert_test", {})
master_conn.commit()
def test_query_timeout(self):
try:
replica_conn = vtdb_test.get_connection(db_type='replica', shard_index=self.shard_index)
except Exception, e:
self.fail("Connection to shard0 replica failed with error %s" % str(e))
with self.assertRaises(dbexceptions.TimeoutError):
replica_conn._execute("select sleep(12) from dual", {})
try:
master_conn = vtdb_test.get_connection(db_type='master')
except Exception, e:
self.fail("Connection to shard0 master failed with error %s" % str(e))
with self.assertRaises(dbexceptions.TimeoutError):
master_conn._execute("select sleep(12) from dual", {})
# FIXME(shrutip): flaky test, making it NOP for now
def test_restart_mysql_failure(self):
return
try:
replica_conn = vtdb_test.get_connection(db_type='replica', shard_index=self.shard_index)
except Exception, e:
self.fail("Connection to shard0 replica failed with error %s" % str(e))
utils.wait_procs([self.replica_tablet.shutdown_mysql(),])
with self.assertRaises(dbexceptions.DatabaseError):
replica_conn._execute("select 1 from vt_insert_test", {})
def test_vtgate_restart_stream_execute(self):
try:
replica_conn = vtdb_test.get_connection(db_type='replica', shard_index=self.shard_index)
except Exception, e:
self.fail("Connection to %s replica failed with error %s" % (vtdb_test.shard_names[self.shard_index], str(e)))
def test_tablet_restart_begin(self):
try:
master_conn = vtdb_test.get_connection(db_type='master')
except Exception, e:
self.fail("Connection to shard0 master failed with error %s" %
str(e))
def test_vtgate_fail_write(self):
try:
master_conn = vtdb_test.get_connection(db_type='master')
except Exception, e:
self.fail("Connection to shard0 master failed with error %s" %
str(e))
def test_tablet_fail_write(self):
try:
master_conn = vtdb_test.get_connection(db_type='master')
except Exception, e:
self.fail("Connection to shard0 master failed with error %s" % str(e))
def test_vtgate_restart_begin(self):
try:
master_conn = vtdb_test.get_connection(db_type='master')
except Exception, e:
self.fail("Connection to shard0 master failed with error %s" % str(e))
def test_query_timeout(self):
try:
replica_conn = vtdb_test.get_connection(db_type='replica', shard_index=self.shard_index)
except Exception, e:
self.fail("Connection to shard0 replica failed with error %s" % str(e))
def test_vtgate_fail_write(self):
try:
master_conn = vtdb_test.get_connection(db_type='master')
except Exception, e:
self.fail("Connection to shard0 master failed with error %s" %
str(e))
with self.assertRaises(dbexceptions.OperationalError):
master_conn.begin()
utils.vtgate_kill(vtdb_test.vtgate_server)
master_conn._execute("delete from vt_insert_test", {})
master_conn.commit()
vtdb_test.vtgate_server, vtdb_test.vtgate_port = utils.vtgate_start(
vtdb_test.vtgate_port)
try:
master_conn = vtdb_test.get_connection(db_type='master')
except Exception, e:
self.fail("Connection to shard0 master failed with error %s" %
str(e))
master_conn.begin()
master_conn._execute("delete from vt_insert_test", {})
master_conn.commit()
# test timeout between py client and vtgate
# the default timeout is 10 seconds
def test_vtgate_timeout(self):
try:
replica_conn = vtdb_test.get_connection(
db_type='replica', shard_index=self.shard_index)
except Exception, e:
self.fail("Connection to shard0 replica failed with error %s" %
