Re: [ADMIN] [PERFORM] Query Core Dumping

2011-02-08 Thread Sam Stearns
/usr/local/stow/perl-5.8.8/lib/5.8.8/i86pc-solaris /usr/local/stow/perl-5.8.8/lib/5.8.8 /usr/local/stow/perl-5.8.8/lib/site_perl/5.8.8/i86pc-solaris /usr/local/stow/perl-5.8.8/lib/site_perl/5.8.8 /usr/local/stow/perl-5.8.8/lib/site_perl . > Sam On Wed, Feb 9, 2011 at 10:

Re: [ADMIN] [PERFORM] Query Core Dumping

2011-02-08 Thread Sam Stearns
andard () #17 0x08068814 in S_run_body () #18 0x0806852b in perl_run () #19 0x08065ae0 in main () Sam On Wed, Feb 9, 2011 at 10:33 AM, Sam Stearns wrote: > Thanks, Tom.  Forwarded from pgsql-performance.  Working on stack > trace.  perl -V: > >> perl -V > Summary of my perl5 (revis

Re: [ADMIN] [PERFORM] Query Core Dumping

2011-02-08 Thread Sam Stearns
2006 21:33:23 @INC: /usr/local/stow/perl-5.8.8/lib/5.8.8/i86pc-solaris /usr/local/stow/perl-5.8.8/lib/5.8.8 /usr/local/stow/perl-5.8.8/lib/site_perl/5.8.8/i86pc-solaris /usr/local/stow/perl-5.8.8/lib/site_perl/5.8.8 /usr/local/stow/perl-5.8.8/lib/site_perl . > Sam On Wed, Fe

[ADMIN] Perl Libraries and Postgres

2011-02-09 Thread Sam Stearns
Howdy, Environment: Postgres 8.3.13 Solaris 10 I have a SELECT query that runs no problem standalone but when running within a perl script it intermittently core dumps. Random, no pattern to the timing of the core dumps. The perl script processes the rows from the query, if the rows satisfy a

Re: [ADMIN] Perl Libraries and Postgres

2011-02-10 Thread Sam Stearns
Thanks, Norbert! I'll run the perl 5.10 upgrade past the guys. Sam On Thu, Feb 10, 2011 at 6:27 PM, Norbert Zacharias wrote: > Moin, > >> Howdy, >> >> Environment: >> >> Postgres 8.3.13 >> Solaris 10 >> >> I have a SELECT query that runs no problem standalone but when running >> within a perl

Re: [ADMIN] Perl Libraries and Postgres

2011-02-15 Thread Sam Stearns
Thanks, Alex! I will take a look at your recommendations and keep you posted. Sam On Sat, Feb 12, 2011 at 3:28 AM, Alex Hunsaker wrote: > On Thu, Feb 10, 2011 at 03:24, Sam Stearns wrote: >> Thanks, Norbert! >> >> I'll run the perl 5.10 upgrade past the guys. >

[ADMIN] Unable to Insert Row

2011-05-02 Thread Sam Stearns
Howdy, Environment: Postgres 8.3.14 Solaris 10 When attempting to insert a row, the following error is received: ERROR: could not open relation with OID 926167091 This OID does not exist anywhere in the database. Most inserts on this table are successful. It is only for 2 particular id's wh

Fwd: [ADMIN] Unable to Insert Row

2011-05-03 Thread Sam Stearns
-- Forwarded message -- From: Sam Stearns Date: Tue, May 3, 2011 at 6:32 PM Subject: Re: [ADMIN] Unable to Insert Row To: Adarsh Sharma Thanks, Adarsh. I don't see any references to a repair command in the 8.3 doco. On Tue, May 3, 2011 at 5:06 PM, Adarsh Sharma wrote:

Re: [ADMIN] Unable to Insert Row

2011-05-03 Thread Sam Stearns
Does anyone else have any ideas on how to solve this problem besides this mysterious repair command? On Tue, May 3, 2011 at 6:33 PM, Sam Stearns wrote: > -- Forwarded message -- > From: Sam Stearns > Date: Tue, May 3, 2011 at 6:32 PM > Subject: Re: [ADMIN] Unable t

Re: [ADMIN] Unable to Insert Row

2011-05-04 Thread Sam Stearns
Dump/restore of table resolved this problem. On Wed, May 4, 2011 at 8:22 AM, Sam Stearns wrote: > Does anyone else have any ideas on how to solve this problem besides > this mysterious repair command? > > On Tue, May 3, 2011 at 6:33 PM, Sam Stearns wrote: >> --

Re: [ADMIN] Unable to Insert Row

2011-05-05 Thread Sam Stearns
Noted. Thanks, Ross. On Fri, May 6, 2011 at 2:02 AM, Ross J. Reedstrom wrote: > On Thu, May 05, 2011 at 08:23:16AM +0930, Sam Stearns wrote: >> Dump/restore of table resolved this problem. > > Yeah, the 'repair' advice was probably bleed over from some other open >

[ADMIN] Unable To Establish Connections

2011-05-17 Thread Sam Stearns
Howdy, Environment: Postgres 8.2.3 Solaris 10 We were unable to make a remote postgres connection for ~2 hours this afternoon. Receiving the following message in the postgres log every 30 seconds: LOG: expected password response, got message type 88 Connection limit is 300. 17 active connec

Re: [ADMIN] Unable To Establish Connections

2011-05-17 Thread Sam Stearns
Anyone have any ideas on this? We're an ISP. I was thinking of the possibility of a hack attempt. On Tue, May 17, 2011 at 6:52 PM, Sam Stearns wrote: > Howdy, > > Environment: > > Postgres 8.2.3 > Solaris 10 > > We were unable to make a remote postgres connection

Re: [ADMIN] Unable To Establish Connections

2011-05-17 Thread Sam Stearns
er." > > also > "It looks to me like the ODBC driver is failing to follow the protocol. > It shouldn't respond with an 'X' if it doesn't have a password, just > disconnect." > I would start logging traffic so you have more to go on next time it &g

Re: [ADMIN] Unable To Establish Connections

2011-05-18 Thread Sam Stearns
Future reference: Problem was caused by primary DNS resolver suffering from degraded performance. Server experienced a software issue with BIND, the software that performs DNS resolution. On Wed, May 18, 2011 at 10:11 AM, Sam Stearns wrote: > Thanks, Tim. > > I've turned up log

Re: [ADMIN] Unable To Establish Connections

2011-05-21 Thread Sam Stearns
Anyone have any ideas on this? We're an ISP. I was thinking of the possibility of a hack attempt. On Tue, May 17, 2011 at 6:52 PM, Sam Stearns wrote: > Howdy, > > Environment: > > Postgres 8.2.3 > Solaris 10 > > We were unable to make a remote postgres connection