Oracle Error (ORA-08103) happens intermittently

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
slaxman
Posts: 51
Joined: Wed 16 Sep 2009 20:09
Location: United States

Oracle Error (ORA-08103) happens intermittently

Post by slaxman » Mon 14 Jan 2019 17:19

Exception is thrown intermittently during some read operations on our production environment. It does not reproduce on our test servers. any thoughts?

Devart.Data.Oracle.dll 9.0.12.0

call stack:

||544|2019/01/03 14:49:37.074|8284|PoolThread:89|||Details: Devart.Data.Oracle.OracleException: ORA-08103: object no longer exists
at Devart.Data.Oracle.cv.d()
at Devart.Data.Oracle.ah.i()
at Devart.Data.Oracle.ad.s(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.Entity.d.b(Int32 A_0, aa A_1)
at System.Data.Entity.Core.Common.Internal.Materialization.Coordinator`1.ReadNextElement(Shaper shaper)
at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Oracle Error (ORA-08103) happens intermittently

Post by Shalex » Thu 17 Jan 2019 13:45

Most likely, your table was truncated by another process at the same time when your code was executing select. Please refer to https://stackoverflow.com/questions/485 ... ing-tables.

Bellamy112
Posts: 1
Joined: Wed 05 Jan 2022 08:46

Re: Oracle Error (ORA-08103) happens intermittently

Post by Bellamy112 » Wed 05 Jan 2022 08:49

Shalex wrote: Thu 17 Jan 2019 13:45 Most likely, your table was truncated by another process at the same time when your code was executing select. Please refer to https://stackoverflow.com/questions/485 ... ing-tablesworld of solitaire
OK. So, does Connection Timeout=0 in OCI mode act the same and wait for the connection for an unlimited amount of time?

DmitryGm
Devart Team
Posts: 152
Joined: Fri 11 Dec 2020 10:27

Re: Oracle Error (ORA-08103) happens intermittently

Post by DmitryGm » Wed 05 Jan 2022 09:45

Bellamy112 wrote: Wed 05 Jan 2022 08:49does Connection Timeout=0 in OCI mode act the same and wait for the connection for an unlimited amount of time?
Yes, Connection Timeout is the time (in seconds) to wait while trying to establish a connection before terminating the attempt and generating an error. A value of 0 indicates no limit. The default value is 15 seconds.

See: ConnectionString Property

Post Reply