[V4RB] Crash with many insert/update statements

[Ruslan Zasukhin]

on 11/21/03 3:31 PM, Frank Bitterlich at bitterlich at gsco.de wrote:

> Hi,
> 
> one of my apps issues many (thousands) of mixed insert and update statements
> (SQLExecute()) on a single table. Every thousand statements, I issue a
> Flush(), just for good measure.
> 
> But after a few (2000-3000) of these statements, I get a crash like this:
> Thread 0 Crashed:
> #0   0x005b111c in FBL_Cache::FlushAll(void)
> #1   0x006084ec in FBL_DataBase::FlushAll(void)
> #2   0x00639db8 in OBL_Cursor::UpdateAll(void)
> #3   0x0063b300 in VDK_Cursor::UpdateAll(void)
> #4   0x0062db54 in
> Parse_UpdateStatement__12VDK_DataBaseFPCcPUlP28FBL_Array<P14VD
> #5   0x0062a6ac in
> SqlExecute__12VDK_DataBaseFPCcPUlP28FBL_Array<P14VDK_IParamete
> #6   0x00592958 in DataBase_SqlExecute(REALobjectStruct *, REALstringStruct
> *)
> #7   0x001acc34 in 0x1acc34
> #8   0x001b2184 in 0x1b2184
> 
> Any clue what could be wrong? I've removed the index flags of the table now,
> and I get better success (tested it only up to 10000 now, no crash so far).
> 
> Corrupted DB? Any tips? V4RB 1.9.8 with RB 5.2.2 on OS X 10.2.8.

Hi Frank,

1) may be you have small cache for you db.
    try set it bigger.

2) may be you can make flush more often

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------