Skip to content
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

Closed
firebird-automations opened this issue Nov 24, 2014 · 3 comments
Closed

Regression [PYFB45] #35

firebird-automations opened this issue Nov 24, 2014 · 3 comments

Comments

@firebird-automations
Copy link

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())

@firebird-automations
Copy link
Author

Modified by: @pmakowski

description: 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 classic show the crash during test about CORE2307
My other attempt with Superserver 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

=>

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

@firebird-automations
Copy link
Author

Modified by: @pmakowski

description: 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

=>

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())

@firebird-automations
Copy link
Author

Modified by: @pcisar

status: Open [ 1 ] => Closed [ 6 ]

resolution: Cannot Reproduce [ 5 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants