datacell functions no longer work after restart of database #3063
Last updated: 2012-05-25 12:58:45 +0200
Date: 2012-03-15 16:29:32 +0100
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_7; en-us) AppleWebKit/533.21.1 (KHTML, like Gecko) Version/5.0.5 Safari/533.21.1
mserver does not load datacell functions when restarted on an old database
Steps to Reproduce:
Date: 2012-03-15 17:13:34 +0100
not limited to datacell, udf.reverse doesn't work either
Date: 2012-03-15 19:36:28 +0100
IMHO, files in createdb are only executed on creation of a newly create database.
Of course, between release, we should provide an upgrade path.
This is most probably no available for datacell --- but then, datacell has never been released formally --- and might indeed also not correctly exist for UDF.
I'll check the latter tomorrow ...
Date: 2012-04-05 13:23:44 +0200
Stefan's and Fabian's comments are, I'm afraid, not relevant. As Erietta says, if you start with a non-existing database which gets initialized when the server starts first up, the query works. If you then stop the server and start it again on the already initialized database, the query does not work.
Date: 2012-04-05 13:27:34 +0200
By the way, I can reproduce the problem, even though when the server is started the second time, I get:
sql>select f.* from functions f, schemas s where f.name = 'queries' and f.schema_id = s.id and s.name = 'datacell';
Date: 2012-04-05 13:28:58 +0200
my comment still stands, I can reproduce with udf.reverse -- thus making the problem non-datacell specific ;) I changed the subject, see history.
Date: 2012-04-25 15:50:51 +0200
fabian could you show howto reproduce this using udf.reverse?
Date: 2012-05-01 11:00:11 +0200
I can't reproduce any more, select udf.reverse('bla') works fine now.
Date: 2012-05-02 09:40:02 +0200
The problem only occurs with datacell. I've done quite some patching, but all in vain. I suspect that the definition of datacell.queries is not available somehow. Hence I moved definitions of datacell before sql, but that didn't help either (with fixing the runtime symbol lookup problems).
Date: 2012-05-02 11:52:43 +0200
the table returning functions require a 'table definition'. These are stored in the _tables table. Somehow with private schema's this goes wrong.
Date: 2012-05-02 11:56:28 +0200
it seems the tables types are stored in the sys._tables table instead of the datacell tables table.
Date: 2012-05-02 13:36:18 +0200
properly store the functions return type into the tables table in the schema of the function
Date: 2012-05-02 13:54:08 +0200
correction, all return types should stay in the sys.tables table (only tmp also
Date: 2012-05-02 16:00:14 +0200
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=4abb5d147a2d
The text was updated successfully, but these errors were encountered: