Bug #3442 ERROR 1030: Got error 139 from table handler
Submitted: 12 Apr 2004 1:47 Modified: 27 Apr 2004 14:00
Reporter: Sergey Frolovichev Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S2 (Serious)
Version:4.0.18-standard OS:Linux (SuSe 9.0)
Assigned to: Sergei Golubchik CPU Architecture:Any

[12 Apr 2004 1:47] Sergey Frolovichev
Description:
unable to update record in innodb table

How to repeat:
CREATE TABLE `AnketaNames` (
 `oid` int(10) unsigned NOT NULL default '0',
 `lang_id` int(10) unsigned NOT NULL default '0',
 `name` varchar(150) NOT NULL default '',
 `aboutme` text NOT NULL,
 `constitution_descr` text NOT NULL,
 `disablement` text NOT NULL,
 `profession` text NOT NULL,
 `religion` text NOT NULL,
 `languages_descr` text NOT NULL,
 `lifepriority_descr` text NOT NULL,
 `freeday_descr` text NOT NULL,
 `interests_descr` text NOT NULL,
 `music_descr` text NOT NULL,
 `sport_descr` text NOT NULL,
 `sexgetero_descr` text NOT NULL,
 `sexgomo_descr` text NOT NULL,
 `sexoften_descr` text NOT NULL,
 `sexrole_descr` text NOT NULL,
 `sexexcitation_descr` text NOT NULL,
 `sexpriority_descr` text NOT NULL,
 `target_descr` text NOT NULL,
 `lookfor_descr` text NOT NULL,
 `waitingfor` text NOT NULL,
 `education_descr` text NOT NULL,
 `happiness_descr` text NOT NULL,
 `painter_descr` text NOT NULL,
 `musician_descr` text NOT NULL,
 `discovery_descr` text NOT NULL,
 `advice_descr` text NOT NULL,
 `penissize_descr` text NOT NULL,
 `breastsize_descr` text NOT NULL,
 `human_descr` text NOT NULL,
 `errors_descr` text NOT NULL,
 `literature_descr` text NOT NULL,
 `progress_descr` text NOT NULL,
 `lost_descr` text NOT NULL,
 `goal_descr` text NOT NULL,
 `religion_descr` text NOT NULL,
 `work_descr` text NOT NULL,
 `place_descr` text NOT NULL,
 `firstlove_descr` text NOT NULL,
 `spendtime_descr` text NOT NULL,
 `worse_descr` text NOT NULL,
 `around_descr` text NOT NULL,
 `gays_descr` text NOT NULL,
 `dish_descr` text NOT NULL,
 `history_descr` text NOT NULL,
 `cityplace_descr` text NOT NULL,
 `toast_descr` text NOT NULL,
 `animals_descr` text NOT NULL,
 `favoritecity_descr` text NOT NULL,
 `notalk_descr` text NOT NULL,
 `wantchild_descr` text NOT NULL,
 `favotitefilm_descr` text NOT NULL,
 `imagine_descr` text NOT NULL,
 `book_descr` text NOT NULL,
 `entrainment_descr` text NOT NULL,
 `star_descr` text NOT NULL,
 `hate_descr` text NOT NULL,
 `charakter_descr` text NOT NULL,
 `parentknow_descr` text NOT NULL,
 `friends_descr` text NOT NULL,
 `lack_descr` text NOT NULL,
 `unhappy_descr` text NOT NULL,
 `seeself_descr` text NOT NULL,
 `writers_descr` text NOT NULL,
 `contact_descr` text NOT NULL,
 `mens_descr` text NOT NULL,
 `womens_descr` text NOT NULL,
 `porno_descr` text NOT NULL,
 `hatemore_descr` text NOT NULL,
 `die_descr` text NOT NULL,
 `spirit_descr` text NOT NULL,
 `motto_descr` text NOT NULL,
 `updated` timestamp(14) NOT NULL,
 `created` timestamp(14) NOT NULL,
 PRIMARY KEY  (`oid`,`lang_id`)
) TYPE=InnoDB;

insert into AnketaNames (oid,lang_id) values (1,2);

update AnketaNames set
parentknow_descr='- U moikh ot-ttsa i mat-teri sof-fsem ne p-pylo tet-tej!
- A vy togda otkuda vzialis#?
- Ia is Tallinnnna!

