[MDEV-7171] funcs_1.is_tables_is and main.information_schema-big fail in buildbot - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.1(EOL)
Fix Version/s: 10.1.2
Component/s: Tests
Labels:
- buildbot
- tests

Description

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-debian6-x86/builds/3349/steps/test_4/logs/stdio
(and many more)

funcs_1.is_tables_is                     w4 [ fail ]

        Test ended at 2014-11-23 00:28:56

CURRENT_TEST: funcs_1.is_tables_is

--- /usr/share/mysql/mysql-test/suite/funcs_1/r/is_tables_is.result	2014-11-22 22:33:32.000000000 +0100

+++ /dev/shm/var/4/log/is_tables_is.reject	2014-11-23 00:28:55.932248607 +0100

@@ -290,6 +290,29 @@

 Separator	-----------------------------------------------------

 TABLE_CATALOG	def

 TABLE_SCHEMA	information_schema

+TABLE_NAME	GEOMETRY_COLUMNS

+TABLE_TYPE	SYSTEM VIEW

+ENGINE	MEMORY

+VERSION	10

+ROW_FORMAT	Fixed

+TABLE_ROWS	#TBLR#

+AVG_ROW_LENGTH	#ARL#

+DATA_LENGTH	#DL#

+MAX_DATA_LENGTH	#MDL#

+INDEX_LENGTH	#IL#

+DATA_FREE	#DF#

+AUTO_INCREMENT	NULL

+CREATE_TIME	#CRT#

+UPDATE_TIME	#UT#

+CHECK_TIME	#CT#

+TABLE_COLLATION	utf8_general_ci

+CHECKSUM	NULL

+CREATE_OPTIONS	#CO#

+TABLE_COMMENT	#TC#

+user_comment

+Separator	-----------------------------------------------------

+TABLE_CATALOG	def

+TABLE_SCHEMA	information_schema

 TABLE_NAME	GLOBAL_STATUS

 TABLE_TYPE	SYSTEM VIEW

 ENGINE	MEMORY

@@ -635,6 +658,29 @@

 Separator	-----------------------------------------------------

 TABLE_CATALOG	def

 TABLE_SCHEMA	information_schema

+TABLE_NAME	SPATIAL_REF_SYS

+TABLE_TYPE	SYSTEM VIEW

+ENGINE	MEMORY

+VERSION	10

+ROW_FORMAT	Fixed

+TABLE_ROWS	#TBLR#

+AVG_ROW_LENGTH	#ARL#

+DATA_LENGTH	#DL#

+MAX_DATA_LENGTH	#MDL#

+INDEX_LENGTH	#IL#

+DATA_FREE	#DF#

+AUTO_INCREMENT	NULL

+CREATE_TIME	#CRT#

+UPDATE_TIME	#UT#

+CHECK_TIME	#CT#

+TABLE_COLLATION	utf8_general_ci

+CHECKSUM	NULL

+CREATE_OPTIONS	#CO#

+TABLE_COMMENT	#TC#

+user_comment

+Separator	-----------------------------------------------------

+TABLE_CATALOG	def

+TABLE_SCHEMA	information_schema

 TABLE_NAME	STATISTICS

 TABLE_TYPE	SYSTEM VIEW

 ENGINE	MEMORY

@@ -1180,6 +1226,29 @@

 Separator	-----------------------------------------------------

 TABLE_CATALOG	def

 TABLE_SCHEMA	information_schema

+TABLE_NAME	GEOMETRY_COLUMNS

+TABLE_TYPE	SYSTEM VIEW

+ENGINE	MEMORY

+VERSION	10

+ROW_FORMAT	Fixed

+TABLE_ROWS	#TBLR#

+AVG_ROW_LENGTH	#ARL#

+DATA_LENGTH	#DL#

+MAX_DATA_LENGTH	#MDL#

+INDEX_LENGTH	#IL#

+DATA_FREE	#DF#

+AUTO_INCREMENT	NULL

+CREATE_TIME	#CRT#

+UPDATE_TIME	#UT#

