BUG: ValueError: Buffer dtype mismatch, expected 'intp_t' but got 'long long' on ARMv7 32 bit

[scinteeb]

Pandas version checks

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

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

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

Reproducible Example

import pandas as pd

# Create a list of data
data = [["Alice", 25], ["Bob", 30], ["Carol", 35]]

# Create a Pandas DataFrame from the list of data
df = pd.DataFrame(data, columns=["Name", "Age"])

# Print the DataFrame
print(df)

Issue Description

The simplest test on a dataframe object is failing on an embedded 32bit device with ARMv7 CPU. No matter how the dataframe is created, from an array or read from a csv file using read_csv, access on the object fails the same:

File "pandas/_libs/internals.pyx", line 711, in pandas._libs.internals.BlockManager._rebuild_blknos_and_blklocs
ValueError: Buffer dtype mismatch, expected 'intp_t' but got 'long long'

Unfortunately, on that platform I cannot compile a newer version of pandas, so I cannot verify if the issue is present in the latest version or main branch.

Expected Behavior

The expected output is:
Name Age
0 Alice 25
1 Bob 30
2 Carol 35

but running the script is giving:
File "/home/root/test.py", line 10, in
print(df)
File "/usr/lib/python3.10/site-packages/pandas/core/frame.py", line 1011, in repr
return self.to_string(**repr_params)
File "/usr/lib/python3.10/site-packages/pandas/core/frame.py", line 1192, in to_string
return fmt.DataFrameRenderer(formatter).to_string(
File "/usr/lib/python3.10/site-packages/pandas/io/formats/format.py", line 1128, in to_string
string = string_formatter.to_string()
File "/usr/lib/python3.10/site-packages/pandas/io/formats/string.py", line 25, in to_string
text = self._get_string_representation()
File "/usr/lib/python3.10/site-packages/pandas/io/formats/string.py", line 40, in _get_string_representation
strcols = self._get_strcols()
File "/usr/lib/python3.10/site-packages/pandas/io/formats/string.py", line 31, in _get_strcols
strcols = self.fmt.get_strcols()
File "/usr/lib/python3.10/site-packages/pandas/io/formats/format.py", line 611, in get_strcols
strcols = self._get_strcols_without_index()
File "/usr/lib/python3.10/site-packages/pandas/io/formats/format.py", line 864, in _get_strcols_without_index
str_columns = self._get_formatted_column_labels(self.tr_frame)
File "/usr/lib/python3.10/site-packages/pandas/io/formats/format.py", line 943, in _get_formatted_column_labels
dtypes = self.frame.dtypes
File "/usr/lib/python3.10/site-packages/pandas/core/generic.py", line 5746, in dtypes
data = self._mgr.get_dtypes()
File "/usr/lib/python3.10/site-packages/pandas/core/internals/managers.py", line 228, in get_dtypes
return dtypes.take(self.blknos)
File "/usr/lib/python3.10/site-packages/pandas/core/internals/managers.py", line 168, in blknos
self._rebuild_blknos_and_blklocs()
File "pandas/_libs/internals.pyx", line 711, in pandas._libs.internals.BlockManager._rebuild_blknos_and_blklocs
ValueError: Buffer dtype mismatch, expected 'intp_t' but got 'long long'

Installed Versions

INSTALLED VERSIONS

---

commit : 4bfe3d0
python : 3.10.4.final.0
python-bits : 32
OS : Linux
OS-release : 5.15.32-yoctoEMB+gddbcf3882cd3
Version : #1 SMP PREEMPT Thu Apr 13 04:27:17 UTC 2023
machine : armv7l
processor : armv7l
byteorder : little
LC_ALL : None
LANG : None
LOCALE : None.None

pandas : 1.4.2
numpy : 1.22.3
pytz : 2022.1
dateutil : 2.8.2
pip : 22.0.3
setuptools : 59.5.0
Cython : 0.29.28
pytest : 7.1.1

[scinteeb]

Hey all! any feedback will be appreciated.
Thanks

[mweitner]

Hi scinteeb,
I am facing exact same issue with Embedded Linux system build by Yocto 4,0 (kirkstone) running on armv7 32bit target. I have setup test environment on RaspberryPi 4 32bit.
My test is the spearman correlation test see also:

• closed BUG: Spearman correlation is broken... on 32-bit platforms

When installing 64bit it works fine. When using 32bit it fails.

OS details:

root@raspberrypi4:~# uname -a
Linux raspberrypi4 5.15.34-v7l #1 SMP Tue Apr 19 19:21:26 UTC 2022 armv7l GNU/Linux

Installed Versions

root@raspberrypi4:~# python3 --version
Python 3.10.13

root@raspberrypi4:~# ls -lsa /usr/lib/liblapack.so.3
     /usr/lib/liblapack.so.3 -> liblapack.so.3.10.0

root@raspberrypi4:~# python3
Python 3.10.13 (main, Aug 24 2023, 12:59:26) [GCC 11.4.0] on linux
>>> import numpy as np
>>> np.__version__
'1.22.3'
>>> import scipy as sc
>>> sc.__version__
'1.8.1'
>>> import pandas as pd
>>> pd.__version__
'1.4.2'

Reproducible Example

 import pandas as pd
 d = pd.DataFrame([1.0, 2.0])
 d.corr(method='spearman')
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/lib/python3.10/site-packages/pandas/core/frame.py", line 1011, in __repr__
    return self.to_string(**repr_params)
  File "/usr/lib/python3.10/site-packages/pandas/core/frame.py", line 1192, in to_string
    return fmt.DataFrameRenderer(formatter).to_string(
  File "/usr/lib/python3.10/site-packages/pandas/io/formats/format.py", line 1128, in to_string
    string = string_formatter.to_string()
  File "/usr/lib/python3.10/site-packages/pandas/io/formats/string.py", line 25, in to_string
    text = self._get_string_representation()
  File "/usr/lib/python3.10/site-packages/pandas/io/formats/string.py", line 40, in _get_string_representation
    strcols = self._get_strcols()
  File "/usr/lib/python3.10/site-packages/pandas/io/formats/string.py", line 31, in _get_strcols
    strcols = self.fmt.get_strcols()
  File "/usr/lib/python3.10/site-packages/pandas/io/formats/format.py", line 611, in get_strcols
    strcols = self._get_strcols_without_index()
  File "/usr/lib/python3.10/site-packages/pandas/io/formats/format.py", line 864, in _get_strcols_without_index
    str_columns = self._get_formatted_column_labels(self.tr_frame)
  File "/usr/lib/python3.10/site-packages/pandas/io/formats/format.py", line 943, in _get_formatted_column_labels
    dtypes = self.frame.dtypes
  File "/usr/lib/python3.10/site-packages/pandas/core/generic.py", line 5746, in dtypes
    data = self._mgr.get_dtypes()
  File "/usr/lib/python3.10/site-packages/pandas/core/internals/managers.py", line 228, in get_dtypes
    return dtypes.take(self.blknos)
  File "/usr/lib/python3.10/site-packages/pandas/core/internals/managers.py", line 168, in blknos
    self._rebuild_blknos_and_blklocs()
  File "pandas/_libs/internals.pyx", line 711, in pandas._libs.internals.BlockManager._rebuild_blknos_and_blklocs
ValueError: Buffer dtype mismatch, expected 'intp_t' but got 'long long'

Expected Behavior

>>> d = pd.DataFrame([1.0, 2.0])
>>> d.corr(method='spearman')
     0
0  1.0

I will try to dive further into this issue ... and let you know about any news...
As I am quit new to pandas project I appreciate any help
Michael

[scinteeb]

    Hello Michael,

My target device is an embedded unit with scarce storage resources. That's why I cannot do much testing on it.
What I did was to create a virtual ARMv7 32bit system using qemu and in there I did the following experiment:

1. install python3.10
2. install build-essential tools
3. using pip3 install numpy v1.22.3 and pandas v1.4.2
4. run the testing
   What I found was that when the numpy and pandas were installed using pip3 (practically compiled on the target) everything worked fine. So i guess that the issue is the compiling environment in Kirkstone.
   If you have time, maybe you ca try on the PaspberryPi unit that you have to install the numpy and pandas as I did and check the functionality. If is working in your case as well, this proves the assumption that Yocto's compiling environment is the issue as we can focus in finding the issue there.
   Good luck,
   Bogdan.

[avan051]

hello Bogdan,
I have the same problem as you, and I would like to consult with you. Has your problem been resolved? How was it ultimately resolved?
Thank you very much for seeing my message and providing assistance. Thank you.
happy everyday for you...

My records are as follows：

1.errors：
Traceback (most recent call last):
File "pyabcs", line 952, in _thread_loop
if func(loopcnt=cnt, looptime=t - t0, loopintv=t - tlst) if fargs else func():
File "mdc_equip", line 140, in loop_mdcboard
self.mdc_board()
File "npm_tpj", line 450, in mdc_board
if self.parse_data(data_html, lane, folder):
File "npm_tpj", line 589, in parse_data
platform_p = platform_pickup[platform_pickup['Machine Order']==str(seq)].sum()
File "generic", line 10709, in sum
self, axis, skipna, level, numeric_only, min_count, **kwargs
File "generic", line 10447, in sum
"sum", nanops.nansum, axis, skipna, level, numeric_only, min_count, **kwargs
File "generic", line 10434, in _min_count_stat_function
min_count=min_count,
File "frame", line 9852, in _reduce
res, _ = df._mgr.reduce(blk_func, ignore_failures=ignore_failures)
File "managers", line 1290, in reduce
new_mgr = self._combine(res_blocks, copy=False, index=index)
File "managers", line 555, in _combine
inv_indexer = lib.get_reverse_indexer(indexer, self.shape[0])
File "lib", line 484, in pandas._libs.lib.get_reverse_indexer
ValueError: Buffer dtype mismatch, expected 'const intp_t' but got 'long long'

2.INSTALLED VERSIONS
python : 3.7.2
OS : Ubuntu 16.04.4 LTS
machine : armv7l
pandas : 1.3.3
numpy : 1.21.6

3.Cross compiler = arm-linux-gnueabihf-gcc

4.Example of target library files for partial cross compilation,name as :
algos.cpython-37m-arm-linux-gnueabihf.so
lib.cpython-37m-arm-linux-gnueabihf.so
.........
etc.

[mweitner]

Hi Bogdan,
just did the verification on Raspberry 4 (32bit) official Debian Bullseye OS (32bit):

pi@sheep:~$ getconf LONG_BIT
32
pi@sheep:~$ file /lib/systemd/systemd
/lib/systemd/systemd: ELF 32-bit LSB pie executable, ARM, EABI5 version 1 (SYSV), \
  dynamically linked, interpreter /lib/ld-linux-armhf.so.3, \
  BuildID[sha1]=c8e472c9a12568fbde5035980497ffc8e4a857cd, for GNU/Linux 3.2.0, \
  stripped

The test was successful:

>>> d = pd.DataFrame([1.0, 2.0])
>>> d.corr(method='spearman')
     0
0  1.0

Installed Versions:

(venv) pi@sheep:~ $ python
Python 3.10.13 (main, Oct  9 2023, 15:41:20) [GCC 10.2.1 20210110] on linux
>>> import pytz as pt
>>> pt.__version__
'2023.3.post1'
>>> import dateutil as dt
>>> dt.__version__
'2.8.2'
>>> import six as x
>>> x.__version__
'1.16.0'
>>> import numpy as np
>>> np.__version__
'1.22.3'
>>> import pandas as pd
>>> pd.__version__
'1.4.2'

So it seems Yocto kirkstone might compile numpy, pandas, ... not properly for 32bit... By the way I have backported down to gatesgarth where I did not fiind working setup either numpy and pandas are not compatible or 32bit error occurs.

That means we might need to find out the magic setting (options) for cross compiling numpy, pands...

@avan051 it seems your cross compiler or options on Ubuntu (32bit) are also missing some magic settings

[avan051]

@mweitner
ok，thanks for your reply！
BTW, the same configuration is okay for me to run on an ubuntu for x86 platform。
but ,cross compiler to arm,is not okay.

[scinteeb]

  Hello Michael,

There are two more tests that we can do to narrow down further the issue. I am planning to run them tomorrow or a day after tomorrow after I'll build a qemu image.
If you have time the tests are quite simple:

1. install on the rasp device the Yocto rpm for numpy and install the pandas with pip3 and run the test
2. install on the rasp device the Yocto rpm for pandas and the numpy with pip3 and run the test
   Before each test we need to uninstall the numpy and pandas either by pip3 or rpm depending on how they were installed.

We might see that only module compiled by Yocto is causing the problem so we'll focus on that one.

[mweitner]

Hi Bogdan,
it seems Yocto build of pandas is the bad one as tested Test 1. successfully:

• numpy==1.22.3 installed by yocto

pandas==1.4.2 installed by pip3 on target

root@raspberrypi4:~# pip3 install pandas==1.4.2 --no-use-pep517 -vvv
...
  Running setup.py install for pandas ... done
Successfully installed pandas-1.4.2 python-dateutil-2.8.2 pytz-2023.3.post1 six-1.16.0

Verification:

>>> import numpy as np
>>> np.__version__
'1.22.3'
>>> import pandas as pd
>>> pd.__version__
'1.4.2'
>>> d = pd.DataFrame([1.0, 2.0])
>>> d.corr(method='spearman')
     0
0  1.0

[mweitner]

I will dive further into how Yocto build compiles python3-pandas package and what is the difference between on-target pip build and Yocto cross compile build?

So far I identified Options missing on Yocto build:

-pipe -feliminate-unused-debug-types \
-DHAVE_BROKEN_POSIX_SEMAPHORES \
-feliminate-unused-debug-types \
-fPIC -DNPY_NO_DEPRECATED_API=0

However adding those to TOOLCHAIN_OPTIONS in order to have them at cross compiler CC did not help.

Is there anyone who knows pip build process of pandas to identify the missing/wrong option, parameter, libary link, etc?

[scinteeb]

While I am building the qemu image, I kept looking at the source code. I believe that the the issue is coming from the mismatch definition of the intp_t type in pandas, numpy AND cython, definitely caused by some compiling parameter in Yocto. I guess that in one (or more) recipe the architecture is not properly detected using 64-bit platform instead of 32-bit.
Also, checking out the WHEEL in the dist-info folder for the packages (i.e./usr/lib/python3.10/site-packages/pandas-1.4.2.dist-info/WHEEL) , I found that numpy/pandas/cython are having the tag:
Tag: cp310-cp310-linux_x86_64
which means that the compatibility platform is x86_64. For the rest of the packages the Tag is py2-none-any or py3-none-any.
Can you please check on your unit after pandas was installed with pip command, what that WHEEL file contain?

[mweitner]

Hi Bogdan, just stumbled over issue labels ... it could make sense we tag this issue with following labels:

• 32bit 32-bit systems
• ARM aarch64 architecture (is dedicated to aarm64 but at least we have arm context)
• Build Library building on various platforms (dedicated to build for several platforms)
• unfortunately there is not yocto label or embedded target label

This might help to get more visible with our issue
Anyway I come back with pending verification of WHEEL details sorry takes some more time as I forgot to tell pip not to cleanup build ;-)

[mweitner]

by the way I am a bit worried for the future supporting arm 32bit target using pandas or even Data science python3 eco system as there seems to be a lot going on decreasing project effort by removing 32bit support in future see open issue:

• BLD: remove support for 32 bit #44453

[mweitner]

Back to technical issue.. I might have found a track while forced rebuilding of pandas by pip I see there might be no wheel support for arm 32 bit "anymore" ... as it downloads tar with egg-info. If you follow Issue #44453 discussion it mentions that numpy project has dropped 32bit wheel support...

Yocto build of our numpy version has wheel support but 64 bit tag:

root@raspberrypi4:~# cat /usr/lib/python3.10/site-packages/numpy-1.22.3.dist-info/WHEEL
Wheel-Version: 1.0
Generator: bdist_wheel (0.37.1)
Root-Is-Purelib: false
Tag: cp310-cp310-linux_x86_64

It looks like when pip install pandas on target it compiles it dependency numpy again with 32bit arm support...

pandas installed on-target by pip:

root@raspberrypi4:~# find / -iname "*pandas*"
/usr/lib/python3.10/site-packages/pandas
/usr/lib/python3.10/site-packages/pandas/tests/io/json/__pycache__/test_pandas.cpython-310.pyc
/usr/lib/python3.10/site-packages/pandas/tests/io/json/test_pandas.py
/usr/lib/python3.10/site-packages/pandas-1.4.2-py3.10.egg-info

Forced pip reinstall pending:

/tmp/pip-pip-egg-info-dhmxqt13/pandas.egg-info
/tmp/pip-unpack-a4zhymls/pandas-1.4.2.tar.gz
/tmp/pip-install-n6aoumqy/pandas_89a387b3cfdf47d993fe5881fcff294b
/tmp/pip-install-n6aoumqy/pandas_89a387b3cfdf47d993fe5881fcff294b/pandas.egg-info
/tmp/pip-install-n6aoumqy/pandas_89a387b3cfdf47d993fe5881fcff294b/pandas
/tmp/pip-install-n6aoumqy/pandas_89a387b3cfdf47d993fe5881fcff294b/pandas/tests/io/json/test_pandas.py
/tmp/pip-install-n6aoumqy/pandas_89a387b3cfdf47d993fe5881fcff294b/doc/source/_static/css/pandas.css

Interesting is on a forced-reinstall I get build error on target telling me can not build with --no-use-pep517 option as using meson build backend... When building without --no-use-pep517 option it build successfully. In addition, it creates a numpy wheel file for numpy==1.22.6 for arm 32 bit.

That proofs the guess above is right, the pip install pandas on target builds wheel file for latest supporting numpy==1.21.6 compiled for arm 32bit:

root@raspberrypi4:~# cat \
  /usr/lib/python3.10/site-packages/numpy-1.22.3.dist-info/WHEEL
Wheel-Version: 1.0
Generator: bdist_wheel (0.37.1)
Root-Is-Purelib: false
Tag: cp310-cp310-linux_x86_64

root@raspberrypi4:~# cat \
  /tmp/pip-build-env-h3yyacej/overlay/lib/python3.10/site-packages/numpy-1.21.6.dist-info/WHEEL
Wheel-Version: 1.0
Generator: bdist_wheel (0.37.0)
Root-Is-Purelib: false
Tag: cp310-cp310-linux_armv7l

Solution

Solution of our problem should be to adapt all relevant python3 packages recipes of Yocto to build arm 32 bit wheel files.

Another example when Yocto builds and installs Cython (python3-cython) compared to on target pip install:

root@raspberrypi4:~# cat /usr/lib/python3.10/site-packages/Cython-0.29.28.dist-info/WHEEL
Wheel-Version: 1.0
Generator: bdist_wheel (0.37.1)
Root-Is-Purelib: false
Tag: cp310-cp310-linux_x86_64

root@raspberrypi4:~# cat /tmp/pip-build-env-h3yyacej/overlay/lib/python3.10/site-packages/Cython-0.29.36.dist-info/WHEEL
Wheel-Version: 1.0
Generator: bdist_wheel (0.40.0)
Root-Is-Purelib: true
Tag: py2-none-any
Tag: py3-none-any