Cansu Kaynak writes: > Hi. > The first thing to try is to restart the database server and then try to > regenerate the data set. > To shut down the database: sudo bin/mysqladmin shutdown
> Then, please take a look at the recommendation at > http://www.mail-archive.com/[email protected]/msg00061.html Right, I was missing the mysql parameters pointed out in that mail. I actually had an olio-specific config at /etc/mysql/conf.d, but it was missing the .cnf suffix, and mysql then ignores that file. Thanks a lot! > Let me know if these don't work. > Cansu > On 10/06/2013 10:30 PM, Lluís Vilanova wrote: >> Hi, >> >> I'm trying to set cloudstone up in a Debian testing system, and the >> dbloader.sh >> script never finishes (I'm following >> http://parsa.epfl.ch/cloudsuite/web.html). >> >> Starting it with a load factor of 30 prints the following: >> >> Oct 06, 2013 10:20:24 PM org.apache.olio.workload.loader.LoadController main >> INFO: Done clearing database tables. >> Oct 06, 2013 10:20:24 PM org.apache.olio.workload.loader.LoadController main >> INFO: Done data creation. >> >> While starting it with a factor of 50 just prints up until the "clearing >> database tables" line. >> >> In all cases, mysqld and some java threads are left running around, with a >> low >> CPU usage. A little bit of jdb tells me some of the threads are stuck waiting >> for some info (this is for a factor of 30): >> >>> threads >> Group system: >> (java.lang.ref.Reference$ReferenceHandler)0x3c9 Reference Handler >> cond. waiting >> (java.lang.ref.Finalizer$FinalizerThread)0x3ca Finalizer >> cond. waiting >> (java.lang.Thread)0x3cb Signal Dispatcher >> running >> Group main: >> (java.lang.Thread)0x3cd main >> cond. waiting >> (java.util.TimerThread)0x3ce MySQL Statement Cancellation >> Timer cond. waiting >> (java.lang.Thread)0x3cf pool-8-thread-2 >> running >> (java.lang.Thread)0x3d0 pool-3-thread-2 >> running >> (java.lang.Thread)0x3d1 pool-9-thread-2 >> running >> (java.lang.Thread)0x3d2 pool-3-thread-3 >> running >> (java.lang.Thread)0x3d3 pool-8-thread-3 >> running >> (java.lang.Thread)0x3d4 pool-7-thread-2 >> running >> (java.lang.Thread)0x3d5 pool-9-thread-3 >> running >> (java.lang.Thread)0x3d6 pool-7-thread-3 >> running >> (java.lang.Thread)0x3d7 pool-3-thread-4 >> running >> (java.lang.Thread)0x3d8 pool-8-thread-4 >> running >>> suspend 0x3cd >>> where >> [1] sun.misc.Unsafe.park (native method) >> [2] java.util.concurrent.locks.LockSupport.parkNanos (LockSupport.java:226) >> [3] >> java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos >> (AbstractQueuedSynchronizer.java:2.082) >> [4] java.util.concurrent.ThreadPoolExecutor.awaitTermination >> (ThreadPoolExecutor.java:1.468) >> [5] org.apache.olio.workload.loader.framework.Loader.shutdown >> (Loader.java:323) >> [6] org.apache.olio.workload.loader.LoadController.main >> (LoadController.java:66) >>> suspend 0x3cf >>> where >> [1] java.net.SocketInputStream.socketRead0 (native method) >> [2] java.net.SocketInputStream.read (SocketInputStream.java:150) >> [3] java.net.SocketInputStream.read (SocketInputStream.java:121) >> [4] com.mysql.jdbc.util.ReadAheadInputStream.fill >> (ReadAheadInputStream.java:113) >> [5] >> com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary >> (ReadAheadInputStream.java:160) >> [6] com.mysql.jdbc.util.ReadAheadInputStream.read >> (ReadAheadInputStream.java:188) >> [7] com.mysql.jdbc.MysqlIO.readFully (MysqlIO.java:1.994) >> [8] com.mysql.jdbc.MysqlIO.reuseAndReadPacket (MysqlIO.java:2.411) >> [9] com.mysql.jdbc.MysqlIO.checkErrorPacket (MysqlIO.java:2.916) >> [10] com.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:1.631) >> [11] com.mysql.jdbc.MysqlIO.sqlQueryDirect (MysqlIO.java:1.723) >> [12] com.mysql.jdbc.Connection.execSQL (Connection.java:3.283) >> [13] com.mysql.jdbc.PreparedStatement.executeInternal >> (PreparedStatement.java:1.332) >> [14] com.mysql.jdbc.PreparedStatement.executeUpdate >> (PreparedStatement.java:1.604) >> [15] com.mysql.jdbc.PreparedStatement.executeBatchSerially >> (PreparedStatement.java:1.229) >> [16] com.mysql.jdbc.PreparedStatement.executeBatch >> (PreparedStatement.java:955) >> [17] org.apache.olio.workload.loader.framework.ThreadConnection.flush >> (ThreadConnection.java:235) >> [18] org.apache.olio.workload.loader.framework.ThreadConnection.processBatch >> (ThreadConnection.java:180) >> [19] org.apache.olio.workload.loader.framework.Loader$4.run (Loader.java:276) >> [20] java.util.concurrent.Executors$RunnableAdapter.call (Executors.java:471) >> [21] java.util.concurrent.FutureTask$Sync.innerRun (FutureTask.java:334) >> [22] java.util.concurrent.FutureTask.run (FutureTask.java:166) >> [23] java.util.concurrent.ThreadPoolExecutor.runWorker >> (ThreadPoolExecutor.java:1.145) >> [24] java.util.concurrent.ThreadPoolExecutor$Worker.run >> (ThreadPoolExecutor.java:615) >> [25] java.lang.Thread.run (Thread.java:724) >> >> >> Any ideas on what I'm doing wrong? >> >> >> Thanks, >> Lluis >> -- "And it's much the same thing with knowledge, for whenever you learn something new, the whole world becomes that much richer." -- The Princess of Pure Reason, as told by Norton Juster in The Phantom Tollbooth
