The see's discuss from myide

工单点击执行，inception日志显示执行了2次update

如图所示

请问下mysql5.7是如何支持的呢？因为我看到inception是不支持的5.7的

Traceback (most recent call last):
File "/data/vmpython/lib/python3.6/site-packages/django/core/handlers/exception.py", line 35, in inner
response = get_response(request)
File "/data/vmpython/lib/python3.6/site-packages/django/core/handlers/base.py", line 128, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/data/vmpython/lib/python3.6/site-packages/django/core/handlers/base.py", line 126, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/data/vmpython/lib/python3.6/site-packages/django/views/decorators/csrf.py", line 54, in wrapped_view
return view_func(*args, **kwargs)
File "/data/vmpython/lib/python3.6/site-packages/django/views/generic/base.py", line 69, in view
return self.dispatch(request, *args, **kwargs)
File "/data/vmpython/lib/python3.6/site-packages/rest_framework/views.py", line 483, in dispatch
response = self.handle_exception(exc)
File "/data/vmpython/lib/python3.6/site-packages/rest_framework/views.py", line 443, in handle_exception
self.raise_uncaught_exception(exc)
File "/data/vmpython/lib/python3.6/site-packages/rest_framework/views.py", line 480, in dispatch
response = handler(request, *args, **kwargs)
File "/data/see/backend/sqlmng/views/settings.py", line 111, in post
ret = func(self, request)
File "/data/see/backend/sqlmng/mixins.py", line 127, in inception_backup
password = self.conf.get('inception', 'inception_remote_system_password')
File "/data/python3/lib/python3.6/configparser.py", line 781, in get
d = self._unify_values(section, vars)
File "/data/python3/lib/python3.6/configparser.py", line 1141, in _unify_values
print section

inception 测试无问题，可以正常进行备份，但是页面点击备份数据库连接失败

建议使用社区维护新版sql索引审查建议模块

现由社区共同维护，看到see使用到了sqladvisor，建议使用社区维护新版：https://github.com/mysqladvisor/MySQLAdvisor

更新数据一直显示执行中，但实际mysql端以完成执行。

比如没有数据delete,update是返回很快。执行成功。
一旦执行有数据，实际也commit了。始终显示执行中。

http://oldcat.online:52080/ 演示网站暂时无法访问

http://oldcat.online:52080/ 演示网站暂时无法打开，麻烦帮忙查看下呢

支持mssql吗？

sql server 2016

备份库连接失败 500 Internal Server Error

[2019-03-28 18:17:53,310][MainThread:140695313114944][task_id:django.request][exception.py:118][ERROR][Internal Server Error: /api/sqlmng/inception/conncheck/]
Traceback (most recent call last):
File "/usr/local/python3.6/lib/python3.6/configparser.py", line 1138, in _unify_values
sectiondict = self._sections[section]
KeyError: 'inception'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/usr/local/seevenv/lib/python3.6/site-packages/django/core/handlers/exception.py", line 35, in inner
response = get_response(request)
File "/usr/local/seevenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 128, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/usr/local/seevenv/lib/python3.6/site-packages/django/core/handlers/base.py", line 126, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/usr/local/seevenv/lib/python3.6/site-packages/django/views/decorators/csrf.py", line 54, in wrapped_view
return view_func(*args, **kwargs)
File "/usr/local/seevenv/lib/python3.6/site-packages/django/views/generic/base.py", line 69, in view
return self.dispatch(request, *args, **kwargs)
File "/usr/local/seevenv/lib/python3.6/site-packages/rest_framework/views.py", line 483, in dispatch
response = self.handle_exception(exc)
File "/usr/local/seevenv/lib/python3.6/site-packages/rest_framework/views.py", line 443, in handle_exception
self.raise_uncaught_exception(exc)
File "/usr/local/seevenv/lib/python3.6/site-packages/rest_framework/views.py", line 480, in dispatch
response = handler(request, *args, **kwargs)
File "/usr/local/seevenv/see-master/backend/sqlmng/views/settings.py", line 122, in post
ret = func(self, request)
File "/usr/local/seevenv/see-master/backend/sqlmng/mixins.py", line 95, in inception_backup
password = self.conf.get('inception', 'inception_remote_system_password')
File "/usr/local/python3.6/lib/python3.6/configparser.py", line 781, in get
d = self._unify_values(section, vars)
File "/usr/local/python3.6/lib/python3.6/configparser.py", line 1141, in _unify_values
raise NoSectionError(section)
configparser.NoSectionError: No section: 'inception'

