entitytests.testConverters failed on 1636820

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

entitytests.testConverters failed on 1636820

Nicolas Malin-2
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>

Reply | Threaded
Open this post in threaded view
|

Re: entitytests.testConverters failed on 1636820

Jacopo Cappellato-4

On Nov 5, 2014, at 1:47 PM, Nicolas Malin <[hidden email]> 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

Reply | Threaded
Open this post in threaded view
|

Re: entitytests.testConverters failed on 1636820

Nicolas Malin-2
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
Reply | Threaded
Open this post in threaded view
|

Re: entitytests.testConverters failed on 1636820

Jacques Le Roux
Administrator
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
>
>
Reply | Threaded
Open this post in threaded view
|

Re: entitytests.testConverters failed on 1636820

Adrian Crum-3
In reply to this post by Nicolas Malin-2
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
Reply | Threaded
Open this post in threaded view
|

Re: entitytests.testConverters failed on 1636820

Nicolas Malin-2
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
>