Please unlock this message is just an attached log...
Have been doing checks for this issue... but have not been able to make
this work properly if I don't a synchronous way of doing initial upload...
have tried modifying some postgres parameters....
like deadlock_timeout, making checkpoint happening each more time.. with
checkpoint_segments, checkpoint_completion_target....
checkpoint_timeout... and so...
Have not modified any sync parameter because I think we should let
servers to commit changes the way they have been configured for...
because each platform finally is different
so I think this should not be changed....
So... what could we do mates?.
Any ideas? My config is this one (note I'm doing streaming replication)
listen_addresses = '*'
max_connections = 100 # (change requires restart)
shared_buffers = 2GB # min 128kB
work_mem = 5MB # min 64kB
maintenance_work_mem = 400MB # min 1MB
wal_level = hot_standby
max_wal_senders = 5
archive_mode = on
archive_command = 'cp %p /expert/bbdd/archivowal/%f'
wal_keep_segments = 20
effective_cache_size = 2500MB
log_destination = 'syslog'
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
silent_mode = on
log_min_messages = debug1
update_process_title = on
autovacuum = on # Enable autovacuum subprocess? 'on'
autovacuum_max_workers = 2 # max number of autovacuum subprocesses
autovacuum_naptime = 2400
autovacuum_vacuum_cost_delay = 100ms # default vacuum cost delay for
datestyle = 'iso, mdy'
lc_messages = 'C' # locale for system error message
lc_monetary = 'C' # locale for monetary formatting
lc_numeric = 'C' # locale for number formatting
lc_time = 'C' # locale for time formatting
default_text_search_config = 'pg_catalog.english'
Cheers!
-------- Mensaje reenviado --------
Return-Path: <davical-general-bounces@lists.sourceforge.net>
Received: from mx7c.sarenet.es (localhost.mx7c.sarenet.es [127.0.0.1])
by mx7c.sarenet.es with LMTPA; Tue, 26 Jan 2016 09:23:01 +0100
X-Sieve: CMU Sieve 2.3
Received: from smtp2.sarenet.es (smtp2.sarenet.es [194.30.0.71]) by
mx7c.sarenet.es (Postfix) with ESMTP id 4C17A60BEEB0 for
<egoitz@sarenet.es>; Tue, 26 Jan 2016 09:23:01 +0100 (CET)
Received: from antispam1.sarenet.es (antispam1.sarenet.es
[194.30.0.144]) by smtp2a.sarenet.es (Postfix) with ESMTP id 4344210711D
for <egoitz@sarenet.es>; Tue, 26 Jan 2016 09:23:01 +0100 (CET)
X-Virus-Scanned: by SareMail Shield
X-CTCH-RefID:
str=0001.0A0B0206.56A72CE5.009F:SCFSTAT20185943,ss=1,re=-4.000,recu=0.000,reip=0.000,cl=1,cld=1,fgs=256
X-Spam-Flag: NO
X-Spam-Score: -1
X-Spam-Level:
X-Spam-Status: No, score=-1 tagged_above=-20 required=5
tests=[CTASD_SPAM_UNKNOWN=-1] autolearn=disabled
Authentication-Results: antispam1.sarenet.es (amavisd-new); dkim=pass
(1024-bit key) header.d=lists.sourceforge.net
Received: from smtp2.sarenet.es ([194.30.0.71]) by antispam1.sarenet.es
(antispam1.sarenet.es [194.30.0.144]) (amavisd-new, port 10024) with
ESMTP id SNxvwehT4VHM for <egoitz@sarenet.es>; Tue, 26 Jan 2016 09:23:00
+0100 (CET)
Received-SPF: pass (lists.sourceforge.net ... _spf.sourceforge.com:
216.34.181.88 is authorized to use
'davical-general-bounces@lists.sourceforge.net' in 'mfrom' identity
(mechanism 'ip4:216.34.181.0/24' matched)) receiver=smtp2;
identity=mailfrom;
envelope-from="davical-general-bounces@lists.sourceforge.net";
helo=lists.sourceforge.net; client-ip=216.34.181.88
Received: from lists.sourceforge.net (lists.sourceforge.net
[216.34.181.88]) by smtp2.sarenet.es (Postfix) with ESMTPS id
B0B40107A23 for <egoitz@sarenet.es>; Tue, 26 Jan 2016 09:23:00 +0100 (CET)
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
d=lists.sourceforge.net; s=beta;
h=List-Id:Date:Message-ID:To:From:Subject:Content-Transfer-Encoding:Content-Type:MIME-Version;
bh=o8Cm23xpTWGJfPs/4SFJigLYDnCMUKl1OJT6quyOlXw=;
b=fo4cDSifjS0/XnHMpbV+rMP+0viJ0/MbTOgVJAMhha1Fl7qO74LSAokGM2kKO5zZnDEJbTDFCgxUZd46IBS6YWQxkKoWhvuWaYOZHlMbATj4XZM+Fbl8DS/zZieIrzL63604tEALCHkUMuWmPfcsdBzaskjBQ9shcx3Trp+DbLQ=;
Received: from localhost ([127.0.0.1]
helo=sfs-ml-2.v29.ch3.sourceforge.com) by
sfs-ml-2.v29.ch3.sourceforge.com with esmtp (Exim 4.76) (envelope-from
<davical-general-bounces@lists.sourceforge.net>) id 1aNytv-0004RB-JP for
egoitz@sarenet.es; Tue, 26 Jan 2016 08:22:59 +0000
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Subject: Your message to Davical-general awaits moderator approval
From: davical-general-bounces@lists.sourceforge.net
To: egoitz@sarenet.es
Message-ID:
<mailman.14015.1453796578.3397.davical-general@lists.sourceforge.net>
Date: Tue, 26 Jan 2016 08:22:58 +0000
Precedence: bulk
X-BeenThere: davical-general@lists.sourceforge.net
X-Mailman-Version: 2.1.9
List-Id: General discussion about the DAViCal CalDAV Server
<davical-general.lists.sourceforge.net>
X-List-Administrivia: yes
Errors-To: davical-general-bounces@lists.sourceforge.net
Your mail to 'Davical-general' with the subject
Re: [Davical-general] Davical returning OK/2xx even when due to a
database lock it's not inserting in database
Is being held until the list moderator can review it for approval.
The reason it is being held:
Message body is too big: 49220 bytes with a limit of 40 KB
Either the message will get posted to the list, or you will receive
notification of the moderator's decision. If you would like to cancel
this posting, please visit the following URL:
https://lists.sourceforge.net/lists/confirm/davical-general/70d0de79b09ef0a0137a0b89b593ae559c0808d3
Have been doing checks for this issue... but have not been able to make
this work properly if I don't a synchronous way of doing initial upload...
have tried modifying some postgres parameters....
like deadlock_timeout, making checkpoint happening each more time.. with
checkpoint_segments, checkpoint_completion_target....
checkpoint_timeout... and so...
Have not modified any sync parameter because I think we should let
servers to commit changes the way they have been configured for...
because each platform finally is different
so I think this should not be changed....
So... what could we do mates?.
Any ideas? My config is this one (note I'm doing streaming replication)
listen_addresses = '*'
max_connections = 100 # (change requires restart)
shared_buffers = 2GB # min 128kB
work_mem = 5MB # min 64kB
maintenance_work_mem = 400MB # min 1MB
wal_level = hot_standby
max_wal_senders = 5
archive_mode = on
archive_command = 'cp %p /expert/bbdd/archivowal/%f'
wal_keep_segments = 20
effective_cache_size = 2500MB
log_destination = 'syslog'
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
silent_mode = on
log_min_messages = debug1
update_process_title = on
autovacuum = on # Enable autovacuum subprocess? 'on'
autovacuum_max_workers = 2 # max number of autovacuum subprocesses
autovacuum_naptime = 2400
autovacuum_vacuum_cost_delay = 100ms # default vacuum cost delay for
datestyle = 'iso, mdy'
lc_messages = 'C' # locale for system error message
lc_monetary = 'C' # locale for monetary formatting
lc_numeric = 'C' # locale for number formatting
lc_time = 'C' # locale for time formatting
default_text_search_config = 'pg_catalog.english'
Cheers!
-------- Mensaje reenviado --------
Return-Path: <davical-general-bounces@lists.sourceforge.net>
Received: from mx7c.sarenet.es (localhost.mx7c.sarenet.es [127.0.0.1])
by mx7c.sarenet.es with LMTPA; Tue, 26 Jan 2016 09:23:01 +0100
X-Sieve: CMU Sieve 2.3
Received: from smtp2.sarenet.es (smtp2.sarenet.es [194.30.0.71]) by
mx7c.sarenet.es (Postfix) with ESMTP id 4C17A60BEEB0 for
<egoitz@sarenet.es>; Tue, 26 Jan 2016 09:23:01 +0100 (CET)
Received: from antispam1.sarenet.es (antispam1.sarenet.es
[194.30.0.144]) by smtp2a.sarenet.es (Postfix) with ESMTP id 4344210711D
for <egoitz@sarenet.es>; Tue, 26 Jan 2016 09:23:01 +0100 (CET)
X-Virus-Scanned: by SareMail Shield
X-CTCH-RefID:
str=0001.0A0B0206.56A72CE5.009F:SCFSTAT20185943,ss=1,re=-4.000,recu=0.000,reip=0.000,cl=1,cld=1,fgs=256
X-Spam-Flag: NO
X-Spam-Score: -1
X-Spam-Level:
X-Spam-Status: No, score=-1 tagged_above=-20 required=5
tests=[CTASD_SPAM_UNKNOWN=-1] autolearn=disabled
Authentication-Results: antispam1.sarenet.es (amavisd-new); dkim=pass
(1024-bit key) header.d=lists.sourceforge.net
Received: from smtp2.sarenet.es ([194.30.0.71]) by antispam1.sarenet.es
(antispam1.sarenet.es [194.30.0.144]) (amavisd-new, port 10024) with
ESMTP id SNxvwehT4VHM for <egoitz@sarenet.es>; Tue, 26 Jan 2016 09:23:00
+0100 (CET)
Received-SPF: pass (lists.sourceforge.net ... _spf.sourceforge.com:
216.34.181.88 is authorized to use
'davical-general-bounces@lists.sourceforge.net' in 'mfrom' identity
(mechanism 'ip4:216.34.181.0/24' matched)) receiver=smtp2;
identity=mailfrom;
envelope-from="davical-general-bounces@lists.sourceforge.net";
helo=lists.sourceforge.net; client-ip=216.34.181.88
Received: from lists.sourceforge.net (lists.sourceforge.net
[216.34.181.88]) by smtp2.sarenet.es (Postfix) with ESMTPS id
B0B40107A23 for <egoitz@sarenet.es>; Tue, 26 Jan 2016 09:23:00 +0100 (CET)
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
d=lists.sourceforge.net; s=beta;
h=List-Id:Date:Message-ID:To:From:Subject:Content-Transfer-Encoding:Content-Type:MIME-Version;
bh=o8Cm23xpTWGJfPs/4SFJigLYDnCMUKl1OJT6quyOlXw=;
b=fo4cDSifjS0/XnHMpbV+rMP+0viJ0/MbTOgVJAMhha1Fl7qO74LSAokGM2kKO5zZnDEJbTDFCgxUZd46IBS6YWQxkKoWhvuWaYOZHlMbATj4XZM+Fbl8DS/zZieIrzL63604tEALCHkUMuWmPfcsdBzaskjBQ9shcx3Trp+DbLQ=;
Received: from localhost ([127.0.0.1]
helo=sfs-ml-2.v29.ch3.sourceforge.com) by
sfs-ml-2.v29.ch3.sourceforge.com with esmtp (Exim 4.76) (envelope-from
<davical-general-bounces@lists.sourceforge.net>) id 1aNytv-0004RB-JP for
egoitz@sarenet.es; Tue, 26 Jan 2016 08:22:59 +0000
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Subject: Your message to Davical-general awaits moderator approval
From: davical-general-bounces@lists.sourceforge.net
To: egoitz@sarenet.es
Message-ID:
<mailman.14015.1453796578.3397.davical-general@lists.sourceforge.net>
Date: Tue, 26 Jan 2016 08:22:58 +0000
Precedence: bulk
X-BeenThere: davical-general@lists.sourceforge.net
X-Mailman-Version: 2.1.9
List-Id: General discussion about the DAViCal CalDAV Server
<davical-general.lists.sourceforge.net>
X-List-Administrivia: yes
Errors-To: davical-general-bounces@lists.sourceforge.net
Your mail to 'Davical-general' with the subject
Re: [Davical-general] Davical returning OK/2xx even when due to a
database lock it's not inserting in database
Is being held until the list moderator can review it for approval.
The reason it is being held:
Message body is too big: 49220 bytes with a limit of 40 KB
Either the message will get posted to the list, or you will receive
notification of the moderator's decision. If you would like to cancel
this posting, please visit the following URL:
https://lists.sourceforge.net/lists/confirm/davical-general/70d0de79b09ef0a0137a0b89b593ae559c0808d3