Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Both the 2 nodes crashed with "BUG: soft lockup - CPU#11 stuck for 67s! [migration/0:5]"

user11982888Aug 7 2014 — edited Aug 18 2014

Hi,

Our 2 nodes RAC worked for over 6months without any problems. Suddenly both the 2 nodes crashed with error "BUG: soft lockup - CPU#11 stuck for 67s! [migration/0:5]" in the console.

We are with Oracle CRS/RAC 11.2.0.4 in Redhat 6.3. Kernel used is 2.6.32-279.el6.x86_64. Both the 2 nodes are  HP ProLiant DL380p Gen8 with BIOS P70 03/01/2013. The shared storage is NetApp and NFS is used.

After re-booting the RAC is back to normal. I wonder if this can happen again and how to prevent such incident (upgrade Kernel/BIOS etc)?

Pls advice.

Pham

Comments

Frank Kulash

Hi, User_97XVQ
If you want the sub-string of str from the start of the string up to (but not including) the last substring of hyphen-digits-hyphen, then you can use:

REGEXP_SUBSTR ( str
	      , '(.*)-\d+-'
	      , 1
	      , 1
	      , NULL
	      , 1
	      )

If you'd care to post CREATE TABLE and INSERT statements for the sample data, then I could test it.
If str does not contain a sub-0string of all digits surrounded by hyphens, then the expression above returns NULL.

Frank Kulash

Hi, User_97XVQ
I see that you changed your original message after I replied. Please don't do that: it makes the thread hard to read and your changes easy to miss. Make any corrections and additions in a new reply, at the end of the thread.
If tst is a string containing one or more digits, immediately preceded and followed by a hyphen, then

REGEXP_SUBSTR ( tst
	      , '(.*?)-\d+-'
	      , 1
	      , 1
	      , NULL
	      , 1
	      )

returns the sub-string before the first occurrence of the hyphen-digits-hyphen pattern. The only change for your new requirements is the '?' in the second argument, making '.*' non-greedy (that is, matching as little as possible when there is a choice).
As before, the expression returns NULL if tst does not contain a hyphen-digits-hyphen pattern.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 15 2014
Added on Aug 7 2014
2 comments
2,522 views