Hi, the dev here.
With the -test1 packet, pymysql + mysqlrouter works for me.
Below, a working strace of pymysql. Can someone please provide me with an strace shows the sendto/recvfrom of a failing pymysql?
$ strace -e sendto,recvfrom python3 -c "import pymysql;cnx = pymysql.connect(host='127.0.0.1', port=6446, user='someuser', password='somepass'); cnx.query('DO 1')" recvfrom(3, "M\0\0\0\n8.0.32\0\7\0\0\0DQi=\34qGI\0\337\377\377\2"..., 8192, 0, NULL, NULL) = 81 sendto(3, "\225\0\0\1\5\242:\0\377\377\377\0-\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 153, 0, NULL, 0) = 153 recvfrom(3, "\2\0\0\2\1\4", 8192, 0, NULL, NULL) = 6 sendto(3, "\1\0\0\3\2", 5, 0, NULL, 0) = 5 recvfrom(3, "\304\1\0\4\1-----BEGIN PUBLIC KEY-----\n"..., 8192, 0, NULL, NULL) = 456 sendto(3, "\0\1\0\5SS\301\252\336\366\262GMRb\237\267\227\262\r\v\6l\201\213\17Aso\366\311\33"..., 260, 0, NULL, 0) = 260 recvfrom(3, "\7\0\0\6\0\0\0\2\0\0\0", 8192, 0, NULL, NULL) = 11 sendto(3, "\23\0\0\0\3SET AUTOCOMMIT = 0", 23, 0, NULL, 0) = 23 recvfrom(3, "\7\0\0\1\0\0\0\0\0\0\0", 8192, 0, NULL, NULL) = 11 sendto(3, "\5\0\0\0\3DO 1", 9, 0, NULL, 0) = 9 recvfrom(3, "\7\0\0\1\0\0\0\0\0\0\0", 8192, 0, NULL, NULL) = 11 +++ exited with 0 +++
Hi, the dev here.
With the -test1 packet, pymysql + mysqlrouter works for me.
Below, a working strace of pymysql. Can someone please provide me with an strace shows the sendto/recvfrom of a failing pymysql?
$ strace -e sendto,recvfrom python3 -c "import pymysql;cnx = pymysql. connect( host='127. 0.0.1', port=6446, user='someuser', password= 'somepass' ); cnx.query('DO 1')" 0\n8.0. 32\0\7\ 0\0\0DQi= \34qGI\ 0\337\377\ 377\2". .., 8192, 0, NULL, NULL) = 81 0\1\5\242: \0\377\ 377\377\ 0-\0\0\ 0\0\0\0\ 0\0\0\0\ 0\0\0\0\ 0\0\0\0\ 0"..., 153, 0, NULL, 0) = 153 0\4\1-- ---BEGIN PUBLIC KEY-----\n"..., 8192, 0, NULL, NULL) = 456 5SS\301\ 252\336\ 366\262GMRb\ 237\267\ 227\262\ r\v\6l\ 201\213\ 17Aso\366\ 311\33" ..., 260, 0, NULL, 0) = 260 6\0\0\0\ 2\0\0\0" , 8192, 0, NULL, NULL) = 11 1\0\0\0\ 0\0\0\0" , 8192, 0, NULL, NULL) = 11 1\0\0\0\ 0\0\0\0" , 8192, 0, NULL, NULL) = 11
recvfrom(3, "M\0\0\
sendto(3, "\225\0\
recvfrom(3, "\2\0\0\2\1\4", 8192, 0, NULL, NULL) = 6
sendto(3, "\1\0\0\3\2", 5, 0, NULL, 0) = 5
recvfrom(3, "\304\1\
sendto(3, "\0\1\0\
recvfrom(3, "\7\0\0\
sendto(3, "\23\0\0\0\3SET AUTOCOMMIT = 0", 23, 0, NULL, 0) = 23
recvfrom(3, "\7\0\0\
sendto(3, "\5\0\0\0\3DO 1", 9, 0, NULL, 0) = 9
recvfrom(3, "\7\0\0\
+++ exited with 0 +++