TSocket::open() error on socket (after poll) <Host: localhost Port: 38080>Connection refused

916 views
Skip to first unread message

anggagitu

unread,
Jul 2, 2010, 8:04:50 AM7/2/10
to Hypertable User
Hi, all...
I installed hypertable 0.9.3.3 in my slackware 13.1. instalation
process is succes.But when start hypertable, this error message
appears. what is wrong?

root@darkstar:~# /opt/hypertable/current/bin/ht start all-servers
local
DFS broker: available file descriptors: 1024
Started DFS Broker (local)
Started Hyperspace
Started Hypertable.Master
Started Hypertable.RangeServer
Thrift: Fri Jul 2 14:45:07 2010 TSocket::open() error on socket
(after poll) <Host: localhost Port: 38080>Connection refused
Thrift: Fri Jul 2 14:45:07 2010 TSocket::open() error on socket
(after poll) <Host: localhost Port: 38080>Connection refused
Started ThriftBroker


please help me...I use hypertable to do my thesis... :(( thx before
anggagitu

Milko Marinov

unread,
Jul 5, 2010, 12:17:15 PM7/5/10
to hyperta...@googlegroups.com, mmar...@ecs.uni-ruse.bg, Vladimir Tochev, jco...@hildebrand.co.uk, p...@manuf.uni-ruse.bg
Hi Doug,

I’m pleased to be able to inform you that we managed to extend the HQL with aggregate operations (SUM, MIN, MAX, AVG, COUNT).

As I mentioned several months ago we are using Hypertable DBMS into the DEHEMS project (look at: http://www.dehems.eu/   and  http://www.dehems.org ) to collect real time-series data.

The project about Extension of HQL with aggregate operations is developed by my MSc student Vladimir Tochev (on.th...@gmail.com). Last week he successfully defended his MSc Diplom Thesis.

Our interpreter is called “DHQL” – DEHEMS HQL. Here are some examples of queries:

./dhqli "SELECT COUNT(ch1_watts, LONG) FROM real_data"

./dhqli "SELECT AVG(ch1_watts, FLOAT) FROM real_data GROUP BY ROW"

./dhqli "SELECT AVG(ch1_watts, FLOAT) FROM real_data GROUP BY TIMESTAMP"

./dhqli "SELECT AVG(temp, FLOAT) FROM real_data GROUP BY ROW"

./dhqli "SELECT SUM(ch1_watts, LONG) FROM real_data WHERE ROW='client1'"

./dhql "SELECT SUM(ch1_watts, LONG), AVG(temp, FLOAT) FROM real_data WHERE '2010-06-05 17:55:00'< TIMESTAMP < '2010-07-05 18:15:00' GROUP BY ROW TIME_RESOLUTION = 1 m"

./dhqli "SELECT MIN(ch1_watts, INT) FROM real_data WHERE ROW='client1' AND '2010-06-03 17:00:00'< TIMESTAMP < '2010-06-03 20:00:00' GROUP BY TIMESTAMP TIME_RESOLUTION = 30 m"

./dhqli "SELECT MAX(ch1_watts, INT) FROM real_data WHERE ROW='client1' AND '2010-06-03 17:00:00'< TIMESTAMP < '2010-06-03 20:00:00' GROUP BY ROW TIME_RESOLUTION = 1 h"

Please let me know if you are interested in more details about the implementation of the HQL Extension.

You are welcome!!!  :-)

Regards,

Milko

**********************************************************
     Assoc. Prof. Milko Todorov Marinov, PhD
 Department of Computer Systems & Technologies
                University of Ruse
8 Studentska Str, 7017 Ruse, BULGARIA
Cell phone: (+359 88) 999 6793
***********************************************************

nugge...@gmail.com

unread,
Jul 5, 2010, 6:44:53 PM7/5/10
to hyperta...@googlegroups.com, mmar...@ecs.uni-ruse.bg, Vladimir Tochev, jco...@hildebrand.co.uk, p...@manuf.uni-ruse.bg
Hi Milko, This is great! I'm on vacation now. I'll check it out when I get back in about a week. - Doug

Sent from my Verizon Wireless BlackBerry


From: "Milko Marinov" <MMar...@ecs.uni-ruse.bg>
Date: Mon, 05 Jul 2010 19:17:15 +0300
Subject: [hypertable-user] Extension of HQL with aggregate operations

--
You received this message because you are subscribed to the Google Groups "Hypertable User" group.
To post to this group, send email to hyperta...@googlegroups.com.
To unsubscribe from this group, send email to hypertable-us...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/hypertable-user?hl=en.

Sanjit Jhala

unread,
Jul 5, 2010, 9:48:12 PM7/5/10
to hyperta...@googlegroups.com
Hi,

This message is harmless, just ignore it. It looks like all the servers are running just fine.

-Sanjit

Milko Marinov

unread,
Jul 9, 2010, 8:37:34 AM7/9/10
to hyperta...@googlegroups.com, Vladimir Tochev, jco...@hildebrand.co.uk, p...@manuf.uni-ruse.bg
Hi Doug,

We are making an attempt at using ThriftBroker to insert data into Hypertable DB.

When used with mod_python (the code below),

#!/usr/bin/python
from mod_python import apache
from mod_python import util
import sys
sys.path.append('/var/www/html/insert')
sys.path.append('/var/www/html/insert/hypertable')
sys.path.append('/var/www/html/insert/hyperthrift')
from hypertable.thriftclient import *
from hyperthrift.gen.ttypes import *
def handler(req):
req.content_type = 'text/plain'
client = ThriftClient("192.168.0.153", 38080)
req.write( "HQL examples" )
req.write( client.hql_query("show tables") )
return apache.OK


the python ThriftClient for hypertable gives the following error:


MOD_PYTHON ERROR
ProcessId: 1504
Interpreter: '::1'
ServerName: '::1'
DocumentRoot: '/var/www/html'
URI: '/insert/insert.py'
Location: None
Directory: '/var/www/html/insert/'
Filename: '/var/www/html/insert/insert.py'
PathInfo: ''
Phase: 'PythonHandler'
Handler: 'insert'
Traceback (most recent call last):
File "/usr/lib64/python2.6/site-packages/mod_python/importer.py", line 1537, in
HandlerDispatch
default=default_handler, arg=req, silent=hlist.silent)
File "/usr/lib64/python2.6/site-packages/mod_python/importer.py", line 1229, in
_process_target
result = _execute_target(config, req, object, arg)
File "/usr/lib64/python2.6/site-packages/mod_python/importer.py", line 1128, in
_execute_target
result = object(arg)
File "/var/www/html/insert/insert.py", line 17, in handler
client = ThriftClient("192.168.0.153", 38080)
File "/var/www/html/insert/hypertable/thriftclient.py", line 17, in __init__
self.open(timeout_ms)
File "/var/www/html/insert/hypertable/thriftclient.py", line 20, in open
self.transport.open()
File "/usr/lib64/python2.6/site-packages/thrift/transport/TTransportpy", line 257, in open
return self.__trans.open()
File "/usr/lib64/python2.6/site-packages/thrift/transport/TSocket.py", line 89, in open
raise TTransportException(type=TTransportException.NOT_OPEN, message=message)
TTransportException: Could not connect to 192.168.0.153:38080
MODULE CACHE DETAILS
Accessed: Fri Jul 9 11:57:04 2010
Generation: 0
_mp_809b41c18fb5188389b7908e1f9234d3 {
FileName: '/var/www/html/insert/insert.py'
Instance: 1 [IMPORT]
Generation: 1
Modified: Thu Jul 8 18:34:23 2010
Imported: Fri Jul 9 11:57:04 2010
}

This exception is not raised when ThriftClient is used with the standard python interpreter.

Have you got any idea???

Regards,

Milko

On 5 Jul 2010 at 22:44, nugge...@gmail.com wrote:

>
> Hi Milko, This is great! I'm on vacation now. I'll check it out when I get back in about a week. -
> Doug
> Sent from my Verizon Wireless BlackBerry
>

> From: "Milko Marinov" <MMar...@ecs.uni-rusebg>
> Sender: hyperta...@googlegroups.com
> Date: Mon, 05 Jul 2010 19:17:15 +0300
> To: <hyperta...@googlegroups.com>
> ReplyTo: hyperta...@googlegroups.com
> Cc: <mmar...@ecs.uni-ruse.bg>; Vladimir Tochev<on.th...@gmail.com>;
> <jco...@hildebrand.co.uk>; <p...@manuf.uni-ruse.bg>
> Subject: [hypertable-user] Extension of HQL with aggregate operations
>
> Hi Doug,
>
> I’m pleased to be able to inform you that we managed to extend the HQL with aggregate
> operations (SUM, MIN, MAX, AVG, COUNT).
>
> As I mentioned several months ago we are using Hypertable DBMS into the DEHEMS project

> (look at: http://wwwdehems.eu/ and http://www.dehems.org ) to collect real time-series data.

Sanjit Jhala

unread,
Jul 9, 2010, 2:48:47 PM7/9/10
to hyperta...@googlegroups.com
Hi Milko,

From the error it looks like the client can't connect to the ThriftBroker. Can you confirm that the ThriftBroker is indeed running on 192.168.0.153:38080 and also that the port 38080 is open and the client isn't being blocked by a firewall?

-Sanjit

Doug Judd

unread,
Jul 10, 2010, 9:39:54 AM7/10/10
to hyperta...@googlegroups.com, mmar...@ecs.uni-ruse.bg, Vladimir Tochev, jco...@hildebrand.co.uk, p...@manuf.uni-ruse.bg
Hi Milko,

Can you point me to a github repository that contains your work?

- Doug

--

mmar...@ecs.uni-ruse.bg

unread,
Jul 10, 2010, 1:42:16 PM7/10/10
to sjh...@gmail.com, hyperta...@googlegroups.com
Thanks Sanjit,

The problem described bellow arises only with mod_python.

No problems with other interpreters.

Have got any idea?

Regards,

Milko

>> hypertable-us...@googlegroups.com<hypertable-user%2Bunsubscri
>> b...@googlegroups.com> .


>> For more options, visit this group at
>> http://groups.google.com/group/hypertable-user?hl=en.
>>
>>
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Hypertable User" group.
> To post to this group, send email to hyperta...@googlegroups.com.
> To unsubscribe from this group, send email to
> hypertable-us...@googlegroups.com. For more options, visit this
> group at http://groups.google.com/group/hypertable-user?hl=en.
>
>
>

Reply all
Reply to author
Forward
0 new messages