how to debug and use user defined functions?

Martin Kersten Martin.Kersten at cwi.nl
Fri Jul 5 10:13:04 CEST 2013


Hi
You want to use an embedded version of MonetDB?
That calls for quite some effort.

regards, Martin

On 7/5/13 4:49 AM, hlfwm hlfwm wrote:
> Hi everyone,
>
> I want to know how to call my user defined function binarycopy()
> in MonetDB/sql/backends/monet5/UDF/svom.c in another C program?
>
> I dont want to use my UDF i sql client but want to use as a C API.
>
>
> Thanks!
> Meng
>
>
> 2013/7/4 hlfwm hlfwm <hlfwmqd at gmail.com <mailto:hlfwmqd at gmail.com>>
>
>     Another important question is how to call my defined function by a
>     user to test it?
>
>     I mean not called in sql client , but in another C program.
>
>
>     Thanks !
>
>     Meng
>
>
>     2013/7/4 hlfwm hlfwm <hlfwmqd at gmail.com <mailto:hlfwmqd at gmail.com>>
>
>         Hi,
>
>         when i use my UDF in sql , i got :
>
>         *sql>select binarycopy('starid','10000',1);*
>         TypeException:user.s6_1[5]:'svom.binarycopy' undefined in:
>         _9:any := svom.binarycopy(_6:str, _7:str, _8:int)
>         program contains errors
>
>         anyone knows what mean by what is undefined in _9:any???
>
>
>
>         2013/7/3 hlfwm hlfwm <hlfwmqd at gmail.com <mailto:hlfwmqd at gmail.com>>
>
>             Hi Stefan,
>
>             Thanks very much, i entered into gdb debug and set a
>             breakpoint at binaryCopy,
>
>             (gdb) b binaryCopy
>             Note: breakpoint 1 (permanent) also set at pc 0x7fffee687f2a.
>             Breakpoint 2 at 0x7fffee687f2a: file svom.c, line 36.
>
>             but how could i debug my defined function and step into it,
>             how to enter my function?
>
>             Best regards,
>             Meng
>
>
>             2013/7/2 Stefan Manegold <Stefan.Manegold at cwi.nl
>             <mailto:Stefan.Manegold at cwi.nl>>
>
>                 turn "lib_svom" into "lib__svom" (mind the double '_' as
>                 with udf & ssdb --- exactly the name difference you
>                 noticed and were wondering about ...) and things should
>                 work ... --- you also need to start with a newly created
>                 virgin empty database to ensure that all scripts in
>                 libdir/monetdb5/createdb (i.e., including your
>                 81_svom.sql) are executed (they are not expected to be
>                 idempotent and thus only executed with the first server
>                 start on a new virgin empty DB) ...
>
>                 ----- Original Message -----
>                  > hi, my Makefile.ag :
>                  >
>                  >
>                 [svomhpc at localhost/home/data1/download/new/MonetDB/sql/backends/monet5/UDF]$>cat
>                  > Makefile.ag
>                  > # The contents of this file are subject to the
>                 MonetDB Public License
>                  > # Version 1.1 (the "License"); you may not use this
>                 file except in
>                  > # compliance with the License. You may obtain a copy
>                 of the License
>                  > at
>                  > # http://www.monetdb.org/Legal/MonetDBLicense
>                  > #
>                  > # Software distributed under the License is
>                 distributed on an "AS IS"
>                  > # basis, WITHOUT WARRANTY OF ANY KIND, either express
>                 or implied. See
>                  > the
>                  > # License for the specific language governing rights
>                 and limitations
>                  > # under the License.
>                  > #
>                  > # The Original Code is the MonetDB Database System.
>                  > #
>                  > # The Initial Developer of the Original Code is CWI.
>                  > # Portions created by CWI are Copyright (C) 1997-July
>                 2008 CWI.
>                  > # Copyright August 2008-2013 MonetDB B.V.
>                  > # All Rights Reserved.
>                  >
>                  > INCLUDES = .. \
>                  >          ../../../include \
>                  >         ../../../common \
>                  >         ../../../storage \
>                  >         ../../../server \
>                  >         ../../../../monetdb5/modules/atoms \
>                  >         ../../../../monetdb5/modules/kernel \
>                  >         ../../../../monetdb5/mal \
>                  >         ../../../../monetdb5/modules/mal \
>                  >         ../../../../monetdb5/optimizer \
>                  >         ../../../../clients/mapilib \
>                  >         ../../../../common/options \
>                  >         ../../../../common/stream \
>                  >         ../../../../gdk
>                  >
>                  > lib__udf = {
>                  >         MODULE
>                  >         DIR = libdir/monetdb5
>                  >         SOURCES = udf.c udf.h udf_impl.h
>                  >         LIBS = ../../../../monetdb5/tools/libmonetdb5 \
>                  >                    ../../../../gdk/libbat
>                  > }
>                  >
>                  > lib__ssdb = {
>                  >         MODULE
>                  >         DIR = libdir/monetdb5
>                  >         SOURCES = ssdb.c ssdb.h
>                  >         LIBS = ../../../../monetdb5/tools/libmonetdb5 \
>                  >                 ../../../../gdk/libbat \
>                  >                 ../../../server/libsqlserver \
>                  >                 ../../../storage/libstore \
>                  >                 ../../../storage/bat/libbatstore \
>                  >
>                 ../../../storage/restrict/librestrictstore \
>                  >                 ../../../common/libsqlcommon \
>                  >                 ../../../../common/stream/libstream
>                  > }
>                  >
>                  > lib_svom = {
>                  >         MODULE
>                  >         DIR = libdir/monetdb5
>                  >         SOURCES = svom.c svom.h
>                  >         LIBS = ../../../../monetdb5/tools/libmonetdb5 \
>                  >                ../../../../gdk/libbat
>                  >                ../../../server/libsqlserver \
>                  >                ../../../storage/libstore \
>                  >                ../../../storage/bat/libbatstore \
>                  >
>                   ../../../storage/restrict/librestrictstore \
>                  >                ../../../common/libsqlcommon \
>                  >                ../../../../common/stream/libstream
>                  > }
>                  >
>                  > headers_mal = {
>                  >         HEADERS = mal
>                  >         DIR = libdir/monetdb5
>                  >         SOURCES = udf.mal ssdb.mal svom.mal
>                  > }
>                  >
>                  > headers_sql = {
>                  >         HEADERS = sql
>                  >         DIR = libdir/monetdb5/createdb
>                  >         SOURCES = 80_udf.sql 80_ssdb.sql 81_svom.sql
>                  > }
>                  >
>                  > headers_autoload = {
>                  >         HEADERS = mal
>                  >         DIR = libdir/monetdb5/autoload
>                  >         SOURCES = 80_udf.mal 80_ssdb.mal 81_svom.mal
>                  > }
>                  >
>                  > EXTRA_DIST_DIR = Tests
>                  >
>                  >
>                  > 2013/7/2 Stefan Manegold <Stefan.Manegold at cwi.nl
>                 <mailto:Stefan.Manegold at cwi.nl>>
>                  >
>                  > > There is no function "reverse" in UDF.
>                  > >
>                  > > What does `mserver5` say?
>                  > >
>                  > > Can you share your Makefile.ag?
>                  > >
>                  > > Stefan
>                  > >
>                  > > ----- Original Message -----
>                  > > > Hi Stefan,
>                  > > >
>                  > > > i double-checked my Makefile.ag, and mserver5
>                 start-up message:
>                  > > >
>                  > > > [svomhpc at localhost /home/data1/opt/MonetDB]$>*ps
>                 -ef|grep
>                  > > > monetdb*
>                  > > > svomhpc  19083     1  0 12:58 ?        00:00:00
>                 monetdbd start
>                  > > > mydbfarm2
>                  > > > svomhpc  19090 19083  0 12:58 ?        00:00:01
>                  > > > /home/data1/opt/MonetDB/bin/mserver5
>                  > > > --dbpath=/home/data1/mydbfarm2/mydb2
>                  > > > --set merovingian_uri
>                  > > > mapi:monetdb://localhost.localdomain:50000/mydb2
>                  > > > --set mapi_open false --set mapi_port 0 --set
>                 mapi_usock
>                  > > > /home/data1/mydbfarm2/mydb2/.mapi.sock --set
>                 monet_vault_key
>                  > > > /home/data1/mydbfarm2/mydb2/.vaultkey --set
>                 gdk_nr_threads 4
>                  > > > --set
>                  > > > max_clients 64 --set sql_optimizer default_pipe --set
>                  > > > monet_daemon
>                  > > > yes
>                  > > > svomhpc  19399 26416  0 13:16 pts/2    00:00:00
>                 grep --color=auto
>                  > > > monetdb
>                  > > > [svomhpc at localhost /home/data1/opt/MonetDB]$>
>                  > > > [svomhpc at localhost /home/data1/opt/MonetDB]$>
>                  > > > [svomhpc at localhost /home/data1/opt/MonetDB]$>
>                  > > > [svomhpc at localhost
>                 /home/data1/opt/MonetDB]$>*sudo gdb
>                  > > > /home/data1/opt/MonetDB/bin/mserver5 19090*
>                  > > > GNU gdb (GDB) Fedora (7.5.0.20120926-25.fc18)
>                  > > > Copyright (C) 2012 Free Software Foundation, Inc.
>                  > > > License GPLv3+: GNU GPL version 3 or later
>                  > > > <http://gnu.org/licenses/gpl.html
>                  > > > >
>                  > > > This is free software: you are free to change and
>                 redistribute
>                  > > > it.
>                  > > > There is NO WARRANTY, to the extent permitted by
>                 law.  Type "show
>                  > > > copying"
>                  > > > and "show warranty" for details.
>                  > > > This GDB was configured as "x86_64-redhat-linux-gnu".
>                  > > > For bug reporting instructions, please see:
>                  > > > <http://www.gnu.org/software/gdb/bugs/>...
>                  > > > Reading symbols from
>                 /home/data1/opt/MonetDB/bin/mserver5...done.
>                  > > > Attaching to program:
>                 /home/data1/opt/MonetDB/bin/mserver5,
>                  > > > process
>                  > > > 19090
>                  > > > Reading symbols from
>                  > > > /home/data1/opt/MonetDB/lib/libmonetdb5.so.14...done.
>                  > > > Loaded symbols for
>                 /home/data1/opt/MonetDB/lib/libmonetdb5.so.14
>                  > > > Reading symbols from
>                  > > > /home/data1/opt/MonetDB/lib/libbat.so.9...done.
>                  > > > Loaded symbols for
>                 /home/data1/opt/MonetDB/lib/libbat.so.9
>                  > > > Reading symbols from
>                  > > > /home/data1/opt/MonetDB/lib/libmapi.so.6...done.
>                  > > > Loaded symbols for
>                 /home/data1/opt/MonetDB/lib/libmapi.so.6
>                  > > > Reading symbols from
>                 /lib64/libuuid.so.1...Reading symbols from
>                  > > > /lib64/libuuid.so.1...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libuuid.so.1
>                  > > > Reading symbols from
>                 /lib64/libreadline.so.6...Reading symbols
>                  > > > from
>                  > > > /lib64/libreadline.so.6...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libreadline.so.6
>                  > > > Reading symbols from
>                 /lib64/libxml2.so.2...Reading symbols from
>                  > > > /lib64/libxml2.so.2...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libxml2.so.2
>                  > > > Reading symbols from
>                  > > > /home/data1/opt/MonetDB/lib/libstream.so.3...done.
>                  > > > Loaded symbols for
>                 /home/data1/opt/MonetDB/lib/libstream.so.3
>                  > > > Reading symbols from /lib64/libm.so.6...(no
>                 debugging symbols
>                  > > > found)...done.
>                  > > > Loaded symbols for /lib64/libm.so.6
>                  > > > Reading symbols from /lib64/libz.so.1...Reading
>                 symbols from
>                  > > > /lib64/libz.so.1...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libz.so.1
>                  > > > Reading symbols from /lib64/libbz2.so.1...Reading
>                 symbols from
>                  > > > /lib64/libbz2.so.1...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libbz2.so.1
>                  > > > Reading symbols from
>                 /lib64/libcurl.so.4...Reading symbols from
>                  > > > /lib64/libcurl.so.4...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libcurl.so.4
>                  > > > Reading symbols from
>                 /lib64/libpcre.so.1...Reading symbols from
>                  > > > /lib64/libpcre.so.1...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libpcre.so.1
>                  > > > Reading symbols from
>                 /lib64/libssl.so.10...Reading symbols from
>                  > > > /lib64/libssl.so.10...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libssl.so.10
>                  > > > Reading symbols from
>                 /lib64/libcrypto.so.10...Reading symbols
>                  > > > from
>                  > > > /lib64/libcrypto.so.10...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libcrypto.so.10
>                  > > > Reading symbols from /lib64/libdl.so.2...(no
>                 debugging symbols
>                  > > > found)...done.
>                  > > > Loaded symbols for /lib64/libdl.so.2
>                  > > > Reading symbols from /lib64/libpthread.so.0...(no
>                 debugging
>                  > > > symbols
>                  > > > found)...done.
>                  > > > [New LWP 19099]
>                  > > > [New LWP 19098]
>                  > > > [New LWP 19097]
>                  > > > [New LWP 19096]
>                  > > > [New LWP 19094]
>                  > > > [New LWP 19093]
>                  > > > [New LWP 19092]
>                  > > > [New LWP 19091]
>                  > > > [Thread debugging using libthread_db enabled]
>                  > > > Using host libthread_db library
>                 "/lib64/libthread_db.so.1".
>                  > > > Loaded symbols for /lib64/libpthread.so.0
>                  > > > Reading symbols from /lib64/libc.so.6...(no
>                 debugging symbols
>                  > > > found)...done.
>                  > > > Loaded symbols for /lib64/libc.so.6
>                  > > > Reading symbols from
>                 /lib64/ld-linux-x86-64.so.2...(no debugging
>                  > > > symbols
>                  > > > found)...done.
>                  > > > Loaded symbols for /lib64/ld-linux-x86-64.so.2
>                  > > > Reading symbols from
>                 /lib64/libtinfo.so.5...Reading symbols from
>                  > > > /lib64/libtinfo.so.5...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libtinfo.so.5
>                  > > > Reading symbols from
>                 /lib64/liblzma.so.5...Reading symbols from
>                  > > > /lib64/liblzma.so.5...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/liblzma.so.5
>                  > > > Reading symbols from
>                 /lib64/libidn.so.11...Reading symbols from
>                  > > > /lib64/libidn.so.11...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libidn.so.11
>                  > > > Reading symbols from
>                 /lib64/liblber-2.4.so.2...Reading symbols
>                  > > > from
>                  > > > /lib64/liblber-2.4.so.2...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/liblber-2.4.so.2
>                  > > > Reading symbols from
>                 /lib64/libldap-2.4.so.2...Reading symbols
>                  > > > from
>                  > > > /lib64/libldap-2.4.so.2...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libldap-2.4.so.2
>                  > > > Reading symbols from /lib64/librt.so.1...(no
>                 debugging symbols
>                  > > > found)...done.
>                  > > > Loaded symbols for /lib64/librt.so.1
>                  > > > Reading symbols from
>                 /lib64/libgssapi_krb5.so.2...Reading symbols
>                  > > > from
>                  > > > /lib64/libgssapi_krb5.so.2...(no debugging
>                 symbols found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libgssapi_krb5.so.2
>                  > > > Reading symbols from
>                 /lib64/libkrb5.so.3...Reading symbols from
>                  > > > /lib64/libkrb5.so.3...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libkrb5.so.3
>                  > > > Reading symbols from
>                 /lib64/libk5crypto.so.3...Reading symbols
>                  > > > from
>                  > > > /lib64/libk5crypto.so.3...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libk5crypto.so.3
>                  > > > Reading symbols from
>                 /lib64/libcom_err.so.2...Reading symbols
>                  > > > from
>                  > > > /lib64/libcom_err.so.2...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libcom_err.so.2
>                  > > > Reading symbols from /lib64/libssl3.so...Reading
>                 symbols from
>                  > > > /lib64/libssl3.so...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libssl3.so
>                  > > > Reading symbols from
>                 /lib64/libsmime3.so...Reading symbols from
>                  > > > /lib64/libsmime3.so...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libsmime3.so
>                  > > > Reading symbols from /lib64/libnss3.so...Reading
>                 symbols from
>                  > > > /lib64/libnss3.so...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libnss3.so
>                  > > > Reading symbols from
>                 /lib64/libnssutil3.so...Reading symbols from
>                  > > > /lib64/libnssutil3.so...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libnssutil3.so
>                  > > > Reading symbols from /lib64/libplds4.so...Reading
>                 symbols from
>                  > > > /lib64/libplds4.so...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libplds4.so
>                  > > > Reading symbols from /lib64/libplc4.so...Reading
>                 symbols from
>                  > > > /lib64/libplc4.so...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libplc4.so
>                  > > > Reading symbols from /lib64/libnspr4.so...Reading
>                 symbols from
>                  > > > /lib64/libnspr4.so...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libnspr4.so
>                  > > > Reading symbols from
>                 /lib64/libssh2.so.1...Reading symbols from
>                  > > > /lib64/libssh2.so.1...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libssh2.so.1
>                  > > > Reading symbols from /lib64/libresolv.so.2...(no
>                 debugging
>                  > > > symbols
>                  > > > found)...done.
>                  > > > Loaded symbols for /lib64/libresolv.so.2
>                  > > > Reading symbols from
>                 /lib64/libsasl2.so.2...Reading symbols from
>                  > > > /lib64/libsasl2.so.2...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libsasl2.so.2
>                  > > > Reading symbols from
>                 /lib64/libkrb5support.so.0...Reading symbols
>                  > > > from
>                  > > > /lib64/libkrb5support.so.0...(no debugging
>                 symbols found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libkrb5support.so.0
>                  > > > Reading symbols from
>                 /lib64/libkeyutils.so.1...Reading symbols
>                  > > > from
>                  > > > /lib64/libkeyutils.so.1...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libkeyutils.so.1
>                  > > > Reading symbols from /lib64/libgcc_s.so.1...(no
>                 debugging symbols
>                  > > > found)...done.
>                  > > > Loaded symbols for /lib64/libgcc_s.so.1
>                  > > > Reading symbols from /lib64/libcrypt.so.1...(no
>                 debugging symbols
>                  > > > found)...done.
>                  > > > Loaded symbols for /lib64/libcrypt.so.1
>                  > > > Reading symbols from
>                 /lib64/libselinux.so.1...Reading symbols
>                  > > > from
>                  > > > /lib64/libselinux.so.1...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libselinux.so.1
>                  > > > Reading symbols from
>                 /lib64/libfreebl3.so...Reading symbols from
>                  > > > /lib64/libfreebl3.so...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libfreebl3.so
>                  > > > Reading symbols from
>                  > > >
>                 /home/data1/opt/MonetDB/lib/monetdb5/lib_geom.so...done.
>                  > > > Loaded symbols for
>                  > > > /home/data1/opt/MonetDB/lib/monetdb5/lib_geom.so
>                  > > > Reading symbols from
>                 /lib64/libgeos_c.so.1...Reading symbols from
>                  > > > /lib64/libgeos_c.so.1...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libgeos_c.so.1
>                  > > > Reading symbols from
>                 /lib64/libgeos-3.3.2.so...Reading symbols
>                  > > > from
>                  > > > /lib64/libgeos-3.3.2.so...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libgeos-3.3.2.so
>                 <http://libgeos-3.3.2.so>
>                  > > > Reading symbols from /lib64/libstdc++.so.6...(no
>                 debugging
>                  > > > symbols
>                  > > > found)...done.
>                  > > > Loaded symbols for /lib64/libstdc++.so.6
>                  > > > Reading symbols from
>                  > > >
>                 /home/data1/opt/MonetDB/lib/monetdb5/lib_json.so...done.
>                  > > > Loaded symbols for
>                  > > > /home/data1/opt/MonetDB/lib/monetdb5/lib_json.so
>                  > > > Reading symbols from
>                  > > >
>                 /home/data1/opt/MonetDB/lib/monetdb5/lib_jaql.so...done.
>                  > > > Loaded symbols for
>                  > > > /home/data1/opt/MonetDB/lib/monetdb5/lib_jaql.so
>                  > > > Reading symbols from
>                  > > >
>                 /home/data1/opt/MonetDB/lib/monetdb5/lib_sql.so...done.
>                  > > > Loaded symbols for
>                  > > > /home/data1/opt/MonetDB/lib/monetdb5/lib_sql.so
>                  > > > Reading symbols from
>                  > > >
>                 /home/data1/opt/MonetDB/lib/monetdb5/lib_fits.so...done.
>                  > > > Loaded symbols for
>                  > > > /home/data1/opt/MonetDB/lib/monetdb5/lib_fits.so
>                  > > > Reading symbols from
>                 /lib64/libcfitsio.so.0...Reading symbols
>                  > > > from
>                  > > > /lib64/libcfitsio.so.0...(no debugging symbols
>                 found)...done.
>                  > > > (no debugging symbols found)...done.
>                  > > > Loaded symbols for /lib64/libcfitsio.so.0
>                  > > > 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
>                  > > > 0x0000003efdeeb5f3 in select () from /lib64/libc.so.6
>                  > > > Missing separate debuginfos, use: debuginfo-install
>                  > > > bzip2-libs-1.0.6-7.fc18.x86_64
>                 cfitsio-3.300-2.fc18.x86_64
>                  > > > cyrus-sasl-lib-2.1.23-36.fc18.x86_64
>                 geos-3.3.2-3.fc18.x86_64
>                  > > > glibc-2.16-24.fc18.x86_64
>                 keyutils-libs-1.5.5-3.fc18.x86_64
>                  > > > krb5-libs-1.10.3-5.fc18.x86_64
>                 libcom_err-1.42.5-1.fc18.x86_64
>                  > > > libcurl-7.27.0-4.fc18.x86_64
>                 libgcc-4.7.2-8.fc18.x86_64
>                  > > > libidn-1.25-3.fc18.x86_64
>                 libselinux-2.1.12-7.fc18.x86_64
>                  > > > libssh2-1.4.2-2.fc18.x86_64
>                 libstdc++-4.7.2-8.fc18.x86_64
>                  > > > libuuid-2.22.1-2.1.fc18.x86_64
>                 libxml2-2.9.0-3.fc18.x86_64
>                  > > > ncurses-libs-5.9-7.20121017.fc18.x86_64
>                 nspr-4.9.2-1.fc18.x86_64
>                  > > > nss-3.14-7.fc18.x86_64
>                 nss-softokn-freebl-3.14-5.fc18.x86_64
>                  > > > nss-util-3.14-1.fc18.x86_64
>                 openldap-2.4.33-3.fc18.x86_64
>                  > > > openssl-libs-1.0.1c-7.fc18.x86_64
>                 pcre-8.31-2.fc18.x86_64
>                  > > > readline-6.2-5.fc18.x86_64
>                 xz-libs-5.1.2-2alpha.fc18.x86_64
>                  > > > zlib-1.2.7-9.fc18.x86_64
>                  > > > (gdb) *b reverse*
>                  > > > Function "reverse" not defined.
>                  > > > Make breakpoint pending on future shared library
>                 load? (y or [n])
>                  > > > n
>                  > > > (gdb) *b udf.reverse*
>                  > > > Function "udf.reverse" not defined.
>                  > > > Make breakpoint pending on future shared library
>                 load? (y or [n])
>                  > > > n
>                  > > > (gdb)* b binaryCopy*
>                  > > > Function "binaryCopy" not defined.
>                  > > > Make breakpoint pending on future shared library
>                 load? (y or [n])
>                  > > > n
>                  > > > (gdb) *b binarycopy*
>                  > > > Function "binarycopy" not defined.
>                  > > > Make breakpoint pending on future shared library
>                 load? (y or [n])
>                  > > > n
>                  > > >
>                  > > > gdb still find binarycopy and udf
>                 functions............
>                  > > >
>                  > > >
>                  > > > 2013/6/29 Stefan Manegold <Stefan.Manegold at cwi.nl
>                 <mailto:Stefan.Manegold at cwi.nl>>
>                  > > >
>                  > > > > 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 at cwi.nl <mailto:Stefan.Manegold at 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 at 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 at localhost
>                  > > > > > > > /home/data1/opt/MonetDB/lib/monetdb5]$>ll
>                  > > > > > > > -rwxr-xr-x. 1 svomhpc svomhpc    1180 Jun
>                 28 11:18
>                  > > > > > > > lib_fits.la <http://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 <http://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 <http://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 <http://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 <http://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
>                 <http://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 <http://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 <http://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 <http://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 <http://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 <http://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
>                 <http://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 at telecom.pt <mailto:miguel.ping at 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 at 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 at monetdb.org
>                 <mailto:users-list at monetdb.org>
>                  > > > > > > > >
>                 http://mail.monetdb.org/mailman/listinfo/users-list
>                  > > > > > > > >
>                  > > > > > > > >
>                  > > > > > > >
>                  > > > > > > >
>                 _______________________________________________
>                  > > > > > > > users-list mailing list
>                  > > > > > > > users-list at monetdb.org
>                 <mailto:users-list at monetdb.org>
>                  > > > > > > >
>                 http://mail.monetdb.org/mailman/listinfo/users-list
>                  > > > > > > >
>                  > > > > > >
>                  > > > > > > --
>                  > > > > > > | Stefan.Manegold at CWI.nl | DB Architectures
>                    (DA) |
>                  > > > > > > | www.CWI.nl/~manegold/
>                 <http://www.CWI.nl/~manegold/>  | Science Park 123 (L321) |
>                  > > > > > > | +31 (0)20 592-4212     | 1098 XG
>                 Amsterdam  (NL) |
>                  > > > > > >
>                  > > > > > > _______________________________________________
>                  > > > > > > users-list mailing list
>                  > > > > > > users-list at monetdb.org
>                 <mailto:users-list at monetdb.org>
>                  > > > > > >
>                 http://mail.monetdb.org/mailman/listinfo/users-list
>                  > > > > > >
>                  > > > > >
>                  > > > > > _______________________________________________
>                  > > > > > users-list mailing list
>                  > > > > > users-list at monetdb.org
>                 <mailto:users-list at monetdb.org>
>                  > > > > >
>                 http://mail.monetdb.org/mailman/listinfo/users-list
>                  > > > > >
>                  > > > >
>                  > > > > --
>                  > > > > | Stefan.Manegold at CWI.nl | DB Architectures
>                 (DA) |
>                  > > > > | www.CWI.nl/~manegold/
>                 <http://www.CWI.nl/~manegold/>  | Science Park 123 (L321) |
>                  > > > > | +31 (0)20 592-4212     | 1098 XG Amsterdam
>                   (NL) |
>                  > > > >
>                  > > > > _______________________________________________
>                  > > > > users-list mailing list
>                  > > > > users-list at monetdb.org
>                 <mailto:users-list at monetdb.org>
>                  > > > > http://mail.monetdb.org/mailman/listinfo/users-list
>                  > > > >
>                  > > >
>                  > > > _______________________________________________
>                  > > > users-list mailing list
>                  > > > users-list at monetdb.org
>                 <mailto:users-list at monetdb.org>
>                  > > > http://mail.monetdb.org/mailman/listinfo/users-list
>                  > > >
>                  > >
>                  > > --
>                  > > | Stefan.Manegold at CWI.nl | DB Architectures   (DA) |
>                  > > | www.CWI.nl/~manegold/
>                 <http://www.CWI.nl/~manegold/>  | Science Park 123 (L321) |
>                  > > | +31 (0)20 592-4212     | 1098 XG Amsterdam  (NL) |
>                  > >
>                  > > _______________________________________________
>                  > > users-list mailing list
>                  > > users-list at monetdb.org <mailto:users-list at monetdb.org>
>                  > > http://mail.monetdb.org/mailman/listinfo/users-list
>                  > >
>                  >
>                  > _______________________________________________
>                  > users-list mailing list
>                  > users-list at monetdb.org <mailto:users-list at monetdb.org>
>                  > http://mail.monetdb.org/mailman/listinfo/users-list
>                  >
>
>                 --
>                 | Stefan.Manegold at CWI.nl | DB Architectures   (DA) |
>                 | www.CWI.nl/~manegold/ <http://www.CWI.nl/~manegold/>
>                   | Science Park 123 (L321) |
>                 | +31 (0)20 592-4212     | 1098 XG Amsterdam  (NL) |
>
>                 _______________________________________________
>                 users-list mailing list
>                 users-list at monetdb.org <mailto:users-list at monetdb.org>
>                 http://mail.monetdb.org/mailman/listinfo/users-list
>
>
>
>
>
>
>
> _______________________________________________
> users-list mailing list
> users-list at monetdb.org
> http://mail.monetdb.org/mailman/listinfo/users-list
>



More information about the users-list mailing list