Please double-check your Makefile.ag and make sure it look like the one in the canonical UDF example. Please double-check the messaged produced by your mserver5 at start-up. Stefan ----- Original Message -----
yes, i do follow the two page, but i didn't use the udf_impl.hhttp://dev.monetdb.org/hg/MonetDB/file/a035a0351643/sql/backends/monet5/UDF/... like file.
2013/6/29 Stefan Manegold
Did you follow the proper step to add a C-implemented UDF in MonetDB?
Cf.,
http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/UserDefinedFuncti... and http://dev.monetdb.org/hg/MonetDB/file/tip/sql/backends/monet5/UDF
for documentation and canonical example.
Stefan
----- Original Message -----
[svomhpc@localhost /home/data1]$>*sudo gdb /home/data1/opt/MonetDB/bin/mserver5 21260* [sudo] password for svomhpc: ............................ Reading symbols from /home/data1/opt/MonetDB/lib/monetdb5/lib_lsst.so...done. Loaded symbols for /home/data1/opt/MonetDB/lib/monetdb5/lib_lsst.so Reading symbols from /home/data1/opt/MonetDB/lib/monetdb5/lib_ssdb.so...done. Loaded symbols for /home/data1/opt/MonetDB/lib/monetdb5/lib_ssdb.so Reading symbols from /home/data1/opt/MonetDB/lib/monetdb5/lib_udf.so...done. Loaded symbols for /home/data1/opt/MonetDB/lib/monetdb5/lib_udf.so Reading symbols from /home/data1/opt/MonetDB/lib/monetdb5/lib_opt_sql_append.so...done. Loaded symbols for /home/data1/opt/MonetDB/lib/monetdb5/lib_opt_sql_append.so ................................................................... (gdb) b binarycopy Function "binarycopy" not defined.
accordiing to the above, the svom lib is not loaded.
[svomhpc@localhost /home/data1/opt/MonetDB/lib/monetdb5]$>ll -rwxr-xr-x. 1 svomhpc svomhpc 1180 Jun 28 11:18 lib_fits.la -rwxr-xr-x. 1 svomhpc svomhpc 66800 Jun 28 11:18 lib_fits.so -rwxr-xr-x. 1 svomhpc svomhpc 1192 Jun 28 11:18 lib_geom.la -rwxr-xr-x. 1 svomhpc svomhpc 75821 Jun 28 11:18 lib_geom.so -rwxr-xr-x. 1 svomhpc svomhpc 1170 Jun 28 11:18 lib_jaql.la -rwxr-xr-x. 1 svomhpc svomhpc 434287 Jun 28 11:18 lib_jaql.so -rwxr-xr-x. 1 svomhpc svomhpc 1170 Jun 28 11:18 lib_json.la -rwxr-xr-x. 1 svomhpc svomhpc 217026 Jun 28 11:18 lib_json.so -rwxr-xr-x. 1 svomhpc svomhpc 1170 Jun 28 11:18 lib_lsst.la -rwxr-xr-x. 1 svomhpc svomhpc 34435 Jun 28 11:18 lib_lsst.so -rwxr-xr-x. 1 svomhpc svomhpc 1230 Jun 28 11:18 lib_opt_sql_append.la -rwxr-xr-x. 1 svomhpc svomhpc 30396 Jun 28 11:18 lib_opt_sql_append.so -rwxr-xr-x. 1 svomhpc svomhpc 1164 Jun 28 11:18 lib_sql.la -rwxr-xr-x. 1 svomhpc svomhpc 3026400 Jun 28 11:18 lib_sql.so -rwxr-xr-x. 1 svomhpc svomhpc 1170 Jun 28 11:18 lib_ssdb.la -rwxr-xr-x. 1 svomhpc svomhpc 1833811 Jun 28 11:18 lib_ssdb.so -rwxr-xr-x. 1 svomhpc svomhpc 1164 Jun 28 11:18 *libsvom.la* -rwxr-xr-x. 1 svomhpc svomhpc 29015 Jun 28 11:18 *libsvom.so* -rwxr-xr-x. 1 svomhpc svomhpc 1164 Jun 28 11:18 lib_udf.la -rwxr-xr-x. 1 svomhpc svomhpc 38231 Jun 28 11:18 lib_udf.so -rwxr-xr-x. 1 svomhpc svomhpc 1176 Jun 28 11:18 lib_vault.la -rwxr-xr-x. 1 svomhpc svomhpc 42556 Jun 28 11:18 lib_vault.so
i dont know why the name of libsvom.la is different from other libs, could anyone tell me how to correct the name?
Thanks!
Meng Wan
2013/6/26 Miguel Ping
I would do something like this:
ps -ef | grep mserver5
dude 27387 27358 0 17:46 ? 00:00:00 /usr/local/bin/mserver5 --set gdk_d... sudo gdb $(which mserver5) 27387
(gdb) b binaryCopy Breakpoint 1 at 0x7f71ef7b4000: file svom.c,... (gdb) continue
But if the error happens before hitting your function, I don't know how to debug.
On 06/26/2013 08:10 AM, hlfwm hlfwm wrote:
i defined a user defined function "binarycopy",when i use my function, there is error: sql>select binarycopy('starid','1111',1); TypeException:user.s1_1[5]:'svom.binarycopy' undefined in: _9:any := svom.binarycopy(_6:str, _7:str, _8:int) program contains errors
i want to debug the error with mal, there also some error:
[svomhpc@localhost /home/data1]$>mclient -l mal -u monetdb -d mydb4 password: Welcome to mclient, the MonetDB interactive terminal (unreleased) Type \q to quit, \? for a list of available commands mal> mal> mal>function test(i:int):str; mal>io.print(i); mal>i:=i*2; mal>b:=bat.new(:int,:int); mal>bat.insert(b,1,i); mal>io.print(b); mal>return test:= "ok"; mal>end test; MAPI = (monetdb) /tmp/.s.monetdb.50000 QUERY = end test; ERROR = !TypeException:user.test[3]:'bat.new' undefined in: b:any := bat.new(_5:int, _6:int) !TypeException:user.test[4]:'bat.insert' undefined in: _7:any := bat.insert(b:any, _8:int, i:int) mal>
could anyone tell me how to debug my function ,please?
Thanks!
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.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 http://mail.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.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) |