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
