how to deal with the errors how to raise or import or except them ??

[peternasser99]

def summary():
    try:
        with connection_pool.acquire() as connection:
            # Fetch all table names from the database
            cursor = connection.cursor()
            cursor.execute('SELECT * FROM user_tables')
            tables = cursor.fetchall()

            for table_name in tables[::-1]:
                print(f"Table: {table_name[0]}")
                print(f"Table: {table_name}")
                # Get the row count for the current table
                cursor.execute(f"SELECT COUNT(*) FROM {table_name[0]}")
                row_count = cursor.fetchone()[0]
                print(f"Row count: {row_count}")

                cursor.execute(f"SELECT * FROM {table_name[0]} WHERE ROWNUM <= 15")
                # cursor.execute(f"SELECT * FROM {table_name[0]} ORDER BY rowid DESC FETCH FIRST 15 ROWS ONLY")
                rows = cursor.fetchall()  # Fetch all 15 rows
                # rows = cursor.fetchmany(15)

                column_names = [desc[0] for desc in cursor.description]
                print("Columns: ", column_names)

                for row in rows:
                    print(row)

                # Get the size of the table
                cursor.execute(f"SELECT SUM(bytes) FROM user_segments WHERE segment_name = '{table_name[0]}'")
                table_size_bytes = cursor.fetchone()[0]

                if table_size_bytes is not None:
                    table_size_kb = table_size_bytes / 1024
                    table_size_mb = table_size_kb / 1024
                    print(f"Table size: {table_size_bytes} bytes / {table_size_kb:.2f} KB / {table_size_mb:.2f} MB")
                else:
                    print("Table size: Unknown")

                print("\n")
            cursor.close()
    except oracledb.Error :
        print("haha")

summary()

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

DatabaseError                             Traceback (most recent call last)

src/oracledb/impl/thin/connection.pyx in oracledb.thin_impl.ThinConnImpl.connect()

src/oracledb/impl/thin/connection.pyx in oracledb.thin_impl.ThinConnImpl._connect_with_params()

src/oracledb/impl/thin/connection.pyx in oracledb.thin_impl.ThinConnImpl._connect_with_description()

src/oracledb/impl/thin/connection.pyx in oracledb.thin_impl.ThinConnImpl._connect_with_address()

src/oracledb/impl/thin/protocol.pyx in oracledb.thin_impl.Protocol._connect_phase_two()

src/oracledb/impl/thin/protocol.pyx in oracledb.thin_impl.Protocol._process_message()

src/oracledb/impl/thin/protocol.pyx in oracledb.thin_impl.Protocol._process_message()

src/oracledb/impl/thin/protocol.pyx in oracledb.thin_impl.Protocol._receive_packet()

src/oracledb/impl/thin/packet.pyx in oracledb.thin_impl.ReadBuffer.receive_packet()

src/oracledb/impl/thin/packet.pyx in oracledb.thin_impl.ReadBuffer._receive_packet_helper()

src/oracledb/impl/thin/packet.pyx in oracledb.thin_impl.ReadBuffer._get_data_from_socket()

/usr/local/lib/python3.10/dist-packages/oracledb/errors.py in _raise_err(error_num, context_error_message, cause, **args)
    126     exc_type = ERR_EXCEPTION_TYPES[error_num // 1000]
--> 127     raise exc_type(_Error(message)) from cause
    128 

DatabaseError: DPY-4011: the database or network closed the connection


During handling of the above exception, another exception occurred:

OSError                                   Traceback (most recent call last)

5 frames

src/oracledb/impl/thin/pool.pyx in oracledb.thin_impl.ThinPoolImpl.acquire()

src/oracledb/impl/thin/pool.pyx in oracledb.thin_impl.ThinPoolImpl._acquire_helper()

src/oracledb/impl/thin/pool.pyx in oracledb.thin_impl.ThinPoolImpl._acquire_helper()

src/oracledb/impl/thin/pool.pyx in oracledb.thin_impl.ThinPoolImpl._acquire_helper.lambda2()

src/oracledb/impl/thin/pool.pyx in oracledb.thin_impl.ThinPoolImpl._get_connection()

src/oracledb/impl/thin/pool.pyx in oracledb.thin_impl.ThinPoolImpl._create_conn_impls_helper()

src/oracledb/impl/thin/pool.pyx in oracledb.thin_impl.ThinPoolImpl._create_conn_impl()

src/oracledb/impl/thin/connection.pyx in oracledb.thin_impl.ThinConnImpl.connect()

src/oracledb/impl/thin/connection.pyx in oracledb.thin_impl.ThinConnImpl._force_close()

src/oracledb/impl/thin/protocol.pyx in oracledb.thin_impl.Protocol._force_close()

/usr/lib/python3.10/ssl.py in shutdown(self, how)
   1311         self._checkClosed()
   1312         self._sslobj = None
-> 1313         super().shutdown(how)
   1314 
   1315     @_sslcopydoc

OSError: [Errno 9] Bad file descriptor

how to raise or import or except this error ??

[anthony-tuininga]

I'm not sure what you are trying to accomplish exactly. Can you clarify?

The error supplied suggests that you may have NNE enabled on your database. If so, you will need to enable thick mode. See the last item of the troubleshooting section for more information.

[peternasser99]

i am trying to catch the error
using a try except block

DatabaseError: DPY-4011: the database or network closed the connection
except oracledb.Error :

but the onlything working is excepting everything

try:
except:

• any clarification on by passing this error i would be gratefull
  NNE enabled on your database what is that

and how to enable thick mode

#this is my connection_pool
def get_connection_pool():
    return oracledb.create_pool(user=un, password=pw, dsn="db2_high", port = port, config_dir=lo, wallet_location=lo, wallet_password=pw,
                                min=10, max=20, increment=1, timeout=60,
                                max_lifetime_session = 5,
                                        )

[cjbj]

• NNE is discussed in the troubleshooting link that @anthony-tuininga gave
• Enabling thick mode is discussed in the section on NNE too.