public inbox for [email protected]
 help / color / mirror / Atom feed
From: Muhammad Rizki <[email protected]>
To: Ammar Faizi <[email protected]>
Cc: Muhammad Rizki <[email protected]>,
	GNU/Weeb Mailing List <[email protected]>
Subject: [PATCH v2 03/18] Fix MySQL InternalError: Unread result found
Date: Fri, 29 Jul 2022 07:40:31 +0700	[thread overview]
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>

Use con.cursor(buffered=True) to make it avoid from
mysql.connector.errors.InternalError: Unread result found.

Signed-off-by: Muhammad Rizki <[email protected]>
---
 daemon/scraper/db.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/daemon/scraper/db.py b/daemon/scraper/db.py
index 321661f..296559e 100644
--- a/daemon/scraper/db.py
+++ b/daemon/scraper/db.py
@@ -12,7 +12,7 @@ class Db():
 	def __init__(self, conn):
 		self.conn = conn
 		self.conn.autocommit = True
-		self.cur = self.conn.cursor()
+		self.cur = self.conn.cursor(buffered=True)
 
 
 	def __del__(self):
-- 
Muhammad Rizki


  parent reply	other threads:[~2022-07-29  0:42 UTC|newest]

Thread overview: 39+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2022-07-29  0:40 [PATCH v1 00/18] New feature to handle atom URLs and broadcast Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 01/18] Add atom_broadcast.sql Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 02/18] Add ATOM_URLS and BROADCAST_CHAT methods Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 03/18] Fix MySQL InternalError: Unread result found Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 04/18] Create /add_atom command Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 05/18] Add utility functions for /add_atom Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 06/18] Refactor database methods Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 07/18] Add insert_atom() in scraper/db.py Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 08/18] Rename admin.py to debugger.py Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 09/18] Add delete_atom() function in scraper/db.py Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 10/18] Add utility function buton_numbers() Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 11/18] Move bot commands related files to packages/plugins/commands/ Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 12/18] Add del_atom callback query Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 13/18] Add insert_broadcast() in scraper/db.py Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 14/18] Add delete_broadcast() " Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 15/18] Create /add_bc bot command Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 16/18] Add create_chat_link() function Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 17/18] Add /del_bc bot command Muhammad Rizki
2022-07-29  0:40 ` [PATCH v1 18/18] Add del_chat callback query Muhammad Rizki
2022-07-29  0:40 ` [PATCH v2 00/18] New feature to handle atom URLs and broadcast Muhammad Rizki
2022-07-29  0:40 ` [PATCH v2 01/18] Add atom_broadcast.sql Muhammad Rizki
2022-07-29  0:40 ` [PATCH v2 02/18] Add ATOM_URLS and BROADCAST_CHAT methods Muhammad Rizki
2022-07-29  0:40 ` Muhammad Rizki [this message]
2022-07-29  0:40 ` [PATCH v2 04/18] Create /add_atom command Muhammad Rizki
2022-07-29  0:40 ` [PATCH v2 05/18] Add utility functions for /add_atom Muhammad Rizki
2022-07-29  0:40 ` [PATCH v2 06/18] Refactor database methods Muhammad Rizki
2022-07-29  0:40 ` [PATCH v2 07/18] Add insert_atom() in scraper/db.py Muhammad Rizki
2022-07-29  0:40 ` [PATCH v2 08/18] Rename admin.py to debugger.py Muhammad Rizki
2022-07-29  0:40 ` [PATCH v2 09/18] Add delete_atom() function in scraper/db.py Muhammad Rizki
2022-07-29  0:40 ` [PATCH v2 10/18] Add utility function buton_numbers() Muhammad Rizki
2022-07-29  0:40 ` [PATCH v2 11/18] Move bot commands related files to packages/plugins/commands/ Muhammad Rizki
2022-07-29  0:40 ` [PATCH v2 12/18] Add del_atom callback query Muhammad Rizki
2022-07-29  0:40 ` [PATCH v2 13/18] Add insert_broadcast() in scraper/db.py Muhammad Rizki
2022-07-29  0:40 ` [PATCH v2 14/18] Add delete_broadcast() " Muhammad Rizki
2022-07-29  0:40 ` [PATCH v2 15/18] Create /add_bc bot command Muhammad Rizki
2022-07-29  0:40 ` [PATCH v2 16/18] Add create_chat_link() function Muhammad Rizki
2022-07-29  0:40 ` [PATCH v2 17/18] Add /del_bc bot command Muhammad Rizki
2022-07-29  0:40 ` [PATCH v2 18/18] Add del_chat callback query Muhammad Rizki
  -- strict thread matches above, loose matches on Subject: below --
2022-07-29  0:44 [PATCH v2 00/18] New feature to handle atom URLs and broadcast Muhammad Rizki
2022-07-29  0:44 ` [PATCH v2 03/18] Fix MySQL InternalError: Unread result found Muhammad Rizki

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    [email protected] \
    [email protected] \
    [email protected] \
    [email protected] \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox