Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Error 5088: The index is corrupt. A reindex is necessary. Detected in Seek.

10 posts in FoxPro Last posting was on 2008-12-02 09:08:52.0Z
Reijo Pitkanen Posted on 2008-11-12 08:56:51.0Z
Date: Wed, 12 Nov 2008 10:56:51 +0200
From: Reijo Pitkanen <reijo.pitkanen@somermatic.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: advantage.foxpro
Subject: Error 5088: The index is corrupt. A reindex is necessary. Detected in Seek.
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 86.60.191.249
Message-ID: <491a98d7@solutions.advantagedatabase.com>
X-Trace: 12 Nov 2008 01:50:31 -0700, 86.60.191.249
Lines: 222
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!86.60.191.249
Xref: solutions.advantagedatabase.com Advantage.FoxPro:275
Article PK: 1109629

Hi,
When you run a complicated SQL-query against DBF/CDX tables
simultaneously from two clients, you get to the first started client
following error:

“AdsQuery1: Error 7200: AQE Error: State = HY000; NativeError =
5088; [iAnywhere Solutions][Advantage SQL][ASA] Error 5088: The index
is corrupt. A reindex is necessary. Detected in Seek.”

If you run this query from only one client at a time it works perfectly.

I am using ADS remote server v. 9.0.0.7 on Linux CentOS 5.2 box.
OEM character set is FINNISH and Ansi set is finnish.
Tables are foxpro 2.6 tables and the code page is not marked into the
tables.
The query result is little bit less than 20000 rows and the execution
time is about 15 seconds.
Test clients are Windows XP boxes running ARC v. 9.0.0.7 and the server
connection is remote using TCP/IP .

The query:

Select s.SUTYONO,s.SUOSANRO,s.SUNITUNNUS as
MATERIAALI,s.SULATENRO,s.SUTOTNUM,v.VLNITUNNUS,n.NINIMIKE,
n.NIPIIRNO,v.VLMAARA,v.VLYKS,v.VLTEHTYKPL , w.TYOTILNRO, w.TYOASIAKAS,
w.TYOPROJEKT, w.TYOPVM, s.ROWID as RIVID
from "SULATENO.DBF" s
left outer join "VALMISTE.DBF" v on ((s.SUTYONO=v.VLTYONRO) AND
(s.SUOSANRO=v.VLOSANRO))
left outer join "NIMIKE.DBF" n ON (v.VLNITUNNUS=n.NITUNNUS)
left outer join "TYOT.DBF" w ON s.SUTYONO=w.tyonumero
Order by s.SUTYONO,s.SUOSANRO

Table definitions:

Structure for database: V:\TUOMATIC\DB\SULATENO.DBF
Number of data records: 0
Date of last update : 12/20/07
Field Field Name Type Width Dec Index
1 SUTYONO Numeric 6 Asc
2 SUOSANRO Numeric 3 Asc
3 SUNITUNNUS Character 10 Asc
4 SULATENRO Character 20
5 SUTOTNUM Numeric 10
** Total ** 50

Structure for table: c:\tuomatic\db\valmiste.dbf
Number of data records: 18946
Date of last update: 08.11.2007
Memo file block size: 64
Code Page: 0
Field Field Name Type Width Dec Index Collate
1 VLTYONRO Numeric 6 Desc Machine
2 VLOSANRO Numeric 3 Asc Machine
3 VLNITUNNUS Character 10 Asc Machine
4 VLMAARA Numeric 12 4
5 VLYKS Character 10
6 VLSVKO Character 4
7 VLLMISVKO Character 4
8 VLLMISPVM Date 8
9 VLTEHTYKPL Numeric 12 4
10 VLLISAINFO Character 70
11 VLTILA Character 10
12 VLSARJANRO Numeric 3
13 VLLOPPUTUO Character 10
14 VLMEMO Memo 10
** Total ** 173

Structure for table: c:\tuomatic\db\tyot.dbf
Number of data records: 6785
Date of last update: 08.11.2007
Memo file block size: 64
Code Page: 0
Field Field Name Type Width Dec Index Collate
1 TYONUMERO Numeric 6 Desc Machine
2 TYOTILNRO Numeric 6 Desc Machine
3 TYOASIAKAS Character 40
4 TYOPROJEKT Character 40
5 TYOPVM Date 8
6 TYOMUUPVM Date 8
7 TYOSVKO Character 4
8 TYOTILA Character 10
9 TYOLISAT Character 140
10 TYOVALMPVM Date 8
11 TYOVALMVKO Character 4
12 TYOMAARTUL Logical 1
13 TYOMEMO Memo 10
14 TYOOSTOT Character 70
** Total ** 356

Structure for table: r:\db\nimike.dbf
Number of data records: 16770
Date of last update: 14.10.1908
Memo file block size: 64
Code Page: 0
Field Field Name Type Width Dec Index Collate
1 NITUNNUS Character 10 Asc Machine
2 NINIMIKE Character 40 Asc Machine
3 NILISAT Character 40
4 NIRYHMA Character 10
5 NIPIIRNO Character 20 Asc Machine
6 NISTANDARD Character 20
7 NIASIAKAS Numeric 5
8 NIKUSTLAJI Numeric 2
9 NINIMILAJI Numeric 2
10 NIKASYKS Character 10
11 NIHINYKS Character 10
12 NIMUUNKER Numeric 10 4
13 NIYKSPAINO Numeric 10 4
14 NIABCLUOK Character 2
15 NIVARASTO Numeric 5 Asc Machine
16 NISALDO Numeric 12 4
17 NIVARAUS Numeric 12 4
18 NIVARVKO Character 4
19 NIVARAAJA Numeric 6
20 NISAAPUU Numeric 12 4
21 NISAAPVKO Character 4
22 NITUOJA Numeric 6
23 NIHUKKALIS Numeric 12 4
24 NITILPISTE Numeric 12 4
25 NIVALMERA Numeric 12 4
26 NIPAKKOKO Numeric 12 4
27 NITOIAIKA Numeric 4
28 NIVALMAIKA Numeric 8 3
29 NITOIMITT1 Numeric 5
30 NIOSTOHI Numeric 12 4
31 NIMYYNTIHI Numeric 12 4
32 NIHINTAPVM Date 8
33 NIMUUTOSPV Date 8
34 NIINVVALI Numeric 2
35 NIINVPVM Date 8
36 NIRAKEPVM Date 8
37 NITYOVPVM Date 8
38 NITARJHIN Numeric 12 4
39 NIKALEPRO Numeric 5 2
40 NIINVSALDO Numeric 12 4
41 NIMEMO Memo 10
42 NIPICTURE Character 40
43 NILOKERO Character 20
** Total ** 483

-----------------------------------------------------------------------------------
Here is a small sample of ads_err.adt-table from the testing time:

Created: 11/12/2008 10:49:56

Item Error_Number DateTime Thread_Num Err_Class Error_Code
ADS_Source Src_Line Cnnct_Num Cnnct_Name FileName ADS_Ver
Environmnt OS_Version HostName More_Info

306 306 11/11/2008 15:58:53 10673616 7200 5088 evaluate.c
27376 TESTI-PC 9.0.0.7 Linux aatos
307 307 11/11/2008 15:58:53 2158032 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_0202.tmp 9.0.0.7 Linux aatos
308 308 11/11/2008 15:59:26 13704656 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux aatos
309 309 11/11/2008 15:59:26 13704656 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux aatos
310 310 11/11/2008 15:59:26 2158032 8000 65535 bldix.c 3910
TESTI-PC /home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux aatos
311 311 11/11/2008 15:59:26 2158032 8000 65535 bldix.c 3910
TESTI-PC /home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux aatos
312 312 11/11/2008 15:59:26 13704656 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux aatos
313 313 11/11/2008 15:59:26 13704656 7200 5088 evaluate.c
27376 REKANHP 9.0.0.7 Linux aatos
314 314 11/11/2008 15:59:26 2158032 8000 65535 bldix.c 3910
TESTI-PC /home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux aatos
315 315 11/11/2008 16:05:56 14708176 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
316 316 11/11/2008 16:05:56 14708176 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
317 317 11/11/2008 16:05:56 2158032 8000 65535 bldix.c 3910
TESTI-PC /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
318 318 11/11/2008 16:05:56 14708176 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
319 319 11/11/2008 16:05:56 2158032 8000 65535 bldix.c 3910
TESTI-PC /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
320 320 11/11/2008 16:05:57 14708176 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
321 321 11/11/2008 16:05:57 2158032 8000 65535 bldix.c 3910
TESTI-PC /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
322 322 11/11/2008 16:05:57 2158032 8000 65535 bldix.c 3910
TESTI-PC /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
323 323 11/11/2008 16:05:57 14708176 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
324 324 11/11/2008 16:05:57 2158032 8000 65535 bldix.c 3910
TESTI-PC /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
325 325 11/11/2008 16:05:57 14708176 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
326 326 11/11/2008 16:05:57 2158032 8000 65535 bldix.c 3910
TESTI-PC /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
327 327 11/11/2008 16:05:57 14708176 7200 5088 evaluate.c
27376 REKANHP 9.0.0.7 Linux aatos
328 328 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
329 329 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
330 330 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910
TESTI-PC /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
331 331 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910
TESTI-PC /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
332 332 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
333 333 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
334 334 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910
TESTI-PC /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
335 335 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910
TESTI-PC /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
336 336 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
337 337 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
338 338 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910
TESTI-PC /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
339 339 11/11/2008 16:08:15 13704656 8000 65535 bldix.c 3910
TESTI-PC /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos


Best regards,
Reijo Pitkanen


Alex Wong (ADS) Posted on 2008-11-12 16:57:50.0Z
From: "Alex Wong \(ADS\)" <nobody@sybase.com>
Newsgroups: advantage.foxpro
References: <491a98d7@solutions.advantagedatabase.com>
Subject: Re: Error 5088: The index is corrupt. A reindex is necessary. Detected in Seek.
Date: Wed, 12 Nov 2008 09:57:50 -0700
Lines: 233
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 10.24.38.144
Message-ID: <491b0989@solutions.advantagedatabase.com>
X-Trace: 12 Nov 2008 09:51:21 -0700, 10.24.38.144
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.144
Xref: solutions.advantagedatabase.com Advantage.FoxPro:276
Article PK: 1109630

Hi Reijo,

Can you send the tables to us so we can take a look? Please send to
advantage@ianywhere.com, attn: Alex Wong.

Thanks,

--
Alex

