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: 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) 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