+CHECK_TIME	#CT#

+TABLE_COLLATION	utf8_general_ci

+CHECKSUM	NULL

+CREATE_OPTIONS	#CO#

+TABLE_COMMENT	#TC#

+user_comment

+Separator	-----------------------------------------------------

+TABLE_CATALOG	def

+TABLE_SCHEMA	information_schema

 TABLE_NAME	GLOBAL_STATUS

 TABLE_TYPE	SYSTEM VIEW

 ENGINE	MEMORY

@@ -1506,6 +1575,29 @@

 TABLE_TYPE	SYSTEM VIEW

 ENGINE	MEMORY

 VERSION	10

+ROW_FORMAT	Fixed

+TABLE_ROWS	#TBLR#

+AVG_ROW_LENGTH	#ARL#

+DATA_LENGTH	#DL#

+MAX_DATA_LENGTH	#MDL#

+INDEX_LENGTH	#IL#

+DATA_FREE	#DF#

+AUTO_INCREMENT	NULL

+CREATE_TIME	#CRT#

+UPDATE_TIME	#UT#

+CHECK_TIME	#CT#

+TABLE_COLLATION	utf8_general_ci

+CHECKSUM	NULL

+CREATE_OPTIONS	#CO#

+TABLE_COMMENT	#TC#

+user_comment

+Separator	-----------------------------------------------------

+TABLE_CATALOG	def

+TABLE_SCHEMA	information_schema

+TABLE_NAME	SPATIAL_REF_SYS

+TABLE_TYPE	SYSTEM VIEW

+ENGINE	MEMORY

+VERSION	10

 ROW_FORMAT	Fixed

 TABLE_ROWS	#TBLR#

 AVG_ROW_LENGTH	#ARL#

mysqltest: Result length mismatch

Apparently it was introduced by this revision:

Changed by	Alexey Botchkov <holyfoot@montyprogram.com>

Changed at	Tue 21 Oct 2014 10:25:47

Repository	https://github.com/MariaDB/server

Branch	10.1

Revision	c3db4459561bc491582bef6bea7b83e9fe464a10

Comments

MDEV-12 OpenGIS: create required tables: GeometryColumns, related views.

GEOMETRY_COLUMNS and SPATIAL_REF_SYS tables added to the INFORMATION_SCHEMA.

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/3453/steps/test_2/logs/stdio

CURRENT_TEST: main.information_schema-big

--- /mnt/buildbot/build/mariadb-10.1.2/mysql-test/r/information_schema-big.result	2014-11-23 16:58:52.000000000 +0200

+++ /mnt/buildbot/build/mariadb-10.1.2/mysql-test/r/information_schema-big.reject	2014-11-23 19:36:59.000000000 +0200

@@ -31,6 +31,7 @@

 ENGINES	ENGINE

 EVENTS	EVENT_SCHEMA

 FILES	TABLE_SCHEMA

+GEOMETRY_COLUMNS	F_TABLE_SCHEMA

 GLOBAL_STATUS	VARIABLE_NAME

 GLOBAL_VARIABLES	VARIABLE_NAME

 INDEX_STATISTICS	TABLE_SCHEMA

@@ -47,6 +48,7 @@

 SCHEMA_PRIVILEGES	TABLE_SCHEMA

 SESSION_STATUS	VARIABLE_NAME

 SESSION_VARIABLES	VARIABLE_NAME

+SPATIAL_REF_SYS	SRID

 STATISTICS	TABLE_SCHEMA

 SYSTEM_VARIABLES	VARIABLE_NAME

 TABLES	TABLE_SCHEMA

@@ -86,6 +88,7 @@

 ENGINES	ENGINE

 EVENTS	EVENT_SCHEMA

 FILES	TABLE_SCHEMA

+GEOMETRY_COLUMNS	F_TABLE_SCHEMA

 GLOBAL_STATUS	VARIABLE_NAME

 GLOBAL_VARIABLES	VARIABLE_NAME

 INDEX_STATISTICS	TABLE_SCHEMA

