Results 1 to 2 of 2

Thread: com.zimbra.common.soap.SoapFaultException: no such account

Hybrid View

  1. #1
    Join Date
    Jun 2009
    Posts
    31
    Rep Power
    6

    Default com.zimbra.common.soap.SoapFaultException: no such account

    hi,

    while performing a zmblobchk -v start i get this error on one account:

    Code:
    com.zimbra.common.soap.SoapFaultException: no such account: bedeeea4-28d5-47dd-8324-224372904fec
    ExceptionId:btpool0-1445://localhost:7071/service/admin/soap/CheckBlobConsistencyRequest:1366203506901:17069ce5097f7a46
    Code:account.NO_SUCH_ACCOUNT
    	at com.zimbra.common.soap.Soap12Protocol.soapFault(Soap12Protocol.java:88)
    	at com.zimbra.common.soap.SoapTransport.extractBodyElement(SoapTransport.java:354)
    	at com.zimbra.common.soap.SoapTransport.parseSoapResponse(SoapTransport.java:313)
    	at com.zimbra.common.soap.SoapHttpTransport.invoke(SoapHttpTransport.java:260)
    	at com.zimbra.common.soap.SoapHttpTransport.invoke(SoapHttpTransport.java:164)
    	at com.zimbra.common.soap.SoapTransport.invoke(SoapTransport.java:407)
    	at com.zimbra.common.soap.SoapTransport.invokeWithoutSession(SoapTransport.java:393)
    	at com.zimbra.cs.account.soap.SoapProvisioning.invokeRequest(SoapProvisioning.java:342)
    	at com.zimbra.cs.account.soap.SoapProvisioning.invoke(SoapProvisioning.java:350)
    	at com.zimbra.cs.store.file.BlobConsistencyUtil.checkMailbox(BlobConsistencyUtil.java:207)
    	at com.zimbra.cs.store.file.BlobConsistencyUtil.run(BlobConsistencyUtil.java:179)
    	at com.zimbra.cs.store.file.BlobConsistencyUtil.main(BlobConsistencyUtil.java:282)

    This installation is new but several accounts/domains have been imported from an old installation, so I suspect this is dirty information from an old account.

    how can I totally remove that account?

    I was thinking about modifying ldap directly, but I would like to be sure before proceding.



    Release 7.2.1_GA_2790.UBUNTU10_64 UBUNTU10_64 FOSS edition.

  2. #2
    Join Date
    Jan 2008
    Location
    Berlin, Germany
    Posts
    203
    Rep Power
    7

    Default

    ... it looks like there's stale data in your MySQL Database. You can check this by looking into the dabase directly. As the zimbra user run a MySQL shell "mysql"

    Code:
    mysql> use zimbra;
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    
    Database changed
    mysql> select * from mailbox where account_id="bedeeea4-28d5-47dd-8324-224372904fec"\G
    *************************** 1. row ***************************
                    id: 869
              group_id: 69
            account_id: bedeeea4-28d5-47dd-8324-224372904fec
       index_volume_id: 2
    item_id_checkpoint: 256
         contact_count: 0
       size_checkpoint: 0
     change_checkpoint: 1
         tracking_sync: 0
         tracking_imap: 0
        last_backup_at: NULL
               comment: john.doe@test.com
      last_soap_access: 0
          new_messages: 0
    idx_deferred_count: 0
       highest_indexed: 0
    1 row in set (0.00 sec)
    should give you the details. You may then delete the stale data from the database:

    Code:
    delete from mailbox where account_id ="bedeeea4-28d5-47dd-8324-224372904fec";
    will most likely result in an error message like "ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails". You have to check table by table if there's other stale data related to the non-existing account and delete that too.

    Please be careful when deleting data! No warranty for any damage.
    Best regards

    Andreas Wolske

    managedhosting.de GmbH

    Zimbra Cloud Hosting, Consulting & Support
    VMware vCloud Powered Serviceprovider

Similar Threads

  1. Replies: 6
    Last Post: 03-24-2014, 10:41 PM
  2. Replies: 1
    Last Post: 04-13-2012, 12:32 PM
  3. Replies: 0
    Last Post: 07-04-2009, 07:57 AM
  4. Replies: 0
    Last Post: 07-04-2009, 07:57 AM
  5. Common mailbox (or mail account) for some users
    By santiago78 in forum Administrators
    Replies: 6
    Last Post: 10-27-2008, 04:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •