web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Connection type 'C...
Microsoft Dynamics AX (Archived)

Connection type 'CLIENT EXTRA - read-only' in SQL statement trace log

(0) ShareShare
ReportReport
Posted on by Francesco 524

I am troubleshooting a deadlock issue that occurred earlier. When examining the SQL trace log, I notice that at the exact time the problem starts all excessive queries have a connection type of 'CLIENT EXTRA - read-only'.

Never before was this connection type logged and I can't find any documentation on it. My best guess is that these are stored procedure calls (all related to number sequences), and that they never showed before because they don't normally pass the performance trhreshold. However, I'd like to eliminate the guesswork, so I was curious if anybody can shed some light on this mystery connection type.

*This post is locked for comments

I have the same question (0)
  • Dick Wenning Profile Picture
    Dick Wenning 8,705 Moderator on at
    RE: Connection type 'CLIENT EXTRA - read-only' in SQL statement trace log

    please tell me more, where do you see the deadlock?

  • Francesco Profile Picture
    Francesco 524 on at
    RE: Connection type 'CLIENT EXTRA - read-only' in SQL statement trace log

    In SQL Server on this query (it just happened again)

    (@P1 int,@P2 bigint,@P3 int,@P4 datetime2,@P5 nvarchar(9),@P6 bigint,@P7 bigint)UPDATE NUMBERSEQUENCELIST SET STATUS=@P1,TRANSID=@P2,RECVERSION=@P3,MODIFIEDDATETIME=@P4,MODIFIEDBY=@P5,MODIFIEDTRANSACTIONID=@P6 WHERE (RECID=@P7)

  • Dick Wenning Profile Picture
    Dick Wenning 8,705 Moderator on at
    RE: Connection type 'CLIENT EXTRA - read-only' in SQL statement trace log

    - do you have numbsersequences on continue, and did they do a clean up at that time?

    - also use traceparser on the AOS, this will tell you the table an related calls (stack trace)

    - do users experience anything wrong?

  • Francesco Profile Picture
    Francesco 524 on at
    RE: Connection type 'CLIENT EXTRA - read-only' in SQL statement trace log

    Yes, I have the stack, and I'm sure the user is experiencing an error (my bet is on unbalanced TTS), but my question is about the connection type, not so much about the lock :)

  • Dick Wenning Profile Picture
    Dick Wenning 8,705 Moderator on at
    RE: Connection type 'CLIENT EXTRA - read-only' in SQL statement trace log

    you get the lock that you deserve :-(

    is read committed snapshot active?

    please show me the stack

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans