Re: PostgreSQL Exception: invalid input syntax for type timestamp

Sven Arnold <[email protected]> Tue, 17 Feb 2009 23:57:05 +0100
Newsgroups gmane.comp.cms.opengroupware.user
Message-ID <1234911425.7014.36.camel@schnuppe>
> Anyways, a 'bt' should work w/o the break in an libFoundation  
> environment. (lF uses nested functions to implement exceptions)

hmm,.. the application seems to catch the exception and terminates
normally. No Backtrace.

I noticed that also some of the log statements start the literal string
"%b %d %H:%M:%S"


(gdb) r -WOUseWatchDog NO
Starting program: /usr/local/sbin/ogo-webui-1.1 -WOUseWatchDog NO
[Thread debugging using libthread_db enabled]
[New Thread 0xb72a86b0 (LWP 4206)]
Feb 17 22:38:23 ogo-webui-1.1 [4206]: SNS support disabled.
%b %d %H:%M:%S ogo-webui-1.1 [4206]: Note: storing cached vCards files
in: '/var/lib/opengroupware.org/documents'

[...]

Feb 17 22:38:25 ogo-webui-1.1 [4206]: |ogo-webui-1.1| OpenGroupware.org
instance initialized.
Feb 17 22:38:25 ogo-webui-1.1 [4206]: |ogo-webui-1.1| WOHttpAdaptor
listening on address *:20000

[...]

%b %d %H:%M:%S ogo-webui-1.1 [4206]: Note: PostgreSQL72 adaptor using
timezone 'GMT' as default
Feb 17 22:38:31 ogo-webui-1.1 [4206]: |ogo-webui-1.1|
<OpenGroupware[0x0x9567a14]: name=ogo-webui-1.1>: caught:
  (Exception name:PostgreSQL72FatalError class:PostgreSQL72Exception
reason:fatal pgsql error (channel=<0x0x9e1852c[PostgreSQL72Channel]:
connection=<0x0x9e1872c[PGConnection]:  connection=0x0x9e18f90>>):
ERROR:  invalid input syntax for type timestamp with time zone: "%Y-%m-%
d %H:%M:%S%z"
 info:<nil>)
in context:
  <0x0x9c271d4[WOContext]: 001499b3c6609c271d4 app=ogo-webui-1.1
sn=106E106E01499B3C67 eid= rqeid=>.
Feb 17 22:38:31 ogo-webui-1.1 [4206]: |ogo-webui-1.1| terminating
session due to exception: 106E106E01499B3C67
Feb 17 22:38:31 ogo-webui-1.1 [4206]: |ogo-webui-1.1|
WOServerSessionStore: session 106E106E01499B3C67 terminated.
Feb 17 22:38:31 ogo-webui-1.1 [4206]: [da-handler] application
terminates because it refuses new sessions and the active session count
(0) is below the minimum (1).
192.168.122.1 - - [17/Feb/2009:22:38:31 GMT] "GET /OpenGroupware
HTTP/1.1" 200 644/0 0.883 - - 2M
Feb 17 22:38:31 ogo-webui-1.1 [4206]: <0x0x9c1633c[WOHttpAdaptor]>
adaptor stops application: <OpenGroupware[0x0x9567a14]:
name=ogo-webui-1.1 terminating> ...

Program exited normally.
(gdb) bt
No stack.
(gdb) 


-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users