You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Nicolas Malin <ni...@nereide.fr> on 2014/11/05 13:47:06 UTC

entitytests.testConverters failed on 1636820

Hello during my test on entity-auto, the non regression entitytests 
faild on testConverters. I believed at first to an error from my local 
improvement but after a svn revert and run an other "ant clean-all 
load-demo run-tests", I have one error :

org.ofbiz.entity.GenericEntityException: Error while inserting: 
[GenericEntity:Testing][createdStamp,2014-11-05 
09:33:30.509(java.sql.Timestamp)][createdTxStamp,2014-11-05 
09:33:30.509(java.sql.Timestamp)][description,Testing JSON 
Converters(java.lang.String)][lastUpdatedStamp,2014-11-05 
09:33:30.509(java.sql.Timestamp)][lastUpdatedTxStamp,2014-11-05 
09:33:30.509(java.sql.Timestamp)][testingDate,2014-11-05 
09:33:30.509(java.sql.Timestamp)][testingId,JSON_TEST(java.lang.String)][testingSize,123(java.lang.Long)][testingTypeId,TEST-UPDATE-1(java.lang.String)] 
(SQL Exception while executing the following:INSERT INTO OFBIZ.TESTING 
(TESTING_ID, TESTING_TYPE_ID, TESTING_NAME, DESCRIPTION, COMMENTS, 
TESTING_SIZE, TESTING_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, 
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?) (INSERT on table 'TESTING' caused a violation of foreign key 
constraint 'ENTITY_ENTY_TYP' for key (TEST-UPDATE-1). The statement has 
been rolled back.)) (Error while inserting: 
[GenericEntity:Testing][createdStamp,2014-11-05 
09:33:30.509(java.sql.Timestamp)][createdTxStamp,2014-11-05 
09:33:30.509(java.sql.Timestamp)][description,Testing JSON 
Converters(java.lang.String)][lastUpdatedStamp,2014-11-05 
09:33:30.509(java.sql.Timestamp)][lastUpdatedTxStamp,2014-11-05 
09:33:30.509(java.sql.Timestamp)][testingDate,2014-11-05 
09:33:30.509(java.sql.Timestamp)][testingId,JSON_TEST(java.lang.String)][testingSize,123(java.lang.Long)][testingTypeId,TEST-UPDATE-1(java.lang.String)] 
(SQL Exception while executing the following:INSERT INTO OFBIZ.TESTING 
(TESTING_ID, TESTING_TYPE_ID, TESTING_NAME, DESCRIPTION, COMMENTS, 
TESTING_SIZE, TESTING_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, 
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?) (INSERT on table 'TESTING' caused a violation of foreign key 
constraint 'ENTITY_ENTY_TYP' for key (TEST-UPDATE-1). The statement has 
been rolled back.)))

|org.ofbiz.entity.GenericEntityException: 
org.ofbiz.entity.GenericEntityException: Error while inserting: 
[GenericEntity:Testing][createdStamp,2014-11-05 
09:33:30.509(java.sql.Timestamp)][createdTxStamp,2014-11-05 
09:33:30.509(java.sql.Timestamp)][description,Testing JSON 
Converters(java.lang.String)][lastUpdatedStamp,2014-11-05 
09:33:30.509(java.sql.Timestamp)][lastUpdatedTxStamp,2014-11-05 
09:33:30.509(java.sql.Timestamp)][testingDate,2014-11-05 
09:33:30.509(java.sql.Timestamp)][testingId,JSON_TEST(java.lang.String)][testingSize,123(java.lang.Long)][testingTypeId,TEST-UPDATE-1(java.lang.String)] 
(SQL Exception while executing the following:INSERT INTO OFBIZ.TESTING 
(TESTING_ID, TESTING_TYPE_ID, TESTING_NAME, DESCRIPTION, COMMENTS, 
TESTING_SIZE, TESTING_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, 
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?) (INSERT on table 'TESTING' caused a violation of foreign key 
constraint 'ENTITY_ENTY_TYP' for key (TEST-UPDATE-1). The statement has 
been rolled back.)) (Error while inserting: 
[GenericEntity:Testing][createdStamp,2014-11-05 
09:33:30.509(java.sql.Timestamp)][createdTxStamp,2014-11-05 
09:33:30.509(java.sql.Timestamp)][description,Testing JSON 
Converters(java.lang.String)][lastUpdatedStamp,2014-11-05 
09:33:30.509(java.sql.Timestamp)][lastUpdatedTxStamp,2014-11-05 
09:33:30.509(java.sql.Timestamp)][testingDate,2014-11-05 
09:33:30.509(java.sql.Timestamp)][testingId,JSON_TEST(java.lang.String)][testingSize,123(java.lang.Long)][testingTypeId,TEST-UPDATE-1(java.lang.String)] 
(SQL Exception while executing the following:INSERT INTO OFBIZ.TESTING 
(TESTING_ID, TESTING_TYPE_ID, TESTING_NAME, DESCRIPTION, COMMENTS, 
TESTING_SIZE, TESTING_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, 
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?) (INSERT on table 'TESTING' caused a violation of foreign key 
constraint 'ENTITY_ENTY_TYP' for key (TEST-UPDATE-1). The statement has 
been rolled back.)))
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:923)
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:745)
at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:731)
at 
org.ofbiz.entity.test.EntityTestSuite.testConverters(EntityTestSuite.java:1218)

|I'm only one ?

Nicolas
-- 

Nicolas Malin - Consultant - 06 17 66 40 06 - nereide.fr 
<http://nereide.fr>


Re: entitytests.testConverters failed on 1636820

Posted by Nicolas Malin <ni...@nereide.fr>.
BUILD SUCCESSFUL
Total time: 5 minutes 45 seconds

Thanks Adrian !

Nicolas

Le 05/11/2014 16:35, Adrian Crum a écrit :
> I committed a fix in rev 1636896. Please let me know if it solves the 
> problem.
>
> Adrian Crum
> Sandglass Software
> www.sandglass-software.com
>


Re: entitytests.testConverters failed on 1636820

Posted by Adrian Crum <ad...@sandglass-software.com>.
I committed a fix in rev 1636896. Please let me know if it solves the 
problem.

Adrian Crum
Sandglass Software
www.sandglass-software.com

On 11/5/2014 12:47 PM, Nicolas Malin wrote:
> Hello during my test on entity-auto, the non regression entitytests
> faild on testConverters. I believed at first to an error from my local
> improvement but after a svn revert and run an other "ant clean-all
> load-demo run-tests", I have one error :
>
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:Testing][createdStamp,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][createdTxStamp,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][description,Testing JSON
> Converters(java.lang.String)][lastUpdatedStamp,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][lastUpdatedTxStamp,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][testingDate,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][testingId,JSON_TEST(java.lang.String)][testingSize,123(java.lang.Long)][testingTypeId,TEST-UPDATE-1(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO OFBIZ.TESTING
> (TESTING_ID, TESTING_TYPE_ID, TESTING_NAME, DESCRIPTION, COMMENTS,
> TESTING_SIZE, TESTING_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?) (INSERT on table 'TESTING' caused a violation of foreign key
> constraint 'ENTITY_ENTY_TYP' for key (TEST-UPDATE-1). The statement has
> been rolled back.)) (Error while inserting:
> [GenericEntity:Testing][createdStamp,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][createdTxStamp,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][description,Testing JSON
> Converters(java.lang.String)][lastUpdatedStamp,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][lastUpdatedTxStamp,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][testingDate,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][testingId,JSON_TEST(java.lang.String)][testingSize,123(java.lang.Long)][testingTypeId,TEST-UPDATE-1(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO OFBIZ.TESTING
> (TESTING_ID, TESTING_TYPE_ID, TESTING_NAME, DESCRIPTION, COMMENTS,
> TESTING_SIZE, TESTING_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?) (INSERT on table 'TESTING' caused a violation of foreign key
> constraint 'ENTITY_ENTY_TYP' for key (TEST-UPDATE-1). The statement has
> been rolled back.)))
>
> |org.ofbiz.entity.GenericEntityException:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:Testing][createdStamp,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][createdTxStamp,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][description,Testing JSON
> Converters(java.lang.String)][lastUpdatedStamp,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][lastUpdatedTxStamp,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][testingDate,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][testingId,JSON_TEST(java.lang.String)][testingSize,123(java.lang.Long)][testingTypeId,TEST-UPDATE-1(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO OFBIZ.TESTING
> (TESTING_ID, TESTING_TYPE_ID, TESTING_NAME, DESCRIPTION, COMMENTS,
> TESTING_SIZE, TESTING_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?) (INSERT on table 'TESTING' caused a violation of foreign key
> constraint 'ENTITY_ENTY_TYP' for key (TEST-UPDATE-1). The statement has
> been rolled back.)) (Error while inserting:
> [GenericEntity:Testing][createdStamp,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][createdTxStamp,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][description,Testing JSON
> Converters(java.lang.String)][lastUpdatedStamp,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][lastUpdatedTxStamp,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][testingDate,2014-11-05
> 09:33:30.509(java.sql.Timestamp)][testingId,JSON_TEST(java.lang.String)][testingSize,123(java.lang.Long)][testingTypeId,TEST-UPDATE-1(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO OFBIZ.TESTING
> (TESTING_ID, TESTING_TYPE_ID, TESTING_NAME, DESCRIPTION, COMMENTS,
> TESTING_SIZE, TESTING_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?) (INSERT on table 'TESTING' caused a violation of foreign key
> constraint 'ENTITY_ENTY_TYP' for key (TEST-UPDATE-1). The statement has
> been rolled back.)))
> at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:923)
> at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:745)
> at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:731)
> at
> org.ofbiz.entity.test.EntityTestSuite.testConverters(EntityTestSuite.java:1218)
>
>
> |I'm only one ?
>
> Nicolas

Re: entitytests.testConverters failed on 1636820

Posted by Jacques Le Roux <ja...@les7arts.com>.
Hi Nicolas,

Yes it's a new random error in testConverters indeed

I 1st sent this message http://markmail.org/message/yevxxy5k2bleqics Could help to trace the initial reason...

Thanks

Jacques


Le 05/11/2014 14:58, Nicolas Malin a écrit :
> Le 05/11/2014 14:46, Jacopo Cappellato a écrit :
>> Since then it didn't happen again. I will have to further investigate.
> No problem, I continue tomorrow my test and I will check it in the same time
>
> Nicolas
>
>

Re: entitytests.testConverters failed on 1636820

Posted by Nicolas Malin <ni...@nereide.fr>.
Le 05/11/2014 14:46, Jacopo Cappellato a écrit :
> Since then it didn't happen again. I will have to further investigate.
No problem, I continue tomorrow my test and I will check it in the same time

Nicolas

Re: entitytests.testConverters failed on 1636820

Posted by Jacopo Cappellato <ja...@hotwaxmedia.com>.
On Nov 5, 2014, at 1:47 PM, Nicolas Malin <ni...@nereide.fr> wrote:

> |I'm only one ?

I actually got it too a few days ago but it was intermittent. Since then it didn't happen again. I will have to further investigate.

Jacopo