[Maria-developers] [[Bug] skip-character-set-client-handshake]

Sun, 02 Dec 2012 00:30:37 -0800 

>Description:
        <I'm using MariaDB with my gameservers. Server works with db through 
sourcemod.
In my db i'am using utf8 encoding, and all works fine on MariaDB 5.3.8 with 
params:
init-connect = "SET NAMES 'utf8' COLLATE 'utf8_general_ci'"
skip-character-set-client-handshake
 
But after upgrade to 5.5.27 i found a 'bug'.
When i'm send query from my game server, over time character_set_connection, 
character_set_client and character_set_results set to latin1.
After enable log i saw:
 
                   88 Connect   login@domain as anonymous on sourcebans
                   88 Query     SET NAMES 'utf8' COLLATE 'utf8_general_ci'
                   88 Query     SET NAMES latin1
                   88 Query     SHOW VARIABLES LIKE '%character_set%'
But my request is only show vars.
I assumed that sourcemod is guilty. But skip-character-set-client-handshake is 
set! I disable it, and try again.
At this time i send SET collation_connection = utf8_general_ci and SET NAMES 
utf8 after my query. But over time it set to latin1 again.
 
No errosr in error.log
Sorry for my english.>
>How-To-Repeat:
        <I don't know how to repeat it manually (without sourcemod app)>
>Fix:
        <It works fine in previous versions. Just not accept NAMES from client.>

>Submitter-Id:  <submitter ID>
>Originator:    spumer
>Organization:
 <russian game servers>
>MySQL support: [ email support ]
>Synopsis:      <skip-character-set-client-handshake not work correctly>
>Severity:      
>Priority:      
>Category:      mysql
>Class:         
>Release:       mysql-5.5.28a (MariaDB Server)

>C compiler:    gcc-4.5.3 (Gentoo 4.5.3-r1 p1.0, pie-0.4.5) 4.5.3

>C++ compiler:  g++-4.5.3(Gentoo 4.5.3-r1 p1.0, pie-0.4.5) 4.5.3

>Environment:
        <VMware ESXi 5, Gentoo, Glibc 2.15>
System: Linux localhost 3.6.1-gentoo #1 SMP Mon Oct 8 06:00:23 YEKT 2012 x86_64 
Intel(R) Core(TM) i7 CPU 870 @ 2.93GHz GenuineIntel GNU/Linux


Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Используются внутренние спецификации.
COLLECT_GCC=/usr/x86_64-pc-linux-gnu/gcc-bin/4.5.3/gcc
COLLECT_LTO_WRAPPER=/usr/libexec/gcc/x86_64-pc-linux-gnu/4.5.3/lto-wrapper
Целевая архитектура: x86_64-pc-linux-gnu
Параметры конфигурации: 
/var/tmp/portage/sys-devel/gcc-4.5.3-r1/work/gcc-4.5.3/configure --prefix=/usr 
--bindir=/usr/x86_64-pc-linux-gnu/gcc-bin/4.5.3 
--includedir=/usr/lib/gcc/x86_64-pc-linux-gnu/4.5.3/include 
--datadir=/usr/share/gcc-data/x86_64-pc-linux-gnu/4.5.3 
--mandir=/usr/share/gcc-data/x86_64-pc-linux-gnu/4.5.3/man 
--infodir=/usr/share/gcc-data/x86_64-pc-linux-gnu/4.5.3/info 
--with-gxx-include-dir=/usr/lib/gcc/x86_64-pc-linux-gnu/4.5.3/include/g++-v4 
--host=x86_64-pc-linux-gnu --build=x86_64-pc-linux-gnu --disable-altivec 
--disable-fixed-point --without-ppl --without-cloog --disable-lto --enable-nls 
--without-included-gettext --with-system-zlib --disable-werror 
--enable-secureplt --enable-multilib --enable-libmudflap --disable-libssp 
--enable-libgomp 
--with-python-dir=/share/gcc-data/x86_64-pc-linux-gnu/4.5.3/python 
--enable-checking=release --disable-libgcj --enable-languages=c,c++,fortran 
--enable-shared --enable-threads=posix --enable-__cxa_a!
 texit --enable-clocale=gnu --enable-targets=all 
--with-bugurl=http://bugs.gentoo.org/ --with-pkgversion='Gentoo 4.5.3-r1 p1.0, 
pie-0.4.5'
Модель многопоточности: posix
gcc версия 4.5.3 (Gentoo 4.5.3-r1 p1.0, pie-0.4.5) 
Compilation info (call): CC='/usr/bin/gcc'  CFLAGS='-Wall  -O3 -g 
-static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF 
-DMY_PTHREAD_FASTMUTEX=1'  CXX='/usr/bin/c++'  CXXFLAGS='-Wall  
-Wno-unused-parameter -fno-implicit-templates -fno-exceptions -fno-rtti -O3 -g 
-static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF 
-DMY_PTHREAD_FASTMUTEX=1'  LDFLAGS=''  ASFLAGS=''
Compilation info (used): CC='/usr/bin/gcc'  CFLAGS='-Wall  -O3 -g 
-static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF 
-DMY_PTHREAD_FASTMUTEX=1'  CXX='/usr/bin/c++'  CXXFLAGS='-Wall  
-Wno-unused-parameter -fno-implicit-templates -fno-exceptions -fno-rtti -O3 -g 
-static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF 
-DMY_PTHREAD_FASTMUTEX=1'  LDFLAGS=''  ASFLAGS=''
LIBC: 
lrwxrwxrwx 1 root root 12 дек.   2 12:43 /lib/libc.so.6 -> libc-2.15.so
-rwxr-xr-x 1 root root 1734576 дек.   2 12:42 /lib/libc-2.15.so
-rw-r--r-- 1 root root 4594916 дек.   2 12:42 /usr/lib/libc.a
-rwxr-xr-x 1 root root 253 дек.   2 12:42 /usr/lib/libc.so

Perl: This is perl 5, version 12, subversion 4 (v5.12.4) built for 
x86_64-linux-thread-multi


_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to     : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Reply via email to