Hi
I'm trying to setup unique partial indexes so that constraint violation is
only thrown when a a certain column is true. This is the index I'm using:
__table_args__ = (
Index(
"idx_one_active_fulfillment",
member_id,
status,
unique=True,
postgres_where=(status ==
this does mean there's a bug in the mariadb driver, if you can provide a
reproducing test case
On Tue, May 11, 2021, at 12:41 PM, Rob Marshall wrote:
> Hi Mike,
>
> Apparently it was the driver. I changed the create_engine to:
>
> engine =
Hi Mike,
Apparently it was the driver. I changed the create_engine to:
engine = create_engine('mysql://user:password@127.0.0.1/options')
And that appears to handle that particular insert without issue.
Thank-you,
Rob
On Tuesday, May 11, 2021 at 10:41:13 AM UTC-4 Mike Bayer wrote:
> two
two things to try:
1. try a different driver, like mysqlclient or pymysql, to see if error persists
2. when it hangs, look in information_schema.processlist for current info (it's
the same in mariadb):
https://dev.mysql.com/doc/refman/8.0/en/information-schema-processlist-table.html
On
Hi,
I'm updating a MySQL (MariaDB) database using Pandas and sqlalchemy. I am
seeing it hang on a ROLLBACK but I'm not sure how to determine what is
causing the ROLLBACK. Below is a session with DEBUG enabled. Any help would
be appreciated.
The engine is created with:
engine =