search

timolson / cointrader

Coin Trader is a Java-based backend for algorithmically trading cryptocurrencies. It provides data collection and export, complex event processing and triggering, and backtesting - paper trading - live trading.
Other
450 stars 166 forks source link

DB Connection Issue During Setup #124

Closed Tikaszar closed 9 years ago

Tikaszar commented 9 years ago

I've been following the setup instructions and ran into an error I'm not quite sure how to get around. After I run ./cointrader.sh reset-database I receive an exception: Could not initialize db. I've tried a few different things (switching sql users around, new db from scratch, re-pull, recompile, new properties file, default config including root with no pass, etc). I'm running this on Windows 10. I've inspected the db in workbench, and it does generate the tables and columns. Any help would be very much appreciated!

Here's the log info, as well as the error at the bottom:


2015-08-03 17:50:23 [main] DEBUG o.cryptocoinpartners.util.ConfigUtil - Combined Configuration:
awt.toolkit=sun.awt.windows.WToolkit
base.symbol=USD
command.path=
console.cursor=ct>
console.hisory.size=100
db.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
db.driver=com.mysql.jdbc.Driver
db.idle.test.period=3000
db.max.connection.age=3600
db.persist.retry=4
db.pool.growth=3
db.pool.size=3
db.test.connection=false
db.url=jdbc:mysql://localhost:3306/cointrader
db.username=cointrader
faketicker.exchange=BITSTAMP
file.encoding.pkg=sun.io
file.encoding=Cp1252
file.separator=\
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
java.awt.printerjob=sun.awt.windows.WPrinterJob
java.class.path=target/cointrader-0.3.0-SNAPSHOT-jar-with-dependencies.jar
java.class.version=52.0
java.endorsed.dirs=C:\Program Files\Java\jre1.8.0_51\lib\endorsed
java.ext.dirs=C:\Program Files\Java\jre1.8.0_51\lib\ext;C:\WINDOWS\Sun\Java\lib\ext
java.home=C:\Program Files\Java\jre1.8.0_51
java.io.tmpdir=C:\Users\Ptolemy\AppData\Local\Temp\
java.library.path=c:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;c:\Users\Ptolemy\bin;.;C:\Program Files (x86)\Git\local\bin;C:\Program Files (x86)\Git\mingw\bin;C:\Program Files (x86)\Git\bin;d:\Program Files\ImageMagick-6.9.1-Q16;c:\Program Files (x86)\OpenSSH\bin;c:\Program Files (x86)\Skype\Phone\;c:\HashiCorp\Vagrant\bin;d:\Python34;c:\WINDOWS\system32;c:\WINDOWS;c:\WINDOWS\System32\Wbem;c:\WINDOWS\System32\WindowsPowerShell\v1.0\;c:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;c:\Program Files (x86)\AMD\ATI.ACE\Core-Static;d:\Maven 3.3.3\bin;c:\Program Files (x86)\MySQL\MySQL Fabric 1.5.4 & MySQL Utilities 1.5.4 1.5\;c:\Program Files (x86)\MySQL\MySQL Fabric 1.5.4 & MySQL Utilities 1.5.4 1.5\Doctrine extensions for PHP\;c:\ProgramData\Oracle\Java\javapath;.
java.runtime.name=Java(TM) SE Runtime Environment
java.runtime.version=1.8.0_51-b16
java.specification.name=Java Platform API Specification
java.specification.vendor=Oracle Corporation
java.specification.version=1.8
java.vendor.url.bug=http://bugreport.sun.com/bugreport/
java.vendor.url=http://java.oracle.com/
java.vendor=Oracle Corporation
java.version=1.8.0_51
java.vm.info=mixed mode
java.vm.name=Java HotSpot(TM) 64-Bit Server VM
java.vm.specification.name=Java Virtual Machine Specification
java.vm.specification.vendor=Oracle Corporation
java.vm.specification.version=1.8
java.vm.vendor=Oracle Corporation
java.vm.version=25.51-b03
jline.WindowsTerminal.directConsole=false
line.separator=
module.path=
os.arch=amd64
os.name=Windows 8.1
os.version=6.3
path.separator=;
project.artifactId=cointrader
project.groupId=org.cryptocoinpartners
project.version=0.3.0-SNAPSHOT
sun.arch.data.model=64
sun.boot.class.path=C:\Program Files\Java\jre1.8.0_51\lib\resources.jar;C:\Program Files\Java\jre1.8.0_51\lib\rt.jar;C:\Program Files\Java\jre1.8.0_51\lib\sunrsasign.jar;C:\Program Files\Java\jre1.8.0_51\lib\jsse.jar;C:\Program Files\Java\jre1.8.0_51\lib\jce.jar;C:\Program Files\Java\jre1.8.0_51\lib\charsets.jar;C:\Program Files\Java\jre1.8.0_51\lib\jfr.jar;C:\Program Files\Java\jre1.8.0_51\classes
sun.boot.library.path=C:\Program Files\Java\jre1.8.0_51\bin
sun.cpu.endian=little
sun.cpu.isalist=amd64
sun.desktop=windows
sun.io.unicode.encoding=UnicodeLittle
sun.java.command=target/cointrader-0.3.0-SNAPSHOT-jar-with-dependencies.jar reset-database
sun.java.launcher=SUN_STANDARD
sun.jnu.encoding=Cp1252
sun.management.compiler=HotSpot 64-Bit Tiered Compilers
sun.os.patch.level=
sun.stderr.encoding=cp437
sun.stdout.encoding=cp437
user.country=US
user.dir=D:\Documents\JavaBot\cointrader
user.home=C:\Users\Ptolemy
user.language=en
user.name=Ptolemy
user.script=
user.timezone=America/New_York
user.variant=
xchange.bitfinex.class=com.xeiam.xchange.bitfinex.v1.BitfinexExchange
xchange.bitfinex.helper.class=BitfinexHelper
xchange.bitfinex.rate.period=5
xchange.bitfinex.rate.queries=3
xchange.bitstamp.class=com.xeiam.xchange.bitstamp.BitstampExchange
xchange.bitstamp.rate.period=5
xchange.bitstamp.rate.queries=1
xchange.btcchina.class=com.xeiam.xchange.btcchina.BTCChinaExchange
xchange.btcchina.rate.period=2
xchange.btcchina.rate.queries=1
xchange.btce.class=com.xeiam.xchange.btce.v3.BTCEExchange
xchange.btce.rate.period=5
xchange.btce.rate.queries=3
xchange.bter.class=com.xeiam.xchange.bter.BTERExchange
xchange.bter.rate.period=5
xchange.bter.rate.queries=3
xchange.campbx.class=com.xeiam.xchange.campbx.CampBXExchange
xchange.campbx.rate.period=1
xchange.campbx.rate.queries=1
xchange.coinbase.class=com.xeiam.xchange.coinbase.CoinbaseExchange
xchange.coinbase.rate.period=5
xchange.coinbase.rate.queries=1
xchange.cryptsy.class=com.xeiam.xchange.cryptsy.CryptsyExchange
xchange.cryptsy.rate.period=2
xchange.cryptsy.rate.queries=1
xchange.okcoin.class=com.xeiam.xchange.okcoin.OkCoinExchange
xchange.okcoin.exchangeSpecificParameters.futures=false
xchange.okcoin.exchangeSpecificParameters.intl=true
xchange.okcoin.rate.period=5
xchange.okcoin.rate.queries=3
xchange.okcoin_month.class=com.xeiam.xchange.okcoin.OkCoinExchange
xchange.okcoin_month.exchangeSpecificParameters.futures=true
xchange.okcoin_month.exchangeSpecificParameters.intl=true
xchange.okcoin_month.rate.period=5
xchange.okcoin_month.rate.queries=3
xchange.okcoin_nextweek.class=com.xeiam.xchange.okcoin.OkCoinExchange
xchange.okcoin_nextweek.exchangeSpecificParameters.futures=true
xchange.okcoin_nextweek.exchangeSpecificParameters.intl=true
xchange.okcoin_nextweek.rate.period=5
xchange.okcoin_nextweek.rate.queries=3
xchange.okcoin_quarter.class=com.xeiam.xchange.okcoin.OkCoinExchange
xchange.okcoin_quarter.exchangeSpecificParameters.futures=true
xchange.okcoin_quarter.exchangeSpecificParameters.intl=true
xchange.okcoin_quarter.rate.period=5
xchange.okcoin_quarter.rate.queries=3
xchange.okcoin_thisweek.class=com.xeiam.xchange.okcoin.OkCoinExchange
xchange.okcoin_thisweek.exchangeSpecificParameters.futures=true
xchange.okcoin_thisweek.exchangeSpecificParameters.intl=true
xchange.okcoin_thisweek.rate.period=5
xchange.okcoin_thisweek.rate.queries=3

2015-08-03 17:50:26 [main] INFO  org.reflections.Reflections - Reflections took 2238 ms to scan 1 urls, producing 5562 keys and 22050 values 
2015-08-03 17:50:26 [main] INFO  org.cryptocoinpartners.persist - initializing persistence
2015-08-03 17:50:26 [main] WARN  o.hibernate.ejb.HibernatePersistence - HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead.
2015-08-03 17:50:26 [main] WARN  o.hibernate.ejb.HibernatePersistence - HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead.
2015-08-03 17:50:26 [main] WARN  o.hibernate.ejb.HibernatePersistence - HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead.
2015-08-03 17:50:26 [main] INFO  o.h.jpa.internal.util.LogHelper - HHH000204: Processing PersistenceUnitInfo [
    name: org.cryptocoinpartners.schema
    ...]
