Targeted CR List for ASE 12.5.4 ESD #6
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 |
|---|---|
| 329205 | Add new procedure, sp_showtext, that can re-generate the text from syscomments for compiled objects like procedures, triggers, views, so that the output matches exactly what was submitted by the user when creating the object. Output can be generated with line numbers, and also as a context block of SQL text around a given line number. Output can be generated as a stand-alone DDL script which can be then used to recreate the object in most cases. Use 'sp_showtext' without any arguments to get usage syntax help. |
| 351032 | If a user does not supply password when invoking DDLGen from command line, he will be prompted to enter the password from the console. |
| 358404 | Under very rare circumstances, some 821 or 813 errors may be raised for a very busy multi-engine ASE having a buffer cache shortage. |
| 398320 | The error 10302, "Only the DBO of database 'dbccdb' or a user with System Administrator (SA) role can run this command." will be incorrectly raised when a user without SA role different from the DBO executes DBCC CHECKVERIFY even if this access has been granted in the target database. |
| 398443 | In rare circumstances , an error message "Internal error, FDP API, fdp_get_memory() :Failed to allocate xxxxx bytes" may be logged in the ASE errorlog when sp_configure is executed. |
| 401066 | Error 3935, "Fatal protocol error. xact_beginupdate() API was invoked in the wrong context. The transaction is currently in 'Abort tran-attached' state." may be hit in module 'xact_beginupdate' with a stack trace in the error log, when a rollback occurred during the execution of a stored procedure that is marked for replication. The module 'log_repproc_exec' will also be reported in the stack trace. |
| 407031 | When a named cache is configured too small for current demands, a message is posted in the log and the associated spid may keep looping , waiting for free buffers. The spid cannot be killed. |
| 409347 | Adaptive Server tries to flush a free descriptor from the local cache of engines' by migrating to the engine without looking at the count of free descriptors on that engine, leading to a small performance degradation when all descriptors are in use. |
| 415882 | Feature to audit LDAPUA state changes. |
| 416246 | A self-deadlock may sometimes occur if there are concurrent serializable and non-serializable transactions doing DMLs to a DATA-ONLY locked table. |
| 423253 | On Solaris, if ASE is configured for HighAvailability on SunCluster, the HA agent ase_monitor will initiate failover if it fails to run various SQL commands as part of thorough probe, though the error is a transient one such as no space in tempdb. |
| 423559 | Increase limit of message parameter in syb_sendmsg TSQL function from 255 characters in length. |
| 425396 | If the value of the 'max SQL text monitored' configuration parameter is greater than 16384 bytes and a n application submits a SQL batch larger than 16384 bytes, a query on the monProcessSQLText Monitoring Table may generate a 632 error. |
| 426791 | ASE hangs or crashes when 3604 flag is enabled along with 7825, 7826 or 7827 flags. |
| 428922 | Enhancement to sp_monitor to monitor deadlocks using monDeadLock monitoring table. Interface is "sp_monitor 'deadlock'", followed by various arguments. An archival facility is provided to store deadlock events in a user-specified table. Detailed usage information can be obtained from: "sp_monitor help, deadlock" comand. Connection monitoring is now enhanced with new command "sp_monitor procstack", that reports on a task's procedural execution stack. Use "sp_monitor help, procstack" for more details. |
| 430428 | modify sp_text_load_index to display progress messages |
| 430503 | An INSERT/DELETE/UPDATE trigger interrupted by Ctrl C may not qualify the expected number of rows from the INSERTED/DELETED table and the associated INSERT/DELETE/UPDATE statement may not be rolled back accordingly. |
| 430748 | Instrumentation to diagnose 12328 errors: "The calculated row offset ' < offset > ' of an index key on page ' < pageid > ' for object ' < objid > 'in database ' < dbid > ' is out of bounds (table offset on page = ' < offset > ', page status = ' < pgstat > ', local offset table address = < address > ). Also, regenerate the offset table once to try to avoid 12328 errors, unless command line trace flag 625 is turned on. |
| 432693 | User without an Unix OS id were not able to use ASE RTDS messaging with MQ. This fix provides an option 'alter_user=yes' that allows such users to use RTDS messaging with MQ. |
| 440159 | syconfig.exe utility shows corrupt Chinese Characters when default language is set to Traditional Chinese. |
| 441274 | CREATE RULE statement incorrectly allows the creation of rules that use subqueries on its definition. |
| 442525 | A union with subquery in the result list may fail with error 530 ("Attempt to insert NULL value into column %d in work table (table id %ld); column does not allow NULLS. UPDATE fails.") if the subquery is producing empty result set. |
| 444117 | The auditing of login failures is enhanced to include the "Error number.Severity.State" in the "Other Information" section of extrainfo column. |
| 445986 | Incorrect join costing due to wrong filtering cost when subquery is flattened for reformating. |
| 446293 | CR 363894 causes 3250 error when using striping and Netbackup The error 3250, "The devices ' < backup api library name > :: < filename > ' and ' < backup api library name > :: < filename > ' specified in the command should be different." will be raised if the file names of two stripes are the same. This error should only be raised for normal or compressed files and it is an error assuming that an external API cannot use duplicate names. |
| 448978 | Under some rare conditions, the message "current process infected with 11" in the module 'qualpage' together with a stacktrace which includes the module 'getpage_with_validation' may be reported in the error log if a query is executed with materialized derived table. |
| 449021 | In a server configured to use a multi-byte character set by default, the replication of text being bulk copied could fail if the BCP client is using a single-byte character set. |
| 449301 | A 510 error, "Bad eop type 0x...", may be reported in the errorlog together with a stack trace which includes the modules 'execproc' and 'tdsrecv__dynexec' when executing a dynamic parameterized sql statement which used one of the following string manipulation functions: SUBSTRING(), LTRIM(), RTRIM(), RIGHT(), LEFT(), UPPER() or REVERSE() and the parameter's length value exceeds 255 characters. |
| 449492 | It was impossible to change configuration parameter 'messaging memory' when 'enable real time messaging' equals 0 (RTDS option disabled). That CR addresses that issue, allowing the user to modify 'messaging memory' configuration parameter before enabling RTDS. |
| 450005 | When a stored procedure involving joins on regular tables and a derived table must be recompiled due to a schema change, column names might not be resolved correctly, yielding an erroneous "ambiguous column" error. |
| 452189 | Incorrect code execution on ibmaix64 for fbo mode may lead to difference in selectivities for sarg. |
| 452442 | OR-clauses may not be evaluated if the query qualification references a column with the decrypt_default attribute. In SQL statements containing qualifications of the type WHERE dd_col = < value > OR non_dd_col = < value > , where dd_col is an encrypted column with the decrypt_default attribute and non_dd_col is a column without the decrypt_default attribute, the WHERE clause will disqualify all rows if the user executing the query does not have decrypt permission on dd_col. |
| 452482 | Encryption Column feature is now available on linuxamd64 platform. |
| 452735 | With traceflag 1649 active, ASE fails to initialize devices (like tmpfs) which does not support KAIO. Also databases on these devices (created before using traceflag 1649) fails to come online with error 823. |
| 452782 | If a Kerberos login attempt blocks during security session establishment reading the security opaque token from the client, it can hold an engine-wide security semaphore effectively blocking all other Kerberos login attempts. A new trace flag 7850 is added to timeout security connections if no security opaque token is received from client in 60 seconds. |
| 453273 | In rare circumstances, concurrent dmls to very large data-only locked tables may cause index corruption, resulting in 644 errors: "Index row entry for data row id < pageid, rnum > is missing from index page < indexpage > of index id < indid > of table < tabid > in database < dbid > . Xactid is < xactid > . Drop and re-create the index." Running online index reorg may cause self-deadlocks and 12311 errors, and dbcc checktable may report corruption. |
| 453339 | When ASE is booted with 16k page size, installmaster script may fail to complete with following message: "The current 'max memory' value '32768', is not sufficient to change the parameter 'allow updates to system tables' to '1'". |
| 453367 | The query, "ALTER TABLE MODIFY < column_name > NULL ENCRYPT WITH < encr_key > DECRYPT_DEFAULT NULL", failed with an 13975 error message, "You may not declare a null-valued decrypt_default on column < column_name > because that column is not nullable". |
| 453742 | ASE HA Failback fails with ServiceGuard A.11.17 but works on ServiceGuard A.11.16 and A.11.15. This is a compatibility issue with ServiceGuard A.11.17. ServiceGuard A.11.17 changes the message in its output from "cmhaltpkg : Completed successfully" to "cmhaltpkg: Completed successfully". A white space has been removed in the message between "cmhaltpkg" and ":" causing ASE HA Failback to fail. |
| 453759 | The count distinct expression may not return the correct number of rows on ANSI join queries involving subquery and ANY expression. |
| 453993 | Query with derrived table expression having TSQL outer join operator *= may return incorrect result if the inner table joining column is also present in the select list of the main query. |
| 454609 | Table scans on DATA_ONLY locked tables running at isolation level READ COMMITTED may sometimes fail to return qualifying rows if there are concurrent INSERTs/UPDATEs happening on the table. |
| 455042 | Client connection which is bound to the LASTONLINE will hang when issuing the "sp_engine 'offline'" command. |
| 455275 | Under rare circumstances DBCC CHECKSTORAGE may detect non-existent 100018 errors when run on an archive database. |
| 455295 | When table in IQ/ASA has name greater than 30 characters, creating proxy table in ASE that maps to it will fail with ASA Error -131: Syntax error near 'order' on line 1. |
| 455326 | The 110219 error log message has been reworded and now reads "Warning: There is no valid license for ASE_ASM and therefore the ASE_ASM feature has not been initialized". |
| 455611 | HAaseAgent for VCS on Solaris and Linux executes one VCS system command with wrong syntax: hagrp -display < service-group-name > attribute SystemList The above command with correct syntax should be: hagrp -display < serveric-group-name > -attribute SystemList The wrong syntax will not cause any failure in HAaseAgent or HA function except that VCS engine may log some error message to its log. |
| 455674 | Under very rare circumstances, some 821 or 813 errors may be raised for a very busy multi-engine ASE having a buffer cache shortage. |
| 455826 | If a kerberos login gets a timeslice error during security session establishment, the engine-wide semaphore is not released, causing all the other kerberos logins on that engine to block. |
| 456260 | When using RTDS (version 4.0 and before) with MQ, messages larger than 1MB cannot be sent or received. |
| 456498 | A 804 error reading "Unable to find buffer ' < Buffer Address > ' from cache 'Named Cache' holding logical page ' < Page Id > ' in sdes 'Sdes Address' kept buffer pool for object ' < Object Name > ', together with a stack trace showing modules 'pg_getdatapage_forinsert' and 'pg_release_alloc_page' may be raised while many concurrent sessions are INSERTing into the same sliced DOL table having a placement index. |
| 456532 | On Solaris, if ASE is configured for High Availability with SunCluster, the HA agent ase_monitor may print misleading error messages on every thorough probe, though the error occured only once. |
| 456569 | Some ALTER TABLE ADD < default > with MODIFY and/or DROP commands may fail with Msg 11050 in a HA environment. |
| 460687 | The error 9947, "An attempt to allocate memory failed due to insufficient ASE memory." can be raised by DBCC CHECKVERIFY, if the number of faults found by DBCC CHECKSTORAGE is very big. |
| 460825 | Execute immediate queries referencing outer scope variables may sometimes fail with syntax error about non declared local variables. |
| 460936 | Installer is not able to find JVM on HP-UX 11.31 |
| 461066 | Parallel query execution with runtime adjustment to serial execution may return incorrect results or fail with different unexpected errors if there are some DOL tables in the query and some expressions with result size bigger than 255 characters. |
| 461310 | Under random circumstances, the error "Cannot create msgqueue Xnnnnnnnn because it already exists" could be raised by the backup server. The chances are higher when there are several dumps running simultaneously. |
| 461469 | A timeslice error followed by a stack trace that includes the module db__diskremap_sysaltusages could result when trying to load a transaction dump on a big archive database. |
| 461669 | On PPC64/Linux, if a dump is made with the compress option, the dump archive cannot be greater than 2GB. |
| 462191 | The message text for error 15082 has been changed to indicate that it is not an error "There are < value > OAM entries with zero used/unused page counts. This is not an error. Run DBCC < value > FIX on objid < value > indid < value > to remove these entries as doing so will improve OAM scan performance.". Furthermore the message will be reported on objects with greater than 10 OAM pages and having 50% zero used/unused page counts OAM entries. |
| 462331 | soc_printpeername should print port number of client associated with invalid tds |
| 462943 | In some cases, outer join on view or derived table with CASE expression may return wrong result. |
| 462956 | Queries involving IN clause may perform with high logical reads even if the index covers the query. |
| 463003 | When the result of messaging builtins (eg msgrecv, msgconsume) is obtained as TEXT datatype, and this result is converted to java.lang.String, we hit a stack trace. |
| 463013 | When RTDS is disabled and a messaging built-in is executed, the transcation is left allocated instead of being rollbacked. Later, this lead to error 11068 as the left transaction can be reused but with an expected state. |
| 463040 | When using messaging builtins (eg msgrecv, msgconsume) to return java.lang.String, if the return value is larger than 16k we get MEMMOVE error. |
| 463111 | When Q engines are onlined with ASE, messaging tasks and other DBMS tasks may hang. |
| 463176 | Schema count is not incremented correctly for a table when dropping a foreign key constraint on if a table has multiple foreign key constraints. A stored procedure using this table will not automatically be recompiled yielding a 3601 internal error. |
| 463287 | Error 11775 displays a negative number instead of the command name when encrypted columns is not enabled and an attempt to grant permission on encrypted columns commands is made. |
| 463492 | Times recorded in historical server recording sessions do not properly adjust for DST 2007 changes. |
| 463772 | DUMP TRANSACTION < db > WITH STANDBY_ACCESS is not forwarded to Replication Server. This command allows a database that has been loaded with that transaction log dump, to be brought online between loads. This is possible because this command only dumps completed transactions. In a replication environment using coordinated dumps, a dump tran with standby_access that was successfuly run on the primary may fail when RS attemps to apply it into the replicated database as it may not find a quiesce point in the transaction log of the replicated database. |
| 464760 | Login to ASE using LDAP may hang with the message "Waiting for native threads to be released, or for 'max number of ldapua native threads' to be increased." even after increasing value of 'set_max_ldapua_native_threads'. |
| 465014 | ASE may send incorrect SQL to the remote server resulting in syntax error when a local table is joined with a proxy table and the WHERE clause contains IN or OR clauses on 'date' or 'time' columns. |
| 465301 | With "max parallel degree" configured to more than 1, statements that reference encrypted columns with the decrypt default property can cause ASE to stacktrace with a "Worker Process internal plan copy error for EVAL E_DECRYPT_PERM" message. |
| 465382 | When trace flag 2511 is active, ASE will suppress reporting the message 15082 during DBCC checks. |
| 465736 | Timing issues related to signal handling require the implementation of an alternate signal stack via the system call sigaltstack(). |
| 465853 | 64bit monserver on solaris can have very high cpu utilization at times due to not being linked with the kernel threads libraries (/usr/lib/lwp/64) |
| 465953 | Changing column encryption key causes stack trace if a decrypt_default is defined on the column. |
| 466435 | A LOAD DATABASE command might hang in cases where the "number of open databases" configuration parameter is less than the number of databases on the server and an earlier attempt to load another database with a cross-architecture database dump, failed. |
| 466986 | DDLGen fails in some circumstances to generate DDL for a table, where permissions have been granted on table columns with error P12: Critical internal application error occured. |
| 467253 | When executing stored procedure a new timestamp value is not assigned after performing UPDATE query on a table created in the same procedure. Similary timestamp returned after calling tsequal() is also incorrect. |
| 467447 | Since ASE 12.5.4, 923 errors, "User < user > not allowed in database ' < database > ' - only the owner of this database can access it" and 937 errors, "Database ' < database > ' is unavailable. It is undergoing LOAD DATABASE" may be reported unnecessarily. |
| 467841 | The message "current process ... infected with 11" may be reported in module 'dol_row_delete' during the execution of a DELETE command from a Data Only Locked table. The modules 'dol_delete' and 'row_delete' would also be reported in the stack trace in the error log. |
| 468311 | The message "Current process infected with signal 11 (SIGSEGV)" in the module 'pchk_pt_sched_scan' together with a stack trace including the module 'checkstorage' may be reported in the error log when DBCC CHECKSTORAGE is run for a database using a device whose vdevno is greater than 127. This applies to ASE version 12.5.* on the IBM AIX platform only. |
| 468710 | There is memory leak while msgsend/msgpublish with the option replyto and the type of replyto destination is different from the send/publish destination type. |
| 470912 | Extended stored procedures fail if 'set cis_rpc_handling on' is enabled and the xpserver has the 'negotiated logins' attribute switched on. |
| 472095 | Index may be corrupted with 7930 and 2511 errors when DBCC TUNE "ascinserts" is used with an INSERT SELECT from a table with data that is not in sorted order. |
| 472804 | If the trigger was defined on a prefixed table name (db..table or db.owner.table) and the schema count for syslogs table in the database is different than 0, ASE may be unable to compile the trigger correctly and the INSERT/DELETE/UPDATE statements will return the error 225/16/3, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization." |
| 474014 | srvbuild and srvbuildres are built with PA RISC2.0 dependency so the binaries cannot execute on PA RISC1.1 platforms. |
Back to Top
