Description of problem: # engine-log-collector --no-postgresql -v ..skip.. DEBUG: STDERR() INFO: Skipping postgresql collection... Please provide the REST API password for the admin@internal oVirt Engine user (CTRL+D to skip): DEBUG: API Vendor(ovirt.org) API Version(3.4.0) ERROR: Unable to connect to REST API. Reason: Bad Request ERROR: _get_hypervisors_from_api: ^M status: 400^M reason: Bad Request^M detail: statementcallback; sql [select * from (select * from storage pool where ( id in (select storage pool with storage domain.id from storage pool with storage domain )) order by name asc ) as t1 offset (-2147483648 -1) limit 2147483647]; error: integer out of range; nested exception is org.postgresql.util.psqlexception: error: integer out of range ^^^ HERE INFO: No hypervisors were selected, therefore no hypervisor data will be collected. ..skip.. Version-Release number of selected component (if applicable): ovirt-log-collector-3.4.0-0.0.master.20131224.gite939ada.el6.noarch How reproducible: 100% Steps to Reproduce: 1. engine-log-collector --no-postgresql -v 2. check if there's anything about sql queries 3. Actual results: detail: statementcallback; sql [select * from (select * from storage pool where ( id in (select storage pool with storage domain.id from storage pool with storage domain )) order by name asc ) as t1 offset (-2147483648 -1) limit 2147483647]; error: integer out of range; nested exception is org.postgresql.util.psqlexception: error: integer out of range Expected results: --no-postgresql means no sql queries i suppose :) Additional info: -%- # engine-log-collector --no-postgresql -v INFO: Gathering oVirt Engine information... DEBUG: calling(['sosreport', '--batch', '--report', '--build', '--tmp-dir=/tmp/logcollector-Mu9wI6', '-o', 'engine,rpm,libvirt,general,networking,hardware,process,yum,filesys,devicemapper,selinux,kernel,apache,memory', '-k', 'rpm.rpmva=off', '-k', 'general.all_logs=True', '-k', 'apache.log=True']) DEBUG: returncode(0) DEBUG: STDOUT( sosreport (version 2.2) This command will collect diagnostic and configuration information from this Red Hat Enterprise Linux system and installed applications. An archive containing the collected information will be generated in /tmp/logcollector-Mu9wI6 and may be provided to a Red Hat support representative. Any information provided to Red Hat will be treated in accordance with the published support policies at: https://access.redhat.com/support/ The generated archive may contain data considered sensitive and its content should be reviewed by the originating organization before being passed to any third party. No changes will be made to system configuration. Running plugins. Please wait ... Completed [1/14] ... Completed [2/14] ... Completed [3/14] ... Completed [4/14] ... Completed [5/14] ... Completed [6/14] ... Completed [7/14] ... Completed [8/14] ... Completed [9/14] ... Completed [10/14] ... Completed [11/14] ... Completed [12/14] ... Completed [13/14] ... Completed [14/14] ... sosreport build tree is located at : /tmp/logcollector-Mu9wI6/jb-rh34-2014013010541391075671 ) DEBUG: STDERR() INFO: Skipping postgresql collection... Please provide the REST API password for the admin@internal oVirt Engine user (CTRL+D to skip): DEBUG: API Vendor(ovirt.org) API Version(3.4.0) ERROR: Unable to connect to REST API. Reason: Bad Request ERROR: _get_hypervisors_from_api: status: 400 reason: Bad Request detail: statementcallback; sql [select * from (select * from storage pool where ( id in (select storage pool with storage domain.id from storage pool with storage domain )) order by name asc ) as t1 offset (-2147483648 -1) limit 2147483647]; error: integer out of range; nested exception is org.postgresql.util.psqlexception: error: integer out of range INFO: No hypervisors were selected, therefore no hypervisor data will be collected. Creating compressed archive... DEBUG: calling(['xz', '--version']) DEBUG: returncode(0) DEBUG: STDOUT(xz (XZ Utils) 4.999.9beta liblzma 4.999.9beta ) DEBUG: STDERR() DEBUG: calling(['tar', '-cf', '/tmp/sosreport-LogCollector-20140130110353.tar', '-C', '/tmp/logcollector-Mu9wI6', '.']) DEBUG: returncode(0) DEBUG: STDOUT() DEBUG: STDERR() DEBUG: calling(['xz', '-1', '/tmp/sosreport-LogCollector-20140130110353.tar']) DEBUG: returncode(0) DEBUG: STDOUT() DEBUG: STDERR() DEBUG: calling(['md5sum', '/tmp/sosreport-LogCollector-20140130110353.tar.xz']) DEBUG: returncode(0) DEBUG: STDOUT(a1ed12ac75af2ffd1d464c131d60df53 /tmp/sosreport-LogCollector-20140130110353.tar.xz ) DEBUG: STDERR() INFO: Log files have been collected and placed in /tmp/sosreport-LogCollector-20140130110353.tar.xz. The MD5 for this file is a1ed12ac75af2ffd1d464c131d60df53 and its size is 7.4M -%-
--no-postgresql means what man page says: --no-postgresql This option causes the tool to skip the postgresql collection (default=false). SQL queries are still needed by engine in order to get hypervisors list. log-collector just don't collect sosreport from postgresql sos plugin.