fluent / fluent/fluent-plugin-sql

Azure MS SQL Server - USE statement is not supported to switch between databases

未关闭
#133 2 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
enhancement
主要语言
Ruby
星标
112
派生
58
PR 合并指标
30 天内没有已合并 PR

描述

Hi,
I'm trying to use fluent-plugin-sql with Azure MS SQL Server DB and getting error.

Dockerfile partial config:

```
&& gem install fluent-plugin-sql --no-document \
&& gem install tiny_tds \
&& gem install activerecord-sqlserver-adapter \
```

fluent.conf

```

@type sql
host ...
port 1433
database ...
adapter sqlserver
username ...
password ...

table ...

```

Error in fluentd logs:

```
2023-05-12 19:59:57 +0000 [warn]: #0 failed to flush the buffer. retry_times=0 next_retry_time=2023-05-12 19:59:58 +0000 chunk="5fb8489140af6d7034566d69be465982" error_class=TinyTds::Error error="USE statement is not supported to switch between databases. Use a new connection to connect to a different database."
2023-05-12 19:59:57 +0000 [warn]: #0 /usr/local/rvm/rubies/ruby-3.1.4/lib/ruby/gems/3.1.0/gems/tiny_tds-2.1.5/lib/tiny_tds/client.rb:60:in `connect'
2023-05-12 19:59:57 +0000 [warn]: #0 /usr/local/rvm/rubies/ruby-3.1.4/lib/ruby/gems/3.1.0/gems/tiny_tds-2.1.5/lib/tiny_tds/client.rb:60:in `initialize'
2023-05-12 19:59:57 +0000 [warn]: #0 /usr/local/rvm/rubies/ruby-3.1.4/lib/ruby/gems/3.1.0/gems/activerecord-sqlserver-adapter-7.0.2.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:90:in `new'
2023-05-12 19:59:57 +0000 [warn]: #0 /usr/local/rvm/rubies/ruby-3.1.4/lib/ruby/gems/3.1.0/gems/activerecord-sqlserver-adapter-7.0.2.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:90:in `dblib_connect'
2023-05-12 19:59:57 +0000 [warn]: #0 /usr/local/rvm/rubies/ruby-3.1.4/lib/ruby/gems/3.1.0/gems/activerecord-sqlserver-adapter-7.0.2.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:83:in `new_client'
2023-05-12 19:59:57 +0000 [warn]: #0 /usr/local/rvm/rubies/ruby-3.1.4/lib/ruby/gems/3.1.0/gems/activerecord-sqlserver-adapter-7.0.2.0/lib/active_record/sqlserver_base.rb:15:in `sqlserver_connection'
```

Looks like Azure SQL Server doesn't support USE command to switch database. Anyone faced and resolved this?
Thanks in advance.

贡献指南

这个仓库没有索引到贡献指南

调研方向

使用 Dockerfile 的依赖设置和 fluent.conf 作为复现上下文,然后跟踪报告中的 ActiveRecord SQL Server 和 TinyTDS 连接堆栈。确定 sql plugin 如何将数据库设置传递给该连接,并针对 Azure MS SQL Server 确认其行为。当配置的数据库连接能够在不使用不受支持的 USE 开关的情况下成功建立时,即表示完成。

由索引模型根据 Issue 内容生成。

评估

技术栈
azure, ruby, sql
领域
database
Issue 类型
缺陷
难度
4/5
预计耗时
3-5 天
活跃度
冷清
描述清晰度
需要澄清
新手友好度
42/100

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。