Won't hurt to check, but a SQLException would normally be raised in that case.
On 03-01-15 11:29, Jorge Bastos wrote: > 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 <mailto: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 <mailto: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 > -- ________________________________________________________________ Paul J Stevens pjstevns @ gmail, twitter, github, linkedin www.nfg.nl/i...@nfg.nl/+31.85.877.99.97 _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
