Pandas version checks

  • [x] I have checked that this issue has not already been reported.

  • [x] I have confirmed this bug exists on the latest version of pandas.

  • [x] I have confirmed this bug exists on the main branch of pandas.

Reproducible Example

na

Issue Description

FAILED pandas/tests/io/test_sql.py::test_xsqlite_execute_fail - pandas.errors.DatabaseError: Execution failed on sql 'INSERT INTO test VALUES("foo", "bar", 1.234)': no such column: "foo" - should this be a string literal in single-quotes? FAILED pandas/tests/io/test_sql.py::test_xsqlite_execute_closed_connection - pandas.errors.DatabaseError: Execution failed on sql 'INSERT INTO test VALUES("foo", "bar", 1.234)': no such column: "foo" - should this be a string literal in single-quotes? = 2 failed, 3760 passed, 372 skipped, 232245 deselected, 376 xfailed, 1 xpassed, 81 warnings in 1182.58s (0:19:42) = /home/runner/micromamba/envs/test/lib/python3.12/site-packages/s3fs/core.py:569: DeprecationWarning: There is no current event loop loop = asyncio.get_event_loop() Error: Process completed with exit code 1. Run actions/upload-artifact@v4 With the provided path, there will be 1 file uploaded Artifact name is valid! Root directory input is valid! Beginning upload of artifact content to blob storage Uploaded bytes 39831 Finished uploading artifact content to blob storage! SHA256 hash of uploaded artifact zip is f1126cc96347284a152f921e8e59bcadd2762e4d3872d66fe1d9881a9775948f Finalizing artifact upload Artifact Test results.zip successfully finalized. Artifact ID 2636217021 Artifact Test results has been successfully uploaded! Final size is 39831 bytes. Artifact ID is 2636217021 Artifact download URL: https://github.com/pandas-dev/pandas/actions/runs/13478588009/artifacts/2636217021 Run codecov/codecov-action@v4 eventName: pull_request baseRef: pandas-dev:main | headRef: Anurag-Varma:bug#60723 ==> Fork detected, tokenless uploading used ==> linux OS detected https://cli.codecov.io/latest/linux/codecov.SHA256SUM gpg: directory '/home/runner/.gnupg' created gpg: keybox '/home/runner/.gnupg/pubring.kbx' created gpg: /home/runner/.gnupg/trustdb.gpg: trustdb created gpg: key 806BB28AED779869: public key "Codecov Uploader (Codecov Uploader Verification Key) security@codecov.io" imported gpg: Total number processed: 1 gpg: imported: 1 gpg: Signature made Fri Feb 21 21:18:38 2025 UTC gpg: using RSA key 27034E7FDB850E0BBC2C62FF806BB28AED779869 gpg: Good signature from "Codecov Uploader (Codecov Uploader Verification Key) security@codecov.io" [unknown] gpg: WARNING: This key is not certified with a trusted signature! gpg: There is no indication that the signature belongs to the owner. Primary key fingerprint: 2703 4E7F DB85 0E0B BC2C 62FF 806B B28A ED77 9869 ==> Uploader SHASUM verified (ec031bdc38a2ca279ea1f56650b63aa6ce1365e7ee9da33b413e6f175a94fe2b codecov) ==> Running version latest Could not pull latest version information: SyntaxError: Unexpected token '<', "<!DOCTYPE "... is not valid JSON ==> Running git config --global --add safe.directory /home/runner/work/pandas/pandas /usr/bin/git config --global --add safe.directory /home/runner/work/pandas/pandas ==> Running command '/home/runner/work/_actions/codecov/codecov-action/v4/dist/codecov create-commit' /home/runner/work/_actions/codecov/codecov-action/v4/dist/codecov create-commit --git-service github -B Anurag-Varma:bug#60723 -C 42c51ec8e4efc3c8a221625c92b22e2730b5fe7e info - 2025-02-23 02:40:28,834 -- ci service found: github-actions info - 2025-02-23 02:40:28,861 -- Creating a commit for an unprotected branch: Anurag-Varma:bug#60723 info - 2025-02-23 02:40:29,365 -- Process Commit creating complete ==> Running command '/home/runner/work/_actions/codecov/codecov-action/v4/dist/codecov create-report' /home/runner/work/_actions/codecov/codecov-action/v4/dist/codecov create-report --git-service github -C 42c51ec8e4efc3c8a221625c92b22e2730b5fe7e info - 2025-02-23 02:40:30,161 -- ci service found: github-actions info - 2025-02-23 02:40:30,587 -- Process Report creating complete info - 2025-02-23 02:40:30,588 -- Finished creating report successfully --- {"response": "{\"status\":\"queued\"}\n"} ==> Running command '/home/runner/work/_actions/codecov/codecov-action/v4/dist/codecov do-upload' /home/runner/work/_actions/codecov/codecov-action/v4/dist/codecov do-upload -F unittests --git-service github -n codecov-pandas -C 42c51ec8e4efc3c8a221625c92b22e2730b5fe7e info - 2025-02-23 02:40:31,391 -- ci service found: github-actions warning - 2025-02-23 02:40:31,418 -- xcrun is not installed or can't be found. warning - 2025-02-23 02:40:31,450 -- No gcov data found. warning - 2025-02-23 02:40:31,450 -- coverage.py is not installed or can't be found. info - 2025-02-23 02:40:31,498 -- Found 1 coverage files to report info - 2025-02-23 02:40:31,498 -- > /home/runner/work/pandas/pandas/coverage.xml info - 2025-02-23 02:40:32,005 -- Your upload is now processing. When finished, results will be available at: https://app.codecov.io/github/pandas-dev/pandas/commit/42c51ec8e4efc3c8a221625c92b22e2730b5fe7e info - 2025-02-23 02:40:32,331 -- Process Upload complete

Expected Behavior

na

Installed Versions

Replace this line with the output of pd.show_versions()

Comment From: Anurag-Varma

The deployment is not working and failing in few cases.

Attached the logs above and the run link

Comment From: StephenTanksley

Which version of Pandas are you using, @Anurag-Varma?

Comment From: Anurag-Varma

INSTALLED VERSIONS

commit : 6bcd30397d67c3887288c7a82c2c235ce8bc3c7f python : 3.10.14 python-bits : 64 OS : Windows OS-release : 10 Version : 10.0.26120 machine : AMD64 processor : AMD64 Family 23 Model 96 Stepping 1, AuthenticAMD byteorder : little LC_ALL : None LANG : None LOCALE : English_United States.1252

pandas : 3.0.0.dev0+1944.g6bcd30397d.dirty numpy : 1.26.4 dateutil : 2.9.0.post0 pip : 24.0 Cython : 3.0.10 sphinx : 7.3.7 IPython : 8.18.1 adbc-driver-postgresql: None adbc-driver-sqlite : None bs4 : 4.12.3 blosc : None bottleneck : None fastparquet : None fsspec : 2024.6.1 html5lib : 1.1 hypothesis : 6.105.0 gcsfs : 2024.6.1 jinja2 : 3.1.4 lxml.etree : None matplotlib : None numba : 0.61.0 numexpr : None odfpy : None openpyxl : 3.1.5 psycopg2 : None pymysql : 1.4.6 pyarrow : 19.0.0 pyreadstat : None pytest : 8.3.4 python-calamine : None pytz : 2025.1 pyxlsb : 1.0.10 s3fs : 2024.6.1 scipy : 1.15.2 sqlalchemy : 2.0.31 tables : None tabulate : 0.9.0 xarray : 2024.6.0 xlrd : 2.0.1 xlsxwriter : 3.2.0 zstandard : None tzdata : 2025.1 qtpy : None pyqt5 : None

Comment From: StephenTanksley

Execution failed on sql 'INSERT INTO test VALUES("foo", "bar", 1.234)': no such column: "foo"

Humor me here.

Try this:

INSERT INTO test (col_1, col_2, col_3) VALUES ("foo", "bar", 1.234)

Just replace column names as necessary.

Comment From: Anurag-Varma

Thanks @StephenTanksley

But I see many other also are getting this error:

link by @rhshadrach

link by @anzber

.... and few others in last 10hrs in actions tab

Comment From: StephenTanksley

I'll take a look.

Comment From: SaraInCode

I second that, facing similar errors in deployment #60990

Comment From: Anurag-Varma

@mroeschke still the issue is not fixed, it has new errors:

FAILED pandas/tests/apply/test_frame_apply.py::test_apply_raw_float_frame_lambda[numba-0] - AssertionError: Implementation function returned by `@overload` has an unexpected type.  Got <function mean at 0xff79df982f10>
FAILED pandas/tests/apply/test_frame_apply.py::test_apply_raw_float_frame_lambda[numba-1] - AssertionError: Implementation function returned by `@overload` has an unexpected type.  Got <function mean at 0xff79df982f10>
FAILED pandas/tests/window/test_expanding.py::test_expanding_apply_args_kwargs[engine_and_raw0] - AssertionError: Implementation function returned by `@overload` has an unexpected type.  Got <function mean at 0xff79df982f10>
= 3 failed, 2717 passed, 1916 skipped, 230544 deselected, 348 xfailed, 1 xpassed in 845.98s (0:14:05) =