Red Gate forums :: View topic - Generator causing a SQL deadlock
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

Generator causing a SQL deadlock

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
bostonaudi



Joined: 30 Jun 2009
Posts: 3

PostPosted: Tue Jun 30, 2009 3:56 pm    Post subject: Generator causing a SQL deadlock Reply with quote

Hey all, I'm getting a deadlock with a table I'm trying to populate. Up to 15,000 rows its fine, as I try to go to 20,000 (adding 5,000 more rows) I'm gettting a deadlock from SQL Data Generator between the bulk copy and the query to find data for a column based on a foreign key where its trying to figure out what values haven't been used yet (using Repeat Keys at random). If I add a row or two it works. Suggestions? I've tried disabling triggers on the target table but they aren't involved with this lock.

The blocker (generated by Data Generator):
SELECT tlb0.[ID]
FROM [dbo].[RECORDS] AS tlb0
LEFT OUTER JOIN [dbo].[SOLICITOR_GOAL] AS ExistingRows
ON ExistingRows.[RECORDS_ID] = tlb0.[ID]
WHERE ExistingRows.[ID] IS NULL
ORDER BY tlb0.[ID]

The blockee:
insert bulk [dbo].[SOLICITOR_GOAL] ([RECORDS_ID] Int, [CAMPAIGN_ID] Int, [FUND_ID] Int, [TYPE] Int, [CATEGORY] Int, [GOAL] Decimal(30,6), [TEAM_ID] Int, [REPORTS_TO_ID] Int, [NOTES] Text COLLATE SQL_Latin1_General_CP1_CI_AS, [SEQUENCE] Int, [IMPORT_ID] VarChar(20) COLLATE SQL_Latin1_General_CP1_CI_AS, [Depth] Int, [Lineage] VarChar(255) COLLATE SQL_Latin1_General_CP1_CI_AS, [APPEAL_ID] Int) with (KEEP_NULLS, CHECK_CONSTRAINTS, FIRE_TRIGGERS)
Back to top
View user's profile Send private message Yahoo Messenger
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Tue Jul 07, 2009 11:22 am    Post subject: Reply with quote

Please can you run the generation again, select the small SQL Data Generator icon in the top left-hand corner of the screen, Locate temporary files and Log file and send across the text files from those locations (by default C:\Documents and Settings\user.name\Local Settings\Temp\Red Gate\SDG). If possible, please also send across your object creation SQL and your SQL Data Generator project file.

Please quote this forum post in your mail.
Back to top
View user's profile Send private message
bostonaudi



Joined: 30 Jun 2009
Posts: 3

PostPosted: Wed Jul 15, 2009 7:02 pm    Post subject: Re: Reply with quote

Linda Hawksworth wrote:
Please can you run the generation again, select the small SQL Data Generator icon in the top left-hand corner of the screen, Locate temporary files and Log file and send across the text files from those locations (by default C:\Documents and Settings\user.name\Local Settings\Temp\Red Gate\SDG). If possible, please also send across your object creation SQL and your SQL Data Generator project file.

Please quote this forum post in your mail.


Just got back from vacation, and my trial expired. Can I renew the trial? If I can get the tool to work I will purchase a copy.

thanks, John
Back to top
View user's profile Send private message Yahoo Messenger
bostonaudi



Joined: 30 Jun 2009
Posts: 3

PostPosted: Wed Jul 15, 2009 8:25 pm    Post subject: Re: Reply with quote

bostonaudi wrote:
Linda Hawksworth wrote:
Please can you run the generation again, select the small SQL Data Generator icon in the top left-hand corner of the screen, Locate temporary files and Log file and send across the text files from those locations (by default C:\Documents and Settings\user.name\Local Settings\Temp\Red Gate\SDG). If possible, please also send across your object creation SQL and your SQL Data Generator project file.

Please quote this forum post in your mail.


Just got back from vacation, and my trial expired. Can I renew the trial? If I can get the tool to work I will purchase a copy.

thanks, John


May have found the cause, the database I was using is a demo database and has a record count restriction of 15,000, which may have manifested this error. Investigating further.
Back to top
View user's profile Send private message Yahoo Messenger
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group