So, the big company in Indiana that now owns us is having a consulting company install a java portal server. We pay (imnsho) an astounding amount for support and maintenance and the consulting company uses our support contract when they run into problems with the initial build (about 1/2 done at present). Below is a part of the actual thread between consulting company and portal support.
Ah, the beauty and simplicity of treating a database server as though tables were merely text files and keeping all constraints in client code because you can do that with ORM.
Consultant: The Java process has CPU pegged. Pages are slow to load and occasionally return with an "Internal Server Error"
When we do get an “Internal Server Error”, this shows in the log: ...
I tried rebooting the server, but it spikes again. I also attempted increasing the heap size, but it didn't seem to make a differerence. [SIC]
Can I get help troubleshooting this? Thanks.
Paid Support: Looking at your database, there appear to be two problematic web contents articles, named '500' and '404'. Each has hundreds of coppies [SIC] that all share the same primary key. This is a problem because no web content articles should have the same primary key. Do you know how these web content articles were created?
Ah, the beauty and simplicity of treating a database server as though tables were merely text files and keeping all constraints in client code because you can do that with ORM.