{"id":44,"date":"2016-05-21T19:16:00","date_gmt":"2016-05-21T19:16:00","guid":{"rendered":"\/colin\/morethanfour\/post\/Crashing-a-server-process-with-Error-14508"},"modified":"2016-05-21T19:16:00","modified_gmt":"2016-05-21T19:16:00","slug":"crashing-a-server-process-with-error-14508","status":"publish","type":"post","link":"https:\/\/spacefold.com\/colin\/morethanfour\/2016\/05\/21\/crashing-a-server-process-with-error-14508\/","title":{"rendered":"Crashing a server process with Error 14508"},"content":{"rendered":"<p>We have a SQL query that accepts  WHERE clause parameters of date range. 1 year, 2 years, all work predictably. When I use a very large date range (i.e. &#8220;everything&#8221;), the Oracle dedicated server process crashes.<\/p>\n<p>From the trace file:<\/p>\n<div id=\"codeSnippetWrapper\">\n<pre id=\"codeSnippet\" style=\"border-top-style: none; font-size: 8pt; overflow: visible; border-left-style: none; font-family: 'Courier New', courier, monospace; width: 100%; border-bottom-style: none; color: black; padding-bottom: 0px; direction: ltr; text-align: left; padding-top: 0px; border-right-style: none; padding-left: 0px; margin: 0em; line-height: 12pt; padding-right: 0px; background-color: #f4f4f4\">*** 2016-05-20 22:06:12.735<br>*** SESSION ID:(630.42649) 2016-05-20 22:06:12.735<br>*** CLIENT ID:() 2016-05-20 22:06:12.735<br>*** SERVICE NAME:(SYS$USERS) 2016-05-20 22:06:12.735<br>*** MODULE NAME:(rix) 2016-05-20 22:06:12.735<br>*** CLIENT DRIVER:() 2016-05-20 22:06:12.735<br>*** ACTION NAME:(prepare_series(a)) 2016-05-20 22:06:12.735<br> <br>Block Checking: DBA = 8236992, Block Type = Unlimited undo segment header<br>ERROR: Undo Segment Header Corrupted. Error Code = 14508<br>ktu4shck: starting extent(0xffff8000) of txn slot #0x6b is invalid.<\/pre>\n<p><\/div>\n<p>Searching Google brought up a <a href=\"https:\/\/iusoltsev.wordpress.com\/2015\/10\/11\/12c-ora-600-kdblkcheckerror-%D0%BF%D1%80%D0%B8-%D0%B8%D1%81%D0%BF%D0%BE%D0%BB%D1%8C%D0%B7%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D0%B8-temporary-undo-%D0%B2-oebs\/\" target=\"_blank\" rel=\"noopener noreferrer\">Russian blog page, that seems to be citing<\/a> exactly the same issue:<\/p>\n<div id=\"codeSnippetWrapper\">\n<pre id=\"codeSnippet\" style=\"border-top-style: none; font-size: 8pt; overflow: visible; border-left-style: none; font-family: 'Courier New', courier, monospace; width: 100%; border-bottom-style: none; color: black; padding-bottom: 0px; direction: ltr; text-align: left; padding-top: 0px; border-right-style: none; padding-left: 0px; margin: 0em; line-height: 12pt; padding-right: 0px; background-color: #f4f4f4\">*** MODULE NAME:(e:AR:bes:oracle.apps.xla.accounting.extract) 2015-10-01 06:37:00.659 -- \u0441\u0442\u0430\u043d\u0434.\u043c\u043e\u0434\u0443\u043b\u044c OEBS<br>...<br> <br>Block Checking: DBA = 14597504, Block Type = Unlimited undo segment header -- \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 UNDO<br>ERROR: Undo Segment Header Corrupted. Error Code = 14508 -- \u043f\u0430\u0434\u0430\u0435\u0442 \u0441\u043e \u0441\u043f\u0435\u0446\u0438\u0444\u0438\u0447\u043d\u043e\u0439 \u0434\u043b\u044f ANALYZE \u043e\u0448\u0438\u0431\u043a\u043e\u0439 (***)<br>ktu4shck: starting extent(0xffff8000) of txn slot <span style=\"color: #008000\">#0x21 is invalid.<\/span><br>valid value (0 - 0x8000)<\/pre>\n<p><\/div>\n<p>The gist of the post seems to indicate that they are using Oracle 12.1.0.2 and had set TEMP_UNDO_ENABLED=TRUE (a new feature in 12c).<\/p>\n<p>This is interesting because we set this parameter true also, in our code.<\/p>\n<p>Google Translate failed to come through with a useful translation, but it could be that they set this parameter FALSE in order to resolve the problem.<\/p>\n<p>Previously, our test failed after ~2 hours. So far, having made the change to the parameter, it is still running after 4 hours. So, we&#8217;re optimistic.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have a SQL query that accepts WHERE clause parameters of date range. 1 year, 2 years, all work predictably. When I use a very large date range (i.e. &#8220;everything&#8221;), the Oracle dedicated server process crashes. From the trace file: *** 2016-05-20 22:06:12.735*** SESSION ID:(630.42649) 2016-05-20 22:06:12.735*** CLIENT ID:() 2016-05-20 22:06:12.735*** SERVICE NAME:(SYS$USERS) 2016-05-20 22:06:12.735*** [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-44","post","type-post","status-publish","format-standard","hentry","category-oracle","post-preview"],"_links":{"self":[{"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/posts\/44","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/comments?post=44"}],"version-history":[{"count":0,"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/posts\/44\/revisions"}],"wp:attachment":[{"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/media?parent=44"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/categories?post=44"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spacefold.com\/colin\/morethanfour\/wp-json\/wp\/v2\/tags?post=44"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}