Issue putting BSV into test mode

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
Jhstephenson
Posts: 297
Joined: Wed Apr 22, 2015 11:44 pm

Issue putting BSV into test mode

Post by Jhstephenson »

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:
Screenshot2022-01-10_105048.png
Screenshot2022-01-10_105048.png (14.63 KiB) Viewed 1080 times
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
customaware
Posts: 2391
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Issue putting BSV into test mode

Post by customaware »

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.
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
Jhstephenson
Posts: 297
Joined: Wed Apr 22, 2015 11:44 pm

Re: Issue putting BSV into test mode

Post by Jhstephenson »

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
Post Reply