Re: - Mailing list pgadmin-support

From Michael Rasmussen
Subject Re:
Date
Msg-id 51F97244-5D6D-4EDC-850F-A6A7DDCC906A@porch.com
Whole thread Raw
In response to  (Niel Smith <nsmith@equature.com>)
Responses Re:  (Jaime Casanova <jaime.casanova@2ndquadrant.com>)
List pgadmin-support

Hi Niel –

 

This mailing list is only for support with the desktop client pgAdmin.  Your problem is server related. Please send your request to pgsql-general@postgresql.org, and they will be better able to help you there.

 

-- 

Michael Rasmussen

Sr. Data Engineer

Porch

 

From: Niel Smith <nsmith@equature.com>
Date: Wednesday, June 28, 2017 at 11:22 AM
To: "pgadmin-support@lists.postgresql.org" <pgadmin-support@lists.postgresql.org>
Subject: <no subject>

 

Hi,

 

So I have a few problems with my PostGreSQL and was hoping you could help me out. one is I'm getting random timeouts and the errors I'm seeing in the logs are 

 

On the 6/22/17 at 10:51am we had  ERROR [08001] timeout expired at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)  

 

 2:23pm we had Error during indexfile unfixed fields readCurIndex: 6598CurFileNum: 551

 

4;25 pm Error during indexfile unfixed fields readCurIndex: 7054CurFileNum: 551   

 

6/23/17 @ 5:57PM Error during indexfile unfixed fields readCurIndex: 4449CurFileNum: 552

 

6/24/17 9:43 am ERROR [08001] timeout expired

   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

 

6/26/17 7:21am  Exception during IsDuplicateSelect ID from di_central.di_web_records where starttime = '2017-06-26 01:07:34' AND channelnum = 95 AND ulseqlow = 5095480The connection has been disabled.   at System.Data.Odbc.OdbcConnection.ConnectionIsAlive(Exception innerException)

 

x2 6/26/17 7:21am ERROR [08001] FATAL:  the database system is shutting down

   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

 

 Having an Issue of timing out or just randomly shutting down?  other errors I'm getting are duplicate key value violates unique constraint "di_web_users_pkey"  

2017-06-21 06:53:09 MDT ERROR:  relation "di_central.di_web_user_hmaxfield" does not exist at character 37

2017-06-21 06:53:09 MDT STATEMENT:  select column_name, is_checked from di_central.di_web_user_hmaxfield

2017-06-21 09:43:35 MDT LOG:  could not receive data from client: An established connection was aborted by the software in your host machine.

 

2017-06-26 07:21:35 MDT FATAL:  terminating connection due to administrator command

2017-06-26 07:21:47 MDT FATAL:  the database system is shutting down

 

I also have MySQL running on this PC and have an error in event viewer we have a spam of errors  Task category is WebHost and the source is system.serviceModel 4.0.0.0 WebHost failed to process a request.

 Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/45653674

 Exception: System.ServiceModel.ServiceActivationException: The service '/MySQLService.svc' cannot be activated due to an exception during compilation.  The exception message is: Memory gates checking failed because the free memory (89677824 bytes) is less than 5% of total memory. Process Name: w3wp Process ID: 10672

 

if anyone can help me out with these errors that would be very much appreciated.

 

Thank you

 


Niel Smith - Support Technician

Equature

18311 W. 10 Mile Rd.

Southfield, Michigan 48075

248.359.8860 - Office Phone

888.305.3428 - 24 Hour Support

 

Interactive Response

Police * Fire * EMT * Military * Security

 

ttp://www.equature.com/wp-content/uploads/2015/05/eq-logo-tiny-2015.fw_.png

 

pgadmin-support by date:

Previous
From: Niel Smith
Date:
Subject:
Next
From: Jaime Casanova
Date:
Subject: Re: