MySQL Forums
Forum List  »  Perl

Perl DBI Client Hangs
Posted by: Nick Matheson
Date: March 21, 2006 12:43PM

Just wanted to see if anyone could point me in the right direction on this one.

I am using a cluster of 64 Bit AMD Opterons to save raw data, retrieve raw data, summarize raw data and then save the summary data into/from the same MySQL database.

With higher job density I am seeing Perl jobs that hang (Unresponsive processes with no CPU usage). Even after the load goes down the jobs are permanently hung.

I attached to some of the hung processes with GDB and have found the following stack trace:

#0 0x00000036f91b7e52 in __read_nocancel () from /lib64/tls/libc.so.6
#1 0x0000003113d3cff8 in vio_read () from /usr/lib64/mysql/libmysqlclient.so.14
#2 0x0000003113d3e960 in net_write_command () from /usr/lib64/mysql/libmysqlclient.so.14
#3 0x0000003113d3ecf5 in my_net_read () from /usr/lib64/mysql/libmysqlclient.so.14
#4 0x0000003113d388d8 in net_safe_read () from /usr/lib64/mysql/libmysqlclient.so.14
#5 0x0000003113d395c7 in cli_read_rows () from /usr/lib64/mysql/libmysqlclient.so.14
#6 0x0000003113d3b5fe in mysql_store_result () from /usr/lib64/mysql/libmysqlclient.so.14
#7 0x0000002a98696b5a in mysql_st_internal_execute (h=0x2a98179030, statement=0xc2, attribs=0xd, num_params=0,
params=0x0, result=0x3e4dc70, svsock=0x1924448, use_mysql_use_result=0) at dbdimp.c:2412
#8 0x0000002a9869751f in mysql_st_execute (sth=0x2a98179030, imp_sth=0x3e4db80) at dbdimp.c:2604
#9 0x0000002a986982c3 in XS_DBD__mysql__db_selectall_arrayref (cv=0x4) at mysql.xsi:136
#10 0x0000002a97e8054f in XS_DBI_dispatch () from /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBI/DBI.so
#11 0x00000000004711bb in Perl_pp_entersub ()
#12 0x000000000046a77e in Perl_runops_standard ()
#13 0x0000000000421508 in perl_run ()
#14 0x000000000041b9dd in main ()

I am not sure of all of the relevant info but here is a start:

Database Server

Red Hat Enterprise AS Release 4 Update 2
Kernel 2.6.9-22-ELsmp
MySQL Server 5.0.18-standard

Cluster Node

Red Hat Enterprise WS Release 4
Kernel 2.6.9-5.ELsmp
MySQL Client v14.12 from 5.0.18 Distribution
Perl 5.8.8 (Custom build of Perl with support for specific GDI features.)

If any additional information would be helpful please let me know.

Cheers,

Nick

Options: ReplyQuote


Subject
Written By
Posted
Perl DBI Client Hangs
March 21, 2006 12:43PM
July 02, 2006 08:29AM
July 11, 2006 01:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.