[
https://issues.apache.org/jira/browse/HAWQ-233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15047900#comment-15047900
]
ASF GitHub Bot commented on HAWQ-233:
-------------------------------------
GitHub user leoncamel opened a pull request:
https://github.com/apache/incubator-hawq/pull/170
HAWQ-233. Fix HAWQ initialization failed on Centos7
Hi,
We have investigated this issue, and we found the root cause is that
gcc-4.8 introduced new feature "-faggressive-loop-optimizations". This
optimization feature is enabled by default, and it will break variable length
array under some condition.
Similar issue can be found from PostgreSQL 9.2. See the following links for
detail:
1. http://www.postgresql.org/message-id/[email protected]
2. https://gcc.gnu.org/gcc-4.8/changes.html
3.
http://pkgs.fedoraproject.org/cgit/postgresql.git/commit/?h=f19&id=2a75d7af27fdf03e875f76f4c272c8435f565d10
So, we just borrow the idea to fix this issue and create a patch. Please
review it.
Thanks.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/leoncamel/incubator-hawq HAWQ-233
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hawq/pull/170.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #170
----
commit 3c777449ee8eb11227281394f10c4fb5faf37d77
Author: Xiaolin Zhang <[email protected]>
Date: 2015-12-09T02:27:25Z
HAWQ-233. Fix HAWQ initialization failed on Centos7
----
> HAWQ failed to initialize the cluster if it is built on centos 7
> ----------------------------------------------------------------
>
> Key: HAWQ-233
> URL: https://issues.apache.org/jira/browse/HAWQ-233
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Build
> Reporter: Zhanwei Wang
> Assignee: Lei Chang
> Attachments:
> 0001-HAWQ-233.-Fix-HAWQ-initialization-failed-on-Centos7.patch
>
>
> {code}
> The database cluster will be initialized with locale en_US.utf8.
> fixing permissions on existing directory
> /mnt/xiaolin/hawq-data-directory/masterdd ... ok
> creating subdirectories ... ok
> selecting default max_connections ... 1280
> selecting default shared_buffers/max_fsm_pages ... 125MB/200000
> creating configuration files ... ok
> creating template1 database in
> /mnt/xiaolin/hawq-data-directory/masterdd/base/1 ... 2015-12-05
> 02:00:44.038224
> GMT,,,p106570,th2038606336,,,,0,,,seg-10000,,,,,"WARNING","01000","""fsync"":
> can not be set by the user and will be
> ignored.",,,,,,,,"set_config_option","guc.c",9990,
> ok
> loading file-system persistent tables for template1 ...
> 2015-12-05 02:00:50.473854
> GMT,,,p106586,th2067827200,,,,0,,,seg-10000,,,,,"WARNING","01000","""fsync"":
> can not be set by the user and will be
> ignored.",,,,,,,,"set_config_option","guc.c",9990,
> ok
> initializing pg_authid ... 2015-12-05 02:00:51.873844
> GMT,,,p106590,th-1267525120,,,,0,,,seg-10000,,,,,"WARNING","01000","""fsync"":
> can not be set by the user and will be
> ignored.",,,,,,,,"set_config_option","guc.c",9990,
> 2015-12-05 10:00:52.434633
> CST,,,p106590,th-1267525120,,,,0,,cmd1,seg-10000,,,x6,sx1,"FATAL","XX000","wrong
> number of index expressions (index.c:1186)",,,,,,"CREATE TRIGGER
> pg_sync_pg_database AFTER INSERT OR UPDATE OR DELETE ON pg_database FOR
> EACH STATEMENT EXECUTE PROCEDURE flatfile_update_trigger();
> ",,"FormIndexDatum","index.c",1186,1 0x8c2b28 postgres errstart
> (elog.c:473)
> 2 0x8c489b postgres elog_finish (elog.c:1421)
> 3 0x5735e5 postgres FormIndexDatum (index.c:1186)
> 4 0x575030 postgres CatalogIndexInsert (discriminator 2)
> 5 0x562f14 postgres caql_insert (caqlaccess.c:830)
> 6 0x63fb38 postgres CreateTrigger (trigger.c:427)
> 7 0x7ed0ec postgres ProcessUtility (utility.c:1578)
> 8 0x7e8d6e postgres <symbol not found> (pquery.c:1885)
> 9 0x7ea54e postgres <symbol not found> (pquery.c:1989)
> 10 0x7ec2a5 postgres PortalRun (pquery.c:1510)
> 11 0x7e41f1 postgres <symbol not found> (postgres.c:1732)
> 12 0x7e56b4 postgres PostgresMain (postgres.c:4697)
> 13 0x4a2982 postgres main (main.c:204)
> 14 0x7f1eb174faf5 libc.so.6 __libc_start_main (??:0)
> 15 0x4a2a1d postgres <symbol not found> (??:?)
> child process exited with exit code 1
> initdb: removing contents of data directory
> "/mnt/xiaolin/hawq-data-directory/masterdd"
> Master postgres initdb failed
> 20151205:10:01:00:106236 hawq_init:dserver1:xiaolin-[INFO]:-Master postgres
> initdb failed
> 20151205:10:01:00:106236 hawq_init:dserver1:xiaolin-[ERROR]:-Master init
> failed, exit
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
