From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Niel Smith <nsmith(at)equature(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: PostGreSQL Timeout, auto shutdown and Pkey errors |
Date: | 2017-06-29 13:14:36 |
Message-ID: | 1b84d68d-7d55-730e-db3b-54d1656a959c@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 06/28/2017 11:32 AM, Niel Smith wrote:
> 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
What version of Postgres and where did you get it?
OS and version?
What is the source for the logs below?
>
> On the 6/22/17 at 10:51am we had ERROR [08001] timeout expired at
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode
> retcode)
A timeout expired, probably on client side.
Where are the clients relative to the server, local network or Internet?
>
> 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
Where are the above coming from as I can not find a reference to
readCurIndex in either the Postgres or psqodbc code?
>
> 6/24/17 9:43 am ERROR [08001] timeout expired
> at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle,
> RetCode retcode)
Another timeout.
>
> 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)
Looks like bad code in IsDuplicateSelect ID is triggering an exception
that shuts down the database.
>
> 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"
I am not seeing that in what you show. In any case that is what a unique
constraint is supposed to do, throw an error when you try to create a
duplicate entry. The client/application code will need to be able to
deal with that.
> 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
Looks like some external process is shutting down the server.
>
> 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
The only thing I understand in the above is:
"...the free memory (89677824 bytes) is less than 5% of total memory."
Whatever it is wants more memory.
>
> if anyone can help me out with these errors that would be very much
> appreciated.
>
> Thank you
>
>
> Niel Smith - Support Technician
> Equature
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Willy-Bas Loos | 2017-06-29 14:19:41 | RAM, the more the merrier? |
Previous Message | Adrian Klaver | 2017-06-29 13:12:25 | Re: PostGreSQL Timeout, auto shutdown and Pkey errors |