- stopped mysqld and deleted /var/lib/mysql/ibdata1 and the ib_logfiles
- added innodb_buffer_pool_size = 2000M to /etc/my.cnf
- started mysqld and ran ALTER TABLE partners.jos_core_acl_aro ENGINE=InnoDB; ALTER TABLE partners.jos_core_acl_groups_aro_map ENGINE=InnoDB; ALTER TABLE partners.jos_users ENGINE=InnoDB;
I'm now finding that my integration is running but the jos_users table changes are not being written. I've turned on general logging to look at the queries coming in and it looks like the java mysql connector is turning off autocommit and not committing changes at the end of the query. Can anyone suggest how this might be fixed?
Code: Select all
11 Query /* mysql-connector-java-5.1.12 ( Revision: ${bzr.revision-id} ) */SELECT @@session.auto_increment_increment
11 Query SHOW COLLATION
11 Query SET NAMES latin1
11 Query SET character_set_results = NULL
11 Query SET autocommit=1
11 Query SET sql_mode='STRICT_TRANS_TABLES'
11 Query SET autocommit=0
11 Query insert into `jos_users`(`company`, `block`, `email`, `gid`, `lastvisitDate`, `name`, `password`, `registerDate`, `username`,
`usertype`, `activation`, `params`, `sendEmail`) values ('MyCo', 0, '[email protected]', 37, '2013-11-29 17:47:16', 'Bill
Gates', 'password6b771e8d2f266975c04f8:SALTjG9DDqqxsCZ91bWm6jDfc4D5wP1k', '1900-01-01 00:00:00', '[email protected]', 'UserType', '', '', 0)
12 Connect [email protected] on dbname
12 Query /* mysql-connector-java-5.1.12 ( Revision: ${bzr.revision-id} ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_
name = 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' OR Variable_n
ame = 'character_set_connection' OR Variable_name = 'character_set' OR Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_n
ame = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = 'sys
tem_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR Variable_name =
'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' OR Variable_name = 'init_connect'
12 Query /* mysql-connector-java-5.1.12 ( Revision: ${bzr.revision-id} ) */SELECT @@session.auto_increment_increment
12 Query SHOW COLLATION
12 Query SET NAMES latin1
12 Query SET character_set_results = NULL
12 Query SET autocommit=1
12 Query SET sql_mode='STRICT_TRANS_TABLES'
12 Query SET autocommit=0
12 Query commit