[MDEV-18847] Assertion failure in file ha_innodb.cc line 9690, Failing assertion: ut_strcmp(index->name, key->name) == 0 - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Duplicate
Affects Version/s: 10.2.17
Fix Version/s: N/A
Component/s: Data Definition - Alter Table, Storage Engine - InnoDB
Labels:
None
Environment:
Gentoo 4.14.13, 2x E5-2620

Description

2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:10 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610613581568 [ERROR] InnoDB: Index for key no 1 mysql name axcfgrtys_axcfgrtypr_lorzutc_id_cd08a4ed_fk_lorzutcs_ Inno
DB name lorzutc_id for table datbas/#sql-3ea1_2650bebf
2019-03-06 16:15:11 140610613581568 [Note] InnoDB: Index for key no 1 mysql name axcfgrtys_axcfgrtypr_lorzutc_id_cd08a4ed_fk_lorzutcs_ InnoD
B name PRIMARY for table datbas/#sql-3ea1_2650bebf
2019-03-06 16:15:11 140610613581568 [Note] InnoDB: Index for key no 1 mysql name axcfgrtys_axcfgrtypr_lorzutc_id_cd08a4ed_fk_lorzutcs_ InnoD
B name lorzutc_id for table datbas/#sql-3ea1_2650bebf
2019-03-06 16:15:11 0x7fe275ac9700 InnoDB: Assertion failure in file /var/tmp/portage/dev-db/mariadb-10.2.17/work/mysql/storage/innobase/han
dler/ha_innodb.cc line 9690
InnoDB: Failing assertion: ut_strcmp(index->name, key->name) == 0
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: https://mariadb.com/kb/en/library/xtradbinnodb-recovery-modes/
InnoDB: about forcing recovery.
190306 16:15:11 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

Server version: 10.2.17-MariaDB-log
key_buffer_size=134217728
read_buffer_size=524288
max_used_connections=382
max_threads=1502
thread_count=310

Thread pointer: 0x7fe1b8312118
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...
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
stack_bottom = 0x7fe275ac8e78 thread_stack 0x49000
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'
2019-03-06 16:15:11 140610624640768 [ERROR] Invalid (old?) table or database name '#sql-3ea1_2650bebf'

/usr/sbin/mysqld(my_print_stacktrace+0x29)[0x5586cc507889]
/usr/sbin/mysqld(handle_fatal_signal+0x57b)[0x5586cc04e81b]
/lib64/libpthread.so.0(+0x14180)[0x7fe5e06d6180]
/lib64/libc.so.6(gsignal+0x110)[0x7fe5df1a6f90]
/lib64/libc.so.6(abort+0x1c7)[0x7fe5df1a8ae7]
/usr/sbin/mysqld(+0x3fed44)[0x5586cbe49d44]
/usr/sbin/mysqld(+0x773bfb)[0x5586cc1bebfb]
/usr/sbin/mysqld(+0x77bed3)[0x5586cc1c6ed3]
/usr/sbin/mysqld(+0x77dbb7)[0x5586cc1c8bb7]
/usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcij+0x2a)[0x5586cc05250a]
/usr/sbin/mysqld(_Z21open_table_from_shareP3THDP11TABLE_SHAREPKcjjjP5TABLEb+0x7de)[0x5586cbf88bae]
/usr/sbin/mysqld(_ZN3THD20open_temporary_tableEP15TMP_TABLE_SHAREPKcb+0x5d)[0x5586cbfffffd]
/usr/sbin/mysqld(_ZN3THD25create_and_open_tmp_tableEP10handlertonP34st_mysql_const_unsigned_lex_stringPKcS5_S5_b+0x32)[0x5586cc001c02]
/usr/sbin/mysqld(_Z17mysql_alter_tableP3THDPcS1_P14HA_CREATE_INFOP10TABLE_LISTP10Alter_infojP8st_orderb+0x3794)[0x5586cbf69d04]
/usr/sbin/mysqld(_ZN19Sql_cmd_alter_table7executeEP3THD+0x50c)[0x5586cbfaea4c]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0xccf)[0x5586cbee919f]
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x289)[0x5586cbeef869]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x101e)[0x5586cbef0f4e]
/usr/sbin/mysqld(_Z10do_commandP3THD+0xdf)[0x5586cbef257f]
/usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x204)[0x5586cbfabea4]
/usr/sbin/mysqld(handle_one_connection+0x34)[0x5586cbfabf74]
/lib64/libpthread.so.0(+0x792a)[0x7fe5e06c992a]
/lib64/libc.so.6(clone+0x3f)[0x7fe5df27361f]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7fe1b86f67d0): is an invalid pointer
Connection ID (thread ID): 642825919
Status: NOT_KILLED

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on

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.

We think the query pointer is invalid, but we will try to print it anyway.
Query: ALTER TABLE `axcfgrtys_axcfgrtyprlorzutcasde` ADD CONSTRAINT `axcfgrtys_axcfgrtypr_lorzutc_id_cd08a4ed_fk_lorzutcs_` FOREIGN KEY (`lorzutc_id`) REFERENCES `lorzutcs_lorzutc` (`id`)

Attachments

Issue Links

duplicates

MDEV-16060 InnoDB: Failing assertion: ut_strcmp(index->name, key->name)

Closed

relates to

MDEV-19037 Crashing on adding index / index name could not added again in same tablespace

Closed

Activity

Ascending order - Click to sort in descending order

Sergey Vojtovich added a comment - 2019-03-07 09:39

Please also specify both table definitions.

Sergey Vojtovich added a comment - 2019-03-07 09:39 Please also specify both table definitions.

Sergey Vojtovich added a comment - 2019-03-07 09:43

Thinking more on this: it very likely relates to ~~MDEV-17595~~, but not exactly the same issue.

Sergey Vojtovich added a comment - 2019-03-07 09:43 Thinking more on this: it very likely relates to MDEV-17595 , but not exactly the same issue.

Mikhail Zheltukhin added a comment - 2019-03-07 09:53

table axcfgrtys_axcfgrtyprlorzutcasde

Field Type Null Key Default Extra

id int(11) NO PRI NULL auto_increment
datetime(6) NO NULL
datetime(6) NO NULL
varchar(1) NO NULL
longtext NO NULL
longtext NO NULL
int(11) NO NULL
int(11) YES NULL
int(11) YES NULL
longtext YES NULL
lorzutc_id int(11) NO MUL NULL

table lorzutcs_lorzutc
Field Type Null Key Default Extra

id                                   int(11)               NO    PRI NULL     auto_increment
varchar(1)            NO         NULL
varchar(120)          NO         NULL
longtext              NO         NULL
varchar(100)          NO         NULL
int(10) unsigned      YES      NULL
int(10) unsigned      NO         NULL
datetime              NO         NULL
tinyint(1)            NO         NULL
int(10) unsigned      NO         NULL
int(10) unsigned      NO         NULL
int(11)               YES MUL NULL
int(10) unsigned      NO         NULL
smallint(5) unsigned NO         NULL
tinyint(1)            NO         NULL
varchar(120)          NO         NULL
varchar(1)            NO         NULL
tinyint(1)            NO         NULL
varchar(255)          YES      NULL
varchar(32)           NO         NULL
int(10) unsigned      NO         NULL
int(10) unsigned      NO         NULL
int(11)               YES      NULL
varchar(100)          YES      NULL
int(11)               YES      NULL
varchar(1)            NO         NULL
int(10) unsigned      YES      NULL
int(11)               YES MUL NULL
longtext              NO         NULL
tinyint(1)            NO         NULL
int(10) unsigned      NO         NULL
int(11)               YES MUL NULL
int(10) unsigned      NO         NULL
longtext              NO         NULL
longtext              NO         NULL
int(10) unsigned      NO         NULL
longtext              NO         NULL
longtext              NO         NULL
datetime              YES      NULL
tinyint(1)            NO         NULL
int(10) unsigned      NO         NULL
varchar(90)           YES      NULL
varchar(90)           YES      NULL
tinyint(1)            NO         0
varchar(200)          YES      NULL
tinyint(1)            NO         NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
varchar(120)          YES      NULL
varchar(120)          YES      NULL
varchar(120)          YES      NULL
varchar(120)          YES      NULL
varchar(120)          YES      NULL
varchar(120)          YES      NULL
varchar(120)          YES      NULL
varchar(120)          YES      NULL
varchar(120)          YES      NULL
varchar(120)          YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
int(10) unsigned      NO         NULL
datetime(6)           YES      NULL
tinyint(1)            YES      NULL
varchar(256)          YES      NULL
tinyint(1)            NO         NULL
tinyint(1)            NO         NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL
longtext              YES      NULL

