I'm still freaking out, but this time the problems isn't the message base (at least I hope).
When I login using Mac OS X's Mail in IMAP after just a few minutes the account becomes unavailable. I have to accounts on the same server. Sometimes one is available and the other isnt', some time the other way around, sometimes none of them is available, sometimes they suddenly are both available again. I did a Trace 5 and found this: Info:[imap] imap4.c,IMAPClientHandler(+195): COMMAND: [3 SELECT Drafts] Debug:[imapsession] dbmail-imapsession.c,build_args_array_ext(+2210): arg[0]: 'Drafts' Info:[imap] imap4.c,IMAPClientHandler(+308): Executing command select... Debug:[db] db.c,db_findmailbox(+2465): looking for mailbox with FQN [Drafts]. Debug:[sql] dbmysql.c,db_query(+286): query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name LIKE 'Drafts' AND owner_idnr=32] Debug:[db] db.c,db_acl_has_right(+4204): checking ACL [read_flag] for user [32] on mailbox [183] Debug:[sql] dbmysql.c,db_query(+286): query [SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = 183] Debug:[db] db.c,db_acl_has_right(+4214): mailbox [183] is owned by user [32], is that also [32]? Debug:[db] db.c,db_acl_has_right(+4218): mailbox [183] is owned by user [32], giving all rights Debug:[sql] dbmysql.c,db_query(+286): query [SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = 183]Debug:[sql] dbmysql.c,db_query(+286): query [SELECT permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = 183]Debug:[sql] dbmysql.c,db_query(+286): query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr=183 AND (status < 2) UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr=183 AND (status < 2) AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr=183 AND (status < 2) AND recent_flag=1] Debug:[sql] dbmysql.c,db_query(+286): query [SELECT message_idnr+1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1]Debug:[sql] dbmysql.c,db_query(+286): query [SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = 183 AND status IN (0,1) ORDER BY message_idnr] Debug:[mailbox] dbmail-mailbox.c,mailbox_build_uid_map(+156): ids [0], msn [0] ** (process:53780): CRITICAL **: dbmail_imap_session_get_msginfo: assertion `ids && g_tree_nnodes(ids)>0' failed Debug:[imapsession] dbmail-imapsession.c,dbmail_imap_session_mailbox_open(+1722): unable to retrieve msginfo Maybe there's some relation? I also noted that when I close Mail the server still keeps the socket connected... and if I open back Mail just a few minutes later then the stupid locking issue on the dbmail_users (update on last login) pops in and Mail becomes irresponsible. The only solution to have my accounts available again at all is then restart dbmail-imapd. 1) I'll upgrade dbmail (it's 2.2.4 now) as soon as a new port from freebsd is available 2) maybe there's some issue with freebsd sockets? _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
