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