Search Postgresql Archives

Userid error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux