Foxhound 2.0 FAQ
Foxhound 2.0 FAQ Home      Foxhound Home      RisingRoad           Breck.Carter@gmail.com     


Message: An attempt to start sample loop event ... for sampling id ... failed because event ... was already running for that sampling id.

Explanation:

This is an unexpected error, possibly caused by an internal error in Foxhound.

Please report this error; see How do I report unexpected errors and exceptions?

If possible, include the diagnostic message and associated dump; here is an example:

1. Use the Foxhound Options - 8. Diagnostics - Display Diagnostics button to find the exception id, 477 in this case:

 477 - 2012-07-26 06:56:37.407 Full Build 4173a 1000001557 203a3d3(203eh1) An attempt to start sample loop event 1000001557 for sampling id 4 failed because event 1000000020 was already running for that sampling id. [4-Foxhound_on_old_Dell_XP]

2. Run adhoc queries to see the diagnostic message and the associated dump (see How do I run adhoc queries on the Foxhound database?):

SELECT * FROM exception_diagnostic WHERE exception_id = 477;
SELECT * FROM exception_dump       WHERE exception_id = 477;

exception_id,exception_diagnostic
477,2012-07-26 06:56:37.407 Full Build 4173a 1000001557 203a3d3(203eh1) An attempt to start sample loop event 1000001557 for sampling id 4 failed because event 1000000020 was already running for that sampling id. [4-Foxhound_on_old_Dell_XP]
SELECT * FROM exception_dump WHERE exception_id = 477;

exception_id,dump_id,dump_inserted_at,dump
477,1,'2012-07-26 06:56:37.409','rroad_sampling_options','203a3d3','(203eh1)',4,'1','Foxhound_on_old_Dell_XP','Foxhound_on_old_Dell_XP','',,,,'Y','N',2012-07-23 12:09:23.973,'OK',1000000020,'','Y','',0,4,2012-07-26 06:56:36.070,2012-07-26 06:56:36.070,2012-07-26 06:56:26.026,2012-07-26 06:56:26.030,'12.0.1.3298','12.0.1.3298','p001',8192,'N','N','N','DBA','',2147483647,'Conn #','ASC',0,'',''\x0d\x0a

3. Run adhoc queries to copy the diagnostic message and associate dump to a single text file:

UNLOAD SELECT * FROM exception_diagnostic WHERE exception_id = 477 TO 'c:/temp/foxhound_exception.txt';
UNLOAD SELECT * FROM exception_dump       WHERE exception_id = 477 TO 'c:/temp/foxhound_exception.txt' APPEND ON;

477,'2012-07-26 06:56:37.407 Full Build 4173a 1000001557 203a3d3(203eh1) An attempt to start sample loop event 1000001557 for sampling id 4 failed because event 1000000020 was already running for that sampling id. [4-Foxhound_on_old_Dell_XP]'
477,1,2012-07-26 06:56:37.409,'''rroad_sampling_options'',''203a3d3'',''(203eh1)'',4,''1'',''Foxhound_on_old_Dell_XP'',''Foxhound_on_old_Dell_XP'','''',,,,''Y'',''N'',2012-07-23 12:09:23.973,''OK'',1000000020,'''',''Y'','''',0,4,2012-07-26 06:56:36.070,2012-07-26 06:56:36.070,2012-07-26 06:56:26.026,2012-07-26 06:56:26.030,''12.0.1.3298'',''12.0.1.3298'',''p001'',8192,''N'',''N'',''N'',''DBA'','''',2147483647,''Conn #'',''ASC'',0,'''',''''\x0d\x0a'

See also...
How do I report unexpected errors and exceptions?
How do I run adhoc queries on the Foxhound database?
How do I see the schema for adhoc reporting?


This page was last updated on October 30, 2012. Foxhound 2.0 FAQ Home      Foxhound Home      RisingRoad      Breck.Carter@gmail.com