Thank you Daniel for your information. This is awesome. BTW, the script that you have mentioned "maria_add_gis_sp.sql" - where can I get this. How do we come to know in future for any fixes from MariaDB corp. Thank you.
On Thu, Feb 16, 2017 at 9:39 AM, Daniel Black <daniel.bl...@au1.ibm.com> wrote: > > > On 15/02/17 19:02, Karthick Subramanian wrote: > > All, > > > > I got a replciation problem and planned to take master server dump using > > below command and tried to restore in slave server: > > > > mysqldump --skip-lock-tables --single-transaction --flush-logs > > --hex-blob --master-data=1 -A --routines > ~/dump.sql > > > > I got into this error: > > https://jira.mariadb.org/browse/MDEV-10119 > > > > Then I tried this method: > > http://lists.askmonty.org/pipermail/commits/2016-June/009504.html > > > > My question: > > > > Is it ok if the GIS procedure currently with definer as > > definer=`root@localhost` > > yes. This is the proper state for the procedure. > > > instead of blank as definer=`` for the > > This is incorrect. Fix your Master_MariaDB. Drop the procedure and > create again as per maria_add_gis_sp.sql > > > following two procs in mysql: > > > > Use SHOW CREATE PROCEDURE mysql.AddGeometryColumn\G > > https://mariadb.com/kb/en/mariadb/show-create-procedure/ > > to show information rather than selecting from the underlying tables. > > > Slave_MariaDB [(none)]> select db, name, definer from mysql.proc; > > +---------+------------------------+-----------------+ > > | db | name | definer | > > +---------+------------------------+-----------------+ > > | mysql | AddGeometryColumn | root@localhost | > > | mysql | DropGeometryColumn | root@localhost | > > > > > > Master_MariaDB [(none)]> select db, name, definer from mysql.proc; > > +---------+------------------------+-----------------+ > > | db | name | definer | > > +---------+------------------------+-----------------+ > > | mysql | AddGeometryColumn | @ | > > | mysql | DropGeometryColumn | @ | > > > _______________________________________________ > 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 >
_______________________________________________ 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
