Sai Pullabhotla wrote:
Hello,
Hello and thank you for reporting this issue.
Our application using Derby 10.4 (in embedded mode) has a background process
that runs the SYSCS_UTIL.SYSCS_COMPRESS_TABLE procedure periodically. We
have been reported the following error while this procedure is being
executed and a SELECT statement came in at the same time:
com.linoma.dpa.dao.DAOException: The conglomerate (71,409) requested
does
not exist.
Mike just fixed a corruption issue related to inplace
compress,https://issues.apache.org/jira/browse/DERBY-4239 but my
understanding is that it should not be an issue with offline compress
and also I would expect your database to be unbootable even after you
completely shutdown your application and Derby. Can you
1) Post the full nested stack trace from the derby.log.
2) Run a consistency check on your database.
http://wiki.apache.org/db-derby/DatabaseConsistencyCheck
4) Tell us the isolation level of your select statement.
3) Modify the reproduction attached to DERBY-4239
https://issues.apache.org/jira/secure/attachment/12408948/reproBackgroundCheckpoint.zip
to use SYCS_UTIL.SYSCS_COMPRESS_TABLE and see if you can reproduce your
issue. You might need to modify it to add in a select.
Thanks
Kathey
