Andrea,
Do you have the seq column in dbmail_mailboxes? From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On Behalf Of Alan Hicks Sent: sábado, 3 de Janeiro de 2015 10:22 To: DBMail mailinglist Subject: Re: [Dbmail] Segmentation Fault with dbmail 3.2.1 (FreeBSD) Perhaps something else has changed? You might try rebuilding/reinstalling dependent libraries including zdb and the database libraries, I understand that PostgreSQL has recently been updated to 9.3 which may have had an affect. That you have the same segfault with 3.2.0 suggests it is a related library rather than dbmail. You can check to see which libraries are linked using ldd /usr/local/sbin/dbmail-imapd I run my own poudriere build so can only confirm that my experience with 3.2.1 is that it is the most stable release to date and have not seen any segfaults. Regards, Alan On 02/01/2015 15:09, Andrea Brancatelli wrote: We tried to switch to 3.2.0 on an older machine but it segfaults the same… Please, we need some help! ------- Andrea Brancatelli Schema 31 S.p.a. Responsabile IT ROMA - FIRENZE - PALERMO ITALY Tel: +39. 06.98.358.472 Cell: +39 331.2488468 Fax: +39. 055.71.880.466 Società del Gruppo SC31 ITALIA Il giorno 29 dicembre 2014 @ 10:35:54, Andrea Brancatelli (abrancate...@schema31.it) ha scritto: Hello everybody. We recently upgraded from 3.1.17 to 3.2.1 on two different machines and we’re now facing continuous segmentation faults both in dbmail-imapd and dbmail-lmtpd (on both machines). We don’t have dbmail-pop3d active but I suppose that would be crashing too :-) The machine is a FreeBSD 10.1, I suspect there’s something strange going on with libzdb. Last line in dbmail.err is always the same when dbmail crashes: Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Database:[db] db_con_clear(+349): [0x80506f6f0] connection cleared Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Database:[db] db_stmt_prepare(+477): [0x80506f6f0] [SELECT MAX(message_idnr)+1 FROM dbmail_messages WHERE mailbox_idnr=?] Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Database:[db] db_stmt_set_u64(+497): [0x80516cd20] 1:[1142] Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Database:[db] db_commit_transaction(+606): COMMIT Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Database:[db] db_con_close(+342): [0x80506f6f0] connection to pool Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Debug:[MailboxState] MailboxState_hasPermission(+973): checking ACL [read_flag] for user [137] on mailbox [1142] Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Database:[db] db_con_get(+314): [0x80506f6f0] connection from pool Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Database:[db] db_stmt_prepare(+477): [0x80506f6f0] [SELECT * FROM dbmail_acl WHERE user_id = ? AND mailbox_id = ?] Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Database:[db] db_stmt_set_u64(+497): [0x80516cd20] 1:[137] Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Database:[db] db_stmt_set_u64(+497): [0x80516cd20] 2:[1142] Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Database:[db] db_con_close(+342): [0x80506f6f0] connection to pool Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Debug:[MailboxState] MailboxState_hasPermission(+1007): mailbox [1142] is owned by user [137]and no ACL in place. Giving all rights Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Debug:[imap] mailbox_check_acl(+369): access granted Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Database:[db] db_con_get(+314): [0x80506f6f0] connection from pool Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Database:[db] db_stmt_prepare(+477): [0x80506f6f0] [SELECT name,seq FROM dbmail_mailboxes WHERE mailbox_idnr=?] Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Database:[db] db_stmt_set_u64(+497): [0x80516cd20] 1:[1142] Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Debug:[MailboxState] db_getmailbox_seq(+878): id: [1142] name: [Drafts] seq [11334] Dec 29 10:30:30 rubidio.roma.sc dbmail-imapd[49852]: [0x80500a540] Database:[db] db_con_close(+342): [0x80506f6f0] connection to pool There’s no dbmail-imapd.core or anything. The chain is the usual one: stunnel -> dbmail -> mysql 5.6 The machine is pretty busy but not super busy, after all it’s 29 dic. What can I look for? Thank you. ------- Andrea Brancatelli _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail -- Persistent Objects Ltd 128 Lilleshall Road Morden SM4 6DR The Home of Lasting Solutions Mobile: +44 79 3030 5004 Tel: +44 20 8544 5292 Web: p-o.co.uk Skype: alan-hicks-london Personal blog https://plus.google.com/+AlanHicksLondon Company blog https://plus.google.com/+PoCoUkLondon/posts LinkedIn https://uk.linkedin.com/in/alanhickslondon/ GitHub https://github.com/alan-hicks
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
