- discuss - lists.mariadb.org

Re: [Maria-discuss] [DBD-mysql] mysql_server_prepare causes segmentation fault on execute (#44)
by Patrick Galbraith 28 May '13

28 May '13

Hi Jan, I suspect it's a server issue vs. client, since as you say mysql crashes. No client should be able to do that :) The real test, is to write a program in C against libmysql that uses the server-side prepared statement API and see if you can reproduce it there. Monty and his team definitely would want to know about the crash. Any chance you could run that with mysql running debug and capture a trace? I would want to get that to Monty and team ASAP. Regards, Patrick On May 25, 2013, at 6:02 AM, Jan Pingel <notifications(a)github.com> wrote: > I've been debugging an issue with prepared queries crashing on the 2nd execute() on my FreeBSD box with the following: > > perl-5.16.2_1 > p5-DBD-mysql-4.021 > p5-DBI-1.625 > mariadb-server-5.5.30 > After connect if I set $DB->{'mysql_server_prepare'} = 1 the first execute() works but on the 2nd one the connection is lost as mariadb/mysql crashes. If I set $DB->{'mysql_server_prepare'} = 0 after connect it works as expected. > > The prepared query is: > > our $shop::test_query = $DB->prepare("SELECT id, merchant_id, name, price, image FROM lbn_shop_products WHERE category_id = ? ORDER BY purchase_count DESC, ctime DESC LIMIT ?, ?"); > Executing the queries: > > #>print $shop::test_query->execute(11, 0, 15) > 3 > $VAR1 = 1; > > #>print $shop::test_query->execute(11, 0, 15) > Database Error: > Lost connection to MySQL server during query > File Line Subroutine > ...k/shared/lib/exceptions.pm 93 (eval) oyster::console::__ANON__ > ...ork/shared/lib/database.pm 17 exceptions::throw > ...ared/lib/oyster/console.pm 73 (eval) database::handle_error > ...ared/lib/oyster/console.pm 31 oyster::_console_execute > ...k/shared/lib/exceptions.pm 178 (eval) oyster::console::__ANON__ > ...ared/lib/oyster/console.pm 64 exceptions::try > script/console.pl 38 oyster::console::start > > ! HASH(0x7fdcf8abd5b8) > The mysql/mariadb log isn't very useful: > > 130525 08:45:41 mysqld_safe mysqld restarted > I believe this is the same issue mentioned on both of these: > http://bugs.mysql.com/bug.php?id=27421 > https://rt.cpan.org/Public/Bug/Display.html?id=83497 > > Is there any additional information that would be useful such as setting the trace level and reporting the output? > > — > Reply to this email directly or view it on GitHub. >

1 0

[Maria-discuss] Aria table with auto increment PK - no concurrent inserts?
by Dmitry Insta 27 May '13

27 May '13

Hello, Aria FAQ says: "Multiple concurrent inserters into the same table." However, if I create a table with autoincrement PK, ENGINE=Aria ROW_FORMAT=PAGE (tried also TRANSACTIONAL=1) then there is no concurrency - only 1 thread is working, others are stuck in "Waiting for table level lock". I couldn't find the exact description of Aria engine behaviour in docs/faq/discussions - is it the way it's supposed to be? Thank you!

1 0

[Maria-discuss] New Question: database password?
by AskMonty KB 27 May '13

27 May '13

Hello, A new question has been asked in "Getting Started" by TommiG: -------------------------------- Dear colleagues, is there a way to have user restrictions embedded into the database? I learned user accounts and passwords are stored as part of the DBMS, but not as part of the DB. Therefore someone could copy the physical DB-files to an memorystick, move it to another machine and with a fresh installation of MariaDB he can read and modify all data. We create a desktop application and would like to distribute a database with private information to the end users. Is there a way we can hide this information and restrict its access only by using our client application but not by any other client? Sure we could encrypt our secret data, but than the DBMS could not create inizes, constrains, etc. Thank you in advance. Best regards, Thomas Env: WinXP, Win7, Win8 -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/database-password/

1 0

[Maria-discuss] New Question: my.cnf
by AskMonty KB 25 May '13

25 May '13

Hello, A new question has been asked in "Getting Started" by mici: -------------------------------- Hallo people, Today I install mariaDB 5.5.31 from binary source in Linux, Installation was success but after that I could not find my.cnf file. I need to edit cnf.file because I have to change the port number. can you tell where is my my.cnf file ? thanks -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/mycnf/

1 0

[Maria-discuss] New Question: my.cnf
by AskMonty KB 25 May '13

25 May '13

Hello, A new question has been asked in "Getting Started" by mici: -------------------------------- Hallo people, Today I install mariaDB 5.5.31 from binary source in Linux, Installation was success but after that I could not find my.cnf file. I need to edit cnf.file because I have to change the port number. can you tell where is my my.cnf file ? thanks -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/getting-started-mycnf/

1 0

[Maria-discuss] Flush logs does not recreate slowlog.
by Rafał Radecki 24 May '13

24 May '13

Hi All. I use: MariaDB-server-5.5.30-1.x86_64 on CentOS release 6.4 (Final) 2.6.32-358.el6.x86_64 "flush logs" or "flush slow logs" does not recreate the file. In https://dev.mysql.com/doc/refman/5.5/en/flush.html there is "With no log_type option, FLUSH LOGS closes and reopens all log files." and "With a log_type option, only the specified log type is flushed." but neither command recreates the log file. I rotate slowlog through crontab: mv /var/log/mysqld-slow.log /var/log/mysqld-slow.log.old ; mysqladmin flush-logs Is it a bug or should it be so for some reason? Best regards, Rafal.

2 2

[Maria-discuss] MariaDB 5.5.31 now available
by Daniel Bartholomew 23 May '13

23 May '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.31. This is a bug-fix release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.31 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5531-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5531-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.31 Overview of MariaDB 5.5: https://kb.askmonty.org/en/what-is-mariadb-55 APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - 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 (my.ini on Windows) file! See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Discontinued Builds - - - - - - - - - - - - - - - - - - - - - - - The MariaDB project tries to support as many different Operating Systems and Linux Distributions as we can. However, when a distribution or OS stops receiving security and other updates it becomes difficult to freely provide packages for that platform. In such cases, our policy is to deprecate that platform and stop providing binary packages for it. Accordingly, this will be the final release of MariaDB 10.0 for the following distributions: - Ubuntu 8.04 LTS "Hardy" - Ubuntu 11.10 "Oneiric" If your chosen Linux Distribution or Operating System is deprecated, packages or support are not completely unavailable. Companies such as SkySQL and others provide support for all versions of MariaDB back to even very old MySQL versions. This includes packaged binaries. Contact them for more details. More information on the deprecation policy can be found at: - https://kb.askmonty.org/en/mariadb-deprecation-policy/ - - 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 MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://kb.askmonty.org/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] Update mariadb-galera-server in Debian repository to 5.5.30
by Patric Falinder 17 May '13

17 May '13

Hi, I was just going to try MariaDB Galera on a couple of Debian 7.0 servers and noticed that the package mariadb-galera-server is not updated to version 5.5.30, it's still 5.5.29 which makes it impossible to install through the repository as it depends on libssl0.9.8 and Debian 7.0 is using libssl1.0.0. When looking at this bugreport https://mariadb.atlassian.net/browse/MDEV-4229 and if I understand it right, it's fixed in version 5.5.30, "Fix Version/s: 5.5.30-galera". Or have I misinterpreted that? Was mariadb-galera-server just missed when the updates where made? Can someone clarify that it's fixed in version 5.5.30 and if the repository is going to be updated? Thanks for your time, -Patric -

2 2

[Maria-discuss] mariadb update through yum repo when new version is available?
by Rafał Radecki 16 May '13

16 May '13

Hi All. I use http://yum.mariadb.org/5.5.30/centos6-amd64/ . Current version is 5.5.30. I would like to use the same version on all my mariadb machines so that (for example) the file format of storage engines would be the same (I make frequently rsyncs between servers). Lets assume that a new version 5.5.31 would be available in repo and then an update would be made. Are updates from 5.5.X to 5.5.Y always safe (small changes) or there can be problems/I should always read release info? Best regards, Rafal.

2 1

[Maria-discuss] int(x) does nothing
by Richard Couture 15 May '13

15 May '13

We discovered that declaring an int(x) of x characters does not seem to impose any restrictions what-so-ever on the size of data that can be stored in that int. Storing an int of greater dimension than that which was declared does NOT even generate a warning. Can someone please tell us why we are allowed to make such declarations and what are there purposes? Thanks Richard -- LinuxCabal Asociación Civil Ing. Richard Couture Novell CNE, ECNE, MCNE HP/Compaq ASE Tel.: (+52) (333) 145-2638 Cel.: (+52) (044) 333 377-7505 Cel.: (+52) (044) 333 377-7506 Web: http://www.LinuxCabal.org E-Mail: rrc(a)linuxcabal.org Hosted en la nube Cloud Sigma - www.CloudSigma.com AVISO DE CONFIDENCIALIDAD: Este correo electrónico, incluyendo en su caso, los archivos adjuntos al mismo, pueden contener información de carácter confidencial y/o privilegiada, y se envían a la atención única y exclusivamente de la persona y/o entidad a quien va dirigido. La copia, revisión, uso, revelación y/o distribución de dicha información confidencial sin la autorización por escrito de LinuxCabal está prohibida. Si usted no es el destinatario a quien se dirige el presente correo, favor de contactar al remitente respondiendo al presente correo y eliminar el correo original incluyendo sus archivos, así como cualesquiera copia del mismo. Mediante la recepción del presente correo usted reconoce y acepta que en caso de incumplimiento de su parte y/o de sus representantes a los términos antes mencionados, LinuxCabal tendrá derecho a los daños y perjuicios que esto le cause.

4 3