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

[Mike Thornton]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.trading-shim.org/pipermail/ts-general/attachments/20090412/f88ca3cf/attachment.html