Postgres Pro
Downloads
Home   >   mailing lists

Thread:

From
Niel Smith
Date:
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


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



Re:

From
Michael Rasmussen
Date:

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

 

Re:

From
Jaime Casanova
Date:
On 28 June 2017 at 13:28, Michael Rasmussen <michaelr@porch.com> wrote:
>
> This mailing list is only for support with the desktop client pgAdmin.  Your problem is server related. Please send
yourrequest to
 
> pgsql-general@postgresql.org, and they will be better able to help you there.
>
>

Actually, this doesn't look like a server-side problem either.
Messages shown says System.Data.Odbc.OdbcConnection which makes me
thing in app level problem.

The only postgresql messages here are:
"""
x2 6/26/17 7:21am ERROR [08001] FATAL:  the database system is shutting down  at
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandlehrHandle,
 
RetCode retcode)
"""
apparently shown via odbc message an informs the database is shutting
down that's not a problem specially since a few lines later it says:
"""
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
"""
explaining that the shutdown comes from administrator command and not
from an error

and the other one are:
"""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.
"""
which the first one says the app is not checking for uniqueness so the
database is doing it and the second that the table
"di_central.di_web_user_hmaxfield" does not exist

neither of both are postgresql failures

-- 
Jaime Casanova                      www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services