Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

DBDesigner error 12

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.

Comments

  • 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
  • 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
  • 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
  • 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

  • Is there anything else I should try?

    Should I open a service ticket with Vertica?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.