[gold-users] Newbie question: GUI and list of jobs
Tolis Sisiaridis
tolis.sisiaridis at oerc.ox.ac.uk
Wed Nov 7 07:13:03 MST 2007
Tim Robinson wrote:
> Hi Tolis
> What do the logs say? You should see the SQL query that is being
> performed...
>
> Tim
>
> On Wed, 2007-11-07 at 11:54 +0000, Tolis Sisiaridis wrote:
>
>> Just installed GOLD 2.4.1.2 and i am testing integration with PBS PRO.
>> Have tried both SQLITE and POSTGRESQL and so far i am very pleased with the results. A small problem though: The GUI would not list jobs no matter what i use for 'Prefilter' options. Everything else on the GUI
>> seems to be working well and 'glsjob' lists jobs normally.
>> Anyone else with the same issue?
>>
>> Tolis
>>
>>
>>
>>
>>
>> _______________________________________________
>> gold-users mailing list
>> gold-users at supercluster.org
>> http://www.supercluster.org/mailman/listinfo/gold-users
>>
When i run a query for all jobs (- infinity, infinity) the daemon log
($GOLD_HOME/log/goldd.log) shows:
2007-11-07 13:55:53.761 INFO main:: New Connection Received
2007-11-07 13:55:53.763 TRACE Gold::Message::new invoked with
arguments: (connection => IO::Socket::INET=GLOB(0x60000000017f5b30))
2007-11-07 13:55:53.764 TRACE Gold::Message::receiveChunk invoked with
arguments: ()
2007-11-07 13:55:53.765 DEBUG Gold::Message::receiveChunk Read message
header (POST /SSSRMAP3 HTTP/1.1
Content-Type: text/xml; charset="utf-8"
Transfer-Encoding: chunked
).
2007-11-07 13:55:53.765 INFO Gold::Message::receiveChunk Read message
payload (462, <?xml version="1.0" encoding="UTF-8"?>
<Envelope><Body><Request action="Query"
actor="gold"><Object>Job</Object><Where name="StartTime"
op="GE">0</Where><Where name="EndTime" op="LT">2147483647</Where><Option
name="Limit">1000</Option></Request></Body><Signature><DigestValue>73tVCxqOqMyFVY0hvtFTp25FwBs=</DigestValue><SignatureValue>zTZ4b/zxkAgM1rtHRUznUEkB+0Y=</SignatureValue><SecurityToken
type="Password" name="gold"></SecurityToken></Signature></Envelope>
).
2007-11-07 13:55:53.766 TRACE Gold::Message::unmarshallChunk invoked
with arguments: (<?xml version="1.0" encoding="UTF-8"?>
<Envelope><Body><Request action="Query"
actor="gold"><Object>Job</Object><Where name="StartTime"
op="GE">0</Where><Where name="EndTime" op="LT">2147483647</Where><Option
name="Limit">1000</Option></Request></Body><Signature><DigestValue>73tVCxqOqMyFVY0hvtFTp25FwBs=</DigestValue><SignatureValue>zTZ4b/zxkAgM1rtHRUznUEkB+0Y=</SignatureValue><SecurityToken
type="Password" name="gold"></SecurityToken></Signature></Envelope>
)
2007-11-07 13:55:53.768 TRACE Gold::Chunk::authenticate invoked with
arguments: (XML::LibXML::Document=SCALAR(0x600000000051f6a0))
2007-11-07 13:55:53.769 TRACE Gold::Cache::getPasswordProperty invoked
with arguments: (gold, Password)
2007-11-07 13:55:53.774 DEBUG Gold::Chunk::authenticate The security
token type is (Password).
2007-11-07 13:55:53.775 DEBUG Gold::Chunk::authenticate The
canonicalized body text is (<Body><Request action="Query"
actor="gold"><Object>Job</Object><Where name="StartTime"
op="GE">0</Where><Where name="EndTime" op="LT">2147483647</Where><Option
name="Limit">1000</Option></Request></Body>).
2007-11-07 13:55:53.775 DEBUG Gold::Chunk::authenticate The
base64-encoded message digest is (73tVCxqOqMyFVY0hvtFTp25FwBs=).
2007-11-07 13:55:53.776 DEBUG Gold::Chunk::authenticate The
base64-encoded MAC is (zTZ4b/zxkAgM1rtHRUznUEkB+0Y=).
2007-11-07 13:55:53.787 TRACE Gold::Request::new invoked with arguments: ()
2007-11-07 13:55:53.789 DEBUG Gold::Message::unmarshallChunk Extracted
the request ((Query, gold, [(Job, , )], [], [], [(StartTime, 0, GE, , ,
, ), (EndTime, 2147483647, LT, , , , )], [(Limit, 1000, )], [], 0, 0,
100000, )).
2007-11-07 13:55:53.790 DEBUG Gold::Message::receiveChunk Read message
tail (0).
2007-11-07 13:55:53.790 TRACE Gold::Proxy::new invoked with arguments:
(request => Gold::Request=HASH(0x6000000000a14280))
2007-11-07 13:55:53.791 TRACE Gold::Database::new invoked with
arguments: ()
2007-11-07 13:55:53.804 TRACE Gold::Database::nextId invoked with
arguments: (Request)
2007-11-07 13:55:53.808 TRACE Gold::Database::nextId generated new id
891 for Request
2007-11-07 13:55:53.809 TRACE Gold::Proxy::prepare invoked with
arguments: (Gold::Request=HASH(0x6000000000a14280))
2007-11-07 13:55:53.833 TRACE Gold::Cache::objectExists invoked with
arguments: (Job)
2007-11-07 13:55:53.834 TRACE Gold::Cache::actionExists invoked with
arguments: (Job, Query)
2007-11-07 13:55:53.835 TRACE Gold::Proxy::authorize invoked with
arguments: (Gold::Request=HASH(0x6000000000a14280))
2007-11-07 13:55:53.836 TRACE Gold::Cache::listUserRoles invoked with
arguments: (gold)
2007-11-07 13:55:53.837 TRACE Gold::Cache::listUserRoles invoked with
arguments: (ANY)
2007-11-07 13:55:53.838 TRACE Gold::Cache::getObjectProperty invoked
with arguments: (Job, Association)
2007-11-07 13:55:53.839 TRACE Gold::Cache::listRoleActionInstances
invoked with arguments: (SystemAdmin, Job, Query, ANY)
2007-11-07 13:55:53.839 TRACE Gold::Proxy::prepareOptions invoked with
arguments: (Gold::Request=HASH(0x6000000000a14280))
2007-11-07 13:55:53.840 DEBUG Gold::Proxy::prepareOptions Adding cooked
option: (Limit, 1000, )
2007-11-07 13:55:53.840 TRACE Gold::Proxy::prepareSelections invoked
with arguments: (Gold::Request=HASH(0x6000000000a14280))
2007-11-07 13:55:53.841 TRACE Gold::Database::select invoked with
arguments: (object => Attribute, options => ARRAY(0x6000000001ac1d80),
selections => ARRAY(0x6000000001ac1b00), chunkNum => 0, conditions =>
ARRAY(0x600000000116fb00))
2007-11-07 13:55:53.841 TRACE Gold::Database::buildWhere invoked with
arguments: (objects => ARRAY(0x6000000000847b70), conditions =>
ARRAY(0x6000000000847cd0))
2007-11-07 13:55:53.842 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-07 13:55:53.845 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-07 13:55:53.846 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Id)
2007-11-07 13:55:53.846 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (JobId)
2007-11-07 13:55:53.846 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (User)
2007-11-07 13:55:53.847 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Project)
2007-11-07 13:55:53.847 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Machine)
2007-11-07 13:55:53.848 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Charge)
2007-11-07 13:55:53.848 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Queue)
2007-11-07 13:55:53.848 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Type)
2007-11-07 13:55:53.849 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Stage)
2007-11-07 13:55:53.849 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (QualityOfService)
2007-11-07 13:55:53.850 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Nodes)
2007-11-07 13:55:53.850 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Processors)
2007-11-07 13:55:53.850 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Executable)
2007-11-07 13:55:53.851 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Application)
2007-11-07 13:55:53.851 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (StartTime)
2007-11-07 13:55:53.851 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (EndTime)
2007-11-07 13:55:53.852 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (WallDuration)
2007-11-07 13:55:53.852 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (QuoteId)
2007-11-07 13:55:53.853 DEBUG Gold::Proxy::prepareSelections Adding
cooked selection: (Description)
2007-11-07 13:55:53.853 TRACE Gold::Proxy::prepareAssignments invoked
with arguments: (Gold::Request=HASH(0x6000000000a14280))
2007-11-07 13:55:53.853 TRACE Gold::Cache::listAttributes invoked with
arguments: (Job)
2007-11-07 13:55:53.855 TRACE Gold::Proxy::prepareConditions invoked
with arguments: (Gold::Request=HASH(0x6000000000a14280))
2007-11-07 13:55:53.855 TRACE Gold::Cache::attributeExists invoked with
arguments: (Job, StartTime)
2007-11-07 13:55:53.856 TRACE Gold::Cache::getAttributeProperty invoked
with arguments: (Job, StartTime, DataType)
2007-11-07 13:55:53.858 DEBUG Gold::Proxy::prepareConditions Adding
cooked condition: (StartTime, 0, GE, , 0, , )
2007-11-07 13:55:53.859 TRACE Gold::Cache::attributeExists invoked with
arguments: (Job, EndTime)
2007-11-07 13:55:53.860 TRACE Gold::Cache::getAttributeProperty invoked
with arguments: (Job, EndTime, DataType)
2007-11-07 13:55:53.861 DEBUG Gold::Proxy::prepareConditions Adding
cooked condition: (EndTime, 2147483647, LT, , 0, , )
2007-11-07 13:55:53.862 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, , , )], [], [(StartTime, 0, GE, , , , ), (EndTime,
2147483647, LT, , , , )], [(Limit, 1000, )], [], 0, 0, 100000,
Gold::Database=HASH(0x60000000018006e0))
2007-11-07 13:55:53.863 TRACE Gold::Proxy::execute invoked with
arguments: ()
2007-11-07 13:55:53.863 TRACE Gold::Bank::execute invoked with
arguments: (Gold::Proxy=HASH(0x6000000001800800))
2007-11-07 13:55:53.864 DEBUG Gold::Bank::query invoked with arguments:
(Gold::Request=HASH(0x6000000000a14280), 891)
2007-11-07 13:55:53.864 DEBUG Gold::Base::query invoked with arguments:
(Gold::Request=HASH(0x6000000000a14280))
2007-11-07 13:55:53.865 TRACE Gold::Database::select invoked with
arguments: (chunkSize => 100000, options => ARRAY(0x60000000010d9480),
selections => ARRAY(0x60000000010d93e0), objects =>
ARRAY(0x60000000010d92a0), chunkNum => 1, conditions =>
ARRAY(0x60000000010d9430))
2007-11-07 13:55:53.888 TRACE Gold::Database::buildWhere invoked with
arguments: (objects => ARRAY(0x6000000000847b70), conditions =>
ARRAY(0x6000000000847cd0))
2007-11-07 13:55:53.888 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_start_time>='0' AND g_end_time<'2147483647' ) AND
g_deleted!='True' LIMIT 1000
2007-11-07 13:55:53.891 DEBUG Gold::Database::select SQL Results:
2007-11-07 13:55:53.896 TRACE Gold::Response::new invoked with
arguments: ()
2007-11-07 13:55:53.896 TRACE Gold::Response::success invoked with
arguments: (0, ARRAY(0x60000000010d9540))
2007-11-07 13:55:53.907 TRACE Gold::Reply::new invoked with arguments:
(connection => IO::Socket::INET=GLOB(0x60000000017f5b30))
2007-11-07 13:55:53.908 TRACE Gold::Reply::sendChunk invoked with
arguments: (Gold::Chunk=HASH(0x6000000001ab9910))
2007-11-07 13:55:53.908 TRACE Gold::Reply::marshallChunk invoked with
arguments: (Gold::Chunk=HASH(0x6000000001ab9910))
2007-11-07 13:55:53.909 DEBUG Gold::Reply::sendChunk Writing reply
header (HTTP/1.1 200 OK
Content-Type: text/xml; charset="utf-8"
Transfer-Encoding: chunked
).
2007-11-07 13:55:53.910 INFO Gold::Reply::sendChunk Writing reply
payload (179, <?xml version="1.0" encoding="UTF-8"?>
<Envelope><Body><Response
actor="gold"><Status><Value>Success</Value><Code>000</Code></Status><Count>0</Count></Response></Body></Envelope>
).
I will try to run the query on the database and see if anything comes out.
More information about the gold-users
mailing list