(This page was automatically generated by the tools in the opsboy project on 15:08:05 28-Dec-2023 GMT.)

Detailed Test Report for lua-resty-mysql in linux x86_64 (r)

Summary

Commit Testing Time Unexpected
Failures
Expected
Failures
Files Tests Elapsed Time
82059c13 2020-10-18 03:12:29 GMT 303 0 sec

LuaJIT

LuaJIT 2.1.0-beta3, commit 0e646b54

OpenSSL

OpenSSL 1.1.1d 10 Sep 2019

Compilation Errors

Unexpected Failures

File Name Details
auth.t TEST 1: test different auth plugin - status code ok got: '500'
expected: '200'
auth.t TEST 1: test different auth plugin - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20400\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/t/servroot/html/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
'
auth.t TEST 1: test different auth plugin - status code ok got: '500'
expected: '200'
auth.t TEST 1: test different auth plugin - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20400\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/t/servroot/html/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
'
auth.t TEST 1: test different auth plugin - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20400\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:154):3: attempt to index local 'test_suit' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:154): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:08 [debug] 20400\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:08 [debug] 20400\#0: *2 lua deleting light thread
2020/10/18 03:32:08 [debug] 20400\#0: *2 lua caching unused lua thread 00007FB2F920CF60 (ref 1)
2020/10/18 03:32:08 [debug] 20400\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:08 [debug] 20400\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:08 [debug] 20400\#0: *2 http set discard body
'
auth.t TEST 1: test different auth plugin - status code ok got: '500'
expected: '200'
auth.t TEST 1: test different auth plugin - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20400\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 2) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/t/servroot/html/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
'
auth.t TEST 1: test different auth plugin - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20400\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:154):3: attempt to index local 'test_suit' (a number value)" (req 2) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:154): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:08 [debug] 20400\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:08 [debug] 20400\#0: *2 lua deleting light thread
2020/10/18 03:32:08 [debug] 20400\#0: *2 lua caching unused lua thread 00007FB2F920CF60 (ref 1)
2020/10/18 03:32:08 [debug] 20400\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:08 [debug] 20400\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:08 [debug] 20400\#0: *2 http set discard body
'
auth.t TEST 1: test different auth plugin - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20400\#0: *3 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:154):3: attempt to index local 'test_suit' (a number value)" (req 2) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:154): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:08 [debug] 20400\#0: *3 lua request cleanup: forcible=0
2020/10/18 03:32:08 [debug] 20400\#0: *3 lua deleting light thread
2020/10/18 03:32:08 [debug] 20400\#0: *3 lua caching unused lua thread 00007FB2F920CF60 (ref 1)
2020/10/18 03:32:08 [debug] 20400\#0: *3 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:08 [debug] 20400\#0: *3 http special response: 500, "/t?"
2020/10/18 03:32:08 [debug] 20400\#0: *3 http set discard body
'
auth.t TEST 1: test different auth plugin - status code ok got: '500'
expected: '200'
auth.t TEST 1: test different auth plugin - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20400\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 3) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/t/servroot/html/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
'
auth.t TEST 1: test different auth plugin - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20400\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:154):3: attempt to index local 'test_suit' (a number value)" (req 3) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:154): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:08 [debug] 20400\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:08 [debug] 20400\#0: *2 lua deleting light thread
2020/10/18 03:32:08 [debug] 20400\#0: *2 lua caching unused lua thread 00007FB2F920CF60 (ref 1)
2020/10/18 03:32:08 [debug] 20400\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:08 [debug] 20400\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:08 [debug] 20400\#0: *2 http set discard body
'
auth.t TEST 1: test different auth plugin - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20400\#0: *3 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:154):3: attempt to index local 'test_suit' (a number value)" (req 3) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:154): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:08 [debug] 20400\#0: *3 lua request cleanup: forcible=0
2020/10/18 03:32:08 [debug] 20400\#0: *3 lua deleting light thread
2020/10/18 03:32:08 [debug] 20400\#0: *3 lua caching unused lua thread 00007FB2F920CF60 (ref 1)
2020/10/18 03:32:08 [debug] 20400\#0: *3 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:08 [debug] 20400\#0: *3 http special response: 500, "/t?"
2020/10/18 03:32:08 [debug] 20400\#0: *3 http set discard body
'
auth.t TEST 1: test different auth plugin - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20400\#0: *4 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:154):3: attempt to index local 'test_suit' (a number value)" (req 3) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:154): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:08 [debug] 20400\#0: *4 lua request cleanup: forcible=0
2020/10/18 03:32:08 [debug] 20400\#0: *4 lua deleting light thread
2020/10/18 03:32:08 [debug] 20400\#0: *4 lua caching unused lua thread 00007FB2F920CF60 (ref 1)
2020/10/18 03:32:08 [debug] 20400\#0: *4 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:08 [debug] 20400\#0: *4 http special response: 500, "/t?"
2020/10/18 03:32:08 [debug] 20400\#0: *4 http set discard body
'
auth.t TEST 1: test different auth plugin - status code ok got: '500'
expected: '200'
auth.t TEST 1: test different auth plugin - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20400\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 4) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/t/servroot/html/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
'
auth.t TEST 1: test different auth plugin - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20400\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:154):3: attempt to index local 'test_suit' (a number value)" (req 4) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:154): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:08 [debug] 20400\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:08 [debug] 20400\#0: *2 lua deleting light thread
2020/10/18 03:32:08 [debug] 20400\#0: *2 lua caching unused lua thread 00007FB2F920CF60 (ref 1)
2020/10/18 03:32:08 [debug] 20400\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:08 [debug] 20400\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:08 [debug] 20400\#0: *2 http set discard body
'
auth.t TEST 1: test different auth plugin - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20400\#0: *3 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:154):3: attempt to index local 'test_suit' (a number value)" (req 4) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:154): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:08 [debug] 20400\#0: *3 lua request cleanup: forcible=0
2020/10/18 03:32:08 [debug] 20400\#0: *3 lua deleting light thread
2020/10/18 03:32:08 [debug] 20400\#0: *3 lua caching unused lua thread 00007FB2F920CF60 (ref 1)
2020/10/18 03:32:08 [debug] 20400\#0: *3 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:08 [debug] 20400\#0: *3 http special response: 500, "/t?"
2020/10/18 03:32:08 [debug] 20400\#0: *3 http set discard body
'
auth.t TEST 1: test different auth plugin - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20400\#0: *4 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:154):3: attempt to index local 'test_suit' (a number value)" (req 4) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:154): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:08 [debug] 20400\#0: *4 lua request cleanup: forcible=0
2020/10/18 03:32:08 [debug] 20400\#0: *4 lua deleting light thread
2020/10/18 03:32:08 [debug] 20400\#0: *4 lua caching unused lua thread 00007FB2F920CF60 (ref 1)
2020/10/18 03:32:08 [debug] 20400\#0: *4 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:08 [debug] 20400\#0: *4 http special response: 500, "/t?"
2020/10/18 03:32:08 [debug] 20400\#0: *4 http set discard body
'
auth.t TEST 1: test different auth plugin - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20400\#0: *5 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:154):3: attempt to index local 'test_suit' (a number value)" (req 4) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:154): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:08 [debug] 20400\#0: *5 lua request cleanup: forcible=0
2020/10/18 03:32:08 [debug] 20400\#0: *5 lua deleting light thread
2020/10/18 03:32:08 [debug] 20400\#0: *5 lua caching unused lua thread 00007FB2F920CF60 (ref 1)
2020/10/18 03:32:08 [debug] 20400\#0: *5 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:08 [debug] 20400\#0: *5 http special response: 500, "/t?"
2020/10/18 03:32:08 [debug] 20400\#0: *5 http set discard body
'
bug.t TEST 1: message in ok packet (github \#61) - status code ok got: '500'
expected: '200'
bug.t TEST 1: message in ok packet (github \#61) - response_body - response is expected (repeated req 0, req 0) got: '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
expected: 'Rows matched: 1 Changed: 1 Warnings: 0
'
bug.t TEST 1: message in ok packet (github \#61) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20407\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
bug.t TEST 1: message in ok packet (github \#61) - status code ok got: '500'
expected: '200'
bug.t TEST 1: message in ok packet (github \#61) - response_body - response is expected (repeated req 1, req 0) got: '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
expected: 'Rows matched: 1 Changed: 1 Warnings: 0
'
bug.t TEST 1: message in ok packet (github \#61) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20407\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
bug.t TEST 1: message in ok packet (github \#61) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:08 [error] 20407\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:98):18: attempt to index upvalue 'mysql_driver' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:98): in function 'query'
content_by_lua(nginx.conf:98):47: in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:08 [debug] 20407\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:08 [debug] 20407\#0: *2 lua deleting light thread
2020/10/18 03:32:08 [debug] 20407\#0: *2 lua caching unused lua thread 00007FA2BA1BDDB0 (ref 1)
2020/10/18 03:32:08 [debug] 20407\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:08 [debug] 20407\#0: *2 http special response: 500, "/t?"
'
charset.t TEST 1: connect db using charset option (utf8) - status code ok got: '500'
expected: '200'
charset.t TEST 1: connect db using charset option (utf8) - response_body - response is expected (repeated req 0, req 0) got: "<html>\x{0d}\x{0a}<head><title>500 Internal Server Error</ti"...
length: 187
expected: "[{"id":"1","name":"\x{e6}\x{84}\x{9b}\x{e9}\x{ba}\x{97}\x{e7}\x{b5}\x{b2}"}]\x{0a}"
length: 32
strings begin to differ at char 1 (line 1 column 1)
charset.t TEST 1: connect db using charset option (utf8) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:09 [error] 20413\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
charset.t TEST 1: connect db using charset option (utf8) - status code ok got: '500'
expected: '200'
charset.t TEST 1: connect db using charset option (utf8) - response_body - response is expected (repeated req 1, req 0) got: "<html>\x{0d}\x{0a}<head><title>500 Internal Server Error</ti"...
length: 187
expected: "[{"id":"1","name":"\x{e6}\x{84}\x{9b}\x{e9}\x{ba}\x{97}\x{e7}\x{b5}\x{b2}"}]\x{0a}"
length: 32
strings begin to differ at char 1 (line 1 column 1)
charset.t TEST 1: connect db using charset option (utf8) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:09 [error] 20413\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
charset.t TEST 1: connect db using charset option (utf8) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:09 [error] 20413\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:93):4: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:93): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:09 [debug] 20413\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:09 [debug] 20413\#0: *2 lua deleting light thread
2020/10/18 03:32:09 [debug] 20413\#0: *2 lua caching unused lua thread 00007FAFB9CD4FC8 (ref 1)
2020/10/18 03:32:09 [debug] 20413\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:09 [debug] 20413\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:09 [debug] 20413\#0: *2 http set discard body
'
charset.t TEST 2: connect db using charset option (big5) - status code ok got: '500'
expected: '200'
charset.t TEST 2: connect db using charset option (big5) - response_body - response is expected (repeated req 0, req 0) got: "<html>\x{0d}\x{0a}<head><title>500 Internal Server Error</ti"...
length: 187
expected: "[{"id":"1","name":"\x{b7}R\x{c4}R\x{b5}\x{b7}"}]\x{0a}"
length: 29
strings begin to differ at char 1 (line 1 column 1)
charset.t TEST 2: connect db using charset option (big5) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:09 [error] 20416\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
charset.t TEST 2: connect db using charset option (big5) - status code ok got: '500'
expected: '200'
charset.t TEST 2: connect db using charset option (big5) - response_body - response is expected (repeated req 1, req 0) got: "<html>\x{0d}\x{0a}<head><title>500 Internal Server Error</ti"...
length: 187
expected: "[{"id":"1","name":"\x{b7}R\x{c4}R\x{b5}\x{b7}"}]\x{0a}"
length: 29
strings begin to differ at char 1 (line 1 column 1)
charset.t TEST 2: connect db using charset option (big5) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:09 [error] 20416\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
charset.t TEST 2: connect db using charset option (big5) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:09 [error] 20416\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:93):4: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:93): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:09 [debug] 20416\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:09 [debug] 20416\#0: *2 lua deleting light thread
2020/10/18 03:32:09 [debug] 20416\#0: *2 lua caching unused lua thread 00007FD06CEF91C0 (ref 1)
2020/10/18 03:32:09 [debug] 20416\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:09 [debug] 20416\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:09 [debug] 20416\#0: *2 http set discard body
'
charset.t TEST 3: connect db using charset option (gbk) - status code ok got: '500'
expected: '200'
charset.t TEST 3: connect db using charset option (gbk) - response_body - response is expected (repeated req 0, req 0) got: "<html>\x{0d}\x{0a}<head><title>500 Internal Server Error</ti"...
length: 187
expected: "[{"id":"1","name":"\x{90}\x{db}\x{fb}\x{90}\x{bd}z"}]\x{0a}"
length: 29
strings begin to differ at char 1 (line 1 column 1)
charset.t TEST 3: connect db using charset option (gbk) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:09 [error] 20419\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
charset.t TEST 3: connect db using charset option (gbk) - status code ok got: '500'
expected: '200'
charset.t TEST 3: connect db using charset option (gbk) - response_body - response is expected (repeated req 1, req 0) got: "<html>\x{0d}\x{0a}<head><title>500 Internal Server Error</ti"...
length: 187
expected: "[{"id":"1","name":"\x{90}\x{db}\x{fb}\x{90}\x{bd}z"}]\x{0a}"
length: 29
strings begin to differ at char 1 (line 1 column 1)
charset.t TEST 3: connect db using charset option (gbk) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:09 [error] 20419\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
charset.t TEST 3: connect db using charset option (gbk) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:09 [error] 20419\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:93):4: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:93): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:09 [debug] 20419\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:09 [debug] 20419\#0: *2 lua deleting light thread
2020/10/18 03:32:09 [debug] 20419\#0: *2 lua caching unused lua thread 00007F2C013C2F98 (ref 1)
2020/10/18 03:32:09 [debug] 20419\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:09 [debug] 20419\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:09 [debug] 20419\#0: *2 http set discard body
'
compact_arrays.t TEST 1: send query w/o result set - status code ok got: '500'
expected: '200'
compact_arrays.t TEST 1: send query w/o result set - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql \d\.[^\s\x00]+\.
sent 30 bytes\.
result: (?:{"insert_id":0,"server_status":2,"warning_count":[01],"affected_rows":0}|{"affected_rows":0,"insert_id":0,"server_status":2,"warning_count":[01]})$)'
compact_arrays.t TEST 1: send query w/o result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:09 [error] 20425\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
compact_arrays.t TEST 1: send query w/o result set - status code ok got: '500'
expected: '200'
compact_arrays.t TEST 1: send query w/o result set - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql \d\.[^\s\x00]+\.
sent 30 bytes\.
result: (?:{"insert_id":0,"server_status":2,"warning_count":[01],"affected_rows":0}|{"affected_rows":0,"insert_id":0,"server_status":2,"warning_count":[01]})$)'
compact_arrays.t TEST 1: send query w/o result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:09 [error] 20425\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:85):3: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:85): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:09 [debug] 20425\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:09 [debug] 20425\#0: *2 lua deleting light thread
2020/10/18 03:32:09 [debug] 20425\#0: *2 lua caching unused lua thread 00007F34AC584140 (ref 1)
2020/10/18 03:32:09 [debug] 20425\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:09 [debug] 20425\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:09 [debug] 20425\#0: *2 http set discard body
'
compact_arrays.t TEST 2: select query with an non-empty result set - status code ok got: '500'
expected: '200'
compact_arrays.t TEST 2: select query with an non-empty result set - response_body - response is expected (repeated req 0, req 0) @@ -1,6 +1,7 @@
-connected to mysql.
+<html>
-table cats dropped.
+<head><title>500 Internal Server Error</title></head>
-table cats created.
+<body>
-3 rows inserted into table cats (last id: 1)
+<center><h1>500 Internal Server Error</h1></center>
-result: [["Bob","1"],["","2"],[null,"3"]]
+<hr><center>nginx/1.19.3 (no pool)</center>
-result: [[null,"3"],["","2"],["Bob","1"]]
+</body>
+</html>
'
compact_arrays.t TEST 2: select query with an non-empty result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:09 [error] 20428\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
compact_arrays.t TEST 2: select query with an non-empty result set - status code ok got: '500'
expected: '200'
compact_arrays.t TEST 2: select query with an non-empty result set - response_body - response is expected (repeated req 1, req 0) @@ -1,6 +1,7 @@
-connected to mysql.
+<html>
-table cats dropped.
+<head><title>500 Internal Server Error</title></head>
-table cats created.
+<body>
-3 rows inserted into table cats (last id: 1)
+<center><h1>500 Internal Server Error</h1></center>
-result: [["Bob","1"],["","2"],[null,"3"]]
+<hr><center>nginx/1.19.3 (no pool)</center>
-result: [[null,"3"],["","2"],["Bob","1"]]
+</body>
+</html>
'
compact_arrays.t TEST 2: select query with an non-empty result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:09 [error] 20428\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:112):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:112): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:09 [debug] 20428\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:09 [debug] 20428\#0: *2 lua deleting light thread
2020/10/18 03:32:09 [debug] 20428\#0: *2 lua caching unused lua thread 00007FB1E696D248 (ref 1)
2020/10/18 03:32:09 [debug] 20428\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:09 [debug] 20428\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:09 [debug] 20428\#0: *2 http set discard body
'
compact_arrays.t TEST 3: select query with an empty result set - status code ok got: '500'
expected: '200'
compact_arrays.t TEST 3: select query with an empty result set - response_body - response is expected (repeated req 0, req 0) @@ -1,5 +1,7 @@
-connected to mysql.
+<html>
-table cats dropped.
+<head><title>500 Internal Server Error</title></head>
-table cats created.
+<body>
-result: []
+<center><h1>500 Internal Server Error</h1></center>
-result: []
+<hr><center>nginx/1.19.3 (no pool)</center>
+</body>
+</html>
'
compact_arrays.t TEST 3: select query with an empty result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:09 [error] 20431\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
compact_arrays.t TEST 3: select query with an empty result set - status code ok got: '500'
expected: '200'
compact_arrays.t TEST 3: select query with an empty result set - response_body - response is expected (repeated req 1, req 0) @@ -1,5 +1,7 @@
-connected to mysql.
+<html>
-table cats dropped.
+<head><title>500 Internal Server Error</title></head>
-table cats created.
+<body>
-result: []
+<center><h1>500 Internal Server Error</h1></center>
-result: []
+<hr><center>nginx/1.19.3 (no pool)</center>
+</body>
+</html>
'
compact_arrays.t TEST 3: select query with an empty result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20431\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:104):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:104): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:10 [debug] 20431\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:10 [debug] 20431\#0: *2 lua deleting light thread
2020/10/18 03:32:10 [debug] 20431\#0: *2 lua caching unused lua thread 00007F3DE8386060 (ref 1)
2020/10/18 03:32:10 [debug] 20431\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:10 [debug] 20431\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:10 [debug] 20431\#0: *2 http set discard body
'
compact_arrays.t TEST 4: select query with an non-empty result set - set_compact_arrays - status code ok got: '500'
expected: '200'
compact_arrays.t TEST 4: select query with an non-empty result set - set_compact_arrays - response_body - response is expected (repeated req 0, req 0) @@ -1,6 +1,7 @@
-connected to mysql.
+<html>
-table cats dropped.
+<head><title>500 Internal Server Error</title></head>
-table cats created.
+<body>
-3 rows inserted into table cats (last id: 1)
+<center><h1>500 Internal Server Error</h1></center>
-result: [["Bob","1"],["","2"],[null,"3"]]
+<hr><center>nginx/1.19.3 (no pool)</center>
-result: [{"id":"3","name":null},{"id":"2","name":""},{"id":"1","name":"Bob"}]
+</body>
+</html>
'
compact_arrays.t TEST 4: select query with an non-empty result set - set_compact_arrays - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20434\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
compact_arrays.t TEST 4: select query with an non-empty result set - set_compact_arrays - status code ok got: '500'
expected: '200'
compact_arrays.t TEST 4: select query with an non-empty result set - set_compact_arrays - response_body - response is expected (repeated req 1, req 0) @@ -1,6 +1,7 @@
-connected to mysql.
+<html>
-table cats dropped.
+<head><title>500 Internal Server Error</title></head>
-table cats created.
+<body>
-3 rows inserted into table cats (last id: 1)
+<center><h1>500 Internal Server Error</h1></center>
-result: [["Bob","1"],["","2"],[null,"3"]]
+<hr><center>nginx/1.19.3 (no pool)</center>
-result: [{"id":"3","name":null},{"id":"2","name":""},{"id":"1","name":"Bob"}]
+</body>
+</html>
'
compact_arrays.t TEST 4: select query with an non-empty result set - set_compact_arrays - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20434\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:115):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:115): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:10 [debug] 20434\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:10 [debug] 20434\#0: *2 lua deleting light thread
2020/10/18 03:32:10 [debug] 20434\#0: *2 lua caching unused lua thread 00007F65A3F163C0 (ref 1)
2020/10/18 03:32:10 [debug] 20434\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:10 [debug] 20434\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:10 [debug] 20434\#0: *2 http set discard body
'
sanity.t TEST 1: bad user - status code ok got: '500'
expected: '200'
sanity.t TEST 1: bad user - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:failed to connect: Access denied for user 'user_not_found'@'[^\s]+' \(using password: YES\): 1045 28000
)'
sanity.t TEST 1: bad user - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20440\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 1: bad user - status code ok got: '500'
expected: '200'
sanity.t TEST 1: bad user - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:failed to connect: Access denied for user 'user_not_found'@'[^\s]+' \(using password: YES\): 1045 28000
)'
sanity.t TEST 1: bad user - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20440\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 1: bad user - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20440\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:63):3: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:63): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:10 [debug] 20440\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:10 [debug] 20440\#0: *2 lua deleting light thread
2020/10/18 03:32:10 [debug] 20440\#0: *2 lua caching unused lua thread 00007F420B770FD0 (ref 1)
2020/10/18 03:32:10 [debug] 20440\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:10 [debug] 20440\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:10 [debug] 20440\#0: *2 http set discard body
'
sanity.t TEST 2: bad host - status code ok got: '500'
expected: '200'
sanity.t TEST 2: bad host - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^failed to connect: failed to connect: host-not-found.org could not be resolved(?: \(3: Host not found\))?: nil nil$)'
sanity.t TEST 2: bad host - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20443\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 2: bad host - status code ok got: '500'
expected: '200'
sanity.t TEST 2: bad host - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^failed to connect: failed to connect: host-not-found.org could not be resolved(?: \(3: Host not found\))?: nil nil$)'
sanity.t TEST 2: bad host - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20443\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 2: bad host - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20443\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:63):3: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:63): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:10 [debug] 20443\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:10 [debug] 20443\#0: *2 lua deleting light thread
2020/10/18 03:32:10 [debug] 20443\#0: *2 lua caching unused lua thread 00007F8006C3E238 (ref 1)
2020/10/18 03:32:10 [debug] 20443\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:10 [debug] 20443\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:10 [debug] 20443\#0: *2 http set discard body
'
sanity.t TEST 3: connected - status code ok got: '500'
expected: '200'
sanity.t TEST 3: connected - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:connected to mysql \d\.[^\s\x00]+
)'
sanity.t TEST 3: connected - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20446\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 3: connected - status code ok got: '500'
expected: '200'
sanity.t TEST 3: connected - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:connected to mysql \d\.[^\s\x00]+
)'
sanity.t TEST 3: connected - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20446\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 3: connected - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20446\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:65):3: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:65): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:10 [debug] 20446\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:10 [debug] 20446\#0: *2 lua deleting light thread
2020/10/18 03:32:10 [debug] 20446\#0: *2 lua caching unused lua thread 00007FE8CED4B248 (ref 1)
2020/10/18 03:32:10 [debug] 20446\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:10 [debug] 20446\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:10 [debug] 20446\#0: *2 http set discard body
'
sanity.t TEST 4: send query w/o result set - status code ok got: '500'
expected: '200'
sanity.t TEST 4: send query w/o result set - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql \d\.[^\s\x00]+\.
sent 30 bytes\.
result: \{"affected_rows":0,"insert_id":0,"server_status":2,"warning_count":[01]\}$)'
sanity.t TEST 4: send query w/o result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20449\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 4: send query w/o result set - status code ok got: '500'
expected: '200'
sanity.t TEST 4: send query w/o result set - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql \d\.[^\s\x00]+\.
sent 30 bytes\.
result: \{"affected_rows":0,"insert_id":0,"server_status":2,"warning_count":[01]\}$)'
sanity.t TEST 4: send query w/o result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20449\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 4: send query w/o result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20449\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:84):3: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:84): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:10 [debug] 20449\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:10 [debug] 20449\#0: *2 lua deleting light thread
2020/10/18 03:32:10 [debug] 20449\#0: *2 lua caching unused lua thread 00007F18C130D248 (ref 1)
2020/10/18 03:32:10 [debug] 20449\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:10 [debug] 20449\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:10 [debug] 20449\#0: *2 http set discard body
'
sanity.t TEST 5: send bad query - status code ok got: '500'
expected: '200'
sanity.t TEST 5: send bad query - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql \d\.[^\s\x00]+\.
sent 12 bytes\.
bad result: You have an error in your SQL syntax; check the manual that corresponds to your (?:MySQL|MariaDB) server version for the right syntax to use near 'bad SQL' at line 1: 1064: 42000\.$)'
sanity.t TEST 5: send bad query - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20452\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 5: send bad query - status code ok got: '500'
expected: '200'
sanity.t TEST 5: send bad query - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql \d\.[^\s\x00]+\.
sent 12 bytes\.
bad result: You have an error in your SQL syntax; check the manual that corresponds to your (?:MySQL|MariaDB) server version for the right syntax to use near 'bad SQL' at line 1: 1064: 42000\.$)'
sanity.t TEST 5: send bad query - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20452\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 5: send bad query - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:10 [error] 20452\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:85):3: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:85): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:10 [debug] 20452\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:10 [debug] 20452\#0: *2 lua deleting light thread
2020/10/18 03:32:10 [debug] 20452\#0: *2 lua caching unused lua thread 00007F7B0C4F77F8 (ref 1)
2020/10/18 03:32:10 [debug] 20452\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:10 [debug] 20452\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:10 [debug] 20452\#0: *2 http set discard body
'
sanity.t TEST 6: select query with an non-empty result set - status code ok got: '500'
expected: '200'
sanity.t TEST 6: select query with an non-empty result set - response_body - response is expected (repeated req 0, req 0) @@ -1,6 +1,7 @@
-connected to mysql.
+<html>
-table cats dropped.
+<head><title>500 Internal Server Error</title></head>
-table cats created.
+<body>
-3 rows inserted into table cats (last id: 1)
+<center><h1>500 Internal Server Error</h1></center>
-result: [{"id":"1","name":"Bob"},{"id":"2","name":""},{"id":"3","name":null}]
+<hr><center>nginx/1.19.3 (no pool)</center>
-result: [{"id":"3","name":null},{"id":"2","name":""},{"id":"1","name":"Bob"}]
+</body>
+</html>
'
sanity.t TEST 6: select query with an non-empty result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20455\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 6: select query with an non-empty result set - status code ok got: '500'
expected: '200'
sanity.t TEST 6: select query with an non-empty result set - response_body - response is expected (repeated req 1, req 0) @@ -1,6 +1,7 @@
-connected to mysql.
+<html>
-table cats dropped.
+<head><title>500 Internal Server Error</title></head>
-table cats created.
+<body>
-3 rows inserted into table cats (last id: 1)
+<center><h1>500 Internal Server Error</h1></center>
-result: [{"id":"1","name":"Bob"},{"id":"2","name":""},{"id":"3","name":null}]
+<hr><center>nginx/1.19.3 (no pool)</center>
-result: [{"id":"3","name":null},{"id":"2","name":""},{"id":"1","name":"Bob"}]
+</body>
+</html>
'
sanity.t TEST 6: select query with an non-empty result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20455\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 6: select query with an non-empty result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20455\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:111):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:111): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:11 [debug] 20455\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:11 [debug] 20455\#0: *2 lua deleting light thread
2020/10/18 03:32:11 [debug] 20455\#0: *2 lua caching unused lua thread 00007F8DED505A58 (ref 1)
2020/10/18 03:32:11 [debug] 20455\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:11 [debug] 20455\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:11 [debug] 20455\#0: *2 http set discard body
'
sanity.t TEST 7: select query with an empty result set - status code ok got: '500'
expected: '200'
sanity.t TEST 7: select query with an empty result set - response_body - response is expected (repeated req 0, req 0) @@ -1,5 +1,7 @@
-connected to mysql.
+<html>
-table cats dropped.
+<head><title>500 Internal Server Error</title></head>
-table cats created.
+<body>
-result: []
+<center><h1>500 Internal Server Error</h1></center>
-result: []
+<hr><center>nginx/1.19.3 (no pool)</center>
+</body>
+</html>
'
sanity.t TEST 7: select query with an empty result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20458\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 7: select query with an empty result set - status code ok got: '500'
expected: '200'
sanity.t TEST 7: select query with an empty result set - response_body - response is expected (repeated req 1, req 0) @@ -1,5 +1,7 @@
-connected to mysql.
+<html>
-table cats dropped.
+<head><title>500 Internal Server Error</title></head>
-table cats created.
+<body>
-result: []
+<center><h1>500 Internal Server Error</h1></center>
-result: []
+<hr><center>nginx/1.19.3 (no pool)</center>
+</body>
+</html>
'
sanity.t TEST 7: select query with an empty result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20458\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 7: select query with an empty result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20458\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:103):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:103): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:11 [debug] 20458\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:11 [debug] 20458\#0: *2 lua deleting light thread
2020/10/18 03:32:11 [debug] 20458\#0: *2 lua caching unused lua thread 00007FDA4A28C1E8 (ref 1)
2020/10/18 03:32:11 [debug] 20458\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:11 [debug] 20458\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:11 [debug] 20458\#0: *2 http set discard body
'
sanity.t TEST 8: numerical types - status code ok got: '500'
expected: '200'
sanity.t TEST 8: numerical types - response_body - response is expected (repeated req 0, req 0) @@ -1,6 +1,7 @@
-connected to mysql.
+<html>
-table foo dropped.
+<head><title>500 Internal Server Error</title></head>
-table foo created.
+<body>
-2 rows inserted into table foo (last id: 1)
+<center><h1>500 Internal Server Error</h1></center>
-result: [{"bah":3.14,"bar":3,"baz":4,"blah":5.16,"hah":256,"haha":1998,"id":"1","kah":"65535","lah":579},{"bah":null,"bar":null,"baz":null,"blah":null,"hah":null,"haha":null,"id":"2","kah":null,"lah":null}]
+<hr><center>nginx/1.19.3 (no pool)</center>
-result: [{"bah":null,"bar":null,"baz":null,"blah":null,"hah":null,"haha":null,"id":"2","kah":null,"lah":null},{"bah":3.14,"bar":3,"baz":4,"blah":5.16,"hah":256,"haha":1998,"id":"1","kah":"65535","lah":579}]
+</body>
+</html>
'
sanity.t TEST 8: numerical types - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20461\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 8: numerical types - status code ok got: '500'
expected: '200'
sanity.t TEST 8: numerical types - response_body - response is expected (repeated req 1, req 0) @@ -1,6 +1,7 @@
-connected to mysql.
+<html>
-table foo dropped.
+<head><title>500 Internal Server Error</title></head>
-table foo created.
+<body>
-2 rows inserted into table foo (last id: 1)
+<center><h1>500 Internal Server Error</h1></center>
-result: [{"bah":3.14,"bar":3,"baz":4,"blah":5.16,"hah":256,"haha":1998,"id":"1","kah":"65535","lah":579},{"bah":null,"bar":null,"baz":null,"blah":null,"hah":null,"haha":null,"id":"2","kah":null,"lah":null}]
+<hr><center>nginx/1.19.3 (no pool)</center>
-result: [{"bah":null,"bar":null,"baz":null,"blah":null,"hah":null,"haha":null,"id":"2","kah":null,"lah":null},{"bah":3.14,"bar":3,"baz":4,"blah":5.16,"hah":256,"haha":1998,"id":"1","kah":"65535","lah":579}]
+</body>
+</html>
'
sanity.t TEST 8: numerical types - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20461\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 8: numerical types - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20461\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:111):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:111): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:11 [debug] 20461\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:11 [debug] 20461\#0: *2 lua deleting light thread
2020/10/18 03:32:11 [debug] 20461\#0: *2 lua caching unused lua thread 00007FF74173A2B8 (ref 1)
2020/10/18 03:32:11 [debug] 20461\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:11 [debug] 20461\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:11 [debug] 20461\#0: *2 http set discard body
'
sanity.t TEST 9: multiple DDL statements - status code ok got: '500'
expected: '200'
sanity.t TEST 9: multiple DDL statements - response_body - response is expected (repeated req 0, req 0) @@ -1,3 +1,7 @@
-connected to mysql.
+<html>
-result: {"affected_rows":0,"insert_id":0,"server_status":10,"warning_count":0}, err:again
+<head><title>500 Internal Server Error</title></head>
-bad result: failed to send query: cannot send query in the current context: 2: nil: nil.
+<body>
+<center><h1>500 Internal Server Error</h1></center>
+<hr><center>nginx/1.19.3 (no pool)</center>
+</body>
+</html>
'
sanity.t TEST 9: multiple DDL statements - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20464\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 9: multiple DDL statements - status code ok got: '500'
expected: '200'
sanity.t TEST 9: multiple DDL statements - response_body - response is expected (repeated req 1, req 0) @@ -1,3 +1,7 @@
-connected to mysql.
+<html>
-result: {"affected_rows":0,"insert_id":0,"server_status":10,"warning_count":0}, err:again
+<head><title>500 Internal Server Error</title></head>
-bad result: failed to send query: cannot send query in the current context: 2: nil: nil.
+<body>
+<center><h1>500 Internal Server Error</h1></center>
+<hr><center>nginx/1.19.3 (no pool)</center>
+</body>
+</html>
'
sanity.t TEST 9: multiple DDL statements - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20464\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 9: multiple DDL statements - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20464\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:107):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:107): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:11 [debug] 20464\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:11 [debug] 20464\#0: *2 lua deleting light thread
2020/10/18 03:32:11 [debug] 20464\#0: *2 lua caching unused lua thread 00007F4B1F9F0140 (ref 1)
2020/10/18 03:32:11 [debug] 20464\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:11 [debug] 20464\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:11 [debug] 20464\#0: *2 http set discard body
'
sanity.t TEST 10: multiple select queries - status code ok got: '500'
expected: '200'
sanity.t TEST 10: multiple select queries - response_body - response is expected (repeated req 0, req 0) @@ -1,6 +1,7 @@
-connected to mysql.
+<html>
-table cats dropped.
+<head><title>500 Internal Server Error</title></head>
-table cats created.
+<body>
-3 rows inserted into table cats (last id: 1)
+<center><h1>500 Internal Server Error</h1></center>
-result: [{"id":"1","name":"Bob"},{"id":"2","name":""},{"id":"3","name":null}], err:again
+<hr><center>nginx/1.19.3 (no pool)</center>
-result: [{"id":"3","name":null},{"id":"2","name":""},{"id":"1","name":"Bob"}], err:nil
+</body>
+</html>
'
sanity.t TEST 10: multiple select queries - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20467\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 10: multiple select queries - status code ok got: '500'
expected: '200'
sanity.t TEST 10: multiple select queries - response_body - response is expected (repeated req 1, req 0) @@ -1,6 +1,7 @@
-connected to mysql.
+<html>
-table cats dropped.
+<head><title>500 Internal Server Error</title></head>
-table cats created.
+<body>
-3 rows inserted into table cats (last id: 1)
+<center><h1>500 Internal Server Error</h1></center>
-result: [{"id":"1","name":"Bob"},{"id":"2","name":""},{"id":"3","name":null}], err:again
+<hr><center>nginx/1.19.3 (no pool)</center>
-result: [{"id":"3","name":null},{"id":"2","name":""},{"id":"1","name":"Bob"}], err:nil
+</body>
+</html>
'
sanity.t TEST 10: multiple select queries - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20467\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 10: multiple select queries - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20467\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:118):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:118): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:11 [debug] 20467\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:11 [debug] 20467\#0: *2 lua deleting light thread
2020/10/18 03:32:11 [debug] 20467\#0: *2 lua caching unused lua thread 00007FDD5E2B00C0 (ref 1)
2020/10/18 03:32:11 [debug] 20467\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:11 [debug] 20467\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:11 [debug] 20467\#0: *2 http set discard body
'
sanity.t TEST 11: set_keepalive in the wrong state - status code ok got: '500'
expected: '200'
sanity.t TEST 11: set_keepalive in the wrong state - response_body - response is expected (repeated req 0, req 0) @@ -1,6 +1,7 @@
-connected to mysql.
+<html>
-table cats dropped.
+<head><title>500 Internal Server Error</title></head>
-table cats created.
+<body>
-3 rows inserted into table cats (last id: 1)
+<center><h1>500 Internal Server Error</h1></center>
-result: [{"id":"1","name":"Bob"},{"id":"2","name":""},{"id":"3","name":null}], err:again
+<hr><center>nginx/1.19.3 (no pool)</center>
-failed to set keepalive: cannot be reused in the current connection state: 2
+</body>
+</html>
'
sanity.t TEST 11: set_keepalive in the wrong state - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20470\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 11: set_keepalive in the wrong state - status code ok got: '500'
expected: '200'
sanity.t TEST 11: set_keepalive in the wrong state - response_body - response is expected (repeated req 1, req 0) @@ -1,6 +1,7 @@
-connected to mysql.
+<html>
-table cats dropped.
+<head><title>500 Internal Server Error</title></head>
-table cats created.
+<body>
-3 rows inserted into table cats (last id: 1)
+<center><h1>500 Internal Server Error</h1></center>
-result: [{"id":"1","name":"Bob"},{"id":"2","name":""},{"id":"3","name":null}], err:again
+<hr><center>nginx/1.19.3 (no pool)</center>
-failed to set keepalive: cannot be reused in the current connection state: 2
+</body>
+</html>
'
sanity.t TEST 11: set_keepalive in the wrong state - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20470\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 11: set_keepalive in the wrong state - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20470\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:110):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:110): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:11 [debug] 20470\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:11 [debug] 20470\#0: *2 lua deleting light thread
2020/10/18 03:32:11 [debug] 20470\#0: *2 lua caching unused lua thread 00007F6A44BE6FB8 (ref 1)
2020/10/18 03:32:11 [debug] 20470\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:11 [debug] 20470\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:11 [debug] 20470\#0: *2 http set discard body
'
sanity.t TEST 12: set keepalive (tcp) - status code ok got: '500'
expected: '200'
sanity.t TEST 12: set keepalive (tcp) - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql: [02]
connected to mysql: [13]
result: \[\{"id":"1","name":"Bob"\},\{"id":"2","name":""\},\{"id":"3","name":null\}\], err:nil$)'
sanity.t TEST 12: set keepalive (tcp) - pattern "(?^:lua tcp socket keepalive create connection pool for key "ngx_test:ngx_test:[^\s:]+:\d+")" should match a line in error.log (req 0)
sanity.t TEST 12: set keepalive (tcp) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20473\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 12: set keepalive (tcp) - status code ok got: '500'
expected: '200'
sanity.t TEST 12: set keepalive (tcp) - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql: [02]
connected to mysql: [13]
result: \[\{"id":"1","name":"Bob"\},\{"id":"2","name":""\},\{"id":"3","name":null\}\], err:nil$)'
sanity.t TEST 12: set keepalive (tcp) - pattern "(?^:lua tcp socket keepalive create connection pool for key "ngx_test:ngx_test:[^\s:]+:\d+")" should match a line in error.log (req 1)
sanity.t TEST 12: set keepalive (tcp) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:11 [error] 20473\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 12: set keepalive (tcp) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:12 [error] 20473\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:95):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:95): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:12 [debug] 20473\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:12 [debug] 20473\#0: *2 lua deleting light thread
2020/10/18 03:32:12 [debug] 20473\#0: *2 lua caching unused lua thread 00007F63E4B2C128 (ref 1)
2020/10/18 03:32:12 [debug] 20473\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:12 [debug] 20473\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:12 [debug] 20473\#0: *2 http set discard body
'
sanity.t TEST 13: send query w/o result set (unix domain socket) - status code ok got: '500'
expected: '200'
sanity.t TEST 13: send query w/o result set (unix domain socket) - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql \d\.[^\s\x00]+\.
sent 30 bytes\.
result: (?:\{"insert_id":0,"server_status":2,"warning_count":1,"affected_rows":0}|{"affected_rows":0,"insert_id":0,"server_status":2,"warning_count":[01]\})$)'
sanity.t TEST 13: send query w/o result set (unix domain socket) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:12 [error] 20476\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 13: send query w/o result set (unix domain socket) - status code ok got: '500'
expected: '200'
sanity.t TEST 13: send query w/o result set (unix domain socket) - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql \d\.[^\s\x00]+\.
sent 30 bytes\.
result: (?:\{"insert_id":0,"server_status":2,"warning_count":1,"affected_rows":0}|{"affected_rows":0,"insert_id":0,"server_status":2,"warning_count":[01]\})$)'
sanity.t TEST 13: send query w/o result set (unix domain socket) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:12 [error] 20476\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 13: send query w/o result set (unix domain socket) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:12 [error] 20476\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:83):3: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:83): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:12 [debug] 20476\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:12 [debug] 20476\#0: *2 lua deleting light thread
2020/10/18 03:32:12 [debug] 20476\#0: *2 lua caching unused lua thread 00007FD06C7090A0 (ref 1)
2020/10/18 03:32:12 [debug] 20476\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:12 [debug] 20476\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:12 [debug] 20476\#0: *2 http set discard body
'
sanity.t TEST 14: null at the beginning of a row - status code ok got: '500'
expected: '200'
sanity.t TEST 14: null at the beginning of a row - response_body - response is expected (repeated req 0, req 0) @@ -1,6 +1,7 @@
-connected to mysql.
+<html>
-table cats dropped.
+<head><title>500 Internal Server Error</title></head>
-table cats created.
+<body>
-3 rows inserted into table cats (last id: 1)
+<center><h1>500 Internal Server Error</h1></center>
-result: [{"name":"Bob"},{"name":""},{"name":null}]
+<hr><center>nginx/1.19.3 (no pool)</center>
-result: [{"name":null},{"name":""},{"name":"Bob"}]
+</body>
+</html>
'
sanity.t TEST 14: null at the beginning of a row - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:12 [error] 20479\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 14: null at the beginning of a row - status code ok got: '500'
expected: '200'
sanity.t TEST 14: null at the beginning of a row - response_body - response is expected (repeated req 1, req 0) @@ -1,6 +1,7 @@
-connected to mysql.
+<html>
-table cats dropped.
+<head><title>500 Internal Server Error</title></head>
-table cats created.
+<body>
-3 rows inserted into table cats (last id: 1)
+<center><h1>500 Internal Server Error</h1></center>
-result: [{"name":"Bob"},{"name":""},{"name":null}]
+<hr><center>nginx/1.19.3 (no pool)</center>
-result: [{"name":null},{"name":""},{"name":"Bob"}]
+</body>
+</html>
'
sanity.t TEST 14: null at the beginning of a row - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:12 [error] 20479\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 14: null at the beginning of a row - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:12 [error] 20479\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:112):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:112): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:12 [debug] 20479\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:12 [debug] 20479\#0: *2 lua deleting light thread
2020/10/18 03:32:12 [debug] 20479\#0: *2 lua caching unused lua thread 00007F98620E60E8 (ref 1)
2020/10/18 03:32:12 [debug] 20479\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:12 [debug] 20479\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:12 [debug] 20479\#0: *2 http set discard body
'
sanity.t TEST 15: set keepalive (uds) - status code ok got: '500'
expected: '200'
sanity.t TEST 15: set keepalive (uds) - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql: [02]
connected to mysql: [13]
result: \[\{"id":"1","name":"Bob"\},\{"id":"2","name":""\},\{"id":"3","name":null\}\], err:nil$)'
sanity.t TEST 15: set keepalive (uds) - pattern "(?^:lua tcp socket keepalive create connection pool for key "ngx_test:ngx_test:[^\s:]+")" should match a line in error.log (req 0)
sanity.t TEST 15: set keepalive (uds) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:13 [error] 20482\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 15: set keepalive (uds) - status code ok got: '500'
expected: '200'
sanity.t TEST 15: set keepalive (uds) - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql: [02]
connected to mysql: [13]
result: \[\{"id":"1","name":"Bob"\},\{"id":"2","name":""\},\{"id":"3","name":null\}\], err:nil$)'
sanity.t TEST 15: set keepalive (uds) - pattern "(?^:lua tcp socket keepalive create connection pool for key "ngx_test:ngx_test:[^\s:]+")" should match a line in error.log (req 1)
sanity.t TEST 15: set keepalive (uds) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:13 [error] 20482\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 15: set keepalive (uds) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:13 [error] 20482\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:94):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:94): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:13 [debug] 20482\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:13 [debug] 20482\#0: *2 lua deleting light thread
2020/10/18 03:32:13 [debug] 20482\#0: *2 lua caching unused lua thread 00007FD25971B2E8 (ref 1)
2020/10/18 03:32:13 [debug] 20482\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:13 [debug] 20482\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:13 [debug] 20482\#0: *2 http set discard body
'
sanity.t TEST 16: set keepalive (explicit pool name) - status code ok got: '500'
expected: '200'
sanity.t TEST 16: set keepalive (explicit pool name) - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql: [02]
connected to mysql: [13]
result: \[\{"id":"1","name":"Bob"\},\{"id":"2","name":""\},\{"id":"3","name":null\}\], err:nil$)'
sanity.t TEST 16: set keepalive (explicit pool name) - pattern "(?^:lua tcp socket keepalive create connection pool for key "my_pool")" should match a line in error.log (req 0)
sanity.t TEST 16: set keepalive (explicit pool name) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:13 [error] 20485\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 16: set keepalive (explicit pool name) - status code ok got: '500'
expected: '200'
sanity.t TEST 16: set keepalive (explicit pool name) - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql: [02]
connected to mysql: [13]
result: \[\{"id":"1","name":"Bob"\},\{"id":"2","name":""\},\{"id":"3","name":null\}\], err:nil$)'
sanity.t TEST 16: set keepalive (explicit pool name) - pattern "(?^:lua tcp socket keepalive create connection pool for key "my_pool")" should match a line in error.log (req 1)
sanity.t TEST 16: set keepalive (explicit pool name) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:13 [error] 20485\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 16: set keepalive (explicit pool name) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:14 [error] 20485\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:97):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:97): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:14 [debug] 20485\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:14 [debug] 20485\#0: *2 lua deleting light thread
2020/10/18 03:32:14 [debug] 20485\#0: *2 lua caching unused lua thread 00007FB04007C3C0 (ref 1)
2020/10/18 03:32:14 [debug] 20485\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:14 [debug] 20485\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:14 [debug] 20485\#0: *2 http set discard body
'
sanity.t TEST 17: the mysql newdecimal type - status code ok got: '500'
expected: '200'
sanity.t TEST 17: the mysql newdecimal type - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql: [02]
connected to mysql: [13]
result: \[\{"sum\(id\)":6\}\], err:nil$)'
sanity.t TEST 17: the mysql newdecimal type - pattern "(?^:lua tcp socket keepalive create connection pool for key "my_pool")" should match a line in error.log (req 0)
sanity.t TEST 17: the mysql newdecimal type - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:14 [error] 20488\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 17: the mysql newdecimal type - status code ok got: '500'
expected: '200'
sanity.t TEST 17: the mysql newdecimal type - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql: [02]
connected to mysql: [13]
result: \[\{"sum\(id\)":6\}\], err:nil$)'
sanity.t TEST 17: the mysql newdecimal type - pattern "(?^:lua tcp socket keepalive create connection pool for key "my_pool")" should match a line in error.log (req 1)
sanity.t TEST 17: the mysql newdecimal type - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:14 [error] 20488\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 17: the mysql newdecimal type - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:14 [error] 20488\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:97):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:97): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:14 [debug] 20488\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:14 [debug] 20488\#0: *2 lua deleting light thread
2020/10/18 03:32:14 [debug] 20488\#0: *2 lua caching unused lua thread 00007F7E1D491238 (ref 1)
2020/10/18 03:32:14 [debug] 20488\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:14 [debug] 20488\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:14 [debug] 20488\#0: *2 http set discard body
'
sanity.t TEST 18: large insert_id exceeding a 32-bit integer value - status code ok got: '500'
expected: '200'
sanity.t TEST 18: large insert_id exceeding a 32-bit integer value - response_body - response is expected (repeated req 0, req 0) got: '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
expected: '5000000312
'
sanity.t TEST 18: large insert_id exceeding a 32-bit integer value - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:15 [error] 20491\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 18: large insert_id exceeding a 32-bit integer value - status code ok got: '500'
expected: '200'
sanity.t TEST 18: large insert_id exceeding a 32-bit integer value - response_body - response is expected (repeated req 1, req 0) got: '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
expected: '5000000312
'
sanity.t TEST 18: large insert_id exceeding a 32-bit integer value - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:15 [error] 20491\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 18: large insert_id exceeding a 32-bit integer value - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:15 [error] 20491\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:91):15: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:91): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:15 [debug] 20491\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:15 [debug] 20491\#0: *2 lua deleting light thread
2020/10/18 03:32:15 [debug] 20491\#0: *2 lua caching unused lua thread 00007F3E5AE61548 (ref 1)
2020/10/18 03:32:15 [debug] 20491\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:15 [debug] 20491\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:15 [debug] 20491\#0: *2 http set discard body
'
sanity.t TEST 19: fix packet number overflow - status code ok got: '500'
expected: '200'
sanity.t TEST 19: fix packet number overflow - response_body - response is expected (repeated req 0, req 0) got: '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
expected: 'success
'
sanity.t TEST 19: fix packet number overflow - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:15 [error] 20494\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 19: fix packet number overflow - status code ok got: '500'
expected: '200'
sanity.t TEST 19: fix packet number overflow - response_body - response is expected (repeated req 1, req 0) got: '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
expected: 'success
'
sanity.t TEST 19: fix packet number overflow - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:15 [error] 20494\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 19: fix packet number overflow - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:15 [error] 20494\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:100):3: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:100): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:15 [debug] 20494\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:15 [debug] 20494\#0: *2 lua deleting light thread
2020/10/18 03:32:15 [debug] 20494\#0: *2 lua caching unused lua thread 00007F5BBFB13EF8 (ref 1)
2020/10/18 03:32:15 [debug] 20494\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:15 [debug] 20494\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:15 [debug] 20494\#0: *2 http set discard body
'
sanity.t TEST 20: 251 columns - status code ok got: '500'
expected: '200'
sanity.t TEST 20: 251 columns - response_body - response is expected (repeated req 0, req 0) got: '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
expected: 'success
'
sanity.t TEST 20: 251 columns - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:15 [error] 20497\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 20: 251 columns - status code ok got: '500'
expected: '200'
sanity.t TEST 20: 251 columns - response_body - response is expected (repeated req 1, req 0) got: '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
expected: 'success
'
sanity.t TEST 20: 251 columns - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:15 [error] 20497\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 20: 251 columns - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:15 [error] 20497\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:108):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:108): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:15 [debug] 20497\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:15 [debug] 20497\#0: *2 lua deleting light thread
2020/10/18 03:32:15 [debug] 20497\#0: *2 lua caching unused lua thread 00007F9848C962D0 (ref 1)
2020/10/18 03:32:15 [debug] 20497\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:15 [debug] 20497\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:15 [debug] 20497\#0: *2 http set discard body
'
sanity.t TEST 21: MySQL has hard limit of 4096 columns per table - status code ok got: '500'
expected: '200'
sanity.t TEST 21: MySQL has hard limit of 4096 columns per table - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:bad result: .*Too many columns.*.
)'
sanity.t TEST 21: MySQL has hard limit of 4096 columns per table - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:15 [error] 20500\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 21: MySQL has hard limit of 4096 columns per table - status code ok got: '500'
expected: '200'
sanity.t TEST 21: MySQL has hard limit of 4096 columns per table - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:bad result: .*Too many columns.*.
)'
sanity.t TEST 21: MySQL has hard limit of 4096 columns per table - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:15 [error] 20500\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 21: MySQL has hard limit of 4096 columns per table - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:15 [error] 20500\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:108):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:108): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:15 [debug] 20500\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:15 [debug] 20500\#0: *2 lua deleting light thread
2020/10/18 03:32:15 [debug] 20500\#0: *2 lua caching unused lua thread 00007F99F7FA3238 (ref 1)
2020/10/18 03:32:15 [debug] 20500\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:15 [debug] 20500\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:15 [debug] 20500\#0: *2 http set discard body
'
sanity.t TEST 22: InnoDB has a limit of 1017 columns per table - status code ok got: '500'
expected: '200'
sanity.t TEST 22: InnoDB has a limit of 1017 columns per table - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:bad result: .*?(?:Too many columns|Can't create table 'ngx_test\.test1018' \(errno: 139\)))'
sanity.t TEST 22: InnoDB has a limit of 1017 columns per table - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:15 [error] 20503\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 22: InnoDB has a limit of 1017 columns per table - status code ok got: '500'
expected: '200'
sanity.t TEST 22: InnoDB has a limit of 1017 columns per table - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:bad result: .*?(?:Too many columns|Can't create table 'ngx_test\.test1018' \(errno: 139\)))'
sanity.t TEST 22: InnoDB has a limit of 1017 columns per table - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:15 [error] 20503\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 22: InnoDB has a limit of 1017 columns per table - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:15 [error] 20503\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:108):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:108): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:15 [debug] 20503\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:15 [debug] 20503\#0: *2 lua deleting light thread
2020/10/18 03:32:15 [debug] 20503\#0: *2 lua caching unused lua thread 00007F0BB8220CE8 (ref 1)
2020/10/18 03:32:15 [debug] 20503\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:15 [debug] 20503\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:15 [debug] 20503\#0: *2 http set discard body
'
sanity.t TEST 23: MyISAM columns per table > 1017 - status code ok got: '500'
expected: '200'
sanity.t TEST 23: MyISAM columns per table > 1017 - response_body - response is expected (repeated req 0, req 0) got: '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
expected: 'success
'
sanity.t TEST 23: MyISAM columns per table > 1017 - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:16 [error] 20506\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 23: MyISAM columns per table > 1017 - status code ok got: '500'
expected: '200'
sanity.t TEST 23: MyISAM columns per table > 1017 - response_body - response is expected (repeated req 1, req 0) got: '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
expected: 'success
'
sanity.t TEST 23: MyISAM columns per table > 1017 - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:16 [error] 20506\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 23: MyISAM columns per table > 1017 - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:16 [error] 20506\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:108):5: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:108): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:16 [debug] 20506\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:16 [debug] 20506\#0: *2 lua deleting light thread
2020/10/18 03:32:16 [debug] 20506\#0: *2 lua caching unused lua thread 00007FCBEE9EDFE0 (ref 1)
2020/10/18 03:32:16 [debug] 20506\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:16 [debug] 20506\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:16 [debug] 20506\#0: *2 http set discard body
'
sanity.t TEST 24: connected with no error when pool opts are provided - status code ok got: '500'
expected: '200'
sanity.t TEST 24: connected with no error when pool opts are provided - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:connected to mysql \d\.[^\s\x00]+
)'
sanity.t TEST 24: connected with no error when pool opts are provided - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:16 [error] 20509\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 24: connected with no error when pool opts are provided - status code ok got: '500'
expected: '200'
sanity.t TEST 24: connected with no error when pool opts are provided - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:connected to mysql \d\.[^\s\x00]+
)'
sanity.t TEST 24: connected with no error when pool opts are provided - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:16 [error] 20509\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 24: connected with no error when pool opts are provided - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:16 [error] 20509\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:69):3: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:69): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:16 [debug] 20509\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:16 [debug] 20509\#0: *2 lua deleting light thread
2020/10/18 03:32:16 [debug] 20509\#0: *2 lua caching unused lua thread 00007FC947CAB228 (ref 1)
2020/10/18 03:32:16 [debug] 20509\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:16 [debug] 20509\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:16 [debug] 20509\#0: *2 http set discard body
'
sanity.t TEST 25: set pool_size option no backlog option - status code ok got: '500'
expected: '200'
sanity.t TEST 25: set pool_size option no backlog option - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:connected to mysql
)'
sanity.t TEST 25: set pool_size option no backlog option - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:16 [error] 20512\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 25: set pool_size option no backlog option - status code ok got: '500'
expected: '200'
sanity.t TEST 25: set pool_size option no backlog option - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:connected to mysql
)'
sanity.t TEST 25: set pool_size option no backlog option - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:16 [error] 20512\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
sanity.t TEST 25: set pool_size option no backlog option - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:16 [error] 20512\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:74):5: attempt to index upvalue 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:74): in function 'mysql_conn'
content_by_lua(nginx.conf:74):24: in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:16 [debug] 20512\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:16 [debug] 20512\#0: *2 lua deleting light thread
2020/10/18 03:32:16 [debug] 20512\#0: *2 lua caching unused lua thread 00007FBB5A6E8248 (ref 1)
2020/10/18 03:32:16 [debug] 20512\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:16 [debug] 20512\#0: *2 http special response: 500, "/t?"
'
sanity.t TEST 26: set the pool_size and backlog options at the same time - status code ok got: '500'
expected: '200'
sanity.t TEST 26: set the pool_size and backlog options at the same time - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:failed to connect: too many waiting connect operations
failed to connect: too many waiting connect operations
failed to connect: too many waiting connect operations
failed to connect: too many waiting connect operations
failed to connect: too many waiting connect operations
failed to connect: timeout
failed to connect: timeout
failed to connect: timeout
failed to connect: timeout
failed to connect: timeout
)'
sanity.t TEST 26: set the pool_size and backlog options at the same time - pattern "lua tcp socket queued connect timed out" should match a line in error.log (req 0)
sanity.t TEST 26: set the pool_size and backlog options at the same time - response_body_like - response is expected () ''
doesn't match '(?^s:failed to connect: too many waiting connect operations
failed to connect: too many waiting connect operations
failed to connect: too many waiting connect operations
failed to connect: too many waiting connect operations
failed to connect: too many waiting connect operations
failed to connect: timeout
failed to connect: timeout
failed to connect: timeout
failed to connect: timeout
failed to connect: timeout
)'
sanity.t TEST 26: set the pool_size and backlog options at the same time - pattern "lua tcp socket queued connect timed out" should match a line in error.log (req 1)
TEST 1: send query w/o result set - status code ok got: '500'
expected: '200'
TEST 1: send query w/o result set - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql \d\.[^\s\x00]+\.
sent 30 bytes\.
result: \{"affected_rows":0,"insert_id":0,"server_status":2,"warning_count":[01]\}$)'
TEST 1: send query w/o result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:16 [error] 20521\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 0) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
TEST 1: send query w/o result set - status code ok got: '500'
expected: '200'
TEST 1: send query w/o result set - response_body_like - response is expected (<html> <head><title>500 Internal Server Error</title></head> <body> <center><h1>500 Internal Server Error</h1></center> <hr><center>nginx/1.19.3 (no pool)</center> </body> </html>) '<html>
<head><title>500 Internal Server Error</title></head>
<body>
<center><h1>500 Internal Server Error</h1></center>
<hr><center>nginx/1.19.3 (no pool)</center>
</body>
</html>
'
doesn't match '(?^s:^connected to mysql \d\.[^\s\x00]+\.
sent 30 bytes\.
result: \{"affected_rows":0,"insert_id":0,"server_status":2,"warning_count":[01]\}$)'
TEST 1: send query w/o result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:16 [error] 20521\#0: *1 lua entry thread aborted: runtime error: /home/ec2-user/git/lua-resty-mysql/lib/resty/mysql.lua:5: module 'resty.sha256' not found:" (req 1) no field package.preload['resty.sha256']
no file '/home/ec2-user/git/lua-resty-mysql/lib/resty/sha256.lua'
no file '/home/ec2-user/git/lua-resty-mysql/t/lib/resty/sha256.lua'
no file '../lua-resty-core/lib/resty/sha256.lua'
no file '../lua-resty-lrucache/lib/resty/sha256.lua'
no file './resty/sha256.lua'
no file '/opt/luajit/share/luajit-2.1.0-beta3/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256.lua'
no file '/usr/local/share/lua/5.1/resty/sha256/init.lua'
'
TEST 1: send query w/o result set - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:32:16 [error] 20521\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:86):3: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:86): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:32:16 [debug] 20521\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:32:16 [debug] 20521\#0: *2 lua deleting light thread
2020/10/18 03:32:16 [debug] 20521\#0: *2 lua caching unused lua thread 00007F5B28F03750 (ref 1)
2020/10/18 03:32:16 [debug] 20521\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:32:16 [debug] 20521\#0: *2 http special response: 500, "/t?"
2020/10/18 03:32:16 [debug] 20521\#0: *2 http set discard body
'
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
nginx: [emerg] SSL_CTX_load_verify_locations("/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt") failed (SSL: error:02001002:system library:fopen:No such file or directory:fopen('/home/ec2-user/git/lua-resty-mysql/t/servroot/conf/../../data/test.crt','r') error:2006D080:BIO routines:BIO_new_file:no such file error:0B084002:x509 certificate routines:X509_load_cert_crl_file:system lib)
Bailout called. Further testing stopped: TEST 2: send query w/o result set (verify) - Cannot start nginx using command "nginx -p /home/ec2-user/git/lua-resty-mysql/t/servroot/ -c /home/ec2-user/git/lua-resty-mysql/t/servroot/conf/nginx.conf > /dev/null" (status code 256).

Expected Failures

(none)

Warnings

(none)

Go back to the index page.