Closed: Find Broken Query


log in

Advanced search

Message boards : Help Wanted : Closed: Find Broken Query

Author Message
Profile Matt Lebofsky
Volunteer moderator
Project administrator
Project developer
Project scientist
Avatar
Send message
Joined: 1 Mar 99
Posts: 1384
Credit: 74,079
RAC: 0
United States
Message 715416 - Posted: 20 Feb 2008, 0:03:37 UTC
Last modified: 4 Mar 2008, 22:57:44 UTC

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

Message boards : Help Wanted : Closed: Find Broken Query

Copyright © 2014 University of California