Hi Luca;
I have the same problem when I did not limit the row count of the table. I
tried tx:false with following configuration and It gets GC overlimit again.
Best Regards.
{
"config": {
"log": "debug"
},
"extractor": {
"jdbc": {
"driver": "com.mysql.jdbc.Driver",
"url": "jdbc:mysql://xxxx",
"userName": "xxxxx",
"userPassword": "xxxx",
"query": "select * from `gg`.`member`"
}
},
"transformers": [
{
"vertex": {
"class": "Member"
}
}
],
"loader": {
"orientdb": {
"dbURL":
"plocal:/Users/ykurtulus/orientdb-community-2.0.5/databases/ElekMigrationTest10",
"dbUser": "root",
"dbPassword": "root",
"dbAutoCreate": true,
"tx": false,
"batchCommit": 1000,
"wal" : false,
"dbType": "graph",
"classes": [
{"name": "Member", "extends": "V"}
]
}
}
}
java.lang.OutOfMemoryError: GC overhead limit exceeded
at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:1657)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1434)
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2936)
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:477)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2631)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1800)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2221)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557)
at
com.orientechnologies.orient.etl.extractor.OJDBCExtractor.begin(OJDBCExtractor.java:107)
at
com.orientechnologies.orient.etl.OETLProcessor.begin(OETLProcessor.java:436)
at
com.orientechnologies.orient.etl.OETLProcessor.executeSequentially(OETLProcessor.java:466)
at
com.orientechnologies.orient.etl.OETLProcessor.execute(OETLProcessor.java:291)
at
com.orientechnologies.orient.etl.OETLProcessor.main(OETLProcessor.java:163)
Best Regards.
7 Ekim 2014 Salı 21:00:50 UTC+3 tarihinde Lvc@ yazdı:
>
> Try to set
>
> tx: false
>
> Lvc@
>
> Sent from Mobile device
> Il 07/Ott/2014 17:43 "Tongqing Qiu" <[email protected] <javascript:>>
> ha scritto:
>
>> Any idea?
>>
>> Here is the log
>>
>> + extracted 0 records (0 records/sec) - 0 records -> loaded 0 vertices (0
>> vertices/sec) Total time: 24274ms [0 warnings, 0 errors]
>> + extracted 0 records (0 records/sec) - 0 records -> loaded 0 vertices (0
>> vertices/sec) Total time: 35854ms [0 warnings, 0 errors]
>> Exception in thread "Timer-0" java.lang.OutOfMemoryError: GC overhead
>> limit exceeded
>>
>> Exception: java.lang.OutOfMemoryError thrown from the
>> UncaughtExceptionHandler in thread "Timer-0"
>> Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit
>> exceeded
>> at java.util.zip.ZipCoder.getBytes(ZipCoder.java:80)
>> at java.util.zip.ZipFile.getEntry(ZipFile.java:306)
>> at java.util.jar.JarFile.getEntry(JarFile.java:227)
>> at java.util.jar.JarFile.getJarEntry(JarFile.java:210)
>> at sun.misc.URLClassPath$JarLoader.getResource(URLClassPath.java:840)
>> at sun.misc.URLClassPath.getResource(URLClassPath.java:199)
>> at java.net.URLClassLoader$1.run(URLClassLoader.java:358)
>> at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
>> at java.security.AccessController.doPrivileged(Native Method)
>> at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
>> at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
>> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
>> at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
>> at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4291)
>> at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3436)
>> at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3327)
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:870)
>> at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1928)
>> at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3278)
>> at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:462)
>> at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2997)
>> at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2245)
>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2638)
>> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
>> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
>> at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
>> at
>> com.orientechnologies.orient.etl.extractor.OJDBCExtractor.begin(OJDBCExtractor.java:103)
>> at
>> com.orientechnologies.orient.etl.OETLProcessor.begin(OETLProcessor.java:382)
>> at
>> com.orientechnologies.orient.etl.OETLProcessor.executeSequentially(OETLProcessor.java:447)
>> at
>> com.orientechnologies.orient.etl.OETLProcessor.execute(OETLProcessor.java:257)
>> at
>> com.orientechnologies.orient.etl.OETLProcessor.main(OETLProcessor.java:225)
>>
>> Here is my configuration
>>
>> {
>> "config": {
>> "verbose": true,
>> "log": "debug"
>> },
>> "extractor" : {
>> "jdbc": { "driver": "com.mysql.jdbc.Driver",
>> "url": "jdbc:mysql://10.10.16.180/mydb",
>> "userName": "root",
>> "userPassword": "password",
>> "query": "select * from Concepts" }
>> },
>> "transformers" : [
>> { "vertex": { "class": "Concepts"} }
>> ],
>> "loader" : {
>> "orientdb": {
>> "dbURL": "plocal:/tmp/mydb",
>> "dbUser": "admin",
>> "dbPassword": "admin",
>> "dbAutoCreate": true,
>> "tx": true,
>> "dbType": "graph",
>> "batchCommit": 1000
>> }
>> }
>> }
>>
>> --
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "OrientDB" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
