id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 6512,ticket.query fails to return all matches,anonymous,osimons,"Notice in the trace below (password obfuscated), an XMLRPC client call to ticket.query for all tickets of status ""new"" returns an array which does '''not''' contain ticket #1. When fetched directly, however, ticket 1 is returned... and it's status is, indeed, new. {{{ irb(main):062:0> client = XMLRPC::Client.new2(""http://FOO:BAR@trac.germane-software.com/TimeTracker/login/xmlrpc"") => #> irb(main):063:0> client.call(""ticket.query"", ""status=new"").sort => [6, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108] irb(main):064:0> client.call(""ticket.get"", ""1"") => [""1"", #, #, {""component""=>""TimeTracker Android"", ""cc""=>""cupra.kev@googlemail.com"", ""reporter""=>""www.google.com/accounts/o8/id?id=aitoawkx8pndhvjyausyrhg8m8md8txy_7sju_w"", ""priority""=>""minor"", ""os""=>""Linux"", ""type""=>""enhancement"", ""version""=>"""", ""milestone""=>""2009.3"", ""summary""=>""Back up DB to memory card"", ""description""=>""Copy the whole DB to the memory card. Optionally pack the on-phone DB, moving old times to the DB on the memory card."", ""status""=>""new"", ""owner""=>""somebody"", ""keywords""=>""""}] }}} To eliminate the possibility that the error is in the Ruby XMLRPC library, I've also tried it with the JSONRPC interface: {{{ bean:1121)~% cat body.json {""params"": [""status=new""], ""method"": ""ticket.query"", ""id"": 123} bean:1122)~% curl -H ""Content-Type: application/json"" --data @body.json -u 'FOO:BAR' 'http://trac.germane-software.com/TimeTracker/login/jsonrpc' {""id"": 123, ""result"": [9, 6, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108], ""error"": null} }}} Again, notice that ticket is missing. Actually, there are about 41 tickets missing, as per a count on the server: {{{ haselmaus db # sqlite3 trac.db ""select count(*) from ticket where status='new'"" 141 }}}",defect,closed,normal,XmlRpcPlugin,major,fixed,documentation,seanerussell@…,0.11