Skip to content

Instantly share code, notes, and snippets.

View nirbhayc's full-sized avatar

Nirbhay Choubey nirbhayc

  • Bloomberg LP
  • New York
View GitHub Profile
diff --git a/support-files/CMakeLists.txt b/support-files/CMakeLists.txt
index 2ab4350..c369e1d 100644
--- a/support-files/CMakeLists.txt
+++ b/support-files/CMakeLists.txt
@@ -79,16 +79,23 @@ IF(UNIX)
IF(HAVE_SYSTEMD)
CONFIGURE_FILE(mariadb.service.in
${CMAKE_CURRENT_BINARY_DIR}/mariadb.service @ONLY)
- IF(NOT RPM)
+ INSTALL(FILES use_galera_new_cluster.conf
MariaDB [test]> flush tables;
Query OK, 0 rows affected (0.00 sec)
MariaDB [test]> show variables like 'gtid_binlog_pos';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| gtid_binlog_pos | 0-1-3 |
+-----------------+-------+
1 row in set (0.00 sec)
// Free disk space using statvfs() and df -h.
#include <stdio.h>
#include <stdlib.h>
#include <sys/statvfs.h>
float _statvfs()
{
int err;
struct statvfs stat;
Configuration
=============
Node 1 :
[mysqld]
basedir=/home/nirbhay/project/git-repo/maria/10.1/install
datadir=/home/nirbhay/project/git-repo/maria/10.1/install/data1
log-bin
log-slave-updates
binlog_format=row
#include<stdio.h>
#include<unistd.h>
void main() {
char buff[100];
gethostname(buff, sizeof(buff));
printf("%s\n", buff);
}
# Case 1:
drop table if exists t1;
delimiter |
create function f1() returns int
begin
drop temporary table t1;
return 1;
end|
delimiter ;
diff --git a/sql/sql_base.cc b/sql/sql_base.cc
index 20e1836..da55889 100644
--- a/sql/sql_base.cc
+++ b/sql/sql_base.cc
@@ -274,7 +274,7 @@ static my_bool list_open_tables_callback(TDC_element *element,
(*arg->start_list)->in_use= 0;
mysql_mutex_lock(&element->LOCK_table_share);
- TDC_element::All_share_tables_list::Iterator it(element->all_tables);
+ TABLE_SHARE::All_share_tables_list::Iterator it(element->share->all_tables);
Thread 1 (Thread 0x7f9897f3e700 (LWP 3536)):
#0 0x00007f98956cc621 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x00007f989791dc2f in my_write_core (sig=11) at /home/nirbhay/project/git-repo/maria/bugs/10.2.b5535/mysys/stacktrace.c:456
#2 0x00007f98972ce554 in handle_fatal_signal (sig=11) at /home/nirbhay/project/git-repo/maria/bugs/10.2.b5535/sql/signal_handler.cc:273
#3 <signal handler called>
#4 0x00007f989703e04b in I_P_List_iterator<TABLE, I_P_List<TABLE, All_share_tables, I_P_List_null_counter, I_P_List_no_push_back<TABLE> > >::I_P_List_iterator (this=0x7f9897f3bdf0, a=...) at /home/nirbhay/project/git-repo/maria/bugs/10.2.b5535/sql/sql_plist.h:181
#5 0x00007f9897182d85 in TABLE_SHARE::visit_subgraph (this=0x7f9888b47e88, wait_for_flush=0x7f9897f3bef0, gvisitor=0x7f9897f3be80) at /home/nirbhay/project/git-repo/maria/bugs/10.2.b5535/sql/table.cc:3937
#6 0x00007f9897182cbf in Wait_for_flush::accept_visitor (this=0x7f9897f3bef0, gvisi
diff --git a/sql/table_cache.cc b/sql/table_cache.cc
index 95a169d..d6f20bd 100644
--- a/sql/table_cache.cc
+++ b/sql/table_cache.cc
@@ -522,7 +522,7 @@ void tdc_purge(bool all)
continue;
}
mysql_mutex_unlock(&LOCK_unused_shares);
-
+ share->tdc->wait_for_mdl_deadlock_detector();
Config file : ~/.mariadbrc
Commands:
* alias - list all aliases.
* alias name - show alias 'name'
* alias name=value - set alias name to value
* unalias name
* alias junk
bash: alias: junk: not found