[rt-users] RT 3.8.8 upgrade stacked on database upgrade

Josep Manel Andrés josep.andres at bsc.es
Thu Jul 2 08:55:22 EDT 2015


Hi all,
I went through all the documentation that I've found to upgrade from 
3.8.8 to 4.2.11(from old server to a new one) so what I am doing is:
I am using SLES12, MariaDB 10.0.16

-Create DDBB for the rt04
MariaDB [(none)]> create database rt4;

-Load rt3 dump to the new DDBB named rt4
mysql -u root -p --default-character-set=binary rt4 < /srv/tmp/rt3.sql

-Create schema
perl etc/upgrade/upgrade-mysql-schema.pl rt4 rt_user rt_pass > queries.sql

-Load schema
mysql -u rt_user -p rt4 < queries.sql

-Make upgrade
make upgrade-database

And at this point the upgrade stops and drops an error (after filling up 
the disk). I've got a 10G database within a 100G hard drive,

Proceed [y/N]:y
Processing 3.8.9
Now inserting data.
Processing 3.9.1
Now inserting data.
Processing 3.9.2
Now inserting data.
Processing 3.9.3
Now populating database schema.
Processing 3.9.5
Now populating database schema.
[11216] [Thu Jul  2 12:50:44 2015] [critical]: DBD::mysql::st execute 
failed: Lost connection to MySQL server during query at 
/root/rt-4.2.11/sbin/../lib/RT/Handle.pm line 552. 
(/root/rt-4.2.11/sbin/../lib/RT.pm:389)
DBD::mysql::st execute failed: Lost connection to MySQL server during 
query at /root/rt-4.2.11/sbin/../lib/RT/Handle.pm line 552.
Makefile:389: recipe for target 'upgrade-database' failed
make: *** [upgrade-database] Error 9



The file that is taking up the space is:

#sql-ib162-2876089901.ibd nearly 80G


Those are the logs from /var/log/mysql/mysqld.log

It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 
137034 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x48000
/usr/sbin/mysqld(my_print_stacktrace+0x29)[0xb72d89]
/usr/sbin/mysqld(handle_fatal_signal+0x515)[0x71dbc5]
/lib64/libpthread.so.0(+0xf890)[0x7f1effc44890]
/lib64/libc.so.6(gsignal+0x37)[0x7f1efea5b187]
/lib64/libc.so.6(abort+0x118)[0x7f1efea5c538]
/usr/sbin/mysqld[0x9eef64]
/lib64/libpthread.so.0(+0x80a4)[0x7f1effc3d0a4]
/lib64/libc.so.6(clone+0x6d)[0x7f1efeb0b08d]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
150702 14:50:45 mysqld_safe Number of processes running now: 0
150702 14:50:45 mysqld_safe mysqld restarted
150702 14:50:46 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150702 14:50:46 [Note] InnoDB: The InnoDB memory heap is disabled
150702 14:50:46 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150702 14:50:46 [Note] InnoDB: Memory barrier is not used
150702 14:50:46 [Note] InnoDB: Compressed tables use zlib 1.2.8


I would really appreciate any help on this.

Best regards.
Josep

WARNING / LEGAL TEXT: This message is intended only for the use of the
individual or entity to which it is addressed and may contain
information which is privileged, confidential, proprietary, or exempt
from disclosure under applicable law. If you are not the intended
recipient or the person responsible for delivering the message to the
intended recipient, you are strictly prohibited from disclosing,
distributing, copying, or in any way using this message. If you have
received this communication in error, please notify the sender and
destroy and delete any copies you may have received.

http://www.bsc.es/disclaimer



More information about the rt-users mailing list