Re: [Maria-discuss] Maria-db refuses to start

2022-12-09 Thread Reindl Harald
Am 10.12.22 um 03:42 schrieb martin doc: "Some of us run MariaDB on file systems that do their own block checksumming, and thus run innodb_checksum_algorithm=none" unchallenged Your choice. Your risks wow it took long until you understood what i was talking about your offlist pissing co

Re: [Maria-discuss] Maria-db refuses to start

2022-12-09 Thread Reindl Harald
Am 09.12.22 um 09:00 schrieb Marko Mäkelä: Regarding the dbmail/#sql2-704-271.ibd in your other message, in MariaDB 10.5 or later you should be able to drop the table even if a .frm file does not exist, with DROP TABLE dbmail.`#mysql50##sql2-704-271`; currently on 10.3 because i don't agree

Re: [Maria-discuss] Maria-db refuses to start

2022-12-09 Thread Reindl Harald
Am 09.12.22 um 08:10 schrieb martin doc: If you want protection from your database files being corrupted then you need to implement it. tell me something new - but what has this to do woth the topic? If you do nothing then you'll have no protection. You did nothing and your data got corrupt

Re: [Maria-discuss] Maria-db refuses to start

2022-12-08 Thread Reindl Harald
Am 08.12.22 um 23:53 schrieb martin doc: If you're concerned about database corruption then you need to start off by having multiple copies of the data available in an online state if you want to recover from corrupt data without doing a backup. completly different topic This is what ZFS

Re: [Maria-discuss] Maria-db refuses to start

2022-12-08 Thread Reindl Harald
Am 08.12.22 um 23:55 schrieb Gordan Bobic: On Fri, Dec 9, 2022 at 12:31 AM Reindl Harald wrote: 2.2) Database doesn't crash because the damage merely corrupts a single value but the record structure remains sound. So it is that 2.2) point where the InnoDB checksum gives you any

Re: [Maria-discuss] Maria-db refuses to start

2022-12-08 Thread Reindl Harald
Am 08.12.22 um 22:32 schrieb Gordan Bobic: On Thu, Dec 8, 2022 at 10:59 PM Reindl Harald wrote: What is the net benefit of detecting said error? The way I see it, the options are: 1) MariaDB detects and error, crashes out 2) MariaDB doesn't detect an error, ingests garbage, crashe

Re: [Maria-discuss] Maria-db refuses to start

2022-12-08 Thread Reindl Harald
the next reply-all clown boy i am subsribed so you can just respond to the list Am 08.12.22 um 21:13 schrieb Gordan Bobic: On Thu, Dec 8, 2022 at 9:42 PM Reindl Harald wrote: Am 08.12.22 um 18:59 schrieb Gordan Bobic: On Thu, Dec 8, 2022 at 7:28 PM Reindl Harald wrote: MariaDB does

Re: [Maria-discuss] Maria-db refuses to start

2022-12-08 Thread Reindl Harald
Am 08.12.22 um 18:59 schrieb Gordan Bobic: On Thu, Dec 8, 2022 at 7:28 PM Reindl Harald wrote: MariaDB does the same as the filesystem InnoDB in fact is more ore less a FS on top of a FS So why do it at both levels? because the FS layer can't detect MariaDB errors? And what

Re: [Maria-discuss] Maria-db refuses to start

2022-12-08 Thread Reindl Harald
Am 08.12.22 um 18:08 schrieb Gordan Bobic: On Thu, Dec 8, 2022 at 7:02 PM Reindl Harald wrote: MariaDB Server 10.4 introduced a new file format innodb_checksum_algorithm=full_crc32, and MariaDB Server 10.5 made it the default. Any files that were created when that setting is active are

Re: [Maria-discuss] Maria-db refuses to start

2022-12-08 Thread Reindl Harald
Am 08.12.22 um 17:47 schrieb Gordan Bobic: On Thu, Dec 8, 2022 at 6:25 PM Marko Mäkelä wrote: MariaDB Server 10.4 introduced a new file format innodb_checksum_algorithm=full_crc32, and MariaDB Server 10.5 made it the default. Any files that were created when that setting is active are guaran

Re: [Maria-discuss] Maria-db refuses to start

2022-12-08 Thread Reindl Harald
Am 08.12.22 um 17:51 schrieb Gordan Bobic: On Thu, Dec 8, 2022 at 6:43 PM Reindl Harald wrote: and when you are at it get rid of "ib_logfile0" and "ib_logfile1" which hold data even in file-per-table mode you can't cleanup from crap caused by a crash 13 years ago

Re: [Maria-discuss] Maria-db refuses to start

2022-12-08 Thread Reindl Harald
Am 08.12.22 um 17:22 schrieb Marko Mäkelä: On Thu, Dec 8, 2022 at 5:41 PM Reindl Harald wrote: I think you mean mysql, not postgresql... no, i mean postgresql, that piece of crap breaking for years after dist-upgrades because you need to do dump+restore at every version change - real fun

Re: [Maria-discuss] Maria-db refuses to start

2022-12-08 Thread Reindl Harald
Am 08.12.22 um 16:29 schrieb Jogchum Reitsma: Hi Reindl, Op 08-12-2022 om 08:31 schreef Reindl Harald: FIRST: can you stop using "rewrite-all" on mailing-lists? when the useless offlist-copy is faster the dupes-filter on our server is supressing the list-copy and you break my

Re: [Maria-discuss] Maria-db refuses to start

2022-12-07 Thread Reindl Harald
FIRST: can you stop using "rewrite-all" on mailing-lists? when the useless offlist-copy is faster the dupes-filter on our server is supressing the list-copy and you break my reply-list button in thunderbird Am 08.12.22 um 08:13 schrieb Jogchum Reitsma: Op 07-12-2022 om 23:14 schr

Re: [Maria-discuss] Maria-db refuses to start

2022-12-07 Thread Reindl Harald
Am 07.12.22 um 16:53 schrieb Jogchum Reitsma: Op 07-12-2022 om 12:15 schreef Reindl Harald: Am 07.12.22 um 10:27 schrieb Jogchum Reitsma: Sorry, my bad: of course I should have started mysqld, not mysql. besides that you should notice when you try to start a non-existing service

Re: [Maria-discuss] Maria-db refuses to start

2022-12-07 Thread Reindl Harald
Am 07.12.22 um 10:27 schrieb Jogchum Reitsma: Sorry, my bad: of course I should have started mysqld, not mysql. besides that you should notice when you try to start a non-existing service what is really bad: you randomly mix "mysqld", "mysql" and "mariadb" as service name in your posts

Re: [Maria-discuss] Maria-db refuses to start

2022-11-10 Thread Reindl Harald
PLEASE don't use "reply-all" on mailing-lists, you break "reply-list" for capable users! Am 10.11.22 um 20:36 schrieb Jogchum Reitsma: Op 10-11-2022 om 13:39 schreef Reindl Harald: for the sake of god open "/usr/lib/systemd/system/mariadb.service" and remo

Re: [Maria-discuss] Maria-db refuses to start

2022-11-10 Thread Reindl Harald
Am 10.11.22 um 12:06 schrieb Jogchum Reitsma: Op 08-11-2022 om 22:54 schreef Daniel Black: On Wed, Nov 9, 2022 at 12:01 AM Jogchum Reitsma wrote: <...> The directory /var/run/mysql doesn't exist 2022-11-08 13:37:33 0 [ERROR] Do you already have another server running on socket: /var/run

[Maria-discuss] mariadb-10.3.37 strips "collate" from "show create table"

2022-11-09 Thread Reindl Harald
mariadb-10.3.36 versus mariadb-10.3.37 in the past every field contained "collate latin1_german1_ci" and after this point-update collation is only part of the output if it's different then the tables default collation surely, i can update everything to mariadb-10.3.37 and rewrite all this te

Re: [Maria-discuss] Maria-db refuses to start

2022-10-13 Thread Reindl Harald
Am 13.10.22 um 15:29 schrieb Jogchum Reitsma: Op 13-10-2022 om 15:10 schreef Reindl Harald: There I have plenty of room in a raid6 configuration, where the default location is much smaller, and populated by the infamous (well, with me at least) btrfs filesystem. you can put the data in

Re: [Maria-discuss] Maria-db refuses to start

2022-10-13 Thread Reindl Harald
Am 13.10.22 um 14:54 schrieb Jogchum Reitsma: frankly why don#t you move the datadir out of your suerhome and change the path to the datadir in the config? 25 years ago I decided that the data is only useful to me, so why place it anywhere else than in my home directory? After all, that's whe

Re: [Maria-discuss] Maria-db refuses to start

2022-10-13 Thread Reindl Harald
Am 13.10.22 um 14:16 schrieb Jogchum Reitsma: Op 13-10-2022 om 01:46 schreef Daniel Black: On Thu, Oct 13, 2022 at 12:27 AM Jogchum Reitsma wrote: Anyone an idea why /home/jogchum/mysql_recover/linux-mkay.lower-test can't be created and how to solve that? In systemd ProtectHome=read-only

Re: [Maria-discuss] Maria-db refuses to start

2022-10-13 Thread Reindl Harald
Am 13.10.22 um 13:55 schrieb Jogchum Reitsma: Op 13-10-2022 om 12:59 schreef Reindl Harald: All files and dir's under /home/jogchum/mysql_recover have mysql:mysql as owner:group and your userhome is 755 which is the default, when opensuse creates a new user. So, if I understan

Re: [Maria-discuss] Maria-db refuses to start

2022-10-13 Thread Reindl Harald
Am 13.10.22 um 12:14 schrieb Jogchum Reitsma: Op 12-10-2022 om 16:48 schreef Sergei Golubchik: Hi, Jogchum, Anyone an idea why /home/jogchum/mysql_recover/linux-mkay.lower-test can't be created and how to solve that? permission problem, perhaps? All files and dir's under /home/jogchum/mysql

Re: [Maria-discuss] mysql_upgrade fails

2022-07-21 Thread Reindl Harald
Am 21.07.22 um 13:01 schrieb Hartmut Holzgraefe: On 21.07.22 10:37, Reindl Harald wrote: 10.2.x to 10.2.y and mysql_upgrade crashing can you point me at a related bug report for that? i can't find it in the archives and it was one of my replies to a point update release anounc

Re: [Maria-discuss] mysql_upgrade fails

2022-07-21 Thread Reindl Harald
--- *From:* Maria-discuss on behalf of Reindl Harald *Sent:* Thursday, July 21, 2022 11:37 AM *To:* maria-discuss@lists.launchpad.net *Subject:* Re: [Maria-discuss] mysql_upgrade fails Am 21.07.22 um 07:48 schrieb Majed Zouhairy: i just upgraded zabbix and it doesn't suppor

Re: [Maria-discuss] mysql_upgrade fails

2022-07-21 Thread Reindl Harald
.2.y and mysql_upgrade crashing but now developers pretend they even *really test* jumps from 10.2 to 10.6 - are you guys kidding me? *From:* Maria-discuss on behalf of Reindl Harald *Sent:* Wednesday, July 20, 2022 1:39 PM *To:* maria-discuss@lists.launchpad.net *Subject:* Re: [Maria-d

Re: [Maria-discuss] mysql_upgrade fails

2022-07-20 Thread Reindl Harald
Am 20.07.22 um 09:34 schrieb Majed Zouhairy: on centos 8, upgrade form mraidb 10.3 to 10.6 fails it's not that smart to skip major versions why for the sake of god do you not upgrade 10.3 -> 10.4 -> 10.5 -> 10.6 like everybody else? ___ Mailing

[Maria-discuss] Fwd: [MariaDB Announce] MariaDB 10.8.1 RC and MariaDB 10.7.2, 10.6.6, 10.5.14, 10.4.23, 10.3.33 and 10.2.42 now available

2022-02-10 Thread Reindl Harald
https://downloads.mariadb.org/mariadb/10.3.33/ points to a form with 10.6 preselected because a redirect to https://mariadb.org/download/?t=mariadb&p=mariadb&r=10.6.5&os=Linux&cpu=x86_64&pkg=tar_gz&i=systemd&m=nextlayer and in that useless form 10.3.32 is the newest you can select when tryin

Re: [Maria-discuss] Issues with Upgrading from MariaDB 10.2.22 to 10.5.12

2021-08-25 Thread Reindl Harald
Am 25.08.21 um 16:53 schrieb Michael Caplan: Thanks Gordan, Maybe I'm misrepresenting / misunderstanding the info found here: https://mariadb.com/kb/en/upgrading-between-major-mariadb-versions/ But it seems a straight shot upgrade is a-okay but common sense should tell you it's a bad idea

Re: [Maria-discuss] MySQL crash after 'partial' version upgrade

2021-07-26 Thread Reindl Harald
Am 26.07.21 um 17:30 schrieb William Edwards: William Edwards schreef op 2021-07-23 19:16: Hello, The weather probably has an effect on me, because I'm not seeing the cause for the issue below right away. Hopefully someone can use the cluebat. Also, I apologize if we're not supposed to paste

Re: [Maria-discuss] dist-upgrade for minor version upgrade

2021-07-10 Thread Reindl Harald
Am 10.07.21 um 16:58 schrieb William Edwards: Hi, https://mariadb.com/kb/en/upgrading-from-mariadb-104-to-mariadb-105/ (and all other minor upgrade guides) contain these steps: 2. Stop MariaDB. 3. Uninstall the old version of MariaDB:    On Debian, Ubuntu, and other similar Linux distribut

Re: [Maria-discuss] How to Host Multiple Mail Domains (Email Hosting) in iRedMail Full Featured Linux Mail Server

2021-05-04 Thread Reindl Harald
may i ask you again THIS TIME IN PUBLIC to stop this idiotic mails to every single mailing list i am subscribed to? --- are you mentally ill or why do you send such dumb signatures all the time (others already asked to not do that on mailing lists at all) Mr. Turritopsis

Re: [Maria-discuss] Exceeding configured memory

2021-04-12 Thread Reindl Harald
Am 12.04.21 um 08:31 schrieb Sig Pam: Hi all! I run into problems with the memory configuration of MariaDB 10.3.27 on Debian 10. It looks as if it exceeds the configured memory. The server hat 4 GB of memory. It runs MariaDB and a Kopano (Mail/Collaboration) server. The configuration I be

Re: [Maria-discuss] MEMORY tables and binlog

2021-04-07 Thread Reindl Harald
Am 07.04.21 um 14:51 schrieb Antony Stone: On Wednesday 07 April 2021 at 14:48:55, Reindl Harald wrote: Am 07.04.21 um 14:46 schrieb Dajka Tamás: Hi All, I’m facing a weird error. We’re migrating our old 10.1 multi-master setup to a new 10.3 cluster (everything is running on Debian). New

Re: [Maria-discuss] MEMORY tables and binlog

2021-04-07 Thread Reindl Harald
Am 07.04.21 um 14:46 schrieb Dajka Tamás: Hi All, I’m facing a weird error. We’re migrating our old 10.1 multi-master setup to a new 10.3 cluster (everything is running on Debian). New-node01 is connected as a slave to the old cluster’s master. When I tried to set up the replication betwee

Re: [Maria-discuss] Is it possible to upgrade SHA-1 and MD5 algorithms in Mariadb-10.5?

2021-03-19 Thread Reindl Harald
Am 19.03.21 um 01:47 schrieb Daniel Black: md5: extra/mariabackup/xbcloud.cc - old bit, however for old reasons used md5 as a checksum on a storage format. I'm think can be removed before RHEL9 In SQL there is a MD5 function, we can't just replace that as it will break user applications.

Re: [Maria-discuss] Problem with InnoDB: Semaphore wait after upgrading to 10.3.27

2021-03-16 Thread Reindl Harald
time? [root@srv-rhsoft:~]$ rpm -q --changelog mariadb | head * Mo Feb 22 2021 Reindl Harald - update to 10.3.28 ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~

Re: [Maria-discuss] Maximum possible memory usage: 123.3G

2021-02-19 Thread Reindl Harald
is a downright dangerous tool that far too often gives cripplingly terrible advice. i don't follow it blindly besides not answering any of my questions you really could only reply to the list and so not break my reply-list-button with your faster off-list copy On Fri, 19 Feb 2021,

[Maria-discuss] Maximum possible memory usage: 123.3G

2021-02-19 Thread Reindl Harald
h - i thought i had the per-thread buffers down to a value which would be reasonable in case the max number of connections is reached i guess that two are guilty but with low "myisam_sort_buffer_size" optimize large tables fail from my expierience and a small "join_buffer_size" don't work

Re: [Maria-discuss] Set password for all users, regardless of host value

2020-09-05 Thread Reindl Harald
Am 05.09.20 um 12:32 schrieb Sergei Golubchik: >> i guess beause not everybody likes % when a user should only have >> access from 3 hosts - defense in depth > > Hmm, okay. I see. Unfortunately it means creating three distinct > accounts doing grants three times, etc. And they can get out of sy

Re: [Maria-discuss] Set password for all users, regardless of host value

2020-09-05 Thread Reindl Harald
Am 05.09.20 um 12:32 schrieb Sergei Golubchik: > On Sep 05, Reindl Harald wrote: >> well, why in the world was a clear structure replaced with some >> json-like crap? > > for a couple of reasons. > every new release was adding more columns to mysql.user, and > mys

Re: [Maria-discuss] Set password for all users, regardless of host value

2020-09-05 Thread Reindl Harald
Am 05.09.20 um 10:37 schrieb Sergei Golubchik: > Hi, Chris! > > On Sep 04, Chris Ross (cross2) wrote: >> Hello there. We have scripts to restore credentials to MySQL >> databases from external store. The mechanism that was in use, >> however, stores usernames and passwords, without considerati

Re: [Maria-discuss] Missing table rows when importing a MySQL 5.7.8 database into MariaDB 10.4.8 database

2020-08-26 Thread Reindl Harald
changelog/ https://mariadb.com/kb/en/mariadb-10414-changelog/ > On Aug 27, 2020 2:05 AM, Reindl Harald wrote: > > > > Am 27.08.20 um 03:30 schrieb Elliot Holden: > > Long story short, I updated MariaDB Server from 10.4.8 to 10.4.14 and > > problem solved. >

Re: [Maria-discuss] Missing table rows when importing a MySQL 5.7.8 database into MariaDB 10.4.8 database

2020-08-26 Thread Reindl Harald
Am 27.08.20 um 03:30 schrieb Elliot Holden: > Long story short, I updated MariaDB Server from 10.4.8 to 10.4.14 and > problem solved. what was the point using a nearly one year old version to begin with (sorry for not realize the outfated version in the subject after your first post) i won't e

Re: [Maria-discuss] MariaDB 10.4: subtle change of result ordering

2020-08-24 Thread Reindl Harald
years, the autotests which is part of a bug testsuite has the expected HTML output base64 decoded, fires a diff against the now created html-output and alerts if there is a byte changed > I tried your table structure and your test data on both 10.3 and 10.5 > and in both cases I've go

Re: [Maria-discuss] MariaDB 10.4: subtle change of result ordering

2020-08-24 Thread Reindl Harald
Am 24.08.20 um 12:23 schrieb Reindl Harald: > Am 24.08.20 um 09:46 schrieb Sergei Golubchik: >> Hi, Reindl! >> >> 1. Is it 10.3 to 10.4 difference? There were some optimizations that >> could have such an effect. >> https://mariadb.com/kb/en/changes-improvements

Re: [Maria-discuss] MariaDB 10.4: subtle change of result ordering

2020-08-24 Thread Reindl Harald
ways* empty at the begin of the autotest suite > On Aug 21, Reindl Harald wrote: >> MyISAM: >> >> in all previous versions this test was stable, so as the timestamps are >> identical and ordering is 'desc' the result was ordered by the creation >>

Re: [Maria-discuss] MariaDB 10.4: subtle change of result ordering

2020-08-21 Thread Reindl Harald
Am 21.08.20 um 17:44 schrieb Rodrigo Severo: > ‐‐‐ Original Message ‐‐‐ > On Friday, August 21, 2020 12:18 PM, Reindl Harald > wrote: > >> MyISAM: >> >> in all previous versions this test was stable, so as the timestamps are >> identical and order

[Maria-discuss] Mariadb 10.4: mysql_test broken - No option named 'plugin-dir' in group 'mysqld.1' at lib/My/ConfigFactory.pm line 349

2020-08-21 Thread Reindl Harald
one last thing before i restore the snapshot with the latest 10.3 build - /usr/bin/su -c 'cd /usr/share/mysql-test; ./mysql-test-run.pl --parallel=4 --max-test-fail=0 --mysqld=--binlog-format=row --force --suites="main-,binlog-,csv-,funcs_1-,funcs_2-,handle

[Maria-discuss] MariaDB 10.4: subtle change of result ordering

2020-08-21 Thread Reindl Harald
MyISAM: in all previous versions this test was stable, so as the timestamps are identical and ordering is 'desc' the result was ordered by the creation time of the the records now it's reverse which can break all sort of expectations in subtle ways while we could discuss what is the expected out

[Maria-discuss] logging options of mariadb are a joke

2020-08-16 Thread Reindl Harald
it's a shame that even MySQl 5.7 options are unknown in MariaDB 10.3 which was *long* after -- https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_log_syslog [ERROR] /usr/libexec/mysqld: unknown variable 'log-syslog=1' don't set "l

Re: [Maria-discuss] why stdout? -> [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096

2020-07-05 Thread Reindl Harald
Am 06.08.15 um 17:26 schrieb Reindl Harald: > Am 06.08.2015 um 17:23 schrieb Sergei Golubchik: >> Hi, Reindl! >> >> On Aug 06, Reindl Harald wrote: >>> Am 06.08.2015 um 14:25 schrieb Sergei Golubchik: >>>> On Aug 06, Reindl Harald wrote: >>>

Re: [Maria-discuss] Poor performance compared to MySQL

2020-06-02 Thread Reindl Harald
aring exactly that and *additionally* provides numbers with Aria BTW: that below looks like after shot in the head because of using HTML mails previosuly > Em ter., 2 de jun. de 2020 às 12:07, Reindl Harald > mailto:h.rei...@thelounge.net>> escreveu: > > > > Am 02.06.20 um 17:0

Re: [Maria-discuss] Poor performance compared to MySQL

2020-06-02 Thread Reindl Harald
Am 02.06.20 um 17:03 schrieb Roberto Spadim: > Try to avoid compare aria/myisam cause it have a journal how does that matter for selects and the point is "but MariaDB 10 MyISAM is still a long way behind 5.5" it's complety normal to also compare the same operations with different engines and th

Re: [Maria-discuss] Nosql language with plugins

2020-05-16 Thread Reindl Harald
riaDB CoC. > > Kind regards, > Erik > >> Den 14. maj 2020 kl. 19.49 skrev Reindl Harald : >> >> if you once again are responding to a private mail on a public list i will >> care of that you wish you woldn&#x

Re: [Maria-discuss] Nosql language with plugins

2020-05-14 Thread Reindl Harald
On Thu, May 14, 2020, 1:44 PM Reindl Harald <mailto:h.rei...@thelounge.net>> wrote: > > just a dumb fucker which don't realize that his idiot posts > talking to himslef are annoying and if he once again comes with > "You want a flame war? I was a Usenet admin.

Re: [Maria-discuss] Nosql language with plugins

2020-05-14 Thread Reindl Harald
dy cares about when someone is talking to himself for days > On Thu, May 14, 2020, 1:28 PM Reindl Harald <mailto:h.rei...@thelounge.net>> wrote: > > > I had to go on disability for mental health reasons > > didn't work well - shut the fuck up! > >

Re: [Maria-discuss] Nosql language with plugins

2020-05-14 Thread Reindl Harald
> I had to go on disability for mental health reasons didn't work well - shut the fuck up! Am 14.05.20 um 19:20 schrieb Justin Swanhart: > I propose we just let it go. > > I will never speak of MariaDB again and you stop fucking me over.  We > both win. > > Can we please just stop this stupid f

Re: [Maria-discuss] database corrupted when switching from MySQL to MariaDB on Ubuntu 19.04

2019-10-16 Thread Reindl Harald
10.0 -> 10.1 -> 10.2 -> 10.3 Mo Sep 02 2019: 10.2.26 -> 10.3.17 and frankly i expect whatever software to be able to read it's old data > On Wed, 16 Oct 2019, 10:51 Reindl Harald, <mailto:h.rei...@thelounge.net>> wrote: > > > Am 16.10.19 um 11:29 schr

Re: [Maria-discuss] database corrupted when switching from MySQL to MariaDB on Ubuntu 19.04

2019-10-16 Thread Reindl Harald
Am 16.10.19 um 11:29 schrieb Gordan Bobic: > On Wed, Oct 16, 2019 at 10:17 AM Reindl Harald <mailto:h.rei...@thelounge.net>> wrote: > > > Am 16.10.19 um 10:23 schrieb Gordan Bobic: > > I don't know if it is recoverable but it sounds like you missed

Re: [Maria-discuss] database corrupted when switching from MySQL to MariaDB on Ubuntu 19.04

2019-10-16 Thread Reindl Harald
Am 16.10.19 um 10:23 schrieb Gordan Bobic: > I don't know if it is recoverable but it sounds like you missed the step > of always needing a full, clean shutdown between upgrades with > innodb_fast_shutdown=0. Then you can delete ib_logfile*, and upgrade. always? how comes that i didn't need th

Re: [Maria-discuss] MariaDB 10.4.8 crash

2019-10-03 Thread Reindl Harald
Am 03.10.19 um 13:23 schrieb Thomas Plant: > Am 03.10.2019 um 11:53 schrieb Reindl Harald: >> "10.4.6 Stable 2019-06-18" > > Well, its marked 'stable' two releases ago, how long should one wait > until he uses it? If it crashes on a simple query it should

Re: [Maria-discuss] MariaDB 10.4.8 crash

2019-10-03 Thread Reindl Harald
Am 03.10.19 um 11:41 schrieb Thomas Plant: >> Client did some tests and he discovered that the following query will >> crash reliably: >> >> SELECT >> * >> FROM >> `users` >> WHERE >> ( `role` = 1 OR `role` = 10 ) >> AND EXISTS ( SELECT * FROM `email_templates` INNER JOIN `users_email` ON >> `em

Re: [Maria-discuss] Rocks, toku and some performance considerations.

2019-09-17 Thread Reindl Harald
Am 17.09.19 um 16:16 schrieb jocelyn fournier: >> Le 17 sept. 2019 à 16:07, pslawek83 a écrit : >> >> Hi Everyone, just some quick follow up on this topic about MyRocks i >> started. It seems that there are some issues with debian9 and cfq scheduler >> when using rocks. Tested this on VM, not

Re: [Maria-discuss] Cannot open datafile for read-only: './dbmail/#sql2-704-271.ibd' OS error: 71

2019-09-16 Thread Reindl Harald
Am 16.09.19 um 16:43 schrieb Marko Mäkelä: >> it's a shame that you simply can't get rid of garbage from the global >> tablespace > > Starting with MDEV-14585 InnoDB actually does drop #sql- tables during > startup. The #sql2 tables are intentionally preserved, because during > ALTER TABLE…ALGOR

Re: [Maria-discuss] Cannot open datafile for read-only: './dbmail/#sql2-704-271.ibd' OS error: 71

2019-09-16 Thread Reindl Harald
Am 16.09.19 um 15:58 schrieb Sergei Golubchik: > Hi, Reindl! > > On Sep 14, Reindl Harald wrote: >> Am 14.09.19 um 14:05 schrieb Sergei Golubchik: >>> Hi, Reindl! >>> >>> 1. Do you actually have /dbmail/*271* files ? >> >> no as you can

Re: [Maria-discuss] Cannot open datafile for read-only: './dbmail/#sql2-704-271.ibd' OS error: 71

2019-09-14 Thread Reindl Harald
Am 14.09.19 um 14:05 schrieb Sergei Golubchik: > Hi, Reindl! > > 1. Do you actually have /dbmail/*271* files ? no as you can see "Cannot open datafile for read-only: './dbmail/#sql2-704-271.ibd'", i deleted the temp files 10 years ago after one week of not used obviously from anything and didn

[Maria-discuss] Cannot open datafile for read-only: './dbmail/#sql2-704-271.ibd' OS error: 71

2019-09-11 Thread Reindl Harald
as far as i remember i was told 10.3 is able to fix that after a full dcade now but it don't 2019-09-11 18:18:12 0 [ERROR] InnoDB: Operating system error number 2 in a file operation. 2019-09-11 18:18:12 0 [ERROR] InnoDB: The error means the system cannot find the path specified. 2019-09-11 18:18:

Re: [Maria-discuss] fsync alternative

2019-09-07 Thread Reindl Harald
Am 07.09.19 um 21:38 schrieb Jure Sah: > On 7. 09. 19 21:03, Jan Steinman wrote: >> I’m using an inexpensive Mac Mini, maxed out with RAM, and a 2GB SSD, >> running NOTHING but MariaDB. I even run it headless, which means all >> the UI processes stay in sleep(3). When I was having web server >> p

Re: [Maria-discuss] 10.3.x: unknown variable 'innodb_support_xa=1'

2019-09-03 Thread Reindl Harald
Am 03.09.19 um 11:53 schrieb Benoit Plessis: >> [root@srv-rhsoft:~]$ apachectl -t >> AH00526: Syntax error on line 14 of /etc/httpd/conf/httpd-prefork.conf: >> Invalid command 'ddd=dfdfdf', perhaps misspelled or defined by a module >> not included in the server configuration >> >> where is somet

Re: [Maria-discuss] 10.3.x: unknown variable 'innodb_support_xa=1'

2019-09-03 Thread Reindl Harald
Am 03.09.19 um 11:38 schrieb Benoit Plessis: > On 03/09/2019 11:25, Reindl Harald wrote: >> when i *explicit disable* some bloatware crap it's missing exitence is >> not a hard error > Well, so you want to add some "bloat" to a software to handle deprecated

Re: [Maria-discuss] 10.3.x: unknown variable 'innodb_support_xa=1'

2019-09-03 Thread Reindl Harald
Am 03.09.19 um 09:50 schrieb Benoit Plessis: >> Am 02.09.19 um 19:38 schrieb Faustin Lammler: >>> I am truly sorry by the issue you are facing, but giving us *in >>> your first post* the version and the OS would have been more >>> productive IMHO >> >> don't get me wrong *but* i find it insulting

Re: [Maria-discuss] mariadb + FIPS

2019-09-02 Thread Reindl Harald
age from mariadb (linked with openssl) will fail. yeah, but not every usage of a hash function is related to openssl > On Thu, Aug 29, 2019 at 4:33 PM Reindl Harald <mailto:h.rei...@thelounge.net>> wrote: > > > > Am 30.08.19 um 00:10 schrieb Captain Wiggum: >

Re: [Maria-discuss] 10.3.x: unknown variable 'innodb_support_xa=1'

2019-09-02 Thread Reindl Harald
Am 02.09.19 um 20:20 schrieb Marko Mäkelä: > On Mon, Sep 2, 2019 at 8:48 PM Reindl Harald wrote: >> and yes, i assumed that a core developer other than you would look at >> that startup log, came to the conslusion "indeed, no warning there" >> and while read th

Re: [Maria-discuss] 10.3.x: unknown variable 'innodb_support_xa=1'

2019-09-02 Thread Reindl Harald
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Am 02.09.19 um 19:38 schrieb Faustin Lammler: > I am truly sorry by the issue you are facing, but giving us *in > your first post* the version and the OS would have been more > productive IMHO don't get me wrong *but* i find it insulting when some

Re: [Maria-discuss] 10.3.x: unknown variable 'innodb_support_xa=1'

2019-09-02 Thread Reindl Harald
Am 02.09.19 um 19:21 schrieb Sergei Golubchik: > On Sep 02, Reindl Harald wrote: >> Am 02.09.19 um 17:09 schrieb Marko Mäkelä: >>> On Mon, Sep 2, 2019 at 5:43 PM Reindl Harald wrote: >>>> unknown variable 'innodb_support_xa=1' >>>> >>

Re: [Maria-discuss] 10.3.x: unknown variable 'innodb_support_xa=1'

2019-09-02 Thread Reindl Harald
inted out often enough > This is clearly not a >> good start for a discussion > > https://lists.freedesktop.org/archives/systemd-devel/2019-August/043349.html > > Reindl Harald , 02/09/2019 – 17:20:36 > (+0200): > >> bullshit >> >> the part you skipped

Re: [Maria-discuss] 10.3.x: unknown variable 'innodb_support_xa=1'

2019-09-02 Thread Reindl Harald
Am 02.09.19 um 17:18 schrieb Benoit Plessis: > On 02/09/2019 17:13, Reindl Harald wrote: >>> A deprecation warning was added in the MariaDB Server 10.2.2, well >>> before it was Generally Available. >>> That said, maybe there is a nontrivial amount of users who sk

Re: [Maria-discuss] 10.3.x: unknown variable 'innodb_support_xa=1'

2019-09-02 Thread Reindl Harald
Am 02.09.19 um 17:09 schrieb Marko Mäkelä: > On Mon, Sep 2, 2019 at 5:43 PM Reindl Harald wrote: >> unknown variable 'innodb_support_xa=1' >> >> would you funny guys consider things like deperectaion warnings in >> previous releases > > A deprecat

[Maria-discuss] 10.3.x: unknown variable 'innodb_support_xa=1'

2019-09-02 Thread Reindl Harald
unknown variable 'innodb_support_xa=1' would you funny guys consider things like deperectaion warnings in previous releases or at least offer an option to change all these fucking "i don't know a option because it was removed or you did not compile something in and hence i refuse to start the serv

Re: [Maria-discuss] mariadb + FIPS

2019-08-29 Thread Reindl Harald
Am 30.08.19 um 00:10 schrieb Captain Wiggum: > I have searched the archives and forums and cannot find an answer to > this question. > Does mariadb support FIPS, and if so, how or where is a document about this. > I use mariadb 10.3.17 with OpenSSL 1.0.2 with FIPS enabled, all built > from sourc

Re: [Maria-discuss] Disk increase with MAD and MAI extension files in tmp dir

2019-08-07 Thread Reindl Harald
Am 07.08.19 um 10:30 schrieb Kevin DG: > MariaDB version -> 10.3.14 > > Recently, we had a new problem with our MariaDB instance. Indeed, > suddenly the size of the tmp directory has increased almost > instantaneously, to finish saturating the disk. > > We have encountered this problem twice an

Re: [Maria-discuss] ERROR 1071 with mysql_upgrade

2019-07-16 Thread Reindl Harald
Am 16.07.19 um 21:13 schrieb Sergei Golubchik: > you can run mysql_fix_privilege_tables.sql manually. Like with > mysql -uroot -p -vvv < mysql_fix_privilege_tables.sql how would that solve the issue of a obviously incompatible change in 10.4? > On Jul 16, Erik Cederstrand wrote: >> Hi, >> >> I

Re: [Maria-discuss] How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap?

2019-04-17 Thread Reindl Harald
Am 17.04.19 um 23:03 schrieb Jeff Dyke: > I've done this and i'm doing this, its not hard, everyone that needs db > access can read a readme and give me a public key in a matter of > seconds.  I'll take SSH over http-auth and a freaken app that can drop > tables/database via a SQL injection bug a

Re: [Maria-discuss] How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap?

2019-04-17 Thread Reindl Harald
Am 17.04.19 um 22:43 schrieb Reindl Harald: > > > Am 17.04.19 um 22:39 schrieb Jeff Dyke: >> How can you say it doesn't scale when you have now idea how i'm set up.  >> I had to add 5 users yesterday, took 5-10 (mostly talking to people) >> minutes.  Using

Re: [Maria-discuss] How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap?

2019-04-17 Thread Reindl Harald
Am 17.04.19 um 22:39 schrieb Jeff Dyke: > How can you say it doesn't scale when you have now idea how i'm set up.  > I had to add 5 users yesterday, took 5-10 (mostly talking to people) > minutes.  Using a config mgmt system i set up ssh and mysql in the same > single call to multiple database se

Re: [Maria-discuss] How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap?

2019-04-17 Thread Reindl Harald
ny > phpMyAdmin configuration. > > Again, i appreciate your point of view, but wanted to qualify some of my > answers. > > On Wed, Apr 17, 2019 at 1:18 PM Reindl Harald <mailto:h.rei...@thelounge.net>> wrote: > > > > Am 17.04.19 um 18:55 schrieb Jef

Re: [Maria-discuss] How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap?

2019-04-17 Thread Reindl Harald
ages for the target OS hire some one which is capable to do so or unpack that dmaned folder ph hand > On Wed, Apr 17, 2019 at 10:54 AM Reindl Harald <mailto:h.rei...@thelounge.net>> wrote: > > > > Am 17.04.19 um 16:50 schrieb Turritopsis Dohrnii Teo En Ming: >

Re: [Maria-discuss] How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap?

2019-04-17 Thread Reindl Harald
Am 17.04.19 um 16:50 schrieb Turritopsis Dohrnii Teo En Ming: > Subject/Topic: How do I determine if versions of phpMyAdmin before 4.8.5 is > SQL Injectable using sqlmap? frankly are you drunken? you posted this exactly same message to * phpmyadmin list TWICE * oracle mysql list * now mariad

Re: [Maria-discuss] required mysql_upgrade; MDEV-14637

2019-04-03 Thread Reindl Harald
Am 03.04.19 um 09:54 schrieb mj: > On 3/28/19 11:59 AM, Reindl Harald wrote: >> our production datadirs date back to 2002, originally on windows then >> moved to MacOS and in 2008 to Fedora and i did not dump/restore a single >> time in my whole life, this is not postgresq

Re: [Maria-discuss] required mysql_upgrade; MDEV-14637

2019-03-28 Thread Reindl Harald
Am 28.03.19 um 11:16 schrieb Michal Schorm: > Hello, > I have a questions regarding the warnings showing up at 10.2 and 10.3 > releases: > > When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, > running mysql_upgrade is required due to changes introduced in MDEV-14637.

Re: [Maria-discuss] MariaDB 10.2.23 and MariaDB Connector/J 2.4.1 now available

2019-03-25 Thread Reindl Harald
cause problems before. yeah, guess where, my config is not new :-) > Regards, > Sergei > Chief Architect MariaDB > and secur...@mariadb.org > > On Mar 25, Reindl Harald wrote: >> congratulations, again a point update which just don't compile >> >> frank

Re: [Maria-discuss] [MariaDB Announce] MariaDB 10.2.23 and MariaDB Connector/J 2.4.1 now available

2019-03-25 Thread Reindl Harald
congratulations, again a point update which just don't compile frankly what about RC announcements so that idiots like me building packages from source can point out such issues *before* official announcements? [ 92%] Building CXX object sql/CMakeFiles/sql.dir/sql_plugin.cc.o [ 92%] Building CXX

[Maria-discuss] Fwd: [MariaDB Announce] MariaDB 10.2.19 now available

2018-11-13 Thread Reindl Harald
hell, a new file again breaking rpm-build /usr/lib/pkgconfig/libmariadb.pc adjusted mariadb.spec error: File not found: /home/builduser/rpmbuild/BUILDROOT/mariadb-10.2.19-0.fc28.20181114.rh.sandybridge.x86_64/usr/lib64/pkgconfig/libmariadb.pc WTF - why is that crap on a x86_64 system in /usr/li

Re: [Maria-discuss] My Solution to MariaDB Database Server Crashed in Experimental Online Store

2018-10-22 Thread Reindl Harald
Am 22.10.18 um 23:12 schrieb Daniel Black: >> Giving my virtual server more than 1 GB of RAM will cost me more >> money. > > Sometimes you can't run a real service on less memory than your phone +1 with 1 GB you just survive basic operations and system-upgrades, below 768 MB you even don't su

Re: [Maria-discuss] My Solution to MariaDB Database Server Crashed in Experimental Online Store

2018-10-22 Thread Reindl Harald
Am 22.10.18 um 11:48 schrieb Turritopsis Dohrnii Teo En Ming: > My MariaDB SQL Database Server really crashed. I did not reboot my virtual > server at all. It has crashed twice already. in your first message you only mentioned systemctl start mariadb.service systemctl enable mariadb.service a

Re: [Maria-discuss] My Solution to MariaDB Database Server Crashed in Experimental Online Store

2018-10-19 Thread Reindl Harald
Am 19.10.18 um 13:17 schrieb Turritopsis Dohrnii Teo En Ming: > Good evening from Singapore, > > Here is my solution: > > # systemctl start mariadb.service > > # mysql > Welcome to the MariaDB monitor. Commands end with ; or \g. > Your MariaDB connection id is 2 > Server version: 5.5.60-Mari

Re: [Maria-discuss] [EXTERNAL] Re: Copying database files

2018-08-13 Thread Reindl Harald
Am 13.08.2018 um 14:33 schrieb Sergei Golubchik: > On Aug 13, Reindl Harald wrote: >> >> >> Am 13.08.2018 um 12:22 schrieb Ling, Andy: >>>> "The advantage of FLUSH TABLES table_name FOR EXPORT is that the table >>>> is read locked until UNLOCK T

Re: [Maria-discuss] [EXTERNAL] Re: Copying database files

2018-08-13 Thread Reindl Harald
Am 13.08.2018 um 12:27 schrieb Sergei Golubchik: > On Aug 13, Ling, Andy wrote: >> >> The code doing this stops everything talking to the database (Yes, I >> know there could be someone fiddling remotely in a shell, but this is >> very unlikely). Even tables which are never written to cause this

  1   2   3   4   5   6   >