You are viewing a plain text version of this content. The canonical link for it is here.
Posted to olio-dev@incubator.apache.org by "Shanti Subramanyam (JIRA)" <ji...@apache.org> on 2009/03/02 21:24:56 UTC
[jira] Closed: (OLIO-53) Database load fails at high user counts
[ https://issues.apache.org/jira/browse/OLIO-53?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shanti Subramanyam closed OLIO-53.
----------------------------------
> Database load fails at high user counts
> ---------------------------------------
>
> Key: OLIO-53
> URL: https://issues.apache.org/jira/browse/OLIO-53
> Project: Olio
> Issue Type: Bug
> Components: generic
> Reporter: Shanti Subramanyam
> Assignee: Akara Sucharitakul
>
> The current database loader does not load for a user population of over 3000 (this is with the scalefactor set to 100x i.e. the db has 100 times the #concurrent users).
> If we edit the dbloader.sh to add a '-Xmx3g' option, the loader works upto a scale of 7000.
> Beyond that, the loader fails with:
> Feb 17, 2009 9:29:14 PM com.sun.web20.loader.framework.ThreadConnection processBatch
> WARNING: com.sun.web20.loader.Person: Retry loading.
> java.sql.BatchUpdateException: Duplicate entry 'jjq' for key 'PRIMARY'
> at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1237)
> at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:936)
> at com.sun.web20.loader.framework.ThreadConnection.flush(ThreadConnection.java:220)
> at com.sun.web20.loader.framework.ThreadConnection.processBatch(ThreadConnection.java:166)
> at com.sun.web20.loader.framework.Loader$4.run(Loader.java:184)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
> at java.util.concurrent.FutureTask.run(FutureTask.java:138)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
> Feb 17, 2009 9:29:14 PM com.sun.web20.loader.framework.ThreadConnection processBatch
> WARNING: com.sun.web20.loader.Person: Failed to update.
> java.sql.BatchUpdateException: Duplicate entry 'ycb9vui' for key 'PRIMARY'
> at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1237)
> at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:936)
> at com.sun.web20.loader.framework.ThreadConnection.flush(ThreadConnection.java:220)
> at com.sun.web20.loader.framework.ThreadConnection.processBatch(ThreadConnection.java:166)
> at com.sun.web20.loader.framework.Loader$4.run(Loader.java:184)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
> at java.util.concurrent.FutureTask.run(FutureTask.java:138)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
> Error count exceeded threshold of 50! Exiting.
> ERROR: Database loader exited with code 2.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.