(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 (w)

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:21:24 [error] 15640\#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:21:24 [error] 15640\#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:21:24 [error] 15640\#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:21:24 [debug] 15640\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:24 [debug] 15640\#0: *2 lua deleting light thread
2020/10/18 03:21:24 [debug] 15640\#0: *2 lua caching unused lua thread 00007FEE20CB6A50 (ref 1)
2020/10/18 03:21:24 [debug] 15640\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:24 [debug] 15640\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:24 [debug] 15640\#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:21:24 [error] 15640\#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:21:24 [error] 15640\#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:21:24 [debug] 15640\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:24 [debug] 15640\#0: *2 lua deleting light thread
2020/10/18 03:21:24 [debug] 15640\#0: *2 lua caching unused lua thread 00007FEE20CB6A50 (ref 1)
2020/10/18 03:21:24 [debug] 15640\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:24 [debug] 15640\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:24 [debug] 15640\#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:21:24 [error] 15640\#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:21:24 [debug] 15640\#0: *3 lua request cleanup: forcible=0
2020/10/18 03:21:24 [debug] 15640\#0: *3 lua deleting light thread
2020/10/18 03:21:24 [debug] 15640\#0: *3 lua caching unused lua thread 00007FEE20CB6A50 (ref 1)
2020/10/18 03:21:24 [debug] 15640\#0: *3 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:24 [debug] 15640\#0: *3 http special response: 500, "/t?"
2020/10/18 03:21:24 [debug] 15640\#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:21:24 [error] 15640\#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:21:24 [error] 15640\#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:21:24 [debug] 15640\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:24 [debug] 15640\#0: *2 lua deleting light thread
2020/10/18 03:21:24 [debug] 15640\#0: *2 lua caching unused lua thread 00007FEE20CB6A50 (ref 1)
2020/10/18 03:21:24 [debug] 15640\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:24 [debug] 15640\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:24 [debug] 15640\#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:21:24 [error] 15640\#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:21:24 [debug] 15640\#0: *3 lua request cleanup: forcible=0
2020/10/18 03:21:24 [debug] 15640\#0: *3 lua deleting light thread
2020/10/18 03:21:24 [debug] 15640\#0: *3 lua caching unused lua thread 00007FEE20CB6A50 (ref 1)
2020/10/18 03:21:24 [debug] 15640\#0: *3 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:24 [debug] 15640\#0: *3 http special response: 500, "/t?"
2020/10/18 03:21:24 [debug] 15640\#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:21:25 [error] 15640\#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:21:25 [debug] 15640\#0: *4 lua request cleanup: forcible=0
2020/10/18 03:21:25 [debug] 15640\#0: *4 lua deleting light thread
2020/10/18 03:21:25 [debug] 15640\#0: *4 lua caching unused lua thread 00007FEE20CB6A50 (ref 1)
2020/10/18 03:21:25 [debug] 15640\#0: *4 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:25 [debug] 15640\#0: *4 http special response: 500, "/t?"
2020/10/18 03:21:25 [debug] 15640\#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:21:24 [error] 15640\#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:21:24 [error] 15640\#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:21:24 [debug] 15640\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:24 [debug] 15640\#0: *2 lua deleting light thread
2020/10/18 03:21:24 [debug] 15640\#0: *2 lua caching unused lua thread 00007FEE20CB6A50 (ref 1)
2020/10/18 03:21:24 [debug] 15640\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:24 [debug] 15640\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:24 [debug] 15640\#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:21:24 [error] 15640\#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:21:24 [debug] 15640\#0: *3 lua request cleanup: forcible=0
2020/10/18 03:21:24 [debug] 15640\#0: *3 lua deleting light thread
2020/10/18 03:21:24 [debug] 15640\#0: *3 lua caching unused lua thread 00007FEE20CB6A50 (ref 1)
2020/10/18 03:21:24 [debug] 15640\#0: *3 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:24 [debug] 15640\#0: *3 http special response: 500, "/t?"
2020/10/18 03:21:24 [debug] 15640\#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:21:25 [error] 15640\#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:21:25 [debug] 15640\#0: *4 lua request cleanup: forcible=0
2020/10/18 03:21:25 [debug] 15640\#0: *4 lua deleting light thread
2020/10/18 03:21:25 [debug] 15640\#0: *4 lua caching unused lua thread 00007FEE20CB6A50 (ref 1)
2020/10/18 03:21:25 [debug] 15640\#0: *4 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:25 [debug] 15640\#0: *4 http special response: 500, "/t?"
2020/10/18 03:21:25 [debug] 15640\#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:21:25 [error] 15640\#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:21:25 [debug] 15640\#0: *5 lua request cleanup: forcible=0
2020/10/18 03:21:25 [debug] 15640\#0: *5 lua deleting light thread
2020/10/18 03:21:25 [debug] 15640\#0: *5 lua caching unused lua thread 00007FEE20CB6A50 (ref 1)
2020/10/18 03:21:25 [debug] 15640\#0: *5 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:25 [debug] 15640\#0: *5 http special response: 500, "/t?"
2020/10/18 03:21:25 [debug] 15640\#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:21:25 [error] 15647\#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:21:25 [error] 15647\#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:21:25 [error] 15647\#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:21:25 [debug] 15647\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:25 [debug] 15647\#0: *2 lua deleting light thread
2020/10/18 03:21:25 [debug] 15647\#0: *2 lua caching unused lua thread 00007F35E98B4008 (ref 1)
2020/10/18 03:21:25 [debug] 15647\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:25 [debug] 15647\#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:21:25 [error] 15653\#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:21:25 [error] 15653\#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:21:25 [error] 15653\#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:21:25 [debug] 15653\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:25 [debug] 15653\#0: *2 lua deleting light thread
2020/10/18 03:21:25 [debug] 15653\#0: *2 lua caching unused lua thread 00007FF8971D8DC8 (ref 1)
2020/10/18 03:21:25 [debug] 15653\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:25 [debug] 15653\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:25 [debug] 15653\#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:21:25 [error] 15656\#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:21:25 [error] 15656\#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:21:26 [error] 15656\#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:21:26 [debug] 15656\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:26 [debug] 15656\#0: *2 lua deleting light thread
2020/10/18 03:21:26 [debug] 15656\#0: *2 lua caching unused lua thread 00007F1C700A40D0 (ref 1)
2020/10/18 03:21:26 [debug] 15656\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:26 [debug] 15656\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:26 [debug] 15656\#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:21:26 [error] 15659\#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:21:26 [error] 15659\#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:21:26 [error] 15659\#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:21:26 [debug] 15659\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:26 [debug] 15659\#0: *2 lua deleting light thread
2020/10/18 03:21:26 [debug] 15659\#0: *2 lua caching unused lua thread 00007FA19F15F050 (ref 1)
2020/10/18 03:21:26 [debug] 15659\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:26 [debug] 15659\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:26 [debug] 15659\#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:21:26 [error] 15665\#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:21:26 [error] 15665\#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:21:26 [debug] 15665\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:26 [debug] 15665\#0: *2 lua deleting light thread
2020/10/18 03:21:26 [debug] 15665\#0: *2 lua caching unused lua thread 00007F5B995ADED0 (ref 1)
2020/10/18 03:21:26 [debug] 15665\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:26 [debug] 15665\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:26 [debug] 15665\#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:21:26 [error] 15668\#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:21:26 [error] 15668\#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:21:26 [debug] 15668\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:26 [debug] 15668\#0: *2 lua deleting light thread
2020/10/18 03:21:26 [debug] 15668\#0: *2 lua caching unused lua thread 00007FA281344008 (ref 1)
2020/10/18 03:21:26 [debug] 15668\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:26 [debug] 15668\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:26 [debug] 15668\#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:21:26 [error] 15671\#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:21:26 [error] 15671\#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:21:26 [debug] 15671\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:26 [debug] 15671\#0: *2 lua deleting light thread
2020/10/18 03:21:26 [debug] 15671\#0: *2 lua caching unused lua thread 00007F350C002F40 (ref 1)
2020/10/18 03:21:26 [debug] 15671\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:26 [debug] 15671\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:26 [debug] 15671\#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:21:27 [error] 15674\#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:21:27 [error] 15674\#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:21:27 [debug] 15674\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:27 [debug] 15674\#0: *2 lua deleting light thread
2020/10/18 03:21:27 [debug] 15674\#0: *2 lua caching unused lua thread 00007FA7CF90E2D0 (ref 1)
2020/10/18 03:21:27 [debug] 15674\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:27 [debug] 15674\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:27 [debug] 15674\#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:21:27 [error] 15680\#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:21:27 [error] 15680\#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:21:27 [error] 15680\#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:21:27 [debug] 15680\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:27 [debug] 15680\#0: *2 lua deleting light thread
2020/10/18 03:21:27 [debug] 15680\#0: *2 lua caching unused lua thread 00007F4BC4BC3210 (ref 1)
2020/10/18 03:21:27 [debug] 15680\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:27 [debug] 15680\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:27 [debug] 15680\#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:21:27 [error] 15683\#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:21:27 [error] 15683\#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:21:27 [error] 15683\#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:21:27 [debug] 15683\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:27 [debug] 15683\#0: *2 lua deleting light thread
2020/10/18 03:21:27 [debug] 15683\#0: *2 lua caching unused lua thread 00007F0E25CFB238 (ref 1)
2020/10/18 03:21:27 [debug] 15683\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:27 [debug] 15683\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:27 [debug] 15683\#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:21:27 [error] 15686\#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:21:27 [error] 15686\#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:21:27 [error] 15686\#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:21:27 [debug] 15686\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:27 [debug] 15686\#0: *2 lua deleting light thread
2020/10/18 03:21:27 [debug] 15686\#0: *2 lua caching unused lua thread 00007FAAA85761D0 (ref 1)
2020/10/18 03:21:27 [debug] 15686\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:27 [debug] 15686\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:27 [debug] 15686\#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:21:27 [error] 15689\#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:21:27 [error] 15689\#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:21:28 [error] 15689\#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:21:28 [debug] 15689\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:28 [debug] 15689\#0: *2 lua deleting light thread
2020/10/18 03:21:28 [debug] 15689\#0: *2 lua caching unused lua thread 00007F986522ECF8 (ref 1)
2020/10/18 03:21:28 [debug] 15689\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:28 [debug] 15689\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:28 [debug] 15689\#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:21:28 [error] 15692\#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:21:28 [error] 15692\#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:21:28 [error] 15692\#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:21:28 [debug] 15692\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:28 [debug] 15692\#0: *2 lua deleting light thread
2020/10/18 03:21:28 [debug] 15692\#0: *2 lua caching unused lua thread 00007FB76209F750 (ref 1)
2020/10/18 03:21:28 [debug] 15692\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:28 [debug] 15692\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:28 [debug] 15692\#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:21:28 [error] 15695\#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:21:28 [error] 15695\#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:21:28 [error] 15695\#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:21:28 [debug] 15695\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:28 [debug] 15695\#0: *2 lua deleting light thread
2020/10/18 03:21:28 [debug] 15695\#0: *2 lua caching unused lua thread 00007F7A1A2DDFF8 (ref 1)
2020/10/18 03:21:28 [debug] 15695\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:28 [debug] 15695\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:28 [debug] 15695\#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:21:28 [error] 15698\#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:21:28 [error] 15698\#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:21:28 [error] 15698\#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:21:28 [debug] 15698\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:28 [debug] 15698\#0: *2 lua deleting light thread
2020/10/18 03:21:28 [debug] 15698\#0: *2 lua caching unused lua thread 00007FF306CF1598 (ref 1)
2020/10/18 03:21:28 [debug] 15698\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:28 [debug] 15698\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:28 [debug] 15698\#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:21:28 [error] 15701\#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:21:28 [error] 15701\#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:21:28 [error] 15701\#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:21:28 [debug] 15701\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:28 [debug] 15701\#0: *2 lua deleting light thread
2020/10/18 03:21:28 [debug] 15701\#0: *2 lua caching unused lua thread 00007FB6FB247250 (ref 1)
2020/10/18 03:21:28 [debug] 15701\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:28 [debug] 15701\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:28 [debug] 15701\#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:21:29 [error] 15704\#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:21:29 [error] 15704\#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:21:29 [error] 15704\#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:21:29 [debug] 15704\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:29 [debug] 15704\#0: *2 lua deleting light thread
2020/10/18 03:21:29 [debug] 15704\#0: *2 lua caching unused lua thread 00007F971B7AA248 (ref 1)
2020/10/18 03:21:29 [debug] 15704\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:29 [debug] 15704\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:29 [debug] 15704\#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:21:29 [error] 15707\#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:21:29 [error] 15707\#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:21:29 [error] 15707\#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:21:29 [debug] 15707\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:29 [debug] 15707\#0: *2 lua deleting light thread
2020/10/18 03:21:29 [debug] 15707\#0: *2 lua caching unused lua thread 00007F2E047D76C0 (ref 1)
2020/10/18 03:21:29 [debug] 15707\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:29 [debug] 15707\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:29 [debug] 15707\#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:21:29 [error] 15710\#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:21:29 [error] 15710\#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:21:29 [error] 15710\#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:21:29 [debug] 15710\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:29 [debug] 15710\#0: *2 lua deleting light thread
2020/10/18 03:21:29 [debug] 15710\#0: *2 lua caching unused lua thread 00007F5869639020 (ref 1)
2020/10/18 03:21:29 [debug] 15710\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:29 [debug] 15710\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:29 [debug] 15710\#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:21:29 [error] 15713\#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:21:29 [error] 15713\#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:21:30 [error] 15713\#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:21:30 [debug] 15713\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:30 [debug] 15713\#0: *2 lua deleting light thread
2020/10/18 03:21:30 [debug] 15713\#0: *2 lua caching unused lua thread 00007F3B781E04E8 (ref 1)
2020/10/18 03:21:30 [debug] 15713\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:30 [debug] 15713\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:30 [debug] 15713\#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:21:30 [error] 15716\#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:21:30 [error] 15716\#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:21:30 [error] 15716\#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:21:30 [debug] 15716\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:30 [debug] 15716\#0: *2 lua deleting light thread
2020/10/18 03:21:30 [debug] 15716\#0: *2 lua caching unused lua thread 00007FB154993248 (ref 1)
2020/10/18 03:21:30 [debug] 15716\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:30 [debug] 15716\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:30 [debug] 15716\#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:21:30 [error] 15719\#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:21:30 [error] 15719\#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:21:30 [error] 15719\#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:21:30 [debug] 15719\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:30 [debug] 15719\#0: *2 lua deleting light thread
2020/10/18 03:21:30 [debug] 15719\#0: *2 lua caching unused lua thread 00007FEFB059F500 (ref 1)
2020/10/18 03:21:30 [debug] 15719\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:30 [debug] 15719\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:30 [debug] 15719\#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:21:30 [error] 15722\#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:21:30 [error] 15722\#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:21:31 [error] 15722\#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:21:31 [debug] 15722\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:31 [debug] 15722\#0: *2 lua deleting light thread
2020/10/18 03:21:31 [debug] 15722\#0: *2 lua caching unused lua thread 00007F47BEE46080 (ref 1)
2020/10/18 03:21:31 [debug] 15722\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:31 [debug] 15722\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:31 [debug] 15722\#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:21:31 [error] 15725\#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:21:31 [error] 15725\#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:21:32 [error] 15725\#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:21:32 [debug] 15725\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:32 [debug] 15725\#0: *2 lua deleting light thread
2020/10/18 03:21:32 [debug] 15725\#0: *2 lua caching unused lua thread 00007FB14AA1F048 (ref 1)
2020/10/18 03:21:32 [debug] 15725\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:32 [debug] 15725\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:32 [debug] 15725\#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:21:32 [error] 15728\#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:21:32 [error] 15728\#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:21:32 [error] 15728\#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:21:32 [debug] 15728\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:32 [debug] 15728\#0: *2 lua deleting light thread
2020/10/18 03:21:32 [debug] 15728\#0: *2 lua caching unused lua thread 00007F705A6E4FA0 (ref 1)
2020/10/18 03:21:32 [debug] 15728\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:32 [debug] 15728\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:32 [debug] 15728\#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:21:33 [error] 15731\#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:21:33 [error] 15731\#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:21:33 [error] 15731\#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:21:33 [debug] 15731\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:33 [debug] 15731\#0: *2 lua deleting light thread
2020/10/18 03:21:33 [debug] 15731\#0: *2 lua caching unused lua thread 00007FF523221248 (ref 1)
2020/10/18 03:21:33 [debug] 15731\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:33 [debug] 15731\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:33 [debug] 15731\#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:21:33 [error] 15734\#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:21:33 [error] 15734\#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:21:33 [error] 15734\#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:21:33 [debug] 15734\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:33 [debug] 15734\#0: *2 lua deleting light thread
2020/10/18 03:21:33 [debug] 15734\#0: *2 lua caching unused lua thread 00007FDE2D981128 (ref 1)
2020/10/18 03:21:33 [debug] 15734\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:33 [debug] 15734\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:33 [debug] 15734\#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:21:33 [error] 15737\#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:21:33 [error] 15737\#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:21:33 [error] 15737\#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:21:33 [debug] 15737\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:33 [debug] 15737\#0: *2 lua deleting light thread
2020/10/18 03:21:33 [debug] 15737\#0: *2 lua caching unused lua thread 00007F8CBAEE0088 (ref 1)
2020/10/18 03:21:33 [debug] 15737\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:33 [debug] 15737\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:33 [debug] 15737\#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:21:33 [error] 15740\#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:21:33 [error] 15740\#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:21:34 [error] 15740\#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:21:34 [debug] 15740\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:34 [debug] 15740\#0: *2 lua deleting light thread
2020/10/18 03:21:34 [debug] 15740\#0: *2 lua caching unused lua thread 00007F8980D5EFD8 (ref 1)
2020/10/18 03:21:34 [debug] 15740\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:34 [debug] 15740\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:34 [debug] 15740\#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:21:34 [error] 15743\#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:21:34 [error] 15743\#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:21:34 [error] 15743\#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:21:34 [debug] 15743\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:34 [debug] 15743\#0: *2 lua deleting light thread
2020/10/18 03:21:34 [debug] 15743\#0: *2 lua caching unused lua thread 00007F5C81422F58 (ref 1)
2020/10/18 03:21:34 [debug] 15743\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:34 [debug] 15743\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:34 [debug] 15743\#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:21:34 [error] 15746\#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:21:34 [error] 15746\#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:21:34 [error] 15746\#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:21:34 [debug] 15746\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:34 [debug] 15746\#0: *2 lua deleting light thread
2020/10/18 03:21:34 [debug] 15746\#0: *2 lua caching unused lua thread 00007FFA9E9F6220 (ref 1)
2020/10/18 03:21:34 [debug] 15746\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:34 [debug] 15746\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:34 [debug] 15746\#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:21:34 [error] 15749\#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:21:34 [error] 15749\#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:21:34 [error] 15749\#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:21:34 [debug] 15749\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:34 [debug] 15749\#0: *2 lua deleting light thread
2020/10/18 03:21:34 [debug] 15749\#0: *2 lua caching unused lua thread 00007FA84E602238 (ref 1)
2020/10/18 03:21:34 [debug] 15749\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:34 [debug] 15749\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:34 [debug] 15749\#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:21:34 [error] 15752\#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:21:34 [error] 15752\#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:21:34 [error] 15752\#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:21:34 [debug] 15752\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:34 [debug] 15752\#0: *2 lua deleting light thread
2020/10/18 03:21:34 [debug] 15752\#0: *2 lua caching unused lua thread 00007FE5B49402E8 (ref 1)
2020/10/18 03:21:34 [debug] 15752\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:34 [debug] 15752\#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:21:35 [error] 15761\#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:21:35 [error] 15761\#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:21:35 [error] 15761\#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:21:35 [debug] 15761\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:21:35 [debug] 15761\#0: *2 lua deleting light thread
2020/10/18 03:21:35 [debug] 15761\#0: *2 lua caching unused lua thread 00007F47314B8008 (ref 1)
2020/10/18 03:21:35 [debug] 15761\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:21:35 [debug] 15761\#0: *2 http special response: 500, "/t?"
2020/10/18 03:21:35 [debug] 15761\#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.