INTERNAL 3591: Internal EE Error (11)

Hi,

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

Thank you,

Sruthi

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)?

Hi,

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

Thank you,

Sruthi

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

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

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

Hi Rahul,

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