Re: Datacell issue on Jan2014-SP3 build

18 Mar 2015

...
On Mar 18, 2015, at 15:41, Dimitar Nedev  wrote:
Hello Liming,
I would recommend using MonetDB Feb2013-SP6 until we figure out the cause of the issue. It's best to build it from sources and explicitly enable the DataCell module with "--enable-datacell" [1].
I ran through the DataCell Tutorial without issues using that version: pushing data with "sensor" and getting it out from the emitter using 'nc'.
...
datacell.dump() does report the same "invalid/unknown response from server, ignoring output",
This is not reported by datacell.dump(), but mclient.  This is caused by that datacell.dump() has piggybacked some additional information in a rather hacky way, and mclient doesn't know what to do with it.

This complain can be safely ignored for now.

Regards,

Jennie
...
but everything else to worked.
Best regards,
Dimitar
[1] https://dev.monetdb.org/downloads/sources/Feb2013-SP6/
...
On 2015-Mar-18, at 13:09 , Ying Zhang  wrote:
Hello Liming,
I can reproduce the error.   One of our colleagues is looking into this issue.  With some the error is caused by some out-dated internal configuration.  However, we are quite occupied this week.  So we can only spend more effort on this issue next week.  Please bear with us.  Thanks for your patience!
With kind regards,
Jennie
...
On Mar 12, 2015, at 11:08, Tsai Li Ming  wrote:
Hi,
We are trying data cell on the Jan2014-SP3 build.
There is a “Query datacell.pass failed:SQLException:mvc:SQL module not initialised” error. Please see below:
Welcome to mclient, the MonetDB/SQL interactive terminal (Jan2014-SP3)
Database: MonetDB v11.17.21 (Jan2014-SP3), 'mapi:monetdb://localhost.localdomain:50000/foo'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>set optimizer='datacell_pipe';
operation successful (1.465ms)
sql>
sql>create table datacell.bsktin(
more>    id integer,
more>    tag integer,
more>    payload integer
more>);
operation successful (325.852ms)
sql>create table datacell.bsktout (like datacell.bsktin);
operation successful (106.356ms)
sql>
sql>call datacell.receptor('datacell.bsktin','localhost',50500);
sql>
sql>call datacell.emitter('datacell.bsktout','localhost',50600);
sql>
sql>call datacell.query('datacell.pass', 'insert into datacell.bsktout select * from datacell.bsktin;');
sql>
sql>select * from datacell.receptors(); select * from datacell.emitters(); select * from datacell.queries(); select * from datacell.baskets();
+-----------------+-----------+-------+----------+---------+--------+----------------------------+--------+----------+---------+
| nme             | host      | port  | protocol | mode    | status | lastseen                   | cycles | received | pending |
+=================+===========+=======+==========+=========+========+============================+========+==========+=========+
| datacell.bsktin | localhost | 50500 | TCP      | passive | paused | null                       |      0 |        0 |       0 |
+-----------------+-----------+-------+----------+---------+--------+----------------------------+--------+----------+---------+
1 tuple (10.546ms)
+------------------+-----------+-------+----------+--------+--------+----------------------------+--------+------+---------+
| nme              | host      | port  | protocol | mode   | status | lastsent                   | cycles | sent | pending |
+==================+===========+=======+==========+========+========+============================+========+======+=========+
| datacell.bsktout | localhost | 50600 | UDP      | active | paused | null                       |      0 |    0 |       0 |
+------------------+-----------+-------+----------+--------+--------+----------------------------+--------+------+---------+
1 tuple (10.780ms)
+---------------+--------+----------------------------+--------+--------+------+-------+-------------------------------------------------------------+
| nme           | status | lastrun                    | cycles | events | time | error | def                                                         |
+===============+========+============================+========+========+======+=======+=============================================================+
| datacell.pass | paused | null                       |      0 |      0 |    0 |       | insert into datacell.bsktout select * from datacell.bsktin; |
+---------------+--------+----------------------------+--------+--------+------+-------+-------------------------------------------------------------+
1 tuple (15.348ms)
+------------------+-----------+---------+-----------+-----------+------------+------+----------------------------+--------+
| nme              | threshold | winsize | winstride | timeslice | timestride | beat | seen                       | events |
+==================+===========+=========+===========+===========+============+======+============================+========+
| datacell.bsktin  |         0 |       0 |         0 |         0 |          0 |    0 | null                       |      0 |
| datacell.bsktout |         0 |       0 |         0 |         0 |          0 |    0 | null                       |      0 |
+------------------+-----------+---------+-----------+-----------+------------+------+----------------------------+--------+
2 tuples (15.704ms)
sql>
sql>call datacell.resume();
sql>call datacell.dump();
invalid/unknown response from server, ignoring output
? #baskets[ 1] datacell.bsktin columns 3 threshold 0 window=[0,0] time window=[0,0] beat 0 milliseconds events 0
? #baskets[ 2] datacell.bsktout columns 3 threshold 0 window=[0,0] time window=[0,0] beat 0 milliseconds events 0
? #receptor datacell.bsktin at localhost:50500 protocol=TCP mode=passive status=running delay=1000 
? #emitter datacell.bsktout at localhost:50600 protocol=UDP mode=active status=running delay=1000
? #scheduler status running
(remaining output omitted, use \fraw to examine in detail)
We then ran nc and sensor program but get nothing on the nc output:
sql>select * from datacell.receptors(); select * from datacell.emitters(); select * from datacell.queries(); select * from datacell.baskets();
+-----------------+-----------+-------+----------+---------+---------+----------------------------+--------+----------+---------+
| nme             | host      | port  | protocol | mode    | status  | lastseen                   | cycles | received | pending |
+=================+===========+=======+==========+=========+=========+============================+========+==========+=========+
| datacell.bsktin | localhost | 50500 | TCP      | passive | running | 2015-03-12 09:58:36.000000 |      1 |     1000 |    1000 |
+-----------------+-----------+-------+----------+---------+---------+----------------------------+--------+----------+---------+
1 tuple (5.729ms)
+------------------+-----------+-------+----------+--------+---------+----------------------------+--------+------+---------+
| nme              | host      | port  | protocol | mode   | status  | lastsent                   | cycles | sent | pending |
+==================+===========+=======+==========+========+=========+============================+========+======+=========+
| datacell.bsktout | localhost | 50600 | UDP      | active | running | null                       |      0 |    0 |       0 |
+------------------+-----------+-------+----------+--------+---------+----------------------------+--------+------+---------+
1 tuple (6.183ms)
+---------------+---------+----------------------------+--------+------+----------+------------------------------------------------+------------------------------------------------+
| nme           | status  | lastrun                    | cycles | even | time     | error                                          | def                                            |
:               :         :                            :        : ts   :          :                                                :                                                :
+===============+=========+============================+========+======+==========+================================================+================================================+
| datacell.pass | running | null                       | 105797 |    0 | 12205937 | Query datacell.pass failed:SQLException:mvc:SQ | insert into datacell.bsktout select * from dat |
:               :         :                            :        :      :          : L module not initialized                       : acell.bsktin;                                  :
+---------------+---------+----------------------------+--------+------+----------+------------------------------------------------+------------------------------------------------+
1 tuple (6.299ms)
+------------------+-----------+---------+-----------+-----------+------------+------+----------------------------+--------+
| nme              | threshold | winsize | winstride | timeslice | timestride | beat | seen                       | events |
+==================+===========+=========+===========+===========+============+======+============================+========+
| datacell.bsktin  |         0 |       0 |         0 |         0 |          0 |    0 | 2015-03-12 10:04:22.000000 |   1000 |
| datacell.bsktout |         0 |       0 |         0 |         0 |          0 |    0 | null                       |      0 |
+------------------+-----------+---------+-----------+-----------+------------+------+----------------------------+--------+
2 tuples (6.487ms)
Can someone help? Our MonetDB build is faulty?
Regards,
Liming
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list