DBDesigner error 12

Allan_Cochrane_1

Trying to run DBD on a schema and I get this error in vertica.log:

2014-09-24 13:24:40.817 InternalStmt:0x2b37000611a0 [Txn] <INFO> Commit Complete: Txn: a0000000fcfe83 at epoch 0x1d00f92014-09-24 13:24:40.851 Init Session:0x2b36b0032870 <LOG> @v_brodie_ac_node0001: 00000/2705: Connection received: host=127.0.0.1 port=54939 (connCnt 3)
2014-09-24 13:24:40.851 Init Session:0x2b36b0032870 <LOG> @v_brodie_ac_node0001: 00000/4540: Received SSL negotiation startup packet
2014-09-24 13:24:40.851 Init Session:0x2b36b0032870 <LOG> @v_brodie_ac_node0001: 00000/4691: Sending SSL negotiation response 'N'
2014-09-24 13:24:40.851 Init Session:0x2b36b0032870 <LOG> @v_brodie_ac_node0001: 00000/4686: Authentication - sendAuthRequest: user=dbadmin database=brodie_ac host=127.0.0.1 authType=3
2014-09-24 13:24:40.851 Init Session:0x2b36b0032870-a0000000fcfe85 [Txn] <INFO> Begin Txn: a0000000fcfe85 'check_login_history'
2014-09-24 13:24:40.851 Init Session:0x2b36b0032870-a0000000fcfe85 [Txn] <INFO> Rollback Txn: a0000000fcfe85 'check_login_history'
2014-09-24 13:24:40.851 Init Session:0x2b36b0032870 <LOG> @v_brodie_ac_node0001: 00000/4686: Authentication - sendAuthRequest: user=dbadmin database=brodie_ac host=127.0.0.1 authType=0
2014-09-24 13:24:40.851 Init Session:0x2b36b0032870 <LOG> @v_brodie_ac_node0001: 00000/2703: Connection authenticated: user=dbadmin database=brodie_ac host=127.0.0.1
2014-09-24 13:24:40.851 Init Session:0x2b36b0032870 <LOG> @v_brodie_ac_node0001: 00000/2609: Client pid: 30263
2014-09-24 13:24:40.953 Init Session:0x2b36b0032870 [Session] <INFO> [Query] TX:0(u200940-lin-1988:0xfee) SET search_path=brodie_varys,public;
2014-09-24 13:24:41.055 Init Session:0x2b36b0032870 [Session] <INFO> [Query] TX:0(u200940-lin-1988:0xfee) select a.* from "v_dbd_varys_varys".output_event_history_report as a, "v_dbd_varys_varys".current_event as b where a.time_stamp = b.time_stamp;
2014-09-24 13:24:41.056 Init Session:0x2b36b0032870-a0000000fcfe86 [Txn] <INFO> Begin Txn: a0000000fcfe86 'select a.* from "v_dbd_varys_varys".output_event_history_report as a, "v_dbd_varys_varys".current_event as b where a.time_stamp = b.time_stamp;'
2014-09-24 13:24:41.280 Init Session:0x2b36b0032870-a0000000fcfe86 <LOG> @v_brodie_ac_node0001: 00000/4719: Session u200940-lin-1988:0xfee ended; closing connection (connCnt 3)
2014-09-24 13:24:41.281 Init Session:0x2b36b0032870-a0000000fcfe86 [Txn] <INFO> Rollback Txn: a0000000fcfe86 'select a.* from "v_dbd_varys_varys".output_event_history_report as a, "v_dbd_varys_varys".current_event as b where a.time_stamp = b.time_stamp;'
2014-09-24 13:24:42.216 D4_Design:0x145cdde0 [Designer] <WARNING> <const DBD::D4_SortOrder* DBD:lithiumrleExtendSO(const DBD::D4_DesignTable&, const DBD::D4_SortOrder*, const DBD::D4_Extender*, const DBD::D4_StatsMgr*)> Vertica Internal Error 12 'isRleF'
2014-09-24 13:24:42.216 D4_Design:0x145cdde0 <INTERNAL> @v_brodie_ac_node0001: VX001/3590: Internal DBDesigner Error (12)
        DETAIL:  isRleF
        HINT:  Please report this error to Vertica
        LOCATION:  _rleExtendSO, /scratch_a/release/vbuild/vertica/DBDesigner/D4_SOEnumerator.cpp:331
2014-09-24 13:24:42.216 D4_Design:0x145cdde0 [Designer] <WARNING> <void DBD::D4_Design::Task::run()> Handling exception during background design: Internal DBDesigner Error (12) DETAIL: isRleF
2014-09-24 13:24:42.216 D4_Design:0x145cdde0 [Designer] <INFO> <void DBD:lithiumaddToLogInfo(const DBD::D4_TableRow&, const char*)> addDesignProgressErrorWarningEvent: 2014-09-24 13:24:42.216|45035996290284591|varys|Error during design||||-1|-1|Design did not complete successfully.  ERROR - Internal DBDesigner Error (12)
 DETAIL:isRleF
2014-09-24 13:24:42.216 D4_Design:0x145cdde0 [Designer] <INFO> <void DBD::D4_InternalStmt:lithiumexecStmt(const Session::InternalQueryTemplate&, Session::TupleStoreResultSet*, const char*)> Statement to execute is: COPY v_dbd_varys_varys.vs_output_event_history  FROM STDIN DELIMITER '|' RECORD TERMINATOR ' NULL '' ;
2014-09-24 13:24:42.218 InternalStmt:0x2b35449000c0-a0000000fcfe88 [Txn] <INFO> Begin Txn: a0000000fcfe88 'COPY v_dbd_varys_varys.vs_output_event_history  FROM STDIN DELIMITER '|' RECORD TERMINATOR ' NULL '' ;'
2014-09-24 13:24:42.219 InternalStmt:0x2b35449000c0-a0000000fcfe88 <LOG> @v_brodie_ac_node0001: 00000/5771: Cannot getting Non-SelectPath ID because the Input Path of the Select Path is NULL
2014-09-24 13:24:42.221 InternalStmt:0x2b35449000c0-a0000000fcfe88 [LocalPlanner] <INFO> finalizeThreadsToUseForLoad(): max_threads_allowed = 8, numSources = 1

Stopped Db and retried after restart but always get this error.

Rahul_Choudhary

Hi Allan

Can you kindly let us know what's your db/cluster version?
When a query reference an epoch column it causes this internal error in DBD. 
Will suggest you to remove the epoch column from the query & try re-running DBD once again.


Regards
Rahul Choudhary

Allan_Cochrane_1

Hi,

version = v7.1.0-1

Can you give me an idea of what an epoch column might be please? I suspect it's a timestamp like column but could you confirm that please?

Thanks for your help.

Allan

Rahul_Choudhary

Hi 

Epoch represents a unique point in time of the data in vertica.Also every row has an explicity stored column.

For eg;

dbadmin=> select epoch, c1, c2, count(*) from test group by epoch, 2, 3; 
epoch | c1 | c2 | count 
-------+----+----+------- 
621 | 1 | 2 | 2 
622 | 3 | 3 | 3 
622 | 3 | 2 | 1 
623 | 1 | 2 | 2 
622 | 2 | 2 | 1 

Regards
Rahul Choudhary

Allan_Cochrane_1

Hi,

there is no epoch or epoch-like column in the table nor in the query.

The queries used to tune the projections are:

SELECT SUM(dut_error_count) AS dut_error_count, COUNT(DISTINCT test_revision) AS test_revision, COUNT(DISTINCT simulator) AS simulator, SUM(dut_warning_count) AS dut_warning_count, SUM(testbench_error_count) AS testbench_error_count, SUM(testbench_warning_count) AS testbench_warning_count, COUNT(DISTINCT test_name) AS test_name, COUNT(DISTINCT test_suite) AS test_suite, COUNT(DISTINCT status) AS status, COUNT(DISTINCT test_configuration) AS test_configuration, COUNT(DISTINCT seed) AS seed, SUM(cycles) AS cycles, SUM(run_time) AS run_time, COUNT(DISTINCT fail_region) AS fail_region, COUNT(DISTINCT signature_id) AS signature_id, COUNT(DISTINCT fail_signature) AS fail_signature, COUNT(DISTINCT bug_id) AS bug_id, COUNT(DISTINCT signature_version) AS signature_version, SUM(transaction_count) AS transaction_count, SUM(test_cycles) AS test_cycles FROM project_results WHERE ( ( ignore_result = false AND revision_fk IN ( 3665000046 ) ) );  
SELECT CONCAT('PROJ/',TO_CHAR(created_at, 'YYYY/MM/DD')) AS mongo_collection_name, dut_error_count AS dut_error_count, test_revision AS test_revision, simulator AS simulator, dut_warning_count AS dut_warning_count, testbench_error_count AS testbench_error_count, testbench_warning_count AS testbench_warning_count, test_name AS test_name, test_suite AS test_suite, status AS status, test_configuration AS test_configuration, seed AS seed, cycles AS cycles, run_time AS run_time, fail_region AS fail_region, signature_id AS signature_id, fail_signature AS fail_signature, bug_id AS bug_id, signature_version AS signature_version, transaction_count AS transaction_count, test_cycles AS test_cycles, throughput AS throughput, mem_use AS mem_use, job_tag AS job_tag, submit_time AS submit_time, start_time AS start_time, command AS command, end_time AS end_time, comments AS comments, exit_status AS exit_status, exec_hosts AS exec_hosts, cwd AS cwd, cpu_time AS cpu_time, updated_at AS updated_at, created_at AS created_at, inserted_by AS inserted_by, job_tag AS job_tag, submit_time AS submit_time, start_time AS start_time, command AS command, end_time AS end_time, comments AS comments, exit_status AS exit_status, exec_hosts AS exec_hosts, cwd AS cwd, cpu_time AS cpu_time, updated_at AS updated_at, created_at AS created_at, inserted_by AS inserted_by, inserted_by AS inserted_by, project_result_id AS project_result_id, project_result_uuid AS project_result_uuid, revision_fk AS revision_fk, created_at AS created_at, updated_at AS updated_at FROM project_results WHERE ( ( ignore_result = false AND revision_fk IN ( 3665000046 ) ) ) ORDER BY project_result_id ASC, project_result_id ASC LIMIT 5 OFFSET 0;

Allan

Allan_Cochrane_1

Is there anything else I should try?

Should I open a service ticket with Vertica?