The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
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)Stopped Db and retried after restart but always get this error.
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
0
Comments
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
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
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
there is no epoch or epoch-like column in the table nor in the query.
The queries used to tune the projections are: Allan
Should I open a service ticket with Vertica?