[ts-gen] foreign key constraint fails during setup.sql

[Richard Pruss]

Hi Shim-mers,

Built the shim on MacOs.  No problems in build except the change in mysql
location to Lib in the Makefile.
(The source included README should point to the online doc as that is
clearly more up to date.)

I have a error during sourceing setup.sql.
.
..
Query OK, 1 row affected (0.01 sec)

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`))
Query OK, 0 rows affected, 1 warning (0.00 sec)
...


One other warning which looks less dire:
....

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
Query OK, 0 rows affected, 1 warning (0.00 sec)
...

Possibly as a result on one of these shim does not start:
Quady:shim-090120 ric$ ./shim --data

          The trading shim has connected to the database server

The record with uid 65536 from table Symbol is out of sequence.
Fill: 1 65536 45223 Symbol
Dbms: uid(65536) next(45223)

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

I am probably missing some obvious step??

-Ric
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.trading-shim.org/pipermail/ts-general/attachments/20090126/69b99ee8/attachment.html