C
ChUIMonster
Guest
Killing shared memory connections _is_ unsafe. The kbase articles are correct to warn people not to do it. But, as Mike observes, the circumstances here are such that it ought not to matter. So what if your development db on your PC crashes? That's not a big deal. I have probably not read *every* kbase on the topic but the "unsafe" part of killing a shared memory connection is that it might cause the db to crash. BY ITSELF that will not cause any integrity problems. You will just restart and go through crash recovery. People end up with corruption and similar issues when they take additional steps like restarting with -F or using OS level tools to manipulate the data extents. There is an unfortunately strong correlation between people who use "kill -9" and people who take those other steps. That sometimes leads to the false impression that killing the shared memory connection corrupts data.
Continue reading...
Continue reading...