Failed make check tests

David Venus <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAPhOLBOaE3igDy7CNkG_1-UnyCh0=X9z4VCYOVNYR-2ZN_zYyg@mail.gmail.com>
Hi!

Now that the builds on AIX 7.1 with GCC 4.6.1 have completed successfully I
have run make check and had 3 of 34 tests fail. Are any of
these failures something to be concerned about?

In case it makes a difference here is the command line used to configure
FreeTDS:

LDFLAGS=-L/opt/oracle/local/lib ./configure --prefix=/opt/oracle/local
-with-unixodbc=/opt/oracle/local/unixODBC-2.3.2-pre \
         --enable-shared --with-tdsver=7.0 --enable-msdblib

Below are the tests that failed in both FreeTDS-0.91 stable and patched.
All of them appear to come in DBLIB. The tests were
run against a SQL Server 8.0.2055 instance and a SQL Server 9.0.5000
instance. Same errors on both. These are representative
of SQL Servers in my environment.

Failed to create procedure #t0022. Wrong permission or not MSSQL.
trying to create a permanent stored procedure
Dropping procedure t0022
      1: IF OBJECT_ID('t0022') IS NOT NULL DROP PROC t0022
Creating procedure t0022
      1: CREATE PROCEDURE t0022
      2:   @null_input varchar(30) OUTPUT
      3: , @first_type varchar(30) OUTPUT
      4: , @nullout int OUTPUT
      5: , @nrows int OUTPUT
      6: , @c varchar(20)
      7: , @nv nvarchar(20) = N'hello'
      8: AS
      9: BEGIN
     10: if @null_input is not NULL begin
     11:     select 'error: should be NULL' as status, @null_input as
'null_input'
     12:     return -42
     13: end else begin
     14:     print '@null_input is NULL, as expected'
     15: end
     16: if @c is not NULL begin
     17:     select 'error: should be NULL' as status, @c as '@c'
     18:     return -42
     19: end else begin
     20:     print 'Good: @c is NULL'
     21: end
     22: select @null_input = max(convert(varchar(30), name)) from systypes
     23: select @first_type = min(convert(varchar(30), name)) from systypes
     24: select name from sysobjects where 0=1
     25: select distinct convert(varchar(30), name) as 'type'  from
systypes
     26: where name in ('int', 'char', 'text')
     27: select @nrows = @@rowcount
     28: select distinct @nv as '@nv', convert(varchar(30), name) as name
from sysobjects where type = 'S'
     29: select      @null_input as 'null_input'
     30:     , @first_type as 'first_type'
     31:     , @nullout as 'nullout'
     32:     , @nrows as 'nrows'
     33:     , @c as 'c'
     34:     , @nv as 'nv'
     35:     into #parameters
     36: select * from #parameters
     37: return 42
     38: END
     39:
Created procedure t0022
executing dbrpcinit
executing dbrpcparam for @null_input
executing dbrpcparam for @first_type
executing dbrpcparam for @nullout
executing dbrpcparam for @nrows
executing dbrpcparam for @c
executing dbrpcparam for @nv
executing dbrpcsend
Failed line 246: dbrpcsend
FAIL: rpc

-----------------------------------------------------------------------------------------

      1: select colid, cast(c.name as varchar(30)) as name, c.length , '
'+ substring('NY', convert(bit,(c.status & 8))+1,1) as Nulls from
syscolumns as c left join systypes as t on c.usertype = t.usertype where
c.id = object_id('all_types_bcp_unittest') order by colid
colid  name                           length Nulls
------ ------------------------------ ------ -----
1      not_null_bit                   1        N
2      not_null_char                  10       N
3      not_null_varchar               10       N
4      not_null_datetime              8        N
5      not_null_smalldatetime         4        N
6      not_null_money                 8        N
7      not_null_smallmoney            4        N
8      not_null_float                 8        N
9      not_null_real                  4        N
10     not_null_decimal               5        N
11     not_null_numeric               5        N
12     not_null_int                   4        N
13     not_null_smallint              2        N
14     not_null_tinyint               1        N
15     nullable_char                  10       Y
16     nullable_varchar               10       Y
17     nullable_datetime              8        Y
18     nullable_smalldatetime         4        Y
19     nullable_money                 8        Y
20     nullable_smallmoney            4        Y
21     nullable_float                 8        Y
22     nullable_real                  4        Y
23     nullable_decimal               5        Y
24     nullable_numeric               5        Y
25     nullable_int                   4        Y
26     nullable_smallint              2        Y
27     nullable_tinyint               1        Y
ok
preparing to insert into TestDB..all_types_bcp_unittest ... OK
DB-LIBRARY error (dberr 20010 (severity 8): "Unable to allocate sufficient
memory"; oserr 0: "Error 0")
error: no unanticipated errors allowed in unit tests
FAIL: bcp

---------------------------------------------------------------------------------------

Starting ./timeout
About to logon
About to open TestServer.TestDB
using 3 1-second login timeouts
connected.
using 3 3-second query timeouts
issuing a query that will take 30 seconds
          1: select getdate() as 'begintime' waitfor delay '00:00:30'
select get
date() as 'endtime'
executing dbsqlok
in chkintr, 1 seconds elapsed
in chkintr, 2 seconds elapsed
in chkintr, 3 seconds elapsed
1 timeouts received in 3 seconds, continuing to wait
in chkintr, 4 seconds elapsed
in chkintr, 5 seconds elapsed
in chkintr, 6 seconds elapsed
2 timeouts received in 6 seconds, continuing to wait
DB-LIBRARY error (severity 1, dberr 20047, oserr 0, dberrstr DBPROCESS is
dead
or not enabled, oserrstr Error 0):
error: dbproc (20012f88) is DEAD, goodbye
FAIL: timeout

---------------------------------------------------------------------------------------------------------------

What other information can I provide that would be helpful?

Any suggestions, hints, tips, tricks, etc. gratefully accecpted!

Thanks!

Dave Venus
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.