Hi Martin, thanks for the explanation! Unfortunately we see the error "[-708] Data receive failed." not only when doing UPDATE STATISTICS. Also, we normally do not execute DDL and UPDATE STATISTICS in parallel - the only circumstances where I guess it could happen is during startup if the schema has to be changed - which is rarely the case. Are there other circumstances you can think of that this error can happen?
Kind regards robert 2006/5/24, Kittel, Martin <[EMAIL PROTECTED]>:
Hi Robert, > >I though I'll ask again just in case someone has an idea what's going >on here. I'd really appreciate any feedback. Thanks! > from your knldiag: .... 2005-11-25 09:55:18 0xC14 ERR 19999 BTRACE kernel!a11put_date_time + 25 bytes 2005-11-25 09:55:18 0xC14 ERR 19999 BTRACE SFrame: IP:004711e9 RA:004ce1cb FP:0710636c SP:07106374 2005-11-25 09:55:18 0xC14 ERR 19999 BTRACE Params: 01:00000020 02:00000024 03:0710a534 04:0710e9ec 2005-11-25 09:55:18 0xC14 ERR 19999 BTRACE Source: vak11.c ( Line: 8488 ) 2005-11-25 09:55:18 0xC14 ERR 19999 BTRACE kernel!a28table_upd_statistics + 603 bytes 2005-11-25 09:55:18 0xC14 ERR 19999 BTRACE SFrame: IP:004ce1cb RA:004fa7d9 FP:0710a164 SP:0710a16c 2005-11-25 09:55:18 0xC14 ERR 19999 BTRACE Params: 01:00000004 02:00000000 03:0000000a 04:00000000 2005-11-25 09:55:18 0xC14 ERR 19999 BTRACE Source: vak28.c ( Line: 7371 ) 2005-11-25 09:55:18 0xC14 ERR 19999 BTRACE kernel!ak45check_one_table + 329 bytes 2005-11-25 09:55:18 0xC14 ERR 19999 BTRACE SFrame: IP:004fa7d9 RA:004fa8e3 FP:0710a4ac SP:0710a4b4 2005-11-25 09:55:18 0xC14 ERR 19999 BTRACE Params: 01:0710e9ec 02:0110a534 03:00000000 04:00000000 2005-11-25 09:55:18 0xC14 ERR 19999 BTRACE Source: vak45.c ( Line: 5873 ) ... This is the stackbacktrace for a known problem that has been fixed with 7.5.00.34. The error usually occurs if an update statistics command is running while DDL is being performed in another session. The best workaround is to run 'Update Statistics *' only from a new session and while you are fairly by yourself on the system. Best wishes, Martin.
-- Have a look: http://www.flickr.com/photos/fussel-foto/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
