Re: [Ground-user] ./databaseInterface start problem ?

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hi Calum,

psql (PostgreSQL) 8.1.23 Installed via YUM ... Just checking again...

yum install postgresql postgresql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: archive.cs.uu.nl
 * extras: archive.cs.uu.nl
 * updates: centos.mirror.transip.nl
Setting up Install Process
Package postgresql-8.1.23-1.el5_6.1.i386 already installed and latest
version
Package postgresql-server-8.1.23-1.el5_6.1.i386 already installed and latest
version
Nothing to do

CREATE DATABASE ground_stats  ENCODING 'UTF8'; > database command
interpreter.

createlang plpgsql ground_stats > via unix command console.

CentOS release 5.6 (Final)
uname -a  -> Linux localhost.localdomain 2.6.18-238.9.1.el5 #1 SMP Tue Apr
12 18:10:56 EDT 2011 i686 i686 i386 GNU/Linux

Gerry

On Tue, Sep 20, 2011 at 9:22 PM, Calum Fitzgerald <
cal...@gm...> wrote:

> Hi Gerry,
>
> Looks like an interesting problem....and not one that I have come
> across before unfortunately.
>
> Please can you let me know which version of Postgres you are running
> against?
> is the PL/PGSQL language installed?
> Also which OS are you using?
>
> Cheers
> Cal
>
> On 19 September 2011 15:49, Gerry Brennan <ger...@gm...> wrote:
> > Hi Calum,
> >
> > I got past this issue. Thank you very much for your response.
> >
> > I am currently on another one around the database. (in my opinion)
> >
> >
> > When I run in to Databaseinterface.bash and press 1 to install database i
> > get the following.
> >
> > I have manipulated some code in the file  databaseFactory.py file  to
> > highlight the problems ONLY...
> >
> > When i identify them i can revert back to the original.
> >
> > DATABASE CONTROL MENU
> >
> > -----------------------
> >
> >
> >
> >  Select action to perform:
> >
> >
> >
> >   1 ) install Database
> >
> >   2 ) delete Database
> >
> >   3 ) reset Database
> >
> >   4 ) upload Files
> >
> >   5 ) refresh Materialised Views
> >
> >   6 ) drop Data
> >
> >
> >
> >  Experimental
> >
> >  ------------
> >
> >   7 ) cluster Database
> >
> >   8 ) refresh Extended Stats Materialised Views
> >
> >
> >
> >  Information
> >
> >  ------------
> >
> >   9 ) show loadrun information
> >
> >   10) show data file information
> >
> >
> >
> >  Type 'exit' to escape the menu
> >
> >
> >
> >  Enter action: 1
> >
> >
> >
> >  Create Database Selected
> >
> >
> >
> > Traceback (innermost last):
> >
> >   File "~/ground_report-1.5/lib/databaseInterface.py", line 455, in ?
> >
> >   File "~/ground_report-1.5/lib/databaseInterface.py", line 197, in
> > startDBMenu
> >
> >   File "~/ground_report-1.5/lib/databaseFactory.py", line 35, in createDB
> >
> > Error: ERROR: syntax error at or near "(" [SQLCode: 0], [SQLState: 42601]
> >
> >
> >
> > Then when I look at the line of code in lib/databaseFactory.py
> >
> >
> >
> >
> >
> >   c.execute('''CREATE TABLE "raw_data_http"
> >
> >   17             (
> >
> >   18              "RAW_ID" integer NOT NULL DEFAULT
> > nextval(('public."raw_http_seq"'::text)::regclass),
> >
> >   19              "Load Run" integer NOT NULL,
> >
> >   20              "Data File" integer NOT NULL,
> >
> >   21              "Thread" integer NOT NULL,
> >
> >   22              "Run" integer NOT NULL,
> >
> >   23              "Test" bigint NOT NULL,
> >
> >   24              "Milliseconds Since Epoch" bigint NOT NULL,
> >
> >   25              "Test Time" integer NOT NULL,
> >
> >   26              "Errors" integer NOT NULL,
> >
> >   27              "HTTP Response Code" integer NOT NULL,
> >
> >   28              "HTTP Response Length" integer NOT NULL,
> >
> >   29              "HTTP Response Errors" integer NOT NULL,
> >
> >   30              "Time To Resolve Host" integer NOT NULL,
> >
> >   31              "Time To Establish Connection" integer NOT NULL,
> >
> >   32              "Time To First Byte" integer NOT NULL,
> >
> >   33              CONSTRAINT raw_http_pkey PRIMARY KEY ("RAW_ID")
> >
> >   34             )
> >
> >   35             WITH (OIDS=FALSE); ''')
> >
> >
> >
> > In the database log file I get
> >
> >
> >
> > ERROR:  syntax error at or near "(" at character 904
> >
> > LOG:  unexpected EOF on client connection
> >
> >
> >
> >
> >
> > When I remove the component
> >
> >
> >
> > WITH (OIDS=FALSE);
> >
> >
> >
> > It moves on to the next problem statement.
> >
> >
> >
> > WITH (OIDS=FALSE);
> >
> >
> >
> > So I remove them all of them across Across all the file.
> >
> >
> >
> > Finally I get to  an PL/PgSQL problem.
> >
> >
> >
> > NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> > "raw_http_pkey" for table "raw_data_http"
> >
> > NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> > "upload_http_pkey" for table "http_upload_info"
> >
> > NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> > "datafile_http_pkey" for table "http_data_files"
> >
> > NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> > "descfile_http_pkey" for table "http_desc_files"
> >
> > NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> > "descriptions_http_pkey" for table "descriptions_http"
> >
> > ERROR:  syntax error at or near "$1" at character 46
> >
> > QUERY:  SELECT  sum("Started Threads") INTO  STRICT  $1  FROM
> > thread_start_buckets_http_mv WHERE "Load Run" =  $2  AND "Time Bucket" <=
> > $3
> >
> > CONTEXT:  SQL statement in PL/PgSQL function "concurrent_users_http" near
> > line 9
> >
> > Traceback (innermost last):
> >   File "/home/devweb/ground_report-1.5/lib/databaseInterface.py", line
> 455,
> > in ?
> >   File "/home/devweb/ground_report-1.5/lib/databaseInterface.py", line
> 197,
> > in startDBMenu
> >   File "/home/devweb/ground_report-1.5/lib/databaseFactory.py", line 180,
> in
> > createDB
> > Error: ERROR: syntax error at or near "$1" [SQLCode: 0], [SQLState:
> 42601]
> >
> > Your help is greatly appreciated.
> >
> > Gerry.
> >
> >
> > On Mon, Sep 19, 2011 at 12:53 PM, Calum Fitzgerald
> > <cal...@gm...> wrote:
> >>
> >> Hi Gerry,
> >>
> >> The issue is to do with the fact that the ground report cannot find
> >> the Jython installation:
> >>
> >> Some initial steps to try with respects to troubleshooting:
> >>
> >> 1. Have you installed Jython onto your machine?
> >> 2. Have you updated the configuration files with the location of your
> >> Jython installation?
> >>
> >>
> >> Cheers
> >> Cal
> >>
> >>
> >> On 16 September 2011 15:32, Gerry Brennan <ger...@gm...>
> wrote:
> >> >
> >> > Hi Group,
> >> >
> >> > I am trying to install ground report I have got as far as trying to
> run
> >> > databaseInterface
> >> >
> >> > ./databaseInterface.bash
> >> > Exception in thread "main" java.lang.NoClassDefFoundError:
> >> > org/python/util/jython
> >> > Caused by: java.lang.ClassNotFoundException: org.python.util.jython
> >> >         at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
> >> >         at java.security.AccessController.doPrivileged(Native Method)
> >> >         at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
> >> >         at java.lang.ClassLoader.loadClass(ClassLoader.java:319)
> >> >         at
> sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
> >> >         at java.lang.ClassLoader.loadClass(ClassLoader.java:264)
> >> >         at
> java.lang.ClassLoader.loadClassInternal(ClassLoader.java:332)
> >> > Could not find the main class: org.python.util.jython. Program will
> >> > exit.
> >> >
> >> >
> >> > Can anyone help
> >> >
> >> >
> >> >
> ------------------------------------------------------------------------------
> >> > BlackBerry&reg; DevCon Americas, Oct. 18-20, San Francisco, CA
> >> > http://p.sf.net/sfu/rim-devcon-copy2
> >> > _______________________________________________
> >> > Ground-user mailing list
> >> > Gro...@li...
> >> > https://lists.sourceforge.net/lists/listinfo/ground-user
> >> >
> >> >
> >
> >
> >
> >
> >
>

-- 
Gerry Brennan.
"Shalom"
Lipstown
Narraghmore
Co. Kildare
Ireland

Tel :  + 353 86 0200999.
Tel :  + 353 87 9783902.

Personal Mail: ger...@gm...