DAP 1.0.0 syncdb error in PostgreSQL - table not initialized, use "initdb"

I used the initdb command to create a table. The table is created successfully with some data. Then when I try to use the syncdb command the following error appears:

INFO:pysqlsync.postgres:PostgreSQL version 16.0.2 final
2024-03-06 15:48:52,993 - ERROR - table not initialized, use `initdb`

Has anyone seen this error and know how to resolve it?

Find more posts tagged with

Accepted answers

All comments

Robert Sznyida

Hi @bruno_guimaraes,

there is an ongoing discussion here with StevenWalls (he brought it up in the comments section), he has an issue that sounds similar to yours. It is specific to the environment (operating system and python version).

In short, `syncdb` doesn't work if there was some failure during `initdb`. So it would be helpful to see the output of the `initdb` command that you previously executed. And knowing the operating system and Python version would be also helpful.

If you had the same error during `initdb` as what StevenWalls had ("Fatal Python error: none_dealloc: deallocating None"), AND you are using Python version lower than 3.12 on Windows, then my suggestion is upgrading your Python version to 3.12, if that is an option for you, while we analyze the issue further.

It is likely that your database is an inconsistent state now, so before retrying the `initdb` again, you need to drop the one specific table that is being initialized.

Let us know if this was helpful or you need further assistance.

michael60

Hi Bruno,

I am also having this issue with Python 3.12 and Postres 16.02 on Windows Server 2016.

-M

michael60

Thanks. I installed 1.1.0 and removed DAP schemas from Postgres and tried initdb again on accounts. It states success but no data in canvas.accounts table:

2024-03-25 14:02:15,028 - INFO - Data has been successfully retrieved:
{"id": "6debc9ad-e2ce-4550-9109-e0b3cd34565f", "status": "complete", "expires_at": "2024-03-26T17:59:08Z", "objects": [{"id": "6debc9ad-e2ce-4550-9109-e0b3cd34565f/part-00000-55d0211c-293b-461c-8c18-e113049a2fe3-c000.tsv.gz"}], "schema_version": 2, "at": "2024-03-25T16:42:05Z"}

Maybe I need Windows 11:-(??

michael60

Attached is my dap log ater running this:
>dap --loglevel debug --logfile c:\temp\dap.log initdb --connection-string postgresql://xxxxxxxxxx@localhost:5432/postgres --namespace canvas --table accounts

NoorRashid

Yes, I got this too!

Update to the new stable release and reinitialise the db, should work!

Unanswered Questions

EDUCAUSE Insights: Data and Decision-Making
EDUCAUSE is full of inspiration, whether you’re onsite or following from afar. Join the evolution by sharing what sparks your curiosity, the questions you have, and the insights you discover. We'll learn from each other, expand our networks, and strengthen our Community. Your perspective matters, and the more we share,…
Problems with GraphQL in User Pageviews reports
Prompted by the most recent Canvas release notes, we looked into the Page Views feature, and we were happy with the new documented changes. However, we notice that more user actions are done by GraphQL API, which does not provide details in the page view report, either in the GUI or in the CSV file download. We and most…
Metrics Easy Button
I am currently teaching five courses this semester with more than 70 students. To track their progress, I currently have to review each course and section individually, which is very time-consuming. Ideally, I would like to consolidate key information for all students into a single Excel file—showing class attendance…
Analytics API / Metrics calculation logic
Hello, We are currently using the Analytics API provided in the Instructure Developer Documentation Portal to retrieve certain metrics-related data. We would like to know if it’s possible to replicate these datasets using the Canvas Data Platform (CDP), instead of relying on API calls. For example, could you please advise…
CD2: Enhanced Rubrics
Is there a way to tell via CD2 if a course is using Enhanced Rubrics? I didn't see it in the entity diagram for Rubrics table, but I might have missed something... Thanks Ian