Re: [Ground-user] ./databaseInterface start problem ?
Status: Beta
Brought to you by:
calumfodder
Menu
▾
▴
Re: [Ground-user] ./databaseInterface start problem ?
|
From: Calum F. <cal...@gm...> - 2011-09-20 20:22:57
|
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® 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
>> >
>> >
>
>
>
>
>
|
