{"id":1671,"date":"2015-11-14T19:18:00","date_gmt":"2015-11-15T01:18:00","guid":{"rendered":"http:\/\/linuxitos.com\/main\/solucionar-error-errortable-performance_schema-session_variables-doesnt-exist-de-mysql-mostrado-en-netbeans\/"},"modified":"2015-11-14T19:18:00","modified_gmt":"2015-11-15T01:18:00","slug":"solucionar-error-errortable-performance_schema-session_variables-doesnt-exist-de-mysql-mostrado-en-netbeans","status":"publish","type":"post","link":"https:\/\/linuxitos.com\/main\/solucionar-error-errortable-performance_schema-session_variables-doesnt-exist-de-mysql-mostrado-en-netbeans\/","title":{"rendered":"Solucionar error: ErrorTable &#8216;performance_schema.session_variables&#8217; doesn&#8217;t exist de MySQL mostrado en Netbeans"},"content":{"rendered":"<div dir=\"ltr\" style=\"text-align: left;\">Recientemente instal\u00e9 MySQL en Fedora 23 despu\u00e9s de haber actualizado. Continuando con las instalaciones de los diferentes programas que utilizo y probando cada uno de ellos, me percat\u00e9 del siguiente error que mostraba Netbeans al intentar ejecutar un aplicaci\u00f3n desarrollada en java utilizando mysql como base de datos.<\/p>\n<p>El mensaje del error es:<br \/><span style=\"font-size: large;\"><b><span style=\"color: red;\">ErrorTable &#8216;performance_schema.session_variables&#8217; doesn&#8217;t exist<\/span><\/b><\/span><\/p>\n<div style=\"clear: both; text-align: center;\"><a href=\"http:\/\/4.bp.blogspot.com\/-YZhfkizDRDY\/VkfOIt9pQqI\/AAAAAAAABh4\/vn5k7E8Jhd4\/s1600\/Captura%2Bde%2Bpantalla%2Bde%2B2015-11-14%2B18-12-43.png\" style=\"margin-left: 1em; margin-right: 1em;\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"358\" src=\"http:\/\/4.bp.blogspot.com\/-YZhfkizDRDY\/VkfOIt9pQqI\/AAAAAAAABh4\/vn5k7E8Jhd4\/s640\/Captura%2Bde%2Bpantalla%2Bde%2B2015-11-14%2B18-12-43.png\" width=\"640\" \/><\/a><\/div>\n<p>Al principio cre\u00ed que se deb\u00eda a las contrase\u00f1as del usuario de mysql, o que tal vez el jar estaba desactulizado, pero no era as\u00ed. En internet encontr\u00e9 la siguiente instrucci\u00f3n de l\u00ednea de comando para solucionar el error:<\/p>\n<pre style=\"background: none no-repeat scroll 0% 0% rgb(0, 0, 0); border-radius: 3px; border: 1px solid rgb(0, 0, 0); font-family: &quot;Droid Sans Mono&quot;,Consolas,monospace; font-size: 13px; line-height: 20px; margin: 8px 15px; opacity: 0.85; padding: 9.5px; text-align: start; text-shadow: none; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;\"><span style=\"color: white;\">mysql_upgrade -u root -p --force<\/span><\/pre>\n<p>Luego reiniciar el servicio de mysql:<\/p>\n<pre style=\"background: none no-repeat scroll 0% 0% rgb(0, 0, 0); border-radius: 3px; border: 1px solid rgb(0, 0, 0); font-family: &quot;Droid Sans Mono&quot;,Consolas,monospace; font-size: 13px; line-height: 20px; margin: 8px 15px; opacity: 0.85; padding: 9.5px; text-align: start; text-shadow: none; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;\"><span style=\"color: white;\">sudo \/bin\/systemctl restart  mysqld.service<\/span><\/pre>\n<p>Y con eso se soluciona el error:<\/p>\n<p>Finalmente pude ejecutar mi programa:<\/p>\n<div style=\"clear: both; text-align: center;\"><a href=\"http:\/\/4.bp.blogspot.com\/-5uLampdvrgc\/VkfPRakSVGI\/AAAAAAAABiE\/5Z-uej-yaqo\/s1600\/Captura%2Bde%2Bpantalla%2Bde%2B2015-11-14%2B18-17-55.png\" style=\"margin-left: 1em; margin-right: 1em;\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"358\" src=\"http:\/\/4.bp.blogspot.com\/-5uLampdvrgc\/VkfPRakSVGI\/AAAAAAAABiE\/5Z-uej-yaqo\/s640\/Captura%2Bde%2Bpantalla%2Bde%2B2015-11-14%2B18-17-55.png\" width=\"640\" \/><\/a><\/div>\n<p>Gracias por visitar. Si gustan descargar la aplicaci\u00f3n lo tengo en mi sitio de github <a href=\"https:\/\/github.com\/jesusferm\/gestionbasedatos\">https:\/\/github.com\/jesusferm\/gestionbasedatos<\/a><\/p>\n<div style=\"text-align: right;\"><span style=\"font-size: xx-small;\">Fuentes:&nbsp;<\/span><\/div>\n<div style=\"text-align: right;\"><span style=\"font-size: xx-small;\">http:\/\/stackoverflow.com\/questions\/31967527\/table-performance-schema-session-variables-doesnt-exist<\/span><\/div>\n<div style=\"text-align: right;\"><span style=\"font-size: xx-small;\">http:\/\/www.tecposter.com\/fix-mysql-error-table-performance_schema-session_variables-doesnt-exist\/<\/span><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Recientemente instal\u00e9 MySQL en Fedora 23 despu\u00e9s de haber actualizado. Continuando con las instalaciones de los diferentes programas que utilizo y probando cada uno de ellos, me percat\u00e9 del siguiente error que mostraba Netbeans al intentar ejecutar un aplicaci\u00f3n desarrollada en java utilizando mysql como base de datos. El mensaje del error es:ErrorTable &#8216;performance_schema.session_variables&#8217; doesn&#8217;t [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[140,908,910,446,60,911,359,909],"tags":[],"class_list":["post-1671","post","type-post","status-publish","format-standard","hentry","category-error","category-error-mysql","category-errortable-performance_schema-session_variables-doesnt-exist","category-java","category-mysql","category-mysql-y-java","category-netbeans","category-solucionar-error-mysql"],"_links":{"self":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/1671","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/comments?post=1671"}],"version-history":[{"count":0,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/1671\/revisions"}],"wp:attachment":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/media?parent=1671"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/categories?post=1671"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/tags?post=1671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}