{"action":"created","issue":{"url":"https://api.github.com/repos/rancher/rancher/issues/9357","repository_url":"https://api.github.com/repos/rancher/rancher","labels_url":"https://api.github.com/repos/rancher/rancher/issues/9357/labels{/name}","comments_url":"https://api.github.com/repos/rancher/rancher/issues/9357/comments","events_url":"https://api.github.com/repos/rancher/rancher/issues/9357/events","html_url":"https://github.com/rancher/rancher/issues/9357","id":243253015,"number":9357,"title":"Catalog: mysql_send_long_data() is longer than 'max_long_data_size' bytes","user":{"login":"marvinwankersteen","id":17569312,"avatar_url":"https://avatars5.githubusercontent.com/u/17569312?v=4","gravatar_id":"","url":"https://api.github.com/users/marvinwankersteen","html_url":"https://github.com/marvinwankersteen","followers_url":"https://api.github.com/users/marvinwankersteen/followers","following_url":"https://api.github.com/users/marvinwankersteen/following{/other_user}","gists_url":"https://api.github.com/users/marvinwankersteen/gists{/gist_id}","starred_url":"https://api.github.com/users/marvinwankersteen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marvinwankersteen/subscriptions","organizations_url":"https://api.github.com/users/marvinwankersteen/orgs","repos_url":"https://api.github.com/users/marvinwankersteen/repos","events_url":"https://api.github.com/users/marvinwankersteen/events{/privacy}","received_events_url":"https://api.github.com/users/marvinwankersteen/received_events","type":"User","site_admin":false},"labels":[{"id":611716239,"url":"https://api.github.com/repos/rancher/rancher/labels/area/database","name":"area/database","color":"FBCA04","default":false},{"id":601597122,"url":"https://api.github.com/repos/rancher/rancher/labels/status/more-info","name":"status/more-info","color":"bfdadc","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2017-07-16T17:18:12Z","updated_at":"2017-07-17T10:54:12Z","closed_at":null,"body":"**Rancher versions:**\r\nrancher/server:v1.6.4\r\nrancher/agent:v1.2.5\r\n\r\n**Infrastructure Stack versions:**\r\nhealthcheck:v0.3.1\r\nipsec:v0.11.3\r\nnetwork-services:v0.7.4\r\nscheduler:v0.8.2\r\nkubernetes (if applicable):\r\n\r\n**Docker version: (`docker version`,`docker info` preferred)**\r\nClient:\r\n Version:      17.03.0-ce\r\n API version:  1.26\r\n Go version:   go1.7.5\r\n Git commit:   60ccb22\r\n Built:        Thu Feb 23 11:02:43 2017\r\n OS/Arch:      linux/amd64\r\n\r\nServer:\r\n Version:      17.03.0-ce\r\n API version:  1.26 (minimum version 1.12)\r\n Go version:   go1.7.5\r\n Git commit:   60ccb22\r\n Built:        Thu Feb 23 11:02:43 2017\r\n OS/Arch:      linux/amd64\r\n Experimental: false\r\n\r\n**Operating system and kernel: (`cat /etc/os-release`, `uname -r` preferred)**\r\nUbuntu 16.04.2 LTS\r\n\r\n**Type/provider of hosts: (VirtualBox/Bare-metal/AWS/GCE/DO)**\r\nKVM, Bare-metal\r\n\r\n**Setup details: (single node rancher vs. HA rancher, internal DB vs. external DB)**\r\nHA rancher with external DB\r\n\r\n**Environment Template: (Cattle/Kubernetes/Swarm/Mesos)**\r\nCattle\r\n\r\n**Steps to Reproduce:**\r\nActivate/refresh catalogs\r\n\r\n**Results:**\r\n```\r\n(Error 1105: Parameter of prepared statement which is set through mysql_send_long_data() is longer than 'max_long_data_size' bytes) \r\n[2017-07-16 19:02:27]  \r\nERRO[0013] Failed to perform catalog refresh: community: Error 1105: Parameter of prepared statement which is set through mysql_send_long_data() is longer than 'max_long_data_size' bytes \r\n\r\n(Error 1105: Parameter of prepared statement which is set through mysql_send_long_data() is longer than 'max_long_data_size' bytes) \r\n[2017-07-16 19:02:33]  \r\nERRO[0020] Failed to perform catalog refresh: community: Error 1105: Parameter of prepared statement which is set through mysql_send_long_data() is longer than 'max_long_data_size' bytes\r\n```\r\n\r\n\r\nI found the above errors every ~6 seconds in \"`docker logs`\" and `cattle-debug.log`. The error appears, I think, after the upgrade from 1.6.2 to 1.6.4. I tried to increase the `max_long_data_size` from `1048576` to `2097152` but the error appears until I disable the catalogs in admin settings.\r\n```\r\nmysql> show variables like 'max_long_data_size'\\G\r\nVariable_name: max_long_data_size\r\n        Value: 2097152\r\n```\r\n\r\nHow can I find out how big is `mysql_send_long_data`?"},"comment":{"url":"https://api.github.com/repos/rancher/rancher/issues/comments/315723762","html_url":"https://github.com/rancher/rancher/issues/9357#issuecomment-315723762","issue_url":"https://api.github.com/repos/rancher/rancher/issues/9357","id":315723762,"user":{"login":"superseb","id":2620179,"avatar_url":"https://avatars6.githubusercontent.com/u/2620179?v=4","gravatar_id":"","url":"https://api.github.com/users/superseb","html_url":"https://github.com/superseb","followers_url":"https://api.github.com/users/superseb/followers","following_url":"https://api.github.com/users/superseb/following{/other_user}","gists_url":"https://api.github.com/users/superseb/gists{/gist_id}","starred_url":"https://api.github.com/users/superseb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/superseb/subscriptions","organizations_url":"https://api.github.com/users/superseb/orgs","repos_url":"https://api.github.com/users/superseb/repos","events_url":"https://api.github.com/users/superseb/events{/privacy}","received_events_url":"https://api.github.com/users/superseb/received_events","type":"User","site_admin":false},"created_at":"2017-07-17T10:54:12Z","updated_at":"2017-07-17T10:54:12Z","body":"Can you try setting it to `16777216` or higher?"}}
{"actor":{"display_login":"superseb"}}