Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Interbase 7.1

108 views
Skip to first unread message

Donny Philip

unread,
Dec 16, 2003, 6:07:58 AM12/16/03
to

Hi Everyone,
My client migrated from IB7.0 to IB7.1 yesterday evening.
Application is in Delphi 5.0. Its being used 24*7.

Today morning they are getting the foloowing error
Quote
I/O error for file "Unopened sort or merge file"
I/O error for file "A"
sort error
UnQuote

Help pls...

Many Thanks

Cheers
Donny.


Martijn Tonies

unread,
Dec 16, 2003, 7:29:03 AM12/16/03
to
Hi Donny,

Did you apply the latest 7.1 patch? You can download
it from the registered users are at Borland.


--
With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com


Donny Philip

unread,
Dec 16, 2003, 7:26:45 AM12/16/03
to
Hello Martijn

Thank you for the quick response

"Martijn Tonies" <m.tonies@upscene!nospam!.com> wrote:
>> I/O error for file "Unopened sort or merge file"
>> I/O error for file "A"
>> sort error
>

>Did you apply the latest 7.1 patch? You can download
>it from the registered users are at Borland.

Is this the one??
http://info.borland.com/devsupport/interbase/ib70_patch.html

InterBase 7.0 Server Edition patch
InterBase 7.0 Server Edition patch (Windows):
This patch fixes problems with sort/merge joins. If the join returned equivalence merge sets with common values that totalled more than 64KB, the result was spooled to a temporary file that had a prefix of "ib_merge". When the query finished, this file was not being properly closed and could cause a server crash if a query of this type was run over 26 times.

If no could you please send me a link to 7.1 patch?

Sorry if I got it wrong

Thanks again


With BRegards
Donny.

Bill Todd (TeamB)

unread,
Dec 16, 2003, 9:27:39 AM12/16/03
to
No. Martijn is referring to the service pack for IB 7.1 which is in
the registered users area at
http://info.borland.com/cgi-bin/registered_users/ds_check_in2.cgi?productid=7071

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Donny Cherian Philip

unread,
Dec 16, 2003, 8:55:45 AM12/16/03
to

Thanks Bill, my apologies and thanks Martijn.

Thanks again

Cheers
Donny.

Donny Cherian Philip

unread,
Dec 16, 2003, 8:55:33 AM12/16/03
to

Thomas Steinmaurer

unread,
Dec 16, 2003, 10:40:10 AM12/16/03
to
Hi Bill,

> No. Martijn is referring to the service pack for IB 7.1 which is in
> the registered users area at
>
http://info.borland.com/cgi-bin/registered_users/ds_check_in2.cgi?productid=
7071

Do you know if the currently available 7.1 trial version has that
service pack already applied?


Thank you,
Thomas Steinmaurer

Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com
Logging/Auditing Suite for Advantage Database Server
http://www.adslogmanager.com

Jeff Overcash (TeamB)

unread,
Dec 16, 2003, 1:43:07 PM12/16/03
to

"Thomas Steinmaurer" <t...@iblogmanager.com> wrote:
>Hi Bill,
>
>> No. Martijn is referring to the service pack for IB 7.1 which is in
>> the registered users area at
>>
>http://info.borland.com/cgi-bin/registered_users/ds_check_in2.cgi?productid=
>7071
>
>Do you know if the currently available 7.1 trial version has that
>service pack already applied?
>

No, but the last I heard it was planned to release a new trial
with it applied. I have no idea what stage that plan is in or
if it is still the plan.

Bill Todd (TeamB)

unread,
Dec 16, 2003, 6:13:17 PM12/16/03
to
On Tue, 16 Dec 2003 16:40:10 +0100, "Thomas Steinmaurer"
<t...@iblogmanager.com> wrote:

>Do you know if the currently available 7.1 trial version has that
>service pack already applied?

Yes, it does have the SP applied.

Bill Todd (TeamB)

unread,
Dec 16, 2003, 6:14:14 PM12/16/03
to
I am quite sure I saw an announcement that the new trial with the SP
is now on line.

