Bug 1191755
| Summary: | frequent postgresql error "PGError: ERROR: value too long for type character varying(255)" returned from VM scanning | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Red Hat CloudForms Management Engine | Reporter: | Thomas Hennessy <thenness> | ||||
| Component: | SmartState Analysis | Assignee: | Rich Oliveri <roliveri> | ||||
| Status: | CLOSED INSUFFICIENT_DATA | QA Contact: | Vadim Rutkovsky <vrutkovs> | ||||
| Severity: | medium | Docs Contact: | |||||
| Priority: | medium | ||||||
| Version: | 5.3.0 | CC: | jdeubel, jhardy, jocarter, mfeifer, obarenbo, xlecauch | ||||
| Target Milestone: | GA | ||||||
| Target Release: | 5.6.0 | ||||||
| Hardware: | x86_64 | ||||||
| OS: | Linux | ||||||
| Whiteboard: | error:infra:vm:smartstate | ||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2016-02-18 15:59:35 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: | |||||||
| Attachments: |
|
||||||
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. |
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.