1969-12-31 Event Timestamps

[MILxDOT]

I am seeing some events with a timestamp of 1969-12-31.

This seems to only happen on my newer builds using Ubuntu. I used to standardize on CentOS but have since made the switch to Ubuntu.

Running Ubuntu Server 9.04 amd64 (seeing this on 32bit boxes also)
Zoneminder built according to this guide:
http://www.zoneminder.com/forums/viewtopic.php?t=14281

I noticed that normando and cordel were troubleshooting this at the beginning of the year in 1.23.x:
http://www.zoneminder.com/forums/viewto ... light=1969

zmf is disabled and this is still happening.

Like normando, I verified that these timestamps are being written to the database with the 1969 timestamp.

I have not configured any php TZ yet.

Can anybody point me in the right direction?

[cordel]

Check the bug list for MySQL as well as make sure your machine is not overloaded and you have MySQL properly tuned. MySQL Provides all the time stamps n the database.

[kwire]

I may be way off base here, but I seem to remember seeing that on my system too...

I was using Modect and I think it occured when I looked at an event before it was finished recording.

Keith

[MILxDOT]

I think that I resolved the timestamp issues by doing the following:

FIRST INSTALL mysqltuner:
sudo -i
apt-get install mysqltuner

STOP ZONEMINDER
/etc/init.d/zm stop

STOP MYSQL
/etc/init.d/mysql stop

EDIT YOUR my.cnf FILE
vi /etc/mysql/my.cnf

UNCOMMENT skip-innodb OR ADD IT IF IT IS NOT IN THERE

MAKE SURE THE THE FOLLOWING PARAMETERS ARE SET:
key_buffer = 16M
max_allowed_packet = 32M
thread_stack = 128K
thread_cache_size = 8
query_cache_limit = 1M
query_cache_size = 24M

ADD THESE PARAMETERS:
tmp_table_size = 32M
max_heap_table_size = 16M

SAVE AND EXIT

START MYSQL
/etc/init.d/mysql start

START ZONEMINDER
/etc/init.d/zm start

IF YOU WANT TO TUNE YOUR OWN SYSTEM, LET YOUR SYSTEM RUN NORMALLY FOR ABOUT 15 MINUTES AND THEN RUN:
mysqltuner

IT WILL ASK YOU FOR YOUR MYSQL ROOT USERNAME AND PASSWORD SO ENTER IT

ONCE YOU ENTER YOUR USERNAME AND PASSWORD IT WILL GIVE YOU SOME RECOMMENDATIONS. I WOULD GUESS THAT IF YOU APPLY THE ABOVE SETTINGS IT WILL NOT RECOMMEND ANY CHANGES.

You can disregard this:
General recommendations:
Enable the slow query log to troubleshoot bad queries

You will probably find that your system will run with greater efficiency

[gola10]

I have Zm 1.22.3 under mandriva 2007 from livecd. I use to consider the performance to be excellent but tried mysqltuner just to see what happends and now i and getting even better performance.

This might be something every one should try. Just make a copy of your my.cnf in case you want to return to original settings.

I was worried about installation of mysqltunner but finally discovered that is a script that you download (no need to install) .
All i had to do was.

wget -O mysqltuner.pl http://tools.assembla.com/mysqltuner/br ... format=txt
chmod 775 mysqltuner.pl

To run it just go to the palce you have it and type
perl mysqltuner.pl

This is someting i has never done before and there are some recommendations that i have to read more about. I have just applied the ones you mentioned and i can see a increase in performance,