2015-08-03 17:50:26 [main] INFO  org.hibernate.Version - HHH000412: Hibernate Core {4.3.6.Final}
2015-08-03 17:50:26 [main] INFO  org.hibernate.cfg.Environment - HHH000206: hibernate.properties not found
2015-08-03 17:50:26 [main] INFO  org.hibernate.cfg.Environment - HHH000021: Bytecode provider name : javassist
2015-08-03 17:50:28 [main] INFO  o.h.annotations.common.Version - HCANN000001: Hibernate Commons Annotations {4.0.5.Final}
2015-08-03 17:50:28 [main] INFO  o.h.e.j.c.i.ConnectionProviderInitiator - HHH000130: Instantiating explicit connection provider: org.hibernate.connection.C3P0ConnectionProvider
2015-08-03 17:50:28 [main] INFO  o.h.c.i.C3P0ConnectionProvider - HHH010002: C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/cointrader
2015-08-03 17:50:28 [main] INFO  o.h.c.i.C3P0ConnectionProvider - HHH000046: Connection properties: {user=cointrader, password=****, autocommit=true, release_mode=auto}
2015-08-03 17:50:28 [main] INFO  o.h.c.i.C3P0ConnectionProvider - HHH000006: Autocommit mode: true
2015-08-03 17:50:28 [MLog-Init-Reporter] INFO  com.mchange.v2.log.MLog - MLog clients using slf4j logging.
2015-08-03 17:50:29 [main] INFO  com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.5 [built 02-January-2015 13:25:04 -0500; debug? true; trace: 10]
2015-08-03 17:50:29 [main] INFO  c.m.v.c.i.AbstractPoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@93405021 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@3ed1a980 [ acquireIncrement -> 3, acquireRetryAttempts -> 0, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge1579a1w4oar717q6w8q|57c27be2, idleConnectionTestPeriod -> 0, initialPoolSize -> 10, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 3, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 10, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@8da9db50 [ description -> null, driverClass -> null, factoryClassLocation -> null, forceUseNamedDriverClass -> false, identityToken -> 1hge1579a1w4oar717q6w8q|6da66c8a, jdbcUrl -> jdbc:mysql://localhost:3306/cointrader, properties -> {user=******, password=******, autocommit=true, release_mode=auto} ], preferredTestQuery -> SELECT 1 from exchange, privilegeSpawnedThreads -> false, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, extensions -> {}, factoryClassLocation -> null, identityToken -> 1hge1579a1w4oar717q6w8q|c1a9505, numHelperThreads -> 3 ]
2015-08-03 17:50:29 [main] WARN  c.m.v.resourcepool.BasicResourcePool - Bad pool size config, min 10 > max 3. Using 3 as min.
2015-08-03 17:50:29 [main] WARN  c.m.v.resourcepool.BasicResourcePool - Bad pool size config, start 10 > max 3. Using 3 as start.
2015-08-03 17:50:29 [main] INFO  org.hibernate.dialect.Dialect - HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect
2015-08-03 17:50:29 [main] INFO  o.h.h.i.a.ASTQueryTranslatorFactory - HHH000397: Using ASTQueryTranslatorFactory
2015-08-03 17:50:30 [main] WARN  n.s.e.config.ConfigurationFactory - No configuration found. Configuring ehcache from ehcache-failsafe.xml  found in the classpath: jar:file:/D:/Documents/JavaBot/cointrader/target/cointrader-0.3.0-SNAPSHOT-jar-with-dependencies.jar!/ehcache-failsafe.xml
2015-08-03 17:50:30 [main] INFO  o.h.cache.spi.UpdateTimestampsCache - HHH000250: Starting update timestamps cache at region: org.hibernate.cache.spi.UpdateTimestampsCache
2015-08-03 17:50:30 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.spi.UpdateTimestampsCache]; using defaults.
2015-08-03 17:50:30 [main] INFO  o.h.c.internal.StandardQueryCache - HHH000248: Starting query cache at region: org.hibernate.cache.internal.StandardQueryCache
2015-08-03 17:50:30 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.internal.StandardQueryCache]; using defaults.
2015-08-03 17:50:30 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Fill]; using defaults.
2015-08-03 17:50:30 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Listing]; using defaults.
2015-08-03 17:50:30 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.PortfolioManager]; using defaults.
2015-08-03 17:50:30 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Order]; using defaults.
2015-08-03 17:50:30 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Market]; using defaults.
2015-08-03 17:50:30 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Position]; using defaults.
2015-08-03 17:50:30 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Transaction]; using defaults.
2015-08-03 17:50:30 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Asset]; using defaults.
2015-08-03 17:50:30 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Portfolio]; using defaults.
2015-08-03 17:50:30 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Stake]; using defaults.
2015-08-03 17:50:30 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Exchange]; using defaults.
2015-08-03 17:50:30 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Prompt]; using defaults.
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.SchemaUpdate - HHH000228: Running hbm2ddl schema update
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.SchemaUpdate - HHH000102: Fetching database metadata
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.SchemaUpdate - HHH000396: Updating schema
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.order_children
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [children, order]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: []
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_d42vf63qki5m3f2yfc39gix5d]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.adjustment
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [authorization, time_applied, id, version]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_54ru1mkfaf05t3sw7qajriyjq]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_54ru1mkfaf05t3sw7qajriyjq, primary]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.adjustment_deltas
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [adjustment, deltas]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_hnvmj4sauvd6bwou2u9838wx3, fk_pkvmcu7o8vd9w9c0ogcynvp1j]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_hnvmj4sauvd6bwou2u9838wx3, fk_pkvmcu7o8vd9w9c0ogcynvp1j]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.authorization
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [notes, id, version]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: []
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.book
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [ask_price_as_double, parent, bid_deletions_blob, version, ask_insertions_blob, remote_key, market, bid_price_as_double, ask_volume_as_double, bid_volume_as_double, ask_deletions_blob, time_received, bid_insertions_blob, id, time]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_i9o6ht1d1lk975n7i4h8slkaw, fk_boctr5mp6fppkh67gxjp4xqos]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_i9o6ht1d1lk975n7i4h8slkaw, uk_nfugogi72k3uaprxstuhwbf7u, fk_boctr5mp6fppkh67gxjp4xqos, uk_f8mycxusp2jqgvehm1vkmtefe, primary]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.currency
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [symbol, fiat, id, basis, version]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: []
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.exchange
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [margin_fee_method, symbol, margin, fee_method, margin_fee_rate, id, version, fee_rate]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: []
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.fill
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [stop_price_count, open_volume_count, target_price_count, version, volume_count, remote_key, market, time_received, portfolio, price_count, id, time, position, order]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_lar4y36pcsm03uxlj4wbu1fsq, fk_sfk9h7xr4ckkp6fxrv9hcwsyl, fk_n3lj0gejdepujkfv9oxcwr7oh, fk_7gs0r7diitihi47sguavpflhn]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_lar4y36pcsm03uxlj4wbu1fsq, fk_sfk9h7xr4ckkp6fxrv9hcwsyl, fk_n3lj0gejdepujkfv9oxcwr7oh, primary, fk_7gs0r7diitihi47sguavpflhn]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.general_order
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [limit_price_decimal, entry_time, position_effect, emulation, execution_instruction, fill_type, version, parent_order, volume_decimal, margin_type, market, stop_amount_decimal, target_amount_decimal, portfolio, stop_price_decimal, target_price_decimal, trailing_stop_price_decimal, comment, expiration, id, time, listing, panic_force]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_5n09idi1cl4rbt9uswvm2gp8, fk_oegy99vbh4n958dct2c67v0sr, fk_b7wqc8o55t2f10sfyi7byfyxv]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [general_orderuk_pfc5uvg0u2tdtrtgwq9p50tgn, general_orderuk_sb9a6t3qikue8dtuwn7ju5uei, fk_oegy99vbh4n958dct2c67v0sr, general_orderuk_e0gui2lqm0kyyua6rtbvheyu5, primary]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.listing
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [quote, id, version, prompt, base]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_wbsljbkb77noa0xducg43x8f]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_wbsljbkb77noa0xducg43x8f, uk_b109latdocdl8cgu6jgagabep, uk_fu2dx1ue0cs9sytm3ts2x8dld, primary]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.market
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [price_basis, active, exchange, id, volume_basis, listing, version]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_rm6ipgm2qgxvjwpx3rmrud2yd, fk_oeh8osopuxors0whhhyw0exrq]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_p7eyg8ihn8eathob3ph6lj6yk, uk_oeh8osopuxors0whhhyw0exrq, uk_rm6ipgm2qgxvjwpx3rmrud2yd, primary]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.market_data_gap_error
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [exception, market, gap_interval_start, gap_interval_end, id, time, version]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_srsibgckoty6rnljq7oacgeeb]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary, fk_srsibgckoty6rnljq7oacgeeb]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.offer
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [remote_key, market, time_received, price_count, id, time, version, volume_count]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_qgfii77q46573q0k6d5urno2b]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_qgfii77q46573q0k6d5urno2b, primary]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.order_update
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [sequence, last_state, id, time, state, version, order]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: []
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_jq7kng418cnfaqvll20cfw0n1, primary]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.owner
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [portfolio, name, id, version]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_n0jse4c6ubwbybwgrs1t8sqtn]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_n0jse4c6ubwbybwgrs1t8sqtn, primary]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.owner_stakes
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [owner, stakes]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_hkdupubd782wg400ixlx3gn12, fk_ls73ux93q48x1k5a75lqlflhv]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_hkdupubd782wg400ixlx3gn12, uk_ls73ux93q48x1k5a75lqlflhv]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.portfolio
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [base_asset, name, id, version]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: []
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.portfolio_manager
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [portfolio, id, version]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_g9vyao5fmxwcvyl2cvkw4hn2t]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_g9vyao5fmxwcvyl2cvkw4hn2t, primary]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.portfolio_positions
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [portfolio, positions]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_wq6vljxbnadvd9kyax2n2vfs, fk_e6gv8j20ydaafsrhwvimqix3k]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_e6gv8j20ydaafsrhwvimqix3k, uk_wq6vljxbnadvd9kyax2n2vfs]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.portfolio_stakes
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [stakes, portfolio]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_q2q8fsgn6f6kterkbfsc33vnc, fk_gg9mqu5am8sba65wvah6bowk4]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_q2q8fsgn6f6kterkbfsc33vnc, fk_gg9mqu5am8sba65wvah6bowk4]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.position
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [market, portfolio, exchange, id, asset, version]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_f7foa02pae7jn067oyu128wrm, fk_of2dh8mim0n70tdiny7oyj7ib, fk_47vs0iaimuwvfjxbi791gjm80]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_f7foa02pae7jn067oyu128wrm, fk_of2dh8mim0n70tdiny7oyj7ib, fk_47vs0iaimuwvfjxbi791gjm80, primary]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.position_update
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [market, last_type, id, time, position, type, version]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_95qcokwwvmpl7yy6v072g8jy8, fk_bp8965bghp7ae5uo758v0p62k]
2015-08-03 17:50:30 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_95qcokwwvmpl7yy6v072g8jy8, fk_bp8965bghp7ae5uo758v0p62k, primary]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.prompt
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [margin_fee_method, symbol, margin, price_basis, traded_currency, volume_basis, version, tick_size, fee_rate, margin_method, fee_method, id, contract_size, tick_value]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: []
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.specific_order
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [entry_time, position_effect, emulation, execution_instruction, placement_count, fill_type, version, volume_count, parent_order, margin_type, market, remote_key, portfolio, time_received, comment, expiration, id, time, limit_price_count, panic_force]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_mpgexwbtqjc4as6sc9ahihqln, fk_3ovh0s0m3o3oe5y1v7gm3j1d0]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [specific_orderuk_pfc5uvg0u2tdtrtgwq9p50tgn, specific_orderuk_sb9a6t3qikue8dtuwn7ju5uei, specific_orderuk_e0gui2lqm0kyyua6rtbvheyu5, primary]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.stake
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [stake, owner, portfolio, id, version]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_7emmidtfhutcjvm20da0pirpu, fk_2nyltxk5lyuhrmhc6r0ustns0]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_7emmidtfhutcjvm20da0pirpu, fk_2nyltxk5lyuhrmhc6r0ustns0, primary]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.strategy_instance
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [portfolio, id, module_name, version]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_78y9ysg7j6jq0nvyufx505g5i]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_78y9ysg7j6jq0nvyufx505g5i, primary]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.strategy_instance_config
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [strategy_instance, config_key, config]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_60nm0bu9carvgeoh535buhihq]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.tick
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [remote_key, market, start_instant, time_received, price_count, last_book, id, time, version, volume_count]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_4tysbo6v9o6l917yek17px9p8, fk_1s4mo583fm863i68wk5mjyf2o]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_4tysbo6v9o6l917yek17px9p8, fk_1s4mo583fm863i68wk5mjyf2o, primary]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.trade
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [remote_key, market, time_received, price_count, id, time, version, volume_count]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_3e8g41qfm2egglm1xj17ubooc]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_8kdomlkbs1vrbuemp0x8o1blf, uk_3e8g41qfm2egglm1xj17ubooc, uk_9o7pvdorduhxo0p2855fr2w2t, uk_69n5t8v03i6jyoqx7q4x0os3u, uk_ajh0h97g35whr3rm5tve50yhc, primary]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.transaction
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [position_effect, type, fill, version, amount_count, commission_currency, market, portfolio, price_count, currency, exchange, id, time, commission_count, asset, order]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_lucasenbcynptutvbhodxn1ln, fk_q5y4q26rn1or55bx6nlfmh1ne, fk_3lmhbk66eufissa0y7vubj366, fk_f3ilsvdq06ndnmim591yo2cia]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_lucasenbcynptutvbhodxn1ln, fk_q5y4q26rn1or55bx6nlfmh1ne, uk_8dfwvrlg6wtv9wfyeqca1ybtb, fk_3lmhbk66eufissa0y7vubj366, fk_f3ilsvdq06ndnmim591yo2cia, primary]
2015-08-03 17:50:31 [main] INFO  o.h.tool.hbm2ddl.SchemaUpdate - HHH000232: Schema update complete
2015-08-03 17:50:31 [net.sf.ehcache.CacheManager@2d411abb] INFO  net.sf.ehcache.util.UpdateChecker - New update(s) found: 2.4.7 [http://www.terracotta.org/confluence/display/release/Release+Notes+Ehcache+Core+2.4]. Please check http://ehcache.org for the latest version.
Exception in thread "main" java.lang.Error: Could not initialize db
        at org.cryptocoinpartners.util.PersistUtil.init(PersistUtil.java:789)
        at org.cryptocoinpartners.util.PersistUtil.init(PersistUtil.java:701)
        at org.cryptocoinpartners.bin.Main.main(Main.java:105)
Caused by: java.lang.ExceptionInInitializerError
        at org.cryptocoinpartners.util.PersistUtil.ensureSingletonsExist(Persist
Util.java:813)
        at org.cryptocoinpartners.util.PersistUtil.init(PersistUtil.java:782)
        ... 2 more
Caused by: javax.persistence.NoResultException: No entity found for query
        at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:4
98)
        at org.cryptocoinpartners.util.PersistUtil.queryOne(PersistUtil.java:615
)
        at org.cryptocoinpartners.schema.Currency.forSymbol(Currency.java:28)
        at org.cryptocoinpartners.schema.Prompt.forSymbolOrCreate(Prompt.java:15
6)
        at org.cryptocoinpartners.schema.Prompts.prompt(Prompts.java:18)
        at org.cryptocoinpartners.schema.Prompts.(Prompts.java:7)
        ... 4 more
timolson commented 9 years ago

Looks like an issue with Prompt and maybe FeeMethod. Maybe Douggie can help you. Perhaps these tables are not getting created in your database? The many-to-one relation between Prompt and FeeMethod looks incorrect, since FeeMethod is a raw enum, not a separate table? Perhaps this is causing errors in your system but not Douggie's.

Tikaszar commented 9 years ago

I do see a table entry in the db for Prompt, as well as a column for fee_method within the Prompt table. I'm not quite sure what you mean by the Many-to-One relation between Prompt and FeeMethod.

douggie commented 9 years ago

Hi Tikaszar,

Would you be able to run the following:

select * from currency select * from prompt

I suspect that the tables of default static are not getting populated, normally this is done via PersitUtil. ensureSingletonsExist() method, seems like it is having diffculty creating the various symbols as it can't find the currency symbols.

On Tue, Aug 4, 2015 at 12:53 AM, Tikaszar notifications@github.com wrote:

I do see a table entry in the db for Prompt, as well as a column for fee_method within the Prompt table. I'm not quite sure what you mean by the Many-to-One relation between Prompt and FeeMethod.

— Reply to this email directly or view it on GitHub https://github.com/timolson/cointrader/issues/124#issuecomment-127435744 .

Tikaszar commented 9 years ago

Hey Douggie,

I went ahead and ran the queries on Currency and Prompt, and both return 0 rows, so it does seem that the default information is not being properly populated.

douggie commented 9 years ago

humm. did you run the following

cointrader.sh reset-database

then try cointrader.sh save-data

should spring it all into action, does your user definitely have write access to the db?

On Tue, Aug 4, 2015 at 8:04 PM, Tikaszar notifications@github.com wrote:

Hey Douggie,

I went ahead and ran the queries on Currency and Prompt, and both return 0 rows, so it does seem that the default information is not being properly populated.

— Reply to this email directly or view it on GitHub https://github.com/timolson/cointrader/issues/124#issuecomment-127721150 .

Tikaszar commented 9 years ago

I've run both commands a few times again, same results. Right now I'm using the root user with no password, so read/write shouldn't be an issue I think (I've also tried a new user with privileges added and a new properties file). I wrote a small test app in c# to write/read from a test db and ran into no issues there.

douggie commented 9 years ago

let me try to recreate, will keep you posted.

On Tue, Aug 4, 2015 at 9:23 PM, Tikaszar notifications@github.com wrote:

I've run both commands a few times again, same results. Right now I'm using the root user with no password, so read/write shouldn't be an issue I think (I've also tried a new user with privileges added and a new properties file). I wrote a small test app in c# to write/read from a test db and ran into no issues there.

— Reply to this email directly or view it on GitHub https://github.com/timolson/cointrader/issues/124#issuecomment-127747822 .

Tikaszar commented 9 years ago

Awesome, thanks for the help by the way!

timolson commented 9 years ago

This could be a load-order issue. The order of class loading will specify the order of static method invocation. Maybe on Douggie and my machines, a different load order creates these rows in the database before the code in question gets triggered? I thought I wrote around this case but there is still a tangle between the singleton classes (Currencies) and PersistUtil... What JVM are you running? Can you try the Sun HotSpot VM (aka standard Oracle Java)

timolson commented 9 years ago

Also, try touching the Currencies and Prompts classes at the top of a main method, before PersistUtil is touched.

Tikaszar commented 9 years ago

I haven't changed the JVM from the default installed by the JDK (I'm still pretty new to Java, so haven't gotten that far yet). The log says I'm using Java HotSpot(TM) 64-Bit Server VM currently. I've added a touch for Currencies, Exchanges, and Prompts (copied the calls in PersistUtil.ensureSingletonsExist()) right above the PersistUtil.init() call in Main.java (line 108), doesn't seems to have an effect on the issue (if there is a better location to try let me know).

Tikaszar commented 9 years ago

So I've managed to sorta bypass this issue and get cointrader.sh save-data as well as the other setup commands to run by inserting BTC into the Currency table with arbitrary data. This works to populate the Currency, Exchange and Prompt tables. Unfortunately, if I run cointrader.sh reset-database, it breaks again and I have to re-insert BTC into the table. However, save-data as well as any command used in the console fail to execute properly and instead throw up some warnings. I don't see any data saving happening. watch btc.usd and unwatch btc.usd in the console also throw errors and don't display any ticker information. Here is the log from running console.sh save-data in this way (in case it may help):


