[ts-gen] shim setup issues on 64-bit linux

Nils Gebhardt mail at ngebhardt.de
Mon Apr 13 03:39:52 EDT 2009



Hi Mike, 

I have shim running on 64 bit (Ubuntu 08 10,  mysql --version:
mysql  Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (x86_64) using
readline 5.2). Runs fine. 
However, I can reproduce a similar problem: when sending a limit order
from within shim and canceling the same order in the tws GUI afterwards,
a subsequent start of shim fails with a similar error:

----%------

          The trading shim has connected to the database server

The record with uid 43 from table ChangeOrder is out of sequence.
Fill: 1 43 42 ChangeOrder
Dbms: uid(43) next(42)

Problem: 515 db record uid -- vector offset mismatch
Exiting

-----%-----

Deleting corresponding rows in table ChangeOrder with uid 43 upwards
helps.  This is probably a bad usage rather than a bug. 

However, looking at 


> ERROR: 
> Failed to open file 'sym/opt/GOOG.sql', error: 2
> 
> 


quoted from your message below it seems that the data files for the shim
distribution, which come separatly since recently, are missing. Needs to
be downloaded and unpacked in the same directory as the shim tarball. 


regards, Nils 



On Sun, 2009-04-12 at 18:12 -0700, Mike Thornton wrote:
> Hi folks,
> 
> I am having similar trading shim setup problems as discussed in this
> thread
> 
> http://tradingshim.net/pipermail/ts-general/2009-January/000357.html
> 
> However, I am using a 64-bit linux fedora distro, and not a mac.  One
> of the errors I see when running setup.sql in mysq is (the other mysql
> errors I see are below)
> 
> ERROR 1452 (23000): Cannot add or update a child row: a foreign key
> constraint fails (`testing`.`Template`, CONSTRAINT `Template_ibfk_4`
> FOREIGN KEY (`par`) REFERENCES `Template` (`uid`))
> 
> The mysql package I am using is "mysql-5.1.33-linux-x86_64-glibc23".
> I have tried several installs of both mysql and the trading shim, with
> the same errors when trying to run trading shim using.  I don't see
> any errors with the trading shim compilation.  When I run "shim
> --data", I see
> 
> "The trading shim has connected to the database server
> 
> The record with uid 32 from table PastFilter is out of sequence.
> Fill: 1 32 21 PastFilter
> Dbms: uid(32) next(21)
> 
> Problem: 515 db record uid -- vector offset mismatch
> Exiting"
> 
> Has anyone successfully set up the trading shim using a 64-bit mysql
> package?  If so, what package are you using?  Does anyone know how to
> fix this problem(s)?
> 
> 
> Thanks.
> Mike
> 
> 
> 
> 
> 
> ----------------------Errors from running
> setup.sql-----------------------------
> ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
> ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
> 
> 
> ERROR: 
> Failed to open file 'sym/A0Ind00.sql', error: 2
> ERROR: 
> Failed to open file 'sym/A0Stk00.sql', error: 2
> ERROR: 
> Failed to open file 'sym/A0Stk01.sql', error: 2
> ERROR: 
> Failed to open file 'sym/A0Stk02.sql', error: 2
> ERROR: 
> Failed to open file 'sym/A0Stk03.sql', error: 2
> ERROR: 
> Failed to open file 'sym/A0Stk04.sql', error: 2
> ERROR: 
> Failed to open file 'sym/A0Stk05.sql', error: 2
> ERROR: 
> Failed to open file 'sym/A0Stk06.sql', error: 2
> ERROR: 
> Failed to open file 'sym/A0Stk07.sql', error: 2
> ERROR: 
> Failed to open file 'sym/A0Csh00.sql', error: 2
> ERROR: 
> Failed to open file 'sym/A0Bnd00.sql', error: 2
> ERROR: 
> Failed to open file 'sym/A0Bnd01.sql', error: 2
> ERROR: 
> Failed to open file 'sym/A0Bnd02.sql', error: 2
> ERROR: 
> Failed to open file 'sym/A0Bnd03.sql', error: 2
> ERROR: 
> Failed to open file 'sym/A0Fut00.sql', error: 2
> ERROR: 
> Failed to open file 'sym/A0Fut01.sql', error: 2
> ERROR: 
> Failed to open file 'sym/opt/GOOG.sql', error: 2
> 
> 
> ERROR 1049 (42000): Unknown database 'mysql'
> ERROR 1146 (42S02): Table 'trading.user' doesn't exist
> ERROR 1146 (42S02): Table 'trading.db' doesn't exist
> ERROR 1146 (42S02): Table 'trading.tables_priv' doesn't exist
> ERROR 1146 (42S02): Table 'trading.user' doesn't exist
> ERROR 1146 (42S02): Table 'trading.db' doesn't exist
> ERROR 1146 (42S02): Table 'trading.db' doesn't exist
> ERROR 1146 (42S02): Table 'trading.db' doesn't exist
> ERROR 1146 (42S02): Table 'trading.db' doesn't exist
> ERROR 1146 (42S02): Table 'mysql.host' doesn't exist
> ERROR 1146 (42S02): Table 'trading.tables_priv' doesn't exist
> ERROR 1146 (42S02): Table 'mysql.host' doesn't exist
> _______________________________________________
> ts-general mailing list
> ts-general at trading-shim.org
> http://www.trading-shim.org/mailman/listinfo/ts-general



More information about the ts-general mailing list