Fwd: our server got stuck
hi All,
Last month, one of the our server got stuck but We could n't find the
reason. Here I have attached the OS(Red Hat Enterprise Linux AS relese 4)
message log. I think issue may be in MySQL.
We are using MySQL Server version: 5.1.12-beta MySQL Community Server (GPL)
So if you can please send me what are the actions we can take for avoid this
type of scenarios in future.
Thanks
#--
Aug 14 22:18:48 localhost kernel: Unable to handle kernel NULL pointer
dereference at 0018 RIP:
Aug 14 22:18:48 localhost kernel:
{:jbd:journal_commit_transaction+1140}
Aug 14 22:18:48 localhost kernel: PML4 46aec067 PGD 29203b067 PMD 0
Aug 14 22:18:48 localhost kernel: Oops: 0002 [1] SMP
Aug 14 22:18:48 localhost kernel: CPU 2
Aug 14 22:18:48 localhost kernel: Modules linked in: nfsd exportfs lockd
parport_pc lp parport autofs4 i2c_dev i2c_core sunrpc ds yenta_socket
pcmcia_core dm_mod button battery ac md5 ipv6 joydev ohci_hcd ehci_hcd tg3
floppy ext3 jbd mppVhba(U) qla2400(U) qla2xxx(U) qla2xxx_conf(U) aacraid(U)
mppUpper(U) sg sd_mod scsi_mod
Aug 14 22:18:48 localhost kernel: Pid: 2255, comm: kjournald Tainted: GF
2.6.9-5.ELsmp
Aug 14 22:18:48 localhost kernel: RIP: 0010:[]
{:jbd:journal_commit_transaction+1140}
Aug 14 22:18:48 localhost kernel: RSP: :01032adf7bb8 EFLAGS:
00010202
Aug 14 22:18:48 localhost kernel: RAX: 01025e9b0d98 RBX:
RCX: c100
Aug 14 22:18:48 localhost kernel: RDX: 0101c5721818 RSI:
01032adf6000 RDI: 0202
Aug 14 22:18:48 localhost kernel: RBP: R08:
01032adf6000 R09: 0100b58bdd80
Aug 14 22:18:48 localhost kernel: R10: 01032adf7b68 R11:
01032adf7b68 R12: 0101c5721b88
Aug 14 22:18:48 localhost kernel: R13: 0103277aeac0 R14:
0100cfe30e00 R15:
Aug 14 22:18:48 localhost kernel: FS: 002a95564b00()
GS:804bf400() knlGS:
Aug 14 22:18:48 localhost kernel: CS: 0010 DS: ES: CR0:
8005003b
Aug 14 22:18:48 localhost kernel: CR2: 0018 CR3:
cff6e000 CR4: 06e0
Aug 14 22:18:48 localhost kernel: Process kjournald (pid: 2255, threadinfo
01032adf6000, task 01032a8d67f0)
Aug 14 22:18:48 localhost kernel: Stack:
Aug 14 22:18:48 localhost kernel:010078d73088 1fd0
01032a8d67f0
Aug 14 22:18:48 localhost kernel:80132ff0 01032adf7c30
Aug 14 22:18:48 localhost kernel: Call
Trace:{autoremove_wake_function+0}
{autoremove_wake_function+0}
Aug 14 22:18:48 localhost kernel:
{:jbd:kjournald+250}
{autoremove_wake_function+0}
Aug 14 22:18:48 localhost kernel:
{autoremove_wake_function+0}
{:jbd:commit_timeout+0}
Aug 14 22:18:48 localhost kernel:{child_rip+8}
{:jbd:kjournald+0}
Aug 14 22:18:48 localhost kernel:{child_rip+0}
Aug 14 22:18:48 localhost kernel:
Aug 14 22:18:48 localhost kernel: Code: f0 ff 43 18 8b 03 a8 04 74 52 49 8d
be 5c 01 00 00 e8 17 1a
Aug 14 22:18:48 localhost kernel: RIP
{:jbd:journal_commit_transaction+1140} RSP
<01032adf7bb8>
Aug 14 22:18:48 localhost kernel: CR2: 0018
#
Aug 24 17:41:35 localhost kernel: Unable to handle kernel NULL pointer
dereference at RIP:
Aug 24 17:41:35 localhost kernel:
{:jbd:journal_commit_transaction+1136}
Aug 24 17:41:35 localhost kernel: PML4 2cd832067 PGD 1f1216067 PMD 0
Aug 24 17:41:35 localhost kernel: Oops: [1] SMP
Aug 24 17:41:35 localhost kernel: CPU 3
Aug 24 17:41:35 localhost kernel: Modules linked in: parport_pc lp parport
autofs4 i2c_dev i2c_core sunrpc ds yenta_socket pcmcia_core dm_mod button
battery ac md5 ipv6 joydev ohci_hcd ehci_hcd tg3 floppy ext3 jbd mppVhba(U)
qla2400(U) qla2xxx(U) qla2xxx_conf(U) aacraid(U) mppUpper(U) sg sd_mod
scsi_mod
Aug 24 17:41:35 localhost kernel: Pid: 2312, comm: kjournald Tainted: GF
2.6.9-5.ELsmp
Aug 24 17:41:35 localhost kernel: RIP: 0010:[]
{:jbd:journal_commit_transaction+1136}
Aug 24 17:41:35 localhost kernel: RSP: 0018:01032ae27bb8 EFLAGS:
00010206
Aug 24 17:41:35 localhost kernel: RAX: 0102691752f0 RBX:
0101018779d0 RCX: c100
Aug 24 17:41:35 localhost kernel: RDX: c100 RSI:
0101018779d0 RDI: 0100cfe3dc00
Aug 24 17:41:35 localhost kernel: RBP: R08:
01032ae26000 R09: 0046
[EMAIL PROTECTED] log]# grep "Aug 24 17:41" messages.2
Aug 24 17:41:35 localhost kernel: Unable to handle kernel NULL pointer
dereference at RIP:
Aug 24 17:41:35 localhost kernel:
{:jbd:journal_commit_transaction+1136}
Aug 24 17:41:35 localhost kernel: PML4 2cd832067 PGD 1f1216067 PMD 0
Aug 24 17:41:35 localh
Re: MySQL 6.0.2-alpha and Falcon and possible bug/problem
Mariella Petrini wrote: ...MySQL 6.0.2 with Falcon on Linux with Debian 4. I have compiled the source code for 64 bit executable. The system is an Intel 2 cpus 4 cores each, with 8 GB of RAM. After having created approximately 8,500 empty tables mysqld server was still alive, you could connect with the mysql client, but any command that you would type would freeze (never come back). It would be interesting to get a stack trace at that point. We do have tests that create that many tables, so the problem is going to take some thought. I will try to re-run the same job, enabling falcon_debug_mask and see if I can get more info and repeat the problem. Sounds good - that can produce a LOT of output... so be sure to redirect it to a file. Best regards, Ann -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 6.0.2-alpha and Falcon and possible bug/problem
Mathieu Bruneau wrote: I never tried the falcon engine, but could it be that mysql is running out of file descriptor ? That's less likely with Falcon than with engines that put each table and index in its own file. By default, Falcon tables share a single tablespace. Regards, Ann -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Selecting just 'N' first rows
How can I send a query that retrieves only the first 'N' rows that match a condition? As far as I know you must call mysql_fetch_row() until the last row has been processed or the resources allocated won't be free. Am creating a program in PHP that should retrieve only 'N' records each time a query is sent, so I I'm thinking on using mysql_free_result(), but, is it safe to free the results even if there are more records remaining that match the query conditions? I need to know how secure could be to read only the first records and free the resources, or if there is another way to do the same thing. Why dont' you just use the LIMIT statement? thnx, Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Selecting just 'N' first rows
Look up the LIMIT clause of SELECT statement, also ASCENDING/DESCENDING - depending on how you want it. Remember LIMIT can take a number and an offset. Terry - Original Message - > *From:* Renito 73 <[EMAIL PROTECTED]> > *To:* mysql@lists.mysql.com > *Date:* Sun, 9 Sep 2007 10:05:52 -0500 > > Hello > > How can I send a query that retrieves only the first 'N' rows that > match a condition? As far as I know you must call mysql_fetch_row() > until the last row has been processed or the resources allocated > won't be free. > > Am creating a program in PHP that should retrieve only 'N' records > each time a query is sent, so I I'm thinking on using > mysql_free_result(), but, is it safe to free the results even if > there are more records remaining that match the query conditions? > > I need to know how secure could be to read only the first records and > free the resources, or if there is another way to do the same thing. > > Thanks, > Miguel > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.485 / Virus Database: 269.13.10/995 - Release Date: > 08/09/2007 13:24 > > Terry http://booksihaveread.awardspace.co.uk -- No virus found in this outgoing message. Checked by AVG. Version: 7.5.485 / Virus Database: 269.13.10/995 - Release Date: 08/09/2007 13:24 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Selecting just 'N' first rows
Hello How can I send a query that retrieves only the first 'N' rows that match a condition? As far as I know you must call mysql_fetch_row() until the last row has been processed or the resources allocated won't be free. Am creating a program in PHP that should retrieve only 'N' records each time a query is sent, so I I'm thinking on using mysql_free_result(), but, is it safe to free the results even if there are more records remaining that match the query conditions? I need to know how secure could be to read only the first records and free the resources, or if there is another way to do the same thing. Thanks, Miguel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
