SciQL-2 branch - users-list - monetdb.org

newer
Grant select on all tables

SciQL-2 branch

older
Release Disk Space

Dimitar Misev

4 Dec 2014 4 Dec '14

1:03 p.m.

Hi, I wanted to try SciQL so I got the SciQL-2 branch, but unfortunately it doesn't seem to be working. Following the tutorial at https://www.monetdb.org/Documentation/UserGuide/Tutorial I got stuck at $ mclient -u monetdb -d voc password: 3F000!CREATE PROCEDURE: no such schema 'rs' ParseException:SQLparser:3F000!CREATE PROCEDURE: no such schema 'rs' The default branch works ok. Any ideas on this problem, is there maybe a specific commit known to work? Thanks, Dimitar

Reply

Sign in to reply online Use email software

Show replies by date

Stefan Manegold

4 Dec 4 Dec

1:07 p.m.

Hi, did you try the SciQL branch on a new virgin empty database, or on a database that was previously created by some other version of MonetDB? If the latter, please try the former. Best, Stefan ----- Original Message -----

Hi,

I wanted to try SciQL so I got the SciQL-2 branch, but unfortunately it doesn't seem to be working.

Following the tutorial at https://www.monetdb.org/Documentation/UserGuide/Tutorial I got stuck at

$ mclient -u monetdb -d voc password: 3F000!CREATE PROCEDURE: no such schema 'rs' ParseException:SQLparser:3F000!CREATE PROCEDURE: no such schema 'rs'

The default branch works ok. Any ideas on this problem, is there maybe a specific commit known to work?

Thanks, Dimitar _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

Reply

Sign in to reply online Use email software

Dimitar Misev

1:11 p.m.

It was a brand new database, here's full log: $ monetdbd create ~/data $ monetdbd start ~/data $ monetdb create voc created database in maintenance mode: voc $ monetdb release voc taken database out of maintenance mode: voc $ mclient -u monetdb -d voc password: 3F000!CREATE PROCEDURE: no such schema 'rs' ParseException:SQLparser:3F000!CREATE PROCEDURE: no such schema 'rs' I tried also SciQL-2-NetCDF, but it failed similarly. Best, Dimitar On 12/04/2014 02:07 PM, Stefan Manegold wrote:

Hi,

did you try the SciQL branch on a new virgin empty database, or on a database that was previously created by some other version of MonetDB?

If the latter, please try the former.

Best, Stefan

----- Original Message -----

...
Hi,

I wanted to try SciQL so I got the SciQL-2 branch, but unfortunately it doesn't seem to be working.

Following the tutorial at https://www.monetdb.org/Documentation/UserGuide/Tutorial I got stuck at

$ mclient -u monetdb -d voc password: 3F000!CREATE PROCEDURE: no such schema 'rs' ParseException:SQLparser:3F000!CREATE PROCEDURE: no such schema 'rs'

The default branch works ok. Any ideas on this problem, is there maybe a specific commit known to work?

Thanks, Dimitar _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

Reply

Sign in to reply online Use email software

Ying Zhang

1:52 p.m.

On Dec 04, 2014, at 14:11, Dimitar Misev wrote:

It was a brand new database, here's full log:

$ monetdbd create ~/data $ monetdbd start ~/data $ monetdb create voc created database in maintenance mode: voc $ monetdb release voc taken database out of maintenance mode: voc $ mclient -u monetdb -d voc password: 3F000!CREATE PROCEDURE: no such schema 'rs' ParseException:SQLparser:3F000!CREATE PROCEDURE: no such schema 'rs'

A file "31_geotiff_schema.sql" should be present in lib/monetdb5/createdb/ under the dir. where you installed your monetdb. That file is supposed to automatically create the schema 'rs' when a new db is created. Can you please check?

I tried also SciQL-2-NetCDF, but it failed similarly.

These two branches are synced... Jennie

Best, Dimitar

On 12/04/2014 02:07 PM, Stefan Manegold wrote:

...
Hi,

did you try the SciQL branch on a new virgin empty database, or on a database that was previously created by some other version of MonetDB?

If the latter, please try the former.

Best, Stefan

----- Original Message -----

...
Hi,

I wanted to try SciQL so I got the SciQL-2 branch, but unfortunately it doesn't seem to be working.

Following the tutorial at https://www.monetdb.org/Documentation/UserGuide/Tutorial I got stuck at

$ mclient -u monetdb -d voc password: 3F000!CREATE PROCEDURE: no such schema 'rs' ParseException:SQLparser:3F000!CREATE PROCEDURE: no such schema 'rs'

The default branch works ok. Any ideas on this problem, is there maybe a specific commit known to work?

Thanks, Dimitar _______________________________________________ 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

Reply

Sign in to reply online Use email software

Dimitar Misev

2 p.m.

Thanks, that helped! This file wasn't installed for some reason, copying it fixed the issue. ~/MonetDB is the source dir, ~/MonetDB/INSTALL is the installation dir: ~/MonetDB$ find -name 31_geotiff_schema.sql ./sql/scripts/31_geotiff_schema.sql ~/MonetDB$ cp ./sql/scripts/31_geotiff_schema.sql INSTALL/lib/monetdb5/createdb/ On 12/04/2014 02:52 PM, Ying Zhang wrote:

A file "31_geotiff_schema.sql" should be present in lib/monetdb5/createdb/ under the dir. where you installed your monetdb. That file is supposed to automatically create the schema 'rs' when a new db is created. Can you please check?

Reply

Sign in to reply online Use email software

Dimitar Misev

2:28 p.m.

Forgot to mention, maybe it would be useful to others that want to compile SciQL-2 with gcc 4.7.2: compilation failed for me because of a warning I assume, I had to do this to go around it: sed -i 's/-Werror//g' configure Dimitar On 12/04/2014 03:00 PM, Dimitar Misev wrote:

Thanks, that helped! This file wasn't installed for some reason, copying it fixed the issue. ~/MonetDB is the source dir, ~/MonetDB/INSTALL is the installation dir:

~/MonetDB$ find -name 31_geotiff_schema.sql ./sql/scripts/31_geotiff_schema.sql ~/MonetDB$ cp ./sql/scripts/31_geotiff_schema.sql INSTALL/lib/monetdb5/createdb/

On 12/04/2014 02:52 PM, Ying Zhang wrote:

...
A file "31_geotiff_schema.sql" should be present in lib/monetdb5/createdb/ under the dir. where you installed your monetdb. That file is supposed to automatically create the schema 'rs' when a new db is created. Can you please check?

users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

Reply

Sign in to reply online Use email software

Stefan Manegold

2:53 p.m.

Dimitar, as a user, you are welcome to try configure with --disable-strict; which disables -Werror more conveniently than your patch. We as developers need to do our homework and fix the SciQL-2 code to get it compiled successfully also with -Werror (i.e., --enable-strict). Having said that, SciQL is still in a very experimental state, and any user is implicitly a "Guinea pig" and "beta-tester". Thus, we appreciate your patience, understanding, and in particular any feedback even more! Thanks! Stefan ----- Original Message -----

Forgot to mention, maybe it would be useful to others that want to compile SciQL-2 with gcc 4.7.2: compilation failed for me because of a warning I assume, I had to do this to go around it:

sed -i 's/-Werror//g' configure

Dimitar

On 12/04/2014 03:00 PM, Dimitar Misev wrote:

...
Thanks, that helped! This file wasn't installed for some reason, copying it fixed the issue. ~/MonetDB is the source dir, ~/MonetDB/INSTALL is the installation dir:

~/MonetDB$ find -name 31_geotiff_schema.sql ./sql/scripts/31_geotiff_schema.sql ~/MonetDB$ cp ./sql/scripts/31_geotiff_schema.sql INSTALL/lib/monetdb5/createdb/

On 12/04/2014 02:52 PM, Ying Zhang wrote:

...
A file "31_geotiff_schema.sql" should be present in lib/monetdb5/createdb/ under the dir. where you installed your monetdb. That file is supposed to automatically create the schema 'rs' when a new db is created. Can you please check?

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

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

Reply

Sign in to reply online Use email software

Dimitar Misev

3:11 p.m.

Thanks, that's indeed better; I looked quickly through the configure options but have somehow missed it. Best, Dimitar On 12/04/2014 03:53 PM, Stefan Manegold wrote:

Dimitar,

as a user, you are welcome to try configure with --disable-strict; which disables -Werror more conveniently than your patch.

We as developers need to do our homework and fix the SciQL-2 code to get it compiled successfully also with -Werror (i.e., --enable-strict).

Having said that, SciQL is still in a very experimental state, and any user is implicitly a "Guinea pig" and "beta-tester". Thus, we appreciate your patience, understanding, and in particular any feedback even more!

Thanks! Stefan

----- Original Message -----

...
Forgot to mention, maybe it would be useful to others that want to compile SciQL-2 with gcc 4.7.2: compilation failed for me because of a warning I assume, I had to do this to go around it:

sed -i 's/-Werror//g' configure

Dimitar

On 12/04/2014 03:00 PM, Dimitar Misev wrote:

...
Thanks, that helped! This file wasn't installed for some reason, copying it fixed the issue. ~/MonetDB is the source dir, ~/MonetDB/INSTALL is the installation dir:

~/MonetDB$ find -name 31_geotiff_schema.sql ./sql/scripts/31_geotiff_schema.sql ~/MonetDB$ cp ./sql/scripts/31_geotiff_schema.sql INSTALL/lib/monetdb5/createdb/

On 12/04/2014 02:52 PM, Ying Zhang wrote:

...
A file "31_geotiff_schema.sql" should be present in lib/monetdb5/createdb/ under the dir. where you installed your monetdb. That file is supposed to automatically create the schema 'rs' when a new db is created. Can you please check?

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

Reply

Sign in to reply online Use email software

Sjoerd Mullender

2:29 p.m.

Jennie, then this file should be mentioned in the SOURCES list in sql/scripts/Makefile.ag. On 04/12/14 14:52, Ying Zhang wrote:

...
On Dec 04, 2014, at 14:11, Dimitar Misev wrote:

It was a brand new database, here's full log:

$ monetdbd create ~/data $ monetdbd start ~/data $ monetdb create voc created database in maintenance mode: voc $ monetdb release voc taken database out of maintenance mode: voc $ mclient -u monetdb -d voc password: 3F000!CREATE PROCEDURE: no such schema 'rs' ParseException:SQLparser:3F000!CREATE PROCEDURE: no such schema 'rs'

A file "31_geotiff_schema.sql" should be present in lib/monetdb5/createdb/ under the dir. where you installed your monetdb. That file is supposed to automatically create the schema 'rs' when a new db is created. Can you please check?

...
I tried also SciQL-2-NetCDF, but it failed similarly.

These two branches are synced...

Jennie

...
Best, Dimitar

On 12/04/2014 02:07 PM, Stefan Manegold wrote:

...
Hi,

did you try the SciQL branch on a new virgin empty database, or on a database that was previously created by some other version of MonetDB?

If the latter, please try the former.

Best, Stefan

----- Original Message -----

...
Hi,

I wanted to try SciQL so I got the SciQL-2 branch, but unfortunately it doesn't seem to be working.

Following the tutorial at https://www.monetdb.org/Documentation/UserGuide/Tutorial I got stuck at

$ mclient -u monetdb -d voc password: 3F000!CREATE PROCEDURE: no such schema 'rs' ParseException:SQLparser:3F000!CREATE PROCEDURE: no such schema 'rs'

The default branch works ok. Any ideas on this problem, is there maybe a specific commit known to work?

Thanks, Dimitar _______________________________________________ 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

-- Sjoerd Mullender

Reply

Sign in to reply online Use email software

Ying Zhang

2:55 p.m.

On Dec 04, 2014, at 15:29, Sjoerd Mullender wrote:

Jennie, then this file should be mentioned in the SOURCES list in sql/scripts/Makefile.ag.

It is in the Makefile.ag, with the condition HAVE_GEOTIFF Obviously, it was not copied to the createdb dir because the geotiff lib was not found, but for some reason, some code is still trying to do something with the 'rs' schema... I'll have a quick look why or who is trying to use schema 'rs', already at the first client connection.

On 04/12/14 14:52, Ying Zhang wrote:

...
...
On Dec 04, 2014, at 14:11, Dimitar Misev wrote:

It was a brand new database, here's full log:

$ monetdbd create ~/data $ monetdbd start ~/data $ monetdb create voc created database in maintenance mode: voc $ monetdb release voc taken database out of maintenance mode: voc $ mclient -u monetdb -d voc password: 3F000!CREATE PROCEDURE: no such schema 'rs' ParseException:SQLparser:3F000!CREATE PROCEDURE: no such schema 'rs'

A file "31_geotiff_schema.sql" should be present in lib/monetdb5/createdb/ under the dir. where you installed your monetdb. That file is supposed to automatically create the schema 'rs' when a new db is created. Can you please check?

...
I tried also SciQL-2-NetCDF, but it failed similarly.

These two branches are synced...

Jennie

...
Best, Dimitar

On 12/04/2014 02:07 PM, Stefan Manegold wrote:

...
Hi,

did you try the SciQL branch on a new virgin empty database, or on a database that was previously created by some other version of MonetDB?

If the latter, please try the former.

Best, Stefan

----- Original Message -----

...
Hi,

I wanted to try SciQL so I got the SciQL-2 branch, but unfortunately it doesn't seem to be working.

Following the tutorial at https://www.monetdb.org/Documentation/UserGuide/Tutorial I got stuck at

$ mclient -u monetdb -d voc password: 3F000!CREATE PROCEDURE: no such schema 'rs' ParseException:SQLparser:3F000!CREATE PROCEDURE: no such schema 'rs'

The default branch works ok. Any ideas on this problem, is there maybe a specific commit known to work?

Thanks, Dimitar _______________________________________________ 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

-- Sjoerd Mullender

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

Reply

Sign in to reply online Use email software

3677

Age (days ago)

3677

Last active (days ago)

Download

9 comments

4 participants

tags

participants (4)

Dimitar Misev
Sjoerd Mullender
Stefan Manegold
Ying Zhang