Mikhail Zheltukhin added a comment - 2019-03-07 09:53 table axcfgrtys_axcfgrtyprlorzutcasde Field Type Null Key Default Extra id int(11) NO PRI NULL auto_increment datetime(6) NO NULL datetime(6) NO NULL varchar(1) NO NULL longtext NO NULL longtext NO NULL int(11) NO NULL int(11) YES NULL int(11) YES NULL longtext YES NULL lorzutc_id int(11) NO MUL NULL table lorzutcs_lorzutc Field Type Null Key Default Extra id int(11) NO PRI NULL auto_increment varchar(1) NO NULL varchar(120) NO NULL longtext NO NULL varchar(100) NO NULL int(10) unsigned YES NULL int(10) unsigned NO NULL datetime NO NULL tinyint(1) NO NULL int(10) unsigned NO NULL int(10) unsigned NO NULL int(11) YES MUL NULL int(10) unsigned NO NULL smallint(5) unsigned NO NULL tinyint(1) NO NULL varchar(120) NO NULL varchar(1) NO NULL tinyint(1) NO NULL varchar(255) YES NULL varchar(32) NO NULL int(10) unsigned NO NULL int(10) unsigned NO NULL int(11) YES NULL varchar(100) YES NULL int(11) YES NULL varchar(1) NO NULL int(10) unsigned YES NULL int(11) YES MUL NULL longtext NO NULL tinyint(1) NO NULL int(10) unsigned NO NULL int(11) YES MUL NULL int(10) unsigned NO NULL longtext NO NULL longtext NO NULL int(10) unsigned NO NULL longtext NO NULL longtext NO NULL datetime YES NULL tinyint(1) NO NULL int(10) unsigned NO NULL varchar(90) YES NULL varchar(90) YES NULL tinyint(1) NO 0 varchar(200) YES NULL tinyint(1) NO NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL varchar(120) YES NULL varchar(120) YES NULL varchar(120) YES NULL varchar(120) YES NULL varchar(120) YES NULL varchar(120) YES NULL varchar(120) YES NULL varchar(120) YES NULL varchar(120) YES NULL varchar(120) YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL int(10) unsigned NO NULL datetime(6) YES NULL tinyint(1) YES NULL varchar(256) YES NULL tinyint(1) NO NULL tinyint(1) NO NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL longtext YES NULL

Elena Stepanova added a comment - 2019-03-07 10:34

svoj

Thinking more on this: it very likely relates to ~~MDEV-17595~~, but not exactly the same issue.

~~MDEV-16060~~ seems to be even more likely relation.

Elena Stepanova added a comment - 2019-03-07 10:34 svoj Thinking more on this: it very likely relates to MDEV-17595 , but not exactly the same issue. MDEV-16060 seems to be even more likely relation.

Sergey Vojtovich added a comment - 2019-03-07 10:49

mike_z, what we need is SHOW CREATE TABLE output.

elenst, yes, sure. But ~~MDEV-17595~~ is very close as well.

Sergey Vojtovich added a comment - 2019-03-07 10:49 mike_z , what we need is SHOW CREATE TABLE output. elenst , yes, sure. But MDEV-17595 is very close as well.

Mikhail Zheltukhin added a comment - 2019-03-07 11:43 - edited

Table: lorzutcs_lorzutc

