Re: [galaxy-dev] stupid logging question

Thanks, that fixed it, they were uncommented! 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 Wed, Jun 2, 2010 at 9:56 AM, James Taylor&lt;james(a)bx.psu.edu&gt; wrote: > 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&lt;nate(a)bx.psu.edu&gt; 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 >> > _______________________________________________ galaxy-dev mailing list galaxy-dev(a)lists.bx.psu.edu http://lists.bx.psu.edu/listinfo/galaxy-dev