You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <de...@db.apache.org> on 2006/01/12 21:45:20 UTC
[jira] Created: (DERBY-810) intermittent diff for
store/RecoveryAfterBackup.java test
intermittent diff for store/RecoveryAfterBackup.java test
---------------------------------------------------------
Key: DERBY-810
URL: http://issues.apache.org/jira/browse/DERBY-810
Project: Derby
Type: Test
Components: Store
Versions: 10.2.0.0
Environment: Sun jdk 1.5
Reporter: Kathey Marsden
Fix For: 10.2.0.0
I saw this diff for test running at 2006-01-11 00:45:23 PST. The test seemed to run fine the next night.It would appear that this is some sort of intermittent test output problem. The test was just checked in on 2006-01-09.
store/RecoveryAfterBackup.java. on jdk15
*** Start: RecoveryAfterBackup jdk1.5.0_02 storeall:storerecovery 2006-01-11 00:45:23 ***
4 del
< SQL Exception: Derby system shutdown.
5 del
< Starting restore with roll-forward recovery..
5a4
> SQL Exception: Derby system shutdown.Starting restore with roll-forward recovery..
Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-810) intermittent diff for
store/RecoveryAfterBackup.java test
Posted by "David Van Couvering (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-810?page=comments#action_12363025 ]
David Van Couvering commented on DERBY-810:
-------------------------------------------
I'd also like to suggest that in the code you use a SQLState constant rather than a hardcoded string, it would make it a little more reliable in case SQL States are modified in the future... (doubtful, but possible, I just saw a change that did that).
> intermittent diff for store/RecoveryAfterBackup.java test
> ---------------------------------------------------------
>
> Key: DERBY-810
> URL: http://issues.apache.org/jira/browse/DERBY-810
> Project: Derby
> Type: Test
> Components: Store
> Versions: 10.2.0.0
> Environment: Sun jdk 1.5
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Fix For: 10.2.0.0
> Attachments: derby-810.diff, derby-810.stat
>
> I saw this diff for test running at 2006-01-11 00:45:23 PST. The test seemed to run fine the next night.It would appear that this is some sort of intermittent test output problem. The test was just checked in on 2006-01-09.
> store/RecoveryAfterBackup.java. on jdk15
> *** Start: RecoveryAfterBackup jdk1.5.0_02 storeall:storerecovery 2006-01-11 00:45:23 ***
> 4 del
> < SQL Exception: Derby system shutdown.
> 5 del
> < Starting restore with roll-forward recovery..
> 5a4
> > SQL Exception: Derby system shutdown.Starting restore with roll-forward recovery..
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Assigned: (DERBY-810) intermittent diff for
store/RecoveryAfterBackup.java test
Posted by "Øystein Grøvlen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-810?page=all ]
Øystein Grøvlen reassigned DERBY-810:
-------------------------------------
Assign To: Øystein Grøvlen
> intermittent diff for store/RecoveryAfterBackup.java test
> ---------------------------------------------------------
>
> Key: DERBY-810
> URL: http://issues.apache.org/jira/browse/DERBY-810
> Project: Derby
> Type: Test
> Components: Store
> Versions: 10.2.0.0
> Environment: Sun jdk 1.5
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Fix For: 10.2.0.0
>
> I saw this diff for test running at 2006-01-11 00:45:23 PST. The test seemed to run fine the next night.It would appear that this is some sort of intermittent test output problem. The test was just checked in on 2006-01-09.
> store/RecoveryAfterBackup.java. on jdk15
> *** Start: RecoveryAfterBackup jdk1.5.0_02 storeall:storerecovery 2006-01-11 00:45:23 ***
> 4 del
> < SQL Exception: Derby system shutdown.
> 5 del
> < Starting restore with roll-forward recovery..
> 5a4
> > SQL Exception: Derby system shutdown.Starting restore with roll-forward recovery..
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Resolved: (DERBY-810) intermittent diff for
store/RecoveryAfterBackup.java test
Posted by "David Van Couvering (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-810?page=all ]
David Van Couvering resolved DERBY-810:
---------------------------------------
Resolution: Fixed
Committed revision 370195
> intermittent diff for store/RecoveryAfterBackup.java test
> ---------------------------------------------------------
>
> Key: DERBY-810
> URL: http://issues.apache.org/jira/browse/DERBY-810
> Project: Derby
> Type: Test
> Components: Store
> Versions: 10.2.0.0
> Environment: Sun jdk 1.5
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Fix For: 10.2.0.0
> Attachments: derby-810.diff, derby-810.stat
>
> I saw this diff for test running at 2006-01-11 00:45:23 PST. The test seemed to run fine the next night.It would appear that this is some sort of intermittent test output problem. The test was just checked in on 2006-01-09.
> store/RecoveryAfterBackup.java. on jdk15
> *** Start: RecoveryAfterBackup jdk1.5.0_02 storeall:storerecovery 2006-01-11 00:45:23 ***
> 4 del
> < SQL Exception: Derby system shutdown.
> 5 del
> < Starting restore with roll-forward recovery..
> 5a4
> > SQL Exception: Derby system shutdown.Starting restore with roll-forward recovery..
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-810) intermittent diff for
store/RecoveryAfterBackup.java test
Posted by "David Van Couvering (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-810?page=comments#action_12363030 ]
David Van Couvering commented on DERBY-810:
-------------------------------------------
Yes, what you say makes sense, thanks, Dan.
> intermittent diff for store/RecoveryAfterBackup.java test
> ---------------------------------------------------------
>
> Key: DERBY-810
> URL: http://issues.apache.org/jira/browse/DERBY-810
> Project: Derby
> Type: Test
> Components: Store
> Versions: 10.2.0.0
> Environment: Sun jdk 1.5
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Fix For: 10.2.0.0
> Attachments: derby-810.diff, derby-810.stat
>
> I saw this diff for test running at 2006-01-11 00:45:23 PST. The test seemed to run fine the next night.It would appear that this is some sort of intermittent test output problem. The test was just checked in on 2006-01-09.
> store/RecoveryAfterBackup.java. on jdk15
> *** Start: RecoveryAfterBackup jdk1.5.0_02 storeall:storerecovery 2006-01-11 00:45:23 ***
> 4 del
> < SQL Exception: Derby system shutdown.
> 5 del
> < Starting restore with roll-forward recovery..
> 5a4
> > SQL Exception: Derby system shutdown.Starting restore with roll-forward recovery..
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-810) intermittent diff for
store/RecoveryAfterBackup.java test
Posted by "Øystein Grøvlen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-810?page=comments#action_12362855 ]
Øystein Grøvlen commented on DERBY-810:
---------------------------------------
Thanks, Suresh for the analysis. I think you are right that the reason for the failure is that output to stdout and stderr gets mixed. I agree that it is better to check for the shutdown SQLState instead of relying on the output of printStackTrace. I will create a patch to change this.
> intermittent diff for store/RecoveryAfterBackup.java test
> ---------------------------------------------------------
>
> Key: DERBY-810
> URL: http://issues.apache.org/jira/browse/DERBY-810
> Project: Derby
> Type: Test
> Components: Store
> Versions: 10.2.0.0
> Environment: Sun jdk 1.5
> Reporter: Kathey Marsden
> Fix For: 10.2.0.0
>
> I saw this diff for test running at 2006-01-11 00:45:23 PST. The test seemed to run fine the next night.It would appear that this is some sort of intermittent test output problem. The test was just checked in on 2006-01-09.
> store/RecoveryAfterBackup.java. on jdk15
> *** Start: RecoveryAfterBackup jdk1.5.0_02 storeall:storerecovery 2006-01-11 00:45:23 ***
> 4 del
> < SQL Exception: Derby system shutdown.
> 5 del
> < Starting restore with roll-forward recovery..
> 5a4
> > SQL Exception: Derby system shutdown.Starting restore with roll-forward recovery..
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Re: [jira] Updated: (DERBY-810) intermittent diff for store/RecoveryAfterBackup.java
test
Posted by Mike Matrigali <mi...@sbcglobal.net>.
oops, nevermind - i was behind on the list. I see this has already
been taken care of.
Mike Matrigali wrote:
> I am looking at reviewing/committing this. If anyone else is already
> looking or wants me to wait on the commit let me know.
>
> Øystein Grøvlen (JIRA) wrote:
>
>> [ http://issues.apache.org/jira/browse/DERBY-810?page=all ]
>>
>> Øystein Grøvlen updated DERBY-810:
>> ----------------------------------
>>
>> Attachment: derby-810.diff
>> derby-810.stat
>>
>> The attach patch should solve this problem. I no longer print the
>> stack trace if the normal shutdown exception is received.
>>
>>
>>> intermittent diff for store/RecoveryAfterBackup.java test
>>> ---------------------------------------------------------
>>>
>>> Key: DERBY-810
>>> URL: http://issues.apache.org/jira/browse/DERBY-810
>>> Project: Derby
>>> Type: Test
>>> Components: Store
>>> Versions: 10.2.0.0
>>> Environment: Sun jdk 1.5
>>> Reporter: Kathey Marsden
>>> Assignee: Øystein Grøvlen
>>> Fix For: 10.2.0.0
>>> Attachments: derby-810.diff, derby-810.stat
>>>
>>> I saw this diff for test running at 2006-01-11 00:45:23 PST. The
>>> test seemed to run fine the next night.It would appear that this is
>>> some sort of intermittent test output problem. The test was just
>>> checked in on 2006-01-09.
>>> store/RecoveryAfterBackup.java. on jdk15
>>> *** Start: RecoveryAfterBackup jdk1.5.0_02 storeall:storerecovery
>>> 2006-01-11 00:45:23 ***
>>> 4 del
>>> < SQL Exception: Derby system shutdown.
>>> 5 del
>>> < Starting restore with roll-forward recovery..
>>> 5a4
>>>
>>>> SQL Exception: Derby system shutdown.Starting restore with
>>>> roll-forward recovery..
>>>
>>>
>>> Test Failed.
>>
>>
>>
>
>
>
Re: [jira] Updated: (DERBY-810) intermittent diff for store/RecoveryAfterBackup.java
test
Posted by Suresh Thalamati <su...@gmail.com>.
I think David already committed this patch.
Mike Matrigali wrote:
> I am looking at reviewing/committing this. If anyone else is already
> looking or wants me to wait on the commit let me know.
>
> Øystein Grøvlen (JIRA) wrote:
>
>> [ http://issues.apache.org/jira/browse/DERBY-810?page=all ]
>>
>> Øystein Grøvlen updated DERBY-810:
>> ----------------------------------
>>
>> Attachment: derby-810.diff
>> derby-810.stat
>>
>> The attach patch should solve this problem. I no longer print the
>> stack trace if the normal shutdown exception is received.
>>
>>
>>> intermittent diff for store/RecoveryAfterBackup.java test
>>> ---------------------------------------------------------
>>>
>>> Key: DERBY-810
>>> URL: http://issues.apache.org/jira/browse/DERBY-810
>>> Project: Derby
>>> Type: Test
>>> Components: Store
>>> Versions: 10.2.0.0
>>> Environment: Sun jdk 1.5
>>> Reporter: Kathey Marsden
>>> Assignee: Øystein Grøvlen
>>> Fix For: 10.2.0.0
>>> Attachments: derby-810.diff, derby-810.stat
>>>
>>> I saw this diff for test running at 2006-01-11 00:45:23 PST. The
>>> test seemed to run fine the next night.It would appear that this is
>>> some sort of intermittent test output problem. The test was just
>>> checked in on 2006-01-09.
>>> store/RecoveryAfterBackup.java. on jdk15
>>> *** Start: RecoveryAfterBackup jdk1.5.0_02 storeall:storerecovery
>>> 2006-01-11 00:45:23 ***
>>> 4 del
>>> < SQL Exception: Derby system shutdown.
>>> 5 del
>>> < Starting restore with roll-forward recovery..
>>> 5a4
>>>
>>>> SQL Exception: Derby system shutdown.Starting restore with
>>>> roll-forward recovery..
>>>
>>>
>>> Test Failed.
>>
>>
>>
>
>
Re: [jira] Updated: (DERBY-810) intermittent diff for store/RecoveryAfterBackup.java
test
Posted by Mike Matrigali <mi...@sbcglobal.net>.
I am looking at reviewing/committing this. If anyone else is already
looking or wants me to wait on the commit let me know.
Øystein Grøvlen (JIRA) wrote:
> [ http://issues.apache.org/jira/browse/DERBY-810?page=all ]
>
> Øystein Grøvlen updated DERBY-810:
> ----------------------------------
>
> Attachment: derby-810.diff
> derby-810.stat
>
> The attach patch should solve this problem. I no longer print the stack trace if the normal shutdown exception is received.
>
>
>>intermittent diff for store/RecoveryAfterBackup.java test
>>---------------------------------------------------------
>>
>> Key: DERBY-810
>> URL: http://issues.apache.org/jira/browse/DERBY-810
>> Project: Derby
>> Type: Test
>> Components: Store
>> Versions: 10.2.0.0
>> Environment: Sun jdk 1.5
>> Reporter: Kathey Marsden
>> Assignee: Øystein Grøvlen
>> Fix For: 10.2.0.0
>> Attachments: derby-810.diff, derby-810.stat
>>
>>I saw this diff for test running at 2006-01-11 00:45:23 PST. The test seemed to run fine the next night.It would appear that this is some sort of intermittent test output problem. The test was just checked in on 2006-01-09.
>>store/RecoveryAfterBackup.java. on jdk15
>>*** Start: RecoveryAfterBackup jdk1.5.0_02 storeall:storerecovery 2006-01-11 00:45:23 ***
>>4 del
>>< SQL Exception: Derby system shutdown.
>>5 del
>>< Starting restore with roll-forward recovery..
>>5a4
>>
>>>SQL Exception: Derby system shutdown.Starting restore with roll-forward recovery..
>>
>>Test Failed.
>
>
[jira] Updated: (DERBY-810) intermittent diff for
store/RecoveryAfterBackup.java test
Posted by "Øystein Grøvlen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-810?page=all ]
Øystein Grøvlen updated DERBY-810:
----------------------------------
Attachment: derby-810.diff
derby-810.stat
The attach patch should solve this problem. I no longer print the stack trace if the normal shutdown exception is received.
> intermittent diff for store/RecoveryAfterBackup.java test
> ---------------------------------------------------------
>
> Key: DERBY-810
> URL: http://issues.apache.org/jira/browse/DERBY-810
> Project: Derby
> Type: Test
> Components: Store
> Versions: 10.2.0.0
> Environment: Sun jdk 1.5
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Fix For: 10.2.0.0
> Attachments: derby-810.diff, derby-810.stat
>
> I saw this diff for test running at 2006-01-11 00:45:23 PST. The test seemed to run fine the next night.It would appear that this is some sort of intermittent test output problem. The test was just checked in on 2006-01-09.
> store/RecoveryAfterBackup.java. on jdk15
> *** Start: RecoveryAfterBackup jdk1.5.0_02 storeall:storerecovery 2006-01-11 00:45:23 ***
> 4 del
> < SQL Exception: Derby system shutdown.
> 5 del
> < Starting restore with roll-forward recovery..
> 5a4
> > SQL Exception: Derby system shutdown.Starting restore with roll-forward recovery..
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-810) intermittent diff for
store/RecoveryAfterBackup.java test
Posted by "David Van Couvering (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-810?page=comments#action_12363026 ]
David Van Couvering commented on DERBY-810:
-------------------------------------------
I'd also like to suggest that in the code you use a SQLState constant rather than a hardcoded string, it would make it a little more reliable in case SQL States are modified in the future... (doubtful, but possible, I just saw a change that did that).
> intermittent diff for store/RecoveryAfterBackup.java test
> ---------------------------------------------------------
>
> Key: DERBY-810
> URL: http://issues.apache.org/jira/browse/DERBY-810
> Project: Derby
> Type: Test
> Components: Store
> Versions: 10.2.0.0
> Environment: Sun jdk 1.5
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Fix For: 10.2.0.0
> Attachments: derby-810.diff, derby-810.stat
>
> I saw this diff for test running at 2006-01-11 00:45:23 PST. The test seemed to run fine the next night.It would appear that this is some sort of intermittent test output problem. The test was just checked in on 2006-01-09.
> store/RecoveryAfterBackup.java. on jdk15
> *** Start: RecoveryAfterBackup jdk1.5.0_02 storeall:storerecovery 2006-01-11 00:45:23 ***
> 4 del
> < SQL Exception: Derby system shutdown.
> 5 del
> < Starting restore with roll-forward recovery..
> 5a4
> > SQL Exception: Derby system shutdown.Starting restore with roll-forward recovery..
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-810) intermittent diff for
store/RecoveryAfterBackup.java test
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-810?page=comments#action_12363029 ]
Daniel John Debrunner commented on DERBY-810:
---------------------------------------------
The SQLState constants are not part of the public api, tests should not be using them. In fact it's better if the test does have its own version of the constant as then a incorrect change in the code would be caugth be the test. Changing the SQL state for shutdown is a change in api. and could break existing applications.
> intermittent diff for store/RecoveryAfterBackup.java test
> ---------------------------------------------------------
>
> Key: DERBY-810
> URL: http://issues.apache.org/jira/browse/DERBY-810
> Project: Derby
> Type: Test
> Components: Store
> Versions: 10.2.0.0
> Environment: Sun jdk 1.5
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Fix For: 10.2.0.0
> Attachments: derby-810.diff, derby-810.stat
>
> I saw this diff for test running at 2006-01-11 00:45:23 PST. The test seemed to run fine the next night.It would appear that this is some sort of intermittent test output problem. The test was just checked in on 2006-01-09.
> store/RecoveryAfterBackup.java. on jdk15
> *** Start: RecoveryAfterBackup jdk1.5.0_02 storeall:storerecovery 2006-01-11 00:45:23 ***
> 4 del
> < SQL Exception: Derby system shutdown.
> 5 del
> < Starting restore with roll-forward recovery..
> 5a4
> > SQL Exception: Derby system shutdown.Starting restore with roll-forward recovery..
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Re: [jira] Commented: (DERBY-810) intermittent diff for store/RecoveryAfterBackup.java
test
Posted by Mike Matrigali <mi...@sbcglobal.net>.
As pointed out this test must be run as part of a suite. Unlike the
majority of derby tests each subsequent test is dependent on what
has come before in the SAME database. This is because each test does
stuff like setup some uncommitted transaction and crash the database,
so that the subsequent test can do test redo recovery of what was set
up.
I am not sure why running each separately in order does not work, but
I would guess it has to do with some properties that are special to
running as a suite which you don't pick up running each test separately.
Øystein Grøvlen wrote:
>>>>>>"DVC(" == David Van Couvering (JIRA) <de...@db.apache.org> writes:
>
>
> DVC(> [ http://issues.apache.org/jira/browse/DERBY-810?page=comments#action_12363024 ]
> DVC(> David Van Couvering commented on DERBY-810:
> DVC(> -------------------------------------------
>
> DVC(> I applied this patch and it built fine, but when I try to
> DVC(> run storemats I get this error. I tried running it as a
> DVC(> separate test and got the same error. Is there something
> DVC(> I'm missing?
>
> This test is not part of storemats so I cannot understand how you can
> get this error when running storemats. To run this test you must run
> either storerecovery, storeall, or derbyall. None of the tests in the
> storerecovery test can be run as separate tests. They depend on being
> run in sequence, and for some reason that I have not understand,
> running them in sequence manually does not work either.
>
> The test works fine for me when I run storerecovery or storeall.
>
> DVC(> And who thought of this name for a database - ick! :)
>
> http://www.wombania.com/wombats/hairy-nosed-wombat.htm
>
Re: [jira] Commented: (DERBY-810) intermittent diff for
store/RecoveryAfterBackup.java test
Posted by "David W. Van Couvering" <Da...@Sun.COM>.
�ystein Gr�vlen wrote:
>>>>>>"DVC(" == David Van Couvering (JIRA) <de...@db.apache.org> writes:
>
>
> DVC(> [ http://issues.apache.org/jira/browse/DERBY-810?page=comments#action_12363024 ]
> DVC(> David Van Couvering commented on DERBY-810:
> DVC(> -------------------------------------------
>
> DVC(> I applied this patch and it built fine, but when I try to
> DVC(> run storemats I get this error. I tried running it as a
> DVC(> separate test and got the same error. Is there something
> DVC(> I'm missing?
>
> This test is not part of storemats so I cannot understand how you can
> get this error when running storemats.
Perhaps I was looking at the wrong diffs. I'll run your test using
storerecovery, and if all looks good I'll check it in.
To run this test you must run
> either storerecovery, storeall, or derbyall. None of the tests in the
> storerecovery test can be run as separate tests. They depend on being
> run in sequence, and for some reason that I have not understand,
> running them in sequence manually does not work either.
>
> The test works fine for me when I run storerecovery or storeall.
>
> DVC(> And who thought of this name for a database - ick! :)
>
> http://www.wombania.com/wombats/hairy-nosed-wombat.htm
>
Well, the animal is a lot cuter than its name! :)
David
Re: [jira] Commented: (DERBY-810) intermittent diff for
store/RecoveryAfterBackup.java test
Posted by Øystein Grøvlen <Oy...@Sun.COM>.
>>>>> "DVC(" == David Van Couvering (JIRA) <de...@db.apache.org> writes:
DVC(> [ http://issues.apache.org/jira/browse/DERBY-810?page=comments#action_12363024 ]
DVC(> David Van Couvering commented on DERBY-810:
DVC(> -------------------------------------------
DVC(> I applied this patch and it built fine, but when I try to
DVC(> run storemats I get this error. I tried running it as a
DVC(> separate test and got the same error. Is there something
DVC(> I'm missing?
This test is not part of storemats so I cannot understand how you can
get this error when running storemats. To run this test you must run
either storerecovery, storeall, or derbyall. None of the tests in the
storerecovery test can be run as separate tests. They depend on being
run in sequence, and for some reason that I have not understand,
running them in sequence manually does not work either.
The test works fine for me when I run storerecovery or storeall.
DVC(> And who thought of this name for a database - ick! :)
http://www.wombania.com/wombats/hairy-nosed-wombat.htm
--
Øystein
[jira] Commented: (DERBY-810) intermittent diff for
store/RecoveryAfterBackup.java test
Posted by "David Van Couvering (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-810?page=comments#action_12363024 ]
David Van Couvering commented on DERBY-810:
-------------------------------------------
I applied this patch and it built fine, but when I try to run storemats I get this error. I tried running it as a separate test and got the same error. Is there something I'm missing? And who thought of this name for a database - ick! :)
Framework: embedded
*** Start: RecoveryAfterBackup jdk1.4.2_07 2006-01-17 10:29:22 ***
1 del
< Count: 2 Sum: 1
2 del
< Inserting records ...
3 del
< Shutting down database ...
4 del
< Database shutdown completed
5 del
< Starting restore with roll-forward recovery..
6 del
< Verifying database ...
7 del
< Count: 256 Sum: 32640
7 add
> ERROR XJ004: Database 'hairynosedwombat' not found.
> SQL Exception: Database 'hairynosedwombat' not found.
Test Failed.
*** End: RecoveryAfterBackup jdk1.4.2_07 2006-01-17 10:29:23 ***
> intermittent diff for store/RecoveryAfterBackup.java test
> ---------------------------------------------------------
>
> Key: DERBY-810
> URL: http://issues.apache.org/jira/browse/DERBY-810
> Project: Derby
> Type: Test
> Components: Store
> Versions: 10.2.0.0
> Environment: Sun jdk 1.5
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Fix For: 10.2.0.0
> Attachments: derby-810.diff, derby-810.stat
>
> I saw this diff for test running at 2006-01-11 00:45:23 PST. The test seemed to run fine the next night.It would appear that this is some sort of intermittent test output problem. The test was just checked in on 2006-01-09.
> store/RecoveryAfterBackup.java. on jdk15
> *** Start: RecoveryAfterBackup jdk1.5.0_02 storeall:storerecovery 2006-01-11 00:45:23 ***
> 4 del
> < SQL Exception: Derby system shutdown.
> 5 del
> < Starting restore with roll-forward recovery..
> 5a4
> > SQL Exception: Derby system shutdown.Starting restore with roll-forward recovery..
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Closed: (DERBY-810) intermittent diff for
store/RecoveryAfterBackup.java test
Posted by "Kathey Marsden (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-810?page=all ]
Kathey Marsden closed DERBY-810:
--------------------------------
> intermittent diff for store/RecoveryAfterBackup.java test
> ---------------------------------------------------------
>
> Key: DERBY-810
> URL: http://issues.apache.org/jira/browse/DERBY-810
> Project: Derby
> Type: Test
> Components: Store
> Versions: 10.2.0.0
> Environment: Sun jdk 1.5
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Fix For: 10.2.0.0
> Attachments: derby-810.diff, derby-810.stat
>
> I saw this diff for test running at 2006-01-11 00:45:23 PST. The test seemed to run fine the next night.It would appear that this is some sort of intermittent test output problem. The test was just checked in on 2006-01-09.
> store/RecoveryAfterBackup.java. on jdk15
> *** Start: RecoveryAfterBackup jdk1.5.0_02 storeall:storerecovery 2006-01-11 00:45:23 ***
> 4 del
> < SQL Exception: Derby system shutdown.
> 5 del
> < Starting restore with roll-forward recovery..
> 5a4
> > SQL Exception: Derby system shutdown.Starting restore with roll-forward recovery..
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-810) intermittent diff for
store/RecoveryAfterBackup.java test
Posted by "David Van Couvering (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-810?page=all ]
David Van Couvering updated DERBY-810:
--------------------------------------
Comment: was deleted
> intermittent diff for store/RecoveryAfterBackup.java test
> ---------------------------------------------------------
>
> Key: DERBY-810
> URL: http://issues.apache.org/jira/browse/DERBY-810
> Project: Derby
> Type: Test
> Components: Store
> Versions: 10.2.0.0
> Environment: Sun jdk 1.5
> Reporter: Kathey Marsden
> Assignee: Øystein Grøvlen
> Fix For: 10.2.0.0
> Attachments: derby-810.diff, derby-810.stat
>
> I saw this diff for test running at 2006-01-11 00:45:23 PST. The test seemed to run fine the next night.It would appear that this is some sort of intermittent test output problem. The test was just checked in on 2006-01-09.
> store/RecoveryAfterBackup.java. on jdk15
> *** Start: RecoveryAfterBackup jdk1.5.0_02 storeall:storerecovery 2006-01-11 00:45:23 ***
> 4 del
> < SQL Exception: Derby system shutdown.
> 5 del
> < Starting restore with roll-forward recovery..
> 5a4
> > SQL Exception: Derby system shutdown.Starting restore with roll-forward recovery..
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[PATCH] Re: [jira] Commented: (DERBY-810) intermittent diff for
store/RecoveryAfterBackup.java test
Posted by Øystein Grøvlen <Oy...@Sun.COM>.
>>>>> "ST(" == Suresh Thalamati (JIRA) <de...@db.apache.org> writes:
ST(> [ http://issues.apache.org/jira/browse/DERBY-810?page=comments#action_12362682 ]
ST(> Suresh Thalamati commented on DERBY-810:
ST(> ----------------------------------------
ST(> Difference in the output seems to be a new line. My guess is
ST(> System.out and System.err (output of the printStackTrace() )
ST(> output to the file are getting intermingled.
I have attached a patch to JIRA that should solve this problem.
Please, review and commit it.
--
Øystein
[jira] Commented: (DERBY-810) intermittent diff for
store/RecoveryAfterBackup.java test
Posted by "Suresh Thalamati (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-810?page=comments#action_12362682 ]
Suresh Thalamati commented on DERBY-810:
----------------------------------------
Difference in the output seems to be a new line. My guess is System.out and System.err (output of the printStackTrace() ) output to the file are getting intermingled.
Related code in RecoveryAfterBackup.java:
// Shut down database
Properties shutdownAttrs = new Properties();
shutdownAttrs.setProperty("shutdownDatabase", "shutdown");
System.out.println("Shutting down database ...");
try {
DataSource ds = TestUtil.getDataSource(shutdownAttrs);
ds.getConnection();
} catch (Throwable ith) {
ith.printStackTrace();
}
// Start up with rollforward-recovery
System.out.println("Starting restore with roll-forward recovery..");
Oyestin: I did not notice this when I reviewed the patch for Derby-298. Any particular reason for printing stack trace on shutdown ? Normally I check for the shutdown SQLState and not print the stack trace if the shutdown is successful. I think to avoid timing issues with tests , it is better to print the stack traces to System.out .
output in the temp file:
Count: 2 Sum: 1
Inserting records ...
Shutting down database ...
SQL Exception: Derby system shutdown.Starting restore with roll-forward recovery..
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:80)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:97)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:161)
at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:182)
at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(EmbeddedDataSource.java:478)
at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(EmbeddedDataSource.java:422)
at org.apache.derbyTesting.functionTests.tests.store.RecoveryAfterBackup.main(RecoveryAfterBackup.java:85)
Verifying database ...
Count: 256 Sum: 32640
> intermittent diff for store/RecoveryAfterBackup.java test
> ---------------------------------------------------------
>
> Key: DERBY-810
> URL: http://issues.apache.org/jira/browse/DERBY-810
> Project: Derby
> Type: Test
> Components: Store
> Versions: 10.2.0.0
> Environment: Sun jdk 1.5
> Reporter: Kathey Marsden
> Fix For: 10.2.0.0
>
> I saw this diff for test running at 2006-01-11 00:45:23 PST. The test seemed to run fine the next night.It would appear that this is some sort of intermittent test output problem. The test was just checked in on 2006-01-09.
> store/RecoveryAfterBackup.java. on jdk15
> *** Start: RecoveryAfterBackup jdk1.5.0_02 storeall:storerecovery 2006-01-11 00:45:23 ***
> 4 del
> < SQL Exception: Derby system shutdown.
> 5 del
> < Starting restore with roll-forward recovery..
> 5a4
> > SQL Exception: Derby system shutdown.Starting restore with roll-forward recovery..
> Test Failed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira