Re: [GENERAL] PostGreSQL Timeout, auto shutdown and Pkey errors - Mailing list pgsql-general
From | Adrian Klaver |
---|---|
Subject | Re: [GENERAL] PostGreSQL Timeout, auto shutdown and Pkey errors |
Date | |
Msg-id | 1b84d68d-7d55-730e-db3b-54d1656a959c@aklaver.com Whole thread Raw |
In response to | [GENERAL] PostGreSQL Timeout, auto shutdown and Pkey errors (Niel Smith <nsmith@equature.com>) |
List | 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.klaver@aklaver.com
pgsql-general by date: