Forum OpenACS Development: Response to Using Oracle *and* Postgres

Collapse
Posted by Andrei Popov on
I must be going insane... One day it was all working, now it does not -- It just gets stuck and based on a few ``ammendments'' made to oracle driver, it gets stuck here:
[09/Jan/2002:14:03:24][7657.9223][-conn2-] Notice: dbdrv: opening database 'ora8:boflex.world'
[09/Jan/2002:14:03:24][7657.9223][-conn2-] Notice: ora8.c:1014:ora_open_db: entry (dbh 0x8169180)
[09/Jan/2002:14:03:25][7657.9223][-conn2-] Notice: ora8.c:1141:ora_open_db: (dbh 0x8169180); return NS_OK;
[09/Jan/2002:14:03:25][7657.9223][-conn2-] Notice: >>> database handle is nsdb1 for boflex
[09/Jan/2002:14:03:25][7657.9223][-conn2-] Notice: ora8.c:1387:ora_exec: generate simple message
[09/Jan/2002:14:03:25][7657.9223][-conn2-] Notice: ora8.c:1388:ora_exec: entry (dbh 0x8169180, sql select count(*) c from dual)
[09/Jan/2002:14:03:25][7657.9223][-conn2-] Notice: ora8.c:2334:flush_handle: entry (dbh 0x8169180, row (nil))
[09/Jan/2002:14:03:25][7657.9223][-conn2-] Notice: ora8.c:1296:handle_builtins: entry (dbh 0x8169180, sql select count(*) c from dual)
[09/Jan/2002:14:03:25][7657.9223][-conn2-] Notice: ora8.c:1515:ora_exec: query type `1'
[09/Jan/2002:14:03:25][7657.9223][-conn2-] Notice: dbinit: sql(boflex.world): 'select count(*) c from dual'
[09/Jan/2002:14:03:25][7657.9223][-conn2-] Notice: ora8.c:1734:ora_bindrow: entry (dbh 0x8169180)
[09/Jan/2002:14:03:25][7657.9223][-conn2-] Notice: ora8.c:1777:ora_bindrow: n_columns: 1
[09/Jan/2002:14:03:25][7657.9223][-conn2-] Notice: ora8.c:1829:ora_bindrow: name 1 `c'
[09/Jan/2002:14:03:25][7657.9223][-conn2-] Notice: ora8.c:1845:ora_bindrow: column `c' type `2'
[09/Jan/2002:14:03:25][7657.9223][-conn2-] Notice: >>> the set is t4
[09/Jan/2002:14:03:25][7657.9223][-conn2-] Notice: ora8.c:2047:ora_get_row: entry (dbh 0x8169180, row 0x81693e8)
[09/Jan/2002:14:03:25][7657.9223][-conn2-] Notice: ora8.c:2106:ora_get_row: >> fetch succeeded, copying to ns_set
[09/Jan/2002:14:03:25][7657.9223][-conn2-] Notice: ora8.c:2112:ora_get_row: >> we are at 0
[09/Jan/2002:14:03:25][7657.9223][-conn2-] Notice: ora8.c:2291:ora_get_row: >> Ns_SetPutValue was called as 135697384, 0, 1
This happens in both -- remote an local Oracle server configuration. Any idea what is going wrong?