如何避免PDOException：SQLSTATE [HY000] [1040] Laravel Lumen中的连接太多

I have an API server built with lumen. When I run load test that swarms the server, at a certain points it throws PDOException: SQLSTATE[HY000] [1040] Too many connections. I am using a free tier AWS EC2 and RDS setup so I know that my instance is not big enough for this test, but is there any way to optimize this without upgrading the RDS instance first?

My question is:

Will connection pooling avoid this problem? Will the requests wait for an available connection instead of crashing when I use connection pooling?
Is there a way from preventing my app from crashing when this happens? So far it always require me to reboot my RDS instance

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

报告相同问题？

关注问题

致命错误：未捕获PDOException：SQLSTATE [HY093]：参数号无效：混合命名和位置参数 php postgresql
2019-07-31 16:30

回答 1 已采纳 you can't use :param and ? use :id instead of ? but for update you could use 'UPDATE '
SQLSTATE [HY000] [2002]连接被拒绝 - 引起：PDOException php
2015-01-30 03:11

回答 2 已采纳 host=myURL ?? try host=localhost Unless you are using a different machine for the mysql server, b
致命错误：未捕获PDOException：SQLSTATE [42000] php
2017-02-15 11:38

回答 1 已采纳 Try adding quotes around id=$search $where=' AND (cognome like "%'.$search.'%" OR nome like "%'.$
laravel PDOException: SQLSTATE[HY000] [2002] Network is unreachable in /home/ww
2022-05-20 10:21

lxw1844912514的博客 SQLSTATE[HY000] [2002] Network is unreachable 无法访问SQLSTATE[HY000][2002]网络找各种原因都试过，不可以，最后偶然重启机器好了。奇怪。我的是在Mac上搭建的vagrant 虚拟机。估测是跑异常sql脚本把机器跑挂...
Laravel：Connection.php第319行中的PDOException：SQLSTATE [42S02] laravel php
2017-02-28 15:10

回答 1 已采纳 Your issue lies with your validation of the user email unique:user_id -> unique:user_details,
PDOException：:(“SQLSTATE [42S22]：未找到列：1054'字段列表'中的未知列'问题'”） laravel php vue.js
2019-07-27 04:56

回答 2 已采纳 In your replies table migration, you create a field called question_id: Schema::create('replies',
PHP PDOException：“SQLSTATE [HY093]：参数号无效” mysql php
2013-08-03 02:35

回答 4 已采纳 Try: $sql = "INSERT INTO persist (user_id, hash, expire) VALUES (:user_id, :hash, :expire) ON DUP
Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1045]如何解决
2021-12-08 03:35

qq_36745209的博客 Uncaught PDOException: SQLSTATE[HY000] [1045] Access denied for user 'zaixiankefu'@'localhost' (using password: YES) in C:\wwwroot\zaixiankefu\Frame\Library\Vendor\GatewayWorker\vendor\workerman\mysql...
Laravel PDOException SQLSTATE [HY000] [1049]未知数据库'forge' laravel mysql php
2014-06-09 11:57

回答 10 已采纳 You have to clear the cache like that (because your old configuration is in you cache file) : php
未捕获的PDOException：SQLSTATE [42000]：语法错误或访问冲突：1064查询功能 php sql
2019-02-05 18:01

回答 1 已采纳 As you are working with SQL you should use order by instead of order $contacts = $this->Contac
未捕获的PDOException：SQLSTATE [HY093]：参数号无效：参数未定义[重复] mysql php
2018-07-05 08:34

回答 1 已采纳 There are some syntax errors. Like no space after SET and before WHERE keyword. I have added and u
后端报错：Uncaught PDOException: SQLSTATE[HY000] [1045] Access denied for user ......
2022-03-17 11:27

白开水z的博客打开根目录www/index.php里的数据库配置好就行了【注】（1）mysql服务器地址：打开phpStudy=>设置=>hosts （2）数据库名称和数据表统一前缀：打开phpMyAdmin,对应的数据表（3）数据库账号和密码：（4...
php数据库连接成功但是不能插入数据 mysql php 数据库有问必答
2022-02-08 02:26

回答 5 已采纳去掉圈出来的那句代码，用mysqli了干嘛又新建个PDO链接对象干嘛，没必要用PDO了有其他问题可以继续交流~
OJ系统部署问题排查记录；PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1045]
2020-04-10 11:13

荒漠的远行者的博客前言自己搭建的OJ系统移植到了另外一个服务器上，进行了重新部署配置，然后发现打不开了，页面首先提示404，打开nginx的error的日志文件，发现是文件权限不对，于是改了一通...在linux中一般的文件都可以用vim打...
Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory
2017-12-04 14:31

snow_small的博客在PDO连接MySQL时，出现Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory。。。。。原因：PDO无法找到mysql.sock <?php $pdo = new PDO("mysql:host=localhost;dbname=text1", 'root'...
mysql 2002 pdo,PDOException:SQLSTATE[HY000][2002]没有这样的文件或目录
2021-04-19 01:55

weixin_39761822的博客我已经将PushChatServer目录放在htdocs文件夹中，并创建数据库puschat，尝试运行@“http://localhost/PushChatServer/api/test/database.php”然后我得到了以下例外。我想做同样的事情来解释这个链接...
解决 drush PDOException: SQLSTATE[HY000] [2002]
2017-03-03 16:18

for023的博客今天在Mac OS中安装Drush时遇到一个错误。 Drush command terminated abnormally due to an unrecoverable error. [error] Additional uncaught exception thrown while handling exception. Original ...
PDOException: SQLSTATE[HY000] [2002] Connection refused
2021-12-01 18:24

秦艽的博客 https://stackoverflow.com/questions/41225720/laravel-sqlstatehy000-2002-connection-refused
PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[08004] [1040] Too many connections
2021-04-27 22:04

荒漠的远行者的博客前言之前搭建的OJ，今天傍晚突然出现了http 500的... 正文然后打开mysql配置文件，配置文件路径如下 /etc/mysql/mysql.conf.d/mysqld.cnf ...把里面的链接数max_connections改成了1000，然后重启mysql就可以了。......
php column not found,Uncaught PDOException: SQLSTATE[42S22]: Column not found in PHP code
2021-05-06 03:10

晨雨竹的博客 I get this message:Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Password' in 'field list' in C:\xampp\htdocs\eCommerce\admin\index.php:26 Stack trace: #0...
没有解决我的问题, 去提问

悬赏问题

¥15 基于卷积神经网络的声纹识别
¥15 Python中的request，如何使用ssr节点，通过代理requests网页。本人在泰国，需要用大陆ip才能玩网页游戏，合法合规。
¥100 为什么这个恒流源电路不能恒流？
¥15 有偿求跨组件数据流路径图
¥15 写一个方法checkPerson，入参实体类Person，出参布尔值
¥15 我想咨询一下路面纹理三维点云数据处理的一些问题，上传的坐标文件里是怎么对无序点进行编号的，以及xy坐标在处理的时候是进行整体模型分片处理的吗
¥15 CSAPPattacklab
¥15 一直显示正在等待HID—ISP
¥15 Python turtle 画图
¥15 stm32开发clion时遇到的编译问题

码龄粉丝数原力等级 --

如何避免PDOException：SQLSTATE [HY000] [1040] Laravel Lumen中的连接太多

0条回答默认最新

悬赏问题

如何避免PDOException：SQLSTATE [HY000] [1040] Laravel Lumen中的连接太多

0条回答 默认 最新

悬赏问题

0条回答默认最新