Details
- 
    
Bug
 - 
    Status: Closed (View Workflow)
 - 
    
Major
 - 
    Resolution: Fixed
 - 
    10.2(EOL)
 - 
    None
 - 
    Linux, gcc
 
Description
					[server]
			 | 
		
					server-id = 1  | 
		
					log_bin                 = /tmp/mysql-bin.log
			 | 
		
Run like this:
mysql_install_db --basedir=/path2 --datadir=/path1 --defaults-file=./mysqld.cnf
					Installing MariaDB/MySQL system tables in './data' ...  | 
		
					2016-12-09 13:19:45 139923804589760 [Warning] InnoDB: New log files created, LSN=45892  | 
		
					2016-12-09 13:19:45 139923804589760 [Warning] InnoDB: Creating foreign key constraint system tables.  | 
		
					2016-12-09 13:19:46 139923028783872 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist  | 
		
					ERROR: 1105 Bootstrap file error, return code (0). Nearest query: 'CREATE DEFINER=`root`@`localhost` PROCEDURE AddGeometryColumn(catalog varchar(64), t_schema varchar(64),  | 
		
					t_name varchar(64), geometry_column varchar(64), t_srid int)  | 
		
					begin
			 | 
		
					set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' ADD ', geometry_column,' GEOMETRY REF_SYSTEM_ID=', t_srid); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end~~  | 
		
					CREATE DEFINER=`root`@`localhost` PROCEDURE DropGeometryColumn(catalog varchar(64), t_schema varch  | 
		
					mysqld: /home/kevg/work/mariadb_10.2/sql/sql_parse.cc:1098: void do_handle_bootstrap(THD *): Assertion `!opt_bootstrap || thread_count == 0' failed.  | 
		
					161209 13:19:49 [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.
			 | 
		
| 
					 | 
		
					To report this bug, see https://mariadb.com/kb/en/reporting-bugs  | 
		
| 
					 | 
		
					We will try our best to scrape up some info that will hopefully help  | 
		
					diagnose the problem, but since we have already crashed, 
			 | 
		
					something is definitely wrong and this may fail.  | 
		
| 
					 | 
		
					Server version: 10.2.2-MariaDB-debug-log  | 
		
					key_buffer_size=134217728  | 
		
					read_buffer_size=131072  | 
		
					max_used_connections=0  | 
		
					max_threads=153  | 
		
					thread_count=1  | 
		
					It is possible that mysqld could use up to 
			 | 
		
					key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467292 K bytes of memory  | 
		
					Hope that's ok; if not, decrease some variables in the equation.  | 
		
| 
					 | 
		
					Thread pointer: 0x0x0
			 | 
		
					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...
			 | 
		
					stack_bottom = 0x0 thread_stack 0x48c00  | 
		
					/home/kevg/work/debug/sql/mysqld(my_print_stacktrace+0x34)[0x129b534]  | 
		
					/home/kevg/work/debug/sql/mysqld(handle_fatal_signal+0x3cf)[0x9a5c8f]  | 
		
					/lib/x86_64-linux-gnu/libpthread.so.0(+0x11630)[0x7f428c6ab630]  | 
		
					/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x9f)[0x7f428b40a7ef]  | 
		
					/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f428b40c3ea]  | 
		
					/lib/x86_64-linux-gnu/libc.so.6(+0x2dbb7)[0x7f428b402bb7]  | 
		
					/lib/x86_64-linux-gnu/libc.so.6(+0x2dc62)[0x7f428b402c62]  | 
		
					/home/kevg/work/debug/sql/mysqld(_Z19do_handle_bootstrapP3THD+0x125)[0x6cc8c5]  | 
		
					/home/kevg/work/debug/sql/mysqld(handle_bootstrap+0x2d)[0x6cc73d]  | 
		
					/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ca)[0x7f428c6a16ca]  | 
		
					/lib/x86_64-linux-gnu/libc.so.6(clone+0x5f)[0x7f428b4dd0af]  | 
		
					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.
			 | 
		
| 
					 | 
		
					Installation of system tables failed!  Examine the logs in
			 | 
		
					./data for more information.  | 
		
| 
					 | 
		
					The problem could be conflicting information in an external
			 | 
		
					my.cnf files. You can ignore these by doing:
			 | 
		
| 
					 | 
		
					shell> /home/kevg/work/mariadb_10.2/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf  | 
		
| 
					 | 
		
					You can also try to start the mysqld daemon with:  | 
		
| 
					 | 
		
					    shell> /home/kevg/work/debug/sql/mysqld --skip-grant --general-log &
			 | 
		
| 
					 | 
		
					and use the command line tool /home/kevg/work/debug/client/mysql
			 | 
		
					to connect to the mysql database and look at the grant tables:
			 | 
		
| 
					 | 
		
					    shell> /home/kevg/work/debug/client/mysql -u root mysql
			 | 
		
					    mysql> show tables;
			 | 
		
| 
					 | 
		
					Try 'mysqld --help' if you have problems with paths. Using  | 
		
					--general-log gives you a log in ./data that may be helpful.
			 | 
		
| 
					 | 
		
					The latest information about mysql_install_db is available at
			 | 
		
					https://mariadb.com/kb/en/installing-system-tables-mysql_install_db  | 
		
					MariaDB is hosted on launchpad; You can find the latest source and
			 | 
		
					email lists at http://launchpad.net/maria  | 
		
| 
					 | 
		
					Please check all of the above before submitting a bug report
			 | 
		
					at http://mariadb.org/jira  | 
		
Attachments
Issue Links
- is duplicated by
 - 
                    
MDEV-10540 mysqld started by mysql_install_db will hang when having log-bin in config file
-         
 - Closed
 
 -