Bug 1629641
| Summary: | PSQLException ERROR: integer out of range - Storage Domains view | ||
|---|---|---|---|
| Product: | [oVirt] ovirt-engine | Reporter: | Fred Rolland <frolland> |
| Component: | BLL.Storage | Assignee: | Ahmad Khiet <akhiet> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Yosi Ben Shimon <ybenshim> |
| Severity: | medium | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 4.2.6 | CC: | bugs, lveyde, ratamir, tnisan |
| Target Milestone: | ovirt-4.2.7 | Flags: | rule-engine:
ovirt-4.2+
rule-engine: exception+ |
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | ovirt-engine-4.2.7.3 | Doc Type: | If docs needed, set a value |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2018-10-21 11:48:27 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | Storage | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
Description of problem: the RHV menu for Storage Domains stopped working, it just showed the spinning wheel. The logs shows an SQL error. Long story short: in the storage domain there was a file with ILEGAL status that reported an absurdily big file size (6735454849883701248) in the SQL table that made the SQL views blow up: 2018-08-29 06:01:03,208-04 ERROR [org.ovirt.engine.core.bll.SearchQuery] (default task-223) [24a10e65-cf90-454b-a746-765c9ec4fe26] Query 'SearchQuery' failed: StatementCallback; SQL [SELECT * FROM ((SELECT distinct storage_domains_for_search.* FROM storage_domains_for_search ) ORDER BY storage_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; ERROR: integer out of range; nested exception is org.postgresql.util.PSQLException: ERROR: integer out of range 2018-08-29 06:01:03,208-04 ERROR [org.ovirt.engine.core.bll.SearchQuery] (default task-223) [24a10e65-cf90-454b-a746-765c9ec4fe26] Exception: org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [SELECT * FROM ((SELECT distinct storage_domains_for_search.* FROM storage_domains_for_search ) ORDER BY storage_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; ERROR: integer out of range; nested exception is org.postgresql.util.PSQLException: ERROR: integer out of range engine=# select * from images; image_guid | creation_date | size | it_guid | parentid | imagest atus | lastmodified | vm_snapshot_id | volume_type | volume_format | image_group_id | _create_date | _update_date | active | volume_classification | qcow_compat 5a2a1ee6-c8da-4c3d-bdc1-ba9759fd13cd | 2018-08-07 14:40:27.729-04 | 6735454849883701248 | 00000000-0000-0000-0000-000000000000 | 00000000-0000-0000-0000-000000000000 | 4 | 2018-08-07 14:40:27.729-04 | 46912587-e036-4721-b455-65a9b81dc480 | 2 | 5 | 14da0433-70fa-4825-aadf-4ac36996c917 | 2018-08-07 14:40:27.729927-04 | | t | 0 | 0 See: https://gerrit.ovirt.org/#/c/52912/