Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Debug level 2 hangs Perl.exe

Dec 27, 2002, 12:48 PM
webmaster33
Veteran (2312 posts)
Dec 27, 2002, 12:48 PM
Post #1 of 15
Views: 5152
Shortcut
Quote Reply
Debug level 2 hangs Perl.exe
Config: LSQL v2.1.1, ActivePerl v5.6.1 build 633, Apache v1.3.27, MySQL 3.23.49-nt, Windows XP + SP1
LSQL v2.1.1 was brand newly installed. Nothing modified, just Debug level.

When I set debug level 2, and call page.cgi?d=1, the perl.exe hangs.
Using Debug level 1, everything works fine, no perl hangups.
Later, when I kill the hanged perl.exe, error 500 is displayed in the browser.
The bug is replicable for me.

Did somebody have the same problem?
Paul, you also use XP. Did you find such problem? Could you try this out?

Merry Christmas & Happy New Year!

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Dec 30, 2002, 9:56 PM
pugdog
Veteran / Moderator (6956 posts)
Dec 30, 2002, 9:56 PM
Post #2 of 15
Views: 5026
Shortcut
Quote Reply
Re: [webmaster33] Debug level 2 hangs Perl.exe In reply to
Here's your problem: "Windows XP" <G>

Perl is a Unix thing, windows probably has code in it to prevent perl from running, to force you to use Vbasic or whatever flavor of scripting M$ is trying to force upon you at the moment.

No debug/perl problems under 3 versions of Unix :)


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Dec 31, 2002, 2:31 AM
Paul
Veteran (19537 posts)
Dec 31, 2002, 2:31 AM
Post #3 of 15
Views: 5008
Shortcut
Quote Reply
Re: [pugdog] Debug level 2 hangs Perl.exe In reply to
Quote:
Here's your problem: "Windows XP" <G>

Perl is a Unix thing, windows probably has code in it to prevent perl from running, to force you to use Vbasic or whatever flavor of scripting M$ is trying to force upon you at the moment.

No debug/perl problems under 3 versions of Unix :)

Great analysis, however I use XP successfully, with and without mod_perl
Dec 31, 2002, 5:22 AM
webmaster33
Veteran (2312 posts)
Dec 31, 2002, 5:22 AM
Post #4 of 15
Views: 4989
Shortcut
Quote Reply
Re: [pugdog] Debug level 2 hangs Perl.exe In reply to
Yeah, interesting opinion :-)
But I could imagine that Windows has some implemented code which sometimes hangs Netscape. A few years ago I was thinking on this.
Hopefully this is just a paranoid idea...

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Dec 31, 2002, 5:51 AM
webmaster33
Veteran (2312 posts)
Dec 31, 2002, 5:51 AM
Post #5 of 15
Views: 5039
Shortcut
Quote Reply
Re: [Paul] Debug level 2 hangs Perl.exe In reply to
Finally I got support answer from Alex.
He said it's a bug in Activestate Perl, and did send bug report to them.
The hang was likely caused by back traces what LSQL use.

Many thanks to Alex for finding the problem.

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Dec 31, 2002, 3:16 PM
Alex
Administrator (9387 posts)
Dec 31, 2002, 3:16 PM
Post #6 of 15
Views: 4975
Shortcut
Quote Reply
Re: [webmaster33] Debug level 2 hangs Perl.exe In reply to
The issue is when you use debug level 2, Links SQL generates a stack trace for every SQL query that is run. There are ceartain perl peculiarities with getting a stack trace that can cause the windows perl to seg fault.

Cheers,

Alex
--
Gossamer Threads Inc.
Dec 31, 2002, 4:13 PM
gatman
User (187 posts)
Dec 31, 2002, 4:13 PM
Post #7 of 15
Views: 4976
Shortcut
Quote Reply
Re: [Alex] Debug level 2 hangs Perl.exe In reply to
... And I'm getting this at level 1 using Windows 2000, Activestate 5.6.1 Build 633, mySQL 4.07 gamma
Dec 31, 2002, 4:22 PM
gatman
User (187 posts)
Dec 31, 2002, 4:22 PM
Post #8 of 15
Views: 4992
Shortcut
Quote Reply
Re: [gatman] Debug level 2 hangs Perl.exe In reply to
As an aside, I have been building on the DOS command line. Is there any way to pass the debug level to the build?

%>perl nph-build.cgi --all
Jan 1, 2003, 6:39 AM
webmaster33
Veteran (2312 posts)
Jan 1, 2003, 6:39 AM
Post #9 of 15
Views: 4965
Shortcut
Quote Reply
Re: [Alex] Debug level 2 hangs Perl.exe In reply to
There is an another perl.exe hang issue, when I use debug level 1, and the 'build_directory_field' is used.
I reported this through email support, but I post it here too, so others know about it.

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Jan 2, 2003, 12:22 AM
pugdog
Veteran / Moderator (6956 posts)
Jan 2, 2003, 12:22 AM
Post #10 of 15
Views: 4942
Shortcut
Quote Reply
Re: [Paul] Debug level 2 hangs Perl.exe In reply to
>> .... however I use XP successfully....



One of the very few, it seems.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Jan 2, 2003, 12:37 AM
webmaster33
Veteran (2312 posts)
Jan 2, 2003, 12:37 AM
Post #11 of 15
Views: 4985
Shortcut
Quote Reply
Re: [Paul] Debug level 2 hangs Perl.exe In reply to
What's your installed Perl version?

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Jan 2, 2003, 2:49 AM
Paul
Veteran (19537 posts)
Jan 2, 2003, 2:49 AM
Post #12 of 15
Views: 4920
Shortcut
Quote Reply
Re: [pugdog] Debug level 2 hangs Perl.exe In reply to
>>
One of the very few, it seems.
<<

Evidence?
Jan 2, 2003, 2:49 AM
Paul
Veteran (19537 posts)
Jan 2, 2003, 2:49 AM
Post #13 of 15
Views: 4958
Shortcut
Quote Reply
Re: [webmaster33] Debug level 2 hangs Perl.exe In reply to
Same as you.
Jan 2, 2003, 3:18 AM
webmaster33
Veteran (2312 posts)
Jan 2, 2003, 3:18 AM
Post #14 of 15
Views: 4940
Shortcut
Quote Reply
Re: [Paul] Debug level 2 hangs Perl.exe In reply to
ActivePerl v5.8.0 build 804 (Windows) released.
Just downloaded, and will try out (sometime nowadays) whether it's working fine with LSQL or not.

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Feb 20, 2005, 5:03 PM
webmaster33
Veteran (2312 posts)
Feb 20, 2005, 5:03 PM
Post #15 of 15
Views: 4840
Shortcut
Quote Reply
Re: [Alex] Debug level 2 hangs Perl.exe In reply to
After 2 years, this BUG is still alive Mad
This bug makes me crazy, because I can not do any SQL related debugging! Frown
The bug hangs perl.exe, when $GT::SQL::DEBUG = 2 is set.

At least a workaround should be done when outputting to STDERR, as it hangs if over 4K of data gets written to STDERR. Maybe a slowed output or unbuffered output could solve the problem...

My environment, is
Win XP v5.1.2600 + SP2
ActiveState v5.8.6 build 811 built for MSWin32-x86-multi-thread
LSQL v2.2.1

Any news about a workaround?

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...