1
Why am I getting this mistake:
SSL SYSCALL error: EOF Detected
Connection is via local network via Delphi Application -> Posgtresql I use the ZEOS component for connection
0No answers
Browser other questions tagged delphi postgresql zeos
You are not signed in. Login or sign up in order to post.
Post the code that causes the error so we can help. Explain when this error appears (program opening? "Open" of the query?)
– Cleber Griff
Boy I would even like to put the code the problem is that I did not find at what moment this occurs with precision, because the application is connected without use and nothing of this error, I do not know where to debug to catch this error
– Marcelo
Hmm, there’s some Timer in the program, or some Thread that uses bank access or web access?
– Cleber Griff
There was a timer yes that consults minute to minute (at least), I left with this time to not overload... pass the two querys related to this timer and I could not see anything abnormal in them, including taking the Text in Debug and running by pgAdmin, looking on the internet I gave an increment in the component Zconnection, at first it seems that improved, I will monitor to see the result, it seems to have an effect, if it works I put the solution here.
– Marcelo
Do you disable the Timer when it starts and reactivates after it executes the queries? (Enable False/True) I imagined that one query is running "on top" of the other, before the previous one concludes. Think this may be the case?
– Cleber Griff
There is no query that lasts more than a minute, I think I solved the problem, I put some options in the component, codepage=UTF8 Autoencodestrings=ON controls_cp=GET_ACP isc_tpb_read_commited isc_tpb_concurrency isc_tpb_nowait exit_on_error=off It has been a long time that does not give the error, so I saw without these options existed exclusive access in some tables generating crash for some machines, I hope to have solved... this took my nights of sleep.
– Marcelo