Hi

rw-rw-r-- 1 trafodion trafodion 135 oct.  10 20:06 master_exec_0_43312.log
-rw-rw-r-- 1 trafodion trafodion 135 oct.  10 20:44 master_exec_0_50370.log
-rw-rw-r-- 1 trafodion trafodion 135 oct.  10 20:51 master_exec_0_50510.log
-rw-rw-r-- 1 trafodion trafodion 135 oct.  10 20:55 master_exec_0_50597.log
-rw-rw-r-- 1 trafodion trafodion 135 oct.  10 20:56 master_exec_0_50633.log
-rw-rw-r-- 1 trafodion trafodion 135 oct.  11 11:22 master_exec_0_60985.log
-rw-rw-r-- 1 trafodion trafodion 134 oct.  12 11:49 master_exec_0_9887.log
-rw-rw-r-- 1 trafodion trafodion 135 oct.  12 15:49 master_exec_0_35261.log
-rw-rw-r-- 1 trafodion trafodion 134 oct.  12 18:12 master_exec_0_6097.log
-rw-rw-r-- 1 trafodion trafodion 135 oct.  12 18:50 master_exec_0_20002.log
-rw-rw-r-- 1 trafodion trafodion 135 oct.  14 16:36 master_exec_0_29229.log
-rw-rw-r-- 1 trafodion trafodion 135 oct.  14 16:54 master_exec_0_26786.log
-rw-rw-r-- 1 trafodion trafodion 135 oct.  15 12:32 master_exec_0_62694.log
-rw-rw-r-- 1 trafodion trafodion 135 oct.  17 12:44 master_exec_0_49819.log
-rw-rw-r-- 1 trafodion trafodion 135 oct.  18 10:13 master_exec_0_18432.log
-rw-rw-r-- 1 trafodion trafodion 135 oct.  18 10:23 master_exec_0_13112.log
trafodion@ubuntu-1:~/apache-trafodion_server-2.0.1-incubating/logs$ cat master_exec_0_13112.log 2016-10-18 10:23:52,436, INFO, SQL.EXE, Node Number: 0, CPU: 0, PIN: 13112, Process Name: $Z000APM,,, An executor process is launched.
trafodion@ubuntu-1:~/apache-trafodion_server-2.0.1-incubating/logs$

And DCS:

2016-10-18 10:17:53,838, INFO, org.trafodion.dcs.util.VersionInfo, Node Number: , CPU: , PIN: , Process Name: , , ,Dcs 2.0.1 2016-10-18 10:17:53,838, INFO, org.trafodion.dcs.util.VersionInfo, Node Number: , CPU: , PIN: , Process Name: , , ,Revision Unknown 2016-10-18 10:17:53,838, INFO, org.trafodion.dcs.util.VersionInfo, Node Number: , CPU: , PIN: , Process Name: , , ,Compiled by centos on Fri Jun 24 17:42:18 UTC 2016 2016-10-18 10:17:55,127, INFO, org.trafodion.dcs.master.DcsMaster, Node Number: , CPU: , PIN: , Process Name: , , ,Connected to ZooKeeper 2016-10-18 10:17:55,159, INFO, org.trafodion.dcs.util.DcsNetworkConfiguration, Node Number: , CPU: , PIN: , Process Name: , , ,Found interface [enp0s25] 2016-10-18 10:17:55,159, INFO, org.trafodion.dcs.util.DcsNetworkConfiguration, Node Number: , CPU: , PIN: , Process Name: , , ,Matched specified interface [enp0s25] 2016-10-18 10:17:55,166, INFO, org.trafodion.dcs.util.DcsNetworkConfiguration, Node Number: , CPU: , PIN: , Process Name: , , ,Match Found interface [name:enp0s25 (enp0s25),enp0s25,fe80:0:0:0:21a:a0ff:fe7c:a220%enp0s25,fe80:0:0:0:21a:a0ff:fe7c:a220%enp0s25] 2016-10-18 10:17:55,167, INFO, org.trafodion.dcs.util.DcsNetworkConfiguration, Node Number: , CPU: , PIN: , Process Name: , , ,Match Found interface [name:enp0s25 (enp0s25),enp0s25,192.168.0.19,192.168.0.19] 2016-10-18 10:17:55,167, INFO, org.trafodion.dcs.util.DcsNetworkConfiguration, Node Number: , CPU: , PIN: , Process Name: , , ,Using interface [enp0s25,192.168.0.19,192.168.0.19] 2016-10-18 10:17:55,209, INFO, org.trafodion.dcs.master.MasterLeaderElection, Node Number: , CPU: , PIN: , Process Name: , , ,I'm the Leader [/trafodion/dcs/leader/leader-n_0000000005] 2016-10-18 10:17:55,209, INFO, org.trafodion.dcs.master.FloatingIp, Node Number: , CPU: , PIN: , Process Name: , , ,Floating IP is disabled 2016-10-18 10:17:55,214, INFO, org.trafodion.dcs.master.DcsMaster, Node Number: , CPU: , PIN: , Process Name: , , ,Created znode [/trafodion/dcs/master/192.168.0.19:23400:100:1476778675158] 2016-10-18 10:17:55,216, INFO, org.trafodion.dcs.master.listener.ListenerService, Node Number: , CPU: , PIN: , Process Name: , , ,Connected to ZooKeeper 2016-10-18 10:17:55,487, INFO, org.trafodion.dcs.master.DcsMaster, Node Number: , CPU: , PIN: , Process Name: , , ,Listening for clients on port [23400] 2016-10-18 10:17:55,584, INFO, org.mortbay.log, Node Number: , CPU: , PIN: , Process Name: , , ,Logging to org.slf4j.impl.Log4jLoggerAdapter(org.mortbay.log) via org.mortbay.log.Slf4jLog 2016-10-18 10:17:55,675, INFO, org.trafodion.dcs.http.HttpServer, Node Number: , CPU: , PIN: , Process Name: , , ,Port returned by webServer.getConnectors()[0].getLocalPort() before open() is -1. Opening the listener on 24400 2016-10-18 10:17:55,675, INFO, org.trafodion.dcs.http.HttpServer, Node Number: , CPU: , PIN: , Process Name: , , ,listener.getLocalPort() returned 24400 webServer.getConnectors()[0].getLocalPort() returned 24400 2016-10-18 10:17:55,675, INFO, org.trafodion.dcs.http.HttpServer, Node Number: , CPU: , PIN: , Process Name: , , ,Jetty bound to port 24400 2016-10-18 10:17:55,675, INFO, org.mortbay.log, Node Number: , CPU: , PIN: , Process Name: , , ,jetty-6.1.26 2016-10-18 10:17:56,829, INFO, org.mortbay.log, Node Number: , CPU: , PIN: , Process Name: , , ,Started SelectChannelConnector@0.0.0.0:24400 2016-10-18 10:24:07,195, ERROR, org.trafodion.dcs.master.listener.ConnectReply, Node Number: , CPU: , PIN: , Process Name: , , ,/127.0.0.1:46828: No Available Servers - length is 0 2016-10-18 10:24:07,234, ERROR, org.trafodion.dcs.master.listener.ConnectReply, Node Number: , CPU: , PIN: , Process Name: , , ,/127.0.0.1:46828: No Available Servers 2016-10-18 10:24:07,303, ERROR, org.trafodion.dcs.master.listener.ConnectReply, Node Number: , CPU: , PIN: , Process Name: , , ,/127.0.0.1:46832: No Available Servers - length is 0 2016-10-18 10:24:07,303, ERROR, org.trafodion.dcs.master.listener.ConnectReply, Node Number: , CPU: , PIN: , Process Name: , , ,/127.0.0.1:46832: No Available Servers 2016-10-18 10:24:07,311, ERROR, org.trafodion.dcs.master.listener.ConnectReply, Node Number: , CPU: , PIN: , Process Name: , , ,/127.0.0.1:46834: No Available Servers - length is 0 2016-10-18 10:24:07,311, ERROR, org.trafodion.dcs.master.listener.ConnectReply, Node Number: , CPU: , PIN: , Process Name: , , ,/127.0.0.1:46834: No Available Servers 2016-10-18 10:24:07,432, ERROR, org.trafodion.dcs.master.listener.ConnectReply, Node Number: , CPU: , PIN: , Process Name: , , ,/127.0.0.1:46836: No Available Servers - length is 0 2016-10-18 10:24:07,432, ERROR, org.trafodion.dcs.master.listener.ConnectReply, Node Number: , CPU: , PIN: , Process Name: , , ,/127.0.0.1:46836: No Available Servers 2016-10-18 10:24:07,447, ERROR, org.trafodion.dcs.master.listener.ConnectReply, Node Number: , CPU: , PIN: , Process Name: , , ,/127.0.0.1:46838: No Available Servers - length is 0 2016-10-18 10:24:07,447, ERROR, org.trafodion.dcs.master.listener.ConnectReply, Node Number: , CPU: , PIN: , Process Name: , , ,/127.0.0.1:46838: No Available Servers 2016-10-18 10:24:07,453, ERROR, org.trafodion.dcs.master.listener.ConnectReply, Node Number: , CPU: , PIN: , Process Name: , , ,/127.0.0.1:46840: No Available Servers - length is 0 2016-10-18 10:24:07,453, ERROR, org.trafodion.dcs.master.listener.ConnectReply, Node Number: , CPU: , PIN: , Process Name: , , ,/127.0.0.1:46840: No Available Servers 2016-10-18 10:24:07,479, ERROR, org.trafodion.dcs.master.listener.ConnectReply, Node Number: , CPU: , PIN: , Process Name: , , ,/127.0.0.1:46842: No Available Servers - length is 0 2016-10-18 10:24:07,479, ERROR, org.trafodion.dcs.master.listener.ConnectReply, Node Number: , CPU: , PIN: , Process Name: , , ,/127.0.0.1:46842: No Available Servers 2016-10-18 10:24:07,492, ERROR, org.trafodion.dcs.master.listener.ConnectReply, Node Number: , CPU: , PIN: , Process Name: , , ,/127.0.0.1:46844: No Available Servers - length is 0

regards


Le 16/10/2016 à 00:50, Anuradha Hegde 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

Reply via email to