testsuite.regression

Class StressRegressionTest

java.lang.Object

testsuite.BaseTestCase

testsuite.regression.StressRegressionTest

public class StressRegressionTest
extends BaseTestCase

Tests for multi-thread stress regressions.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
class	StressRegressionTest.BusyThread
(package private) class	StressRegressionTest.ContentionThread
(package private) class	StressRegressionTest.CreateThread
private static class	StressRegressionTest.SharedInfoForTestBug67760

Nested classes/interfaces inherited from class testsuite.BaseTestCase

BaseTestCase.MockConnectionConfiguration

Field Summary

Fields

Modifier and Type	Field and Description
private int	numThreadsStarted

Fields inherited from class testsuite.BaseTestCase

conn, dbClass, dbName, dbUrl, isOpenSSL, mainConnectionUrl, pstmt, rs, serverVersion, stmt, timeZoneFreeDbUrl

Constructor Summary

Constructors

Constructor and Description
StressRegressionTest()

Method Summary

Modifier and Type	Method and Description
(package private) void	contentiousWork(java.sql.Connection threadConn, java.sql.Statement threadStmt, int threadNumber)
(package private) void	reportDone()
void	testBug67760() Tests fix for BUG#67760 - Deadlock when concurrently executing prepared statements with Timestamp objects Concurrent execution of Timestamp, Date and Time related setters and getters from a PreparedStatement and ResultSet object obtained from a same shared Connection may result in a deadlock.
void	testContention()
void	testCreateConnections()
void	testCreateConnectionsUnderLoad()

Methods inherited from class testsuite.BaseTestCase

appendRequiredProperties, assertByteArrayEquals, assertConnectionsHistory, assertEqualsFSAware, assertNonSecureConnection, assertResultSetLength, assertResultSetsEqual, assertSecureConnection, assertSecureConnection, assertSessionStatusEquals, assertThrows, assertThrows, assertThrows, assertThrows, cleanupTempFiles, createDatabase, createDatabase, createFunction, createFunction, createProcedure, createProcedure, createSchemaObject, createSchemaObject, createTable, createTable, createTable, createTable, createUser, createUser, createView, createView, currentTimeMillis, dropDatabase, dropDatabase, dropFunction, dropFunction, dropProcedure, dropProcedure, dropSchemaObject, dropSchemaObject, dropTable, dropTable, dropUser, dropUser, dropView, dropView, fillPrimitiveDefaults, getConnectionWithProps, getConnectionWithProps, getConnectionWithProps, getConnectionWithProps, getEncodedHostFromTestsuiteUrl, getEncodedHostPortPairFromTestsuiteUrl, getFailoverConnection, getFailoverConnection, getHostFreePropertiesFromTestsuiteUrl, getHostFreePropertiesFromTestsuiteUrl, getHostFromTestsuiteUrl, getInstanceNumber, getLoadBalancedConnection, getLoadBalancedConnection, getLoadBalancedConnection, getMysqlVariable, getMysqlVariable, getNewConnection, getNoDbUrl, getPort, getPortFreeHostname, getPortFromTestsuiteUrl, getPropertiesFromTestsuiteUrl, getPropertiesFromUrl, getRowCount, getSingleIndexedValueWithQuery, getSingleIndexedValueWithQuery, getSingleValue, getSingleValueWithQuery, getSourceReplicaReplicationConnection, getSourceReplicaReplicationConnection, getSourceReplicaUrl, getSourceReplicaUrl, getUnreliableFailoverConnection, getUnreliableFailoverConnection, getUnreliableLoadBalancedConnection, getUnreliableLoadBalancedConnection, getUnreliableMultiHostConnection, getUnreliableReplicationConnection, getUnreliableReplicationConnection, getUnreliableReplicationConnection, isClassAvailable, isCommunityEdition, isEnterpriseEdition, isMysqlRunningLocally, isRunningOnJRockit, isServerRunningOnWindows, isSysPropDefined, logDebug, newTempBinaryFile, randomString, removeHostRelatedProps, removeSqlMode, runLongTests, setUpBase, supportsLoadLocalInfile, supportsTestCachingSha2PasswordKeys, supportsTestCertificates, supportsTestSha256PasswordKeys, supportsTimeZoneNames, supportsTLSv1_2, tearDownBase, versionMeetsMinimum, versionMeetsMinimum

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

numThreadsStarted

private int numThreadsStarted

Constructor Detail

StressRegressionTest

public StressRegressionTest()

Method Detail

testContention

@Test
 @Disabled(value="It\'s a very long test")
public void testContention()
                                                                     throws java.lang.Exception

Throws:

java.lang.Exception

testCreateConnections

@Test
public void testCreateConnections()
                                 throws java.lang.Exception

Throws:

java.lang.Exception

testCreateConnectionsUnderLoad

@Test
public void testCreateConnectionsUnderLoad()
                                          throws java.lang.Exception

Throws:

java.lang.Exception

contentiousWork

void contentiousWork(java.sql.Connection threadConn,
                     java.sql.Statement threadStmt,
                     int threadNumber)

Parameters:

threadConn -

threadStmt -

threadNumber -

reportDone

void reportDone()

testBug67760

@Test
public void testBug67760()
                        throws java.lang.Exception

Tests fix for BUG#67760 - Deadlock when concurrently executing prepared statements with Timestamp objects Concurrent execution of Timestamp, Date and Time related setters and getters from a PreparedStatement and ResultSet object obtained from a same shared Connection may result in a deadlock. This test exploits a non-deterministic situation that can end in a deadlock. It executes two concurrent jobs for 10 seconds while stressing the referred methods. The deadlock was observed before 3 seconds have elapsed, all times, in development environment. WARNING! If this test fails there is no guarantee that the JVM will remain stable and won't affect any other tests. It is imperative that this test passes to ensure other tests results.

Throws:

java.lang.Exception