[gold-users] error running gold-2.2.0.1

Scott Jackson scottmo at adaptivecomputing.com
Tue Nov 30 18:05:43 MST 2010


Ingmar,

Thanks. I can see where a part of the problem is: the Cache XML should look like:

<Object Name="User" Association="False"

but it looks like:

<Object G_NAME="User" G_ASSOCIATION="False"

This appears to be happening because the $database->select(object => "Object") which reads the names from $object->setAttribute($objectResults->{names}->[$i], $property) is not getting the names set correctly.

It uses $results{names} = [map { toUCC($_) } @{$sth->{NAME}}] to attempt to map names like g_name to Name. I think the problem is that in most other SQL databases, the attribute names are returned in lower case as they were created, but Oracle is returning these attribute names in uppercase which results in a bad translation from toUCC.

Ahh, I googled it and here is what I found:

NOTE the NAME attribute can return lowercase or uppercase column names depending on the database. Some database will always uppercase column names in create statements if they are unquoted and some databases retain the case of column names if they are enclosed in the identifier quote character. TIP: For this reason it is best to use NAME_uc or NAME_lc.

So based on this, please make the following change to your ${GOLD_HOME}/lib/Gold/Database.pm file:

scottmo at mana:/software/gold-2.2$ svn diff
Index: lib/Gold/Database.pm
===================================================================
--- lib/Gold/Database.pm	(revision 261)
+++ lib/Gold/Database.pm	(working copy)
@@ -674,7 +674,7 @@
 
     my %results = ();
     $results{cols}  = $sth->{NUM_OF_FIELDS};
-    $results{names} = [map { toUCC($_) } @{$sth->{NAME}}];
+    $results{names} = [map { toUCC($_) } @{$sth->{NAME_lc}}];
     $results{data}  = $sth->fetchall_arrayref();
     $results{rows}  = @{$results{data}};
 
then, restart goldd and let me know if things have improved.

I will make this change in the latest gold distributions.

Thanks,

Scott


----- Original Message -----
> From: "ingmar" <ingmar at ucar.edu>
> To: "Gold Users Mailing List" <gold-users at supercluster.org>, "Scott Jackson" <scottmo at adaptivecomputing.com>
> Sent: Tuesday, November 30, 2010 1:18:09 PM
> Subject: Re: [gold-users] error running gold-2.2.0.1
> Some answers...
> Thanks,
> -ingmar
> 
> On 11/23/2010 06:54 PM, Scott Jackson wrote:
> > It could be. I haven't tested with Oracle for a very long time. I'm
> > sure if we dig into this that we can make it work, though.
> >
> > Do you get the same response from glsuser?
> ingmar at cisl-mandurah:/usr/local/gold/bin$ ./glsuser
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> User is not a valid object
> ingmar at cisl-mandurah:/usr/local/gold/bin$ ./gbalance
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Account is not a valid object
> ingmar at cisl-mandurah:/usr/local/gold/bin$ ./gchaccount
> Usage:
> gchaccount [-n *account_name*] [-d *description*] [--addProjects
> *project_name*[,*project_name*]*] [--addUsers
> *user_name*[,*user_name*]*] [--addMachines
> *machine_name*[,*machine_name*]*] [--delProjects
> *project_name*[,*project_name*]*] [--delUsers
> *user_name*[,*user_name*]*] [--delMachines
> *machine_name*[,*machine_name*]*] [-X | --extension
> *property*=*value*]*
> [--debug] [-?, --help] [--man] [--quiet] [-v, --verbose] [-V,
> --version]
> {[-a] *account_id* | { -p *project_name* &| -u *user_name* &| -m
> *machine_name*}}
> 
> ingmar at cisl-mandurah:/usr/local/gold/bin$ ./glsres
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Reservation is not a valid object
> ingmar at cisl-mandurah:/usr/local/gold/bin$ ./glsjob
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Job is not a valid object
> ingmar at cisl-mandurah:/usr/local/gold/bin$ ./glsmachine
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Use of uninitialized value in string eq at
> /usr/local/gold/lib/Gold/Cache.pm line 519.
> Machine is not a valid object
> 
> > Perhaps the bootstrap step was not run or failed somehow to create
> > the User object?
> >
> > Do any of the commands work?
> >
> > When you examine the database, "SELECT * FROM g_object", do you see
> > the User object defined?
> Please see the included image file.
> > What does the Cache DOM look like when goldd is started up?
> Please see the included goldd.log when Gold is started.
> > Thanks,
> >
> > Scott
> >
> >


More information about the gold-users mailing list