Re: Segmentation Fault with dbmail 3.2.1 (FreeBSD)

 

We do. 

mysql [localhost] {root} (dbmail) > desc dbmail_mailboxes; 

+---------------+---------------------+------+-----+---------+----------------+


| Field | Type | Null | Key | Default | Extra | 

+---------------+---------------------+------+-----+---------+----------------+


| mailbox_idnr | bigint(20) unsigned | NO | PRI | NULL | auto_increment
| 

| owner_idnr | bigint(20) unsigned | NO | MUL | 0 | | 

| name | varchar(255) | NO | MUL | | | 

| seen_flag | tinyint(1) | NO | | 0 | | 

| answered_flag | tinyint(1) | NO | | 0 | | 

| deleted_flag | tinyint(1) | NO | | 0 | | 

| flagged_flag | tinyint(1) | NO | | 0 | | 

| recent_flag | tinyint(1) | NO | | 0 | | 

| draft_flag | tinyint(1) | NO | | 0 | | 

| no_inferiors | tinyint(1) | NO | | 0 | | 

| no_select | tinyint(1) | NO | | 0 | | 

| permission | tinyint(1) | YES | | 2 | | 

| seq | bigint(20) | NO | MUL | 0 | | 

+---------------+---------------------+------+-----+---------+----------------+


13 rows in set (0.02 sec) 

---

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:29 Jorge Bastos ha scritto: 

> Andrea, 
> 
> Do you have the seq column in dbmail_mailboxes? 
> 
> FROM: [email protected] [mailto:[email protected]] 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 ([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 [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
[email protected]
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
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail