[EMAIL PROTECTED] wrote: > Hi, > > please have a look at task T35 in the log. > Most of my querys seem to fail due to command timeouts. > It appears always after about 15 minutes. > Is there a setting where I can increase this timeout value? > > bye > > Daniel
setting the installation parameter SESSION_TIMEOUT to a value (in seconds) that is convenient for your needs will help. This can be done using DBM. See http://dev.mysql.com/doc/maxdb/en/30/cc213e225f9a0be10000000a114084/fram eset.htm param* - commands Elke SAP Labs Berlin > > 2005-01-14 09:59:04 28237 12929 TASKING Task T35 started > 2005-01-14 09:59:04 28237 11007 COMMUNIC wait for connection T35 > 2005-01-14 09:59:10 28200 11561 COMMUNIC Connecting T35 localhost 3756 > 2005-01-14 09:59:10 28235 11561 COMMUNIC Connected T35 localhost 3756 > 2005-01-14 10:00:00 28200 11561 COMMUNIC Connecting T36 localhost 0 > 2005-01-14 10:00:00 28235 11561 COMMUNIC Connected T36 localhost 0 > 2005-01-14 10:00:24 28234 11509 COMMUNIC Connection broken by appl > state 10 T32 > 2005-01-14 10:00:24 28234 WNG 11824 COMMUNIC Releasing T32 connection > aborted > 2005-01-14 10:00:24 28238 11509 COMMUNIC Connection broken by appl > state 10 T36 > 2005-01-14 10:00:24 28238 WNG 11824 COMMUNIC Releasing T36 connection > aborted > 2005-01-14 10:00:24 28238 12929 TASKING Task T36 started > 2005-01-14 10:00:24 28238 11007 COMMUNIC wait for connection T36 > 2005-01-14 10:00:24 28235 11509 COMMUNIC Connection broken by appl > state 10 T33 > 2005-01-14 10:00:24 28235 WNG 11824 COMMUNIC Releasing T33 connection > aborted > 2005-01-14 10:00:24 28234 12929 TASKING Task T32 started > 2005-01-14 10:00:24 28234 11007 COMMUNIC wait for connection T32 > 2005-01-14 10:00:24 28235 12929 TASKING Task T33 started > 2005-01-14 10:00:24 28235 11007 COMMUNIC wait for connection T33 > 2005-01-14 10:01:04 28200 11561 COMMUNIC Connecting T32 localhost 0 > 2005-01-14 10:01:04 28235 11561 COMMUNIC Connected T32 localhost 0 > 2005-01-14 10:01:05 28200 11561 COMMUNIC Connecting T33 localhost 0 > 2005-01-14 10:01:05 28234 11561 COMMUNIC Connected T33 localhost 0 > 2005-01-14 10:01:05 28200 11561 COMMUNIC Connecting T36 localhost 0 > 2005-01-14 10:01:05 28234 11561 COMMUNIC Connected T36 localhost 0 > 2005-01-14 10:01:05 28200 11561 COMMUNIC Connecting T37 localhost 0 > 2005-01-14 10:01:05 28234 11561 COMMUNIC Connected T37 localhost 0 > 2005-01-14 10:01:05 28200 11561 COMMUNIC Connecting T38 localhost 0 > 2005-01-14 10:01:05 28234 11561 COMMUNIC Connected T38 localhost 0 > 2005-01-14 10:03:16 28236 11509 COMMUNIC Connection broken by appl > state 10 T34 > 2005-01-14 10:03:16 28236 WNG 11824 COMMUNIC Releasing T34 connection > aborted > 2005-01-14 10:03:16 28236 12929 TASKING Task T34 started > 2005-01-14 10:03:16 28236 11007 COMMUNIC wait for connection T34 > 2005-01-14 10:04:32 28200 11561 COMMUNIC Connecting T34 10.128.130.244 > 0 > 2005-01-14 10:04:32 28234 11561 COMMUNIC Connected T34 10.128.130.244 > 0 > 2005-01-14 10:05:06 28200 11561 COMMUNIC Connecting T39 10.128.130.244 > 0 > 2005-01-14 10:05:06 28234 11561 COMMUNIC Connected T39 10.128.130.244 > 0 > 2005-01-14 10:08:25 28200 11561 COMMUNIC Connecting T40 10.128.130.244 > 0 > 2005-01-14 10:08:25 28234 11561 COMMUNIC Connected T40 10.128.130.244 > 0 > 2005-01-14 10:11:29 28200 11561 COMMUNIC Connecting T41 local 17575 > 2005-01-14 10:11:29 28234 11561 COMMUNIC Connected T41 local 17575 > 2005-01-14 10:11:31 28200 11561 COMMUNIC Connecting T42 local 17781 > 2005-01-14 10:11:31 28234 11561 COMMUNIC Connected T42 local 17781 > 2005-01-14 10:11:32 28244 11560 COMMUNIC Releasing T42 > 2005-01-14 10:11:32 28244 12929 TASKING Task T42 started > 2005-01-14 10:11:32 28244 11007 COMMUNIC wait for connection T42 > 2005-01-14 10:11:32 28200 11561 COMMUNIC Connecting T42 local 17575 > 2005-01-14 10:11:32 28234 11561 COMMUNIC Connected T42 local 17575 > 2005-01-14 10:11:32 28244 11560 COMMUNIC Releasing T42 > 2005-01-14 10:11:32 28244 12929 TASKING Task T42 started > 2005-01-14 10:11:32 28244 11007 COMMUNIC wait for connection T42 > 2005-01-14 10:11:32 28243 11560 COMMUNIC Releasing T41 > 2005-01-14 10:11:32 28243 12929 TASKING Task T41 started > 2005-01-14 10:11:32 28243 11007 COMMUNIC wait for connection T41 > 2005-01-14 10:14:18 28237 WNG 11824 COMMUNIC Releasing T35 command > timeout > 2005-01-14 10:14:18 28237 12929 TASKING Task T35 started > 2005-01-14 10:14:18 28237 11007 COMMUNIC wait for connection T35 > 2005-01-14 10:15:37 28200 11561 COMMUNIC Connecting T35 local 17575 > 2005-01-14 10:15:37 28234 11561 COMMUNIC Connected T35 local 17575 > 2005-01-14 10:15:37 28237 11560 COMMUNIC Releasing T35 > 2005-01-14 10:15:37 28237 12929 TASKING Task T35 started > 2005-01-14 10:15:37 28237 11007 COMMUNIC wait for connection T35 > 2005-01-14 10:15:37 28200 11561 COMMUNIC Connecting T35 local 17575 > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
