dropping to exim gid; retaining priv uid
search_open: pgsql "NULL"
search_find: file="NULL"
- key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
+ key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="select name from them where id='ph10';"
+ type=pgsql key="select name from them where id='ph10';" opts=NULL
database lookup required for select name from them where id='ph10';
PostgreSQL query: select name from them where id='ph10';
PGSQL new connection: host=localhost port=1223 database=test user=CALLER
search_open: pgsql "NULL"
cached open
search_find: file="NULL"
- key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
+ key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="select name from them where id='ph10';"
+ type=pgsql key="select name from them where id='ph10';" opts=NULL
cached data used for lookup of select name from them where id='ph10';
lookup yielded: Philip Hazel
search_open: pgsql "NULL"
cached open
search_find: file="NULL"
- key="select name from them where id='xxxx';" partial=-1 affix=NULL starflags=0
+ key="select name from them where id='xxxx';" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="select name from them where id='xxxx';"
+ type=pgsql key="select name from them where id='xxxx';" opts=NULL
database lookup required for select name from them where id='xxxx';
PostgreSQL query: select name from them where id='xxxx';
PGSQL using cached connection for localhost:1223/test/CALLER
search_open: pgsql "NULL"
cached open
search_find: file="NULL"
- key="select name from them where id='nothing';" partial=-1 affix=NULL starflags=0
+ key="select name from them where id='nothing';" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="select name from them where id='nothing';"
+ type=pgsql key="select name from them where id='nothing';" opts=NULL
database lookup required for select name from them where id='nothing';
PostgreSQL query: select name from them where id='nothing';
PGSQL using cached connection for localhost:1223/test/CALLER
search_open: pgsql "NULL"
cached open
search_find: file="NULL"
- key="select id,name from them where id='nothing';" partial=-1 affix=NULL starflags=0
+ key="select id,name from them where id='nothing';" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="select id,name from them where id='nothing';"
+ type=pgsql key="select id,name from them where id='nothing';" opts=NULL
database lookup required for select id,name from them where id='nothing';
PostgreSQL query: select id,name from them where id='nothing';
PGSQL using cached connection for localhost:1223/test/CALLER
search_open: pgsql "NULL"
cached open
search_find: file="NULL"
- key="delete from them where id='nonexist';" partial=-1 affix=NULL starflags=0
+ key="delete from them where id='nonexist';" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="delete from them where id='nonexist';"
+ type=pgsql key="delete from them where id='nonexist';" opts=NULL
database lookup required for delete from them where id='nonexist';
PostgreSQL query: delete from them where id='nonexist';
PGSQL using cached connection for localhost:1223/test/CALLER
search_open: pgsql "NULL"
cached open
search_find: file="NULL"
- key="select * from them where id='quote2';" partial=-1 affix=NULL starflags=0
+ key="select * from them where id='quote2';" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="select * from them where id='quote2';"
+ type=pgsql key="select * from them where id='quote2';" opts=NULL
database lookup required for select * from them where id='quote2';
PostgreSQL query: select * from them where id='quote2';
PGSQL using cached connection for localhost:1223/test/CALLER
search_open: pgsql "NULL"
cached open
search_find: file="NULL"
- key="select * from them where id='newline';" partial=-1 affix=NULL starflags=0
+ key="select * from them where id='newline';" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="select * from them where id='newline';"
+ type=pgsql key="select * from them where id='newline';" opts=NULL
database lookup required for select * from them where id='newline';
PostgreSQL query: select * from them where id='newline';
PGSQL using cached connection for localhost:1223/test/CALLER
search_open: pgsql "NULL"
cached open
search_find: file="NULL"
- key="select * from them where id='tab';" partial=-1 affix=NULL starflags=0
+ key="select * from them where id='tab';" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="select * from them where id='tab';"
+ type=pgsql key="select * from them where id='tab';" opts=NULL
database lookup required for select * from them where id='tab';
PostgreSQL query: select * from them where id='tab';
PGSQL using cached connection for localhost:1223/test/CALLER
search_open: pgsql "NULL"
cached open
search_find: file="NULL"
- key="select * from them where name='''stquot';" partial=-1 affix=NULL starflags=0
+ key="select * from them where name='''stquot';" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="select * from them where name='''stquot';"
+ type=pgsql key="select * from them where name='''stquot';" opts=NULL
database lookup required for select * from them where name='''stquot';
PostgreSQL query: select * from them where name='''stquot';
PGSQL using cached connection for localhost:1223/test/CALLER
search_open: pgsql "NULL"
cached open
search_find: file="NULL"
- key="servers=x:localhost; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
+ key="servers=x:localhost; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="servers=x:localhost; select name from them where id='ph10';"
+ type=pgsql key="servers=x:localhost; select name from them where id='ph10';" opts=NULL
database lookup required for servers=x:localhost; select name from them where id='ph10';
PostgreSQL query: servers=x:localhost; select name from them where id='ph10';
lookup deferred: PostgreSQL server "x" not found in pgsql_servers
search_open: pgsql "NULL"
cached open
search_find: file="NULL"
- key="servers=localhost::1223:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
+ key="servers=localhost::1223:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="servers=localhost::1223:x; select name from them where id='ph10';"
+ type=pgsql key="servers=localhost::1223:x; select name from them where id='ph10';" opts=NULL
database lookup required for servers=localhost::1223:x; select name from them where id='ph10';
PostgreSQL query: servers=localhost::1223:x; select name from them where id='ph10';
PGSQL using cached connection for localhost:1223/test/CALLER
search_open: pgsql "NULL"
cached open
search_find: file="NULL"
- key="servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
+ key="servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';"
+ type=pgsql key="servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';" opts=NULL
database lookup required for servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';
PostgreSQL query: servers=localhost::1223/test/CALLER/:x; select name from them where id='ph10';
PGSQL using cached connection for localhost:1223/test/CALLER
search_open: pgsql "NULL"
cached open
search_find: file="NULL"
- key="servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
+ key="servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';"
+ type=pgsql key="servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';" opts=NULL
database lookup required for servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';
PostgreSQL query: servers=(TESTSUITE/pgsql/.s.PGSQL.1223)/test/CALLER/:x; select name from them where id='ph10';
PGSQL new connection: socket=TESTSUITE/pgsql/.s.PGSQL.1223 database=test user=CALLER
search_open: pgsql "NULL"
cached open
search_find: file="NULL"
- key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0
+ key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');"
+ type=pgsql key="SELECT name FROM them WHERE id IN ('ph10', 'aaaa');" opts=NULL
database lookup required for SELECT name FROM them WHERE id IN ('ph10', 'aaaa');
PostgreSQL query: SELECT name FROM them WHERE id IN ('ph10', 'aaaa');
PGSQL using cached connection for localhost:1223/test/CALLER
search_open: pgsql "NULL"
cached open
search_find: file="NULL"
- key="SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0
+ key="SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="SELECT * FROM them WHERE id IN ('ph10', 'aaaa');"
+ type=pgsql key="SELECT * FROM them WHERE id IN ('ph10', 'aaaa');" opts=NULL
database lookup required for SELECT * FROM them WHERE id IN ('ph10', 'aaaa');
PostgreSQL query: SELECT * FROM them WHERE id IN ('ph10', 'aaaa');
PGSQL using cached connection for localhost:1223/test/CALLER
search_open: pgsql "NULL"
cached open
search_find: file="NULL"
- key="delete from them where id='aaaa'" partial=-1 affix=NULL starflags=0
+ key="delete from them where id='aaaa'" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="delete from them where id='aaaa'"
+ type=pgsql key="delete from them where id='aaaa'" opts=NULL
database lookup required for delete from them where id='aaaa'
PostgreSQL query: delete from them where id='aaaa'
PGSQL using cached connection for localhost:1223/test/CALLER
check hosts = +relay_hosts
search_open: pgsql "NULL"
search_find: file="NULL"
- key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0
+ key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="select * from them where id='10.0.0.0'"
+ type=pgsql key="select * from them where id='10.0.0.0'" opts=NULL
database lookup required for select * from them where id='10.0.0.0'
PostgreSQL query: select * from them where id='10.0.0.0'
PGSQL new connection: host=localhost port=1223 database=test user=CALLER
search_open: pgsql "NULL"
cached open
search_find: file="NULL"
- key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0
+ key="select * from them where id='10.0.0.0'" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="select * from them where id='10.0.0.0'"
+ type=pgsql key="select * from them where id='10.0.0.0'" opts=NULL
cached data used for lookup of select * from them where id='10.0.0.0'
lookup failed
host in "net-pgsql;select * from them where id='10.0.0.0'"? no (end of list)
<= CALLER@myhost.test.ex U=CALLER P=local S=sss
created log directory TESTSUITE/spool/log
search_tidyup called
-fresh-exec forking for local-accept-delivery
-postfork: local-accept-delivery
exec TESTSUITE/eximdir/exim -DEXIM_PATH=TESTSUITE/eximdir/exim -C TESTSUITE/test-config -d=0xf7715cfd -MCd local-accept-delivery -odi -Mc 10HmaX-0005vi-00
-fresh-exec forked for local-accept-delivery: npppp
Exim version x.yz ....
changed uid/gid: forcing real = effective
uid=uuuu gid=EXIM_GID pid=pppp
processing address_data
search_open: pgsql "NULL"
search_find: file="NULL"
- key="select name from them where id='ph10'" partial=-1 affix=NULL starflags=0
+ key="select name from them where id='ph10'" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="select name from them where id='ph10'"
+ type=pgsql key="select name from them where id='ph10'" opts=NULL
database lookup required for select name from them where id='ph10'
PostgreSQL query: select name from them where id='ph10'
PGSQL new connection: host=localhost port=1223 database=test user=CALLER
failed to open DB file TESTSUITE/spool/db/retry: No such file or directory
no retry data available
search_tidyup called
-local-accept-delivery forking for delivery-local
-postfork: delivery-local
changed uid/gid: local delivery to CALLER <CALLER@myhost.test.ex> transport=t1
uid=CALLER_UID gid=CALLER_GID pid=pppp
home=NULL current=/
appendfile transport entered
search_open: pgsql "NULL"
search_find: file="NULL"
- key="select id from them where id='ph10'" partial=-1 affix=NULL starflags=0
+ key="select id from them where id='ph10'" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="select id from them where id='ph10'"
+ type=pgsql key="select id from them where id='ph10'" opts=NULL
database lookup required for select id from them where id='ph10'
PostgreSQL query: select id from them where id='ph10'
PGSQL new connection: host=localhost port=1223 database=test user=CALLER
appendfile yields 0 with errno=dd more_errno=dd
search_tidyup called
close PGSQL connection: localhost:1223/test/CALLER
-local-accept-delivery forked for delivery-local: npppp
journalling CALLER@myhost.test.ex
t1 transport returned OK for CALLER@myhost.test.ex
post-process CALLER@myhost.test.ex (0)
dropping to exim gid; retaining priv uid
search_open: pgsql "NULL"
search_find: file="NULL"
- key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0
+ key="select name from them where id='ph10';" partial=-1 affix=NULL starflags=0 opts=NULL
LRU list:
internal_search_find: file="NULL"
- type=pgsql key="select name from them where id='ph10';"
+ type=pgsql key="select name from them where id='ph10';" opts=NULL
database lookup required for select name from them where id='ph10';
PostgreSQL query: select name from them where id='ph10';
PGSQL new connection: socket=TESTSUITE/pgsql/.s.PGSQL.1223 database=test user=CALLER