error

[expired user #7520]'s profile image [expired user #7520] posted 10 years ago in General Permalink
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's profile image kalvaro posted 10 years ago Permalink
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.
[expired user #7520]'s profile image [expired user #7520] posted 10 years ago Permalink
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's profile image jfalch posted 10 years ago Permalink
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's profile image jfalch posted 10 years ago Permalink
NB "ile space qute" should be "file space quota".
(This write-only forum really has its drawbacks..)
[expired user #7520]'s profile image [expired user #7520] posted 10 years ago Permalink
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's profile image jfalch posted 10 years ago Permalink
what engine is used for the db ? myisam, innodb, other ? (Table tab, Options subtab)
are there any indexes defined ? (Table tab, Indexes subtab)
jfalch's profile image jfalch posted 10 years ago Permalink
sorry, saw the engine too late.
[expired user #7520]'s profile image [expired user #7520] posted 10 years ago Permalink
@jfalch: Yes there is a primary key field. It is a field named ID that is an auto_increment INT.
kalvaro's profile image kalvaro posted 10 years ago Permalink
If you run the command line client (Tools-> Launch command line) and paste the query there, do you get the same error?
[expired user #7520]'s profile image [expired user #7520] posted 10 years ago Permalink
@kalvaro
I don't currently have mysql installed on my local machine. The command line client requires a local install.
[expired user #9555]'s profile image [expired user #9555] posted 8 years ago Permalink

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.