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 [email protected]: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:[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
