Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

truncate while inserting problem

From: Jason Brooke <jason(at)mammoth.com.au>
Date: Fri Aug 31 2007 - 00:53:42 EDT


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


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library