Paul,
I've just update to svn 2196, on postgresql 8.4.1, with the aim of
speeding up searches. But, now I errors with the new search code.
Level 5 log follows.
Regards,
Michael.
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Info COMMAND: [5 uid
SEARCH UNDELETED BODY "Cuculowskyj"]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug arg[0]: 'SEARCH'
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug arg[1]: 'UNDELETED'
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug arg[2]: 'BODY'
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug arg[3]: 'Cuculowskyj'
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Info
imap4.c,IMAPClientHandler: Executing command uid...
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
db.c,db_acl_has_right: checking ACL [read_flag] for user [3] on mailbox [9]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug db.c,
db_acl_has_right: mailbox [9] is owned by user [3], is that also [3]?
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug db.c,
db_acl_has_right: mailbox [9] is owned by user [3], giving all rights
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
dbpgsql.c,db_query: executing query [SELECT message_idnr FROM
dbmail_messages WHERE mailbox_idnr = '9' AND status IN ('0','1') ORDER
BY message_idnr]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
dbmail-mailbox.c,append_search: [135459360] [1] type [1] field [] search
[1:*] at depth [1]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
dbmail-mailbox.c,append_search: [136115440] [0] type [2] field [] search
[deleted_flag=0] at depth [1]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
dbmail-mailbox.c,append_search: [136119704] [0] type [9] field [] search
[Cuculowskyj] at depth [1]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
dbmail-mailbox.c,dbmail_mailbox_get_set: [1:*]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
misc.c,g_tree_merge: a[0] [OR] b[1008] -> a[1008]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
dbmail-mailbox.c,dbmail_mailbox_get_set: self->set contains [1008] ids
between [7117] and [17379]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
dbmail-mailbox.c,_do_search: [135459360] depth [1] type [1] rows [0]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
dbpgsql.c,db_query: executing query [SELECT message_idnr FROM
dbmail_messages WHERE mailbox_idnr = '9' AND status IN ('0','1') AND
deleted_flag=0 ORDER BY message_idnr]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
dbmail-mailbox.c,_do_search: [136115440] depth [2] type [2] rows [1008]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
dbpgsql.c,db_query: executing query [SELECT m.message_idnr,k.messageblk
FROM dbmail_messageblks k JOIN dbmail_physmessage p ON k.physmessage_id
= p.id JOIN dbmail_messages m ON p.id = m.physmessage_id WHERE
mailbox_idnr = '9' AND status IN ('0','1' ) AND k.is_header = '0' HAVING
ENCODE(k.messageblk::bytea,'escape') ILIKE '%Cuculowskyj%']
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Error dbpgsql.c,
db_query: Error executing query [SELECT m.message_idnr,k.messageblk FROM
dbmail_messageblks k JOIN dbmail_physmessage p ON k.physmessage_id =
p.id JOIN dbmail_messages m ON p.id = m.physmessage_id WHERE
mailbox_idnr = '9' AND status IN ('0','1' ) AND k.is_header = '0' HAVING
ENCODE(k.messageblk::bytea,'escape') ILIKE '%Cuculowskyj%'] : [ERROR:
column "m.message_idnr" must appear in the GROUP BY clause or be used in
an aggregate function ]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Error
dbmail-mailbox.c,mailbox_search: could not execute query
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
dbmail-mailbox.c,_do_search: [136119704] depth [2] type [9] rows [0]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
dbmail-mailbox.c,_merge_search: [135459360] depth [1] type [1]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
dbmail-mailbox.c,_merge_search: [136115440] depth [2] type [2]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
misc.c,g_tree_merge: a[1008] [AND] b[1008] -> a[1008]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
dbmail-mailbox.c,_merge_search: [136119704] depth [2] type [9]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug
dbmail-mailbox.c,dbmail_mailbox_search: found [1008] ids
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug RESPONSE: [*
SEARCH 7117 7119 7127 7129 7143 7147 7149 7153 7173 7175 7185 7187 7189
7195 7207 7209 7211 7213 ...]
Jul 16 11:09:43 localhost dbmail/imap4d[15092]: Debug RESPONSE: [^M 5 OK
SEARCH completed^M ]