2015-08-04 19:06:15 [main] WARN  o.cryptocoinpartners.util.ConfigUtil - Could not find configuration file "cointrader.properties"
2015-08-04 19:06:15 [main] DEBUG o.cryptocoinpartners.util.ConfigUtil - Combined Configuration:
awt.toolkit=sun.awt.windows.WToolkit
base.symbol=USD
command.path=
console.cursor=ct>
console.hisory.size=100
db.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
db.driver=com.mysql.jdbc.Driver
db.idle.test.period=3000
db.max.connection.age=3600
db.persist.retry=4
db.pool.growth=3
db.pool.size=3
db.test.connection=false
db.url=jdbc:mysql://localhost:3306/cointrader
db.username=root
faketicker.exchange=BITSTAMP
file.encoding.pkg=sun.io
file.encoding=Cp1252
file.separator=\
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
java.awt.printerjob=sun.awt.windows.WPrinterJob
java.class.path=target/cointrader-0.3.0-SNAPSHOT-jar-with-dependencies.jar
java.class.version=52.0
java.endorsed.dirs=C:\Program Files\Java\jre1.8.0_51\lib\endorsed
java.ext.dirs=C:\Program Files\Java\jre1.8.0_51\lib\ext;C:\WINDOWS\Sun\Java\lib\ext
java.home=C:\Program Files\Java\jre1.8.0_51
java.io.tmpdir=C:\Users\Ptolemy\AppData\Local\Temp\
java.library.path=c:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;c:\Users\Ptolemy\bin;.;C:\Program Files (x86)\Git\local\bin;C:\Program Files (x86)\Git\mingw\bin;C:\Program Files (x86)\Git\bin;d:\Program Files\ImageMagick-6.9.1-Q16;c:\Program Files (x86)\OpenSSH\bin;c:\Program Files (x86)\Skype\Phone\;c:\HashiCorp\Vagrant\bin;d:\Python34;c:\WINDOWS\system32;c:\WINDOWS;c:\WINDOWS\System32\Wbem;c:\WINDOWS\System32\WindowsPowerShell\v1.0\;c:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;c:\Program Files (x86)\AMD\ATI.ACE\Core-Static;d:\Maven 3.3.3\bin;c:\Program Files (x86)\MySQL\MySQL Fabric 1.5.4 & MySQL Utilities 1.5.4 1.5\;c:\Program Files (x86)\MySQL\MySQL Fabric 1.5.4 & MySQL Utilities 1.5.4 1.5\Doctrine extensions for PHP\;c:\ProgramData\Oracle\Java\javapath;c:\Program Files\MySQL\MySQL Server 5.6\bin;.
java.runtime.name=Java(TM) SE Runtime Environment
java.runtime.version=1.8.0_51-b16
java.specification.name=Java Platform API Specification
java.specification.vendor=Oracle Corporation
java.specification.version=1.8
java.vendor.url.bug=http://bugreport.sun.com/bugreport/
java.vendor.url=http://java.oracle.com/
java.vendor=Oracle Corporation
java.version=1.8.0_51
java.vm.info=mixed mode
java.vm.name=Java HotSpot(TM) 64-Bit Server VM
java.vm.specification.name=Java Virtual Machine Specification
java.vm.specification.vendor=Oracle Corporation
java.vm.specification.version=1.8
java.vm.vendor=Oracle Corporation
java.vm.version=25.51-b03
jline.WindowsTerminal.directConsole=false
line.separator=
module.path=
os.arch=amd64
os.name=Windows 8.1
os.version=6.3
path.separator=;
project.artifactId=cointrader
project.groupId=org.cryptocoinpartners
project.version=0.3.0-SNAPSHOT
sun.arch.data.model=64
sun.boot.class.path=C:\Program Files\Java\jre1.8.0_51\lib\resources.jar;C:\Program Files\Java\jre1.8.0_51\lib\rt.jar;C:\Program Files\Java\jre1.8.0_51\lib\sunrsasign.jar;C:\Program Files\Java\jre1.8.0_51\lib\jsse.jar;C:\Program Files\Java\jre1.8.0_51\lib\jce.jar;C:\Program Files\Java\jre1.8.0_51\lib\charsets.jar;C:\Program Files\Java\jre1.8.0_51\lib\jfr.jar;C:\Program Files\Java\jre1.8.0_51\classes
sun.boot.library.path=C:\Program Files\Java\jre1.8.0_51\bin
sun.cpu.endian=little
sun.cpu.isalist=amd64
sun.desktop=windows
sun.io.unicode.encoding=UnicodeLittle
sun.java.command=target/cointrader-0.3.0-SNAPSHOT-jar-with-dependencies.jar save-data
sun.java.launcher=SUN_STANDARD
sun.jnu.encoding=Cp1252
sun.management.compiler=HotSpot 64-Bit Tiered Compilers
sun.os.patch.level=
sun.stderr.encoding=cp437
sun.stdout.encoding=cp437
user.country=US
user.dir=D:\Documents\JavaBot\cointrader
user.home=C:\Users\Ptolemy
user.language=en
user.name=Ptolemy
user.script=
user.timezone=America/New_York
user.variant=
xchange.bitfinex.class=com.xeiam.xchange.bitfinex.v1.BitfinexExchange
xchange.bitfinex.helper.class=BitfinexHelper
xchange.bitfinex.rate.period=5
xchange.bitfinex.rate.queries=3
xchange.bitstamp.class=com.xeiam.xchange.bitstamp.BitstampExchange
xchange.bitstamp.rate.period=5
xchange.bitstamp.rate.queries=1
xchange.btcchina.class=com.xeiam.xchange.btcchina.BTCChinaExchange
xchange.btcchina.rate.period=2
xchange.btcchina.rate.queries=1
xchange.btce.class=com.xeiam.xchange.btce.v3.BTCEExchange
xchange.btce.rate.period=5
xchange.btce.rate.queries=3
xchange.bter.class=com.xeiam.xchange.bter.BTERExchange
xchange.bter.rate.period=5
xchange.bter.rate.queries=3
xchange.campbx.class=com.xeiam.xchange.campbx.CampBXExchange
xchange.campbx.rate.period=1
xchange.campbx.rate.queries=1
xchange.coinbase.class=com.xeiam.xchange.coinbase.CoinbaseExchange
xchange.coinbase.rate.period=5
xchange.coinbase.rate.queries=1
xchange.cryptsy.class=com.xeiam.xchange.cryptsy.CryptsyExchange
xchange.cryptsy.rate.period=2
xchange.cryptsy.rate.queries=1
xchange.okcoin.class=com.xeiam.xchange.okcoin.OkCoinExchange
xchange.okcoin.exchangeSpecificParameters.futures=false
xchange.okcoin.exchangeSpecificParameters.intl=true
xchange.okcoin.rate.period=5
xchange.okcoin.rate.queries=3
xchange.okcoin_month.class=com.xeiam.xchange.okcoin.OkCoinExchange
xchange.okcoin_month.exchangeSpecificParameters.futures=true
xchange.okcoin_month.exchangeSpecificParameters.intl=true
xchange.okcoin_month.rate.period=5
xchange.okcoin_month.rate.queries=3
xchange.okcoin_nextweek.class=com.xeiam.xchange.okcoin.OkCoinExchange
xchange.okcoin_nextweek.exchangeSpecificParameters.futures=true
xchange.okcoin_nextweek.exchangeSpecificParameters.intl=true
xchange.okcoin_nextweek.rate.period=5
xchange.okcoin_nextweek.rate.queries=3
xchange.okcoin_quarter.class=com.xeiam.xchange.okcoin.OkCoinExchange
xchange.okcoin_quarter.exchangeSpecificParameters.futures=true
xchange.okcoin_quarter.exchangeSpecificParameters.intl=true
xchange.okcoin_quarter.rate.period=5
xchange.okcoin_quarter.rate.queries=3
xchange.okcoin_thisweek.class=com.xeiam.xchange.okcoin.OkCoinExchange
xchange.okcoin_thisweek.exchangeSpecificParameters.futures=true
xchange.okcoin_thisweek.exchangeSpecificParameters.intl=true
xchange.okcoin_thisweek.rate.period=5
xchange.okcoin_thisweek.rate.queries=3
2015-08-04 19:06:17 [main] INFO  org.reflections.Reflections - Reflections took 2300 ms to scan 1 urls, producing 5558 keys and 22046 values 
2015-08-04 19:06:17 [main] INFO  org.cryptocoinpartners.persist - initializing persistence
2015-08-04 19:06:17 [main] WARN  o.hibernate.ejb.HibernatePersistence - HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead.
2015-08-04 19:06:17 [main] WARN  o.hibernate.ejb.HibernatePersistence - HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead.
2015-08-04 19:06:17 [main] WARN  o.hibernate.ejb.HibernatePersistence - HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead.
2015-08-04 19:06:18 [main] INFO  o.h.jpa.internal.util.LogHelper - HHH000204: Processing PersistenceUnitInfo [
    name: org.cryptocoinpartners.schema
    ...]
