博客提及了Sybase相关的修复列表，但未给出具体内容。涉及数据库、表、字符、服务器、命令等信息技术相关概念。
FIXES LIST :
List of Fixes for EBF 12060
---------------------------
Following is a list of fixes which are cumulative to this release. Each
fix is listed along with the EBF in which it was first released and the
description of the problem. The list is sorted by the EBFID column.
The list of fixes represents changes included after the ASE 12.5.2 Release.
For product changes up to ASE 12.5.2, please refer to the CPR and SPR files
included in the %SYBASE%/ASE-12_5/install/SPR directory.
EBFID BugID Description
----- ------ ------------------------------------------------------
12060 364293 Update language module version, so that locales files
will overlay earlier versions of the files.
12060 362369 On Tru64 Unix platform, ASE may generate stack traces
with the wrong symbol names due to the missing
libbtsymbols.so file.
12060 362041 Replication Agent may not send to Replication Server an
INSERT or DELETE operation performed on a table with
text/image column, if a partial rollback occurred
during processing.
12060 361694 A 691 error: "Encountered invalid logical page
'' while accessing object '' in database
''." may sometimes be encountered when inserting
data into an Allpages Locked table with large length
columns and having a clustered index.
12060 361498 SSL Clients specifying "Diffie-Hellman" key exchange
algorithm in the ciphersuites fail in the SSLHandshake.
Some clients, such as ODBC TDS based driver, offer
ciphersuites which will cause the handshake failures.
The certificates don't seem to matter in this problem.
isql and OCS clients are fine as long as they specify
the default ciphersuites but if the defaults are
overridden and "Diffie-Hellman" is offered, the ASE
fails in the handshake with them.
12060 360599 The current limit of 1024 AND/OR conditions in a WHERE
clause has been raised to 2000. In order to take
advantage of this new limit, it is necessary to adjust
the default stack size upward, to approximately 300K.
No change to the stack size is required unless the
application desires to take advantage of this new
limit. In addition to stack space, this new limit may
result in a need to allocate more procedure cache space
to the server. The dataserver must be started with
traceflag 404 ( -T404 ) to allow this new limit to take
effect. Otherwise, the current limit of 1024 will
remain.
12060 360414 Under rare circumstances a session may hit a
segmentation violation with message "current process
() infected with 11" in module 'bufdlink'
followed by a stack trace in the error log. This
results in an implicit shutdown of ASE.
12060 360063 Under large number of user connections, if connections
are killed repeatedly, then subsequent logins may take
a long time to get through resulting in slower response
time.
12060 359172 If Job Scheduler Task fails to initialize, infected
with 10 in kbfalloc() is caused by running sp_sysmon
with "cache wizard".
12060 359128 A 10479 error, "Conversion error detected while
converting Java data to SQL data. Either the conversion
is not supported or the datatype(s)is invalid." may be
raised when using CONVERT() function to convert certain
JAVA datatype values to NUMERIC SQL datatype values.
12060 358954 When CREATE TABLE and INSERT are in the same store
procedure, and the table is a non-temporary table with
IDENTITY column, the IDENTITY column data will be
incorrect.
12060 358868 Character set conversions are rejected for older
(DBlib) clients when the server's default character set
is SJIS and the client's character set is EUCJIS.
12060 358800 On AIX platforms, there may be a problem with
populating the aio_return field of an aio control block
in a timely fashion within the ASE.
12060 358758 When a transaction is being implicitly rolled back by
ASE, then the command "KILL WITH STATUSONLY"
will mistakenly report the message "Status report
cannot be obtained. ROLLBACK for spid: is not in
progress.".
12060 358450 If a new data cache is created using sp_cacheconfig,
the "APF Percent" for the default memory pool may be
incorrectly set to zero when Adaptive Server is next
rebooted. This can cause performance degradation when
accessing any objects that are bound to this data
cache.
12060 358418 Monitor tool to display in English only.
12060 358397 Transient 806, 691, 605 errors may be seen in very rare
circumstances when multiple sessions are scanning the
same page of an index in an Allpage Locked table.
12060 358269 A SELECT UNION query using a view which is materialized
whereby columns of the view are used in an outerjoin-
clause can return incorrect results.
12060 358092 When forcing an index, optimiser considers only the 1st
SARG
12060 358007 Stored procedure executing INSERT into a table with
some varchar columns may incorrectly leave trailing
spaces in the varchar column if the source of the data
is a table with CHAR column.
12060 357839 The command DUMP TRAN TO WITH
STANDBY_ACCESS may take too much time to stop when
interrupted with Ctrl C or killed from another session.
12060 357688 A 530 error, "Attempt to insert NULL value into column
... in work table (table id ...) column does not allow
NULLS. UPDATE fails." may be raised when a java class
running inside the ASE's JVM is connecting to the
server using the internal JDBC driver and then executes
a query on a table that has wide columns and a
worktable is necessary to resolve that query.
12060 357658 In an HA environment that is configured "with
proxy_db", the error "Infected with 11" followed by a
stack trace that includes the module
'palt__gen_addcol_clause' will be printed in the error
log and the process will be killed when a table is
altered to add a new non-null column without providing
a default. A 4997 error, "ALTER TABLE ''
failed. Default clause is required in order to add
non-NULL column ''", should be printed
instead.
12060 357477 A 871 error, "Process is trying to release a
latch on buffer (dbid: , pageno:
) without holding a latch on the buffer." may be
raised in module 'getnext' or 'dol__get_lock' when the
given process selects rows from a Data Only Locked
table while DML commands are taking place concurrently
by other processes.
12060 357181 The amount of memory needed by Adaptive Server may be
overestimated. This could happen when a large number of
"open objects", "open databases" or user-defined caches
are configured so that following an upgrade, Adaptive
Server may be unable to boot. The following message,
"The value of the 'max memory' parameter ()
defined in the configuration file is not high enough
to set the other parameter values specified in the
configuration file...", is reported in the error log.
12060 356785 ASE 12.5.0.3 ESD#4 running on HP-64 platform after a
few days suddenly becomes very slow, triggered by high
network activity. Incoming network I/O is very high,
ASE engines use 80% to 100% of CPU at Operating System
level, but do not perform any useful work. New incoming
connections are most of the time refused, effectively
ASE seems to be hung.
12060 356027 A 8201 error, "Keep count of descriptor ... expected to
be 1. Instead 0 was found." may be reported in the
error log followed by a stack trace including the
modules 'proc_get' and 'des_rekeep' during the
execution of a stored procedure whose previous
execution had failed with the message 'current process
infected with 11' in the module 'proc__setdb_plan'.
12060 356005 A 2780 error, "maxlen (1) is less than length (2)" may
be raised and reported to the errorlog together with a
stack trace which includes the modules
'sybase_asejdbc_Param_nt_1setBigDecimal' and
'j2c_setVal' when executing a java method that uses ASE
internal JDBC driver and tries to convert from
BigDecimal java datatype to NUMERIC SQL datatype.
12060 355551 When an ASE (12.5.1 and beyond) listener encounters
some recoverable network errors, like client aborting a
connection, when ASE is in the process of accepting the
client connection, ASE may consider the error to be
unrecoverable and terminate that listener. If there is
only one listener, no new connections can then be
established. However if a system administrator isql
session is available, then listener can be restarted.
This condition may be triggered by some activities like
a long duration shared memory dump.
12060 355375 ASE Replicator: On Windows, if the default system
locale is set to French, "corrupted" characters may be
seen instead of e with accent, o with circumflex, etc.
There does not seem to be a straight-forward way to
force Windows to use a specific charset. So, instead,
that info can be directly provided to ASE Replicator.
To provide the default charset to ASE Replicator, do
the following: Edit the $SYBASE/RPL-
12_5/bin/aserep.[bat|sh] script and add the "-
Dfile.encoding=xxx" parameter to the JRE command line
where "xxx" is a valid *Java* charset. For example:
"%JRE%" -Xmx64m "-Dfile.encoding=Cp850" "-
Dinstall.root=%SYBASE_DIR%/RPL-12_5" -classpath
"%SYBASE_DIR%/RPL-
12_5/classes/aserep.jar;%SYBASE_DIR%/jConnect-
5_5/classes/jconn2.jar;%SYBASE_DIR%/jConnect-
5_5/classes/jTDS2.jar;%CHARSETS%"
com.sybase.replite.RepLite %* The Java charsets that
display the French unicode characters correctly are
cp437, cp850, cp852, and cp858, specifically, the
charsets that are MS-DOS compatible. Other Latin
charsets do not work and display "corrupted"
characters.
12060 355370 ASE Replicator: On Windows, if the default system
locale is set to French, "corrupted" characters may be
seen instead of e with accent, o with circumflex, etc.
There does not seem to be a straight-forward way to
force Windows to use a specific charset. So, instead,
that info can be directly provided to ASE Replicator.
To provide the default charset to ASE Replicator, do
the following: Edit the $SYBASE/RPL-
12_5/bin/aserep.[bat|sh] script and add the "-
Dfile.encoding=xxx" parameter to the JRE command line
where "xxx" is a valid *Java* charset. For example:
"%JRE%" -Xmx64m "-Dfile.encoding=Cp850" "-
Dinstall.root=%SYBASE_DIR%/RPL-12_5" -classpath
"%SYBASE_DIR%/RPL-
12_5/classes/aserep.jar;%SYBASE_DIR%/jConnect-
5_5/classes/jconn2.jar;%SYBASE_DIR%/jConnect-
5_5/classes/jTDS2.jar;%CHARSETS%"
com.sybase.replite.RepLite %* The Java charsets that
display the French unicode characters correctly are
cp437, cp850, cp852, and cp858, specifically, the
charsets that are MS-DOS compatible. Other Latin
charsets do not work and display "corrupted"
characters.
12060 355108 When two instances of the same shared memory dump
condition occur at almost the same time, it is possible
for the number of shared memory dumps created to exceed
the configured maxdumps value for that dump condition.
12060 355017 ASE Replicator: When a single quote mark is not doubled
in the resource message, two things can happen: (1)the
quote mark does not show up in the localized message
and (2)if there is/are parameter placeholder(s) in the
resource message, then the actual values do *not* show
up in the localized message; instead, the placeholders
themselves show up.
12060 355004 ASE Replicator: When trying to start ASE Replicator, a
SQLException "S0022 column not found" error occurs.
12060 354984 A 694 error, " An attempt was made to read logical page
'', virtpage '' from virtual device
'' for object '' in database ''.
The page was not read successfully. You may have a
device problem or an operating system problem." may be
reported under rare circumstances when CREATE INDEX and
DUMP DATABASE are running concurrently and the server
has large pools configured.
12060 354961 ASE Replicator: On Windows, if the default system
locale is set to French, "corrupted" characters may be
seen instead of e with accent, o with circumflex, etc.
There does not seem to be a straight-forward way to
force Windows to use a specific charset. So, instead,
that info can be directly provided to ASE Replicator.
To provide the default charset to ASE Replicator, do
the following: Edit the $SYBASE/RPL-
12_5/bin/aserep.[bat|sh] script and add the "-
Dfile.encoding=xxx" parameter to the JRE command line
where "xxx" is a valid *Java* charset. For example:
"%JRE%" -Xmx64m "-Dfile.encoding=Cp850" "-
Dinstall.root=%SYBASE_DIR%/RPL-12_5" -classpath
"%SYBASE_DIR%/RPL-
12_5/classes/aserep.jar;%SYBASE_DIR%/jConnect-
5_5/classes/jconn2.jar;%SYBASE_DIR%/jConnect-
5_5/classes/jTDS2.jar;%CHARSETS%"
com.sybase.replite.RepLite %* The Java charsets that
display the French unicode characters correctly are
cp437, cp850, cp852, and cp858, specifically, the
charsets that are MS-DOS compatible. Other Latin
charsets do not work and display "corrupted"
characters.
12060 354958 ASE Replicator: Usage command has garbled text when
running aserep /?
12060 354936 In rare circumstances, ASE may report a timeslice error
in the module 'lm_internal_ctxchain_release' if a
session has acquired a very large number of locks. If
the lock manager spinlock is held at this point, the
server will crash.
12060 354798 Traceflag 7842 can be used to log a diagnostic message
when a client cancels an operation. Traceflag 7843 can
be used to reverse the changes from bugfix 269372 for
situations where an existing application relies on the
previous (incorrect) behaviour of ASE attention
handling.
12060 354772 When the 'number of user connections' is configured to
a large value (around 30000), ASE may fail to start due
to a timeslice error in module 'dbt__getfree' after the
message 'Opening Master Database ... ' has been
reported in the error log.
12060 354768 Allocate memory for EJB connection sockets only under
traceflag -T 1642. This new default behavior change
eliminates unused memory reserved for EJB server when
EJB server is not configured so that more user
connections can be configured for the ASE server.
12060 354727 When the Statement Cache is enabled and a normalization
error occurs, the keepcounts of other statements in the
batch may not be decremented resulting in incorrect
keepcounts. This prevents these statements from ever
being purged using DBCC PURGESQLCACHE.
12060 354650 Noticeable performance degradation is observed in query
performance when migrating to ASE 12.5.0.3 and later
versions on IBM 64bit platform built on AIX 5.1 OS (ASE
version string reported by 'dataserver -v' has "AIX
5.1" rather than "AIX 4.3.3").
12060 354609 The error 208 will be incorrectly raised when trying to
access an object that is qualified with the database
name that is enclosed in double quotes and SET
QUOTED_IDENTIFIER is ON.
12060 354585 A batch executing the sequence of statements: CREATE
CLUSTERED INDEX on a table and then UPDATE table may
fail with error 629, "Clustered index row entry for
data page # is missing in index page # of table
`tabname` in database 'dbname'; index row contains data
page # instead. You can recreate the clustered index to
fix this error Xactid is (xactid)."
12060 354578 CIS: sp_passthru is not returning the correct @rowcount
value when no rows are fetched or affected by the
pass-through query.
12060 354511 Msg. 156, "Incorrect syntax near ELSE" is raised when
executing an IF ELSE construction whereby the SQL
statement in the IF block is cached using the Statement
Cache feature.
12060 354281 The message "current process infected with 11" in the
module 'memshrink' together with a stack trace which
includes the modules 'cri_physbuild' and 'cri_bldindex'
may be reported in the error log when a DUMP DATABASE
statement is run at the same time as a CREATE INDEX,
SELECT INTO or BCP. The diagserver will return error
message 3205 in this case.
12060 354208 Cannot Delete an Extended Stored Procedure in ASE Plug-
in. This problem is seen in 12.5.2 version of ASE Plug-
in.
12060 353866 A user trying to log into the server may be blocked
forever if the master database is quiesced.
12060 353718 A 2628 or 2630 error together with message "Mass
found in the buffer wash with incorrect state dirty but
not writing" may sometimes be encountered while doing a
lot of UPDATEs or DELETEs on a Data Only Locked table.
12060 353460 sp_monitor stored procedure executed with the
'connection' parameter gives incorrect time values for
sleeping processes.
12060 352568 In rare circumstances, ASE may hang forever if the IO
subsystem is overloaded and a process goes to sleep
while holding the default data cache spinlock. The call
stack of this process will show the modules 'dstartio',
'kd_p_semaphore' and 'upsleepgeneric'.
12060 352153 A 257 error, "Implicit conversion from datatype
to is not allowed" may be
raised when inserting a NULL value using a
parameterized statement and the datatype of the
parameter does not match with the datatype of the
column.
12060 352103 CIS: SELECT..INTO from proxy table command against DB2
backend is slow when the WHERE clause is not forwarded
to the remote server.
12060 352044 If character set conversion is already active,
executing the statement "set char_convert on" will
cause incorrect information to be reported via the
global variables @@char_convert and @@client_csid, and
it may ultimately lead to the process being terminated
with a a stack trace.
12060 352027 A 7951 error may be reported by DBCC CHECKTABLE after a
valid XML document that is encoded in a multi-byte
character set, has been BCP'd into this table.
12060 351074 A 614 error, "Adaptive Server accessed a row that has
an illegal length of while in database
. Page pointer = , , pageno =
, status = , objectid = ,
indexid = , level = . The minimum row
length is %d. The page size is (pagesize>" may
sometimes happen when a transaction doing DELETE and
UPDATE operations on a Data Only Locked table is rolled
back.
12060 351008 Replication Agent may report the error 691, including
page '0', when trying to process an update where the
before image has not been marked for replication.
12060 349790 CIS : Execution of multiple Extended Stored Procedures
might result in performance improvement due to an
efficient connection establishment model when routed
through CIS RPC mechanism after both 'cis rpc handling'
and 'negotiated logins' options are turned on.
12060 349251 When a single long transaction is aborted in a primary
database because it has filled up the log, replication
agent is not able to move the secondary truncation
point, even if all transactions have been processed by
replication agent.
12060 348384 The error 1505, "Create unique index aborted on
duplicate key. Primary key is ''" may report an
incorrect key value if the index is created in parallel
mode as opposed to serial.
12060 347753 Enhanced diagnostics for access violation errors.
12060 347380 Msg. 103, "The identifier that starts with
'' is too long. Maximum length is 30." is
raised when executing the command WRITETEXT BULK
. and colname is
called "parameter".
12060 345943 After unmirroring the master device keeping the
secondary side, dumps of the master database fail with
an attempt to access the original master device.
12060 342856 Under very rare circumstances, DBCC CHECKSTORAGE may
incorrectly report a large number of 100018 soft
faults.
12060 335542 CIS: An outer join query declared inside a cursor can't
be passed to the remote server completely even if all
tables involved are on the same remote server. Cursors
involving remote tables are READONLY by default. They
can be made UPDATE-ABLE by default upon enabling
traceflag 11218.
12060 95163 A column created with the system datatype 'sysname',
defined as a varchar(30) NULL, will get a length of 1
char instead of 30.
扫一扫
824
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
