percona-lab / mysql_random_data_load Goto Github PK
View Code? Open in Web Editor NEWMySQL random data loader
License: Apache License 2.0
MySQL random data loader
License: Apache License 2.0
Json column format is not supported:
INFO[2019-03-13T18:31:25Z] Starting
INFO[2019-03-13T18:31:25Z] cannot get field type: payload: json
Hey Carlos! :)
I have a request: can you add profiling support, such that I can see what's going on and report proper issues? I'm having some performance issues and I can't figure out what's going on :)
this shows the snippet of code you need to add, it's a single parameter and a small piece of code to handle it: https://blog.golang.org/profiling-go-programs
Thanks!!!
Using --version is not supported yet:
shell> ~/bin/mysql_random_data_loader --version
mysql_random_data_loader: error: unknown long flag '--version', try --help
When trying to use this tool in Docker's mysql: latest (8.0.12), the error INFO [0000] Can not set time zone to UTC: this authentication plugin is not supported
is displayed and can not be executed.
However, it works in Docker's mysql:5.6 case.
Also, in 8.0.12 the query SET @@ session.time_zone = "+00: 00";
could be executed directly.
Of course, the database schema is the same.
What is the cause?
On Ubuntu 16.04.4 LTS I get the following error. What's wrong?
I've installed go even if in the documentation is not mandatory.
panic: invalid argument to Int63n
goroutine 1 [running]:
math/rand.(*Rand).Int63n(0xc420066180, 0x8000000000000000, 0x3fc408d2ac22c4d3)
/usr/local/go/src/math/rand/rand.go:108 +0x10d
math/rand.Int63n(0x8000000000000000, 0x16a)
/usr/local/go/src/math/rand/rand.go:267 +0x37
github.com/Percona-Lab/mysql_random_data_load/internal/getters.(*RandomDecimal).Value(0xc42028c060, 0xc42010e180, 0xc42010e2d7)
/home/karl/golang/src/github.com/Percona-Lab/mysql_random_data_load/internal/getters/decimal.go:17 +0x85
github.com/Percona-Lab/mysql_random_data_load/internal/getters.(*RandomDecimal).String(0xc42028c060, 0xc42010e180, 0x16a)
/home/karl/golang/src/github.com/Percona-Lab/mysql_random_data_load/internal/getters/decimal.go:22 +0x2f
github.com/Percona-Lab/mysql_random_data_load/internal/getters.(*RandomDecimal).Quote(0xc42028c060, 0xc420084580, 0x155)
/home/karl/golang/src/github.com/Percona-Lab/mysql_random_data_load/internal/getters/decimal.go:26 +0x2b
main.run(0xc420011720, 0xc4200f2400, 0xc4200f2800, 0xc420020150, 0xc42028e000, 0x1c, 0x20, 0x1, 0xa, 0x807790, ...)
/home/karl/golang/src/github.com/Percona-Lab/mysql_random_data_load/main.go:251 +0x1bc
main.main()
/home/karl/golang/src/github.com/Percona-Lab/mysql_random_data_load/main.go:189 +0xbb4
Probably a similar issue with #27
MariaDB 10.6.5 Centos 7
[root@rafael-dagandan-node3 ~]# ./mysql_random_data_load --host=127.0.0.1 --port=3306 --user=test --password=test test service1 200 --debug
INFO[0000] cannot get table service1 struct: cannot read indexes: sql: expected 14 destination arguments in Scan, not 13
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| service1 | 0 | PRIMARY | 1 | ID | A | 0 | NULL | NULL | | BTREE | | | NO |
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
1 row in set (0.001 sec)```
When ANSI and/or ANSI_QUOTES is listed in sql_mode, the tool fails to insert rows to some tables.
It works with simple table like this:
mysql [localhost:5727] {msandbox} (test) > show create table t1\G
*************************** 1. row ***************************
Table: t1
Create Table: CREATE TABLE "t1" (
"id" int(11) DEFAULT NULL,
KEY "id" ("id")
)
1 row in set (0.00 sec)
$ mysql_random_data_load test t1 10 -u msandbox -p msandbox --host="127.0.0.1" -P 5727
INFO[2019-06-24T11:56:21+02:00] Starting
0s [====================================================================] 100%
INFO[2019-06-24T11:56:21+02:00] 10 rows inserted
But does not work for this table:
mysql [localhost:5727] {msandbox} (test) > show create table t3\G
*************************** 1. row ***************************
Table: t3
Create Table: CREATE TABLE "t3" (
"id" int(11) NOT NULL AUTO_INCREMENT,
"tcol01" tinyint(4) DEFAULT NULL,
"tcol02" smallint(6) DEFAULT NULL,
"tcol03" mediumint(9) DEFAULT NULL,
"tcol04" int(11) DEFAULT NULL,
"tcol05" bigint(20) DEFAULT NULL,
"tcol06" float DEFAULT NULL,
"tcol08" decimal(10,2) DEFAULT NULL,
"tcol09" date DEFAULT NULL,
"tcol10" datetime DEFAULT NULL,
"tcol11" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
"tcol12" time DEFAULT NULL,
"tcol13" year(4) DEFAULT NULL,
"tcol14" varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
"tcol15" char(2) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
"tcol16" blob,
"tcol17" text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
"tcol18" mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
"tcol19" mediumblob,
"tcol20" longblob,
"tcol21" longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
"tcol22" mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
"tcol23" varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
"tcol24" varbinary(10) DEFAULT NULL,
"tcol25" enum('a','b','c') CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
"tcol26" set('red','green','blue') CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
"tcol27" float(5,3) DEFAULT NULL,
"tcol28" double(4,2) DEFAULT NULL,
PRIMARY KEY ("id","tcol11")
)
1 row in set (0.00 sec)
$ mysql_random_data_load test t3 10 -u msandbox -p msandbox --host="127.0.0.1" -P 5727
INFO[2019-06-24T11:56:49+02:00] Starting
--- [--------------------------------------------------------------------] 0%
INFO[2019-06-24T11:56:50+02:00] 0 rows inserted
Tested with
Version : v0.1.10
Commit : 77ba5b493094d79318d941ea45f43268115c7be1
Branch : master
Build : 2018-10-10T16:39:41-0300
Go version: go1.11.1
Don't know what specifically caused this
[root@ip-10-0-0-170 ~]# mysql_random_data_load --version xx xx 2
Version : v0.1.10
Commit : 77ba5b493094d79318d941ea45f43268115c7be1
Branch : master
Build : 2018-10-10T16:39:41-0300
Go version: go1.11.1
panic: runtime error: integer divide by zero
goroutine 1 [running]:
main.main()
/home/karl/go/src/github.com/Percona-Lab/mysql_random_data_load/main.go:187 +0x1536
I tried to use your program on Debian 9. It says:
INFO[0000] Cannot set time zone to UTC: Error 2003: Authentication with backend failed. Session will be closed.
How can I solve this problem? I need to test my database cluster.
Anyone having same issue?
(Centos 7 x64)
./mysql_random_data_load test test 10 --bulk-size=1 -h 127.0.0.1 --max-threads=1 --print -u root -p test
panic: invalid argument to Int63n
goroutine 1 [running]:a
math/rand.(*Rand).Int63n(0xc00008e180, 0x8000000000000000, 0x3fc408d2ac22c4d3)
/usr/local/go/src/math/rand/rand.go:111 +0x10d
math/rand.Int63n(0x8000000000000000, 0x16d)
/usr/local/go/src/math/rand/rand.go:319 +0x37
github.com/Percona-Lab/mysql_random_data_load/internal/getters.(*RandomDecimal).Value(0xc0001f6440, 0xc0002fe000, 0xc0002fe15a)
/home/karl/go/src/github.com/Percona-Lab/mysql_random_data_load/internal/getters/decimal.go:17 +0x85
github.com/Percona-Lab/mysql_random_data_load/internal/getters.(*RandomDecimal).String(0xc0001f6440, 0xc0002fe000, 0x16d)
/home/karl/go/src/github.com/Percona-Lab/mysql_random_data_load/internal/getters/decimal.go:22 +0x2f
github.com/Percona-Lab/mysql_random_data_load/internal/getters.(*RandomDecimal).Quote(0xc0001f6440, 0xc0000b66e0, 0x158)
/home/karl/go/src/github.com/Percona-Lab/mysql_random_data_load/internal/getters/decimal.go:26 +0x2b
main.run(0xc0001220c0, 0xc000114480, 0xc000114700, 0xc00006c0e0, 0xc0002d2000, 0x1c, 0x20, 0xa, 0x1, 0xc00005b8c0, ...)
/home/karl/go/src/github.com/Percona-Lab/mysql_random_data_load/main.go:273 +0x1f1
main.main()
/home/karl/go/src/github.com/Percona-Lab/mysql_random_data_load/main.go:211 +0xa1a
Currently, there is no support for tinytext data type:
$ ~/src/go/src/github.com/Percona-Lab/mysql_random_data_load/build/mysql_random_data_load --user=root --password=msandbox --host=127.0.0.1 --port=12999 test articles 1000
INFO[2018-03-30T16:12:33-04:00] Starting
INFO[2018-03-30T16:12:33-04:00] cannot get field type: summary: tinytext
0s [====================================================================] 100%
INFO[2018-03-30T16:12:38-04:00] 1000 rows inserted
mysql [localhost] {msandbox} (sakila) > show create table actor\G
*************************** 1. row ***************************
Table: actor
Create Table: CREATE TABLE `actor` (
`actor_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`first_name` varchar(45) NOT NULL,
`last_name` varchar(45) NOT NULL,
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`actor_id`),
KEY `idx_actor_last_name` (`last_name`)
) ENGINE=InnoDB AUTO_INCREMENT=65535 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
SELECT COUNT(*) FROM actor;
+----------+
| COUNT(*) |
+----------+
| 0 |
+----------+
1 row in set (0.00 sec)
As we can see, the PK is a smallint, the table is empty, and the AUTO_INCREMENT value is at 65535 (this was a table that was full, then all rows were deleted).
If we try to use the tool, it will insert only one row, and will error out with duplicate key errors:
mysql_random_data_load_linux_amd64 sakila actor 5 --host=127.0.0.1 --port=12323 --user=msandbox --password=msandbox
2017/12/22 00:12:29 Starting
2017/12/22 00:12:29 cannot run insert: Error 1467: Failed to read auto-increment value from storage engine
2017/12/22 00:12:29 Adding extra 5 rows.
0s [============>-------------------------------------------------------] 20%
Error 1062: Duplicate entry '65535' for key 'PRIMARY'
Error 1062: Duplicate entry '65535' for key 'PRIMARY'
Error 1062: Duplicate entry '65535' for key 'PRIMARY'
...
Only one row is inserted:
SELECT * FROM actor;
+----------+-----------------------------------------------+-----------------------------------------------+---------------------+
| actor_id | first_name | last_name | last_update |
+----------+-----------------------------------------------+-----------------------------------------------+---------------------+
| 65535 | fugiat ratione tempora quia aliquam nulla dol | tempore aut harum debitis corporis sed repell | 2017-08-29 05:09:01 |
+----------+-----------------------------------------------+-----------------------------------------------+---------------------+
1 row in set (0.00 sec)
It may make sense to try to choose another PK value on error.
Instead of the tool generating and running the SQL commands needed to insert data, add a new flag that can instead print the queries needed to STDOUT (or file), without running them.
It should still need connection to the server to get table definitions.
Hi,
I get the following error when trying to insert 1000 random rows to any of my tables that have triggers defined on them:
INFO[0028] cannot get table tableName struct: cannot read trigger: sql: Scan error on column index 5: unsupported Scan, storing driver.Value type into type *time.Time
Last release version was shipped in 2019 and the PR fix: --max-fk-samples was not applied #36 is merged, though new release build is pending.
Hi Percona guys,
Seems dumb but I've run make as root in amazon linux 2017, /bin deleted as result, It was a test vm. But ...
Thanks in advance!
With version 0.1.10 on macOS X 10.14.5
~/chefdb ./mysql_random_data_load chefdb clients 1000 --user=root
INFO[0000] cannot get table clients struct: cannot read indexes: sql: expected 15 destination arguments in Scan, not 13
mysql> show indexes from clients;
+---------+------------+-------------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Visible | Expression |
+---------+------------+-------------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+
| clients | 0 | PRIMARY | 1 | clients_id | A | 0 | NULL | NULL | | BTREE | | | YES | NULL |
| clients | 0 | clients_hostname_UNIQUE | 1 | clients_hostname | A | 0 | NULL | NULL | YES | BTREE | | | YES | NULL |
+---------+------------+-------------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+------------+
2 rows in set (0.00 sec)
It appears the the bit
type is not handled correctly
[root@ip-10-0-0-170 ~]# mysql_random_data_load --version x x 2
Version : v0.1.10
Commit : 77ba5b493094d79318d941ea45f43268115c7be1
Branch : master
Build : 2018-10-10T16:39:41-0300
Go version: go1.11.1
[root@ip-10-0-0-170 ~]# rpm -qa|grep Percona
Percona-Server-client-57-5.7.27-30.1.el6.x86_64
Percona-Server-57-debuginfo-5.7.27-30.1.el6.x86_64
Percona-Server-shared-57-5.7.27-30.1.el6.x86_64
Percona-Server-server-57-5.7.27-30.1.el6.x86_64
BIT
type with DEFAULT NULL
[root@ip-10-0-0-170 ~]# mysql theswamp -e "show create table customer2"
+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| customer2 | CREATE TABLE `customer2` (
`customer_id` bigint(20) NOT NULL,
`receive_fx_insight_emails` bit(1) DEFAULT NULL,
PRIMARY KEY (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
[root@ip-10-0-0-170 ~]# mysql_random_data_load --no-progress --max-threads=1 --bulk-size=5000 theswamp customer2 5
INFO[2019-10-10T14:17:42Z] Starting
INFO[2019-10-10T14:17:42Z] cannot get field type: receive_fx_insight_emails: bit
INFO[2019-10-10T14:17:43Z] 5 rows inserted
[root@ip-10-0-0-170 ~]# mysql theswamp -e "select * from customer2"
+---------------------+---------------------------+
| customer_id | receive_fx_insight_emails |
+---------------------+---------------------------+
| 3916589616287113937 | NULL |
| 4037200794235010051 | NULL |
| 5577006791947779410 | NULL |
| 6129484611666145821 | NULL |
| 8674665223082153551 | NULL |
+---------------------+---------------------------+
BIT
type with NOT NULL
[root@ip-10-0-0-170 ~]# mysql theswamp -e 'show create table customer3'
+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| customer3 | CREATE TABLE `customer3` (
`customer_id` bigint(20) NOT NULL,
`receive_fx_insight_emails` bit(1) NOT NULL,
PRIMARY KEY (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
[root@ip-10-0-0-170 ~]# mysql_random_data_load --no-progress --max-threads=1 --bulk-size=5000 theswamp customer3 5
INFO[2019-10-10T14:23:55Z] Starting
INFO[2019-10-10T14:23:55Z] cannot get field type: receive_fx_insight_emails: bit
INFO[2019-10-10T14:23:56Z] 5 rows inserted
[root@ip-10-0-0-170 ~]# mysql theswamp -e 'select * from customer3;'
+---------------------+---------------------------+
| customer_id | receive_fx_insight_emails |
+---------------------+---------------------------+
| 3916589616287113937 | |
| 4037200794235010051 | |
| 5577006791947779410 | |
| 6129484611666145821 | |
| 8674665223082153551 | |
+---------------------+---------------------------+
Greetings,
Trying to compile on FreeBSD. I'm I missing something?
[root@master] ~/.gopkg/src/github.com/github/mysql_random_data_load# go build main.go
main.go:13:2: use of internal package not allowed
[root@master] ~/.gopkg/src/github.com/github/mysql_random_data_load# go get -t -v ./... main.go:13:2: use of internal package not allowed
main.go line:13
"github.com/Percona-Lab/mysql_random_data_load/internal/getters"
"github.com/Percona-Lab/mysql_random_data_load/tableparser"
Fixed by using:
go get -u -v github.com/Percona-Lab/mysql_random_data_load
CREATE TABLE `u1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`u1` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `u1` (`u1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
./random_data_load_linux_amd64 -uroot -p*** -h192.168.3.2 test u1 100;
2017/09/19 06:47:25 Starting
2017/09/19 06:47:25 Error inserting values: Error 1062: Duplicate entry '25630' for key 'u1'
For some reason, it is broken now (used to work correctly):
agustin@bm-support01 ~/bin $ mysql_random_data_load --version
FATA[0000] required argument 'database' not provided
agustin@bm-support01 ~/bin $ mysql_random_data_load --version db
FATA[0000] required argument 'table' not provided
agustin@bm-support01 ~/bin $ mysql_random_data_load --version db table
FATA[0000] required argument 'rows' not provided
agustin@bm-support01 ~/bin $ mysql_random_data_load --version db table 23
Version : v0.1.10
Commit : 77ba5b493094d79318d941ea45f43268115c7be1
Branch : master
Build : 2018-10-10T16:39:41-0300
Go version: go1.11.1
I found that these parameters are not working, I read source code, samples and factors are using a fix-number rather than a parameter value.
In mysql 5.5 versions, the information_schema.columns doesn't have the DATETIME_PRECISION column, so there were errors when trying to run against 5.5:
ERRO[0000] Cannot get table fields: sql: expected 19 destination arguments in Scan, not 20
The following function should be changed (PR in progress for this):
https://github.com/Percona-Lab/mysql_random_data_load/blob/master/tableparser/tableparser.go#L213
This is below Low priority, but below it shows the options and --Print does not work, but --print does. Maybe a typo? Thanks
Option | Description |
---|---|
--bulk-size | Number of rows per INSERT statement (Default: 1000) |
--debug | Show some debug information |
--fk-samples-factor | Percentage used to get random samples for foreign keys fields. Default 0.3 |
--host | Host name/ip |
--max-fk-samples | Maximum number of samples for fields having foreign keys constarints. Default: 100 |
--max-retries | Maximum number of rows to retry in case of errors. See duplicated keys. Deafult: 100 |
--no-progressbar | Skip showing the progress bar. Default: false |
--password | Password |
--port | Port number |
Print queries to the standard output instead of inserting them into the db | |
--user | Username |
--version | Show version and exit |
While testing a legacy system I had problems inserting data into a column named "Behörighet", among others.
With that example the column name in the query becomes "Beh%C3%B6righet", which gives an error with --debug
DEBU[2021-05-11T10:40:49+02:00] Cannot run insert: Error 1054: Unknown column 'Beh%C3%B6righet' in 'field list'
I believe we could use output of SHOW INDEX STATUS
to find out how many unique values each column should present.
+------------------------+------------+--------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------------------+------------+--------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| performance_by_affcode | 0 | PRIMARY | 1 | id | A | 2183073712 | NULL | NULL | | BTREE | | |
| performance_by_affcode | 0 | affcode_per_day | 1 | profile_id | A | 1113 | NULL | NULL | YES | BTREE | | |
| performance_by_affcode | 0 | affcode_per_day | 2 | ad_id_in_target | A | 8838355 | NULL | NULL | YES | BTREE | | |
| performance_by_affcode | 0 | affcode_per_day | 3 | affcode | A | 33076874 | NULL | NULL | | BTREE | | |
| performance_by_affcode | 0 | affcode_per_day | 4 | date | A | 2183073712 | NULL | NULL | | BTREE | | |
| performance_by_affcode | 1 | campaign_id_date | 1 | campaign_id | A | 447 | NULL | NULL | YES | BTREE | | |
| performance_by_affcode | 1 | campaign_id_date | 2 | date | A | 326563 | NULL | NULL | | BTREE | | |
| performance_by_affcode | 1 | last_updated | 1 | last_updated | A | 13311425 | NULL | NULL | | BTREE | | |
| performance_by_affcode | 1 | profile_ad_id_date | 1 | profile_id | A | 919 | NULL | NULL | YES | BTREE | | |
| performance_by_affcode | 1 | profile_ad_id_date | 2 | ad_id_in_target | A | 10754057 | NULL | NULL | YES | BTREE | | |
| performance_by_affcode | 1 | profile_ad_id_date | 3 | date | A | 2183073712 | NULL | NULL | | BTREE | | |
| performance_by_affcode | 1 | profile_affcode | 1 | profile_id | A | 763 | NULL | NULL | YES | BTREE | | |
| performance_by_affcode | 1 | profile_affcode | 2 | affcode | A | 31638749 | NULL | NULL | | BTREE | | |
| performance_by_affcode | 1 | profile_id_date | 1 | profile_id | A | 723 | NULL | NULL | YES | BTREE | | |
| performance_by_affcode | 1 | profile_id_date | 2 | date | A | 265387 | NULL | NULL | | BTREE | | |
+------------------------+------------+--------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
The maximum cardinality value would be the total rows to generate, and you can nest-loop from largest to smallest. So if you had columns A, B and C with cardinality 2, 3 and 6 respectively you would end up with
A | B | C
---+---+----
1 | 1 | 1
2 | 2 | 2
1 | 3 | 3
2 | 1 | 4
1 | 2 | 5
2 | 3 | 6
[note for usage: if an index does not exists customer could provide SELECT COUNT(DISTINCT...) for the relevant columns and we could manually add lines to the output based on that to test on our side]
what is error?
INFO[0000] cannot get table film struct: cannot read trigger: sql: Scan error on column index 5: unsupported Scan, storing driver.Value type into type *time.Time
failed to build, getters.NewRandomBinary
is undefined.
/main.go:426:28: undefined: getters.NewRandomBinary
create a smaller table then in the example.
mysql> CREATE TABLE eric.t2( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, t TIME DEFAULT NULL, vc10 VARCHAR(10), vc25 VARCHAR(25), vc100 VARCHAR(100), ts TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, dt DATETIME DEFAULT NULL, e ENUM( 'x', 'a', 'b', 'c', 'd', 'e', 'f' ) NOT NULL ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_0900_as_cs;
try to add some data and get the following INFO error. no data in the table.
$ mysql_random_data_loader --host="127.0.0.1" --user=root --password=xxx eric t2 500 INFO[0000] cannot get table t2 struct: cannot read indexes: sql: expected 14 destination arguments in Scan, not 13
I'm on a Mac with mysql v.8.0.3
The tool is currently returning the following:
2017/11/29 20:01:17 cannot get table table_fulltext struct: cannot read constraints: sql: Scan error on column index 5: unsupported Scan, storing driver.Value type <nil> into type *string
CREATE TABLE `table_fulltext` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`string` text NOT NULL,
PRIMARY KEY (`id`),
KEY `string` (`string`(15)),
FULLTEXT KEY `FT_string` (`string`)
) ENGINE=InnoDB;
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.