Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar

Search for    in all of
view all search results right arrow

Support > Technical Documents > Document Types > Technote > Targeted CR List for ASE 15.0.3 ESD #4.2  
RSS Feed

Targeted CR List for ASE 15.0.3 ESD#4.2

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.

If the EBF has been released, check the CR list and coverletter at the EBF/Maintenance site:

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 IDDescription
538069 Connecting to a server that is down or non-existent server could cause memory leaks that eventually could lead to 7220 and 7235 errors.
545741 Fixed by 547741 which was checked into 15.0.3 IR.
552606 sp_options may not show no_stats_distinctness option. This is correct in ASE 15.0.3 IR onwards (CR 539440), this CR was to correct a problem with the backport of 539440 in a 15.0.2 1-off.
555255 When a query contains a negative integer specified such as -(90), and when literal parameterization is on, parser or normalization syntax error might be raised when the query is cached and has to be recompiled during subsequent executions.
577488 Provide traceflag 1144 to avoid 1127 errors reporting insufficient space in the OAM page when running heavily concurrent multi-user applications simultaneously inserting into the same table.
581138 Select monCachedObject cause SEGV in mda__set_ptninfo() with spinlock held. This was addressed via CR 539065.
592395 Signal 11 in function ResRelOp()and spid termination with ResRelOpProcess(), CgpPop::_CgpPePredBmToScalar visible in the stack trace in the error log. Query involving outer join onto a virtual expression from a sub-query containing the column involved in the virtual expression in a further outer-join clause. A virtual expression is generally the result of a built-in function (isnull etc)
616869 When a proxy table is accessed through a query limited by either SET ROWCOUNT or the query is aborted through CNTL-C, then a subsequent query to the proxy table will raise a 11206 error, "Unable to connect to server < servername > . Command has been aborted."
618469 The message "Current process ... infected with signal 11 (SIGSEGV)" in module "CgEvals::_CgCompVcol" may be reported in the error log followed by a stack trace during the execution of a query involving UDF/ADT constructions. The modules "jvmfini" and "BRIDGEjvm_AbortJavaVM" will also be reported resulting in the current session terminating and the JVM aborting. Alternatively this may cause ASE shutting down itself.
632207 In some circumstances, query on MDA table monCachedObject may affect ASE system performance.
632482 ASE reports "Protocol < XXXXX > not supported within soc_nopen()" error in errorlog. This may be followed by SIGSEGV, SIGBUS or timeslice error and lead to ASE hang.
635315 Under some circumstances when the execution of a stored procedure is aborted due to a 1205 error, "Your server command (family id ..., process id ...) encountered a deadlock situation. Please re-run your command." and the procedure was executed by another stored procedure that had a cursor opened inside a user transaction and the option SET CLOSE ON END TRAN was ON then the next execution of the same stored procedure that reuses the plan which was aborted could behave ignoring the WHERE clause for the statement that was aborted by the 1205 error.
637993 In some ASE workloads, proc_spin shows up as having high contention. This fix could decrease the contention in some of these workloads.
638786 Parallel activity on tables related with RI constraints may lead to deadlocks
641109 The message "current process infected with 11" in the module 'getvalue' together with a stack trace which includes the modules 's_retparams' and 'execproc' may be reported in the error log when an INSERT statement is run on a table having an encrypted CHAR/VARCHAR column, the configuration parameter "statement cache" is active and the INSERT statement was previously cached but it had to be recompiled or renormalized because, for example, all the query plans were in use or the schema for the underlying table changed.
642776 SELECT INTO proxy table may fail silently when inserting NULL into the proxy column.
644104 Under some rare conditions, stacktrace involving the modules 'LePlanRelease', 'LePlanWriteStats' an d 'LeAlfaStatsCollector' may be reported during query plan generation.
644156 Under some circumstances the message "WARNING: memory usage in procedure headers (x) does not match memory usage count in Pss (x) for server process id x" may be reported in the errorlog when a session is holding a high number of user temporary tables without dropping them and, for example, runs some stored procedures via Remote Procedure Call. Eventually, after multiple of those messages, a 701 error "There is not enough procedure cache to run this procedure, trigger, or SQL batch." maybe reported indicating that the free memory available in the Procedure Cache is low.
644994 Under some conditions, for example reset or reconfigure 'parallel degree', statement cache clean up issues and memory leaks may occur and it could also make the purge statement cache entry impossible due to ssql_keep > 0.
645146 Under some conditions, creating trigger involving union could lead to SEGV in p__check_lob_insdel() function.
645343 Stack trace in LeDataRow::readRow when fetching insensitive cursor on a union.
646353 sig-11 raised when upgrade step 245 is involved during upgrade to ase 15.5 smp.
646388 When tables with large number of partitions (typically greater than 32) are used in a query that has a UNION or a UNION ALL query with ASE configured for parallelism, ASE may stack trace.
646397 Executing an insert-select from proxy table into local table when a LOB column is present is much slower than in ASE 12.5.
647485 Executing a SELECT INTO EXISTING command on a proxy table with identity_insert option turned on does not insert the data.
647654 In rare circumstances an ASE task that is in the process of creating a temporary table in a user defined temporary database may sleep for ever while ASE generates the object ID value for this table. The call stack for the sleeping task will report the modules 'crt_main' and 'objd_id'.
648664 Under some rare conditions, the statement cache entry could have ssql_keep > 0 and this entry could not be removed by the DBCC PURGESQLCACHE command and this could cause problem for the statement cache.
649428 Adaptive Server may encounter a storage access violation error when query execution is interrupted.
650660 Queries with outer joins on encrypted columns may not return all the rows from the outer table if the encrypted column uses the decrypt_default modifier.
652634 When selecting from a VIEW that selects DISTINCT rows from a base table with at least one encrypted column that specifies a decrypt default value, Adaptive Server gets a SEGV violation and aborts the user session.
652646 A SELECT statement with a qualification that searches an encrypted column that has a decrypt_default modifier and another column using the LIKE operator may ignore the LIKE filter and produce wrong results.
653212 The message "Error: 820, Severity: 21, State: 6" may be reported in the error log together with a stack trace including the modules 'bufpindirty' and 'pg_allocate'. Alternatively, the "infected with 11" message may be seen in the error log together with a stack trace showing the modules 'xls_bufunpin' and 'buf_get_latch'.
654011 The message "current process infected with 11" in the module 'bufdlink' together with a stack trace which includes the modules 'pg_allocate' and 'bufpindirty' may be reported in the error log when a table was in the process of being created and ASE has previously hit a 1204 error "ASE has run out of LOCKS. Re-run your command when there are fewer active users, etc.".
654339 A 539 error "Unexpected internal access methods error < value > , state < value > etc." may be reported when an UPDATE with OR clauses is executed on a Data Only Locked table while concurrent DML activity takes place on it. The execution plan would report "Using Dynamic Index" and "Positioning by Row IDentifier (RID)". Alternatively the message "The current row ID ' < value > ' does not match the new row ID ' < value > ' for update, etc." may be reported in the error log.
654532 A 15412 error may be raised when during a decryption operation if there are a lot of concurrent user sessions using encrypted columns features in Adaptive Server.
655613 A DB2 error indicating an invalid value may be returned when a query referencing a remote DB2 table contains a DATE search value.
656075 In environments with a high number of concurrent users and using the statement cache intensively, the monitor counters for spinlocks may indicate that the DES manager spinlock was excessively used.
656566 On AIX platforms, a client session running a batch job may be terminated with error "ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect] SQLCODE[-84083974]" and the ASE errorlog is logged with message"kernel nrpacket: recv, Resource temporarily unavailable, spid: < spid > , suid: < suid > ".
656606 The message "current process infected with 11" in the module 's_retparams' together with a stack trace which includes the modules 's_setreturns' and 'execproc' may be reported in the error log when a SELECT statement is run on a table having an encrypted column and the configuration parameter "statement cache size" is greater than 0.
657963 Error message 233 appears when a ISNULL clause is present in a SELECT INTO EXISTING query where the target table is a proxy table.
658276 A "9219, severity 20, state 83" error may occur when a stored procedure with enough wide parameters that the number of bytes necessary to log an invocation would require more than a single log page. The error will only occur if the stored procedure has been previously invoked with null values in the wide parameter(s) and is subsequently invoked with non-null values in those same parameter(s).
659042 When the master database is marked for replication the execution of sp_addlogin does not replicate the login with the correct password expiration interval.
662923 sp_monitorconfig 'procedure cache size' can become inaccurate. Fixed via CR 644156.
665043 The following is observed when 'restricted decrypt permission' is configured: (1) a table owner who has decrypt permission on an encrypted column through group membership is not permitted to select decrypted data from the column. (2) sso_role who should have implicit decrypt permission is not permitted to select decrypted data from the column and is not permitted to insert into the column when trigger present on the table (3) a table owner who has been granted decrypt permission through a user defined role is not permitted to insert data into the column when trigger present on the table
665257 Under certain circumstances, server may fail to boot under UTF-8 nocase sort order, 8211 error may be seen.
665715 The message "current process infected with 11" in the module 'bufdlink' together with a stack trace which includes the modules 'pg_allocate' and 'bufpindirty' may be reported in the error log when a table was in the process of being created and ASE has previously hit a 1204 error "ASE has run out of LOCKS. Re-run your command when there are fewer active users, etc.".
666728 Update the Open Server Components of ASE to provide essential Open Server vulnerability fixes.
669847 A 290024 error, "Invalid column length: < number > Value must be between < number > and < number > at offset < number > ..." may be reported during a UPDATE plan execution when a complex VIEW or derived table (such as UNION or GROUPBY) is used in the FROM clause of the UPDATE statement.
670506 A server configured with certain specific character sets and case insensitive sort orders can report error 15417 when querying tables that contain encrypted columns.
670907 ASE may crash unrecoverably with signal 11 in ct_poll when a connection to a remote server running an SQL query is killed.
671440 Under some rare circumstances, ONLINE DATABASE or LOAD TRAN command may fail with a stack trace showing module xls_pre_alloc_numclrs and plc__flush. This may happen after loading a transaction dump including log records written by a CREATE INDEX command run for a DOL table.
671536 In certain circumstances, a query that contains an OR clause with multiple joins may generate a sub-optimal plan, with respect to result accurracy, when executed with the optimizer level of ?ase_default?.
671592 Lots of concurrent logins may result in error 290024 and stacktraces during ASE authentication.
672829 There can be high spinlock contention on the ASE network memory pool spinlock.
674627 When a table is being replicated to a table that includes an additional IDENTITY, an error "AOP not found in getAopt" is raised.
674877 Performance issue on SELECT INTO from encrypted tables for non-privileged user.
675990 After cross-platform dump and load of a database containing a view defined on a base table with an encrypted column and a decrypt default, the decrypt default information may be lost leading to a 3762 error: "The decrypt_default for column id 27 was not found in the system catalogs."
676991 High cpu usage seen with rprocmgr_spin contention
678432 If a target list for a view maps to more than one encrypted column in the base table with the decrypt_default attribute, Adaptive Server may fail to check the user's decrypt permission and incorrectly return the decrypt_default value instead of the actual column value.
678639 Closing a connection in ASE may cause high cpu usage.
679267 In rare circumstances, the error 8203 followed by a stack trace that includes the module des_create_inxact() could be raised when rolling back a transaction.
679807 For a SELECT statement in a stored procedure, if the table has more then one partition keys and not all the partition keys in the predicates are constants, neither compiler time partition elimination nor dynamic partition elimination occurs.
680759 In rare circumstances, terminating an idle CIS connection may result in some form of memory corruption in the next connection attempt.
683028 Dynamic Partition Elimination is not used for a store procedure with EXEC IMMEDIATE.
683626 Abstract plan error message could be reported when using "set forceplan on" for outer join query with subquery.
684110 Under rare circumstances, a 8601 error, "Process < pid1 > tried to keep the PSS for process < pid2 > when it already had the PSS for process < pid3 > kept", may be reported when executing utility functions, such as sp_showplan, which query another active spid.
685996 Abstract plan error could happen failing to apply a right nested outerjoin abstract plan. It is more likely to happen when there is a subquery at the inner side too. Same issue could also cause optimizer to ignore certain legit merge/hash outerjoin bushy plan too under allrows_dss optimization goal.
688338 Query involving column relop NULL clause may result in a 403 error message if the column projects NULL and the relop is =, > =, > , < = or < .
690064 A 11051 error, "ALTER TABLE ' < table_name > ' failed. Table is currently being used by one or more other tasks." may be reported when a REORG REBUILD command is run while another process concurrently runs a SELECT query on the same table at isolation level read uncommitted. Following this error and while the SELECT query continues to execute, any process that attempts to reference this table will fail mistakenly with an error such as 17461 "Object does not exist in this database.".
690730 High rprocmgr spinlock contention may be observed under heavy workload of dynamic SQL and stored procedures.
691248 When tempdb_space resource limit is reached, any subsequent work table creation operation fails and does not release the buffers and the allocated tempdb pages during the execution.
692550 A 11060 error, "This statement has exceeded the maximum number of recompilations (10). This indicates an internal error. Please note the error prior to this one and contact Sybase Technical Support.", may be reported under some circumstances when a stored procedure containing a SELECT INTO ... UNION statement is executed and references session temporary tables and/or stored procedure parameters.
694123 The 10330 error message is issued on a select from a join with a normal table and a view after dump/load database. The view and the normal table both have encrypted columns that have decrypt_default. The server has restricted decrypt permission set.
694488 In rare circumstances the message "Infected with 11" together with modules like s_cleanframe, s_senddone followed by spid termination may occur when set statistics time is enabled with a create proc referencing a non-existent temporary table and a particular Sybase supplied traceflag is enabled.
696470 In rare circumstances the message "Infected with 11" together with modules like senderror(),send_msg(), tdsrecv_errorhdl() followed by spid termination may occur when set statistics time is enabled with a create proc failed with syntax error.
697522 In rare circumstances the message "Infected with 11" together with modules like ex_printmsg(), senderror() followed by spid termination may occur when SET STATISTICS TIME is enabled with a create proc referencing an existent temporary table and a particular Sybase supplied traceflag is enabled.
697828 High rprocmgr or rpmctrl spinlock contention may be observed under heavy workload of dynamic SQL or stored procedures.
698059 Multiple failed connection attempts may result in memory related stacktraces in Ct-library and hang up the server completely. This is resolved by OCS CR 585954 (fixed in OCS 15.5 GA onwards).
702653 When a primary key contains IDENTITY columns, INSERT INTO and SELECT statements may create bad LTL causing the RepServer to report the error message, "Incorrect syntax near the keyword FROM". This is fixed via CR 674627.
712855 Invoking the soundex() or difference() built-ins on unichar/univarchar strings larger than 127 characters (254 bytes) may cause the process to be terminated.
713677 Include OCS CR 672301 to fix an AIX specific memory leak.
718191 Error 2812 or 11214 is raised when accessing an MDA table specifically mapped as a proxy table.
719019 An argument to error message 301 is too long. The argument needs to be truncated.
721144 If Java in the database is being used, then if the "same" shared configuration file is used by more than one instance or Server, then there is a race condition during JVM initialization where it is possible that the message ?current process infected with signal 11? in the function ?jvminit? may be reported in the error log, followed by the message ?Failed to initialize Java services". This may result in ASE shutting itself down.
723777 During installation, ASE Default Master/Tempdb Device Size is 0 on very large disk


Related Links

Last Revised: Nov 30, 2012
Product: Adaptive Server Enterprise
Technical Topics: Error Message, Database Admin, Bug Information, Troubleshooting
Business or Technical: Technical
Content Id: 1099089
Infotype: Technote

© Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics