Hi there- You need to have HBase version of 1.0+.
Thanks. Amanda Sent from my iPhone > On Oct 30, 2016, at 11:22 AM, samuel.lepetre <[email protected]> > wrote: > > Hi > > Now I'm facing problem while trying to 'initialize trafodion': > NoSuchMethodError. Seems that I'm not using a right version of trafodion. > Strange because I'm using > > - Ubuntu *16.04* (Linux ubuntu-1 4.4.0-45-generic x86_64 GNU/Linux) > > - Hadoop *2.7.1* > > - HBase *0.98.23*-hadoop2 > > - Trafodion Release *2.0.1 *(Trafodion Connectivity Services : version 1.0.0) > > ------------------------------------------------------------------------------------------------------------------------------------------ > > Process Configured Actual Down > ------- ---------- ------ ---- > DTM 1 1 > RMS 2 2 > DcsMaster 1 1 > DcsServer 1 1 > mxosrvr 8 8 > > trafodion@ubuntu-1:~/apache-trafodion_server-2.0.1-incubating/sql/scripts$ > trafodion@ubuntu-1:~/apache-trafodion_server-2.0.1-incubating/sql/scripts$ > trafodion@ubuntu-1:~/apache-trafodion_server-2.0.1-incubating/sql/scripts$ > trafodion@ubuntu-1:~/apache-trafodion_server-2.0.1-incubating/sql/scripts$ > sqlci > Apache Trafodion Conversational Interface 2.0.1 > Copyright (c) 2015-2016 Apache Software Foundation > >>initialize trafodion; > > *** ERROR[8448] Unable to access Hbase interface. Call to > ExpHbaseInterface::create() returned error HBASE_CREATE_ERROR(701). Cause: > java.lang.NoSuchMethodError: > org.apache.hadoop.hbase.HTableDescriptor.addCoprocessor(Ljava/lang/String;)Lorg/apache/hadoop/hbase/HTableDescriptor; > org.trafodion.sql.CoprocessorUtils.addCoprocessor(CoprocessorUtils.java:71) > org.trafodion.sql.HBaseClient.createk(HBaseClient.java:491) > . > > --- SQL operation failed with errors. > >> > > Do you have an idea ? > > Regards > > samuel > > >> Le 18/10/2016 à 23:16, Samuel LEPETRE a écrit : >> >> That's ok if I set /etc/default/local to en_US then it starts: >> >> trafodion@ubuntu-1:~/apache-trafodion_server-2.0.1-incubating/sql/scripts$ >> trafci >> >> Welcome to Apache Trafodion Command Interface >> Copyright (c) 2015-2016 Apache Software Foundation >> >> Host Name/IP Address: ubuntu-1:23400 >> User Name: trafodion >> >> Connected to Trafodion >> >> SQL> >> >> >> Sam >> >>> Le 18 octobre 2016 à 20:54, Samuel LEPETRE <[email protected]> a >>> écrit : >>> >>> Found something ;) sound like the DB does not like the french floating >>> system => '0.5' means in french '0,5' :( >>> >>> Not sure how to handle this... may be /etc/default/locale. Any ideas ? >>> >>> *** ERROR[2055] The specified value '0.5' for DEFAULTS attribute >>> ACCEPTABLE_INPUTESTLOGPROP_ERROR is not valid. [2016-10-18 20:47:14 >>> 2016-10-18 20:47:14,691, ERROR, MXOSRVR, Node Number: 0, CPU: 0, PIN:26588, >>> Process Name:$Z000LPN , , ,A SQL/MX query failed. SQLCODE: ODBC/MX Server. >>> Error Text: 4294965241. >>> *** ERROR[2055] The specified value '0.5' for DEFAULTS attribute >>> ACCEPTABLE_INPUTESTLOGPROP_ERROR is not valid. [2016-10-18 20:47:14 >>> 2016-10-18 20:47:14,691, ERROR, MXOSRVR, Node Number: 0, CPU: 0, PIN:26588, >>> Process Name:$Z000LPN , , ,A SQL/MX query failed. SQLCODE: ODBC/MX Server. >>> Error Text: 4294965241. >>> *** ERROR[2055] The specified value '0.5' for DEFAULTS attribute >>> ACCEPTABLE_INPUTESTLOGPROP_ERROR is not valid. [2016-10-18 20:47:14 >>> 2016-10-18 20:47:14,691, ERROR, MXOSRVR, Node Number: 0, CPU: 0, PIN:26588, >>> Process Name:$Z000LPN , , ,A SQL/MX query failed. SQLCODE: ODBC/MX Server. >>> Error Text: 4294965241. >>> *** ERROR[2055] The specified value '0.5' for DEFAULTS attribute >>> ACCEPTABLE_INPUTESTLOGPROP_ERROR is not valid. [2016-10-18 20:47:14 >>> 2016-10-18 20:47:14,691, ERROR, MXOSRVR, Node Number: 0, CPU: 0, PIN:26588, >>> Process Name:$Z000LPN , , ,A SQL/MX query failed. SQLCODE: ODBC/MX Server. >>> Error Text: 4294965241. >>> *** ERROR[2055] The specified value '1.0' for DEFAULTS attribute >>> HIST_JOIN_CARD_LOWBOUND is not valid. [2016-10-18 20:47:14 >>> 2016-10-18 20:47:14,691, ERROR, MXOSRVR, Node Number: 0, CPU: 0, PIN:26588, >>> Process Name:$Z000LPN , , ,A SQL/MX query failed. SQLCODE: ODBC/MX Server. >>> Error Text: 4294965241. >>> *** ERROR[2055] The specified value '1.0' for DEFAULTS attribute >>> HIST_JOIN_CARD_LOWBOUND is not valid. [2016-10-18 20:47:14 >>> 2016-10-18 20:47:14,691, ERROR, MXOSRVR, Node Number: 0, CPU: 0, PIN:26588, >>> Process Name:$Z000LPN , , ,A SQL/MX query failed. SQLCODE: ODBC/MX Server. >>> Error Text: 4294965241. >>> *** ERROR[2055] The specified value >>> 'defs_->getFloat(REFERENCE_CPU_FREQUENCY,referenceFrequency)' for DEFAULTS >>> attribute ../optimizer/opt.cpp is not valid. [2016-10-18 20:47:14 >>> 2016-10-18 20:47:14,691, ERROR, MXOSRVR, Node Number: 0, CPU: 0, PIN:26588, >>> Process Name:$Z000LPN , , ,A SQL/MX query failed. SQLCODE: ODBC/MX Server. >>> >>> >>>> Le 18 octobre 2016 à 20:29, Samuel LEPETRE <[email protected]> a >>>> écrit : >>>> >>>> Hi >>>> >>>> Have done fews things, for example in sqenv.sh and sqenvcom.sh, now I can >>>> see all processes: >>>> >>>> Zookeeper listen port: 2181 >>>> DcsMaster listen port: 23400 >>>> >>>> Configured Primary DcsMaster: "ubuntu-1" >>>> Active DcsMaster : "localhost", pid ubuntu-1: >>>> >>>> Process Configured Actual Down >>>> --------- ---------- ------ ---- >>>> DcsMaster 1 1 >>>> DcsServer 1 1 >>>> mxosrvr 8 8 >>>> >>>> >>>> Now I have another error 29157: >>>> >>>> trafodion@ubuntu-1:~/apache-trafodion_server-2.0.1-incubating/sql/scripts$ >>>> trafci >>>> >>>> Welcome to Apache Trafodion Command Interface >>>> Copyright (c) 2015-2016 Apache Software Foundation >>>> >>>> Host Name/IP Address: ubuntu-1:23400 >>>> User Name: trafodion >>>> >>>> *** ERROR[29157] There was a problem reading from the server >>>> >>>> >>>> *** ERROR[29157] There was a problem reading from the server >>>> >>>> >>>> *** ERROR[29157] There was a problem reading from the server >>>> >>>> Regards >>>> >>>> sam >>>> >>>>> Le 16 octobre 2016 à 00:50, Anuradha Hegde <[email protected]> a >>>>> écrit : >>>>> >>>>> >>>>> Looking at sqcheck output that is displayed below it looks like mxosrvrs >>>>> are >>>>> all down. So there were no servers in available state for clients(trafci) >>>>> to >>>>> connect. All the servers failed to start... >>>>> Can you check the error logs($MY_SQROOT/logs/master* and >>>>> $DCS_INSTALL_DIR/logs) for more information? >>>>> Using sqlci, are you not able to run any SQL commands? >>>>> >>>>> Anu >>>>> >>>>> -----Original Message----- >>>>> From: Elitelco [mailto:[email protected]] >>>>> Sent: Saturday, October 15, 2016 2:41 AM >>>>> To: [email protected] >>>>> Subject: Running trafodion on Ubuntu 16 >>>>> >>>>> >>>>> >>>>> >Hi >>>>> >we have installed trafodion on Ubuntu 16 distribution. >>>>> >After few modifications in scripts and librairies, trafodion DB seems to >>>>> >be >>>>> >up and running: >>>>> >----------------------------------------------------------------------- >>>>> >----------------------------------------------------------------------- >>>>> >------------- >>>>> >trafodion@ubuntu-1:~/apache-trafodion_server-2.0.1-incubating/sql/scrip >>>>> >ts$ ./sqstart Checking orphan processes. >>>>> >Removing old mpijob* files from >>>>> >/home/trafodion/apache-trafodion_server-2.0.1-incubating/tmp >>>>> >Removing old monitor.port* files from >>>>> >/home/trafodion/apache-trafodion_server-2.0.1-incubating/tmp >>>>> >Executing sqipcrm (output to sqipcrm.out) Starting the SQ Environment >>>>> >(Executing >>>>> >/home/trafodion/apache-trafodion_server-2.0.1-incubating/sql/scripts/go >>>>> >mon.cold) >>>>> >Background SQ Startup job (pid: 24645) >>>>> ># of SQ processes: 26 ......... >>>>> >SQ Startup script >>>>> >(/home/trafodion/apache-trafodion_server-2.0.1-incubating/sql/scripts/gomon.cold) >>>>> >ran successfully. Performing further checks... >>>>> >Checking if processes are up. >>>>> >Checking attempt: 1; user specified max: 2. Execution time in seconds: 0. >>>>> >The SQ environment is up! >>>>> >Process Configured Actual Down >>>>> >------- ---------- ------ ---- DTM 2 >>>>> >2 RMS 4 4 DcsMaster 1 1 >>>>> >DcsServer 1 1 mxosrvr 8 0 >>>>> >8 vendredi 14 octobre 2016, 16:36:28 (UTC+0200) Checking if processes >>>>> >are up. >>>>> >Checking attempt: 1; user specified max: 1. Execution time in seconds: 0. >>>>> >The SQ environment is up! >>>>> >Process Configured Actual Down >>>>> >------- ---------- ------ ---- DTM 2 >>>>> >2 RMS 4 4 DcsMaster 1 1 >>>>> >DcsServer 1 1 mxosrvr 8 0 >>>>> >8 Starting the DCS environment now master 20503. Stop it first. >>>>> >ubuntu-1: server 20915. Stop it first. >>>>> >Checking if processes are up. >>>>> >Checking attempt: 1; user specified max: 2. Execution time in seconds: 0. >>>>> >The SQ environment is up! >>>>> >Process Configured Actual Down >>>>> >------- ---------- ------ ---- DTM 2 >>>>> >2 RMS 4 4 DcsMaster 1 1 >>>>> >DcsServer 1 1 mxosrvr 8 0 >>>>> >8 Checking if processes are up. >>>>> >Checking attempt: 1; user specified max: 1. Execution time in seconds: 0. >>>>> >The SQ environment is up! >>>>> >Process Configured Actual Down >>>>> >------- ---------- ------ ---- DTM 2 >>>>> >2 RMS 4 4 DcsMaster 1 1 >>>>> >DcsServer 1 1 mxosrvr 8 0 >>>>> >8 Starting the REST environment now starting rest, logging to >>>>> >/home/trafodion/apache-trafodion_server-2.0.1-incubating/rest-2.0.1/bin >>>>> >/../logs/rest-trafodion-1-rest-ubuntu-1.out >>>>> >Zookeeper listen port: 2181 >>>>> >DcsMaster listen port: 23400 >>>>> >Configured Primary DcsMaster: "trafodion" >>>>> >Active DcsMaster : "localhost", pid 20503 Process >>>>> >Configured Actual Down >>>>> >--------- ---------- ------ ---- DcsMaster 1 >>>>> >1 DcsServer 1 1 mxosrvr 8 0 >>>>> >8 You can monitor the SQ shell log file : >>>>> >/home/trafodion/apache-trafodion_server-2.0.1-incubating/logs/sqmon.log >>>>> >Startup time 0 hour(s) 3 minute(s) 38 second(s) >>>>> >----------------------------------------------------------------------- >>>>> >----------------------------------------------------------------------- >>>>> >------------- However, when we launch trafci for testing DB, we have an >>>>> >error: >>>>> >trafodion@ubuntu-1:~$ trafci >>>>> >Welcome to Apache Trafodion Command Interface Copyright (c) 2015-2016 >>>>> >Apache Software Foundation Host Name/IP Address: trafodion:23400 User >>>>> >Name: trafodion >>>>> >*** ERROR[1] The message id: as_connect_message_error With parameters: >>>>> >server handle not available >>>>> >*** ERROR[1] The message id: as_connect_message_error With parameters: >>>>> >server handle not available >>>>> >*** ERROR[1] The message id: as_connect_message_error With parameters: >>>>> >server handle not available Can you please help ? >>>>> >By the way, 23400 port is listenning: >>>>> >trafodion@ubuntu-1:~/apache-trafodion_server-2.0.1-incubating/sql/scrip >>>>> >ts$ netstat -a|grep 23400 >>>>> >tcp6 0 0 [::]:23400 [::]:* >>>>> >LISTEN And if we try sqlci: >>>>> >trafodion@ubuntu-1:~$ sqlci >>>>> >Apache Trafodion Conversational Interface 2.0.1 Copyright (c) 2015-2016 >>>>> >Apache Software Foundation >>>>> >*** ERROR[2055] The specified value '0.001' for DEFAULTS attribute >>>>> >WORK_UNIT_ESP_DATA_COPY_COST is not valid. >>>>> >regards >>>>> >Samuel >
