This is my serviceconfig.json of sync gateway. I am not sure whether this is the file which I should change. Initially I had made a ‘sync-gateway-config.json’ file inside examples folder with the same configuration but couldn’t get any result.
{
“adminInterface”: “127.0.0.1:4985”,
“interface”: “0.0.0.0:4984”,
“databases”: {
“grocery-sync”: {
“server”: “walrus:data”,
“server”: “http://localhost:8091”,
“bucket”: “grocery-sync”,
“username”: “username”,
“password”: “password”,
“enable_shared_bucket_access”: true,
“import_docs”: true,
“num_index_replicas”: 0,
“users”: {
“GUEST”: {“disabled”: false, “admin_channels”: ["*"] }
},
“allow_conflicts”: false,
“revs_limit”: 20
}
}
}
This is screenshot of couchbase server where I am getting some entries which are not as those on sync gateway. I am not sure where they are coming from
this is the sg_info.log.
2020-10-01T22:31:23.325+05:30 [INF] GoCBCustomSGTranscoder Opening Couchbase database grocery-sync on
2020-10-01T22:31:23.325+05:30 [INF] Auth: Attempting credential authentication localhost:8091?http_idle_conn_timeout=90000&http_max_idle_conns=64000&http_max_idle_conns_per_host=256&kv_pool_size=2&n1ql_timeout=75000&operation_tracing=false
2020-10-01T22:31:27.936+05:30 [INF] Error opening bucket grocery-sync: failed to connect to any of the specified hosts
2020-10-01T22:31:27.936+05:30 [WRN] RetryLoop for Attempt to connect to bucket : grocery-sync giving up after 14 attempts – base.RetryLoop() at util.go:382
2020-10-01T22:31:27.936+05:30 [ERR] Error opening database grocery-sync: 502 Unable to connect to Couchbase Server (connection refused). Please ensure it is running and reachable at the configured host and port. Detailed error: failed to connect to any of the specified hosts – rest.RunServer() at config.go:1028
2020-10-03T08:45:45.503+05:30 ==== Couchbase Sync Gateway/2.7.3(3;33d352f) CE ====
2020-10-03T08:45:45.423+05:30 ==== Couchbase Sync Gateway/2.7.3(3;33d352f) CE ====
2020-10-03T08:45:45.601+05:30 [INF] Logging: Console disabled
2020-10-03T08:45:45.601+05:30 [INF] Logging: Files to C:\Program Files\Couchbase\Sync Gateway\var\lib\couchbase\logs
2020-10-03T08:45:45.601+05:30 [INF] Logging: Console level: none
2020-10-03T08:45:45.601+05:30 [INF] Logging: Console keys: [HTTP]
2020-10-03T08:45:45.601+05:30 [INF] Logging: Redaction level: none
2020-10-03T08:45:45.601+05:30 [INF] Logging stats with frequency: 1m0s
2020-10-03T08:45:45.601+05:30 [INF] Opening db /grocery-sync as bucket “grocery-sync”, pool “default”, server ocalhost:8091>
2020-10-03T08:45:45.602+05:30 [INF] GoCBCustomSGTranscoder Opening Couchbase database grocery-sync on ocalhost:8091> as user “username”
2020-10-03T08:45:45.829+05:30 [INF] Auth: Attempting credential authentication localhost:8091?http_idle_conn_timeout=90000&http_max_idle_conns=64000&http_max_idle_conns_per_host=256&kv_pool_size=2&n1ql_timeout=75000&operation_tracing=false
2020-10-03T08:45:47.459+05:30 [INF] Successfully opened bucket grocery-sync
2020-10-03T08:45:48.311+05:30 [INF] Set query timeouts for bucket grocery-sync to cluster:1m15s, bucket:1m15s
2020-10-03T08:45:48.325+05:30 [INF] Initializing indexes with numReplicas: 0…
2020-10-03T08:45:48.797+05:30 [INF] Verifying index availability for bucket grocery-sync…
2020-10-03T08:45:49.796+05:30 [INF] Indexes ready for bucket grocery-sync.
2020-10-03T08:45:49.938+05:30 [INF] delta_sync enabled=false with rev_max_age_seconds=86400 for database grocery-sync
2020-10-03T08:45:49.995+05:30 [INF] Created background task: “CleanAgedItems” with interval 1m0s
2020-10-03T08:45:49.995+05:30 [INF] Cache: Initializing changes cache for database grocery-sync with options {ChannelCacheOptions:{ChannelCacheMinLength:50 ChannelCacheMaxLength:500 ChannelCacheAge:1m0s MaxNumChannels:50000 CompactHighWatermarkPercent:80 CompactLowWatermarkPercent:60} CachePendingSeqMaxWait:5s CachePendingSeqMaxNum:10000 CacheSkippedSeqMaxWait:1h0m0s}
2020-10-03T08:45:49.995+05:30 [INF] Created background task: “InsertPendingEntries” with interval 2.5s
2020-10-03T08:45:49.995+05:30 [INF] Created background task: “CleanSkippedSequenceQueue” with interval 30m0s
2020-10-03T08:45:49.996+05:30 [INF] DCP: Attempting to start import DCP feed…
2020-10-03T08:45:50.116+05:30 [INF] DCP: Registering PindexImplType for syncGateway-import-grocery-sync
2020-10-03T08:45:50.116+05:30 [INF] DCP: Starting DCP import feed for bucket: “grocery-sync”
2020-10-03T08:45:50.867+05:30 [INF] DCP: Previously persisted backfill sequences found - will resume
CP: c:grocery-sync-SGI Restarting vb 1016 using metadata sequence 0 (backfill 0 not in [0-0])
2020-10-03T08:45:51.079+05:30 [INF] DCP: c:grocery-sync-SGI Restarting vb 1017 using metadata sequence 0 (backfill 0 not in [0-0])
2020-10-03T08:45:51.079+05:30 [INF] DCP: c:grocery-sync-SGI Restarting vb 1018 using metadata sequence 0 (backfill 0 not in [0-0])
2020-10-03T08:45:51.079+05:30 [INF] DCP: c:grocery-sync-SGI Restarting vb 1019 using metadata sequence 0 (backfill 0 not in [0-0])
2020-10-03T08:45:51.079+05:30 [INF] DCP: c:grocery-sync-SGI Restarting vb 1020 using metadata sequence 0 (backfill 0 not in [0-0])
2020-10-03T08:45:51.079+05:30 [INF] DCP: c:grocery-sync-SGI Restarting vb 1021 using metadata sequence 0 (backfill 0 not in [0-0])
2020-10-03T08:45:51.079+05:30 [INF] DCP: c:grocery-sync-SGI Restarting vb 1022 using metadata sequence 0 (backfill 0 not in [0-0])
2020-10-03T08:45:51.079+05:30 [INF] DCP: c:grocery-sync-SGI Restarting vb 1023 using metadata sequence 0 (backfill 0 not in [0-0])
2020-10-03T08:45:51.198+05:30 [INF] DCP: c:grocery-sync-SGI DCP feed starting with name SGI-v-2.7-commit–uuid-bd87ca57-0526-11eb-bbbd-180373c77920
2020-10-03T08:45:51.226+05:30 [INF] DCP: Starting mutation feed on bucket grocery-sync due to either channel cache mode or doc tracking (auto-import)
2020-10-03T08:45:51.226+05:30 [INF] DCP: Using DCP feed for bucket: “grocery-sync” (based on feed_type specified in config file)
2020-10-03T08:45:51.445+05:30 [INF] DCP: c:grocery-sync-SG DCP feed starting with name SG-v-2.7-commit–uuid-bdb31a35-0526-11eb-bbbd-180373c77920
2020-10-03T08:45:51.769+05:30 [INF] Using metadata purge interval of 3.00 days for tombstone compaction.
2020-10-03T08:45:51.772+05:30 [INF] Created background task: “Compact” with interval 24h0m0s
2020-10-03T08:45:51.782+05:30 [INF] Using default sync function ‘channel(doc.channels)’ for database “grocery-sync”
2020-10-03T08:45:51.833+05:30 [INF] Reset guest user to config
2020-10-03T08:45:51.873+05:30 [INF] Starting admin server on 127.0.0.1:4985
2020-10-03T08:45:52.085+05:30 [INF] CBGoUtilsLogger: Using plain authentication for user username
2020-10-03T08:45:52.085+05:30 [INF] CBGoUtilsLogger: Using plain authentication for user username
2020-10-03T08:45:52.143+05:30 [INF] Starting server on 0.0.0.0:4984 …
2020-10-03T08:45:54.741+05:30 [INF] HTTP: #001: GET /favicon.ico/ (as ADMIN)
2020-10-03T08:45:54.741+05:30 [INF] HTTP: #001: --> 400 invalid database name “favicon.ico” (10.0 ms)
2020-10-03T08:45:55.315+05:30 [INF] HTTP: #002: GET /_all_dbs (as ADMIN)
2020-10-03T08:45:55.323+05:30 [INF] HTTP+: #002: --> 200 (8.0 ms)
2020-10-03T08:45:55.450+05:30 [INF] HTTP: #003: GET /favicon.ico/ (as ADMIN)
2020-10-03T08:45:55.450+05:30 [INF] HTTP: #003: --> 400 invalid database name “favicon.ico” (0.0 ms)
2020-10-03T08:45:57.587+05:30 [INF] HTTP: #004: GET /grocery-sync/_config (as ADMIN)
2020-10-03T08:45:57.606+05:30 [INF] HTTP+: #004: --> 200 (19.0 ms)
2020-10-03T08:45:57.620+05:30 [INF] HTTP: #006: GET /grocery-sync/_changes?limit=10&include_docs=true (as ADMIN)
2020-10-03T08:45:57.602+05:30 [INF] HTTP: #005: GET /favicon.ico/ (as ADMIN)
2020-10-03T08:45:57.802+05:30 [INF] HTTP: #005: --> 400 invalid database name “favicon.ico” (200.0 ms)
2020-10-03T08:45:57.812+05:30 [INF] Changes: c:#006 MultiChangesFeed(channels: {}, options: {Since: 0, Limit: 10, Conflicts: false, IncludeDocs: true, Wait: false, Continuous: false, HeartbeatMs: 0, TimeoutMs: 300000, ActiveOnly: false}) …
2020-10-03T08:45:58.114+05:30 [INF] Cache: Querying ‘channels’ for "" (start=#1, end=#2, limit=10)
2020-10-03T08:45:58.125+05:30 [INF] Cache: Got no rows from query for channel:""
2020-10-03T08:45:58.125+05:30 [INF] Cache: GetChangesInChannel("") --> 0 rows
2020-10-03T08:45:58.126+05:30 [INF] Changes: c:#006 MultiChangesFeed done
2020-10-03T08:45:58.126+05:30 [INF] HTTP+: #006: --> 200 OK (505.9 ms)
2020-10-03T08:45:58.131+05:30 [INF] HTTP: #007: GET /grocery-sync/_changes?since=0&include_docs=true&limit=10 (as ADMIN)
2020-10-03T08:45:58.131+05:30 [INF] Changes: c:#007 MultiChangesFeed(channels: {}, options: {Since: 0, Limit: 10, Conflicts: false, IncludeDocs: true, Wait: false, Continuous: false, HeartbeatMs: 0, TimeoutMs: 300000, ActiveOnly: false}) …
2020-10-03T08:45:58.131+05:30 [INF] Changes: c:#007 MultiChangesFeed done
2020-10-03T08:45:58.131+05:30 [INF] HTTP+: #007: --> 200 OK (0.0 ms)
2020-10-03T08:45:58.133+05:30 [INF] HTTP: #008: GET /grocery-sync/_changes?since=0&include_docs=true&feed=longpoll (as ADMIN)
2020-10-03T08:45:58.133+05:30 [INF] Changes: c:#008 MultiChangesFeed(channels: {}, options: {Since: 0, Limit: 0, Conflicts: false, IncludeDocs: true, Wait: true, Continuous: false, HeartbeatMs: 0, TimeoutMs: 300000, ActiveOnly: false}) …
2020-10-03T08:45:58.329+05:30 [INF] HTTP: #009: GET /grocery-sync/_all_docs (as ADMIN)
2020-10-03T08:45:58.369+05:30 [INF] HTTP+: #009: --> 200 OK (40.0 ms)
2020-10-03T08:45:59.595+05:30 [INF] Changes: c:#008 Connection lost from client
2020-10-03T08:45:59.595+05:30 [INF] HTTP+: #008: --> 200 OK (0.0 ms)
2020-10-03T08:45:59.693+05:30 [INF] HTTP: #010: GET /favicon.ico/ (as ADMIN)
2020-10-03T08:45:59.693+05:30 [INF] HTTP: #010: --> 400 invalid database name “favicon.ico” (0.0 ms)
2020-10-03T08:46:00.074+05:30 [INF] HTTP: #011: GET /_all_dbs (as ADMIN)
2020-10-03T08:46:00.074+05:30 [INF] HTTP+: #011: --> 200 (0.0 ms)
2020-10-03T08:46:00.121+05:30 [INF] HTTP: #012: GET /favicon.ico/ (as ADMIN)
2020-10-03T08:46:00.121+05:30 [INF] HTTP: #012: --> 400 invalid database name “favicon.ico” (0.0 ms)
2020-10-03T08:46:01.525+05:30 [INF] HTTP: #013: GET /grocery-sync/_config (as ADMIN)
2020-10-03T08:46:01.525+05:30 [INF] HTTP+: #013: --> 200 (0.0 ms)
2020-10-03T08:46:01.539+05:30 [INF] HTTP: #014: GET /grocery-sync/_changes?limit=10&include_docs=true (as ADMIN)
2020-10-03T08:46:01.539+05:30 [INF] Changes: c:#014 MultiChangesFeed(channels: {}, options: {Since: 0, Limit: 10, Conflicts: false, IncludeDocs: true, Wait: false, Continuous: false, HeartbeatMs: 0, TimeoutMs: 300000, ActiveOnly: false}) …
2020-10-03T08:46:01.539+05:30 [INF] Changes: c:#014 MultiChangesFeed done
2020-10-03T08:46:01.539+05:30 [INF] HTTP+: #014: --> 200 OK (0.0 ms)
2020-10-03T08:46:01.543+05:30 [INF] HTTP: #015: GET /favicon.ico/ (as ADMIN)
2020-10-03T08:46:01.543+05:30 [INF] HTTP: #015: --> 400 invalid database name “favicon.ico” (0.0 ms)
2020-10-03T08:46:01.552+05:30 [INF] HTTP: #016: GET /grocery-sync/_changes?since=0&include_docs=true&feed=longpoll (as ADMIN)
2020-10-03T08:46:01.552+05:30 [INF] Changes: c:#016 MultiChangesFeed(channels: {}, options: {Since: 0, Limit: 0, Conflicts: false, IncludeDocs: true, Wait: true, Continuous: false, HeartbeatMs: 0, TimeoutMs: 300000, ActiveOnly: false}) …
2020-10-03T08:46:01.572+05:30 [INF] HTTP: #017: GET /grocery-sync/_changes?since=0&include_docs=true&limit=10 (as ADMIN)
2020-10-03T08:46:01.572+05:30 [INF] Changes: c:#017 MultiChangesFeed(channels: {*}, options: {Since: 0, Limit: 10, Conflicts: false, IncludeDocs: true, Wait: false, Continuous: false, HeartbeatMs: 0, TimeoutMs: 300000, ActiveOnly: false}) …
2020-10-03T08:46:01.572+05:30 [INF] Changes: c:#017 MultiChangesFeed done
2020-10-03T08:46:01.572+05:30 [INF] HTTP+: #017: --> 200 OK (0.0 ms)
2020-10-03T08:46:01.574+05:30 [INF] HTTP: #018: GET /grocery-sync/_all_docs (as ADMIN)
2020-10-03T08:46:01.578+05:30 [INF] HTTP+: #018: --> 200 OK (4.0 ms)
2020-10-03T08:46:04.443+05:30 [INF] Changes: c:#016 Connection lost from client
2020-10-03T08:46:04.443+05:30 [INF] HTTP+: #016: --> 200 OK (0.0 ms)
2020-10-03T08:46:04.537+05:30 [INF] HTTP: #019: GET /favicon.ico/ (as ADMIN)
2020-10-03T08:46:04.537+05:30 [INF] HTTP: #019: --> 400 invalid database name “favicon.ico” (0.0 ms)
2020-10-03T08:46:04.802+05:30 [INF] HTTP: #020: GET /_all_dbs (as ADMIN)
2020-10-03T08:46:04.803+05:30 [INF] HTTP+: #020: --> 200 (1.0 ms)
2020-10-03T08:46:04.829+05:30 [INF] HTTP: #021: GET /favicon.ico/ (as ADMIN)
2020-10-03T08:46:04.829+05:30 [INF] HTTP: #021: --> 400 invalid database name “favicon.ico” (0.0 ms)