Re: Another Informix Bug? Online

>>>>> On Tue, 26 Apr 1994 14:31:07 GMT, doc@balr.com (David R. Gilbert) said: > dtroutt@netcom.com (David Troutt) writes: > : > : Has anybody else seen this one? We are running Informix-OnLine V5.01 under > : Solaris 2.2. > : > : A user creates a temp table and inserts into it. Later, the user drops the > : temp table, but remains in his process (either ISQL or a 4gl program). > : Another user now logs into the same database and tries to create a temp > : table. This user either hangs (if he has SET LOCK MODE TO WAIT), or > : generates the following error: > : > : SQL statement error number -261. > : Cannot create file for table <tablename>. > : SYSTEM error number -113. > : ISAM error: the file is locked. > : [...] > Ahh, yes. We hit this one too. It is a known bug with 5.01. > You need to upgrade to 5.02 and your problem will be fixed. > It applies to all ports of OnLine 5.01 (SunOS 4.1.x, too.) Tried to reproduce this bug using OnLine 5.01.UD1 on UnixWare. Database is MODE ANSI. The problem did not occur. Can anyone clarify this? -- Oliver Okrongli infix Software-Systeme GmbH Phone +49 531 238090 Rebenring 33 Fax +49 531 2380935 oliver@infix.de 38106 Braunschweig F.R. Germany