[OGo-Users] Postgre fatal error after new install on Suse 10.2

Mon, 29 Jan 2007 10:33:26 -0500

On Mon, 2007-01-29 at 08:37 -0500, Adam Tauno Williams wrote:
> > Nope, no effect what-so-ever.
> > I've tried adding:
> > export PGDATESTYLE=ISO
> > export PGTZ=GMT
> > to both the PostgreSQL and OGo WebUI startup script;  no change at all.
> Setting:
> datestyle = ISO
> timezone = GMT 
>  in postgresql.conf (and restarting PostgreSQL) also has no effect. :(
> > Application Server caught exception:
> >   session: 781078100145BDE84C
> >   element: 
> >   context: <0x0x86f791c[WOContext]: 00145bde84c086f791c app=ogo-webui-1.1 sn=781078100145BDE84C eid= rqeid=>
> >   request: <WORequest[0x0x86f3f24]: method=GET uri=/OpenGroupware app=OpenGroupware rqKey= rqPath=>
> >   class:   PostgreSQL72Exception
> >   name:    PostgreSQL72FatalError
> >   reason:  fatal pgsql error (channel=<0x0x88e0214[PostgreSQL72Channel]: connection=<0x0x88e0414[PGConnection]:  connection=0x0x88e0c88>>): ERROR:  invalid input syntax for type timestamp with time zone: "%Y-%m-%d %H:%M:%S%z"
> >   info:

A snippet of the log with PGDebugEnabled and command profiling enabled
looks like:

Jan 29 14:29:36 ogo-webui-1.1 [31395]: PostgreSQL72 connection
established: <0x0x86e950c[PGConnection]:  connection=0x0x8700e48>
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PostgreSQL72 channel 0x0x81175ac
opened (connection=<0x0x86e950c[PGConnection]:  connection=0x0x8700e48>)
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PG0x0x81175ac SQL: BEGIN
TRANSACTION
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PG0x0x81175ac SQL: SELECT
t1.login, t1.company_id FROM  person t1 WHERE t1.company_id = 10000
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PG0x0x81175ac SQL: COMMIT
TRANSACTION
PostgreSQL72 connection dropped 0x0x86e950c (channel=0x0x81175ac)
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PostgreSQL72 connection
established: <0x0x8709cc4[PGConnection]:  connection=0x0x8700e48>
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PostgreSQL72 channel 0x0x81175ac
opened (connection=<0x0x8709cc4[PGConnection]:  connection=0x0x8700e48>)
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PG0x0x81175ac SQL: BEGIN
TRANSACTION
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PG0x0x81175ac SQL: SELECT
t1.login, t1.is_locked, t1.password FROM  person t1 WHERE (t1.login =
'root') AND (t1.is_account=1)
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PG0x0x81175ac SQL: COMMIT
TRANSACTION
PostgreSQL72 connection dropped 0x0x8709cc4 (channel=0x0x81175ac)
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PostgreSQL72 connection
established: <0x0x870bdcc[PGConnection]:  connection=0x0x870e3f8>
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PostgreSQL72 channel 0x0x81175ac
opened (connection=<0x0x870bdcc[PGConnection]:  connection=0x0x870e3f8>)
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PG0x0x81175ac SQL: BEGIN
TRANSACTION
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PG0x0x81175ac SQL: SELECT
t1.login, t1.is_locked, t1.password FROM  person t1 WHERE (t1.login =
'root') AND (t1.is_account=1)
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PG0x0x81175ac SQL: COMMIT
TRANSACTION
PostgreSQL72 connection dropped 0x0x870bdcc (channel=0x0x81175ac)
Jan 29 14:29:36 ogo-webui-1.1 [31395]: <0x0x8704e24[OGoHelpManager]>
Note: no OGo documentation installed!
Jan 29 14:29:36 ogo-webui-1.1 [31395]: <0x0x8704e24[OGoHelpManager]>
SP: 
Jan 29 14:29:36 ogo-webui-1.1 [31395]: |ogo-webui-1.1|
<OpenGroupware[0x0x8100edc]: name=ogo-webui-1.1>: created session:
<OGoSession[0x0x870e3fc]: id=7AA37AA30145BE04D0>
Jan 29 14:29:36 ogo-webui-1.1 [31395]: ccaps:
<WEClientCapabilities[0x0x8715ed4]: type=Mozilla v5.0 os=Linux cpu=ix86
fast-tbl css2 xul js>
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PostgreSQL72 connection
established: <0x0x87183d4[PGConnection]:  connection=0x0x87187a0>
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PostgreSQL72 channel 0x0x81175ac
opened (connection=<0x0x87183d4[PGConnection]:  connection=0x0x87187a0>)
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PG0x0x81175ac SQL: BEGIN
TRANSACTION
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PG0x0x81175ac SQL: SELECT
t1.login, t1.is_locked, t1.password FROM  person t1 WHERE (t1.login =
'root') AND (t1.is_account=1)
Jan 29 14:29:36 ogo-webui-1.1 [31395]: PG0x0x81175ac SQL: COMMIT
TRANSACTION
PostgreSQL72 connection dropped 0x0x87183d4 (channel=0x0x81175ac)
Jan 29 14:29:37 ogo-webui-1.1 [31395]: PostgreSQL72 connection
established: <0x0x88e6474[PGConnection]:  connection=0x0x88e6ce8>
Jan 29 14:29:37 ogo-webui-1.1 [31395]: PostgreSQL72 channel 0x0x88e6274
opened (connection=<0x0x88e6474[PGConnection]:  connection=0x0x88e6ce8>)
Jan 29 14:29:37 ogo-webui-1.1 [31395]: PG0x0x88e6274 SQL: BEGIN
TRANSACTION
Jan 29 14:29:37 ogo-webui-1.1 [31395]: PG0x0x88e6274 SQL: SELECT
t1.anniversary, t1.assistant_name, t1.associated_categories,
t1.associated_company, t1.associated_contacts, t1.birthday,
t1.boss_name, t1.company_id, t1.contact_id, t1.db_status, t1.degree,
t1.department, t1.description, t1.dir_server, t1.email_alias, t1.fileas,
t1.firstname, t1.freebusy_url, t1.im_address, t1.pop3_account,
t1.is_account, t1.is_customer, t1.is_extra_account, t1.is_intra_account,
t1.is_locked, t1.is_person, t1.is_private, t1.is_readonly,
t1.is_template_user, t1.keywords, t1.login, t1.middlename, t1.name,
t1.name_affix, t1.name_title, t1.number, t1.object_version,
t1.occupation, t1.office, t1.owner_id, t1.partner_name, t1.password,
t1.priority, t1.salutation, t1.sensitivity, t1.sex, t1.show_email2_as,
t1.show_email3_as, t1.show_email_as, t1.source_url, t1.template_user_id,
t1.url FROM  person t1 WHERE (t1.login='root' AND t1.is_account=1 AND
(NOT t1.login='template') AND (t1.is_locked=0 OR t1.is_locked is null))
AND (t1.db_status <> 'archived')
  0.000s userdefaults::register
Jan 29 14:29:37 ogo-webui-1.1 [31395]: PG0x0x88e6274 SQL: SELECT
DISTINCT t1.attribute, t1.company_id, t1.company_value_id, t1.db_status,
t1.is_enum, t1.is_label_localized, t1.label, t1.type, t1.uid,
t1.value_string FROM  company_value t1 WHERE t1.company_id IN (10000)
    0.000s userdefaults::get
    0.000s userdefaults::get
  0.008s person::get-extattrs
Jan 29 14:29:37 ogo-webui-1.1 [31395]: PG0x0x88e6274 SQL: select
nextval('key_generator')
    0.002s system::newkey
Jan 29 14:29:37 ogo-webui-1.1 [31395]: Note: PostgreSQL72 adaptor using
timezone 'GMT' as default
Jan 29 14:29:37 ogo-webui-1.1 [31395]: PG0x0x88e6274 SQL: INSERT INTO
session_log (account_id, session_log_id, action, log_date) VALUES
(10000, 10280, 'login', '%Y-%m-%d %H:%M:%S%z')
Jan 29 14:29:37 ogo-webui-1.1 [31395]: PG0x0x88e6274 SQL: ROLLBACK
TRANSACTION
Jan 29 14:29:37 ogo-webui-1.1 [31395]: |ogo-webui-1.1|
<OpenGroupware[0x0x8100edc]: name=ogo-webui-1.1>: caught:
  (Exception name:PostgreSQL72FatalError class:PostgreSQL72Exception
reason:fatal pgsql error (channel=<0x0x88e6274[PostgreSQL72Channel]:
connection=<0x0x88e6474[PGConnection]:  connection=0x0x88e6ce8>>):
ERROR:  invalid input syntax for type timestamp with time zone: "%Y-%m-%
d %H:%M:%S%z"
 info:<nil>)
in context:
  <0x0x86f8c0c[WOContext]: 00145be04d0086f8c0c app=ogo-webui-1.1
sn=7AA37AA30145BE04D0 eid= rqeid=>.
Jan 29 14:29:37 ogo-webui-1.1 [31395]: |ogo-webui-1.1| terminating
session due to exception: 7AA37AA30145BE04D0
Jan 29 14:29:37 ogo-webui-1.1 [31395]: |ogo-webui-1.1|
WOServerSessionStore: session 7AA37AA30145BE04D0 terminated.
Jan 29 14:29:37 ogo-webui-1.1 [31395]: [da-handler] application
terminates because it refuses new sessions and the active session count
(0) is below the minimum (1).
Jan 29 14:29:37 ogo-webui-1.1 [31395]: <0x0x86cafc4[WOHttpAdaptor]>
adaptor stops application: <OpenGroupware[0x0x8100edc]:
name=ogo-webui-1.1 terminating> ...
### child 31395 (#1) exited successfully (uptime=50s).