Uploaded image for project: 'Apache HAWQ'
  1. Apache HAWQ
  2. HAWQ-1170

Crash at cleanup_allocation_algorithm() when enable '--enable-cassert' option

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 2.1.0.0-incubating
    • Core
    • None

    Description

      when add option '--enable-cassert' in hawq configure, hawq will crash when run a test case of gpload. In the case, the default bucket num is 12 and the expected virtual segment number is 24 when external table exists.

      reproduce steps :

      1. hawq config -c default_hash_table_bucket_number -v 12 --skipvalidation
      2. restart hawq
      3. create table lineitem with the create.sql
      4. update config_file, replace all $VAR with the correct value on your environment.
      5. gpload -f config_file

      THE LOG .
      2016-11-15 06:43:45.635469 PST,,,p177585,th0,,,2016-11-15 06:43:38 PST,0,con5182,cmd6,seg-10000,,,,,"PANIC","XX000","Unexpected internal error: Master process received signal SIGSEGV",,,,,,,0,,,,"1 0x9ce6f2 postgres <symbol not found> (elog.c:4510)
      2 0x9ce969 postgres StandardHandlerForSigillSigsegvSigbus_OnMainThread (elog.c:4597)
      3 0x8e1c36 postgres CdbProgramErrorHandler (postgres.c:3513)
      4 0x3e4380f7e0 libpthread.so.0 <symbol not found> (??:0)
      5 0xb66a11 postgres calculate_planner_segment_num (cdbdatalocality.c:4431)
      6 0x836555 postgres <symbol not found> (planner.c:667)
      7 0x835d5e postgres planner (planner.c:475)
      8 0x8dd67b postgres pg_plan_query (postgres.c:908)
      9 0x8dd786 postgres pg_plan_queries (postgres.c:982)
      10 0x8ded29 postgres <symbol not found> (postgres.c:1742)
      "
      2016-11-15 06:44:26.162520 PST,,,p78695,th-1193023200,,,,0,,,seg-10000,,,,,"LOG","00000","server process (PID 177585) was terminated by signal 11: Segmentation fault",,,,,,,0,,"postmaster.c",4748,
      2016-11-15 06:44:26.162587 PST,,,p78695,th-1193023200,,,,0,,,seg-10000,,,,,"LOG","00000","terminating any other active server processes",,,,,,,0,,"postmaster.c",4486,

      CORE DUMPED
      (gdb) bt
      #0 0x0000003e4380f6ab in raise () from /lib64/libpthread.so.0
      #1 0x00000000009ce73f in SafeHandlerForSegvBusIll (processName=0xd27713 "Master process", postgres_signal_arg=11) at elog.c:4519
      #2 0x00000000009ce969 in StandardHandlerForSigillSigsegvSigbus_OnMainThread (processName=0xd27713 "Master process", postgres_signal_arg=11) at elog.c:4597
      #3 0x00000000008e1c36 in CdbProgramErrorHandler (postgres_signal_arg=11) at postgres.c:3512
      #4 <signal handler called>
      #5 0x0000000000b65a16 in cleanup_allocation_algorithm (context=0x7fffbd549cd0) at cdbdatalocality.c:3980
      #6 0x0000000000b66a11 in calculate_planner_segment_num (query=0x307d5d0, resourceLife=QRL_ONCE, fullRangeTable=0x2ff2480, intoPolicy=0x0, sliceNum=2,
      fixedVsegNum=-1) at cdbdatalocality.c:4430
      #7 0x0000000000836555 in resource_negotiator (parse=0x307d708, cursorOptions=0, boundParams=0x0, resourceLife=QRL_ONCE, result=0x7fffbd54a018)
      at planner.c:667
      #8 0x0000000000835d5e in planner (parse=0x307d708, cursorOptions=0, boundParams=0x0, resourceLife=QRL_ONCE) at planner.c:473
      #9 0x00000000008dd67b in pg_plan_query (querytree=0x307d708, boundParams=0x0, resource_life=QRL_ONCE) at postgres.c:908
      #10 0x00000000008dd786 in pg_plan_queries (querytrees=0x2ed7960, boundParams=0x0, needSnapshot=0 '\000', resource_life=QRL_ONCE) at postgres.c:982
      #11 0x00000000008ded29 in exec_simple_query (
      query_string=0x2ed0898 "INSERT INTO public.\"lineitem\" (\"l_orderkey\",\"l_partkey\",\"l_suppkey\",\"l_linenumber\",\"l_quantity\",\"l_extendedprice\",\"l_discount\",\"l_tax\",\"l_returnflag\",\"l_linestatus\",\"l_shipdate\",\"l_commitdate\",\"l_rece"..., seqServerHost=0x0, seqServerPort=-1) at postgres.c:1742
      #12 0x00000000008e3b44 in PostgresMain (argc=4, argv=0x2d38e60, username=0x2d38de0 "gpadmin") at postgres.c:4840
      #13 0x000000000088d9eb in BackendRun (port=0x2d0a5f0) at postmaster.c:5915
      #14 0x000000000088ce0a in BackendStartup (port=0x2d0a5f0) at postmaster.c:5484
      #15 0x0000000000886e86 in ServerLoop () at postmaster.c:2163
      #16 0x0000000000885e93 in PostmasterMain (argc=9, argv=0x2d13010) at postmaster.c:1454
      #17 0x00000000007a3097 in main (argc=9, argv=0x2d13010) at main.c:226
      (gdb)

      Attachments

        1. config_file
          5 kB
          Xiang Sheng
        2. create.sql
          0.7 kB
          Xiang Sheng
        3. lineitem.tbl.small
          0.1 kB
          Xiang Sheng

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            xsheng Xiang Sheng
            xsheng Xiang Sheng
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment