Commented by: @AlexPeshkoff

I've tried fb2rc4 linux classic on both i386 and amd64 - given select operator works fine.

Commented by: chedek (chedek2)

Operation system: Linux Mandriva 2006
Processor: AMD64 dual core
Firebird SQL Server: FB 2 RC 4 linux classic 32-bit

fb2 Server craches if given SQL-stamenent is the first operator after connect

Commented by: @AlexPeshkoff

Have a look at screenshot:

*--------------------------
gds bin #⁠ ./isql -z employee;
ISQL Version: LI-V2.0.0.12724 Firebird 2.0 Release Candidate 4
Server version:
LI-V2.0.0.12724 Firebird 2.0 Release Candidate 4
Database: employee
SQL> select rtrim(sright('TODAY',2)) from rdb$database;

RTRIM

AY

SQL> select rtrim(sright('TODAY',2)) from rdb$database;

RTRIM

AY

SQL> gds bin #⁠ uname -a
Linux gds.infs.local 2.6.11 #⁠9 Wed Nov 2 12:48:52 MSK 2005 x86_64 AMD Athlon(tm) 64 Processor 3000+ AuthenticAMD GNU/Linux
gds bin #⁠
*--------------------------

Can you give more details, please?
For me it works as any operator - first, second, etc.

Commented by: @pmakowski

could it be because he use FB 2 RC 4 linux classic 32-bit on 64-bit ?
I did the test on Mandriva2006 and MandrivaCS4 on Amd64 but with FB 2 RC 4 linux classic 64-bit and all is ok
and can't reproduce this "bug"

Commented by: @AlexPeshkoff

I've tried also with 32-bit build. And I've reproduced an issue once on beta2. But rc4 seems quite stable from this POV.

Commented by: chedek (chedek2)

I run this on WIndows XP SP2
Here is screenshot:

C:\Program Files\Firebird\Firebird_2_0\bin>isql -z mail:/sql/companyorganizer2.g
db -USER SYSDBA -PASSW djhjyf

ISQL Version: WI-V2.0.0.12724 Firebird 2.0 Release Candidate 4
Server version:
LI-V2.0.0.12724 Firebird 2.0 Release Candidate 4
LI-V2.0.0.12724 Firebird 2.0 Release Candidate 4/tcp (mail)/P10
WI-V2.0.0.12724 Firebird 2.0 Release Candidate 4/tcp (chedek)/P10
Database: mail:/sql/companyorganizer2.gdb, User: SYSDBA
SQL> select rtrim(sright('TODAY',2)) from rdb$database;

RTRIM

===============================================================================

Statement failed, SQLCODE = -902
Error reading data from the connection.
SQL>

Commented by: @AlexPeshkoff

Sorry, I can't reproduce this bug any more with *any* configuration of firebird - no matter, which release, local or remote connection used, etc. Can you try to reproduce it using local connection? If yes, do the following:

ulimit -c 1024000
isql your.database

And sent resulting core file to me - after processing with bzip2 to save my IP traffic.

Commented by: chedek (chedek2)

This error happens only when I using remote connection from Windows to Linux. In local mode all's OK.

Commented by: @AlexPeshkoff

Things get a bit more complicated. You should setup your system to create core files for processes, started by (x)inetd. If it's impossible, attach to appropriate fb_inet_server with gdb, and after receiving signal, create core file using gdb (generate-core-file command).

Commented by: @AlexPeshkoff

Hi, chedek2 !

Can you produce core file for me? Without this I can't continue with your problem and I'm afraid we will have to release RC5 without fix for it.

Commented by: chedek (chedek2)

I can't produce it because an error:

Reading symbols from /opt/firebird/bin/fb_inet_server...(no debugging symbols found)...done.
Using host libthread_db library "/lib/tls/libthread_db.so.1".
(gdb) start
Function "main" not defined.

Commented by: @AlexPeshkoff

Contact me privately, please, in order not to overload this tracker with gdb issues. I'm sure we will solve such problem.

Commented by: chedek (chedek2)

?????????, ? ???? ???? ??? ?? ??? ?? ?????? ????? ????? ?? ??????? ?????
??? ?????? ????? e-mail ????? ??? ?????? ??????????? ??? ????? ICQ

Commented by: chedek (chedek2)

Alexander Peshkov. Please give me your e-mail.... I'm from Russia too. We can discuss this problem in Russian.

Commented by: @AlexPeshkoff

Chedek!
Please find my address in my jira user's profile. You may write me in Russian privately, but please don't do it in the tracker.

Commented by: Pierre Yager (pierrey)

Hi guys,

I tried to help reproducing this issue. I compiled Fb2.0 from latest CVS on my Gentoo :

#⁠ emerge --info
Portage 2.1.2_pre1 (default-linux/amd64/2006.1/desktop, gcc-3.4.6/amd64-vanilla, glibc-2.4-r3, 2.6.17-gentoo-r7 x86_64)

System uname: 2.6.17-gentoo-r7 x86_64 Intel(R) Pentium(R) D CPU 3.00GHz
Gentoo Base System version 1.12.5
Last Sync: Sun, 17 Sep 2006 18:00:01 +0000
ccache version 2.4 [disabled]
app-admin/eselect-compiler: 2.0.0_rc2-r1
dev-java/java-config: 1.3.6-r1, 2.0.28-r1
dev-lang/python: 2.4.3-r3
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache: 2.4-r6
dev-util/confcache: 0.4.2-r1
sys-apps/sandbox: 1.2.18.1
sys-devel/autoconf: 2.13, 2.60
sys-devel/automake: 1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2
sys-devel/binutils: 2.17
sys-devel/gcc-config: 1.3.13-r3
sys-devel/libtool: 1.5.22
virtual/os-headers: 2.6.16
ACCEPT_KEYWORDS="amd64 ~amd64 ~x86"
AUTOCLEAN="yes"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-march=nocona -O2 -fomit-frame-pointer -pipe"
CHOST="x86_64-pc-linux-gnu"

Connecting from official Fb2.0/RC4 on Windows 2000 Server to my Gentoo box succeeded :

C:\Program Files\Firebird\bin>isql ******.sudogeek.net:/var/db/firebird/fb20test
fdb -user SYSDBA -password ******
Database: ******.sudogeek.net:/var/db/firebird/fb20test.fdb, User: SYSDBA
SQL> show functions;
ABS ACOS
ADDDAY ADDDAY2
ADDHOUR ADDMILLISECOND
ADDMINUTE ADDMONTH
ADDSECOND ADDWEEK
ADDYEAR ASCII_CHAR
ASCII_VAL ASIN
ATAN ATAN2
BIN_AND BIN_OR
BIN_XOR CEILING
COS COSH
COT DIV
DNULLIF DNVL
DOW DPOWER
FLOOR FRAC
GETEXACTTIMESTAMP GETEXACTTIMESTAMPUTC
I64NULLIF I64NVL
I64ROUND I64TRUNCATE
INULLIF INVL
ISLEAPYEAR LN
LOG LOG10
LOWER LPAD
LTRIM MOD
PI RAND
ROUND RPAD
RTRIM SDOW
SIGN SIN
SINH SNULLIF
SNVL SQRT
SRAND SRIGHT
STRING2BLOB STRLEN
SUBSTR SUBSTRLEN
TAN TANH
TRUNCATE
SQL> select rtrim(sright('TODAY',2)) from rdb$database;

RTRIM

AY

I think this issue is library/kernel/compiler related.