mysql连接丢失

import mysql.connector
from mysql.connector import pooling

# 创建连接池
dbconfig = {
    "host": "localhost",
    "user": "user",
    "password": "password",
    "database": "database"
}
pool = mysql.connector.pooling.MySQLConnectionPool(pool_name="mypool", pool_size=5, **dbconfig)

def get_connection():
    try:
        return pool.get_connection()
    except mysql.connector.errors.PoolError as err:
        print(f"Failed to get connection from pool: {err}")
        return None

def execute_query(query):
    conn = get_connection()
    if conn is None:
        return None
    try:
        cursor = conn.cursor()
        cursor.execute(query)
        result = cursor.fetchall()
        return result
    except mysql.connector.errors.InterfaceError as err:
        print(f"Connection lost: {err}")
        # 尝试重新获取连接并重试
        conn = get_connection()
        if conn is not None:
            cursor = conn.cursor()
            cursor.execute(query)
            result = cursor.fetchall()
            return result
    finally:
        if conn is not None:
            conn.close()

# 示例查询
result = execute_query("SELECT * FROM table")
print(result)