From: Niel Smith <nsmith(at)equature(dot)com>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject:
Date: 2017-06-28 18:22:52
Message-ID: CACye3hR0K66cmHP7kqqUP8gz=aWKqYBC8se3xhfVGqCB8rzsCQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.ServiceHos
tingEnvironment+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 <(248)%20359-8860> - Office Phone
888.305.3428 <(888)%20305-3428> - 24 Hour Support

*Interactive Response*

Police * Fire * EMT * Military * Security

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

Responses

  • Re: at 2017-06-28 18:28:54 from Michael Rasmussen

Browse pgadmin-support by date

  From Date Subject
Next Message Michael Rasmussen 2017-06-28 18:28:54 Re:
Previous Message Darren Duncan 2017-06-28 18:14:15 request link to maintained pgAdmin 3 fork on main project page