Admin UI seems to cause an increase in memory consumption

Couchbase Server
1

Hello,

We have found that simply leaving a browser tab on the Admin Web UI page appears to cause in increase in memory consumption. If left open long enough, memory consumption can exhaust available system memory, making the node unusable.
The requests seem to correspond to POST /_p/query/query/service request which end up looking like ‘POST /_cbauth HTTP/1.1" 200 36 - Go-http-client/1.1’ in the CB Access logs and large numbers of warnings like ‘[WARN] Finalizing a bucket with active connections’ in the query logs.
Given enough time (for us, about 90 minutes with an instance running at ~90% memory utilization and 16GB system memory under normal conditions).

This looks similar to the post Massive amount of auth POST /_cbauth & [WARN] Finalizing a bucket with active connections

We are using couchbase CE 6.0.0-1693-1 on Ubuntu 16.04.

2

Hello @sdayman,

It’s possible that this issue is caused by the query workbench in the Admin UI, which runs queries in the background when initially launched. On some data sets the INFER commands to retrieve schemas for the query workbench can cause problems (which were fixed in release 6.5).

If you click the “Preferences” button in the query workbench (below and to the right of the query window), one of the options in the preferences dialog is a checkbox labelled “Automatically infer bucket schemas.” Try unclicking that checkbox, and see if the issue improves.

Regards,

-Eben