--source include/have_partition.inc
|
CREATE TABLE t1 (v1 int);
|
|
ALTER TABLE t1 PARTITION BY system_time INTERVAL (SELECT 4 FROM dual) HOUR
|
(PARTITION ver_p1 HISTORY, PARTITION ver_pn CURRENT) ;
|
10.3 a4cd91c526933e87d78a
|
/10.3/sql/item_subselect.cc:1317: virtual longlong Item_singlerow_subselect::val_int(): Assertion `fixed == 1' failed.
|
190218 14:50:08 [ERROR] mysqld got signal 6 ;
|
stdlib/abort.c:91(__GI_abort)[0x7fe54786302a]
|
assert/assert.c:92(__assert_fail_base)[0x7fe547859bd7]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fe547859c82]
|
sql/item_subselect.cc:1318(Item_singlerow_subselect::val_int())[0x562b506728ba]
|
sql/item_timefunc.cc:1338(get_interval_value(Item*, interval_type, INTERVAL*))[0x562b506e1369]
|
sql/partition_info.h:404(partition_info::vers_set_interval(Item*, interval_type, long))[0x562b50332c62]
|
sql/sql_yacc.yy:6066(MYSQLparse(THD*))[0x562b502c74b6]
|
sql/sql_parse.cc:10106(parse_sql(THD*, Parser_state*, Object_creation_ctx*, bool))[0x562b4fdd1bb2]
|
sql/sql_parse.cc:8048(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x562b4fdc571b]
|
sql/sql_parse.cc:1856(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x562b4fda064a]
|
sql/sql_parse.cc:1396(do_command(THD*))[0x562b4fd9d76c]
|
sql/sql_connect.cc:1403(do_handle_one_connection(CONNECT*))[0x562b500f0fe8]
|
sql/sql_connect.cc:1310(handle_one_connection)[0x562b500f09c5]
|
perfschema/pfs.cc:1864(pfs_spawn_thread)[0x562b5141b0b1]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fe54849e6ba]
|
x86_64/clone.S:111(clone)[0x7fe54793341d]
|
signal 11 on non-debug build:
190218 15:02:52 [ERROR] mysqld got signal 11 ;
|
Server version: 10.3.12-MariaDB
|
|
sql/item_cmpfunc.h:3264(THD::is_error() const)[0x561ddee2d621]
|
sql/item_subselect.cc:1320(Item_singlerow_subselect::val_int())[0x561ddee2dafe]
|
sql/item_timefunc.cc:1339(get_interval_value(Item*, interval_type, INTERVAL*))[0x561ddee4af5f]
|
sql/partition_info.h:407(partition_info::vers_set_interval(Item*, interval_type, long))[0x561dded50ba5]
|
sql/sql_yacc.yy:6066(MYSQLparse(THD*))[0x561dded2d775]
|
sql/sql_parse.cc:10103(parse_sql(THD*, Parser_state*, Object_creation_ctx*, bool))[0x561ddebe6205]
|
sql/sql_parse.cc:8047(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x561ddebe64a6]
|
sql/sql_parse.cc:1851(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x561ddebe86f5]
|
sql/sql_parse.cc:1398(do_command(THD*))[0x561ddebe8e9e]
|
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x561ddecb081f]
|
sql/sql_connect.cc:1310(handle_one_connection)[0x561ddecb0944]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fdaac1bd6ba]
|
x86_64/clone.S:111(clone)[0x7fdaab02241d]
|
|
Query (0x7fda440115c0): ALTER TABLE t1 PARTITION BY system_time INTERVAL (SELECT 4 FROM dual) HOUR (PARTITION ver_p1 HISTORY, PARTITION ver_pn CURRENT)
|
- duplicates
-
MDEV-18136
Server crashes in Item_func_dyncol_create::prepare_arguments
-
-
Closed
{"report":{"fcp":957,"ttfb":156.20000004768372,"pageVisibility":"visible","entityId":72672,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"ff22180b-5054-45a8-900e-206d59727090","navigationType":0,"readyForUser":1028.2999999523163,"redirectCount":0,"resourceLoadedEnd":986.1000001430511,"resourceLoadedStart":161.79999995231628,"resourceTiming":[{"duration":312.40000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":161.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":161.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":474.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":312.2999999523163,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":162.20000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":162.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":474.5,"responseStart":0,"secureConnectionStart":0},{"duration":321.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":162.20000004768372,"connectEnd":162.20000004768372,"connectStart":162.20000004768372,"domainLookupEnd":162.20000004768372,"domainLookupStart":162.20000004768372,"fetchStart":162.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":162.20000004768372,"responseEnd":484,"responseStart":484,"secureConnectionStart":162.20000004768372},{"duration":398.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":162.29999995231628,"connectEnd":162.29999995231628,"connectStart":162.29999995231628,"domainLookupEnd":162.29999995231628,"domainLookupStart":162.29999995231628,"fetchStart":162.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":162.29999995231628,"responseEnd":561.1000001430511,"responseStart":561.1000001430511,"secureConnectionStart":162.29999995231628},{"duration":402.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":162.40000009536743,"connectEnd":162.40000009536743,"connectStart":162.40000009536743,"domainLookupEnd":162.40000009536743,"domainLookupStart":162.40000009536743,"fetchStart":162.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":162.40000009536743,"responseEnd":565.1000001430511,"responseStart":565.1000001430511,"secureConnectionStart":162.40000009536743},{"duration":403.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":162.5,"connectEnd":162.5,"connectStart":162.5,"domainLookupEnd":162.5,"domainLookupStart":162.5,"fetchStart":162.5,"redirectEnd":0,"redirectStart":0,"requestStart":162.5,"responseEnd":565.9000000953674,"responseStart":565.9000000953674,"secureConnectionStart":162.5},{"duration":403.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":162.60000014305115,"connectEnd":162.60000014305115,"connectStart":162.60000014305115,"domainLookupEnd":162.60000014305115,"domainLookupStart":162.60000014305115,"fetchStart":162.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":162.60000014305115,"responseEnd":566.4000000953674,"responseStart":566.4000000953674,"secureConnectionStart":162.60000014305115},{"duration":404.2000000476837,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":162.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":162.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":567,"responseStart":0,"secureConnectionStart":0},{"duration":404.59999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":162.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":162.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":567.5,"responseStart":0,"secureConnectionStart":0},{"duration":404.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":162.90000009536743,"connectEnd":162.90000009536743,"connectStart":162.90000009536743,"domainLookupEnd":162.90000009536743,"domainLookupStart":162.90000009536743,"fetchStart":162.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":162.90000009536743,"responseEnd":567,"responseStart":567,"secureConnectionStart":162.90000009536743},{"duration":404.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":163.10000014305115,"connectEnd":163.10000014305115,"connectStart":163.10000014305115,"domainLookupEnd":163.10000014305115,"domainLookupStart":163.10000014305115,"fetchStart":163.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":163.10000014305115,"responseEnd":567.7000000476837,"responseStart":567.7000000476837,"secureConnectionStart":163.10000014305115},{"duration":580.9000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":163.70000004768372,"connectEnd":163.70000004768372,"connectStart":163.70000004768372,"domainLookupEnd":163.70000004768372,"domainLookupStart":163.70000004768372,"fetchStart":163.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":163.70000004768372,"responseEnd":744.6000001430511,"responseStart":744.6000001430511,"secureConnectionStart":163.70000004768372},{"duration":822.3000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":163.79999995231628,"connectEnd":163.79999995231628,"connectStart":163.79999995231628,"domainLookupEnd":163.79999995231628,"domainLookupStart":163.79999995231628,"fetchStart":163.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":163.79999995231628,"responseEnd":986.1000001430511,"responseStart":986.1000001430511,"secureConnectionStart":163.79999995231628},{"duration":182.69999980926514,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":701.6000001430511,"connectEnd":701.6000001430511,"connectStart":701.6000001430511,"domainLookupEnd":701.6000001430511,"domainLookupStart":701.6000001430511,"fetchStart":701.6000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":701.6000001430511,"responseEnd":884.2999999523163,"responseStart":884.2999999523163,"secureConnectionStart":701.6000001430511}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":36,"responseStart":156,"responseEnd":159,"domLoading":159,"domInteractive":1093,"domContentLoadedEventStart":1093,"domContentLoadedEventEnd":1138,"domComplete":2012,"loadEventStart":2012,"loadEventEnd":2014,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1070.4000000953674},{"name":"bigPipe.sidebar-id.end","time":1071.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":1071.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1075.2000000476837},{"name":"activityTabFullyLoaded","time":1150}],"measures":[],"correlationId":"b4ec6a2dd8a2fa","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":66,"dbReadsTimeInMs":9,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}