Blocking when deleting from tables

The simplest way to populate your database with test data.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr

Blocking when deleting from tables

Postby JimboJet » Wed Oct 03, 2012 5:26 pm

Hi All,

Has anyone experienced blocking when SDG deletes from tables before a load?

I'm using sp_who2 to investigate and the DELETE SPID is being blocked by a SELECT SPID. When I KILL the SPID doing the blocking SDG is then blocked by another SELECT SPID, and so on..

N.B. the SPIDs are SDG SPIDs...

The only way to get out is to KILL the DELETE SPID and restart the program.

This doesn't happen every time I use SDG, probably 7 out of every 10 times?

Any help, much appreciated..

Cheers,

Jim.
JimboJet
 
Posts: 5
Joined: Mon Oct 01, 2012 11:52 am
Location: Leeds, England

Postby Manfred.Castro » Thu Oct 04, 2012 6:45 pm

Sorry you are experiencing this.
We are aware of this issue and it has been assigned the internal reference number of SDG-1008.
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Postby JimboJet » Fri Oct 12, 2012 12:36 pm

There is a work around for this issue.

Before generating data, save your project and then refresh the schema.
JimboJet
 
Posts: 5
Joined: Mon Oct 01, 2012 11:52 am
Location: Leeds, England

Postby beyond » Thu Nov 08, 2012 6:18 pm

I am also experiencing the same issue, very annoying.

It looks like the tool leaves open transactions against the server, reading from the table(s) we are trying to populate.

I look forward to a fix coming out soon!
You always have a choice
beyond
 
Posts: 2
Joined: Tue May 22, 2012 9:22 am

Re:

Postby JimboJet » Fri Nov 09, 2012 9:23 am

beyond wrote:I am also experiencing the same issue, very annoying.

It looks like the tool leaves open transactions against the server, reading from the table(s) we are trying to populate.

I look forward to a fix coming out soon!


Just make sure you hit 'Save' and 'Refresh Schema' before you run your generation plan after you've made any changes and this seems to drop the offending transactions.
JimboJet
 
Posts: 5
Joined: Mon Oct 01, 2012 11:52 am
Location: Leeds, England


Return to SQL Data Generator 2

Who is online

Users browsing this forum: No registered users and 0 guests