org.apache.derbyTesting.functionTests.tests.store

Class ClobReclamationTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.store.ClobReclamationTest

All Implemented Interfaces:

junit.framework.Test

public class ClobReclamationTest
extends BaseJDBCTestCase

Verify that space gets reclaimed for multi-threaded Clob updates

Field Summary

Fields

Modifier and Type	Field and Description
private static int	expectedNumAllocated
private static int	NUM_THREADS

Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
ClobReclamationTest(java.lang.String name)

Method Summary

Modifier and Type	Method and Description
private void	checkNumAllocatedPages(java.lang.String table, int expectedAlloc) Check that table has specified number of allocated pages.
private void	checkNumFreePages(java.lang.String table, int expectedFree) Check that table has specified number of free pages.
private static void	fiveHundredUpdates(java.sql.Connection conn, java.lang.String updateString, int key, boolean lockTable)
static junit.framework.Test	suite()
void	testBlobLinkedListReclamationOnRollback() Test for DERBY-4182.
void	testMultiThreadedUpdate(boolean lockTable, boolean updateSingleRow) Two threads simultaneously updating a table.
void	testMultiThreadedUpdateRowLocking() Test multithreaded clob update using standard row locking
void	xtestMultiThreadedUpdateTableLocking() Test multithreaded clob update but get an exclusive lock on the table for each update.
void	xtestMultiThreadUpdateSingleRow() Test multiThreaded update of single row to cause lock contention This will trigger the row lock retry case of DERBY-4055
void	xtestReclamationOnRollback() Make sure we reclaim space on rollback.

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, emptyStatementCache, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runBare, runBareOverridable, runScript, runScript, runSQLCommands, setAutoCommit, tearDown, usingDB2Client, usingDerbyNetClient, usingEmbedded

Methods inherited from class org.apache.derbyTesting.junit.BaseTestCase

alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemProperty, sleep, sleepAtLeastOneTick, traceit

Methods inherited from class junit.framework.TestCase

assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, countTestCases, createResult, fail, fail, failNotEquals, failNotSame, failSame, format, getName, run, run, runTest, setName, setUp, toString

Methods inherited from class java.lang.Object

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

Field Detail

NUM_THREADS

private static final int NUM_THREADS

See Also:

Constant Field Values

expectedNumAllocated

private static int expectedNumAllocated

Constructor Detail

ClobReclamationTest

public ClobReclamationTest(java.lang.String name)

Method Detail

testMultiThreadedUpdate

public void testMultiThreadedUpdate(boolean lockTable,
                                    boolean updateSingleRow)
                             throws java.sql.SQLException,
                                    java.lang.InterruptedException

Two threads simultaneously updating a table. Threads each update a separate row with a long value (>32K). NUMALLOCATED pages should not grow past expected value after 500 updates by each thread.

Parameters:

lockTable - true if we should get an exclusive lock on the table before update

updateSingleRow - true if we should try updating a single row instead of different rows

Throws:

java.sql.SQLException

java.lang.InterruptedException

checkNumAllocatedPages

private void checkNumAllocatedPages(java.lang.String table,
                                    int expectedAlloc)
                             throws java.sql.SQLException

Check that table has specified number of allocated pages.

Parameters:

table -

expectedAlloc -

Throws:

java.sql.SQLException

checkNumFreePages

private void checkNumFreePages(java.lang.String table,
                               int expectedFree)
                        throws java.sql.SQLException

Check that table has specified number of free pages.

Parameters:

table -

expectedFree - expected number of free pages.

Throws:

java.sql.SQLException

fiveHundredUpdates

private static void fiveHundredUpdates(java.sql.Connection conn,
                                       java.lang.String updateString,
                                       int key,
                                       boolean lockTable)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

testMultiThreadedUpdateRowLocking

public void testMultiThreadedUpdateRowLocking()
                                       throws java.sql.SQLException,
                                              java.lang.InterruptedException

Test multithreaded clob update using standard row locking

Throws:

java.sql.SQLException

java.lang.InterruptedException

xtestMultiThreadedUpdateTableLocking

public void xtestMultiThreadedUpdateTableLocking()
                                          throws java.sql.SQLException,
                                                 java.lang.InterruptedException

Test multithreaded clob update but get an exclusive lock on the table for each update. We can't enable this teset until DERBY-4054 is fixed.

Throws:

java.sql.SQLException

java.lang.InterruptedException

xtestMultiThreadUpdateSingleRow

public void xtestMultiThreadUpdateSingleRow()
                                     throws java.sql.SQLException,
                                            java.lang.InterruptedException

Test multiThreaded update of single row to cause lock contention This will trigger the row lock retry case of DERBY-4055

Throws:

java.sql.SQLException

java.lang.InterruptedException

xtestReclamationOnRollback

public void xtestReclamationOnRollback()
                                throws java.sql.SQLException

Make sure we reclaim space on rollback. Cannot enable this test until DERBY-4057 is fixed.

Throws:

java.sql.SQLException

testBlobLinkedListReclamationOnRollback

public void testBlobLinkedListReclamationOnRollback()
                                             throws java.sql.SQLException

Test for DERBY-4182. This test just exercises the abort specific part of DERBY-4182. After the fix abort of an insert containing a blob will leave the head row, plus the first page of the overflow chain. The rest of the chain will be moved to free pages.

Throws:

java.sql.SQLException

suite

public static junit.framework.Test suite()