John Glenn - 2004-01-17

From time to time (quite often I have to say) I happen that some method from auth class writes to the active_session table the data with the same unique ID which are already pressent. We dit foud it when we played with demo pages. Here is the error output:

Warning: pg_exec() query failed: ERROR: duplicate key violates unique constraint "active_sessions_pkey" in /srv/www/php/db_pgsql.inc on line 75
Database error: Invalid SQL: INSERT INTO active_sessions (ct_sid, ct_name, ct_pos, ct_val, ct_changed) VALUES ('62b65035097bf49bde88964339efafe3','ISD_Session','000000','JHRoaXMtPmluID0gJzAnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyAkdGhpcy0+cHRbJ3MnXSA9ICcxJzsgJHRoaXMtPnB0WydjaGFsbGVuZ2UnXSA9ICcxJzsgJEdMT0JBTFNbJ3MnXSA9ICc4JzsgJEdMT0JBTFNbJ2NoYWxsZW5nZSddID0gJzNmZTk3Zjk3Zjc5OTE0YWQxYmEwMmZlNDBlMjg3YmNhJzsg','20040117212218')
PostgreSQL Error: 1 (ERROR: duplicate key violates unique constraint "active_sessions_pkey" )
Session halted.

This error ocures randomly.

We are using   phplib 7.4, mode_php4 with apache.

ct_split_sql.inc as container

Does anybody  have any idea what can be a problem?