Issue Details (XML | Word | Printable)

Key: PYFB-45
Type: Bug Bug
Status: Closed Closed
Resolution: Cannot Reproduce
Priority: Critical Critical
Assignee: Pavel Cisar
Reporter: Philippe Makowski
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird driver for Python

Regression

Created: 24/Nov/14 09:37 AM   Updated: 30/Aug/15 04:15 PM
Component/s: None
Affects Version/s: 1.4.3
Fix Version/s: None

Environment: Firebird QA test suite under Linux


 Description  « Hide
Crash during Firebird test suite
kernel: [ 724.669973] fbt_run[21560]: segfault at 0 ip (null) sp 00007fff305ac9f8 error 14 in python2.7

My last attempt with Superserver show the crash during test about http://tracker.firebirdsql.org/browse/CORE-2307
My other attempt with Classic show the crash during test about functional.monitoring.04

No problem with FDB at rev 59844

More info on Firebird devel list and logs at ci.ibphoenix.com

the test about CORE-2307 is :

- create a database
In the database :

set term ^ ;
EXECUTE BLOCK AS
DECLARE VARIABLE I INTEGER = 0;
BEGIN
  WHILE (I < 1000)
  DO
    BEGIN
      EXECUTE statement 'CREATE TABLE T' || cast(:I as varchar(5)) || ' (C INTEGER)';
      I = I + 1 ;
    END
END ^
commit ^

EXECUTE BLOCK AS
DECLARE VARIABLE I INTEGER = 0;
BEGIN
  WHILE (I < 1000)
  DO
    BEGIN
      EXECUTE statement 'INSERT INTO T' || cast(:I as varchar(5)) || ' (C) VALUES (1)';
      I = I + 1 ;
    END
END ^
commit ^

After that the python script is doing :

import fdb

db_conn = fdb.connect(
    host='localhost', database='/temp/test.db',
    user='sysdba', password='masterkey'
  )

sql = """EXECUTE BLOCK AS
DECLARE VARIABLE N VARCHAR(31);
DECLARE VARIABLE I INTEGER;
BEGIN
  FOR SELECT RDB$RELATION_NAME
    FROM RDB$RELATIONS
    INTO :N
    DO
    BEGIN
      EXECUTE statement 'SELECT FIRST 1 1 FROM ' || :N INTO :I;
    END
END"""
c = db_conn.cursor()
c.execute(sql)
print (db_conn.db_info(kdb.isc_info_read_seq_count))



The test about functional.monitoring.04 is a connection to a database with SYSDBA and with another user :

import fdb

con_1 = fdb.connect(
    host='localhost', database='/temp/test.db',
    user='sysdba', password='masterkey'
  )
con_1.begin()
c1 = con_1.cursor()
con_2 = fdb.connect(
    host='localhost', database='/temp/test.db',
    user='TEST', password='test'
  )
con_2.begin()
c2 = con_2.cursor()
c2.execute("SELECT TRIM(T2.MON$USER), T1.MON$ISOLATION_MODE FROM MON$TRANSACTIONS T1 JOIN MON$ATTACHMENTS T2 USING (MON$ATTACHMENT_ID) ORDER BY 1")
print (c2.fetchall())
c1.execute("SELECT TRIM(T2.MON$USER), T1.MON$ISOLATION_MODE FROM MON$TRANSACTIONS T1 JOIN MON$ATTACHMENTS T2 USING (MON$ATTACHMENT_ID) ORDER BY 1")
print (c1.fetchall())








 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.