[Firebird-devel] [FB-Tracker] Created: (CORE-5302) Performance regression when bulk inserting into table with indices

2016-07-07 Thread Vlad Khorsun (JIRA)
Components: Engine Affects Versions: 3.0.0, 4.0 Initial Reporter: Vlad Khorsun -- 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

[Firebird-devel] [FB-Tracker] Created: (CORE-5488) Timeouts for running SQL statements and idle connections

2017-02-22 Thread Vlad Khorsun (JIRA)
Components: API / Client Library, Engine Reporter: Vlad Khorsun Allows to set timeout for SQL statement, i.e. it allows to automatically stop execution of SQL statement when it running longer than given timeout value. Allows to automatically close user connection after period

[Firebird-devel] [FB-Tracker] Created: (CORE-5464) AV in fbclient when reading blob stored in incompatible encoding

2017-01-19 Thread Vlad Khorsun (JIRA)
Components: API / Client Library Affects Versions: 3.0.1, 4.0 Initial Reporter: Vlad Khorsun firebird>chcp 1251 Active code page: 1251 firebird>isql -ch win1251 Use CONNECT or CREATE DATABASE to specify a database SQL> create database 'inet://c:\temp\blf.fdb

[Firebird-devel] [FB-Tracker] Created: (CORE-5348) Databases created at build process are owned by Windows administrator, not SYSDBA

2016-09-07 Thread Vlad Khorsun (JIRA)
Core Issue Type: Bug Components: Build Issues / Porting Affects Versions: 3.0.0, 4.0 Initial Environment: Windows only Reporter: Vlad Khorsun Priority: Trivial -- This message is automatically generated by JIRA. - If you think

[Firebird-devel] [FB-Tracker] Reopened: (CORE-5257) Enable nested keys in plugin configuration

2016-10-24 Thread Vlad Khorsun (JIRA)
[ http://tracker.firebirdsql.org/browse/CORE-5257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vlad Khorsun reopened CORE-5257: Fix Version/s: 3.0.2 Re-opened due to wrong parsing of nested keys > Enable nested keys in plu

[Firebird-devel] [FB-Tracker] Created: (CORE-5417) Engine could hang up if auto-sweep is starting while database is shuttign down

2016-12-11 Thread Vlad Khorsun (JIRA)
Issue Type: Bug Components: Engine Affects Versions: 3.0.1, 2.5.6, 3.0.0, 4.0 Initial Reporter: Vlad Khorsun The issue was reported by Jiří Činčura at fb-devel (26 Sep 2016, " Stuck transaction in 2.5.6") : https://sourceforge.net/p/firebird/mailm

[Firebird-devel] [FB-Tracker] Created: (CORE-5434) Read-only transactions in SuperServer could not write Header and TIP pages immediately after edit

2017-01-03 Thread Vlad Khorsun (JIRA)
-5434 Project: Firebird Core Issue Type: Improvement Components: Engine Reporter: Vlad Khorsun Currently engine writes contents of Header and TIP pages to disk immediately after any change (for ex. transaction start increments value of "Next transa

[Firebird-devel] [FB-Tracker] Created: (CORE-5441) Cache physical numbers of often used data pages to reduce number of fetches of pointer pages

2017-01-08 Thread Vlad Khorsun (JIRA)
Project: Firebird Core Issue Type: Improvement Components: Engine Reporter: Vlad Khorsun When engine need to fetch some data page by its logical number (sequence number of DP in relation) it should fetch corresponding PP first and look for slot with physical

[Firebird-devel] [FB-Tracker] Created: (CORE-5507) Wrong value of the new field at the old records, created before that new field was added.

2017-03-23 Thread Vlad Khorsun (JIRA)
Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.2 Reporter: Vlad Khorsun RECREATE TABLE T (ID INT NOT NULL, DESCR VARCHAR(32) NOT NULL); COMMIT; INSERT INTO T (ID, DESCR) VALUES (1, 'No F1 field'); COMMIT; ALTER TABLE T ADD F1

[Firebird-devel] [FB-Tracker] Created: (CORE-5522) Engine could freeze up to 2 minutes and raise deadlock error when updating RDB$INDICES if it contains backversions

2017-04-16 Thread Vlad Khorsun (JIRA)
://tracker.firebirdsql.org/browse/CORE-5522 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.5.7 Reporter: Vlad Khorsun Test case 1. create backversions in rdb$indices and make hard rollback to leave it on disk: delete from

[Firebird-devel] [FB-Tracker] Created: (CORE-5582) Segmentation fault in TRA_detach_request

2017-07-14 Thread Vlad Khorsun (JIRA)
: 2.5.7 Environment: Linux, CS Reporter: Vlad Khorsun There is user report that some of many Firebird CS processes crashes when database is shutting down by DBA before sweep run. The crashes relatively rare, once per few days or weeks. The coredump contains following stack #0

[Firebird-devel] [FB-Tracker] Created: (CORE-5530) Random AV at client application using events when connection was broken

2017-05-04 Thread Vlad Khorsun (JIRA)
Type: Bug Components: API / Client Library Affects Versions: 2.5.7, 2.5.6, 2.5.5, 2.5.4, 2.5.3 Update 1, 2.1.7, 2.5.3, 2.5.2 Update 1, 2.5.2, 2.5.1, 2.5.0 Reporter: Vlad Khorsun If client application - uses local (stack based) status vector when call ISC API functions

[Firebird-devel] [FB-Tracker] Created: (CORE-5613) SuperServer could hung when changing physical backup state under high load

2017-09-16 Thread Vlad Khorsun (JIRA)
Issue Type: Bug Components: Engine Affects Versions: 4.0 Alpha 1, 3.0.2, 3.0.1, 3.0.0 Reporter: Vlad Khorsun The issue was detected when testing nbackup during TPCC run with 64 concurrent connections. Engine could hung immediately after begin\end backup, i.e. after

[Firebird-devel] [FB-Tracker] Created: (CORE-5614) Physical backup merge stage could run too long, especially with huge page cache

2017-09-16 Thread Vlad Khorsun (JIRA)
Issue Type: Improvement Components: Engine Affects Versions: 4.0 Alpha 1, 3.0.2, 3.0.1, 3.0.0 Reporter: Vlad Khorsun -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http

[Firebird-devel] [FB-Tracker] Created: (CORE-5648) Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation

2017-10-24 Thread Vlad Khorsun (JIRA)
architectures. Classic is not affected. Reporter: Vlad Khorsun When EXECUTE STATEMENT ... ON EXTERNAL DATA SOURCE was introiduced in v2.5.0 there was informal agreement that calls of isc_attach_database should be serialized to avoid deadlocks in fbclient (reported by users from time to time

[Firebird-devel] [FB-Tracker] Created: (CORE-5674) Allow unused Common Table Expressions

2017-12-01 Thread Vlad Khorsun (JIRA)
: Vlad Khorsun When fixing bug CORE-1793 unused CTEs was forbidden - it was simplest solution to avoid crash in the engine. Crash happens due to uninitialized input parameters as unused CTE is not handled by syntax analyzer at all. But it is too stong limitation and users complains about

[Firebird-devel] [FB-Tracker] Created: (CORE-5681) AV when external statement is executed and local transaction is rolled back

2017-12-16 Thread Vlad Khorsun (JIRA)
Issue Type: Bug Components: Engine Affects Versions: 4.0 Alpha 1, 3.0.2, 2.5.7, 3.0.1, 2.5.6, 3.0.0, 4.0 Initial, 2.5.5, 2.5.4, 2.5.3 Update 1, 2.5.3, 2.5.2 Update 1, 2.5.2, 2.5.1, 2.5.0 Reporter: Vlad Khorsun Crash of Firebird 2.5 on Linux was reported by user

[Firebird-devel] [FB-Tracker] Created: (CORE-5685) Sometime it is impossible to cancel\kill connection executing external query

2017-12-20 Thread Vlad Khorsun (JIRA)
Issue Type: Bug Components: API / Client Library Affects Versions: 4.0 Alpha 1, 3.0.2, 2.5.7, 3.0.1, 2.5.6, 3.0.0, 4.0 Initial, 2.5.5, 2.5.4, 2.5.3 Update 1, 2.5.3, 2.5.2 Update 1, 2.5.2, 2.5.1, 2.5.0 Reporter: Vlad Khorsun There is user reports that in some cases

[Firebird-devel] [FB-Tracker] Created: (CORE-5660) Make flash of big number of dirty pages faster

2017-11-14 Thread Vlad Khorsun (JIRA)
Affects Versions: 4.0 Alpha 1, 3.0.2, 2.5.7, 3.0.1, 2.5.6, 3.0.0, 4.0 Initial, 2.5.5, 2.5.4, 2.5.3 Update 1, 2.1.7, 2.5.3, 2.5.2 Update 1, 2.5.2, 2.5.1, 2.5.0 Reporter: Vlad Khorsun Flush cache algorithm could be improved for the case when there is a big number of dirty pages

[Firebird-devel] [FB-Tracker] Reopened: (CORE-5652) Rolling back a transaction that creates a function or procedure keeps a cached version of that function or procedure when subsequently re-creating i

2017-12-12 Thread Vlad Khorsun (JIRA)
[ http://tracker.firebirdsql.org/browse/CORE-5652?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vlad Khorsun reopened CORE-5652: I missed that script was executed with FlameRobin. Now, with isql and AUTODDL OFF SQL> SQL&g

[Firebird-devel] [FB-Tracker] Created: (CORE-5819) Attachment could not gone after it was DELETE'd FROM MON$ATTACHMENTS

2018-05-09 Thread Vlad Khorsun (JIRA)
: Bug Components: Engine Affects Versions: 3.0.3, 4.0 Alpha 1, 3.0.2, 3.0.1, 3.0.0, 4.0 Initial Environment: Attachment run some EXECUTE STATEMENT when it was asynchronously dropped (using DELETE FROM MON$ATTACHMENTS). Reporter: Vlad Khorsun It was reproduced

[Firebird-devel] [FB-Tracker] Created: (CORE-5831) Not user friendly output of gstat at encrypted database

2018-05-21 Thread Vlad Khorsun (JIRA)
: GSTAT Affects Versions: 3.0.3 Reporter: Vlad Khorsun Priority: Minor Gstat shows "strange" lines "Variable header data" section at on encrypted database: > gstat -h ... Database header page information: .. Implementation HW=I

[Firebird-devel] [FB-Tracker] Created: (CORE-5832) Implement way to reset user session environment to its initial (default) state

2018-05-21 Thread Vlad Khorsun (JIRA)
Issue Type: New Feature Components: Engine Reporter: Vlad Khorsun Resetting user session (connection) to its initial state should be useful when session is reused by application. I.e. instead of detach\attach application could just reuse already established

[Firebird-devel] [FB-Tracker] Created: (CORE-5843) Wrong handling of failures of TRANSACTION START trigger

2018-06-10 Thread Vlad Khorsun (JIRA)
: Engine Affects Versions: 4.0 Alpha 1 Reporter: Vlad Khorsun There are two general cases when TRANSACTION START trigger is fired 1. when user start transaction, and 2. when IN AUTONOMOUS TRANSACTION statement starts new transaction. Let look what happens if TRANSACTION START

[Firebird-devel] [FB-Tracker] Reopened: (CORE-5436) [FB3 SC] Server hangs (under load test)

2018-06-13 Thread Vlad Khorsun (JIRA)
[ http://tracker.firebirdsql.org/browse/CORE-5436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vlad Khorsun reopened CORE-5436: New reports from users allows to find another reason for this issue. Thus i re-open the ticket > [

[Firebird-devel] [FB-Tracker] Created: (CORE-5837) Inconsistent results when working with GLOBAL TEMPORARY TABLE ON COMMIT PRESERVE ROWS

2018-05-30 Thread Vlad Khorsun (JIRA)
: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.3, 4.0 Alpha 1, 3.0.2, 3.0.1, 3.0.0, 4.0 Initial Environment: SuperServer only Reporter: Vlad Khorsun One attachment could see data of GTT instance of another attachment. Bugcheck

[Firebird-devel] [FB-Tracker] Created: (CORE-5703) When database validation fixes "orphan page" errors it also should adjust "lowest free page" marker (pip_min) on corresponding PIP, if necessary

2018-01-09 Thread Vlad Khorsun (JIRA)
ng PIP, if necessary Key: CORE-5703 URL: http://tracker.firebirdsql.org/browse/CORE-5703 Project: Firebird Core Issue Type: Improvement Components: Engine Reporter: Vlad Khorsun -- This message is automatically generat

[Firebird-devel] [FB-Tracker] Created: (CORE-5704) Avoid UPDATE of RDB$DATABASE by ALTER DATABASE statement when possible

2018-01-09 Thread Vlad Khorsun (JIRA)
Type: Improvement Components: Engine Reporter: Vlad Khorsun Some clauses of ALTER DATABASE statement requires to update row in RDB$DATABASE: SET DEFAULT CHARACTER SET, SET LINGER, DROP LINGER. Other clauses doesn't requires to update RDB$DATABASE: BEGIN|END BACKUP

[Firebird-devel] [FB-Tracker] Created: (CORE-5720) Sweep in Firebird 3 in CS mode could run too slow when there is big load on server

2018-01-21 Thread Vlad Khorsun (JIRA)
: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 4.0 Alpha 1, 3.0.2, 3.0.1, 3.0.0, 4.0 Initial Reporter: Vlad Khorsun -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators

[Firebird-devel] [FB-Tracker] Created: (CORE-5719) FB3 crashes when restoring backup made by FB2.5

2018-01-21 Thread Vlad Khorsun (JIRA)
Affects Versions: 3.0.2 Reporter: Vlad Khorsun -- 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

[Firebird-devel] [FB-Tracker] Created: (CORE-5727) Make faster engine response on cancel\shutdown signals when scanning long list of pointer pages

2018-01-28 Thread Vlad Khorsun (JIRA)
Project: Firebird Core Issue Type: Improvement Components: Engine Affects Versions: 2.5.8, 4.0 Alpha 1, 3.0.2 Reporter: Vlad Khorsun -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one

[Firebird-devel] [FB-Tracker] Created: (CORE-5847) "Malformed string" instead of key value in PK violation error message

2018-06-19 Thread Vlad Khorsun (JIRA)
Issue Type: Bug Components: Engine Affects Versions: 3.0.3, 2.5.8, 4.0 Alpha 1, 3.0.2, 2.5.7, 3.0.1, 2.5.6, 3.0.0, 4.0 Initial, 2.5.5, 2.5.4, 2.5.3 Update 1, 2.5.3 Reporter: Vlad Khorsun Priority: Minor 1. Connect with UTF8 charset: firebird>isql

[Firebird-devel] [FB-Tracker] Created: (CORE-5870) ISQL's show_database command works wrong with big numbers

2018-07-10 Thread Vlad Khorsun (JIRA)
Components: ISQL Affects Versions: 3.0.3, 4.0 Alpha 1, 3.0.2, 3.0.1, 3.0.0, 4.0 Initial Reporter: Vlad Khorsun Priority: Minor \firebird>gstat -h s:\temp\tx.30.fdb Database "S:\TEMP\TX.30.FDB" Gstat execution time Tue Jul 10 18:32:41 2018 Database header pag

[Firebird-devel] [FB-Tracker] Created: (CORE-5869) Sweep can't move OIT value over 2^32, when Next already greater than 2^32 (4'294'967'296)

2018-07-10 Thread Vlad Khorsun (JIRA)
Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.3, 3.0.2, 3.0.1, 3.0.0 Reporter: Vlad Khorsun First sweep run: Sweep is started by SYSDBA Database "S:\TEMP\TX.30.FDB" OIT 4294965022, OAT 42949

[Firebird-devel] [FB-Tracker] Created: (CORE-5872) Database validation reports false errors "Record XXX has bad transaction" and\or "Record XXX is wrong length" when record transaction number is great

2018-07-10 Thread Vlad Khorsun (JIRA)
, 3.0.0, 4.0 Initial Reporter: Vlad Khorsun -- 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.atlassi

[Firebird-devel] [FB-Tracker] Reopened: (CORE-405) Garbage vs indices/constraints

2018-03-16 Thread Vlad Khorsun (JIRA)
[ http://tracker.firebirdsql.org/browse/CORE-405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vlad Khorsun reopened CORE-405: --- Assignee: Vlad Khorsun > Garbage vs indices/constrai

[Firebird-devel] [FB-Tracker] Created: (CORE-5781) Implement INSENSITIVE property for PSQL explicit cursors

2018-03-20 Thread Vlad Khorsun (JIRA)
Components: Engine Reporter: Vlad Khorsun The SQL Standard say: --- begin quote --- The following paragraphs define several terms used to discuss issues relating to a cursor's operational sensitivity property: A change to SQL-data is said to be independent of a cursor CR if and only

[Firebird-devel] [FB-Tracker] Created: (CORE-5954) Garbage collection in intermediate record versions

2018-10-25 Thread Vlad Khorsun (JIRA)
: Engine Reporter: Vlad Khorsun The ticket is created for documentation purposes. The more detailed description is at doc\README.read_consistency.md -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http

[Firebird-devel] [FB-Tracker] Created: (CORE-5953) Statement level read consistency in read-committed transactions

2018-10-25 Thread Vlad Khorsun (JIRA)
Feature Components: Engine Reporter: Vlad Khorsun The ticket is created for documentation purposes. The more detailed description is at doc\README.read_consistency.md -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one

[Firebird-devel] [FB-Tracker] Created: (CORE-5935) Bugcheck 165 (cannot find tip page)

2018-10-04 Thread Vlad Khorsun (JIRA)
, 3.0.3, 3.0.2, 3.0.1, 3.0.0 Environment: Classic, SuperClassic Reporter: Vlad Khorsun -- 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

[Firebird-devel] [FB-Tracker] Created: (CORE-5921) Provide information about Global Commit Number, Commit Number of currently used database snapshot (if any) and Commit Numbers assigned to the committ

2018-09-23 Thread Vlad Khorsun (JIRA)
Key: CORE-5921 URL: http://tracker.firebirdsql.org/browse/CORE-5921 Project: Firebird Core Issue Type: Improvement Components: Engine Affects Versions: 4.0 Alpha 1 Reporter: Vlad

[Firebird-devel] [FB-Tracker] Created: (CORE-5990) Pool of external connections

2019-01-23 Thread Vlad Khorsun (JIRA)
Pool of external connections Key: CORE-5990 URL: http://tracker.firebirdsql.org/browse/CORE-5990 Project: Firebird Core Issue Type: New Feature Components: Engine Reporter: Vlad Khorsun

[Firebird-devel] [FB-Tracker] Created: (CORE-5911) Connection could hung after no activity for 60 seconds

2018-09-14 Thread Vlad Khorsun (JIRA)
: Engine Affects Versions: 3.0.3, 2.5.8, 4.0 Alpha 1 Environment: INET connections only Reporter: Vlad Khorsun Imagine application that run some query then sleep for 60 seconds then again run query, sleep for 60 sec and so on. If there are no other connections

[Firebird-devel] [FB-Tracker] Created: (CORE-5913) Add context variables with compression and encryption status of current connection

2018-09-18 Thread Vlad Khorsun (JIRA)
: Firebird Core Issue Type: Sub-task Reporter: Vlad Khorsun Assignee: Vlad Khorsun -- 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

[Firebird-devel] [FB-Tracker] Created: (CORE-5993) When creation of audit log file fails, there is no error message in firebird.log

2019-01-25 Thread Vlad Khorsun (JIRA)
Core Issue Type: Bug Components: Engine Affects Versions: 3.0.4, 3.0.3, 4.0 Alpha 1, 3.0.2, 3.0.1, 3.0.0, 4.0 Initial Reporter: Vlad Khorsun -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one

[Firebird-devel] [FB-Tracker] Created: (CORE-5991) Trace could not work correctly with quoted file names in trace configurations

2019-01-24 Thread Vlad Khorsun (JIRA)
Issue Type: Bug Components: Engine Affects Versions: 3.0.4, 3.0.3, 4.0 Alpha 1, 3.0.2, 3.0.1, 3.0.0, 4.0 Initial Reporter: Vlad Khorsun Priority: Minor Trace configuration allows to specify file names in two places: a) at "database" sect

[Firebird-devel] [FB-Tracker] Reopened: (CORE-6080) Attempt to drop existing user randomly fails with "336723990 : record not found for user"

2019-07-02 Thread Vlad Khorsun (JIRA)
[ http://tracker.firebirdsql.org/browse/CORE-6080?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vlad Khorsun reopened CORE-6080: Re-opened to fix a bug, introduced by initial attempt > Attempt to drop existing user randomly fa

[Firebird-devel] [FB-Tracker] Created: (CORE-6142) Error "connection lost to database" could happen when application creates few local attachments (using XNET) simultaneously

2019-09-13 Thread Vlad Khorsun (JIRA)
5.5, 2.5.4, 2.5.3 Update 1, 2.1.7, 2.5.3, 2.5.2 Update 1, 2.5.2, 2.5.1, 2.5.0 Environment: Windows only, mt-application, local protocol Reporter: Vlad Khorsun -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the admi

[Firebird-devel] [FB-Tracker] Created: (CORE-6150) Bugcheck when PK\UK\FK constraint check read record already marked as damaged

2019-09-30 Thread Vlad Khorsun (JIRA)
Issue Type: Bug Components: Engine Affects Versions: 2.5.9, 4.0 Beta 1, 3.0.4, 3.0.3, 2.5.8, 4.0 Alpha 1, 3.0.2, 2.5.7, 3.0.1, 2.5.6, 3.0.0, 4.0 Initial, 2.5.5, 2.5.4, 2.5.3 Update 1, 2.1.7, 2.5.3, 2.5.2 Update 1, 2.5.2, 2.5.1, 2.5.0 Reporter: Vlad Khorsun I

[Firebird-devel] [FB-Tracker] Created: (CORE-6254) AV in engine when using SET TRANSACTION and ON TRANSACTION START trigger uses EXECUTE STATEMENT against current transaction

2020-02-20 Thread Vlad Khorsun (JIRA)
URL: http://tracker.firebirdsql.org/browse/CORE-6254 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0.5, 4.0 Beta 1, 3.0.4, 3.0.3, 4.0 Alpha 1, 3.0.2, 3.0.1, 3.0.0, 4.0 Initial Reporter: Vlad Khorsun To reproduce, attach with isql to the any

[Firebird-devel] [FB-Tracker] Created: (CORE-6233) Wrong dependencies of stored function on view after backup and restore

2020-01-17 Thread Vlad Khorsun (JIRA)
Type: Bug Components: Engine Affects Versions: 3.0.5 Reporter: Vlad Khorsun 1. Create database and run script set term ^; create or alter view v1 as select 1 as n from rdb$database ^ create or alter function f1 returns integer as declare ret integer; begin

[Firebird-devel] [FB-Tracker] Created: (CORE-6295) Incomplete header files

2020-05-01 Thread Vlad Khorsun (JIRA)
, 3.0.3, 4.0 Alpha 1, 3.0.2, 3.0.1, 3.0.0, 4.0 Initial Reporter: Vlad Khorsun \include\firebird\IdlFbInterfaces.h contains references to the PerformanceInfo which is declared in \src\jrd\ntrace.h Contents of this file should be included into final ibase.h Also, i see no \include

[Firebird-devel] [FB-Tracker] Created: (CORE-6319) NBACKUP locks db file on error

2020-05-27 Thread Vlad Khorsun (JIRA)
Reporter: Vlad Khorsun When I give wrong backup file to NBACKUP.exe -INPLACE, error is reported as expected: NBACKUP -inplace -restore localhost/:Z:\export\TESTF2.FDB Z:\export\x05G.nbk Invalid incremental backup file: Z:\export\x05G.nbk NBACKUP -inplace -restore localhost/:Z

[Firebird-devel] [FB-Tracker] Created: (CORE-6379) Bugcheck 179

2020-08-04 Thread Vlad Khorsun (JIRA)
Bugcheck 179 - Key: CORE-6379 URL: http://tracker.firebirdsql.org/browse/CORE-6379 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 4.0 Beta 2 Reporter: Vlad Khorsun

[Firebird-devel] [FB-Tracker] Created: (CORE-6351) Computed field could be wrongly evaluated as NULL

2020-07-02 Thread Vlad Khorsun (JIRA)
Affects Versions: 3.0.6 Reporter: Vlad Khorsun The sample is based on much more complex case sent to me by user privately. 1. Prepare metatada create table t1 ( id int, f1 computed by ('abcd'), f2 computed by ('xyz') ); commit; set term ^; create or alter procedure p_t1 (id

[Firebird-devel] [FB-Tracker] Reopened: (CORE-6253) Crash caused by the locked fb_lock file

2020-07-07 Thread Vlad Khorsun (JIRA)
[ http://tracker.firebirdsql.org/browse/CORE-6253?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vlad Khorsun reopened CORE-6253: > Crash caused by the locked fb_lock f

[Firebird-devel] [FB-Tracker] Created: (CORE-6364) Wrong reference counting in UDR trigger sample

2020-07-13 Thread Vlad Khorsun (JIRA)
Versions: 3.0.6, 4.0 Beta 2, 3.0.5, 4.0 Beta 1, 3.0.4, 3.0.3, 4.0 Alpha 1, 3.0.2, 3.0.1, 3.0.0, 4.0 Initial Reporter: Vlad Khorsun Due to not released transaction and attachment interfaces in examples\udr\Trigger.cpp there is small memory leak and possible server crash on shutdown

[Firebird-devel] [FB-Tracker] Created: (CORE-6444) Ability to query Firebird configuration using SQL

2020-11-11 Thread Vlad Khorsun (JIRA)
: Engine Reporter: Vlad Khorsun It will be nice to have ability to query configuration settings using SQL language. Configuration here is contents of firebird.conf, databases.conf and settings passed via DPB when applicable. Proposed solution is to introduce new virtual table to expose

[Firebird-devel] [FB-Tracker] Created: (CORE-6475) Memory leak when running EXECUTE STATEMENT with named parameters

2021-01-23 Thread Vlad Khorsun (JIRA)
Components: API / Client Library Affects Versions: 4.0 Beta 2 Reporter: Vlad Khorsun The small memory leak (96 bytes per named parameter) was introduced with CORE-5658 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one

[Firebird-devel] [FB-Tracker] Created: (CORE-6477) Rare race condition in Plugin Manager could lead to the server crash

2021-01-28 Thread Vlad Khorsun (JIRA)
: Bug Components: Engine Affects Versions: 3.0.7 Reporter: Vlad Khorsun Attachments: stack.txt -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure

[Firebird-devel] [FB-Tracker] Created: (CORE-6526) AV in engine when StatementTimeout is active for user statement and some internal DSQL statement was executed as part of overall execution process

2021-03-28 Thread Vlad Khorsun (JIRA)
-- Key: CORE-6526 URL: http://tracker.firebirdsql.org/browse/CORE-6526 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 4.0 RC 1, 4.0 Beta 2, 4.0 Beta 1 Reporter: Vlad Khorsun In the case below

[Firebird-devel] [FB-Tracker] Created: (CORE-6542) Implementation of SUBSTRING for multi-byte character sets is inefficient

2021-04-16 Thread Vlad Khorsun (JIRA)
Issue Type: Improvement Components: Engine Affects Versions: 4.0 RC 1, 3.0.7 Reporter: Vlad Khorsun The case below shows bad performance of SUBSTRING for UTF8 comparing with (legacy) UNICODE_FSS a) UNICODE_FSS execute block as declare str1 varchar(8000) character set

[Firebird-devel] [FB-Tracker] Created: (CORE-6488) Event delivery could be missed when local (XNET) protocol is used

2021-02-15 Thread Vlad Khorsun (JIRA)
Components: API / Client Library, Engine Affects Versions: 4.0 RC 1, 3.0.7, 2.5.9 Environment: Windows only Reporter: Vlad Khorsun The bug was reported at https://www.sql.ru/forum/165/ The problem could happen when: - the op_event packet is longer than

Re: [Firebird-devel] Trace no returning any data

2017-07-14 Thread Vlad Khorsun via Firebird-devel
14.07.2017 11:01, Jiří Činčura wrote: Hi *, I have this fbtrace.conf file: database { enabled = true log_connections = true log_statement_prepare = true log_statement_start = true log_statement_finish = true time_threshold = 0 } And I'm starting

Re: [Firebird-devel] fbtrace.conf format

2017-07-14 Thread Vlad Khorsun via Firebird-devel
14.07.2017 11:02, Jiří Činčura wrote: Hi *, I realized the fbtrace.conf has new format in FB3. Is the old one still supported (because that's what the .NET provider is currently using - I was not expecting this to be change "just because we can")? In FB3 we used same configuration files

Re: [Firebird-devel] Trace no returning any data

2017-07-14 Thread Vlad Khorsun via Firebird-devel
14.07.2017 11:26, Jiří Činčura wrote: What Firebird account you used to run trace ? I haven't specified any username/password. The command line I posted is all I executed. It uses your OS user name (i guess) and thus it can't trace sessions of other users. Specify correct user

Re: [Firebird-devel] icudt52.dll FB3

2017-07-10 Thread Vlad Khorsun via Firebird-devel
10.07.2017 11:11, D. Kruise пишет: ... I installed in the exe directory FBclient.dll firebird.msg ib_util.dll icudt52.dll icuin52.dll icuuc52.dll Seems you missed icudt52l.dat. Also, make sure, you used 64-bit DLL's And into subdir intl fbintl.conf fbintl.dll And into subdir plugins

Re: [Firebird-devel] Trace no returning any data

2017-07-14 Thread Vlad Khorsun via Firebird-devel
14.07.2017 12:14, Jiří Činčura wrote: It uses your OS user name (i guess) and thus it can't trace sessions of other users. Specify correct user credentials and it should work. No luck. I tried both ".\fbsvcmgr service_mgr user sysdba password masterkey action_trace_start trc_name ..."

Re: [Firebird-devel] HASH function (CORE-4436)

2017-07-18 Thread Vlad Khorsun via Firebird-devel
18.07.2017 21:55, Adriano dos Santos Fernandes wrote: Hi! We have HASH function that returns a 64 bit integer. The algorithm is bad and the result too small for a hash. I propose to extend the same function with a second parameter with the algorithm name. > When only one parameter is passed,

Re: [Firebird-devel] Detecting connection is using wire encryption

2017-07-16 Thread Vlad Khorsun via Firebird-devel
16.07.2017 12:59, Mark Rotteveel wrote: Is there a way to programmatically detect a connection is using wire encryption (eg in a monitoring table or the service API)? I'm writing a test to check if Jaybird is correctly (not) using encryption depending on its connection properties, and I'd

[Firebird-devel] test

2017-08-18 Thread Vlad Khorsun via Firebird-devel
Ignore please Vlad -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] 3.0.2 consistent crash

2017-08-19 Thread Vlad Khorsun via Firebird-devel
18.08.2017 19:45, Jiří Činčura wrote: Could you try latest snapshot build ? Running it (3.0.3.32798) for about an hour now. So far so good. Sounds good ;) Send full memory dump to me, please. Or, better, reproducible test case, if it is possible. I can only trigger it from

Re: [Firebird-devel] 3.0.2 consistent crash

2017-08-18 Thread Vlad Khorsun via Firebird-devel
18.08.2017 14:59, Jiří Činčura wrote: Hi *, I'm running 3.0.2 x64 SS (on Win 2016 (if it matters)) and I can consistently get "internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 282)". Sometimes it's quick sometimes it takes few minutes. Always this.

[Firebird-devel] [SPAM] Re: Build sources

2017-10-13 Thread Vlad Khorsun via Firebird-devel
13.10.2017 12:16, liviuslivius wrote: Hi, I try to build Fb master from sources. What is the recommended environment for Windows. Can i use MSVC14 Express? I never used Express version by myself. I use VS 2015 Community Edition currently for testing VC14 builds. Or it must be MSVC12? I

Re: [Firebird-devel] FB 3.0 Replacing ICU libraries on Windows

2017-10-12 Thread Vlad Khorsun via Firebird-devel
12.09.2017 15:33, Adriano dos Santos Fernandes wrote: On 12/09/2017 08:46, Magnus Johansson wrote: ... SELECT FIELD_UTF_SV_CI_NUM FROM TABLE_T WHERE FIELD_UTF_SV_CI_NUM BETWEEN '' AND 'b' ORDER BY 1; FIELD_UTF_SV_CI_NUM === 1 2 10 20 a A aa Aa AA b

Re: [Firebird-devel] Plans to support cross and outer apply

2017-09-06 Thread Vlad Khorsun via Firebird-devel
06.09.2017 9:45, Jiří Činčura wrote: Hi *, I was searching the tracker but couldn't find anything. Any plans around supporting cross and outer apply "joins"? I think we should consider standard LATERAL JOIN. It seems not too hard to implement. Regards, Vlad

Re: [Firebird-devel] Lateral derived tables

2017-09-10 Thread Vlad Khorsun via Firebird-devel
08.09.2017 11:03, Dmitry Yemanov wrote: All, The key point of this standard feature is to allow sub-queries to reference priorly defined contexts (in joins). While thinking about this, I have a few questions to raise here. The standard defines LATERAL for derived tables only. This sounds

Re: [Firebird-devel] Test - please ignore

2017-09-30 Thread Vlad Khorsun via Firebird-devel
Test 2 -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-11 Thread Vlad Khorsun via Firebird-devel
11.10.2017 23:33, Dimitry Sibiryakov wrote: 11.10.2017 22:14, Vlad Khorsun via Firebird-devel wrote:    IIRC, it is already implemented.   No. This functionality is in fbsvcmgr, but not in gbak. It is implemented at Service API level, i.e. by all the providers (engine, remote, etc

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-11 Thread Vlad Khorsun via Firebird-devel
12.10.2017 0:37, Dimitry Sibiryakov wrote: 11.10.2017 22:56, Vlad Khorsun via Firebird-devel wrote:    The problem is that you don't undestand that auth parameters (required to create connection) should not be mixed with action's parameters.   I can't understand what you talking about

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-11 Thread Vlad Khorsun via Firebird-devel
11.10.2017 21:09, Dimitry Sibiryakov wrote: 11.10.2017 19:47, Vlad Khorsun via Firebird-devel wrote:    I don't see it as a problem, as user already should understand what is connection string and how to construct is from host name and database name. From my expirience "usual" ap

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-11 Thread Vlad Khorsun via Firebird-devel
11.10.2017 21:34, Adriano dos Santos Fernandes wrote: I must agree that host:service_mgr is weird, but not all services expects (or would expect) a database. Can't say it is weird. Probably, we could allow to skip service manager name, but it will be hard to specify XNET protocol without

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-11 Thread Vlad Khorsun via Firebird-devel
11.10.2017 16:59, Dimitry Sibiryakov пишет: 10.10.2017 18:00, Dimitry Sibiryakov wrote:    I'd suggest to offer to the application developer third, more convenient, option: subj.    If database connection string is used this way, server can automatically set the database name to expected_db

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-11 Thread Vlad Khorsun via Firebird-devel
10.10.2017 19:00, Dimitry Sibiryakov wrote:   Hello.   Imagine that you are an application developer and develop an application that allow users to enter connection string for database they want to work with. Imagine that in new version of the application you would like to add some work with

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-11 Thread Vlad Khorsun via Firebird-devel
11.10.2017 22:22, Dimitry Sibiryakov wrote: 11.10.2017 20:57, Vlad Khorsun via Firebird-devel wrote:   I don't understand your speculations   Ok, turn your imagination on: Performance of gbak must be improved by feeding of backup stream from server using services instead of sending queries

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Vlad Khorsun via Firebird-devel
27.11.2017 16:50, Jiří Činčura wrote: But mostly wierd is that even in theory crypt plugin can not affect integrity constraints - encryption works a few logical levels deeper than constraints violation, that's absolutely different parts of code. Yeah. I though the database was somewhat

Re: [Firebird-devel] Database opened in another session

2017-12-18 Thread Vlad Khorsun via Firebird-devel
17.12.2017 17:33, Jiří Činčura wrote: I.e. it is failed to initialize shared memory for monitoring snapshot. I can't explain how it is possible to initialize lock manager shared memory first and then fail to initialize shared memory for monitoring snapshot. Need more time to investigate it.

Re: [Firebird-devel] Memory leak - How can I provide information about it?

2017-12-12 Thread Vlad Khorsun via Firebird-devel
12.12.2017 17:38, Gabor Boros wrote: If the problem can't be reproduces with a simple database and simple application, it's probably another problem. I have a simple application and three databases. Can I send to you privately? I attached earlier but got a message about the 40 KB body limit.

Re: [Firebird-devel] Memory leak - How can I provide information about it?

2017-12-14 Thread Vlad Khorsun via Firebird-devel
12.12.2017 19:55, Gabor Boros wrote: 2017. 12. 12. 18:31 keltezéssel, Vlad Khorsun via Firebird-devel írta: 12.12.2017 17:38, Gabor Boros wrote: If the problem can't be reproduces with a simple database and simple application, it's probably another problem. I have a simple application

Re: [Firebird-devel] Memory leak - How can I provide information about it?

2017-12-15 Thread Vlad Khorsun via Firebird-devel
15.12.2017 10:45, liviuslivius wrote: Hi Vlad, "This temporary blobs could be released on commit (rollback) only" just curious, why it can not be released after it is used? When its become unused ? That blobs returned to the client aplication and should be accessible until transaction

Re: [Firebird-devel] Memory leak - How can I provide information about it?

2017-12-15 Thread Vlad Khorsun via Firebird-devel
15.12.2017 12:34, Dimitry Sibiryakov wrote: 15.12.2017 10:03, Vlad Khorsun via Firebird-devel wrote: PS In theory, it should be possible to postpone transliteration into attachment charset until application opens blob. But i see no easy\direct way to do it.   In theory it is possible

Re: [Firebird-devel] Memory leak - How can I provide information about it?

2017-12-15 Thread Vlad Khorsun via Firebird-devel
15.12.2017 11:20, Adriano dos Santos Fernandes пишет: On 15/12/2017 07:03, Vlad Khorsun via Firebird-devel wrote: 15.12.2017 10:45, liviuslivius wrote: Hi Vlad, "This temporary blobs could be released on commit (rollback) only" just curious, why it can not be released after

Re: [Firebird-devel] Database opened in another session

2017-12-20 Thread Vlad Khorsun via Firebird-devel
18.12.2017 14:26, Jiří Činčura wrote: Right now I isolated the databases, so only apps from the same session (0) are accessing the database and always via TCP/IP. I'm afraid it's something else. I found one change in v3 not backported into v2.5 which could be related to this issue. Could you

Re: [Firebird-devel] Database opened in another session

2017-12-20 Thread Vlad Khorsun via Firebird-devel
20.12.2017 11:16, Jiří Činčura wrote: v3 after you isolated the databases (what do you mean by this, btw) ? I'm keeping eye on v3. For sure it's not often. But I think I saw it even on 3 before. Will wait a week or so to see whether it happens or not. Isolated: I went through all apps and

Re: [Firebird-devel] Database opened in another session

2017-12-07 Thread Vlad Khorsun via Firebird-devel
07.12.2017 16:23, Jiří Činčura wrote: Hi *, I'm getting, for quite some time, "Database is probably already opened by another engine instance in another Windows session" on servers (2x 2.5.7, 1x 3.0.3 (although it's less common here)). The problem is, that the database is only accessed via

Re: [Firebird-devel] Database opened in another session

2017-12-07 Thread Vlad Khorsun via Firebird-devel
07.12.2017 17:16, Jiří Činčura wrote: Nope. Still happening. Even with `-i`. Hmm... i was not attentive enough, error is about database not about listener. It means that one engine instance is already open database and another instance going to open it too and both instances runs in

Re: [Firebird-devel] Virtual table for time zones

2018-05-14 Thread Vlad Khorsun via Firebird-devel
10.05.2018 19:23, Adriano dos Santos Fernandes wrote: On 10/05/2018 13:12, Vlad Khorsun via Firebird-devel wrote:   I guess the question is about the case when users have historical data and need to apply old time zone rule to the old data and new timezone rule to the new data

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Vlad Khorsun via Firebird-devel
10.05.2018 19:02, Adriano dos Santos Fernandes wrote: On 10/05/2018 12:53, Lester Caine wrote: ... And how will the version of TZ data be handled! This is a key element that has screwed normalized data in the past, and some way to manage that normalized data needs to be included in the

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Vlad Khorsun via Firebird-devel
10.05.2018 19:02, Adriano dos Santos Fernandes wrote: On 10/05/2018 12:53, Lester Caine wrote: ... And how will the version of TZ data be handled! This is a key element that has screwed normalized data in the past, and some way to manage that normalized data needs to be included in the

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Vlad Khorsun via Firebird-devel
10.05.2018 19:23, Adriano dos Santos Fernandes wrote: On 10/05/2018 13:12, Vlad Khorsun via Firebird-devel wrote:   I guess the question is about the case when users have historical data and need to apply old time zone rule to the old data and new timezone rule to the new data

<    5   6   7   8   9   10   11   >