Code runs fine on my home system Windows Perl 5.8 Code was running fine on a hosted system, then the hosting service upgraded the Perl version from 5.3 to 5.7 and it stopped running. We tried version 5.3 and 5.8 - it still did not work on that server. After 3 weeks to trying to isolate the problem we gave up and moved it to another server (that had not been upgraded). Worked fine. They have now upgraded the that system, same problem.
I have tried removing huge chunks of code, split processes in two and still get the problem. Execution termination floats around from one execute to another as the data set changes or if I remove code. Here is the DBI trace (the first line is my debug code) CSDB_Sites.pm::getSiteLocation:297: after prepare:SELECT city, state, country from sites where site='http://www.nipissingu.ca/' ; siteQH:DBI::st=HASH(0xa7ac35c) reerse/public_html/cgi-bin/ExtractJob.pm line 280 -> prepare for DBD::mysql::db (DBI::db=HASH(0xa6d3aa8)~0xa6d3b8c 'SELECT city, state, country from sites where site='http://www.nipissingu.ca/' ;') thr#9c49008 New 'DBI::st' (for DBD::mysql::st, parent=DBI::db=HASH(0xa6d3b8c), id=undef) dbih_setup_handle(DBI::st=HASH(0xa7ac35c)=>DBI::st=HASH(0xa79ac64), DBD::mysql::st, a820834, Null!) dbih_make_com(DBI::db=HASH(0xa6d3b8c), a721018, DBD::mysql::st, 252, 0) thr#9c49008 dbih_setup_attrib(DBI::st=HASH(0xa79ac64), Err, DBI::db=HASH(0xa6d3b8c)) SCALAR(0x9e715ac) (already defined) dbih_setup_attrib(DBI::st=HASH(0xa79ac64), State, DBI::db=HASH(0xa6d3b8c)) SCALAR(0x9e7160c) (already defined) dbih_setup_attrib(DBI::st=HASH(0xa79ac64), Errstr, DBI::db=HASH(0xa6d3b8c)) SCALAR(0x9e715dc) (already defined) dbih_setup_attrib(DBI::st=HASH(0xa79ac64), TraceLevel, DBI::db=HASH(0xa6d3b8c)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0xa79ac64), FetchHashKeyName, DBI::db=HASH(0xa6d3b8c)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0xa79ac64), HandleSetErr, DBI::db=HASH(0xa6d3b8c)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xa79ac64), HandleError, DBI::db=HASH(0xa6d3b8c)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xa79ac64), ReadOnly, DBI::db=HASH(0xa6d3b8c)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0xa79ac64), Profile, DBI::db=HASH(0xa6d3b8c)) undef (not defined) -> dbd_st_prepare MYSQL_VERSION_ID 40122, SQL statement: SELECT city, state, country from sites where site='http://www.nipissingu.ca/' ; >- dbd_st_free_result_sets <- dbd_st_free_result_sets RC -1 <- dbd_st_free_result_sets >count_params statement SELECT city, state, country from sites where >site='http://www.nipissingu.ca/' ; <- dbd_st_prepare <- prepare= DBI::st=HASH(0xa7ac35c) at /home/careerse/public_html/cgi-bin/CSDB_Sites.pm line 297 via at /home/careerse/public_html/cgi-bin/ExtractJob.pm line 280 >> execute DISPATCH (DBI::st=HASH(0xa7ac35c) rc1/1 @1 g0 ima1041 pid#17112) at >> /home/careerse/public_html/cgi-bin/CSDB_Sites.pm line 298 via at >> /home/careerse/public_html/cgi-bin/ExtractJob.pm line 280 -> execute for DBD::mysql::st (DBI::st=HASH(0xa7ac35c)~0xa79ac64) thr#9c49008 -> dbd_st_execute for 0a820aec >- dbd_st_free_result_sets <- dbd_st_free_result_sets RC -1 <- dbd_st_free_result_sets mysql_st_internal_execute MYSQL_VERSION_ID 40122 >parse_params statement SELECT city, state, country from sites where >site='http://www.nipissingu.ca/' ; my_login skip connect Given the same data set it fails in the same place mostly. Different data sets fail on different MySQL queries. Often, as in this case, they are fairly simple selects. They tend to fail near the end of the program. The last line of the trace is always my_login skip connect Perl v 5.8.8 MySQL v 4.1.22-standard Any advice on how I should proceed in figuring this out? Thanks, ian __________________________________________________________________ Looking for the perfect gift? Give the gift of Flickr! http://www.flickr.com/gift/
