When I call SP using frappe.db.sql(‘’’ CALL test(); ‘’') using API. Its give first time only result then onwards give Error: Packet sequence number wrong - got 80 expected 1
Wjen I am using direct query n times frappe.db.sql(‘’’ SELECT * FROM diamond.tabDocField tdf;‘’') , no error anytime.
This error comes in Frappe 15 Only.
285 @frappe.whitelist(allow_guest=True)
286 def check_sp():
→ 287 res = frappe.db.sql(‘’’ CALL test();
288 ‘’',as_dict=1)
289 return res
File ~/frappe-bench/apps/frappe/frappe/database/database.py:234, in Database.sql(self, query, values, as_dict, as_list, debug, ignore_ddl, auto_commit, update, explain, run, pluck, as_iterator)
231 query += f" /* FRAPPE_TRACE_ID: {trace_id} */"
233 try:
→ 234 self._cursor.execute(query, values)
235 except Exception as e:
236 if self.is_syntax_error(e):
File ~/frappe-bench/env/lib/python3.11/site-packages/pymysql/cursors.py:153, in Cursor.execute(self, query, args)
149 pass
151 query = self.mogrify(query, args)
→ 153 result = self._query(query)
154 self._executed = query
155 return result
File ~/frappe-bench/env/lib/python3.11/site-packages/pymysql/cursors.py:322, in Cursor._query(self, q)
320 conn = self._get_db()
321 self._clear_result()
→ 322 conn.query(q)
323 self._do_get_result()
324 return self.rowcount
File ~/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py:558, in Connection.query(self, sql, unbuffered)
556 sql = sql.encode(self.encoding, “surrogateescape”)
557 self._execute_command(COMMAND.COM_QUERY, sql)
→ 558 self._affected_rows = self._read_query_result(unbuffered=unbuffered)
559 return self._affected_rows
File ~/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py:822, in Connection._read_query_result(self, unbuffered)
820 else:
821 result = MySQLResult(self)
→ 822 result.read()
823 self._result = result
824 if result.server_status is not None:
File ~/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py:1200, in MySQLResult.read(self)
1198 def read(self):
1199 try:
→ 1200 first_packet = self.connection._read_packet()
1202 if first_packet.is_ok_packet():
1203 self._read_ok_packet(first_packet)
File ~/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py:752, in Connection._read_packet(self, packet_type)
746 if packet_number == 0:
747 # MariaDB sends error packet with seqno==0 when shutdown
748 raise err.OperationalError(
749 CR.CR_SERVER_LOST,
750 “Lost connection to MySQL server during query”,
751 )
→ 752 raise err.InternalError(
753 “Packet sequence number wrong - got %d expected %d”
754 % (packet_number, self._next_seq_id)
755 )
756 self._next_seq_id = (self._next_seq_id + 1) % 256
758 recv_data = self._read_bytes(bytes_to_read)
InternalError: Packet sequence number wrong - got 80 expected 1