- discuss - lists.mariadb.org

[Maria-discuss] Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)
by Tanstaafl 09 Jul '14

09 Jul '14

Hi all, I'm very inexperienced mariadb/mysql/sql user/admin, but not totally clueless, been maintaining a tiny mysql DB for postfixadmin for years, then converted it to mariadb. We recently started using SOGo (groupware). I hired the SOGo guys to help with the install/config, and have been using it trouble-free for a few months now (love it for the most part), until now. Everything seems to be working fine, but since the upgrade to SOGo 2.2.4 on 6/12, which I am told increases the number of connections it uses to the DB, I have been getting very occasional errors like this (the system error is always either 104 or 0): 2014-06-12 03:30:15.530 sogo-tool[31674] ERROR: could not open MySQL4 connection to database 'sogo': Lost connection to MySQL server at 'reading authorization packet', system error: 104 <0x0x236c140[GCSChannelManager]> could not open channel <MySQL4Channel[0x0x22241b0] connection=0x(null)> for URL: mysql://user:password@myhost.com:3306/sogo/sogo_sessions_folder <0x0x236c140[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2014-06-12 03:30:01 -0400 2014-06-12 03:30:15.531 sogo-tool[31674] Can't aquire channel But it only happened once per day after the upgrade, then once it happened twice (about 12 hours apart), and it happened at times when the load would be the lowest (ie, 3:30am for the one above). Googling reveals a lot of reports about this error over the years, some seemingly to be bugs, others DB tuning issues. Should I be looking at tuning: max_connections max_user_connections ? If not, does anyone know where I should start looking? Is there some kind of extra logging I could enable that wouldn't cause serious performance problems? Or... maybe this is simply not something I should be worried about? Thanks for any help/suggestions...

5 23

[Maria-discuss] max_connections variable
by Tanstaafl 08 Jul '14

08 Jul '14

Hello all, How is the max_connections variable used? Apparently it counts the max number of connections for all users combined, but is there a time factor? Ie, is it just simultaneous connections? Or max_connections per day? per hour? Thanks

4 3

[Maria-discuss] Galera cluster with asynchronous slave
by Johnny Antonsen 03 Jul '14

03 Jul '14

Hi! First off let show you what we are trying to achieve: Galera Cluster: MariaDBNode1 - HAProxy - keepalived <- MariaDBNode2 - HAProxy - keepalived <- MariaDB Slave node with GTID MariaDBNode3 - HAProxy - keepalived <- I'm currently working on a high-availability project where we want to use MariaDB 10 and Galera as the backend. Running this system as it is with Haproxy and keepalived works great. We are able to write to the VIP that is being moved between each node and haproxy takes care of redirecting the server with least connections. The problem comes when we want to do a standard master/slave replication from the cluster to an external slave. The slave is set up to connect to the VIP (or I have also been testing with connecting directly to the haproxied ip), and Using_gtid is set to Slave_pos. However, after some time, once the connection changes to a different node through haproxy, the following error occurs: Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave requested to start from GTID 3-1-422, which is not in the master's binlog' And the Slave_IO_State shows that it's no longer in sync. I have run SELECT @@GLOBAL.gtid_slave_pos; to check what the current GTID for each node is, and they all return: 1-1-2145, however, sometimes if I add a lot of data, that value is different on some nodes, which is why I think the slave gets confused. On the slave, when activating using_gtid=slave_pos, the following gtid_IO_pos appear: 1-1-2464,2-3-420,3-1-422 From what I have read, this should be somewhat correct, as the first value is the server id. However, in the config I have specified that node 1 has server id 1, node 2 has id 2 and so on, and that the same goes for gtid_domain_id. Is this the correct setup or do the nodes need to have the same server-id or gtid_domain_id? Surely there must be a good way to solve this? Is the system not built to handle an asynchronous slave replicating from one random node? Hope I can get some good feedback on this. Just as a side-note, I'm fairly new to mariadb and galera cluster, so be gentle :) With best regards Johnny Antonsen

1 0

[Maria-discuss] information about functions
by Roberto Spadim 02 Jul '14

02 Jul '14

hi guys! does information plugin show something about, what functions i'm using in my mariadb server? for example, i want know what udf functions are being executed and for a second step, there's something to block functions ? like some user only use sum() and min() max(), i want to block count() function -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

2 1

Re: [Maria-discuss] Utexas MariaDb Repository Down?
by Colin Charles 30 Jun '14

30 Jun '14

Hi! On 30 Jun 2014, at 09:25, Dirk Collins <collins.dirk(a)gmail.com> wrote: > I have not been able to download MariaDB from the UTexas Austin secured archive... The files are being corrupted by the server there, and it doesn't seem like the Java Web Publishing app they are using down there is working properly. > > Is there any alternative cloud servers or torrents where I can download 10.0.12 for Windows, either as an MSI or Zip file? You might try: http://ftp.osuosl.org/pub/mariadb/mariadb-10.0.12 And for the Windows files, they are: http://ftp.osuosl.org/pub/mariadb/mariadb-10.0.12/winx64-packages/ HTH -- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles

1 0

[Maria-discuss] New Question: Support for non autoincrement kes
by AskMonty KB 28 Jun '14

28 Jun '14

Hello, A new question has been asked in "Archive" by openiduser42: -------------------------------- This documentation says "ARCHIVE allows a maximum of one key. The key can be a PRIMARY KEY on an AUTO_INCREMENT column. However, it has a limitation ...". This sounds like AUTO_INCREMENT is an optional setting that causes a limitation, but trying to create an archive without auto increment gives an error: CREATE TABLE t1 (id int NOT NULL, PRIMARY KEY (id)) ENGINE = ARCHIVE; Error: Can't create table `test`.`t1` (errno: 140 "Wrong create options") Just adding AUTO_INCREMENT solves the problem. So, is this a bug or AUTO_INCREMENT is mandatory for ARCHIVE tables? If so, the documentation should say MUST, not CAN. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/support-for-non-autoincrement-kes/

1 0

[Maria-discuss] New Question: Connect Spring Hibernate and C3p0 application to Mariadb through SSL certificate authentication.
by AskMonty KB 25 Jun '14

25 Jun '14

Hello, A new question has been asked in "MariaDB FAQ" by ashishjagtap: -------------------------------- I have created application in Spring,Hibernate and c3p0 which is now connecting to Mysql database. now we are migrating our application to MariaDB (Server version: 5.5.5-10.0.7-MariaDB Source distribution) through SSL. following is the configuration file that we are using to connect to Mysql database JDBC.properties jdbc.initialPoolSize=10 jdbc.maxPoolSize=30 jdbc.minPoolSize=5 jdbc.acquireIncrement=3 jdbc.acquireRetryAttempts=0 jdbc.preferredTestQuery=SELECT 1 jdbc.idleConnectionTestPeriod=600 jdbc.numHelperThreads=10 jdbc.debugUnreturnedConnectionStackTraces=true jdbc.mydbUrl=jdbc:mysql://myhost.com:3306/mydb?verifyServerCertificate=true&useSSL=true&requireSSL=true&characterEncoding=utf8 jdbc.mydbUsername=myuser datasource-context.xml <bean id="mydbCommon" class="com.mchange.v2.c3p0.ComboPooledDataSource" abstract="true" destroy-method="close"> <property name="driverClass" value="${jdbc.rptdbDriverClassName}"/>  <property name="initialPoolSize" value="${jdbc.initialPoolSize}"/> <property name="maxPoolSize" value="${jdbc.maxPoolSize}"/> <property name="minPoolSize" value="${jdbc.minPoolSize}"/> <property name="acquireIncrement" value="${jdbc.acquireIncrement}"/> <property name="acquireRetryAttempts" value="${jdbc.acquireRetryAttempts}"/> <property name="preferredTestQuery" value="${jdbc.preferredTestQuery}"/> <property name="idleConnectionTestPeriod" value="${jdbc.idleConnectionTestPeriod}"/> <property name="numHelperThreads" value="${jdbc.numHelperThreads}"/> <property name="debugUnreturnedConnectionStackTraces" value="${jdbc.debugUnreturnedConnectionStackTraces}"/> </bean> <bean id="mydb" parent="mydbCommon"> <property name="jdbcUrl" value="${jdbc.mydbUrl}"/> <property name="user" value="${jdbc.mydbUsername}"/> </bean> we are able to connect to DB server through command line using following command mysql -h myhost.com -P3306 -umyuser --ssl-ca ca.crt --ssl-cert app.crt --ssl-key my-key.key now how can I specify --ssl-ca,--ssl-cert and --ssl-cert files while connecting to MariaDB through Hibernate and c3p0. or what is the steps to connect to MariaDB database through SSL using c3p0 and hibernate. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connect-spring-hibernate-and-c3p0-application-to-m…

1 0

[Maria-discuss] New Question: MariaDB Galera 10 stable?
by AskMonty KB 25 Jun '14

25 Jun '14

Hello, A new question has been asked in "Galera" by massimilianoadamo: -------------------------------- I am using MariaDB-Galera 10 on preprod & test environments and I haven't seen any problem so far. Any chance to see a so-called stable version? Hurry up: Percona XtraDB Cluster 5.6 is out from quite long time... -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-galera-10-stable/

1 0

[Maria-discuss] User feedback statistics
by Colin Charles 21 Jun '14

21 Jun '14

Hi, http://mariadb.org/feedback_plugin/ in question -- where do we find out information about storage engines in use? List of loaded plugins? So far I see: http://mariadb.org/feedback_plugin/stats/features/ - which has some information but clearly not all information Can we also get access to all the information like if people are using the threadpool or not? I know that information is generated and we're receiving it, but we're just not exposing it (I mean I see this from SELECT * FROM information_schema.feedback;) Its also a good way to see if users are using something like the PERFORMANCE_SCHEMA Let me know how one can access this information (and even better how this can be exposed in the web interface) cheers, -colin -- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles

3 3

[Maria-discuss] New MariaDB book: Building a Web Application with PHP and MariaDB
by Daniel Bartholomew 18 Jun '14

18 Jun '14

I just received an email from Packt about a new MariaDB book they've just published, Building a Web Application with PHP and MariaDB: A Reference Guide, by Sai Srinivas Sriparasa. If you're interested, check it out: http://www.packtpub.com/building-a-web-application-with-php-and-mariadb/book I was not aware that this book was in the works, so it was a nice surprise! I'm going to pick up a copy, give it a look through, and write up a review on my personal blog. It's been a looong time since I've done anything with PHP (over ten years), so I won't have a lot to say about that part of the content, but I'm reasonably current with MariaDB. ;-) Thanks. -- Daniel Bartholomew, MariaDB Release Manager MariaDB | http://mariadb.com

1 0