[Maria-discuss] how to file a problem / bug ?
Hello to everybody! I hope that this mailing list is the right place to ask this question... I have been using mysql, and since it came out mariadb, for years now without any problem. Now, something serious (a bug ?) suddendly happened. (mariadb server crashed and a whole table was gone afterwards. So I wonder where would be the right place to communicate / discuss this problem? Hope that someone here can point me in the right direction. regards, Norbert
Hi, If you're looking to report bugs, you can find the MariaDB Jira here: https://jira.mariadb.org What sort of a problem did you encounter? It's possible that it's not a bug so some more details would be good. Markus On 3/14/19 13:19, Norbert Zawodsky wrote:
Hello to everybody!
I hope that this mailing list is the right place to ask this question...
I have been using mysql, and since it came out mariadb, for years now without any problem. Now, something serious (a bug ?) suddendly happened. (mariadb server crashed and a whole table was gone afterwards. So I wonder where would be the right place to communicate / discuss this problem?
Hope that someone here can point me in the right direction.
regards, Norbert
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Markus Mäkelä, Senior Software Engineer MariaDB Corporation t: +358 40 7740484 | IRC: markusjm@freenode
Hi Markus, as I wrote before, I wasn't sure if this list was the right place. So I didn't want to go into more details first. What I did: * A relatively simple table, 5 columns, col1...col4 unsingned integers (medium and tiny), col5 decimal * col1...col4 together form the primary key * besides this, col2...col4 have foreign key constraint pointing to 3 other tables First I had 4 indexes * primary (col1,col2,col3,col4) * col2_Idx (col2) * col3_Idx (col3) * col4_Idx (col4) and the 3 foreign key constraints. Some weeks ago I wondered if the 3 indexes for col2...col4 are necessary at all, because this 3 columns are allready part of the primary key. So I thought "just try" and simply DROPed them. The server did not complain and the table still "worked" as before for some weeks now. Yesterday evenenig I added a 6th column (of type decimal) to the table. Still everything was fine. I inserted some records, everything ok. Today I connected to the DB again (from a different machine). When I inserted the first record I saw that the 3 foreign key were gone. Now I guessed that there was a problem with the deleted indexes in the server by adding the 6th column. For a test I tried to recreate 1 of those indexes (for col2). There the server crashed. (See the log attached to this mail) Norbert Am 14.03.19 12:24 schrieb Markus Mäkelä:
Hi,
If you're looking to report bugs, you can find the MariaDB Jira here: https://jira.mariadb.org
What sort of a problem did you encounter? It's possible that it's not a bug so some more details would be good.
Markus
Innodb indexes FK's automatically. You don't want to drop these indexes. From your log it looks like something went wrong with one of these index drops. You could look inside the frm file to see if one of the old ones is still define. You probably want to restore form backups or look at innodb_force_recovery. R -----Original Message----- From: Maria-discuss <maria-discuss-bounces+rhys.campbell=swisscom.com@lists.launchpad.net> On Behalf Of Norbert Zawodsky Sent: 14 March 2019 13:18 To: maria-discuss@lists.launchpad.net Subject: Re: [Maria-discuss] how to file a problem / bug ? Hi Markus, as I wrote before, I wasn't sure if this list was the right place. So I didn't want to go into more details first. What I did: * A relatively simple table, 5 columns, col1...col4 unsingned integers (medium and tiny), col5 decimal * col1...col4 together form the primary key * besides this, col2...col4 have foreign key constraint pointing to 3 other tables First I had 4 indexes * primary (col1,col2,col3,col4) * col2_Idx (col2) * col3_Idx (col3) * col4_Idx (col4) and the 3 foreign key constraints. Some weeks ago I wondered if the 3 indexes for col2...col4 are necessary at all, because this 3 columns are allready part of the primary key. So I thought "just try" and simply DROPed them. The server did not complain and the table still "worked" as before for some weeks now. Yesterday evenenig I added a 6th column (of type decimal) to the table. Still everything was fine. I inserted some records, everything ok. Today I connected to the DB again (from a different machine). When I inserted the first record I saw that the 3 foreign key were gone. Now I guessed that there was a problem with the deleted indexes in the server by adding the 6th column. For a test I tried to recreate 1 of those indexes (for col2). There the server crashed. (See the log attached to this mail) Norbert Am 14.03.19 12:24 schrieb Markus Mäkelä:
Hi,
If you're looking to report bugs, you can find the MariaDB Jira here: https://jira.mariadb.org
What sort of a problem did you encounter? It's possible that it's not a bug so some more details would be good.
Markus
Hi Norbert, The right place for such a problem report would be https://jira.mariadb.org , the bug / issue / project tracker for MariaDB. Rasmus On Thu, Mar 14, 2019 at 1:20 PM Norbert Zawodsky <norbert@zawodsky.at> wrote:
Hello to everybody!
I hope that this mailing list is the right place to ask this question...
I have been using mysql, and since it came out mariadb, for years now without any problem. Now, something serious (a bug ?) suddendly happened. (mariadb server crashed and a whole table was gone afterwards. So I wonder where would be the right place to communicate / discuss this problem?
Hope that someone here can point me in the right direction.
regards, Norbert
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (4)
-
Markus Mäkelä -
Norbert Zawodsky -
Rasmus Johansson -
Rhys.Campbell＠swisscom.com