[prev in list] [next in list] [prev in thread] [next in thread]
List: drbd-user
Subject: [DRBD-user] mysql crashes when I move the datafiles from its current mysql directory to drbd file sy
From: ARUN CHAKRAPANI RAO <arunrao_erp () yahoo ! com>
Date: 2014-05-13 11:13:17
Message-ID: 1399979597.36787.YahooMailNeo () web164704 ! mail ! gq1 ! yahoo ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hi,
I am new to this drbd configuration concept.
I am running mysql/drbd on a ubuntu 12.04 64 bit server running on vmware.
I am trying to move my existing mysql database to drbd file system, which is in turn \
replicating to another node. I shut down the db. edited the my.cnf file and updated \
the datadir to datadir = /var/lib/mysql_drbd
and
log_bin = /var/lib/mysql_drbd/mysql-bin.log
I copied all the files under the default mysql directory to this new drbd files.
set the permissions to the new file system to chown mysql:mysql /var/lib/mysql_drbd
started the db using service mysql start. it just crashes. but if I change the path \
to the original location it starts working fine.
Please do let me know if you have faced similar kind of an issue.
How to solve this. Is there any parameters which needs to be set in order for this db \
to be working on drbd file systems.
Any help greatly appreciated.
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 = 0 thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x29)[0x7f219dfb8989]
/usr/sbin/mysqld(handle_fatal_signal+0x483)[0x7f219de7dbd3]
/lib/x86_64-linux-gnu/libpthread.so.0(+0xfcb0)[0x7f219cbc7cb0]
/usr/sbin/mysqld(_ZN9MYSQL_LOG17generate_new_nameEPcPKc+0x9b)[0x7f219df1183b]
/usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG4openEPKc13enum_log_typeS1_10cache_typebmbb+0x204)[0x7f219df15684]
/usr/sbin/mysqld(+0x285461)[0x7f219dce4461]
/usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x624)[0x7f219dce7694]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed)[0x7f219c21d76d]
/usr/sbin/mysqld(+0x27e6d5)[0x7f219dcdd6d5]
[Attachment #5 (text/html)]
<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, \
courier, monaco, monospace, sans-serif;font-size:12pt">Hi,<br style="">I am new to \
this drbd configuration concept.<br style="" class="">I am running mysql/drbd on a \
ubuntu 12.04 64 bit server running on vmware.<br style="" class="">I am trying to \
move my existing mysql database to drbd file system, which is in turn replicating to \
another node.<br style="" class="">I shut down the db. edited the my.cnf file and \
updated the datadir to<br style="" \
class="">datadir \
= /var/lib/mysql_drbd<br style="" class="">and<br style="" \
class="">log_bin \
= /var/lib/mysql_drbd/mysql-bin.log<br style="" class=""><br style="" class="">I \
copied all the files under the default mysql directory to this new drbd files.<br \
style="" class="">set the permissions to the new file system to chown mysql:mysql \
/var/lib/mysql_drbd<br style="" class=""><br style="" class="">started the db using \
service mysql start. it just crashes. but if I change the path to the original \
location it starts working fine.<br><br>Please do let me know if you have faced \
similar kind of an issue.<br>How to solve this. Is there any parameters which needs \
to be set in order for this db to be working on drbd file systems.<br><br>Any help \
greatly appreciated.<br><br><br><br style="" class="">Attempting backtrace. You can \
use the following information to find out<br style="" class="">where mysqld died. If \
you see no messages after this, something went<br style="" class="">terribly \
wrong...<br style="" class="">stack_bottom = 0 thread_stack 0x30000<br style="" \
class="">/usr/sbin/mysqld(my_print_stacktrace+0x29)[0x7f219dfb8989]<br style="" \
class="">/usr/sbin/mysqld(handle_fatal_signal+0x483)[0x7f219de7dbd3]<br style="" \
class="">/lib/x86_64-linux-gnu/libpthread.so.0(+0xfcb0)[0x7f219cbc7cb0]<br style="" \
class="">/usr/sbin/mysqld(_ZN9MYSQL_LOG17generate_new_nameEPcPKc+0x9b)[0x7f219df1183b]<br \
style="" class="">/usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG4openEPKc13enum_log_typeS1_10cache_typebmbb+0x204)[0x7f219df15684]<br \
style="" class="">/usr/sbin/mysqld(+0x285461)[0x7f219dce4461]<br style="" \
class="">/usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x624)[0x7f219dce7694]<br style="" \
class="">/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed)[0x7f219c21d76d]<br \
style="" class="">/usr/sbin/mysqld(+0x27e6d5)[0x7f219dcdd6d5]<br style="" \
class=""><br style="" class=""><br style="" class=""><br style="" class=""><br \
style="" class=""></div></body></html>
_______________________________________________
drbd-user mailing list
drbd-user@lists.linbit.com
http://lists.linbit.com/mailman/listinfo/drbd-user
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic