Thread 'Server/project setup - The storage engine for the table doesn't support descending indexes'

Message boards : Questions and problems : Server/project setup - The storage engine for the table doesn't support descending indexes
Message board moderation

To post messages, you must log in.

AuthorMessage
using_namespace

Send message
Joined: 4 Apr 20
Posts: 7
Message 97280 - Posted: 5 Apr 2020, 12:20:31 UTC
Last modified: 5 Apr 2020, 12:23:35 UTC

Hello, I hope everyone is safe these days.

I've set up set up the BOINC server by compiling the source code and using this guide: https://boinc.berkeley.edu/trac/wiki/ServerIntro
Then, according to https://boinc.berkeley.edu/trac/wiki/MakeProject I've tried to run:
./make_project --db_passwd xxx --test_app cplan


However, I got the following error:
boincadm@debian:~/boinc-src/tools$ ./make_project --delete_prev_inst --drop_db_first --db_passwd XXX --test_app cplan
Creating project 'cplan' (short name 'cplan'):
   PROJECT_ROOT = /home/boincadm/projects/cplan/
   PROJECT_HOST = debian
       URL_BASE = https://debian.debian/
  HTML_USER_URL = https://debian.debian/cplan/
   HTML_OPS_URL = https://debian.debian/cplan_ops/
        KEY_DIR = /home/boincadm/projects/cplan/keys/
        DB_NAME = cplan
        DB_HOST = 

Delete /home/boincadm/projects/cplan/?[y/N] y
Deleting /home/boincadm/projects/cplan/

Continue?[Y/n] y
Creating directories
Generating encryption keys
Copying files
failed to copy /home/boincadm/boinc-src/tools/db_query to /home/boincadm/projects/cplan/bin/db_query
failed to copy /home/boincadm/boinc-src/tools/watch_tcp to /home/boincadm/projects/cplan/bin/watch_tcp
Setting up database
Traceback (most recent call last):
  File "./make_project", line 234, in <module>
    project.install_project()
  File "/home/boincadm/boinc-src/py/Boinc/setup_project.py", line 612, in install_project
    drop_first = options.drop_db_first
  File "/home/boincadm/boinc-src/py/Boinc/database.py", line 291, in create_database
    _execute_sql_script(cursor, os.path.join(srcdir, 'db', file))
  File "/home/boincadm/boinc-src/py/Boinc/database.py", line 277, in _execute_sql_script
    cursor.execute(query)
  File "/usr/local/lib/python3.7/dist-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/usr/local/lib/python3.7/dist-packages/MySQLdb/cursors.py", line 315, in _query
    db.query(q)
  File "/usr/local/lib/python3.7/dist-packages/MySQLdb/connections.py", line 239, in query
    _mysql.connection.query(self, query)
MySQLdb._exceptions.OperationalError: (1178, "The storage engine for the table doesn't support descending indexes")


Do I need to use some specific version of MySQL or Python? I've been using the latest versions so far.
ID: 97280 · Report as offensive

Message boards : Questions and problems : Server/project setup - The storage engine for the table doesn't support descending indexes

Copyright © 2025 University of California.
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.