Re: Tracker stopped accepting new issues from the web GUI

Thank you for the ideas. I turned the logging level to DEBUG (that's a LOT
of output), but didn't
see any obvious problems there.

I am the tracker administrator, and I'm not getting any emails for this
problem. I turned on web:debug and don't get a traceback in the browser
when I encounter the white screen upon submission. It all seems quite
normal from the web-user perspective, except the redirect after submission
is to /support/issue instead of /support/issue/NNNNN.

I have appended some Postgres logging (also turned up as high as
possible). I do see a ROLLBACK at the end of the queries, but I'm still
trying to figure out how to determine which of the previous statement
might have been the cause.

The database behind this tracker was upgraded from Postgres 8.3 to 9.1
several weeks ago, but there have been hundreds of issues created since
that time.

Thanks again for any ideas you might have.

Cheers! 
-- 
David Hancock | [email protected]


2013-01-27 21:08:57 GMT:127.0.0.1(57416):roundup@roundup:[25660]LOG:
duration: 0.244 ms  statement: insert into status__journal
(nodeid,date,tag,action,params) values (E'1',E'2013-01-27
21:08:57.736',E'10',E'link',E'(''issue'', ''35176'', ''status'')')

2013-01-27 21:08:57 GMT:127.0.0.1(57416):roundup@roundup:[25660]LOG:
duration: 0.380 ms  statement: select count(*) from _custcomp where
id=E'57'

2013-01-27 21:08:57 GMT:127.0.0.1(57416):roundup@roundup:[25660]LOG:
duration: 0.247 ms  statement: insert into custcomp__journal
(nodeid,date,tag,action,params) values (E'57',E'2013-01-27
21:08:57.737',E'10',E'link',E'(''issue'', ''35176'', ''custcomp'')')

2013-01-27 21:08:57 GMT:127.0.0.1(57416):roundup@roundup:[25660]LOG:
duration: 0.369 ms  statement: insert into _issue
(_activity,_actor,_browserversion,_bugnumbers,_causes,_contactinfo,_creatio
n,_creator,_custcomp,_custname,_followup,_priority,_revisit,_status,_tailnu
m,_title,id) values (E'2013-01-27
21:08:57.738',10,NULL,NULL,NULL,E'[email protected]',E'2013-01-27
21:08:57.738',10,57,E'David Hancock',1,2,NULL,1,E'ANY',E'Test Feedback,
please ignore',E'35176')

2013-01-27 21:08:57 GMT:127.0.0.1(57416):roundup@roundup:[25660]LOG:
duration: 0.236 ms  statement: insert into issue__journal
(nodeid,date,tag,action,params) values (E'35176',E'2013-01-27
21:08:57.739',E'10',E'create',E'{}')

2013-01-27 21:08:57 GMT:127.0.0.1(57416):roundup@roundup:[25660]LOG:
duration: 0.512 ms  statement: select_activity,_a
ctor,_browserversion,_bugnumbers,_causes,_contactinfo,_creation,_creator,_c
ustcomp,_custname,_followup,_priority,_revisit,_status,_tailnum,_title
from _issue where id=E'35176'

2013-01-27 21:08:57 GMT:127.0.0.1(57416):roundup@roundup:[25660]LOG:
duration: 0.249 ms  statement: select linkid from issue_messages where
nodeid=E'35176'

2013-01-27 21:08:57 GMT:127.0.0.1(57416):roundup@roundup:[25660]LOG:
duration: 0.153 ms  statement: select_activity,_a
ctor,_creation,_creator,_name,_order from _priority where id=E'2'

2013-01-27 21:08:57 GMT:127.0.0.1(57416):roundup@roundup:[25660]LOG:
duration: 0.141 ms  statement: select
_activity,_actor,_creation,_creator,_homebase,_name from _custcomp where
id=E'57'

2013-01-27 21:08:57 GMT:127.0.0.1(57416):roundup@roundup:[25660]LOG:
duration: 0.164 ms  statement: ROLLBACK

2013-01-27 21:08:57 GMT:127.0.0.1(57416):roundup@roundup:[25660]LOG:
disconnection: session time: 0:00:00.086 user=roundup database=roundup
host=127.0.0.1 port=57416






-----Original Message-----
From: "John P. Rouillard" <[email protected]>
Reply-To: "[email protected]" <[email protected]>
Date: Sunday, January 27, 2013 3:45 PM
To: David Hancock <[email protected]>
Cc: "[email protected]"
<[email protected]>, "Parangot, Reena M. (RMP)"
<[email protected]>
Subject: Re: [Roundup-users] Tracker stopped accepting new issues from the
web GUI 

>
>In message <[email protected]>,
>"Hancock, David (DHANCOCK)" writes:
>
>>This just started happening today: Creating new issues fails, but
>>updating =
>>issues is working fine. From the web page, submitting the new issue
>>yields =
>>a white page (no content at all) instead of the page with the new
>>issue's i=
>>nformation. The URL ends with just "/issue" rather than "issueNNNNN".
>>The i=
>>ssue is not getting saved in the database (_issue table). The initial
>>chang=
>>e note is getting into the correct directory under db/files/msg/NNN, but
>>ha=
>>s the form msgNNNNN.tmp.
>>
>>For IE users, they are seeing a popup screen saying "You have chosen to
>>ope=
>>n issue, which is a text/x-python (20 bytes)"; I'm using Chrome and get
>>the=
>> white page with URL: http://feedback.arincdirect.net/support/issue. If
>>I r=
>>eload that URL, I get an issue list.
>>
>>I've tried a number of things that did NOT work (restarted Apache,
>>restarte=
>>d Postgres, checked directory permissions, checked disk space,etc.). I'd
>>be=
>> grateful for idea on how to troubleshoot this further. This a a
>>critical t=
>>ool to our operation.
>
>Turn on debugging
>
>http://roundup.sourceforge.net/doc-1.0/customizing.html#id15
>
>at end of the page.
>
>the tracker admin email should be receiving the tracebacks.
>
>my guess is some template for issue display got corrupted
>and errors are being suppressed to the browser.
>
>--
>				-- rouilj
>John Rouillard
>==========================================================================
>=
>My employers don't acknowledge my existence much less my opinions.


------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d