- discuss - lists.mariadb.org

[Maria-discuss] New Question: PORTING MYSQL V5.5.19 TO MARIADB MASTER-MASTER SETUP
by AskMonty KB 17 Feb '16

17 Feb '16

Hello, A new question has been asked in "Replication, Cluster, & Multi-Master" by Christine.Ross. Please answer it at http://mariadb.com/kb/en/porting-mysql-v5519-to-mariadb-master-master-setup/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We currently have mysql v5.5.19 64bit on Sparc Sun Solaris, with an INNODB storage engine. I am researching porting to mariadb. Our primary servers function in a master-master configuration, with real-time updates when changes are made on either server. I see docs describing master-slave and some posts about master-master. Do I have to install the galera cluster to maintain this master-master setup please or can I just install mariadb on each server and set the my.cnf files as I currently have them with different server-IDs please? Thank you very much. Christine -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/porting-mysql-v5519-to-mariadb-master-master-setup/

1 0

[Maria-discuss] Performance issues after upgrading to 10.0
by azurit＠pobox.sk 15 Feb '16

15 Feb '16

Hi, we upgraded MariaDB 5.5 to 10.0 on one server last night and are now dealing with severe performance issues. Here is one case where it's notable: Query - SELECT b.*, p.category_id FROM brands b JOIN products p USING(brand_id) GROUP BY category_id, brand_id ORDER BY title ASC; Table structures: CREATE TABLE `brands` ( `brand_id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL, `slug` varchar(50) NOT NULL, `description` text NOT NULL, `discount_suv_1` float NOT NULL, `discount_suv_2` float NOT NULL, `discount_van_1` float NOT NULL, `discount_van_2` float NOT NULL, `discount_orp_1` float NOT NULL, `discount_orp_2` float NOT NULL, PRIMARY KEY (`brand_id`) ) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=utf8 CREATE TABLE `products` ( `product_id` int(11) NOT NULL AUTO_INCREMENT, `category_id` int(11) DEFAULT NULL, `featured_image_id` int(11) DEFAULT NULL, `brand_id` int(11) DEFAULT NULL, `title` text NOT NULL, `slug` text NOT NULL, `price` float NOT NULL, `custom_price` float NOT NULL, `description` text NOT NULL, `hidden` tinyint(1) NOT NULL, `homepage` tinyint(1) NOT NULL, `sale` tinyint(1) NOT NULL, `width` float NOT NULL, `height` int(11) NOT NULL, `diameter` int(11) NOT NULL, `resistance` varchar(50) NOT NULL, `breaking_distance` varchar(50) NOT NULL, `noise` varchar(50) NOT NULL, `ean` varchar(50) NOT NULL, `availability` char(1) NOT NULL, `li` varchar(15) NOT NULL, `si` varchar(15) NOT NULL, `classes` varchar(5) NOT NULL, `all_year` tinyint(1) NOT NULL, `type` char(3) NOT NULL, `holes_count` float NOT NULL, `pitch` float NOT NULL, `et` float NOT NULL, `code` varchar(50) NOT NULL, `custom` tinyint(1) NOT NULL, `car_type` varchar(100) NOT NULL, `models` text NOT NULL, `imported` tinyint(1) NOT NULL, `is_runflat` tinyint(1) NOT NULL, `stock_count` int(11) NOT NULL, `parser` char(1) NOT NULL, PRIMARY KEY (`product_id`), KEY `category_id` (`category_id`), KEY `featured_image_id` (`featured_image_id`), KEY `brand_id` (`brand_id`), KEY `slug` (`slug`(100)), KEY `hidden` (`hidden`), CONSTRAINT `products_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`category_id`) ON DELETE SET NULL, CONSTRAINT `products_ibfk_4` FOREIGN KEY (`featured_image_id`) REFERENCES `product_images` (`product_image_id`) ON DELETE SET NULL, CONSTRAINT `products_ibfk_5` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`brand_id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=63638 DEFAULT CHARSET=utf8 Table brands: 149 rows Table products: 62074 rows Query time on 5.5: about 0.2s Query time on 10.0: between 2 and 9s (if not cached) Explain on 5.5: http://watchdog.sk/5.5.png Explain on 10.0: http://watchdog.sk/10.png Any hints what's going on? What about the difference in the explain command? Thank you. azur

4 8

[Maria-discuss] New Question: unable to update MariaDB from 10.0 to 10.1, error indicating galera libboost dependencies issue
by AskMonty KB 15 Feb '16

15 Feb '16

Hello, A new question has been asked in "MariaDB Community" by cyberdome. Please answer it at http://mariadb.com/kb/en/unable-to-update-mariadb-from-100-to-101-error-ind… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello world, I am trying to update my database MariaDB from 10.0 to 10.1 and when I run the yum update command. I am getting this error message below: Any help is appreciated. Resolving Dependencies --> Running transaction check ---> Package galera.x86_64 0:25.3.9-1.rhel7.el7.centos will be updated ---> Package galera.x86_64 0:25.3.12-1.rhel7.el7.centos will be an update --> Processing Dependency: libboost_program_options.so.1.53.0()(64bit) for package: galera-25.3.12-1.rhel7.el7.centos.x86_64 ---> Package google-chrome-stable.x86_64 0:48.0.2564.97-1 will be updated ---> Package google-chrome-stable.x86_64 0:48.0.2564.109-1 will be an update --> Finished Dependency Resolution Error: Package: galera-25.3.12-1.rhel7.el7.centos.x86_64 (mariadb) Requires: libboost_program_options.so.1.53.0()(64bit) You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest Any suggestions would be helpful. I am stuck at this stage. I have no idea what to do next? Thanks __________________ Linux Newbie - Information is Power! Download Linux @ http://www.fedora.redhat.com/ May the Linux force be with you! Fedora 21 - MariaDB 10.0 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-update-mariadb-from-100-to-101-error-ind…

1 0

[Maria-discuss] New Question: Will Aria 2.0 have an option to stay crash-safe, but not have the performance penalties necessary for true transactionality?
by AskMonty KB 12 Feb '16

12 Feb '16

Hello, A new question has been asked in "Development" by Moscato. Please answer it at http://mariadb.com/kb/en/will-aria-20-have-an-option-to-stay-crash-safe-but… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Will Aria 2.0 have an option to stay crash-safe, but not have the performance penalties necessary for true transactionality? I love the speed and compactness of Aria (InnoDB tables are relatively huge), and I love that its crash-safe. I don't want to ever lose that crash-safe-ness, but I really don't care if my database goes back in time, and I lose data. Will there be a middle ground? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/will-aria-20-have-an-option-to-stay-crash-safe-but…

1 0

[Maria-discuss] New Question: COUNT not working on XAMPP
by AskMonty KB 12 Feb '16

12 Feb '16

Hello, A new question has been asked in "SQL Commands" by styxlawyer. Please answer it at http://mariadb.com/kb/en/count-not-working-on-xampp/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have just installed XAMPP version 7.0.2 which incorporates MariaDB. I have added a table called repairs to the test database and it works fine with various PHP pages I have written. However, when trying to use a simple query like: SELECT COUNT (*) FROM repairs I get the following error message: #1630 - FUNCTION test.COUNT does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual This happens in both phpMyadmin and in PHP pages which are accessing the database. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/count-not-working-on-xampp/

2 1

[Maria-discuss] MariaDB 5.5.48 and Connector/J 1.3.5 now available
by Daniel Bartholomew 11 Feb '16

11 Feb '16

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

1 0

[Maria-discuss] JSON in MySQL and MariaDB
by Peter Laursen 11 Feb '16

11 Feb '16

I wonder if someone are able to summarize differences (and similarities - if any ;-) ) between MariaDB and MySQL as regards JSON. I a not really able to structure it myself. MySQL has introduced the JSON datatype https://dev.mysql.com/doc/refman/5.7/en/json.html. I don' tbelieve it is availale in MariaDB. The slides here http://www.slideshare.net/blueskarlsson/using-json-with-mariadb-and-mysql tell that dynamic columns should be used with JSON and MariaDB. Also how much do the functions in both servers for manipulating JSON differ? Are they just named diferently in some cases but doing basically the same? What manipultion options does one have that the other has not (and vice versa). Also :does MariaDB have any plans to move closer to MySQL in 10.2 (such as introducing the JSON datatype and related syntax and funtionalities, for instance)? We would like to add JSON handling capabilites in our (SQLyog) GUI client soon. But the 'uneven' implementation in MariaDB and MySQL is indeed a problem. I think the reply to questions above would be approproate for a Blog, BTW. (@Anders - something for you?) -- Peter Laursen -- Webyog

1 0

[Maria-discuss] New Question: my.cnf 128 GB RAM server
by AskMonty KB 11 Feb '16

11 Feb '16

Hello, A new question has been asked in "MariaDB Community" by wgn. Please answer it at http://mariadb.com/kb/en/mycnf-128-gb-ram-server/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We are using /usr/share/lve/dbgovernor/db-select-mysql --mysql-version=mariadb101 Hello, As I see MySQL-governor and cl-MariaDB packages have already installed in your system. Could you please clarify what exactly doesn't work? Best regards, -- Anton Mashnin | L2 Technical Support Engineer CloudLinux.com | KernelCare.com [Free Trial] | KuberDock.com [Free Trial] It is work but make an issue ... we not know what is the best setting with our server 128GB RAM We use this http://www.gk-root.com/GK-Blog/optimize-mysql-apache-on-cpanelwhm-server/ Best config base on 8 core & 12GB memory (Shared server) MySQL 5.5: [mysqld] local-infile=0 max_connections = 600 max_user_connections=1000 key_buffer_size = 512M myisam_sort_buffer_size = 64M read_buffer_size = 1M table_open_cache = 5000 thread_cache_size = 384 wait_timeout = 20 connect_timeout = 10 tmp_table_size = 256M max_heap_table_size = 128M max_allowed_packet = 64M net_buffer_length = 16384 max_connect_errors = 10 concurrent_insert = 2 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M query_cache_limit = 5M query_cache_size = 128M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65535 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 max_write_lock_count = 8 slow_query_log log-error external-locking=FALSE open_files_limit=50000 [mysqld_safe] [mysqldump] quick max_allowed_packet = 16M [isamchk] key_buffer = 384M sort_buffer = 384M read_buffer = 256M write_buffer = 256M [myisamchk] key_buffer = 384M sort_buffer = 384M read_buffer = 256M write_buffer = 256M #### Per connection configuration #### sort_buffer_size = 1M join_buffer_size = 1M thread_stack = 192K -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mycnf-128-gb-ram-server/

1 0

[Maria-discuss] New Question: setNString method not implemented in PreparedStatement class
by AskMonty KB 11 Feb '16

11 Feb '16

Hello, A new question has been asked in "MariaDB Connector/J" by Sebastian_S. Please answer it at http://mariadb.com/kb/en/setnstring-method-not-implemented-in-preparedstate… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I do not know if it proper place to ask something like that, but did not find better place. Recently I'd like to connect log4j2 to MariaDB database via MariaDB Connector/J (version 1.3.5, but tested each other). I could not do that and I found that reason is in connector - MariaDbServerPreparedStatement class does not implement method setNString and AbstractMariaDbPreparedStatement class throws exception "NStrings not supported". Why it is not supported. MariaDB does not support such type or it is just a bug? When I copied code form setString method to setNString then everything works properly. Regards, Sebastian -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/setnstring-method-not-implemented-in-preparedstate…

1 0

[Maria-discuss] New Question: MySQL connector bug with bulk insert ?
by AskMonty KB 10 Feb '16

10 Feb '16

Hello, A new question has been asked in "MariaDB Connector/J" by doortts. Please answer it at http://mariadb.com/kb/en/mysql-connector-bug-with-bulk-insert/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm new to MariaDB and testing with some applications. Yesterday I met a wired bug. When I using bulk insert with MariaDB connector 1.3.4, following errors occur. (Ubuntu 14.4 and MariaDB 10.1.11) When I replace the connector driver with 'MySQL connector', It works fine. The reference Q&A was http://stackoverflow.com/questions/18693800/mariadb-jdbc-connection-fails-d… The reason that I call this bug is wired was, with same mariadb connector I haven't met bug in any other systems, Mac/Centos 6. Even more another ubuntu system MariaDB 10.1.10 with same driver, no error occurs. works fine: Linux ubuntu 3.13.0-34-generic #60-Ubuntu SMP Wed Aug 13 15:45:27 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux Error occurred system: No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 14.04.3 LTS Release: 14.04 Codename: trusty Linux Yukino 3.16.0-57-generic #77~14.04.1-Ubuntu SMP Thu Dec 17 23:20:00 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux java version "1.8.0_66" Java(TM) SE Runtime Environment (build 1.8.0_66-b17) Java HotSpot(TM) 64-Bit Server VM (build 25.66-b17, mixed mode) Error message: ``` java.lang.NullPointerException at java.lang.String.getBytes(String.java:917) at org.mariadb.jdbc.internal.stream.PacketOutputStream.sendStream(PacketOutputStream.java:178) at org.mariadb.jdbc.internal.packet.dao.parameters.ReaderParameter.writeBinary(ReaderParameter.java:134) at org.mariadb.jdbc.internal.packet.send.SendPrepareParameterPacket.send(SendPrepareParameterPacket.java:93) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:568) at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeBatch(MariaDbServerPreparedStatement.java:230) at com.jolbox.bonecp.StatementHandle.executeBatch(StatementHandle.java:424) at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005) at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673) at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989) at data.DefaultExchanger.batchUpdate(DefaultExchanger.java:319) at data.DefaultExchanger.importDataFromArray(DefaultExchanger.java:307) at data.DefaultExchanger.importData(DefaultExchanger.java:255) at data.DataService.importData(DataService.java:196) at controllers.SiteApp.importData(SiteApp.java:314) at Routes$$anonfun$routes$1$$anonfun$applyOrElse$54$$anonfun$apply$54.apply(routes_routing.scala:2058) at Routes$$anonfun$routes$1$$anonfun$applyOrElse$54$$anonfun$apply$54.apply(routes_routing.scala:2058) at play.core.Router$HandlerInvokerFactory$$anon$4.resultCall(Router.scala:264) at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.invocation(Router.scala:255) at play.core.j.JavaAction$$anon$1.call(JavaAction.scala:55) at Global$1.call(Global.java:190) at actions.AnonymousCheckAction.call(AnonymousCheckAction.java:57) at utils.SiteManagerAuthAction.call(SiteManagerAuthAction.java:39) at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) at play.core.j.HttpExecutionContext$$anon$2.run(HttpExecutionContext.scala:40) at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) at play.core.j.HttpExecutionContext.execute(HttpExecutionContext.scala:32) at scala.concurrent.impl.Future$.apply(Future.scala:31) at scala.concurrent.Future$.apply(Future.scala:485) at play.core.j.JavaAction$class.apply(JavaAction.scala:82) at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.apply(Router.scala:252) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) at play.utils.Threads$.withContextClassLoader(Threads.scala:21) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:129) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:128) at scala.Option.map(Option.scala:145) at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:128) at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:121) at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) org.springframework.transaction.TransactionSystemException: Could not roll back JDBC transaction; nested exception is java.sql.SQLNonTransientConnectionException: Could not send query: Last stream not finished at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:290) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:849) at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:826) at data.DefaultExchanger.importData(DefaultExchanger.java:266) at data.DataService.importData(DataService.java:196) at controllers.SiteApp.importData(SiteApp.java:314) at Routes$$anonfun$routes$1$$anonfun$applyOrElse$54$$anonfun$apply$54.apply(routes_routing.scala:2058) at Routes$$anonfun$routes$1$$anonfun$applyOrElse$54$$anonfun$apply$54.apply(routes_routing.scala:2058) at play.core.Router$HandlerInvokerFactory$$anon$4.resultCall(Router.scala:264) at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.invocation(Router.scala:255) at play.core.j.JavaAction$$anon$1.call(JavaAction.scala:55) at Global$1.call(Global.java:190) at actions.AnonymousCheckAction.call(AnonymousCheckAction.java:57) at utils.SiteManagerAuthAction.call(SiteManagerAuthAction.java:39) at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) at play.core.j.HttpExecutionContext$$anon$2.run(HttpExecutionContext.scala:40) at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) at play.core.j.HttpExecutionContext.execute(HttpExecutionContext.scala:32) at scala.concurrent.impl.Future$.apply(Future.scala:31) at scala.concurrent.Future$.apply(Future.scala:485) at play.core.j.JavaAction$class.apply(JavaAction.scala:82) at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.apply(Router.scala:252) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) at play.utils.Threads$.withContextClassLoader(Threads.scala:21) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:129) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:128) at scala.Option.map(Option.scala:145) at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:128) at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:121) at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) Caused by: java.sql.SQLNonTransientConnectionException: Could not send query: Last stream not finished at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:123) at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:69) at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:261) at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:290) at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:344) at org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:532) at com.jolbox.bonecp.ConnectionHandle.rollback(ConnectionHandle.java:1272) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:287) ... 46 more Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Could not send query: Last stream not finished at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.sendQuery(AbstractQueryProtocol. ``` -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mysql-connector-bug-with-bulk-insert/

1 0