Hi list,
We are using Linux SuSE 9.3 with psycopg 1.18 and postgresql 7.4.8.
Sometimes we get the following error message on varying queries:
2006-01-18 13:19:17,807 ERROR SQLDict 185 Fout in Select ERROR: user with ID
322 does not exist
SELECT "per_id", "per_naam1", "per_naam2", "per_telefoonnr_thuis",
"per_telefoonnr_mobiel", "per_faxnr", "per_mailadres_thuis",
"per_mailadres_werk", "
per_adres", "per_opmerkingen", "mutmed", "mutdat", "per_aanhef",
"per_geboortedatum", "per_sofinr", "per_geslacht", "per_aanmaakdatum",
"per_debiteur_t
ime", "per_debiteur_toegevoegd", "per_roepnaam",
"per_adressering_meisjesnaam",
"per_initialen", "per_tussenvoegsels", "per_meisjesnaam", "per_achterna
am", "cli_geboorteplaats", "cli_nationaliteit", "cli_burgerlijke_staat",
"cli_vluchteling", "cli_verblijfsvergunning", "cli_gehandicapt", "cli_autoallo
", "cli_woonsituatie", "cli_roepnaam", "cli_eigen_werknr",
"cli_soort_identificatie", "cli_identificatie", "cli_aantkinderen",
"cli_rijbewijs", "cli_uw
vcode", "cli_cwicode", "cli_opschort_vanaf", "cli_opschort_tot",
"cli_verzuimcoordinator", "cli_opschort_actief" FROM
"adeuxproductie"."clienten"
sqd1
WHERE per_id in ((select cli_id from "adeuxproductie".betrokken_opdrachten
where betrokkene = 1061 and (opd_status < 90 OR (opd_status >= 90 AND ((o
pd_real_einde is NULL or opd_real_einde > '2006-01-04') OR uit_categorie is
NULL))))
UNION (select cli_id from "adeuxproductie".planning
et1,
"adeuxproductie".activiteiten_stappen et2, "adeuxproductie".opdrachten
et3, "adeuxproductie".groepen_per_medewerker et4
where et1.opd_id = et3.opd_id and et1.stp_id =
et2.tab_id and et4.mwg_id = et2.act_med_groep and med_id = 1061 and
(opd_status
< 90 OR (opd_status >= 90 AND ((opd_real_einde is NULL or opd_real_einde >
'2006-01-04') OR uit_categorie is NULL)))))
It looks as if the user that is connected to the database suddenly doesn't
exist anymore. The user has been able to connect, to work for a while, and
after a while this error occurs.
Anyone any ideas? Could this be a problem in libpq, or
postgresql?
Thanks in advance
Dick Kniep