Re: Corrupt database file

2014-03-21 Thread Tim Tisdall
If the DB was corrupted because the disk became full, shouldn't the DB still be fine but just missing the most recent commits? Or would the a person need to truncate a certain number of bytes off the end of the DB to get it to read properly? As for JSON file size... I always dump the DB into a GZ

Re: Corrupt database file

2014-03-21 Thread Tim Tisdall
I don't think there's any tool for fixing corrupted db files... What I'd try doing is dumping all the content from the DB and reconstructing it. You can fetch everything in the database by downloading http://127.0.0.1:5984/my_database/_all_docs?include_docs=true (where the IP and domain is your s

Re: view_duplicate_id chaos

2013-11-15 Thread Tim Tisdall
Do you have duplicate doc ids in your data?? I think the view is just corrupted and needs to be deleted and recreated from scratch. -Tim On Fri, Nov 15, 2013 at 4:17 PM, Will Perry wrote: > Hi Folks- > > In a fairly large DB (~8GB) we're seeing crashes, compaction failures and > index rebuilds

Re: [REQUEST] Help promote the CouchDB 1.5.0 release

2013-11-06 Thread Tim Tisdall
Dare I ask? :) Is this the version with Bigcouch merged in? On Tue, Nov 5, 2013 at 2:09 PM, Noah Slater wrote: > https://plus.google.com/109226482722655790973/posts/fQhjYZVEeJL > https://plus.google.com/109226482722655790973/posts/Zn1tnx9KPrb > > On 5 November 2013 19:47, Dirkjan Ochtman wro

Re: Mailing list search

2013-10-24 Thread Tim Tisdall
very helpful! thanks! On Thu, Oct 24, 2013 at 9:16 AM, Noah Slater wrote: > Hi folks, > > Micro announcement: I just added a mailing list search to our website. > > http://couchdb.apache.org/#mailing-lists > > Next time you're stuck, you can use this. But also, next time you see > someone aski

Re: [ANNOUNCE] Apache CouchDB 1.4.0 released

2013-09-03 Thread Tim Tisdall
I was going to ask about bigcouch too... I'm really looking forward to that merge! On Tue, Sep 3, 2013 at 2:54 PM, Filippo Fadda < filippo.fa...@programmazione.it> wrote: > Nope. > > -Filippo > > On Sep 3, 2013, at 8:51 PM, Stanley Iriele wrote: > > > Does this release contain the merged code f

Re: Unsolicited email from CouchBase

2013-08-30 Thread Tim Tisdall
I've never received any. On Fri, Aug 30, 2013 at 9:32 AM, Robert Newson wrote: > "particularly cool to me to be harvesting emails from an apache list for > marketing purposes in the first place" > > That would be distinctly uncool if true, thanks for letting us know. > > B. > > > > On 30 August

Re: Need Strategy for Dealing with Large List Output

2013-07-18 Thread Tim Tisdall
Does this help? http://guide.couchdb.org/draft/recipes.html#pagination On Thu, Jul 18, 2013 at 9:05 AM, Paul Roebuck wrote: > Have a couchapp whose list() can't seem to output its information > before OS timeout occurs. We initially just increased the OS timeout, > but still have issues depend

Re: Can't upload a pic to CouchDB.

2013-07-16 Thread Tim Tisdall
Do you have a space before "--data-binary" when you run the command? On Tue, Jul 16, 2013 at 11:05 AM, Yves S. Garret wrote: > I'm going through this book and I'm in this section: > http://guide.couchdb.org/editions/1/en/api.html#attachments > > I try this in the command line and this is the er

Re: Database too large for partition

2013-07-11 Thread Tim Tisdall
uld be true is if you > > compacted a database that you had just compacted and had made no > > changes to. Compacting it again will just write the whole thing out > > again. Obviously this worse case is also the case where there's no > > point compacting anyway. > > > &

Re: Database too large for partition

2013-07-11 Thread Tim Tisdall
You could delete the generated views in /var/lib/couchdb/.your_database/ and recover a little extra space. There could also be a partially done compaction in /var/lib/couchdb/ The longer term solution is to do compactions... but you need space equal to the content of the database to do a compacti

Re: [ANNOUNCE] Apache CouchDB 1.3.1 released

2013-06-28 Thread Tim Tisdall
Forgive my ignorance and forgetfulness... Is this the version that's supposed to have clustering support merged in? Or is that yet to come? -Tim On Thu, Jun 27, 2013 at 2:38 PM, Noah Slater wrote: > Dear Community, > > Apache CouchDB 1.3.1 has been released and is available for download. > >

Re: which is the good server to support CouchDB

2013-05-20 Thread Tim Tisdall
oh.. just saw the past posts where Ashraf replied to people's posts... I'm not sure what he wants to hear since he keeps posting the same questions even after people have posted replies. On Mon, May 20, 2013 at 8:48 AM, Tim Tisdall wrote: > The problem before was that someon

Re: which is the good server to support CouchDB

2013-05-20 Thread Tim Tisdall
The problem before was that someone was letting Ashraf's posts into the mailing list even though he wasn't subscribed. So, he never got the replies people sent him. Are you subscribed now Ashraf? If not, there's no point in anyone responding. -Tim On Mon, May 20, 2013 at 7:46 AM, Michael Zede

Re: please

2013-05-16 Thread Tim Tisdall
re: > http://mail-archives.apache.org/mod_mbox/couchdb-user/201305.mbox/browser > > Everyone, it's great to see quick and useful replies from several > different people, nice work. > > B. > > On 16 May 2013 20:33, Tim Tisdall wrote: > > I think Jens Alfke answered this

Re: please

2013-05-16 Thread Tim Tisdall
I think Jens Alfke answered this question pretty well and completely. If there's something else you need to know, you need to be more specific. On Thu, May 16, 2013 at 3:20 PM, Ashraf Janan wrote: > I don't know where can i find the answers on my questions.can i get the > link to these answers

Re: CouchDB not reachable (beginner's question)

2013-04-15 Thread Tim Tisdall
ards, > > Michael > > > On 2013-04-15 16:23, Keith Gable wrote: > >> wow indeed. >> >> --- >> Keith Gable >> A+, Network+, and Storage+ Certified Professional >> Apple Certified Technical Coordinator >> Mobile Application Developer / Web D

Re: CouchDB not reachable (beginner's question)

2013-04-15 Thread Tim Tisdall
you don't > need root to do SSH tunneling. > > > > --- > Keith Gable > A+, Network+, and Storage+ Certified Professional > Apple Certified Technical Coordinator > Mobile Application Developer / Web Developer > > > On Mon, Apr 15, 2013 at 9:55 AM, Tim Tisdall wr

Re: CouchDB not reachable (beginner's question)

2013-04-15 Thread Tim Tisdall
open couchdb to the world > before you set an administration password in the first place. :) > > B. > > On 15 April 2013 15:55, Tim Tisdall wrote: > > Still don't see how ssh'ing in as root is anywhere as bad as having your > > CouchDB open to the world with

Re: CouchDB not reachable (beginner's question)

2013-04-15 Thread Tim Tisdall
Developer > > > On Mon, Apr 15, 2013 at 9:18 AM, Robert Newson wrote: > > > wow. > > > > On 15 April 2013 15:15, Tim Tisdall wrote: > > > What's wrong with ssh'ing as root? > > > > > > > > > On Mon, Apr 15, 2013 at 10:

Re: CouchDB not reachable (beginner's question)

2013-04-15 Thread Tim Tisdall
ed Professional > Apple Certified Technical Coordinator > Mobile Application Developer / Web Developer > > > On Mon, Apr 15, 2013 at 8:45 AM, Tim Tisdall wrote: > > > Instead of opening CouchDB to the world, I simply access it by > > port-forwarding through ssh when I connect t

Re: CouchDB not reachable (beginner's question)

2013-04-15 Thread Tim Tisdall
Instead of opening CouchDB to the world, I simply access it by port-forwarding through ssh when I connect to the machine. Like this: ssh -L 5984:127.0.0.1:5984 r...@mymachine.com Then on my local machine I can simply access http://localhost:5984/_utils/ and up comes futon. It depends on your us

Re: CouchDB not reachable (beginner's question)

2013-04-10 Thread Tim Tisdall
Do you have any firewall (iptables) rules running? On Wed, Apr 10, 2013 at 1:47 PM, Stefan Reich < stefan.reich.maker.of@googlemail.com> wrote: > Oops, bad copy&paste - here's the actual process info: > > root@pussy-riot-germany:~/luastuff# ps -aef|grep 7651 > couchdb 7651 7650 0 19:44 p

compaction triggering mysteriously

2013-03-21 Thread Tim Tisdall
I know CouchDB 1.2.X has functionality for automatic triggering of compaction for databases and views, but I'm pretty sure the default is that they're off. I just set up a new instance of 1.2.1 and I keep finding my database being compacting when I look in the "status" page. I set up only one aut

Re: distributed database

2013-03-17 Thread Tim Tisdall
see it before. -Tim On Fri, Mar 15, 2013 at 1:14 PM, Robert Newson wrote: > Good news, the BigCouch source tree is being merged into CouchDB at > the moment and will be included in a release this year. > > B. > > On 15 March 2013 08:35, Tim Tisdall wrote: > > I've

Re: distributed database

2013-03-16 Thread Tim Tisdall
heck out cloudant. Those guys are awesome. > > On Fri, Mar 15, 2013 at 1:14 PM, Robert Newson wrote: > > > Good news, the BigCouch source tree is being merged into CouchDB at > > the moment and will be included in a release this year. > > > > B. > > > > O

Re: distributed database

2013-03-16 Thread Tim Tisdall
Is there any projected date for the release? On Fri, Mar 15, 2013 at 1:14 PM, Robert Newson wrote: > Good news, the BigCouch source tree is being merged into CouchDB at > the moment and will be included in a release this year. > > B. > > On 15 March 2013 08:35, Tim Tisdal

Re: distributed database

2013-03-16 Thread Tim Tisdall
n Fri, Mar 15, 2013 at 3:04 PM, Paul Davis wrote: > On Fri, Mar 15, 2013 at 8:35 AM, Tim Tisdall wrote: > > I've been running a CouchDB instance for quite a while now, but only on a > > single machine. I'm looking at moving my hosting and settings things up > in

distributed database

2013-03-15 Thread Tim Tisdall
I've been running a CouchDB instance for quite a while now, but only on a single machine. I'm looking at moving my hosting and settings things up in a distributed fashion. I was hoping someone could point me in the right direction for what solutions are current and what solutions may actually mak

Re: http equivalent of curl example

2013-02-28 Thread Tim Tisdall
t; > > > *** > > > > Alexander Gabriel > Wiesenstrasse 22 > 8800 Thalwil > 079/ 372 51 64 > a...@barbalex.ch > www.barbalex.ch > > > > 2013/2/28 Robert Newson > > > you can do ?keys=["

Re: http equivalent of curl example

2013-02-28 Thread Tim Tisdall
ows. Browser is IE10. > > > > > > oh: $(location).attr('host') returns a '/' instead of a ':' before the > > > port! I corrected for that but still get the exact same error. > > > > > > (still scratching my head...) > > > &

Re: http equivalent of curl example

2013-02-28 Thread Tim Tisdall
In that example the variables are being passed in as POST values. You're adding them to the URL which is making them GET variables. Do you have code examples that you're trying to use in Javascript? Are you using jQuery? On Thu, Feb 28, 2013 at 11:32 AM, Alexander Gabriel wrote: > Hi > > The

Re: Sorting dates in CouchDB

2012-10-08 Thread Tim Tisdall
I think it'd only be a lot slower if you did parsing of the date. As you have it, it's just a simple string comparison. You're doing it the way I would. Unix timestamp is good too, but makes it hard to read the dates manually. - Original message - > No, I'm not sure.  I can't help bu

Re: did query change in 1.20 ? [solved - but..]

2012-09-24 Thread Tim Tisdall
I think a lot of the newer browsers automatically translate the URL into http://examples.cloudant.com/animaldb/_design/views101/_view/latin_name?key=%22Meles%20meles%22 when you enter in http://examples.cloudant.com/animaldb/_design/views101/_view/latin_name?key="Meles meles" In Debian I can run:

Re: recovering data from an unfinished compaction db

2012-09-24 Thread Tim Tisdall
Since this is the result of a compaction, shouldn't the header be at the beginning of the file? (just testing my knowledge on how all this works...) -Tim On Mon, Sep 24, 2012 at 12:09 PM, Robert Newson wrote: > That does imply that the last valid header is a long way back up the > file, though.

Re: ip_conntrack problems

2012-09-10 Thread Tim Tisdall
d when making connections to couchdb on the loopback connection. I was making many rapid connections and quickly using up all the space in the hash tables for ip_conntrack. -Tim On Mon, Sep 10, 2012 at 3:20 PM, Tim Tisdall wrote: > No. It's a cron script that I've been using for

Re: ip_conntrack problems

2012-09-10 Thread Tim Tisdall
rage+ Certified Professional > Mobile Application Developer / Web Developer > > > > On Sun, Sep 9, 2012 at 9:14 PM, Tim Tisdall wrote: > >> I'm using iptables on my system to block external access to everything >> except for explicit ports (http, https, ssh, etc).

view creation followed by compaction?

2012-09-10 Thread Tim Tisdall
Is there a way to request a view creation/update and then have it compact immediately afterwards?

ip_conntrack problems

2012-09-09 Thread Tim Tisdall
I'm using iptables on my system to block external access to everything except for explicit ports (http, https, ssh, etc). I'm not sure how, but I'm getting “nf_conntrack: table full, dropping packet.” and “TCP: time wait bucket table overflow” because the number of connections is past the maximum

Re: dropping revision records

2012-09-06 Thread Tim Tisdall
;>> You could lower _rev_limit and recompact to flush these out. >>> >>> B. >>> >>> On 6 Sep 2012, at 20:46, Benoit Chesneau wrote: >>> >>>> On Thu, Sep 6, 2012 at 4:18 PM, Tim Tisdall wrote: >>>>> I had a database

Re: dropping revision records

2012-09-06 Thread Tim Tisdall
ewson wrote: > > I think Tim was clear that this was post-compaction, though. The 2gb is the > historic _rev values for all these documents. > > You could lower _rev_limit and recompact to flush these out. > > B. > > On 6 Sep 2012, at 20:46, Benoit Chesneau wrote: > >

Re: dropping revision records

2012-09-06 Thread Tim Tisdall
;) On Thu, Sep 6, 2012 at 5:23 PM, Benoit Chesneau wrote: > On Thu, Sep 6, 2012 at 10:35 PM, Robert Newson wrote: >> >> I think Tim was clear that this was post-compaction, though. > > i forgot to take my coffee...

Re: dropping revision records

2012-09-06 Thread Tim Tisdall
the db live and running as long as the site is running (so, as much as possible). I also need to maintain the document ids. On Thu, Sep 6, 2012 at 11:26 AM, Nathan Vander Wilt wrote: > > On Sep 6, 2012, at 7:18 AM, Tim Tisdall wrote: > >> I had a database of about 10.8gb with almost 1

dropping revision records

2012-09-06 Thread Tim Tisdall
I had a database of about 10.8gb with almost 15 million records which was fully compacted. I had to back it up by dumping all the JSON and then restoring it by inserting it back in. After it was done and I compacted it the database was now only 8.8gb! I shed 2gb because of dropping the revision

Re: Possible validation security issue

2012-08-30 Thread Tim Tisdall
r what the chunk of code is intended to do. You should post something in the issues tracker and see if they'll change it... -Tim On Thu, Aug 30, 2012 at 5:09 PM, Wordit wrote: > On Wed, Aug 29, 2012 at 10:32 PM, Tim Tisdall wrote: >> >> I think that chunk of code is to en

Re: Possible validation security issue

2012-08-29 Thread Tim Tisdall
ame in the document isn't a way to circumvent the security, it's something that the validator is enforcing so the document always has the author of the last person to edit it. So, not a bug in the document, just a misunderstanding of the intention of the code... -Tim On Wed, Aug 29,

Re: Possible validation security issue

2012-08-29 Thread Tim Tisdall
I think it should probably be looking at the oldDoc like Paul said. Then it should be preventing all editing unless the current user is the one in the doc (including changing the author). On the top of the couchdb definitive guide page you sent there's a link that says "report issue"... I'm prett

Re: max_document_size limits on hosted services?

2012-08-28 Thread Tim Tisdall
I'm not familiar with TouchDB, but I get dropped connections when using _bulk_docs when couch runs out of memory or crashes. I've had to reduce the number of docs to accommodate this problem, but adding more RAM may also help. The problem is related to the way linux over allocates RAM and the oom

Re: couchdb returning truncated JSON

2012-08-20 Thread Tim Tisdall
few occasions (Linux terminal >> > truncated my message because it was single line - line end was translated >> > as "\n" inside the message, so, no real line break was actually >> registered). >> > >> > CGS >> > >> > >>

Re: couchdb returning empty response

2012-08-20 Thread Tim Tisdall
son wrote: > > Is one of those "other processes" called "heart", by any chance? > > B. > > On 19 Aug 2012, at 21:00, Tim Tisdall wrote: > >> stderr shows this when I hit an empty response: >> >> heart_beat_kill_pid = 17700 >> heart

Re: couchdb returning empty response

2012-08-19 Thread Tim Tisdall
which doesn't hit the .log file, iirc). > > B. > > > On 19 Aug 2012, at 11:30, CGS wrote: > >> On Sat, Aug 18, 2012 at 9:15 PM, Tim Tisdall wrote: >> >>> So, it's possible that couchdb is running out of memory when >>> processing a large JS

Re: couchdb returning truncated JSON

2012-08-19 Thread Tim Tisdall
umber of characters per line, truncating >> the message if more. It happened to me in few occasions (Linux terminal >> truncated my message because it was single line - line end was translated >> as "\n" inside the message, so, no real line break was actually registered). >&g

Re: couchdb returning truncated JSON

2012-08-19 Thread Tim Tisdall
Does the Mochiweb server have separate logs from couch? If not, then there was nothing in the logs. - Original message - > > On Aug 18, 2012, at 4:46 PM, Tim Tisdall wrote: > > > I have a script where I query a view for multiple entries of data. > > I'm d

couchdb returning truncated JSON

2012-08-18 Thread Tim Tisdall
I have a script where I query a view for multiple entries of data. I'm doing it in batches of 1000. It works fine multiple times and then suddenly it returns a result that doesn't properly parse as JSON because it's missing some content at the end (not sure how much, but it's at least missing the

Re: couchdb returning empty response

2012-08-18 Thread Tim Tisdall
ot of memory. > > The _design/_replicator error comes with multipart file set by cURL by > default in such cases. Once a second piece is sent toward the server, the > crash is registered. The first piece report looks like: > > [Sat, 18 Aug 2012 00:57:38 GMT] [debug] [<0.170.0>] &

Re: couchdb returning empty response

2012-08-17 Thread Tim Tisdall
Okay, so it always states that _replicator line any time I manually restart the server. I think it's just a standard logging message when the level is set to "debug". On Fri, Aug 17, 2012 at 1:13 PM, Tim Tisdall wrote: > No. All my ids (except for design documents) are

Re: couchdb returning empty response

2012-08-17 Thread Tim Tisdall
1:03 PM, Robert Newson wrote: > > Does app_stats_test contain a document called _design/_replicator or is a > document with that id in the body of your bulk post? > > B. > > On 17 Aug 2012, at 17:52, Tim Tisdall wrote: > >> I do have UTF8 characters in the JSON, bu

Re: couchdb returning empty response

2012-08-17 Thread Tim Tisdall
on-latin1 ones) in your JSON? That > error looks strangely close to trying to transform a list of unicode > characters into a binary. I might be wrong though. > > CGS > > > > On Fri, Aug 17, 2012 at 4:09 PM, Tim Tisdall wrote: > >> I thought I added that to the ini

Re: couchdb returning empty response

2012-08-17 Thread Tim Tisdall
e _replicator db is problematic (i.e, not possible) due to the > restrictions introduced by the 'systems db' feature combined with the > validation functions inside _design/_replicator. > > B. > > On 17 Aug 2012, at 15:09, Tim Tisdall wrote: > >> I thought I ad

Re: couchdb returning empty response

2012-08-17 Thread Tim Tisdall
d tracked it down > to the current working directory setting. It seems that the cwd is searched > first, and then erlang looks elsewhere. So, if our startup script doesn't > change it to somewhere that the couchdb user can read, you get spurious > eacces errors. > > Don&

Re: couchdb returning empty response

2012-08-16 Thread Tim Tisdall
gh system logs for any kind of resource issue and couldn't find anything. -Tim On Thu, Aug 16, 2012 at 4:07 PM, Dave Cottlehuber wrote: > On 16 August 2012 21:44, Dave Cottlehuber wrote: >> On 16 August 2012 17:16, Tim Tisdall wrote: >>> I tried running my code again and

Re: couchdb returning empty response

2012-08-16 Thread Tim Tisdall
e definitely never seen such a thing. > > On Thu, Aug 16, 2012 at 2:19 PM, Tim Tisdall wrote: >> Paul, did you ever solve the eaccess problem you had described here: >> http://mail-archives.apache.org/mod_mbox/couchdb-user/201106.mbox/%3c4e0b304f.5080...@lymegreen.co.uk%3E >>

Re: couchdb returning empty response

2012-08-16 Thread Tim Tisdall
#x27;ve also had the couchdb server restart without those eaccess errors. Will running couchdb in interactive mode give me any more logging information that what goes into couch.log? On Thu, Aug 16, 2012 at 3:44 PM, Dave Cottlehuber wrote: > On 16 August 2012 17:16, Tim Tisdall wrote: >>

Re: couchdb returning empty response

2012-08-16 Thread Tim Tisdall
Tue, Aug 14, 2012 at 9:38 PM, Tim Tisdall wrote: >> I'm still having problems with couchdb, but I'm trying out different >> things to see if I can narrow down what the problem is... >> >> I stopped using fsockopen() in PHP and am using curl now to hopefully

Re: couchdb returning empty response

2012-08-16 Thread Tim Tisdall
make - make install - useradd -d /var/lib/couchdb couchdb - chown -R couchdb: /var/{lib,log,run}/couchdb /etc/couchdb - chmod 0770 /var/{lib,log,run}/couchdb /etc/couchdb - update-rc.d couchdb defaults # start couchdb on system start On Thu, Aug 16, 2012 at 11:16 AM, Tim Tisdall wrote: > I tried ru

Re: couchdb returning empty response

2012-08-16 Thread Tim Tisdall
n error: eacces. Target: ./mochiweb_response.beam. Function: get_file. Process: code_server."}} here's the file listing for the file (as you can see it's readable by all): -rw-r--r-- 1 root staff 1420 Aug 7 21:11 /usr/local/lib/couchdb/erlang/lib/mochiweb-1.4.1/ebin/mochiweb_response.beam On Thu,

Re: couchdb returning empty response

2012-08-16 Thread Tim Tisdall
ied typing "continue" into gdb and the process stays "defunct". Do I need to install the debugging versions of all those libraries in order for this to work? -Tim On Tue, Aug 14, 2012 at 11:41 PM, Paul Davis wrote: > On Tue, Aug 14, 2012 at 9:38 PM, Tim Tisdall wrote: >>

couchdb returning empty response

2012-08-14 Thread Tim Tisdall
I'm still having problems with couchdb, but I'm trying out different things to see if I can narrow down what the problem is... I stopped using fsockopen() in PHP and am using curl now to hopefully be able to see more debugging info. I get an empty response when sending a POST to _bulk_docs. From

Re: admin party has been crashed!

2012-08-07 Thread Tim Tisdall
9:45 PM, Tim Tisdall wrote: > I never set up any user accounts and was enjoying the admin party... > I tried recompiling couchdb and then tried running the test suite to > check things out. However, the test suite died after creating a user > account (I think) and thus crashing my r

admin party has been crashed!

2012-08-07 Thread Tim Tisdall
I never set up any user accounts and was enjoying the admin party... I tried recompiling couchdb and then tried running the test suite to check things out. However, the test suite died after creating a user account (I think) and thus crashing my rock'n admin party. So, now I seem to be locked out

Re: more refused connections

2012-08-07 Thread Tim Tisdall
sure I don't lose all my data... "make install" knows to leave the .couch files alone, right? :) -Tim On Tue, Aug 7, 2012 at 2:11 PM, Tim Tisdall wrote: > I have /var/lib/couchdb as the home directory for the couchdb user and > it's set to be rwx by that user. I

Re: more refused connections

2012-08-07 Thread Tim Tisdall
but can still login, then we must have > found a readable copy somewhere. I've seen this happen in bigcouch clusters > recently, and tracked it (somewhat laboriously) to the bigcouch startup > script. Adding a simple 'cd ~bigcouch' was the fix there. > > B. > &

Re: more refused connections

2012-08-07 Thread Tim Tisdall
tarts showing those "eacces" errors and then the server seems to restart and continue running with no problem. Ideas? -Tim On Mon, Aug 6, 2012 at 5:41 PM, Tim Tisdall wrote: > I can confirm that the server is running before and directly after the > error occurs. I think I'v

Re: more refused connections

2012-08-06 Thread Tim Tisdall
with the debugging... > > - Can you confirm that CouchDB is actually running when you see this > problem? > > - How are you connecting to CouchDB from PHP? Are you using a library? > > - What version of CouchDB are you using? > > - Can you provide a reliable set o

more refused connections

2012-08-05 Thread Tim Tisdall
Well, I've had this problem before, but I still have no idea what caused it then, why it went away, or why it's back again. :S "PHP Warning: fsockopen(): unable to connect to localhost:5984 (Connection refused)" After making several bulk updates of about 100 documents each, I then get this warn

Re: accessing previous document revisions within a view

2012-07-26 Thread Tim Tisdall
, Robert Newson wrote: > Tim, > > The couchdb revision system is to provide eventual consistency between > database replicas. It is not a user-facing document versioning system. Old > revisions are deleted during compaction and are not replicated either. > > B. > > O

Re: accessing previous document revisions within a view

2012-07-26 Thread Tim Tisdall
t; > [1] http://wiki.apache.org/couchdb/Document_revisions > > -- > ,,,^..^,,, > > > On Thu, Jul 26, 2012 at 2:29 AM, Tim Tisdall wrote: >> Is it possible to access a previous revision of a document from within >> a view? I'd like to output something in a view based on the >> difference between the revisions of the documents. >> >> -Tim

accessing previous document revisions within a view

2012-07-25 Thread Tim Tisdall
Is it possible to access a previous revision of a document from within a view? I'd like to output something in a view based on the difference between the revisions of the documents. -Tim

Re: Compaction Best Practices

2012-06-14 Thread Tim Tisdall
modify those records. Just query them up in certain >> cases. >> >> Regarding Robert's suggestion, I was indeed confused because he was >> suggesting to delete them one by one. >> >> I need to read about the "lower_revs_limit". We never replicate this data. &

Re: Compaction Best Practices

2012-06-14 Thread Tim Tisdall
I think he's suggesting avoiding compaction completely. Just delete the old DB when you've finished deleting all the records. On Thu, Jun 14, 2012 at 9:05 AM, Nicolas Peeters wrote: > Interesting suggestion. However, this would perhaps have the same effect > (deleting/compacting the old DB is wh

Re: result from _bulk_docs update being truncated

2012-06-08 Thread Tim Tisdall
don't think makes a lot of sense when the result (I think) never has any line endings. fread() simply reads the number of bytes indicated in a binary-safe way. -Tim On Fri, Jun 8, 2012 at 9:55 AM, Dave Cottlehuber wrote: > On 8 June 2012 15:47, Tim Tisdall wrote: >> I'm havin

Re: Adding vs replicating documents

2012-06-08 Thread Tim Tisdall
I was going to suggest something like this too. However, if you have access to the script, you could alter it to record in a separate file which documents have been altered and then write another script to only send those docs to the couchdb server. (This is essentially duplicating what the couch

result from _bulk_docs update being truncated

2012-06-08 Thread Tim Tisdall
I'm having a strange intermittent problem where the result returned from a POST to _bulk_docs is being truncated. I know it's being truncated because the truncation makes the result invalid JSON and my script throws an exception because it can't decode it. However, I can't replicate it consistent

Re: limit on number of docs updated via _bulk_docs?

2012-06-05 Thread Tim Tisdall
affects the other but I guess it's something on the OS level. -Tim On Tue, Jun 5, 2012 at 8:43 AM, Tim Tisdall wrote: > Um...  I seemed to have fixed the problem, but I'm not sure how.  :S > The problem wasn't related to POSTs to _bulk_docs, though, but to > fetching doc

Re: limit on number of docs updated via _bulk_docs?

2012-06-05 Thread Tim Tisdall
cause had nothing to do with couchdb... I'll let you guys know if I manage to figure it out. -Tim On Tue, Jun 5, 2012 at 7:55 AM, Tim Tisdall wrote: > Yeah, I've done other bulk updates with millions and had no problem > either, that's why I'm not sure what's going

Re: limit on number of docs updated via _bulk_docs?

2012-06-05 Thread Tim Tisdall
g at that > document, try to isolate it and to make a single insertion with it only > (you will get back an error and, at least, it will give you a hint where > the problem is). > > That is what comes to my mind now. If I have more ideas, I will let you > know. > > CGS >

limit on number of docs updated via _bulk_docs?

2012-06-04 Thread Tim Tisdall
Hopefully someone can give me an idea on this problem because I think I've about exhausted ideas. I'm doing a series of document updates fairly rapidly. I was doing the updates via PUT and was having no problems except for the DB file size growing way too fast. I changed things to update the dat

Re: local.ini settings not taking precedence

2012-06-01 Thread Tim Tisdall
wrote: > On 1 June 2012 17:09, Tim Tisdall wrote: > > Maybe I'm missing something simple, but my understanding is that > local.ini > > values should take precedence over values in default.ini . However, I'm > > trying to set nodelay to true for the so

local.ini settings not taking precedence

2012-06-01 Thread Tim Tisdall
Maybe I'm missing something simple, but my understanding is that local.ini values should take precedence over values in default.ini . However, I'm trying to set nodelay to true for the socket_options and that doesn't appear to be working. Here's what's in default.ini : socket_options = [{keepaliv

Re: oops! cancel temporary view creation?

2012-05-22 Thread Tim Tisdall
Yep, a call to _view_cleanup worked as you expected... curl -H "Content-Type: application/json" -X POST http://localhost:5984/my_database/_view_cleanup On Mon, May 21, 2012 at 2:01 PM, Matthieu Rakotojaona < matthieu.rakotoja...@gmail.com> wrote: > On Mon, May 21, 2012 at 7

Re: oops! cancel temporary view creation?

2012-05-21 Thread Tim Tisdall
Sorry for my ignorance, but how do you delete a temporary view? Or can I just safely delete the .view file in /var/lib/couchdb since it's transient? On Mon, May 21, 2012 at 1:30 PM, Matthieu Rakotojaona < matthieu.rakotoja...@gmail.com> wrote: > Just stop the server, it will also stop the view c

oops! cancel temporary view creation?

2012-05-21 Thread Tim Tisdall
I went to http://localhost:5984/_utils/database.html?my_database/_temp_view and hit "Run" with the default code in there. This normally wouldn't be a big deal, but my database is 6.5gb so it's taking a very very long time to complet

Re: purging documents?

2012-05-21 Thread Tim Tisdall
gt; On Fri, May 18, 2012 at 1:02 PM, Jim Klo wrote: > > Not sure how many docs you have, but can you filter replicate the good > docs > > into a new db? > > > > > > Jim Klo > > Senior Software Engineer > > Center for Software Engineering > > SR

Re: purging documents?

2012-05-18 Thread Tim Tisdall
After further reading it seems like I could use _purge ... However, I still need to query the DB to fetch all the revisions. On Fri, May 18, 2012 at 12:12 PM, Tim Tisdall wrote: > I accidentally created several million documents in my DB which I'd like > to undo. ^_^ I know I can

purging documents?

2012-05-18 Thread Tim Tisdall
I accidentally created several million documents in my DB which I'd like to undo. ^_^ I know I can query each document to get the revision and then issue a DELETE, but that seems like a lot of additional work. Also, the wiki says "Deleted documents remain in the database forever, even after comp

Re: manipulating .couch files

2012-05-18 Thread Tim Tisdall
bingo! Yeah, port forwarding would be the best way to go! On Fri, May 18, 2012 at 4:05 AM, Dave Cottlehuber wrote: > On 17 May 2012 20:58, Tim Tisdall wrote: > > > I want to temporarily open the port for couchdb so I can access futon. > > However, I have a large databas

manipulating .couch files

2012-05-17 Thread Tim Tisdall
I want to temporarily open the port for couchdb so I can access futon. However, I have a large database already in there that I don't want accessible by the public. If I temporarily move the database_name.couch file from the var/lib/couchdb/ directory and then move it back after allow me to hide

Re: reducing db size

2012-05-14 Thread Tim Tisdall
t 3:08 PM, James Marca > wrote: > > On Mon, May 14, 2012 at 03:42:01PM -0400, Tim Tisdall wrote: > >> Yes, I did it with a PUT for each id. When you call for compaction, is > >> there a way to see the progress or a way to know if it's done? > > > > the

Re: reducing db size

2012-05-14 Thread Tim Tisdall
Okay, I see that you can tell that it's running by doing a GET on the database in question and looking for the "compact_running":true . However, I don't seem to see any changes in the db's file size. On Mon, May 14, 2012 at 3:42 PM, Tim Tisdall wrote: > Yes, I d

Re: reducing db size

2012-05-14 Thread Tim Tisdall
ards. > > On Mon, May 14, 2012 at 2:13 PM, Tim Tisdall wrote: > > I've got several gigabytes of data that I'm trying to store in a couchdb > on > > a single machine. I've placed a section of the data in an sqlite db and > > the file is about 5.9gb. I'm

  1   2   >