Znaiut, konechno. Slava bogu, sovetami ne pomogaiut...',
mens_descr='Ustojchivost# tseniu. Tseniu, chtoby polozhit#sia na nego mozhno bylo. Chtoby ruku pomoshchi, nakonets, protiagival, kogda sam konchit# ne mozhesh#...',
favotitefilm_descr='"Veselye rebiata" i "Molodaia Gavrdiia". Kakaia zh studiia snimala? "Magnum"? Net... Ne pomniu... No ne "BelAmi" - ehto tochno...',
firstlove_descr='"Devushka, vot vy vse govorite "A.Smit", "A.Smit", a "A" - ehto kto? Nu? Chto zhe vy molchite? Nu, kak zvali pervogo muzhchinu?" - "Valera?.."',
penissize_descr='Dajte-ka vzglianut#... Khm...Est# u menia mechta" - govarival kak-to Martin L. King... No pust# ego, s ego chernymi mechtami, a dlia moej mechty nadot# libo spinku krajne gibkuiu, chego ne zamechaetsia, libo che-kak lishnikh santimetrov dvadtsat#... Tak chto, skazhem, pozhaluj khotel by, no tol#ko na odin raz. Tak mozhno? Ugovorili. Kuda za tabletkami priezzhat#? Platit# chekom ili po karte mozhno? Na vashem bannere ssylka bitaia! A eshche - moj komp#iuter za mnoj shpionit! Khochu, chert poberi, zashchitit# svoiu prajvesi! Gde mozhno skachat# fdisk ili chto tam vy obychno predlagaete?',
imagine_descr='V 89-m godu v Tartu ni odna ... Nu, v obshchem, nikto ne govoril po-russki! na moj detskij neokrepshij organizm ehto proizvelo tiagchajshee vpechatlenie, s posledstviiami kotorogo ia borius# do sikh por.',
gays_descr='Kakie-to vse oni grubye, neotesannye, rzhut kak koni patlatye, matom rugaiutsia, pliuiutsia, vodku p#iut sivushnuiu po podvorotniam, gadiat v pod`ezdakh, sikamaniat... Mishen#ku, vnuchkA, v svoiu shajku zavlekli. Skripochku zabrosil i teper# vse s nimi da s nimi... "Budu," - govorit, - "babka, tapericha pevtsom izvestnym!" Potom vzdokhnet, kasatik, prigoriunitsia, nosikom kurnosym shmorknet: "Ili," - placha, "balerunom kakim-nibud#. Kak Merkurev!"',
religion_descr='Ia zh govoriu - solipsist! Vydumki vse ehto! Prichem moi zhe sobstvennye... I ot ehtogo grustno, tovarishchi... Kakogo zhe "iks" u menia takoe voobrazhenie nebogatoe?!..',
lost_descr='Uznal, chto Serena Vil#iams - devushka. Kakogo parnia my poteriali!',
happiness_descr='Ot zhe sh# liudi! V samye potemki, panimaish#, dushi, mozhno skazat#, lezut. Nu vot predstav#te: prikhodit vam povestka. Mol, tak i tak, dorogoj grazhdanin, zaviazyvaj, davaj, so vsej ehtoj grazhdanskoj tiagomotinoj i - milosti prosim k nam, k nastoiashchim mushchshchinam. Pocheshesh# tut repu, poproshchaesh#sia, na vsiakij na raznyj, s rodnymi i blizkimi, soberesh# polkraiushki chernogo, da lukovichku, da "Zhillett Mak 3", da i pojdesh#, kruchinias#, v obitel# stradanij. A tam tebe bravyj usatyj praporshchik, suvorovskij chudo-bogatyr#, votknuv poluslepen#kij glaz v spisok, i skazhet: "Netu tebia, sokolik, tutochki! Oshibochka, deskat#, vyshla! Prokhodi, ne zaderzhivaj, chego vstal?" Vot ehto, tovarishchi, i est# bol#shoe i v chem-to chelovecheskoe schast#e... Net?',
seeself_descr='Znachit tak, 1-e sentiabria, tut vot po podol#chiku volany, volany, tut vot festonchiki, kruzhavchiki takie, tut vot i tam vot oborochki, riushi takie nariadnye. A vokrug - suvorovtsy, kursanty morekhodnykh uchilishch, sotrudniki sluzhb bezopasnosti vedushchikh rossijskikh bankov, pozharniki, dokhtura i lichno prezident Rossii Vladimir Vladimirovich Putin. A ia im vsem - "Ot litsa pionerskoj molodezhi vsej strany! Ot imeni pionerov-geroev! Po porucheniiu nashej shkoly! Diaden#ki! Ebites# vse v zhopu!"',
painter_descr='Davecha lorniroval graviurki Shemiakina (ili kak ehto? li-to-gra-fi-i! o!) i ponial - vot on tochno net! Srazu vspominaetsia "Vattsn! A sho konkretno ona khotela ehtim skzat#?!" Net otveta. Molchit rybka, dazhe khvostikom, pala, ne mashet. Zoia, ponimash#, Kosmodem#ianskaia, etit# eio... Vot Shishkina liubliu - on u menia v detstve na kovre byl vyshit. Nu prosto vylityj, kak zhivoj! Tol#ko ne mog poniat#, kakoj iz ehtikh troikh na brevnyshkakh - sam Shishkin. Pokhozhi, cherti, drug na druga. Kuindzhi liubliu - sam v Sevastopole na RGB ego "Noch#" razlozhit# proboval. Dejstvitel#no - odin zelenyj tsvet... ',
die_descr='Tol#ko ne tak, chtoby kogda ia zanimalsia liubov#iu na menia by slon nastupil! Chto-nibud# bolee pravdopodobnoe i veroiatnoe, a to tak i ne umresh#, nafig, nikogda...',
toast_descr='"Za prisutstvuiushchikh zdes# dam!" Ni razu, verite net, tak i ne udalos# ego do kontsa proiznesti. Vse vremia parni mordu bit# lezut...',
spirit_descr='Takoe, znaete li, bodren#koe. No golod muchaet vse sil#nee... Kogda zhe pojdu pozhrat#?',
favoritecity_descr='Ia shchas razryvaius# mezhdu Antananarivu i Tegusigal#poj. Vse nikak ne mogu vybrat#. A est# takie mesta, gde belogo cheloveka tseniat na ves zolota?',
around_descr='Libo kak sutulyj ochkarik v rastianutom svitere, s kotorogo sypetsia perkhot# pri kazhdom neostorozhnom dvizhenii, a o slove "pricheska" v moem prisutstvii govorit# prosto ne priniato, libo kak pyshnovolosaia blondinka, kotoraia tol#ko chto vyshla iz vannoj i na barkhatnoj kozhe eia vysokoj grudi eshche ne vysokhli kapel#ki vody...

Chert, vykhodit vse ravno bol#she, chem odno slovo...',
history_descr='Nam kak-to v shkole govorili, chto Diujmovochka dejstvitel#no sushchestvovala, a Andersen eio istoriiu voobshche iz arkhiva kakoj-to datskoj bol#nitsy poper, - tak vot ona. A chego? Mesto mnogo v kvartire ne zanimaet, vsegda mozhno na nee tsyknut#, a uzh kak pomoshchnitsa medvezhatnika - luchshe i ne syskat#!',
errors_descr='Znaete, davecha tut devochka odna integral bytalas# vziat# ot nev#ebennogo mnogochlena - chut# rot, durochka, ne porvala... I net by ej, durekhe, na spinu lech#, da golovu svesit# - legche b poshlo, tak it# net, gordaia! Luchshe, govorit, umeret# stoia, chem zakhlebnut#sia. Vot takie oshibki, tovarishchi, mozhno i, bolee togo, nuzhno proshchat#! Nu deti, chto s nikh vziat#?',
progress_descr='Sderzhal sebia v rukakh i ne stal strich#sia pod poluboks, kak ni ugovarivali. Eshche prochital pro "Khlopkovoe delo" i perestal zanimat#sia pripiskami na rabote... Akh, da! Nakonets-to na vody vybralsia! V pervyj raz za tuevu khuchu mesiatsev! Skol#ko tel na pliazhakh! Da kakikh! Odno drugogo krashe (v smysle - krasnee, davecha voobshche odnogo videl - kak rak varenyj, pravo slovo...)',
cityplace_descr='Nu znaete... Tak srazu i ne skazhesh#... Khotia, priglianulas# mne tut odna kvartirka, domik takoj nichego, sosedi opiat# zhe privetlivye... Tol#ko vot khoziaeva, ssuki, vse doma da doma sidiat - net chtoby na dachu kakuiu vybrat#sia, k moriu, v les, za gribami! Sidiat, ponimaesh#, i vse tut! A cherez okna mnogo ne nasmotrish#... Da i zamesti mogut... Tak chto chto tam vnutri - vrat# ne stanu, ne videl... Poka eshche...',
dish_descr='Goviadina po-pikantnomu s otsrym sousom! Predstav#te sebe semikratno razmorozhennoe-zamorozhennoe miaso, voniaiushchee tak, chto ego smrad ne mozhet otshibit# dazhe polbanki uksusa, pertsa i ketchupa, podannoe na zalapannoj tarelke v pivniake u Moskovskogo vokzala! Voistinu, chto mozhet byt# prekrasnej? Chto eshche tak tonko, tochno i bez prikras vyrazit nashu dushu russkogo cheloveka, ia vas vnimatel#no sprashivaiu?',
porno_descr='Nu vot polozha ruku na serdtse, chestno vam skazhu - ochen#! Ochen#, tovarishchi, pornografiia menia vozbuzhdaet! I nasha, otechestvennaia, vozbuzhdaet, i ikhniaia, importnaia, chto-to takoe v dushe zatragivaet... Da chto tam daleko za primerami khodit# - davecha vot naryl sebe galereiu "Moloden#kie mal#chiki 15-ti let ublazhaiut babushek za 60". Vot gde, dolzhen ia vam skazat#, podlinnoe iskusstvo! Vot gde shirota razmakha i podlinnyj katarsis!',
motto_descr='- Sic transit gloria mundi!
- Za "mundi" otvetish#!',
worse_descr='Rannim prekrasnym vesennim utrom, kogda nikuda ne nado speshit#, ty tikhonechko prosypaesh#sia, ulybaias# solntsu i sinemu nebu, netoroplivo potiagivaesh#sia, erosha volosy sebe i dremliushchemu riadom na podushke svetlovolosomu kudriavomu paren#ku, krasivomu kak tysiachedollarovaia bumazhka, i, sunuv nogi v shlepantsy, otpravliaesh#sia po obychnym utrennim delam. Zaperevshis# iznutri, ty prispukaesh# trusy i lezesh# rukoj, chtoby dostat# EGO, a tam - PIZDA!..

Vot ehto, tovarishchi, ochen#, znaete li, nepriiatnoe oshchushchenie, i po men#shej mere khotelos# by ego kak-nibud# izbezhat#. A luchshe dazhe na ehto na samoe oshchushchenie dazhe i ne namiakivat#...',
goal_descr='Vot shchas dokuriu, pojdu poem. Ili vy v global#nom plane antiresuetes#?',
charakter_descr='Ugriumaia pizdlivost#.',
work_descr='Nu, tut dva varianta. Libo priobshchit#sia k skromnomu klassu skromnykh jeldunov (oni zhe rant#e), libo s kajlom v zaboj: potnye, griaznye, polugolye grubye kak slog Prokhanova muzhiki - chto mozhet byt# krashe?!',
writers_descr='1. Ril#ke i Lorka - poehty.
2. Kafka i Kendke - prozaiki.
5. Dostoevskij, Tarkovskij i Kobo Abe - ambivalentny i polifonichny.
8. Kitajskaia poehziia namnogo ton#she i glubzhe iaponskoj.',
star_descr='Tol#ko ne Monikoj Beluchchi! Ona mne sovershenno neizvestna. Zato mne izvesten Vas#ka - vot im by ia khotel byt#. No tol#ko nedolgo, a to skoro domoj vozvrashchat#sia, koshka ne pustit. Ona do chuzhikh - diuzhe liutaia...',
place_descr='"A u vas drugogo globusa net?" No tol#ko ne v Cherapundzhi - tam takie dozhdi, chto vsia gandzha gniet na korniu, ia vas umoliaiu!',
contact_descr='Znachit, s odnim - na strel#bishche, so vtorym - na sklade, s tret#im - v gostiakh, s chetvertym - v klube, s piatym... Bozhe, gde zhe ia poznakomilsia s piatym? Zabyl, chert voz#mi... Khotia, byt# mozhet, ehto on so mnoj poznakomilsia? Togda s nego i spros... ',
advice_descr='Nu, ikh srazu neskol#ko!

