Bug 1297701
| Summary: | fix_invalid_macs.sql is incompatible with postgresql 8 | ||
|---|---|---|---|
| Product: | [oVirt] ovirt-engine | Reporter: | Yedidyah Bar David <didi> |
| Component: | BLL.Network | Assignee: | Dan Kenigsberg <danken> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Meni Yakove <myakove> |
| Severity: | urgent | Docs Contact: | |
| Priority: | urgent | ||
| Version: | 3.6.1 | CC: | bugs, gklein, michal.skrivanek, pstehlik, sbonazzo, ylavi |
| Target Milestone: | ovirt-3.6.2 | Flags: | rule-engine:
ovirt-3.6.z+
rule-engine: blocker+ ylavi: planning_ack+ michal.skrivanek: devel_ack+ pstehlik: testing_ack+ |
| Target Release: | 3.6.2.5 | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2016-02-18 11:16:26 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | Network | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | |||
| Bug Blocks: | 1285700 | ||
Description of problem: 03_06_1980_fix_invalid_macs.sql (or 04_00_0120_fix_invalid_macs.sql in master branch) uses regexp with backreferences ('\1') in a way that is incompatible with postgresql 8 (but does work in 9). This causes all mac ranges to be converted to: \x01:\x01:\x01:\x01:\x01:\x01: - \x01:\x01:\x01:\x01:\x01:\x01: Version-Release number of selected component (if applicable): How reproducible: Always I think Steps to Reproduce: 1. setup a 3.5 engine 2. upgrade to 3.6 (or master) 3. Actual results: All mac ranges will be as described above, e.g.: engine=# select * from mac_pool_ranges ; mac_pool_id | from_mac | to_mac --------------------------------------+--------------------------------+-------------------------------- 0000001c-001c-001c-001c-0000000001a2 | \x01:\x01:\x01:\x01:\x01:\x01: | \x01:\x01:\x01:\x01:\x01:\x01: Expected results: mac ranges correctly converted into mac_pool_ranges Additional info: