[Maria-discuss] New Question: my.cnf
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/ ___ 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
[Maria-discuss] New Question: my.cnf
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/ ___ 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
[Maria-discuss] New Question: database password?
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/ ___ 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
[Maria-discuss] New Question: Netbeans 7.3 + Hibernate + MariaDB Java Client + MySQL database
Hello, A new question has been asked in "MariaDB Java Client" by mr_lou_d: Although I can access the database through Netbeans using this driver and MySQL database, I am having difficulty getting Hibernate to work with the driver. Hibernate.cfg file has these entries: org.mariadb.jdbc.Driver jdbc:mysql://localhost:3306 /myspecial?zeroDateTimeBehavior=convertToNull [MariaDB - root on myspecial] org.hibernate.dialect.MySQLDialect Note that the Hibernate plugin can't seem to find (doesn't have) any valid dialects for the mariadb driver. Therefore I edited the above xml to force MySQLDialect. This allowed me to get a little further, but when I try to create new "Hibernate mapping files and pojos from database", I fill in the dialog - but no files are generated. When I follow the same steps with the MySQL Java "Connector", including the same hibernate.reveng, it generates the pojos, and all works fine. Thanks for taking a look at this... Any ideas? To view or answer this question please visit: http://kb.askmonty.org/en/netbeans-73-hibernate-mariadb-java-client-mysql-database/ ___ 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
[Maria-discuss] New Question: Aria Max Table Size for internal on-disk temporary tables
Hello,
A new question has been asked in "Aria" by trsystran:
Using MariaDB 5.5.31 (deb file for ubuntu 12.04 amd_64: 5.5.31+maria-1~precise).
When a query requires an internal temporary tables, and this tables becomes too
large to be kept in ram, the table is moved to disk using Aria engine.
If the on-disk .MAD file reaches 4GB, an error occurs:
{{{
[ERROR] mysqld: The table '/tmp/#sql_74e_0' is full
}}}
How can we change this limit?
In https://kb.askmonty.org/en/aria-max-table-size/ it is recommended to change
MAX_ROW, but it only applies for explicitly created temporary tables.
Looking at the code I found this in maria_create():
{{{
data_file_length= ulonglong) 1 << ((BLOCK_RECORD_POINTER_SIZE-1) *
8))/2 -1) * maria_block_size);
}}}
Which amounts to 4GB with default values (8192 for maria_block_size).
I created a new DB with aria-block-size = 32768 (the max value), and it still
failed at 4GB.
Even if it worked, it would mean the max size is only 16GB, and setting a large
block size may have performance penalties.
So what is the proper fix to increase this limit?
With MyISAM as on-disk temporary tables engine the limit seems to be much
higher (at least 14GB from experiments).
To view or answer this question please visit:
http://kb.askmonty.org/en/aria-max-table-size-for-internal-on-disk-temporary-tables/
___
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
[Maria-discuss] New Question: Schema Missing after upgrading from MySQL 5.5.8 to MariaDB 5.5.31
Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by reustmd: My OS is Windows 7 64-bit. I used the MariaDB msi installer. I uninstalled MySQL and installed MariaDB. I then launched sqlyog and it only found the standard mysql schemas (e.g., information_schema, mysql, performance_schema). My application schema appears to be missing. I also tried running "mysql_upgrade --verbose" and that didn't seem to help. Should I have to do something else? Thanks! To view or answer this question please visit: http://kb.askmonty.org/en/schema-missing-after-upgrading-from-mysql-558-to-mariadb-5531/ ___ 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
[Maria-discuss] New Question: 100% RAM and Swapping
Hello, A new question has been asked in "MariaDB community" by danezpz: Hi, Having recently converted our cPanel servers from MySQL to MariaDB we're having issues with MariaDB using 100% of a servers RAM and swap when a customer optimises a table. This doesn't happen under normal circumstances and only when an optimize is run. Any ideas what's cause this? The servers have 16GB RAM and use the following my.cnf: http://paste2.org/P3cZzBHN Using MariaDB 5.5.30 Any help would be appreciated Thanks To view or answer this question please visit: http://kb.askmonty.org/en/100-ram-and-swapping/ ___ 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
[Maria-discuss] New Question: How to define a date in order to import an empty date from a CSV file?
Hello, A new question has been asked in "Data Types" by JohnD: I have a CSV file containing amongst other things a couple of date columns. Some of the date values are empty - that is just ",," - a comma followed by another comma. The date rows in the table are defined like this: `PTY_USR_PASSWORD_DATE` DATE NULL DEFAULT NULL, But when I import the data (using HeidiSQL), I get the following error: /* SQL Error (1292): Incorrect date value: '' for column 'PTY_USR_PASSWORD_DATE' at row 1 */ How should I set up the table to allow this? Or how can I modify the CSV? John D. To view or answer this question please visit: http://kb.askmonty.org/en/how-to-define-a-date-in-order-to-import-an-empty-date-from-a-csv-file/ ___ 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
[Maria-discuss] New Question: Executing a command file from within a command file?
Hello, A new question has been asked in "mysql client" by JohnD: I have a bunch of things I'd like to execute one after the other. A simple example would be: - drop table x; - drop table y; - create table y by executing create_table_y.sql - create table x by executing create_table_x.sql With the mysql command line, I can execute "drop table x;", and I can execute a SQL script with -e "source create_table_x.sql". But what is the good way to bundle all these together into a script which will do all the actions? The only way I can think of is to create a batch file which will call out to mysql for each action. And pass the password as an argument to the batch file. Like this: mysql -u root -p mypassword -e "drop table x;" mysql -u root -p mypassword -e "drop table y;" mysql -u root -p mypassword -e "source create_table_y.sql" mysql -u root -p mypassword -e "source create_table_x.sql" But this seems fairly clunky. Is there a better, or even best practice? John D. To view or answer this question please visit: http://kb.askmonty.org/en/executing-a-command-file-from-within-a-command-file/ ___ 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
[Maria-discuss] New Question: compile mariadb from source
Hello, A new question has been asked in "MariaDB community" by raph: i try to compile mariadb from source and got error oqgraph not found, so i put option in cmake command -DWITHOUT_OQGRAPH_STORAGE_ENGINE=1 every thing work fine. my os is opensuse11.4 . how do i compile with oqgraph support. thanks To view or answer this question please visit: http://kb.askmonty.org/en/compile-mariadb-from-source/ ___ 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
[Maria-discuss] New Question: MariaDB SSL connection issues
Hello, A new question has been asked in "Getting Started" by bacterie: Hi, After switching from Mysql to MariaDB ( Server version: 5.5.31-MariaDB-1~squeeze-log ) we lost the ability to connect via SSL to the server. We were using self signed certificates generated via the method described here and they worked well before the switch to MariaDB : http://dev.mysql.com/doc/refman/5.5/en/creating-ssl-certs.html We get the following error messages when trying to connect on the same machine having bot the client and the server. mysql -v -u user -p database --ssl-ca /etc/mysql/newcerts/ca-cert.pem --ssl-cert /etc/mysql/newcerts/client-cert.pem --ssl-key /etc/mysql/newcerts/client-key.pem Enter password: ERROR 2026 (HY000): SSL connection error: error:0001:lib(0):func(0):reason(1) Any hint is appreciated. Thanks. To view or answer this question please visit: http://kb.askmonty.org/en/mariadb-ssl-connection-issues/ ___ 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
[Maria-discuss] New Question: Windows Authentication on AD
Hello, A new question has been asked in "Plugins" by nobi: Hi all, I have a question concerning the authentication plugin interface in MariaDB. We would use MariaDB on a Windows OS and want to authenticate the users against Active Directory. Additionally the users, who have logged in to Windows, should be able to connect from client programs to the server based on the token information in their environment without specifying an additional password (Single-Sign-On functionallity). MySQL sells this function in the commercial MySQL Enterprise version http://www.mysql.com/products/enterprise/security.html I have seen articles about authentication with PAM in the linux environment but found nothing about authentication issues in Windows world. Does there exist something that can be used? Best regards, nobi To view or answer this question please visit: http://kb.askmonty.org/en/windows-authentication-on-ad/ ___ 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
[Maria-discuss] New Question: Downloading MariaDB and starting the installation procedure
Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by tsperry: I've downloaded the package several times but the installation feature won't start. What am I doing wrong? To view or answer this question please visit: http://kb.askmonty.org/en/downloading-mariadb-and-starting-the-installation-procedure/ ___ 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
[Maria-discuss] New Question: Downloading MariaDB and starting the installation procedure
Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by tsperry: I've downloaded the package several times but the installation feature won't start. What am I doing wrong? To view or answer this question please visit: http://kb.askmonty.org/en/getting-installing-and-upgrading-mariadb-downloading-mariadb-and-starting-t/ ___ 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
[Maria-discuss] New Question: Issue with symlinked database directories loading under windows
Hello, A new question has been asked in "Using MariaDB" by scottharman: Hi all, I'm having trouble getting symlinked databases to work under 5.5.31 of MariaDB Currently the databases are held on a different drive, and I've tried both Symlinks and Junctions under windows to get them working under MariaDB Both methods work equally well under MySQL 5.5.31, and I've enabled symlink support in my.ini for Mariadb Any thoughts on why it wouldn't be working? To view or answer this question please visit: http://kb.askmonty.org/en/issue-with-symlinked-database-directories-loading-under-windows/ ___ 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
[Maria-discuss] New Question: installation and license
Hello, A new question has been asked in "Getting Started" by JDoggieIII: Hi, we want to use MariaDB on several machines, one of which contains MS SQL 2008 R2 (which we don't want to use). Does MariaDB play nice on the same server as MS SQL 2008 R2? Also, is there a license somewhere, I can't locate one. Thanks, Jeremy To view or answer this question please visit: http://kb.askmonty.org/en/installation-and-license/ ___ 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
[Maria-discuss] New Question: LINQ in C#
Hello, A new question has been asked in "Using MariaDB" by JDoggieIII: Hi, I am attempting to replace the database in an application with MariaDB. This application is written in C# and previously accessed the database (mostly inserts) with LINQ. When I attempt to insert (other transactions have the same type of issue) I get the error message: "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '[t0].[Id], [t0].[BirthYear], [t0].[FirstName], [t0].[Gender], [t0].[LastName], [' at line 1" The table in MariaDB is setup the same as it was in MS SQL. Any thoughts on this subject would be most appreciated. I could go back and remove all use of LINQ and write SQL by hand (which is how I would have implemented it in the first place due to LINQ being the bane of my existence), but if I can get it to work as is it will save a great deal of time, and therefore money. Thanks, Jeremy To view or answer this question please visit: http://kb.askmonty.org/en/linq-in-c/ ___ 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
[Maria-discuss] New Question: Changing location of database
Hello, A new question has been asked in "MariaDB community" by mdavies5: Using 5.5.31 on Linux Mint. By default datadir is /var/lib/mysql. Like most users I do not want my data on my boot drive so I moved it to a different physical drive which is always mounted. I then stopped server, reset the basedir in my.cnf and restarted. No problem. After a reboot the log shows multiple errors "Table xxx doesn't exist" although it does. In Mysql workbench the tables are listed in the schema tree but any attempt to access causes workbench to abort. I also tried deleting all data, recreate the schema folders and then the scripts to create the tables and routines and data. Again ok until a reboot. The only thing I haven't tried is dropping the schemas and recreating them in workbench. Relevant data: The new data drive is NTFS. The error messages include: [ERROR] Cannot find or open table pword/pword from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? or, the table contains indexes that this version of the engine doesn't support. Would appreciate any suggestions. To view or answer this question please visit: http://kb.askmonty.org/en/changing-location-of-database/ ___ 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
[Maria-discuss] New Question: zip or msi
Hello, A new question has been asked in "What is in the different MariaDB releases?" by Swirl: Why is the "zip" that much bigger than the "msi"? Does it contain more info/code/tools or whatever? To view or answer this question please visit: http://kb.askmonty.org/en/zip-or-msi/ ___ 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
[Maria-discuss] New Question: Is it possible to specify a user, password, and non standard port for the thrift servers?
Hello, A new question has been asked in "Cassandra Storage Engine" by frankflynn: In the Cassandra examples we see: set cassandra_default_thrift_host='192.168.0.10' and then create table cassandra_tbl ( rowkey type PRIMARY KEY, ... thrift_host= can also be specified here But is it currently possible to specify a user, password, and/or a non standard port? I've removed the user and password and tried thrift_host='192.168.0.10:9161' (using my particular IP) but that does not seem to work. The error I get is: ERROR 1429 (HY000): Unable to connect to foreign data source: Could not resolve host for client socket. [1] I can connect to this host / port from the command line. To view or answer this question please visit: http://kb.askmonty.org/en/is-it-possible-to-specify-a-user-password-and-non-standard-port-for-the-thr/ ___ 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
[Maria-discuss] New Question: How can I install MariaDB C Client on Fedora 17/18 or CentOS 6.* without uninstalling MySQL
Hello, A new question has been asked in "MariaDB Client Library for C" by aesterkin: Hello, I need to install only client libraries without uninstalling MySQL. How can I do it? I tries installing from your YUM repository, but this installation conflicts with mysql-libs and mysql-server pachages (from "remi" repository). Thanks, Alex Esterkin To view or answer this question please visit: http://kb.askmonty.org/en/how-can-i-install-mariadb-c-client-on-fedora-1718-or-centos-6-without-unins/ ___ 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
[Maria-discuss] New Question: xtrabackup sync method
Hello, A new question has been asked in "Galera" by uxbod: Hello, have installed Maria on Centos 6.4 x86_64: MariaDB-common-5.5.31-1.x86_64 MariaDB-Galera-server-5.5.29-1.x86_64 MariaDB-compat-5.5.31-1.x86_64 MariaDB-client-5.5.31-1.x86_64 and the primary node is working fine with the configuration: [mysqld] wsrep_provider=/usr/lib64/galera/libgalera_smm.so wsrep_cluster_name="MYCLUSTER" wsrep_node_name=db1 wsrep_cluster_address="gcomm://" wsrep_slave_threads=8 wsrep_sst_method=xtrabackup wsrep_sst_auth=username:password wsrep_node_address=172.30.10.13 datadir=/var/lib/mysql innodb_autoinc_lock_mode=2 The problem is on the second node when it tries to replicate as receiving the error: 130629 8:55:17 [ERROR] WSREP: Failed to read 'ready ' from: wsrep_sst_xtrabackup --role 'joiner' --address '172.30.10.18' --auth 'username:password' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '7131' Read: 'Can't find innobackupex in the path' yet innobackupex is indeed within the path. What could the issue be please ? To view or answer this question please visit: http://kb.askmonty.org/en/xtrabackup-sync-method/ ___ 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
[Maria-discuss] New Question: Local state seqno out of sync with group
Hello,
A new question has been asked in "Galera" by uxbod:
We have MariaDB and Galera working in our lab on a three node cluster. When
setting them up the wsrep options for each node were as follows:
{{{
node1: wsrep_cluster_address="gcomm://"
node2: wsrep_cluster_address="gcomm://172.30.1.3"
node3: wsrep_cluster_address="gcomm://172.30.1.1"
}}}
Once all the nodes were in sync I shutdown node1 and set its
wsrep_cluster_address to be 172.30.1.2. This I thought would allow the three
nodes to keep in sync. What happened though was when I started MariaDB backup
I received the error:
{{{
130702 8:35:51 [ERROR] WSREP: Local state seqno (16053) is greater than group
seqno (15898): states diverged. Aborting to avoid potential data loss. Remove
'/var/lib/mysql//grastate.dat' file and restart if you wish to continue. (FATAL)
at galera/src/replicator_str.cpp:state_transfer_required():34
}}}
Why has this happened ? Is it safe to proceed with the recommendation of
removing grastate.dat ?
To view or answer this question please visit:
http://kb.askmonty.org/en/local-state-seqno-out-of-sync-with-group/
___
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
[Maria-discuss] New Question: Amazon RDS or AWS services
Hello, A new question has been asked in "MariaDB community" by openiduser28: I'm interested in trying out MariaDB, and was wondering if anyone has MariaDB running with Amazon RDS or is it only possible using some sort of VM? I can try it out that way, but being on the free tier sure limits things. Thanks! To view or answer this question please visit: http://kb.askmonty.org/en/amazon-rds-or-aws-services/ ___ 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
[Maria-discuss] New Question: Creating a System DSN for MariaDB on Windows
Hello, A new question has been asked in "A MariaDB Primer" by marcw: Hi, I'd like to use MariaDB to back-end a system that expects an ODBC interface. Is there a way to create a system DSN for MariaDB in Windows 7? It's not showing up as a connection type in the Data Sources panel. To view or answer this question please visit: http://kb.askmonty.org/en/creating-a-system-dsn-for-mariadb-on-windows/ ___ 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
[Maria-discuss] New Question: page_checksum performance implications
Hello, A new question has been asked in "Aria" by Vasilis: Does enabling page_checksum for the Aria engine involve significant drops in performance when compared to a disabled page_checksum(ed) table? Are there any benchmarks on this one? At the end, should I enable it or not? To view or answer this question please visit: http://kb.askmonty.org/en/page_checksum-performance-implications/ ___ 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
[Maria-discuss] New Question: Does MariaDB support multiple data directories within a single instance?
Hello, A new question has been asked in "Does MariaDB support..." by joshuavalencia: MySQL 5.6 lets you define separate data directories for individual tables. This is useful if you want to put large tables on a separate storage backend - e.g. frequently used tables go on local disk, and some larger tables go on ISCSI. Does MariaDB support having multiple data directies within a single running instance? To view or answer this question please visit: http://kb.askmonty.org/en/does-mariadb-support-multiple-data-directories-within-a-single-instance/ ___ 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
[Maria-discuss] New Question: Issue in edit on MariaDB 10
Hello, A new question has been asked in "Storage Engines" by cirovargas: I have a problem when editing rows in the database, MariaDB consumes all memory and cpu. On my local computer it does not happen using mysql5.5 http://pastebin.com/k6YTpCUd http://oi42.tinypic.com/w33lt.jpg To view or answer this question please visit: http://kb.askmonty.org/en/issue-in-edit-on-mariadb-10/ ___ 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
[Maria-discuss] New Question: Which datatypes are supported by MariaDB
Hello, A new question has been asked in "Getting Started" by giordano: I would like to know which datatypes are supported by MariaDB. I'm asking since I'm little confused. For example, the knowledge base contains a chapter temporal datatypes: https://kb.askmonty.org/en/temporal-data-types/ where the the datatype timestamp is defined: "it defines a set of correctly formed values that represent any valid Gregorian calendar date between '0001-01-01' and '-12-31'" If I look at the MySQL-site http://dev.mysql.com/doc/refman/5.1/de/datetime.html The definition for timestamp is: "The TIMESTAMP data type is used for values that contain both date and time parts. TIMESTAMP has a range of '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC." These are different definitions.I know that the datatype defintions in the knowledge base contains the syntax of SQL-99. What makes me insecure is which definition has priority. Also I do not know if all datatypes in Oracle-MySQL are supported by MariaDB. For example, tinyint, bigint. (Sincerly, I know that MariaDB understand these datatypes, but I wonder if they have the same definition as given by the Oracle-MySQL-site.) Thanks for help To view or answer this question please visit: http://kb.askmonty.org/en/which-datatypes-are-supported-by-mariadb/ ___ 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
[Maria-discuss] New Question: A Few Questions About MariaDB
Hello, A new question has been asked in "General FAQ" by edutrac: I am starting a new SaaS project, and I am looking at installing MariaDB 10.x for some testing. Below are a few questions I have. 1. Most of the time in MySQL, I would use the InnoDB storage engine in which I used constraints and foreign keys. Is this feature present in XtraDB and/or Aria db engines? 2. If the feature is present in both of them, can you point me in the right direction to see a compare and contrast of the Aria and XtraDB storage engines? 3. Does MariaDB recognize the mysqli function or only the mysql function? To view or answer this question please visit: http://kb.askmonty.org/en/a-few-questions-about-mariadb/ ___ 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
[Maria-discuss] New Question: Multi-threading and Statement.cancel()
Hello, A new question has been asked in "MariaDB Java Client" by rstepanski: Attempting to execute queries on multiple threads (10 to 20) with the ability to cancel each Thread's unique Statement mid execution from a separate thread. However, when sharing a single Connection among all threads for their Statement creation, a cancel() on one Statement will cause other thread's executeQuery() to throw a "Query execution was interrupted". Switching to per thread Connections and a thread pool, the cancel() will sometimes fail with "Unknown thread id: xx". I'm assuming this occurs when a thread previously used to work with another connection attempts to cancel() another. This had worked previously with MySql jdbc (and still does with MySql jdbc + MariaDb server). The queries themselves are single table, limited/offset, selects. Where clauses would generally be related: query 1: like 'a%' query 2: like 'ab%' query 3: like 'abc%' With each previous query being cancelled when a more specific query was available. Any comments/suggestions appreciated. Thanks! To view or answer this question please visit: http://kb.askmonty.org/en/multi-threading-and-statementcancel/ ___ 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
[Maria-discuss] New Question: MarinaDB and RHEL6.4 on PowerLinux
Hello, A new question has been asked in "MariaDB community" by jinkoo: Dear all. I am testing the mariaDB 5.5 on RHEL 6.4 on PowerLinux. When I compile, I met following error message. how to solve this problem? --> snip <-- Linking CXX executable explain_filename-t /usr/bin/ld: ../../storage/csv/libcsv.a(ha_tina.cc.o)(.text+0x2940): sibling call optimization to `String::append(char)' does not allow automatic multiple TOCs; recompile with -mminimal-toc or -fno-optimize-sibling-calls, or make `String::append(char)' extern /usr/bin/ld: ../../storage/csv/libcsv.a(ha_tina.cc.o)(.text+0x2954): sibling call optimization to `String::append(char)' does not allow automatic multiple TOCs; recompile with -mminimal-toc or -fno-optimize-sibling-calls, or make `String::append(char)' extern /usr/bin/ld: final link failed: Bad value collect2: ld returned 1 exit status make[2]: *** [unittest/mysys/explain_filename-t] Error 1 make[1]: *** [unittest/mysys/CMakeFiles/explain_filename-t.dir/all] Error 2 make: *** [all] Error 2 --> end <-- and MariaDB has any plan to support for POWER system? Thanks, To view or answer this question please visit: http://kb.askmonty.org/en/marinadb-and-rhel64-on-powerlinux/ ___ 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
[Maria-discuss] New Question: Does MariaDB support for Linux on POWER system?
Hello, A new question has been asked in "Does MariaDB support..." by jinkoo: Does MariaDB support for Linux on POWER system? To view or answer this question please visit: http://kb.askmonty.org/en/does-mariadb-support-for-linux-on-power-system/ ___ 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
[Maria-discuss] New Question: mariadb on Cubieboard (ARM AllWinner A10)
Hello, A new question has been asked in "Does MariaDB support..." by aemlin: Hello, I'm using mariadb on Cubieboard (within a debian server). The compile of the sources for 5.5 did work perfectly but the 10.0 does not compile , is it possible to have some help to get it running ? Also is there a way to make my mariadb 5.5 available for other users (by exemple as a .deb file)? To view or answer this question please visit: http://kb.askmonty.org/en/mariadb-on-cubieboard-arm-allwinner-a10/ ___ 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
[Maria-discuss] New Question: Web Applications do not receive all data in Galera Cluster
Hello, A new question has been asked in "Replication" by confidus: Hello, I have a real strange issue. I have a web application that appears to not show the correct records. I am using a load balancer for a web farm for a billing system. I am also using a load balancer for the Galera cluster. When a trouble ticket is generated, sometimes that ticket is not available on all the web servers, but when I look at each individual MariaDB server, I see the record. Data commits are synced and all looks good from the cluster side of things. I can perform a mysqldump to another database and point the billing system to that database and all is good. If I reboot each MariaDB server one by one, things start working again. It almost seems like there is some caching where the database cluster at times only shows records that were generated by that web server. I did check that all the web servers in the farm are using the same load balanced ip address for the MariaDB farm and they are. I have replicated this on two different web applications (A CRM & Billing system) both on different web farms. To view or answer this question please visit: http://kb.askmonty.org/en/web-applications-do-not-receive-all-data-in-galera-cluster/ ___ 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
[Maria-discuss] New Question: use trigger for create table
Hello, A new question has been asked in "MariaDB Documentation" by bhdbing: as the title,does this db can do this? i want change my db from ORACLE to MariaDB,some problem appeared. and how to use sqlstring? in ORACLE use sql='%some sentences%'; and executed immediate, how it does in MariaDB? so my email:bhdb...@163.com,Thank you for your help! To view or answer this question please visit: http://kb.askmonty.org/en/use-trigger-for-create-table/ ___ 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
[Maria-discuss] New Question: flush host
Hello, A new question has been asked in "FLUSH commands" by h725: i have looking for info how to 'read' info which are the hosts that hit the max_connect_errors. I have found there was a patch of Jeremy Cole, but i have not found anything for Mariadb. Is there a way to know which hosts increase the max_connect_errors?? any from SHOW or information_schema? thanks a lot To view or answer this question please visit: http://kb.askmonty.org/en/flush-host/ ___ 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
[Maria-discuss] New Question: Timestamps are different
Hello, A new question has been asked in "Replication, Cluster, & Multi-Master" by confidus: I am in the very early stages of testing out our Galara cluster with innodb databases. I have a tool that is comparing data against each node on the cluster and I have found that timestamps seem to be the only thing that is inconstant and by exactly 5 hours. I have a record in a Galera cluster that has a field with date time. I took one database and started comparing each table (one by one). I had several thousand records with different timestamps. An example is 2013-07-03 11:13:59, but another server, the date time is 2013-07-03 16:13:59. I would suspect that the times would be synced everywhere exactly the same. If I run a "SELECT NOW();" on all four servers at the same time, I see: +-+ | NOW() | +-+ | 2013-08-13 14:59:51 | +-+ +-+ | NOW() | +-+ | 2013-08-13 14:59:51 | +-+ +-+ | NOW() | +-+ | 2013-08-13 14:59:51 | +-+ +-+ | NOW() | +-+ | 2013-08-13 14:59:51 | +-+ If I run a select @@global.time_zone, @@session.time_zone on all four nodes in the cluster, I also see ++-+ | @@global.time_zone | @@session.time_zone | ++-+ | SYSTEM | SYSTEM | ++-+ And if I enter date on all 4 machines, the time matches just fine. I have checked other non erip databases (some very large databases) and things are correct within those systems. [root@a2 ~]# mysql -u root -p** -h a2 -e "select * from safeplan_new1.plan_approval where plan_approval_id=3247" +--++--++--+-+--+ | plan_approval_id | plan_master_id | plan_location_id | plan_approval_location | plan_approval_by | plan_approved_on| plan_approval_status | +--++--++--+-+--+ | 3247 |292 |0 |155 | 133 | 2013-07-03 11:13:59 | 1| +--++--++--+-+--+ [root@a2 ~]# mysql -u root -p** -h a3 -e "select * from safeplan_new1.plan_approval where plan_approval_id=3247" +--++--++--+-+--+ | plan_approval_id | plan_master_id | plan_location_id | plan_approval_location | plan_approval_by | plan_approved_on| plan_approval_status | +--++--++--+-+--+ | 3247 |292 |0 |155 | 133 | 2013-07-03 16:13:59 | 1| +--++--++--+-+--+ [root@a2 ~]# mysql -u root -p** -h a4 -e "select * from safeplan_new1.plan_approval where plan_approval_id=3247" +--++--++--+-+--+ | plan_approval_id | plan_master_id | plan_location_id | plan_approval_location | plan_approval_by | plan_approved_on| plan_approval_status | +--++--++--+-+--+ | 3247 |292 |0 |155 | 133 | 2013-07-03 16:13:59 | 1| +--++--++--+-+--+ To view or answer this question please visit: http://kb.askmonty.org/en/timestamps-are-different/ ___ 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
[Maria-discuss] New Question: how can i transfer data use cursor
Hello, A new question has been asked in "MariaDB Documentation" by bhdbing: in MariaDB the cursor can't be a output datatype, generally in Oracle ,i declare a cursor and use it for transfer data,the sample like: ...rs out sys_refcursor... open rs for select * from %table name%; ... in c#,the cursor rs can be accepted,so i can get the whole data from %table name%. in MariaDB,how can i do this? To view or answer this question please visit: http://kb.askmonty.org/en/how-can-i-transfer-data-use-cursor/ ___ 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
[Maria-discuss] New Question: Hibernate Reverse Engineering wizard with MariaDB
Hello,
A new question has been asked in "MariaDB Documentation" by JohnD:
(Sorry, couldn't find a good place for this query - perhaps there ought to be a
folder "MariaDB and ORMs"?)
I'm trying to use the Hibernate Reverse Engineering wizard with MariaDB. It's
just a very simple example, but I am stuck. I don't see any errors, but it
doesn't work as described.
Here's what I've got so far:
* Windows 7 x64, Eclipse Juno, MariaDB v5.5.3, Hibernate v4.2.3
* I've got an example with Hibernate running using annotations and the same
instance of MariaDB, no problem
* Now I want to create the classes from the tables, so I'm trying to use the
reverse engineering wizard.
* I've set up a simple DB and a couple of tables
* I've set up a hibernate.cfg.xml file using the same values as my working
annotation example
* Now I use the wizard (in Eclipse) to "New/Hibernate Reverse Engineering
File (reveng.xml)"
** First page ok, second page "Configure Table filters" is where I'm stuck
** I select the correct Console configuration (generated as part of creating
the config file)
and then press the "Refresh" button
** At this point I should see my two tables in the "Database schema:" column.
But it's empty.
** I briefly see "Pending..." - then nothing.
** I can't see any errors.
So, how to move forwards? Can I turn on some logging? Where is the error? What
logs to check?
The Eclipse console window shows a bunch of stuff, all info, no errors and the
last three lines are like this:
* 2013-08-22 11:34:38,189 DEBUG Worker-33
org.hibernate.connection.DriverManagerConnectionProvider - opening new JDBC
connection
* 2013-08-22 11:34:38,198 DEBUG Worker-33
org.hibernate.connection.DriverManagerConnectionProvider - created connection
to: jdbc:mysql://localhost:3306/omthibernate, Isolation Level: 4
* 2013-08-22 11:34:38,199 INFO Worker-33
org.hibernate.connection.DriverManagerConnectionProvider - cleaning up
connection pool: jdbc:mysql://localhost:3306/omthibernate
In case it helps, here is the hibernate config (I've tried a lot of variations):
{{{
http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd";>
org.mariadb.jdbc.Driver
password
jdbc:mysql://localhost:3306/omthibernate
user
org.hibernate.dialect.MySQL5InnoDBDialect
}}}
To view or answer this question please visit:
http://kb.askmonty.org/en/hibernate-reverse-engineering-wizard-with-mariadb/
___
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
[Maria-discuss] New Question: MariaDB on AIX: am I the first to try to compile?
Hello, A new question has been asked in "Development" by mamfelt: Since the current owner of mysql is no longer interested in creating/distributing for and IBM platforms - and, as a joomla user I am accustomed to using mysql as backend I am hoping to package and use mariadb on AIX. So, anyone else who has any (successful) experience with compiling mariadb for/on AIX? If yes, what OS level did you use, and compiler? I am trying with OS 5.3TL7 and AIX 6.1TL7. I will prefer to have it work on AIX 5.3 as that should support AIX 6.1 - but at this point I am just looking for a better starting point. Thanks for reply/comments! To view or answer this question please visit: http://kb.askmonty.org/en/mariadb-on-aix-am-i-the-first-to-try-to-compile/ ___ 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
[Maria-discuss] New Question: Replication stops after one hour or so
Hello, A new question has been asked in "Replication" by Martin22: Hi there, we operate a big MariaDB-server (24 CPUs, 48 GB RAM, Version 5.5.32 with Percona XTRADB). Because it is mission-critical it is replicated to another server of similar size (row based replication). We get the ball rolling with "innobackupex" (GREAT tool to clone a life server). After setting the slave to its coordinates it starts up, catches up to the master (times behind = 0) and all is well. For an hour. Or four. Or two days. Then the slave suddenly stops executing the masters binlog. There are no errors logged. I checked the binlog and relaylog on master and slave around the last log entry processed and can't find anything strange. I'm at a total loss. I can't say that I'm an MySQL or MariaDB specialist, so I'd like to reach out to this community in order to get some idea what's happening. Anybody got an idea? Thanks in advance! Best regards Martin Trenz, Soquero GmbH, Frankfurt, Germany To view or answer this question please visit: http://mariadb.com/kb/en/replication-stops-after-one-hour-or-so/ ___ 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
[Maria-discuss] New Question: Unable to get pdo_mysql to work with CentOS 6 and MariaDB 5.5.32
Hello, A new question has been asked in "Client libraries" by Ruskicowboy: I just installed from YUM the MariaDB-server and MariaDB-client. These are the packages installed: compat-mysql55.x86_64 MariaDB-client.x86_64 MariaDB-common.x86_64 MariaDB-compat.x86_64 MariaDB-server.x86_64 MariaDB-shared.x86_64 But when trying to run a PHP script that uses PDO (which worked with MySQL 5.5), I get this error: PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/pdo_mysql.so' - /usr/lib64/php/modules/pdo_mysql.so: symbol mysql_options, version libmysqlclient_18 not defined in file libmysqlclient.so.18 with link time reference in Unknown on line 0 I have searched Google and here quite a bit but can't seem to find the answer. Any help would be greatly appreciated. To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-get-pdo_mysql-to-work-with-centos-6-and-mariadb-5532/ ___ 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
[Maria-discuss] New Question: How to install MariaDB rpms in CentOS 6.4 using rpm (not yum cmd) + handling mysql-libs conflicts
Hello, A new question has been asked in "MariaDB community" by theone: I need to script the install of MariaDB using the rpm command in CentOS 6.4. I can't use yum since it's gong to be an offline install so there's no live access to the repository. The only MySQL package installed is mysql-libs as various other packages depend on it. When I did a test install of MariaDB with yum using the command: yum install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared It correctly accounted for mysql-libs and uninstalled it at the end as MariaDB could handle the dependencies after it was installed: Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package MariaDB-client.x86_64 0:5.5.32-1 will be installed ---> Package MariaDB-common.x86_64 0:5.5.32-1 will be installed ---> Package MariaDB-compat.x86_64 0:5.5.32-1 will be obsoleting ---> Package MariaDB-devel.x86_64 0:5.5.32-1 will be installed ---> Package MariaDB-server.x86_64 0:5.5.32-1 will be installed ---> Package MariaDB-shared.x86_64 0:5.5.32-1 will be obsoleting ---> Package mysql-libs.x86_64 0:5.1.66-2.el6_3 will be obsoleted --> Finished Dependency Resolution Dependencies Resolved Package Arch Version Repository Size Installing: MariaDB-client x86_64 5.5.32-1mariadb 10 M MariaDB-common x86_64 5.5.32-1mariadb 23 k MariaDB-compat x86_64 5.5.32-1mariadb 2.7 M replacing mysql-libs.x86_64 5.1.66-2.el6_3 MariaDB-devel x86_64 5.5.32-1mariadb 5.6 M MariaDB-server x86_64 5.5.32-1mariadb 34 M MariaDB-shared x86_64 5.5.32-1mariadb 1.1 M replacing mysql-libs.x86_64 5.1.66-2.el6_3 Transaction Summary My question is, what is the equivalent way to install the MariaDB packages using the rpm command only as opposed to yum? If I do rpm -ivh MariaDB*.rpm, I will get a ton of messages like the following about conflicts with mysql-libs: file /etc/my.cnf from install of MariaDB-common-5.5.32-1.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64 file /usr/share/mysql/charsets/Index.xml from install of MariaDB-common-5.5.32-1.x86_64 conflicts with file from package mysql-libs-5.1.66-2.el6_3.x86_64 I used the --force option to install and then uninstalled mysql-libs and didn't get any weird messages but I'm not sure that is the cleanest method to handle the conflicts. So can someone confirm that installing MariaDB with the following rpm commands would be the same as using yum to install the packages and handle mysql-libs conflicts/removal: rpm -ivh --force MariaDB*.rpm rpm -e mysql-libs Thanks for any input! To view or answer this question please visit: http://mariadb.com/kb/en/how-to-install-mariadb-rpms-in-centos-64-using-rpm-not-yum-cmd-handling-mys/ ___ 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
[Maria-discuss] New Question: Optimize Aria
Hello, A new question has been asked in "Aria" by subjakt: When I want to use aria I need to configure the standard myisam variables in my my.ini or something new ? like aria_key_buffer_size or I dont know :)? I hope you understand... To view or answer this question please visit: http://mariadb.com/kb/en/optimize-aria/ ___ 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
[Maria-discuss] New Question: Migrating from MySql: MariaDB server closing client connections unexpectedly
Hello, A new question has been asked in "General FAQ" by vivek_kubaji: We in the process of migrating from MySql to MariaDB due to licensing/commercial usage reasons. We have successfully replaced the MySql connector jar with MariaDB client jar (first change) and are now trying to replace MySql server with MariaDB server without changing the data files. All our applications run perfectly for about 8-12 hours after which we see the following exception: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Cannot open connection Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144) at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326) at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:494) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:315) at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:257) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:102) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:209) at $Proxy4.getMessageCountByStatus(Unknown Source) at com.onmobile.cmfweb.monitoring.CmfMessagesMonitor.getMessageCounts(CmfMessagesMonitor.java:56) at sun.reflect.GeneratedMethodAccessor625.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:270) at com.onmobile.cmfshare.MethodInvockingBean.invoke(MethodInvockingBean.java:28) at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:212) at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:79) at org.quartz.core.JobRunShell.run(JobRunShell.java:203) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to localhost:3306: unexpected end of stream, read 0bytes from 4 at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:136) at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) at org.mariadb.jdbc.Driver.connect(Driver.java:114) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:544) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423) ... 21 more Caused by: org.mariadb.jdbc.internal.common.QueryException: Could not connect to localhost:3306: unexpected end of stream, read 0bytes from 4 at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:509) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:669) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.(MySQLProtocol.java:264) at org.mariadb.jdbc.Driver.connect(Driver.java:110) ... 28 more Caused by: java.io.EOFException: unexpected end of stream, read 0bytes from 4 at org.mariadb.jdbc.internal.common.packet.buffer.ReadUt
[Maria-discuss] New Question: OPTIMIZE my.cnf
Hello, A new question has been asked in "MariaDB FAQ" by cmejia_22: I need help for optimize my.cnf what parameters are important and the optimal values? I have a server with 8 core, 64 GB Memory, raid 10 and engine=innodb Thanks. To view or answer this question please visit: http://mariadb.com/kb/en/optimize-mycnf/ ___ 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
[Maria-discuss] New Question: How to define a role for a particular set of users
Hello, A new question has been asked in "MariaDB community" by lucky7456969: create role xxx.GM WITH ADMIN CURRENT_USER; here xxx is the schema name I get syntax error out of it. Could anyone shed some lights on this? Thanks Jack To view or answer this question please visit: http://mariadb.com/kb/en/how-to-define-a-role-for-a-particular-set-of-users/ ___ 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
[Maria-discuss] New Question: How to define a role for a particular set of users
Hello, A new question has been asked in "MariaDB community" by lucky7456969: create role xxx.GM WITH ADMIN CURRENT_USER; here xxx is the schema name I get syntax error out of it. Could anyone shed some lights on this? Thanks Jack To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-community-how-to-define-a-role-for-a-particular-set-of-users/ ___ 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
[Maria-discuss] New Question: Importing Access Database Structure
Hello, A new question has been asked in "MariaDB FAQ" by mmontoya19: Hello Everyone, I am currently conducting a study and trying to find DB software for company use. There is a current database in use that I am wondering if I can export the structure ONLY into MariaDB. Meaning I want to be able to duplicate the Tables, Relationship, Queries, and if possible reports. Is it possible to do this? To view or answer this question please visit: http://mariadb.com/kb/en/importing-access-database-structure/ ___ 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
[Maria-discuss] New Question: ¿can I run MariaDB from a live-dvd?
Hello, A new question has been asked in "General FAQ" by juanito1969: Hello there. Greetings from México. I hope you can help me with the next case: I am using a knoppix's live-dvd. My pc has an independent logical-partition used for programs and data storage. I download and unzip and decompress the tarball and put it into the "storage partition". But I don't know how to startup and use MariaDB from the live-dvd and the info. "prepared" in the logical-partition. What do I need to do for use MariaDb that way? Thank you in advance for your help Juan Antonio Vargas. To view or answer this question please visit: http://mariadb.com/kb/en/can-i-run-mariadb-from-a-live-dvd/ ___ 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
[Maria-discuss] New Question: Java 1.5 and MariaDB connector
Hello, A new question has been asked in "General FAQ" by yalingfan: Hi, MariaDB 1.1.5 client requires JDK1.6. I have a need for MariaDB client to support JRE1.5 MySQL connector/J supports both JDK1.5 and JDK1.6 Can you support JDK1.5? To view or answer this question please visit: http://mariadb.com/kb/en/java-15-and-mariadb-connector/ ___ 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
[Maria-discuss] New Question: yum Install on x86_64 CentOS 5.x
Hello, A new question has been asked in "MariaDB community" by flumpydog: I am attempting to install MariaDB on a x86_64 server running CentOS 5.9. I followed the instructions for "Installing MariaDB with yum", created the MariaDB.repo file, however when I run yum, it wants to install i386 rpm files and not x86_64. I even attempted to modify the MariaDB.repo file and use baseurl = http://yum.mariadb.org/5.5/centos5-amd64 , however this did not work. What can I do to correct this as I would like to do this all with yum. Thanks, Chuck To view or answer this question please visit: http://mariadb.com/kb/en/yum-install-on-x86_64-centos-5x/ ___ 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
[Maria-discuss] New Question: Migrating from MySQL 5.1.31-community >> MariaDB 5.5
Hello, A new question has been asked in "Upgrading MariaDB" by flumpydog: One of our internal development db servers is currently running MySQL 5.1.31-community on CentOS 5.9 as it suits are needs internally for testing only purposes of our sites. I would like to use this box to install and test MariaDB 5.5 on. What would be the best method to make this transition as smooth as possible? The MySQL rpm's are not the ones supplied by CentOS, but are from the MySQL site. Should I do a dump of all the databases on MySQL, remove all the MySQL rpm packages, install MariaDB 5.5 via yum and then do an import of the databases? Or will I have to install a prior release of MariaDB and upgrade from there? Also, all the tables are currently using the MyISAM storage engine. Just so I will have the best experience here and while I am experimenting, what storage engine would you recommend we try, Ari or? Some of these tables contain in excess of a million rows. Is there anything I should be aware of before converting tables? Thanks, Chuck To view or answer this question please visit: http://mariadb.com/kb/en/migrating-from-mysql-5131-community-mariadb-55/ ___ 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
[Maria-discuss] New Question: regarding seconds behind master variable in 10.0.4
Hello, A new question has been asked in "MariaDB Documentation" by jaihind213: hi we setup maria 10.0.4 for multisource replication. it was replicating from a percona 5.5 master. When we started replication, maria was a day behind its master. its working fine but we noticed this phenomenon: when we execute 'show all slaves status' consecutively the 'seconds_behind_master' flips from 0 to XXX and XXX to 0. XXX keeps decreasing though, which is good as its getting closer to the state of its master. But wanted to know why the 'seconds_behind_master' comes down to 0 then again sets to a positive number. Note: XXX is some positive number. Thanking you. vishnu rao To view or answer this question please visit: http://mariadb.com/kb/en/regarding-seconds-behind-master-variable-in-1004/ ___ 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
[Maria-discuss] New Question: I want to install mariadb5.5.33(with tokudb plugin) without 'apt-get install'
Hello, A new question has been asked in "MariaDB FAQ" by frances714: I want to install mariadb5.5.33(with tokudb plugin) without 'apt-get install' on debain 6 squeeze(i686), but there is only mariadb5.5.30(with tokudb plugin) for x86_64 on tokudb.org. So is there any method to install the mariadb(with tokudb plugin) on my computer? Thank you so much! To view or answer this question please visit: http://mariadb.com/kb/en/i-want-to-install-mariadb5533with-tokudb-plugin-without-apt-get-install/ ___ 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
[Maria-discuss] New Question: Galera Cluster starting backup can't find innobackupex in the path
Hello, A new question has been asked in "Galera" by tubaguy50035: I am trying to get a Galera cluster running. I have the first node up and ready for connections. My second node, however, when trying to run wsrep_sst_xtrabackup gets the error "Can't find innobackupex in the path". As soon as I start the mysql service on the second node, I briefly see it as an incoming address on the first node, but then it goes away. Not sure what would be necessary to help me with this, so here's my whole wsrep specific section of my my.cnf: <> binlog_format=ROW default_storage_engine=innodb innodb_autoinc_lock_mode=2 innodb_locks_unsafe_for_binlog=1 innodb_doublewrite=1 wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_provider_options="gcache.size=256M; gcache.page_size=128M" wsrep_cluster_address=gcomm://firstnode wsrep_cluster_name="Cluster" wsrep_node_address="thisnode" wsrep_node_name="thisnode" wsrep_sst_method=xtrabackup wsrep_sst_auth="root:password" wsrep_node_incoming_address=this node's IP wsrep_sst_receive_address=this node's IP wsrep_slave_threads=16 <> To view or answer this question please visit: http://mariadb.com/kb/en/galera-cluster-starting-backup-cant-find-innobackupex-in-the-path/ ___ 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
[Maria-discuss] New Question: new stable release for MariaDB Client Library for "C"
Hello, A new question has been asked in "MariaDB Client Library for C" by gghervase: Hello, Can you please tell me if a new stable release for the mariadb native client will be done anytime soon? There are several bug fixes on trunk and I wonder when will they be released. For example, I can't ssl authenticate to the maridb 5.5.33 with the currently released client (Bad Handshake - response error 1043 from the server), but it works with your lastest code from trunk. Thank you very much. Best regards, Gabriel Ghervase To view or answer this question please visit: http://mariadb.com/kb/en/new-stable-release-for-mariadb-client-library-for-c/ ___ 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
[Maria-discuss] New Question: Using Connect with MySQL 5.5
Hello, A new question has been asked in "Connect" by shlomisut: Hi We're currently testing usage of MySQL Federated engine, used for read-only cached tables. The Connect engine looks like a very interesting option as it will allow us to use the index/condition push down, thus reducing the amount of network & total query time. Do you have any experience with using Connect as a MySQL engine? migrating to MariaDB is not possible at current time frames, though it is on our roadmap Thanks! Shlomi To view or answer this question please visit: http://mariadb.com/kb/en/using-connect-with-mysql-55/ ___ 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
[Maria-discuss] New Question: understanding Unkwnon error when connection is aborted
Hello, A new question has been asked in "MariaDB FAQ" by jaihind213: [Warning] Aborted connection 290 to db: 'test_db' user: 'dev' host: 'host.stage.com' (Unknown error) We have been getting this error in the logs. would like to know when this happens. thanks To view or answer this question please visit: http://mariadb.com/kb/en/understanding-unkwnon-error-when-connection-is-aborted/ ___ 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
[Maria-discuss] New Question: MariaDB Partitioning and Stored Procedure Support
Hello, A new question has been asked in "MariaDB FAQ" by htaylor: Does MariaDB support the use of stored procedures with partitioning of tables. To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-partitioning-and-stored-procedure-support/ ___ 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
[Maria-discuss] New Question: mysql_secure_installation does not work with socket locations other than /tmp/mysql.sock
Hello, A new question has been asked in "MariaDB community" by openiduser32: The only information I could find on this is a MySQL bug report dating back to 2009: http://bugs.mysql.com/bug.php?id=46842 I've tried passing the basedir to mysql_secure_installation as well as --defaults-file and --socket but it refuses to look anywhere but /tmp/mysql.sock. I'm running MariaDB in userland and except for this script everything is working fine. My socket file is in ~/mariadb/mysql/run/mysql.sock. Mediawiki has no problem connecting to it using localhost when it's set as the default socket in php.ini. I have network connections disabled in my.cnf to only allowed Unix socket connections. I've tried to fix it myself but I've exhausted my command line scripting knowledge. Can someone please help me get this script working again? To view or answer this question please visit: http://mariadb.com/kb/en/mysql_secure_installation-does-not-work-with-socket-locations-other-than-tm/ ___ 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
[Maria-discuss] New Question: XtraDB and ODBC compatibility?
Hello, A new question has been asked in "XtraDB and InnoDB" by ferreirah: Hi How compatible is XtraDB with the myodbc driver? Any issues that you know about? Thanks H.F. To view or answer this question please visit: http://mariadb.com/kb/en/xtradb-and-odbc-compatibility/ ___ 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
[Maria-discuss] New Question: XtraDB and Workbench CE compatibility?
Hello, A new question has been asked in "XtraDB and InnoDB" by ferreirah: Hi I read here that there are some issues with Aria and Workbench? Are there any issues with XtraDB and Workbench CE? People have mentioned HeidiSQL but can it do diagrams of your table structure? Will HeidiSQL work with XtraDB? Any other free for commercial use, alternatives? Thanks H.F. To view or answer this question please visit: http://mariadb.com/kb/en/xtradb-and-workbench-ce-compatibility/ ___ 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
[Maria-discuss] New Question: Client for Mysql - zeroDateTimeBehavior=convertToNull key
Hello, A new question has been asked in "MariaDB Java Client" by netanel: Hi, Does it possible to use the "zeroDateTimeBehavior=convertToNull" to the jdbc url connection string like in the original mysql driver? Is there a workaround? Netanel To view or answer this question please visit: http://mariadb.com/kb/en/client-for-mysql-zerodatetimebehaviorconverttonull-key/ ___ 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
[Maria-discuss] New Question: licencing of mariadb and mysql dot net connector
Hello, A new question has been asked in "Client libraries" by ferreirah: Hi I agree with one of the previous posts that licencing is such a tricky aspect of IT. I read in previous posts that when using mariadb with the odbc framework that you can distribute both the odbc connector and mariadb with your closed source commercial application. It said in the post if you use a framework to access the database then both the connector and mariadb are free for commercial use. What about dot net? Dot net is a framework through which you can access mariadb? Does this mean that both the dot net connector as well as mariadb are free for closed source commercial use? I suppose the downside is that you can't use any mariadb specific features if you are using the mysql connector? Thanks H.F. To view or answer this question please visit: http://mariadb.com/kb/en/licencing-of-mariadb-and-mysql-dot-net-connector/ ___ 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
[Maria-discuss] New Question: mariadb RAM usage
Hello, A new question has been asked in "MariaDB Performance & Advanced Configurations" by ferreirah: When you bundle your app with mysql or mariadb, you don't want mysql or mariadb to devour all your RAM, especially if the database is installed on a desktop operating system. I haven't recently tried out mysql or mariadb, but I was wondering about the minimum memory required on windows. I sent a question to mysql and they told me it only requires 1 MB RAM minimum. At that stage they still supported windows 2000 and windows xp, which isn't supported any more. I remember installing mysql on windows xp and you could configure it through a wizard. You could either set it to dedicated server, shared server or developer install. I suppose developer install will use the least amount of RAM. How much RAM would mariadb use with a developer install if you had to install it on windows vista/7/8/8.1? Does it matter which engine you are using? XtraDB? Thanks H.F. To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-ram-usage/ ___ 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
[Maria-discuss] New Question: SphinxSE gone from MariaDB 10.0.6?
Hello, A new question has been asked in "Development" by robertmedeksza: I recently ran apt-get upgrade and this updated my MariaDB 10.0.4 to 10.0.6. After the update the SphinxSE engine is gone and my Sphinx tables no longer function. How can I get SphinxSE back and can this be fixed in 10.0.7? To view or answer this question please visit: http://mariadb.com/kb/en/sphinxse-gone-from-mariadb-1006/ ___ 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
[Maria-discuss] New Question: Link MariaDB Client Library for C with specific external zlib and openssl
Hello, A new question has been asked in "MariaDB Client Library for C" by trsystran: Hi, I am trying to link the mariadb client library with zlib and openssl which are neither embedded in mariadb (for zlib), nor the one available on the system: I want to force cmake to use zlib and openssl from a given path. How can I do that? Is there another way than creating my own FindZLIB.cmake and force it via CMAKE_MODULE_PATH ? Thank you. To view or answer this question please visit: http://mariadb.com/kb/en/link-mariadb-client-library-for-c-with-specific-external-zlib-and-openssl/ ___ 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
[Maria-discuss] New Question: Build fails at "Linking CXX executable tdb-recover"
Hello,
A new question has been asked in "Compiling MariaDB From Source" by
openiduser33:
I'm trying to compile MariaDB on Ubuntu 13.10. I've followed all the directions
here on the KB in regards to compiling. I meet all the package requirements
listed.
This is the output where make fails:
Linking CXX executable tdb-recover
cd
/home/chris/web/servers/mariadb/src/mariadb-5.5.34/storage/tokudb/ft-index/ft
&& /usr/bin/cmake -E cmake_link_script CMakeFiles/tdb-recover.dir/link.txt
--verbose=1
/usr/bin/c++ -std=c++11 -Wall -Werror -Wcast-align -Wshadow
-Wmissing-format-attribute -Wpointer-arith -Wmissing-declarations
-Wno-missing-noreturn -Wextra -Wno-error=strict-overflow -Wpacked
-fno-exceptions -fno-rtti -Wno-error=missing-format-attribute
-Wmissing-format-attribute -Wlogical-op -Wtrampolines -Wswitch -Winit-self
-Wstrict-null-sentinel -Wno-missing-field-initializers -Wall
-Wno-unused-parameter -fno-implicit-templates -fno-exceptions -fno-rtti
-fimplicit-templates -flto -fuse-linker-plugin -O2 -g -DNDEBUG -DDBUG_OFF -g
-O3 -UNDEBUG -g -fuse-linker-plugin -Wno-error=strict-overflow
CMakeFiles/tdb-recover.dir/tdb-recover.cc.o -o tdb-recover -lpthread
libft_static.a ../util/libutil_static.a ../../../../zlib/libzlib.a
.././xz/lib/liblzma.a ../portability/libtokuportability_static.a -lpthread -ldl
-lrt
/home/chris/web/servers/mariadb/src/mariadb-5.5.34/storage/tokudb/ft-index/ft/ft-ops.cc:
In function ‘ft_leaf_run_gc’:
/home/chris/web/servers/mariadb/src/mariadb-5.5.34/storage/tokudb/ft-index/ft/ft-ops.cc:2261:26:
error: ‘leaf_entry’ may be used uninitialized in this function
[-Werror=maybe-uninitialized]
if (leaf_entry->type != LE_MVCC) {
^
lto1: all warnings being treated as errors
lto-wrapper: /usr/bin/g++-4.8.real returned 1 exit status
/usr/bin/ld.bfd.real: lto-wrapper failed
collect2: error: ld returned 1 exit status
Pastebin for easier reading: http://pastebin.com/wGzHpD2p
I'm using the default compile option list posted here:
https://mariadb.com/kb/en/generic-build-instructions/
The only thing I've changed is the prefix.
To view or answer this question please visit:
http://mariadb.com/kb/en/build-fails-at-linking-cxx-executable-tdb-recover/
___
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
[Maria-discuss] New Question: Mariadb refuses to stay confined to install directory
Hello, A new question has been asked in "Compiling MariaDB From Source" by openiduser33: I've been struggling with this off and on for weeks. I need a contained MariaDB install running in the home directory. My most recent attempt (and what would be my preferred method) is compiling from source. No matter what I do though MariaDB insists on trying to create /var/run/mysqld/mysqld.sock on every run and fails. I compiled it from source with --prefix pointing to my home directory. I ran mysql with --basedir and --defaults-file. The defaults-file I used contains the location of my mysql.sock file in the home directory but MariaDB will not use it. I even tried recompiling with --exec-prefix as per the MySQL 5.5 documentation but this screws the entire installation up, causing MariaDB to recreate the entire prefix path from root underneath src/efix=/ where I'm storing the source while I install. Here is my configure options: ##./configure --prefix=/home/user/web/servers/mariadb --enable-assembler \ --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables \ --with-plugin-maria --with-aria-tmp-tables --without-plugin-innodb_plugin --without-plugin=tokudb \ --with-mysqld-ldflags=-static --with-client-ldflags=-static --with-readline \ --with-ssl --with-plugins=max-no-ndb --with-embedded-server --with-libevent \ --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static \ --with-zlib-dir=bundled --enable-local-infile## And here is what happens when I try to launch MariaDB: ##$ bin/mysqld_safe --basedir=/home/user/web/servers/mariadb --defaults-file=/home/user/web/servers/mariadb/my.cnf 131128 16:20:20 mysqld_safe Logging to '/home/user/web/servers/mariadb/log/error.log'. mkdir: cannot create directory ‘/var/run/mysqld’: Permission denied Fatal error Can't create database directory '/var/run/mysqld/mysqld.sock'## My socket file is specific in the given my.cnf file as /home/user/web/servers/mariadb/run/mysql.sock No matter what I do I can't get MariaDB to behave and run in user land. What am I doing wrong? I've tried the Linux binaries with slightly more success but I still felt like I was fighting the server to get it to read files from the correct location. I'd like to have it compiled from source though and it *should* be easier this way since I can specify a prefix. How can I get MariaDB to follow the set prefix for all files? To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-refuses-to-stay-confined-to-install-directory/ ___ 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
[Maria-discuss] New Question: CMAKE settings to include TokuDB in 5.5.34
Hello, A new question has been asked in "TokuDB" by markdiener: I am trying to build 5.5.34 from source on Linux x64 (Fedora 14). I was looking at the readme files and could not find anything about building 5.5.34 from source and including TokuDB (which has the source code in the /storage/TokuDB/ directory) into the build. I was looking for something like: -DWITH_TOKUDB_STORAGE_ENGINE=ON but did not stumble across anything. Anybody got some ideas? Here is my build script: rm -f CMakeCache.txt make clean cmake \ -DCMAKE_BUILD_TYPE=Release \ -DCMAKE_INSTALL_PREFIX=/mysql \ -DENABLED_PROFILING=OFF \ -DENABLE_DEBUG_SYNC=ON \ -DENABLE_GCOV=OFF \ -DINSTALL_LAYOUT=STANDALONE \ -DMYSQL_DATADIR=/mysql/data \ -DINSTALL_INCLUDEDIR=include/mysql \ -DINSTALL_UNIX_ADDRDIR=/mysql/mysql.sock \ -DUSE_ARIA_FOR_TMP_TABLES=ON \ -DWITHOUT_PBXT_STORAGE_ENGINE=ON \ -DWITHOUT_SERVER=OFF \ -DWITH_ARCHIVE_STORAGE_ENGINE=OFF \ -DWITH_EMBEDDED_SERVER=OFF \ -DWITH_FAST_MUTEXES=OFF \ -DWITH_FEDERATEDX_STORAGE_ENGINE=OFF \ -DWITH_FEEDBACK=OFF \ -DWITH_LIBWRAP=OFF \ -DWITH_PIC=ON \ -DWITH_PARTITION_STORAGE_ENGINE=OFF \ -DWITH_PERFSCHEMA_STORAGE_ENGINE=ON \ -DWITH_SPHINX_STORAGE_ENGINE=OFF \ -DWITH_SSL=OFF \ -DWITH_UNIT_TESTS=OFF \ -DWITH_VALGRIND=OFF \ -DWITH_XTRADB_STORAGE_ENGINE=ON \ -DWITHOUT_OQGRAPH=ON \ -DWITH_ZLIB=bundled make (now compiling your program) To view or answer this question please visit: http://mariadb.com/kb/en/cmake-settings-to-include-tokudb-in-5534/ ___ 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
[Maria-discuss] New Question: mariadb run failed on Centos 6.4
Hello, A new question has been asked in "MariaDB community" by kimbg: my server installed centos 6.4(32bit) i'll source compile maria db 5.1.67/5.5.34 and yum install. but, i looking error message mysql_install_db. how fixed? maria source version : 5.1.67/5.1.62 5.5.34 (https://downloads.mariadb.org/interstitial/mariadb-5.1.67/kvm-tarbake-jaunty-x86/mariadb-5.1.67.tar.gz/from/http://mariadb.biz.net.id/) compile option [root@localhost var]# ./configure --prefix=/usr/local/mysql --with-extra-charsets=all --with-readline mysql_install_db command [root@localhost ~]# /usr/local/mysql/bin/mysql_install_db Installing MariaDB/MySQL system tables... 131209 11:07:26 [ERROR] /usr/local/mysql/libexec/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 131209 11:07:26 [ERROR] Aborting Installation of system tables failed! Examine the logs in /usr/local/mysql/var for more information. You can try to start the mysqld daemon with: shell> /usr/local/mysql/libexec/mysqld --skip-grant & and use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql/bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --general-log gives you a log in /usr/local/mysql/var that may be helpful. The latest information about mysql_install_db is available at http://kb.askmonty.org/v/installing-system-tables-mysql_install_db. MariaDB is hosted on launchpad; You can find the latest source and email lists at http://launchpad.net/maria Please check all of the above before mailing us! And remember, if you do mail us, you should use the /usr/local/mysql/bin/mysqlbug script! [root@localhost ~]# /usr/local/mysql/libexec/mysqld --skip-grant & [1] 1402 [root@localhost ~]# 131209 11:20:11 [ERROR] /usr/local/mysql/libexec/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 131209 11:20:11 [ERROR] Aborting [1]+ Exit 1 /usr/local/mysql/libexec/mysqld --skip-grant [root@localhost ~]# cat /usr/local/mysql/var/localhost.localdomain.err 131209 11:08:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var 131209 11:08:40 [ERROR] /usr/local/mysql/libexec/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 131209 11:08:40 [ERROR] Aborting 131209 11:08:40 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended [root@localhost ~]# To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-run-failed-on-centos-64/ ___ 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
[Maria-discuss] New Question: Simple cluster two nodes, error.
Hello,
A new question has been asked in "MariaDB FAQ" by maximilianodipietro:
Hi people, i have a two nodes cluster of MariaDb, and i need some help, i have
this simple script to do a solve failover, the script works like this: if the
master node dies, the script kills the slave and restart it as master, and then
the master as slave when the script detects that the process is down, here's
the code:
--
#!/bin/bash
if [ $1 = "start" ]
then
PidMaria=$(ps -ef | grep wsrep_cluster | grep -v grep | awk {'print $2'})
Server2=$(nmap -v ipnodo2 | grep 3306 | tail -n1 | awk {'print $2'})
TipoPid=$(ssh ipnodo2 "ps -ef |grep mysql | grep -v grep | cut -d "=" -f 2 |
cut -d "/" -f 3 | cut -d "-" -f 1 | cut -d "." -f 1")
TipoPidLocal=$(ps -ef |grep mysql | grep -v grep | cut -d "=" -f 2 | cut -d "/"
-f 3 | cut -d "-" -f 1 | cut -d "." -f 1)
if [ -z $PidMaria ]
then
#sleep 20
Server2=$(nmap -v ipnodo2 | grep 3306 | tail -n1 | awk {'print $2'})
if [ -z $Server2 ]
then
if [ -z $TipoPid ]
then
if [ -z $(ssh ipnodo2 "ps -ef |grep mysql |
grep -v grep " | awk {'print $2'}) ]
then
/usr/sbin/mysqld --wsrep_cluster_address=gcomm://
--user=mysql --wsrep_sst_auth=root:root
--wsrep_provider=/usr/lib64/galera/libgalera_smm.so
fi
else
/usr/sbin/mysqld
--wsrep_cluster_address=gcomm://ipnodo2 --wsrep_sst_auth=root:root --user=mysql
--wsrep_provider=/usr/lib64/galera/libgalera_smm.so
fi
else
if [ -z $TipoPid ]
then
/usr/sbin/mysqld --wsrep_cluster_address=gcomm://ipnodo2 --user=mysql
--wsrep_sst_auth=root:root --wsrep_provider=/usr/lib64/galera/libgalera_smm.so
fi
fi
else
if [ -z $Server2 ]
then
if [ -z $TipoPidLocal ]
then
echo "hola"
else
kill -9 $PidMaria
/usr/sbin/mysqld --wsrep_cluster_address=gcomm://
--wsrep_sst_auth=root:root --user=mysql
--wsrep_provider=/usr/lib64/galera/libgalera_smm.so
fi
else
if [ -z $PidMaria ]
then
/usr/sbin/mysqld --wsrep_cluster_address=gcomm://ipnodo2
--user=mysql --wsrep_sst_auth=root:root
--wsrep_provider=/usr/lib64/galera/libgalera_smm.so
fi
fi
fi
fi
This is the error i get in the slave output when i run the script by hand.
---
+ /usr/sbin/mysqld --wsrep_cluster_address=gcomm://IPMASTER --user=mysql
--wsrep_sst_auth=root:root --wsrep_provider=/usr/lib64/galera/libgalera_smm.so
131211 20:04:35 [Note] WSREP: Read nil XID from storage engines, skipping
position init
131211 20:04:35 [Note] WSREP: wsrep_load(): loading provider library
'/usr/lib64/galera/libgalera_smm.so'
131211 20:04:35 [Note] WSREP: wsrep_load(): Galera 23.2.7(r157) by Codership Oy
loaded succesfully.
131211 20:04:35 [Note] WSREP: Found saved state:
1503cc31-6281-11e3-abfc-5bf96ca010d8:-1
131211 20:04:35 [Note] WSREP: Reusing existing '/var/lib/mysql//galera.cache'.
131211 20:04:35 [Note] WSREP: Passing config to GCS: base_host = IPLOCALHOST;
base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/lib/mysql/;
gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name =
/var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M;
gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave =
NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit
= 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO;
replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
131211 20:04:35 [Note] WSREP: Assign initial position for certification: -1,
protocol version: -1
131211 20:04:35 [Note] WSREP: wsrep_sst_grab()
131211 20:04:35 [Note] WSREP: Start replication
131211 20:04:35 [Note] WSREP: Setting initial position to
----:-1
131211 20:04:35 [Note] WSREP: protonet asio version 0
131211 20:04:35 [Note] WSREP: backend: asio
131211 20:04:35 [Note] WSREP: GMCast version 0
131211 20:04:35 [Note] WSREP: (74e621f3-629f-11e3-a86f-0adb496b3ff6,
'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
131211 20:04:35 [Note] WSREP: (74e621f3-629f-11e3-a86f-0adb496b3ff6,
'tcp://0.0.0.0:4567') multicast: , ttl: 1
131211 20:04:35 [Note] WSREP: EVS version 0
1312
[Maria-discuss] New Question: MySQL 5.6 function
Hello, A new question has been asked in "Miscellaneous Functions" by ymhuang0808: Hello! My MariaDB version is 10.0.6. I found it dosen't support some MySQL 5.6 functions, like INET6_ATON(), INET6_NTOA(), IS_IPV4(), etc. Hope new version MaraiDB support those functions. Thank you. To view or answer this question please visit: http://mariadb.com/kb/en/mysql-56-function/ ___ 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
[Maria-discuss] New Question: Debug files not written by client lib
Hello,
A new question has been asked in "MariaDB Client Library for C" by sruliganor:
Hi, I have a C program that uses mariadbclient.lib.
I added this line to generatate a trace file from the lib:
mysql_debug("d:t:O,e:\\Temp\\MysqlClient.log");
In addition I set environmant variable MYSQL_DEBUG.
However, no debug file was created anywhere.
What should I do to see trace files?
I tried the client lib 1.0 binary downloaded fron your site, as well as the
source code complied in DEBUG.
Thanks
To view or answer this question please visit:
http://mariadb.com/kb/en/debug-files-not-written-by-client-lib/
___
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
[Maria-discuss] New Question: MariaDB Galera Cluster Questions
Hello, A new question has been asked in "MariaDB FAQ" by pranava: I have some questions on Maria DB Galera Cluster. Q1) If I partition a table in a schema which is part of MariaDB Galera Cluster, can i configure partitions in such a way that a one partition resides in one Node, another partition resides in second Node and so on? I'm trying to shard the data and use Galera cluster nodes to accommodate parts of that shard. Q2) Scenario - During replication of MariaDB Galera Cluster, the Master node gets a request, it processes it and then sends to other nodes for approval, followed by a commit at every node. What if commit happens on majority of nodes except one or two? What happens to that transaction and how about Data consistency among all nodes? Q3) Which protocol is used for communicating between nodes during data replication in MariaDB Galera Cluster? Is it TCP or a Broadcast to all other nodes or Some customized protocol between nodes that enables replication in the cluster. Thanks a lot in advance. Thanks Pranav. To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-galera-cluster-questions/ ___ 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
[Maria-discuss] New Question: Asynchronous Replication with Galera Cluster ?
Hello, A new question has been asked in "Galera" by nicolasblanc: My question is simple. Today i have a Galera Cluster with 3 nodes to write/read. And i want to put one(more to come) slave (asynchronous replication) to the cluster. As all my writes are located on 1 node, it's ok. But if i change the node on which the writes come... My slave is not synchronized anymore. I had to change the master of the slave to have the new written node as master. It seems that each galera node write only transactions from "real client" to replication binary log, not the ones from wsrep. Is there a way that i can ask to a Galera cluster node to always write commited transaction on the replication binary log ? Even if the transaction come from wsrep and not "real client" ? Thx in advance, -- Nicolas Blanc. To view or answer this question please visit: http://mariadb.com/kb/en/asynchronous-replication-with-galera-cluster/ ___ 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
[Maria-discuss] New Question: Stable release of 10.0
Hello, A new question has been asked in "What is in the different MariaDB releases?" by pranava: Hi, In which month there will be a stable release of 10.0? We are using 5.5.34 and want to upgrade to 10.0 but are waiting for a stable release. Thanks Pranav. To view or answer this question please visit: http://mariadb.com/kb/en/stable-release-of-100/ ___ 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
[Maria-discuss] New Question: Maximum number of columns
Hello, A new question has been asked in "MariaDB FAQ" by robpaton: Hi there, What is the maximum number of columns a row can have in MariaDB? I can't find this info anywhere on the web. Best regards, Rob To view or answer this question please visit: http://mariadb.com/kb/en/maximum-number-of-columns/ ___ 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
[Maria-discuss] New Question: CONNECT engine windows
Hello, A new question has been asked in "CONNECT Table Types" by jpser2: with mariadb 10.07 installed on windows, how to setup engines, particulary CONNECT engine We do appreciate your effort to produce an efficient product with many engines capabilities, But in your web site communication , it is not obvious that all the soultions exposed ( in particular, ENGINES) are effective, anf it they are : on what OS can they be installed. Thanks for answer To view or answer this question please visit: http://mariadb.com/kb/en/connect-engine-windows/ ___ 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
[Maria-discuss] New Question: What should I know if I am moving database from Oracle to MiriaDB?
Hello, A new question has been asked in "Does MariaDB support..." by jimwu: Hi, I am trying to find what difficulty would I meet if I move database from Oracle to MariaDB? Are there similar functions in MariaDB like functions in Oracle, like material view or snapshot? Best Regards, Jim Wu To view or answer this question please visit: http://mariadb.com/kb/en/what-should-i-know-if-i-am-moving-database-from-oracle-to-miriadb/ ___ 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
[Maria-discuss] New Question: I am trying to find the latest MariaDB equivelent of the MySQL reference manual
Hello, A new question has been asked in "MariaDB FAQ" by robsilver: For example I am trying to determine regarding using implicit and or explicit Locking e.g Issolation Levels , Locking , transactions processing via [FOR UPDATE | LOCK IN SHARE MODE] I have not found a lot out there but if there is an equivalent PDF file that would be great. I currently have the book: MariaDB Crash Course which I can not find one reference to LOCK IN SHARE MODE or FOR UPDATE. To view or answer this question please visit: http://mariadb.com/kb/en/i-am-trying-to-find-the-latest-mariadb-equivelent-of-the-mysql-reference-ma/ ___ 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
[Maria-discuss] New Question: What version do I need and how to install
Hello, A new question has been asked in "Getting Started" by rjtuijnman: I've installed a virtual OpenSuse server. I want to insdtall the latest stable version of MariaDB. What install version do I need and where can I find documentation for installing. I'm an absolute no-know ons Linux... To view or answer this question please visit: http://mariadb.com/kb/en/what-version-do-i-need-and-how-to-install/ ___ 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
[Maria-discuss] New Question: ARCHIVE equivalent
Hello, A new question has been asked in "MariaDB FAQ" by dumdummare: What options are there to have a log table that is difficult to change but quick to search using criterias even during inserts? Something like an ARCHIVE with indicies or an InnoDB without UPDATE or DELETE. To view or answer this question please visit: http://mariadb.com/kb/en/archive-equivalent/ ___ 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
[Maria-discuss] New Question: Data limit on joins with connect tables?
Hello, A new question has been asked in "Connect" by benkendrick: I am attempting run a query against two tables in a remote database with an inner join. These tables reside in a Progress Database. I have used the CONNECT engine via the ODBC connection that I have set up. The first query had 24 columns returned by the query, I got 930 rows as a result. If I reduce the number of columns that I select, the number of rows returned by the database goes up. Even with only two rows select, I only get about 12,000 rows. The total result should be 14,149 rows. I have used the same ODBC connection with LibreOffice Base and received the full number of rows. If I query each table individually, I get the full number of rows (The tables have a 1 to 1 relationship with the current data). I am using MariaDB 10.0.8 32-bit on Windows 7 querying a remote Progress Database. Is there some sort of data limit? I have noticed that the total number of data points (rows multiplied by columns) is between 20,000 and 24,000. To view or answer this question please visit: http://mariadb.com/kb/en/data-limit-on-joins-with-connect-tables/ ___ 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
[Maria-discuss] New Question: Unknown option 'table_data' OQGraph in MariaDB 10.0.7
Hello, A new question has been asked in "OQGRAPH" by prestonthayne: I am trying to evaluate MariaDB and OQGraph and am having difficulty creating the tables. I follow the examples exactly as on the site. I create the backing table, I insert some data into the backing table, I attempt to create the graph table and I get an error that the option 'table_data' is unknown. I am using MariaDB 10.0.7 on CentOS 6.5. Any advice would be greatly appreciated. Preston To view or answer this question please visit: http://mariadb.com/kb/en/unknown-option-table_data-oqgraph-in-mariadb-1007/ ___ 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
[Maria-discuss] New Question: How do I keep the graph table and data table in sync?
Hello, A new question has been asked in "OQGRAPH" by prestonthayne: So I added some rows to the data table before I created the graph table that then showed up just fine. I then added some more rows to the data table and did a select * on the graph table and the new rows weren't there. I did a shortest route query and they showed up. A subsequent select * query to the graph table and they were there. What triggered them to appear? I then added a few more and no matter what I do they won't show up. The last one that won't show up was a two way link ( insert into oq_backing (origid,destid) values (9,10),(10,9) ). That's not a problem is it? And lastly, is there any good documentation/literature around for how oqgraph works and how to use it? Thanks, Preston To view or answer this question please visit: http://mariadb.com/kb/en/how-do-i-keep-the-graph-table-and-data-table-in-sync/ ___ 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
[Maria-discuss] New Question: Maria DB - changing hosting with a different DB
Hello, A new question has been asked in "MariaDB community" by hannasles: Hi Guys! I am moving my web-site from one hosting to another. The DB on the first hosting is MariaDB, DB on the hosting I am moving to is MyIsam. When importing the DB, I am getting this message: ERROR 1064 (42000) at line 19: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PAGE_CHECKSUM=1' at line 6 Line 19 runs: CREATE TABLE `wp_blc_filters` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `params` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=Aria DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1; As I am not good at all with DB and my hosting supports can not answer my enquiries, I have to open this question here. I will really appreciate that if you could help me with this! To view or answer this question please visit: http://mariadb.com/kb/en/maria-db-changing-hosting-with-a-different-db/ ___ 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
[Maria-discuss] New Question: Downloaded; how do I install?
Hello, A new question has been asked in "MariaDB Documentation" by jeffreythomas: I've downloaded MariaDB; how do I install it? Thanks, Jeff To view or answer this question please visit: http://mariadb.com/kb/en/downloaded-how-do-i-install/ ___ 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
[Maria-discuss] New Question: mariaDB for arm
Hello, A new question has been asked in "MariaDB community" by mikestorcheous: А не подскажите репозиторий для debian 7 armhf? To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-for-arm/ ___ 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
[Maria-discuss] New Question: V5.5.36 will only use default data directory
Hello, A new question has been asked in "MariaDB community" by mdavies5: I installed v5.5.36 on a new Mint16 installation and it started ok. I then modified my.cnf to point to an existing data directory. I made sure that all folders and files were owned by mysql user and the mysql group had permissions to read/write. I also deleted existing files ib_logfile0/1, ibdata1 and aria_log_control as I know these must be recreated. When restarting MariaDb I get: Can't create/write to file '/home/michael/mysql/aria_log_control' (Errcode: 13). Files ib_logfile0 & 1 and ibdata1 were created ok so it is not a permissions problems. Why does only aria_log_control fail to create. If I copy all this data to default /var/lib/mysql and reset my.cnf then they work fine To view or answer this question please visit: http://mariadb.com/kb/en/v5536-will-only-use-default-data-directory/ ___ 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
[Maria-discuss] New Question: unable to START MySQL server at BOOT "systemctl enable mysqld.service" does not work
Hello, A new question has been asked in "MariaDB community" by asifcyberdome: unable to START MySQL server at BOOT "systemctl enable mysqld.service" does not work I am running FEDORA 20 and I have MySQL installed or the replacement MariaDB. same difference. I am able to do everything correcty. Everything works, except when I run the command: "systemctl enable mysqld.service", It gives me error "failed to issue method call: no such file or directory." Is this a known issue? Is this a known BUG? Is there a way to fix this? I am running Fedora 20 MySQL/MariaDB 5.5 version. Any help is greatly appreciated To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-start-mysql-server-at-boot-systemctl-enable-mysqldservice-does-no/ ___ 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
[Maria-discuss] New Question: creating pivot table fails
Hello, A new question has been asked in "CONNECT Table Types" by nobswolf: I tried to create a pivot table based on an existing table "test1" and get an error. I am logged in and I can use "test1", so this error makes no sense to me. What I am doing wrong? Any hints? MariaDB [nav]> create table xsort engine=connect table_type=pivot tabname=test1; ERROR 1105 (HY000): (1045) Access denied for user 'root'@'localhost' (using password: NO) MariaDB [nav]> To view or answer this question please visit: http://mariadb.com/kb/en/creating-pivot-table-fails/ ___ 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
[Maria-discuss] New Question: Permanent link to download last version of MariaDB
Hello, A new question has been asked in "MariaDB FAQ" by francocorbelli: I suggest to create permanent link to last version of a given series. Something like this https://downloads.mariadb.org/mariadb-5.5/mariadb-current-winx64.msi With best regards for a great project. To view or answer this question please visit: http://mariadb.com/kb/en/permanent-link-to-download-last-version-of-mariadb/ ___ 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
[Maria-discuss] New Question: JSON error
Hello, A new question has been asked in "MariaDB community" by miroigov: Hello, I installed MariaDB Manager on CentOS 6.5 and when i open in browser http://domain.com:8080/MariaDBManager/ it starts loading and then displays error : API did not return JSON for: GET http://localhost/consoleAPI/api/user HTTP 500 - Errors: HTTP/1.1 500 Internal Server Error - The API is unable to function because PHP JSON functions are not available I do not have experience with Tomcat and have no idea how to set json for php. I have php 5 install and json is working fine with default config /etc/php.ini To view or answer this question please visit: http://mariadb.com/kb/en/json-error/ ___ 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
[Maria-discuss] New Question: Question about testing
Hello, A new question has been asked in "MariaDB FAQ" by openiduser40: I'd like to run the test suite on MariaDB-5 + MariaDB-10 both. https://mariadb.com/kb/en/mysql-test-overview gives some information + fails to give enough. Suggest docs add a full example. Something like this... 1) create a database net1# mysql_create_database --dbname=mariadb_test --dbuser=mariadb --dbpass=mariadb /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'CREATE DATABASE mariadb_test CHARACTER SET utf8 COLLATE utf8_general_ci' /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'GRANT ALL PRIVILEGES ON mariadb_test.* to 'mariadb@localhost' IDENTIFIED BY "mariadb"; FLUSH PRIVILEGES;' 2) run a test The reason I ask about this is every test I run fails. lsof shows my socket is /var/run/mysqld/mysqld.sock + here are the failures. mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'SHOW DATABASES' | grep mariadb_test shows my database exists. These tests fail to connect to database... net1# mysqltest --verbose --protocol=socket --socket=/var/run/mysqld/mysqld.sock --database=name=mariadb_test --user=mariadb --password=mariadb mysqltest: Logging to ''. mysqltest: Results saved in ''. mysqltest: Connecting to server (null):3306 (socket /var/run/mysqld/mysqld.sock) as 'mariadb', connection 'default', attempt 0 ... mysqltest: Could not open connection 'default': 1044 Access denied for user 'mariadb'@'localhost' to database 'name=mariadb_test' not ok net1# mysqltest --verbose --host=localhost --database=name=mariadb_test --user=mariadb --password=mariadb mysqltest: Logging to ''. mysqltest: Results saved in ''. mysqltest: Connecting to server localhost:3306 (socket /var/run/mysqld/mysqld.sock) as 'mariadb', connection 'default', attempt 0 ... mysqltest: Could not open connection 'default': 1044 Access denied for user 'mariadb'@'localhost' to database 'name=mariadb_test' not ok net1# /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'SELECT db,user,host FROM mysql.db WHERE db="mariadb_test"' +--+-+---+ | db | user| host | +--+-+---+ | mariadb_test | mariadb | localhost | +--+-+---+ Obviously I'm missing something simple + having a complete example would help. Please update this question with all steps required to run mysqltest. Thanks. To view or answer this question please visit: http://mariadb.com/kb/en/question-about-testing/ ___ 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
[Maria-discuss] New Question: Reentrant mariadbclient on the horizon?
Hello, A new question has been asked in "MariaDB community" by markcianfaglione: I've written an test application that can be multi-threaded and I've done a bit of testing only to find that mariadbclient is not reentrant! (Oh the humanity!) I have got it to run using the reentrant library (libmysqlclient_r) for MySQL but there doesn't seem to be a similar library for mariadbclient. Is this even on the horizon? Mark To view or answer this question please visit: http://mariadb.com/kb/en/reentrant-mariadbclient-on-the-horizon/ ___ 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
[Maria-discuss] New Question: pre-seeding databases from remote servers for multi-source replication
Hello, A new question has been asked in "Backup, Restore and Import" by ivesstoddard: I'm in the process of pre-seeding a mariadb 10.0.9 multi-source replica server with databases from remote 5.5 servers. I'm looking for the fastest and most stable way of doing this (preferably without using mysqldump). I'm curious if there is a way to import entire databases directly from block-level snapshots, similar to the transportable tablespaces (only on a database level instead of a table level, by copying .idb/.frm/etc. files directly to the target server). NOTE: Transportable tablespaces aren't yet available in 5.5 and also have to be done on a table-by-table basis. Some of the databases are large enough that running mysqldump & import will are impractical. Not only will this process take a considerable amount of time, but to do this in a way that is closest to a snapshot will require a separate server instance to ensure all transactions have been committed to the tablespaces. Is there anyone out there looking at multi-source replication who has a simple solution to this that i might be overlooking? Thank you. To view or answer this question please visit: http://mariadb.com/kb/en/pre-seeding-databases-from-remote-servers-for-multi-source-replication/ ___ 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
[Maria-discuss] New Question: mariaDB_client-1-0-0_win64 in Visual Studio 2012
Hello,
A new question has been asked in "Client libraries" by olivierf77:
Hello,
I have installed MariaDB 5.6 , and its works perfectly. Thanks to all the
MariaDB team.
I also installed (by *.msi) mariaDB_client-1-0-0_win64 in
c:\L\SQLClient\mariadb_client-1.0.0-win64\
+ added paths as follow in project properties:
INCLUDE DIRECTORIES =
C:\L\SQLClient\mariadb_client-1.0.0-win64\mariadbclient\include;$(IncludePath)
LIBRARY DIRECTORIES =
C:\L\SQLClient\mariadb_client-1.0.0-win64\lib;$(LibraryPath)
However, when trying to use it even with the most simple programs, compilation
is OK,
**BUT** linking fails:
--- my minimal c++ program (c++ console under Visual Studio 2012 ---
#include "stdafx.h"
#include
int _tmain(int argc, _TCHAR* argv[])
{
MYSQL *my;
my = mysql_init(NULL);
}
-- end of program --
BUILDING PROJETS -> following error msg:
1>-- Build started: Project: cppconMariaDB02, Configuration: Debug Win32
--
1>cppconMariaDB02.obj : error LNK2019: unresolved external symbol _mysql_init@4
referenced in function _wmain
1>c:\users\olivier\documents\visual studio
2012\Projects\cppconMariaDB02\Debug\cppconMariaDB02.exe : fatal error LNK1120:
1 unresolved externals
== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ==
Every mysql function gets the same "unresolved external symbol" error, even
though I believe I did specify the path to the directory containing the 3 files
"libmariadb.dll, libmariadb.lib & mariadbclient.lib", which I even tried (for
testing purposes only, and with no better results) to copy into
windows/system32.
I have spent a lot of time on this issue, with no success. I did see that this
question was asked several times on several programming sites, but it never
gets any answer.
As additional info, here is my directory for the c mariadb_client client:
Directory of c:\L\SQLClient\mariadb_client-1.0.0-win64
..
docs
examples
html
lib
libmysql
mariadbclient
mysql_config
unittest
zlib
I hope that the above information (and question) is clear and complete, but not
over verbose, and that someone in your team will have a few seconds to answer
my query, even though the answer may be trivial (at least for him).
And once again, many thanks for a very nice product.
Sincerely yours
Olivier, Paris, France
PS And hello to Michael 'Monty' Widenus, whom I met in Paris six months ago.
To view or answer this question please visit:
http://mariadb.com/kb/en/mariadb_client-1-0-0_win64-in-visual-studio-2012/
___
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
