Ошибка системы begin failed with sql exception

View unanswered posts | View active topics

Author	Message
maxime	Post subject: begin failed with sql exception Posted: Tue Jul 24, 2007 11:10 am
Beginner Joined: Wed Mar 14, 2007 4:29 am Posts: 33	Hello i’m using Nhibernate and i have one problem: When i do a rollback after an exception, it works but i can’t execute queries anymore. I have the exception «begin failed with sql exception» when i want to begin a new transaction ! Any idea ? [/code]
Top

marcal	Post subject: Posted: Tue Jul 24, 2007 5:02 pm
Expert Joined: Fri May 13, 2005 11:13 am Posts: 292 Location: Rochester, NY	The full exception might help. Also, are you discarding your Session and starting from scratch? This is important, because after an exception, a given Session is considered to be at least potentially corrupted. What happens if you begin a new transaction on a new Session?
Top

maxime	Post subject: Posted: Wed Jul 25, 2007 7:07 am
Beginner Joined: Wed Mar 14, 2007 4:29 am Posts: 33	rigth, it works if i do a session = factory.OpenSession(); when catching the exception…. thanks !
Top

You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum

© Copyright 2014, Red Hat Inc. All rights reserved.
JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.

We were receiving the following error, about a failed login. Recycling the application, pool by making an meaningless change to the web.config, fixed the error, and we could subsequently log in. The error may (or may not) have started after restoring the database from a backup. In any case, why would restarting the application pool fix the login failure?

2014-08-27 21:17:48,477 [10] Orchard.Tasks.BackgroundService - Error while processing background task    
NHibernate.TransactionException: Begin failed with SQL exception --->     
System.Data.SqlClient.SqlException: Cannot open database "some_database_name" requested by the login. The login failed.    
Login failed for user 'some_database_user'.    
This session has been assigned a tracing ID of 'aaa-aaa-aaa-aaa-aaa'.  Provide this tracing ID to customer support when you need assistance.    
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)       
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)       
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)       
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)       
   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)       
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)       
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)       
   at System.Data.SqlClient.SqlConnection.Open()       
   at Microsoft.Practices.EnterpriseLibrary.WindowsAzure.TransientFaultHandling.SqlAzure.ReliableSqlConnection.<Open>b__7()       
   at Microsoft.Practices.TransientFaultHandling.RetryPolicy.<>c__DisplayClass1.<ExecuteAction>b__0()       
   at Microsoft.Practices.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)       
   at Microsoft.Practices.TransientFaultHandling.RetryPolicy.ExecuteAction(Action action)       
   at Microsoft.Practices.EnterpriseLibrary.WindowsAzure.TransientFaultHandling.SqlAzure.ReliableSqlConnection.<Open>b__6()       
   at Microsoft.Practices.TransientFaultHandling.RetryPolicy.<>c__DisplayClass1.<ExecuteAction>b__0()       
   at Microsoft.Practices.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)       
   at Microsoft.Practices.TransientFaultHandling.RetryPolicy.ExecuteAction(Action action)       
   at Microsoft.Practices.EnterpriseLibrary.WindowsAzure.TransientFaultHandling.SqlAzure.ReliableSqlConnection.Open(RetryPolicy retryPolicy)       
   at NHibernate.SqlAzure.ReliableSqlDbConnection.Open()       
   at NHibernate.Connection.DriverConnectionProvider.GetConnection()       
   at NHibernate.AdoNet.ConnectionManager.GetConnection()       
   at NHibernate.Impl.SessionImpl.get_Connection()       
   at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel)       
   --- End of inner exception stack trace ---       
   at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel)       
   at NHibernate.Impl.SessionImpl.BeginTransaction(IsolationLevel isolationLevel)       
   at Orchard.Data.SessionLocator.RequireNew(IsolationLevel level)       
   at Orchard.Data.SessionLocator.RequireNew()       
   at Orchard.Tasks.BackgroundService.Sweep()

Also, we have a follow up question here: Site down: error log pattern of login failure x20, then invalid object name x20, then again login failure x20

Я только что перенесла свое приложение NHibernate с SQL Server на MySql. Кажется, все хорошо, но я получаю прерывистый TimeoutExceptions. Я могу найти много информации об этих тайм-аутах с MySql и даже одно сообщение в блоге о тайм-аутах с Hibernate + MySql + C3PO (что бы это ни было). Но ничего о том, как настроить NHib, чтобы остановить эту проблему. Знаете ли вы?

Вот трассировка стека:

NHibernate.TransactionException: Begin failed with SQL exception ---> System.TimeoutException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond ---> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   --- End of inner exception stack trace ---
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   --- End of inner exception stack trace ---
   at MyNetworkStream.HandleOrRethrowException(Exception e)
   at MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.ReadOk(Boolean read)
   at MySql.Data.MySqlClient.NativeDriver.SetDatabase(String dbName)
   at MySql.Data.MySqlClient.Driver.SetDatabase(String dbName)
   at MySql.Data.MySqlClient.MySqlConnection.ChangeDatabase(String databaseName)
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at NHibernate.Connection.DriverConnectionProvider.GetConnection()
   at NHibernate.AdoNet.ConnectionManager.GetConnection()
   at NHibernate.Impl.SessionImpl.get_Connection()
   at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel)
   --- End of inner exception stack trace ---
   at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel)
   at NHibernate.Transaction.AdoTransaction.Begin()
   at NHibernate.AdoNet.ConnectionManager.BeginTransaction()
   at NHibernate.Impl.SessionImpl.BeginTransaction()