truncate while inserting problem
Have any of you folks come across an issue doing a truncate table while
inserts are being performed on it? I've logged a bug report for it
(http://bugs.mysql.com/bug.php?id=30739) but if anyone knows how to
workaround the issue in the meantime it'd be handy, due to the resulting
problem trying to drop/recreate the table afterwards. At the moment the
only way I know to deal with this issue is rebuilding the cluster from
scratch.
What happens is you have a data import going and if you issue a truncate
table on the table havign data imported into it, the import fails with
table doesn't exist error, and the truncate fails with table already
exists. From then on, any attempt to drop the table to start over
results in being told it doesn't exist, while any attempt to create the
table results in being told it exists.
Thanks
--
MySQL Cluster Mailing List
For list archives:
http://lists.mysql.com/cluster
To unsubscribe:
http://lists.mysql.com/cluster?unsub=lists@pantek.com
Received on Fri Aug 31 00:53:58 2007
This archive was generated by hypermail 2.1.8
: Sun Oct 07 2007 - 10:15:06 EDT
|