2015-08-04 19:06:18 [main] INFO  org.hibernate.Version - HHH000412: Hibernate Core {4.3.6.Final}
2015-08-04 19:06:18 [main] INFO  org.hibernate.cfg.Environment - HHH000206: hibernate.properties not found
2015-08-04 19:06:18 [main] INFO  org.hibernate.cfg.Environment - HHH000021: Bytecode provider name : javassist
2015-08-04 19:06:20 [main] INFO  o.h.annotations.common.Version - HCANN000001: Hibernate Commons Annotations {4.0.5.Final}
2015-08-04 19:06:20 [main] INFO  o.h.e.j.c.i.ConnectionProviderInitiator - HHH000130: Instantiating explicit connection provider: org.hibernate.connection.C3P0ConnectionProvider
2015-08-04 19:06:20 [main] INFO  o.h.c.i.C3P0ConnectionProvider - HHH010002: C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/cointrader
2015-08-04 19:06:20 [main] INFO  o.h.c.i.C3P0ConnectionProvider - HHH000046: Connection properties: {user=root, password=****, autocommit=true, release_mode=auto}
2015-08-04 19:06:20 [main] INFO  o.h.c.i.C3P0ConnectionProvider - HHH000006: Autocommit mode: true
2015-08-04 19:06:20 [MLog-Init-Reporter] INFO  com.mchange.v2.log.MLog - MLog clients using slf4j logging.
2015-08-04 19:06:20 [main] INFO  com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.5 [built 02-January-2015 13:25:04 -0500; debug? true; trace: 10]
2015-08-04 19:06:20 [main] INFO  c.m.v.c.i.AbstractPoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@936e97d4 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@ad41e439 [ acquireIncrement -> 3, acquireRetryAttempts -> 0, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge1579a1xmtpcqskn3hv|7339450, idleConnectionTestPeriod -> 0, initialPoolSize -> 10, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 3, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 10, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@86fd0283 [ description -> null, driverClass -> null, factoryClassLocation -> null, forceUseNamedDriverClass -> false, identityToken -> 1hge1579a1xmtpcqskn3hv|1ffd80f0, jdbcUrl -> jdbc:mysql://localhost:3306/cointrader, properties -> {user=******, password=******, autocommit=true, release_mode=auto} ], preferredTestQuery -> SELECT 1 from exchange, privilegeSpawnedThreads -> false, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, extensions -> {}, factoryClassLocation -> null, identityToken -> 1hge1579a1xmtpcqskn3hv|1754eb35, numHelperThreads -> 3 ]
2015-08-04 19:06:20 [main] WARN  c.m.v.resourcepool.BasicResourcePool - Bad pool size config, min 10 > max 3. Using 3 as min.
2015-08-04 19:06:20 [main] WARN  c.m.v.resourcepool.BasicResourcePool - Bad pool size config, start 10 > max 3. Using 3 as start.
2015-08-04 19:06:21 [main] INFO  org.hibernate.dialect.Dialect - HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect
2015-08-04 19:06:21 [main] INFO  o.h.h.i.a.ASTQueryTranslatorFactory - HHH000397: Using ASTQueryTranslatorFactory
2015-08-04 19:06:21 [main] WARN  n.s.e.config.ConfigurationFactory - No configuration found. Configuring ehcache from ehcache-failsafe.xml  found in the classpath: jar:file:/D:/Documents/JavaBot/cointrader/target/cointrader-0.3.0-SNAPSHOT-jar-with-dependencies.jar!/ehcache-failsafe.xml
2015-08-04 19:06:21 [main] INFO  o.h.cache.spi.UpdateTimestampsCache - HHH000250: Starting update timestamps cache at region: org.hibernate.cache.spi.UpdateTimestampsCache
2015-08-04 19:06:21 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.spi.UpdateTimestampsCache]; using defaults.
2015-08-04 19:06:21 [main] INFO  o.h.c.internal.StandardQueryCache - HHH000248: Starting query cache at region: org.hibernate.cache.internal.StandardQueryCache
2015-08-04 19:06:21 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.internal.StandardQueryCache]; using defaults.
2015-08-04 19:06:21 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Fill]; using defaults.
2015-08-04 19:06:21 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Listing]; using defaults.
2015-08-04 19:06:21 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.PortfolioManager]; using defaults.
2015-08-04 19:06:21 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Order]; using defaults.
2015-08-04 19:06:21 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Market]; using defaults.
2015-08-04 19:06:21 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Position]; using defaults.
2015-08-04 19:06:21 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Transaction]; using defaults.
2015-08-04 19:06:21 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Asset]; using defaults.
2015-08-04 19:06:21 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Portfolio]; using defaults.
2015-08-04 19:06:21 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Stake]; using defaults.
2015-08-04 19:06:21 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Exchange]; using defaults.
2015-08-04 19:06:21 [main] WARN  o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Prompt]; using defaults.
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.SchemaUpdate - HHH000228: Running hbm2ddl schema update
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.SchemaUpdate - HHH000102: Fetching database metadata
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.SchemaUpdate - HHH000396: Updating schema
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.order_children
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [children, order]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: []
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_d42vf63qki5m3f2yfc39gix5d]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.adjustment
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [authorization, time_applied, id, version]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_54ru1mkfaf05t3sw7qajriyjq]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_54ru1mkfaf05t3sw7qajriyjq, primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.adjustment_deltas
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [adjustment, deltas]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_hnvmj4sauvd6bwou2u9838wx3, fk_pkvmcu7o8vd9w9c0ogcynvp1j]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_hnvmj4sauvd6bwou2u9838wx3, fk_pkvmcu7o8vd9w9c0ogcynvp1j]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.authorization
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [notes, id, version]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: []
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.book
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [ask_price_as_double, parent, bid_deletions_blob, version, ask_insertions_blob, remote_key, market, bid_price_as_double, ask_volume_as_double, bid_volume_as_double, ask_deletions_blob, time_received, bid_insertions_blob, id, time]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_i9o6ht1d1lk975n7i4h8slkaw, fk_boctr5mp6fppkh67gxjp4xqos]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_i9o6ht1d1lk975n7i4h8slkaw, uk_nfugogi72k3uaprxstuhwbf7u, fk_boctr5mp6fppkh67gxjp4xqos, uk_f8mycxusp2jqgvehm1vkmtefe, primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.currency
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [symbol, fiat, id, basis, version]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: []
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.exchange
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [margin_fee_method, symbol, margin, fee_method, margin_fee_rate, id, version, fee_rate]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: []
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.fill
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [stop_price_count, open_volume_count, target_price_count, version, volume_count, remote_key, market, time_received, portfolio, price_count, id, time, position, order]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_lar4y36pcsm03uxlj4wbu1fsq, fk_sfk9h7xr4ckkp6fxrv9hcwsyl, fk_n3lj0gejdepujkfv9oxcwr7oh, fk_7gs0r7diitihi47sguavpflhn]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_lar4y36pcsm03uxlj4wbu1fsq, fk_sfk9h7xr4ckkp6fxrv9hcwsyl, fk_n3lj0gejdepujkfv9oxcwr7oh, primary, fk_7gs0r7diitihi47sguavpflhn]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.general_order
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [limit_price_decimal, entry_time, position_effect, emulation, execution_instruction, fill_type, version, parent_order, volume_decimal, margin_type, market, stop_amount_decimal, target_amount_decimal, portfolio, stop_price_decimal, target_price_decimal, trailing_stop_price_decimal, comment, expiration, id, time, listing, panic_force]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_5n09idi1cl4rbt9uswvm2gp8, fk_oegy99vbh4n958dct2c67v0sr, fk_b7wqc8o55t2f10sfyi7byfyxv]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [general_orderuk_pfc5uvg0u2tdtrtgwq9p50tgn, general_orderuk_sb9a6t3qikue8dtuwn7ju5uei, fk_oegy99vbh4n958dct2c67v0sr, general_orderuk_e0gui2lqm0kyyua6rtbvheyu5, primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.listing
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [quote, id, version, prompt, base]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_wbsljbkb77noa0xducg43x8f]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_wbsljbkb77noa0xducg43x8f, uk_b109latdocdl8cgu6jgagabep, uk_fu2dx1ue0cs9sytm3ts2x8dld, primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.market
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [price_basis, active, exchange, id, volume_basis, listing, version]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_rm6ipgm2qgxvjwpx3rmrud2yd, fk_oeh8osopuxors0whhhyw0exrq]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_p7eyg8ihn8eathob3ph6lj6yk, uk_oeh8osopuxors0whhhyw0exrq, uk_rm6ipgm2qgxvjwpx3rmrud2yd, primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.market_data_gap_error
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [exception, market, gap_interval_start, gap_interval_end, id, time, version]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_srsibgckoty6rnljq7oacgeeb]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary, fk_srsibgckoty6rnljq7oacgeeb]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.offer
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [remote_key, market, time_received, price_count, id, time, version, volume_count]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_qgfii77q46573q0k6d5urno2b]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_qgfii77q46573q0k6d5urno2b, primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.order_update
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [sequence, last_state, id, time, state, version, order]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: []
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_jq7kng418cnfaqvll20cfw0n1, primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.owner
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [portfolio, name, id, version]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_n0jse4c6ubwbybwgrs1t8sqtn]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_n0jse4c6ubwbybwgrs1t8sqtn, primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.owner_stakes
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [owner, stakes]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_hkdupubd782wg400ixlx3gn12, fk_ls73ux93q48x1k5a75lqlflhv]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_hkdupubd782wg400ixlx3gn12, uk_ls73ux93q48x1k5a75lqlflhv]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.portfolio
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [base_asset, name, id, version]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: []
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.portfolio_manager
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [portfolio, id, version]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_g9vyao5fmxwcvyl2cvkw4hn2t]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_g9vyao5fmxwcvyl2cvkw4hn2t, primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.portfolio_positions
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [portfolio, positions]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_wq6vljxbnadvd9kyax2n2vfs, fk_e6gv8j20ydaafsrhwvimqix3k]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_e6gv8j20ydaafsrhwvimqix3k, uk_wq6vljxbnadvd9kyax2n2vfs]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.portfolio_stakes
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [stakes, portfolio]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_q2q8fsgn6f6kterkbfsc33vnc, fk_gg9mqu5am8sba65wvah6bowk4]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_q2q8fsgn6f6kterkbfsc33vnc, fk_gg9mqu5am8sba65wvah6bowk4]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.position
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [market, portfolio, exchange, id, asset, version]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_f7foa02pae7jn067oyu128wrm, fk_of2dh8mim0n70tdiny7oyj7ib, fk_47vs0iaimuwvfjxbi791gjm80]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_f7foa02pae7jn067oyu128wrm, fk_of2dh8mim0n70tdiny7oyj7ib, fk_47vs0iaimuwvfjxbi791gjm80, primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.position_update
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [market, last_type, id, time, position, type, version]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_95qcokwwvmpl7yy6v072g8jy8, fk_bp8965bghp7ae5uo758v0p62k]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_95qcokwwvmpl7yy6v072g8jy8, fk_bp8965bghp7ae5uo758v0p62k, primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.prompt
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [margin_fee_method, symbol, margin, price_basis, traded_currency, volume_basis, version, tick_size, fee_rate, margin_method, fee_method, id, contract_size, tick_value]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: []
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.specific_order
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [entry_time, position_effect, emulation, execution_instruction, placement_count, fill_type, version, volume_count, parent_order, margin_type, market, remote_key, portfolio, time_received, comment, expiration, id, time, limit_price_count, panic_force]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_mpgexwbtqjc4as6sc9ahihqln, fk_3ovh0s0m3o3oe5y1v7gm3j1d0]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [specific_orderuk_pfc5uvg0u2tdtrtgwq9p50tgn, specific_orderuk_sb9a6t3qikue8dtuwn7ju5uei, specific_orderuk_e0gui2lqm0kyyua6rtbvheyu5, primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.stake
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [stake, owner, portfolio, id, version]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_7emmidtfhutcjvm20da0pirpu, fk_2nyltxk5lyuhrmhc6r0ustns0]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_7emmidtfhutcjvm20da0pirpu, fk_2nyltxk5lyuhrmhc6r0ustns0, primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.strategy_instance
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [portfolio, id, module_name, version]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_78y9ysg7j6jq0nvyufx505g5i]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_78y9ysg7j6jq0nvyufx505g5i, primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.strategy_instance_config
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [strategy_instance, config_key, config]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_60nm0bu9carvgeoh535buhihq]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.tick
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [remote_key, market, start_instant, time_received, price_count, last_book, id, time, version, volume_count]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_4tysbo6v9o6l917yek17px9p8, fk_1s4mo583fm863i68wk5mjyf2o]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_4tysbo6v9o6l917yek17px9p8, fk_1s4mo583fm863i68wk5mjyf2o, primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.trade
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [remote_key, market, time_received, price_count, id, time, version, volume_count]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_3e8g41qfm2egglm1xj17ubooc]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_8kdomlkbs1vrbuemp0x8o1blf, uk_3e8g41qfm2egglm1xj17ubooc, uk_9o7pvdorduhxo0p2855fr2w2t, uk_69n5t8v03i6jyoqx7q4x0os3u, uk_ajh0h97g35whr3rm5tve50yhc, primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.transaction
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [position_effect, type, fill, version, amount_count, commission_currency, market, portfolio, price_count, currency, exchange, id, time, commission_count, asset, order]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_lucasenbcynptutvbhodxn1ln, fk_q5y4q26rn1or55bx6nlfmh1ne, fk_3lmhbk66eufissa0y7vubj366, fk_f3ilsvdq06ndnmim591yo2cia]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_lucasenbcynptutvbhodxn1ln, fk_q5y4q26rn1or55bx6nlfmh1ne, uk_8dfwvrlg6wtv9wfyeqca1ybtb, fk_3lmhbk66eufissa0y7vubj366, fk_f3ilsvdq06ndnmim591yo2cia, primary]
2015-08-04 19:06:22 [main] INFO  o.h.tool.hbm2ddl.SchemaUpdate - HHH000232: Schema update complete
2015-08-04 19:06:22 [net.sf.ehcache.CacheManager@7ba194df] INFO  net.sf.ehcache.util.UpdateChecker - New update(s) found: 2.4.7 [http://www.terracotta.org/confluence/display/release/Release+Notes+Ehcache+Core+2.4]. Please check http://ehcache.org for the latest version.
2015-08-04 19:06:23 [main] INFO  c.e.e.c.s.EPServiceProviderImpl - Initializing engine URI 'default' version 4.9.0
2015-08-04 19:06:23 [main] WARN  c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DecimalAmount org.cryptocoinpartners.schema.GeneralOrder.getLimitPrice()
2015-08-04 19:06:23 [main] WARN  c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DecimalAmount org.cryptocoinpartners.schema.GeneralOrder.getStopAmount()
2015-08-04 19:06:23 [main] WARN  c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DecimalAmount org.cryptocoinpartners.schema.GeneralOrder.getStopPrice()
2015-08-04 19:06:23 [main] WARN  c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DecimalAmount org.cryptocoinpartners.schema.GeneralOrder.getTargetAmount()
2015-08-04 19:06:23 [main] WARN  c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DecimalAmount org.cryptocoinpartners.schema.GeneralOrder.getTargetPrice()
2015-08-04 19:06:23 [main] WARN  c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DecimalAmount org.cryptocoinpartners.schema.GeneralOrder.getTrailingStopPrice()
2015-08-04 19:06:23 [main] WARN  c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DecimalAmount org.cryptocoinpartners.schema.GeneralOrder.getVolume()
2015-08-04 19:06:23 [main] WARN  c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DiscreteAmount org.cryptocoinpartners.schema.SpecificOrder.getLimitPrice()
2015-08-04 19:06:23 [main] WARN  c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DiscreteAmount org.cryptocoinpartners.schema.SpecificOrder.getStopAmount()
2015-08-04 19:06:23 [main] WARN  c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DiscreteAmount org.cryptocoinpartners.schema.SpecificOrder.getStopPrice()
2015-08-04 19:06:23 [main] WARN  c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DiscreteAmount org.cryptocoinpartners.schema.SpecificOrder.getTargetAmount()
2015-08-04 19:06:23 [main] WARN  c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DiscreteAmount org.cryptocoinpartners.schema.SpecificOrder.getTargetPrice()
2015-08-04 19:06:23 [main] WARN  c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DiscreteAmount org.cryptocoinpartners.schema.SpecificOrder.getTrailingStopPrice()
2015-08-04 19:06:23 [main] WARN  c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DiscreteAmount org.cryptocoinpartners.schema.SpecificOrder.getUnfilledVolume()
2015-08-04 19:06:23 [main] WARN  c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DiscreteAmount org.cryptocoinpartners.schema.SpecificOrder.getVolume()
2015-08-04 19:06:23 [main] DEBUG o.cryptocoinpartners.module.Context - no module file found for SaveMarketData.epl on classpath. Please ensure SaveMarketData.epl is in the resources directory.
2015-08-04 19:06:23 [main] DEBUG o.cryptocoinpartners.module.Context - subscribing public static void org.cryptocoinpartners.module.SaveMarketData.handleMarketData(org.cryptocoinpartners.schema.MarketData) with statement "select * from MarketData.std:lastevent()"
2015-08-04 19:06:24 [main] DEBUG o.cryptocoinpartners.module.Context - no module file found for XchangeData.epl on classpath. Please ensure XchangeData.epl is in the resources directory.
douggie commented 9 years ago

just checked in a fix, let me know how you get on.

On Wed, Aug 5, 2015 at 12:27 AM, Tikaszar notifications@github.com wrote:

So I've managed to sorta bypass this issue and get cointrader.sh save-data as well as the other setup commands to run by inserting BTC into the Currency table with arbitrary data. This works to populate the Currency, Exchange and Prompt tables. Unfortunately, if I run cointrader.sh reset-database, it breaks again and I have to re-insert BTC into the table. However, save-data as well as any command used in the console fail to execute properly and instead throw up some warnings. I don't see any data saving happening. watch btc.usd and unwatch btc.usd in the console also throw errors and don't display any ticker information. Here is the log from running console.sh save-data in this way (in case it may help):

2015-08-04 19:06:15 [main] WARN o.cryptocoinpartners.util.ConfigUtil - Could not find configuration file "cointrader.properties" 2015-08-04 19:06:15 [main] DEBUG o.cryptocoinpartners.util.ConfigUtil - Combined Configuration: awt.toolkit=sun.awt.windows.WToolkit base.symbol=USD command.path= console.cursor=ct> console.hisory.size=100 db.dialect=org.hibernate.dialect.MySQL5InnoDBDialect db.driver=com.mysql.jdbc.Driver db.idle.test.period=3000 db.max.connection.age=3600 db.persist.retry=4 db.pool.growth=3 db.pool.size=3 db.test.connection=false db.url=jdbc:mysql://localhost:3306/cointrader db.username=root faketicker.exchange=BITSTAMP file.encoding.pkg=sun.io file.encoding=Cp1252 file.separator=\ java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment java.awt.printerjob=sun.awt.windows.WPrinterJob java.class.path=target/cointrader-0.3.0-SNAPSHOT-jar-with-dependencies.jar java.class.version=52.0 java.endorsed.dirs=C:\Program Files\Java\jre1.8.0_51\lib\endorsed java.ext.dirs=C:\Program Files\Java\jre1.8.0_51\lib\ext;C:\WINDOWS\Sun\Java\lib\ext java.home=C:\Program Files\Java\jre1.8.0_51 java.io.tmpdir=C:\Users\Ptolemy\AppData\Local\Temp\ java.library.path=c:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;c:\Users\Ptolemy\bin;.;C:\Program Files (x86)\Git\local\bin;C:\Program Files (x86)\Git\mingw\bin;C:\Program Files (x86)\Git\bin;d:\Program Files\ImageMagick-6.9.1-Q16;c:\Program Files (x86)\OpenSSH\bin;c:\Program Files (x86)\Skype\Phone\;c:\HashiCorp\Vagrant\bin;d:\Python34;c:\WINDOWS\system32;c:\WINDOWS;c:\WINDOWS\System32\Wbem;c:\WINDOWS\System32\WindowsPowerShell\v1.0\;c:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;c:\Program Files (x86)\AMD\ATI.ACE\Core-Static;d:\Maven 3.3.3\bin;c:\Program Files (x86)\MySQL\MySQL Fabric 1.5.4 & MySQL Utilities 1.5.4 1.5\;c:\Program Files (x86)\MySQL\MySQL Fabric 1.5.4 & MySQL Utilities 1.5.4 1.5\Doctrine extensions for PHP\;c:\ProgramData\Oracle\Java\javapath;c:\Program Files\MySQL\MySQL Server 5.6\bin;. java.runtime.name=Java(TM) SE Runtime Environment java.runtime.version=1.8.0_51-b16java.specification.name=Java Platform API Specification java.specification.vendor=Oracle Corporation java.specification.version=1.8 java.vendor.url.bug=http://bugreport.sun.com/bugreport/ java.vendor.url=http://java.oracle.com/ java.vendor=Oracle http://java.oracle.com/java.vendor=Oracle Corporation java.version=1.8.0_51java.vm.info=mixed modejava.vm.name=Java HotSpot(TM) 64-Bit Server VMjava.vm.specification.name=Java Virtual Machine Specification java.vm.specification.vendor=Oracle Corporation java.vm.specification.version=1.8 java.vm.vendor=Oracle Corporation java.vm.version=25.51-b03 jline.WindowsTerminal.directConsole=false line.separator= module.path= os.arch=amd64os.name=Windows 8.1 os.version=6.3 path.separator=; project.artifactId=cointrader project.groupId=org.cryptocoinpartners project.version=0.3.0-SNAPSHOT sun.arch.data.model=64 sun.boot.class.path=C:\Program Files\Java\jre1.8.0_51\lib\resources.jar;C:\Program Files\Java\jre1.8.0_51\lib\rt.jar;C:\Program Files\Java\jre1.8.0_51\lib\sunrsasign.jar;C:\Program Files\Java\jre1.8.0_51\lib\jsse.jar;C:\Program Files\Java\jre1.8.0_51\lib\jce.jar;C:\Program Files\Java\jre1.8.0_51\lib\charsets.jar;C:\Program Files\Java\jre1.8.0_51\lib\jfr.jar;C:\Program Files\Java\jre1.8.0_51\classes sun.boot.library.path=C:\Program Files\Java\jre1.8.0_51\bin sun.cpu.endian=little sun.cpu.isalist=amd64 sun.desktop=windows sun.io.unicode.encoding= UnicodeLittle sun.java.command=target/cointrader-0.3.0-SNAPSHOT-jar-with-dependencies.jar save-data sun.java.launcher=SUN_STANDARD sun.jnu.encoding=Cp1252 sun.management.compiler=HotSpot 64-Bit Tiered Compilers sun.os.patch.level= sun.stderr.encoding=cp437 sun.stdout.encoding=cp437 user.country=US user.dir=D:\Documents\JavaBot\cointrader user.home=C:\Users\Ptolemy user.language=en user.name=Ptolemy user.script= user.timezone=America/New_York user.variant= xchange.bitfinex.class=com.xeiam.xchange.bitfinex.v1.BitfinexExchange xchange.bitfinex.helper.class=BitfinexHelper xchange.bitfinex.rate.period=5 xchange.bitfinex.rate.queries=3 xchange.bitstamp.class=com.xeiam.xchange.bitstamp.BitstampExchange xchange.bitstamp.rate.period=5 xchange.bitstamp.rate.queries=1 xchange.btcchina.class=com.xeiam.xchange.btcchina.BTCChinaExchange xchange.btcchina.rate.period=2 xchange.btcchina.rate.queries=1 xchange.btce.class=com.xeiam.xchange.btce.v3.BTCEExchange xchange.btce.rate.period=5 xchange.btce.rate.queries=3 xchange.bter.class=com.xeiam.xchange.bter.BTERExchange xchange.bter.rate.period=5 xchange.bter.rate.queries=3 xchange.campbx.class=com.xeiam.xchange.campbx.CampBXExchange xchange.campbx.rate.period=1 xchange.campbx.rate.queries=1 xchange.coinbase.class=com.xeiam.xchange.coinbase.CoinbaseExchange xchange.coinbase.rate.period=5 xchange.coinbase.rate.queries=1 xchange.cryptsy.class=com.xeiam.xchange.cryptsy.CryptsyExchange xchange.cryptsy.rate.period=2 xchange.cryptsy.rate.queries=1 xchange.okcoin.class=com.xeiam.xchange.okcoin.OkCoinExchange xchange.okcoin.exchangeSpecificParameters.futures=false xchange.okcoin.exchangeSpecificParameters.intl=true xchange.okcoin.rate.period=5 xchange.okcoin.rate.queries=3 xchange.okcoin_month.class=com.xeiam.xchange.okcoin.OkCoinExchange xchange.okcoin_month.exchangeSpecificParameters.futures=true xchange.okcoin_month.exchangeSpecificParameters.intl=true xchange.okcoin_month.rate.period=5 xchange.okcoin_month.rate.queries=3 xchange.okcoin_nextweek.class=com.xeiam.xchange.okcoin.OkCoinExchange xchange.okcoin_nextweek.exchangeSpecificParameters.futures=true xchange.okcoin_nextweek.exchangeSpecificParameters.intl=true xchange.okcoin_nextweek.rate.period=5 xchange.okcoin_nextweek.rate.queries=3 xchange.okcoin_quarter.class=com.xeiam.xchange.okcoin.OkCoinExchange xchange.okcoin_quarter.exchangeSpecificParameters.futures=true xchange.okcoin_quarter.exchangeSpecificParameters.intl=true xchange.okcoin_quarter.rate.period=5 xchange.okcoin_quarter.rate.queries=3 xchange.okcoin_thisweek.class=com.xeiam.xchange.okcoin.OkCoinExchange xchange.okcoin_thisweek.exchangeSpecificParameters.futures=true xchange.okcoin_thisweek.exchangeSpecificParameters.intl=true xchange.okcoin_thisweek.rate.period=5 xchange.okcoin_thisweek.rate. queries=3

2015-08-04 19:06:17 [main] INFO org.reflections.Reflections - Reflections took 2300 ms to scan 1 urls, producing 5558 keys and 22046 values 2015-08-04 19:06:17 [main] INFO org.cryptocoinpartners.persist - initializing persistence 2015-08-04 19:06:17 [main] WARN o.hibernate.ejb.HibernatePersistence - HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead. 2015-08-04 19:06:17 [main] WARN o.hibernate.ejb.HibernatePersistence - HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead. 2015-08-04 19:06:17 [main] WARN o.hibernate.ejb.HibernatePersistence - HHH015016: Encountered a deprecated javax.persistence.spi.PersistenceProvider [org.hibernate.ejb.HibernatePersistence]; use [org.hibernate.jpa.HibernatePersistenceProvider] instead. 2015-08-04 19:06:18 [main] INFO o.h.jpa.internal.util.LogHelper - HHH000204: Processing PersistenceUnitInfo [ name: org.cryptocoinpartners.schema ...] 2015-08-04 19:06:18 [main] INFO org.hibernate.Version - HHH000412: Hibernate Core {4.3.6.Final} 2015-08-04 19:06:18 [main] INFO org.hibernate.cfg.Environment - HHH000206: hibernate.properties not found 2015-08-04 19:06:18 [main] INFO org.hibernate.cfg.Environment - HHH000021: Bytecode provider name : javassist 2015-08-04 19:06:20 [main] INFO o.h.annotations.common.Version - HCANN000001: Hibernate Commons Annotations {4.0.5.Final} 2015-08-04 19:06:20 [main] INFO o.h.e.j.c.i.ConnectionProviderInitiator - HHH000130: Instantiating explicit connection provider: org.hibernate.connection.C3P0ConnectionProvider 2015-08-04 19:06:20 [main] INFO o.h.c.i.C3P0ConnectionProvider - HHH010002: C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/cointrader 2015-08-04 19:06:20 [main] INFO o.h.c.i.C3P0ConnectionProvider - HHH000046: Connection properties: {user=root, password=*_, autocommit=true, releasemode=auto} 2015-08-04 19:06:20 [main] INFO o.h.c.i.C3P0ConnectionProvider - HHH000006: Autocommit mode: true 2015-08-04 19:06:20 [MLog-Init-Reporter] INFO com.mchange.v2.log.MLog - MLog clients using slf4j logging. 2015-08-04 19:06:20 [main] INFO com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.5 [built 02-January-2015 13:25:04 -0500; debug? true; trace: 10] 2015-08-04 19:06:20 [main] INFO c.m.v.c.i.AbstractPoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@936e97d4 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@ad41e439 [ acquireIncrement -> 3, acquireRetryAttempts -> 0, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge1579a1xmtpcqskn3hv|7339450, idleConnectionTestPeriod -> 0, initialPoolSize -> 10, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolS ize -&gt ; 3, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 10, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@86fd0283 [ description -> null, driverClass -> null, factoryClassLocation -> null, forceUseNamedDriverClass -> false, identityToken -> 1hge1579a1xmtpcqskn3hv|1ffd80f0, jdbcUrl -> jdbc:mysql://localhost:3306/cointrader, properties -> {user=**_, password=_*, autocommit=true, release_mode=auto} ], preferredTestQuery -> SELECT 1 from exchange, privilegeSpawnedThreads -> false, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, extensions -> {}, factoryClassLocation -> null, identityToken -> 1hge1579a1xmtpcqskn3hv|1754eb35, numHelperThreads -> 3 ] 2015-08-04 19:06:20 [main] WARN c.m.v.resourcepool.BasicResourcePool - Bad pool size config, min 10 > max 3. Using 3 as min. 2015-08-04 19:06:20 [main] WARN c.m.v.resourcepool.BasicResourcePool - Bad pool size config, start 10 > max 3. Using 3 as start. 2015-08-04 19:06:21 [main] INFO org.hibernate.dialect.Dialect - HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect 2015-08-04 19:06:21 [main] INFO o.h.h.i.a.ASTQueryTranslatorFactory - HHH000397: Using ASTQueryTranslatorFactory 2015-08-04 19:06:21 [main] WARN n.s.e.config.ConfigurationFactory - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/D:/Documents/JavaBot/cointrader/target/cointrader-0.3.0-SNAPSHOT-jar-with-dependencies.jar!/ehcache-failsafe.xml 2015-08-04 19:06:21 [main] INFO o.h.cache.spi.UpdateTimestampsCache - HHH000250: Starting update timestamps cache at region: org.hibernate.cache.spi.UpdateTimestampsCache 2015-08-04 19:06:21 [main] WARN o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.spi.UpdateTimestampsCache]; using defaults. 2015-08-04 19:06:21 [main] INFO o.h.c.internal.StandardQueryCache - HHH000248: Starting query cache at region: org.hibernate.cache.internal.StandardQueryCache 2015-08-04 19:06:21 [main] WARN o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.internal.StandardQueryCache]; using defaults. 2015-08-04 19:06:21 [main] WARN o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Fill]; using defaults. 2015-08-04 19:06:21 [main] WARN o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Listing]; using defaults. 2015-08-04 19:06:21 [main] WARN o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.PortfolioManager]; using defaults. 2015-08-04 19:06:21 [main] WARN o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Order]; using defaults. 2015-08-04 19:06:21 [main] WARN o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Market]; using defaults. 2015-08-04 19:06:21 [main] WARN o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Position]; using defaults. 2015-08-04 19:06:21 [main] WARN o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Transaction]; using defaults. 2015-08-04 19:06:21 [main] WARN o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Asset]; using defaults. 2015-08-04 19:06:21 [main] WARN o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Portfolio]; using defaults. 2015-08-04 19:06:21 [main] WARN o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Stake]; using defaults. 2015-08-04 19:06:21 [main] WARN o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Exchange]; using defaults. 2015-08-04 19:06:21 [main] WARN o.h.c.e.AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.cryptocoinpartners.schema.Prompt]; using defaults. 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.SchemaUpdate - HHH000228: Running hbm2ddl schema update 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.SchemaUpdate - HHH000102: Fetching database metadata 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.SchemaUpdate - HHH000396: Updating schema 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.order_children 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [children, order] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_d42vf63qki5m3f2yfc39gix5d] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.adjustment 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [authorization, time_applied, id, version] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_54ru1mkfaf05t3sw7qajriyjq] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_54ru1mkfaf05t3sw7qajriyjq, primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.adjustment_deltas 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [adjustment, deltas] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_hnvmj4sauvd6bwou2u9838wx3, fk_pkvmcu7o8vd9w9c0ogcynvp1j] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_hnvmj4sauvd6bwou2u9838wx3, fk_pkvmcu7o8vd9w9c0ogcynvp1j] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.authorization 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [notes, id, version] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.book 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [ask_price_as_double, parent, bid_deletions_blob, version, ask_insertions_blob, remote_key, market, bid_price_as_double, ask_volume_as_double, bid_volume_as_double, ask_deletions_blob, time_received, bid_insertions_blob, id, time] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_i9o6ht1d1lk975n7i4h8slkaw, fk_boctr5mp6fppkh67gxjp4xqos] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_i9o6ht1d1lk975n7i4h8slkaw, uk_nfugogi72k3uaprxstuhwbf7u, fk_boctr5mp6fppkh67gxjp4xqos, uk_f8mycxusp2jqgvehm1vkmtefe, primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.currency 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [symbol, fiat, id, basis, version] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.exchange 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [margin_fee_method, symbol, margin, fee_method, margin_fee_rate, id, version, fee_rate] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.fill 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [stop_price_count, open_volume_count, target_price_count, version, volume_count, remote_key, market, time_received, portfolio, price_count, id, time, position, order] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_lar4y36pcsm03uxlj4wbu1fsq, fk_sfk9h7xr4ckkp6fxrv9hcwsyl, fk_n3lj0gejdepujkfv9oxcwr7oh, fk_7gs0r7diitihi47sguavpflhn] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_lar4y36pcsm03uxlj4wbu1fsq, fk_sfk9h7xr4ckkp6fxrv9hcwsyl, fk_n3lj0gejdepujkfv9oxcwr7oh, primary, fk_7gs0r7diitihi47sguavpflhn] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.general_order 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [limit_price_decimal, entry_time, position_effect, emulation, execution_instruction, fill_type, version, parent_order, volume_decimal, margin_type, market, stop_amount_decimal, target_amount_decimal, portfolio, stop_price_decimal, target_price_decimal, trailing_stop_price_decimal, comment, expiration, id, time, listing, panic_force] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_5n09idi1cl4rbt9uswvm2gp8, fk_oegy99vbh4n958dct2c67v0sr, fk_b7wqc8o55t2f10sfyi7byfyxv] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [general_orderuk_pfc5uvg0u2tdtrtgwq9p50tgn, general_orderuk_sb9a6t3qikue8dtuwn7ju5uei, fk_oegy99vbh4n958dct2c67v0sr, general_orderuk_e0gui2lqm0kyyua6rtbvheyu5, primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.listing 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [quote, id, version, prompt, base] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_wbsljbkb77noa0xducg43x8f] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_wbsljbkb77noa0xducg43x8f, uk_b109latdocdl8cgu6jgagabep, uk_fu2dx1ue0cs9sytm3ts2x8dld, primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.market 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [price_basis, active, exchange, id, volume_basis, listing, version] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_rm6ipgm2qgxvjwpx3rmrud2yd, fk_oeh8osopuxors0whhhyw0exrq] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_p7eyg8ihn8eathob3ph6lj6yk, uk_oeh8osopuxors0whhhyw0exrq, uk_rm6ipgm2qgxvjwpx3rmrud2yd, primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.market_data_gap_error 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [exception, market, gap_interval_start, gap_interval_end, id, time, version] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_srsibgckoty6rnljq7oacgeeb] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary, fk_srsibgckoty6rnljq7oacgeeb] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.offer 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [remote_key, market, time_received, price_count, id, time, version, volume_count] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_qgfii77q46573q0k6d5urno2b] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_qgfii77q46573q0k6d5urno2b, primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.order_update 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [sequence, last_state, id, time, state, version, order] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_jq7kng418cnfaqvll20cfw0n1, primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.owner 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [portfolio, name, id, version] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_n0jse4c6ubwbybwgrs1t8sqtn] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_n0jse4c6ubwbybwgrs1t8sqtn, primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.owner_stakes 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [owner, stakes] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_hkdupubd782wg400ixlx3gn12, fk_ls73ux93q48x1k5a75lqlflhv] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_hkdupubd782wg400ixlx3gn12, uk_ls73ux93q48x1k5a75lqlflhv] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.portfolio 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [base_asset, name, id, version] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.portfolio_manager 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [portfolio, id, version] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_g9vyao5fmxwcvyl2cvkw4hn2t] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_g9vyao5fmxwcvyl2cvkw4hn2t, primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.portfolio_positions 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [portfolio, positions] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_wq6vljxbnadvd9kyax2n2vfs, fk_e6gv8j20ydaafsrhwvimqix3k] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_e6gv8j20ydaafsrhwvimqix3k, uk_wq6vljxbnadvd9kyax2n2vfs] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.portfolio_stakes 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [stakes, portfolio] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_q2q8fsgn6f6kterkbfsc33vnc, fk_gg9mqu5am8sba65wvah6bowk4] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_q2q8fsgn6f6kterkbfsc33vnc, fk_gg9mqu5am8sba65wvah6bowk4] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.position 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [market, portfolio, exchange, id, asset, version] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_f7foa02pae7jn067oyu128wrm, fk_of2dh8mim0n70tdiny7oyj7ib, fk_47vs0iaimuwvfjxbi791gjm80] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_f7foa02pae7jn067oyu128wrm, fk_of2dh8mim0n70tdiny7oyj7ib, fk_47vs0iaimuwvfjxbi791gjm80, primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.position_update 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [market, last_type, id, time, position, type, version] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_95qcokwwvmpl7yy6v072g8jy8, fk_bp8965bghp7ae5uo758v0p62k] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_95qcokwwvmpl7yy6v072g8jy8, fk_bp8965bghp7ae5uo758v0p62k, primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.prompt 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [margin_fee_method, symbol, margin, price_basis, traded_currency, volume_basis, version, tick_size, fee_rate, margin_method, fee_method, id, contract_size, tick_value] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.specific_order 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [entry_time, position_effect, emulation, execution_instruction, placement_count, fill_type, version, volume_count, parent_order, margin_type, market, remote_key, portfolio, time_received, comment, expiration, id, time, limit_price_count, panic_force] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_mpgexwbtqjc4as6sc9ahihqln, fk_3ovh0s0m3o3oe5y1v7gm3j1d0] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [specific_orderuk_pfc5uvg0u2tdtrtgwq9p50tgn, specific_orderuk_sb9a6t3qikue8dtuwn7ju5uei, specific_orderuk_e0gui2lqm0kyyua6rtbvheyu5, primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.stake 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [stake, owner, portfolio, id, version] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_7emmidtfhutcjvm20da0pirpu, fk_2nyltxk5lyuhrmhc6r0ustns0] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_7emmidtfhutcjvm20da0pirpu, fk_2nyltxk5lyuhrmhc6r0ustns0, primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.strategy_instance 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [portfolio, id, module_name, version] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_78y9ysg7j6jq0nvyufx505g5i] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_78y9ysg7j6jq0nvyufx505g5i, primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.strategy_instance_config 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [strategy_instance, config_key, config] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_60nm0bu9carvgeoh535buhihq] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.tick 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [remote_key, market, start_instant, time_received, price_count, last_book, id, time, version, volume_count] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_4tysbo6v9o6l917yek17px9p8, fk_1s4mo583fm863i68wk5mjyf2o] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_4tysbo6v9o6l917yek17px9p8, fk_1s4mo583fm863i68wk5mjyf2o, primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.trade 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [remote_key, market, time_received, price_count, id, time, version, volume_count] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_3e8g41qfm2egglm1xj17ubooc] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [uk_8kdomlkbs1vrbuemp0x8o1blf, uk_3e8g41qfm2egglm1xj17ubooc, uk_9o7pvdorduhxo0p2855fr2w2t, uk_69n5t8v03i6jyoqx7q4x0os3u, uk_ajh0h97g35whr3rm5tve50yhc, primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000261: Table found: cointrader.transaction 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000037: Columns: [position_effect, type, fill, version, amount_count, commission_currency, market, portfolio, price_count, currency, exchange, id, time, commission_count, asset, order] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000108: Foreign keys: [fk_lucasenbcynptutvbhodxn1ln, fk_q5y4q26rn1or55bx6nlfmh1ne, fk_3lmhbk66eufissa0y7vubj366, fk_f3ilsvdq06ndnmim591yo2cia] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.TableMetadata - HHH000126: Indexes: [fk_lucasenbcynptutvbhodxn1ln, fk_q5y4q26rn1or55bx6nlfmh1ne, uk_8dfwvrlg6wtv9wfyeqca1ybtb, fk_3lmhbk66eufissa0y7vubj366, fk_f3ilsvdq06ndnmim591yo2cia, primary] 2015-08-04 19:06:22 [main] INFO o.h.tool.hbm2ddl.SchemaUpdate - HHH000232: Schema update complete 2015-08-04 19:06:22 [net.sf.ehcache.CacheManager@7ba194df] INFO net.sf.ehcache.util.UpdateChecker - New update(s) found: 2.4.7 [http://www.terracotta.org/confluence/display/release/Release+Notes+Ehcache+Core+2.4]. Please check http://ehcache.org for the latest version. 2015-08-04 19:06:23 [main] INFO c.e.e.c.s.EPServiceProviderImpl - Initializing engine URI 'default' version 4.9.0 2015-08-04 19:06:23 [main] WARN c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DecimalAmount org.cryptocoinpartners.schema.GeneralOrder.getLimitPrice() 2015-08-04 19:06:23 [main] WARN c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DecimalAmount org.cryptocoinpartners.schema.GeneralOrder.getStopAmount() 2015-08-04 19:06:23 [main] WARN c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DecimalAmount org.cryptocoinpartners.schema.GeneralOrder.getStopPrice() 2015-08-04 19:06:23 [main] WARN c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DecimalAmount org.cryptocoinpartners.schema.GeneralOrder.getTargetAmount() 2015-08-04 19:06:23 [main] WARN c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DecimalAmount org.cryptocoinpartners.schema.GeneralOrder.getTargetPrice() 2015-08-04 19:06:23 [main] WARN c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DecimalAmount org.cryptocoinpartners.schema.GeneralOrder.getTrailingStopPrice() 2015-08-04 19:06:23 [main] WARN c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DecimalAmount org.cryptocoinpartners.schema.GeneralOrder.getVolume() 2015-08-04 19:06:23 [main] WARN c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DiscreteAmount org.cryptocoinpartners.schema.SpecificOrder.getLimitPrice() 2015-08-04 19:06:23 [main] WARN c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DiscreteAmount org.cryptocoinpartners.schema.SpecificOrder.getStopAmount() 2015-08-04 19:06:23 [main] WARN c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DiscreteAmount org.cryptocoinpartners.schema.SpecificOrder.getStopPrice() 2015-08-04 19:06:23 [main] WARN c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DiscreteAmount org.cryptocoinpartners.schema.SpecificOrder.getTargetAmount() 2015-08-04 19:06:23 [main] WARN c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DiscreteAmount org.cryptocoinpartners.schema.SpecificOrder.getTargetPrice() 2015-08-04 19:06:23 [main] WARN c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DiscreteAmount org.cryptocoinpartners.schema.SpecificOrder.getTrailingStopPrice() 2015-08-04 19:06:23 [main] WARN c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DiscreteAmount org.cryptocoinpartners.schema.SpecificOrder.getUnfilledVolume() 2015-08-04 19:06:23 [main] WARN c.e.esper.event.bean.PropertyHelper - .getAccessors Unable to obtain CGLib fast method implementation, msg=Cannot find method public org.cryptocoinpartners.schema.DiscreteAmount org.cryptocoinpartners.schema.SpecificOrder.getVolume() 2015-08-04 19:06:23 [main] DEBUG o.cryptocoinpartners.module.Context - no module file found for SaveMarketData.epl on classpath. Please ensure SaveMarketData.epl is in the resources directory. 2015-08-04 19:06:23 [main] DEBUG o.cryptocoinpartners.module.Context - subscribing public static void org.cryptocoinpartners.module.SaveMarketData.handleMarketData(org.cryptocoinpartners.schema.MarketData) with statement "select * from MarketData.std:lastevent()" 2015-08-04 19:06:24 [main] DEBUG o.cryptocoinpartners.module.Context - no module file found for XchangeData.epl on classpath. Please ensure XchangeData.epl is in the resources directory.

— Reply to this email directly or view it on GitHub https://github.com/timolson/cointrader/issues/124#issuecomment-127795100 .

Tikaszar commented 9 years ago

Hey Douggie,

The fix doesn't seem to be working for me. cointrader.sh reset-database still comes back with a could not initialize db error and cointrader.sh save-data does the same.

If I insert BTC into the Currency table manually, then run cointrader.sh save-data, I continue to get the errors that none of the *.epl files could be found. cointrader.sh reset-database works properly after this, but still fails to insert the default data into the db, which leads back to cointrader.sh save-data failing to init db.

Given that I see no .epl files, is my assumption that the code should be handling this through Context correct?

I also went ahead and ran this on my 2nd comp (fresh win 8.1 install fully updated, only this installed), and both errors are occurring on that comp as well.

douggie commented 9 years ago

humm, the *.epl erors can be ignored, they are the esper files you can add for your strategies, there are some their in the resources folders for the services that need them, basic portfolio service.

did you try tim's suggestion of the different JVM? I am using the oracle 1.7.0 JVM on a mac.

here is the version I am running, I am unable to replicate this on a mac.

java version "1.7.0_60-ea"

Java(TM) SE Runtime Environment (build 1.7.0_60-ea-b15)

Java HotSpot(TM) 64-Bit Server VM (build 24.60-b09, mixed mode)

Regards

Douggie

On Wed, Aug 5, 2015 at 10:16 PM, Tikaszar notifications@github.com wrote:

Hey Douggie,

The fix doesn't seem to be working for me. cointrader.sh reset-database still comes back with a could not initialize db error and cointrader.sh save-data does the same. If I insert BTC into the Currency table manually, then run cointrader.sh save-data, I continue to get the errors that none of the *.epl files could be found. Given that I see no .epl files, is my assumption that the code should be handling this through Context correct?

I also went ahead and ran this on my 2nd comp (fresh win 8.1 install fully updated, only this installed), and both errors are occurring on that comp as well.

— Reply to this email directly or view it on GitHub https://github.com/timolson/cointrader/issues/124#issuecomment-128151590 .

Tikaszar commented 9 years ago

I've tried a few different methods to get this to work after you suggested changing the JVM, all with the same results. 1) I switched from java 1.8 down to 1.7. Trying both update 80 and update 60 for 1.7 returned the same error on Windows (all Oracle). 2) I ditched Windows and switched to Ubuntu 14.04 LTS (fresh install). Same results here as well. I also left cointrader.sh save-data running overnight on this machine, and have not had any data populate into the db. I've tried touching Prompt and Currency before PersistUtil is called as well.

I have also noticed another odd behaviour, not sure if this has something to do with it. Provided I've manually inserted BTC into Currency, when cointrader.sh reset-database is executing, it does insert all the default static information into the db. The data is visible when I query the database (select * from currency). However, once I get the output [main] INFO o.h.tool.hbm2ddl.SchemaExport - HHH000230: Schema export complete after the last Prompt entry is completed, the data is no longer stored in the db. Currency, Exchange and Prompt return to being empty. I tried ending the process before the data was removed and executing cointrader.sh save-data, however I end up with the same output log as before and no new data populating into the db (I believe the tables I should be looking at are book and trade, but I've checked all of them in case).

Also, just wanted to say thanks again for continuing to take the time to help me with this.

Tikaszar commented 9 years ago

Fixed now after #126.