C3W3 Assignment 3 - Advanced SQL Queries - Experience the problem with the notebook

I am experiencing the following problem while trying to run SQL commands in the notebook.

Hi. First, download your current notebook as back up. Then, please use the restore original version feature on the upper right.

restoreorig3

This should reset your workspace and get you a blank notebook. Try modifying that new notebook and see if the error persists. Let us know how it goes. Thank you.

On another note, there’s another error when setting up the SQL connection. Will look into this and push a fix asap. Thank you for reporting!

i face db connection error too

Traceback (most recent call last):
File “/usr/local/lib/python3.10/site-packages/pymysql/connections.py”, line 644, in connect
sock = socket.create_connection(
File “/usr/local/lib/python3.10/socket.py”, line 857, in create_connection
raise err
File “/usr/local/lib/python3.10/socket.py”, line 845, in create_connection
sock.connect(sa)
ConnectionRefusedError: [Errno 111] Connection refused

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File “/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py”, line 145, in _init_
self._dbapi_connection = engine.raw_connection()
File “/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py”, line 3293, in raw_connection
return self.pool.connect()
File “/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py”, line 452, in connect
return _ConnectionFairy._checkout(self)
File “/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py”, line 1269, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File “/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py”, line 716, in checkout
rec = pool._do_get()
File “/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/impl.py”, line 169, in _do_get
with util.safe_reraise():
File “/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py”, line 146, in _exit_

…

Connection info needed in SQLAlchemy format, example:
postgresql://username:password@hostname/dbname
or an existing connection: dict_keys([])

I also have the similar issue.

After restoring original version the first issue was gone but SQL connection error is still present.

Hi everyone! This is a known issue and will push a fix by Monday (if not sooner). In the meantime, please proceed first to the next course to continue your progress. Will post here as soon as the problem is fixed. Thank you!

Hi everyone. Unfortunately, this is still in progress. Will try to push a fix by tomorrow end of day.

Hello again. The issue is now fixed! Please retry the lab and check if the sql connection runs successfully now. Thank you!