Create Table: CREATE TABLE `lorzutc` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `kind` varchar(1) NOT NULL,

  `title` varchar(120) NOT NULL,

  `descr` longtext NOT NULL,

  `picture` varchar(100) NOT NULL,

  `price` int(10) unsigned DEFAULT NULL,

  `priority` int(10) unsigned NOT NULL,

  `date_added` datetime NOT NULL,

  `is_published` tinyint(1) NOT NULL,

  `reds_total` int(10) unsigned NOT NULL,

  `reds_reserved` int(10) unsigned NOT NULL,

  `fork_id` int(11) DEFAULT NULL,

  `reds_engaged` int(10) unsigned NOT NULL,

  `color` smallint(5) unsigned NOT NULL,

  `is_rare` tinyint(1) NOT NULL,

  `subtitle` varchar(120) NOT NULL,

  `drop` varchar(1) NOT NULL,

  `dust_ended` tinyint(1) NOT NULL,

  `ext_id` varchar(255) DEFAULT NULL,

  `platform_type` varchar(32) NOT NULL,

  `cnt_sold` int(10) unsigned NOT NULL,

  `cnt_to_sell` int(10) unsigned NOT NULL,

  `robot_needed` int(11) DEFAULT NULL,

  `share_picture` varchar(100) DEFAULT NULL,

  `robot_quest_id` int(11) DEFAULT NULL,

  `currency` varchar(1) NOT NULL,

  `call_drop_amount` int(10) unsigned DEFAULT NULL,

  `call_drop_lorzutc_id` int(11) DEFAULT NULL,

  `call_hint_text` longtext NOT NULL,

  `no_quantity_discount` tinyint(1) NOT NULL,

  `morning_amount` int(10) unsigned NOT NULL,

  `morning_type_id` int(11) DEFAULT NULL,

  `limit_daily` int(10) unsigned NOT NULL,

  `limit_error_daily` longtext NOT NULL,

  `limit_error_total` longtext NOT NULL,

  `limit_total` int(10) unsigned NOT NULL,

  `limit_warning_daily` longtext NOT NULL,

  `limit_warning_total` longtext NOT NULL,

  `date_finish` datetime DEFAULT NULL,

  `only_corp` tinyint(1) NOT NULL,

  `robot_coins_amount` int(10) unsigned NOT NULL,

  `first_tag` varchar(90) DEFAULT NULL,

  `second_tag` varchar(90) DEFAULT NULL,

  `is_free` tinyint(1) NOT NULL DEFAULT 0,

  `instruction_for_red_activation_url` varchar(200) DEFAULT NULL,

  `use_instruction_for_red_activation` tinyint(1) NOT NULL,

  `descr_de` longtext DEFAULT NULL,

  `descr_en` longtext DEFAULT NULL,

  `descr_fr` longtext DEFAULT NULL,

  `descr_pl` longtext DEFAULT NULL,

  `descr_ru` longtext DEFAULT NULL,

  `call_hint_text_de` longtext DEFAULT NULL,

  `call_hint_text_en` longtext DEFAULT NULL,

  `call_hint_text_fr` longtext DEFAULT NULL,

  `call_hint_text_pl` longtext DEFAULT NULL,

  `call_hint_text_ru` longtext DEFAULT NULL,

  `subtitle_de` varchar(120) DEFAULT NULL,

  `subtitle_en` varchar(120) DEFAULT NULL,

  `subtitle_fr` varchar(120) DEFAULT NULL,

  `subtitle_pl` varchar(120) DEFAULT NULL,

  `subtitle_ru` varchar(120) DEFAULT NULL,

  `title_de` varchar(120) DEFAULT NULL,

  `title_en` varchar(120) DEFAULT NULL,

  `title_fr` varchar(120) DEFAULT NULL,

  `title_pl` varchar(120) DEFAULT NULL,

  `title_ru` varchar(120) DEFAULT NULL,

  `limit_error_daily_de` longtext DEFAULT NULL,

  `limit_error_daily_en` longtext DEFAULT NULL,

  `limit_error_daily_fr` longtext DEFAULT NULL,

  `limit_error_daily_pl` longtext DEFAULT NULL,

  `limit_error_daily_ru` longtext DEFAULT NULL,

  `limit_error_total_de` longtext DEFAULT NULL,

  `limit_error_total_en` longtext DEFAULT NULL,

  `limit_error_total_fr` longtext DEFAULT NULL,

  `limit_error_total_pl` longtext DEFAULT NULL,

  `limit_error_total_ru` longtext DEFAULT NULL,

  `limit_warning_daily_de` longtext DEFAULT NULL,

  `limit_warning_daily_en` longtext DEFAULT NULL,

  `limit_warning_daily_fr` longtext DEFAULT NULL,

  `limit_warning_daily_pl` longtext DEFAULT NULL,

  `limit_warning_daily_ru` longtext DEFAULT NULL,

  `limit_warning_total_de` longtext DEFAULT NULL,

  `limit_warning_total_en` longtext DEFAULT NULL,

  `limit_warning_total_fr` longtext DEFAULT NULL,

  `limit_warning_total_pl` longtext DEFAULT NULL,

  `limit_warning_total_ru` longtext DEFAULT NULL,

  `packed_coins_amount` int(10) unsigned NOT NULL,

  `date_start` datetime(6) DEFAULT NULL,

  `for_axcfgrtys` tinyint(1),

  `axcfgrty_form_label` varchar(256) DEFAULT NULL,

  `service_transfer_enabled` tinyint(1) NOT NULL,

  `for_direct_link_only` tinyint(1) NOT NULL,

  `multi_axcfgrty_form` longtext DEFAULT NULL,

  `multi_axcfgrty_form_de` longtext DEFAULT NULL,

  `multi_axcfgrty_form_en` longtext DEFAULT NULL,

  `multi_axcfgrty_form_fr` longtext DEFAULT NULL,

  `multi_axcfgrty_form_pl` longtext DEFAULT NULL,

  `multi_axcfgrty_form_ru` longtext DEFAULT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `lorzutcs_lorzutc_fork_id_3d78875a493a690e_uniq` (`fork_id`,`ext_id`),

  KEY `lorzutcs_lorzutc_7ffe293f` (`call_drop_lorzutc_id`),

  KEY `lorzutcs_lorzutc_6ae2cc48` (`morning_type_id`),

  KEY `lorzutcs_lorzutc_fork_id_kind_idx` (`fork_id`,`kind`),

  CONSTRAINT `D677e29f346e2cb9534923ae7a1cef3c` FOREIGN KEY (`morning_type_id`) REFERENCES `lorzutcs_lorzutcstacktype` (`id`),

  CONSTRAINT `pr_call_drop_lorzutc_id_4585ada564c7ff7b_fk_lorzutcs_lorzutc_id` FOREIGN KEY (`call_drop_lorzutc_id`) REFERENCES `lorzutcs_lorzutc` (`id`),

  CONSTRAINT `lorzutcs_lorzutc_fork_id_24d38688d2cddd78_fk_lorzutcs_fork_id` FOREIGN KEY (`fork_id`) REFERENCES `lorzutcs_fork` (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2008 DEFAULT CHARSET=utf8

SHOW CREATE TABLE  axcfgrtys_axcfgrtyprlorzutcasde\G

*************************** 1. row ***************************

       Table: axcfgrtys_axcfgrtyprlorzutcasde

Create Table: CREATE TABLE `axcfgrtys_axcfgrtyprlorzutcasde` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `date_start` datetime(6) NOT NULL,

  `date_last_activity` datetime(6) NOT NULL,

  `state` varchar(1) NOT NULL,

  `desc` longtext NOT NULL,

  `error` longtext NOT NULL,

  `tries_count` int(11) NOT NULL,

  `space_id` int(11) DEFAULT NULL,

  `space_status` int(11) DEFAULT NULL,

  `space_error` longtext DEFAULT NULL,

  `lorzutc_id` int(11) NOT NULL,

  PRIMARY KEY (`id`),

  KEY `axcfgrtys_axcfgrtypr_lorzutc_id_fk_lorzutcs_` (`lorzutc_id`),

  CONSTRAINT `axcfgrtys_axcfgrtypr_lorzutc_id_fk_lorzutcs_` FOREIGN KEY (`lorzutc_id`) REFERENCES `lorzutcs_lorzutc` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

Mikhail Zheltukhin added a comment - 2019-03-07 11:43 - edited Table: lorzutcs_lorzutc Create Table: CREATE TABLE `lorzutc` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kind` varchar(1) NOT NULL, `title` varchar(120) NOT NULL, `descr` longtext NOT NULL, `picture` varchar(100) NOT NULL, `price` int(10) unsigned DEFAULT NULL, `priority` int(10) unsigned NOT NULL, `date_added` datetime NOT NULL, `is_published` tinyint(1) NOT NULL, `reds_total` int(10) unsigned NOT NULL, `reds_reserved` int(10) unsigned NOT NULL, `fork_id` int(11) DEFAULT NULL, `reds_engaged` int(10) unsigned NOT NULL, `color` smallint(5) unsigned NOT NULL, `is_rare` tinyint(1) NOT NULL, `subtitle` varchar(120) NOT NULL, `drop` varchar(1) NOT NULL, `dust_ended` tinyint(1) NOT NULL, `ext_id` varchar(255) DEFAULT NULL, `platform_type` varchar(32) NOT NULL, `cnt_sold` int(10) unsigned NOT NULL, `cnt_to_sell` int(10) unsigned NOT NULL, `robot_needed` int(11) DEFAULT NULL, `share_picture` varchar(100) DEFAULT NULL, `robot_quest_id` int(11) DEFAULT NULL, `currency` varchar(1) NOT NULL, `call_drop_amount` int(10) unsigned DEFAULT NULL, `call_drop_lorzutc_id` int(11) DEFAULT NULL, `call_hint_text` longtext NOT NULL, `no_quantity_discount` tinyint(1) NOT NULL, `morning_amount` int(10) unsigned NOT NULL, `morning_type_id` int(11) DEFAULT NULL, `limit_daily` int(10) unsigned NOT NULL, `limit_error_daily` longtext NOT NULL, `limit_error_total` longtext NOT NULL, `limit_total` int(10) unsigned NOT NULL, `limit_warning_daily` longtext NOT NULL, `limit_warning_total` longtext NOT NULL, `date_finish` datetime DEFAULT NULL, `only_corp` tinyint(1) NOT NULL, `robot_coins_amount` int(10) unsigned NOT NULL, `first_tag` varchar(90) DEFAULT NULL, `second_tag` varchar(90) DEFAULT NULL, `is_free` tinyint(1) NOT NULL DEFAULT 0, `instruction_for_red_activation_url` varchar(200) DEFAULT NULL, `use_instruction_for_red_activation` tinyint(1) NOT NULL, `descr_de` longtext DEFAULT NULL, `descr_en` longtext DEFAULT NULL, `descr_fr` longtext DEFAULT NULL, `descr_pl` longtext DEFAULT NULL, `descr_ru` longtext DEFAULT NULL, `call_hint_text_de` longtext DEFAULT NULL, `call_hint_text_en` longtext DEFAULT NULL, `call_hint_text_fr` longtext DEFAULT NULL, `call_hint_text_pl` longtext DEFAULT NULL, `call_hint_text_ru` longtext DEFAULT NULL, `subtitle_de` varchar(120) DEFAULT NULL, `subtitle_en` varchar(120) DEFAULT NULL, `subtitle_fr` varchar(120) DEFAULT NULL, `subtitle_pl` varchar(120) DEFAULT NULL, `subtitle_ru` varchar(120) DEFAULT NULL, `title_de` varchar(120) DEFAULT NULL, `title_en` varchar(120) DEFAULT NULL, `title_fr` varchar(120) DEFAULT NULL, `title_pl` varchar(120) DEFAULT NULL, `title_ru` varchar(120) DEFAULT NULL, `limit_error_daily_de` longtext DEFAULT NULL, `limit_error_daily_en` longtext DEFAULT NULL, `limit_error_daily_fr` longtext DEFAULT NULL, `limit_error_daily_pl` longtext DEFAULT NULL, `limit_error_daily_ru` longtext DEFAULT NULL, `limit_error_total_de` longtext DEFAULT NULL, `limit_error_total_en` longtext DEFAULT NULL, `limit_error_total_fr` longtext DEFAULT NULL, `limit_error_total_pl` longtext DEFAULT NULL, `limit_error_total_ru` longtext DEFAULT NULL, `limit_warning_daily_de` longtext DEFAULT NULL, `limit_warning_daily_en` longtext DEFAULT NULL, `limit_warning_daily_fr` longtext DEFAULT NULL, `limit_warning_daily_pl` longtext DEFAULT NULL, `limit_warning_daily_ru` longtext DEFAULT NULL, `limit_warning_total_de` longtext DEFAULT NULL, `limit_warning_total_en` longtext DEFAULT NULL, `limit_warning_total_fr` longtext DEFAULT NULL, `limit_warning_total_pl` longtext DEFAULT NULL, `limit_warning_total_ru` longtext DEFAULT NULL, `packed_coins_amount` int(10) unsigned NOT NULL, `date_start` datetime(6) DEFAULT NULL, `for_axcfgrtys` tinyint(1), `axcfgrty_form_label` varchar(256) DEFAULT NULL, `service_transfer_enabled` tinyint(1) NOT NULL, `for_direct_link_only` tinyint(1) NOT NULL, `multi_axcfgrty_form` longtext DEFAULT NULL, `multi_axcfgrty_form_de` longtext DEFAULT NULL, `multi_axcfgrty_form_en` longtext DEFAULT NULL, `multi_axcfgrty_form_fr` longtext DEFAULT NULL, `multi_axcfgrty_form_pl` longtext DEFAULT NULL, `multi_axcfgrty_form_ru` longtext DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `lorzutcs_lorzutc_fork_id_3d78875a493a690e_uniq` (`fork_id`,`ext_id`), KEY `lorzutcs_lorzutc_7ffe293f` (`call_drop_lorzutc_id`), KEY `lorzutcs_lorzutc_6ae2cc48` (`morning_type_id`), KEY `lorzutcs_lorzutc_fork_id_kind_idx` (`fork_id`,`kind`), CONSTRAINT `D677e29f346e2cb9534923ae7a1cef3c` FOREIGN KEY (`morning_type_id`) REFERENCES `lorzutcs_lorzutcstacktype` (`id`), CONSTRAINT `pr_call_drop_lorzutc_id_4585ada564c7ff7b_fk_lorzutcs_lorzutc_id` FOREIGN KEY (`call_drop_lorzutc_id`) REFERENCES `lorzutcs_lorzutc` (`id`), CONSTRAINT `lorzutcs_lorzutc_fork_id_24d38688d2cddd78_fk_lorzutcs_fork_id` FOREIGN KEY (`fork_id`) REFERENCES `lorzutcs_fork` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2008 DEFAULT CHARSET=utf8 SHOW CREATE TABLE axcfgrtys_axcfgrtyprlorzutcasde\G *************************** 1. row *************************** Table: axcfgrtys_axcfgrtyprlorzutcasde Create Table: CREATE TABLE `axcfgrtys_axcfgrtyprlorzutcasde` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date_start` datetime(6) NOT NULL, `date_last_activity` datetime(6) NOT NULL, `state` varchar(1) NOT NULL, `desc` longtext NOT NULL, `error` longtext NOT NULL, `tries_count` int(11) NOT NULL, `space_id` int(11) DEFAULT NULL, `space_status` int(11) DEFAULT NULL, `space_error` longtext DEFAULT NULL, `lorzutc_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `axcfgrtys_axcfgrtypr_lorzutc_id_fk_lorzutcs_` (`lorzutc_id`), CONSTRAINT `axcfgrtys_axcfgrtypr_lorzutc_id_fk_lorzutcs_` FOREIGN KEY (`lorzutc_id`) REFERENCES `lorzutcs_lorzutc` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8

Sergey Vojtovich added a comment - 2019-05-09 07:49

Should've been fixed by ~~MDEV-16060~~. Feel free to reopen if the problem persists.

Sergey Vojtovich added a comment - 2019-05-09 07:49 Should've been fixed by MDEV-16060 . Feel free to reopen if the problem persists.

People

Assignee:: Sergey Vojtovich

Reporter:: Mikhail Zheltukhin

Votes:: 0 Vote for this issue

Watchers:: 9 Start watching this issue

Dates

Created:: 2019-03-07 08:53

Updated:: 2019-05-09 07:49

Resolved:: 2019-05-09 07:49

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server