maria-discuss team mailing list archive

[Karthick Subramanian <ksubramanian@xxxxxxxxxxxxxxx>]

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.black@xxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>