Datacell issue on Jan2014-SP3 build

12 Mar 2015

      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

Tsai Li Ming

Ying Zhang

Dimitar Nedev

Tsai Li Ming

Ying Zhang

Martin Kersten

tags

participants (4)