homepage Welcome to WebmasterWorld Guest from 54.196.69.189
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe and Support WebmasterWorld
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
MySQL Problem
tried to use non-present sched_yield
carfac




msg:3779256
 4:04 pm on Nov 3, 2008 (gmt 0)

Having some REALLY strange things happen on my MySQL server this morning. First, I am getting messages like this:

Nov 3 07:33:21 debi kernel: cmd mysqld pid 1263 tried to use non-present sched_yield
Nov 3 07:33:57 debi last message repeated 8 times
Nov 3 07:35:22 debi last message repeated 5 times

My "message" log file was 8 Megs this morning of these! I stopped and restarted MySQL, and they continued in a similar manner. I restarted the server, and they continue.

I also have a LOT of really weird messages suddenly appearing in other, various logs:

(Sample from Debug.log):

Nov 3 06:38:28 debi kernel: 1m8y>sqse
Nov 3 06:38:30 debi kernel: 0s
Nov 3 06:38:30 debi kernel: <2
Nov 3 06:38:31 debi kernel: s
Nov 3 06:38:31 debi kernel: <> 3
Nov 3 06:38:31 debi kernel: n1t8 >s1
Nov 3 06:38:32 debi kernel: 1d8> 0
Nov 3 06:38:32 debi kernel: 08d
Nov 3 06:38:32 debi kernel:
Nov 3 06:38:32 debi kernel: p1r8e>se
Nov 3 06:38:33 debi kernel: :r
Nov 3 06:38:33 debi kernel: 1e8>n
Nov 3 06:38:38 debi kernel: 2sq
Nov 3 06:38:38 debi kernel: t1 8>sl
Nov 3 06:38:38 debi kernel: :p
Nov 3 06:38:40 debi kernel:
Nov 3 06:38:40 debi kernel: 1y8>s6:
Nov 3 06:38:40 debi kernel: :5 t
Nov 3 06:38:41 debi kernel: 1t8r>iN
Nov 3 06:38:46 debi kernel: c
Nov 3 06:38:46 debi kernel: 0u
Nov 3 06:38:48 debi kernel: :s3q
Nov 3 06:38:48 debi kernel: 0 t
Nov 3 06:38:48 debi kernel: 12088>s1e
Nov 3 06:38:48 debi kernel: 5
Nov 3 06:38:48 debi kernel: 1d 8>ms

(Sample from xfer.log)

Nov 3 06:37:49 debi kernel: l
Nov 3 06:38:09 debi kernel: 0d8
Nov 3 06:38:09 debi kernel: d
Nov 3 06:38:09 debi kernel: h
Nov 3 06:38:09 debi kernel: don
Nov 3 06:38:09 debi kernel: 0 8
Nov 3 06:38:49 debi kernel: dus
Nov 3 06:38:49 debi kernel: <n3- p>r
Nov 3 06:38:49 debi kernel: 5< 3t
Nov 3 06:38:49 debi kernel: 0
Nov 3 06:38:49 debi kernel: d20
Nov 3 06:39:06 debi kernel: :n
Nov 3 06:39:33 debi kernel: :e
Nov 3 06:39:41 debi kernel: :4t
Nov 3 06:39:41 debi kernel: :i
Nov 3 06:39:41 debi kernel: :048
Nov 3 06:39:42 debi kernel: :_4y
Nov 3 06:39:42 debi kernel: :
Nov 3 06:39:42 debi kernel: :4
Nov 3 06:39:42 debi kernel: :d
Nov 3 06:39:59 debi kernel: u se

Really strange!

Any idea what is happening... or better, how to fix it?

I did some googling, and about the only thing I could find was to rebuild my KERNEL with:

options P1003_1B
options _KPOSIX_PRIORITY_SCHEDULING
options _KPOSIX_VERSION=199309L

Added. But I do not know or understand what this is. These posts are a couple years old, too. Not a whole lot out there on this topic. POSIX is not something I use (knowingly!). If I add this, do I have to install anything else? Does this look right to you? What the heck is POSIX?

This is a Dedicated MySQL server running Server version: 5.1.22-rc-log on FreeBSD 6.2-RELEASE with a 4 Core Intel(R) Xeon(R) CPU E5335 @ 2.00GHz and 8 Gig Memory.

Oh, about the only change I have made recently is I have added is InnoDB and tables. My MySQL databases are pretty well optimized using MySQLTuner 0.9.9 and tuner-primer.sh

Thanks!

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved