| *** rcernin has joined #openstack-trove | 00:06 | |
| *** rcernin has quit IRC | 00:06 | |
| openstackgerrit | Lingxian Kong proposed openstack/python-troveclient master: Show project Id for backup https://review.opendev.org/751913 | 00:28 |
|---|---|---|
| *** congnt95 has joined #openstack-trove | 01:15 | |
| *** congnt95 has quit IRC | 02:13 | |
| *** congnt95 has joined #openstack-trove | 02:13 | |
| *** congnt95 has quit IRC | 03:12 | |
| *** congnt95 has joined #openstack-trove | 04:45 | |
| *** tosky has joined #openstack-trove | 07:34 | |
| *** e0ne has joined #openstack-trove | 08:04 | |
| congnt95 | lxkong: I am testing trove master. When i create instance, trove-api raise error when insert row to database. Did you get this error? | 08:04 |
| congnt95 | "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''is_public': '0'})' | 08:04 |
| lxkong | congnt95, how did you create db instance? | 09:28 |
| congnt95 | openstack database instance create --flavor 6d561f8b-e979-4b39-be19-d20a992823c4 --size 4 --databases database1 --users congnt:daylapassword --datastore mariadb -datastore-version 10.4 --nic net-id=c99b1e3b-08e6-4acf-8050-563a5bd103e2 docker-mariadb-1 | 09:29 |
| congnt95 | i just create by cli | 09:29 |
| congnt95 | I install trove by clone repo & install with pip. anything wrong? | 09:30 |
| lxkong | troveclient version? | 09:31 |
| congnt95 | python-troveclient==5.2.0.dev8 | 09:31 |
| lxkong | that's weird, i just ran that command in my devstack, it is working | 09:33 |
| lxkong | can you add '--debug' in the CLI and try again? | 09:34 |
| lxkong | congnt95, also, did you run db upgrade command? | 09:34 |
| congnt95 | I already run trove-manage db_sync when install trove master | 09:35 |
| congnt95 | let me try another troveclient version | 09:35 |
| lxkong | congnt95, can you paste the output of 'select * from migrate_version;' in trove db? | 09:37 |
| congnt95 | | Trove Migrations | /opt/trove/trove/db/sqlalchemy/migrate_repo | 46 | | 09:38 |
| lxkong | same with mine | 09:42 |
| *** lxkong_ has joined #openstack-trove | 09:43 | |
| lxkong | congnt95, or can you provide the trove error log? | 09:44 |
| congnt95 | https://pikab.in/2df6580936 | 09:47 |
| congnt95 | This is all log when i create instance. With --debug, just return 500 https://imgur.com/I3ehPUv | 09:49 |
| congnt95 | i already try troveclient 2.14, but raise same error | 09:52 |
| lxkong | it has nothing to do with client, it's trove can't insert a JSON type data into mariadb | 09:53 |
| lxkong | i'm using mysql | 09:53 |
| lxkong | congnt95, https://docs.sqlalchemy.org/en/13/core/type_basics.html#sqlalchemy.types.JSON | 09:55 |
| *** lxkong has quit IRC | 09:56 | |
| *** lxkong_ is now known as lxkong | 09:56 | |
| lxkong | maybe we need to think about re-implement JSON type | 09:58 |
| congnt95 | what is your mysql version? | 10:03 |
| lxkong | `Server version: 5.7.31-0ubuntu0.16.04.1` | 10:03 |
| lxkong | congnt95: may i know your mariadb version? | 10:39 |
| *** congnt96 has joined #openstack-trove | 10:59 | |
| *** congnt96 has quit IRC | 11:05 | |
| openstackgerrit | Lingxian Kong proposed openstack/trove master: Change access column type for instance https://review.opendev.org/752030 | 12:07 |
| lxkong | congnt95: could you please help to verify https://review.opendev.org/752030? Please run db upgrade before restarting trove services | 12:07 |
| lxkong | congnt95: i need to go sleep now, please leave msg here for the result, thanks | 12:08 |
| openstackgerrit | Lingxian Kong proposed openstack/trove master: Change access column type for instance https://review.opendev.org/752030 | 12:17 |
| *** lxkong has quit IRC | 12:21 | |
| *** lxkong has joined #openstack-trove | 12:24 | |
| *** andrein_ has joined #openstack-trove | 13:57 | |
| *** coreycb_ has joined #openstack-trove | 14:00 | |
| *** fungi has quit IRC | 14:00 | |
| *** andrein has quit IRC | 14:00 | |
| *** coreycb has quit IRC | 14:00 | |
| *** andrein_ is now known as andrein | 14:00 | |
| *** coreycb_ is now known as coreycb | 14:00 | |
| *** fungi has joined #openstack-trove | 14:09 | |
| *** jmlowe has quit IRC | 14:28 | |
| *** jmlowe has joined #openstack-trove | 14:32 | |
| *** e0ne has quit IRC | 15:26 | |
| openstackgerrit | Lingxian Kong proposed openstack/trove master: Change access column type for instance https://review.opendev.org/752030 | 15:30 |
| -openstackstatus- NOTICE: Our PyPI caching proxies are serving stale package indexes for some packages. We think because PyPI's CDN is serving stale package indexes. We are sorting out how we can either fix or workaround that. In the meantime updating requirements is likely the wrong option. | 16:11 | |
| *** tosky has quit IRC | 17:40 | |
| openstackgerrit | Lingxian Kong proposed openstack/python-troveclient master: Support region in CLI https://review.opendev.org/752115 | 21:14 |
| openstackgerrit | Lingxian Kong proposed openstack/python-troveclient stable/victoria: Support region in CLI https://review.opendev.org/752116 | 21:15 |
| openstackgerrit | Lingxian Kong proposed openstack/python-troveclient stable/ussuri: Support region in CLI https://review.opendev.org/752117 | 21:15 |
| openstackgerrit | Lingxian Kong proposed openstack/python-troveclient stable/train: Support region in CLI https://review.opendev.org/752118 | 21:15 |
| openstackgerrit | Merged openstack/python-troveclient stable/victoria: Support region in CLI https://review.opendev.org/752116 | 21:32 |
| openstackgerrit | Merged openstack/python-troveclient stable/ussuri: Support region in CLI https://review.opendev.org/752117 | 21:38 |
| openstackgerrit | Merged openstack/python-troveclient stable/train: Support region in CLI https://review.opendev.org/752118 | 21:39 |
| openstackgerrit | Merged openstack/python-troveclient master: Support region in CLI https://review.opendev.org/752115 | 21:39 |
| openstackgerrit | Merged openstack/python-troveclient master: Show project Id for backup https://review.opendev.org/751913 | 22:01 |
| *** rcernin has joined #openstack-trove | 22:25 | |
Generated by irclog2html.py 2.17.2 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!