Kamil Srot wrote:
brian wrote:
IMHO, it's not at all improbable, given that this software is
connecting to the same databases you are seeing affected by this
phenomenon. Not to mention that it's proprietary, so fewer eyes
have gone over it.[1] I suggested earlier grepping for 'drop' in
your application. Perhaps you should do the same on the CMS.
[1] Not meant as a dig at non-free software.
Understood and I agree. I would accept the possibility to do the most
stupid coding error in the world, but there is simply no statement
manipulating with the schema in the whole project. To be sure, I
searched thru the sources for /drop/i and didn't found anywhere but
the pear framework of PHP (some constants and test patterns of user
statements)... OK, I agree this can be run by some coincidence and so
I have started to log all statements in the logfile... but still I
doubt executing the drop statement is the problem...
Just wondering: what's the name of this table? What's its function? I
think you mentioned that it's pretty well static. But what is it
holding? Maybe that'll provide a clue as to where to look.
brian
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
