Percona Server moved to https://jira.percona.com/projects/PS

5.1.55 main.loaddata failed

Bug #726708 reported by Valentine Gostev
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Invalid
Undecided
Unassigned

Bug Description

Looks like server is not built with the support of mentioned character set

CURRENT_TEST: main.loaddata
mysqltest: At line 592: query 'LOAD DATA INFILE 'tmpp.txt' INTO TABLE t1 CHARACTER SET ucs2
(@b) SET a=REVERSE(@b)' failed: 1115: Unknown character set: 'ucs2'

The result from queries just before the failure was:
< snip >
SELECT 'test' INTO OUTFILE 't1.txt';
LOAD DATA INFILE 't1.txt' IGNORE INTO TABLE t1 SET col0=col0;
SELECT * FROM t1;
col0
test
DROP TABLE t1;
#
# Bug #52512 : Assertion `! is_set()' in
# Diagnostics_area::set_ok_status on LOAD DATA
#
CREATE TABLE t1 (id INT NOT NULL);
LOAD DATA LOCAL INFILE 'tb.txt' INTO TABLE t1;
DROP TABLE t1;
#
# Bug #51876 : crash/memory underrun when loading data with ucs2
# and reverse() function
#
# Problem # 1 (original report): wrong parsing of ucs2 data
SELECT '00' UNION SELECT '10' INTO OUTFILE 'tmpp.txt';
CREATE TABLE t1(a INT);

More results from queries before failure can be found in /root/5.1.55-test-fixes/Percona-Server/mysql-test/var/log/loaddata.log

 - saving '/root/5.1.55-test-fixes/Percona-Server/mysql-test/var/log/main.loaddata/' to '/root/5.1.55-test-fixes/Percona-Server/mysql-test/var/log/main.loaddata/'
------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 1 seconds executing testcases

Completed: Failed 1/1 tests, 0.00% were successful.

Failing test(s): main.loaddata

Revision history for this message
Oleg Tsarev (tsarev) wrote :

Need additional information.
On My Fedora all OK.
I build Percona-Server by following script:

#!/usr/bin/env sh
test -z ${PERCONA_SERVER} && export PERCONA_SERVER=Percona-Server
echo PERCONA_SERVER=${PERCONA_SERVER}
echo ADDITIONAL=${ADDITIONAL}
PERCONA_SERVER=${PERCONA_SERVER} make all
cd ${PERCONA_SERVER}
export CFLAGS="-O2 -g -fmessage-length=0 -D_FORTIFY_SOURCE=2"
export CXXFLAGS="-O2 -g -fmessage-length=0 -D_FORTIFY_SOURCE=2"
export LIBS=-lrt
BUILD/autorun.sh
CONFIGURE="./configure --build=x86_64-linux-gnu --host=x86_64-linux-gnu --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --enable-static --enable-thread-safe-client --enable-assembler --enable-local-infile --with-fast-mutexes --with-big-tables --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --with-libwrap --with-ssl --without-docs --with-extra-charsets=all --with-plugins=max-no-ndb --without-plugin-innobase --without-embedded-server --with-embedded-privilege-control"
#CONFIGURE=./configure --without-plugin-innobase --with-plugin-innodb_plugin --with-extra-charsets=all --with-plugin-partition --prefix=/storage/project/percona/mysql
echo "========================================"
echo ${CONFIGURE} ${ADDITIONAL}
echo "========================================"
${CONFIGURE} ${ADDITIONAL}
make -j5
make test-force-full 1>log 2>error

Revision history for this message
Stewart Smith (stewart) wrote :

Does this still happen?

affects: percona-projects-qa → percona-server
Changed in percona-server:
status: New → Incomplete
Stewart Smith (stewart)
Changed in percona-server:
status: Incomplete → Invalid
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2612

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.