"V bol#shoj sem#e kliuvom ne shchelkaj" - ehto raz.
"Vykhodia iz samoleta - ubedis# v nalichii trapa" - ehto dva.
"V kompanii matrosov na podvodnojlodke v avtonomnom plavanii ne perekhodi na "-la", predvaritel#no ne vkolov obezbolivaiushchee vo vse trepetnye mesta" - ehto tri.
Nu i, konechno zhe, "Ne podmazhesh# - ne poedesh#" - ehto chetyre i samoe, navernoe, glavnoe...',
musician_descr='Shnitke, konechno! Znatnyj byl balalaeshnik! Zhalko, na gastroliakh nedavno pomre... Odna Gubajdulina nas na dombre po-prezhnemu raduet... Arno Piart, vot, na lozhkakh fachit kak adskij boss, Ehdik Denisov tozhe gusliar byl preotmennejshij (ne slyshno davno ego chto-to, neuzhto tozhe konej dvinul?!)... Chert, prosto kvartet "Druzhba narodov" kakoj-to poluchaetsia...',
book_descr='"Mne nravitsia KOBOL", "Sistemnoe programmirovanie na Bejsike" i "Muzhchiny - poveliteli Vselennoj".',
lack_descr='Ia lazhu vizhu. Kak Vanga! Da chto tam Vanga - Dzhuna otzhimaetsia i nervno kurit v tualete - o kak ia lazhu vizhu! A s ehtim zhit# trudno... Vot i maius#, mesta ne nakhozhu...',
friends_descr='Molchalivost#, zelenye glaza, inostrannoe grazhdanstvo, neogranichennyj kredit v "Morgan Stenli"... Da! I chtoby chelovek, konechno zhe, byl khoroshij! Bez ehtogo posejchas nu nikuda nel#zia!',
unhappy_descr='Esli by k nam, prostym russkim parniam, stali by otnositsia kak v Amerike k chernokozhim geiam. Ia b povesilsia! Vernite stat#iu v UK! Raj-kov! Raj-kov! Raj-kov!',
literature_descr='Sasha Blo i Maliuta iz anal#no-vytesniaiushchego. Chto za liudi byli! Kuda tam vashej Zhikhorke s Grzhmelikom! Vera Shibeko i Aza Likhitchenko slez#mi by obrydalis#, popadi im v ruki nechto podobnoe... Khotia, po chesnoku, kruche, chem Popad#ia iz skazki Tolstogo (Fehta) "Na dne" ia ne vstrechal, polozha ruku na serdtse...',
animals_descr='Klopy schitaiutsia? Tarakanov uzhe vsekh vyvel (melok "Mashen#ka" - rekomenduiu!) Koshka poka derzhitsia, no tozhe podozritel#no kositsia v storonu vkhodnoj dveri. Vchera nashel v uglu sobrannye v uzelok eio veshchi. Nachal podozrevat# khudshee. Mne kazhetsia, ona khochet menia brosit#. Pojdu, peresmotriu eshche raz "Psikho" v interpretatsii Van Senta i reshu, kak byt#...',
entrainment_descr='Ebat#sia? Drochit#? Kurit#? Net, vse ne to, vse kak-to nekomil#fotno... Viazanie i vyshivanie na pial#tsakh bolgarskim krestikom po kanve ostavim dlia devushek... Chto zhe vspomnit#? A, vot! Poiu i risuiu. Ot pervogo veshaiutsia sosedi i koshka, ot vtorogo - ia sam.',
education_descr='Skazal by! Tak it# zh deti zh tut... Nachnut: "Tozhe khochu tuda! Tozhe! Tam tak veselo!" A vinovatyj i krajnij kto potom? Pravil#no - diadia Kolia! On, pala, poduchil! On, los#, rebenku budushchee ispokhanil! Atu!.. Zato vot iasel#ki u menia byli zamechatel#nye. Nu prosto chudo, chto za iasel#ki. Numer 42, kak shchas pomniu! Lezhim my, tit#ku prosim... Khotia net, ehto iz drugogo fil#ma...',
wantchild_descr='Pomilujte! V zhivogo rebenka khuem tykat#?! Za ehto zh daiut bol#she, chem im sejchas est#! Ne, imet# detej ia reshitel#no otkazyvaius#!',
hatemore_descr='Kogda vkhodiat bez razresheniia...',
human_descr='Ehta nu kogda on togo tipa tam slova vsiakie i kak by mysli nu koroche vrode kak tak vsio gramotno i tuda siuda i koroche telki vse ego i vse takoe',
lang_id='2'
where oid=1 and lang_id=2
[27 Apr 2004 14:00] Sergei Golubchik
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

error 139 means "too big row"
InnoDB manual specifies  that max. row length is slightly more than 8000 bytes.
Though blobs are excluded, still first 512 bytes of each blob are not.
You have som many blobs in the table that 512-byte prefixes of blob data are already about 11K, so you get an error "too big row".

Sorry za zaderzhku s otvetom, kazhdyj raz pytajas' otvetit' nachinal chitat' test case i rabochee nastroenie bezvozvratno uletuchivalos' :)