Hi Adam
Any ideas on this? It is very consistent…! Here are a tail
of a couple of log files:
sg_error.log
2018-12-04T07:34:43.300+01:00 ==== Couchbase Sync Gateway/2.1.1(17;fea9947) ====
2018-12-04T07:42:40.373+01:00 ==== Couchbase Sync Gateway/2.1.1(17;fea9947) ====
2018-12-13T09:10:02.504+01:00 ==== Couchbase Sync Gateway/2.1.1(17;fea9947) ====
sg_info.log
2018-12-13T09:10:05.214+01:00 [INF] Error opening bucket: failed to connect to any of the specified hosts
2018-12-13T09:10:07.775+01:00 [INF] GoCBCustomSGTranscoder Opening Couchbase database data on <http://localhost:8091> as user "remoteSync"
2018-12-13T09:10:07.776+01:00 [INF] Auth: Attempting credential authentication http://localhost:8091?http_idle_conn_timeout=90000&http_max_idle_conns=64000&http_max_idle_conns_per_host=256
2018-12-13T09:10:07.777+01:00 [INF] Error opening bucket: failed to connect to any of the specified hosts
2018-12-13T09:10:13.278+01:00 [INF] GoCBCustomSGTranscoder Opening Couchbase database data on <http://localhost:8091> as user "remoteSync"
2018-12-13T09:10:13.278+01:00 [INF] Auth: Attempting credential authentication http://localhost:8091?http_idle_conn_timeout=90000&http_max_idle_conns=64000&http_max_idle_conns_per_host=256
2018-12-13T09:10:13.280+01:00 [INF] Error opening bucket: failed to connect to any of the specified hosts
2018-12-13T09:10:23.520+01:00 [INF] GoCBCustomSGTranscoder Opening Couchbase database data on <http://localhost:8091> as user "remoteSync"
2018-12-13T09:10:23.520+01:00 [INF] Auth: Attempting credential authentication http://localhost:8091?http_idle_conn_timeout=90000&http_max_idle_conns=64000&http_max_idle_conns_per_host=256
2018-12-13T09:10:23.529+01:00 [INF] Successfully opened bucket
sync_gateway_error.log
2018-12-13T09:10:03.930+01:00 [INF] GoCBCustomSGTranscoder Opening Couchbase database data on <http://localhost:8091> as user "remoteSync"
2018-12-13T09:10:03.933+01:00 [INF] Error opening bucket: failed to connect to any of the specified hosts
2018-12-13T09:10:05.213+01:00 [INF] GoCBCustomSGTranscoder Opening Couchbase database data on <http://localhost:8091> as user "remoteSync"
2018-12-13T09:10:05.214+01:00 [INF] Error opening bucket: failed to connect to any of the specified hosts
2018-12-13T09:10:07.775+01:00 [INF] GoCBCustomSGTranscoder Opening Couchbase database data on <http://localhost:8091> as user "remoteSync"
2018-12-13T09:10:07.777+01:00 [INF] Error opening bucket: failed to connect to any of the specified hosts
2018-12-13T09:10:13.278+01:00 [INF] GoCBCustomSGTranscoder Opening Couchbase database data on <http://localhost:8091> as user "remoteSync"
2018-12-13T09:10:13.280+01:00 [INF] Error opening bucket: failed to connect to any of the specified hosts
2018-12-13T09:10:23.520+01:00 [INF] GoCBCustomSGTranscoder Opening Couchbase database data on <http://localhost:8091> as user "remoteSync"
2018-12-13T09:10:23.529+01:00 [INF] Successfully opened bucket
I tried to open the admin console using: http://db1.my-domain.dk:4985/_admin/
- and I just get:
This site can’t be reached db1.dalsgaard-data.dk refused to connect.
Search Google for db1 my domain 4985 admin
ERR_CONNECTION_REFUSED
And it stays like that - I have even tried to leave it for days…
So issuing systemctl restart sync_gateway
on the server will restart Sync Gateway - and then it responds on port 4985.
The log files now show (inlcuding the last few lines from before):
sg_error.log
2018-12-04T07:34:43.300+01:00 ==== Couchbase Sync Gateway/2.1.1(17;fea9947) ====
2018-12-04T07:42:40.373+01:00 ==== Couchbase Sync Gateway/2.1.1(17;fea9947) ====
2018-12-13T09:10:02.504+01:00 ==== Couchbase Sync Gateway/2.1.1(17;fea9947) ====
2018-12-13T09:20:58.702+01:00 ==== Couchbase Sync Gateway/2.1.1(17;fea9947) ====
sg_info.log
2018-12-13T09:10:23.520+01:00 [INF] Auth: Attempting credential authentication http://localhost:8091?http_idle_conn_timeout=90000&http_max_idle_conns=64000&http_max_idle_conns_per_host=256
2018-12-13T09:10:23.529+01:00 [INF] Successfully opened bucket
2018-12-13T09:20:58.702+01:00 ==== Couchbase Sync Gateway/2.1.1(17;fea9947) ====
2018-12-13T09:20:58.702+01:00 [INF] Console LogKeys: [HTTP HTTP+]
2018-12-13T09:20:58.702+01:00 [INF] Console LogLevel: info
2018-12-13T09:20:58.702+01:00 [INF] Log Redaction Level: none
2018-12-13T09:20:58.702+01:00 [INF] requestedSoftFDLimit < currentSoftFdLimit (5000 < 65535) no action needed
2018-12-13T09:20:58.702+01:00 [INF] Opening db /data as bucket "data", pool "default", server <http://localhost:8091>
2018-12-13T09:20:58.702+01:00 [INF] GoCBCustomSGTranscoder Opening Couchbase database data on <http://localhost:8091> as user "remoteSync"
2018-12-13T09:20:58.702+01:00 [INF] Auth: Attempting credential authentication http://localhost:8091?http_idle_conn_timeout=90000&http_max_idle_conns=64000&http_max_idle_conns_per_host=256
2018-12-13T09:20:58.708+01:00 [INF] Successfully opened bucket
2018-12-13T09:20:58.775+01:00 [INF] Design docs for current SG view version (2.1) found.
2018-12-13T09:20:58.775+01:00 [INF] Verifying view availability for bucket data...
2018-12-13T09:20:59.374+01:00 [INF] Views ready for bucket data.
2018-12-13T09:20:59.375+01:00 [INF] Cache: Initializing changes cache with options {ChannelCacheOptions:{ChannelCacheMinLength:0 ChannelCacheMaxLength:0 ChannelCacheAge:0s} CachePendingSeqMaxWait:5s CachePendingSeqMaxNum:10000 CacheSkippedSeqMaxWait:1h0m0s}
2018-12-13T09:20:59.375+01:00 [INF] Initializing changes cache for database data
2018-12-13T09:20:59.375+01:00 [INF] DCP: Starting mutation feed on bucket data due to either channel cache mode or doc tracking (auto-import/bucketshadow)
2018-12-13T09:20:59.375+01:00 [INF] DCP: Using DCP feed for bucket: "data" (based on feed_type specified in config file)
2018-12-13T09:20:59.811+01:00 [INF] Using metadata purge interval of 3.00 days for tombstone compaction.
2018-12-13T09:20:59.830+01:00 [INF] Reset guest user to config
2018-12-13T09:20:59.830+01:00 [INF] Starting admin server on 0.0.0.0:4985
2018-12-13T09:20:59.836+01:00 [INF] Starting server on 0.0.0.0:4984 ...
2018-12-13T09:20:59.872+01:00 [INF] DCP: Backfill in progress: 0% (4 / 10377)
2018-12-13T09:21:00.260+01:00 [INF] Cache: Received #463322 (unused sequence)
2018-12-13T09:21:00.878+01:00 [INF] DCP: Backfill complete
2018-12-13T09:21:03.217+01:00 [INF] HTTP: #001: GET /_all_dbs (as ADMIN)
2018-12-13T09:21:03.217+01:00 [INF] HTTP+: #001: --> 200 (0.1 ms)
2018-12-13T09:21:03.375+01:00 [INF] HTTP: #002: GET /favicon.ico/ (as ADMIN)
2018-12-13T09:21:03.375+01:00 [INF] HTTP: #002: --> 400 invalid database name "favicon.ico" (0.1 ms)
sync_gateway_error.log
2018-12-13T09:10:13.280+01:00 [INF] Error opening bucket: failed to connect to any of the specified hosts
2018-12-13T09:10:23.520+01:00 [INF] GoCBCustomSGTranscoder Opening Couchbase database data on <http://localhost:8091> as user "remoteSync"
2018-12-13T09:10:23.529+01:00 [INF] Successfully opened bucket
2018-12-13T09:20:58.701+01:00 [WRN] Using deprecated config option: log. Use logging.console.log_keys instead. -- rest.(*ServerConfig).deprecatedConfigLoggingFallback() at config.go:623
2018-12-13T09:20:58.702+01:00 ==== Couchbase Sync Gateway/2.1.1(17;fea9947) ====
2018-12-13T09:20:58.702+01:00 [INF] Console LogKeys: [HTTP HTTP+]
2018-12-13T09:20:58.702+01:00 [INF] Console LogLevel: info
2018-12-13T09:20:58.702+01:00 [INF] Log Redaction Level: none
2018-12-13T09:20:58.702+01:00 [INF] requestedSoftFDLimit < currentSoftFdLimit (5000 < 65535) no action needed
2018-12-13T09:20:58.702+01:00 [INF] Opening db /data as bucket "data", pool "default", server <http://localhost:8091>
2018-12-13T09:20:58.702+01:00 [INF] GoCBCustomSGTranscoder Opening Couchbase database data on <http://localhost:8091> as user "remoteSync"
2018-12-13T09:20:58.708+01:00 [INF] Successfully opened bucket
2018-12-13T09:20:58.775+01:00 [INF] Design docs for current SG view version (2.1) found.
2018-12-13T09:20:58.775+01:00 [INF] Verifying view availability for bucket data...
2018-12-13T09:20:59.374+01:00 [INF] Views ready for bucket data.
2018-12-13T09:20:59.375+01:00 [INF] Initializing changes cache for database data
2018-12-13T09:20:59.811+01:00 [INF] Using metadata purge interval of 3.00 days for tombstone compaction.
2018-12-13T09:20:59.814+01:00 [INFO] Using plain authentication for user <ud>remoteSync</ud>
2018-12-13T09:20:59.829+01:00 [INFO] Using plain authentication for user <ud>remoteSync</ud>
2018-12-13T09:20:59.830+01:00 [INF] Reset guest user to config
2018-12-13T09:20:59.830+01:00 [INF] Starting admin server on 0.0.0.0:4985
2018-12-13T09:20:59.836+01:00 [INF] Starting server on 0.0.0.0:4984 ...
2018-12-13T09:21:03.217+01:00 [INF] HTTP: #001: GET /_all_dbs (as ADMIN)
2018-12-13T09:21:03.217+01:00 [INF] HTTP+: #001: --> 200 (0.1 ms)
2018-12-13T09:21:03.375+01:00 [INF] HTTP: #002: GET /favicon.ico/ (as ADMIN)
2018-12-13T09:21:03.375+01:00 [INF] HTTP: #002: --> 400 invalid database name "favicon.ico" (0.1 ms)
I guess the error on favicon.ico
comes as I open the admin console in a browser - and thus can be ignored.
Any ideas what to do? I have not seen this problem on the prior release. And I have the same version installed on another CentOS 6.10 box - where this is not a problem either (though that is a single server installation).
This is a cluster of two nodes - problem is consistent across both. OS i s CentOS 7.6, Couchbase Community Edition 6.0 and Sync Gateway 2.1.1
The sync_gateways.json file looks like this (leaving out the sync formula):
{
"log": ["HTTP+"],
"adminInterface": "0.0.0.0:4985",
"interface": "0.0.0.0:4984",
"databases": {
"data": {
"use_views":true,
"bucket": "data",
"server": "http://localhost:8091",
"username": "remote.....",
"password": ".........",
"enable_shared_bucket_access": true,
"import_docs": "continuous",
"users": { "GUEST": { "disabled": true, "admin_channels": ["!"] } },
"sync": `function (doc, oldDoc) {
: