ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
Hi,
I'm trying to implement Oracle text for searching full text on some tables, and after some time whole web application hangs with exception.:
Message:
Devart.Data.Oracle.OracleException : ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
Stack Trace:
DbConnectionBase.Open()
OracleConnection.Open()
cv.Open()
DbConnection.OpenAsync(CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
Actual query that I think is responsible for such crash looks like that:
var customersByNameQueryable = context.Persons.FromSqlRaw("SELECT c.* FROM \"Persons\" c WHERE CONTAINS(c.\"FullName\", :p ,1)>0", p);
Before web application crashes, log file also contain such entries:
ORA-00604: error occurred at recursive SQL level 1
ORA-01013: user requested cancel of current operation
ORA-06512: at "CTXSYS.TEXTOPTSTATS", line 46
ORA-06512: at line 6 Devart.Data.Oracle.OracleException (0x80004005): ORA-00604: error occurred at recursive SQL level 1
ORA-01013: user requested cancel of current operation
ORA-06512: at "CTXSYS.TEXTOPTSTATS", line 46
ORA-06512: at line 6
at Devart.Data.Oracle.dl.a(au A_0, Int32 A_1)
at Devart.Data.Oracle.dl.a(Int32 A_0, bt A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Data.Oracle.Entity.aj.a(CommandBehavior A_0)
at Devart.Common.Entity.cu.d(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.aj.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
ORA-01013: user requested cancel of current operation Devart.Data.Oracle.OracleException (0x80004005): ORA-01013: user requested cancel of current operation
at Devart.Data.Oracle.dl.a(au A_0, Int32 A_1)
at Devart.Data.Oracle.dl.a(Int32 A_0, bt A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Data.Oracle.Entity.aj.a(CommandBehavior A_0)
at Devart.Common.Entity.cu.d(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.aj.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
I'm trying to implement Oracle text for searching full text on some tables, and after some time whole web application hangs with exception.:
Message:
Devart.Data.Oracle.OracleException : ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
Stack Trace:
DbConnectionBase.Open()
OracleConnection.Open()
cv.Open()
DbConnection.OpenAsync(CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
Actual query that I think is responsible for such crash looks like that:
var customersByNameQueryable = context.Persons.FromSqlRaw("SELECT c.* FROM \"Persons\" c WHERE CONTAINS(c.\"FullName\", :p ,1)>0", p);
Before web application crashes, log file also contain such entries:
ORA-00604: error occurred at recursive SQL level 1
ORA-01013: user requested cancel of current operation
ORA-06512: at "CTXSYS.TEXTOPTSTATS", line 46
ORA-06512: at line 6 Devart.Data.Oracle.OracleException (0x80004005): ORA-00604: error occurred at recursive SQL level 1
ORA-01013: user requested cancel of current operation
ORA-06512: at "CTXSYS.TEXTOPTSTATS", line 46
ORA-06512: at line 6
at Devart.Data.Oracle.dl.a(au A_0, Int32 A_1)
at Devart.Data.Oracle.dl.a(Int32 A_0, bt A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Data.Oracle.Entity.aj.a(CommandBehavior A_0)
at Devart.Common.Entity.cu.d(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.aj.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
ORA-01013: user requested cancel of current operation Devart.Data.Oracle.OracleException (0x80004005): ORA-01013: user requested cancel of current operation
at Devart.Data.Oracle.dl.a(au A_0, Int32 A_1)
at Devart.Data.Oracle.dl.a(Int32 A_0, bt A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Data.Oracle.Entity.aj.a(CommandBehavior A_0)
at Devart.Common.Entity.cu.d(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.aj.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
Re: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
Devart library: Devart.Data.Oracle.EFCore (9.11.1034) and Devart.Data.Oracle.EFCore (9.12.1064)
Connection string:
User ID=user;Password=pass;Host=xxxx;Service Name=xxx;Port=1521;Direct=True;Initialization Command=ALTER SESSION SET NLS_COMP = LINGUISTIC NLS_SORT = BINARY_CI;License Key=.....
Connection string:
User ID=user;Password=pass;Host=xxxx;Service Name=xxx;Port=1521;Direct=True;Initialization Command=ALTER SESSION SET NLS_COMP = LINGUISTIC NLS_SORT = BINARY_CI;License Key=.....
Re: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
Please try to localize the issue and send us a small test project with the corresponding DDL/DML script for reproducing the error in our environment.
Re: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
I have sent you a demo project, please see if that is enough.
Re: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
Thank you for the test project. We will investigate it and notify you about the result.
Re: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
Hi,
what is the status of this problem?
what is the status of this problem?
Re: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
The investigation is in progress. As soon as we have any results, we will notify you.
Re: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
Hello!
I was wondering, I a solution has been found in the meantime.
Thanks for helping!
Regards,
h. wespe
I was wondering, I a solution has been found in the meantime.
Thanks for helping!
Regards,
h. wespe
Re: ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
We cannot provide any timeframe at the moment.