Has anyone ever had an issue like this?
Every once in awhile when I try to put my app into test mode I get an error like the following:
I end up having to basically delete the database and then it goes into test mode just fine.
The key part of the message really is the last sentence. It acts like it expects there not to be a database already there.
It will work for days without an issue and then randomly this error pops up again.
It only happens with my test database. The live database doesn't seem to have an issue when I publish a new version.
I have deleted the individual tables and then tried it again also and it will work. I have also created a whole new BSV with a different name and imported the app into it and it works for awhile and then it will randomly do this again.
Any ideas?
Jim
Issue putting BSV into test mode
-
- Posts: 2405
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Issue putting BSV into test mode
I had a similar problem Jim..
I am using MariaDB and this occurred when I changed my machine to Mac M1... Hence needed to migrate to Windows 11 ARM under parallels...
I researched and found the problem and resolved it by adding the following lines to the my.ini file.
innodb_buffer_pool_size=1021M
innodb_log_file_size = 1024M
innodb_log_buffer_size = 800M
innodb_strict_mode=OFF
The my.ini file now looks like this....
[mysqld]
datadir=C:/Program Files/MariaDB 10.6/data
innodb_buffer_pool_size=1021M
innodb_log_file_size = 1024M
innodb_log_buffer_size = 800M
innodb_strict_mode=OFF
collation-server = utf8mb4_general_ci
init-connect='SET NAMES utf8mb4'
character-set-server = utf8mb4
[client]
plugin-dir=C:/Program Files/MariaDB 10.6/lib/plugin
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
Hope it helps for you to.
I am using MariaDB and this occurred when I changed my machine to Mac M1... Hence needed to migrate to Windows 11 ARM under parallels...
I researched and found the problem and resolved it by adding the following lines to the my.ini file.
innodb_buffer_pool_size=1021M
innodb_log_file_size = 1024M
innodb_log_buffer_size = 800M
innodb_strict_mode=OFF
The my.ini file now looks like this....
[mysqld]
datadir=C:/Program Files/MariaDB 10.6/data
innodb_buffer_pool_size=1021M
innodb_log_file_size = 1024M
innodb_log_buffer_size = 800M
innodb_strict_mode=OFF
collation-server = utf8mb4_general_ci
init-connect='SET NAMES utf8mb4'
character-set-server = utf8mb4
[client]
plugin-dir=C:/Program Files/MariaDB 10.6/lib/plugin
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
Hope it helps for you to.
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
-
- Posts: 297
- Joined: Wed Apr 22, 2015 11:44 pm
Re: Issue putting BSV into test mode
Thanks Mark, we will take a look at that.
I don't know if it makes any difference, but we are running MSSQL Server for this app.
Jim
I don't know if it makes any difference, but we are running MSSQL Server for this app.
Jim