from:"Kovalenko Dmitry"

Re: [Firebird-devel] MacOS problem with dlclose

2022-01-22 Thread Kovalenko Dmitry

Hello Adriano,

If I understood correctly in this topic described same problem:

https://groups.google.com/g/firebird-support/c/oO9c_ppmfRg/m/-ukO9L37DQAJ

?

---
The problem with correct shutdown of module with shutdown function (or
component with "Dispose" method) is solved through counter of active calls.
Or counter of alive objects in case of OO-API.

I use this technology in my DLL servers.

Regards,
Dmitry Kovalenko

-Original Message-
From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] 
Sent: Friday, January 21, 2022 10:08 PM
To: For discussion among Firebird Developers

Subject: Re: [Firebird-devel] MacOS problem with dlclose

Hi Alex and Paul!

I see three way to resolve this:

On 10/01/2022 16:19, Adriano dos Santos Fernandes wrote:
> Hi!
> 
> As reported in #7041, MacOS build (even in Intel) is returning errors 
> after some time (1 min) used:
> 
> Authentication error
> connection shutdown
> 
> I had debugged the problem, it happens when plugin manager tries to 
> unload plugins.
> 
> When it calls dlclose no error is returned but library is not really 
> unloaded.
> 
> Next time it loads the plugin again, it is already in memory and the 
> memory is not reinitialized nor constructors run again. Only the 
> plugin entry point is called.
> 
> That makes things unusable.
> 
> I have tracked why it is not unloading.
> 
> There is two reasons for it:
> 1) Usage of framework APIs / Objective-C
> 2) Usage of __thread variables
> 
> 1) https://developer.apple.com/forums/thread/122591
> 2) 
> https://github.com/rust-lang/rust/issues/28794#issuecomment-368693049
> 
> In our code (1) is happening with mac_utils.m and (2) due to 
> HAVE___THREAD being defined.
> 
> I have tested fixing (2) changing fb_tls.h define:
> 
> -#if defined(HAVE___THREAD)
> +#if defined(HAVE___THREAD) && !defined(DARWIN)
> 
> And reverting mac_utils changes it worked.
> 
> There is also suspicious code in
> src/yvalve/config/os/darwin/config_root.cpp but it has not needed to 
> be changed.
> 
> I have not deeply tested why this works in v3. It seems to not try to 
> unload plugins.
> 
> 
> Adriano



Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [FB3] result type of negate operation

2021-10-10 Thread Kovalenko Dmitry

>>>   The question is whether result of negation should keep the type of 
>>> source or can it be expanded if needed.

>>Then it would need to expand for all types.

>And what would be an -INT128?

Result type must be same as result of expression "0-source"?

Note that in Dialect 1:

0-smallint -> integer
0-integer -> double

---
Dmitry Kovalenko



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB3] result type of negate operation

2021-10-09 Thread Kovalenko Dmitry

Hello,

 

FB3.0.8.22506 (Dialect 3)

 

Firebird defines a follow result types for Negate operation:

 

-SMALLINT_COLUMN has result type SMALLINT

-INTEGER_COLUMN has result type INTEGER

 

As result, I see a work like this:

 

SQL> create table TTT2 (COL_SMALLINT SMALLINT);

SQL> insert into TTT2 values(-32768);

 

SQL> select -COL_SMALLINT from TTT2;

 

===

Statement failed, SQLSTATE = 22003

Integer overflow.  The result of an integer operation caused the most
significant bit of the result to carry.

 

It is OK?

 

Dmitry Kovalenko.

Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-6496) string_to_datetime and '\0' symbol

2021-02-24 Thread Kovalenko Dmitry (JIRA)

string_to_datetime and '\0' symbol
--

 Key: CORE-6496
 URL: http://tracker.firebirdsql.org/browse/CORE-6496
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0.8
Reporter: Kovalenko Dmitry


string_to_datetime returns error when translates string like:

"2021-2-20\0"
"2021-2-20 1:2\0"
"2021-2-20 1:2:3\0"

but not have problems with translation of strings like:

"5.3.2021 01:02:03.1234\0"

-
Note that, Firebird can't translate to BOOLEAN the string with '\0' symbol (for 
example "TRUE\0").


-- 
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-6495) string_to_datetime and y2k problem

2021-02-24 Thread Kovalenko Dmitry (JIRA)

string_to_datetime and y2k problem
--

 Key: CORE-6495
 URL: http://tracker.firebirdsql.org/browse/CORE-6495
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0.8
Reporter: Kovalenko Dmitry
Priority: Minor


string_to_datetime has following code for correction of y2k problem (two-digit 
year):

tm times2;
Firebird::TimeStamp::getCurrentTimeStamp().decode();

// Handle defaulting of year

if (description[position_year] == 0) {
times.tm_year = times2.tm_year + 1900;
}
else if (description[position_year] <= 2)
{
// Handle conversion of 2-digit years
if (times.tm_year < (times2.tm_year - 50) % 100)
times.tm_year += 2000;
else
times.tm_year += 1900;
}

times.tm_year -= 1900;
times.tm_mon -= 1;

---
This code looks to the CURRENT year, but adjust the two-digit year number on 
1900 or 2000.

When current year will be more than 2050, this code will return strange result.


-- 
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-6494) Inconsistent translation "string->timestamp->string->timestamp" and first dialect

2021-02-24 Thread Kovalenko Dmitry (JIRA)

Inconsistent  translation "string->timestamp->string->timestamp" and first 
dialect
--

 Key: CORE-6494
 URL: http://tracker.firebirdsql.org/browse/CORE-6494
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0.8
    Reporter: Kovalenko Dmitry
Priority: Minor


Connection with first dialect.

SQL:
select cast(cast(cast(cast('2-DEC-0083' as TIMESTAMP) as varchar(64))as 
TIMESTAMP)as varchar(64))  from DUAL

RESULT:
2-DEC-1983

-- 
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-6481) Dialect 1. Not consistent result of two expressions with divide of NUMERIC with scale

2021-02-02 Thread Kovalenko Dmitry (JIRA)

Dialect 1. Not consistent result of two expressions with divide of NUMERIC with 
scale
-

 Key: CORE-6481
 URL: http://tracker.firebirdsql.org/browse/CORE-6481
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0.8
 Environment: Database with first dialect
Reporter: Kovalenko Dmitry
Priority: Minor


Not consistent result of two expressions with divide:

1. cast(2 as NUMERIC(2,  1)) / cast(3 as NUMERIC(2,0))

returns DOUBLE value: 0.6(6) without any information about scale

2. cast(cast(2 as NUMERIC(2,  1)) / cast(3 as NUMERIC(2,0)) AS VARCHAR(32))

returns VARCHAR value: 0.7

---
d:\Program_Files\Firebird_3_0_x64>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> CONNECT "inet4://localhost/d:\database\RAM\IBP_TEST_FB30_D1.GDB";
Database: "inet4://localhost/d:\database\RAM\IBP_TEST_FB30_D1.GDB", User: 
HOME4\DIMA
SQL> SET SQLDA_DISPLAY ON;
SQL> select cast(2 as NUMERIC(2,  1)) / cast(3 as NUMERIC(2,0)) from dual;

INPUT message field count: 0

OUTPUT message field count: 1
01: sqltype: 480 DOUBLE scale: 0 subtype: 0 len: 8
  :  name: DIVIDE  alias: DIVIDE
  : table:   owner:

 DIVIDE
===
 0.

SQL> select cast(cast(2 as NUMERIC(2,  1)) / cast(3 as NUMERIC(2,0)) AS 
VARCHAR(32)) from dual;

INPUT message field count: 0

OUTPUT message field count: 1
01: sqltype: 448 VARYING scale: 0 subtype: 0 len: 32 charset: 0 NONE
  :  name: CAST  alias: CAST
  : table:   owner:

CAST

0.7
-

-- 
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-6439) TIMESTAMP+-TIME

2020-11-09 Thread Kovalenko Dmitry (JIRA)

TIMESTAMP+-TIME
---

 Key: CORE-6439
 URL: http://tracker.firebirdsql.org/browse/CORE-6439
 Project: Firebird Core
  Issue Type: New Feature
  Components: Engine
Affects Versions: 3.0.7
Reporter: Kovalenko Dmitry


Hello,

Could you add support for the following expressions with TIMESTAMP and TIME?

SQL:
select CURRENT_TIMESTAMP-CURRENT_TIME from RDB$DATABASE

ERROR:
Dynamic SQL Error
expression evaluation not supported
Invalid data type for subtraction involving DATE, TIME or TIMESTAMP types

SQL:
select CURRENT_TIMESTAMP+CAST('01:00:00' AS TIME) from RDB$DATABASE

ERROR:
Dynamic SQL Error
expression evaluation not supported
Adding two DATE values or two TIME values is not allowed


-- 
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-6428) CAST( AS NOT NULL)

2020-10-23 Thread Kovalenko Dmitry (JIRA)

CAST( AS  NOT NULL)
--

 Key: CORE-6428
 URL: http://tracker.firebirdsql.org/browse/CORE-6428
 Project: Firebird Core
  Issue Type: New Feature
Reporter: Kovalenko Dmitry


Hello,

At current time Firebird does not allow expression like "CAST(ColumnName AS 
INTEGER NOT NULL)".

The expected behavior is generation of error for a NULL value.

This feature may be used in LINQ-translators for "Nullable.Value" 
expressions.

-- 
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-6406) Unexpected socket close [FB3 SS, TCP/IP]

2020-09-23 Thread Kovalenko Dmitry (JIRA)

Unexpected socket close [FB3 SS, TCP/IP]


 Key: CORE-6406
 URL: http://tracker.firebirdsql.org/browse/CORE-6406
 Project: Firebird Core
  Issue Type: Bug
Affects Versions: 3.0.7
 Environment: Windows, IBProvider test system, FB SS x64.
Reporter: Kovalenko Dmitry


Under multithreaded load test Firebird, time from time, closes INET-connection 
without any error/warning in own firebird.log

Server continues to work after these problems.

Work through own (builtin) IBProvider client for Firebird.

Examples of error messages:

-- 1.

[THR:036728] [24.09.2020 05:24:10] ERROR: 
[octets.003.blob.asynch.cmd.BIN_BLOB_TABLE.BIN_DATA.len_131073.bind__bytes] 
Execution of command
1. [LCPI.IBProvider.5]: Ошибка формирования ib-значения входящего параметра. 
Позиция 0.

[winsock][BUG CHECK] Чтение из закрытого порта подключения. Ошибка WinSock: 0.
2. [LCPI.IBProvider.5]: Ошибка формирования ib-значения входящего параметра. 
Позиция 0.

Запись BLOB: Ошибка записи данных.
Неопознанная ошибка

-- 2.

[THR:040972] [23.09.2020 15:54:10] ERROR: 
[blob.002.change_rs.unicode.TBL_CS__FSS.COL_BLOB.bind__iunknown__ibp_ss_wc.large.len_65536.chars_WIN1251.ins_UTF8.sel_UTF8.block_256]
 Insert row
1. [LCPI.IBProvider.5]: Ошибка формирования ib-значения входящего параметра. 
Позиция 1.

[winsock][BUG CHECK] Чтение из закрытого порта подключения. Ошибка WinSock: 0.
2. [LCPI.IBProvider.5]: Ошибка формирования ib-значения входящего параметра. 
Позиция 1.

Запись BLOB: Ошибка записи данных.
3. [LCPI.IBProvider.5]: [IBP.SS] Ошибка выполнения служебного запроса [0].
4. [LCPI.IBProvider.5]: [IBP.SS] [изменение базы] Ошибка добавления ряда.
Неопознанная ошибка

COM Error Code: E_FAIL

-- 3.

[THR:040972] [23.09.2020 17:27:30] [test] TRY SET FIELD 
"COL_TEXT_BLOB"=IUNKNOWN[S_OK][0x024660E8, 
{769A128F-04BF-11D8-AE8B-00A0C907DB93}] ...
[THR:040972] [23.09.2020 17:27:39] [test] OK - we receive error:
[THR:040972] [23.09.2020 17:27:39] [test] Update row
1. [LCPI.IBProvider.5]: Ошибка формирования ib-значения входящего параметра. 
Позиция 0.

[winsock][BUG CHECK] Чтение из закрытого порта подключения. Ошибка WinSock: 0.
2. [LCPI.IBProvider.5]: Ошибка формирования ib-значения входящего параметра. 
Позиция 0.

Запись BLOB: Ошибка записи данных.
3. [LCPI.IBProvider.5]: [IBP.SS] Ошибка выполнения служебного запроса [0].
4. [LCPI.IBProvider.5]: [IBP.SS] [изменение базы] Ошибка обновления ряда.

-- 4. [ just for collection - error 10054]

[THR:023940] [21.09.2020 23:07:29] ERROR: [icr.04.all2/task__2434.direct] 
Preparing a command
1. [LCPI.IBProvider.5]: [winsock] Сбой чтения данных из порта подключения. 
Ошибка WinSock: 10054.
2. [LCPI.IBProvider.5]: Ошибка подготовки SQL выражения.
Неопознанная ошибка

COM Error Code: E_FAIL


-- 
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-6293) ISQL does not process (not extract) hex string of external SP body

2020-05-01 Thread Kovalenko Dmitry (JIRA)

ISQL does not process (not extract) hex string of external SP body
--

 Key: CORE-6293
 URL: http://tracker.firebirdsql.org/browse/CORE-6293
 Project: Firebird Core
  Issue Type: Bug
  Components: ISQL
Affects Versions: 3.0.6
Reporter: Kovalenko Dmitry
Priority: Minor


Source code:
 CREATE PROCEDURE UDR__GEN_ROWS_05
 (START_N INTEGER NOT NULL,
 END_N INTEGER NOT NULL)
 RETURNS
 (N INTEGER NOT NULL)
 EXTERNAL NAME 'udrcpp_example.dll!gen_rows'
 ENGINE UDR
 AS x'000100';

ISQL extacts:

ALTER PROCEDURE UDR__GEN_ROWS_05 (START_N INTEGER NOT NULL,
END_N INTEGER NOT NULL)
RETURNS (N INTEGER NOT NULL)
EXTERNAL NAME 'udrcpp_example.dll!gen_rows'
ENGINE UDR
AS ''


-- 
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-6246) [fbclient] Problem with too many number of columns in resultset.

2020-02-14 Thread Kovalenko Dmitry (JIRA)

[fbclient] Problem with too many number of columns in resultset.


 Key: CORE-6246
 URL: http://tracker.firebirdsql.org/browse/CORE-6246
 Project: Firebird Core
  Issue Type: Bug
  Components: API / Client Library
Affects Versions: 3.0.5
Reporter: Kovalenko Dmitry


First query:
 select x1.RDB$FIELD_NAME from RDB$FIELDS as x1

fbclient.dll returns subtype=3 for first column

Second query:
 select x1.RDB$FIELD_NAME, x1.RDB$FIELD_NAME, /*100500 raz*/ 
,x1.RDB$FIELD_NAME from RDB$FIELDS as x1

fbclient.dll (isc_dsql_describe) returns subtype=0 for first column.


-- 
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-6224) [AV] Re-destruction of the rem_port object

2020-01-13 Thread Kovalenko Dmitry (JIRA)

[AV] Re-destruction of the rem_port object
--

 Key: CORE-6224
 URL: http://tracker.firebirdsql.org/browse/CORE-6224
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0.5
 Environment: Test of IBProvider builtin client for Firebird.
Reporter: Kovalenko Dmitry


FB3.0.5.33225 x64 SuperServer.

Connection through TCP/IP.

---
Under mt-tesing of IBProvider builtin client for Firebird, Firebird crash on 
the destroy of rem_port object.

This is a reproducible problem on the "clear" build of server.

Run parameters [for history]
target\vs2019-x64-Debug\test_db_client_fb_1.exe   /thread_count 10 /auto 
/log_dir _logs /log_file_prefix fb03-0-4 /inet_host HOME4 /db 
d:\database\ram\ibp_test_fb30_d3.gdb /db_user GAMER /db_password vermut 
/new_db_dir d:\database\ram\ /isc_api_library fbclient_30.dll /cn_str 
"remote:protocol_arch=symmetric,generic;remote:wire_compression=required" /dbms 
"FB-3" /test RemoteFB.WORK.019.StmtExecute.*

 [The "best" case of crash]

I made some changes in FB sources for better undertand of problem.

CRASH THREAD [ID 31192 - not sure at current time]

virtual int release() const
{
fb_assert(m_refCnt.value() > 0); //<- HERE

STACK:
firebird.exe!fb_assert_impl(const char * msg, const char * file, int 
line, bool do_abort)Строка 48  C++
>   firebird.exe!Firebird::RefCounted::release()Строка 45   C++
firebird.exe!rem_port::release()Строка 1162 C++
firebird.exe!Firebird::RefPtr::assign(rem_port * const 
p)Строка 276   C++
firebird.exe!Firebird::RefPtr::operator=(rem_port * p)Строка 
182  C++
firebird.exe!server_req_t::~server_req_t()Строка 130C++
firebird.exe!server_req_t::`scalar deleting destructor'(unsigned int)   
C++
firebird.exe!loopThread(void * __formal)Строка 6180 C++
firebird.exe!`anonymous namespace'::ThreadArgs::run()Строка 78  C++
firebird.exe!threadStart(void * arg)Строка 97   C++
ucrtbased.dll!thread_start(void * 
const parameter)Строка 97  C++
kernel32.dll!BaseThreadInitThunk()  Нет данных
ntdll.dll!RtlUserThreadStart()  Нет данных

LOCAL VARIABLES:
-   this0x008ca1d0 {m_refCnt={...} 
m_debug__WAS_DELETED=-572662307 }const Firebird::RefCounted *
+   __vfptr 0x {???, ???, ???}  void * *
-   m_refCnt{...}   Firebird::AtomicCounter
+   Firebird::PlatformAtomicCounter {counter=-2459565876494606883 } 
Firebird::PlatformAtomicCounter
m_debug__WAS_DELETED-572662307  long
refCnt  -858993460  const int

NOTE ON THE this - is is 0x008ca1d0

-- TRACE INFORMATION, WHICH WAS CREATED __BEFORE__ CRASH:

It is dirrect call of rem_port::release from "static void disconnect(rem_port* 
const port)" (inet.cpp). Decrement from 2 to 1.

REM_PORT_RLS - 0x008ca1d0. TID: 31192. R: 1. STACK:
firebird.exe!rem_port::release
firebird.exe!disconnect
firebird.exe!rem_port::disconnect
firebird.exe!rem_port::disconnect
firebird.exe!process_packet
firebird.exe!loopThread
firebird.exe!`anonymous namespace'::ThreadArgs::run
firebird.exe!threadStart
ucrtbased.dll!thread_start
kernel32.dll!BaseThreadInitThunk
ntdll.dll!RtlUserThreadStart

It is destroy of rem_port object. Decrement from 1 to 0.

REM_PORT_DCR - 0x008ca1d0. TID: 31192. STACK:
firebird.exe!rem_port::~rem_port
firebird.exe!rem_port::`scalar deleting destructor'
firebird.exe!Firebird::RefCounted::release
firebird.exe!rem_port::release
firebird.exe!Firebird::RefPtr::~RefPtr
firebird.exe!DecrementRequestsQueued::~DecrementRequestsQueued
firebird.exe!process_packet
firebird.exe!loopThread
firebird.exe!`anonymous namespace'::ThreadArgs::run
firebird.exe!threadStart
ucrtbased.dll!thread_start
kernel32.dll!BaseThreadInitThunk
ntdll.dll!RtlUserThreadStart


-- 
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-6221) Incorrect (throw-based) alloFunc for zlib1. Possible memory leak.

2020-01-10 Thread Kovalenko Dmitry (JIRA)

Incorrect (throw-based) alloFunc for zlib1. Possible memory leak.
-

 Key: CORE-6221
 URL: http://tracker.firebirdsql.org/browse/CORE-6221
 Project: Firebird Core
  Issue Type: Bug
Affects Versions: 3.0.5
Reporter: Kovalenko Dmitry


https://www.zlib.net/manual.html

Usage of z_stream_s structure: zalloc must return Z_NULL if there is not enough 
memory for the object.

Firebird code, if I understood correctly, assign to zalloc throw-based 
allocation func:

void* allocFunc(void*, uInt items, uInt size)
{
return MemoryPool::globalAlloc(items * size ALLOC_ARGS); //thow ?
}

In deflateInit, for example, has five calls of zalloc functions and has 
rollback of initialization if second (and next) call of zalloc return nullptr.


-- 
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-6217) [inet.cpp] Wrong work with pointer: delete ptr; ptr=new ;

2020-01-07 Thread Kovalenko Dmitry (JIRA)

[inet.cpp] Wrong work with pointer: delete ptr; ptr=new ;
-

 Key: CORE-6217
 URL: http://tracker.firebirdsql.org/browse/CORE-6217
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0.5
Reporter: Kovalenko Dmitry


inet.cpp, line 835-839

if (host.hasData())
{
delete port->port_connection;
port->port_connection = REMOTE_make_string(host.c_str());
}

REMOTE_make_string may throw exception and "delete port->port_connection" will 
hold pointer to released (deleted) memory block.

Please assign nullptr to delete port->port_connection after delete operation:

if (host.hasData())
{
delete port->port_connection;
port->port_connection=nullptr;
port->port_connection = REMOTE_make_string(host.c_str());
}


-- 
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-6063) FB3 (protocol 13) returns op_accept instead op_accept_data

2019-05-14 Thread Kovalenko Dmitry (JIRA)

FB3 (protocol 13) returns op_accept instead op_accept_data
--

 Key: CORE-6063
 URL: http://tracker.firebirdsql.org/browse/CORE-6063
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 4.0 Beta 1, 3.0.4, 3.0.3, 3.0.2, 3.0.1, 3.0.0, 4.0 
Initial, 3.0.5, 4.0 Beta 2
Reporter: Kovalenko Dmitry


This problem was detected by IBProvider builtin client to Firebird (not by 
fbclient.dll).

Reproductions:

1. Server config:

AuthServer=Legacy_Auth, Win_SSpi, Srp
WireCrypt=enabled

2. Client config:

AuthClient=Legacy_Auth, Win_SSpi, Srp
WireCrypt=disabled

3. Create NEW used "DBA-SRP" through SRP plugin:

CREATE USER "DBA-SRP" PASSWORD 'masterkey' USING PLUGIN Srp;

4. Connect to database with "DBA-SRP"

5. Server returns op_accept instead op_accept_data.

The problem located in static bool accept_connection(rem_port* port, P_CNCT* 
connect, PACKET* send):

case IAuth::AUTH_CONTINUE:
HANDSHAKE_DEBUG(fprintf(stderr, "AUTH_CONTINUE\n"));
// try next plugin
plugins->next();
if (!plugins->hasData())
{
// failed
setErrorStatus();
accepted = false;
loginFail(port->port_login, port->getRemoteId());
break;
}
port->port_srv_auth_block->setPluginName(plugins->name());

port->port_srv_auth_block->extractPluginName(>p_acpd.p_acpt_plugin);

/* BUG FIX */ returnData = true; // <-- You forgot setup this 
flag

break;


This code (by designe) should return the name of next auth-plugin. But does not 
return, because returnData was not set to true.



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

Re: [Firebird-devel] FB3 and op_accept answer

2019-05-14 Thread Kovalenko Dmitry

Reproduction (FB3.0.3, Windows).

1. Server config:

WireCrypt=Enabled

AuthServer = Legacy_Auth, Win_SSpi, Srp

2. CREATE USER "DBA-SRP" PASSWORD 'masterkey' USING PLUGIN Srp;

3. "Client config":

AuthClient= Legacy_Auth, Srp

WireCrypt=Disabled

4. Connect to database (P13) with USER ID=DBA-SRP

My client (in IBProvider) obtain a packet with ID: 3 (op_accept). I think,
it is incorrect.

Regards,
Dmitry Kovalenko
www.ibprovider.com

-Original Message-
From: Mark Rotteveel [mailto:m...@lawinegevaar.nl] 
Sent: Sunday, May 12, 2019 9:02 AM
To: firebird-devel@lists.sourceforge.net
Subject: Re: [Firebird-devel] FB3 and op_accept answer

On 11-5-2019 18:39, Kovalenko Dmitry wrote:
> Hello.
> 
> Which conditions required for obtain the op_accept packet during
connection?
> 
> I tried different settings, but see only op_accept_data or 
> op_cond_accept packets.

As far as I'm aware, you will only get op_accept when connecting with
v12 or lower protocols (so when connecting to Firebird 2.5 or earlier).

Mark
--
Mark Rotteveel


Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] FB3 and op_accept answer

2019-05-12 Thread Kovalenko Dmitry

Hello,

Sorry for my question with minimal information :)

I connect with definition of exact protocol version (13).

Looking to this code:

https://github.com/FirebirdSQL/firebird/blob/05e090539d428cb82f621b8b9bd14b4
3c2445b03/src/remote/server/server.cpp#L1983-L1997

For me - before "break;" should be " returnData = true; "

--
case IAuth::AUTH_CONTINUE:
HANDSHAKE_DEBUG(fprintf(stderr, "AUTH_CONTINUE\n"));
// try next plugin
plugins->next();
if (!plugins->hasData())
{
// failed
setErrorStatus();
accepted = false;
loginFail(port->port_login, port->getRemoteId());
break;
}
port->port_srv_auth_block->setPluginName(plugins->name());

port->port_srv_auth_block->extractPluginName(>p_acpd.p_acpt_plugin);

returnData = true; //<- YES?

break;
--

Regards,
Dmitry Kovalenko
www.ibprovider.com

-Original Message-
From: Mark Rotteveel [mailto:m...@lawinegevaar.nl] 
Sent: Sunday, May 12, 2019 9:02 AM
To: firebird-devel@lists.sourceforge.net
Subject: Re: [Firebird-devel] FB3 and op_accept answer

On 11-5-2019 18:39, Kovalenko Dmitry wrote:
> Hello.
> 
> Which conditions required for obtain the op_accept packet during
connection?
> 
> I tried different settings, but see only op_accept_data or 
> op_cond_accept packets.

As far as I'm aware, you will only get op_accept when connecting with
v12 or lower protocols (so when connecting to Firebird 2.5 or earlier).

Mark
--
Mark Rotteveel


Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] FB3 and op_accept answer

2019-05-11 Thread Kovalenko Dmitry

Hello.

 

Which conditions required for obtain the op_accept packet during connection?

 

I tried different settings, but see only op_accept_data or op_cond_accept
packets.

 

Thanks,

Dmitry Kovalenko

www.ibprovider.com  

 

Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] CURRENT_DATE in 1 dialect

2019-03-26 Thread Kovalenko Dmitry

Hello

 

FB3, database with 1 dialect.

 

I try to execute:

 

select CAST(CURRENT_DATE AS TIMESTAMP) from RDB$DATABASE

 

and see  an error:

 

Dynamic SQL Error.

SQL error code = -104.

Client SQL dialect 1 does not support reference to DATE datatype.

 

For my point of view - server should prevent return DATE to client. Within,
server may work with DATE without any problem.

 

I know about "CAST('TODAY' AS TIMESTAMP)", question about CURRENT_DATE :)

 

Thanks,

Dmitry Kovalenko

www.ibprovider.com

Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] isc_database_info and current database user

2019-02-28 Thread Kovalenko Dmitry

> Can you explain - what a problem with use of SQL to get that data?

Need start (and commit) implicit transaction.

For me - it is not good behavior of provider.

Dmitry Kovalenko.



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] isc_database_info and current database user

2019-02-28 Thread Kovalenko Dmitry

> select current_user from rdb$database

Usage of similar queries is not good idea for connection provider.

It is problem to added new info-tags (current_user and, may be,
current_role) for isc_database_info in FB3.0.5?

>From my side I will added the special support for these new tags into my
provider.

Dmitry Kovalenko.



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] isc_database_info and current database user

2019-02-27 Thread Kovalenko Dmitry

Hello,

 

Could anybody tell me - how I can get name of current user through
isc_database_info API function?

 

I see isc_info_user_names.

 

But I want to get the only one name.

 

Thanks,

Dmitry Kovalenko.

Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Introducing Firebird Butler

2019-01-31 Thread Kovalenko Dmitry

>We are pleased to announce a significant extension of the Firebird project
to a whole new area 

Copy -> Paste into Google Translate -> Hmm -> Return to Work.

Regards,
Dmitry Kovalenko
www.ibprovider.com
https://www.nuget.org/packages/lcpi.data.oledb/




Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] NULL and/or true/false

2018-10-01 Thread Kovalenko Dmitry

Hello Mark and Denis,

>> Just – yes or no :)

>Yes, and verified against SQL:2016.
>

Thank :)

Dmitry Kovalenko



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] NULL and/or true/false

2018-10-01 Thread Kovalenko Dmitry

Hello,

 

Firebird 3.0.4

 

Could anybody (Adriano?) confirm, that next result is corrected:

 

select

null   or trueas c4__null_or_true,  /*  TRUE */

null   or false   as c5__null_or_false,   /* NULL */

null   and true   as c6__null_and_true, /* NULL */

null   and false  as c7__null_and_false /* FALSE */

from rdb$database

 

Just - yes or no :)

 

Thanks,

Dmitry Kovalenko

 

Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5932) Usage of "BLOB SUB_TYPE TEXT" for "free" parameters

2018-10-01 Thread Kovalenko Dmitry (JIRA)

Usage of "BLOB SUB_TYPE TEXT" for "free" parameters
---

 Key: CORE-5932
 URL: http://tracker.firebirdsql.org/browse/CORE-5932
 Project: Firebird Core
  Issue Type: Improvement
  Components: Engine
Affects Versions: 3.0.4
    Reporter: Kovalenko Dmitry


Test code:


 cmd.CommandText
  ="SELECT \"r\".\"TEST_ID\", \"r\".\"COL_VARCHAR_10\"\n"
  +"FROM \"TEST_MODIFY_ROW\" AS \"r\"\n"
  +"WHERE (:__src_0||\"r\".\"COL_VARCHAR_10\" STARTING WITH _utf8 'Q') AND 
(\"r\".\"TEST_ID\" = :__testID_1)";

 cmd.Prepare();

 Assert.AreEqual
  (1, //<---  USUS
   cmd["__src_0"].Size);


Server describes "__src_0" as parameter with datatype "(var)char(1)".

I offer to use a "BLOB (SUB_TYPE TEXT)" datatype.


-- 
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-5920) SUBSTRING does not support parameters for startPos and length

2018-09-22 Thread Kovalenko Dmitry (JIRA)

SUBSTRING does not support parameters for startPos and length
-

 Key: CORE-5920
 URL: http://tracker.firebirdsql.org/browse/CORE-5920
 Project: Firebird Core
  Issue Type: Improvement
Affects Versions: 3.0.4
Reporter: Kovalenko Dmitry


Server can't prepare SQL:

SELECT *
FROM "TEST_MODIFY_ROW" AS "r"
WHERE SUBSTRING("r"."COL_VARCHAR_10" FROM :__vv1_0 FOR :__vv2_1) = _utf8 'G'

Error message: "expression evaluation not supported".

-- 
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-5919) REPLACE and charset of third parameter

2018-09-21 Thread Kovalenko Dmitry (JIRA)

REPLACE and charset of third parameter
--

 Key: CORE-5919
 URL: http://tracker.firebirdsql.org/browse/CORE-5919
 Project: Firebird Core
  Issue Type: Bug
Affects Versions: 3.0.4
Reporter: Kovalenko Dmitry


Connection charset: win1251

CREATE TABLE TEST_MODIFY_ROW (
TEST_IDT_TEST_ID NOT NULL /* T_TEST_ID = BIGINT */,
COL_VARCHAR_10 T_VARCHAR_10 /* T_VARCHAR_10 = VARCHAR(10), CHARSET: 
WIN1251 */,
);

For query1
SELECT "r"."TEST_ID", "r"."COL_VARCHAR_10" FROM "TEST_MODIFY_ROW" AS "r"
WHERE (POSITION(REPLACE("r"."COL_VARCHAR_10", 'ABC', :__vv_0), 
"r"."COL_VARCHAR_10") > 0) AND ("r"."TEST_ID" = :__8__locals1_testID_1)

Server returns that "__vv_0" parameter has NON OCTETS charset.

For query2:
SELECT "r"."TEST_ID", "r"."COL_VARCHAR_10" FROM "TEST_MODIFY_ROW" AS "r"
WHERE (POSITION(REPLACE("r"."COL_VARCHAR_10", 'ABC'||x'00'||'123', :__vv_0), 
"r"."COL_VARCHAR_10") > 0) AND ("r"."TEST_ID" = :__8__locals1_testID_1)

Server returns that "__vv_0" parameter has OCTETS charset.

Difference of these queries in second parameter of REPLACE: 'ABC' and 
'ABC'||x'00'||'123'.

For me - in second query parameter "__vv_0" should has NON OCTETS charset.

Could anybody confirm this behaviour and explain the reason?


-- 
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-5693) EXTRACT(QUARTER FROM )

2018-01-03 Thread Kovalenko Dmitry (JIRA)

EXTRACT(QUARTER FROM )
--

 Key: CORE-5693
 URL: http://tracker.firebirdsql.org/browse/CORE-5693
 Project: Firebird Core
  Issue Type: New Feature
  Components: Engine
Affects Versions: 3.0.3
Reporter: Kovalenko Dmitry


I'm surprised that Firebird (v3) still not support QUARTER in EXTRACT statement.

It has a serious reason?

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



--
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 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5632) SuperServer FB3 has entered in infinite loop (hang up)

2017-10-09 Thread Kovalenko Dmitry (JIRA)

SuperServer FB3 has entered in infinite loop (hang up)
--

 Key: CORE-5632
 URL: http://tracker.firebirdsql.org/browse/CORE-5632
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0.3
 Environment: Windows 10 Pro x64, 6950x/128GB, FB3 SuperServer x64, 
IBProvider Test System.
Reporter: Kovalenko Dmitry


- Firebird 3.0.3.32802 x64 (SuperServer)
- Connection through TCP/IP (localhost)

Server has entered in infinite loop(?) in one own thread (ID: 24436)

I waited 24 hours.

At client side (multithreaded test system) all test threads wait the answer 
from server:
 - 1 thread wait answer for COMMIT_TR
 - 3 threads wait answers for START_TR
 - 7 threads wait answers for DETACH_DB

Sources, dumps, binaries ...: http://dropmefiles.com/h0au4  (valid within 14 
days)

Stack of thread with infinite loop (24436)
>   engine12.dll!Jrd::LockManager::find_lock(unsigned short series, const 
> unsigned char * value, unsigned short length, unsigned short * slot) Line 
> 2129C++ Symbols loaded.
engine12.dll!Jrd::LockManager::enqueue(Jrd::thread_db * tdbb, 
Firebird::CheckStatusWrapper * statusVector, long prior_request, const unsigned 
short series, const unsigned char * value, const unsigned short length, 
unsigned char type, int(*)(void *) ast_routine, void * ast_argument, __int64 
data, short lck_wait, long owner_offset) Line 581C++ Symbols loaded.
engine12.dll!enqueue(Jrd::thread_db * tdbb, 
Firebird::CheckStatusWrapper * statusVector, Jrd::Lock * lock, unsigned short 
level, short wait) Line 934   C++ Symbols loaded.
[Inline Frame] engine12.dll!ENQUEUE(Jrd::thread_db *) Line 149  C++ 
Symbols loaded.
engine12.dll!LCK_lock(Jrd::thread_db * tdbb, Jrd::Lock * lock, unsigned 
short level, short wait) Line 663   C++ Symbols loaded.
engine12.dll!transaction_start(Jrd::thread_db * tdbb, Jrd::jrd_tra * 
trans) Line 3259   C++ Symbols loaded.
engine12.dll!TRA_start(Jrd::thread_db * tdbb, int tpb_length, const 
unsigned char * tpb, Jrd::jrd_tra * outer) Line 1715C++ Symbols 
loaded.
engine12.dll!start_transaction(Jrd::thread_db * tdbb, bool 
transliterate, Jrd::jrd_tra * * tra_handle, Jrd::Attachment * attachment, 
unsigned int tpb_length, const unsigned char * tpb) Line 7848  C++ 
Symbols loaded.

engine12.dll!Jrd::JAttachment::startTransaction(Firebird::CheckStatusWrapper * 
user_status, unsigned int tpbLength, const unsigned char * tpb) Line 4195   
 C++ Symbols loaded.

engine12.dll!Firebird::IAttachmentBaseImpl<Jrd::JAttachment,Firebird::CheckStatusWrapper,Firebird::IReferenceCountedImpl<Jrd::JAttachment,Firebird::CheckStatusWrapper,Firebird::Inherit<Firebird::IVersionedImpl<Jrd::JAttachment,Firebird::CheckStatusWrapper,Firebird::Inherit
 > > > >::cloopstartTransactionDispatcher(Firebird::IAttachment * self, 
Firebird::IStatus * status, unsigned int tpbLength, const unsigned char * tpb) 
Line 8654C++ Symbols loaded.
[Inline Frame] 
fbclient.dll!Firebird::IAttachment::startTransaction(Firebird::CheckStatusWrapper
 *) Line 1827   C++ Symbols loaded.

fbclient.dll!Why::YAttachment::startTransaction(Firebird::CheckStatusWrapper * 
status, unsigned int tpbLength, const unsigned char * tpb) Line 5070 C++
 Symbols loaded.

fbclient.dll!Firebird::IAttachmentBaseImpl<Why::YAttachment,Firebird::CheckStatusWrapper,Firebird::IReferenceCountedImpl<Why::YAttachment,Firebird::CheckStatusWrapper,Firebird::Inherit<Firebird::IVersionedImpl<Why::YAttachment,Firebird::CheckStatusWrapper,Firebird::Inherit
 > > > >::cloopstartTransactionDispatcher(Firebird::IAttachment * self, 
Firebird::IStatus * status, unsigned int tpbLength, const unsigned char * tpb) 
Line 8654C++ Symbols loaded.
[Inline Frame] 
firebird.exe!Firebird::IAttachment::startTransaction(Firebird::CheckStatusWrapper
 *) Line 1827   C++ Symbols loaded.
firebird.exe!rem_port::start_transaction(P_OP operation, p_sttr * 
stuff, packet * sendL) Line 5849  C++ Symbols loaded.
firebird.exe!process_packet(rem_port * port, packet * sendL, packet * 
receive, rem_port * * result) Line 4398   C++ Symbols loaded.
firebird.exe!loopThread(void * __formal) Line 5954  C++ Symbols 
loaded.
[Inline Frame] firebird.exe!`anonymous-namespace'::ThreadArgs::run() 
Line 78C++ Symbols loaded.
firebird.exe!threadStart(void * arg) Line 93C++ Symbols loaded.


-- 
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 informa

Re: [Firebird-devel] Unload of fbclient.dll (v3)

2017-10-02 Thread Kovalenko Dmitry

>> Could anybody confirm this behavior of FB3 client library?

>Please add big delay (120 sec should be enough) after last attachment
closed before unloading client library. Does it unload in such case?

  {
   ::Sleep(120*1000);

   _VERIFY(::FreeLibrary(m_hDLL));
  }

Not help. Fbclient (fbclient_30.dll) still present in memory.

My test is simple:

1. Load DLL
2. Connect to database through tcp/ip protocol
3. Detach from database

4. Unload DLL

Regards,
Dmitry Kovalenko



--
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 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Unload of fbclient.dll (v3)

2017-10-02 Thread Kovalenko Dmitry

Hello,

 

fbclient.dll (from FB3) not unload when I call ::FreeLibrary.

 

fbclient.dll (from FB2.5) unloads without problems.

 

Could anybody confirm this behavior of FB3 client library?

 

Thanks,

Dmitry Kovalenko

www.ibprovider.com

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] FB3 ICU (v52)

2017-07-21 Thread Kovalenko Dmitry

Adriano, could you upload to https://github.com/FirebirdSQL the source code
of ICU from FB3?

 

Thanks,

Dmitry Kovalenko

www.ibprovider.com

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] RFC: Timeouts

2017-02-25 Thread Kovalenko Dmitry

>But, client side already can set it own timer and cancel the statement.

At current time, you may forget about cancel of operation. Because it works
incorrectly.

Dmitry Kovalenko.


--
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 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

2017-01-05 Thread Kovalenko Dmitry (JIRA)

[FB3 SC] Server hangs (under load test)
---

 Key: CORE-5436
 URL: http://tracker.firebirdsql.org/browse/CORE-5436
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0.2
 Environment: Firebird 3.0.2.32651 SuperClassic x64, Win10, IBProvider 
Test System.
Reporter: Kovalenko Dmitry


SuperClassic hangs under load test.

---
Two test processes (with 4 test theads) with own (two) databases.

All test threads are waiting the answer from "database attach" operation.

- [Error at client side]
[THR:001544] [05.01.2017 11:44:09] [test] Verify Arrays 
[TBL_CS__NONE::CHAR_ARRAY__8]. ArrayRwMode: direct. BindArrayType: 
array_iunknown__ibp_ss_wc. CType:UNICODE_FSS Truncate Char: false
[THR:001544] [05.01.2017 11:44:29] ERROR: 
[array.002.rw_api.build_mode__use_cmd.unicode.TBL_CS__NONE.CHAR_ARRAY__8.chars__WIN1251.write__array_iunknown__ibp_ss_wc.ctype__UTF8]
 Data Source initialization
1. [Unknown DBMS]: Error occurred during login, please check server 
firebird.log for details
2. [LCPI.IBProvider.3]: Ошибка подключения к базе данных.
Неопознанная ошибка

COM Error Code: E_FAIL

- [Error in firebird.log]
HOME4   Thu Jan  5 11:44:19 2017
Database: D:\PROGRAM_FILES\FIREBIRD_3_0_X64\SECURITY3.FDB
page 0, page type 1 lock denied (216)


HOME4   Thu Jan  5 11:44:29 2017
Database: 
page 0, page type 1 lock denied (216)


HOME4   Thu Jan  5 11:44:29 2017
Authentication error
page 0, page type 1 lock denied

--
Dump file, Sources, PDB, EXE, DLL - http://dropmefiles.com/qlTUB

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

   

--
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 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Wire protocol changes in Firebird 4?

2016-12-30 Thread Kovalenko Dmitry

>4) Knowledge of total length of packet is required only for current parser
which need full packet to be in single buffer. If rewrite parser to use
stateful automate, total length is needless.

No. It need for resolve a problem with cancelation of operations.

http://tracker.firebirdsql.org/browse/CORE-5152

Dmitry Kovalenko


--
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 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Wire protocol changes in Firebird 4?

2016-12-30 Thread Kovalenko Dmitry

>From my point of view, protocol must be rewrited

At minimum:
1. The each packet should contain the field with own size.
2. It is necessary to solve the problems with LazySend mode.

Dmity Kovalenko
www.ibprovider.com

-Original Message-
From: Mark Rotteveel [mailto:m...@lawinegevaar.nl] 
Sent: Monday, December 19, 2016 8:51 PM
To: For discussion among Firebird Developers

Subject: [Firebird-devel] Wire protocol changes in Firebird 4?

Are there any wire protocol changes in Firebird 4 (or planned for Firebird
4). And if so, where can I find information on those changes?

Mark
--
Mark Rotteveel


--
Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon
Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today.http://sdm.link/intel Firebird-Devel mailing list,
web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel


--
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 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [B3_0_Release] Can't compile in VS2015.

2016-12-29 Thread Kovalenko Dmitry

1>-- Build started: Project: engine12, Configuration: Debug Win32 --

1>DdlNodes.obj : warning LNK4075: ignoring '/EDITANDCONTINUE' due to
'/SAFESEH' specification

1> Creating library ..\..\..\temp\Win32\Debug\engine12\engine12.lib and
object ..\..\..\temp\Win32\Debug\engine12\engine12.exp

1>lck.obj : error LNK2019: unresolved external symbol "public: static
unsigned int __cdecl Firebird::InternalHash::hash(unsigned int,unsigned char
const *)" (?hash@InternalHash@Firebird@@SAIIPBE@Z) referenced in function
"public: static unsigned int __cdecl Firebird::InternalHash::hash(unsigned
int,unsigned char const *,unsigned int)"
(?hash@InternalHash@Firebird@@SAIIPBEI@Z)

1>HashJoin.obj : error LNK2001: unresolved external symbol "public: static
unsigned int __cdecl Firebird::InternalHash::hash(unsigned int,unsigned char
const *)" (?hash@InternalHash@Firebird@@SAIIPBE@Z)

1>lock.obj : error LNK2001: unresolved external symbol "public: static
unsigned int __cdecl Firebird::InternalHash::hash(unsigned int,unsigned char
const *)" (?hash@InternalHash@Firebird@@SAIIPBE@Z)

1>..\..\..\temp\Win32\Debug\firebird\plugins\engine12.dll : fatal error
LNK1120: 1 unresolved externals

 

--

Dmitry Kovalenko

--
Check out the vibrant tech community on one of the world's most 
engaging tech sites, SlashDot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5425) [FB3] Server hang

2016-12-18 Thread Kovalenko Dmitry (JIRA)

[FB3] Server hang
-

 Key: CORE-5425
 URL: http://tracker.firebirdsql.org/browse/CORE-5425
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0.2
 Environment: FB 3.0.2.32644 SS x64, Win10 Pro Rus, 6950X/128GB, 
IBProvider Test System.
Reporter: Kovalenko Dmitry
 Attachments: FB_states.7z

Firebird server hangs under load tests

I launched 3 test processes with 4 test threads and own (3) databases.

Connection through fbclient.dll and INET

Firebird SRC, DUMP, EXE/DLL, PDB - http://dropmefiles.com/C61nz

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



--
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 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5416) [FB3] Memory Leaks. FB does not release memory after load tests.

2016-12-09 Thread Kovalenko Dmitry (JIRA)

[FB3] Memory Leaks. FB does not release memory after load tests.


 Key: CORE-5416
 URL: http://tracker.firebirdsql.org/browse/CORE-5416
 Project: Firebird Core
  Issue Type: Bug
Affects Versions: 3.0.2
 Environment: FB 3.0.2.32641 SuperServer x64, Win10 x64 Pro, IBProvider 
Test System
Reporter: Kovalenko Dmitry
 Attachments: fb_image.png, fb_performance.png

Firebird does not release memory after completion of load tests.

Size of each memory leaks ~ equal to size of page cache

One interest moment:
1. When I execute (sequential) two "load tests set" without pause - FB not 
releases memory after second set.
@call run_test_w64_local2_d3.bat
@call run_test_w32_local2_d3.bat

Memory leak (approximately) == 3.5 GB

2. When I added a pause (10 min) between runs - I see 2xLeaks.
@call run_test_w64_local2_d3.bat
sleep 10m
@call run_test_w32_local2_d3.bat

Memory leak (approximately) == 7GB

---
Database Page: 16KB

Changes in firebird.conf:
DefaultDbCachePages = 20
UserManager = Srp, Legacy_UserManager
MaxUnflushedWrites = -1
MaxUnflushedWriteTime = -1
WireCrypt = Enabled


Additional information for attached screenshots - because I executed parallel 
tests for two databases, memory leaks was multiplied by two and equal (at 
current moment) to 21GB.

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



--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today.http://sdm.link/xeonphi
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5415) [security3.fdb] wrong page type page 22 is of wrong type (expected pointer, found index root)

2016-12-08 Thread Kovalenko Dmitry (JIRA)

[security3.fdb] wrong page type page 22 is of wrong type (expected pointer,
found index root)
-

Key: CORE-5415
URL: http://tracker.firebirdsql.org/browse/CORE-5415
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0.2
Environment: FB SS x64 3.0.2.32641, Win10, IBProvider Test System
Reporter: Kovalenko Dmitry

FB SuperServer x64 3.0.2.32641

Under load tests I get the some unexpected problem with connection to database

Test configuration: 8 test threads.

Message at test side:
[THR:002956] [07.12.2016 01:22:37] [test] connect to database ...
[THR:002956] [07.12.2016 01:22:37] ERROR:
[blob.002.cmd.disable_defer_data.ansi.TBL_CS__TIS620.COL_BLOB.param_adLongVarWChar.bind__wstr.large1.len_4053.chars_TIS620.ins_UTF8.sel_NONE]
Data Source initialization
1. [Unknown DBMS]: Error occurred during login, please check server
firebird.log for details
2. [LCPI.IBProvider.3]: Ошибка подключения к базе данных.
Неопознанная ошибка

Message in firebird.log:
HOME4 Wed Dec 7 01:22:37 2016
Authentication error
database file appears corrupt
(D:\PROGRAM_FILES\FIREBIRD_3_0_X64\SECURITY3.FDB)
wrong page type
page 22 is of wrong type (expected pointer, found index root)

The previous tests and the next tests (in this and other threads) work without
problem.

In other word, this problem not affect to work of other tests.

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

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today.http://sdm.link/xeonphi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [FirebirdSQL/firebird] 5aede1: Decimal floating point numbers - first draft

2016-11-18 Thread Kovalenko Dmitry

No

-Original Message-
From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] 
Sent: Friday, November 18, 2016 7:59 PM
To: For discussion among Firebird Developers

Subject: Re: [Firebird-devel] [FirebirdSQL/firebird] 5aede1: Decimal
floating point numbers - first draft

Please, anybody subscribed to this list with gmail is seeing Alex Peshkoff
messages?


Adriano


On 13/11/2016 20:12, Adriano dos Santos Fernandes wrote:
> FYI, previous problem with all Alex messages coming to my gmail spam 
> folder I resolved putting his contact in a "white list".
>
> But now messages from Alex (even the github commits) does not enter in 
> my mail box even in spam folder.
>
>
> Adriano
>
> --
>  Developer Access Program for Intel Xeon Phi Processors Access 
> to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi Firebird-Devel 
> mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel



--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel


--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5396) Assert at MET_current

2016-11-15 Thread Kovalenko Dmitry (JIRA)

Assert at MET_current
-

 Key: CORE-5396
 URL: http://tracker.firebirdsql.org/browse/CORE-5396
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0.2
 Environment: Windows 10 Pro x64, IBProvider Test System, Outside snow.
Reporter: Kovalenko Dmitry


Firebird 3.0.2.32629. Original source code, custom DEBUG build VS2015 SP3, 
SuperServer, x64.

IBProvider tests. 4 test threads.

Problem in test thread #3 [table name: TEST_TABLE_6327]

Crash stack
engine12.dll!fb_assert_impl(const char * msg, const char * file, int 
line, bool do_abort) Line 40   C++
>   engine12.dll!MET_current(Jrd::thread_db * tdbb, Jrd::jrd_rel * 
> relation) Line 5303  C++
engine12.dll!VIO_gc_record(Jrd::thread_db * tdbb, Jrd::jrd_rel * 
relation) Line 2073C++
engine12.dll!purge(Jrd::thread_db * tdbb, Jrd::record_param * rpb) Line 
5938C++
engine12.dll!VIO_chase_record_version(Jrd::thread_db * tdbb, 
Jrd::record_param * rpb, Jrd::jrd_tra * transaction, Firebird::MemoryPool * 
pool, bool writelock, bool noundo) Line 1234   C++
engine12.dll!VIO_next_record(Jrd::thread_db * tdbb, Jrd::record_param * 
rpb, Jrd::jrd_tra * transaction, Firebird::MemoryPool * pool, bool onepage) 
Line 3015   C++
engine12.dll!garbage_collector(void * arg) Line 4894C++
engine12.dll!`anonymous namespace'::ThreadArgs::run() Line 78   C++
engine12.dll!threadStart(void * arg) Line 94C++

Local variables [MET_current]:
+   attachment  0x03a95920 {att_pool=0x03a921b0 
{pool=0x03a91e10 {smallObjects={freeObjects=...} ...} } ...}
Jrd::Attachment *
+   jrd_481 {jrd_482=4156 } 
MET_current::__l2::
+   jrd_483 {jrd_484=0 jrd_485=1 }  
MET_current::__l2::
-   relation0x30bf37b0 {rel_pool=0x03a921b0 
{pool=0x03a91e10 {smallObjects={freeObjects=...} ...} } ...}
Jrd::jrd_rel *
+   pool_alloc<9>   {...}   pool_alloc<9>
+   rel_pool0x03a921b0 {pool=0x03a91e10 
{smallObjects={freeObjects=0x03a91e18 {0x , ...} 
...} ...} }  Firebird::MemoryPool *
rel_id  4156unsigned short
rel_current_fmt 0   unsigned short
rel_flags   800 unsigned long
+   rel_current_format  0x
Jrd::Format *
+   rel_name{data=0x30bf37d0 "TEST_TABLE_6327" 
count=15 }   Firebird::MetaName
+   rel_owner_name  {data=0x30bf37f4 "" count=0 }   
Firebird::MetaName
+   rel_security_name   {data=0x30bf3818 "" count=0 }   
Firebird::MetaName
+   rel_formats 0x
Jrd::vec *
+   rel_fields  0x
Jrd::vec *
+   rel_view_rse0xJrd::RseNode *
+   rel_view_contexts   {sortMode=1 sorted=true }   
Firebird::SortedArray,unsigned 
short,Jrd::ViewContext,Firebird::DefaultComparator >
+   rel_file0x
Jrd::ExternalFile *
+   rel_gc_records  {...}   Firebird::HalfStaticArray
rel_use_count   0   unsigned short
rel_sweep_count 2   unsigned short
rel_scan_count  0   short
+   rel_existence_lock  0x93600148 
{lck_dbb=0x0208ec50 {dbb_sync={lockState={...} waiters={...} 
monitorCount=...} ...} ...} Jrd::Lock *
+   rel_partners_lock   0x30bf3a48 
{lck_dbb=0x0208ec50 {dbb_sync={lockState={...} waiters={...} 
monitorCount=...} ...} ...} Jrd::Lock *
+   rel_rescan_lock 0x93600090 {lck_dbb=0x0208ec50 
{dbb_sync={lockState={...} waiters={...} monitorCount=...} ...} ...} 
Jrd::Lock *
+   rel_gc_lock 0x93600200 {lck_dbb=0x0208ec50 
{dbb_sync={lockState={...} waiters={...} monitorCount=...} ...} ...} 
Jrd::Lock *
+   rel_index_locks 0xJrd::IndexLock *
+   rel_index_blocks0x
Jrd::IndexBlock *
+   rel_pre_erase   0x
Firebird::ObjectsArray<Jrd::Trigger,Firebird::Array > > *
+   rel_post_erase  0x
Firebird::ObjectsArray<Jrd::Trigger,Firebird::Array > > *
+   rel_pre_modify  0x
Firebird::ObjectsArray<Jrd::Trigger,Firebird::Array > > *
+   rel_post_modify 0x
Firebird::ObjectsArray<Jrd::Trigger,Firebird::Array > > *
+   rel_pre_store   0x
F

[Firebird-devel] [FB-Tracker] Created: (CORE-5382) Incorrect processing (truncation) of SQL statement with length 10MB+1

2016-10-26 Thread Kovalenko Dmitry (JIRA)

Incorrect processing (truncation) of SQL statement with length 10MB+1
-

 Key: CORE-5382
 URL: http://tracker.firebirdsql.org/browse/CORE-5382
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0.2
 Environment: Firebird 3.0.2.32619, IBProvider, direct INET-connection 
to FB3 (without fbclient.dll).
Reporter: Kovalenko Dmitry


SQL Statement (total length = 10*1024*1024+1):

 "select/*--  ---*/ID from DUAL "

---
Prepare error:

Dynamic SQL Error
SQL error code = -204
Table unknown
DUA

---

1. I think, the error message must be a little another.

2. Special for this case, I created the new table "DUA" and server prepared 
original query without any problem.


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



--
The Command Line: Reinvented for Modern Developers
Did the resurgence of CLI tooling catch you by surprise?
Reconnect with the command line and become more productive. 
Learn the new .NET and ASP.NET CLI. Get your free copy!
http://sdm.link/telerik
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB3] Can't prepare "select (x.*) from MYTABLE x"

2016-10-20 Thread Kovalenko Dmitry

Hi

 

Firebird 2.5.x can prepare SQL like "select (x.*) from MYTABLE x"

 

Firebird 3.0.2.32619 returns the error:

 

Dynamic SQL Error

SQL error code = -104

Token unknown - line 1, column 11

*

 

It is regression or FB2.5 works incorrectly?

 

Regards,

Dmitry Kovalenko

--
Check out the vibrant tech community on one of the world's most 
engaging tech sites, SlashDot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5350) Assert in CachedMasterInterface::set

2016-09-17 Thread Kovalenko Dmitry (JIRA)

Assert in CachedMasterInterface::set


 Key: CORE-5350
 URL: http://tracker.firebirdsql.org/browse/CORE-5350
 Project: Firebird Core
  Issue Type: Bug
Affects Versions: 3.0.0, 3.0.1
 Environment: Windows 7 x64
Reporter: Kovalenko Dmitry


1. Start server [debug build, x64]
2. Connect to database
3. Disconnect from database
4. Wait some time (1-2 minutes)
5. Connect to database again

void CachedMasterInterface::set(IMaster* master)
{
fb_assert(master); // <-- line with problem
fb_assert(!cached);
cached = master;
}

Stack of crash:
engine12.dll!fb_assert_impl(const char * msg, const char * file, int 
line, bool do_abort) Line 40   C++
>   engine12.dll!Firebird::CachedMasterInterface::set(Firebird::IMaster * 
> master) Line 56   C++
engine12.dll!firebird_plugin(Firebird::IMaster * master) Line 428   
C++
fbclient.dll!`anonymous namespace'::PluginSet::loadModule(const 
`anonymous-namespace'::PluginLoadInfo & info) Line 1091 C++
fbclient.dll!`anonymous 
namespace'::PluginSet::next(Firebird::CheckStatusWrapper * status) Line 1013
C++
fbclient.dll!`anonymous namespace'::PluginSet::PluginSet(const unsigned 
int pinterfaceType, const char * const pnamesList, Firebird::IFirebirdConf * 
const fbConf) Line 928 C++

fbclient.dll!Firebird::PluginManager::getPlugins(Firebird::CheckStatusWrapper * 
status, unsigned int interfaceType, const char * namesList, 
Firebird::IFirebirdConf * firebirdConf) Line 1250   C++

fbclient.dll!Firebird::IPluginManagerBaseImpl<Firebird::PluginManager,Firebird::CheckStatusWrapper,Firebird::IVersionedImpl<Firebird::PluginManager,Firebird::CheckStatusWrapper,Firebird::Inherit
 > >::cloopgetPluginsDispatcher(Firebird::IPluginManager * self, 
Firebird::IStatus * status, unsigned int pluginType, const char * namesList, 
Firebird::IFirebirdConf * firebirdConf) Line 6464 C++

fbclient.dll!Firebird::IPluginManager::getPlugins(Firebird::CheckStatusWrapper
 * status, unsigned int pluginType, const char * namesList, 
Firebird::IFirebirdConf * firebirdConf) Line 810C++

fbclient.dll!Firebird::GetPlugins::GetPlugins(const
 unsigned int interfaceType, Config * const knownConfig, const char * 
namesList) Line 136  C++

fbclient.dll!Why::Dispatcher::attachOrCreateDatabase(Firebird::CheckStatusWrapper
 * status, bool createFlag, const char * filename, unsigned int dpbLength, 
const unsigned char * dpb) Line 5705C++

fbclient.dll!Why::Dispatcher::attachDatabase(Firebird::CheckStatusWrapper * 
status, const char * filename, unsigned int dpbLength, const unsigned char * 
dpb) Line 5625 C++

fbclient.dll!Firebird::IProviderBaseImpl<Why::Dispatcher,Firebird::CheckStatusWrapper,Firebird::IPluginBaseImpl<Why::Dispatcher,Firebird::CheckStatusWrapper,Firebird::Inherit<Firebird::IReferenceCountedImpl<Why::Dispatcher,Firebird::CheckStatusWrapper,Firebird::Inherit<Firebird::IVersionedImpl<Why::Dispatcher,Firebird::CheckStatusWrapper,Firebird::Inherit
 > > > > > >::cloopattachDatabaseDispatcher(Firebird::IProvider * self, 
Firebird::IStatus * status, const char * fileName, unsigned int dpbLength, 
const unsigned char * dpb) Line 8995   C++

firebird.exe!Firebird::IProvider::attachDatabase(Firebird::CheckStatusWrapper
 * status, const char * fileName, unsigned int dpbLength, const unsigned char * 
dpb) Line 2026   C++
firebird.exe!Auth::SrpServer::authenticate(Firebird::CheckStatusWrapper 
* status, Firebird::IServerBlock * sb, Firebird::IWriter * writerInterface) 
Line 138C++

firebird.exe!Firebird::IServerBaseImpl<Auth::SrpServer,Firebird::CheckStatusWrapper,Firebird::IAuthImpl<Auth::SrpServer,Firebird::CheckStatusWrapper,Firebird::Inherit<Firebird::IPluginBaseImpl<Auth::SrpServer,Firebird::CheckStatusWrapper,Firebird::Inherit<Firebird::IReferenceCountedImpl<Auth::SrpServer,Firebird::CheckStatusWrapper,Firebird::Inherit<Firebird::IVersionedImpl<Auth::SrpServer,Firebird::CheckStatusWrapper,Firebird::Inherit
 > > > > > > > >::cloopauthenticateDispatcher(Firebird::IServer * self, 
Firebird::IStatus * status, Firebird::IServerBlock * sBlock, Firebird::IWriter 
* writerInterface) Line 9753C++

firebird.exe!Firebird::IServer::authenticate(Firebird::CheckStatusWrapper
 * status, Firebird::IServerBlock * sBlock, Firebird::IWriter * 
writerInterface) Line 2359   C++
firebird.exe!`anonymous namespace'::ServerAuth::authenticate(packet * 
send, ServerAuthBase::AuthenticateFlags flags) Line 434   C++
firebird.exe!accept_connection(rem_port * port, p_cnct * connect, 
packet * send) Line 1785  C++
firebird.exe!process_packet(rem_port * port, packet * sendL, packe

Re: [Firebird-devel] Longer metadata names and related things

2016-06-03 Thread Kovalenko Dmitry

>> I'd prefer to introduce XSQLDA version 2.

>Then it should also include schema name (reserved now), to avoid yet
another version switch in the future.

And package name ...

Dmitry Kovalenko
www.ibprovider.com



--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5195) Improve a Firebird compilation scripts (bat files)

