IQ multiplex环境，报这个错误

zhaopingzi

SQL Anywhere -1009039: temp Bufman: An error was detected on a database page. You may have a damaged index. For additional informat

怎么办

andkylee

表或索引损坏了。
使用sp_iqcheckdb 'check table table_name';
逐个检查一下确认哪张表索引损坏了。

zhaopingzi

回复 2# andkylee


    是temp Bufman:错误，不是main bufman

   而且，我的表太多了。不能一个一个来吧

zhaopingzi

我怀疑是shared temp 有问题，或者temp 有问题？

zhaopingzi

回复 2# andkylee


    I. 03/13 10:19:24. 0000000014 DBCC - 803777668 leaked blocks
I. 03/13 10:19:24. 0000000014 DBCC - 21 blocks with multiple owners
I. 03/13 10:19:29. 0000001633 Txn 5613024 0 5613024
I. 03/13 10:19:29. 0000000014 DBCC Allocation Mode Report:   
I. 03/13 10:19:29. 0000000014 ** DBCC Status: Errors Detected  ******
I. 03/13 10:19:29. 0000000014    DBCC Status: Freelist updated  
I. 03/13 10:19:29. 0000000014  :   
I. 03/13 10:19:29. 0000000014 Allocation Summary:   
I. 03/13 10:19:29. 0000000014    Blocks Total: 6288381792  
I. 03/13 10:19:29. 0000000014    Blocks in Current Version: 1189636849  
I. 03/13 10:19:29. 0000000014    Blocks in All Versions: 1189636849  
I. 03/13 10:19:29. 0000000014    Blocks in Use: 6288381792  
I. 03/13 10:19:29. 0000000014    % Blocks in Use: 18  
I. 03/13 10:19:29. 0000000014 ** Blocks with Multiple Owners: 21  ******
I. 03/13 10:19:29. 0000000014  :   
I. 03/13 10:19:29. 0000000014 Allocation Statistics:   
I. 03/13 10:19:29. 0000000014    Marked Logical Blocks: 2459363120  
I. 03/13 10:19:29. 0000000014    Marked Physical Blocks: 1189636849  
I. 03/13 10:19:29. 0000000014    Marked Pages: 153710195  
I. 03/13 10:19:29. 0000000014    Blocks in Freelist: 6628773887  
I. 03/13 10:19:29. 0000000014    Imaginary Blocks: 340392095  
I. 03/13 10:19:29. 0000000014    Highest PBN in Use: 6607570712  
I. 03/13 10:19:29. 0000000014 ** 1st Multiple Owner PBN: 1751430337  ******
I. 03/13 10:19:29. 0000000014    Max Blocks Per Page: 16  
I. 03/13 10:19:29. 0000000014    1  Block Page Count: 1958147  
I. 03/13 10:19:29. 0000000014    2  Block Page Count: 10364562  
I. 03/13 10:19:29. 0000000014    3  Block Page Count: 13513781  
I. 03/13 10:19:29. 0000000014    4  Block Page Count: 9060214  
I. 03/13 10:19:29. 0000000014    5  Block Page Count: 16077072  
I. 03/13 10:19:29. 0000000014    6  Block Page Count: 9018940  
I. 03/13 10:19:29. 0000000014    7  Block Page Count: 30632092  
I. 03/13 10:19:29. 0000000014    8  Block Page Count: 11407273  
I. 03/13 10:19:29. 0000000014    9  Block Page Count: 8466554  
I. 03/13 10:19:29. 0000000014    10 Block Page Count: 8510152  
I. 03/13 10:19:29. 0000000014    11 Block Page Count: 5182310  
I. 03/13 10:19:29. 0000000014    12 Block Page Count: 7164071  
I. 03/13 10:19:29. 0000000014    13 Block Page Count: 4755550  
I. 03/13 10:19:29. 0000000014    14 Block Page Count: 2315744  
I. 03/13 10:19:29. 0000000014    15 Block Page Count: 1805671  
I. 03/13 10:19:29. 0000000014    16 Block Page Count: 13478062

zhaopingzi

出现分配为题，但没告诉我什么表有问题。日

andkylee

回复 6# zhaopingzi


    IQ目前就这样。

你执行check table逐个检查就能知道表是否有分配错误问题了。

zhaopingzi

回复 8# andkylee


   关键是太慢

zhaopingzi

我觉得可能不是表的问题。以我以前处理的经验，表坏了会显示出来哪个表有问题