On 19-7-2016 06:25, 'maciej...@gmail.com' maciej...@gmail.com [firebird-support] wrote: > I have a question about the information in the log Firebird (version > Firebird: 2.1.5.18496).). The server was installed as SuperServer. The > problem occurs in Windows XP SP3.
2.1.5 is not the latest 2.1; that is 2.1.7; several critical bugs were fixed since 2.1.5. However 2.1.x is no longer supported, and you should serioulsy consider upgrading 2.5 or 3.0. > A customer who uses the software that runs on the database engine > firebird I reported a problem with the operation of the application. > Please explain in detail the following errors. What could be the cause > of their occurrence? and *which ones are* *disturbing*? What should I > do, that these errors do not appear in the future ? Not all of these messages are errors. > /1. //POS003 (Server) Fri Jul 15 11:56:32 2016/ > > / Database: C:\GASTRO.FDB/ > > / Index 6 is corrupt (missing entries) in table POZRACH > (259)/ Potentially disturbing. A backup and (if successful) a restore might be in order. If the backup fails, you may first need to repair the database first. > /2. //POS003 (Server) //Fri Jul 15 12:17:29 2016/ > > / INET/inet_error: read errno = 10053/ Error 10053 is winsock error WSAECONNABORTED: "Software caused connection abort. An established connection was aborted by the software in your host computer, possibly due to a data transmission time-out or protocol error." Not really important, but it might point to network problems or the application ending without properly closing the connection. This may indicate data loss of active (uncommitted) transaction of that process. > /3. //POS00//3 (Server) Fri Jul 15 12:17:32 2016/ > > / INET/inet_error: read errno = 10054/ Error 10054 is winsock error WSAECONNRESET: "Connection reset by peer. An existing connection was forcibly closed by the remote host. This normally results if the peer application on the remote host is suddenly stopped, the host is rebooted, the host or remote network interface is disabled, or the remote host uses a hard close. This error may also result if a connection was broken due to keep-alive activity detecting a failure while one or more operations are in progress. Operations that were in progress fail with WSAENETRESET. Subsequent operations fail with WSAECONNRESET." Not important. May point to an application terminating abruptly, or to an application not properly closing a connection. > /4. //POS003 (Client) Fri Jul 15 12:47:58 2016/ > > / INET/inet_error: connect errno = 10061/ Error 10061 is winsock error WSAECONNREFUSED: "Connection refused. No connection could be made because the target computer actively refused it. This usually results from trying to connect to a service that is inactive on the foreign host—that is, one with no server application running." Harmless. This means that a client attempted to connect to a port that wasn't open (eg no Firebird server running, wrong port number). > /5. //POS003 (Client) Fri Jul 15 12:43:27 2016/ > > / Guardian starting: "C:\Program > Files\Firebird\Firebird_2_1\bin\fbserver.exe"/ Informational message. Note that you shouldn't be using Guardian, it is an ancient way of keeping Firebird running (eg on process crash) that is no longer necessary when running as a service. > /6. //POS003 (Server) Mon Jul 18 12:51:48 2016/ > > / Shutting down the Firebird service with 1 active > connection(s) to 1 database(s)/ Informational message. Something or someone stopped the Firebird service while there were still connections. This may indicate potentially cause data loss if that connection had active transactions. Mark -- Mark Rotteveel