Forum OpenACS Development: Re: Sequence overrun on

Posted by Gustaf Neumann on
One consequence of the overrun of the sequence is that the session_id does not fit into an SQL integer type anymore. This can result in cascading changes, when the session_id is used for attributed values stored with type integer in the DB.

One example is the bookmark packages (still at use at, which uses (negative) session_ids to identify non-registered users. See [1] for a fix of this, which changes the type from integer to bigint.