Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

This "can't find values in index" assertion 200138 happens from time to time, on the same index in completely different database instances in completely different environments.

Confidence is high that it's not a data corruption error caused by disk or RAM... because it's always the same table, same index, in different database files created at different times on different continents.

Sometimes it's just the Assertion, sometimes the Assertion is accompanied by the "forbid mutex" stuff.

E. 07/20 17:48:10. *** ERROR *** Assertion failed: 200138 ([f]
Can't find values for row bbc3f:c in index 'ux_long_varchar'
W. 07/20 17:49:10. Task 000002857F6DB3A0(Request task 878) is trying get forbid mutex held by task 000002857F6DD920(Request task 876) for more than 60000 ms
W. 07/20 17:49:10. Task 000002857F6DD920(Request task 876) state: worker=000002857F6F4430 wakend=0 waiting=2
W. 07/20 17:49:10. Worker 000002857F6F4430 state: wakend=0 waiting=0 in_atomic=0 is_dedicated=0 in_critical_section=0 allow_forbid=0

Here's a mysterious fix made earlier...

    ================(Build #5874  - Engineering Case #819665)================

    Under some conditions, the server may abort after printing a message like 
    below to the console or print another message line with 
    incorrect information.

    Task 0x245bda0(Request task 52) is trying get forbid mutex held by task 
    0x2460ea0(Request task 79) for more than 60000 ms

    This has been fixed.

asked 20 Jul '21, 14:13

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 20 Jul '21, 14:13

question was seen: 993 times

last updated: 20 Jul '21, 14:13