Paul J Stevens wrote:
Taking foot out of mouth... Searching should work just fine, it's just
the sorting that's broken.
Looks like you hit a bug Tommi. Please try 2.0.5 or a recent snapshot,
set trace_level to 5 and post the resulting logs.
Ok, I did the 2.0 snapshot from aug.18, and now with trace 5. It still
seems to crash.
-- clip --
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: COMMAND: [00000003 SELECT
INBOX]
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: arg[0]: 'INBOX'
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: IMAPClientHandler():
Executing command select...
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: db.c,db_findmailbox:
looking for mailbox with FQN [INBOX].
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: dbmysql.c,db_query:
executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE
name='INBOX' AND owner_idnr='5']
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: db.c,db_acl_has_right:
checking ACL for user [5] on mailbox [7]
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: dbmysql.c,db_query:
executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE
mailbox_idnr = '7' AND owner_idnr = '5']
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: dbmysql.c,db_query:
executing query [SELECT no_select FROM dbmail_mailboxes WHERE
mailbox_idnr = '7']
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: dbmysql.c,db_query:
executing query [SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '7']
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: dbmysql.c,db_query:
executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='7' AND (status='0' OR status='1') UNION SELECT
'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='7' AND (status='0'
OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM
dbmail_messages WHERE mailbox_idnr='7' AND (status='0' OR status='1')
AND recent_flag=1]
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: dbmysql.c,db_query:
executing query [SELECT message_idnr + 1 FROM dbmail_messages ORDER BY
message_idnr DESC LIMIT 1]
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: dbmysql.c, db_get_result:
row = 0, field = 0, bigger than size of result set
Aug 18 13:29:03 vanessa kernel: Aug 18 13:29:03 vanessa
dbmail/imap4d[78955]: dbmysql.c, db_get_result: row = 0, field = 0,
bigger than size of result set
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: dbmysql.c,db_query:
executing query [SELECT MIN(message_idnr) FROM dbmail_messages WHERE
mailbox_idnr = '7' AND status < '2' AND seen_flag = '0']
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: dbmysql.c,db_get_result:
result is null
Aug 18 13:29:03 vanessa kernel: Aug 18 13:29:03 vanessa
dbmail/imap4d[78955]: dbmysql.c,db_get_result: result is null
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: IMAPClientHandler():
Finished command select
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: dbmysql.c,db_query:
executing query [SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '7']
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: dbmysql.c,db_query:
executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='7' AND (status='0' OR status='1') UNION SELECT
'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='7' AND (status='0'
OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM
dbmail_messages WHERE mailbox_idnr='7' AND (status='0' OR status='1')
AND recent_flag=1]
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: dbmysql.c,db_query:
executing query [SELECT message_idnr + 1 FROM dbmail_messages ORDER BY
message_idnr DESC LIMIT 1]
Aug 18 13:29:03 vanessa dbmail/imap4d[78955]: dbmysql.c, db_get_result:
row = 0, field = 0, bigger than size of result set
Aug 18 13:29:03 vanessa kernel: Aug 18 13:29:03 vanessa
dbmail/imap4d[78955]: dbmysql.c, db_get_result: row = 0, field = 0,
bigger than size of result set
Aug 18 13:29:22 vanessa dbmail/imap4d[78955]: IMAPClientHandler(): line
read for PID 78955
Aug 18 13:29:22 vanessa dbmail/imap4d[78955]: COMMAND: [00000004 SEARCH
OR (UNDELETED UNSEEN) (FLAGGED)]
Aug 18 13:29:22 vanessa dbmail/imap4d[78955]: arg[0]: 'OR'
Aug 18 13:29:22 vanessa dbmail/imap4d[78955]: arg[1]: '('
Aug 18 13:29:22 vanessa dbmail/imap4d[78955]: arg[2]: 'UNDELETED'
Aug 18 13:29:22 vanessa dbmail/imap4d[78955]: arg[3]: 'UNSEEN'
Aug 18 13:29:22 vanessa dbmail/imap4d[78955]: arg[4]: ')'
Aug 18 13:29:22 vanessa dbmail/imap4d[78955]: arg[5]: '('
Aug 18 13:29:22 vanessa dbmail/imap4d[78955]: arg[6]: 'FLAGGED'
Aug 18 13:29:22 vanessa dbmail/imap4d[78955]: arg[7]: ')'
Aug 18 13:29:22 vanessa dbmail/imap4d[78955]: IMAPClientHandler():
Executing command search...
Aug 18 13:29:22 vanessa dbmail/imap4d[78955]: db.c,db_acl_has_right:
checking ACL for user [5] on mailbox [7]
Aug 18 13:29:22 vanessa dbmail/imap4d[78955]: dbmysql.c,db_query:
executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE
mailbox_idnr = '7' AND owner_idnr = '5']
Aug 18 13:29:22 vanessa dbmail/imap4d[78955]:
serverchild.c,active_child_sig_handler: got signal [11]
Aug 18 13:29:22 vanessa kernel: Aug 18 13:29:22 vanessa
dbmail/imap4d[78955]: serverchild.c,active_child_sig_handler: got signal
[11]
Aug 18 13:29:22 vanessa dbmail/imap4d[78955]:
serverchild.c,active_child_sig_handler: cannot ignore this. Terminating
Aug 18 13:29:22 vanessa dbmail/imap4d[78955]: pool.c,child_unregister:
child [78955] unregistered
Aug 18 13:29:22 vanessa kernel: Aug 18 13:29:22 vanessa
dbmail/imap4d[78955]: pool.c,child_unregister: child [78955] unregistered
Aug 18 13:29:22 vanessa dbmail/imap4d[78928]: ParentSigHandler(): got
signal [20]
-- clip --
--
br,
Tommi
