Re: bsqldb crashes, fisql does not give the desired results

Sorry, I didn't note I don't have all required tables. Can you do and send
a dump (TDSDUMP) ?

Frediano


2014-07-02 17:33 GMT+01:00 Frantisek Hanzlik <[email protected]>:

> I'm absolute newbie in SQL, thus please forgive me if I do something
> stupid.
> I tried run this script (which is working fine with
> \Program Files\Microsoft SQL Server\90\Tools\Binn\osql.exe
> from MS SQL server 2005 on Windows 2003 server) :
>
>
> --- script begin
> declare
>         @CityOd varchar(10),
>         @CityDo varchar(10),
>         @datumStavu datetime
>
> set @CityOd = 'ADAMOV'
> set @CityDo = 'WIEN'
> set @datumStavu = '2014-07-02'
>
> create table #tmp(no_ varchar(20), up decimal(38,20),
> s12 decimal(38,20), s14 decimal(38,20), s5416 decimal(38,20))
> declare c cursor for
> select No_, [Unit Price] from [MyDB$Item] k
> where [Item Category Code] = 'E-SHOP'
>
> declare @no varchar(20),
>         @up decimal(38,20),
>         @s12 decimal(38,20),
>         @s14 decimal(38,20),
>         @s5416 decimal(38,20)
>
> open c
> fetch c into @no, @up
> while @@fetch_status=0
> begin
>         SELECT @s12 = isnull(SUM([s12]),0),@s14=isnull(SUM([s14]),0) FROM
> [MyDB$TBL1]
>         WITH (READUNCOMMITTED)  WHERE (bucket=5 AND f2=@no AND
> ((f8>=@CityOd AND f8<=@CityDo)))
>         AND f3 < @datumStavu
>
>         SELECT @s5416=isnull(SUM([s5416]),0) FROM [MyDB$TBL2] WITH
> (READUNCOMMITTED)
>         WHERE (bucket=6 AND f1=1 AND f5=2 AND f6=@no AND ((f7>=@CityOd AND
> f7<=@CityDo)))
>         and f10 < @datumStavu
>
>         insert into #tmp values(@no, @up, @s12, @s14, @s5416)
>         fetch c into @no, @up
> end
> close c
> deallocate c
> select * from #tmp
> drop table #tmp
> go
> --- script end
>
> on bsqldb and fisql from freetds-0.91-6.gitf3ae29d.fc19.x86_64 on
> Fedora 19 x86_64.
>
> When I run bsqldb with params:
> -i SQL -U user -P pwd -S sqlsrv -D test -t " " -e SQLerr -o SQLout -h -v
>
> *** Error in `/bin/bsqldb': free(): invalid pointer: 0x000000000064ae00 ***
> ======= Backtrace: =========
> /lib64/libc.so.6[0x3b2607d0b8]
> /lib64/libsybdb.so.5(dbnextrow+0x369)[0x3ec820e1b9]
> /bin/bsqldb[0x40308b]
> /bin/bsqldb[0x4022a2]
> /lib64/libc.so.6(__libc_start_main+0xf5)[0x3b26021b45]
> /bin/bsqldb[0x402431]
> ======= Memory map: ========
> 00400000-00406000 r-xp 00000000 09:01 1736030
>  /usr/bin/bsqldb
> 00605000-00606000 r--p 00005000 09:01 1736030
>  /usr/bin/bsqldb
> 00606000-0060a000 rw-p 00006000 09:01 1736030
>  /usr/bin/bsqldb
> 0060a000-0064f000 rw-p 00000000 00:00 0
>  [heap]
> 3974200000-3974279000 r-xp 00000000 09:01 1707453
>  /usr/lib64/libfreebl3.so
> 3974279000-3974478000 ---p 00079000 09:01 1707453
>  /usr/lib64/libfreebl3.so
> ...
> 7ffff1ab2000-7ffff7fd7000 r--p 00000000 09:01 1734848
>  /usr/lib/locale/locale-archive
> 7ffff7fd7000-7ffff7fe3000 rw-p 00000000 00:00 0
> 7ffff7ff1000-7ffff7ff4000 rw-p 00000000 00:00 0
> 7ffff7ff4000-7ffff7ffb000 r--s 00000000 09:01 1734941
>  /usr/lib64/gconv/gconv-modules.cache
> 7ffff7ffb000-7ffff7ffd000 rw-p 00000000 00:00 0
> 7ffff7ffd000-7ffff7fff000 r-xp 00000000 00:00 0
>  [vdso]
> 7ffffffde000-7ffffffff000 rw-p 00000000 00:00 0
>  [stack]
> ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0
>  [vsyscall]
>
> Program received signal SIGABRT, Aborted.
> 0x0000003b260359e9 in __GI_raise (sig=sig@entry=6) at
> ../nptl/sysdeps/unix/sysv/linux/raise.c:56
> 56        return INLINE_SYSCALL (tgkill, 3, pid, selftid, sig);
>
> And stack backtrace is:
> #0  0x0000003b260359e9 in __GI_raise (sig=sig@entry=6) at
> ../nptl/sysdeps/unix/sysv/linux/raise.c:56
> #1  0x0000003b260370f8 in __GI_abort () at abort.c:90
> #2  0x0000003b26075d17 in __libc_message (do_abort=do_abort@entry=2,
> fmt=fmt@entry=0x3b2617e568 "*** Error in `%s': %s: 0x%s ***\n") at
> ../sysdeps/unix/sysv/linux/libc_fatal.c:196
> #3  0x0000003b2607d0b8 in malloc_printerr (ptr=<optimized out>,
> str=0x3b2617bc75 "free(): invalid pointer", action=3) at malloc.c:4937
> #4  _int_free (av=0x3b263ba780 <main_arena>, p=<optimized out>,
> have_lock=0) at malloc.c:3789
> #5  0x0000003ec820e1b9 in buffer_add_row (resinfo=0x614440,
> dbproc=0x6133c0) at buffering.h:500
> #6  dbnextrow (dbproc=dbproc@entry=0x6133c0) at dblib.c:2071
> #7  0x000000000040308b in print_results (dbproc=dbproc@entry=0x6133c0) at
> bsqldb.c:535
> #8  0x00000000004022a2 in main (argc=<optimized out>, argv=0x7fffffffe508)
> at bsqldb.c:210
>
>
>
> When I tried run this SQL script with 'fisql' with params:
> -i SQL -U user -P pwd -S sqlsrv -D test -e SQLerr -o SQLout -w 65500 -n
>
> then program run seemingly without error, but SQLout output is weird:
>
> no_
>        up s12 s14 s5416
> --------------------------------------------------------------------------------
> -- --- --- -----
> DB-LIBRARY error:
>         Data conversion resulted in overflow
> Operating-system error:
>         Success
> K2030446
>       -- --- --- -----
> DB-LIBRARY error:
>         Data conversion resulted in overflow
> Operating-system error:
>         Success
> K2030457
>       -- --- --- -----
> DB-LIBRARY error:
>         Data conversion resulted in overflow
> Operating-system error:
>         Success
> K2030469
>       -- --- --- -----
> DB-LIBRARY error:
>         Data conversion resulted in overflow
> Operating-system error:
>         Success
> K2030471
>       -- --- --- -----
> ...
>
>
> Can anyone advise me what I'm doing wrong?
>
> Thanks in advance, Franta Hanzlik
>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>