@@ -102,6 +105,7 @@

 SCHEMA_PRIVILEGES	TABLE_SCHEMA

 SESSION_STATUS	VARIABLE_NAME

 SESSION_VARIABLES	VARIABLE_NAME

+SPATIAL_REF_SYS	SRID

 STATISTICS	TABLE_SCHEMA

 SYSTEM_VARIABLES	VARIABLE_NAME

 TABLES	TABLE_SCHEMA

mysqltest: Result length mismatch

Attachments

Issue Links

blocks

MDEV-7172 Fix buildbot failures in 10.1 tree

Closed

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2014-11-23 02:03

Elena Stepanova made changes - 2014-11-23 13:24

Field	Original Value	New Value
Link		This issue blocks ~~MDEV-7172~~ [ ~~MDEV-7172~~ ]

Elena Stepanova made changes - 2014-11-23 23:13

Summary

funcs_1.is_tables_is fails in buildbot

funcs_1.is_tables_is and main.information_schema-big fail in buildbot

Elena Stepanova made changes - 2014-11-23 23:14

Description

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-debian6-x86/builds/3349/steps/test_4/logs/stdio
(and many more)

{noformat}
funcs_1.is_tables_is w4 [ fail ]
Test ended at 2014-11-23 00:28:56

CURRENT_TEST: funcs_1.is_tables_is
--- /usr/share/mysql/mysql-test/suite/funcs_1/r/is_tables_is.result 2014-11-22 22:33:32.000000000 +0100
+++ /dev/shm/var/4/log/is_tables_is.reject 2014-11-23 00:28:55.932248607 +0100
@@ -290,6 +290,29 @@
Separator -----------------------------------------------------
TABLE_CATALOG def
TABLE_SCHEMA information_schema
+TABLE_NAME GEOMETRY_COLUMNS
+TABLE_TYPE SYSTEM VIEW
+ENGINE MEMORY
+VERSION 10
+ROW_FORMAT Fixed
+TABLE_ROWS #TBLR#
+AVG_ROW_LENGTH #ARL#
+DATA_LENGTH #DL#
+MAX_DATA_LENGTH #MDL#
+INDEX_LENGTH #IL#
+DATA_FREE #DF#
+AUTO_INCREMENT NULL
+CREATE_TIME #CRT#
+UPDATE_TIME #UT#
+CHECK_TIME #CT#
+TABLE_COLLATION utf8_general_ci
+CHECKSUM NULL
+CREATE_OPTIONS #CO#
+TABLE_COMMENT #TC#
+user_comment
+Separator -----------------------------------------------------
+TABLE_CATALOG def
+TABLE_SCHEMA information_schema
TABLE_NAME GLOBAL_STATUS
TABLE_TYPE SYSTEM VIEW
ENGINE MEMORY
@@ -635,6 +658,29 @@
Separator -----------------------------------------------------
TABLE_CATALOG def
TABLE_SCHEMA information_schema
+TABLE_NAME SPATIAL_REF_SYS
+TABLE_TYPE SYSTEM VIEW
+ENGINE MEMORY
+VERSION 10
+ROW_FORMAT Fixed
+TABLE_ROWS #TBLR#
+AVG_ROW_LENGTH #ARL#
+DATA_LENGTH #DL#
+MAX_DATA_LENGTH #MDL#
+INDEX_LENGTH #IL#
+DATA_FREE #DF#
+AUTO_INCREMENT NULL
+CREATE_TIME #CRT#
+UPDATE_TIME #UT#
+CHECK_TIME #CT#
+TABLE_COLLATION utf8_general_ci
+CHECKSUM NULL
+CREATE_OPTIONS #CO#
+TABLE_COMMENT #TC#
+user_comment
+Separator -----------------------------------------------------
+TABLE_CATALOG def
+TABLE_SCHEMA information_schema
TABLE_NAME STATISTICS
TABLE_TYPE SYSTEM VIEW
ENGINE MEMORY
@@ -1180,6 +1226,29 @@
Separator -----------------------------------------------------
TABLE_CATALOG def
TABLE_SCHEMA information_schema
+TABLE_NAME GEOMETRY_COLUMNS
+TABLE_TYPE SYSTEM VIEW
+ENGINE MEMORY
+VERSION 10
+ROW_FORMAT Fixed
+TABLE_ROWS #TBLR#
+AVG_ROW_LENGTH #ARL#
+DATA_LENGTH #DL#
+MAX_DATA_LENGTH #MDL#
+INDEX_LENGTH #IL#
+DATA_FREE #DF#
+AUTO_INCREMENT NULL
+CREATE_TIME #CRT#
+UPDATE_TIME #UT#
+CHECK_TIME #CT#
+TABLE_COLLATION utf8_general_ci
+CHECKSUM NULL
+CREATE_OPTIONS #CO#
+TABLE_COMMENT #TC#
+user_comment
+Separator -----------------------------------------------------
+TABLE_CATALOG def
+TABLE_SCHEMA information_schema
TABLE_NAME GLOBAL_STATUS
TABLE_TYPE SYSTEM VIEW
ENGINE MEMORY
@@ -1506,6 +1575,29 @@
TABLE_TYPE SYSTEM VIEW
ENGINE MEMORY
VERSION 10
+ROW_FORMAT Fixed
+TABLE_ROWS #TBLR#
+AVG_ROW_LENGTH #ARL#
+DATA_LENGTH #DL#
+MAX_DATA_LENGTH #MDL#
+INDEX_LENGTH #IL#
+DATA_FREE #DF#
+AUTO_INCREMENT NULL
+CREATE_TIME #CRT#
+UPDATE_TIME #UT#
+CHECK_TIME #CT#
+TABLE_COLLATION utf8_general_ci
+CHECKSUM NULL
+CREATE_OPTIONS #CO#
+TABLE_COMMENT #TC#
+user_comment
+Separator -----------------------------------------------------
+TABLE_CATALOG def
+TABLE_SCHEMA information_schema
+TABLE_NAME SPATIAL_REF_SYS
+TABLE_TYPE SYSTEM VIEW
+ENGINE MEMORY
+VERSION 10
ROW_FORMAT Fixed
TABLE_ROWS #TBLR#
AVG_ROW_LENGTH #ARL#

