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

Re: [Paul] can't loop for over 16 times when debug_level set to 1

Mar 20, 2003, 6:08 AM
webmaster33
Veteran (2312 posts)
Mar 20, 2003, 6:08 AM
Views: 4365
Shortcut
Quote Reply
Re: [Paul] can't loop for over 16 times when debug_level set to 1 In reply to
I quote here my bug report I sent to GT support:

Report 1st is about debug level 2 problem:
Quote:
Config: LSQL v2.1.1, ActivePerl v5.6.1 build 633, Apache v1.3.27, MySQL 3.23.49-nt, Windows XP + SP1.
LSQL 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.


Also into the Apache error.log following is added:
-------------------------------------
[Thu Dec 26 16:13:55 2002] [info] Invoking CGI Command '"F:\Perl\bin\perl.exe" "c:\work\cgi-bin\lsql\page.cgi" '
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] Premature end of script headers c:/work/cgi-bin/lsql/page.cgi
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL (340) Creating new table object for lsql_Category at c:/work/cgi-bin/lsql/admin/GT/SQL/Base.pm line 120.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Table (340) Loading state for lsql_Category at c:/work/cgi-bin/lsql/admin/GT/SQL/Table.pm line 178.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Table (340) State loaded for lsql_Category at c:/work/cgi-bin/lsql/admin/GT/SQL/Table.pm line 182.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL (340) Creating new table object for lsql_Links at c:/work/cgi-bin/lsql/admin/GT/SQL/Base.pm line 120.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Table (340) Loading state for lsql_Links at c:/work/cgi-bin/lsql/admin/GT/SQL/Table.pm line 178.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Table (340) State loaded for lsql_Links at c:/work/cgi-bin/lsql/admin/GT/SQL/Table.pm line 182.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL (340) Creating new table object for lsql_CatLinks at c:/work/cgi-bin/lsql/admin/GT/SQL/Base.pm line 120.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Table (340) Loading state for lsql_CatLinks at c:/work/cgi-bin/lsql/admin/GT/SQL/Table.pm line 178.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Table (340) State loaded for lsql_CatLinks at c:/work/cgi-bin/lsql/admin/GT/SQL/Table.pm line 182.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Driver/MYSQL (340) Connecting to database with 'DBI:mysql:links:localhost', 'links', '**********' at c:/work/cgi-bin/lsql/admin/GT/SQL/Driver.pm line 82.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Driver/MYSQL (340) Connected successfully to database. at c:/work/cgi-bin/lsql/admin/GT/SQL/Driver.pm line 87.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Table (340) Query SELECT COUNT(*) FROM lsql_CatLinks
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Driver/MYSQL (340) Preparing query SELECT COUNT(*) FROM lsql_CatLinks at c:/work/cgi-bin/lsql/admin/GT/SQL/Driver/MYSQL.pm line 35.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Driver/MYSQL/sth (340) Executing query SELECT COUNT(*) FROM lsql_CatLinks
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) GT/SQL/Driver/MYSQL/sth/execute called at c:/work/cgi-bin/lsql/admin/GT/SQL/Table.pm line 949 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (GT/SQL/Driver/MYSQL/sth=HASH(0x21d9fb8)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) GT/SQL/Table/do_query called at c:/work/cgi-bin/lsql/admin/GT/SQL/Table.pm line 865 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (GT/SQL/Table=HASH(0x1a2a10c), SELECT COUNT(*) FROM lsql_CatLinks , ARRAY(0x1a06234)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) GT/SQL/Table/select called at c:/work/cgi-bin/lsql/admin/GT/SQL/Base.pm line 277 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (GT/SQL/Table=HASH(0x1a2a10c), ARRAY(0x225ec88)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) GT/SQL/Base/count called at GT/SQL/Base/total line 292 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (GT/SQL/Table=HASH(0x1a2a10c)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) GT/SQL/Base/total called at c:/work/cgi-bin/lsql/admin/Links/Build.pm line 985 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (GT/SQL/Table=HASH(0x1a2a10c)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) Links/Build/_grand_total called at Links/Build/build_home line 6 with no arguments.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) Links/Build/build_home called at c:/work/cgi-bin/lsql/admin/GT/Plugins.pm line 108 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (HASH(0x1a2e810)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) GT/Plugins/dispatch called at c:/work/cgi-bin/lsql/admin/Links/Build.pm line 30 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (GT/Plugins, c:/work/cgi-bin/lsql/admin/Plugins, build_home, *Links/Build/build_home, HASH(0x1a2e810)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) Links/Build/build called at c:/work/cgi-bin/lsql/admin/Links/User/Page.pm line 77 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (home, HASH(0x1a2e810)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) Links/User/Page/generate_home_page called at c:/work/cgi-bin/lsql/admin/Links/User/Page.pm line 53 with no arguments.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) Links/User/Page/handle called at c:/work/cgi-bin/lsql/admin/GT/Plugins.pm line 108 with no arguments.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) GT/Plugins/dispatch called at c:\work\cgi-bin\lsql\page.cgi line 25 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (GT/Plugins, c:/work/cgi-bin/lsql/admin/Plugins, handle_page, CODE(0x1ae2394)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1]
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Driver/MYSQL (340) Using stored connection DBI:mysql:links:localhost at c:/work/cgi-bin/lsql/admin/GT/SQL/Driver.pm line 77.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] Links/Link (340) Query:
-------------------------------------
The text above is the full error result. Not truncated.
BTW: I had to replace all :: to /, and all :space to space, because it seems the : hangs the GT Forum, when I click to Preview Post button! GT should investigate this GForum bug...

Report 2nd is about debug level 1 problem:
Quote:
When I set debug level 1, and use the 'build_directory_field' option, and call page.cgi?d=1, the perl.exe hangs.
Using Debug level 0, everything works fine, no perl hangups.
Later, when I kill the hanged perl.exe, error 500 is displayed in the browser.
This bug is replicable for me.

Paul, let me know, if you do these 2 cases with brand new LSQL v2.1.2 install, what result do you get?
Could you try with an LSQL v2.1.1 install, too?

If you need more info, let me know.

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...
Subject Author Views Date
Thread Debug Hanging webmaster33 4593 Mar 19, 2003, 6:04 PM
Thread Re: [webmaster33] can't loop for over 16 times when debug_level set to 1 		Paul 4369 Mar 20, 2003, 1:36 AM
Thread Re: [Paul] can't loop for over 16 times when debug_level set to 1 		webmaster33 4378 Mar 20, 2003, 4:56 AM
Thread Re: [webmaster33] can't loop for over 16 times when debug_level set to 1 		Paul 4372 Mar 20, 2003, 5:00 AM
Thread Re: [Paul] can't loop for over 16 times when debug_level set to 1 		webmaster33 4365 Mar 20, 2003, 6:08 AM
Thread Re: [webmaster33] can't loop for over 16 times when debug_level set to 1 		Paul 4359 Mar 20, 2003, 6:27 AM
Post Re: [Paul] Debug Hanging 		webmaster33 4377 Mar 20, 2003, 6:54 AM
Post Re: [webmaster33] can't loop for over 16 times when debug_level set to 1 		Paul 4353 Mar 20, 2003, 6:34 AM
Thread Re: [webmaster33] can't loop for over 16 times when debug_level set to 1 		Paul 4343 Mar 20, 2003, 6:39 AM
Thread Re: [Paul] Debug Hanging 		webmaster33 4338 Mar 20, 2003, 6:58 AM
Thread Re: [webmaster33] can't loop for over 16 times when debug_level set to 1 		Paul 4329 Mar 20, 2003, 7:00 AM
Thread Re: [Paul] Debug Hanging 		webmaster33 4337 Mar 20, 2003, 10:58 AM
Thread Re: [webmaster33] Debug Hanging 		Paul 4302 Mar 20, 2003, 11:18 AM
Post Re: [Paul] Debug Hanging 		webmaster33 4315 Mar 23, 2003, 4:41 PM
Post Re: [Paul] Debug Hanging 		webmaster33 4331 Mar 23, 2003, 2:10 PM