Bug 1191755 - frequent postgresql error "PGError: ERROR: value too long for type character varying(255)" returned from VM scanning
Summary: frequent postgresql error "PGError: ERROR: value too long for type character...
Keywords:
Status: CLOSED INSUFFICIENT_DATA
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: SmartState Analysis
Version: 5.3.0
Hardware: x86_64
OS: Linux
medium
medium
Target Milestone: GA
: 5.6.0
Assignee: Rich Oliveri
QA Contact: Vadim Rutkovsky
URL:
Whiteboard: error:infra:vm:smartstate
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-02-11 21:54 UTC by Thomas Hennessy
Modified: 2017-12-07 15:00 UTC (History)
6 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-02-18 15:59:35 UTC
Category: ---
Cloudforms Team: ---
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)
log lines from single scan job where only one appliance is performing scanning in a zone (124.61 KB, text/plain)
2015-02-11 21:54 UTC, Thomas Hennessy
no flags Details

Description Thomas Hennessy 2015-02-11 21:54:49 UTC
Created attachment 990654 [details]
log lines from single scan job where only one appliance is performing scanning in a zone

Description of problem: PostgreSQL error returned on many VM scans suggesting that data has been lost when trying to save scan data into VMDB.


Version-Release number of selected component (if applicable): 5.3.2.6


How reproducible:


Steps to Reproduce: NORMAL scanning of vms in inventory
1.
2.
3.

Actual results:
[----] E, [2015-02-01T18:49:18.384628 #15969:c40838] ERROR -- : Q-task_id([3535d8ae-aa3c-11e4-8fd3-005056af0049]) MIQ(abstract_adapter) Name: [SQL], Message: [PGError: ERROR:  value too long for type character varying(255)
...: INSERT INTO "accounts" ("acctid", "accttype", "comment", "display_name", "domain", "enabled", "expires", "homedir", "host_id", "last_logon", "local", "name", "vm_or_template_id") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id"...]
[----] E, [2015-02-01T18:49:18.385556 #15969:c40838] ERROR -- : Q-task_id([3535d8ae-aa3c-11e4-8fd3-005056af0049]) [ActiveRecord::StatementInvalid]: Database statement error encountered  Method:[rescue in block in add_elements]


Expected results:
normal completion of scan with data elements being successfully and uneventfully saved into the VMDB.


Additional info:
sample logs from one scan job are provided as a reference.

Comment 2 Dave Johnson 2016-02-18 15:59:35 UTC
This BZ is now over a year old, because of this, we are closing it.  If you feel like this is a mistake and it is still a issue, please reproduce it in the latest release and create a new BZ.


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