Subject | Re: [firebird-python] Huge Firebird memory usage using FDB |
---|---|
Author | Philippe Makowski |
Post date | 2013-05-02T11:26:47Z |
Pavel,
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
>FDB tests have problem on 2.5 on the automated build system
> 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
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