Comment 3 for bug 1267507

hi,

thank you for you quick replies!
:)

data is imported "locally" via mysql client.
i tried it with 3 nodes, and just with one in bootstrap-pxc mode.
same result.

the line is not everytime exactly the same, so i think it is not a single "INSERT" statement that is wrong.
but it crashed within a range of +/- 100 lines (insert statements)

oh, with a 5.5 version this was no problem!
just this "brand new" 5.6er version has troubles.

what other info do you require?

I did the import many times, there i made this script to have the same results every time:

IMPORT SCRIPT: /storage/admin/scripts/do_import__test.sh
#!/bin/sh

( date; mysql --show-warnings --unbuffered --debug-info -v -v -v -f otrs_test < /storage/dbbackup/otrs_prod.sql; date ) > /storage/log/import__test.log 2>&1

# EOF

----------------------------------------------

the SQL import file :
-rw-r--r-- 1 root root 25G Jan 4 02:45 /storage/dbbackup/otrs_prod.sql

CONFIG: egrep -v '^#' my.cnf

[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql

bind-address = 0.0.0.0

myisam-recover = BACKUP

explicit_defaults_for_timestamp = true

slow_query_log = 1
slow_query_log_file = /var/log/mysql/slow_queries.log

log-output = FILE

long_query_time = 10000
log-queries-not-using-indexes = 1

general_log_file = /var/log/mysql/general.log
general-log = 0

log-error = /var/log/mysql/error.log

log_warnings = 3
verbose

join_buffer_size = 128M

thread_stack = 512k
thread_cache_size = 80

table_open_cache = 1024

key_buffer_size = 256M
max_allowed_packet = 64M
net_buffer_length = 1M

read_rnd_buffer_size = 256M
read_buffer_size = 256M
sort_buffer_size = 512M

myisam_sort_buffer_size = 1024M

max_connections = 250
wait_timeout = 600
interactive_timeout = 3000

tmp_table_size = 2048M
max_tmp_tables = 256

max_heap_table_size = 512M

innodb_data_file_path = ibdata1:10M:autoextend

innodb_buffer_pool_size = 4096M

innodb_log_file_size = 128M
innodb_log_buffer_size = 128M

innodb_file_per_table

default_storage_engine = InnoDB

query_cache_type = 0
query_cache_size = 0

log_slave_updates = 1

skip-name-resolve
transaction-isolation = 'READ-COMMITTED'
expire_logs_days = 2
max_binlog_size = 100M
binlog_format = ROW

log_bin = /storage/bin-logs/DB01/mysql-bin.log

wsrep_cluster_name = "Percona-XtraDB-Cluster-LLL-01"
wsrep_provider = /usr/lib/libgalera_smm.so
wsrep_notify_cmd = /etc/mysql/bin/wsrep_notify

wsrep_cluster_address = gcomm://10.10.17.73:4567,10.10.17.74:4567,10.10.17.75:4567

server-id = 101
wsrep_node_name = "LLLC1Node1"
wsrep_node_address = 10.10.17.73

wsrep_sst_method = xtrabackup-v2
wsrep_sst_auth = user:pass

[sst]
socket = /var/run/mysqld/mysqld.sock
streamfmt = xbstream
use_extra = 0

[xtrabackup]
target_dir = /data/backups/mysql/

[innobackupex]
socket = /var/run/mysqld/mysqld.sock

[mysqldump]
socket = /var/run/mysqld/mysqld.sock

quick
quote-names
max_allowed_packet = 16M

[mysql]
socket = /var/run/mysqld/mysqld.sock

[isamchk]
key_buffer = 16M

[mysqlhotcopy]
interactive-timeout