Bug 1062259
| Summary: | [dbscripts] engine-setup fails to configure dwh (psql:upgrade/03_02_0090_updated_enums.sql:1: ERROR: unsafe use of string constant with Unicode escapes) | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [Retired] oVirt | Reporter: | Jiri Belka <jbelka> | ||||
| Component: | ovirt-engine-dwh | Assignee: | Yaniv Lavi <ylavi> | ||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Jiri Belka <jbelka> | ||||
| Severity: | urgent | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 3.4 | CC: | acathrow, emesika, gklein, iheim, yeylon, ylavi | ||||
| Target Milestone: | --- | ||||||
| Target Release: | --- | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2014-02-06 14:43:07 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 is resolved in beta2. Please reopen if needed after testing with beta2. Yaniv |
Created attachment 860192 [details] ovirt-engine-setup-$date.log Description of problem: engine-setup fails to configure dwh, according to alonbl@ it's because of an issue in dbscripts. this is upgrade from first 3.4 ...snip... 2014-02-06 15:05:27 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine_dwh.db.schema plugin.execute:446 execute-output: ['/usr/share/ovirt-engine-dwh/dbscripts/create_schema.sh', '-l', '/var/log/ovirt-engine/setup/ovirt-engine-setup-20140206150321.log', '-s', 'localhost', '-p', '5432', '-d', 'ovirt_engine_history', '-u', 'ovirt_engine_history', '-g'] stderr: psql:upgrade/03_02_0090_updated_enums.sql:1: ERROR: unsafe use of string constant with Unicode escapes LINE 1: ...st(-1 as smallint),cast('ja' as varchar(40)),cast(U&'\4E0D\6... ^ DETAIL: String constants with Unicode escapes cannot be used when standard_conforming_strings is off. 2014-02-06 15:05:27 DEBUG otopi.context context._executeMethod:152 method exception Traceback (most recent call last): File "/usr/lib/python2.6/site-packages/otopi/context.py", line 142, in _executeMethod method['method']() File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine-dwh/db/schema.py", line 207, in _miscInstall odwhcons.DBEnv.PGPASS_FILE File "/usr/lib/python2.6/site-packages/otopi/plugin.py", line 451, in execute command=args[0], RuntimeError: Command '/usr/share/ovirt-engine-dwh/dbscripts/create_schema.sh' failed to execute ...snip... Version-Release number of selected component (if applicable): ovirt-engine-setup-3.4.0-0.5.beta1.el6.noarch ovirt-engine-dbscripts-3.4.0-0.5.beta1.el6.noarch How reproducible: ? Steps to Reproduce: 1. install 3.4 (just ovirt-engine) 2. engine-setup 3. install ovirt-engine-dwh 4. engine-setup Actual results: [ ERROR ] Failed to execute stage 'Misc configuration': Command '/usr/share/ovirt-engine-dwh/dbscripts/create_schema.sh' failed to execute Expected results: should work Additional info: