distal-attribute
distal-attribute
distal-attribute
distal-attribute

error

tonyk posted 11 months ago in General
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.
kalvaro posted 11 months ago
According to the perror utility...

C:\>perror 28
OS error code 28: No space left on device
Win32 error code 28: No queda papel en la impresora.



... the server disk is full or the printer has run out of paper.
tonyk posted 11 months ago
plenty of space on the disk and I am pretty sure the printer has papersmile

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.
jfalch posted 11 months ago
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).
jfalch posted 11 months ago
NB "ile space qute" should be "file space quota".
(This write-only forum really has its drawbacks..)

tonyk posted 11 months ago
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:

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) */

jfalch posted 11 months ago
what engine is used for the db ? myisam, innodb, other ? (Table tab, Options subtab)
are there any indexes defined ? (Table tab, Indexes subtab)
jfalch posted 11 months ago
sorry, saw the engine too late.
tonyk posted 11 months ago
@jfalch: Yes there is a primary key field. It is a field named ID that is an auto_increment INT.
kalvaro posted 11 months ago
If you run the command line client (Tools-> Launch command line) and paste the query there, do you get the same error?

tonyk posted 11 months ago
@kalvaro
I don't currently have mysql installed on my local machine. The command line client requires a local install.

Please login to leave a reply, or register at first.