Strange Error in MySQL
Hello. I am receiving the following error when trying to insert into a field of type text: #1030 - Got error 139 from storage engine The data to be inserted should fit easily into a text field. In fact, this error only occurs for a particular record and other records with much larger data sets are not throwing the same error. Has anyone experienced something similar? I checked via Google but did not find any resources that helped. Any help would be greatly appreciated. Thanks. - Asad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Strange Error in MySQL
[snip] Hello. I am receiving the following error when trying to insert into a field of type text: #1030 - Got error 139 from storage engine The data to be inserted should fit easily into a text field. In fact, this error only occurs for a particular record and other records with much larger data sets are not throwing the same error. Has anyone experienced something similar? I checked via Google but did not find any resources that helped. Any help would be greatly appreciated. Thanks. [/snip] The row is too big. Are there other columns into which a large amount of data are being placed? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Strange Error in MySQL
#1030 - Got error 139 from storage engine The data to be inserted should fit easily into a text field. In fact, this error only occurs for a particular record and other records with much larger data sets are not throwing the same error. Has anyone experienced something similar? I checked via Google but did not find any resources that helped. Any help would be greatly appreciated. Thanks. http://bugs.mysql.com/bug.php?id=10035 http://bugs.mysql.com/bug.php?id=5682 ... might provide a clue. These could be found in a simple Google search: http://www.google.com/search?hl=enq=%22Got+error+139+from+storage+engine%22btnG=Google+Search Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Strange Error in MySQL
Hello. Yes, there are. In fact, other records have more data for this field in them and inserts for those records never threw an error. - Asad On Tue, 10 May 2005, Jay Blanchard wrote: [snip] Hello. I am receiving the following error when trying to insert into a field of type text: #1030 - Got error 139 from storage engine The data to be inserted should fit easily into a text field. In fact, this error only occurs for a particular record and other records with much larger data sets are not throwing the same error. Has anyone experienced something similar? I checked via Google but did not find any resources that helped. Any help would be greatly appreciated. Thanks. [/snip] The row is too big. Are there other columns into which a large amount of data are being placed? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Strange Error in MySQL
[snip] Hello. Yes, there are. In fact, other records have more data for this field in them and inserts for those records never threw an error. [/snip] Is the data for the other fields larger than usual? This field may be smaller, but the cumulative row length (the combined size of every field) is what is causing the error. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: Re: Strange Error with MySQL 4.0.4 under Win2K
Listen, Wednesday, November 20, 2002, 7:31:27 PM, you wrote: LH thanks for your great advice, finally pointing out the reason for the LH problem. SH mysql ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL SH PRIMARY KEY; SH ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to SH '.\trainee\#sql2-648-2.MYI' (Errcode: 13) This error can occur on Windows if you use lower_case_table_names=1. LH Which is turned on by default with MySQL 4.0.x. Is this a bug or a feature? LH ;-) There were some bugs fixed related to the lower_case_table_names=1 on Windows. Could you please provide more details or make a repeatable test case? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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: Strange Error with MySQL 4.0.4 under Win2K
Dear Egor, thanks for your great advice, finally pointing out the reason for the problem. SH mysql ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL SH PRIMARY KEY; SH ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to SH '.\trainee\#sql2-648-2.MYI' (Errcode: 13) This error can occur on Windows if you use lower_case_table_names=1. Which is turned on by default with MySQL 4.0.x. Is this a bug or a feature? ;-) Regards, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 19, 2002 7:52 PM Subject: re: Strange Error with MySQL 4.0.4 under Win2K Stefan, Sunday, November 17, 2002, 5:12:52 PM, you wrote: SH yesterday I imported some tables from MS Access via ODBC into my brand SH new MySQL 4.0.4 server. Everything went fine, but the tables did not SH have a primary key, so I did the following: SH mysql ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL SH PRIMARY KEY; SH ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to SH '.\trainee\#sql2-648-2.MYI' (Errcode: 13) This error can occur on Windows if you use lower_case_table_names=1. SH As PERROR says, 13 is permission denied. What's that? I can do the SH following: SH mysql CREATE TABLE auftrag_2 SELECT * FROM auftrag; SH Now, I can ALTER the auftrag_2 TABLE with no problems at all. SH Trying a workaround, I switched the default-table-type to innodb. Now, SH all the Access tables I import become innoDB tables, and I can ALTER SH TABLE auftrag like above without getting error 13. SH However, innoDB tables have a MyISAM style .frm file. I get a quite SH similar error when I try the following: SH mysql ALTER TABLE auftrag ADD FOREIGN KEY (Auftraggeber) REFERENCES SH auftraggeber(Schl); SH ERROR 1005: Can't create '.\trainee\#sql-6fc_2.frm'. (Error: 150) SH Seems to be an (internal) temporary table problem. Does anyone know SH what's happening, and how to solve this prob? Nope. It's not the same error. This error means that your foreign key definition is not correctly formed. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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 - 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: Strange Error with MySQL 4.0.4 under Win2K
Stefan, Sunday, November 17, 2002, 5:12:52 PM, you wrote: SH yesterday I imported some tables from MS Access via ODBC into my brand SH new MySQL 4.0.4 server. Everything went fine, but the tables did not SH have a primary key, so I did the following: SH mysql ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL SH PRIMARY KEY; SH ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to SH '.\trainee\#sql2-648-2.MYI' (Errcode: 13) This error can occur on Windows if you use lower_case_table_names=1. SH As PERROR says, 13 is permission denied. What's that? I can do the SH following: SH mysql CREATE TABLE auftrag_2 SELECT * FROM auftrag; SH Now, I can ALTER the auftrag_2 TABLE with no problems at all. SH Trying a workaround, I switched the default-table-type to innodb. Now, SH all the Access tables I import become innoDB tables, and I can ALTER SH TABLE auftrag like above without getting error 13. SH However, innoDB tables have a MyISAM style .frm file. I get a quite SH similar error when I try the following: SH mysql ALTER TABLE auftrag ADD FOREIGN KEY (Auftraggeber) REFERENCES SH auftraggeber(Schl); SH ERROR 1005: Can't create '.\trainee\#sql-6fc_2.frm'. (Error: 150) SH Seems to be an (internal) temporary table problem. Does anyone know SH what's happening, and how to solve this prob? Nope. It's not the same error. This error means that your foreign key definition is not correctly formed. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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
Strange Error with MySQL 4.0.4 under Win2K
Dear list, yesterday I imported some tables from MS Access via ODBC into my brand new MySQL 4.0.4 server. Everything went fine, but the tables did not have a primary key, so I did the following: mysql ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL PRIMARY KEY; ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to '.\trainee\#sql2-648-2.MYI' (Errcode: 13) As PERROR says, 13 is permission denied. What's that? I can do the following: mysql CREATE TABLE auftrag_2 SELECT * FROM auftrag; Now, I can ALTER the auftrag_2 TABLE with no problems at all. Trying a workaround, I switched the default-table-type to innodb. Now, all the Access tables I import become innoDB tables, and I can ALTER TABLE auftrag like above without getting error 13. However, innoDB tables have a MyISAM style .frm file. I get a quite similar error when I try the following: mysql ALTER TABLE auftrag ADD FOREIGN KEY (Auftraggeber) REFERENCES auftraggeber(Schl); ERROR 1005: Can't create '.\trainee\#sql-6fc_2.frm'. (Error: 150) Seems to be an (internal) temporary table problem. Does anyone know what's happening, and how to solve this prob? Thanks alot in advance! Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - 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