Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1059689

Summary: [engine-log-collector] while having --no-postgresql there's sql errors in the output
Product: [Retired] oVirt Reporter: Jiri Belka <jbelka>
Component: ovirt-engine-logcollectorAssignee: Sandro Bonazzola <sbonazzo>
Status: CLOSED NOTABUG QA Contact: bugs <bugs>
Severity: high Docs Contact:
Priority: unspecified    
Version: 3.4CC: acathrow, gklein, iheim, yeylon
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-01-31 10:17:36 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Jiri Belka 2014-01-30 11:12:25 UTC
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
-%-

Comment 1 Sandro Bonazzola 2014-01-31 10:17:36 UTC
--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.