System error: 10038 An attempt was made to perform an operation on an object that is not a socket. How to decide?

Question

MySQL

main function for selecting question and answers:

def game(n):
    db_work = mySQL()

    rq = db_work.select_q(n)    #строка с вопросом
    ra = db_work.select_a(n)    #строки с ответами

    marcup = utils.answers_marcup(ra) #заполнение клавиатуры ответами

    bot.send_message(user_id, rq[1], reply_markup=marcup)

    db_work.close()

Requests to the database:
1 request works correctly and 2 crashes

def __init__(self):
        self.connection = mysql.connector.connect(host="localhost", user="root", passwd="123", db="test_db")
        self.cursor = self.connection.cursor()

    def select_q(self, id):
        with self.connection:
            self.cursor.execute('SELECT * FROM questions WHERE id = ' + str(id))
            return self.cursor.fetchone()


    def select_a(self, id_q):
        with self.connection:
            self.cursor.execute('SELECT answer FROM answers WHERE id_q = ' + str(id_q))
            return self.cursor.fetchall()

If you put * in the 2nd request or specify only 1 line instead of several, it gives the same error

Answer 1

You don't understand how with works? The call to select_q closes self.connection. An attempt in select_a to read from a closed connection results in an error.