Azure / Azure/elastic-db-tools

No error message shown when Trying to add a Shard to the same DB as the Shard Map Manager

Open
#55 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
147
Forks
108
PR merge metrics
No merged PRs in 30d

Description

Repro Steps:
- Create a DB
- Add a Shard Map Manager
- Add a Shard

Actual: API Call will be hung for sometime, and then throw a timeout exception.
Expected: This was a design decision to not have Shard Map Manager and Shard co-located on the same DB. The exception thrown should reflect that this is not allowed. Else the user assumes that it is a DB issue, when it is a config issue.

select \* from sys.sysprocesses

spid kpid blocked waittype waittime lastwaittype waitresource dbid uid cpu physical_io memusage login_time last_batch ecid open_tran status sid hostname program_name hostprocess cmd nt_domain nt_username net_address net_library loginame context_info sql_handle stmt_start stmt_end request_id

56 0 0 0x0000 0 MISCELLANEOUS 11 1 0 0 3 2015-06-23 23:05:50.250 2015-06-23 23:05:50.247 0 0 sleeping 0x01060000000001640000000000000000F300E9F727F4214E9A3A105D6FAC7EDE000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 SDOOMRAMAIN ESC_SKv1.0ESC_SMMv1.0.0.1_GSM 11912 AWAITING COMMAND BDD715638B94 TCP/IP sdoomra 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0300FF7FBB63B9F6E96F7B019FA4000001000000 -1 -1 0

58 -31072 56 0x0005 9325 LCK_M_X APP: 11:0:[82fef64b-e16a-4833-bab7-02fbe9ae]:(8f46e7d7) 11 1 0 0 4 2015-06-23 23:05:50.313 2015-06-23 23:05:50.313 0 0 suspended 0x01060000000001640000000000000000F300E9F727F4214E9A3A105D6FAC7EDE000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 SDOOMRAMAIN ESC_SKv1.0ESC_SMMv1.0.0.1_LSM 11912 EXECUTE BDD715638B94 TCP/IP sdoomra 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0400FF7F8ED587D8010000000000000000000000 -1 -1 0

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.