Have you uncommented either of:
#database_engine_option_echo = true
#database_engine_option_echo_pool = true
In you universe_wsgi.ini?
On Jun 1, 2010, at 7:53 PM, Michael Pheasant wrote:
using run script with single web server/jobrunner:
universe_wsgi.ini:
log_level = WARNING
enable_job_running = True
*) During the startup sequence there is a bunch of INFO stuff;
2010-06-02 09:49:55,321 INFO sqlalchemy.pool.QueuePool.0x...8410
Created new connection <_mysql.connection open to 'localhost' at
1aab1730>
sqlalchemy.pool.QueuePool.0x...8410 INFO 2010-06-02 09:49:55,321
Created new connection <_mysql.connection open to 'localhost' at
1aab1730>
2010-06-02 09:49:55,321 INFO sqlalchemy.pool.QueuePool.0x...8410
Connection <_mysql.connection open to 'localhost' at 1aab1730> checked
out from pool
sqlalchemy.pool.QueuePool.0x...8410 INFO 2010-06-02 09:49:55,321
Connection <_mysql.connection open to 'localhost' at 1aab1730> checked
out from pool
2010-06-02 09:49:55,322 INFO sqlalchemy.engine.base.Engine.0x...85d0
SHOW VARIABLES LIKE 'character_set%%'
sqlalchemy.engine.base.Engine.0x...85d0 INFO 2010-06-02 09:49:55,322
SHOW VARIABLES LIKE 'character_set%%'
2010-06-02 09:49:55,322 INFO sqlalchemy.engine.base.Engine.0x...85d0
()
sqlalchemy.engine.base.Engine.0x...85d0 INFO 2010-06-02 09:49:55,322
()
2010-06-02 09:49:55,323 INFO sqlalchemy.engine.base.Engine.0x...85d0
SHOW VARIABLES LIKE 'sql_mode'
sqlalchemy.engine.base.Engine.0x...85d0 INFO 2010-06-02 09:49:55,323
SHOW VARIABLES LIKE 'sql_mode'
2010-06-02 09:49:55,323 INFO sqlalchemy.engine.base.Engine.0x...85d0
()
sqlalchemy.engine.base.Engine.0x...85d0 INFO 2010-06-02 09:49:55,323
()
2010-06-02 09:49:55,348 INFO sqlalchemy.engine.base.Engine.0x...85d0
SHOW CREATE TABLE dataset
sqlalchemy.engine.base.Engine.0x...85d0 INFO 2010-06-02 09:49:55,348
SHOW CREATE TABLE dataset
2010-06-02 09:49:55,348 INFO sqlalchemy.engine.base.Engine.0x...85d0
()
Then every second there is the database ping for jobs;
sqlalchemy.engine.base.Engine.0x...0e50 INFO 2010-06-02 09:50:15,153
SELECT job.id AS job_id, job.create_time AS job_create_time,
job.update_time AS job_update_time, job.history_id AS job_history_id,
job.library_folder_id AS job_library_folder_id, job.tool_id AS
job_tool_id, job.tool_version AS job_tool_version, job.state AS
job_state, job.info AS job_info, job.command_line AS job_command_line,
job.param_filename AS job_param_filename, job.runner_name AS
job_runner_name_1, job.stdout AS job_stdout, job.stderr AS job_stderr,
job.traceback AS job_traceback, job.session_id AS job_session_id,
job.job_runner_name AS job_job_runner_name, job.job_runner_external_id
AS job_job_runner_external_id,
library_dataset_dataset_association_1.id AS
library_dataset_dataset_association_1_id,
library_dataset_dataset_association_1.library_dataset_id AS
library_dataset_dataset_association_1_library_dataset_id,
library_dataset_dataset_association_1.dataset_id AS
library_dataset_dataset_association_1_dataset_id,
library_dataset_dataset_association_1.create_time AS
library_dataset_dataset_association_1_create_time,
library_dataset_dataset_association_1.update_time AS
library_dataset_dataset_association_1_update_time,
library_dataset_dataset_association_1
.copied_from_history_dataset_association_id
AS
library_dataset_dataset_association_1_copied_from_history_dataset_association_id
,
library_dataset_dataset_association_1
.copied_from_library_dataset_dataset_association_id
AS
library_dataset_dataset_association_1_copied_from_library_dataset_dataset_association_id
,
library_dataset_dataset_association_1.name AS
library_dataset_dataset_association_1_name,
library_dataset_dataset_association_1.info AS
library_dataset_dataset_association_1_info,
library_dataset_dataset_association_1.blurb AS
library_dataset_dataset_association_1_blurb,
library_dataset_dataset_association_1.peek AS
library_dataset_dataset_association_1_peek,
library_dataset_dataset_association_1.extension AS
library_dataset_dataset_association_1_extension,
library_dataset_dataset_association_1.metadata AS
library_dataset_dataset_association_1_metadata,
library_dataset_dataset_association_1.parent_id AS
library_dataset_dataset_association_1_parent_id,
library_dataset_dataset_association_1.designation AS
library_dataset_dataset_association_1_designation,
library_dataset_dataset_association_1.deleted AS
library_dataset_dataset_association_1_deleted,
library_dataset_dataset_association_1.visible AS
library_dataset_dataset_association_1_visible,
library_dataset_dataset_association_1.user_id AS
library_dataset_dataset_association_1_user_id,
library_dataset_dataset_association_1.message AS
library_dataset_dataset_association_1_message,
job_to_output_library_dataset_1.id AS
job_to_output_library_dataset_1_id,
job_to_output_library_dataset_1.job_id AS
job_to_output_library_dataset_1_job_id,
job_to_output_library_dataset_1.ldda_id AS
job_to_output_library_dataset_1_ldda_id,
job_to_output_library_dataset_1.name AS
job_to_output_library_dataset_1_name, dataset_1.id AS dataset_1_id,
dataset_1.create_time AS dataset_1_create_time, dataset_1.update_time
AS dataset_1_update_time, dataset_1.state AS dataset_1_state,
dataset_1.deleted AS dataset_1_deleted, dataset_1.purged AS
dataset_1_purged, dataset_1.purgable AS dataset_1_purgable,
dataset_1.external_filename AS dataset_1_external_filename,
dataset_1._extra_files_path AS dataset_1__extra_files_path,
dataset_1.file_size AS dataset_1_file_size,
history_dataset_association_1.id AS history_dataset_association_1_id,
history_dataset_association_1.history_id AS
history_dataset_association_1_history_id,
history_dataset_association_1.dataset_id AS
history_dataset_association_1_dataset_id,
history_dataset_association_1.create_time AS
history_dataset_association_1_create_time,
history_dataset_association_1.update_time AS
history_dataset_association_1_update_time,
history_dataset_association_1
.copied_from_history_dataset_association_id
AS
history_dataset_association_1_copied_from_history_dataset_association_id
,
history_dataset_association_1
.copied_from_library_dataset_dataset_association_id
AS
history_dataset_association_1_copied_from_library_dataset_dataset_association_id
,
history_dataset_association_1.hid AS
history_dataset_association_1_hid, history_dataset_association_1.name
AS history_dataset_association_1_name,
history_dataset_association_1.info AS
history_dataset_association_1_info,
history_dataset_association_1.blurb AS
history_dataset_association_1_blurb,
history_dataset_association_1.peek AS
history_dataset_association_1_peek,
history_dataset_association_1.extension AS
history_dataset_association_1_extension,
history_dataset_association_1.metadata AS
history_dataset_association_1_metadata,
history_dataset_association_1.parent_id AS
history_dataset_association_1_parent_id,
history_dataset_association_1.designation AS
history_dataset_association_1_designation,
history_dataset_association_1.deleted AS
history_dataset_association_1_deleted,
history_dataset_association_1.visible AS
history_dataset_association_1_visible, job_to_input_dataset_1.id AS
job_to_input_dataset_1_id, job_to_input_dataset_1.job_id AS
job_to_input_dataset_1_job_id, job_to_input_dataset_1.dataset_id AS
job_to_input_dataset_1_dataset_id, job_to_input_dataset_1.name AS
job_to_input_dataset_1_name, dataset_2.id AS dataset_2_id,
dataset_2.create_time AS dataset_2_create_time, dataset_2.update_time
AS dataset_2_update_time, dataset_2.state AS dataset_2_state,
dataset_2.deleted AS dataset_2_deleted, dataset_2.purged AS
dataset_2_purged, dataset_2.purgable AS dataset_2_purgable,
dataset_2.external_filename AS dataset_2_external_filename,
dataset_2._extra_files_path AS dataset_2__extra_files_path,
dataset_2.file_size AS dataset_2_file_size,
history_dataset_association_2.id AS history_dataset_association_2_id,
history_dataset_association_2.history_id AS
history_dataset_association_2_history_id,
history_dataset_association_2.dataset_id AS
history_dataset_association_2_dataset_id,
history_dataset_association_2.create_time AS
history_dataset_association_2_create_time,
history_dataset_association_2.update_time AS
history_dataset_association_2_update_time,
history_dataset_association_2
.copied_from_history_dataset_association_id
AS
history_dataset_association_2_copied_from_history_dataset_association_id
,
history_dataset_association_2
.copied_from_library_dataset_dataset_association_id
AS
history_dataset_association_2_copied_from_library_dataset_dataset_association_id
,
history_dataset_association_2.hid AS
history_dataset_association_2_hid, history_dataset_association_2.name
AS history_dataset_association_2_name,
history_dataset_association_2.info AS
history_dataset_association_2_info,
history_dataset_association_2.blurb AS
history_dataset_association_2_blurb,
history_dataset_association_2.peek AS
history_dataset_association_2_peek,
history_dataset_association_2.extension AS
history_dataset_association_2_extension,
history_dataset_association_2.metadata AS
history_dataset_association_2_metadata,
history_dataset_association_2.parent_id AS
history_dataset_association_2_parent_id,
history_dataset_association_2.designation AS
history_dataset_association_2_designation,
history_dataset_association_2.deleted AS
history_dataset_association_2_deleted,
history_dataset_association_2.visible AS
history_dataset_association_2_visible, job_to_output_dataset_1.id AS
job_to_output_dataset_1_id, job_to_output_dataset_1.job_id AS
job_to_output_dataset_1_job_id, job_to_output_dataset_1.dataset_id AS
job_to_output_dataset_1_dataset_id, job_to_output_dataset_1.name AS
job_to_output_dataset_1_name
FROM job LEFT OUTER JOIN job_to_output_library_dataset AS
job_to_output_library_dataset_1 ON job.id =
job_to_output_library_dataset_1.job_id LEFT OUTER JOIN
library_dataset_dataset_association AS
library_dataset_dataset_association_1 ON
library_dataset_dataset_association_1.id =
job_to_output_library_dataset_1.ldda_id LEFT OUTER JOIN
job_to_input_dataset AS job_to_input_dataset_1 ON job.id =
job_to_input_dataset_1.job_id LEFT OUTER JOIN
history_dataset_association AS history_dataset_association_1 ON
history_dataset_association_1.id = job_to_input_dataset_1.dataset_id
LEFT OUTER JOIN dataset AS dataset_1 ON dataset_1.id =
history_dataset_association_1.dataset_id LEFT OUTER JOIN
job_to_output_dataset AS job_to_output_dataset_1 ON job.id =
job_to_output_dataset_1.job_id LEFT OUTER JOIN
history_dataset_association AS history_dataset_association_2 ON
history_dataset_association_2.id = job_to_output_dataset_1.dataset_id
LEFT OUTER JOIN dataset AS dataset_2 ON dataset_2.id =
history_dataset_association_2.dataset_id
WHERE job.state = %s
2010-06-02 09:50:15,154 INFO sqlalchemy.engine.base.Engine.0x...0e50
['new']
sqlalchemy.engine.base.Engine.0x...0e50 INFO 2010-06-02 09:50:15,154
['new']
2010-06-02 09:50:15,157 INFO sqlalchemy.pool.QueuePool.0x...0c90
Connection <_mysql.connection open to 'localhost' at 1b0894d0> being
returned to pool
sqlalchemy.pool.QueuePool.0x...0c90 INFO 2010-06-02 09:50:15,157
Connection <_mysql.connection open to 'localhost' at 1b0894d0> being
returned to pool
cheers
m
--
Michael Pheasant
Software Engineer
Queensland Facility for Advanced Bioinformatics
Level 6, QBP
University of Queensland, QLD 4072
T: +61 (0)7 3346 2070
F: +61 (0)7 3346 2101
www.qfab.org
On Tue, Jun 1, 2010 at 11:24 PM, Nate Coraor <nate(a)bx.psu.edu> wrote:
> Michael Pheasant wrote:
>>
>> Using the run.sh script, and the default 'log_level = DEBUG'
>> universe_wsgi.ini file setting gives a huge amount of output.
>>
>> Changing the ini to either log_level = INFO, WARNING or ERROR and i
>> get the same output, including the INFO messages every second.
>>
>> I assumed that WARNING or ERROR would not give the INFO messages; is
>> there some way to not see these?
>
> Hi Michael,
>
> Can you provide an example of which INFO messages still appear?
> WARNING is
> suppressing everything above the WARNING level for me.
>
> --nate
>
>>
>> Cheers
>> m
>>
>> --
>> Michael Pheasant
>> Software Engineer
>> Queensland Facility for Advanced Bioinformatics
>> Level 6, QBP
>> University of Queensland, QLD 4072
>> T: +61 (0)7 3346 2070
>> F: +61 (0)7 3346 2101
>>
www.qfab.org
>> _______________________________________________
>> galaxy-dev mailing list
>> galaxy-dev(a)lists.bx.psu.edu
>>
http://lists.bx.psu.edu/listinfo/galaxy-dev
>
>
_______________________________________________
galaxy-dev mailing list
galaxy-dev(a)lists.bx.psu.edu
http://lists.bx.psu.edu/listinfo/galaxy-dev