error
Whenever I try to view the data in one of my tables I get an SQL error (3) errcode:28. I can view the data in all my other tables but one in particular.
plenty of space on the disk and I am pretty sure the printer has paper
every time I try to access the data the temp file name changes. for instance the last time I ran it the file name was MYE934.tmp.
This started when I upgraded to version 8.2.0.4675 today. I am guessing there is some field in the table that heidi is having a problem with. I am able to read from the table with no issue via php.
every time I try to access the data the temp file name changes. for instance the last time I ran it the file name was MYE934.tmp.
This started when I upgraded to version 8.2.0.4675 today. I am guessing there is some field in the table that heidi is having a problem with. I am able to read from the table with no issue via php.
Since the error messsage is prefixed with SQL Error, this appears to be a file-related problem occuring in the mysqld server. The server, while processing a request, attempts to write a temporary file (yes, its name changes every time, this is the nature of temporary files), and gets an error code from the operating system when trying to do so. According to this and this, the problem is disk space; however, since you are using windows (which has no separate /tmp partitions), and are sure that you have no space problems on your disk (and no strange ile space qute on the c:\Windows\Temp dir), it could be related to that the size of the tmp file would be very large - other seem to have had problems with this too.
What is the query, and the engine used for the database (myisam, innodb, ..) ? Is the query one of those automatically generated by heidisql when you use the Data tab ?
(cf also especially the "ANALYSE TABLE" tip concerning InnoDB in the second post).
What is the query, and the engine used for the database (myisam, innodb, ..) ? Is the query one of those automatically generated by heidisql when you use the Data tab ?
(cf also especially the "ANALYSE TABLE" tip concerning InnoDB in the second post).
Engine is InnoDB
Yes this is an auto generated query when using the data tab. I have no issues so far using the query tab with this table.
Here is the query and the error message in the console:
Yes this is an auto generated query when using the data tab. I have no issues so far using the query tab with this table.
Here is the query and the error message in the console:
SELECT LEFT(`ShipName`, 256), LEFT(`Adr1`, 256), LEFT(`Adr2`, 256), LEFT(`Adr3`, 256), LEFT(`City`, 256), LEFT(`State`, 256), LEFT(`Postal`, 256), LEFT(`Country`, 256), `ShipDate`, `ETA`, LEFT(`TrackingNumber`, 256), LEFT(`RefNum`, 256), `Service`, LEFT(`LabelType`, 256), `ID` FROM `DB`.`shippinginfo` ORDER BY `ShipDate` ASC, `TrackingNumber` ASC LIMIT 1000;
/* SQL Error (3): Error writing file 'C:\Windows\TEMP\MYAD74.tmp' (Errcode: 28) */
Registered to thank you as this was my issue. My server disk was full, once some space was free SQL worked again.
According to the perror utility...
[code]C:>perror 28 OS error code 28: No space left on device Win32 error code 28: No queda papel en la impresora.[/code]
... the server disk is full or the printer has run out of paper.
Please login to leave a reply, or register at first.