Problems with nodes in a cluster


#1

I have a problem with a node, my couchbase version is 4.0 when I have a node everything works fine but when I add more of my cluster node gets really slow these are my indices:

archive 192.168.0.57:8091 Index_messageId_uniqueId2 Ready 100%
Definition: CREATE INDEX Index_messageId_uniqueId2 ON archive(messageId,uniqueId) WHERE (type = MailSource) USING GSI
archive 192.168.0.57:8091 Index_uniqueId2 Ready 100%
Definition: CREATE INDEX Index_uniqueId2 ON archive(uniqueId) WHERE (type = MailSource) USING GSI
archive 192.168.0.57:8091 archive-primary-index Ready 100%
Definition: CREATE PRIMARY INDEX archive-primary-index ON archive USING GSI
archive 192.168.0.57:8091 archive_primary_index2 Ready 100%
Definition: CREATE PRIMARY INDEX archive_primary_index2 ON archive USING GSI
archive 192.168.0.58:8091 Index_messageId Ready 100%
Definition: CREATE INDEX Index_messageId ON archive(messageId) WHERE (type = MailSource) USING GSI
archive 192.168.0.58:8091 Index_messageId2 Ready 100%
Definition: CREATE INDEX Index_messageId2 ON archive(messageId) WHERE (type = MailSource) USING GSI
archive 192.168.0.58:8091 Index_messageId_uniqueId Ready 100%
Definition: CREATE INDEX Index_messageId_uniqueId ON archive(messageId,uniqueId) WHERE (type = MailSource) USING GSI
archive 192.168.0.58:8091 Index_uniqueId Ready 100%
Definition: CREATE INDEX Index_uniqueId ON archive(uniqueId) WHERE (type = MailSource) USING GSI

and this is the poco of my class.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ConsusBO
{
public class MailSource:IDisposable
{

    public MailSource()
    {
        FromAdrress = new Person();
        ToAddress = new MailAddressSource();
        ReplyToAddress = new MailAddressSource();
        CC = new MailAddressSource();
        Bcc = new MailAddressSource();
        AttachmentList = new List<FileAttach>();
        Folders = new List<string>();
        Viewers = new List<Viewers>();
        Headers = new Dictionary<string, string>();
    }
    public string Type { get { return "MailSource"; } }
    public Dictionary<string,string> Headers { get; set; }
    public string Id {get; set;}
    public string MessageId { get; set; }
    public string UniqueId { get; set; }
    public string Subject {get; set;}
    public Person FromAdrress {get;set;}
    public MailAddressSource ToAddress {get;  set;}
    public MailAddressSource ReplyToAddress {get; set;}
    public MailAddressSource CC { get;  set; }
    public MailAddressSource Bcc { get;  set; }
    public DateTime Date { get; set; }
    public string Body { get; set; }
    public string HtmlBody { get; set; }
    public bool IsBodyHtml { get; set; }
    public List<FileAttach> AttachmentList { get;  set; }
    public List<string> Folders { get;  set; }
    public DateTime MailArchiveDate { get; set; }
    public List<Viewers> Viewers { get; set; }
    public void Dispose()
    {
        GC.SuppressFinalize(this);
    }
}

}


#2

Could you also show how you are connecting to the Couchbase Cluster and how you are getting the bucket?

Also, could you be more specific about what’s running slowly? Are you getting single documents? Are you running a N1QL query? Are you using Linq2Couchbase? You may want to turn on logging and post that information here as well.


#3

Any query that lasts more than 30 minutes



#4

My mistake seconds …!!


#5

Could you try an EXPLAIN on those queries to see what indexes are being used?