Bug 1059689 - [engine-log-collector] while having --no-postgresql there's sql errors in the output
Summary: [engine-log-collector] while having --no-postgresql there's sql errors in the...
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: oVirt
Classification: Retired
Component: ovirt-engine-logcollector
Version: 3.4
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: ---
: ---
Assignee: Sandro Bonazzola
QA Contact: bugs@ovirt.org
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-01-30 11:12 UTC by Jiri Belka
Modified: 2014-01-31 10:17 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-01-31 10:17:36 UTC
oVirt Team: ---
Embargoed:


Attachments (Terms of Use)

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.


Note You need to log in before you can comment on or make changes to this bug.