quinn wildman

unread,
Dec 16, 2003, 7:22:37 PM12/16/03
to
NO, The trial does not have the service pack in it at this time.

Bill Todd (TeamB)

unread,
Dec 16, 2003, 9:41:27 PM12/16/03
to
Thanks.

Thomas Steinmaurer

unread,
Dec 17, 2003, 3:07:37 AM12/17/03
to
Hi Quinn,

> NO, The trial does not have the service pack in it at this time.

I guess Bill was referring to the InterBase newsletter that I got on
December 4, 2003 too, and there it says the following:

InterBase 7.1 Trial
If you haven't tried InterBase 7.1 yet, you should. The currently posted
trial has all of the latest service pack updates. And those updates could
have easily rated another "point" on the release number. The latest service
pack alone adds all this:
-Improves stability when updating more than 10,000 records at a time
-Resolves index creation issues for large indexes
-Fixes server crash issues caused by memory leaks in the Windows system
driver
-Provides better error reporting and logging of SQL statement that caused
exceptions
-Avoids duplicate logging of network errors
-Faster and better query optimization for indexes that have multiple
segments
-Solves issues related to a large number of transactions, enabling prolonged
use of databases on read-only media
-Enhances performance for sort operations


So, now what? What does "latest service pack updates" mean?


Best Regards,

Bill Todd (TeamB)

unread,
Dec 17, 2003, 8:12:15 AM12/17/03
to
Thanks Thomas. That was were I got the information.

quinn wildman

unread,
Dec 17, 2003, 12:20:52 PM12/17/03
to
I talked to the person the wrote this. You might say he wrote this based
on how he expected the world to be. As it works out, the world turned
out different and his information was incorrect. I apologize for this
incorrect information.

Thomas Steinmaurer

unread,
Dec 18, 2003, 3:02:19 AM12/18/03
to
Hi Quinn,

"quinn wildman" <qwil...@borland.com> schrieb im Newsbeitrag
news:3fe09074$1...@newsgroups.borland.com...


> I talked to the person the wrote this. You might say he wrote this based
> on how he expected the world to be. As it works out, the world turned
> out different and his information was incorrect. I apologize for this
> incorrect information.

Thanks for the clarification!

Donny Philip

unread,
Dec 18, 2003, 8:15:33 AM12/18/03
to

Hello

Its regarding the same error


Today morning they are getting the foloowing error
Quote

I/O error for file "Unopened sort or merge file"
I/O error for file "A"
sort error

UnQuote

Even after applying the patch the customer seems to be getting
the same error message.

Any help pls..

Thanks


With Regards
Donny

Jeff Overcash (TeamB)

unread,
Dec 18, 2003, 9:35:23 AM12/18/03
to

Check the drive that the temp files are written to that a) the temp directory
exists and b) there is enough room on that drive for the temp files.

> Thanks
>
> With Regards
> Donny

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
If there is somebody up there could they throw me down a line. Just a
little helping hand just a little understanding. Just some answers to the
questions that surround me now. If there's somebody up there could
they throw me down a line. (Fish)

Donny Philip

unread,
Dec 19, 2003, 10:04:20 AM12/19/03
to

Hello

"Bill Todd (TeamB)" <n...@no.com> wrote:
>http://info.borland.com/cgi-bin/registered_users/ds_check_in2.cgi?productid=7071
>

Is this link referring to service pack 2? Pls confirm.

Thanks...

With BRegards
Donny.

Jeff Overcash (TeamB)

unread,
Dec 19, 2003, 12:51:20 PM12/19/03
to

"Donny Philip" <don...@ibsplc.com> wrote:
>
>Hello
>
>"Bill Todd (TeamB)" <n...@no.com> wrote:
>>http://info.borland.com/cgi-bin/registered_users/ds_check_in2.cgi?productid=7071
>>
>
>Is this link referring to service pack 2? Pls confirm.
>

SP 2 is not available. Quinn only gave early announcment that
they were working on it. Expect it early next year in Q1 I
expect.


0 new messages