Skip to Content
0
Oct 06, 2016 at 06:54 PM

Database locked due to log full, but no more user tasks

854 Views

Hi,

I'm using MaxDB 7.9.09 on SLES 11.

During the update of a fresh solution manager 7.2 installation via SUM, the update process stopped.The are 3 batch jobs running: DBCLONE1, DBCLONE2 and DBCLONE3. The update process stopped because the log is full; when I try to do a log backup, I get the error message "No session of type 'User' available-24994,ERR_RTE: Runtime environment error2,task limit". I have already increased MAXUSERTASKS, but this seems to need a DB restart.

There are 100 entries in the task list of type "user" like this:

T97 8 7885 User 24901 LOG FULL (246) 0 (s)2389500

T98 8 7885 User 24934 Command wait no 0 102819 (s)2389500

T99 8 7885 User 24942 LOG FULL (246) 0 (s)2389500

T100 8 7885 User 29003 Vwait ! 0 (s)2389500

T101 8 7885 User 5601 Vwait ! 0 (s)2389500

T102 8 7885 User 5179 LOG FULL (246) ! 0 (s)2389500

T103 8 7885 User 11269 LOG FULL (246) 0 (s)2389500

T104 8 7885 User 11270 Command wait no 0 121464 (s)2389500

T105 8 7885 User 5573 LOG FULL (246) ! 0 (s)2389500

Is there a possibility to solve this issue?

Regards,

Christian