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
(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
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
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: 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
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
