[OGo-Developer] OGo Trunk WebUI Crashing With Signal#6

[Adam Tauno Williams]

> I think this is bubbling all the way up from PostgreSQL itself;  in
> PostgreSQL's src/backend/utils/adt/timestamp.c ...
> 2832 if (VARSIZE(str) - VARHDRSZ > MAXDATELEN)
> 2833	ereport(ERROR,
> 2834			(errcode(ERRCODE_INVALID_DATETIME_FORMAT),
> 2835			 errmsg("invalid input syntax for type timestamp with time zone: \"%s\"",
> 2836					DatumGetCString(DirectFunctionCall1(textout,
> 2837												   PointerGetDatum(str))))));
> 2838 
> 2839 sp = VARDATA(str);
> 2840 dp = dstr;
> So I'll turn on SQL debugging and see what is getting sent.

Dec 11 17:00:17 ogo-webui-1.1 [6921]: PG0x0x80a61c4 SQL: BEGIN
TRANSACTION
Dec 11 17:00:17 ogo-webui-1.1 [6921]: PG0x0x80a61c4 SQL: SELECT
t1.login, t1.is_locked, t1.password FROM  person t1 WHERE (t1.login =
'awilliam') AND (t1.is_account=1)
Dec 11 17:00:17 ogo-webui-1.1 [6921]: PG0x0x80a61c4 SQL: COMMIT
TRANSACTION
PostgreSQL72 connection dropped 0x0x88fa094 (channel=0x0x80a61c4)
Dec 11 17:00:17 ogo-webui-1.1 [6921]: <0x0x88d3abc[OGoHelpManager]>
Note: no OGo documentation installed!
Dec 11 17:00:17 ogo-webui-1.1 [6921]: <0x0x88d3abc[OGoHelpManager]> SP:
Dec 11 17:00:17 ogo-webui-1.1 [6921]: |ogo-webui-1.1|
<OpenGroupware[0x0x812e2b4]: name=ogo-webui-1.1>: created session:
<OGoSession[0x0x8905504]: id=1B091B0901457D8EA1>
Dec 11 17:00:17 ogo-webui-1.1 [6921]: ccaps:
<WEClientCapabilities[0x0x88fb184]: type=Mozilla v5.0 os=Linux cpu=ix86
fast-tbl css2 xul js>
Dec 11 17:00:17 ogo-webui-1.1 [6921]: PostgreSQL72 connection
established: <0x0x893a40c[PGConnection]:  connection=0x0x893a530>
Dec 11 17:00:17 ogo-webui-1.1 [6921]: PostgreSQL72 channel 0x0x893a00c
opened (connection=<0x0x893a40c[PGConnection]:  connection=0x0x893a530>)
Dec 11 17:00:17 ogo-webui-1.1 [6921]: PG0x0x893a00c SQL: BEGIN
TRANSACTION
Dec 11 17:00:17 ogo-webui-1.1 [6921]: PG0x0x893a00c 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='awilliam' 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')
Dec 11 17:00:17 ogo-webui-1.1 [6921]: PG0x0x893a00c 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 (10120)
Dec 11 17:00:17 ogo-webui-1.1 [6921]: PG0x0x893a00c SQL: select
nextval('key_generator')
Dec 11 17:00:17 ogo-webui-1.1 [6921]: Note: PostgreSQL72 adaptor using
timezone 'GMT' as default
Dec 11 17:00:17 ogo-webui-1.1 [6921]: PG0x0x893a00c SQL: INSERT INTO
session_log (account_id, session_log_id, action, log_date) VALUES
(10120, 39870, 'login', '%Y-%m-%d %H:%M:%S%z')
Dec 11 17:00:17 ogo-webui-1.1 [6921]: PG0x0x893a00c SQL: ROLLBACK
TRANSACTION
Dec 11 17:00:17 ogo-webui-1.1 [6921]: |ogo-webui-1.1|
<OpenGroupware[0x0x812e2b4]: name=ogo-webui-1.1>: caught:
  (Exception name:PostgreSQL72FatalError class:PostgreSQL72Exception
reason:fatal pgsql error (channel=<0x0x893a00c[PostgreSQL72Channel]:
connection=<0x0x893a40c[PGConnection]:  connection=0x0x893a530>>):
ERROR:  invalid input syntax for type timestamp with time zone: "%Y-%m-%
d %H:%M:%S%z"
 info:<nil>)
in context:
  <0x0x88f4bb4[WOContext]: 002457d8ea1088f4bb4 app=ogo-webui-1.1
sn=1B091B0901457D8EA1 eid= rqeid=>.
### child 6921 (#2) was terminated by signal 6 (uptime=49s).