Re: Tracker stopped accepting new issues from the web GUI

The problem went away without further action on my part. There were other
issues in the environment where this runs, particularly some reboots and
DNS outages, but none that SHOULD have had an impact. This remains a
mystery for the time being.

I appreciate all the good ideas for troubleshooting.

Cheers! 
-- 
David Hancock | [email protected]

-----Original Message-----

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

>
>In message <[email protected]>,
>"Hancock, David (DHANCOCK)" writes:
>
>>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.
>
>Can you check your auditors and see if one of them could be failing? I
>would expect a syntax error or explicit failure should result in a
>traceback or message to the user but... Maybe add a simple auditor
>that runs on create and is the first auditor to run (I think the order
>is determined by the optional setting of 'priority=<some number>' when
>calling db.issue.audit. Default priority is 100. I am not sure if 1 or
>1000 makes the auditor run first though).  I thought there was a debug
>auditor that just dumped the changed values somewhere but I can't seem
>to find it now.
>
>If the auditor fires ok, move it along the chain so it runs:
>
>   before all auditors
>
>if it works there, rename it to run:
>
>  after all auditors
>
>if it breaks after, rename it run in the middle of the auditor chain
>till you identify the auditor that is breaking things.
>
>If it works fine when run as the last auditor, create a test reactor
>and if it runs ok then we know the failure is past that point in the
>chain.
>
>Also you say you get a blank screen displayed for /support/issue, if
>you look at the source for that web page (show source) in the browser
>what does it show? No content? Broken html?
>
>If you list all issues, you don't see any new issue being created.
>
>>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.
>
>Yeah I took a fast look through the roundup code and I see a couple of
>calls to rollback() but I am not sure if they are being called or if
>psycopg is executing the rollback on some other error. Since the
>postgres logs don't show any errors (or at least the part you shared
>doesn't show an error) I am guessing that the rollback is caused by
>some failure further up the food chain.
>
>If built with debugging, psycopg can have it's debugging enabled using:
>
>   export PSYCOPG_DEBUG=1
>
>in the environment of the roundup process but I don't think that is
>going to be fruitful at this point.
>
>>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.
>
>Are any of the templates in TRACKER_HOME/html (or indeed any of
>the files under TRACKER_HOME) recently modified?
>
>I am AFK for the rest of the evening. Maybe one of the other members
>on the list will have some ideas.
>
>--
>				-- 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