[db] sql: Scan error on column index 0, name \"SUM(Size)\": converting NULL to int64 is unsupported", mailpit | panic: runtime error: integer divide by zero

[alexszilagyi]

Hi there,

I have encountered the following issue:

mailpit         | time="2024/03/09 06:40:08" level=error msg="[db] sql: Scan error on column index 0, name \"SUM(Size)\": converting NULL to int64 is unsupported"
mailpit         | panic: runtime error: integer divide by zero
mailpit         | 
mailpit         | goroutine 6 [running]:
mailpit         | github.com/axllent/mailpit/internal/storage.dbCron()
mailpit         | 	/app/internal/storage/cron.go:30 +0x18f
mailpit         | created by github.com/axllent/mailpit/internal/storage.InitDB in goroutine 1
mailpit         | 	/app/internal/storage/database.go:94 +0x4a5
mailpit exited with code 2

It seems that the issues is somewhere at those lines:
https://github.com/axllent/mailpit/blob/develop/internal/storage/cron.go#L30

mailpit/internal/storage/migrations.go

Line 108 in bdea197

INSERT INTO settings (Key, Value) VALUES("DeletedSize", (SELECT SUM(Size)/2 FROM mailbox));`,

mailpit/internal/storage/settings.go

Line 56 in bdea197

Select("SUM(Size)").To(&result).

Any ideas how to fix this?

I am using the latest version of mailpit. axllent/mailpit:latest docker image, with the following config:

   image: axllent/mailpit:latest
    container_name: mailpit
    environment:
       - TZ=Europe/Bucharest
       - MP_DATA_FILE=/data/mailpit.db
       - MP_UI_BIND_ADDR=0.0.0.0:9025
       - MP_SMTP_BIND_ADDR=0.0.0.0:1025
       - MP_MAX_MESSAGES=0

[axllent]

Can you please tell me when this error happens... Is it immediately when Mailpit is started, or after running for 5 minutes?

[alexszilagyi]

@axllent I am using in a CI/CD pipeline, after a certain amount of time. Can’t tell you exactly sure. Definitely not immediately

[axllent]

I have just released a new version which should fix this error. Once you have updated it should be fairly easy to test - after 5 minutes of inactivity (ie: not using Mailpit) it runs a background process (which was crashing in your case). If Mailpit doesn't crash after 5 minutes of inactivity then it is fixed 👍

[alexszilagyi]

Thank you @axllent , I can confirm that its fixed in v1.14.3.