On 04/20/09 20:11, Kathey Marsden wrote:
Kathey Marsden wrote:
I ran the test with RC1 and have been running it on trunk, but haven't
tried with RC2. I haven't ever seen this error. Regarding the
mysterious "serious issue" nobody seems to know what that is about.
I filed DERBY-4091 to investigate that issue.
I should have indicated that I have been running this test incorrectly
(without a derby.properties) in order to try to reproduce DERBY-4152 and
DERBY-4075 and on Windows with IBM 1.6 (build pwi3260sr3-20081106_07(SR3))
Kathey
The case I reported was run with derby.properties and with NetworkServer:
java org.apache.derbyTesting.system.mailjdbc.MailJdbc NetworkServer
I just started two embedded runs, w/ and wo/ derby.properties:
java org.apache.derbyTesting.system.mailjdbc.MailJdbc embedded.
Without derby.properties I see:
-------------------------------
: INFO :Purging Thread : delete mails which are older than 1 day
: INFO :Refresh Thread : Error while inserting attachments:The
statement was aborted because it would have caused a duplicate key value
in a unique or primary key constraint or unique index identified by
'ATTACH__PK'
defined on 'ATTACH'.
: ERROR :insertMail() failed The statement was aborted because it
would have caused a duplicate key value in a unique or primary key
constraint or unique index identified by 'ATTACH__PK' defined on 'ATTACH'.
: INFO :Deleting mail by refresh
With derby.properties I see:
----------------------------
: INFO :Backup Thread : dbsize before compress : 1179648
: ERROR :Backup Thread : Error while doing the Compress procedure: The
exception 'java.sql.SQLException: User 'BACKUP' can not perform the
operation in schema 'REFRESH'.' was thrown while evaluating an expressi
on.
: INFO :Backup Thread : Finished Compressing the table: INBOX
: INFO :Backup Thread : dbsize after compress : 1441792
: INFO :Backup Thread : dbsize before compress : 1441792
: ERROR :Backup Thread : Error while doing the Compress procedure: The
exception 'java.sql.SQLException: User 'BACKUP' can not perform the
operation in schema 'REFRESH'.' was thrown while evaluating an expressi
on.
: INFO :Backup Thread : Finished Compressing the table: ATTACH
AND
: INFO :Refresh Thread : Error while inserting attachments:The
statement was aborted because it would have caused a duplicate key value
in a unique or primary key constraint or unique index identified by 'ATTAC
H__PK' defined on 'ATTACH'.
: ERROR :insertMail() failed The statement was aborted because it
would have caused a duplicate key value in a unique or primary key
constraint or unique index identified by 'ATTACH__PK' defined on 'ATTACH'.
: INFO :Deleting mail by refresh
--
Ole Solberg, Database Technology Group,
Sun Microsystems, Trondheim, Norway
