Jun Nishikawa
topaz****@m0n0m*****
2012年 4月 10日 (火) 02:31:10 JST
西川です。 すいません。昨日の問題は解決したのですが、 また別の原因で同じエラーが出ることを確認しました。 どうやら truncate table を流してしまうと、 次の INSERT から 『too long key』が出てしまうようです。 少々長いですが以下、再現手順です。 mysql> create database test; Query OK, 1 row affected (0.00 sec) mysql> use test Database changed mysql> create table foo (`id` int, `bar` text CHARACTER SET utf8, PRIMARY KEY (`id`) USING BTREE, FULLTEXT KEY `bar` (`bar`)) ENGINE=mroonga DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='engine "innodb"'; Query OK, 0 rows affected (0.44 sec) mysql> INSERT INTO foo (`ID`, `bar`) values (1, '<h3>内容説明</h3><div>Eliel and Eero Saarinen occupy a unique position in the history of modem design. From Helsinki\ '\) s famous railroad station to the Cranbrook Academy to the CBS Headquarters their work spans two continents and eight decades and has had a major influence on twentie th-century architecture and city planning. <i>Eliel Saarinen: Projects</i> stands alone in its treatment of the elder Saarinen\'s Finnish work in terms both of schol arship and production. Saarinen\'s ability to present his plans in expressive drawings was his trademark. Often considered independent works of art, 200 of these dra wings are reproduced here in full color and augmented by 900 black and white illustrations in an unusually fine example of architectural bookmaking.<br /><br />\nSaa rinen\'s Finnish years represent the laboratory within which he developed the skills and the concepts to advance an aesthetic of modem design responsive to internati onal trends yet steeped in regional expression. <i>Eliel Saarinen: Projects</i> follows every permutation of the architect\'s career from the Finnish Pavilion at the 1900 Paris World\'s Fair, which brought Saarinen and his partners to the forefront of the international scene, to his design of stamps and banknotes, his large city planning projects, and his successful competition for the Chicago Tribune office building, which in 1923 prompted Saarinen\'s move to the United States.<br /><br /> \nMarika Hausen provides a biography of Saarinen and a critical assessment of his handling of interiors and details, his execution of drawings, his use of stone and wood, and his design of building types ranging from country house to urban projects, followed by commentaries on the most important individual projects, including th e famous studio/home of Hvittrsk. Kirmo Mikkola discusses Saarinen\'s work in town planning, documenting 30 of his most important projects. Tytti Valto writes about Saarinen\'s partnership with Herman Gesellius and Armas Lindgren, covering some 210 architectural and town planning projects produced by the firm. And Anna-Lisa Ambe rg describes and catalogs Saarinen\'s arts and crafts and industrial design projects.<br /><br /><i>Eliel Saarinen: Projects</i> has been in preparation for almost a decade. Research was sponsored by the Kone Foundation. A publication of the Museum of Finnish Architecture.\n</div><h3>Book Description</h3><div>Eliel and Eero Saar inen occupy a unique position in the history of modem design. From Helsinki\'s famous railroad station to the Cranbrook Academy to the CBS Headquarters their work sp ans two continents and eight decades and has had a major influence on twentieth-century architecture and city planning. <i>Eliel Saarinen: Projects</i> stands alone in its treatment of the elder Saarinen\'s Finnish work in terms both of scholarship and production. Saarinen\'s ability to present his plans in expressive drawings w as his trademark. Often considered independent works of art, 200 of these drawings are reproduced here in full color and augmented by 900 black and white illustratio ns in an unusually fine example of architectural bookmaking. Saarinen\'s Finnish years represent the laboratory within which he developed the skills and the concepts to advance an aesthetic of modem design responsive to international trends yet steeped in regional expression. <i>Eliel Saarinen: Projects</i> follows every permuta tion of the architect\'s career from the Finnish Pavilion at the 1900 Paris World\'s Fair, which brought Saarinen and his partners to the forefront of the internatio nal scene, to his design of stamps and banknotes, his large city planning projects, and his successful competition for the Chicago Tribune office building, which in 1923 prompted Saarinen\'s move to the United States. Marika Hausen provides a biography of Saarinen and a critical assessment of his handling of interiors and detail s, his execution of drawings, his use of stone and wood, and his design of building types ranging from country house to urban projects, followed by commentaries on t he most important individual projects, including the famous studio/home of Hvittrsk. Kirmo Mikkola discusses Saarinen\'s work in town planning, documenting 30 of his most important projects. Tytti Valto writes about Saarinen\'s partnership with Herman Gesellius and Armas Lindgren, covering some 210 architectural and town plannin g projects produced by the firm. And Anna-Lisa Amberg describes and catalogs Saarinen\'s arts and crafts and industrial design projects. <i>Eliel Saarinen: Projects< /i> has been in preparation for almost a decade. Research was sponsored by the Kone Foundation. A publication of the Museum of Finnish Architecture.<br /></div>'); Query OK, 1 row affected (0.00 sec) mysql> select length(bar) from foo; +-------------+ | length(bar) | +-------------+ | 4743 | +-------------+ 1 row in set (0.00 sec) mysql> truncate table foo; Query OK, 0 rows affected (0.15 sec) mysql> INSERT INTO foo (`ID`, `bar`) values (1, '<h3>内容説明</h3><div>Eliel and Eero Saarinen occupy a unique position in the history of modem design. From Helsinki\'\) s famous railroad station to the Cranbrook Academy to the CBS Headquarters their work spans two continents and eight decades and has had a major influence on twentie th-century architecture and city planning. <i>Eliel Saarinen: Projects</i> stands alone in its treatment of the elder Saarinen\'s Finnish work in terms both of schol arship and production. Saarinen\'s ability to present his plans in expressive drawings was his trademark. Often considered independent works of art, 200 of these dra wings are reproduced here in full color and augmented by 900 black and white illustrations in an unusually fine example of architectural bookmaking.<br /><br />\nSaa rinen\'s Finnish years represent the laboratory within which he developed the skills and the concepts to advance an aesthetic of modem design responsive to internati onal trends yet steeped in regional expression. <i>Eliel Saarinen: Projects</i> follows every permutation of the architect\'s career from the Finnish Pavilion at the 1900 Paris World\'s Fair, which brought Saarinen and his partners to the forefront of the international scene, to his design of stamps and banknotes, his large city planning projects, and his successful competition for the Chicago Tribune office building, which in 1923 prompted Saarinen\'s move to the United States.<br /><br /> \nMarika Hausen provides a biography of Saarinen and a critical assessment of his handling of interiors and details, his execution of drawings, his use of stone and wood, and his design of building types ranging from country house to urban projects, followed by commentaries on the most important individual projects, including th e famous studio/home of Hvittrsk. Kirmo Mikkola discusses Saarinen\'s work in town planning, documenting 30 of his most important projects. Tytti Valto writes about Saarinen\'s partnership with Herman Gesellius and Armas Lindgren, covering some 210 architectural and town planning projects produced by the firm. And Anna-Lisa Ambe rg describes and catalogs Saarinen\'s arts and crafts and industrial design projects.<br /><br /><i>Eliel Saarinen: Projects</i> has been in preparation for almost a decade. Research was sponsored by the Kone Foundation. A publication of the Museum of Finnish Architecture.\n</div><h3>Book Description</h3><div>Eliel and Eero Saar inen occupy a unique position in the history of modem design. From Helsinki\'s famous railroad station to the Cranbrook Academy to the CBS Headquarters their work sp ans two continents and eight decades and has had a major influence on twentieth-century architecture and city planning. <i>Eliel Saarinen: Projects</i> stands alone in its treatment of the elder Saarinen\'s Finnish work in terms both of scholarship and production. Saarinen\'s ability to present his plans in expressive drawings w as his trademark. Often considered independent works of art, 200 of these drawings are reproduced here in full color and augmented by 900 black and white illustratio ns in an unusually fine example of architectural bookmaking. Saarinen\'s Finnish years represent the laboratory within which he developed the skills and the concepts to advance an aesthetic of modem design responsive to international trends yet steeped in regional expression. <i>Eliel Saarinen: Projects</i> follows every permuta tion of the architect\'s career from the Finnish Pavilion at the 1900 Paris World\'s Fair, which brought Saarinen and his partners to the forefront of the internatio nal scene, to his design of stamps and banknotes, his large city planning projects, and his successful competition for the Chicago Tribune office building, which in 1923 prompted Saarinen\'s move to the United States. Marika Hausen provides a biography of Saarinen and a critical assessment of his handling of interiors and detail s, his execution of drawings, his use of stone and wood, and his design of building types ranging from country house to urban projects, followed by commentaries on t he most important individual projects, including the famous studio/home of Hvittrsk. Kirmo Mikkola discusses Saarinen\'s work in town planning, documenting 30 of his most important projects. Tytti Valto writes about Saarinen\'s partnership with Herman Gesellius and Armas Lindgren, covering some 210 architectural and town plannin g projects produced by the firm. And Anna-Lisa Amberg describes and catalogs Saarinen\'s arts and crafts and industrial design projects. <i>Eliel Saarinen: Projects< /i> has been in preparation for almost a decade. Research was sponsored by the Kone Foundation. A publication of the Museum of Finnish Architecture.<br /></div>'); ERROR 1026 (HY000): too long key: (4743) mysql> select length(bar) from foo; Empty set (0.00 sec) 2012年4月9日18:02 Kouhei Sutou <kou****@clear*****>: > 須藤です。 > > In <CABp+NB6puO_YNQCxUFqrUro2C0q8=+c9Kh****@mail*****> > "[groonga-dev,00758] Re: ERROR 1026 (HY000): too long key: (4097)" on Mon, 9 Apr 2012 17:53:41 +0900, > Jun Nishikawa <topaz****@m0n0m*****> wrote: > >> create database からやり直したら正常に INSERT できるようになりました。 >> mroonga をインストールする前から使っていた database 上で >> create table していたのがまずかったようです。 > > うまく動くようになってよかったです！ > > -- > 須藤 功平 <kou****@clear*****> > 株式会社クリアコード <http://www.clear-code.com/> (03-6231-7270) > > プログラミングが好きなソフトウェア開発者を募集中: > http://www.clear-code.com/recruitment/ > > _______________________________________________ > groonga-dev mailing list > groon****@lists***** > http://lists.sourceforge.jp/mailman/listinfo/groonga-dev -- --------------------------------------------------------------------- Jun Nishikawa, CEO Monomono Co., Ltd. 西川 潤, CEO 合同会社モノモノ Tel: 090-6155-4271 Mail: topaz****@m0n0m***** Skype: topaz2.3333 Y!J Messenger: submarine_motor Twitter: http://twitter.com/topaz2_3333 Corporate Site: http://m0n0m0n0.com/ ----------------------------------------------------------------------
