【求助】mysql应用中,偶而出现这个临时表的创建错误,何解?
CREATE TEMPORARY TABLE IF NOT EXISTS TEMP_TICKETPRINT( BARCODEID VARCHAR(18) , PROJECTID DEC(15) , TICKETTEMPLATEID DEC(15) , SHOPID DEC(10) , SHOPNAME VARCHAR(30) , TICKETKIND DEC(10) , TICKETTYPE DEC(10) , CHANGETYPE DEC(10) , IFSEPARATE DEC(10) DEFAULT 0 , PROVIDEDATE DATETIME , CHANGESTARTDATE DATETIME , CHANGEENDDATE DATETIME , CHANGEDATE DATETIME , IFPRINT DEC(10) DEFAULT 0 ,IFCHANGE DEC(10) DEFAULT 0 , CHANGESHOP DEC(10) DEFAULT 0 , CHANGEWEEK CHAR(7) DEFAULT '1111111' , CHANGEHOUR1 CHAR(4) DEFAULT '0024' ,CHANGEHOUR2 CHAR(4) DEFAULT '0024' , CHANGEHOUR3 CHAR(4) DEFAULT '0024' , TICKETMONEY DEC(12,2) DEFAULT 0 , TOTALCUMULATION DEC(10) DEFAULT 0 ,HISCUMULATION DEC(10) DEFAULT 0 , LISTNO DEC(14), POSNO VARCHAR(30), CHANGELISTNO DEC(14), CHANGEPOSNO VARCHAR(30), PRINTERNAME VARCHAR(30) )ENGINE = INNODB;
Error: Can't create table '/tmp/#sql2e2_2_1.frm' (errno: 121)
后边查了一下:
# perror 121
OS error code 121: Remote I/O error
MySQL error code 121: Duplicate key on write or update
就更加没有懂了。请教各位大侠。