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
<samuel.lepe...@elitelco.net> 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
<samuel.lepe...@elitelco.net> 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
<anuradha.he...@esgyn.com> 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:samuel.lepe...@elitelco.net]
Sent: Saturday, October 15, 2016 2:41 AM
To: dev@trafodion.incubator.apache.org
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