大神能否支持ldap登录啊

如题，大神能否支持ldap登录啊

建议新增docker，安装有点麻烦

sql语句过长引起的问题

查询优化->sql评分，当sql语句长度超过get请求的长度时，会报错，不方便长语句的优化

frontend 安装编译报错

文档上没有frontend的安装操作步骤，在frontend目录下执行npm install 然后在执行npm run build报错

see api 怎么用

sql优化无法连接数据库

sql优化界面无法选择数据库？是空白的

see不更新了吗？

如题

工单审核报数据库连接错误

报错信息如下：
{"MySQL连接异常 ":"((1, 'NONE', 2, 'None', 'Invalid source infomation.', 'Global environment', 0, 'None', 'None', '0', 'None'),)"}

安装步骤混乱，希望能更新。

在步骤4.2 安装依赖中，把 mysql 卸载了yum remove -y mysql-community-client mysql-community-server mysql-community-common mysql-community-libs
然后在7.4 中又做 migration
有点莫名其妙

选择数据库为空

选择数据库时没有响应。后台应该怎么查日志？

按照安装文档安装的，每一步都成功了。

回滚时报错，但找不到错误信息

如上图，报错时提示查看Inception结果集，但Inception日志输出并无错误

回滚段的可以针对单个SQL开启不

工单创建后，点击执行，没有任何响应

创建一个新的工单，提交审核后，点击执行，没有任何相应，再次点击就提示工单已经锁定，等一会儿（解锁之后）在次点击就会立即执行，这个是里面是什么逻辑？是有bug还是我操作方式有问题？
我在demo平台上测试了下，创建了3个工单，一次点击执行，也偶有这个状况出现，但是比我本地的情况好很多
测试的建表语句用的utils中的那个示例，测试insert语句，结果也同上。

sql审核那块，建表语句语法检测必须字段为非空哪里可以设置，我已经关闭inception了

任务异常有点笼统

测试的时候发现，任务异常没有任何原因的日志出现的web页面
1 比如执行的时候warning，会出现任务异常，但是sql已经执行成功了
2 如果一大堆sql中出现一条执行报错，但是这个sql之前的也会执行成功，没有任何提示

/usr/bin/ld: cannot find -lperconaserverclient_r

1> 编译sqladvisor时依赖perconaserverclient_r, 因此需要安装Percona-Server-shared-56。
#wget http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
#yum install percona-release-0.1-3.noarch.rpm -y
#yum install Percona-Server-shared-56 -y
2> 编译sqladvisor的依赖项sqlparser（源码目录）
#cd /usr/local/src/SQLAdvisor/
#cmake -DBUILD_CONFIG=mysql_release -DCMAKE_BUILD_TYPE=debug -DCMAKE_INSTALL_PREFIX=/usr/local/sqlparser -DIGNORE_AIO_CHECK=/usr/share/doc/libaio-0.3.109 ./
#make && make install
3> 编译sqladvisor(源码目录)
#cd ./sqladvisor/
#cmake -DCMAKE_BUILD_TYPE=debug ./
#make

4> Finished

[root@vultr frontend]# npm run build 

> [email protected] build /root/see/frontend
> webpack --progress --hide-modules --config build/webpack.prod.config.js

clean-webpack-plugin: /root/see/frontend/dist/* has been removed.
Happy[happybabel]: Version: 4.0.1. Threads: 1 (shared pool)
fs.js:128
  throw new ERR_INVALID_CALLBACK();
  ^

TypeError [ERR_INVALID_CALLBACK]: Callback must be a function
    at maybeCallback (fs.js:128:9)
    at Object.write (fs.js:540:14)
    at /root/see/frontend/build/webpack.prod.config.js:16:8
    at FSReqWrap.args [as oncomplete] (fs.js:140:20)
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] build: `webpack --progress --hide-modules --config build/webpack.prod.config.js`
npm ERR! Exit status 1
npm ERR! 
npm ERR! Failed at the [email protected] build script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR!     /root/.npm/_logs/2019-06-28T07_09_09_510Z-debug.log
[root@vultr frontend]# ls dist/clean-webpack-plugin
ls: cannot access dist/clean-webpack-plugin: No such file or directory

myide / see Goto Github PK

see's Issues

Recommend Projects

Recommend Topics

Recommend Org