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
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
