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
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) =