Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC

  1. Bug #1091099
  2. Comment #1

Comment 1 for bug 1091099

Revision history for this message
Arthin (arthin) wrote :

case 1 is ok:

begin;
use abc;
select count(*) from id_seq;
rollback;

case 2 get an error:

set autocommit=0;
use abc;
select count(*) from id_seq;
commit;

ERROR 1290 (HY000): The MySQL server is running with the --read-only option so it cannot execute this statement

case 3 get an error:
set autocommit=1;
use abc;
select count(*) from id_seq;

ERROR 1290 (HY000): The MySQL server is running with the --read-only option so it cannot execute this statement