Diego . | 28 Apr 18:20 2016
Picon

How can I unsubscribe?

How can I unsubscribe?

Thanks.
Jason Gordon | 28 Apr 16:04 2016

CouchDB 2.0 and zones

Hi,

Does CouchDB 2.0 support BigCouch-style zones?  If not, is it in the
roadmap?  I would like to have a cluster where two nodes are in one data
center and a third node (for hot failover) is in a remote data center.  I
know replication could be used  but a cluster with zones seems more elegant.

Thanks,

Jason
Christopher D. Malon | 28 Apr 00:59 2016
Picon

connection timeouts and multitasking

Hi,

I'm running CouchDB 1.5.0 on a single-processor EC2 ubuntu (m3.medium)
instance.  A preforking web application that accesses the database runs
on the same server.

I am testing the system with a single user.  In most cases, the web application's process
waits for the CouchDB response before proceeding with any other activity.

Intermittently, some simple GET requests (record accesses, not view queries)
to CouchDB from the web app are timing out.  I'm nowhere near max_connections
or max_dbs_open yet.

Standard advice might be to put the DB and web app on separate servers,
but since this problem occurs already with a single user, I'm not confident
that would fix anything.  The only possibly nonstandard thing I'm doing is
aggressively issuing a view query with "stale=update_after" after every
record update to the database, and that reindexing might still be running when I
try to send another read request.

Have others experienced these kinds of timeouts, and should I respond by
increasing the number of CPU cores or offloading the DB from the server?

Thanks,
Christopher

Raja | 27 Apr 19:58 2016
Picon
Gravatar

CouchDB crashing with SSL

Hi

We recently enabled SSL on CouchDB 1.6.1. Suddenly, it seems to be throwing
errors in the log when viewing even the main url on Futon. The errors are
shown in
https://gist.github.com/rajasaur/747ca711810c22e7780b3288c659f216

1. This was working till last week (http also works perfectly now).
2. Doing a curl seems to make it work:

curl -XGET  https://user:password <at> server:6984

returns {"couchdb":"Welcome","uuid":"de859c6bd13c708e759abc283f67f3c4","version":"1.6.1","vendor":{"version":"1.6.1","name":"The
Apache Software Foundation"}}

but hitting https://<server>:6984 on the browser throws the above mentioned
stack trace. Why would it fail using a browser but not with curl. Doing a
verbose with Curl indicated that it was negotiating using TLS 1.2
connection. I tried to force using --tlsv1.0, --tlsv1.1 and --tlsv1.2 to
curl to see if I can simulate the browser failure but it worked fine in all
cases.

3. Setup local.ini to have tls_version = [ 'tlsv1.2' ], but same result.

Browsing some of the older discussions suggests a upgrade of Erl (we use
Erlang OTP/R16B03-1). Is there anything else I should be looking before
going the upgrade route?

Thanks a lot for the help

(Continue reading)

Oleg Cohen | 26 Apr 23:43 2016

2.0 Clustering Data Encryption

Greetings,

I would like to understand if the data exchanged between cluster nodes is securely encrypted. Is there any
documentation that explains how the data is passed around?

Thank you!
Oleg
guyskk | 24 Apr 07:53 2016

Temporary views are not supported in CouchDB

I try use temp view in CouchDB 2.0 but it response `Temporary views are not supported in CouchDB`,  and
status_code is 403.


But I didn't see Temporary views are not supported in CouchDB2.0 documents,
and the changelog page is broken, http://docs.couchdb.org/en/latest/changelog.html
Gravatar

best practice for escaping _show functions

Hi, any good/easy  practice for creating _shows ?

Mainly I would like to know if there is a way to test my function with some
test data and later just encode it with so that I can basically just paste
it.

If I am right the _show applies do the document, so I can use the document
data to test right ?

Thanks in advance.
José Esteves | 21 Apr 23:28 2016
Picon
Gravatar

ReduceMap

Hi, i’m having some trouble understanding reduce value array parameter is
ordered.

Having this data (the view called with reduce=false)

{"total_rows":7,"offset":0,"rows":[
{"id":"1","key":"1","value":{"anid":1,"dest":"A"}},
{"id":"1","key":"1","value":{"anid":2,"dest":"A"}},
{"id":"1","key":"1","value":{"anid":3,"dest":"A"}},
{"id":"1","key":"1","value":{"anid":4,"dest":"A"}},
{"id":"1","key":"1","value":{"anid":5,"dest":"A"}},
{"id":"2","key":"2","value":{"anid":1,"dest":"B"}},
{"id":"2","key":"2","value":{"anid":2,"dest":"B"}} ]}

with this functions

{
  "_id": "_design/movs",
  "_rev": "131-bfc19def2bea6bda0784a609b2ba3f25",
  "views": {
    "unwind": {
      "map": "function(doc)
{doc.animals_ids.forEach(function(id){emit(doc._id, {anid: id, dest:
doc.destiny}) })} ",
      "reduce": "function(key,values){var res = [];var ac=[];var rt=
{}; values.forEach(function(i){if(ac.indexOf(i.anid)==-1){ac.push(i.anid);rt[i.dest]?rt[i.dest].push(i.anid):rt[i.dest]=[i.anid]
}}); for(key in rt){res.push({dest: key, ids:rt[key],
cant:rt[key].length}) }; return res }"
    }
  },
(Continue reading)

Jenn Turner | 21 Apr 18:34 2016

[NEWS] The CouchDB weekly news for April 21 is out!

Hi CouchDB fans!

The weekly news is now live at: https://blog.couchdb.org/2016/04/21/couchdb-
weekly-news-april-21-2016/

Highlights include lots of congratulations on new roles, many discussions
worth participating in, and a new release for PouchDB!

You can help us spread the news by sharing on Twitter ([https://twitter.com/Co
uchDB/status/720644979971006464](https://twitter.com/CouchDB/status/7231874992
21143552)) and other social networks.  

Also if you have news for next week, just REPLY to this thread!

  
Have a great weekend ![](images/composer-emoji/apple/263a.png)️️  

Jenn Turner

The Neighbourhoodie Software GmbH  
Adalbertstr. 7-8, 10999 Berlin  
[neighbourhood.ie](http://neighbourhood.ie/ "http://neighbourhood.ie/" )  

Handelsregister HRB 157851 B Amtsgericht Charlottenburg  
Geschäftsführung: Jan Lehnardt

Matthew Buckett | 20 Apr 11:35 2016
Picon
Picon
Gravatar

Improve documentation shipped with CouchDB?

Today I was trying to find out what version of JavaScript I could use with
CouchDB 1.6.1 and in the end I downloaded the source and seeing that it
required SpiderMonkey 1.8.5 to build, and looking on Mozilla's page saw it
supports ECMAScript Edition 5 (I was hoping for 6).

https://developer.mozilla.org/en-US/docs/Mozilla/Projects/SpiderMonkey/Releases/1.8.5

I was going to quickly add this fact to the documentation about the
JavaScript query engine, but the instructions for doing so in:

http://docs.couchdb.org/en/1.6.1/contributing.html?highlight=spidermonkey

point to a folder that doesn't currently exist in git (share/doc/src). I'm
guessing that this is because the changes involved in CouchDB 2.0 but
wondered where I should look to improve the documentation on this?

Thanks.
Matthew Buckett | 19 Apr 15:48 2016
Picon
Picon
Gravatar

Re: Reporting on joined data

Thanks Sebastian, is multi-step reduction something that might happen?

I think we may end up having the user's department in all the activities so
that we can just emit this as a key and then do standard map/reduces.
However as a general solution this means that we end up embedding anything
that we want to be able to view our reports by into the activities (eg,
sex, age, etc).

Using a list function is something I had started to look at and as you say
for smallish datasets should work, but performance will drop off as our
database grows.

On Tue, 19 Apr 2016 at 14:24 Sebastian Rothbucher <
sebastianrothbucher@...> wrote:

> Hi Matthew,
>
> multi-step reduction is (unfortunately) something plain CouchDB can't do at
> all. So you're right that there's no easy way of doing it. However, from
> the top of my head, you could emit a key [userId, '1_dept'] w/ value
> department for each userRecord and a key [userid, '2_act'] for each
> activity. When reducing w/ maximum detail and using _sum / _count or
> _stats, you should get no sum for the '1_dept' part and the sum/count for
> the '2_act' parts. You could then use a list-function to iterate over the
> result (which should be small in comparison unless you're a really big
> organization - and anyways, you won't ever need it in memory all at once)
> and create a hash-table with entries per department. Each time you come
> across a new '1_dept' value, you have a new hash key, as long as you get
> '2_act' values, keep summing up (as the input to the list is the - ordered
> - view result, you're good). Finally, just emit the stringified hashtable
(Continue reading)


Gmane