[gold-users] gui problem with more than 1000 hits
Tim Robinson
twrobinson at manchester.ac.uk
Wed Nov 28 05:36:31 MST 2007
Hi Scott
I've upgraded, but unfortunately it still doesn't seem to work.. for the
second page it ignores the selection criteria and just prints the jobs
with id from 1001-2000.
Example, if I ask to list jobs with user = tim the first 1000 is
correct, but the next thousand is simply jobs 1001-2000, no matter what
the user.
Here is the log .. as you can see it doesn't know anything about
User=Tim
----
2007-11-28 12:31:23.584 INFO Gold::Message::receiveChunk Read message
payload (408, <?xml version="1.0" encoding="UTF-8"?>
<Envelope><Body><Request action="Query"
actor="gold"><Object>Job</Object><Option
name="Limit">1000</Option><Option
name="Offset">1000</Option></Request></Body><Signature><DigestValue>Jgi7I2VqsIprUsDbjqyftMLfCuM=</DigestValue><SignatureValue>Hp2rijITJRJHVGJC35Y+PffTQAU=</SignatureValue><SecurityToken type="Password" name="gold"></SecurityToken></Signature></Envelope>
).
2007-11-28 12:31:23.585 TRACE Gold::Message::unmarshallChunk invoked
with arguments: (<?xml version="1.0" encoding="UTF-8"?>
<Envelope><Body><Request action="Query"
actor="gold"><Object>Job</Object><Option
name="Limit">1000</Option><Option
name="Offset">1000</Option></Request></Body><Signature><DigestValue>Jgi7I2VqsIprUsDbjqyftMLfCuM=</DigestValue><SignatureValue>Hp2rijITJRJHVGJC35Y+PffTQAU=</SignatureValue><SecurityToken type="Password" name="gold"></SecurityToken></Signature></Envelope>
)
2007-11-28 12:31:23.586 TRACE Gold::Chunk::authenticate invoked with
arguments: (XML::LibXML::Document=SCALAR(0x8f12904))
2007-11-28 12:31:23.587 TRACE Gold::Cache::getPasswordProperty invoked
with arguments: (gold, Password)
2007-11-28 12:31:23.591 DEBUG Gold::Chunk::authenticate The security
token type is (Password).
2007-11-28 12:31:23.592 DEBUG Gold::Chunk::authenticate The
canonicalized body text is (<Body><Request action="Query"
actor="gold"><Object>Job</Object><Option
name="Limit">1000</Option><Option
name="Offset">1000</Option></Request></Body>).
2007-11-28 12:31:23.592 DEBUG Gold::Chunk::authenticate The
base64-encoded message digest is (Jgi7I2VqsIprUsDbjqyftMLfCuM=).
2007-11-28 12:31:23.593 DEBUG Gold::Chunk::authenticate The
base64-encoded MAC is (Hp2rijITJRJHVGJC35Y+PffTQAU=).
2007-11-28 12:31:23.594 TRACE Gold::Request::new invoked with
arguments: ()
2007-11-28 12:31:23.595 DEBUG Gold::Message::unmarshallChunk Extracted
the request ((Query, gold, [(Job, , )], [], [], [], [(Limit, 1000, ),
(Offset, 1000, )], [], 0, 0, 100000, )).
2007-11-28 12:31:23.596 DEBUG Gold::Message::receiveChunk Read message
tail (0).
2007-11-28 12:31:23.596 TRACE Gold::Proxy::new invoked with arguments:
(request => Gold::Request=HASH(0x8749970))
2007-11-28 12:31:23.597 TRACE Gold::Database::new invoked with
arguments: ()
2007-11-28 12:31:23.598 TRACE Gold::Database::nextId invoked with
arguments: (Request)
2007-11-28 12:31:23.600 TRACE Gold::Database::nextId generated new id
2391 for Request
2007-11-28 12:31:23.600 TRACE Gold::Proxy::prepare invoked with
arguments: (Gold::Request=HASH(0x8749970))
2007-11-28 12:31:23.617 TRACE Gold::Cache::objectExists invoked with
arguments: (Job)
2007-11-28 12:31:23.618 TRACE Gold::Cache::actionExists invoked with
arguments: (Job, Query)
2007-11-28 12:31:23.620 TRACE Gold::Proxy::authorize invoked with
arguments: (Gold::Request=HASH(0x8749970))
2007-11-28 12:31:23.620 TRACE Gold::Cache::listUserRoles invoked with
arguments: (gold)
2007-11-28 12:31:23.621 TRACE Gold::Cache::listUserRoles invoked with
arguments: (ANY)
2007-11-28 12:31:23.622 TRACE Gold::Cache::getObjectProperty invoked
with arguments: (Job, Association)
2007-11-28 12:31:23.623 TRACE Gold::Cache::listRoleActionInstances
invoked with arguments: (SystemAdmin, Job, Query, ANY)
2007-11-28 12:31:23.624 TRACE Gold::Proxy::prepareOptions invoked with
arguments: (Gold::Request=HASH(0x8749970))
2007-11-28 12:31:23.624 DEBUG Gold::Proxy::prepareOptions Adding cooked
option: (Limit, 1000, )
2007-11-28 12:31:23.625 DEBUG Gold::Proxy::prepareOptions Adding cooked
option: (Offset, 1000, )
2007-11-28 12:31:23.625 TRACE Gold::Proxy::prepareSelections invoked
with arguments: (Gold::Request=HASH(0x8749970))
2007-11-28 12:31:23.626 TRACE Gold::Database::select invoked with
arguments: (object => Attribute, options => ARRAY(0x86a4e90), selections
=> ARRAY(0x8f3fb7c), chunkNum => 0, conditions => ARRAY(0x8b85000))
2007-11-28 12:31:23.626 TRACE Gold::Database::buildWhere invoked with
arguments: (objects => ARRAY(0x8632d54), conditions => ARRAY(0x8632e68))
2007-11-28 12:31:23.627 DEBUG Gold::Database::select SQL Query: SELECT
g_name FROM g_attribute WHERE ( g_object='Job' AND g_hidden!='True' )
AND g_deleted!='True' ORDER BY g_sequence
2007-11-28 12:31:24.254 DEBUG Gold::Database::select SQL Results: Id
JobId
User
Project
Machine
Charge
Queue
Type
Stage
QualityOfService
Nodes
Processors
Executable
Application
StartTime
EndTime
WallDuration
QuoteId
Description
2007-11-28 12:31:24.254 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Id)
2007-11-28 12:31:24.255 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (JobId)
2007-11-28 12:31:24.255 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (User)
2007-11-28 12:31:24.256 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Project)
2007-11-28 12:31:24.256 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Machine)
2007-11-28 12:31:24.256 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Charge)
2007-11-28 12:31:24.257 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Queue)
2007-11-28 12:31:24.257 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Type)
2007-11-28 12:31:24.257 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Stage)
2007-11-28 12:31:24.258 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (QualityOfService)
2007-11-28 12:31:24.258 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Nodes)
2007-11-28 12:31:24.258 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Processors)
2007-11-28 12:31:24.259 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Executable)
2007-11-28 12:31:24.259 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Application)
2007-11-28 12:31:24.259 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (StartTime)
2007-11-28 12:31:24.260 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (EndTime)
2007-11-28 12:31:24.260 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (WallDuration)
2007-11-28 12:31:24.261 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (QuoteId)
2007-11-28 12:31:24.261 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Description)
2007-11-28 12:31:24.261 TRACE Gold::Proxy::prepareAssignments invoked
with arguments: (Gold::Request=HASH(0x8749970))
2007-11-28 12:31:24.262 TRACE Gold::Cache::listAttributes invoked with
arguments: (Job)
2007-11-28 12:31:24.263 TRACE Gold::Proxy::prepareConditions invoked
with arguments: (Gold::Request=HASH(0x8749970))
2007-11-28 12:31:24.264 DEBUG Gold::Proxy::prepare Cooked request:
(Query, gold, [(Job, , )], [(Id, , , ), (JobId, , , ), (User, , , ),
(Project, , , ), (Machine, , , ), (Charge, , , ), (Queue, , , ),
(Type, , , ), (Stage, , , ), (QualityOfService, , , ), (Nodes, , , ),
(Processors, , , ), (Executable, , , ), (Application, , , ),
(StartTime, , , ), (EndTime, , , ), (WallDuration, , , ),
(QuoteId, , , ), (Description, , , )], [], [], [(Limit, 1000, ),
(Offset, 1000, )], [], 0, 0, 100000, Gold::Database=HASH(0x8f36eb0))
2007-11-28 12:31:24.264 TRACE Gold::Proxy::execute invoked with
arguments: ()
2007-11-28 12:31:24.265 TRACE Gold::Bank::execute invoked with
arguments: (Gold::Proxy=HASH(0x8f12034))
2007-11-28 12:31:24.265 DEBUG Gold::Bank::query invoked with arguments:
(Gold::Request=HASH(0x8749970), 2391)
2007-11-28 12:31:24.266 DEBUG Gold::Base::query invoked with arguments:
(Gold::Request=HASH(0x8749970))
2007-11-28 12:31:24.266 TRACE Gold::Database::select invoked with
arguments: (chunkSize => 100000, options => ARRAY(0x8b2d224), selections
=> ARRAY(0x8b2d1ac), objects => ARRAY(0x8b2d0bc), chunkNum => 1,
conditions => ARRAY(0x8b2d1e8))
2007-11-28 12:31:24.288 TRACE Gold::Database::buildWhere invoked with
arguments: (objects => ARRAY(0x8632d54), conditions => ARRAY(0x8632e68))
2007-11-28 12:31:24.289 DEBUG Gold::Database::select SQL Query: SELECT
g_id,g_job_id,g_user,g_project,g_machine,g_charge,g_queue,g_type,g_stage,g_quality_of_service,g_nodes,g_processors,g_executable,g_application,g_start_time,g_end_time,g_wall_duration,g_quote_id,g_description FROM g_job WHERE g_deleted!='True' LIMIT 1000 OFFSET 1000
2007-11-28 12:31:24.313 DEBUG Gold::Database::select SQL Results: 1001|
998|gold|z1|machine1|10|||Charge|||1|||||10||
1002|999|gold|z1|machine1|10|||Charge|||1|||||10||
1003|1000|gold|z1|machine1|10|||Charge|||1|||||10||
1004|1001|gold|z1|machine1|10|||Charge|||1|||||10||
1005|1002|gold|z1|machine1|10|||Charge|||1|||||10||
1006|1003|tim|z1|machine1|10|||Charge|||1|||||10||
and so on
More information about the gold-users
mailing list