[jira] Closed: (OFBIZ-37) XML data import fails when importing more than ~10000 products

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

[jira] Closed: (OFBIZ-37) XML data import fails when importing more than ~10000 products

Nicolas Malin (Jira)
     [ http://issues.apache.org/jira/browse/OFBIZ-37?page=all ]

Si Chen closed OFBIZ-37.
------------------------

    Resolution: Fixed

I think I may have fixed in SVN r 433334.   If not please open another issue

>  XML data import fails when importing more than ~10000 products
> ---------------------------------------------------------------
>
>                 Key: OFBIZ-37
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-37
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>    Affects Versions: SVN trunk
>         Environment: Gentoo Linux, 2.8 Ghz Xeon proc, 2 gigs RAM, recent build of ofbiz
>            Reporter: Nick Olson
>            Priority: Minor
>         Attachments: console.log
>
>
> I am trying to import 40k products into the database (I'm running postgres), but when I try to import, I get an error message that says:
> ERROR parsing Entity Xml file: Commit transaction failed.
> This appears in the log file:
> 108829 (http-0.0.0.0-8443-Processor4) [    EntitySaxReader.java:403:INFO ] Another 1000 values imported: now up to 17000
> 113599 (http-0.0.0.0-8443-Processor4) [    EntitySaxReader.java:403:INFO ] Another 1000 values imported: now up to 18000
> 118405 (http-0.0.0.0-8443-Processor4) [    EntitySaxReader.java:261:INFO ] Finished 18999 values from file:/home/nick/ofbiz-7818/import/demo_products.xml
> 118412 (http-0.0.0.0-8443-Processor4) [InheritableTransactionContext.java:311:ERROR] Unable to roll back transaction
> java.lang.IllegalStateException: Status is STATUS_NO_TRANSACTION
> at org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:438)
> at org.apache.geronimo.transaction.context.InheritableTransactionContext.rollbackAndThrow(InheritableTransactionContext.java:308)
> at org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:199)
> I get the exact same error when I try to use a derby database instead
> of the postgres one. This import was working when I was using an
> earlier build of ofbiz (1-2 months ago), but it is failing now.
> ------
> I posted this to the mailing list, and I tried the suggestions, (increasing memory, increasing transaction timeout), with no change in the error  messages.

--
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