dpl3350 2019-06-21 16:32
浏览 129

当MariaDB超时查询时,PHP不会抛出异常

PHP doesn't seem to throw an exception when MariaDB times out a query. Instead it just returns an empty result set. We tried running this via PHP PDO:

SET STATEMENT max_statement_time = 2 FOR
SELECT "A", SLEEP(10);

I'd expect it to throw some sort of PDOException, like when you do something similar in Postgres, but instead it completes successfully and returns an empty result set. There doesn't seem to be any way to distinguish between a timed out query and one that just doesn't return anything.

Anyone know of any way to get this to throw an exception?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 MATLAB怎么通过柱坐标变换画开口是圆形的旋转抛物面?
    • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
    • ¥15 解riccati方程组
    • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
    • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
    • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
    • ¥50 树莓派安卓APK系统签名
    • ¥65 汇编语言除法溢出问题
    • ¥15 Visual Studio问题
    • ¥20 求一个html代码,有偿