Hi!
>>>>> "Michael" == Michael Stassen <[EMAIL PROTECTED]> writes: <cut> Michael> Of course, you are right. As I said, I took this code from Michael> set_maximum_open_files in mysqld.cc: simply turning the 1st Michael> sql_print_error line into the printf lines. I should have looked more Michael> carefully, but I thought I had something here, as I'll explain below. Michael> (Strange, though, that rl.rlimit_max printed fine without the cast to Michael> long.) This is becasue if you send a 64 bit integer to a routine that expect several 32 bit integers, one of the result integers are probably going to be ok. Michael> Strictly speaking, then, this is a bug in either HPUX or gcc (probably Michael> HPUX), not in mysql. On the other hand, those of us who have this problem Michael> cannot use the precompiled binary. >> >> The precompiled binary should work ok. Michael> I tried the precompiled binary (3.23.43) and got the same error. Sorry, but which error ? That 'mysql_install_db' dies with a core. or that mysql-test-run fails ? As this works on our HP-UX machine, it means that some library that we are using is not compatible with yours :( Michael> My workaround is to compile mysql from source, adding --disable-largefile Michael> to the options recommended in the manual. Perhaps there is a better way Michael> -- maybe a fix for HPUX? >> >> What kind of errors do you get if you don't use --disable-largefile ? Michael> As I reported in my earlier email on Oct. 29, I get essentially the same Michael> error as was reported here, namely, setrlimit fails. I configured as you Michael> recommend, run make, then make test. I get: Michael> ======================= Michael> $make test Michael> cd mysql-test ; ./mysql-test-run Michael> Installing Test Databases Michael> Removing Stale Files Michael> Installing Master Databases Michael> 011214 21:50:26 Warning: setrlimit couldn't increase number of open files Michael> to more than 60 Michael> 011214 21:50:26 Warning: Changed limits: max_connections: 50 Michael> table_cache: 64 Michael> 011214 21:50:26 ../sql/mysqld: Shutdown Complete <cut> Michael> [snip] Michael> isam 0.0 0.0 4.6 [ pass ] Michael> isolation .... .... .... [ skipped ] Michael> join .... .... .... [ fail ] Michael> Aborting. To continue, re-run with '--force'. Michael> ============================ Michael> As you can see, setrlimit fails to increase the allowed number of open Michael> files, then the join test fails because it wants to open more than 60, the Michael> default on my system. The ouput quoted here is from 3.23.46 built today, Michael> but it's the same as I got in October with 3.23.43. Thanks; Now I have a much better understanding of this problem. On our system I can increase the number of open files to 500, without any problems. Michael> I also note that every post I could find on Google on the subject of Michael> building mysql from source on HPUX 10.20 recommended --disable-largefile Michael> (though none I saw actually said why). >> I haven't seen this before. Michael> I should clarify: None of these said you need --disable-largefile. When I Michael> ran into the problem above, I went looking for solutions. I found several Michael> threads in which someone said it didn't work on HPUX 10.20, then someone Michael> else replied with "I built it this way and it worked." I noticed that Michael> each of these replies differed from the recommended build mainly by adding Michael> --disable-largefile to configure. None of them pointed to that Michael> explicitly, but I added --disable-largefile and rebuilt and it worked. Michael> No more rlimit warning and join test passed. Very strange! Could you try to modify your test to do the proper casts and see if you can find what is going wrong on your system ? If we can find a tests that fails on your system but works on ours, we would know a lot more about of how to fix this problem. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
