Hello, I've got this error while starting a backup of my database(7.4.3.32): ERR -24988,ERR_SQL: sql error -903,Host file I/O error
If I restart the database the backup will success. But after a while (a few days) the error comes back. I found the following error message in knldiag.err while backup failed: 2004-11-14 04:36:07 1131 ERR 11000 d0_aopen Error during thread creation, resource limit. 2004-11-14 04:36:07 1225 ERR 52012 SAVE error occured, basis_err 3700 Is this an os resource limit? I use SLES 8.0. I tried to modifiy the limits.conf for the user sapdb: [EMAIL PROTECTED]:~> ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited max locked memory (kbytes, -l) unlimited max memory size (kbytes, -m) unlimited open files (-n) 4096 pipe size (512 bytes, -p) 8 stack size (kbytes, -s) unlimited cpu time (seconds, -t) unlimited max user processes (-u) 7168 virtual memory (kbytes, -v) unlimited But the maximum number of threads is still 1024: 2004-11-22 05:42:04 9910 12931 INFO maximum cpu time: unlimited 2004-11-22 05:42:04 9910 12932 INFO maximum number of processes: 0 MB 2004-11-22 05:42:04 9910 12891 INFO maximum core size: 0 MB 2004-11-22 05:42:04 9910 12892 INFO maximum number of open files: 4096 2004-11-22 05:42:04 9910 12933 INFO maximum file size: unlimited 2004-11-22 05:42:04 9910 12895 INFO maximum number of threads: 1024 2004-11-22 05:42:04 9910 12934 INFO maximum stack size: unlimited 2004-11-22 05:42:04 9910 12935 INFO lockable memory size: unlimited 2004-11-22 05:42:04 9910 12893 INFO maximum virtual memory size: unlimited 2004-11-22 05:42:04 9910 12936 INFO resident set size size: unlimited 2004-11-22 05:42:04 9910 12894 INFO maximum heap size: unlimited Am I on the right way? How can I increase the maximum number of threads? Thanks for helping, regards, Kolja -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
