search

zzzprojects / Bulk-Operations

C# SQL Bulk Operations | High-performance C# bulk insert, update, delete and merge for SQL Server, SQL Azure, SQL Compact, MySQL, and SQLite.
https://bulk-operations.net
142 stars 34 forks source link

Bulk insert never ends #18

Closed observer1 closed 6 years ago

observer1 commented 6 years ago

Hi Can you help us with this issue? We developed an application that copies data between 2 servers using a datareader and when we tried in a testing environment the bulk insert never ends. Is there some known issue or a hint to this?

Thanks for your help

JonathanMagnan commented 6 years ago

Hello @observer1 ,

No, there is no known issue like this one.

I suspect there is something that's currently blocking the bulk operations.

Best Regards,

Jonathan

observer1 commented 6 years ago

It hangs even with one row I changed the batchsize to 10 and it hangs on 10

I'll try to see what can block this, but I have no clue where to search, I'm not so good on sql server

2018-01-11 17:33 GMT-06:00 Jonathan Magnan notifications@github.com:

Hello @observer1 https://github.com/observer1 ,

No, there is no known issue like this one.

I suspect there is something that's currently blocking the bulk operations.

  • Could you try in your testing environment to copy only a small amount of row and increase it this amount if that works?
  • Could you try to check if something might block the current bulk operations?

Best Regards,

Jonathan

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/zzzprojects/Bulk-Operations/issues/18#issuecomment-357096255, or mute the thread https://github.com/notifications/unsubscribe-auth/AKpYwFaxHUSwKISO3H1oORK04Fnvrg5bks5tJpozgaJpZM4RbkaW .

JonathanMagnan commented 6 years ago

Do you think you could provide us a project or something that we could investigate?

So far, your problem doesn't look related to our library but if we have a simple project that we could check, we will be happy to take some time on it.

You can send it here: info@zzzprojects.com

Best Regards,

Jonathan

observer1 commented 6 years ago

It was a permissions thing I supposed this would rise an exception... Thanks for your help I'm closing now

JonathanMagnan commented 6 years ago

Hello @observer1 ,

Thank you for letting us known.

Yes, that's weird that no exception was thrown.

Best Regards,

Jonathan