Re: kdmsIMCURelease
Date: Tue, 9 Jan 2018 18:26:11 -0600
Message-ID: <CAMHX9JL00soLXW=-Co5o11SGZxUs-g3rsmKoKfU-S7dXwY-FQg_at_mail.gmail.com>
Thanks for a good excuse for geeking out ;-)
This stack trace shows that the problem happens during execution phase of
your select statement - *selexe()*. The QEC in *qecrlssub()* means
something like *Q*uery *E*xecution sql *C*apability checking.
And I guess you are hitting a bug when finishing a table or partition scan
- *qertbRelease() *- Oracle tries to release a pin on some in-memory
compression unit that it thinks has been pinned during the scan. Perhaps it
thinks that some IMCU has been "opened" due to the capability check of
whether a table/block region is cached in the IM columnstore. Or something
like that (it's a bug, who knows).
But given that Oracle's trying to do IMCU checks when you don't even have
tables cached in memory - try setting *alter session set **inmemory_query =
false* (it's true by default) and rerun your query, maybe it alters the
code path so it doesn't even hit this buggy codepath.
--
Thanks,
Tanel Poder
P.S. Oh, almost forgot to mention, I'm running my AOT seminar one more time
this year ;-)
http://blog.tanelpoder.com/seminar
On Tue, Jan 9, 2018 at 9:02 AM, Noveljic Nenad <nenad.noveljic_at_vontobel.com>
wrote:
> Hi,
>
>
>
> I hit an ORA-7445 in the function kdmsIMCURelease in Oracle 12.1:
>
> ORA-07445: CORE Dump [kdmsIMCURelease()+29] [SIGSEGV] [ADDR:0x23FC96D]
> [PC:0x23FC96D] [Address not mapped to object] []
>
>
>
> I assume the function kdmsIMCURelease has something to do with In Memory,
> but In Memory is not configured.
>
>
>
> Does somebody know why would Oracle call a function which presumably
> handles IM, even though IM is not configured at all?
>
>
>
> The full stack is:
>
> kdmsIMCURelease()+2 signal sigacthandler() 00000000B ?
>
> 9 FFFF80FFBDECFEF0 ?
>
> FFFF80FFBDECF840 ?
>
> qertbRelease()+580 call kdsimcrls() FFFF80FFBBF30FF8 ?
>
> FFFF80FFBDECFEF0 ?
>
> FFFF80FFBDECF840 ?
>
> 000000000 ?
>
> FFFF80FFBDADE2B8 ?
>
> FFFF80FFBDADE2B4 ?
>
> qecrlssub()+90 call qertbRelease() 2AC3ABFD0 ?
>
> FFFF80FFBDADE208 ?
>
> FFFF80FFBDECF840 ?
>
> 000000000 ?
>
> FFFF80FFBDADE2B8 ?
>
> FFFF80FFBDADE2B4 ?
>
> selexe0()+1199 call qecrlssub() 2CE910EB8 ?
>
> FFFF80FFBDADE208 ?
>
> FFFF80FFBDECF840 ?
>
> 000000000 ?
>
> FFFF80FFBDADE2B8 ?
>
> FFFF80FFBDADE2B4 ?
>
> opiexe()+5547 call selexe0() 2CE910EB8 ?
>
> FFFF80FFBFFF5770 ?
>
> FFFF80FFBFFF5920 ?
>
> 000000000 ?
>
> FFFF80FFBDADE2B8 ?
>
> FFFF80FFBDADE2B4 ?
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 10 2018 - 01:26:11 CET