[Firebird-devel] [FB-Tracker] Created: (CORE-6317) Server is crashing on long GRANT statement
Server is crashing on long GRANT statement -- Key: CORE-6317 URL: http://tracker.firebirdsql.org/browse/CORE-6317 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.5, 2.5.9 Environment: Windows x86 classic Reporter: Viktor Belzetskiy Server is crashing on long GRANT statement (buffer overflow?) Example: CREATE TABLE TEST_TABLE (ID INTEGER) For 2.5.x GRANT SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT ON TEST_TABLE TO PUBLIC; For 3.х GRANT SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT ON TEST_TABLE TO PUBLIC; -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-6301) No check dependence return fields in udr-procedures
No check dependence return fields in udr-procedures Key: CORE-6301 URL: http://tracker.firebirdsql.org/browse/CORE-6301 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0.5 Environment: WI-V3.0.6.33290 Reporter: Viktor Belzetskiy Priority: Minor No check dependence return fields in udr-procedures example: - CREATE PROCEDURE TEST_UDR_PROC RETURNS ( NUMBER DOUBLE PRECISION) EXTERNAL NAME 'udr_vds!fstrOpenAnyTable' -- any udr-procedure ENGINE UDR; CREATE PROCEDURE TEST_PROCEDURE RETURNS ( NUMBER DOUBLE PRECISION) AS BEGIN FOR SELECT NUMBER FROM TEST_UDR_PROC INTO :NUMBER DO SUSPEND; END; ALTER PROCEDURE TEST_UDR_PROC RETURNS ( NUMBER_2 DOUBLE PRECISION) -- !!! change field name !!! EXTERNAL NAME 'udr_vds!fstrOpenAnyTable' ENGINE UDR; Successfull. No error !!! -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-3927) Restore's hung for big database.
Restore's hung for big database. Key: CORE-3927 URL: http://tracker.firebirdsql.org/browse/CORE-3927 Project: Firebird Core Issue Type: Bug Components: GBAK Affects Versions: 2.5.0 Environment: Firebird CS 2.5.1 x86, Firebird SS 2.5.2.26538 x64, Windows2008 x86, Windows 2008R2 x64 Reporter: Viktor Belzetskiy Attachments: db_hang.7z The DB volume is about 2 bln records, 1800 tables with 5400 indexes. Restore's hung is happening while gbak.exe -r -user SYSDBA -pass masterkey -p... executing if the key (-o restore one table at a time) is not used. We made a number of tries and found out that restore's hung is not depends on: - Firefird's architecture - Database page size - Windows architecture (x64, x86) - Protocol (INET, XNET, service_mgr) For same bug's playback you should act according to following sequence: 1. Decompressing db_hang.7z. 2. Execute script from file db_script.sql (execute time* ~16h, final database size ~600Г, 7575522329 records) 3. Run Backup database gbak -b... (execute time* 6h, size fbk ~400Г) 4. Run Restore gbak -r... without key -o restore one table at a time. In our case the hung took place on 330 Gb file for TEMP_TBL_1087-table (gbak: 17611 records restored), after about 3 hours* of Restore's executing. * The executing time is specified for my hardware -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-3916) gfix Index x is corrupt (missing entries) in table ... all indexes on large tables
gfix Index x is corrupt (missing entries) in table ... all indexes on large tables --- Key: CORE-3916 URL: http://tracker.firebirdsql.org/browse/CORE-3916 Project: Firebird Core Issue Type: Bug Components: GFIX Affects Versions: 2.5.1 Environment: Win2008 x86, Firebird 2.5.1, 2.5.2 (x86) Reporter: Viktor Belzetskiy Attachments: test_corrupt.zip gfix with the keys -validate-no_update-full always gives the error Index x is corrupt (missing entries) in table ... for all table indexes size 2487410 or more pages. Database page size 16K. To receive this error, you must fill 500 million records. script: CREATE TABLE REP_ATOM_BRICK_DRUGS_DATA ( PERIOD_ID INTEGER, BRICK_CODE VARCHAR(5), DRUGS_IDINTEGER, IS_DUMP INTEGER, V DOUBLE PRECISION, Q DOUBLE PRECISION, PRT DOUBLE PRECISION ); CREATE UNIQUE INDEX REP_ATOM_BRICK_DRUGS_DATA_IDX1 ON REP_ATOM_BRICK_DRUGS_DATA (PERIOD_ID, BRICK_CODE, DRUGS_ID); CREATE INDEX REP_ATOM_BRICK_DRUGS_DATA_IDX3 ON REP_ATOM_BRICK_DRUGS_DATA (DRUGS_ID); If necessary, I can send on e-mail archive with empty database and script to fill it. Archive size 65KB. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-3917) fbtracemgr: add filtration for fields USER, IP (by mask), ROLE, Application in addition to connection_id.
fbtracemgr: add filtration for fields USER, IP (by mask), ROLE, Application in addition to connection_id. - Key: CORE-3917 URL: http://tracker.firebirdsql.org/browse/CORE-3917 Project: Firebird Core Issue Type: New Feature Components: TRACEMGR Reporter: Viktor Belzetskiy For example there can be situations when you had to trace actions from particular USER, IP or Application with several seconds of session duration. It is unreal to determine connection_id during these seconds and change config file, but it is necessary to trace all sessions by USER/IP for a long period. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel