Re: [Firebird-devel] Firebird 2.1 External Table Files InternalFormat

2013-09-27 Thread Huan Ruan
Many thanks for the detailed explanation, Vlad. It all makes sense now.


> I'm not sure FB 2.1.x could correctly work with 32K+ records. But i
> can be
> wrong, i don't remember exactly. Could you check it with FB 2.5 ?
>
>
> FB2.5 works fine with 32K+ rows, and only has problems when the row
reaches the general limit of 64K.

Thanks again
Huan

>
>
> --
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrkFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] --with-system-icu is gone in trunk ?

2013-09-27 Thread Alex Peshkoff
On 09/27/13 12:30, marius adrian popa wrote:
> when i try to compile from trunk i get this error
>
> WARNING: unrecognized options:--with-system-icu
>

it's the only possible choice now for posix build - therefore an option 
is gone
if you ask about Android - all known to me Android builds do contain ICU

--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] --with-system-icu is gone in trunk ?

2013-09-27 Thread marius adrian popa
when i try to compile from trunk i get this error

WARNING: unrecognized options:--with-system-icu

--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk
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 sho

Re: [Firebird-devel] [Firebird-Architect] Install Firebird without being root.

2013-09-27 Thread Alex Peshkoff
On 09/26/13 22:05, pline...@yahoo.com wrote:
> Hi Alex, and thanks for your interest.
>
> (this post may be a dup - apologies if so - also, maybe belongs on general not
> architecture,
> please move if appropriate).
>
>   > 3 points at the first glance.
>
>   > 1. There is a lot of chown commands in firebird install files. They
>   > should not run for non-root install.
>
>
> Understood - but I think that it should be feasible out of the box.
>
>   > 2. Firebird can't be registered as a daemon in /etc without root access
>   > rights, i.e. this part of scripts should not run too.
>
> That's OK too - all I want is the ability to manually start and stop the
> server - as I can easily do with PostgreSQL. MySQL offers a similar
> capability - why not Firebird? If the Firebird project is attempting to 
> compete
> with both of these, then it should be an option - e.g. for students who don't
> have root access to their machines and the like.
>
>
>   > 3. And finally you must modify check for root.
>
> Again - I want it out of the box and I want it now! :) Seriously though,
> I don't have the ability to mess around with these scripts - one never
> knows what one is breaking.

You've asked what must be done - I answered :-)
I've thought you wish to prepare a patch.

>
>   > There is doc/README.build.posix.html.
>
>
> Indeed there is - it just doens't tell me anything about how to install as 
> non-root.

Definitely yes - this feature is not present.

>
>   > But tell me - what a reason for readme's when you build from tarball
>   > using traditional ./configure && make?
>   > configure certainly has a --help switch.
>
> Indeed ./configure does have a help file - which IIRC, amazingly enough, I 
> read :),
> but again, it has nothing about non-root installs.

Once again definitely yes.

>
> I *_did_* use --prefix=$FIREBIRD/exedir and got files produced - it was when 
> I tried
> to kick off fbserver that my problems began!
>
> Any help or input on this matter appreciated.

You can't avoid it not modifying source code. That (agreed, foolish) 
check for "root, interbase, interbas or firebird" was removed in FB3. 
What about 2.5 - it's certainly feature-closed.

As a workaround you may build classic server and use it in embedded 
mode. For single-user non-root access it will work OK.


--
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel