Message boards :
Help Wanted :
Closed: Find Broken Query
Message board moderation
Author | Message |
---|---|
Matt Lebofsky Send message Joined: 1 Mar 99 Posts: 1444 Credit: 957,058 RAC: 0 |
UPDATE: this has been solved by user Gerry Green. Thank you Gerry! [Edit - added "where to get code" information below] Occasionally I'll find a query of the form: select * from SETI_BOINC.user where N; where "SETI_BOINC" is the name of our mysql database, and N is an arbitrary integer, probably somebody's user id. This is obviously broken, and severely clogs our BOINC mysql database - since "where N" for any value of N > 0 is true, the query ends up really being: select * from user ..which gums up all cache with our entire user table. Where is this query happening? My guess is it is originating somewhere in html/ops/notify.php but it really could be anywhere. There's a bunch of php web code which has been converted to object-oriented-ified code by somebody else which I have no time or patience to parse. To download the source code, go to: http://boinc.berkeley.edu/trac/wiki/SoftwareDevelopment And follow the directions about how to get the BOINC source code. The php stuff (which is general and used by most BOINC projects, including us) is in html subdirectory (look in user, inc, and project). Find the bug? Send me a private message. Thanks! - Matt -- BOINC/SETI@home network/web/science/development person -- "Any idiot can have a good idea. What is hard is to do it." - Jeanne-Claude |
©2024 University of California
SETI@home and Astropulse are funded by grants from the National Science Foundation, NASA, and donations from SETI@home volunteers. AstroPulse is funded in part by the NSF through grant AST-0307956.