Re: [Grinder-use] Ground Report With Grinder
Distributed load testing framework - Java, Jython, or Clojure scripts.
Brought to you by:
philipa
Menu
▾
▴
Re: [Grinder-use] Ground Report With Grinder
|
From: Calum F. <cal...@gm...> - 2009-04-23 14:27:48
|
i sent the patch to the mailing list from a different account. it is
awaiting moderator approval to be posted to the list. other than that
if you have a non gmail account I can mail it direct...its not
huge...less that 1MB.
2009/4/23 smiles <tsm...@gm...>:
> Hey,
>
> Thanks for the patch !!!
>
> Appreciate it.
>
> Sure will try out and let you know..
>
> btw, where could i download the patch from?
>
> Thx
> Gayu
>
>
> On Thu, Apr 23, 2009 at 7:44 AM, Calum Fitzgerald
> <cal...@gm...> wrote:
>>
>> hiya,
>>
>> here is a patch for you.
>>
>> put the archive in you ground report home dir and extract.
>>
>> this should replace the contents of:
>>
>> bin
>> etc
>>
>> replace the .py files in:
>>
>> lib
>>
>> create a new directory structure under:
>>
>> var
>>
>> you will need to redo the config files in "etc"
>>
>> you will also need to blow away your old db tables and views b4
>> running the databaseInterface.bat to install the new db....I haven't
>> figured out a clean way of recreating the db between versions yet.
>>
>> I have attached a summaryReport created using your sample file.
>>
>> the bug was in one of the views (element_min_time_norm)....for some
>> reason I had copied the sql for max_time over the sql for
>> min_time...fixed now.
>>
>> Let us know if it works.
>>
>> Cheers
>> Cal
>>
>> patch will arrive by another route as gmail has refused to send .py files
>>
>> 2009/4/22 KG KG <tsm...@gm...>:
>> > I do see data on 'concurrent_users_byfile_norm_mv' but none in
>> > 'concurrent_users_byrun_norm_mv'
>> >
>> > On Wed, Apr 22, 2009 at 5:12 PM, Calum Fitzgerald
>> > <cal...@gm...> wrote:
>> >>
>> >> the materialised views haven't been populated yet, this is part of the
>> >> data upload and happens in a transaction block that will rool back if
>> >> there are any errors, this is probably why there is no data. Also the
>> >> current concurrent users logic has a bug in it that I've fixed in
>> >> version 1.2 (most probably just introduced new bugs :-))...
>> >>
>> >> you can look at the view of the same name to look at the data
>> >> uploaded...concurrent_users_byrun_norm...you can do this with any of
>> >> the views for the data already uploaded...they will just take some
>> >> time to display which depends on power of db server and the amount of
>> >> data loaded....i use materialised views for the reports so that the
>> >> processing hit is paid only once.
>> >>
>> >> 2009/4/22 KG KG <tsm...@gm...>:
>> >> > This is my yet another observation. For some reason, the application
>> >> > doesn't
>> >> > put any entries in
>> >> >
>> >> > 'concurrent_users_byrun_norm_mv' table.
>> >> >
>> >> > Any clues?
>> >> >
>> >> > On Wed, Apr 22, 2009 at 4:46 PM, KG KG <tsm...@gm...> wrote:
>> >> >>
>> >> >> One more point that may be useful:
>> >> >>
>> >> >> I got some images under /$GROUNDREPORT_HOME/output/images, which
>> >> >> have
>> >> >> their axes set, but no graphs, since the data is not available to
>> >> >> create the
>> >> >> reports due to error while uploading files.
>> >> >>
>> >> >> Any help is much appreciated.
>> >> >>
>> >> >> On Wed, Apr 22, 2009 at 4:33 PM, KG KG <tsm...@gm...> wrote:
>> >> >>>
>> >> >>> For Additional information i am using the data_office*.log files
>> >> >>> generated by the grinder output.
>> >> >>> I tried using both the log as well the csv formats.
>> >> >>>
>> >> >>> [converted the *.log to *.csv files since i understood that the
>> >> >>> data
>> >> >>> files needs to be of the format *.csv. Also the descr_norm.txt in
>> >> >>> the
>> >> >>> samples directory didnt run for me.]
>> >> >>>
>> >> >>> Have i missed anything in the configuration part?
>> >> >>>
>> >> >>>
>> >> >>>
>> >> >>> On Wed, Apr 22, 2009 at 4:20 PM, KG KG <tsm...@gm...> wrote:
>> >> >>>>
>> >> >>>> Thanks !! it recognized my file, however still facing problems.
>> >> >>>>
>> >> >>>> I created the database selecting option (1), then tried with
>> >> >>>> option(4).
>> >> >>>>
>> >> >>>> I get a whole trace like this and i am not able to see any
>> >> >>>> reports:
>> >> >>>>
>> >> >>>> Enter action: 4
>> >> >>>>
>> >> >>>> Upload Files Selected
>> >> >>>>
>> >> >>>> Uploading Data Files
>> >> >>>>
>> >> >>>> Number of Uploaded Files = 1
>> >> >>>>
>> >> >>>> Time Taken = 00 Hours 00 Minutes 00 Seconds
>> >> >>>>
>> >> >>>>
>> >> >>>> Refreshing Materialised Views:
>> >> >>>>
>> >> >>>> element_distribution_norm_mv
>> >> >>>> concurrent_users_byfile_norm_mv
>> >> >>>> element_summary_norm_mv
>> >> >>>> element_max_time_norm_mv
>> >> >>>> element_min_time_norm_mv
>> >> >>>> Exception in thread Thread-64:
>> >> >>>> Traceback (most recent call last):
>> >> >>>> File "C:\Softwares\mysoft\jython2.2.1\Lib\threading.py", line
>> >> >>>> 414,
>> >> >>>> in
>> >> >>>> _Thread__bootstrap
>> >> >>>> self.run()
>> >> >>>> File
>> >> >>>>
>> >> >>>> "C:\Softwares\mysoft\ground_report-1.1\lib\multithreadUtilities.py",
>> >> >>>> line
>> >> >>>> 62, in run
>> >> >>>> self.finishedQueue.put(eval(self.sqlScript)(self.dbConn,
>> >> >>>> self.sqlQueue.get_nowait() ))
>> >> >>>> File
>> >> >>>> "C:\Softwares\mysoft\ground_report-1.1\lib\databaseFactory.py",
>> >> >>>> line 813, in refreshMaterialisedView
>> >> >>>> c.execute('SELECT refresh_matview(\'' + mv + '\');')
>> >> >>>> Error: ERROR: count must be greater than zero [SQLCode: 0],
>> >> >>>> [SQLState:
>> >> >>>> 2201G]
>> >> >>>>
>> >> >>>> Exception in thread Thread-66:
>> >> >>>> Traceback (most recent call last):
>> >> >>>> File "C:\Softwares\mysoft\jython2.2.1\Lib\threading.py", line
>> >> >>>> 414,
>> >> >>>> in
>> >> >>>> _Thread__bootstrap
>> >> >>>> self.run()
>> >> >>>> File
>> >> >>>>
>> >> >>>> "C:\Softwares\mysoft\ground_report-1.1\lib\multithreadUtilities.py",
>> >> >>>> line
>> >> >>>> 62, in run
>> >> >>>> self.finishedQueue.put(eval(self.sqlScript)(self.dbConn,
>> >> >>>> self.sqlQueue.get_nowait() ))
>> >> >>>> File
>> >> >>>> "C:\Softwares\mysoft\ground_report-1.1\lib\databaseFactory.py",
>> >> >>>> line 813, in refreshMaterialisedView
>> >> >>>> c.execute('SELECT refresh_matview(\'' + mv + '\');')
>> >> >>>> Error: ERROR: current transaction is aborted, commands ignored
>> >> >>>> until
>> >> >>>> end
>> >> >>>> of transaction block [SQLCode: 0], [SQLState: 25P02]
>> >> >>>>
>> >> >>>> Exception in thread Thread-65:
>> >> >>>> Traceback (most recent call last):
>> >> >>>> File "C:\Softwares\mysoft\jython2.2.1\Lib\threading.py", line
>> >> >>>> 414,
>> >> >>>> in
>> >> >>>> _Thread__bootstrap
>> >> >>>> self.run()
>> >> >>>> File
>> >> >>>>
>> >> >>>> "C:\Softwares\mysoft\ground_report-1.1\lib\multithreadUtilities.py",
>> >> >>>> line
>> >> >>>> 62, in run
>> >> >>>> self.finishedQueue.put(eval(self.sqlScript)(self.dbConn,
>> >> >>>> self.sqlQueue.get_nowait() ))
>> >> >>>> File
>> >> >>>> "C:\Softwares\mysoft\ground_report-1.1\lib\databaseFactory.py",
>> >> >>>> line 813, in refreshMaterialisedView
>> >> >>>> c.execute('SELECT refresh_matview(\'' + mv + '\');')
>> >> >>>> Error: ERROR: current transaction is aborted, commands ignored
>> >> >>>> until
>> >> >>>> end
>> >> >>>> of transaction block [SQLCode: 0], [SQLState: 25P02]
>> >> >>>>
>> >> >>>> Exception in thread Thread-91:
>> >> >>>> Traceback (most recent call last):
>> >> >>>> File "C:\Softwares\mysoft\jython2.2.1\Lib\threading.py", line
>> >> >>>> 414,
>> >> >>>> in
>> >> >>>> _Thread__bootstrap
>> >> >>>> self.run()
>> >> >>>> File
>> >> >>>>
>> >> >>>> "C:\Softwares\mysoft\ground_report-1.1\lib\multithreadUtilities.py",
>> >> >>>> line
>> >> >>>> 62, in run
>> >> >>>> self.finishedQueue.put(eval(self.sqlScript)(self.dbConn,
>> >> >>>> self.sqlQueue.get_nowait() ))
>> >> >>>> File
>> >> >>>> "C:\Softwares\mysoft\ground_report-1.1\lib\databaseFactory.py",
>> >> >>>> line 813, in refreshMaterialisedView
>> >> >>>> c.execute('SELECT refresh_matview(\'' + mv + '\');')
>> >> >>>> Error: ERROR: current transaction is aborted, commands ignored
>> >> >>>> until
>> >> >>>> end
>> >> >>>> of transaction block [SQLCode: 0], [SQLState: 25P02]
>> >> >>>>
>> >> >>>> Exception in thread Thread-96:
>> >> >>>> Traceback (most recent call last):
>> >> >>>> File "C:\Softwares\mysoft\jython2.2.1\Lib\threading.py", line
>> >> >>>> 414,
>> >> >>>> in
>> >> >>>> _Thread__bootstrap
>> >> >>>> self.run()
>> >> >>>> File
>> >> >>>>
>> >> >>>> "C:\Softwares\mysoft\ground_report-1.1\lib\multithreadUtilities.py",
>> >> >>>> line
>> >> >>>> 62, in run
>> >> >>>> self.finishedQueue.put(eval(self.sqlScript)(self.dbConn,
>> >> >>>> self.sqlQueue.get_nowait() ))
>> >> >>>> File
>> >> >>>> "C:\Softwares\mysoft\ground_report-1.1\lib\databaseFactory.py",
>> >> >>>> line 813, in refreshMaterialisedView
>> >> >>>> c.execute('SELECT refresh_matview(\'' + mv + '\');')
>> >> >>>> Error: ERROR: current transaction is aborted, commands ignored
>> >> >>>> until
>> >> >>>> end
>> >> >>>> of transaction block [SQLCode: 0], [SQLState: 25P02]
>> >> >>>>
>> >> >>>> Exception in thread Thread-94:
>> >> >>>> Traceback (most recent call last):
>> >> >>>> File "C:\Softwares\mysoft\jython2.2.1\Lib\threading.py", line
>> >> >>>> 414,
>> >> >>>> in
>> >> >>>> _Thread__bootstrap
>> >> >>>> self.run()
>> >> >>>> File
>> >> >>>>
>> >> >>>> "C:\Softwares\mysoft\ground_report-1.1\lib\multithreadUtilities.py",
>> >> >>>> line
>> >> >>>> 62, in run
>> >> >>>> self.finishedQueue.put(eval(self.sqlScript)(self.dbConn,
>> >> >>>> self.sqlQueue.get_nowait() ))
>> >> >>>> File
>> >> >>>> "C:\Softwares\mysoft\ground_report-1.1\lib\databaseFactory.py",
>> >> >>>> line 813, in refreshMaterialisedView
>> >> >>>> c.execute('SELECT refresh_matview(\'' + mv + '\');')
>> >> >>>> Error: ERROR: current transaction is aborted, commands ignored
>> >> >>>> until
>> >> >>>> end
>> >> >>>> of transaction block [SQLCode: 0], [SQLState: 25P02]
>> >> >>>>
>> >> >>>> Exception in thread Thread-100:
>> >> >>>> Traceback (most recent call last):
>> >> >>>> File "C:\Softwares\mysoft\jython2.2.1\Lib\threading.py", line
>> >> >>>> 414,
>> >> >>>> in
>> >> >>>> _Thread__bootstrap
>> >> >>>> self.run()
>> >> >>>> File
>> >> >>>>
>> >> >>>> "C:\Softwares\mysoft\ground_report-1.1\lib\multithreadUtilities.py",
>> >> >>>> line
>> >> >>>> 62, in run
>> >> >>>> self.finishedQueue.put(eval(self.sqlScript)(self.dbConn,
>> >> >>>> self.sqlQueue.get_nowait() ))
>> >> >>>> File
>> >> >>>> "C:\Softwares\mysoft\ground_report-1.1\lib\databaseFactory.py",
>> >> >>>> line 813, in refreshMaterialisedView
>> >> >>>> c.execute('SELECT refresh_matview(\'' + mv + '\');')
>> >> >>>> Error: ERROR: current transaction is aborted, commands ignored
>> >> >>>> until
>> >> >>>> end
>> >> >>>> of transaction block [SQLCode: 0], [SQLState: 25P02]
>> >> >>>>
>> >> >>>>
>> >> >>>> Time Taken = 00 Hours 00 Minutes 00 Seconds
>> >> >>>>
>> >> >>>>
>> >> >>>>
>> >> >>>>
>> >> >>>> On Wed, Apr 22, 2009 at 2:33 PM, Calum Fitzgerald
>> >> >>>> <cal...@gm...> wrote:
>> >> >>>>>
>> >> >>>>> try this:
>> >> >>>>>
>> >> >>>>>
>> >> >>>>>
>> >> >>>>>
>> >> >>>>> fileList=["c:/Softwares/mysoft/ground_report-1.1/etc/data_Office-PC-118.csv"]
>> >> >>>>>
>> >> >>>>> it needs the square brackets to work.
>> >> >>>>>
>> >> >>>>> Cheers
>> >> >>>>> Cal
>> >> >>>>>
>> >> >>>>> 2009/4/22 KG KG <tsm...@gm...>:
>> >> >>>>> > Hi All,
>> >> >>>>> >
>> >> >>>>> > I am in the process of using Ground Report to generate the
>> >> >>>>> > grinder
>> >> >>>>> > generated
>> >> >>>>> > reports.
>> >> >>>>> >
>> >> >>>>> > I have configured the Ground Report 1.1 with the postgres8.2
>> >> >>>>> > DB.
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>> > When I try to upload files(using option 4) running the
>> >> >>>>> > databaseinterface.bat
>> >> >>>>> > of ground report, I get the following error:
>> >> >>>>> >
>> >> >>>>> > ERROR: could not open file "c" for reading: No
>> >> >>>>> > such
>> >> >>>>> > file or
>> >> >>>>> > directory [SQLCode: 0], [SQLState: 58P01]
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>> > However, I have specified the file name in data.properties as
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>> > fileList="c:/Softwares/mysoft/ground_report-1.1/etc/data_Office-PC-118.csv"
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>> > with the,
>> >> >>>>> >
>> >> >>>>> > dataType=norm
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>> > I tried giving full access to the postgres DB as well, still
>> >> >>>>> > the
>> >> >>>>> > same.
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>> > Please clarify.
>> >> >>>>> >
>> >> >>>>> > Appreciate your help.
>> >> >>>>> >
>> >> >>>>> > Thanks
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>> > ------------------------------------------------------------------------------
>> >> >>>>> > Stay on top of everything new and different, both inside and
>> >> >>>>> > around Java (TM) technology - register by April 22, and save
>> >> >>>>> > $200 on the JavaOne (SM) conference, June 2-5, 2009, San
>> >> >>>>> > Francisco.
>> >> >>>>> > 300 plus technical and hands-on sessions. Register today.
>> >> >>>>> > Use priority code J9JMT32. http://p.sf.net/sfu/p
>> >> >>>>> > _______________________________________________
>> >> >>>>> > grinder-use mailing list
>> >> >>>>> > gri...@li...
>> >> >>>>> > https://lists.sourceforge.net/lists/listinfo/grinder-use
>> >> >>>>> >
>> >> >>>>> >
>> >> >>>>>
>> >> >>>>>
>> >> >>>>>
>> >> >>>>>
>> >> >>>>> ------------------------------------------------------------------------------
>> >> >>>>> Stay on top of everything new and different, both inside and
>> >> >>>>> around Java (TM) technology - register by April 22, and save
>> >> >>>>> $200 on the JavaOne (SM) conference, June 2-5, 2009, San
>> >> >>>>> Francisco.
>> >> >>>>> 300 plus technical and hands-on sessions. Register today.
>> >> >>>>> Use priority code J9JMT32. http://p.sf.net/sfu/p
>> >> >>>>> _______________________________________________
>> >> >>>>> grinder-use mailing list
>> >> >>>>> gri...@li...
>> >> >>>>> https://lists.sourceforge.net/lists/listinfo/grinder-use
>> >> >>>>
>> >> >>>
>> >> >>
>> >> >
>> >> >
>> >
>> >
>
>
|