Switch to standard view 
  Sybase logo
 
 
 



Targeted CR List for ASE 12.5.3 ESD #5

The purpose of this document is to help Sybase customers obtain a general idea of potential bug fixes in future Adaptive Server Enterprise (ASE) EBF releases. Please be sure to read the Disclaimer and General Notes below.

Disclaimer: This document lists the targeted (not committed) fixed CR list for the release listed above. Please be aware that the purpose of this posting is solely to provide you, our customers with estimated release dates and targeted CR lists. Sybase does not commit to releasing EBFs on the specified dates or to including the CR fixes in the said EBF. While every effort will be made to meet the said targets, changes can occur at any time. It is also possible (although unlikely) that Sybase may decide not to release an EBF that was previously scheduled for release.

Bug ID Description
381231 The message "Type Code: 100019; Soft fault that has been upgraded to a hard fault OAM entry is present but there is no allocation." may be mistakenly reported by DBCC CHECKSTORAGE when it is run on a freshly loaded database dump and the given database dump was taken on a busy ASE environment initially.
385942 A new feature request to avoid error 7205 state 3 while a SITE HANDLER is destroying a SITEBUF.
387440 The error 8419 "Could not find index descriptor for objid < value > , indid < value > in dbid < value > ." may be raised during the recovery phase of a database with a stack trace reported in the error log with modules 'recovery', 'pg_zap_dealbit_db' and 'pg__recalc_oams'.
387954 Sub-optimal performances may be seen on queries with < LIKE > ... < ESCAPE > expressions
388889 CIS: Selecting from proxy MSSQL table involving builtin functions hextoint/inttohext could give an error "... not a recognized function name" from the backend server.
389364 ASE may prematurely enforce a resource limit for "tempdb_space" resulting in error 11056 "Exceeded tempdb space limit of < value > pages." being raised. This may happen due to some inaccurate accounting of tempdb space during the execution of DROP TABLE, TRUNCATE TABLE and CREATE INDEX commands.
390696 Wrong linenumbers could be reported while debugging a stored procedure using the sqldbgr program.
390760 Performance optimization and enhancements on Mac OS X 10.4.2
391178 The input parameter @table_name in sp_columns is limited to 32 characters. Passing in a name greater then 32 characters using [] to 'escape' special character _ for the LIKE clauses used in sp_columns, will cause sp_columns to return no results for that tablename.
392779 Disk Init on NFS : On AIX, performing a disk init of a very large device over an NFS share hangs indefinitely.
392963 The message "current process infected with 11" in the module 'ind__copy_row' together with a stack trace which includes the modules 'des__systs_flushall' and 'des_checkpoint' may be reported in the error log during dump database when the "number of open indexes" is under configured and Adaptive Server is configured to use more than one engines.
395732 During sec_session_close the Kerberos security session context is freed. During heavy login and disconnect processing the sec_memfree can get a segv.
395894 A 2631 error, "The maximum number of index levels '255' has been reached for index < indname > of table < tablename > in database < dbname > " may sometimes be encountered while inserting data into a clustered index with a large index key.
396144 The message "current process infected with 11" in the module 'memcpy' together with a stack trace which includes the modules 'ss_chartoblob' and 'run' may be reported in the error log during an UPDATE of a TEXT column using a J-connect program or a CT-library program that uses host variables. In some cases a 510 error, "Bad eop type 0x.." may be reported instead.
396296 Sub-optimal performances may be seen on queries with LIKE expression performed on a unichar or univarchar column.
396479 When an UPDATE that uses the tsequal() builtin function is done within a stored procedure, tsequal() no longer returns a timestamp value unless the 4080 trace flag is being used. When an UPDATE that uses the tsequal() builtin function is done outside a stored procedure, tsequal() returns a timestamp value in the TDS_RETURNVALUE token.
396708 A 15052 error, "Index error: Table id < id > , indid < id > calculated maxlen < value > does not match < value > in Sysindexes" may be reported by DBCC CHECKCATALOG on a table that has at least two bit columns, after ALTER TABLE was run to add/modify a variable length or NULL column.
397229 ASE running on Solaris 10 operating system encounters performance degradation when using asynchronous IO on file system devices. This is liable to manifest as severe performance degradation on single CPU machines and significant performance degradation on multi CPU machines under load. This is due to a bug in Solaris kernel, Sun BugID 6302167 install the following patch from Sun Support for resolving this performance problem. Solaris 10 SPARC: PatchID 120048-03 Solaris 10 x86/x64: PatchID 120049-03
397320 HAFAILOVER occurs on clients when killing a spid on ASE. The condition occurs when the spid is involved in a non-resultset transaction, such as insert into command. When the kill is issued, ASE is internally rolling back the transaction, and the HA Session id is still valid at this point. This enables the client to re-connect. Client should receive some sort of disconnect message instead, like jConnect JZ006 IOException, or isql operation terminated due to disconnect.
397658 If an LDAP server does not allow anonymous binds then one cannot set the "primary_url" and "dn_lookup_url" even if the "access_account" has been successfuly set.
398768 A 8206 error, "Object < negative number > was not found in WorkTabList" may be reported in the error log for a query referencing multiple times the same view and performing aggregates on view columns. This problem will happen only if the query is executed in the parallel mode.
398819 ASE reports "master device corrupt" even for the situation of missing master device when booting a server without providing the master device.
399440 UPDATE all STATISTICS on a proxy table that has partitions results in a stacktrace with Server Error Msg 1142 "Invalid OAM page 0"
399737 Under rare circumstances a session may hang forever during a lock request despite the session having send an interrupt request to ASE (Control-C). This may happen if the session was waiting initially for the lock request and ASE receives the attention request just before it awakes this session in order to initiate a deadlock search.
399972 Enable native XML support for HPIA64 platform
400368 Job Scheduler install fails when configuration parameter 'check password for digit' is enabled.
400554 The ipaddr column in sysprocesses may contain trailing junk when each field of the ip address contains 3 digits.
400662 Various errors related to the TEXT pointer inconsistency may be raised when executing a query under trace flag 289 and the query references a view with union and is using convert function on TEXT data.
400669 CIS: A 2762 error, "CREATE TABLE command is not allowed within multiple statement transaction" may be reported when executing a SQL INSERT..SELECT from proxy table mapped to a RPC. This is resolved with a server-wide traceflag 11232 or a session level traceflag 11228. Either traceflag has to be turned on to allow CREATE TABLE command in the remote procedure.
400797 HA: When a cross database 'drop table' operation is performed on the primary node of an HA configuration, the operation succeeds on the primary but fails on the proxy database on the secondary node without error.
401092 When LDAP User Authentication feature is enabled and the LDAP directory service does not respond to connection or search requests from ASE, logins attempts will hang. This prevents further authentication requests from succeeding on any engine where this occurs. Messages such as "Waiting for native threads to be released, or for 'max number of native threads' to be increased." appear repeatedly in the errorlog after a number of login requests become blocked. When this message appears in the errorlog, other use of native threads are also prevented.
401167 On 64-bit platforms, an infected with 11 message followed by a stacktrace may appear in the ASE error log due to the execution of the sp_shmdumpconfig stored procedure when a "message" type dump condition is configured in ASE.
401281 Negative zero value may be inserted into a float column on HP-UX and Linux platforms only.
401306 Enable native XML support for Linux AMD64 platform.
401595 A 702 error, "Memory request for 49858 bytes exceeds the size of single page of 16384 bytes." together with a stack trace which includes the modules 'cpyconstvalue' and 'memalloc' may be reported in the error log for a SELECT INTO statement with a aggregate on a string longer then 16384 characters.
401718 proc_role() may return incorrect results if run in parallel.
402044 Incorect value may be assignment to the local variable if the query is executed in the parallel and the query has a scalar aggregate. This problem may happen if the showplan output shows multiple query steps with "Parallel result buffer merge" execution strategy.
402240 If user applies the ESD over $SYBASE that was copied from another directory, the installer produces a warning message and ask if he/she wants to continue. If the user chooses "No", the installer displays the same warning message and quesion again. He/She cannot exit this infinite loop.
402274 Query with equi-sargs predicates containing IS NULL on indexed columns can result in wrong selectivity estimation.
402536 XPServer fails to start on linuxia64 platform with default value of "esp execution stacksize" parameter.
402717 After the cross platform dump and load (XPDL), the space utilization is not handled correctly, and an index is unnecessarily rebuilt by sp_post_xpload, if variable length index key was greater than 252 bytes. Also some page corruptions happen in DOL index root page, in DOL non-leaf index page for UNICHAR NOT NULL index key in some cases, and in a special case of slice control page if the database dump is from 11.9.x.
402835 The message "current process infected with 11" in the module 'dbt_unkeep' followed by a stack trace may be reported in the error log when a session is detaching from an external transaction and the revert to the database that was active at the time of the attach has failed. The modules 'xact__detach_external' and 'closedb' will also be reported. As a result an implicit shut down of ASE will occur.
403382 CIS: In some circumstances, running sp_showplan on a multi-engine server with sessions involving CIS query or MDA tables may be infected with signal 10 or 11 and core dumps, or causes ASE to hang.
403592 Error 4022 should have a severity of 10, but a severity of 16 is raised which results in ODBC connections being refused.
403972 On SuSE 32 bit Linux platform (SuSE 9 SP1 or later), ASE incorrectly identifies AIO to be KAIO while using Posix AIO. This can lead to ASE hang. Solution is to start ASE with trace flag 1630.
403996 Job Scheduler Agent has problems with Japanese job command text.
404123 CIS: When a table is marked for replication with sp_setreptable, updating the table with text or image data using UPDATE or INSERT-SELECT command from a proxy XFS table results in 605 or 806 error.
404355 The system stored procedure SP_HELPCACHE may report an inacurrate name value for a given user-defined cache, if it was created with a long name initially.
404470 UPDATE PARTITION STATISTICS raises error 9810 with a stacktrace containing the function call sl_update_ctrlpg_pagecnt
404751 When the option SET ROWCOUNT is set within a procedure where SET EXPORT_OPTIONS is ON, the option is not exported to the procedure caller.
405315 If the "number of open objects" is under configured, the message "current process infected with 11" in the module 'crc_ckconstr' together with a stack trace which includes the modules 'crt_main' and 'crt_constr' may be reported during the creation of a table. Similarly, the message "current process infected with 11" in the module 'procrm' together with a stack trace which includes the modules 's_recompile' and 's_rmpbuf' may be reported during the execution of a stored procedure.
405460 At login time, if the password has expired, it is possible that a shared page lock on syslogins is not released after the login has completed.
406060 An 8201 error "Keep count of descriptor ... was expected to be 1. Instead 2 was found." may be raised during LOAD TRAN or LOAD DATABASE, when the configuration parameter "per object statistics active" is turned on.
406166 Due to packaging error, ASE Plugin included in 12.5.3 ESD#3 and ESD#4 cause following errors. When ASE Plug-in that is coded with JRE 1.4 is run with 1.3 JVM, it gives stack trace during Create Table which results in a stack trace that says java.lang.NoSuchMethodError. When ASE Plug-in that is coded with JRE 1.3 is run with 1.4 JVM, focus error will be seen during Create Table.
406314 The changes included in OCS 12.5.1 ESD#10 include fixes for the following issues: SCL/Kerberos memory leaks on successful connections when using MIT Kerberos, CR 385928. After many hundreds or thousands of successful Kerberos connections, memory leak resulted in memory allocation errors in the errorlog and authentication errors returned to clients. The memory allocation errors reported: "Security Control Layer's memory allocation routine returned an error." An API change occurred to OCS internal functions used by Security Control Layer (SCL) drivers called by ASE. The request ID changed to type long to handle 64bit request ID used by SCL and DCL drivers. CR 384600, the associated OCS fix, avoids a segmentation violation that can occur on 64 bit platforms when using Kerberos or Directory Services lookups.
406473 ASE 12.5.1 or later versions prior to 12.5.3 ESD #5 and version 15.0 treat block device the same as raw device. ASE assumes all writes have been committed to disk, while the modified pages may be retained in the OS kernel cache. In the event of a power failure or other system crashes, the cached modifications may be lost leading to data inconsistency.
406547 In rare circumstances, the message "current process infected with 11" or a timeslice error may be reported in the error log during boot time after recovery processes a PFTS log record that contains information about a bogus page number.
406623 SCL error messages are not available to display on engine 1 and greater. Instead of the text message explaining the error that occured, the following message appears: 01:00000:00049:2005/10/12 15:59:25.84 kernel Failed to get the Connectivity Library (Security Control Layer) error message.
406630 When Kerberos or other SCL authentication mechanisms are used and 1601 errors such as the following occur due to attempts to exceed the limit of "user connection" resources, then a memory leak occurs. server There are not enough 'user connections' available to start a new process. Retry when there are fewer active users, or ask your System Administrator to reconfigure SQL Server with more user connections. server Error: 1601, Severity: 17, State: 7 After memory in the pool used by these authentication mechanisms is exhausted, memory allocation failures and segmentation violations occur with continued authentication attempts. Memory allocation failures appear with message: server Security Control Layer's memory allocation routine returned an error. Segmentation violations due to attempts to use invalid addresses appear with message: kernel current process (0x11200025) infected with 11 kernel Address 0xff130988 (memset+0x74), siginfo (code, address) = (1, 0x00000000) These messages may be accompanied with or without stacktraces in the errorlog.
406718 Sometimes, mainly on single CPU machines, if the job scheduler is enabled, then the job scheduler may fail to start and the message "Job Scheduler Task failed to spawn an Agent" is reported in the ASE errorlog.
408384 A 8211 error, "Mismatch found between the name and id descriptor hash table for table < internal LWP name = (* + number + alfanumeric suffix) > , objid = < negative number > . Descriptor hashed by name = 0x0 and hashed by id = < hexadecimal number > ." together with a stack trace which includes the modules 'lwp_create' and 'des_lwpdescreate' maybe be reported in the errorlog if a client application connection has executed a high number of dynamic sql statements without disconnecting from Adaptive Server. In the same conditions and if the same connection is holding a cursor open which uses internally a worktable then the message "current process infected with 11" in the module 'proc__install' may be reported in the error log and it could bring Adaptive Server down.
408596 In rare circumstances on a server that has been configured with large buffer pools, 644, 2628, 2511 or other similar errors may be reported after an update to a non-leaf index page table is lost.
415412 DDLGen generates 'null' in permissions statements. For eg. for pubs2 database, 'titles' table, some incorrect statements generated are: Grant null on dbo.titles to guest go Grant null on dbo.titles to guest go
415412 DDLGen generates 'null' in permissions statements. For eg. for pubs2 database, 'titles' table, some incorrect statements generated are: Grant null on dbo.titles to guest go Grant null on dbo.titles to guest go


Back to Top
© Copyright 2010, Sybase Inc.