yoku ts.
yoku0****@gmail*****
2013年 8月 29日 (木) 10:31:14 JST
こんにちは、yokuといいます。 こちら http://sourceforge.jp/projects/groonga/lists/archive/dev/2013-August/001712.html で村上さんがなさっているように、 バックトレースを取ると少し幸せになったりしますか…？ > すとーさん `Got error x from storage engine'の発生時にどうやってブレークさせようかとちょっと考えていたのですが、 こんな形でいけそうな気がしています。 (gdbでアタッチしてから"c"を叩くまではmysqldの処理が止まります) # gdb -p <mysqldのpid> gdb> b handler::print_error gdb> c Continuing. (ここでプロンプトが返ってこなくなる) ストレージエンジンからエラーが返るとgdbプロンプトが返ってくるので、 (ここからquitするまでの間、mysqldは処理が止まります) gdb> bt full .. gdb> quit でバックトレースが取れると思います。 いかがでしょう？ yoku ts. 2013年8月29日 3:16 K A <a_kira1****@hotma*****>: > 木村です。 > 須藤さんいろいろとお気遣いいただきありがとうございますm(_ _)m > > > 未解決ですが経過報告させていただきます。 > いただいたアドバイスを参考に、毎分cronによるチェックを走らせることを軸に検証を続けていますが、今のところはかばかしくありません。 > > 毎分チェックの内容は、「productsテーブルからcodeフィールド値300件をランダム抽出し、それをWHERE IN条件節に組み込んだSELECT文を構成し、DBに送って成否を判定する」というものです。 > CakePHPのシェルとして作成しています。 > > productsテーブルは、当初の構造から無関係なインデックスのみ消して、 > > CREATE TABLE IF NOT EXISTS `products` ( > `id` int(11) NOT NULL AUTO_INCREMENT, > `vendor_id` int(11) DEFAULT NULL, > `entity_id` int(11) DEFAULT NULL, > `title` varchar(255) NOT NULL, > `description` text NOT NULL, > `code` varchar(255) DEFAULT NULL, > `code_sub` varchar(255) DEFAULT NULL, > `released` date DEFAULT NULL, > `minutes` int(11) DEFAULT NULL, > `movie` smallint(6) NOT NULL, > `large_pic` smallint(6) NOT NULL, > `tag_pool` text NOT NULL, > `count` int(11) NOT NULL, > `bookmark_count` int(11) NOT NULL, > `created` datetime DEFAULT NULL, > `modified` datetime DEFAULT NULL, > PRIMARY KEY (`id`), > UNIQUE KEY `code_vendor_id` (`code`,`vendor_id`), > FULLTEXT KEY `ft_all` (`title`,`description`,`code`,`code_sub`,`tag_pool`) COMMENT 'normalizer "NormalizerAuto"' > ) ENGINE=mroonga DEFAULT CHARSET=utf8 COMMENT='engine "innodb"'; > > となっています。 > > > 現時点でほぼ確実と思われるのは以下のような点です。 > > まず、「WHERE `検索条件フィールド` IN (多数)」形式のクエリの「検索条件フィールド」がproducts.code以外の場合、「Got error 1 when reading table」エラーは発生しないようです。 > この点は、上記チェック用シェルの検索対象フィールドを同テーブルのidもしくはcode_subフィールドに変更して毎分実行しても、一向にエラーが発生しないことから判断しました。 > > また、エラーが起きるのはproductsテーブルに「code_vendor_id」ユニークインデックスと「ft_all」全文インデックスが両方ともある場合だけのようです。 > いずれか片方しかない場合に「Got error 1 when reading table」エラーが確認された例は今のところありません。 > しかし、この2つのインデックスを消して張り直してもエラーは再発します。 > > > また、productsテーブルから > > 1. ft_all全文インデックスを削除して、 > 2. エンジンを素のInnoDBに変更し、 > 3. 対応するmrnファイル群を削除（※下記URL参照）して、 > http://y-ken.hatenablog.com/entry/mroonga-already-used-name-was-assigned > 4. エンジンをmroongaラッパーモード（InnoDB）に戻し、 > 5. ft_all全文インデックスを再構築する、 > > といった実験もやってみましたが、単純にDBインポートした場合と同様に、しばらく正常に動作した後で同じエラーが起こります。 > 正常に動作する時間は長くても2時間程度だったかと思います。 > > なお、このエラーは1度起きると立て続けに発生する場合が大半ですが、「同タイプのクエリが二度と通らなくなる」わけではないようです。 > ときおり数分間にわたって成功率4割程度の時間帯があったり、2時間ほどエラーが続いた後で数分間成功したりと不安定です（このため、再現条件の検証に途方もなく手間取っています…）。 > > > あと、それとは別に一つ気になる点があります。 > サイトへの外部からのブラウザアクセスを遮断（アクセスがあった場合は静的なメインテナンスページを表示）してDBインポートを行った場合、アクセスを遮断したままの状態では、記憶にある限りまだ1度もエラーが起きたことがない、という点です。 > > たとえば、 > > 1. 外部アクセスを遮断してテスト用の新規データベースtestを準備 > 2. 既存の主DBからダンプしたデータをtestデータベースにインポート > 3. 直近のエラー時刻を参照し、その直前1分間のクエリログを検証して、疑わしいクエリを順次testデータベースに対して実行。その都度「WHERE 〜 IN 多数」クエリを送ってみてエラーが起きないかチェック→再発は確認できず。 > 4. そのtestデータベースをサイトの主DBに設定して、外部からのアクセスを許可。 > > といった作業をした後、しばらくしてエラーが再発するというパターンがこれまでに何度もありました。 > そのことから、あるいは複数のクエリを同時的にさばこうとした際になんらかの問題が起きている可能性はないんだろうか、という疑念もあります（「それはありえない」という場合は教えていただけると助かります）。 > > > 実働データを利用した実験には限界を感じ始めたので、明日からはトラブルの再現が可能なデータ作りに挑戦してみようかと思っています。 > また末尾に、トラブル再発直前の1分間のクエリログ（一例）をコピー＆ペーストしておきます。 > 一部名詞のみ、公人のお名前などで置き換えていますが、ほかは概ねログのままです。 > > ご覧のとおり完全に手探り状態なので、もし何かお気づきの点などがあれば、引き続きアドバイスをどうぞよろしくお願いしますm(_ _)m > > > > SELECT `Product`.`code`, `Product`.`count`, `Product`.`entity_id`, `Product`.`id` FROM `products` AS `Product` WHERE `Product`.`code` IN ( {※productsテーブルからランダム抽出した300件のproducts.code値} ) // ※ここまでは成功 > SELECT database() as `db` > SET NAMES utf8 > SHOW FULL COLUMNS FROM `db_main`.`visitors` > SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME = 'utf8_general_ci' > SELECT COUNT(*) AS `count` FROM `db_main`.`visitors` AS `Visitor` WHERE `Visitor`.`code` = '3e0887e483c67d2b79a92fb681a2fbcc' > UPDATE `db_main`.`visitors` AS `Visitor` SET `Visitor`.`visit_count` = `Visitor`.`visit_count` + 1 WHERE `Visitor`.`code` = '3e0887e483c67d2b79a92fb681a2fbcc' > SHOW FULL COLUMNS FROM `db_main`.`bookmarks` > SELECT `Visitor`.`id`, `Visitor`.`code`, `Visitor`.`visit_count`, `Visitor`.`bookmark_count`, `Visitor`.`review_link_count`, `Visitor`.`created`, `Visitor`.`modified` FROM `db_main`.`visitors` AS `Visitor` WHERE `Visitor`.`code` = '3e0887e483c67d2b79a92fb681a2fbcc' LIMIT 1 > SHOW FULL COLUMNS FROM `db_main`.`products_tags` > SHOW FULL COLUMNS FROM `db_main`.`tags` > SHOW FULL COLUMNS FROM `db_main`.`products` > SELECT `Product`.`bookmark_count`, `Product`.`code`, `Product`.`code_sub`, `Product`.`count`, `Product`.`created`, `Product`.`description`, `Product`.`entity_id`, `Product`.`id`, `Product`.`large_pic`, `Product`.`minutes`, `Product`.`movie`, `Product`.`released`, `Product`.`title`, `Vendor`.`id`, `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`products` AS `Product` LEFT JOIN `db_main`.`vendors` AS `Vendor` ON (`Product`.`vendor_id` = `Vendor`.`id`) WHERE `Product`.`id` = 222892 LIMIT 1 > SHOW FULL COLUMNS FROM `db_main`.`vendors` > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 222892 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `TagAlias`.`id`, `TagAlias`.`vendor_id`, `TagAlias`.`name`, `TagAlias`.`kana`, `TagAlias`.`alias_cache`, `TagAlias`.`type`, `TagAlias`.`code`, `TagAlias`.`private`, `TagAlias`.`count`, `TagAlias`.`entity_id`, `TagAlias`.`created`, `TagAlias`.`modified` FROM `db_main`.`tags` AS `TagAlias` WHERE `TagAlias`.`private` = '0' AND `TagAlias`.`entity_id` IN (32, 56521, 56522, 58165, 59229, 59230) > UPDATE `db_main`.`products` AS `Product` LEFT JOIN `db_main`.`products` AS `ProductEntity` ON (`Product`.`entity_id` = `ProductEntity`.`id`) LEFT JOIN `db_main`.`vendors` AS `Vendor` ON (`Product`.`vendor_id` = `Vendor`.`id`) SET `Product`.`count` = `Product`.`count` + 1 WHERE `Product`.`id` = 222892 > SET NAMES utf8 > SHOW TABLES FROM `db_main` > SHOW FULL COLUMNS FROM `db_main`.`visitors` > SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME = 'utf8_general_ci' > SELECT COUNT(*) AS `count` FROM `db_main`.`visitors` AS `Visitor` WHERE `Visitor`.`code` = '0c37396551ec65f52b70e89f8299fc68' > UPDATE `db_main`.`visitors` AS `Visitor` SET `Visitor`.`visit_count` = `Visitor`.`visit_count` + 1 WHERE `Visitor`.`code` = '0c37396551ec65f52b70e89f8299fc68' > SET NAMES utf8 > SELECT COUNT(*) AS `count` FROM `db_main`.`visitors` AS `Visitor` WHERE `Visitor`.`code` = '5c2f3428b9724d2d209830e3ed2795bd' > SHOW FULL COLUMNS FROM `db_main`.`bookmarks` > SELECT `Visitor`.`id`, `Visitor`.`code`, `Visitor`.`visit_count`, `Visitor`.`bookmark_count`, `Visitor`.`review_link_count`, `Visitor`.`created`, `Visitor`.`modified` FROM `db_main`.`visitors` AS `Visitor` WHERE `Visitor`.`code` = '0c37396551ec65f52b70e89f8299fc68' LIMIT 1 > UPDATE `db_main`.`visitors` AS `Visitor` SET `Visitor`.`visit_count` = `Visitor`.`visit_count` + 1 WHERE `Visitor`.`code` = '5c2f3428b9724d2d209830e3ed2795bd' > SELECT `Visitor`.`id`, `Visitor`.`code`, `Visitor`.`visit_count`, `Visitor`.`bookmark_count`, `Visitor`.`review_link_count`, `Visitor`.`created`, `Visitor`.`modified` FROM `db_main`.`visitors` AS `Visitor` WHERE `Visitor`.`code` = '5c2f3428b9724d2d209830e3ed2795bd' LIMIT 1 > SHOW FULL COLUMNS FROM `db_main`.`tags` > UPDATE `db_main`.`tags` AS `Tag` LEFT JOIN `db_main`.`tags` AS `TagEntity` ON (`Tag`.`entity_id` = `TagEntity`.`id`) LEFT JOIN `db_main`.`vendors` AS `Vendor` ON (`Tag`.`vendor_id` = `Vendor`.`id`) SET `Tag`.`count` = Tag.count + 1 WHERE `Tag`.`entity_id` IS NULL AND `Tag`.`type` = 'series' AND `Tag`.`name` = 'スカイハイ（テレ朝）' > UPDATE `db_main`.`tags` AS `Tag` LEFT JOIN `db_main`.`tags` AS `TagEntity` ON (`Tag`.`entity_id` = `TagEntity`.`id`) LEFT JOIN `db_main`.`vendors` AS `Vendor` ON (`Tag`.`vendor_id` = `Vendor`.`id`) SET `Tag`.`count` = Tag.count + 1 WHERE `Tag`.`entity_id` IS NULL AND `Tag`.`type` = 'actress' AND `Tag`.`name` = '釈由美子' > SHOW FULL COLUMNS FROM `db_main`.`vendors` > SHOW FULL COLUMNS FROM `db_main`.`vendors` > SELECT `Vendor`.`id`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`name` != 'Root' AND `Vendor`.`product_count` > 0 ORDER BY `Vendor`.`product_count` DESC > SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME = 'utf8_general_ci' > SELECT `Vendor`.`id`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`name` != 'Root' AND `Vendor`.`product_count` > 0 ORDER BY `Vendor`.`product_count` DESC > SHOW FULL COLUMNS FROM `db_main`.`product_search_hashes` > UPDATE `db_main`.`product_search_hashes` AS `ProductSearchHash` SET `ProductSearchHash`.`count` = ProductSearchHash.count + 1, `ProductSearchHash`.`count_wed` = ProductSearchHash.count_wed + 1, `ProductSearchHash`.`count_week` = ProductSearchHash.count_week + 1 WHERE `ProductSearchHash`.`hash` = 'q=series%3A%E6%8A%95%E7%A8%BF%E5%AE%9F%E8%A9%B1%EF%BC%88%E3%81%AA%E3%81%8C%E3%81%88STYLE%EF%BC%89' > UPDATE `db_main`.`product_search_hashes` AS `ProductSearchHash` SET `ProductSearchHash`.`count` = ProductSearchHash.count + 1, `ProductSearchHash`.`count_wed` = ProductSearchHash.count_wed + 1, `ProductSearchHash`.`count_week` = ProductSearchHash.count_week + 1 WHERE `ProductSearchHash`.`hash` = 'q=actress%3A%E5%85%89%E6%9C%88%E3%81%BE%E3%82%84&page=2' > SELECT `Tag`.`id`, `Tag`.`entity_id` FROM `db_main`.`tags` AS `Tag` WHERE `Tag`.`type` = 'series' AND `Tag`.`name` = 'スカイハイ（テレ朝）' AND `Tag`.`private` = '0' > SELECT `Tag`.`id`, `Tag`.`entity_id` FROM `db_main`.`tags` AS `Tag` WHERE `Tag`.`type` = 'actress' AND `Tag`.`name` = '釈由美子' AND `Tag`.`private` = '0' > DROP TEMPORARY TABLE IF EXISTS `tmp_products`; > CREATE TEMPORARY TABLE IF NOT EXISTS `tmp_products` (PRIMARY KEY(`product_id`)) ENGINE=MEMORY SELECT DISTINCT `Product`.`id` AS `product_id` FROM `products` AS `Product` WHERE MATCH(`Product`.`title`, `Product`.`description`, `Product`.`code`, `Product`.`code_sub`, `Product`.`tag_pool`) AGAINST('+000000000000000092596142684212' IN BOOLEAN MODE) > SHOW FULL COLUMNS FROM `db_main`.`tmp_products` > DROP TEMPORARY TABLE IF EXISTS `tmp_products`; > CREATE TEMPORARY TABLE IF NOT EXISTS `tmp_products` (PRIMARY KEY(`product_id`)) ENGINE=MEMORY SELECT DISTINCT `Product`.`id` AS `product_id` FROM `products` AS `Product` WHERE MATCH(`Product`.`title`, `Product`.`description`, `Product`.`code`, `Product`.`code_sub`, `Product`.`tag_pool`) AGAINST('+(000000000000000000361703683380 000000000000000092591713432115)' IN BOOLEAN MODE) > SELECT `TmpProduct`.`product_id`, `Product`.`bookmark_count`, `Product`.`code`, `Product`.`code_sub`, `Product`.`count`, `Product`.`created`, `Product`.`description`, `Product`.`entity_id`, `Product`.`id`, `Product`.`large_pic`, `Product`.`minutes`, `Product`.`movie`, `Product`.`released`, `Product`.`title`, `Product`.`vendor_id` FROM `db_main`.`tmp_products` AS `TmpProduct` LEFT JOIN `db_main`.`products` AS `Product` ON (`TmpProduct`.`product_id` = `Product`.`id`) WHERE 1 = 1 ORDER BY `Product`.`count` desc LIMIT 15 > SHOW FULL COLUMNS FROM `db_main`.`products` > SELECT `TmpProduct`.`product_id`, `Product`.`bookmark_count`, `Product`.`code`, `Product`.`code_sub`, `Product`.`count`, `Product`.`created`, `Product`.`description`, `Product`.`entity_id`, `Product`.`id`, `Product`.`large_pic`, `Product`.`minutes`, `Product`.`movie`, `Product`.`released`, `Product`.`title`, `Product`.`vendor_id` FROM `db_main`.`tmp_products` AS `TmpProduct` LEFT JOIN `db_main`.`products` AS `Product` ON (`TmpProduct`.`product_id` = `Product`.`id`) WHERE 1 = 1 ORDER BY `Product`.`count` desc LIMIT 15, 15 > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 3 > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 2 > SHOW FULL COLUMNS FROM `db_main`.`products_tags` > SHOW FULL COLUMNS FROM `db_main`.`products_tags` > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 274126 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 5166 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 2 > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 3 > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 216919 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 271985 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 3 > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 2 > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 225202 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 248712 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 2 > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 3 > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 256521 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 270824 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 2 > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 6926 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 3 > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 3 > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 277278 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 221552 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 2 > SELECT COUNT(*) AS `count` FROM `db_main`.`tmp_products` AS `TmpProduct` LEFT JOIN `db_main`.`products` AS `Product` ON (`TmpProduct`.`product_id` = `Product`.`id`) WHERE 1 = 1 > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 259463 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > DROP TEMPORARY TABLE IF EXISTS `tmp_products` > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 2 > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 259879 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 3 > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 237186 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 3 > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 259669 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 3 > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 270178 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 2 > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 266024 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 3 > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 268415 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT `Vendor`.`name`, `Vendor`.`name_ja` FROM `db_main`.`vendors` AS `Vendor` WHERE `Vendor`.`id` = 3 > SELECT `Tag`.`id`, `Tag`.`vendor_id`, `Tag`.`name`, `Tag`.`kana`, `Tag`.`alias_cache`, `Tag`.`type`, `Tag`.`code`, `Tag`.`private`, `Tag`.`count`, `Tag`.`entity_id`, `Tag`.`created`, `Tag`.`modified`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `db_main`.`tags` AS `Tag` JOIN `db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`product_id` = 281994 AND `ProductsTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`private` = '0' AND `Tag`.`entity_id` IS NULL > SELECT COUNT(*) AS `count` FROM `db_main`.`tmp_products` AS `TmpProduct` LEFT JOIN `db_main`.`products` AS `Product` ON (`TmpProduct`.`product_id` = `Product`.`id`) WHERE 1 = 1 > DROP TEMPORARY TABLE IF EXISTS `tmp_products` > SET NAMES utf8 > SELECT `Product`.`code` FROM `db_main`.`products` AS `Product` WHERE 1 = 1 ORDER BY rand() ASC LIMIT 300 > SELECT `Product`.`code`, `Product`.`count`, `Product`.`entity_id`, `Product`.`id` FROM `products` AS `Product` WHERE `Product`.`code` IN ( {※productsテーブルからランダム抽出した300件のproducts.code値} ) // ※ここで失敗 > > _______________________________________________ > groonga-dev mailing list > groon****@lists***** > http://lists.sourceforge.jp/mailman/listinfo/groonga-dev
