Subject Re: [firebird-support] Global Temp Table Question - pointer page vanished error
Author Vlad Khorsun
>> >I have an FB2.1.3
>> >
>> > CREATE GLOBAL TEMPORARY TABLE CCIMPORTRAW (
>> > ID PKID NOT NULL /* PKID =3D INTEGER DEFAULT 0 NOT NULL
>> */,
>> > ... other fields
>> > ) ON COMMIT DELETE ROWS;
>> >
>> > The DB is on a web which has it's own authentication method (a user
>> table in
>> > the DB) so it uses a single user in FB to make connections.
>> >
>> > When 2 people (the same user as far as FB is concerned) make a
>> submission to
>> > this table at exactly the same moment, the server crashes with this
>> error.
>> >
>> > internal gds software consistency check (pointer page vanished from
>> > relation list in locate_space (254), file: dpm.cpp line: 3060)
>>
>> Are they shared the same Firebird attachment ?
> Vlad,
> Using
> SELECT CURRENT_CONECTION FROM RBD$DATABASE
> I can say that it is not reliably using the same OR differnet connections.
> Sometimes the 2 pages are connecting using different and somtimes the same
> connection number, but the error occurs in either case.

All i can say with this info : make sure it never used same connection in different
threads simultaneously. To be more helpful i need reproducible test case...

Regards,
Vlad