Bug 1297701 - fix_invalid_macs.sql is incompatible with postgresql 8
Summary: fix_invalid_macs.sql is incompatible with postgresql 8
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: ovirt-engine
Classification: oVirt
Component: BLL.Network
Version: 3.6.1
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: ovirt-3.6.2
: 3.6.2.5
Assignee: Dan Kenigsberg
QA Contact: Meni Yakove
URL:
Whiteboard:
Depends On:
Blocks: RHEV3.6Upgrade
TreeView+ depends on / blocked
 
Reported: 2016-01-12 09:32 UTC by Yedidyah Bar David
Modified: 2016-02-18 11:16 UTC (History)
6 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-02-18 11:16:26 UTC
oVirt Team: Network
Embargoed:
rule-engine: ovirt-3.6.z+
rule-engine: blocker+
ylavi: planning_ack+
michal.skrivanek: devel_ack+
pstehlik: testing_ack+


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
oVirt gerrit 51693 0 ovirt-engine-3.6 MERGED network:fix invalid regexp syntax 2016-01-12 10:18:58 UTC
oVirt gerrit 51694 0 ovirt-engine-3.6.2 MERGED network:fix invalid regexp syntax 2016-01-12 10:19:05 UTC
oVirt gerrit 51744 0 master MERGED network:fix invalid regexp syntax 2016-01-25 10:04:34 UTC

Description Yedidyah Bar David 2016-01-12 09:32:01 UTC
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:


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