From: | Michael Rasmussen <michaelr(at)porch(dot)com> |
---|---|
To: | Niel Smith <nsmith(at)equature(dot)com>, "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
Subject: | Re: |
Date: | 2017-06-28 18:28:54 |
Message-ID: | 51F97244-5D6D-4EDC-850F-A6A7DDCC906A@porch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)postgresql(dot)org<mailto:pgsql-general(at)postgresql(dot)org>, and they will be better able to help you there.
--
Michael Rasmussen
Sr. Data Engineer
Porch
From: Niel Smith <nsmith(at)equature(dot)com>
Date: Wednesday, June 28, 2017 at 11:22 AM
To: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)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<tel:(248)%20359-8860> - Office Phone
888.305.3428<tel:(888)%20305-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]
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2017-06-28 18:53:05 | Re: |
Previous Message | Niel Smith | 2017-06-28 18:22:52 |