X-Git-Url: https://git.exim.org/exim.git/blobdiff_plain/df98a6ff2e70887890690ffbf8a8ad583d7d7e38..042e558f346b01902dd414206a047fa47b686f0b:/test/stderr/2610 diff --git a/test/stderr/2610 b/test/stderr/2610 index f9e073f2f..ef3e0a901 100644 --- a/test/stderr/2610 +++ b/test/stderr/2610 @@ -2,210 +2,210 @@ Exim version x.yz .... configuration file is TESTSUITE/test-config admin user dropping to exim gid; retaining priv uid -search_open: mysql "NULL" -search_find: file="NULL" - key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="select name from them where id='ph10';" -database lookup required for select name from them where id='ph10'; -MySQL query: select name from them where id='ph10'; -MYSQL new connection: host=127.0.0.1 port=1223 socket=NULL database=test user=root -lookup yielded: Philip Hazel -search_open: mysql "NULL" - cached open -search_find: file="NULL" - key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="select name from them where id='ph10';" -cached data used for lookup of select name from them where id='ph10'; -lookup yielded: Philip Hazel -search_open: mysql "NULL" - cached open -search_find: file="NULL" - key="select name from them where id='xxxx';" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="select name from them where id='xxxx';" -database lookup required for select name from them where id='xxxx'; -MySQL query: select name from them where id='xxxx'; -MYSQL using cached connection for 127.0.0.1:1223/test/root -MYSQL: no data found -lookup failed -search_open: mysql "NULL" - cached open -search_find: file="NULL" - key="select name from them where id='nothing';" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="select name from them where id='nothing';" -database lookup required for select name from them where id='nothing'; -MySQL query: select name from them where id='nothing'; -MYSQL using cached connection for 127.0.0.1:1223/test/root -lookup yielded: -search_open: mysql "NULL" - cached open -search_find: file="NULL" - key="select id,name from them where id='nothing';" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="select id,name from them where id='nothing';" -database lookup required for select id,name from them where id='nothing'; -MySQL query: select id,name from them where id='nothing'; -MYSQL using cached connection for 127.0.0.1:1223/test/root -lookup yielded: id=nothing name="" -search_open: mysql "NULL" - cached open -search_find: file="NULL" - key="delete from them where id='nonexist';" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="delete from them where id='nonexist';" -database lookup required for delete from them where id='nonexist'; -MySQL query: delete from them where id='nonexist'; -MYSQL using cached connection for 127.0.0.1:1223/test/root -MYSQL: query was not one that returns data -lookup forced cache cleanup -lookup yielded: 0 -search_open: mysql "NULL" - cached open -search_find: file="NULL" - key="select * from them where id='quote';" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="select * from them where id='quote';" -database lookup required for select * from them where id='quote'; -MySQL query: select * from them where id='quote'; -MYSQL using cached connection for 127.0.0.1:1223/test/root -MYSQL: no data found -lookup failed -search_open: mysql "NULL" - cached open -search_find: file="NULL" - key="select * from them where id='filter';" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="select * from them where id='filter';" -database lookup required for select * from them where id='filter'; -MySQL query: select * from them where id='filter'; -MYSQL using cached connection for 127.0.0.1:1223/test/root -MYSQL: no data found -lookup failed -search_open: mysql "NULL" - cached open -search_find: file="NULL" - key="select * from them where id='quote2';" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="select * from them where id='quote2';" -database lookup required for select * from them where id='quote2'; -MySQL query: select * from them where id='quote2'; -MYSQL using cached connection for 127.0.0.1:1223/test/root -lookup yielded: name="\"stquot" id=quote2 -search_open: mysql "NULL" - cached open -search_find: file="NULL" - key="select * from them where id='nlonly';" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="select * from them where id='nlonly';" -database lookup required for select * from them where id='nlonly'; -MySQL query: select * from them where id='nlonly'; -MYSQL using cached connection for 127.0.0.1:1223/test/root -MYSQL: no data found -lookup failed -search_open: mysql "NULL" - cached open -search_find: file="NULL" - key="servers=x:127.0.0.1::1223; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="servers=x:127.0.0.1::1223; select name from them where id='ph10';" -database lookup required for servers=x:127.0.0.1::1223; select name from them where id='ph10'; -MySQL query: servers=x:127.0.0.1::1223; select name from them where id='ph10'; -lookup deferred: MySQL server "x" not found in mysql_servers -search_open: mysql "NULL" - cached open -search_find: file="NULL" - key="servers=127.0.0.1::1223:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="servers=127.0.0.1::1223:x; select name from them where id='ph10';" -database lookup required for servers=127.0.0.1::1223:x; select name from them where id='ph10'; -MySQL query: servers=127.0.0.1::1223:x; select name from them where id='ph10'; -MYSQL using cached connection for 127.0.0.1:1223/test/root -lookup yielded: Philip Hazel -search_open: mysql "NULL" - cached open -search_find: file="NULL" - key="servers=127.0.0.1::1223/test/root/:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="servers=127.0.0.1::1223/test/root/:x; select name from them where id='ph10';" -database lookup required for servers=127.0.0.1::1223/test/root/:x; select name from them where id='ph10'; -MySQL query: servers=127.0.0.1::1223/test/root/:x; select name from them where id='ph10'; -MYSQL using cached connection for 127.0.0.1:1223/test/root -lookup yielded: Philip Hazel -search_open: mysql "NULL" - cached open -search_find: file="NULL" - key="servers=ip4.ip4.ip4.ip4::1223/test/root/:127.0.0.1::1223; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="servers=ip4.ip4.ip4.ip4::1223/test/root/:127.0.0.1::1223; select name from them where id='ph10';" -database lookup required for servers=ip4.ip4.ip4.ip4::1223/test/root/:127.0.0.1::1223; select name from them where id='ph10'; -MySQL query: servers=ip4.ip4.ip4.ip4::1223/test/root/:127.0.0.1::1223; select name from them where id='ph10'; -MYSQL new connection: host=ip4.ip4.ip4.ip4 port=1223 socket=NULL database=test user=root -lookup yielded: Philip Hazel -search_open: mysql "NULL" - cached open -search_find: file="NULL" - key="servers=localhost(TESTSUITE/mysql/sock)/test/root/; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="servers=localhost(TESTSUITE/mysql/sock)/test/root/; select name from them where id='ph10';" -database lookup required for servers=localhost(TESTSUITE/mysql/sock)/test/root/; select name from them where id='ph10'; -MySQL query: servers=localhost(TESTSUITE/mysql/sock)/test/root/; select name from them where id='ph10'; -MYSQL new connection: host=localhost port=0 socket=TESTSUITE/mysql/sock database=test user=root -lookup yielded: Philip Hazel -search_open: mysql "NULL" - cached open -search_find: file="NULL" - key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" -database lookup required for SELECT name FROM them WHERE id IN ('ph10', 'aaaa'); -MySQL query: SELECT name FROM them WHERE id IN ('ph10', 'aaaa'); -MYSQL using cached connection for 127.0.0.1:1223/test/root -lookup yielded: Philip Hazel -Aristotle -search_open: mysql "NULL" - cached open -search_find: file="NULL" - key="SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" -database lookup required for SELECT * FROM them WHERE id IN ('ph10', 'aaaa'); -MySQL query: SELECT * FROM them WHERE id IN ('ph10', 'aaaa'); -MYSQL using cached connection for 127.0.0.1:1223/test/root -lookup yielded: name="Philip Hazel" id=ph10 -name=Aristotle id=aaaa -search_open: mysql "NULL" - cached open -search_find: file="NULL" - key="delete from them where id='aaaa'" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="delete from them where id='aaaa'" -database lookup required for delete from them where id='aaaa' -MySQL query: delete from them where id='aaaa' -MYSQL using cached connection for 127.0.0.1:1223/test/root -MYSQL: query was not one that returns data -lookup forced cache cleanup -lookup yielded: 1 + search_open: mysql "NULL" + search_find: file="NULL" + key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="select name from them where id='ph10';" + database lookup required for select name from them where id='ph10'; + MySQL query: select name from them where id='ph10'; + MYSQL new connection: host=127.0.0.1 port=1223 socket=NULL database=test user=root + lookup yielded: Philip Hazel + search_open: mysql "NULL" + cached open + search_find: file="NULL" + key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="select name from them where id='ph10';" + cached data used for lookup of select name from them where id='ph10'; + lookup yielded: Philip Hazel + search_open: mysql "NULL" + cached open + search_find: file="NULL" + key="select name from them where id='xxxx';" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="select name from them where id='xxxx';" + database lookup required for select name from them where id='xxxx'; + MySQL query: select name from them where id='xxxx'; + MYSQL using cached connection for 127.0.0.1:1223/test/root + MYSQL: no data found + lookup failed + search_open: mysql "NULL" + cached open + search_find: file="NULL" + key="select name from them where id='nothing';" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="select name from them where id='nothing';" + database lookup required for select name from them where id='nothing'; + MySQL query: select name from them where id='nothing'; + MYSQL using cached connection for 127.0.0.1:1223/test/root + lookup yielded: + search_open: mysql "NULL" + cached open + search_find: file="NULL" + key="select id,name from them where id='nothing';" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="select id,name from them where id='nothing';" + database lookup required for select id,name from them where id='nothing'; + MySQL query: select id,name from them where id='nothing'; + MYSQL using cached connection for 127.0.0.1:1223/test/root + lookup yielded: id=nothing name="" + search_open: mysql "NULL" + cached open + search_find: file="NULL" + key="delete from them where id='nonexist';" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="delete from them where id='nonexist';" + database lookup required for delete from them where id='nonexist'; + MySQL query: delete from them where id='nonexist'; + MYSQL using cached connection for 127.0.0.1:1223/test/root + MYSQL: query was not one that returns data + lookup forced cache cleanup + lookup yielded: 0 + search_open: mysql "NULL" + cached open + search_find: file="NULL" + key="select * from them where id='quote';" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="select * from them where id='quote';" + database lookup required for select * from them where id='quote'; + MySQL query: select * from them where id='quote'; + MYSQL using cached connection for 127.0.0.1:1223/test/root + MYSQL: no data found + lookup failed + search_open: mysql "NULL" + cached open + search_find: file="NULL" + key="select * from them where id='filter';" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="select * from them where id='filter';" + database lookup required for select * from them where id='filter'; + MySQL query: select * from them where id='filter'; + MYSQL using cached connection for 127.0.0.1:1223/test/root + MYSQL: no data found + lookup failed + search_open: mysql "NULL" + cached open + search_find: file="NULL" + key="select * from them where id='quote2';" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="select * from them where id='quote2';" + database lookup required for select * from them where id='quote2'; + MySQL query: select * from them where id='quote2'; + MYSQL using cached connection for 127.0.0.1:1223/test/root + lookup yielded: name="\"stquot" id=quote2 + search_open: mysql "NULL" + cached open + search_find: file="NULL" + key="select * from them where id='nlonly';" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="select * from them where id='nlonly';" + database lookup required for select * from them where id='nlonly'; + MySQL query: select * from them where id='nlonly'; + MYSQL using cached connection for 127.0.0.1:1223/test/root + MYSQL: no data found + lookup failed + search_open: mysql "NULL" + cached open + search_find: file="NULL" + key="servers=x:127.0.0.1::1223; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="servers=x:127.0.0.1::1223; select name from them where id='ph10';" + database lookup required for servers=x:127.0.0.1::1223; select name from them where id='ph10'; + MySQL query: servers=x:127.0.0.1::1223; select name from them where id='ph10'; + lookup deferred: MySQL server "x" not found in mysql_servers + search_open: mysql "NULL" + cached open + search_find: file="NULL" + key="servers=127.0.0.1::1223:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="servers=127.0.0.1::1223:x; select name from them where id='ph10';" + database lookup required for servers=127.0.0.1::1223:x; select name from them where id='ph10'; + MySQL query: servers=127.0.0.1::1223:x; select name from them where id='ph10'; + MYSQL using cached connection for 127.0.0.1:1223/test/root + lookup yielded: Philip Hazel + search_open: mysql "NULL" + cached open + search_find: file="NULL" + key="servers=127.0.0.1::1223/test/root/:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="servers=127.0.0.1::1223/test/root/:x; select name from them where id='ph10';" + database lookup required for servers=127.0.0.1::1223/test/root/:x; select name from them where id='ph10'; + MySQL query: servers=127.0.0.1::1223/test/root/:x; select name from them where id='ph10'; + MYSQL using cached connection for 127.0.0.1:1223/test/root + lookup yielded: Philip Hazel + search_open: mysql "NULL" + cached open + search_find: file="NULL" + key="servers=ip4.ip4.ip4.ip4::1223/test/root/:127.0.0.1::1223; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="servers=ip4.ip4.ip4.ip4::1223/test/root/:127.0.0.1::1223; select name from them where id='ph10';" + database lookup required for servers=ip4.ip4.ip4.ip4::1223/test/root/:127.0.0.1::1223; select name from them where id='ph10'; + MySQL query: servers=ip4.ip4.ip4.ip4::1223/test/root/:127.0.0.1::1223; select name from them where id='ph10'; + MYSQL new connection: host=ip4.ip4.ip4.ip4 port=1223 socket=NULL database=test user=root + lookup yielded: Philip Hazel + search_open: mysql "NULL" + cached open + search_find: file="NULL" + key="servers=localhost(TESTSUITE/mysql/sock)/test/root/; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="servers=localhost(TESTSUITE/mysql/sock)/test/root/; select name from them where id='ph10';" + database lookup required for servers=localhost(TESTSUITE/mysql/sock)/test/root/; select name from them where id='ph10'; + MySQL query: servers=localhost(TESTSUITE/mysql/sock)/test/root/; select name from them where id='ph10'; + MYSQL new connection: host=localhost port=0 socket=TESTSUITE/mysql/sock database=test user=root + lookup yielded: Philip Hazel + search_open: mysql "NULL" + cached open + search_find: file="NULL" + key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" + database lookup required for SELECT name FROM them WHERE id IN ('ph10', 'aaaa'); + MySQL query: SELECT name FROM them WHERE id IN ('ph10', 'aaaa'); + MYSQL using cached connection for 127.0.0.1:1223/test/root + lookup yielded: Philip Hazel + Aristotle + search_open: mysql "NULL" + cached open + search_find: file="NULL" + key="SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" + database lookup required for SELECT * FROM them WHERE id IN ('ph10', 'aaaa'); + MySQL query: SELECT * FROM them WHERE id IN ('ph10', 'aaaa'); + MYSQL using cached connection for 127.0.0.1:1223/test/root + lookup yielded: name="Philip Hazel" id=ph10 + name=Aristotle id=aaaa + search_open: mysql "NULL" + cached open + search_find: file="NULL" + key="delete from them where id='aaaa'" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="delete from them where id='aaaa'" + database lookup required for delete from them where id='aaaa' + MySQL query: delete from them where id='aaaa' + MYSQL using cached connection for 127.0.0.1:1223/test/root + MYSQL: query was not one that returns data + lookup forced cache cleanup + lookup yielded: 1 search_tidyup called close MYSQL connection: localhost(TESTSUITE/mysql/sock)/test/root close MYSQL connection: ip4.ip4.ip4.ip4:1223/test/root @@ -367,16 +367,16 @@ routing ph10@myhost.test.ex --------> r1 router <-------- local_part=ph10 domain=myhost.test.ex processing address_data -search_open: mysql "NULL" -search_find: file="NULL" - key="select name from them where id='ph10'" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="select name from them where id='ph10'" -database lookup required for select name from them where id='ph10' -MySQL query: select name from them where id='ph10' -MYSQL new connection: host=127.0.0.1 port=1223 socket=NULL database=test user=root -lookup yielded: Philip Hazel + search_open: mysql "NULL" + search_find: file="NULL" + key="select name from them where id='ph10'" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="select name from them where id='ph10'" + database lookup required for select name from them where id='ph10' + MySQL query: select name from them where id='ph10' + MYSQL new connection: host=127.0.0.1 port=1223 socket=NULL database=test user=root + lookup yielded: Philip Hazel calling r1 router r1 router called for ph10@myhost.test.ex domain = myhost.test.ex @@ -411,16 +411,16 @@ changed uid/gid: local delivery to ph10 transport=t1 home=NULL current=/ set_process_info: pppp delivering 10HmaX-0005vi-00 to ph10 using t1 appendfile transport entered -search_open: mysql "NULL" -search_find: file="NULL" - key="select id from them where id='ph10'" partial=-1 affix=NULL starflags=0 -LRU list: -internal_search_find: file="NULL" - type=mysql key="select id from them where id='ph10'" -database lookup required for select id from them where id='ph10' -MySQL query: select id from them where id='ph10' -MYSQL new connection: host=127.0.0.1 port=1223 socket=NULL database=test user=root -lookup yielded: ph10 + search_open: mysql "NULL" + search_find: file="NULL" + key="select id from them where id='ph10'" partial=-1 affix=NULL starflags=0 + LRU list: + internal_search_find: file="NULL" + type=mysql key="select id from them where id='ph10'" + database lookup required for select id from them where id='ph10' + MySQL query: select id from them where id='ph10' + MYSQL new connection: host=127.0.0.1 port=1223 socket=NULL database=test user=root + lookup yielded: ph10 appendfile: mode=600 notify_comsat=0 quota=0 warning=0 file=TESTSUITE/test-mail/ph10 format=unix message_prefix=From ${if def:return_path{$return_path}{MAILER-DAEMON}} ${tod_bsdinbox}\n