websocket_close_error

Question

Hi all,

we are having a problem with running scripts in the Synapse notebook. It is throwing the following error:

Your notebook connection has closed unexpectedly. To re-establish the connection, run the notebook again. Diagnostic information: websocket_close_error (k9dm3)

We are simply running a test code:

%%pyspark
new_rows = [('CA',22,45000),('WA',35,65000),('WA',20,200000)]
demo_df = spark.createDataFrame(new_rows,['State','age','salary'])
demo_df.createOrReplaceTempView(demo_df)

Any help would be appreciated.

Answer 1

Hello @Bek Abdul ,

Thanks for the question and using MS Q&A platform.

If your query fails with the error message: 'Websocket connection was closed unexpectedly', it means that your browser connection to Synapse Studio was interrupted, for example because of a network issue.

To resolve this issue, rerun this query. If this message occurs often in your environment, advise help from your network administrator, check firewall settings, and visit this troubleshooting guide for more information.

• If the issue still continues, try Azure Data Studio or SQL Server Management Studio for the same queries instead of Synapse Studio for further investigation.
• If the issue still continues, create a support ticket through the Azure portal .

For more details, refer to Azure Synapse - Self-help for serverless SQL pool.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators