(Pdb) n > /home/crazier/workspace/python/dbcopy/mysql/utilities/common/table.py(854)_bulk_insert() -> for data_insert in insert_data: (Pdb) list 849 data_lists = self.make_bulk_insert(rows, new_db) 850 insert_data = data_lists[0] 851 blob_data = data_lists[1] 852 853 # Insert the data first 854 -> for data_insert in insert_data: 855 try: 856 dest.exec_query(data_insert, self.query_options) 857 except UtilError, e: 858 raise UtilError("Problem inserting data. " 859 "Error = %s" % e.errmsg) (Pdb) n > /home/crazier/workspace/python/dbcopy/mysql/utilities/common/table.py(855)_bulk_insert() -> try: (Pdb) n > /home/crazier/workspace/python/dbcopy/mysql/utilities/common/table.py(856)_bulk_insert() -> dest.exec_query(data_insert, self.query_options) (Pdb) list 851 blob_data = data_lists[1] 852 853 # Insert the data first 854 for data_insert in insert_data: 855 try: 856 -> dest.exec_query(data_insert, self.query_options) 857 except UtilError, e: 858 raise UtilError("Problem inserting data. " 859 "Error = %s" % e.errmsg) 860 861 # Now insert the blob data if there is any (Pdb) a self = rows = [('1032', '300911085000200', '1000000000', '100200911080000007666', '3', '2', 'uin=65070043&uname=???&creditcard_id=************7562&creditcard_id_md5=157cc65dae6d560ef47d03adc9b35bd3&fee_type=1&banklist_id=1032100200911080000007666&token=80405eb76220884aebff849a4528628b&draw_id=202200911080000000350&amount=1&bank_type=1020&bank_name=???????&area=2&city=21&save_flag=0&time_stamp=1257647221&history_flag=1&client_ip=10.6.35.38', '2009-11-08 10:36:14', None, None, '1970-01-01 00:00:00', None, None)] new_db = `bank_order_db_00` destination = (Pdb) p data_lists (["INSERT INTO `bank_order_db_00`.`t_business_relation_2` VALUES (1032, '300911085000200', '1000000000', '100200911080000007666', 3, 2, NULL, '2009-11-08 10:36:14', NULL, NULL, '1970-01-01 00:00:00', NULL, NULL)"], ["UPDATE `bank_order_db_00`.`t_business_relation_2` SET `Frequest_packet` = 'uin=65070043&uname=???&creditcard_id=************7562&creditcard_id_md5=157cc65dae6d560ef47d03adc9b35bd3&fee_type=1&banklist_id=1032100200911080000007666&token=80405eb76220884aebff849a4528628b&draw_id=202200911080000000350&amount=1&bank_type=1020&bank_name=???????&area=2&city=21&save_flag=0&time_stamp=1257647221&history_flag=1&client_ip=10.6.35.38' WHERE `Fbank_type` = '1032' AND `Fbank_list` = '300911085000200' AND `Fspid` = '1000000000' AND `Fbusiness_id` = '100200911080000007666' AND `Fbusiness_type` = '3' AND `Flstate` = '2' AND `Fcreate_time` = '2009-11-08 10:36:14' AND `Fstandby1` = NULL AND `Fstandby2` = NULL AND `Fstandby3` = '1970-01-01 00:00:00' AND `Fstandby4` = NULL AND `Fstandby5` = NULL;"]) (Pdb) p insert_data ["INSERT INTO `bank_order_db_00`.`t_business_relation_2` VALUES (1032, '300911085000200', '1000000000', '100200911080000007666', 3, 2, NULL, '2009-11-08 10:36:14', NULL, NULL, '1970-01-01 00:00:00', NULL, NULL)"] (Pdb) p blob_data ["UPDATE `bank_order_db_00`.`t_business_relation_2` SET `Frequest_packet` = 'uin=65070043&uname=???&creditcard_id=************7562&creditcard_id_md5=157cc65dae6d560ef47d03adc9b35bd3&fee_type=1&banklist_id=1032100200911080000007666&token=80405eb76220884aebff849a4528628b&draw_id=202200911080000000350&amount=1&bank_type=1020&bank_name=???????&area=2&city=21&save_flag=0&time_stamp=1257647221&history_flag=1&client_ip=10.6.35.38' WHERE `Fbank_type` = '1032' AND `Fbank_list` = '300911085000200' AND `Fspid` = '1000000000' AND `Fbusiness_id` = '100200911080000007666' AND `Fbusiness_type` = '3' AND `Flstate` = '2' AND `Fcreate_time` = '2009-11-08 10:36:14' AND `Fstandby1` = NULL AND `Fstandby2` = NULL AND `Fstandby3` = '1970-01-01 00:00:00' AND `Fstandby4` = NULL AND `Fstandby5` = NULL;"] (Pdb) n UtilDBError: UtilDBEr...null", 0) > /home/crazier/workspace/python/dbcopy/mysql/utilities/common/table.py(856)_bulk_insert() -> dest.exec_query(data_insert, self.query_options) (Pdb) n > /home/crazier/workspace/python/dbcopy/mysql/utilities/common/table.py(857)_bulk_insert() -> except UtilError, e: (Pdb) n > /home/crazier/workspace/python/dbcopy/mysql/utilities/common/table.py(858)_bulk_insert() -> raise UtilError("Problem inserting data. " (Pdb) n > /home/crazier/workspace/python/dbcopy/mysql/utilities/common/table.py(859)_bulk_insert() -> "Error = %s" % e.errmsg) (Pdb) n UtilError: UtilErro...null", 0) > /home/crazier/workspace/python/dbcopy/mysql/utilities/common/table.py(859)_bulk_insert() -> "Error = %s" % e.errmsg) (Pdb) n --Return-- > /home/crazier/workspace/python/dbcopy/mysql/utilities/common/table.py(859)_bulk_insert()->None -> "Error = %s" % e.errmsg) (Pdb) p e.errmsg "Query failed. 1048 (23000): Column 'Frequest_packet' cannot be null" (Pdb)