DBDish::mysql error - Unsupported Concurrency: Connection used by multiple threads simultaneously

[melezhik]

DBDish::mysql error - Unsupported Concurrency: Connection used by multiple threads simultaneously

[CurtTilmes]

DB::Pg is in pretty good shape. DB::MySQL has some fundamental brokenness I haven't been able to fix.

[jnthn]

In general, one cannot reuse database connection objects across threads. This isn't anything Raku-specific; the same is observed over different database drivers and bindings to them in different programming languages. The typical solution is to use a connection pool; I'm not sure if this module offers one (and that's why I've tended to use DB::Pg instead in Cro apps, since it has had one out of the box from the start).

[melezhik]

Hi @rbt - thanks - I will try DBIish::Pool. and let you guys, know . Thanks Alexey чт, 31 мар. 2022 г. в 06:01, rbt ***@***.***>:

…

@melezhik <https://github.com/melezhik> Try DBIish::Pool. Grab one connection for each request, and discard it at the end of the request. @jnthn <https://github.com/jnthn> I'm not sure if this module offers one (and that's why I've tended to use DB::Pg instead in Cro apps, since it has had one out of the box from the start). I originally created DBIish::Pool with intention of merging into this driver directly via #171 <#171>, but there was a preference to have it as a separate module. — Reply to this email directly, view it on GitHub <#222 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAHRHSNGHVZHW7K2TUVN5ODVCWAZVANCNFSM5SDFAMDQ> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[melezhik]

@jnthn , yeah DB::Pg is one of the options here, though I am hesitant to switch to postgresql from mysql which is on my view is easier to maintain ....

[jnthn]

yeah DB::Pg is one of the options here, though I am hesitant to switch to postgresql from mysql which is on my view is easier to maintain ....

D'oh, yes, that wan't so useful an answer on my part. :-) What I should have added is that there is https://modules.raku.org/dist/DB::MySQL:cpan:CTILMES too, which is pretty much the DB::Pg approach but for MySQL. That said, if you're already using DBIish, the pool module is probably the path of least resistance from where you are.

[melezhik]

@jnthn ++ thanks for that, @patrickbkr already mentioned DB::MySQL in raku irc channel, I will keep it as a second possible solution ...

[melezhik]

I've just tried to use DBIish::Pool and looks like it works great for my sparky web cro app and concurrent db requests - melezhik/sparky@106f82b. @patrickbkr @jnthn @CurtTilmes @rba thanks for your help