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.h<http://dev.monetdb.org/hg/MonetDB/file/a035a0351643/sql/backends/monet5/UDF/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
> >
>
> _______________________________________________
> 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