Comments (6)
@heyuanlong Will you provide a minimal and self-contained code example that can reproduce this?
from lua-resty-mysql.
我的代码
if mysqlConn then local res, err, errno, sqlstate = mysqlConn:read_result() while err == "again" do res, err, errno, sqlstate = mysqlConn:read_result() end local ok, err = mysqlConn:set_keepalive(10000, 100) if not ok then mysqlConn:close() ok = false db_type = db_type + mysql_type err = "MySQL.Error ( "..(err or "null").." ) " end end
报的错误:
2016/04/29 16:57:30 [error] 17843#0: *46412 lua entry thread aborted: runtime error: /data/sns.kobox.tv/lib/sns_common/resty/mysql.lua:794: attempt to concatenate field 'state' (a nil value)
stack traceback:
coroutine 0:
/data/sns.kobox.tv/lib/sns_common/resty/mysql.lua: in function 'read_result'
/data/matchvs.com/lib/user/connection.lua:72: in function 'releaseConn'
from lua-resty-mysql.
if mysqlConn then
local res, err, errno, sqlstate = mysqlConn:read_result()
while err == "again" do
res, err, errno, sqlstate = mysqlConn:read_result()
end
local ok, err = mysqlConn:set_keepalive(10000, 100)
if not ok then
mysqlConn:close()
ok = false
db_type = db_type + mysql_type
err = "MySQL.Error ( "..(err or "null").." ) "
end
end
from lua-resty-mysql.
local function read_result(self)
if self.state ~= STATE_COMMAND_SENT then
return nil, "cannot read result in the current context: " .. (self.state or "nil")--增加判断吧
end
from lua-resty-mysql.
@heyuanlong Please do not use Chinese here. Thank you.
Regarding the issue, yes, we should add the or ""
part there. Patches welcome and pull requests welcome :)
from lua-resty-mysql.
Committed a fix to git master. Thanks for the report.
from lua-resty-mysql.
Related Issues (20)
- TODO: support specify pool_size and backlog in connect method. HOT 1
- create_db, create_user, grant and switch_user
- _recv_packet 函数 遇到错误返回,read_result并没有设置mysql. state=1 而是直接返回nil,导致下一次query失败 HOT 5
- lua entry thread aborted: runtime error: /usr/local/openresty/lualib/resty/mysql.lua:571: bad request
- 腾讯云服务器上mysql,使用lua不能访问数据库 HOT 2
- 为什么查询结果不支持返回number类型,而是将number类型也按string类型返回?
- Hardcoded query works but API disabled in the current context when using a variable HOT 3
- world.sql.gz page was not found, resulting in a CI error HOT 5
- schedule for SQL prepare statement support
- /usr/local/openresty/lualib/resty/mysql.lua:373: attempt to perform arithmetic on field 'packet_no' (a nil value)
- mysql查询是否串行 HOT 1
- bad result: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
- install by luarocks error HOT 3
- can not use "not res" to judge if the 'res' is empty table
- The connect function is thrown incorrectly
- using lua-resty-mysql query table contents, returned body incorrect
- connect() to unix:/var/lib/mysql/mysql.sock failed (11: Resource temporarily unavailable)
- Client does not support authentication protocol requested by server; consider upgrading MySQL client: 1251 08004 HOT 1
- Test case failures on rhel 7.6 ppc64le platform HOT 1
- Connection pooling for php-fpm with nginx unix sockets and resty mysql HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from lua-resty-mysql.