"Reijo Pitkanen" <reijo.pitkanen@somermatic.com> wrote in message
news:491a98d7@solutions.advantagedatabase.com...
> Hi,
> When you run a complicated SQL-query against DBF/CDX tables simultaneously
> from two clients, you get to the first started client following error:
>
> “AdsQuery1: Error 7200: AQE Error: State = HY000; NativeError = 5088;
> [iAnywhere Solutions][Advantage SQL][ASA] Error 5088: The index is
> corrupt. A reindex is necessary. Detected in Seek.”
>
> If you run this query from only one client at a time it works perfectly.
>
> I am using ADS remote server v. 9.0.0.7 on Linux CentOS 5.2 box.
> OEM character set is FINNISH and Ansi set is finnish.
> Tables are foxpro 2.6 tables and the code page is not marked into the
> tables.
> The query result is little bit less than 20000 rows and the execution
> time is about 15 seconds.
> Test clients are Windows XP boxes running ARC v. 9.0.0.7 and the server
> connection is remote using TCP/IP .
>
> The query:
>
> Select s.SUTYONO,s.SUOSANRO,s.SUNITUNNUS as
> MATERIAALI,s.SULATENRO,s.SUTOTNUM,v.VLNITUNNUS,n.NINIMIKE,
> n.NIPIIRNO,v.VLMAARA,v.VLYKS,v.VLTEHTYKPL , w.TYOTILNRO, w.TYOASIAKAS,
> w.TYOPROJEKT, w.TYOPVM, s.ROWID as RIVID
> from "SULATENO.DBF" s
> left outer join "VALMISTE.DBF" v on ((s.SUTYONO=v.VLTYONRO) AND
> (s.SUOSANRO=v.VLOSANRO))
> left outer join "NIMIKE.DBF" n ON (v.VLNITUNNUS=n.NITUNNUS)
> left outer join "TYOT.DBF" w ON s.SUTYONO=w.tyonumero
> Order by s.SUTYONO,s.SUOSANRO
>
> Table definitions:
>
> Structure for database: V:\TUOMATIC\DB\SULATENO.DBF
> Number of data records: 0
> Date of last update : 12/20/07
> Field Field Name Type Width Dec Index
> 1 SUTYONO Numeric 6 Asc
> 2 SUOSANRO Numeric 3 Asc
> 3 SUNITUNNUS Character 10 Asc
> 4 SULATENRO Character 20
> 5 SUTOTNUM Numeric 10
> ** Total ** 50
>
> Structure for table: c:\tuomatic\db\valmiste.dbf
> Number of data records: 18946
> Date of last update: 08.11.2007
> Memo file block size: 64
> Code Page: 0
> Field Field Name Type Width Dec Index Collate
> 1 VLTYONRO Numeric 6 Desc Machine
> 2 VLOSANRO Numeric 3 Asc Machine
> 3 VLNITUNNUS Character 10 Asc Machine
> 4 VLMAARA Numeric 12 4
> 5 VLYKS Character 10
> 6 VLSVKO Character 4
> 7 VLLMISVKO Character 4
> 8 VLLMISPVM Date 8
> 9 VLTEHTYKPL Numeric 12 4
> 10 VLLISAINFO Character 70
> 11 VLTILA Character 10
> 12 VLSARJANRO Numeric 3
> 13 VLLOPPUTUO Character 10
> 14 VLMEMO Memo 10
> ** Total ** 173
>
> Structure for table: c:\tuomatic\db\tyot.dbf
> Number of data records: 6785
> Date of last update: 08.11.2007
> Memo file block size: 64
> Code Page: 0
> Field Field Name Type Width Dec Index Collate
> 1 TYONUMERO Numeric 6 Desc Machine
> 2 TYOTILNRO Numeric 6 Desc Machine
> 3 TYOASIAKAS Character 40
> 4 TYOPROJEKT Character 40
> 5 TYOPVM Date 8
> 6 TYOMUUPVM Date 8
> 7 TYOSVKO Character 4
> 8 TYOTILA Character 10
> 9 TYOLISAT Character 140
> 10 TYOVALMPVM Date 8
> 11 TYOVALMVKO Character 4
> 12 TYOMAARTUL Logical 1
> 13 TYOMEMO Memo 10
> 14 TYOOSTOT Character 70
> ** Total ** 356
>
> Structure for table: r:\db\nimike.dbf
> Number of data records: 16770
> Date of last update: 14.10.1908
> Memo file block size: 64
> Code Page: 0
> Field Field Name Type Width Dec Index Collate
> 1 NITUNNUS Character 10 Asc Machine
> 2 NINIMIKE Character 40 Asc Machine
> 3 NILISAT Character 40
> 4 NIRYHMA Character 10
> 5 NIPIIRNO Character 20 Asc Machine
> 6 NISTANDARD Character 20
> 7 NIASIAKAS Numeric 5
> 8 NIKUSTLAJI Numeric 2
> 9 NINIMILAJI Numeric 2
> 10 NIKASYKS Character 10
> 11 NIHINYKS Character 10
> 12 NIMUUNKER Numeric 10 4
> 13 NIYKSPAINO Numeric 10 4
> 14 NIABCLUOK Character 2
> 15 NIVARASTO Numeric 5 Asc Machine
> 16 NISALDO Numeric 12 4
> 17 NIVARAUS Numeric 12 4
> 18 NIVARVKO Character 4
> 19 NIVARAAJA Numeric 6
> 20 NISAAPUU Numeric 12 4
> 21 NISAAPVKO Character 4
> 22 NITUOJA Numeric 6
> 23 NIHUKKALIS Numeric 12 4
> 24 NITILPISTE Numeric 12 4
> 25 NIVALMERA Numeric 12 4
> 26 NIPAKKOKO Numeric 12 4
> 27 NITOIAIKA Numeric 4
> 28 NIVALMAIKA Numeric 8 3
> 29 NITOIMITT1 Numeric 5
> 30 NIOSTOHI Numeric 12 4
> 31 NIMYYNTIHI Numeric 12 4
> 32 NIHINTAPVM Date 8
> 33 NIMUUTOSPV Date 8
> 34 NIINVVALI Numeric 2
> 35 NIINVPVM Date 8
> 36 NIRAKEPVM Date 8
> 37 NITYOVPVM Date 8
> 38 NITARJHIN Numeric 12 4
> 39 NIKALEPRO Numeric 5 2
> 40 NIINVSALDO Numeric 12 4
> 41 NIMEMO Memo 10
> 42 NIPICTURE Character 40
> 43 NILOKERO Character 20
> ** Total ** 483
>
> -----------------------------------------------------------------------------------
> Here is a small sample of ads_err.adt-table from the testing time:
>
> Created: 11/12/2008 10:49:56
>
> Item Error_Number DateTime Thread_Num Err_Class Error_Code ADS_Source
> Src_Line Cnnct_Num Cnnct_Name FileName ADS_Ver Environmnt OS_Version
> HostName More_Info
>
> 306 306 11/11/2008 15:58:53 10673616 7200 5088 evaluate.c 27376 TESTI-PC
> 9.0.0.7 Linux aatos 307 307 11/11/2008 15:58:53 2158032 8000 65535
> bldix.c 3910 REKANHP /home/tuomatic/db/tim_0202.tmp 9.0.0.7 Linux aatos
> 308 308 11/11/2008 15:59:26 13704656 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux aatos 309 309 11/11/2008
> 15:59:26 13704656 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux aatos 310 310 11/11/2008
> 15:59:26 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux aatos 311 311 11/11/2008
> 15:59:26 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux aatos 312 312 11/11/2008
> 15:59:26 13704656 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux aatos 313 313 11/11/2008
> 15:59:26 13704656 7200 5088 evaluate.c 27376 REKANHP 9.0.0.7 Linux
> aatos 314 314 11/11/2008 15:59:26 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux aatos 315 315 11/11/2008
> 16:05:56 14708176 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 316 316 11/11/2008
> 16:05:56 14708176 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 317 317 11/11/2008
> 16:05:56 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 318 318 11/11/2008
> 16:05:56 14708176 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 319 319 11/11/2008
> 16:05:56 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 320 320 11/11/2008
> 16:05:57 14708176 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 321 321 11/11/2008
> 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 322 322 11/11/2008
> 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 323 323 11/11/2008
> 16:05:57 14708176 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 324 324 11/11/2008
> 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 325 325 11/11/2008
> 16:05:57 14708176 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 326 326 11/11/2008
> 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 327 327 11/11/2008
> 16:05:57 14708176 7200 5088 evaluate.c 27376 REKANHP 9.0.0.7 Linux
> aatos 328 328 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos 329 329 11/11/2008
> 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos 330 330 11/11/2008
> 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos 331 331 11/11/2008
> 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos 332 332 11/11/2008
> 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos 333 333 11/11/2008
> 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos 334 334 11/11/2008
> 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos 335 335 11/11/2008
> 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos 336 336 11/11/2008
> 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos 337 337 11/11/2008
> 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos 338 338 11/11/2008
> 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos 339 339 11/11/2008
> 16:08:15 13704656 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
>
> Best regards,
> Reijo Pitkanen


Reijo Pitkanen Posted on 2008-11-13 09:04:32.0Z
Date: Thu, 13 Nov 2008 11:04:32 +0200
From: Reijo Pitkanen <reijo.pitkanen@somermatic.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: advantage.foxpro
Subject: Re: Error 5088: The index is corrupt. A reindex is necessary. Detected in Seek.
References: <491a98d7@solutions.advantagedatabase.com> <491b0989@solutions.advantagedatabase.com>
In-Reply-To: <491b0989@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 86.60.191.249
Message-ID: <491bec21@solutions.advantagedatabase.com>
X-Trace: 13 Nov 2008 01:58:09 -0700, 86.60.191.249
Lines: 283
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!86.60.191.249
Xref: solutions.advantagedatabase.com Advantage.FoxPro:277
Article PK: 1109631

Hi Alex,
I think that this problem is not the tables but the server environment.
So there is no use to send you the dbf-files.
I encountered into this error situation, when testing a new linux server
box for my customer.
I did some more digging this morning, and tested exactly same data and
same test program in an other, older linux box and I could not repeat
the error. I changed my actual Delphi application so that it executes
this query continuously with timer to ease testing, though the error can
be reproduced also with ARC.
Even the test client pcÂ’s where the same.
Then I copied the database table files from the working environment back
to the failing server and tested again with same results i.e. Error 5088
to the other client, while the other one keeps on working nicely.

The working old server box is dual-core Intel Pentium 850 having Fedora
8 kernel 2.6.24.4.-64.fc8. It has 3 GB system memory.

The new failing server has Quad-Core Intel Xeon E504 cpu and 4GB of
system memory.
Linux distribution is CentOS 5.2 and the kernel version is
2.6.18-92.1.18.el5PAE.

Both servers run Advantage database server 9.0.0.7, even the ads.conf
files are identical, actually ads.conf is the default that setup script
has done.
There is nothing in the system logs of the server.

So, could you say something about these lines in ads_err.adt table:

593 593 11/13/2008 10:06:- 7667152 8000 65535 bldix.c 3910
TESTI-PC /home/tuomatic/db/tim_0017.tmp
9.0.0.7 Linux aatos
594 594 11/13/2008 10:06:- 8670672 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_0019.tmp
9.0.0.7 Linux aatos
595 595 11/13/2008 10:06:- 7667152 8000 65535 bldix.c 3910
TESTI-PC /home/tuomatic/db/tim_0017.tmp
9.0.0.7 Linux aatos
596 596 11/13/2008 10:06:- 8670672 8000 65535 bldix.c 3910
REKANHP /home/tuomatic/db/tim_0019.tmp
9.0.0.7
Linux aatos
597 597 11/13/2008 10:06:- 7667152 7200 5088 evaluate.c 27376
TESTI-PC
9.0.0.7 Linux aatos

Regards Reijo Pitkanen
-------------------------------------------------------------------

Alex Wong (ADS) wrote:
> Hi Reijo,
>
> Can you send the tables to us so we can take a look? Please send to
> advantage@ianywhere.com, attn: Alex Wong.
>
> Thanks,
>
> --
> Alex
>
>
>
> "Reijo Pitkanen" <reijo.pitkanen@somermatic.com> wrote in message
> news:491a98d7@solutions.advantagedatabase.com...
>> Hi,
>> When you run a complicated SQL-query against DBF/CDX tables simultaneously
>> from two clients, you get to the first started client following error:
>>
>> “AdsQuery1: Error 7200: AQE Error: State = HY000; NativeError = 5088;
>> [iAnywhere Solutions][Advantage SQL][ASA] Error 5088: The index is
>> corrupt. A reindex is necessary. Detected in Seek.”
>>
>> If you run this query from only one client at a time it works perfectly.
>>
>> I am using ADS remote server v. 9.0.0.7 on Linux CentOS 5.2 box.
>> OEM character set is FINNISH and Ansi set is finnish.
>> Tables are foxpro 2.6 tables and the code page is not marked into the
>> tables.
>> The query result is little bit less than 20000 rows and the execution
>> time is about 15 seconds.
>> Test clients are Windows XP boxes running ARC v. 9.0.0.7 and the server
>> connection is remote using TCP/IP .
>>
>> The query:
>>
>> Select s.SUTYONO,s.SUOSANRO,s.SUNITUNNUS as
>> MATERIAALI,s.SULATENRO,s.SUTOTNUM,v.VLNITUNNUS,n.NINIMIKE,
>> n.NIPIIRNO,v.VLMAARA,v.VLYKS,v.VLTEHTYKPL , w.TYOTILNRO, w.TYOASIAKAS,
>> w.TYOPROJEKT, w.TYOPVM, s.ROWID as RIVID
>> from "SULATENO.DBF" s
>> left outer join "VALMISTE.DBF" v on ((s.SUTYONO=v.VLTYONRO) AND
>> (s.SUOSANRO=v.VLOSANRO))
>> left outer join "NIMIKE.DBF" n ON (v.VLNITUNNUS=n.NITUNNUS)
>> left outer join "TYOT.DBF" w ON s.SUTYONO=w.tyonumero
>> Order by s.SUTYONO,s.SUOSANRO
>>
>> Table definitions:
>>
>> Structure for database: V:\TUOMATIC\DB\SULATENO.DBF
>> Number of data records: 0
>> Date of last update : 12/20/07
>> Field Field Name Type Width Dec Index
>> 1 SUTYONO Numeric 6 Asc
>> 2 SUOSANRO Numeric 3 Asc
>> 3 SUNITUNNUS Character 10 Asc
>> 4 SULATENRO Character 20
>> 5 SUTOTNUM Numeric 10
>> ** Total ** 50
>>
>> Structure for table: c:\tuomatic\db\valmiste.dbf
>> Number of data records: 18946
>> Date of last update: 08.11.2007
>> Memo file block size: 64
>> Code Page: 0
>> Field Field Name Type Width Dec Index Collate
>> 1 VLTYONRO Numeric 6 Desc Machine
>> 2 VLOSANRO Numeric 3 Asc Machine
>> 3 VLNITUNNUS Character 10 Asc Machine
>> 4 VLMAARA Numeric 12 4
>> 5 VLYKS Character 10
>> 6 VLSVKO Character 4
>> 7 VLLMISVKO Character 4
>> 8 VLLMISPVM Date 8
>> 9 VLTEHTYKPL Numeric 12 4
>> 10 VLLISAINFO Character 70
>> 11 VLTILA Character 10
>> 12 VLSARJANRO Numeric 3
>> 13 VLLOPPUTUO Character 10
>> 14 VLMEMO Memo 10
>> ** Total ** 173
>>
>> Structure for table: c:\tuomatic\db\tyot.dbf
>> Number of data records: 6785
>> Date of last update: 08.11.2007
>> Memo file block size: 64
>> Code Page: 0
>> Field Field Name Type Width Dec Index Collate
>> 1 TYONUMERO Numeric 6 Desc Machine
>> 2 TYOTILNRO Numeric 6 Desc Machine
>> 3 TYOASIAKAS Character 40
>> 4 TYOPROJEKT Character 40
>> 5 TYOPVM Date 8
>> 6 TYOMUUPVM Date 8
>> 7 TYOSVKO Character 4
>> 8 TYOTILA Character 10
>> 9 TYOLISAT Character 140
>> 10 TYOVALMPVM Date 8
>> 11 TYOVALMVKO Character 4
>> 12 TYOMAARTUL Logical 1
>> 13 TYOMEMO Memo 10
>> 14 TYOOSTOT Character 70
>> ** Total ** 356
>>
>> Structure for table: r:\db\nimike.dbf
>> Number of data records: 16770
>> Date of last update: 14.10.1908
>> Memo file block size: 64
>> Code Page: 0
>> Field Field Name Type Width Dec Index Collate
>> 1 NITUNNUS Character 10 Asc Machine
>> 2 NINIMIKE Character 40 Asc Machine
>> 3 NILISAT Character 40
>> 4 NIRYHMA Character 10
>> 5 NIPIIRNO Character 20 Asc Machine
>> 6 NISTANDARD Character 20
>> 7 NIASIAKAS Numeric 5
>> 8 NIKUSTLAJI Numeric 2
>> 9 NINIMILAJI Numeric 2
>> 10 NIKASYKS Character 10
>> 11 NIHINYKS Character 10
>> 12 NIMUUNKER Numeric 10 4
>> 13 NIYKSPAINO Numeric 10 4
>> 14 NIABCLUOK Character 2
>> 15 NIVARASTO Numeric 5 Asc Machine
>> 16 NISALDO Numeric 12 4
>> 17 NIVARAUS Numeric 12 4
>> 18 NIVARVKO Character 4
>> 19 NIVARAAJA Numeric 6
>> 20 NISAAPUU Numeric 12 4
>> 21 NISAAPVKO Character 4
>> 22 NITUOJA Numeric 6
>> 23 NIHUKKALIS Numeric 12 4
>> 24 NITILPISTE Numeric 12 4
>> 25 NIVALMERA Numeric 12 4
>> 26 NIPAKKOKO Numeric 12 4
>> 27 NITOIAIKA Numeric 4
>> 28 NIVALMAIKA Numeric 8 3
>> 29 NITOIMITT1 Numeric 5
>> 30 NIOSTOHI Numeric 12 4
>> 31 NIMYYNTIHI Numeric 12 4
>> 32 NIHINTAPVM Date 8
>> 33 NIMUUTOSPV Date 8
>> 34 NIINVVALI Numeric 2
>> 35 NIINVPVM Date 8
>> 36 NIRAKEPVM Date 8
>> 37 NITYOVPVM Date 8
>> 38 NITARJHIN Numeric 12 4
>> 39 NIKALEPRO Numeric 5 2
>> 40 NIINVSALDO Numeric 12 4
>> 41 NIMEMO Memo 10
>> 42 NIPICTURE Character 40
>> 43 NILOKERO Character 20
>> ** Total ** 483
>>
>> -----------------------------------------------------------------------------------
>> Here is a small sample of ads_err.adt-table from the testing time:
>>
>> Created: 11/12/2008 10:49:56
>>
>> Item Error_Number DateTime Thread_Num Err_Class Error_Code ADS_Source
>> Src_Line Cnnct_Num Cnnct_Name FileName ADS_Ver Environmnt OS_Version
>> HostName More_Info
>>
>> 306 306 11/11/2008 15:58:53 10673616 7200 5088 evaluate.c 27376 TESTI-PC
>> 9.0.0.7 Linux aatos 307 307 11/11/2008 15:58:53 2158032 8000 65535
>> bldix.c 3910 REKANHP /home/tuomatic/db/tim_0202.tmp 9.0.0.7 Linux aatos
>> 308 308 11/11/2008 15:59:26 13704656 8000 65535 bldix.c 3910 REKANHP
>> /home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux aatos 309 309 11/11/2008
>> 15:59:26 13704656 8000 65535 bldix.c 3910 REKANHP
>> /home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux aatos 310 310 11/11/2008
>> 15:59:26 2158032 8000 65535 bldix.c 3910 TESTI-PC
>> /home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux aatos 311 311 11/11/2008
>> 15:59:26 2158032 8000 65535 bldix.c 3910 TESTI-PC
>> /home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux aatos 312 312 11/11/2008
>> 15:59:26 13704656 8000 65535 bldix.c 3910 REKANHP
>> /home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux aatos 313 313 11/11/2008
>> 15:59:26 13704656 7200 5088 evaluate.c 27376 REKANHP 9.0.0.7 Linux
>> aatos 314 314 11/11/2008 15:59:26 2158032 8000 65535 bldix.c 3910 TESTI-PC
>> /home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux aatos 315 315 11/11/2008
>> 16:05:56 14708176 8000 65535 bldix.c 3910 REKANHP
>> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 316 316 11/11/2008
>> 16:05:56 14708176 8000 65535 bldix.c 3910 REKANHP
>> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 317 317 11/11/2008
>> 16:05:56 2158032 8000 65535 bldix.c 3910 TESTI-PC
>> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 318 318 11/11/2008
>> 16:05:56 14708176 8000 65535 bldix.c 3910 REKANHP
>> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 319 319 11/11/2008
>> 16:05:56 2158032 8000 65535 bldix.c 3910 TESTI-PC
>> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 320 320 11/11/2008
>> 16:05:57 14708176 8000 65535 bldix.c 3910 REKANHP
>> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 321 321 11/11/2008
>> 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
>> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 322 322 11/11/2008
>> 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
>> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 323 323 11/11/2008
>> 16:05:57 14708176 8000 65535 bldix.c 3910 REKANHP
>> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 324 324 11/11/2008
>> 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
>> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 325 325 11/11/2008
>> 16:05:57 14708176 8000 65535 bldix.c 3910 REKANHP
>> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 326 326 11/11/2008
>> 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
>> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 327 327 11/11/2008
>> 16:05:57 14708176 7200 5088 evaluate.c 27376 REKANHP 9.0.0.7 Linux
>> aatos 328 328 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
>> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos 329 329 11/11/2008
>> 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
>> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos 330 330 11/11/2008
>> 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
>> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos 331 331 11/11/2008
>> 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
>> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos 332 332 11/11/2008
>> 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
>> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos 333 333 11/11/2008
>> 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
>> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos 334 334 11/11/2008
>> 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
>> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos 335 335 11/11/2008
>> 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
>> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos 336 336 11/11/2008
>> 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
>> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos 337 337 11/11/2008
>> 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
>> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos 338 338 11/11/2008
>> 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
>> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos 339 339 11/11/2008
>> 16:08:15 13704656 8000 65535 bldix.c 3910 TESTI-PC
>> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
>>
>> Best regards,
>> Reijo Pitkanen
>
>


Reijo Pitkanen Posted on 2008-11-13 09:39:40.0Z
Date: Thu, 13 Nov 2008 11:39:40 +0200
From: Reijo Pitkanen <reijo.pitkanen@somermatic.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: advantage.foxpro
Subject: Re: Error 5088: The index is corrupt. A reindex is necessary. Detected in Seek.
References: <491a98d7@solutions.advantagedatabase.com> <491b0989@solutions.advantagedatabase.com> <491bec21@solutions.advantagedatabase.com>
In-Reply-To: <491bec21@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 86.60.191.249
Message-ID: <491bf45c@solutions.advantagedatabase.com>
X-Trace: 13 Nov 2008 02:33:16 -0700, 86.60.191.249
Lines: 291
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!86.60.191.249
Xref: solutions.advantagedatabase.com Advantage.FoxPro:278
Article PK: 1109632

Here is some more information:
I can run the query from both clients without errors, if I reduce the
number of worker threads to 1.

-- Reijo

Reijo Pitkanen wrote:
> Hi Alex,
> I think that this problem is not the tables but the server environment.
> So there is no use to send you the dbf-files.
> I encountered into this error situation, when testing a new linux server
> box for my customer.
> I did some more digging this morning, and tested exactly same data and
> same test program in an other, older linux box and I could not repeat
> the error. I changed my actual Delphi application so that it executes
> this query continuously with timer to ease testing, though the error can
> be reproduced also with ARC.
> Even the test client pcÂ’s where the same.
> Then I copied the database table files from the working environment back
> to the failing server and tested again with same results i.e. Error 5088
> to the other client, while the other one keeps on working nicely.
>
> The working old server box is dual-core Intel Pentium 850 having Fedora
> 8 kernel 2.6.24.4.-64.fc8. It has 3 GB system memory.
>
> The new failing server has Quad-Core Intel Xeon E504 cpu and 4GB of
> system memory.
> Linux distribution is CentOS 5.2 and the kernel version is
> 2.6.18-92.1.18.el5PAE.
>
> Both servers run Advantage database server 9.0.0.7, even the ads.conf
> files are identical, actually ads.conf is the default that setup script
> has done.
> There is nothing in the system logs of the server.
>
> So, could you say something about these lines in ads_err.adt table:
>
> 593 593 11/13/2008 10:06:- 7667152 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_0017.tmp 9.0.0.7
> Linux aatos
> 594 594 11/13/2008 10:06:- 8670672 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_0019.tmp 9.0.0.7
> Linux aatos
> 595 595 11/13/2008 10:06:- 7667152 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_0017.tmp 9.0.0.7 Linux
> aatos
> 596 596 11/13/2008 10:06:- 8670672 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_0019.tmp
> 9.0.0.7
> Linux aatos
> 597 597 11/13/2008 10:06:- 7667152 7200 5088 evaluate.c 27376
> TESTI-PC 9.0.0.7 Linux aatos
>
> Regards Reijo Pitkanen
> -------------------------------------------------------------------
> Alex Wong (ADS) wrote:
>> Hi Reijo,
>>
>> Can you send the tables to us so we can take a look? Please send to
>> advantage@ianywhere.com, attn: Alex Wong.
>>
>> Thanks,
>>
>> --
>> Alex
>>
>>
>>
>> "Reijo Pitkanen" <reijo.pitkanen@somermatic.com> wrote in message
>> news:491a98d7@solutions.advantagedatabase.com...
>>> Hi,
>>> When you run a complicated SQL-query against DBF/CDX tables
>>> simultaneously from two clients, you get to the first started client
>>> following error:
>>>
>>> “AdsQuery1: Error 7200: AQE Error: State = HY000; NativeError =
>>> 5088; [iAnywhere Solutions][Advantage SQL][ASA] Error 5088: The
>>> index is corrupt. A reindex is necessary. Detected in Seek.”
>>>
>>> If you run this query from only one client at a time it works perfectly.
>>>
>>> I am using ADS remote server v. 9.0.0.7 on Linux CentOS 5.2 box.
>>> OEM character set is FINNISH and Ansi set is finnish.
>>> Tables are foxpro 2.6 tables and the code page is not marked into the
>>> tables.
>>> The query result is little bit less than 20000 rows and the
>>> execution time is about 15 seconds.
>>> Test clients are Windows XP boxes running ARC v. 9.0.0.7 and the
>>> server connection is remote using TCP/IP .
>>>
>>> The query:
>>>
>>> Select s.SUTYONO,s.SUOSANRO,s.SUNITUNNUS as
>>> MATERIAALI,s.SULATENRO,s.SUTOTNUM,v.VLNITUNNUS,n.NINIMIKE,
>>> n.NIPIIRNO,v.VLMAARA,v.VLYKS,v.VLTEHTYKPL , w.TYOTILNRO,
>>> w.TYOASIAKAS, w.TYOPROJEKT, w.TYOPVM, s.ROWID as RIVID
>>> from "SULATENO.DBF" s
>>> left outer join "VALMISTE.DBF" v on ((s.SUTYONO=v.VLTYONRO) AND
>>> (s.SUOSANRO=v.VLOSANRO))
>>> left outer join "NIMIKE.DBF" n ON (v.VLNITUNNUS=n.NITUNNUS)
>>> left outer join "TYOT.DBF" w ON s.SUTYONO=w.tyonumero
>>> Order by s.SUTYONO,s.SUOSANRO
>>>
>>> Table definitions:
>>>
>>> Structure for database: V:\TUOMATIC\DB\SULATENO.DBF
>>> Number of data records: 0
>>> Date of last update : 12/20/07
>>> Field Field Name Type Width Dec Index
>>> 1 SUTYONO Numeric 6 Asc
>>> 2 SUOSANRO Numeric 3 Asc
>>> 3 SUNITUNNUS Character 10 Asc
>>> 4 SULATENRO Character 20
>>> 5 SUTOTNUM Numeric 10
>>> ** Total ** 50
>>>
>>> Structure for table: c:\tuomatic\db\valmiste.dbf
>>> Number of data records: 18946
>>> Date of last update: 08.11.2007
>>> Memo file block size: 64
>>> Code Page: 0
>>> Field Field Name Type Width Dec Index Collate
>>> 1 VLTYONRO Numeric 6 Desc Machine
>>> 2 VLOSANRO Numeric 3 Asc Machine
>>> 3 VLNITUNNUS Character 10 Asc Machine
>>> 4 VLMAARA Numeric 12 4
>>> 5 VLYKS Character 10
>>> 6 VLSVKO Character 4
>>> 7 VLLMISVKO Character 4
>>> 8 VLLMISPVM Date 8
>>> 9 VLTEHTYKPL Numeric 12 4
>>> 10 VLLISAINFO Character 70
>>> 11 VLTILA Character 10
>>> 12 VLSARJANRO Numeric 3
>>> 13 VLLOPPUTUO Character 10
>>> 14 VLMEMO Memo 10
>>> ** Total ** 173
>>>
>>> Structure for table: c:\tuomatic\db\tyot.dbf
>>> Number of data records: 6785
>>> Date of last update: 08.11.2007
>>> Memo file block size: 64
>>> Code Page: 0
>>> Field Field Name Type Width Dec Index Collate
>>> 1 TYONUMERO Numeric 6 Desc Machine
>>> 2 TYOTILNRO Numeric 6 Desc Machine
>>> 3 TYOASIAKAS Character 40
>>> 4 TYOPROJEKT Character 40
>>> 5 TYOPVM Date 8
>>> 6 TYOMUUPVM Date 8
>>> 7 TYOSVKO Character 4
>>> 8 TYOTILA Character 10
>>> 9 TYOLISAT Character 140
>>> 10 TYOVALMPVM Date 8
>>> 11 TYOVALMVKO Character 4
>>> 12 TYOMAARTUL Logical 1
>>> 13 TYOMEMO Memo 10
>>> 14 TYOOSTOT Character 70
>>> ** Total ** 356
>>>
>>> Structure for table: r:\db\nimike.dbf
>>> Number of data records: 16770
>>> Date of last update: 14.10.1908
>>> Memo file block size: 64
>>> Code Page: 0
>>> Field Field Name Type Width Dec Index Collate
>>> 1 NITUNNUS Character 10 Asc Machine
>>> 2 NINIMIKE Character 40 Asc Machine
>>> 3 NILISAT Character 40
>>> 4 NIRYHMA Character 10
>>> 5 NIPIIRNO Character 20 Asc Machine
>>> 6 NISTANDARD Character 20
>>> 7 NIASIAKAS Numeric 5
>>> 8 NIKUSTLAJI Numeric 2
>>> 9 NINIMILAJI Numeric 2
>>> 10 NIKASYKS Character 10
>>> 11 NIHINYKS Character 10
>>> 12 NIMUUNKER Numeric 10 4
>>> 13 NIYKSPAINO Numeric 10 4
>>> 14 NIABCLUOK Character 2
>>> 15 NIVARASTO Numeric 5 Asc Machine
>>> 16 NISALDO Numeric 12 4
>>> 17 NIVARAUS Numeric 12 4
>>> 18 NIVARVKO Character 4
>>> 19 NIVARAAJA Numeric 6
>>> 20 NISAAPUU Numeric 12 4
>>> 21 NISAAPVKO Character 4
>>> 22 NITUOJA Numeric 6
>>> 23 NIHUKKALIS Numeric 12 4
>>> 24 NITILPISTE Numeric 12 4
>>> 25 NIVALMERA Numeric 12 4
>>> 26 NIPAKKOKO Numeric 12 4
>>> 27 NITOIAIKA Numeric 4
>>> 28 NIVALMAIKA Numeric 8 3
>>> 29 NITOIMITT1 Numeric 5
>>> 30 NIOSTOHI Numeric 12 4
>>> 31 NIMYYNTIHI Numeric 12 4
>>> 32 NIHINTAPVM Date 8
>>> 33 NIMUUTOSPV Date 8
>>> 34 NIINVVALI Numeric 2
>>> 35 NIINVPVM Date 8
>>> 36 NIRAKEPVM Date 8
>>> 37 NITYOVPVM Date 8
>>> 38 NITARJHIN Numeric 12 4
>>> 39 NIKALEPRO Numeric 5 2
>>> 40 NIINVSALDO Numeric 12 4
>>> 41 NIMEMO Memo 10
>>> 42 NIPICTURE Character 40
>>> 43 NILOKERO Character 20
>>> ** Total ** 483
>>>
>>> -----------------------------------------------------------------------------------
>>>
>>> Here is a small sample of ads_err.adt-table from the testing time:
>>>
>>> Created: 11/12/2008 10:49:56
>>>
>>> Item Error_Number DateTime Thread_Num Err_Class Error_Code ADS_Source
>>> Src_Line Cnnct_Num Cnnct_Name FileName ADS_Ver Environmnt OS_Version
>>> HostName More_Info
>>>
>>> 306 306 11/11/2008 15:58:53 10673616 7200 5088 evaluate.c 27376
>>> TESTI-PC 9.0.0.7 Linux aatos 307 307 11/11/2008 15:58:53 2158032
>>> 8000 65535 bldix.c 3910 REKANHP /home/tuomatic/db/tim_0202.tmp
>>> 9.0.0.7 Linux aatos 308 308 11/11/2008 15:59:26 13704656 8000 65535
>>> bldix.c 3910 REKANHP /home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux
>>> aatos 309 309 11/11/2008 15:59:26 13704656 8000 65535 bldix.c 3910
>>> REKANHP /home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux aatos 310 310
>>> 11/11/2008 15:59:26 2158032 8000 65535 bldix.c 3910 TESTI-PC
>>> /home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux aatos 311 311
>>> 11/11/2008 15:59:26 2158032 8000 65535 bldix.c 3910 TESTI-PC
>>> /home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux aatos 312 312
>>> 11/11/2008 15:59:26 13704656 8000 65535 bldix.c 3910 REKANHP
>>> /home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux aatos 313 313
>>> 11/11/2008 15:59:26 13704656 7200 5088 evaluate.c 27376 REKANHP
>>> 9.0.0.7 Linux aatos 314 314 11/11/2008 15:59:26 2158032 8000 65535
>>> bldix.c 3910 TESTI-PC /home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux
>>> aatos 315 315 11/11/2008 16:05:56 14708176 8000 65535 bldix.c 3910
>>> REKANHP /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 316 316
>>> 11/11/2008 16:05:56 14708176 8000 65535 bldix.c 3910 REKANHP
>>> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 317 317
>>> 11/11/2008 16:05:56 2158032 8000 65535 bldix.c 3910 TESTI-PC
>>> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 318 318
>>> 11/11/2008 16:05:56 14708176 8000 65535 bldix.c 3910 REKANHP
>>> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 319 319
>>> 11/11/2008 16:05:56 2158032 8000 65535 bldix.c 3910 TESTI-PC
>>> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 320 320
>>> 11/11/2008 16:05:57 14708176 8000 65535 bldix.c 3910 REKANHP
>>> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 321 321
>>> 11/11/2008 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
>>> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 322 322
>>> 11/11/2008 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
>>> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 323 323
>>> 11/11/2008 16:05:57 14708176 8000 65535 bldix.c 3910 REKANHP
>>> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 324 324
>>> 11/11/2008 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
>>> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 325 325
>>> 11/11/2008 16:05:57 14708176 8000 65535 bldix.c 3910 REKANHP
>>> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos 326 326
>>> 11/11/2008 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
>>> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos 327 327
>>> 11/11/2008 16:05:57 14708176 7200 5088 evaluate.c 27376 REKANHP
>>> 9.0.0.7 Linux aatos 328 328 11/11/2008 16:08:14 8666576 8000 65535
>>> bldix.c 3910 REKANHP /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux
>>> aatos 329 329 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910
>>> REKANHP /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos 330 330
>>> 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
>>> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos 331 331
>>> 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
>>> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos 332 332
>>> 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
>>> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos 333 333
>>> 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
>>> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos 334 334
>>> 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
>>> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos 335 335
>>> 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
>>> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos 336 336
>>> 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
>>> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos 337 337
>>> 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
>>> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos 338 338
>>> 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
>>> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos 339 339
>>> 11/11/2008 16:08:15 13704656 8000 65535 bldix.c 3910 TESTI-PC
>>> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
>>>
>>> Best regards,
>>> Reijo Pitkanen
>>
>>


Alex Wong (ADS) Posted on 2008-11-13 17:09:05.0Z
From: "Alex Wong \(ADS\)" <nobody@sybase.com>
Newsgroups: advantage.foxpro
References: <491a98d7@solutions.advantagedatabase.com> <491b0989@solutions.advantagedatabase.com> <491bec21@solutions.advantagedatabase.com>
Subject: Re: Error 5088: The index is corrupt. A reindex is necessary. Detected in Seek.
Date: Thu, 13 Nov 2008 10:09:05 -0700
Lines: 297
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 10.24.38.144
Message-ID: <491c5db2@solutions.advantagedatabase.com>
X-Trace: 13 Nov 2008 10:02:42 -0700, 10.24.38.144
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.144
Xref: solutions.advantagedatabase.com Advantage.FoxPro:279
Article PK: 1109633

The lines list below correspond to a failure from calls to statvfs(), a
system call. Unfortunately, we did not log the actual errno. The 65535 is
simply -1. So you are right that the server environment has something to do
with it. However, the call to statvfs() is inside the function that we are
preparing to re-index, probably in response to some index corruption.
However, the indexe files in question are temporary indexes created for each
statement and are exclusively used by a single connection, and thus should
never be corrupted unless there are read/write error. Can you run some
memory and HD checks on the server to make sure that there is no hardware
problem?

--
Alex

"Reijo Pitkanen" <reijo.pitkanen@somermatic.com> wrote in message
news:491bec21@solutions.advantagedatabase.com...
> Hi Alex,
> I think that this problem is not the tables but the server environment. So
> there is no use to send you the dbf-files.
> I encountered into this error situation, when testing a new linux server
> box for my customer.
> I did some more digging this morning, and tested exactly same data and
> same test program in an other, older linux box and I could not repeat the
> error. I changed my actual Delphi application so that it executes this
> query continuously with timer to ease testing, though the error can be
> reproduced also with ARC.
> Even the test client pc’s where the same.
> Then I copied the database table files from the working environment back
> to the failing server and tested again with same results i.e. Error 5088
> to the other client, while the other one keeps on working nicely.
>
> The working old server box is dual-core Intel Pentium 850 having Fedora 8
> kernel 2.6.24.4.-64.fc8. It has 3 GB system memory.
>
> The new failing server has Quad-Core Intel Xeon E504 cpu and 4GB of system
> memory.
> Linux distribution is CentOS 5.2 and the kernel version is
> 2.6.18-92.1.18.el5PAE.
>
> Both servers run Advantage database server 9.0.0.7, even the ads.conf
> files are identical, actually ads.conf is the default that setup script
> has done.
> There is nothing in the system logs of the server.
>
> So, could you say something about these lines in ads_err.adt table:
>
> 593 593 11/13/2008 10:06:- 7667152 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_0017.tmp 9.0.0.7 Linux aatos
> 594 594 11/13/2008 10:06:- 8670672 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_0019.tmp 9.0.0.7 Linux aatos
> 595 595 11/13/2008 10:06:- 7667152 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_0017.tmp 9.0.0.7 Linux aatos
> 596 596 11/13/2008 10:06:- 8670672 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_0019.tmp 9.0.0.7 Linux aatos
> 597 597 11/13/2008 10:06:- 7667152 7200 5088 evaluate.c 27376 TESTI-PC
> 9.0.0.7 Linux aatos
>
> Regards Reijo Pitkanen
> -------------------------------------------------------------------
> Alex Wong (ADS) wrote:
>> Hi Reijo,
>>
>> Can you send the tables to us so we can take a look? Please send to
>> advantage@ianywhere.com, attn: Alex Wong.
>>
>> Thanks,
>>
>> --
>> Alex
>>
>>
>>
>> "Reijo Pitkanen" <reijo.pitkanen@somermatic.com> wrote in message
>> news:491a98d7@solutions.advantagedatabase.com...
>>> Hi,
>>> When you run a complicated SQL-query against DBF/CDX tables
>>> simultaneously from two clients, you get to the first started client
>>> following error:
>>>
>>> “AdsQuery1: Error 7200: AQE Error: State = HY000; NativeError =
>>> 5088; [iAnywhere Solutions][Advantage SQL][ASA] Error 5088: The index
>>> is corrupt. A reindex is necessary. Detected in Seek.”
>>>
>>> If you run this query from only one client at a time it works perfectly.
>>>
>>> I am using ADS remote server v. 9.0.0.7 on Linux CentOS 5.2 box.
>>> OEM character set is FINNISH and Ansi set is finnish.
>>> Tables are foxpro 2.6 tables and the code page is not marked into the
>>> tables.
>>> The query result is little bit less than 20000 rows and the execution
>>> time is about 15 seconds.
>>> Test clients are Windows XP boxes running ARC v. 9.0.0.7 and the server
>>> connection is remote using TCP/IP .
>>>
>>> The query:
>>>
>>> Select s.SUTYONO,s.SUOSANRO,s.SUNITUNNUS as
>>> MATERIAALI,s.SULATENRO,s.SUTOTNUM,v.VLNITUNNUS,n.NINIMIKE,
>>> n.NIPIIRNO,v.VLMAARA,v.VLYKS,v.VLTEHTYKPL , w.TYOTILNRO, w.TYOASIAKAS,
>>> w.TYOPROJEKT, w.TYOPVM, s.ROWID as RIVID
>>> from "SULATENO.DBF" s
>>> left outer join "VALMISTE.DBF" v on ((s.SUTYONO=v.VLTYONRO) AND
>>> (s.SUOSANRO=v.VLOSANRO))
>>> left outer join "NIMIKE.DBF" n ON (v.VLNITUNNUS=n.NITUNNUS)
>>> left outer join "TYOT.DBF" w ON s.SUTYONO=w.tyonumero
>>> Order by s.SUTYONO,s.SUOSANRO
>>>
>>> Table definitions:
>>>
>>> Structure for database: V:\TUOMATIC\DB\SULATENO.DBF
>>> Number of data records: 0
>>> Date of last update : 12/20/07
>>> Field Field Name Type Width Dec Index
>>> 1 SUTYONO Numeric 6 Asc
>>> 2 SUOSANRO Numeric 3 Asc
>>> 3 SUNITUNNUS Character 10 Asc
>>> 4 SULATENRO Character 20
>>> 5 SUTOTNUM Numeric 10
>>> ** Total ** 50
>>>
>>> Structure for table: c:\tuomatic\db\valmiste.dbf
>>> Number of data records: 18946
>>> Date of last update: 08.11.2007
>>> Memo file block size: 64
>>> Code Page: 0
>>> Field Field Name Type Width Dec Index Collate
>>> 1 VLTYONRO Numeric 6 Desc Machine
>>> 2 VLOSANRO Numeric 3 Asc Machine
>>> 3 VLNITUNNUS Character 10 Asc Machine
>>> 4 VLMAARA Numeric 12 4
>>> 5 VLYKS Character 10
>>> 6 VLSVKO Character 4
>>> 7 VLLMISVKO Character 4
>>> 8 VLLMISPVM Date 8
>>> 9 VLTEHTYKPL Numeric 12 4
>>> 10 VLLISAINFO Character 70
>>> 11 VLTILA Character 10
>>> 12 VLSARJANRO Numeric 3
>>> 13 VLLOPPUTUO Character 10
>>> 14 VLMEMO Memo 10
>>> ** Total ** 173
>>>
>>> Structure for table: c:\tuomatic\db\tyot.dbf
>>> Number of data records: 6785
>>> Date of last update: 08.11.2007
>>> Memo file block size: 64
>>> Code Page: 0
>>> Field Field Name Type Width Dec Index Collate
>>> 1 TYONUMERO Numeric 6 Desc Machine
>>> 2 TYOTILNRO Numeric 6 Desc Machine
>>> 3 TYOASIAKAS Character 40
>>> 4 TYOPROJEKT Character 40
>>> 5 TYOPVM Date 8
>>> 6 TYOMUUPVM Date 8
>>> 7 TYOSVKO Character 4
>>> 8 TYOTILA Character 10
>>> 9 TYOLISAT Character 140
>>> 10 TYOVALMPVM Date 8
>>> 11 TYOVALMVKO Character 4
>>> 12 TYOMAARTUL Logical 1
>>> 13 TYOMEMO Memo 10
>>> 14 TYOOSTOT Character 70
>>> ** Total ** 356
>>>
>>> Structure for table: r:\db\nimike.dbf
>>> Number of data records: 16770
>>> Date of last update: 14.10.1908
>>> Memo file block size: 64
>>> Code Page: 0
>>> Field Field Name Type Width Dec Index Collate
>>> 1 NITUNNUS Character 10 Asc Machine
>>> 2 NINIMIKE Character 40 Asc Machine
>>> 3 NILISAT Character 40
>>> 4 NIRYHMA Character 10
>>> 5 NIPIIRNO Character 20 Asc Machine
>>> 6 NISTANDARD Character 20
>>> 7 NIASIAKAS Numeric 5
>>> 8 NIKUSTLAJI Numeric 2
>>> 9 NINIMILAJI Numeric 2
>>> 10 NIKASYKS Character 10
>>> 11 NIHINYKS Character 10
>>> 12 NIMUUNKER Numeric 10 4
>>> 13 NIYKSPAINO Numeric 10 4
>>> 14 NIABCLUOK Character 2
>>> 15 NIVARASTO Numeric 5 Asc Machine
>>> 16 NISALDO Numeric 12 4
>>> 17 NIVARAUS Numeric 12 4
>>> 18 NIVARVKO Character 4
>>> 19 NIVARAAJA Numeric 6
>>> 20 NISAAPUU Numeric 12 4
>>> 21 NISAAPVKO Character 4
>>> 22 NITUOJA Numeric 6
>>> 23 NIHUKKALIS Numeric 12 4
>>> 24 NITILPISTE Numeric 12 4
>>> 25 NIVALMERA Numeric 12 4
>>> 26 NIPAKKOKO Numeric 12 4
>>> 27 NITOIAIKA Numeric 4
>>> 28 NIVALMAIKA Numeric 8 3
>>> 29 NITOIMITT1 Numeric 5
>>> 30 NIOSTOHI Numeric 12 4
>>> 31 NIMYYNTIHI Numeric 12 4
>>> 32 NIHINTAPVM Date 8
>>> 33 NIMUUTOSPV Date 8
>>> 34 NIINVVALI Numeric 2
>>> 35 NIINVPVM Date 8
>>> 36 NIRAKEPVM Date 8
>>> 37 NITYOVPVM Date 8
>>> 38 NITARJHIN Numeric 12 4
>>> 39 NIKALEPRO Numeric 5 2
>>> 40 NIINVSALDO Numeric 12 4
>>> 41 NIMEMO Memo 10
>>> 42 NIPICTURE Character 40
>>> 43 NILOKERO Character 20
>>> ** Total ** 483
>>>
>>> -----------------------------------------------------------------------------------
>>> Here is a small sample of ads_err.adt-table from the testing time:
>>>
>>> Created: 11/12/2008 10:49:56
>>>
>>> Item Error_Number DateTime Thread_Num Err_Class Error_Code ADS_Source
>>> Src_Line Cnnct_Num Cnnct_Name FileName ADS_Ver Environmnt OS_Version
>>> HostName More_Info
>>>

306 306 11/11/2008 15:58:53 10673616 7200 5088 evaluate.c 27376 TESTI-PC
9.0.0.7 Linux aatos
307 307 11/11/2008 15:58:53 2158032 8000 65535 bldix.c 3910 REKANHP
/home/tuomatic/db/tim_0202.tmp 9.0.0.7 Linux aatos
308 308 11/11/2008 15:59:26 13704656 8000 65535 bldix.c 3910 REKANHP
/home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux aatos
309 309 11/11/2008 15:59:26 13704656 8000 65535 bldix.c 3910 REKANHP
/home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux aatos
310 310 11/11/2008 15:59:26 2158032 8000 65535 bldix.c 3910 TESTI-PC
/home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux aatos
311 311 11/11/2008 15:59:26 2158032 8000 65535 bldix.c 3910 TESTI-PC
/home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux aatos
312 312 11/11/2008 15:59:26 13704656 8000 65535 bldix.c 3910 REKANHP
/home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux aatos
313 313 11/11/2008 15:59:26 13704656 7200 5088 evaluate.c 27376 REKANHP
9.0.0.7 Linux aatos

314 314 11/11/2008 15:59:26 2158032 8000 65535 bldix.c 3910 TESTI-PC
/home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux aatos
315 315 11/11/2008 16:05:56 14708176 8000 65535 bldix.c 3910 REKANHP
/home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
316 316 11/11/2008 16:05:56 14708176 8000 65535 bldix.c 3910 REKANHP
/home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
317 317 11/11/2008 16:05:56 2158032 8000 65535 bldix.c 3910 TESTI-PC
/home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
318 318 11/11/2008 16:05:56 14708176 8000 65535 bldix.c 3910 REKANHP
/home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
319 319 11/11/2008 16:05:56 2158032 8000 65535 bldix.c 3910 TESTI-PC
/home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
320 320 11/11/2008 16:05:57 14708176 8000 65535 bldix.c 3910 REKANHP
/home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
321 321 11/11/2008 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
/home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
322 322 11/11/2008 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
/home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
323 323 11/11/2008 16:05:57 14708176 8000 65535 bldix.c 3910 REKANHP
/home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
324 324 11/11/2008 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
/home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
325 325 11/11/2008 16:05:57 14708176 8000 65535 bldix.c 3910 REKANHP
/home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
326 326 11/11/2008 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
/home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
327 327 11/11/2008 16:05:57 14708176 7200 5088 evaluate.c 27376 REKANHP
9.0.0.7 Linux aatos

328 328 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
/home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
329 329 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
/home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
330 330 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
/home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
331 331 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
/home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
332 332 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
/home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
333 333 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
/home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
334 334 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
/home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
335 335 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
/home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
336 336 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
/home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
337 337 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
/home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
338 338 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
/home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
339 339 11/11/2008 16:08:15 13704656 8000 65535 bldix.c 3910 TESTI-PC
/home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos


Reijo Pitkanen Posted on 2008-11-13 17:27:28.0Z
Date: Thu, 13 Nov 2008 19:27:28 +0200
From: Reijo Pitkanen <reijo.pitkanen@somermatic.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: advantage.foxpro
Subject: Re: Error 5088: The index is corrupt. A reindex is necessary. Detected in Seek.
References: <491a98d7@solutions.advantagedatabase.com> <491b0989@solutions.advantagedatabase.com> <491bec21@solutions.advantagedatabase.com> <491c5db2@solutions.advantagedatabase.com>
In-Reply-To: <491c5db2@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 86.60.191.249
Message-ID: <491c6201@solutions.advantagedatabase.com>
X-Trace: 13 Nov 2008 10:21:05 -0700, 86.60.191.249
Lines: 307
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!86.60.191.249
Xref: solutions.advantagedatabase.com Advantage.FoxPro:280
Article PK: 1109634

Did you notice my extra info? That is:
I can run the query from both clients without errors, if I reduce the
number of worker threads to 1.

I doubt that this has something to do with multi threading and is not a
hardware issue.
--
Reijo

Alex Wong (ADS) wrote:
> The lines list below correspond to a failure from calls to statvfs(), a
> system call. Unfortunately, we did not log the actual errno. The 65535 is
> simply -1. So you are right that the server environment has something to do
> with it. However, the call to statvfs() is inside the function that we are
> preparing to re-index, probably in response to some index corruption.
> However, the indexe files in question are temporary indexes created for each
> statement and are exclusively used by a single connection, and thus should
> never be corrupted unless there are read/write error. Can you run some
> memory and HD checks on the server to make sure that there is no hardware
> problem?
>
> --
> Alex
>
>
> "Reijo Pitkanen" <reijo.pitkanen@somermatic.com> wrote in message
> news:491bec21@solutions.advantagedatabase.com...
>> Hi Alex,
>> I think that this problem is not the tables but the server environment. So
>> there is no use to send you the dbf-files.
>> I encountered into this error situation, when testing a new linux server
>> box for my customer.
>> I did some more digging this morning, and tested exactly same data and
>> same test program in an other, older linux box and I could not repeat the
>> error. I changed my actual Delphi application so that it executes this
>> query continuously with timer to ease testing, though the error can be
>> reproduced also with ARC.
>> Even the test client pcÂ’s where the same.
>> Then I copied the database table files from the working environment back
>> to the failing server and tested again with same results i.e. Error 5088
>> to the other client, while the other one keeps on working nicely.
>>
>> The working old server box is dual-core Intel Pentium 850 having Fedora 8
>> kernel 2.6.24.4.-64.fc8. It has 3 GB system memory.
>>
>> The new failing server has Quad-Core Intel Xeon E504 cpu and 4GB of system
>> memory.
>> Linux distribution is CentOS 5.2 and the kernel version is
>> 2.6.18-92.1.18.el5PAE.
>>
>> Both servers run Advantage database server 9.0.0.7, even the ads.conf
>> files are identical, actually ads.conf is the default that setup script
>> has done.
>> There is nothing in the system logs of the server.
>>
>> So, could you say something about these lines in ads_err.adt table:
>>
>> 593 593 11/13/2008 10:06:- 7667152 8000 65535 bldix.c 3910 TESTI-PC
>> /home/tuomatic/db/tim_0017.tmp 9.0.0.7 Linux aatos
>> 594 594 11/13/2008 10:06:- 8670672 8000 65535 bldix.c 3910 REKANHP
>> /home/tuomatic/db/tim_0019.tmp 9.0.0.7 Linux aatos
>> 595 595 11/13/2008 10:06:- 7667152 8000 65535 bldix.c 3910 TESTI-PC
>> /home/tuomatic/db/tim_0017.tmp 9.0.0.7 Linux aatos
>> 596 596 11/13/2008 10:06:- 8670672 8000 65535 bldix.c 3910 REKANHP
>> /home/tuomatic/db/tim_0019.tmp 9.0.0.7 Linux aatos
>> 597 597 11/13/2008 10:06:- 7667152 7200 5088 evaluate.c 27376 TESTI-PC
>> 9.0.0.7 Linux aatos
>>
>> Regards Reijo Pitkanen
>> -------------------------------------------------------------------
>> Alex Wong (ADS) wrote:
>>> Hi Reijo,
>>>
>>> Can you send the tables to us so we can take a look? Please send to
>>> advantage@ianywhere.com, attn: Alex Wong.
>>>
>>> Thanks,
>>>
>>> --
>>> Alex
>>>
>>>
>>>
>>> "Reijo Pitkanen" <reijo.pitkanen@somermatic.com> wrote in message
>>> news:491a98d7@solutions.advantagedatabase.com...
>>>> Hi,
>>>> When you run a complicated SQL-query against DBF/CDX tables
>>>> simultaneously from two clients, you get to the first started client
>>>> following error:
>>>>
>>>> “AdsQuery1: Error 7200: AQE Error: State = HY000; NativeError =
>>>> 5088; [iAnywhere Solutions][Advantage SQL][ASA] Error 5088: The index
>>>> is corrupt. A reindex is necessary. Detected in Seek.”
>>>>
>>>> If you run this query from only one client at a time it works perfectly.
>>>>
>>>> I am using ADS remote server v. 9.0.0.7 on Linux CentOS 5.2 box.
>>>> OEM character set is FINNISH and Ansi set is finnish.
>>>> Tables are foxpro 2.6 tables and the code page is not marked into the
>>>> tables.
>>>> The query result is little bit less than 20000 rows and the execution
>>>> time is about 15 seconds.
>>>> Test clients are Windows XP boxes running ARC v. 9.0.0.7 and the server
>>>> connection is remote using TCP/IP .
>>>>
>>>> The query:
>>>>
>>>> Select s.SUTYONO,s.SUOSANRO,s.SUNITUNNUS as
>>>> MATERIAALI,s.SULATENRO,s.SUTOTNUM,v.VLNITUNNUS,n.NINIMIKE,
>>>> n.NIPIIRNO,v.VLMAARA,v.VLYKS,v.VLTEHTYKPL , w.TYOTILNRO, w.TYOASIAKAS,
>>>> w.TYOPROJEKT, w.TYOPVM, s.ROWID as RIVID
>>>> from "SULATENO.DBF" s
>>>> left outer join "VALMISTE.DBF" v on ((s.SUTYONO=v.VLTYONRO) AND
>>>> (s.SUOSANRO=v.VLOSANRO))
>>>> left outer join "NIMIKE.DBF" n ON (v.VLNITUNNUS=n.NITUNNUS)
>>>> left outer join "TYOT.DBF" w ON s.SUTYONO=w.tyonumero
>>>> Order by s.SUTYONO,s.SUOSANRO
>>>>
>>>> Table definitions:
>>>>
>>>> Structure for database: V:\TUOMATIC\DB\SULATENO.DBF
>>>> Number of data records: 0
>>>> Date of last update : 12/20/07
>>>> Field Field Name Type Width Dec Index
>>>> 1 SUTYONO Numeric 6 Asc
>>>> 2 SUOSANRO Numeric 3 Asc
>>>> 3 SUNITUNNUS Character 10 Asc
>>>> 4 SULATENRO Character 20
>>>> 5 SUTOTNUM Numeric 10
>>>> ** Total ** 50
>>>>
>>>> Structure for table: c:\tuomatic\db\valmiste.dbf
>>>> Number of data records: 18946
>>>> Date of last update: 08.11.2007
>>>> Memo file block size: 64
>>>> Code Page: 0
>>>> Field Field Name Type Width Dec Index Collate
>>>> 1 VLTYONRO Numeric 6 Desc Machine
>>>> 2 VLOSANRO Numeric 3 Asc Machine
>>>> 3 VLNITUNNUS Character 10 Asc Machine
>>>> 4 VLMAARA Numeric 12 4
>>>> 5 VLYKS Character 10
>>>> 6 VLSVKO Character 4
>>>> 7 VLLMISVKO Character 4
>>>> 8 VLLMISPVM Date 8
>>>> 9 VLTEHTYKPL Numeric 12 4
>>>> 10 VLLISAINFO Character 70
>>>> 11 VLTILA Character 10
>>>> 12 VLSARJANRO Numeric 3
>>>> 13 VLLOPPUTUO Character 10
>>>> 14 VLMEMO Memo 10
>>>> ** Total ** 173
>>>>
>>>> Structure for table: c:\tuomatic\db\tyot.dbf
>>>> Number of data records: 6785
>>>> Date of last update: 08.11.2007
>>>> Memo file block size: 64
>>>> Code Page: 0
>>>> Field Field Name Type Width Dec Index Collate
>>>> 1 TYONUMERO Numeric 6 Desc Machine
>>>> 2 TYOTILNRO Numeric 6 Desc Machine
>>>> 3 TYOASIAKAS Character 40
>>>> 4 TYOPROJEKT Character 40
>>>> 5 TYOPVM Date 8
>>>> 6 TYOMUUPVM Date 8
>>>> 7 TYOSVKO Character 4
>>>> 8 TYOTILA Character 10
>>>> 9 TYOLISAT Character 140
>>>> 10 TYOVALMPVM Date 8
>>>> 11 TYOVALMVKO Character 4
>>>> 12 TYOMAARTUL Logical 1
>>>> 13 TYOMEMO Memo 10
>>>> 14 TYOOSTOT Character 70
>>>> ** Total ** 356
>>>>
>>>> Structure for table: r:\db\nimike.dbf
>>>> Number of data records: 16770
>>>> Date of last update: 14.10.1908
>>>> Memo file block size: 64
>>>> Code Page: 0
>>>> Field Field Name Type Width Dec Index Collate
>>>> 1 NITUNNUS Character 10 Asc Machine
>>>> 2 NINIMIKE Character 40 Asc Machine
>>>> 3 NILISAT Character 40
>>>> 4 NIRYHMA Character 10
>>>> 5 NIPIIRNO Character 20 Asc Machine
>>>> 6 NISTANDARD Character 20
>>>> 7 NIASIAKAS Numeric 5
>>>> 8 NIKUSTLAJI Numeric 2
>>>> 9 NINIMILAJI Numeric 2
>>>> 10 NIKASYKS Character 10
>>>> 11 NIHINYKS Character 10
>>>> 12 NIMUUNKER Numeric 10 4
>>>> 13 NIYKSPAINO Numeric 10 4
>>>> 14 NIABCLUOK Character 2
>>>> 15 NIVARASTO Numeric 5 Asc Machine
>>>> 16 NISALDO Numeric 12 4
>>>> 17 NIVARAUS Numeric 12 4
>>>> 18 NIVARVKO Character 4
>>>> 19 NIVARAAJA Numeric 6
>>>> 20 NISAAPUU Numeric 12 4
>>>> 21 NISAAPVKO Character 4
>>>> 22 NITUOJA Numeric 6
>>>> 23 NIHUKKALIS Numeric 12 4
>>>> 24 NITILPISTE Numeric 12 4
>>>> 25 NIVALMERA Numeric 12 4
>>>> 26 NIPAKKOKO Numeric 12 4
>>>> 27 NITOIAIKA Numeric 4
>>>> 28 NIVALMAIKA Numeric 8 3
>>>> 29 NITOIMITT1 Numeric 5
>>>> 30 NIOSTOHI Numeric 12 4
>>>> 31 NIMYYNTIHI Numeric 12 4
>>>> 32 NIHINTAPVM Date 8
>>>> 33 NIMUUTOSPV Date 8
>>>> 34 NIINVVALI Numeric 2
>>>> 35 NIINVPVM Date 8
>>>> 36 NIRAKEPVM Date 8
>>>> 37 NITYOVPVM Date 8
>>>> 38 NITARJHIN Numeric 12 4
>>>> 39 NIKALEPRO Numeric 5 2
>>>> 40 NIINVSALDO Numeric 12 4
>>>> 41 NIMEMO Memo 10
>>>> 42 NIPICTURE Character 40
>>>> 43 NILOKERO Character 20
>>>> ** Total ** 483
>>>>
>>>> -----------------------------------------------------------------------------------
>>>> Here is a small sample of ads_err.adt-table from the testing time:
>>>>
>>>> Created: 11/12/2008 10:49:56
>>>>
>>>> Item Error_Number DateTime Thread_Num Err_Class Error_Code ADS_Source
>>>> Src_Line Cnnct_Num Cnnct_Name FileName ADS_Ver Environmnt OS_Version
>>>> HostName More_Info
>>>>
> 306 306 11/11/2008 15:58:53 10673616 7200 5088 evaluate.c 27376 TESTI-PC
> 9.0.0.7 Linux aatos
> 307 307 11/11/2008 15:58:53 2158032 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_0202.tmp 9.0.0.7 Linux aatos
> 308 308 11/11/2008 15:59:26 13704656 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux aatos
> 309 309 11/11/2008 15:59:26 13704656 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux aatos
> 310 310 11/11/2008 15:59:26 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux aatos
> 311 311 11/11/2008 15:59:26 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux aatos
> 312 312 11/11/2008 15:59:26 13704656 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_0213.tmp 9.0.0.7 Linux aatos
> 313 313 11/11/2008 15:59:26 13704656 7200 5088 evaluate.c 27376 REKANHP
> 9.0.0.7 Linux aatos
>
> 314 314 11/11/2008 15:59:26 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_0215.tmp 9.0.0.7 Linux aatos
> 315 315 11/11/2008 16:05:56 14708176 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
> 316 316 11/11/2008 16:05:56 14708176 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
> 317 317 11/11/2008 16:05:56 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
> 318 318 11/11/2008 16:05:56 14708176 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
> 319 319 11/11/2008 16:05:56 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
> 320 320 11/11/2008 16:05:57 14708176 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
> 321 321 11/11/2008 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
> 322 322 11/11/2008 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
> 323 323 11/11/2008 16:05:57 14708176 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
> 324 324 11/11/2008 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
> 325 325 11/11/2008 16:05:57 14708176 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02B7.tmp 9.0.0.7 Linux aatos
> 326 326 11/11/2008 16:05:57 2158032 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02B9.tmp 9.0.0.7 Linux aatos
> 327 327 11/11/2008 16:05:57 14708176 7200 5088 evaluate.c 27376 REKANHP
> 9.0.0.7 Linux aatos
>
> 328 328 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
> 329 329 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
> 330 330 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
> 331 331 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
> 332 332 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
> 333 333 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
> 334 334 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
> 335 335 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
> 336 336 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
> 337 337 11/11/2008 16:08:14 8666576 8000 65535 bldix.c 3910 REKANHP
> /home/tuomatic/db/tim_02F2.tmp 9.0.0.7 Linux aatos
> 338 338 11/11/2008 16:08:14 13704656 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
> 339 339 11/11/2008 16:08:15 13704656 8000 65535 bldix.c 3910 TESTI-PC
> /home/tuomatic/db/tim_02F4.tmp 9.0.0.7 Linux aatos
>
>


Reijo Pitkanen Posted on 2008-11-18 06:52:07.0Z
Date: Tue, 18 Nov 2008 08:52:07 +0200
From: Reijo Pitkanen <reijo.pitkanen@somermatic.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: advantage.foxpro
Subject: Re: Error 5088: The index is corrupt. A reindex is necessary. Detected in Seek.
References: <491a98d7@solutions.advantagedatabase.com> <491b0989@solutions.advantagedatabase.com> <491bec21@solutions.advantagedatabase.com> <491c5db2@solutions.advantagedatabase.com> <491c6201@solutions.advantagedatabase.com>
In-Reply-To: <491c6201@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 86.60.191.249
Message-ID: <49226499@solutions.advantagedatabase.com>
X-Trace: 17 Nov 2008 23:45:45 -0700, 86.60.191.249
Lines: 66
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!86.60.191.249
Xref: solutions.advantagedatabase.com Advantage.FoxPro:281
Article PK: 1109636

Hi Alex,
You are probably waiting for results from hardware test. The server is
in perfect condition according to HirenÂ’s test tools.
I had to put this server into production last week end, because the old
server was having some hardware problems. Now the Intel Xeon Quad-Core
server is running advantage production database with only one worker
thread.
I can not play any more with this server, so I hope that you can build a
test environment and find the cause to this behavior.
I am quite definite that multi threading has caused problems also in
Pentium 4 Linux servers. Namely we have been struggling for over a year
with following problem:
Advantage Remote Database server SQL query execution halts for more than
a minute and then execution continues normally as nothing has happened.
That is, after getting over the halt situation I get the query result to
client normally and I can do data browsing and manipulation in usual manner.
Halting occurs randomly but quite often, several times in a day. Halting
is not depending on the size of the target dbf table or the complexity
of the query. Halt condition occurs even when there is only one user
(client) connected to the database server, so halting can not be caused
by heavy network traffic or table locking by other advantage clients or
clients that are using the same foxpro tables with genuine foxpro
applications.
When the halt occurs it halts all connected clients, so the problem must
be on the server side.
It seems to me, that the remote server does not take the query to
execution for some reason. This is based on the notice, that when
looking the resource usage on the linux server with 'top' command, the
resource consumption of the Advantage database process keeps on very low
level during the halt condition and then raises for a very short time to
near top level, when the halt ends and the query result is returned to
the requesting client. Top doesn't show any special load by other tasks
during the advantage halt condition (Cpu is Idle over 98%). This
behavior was first discovered in ADS version 8.1.0.26 and continued
after we updated to version 9.0.0.7. ADS was configured to use 8 worker
threads and it newer came to my mind to test with one worker thread.
I have earlier reported this behavior to the Swedish distributor of
Advantage and to mr. Tim Croucher Sybase (UK).

-Reijo

Reijo Pitkanen wrote:
> Did you notice my extra info? That is:
> I can run the query from both clients without errors, if I reduce the
> number of worker threads to 1.
>
> I doubt that this has something to do with multi threading and is not a
> hardware issue.
> --
> Reijo
>
> Alex Wong (ADS) wrote:
>> The lines list below correspond to a failure from calls to statvfs(),
>> a system call. Unfortunately, we did not log the actual errno. The
>> 65535 is simply -1. So you are right that the server environment has
>> something to do with it. However, the call to statvfs() is inside the
>> function that we are preparing to re-index, probably in response to
>> some index corruption. However, the indexe files in question are
>> temporary indexes created for each statement and are exclusively used
>> by a single connection, and thus should never be corrupted unless
>> there are read/write error. Can you run some memory and HD checks on
>> the server to make sure that there is no hardware problem?
>>
>> --
>> Alex
>>


Jed Thomet Posted on 2008-12-01 17:35:19.0Z
Date: Mon, 1 Dec 2008 17:35:19 +0000 (UTC)
Message-ID: <6bf7df5216fbc8cb21b7a4841924@devzone.advantagedatabase.com>
From: Jed Thomet <jedt_no_unrequested_emails_please@ianywhere.com>
Subject: Re: Error 5088: The index is corrupt. A reindex is necessary. Detectedin Seek.
Newsgroups: Advantage.FoxPro
References: <49226499@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
NNTP-Posting-Host: 10.24.38.106
X-Trace: 1 Dec 2008 10:28:51 -0700, 10.24.38.106
Lines: 99
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.106
Xref: solutions.advantagedatabase.com Advantage.FoxPro:284
Article PK: 1109637

Hello Reijo,

Unfortunately, I do not have any great ideas off-hand. I do, however, have
a number of questions:
* Is the kernel 64-bit or 32-bit?
* Is the kernel SMP or not? (Assuming it is an SMP kernel, would you be
willing to try the operation with the non-SMP kernel loaded and let us know
how that goes?)
* What file system does the data directory use?

Thes answers to these questions may help us refine our theories about what
is happening here.

Jed Thomet
Advantage R&D

> Hi Alex,
> You are probably waiting for results from hardware test. The server is
> in perfect condition according to Hiren's test tools.
> I had to put this server into production last week end, because the
> old
> server was having some hardware problems. Now the Intel Xeon Quad-Core
> server is running advantage production database with only one worker
> thread.
> I can not play any more with this server, so I hope that you can build
> a
> test environment and find the cause to this behavior.
> I am quite definite that multi threading has caused problems also in
> Pentium 4 Linux servers. Namely we have been struggling for over a
> year
> with following problem:
> Advantage Remote Database server SQL query execution halts for more
> than
> a minute and then execution continues normally as nothing has
> happened.
> That is, after getting over the halt situation I get the query result
> to
> client normally and I can do data browsing and manipulation in usual
> manner.
> Halting occurs randomly but quite often, several times in a day.
> Halting
> is not depending on the size of the target dbf table or the complexity
> of the query. Halt condition occurs even when there is only one user
> (client) connected to the database server, so halting can not be
> caused
> by heavy network traffic or table locking by other advantage clients
> or
> clients that are using the same foxpro tables with genuine foxpro
> applications.
> When the halt occurs it halts all connected clients, so the problem
> must
> be on the server side.
> It seems to me, that the remote server does not take the query to
> execution for some reason. This is based on the notice, that when
> looking the resource usage on the linux server with 'top' command, the
> resource consumption of the Advantage database process keeps on very
> low
> level during the halt condition and then raises for a very short time
> to
> near top level, when the halt ends and the query result is returned to
> the requesting client. Top doesn't show any special load by other
> tasks
> during the advantage halt condition (Cpu is Idle over 98%). This
> behavior was first discovered in ADS version 8.1.0.26 and continued
> after we updated to version 9.0.0.7. ADS was configured to use 8
> worker
> threads and it newer came to my mind to test with one worker thread.
> I have earlier reported this behavior to the Swedish distributor of
> Advantage and to mr. Tim Croucher Sybase (UK).
> -Reijo
>
> Reijo Pitkanen wrote:
>
>> Did you notice my extra info? That is:
>> I can run the query from both clients without errors, if I reduce the
>> number of worker threads to 1.
>> I doubt that this has something to do with multi threading and is not
>> a
>> hardware issue.
>> --
>> Reijo
>> Alex Wong (ADS) wrote:
>>
>>> The lines list below correspond to a failure from calls to
>>> statvfs(), a system call. Unfortunately, we did not log the actual
>>> errno. The 65535 is simply -1. So you are right that the server
>>> environment has something to do with it. However, the call to
>>> statvfs() is inside the function that we are preparing to re-index,
>>> probably in response to some index corruption. However, the indexe
>>> files in question are temporary indexes created for each statement
>>> and are exclusively used by a single connection, and thus should
>>> never be corrupted unless there are read/write error. Can you run
>>> some memory and HD checks on the server to make sure that there is
>>> no hardware problem?
>>>
>>> -- Alex
>>>


Reijo Pitkanen Posted on 2008-12-02 09:08:52.0Z
Date: Tue, 02 Dec 2008 11:08:52 +0200
From: Reijo Pitkanen <reijo.pitkanen@somermatic.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: Advantage.FoxPro
Subject: Re: Error 5088: The index is corrupt. A reindex is necessary. Detectedin Seek.
References: <49226499@solutions.advantagedatabase.com> <6bf7df5216fbc8cb21b7a4841924@devzone.advantagedatabase.com>
In-Reply-To: <6bf7df5216fbc8cb21b7a4841924@devzone.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 86.60.191.249
Message-ID: <4934f9a3@solutions.advantagedatabase.com>
X-Trace: 2 Dec 2008 02:02:27 -0700, 86.60.191.249
Lines: 127
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!86.60.191.249
Xref: solutions.advantagedatabase.com Advantage.FoxPro:285
Article PK: 1109640

Hi,
The Linux distro is CentOS 5.2 32-bit

Kernel version is 2.6.18-92.1.18.el5PAE

It is SMP kernel using all four processor cores.
File system is EXT3.

I will try the non SMP kernel in near future as soon as my client allows
me to play with this server.

I have also good news, namely the halt problem is solved:
When sharing free DBF-files with linux ADS-server and other applications
with samba you have to deny op locks in Smb.conf e.g. set in to the
global section of your smb.conf-file the following line:

kernel oplocks = no

and to the samba share definition section following 2 lines:

oplocks = no
level2 oplocks = no

Regards Reijo

Jed Thomet wrote:
> Hello Reijo,
>
> Unfortunately, I do not have any great ideas off-hand. I do, however,
> have a number of questions: * Is the kernel 64-bit or 32-bit?
> * Is the kernel SMP or not? (Assuming it is an SMP kernel, would you be
> willing to try the operation with the non-SMP kernel loaded and let us
> know how that goes?)
> * What file system does the data directory use?
>
> Thes answers to these questions may help us refine our theories about
> what is happening here.
>
> Jed Thomet
> Advantage R&D
>
>> Hi Alex,
>> You are probably waiting for results from hardware test. The server is
>> in perfect condition according to Hiren's test tools.
>> I had to put this server into production last week end, because the
>> old
>> server was having some hardware problems. Now the Intel Xeon Quad-Core
>> server is running advantage production database with only one worker
>> thread.
>> I can not play any more with this server, so I hope that you can build
>> a
>> test environment and find the cause to this behavior.
>> I am quite definite that multi threading has caused problems also in
>> Pentium 4 Linux servers. Namely we have been struggling for over a
>> year
>> with following problem:
>> Advantage Remote Database server SQL query execution halts for more
>> than
>> a minute and then execution continues normally as nothing has
>> happened.
>> That is, after getting over the halt situation I get the query result
>> to
>> client normally and I can do data browsing and manipulation in usual
>> manner.
>> Halting occurs randomly but quite often, several times in a day.
>> Halting
>> is not depending on the size of the target dbf table or the complexity
>> of the query. Halt condition occurs even when there is only one user
>> (client) connected to the database server, so halting can not be
>> caused
>> by heavy network traffic or table locking by other advantage clients
>> or
>> clients that are using the same foxpro tables with genuine foxpro
>> applications.
>> When the halt occurs it halts all connected clients, so the problem
>> must
>> be on the server side.
>> It seems to me, that the remote server does not take the query to
>> execution for some reason. This is based on the notice, that when
>> looking the resource usage on the linux server with 'top' command, the
>> resource consumption of the Advantage database process keeps on very
>> low
>> level during the halt condition and then raises for a very short time
>> to
>> near top level, when the halt ends and the query result is returned to
>> the requesting client. Top doesn't show any special load by other
>> tasks
>> during the advantage halt condition (Cpu is Idle over 98%). This
>> behavior was first discovered in ADS version 8.1.0.26 and continued
>> after we updated to version 9.0.0.7. ADS was configured to use 8
>> worker
>> threads and it newer came to my mind to test with one worker thread.
>> I have earlier reported this behavior to the Swedish distributor of
>> Advantage and to mr. Tim Croucher Sybase (UK).
>> -Reijo
>>
>> Reijo Pitkanen wrote:
>>
>>> Did you notice my extra info? That is:
>>> I can run the query from both clients without errors, if I reduce the
>>> number of worker threads to 1.
>>> I doubt that this has something to do with multi threading and is not
>>> a
>>> hardware issue.
>>> --
>>> Reijo
>>> Alex Wong (ADS) wrote:
>>>
>>>> The lines list below correspond to a failure from calls to
>>>> statvfs(), a system call. Unfortunately, we did not log the actual
>>>> errno. The 65535 is simply -1. So you are right that the server
>>>> environment has something to do with it. However, the call to
>>>> statvfs() is inside the function that we are preparing to re-index,
>>>> probably in response to some index corruption. However, the indexe
>>>> files in question are temporary indexes created for each statement
>>>> and are exclusively used by a single connection, and thus should
>>>> never be corrupted unless there are read/write error. Can you run
>>>> some memory and HD checks on the server to make sure that there is
>>>> no hardware problem?
>>>>
>>>> -- Alex
>>>>
>
>


Alex Wong (ADS) Posted on 2008-11-18 16:29:35.0Z
From: "Alex Wong \(ADS\)" <nobody@sybase.com>
Newsgroups: advantage.foxpro
References: <491a98d7@solutions.advantagedatabase.com> <491b0989@solutions.advantagedatabase.com> <491bec21@solutions.advantagedatabase.com> <491c5db2@solutions.advantagedatabase.com> <491c6201@solutions.advantagedatabase.com> <49226499@solutions.advantagedatabase.com>
Subject: Re: Error 5088: The index is corrupt. A reindex is necessary. Detected in Seek.
Date: Tue, 18 Nov 2008 09:29:35 -0700
Lines: 80
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.144
Message-ID: <4922ebf1@solutions.advantagedatabase.com>
X-Trace: 18 Nov 2008 09:23:13 -0700, 10.24.38.144
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.144
Xref: solutions.advantagedatabase.com Advantage.FoxPro:282
Article PK: 1109638

Hi Reijo,

Sorry, I was still thinking about this and could not come up with anything
good. Thanks for the detailed information. It does seem that the
multi-threading may be related to the problem. I have little knowledge with
threading in Linux and could not locate any useful information on the Web,
so I will ask our Linux expert to come in with suggestions.

--
Alex

"Reijo Pitkanen" <reijo.pitkanen@somermatic.com> wrote in message
news:49226499@solutions.advantagedatabase.com...
> Hi Alex,
> You are probably waiting for results from hardware test. The server is in
> perfect condition according to Hiren’s test tools.
> I had to put this server into production last week end, because the old
> server was having some hardware problems. Now the Intel Xeon Quad-Core
> server is running advantage production database with only one worker
> thread.
> I can not play any more with this server, so I hope that you can build a
> test environment and find the cause to this behavior.
> I am quite definite that multi threading has caused problems also in
> Pentium 4 Linux servers. Namely we have been struggling for over a year
> with following problem:
> Advantage Remote Database server SQL query execution halts for more than a
> minute and then execution continues normally as nothing has happened. That
> is, after getting over the halt situation I get the query result to client
> normally and I can do data browsing and manipulation in usual manner.
> Halting occurs randomly but quite often, several times in a day. Halting
> is not depending on the size of the target dbf table or the complexity of
> the query. Halt condition occurs even when there is only one user (client)
> connected to the database server, so halting can not be caused by heavy
> network traffic or table locking by other advantage clients or clients
> that are using the same foxpro tables with genuine foxpro applications.
> When the halt occurs it halts all connected clients, so the problem must
> be on the server side.
> It seems to me, that the remote server does not take the query to
> execution for some reason. This is based on the notice, that when looking
> the resource usage on the linux server with 'top' command, the resource
> consumption of the Advantage database process keeps on very low level
> during the halt condition and then raises for a very short time to near
> top level, when the halt ends and the query result is returned to the
> requesting client. Top doesn't show any special load by other tasks during
> the advantage halt condition (Cpu is Idle over 98%). This behavior was
> first discovered in ADS version 8.1.0.26 and continued after we updated to
> version 9.0.0.7. ADS was configured to use 8 worker threads and it newer
> came to my mind to test with one worker thread.
> I have earlier reported this behavior to the Swedish distributor of
> Advantage and to mr. Tim Croucher Sybase (UK).
>
> -Reijo
>
> Reijo Pitkanen wrote:
>> Did you notice my extra info? That is:
>> I can run the query from both clients without errors, if I reduce the
>> number of worker threads to 1.
>>
>> I doubt that this has something to do with multi threading and is not a
>> hardware issue.
>> --
>> Reijo
>>
>> Alex Wong (ADS) wrote:
>>> The lines list below correspond to a failure from calls to statvfs(), a
>>> system call. Unfortunately, we did not log the actual errno. The 65535
>>> is simply -1. So you are right that the server environment has something
>>> to do with it. However, the call to statvfs() is inside the function
>>> that we are preparing to re-index, probably in response to some index
>>> corruption. However, the indexe files in question are temporary indexes
>>> created for each statement and are exclusively used by a single
>>> connection, and thus should never be corrupted unless there are
>>> read/write error. Can you run some memory and HD checks on the server to
>>> make sure that there is no hardware problem?
>>>
>>> --
>>> Alex
>>>