- Mailing list pgadmin-support
From | Niel Smith |
---|---|
Subject | |
Date | |
Msg-id | CACye3hR0K66cmHP7kqqUP8gz=aWKqYBC8se3xhfVGqCB8rzsCQ@mail.gmail.com Whole thread Raw |
Responses |
Re:
|
List | 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.OdbcConnectio n.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_hmaxfi eld" 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_hmaxfie ld
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.ServiceAct ivationException: 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

pgadmin-support by date: