trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Suresh Subbiah <suresh.subbia...@gmail.com>
Subject Re: HammerDB issues
Date Fri, 11 Sep 2015 15:38:11 GMT
Hi Radu,

Thanks for trying this out.

I think what is happening here is that the jar file did not get pushed to
all the nodes. HammerDB has so far been tested on single node instances or
multiple nodes where we did some intermediate steps manually. I don't think
HammerDB uses pdsh to push the jar file to all nodes, or maybe pdsh is
somehow not available. Could you please check if the jar file is available
from every node in the cluster? If this does turn out to be the problem, I
promise to add more info about HammerDB in the Trafodion wiki and mention a
workaround for these issues.

For the Failed To Create Index issue, is there an error message? IF not we
can take the create index statement HammerDB is using and issue it from
sqlci. I think thisis the DDL that is used.

CREATE UNIQUE INDEX CUSTOMER_I2 ON CUSTOMER (C_W_ID, C_D_ID, C_LAST,
C_FIRST, C_ID) ;
CREATE UNIQUE INDEX ORDERS_I2 ON ORDERS (O_W_ID, O_D_ID, O_C_ID, O_ID) ;

Thanks
Suresh



On Fri, Sep 11, 2015 at 9:27 AM, Radu Marias <radumarias@gmail.com> wrote:

> Hi,
>
> I'm trying to run HammerDB TPC-C from this tutorial
> http://hammerora.sourceforge.net/hammerdb_quickstart_trafodion.pdf
>
> I have this environment:
>
>
> *CentOS release 6.7 (Final)*
> *Ambari 2.1.1*
> *HDP 2.2*
> *trafodion-20150828_0830*
>
> *HammerDB-2.18*
>
> *java version "1.7.0_79"*
>
> On *Schema Build* I get errors when stored procedures are created.
>
> *This is from the hammerdb logs:*
>
> Vuser 1:CREATING TPCC STORED PROCEDURES
> Vuser 1:Failed to create library /home/trafodion/HammerDB-2.18/NEWORDER.jar
>
> *This is what I see in the UI (attached is also a screenshot):*
>
> loading history file ... 0 events added
> Main console display active (Tcl8.6.0 / Tk8.6.0)
> The xml in config.xml is well-formed, applying variables
> Error in Virtual User 1: [Trafodion ODBC Driver][Trafodion Database] SQL
> ERROR:*** ERROR[1382] JAR or DLL file
> /home/trafodion/HammerDB-2.18/NEWORDER.jar not found. [2015-09-11
> 07:50:53]À€ç¿™À€éŽˆç»„ç¿™À€éŽ„组翙À€éŽ€ç»„ç¿™À€é
组翙À€é
> 组翙À€éŒ¸ç»„ç¿™À€å ¦è šç¿™À€ìªˆÊŒÀ€À€ì¹°Ê‰À€À€é
> 组翙À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€Õ€Ë®À€À€ìŸ
> Ì…À€À€À€À€À€À€À€À€À€À€ï¿¿ï¿¿À€À€ì« ï¿¿
À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€À€é
> °À€À€À€ì² ʉÀ€À€îˆ°Ò»À€À€éŸ¼ç« ç¿™À€ë¾°Ç´À€À€å–€Ò
À€À€ç½ Ë—À€À€ì²
> ʉÀ€À€é’€ç»„ç¿™À€ã µç« ç¿™À€é‘ 组翙À€ìµ
ʉÀ€À€é °ç»„
> (executing the statement)
> (HammerDB-2.18) 1 %
>
> By looking in the tpcc schema I see some tables are created and are
> populated with data:
>
> >>set schema tpcc;
>
> --- SQL operation complete.
> >>get tables;
>
> Tables in Schema TRAFODION.TPCC
> ===============================
>
> CUSTOMER
> DISTRICT
> HISTORY
> ITEM
> NEW_ORDER
> ORDERS
> ORDER_LINE
> STOCK
> WAREHOUSE
>
> The file '*/home/trafodion/HammerDB-2.18/NEWORDER.jar*' exists, attached
> is the NEWORDER.java
>
> *When trying to create the stored procedure from sqlci I get this:*
>
> set schema tpcc;
> create library testrs file '/home/trafodion/HammerDB-2.18/NEWORDER.jar';
> create procedure NEWORD()
>        language java
>        parameter style java
>        external name 'NEWORDER.NEWORD'
>        dynamic result sets 1
>        library testrs;
>
> *** ERROR[11239] No compatible Java methods named 'NEWORD' were found in
> Java class 'NEWORDER'.
>
> *** ERROR[1231] User-defined routine TRAFODION.TPCC.NEWORDER could not be
> created.
>
> Is there an API change on methods for stored procedures in the latest
> trafodion and hammerdb uses the older syntax? This is the method:
>
> public static void NEWORD (int no_w_id, int no_max_w_id, int no_d_id, int
> no_c_id, int no_o_ol_cnt, BigDecimal[] no_c_discount, String[] no_c_last,
> String[] no_c_credit, BigDecimal[] no_d_tax, BigDecimal[] no_w_tax, int[]
> no_d_next_o_id, Timestamp tstamp, ResultSet[] opres)
> throws SQLException
>
> Also If I disable "*Build Java Stored Procedures Locally*" from hammerdb
> I  get:
>
> Vuser 1:CREATING TPCC INDEXES
> Vuser 1:Creating Index CUSTOMER_I2...
> Vuser 1:Failed to Create Index
>
> --
> And in the end, it's not the years in your life that count. It's the life
> in your years.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message