Importing a large SQL dump fails to complete

[GoogleCodeExporter]

What steps will reproduce the problem?

1. Try to import a large SQL dump into ORDS - e.g. OxRep (510mb)
2. Select the file and click 'upload'
3. After a while, ORDS will indicate that its importing the file and will email 
when this completes

What is the expected output? What do you see instead?

The operation never completes; after the tables are created and first 6000 or 
so rows inserted no further data is imported. No errors are raised in the logs.

Please use labels and text to provide additional information.

Related to issue 624.

Original issue reported on code.google.com by scott.br...@gmail.com on 4 Mar 2015 at 10:48

[GoogleCodeExporter]

Tried this twice now - always stops on ~5600 rows of the second imported table. 
Last log messages are of the form

2015-03-04 10:47:40,626 DEBUG ordsProjectNode.utilities.GeneralUtils 
(GeneralUtils.java:207) - 
psql:...tomcat8x/temp/codifiedFile4875992825272280353.ordsmod:1223: ERROR:  
role "site1181_1f41" does not exist

But this in general doesn't prevent an import as I tried with a smaller file 
containing missing roles, and this processed OK. Seems to be more likely to be 
a buffer/IO problem somewhere.

No further errors are recorded anywhere; Ords just silently gives up importing 
(or the thread never completes).

Original comment by scott.br...@gmail.com on 4 Mar 2015 at 11:11

[GoogleCodeExporter]

THis is now working

Original comment by jajwil...@gmail.com on 11 Mar 2015 at 2:49

• Changed state: Fixed