Options

INTERNAL 3591: Internal EE Error (11)

voltairevoltaire
in General Discussion

I am facing the error below when I run the query (in vsql for example) with dbadmin or normal user.

INTERNAL 3591:  Internal EE Error (11)

DETAIL:  aggs[i].itype.typmod == aggs[i].otype.typmod

HINT:  Please report this error to Vertica; try restating your query

 

Running on vertica Build 7.2.1-0.

 

Query:

SELECT "main"."COUNTRYCLEAN" AS "countryclean", ((1 - (1 - (CASE WHEN SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'N') THEN (CASE WHEN TRUE THEN "main"."booking_base" ELSE 0 END) ELSE NULL END)) = 0 THEN NULL ELSE CAST(SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'Y') THEN 0 ELSE "main"."BOOKING_NET" END)) AS DOUBLE PRECISION) / SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'N') THEN (CASE WHEN TRUE THEN "main"."booking_base" ELSE 0 END) ELSE NULL END)) END))) * (CASE WHEN SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'Y') THEN 0 ELSE "main"."BOOKING_NET" END)) = 0 THEN NULL ELSE CAST(SUM(((CASE WHEN ("main"."SERVICE_INDICATOR" = 'Y') THEN 0 ELSE "main"."BOOKING_NET" END) - (CASE WHEN ("main"."SERVICE_INDICATOR" = 'N') THEN (CASE WHEN TRUE THEN "main"."STDCOST" ELSE 0 END) ELSE NULL END))) AS DOUBLE PRECISION) / SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'Y') THEN 0 ELSE "main"."BOOKING_NET" END)) END)) AS "usr_calculation_0770731101349693_ok" FROM "public"."t_bok_all_2v2_RR_B0" "main" WHERE (((((FALSE AND TRUE) OR ((NOT FALSE) AND ("main"."SALES_LEVEL_1" = 'EMEAR-REGION'))) AND (("main"."fy_finance" >= 2014) AND ((FALSE AND ("main"."fy_business" >= 2014)) OR ((NOT FALSE) AND TRUE))) AND (NOT ((TRUE AND FALSE) OR ((NOT TRUE) AND ((('jxxxxx' || '-') || 'xxxx') IS NULL)))) AND (((CURRENT_DATE >= CAST('2015-12-11' AS DATE)) OR ("main"."CALENDARDATEOP_ORIGIN" < CAST('2015-10-17' AS DATE))) OR ((TRUE AND TRUE) OR ((NOT TRUE) AND FALSE)))) AND (NOT ((CASE WHEN TRUE THEN "main"."SALES_LEVEL_2" WHEN NOT TRUE THEN "main"."SALES_LEVEL_2_legacy" ELSE NULL END) = 'EMEAR-Other-SL2'))) AND FALSE) GROUP BY 1;

Comments

  • Options
    SruthiASruthiA Vertica Employee Administrator

    Hi,

     

         How many tables are present in the query? Are these joined cyclically?

     

     

    Thank you,

    Sruthi

  • Options
    voltairevoltaire

    Hi Sruthi,

     

    Not sure I understand the question.

    The from table clause references a projection linked to 1 table (not aggregated projections). The Table is 100 millions of rows.

    Let me know if you need anything else,

     

    Stephane

    btw: it seems the last version of vertica is not yet available for download on the website (7.2.1-2)?

  • Options
    SruthiASruthiA Vertica Employee Administrator

    Hi,

     

       Can you share me vertica.log present in the catalog directory of the database after query runs and errors out. 

     

     

     

    Thank you,

    Sruthi

  • Options
    voltairevoltaire

    Hi,

     

    The file is a bit big, see below the main section:

     

    2016-02-01 03:45:11.546 Init Session:0x7f6f30014d60-b0000000250507 [Txn] <INFO> Begin Txn: b0000000250507 'check_login_history'
    2016-02-01 03:45:11.546 Init Session:0x7f6f30014d60-b0000000250507 [Txn] <INFO> Rollback Txn: b0000000250507 'check_login_history'
    2016-02-01 03:45:11.546 Init Session:0x7f6f30014d60 <LOG> @v_tableau_node0002: 00000/4686: Authentication - sendAuthRequest: user=dbadmin database=dbadmin host=127.0.0.1 authType=0
    2016-02-01 03:45:11.546 Init Session:0x7f6f30014d60 <LOG> @v_tableau_node0002: 00000/2703: Connection authenticated: user=dbadmin database=dbadmin host=127.0.0.1
    2016-02-01 03:45:11.546 Init Session:0x7f6f30014d60 <LOG> @v_tableau_node0002: 00000/2609: Client pid: 10571
    2016-02-01 03:45:13.591 Init Session:0x7f6f30014d60 [Session] <INFO> [Query] TX:0(vm-part-um3-009-26302:0xaa5e0) SELECT "main"."COUNTRYCLEAN" AS "countryclean", ((1 - (1 - (CASE WHEN SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'N') THEN (CASE WHEN TRUE THEN "main"."booking_base" ELSE 0 END) ELSE NULL END)) = 0 THEN NULL ELSE CAST(SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'Y') THEN 0 ELSE "main"."BOOKING_NET" END)) AS DOUBLE PRECISION) / SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'N') THEN (CASE WHEN TRUE THEN "main"."booking_base" ELSE 0 END) ELSE NULL END)) END))) * (CASE WHEN SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'Y') THEN 0 ELSE "main"."BOOKING_NET" END)) = 0 THEN NULL ELSE CAST(SUM(((CASE WHEN ("main"."SERVICE_INDICATOR" = 'Y') THEN 0 ELSE "main"."BOOKING_NET" END) - (CASE WHEN ("main"."SERVICE_INDICATOR" = 'N') THEN (CASE WHEN TRUE THEN "main"."STDCOST" ELSE 0 END) ELSE NULL END))) AS DOUBLE PRECISION) / SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'Y') THEN 0 ELSE "main"."BOOKING_NET" END)) END)) AS "usr_calculation_0770731101349693_ok" FROM "public"."t_bok_all_2v2_RR_B0" "main" WHERE (((((FALSE AND TRUE) OR ((NOT FALSE) AND ("main"."SALES_LEVEL_1" = 'EMEAR-REGION'))) AND (("main"."fy_finance" >= 2014) AND ((FALSE AND ("main"."fy_business" >= 2014)) OR ((NOT FALSE) AND TRUE))) AND (NOT ((TRUE AND FALSE) OR ((NOT TRUE) AND ((('jxxxxx' || '-') || 'xxxx') IS NULL)))) AND (((CURRENT_DATE >= CAST('2015-12-11' AS DATE)) OR ("main"."CALENDARDATEOP_ORIGIN" < CAST('2015-10-17' AS DATE))) OR ((TRUE AND TRUE) OR ((NOT TRUE) AND FALSE)))) AND (NOT ((CASE WHEN TRUE THEN "main"."SALES_LEVEL_2" WHEN NOT TRUE THEN "main"."SALES_LEVEL_2_legacy" ELSE NULL END) = 'EMEAR-Other-SL2'))) AND FALSE) GROUP BY 1;
    2016-02-01 03:45:13.596 Init Session:0x7f6f30014d60-b0000000250508 [Txn] <INFO> Begin Txn: b0000000250508 'SELECT "main"."COUNTRYCLEAN" AS "countryclean", ((1 - (1 - (CASE WHEN SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'N') THEN (CASE WHEN TRUE THEN "main"."booking_base" ELSE 0 END) ELSE NULL END)) = 0 THEN NULL ELSE CAST(SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'Y') THEN 0 ELSE "main"."BOOKING_NET" END)) AS DOUBLE PRECISION) / SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'N') THEN (CASE WHEN TRUE THEN "main"."booking_base" ELSE 0 END) ELSE NULL END)) END))) * (CASE WHEN SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'Y') THEN 0 ELSE "main"."BOOKING_NET" END)) = 0 THEN NULL ELSE CAST(SUM(((CASE WHEN ("main"."SERVICE_INDICATOR" = 'Y') THEN 0 ELSE "main"."BOOKING_NET" END) - (CASE WHEN ("main"."SERVICE_INDICATOR" = 'N') THEN (CASE WHEN TRUE THEN "main"."STDCOST" ELSE 0 END) ELSE NULL END))) AS DOUBLE PRECISION) / SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'Y') THEN 0 ELSE "main"."BOOKING_NET" END)) END)) AS "usr_calculation_0770731101349693_ok" FROM "public"."t_bok_all_2v2_RR_B0" "main" WHERE (((((FALSE AND TRUE) OR ((NOT FALSE) AND ("main"."SALES_LEVEL_1" = 'EMEAR-REGION'))) AND (("main"."fy_finance" >= 2014) AND ((FALSE AND ("main"."fy_business" >= 2014)) OR ((NOT FALSE) AND TRUE))) AND (NOT ((TRUE AND FALSE) OR ((NOT TRUE) AND ((('jxxxxx' || '-') || 'xxxx') IS NULL)))) AND (((CURRENT_DATE >= CAST('2015-12-11' AS DATE)) OR ("main"."CALENDARDATEOP_ORIGIN" < CAST('2015-10-17' AS DATE))) OR ((TRUE AND TRUE) OR ((NOT TRUE) AND FALSE)))) AND (NOT ((CASE WHEN TRUE THEN "main"."SALES_LEVEL_2" WHEN NOT TRUE THEN "main"."SALES_LEVEL_2_legacy" ELSE NULL END) = 'EMEAR-Other-SL2'))) AND FALSE) GROUP BY 1;'
    2016-02-01 03:45:13.634 Init Session:0x7f6f30014d60-b0000000250508 [EE] <WARNING> Vertica Internal Error 12 'aggs[i].itype.typmod == aggs[i].otype.typmod'
    2016-02-01 03:45:13.634 Init Session:0x7f6f30014d60-b0000000250508 <INTERNAL> @v_tableau_node0002: VX001/3591: Internal EE Error (11)
    DETAIL: aggs[i].itype.typmod == aggs[i].otype.typmod
    HINT: Please report this error to Vertica; try restating your query
    LOCATION: open, /scratch_a/release/24526/vbuild/vertica/EE/Processing/GroupBy.cpp:267
    2016-02-01 03:45:13.659 Init Session:0x7f6f30014d60-b0000000250508 [EE] <INFO> Thread pool exited. Max Requested 2, peak 0, created 0, removed 0
    2016-02-01 03:45:13.680 Init Session:0x7f6f30014d60-b0000000250508 <INTERNAL> @v_tableau_node0002: VX001/3591: Internal EE Error (11)
    DETAIL: aggs[i].itype.typmod == aggs[i].otype.typmod
    HINT: Please report this error to Vertica; try restating your query
    LOCATION: open, /scratch_a/release/24526/vbuild/vertica/EE/Processing/GroupBy.cpp:267
    2016-02-01 03:45:13.681 Init Session:0x7f6f30014d60-b0000000250508 [Txn] <INFO> Rollback Txn: b0000000250508 'SELECT "main"."COUNTRYCLEAN" AS "countryclean", ((1 - (1 - (CASE WHEN SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'N') THEN (CASE WHEN TRUE THEN "main"."booking_base" ELSE 0 END) ELSE NULL END)) = 0 THEN NULL ELSE CAST(SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'Y') THEN 0 ELSE "main"."BOOKING_NET" END)) AS DOUBLE PRECISION) / SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'N') THEN (CASE WHEN TRUE THEN "main"."booking_base" ELSE 0 END) ELSE NULL END)) END))) * (CASE WHEN SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'Y') THEN 0 ELSE "main"."BOOKING_NET" END)) = 0 THEN NULL ELSE CAST(SUM(((CASE WHEN ("main"."SERVICE_INDICATOR" = 'Y') THEN 0 ELSE "main"."BOOKING_NET" END) - (CASE WHEN ("main"."SERVICE_INDICATOR" = 'N') THEN (CASE WHEN TRUE THEN "main"."STDCOST" ELSE 0 END) ELSE NULL END))) AS DOUBLE PRECISION) / SUM((CASE WHEN ("main"."SERVICE_INDICATOR" = 'Y') THEN 0 ELSE "main"."BOOKING_NET" END)) END)) AS "usr_calculation_0770731101349693_ok" FROM "public"."t_bok_all_2v2_RR_B0" "main" WHERE (((((FALSE AND TRUE) OR ((NOT FALSE) AND ("main"."SALES_LEVEL_1" = 'EMEAR-REGION'))) AND (("main"."fy_finance" >= 2014) AND ((FALSE AND ("main"."fy_business" >= 2014)) OR ((NOT FALSE) AND TRUE))) AND (NOT ((TRUE AND FALSE) OR ((NOT TRUE) AND ((('jxxxxx' || '-') || 'xxxx') IS NULL)))) AND (((CURRENT_DATE >= CAST('2015-12-11' AS DATE)) OR ("main"."CALENDARDATEOP_ORIGIN" < CAST('2015-10-17' AS DATE))) OR ((TRUE AND TRUE) OR ((NOT TRUE) AND FALSE)))) AND (NOT ((CASE WHEN TRUE THEN "main"."SALES_LEVEL_2" WHEN NOT TRUE THEN "main"."SALES_LEVEL_2_legacy" ELSE NULL END) = 'EMEAR-Other-SL2'))) AND FALSE) GROUP BY 1;'
    2016-02-01 03:45:15.004 LGELaggingCheck:0x7f6f34008400-b000000025050a [Txn] <INFO> Begin Txn: b000000025050a 'Recovery: Get last good epoch'
    2016-02-01 03:45:15.008 LGELaggingCheck:0x7f6f34008400-b000000025050a [Catalog] <INFO> Found 0 missing DFS files
    2016-02-01 03:45:15.008 LGELaggingCheck:0x7f6f34008400-b000000025050a [Txn] <INFO> Starting Commit: Txn: b000000025050a 'Recovery: Get last good epoch'
    2016-02-01 03:45:15.009 LGELaggingCheck:0x7f6f34008400 [Txn] <INFO> Commit Complete: Txn: b000000025050a at epoch 0xbdc
    2016-02-01 03:45:15.009 RebalanceCluster:0x7f6f3400bae0 [Util] <INFO> Task 'RebalanceCluster' enabled
    2016-02-01 03:45:15.010 LGELaggingCheck:0x7f6f34008400-b000000025050b [Txn] <INFO> Begin Txn: b000000025050b 'Check LGE'
    2016-02-01 03:45:15.010 LGELaggingCheck:0x7f6f34008400-b000000025050b [Txn] <INFO> Rollback Txn: b000000025050b 'Check LGE'
    2016-02-01 03:45:15.010 LGELaggingCheck:0x7f6f34008400 [Util] <INFO> Task 'LGELaggingCheck' enabled
    2016-02-01 03:45:16.003 DiskSpaceRefresher:0x7f6f34007c20 [Util] <INFO> Task 'DiskSpaceRefresher' enabled
    2016-02-01 03:45:16.990 Init Session:0x7f6f30014d60 <LOG> @v_tableau_node0002: 00000/4719: Session vm-part-um3-009-26302:0xaa5e0 ended; closing connection (connCnt 9)
    2016-02-01 03:45:26.000 DiskSpaceRefresher:0x7f6f34008c90 [Util] <INFO> Task 'DiskSpaceRefresher' enabled
    2016-02-01 03:45:27.002 TM Mergeout(00):0x7f6f34008400-b000000025050c [Txn] <INFO> Begin Txn: b000000025050c 'Mergeout: Tuple Mover'
    2016-02-01 03:45:27.097 TM Mergeout(00):0x7f6f34008400-b000000025050c [TM] <INFO> Tuple Mover: nothing to merge out
    2016-02-01 03:45:27.122 TM Mergeout(00):0x7f6f34008400-b000000025050c [TM] <INFO> Tuple Mover: no DV to merge out
    2016-02-01 03:45:27.122 TM Mergeout(00):0x7f6f34008400-b000000025050c [Txn] <INFO> Rollback Txn: b000000025050c 'Mergeout: Tuple Mover'
    2016-02-01 03:45:27.123 TM Mergeout(00):0x7f6f34008400-b000000025050d [Txn] <INFO> Begin Txn: b000000025050d 'collectMoveStorageJobs'
    2016-02-01 03:45:27.138 TM Mergeout(00):0x7f6f34008400-b000000025050d [Txn] <INFO> Rollback Txn: b000000025050d 'collectMoveStorageJobs'
    2016-02-01 03:45:27.139 TM Mergeout(00):0x7f6f34008400 [Util] <INFO> Task 'TM Mergeout(00)' enabled

     

    Hope that helps,

    Stephane

  • Options
    voltairevoltaire

    It seems a new version of Vertica has just been pulished (7.2.1-3) that may solve this issue, see: http://my.vertica.com/docs/ReleaseNotes/7.2.x/Vertica_7.2.x_Release_Notes.htm#7.2.1-3

     

    Could you confirm on your side? I am unable to download it (only 7.2.1-0 is available for now), but if you share a link, I can confirm for you?

     

    Thanks,

    Stephane

  • Options
    Rahul_ChoudharyRahul_Choudhary

    Hi Stephene

     

    This issue is not fixed in the version that you have mentioned.Instead it will be fixed in 7.2 SP2 version. So please wait until it is released.

     

    Just wanted to check are you a valid customer or vertica? If yes you will be notified about any latest hot-fix releases.

     

    Also in future if faces any such issues and if you hold a valid support license request you to raise a support case with Vertica support.

     

    Regards

    Rahul

  • Options
    voltairevoltaire

    Hi Rahul,

     

    We do use the community edition; but we are happy to test beta version if you are willing to share :)

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...