Re: [ZODB-Dev] Question about relstorage and pack-gc

2012-07-13 Thread Santi Camps
On Fri, Jul 13, 2012 at 7:05 PM, Shane Hathaway wrote: > On 07/12/2012 01:30 PM, Santi Camps wrote: > >> My specific question is: if I disable pack-gc, can I safety empty >> object_ref table and free this space? >> > > Certainly. However, most of the 23 GB probably

[ZODB-Dev] Question about relstorage and pack-gc

2012-07-12 Thread Santi Camps
nt, no references to unexisting or empty transactions. So, information to garbage collection seems to be using a lot of space. My specific question is: if I disable pack-gc, can I safety empty object_ref table and free this space? Thanks in advance -- Santi Camps KMKey hacker (http://www.kmkey.co

Re: [ZODB-Dev] Copying zodb's with relstorage

2011-02-10 Thread Santi Camps
On Thu, Feb 10, 2011 at 5:07 PM, Shane Hathaway wrote: > On 02/10/2011 08:42 AM, Santi Camps wrote: > >> The objective is to duplicate a storage using different mount points. >> For instance, if we have Database1 -> mount_point_1 , create >> Database2 and Database3 as

Re: [ZODB-Dev] Copying zodb's with relstorage

2011-02-10 Thread Santi Camps
On Thu, Feb 10, 2011 at 3:46 PM, Shane Hathaway wrote: > On 02/10/2011 07:41 AM, Shane Hathaway wrote: > >> On 02/10/2011 06:30 AM, Santi Camps wrote: >> >>> I was trying to move a database copy a relstorage zodb and having some >>> issues. The original

[ZODB-Dev] Copying zodb's with relstorage

2011-02-10 Thread Santi Camps
:bytea; update transaction set username=replace(username::text, 'helpdesk_src', 'redesistemas')::bytea; Where is stored the information about parent -> children objects ? Is the prev_tid field of object_state table ? Thanks in advance -- Santi Camps KMKey hacker (htt

Re: [ZODB-Dev] Relstorage Database Adapter

2010-11-25 Thread Santi Camps
On Wed, Nov 24, 2010 at 7:24 PM, Shane Hathaway wrote: > On 11/24/2010 05:17 AM, Santi Camps wrote: > >> Hi all >> >> I'm using relstorage for a long time with very good results. Until >> know, I also use database adapters like ZPsycopgDA to connect the same &g

[ZODB-Dev] Relstorage Database Adapter

2010-11-24 Thread Santi Camps
_with_store(execute_query, query=query) print rows.fetchone() The question is, can I go on ? Or use same connections than relstorage could cause problems at ZODB level ? Thanks in advance -- Santi Camps KMKey hacker (http://www.kmkey.com) Earcon S.

[ZODB-Dev] Relstorage 1.4b3 error

2010-02-23 Thread Santi Camps
m, but I report it to you to be known (in fact, I don't know if the problem is in relstorage or in memcache). I'm working with python2.4.6 and python-memcache module version 1.40 Thanks a lot for this new release of relstorage, the performance testings are amazing -- Santi Camps KMKey hac

Re: [ZODB-Dev] Estrange behaviour with BTreeFolder2

2009-04-01 Thread Santi Camps
er that, this objects are never removed from memory, but the question is why they are loaded. Any ideas ? Thanks -- Santi Camps (Earcon S.L.) http://www.earcon.com http://www.kmkey.com ___ For more information about ZODB, see the ZODB Wiki: http://www.zope

Re: [ZODB-Dev] Estrange behaviour with BTreeFolder2

2009-04-01 Thread Santi Camps
to poll-interval parameter ? I've leaved default values there Thanks again -- Santi Camps (Earcon S.L.) http://www.earcon.com http://www.kmkey.com ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing

Re: [ZODB-Dev] Estrange behaviour with BTreeFolder2

2009-04-01 Thread Santi Camps
sistent). > No, all them inherit from CMF PortalContent, and this from Persistent, so there is not the problem. I'm using RelStorage, but this shouldn't affect. I will try the same tests in a FileStorage to be sure Thanks for your help -- Santi Camps (Earcon S.L.) http://www.earco

[ZODB-Dev] Estrange behaviour with BTreeFolder2

2009-04-01 Thread Santi Camps
r clears this from memory, and after some hours of intensive work, the server RAM is finished Is that normal ? I'm making some mistake ? Anybody knows any way to solve it ? Thanks in advance -- Santi Camps (Earcon S.L.) http://www.earcon.com http://www.kmkey.com _

Re: [ZODB-Dev] Relstorage pack problems

2009-01-26 Thread Santi Camps
my experiments with > packing your database has revealed some unexpected behavior. I'm going to > look into it. > Thanks again, Shane. We'll fix the script, try removing this 2 transactions and packing on a copy of the database, to see what happens. The last pack on a copy works, b

Re: [ZODB-Dev] Relstorage pack problems

2009-01-23 Thread Santi Camps
0;" should tell > you there is only one state in the database for OID 0. Packing should work > fine then. It seemed to do the right thing on my copy, but I don't have > your application code to check it. > Thank you very much for that information. I really could not be a

Re: [ZODB-Dev] Relstorage pack problems

2009-01-22 Thread Santi Camps
ose when packing (nothing references nothing). So, the mystery is not in Relstorage but in the data. The only right ways to solve it is to disable pack-gc or try to fill this tables correctly. Do you know any simple way to do it ? Perhaps an export / import should fill this tables

Re: [ZODB-Dev] Relstorage pack problems

2009-01-20 Thread Santi Camps
On Mon, Jan 19, 2009 at 8:22 PM, Shane Hathaway wrote: > Santi Camps wrote: >> We've been using RelStorage 1.1.c1 in production environments over >> postgresql 8.1 for some time. It has been working really fine, but >> yesterday we have a big problem packing a re

[ZODB-Dev] Relstorage pack problems

2009-01-19 Thread Santi Camps
e.py", line 255, in _log_keyerror rows = adapter.iter_object_history(cursor, oid_int) File "/usr/lib/python2.4/site-packages/relstorage/adapters/common.py", line 229, in iter_object_history raise KeyError(oid) KeyError: 7L Anybody knows what could happen ? Could be a problem access

Re: [ZODB-Dev] Open Connections with RelStorage

2008-10-23 Thread Santi Camps
On Thu, Oct 23, 2008 at 11:21 PM, Shane Hathaway <[EMAIL PROTECTED]> wrote: > Shane Hathaway wrote: >> Santi Camps wrote: >>> I've 8 zope's with 4 threads each one, and I've seen more than 50 open >>> connections used by relstorage. I was hopping

Re: [ZODB-Dev] Open Connections with RelStorage

2008-10-23 Thread Santi Camps
On Thu, Oct 23, 2008 at 7:47 PM, Shane Hathaway <[EMAIL PROTECTED]> wrote: > Santi Camps wrote: >> RelStorage is really fantastic, I'm starting to use it in some >> production environments with postgresql 8.1 and works really fine. >> But I've observed the

[ZODB-Dev] Open Connections with RelStorage

2008-10-23 Thread Santi Camps
I'm not able to debug ZODB and understant what's happening. Could be related to store files in the ZODB (so, in postgres through relstorage) ? Thanks in advance -- Santi Camps Earcon S.L. - http://www.earcon.com - http://www.kmkey.com ___