New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Regression [PYFB45] #35
Comments
Modified by: @pmakowskidescription: Crash during Firebird test suite My last attempt with classic show the crash during test about CORE2307 No problem with FDB at rev 59844 More info on Firebird devel list and logs at http://ci.ibphoenix.com => Crash during Firebird test suite My last attempt with Superserver show the crash during test about CORE2307 No problem with FDB at rev 59844 More info on Firebird devel list and logs at http://ci.ibphoenix.com |
Modified by: @pmakowskidescription: Crash during Firebird test suite My last attempt with Superserver show the crash during test about CORE2307 No problem with FDB at rev 59844 More info on Firebird devel list and logs at http://ci.ibphoenix.com => Crash during Firebird test suite My last attempt with Superserver show the crash during test about CORE2307 No problem with FDB at rev 59844 More info on Firebird devel list and logs at http://ci.ibphoenix.com the test about CORE2307 is : - create a database set term ^ ; EXECUTE BLOCK AS After that the python script is doing : import fdb db_conn = fdb.connect( sql = """EXECUTE BLOCK AS The test about functional.monitoring.04 is a connection to a database with SYSDBA and with another user : import fdb con_1 = fdb.connect( |
Submitted by: @pmakowski
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 CORE2307
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 http://ci.ibphoenix.com
the test about CORE2307 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())
The text was updated successfully, but these errors were encountered: