You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Nick Olson (JIRA)" <ji...@apache.org> on 2006/06/20 23:37:29 UTC
[jira] Created: (OFBIZ-37) XML data import fails when importing
more than ~10000 products
XML data import fails when importing more than ~10000 products
---------------------------------------------------------------
Key: OFBIZ-37
URL: http://issues.apache.org/jira/browse/OFBIZ-37
Project: The Open For Business Project
Type: Bug
Versions: SVN trunk
Environment: Gentoo Linux, 2.8 Ghz Xeon proc, 2 gigs RAM, recent build of ofbiz
Reporter: Nick Olson
Priority: Minor
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
[jira] Updated: (OFBIZ-37) XML data import fails when importing
more than ~10000 products
Posted by "Nick Olson (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OFBIZ-37?page=all ]
Nick Olson updated OFBIZ-37:
----------------------------
Attachment: console.log
This is the full log from when I tried to import the data.
> XML data import fails when importing more than ~10000 products
> ---------------------------------------------------------------
>
> Key: OFBIZ-37
> URL: http://issues.apache.org/jira/browse/OFBIZ-37
> Project: The Open For Business Project
> Type: Bug
> 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
[jira] Closed: (OFBIZ-37) XML data import fails when importing
more than ~10000 products
Posted by "Si Chen (JIRA)" <ji...@apache.org>.
[ 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
[jira] Commented: (OFBIZ-37) XML data import fails when importing
more than ~10000 products
Posted by "Nick Olson (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OFBIZ-37?page=comments#action_12417199 ]
Nick Olson commented on OFBIZ-37:
---------------------------------
Ok, I figured out how to get it to work. The Geronimo transaction was
timing out, and that TRANSACTION_TIMEOUT parameter doesn't seem to
effect that. I went into the GeronimoTransactionFactory.java file and
changed the default transaction timeout to 30 min and it imported the
data without any problems. There is probably a more elegant way to fix
this, but it seems to be working for now.
> XML data import fails when importing more than ~10000 products
> ---------------------------------------------------------------
>
> Key: OFBIZ-37
> URL: http://issues.apache.org/jira/browse/OFBIZ-37
> Project: The Open For Business Project
> Type: Bug
> 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