Beancount file crashes Mac app

[scubed]

Describe your Environment OS: Mac Sonoma (silicon) Paisa Version: 0.6.3 App Variant: Desktop

Describe the bug Tried to open with my beancount file, which works fine and also in fava. Immediately crashes with this error:

Paisa has encountered a critical error and needs to close.
sql: converting argument $11 type: uint64 values with high bit set are not supported
File: /Users/runner/work/paisa/paisa/internal/model/posting/posting.go
Line: 123
Function:github.com/ananthakumaran/paisa/internal/model/posting.UpsertAll

The file that Paisa expects in Documents, is soft linked to my actual beancount file in another folder. Didn't want to have two copies floating around

[ananthakumaran]

would you be able to share a small ledger file that reproduces this issue? That would help me debug, without that it might be hard for me to figure out.

[scubed]

Hi could you tell me what you would need so I can prepare a small version. The original file is pretty big.

It has a mix of assets, liabilities, expense accounts. Also quite a few commodity and price directives and also beancount padding statements.

Thanks

On Tue, Jan 16, 2024 at 9:36 PM Anantha Kumaran @.***> wrote:

would you be able to share a small ledger file that reproduces this issue? That would help me debug, without that it might be hard for me to figure out.

— Reply to this email directly, view it on GitHub https://github.com/ananthakumaran/paisa/issues/146#issuecomment-1893758478, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAHBZL6TL5JFC2QU4PWMT5LYOZ67PAVCNFSM6AAAAABB4TTAN6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQOJTG42TQNBXHA . You are receiving this because you authored the thread.Message ID: @.***>

[ananthakumaran]

I would suggest running paisa (cli not desktop app) in debug mode PAISA_DEBUG=true paisa serve, this will start to print the SQL queries directly to the console. Likely, it will give some hint about the location of the transaction that's breaking the app.

[scubed]

Ok, will try with the CLI and send you the debug output

On Tue, Jan 16, 2024 at 10:57 PM Anantha Kumaran @.***> wrote:

I would suggest running paisa (cli not desktop app) in debug mode PAISA_DEBUG=true paisa serve, this will start to print the SQL queries directly to the console. Likely, it will give some hint about the location of the transaction that's breaking the app.

— Reply to this email directly, view it on GitHub https://github.com/ananthakumaran/paisa/issues/146#issuecomment-1893917290, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAHBZL2H72H3362ZJ6UO2W3YO2IO3AVCNFSM6AAAAABB4TTAN6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQOJTHEYTOMRZGA . You are receiving this because you authored the thread.Message ID: @.***>