Forum OpenACS Q&A: Re: cronjob error: handle "0or1row" is not of type "PostgreSQL"

Collapse
7: Re: cronjob error: handle "0or1row" is not of type "PostgreSQL" (response to 4)
Posted by Gustaf Neumann on 09/30/21 02:38 PM
Although i am not completely sure, what was going on, i have removed a per-thread caching level. My suspicion is that the database handle names are not unique, and since "db_driverkey" is sometimes called with a database name and sometimes with a handle, the latter variant might lead to confusion.

Please apply this patch [1].
-gn

[1] https://cvs.openacs.org/changelog/OpenACS?cs=oacs-5-10%3Agustafn%3A20210930123412

Collapse
8: Re: cronjob error: handle "0or1row" is not of type "PostgreSQL" (response to 7)
Posted by Marty Israelsen on 10/01/21 03:05 PM
Thanks Gustaf, This appears to have fixed the issue on our system:) -Marty