Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

MySQL Strange Messages

Nov 3, 2008, 8:20 AM
carfac
Veteran (1240 posts)
carfac's avatar
Nov 3, 2008, 8:20 AM
Post #1 of 1
Views: 7779
Shortcut
Quote Reply
MySQL Strange Messages
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
dave

Big Cartoon DataBase
Big Comic Book DataBase