2016-04-13 Thread Kovalenko Dmitry (JIRA)

Improve a Firebird compilation scripts (bat files)
--

Key: CORE-5195
URL: http://tracker.firebirdsql.org/browse/CORE-5195
Project: Firebird Core
Issue Type: Improvement
Components: Build Issues / Porting
Affects Versions: 3.0.0
Reporter: Kovalenko Dmitry

I offer to correct the "build" process for simplified a cleanup and creation
different sets of binaries.

At first time - for Windows environment.

1. Names of intermediate (temp, generated, output) directories should countains
the , ,

For example:

<temp|gen|output>\msvc14xp_Win32_Debug
<temp|gen|output>\msvc14xp_Win32_Release
<temp|gen|output>\msvc14xp_x64_Debug
<temp|gen|output>\msvc14xp_x64_Release

2. Directories "output_Win32" and "output_x64" can contains the last compiled
binaries (copies from output directory)

3. All log files must be created in "temp\\log".

Not in "builds\win32"

4. Allow the explicit definition of version Visual Studio (msvc10, msvc11,
msvc12, msvc14 ). By default, bat-files can use last known/supported
version.

--
Example of implementation:

https://github.com/dmitry-lipetsk/firebirdsql-core/blob/B2_5_Release/builds/win32/build_fb_all.bat

--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird support for "newer" compilers & SDKs / especially on Windows & MacOS X

2016-03-15 Thread Kovalenko Dmitry

>One of our developers discovered that Firebird 2.5 fails to compile
MSVC2013, made some steps in the direction of fixing it (like we did
internally for GCC 6), and was told that for Firebird 2.5, it was more work
than he envisioned: http://tracker.firebirdsql.org/browse/CORE-5120

You can look to my "clone" of FB2.5:
https://github.com/dmitry-lipetsk/firebird/tree/B2_5_Release

It supports compilation by VS2005-VS2015. I use VS2015.

But contains the some corrections of source code and project files.

- [sample of command line for compilations]

1. builds\win32\build_fb_all.bat MSVC14XP

2. builds\win32\build_fb_all.bat MSVC12XP

3. builds\win32\build_fb.bat MSVC14XP AMD64 Debug

-
Binary files (in case of VS2015) will be placed into folders:

output\msvc14xp_Win32_Debug
output\msvc14xp_Win32_Release
output\msvc14xp_x64_Debug
output\msvc14xp_x64_Release

-
Regards,
Dmitry Kovalenko


--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785231=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5139) mistake in comment "can't ise MutexLockGuard here"

2016-03-08 Thread Kovalenko Dmitry (JIRA)

mistake in comment "can't ise MutexLockGuard here"
--

 Key: CORE-5139
 URL: http://tracker.firebirdsql.org/browse/CORE-5139
 Project: Firebird Core
  Issue Type: Bug
Affects Versions: 3.0 RC2, 2.5.5
Reporter: Kovalenko Dmitry
Priority: Trivial


server.cpp, line 5816

"can't use MutexLockGuard here" 

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



--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://makebettercode.com/inteldaal-eval
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5074) Lost the charset ID in selection of array element

2016-01-13 Thread Kovalenko Dmitry (JIRA)

Lost the charset ID in selection of  array element
--

 Key: CORE-5074
 URL: http://tracker.firebirdsql.org/browse/CORE-5074
 Project: Firebird Core
  Issue Type: Bug
  Components: API / Client Library, Engine
Affects Versions: 2.5.5
Reporter: Kovalenko Dmitry


1. CREATE TABLE TEST_TBL
(
 ARRAY_COLUMN CHAR(10)[0:100] CHARACTER SET OCTETS
)

2. Prepare SQL: "select ARRAY_COLUMN[0] from TEST_TBL"

3. PROBLEM: XSQLVAR::sqlsubtype contains 0 (ZERO). Expected value: 1 (ID of 
OCTETS charset).

-
I think, the problem in MAKE_field (dsql/make.cpp).

Example of correction:
https://github.com/dmitry-lipetsk/firebird/commit/cc541b78d65a2ec578768819cb3c17d37b0f474e


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



--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4988) [lazy_send mode] problem with alloc_stmt+prepare_stmt operation

2015-11-03 Thread Kovalenko Dmitry (JIRA)

[lazy_send mode] problem with alloc_stmt+prepare_stmt operation
---

 Key: CORE-4988
 URL: http://tracker.firebirdsql.org/browse/CORE-4988
 Project: Firebird Core
  Issue Type: Bug
  Components: API / Client Library
Affects Versions: 2.5.4, 2.5.5
Reporter: Kovalenko Dmitry


In lazy_send mode, when the statement prepares the first own SQL, fbclient.dll 
sends two packet: op_allocate_statement and op_prepare_statement

If first operation [op_allocate_statement] is failed, fbclient.dll not receives 
the answer for second operation [op_prepare_statement].

--- [interface.cpp, GDS_DSQL_PREPARE]

// Set up for the response packet.

if (statement->rsr_flags.test(Rsr::LAZY))
{
if (!receive_response(rdb, packet))
return user_status[1]; // <--- WRONG EXIT !!!

statement->rsr_id = packet->p_resp.p_resp_object;
SET_OBJECT(rdb, statement, statement->rsr_id);

statement->rsr_flags.clear(Rsr::LAZY);
}

---[/interface.cpp]

At result, fbclient.dll starts to works incorrectly.

-- 
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-4983) [AV] Server crashes during execution of unprepared statement

2015-10-29 Thread Kovalenko Dmitry (JIRA)

[AV] Server crashes during execution of unprepared statement


 Key: CORE-4983
 URL: http://tracker.firebirdsql.org/browse/CORE-4983
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 2.5.4
Reporter: Kovalenko Dmitry


[Stack]

>   fb_inet_server.exe!EXE_unwind(Jrd::thread_db * tdbb, Jrd::jrd_req * 
> request) Line 1080  C++
fb_inet_server.exe!JRD_start(Jrd::thread_db * tdbb, Jrd::jrd_req * 
request, Jrd::jrd_tra * transaction, short level) Line 7005  C++
fb_inet_server.exe!execute_request(Jrd::thread_db * tdbb, Jrd::dsql_req 
* request, Jrd::jrd_tra * * tra_handle, unsigned short in_blr_length, const 
unsigned char * in_blr, unsigned short in_msg_length, const unsigned char * 
in_msg, unsigned short out_blr_length, unsigned char * out_blr, unsigned short 
out_msg_length, unsigned char * out_msg, bool singleton) Line 1271   C++
fb_inet_server.exe!DSQL_execute(Jrd::thread_db * tdbb, Jrd::jrd_tra * * 
tra_handle, Jrd::dsql_req * request, unsigned short in_blr_length, const 
unsigned char * in_blr, unsigned short in_msg_type, unsigned short 
in_msg_length, const unsigned char * in_msg, unsigned short out_blr_length, 
unsigned char * out_blr, unsigned short out_msg_length, unsigned char * 
out_msg) Line 273   C++
fb_inet_server.exe!jrd8_execute(__int64 * user_status, Jrd::jrd_tra * * 
tra_handle, Jrd::dsql_req * * stmt_handle, unsigned short in_blr_length, const 
char * in_blr, unsigned short in_msg_type, unsigned short in_msg_length, const 
char * in_msg, unsigned short out_blr_length, char * out_blr, unsigned short 
__formal, unsigned short out_msg_length, char * out_msg) Line 4045   C++
fb_inet_server.exe!isc_dsql_execute2_m(__int64 * user_status, unsigned 
int * tra_handle, unsigned int * stmt_handle, unsigned short in_blr_length, 
const char * in_blr, unsigned short in_msg_type, unsigned short in_msg_length, 
char * in_msg, unsigned short out_blr_length, char * out_blr, unsigned short 
out_msg_type, unsigned short out_msg_length, char * out_msg) Line 2725   C++
fb_inet_server.exe!rem_port::execute_statement(P_OP op, p_sqldata * 
sqldata, packet * sendL) Line 2328  C++
fb_inet_server.exe!process_packet(rem_port * port, packet * sendL, 
packet * receive, rem_port * * result) Line 3531 C++
fb_inet_server.exe!loopThread(void * __formal) Line 5260C++

[Local variables]

+   tdbb0x0487f1c0 {tdbb_default=0x052e9ff0 
{parent_redirect=false freeBlocks={pool=0x052e9ff0 {...} ...} ...} ...} 
Jrd::thread_db *
+   request 0xJrd::jrd_req *


-- 
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-4785) Bad packet of op_execute kills the server

2015-05-08 Thread Kovalenko Dmitry (JIRA)

Bad packet of op_execute kills the server
-

 Key: CORE-4785
 URL: http://tracker.firebirdsql.org/browse/CORE-4785
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 2.5.4
Reporter: Kovalenko Dmitry


0. Connection through TCP/IP (INET)

1. Query: insert into NUM (N_1_0) values (?)

2. input XSQLDA contains one LONG-variable (isc_sql_long). Build code:

 XSQLDA_V1_Wrapper xsqlda(1);

 xsqlda-sqld=1;

 unsigned __int32 xparam0_value=5;
 shortxparam0_ind=0;

 xsqlda-sqlvar[0].sqltype=isc_api::ibp_isc_sql_long|1;
 xsqlda-sqlvar[0].sqllen =sizeof(xparam0_value);
 xsqlda-sqlvar[0].sqldata=reinterpret_castchar*(xparam0_value);
 xsqlda-sqlvar[0].sqlind =xparam0_ind;

3. network packet ( op_execute )

P_OP_SQLDATA
  p_sqldata_statement   2   unsigned short
  p_sqldata_transaction 1   unsigned short
  p_sqldata_blr {cstr_length=12 cstr_address=0x00424240 \x5\x2\x4 }   
ibp::db_client::fb::protocol::P_CSTRING_CONST
cstr_length 12
cstr_address = 05 02 04 00 02 00 08 00 07 00 ff 4c
  p_sqldata_message_number  0   unsigned short
  p_sqldata_messages0   unsigned short
  p_sqldata_out_blr {cstr_length=0 cstr_address=0x NULL } 
ibp::db_client::fb::protocol::P_CSTRING_CONST
  p_sqldata_out_message_number  0   unsigned short
  p_sqldata_status  0   unsigned long

4. Server crash stack:

   fb_inet_server.exe!map_in_out(Jrd::dsql_req * request, Jrd::dsql_msg * 
 message, unsigned short blr_length, const unsigned char * blr, unsigned short 
 msg_length, unsigned char * dsql_msg_buf, const unsigned char * 
 in_dsql_msg_buf) Line 2216 C++
fb_inet_server.exe!execute_request(Jrd::thread_db * tdbb, Jrd::dsql_req 
* request, Jrd::jrd_tra * * tra_handle, unsigned short in_blr_length, const 
unsigned char * in_blr, unsigned short in_msg_length, const unsigned char * 
in_msg, unsigned short out_blr_length, unsigned char * out_blr, unsigned short 
out_msg_length, unsigned char * out_msg, bool singleton) Line 1267   C++
fb_inet_server.exe!DSQL_execute(Jrd::thread_db * tdbb, Jrd::jrd_tra * * 
tra_handle, Jrd::dsql_req * request, unsigned short in_blr_length, const 
unsigned char * in_blr, unsigned short in_msg_type, unsigned short 
in_msg_length, const unsigned char * in_msg, unsigned short out_blr_length, 
unsigned char * out_blr, unsigned short out_msg_length, unsigned char * 
out_msg) Line 273   C++
fb_inet_server.exe!jrd8_execute(__int64 * user_status, Jrd::jrd_tra * * 
tra_handle, Jrd::dsql_req * * stmt_handle, unsigned short in_blr_length, const 
char * in_blr, unsigned short in_msg_type, unsigned short in_msg_length, const 
char * in_msg, unsigned short out_blr_length, char * out_blr, unsigned short 
__formal, unsigned short out_msg_length, char * out_msg) Line 4049   C++
fb_inet_server.exe!isc_dsql_execute2_m(__int64 * user_status, unsigned 
int * tra_handle, unsigned int * stmt_handle, unsigned short in_blr_length, 
const char * in_blr, unsigned short in_msg_type, unsigned short in_msg_length, 
char * in_msg, unsigned short out_blr_length, char * out_blr, unsigned short 
out_msg_type, unsigned short out_msg_length, char * out_msg) Line 2725   C++
fb_inet_server.exe!rem_port::execute_statement(P_OP op, p_sqldata * 
sqldata, packet * sendL) Line 2327  C++
fb_inet_server.exe!process_packet(rem_port * port, packet * sendL, 
packet * receive, rem_port * * result) Line 3530 C++
fb_inet_server.exe!loopThread(void * __formal) Line 5261C++


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



--
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Y-valve and DPBs

2015-03-21 Thread Kovalenko Dmitry

Look to OLE DB properties.

Each property has the unique ID: GUID.Number.

Regards,
Dmitry Kovalenko

-Original Message-
From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] 
Sent: Saturday, March 21, 2015 4:19 AM
To: firebird-devel
Subject: [Firebird-devel] Y-valve and DPBs

Hi!

We have in the set of DPB constants:
- Completely FB-engine features
- Features uses in y-valve

All these constants are mixed in the same number space.

So we say we support multiple providers, but at the same time we expect that
all providers has identical FB-engine features?

How do non-FB providers may have they own functionality with DPBs?


Adriano


--
Dive into the World of Parallel Programming The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel


--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Y-valve and DPBs

2015-03-21 Thread Kovalenko Dmitry

 Connection parameters should be in text form.

Values (in common case) should contain the information about type (UI2, UI4
, String)

OLEDB, for example, uses VARIANT structure.

Regards,
Dmitry Kovalenko.


--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4699) Incorrect processing of DSQL_drop?

2015-02-25 Thread Kovalenko Dmitry (JIRA)

Incorrect processing of DSQL_drop?
--

 Key: CORE-4699
 URL: http://tracker.firebirdsql.org/browse/CORE-4699
 Project: Firebird Core
  Issue Type: Bug
  Components: API / Client Library
Affects Versions: 2.5.4
Reporter: Kovalenko Dmitry
Priority: Minor


As I understand, DSQL_drop constant presents the FLAG of operation, not ID of 
operation.

However, in some cases, instead of checking the flag DSQL_drop, used a direct 
comparison with DSQL_drop

[GDS_DSQL_FREE] [why.cpp]

if (option  DSQL_drop) // - OK
{
destroy(statement);
*stmt_handle = 0;
}

[GDS_DSQL_FREE] [interface.cpp]

if (option == DSQL_drop) // - ???
{
release_sql_request(statement);
*stmt_handle = NULL;
}

if (option == DSQL_drop) // - ???
*stmt_handle = NULL;

[Stack]
fbclient_d.dll!REM_free_statement(int * user_status=0x0249e470, Rsr * * 
stmt_handle=0x00612e2c, unsigned short option=2) Line 1960  C++
   fbclient_d.dll!isc_dsql_free_statement(int * user_status=0x0249e470, 
 void * * stmt_handle=0x042db448, unsigned short option=2) Line 3348C++

_IBProvider_v3_vs2013_d.dll!IBP_ISC_API__dsql_free_statement(isc_base::t_isc_provider
 * isc_provider=0x040ceed8, isc_base::t_isc_connection * 
isc_connection=0x040cf3c0, isc_base::t_isc_status_vector  
arg1__status_vector={...}, void * * arg2__stmt_handle_ptr=0x042db448, unsigned 
short arg3__op_id=2) Line 209   C++


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



--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4700) Mistake in GDS_DROP_DATABASE?

2015-02-25 Thread Kovalenko Dmitry (JIRA)

Mistake in GDS_DROP_DATABASE?
-

 Key: CORE-4700
 URL: http://tracker.firebirdsql.org/browse/CORE-4700
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 2.5.4
Reporter: Kovalenko Dmitry


jrd.cpp, GDS_DROP_DATABASE

for (; shadow; shadow = shadow-sdw_next)
{
 err = err || drop_files(shadow-sdw_file); // mistake?
}

I think, this code should be written like this:

for (; shadow; shadow = shadow-sdw_next)
{
 if ( drop_files(shadow-sdw_file) )
  err=true;
}

?



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



--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4239) AV. Problem in MET_procedure

2013-09-27 Thread Kovalenko Dmitry (JIRA)

AV. Problem in MET_procedure


 Key: CORE-4239
 URL: http://tracker.firebirdsql.org/browse/CORE-4239
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 2.5.3
 Environment: Vista x64. Q6600, 8GB. IBProvider Test System.

Reporter: Kovalenko Dmitry


I executed my old tests (in four threads) and get the (think, reproducible) AV 
in Firebird's engine:

Необработанное исключение в 0x000140256da2 в fb_inet_server.exe: 
0xC005: Нарушение прав доступа при записи 0x.

--
[27.09.2013 08:54:24] [ExecuteTests] CommandLine:

target\ibp_oledb_test_vc10_x64_Release.exe  /thread_count 4 /log_dir ..\_log 
/log_file_prefix w64_local_d3 /cn_str 
provider=LCPI.IBProvider.3;location=d:\database\ibp_test_fb25_d3.gdb;user 
id=gamer;password=vermut;ctype=win1251;icu_library=icuuc30.dll /test schema*

[27.09.2013 08:54:24] [ExecuteTests] Test Mask  : [schema*]

[27.09.2013 08:54:24] [info] Provider DLL:_IBProvider_v3_vc10_w64_i.dll
[27.09.2013 08:54:24] [info] Provider Version:3.16.4.15390
[27.09.2013 08:54:24] [info] Server Name :Firebird x64 [SuperClassic]. 
Release build [VS2010]
[27.09.2013 08:54:24] [info] Server Version  :2.5.3.26640
[27.09.2013 08:54:24] [info] Client Name :Firebird SQL Server
[27.09.2013 08:54:24] [info] Client Version  :2.5.3.26640
[27.09.2013 08:54:24] [info] Database ODS:11.2
[27.09.2013 08:54:24] [info] Database Dialect:3

 [problem FB-thread stack]

[SRC]
Parameter* parameter = *ptr;
// check for parameter to be null, this can only happen if the
// parameter numbers get out of sync. This was added to fix bug
// 10534. -Shaunak Mistry 12-May-99
if (parameter)
{
*desc = parameter-prm_desc; // HERE
length = MET_align(dbb, (*desc), length);
desc-dsc_address = (UCHAR *) (IPTR) length;
length += desc-dsc_length;
}

[ASM]
if (parameter)
000140256D99  testrcx,rcx  
000140256D9C  je  000140256DF1  
{
*desc = parameter-prm_desc;
000140256D9E  mov rax,qword ptr [rcx+8]  
000140256DA2  mov qword ptr [r8],rax  // HERE

[STACK]
   fb_inet_server.exe!MET_procedure(Jrd::thread_db * 
 tdbb=0x305f504d545f5053, int id=67718520, bool noscan=true, unsigned short 
 flags=61472)  Строка 5067 + 0x4 байт   C++
fb_inet_server.exe!MET_lookup_procedure(Jrd::thread_db * 
tdbb=0x053af020, const Firebird::MetaName  name={...}, bool 
noscan=false)  Строка 3979 + 0x14 байтC++
fb_inet_server.exe!create_procedure(Jrd::thread_db * 
tdbb=0x0c99b608, short phase=-27224, Jrd::DeferredWork * 
work=0x0f2f3368, Jrd::jrd_tra * transaction=0x0001)  Строка 
3468  C++
fb_inet_server.exe!DFW_perform_work(Jrd::thread_db * 
tdbb=0x0c99b608, Jrd::jrd_tra * transaction=0x)  Строка 
1174 + 0x11 байт   C++
fb_inet_server.exe!TRA_commit(Jrd::thread_db * tdbb=0x0f2f3368, 
Jrd::jrd_tra * transaction=0x, const bool retaining_flag=true)  
Строка 444  C++
fb_inet_server.exe!commit(Jrd::thread_db * tdbb=0x053af270, 
Jrd::jrd_tra * transaction=0x053af9b0, const bool retaining_flag=true)  
Строка 4539 + 0xf байт  C++
fb_inet_server.exe!jrd8_commit_transaction(__int64 * 
user_status=0x0eed4720, Jrd::jrd_tra * * tra_handle=0x0efc0198) 
 Строка 1744 + 0x13 байт   C++
fb_inet_server.exe!isc_commit_transaction(__int64 * 
user_status=0x0eed4720, unsigned int * tra_handle=0x07178910)  
Строка 1749 + 0x34 байт  C++
fb_inet_server.exe!rem_port::end_transaction(P_OP operation=118982928, 
p_rlse * release=0x07178910, packet * sendL=0x07178910)  Строка 
2086 C++
fb_inet_server.exe!process_packet(rem_port * port=0x00db0020, 
packet * sendL=0x07178910, packet * receive=0x00dba7a8, 
rem_port * * result=0x0038)  Строка 3419  C++
fb_inet_server.exe!SRVR_main(rem_port * main_port=0x043a6f00, 
unsigned short flags=0)  Строка 402 + 0x1a байт   C++
fb_inet_server.exe!process_connection_thread(void * 
arg=0x043a6f10)  Строка 348 + 0x14 байт C++
fb_inet_server.exe!`anonymous namespace'::threadStart(void * 
arg=0x)  Строка 139 + 0x5 байт C++

 [problem FB-thread local vars]
+   tdbb0x305f504d545f5053 {tdbb_default=??? database=??? 
attachment=??? ...}   Jrd::thread_db *
id  67718520int
noscan  truebool
flags   61472   unsigned short

[Firebird-devel] [FB-Tracker] Created: (CORE-4067) Problem with CREATE DATABASE ... COLLATION ... and 1 dialect

2013-03-19 Thread Kovalenko Dmitry (JIRA)

Problem with CREATE DATABASE ... COLLATION ... and 1 dialect
--

 Key: CORE-4067
 URL: http://tracker.firebirdsql.org/browse/CORE-4067
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine, ISQL
Affects Versions: 3.0 Initial
Reporter: Kovalenko Dmitry


Firebird 3.0.0.30278

c:\Program Files (x86)\Firebird_3_0isql.exe
Use CONNECT or CREATE DATABASE to specify a database
SQL SET SQL DIALECT 1;
SQL CREATE DATABASE 'vxp-fb30:e:\database\test2.gdb' USER 'gamer' PASSWORD 
'vermut' PAGE_SIZE 4096 DEFAULT CHARACTER SET win1251 COLLATION win1251;
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-ALTER DATABASE failed
-Dynamic SQL Error
-SQL error code = -817
-Metadata update statement is not allowed by the current database SQL dialect 1

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



--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4059) [FB3][AV] Crash when create an UDF with RETURNS PARAMETER pos_number

2013-03-06 Thread Kovalenko Dmitry (JIRA)

[FB3][AV] Crash when create an UDF with RETURNS PARAMETER pos_number
--

 Key: CORE-4059
 URL: http://tracker.firebirdsql.org/browse/CORE-4059
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine, UDF
Affects Versions: 3.0 Initial
Reporter: Kovalenko Dmitry


FB 3.0.0.30247

SQL: DECLARE EXTERNAL FUNCTION UDF_DUMMY2_RPN_1 smallint, integer, float, 
double precision RETURNS PARAMETER 1 ENTRY_POINT 'IB_UDF_abs' MODULE_NAME 
'ib_udf';

Stack:
engine12.dll!NestConstJrd::dsql_fld::operator Jrd::dsql_fld *()  
Строка 48 + 0x11 байтC++
   
 engine12.dll!Jrd::CreateAlterFunctionNode::dsqlPass(Jrd::DsqlCompilerScratch 
 * dsqlScratch=0x020c0074)  Строка 11209 + 0x15 байтC++

engine12.dll!Jrd::Node::doDsqlPassJrd::DdlNode(Jrd::DsqlCompilerScratch * 
dsqlScratch=0x020c0074, NestConstJrd::DdlNode  node={...})  Строка 133 + 
0x1e байт   C++
engine12.dll!Jrd::DsqlDdlRequest::dsqlPass(Jrd::thread_db * 
tdbb=0x0145effc, Jrd::DsqlCompilerScratch * scratch=0x020c0074, ntrace_result_t 
* traceResult=0x0145eb04)  Строка 878 + 0x13 байт   C++
engine12.dll!prepareStatement(Jrd::thread_db * tdbb=0x0145effc, 
Jrd::dsql_dbb * database=0x02060020, Jrd::jrd_tra * transaction=0x01ff02c8, 
unsigned long textLength=151, const char * text=0x0227b9a0, unsigned short 
clientDialect=1, unsigned short parserVersion=2, bool isInternalRequest=false)  
Строка 1450 + 0x1d байт  C++
engine12.dll!prepareRequest(Jrd::thread_db * tdbb=0x0145effc, 
Jrd::dsql_dbb * database=0x02060020, Jrd::jrd_tra * transaction=0x01ff02c8, 
unsigned long textLength=151, const char * text=0x0227b9a0, unsigned short 
clientDialect=1, unsigned short parserVersion=2, bool isInternalRequest=false)  
Строка 1322 + 0x28 байтC++
engine12.dll!DSQL_prepare(Jrd::thread_db * tdbb=0x0145effc, 
Jrd::Attachment * attachment=0x02080020, Jrd::jrd_tra * transaction=0x01ff02c8, 
unsigned long length=151, const char * string=0x0227b9a0, unsigned short 
dialect=1, Firebird::Arrayunsigned char,Firebird::EmptyStorageunsigned char 
 * items=0x0145ef8c, Firebird::Arrayunsigned 
char,Firebird::EmptyStorageunsigned char  * buffer=0x0145ef74, bool 
isInternalRequest=false)  Строка 373 + 0x28 байт  C++
engine12.dll!Jrd::JAttachment::prepare(Firebird::IStatus * 
user_status=0x0145f2a4, Firebird::ITransaction * apiTra=0x00c2ce34, unsigned 
int stmtLength=151, const char * sqlStmt=0x0227b9a0, unsigned int dialect=12, 
unsigned int flags=71)  Строка 4512 + 0x56 байт   C++
fbclient.dll!Why::YAttachment::prepare(Firebird::IStatus * 
status=0x0145f2a4, Firebird::ITransaction * transaction=0x00804f50, unsigned 
int stmtLength=151, const char * sqlStmt=0x0227b9a0, unsigned int dialect=12, 
unsigned int flags=71)  Строка 4480 + 0x44 байт   C++
firebird.exe!rem_port::prepare_statement(p_sqlst * prepareL=0x00832e68, 
packet * sendL=0x00832970)  Строка 3876 + 0x5c байт C++
firebird.exe!process_packet(rem_port * port=0x00832308, packet * 
sendL=0x00832970, packet * receive=0x00832c64, rem_port * * result=0x0145fea0)  
Строка 4179C++
firebird.exe!loopThread(void * __formal=0x003a)  Строка 5675 + 0x4f 
байтC++
firebird.exe!`anonymous namespace'::ThreadArgs::run()  Строка 73 + 0x1f 
байтC++
firebird.exe!threadStart(void * arg=0x0083157c)  Строка 89  C++

Local variable
-   this0x020c0810 {name={...} create=true alter=false ...} 
Jrd::CreateAlterFunctionNode * const
+   Jrd::DdlNode{...}   Jrd::DdlNode
+   name{data=0x020c0820 UDF_DUMMY2_RPN_1 count=16 }  
Firebird::MetaName
create  truebool
alter   false   bool
+   external{ptr=0x020c1448 }   
NestConstJrd::ExternalClause
deterministic   false   bool
-   parameters  {count=4 capacity=4 data=0x020c0e64 }   
Firebird::ArrayNestConstJrd::ParameterClause,Firebird::EmptyStorageNestConstJrd::ParameterClause
  
+   Firebird::EmptyStorageNestConstJrd::ParameterClause 
{...}   Firebird::EmptyStorageNestConstJrd::ParameterClause 
count   4   unsigned int
capacity4   unsigned int
+   data0x020c0e64 {ptr=0x020c0a78 }
NestConstJrd::ParameterClause *
+   returnType  {ptr=0x }   
NestConstJrd::ParameterClause
+   localDeclList   {ptr=0x }   
NestConstJrd::CompoundStmtNode
+   source  {...}   Firebird::StringBaseFirebird::StringComparator
+   body{ptr=0x }   NestConstJrd::StmtNode
compiledfalse   bool
invalid false   bool
+   package {data=0x020c08a4  count=0 }   Firebird::MetaName

[Firebird-devel] [FB-Tracker] Created: (CORE-3984) [Attempt to reopen an open cursor] in Execute-Fetch-Cancel-Close-Execute-Fetch-Error

2012-11-16 Thread Kovalenko Dmitry (JIRA)

[Attempt to reopen an open cursor] in 
Execute-Fetch-Cancel-Close-Execute-Fetch-Error


 Key: CORE-3984
 URL: http://tracker.firebirdsql.org/browse/CORE-3984
 Project: Firebird Core
  Issue Type: Bug
  Components: API / Client Library, Engine
Affects Versions: 2.5.2
 Environment: Win7, x64.
Reporter: Kovalenko Dmitry


Server Version  :2.5.3.26543 [Windows, SuperClassic, 64bit]
Client Version  :2.5.3.26543 [Windows, 32bit]
Database ODS:11.2
Database Dialect:3

Connection through localhost.

Work from 32bit application.

---
Common scenario:
1. thread1: execute statement select ID,DUMMY from 
SP_PAUSE_FETCH(1000,1000)
2. thread2: fetch one row
3. thread1: cancel fetch (and wait the finish of cancelation)
4. thread1: close cursor
5. thread1: execute statment again
6. thread2: fetch one row - ERROR Attempt to reopen an open cursor

---
Sequence of ISC API calls:
11:[Thr 10032][16.11.2012 12:51:57]ISC_API_IN [#01]: 
isc_dsql_allocate_statement(...,db_handle=0002,stmt_handle=)
12:[Thr 10032][16.11.2012 12:51:57]ISC_API_OUT[#01]: 
isc_dsql_allocate_statement(...,db_handle=0002,stmt_handle=0004) 
return OK.
13:[Thr 10032][16.11.2012 12:51:57]ISC_API_IN [#02]: 
isc_dsql_prepare(...,tr_handle=0003,stmt_handle=0004,...)
[stmt_text len:50]
select ID,DUMMY from SP_PAUSE_FETCH(1000,1000)
[/stmt_text]
14:[Thr 10032][16.11.2012 12:51:57]ISC_API_OUT[#02]: 
isc_dsql_prepare(...,tr_handle=0003,stmt_handle=0004,...) return OK.
15:[Thr 10032][16.11.2012 12:51:57]ISC_API_IN [#03]: 
isc_dsql_execute2(...,tr_handle=0003,stmt_handle=0004,...)
16:[Thr 10032][16.11.2012 12:51:57]ISC_API_OUT[#03]: 
isc_dsql_execute2(...,tr_handle=0003,stmt_handle=0004,...) return OK.
17:[Thr 2284][16.11.2012 12:51:57]ISC_API_IN [#04]: 
isc_dsql_fetch(...,stmt_handle=0004,...)
18:[Thr 10032][16.11.2012 12:51:57]ISC_API_IN [#05]: 
fb_cancel_operation(,db_handle=0002,option=3)
19:[Thr 10032][16.11.2012 12:51:57]ISC_API_OUT[#05]: 
fb_cancel_operation(,db_handle=0002,option=3) return OK.
20:[Thr 10032][16.11.2012 12:51:57]ISC_API_IN [#06]: 
fb_cancel_operation(,db_handle=0002,option=3)
21:[Thr 10032][16.11.2012 12:51:57]ISC_API_OUT[#06]: 
fb_cancel_operation(,db_handle=0002,option=3) return OK.
22:[Thr 2284][16.11.2012 12:51:57]ISC_API_OUT[#04]: 
isc_dsql_fetch(...,stmt_handle=0004,...) return ERROR [335544794]
operation was cancelled
23:[Thr 10032][16.11.2012 12:51:57]ISC_API_IN [#07]: 
isc_dsql_free_statement(...,stmt_handle=0004,1)
24:[Thr 10032][16.11.2012 12:51:57]ISC_API_OUT[#07]: 
isc_dsql_free_statement(...,stmt_handle=0004,1) return OK.
25:[Thr 10032][16.11.2012 12:51:57]ISC_API_IN [#08]: 
isc_dsql_execute2(...,tr_handle=0003,stmt_handle=0004,...)
26:[Thr 10032][16.11.2012 12:51:57]ISC_API_OUT[#08]: 
isc_dsql_execute2(...,tr_handle=0003,stmt_handle=0004,...) return OK.
27:[Thr 2284][16.11.2012 12:51:57]ISC_API_IN [#09]: 
isc_dsql_fetch(...,stmt_handle=0004,...)
28:[Thr 2284][16.11.2012 12:51:57]ISC_API_OUT[#09]: 
isc_dsql_fetch(...,stmt_handle=0004,...) return ERROR [335544569]
Dynamic SQL Error
SQL error code = -502
Attempt to reopen an open cursor
29:[Thr 10032][16.11.2012 12:51:57]ISC_API_IN [#10]: 
isc_dsql_free_statement(...,stmt_handle=0004,1)
30:[Thr 10032][16.11.2012 12:51:57]ISC_API_OUT[#10]: 
isc_dsql_free_statement(...,stmt_handle=0004,1) return OK.
31:[Thr 10032][16.11.2012 12:51:57]ISC_API_IN [#11]: 
isc_dsql_free_statement(...,stmt_handle=0004,2)
32:[Thr 10032][16.11.2012 12:51:57]ISC_API_OUT[#11]: 
isc_dsql_free_statement(...,stmt_handle=,2) return OK.

-
In line 23-24 I close my open cursor
In line 25-26 I re-execute statement

Why in line 28 (operation #09) I obtain the error Attempt to reopen an 
open cursor ?

-- [Test stored procedure] 
CREATE PROCEDURE SP_PAUSE_FETCH(N INTEGER, PAUSE INTEGER) 
 RETURNS (ID INTEGER,DUMMY VARCHAR(32000)) 
AS 
 DECLARE VARIABLE P INTEGER; 
 DECLARE VARIABLE S INTEGER; 
BEGIN 
 ID=0; 

 DUMMY=''; 
 P=0; 
 WHILE(P32000)DO 
 BEGIN 
  DUMMY=DUMMY||'A'; 
  P=P+1; 
 END 

 S=0; 
 WHILE(S=0)DO 
 BEGIN 
  P=0; 
  WHILE(PPAUSE) DO P=P+1; 

  IF(IDN)THEN 
  BEGIN 
   ID=ID+1; 
   SUSPEND; 
  END 
  ELSE 
  BEGIN 
   S=1; 
  END 
 END 
END 
-- [/Test stored procedure] 


-- 
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] ODS12. RDB$FUNCTION_ARGUMENTS. Description field.

2011-04-18 Thread Kovalenko Dmitry

Hi

The system table RDB$FUNCTION_ARGUMENTS (in ODS12) still exists without 
RDB$DESCRIPTION field.

RDB$PROCEDURE_PARAMETERS contains this (and RDB$SYSTEM_FLAG also) field.

Kovalenko Dmitry--
Benefiting from Server Virtualization: Beyond Initial Workload 
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve 
application availability and disaster protection. Learn more about boosting 
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2devFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] RDB$SET_CONTEXT, mistake in system table for return value

2011-04-06 Thread Kovalenko Dmitry

Hi

Firebird 2.5.1

IBExpert returns the next description of RDB$SET_CONTEXT

DECLARE EXTERNAL FUNCTION RDB$SET_CONTEXT
VARCHAR(80) CHARACTER SET NONE NULL,
VARCHAR(80) CHARACTER SET NONE NULL,
VARCHAR(255) CHARACTER SET NONE NULL
RETURNS INTEGER CHARACTER SET NONE BY VALUE  !!!
ENTRY_POINT 'set_context' MODULE_NAME 'system_module';

As I understand, the problem in column 
RDB$FUNCTION_ARGUMENTS::RDB$CHARACTER_SET_ID. And, maybe, RDB$CHARACTER_LENGTH

These columns contain not NULL values

For external functions, declarared by user, records in system table is ok

Can create the ticket in bug-tracker?

Kovalenko Dmitry.

PS. Ofcourse, this is wrong behavior of IBExpert also :)--
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdevFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] isc_dsql_prepare, NULL tr_handle, SET TRANSACTION

2011-04-04 Thread Kovalenko Dmitry

 Fixed. Thanks.

Please, append in source code the comment for this fix.

Because in each new version (begin from 2.0) this feature is broken :)

Regards,
Dmitry Kovalenko.


--
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself; 
WebMatrix provides all the features you need to develop and 
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

66 matches

Mail list logo