[ https://issues.apache.org/jira/browse/DERBY-4075?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12681096#action_12681096
]
Myrna van Lunteren commented on DERBY-4075:
-------------------------------------------
I noticed that my 10.4 run was with insane jars, and my 10.5 run with sane jars.
Also, I could not see in the code that the backup happens once a day; it's more like every
2 minutes. Because of the lack of derby.properties the other calls did not get reported (in
my 10.4/insane jars run nothing at all showed in derby.log). So, my earlier assumption that
the backup was only happening once a day is wrong; the note in the Readme.txt is stale. The
fact that the problem occurred after about a day is a coincidence.
Code inspection suggested a couple of ways to force this more often;
- cause more thread.interrupts of the refresh thread
- sleep less
Also interesting experiments (especially if one of the above mechanisms can make it happen
more easily): To see if the problem reproduces
- on another windows machine
- with 10.4 and insane jars
- without compress
- without backup altogether (but with some other select that would check all tables)
> ERROR XSDBB: Unknown page format at page Page(613,Container(0, 1024)) when running MailJdbc
(Embedded) system tests
> -------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-4075
> URL: https://issues.apache.org/jira/browse/DERBY-4075
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.5.0.0
> Environment: windows 2000 professional, ibm 1.6 (sr2), revision 10.5: 745360
> Reporter: Myrna van Lunteren
> Priority: Blocker
> Fix For: 10.5.0.0
>
> Attachments: Activity.out, d4075_debugchange.diff, derbylog.zip, performance.out
>
>
> I started the org.apache.derbyTesting.system.mailJdbc Embedded test and after about 1
day it ran into an apparently corrupted database.
> 2009-02-19 14:02:44.221 GMT Thread[Refresh Thread,5,main] (XID = 349909), (SESSIONID
= 1), (DATABASE = mailsdb), (DRDAID = null), Failed Statement is: insert into REFRESH.INBOX(from_name,to_name,date,Message,attach_id,size_problem)
values (?,?,?,?,?,?) with 6 parameters begin parameter #1: ABCE :end parameter begin parameter
#2: WXYY :end parameter begin parameter #3: 2009-02-19 06:02:43.705 :end parameter begin parameter
#4: CLOB(org.apache.derby.iapi.types.ReaderToUTF8Stream@41ba41ba) :end parameter begin parameter
#5: 0 :end parameter begin parameter #6: This column is used only to by pass the space problem.
If the problem still exists, then we are going to have a serious issue here.*****************************************************************************************************
:end parameter
> ERROR XSDBB: Unknown page format at page Page(613,Container(0, 1024)), page dump follows:
Hex dump:
> The error up to that point appear to me no different from other errors that this test
is expected to produce (40001, 23505, 4XL01) except that the very first error is a grant error.
> I think we can't have a release until this corruption is explained away or fixed.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.