[DBMail 0000723]: simultaneous mailbox creation

[bugtrack]

The following issue has been RESOLVED.
======================================================================
http://www.dbmail.org/mantis/view.php?id=723 
======================================================================
Reported By:                hinote
Assigned To:                paul
======================================================================
Project:                    DBMail
Issue ID:                   723
Category:                   Database layer
Reproducibility:            sometimes
Severity:                   major
Priority:                   normal
Status:                     resolved
target:                      
Resolution:                 fixed
Fixed in Version:           2.2.11
======================================================================
Date Submitted:             01-Sep-08 14:57 CEST
Last Modified:              05-Oct-08 12:16 CEST
======================================================================
Summary:                    simultaneous mailbox creation
Description:
When multiple dbmail processes start creating new mailbox (this can happen
via IMAP by user client command or with dbmail-smtp run with -M option) at
the same time, only first db_createmailbox() run correctly, others return
error. With dbmail-smtp, messages are rejected and not submitted into
dbmail since the INSERT query fails.

The db_createmailbox() function should check the mailbox for existence
after unsuccessful attempt to run the INSERT query.

======================================================================

----------------------------------------------------------------------
 hinote - 01-Sep-08 20:52  
----------------------------------------------------------------------
the bug causes following error messages:

Aug 29 12:00:00 maildb dbmail/smtp[32104]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [INSERT INTO dbmail_mailboxes
(name, owner_idnr,seen_flag, answered_flag, deleted_flag, flagged_flag,
recent_flag, draft_flag, permission) VALUES ('INBOX/Spam
Archive/2008-08-29/1200-1259', 4, 1, 1, 1, 1, 1, 1, 1)] : [ERROR:
duplicate key value violates unique constraint
"dbmail_mailboxes_owner_name_idx" ]
Aug 29 12:00:00 maildb dbmail/smtp[32104]: Error:[db]
db.c,db_createmailbox(+3446): could not create mailbox
Aug 29 12:00:00 maildb dbmail/smtp[32104]: Error:[db]
db.c,db_find_create_mailbox(+3509): could not create mailbox [INBOX/Spam
Archive/2008-08-29/1200-1259] because [Database error while creating]
Aug 29 12:00:00 maildb dbmail/smtp[32104]: Error:[sort]
sort.c,sort_deliver_to_mailbox(+131): mailbox [INBOX/Spam
Archive/2008-08-29/1200-1259] not found

----------------------------------------------------------------------
 hinote - 02-Sep-08 18:46  
----------------------------------------------------------------------
The db_subscribe() function may also fail due to the same reason -
simultaneous attempts to make INSERT query to add subscription.
The dbmail-createmailbox-2.patch attached is a cumulative patch for
dbmail-2.2.10 which fixes both problems (with mailbox creation and mailbox
subscription performed by different dbmail processed at the same time).

Other INSERT and DELETE queries that deal with mailboxes should be
reviewed carefully as well (todo).

----------------------------------------------------------------------
 paul - 05-Oct-08 12:15  
----------------------------------------------------------------------
patch accepted - minus the change in trace level.

Issue History
Date Modified   Username       Field                    Change              
======================================================================
01-Sep-08 14:57 hinote         New Issue                                    
01-Sep-08 14:57 hinote         File Added: dbmail-createmailbox.patch          
       
01-Sep-08 15:05 jasb           Issue Monitored: jasb                        
01-Sep-08 20:52 hinote         Note Added: 0002592                          
02-Sep-08 18:46 hinote         File Added: dbmail-createmailbox-2.patch        
         
02-Sep-08 18:46 hinote         Note Added: 0002594                          
05-Oct-08 12:15 paul           Note Added: 0002615                          
05-Oct-08 12:16 paul           Assigned To               => paul            
05-Oct-08 12:16 paul           Status                   new => resolved    
05-Oct-08 12:16 paul           Resolution               open => fixed      
05-Oct-08 12:16 paul           Fixed in Version          => 2.2.11          
======================================================================

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@...
http://twister.fastxs.net/mailman/listinfo/dbmail-dev