Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 2 of 2 total |
Advice requested on 8965 Errors |
Thu, Jul 27 2006 11:59 PM | Permanent Link |
Dave | Hi
(Version 3.30 on Delphi 5) Since a recent update we have been getting a lot of #8965 errors (Index page buffers corrupt in the table 'main'). Users see the error when they do a search on the database. I'm not sure if the search causes it or that some corruption happens prior and it only surfaces when they do a search. The search is uses SQL like the following: 'UPDATE "D:\Testing_Other\DB\Test_DB\main.dat" M2 set GroupHit=6361 FROM "D:\Testing_Other\DB\Test_DB\main.dat" LEFT OUTER JOIN "D:\Testing_Other\DB\Test_DB\link.dat" L2 ON (M2.Index = L2.UserID) WHERE (L2.GroupID IN (23))' (And the table is then filtered by GroupHit). I can't reproduce the problem on our systems. I would appreciate any suggestions on things I should look at. A number of things have changed since the problem arose, but the only thing that I think could be problematic is the changes I have made to Session handling. Previously I had a specific TDBISAMSession component. My tables and database component had the SessionName of this session, but my query components had a blank SessionName (so presumably used the default session). In the problematic release I had removed the TDBISAMSession component, and changed the SessionName for the database and all query and table components to "default" So presumably that change is causing the problem??? I could try adding back the session component and pointing just the tables to it as previously. But if that is the cause I would like to understand why so that I don't make a similar mistake in the future. Thanks Dave |
Fri, Jul 28 2006 9:55 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Dave,
<< Since a recent update we have been getting a lot of #8965 errors (Index page buffers corrupt in the table 'main'). Users see the error when they do a search on the database. I'm not sure if the search causes it or that some corruption happens prior and it only surfaces when they do a search. >> I can email you a modified dbisamen.pas that will fix this. Please send me a private email and I'll reply with the unit. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |