questdb
Exception while reading from stream
Describe the bug
Repeat steps 1、Delete tables in the web console 2、Use .net core Npgsql Operation of the database, a high probability of error
error messagae EndOfStreamException: Attempted to read past the end of the stream.
Restart the service to resolve the problem
To reproduce
No response
Expected Behavior
No response
Environment
- **QuestDB version : 6.5
Additional context
No response
I've seen this error with real Postgres in npgsql driver. I means that TCP connection is closed from the database or network infra.
QuestDB can close idle TCP connections after a timeout configured in pg.net.connection.timeout which defaults to 300_000 ms
It should be enough to close faulty Npgsql connection without returning it to the pool and open new one to fix the problem, restart should not be needed
This has nothing to do with PGSQL, but mainly because of the table deletion operation on your web console
Modification Table Structure and Truncate table are prone to problems, others are normal
Perhaps there is an error and connection dropped before returning the error to the client.
What is in server logs when this happens?
C# restarts still have occasional problems
You must restart the database service to resolve the problem