Обсуждение: MS SQL 2008 crush after trunsaction commit

Поиск
Список
Период
Сортировка

MS SQL 2008 crush after trunsaction commit

От
srr
Дата:
Hello!

I have next configuration:

Win Serv 2008 r2 x64 standart
MS SQL 2008 x64
psqlodbc_09_03_0300-x64-1

when I run

set  XACT_ABORT  ON
begin tran
   insert into    OpenQuery(PG,     'SELECT * From test '    )
  values (7)
commit tran

Ms sql crush:

SQL Server is terminating because of fatal exception c0000005. This error
may be caused by an unhandled Win32 or C++ exception, or by an access
violation encountered during exception handling. Check the SQL error log for
any related stack dumps or messages. This exception forces SQL Server to
shutdown. To recover from this error, restart the server (unless SQLAgent is
configured to auto restart).

If i use rollback tran or work without transaction it`s working well.

Thank you!



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/MS-SQL-2008-crush-after-trunsaction-commit-tp5819628.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.


Re: MS SQL 2008 crush after trunsaction commit

От
"Inoue, Hiroshi"
Дата:
Hi,

(2014/09/19 18:03), srr wrote:
> Hello!
>
> I have next configuration:
>
> Win Serv 2008 r2 x64 standart
> MS SQL 2008 x64
> psqlodbc_09_03_0300-x64-1
>
> when I run
>
> set  XACT_ABORT  ON
> begin tran
>     insert into    OpenQuery(PG,     'SELECT * From test '    )
>    values (7)
> commit tran
>
> Ms sql crush:

Could take the Mylog output of psqlodbc driver and send it to me?

regards,
Hiroshi Inoue

--
I am using the free version of SPAMfighter.
SPAMfighter has removed 12610 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

Do you have a slow PC? Try a Free scan
http://www.spamfighter.com/SLOW-PCfighter?cid=sigen