Perl DBI Client Hangs
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
Subject
Written By
Posted
Perl DBI Client Hangs
March 21, 2006 12:43PM
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.