yes, i do follow the two page, but i didn't use the udf_impl.h like file.


2013/6/29 Stefan Manegold <Stefan.Manegold@cwi.nl>
Did you follow the proper step to add a C-implemented UDF in MonetDB?

Cf.,
http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/UserDefinedFunction
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 <miguel.ping@telecom.pt>
>
> >  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
> > <start mclient, test>
> >
> > 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