org.apache.derbyTesting.functionTests.tests.storetests

Class st_reclaim_longcol

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.storetests.st_reclaim_longcol

All Implemented Interfaces:

junit.framework.Test

public class st_reclaim_longcol
extends BaseJDBCTestCase

The purpose of this test space reclamation of long rows and long columns. This addresses DERBY-670. The main issue is that previous to fixes for DERBY-670, space reclamation was only automatically queued when the last row on a page was deleted. In the case of long columns, the actual row on the main page can be quite small as the long data is streamed onto other pages. So the table can grow unexpectedly quite large before the default space reclamation kicks in. The change queues space reclamation in the case of long columns (blob/clob), immediately post commit of the single delete. The testing strategy is to loop doing insert, delete, commit of a blob for a number of iterations and check that the actual size of the table is reasonable. A sleep will be added to allow time for post commit to catch up as the test may be run in a number of environments with varying performance of background activities.

Field Summary

Fields

Modifier and Type	Field and Description
(package private) static boolean	verbose

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
private java.sql.ResultSet	getSpaceTable(java.lang.String table) Invoke SYSCS_DIAG.SPACE_TABLE on the specified table in the current schema.
private void	printCurrentRow(java.sql.ResultSet rs) Print the value of all columns in the current row of the specified result set, if debugging is enabled.
static junit.framework.Test	suite()
private void	test1(int blob_size, int num_rows) Test reclaim of a single deleted blob on a page with non-deleted rows.
private void	test2(int blob_size, int work_size, int total_work) DERBY-1913 test2 is too sensitive to machine speed and background thread processing.
void	testList()
private void	wait_for_max_allocated(java.lang.String test_name, int alloc_wait_count) wait for background thread to convert allocated pages to free pages Wait until the total number of allocated pages is <= alloc_wait_count.

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

assertCallError, assertCheckTable, assertCommitError, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertResults, assertResults, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, chattyPrepare, chattyPrepareCall, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, dumpRs, dumpRs, emptyStatementCache, executeQuery, expectCompilationError, expectCompilationError, expectExecutionError, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, goodStatement, goodUpdate, 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, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSameNullness, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, newAssertionFailedError, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemErr, setSystemOut, setSystemProperty, sleep, sleepAtLeastOneTick, traceit, vmAtLeast

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

verbose

static boolean verbose

Constructor Detail

st_reclaim_longcol

public st_reclaim_longcol(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

test1

private void test1(int blob_size,
                   int num_rows)
            throws java.sql.SQLException

Test reclaim of a single deleted blob on a page with non-deleted rows.

loops through inserting alternating long and short column rows resulting in pages with 1 short and one long. Deletes the long column row and tests that space from the long column row is reclaimed even though there are non-deleted rows on the page.

Throws:

java.sql.SQLException

test2

private void test2(int blob_size,
                   int work_size,
                   int total_work)
            throws java.sql.SQLException

DERBY-1913

test2 is too sensitive to machine speed and background thread processing. It would be better suited as a long running stress test if someone has the inclination. Disabling this test for now. test1 covers the original intent to test that blobs are immediately marked for post commit on individual delete, rather than waiting for all rows on a page to be deleted.

Throws:

java.sql.SQLException

getSpaceTable

private java.sql.ResultSet getSpaceTable(java.lang.String table)
                                  throws java.sql.SQLException

Invoke SYSCS_DIAG.SPACE_TABLE on the specified table in the current schema.

Throws:

java.sql.SQLException

printCurrentRow

private void printCurrentRow(java.sql.ResultSet rs)
                      throws java.sql.SQLException

Print the value of all columns in the current row of the specified result set, if debugging is enabled.

Throws:

java.sql.SQLException

wait_for_max_allocated

private void wait_for_max_allocated(java.lang.String test_name,
                                    int alloc_wait_count)
                             throws java.sql.SQLException

wait for background thread to convert allocated pages to free pages

Wait until the total number of allocated pages is <= alloc_wait_count. The expectation is that the test has performed some deletes and committed allowing the background task converted empty allocated pages with only deleted rows into free pages. On an machine with some idle processors only a short wait should be necessary. But on machines with lots of load, possibly other tests running just sleeping does not guarantee background thread an immediate chance to run. Without this extra wait some nightly's were seeing failures, see DERBY-1913.

Throws:

java.sql.SQLException

testList

public void testList()
              throws java.sql.SQLException

Throws:

java.sql.SQLException