database_issues's People
database_issues's Issues
Got error 168 from storage engine
When I create a table, It doesn't work
[2019-03-30 10:31:51] [HY000][1030] Got error 168 from storage engine
[2019-03-30 10:31:51] [HY000][1030] Got error 168 from storage engine
Any ideas how to fix it? I've tried to google this problem, but couldn't find anything useful.
5-8.2 大数据归档-搭建Replication集群
as
I can't see the database on mycat?
[root@my-08-01 conf]# grep t_list_1 schema.xml
<table name="t_list_1" dataNode="dn1,dn2" rule="sharding-province" />
[root@my-08-01 conf]# grep t_hash_1 schema.xml
<table name="t_hash_1" dataNode="dn1,dn2" rule="sharding-province" />
[root@my-08-01 bin]# ./mycat restart
Stopping Mycat-server...
Mycat-server was not running.
Starting Mycat-server...
On PXC node 1 and node 2, Here's what I did:
use test;
CREATE TABLE t_hash_1(
id int unsigned primary key ,
name VARCHAR(200) NOT NULL ,
province_id INT UNSIGNED NOT NULL
)
PARTITION BY HASH ( id ) PARTITIONS 2(
PARTITION p0
DATA DIRECTORY ="/mnt/p0/data",
PARTITION p1
DATA DIRECTORY ="/mnt/p1/data"
);
I've done the refresh
But I don't see the database on the mycat node?
02. 2019-3-27 Lost connection to MySQL server during query
mysql> show engines;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 5
Current database: *** NONE ***
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| InnoDB | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| MyISAM | YES | MyISAM storage engine | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.00 sec)
mysql> show plugins;
....
....
| TokuDB_background_job_status | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_file_map | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_fractal_tree_block_map | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_fractal_tree_info | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_locks | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_lock_waits | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| TokuDB_trx | ACTIVE | INFORMATION SCHEMA | ha_tokudb.so | GPL |
| validate_password | ACTIVE | VALIDATE PASSWORD | validate_password.so | GPL |
+-------------------------------+----------+--------------------+----------------------+---------+
mysql> INSTALL PLUGIN tokudb SONAME 'ha_tokudb.so';
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> INSTALL PLUGIN tokudb_file_map SONAME 'ha_tokudb.so';
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 4
Current database: *** NONE ***
ERROR 1125 (HY000): Function 'tokudb_file_map' already exists
ERROR 2013 (HY000): Lost connection to MySQL server during query
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.