Hello Alan.
We're using MySQL, not pgSQL. We have three different machines all exposing the same behavior. One of them (the main one) has DBMail compiled from ports against MySQL 5.6, and this is it's LDD: root@rubidio:/home/abrancatelli # ldd /usr/local/sbin/dbmail-imapd /usr/local/sbin/dbmail-imapd: libcrypt.so.5 => /lib/libcrypt.so.5 (0x800835000) libgmodule-2.0.so.0 => /usr/local/lib/libgmodule-2.0.so.0 (0x800a55000) libgmime-2.6.so.0 => /usr/local/lib/libgmime-2.6.so.0 (0x800c58000) libgio-2.0.so.0 => /usr/local/lib/libgio-2.0.so.0 (0x800ec7000) libgobject-2.0.so.0 => /usr/local/lib/libgobject-2.0.so.0 (0x80122b000) libgthread-2.0.so.0 => /usr/local/lib/libgthread-2.0.so.0 (0x801473000) libglib-2.0.so.0 => /usr/local/lib/libglib-2.0.so.0 (0x801674000) libintl.so.8 => /usr/local/lib/libintl.so.8 (0x801979000) libm.so.5 => /lib/libm.so.5 (0x801b83000) libmhash.so.2 => /usr/local/lib/libmhash.so.2 (0x801da9000) libevent_pthreads-2.0.so.5 => /usr/local/lib/libevent_pthreads-2.0.so.5 (0x801fd3000) libevent-2.0.so.5 => /usr/local/lib/libevent-2.0.so.5 (0x8021d5000) libzdb.so.11 => /usr/local/lib/libzdb.so.11 (0x802416000) libdbmail.so.0 => /usr/local/lib/dbmail/libdbmail.so.0 (0x80262a000) libthr.so.3 => /lib/libthr.so.3 (0x8028a0000) libc.so.7 => /lib/libc.so.7 (0x802ac5000) libiconv.so.2 => /usr/local/lib/libiconv.so.2 (0x802e5e000) libpcre.so.1 => /usr/local/lib/libpcre.so.1 (0x803157000) libz.so.6 => /lib/libz.so.6 (0x8033c4000) libffi.so.6 => /usr/local/lib/libffi.so.6 (0x8035d9000) libmysqlclient.so.18 => /usr/local/lib/mysql/libmysqlclient.so.18 (0x8037e0000) libssl.so.7 => /usr/lib/libssl.so.7 (0x803db9000) libcrypto.so.7 => /lib/libcrypto.so.7 (0x804023000) libc++.so.1 => /usr/lib/libc++.so.1 (0x80440e000) libcxxrt.so.1 => /lib/libcxxrt.so.1 (0x8046c9000) libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x8048e3000) The other two machines were it was segfaulting had DBMail installed from PKG against MySQL 5.5.We tried to upgrade those as well to 3.2.1 but the problem is still there. That's the LDD from these machines. root@sc31-mx-01:~ # ldd /usr/local/sbin/dbmail-imapd /usr/local/sbin/dbmail-imapd: libcrypt.so.5 => /lib/libcrypt.so.5 (0x800835000) libgmodule-2.0.so.0 => /usr/local/lib/libgmodule-2.0.so.0 (0x800a55000) libgmime-2.6.so.0 => /usr/local/lib/libgmime-2.6.so.0 (0x800c58000) libgio-2.0.so.0 => /usr/local/lib/libgio-2.0.so.0 (0x800ec7000) libgobject-2.0.so.0 => /usr/local/lib/libgobject-2.0.so.0 (0x80122b000) libgthread-2.0.so.0 => /usr/local/lib/libgthread-2.0.so.0 (0x801473000) libglib-2.0.so.0 => /usr/local/lib/libglib-2.0.so.0 (0x801674000) libintl.so.8 => /usr/local/lib/libintl.so.8 (0x801979000) libm.so.5 => /lib/libm.so.5 (0x801b83000) libmhash.so.2 => /usr/local/lib/libmhash.so.2 (0x801da9000) libevent_pthreads-2.0.so.5 => /usr/local/lib/libevent_pthreads-2.0.so.5 (0x801fd3000) libevent-2.0.so.5 => /usr/local/lib/libevent-2.0.so.5 (0x8021d5000) libzdb.so.11 => /usr/local/lib/libzdb.so.11 (0x802416000) libdbmail.so.0 => /usr/local/lib/dbmail/libdbmail.so.0 (0x802632000) libthr.so.3 => /lib/libthr.so.3 (0x8028a8000) libc.so.7 => /lib/libc.so.7 (0x802acd000) libiconv.so.2 => /usr/local/lib/libiconv.so.2 (0x802e76000) libpcre.so.1 => /usr/local/lib/libpcre.so.1 (0x80316f000) libz.so.6 => /lib/libz.so.6 (0x8033dc000) libffi.so.6 => /usr/local/lib/libffi.so.6 (0x8035f1000) libpq.so.5 => /usr/local/lib/libpq.so.5 (0x8037f8000) libsqlite3.so.0 => /usr/local/lib/libsqlite3.so.0 (0x803a25000) libmysqlclient.so.18 => /usr/local/lib/mysql/libmysqlclient.so.18 (0x803d16000) libssl.so.7 => /usr/lib/libssl.so.7 (0x804283000) libcrypto.so.7 => /lib/libcrypto.so.7 (0x8044ee000) libc++.so.1 => /usr/lib/libc++.so.1 (0x8048e1000) libcxxrt.so.1 => /lib/libcxxrt.so.1 (0x804b9c000) libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x804db6000) I didn't read it but I suppose it to be pretty similar (the same?). BTW, if I can point my finger toward something external to dbmail, my guess would be gmime26-2.6.20. Thanks --- Andrea Brancatelli Schema31 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 2015-01-03 11:22 Alan Hicks ha scritto: > 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 [1] -- 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 [2] Company blog https://plus.google.com/+PoCoUkLondon/posts [3] LinkedIn https://uk.linkedin.com/in/alanhickslondon/ [4] GitHub https://github.com/alan-hicks [5] _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail [1] Links: ------ [1] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail [2] https://plus.google.com/+AlanHicksLondon [3] https://plus.google.com/+PoCoUkLondon/posts [4] https://uk.linkedin.com/in/alanhickslondon/ [5] https://github.com/alan-hicks
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
