when browsing november 2008 mail archive, i found that my problem might be related to postgresql like Julian had but the error message
function create_tmp_table(unknown) does not exist at character 8
aside from that it only happens only 5 times around 11 AM
when i try again at 12 PM
REG-UMAR@192.168.56.6> create_contact CID:CA000001 'Umarzuki' umarzuki@gmail 123 Beranang 43700 MY
Do you really want to send this command to the server? (y/N): y
Return code: 2400
Reason: Command failed
Still same messages
grep exist /var/log/postgresql/postgresql-8.3-main.log
2009-06-09 11:40:28 MYT ERROR: function create_tmp_table(unknown) does not exist at character 8
2009-06-09 11:40:36 MYT ERROR: function create_tmp_table(unknown) does not exist at character 8
2009-06-09 11:40:40 MYT ERROR: function create_tmp_table(unknown) does not exist at character 8
2009-06-09 11:40:43 MYT ERROR: function create_tmp_table(unknown) does not exist at character 8
2009-06-09 11:40:49 MYT ERROR: function create_tmp_table(unknown) does not exist at character 8
but that was yesterday
even the few log messages
tail -25 /var/log/postgresql/postgresql-8.3-main.log
2009-06-10 11:02:25 MYT FATAL: terminating connection due to administrator command
2009-06-10 11:02:25 MYT LOG: autovacuum launcher shutting down
2009-06-10 11:02:25 MYT LOG: shutting down
2009-06-10 11:02:25 MYT LOG: database system is shut down
2009-06-10 11:02:35 MYT LOG: could not load root certificate file "root.crt": no SSL error reported
2009-06-10 11:02:35 MYT DETAIL: Will not verify client certificates.
2009-06-10 11:02:35 MYT LOG: database system was shut down at 2009-06-10 11:02:25 MYT
2009-06-10 11:02:35 MYT LOG: autovacuum launcher started
2009-06-10 11:02:35 MYT LOG: database system is ready to accept connections
2009-06-10 11:02:35 MYT LOG: incomplete startup packet
2009-06-10 11:09:25 MYT LOG: incomplete startup packet
2009-06-10 11:09:25 MYT LOG: received fast shutdown request
2009-06-10 11:09:25 MYT LOG: aborting any active transactions
2009-06-10 11:09:25 MYT FATAL: terminating connection due to administrator command
2009-06-10 11:09:25 MYT FATAL: terminating connection due to administrator command
2009-06-10 11:09:25 MYT LOG: autovacuum launcher shutting down
2009-06-10 11:09:25 MYT FATAL: terminating connection due to administrator command
2009-06-10 11:09:25 MYT LOG: shutting down
2009-06-10 11:09:25 MYT LOG: database system is shut down
2009-06-10 11:10:06 MYT LOG: could not load root certificate file "root.crt": no SSL error reported
2009-06-10 11:10:06 MYT DETAIL: Will not verify client certificates.
2009-06-10 11:10:06 MYT LOG: database system was shut down at 2009-06-10 11:09:25 MYT
2009-06-10 11:10:06 MYT LOG: autovacuum launcher started
2009-06-10 11:10:06 MYT LOG: database system is ready to accept connections
2009-06-10 11:10:06 MYT LOG: incomplete startup packet
--
Regards,
Umarzuki Mochlis
http://gameornot.net