MyCATApache/Mycat-Server

使用laravel连接mycat不上

Open

#2,773 opened on Apr 20, 2021

View on GitHub
 (4 comments) (0 reactions) (0 assignees)Java (3,886 forks)batch import
donehelp wanted

Repository metrics

Stars
 (9,451 stars)
PR merge metrics
 (No merged PRs in 30d)

Description

描述：通过命令进入mycat可以查询到数据

mysql -ucar_v2 -p123456 -h 172.20.0.30 -P 8066

image

但是通过laravel访问mycat,查询数据就会出现问题“SQLSTATE[HY000]: General error: 2006 MySQL server has gone away”

image

修改过配置max_connect , max_allowed_packet,也还是不行

max_connections=1500
max_allowed_packet=30M

image image

以下是mycat的日志输出

image

Contributor guide

Research direction
Inspect the Mycat server logs and compare with the MySQL client behavior. Check the connection pool settings in Mycat and the timeout configurations. Also verify if the query sent by Laravel exceeds the max allowed packet or if the connection is being closed by Mycat due to idle timeout.
Tech stack
java
Domain
database
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
Half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
MySQLLaravel
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
40