ansaurus

Question

Answer 1

A:

Are you disposing your connections? MySQL itself has connection pooling and the way to return connections to the pool is by disposing them.

Garbage collection should not pose a problem if you are correctly disposing your connections after you've used them.

Pieter 2010-10-23 16:12:55

Interesting. I was wondering why when i close my app i still have so many questions. I am going to pretend it is a dispose problem and nothing else is causing this problem

acidzombie24 2010-10-23 16:13:45

You should really try to hunt down any non-disposed connections. This will most likely solve your problems.

Pieter 2010-10-23 16:14:49

I hunted down all of them. There were two areas without the using keyword outside of the class that does it in dispose(). But the errors still happen. Its pretty annoying because this crashes causing me to manually ctrl alt del the webdev process (for asp.net) every 10mins. I wonder if dispose is called when an exception is thrown. Maybe i forgot using on my main class and thats the problem? //talking to others or yourself in a comment helps

acidzombie24 2010-10-23 16:42:09

Everything is dispose of except i have 5 members not having the using() keyword but thats because the object is passed into a thread that lives forever. So that is only being created once so... i dont get it... Even between stop/starts it should either not create it bc it exist or kill it on stop so... wtf... This isnt the problem? This is annoying.

acidzombie24 2010-10-23 16:46:53

Yes, dispose is called when an exception happens. Concerning the threads: how many threads are there running after 10 minutes?

Pieter 2010-10-23 17:15:56

The same amount. I only do it on app init. No where else. There might be additional classes but they are dispose of.

acidzombie24 2010-10-23 22:19:20

ansaurus

tags:

views:

answers:

Randomly Cant connect to local MySQL?

related questions