Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MonetDB server crashes in bin_find_smallest_column #7482

Closed
fuboat opened this issue Mar 17, 2024 · 0 comments
Closed

MonetDB server crashes in bin_find_smallest_column #7482

fuboat opened this issue Mar 17, 2024 · 0 comments
Assignees
Labels
bug Something isn't working

Comments

@fuboat
Copy link

fuboat commented Mar 17, 2024

Describe the bug
MonetDB server crashes in bin_find_smallest_column.

To Reproduce

SELECT var_samp ( '12' ) OVER ( ORDER BY CAST ( ( CASE WHEN ( 99 ) THEN COUNT ( * ) ELSE CASE WHEN 1 THEN ( FALSE ) END END ) AS BIGINT ) );

Backtrace of the Crash

#0 0x7fb8fa8b4ebf (bin_find_smallest_column+0x4f)
#1 0x7fb8fa8ad3e2 (exp_bin+0xff2)
#2 0x7fb8fa8bb289 (subrel_bin+0x5d69)
#3 0x7fb8fa8c34c9 (rel2bin_project+0x1f9)
#4 0x7fb8fa8b61dc (subrel_bin+0xcbc)
#5 0x7fb8fa8c34c9 (rel2bin_project+0x1f9)
#6 0x7fb8fa8b61dc (subrel_bin+0xcbc)
#7 0x7fb8fa8c34c9 (rel2bin_project+0x1f9)
#8 0x7fb8fa8b61dc (subrel_bin+0xcbc)
#9 0x7fb8fa8c34c9 (rel2bin_project+0x1f9)
#10 0x7fb8fa8b61dc (subrel_bin+0xcbc)
#11 0x7fb8fa8b53b9 (output_rel_bin+0xb9)
#12 0x7fb8fa901a59 (backend_dumpstmt_body+0x2c9)
#13 0x7fb8fa9016a2 (backend_dumpstmt+0x192)
#14 0x7fb8fa89d184 (SQLparser+0xf04)
#15 0x7fb8fa89ba0a (SQLengine_+0xa5a)
#16 0x7fb8fa8991fe (SQLengine+0x3e)
#17 0x7fb8fae1db2f (runScenario+0x6f)
#18 0x7fb8fae1ecfe (MSscheduleClient+0xb6e)
#19 0x7fb8faf626c2 (doChallenge+0x132)
#20 0x7fb8fbd7fb38 (thread_starter+0x318)
#21 0x7fb8fa790609 (start_thread+0xd9)
#22 0x7fb8fa6b3353 (clone+0x43)

Software versions

  • MonetDB version number: v11.49.1 (Dec2023)
  • OS and version: Ubuntu 20.04
  • From docker image monetdb/monetdb:Dec2023 (or monetdb/dev-builds:default)

An example of steps to reproduce in docker container (write the poc into /tmp/test.sql first):

docker container rm monetdb_test -f
docker run -e MDB_DB_ADMIN_PASS=monetdb --name monetdb_test -itd monetdb/monetdb:Dec2023
docker exec monetdb_test bash -c 'echo -n -e "user=monetdb\npassword=monetdb\n" > /root/.monetdb'

sleep 10
cat /tmp/test.sql | timeout 5s docker exec -i monetdb_test mclient monetdb     # run test case

if docker exec monetdb_test bash -c "grep '[m]server5' /proc/*/cmdline -lR"; then
    echo "[INFO] Server normal."
else
    echo "[CRASH] Mserver5 process does NOT exist."
fi

It can also be reproduced on the docker image monetdb/dev-builds:default.

Issue labeling
bug

@mvdvm mvdvm added the bug Something isn't working label Mar 20, 2024
monetdb-team pushed a commit that referenced this issue Mar 20, 2024
@njnes njnes self-assigned this May 15, 2024
@njnes njnes added this to the NEXTFEATURERELEASE milestone May 15, 2024
@njnes njnes closed this as completed May 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants