Message: Modifications not permitted for read-only database SQLCODE=-757
Message: -757 Modifications not permitted for read-only database Message: Could not execute statement. Modifications not permitted for read-only database SQLCODE=-757 Message: OFSS Modifications not permitted for read-only database SQLCODE=-757 Message: SQLCODE = -757 Modifications not permitted for read-only database
Explanation: The Offline Foxhound Sampling Service (OFSS) doesn't work on read-only subject databases because the OFSS scripts can't modify the database.
This limitation affects High Availability secondary (mirror) and read-only scale-out databases in particular.
C:\HASETUP2-V17>"C:\Program Files\SQL Anywhere 17\bin64\dbisql.com"
-c "SERVER=secondary_server; UID=dba; PWD=sql; HOST=localhost:55502,localhost:55503; CON=Secondary;"
READ ENCODING Cp1252 "C:\ProgramData\RisingRoad\Foxhound5\scripts\OFSS_1_setup.sql" [OFSS]
You have connected to a read-only database.
Some Interactive SQL functionality will be disabled.
10 row(s) affected
Could not execute statement.
Modifications not permitted for read-only database
SQLCODE=-757, ODBC 3 State="42000"
C:\ProgramData\RisingRoad\Foxhound5\scripts\OFSS_1_setup.sql:83
CREATE TABLE "OFSS".OFSS_settings (
You can continue executing or stop.
1. Stop
2. Continue
Select an option:
Administrative Tip:
When using OFSS on a High Availability setup, run the OFSS setup and start_OFSS_monitor() on the primary, not the underlying partner.
After a failover, you can then rerun the CALL start_OFSS_monitor() on the primary because it will be updatable.
You can also run OFSS on the arbiter server if it has a database.
|