[GENERAL] 9.1.11 - many backends in "semtimedop" syscall

Hi, Ihave following situation: amazon, but not RDS - just plain EC2, with ubuntu system. zone reclaiming is disabled (at least in my system, no idea about host). and there is no "transparent huge page support". today we had at least 3 cases where bunch of abckends (~40) gets "interlocked". Some of

[GENERAL] extract psql meta-commands into library?

I'd like to provide access to psql's "backslash" meta-commands for IPython's %sql magic, as well as some other non-psql tools. When I asked about standalone implementations of the meta-commands, Craig Ringer suggested that extracting them from psql into a libpsql library (which psql would then use

Re: [GENERAL] 9.1.11 - many backends in "semtimedop" syscall

hubert depesz lubaczewski writes: > Thread 1 (LWP 21422): > #0 0x7ffa60da2dc7 in semop () from /lib/x86_64-linux-gnu/libc.so.6 > No symbol table info available. > #1 0x005f65e8 in PGSemaphoreLock () > No symbol table info available. > #2 0x00636125 in LWLockAcquire () > No s

Re: [GENERAL] 9.1.11 - many backends in "semtimedop" syscall

On Thu, Mar 06, 2014 at 11:56:06AM -0500, Tom Lane wrote: > hubert depesz lubaczewski writes: > > Thread 1 (LWP 21422): > > #0 0x7ffa60da2dc7 in semop () from /lib/x86_64-linux-gnu/libc.so.6 > > No symbol table info available. > > #1 0x005f65e8 in PGSemaphoreLock () > > No symbol tab

Re: [GENERAL] 9.1.11 - many backends in "semtimedop" syscall

hubert depesz lubaczewski writes: > I didn't have a chance to do it. Can try if there is a way to get trace > *without* making core (sorry, my c/gdb knowledge is very, very limited). Sure, you just attach to the process: $ gdb /path/to/postgres PID-of-process gdb> bt gdb>

Re: [GENERAL] 9.1.11 - many backends in "semtimedop" syscall

On Thu, Mar 06, 2014 at 12:02:50PM -0500, Tom Lane wrote: > hubert depesz lubaczewski writes: > > I didn't have a chance to do it. Can try if there is a way to get trace > > *without* making core (sorry, my c/gdb knowledge is very, very limited). > > Sure, you just attach to the process: > >

Re: [GENERAL] extract psql meta-commands into library?

Catherine Devlin writes: > I'd like to provide access to psql's "backslash" meta-commands for > IPython's %sql magic, as well as some other non-psql tools. When I > asked about standalone implementations of the meta-commands, Craig > Ringer suggested that extracting them from psql into a libpsql

Re: [GENERAL] Mysterious DB reset

For starters, this happened again this morning (no data prior to 4:45 am and sequence reset), so whatever is going on appears to be reoccurring. Also, I forgot to mention if it is significant: this is running on slackware liunux 14.0 On Mar 5, 2014, at 1:00 PM, Adrian Klaver wrote: > On 03/05/

Re: [GENERAL] Mysterious DB reset

On Mar 5, 2014, at 10:01 AM, Alvaro Herrera wrote: > Israel Brewster wrote: > >> So my question is, aside from someone going in and mucking about in the wee >> hours of the morning, what could possibly cause this behavior? What sort of >> event could cause all data to be deleted from the table

Re: [GENERAL] Mysterious DB reset

On Mar 5, 2014, at 10:01 AM, Thom Brown wrote:On 5 March 2014 18:22, Israel Brewster wrote: I have a Postgresql 9.2.4 database containing real-time tracking data for our aircraft for the past week (theoretically). It is populated by two different processes:

Re: [GENERAL] Mysterious DB reset

On 03/06/2014 09:33 AM, Israel Brewster wrote: For starters, this happened again this morning (no data prior to 4:45 am and sequence reset), so whatever is going on appears to be reoccurring. Also, I forgot to mention if it is significant: this is running on slackware liunux 14.0 On Mar 5, 201

Re: [GENERAL] Mysterious DB reset

On 3/6/14, Israel Brewster wrote: > LOG: received smart shutdown request > LOG: autovacuum launcher shutting down > LOG: shutting down > LOG: database system is shut down > > However, there are no timestamps on any of the entries (can I fix that?) Yes, change the log_line_prefix in the pos

Re: [GENERAL] Mysterious DB reset

On Mar 6, 2014, at 9:03 AM, Adrian Klaver wrote: > On 03/06/2014 09:33 AM, Israel Brewster wrote: >> For starters, this happened again this morning (no data prior to 4:45 am and >> sequence reset), so whatever is going on appears to be reoccurring. Also, I >> forgot to mention if it is signific

Re: [GENERAL] Mysterious DB reset

On 03/06/2014 10:43 AM, Israel Brewster wrote: On Mar 6, 2014, at 9:03 AM, Adrian Klaver wrote: Well something is happening. See my notes on logging below to help track down the cause. Yep. Might be good to explain your archive setup. Ok, here goes: We have the primary system whic

Re: [GENERAL] Mysterious DB reset

On Mar 6, 2014, at 10:03 AM, Adrian Klaver wrote: > On 03/06/2014 10:43 AM, Israel Brewster wrote: >> On Mar 6, 2014, at 9:03 AM, Adrian Klaver wrote: >> > >>> >>> Well something is happening. See my notes on logging below to help track >>> down the cause. >> >> Yep. >> > >>> >>> Might b

Re: [GENERAL] Mysterious DB reset

On 03/06/2014 11:09 AM, Israel Brewster wrote: On Mar 6, 2014, at 10:03 AM, Adrian Klaver wrote: Are all the scripts running from one machine? If so, have you checked that the times are set correctly on the various machines? Three different machines (due to OS requirements), but yeah the

Re: [GENERAL] high throughput 9.3, master/slave question

On 02/03/14 05:08, bricklen wrote: On Fri, Feb 28, 2014 at 1:54 PM, Matthew Chambers mailto:mchamb...@wetafx.co.nz>> wrote: Initially, I had my application servers using the slave for short, read only queries, but this turned out to be highly unstable. The slave would start refusi

Re: [GENERAL] Mysterious DB reset

Israel Brewster-2 wrote > So my question is, aside from someone going in and mucking about in the > wee hours of the morning, what could possibly cause this behavior? What > sort of event could cause all data to be deleted from the table, and the > sequence to be reset? Especially while there is an

Re: [GENERAL] Mysterious DB reset

On 03/06/2014 09:33 AM, Israel Brewster wrote: For starters, this happened again this morning (no data prior to 4:45 am and sequence reset), so whatever is going on appears to be reoccurring. Also, I forgot to mention if it is significant: this is running on slackware liunux 14.0 Also odd is

Re: [GENERAL] Offending My Tender Sensibilities -OR- OLTP on a Star Schema

On Tue, Mar 4, 2014 at 3:08 PM, Rob Sargent wrote: > Do you make a distinction between a key and an index? I'm not picking up on > design-by-natural-key and what that entails. Especially the notion that the > natural key of a given item might be mutable. What stops it from colliding > with the ne

Re: [GENERAL] Offending My Tender Sensibilities -OR- OLTP on a Star Schema

On 03/06/2014 03:52 PM, Merlin Moncure wrote: On Tue, Mar 4, 2014 at 3:08 PM, Rob Sargent wrote: Do you make a distinction between a key and an index? I'm not picking up on design-by-natural-key and what that entails. Especially the notion that the natural key of a given item might be mutable.

[GENERAL] problem with trigger function

I'm having a problem with a trigger function. I've been googling for over an hour, with no luck with my specific problem. I get this error: ERROR: missing FROM-clause entry for table "new" LINE 1: insert into metric_double_values_201203 values (NEW.metricID...

Re: [GENERAL] problem with trigger function

On 03/06/2014 04:08 PM, Susan Cassidy wrote: I'm having a problem with a trigger function. I've been googling for over an hour, with no luck with my specific problem. I get this error: ERROR: missing FROM-clause entry for table "new" LINE 1: insert into metric_double_values_201203 values (NEW.

[GENERAL] There is bug in PCS 0.9.26: configure pacemaker resource agent for PG stream replication

Hi all, I just complete my HA configuration on Redhat 6.4 enterprise: Clusterware: Pacemaker 1.1.8 ( CMAN .0.12.1, corosync 1.4.1 ) Resource manager: PCS 0.9.26 PostgreSQL 9.3.3.1 Detailed configuration follow: http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster#Post