{"action":"closed","number":67,"pull_request":{"url":"https://api.github.com/repos/yohoushi/yohoushi/pulls/67","id":30262778,"html_url":"https://github.com/yohoushi/yohoushi/pull/67","diff_url":"https://github.com/yohoushi/yohoushi/pull/67.diff","patch_url":"https://github.com/yohoushi/yohoushi/pull/67.patch","issue_url":"https://api.github.com/repos/yohoushi/yohoushi/issues/67","number":67,"state":"closed","locked":false,"title":"Fix Mysql2::Error: Got a packet bigger than 'max_allowed_packet' bytes","user":{"login":"sonots","id":2290461,"avatar_url":"https://avatars.githubusercontent.com/u/2290461?v=3","gravatar_id":"","url":"https://api.github.com/users/sonots","html_url":"https://github.com/sonots","followers_url":"https://api.github.com/users/sonots/followers","following_url":"https://api.github.com/users/sonots/following{/other_user}","gists_url":"https://api.github.com/users/sonots/gists{/gist_id}","starred_url":"https://api.github.com/users/sonots/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sonots/subscriptions","organizations_url":"https://api.github.com/users/sonots/orgs","repos_url":"https://api.github.com/users/sonots/repos","events_url":"https://api.github.com/users/sonots/events{/privacy}","received_events_url":"https://api.github.com/users/sonots/received_events","type":"User","site_admin":false},"body":"I got an error like\r\n\r\n```\r\nMysql2::Error: Got a packet bigger than 'max_allowed_packet' bytes: SELECT  tags.*, taggings.tags_count AS count FROM `tags` JOIN (SELECT taggings.tag_id, COUNT(taggings.tag_id) AS tags_count FROM `taggings` INNER JOIN nodes ON nodes.id = taggings.taggable_id AND nodes.type = 'Graph' WHERE (taggings.taggable_type = 'Node' AND taggings.context = 'tags') AND (taggings.taggable_id IN (18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,188593,188594,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,188597,188598,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,188599,188600,173165,173166,173167,173168,173169,173170,173171,173172,173173,173174,173175,173176,173177,188595,188596,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,188601,188602,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,188607,188608,46554,46555,46556,46557,46558,\r\n```\r\n\r\nIt seems that the client query is too big in terms of bytes. \r\n\r\nBecause, currently, the tagcloud is sorted in alphabetical order rather than tag count order, I noticed that\r\n\r\n```\r\nGraph.tag_counts_on(:tags)\r\n```\r\n\r\ncan be simply\r\n\r\n```\r\nTag.all\r\n```\r\n\r\n(except garbage tags which nobody uses)","created_at":"2015-03-02T07:14:33Z","updated_at":"2015-03-02T07:48:30Z","closed_at":"2015-03-02T07:48:29Z","merged_at":"2015-03-02T07:48:28Z","merge_commit_sha":"1f93c9bc2407660b8b70e196f21a57faa2f1cb77","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/yohoushi/yohoushi/pulls/67/commits","review_comments_url":"https://api.github.com/repos/yohoushi/yohoushi/pulls/67/comments","review_comment_url":"https://api.github.com/repos/yohoushi/yohoushi/pulls/comments{/number}","comments_url":"https://api.github.com/repos/yohoushi/yohoushi/issues/67/comments","statuses_url":"https://api.github.com/repos/yohoushi/yohoushi/statuses/4a831d60e1e069cb2778ee2fed6b92bf70edef35","head":{"label":"yohoushi:max_allowed_packet","ref":"max_allowed_packet","sha":"4a831d60e1e069cb2778ee2fed6b92bf70edef35","user":{"login":"yohoushi","id":5027596,"avatar_url":"https://avatars.githubusercontent.com/u/5027596?v=3","gravatar_id":"","url":"https://api.github.com/users/yohoushi","html_url":"https://github.com/yohoushi","followers_url":"https://api.github.com/users/yohoushi/followers","following_url":"https://api.github.com/users/yohoushi/following{/other_user}","gists_url":"https://api.github.com/users/yohoushi/gists{/gist_id}","starred_url":"https://api.github.com/users/yohoushi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yohoushi/subscriptions","organizations_url":"https://api.github.com/users/yohoushi/orgs","repos_url":"https://api.github.com/users/yohoushi/repos","events_url":"https://api.github.com/users/yohoushi/events{/privacy}","received_events_url":"https://api.github.com/users/yohoushi/received_events","type":"Organization","site_admin":false},"repo":{"id":11520632,"name":"yohoushi","full_name":"yohoushi/yohoushi","owner":{"login":"yohoushi","id":5027596,"avatar_url":"https://avatars.githubusercontent.com/u/5027596?v=3","gravatar_id":"","url":"https://api.github.com/users/yohoushi","html_url":"https://github.com/yohoushi","followers_url":"https://api.github.com/users/yohoushi/followers","following_url":"https://api.github.com/users/yohoushi/following{/other_user}","gists_url":"https://api.github.com/users/yohoushi/gists{/gist_id}","starred_url":"https://api.github.com/users/yohoushi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yohoushi/subscriptions","organizations_url":"https://api.github.com/users/yohoushi/orgs","repos_url":"https://api.github.com/users/yohoushi/repos","events_url":"https://api.github.com/users/yohoushi/events{/privacy}","received_events_url":"https://api.github.com/users/yohoushi/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/yohoushi/yohoushi","description":"Yohoushi is a graphing tool, which works together with GrowthForecast","fork":false,"url":"https://api.github.com/repos/yohoushi/yohoushi","forks_url":"https://api.github.com/repos/yohoushi/yohoushi/forks","keys_url":"https://api.github.com/repos/yohoushi/yohoushi/keys{/key_id}","collaborators_url":"https://api.github.com/repos/yohoushi/yohoushi/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/yohoushi/yohoushi/teams","hooks_url":"https://api.github.com/repos/yohoushi/yohoushi/hooks","issue_events_url":"https://api.github.com/repos/yohoushi/yohoushi/issues/events{/number}","events_url":"https://api.github.com/repos/yohoushi/yohoushi/events","assignees_url":"https://api.github.com/repos/yohoushi/yohoushi/assignees{/user}","branches_url":"https://api.github.com/repos/yohoushi/yohoushi/branches{/branch}","tags_url":"https://api.github.com/repos/yohoushi/yohoushi/tags","blobs_url":"https://api.github.com/repos/yohoushi/yohoushi/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/yohoushi/yohoushi/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/yohoushi/yohoushi/git/refs{/sha}","trees_url":"https://api.github.com/repos/yohoushi/yohoushi/git/trees{/sha}","statuses_url":"https://api.github.com/repos/yohoushi/yohoushi/statuses/{sha}","languages_url":"https://api.github.com/repos/yohoushi/yohoushi/languages","stargazers_url":"https://api.github.com/repos/yohoushi/yohoushi/stargazers","contributors_url":"https://api.github.com/repos/yohoushi/yohoushi/contributors","subscribers_url":"https://api.github.com/repos/yohoushi/yohoushi/subscribers","subscription_url":"https://api.github.com/repos/yohoushi/yohoushi/subscription","commits_url":"https://api.github.com/repos/yohoushi/yohoushi/commits{/sha}","git_commits_url":"https://api.github.com/repos/yohoushi/yohoushi/git/commits{/sha}","comments_url":"https://api.github.com/repos/yohoushi/yohoushi/comments{/number}","issue_comment_url":"https://api.github.com/repos/yohoushi/yohoushi/issues/comments{/number}","contents_url":"https://api.github.com/repos/yohoushi/yohoushi/contents/{+path}","compare_url":"https://api.github.com/repos/yohoushi/yohoushi/compare/{base}...{head}","merges_url":"https://api.github.com/repos/yohoushi/yohoushi/merges","archive_url":"https://api.github.com/repos/yohoushi/yohoushi/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/yohoushi/yohoushi/downloads","issues_url":"https://api.github.com/repos/yohoushi/yohoushi/issues{/number}","pulls_url":"https://api.github.com/repos/yohoushi/yohoushi/pulls{/number}","milestones_url":"https://api.github.com/repos/yohoushi/yohoushi/milestones{/number}","notifications_url":"https://api.github.com/repos/yohoushi/yohoushi/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/yohoushi/yohoushi/labels{/name}","releases_url":"https://api.github.com/repos/yohoushi/yohoushi/releases{/id}","created_at":"2013-07-19T05:16:29Z","updated_at":"2015-03-02T06:22:12Z","pushed_at":"2015-03-02T07:48:28Z","git_url":"git://github.com/yohoushi/yohoushi.git","ssh_url":"git@github.com:yohoushi/yohoushi.git","clone_url":"https://github.com/yohoushi/yohoushi.git","svn_url":"https://github.com/yohoushi/yohoushi","homepage":"","size":1930,"stargazers_count":26,"watchers_count":26,"language":"Ruby","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":5,"mirror_url":null,"open_issues_count":4,"forks":5,"open_issues":4,"watchers":26,"default_branch":"master"}},"base":{"label":"yohoushi:master","ref":"master","sha":"2450ceed723b0bdd44212a71a307f95e00b25a71","user":{"login":"yohoushi","id":5027596,"avatar_url":"https://avatars.githubusercontent.com/u/5027596?v=3","gravatar_id":"","url":"https://api.github.com/users/yohoushi","html_url":"https://github.com/yohoushi","followers_url":"https://api.github.com/users/yohoushi/followers","following_url":"https://api.github.com/users/yohoushi/following{/other_user}","gists_url":"https://api.github.com/users/yohoushi/gists{/gist_id}","starred_url":"https://api.github.com/users/yohoushi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yohoushi/subscriptions","organizations_url":"https://api.github.com/users/yohoushi/orgs","repos_url":"https://api.github.com/users/yohoushi/repos","events_url":"https://api.github.com/users/yohoushi/events{/privacy}","received_events_url":"https://api.github.com/users/yohoushi/received_events","type":"Organization","site_admin":false},"repo":{"id":11520632,"name":"yohoushi","full_name":"yohoushi/yohoushi","owner":{"login":"yohoushi","id":5027596,"avatar_url":"https://avatars.githubusercontent.com/u/5027596?v=3","gravatar_id":"","url":"https://api.github.com/users/yohoushi","html_url":"https://github.com/yohoushi","followers_url":"https://api.github.com/users/yohoushi/followers","following_url":"https://api.github.com/users/yohoushi/following{/other_user}","gists_url":"https://api.github.com/users/yohoushi/gists{/gist_id}","starred_url":"https://api.github.com/users/yohoushi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yohoushi/subscriptions","organizations_url":"https://api.github.com/users/yohoushi/orgs","repos_url":"https://api.github.com/users/yohoushi/repos","events_url":"https://api.github.com/users/yohoushi/events{/privacy}","received_events_url":"https://api.github.com/users/yohoushi/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/yohoushi/yohoushi","description":"Yohoushi is a graphing tool, which works together with GrowthForecast","fork":false,"url":"https://api.github.com/repos/yohoushi/yohoushi","forks_url":"https://api.github.com/repos/yohoushi/yohoushi/forks","keys_url":"https://api.github.com/repos/yohoushi/yohoushi/keys{/key_id}","collaborators_url":"https://api.github.com/repos/yohoushi/yohoushi/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/yohoushi/yohoushi/teams","hooks_url":"https://api.github.com/repos/yohoushi/yohoushi/hooks","issue_events_url":"https://api.github.com/repos/yohoushi/yohoushi/issues/events{/number}","events_url":"https://api.github.com/repos/yohoushi/yohoushi/events","assignees_url":"https://api.github.com/repos/yohoushi/yohoushi/assignees{/user}","branches_url":"https://api.github.com/repos/yohoushi/yohoushi/branches{/branch}","tags_url":"https://api.github.com/repos/yohoushi/yohoushi/tags","blobs_url":"https://api.github.com/repos/yohoushi/yohoushi/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/yohoushi/yohoushi/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/yohoushi/yohoushi/git/refs{/sha}","trees_url":"https://api.github.com/repos/yohoushi/yohoushi/git/trees{/sha}","statuses_url":"https://api.github.com/repos/yohoushi/yohoushi/statuses/{sha}","languages_url":"https://api.github.com/repos/yohoushi/yohoushi/languages","stargazers_url":"https://api.github.com/repos/yohoushi/yohoushi/stargazers","contributors_url":"https://api.github.com/repos/yohoushi/yohoushi/contributors","subscribers_url":"https://api.github.com/repos/yohoushi/yohoushi/subscribers","subscription_url":"https://api.github.com/repos/yohoushi/yohoushi/subscription","commits_url":"https://api.github.com/repos/yohoushi/yohoushi/commits{/sha}","git_commits_url":"https://api.github.com/repos/yohoushi/yohoushi/git/commits{/sha}","comments_url":"https://api.github.com/repos/yohoushi/yohoushi/comments{/number}","issue_comment_url":"https://api.github.com/repos/yohoushi/yohoushi/issues/comments{/number}","contents_url":"https://api.github.com/repos/yohoushi/yohoushi/contents/{+path}","compare_url":"https://api.github.com/repos/yohoushi/yohoushi/compare/{base}...{head}","merges_url":"https://api.github.com/repos/yohoushi/yohoushi/merges","archive_url":"https://api.github.com/repos/yohoushi/yohoushi/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/yohoushi/yohoushi/downloads","issues_url":"https://api.github.com/repos/yohoushi/yohoushi/issues{/number}","pulls_url":"https://api.github.com/repos/yohoushi/yohoushi/pulls{/number}","milestones_url":"https://api.github.com/repos/yohoushi/yohoushi/milestones{/number}","notifications_url":"https://api.github.com/repos/yohoushi/yohoushi/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/yohoushi/yohoushi/labels{/name}","releases_url":"https://api.github.com/repos/yohoushi/yohoushi/releases{/id}","created_at":"2013-07-19T05:16:29Z","updated_at":"2015-03-02T06:22:12Z","pushed_at":"2015-03-02T07:48:28Z","git_url":"git://github.com/yohoushi/yohoushi.git","ssh_url":"git@github.com:yohoushi/yohoushi.git","clone_url":"https://github.com/yohoushi/yohoushi.git","svn_url":"https://github.com/yohoushi/yohoushi","homepage":"","size":1930,"stargazers_count":26,"watchers_count":26,"language":"Ruby","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":5,"mirror_url":null,"open_issues_count":4,"forks":5,"open_issues":4,"watchers":26,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/yohoushi/yohoushi/pulls/67"},"html":{"href":"https://github.com/yohoushi/yohoushi/pull/67"},"issue":{"href":"https://api.github.com/repos/yohoushi/yohoushi/issues/67"},"comments":{"href":"https://api.github.com/repos/yohoushi/yohoushi/issues/67/comments"},"review_comments":{"href":"https://api.github.com/repos/yohoushi/yohoushi/pulls/67/comments"},"review_comment":{"href":"https://api.github.com/repos/yohoushi/yohoushi/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/yohoushi/yohoushi/pulls/67/commits"},"statuses":{"href":"https://api.github.com/repos/yohoushi/yohoushi/statuses/4a831d60e1e069cb2778ee2fed6b92bf70edef35"}},"merged":true,"mergeable":null,"mergeable_state":"unknown","merged_by":{"login":"sonots","id":2290461,"avatar_url":"https://avatars.githubusercontent.com/u/2290461?v=3","gravatar_id":"","url":"https://api.github.com/users/sonots","html_url":"https://github.com/sonots","followers_url":"https://api.github.com/users/sonots/followers","following_url":"https://api.github.com/users/sonots/following{/other_user}","gists_url":"https://api.github.com/users/sonots/gists{/gist_id}","starred_url":"https://api.github.com/users/sonots/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sonots/subscriptions","organizations_url":"https://api.github.com/users/sonots/orgs","repos_url":"https://api.github.com/users/sonots/repos","events_url":"https://api.github.com/users/sonots/events{/privacy}","received_events_url":"https://api.github.com/users/sonots/received_events","type":"User","site_admin":false},"comments":0,"review_comments":1,"commits":2,"additions":7,"deletions":3,"changed_files":2}}