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

error

User, date Message
Written by tonyk
4 months ago
Category: General
5 posts since Mon, 23 Dec 13
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.
Written by kalvaro
4 months ago
564 posts since Thu, 29 Nov 07
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.
Written by tonyk
4 months ago
5 posts since Mon, 23 Dec 13
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.
Written by jfalchMoney, Euro
4 months ago
354 posts since Sat, 17 Oct 09
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).
Written by jfalchMoney, Euro
4 months ago
354 posts since Sat, 17 Oct 09
NB "ile space qute" should be "file space quota".
(This write-only forum really has its drawbacks..)
Written by tonyk
4 months ago
5 posts since Mon, 23 Dec 13
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) */

Written by jfalchMoney, Euro
4 months ago
354 posts since Sat, 17 Oct 09
what engine is used for the db ? myisam, innodb, other ? (Table tab, Options subtab)
are there any indexes defined ? (Table tab, Indexes subtab)
Written by jfalchMoney, Euro
4 months ago
354 posts since Sat, 17 Oct 09
sorry, saw the engine too late.
Written by tonyk
4 months ago
5 posts since Mon, 23 Dec 13
@jfalch: Yes there is a primary key field. It is a field named ID that is an auto_increment INT.
Written by kalvaro
4 months ago
564 posts since Thu, 29 Nov 07
If you run the command line client (Tools-> Launch command line) and paste the query there, do you get the same error?
Written by tonyk
4 months ago
5 posts since Mon, 23 Dec 13
@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.