Known issues - Revision history

Kpe: /* Import timeouts */

2025-01-07T11:31:29Z

Import timeouts

2025-01-07T11:30:12Z

Import timeouts

← Older revision		Revision as of 13:30, 7 January 2025
Line 105:		Line 105:
	innodb_log_file_size=500M		innodb_log_file_size=500M
	innodb_log_buffer_size=800M		innodb_log_buffer_size=800M
			bulk_insert_buffer_size=1024M

	* Then a parameter in the import --		* Then a parameter in the import --

2025-01-07T11:19:55Z

Import timeouts

2025-01-07T11:08:41Z

Import timeouts

← Older revision		Revision as of 13:08, 7 January 2025
Line 95:		Line 95:
	Sometimes large blobs will cause timeouts when running the mysql tool		Sometimes large blobs will cause timeouts when running the mysql tool

	* ~~First:~~ Create a config file with (example import.cnf)		* Create a config file with (example import.cnf)

	[mysqld]		[mysqld]
Line 106:		Line 106:
	innodb_log_buffer_size=800M		innodb_log_buffer_size=800M

	~~# Second: Add~~ a parameter in the import --		* Then a parameter in the import --

	mysql.exe --defaults-file=import.cnf ...		mysql.exe --defaults-file=import.cnf ...

2025-01-07T11:06:09Z

Import timeouts

← Older revision		Revision as of 13:06, 7 January 2025
Line 95:		Line 95:
	Sometimes large blobs will cause timeouts when running the mysql tool		Sometimes large blobs will cause timeouts when running the mysql tool

	# Create a config file with (example import.cnf)		* First: Create a config file with (example import.cnf)

	[mysqld]		[mysqld]
	max_allowed_packet=256M		max_allowed_packet=256M
Line 104:		Line 105:
	innodb_log_file_size=500M		innodb_log_file_size=500M
	innodb_log_buffer_size=800M		innodb_log_buffer_size=800M
	# Add a parameter in the import --
			# Second: Add a parameter in the import --

	mysql.exe --defaults-file=import.cnf ...		mysql.exe --defaults-file=import.cnf ...

2025-01-07T11:05:34Z

Import timeouts

← Older revision		Revision as of 13:05, 7 January 2025
Line 96:		Line 96:

	# Create a config file with (example import.cnf)		# Create a config file with (example import.cnf)

	[mysqld]		[mysqld]
	max_allowed_packet=256M		max_allowed_packet=256M
Line 105:		Line 104:
	innodb_log_file_size=500M		innodb_log_file_size=500M
	innodb_log_buffer_size=800M		innodb_log_buffer_size=800M

	# Add a parameter in the import --		# Add a parameter in the import --

	mysql.exe --defaults-file=import.cnf ...		mysql.exe --defaults-file=import.cnf ...

2025-01-07T11:04:47Z

Conatainer specific

← Older revision		Revision as of 13:04, 7 January 2025
Line 91:		Line 91:

	driverClassName=com.mysql.'''cj.'''jdbc.Driver		driverClassName=com.mysql.'''cj.'''jdbc.Driver

			==== Import timeouts ====
			Sometimes large blobs will cause timeouts when running the mysql tool

			# Create a config file with (example import.cnf)

			[mysqld]
			max_allowed_packet=256M
			innodb_lock_wait_timeout=3600
			net_read_timeout=3600
			net_write_timeout=3600
			wait_timeout=3600
			innodb_log_file_size=500M
			innodb_log_buffer_size=800M

			# Add a parameter in the import --

			mysql.exe --defaults-file=import.cnf ...

	===== Unable to restart services =====		===== Unable to restart services =====

2024-12-09T12:57:23Z

Error migrating from 5.x to 8.x

← Older revision		Revision as of 14:57, 9 December 2024
Line 75:		Line 75:
	Set it in the configuration file		Set it in the configuration file
	# Open my.ini		# Open my.ini
	# Replace sql_mode ~~deintion~~ with		# Replace sql_mode definition with

	sql_mode="NO_AUTO_VALUE_ON_ZERO"		sql_mode="NO_AUTO_VALUE_ON_ZERO"


	===== Driver for +8.4 not being used =====		===== Driver for +8.4 not being used =====

2024-12-04T12:11:37Z

Driver for +8.4 not being used

← Older revision		Revision as of 14:11, 4 December 2024
Line 85:		Line 85:
	* TOMCAT\webapps\XXX\WEB-INF\lib		* TOMCAT\webapps\XXX\WEB-INF\lib

	In the application context file (TOMCAT\conf\Catalina\localhost)		In the application context file: TOMCAT\conf\Catalina\localhost\XXX.xml

	driverClassName=com.mysql.jdbc.Driver		driverClassName=com.mysql.jdbc.Driver

2024-12-04T12:11:02Z

Error migrating from 5.x to 8.x

← Older revision		Revision as of 14:11, 4 December 2024
Line 78:		Line 78:

	sql_mode="NO_AUTO_VALUE_ON_ZERO"		sql_mode="NO_AUTO_VALUE_ON_ZERO"


			===== Driver for +8.4 not being used =====
			Make sure that the 8.4 driver is present in
			* TOMCAT\lib
			* TOMCAT\webapps\XXX\WEB-INF\lib

			In the application context file (TOMCAT\conf\Catalina\localhost)

			driverClassName=com.mysql.jdbc.Driver

			Should be changed to (simply add '.cj')

			driverClassName=com.mysql.'''cj.'''jdbc.Driver

	===== Unable to restart services =====		===== Unable to restart services =====