- discuss - lists.mariadb.org

[Maria-discuss] jdbc failure after restart
by l vic 23 Nov '16

23 Nov '16

i have the following jdbc exception in my jdbc client for the node 1 after another node (node2) is removed: om.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: WSREP has not yet prepared node for application use at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at com.mysql.jdbc.Util.getInstance(Util.java:387) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:917) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369) at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3833) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3283) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2297) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.GeneratedConstructorAccessor5.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328) at java.sql.DriverManager.getConnection(DriverManager.java:664) I wonder why i have this failure when i just trying to read db from the unaffected node? The failure seems to be permanent, once it happened - all subsequent reads fail

2 3

Re: [Maria-discuss] master and slave binlog question?
by Pavel Ivanov 18 Nov '16

18 Nov '16

I guess you can do it like that, yes. I wonder what do you need it for though. On Thu, Nov 17, 2016 at 9:45 PM, Ljr Yang <dbmsprog(a)gmail.com> wrote: > Thank you. > > innobackup backup info on slave: > #cat xtrabackup_binlog_info > mysql-bin.000003 83882214 0-118-60061898358 > > Only filter GTID 0-118-60061898358 in all binlog file of slave ? > > mysqlbinlog -vv mysqbin.000001 | grep -B5 "0-118-60061898358" > mysqlbinlog -vv mysqbin.000002 | grep -B5 "0-118-60061898358" > ........ > > 2016-11-18 13:24 GMT+08:00 Pavel Ivanov <pivanof(a)google.com>: >> >> There is no way to find corresponding binlog file and position on the >> slave. You should use GTIDs to find corresponding binlog positions. >> >> On Thu, Nov 17, 2016 at 7:19 PM, Ljr Yang <dbmsprog(a)gmail.com> wrote: >> > >> > Hi, >> > we config master slave and set log_slave_updates = 1 on slave. >> > on master server‘s binlog file and pos , example: mysql-bin.000005 >> > 2036891 , >> > how could quick find corresponding binlog file and pos on slave? >> > Thanks. >> > >> > -- >> > Ljr >> > >> > _______________________________________________ >> > Mailing list: https://launchpad.net/~maria-discuss >> > Post to : maria-discuss(a)lists.launchpad.net >> > Unsubscribe : https://launchpad.net/~maria-discuss >> > More help : https://help.launchpad.net/ListHelp >> > > > > > > -- > Ljr

1 0

[Maria-discuss] master and slave binlog question?
by Ljr Yang 18 Nov '16

18 Nov '16

Hi, we config master slave and set log_slave_updates = 1 on slave. on master server‘s binlog file and pos , example: mysql-bin.000005 2036891 , how could quick find corresponding binlog file and pos on slave? Thanks. -- Ljr

2 1

[Maria-discuss] Download speeds on archive.mariadb.org
by Guillaume Lefranc 14 Nov '16

14 Nov '16

Hi everyone, Download speeds on archive.mariadb.org have reached an abysmal level - 6kb/s today. Honestly, what is the foundation waiting for to solve this issue that has been lasting for years? I am ready to donate server space and bandwidth myself if needed.

4 7

[Maria-discuss] galera replication specs?
by l vic 14 Nov '16

14 Nov '16

Is there online docs to describe Galera in detail, such as specs/RFC? Thanks,

2 1

[Maria-discuss] rsync failure?
by l vic 08 Nov '16

08 Nov '16

Have the rsync failure (see the trace below): 2016-11-08 15:17:34 139959897945856 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_rsync --role 'joiner' --address 'node3.frame.mesos' --datadir '/var/lib/mysql/' --parent '114' '' Read: '(null)' 2016-11-08 15:17:34 139959897945856 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'joiner' --address 'node3.frame.mesos' --datadir '/var/lib/mysql/' --parent '114' '' : 1 (Operation not permitted) 2016-11-08 15:17:34 139960239241984 [ERROR] WSREP: Failed to prepare for 'rsync' SST. Unrecoverable. 2016-11-08 15:17:34 139960239241984 [ERROR] Aborting Can someone with better understanding of replication process explain the nature of this problem? Can it be caused by hostname resolution failure, or would it be storage related? Thank you,

2 6

[Maria-discuss] rsync timeout?
by l vic 08 Nov '16

08 Nov '16

Is it possible to increase rsync timeout? I checked http://galeracluster.com/documentation-webpages/galeraparameters.html but couldn't find corresponding parameters... Thanks, -V

2 2

[Maria-discuss] on stored procedures
by Federico Razzoli 08 Nov '16

08 Nov '16

Some good points from Bill Karwin: https://www.quora.com/What-are-the-reasons-not-to-use-or-not-use-stored-pro… Federico

5 10

Re: [Maria-discuss] on stored procedures
by Federico Razzoli 08 Nov '16

08 Nov '16

Hi Sergei! I was wondering the same! Justin's explanation is probably correct, but I think that various discussions in this list proven that a part of the community badly wants this feature. I wrote a unit tester in SQL some time ago (I know it may sound weird, but I needed it to test several things, from procedures to query time, and even metrics). It was insanely hard. I mean - I think I can write a unit tester in JavaScript or PHP or even BASH in a few hours, with all the features I want. But SQL is full of traps, so it took weeks (of course it was not my only task). Some of the features that have been discussed in this list could have been implemented as stored procedures. For example, extensions to KILL. It may not be the perfect solution but, well, it is not reasonable to expect that you implement every single need/idea I have during my work. If I could write general purpose stored procedures in any decent language, I would do it, and then would push them to GitHub. It seems that some people agree on this but... still nothing happens. Even PL/SQL parser seems to have higher priority than external languages! :( Is there anything we can do to convince the team? Bye, Federico -------------------------------------------- Lun 7/11/16, Sergei Golubchik <serg(a)mariadb.org> ha scritto: Oggetto: Re: [Maria-discuss] on stored procedures A: "Justin Swanhart" <greenlion(a)gmail.com> Cc: "Federico Razzoli" <federico_raz(a)yahoo.it>, "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Lunedì 7 novembre 2016, 22:42 Hi, Justin! On Nov 07, Justin Swanhart wrote: > We discussed it here and it seemed vary popular. WL-820. I know, right? A cool and useful feature, I'd say. I cannot understand why it's constantly being pushed down for the last 10 years. I still hope we get it someday. > On Mon, Nov 7, 2016 at 10:43 AM, Sergei Golubchik <serg(a)mariadb.org> wrote: > > Hi, Federico! > > > > On Nov 07, Federico Razzoli wrote: > > > Some good points from Bill Karwin: > > > https://www.quora.com/What-are-the-reasons-not-to-use-or- > > not-use-stored-procedures/answer/Bill-Karwin > > > > Thanks. > > > > These are valid points, and some of them are related. > > For example, "does not have a rich library of functions or standard > > procedures" that follows from "does not support packages". > > Which might be fixed in https://jira.mariadb.org/browse/MDEV-10591 > > > > External languages for stored procedures - that's a very cool feature, > > and patches exist for many years. But, apparently, it's more cool than > > practically useful? There were almost no requests for it, not when I was > > in MySQL, not in MariaDB. And, frankly, I do not know why, this looks > > insanely useful to me. Regards, Sergei Chief Architect MariaDB and security(a)mariadb.org

1 0

[Maria-discuss] MariaDB 10.1.19 and other releases now available
by Daniel Bartholomew 07 Nov '16

07 Nov '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.19, MariaDB Galera Cluster 10.0.28, and MariaDB Connector/ODBC 2.0.13. These are all stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.19 - Release Notes: https://mariadb.com/kb/en/mdb-10119-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10119-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.19 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Galera Cluster 10.0.28 - Release Notes: https://mariadb.com/kb/en/mgc-10028-rn/ - Changelog: https://mariadb.com/kb/en/mgc-10028-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.28 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/ODBC 2.0.13 - Release Notes: https://mariadb.com/kb/en/mco-2013-rn/ - Changelog: https://mariadb.com/kb/en/mco-2013-cl/ - Downloads: https://downloads.mariadb.org/connector-odbc/2.0.13 About MariaDB Connector/ODBC: - https://mariadb.com/kb/en/about-mariadb-connector-odbc/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadbfdn - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0