mysqltest: Result length mismatch
{noformat}

Apparently it was introduced by this revision:
{noformat}
Changed by Alexey Botchkov <holyfoot@montyprogram.com>
Changed at Tue 21 Oct 2014 10:25:47
Repository https://github.com/MariaDB/server
Branch 10.1
Revision c3db4459561bc491582bef6bea7b83e9fe464a10
Comments

~~MDEV-12~~ OpenGIS: create required tables: GeometryColumns, related views.
GEOMETRY_COLUMNS and SPATIAL_REF_SYS tables added to the INFORMATION_SCHEMA.
{noformat}

Alexey Botchkov made changes - 2014-11-24 11:13

Status

Open [ 1 ]

In Progress [ 3 ]

Alexey Botchkov added a comment - 2014-11-24 12:50

Fixing patch:
http://lists.askmonty.org/pipermail/commits/2014-November/007067.html

Alexey Botchkov added a comment - 2014-11-24 12:50 Fixing patch: http://lists.askmonty.org/pipermail/commits/2014-November/007067.html

Alexey Botchkov made changes - 2014-11-24 12:51

Fix Version/s		10.1.2 [ 15801 ]
Fix Version/s	10.1 [ 16100 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Rasmus Johansson (Inactive) made changes - 2015-05-18 17:51

Workflow

MariaDB v2 [ 58656 ]

MariaDB v3 [ 63672 ]

Sergei Golubchik made changes - 2021-12-06 21:40

Workflow

MariaDB v3 [ 63672 ]

MariaDB v4 [ 148519 ]

People

Assignee:: Alexey Botchkov

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2014-11-23 02:03

Updated:: 2014-11-24 12:51

Resolved:: 2014-11-24 12:51

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration