(This page was automatically generated by the tools in the opsboy project on 09:46:46 03-Nov-2020 GMT.)

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

Summary

Commit Testing Time Unexpected
Failures
Expected
Failures
Files Tests Elapsed Time
82059c13 2020-10-18 03:12:29 GMT 290 8 10 302 89 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:19:07 [error] 7434\#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-sysm/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:19:07 [error] 7434\#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-sysm/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:19:07 [error] 7434\#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:19:07 [debug] 7434\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:07 [debug] 7434\#0: *2 lua deleting light thread
2020/10/18 03:19:07 [debug] 7434\#0: *2 lua caching unused lua thread 0000000008917500 (ref 1)
2020/10/18 03:19:07 [debug] 7434\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:07 [debug] 7434\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:07 [debug] 7434\#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:19:07 [error] 7434\#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-sysm/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:19:07 [error] 7434\#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:19:07 [debug] 7434\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:07 [debug] 7434\#0: *2 lua deleting light thread
2020/10/18 03:19:07 [debug] 7434\#0: *2 lua caching unused lua thread 0000000008917500 (ref 1)
2020/10/18 03:19:07 [debug] 7434\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:07 [debug] 7434\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:07 [debug] 7434\#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:19:07 [error] 7434\#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:19:07 [debug] 7434\#0: *3 lua request cleanup: forcible=0
2020/10/18 03:19:07 [debug] 7434\#0: *3 lua deleting light thread
2020/10/18 03:19:07 [debug] 7434\#0: *3 lua caching unused lua thread 0000000008917500 (ref 1)
2020/10/18 03:19:07 [debug] 7434\#0: *3 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:07 [debug] 7434\#0: *3 http special response: 500, "/t?"
2020/10/18 03:19:07 [debug] 7434\#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:19:07 [error] 7434\#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-sysm/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:19:07 [error] 7434\#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:19:07 [debug] 7434\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:07 [debug] 7434\#0: *2 lua deleting light thread
2020/10/18 03:19:07 [debug] 7434\#0: *2 lua caching unused lua thread 0000000008917500 (ref 1)
2020/10/18 03:19:07 [debug] 7434\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:07 [debug] 7434\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:07 [debug] 7434\#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:19:07 [error] 7434\#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:19:07 [debug] 7434\#0: *3 lua request cleanup: forcible=0
2020/10/18 03:19:07 [debug] 7434\#0: *3 lua deleting light thread
2020/10/18 03:19:07 [debug] 7434\#0: *3 lua caching unused lua thread 0000000008917500 (ref 1)
2020/10/18 03:19:07 [debug] 7434\#0: *3 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:07 [debug] 7434\#0: *3 http special response: 500, "/t?"
2020/10/18 03:19:07 [debug] 7434\#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:19:07 [error] 7434\#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:19:07 [debug] 7434\#0: *4 lua request cleanup: forcible=0
2020/10/18 03:19:07 [debug] 7434\#0: *4 lua deleting light thread
2020/10/18 03:19:07 [debug] 7434\#0: *4 lua caching unused lua thread 0000000008917500 (ref 1)
2020/10/18 03:19:07 [debug] 7434\#0: *4 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:07 [debug] 7434\#0: *4 http special response: 500, "/t?"
2020/10/18 03:19:07 [debug] 7434\#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:19:07 [error] 7434\#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-sysm/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:19:07 [error] 7434\#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:19:07 [debug] 7434\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:07 [debug] 7434\#0: *2 lua deleting light thread
2020/10/18 03:19:07 [debug] 7434\#0: *2 lua caching unused lua thread 0000000008917500 (ref 1)
2020/10/18 03:19:07 [debug] 7434\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:07 [debug] 7434\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:07 [debug] 7434\#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:19:07 [error] 7434\#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:19:07 [debug] 7434\#0: *3 lua request cleanup: forcible=0
2020/10/18 03:19:07 [debug] 7434\#0: *3 lua deleting light thread
2020/10/18 03:19:07 [debug] 7434\#0: *3 lua caching unused lua thread 0000000008917500 (ref 1)
2020/10/18 03:19:07 [debug] 7434\#0: *3 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:07 [debug] 7434\#0: *3 http special response: 500, "/t?"
2020/10/18 03:19:07 [debug] 7434\#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:19:07 [error] 7434\#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:19:07 [debug] 7434\#0: *4 lua request cleanup: forcible=0
2020/10/18 03:19:07 [debug] 7434\#0: *4 lua deleting light thread
2020/10/18 03:19:07 [debug] 7434\#0: *4 lua caching unused lua thread 0000000008917500 (ref 1)
2020/10/18 03:19:07 [debug] 7434\#0: *4 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:07 [debug] 7434\#0: *4 http special response: 500, "/t?"
2020/10/18 03:19:07 [debug] 7434\#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:19:07 [error] 7434\#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:19:07 [debug] 7434\#0: *5 lua request cleanup: forcible=0
2020/10/18 03:19:07 [debug] 7434\#0: *5 lua deleting light thread
2020/10/18 03:19:07 [debug] 7434\#0: *5 lua caching unused lua thread 0000000008917500 (ref 1)
2020/10/18 03:19:07 [debug] 7434\#0: *5 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:07 [debug] 7434\#0: *5 http special response: 500, "/t?"
2020/10/18 03:19:07 [debug] 7434\#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:19:09 [error] 7439\#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-sysm/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:19:09 [error] 7439\#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-sysm/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:19:09 [error] 7439\#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:19:09 [debug] 7439\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:09 [debug] 7439\#0: *2 lua deleting light thread
2020/10/18 03:19:09 [debug] 7439\#0: *2 lua caching unused lua thread 000000000890A9A0 (ref 1)
2020/10/18 03:19:09 [debug] 7439\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:09 [debug] 7439\#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:19:11 [error] 7443\#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-sysm/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:19:11 [error] 7443\#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-sysm/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:19:12 [error] 7443\#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:19:12 [debug] 7443\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:12 [debug] 7443\#0: *2 lua deleting light thread
2020/10/18 03:19:12 [debug] 7443\#0: *2 lua caching unused lua thread 000000000890B360 (ref 1)
2020/10/18 03:19:12 [debug] 7443\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:12 [debug] 7443\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:12 [debug] 7443\#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:19:13 [error] 7444\#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-sysm/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:19:13 [error] 7444\#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-sysm/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:19:14 [error] 7444\#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:19:14 [debug] 7444\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:14 [debug] 7444\#0: *2 lua deleting light thread
2020/10/18 03:19:14 [debug] 7444\#0: *2 lua caching unused lua thread 000000000890B2D0 (ref 1)
2020/10/18 03:19:14 [debug] 7444\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:14 [debug] 7444\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:14 [debug] 7444\#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:19:16 [error] 7445\#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-sysm/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:19:16 [error] 7445\#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-sysm/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:19:16 [error] 7445\#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:19:16 [debug] 7445\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:16 [debug] 7445\#0: *2 lua deleting light thread
2020/10/18 03:19:16 [debug] 7445\#0: *2 lua caching unused lua thread 000000000890B330 (ref 1)
2020/10/18 03:19:16 [debug] 7445\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:16 [debug] 7445\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:16 [debug] 7445\#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:19:18 [error] 7449\#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-sysm/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:19:18 [error] 7449\#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:19:18 [debug] 7449\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:18 [debug] 7449\#0: *2 lua deleting light thread
2020/10/18 03:19:18 [debug] 7449\#0: *2 lua caching unused lua thread 0000000008908700 (ref 1)
2020/10/18 03:19:18 [debug] 7449\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:18 [debug] 7449\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:18 [debug] 7449\#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:19:20 [error] 7450\#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-sysm/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:19:20 [error] 7450\#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:19:20 [debug] 7450\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:20 [debug] 7450\#0: *2 lua deleting light thread
2020/10/18 03:19:20 [debug] 7450\#0: *2 lua caching unused lua thread 0000000008909AA0 (ref 1)
2020/10/18 03:19:20 [debug] 7450\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:20 [debug] 7450\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:20 [debug] 7450\#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:19:22 [error] 7451\#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-sysm/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:19:22 [error] 7451\#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:19:22 [debug] 7451\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:22 [debug] 7451\#0: *2 lua deleting light thread
2020/10/18 03:19:22 [debug] 7451\#0: *2 lua caching unused lua thread 0000000008909470 (ref 1)
2020/10/18 03:19:22 [debug] 7451\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:22 [debug] 7451\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:22 [debug] 7451\#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:19:24 [error] 7452\#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-sysm/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:19:24 [error] 7452\#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:19:24 [debug] 7452\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:24 [debug] 7452\#0: *2 lua deleting light thread
2020/10/18 03:19:24 [debug] 7452\#0: *2 lua caching unused lua thread 0000000008909B90 (ref 1)
2020/10/18 03:19:24 [debug] 7452\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:24 [debug] 7452\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:24 [debug] 7452\#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:19:26 [error] 7456\#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-sysm/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:19:26 [error] 7456\#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-sysm/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:19:26 [error] 7456\#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:19:26 [debug] 7456\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:26 [debug] 7456\#0: *2 lua deleting light thread
2020/10/18 03:19:26 [debug] 7456\#0: *2 lua caching unused lua thread 00000000089069A0 (ref 1)
2020/10/18 03:19:26 [debug] 7456\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:26 [debug] 7456\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:26 [debug] 7456\#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:19:28 [error] 7457\#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-sysm/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:19:28 [error] 7457\#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-sysm/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:19:29 [error] 7457\#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:19:29 [debug] 7457\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:29 [debug] 7457\#0: *2 lua deleting light thread
2020/10/18 03:19:29 [debug] 7457\#0: *2 lua caching unused lua thread 00000000089069A0 (ref 1)
2020/10/18 03:19:29 [debug] 7457\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:29 [debug] 7457\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:29 [debug] 7457\#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:19:31 [error] 7458\#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-sysm/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:19:31 [error] 7458\#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-sysm/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:19:31 [error] 7458\#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:19:31 [debug] 7458\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:31 [debug] 7458\#0: *2 lua deleting light thread
2020/10/18 03:19:31 [debug] 7458\#0: *2 lua caching unused lua thread 0000000008907380 (ref 1)
2020/10/18 03:19:31 [debug] 7458\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:31 [debug] 7458\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:31 [debug] 7458\#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:19:33 [error] 7459\#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-sysm/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:19:33 [error] 7459\#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-sysm/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:19:33 [error] 7459\#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:19:33 [debug] 7459\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:33 [debug] 7459\#0: *2 lua deleting light thread
2020/10/18 03:19:33 [debug] 7459\#0: *2 lua caching unused lua thread 0000000008908530 (ref 1)
2020/10/18 03:19:33 [debug] 7459\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:33 [debug] 7459\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:33 [debug] 7459\#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:19:35 [error] 7460\#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-sysm/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:19:35 [error] 7460\#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-sysm/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:19:35 [error] 7460\#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:19:35 [debug] 7460\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:35 [debug] 7460\#0: *2 lua deleting light thread
2020/10/18 03:19:35 [debug] 7460\#0: *2 lua caching unused lua thread 00000000089086C0 (ref 1)
2020/10/18 03:19:35 [debug] 7460\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:35 [debug] 7460\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:35 [debug] 7460\#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:19:37 [error] 7461\#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-sysm/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:19:37 [error] 7461\#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-sysm/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:19:37 [error] 7461\#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:19:37 [debug] 7461\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:37 [debug] 7461\#0: *2 lua deleting light thread
2020/10/18 03:19:37 [debug] 7461\#0: *2 lua caching unused lua thread 0000000008909A90 (ref 1)
2020/10/18 03:19:37 [debug] 7461\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:37 [debug] 7461\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:37 [debug] 7461\#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:19:39 [error] 7462\#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-sysm/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:19:39 [error] 7462\#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-sysm/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:19:39 [error] 7462\#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:19:39 [debug] 7462\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:39 [debug] 7462\#0: *2 lua deleting light thread
2020/10/18 03:19:39 [debug] 7462\#0: *2 lua caching unused lua thread 0000000008909440 (ref 1)
2020/10/18 03:19:39 [debug] 7462\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:39 [debug] 7462\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:39 [debug] 7462\#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:19:41 [error] 7463\#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-sysm/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:19:41 [error] 7463\#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-sysm/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:19:41 [error] 7463\#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:19:41 [debug] 7463\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:41 [debug] 7463\#0: *2 lua deleting light thread
2020/10/18 03:19:41 [debug] 7463\#0: *2 lua caching unused lua thread 0000000008909E00 (ref 1)
2020/10/18 03:19:41 [debug] 7463\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:41 [debug] 7463\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:41 [debug] 7463\#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:19:43 [error] 7464\#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-sysm/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:19:43 [error] 7464\#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-sysm/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:19:43 [error] 7464\#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:19:43 [debug] 7464\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:43 [debug] 7464\#0: *2 lua deleting light thread
2020/10/18 03:19:43 [debug] 7464\#0: *2 lua caching unused lua thread 0000000008909620 (ref 1)
2020/10/18 03:19:43 [debug] 7464\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:43 [debug] 7464\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:43 [debug] 7464\#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 - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:19:45 [error] 7465\#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-sysm/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 - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:19:45 [error] 7465\#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-sysm/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:19:45 [error] 7465\#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:19:45 [debug] 7465\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:45 [debug] 7465\#0: *2 lua deleting light thread
2020/10/18 03:19:45 [debug] 7465\#0: *2 lua caching unused lua thread 0000000008909E40 (ref 1)
2020/10/18 03:19:45 [debug] 7465\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:45 [debug] 7465\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:45 [debug] 7465\#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:19:47 [error] 7466\#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-sysm/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:19:47 [error] 7466\#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-sysm/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:19:47 [error] 7466\#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:19:47 [debug] 7466\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:47 [debug] 7466\#0: *2 lua deleting light thread
2020/10/18 03:19:47 [debug] 7466\#0: *2 lua caching unused lua thread 0000000008909BA0 (ref 1)
2020/10/18 03:19:47 [debug] 7466\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:47 [debug] 7466\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:47 [debug] 7466\#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:19:49 [error] 7467\#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-sysm/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:19:49 [error] 7467\#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-sysm/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:19:50 [error] 7467\#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:19:50 [debug] 7467\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:50 [debug] 7467\#0: *2 lua deleting light thread
2020/10/18 03:19:50 [debug] 7467\#0: *2 lua caching unused lua thread 0000000008908A70 (ref 1)
2020/10/18 03:19:50 [debug] 7467\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:50 [debug] 7467\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:50 [debug] 7467\#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:19:52 [error] 7468\#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-sysm/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:19:52 [error] 7468\#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-sysm/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:19:52 [error] 7468\#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:19:52 [debug] 7468\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:52 [debug] 7468\#0: *2 lua deleting light thread
2020/10/18 03:19:52 [debug] 7468\#0: *2 lua caching unused lua thread 0000000008908480 (ref 1)
2020/10/18 03:19:52 [debug] 7468\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:52 [debug] 7468\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:52 [debug] 7468\#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:19:54 [error] 7469\#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-sysm/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:19:54 [error] 7469\#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-sysm/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:19:54 [error] 7469\#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:19:54 [debug] 7469\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:54 [debug] 7469\#0: *2 lua deleting light thread
2020/10/18 03:19:54 [debug] 7469\#0: *2 lua caching unused lua thread 0000000008909A60 (ref 1)
2020/10/18 03:19:54 [debug] 7469\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:54 [debug] 7469\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:54 [debug] 7469\#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:19:56 [error] 7470\#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-sysm/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:19:56 [error] 7470\#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-sysm/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:19:57 [error] 7470\#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:19:57 [debug] 7470\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:57 [debug] 7470\#0: *2 lua deleting light thread
2020/10/18 03:19:57 [debug] 7470\#0: *2 lua caching unused lua thread 0000000008908720 (ref 1)
2020/10/18 03:19:57 [debug] 7470\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:57 [debug] 7470\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:57 [debug] 7470\#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:19:59 [error] 7471\#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-sysm/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:19:59 [error] 7471\#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-sysm/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:19:59 [error] 7471\#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:19:59 [debug] 7471\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:19:59 [debug] 7471\#0: *2 lua deleting light thread
2020/10/18 03:19:59 [debug] 7471\#0: *2 lua caching unused lua thread 0000000008908B70 (ref 1)
2020/10/18 03:19:59 [debug] 7471\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:19:59 [debug] 7471\#0: *2 http special response: 500, "/t?"
2020/10/18 03:19:59 [debug] 7471\#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:20:02 [error] 7472\#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-sysm/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:20:02 [error] 7472\#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-sysm/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:20:02 [error] 7472\#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:20:02 [debug] 7472\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:20:02 [debug] 7472\#0: *2 lua deleting light thread
2020/10/18 03:20:02 [debug] 7472\#0: *2 lua caching unused lua thread 0000000008908B30 (ref 1)
2020/10/18 03:20:02 [debug] 7472\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:20:02 [debug] 7472\#0: *2 http special response: 500, "/t?"
2020/10/18 03:20:02 [debug] 7472\#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:20:04 [error] 7473\#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-sysm/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:20:04 [error] 7473\#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-sysm/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:20:04 [error] 7473\#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:20:04 [debug] 7473\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:20:04 [debug] 7473\#0: *2 lua deleting light thread
2020/10/18 03:20:04 [debug] 7473\#0: *2 lua caching unused lua thread 0000000008908A80 (ref 1)
2020/10/18 03:20:04 [debug] 7473\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:20:04 [debug] 7473\#0: *2 http special response: 500, "/t?"
2020/10/18 03:20:04 [debug] 7473\#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:20:06 [error] 7474\#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-sysm/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:20:06 [error] 7474\#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-sysm/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:20:06 [error] 7474\#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:20:06 [debug] 7474\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:20:06 [debug] 7474\#0: *2 lua deleting light thread
2020/10/18 03:20:06 [debug] 7474\#0: *2 lua caching unused lua thread 000000000890B9E0 (ref 1)
2020/10/18 03:20:06 [debug] 7474\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:20:06 [debug] 7474\#0: *2 http special response: 500, "/t?"
2020/10/18 03:20:06 [debug] 7474\#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:20:08 [error] 7475\#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-sysm/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:20:08 [error] 7475\#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-sysm/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:20:09 [error] 7475\#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:20:09 [debug] 7475\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:20:09 [debug] 7475\#0: *2 lua deleting light thread
2020/10/18 03:20:09 [debug] 7475\#0: *2 lua caching unused lua thread 000000000890BFF0 (ref 1)
2020/10/18 03:20:09 [debug] 7475\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:20:09 [debug] 7475\#0: *2 http special response: 500, "/t?"
2020/10/18 03:20:09 [debug] 7475\#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:20:10 [error] 7476\#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-sysm/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:20:10 [error] 7476\#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-sysm/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:20:11 [error] 7476\#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:20:11 [debug] 7476\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:20:11 [debug] 7476\#0: *2 lua deleting light thread
2020/10/18 03:20:11 [debug] 7476\#0: *2 lua caching unused lua thread 000000000890BFE0 (ref 1)
2020/10/18 03:20:11 [debug] 7476\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:20:11 [debug] 7476\#0: *2 http special response: 500, "/t?"
2020/10/18 03:20:11 [debug] 7476\#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:20:13 [error] 7477\#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-sysm/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:20:13 [error] 7477\#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-sysm/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:20:13 [error] 7477\#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:20:13 [debug] 7477\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:20:13 [debug] 7477\#0: *2 lua deleting light thread
2020/10/18 03:20:13 [debug] 7477\#0: *2 lua caching unused lua thread 000000000890C070 (ref 1)
2020/10/18 03:20:13 [debug] 7477\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:20:13 [debug] 7477\#0: *2 http special response: 500, "/t?"
2020/10/18 03:20:13 [debug] 7477\#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:20:15 [error] 7478\#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-sysm/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:20:15 [error] 7478\#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-sysm/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:20:15 [error] 7478\#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:20:15 [debug] 7478\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:20:15 [debug] 7478\#0: *2 lua deleting light thread
2020/10/18 03:20:15 [debug] 7478\#0: *2 lua caching unused lua thread 000000000890C0F0 (ref 1)
2020/10/18 03:20:15 [debug] 7478\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:20:15 [debug] 7478\#0: *2 http special response: 500, "/t?"
2020/10/18 03:20:15 [debug] 7478\#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:20:17 [error] 7479\#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-sysm/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:20:17 [error] 7479\#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-sysm/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:20:17 [error] 7479\#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:20:17 [debug] 7479\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:20:17 [debug] 7479\#0: *2 lua deleting light thread
2020/10/18 03:20:17 [debug] 7479\#0: *2 lua caching unused lua thread 00000000089074A0 (ref 1)
2020/10/18 03:20:17 [debug] 7479\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:20:17 [debug] 7479\#0: *2 http special response: 500, "/t?"
2020/10/18 03:20:17 [debug] 7479\#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:20:19 [error] 7480\#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-sysm/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:20:19 [error] 7480\#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-sysm/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:20:19 [error] 7480\#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:20:19 [debug] 7480\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:20:19 [debug] 7480\#0: *2 lua deleting light thread
2020/10/18 03:20:19 [debug] 7480\#0: *2 lua caching unused lua thread 00000000089083D0 (ref 1)
2020/10/18 03:20:19 [debug] 7480\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:20:19 [debug] 7480\#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)
ssl.t TEST 1: send query w/o result set - status code ok got: '500'
expected: '200'
ssl.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: \{"affected_rows":0,"insert_id":0,"server_status":2,"warning_count":[01]\}$)'
ssl.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:20:23 [error] 7485\#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-sysm/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'
'
ssl.t TEST 1: send query w/o result set - status code ok got: '500'
expected: '200'
ssl.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: \{"affected_rows":0,"insert_id":0,"server_status":2,"warning_count":[01]\}$)'
ssl.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:20:23 [error] 7485\#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-sysm/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'
'
ssl.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:20:23 [error] 7485\#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:20:23 [debug] 7485\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:20:23 [debug] 7485\#0: *2 lua deleting light thread
2020/10/18 03:20:23 [debug] 7485\#0: *2 lua caching unused lua thread 00000000089085E0 (ref 1)
2020/10/18 03:20:23 [debug] 7485\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:20:23 [debug] 7485\#0: *2 http special response: 500, "/t?"
2020/10/18 03:20:23 [debug] 7485\#0: *2 http set discard body
'
ssl.t 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)
ssl.t TEST 2: send query w/o result set (verify) - Can't connect to 127.0.0.1:1984: Connection refused (aborted) '
ssl.t TEST 2: send query w/o result set (verify) - status code ok got: ''
expected: '200'
ssl.t TEST 2: send query w/o result set (verify) - response_body_like - response is expected () ''
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]\}$)'
ssl.t TEST 2: send query w/o result set (verify) - Can't connect to 127.0.0.1:1984: Connection refused (aborted) '
ssl.t TEST 2: send query w/o result set (verify) - status code ok got: ''
expected: '200'
ssl.t TEST 2: send query w/o result set (verify) - response_body_like - response is expected () ''
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]\}$)'
ssl.t TEST 3: send query w/o result set (verify, failed) - status code ok got: '500'
expected: '200'
ssl.t TEST 3: send query w/o result set (verify, failed) - 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: 'failed to connect: failed to do ssl handshake: 18: self signed certificate: nil nil
'
ssl.t TEST 3: send query w/o result set (verify, failed) - status code ok got: '500'
expected: '200'
ssl.t TEST 3: send query w/o result set (verify, failed) - 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: 'failed to connect: failed to do ssl handshake: 18: self signed certificate: nil nil
'
stream.t TEST 1: connected (support in stream module) - response_body_like - response is expected () ''
doesn't match '(?^s:connected to mysql \d\.[^\s\x00]+
)'
stream.t TEST 1: connected (support in stream module) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:20:29 [error] 7493\#0: *3 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-sysm/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'
'
stream.t TEST 1: connected (support in stream module) - response_body_like - response is expected () ''
doesn't match '(?^s:connected to mysql \d\.[^\s\x00]+
)'
stream.t TEST 1: connected (support in stream module) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:20:29 [error] 7493\#0: *3 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-sysm/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'
'
stream.t TEST 1: connected (support in stream module) - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:20:30 [error] 7493\#0: *6 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:46):3: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:46): in main chunk, client: 127.0.0.1, server: 0.0.0.0:1985
2020/10/18 03:20:30 [debug] 7493\#0: *6 lua request cleanup: forcible=0
2020/10/18 03:20:30 [debug] 7493\#0: *6 finalize stream request: 500
2020/10/18 03:20:30 [debug] 7493\#0: *6 finalize stream session: 500
2020/10/18 03:20:30 [debug] 7493\#0: *6 stream log handler
2020/10/18 03:20:30 [debug] 7493\#0: *6 close stream connection: 10
2020/10/18 03:20:30 [debug] 7493\#0: *6 reusable connection: 0
'
version.t TEST 1: basic - status code ok got: '500'
expected: '200'
version.t TEST 1: basic - 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:^\d+\.\d+$)'
version.t TEST 1: basic - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:20:32 [error] 7498\#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 '../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-sysm/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'
no file '/opt/luajit-sysm/share/lua/5.1/resty/sha256.lua'
'
version.t TEST 1: basic - status code ok got: '500'
expected: '200'
version.t TEST 1: basic - 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:^\d+\.\d+$)'
version.t TEST 1: basic - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:20:32 [error] 7498\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:45):3: attempt to index local 'mysql' (a number value)" (req 1) stack traceback:
coroutine 0:
content_by_lua(nginx.conf:45): in main chunk, client: 127.0.0.1, server: localhost, request: "GET /t HTTP/1.1", host: "localhost"
2020/10/18 03:20:32 [debug] 7498\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:20:32 [debug] 7498\#0: *2 lua deleting light thread
2020/10/18 03:20:32 [debug] 7498\#0: *2 lua caching unused lua thread 00000000088FFB70 (ref 1)
2020/10/18 03:20:32 [debug] 7498\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:20:32 [debug] 7498\#0: *2 http special response: 500, "/t?"
2020/10/18 03:20:32 [debug] 7498\#0: *2 http set discard body
'
world.t TEST 1: test an old bug in table.new() on i386 in luajit v2.1 - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:20:34 [error] 7502\#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-sysm/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'
'
world.t TEST 1: test an old bug in table.new() on i386 in luajit v2.1 - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:20:34 [error] 7502\#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-sysm/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'
'
world.t TEST 1: test an old bug in table.new() on i386 in luajit v2.1 - pattern "[error]" should not match any line in error.log but matches line "2020/10/18 03:20:34 [error] 7502\#0: *2 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:84):4: 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:20:34 [debug] 7502\#0: *2 lua request cleanup: forcible=0
2020/10/18 03:20:34 [debug] 7502\#0: *2 lua deleting light thread
2020/10/18 03:20:34 [debug] 7502\#0: *2 lua caching unused lua thread 00000000089088A0 (ref 1)
2020/10/18 03:20:34 [debug] 7502\#0: *2 http finalize request: 500, "/t?" a:1, c:1
2020/10/18 03:20:34 [debug] 7502\#0: *2 http special response: 500, "/t?"
2020/10/18 03:20:34 [debug] 7502\#0: *2 http set discard body
'

Expected Failures

File Name Details
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 - 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>
'
ssl.t TEST 3: send query w/o result set (verify, failed) - pattern "lua ssl certificate verify error: (18: self signed certificate)" should match a line in error.log (req 0)
ssl.t TEST 3: send query w/o result set (verify, failed) - pattern "lua ssl certificate verify error: (18: self signed certificate)" should match a line in error.log (req 1)
world.t TEST 1: test an old bug in table.new() on i386 in luajit v2.1 - status code ok got: '500'
expected: '200'
world.t TEST 1: test an old bug in table.new() on i386 in luajit v2.1 - response_body - response is expected (repeated req 0, req 0) @@ -1,50 +1,7 @@
-ncols: 5
+<html>
-ncols: 5
+<head><title>500 Internal Server Error</title></head>
-ncols: 5
+<body>
-ncols: 5
+<center><h1>500 Internal Server Error</h1></center>
-ncols: 5
+<hr><center>nginx/1.19.3 (no pool)</center>
-ncols: 5
+</body>
-ncols: 5
+</html>
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
'
world.t TEST 1: test an old bug in table.new() on i386 in luajit v2.1 - status code ok got: '500'
expected: '200'
world.t TEST 1: test an old bug in table.new() on i386 in luajit v2.1 - response_body - response is expected (repeated req 1, req 0) @@ -1,50 +1,7 @@
-ncols: 5
+<html>
-ncols: 5
+<head><title>500 Internal Server Error</title></head>
-ncols: 5
+<body>
-ncols: 5
+<center><h1>500 Internal Server Error</h1></center>
-ncols: 5
+<hr><center>nginx/1.19.3 (no pool)</center>
-ncols: 5
+</body>
-ncols: 5
+</html>
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
-ncols: 5
'

Warnings

Go back to the index page.