Re: [Firebird-devel] Firebird 2.1 External Table Files InternalFormat
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 ?
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 ?
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
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.
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