Subject Re: [firebird-python] Huge Firebird memory usage using FDB
Author Philippe Makowski
Pavel,
>
> I never tested FDB with 3.0, so it may fail. Strange it fails with
> fbtest on 2.5, as it passed all FDB tests on 2.5
FDB tests have problem on 2.5 on the automated build system
and this, only after your last commit about PYFB-34

+ nosetests --with-xunit --verbose --exclude=test_limbo_transactions
test_basic (testfdb.TestArrays) ... ok
test_read_full (testfdb.TestArrays) ... ok
test_write_full (testfdb.TestArrays) ... ok
test_write_wrong (testfdb.TestArrays) ... ok
test_pyfb_17 (testfdb.TestBugs) ... ok
test_pyfb_22 (testfdb.TestBugs) ... ok
test_pyfb_25 (testfdb.TestBugs) ... ok
test_pyfb_30 (testfdb.TestBugs) ... ok
testBlob (testfdb.TestCharsetConversion) ... ok
testCharVarchar (testfdb.TestCharsetConversion) ... ok
test_octets (testfdb.TestCharsetConversion) ... ok
test_utf82win1250 (testfdb.TestCharsetConversion) ... ok
test_connect (testfdb.TestConnection) ... ok
test_connect_role (testfdb.TestConnection) ... ok
test_database_info (testfdb.TestConnection) ... ok
test_db_info (testfdb.TestConnection) ... ok
test_execute_immediate (testfdb.TestConnection) ... ok
test_transaction (testfdb.TestConnection) ... ok
test_create_drop (testfdb.TestCreateDrop) ... ok
test_description (testfdb.TestCursor) ... ok
test_exec_after_close (testfdb.TestCursor) ... ok
test_fetchall (testfdb.TestCursor) ... ok
test_fetchallmap (testfdb.TestCursor) ... ok
test_fetchmany (testfdb.TestCursor) ... ok
test_fetchmanymap (testfdb.TestCursor) ... ok
test_fetchone (testfdb.TestCursor) ... ok
test_fetchonemap (testfdb.TestCursor) ... ok
test_iteration (testfdb.TestCursor) ... ok
test_name (testfdb.TestCursor) ... ok
test_pscache (testfdb.TestCursor) ... ok
test_rowcount (testfdb.TestCursor) ... ok
test_use_after_close (testfdb.TestCursor) ... ok
test_context_manager (testfdb.TestDistributedTransaction) ... ok
test_simple_dt (testfdb.TestDistributedTransaction) ... ok
test_20_events (testfdb.TestEvents) ... ok
test_flush_events (testfdb.TestEvents) ... ok
test_multiple_events (testfdb.TestEvents) ... ok
test_one_event (testfdb.TestEvents) ... ok
test_insert_blob (testfdb.TestInsertData) ... ok
test_insert_char_varchar (testfdb.TestInsertData) ... ok
test_insert_datetime (testfdb.TestInsertData) ... ok
test_insert_float_double (testfdb.TestInsertData) ... ok
test_insert_integers (testfdb.TestInsertData) ... ok
test_insert_numeric_decimal (testfdb.TestInsertData) ... ok
test_insert_returning (testfdb.TestInsertData) ... ok
test_basic (testfdb.TestPreparedStatement) ... ok
test_execution (testfdb.TestPreparedStatement) ... ok
test_get_plan (testfdb.TestPreparedStatement) ... ok
test_wrong_cursor (testfdb.TestPreparedStatement) ... ok
test_attach (testfdb.TestServices) ... ok
test_query (testfdb.TestServices) ... FAIL
test_running (testfdb.TestServices) ... ok
test_wait (testfdb.TestServices) ... ok
test_activateShadowFile (testfdb.TestServices2) ... ok
test_backup (testfdb.TestServices2) ... ok
test_getLimboTransactionIDs (testfdb.TestServices2) ... ok
test_getStatistics (testfdb.TestServices2) ... ok
test_getUsers (testfdb.TestServices2) ... ok
test_log (testfdb.TestServices2) ... ok
test_manage_user (testfdb.TestServices2) ... ok
test_nbackup (testfdb.TestServices2) ... ok
test_nrestore (testfdb.TestServices2) ... ok
test_repair (testfdb.TestServices2) ... ok
test_restore (testfdb.TestServices2) ... ERROR
test_setAccessMode (testfdb.TestServices2) ... ok
test_setDefaultPageBuffers (testfdb.TestServices2) ... ok
test_setSQLDialect (testfdb.TestServices2) ... ok
test_setShouldReservePageSpace (testfdb.TestServices2) ... ok
test_setSweepInterval (testfdb.TestServices2) ... ok
test_setWriteMode (testfdb.TestServices2) ... ok
test_shutdown_bringOnline (testfdb.TestServices2) ... ok
test_sweep (testfdb.TestServices2) ... ok
test_trace (testfdb.TestServices2) ... ok
test_callproc (testfdb.TestStoredProc) ... ok
testBlobBasic (testfdb.TestStreamBLOBs) ... ok
testBlobExtended (testfdb.TestStreamBLOBs) ... ok
test_context_manager (testfdb.TestTransaction) ... ok
test_cursor (testfdb.TestTransaction) ... ok
test_fetch_after_commit (testfdb.TestTransaction) ... ok
test_fetch_after_rollback (testfdb.TestTransaction) ... ok
test_savepoint (testfdb.TestTransaction) ... ok
test_tpb (testfdb.TestTransaction) ... ok
test_transaction_info (testfdb.TestTransaction) ... ok

======================================================================
ERROR: test_restore (testfdb.TestServices2)
----------------------------------------------------------------------
Traceback (most recent call last):
File "/home/vagrant/fdb/test/testfdb.py", line 1214, in test_restore
report = self.svc.readlines()
File "/home/vagrant/fdb/fdb/services.py", line 546, in readlines
return [line for line in self]
File "/home/vagrant/fdb/fdb/services.py", line 266, in next
line = self.readline()
File "/home/vagrant/fdb/fdb/services.py", line 537, in readline
return self.__fetchline()
File "/home/vagrant/fdb/fdb/services.py", line 307, in __fetchline
self.__read_buffer()
File "/home/vagrant/fdb/fdb/services.py", line 292, in __read_buffer
"Services/isc_service_query:")
DatabaseError: ('Services/isc_service_query:\n- SQLCODE: -901\n- could
not drop database /home/vagrant/fdb/test/test_employee.fdb (database
might be in use)', -901, 336330985)

======================================================================
FAIL: test_query (testfdb.TestServices)
----------------------------------------------------------------------
Traceback (most recent call last):
File "/home/vagrant/fdb/test/testfdb.py", line 1074, in test_query
assert len(x) == 2
AssertionError

----------------------------------------------------------------------
XML: nosetests.xml
----------------------------------------------------------------------
Ran 83 tests in 20.632s

FAILED (errors=1, failures=1)
Exception fdb.fbcore.DatabaseError: DatabaseError('Error while closing
SQL statement:\n- SQLCODE: -901\n- invalid statement handle', -901,
335544485) in <bound method Cursor.__del__ of <fdb.fbcore.Cursor object
at 0x2ad2f50>> ignored
Exception fdb.fbcore.DatabaseError: DatabaseError('Error while closing
SQL statement:\n- SQLCODE: -901\n- invalid statement handle', -901,
335544485) in <bound method Cursor.__del__ of <fdb.fbcore.Cursor object
at 0x2ad2c10>> ignored
Exception fdb.fbcore.DatabaseError: DatabaseError('Error while closing
SQL statement:\n- SQLCODE: -901\n- invalid statement handle', -901,
335544485) in <bound method Cursor.__del__ of <fdb.fbcore.Cursor object
at 0x2ad28d0>> ignored
Exception fdb.fbcore.DatabaseError: DatabaseError('Error while closing
SQL statement:\n- SQLCODE: -901\n- invalid statement handle', -901,
335544485) in <bound method Cursor.__del__ of <fdb.fbcore.Cursor object
at 0x2ad2810>> ignored
Exception fdb.fbcore.DatabaseError: DatabaseError('Error while closing
SQL statement:\n- SQLCODE: -901\n- invalid statement handle', -901,
335544485) in <bound method Cursor.__del__ of <fdb.fbcore.Cursor object
at 0x2cde1d0>> ignored