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