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

[Gerry B. <ger...@gm...>]

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
> >
> >
>