Symptom
- The ASE server is upgraded, probably recently, from a pre-15.7 release (12.5.x, 15.0.x or 15.5) to a 15.7 or 16.0 release.
- After the ASE upgrade, attempts to access text/image column data fail with any of a variety of the following symptoms:
- Error 632 when accessing text/image column data is the most common symptom encountered under these conditions:
Error: 632, Severity: 20, State: 2
Attempt to move memory with an incorrect length of 28580. Maximum allowed length is 16384.
-
Error "Current process infected with Signal 11" (or Signal 10) with a stack trace that includes routines sendtext() and may include txcomp__getplaintxt() or txcomp__cleanup().
-
Other Signal 11 (or Signal 10) with stack traces may occur indicating memory corruption due to earlier memory corruption failures.
-
The ASE server may crash reporting a memory corruption stack trace with a SPINLOCK violation.
-
BCP OUT of data from a user table with text/image column(s) may hang.
-
Error 7173:
Error: 7173, Severity: 18, State: 6
server Internal error while decompressing the text value on page 622, dbid 1, error code 4 (TX_ZLIB_DAT_ERR).
Please contact Sybase Technical Support.
-
Msg 12918 when executing DBCC CHECKTABLE or CHECKDB against table(s) containing text/image columns.
Msg 12918, Level 16, State 2:
Flags (0x48b) in Text/Image/Unitext Page Status Area on text page 8388935 (partition id 592005140) does not match the attribute of text page
chain starting from page 8331274. Run DBCC REBUILD_TEXT to fix it.
-
Msg 100030, hard fault 'page format error,' in the DBCC CHECKSTORAGE output indicating a page with text/image data.
- Other processes may subsequently encounter a variety of other problems due to memory corruption that may occur during item 2 above.
Read more...
Environment
-
SAP Adaptive Server Enterprise (ASE) 15.7
-
SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
compression, TIPSA, TX_TIPSA_COMPRESSED, skip_ncindex, skip_tables_with_no_text, SIGSEGV, segmentation, fault, segfault, access, violation, SIGBUS, 693329, CR693329, 744986, CR744986 , 787670, CR787670, compression, bit unused, status bit, TIPSA, internal structure, text pages, dbcc page, text stat bit unused, PG_TEXT, PG_FIRST_TEXT_PAGE, -T7167 , KBA , compress , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview