Hello Martin, All that I can add to your question is, that both messages for PIPE_IO will not cause any problems, but they aren't marked with WNG too. So maybe that is nothing new. The database kernel is only testing, how a a pipe has to be checked for available data on your system.
Best regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: Martin Cordova Sent: Mittwoch, 18. Oktober 2006 04:34 To: maxdb Subject: Meaning of some warnings while starting database instance on Linux Hello: I found these messages in knldiag. Since all my schemas on this instance lost their indexes some time ago (I am still investigating), I wonder if these warnings are important, and if they are, should I use ulimit or something like that to solve it?? My platform: OpenSuSE 10.0: Linux version 2.6.13-15.12-default ([EMAIL PROTECTED]) (gcc version 4.0.2 20050901 (prerelease) (SUSE Linux)) #1 Thu Aug 24 11:23:58 UTC 2006 Kernel 7.6.00 Build 027-121-124-939 X32/LINUX 7.6.00 Build 027-121-124-939 These are the messages: 2006-10-16 21:37:54 4261 11521 PIPE_IO Operating system does not support fstat for input check of pipes 2006-10-16 21:37:54 4261 11522 PIPE_IO Input check for pipe with poll supported 2006-10-16 21:37:54 4261 WNG 11000 INITIAL Configured 2055 files. Failed to open optional 1428 self io files. 2006-10-16 21:37:54 4261 WNG 11000 INITIAL Limit reached at file 1011! Check user and system limits... 2006-10-16 21:37:54 4261 WNG 11000 INITIAL Database tries to start now, but can run into resource problem later... My OS limits: ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited max locked memory (kbytes, -l) 32 max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 stack size (kbytes, -s) unlimited cpu time (seconds, -t) unlimited max user processes (-u) 7935 virtual memory (kbytes, -v) unlimited Any help will be very appreciated. Regards, Martin -- Dinamica - RADical J2EE framework open source, easy and powerful http://www.martincordova.com -- 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]
