Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

We are trying to run the insert statement , it shows below error :

ErrorMsg: [Vertica][VerticaDSII] (10) An error occurred during query preparation: no connection to the server

sometimes if i try running it again ,it gets executed successfully. I have increased the resultbuffersize,and also maxmemorysize for my resource pool .

Let me know what is the core issue and action to resolve this .

It's likely that your connection is getting closed because of a timeout, and you are trying to use a closed connection. When using connection pooling, you need logic in your code that pulls the connection out of the pool to check to see if the connection is still open. If it isn't, it needs to be discarded and a new, open connection created and returned.

It's usually your DBMS that is disconnecting the connection after a specified timeout. You can configure the DBMS to not ever disconnect, but that's usually a bad idea since you could easily end up with connection leaks, and your server could run out of connections, causing all future connections to fail until the server is restarted.

Thanks for contributing an answer to Stack Overflow!

• Please be sure to answer the question . Provide details and share your research!

But avoid …

• Asking for help, clarification, or responding to other answers.
• Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers .