近期大数据相关业务的MySQL上proxysql时遇到一个问题,开源BI平台metabase,通过proxysql访问mysql后无法建立连接。直接抛如下异常:
java.lang.Exception: java.sql.SQLNonTransientConnectionException: unexpected end of stream, read 0 bytes
from 7 (socket was closed by server)
at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:34)
at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:18)
proxysql的版本:
ProxySQL version 1.4.11-6-g4e44db1, codename Truls
proxysql日志中有报如下异常:
2019-07-18 10:14:16 MySQL_Session.cpp:95:kill_query_thread(): [WARNING] KILL CONNECTION 0 on 10.26.1.168:3306
2019-07-18 10:14:24 MySQL_Session.cpp:2448:handler(): [ERROR] Unexpected packet from client, disconnecting the client
2019-07-18 10:14:24 MySQL_Session.cpp:2448:handler(): [ERROR] Unexpected packet from client, disconnecting the client
异常后切换到直连mysql是正常的。
在git中有类似的问题:[#1138](https://github.com/sysown/proxysql/issues/1138)。大概的问题是:
1、使用了maridb的驱动,mariadb-connector-j 2.0.0 增加了一个参数usePipelineAuth,默认是开启的。就是在发送一个请求时,没有收到回复时,就可以发送下一个请求,这时proxysql来说就是一个异常请求会断掉连接,并报如下错“[ERROR] Unexpected packet from client”。
2、切换到mysql驱动后能正常使用,mysql-connector 是没有这方面的功能的
3、使用maridb驱动需要将usePipelineAuth设置为false
知道大概方向后,向开发确认信息,确实使用maridb的驱动,不过将usePipelineAuth参数设置为false还是不行,后面将驱动换成mysql就正常了。
文章最后更新时间:
2019年07月20日 14:28:59
Это сообщение, бесподобно ))), мне нравится :) the software program also offers a free demo.
Numerous institutions is a blessing to the residents of town. A lot of establishments makes it a tad bit challenging for a layman to differentiate between a real company and a rogue business. One smart technique utilized by many people involves comparing and contrasting the deals and offers from a large pool of specialists in the city of Richmond, VA. When in want of passable providers in Richmond, it's imperative to go for institutions which are licensed and registered. No marvel these guys are currently ranked as one among the highest earners in the market. One needs to ensure that they discover a company which has earned the trust and respect of their peers. It requires one to be keen and observant at all times to keep away from landing into problems and complications. Make use of non-public referrals at all times.
There are web sites which permit you to place in your parameters and select the most fitted machine in this manner but they are normally linked to a particular manufacturer and is not going to offer you suggestions for merchandise from other companies. If you already know that you will shred a a hundred pages a day then divide this by the utmost to ascertain how long that can take you. Most are standardized to take A4 sheets, which is a nuisance for those who incessantly use bigger size pages. If you find yourself clear on what your wants are, take your notes to the nearest store and ask the sales staff to help you by letting you see the most appropriate machines in that vary. Shredders range in dimension from a hand held multi bladed pair of scissors to a truck sized shredder. Shredding additional into smaller items is a particle-lower shredder and a disintegrator, as it is understood, shreds the paper so high-quality that it passes via a wire mesh when completed.
Я тоже возьму уж очень интересно. Disallow: /wp-admin
Подтверждаю. Я присоединяюсь ко всему выше сказанному.
Сожалею, что не могу Вам помочь. Я думаю, Вы найдёте здесь верное решение.
Сожалею, но ничем не могу помочь. Я знаю, Вы найдёте верное решение. Не отчаивайтесь.
Специально зарегистрировался на форуме, чтобы сказать Вам спасибо за помощь в этом вопросе.
Подскажите, где я могу это найти?
пригодица