Hi

I've just experienced a problem with a JDBC (triggerless) driver in that
it keeps shutting itself down. I've done a trace (level 5) on it and have
posted it below so if anyone can let me know the reason that would be
great.
In order to get the driver back up and running quickly I deleted the
driver state files and started it and its now working fine. This means
that a full re-sync has been done but also I've lost any records that
dropped out during the period it was down (approximately 2 hrs).
I have copies of the old state files (.lg and .db) and once the driver was
working OK I shut it down and took copies of the new driver state files,
is there an easy way to obtain the records that dropped out?

Thanks in advance
Mike


DSTrace of driver shutting itself down:
(note that there were thousands more of the rows first type of rows but i
didn't paste them here)
09:23:56 5D3B0BB0 Drvrs: QLS PT: {[99982663], 3096192392}
09:23:56 5D3B0BB0 Drvrs: QLS PT: {[99982665], 4221133856}
09:23:56 5D3B0BB0 Drvrs: QLS PT: {[99982666], 1392165803}
09:23:56 5D3B0BB0 Drvrs: QLS PT: {[99982690], 3763572006}
09:23:56 5D3B0BB0 Drvrs: QLS PT: {[99982734], 32779159}
09:23:56 5D3B0BB0 Drvrs: QLS PT: {[99982755], 973070934}
09:23:56 5D3B0BB0 Drvrs: QLS PT: {[99982765], 1092886846}
09:23:56 5D3B0BB0 Drvrs: QLS PT: {[99984182], 190188495}
09:23:56 5D3B0BB0 Drvrs: QLS PT: END DIRXML_VIEW_USER$1 ------------
09:23:56 5D3B0BB0 Drvrs: QLS PT: BEGIN Instantiate prepared statement.
09:23:56 5D3B0BB0 Drvrs: QLS PT: Allocating statement from connection
c9352d.
09:23:56 5D3B0BB0 Drvrs: QLS PT: Allocated statement 1c225f7.
09:23:56 5D3B0BB0 Drvrs: QLS PT: END Instantiate prepared statement.
09:23:56 5D3B0BB0 Drvrs: QLS PT: SELECT A.PK_IDU, A.MMU_ID8, A.TITLE,
A.FORENAME, A.SURNAME, A.INITIALS, A.DOB, A.ENROL_STATUS, A.COURSE_CODE,
A.STATUS, A.DEPT_CODE, A.DEPT_NAME, A.COURSE_END_DATE FROM
DIRXML_VIEW_USER A ORDER BY A.PK_IDU ASC
09:24:27 5D3B0BB0 Drvrs: QLS PT: Allocated result set 14a8022 from
statement 1c225f7.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Primary key contains at least one column
with a string data type. Using string implementation.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Current database object: [00014034]
09:24:27 5D3B0BB0 Drvrs: QLS PT: Current database object: [00024003]
09:24:27 5D3B0BB0 Drvrs: QLS PT: Read 1 rows for object [00014034]
09:24:27 5D3B0BB0 Drvrs: QLS PT: Object [00014034] has NOT changed.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Move object {[00014034], 537711715}
09:24:27 5D3B0BB0 Drvrs: QLS PT: Closed result set 14a8022.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Number of statements allocated on
connection 'dedicated1': 1.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Number of statements allocated on
connection 'dedicated0': 0.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Shutting down...
09:24:27 5D3B0BB0 Drvrs: QLS PT: Connection 'dedicated1' is open.
Closing...
09:24:27 5D3B0BB0 Drvrs: QLS PT: Connection implementation is open.
09:24:27 5D3B0BB0 Drvrs: QLS PT: BEGIN Close connection.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Closing open statements.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Closed statement 1c225f7.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Closed open statements.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Closed connection c9352d.
09:24:27 5D3B0BB0 Drvrs: QLS PT: END Close connection.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Connection is closed.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Connection 'dedicated0' is open.
Closing...
09:24:27 5D3B0BB0 Drvrs: QLS PT: Connection implementation is open.
09:24:27 5D3B0BB0 Drvrs: QLS PT: BEGIN Close connection.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Closing open statements.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Closed open statements.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Closed connection 177e4c1.
09:24:27 5D3B0BB0 Drvrs: QLS PT: END Close connection.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Connection is closed.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Closing file
'./jdbc_8b6cd1d0-ecd7-01db-8063-001185ead0b1'.
09:24:27 5D3B0BB0 Drvrs: QLS PT: File closed.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Acquired lock on file
'./jdbc_8b6cd1d0-ecd7-01db-8063-001185ead0b1_0'.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Closing file
'./jdbc_8b6cd1d0-ecd7-01db-8063-001185ead0b1_0'.
09:24:27 5D3B0BB0 Drvrs: QLS PT: File closed.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Released file lock.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Closing file
'./jdbc_8b6cd1d0-ecd7-01db-8063-001185ead0b1_1'.
09:24:27 5D3B0BB0 Drvrs: QLS PT: File closed.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Shut down.
09:24:27 5D3B0BB0 Drvrs: QLS PT: PublicationShim.start() returned:
09:24:27 5D3B0BB0 Drvrs: QLS PT:
(nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc")
(source)
(product build="20070104_0315" instance="QLS" version="2.1.5")DirXML
Driver for JDBC(/product)
(contact)Novell, Inc.(/contact)
(/source)
(output)
(status level="fatal" type="driver-general")
(description)An unexpected exception was thrown during a triggerless
publication polling interval.(/description)
(jdbc:exception jdbc:class="java.lang.IllegalStateException")
(jdbc:message)Error during underflow [1](/jdbc:message)
(jdbc:stack-trace)java.lang.IllegalStateException: Error during underflow
[1]
at jdbm.btree.BPage.remove(BPage.java:451)
at jdbm.btree.BTree.remove(BTree.java:313)
at com.novell.nds.dirxml.driver.jdbc.util.jdbm.JDBMTr ee.remove(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.state.State Mediator.moveToNext(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.state.State Mediator.modifyObject(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.state.State Mediator.stringImplementation(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.state.State Mediator.start(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.JDBCTriggerlessP ublicationShim.waitForEvents(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.pollImpl(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.pollLoop(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.start(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationP roxy.start(Unknown
Source)
at com.novell.nds.dirxml.engine.Publisher.run(Publish er.java:315)
at java.lang.Thread.run(Unknown Source)
(/jdbc:stack-trace)
09:24:27 5D3B0BB0 Drvrs: (/jdbc:exception)
(/status)
(/output)
(/nds)
09:24:27 5D3B0BB0 Drvrs: QLS PT: No input transformation policies.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Applying schema mapping policies to input.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Resolving association references.
09:24:27 5D3B0BB0 Drvrs: QLS PT:
DirXML Log Event -------------------
Driver: MMU-METAmmu-metaIDMDriverSet1QLS
Channel: Publisher
Status: Fatal
Message: (description)An unexpected exception was thrown during a
triggerless publication polling interval.(/description)
(jdbc:exception jdbc:class="java.lang.IllegalStateException"
xmlns:jdbc="urn:dirxml:jdbc")
(jdbc:message)Error during underflow [1](/jdbc:message)
(jdbc:stack-trace)java.lang.IllegalStateException: Error during underflow
[1]
at jdbm.btree.BPage.remove(BPage.java:451)
at jdbm.btree.BTree.remove(BTree.java:313)
at com.novell.nds.dirxml.driver.jdbc.util.jdbm.JDBMTr ee.remove(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.state.State Mediator.moveToNext(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.state.State Mediator.modifyObject(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.state.State Mediator.stringImplementation(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.state.State Mediator.start(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.JDBCTriggerlessP ublicationShim.waitForEvents(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.pollImpl(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.pollLoop(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.start(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationP roxy.start(Unknown
Source)
at com.novell.nds.dirxml.engine.Publisher.run(Publish er.java:315)
at java.lang.Thread.run(Unknown Source)
(/jdbc:stack-trace)
(/jdbc:exception)
09:24:27 5D3B0BB0 Drvrs: QLS PT:
DirXML Log Event -------------------
Driver: MMU-METAmmu-metaIDMDriverSet1QLS
Channel: Publisher
Status: Fatal
Message: Code(-9005) The driver returned a "fatal" status indicating that
the driver should be shut down. Detail from driver: (description)An
unexpected exception was thrown during a triggerless publication polling
interval.(/description)
(jdbc:exception jdbc:class="java.lang.IllegalStateException"
xmlns:jdbc="urn:dirxml:jdbc")
(jdbc:message)Error during underflow [1](/jdbc:message)
(jdbc:stack-trace)java.lang.IllegalStateException: Error during underflow
[1]
at jdbm.btree.BPage.remove(BPage.java:451)
at jdbm.btree.BTree.remove(BTree.java:313)
at com.novell.nds.dirxml.driver.jdbc.util.jdbm.JDBMTr ee.remove(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.state.State Mediator.moveToNext(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.state.State Mediator.modifyObject(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.state.State Mediator.stringImplementation(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.state.State Mediator.start(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.JDBCTriggerlessP ublicationShim.waitForEvents(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.pollImpl(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.pollLoop(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.start(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationP roxy.start(Unknown
Source)
at com.novell.nds.dirxml.engine.Publisher.run(Publish er.java:315)
at java.lang.Thread.run(Unknown Source)
(/jdbc:stack-trace)
(/jdbc:exception)
09:24:27 5D3B0BB0 Drvrs: (application)DirXML(/application)
(module)QLS(/module)
(object-dn)(/object-dn)
(component)Publisher(/component)
09:24:27 5D3B0BB0 Drvrs: QLS PT: Killing driver from publisher thread;
after PublicationShim.start().
09:24:27 5D3B0BB0 Drvrs: QLS PT: Requesting termination.
09:24:27 5D3B0BB0 Drvrs: QLS PT: Ending publisher thread.
09:24:27 5D1F0BB0 Drvrs: QLS ST: Leaving event loop.
28/09/07
09:24:27 5D1F0BB0 Drvrs: QLS ST: Shutting down DirXML driver
MMU-METAmmu-metaIDMDriverSet1QLS.
09:24:27 5D1F0BB0 Drvrs: QLS ST: DriverShim.shutdown() returned:
09:24:27 5D1F0BB0 Drvrs: QLS ST:
(nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc")
(source)
(product build="20070104_0315" instance="QLS" version="2.1.5")DirXML
Driver for JDBC(/product)
(contact)Novell, Inc.(/contact)
(/source)
(output)
(status level="success"/)
(/output)
(/nds)
09:24:27 5D1F0BB0 Drvrs: QLS ST: Waiting for Publisher thread to
terminate...
09:24:27 5D1F0BB0 Drvrs: QLS ST: Publisher thread terminated.
09:24:27 5D1F0BB0 Drvrs: QLS ST: Driver terminated.
09:24:27 5D1F0BB0 Drvrs: QLS ST: Transitioned from state 'Running' to
state 'Stopped'.