A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=614 ====================================================================== Reported By: Anne Assigned To: ====================================================================== Project: DBMail Issue ID: 614 Category: IMAP daemon Reproducibility: always Severity: crash Priority: normal Status: new target: ====================================================================== Date Submitted: 23-Jun-07 09:47 CEST Last Modified: 26-Jun-07 14:23 CEST ====================================================================== Summary: dbmail-imapd exited on signal 11 Description: Jun 22 14:36:13 NBMS01 dbmail/imap4d[28379]: Info:[imap] imap4.c,IMAPClientHandler(+307): Finished command uid [0] Jun 22 14:46:13 NBMS01 dbmail/imap4d[28379]: Info:[imap] imap4.c,IMAPClientHandler(+175): COMMAND: [44 check] Jun 22 14:46:13 NBMS01 dbmail/imap4d[28379]: Info:[imap] imap4.c,IMAPClientHandler(+288): Executing command check... Jun 22 14:46:13 NBMS01 dbmail/imap4d[28379]: Debug:[db] db.c,db_acl_has_right(+4064): checking ACL [read_flag] for user [511] on mailbox [781] Jun 22 14:46:13 NBMS01 dbmail/imap4d[28379]: Debug:[db]db.c,db_acl_has_right(+4075): mailbox [781] is owned by user [511], giving all rights Jun 22 14:46:13 NBMS01 dbmail/imap4d[28379]: Debug:[sql] dbmysql.c,db_query(+290): query [SELECT message_idnr FROM dbmail _messages WHERE mailbox_idnr = 781 AND status IN (0,1) ORDER BY message_idnr] Jun 22 14:46:13 NBMS01 dbmail/imap4d[28379]: Debug:[mailbox] dbmail-mailbox.c,mailbox_build_uid_map(+180): ids [1], msn [1] Jun 22 14:46:13 NBMS01 dbmail/imap4d[28379]: Debug:[sql] dbmysql.c,db_query(+290): query [SELECT message_idnr FROM dbmail _messages WHERE mailbox_idnr = 781 AND status IN (0,1) ORDER BY message_idnr] Jun 22 14:46:13 NBMS01 dbmail/imap4d[28379]: Debug:[mailbox] dbmail-mailbox.c,mailbox_build_uid_map(+180): ids [1], msn [1] Jun 22 14:46:13 NBMS01 dbmail/imap4d[28379]: Debug:[sql] dbmysql.c,db_query(+290): query [SELECT permission,seen_flag,ans wered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = 781] Jun 22 14:46:13 NBMS01 dbmail/imap4d[28379]: Debug:[sql] dbmysql.c,db_query(+290): query [SELECT 'a',COUNT(*) FROM dbmail _messages WHERE mailbox_idnr=781 AND (status < 2) UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr=781 AND (status < 2) AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr=781 AND (status < 2) AND recent_flag=1] Jun 22 14:46:13 NBMS01 dbmail/imap4d[28379]: Debug:[sql] dbmysql.c,db_query(+290): query [SELECT message_idnr+1 FROM dbmail_messages WHERE mailbox_idnr=781 ORDER BY message_idnr DESC LIMIT 1] Jun 22 14:46:13 NBMS01 dbmail/imap4d[28379]: Debug:[sql] dbmysql.c,db_query(+290): query [SELECT seen_flag, answered_flag , deleted_flag, flagged_flag, draft_flag, recent_flag, DATE_FORMAT(internal_date, '%Y-%m-%d %T'), rfcsize, message_idnr FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr BETWEEN 22521495 AND 22521495 AND mailbox_idnr = 781 AND status IN (0,1) ORDER BY message_idnr ASC] Jun 22 14:46:13 NBMS01 kernel: pid 28379 (dbmail-imapd), uid 1000: exited on signal 11 ======================================================================
---------------------------------------------------------------------- Anne - 26-Jun-07 14:23 ---------------------------------------------------------------------- here's the same query crashing each time. Please advise if I can debug something. Jun 25 16:31:19 NBMS01 dbmail/imap4d[32458]: Debug:[sql] dbmysql.c,db_query(+290): query [SELECT see n_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag, DATE_FORMAT(internal_dat e, '%Y-%m-%d %T'), rfcsize, message_idnr FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr BETWEEN 20862680 AND 22678876 AND mailbox_idnr = 29 AND statu s IN (0,1) ORDER BY message_idnr ASC] Jun 25 16:31:19 NBMS01 kernel: pid 32458 (dbmail-imapd), uid 1000: exited on signal 11 Jun 26 09:50:02 NBMS01 dbmail/imap4d[71300]: Debug:[sql] dbmysql.c,db_query(+290): query [SELECT see n_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag, DATE_FORMAT(internal_dat e, '%Y-%m-%d %T'), rfcsize, message_idnr FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr BETWEEN 20862680 AND 22678876 AND mailbox_idnr = 29 AND statu s IN (0,1) ORDER BY message_idnr ASC] Jun 26 09:50:02 NBMS01 kernel: pid 71300 (dbmail-imapd), uid 1000: exited on signal 11 Jun 26 09:53:45 NBMS01 dbmail/imap4d[38112]: Debug:[sql] dbmysql.c,db_query(+290): query [SELECT see n_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag, DATE_FORMAT(internal_dat e, '%Y-%m-%d %T'), rfcsize, message_idnr FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr BETWEEN 20862680 AND 22678876 AND mailbox_idnr = 29 AND statu s IN (0,1) ORDER BY message_idnr ASC] Jun 26 09:53:45 NBMS01 kernel: pid 38112 (dbmail-imapd), uid 1000: exited on signal 11 Issue History Date Modified Username Field Change ====================================================================== 23-Jun-07 09:47 Anne New Issue 26-Jun-07 14:23 Anne Note Added: 0002263 ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
