Re: Segmentation Fault with dbmail 3.2.1 (FreeBSD)

Hello Andrea,

Your libraries glib, gettext-runtime, mhash, libevent2, libzdb, 
libiconv, pcre, libffi and mysql56-client appear ok, the only difference 
is you have libc++, libcssrt and libgcc_s and I have ldap and 
postgresql.  I assume everything is build using clang.  Also I'm running 
ancient 32bit hardware.

Do you have IPv6, I remember getting an error as the authlog table 
needed larger columns for src_ip and dst_ip when I started using IPv6.

Other than that it may be an edge case with data in which case Paul is 
better able to help.

Kind regards,
Alan

% ldd /usr/local/sbin/dbmail-imapd
/usr/local/sbin/dbmail-imapd:
         libcrypt.so.5 => /lib/libcrypt.so.5 (0x2808b000)
         libgmodule-2.0.so.0 => /usr/local/lib/libgmodule-2.0.so.0 
(0x280af000)
         libgmime-2.6.so.0 => /usr/local/lib/libgmime-2.6.so.0 (0x280b2000)
         libgio-2.0.so.0 => /usr/local/lib/libgio-2.0.so.0 (0x28115000)
         libgobject-2.0.so.0 => /usr/local/lib/libgobject-2.0.so.0 
(0x28252000)
         libgthread-2.0.so.0 => /usr/local/lib/libgthread-2.0.so.0 
(0x28291000)
         libglib-2.0.so.0 => /usr/local/lib/libglib-2.0.so.0 (0x28293000)
         libintl.so.8 => /usr/local/lib/libintl.so.8 (0x28387000)
         libm.so.5 => /lib/libm.so.5 (0x28390000)
         libmhash.so.2 => /usr/local/lib/libmhash.so.2 (0x283b6000)
         libevent_pthreads-2.0.so.5 => 
/usr/local/lib/libevent_pthreads-2.0.so.5 (0x283e4000)
         libevent-2.0.so.5 => /usr/local/lib/libevent-2.0.so.5 (0x283e6000)
         libzdb.so.11 => /usr/local/lib/libzdb.so.11 (0x28423000)
         libdbmail.so.0 => /usr/local/lib/dbmail/libdbmail.so.0 (0x28435000)
         libldap_r-2.4.so.2 => /usr/local/lib/libldap_r-2.4.so.2 
(0x284a9000)
         libthr.so.3 => /lib/libthr.so.3 (0x284f1000)
         libc.so.7 => /lib/libc.so.7 (0x28513000)
         libiconv.so.2 => /usr/local/lib/libiconv.so.2 (0x28686000)
         libpcre.so.1 => /usr/local/lib/libpcre.so.1 (0x2877a000)
         libz.so.6 => /lib/libz.so.6 (0x287ef000)
         libffi.so.6 => /usr/local/lib/libffi.so.6 (0x28803000)
         libpq.so.5 => /usr/local/lib/libpq.so.5 (0x28809000)
         libssl.so.7 => /usr/lib/libssl.so.7 (0x28830000)
         libcrypto.so.7 => /lib/libcrypto.so.7 (0x2888c000)
         liblber-2.4.so.2 => /usr/local/lib/liblber-2.4.so.2 (0x28a1b000)


On 03/01/2015 17:21, Andrea Brancatelli wrote:
>
> 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
>>     ([email protected] <mailto:[email protected]>) 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
>>     [email protected]
>>     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 bloghttps://plus.google.com/+AlanHicksLondon
>> Company bloghttps://plus.google.com/+PoCoUkLondon/posts
>> LinkedInhttps://uk.linkedin.com/in/alanhickslondon/
>> GitHubhttps://github.com/alan-hicks
>>
>> _______________________________________________
>> DBmail mailing list
>> [email protected]  <mailto:[email protected]>
>> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

-- 
Persistent Objects Ltd
128 Lilleshall Road
Morden SM4 6DR

The Home of Lasting Solutions

Mobile: 079 3030 5004
Tel:    020 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
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail