I have two suppliers where I am trying to filter the products to achieve the following: Select Products from Table1(supplier 1) that are not already present in Table3 and some further filtering on categories (Working) Select Products from Table2 (Supplier…
I couldn't help noticing that stored procedures are able to return values: create table foo(foo int); insert into foo values (42); create procedure get_foo() select * from foo; call get_foo(); +------+ | foo | +------+ | 42 | +------+ More…
I found a strange bug (I guess) in mariadb Suppose you have a table table1 with col1 and other table2 with col1 and you want to list all row in table1 whose col1 values exist in table2. We could code…
I have MariaDB on docker Trying to setup ssl I managed to completely break my user; I ended up with user duplicates and a new user called testssl I tried resetting everything by deleting my database; deleting the image but…
The MariaDB upgrade of MariaDB seem to follow the same behaviour pattern of removing the old version, keeping the data, then installing the new version, such as Upgrading from MariaDB 10.3 to MariaDB 10.4, and the other version to version…
We are experiencing issues with high load on our dotnet-core (3.1) application. Beyond a certain amount of connection (virtual users), we encouter a bottleneck, the server is starved and we get request timeout but the process doesn't crash (no kestrel…
I know that it appears that there has been an issue surrounding the MariaDB repo's as of recent times, which has been returning a 404 Not Found error during the upgrade stage of migrating from MySQL to MariaDB. I've been…
I'm trying to have multiple MariaDB Docker containers on my server. First is using 3307 -> 3306 port Secondary is using 3311 -> 3310 port But, for the second, docker still binding the 3306 port... Docker Compose : version: '3.7'…
I apologize in advance that I can't categorize this issue any better but the behavior is puzzling to such an extent that I have no clue where the issue might originate from. Together with another dev we tried to bugfix…
I'm currently having issues using mutillidae. When i go too http://localhost/mutillidae/set-up-database.php their is no screen available and everything is blank. I have attached the screen shot as well. This is the error that displays on the Mutillidae home screen Database…