segmentation fault with loopback query

older
group_concat in MAL not working...

Stefano Fioravanzo

6 Jun 2016 6 Jun '16

8:38 a.m.

Hello, I am trying to execute a loopback query in embedded python: CREATE FUNCTION myfunc() RETURNS TABLE(n STRING) LANGUAGE PYTHON { res = _conn.execute("SELECT max(d) FROM mytable;") result = dict() result['n'] = str(res) return result }; When accessing the object ‘res’, mserver5 outputs ‘segmentation fault’ and exits. I think that the issue is in using the max() function in the query, if I leave that out everything works fine. The function: CREATE FUNCTION myfunc() RETURNS TABLE(n STRING) LANGUAGE PYTHON { res = _conn.execute("SELECT d FROM mytable;") result = dict() result['n'] = str(res) return result }; outputs a correct dictionary. Stefano

Show replies by date

Stefan Manegold

6 Jun 6 Jun

8:43 a.m.

Dear Stefano, a segfault is always a bug. Please file a bug report via http://bugs.monetdb.org/ Thanks! Stefan ----- On Jun 6, 2016, at 10:38 AM, Stefano Fioravanzo fioravanzos@gmail.com wrote:

...

Hello,

I am trying to execute a loopback query in embedded python:

CREATE FUNCTION myfunc() RETURNS TABLE(n STRING) LANGUAGE PYTHON { res = _conn.execute("SELECT max(d) FROM mytable;")

result = dict() result['n'] = str(res) return result };

When accessing the object ‘res’, mserver5 outputs ‘segmentation fault’ and exits. I think that the issue is in using the max() function in the query, if I leave that out everything works fine. The function:

CREATE FUNCTION myfunc() RETURNS TABLE(n STRING) LANGUAGE PYTHON { res = _conn.execute("SELECT d FROM mytable;")

result = dict() result['n'] = str(res) return result };

outputs a correct dictionary.

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

Stefano Fioravanzo

8:58 a.m.

Done! Stefano

...

On 06 Jun 2016, at 10:43, Stefan Manegold wrote:

Dear Stefano,

a segfault is always a bug. Please file a bug report via http://bugs.monetdb.org/

Thanks! Stefan

----- On Jun 6, 2016, at 10:38 AM, Stefano Fioravanzo fioravanzos@gmail.com wrote:

...
Hello,

I am trying to execute a loopback query in embedded python:

CREATE FUNCTION myfunc() RETURNS TABLE(n STRING) LANGUAGE PYTHON { res = _conn.execute("SELECT max(d) FROM mytable;")

result = dict() result['n'] = str(res) return result };

When accessing the object ‘res’, mserver5 outputs ‘segmentation fault’ and exits. I think that the issue is in using the max() function in the query, if I leave that out everything works fine. The function:

CREATE FUNCTION myfunc() RETURNS TABLE(n STRING) LANGUAGE PYTHON { res = _conn.execute("SELECT d FROM mytable;")

result = dict() result['n'] = str(res) return result };

outputs a correct dictionary.

Stefano _______________________________________________ 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) | _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

Mark Raasveldt

9:10 a.m.

Hey Stefano, Could you make a reproducible example? The trivial example I made using the UDF you provided does not result in a segfault. This is the example I tested: CREATE TABLE mytable(i DOUBLE, d DOUBLE); INSERT INTO mytable VALUES (1, 1), (2, 2), (3, 3), (4, 4), (5, 5); CREATE FUNCTION myfunc() RETURNS TABLE(n STRING) LANGUAGE PYTHON_MAP { res = _conn.execute("SELECT max(d) FROM mytable;") result = dict() result['n'] = str(res) return result }; SELECT * FROM myfunc(); Which gives the following (expected) result: +----------------------+ | n | +======================+ | {'L1': array([ 5.])} | +----------------------+ Regards, Mark ----- Original Message ----- From: "Stefano Fioravanzo" To: "users-list" Sent: Monday, June 6, 2016 10:58:37 AM Subject: Re: segmentation fault with loopback query Done! Stefano

...

On 06 Jun 2016, at 10:43, Stefan Manegold wrote:

Dear Stefano,

a segfault is always a bug. Please file a bug report via http://bugs.monetdb.org/

Thanks! Stefan

----- On Jun 6, 2016, at 10:38 AM, Stefano Fioravanzo fioravanzos@gmail.com wrote:

...
Hello,

I am trying to execute a loopback query in embedded python:

CREATE FUNCTION myfunc() RETURNS TABLE(n STRING) LANGUAGE PYTHON { res = _conn.execute("SELECT max(d) FROM mytable;")

result = dict() result['n'] = str(res) return result };

When accessing the object ‘res’, mserver5 outputs ‘segmentation fault’ and exits. I think that the issue is in using the max() function in the query, if I leave that out everything works fine. The function:

CREATE FUNCTION myfunc() RETURNS TABLE(n STRING) LANGUAGE PYTHON { res = _conn.execute("SELECT d FROM mytable;")

result = dict() result['n'] = str(res) return result };

outputs a correct dictionary.

Stefano _______________________________________________ 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) | _______________________________________________ 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

Stefano Fioravanzo

9:38 a.m.

Your piece of code does not work for me, sadly. Still gives segmentation fault. Monet version: MonetDB v11.22.0 (unreleased) Python version: 2.7.6 Stefano

...

On 06 Jun 2016, at 11:10, Mark Raasveldt wrote:

Hey Stefano,

Could you make a reproducible example? The trivial example I made using the UDF you provided does not result in a segfault. This is the example I tested:

CREATE TABLE mytable(i DOUBLE, d DOUBLE); INSERT INTO mytable VALUES (1, 1), (2, 2), (3, 3), (4, 4), (5, 5);

CREATE FUNCTION myfunc() RETURNS TABLE(n STRING) LANGUAGE PYTHON_MAP { res = _conn.execute("SELECT max(d) FROM mytable;") result = dict() result['n'] = str(res) return result };

SELECT * FROM myfunc();

Which gives the following (expected) result:

+----------------------+ | n | +======================+ | {'L1': array([ 5.])} | +----------------------+

Regards,

Mark

----- Original Message ----- From: "Stefano Fioravanzo" To: "users-list" Sent: Monday, June 6, 2016 10:58:37 AM Subject: Re: segmentation fault with loopback query

Done! Stefano

...
On 06 Jun 2016, at 10:43, Stefan Manegold wrote:

Dear Stefano,

a segfault is always a bug. Please file a bug report via http://bugs.monetdb.org/

Thanks! Stefan

----- On Jun 6, 2016, at 10:38 AM, Stefano Fioravanzo fioravanzos@gmail.com wrote:

...
Hello,

I am trying to execute a loopback query in embedded python:

CREATE FUNCTION myfunc() RETURNS TABLE(n STRING) LANGUAGE PYTHON { res = _conn.execute("SELECT max(d) FROM mytable;")

result = dict() result['n'] = str(res) return result };

When accessing the object ‘res’, mserver5 outputs ‘segmentation fault’ and exits. I think that the issue is in using the max() function in the query, if I leave that out everything works fine. The function:

CREATE FUNCTION myfunc() RETURNS TABLE(n STRING) LANGUAGE PYTHON { res = _conn.execute("SELECT d FROM mytable;")

result = dict() result['n'] = str(res) return result };

outputs a correct dictionary.

Stefano _______________________________________________ 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) | _______________________________________________ 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

Mark Raasveldt

9:53 a.m.

Interesting, perhaps you are running an older version? I'm runnning MonetDB 5 server v11.24.0 (unreleased) with Python 2.7.5 and that seems to work for me. Where did you get the source code, how did you compile it and with which parameters are you starting mserver? Perhaps you could try the latest default branch and see if that works for you. ----- Original Message ----- From: "Stefano Fioravanzo" To: "users-list" Sent: Monday, June 6, 2016 11:38:31 AM Subject: Re: segmentation fault with loopback query Your piece of code does not work for me, sadly. Still gives segmentation fault. Monet version: MonetDB v11.22.0 (unreleased) Python version: 2.7.6 Stefano

...

On 06 Jun 2016, at 11:10, Mark Raasveldt wrote:

Hey Stefano,

Could you make a reproducible example? The trivial example I made using the UDF you provided does not result in a segfault. This is the example I tested:

CREATE TABLE mytable(i DOUBLE, d DOUBLE); INSERT INTO mytable VALUES (1, 1), (2, 2), (3, 3), (4, 4), (5, 5);

CREATE FUNCTION myfunc() RETURNS TABLE(n STRING) LANGUAGE PYTHON_MAP { res = _conn.execute("SELECT max(d) FROM mytable;") result = dict() result['n'] = str(res) return result };

SELECT * FROM myfunc();

Which gives the following (expected) result:

+----------------------+ | n | +======================+ | {'L1': array([ 5.])} | +----------------------+

Regards,

Mark

----- Original Message ----- From: "Stefano Fioravanzo" To: "users-list" Sent: Monday, June 6, 2016 10:58:37 AM Subject: Re: segmentation fault with loopback query

Done! Stefano

...
On 06 Jun 2016, at 10:43, Stefan Manegold wrote:

Dear Stefano,

a segfault is always a bug. Please file a bug report via http://bugs.monetdb.org/

Thanks! Stefan

----- On Jun 6, 2016, at 10:38 AM, Stefano Fioravanzo fioravanzos@gmail.com wrote:

...
Hello,

I am trying to execute a loopback query in embedded python:

CREATE FUNCTION myfunc() RETURNS TABLE(n STRING) LANGUAGE PYTHON { res = _conn.execute("SELECT max(d) FROM mytable;")

result = dict() result['n'] = str(res) return result };

When accessing the object ‘res’, mserver5 outputs ‘segmentation fault’ and exits. I think that the issue is in using the max() function in the query, if I leave that out everything works fine. The function:

CREATE FUNCTION myfunc() RETURNS TABLE(n STRING) LANGUAGE PYTHON { res = _conn.execute("SELECT d FROM mytable;")

result = dict() result['n'] = str(res) return result };

outputs a correct dictionary.

Stefano _______________________________________________ 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) | _______________________________________________ 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

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

3127

Age (days ago)

3127

Last active (days ago)

List overview

Download

5 comments

3 participants

participants (3)

Mark Raasveldt
Stefan Manegold
Stefano Fioravanzo