Re: Error Code 28
Hi Heston, all! Heston James - Cold Beans wrote: [[...]] One thing which is puzzling me at the moment is why its producing such large record sets from my query. Even when limiting the query to 700 records it still exceeds this 8Mb limit. The query is quite basic and is only returning very simple strings and integers, no more than maybe 8 chars long, like so: SELECT bluetooth_session.bluetooth_session_id AS bluetooth_session_bluetooth_session_id, bluetooth_session.result AS bluetooth_session_result, bluetooth_session.address AS bluetooth_session_address, bluetooth_session.message_id AS bluetooth_session_message_id, bluetooth_session.campaign_id AS bluetooth_session_campaign_id, bluetooth_session.created AS bluetooth_session_created, bluetooth_session.modified AS bluetooth_session_modified FROM bluetooth_session WHERE bluetooth_session.created %s ORDER BY bluetooth_session.created LIMIT 1, 699 The limit clause restricts the data returned, but not the data examined. You ask the server to examine a certain set of rows (where ...), sort it (order by ...), and then to return a limited number of these rows (limit ...). As the data only exist in some other order and you (probably) do not have a way to access them in the order desired (or do you have an index on bluetooth_session.created?), the server must first sort all qualifying rows. This is where it needs so much space. Somebody else has already commented on the limit clause you use, I need not repeat that. bluetooth_session.result and bluetooth_session.address are both 8 character varchars and the rest are integers and dates. Would you really expect a record set from this query to be so large? Is there any way to make it smaller and more efficient? I strongly suspect an index on bluetooth_session.created would help, both in evaluating the where condition and in avoiding the sort for order by, and so both reduce the time and avoid the temp space. Disclaimer: Not tested, not checked - just assuming. Regards and HTH, Jörg -- Joerg Bruehe, MySQL Build Team, [EMAIL PROTECTED] Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error Code 28
Morning Jorg, Thanks for the reply. The limit clause restricts the data returned, but not the data examined. You ask the server to examine a certain set of rows (where ...), sort it (order by ...), and then to return a limited number of these rows (limit ...). As the data only exist in some other order and you (probably) do not have a way to access them in the order desired (or do you have an index on bluetooth_session.created?), the server must first sort all qualifying rows. This is where it needs so much space. This makes perfect sense, I see what you mean about the fact that the data has to effectively be collated in its entirety before it is ordered and limited, that's a very fair statement. Somebody else has already commented on the limit clause you use, I need not repeat that. They did indeed, I hadn't noticed this myself, the SQL is produced by an ORM so I'll examine how I'm using that, thanks to all who pointed that one out. I strongly suspect an index on bluetooth_session.created would help, both in evaluating the where condition and in avoiding the sort for order by, and so both reduce the time and avoid the temp space. I can see your point on this, I've not worked with index's at all at this point in time so I'll give them a shot and see what difference that makes, the created date definitely makes a very strong candidate as this is generally how the data is queried, so that'll be my first index, I also regularly query on the address column so I'll be sure to try indexing that too. Disclaimer: Not tested, not checked - just assuming. I really appreciate the suggestions, I certainly see the logic in them, let's hope they bare fruit :-) Cheers, Heston -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error Code 28
Hi Rob, Thanks for getting back to me on this. You were right on the money with the imposed quota on that directory, I tried copying some large files across to the folder and found it limited to 8Mb for some reason, I'll look into removing that limit. One thing which is puzzling me at the moment is why its producing such large record sets from my query. Even when limiting the query to 700 records it still exceeds this 8Mb limit. The query is quite basic and is only returning very simple strings and integers, no more than maybe 8 chars long, like so: SELECT bluetooth_session.bluetooth_session_id AS bluetooth_session_bluetooth_session_id, bluetooth_session.result AS bluetooth_session_result, bluetooth_session.address AS bluetooth_session_address, bluetooth_session.message_id AS bluetooth_session_message_id, bluetooth_session.campaign_id AS bluetooth_session_campaign_id, bluetooth_session.created AS bluetooth_session_created, bluetooth_session.modified AS bluetooth_session_modified FROM bluetooth_session WHERE bluetooth_session.created %s ORDER BY bluetooth_session.created LIMIT 1, 699 bluetooth_session.result and bluetooth_session.address are both 8 character varchars and the rest are integers and dates. Would you really expect a record set from this query to be so large? Is there any way to make it smaller and more efficient? Cheers Rob, Heston -Original Message- From: Rob Wultsch [mailto:[EMAIL PROTECTED] Sent: 21 October 2008 16:49 To: Heston James - Cold Beans Cc: mysql@lists.mysql.com Subject: Re: Error Code 28 On Tue, Oct 21, 2008 at 8:26 AM, Heston James - Cold Beans [EMAIL PROTECTED] wrote: Afternoon all, I have a SELECT query which is returning the following error: (InternalError) (3, Error writing file '/tmp/MYqlGnfn' (Errcode: 28)) After doing a little searching on google all signs seem to point to a lack of disk space to be able to store the query results. However, I have several hundred MB left on the storage device and the database itself, in its entirety is only around 19Mb in size so it sees very strange to be causing that. Here is a quick output from 'fd -h' which displays the space on my storage device. FilesystemSize Used Avail Use% Mounted on rootfs973M 595M 330M 65% / udev 10M 20K 10M 1% /dev /dev/disk/by-label/ROOT_FS 973M 595M 330M 65% / /dev/disk/by-label/ROOT_FS 973M 595M 330M 65% /dev/.static/dev tmpfs 126M 0 126M 0% /lib/init/rw tmpfs 126M 0 126M 0% /dev/shm tmpfs 8.0M 0 8.0M 0% /rw/tmp Can anyone offer any suggestions as to what might be causing this issue and anything I can do to correct this? I'd really appreciate some help. I'm running MySQL 5 on a Debian based system. If you need any more information what so ever, please let me know. Cheers in advance, Heston 1. Just because your data set is small does not mean that mysql will not create a larger temporary file to store a temporary table. 2. If I had to guess I would say some sort of quota is in effect, also possibly for /tmp/ in particular. -- Rob Wultsch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error Code 28
you can make mysql to use memory for creating temp files rather than disk set sort_buffer_size=1024*1024*100; and try your query. Also the size of the columns is based on the db engine ur using, i dont remember the exact number, i will denfinitly find it in mysql docs. regards anandkl On 10/22/08, Heston James - Cold Beans [EMAIL PROTECTED] wrote: Hi Rob, Thanks for getting back to me on this. You were right on the money with the imposed quota on that directory, I tried copying some large files across to the folder and found it limited to 8Mb for some reason, I'll look into removing that limit. One thing which is puzzling me at the moment is why its producing such large record sets from my query. Even when limiting the query to 700 records it still exceeds this 8Mb limit. The query is quite basic and is only returning very simple strings and integers, no more than maybe 8 chars long, like so: SELECT bluetooth_session.bluetooth_session_id AS bluetooth_session_bluetooth_session_id, bluetooth_session.result AS bluetooth_session_result, bluetooth_session.address AS bluetooth_session_address, bluetooth_session.message_id AS bluetooth_session_message_id, bluetooth_session.campaign_id AS bluetooth_session_campaign_id, bluetooth_session.created AS bluetooth_session_created, bluetooth_session.modified AS bluetooth_session_modified FROM bluetooth_session WHERE bluetooth_session.created %s ORDER BY bluetooth_session.created LIMIT 1, 699 bluetooth_session.result and bluetooth_session.address are both 8 character varchars and the rest are integers and dates. Would you really expect a record set from this query to be so large? Is there any way to make it smaller and more efficient? Cheers Rob, Heston -Original Message- From: Rob Wultsch [mailto:[EMAIL PROTECTED] Sent: 21 October 2008 16:49 To: Heston James - Cold Beans Cc: mysql@lists.mysql.com Subject: Re: Error Code 28 On Tue, Oct 21, 2008 at 8:26 AM, Heston James - Cold Beans [EMAIL PROTECTED] wrote: Afternoon all, I have a SELECT query which is returning the following error: (InternalError) (3, Error writing file '/tmp/MYqlGnfn' (Errcode: 28)) After doing a little searching on google all signs seem to point to a lack of disk space to be able to store the query results. However, I have several hundred MB left on the storage device and the database itself, in its entirety is only around 19Mb in size so it sees very strange to be causing that. Here is a quick output from 'fd -h' which displays the space on my storage device. FilesystemSize Used Avail Use% Mounted on rootfs973M 595M 330M 65% / udev 10M 20K 10M 1% /dev /dev/disk/by-label/ROOT_FS 973M 595M 330M 65% / /dev/disk/by-label/ROOT_FS 973M 595M 330M 65% /dev/.static/dev tmpfs 126M 0 126M 0% /lib/init/rw tmpfs 126M 0 126M 0% /dev/shm tmpfs 8.0M 0 8.0M 0% /rw/tmp Can anyone offer any suggestions as to what might be causing this issue and anything I can do to correct this? I'd really appreciate some help. I'm running MySQL 5 on a Debian based system. If you need any more information what so ever, please let me know. Cheers in advance, Heston 1. Just because your data set is small does not mean that mysql will not create a larger temporary file to store a temporary table. 2. If I had to guess I would say some sort of quota is in effect, also possibly for /tmp/ in particular. -- Rob Wultsch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error Code 28
Heston, What happens if you remove the Order By clause from the query? Does the file size drop? Also why are you using LIMIT 1, 699? The 1 skips the first row because that is the offset. If you just want the first 700 rows then use Limit 700 Mike At 06:29 AM 10/22/2008, you wrote: Hi Rob, Thanks for getting back to me on this. You were right on the money with the imposed quota on that directory, I tried copying some large files across to the folder and found it limited to 8Mb for some reason, I'll look into removing that limit. One thing which is puzzling me at the moment is why its producing such large record sets from my query. Even when limiting the query to 700 records it still exceeds this 8Mb limit. The query is quite basic and is only returning very simple strings and integers, no more than maybe 8 chars long, like so: SELECT bluetooth_session.bluetooth_session_id AS bluetooth_session_bluetooth_session_id, bluetooth_session.result AS bluetooth_session_result, bluetooth_session.address AS bluetooth_session_address, bluetooth_session.message_id AS bluetooth_session_message_id, bluetooth_session.campaign_id AS bluetooth_session_campaign_id, bluetooth_session.created AS bluetooth_session_created, bluetooth_session.modified AS bluetooth_session_modified FROM bluetooth_session WHERE bluetooth_session.created %s ORDER BY bluetooth_session.created LIMIT 1, 699 bluetooth_session.result and bluetooth_session.address are both 8 character varchars and the rest are integers and dates. Would you really expect a record set from this query to be so large? Is there any way to make it smaller and more efficient? Cheers Rob, Heston -Original Message- From: Rob Wultsch [mailto:[EMAIL PROTECTED] Sent: 21 October 2008 16:49 To: Heston James - Cold Beans Cc: mysql@lists.mysql.com Subject: Re: Error Code 28 On Tue, Oct 21, 2008 at 8:26 AM, Heston James - Cold Beans [EMAIL PROTECTED] wrote: Afternoon all, I have a SELECT query which is returning the following error: (InternalError) (3, Error writing file '/tmp/MYqlGnfn' (Errcode: 28)) After doing a little searching on google all signs seem to point to a lack of disk space to be able to store the query results. However, I have several hundred MB left on the storage device and the database itself, in its entirety is only around 19Mb in size so it sees very strange to be causing that. Here is a quick output from 'fd -h' which displays the space on my storage device. FilesystemSize Used Avail Use% Mounted on rootfs973M 595M 330M 65% / udev 10M 20K 10M 1% /dev /dev/disk/by-label/ROOT_FS 973M 595M 330M 65% / /dev/disk/by-label/ROOT_FS 973M 595M 330M 65% /dev/.static/dev tmpfs 126M 0 126M 0% /lib/init/rw tmpfs 126M 0 126M 0% /dev/shm tmpfs 8.0M 0 8.0M 0% /rw/tmp Can anyone offer any suggestions as to what might be causing this issue and anything I can do to correct this? I'd really appreciate some help. I'm running MySQL 5 on a Debian based system. If you need any more information what so ever, please let me know. Cheers in advance, Heston 1. Just because your data set is small does not mean that mysql will not create a larger temporary file to store a temporary table. 2. If I had to guess I would say some sort of quota is in effect, also possibly for /tmp/ in particular. -- Rob Wultsch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error Code 28
On Tue, Oct 21, 2008 at 8:26 AM, Heston James - Cold Beans [EMAIL PROTECTED] wrote: Afternoon all, I have a SELECT query which is returning the following error: (InternalError) (3, Error writing file '/tmp/MYqlGnfn' (Errcode: 28)) After doing a little searching on google all signs seem to point to a lack of disk space to be able to store the query results. However, I have several hundred MB left on the storage device and the database itself, in its entirety is only around 19Mb in size so it sees very strange to be causing that. Here is a quick output from 'fd -h' which displays the space on my storage device. FilesystemSize Used Avail Use% Mounted on rootfs973M 595M 330M 65% / udev 10M 20K 10M 1% /dev /dev/disk/by-label/ROOT_FS 973M 595M 330M 65% / /dev/disk/by-label/ROOT_FS 973M 595M 330M 65% /dev/.static/dev tmpfs 126M 0 126M 0% /lib/init/rw tmpfs 126M 0 126M 0% /dev/shm tmpfs 8.0M 0 8.0M 0% /rw/tmp Can anyone offer any suggestions as to what might be causing this issue and anything I can do to correct this? I'd really appreciate some help. I'm running MySQL 5 on a Debian based system. If you need any more information what so ever, please let me know. Cheers in advance, Heston 1. Just because your data set is small does not mean that mysql will not create a larger temporary file to store a temporary table. 2. If I had to guess I would say some sort of quota is in effect, also possibly for /tmp/ in particular. -- Rob Wultsch
Re: Error Code 28?
Hi ED, thats a number to big for me yet. Sorry. I guess thats better posted to the mailing list. The best I can do is an educated guess (or whatever thats called). And that would be some set limits either from mysql, because the search takes quite long (you could find out with log-slow-queries), or from the ASP side perhaps a time limit etc. Best regards Nils Valentin Tokyo/Japan 2003 8 13 01:00: Hey Nils,. Is there a way I can set error checking on a page? I have a test mySQL db that displays all the records in an ASP page. It works without a problem (it's only 10 records). Then I try it with the main db (and the 1.7 millions records), and it crashes, giving me a page cannot be displayed error. How can I find out where the problem is at? Thanks, Ed -Original Message- From: Nils Valentin [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 9:46 AM To: Ed Kraft Subject: Re: Error Code 28? Hi Ed, hmm, what does perror 28 say ? If I guess right than it shoud say no space left on device or something like this. This is only the partition where the data files are on. The other partitions are not of interest for this. Could you let me know which MySQL version and from where (MySQL or f.e Redhat) and which format (RPM or tar etc.) and which Linux OS. I will see what I can find out Best regards Nils Valentin Tokyo/Japan 2003 8 12 22:38: Thanks Nils. I am running this on Linux, but when I check my hd usage, I'm not full. I don't get it. :) Thanks, Ed -Original Message- From: Nils Valentin [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 9:26 AM To: Ed Kraft; [EMAIL PROTECTED] Subject: Re: Error Code 28? Hi ED, Very close you are. If you run Linux than this message means get a new Harddisk for me please ;-) I am full ;-) You can check this with perror 28. Perror works only for the OS dependent messages (1-150) The other you will have to figure out yourself ;-)... or you can check my homepage http://www.knowd.co.jp/staff/nils/mysql-error-codes.html Best regards Nils Valentin Tokyo/Japan 2003 8 12 21:18Ed Kraft : Hey All, Does anyone know what this error code means? I think it may have something to do with the database being too large. The exact error is, ERROR 1030: Got error 28 from table handler What I tried doing was importing into a mySQL db via a text file. There are approximately 1.7 million records in the text file (the text file is 467 mb). Any suggestions would be greatly appreciated. Thanks, Ed -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error Code 28?
Hi Ed, wouldn't that be the same cause no space left on device ?? A index is using perhaps another 30% of the whole table. Best regards Nils Valentin Tokyo/Tokyo 2003 8 13 00:27: Hey Nils, I just tried it again, and it worked. :) However, I tried creating a few indexes in the db within SQLyog (GUI front end), and got the same error (error 28 within table handler). Why would I be getting an error from trying to create an index? Thanks, Ed -Original Message- From: Nils Valentin [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 9:46 AM To: Ed Kraft Subject: Re: Error Code 28? Hi Ed, hmm, what does perror 28 say ? If I guess right than it shoud say no space left on device or something like this. This is only the partition where the data files are on. The other partitions are not of interest for this. Could you let me know which MySQL version and from where (MySQL or f.e Redhat) and which format (RPM or tar etc.) and which Linux OS. I will see what I can find out Best regards Nils Valentin Tokyo/Japan 2003 8 12 22:38: Thanks Nils. I am running this on Linux, but when I check my hd usage, I'm not full. I don't get it. :) Thanks, Ed -Original Message- From: Nils Valentin [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 9:26 AM To: Ed Kraft; [EMAIL PROTECTED] Subject: Re: Error Code 28? Hi ED, Very close you are. If you run Linux than this message means get a new Harddisk for me please ;-) I am full ;-) You can check this with perror 28. Perror works only for the OS dependent messages (1-150) The other you will have to figure out yourself ;-)... or you can check my homepage http://www.knowd.co.jp/staff/nils/mysql-error-codes.html Best regards Nils Valentin Tokyo/Japan 2003 8 12 21:18Ed Kraft : Hey All, Does anyone know what this error code means? I think it may have something to do with the database being too large. The exact error is, ERROR 1030: Got error 28 from table handler What I tried doing was importing into a mySQL db via a text file. There are approximately 1.7 million records in the text file (the text file is 467 mb). Any suggestions would be greatly appreciated. Thanks, Ed -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error code 28: No space left on device
What will happen on Error code 28: No space left on device? Will mysql crash down?... Will there be posibility of reading data from tables? I saw this error on one of my servers not too long ago. MySQL keeps running but seemingly refuses to do SELECTs on any tables. Upon freeing some space those same SELECTs went through fine without a restart of mysqld. I believe the default my.cnf uses /tmp for its temporary files. If this partition is full you may either free some space within it or alternatively specify a different location for MySQL's temporary files. See the tmpdir setting in my.cnf. e.g.: tmpdir = /usr/tmp/ Ron Jamison - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: Error code 28
Kittiphum, Monday, May 13, 2002, 8:52:38 AM, you wrote: KW Thanks after got your mail that perror 28 Error code 28: No space left on device KW I try to check my disk spack it have 2 GB space left so it may not cause by this problem .And I found that with MySQL 4.0.1 it error but not error in 3.23.49a KW thank again. What is the table type, what is the size of the database? KW Kittiphum Worachat,M.T. KW www.hatyailab.com -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Error code 28
you can use perror 28 to see what does that error code mean Rahul T -Original Message- From: Kittiphum Worachat [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 10:50 AM To: [EMAIL PROTECTED] Subject: Error code 28 Hello, mysql, In select field list if they have some field that field type is text or blob and if I use group by some filed MySQL will generate Got error 28 from table handler the query like this select a.f1,a.f2,a.f3,b.f1,b.f2 from table_a as a,table_b as b where a.f1=b.f1 and a.f1='xxx' group by b.f2 if f2.b if mediumtext I will got error 28 but when change type to varchar it OK but I realy need mediumtext type how to solve this problem Best regards. Kittiphum Worachat [EMAIL PROTECTED] 2002-05-13 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error code 28
On Monday, 13. May 2002 07:20, Kittiphum Worachat wrote: Hi, In select field list if they have some field that field type is text or blob and if I use group by some filed MySQL will generate Got error 28 from table handler the query like this select a.f1,a.f2,a.f3,b.f1,b.f2 from table_a as a,table_b as b where a.f1=b.f1 and a.f1='xxx' group by b.f2 if f2.b if mediumtext I will got error 28 but when change type to varchar it OK but I realy need mediumtext type how to solve this problem For a error description use perror perror 28 Error code 28: No space left on device So maybe you should delete some stuff on your disks or buy a new one. Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: Error code 28
Hi Rahul Torvi, and MySQL user group you can use perror 28 to see what does that error code mean Rahul T -Original Message- From: Kittiphum Worachat [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 10:50 AM To: [EMAIL PROTECTED] Subject: Error code 28 Hello, mysql, In select field list if they have some field that field type is text or blob and if I use group by some filed MySQL will generate Got error 28 from table handler the query like this select a.f1,a.f2,a.f3,b.f1,b.f2 from table_a as a,table_b as b where a.f1=b.f1 and a.f1='xxx' group by b.f2 if f2.b if mediumtext I will got error 28 but when change type to varchar it OK but I realy need mediumtext type how to solve this problem I found this error when use with MySQL verion 4.0.1 but with 3.23.49a it work find so that may be bug for 4.0.1 and again I still don't know what about code 28. Thanks. Kittiphum Worachat,M.T. www.hatyailab.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Error code 28
Hi, Georg Richter, Thanks after got your mail that perror 28 Error code 28: No space left on device I try to check my disk spack it have 2 GB space left so it may not cause by this problem .And I found that with MySQL 4.0.1 it error but not error in 3.23.49a thank again. Kittiphum Worachat,M.T. www.hatyailab.com On Monday, 13. May 2002 07:20, Kittiphum Worachat wrote: Hi, In select field list if they have some field that field type is text or blob and if I use group by some filed MySQL will generate Got error 28 from table handler the query like this select a.f1,a.f2,a.f3,b.f1,b.f2 from table_a as a,table_b as b where a.f1=b.f1 and a.f1='xxx' group by b.f2 if f2.b if mediumtext I will got error 28 but when change type to varchar it OK but I realy need mediumtext type how to solve this problem For a error description use perror perror 28 Error code 28: No space left on device So maybe you should delete some stuff on your disks or buy a new one. Regards Georg . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php