Subject | Re: [firebird-support] HELP Transaction stuck in limbo |
---|---|
Author | Tanno Vorenkamp |
Post date | 2004-11-30T10:17:22Z |
I only have select transactions on two databases
I tried Gfix two_phase all
But get this error message
D:\sites\fleetselect\data\FleetSelect>D:\sites\fleetselect\data\FleetSelect\GFix
.EXE -two all -user SYSDBA -pas qlw12x!
localhost:D:\sites\fleetselect\data\Fle
etSelect\FLEETSELECT.GDB
Could not reattach to database for transaction 15474.
Original path: 192.168.0.2:D:\sites\fleetselect\data\atlx\atlx.gdb
Enter a valid path:
However
I tried Gfix two_phase all
But get this error message
D:\sites\fleetselect\data\FleetSelect>D:\sites\fleetselect\data\FleetSelect\GFix
.EXE -two all -user SYSDBA -pas qlw12x!
localhost:D:\sites\fleetselect\data\Fle
etSelect\FLEETSELECT.GDB
Could not reattach to database for transaction 15474.
Original path: 192.168.0.2:D:\sites\fleetselect\data\atlx\atlx.gdb
Enter a valid path:
However
----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, November 30, 2004 10:57 AM
Subject: Re: [firebird-support] HELP Transaction stuck in limbo
>
> Hello Tanno,
>
>> ISC ERROR CODE:335544459 ISC ERROR MESSAGE: record from transaction 22750
> is
>> stuck in limbo
>>
>> The program has a TIB_Multitransaction but the all transaction are only
>> on
> 1
>> single database
>
> Fixing "in limbo" transactions can be done via "gfix" - read the
> documentation
> on it.
>
> You need exclusive access to the database, AFAIK, to validate the database
> and fix it.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
> SQL
> Server.
> Upscene Productions
> http://www.upscene.com
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>