Enno Ahrens wrote: > Hi, > > we are using a MaxDB 7.6.00.16 on a dedicated DB-Server (Win > 2003 Server, 2 > Intel XEON, 4GB RAM, 500 GB Diskspace). > > From time to time the kernel crashes. We believe that the crach is > influenced by the values of the following parameters: > > MAXUSERTASKS = 500 > CACHE_SIZE = 100.000 > _CAT_CACHE_MINSIZE = 262.144 > In former times we've computed CAT_CACHE_SUPPLY in the following way: > (MAXUSERTASKS + 1) * _CAT_CACHE_MINSIZE = 131334144. In the > hope to solf our > problems we increased this parameter to 190000000 > > Below is a snippet from knldiagerr: > > -------------------------------------------------------------- > -------------- > ---- > Date Time TID(hex) Typ MsgID Label Message-Text > -------------------------------------------------------------- > -------------- > ---- > 2006-07-17 11:36:33 0x1410 ERR 54008 MEMORY > TransContext T429 : could > not allocate > 2006-07-17 11:36:33 0x1410 ERR 54008 MEMORY memory > 2006-07-17 11:36:33 0x1410 ERR 54008 MEMORY required > : 13765936 > 2006-07-17 11:36:33 0x1410 ERR 54008 MEMORY allocated > : 134594560 > 2006-07-17 11:36:33 0x1410 ERR 54008 MEMORY supplement > : 13766656 > 2006-07-17 11:36:33 0x1410 ERR 54008 MEMORY limit : -1 > 2006-07-17 11:36:33 0x1410 ERR 54008 MEMORY free blocks > size 24 : 1 > 2006-07-17 11:36:33 0x1410 ERR 54008 MEMORY free blocks > size 32 : 3 > 2006-07-17 11:36:33 0x1410 ERR 54008 MEMORY free blocks > size 56 : 1 > 2006-07-17 11:36:33 0x1410 ERR 54008 MEMORY free blocks > size 80 : 1 > 2006-07-17 11:36:33 0x1410 ERR 54008 MEMORY free blocks > size 304 : 1 > 2006-07-17 11:36:33 0x1410 ERR 51080 SYSERROR -9407 > unexpected error > 2006-07-17 11:36:33 0x1410 ERR 1 Table > Table_TempHashTable.hpp:759 > 2006-07-17 11:36:33 0x1410 ERR 1 Table 2006-07-17 > 11:36:33 Table > Error 1 > 2006-07-17 11:36:33 0x1410 ERR 1 Table No sort array > 2006-07-17 11:36:33 0x1410 ERR 1 Table + > Table_TempHashTable.hpp:760 > 2006-07-17 11:36:33 0x1410 ERR 1 Table + > 2006-07-17 11:36:33 > Table Info 2 > 2006-07-17 11:36:33 0x1410 ERR 1 Table - Sort > entries failed > 2006-07-17 11:36:33 0x1410 ERR 1 Table + > Table_TempHashTable.hpp:404 > 2006-07-17 11:36:33 0x1410 ERR 1 Table + > 2006-07-17 11:36:33 > Table Error 6 > 2006-07-17 11:36:33 0x1410 ERR 1 Table - Cannot > determine > first entry > > > Thanks in advance for any help. > > Best regards > > Enno Ahrens > > >
Hi, the knldiag shows some problems with internal files used for join selects with set functions. There were some bug fixes in this context so you should upgarde your database to a newer version. As a workaround you could set database parameter HASHED_RESULTSET to NO. Kind regards Holger -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
