On Tuesday 07 August 2001 09:10, Heikki Tuuri wrote:
> Hi!
>
> No idea what is wrong. Below is the code which
> prints the timestamp in InnoDB:
> .................
>
> struct tm cal_tm;
> struct tm* cal_tm_ptr;
> time_t tm;
>
> time(&tm);
>
> #ifdef HAVE_LOCALTIME_R
> localtime_r(&tm, &cal_tm);
> cal_tm_ptr = &cal_tm;
> #else
> cal_tm_ptr = localtime(&tm);
> #endif
>
> fprintf(file,"%02d%02d%02d %2d:%02d:%02d",
> cal_tm_ptr->tm_year % 100,
> cal_tm_ptr->tm_mon+1,
> cal_tm_ptr->tm_mday,
> cal_tm_ptr->tm_hour,
> cal_tm_ptr->tm_min,
> cal_tm_ptr->tm_sec);
> ...................
> I tested 3.23.40b on our Linux computer and got the following:
>
> heikki@donna:~/mysql-3.23.40/sql > mysqld
> 010807 18:01:01 Warning: setrlimit couldn't increase number of open files
> to mo
> re than 1024
> 010807 18:01:01 Warning: Changed limits: max_connections: 250 table_cache:
> 382
> 010807 18:01:02 InnoDB: Started
> 010807 18:01:02 mysqld: Table 'mysql.func' doesn't exist
> 010807 18:01:02 Can't open mysql/func table
> mysqld: ready for connections
> ........
>
> mysql> select now();
> +---------------------+
> | now() |
> +---------------------+
> | 2001-08-07 18:03:24 |
> +---------------------+
> 1 row in set (0.00 sec)
>
> mysql>
> ......................
>
> Any ideas anybody?
Peter - can you strace the bad mysqld and the good one on startup and compare?
Also compile the bad one with debugging, set a breakpoint in getenv() and
backtrace every time it stops on both binaries.
--
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
<___/
---------------------------------------------------------------------
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
