sqlite3.IntegrityError: UNIQUE constraint failed: battery.start_at

[miga97]

Describe the bug
The recharge table has not been updated for a few days, everything else is fine

To Reproduce
Steps to reproduce the behavior:

1. what command did you use: None
2. when the bug append ? Every 2m
3. Does it persist after restarting the program? Yes
4. Does it persist after recreate config by going to http://server_address:port/config? Yes

Config file

Environment:

• OS: docker on linux
• Brand and model of car: e-2008
• Application version: v3.5.6

Additional context

today is the 4th of july and i have recharged the car several times but it doesn't appear in the table anymore. the peugeot app is working now without any problems, after a day that it had stopped working all day

[yfands]

Same here, stopped at 30/06/2025, refresh button has no effect, same sqlite3.IntegrityError VALUES are empty.

http://192.168.xxx.xxx:5000/get_vehicleinfo/myvinnumber shows:
Internal Server Error

The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.
edit: 07-11-2025, the internal server error issue is resolved somehow, guess that was 'something' locally.
But the error updated_at "2025-06-30 21:03:50+00:00" stays

Regards Frank

[nippmi]

Same here.

Also in get_vechileinfo shows: (4 times charged after that time.)
"energy": [
{
"updated_at": "2025-06-30 16:34:17+00:00",

Another Vechileinfo updated if car or phone app make update.

Opel Grandland GS Electric (STLA M based)
3.5.6 in Ubuntu.

[miga97]

Same here, stopped at 30/06/2025, refresh button has no effect, same sqlite3.IntegrityError VALUES are empty.

http://192.168.xxx.xxx:5000/get_vehicleinfo/myvinnumber shows: Internal Server Error

The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.

Regards Frank

my get_vehicleinfo works, but i have the same problem as @nippmi

The data is up to date, but the date is not. Also this does not allow the car to stop at the threshold

[show2go]

Hello, i am using the Home Assistant Addon 3.5.3 (3.5.6 hasnt worked for me) with my Opel Zafire e-life, and am a very happy user of this addon since years! Thank you all so much.
But since 30th of June i have the same behavior/error as above.
Everything is working as soon the car begins to charge, then all of the sensors go to unavailable, and no charge log is written. Also the refresh button does not work, and the last update date is 30th of June.

here ist mylog:

2025-07-08 13:39:30,751 :: INFO :: 192.168.xxx.xxx - - [08/Jul/2025 13:39:30] "�[35m�[1mGET /get_vehicleinfo/xxxxxxxxxxxxxxxxxxx HTTP/1.1�[0m" 500 -
2025-07-08 13:39:30,756 :: INFO :: <Request 'http://192.168.xxx.xxx:5000/charge_control?vin=xxxxxxxxxxxxxxxxxxx&%3Falways_check=true' [GET]>
2025-07-08 13:39:30,760 :: INFO :: 192.168.xxx.xxx - - [08/Jul/2025 13:39:30] "�[37mGET /charge_control?vin=xxxxxxxxxxxxxxxxxxx&?always_check=true HTTP/1.1�[0m" 200 -
2025-07-08 13:39:39,920 :: ERROR :: refresh_vehicle_info:
Traceback (most recent call last):
File "/usr/local/lib/python3.9/dist-packages/psa_car_controller/psacc/application/psa_client.py", line 128, in __refresh_vehicle_info
self.get_vehicle_info(car.vin)
File "/usr/local/lib/python3.9/dist-packages/psa_car_controller/psacc/application/psa_client.py", line 111, in get_vehicle_info
self.record_info(car)
File "/usr/local/lib/python3.9/dist-packages/psa_car_controller/psacc/application/psa_client.py", line 207, in record_info
Charging.record_charging(car, charging_status, charge_date, level, latitude, longitude,
File "/usr/local/lib/python3.9/dist-packages/psa_car_controller/psacc/application/charging.py", line 69, in record_charging
conn.execute("INSERT INTO battery(start_at,start_level,charging_mode,VIN,mileage) VALUES(?,?,?,?,?)",
sqlite3.OperationalError: database is locked
2025-07-08 13:40:25,570 :: ERROR :: Exception on /get_vehicleinfo/xxxxxxxxxxxxxxxxxxx [GET]
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/flask/app.py", line 2447, in wsgi_app
response = self.full_dispatch_request()
File "/usr/lib/python3/dist-packages/flask/app.py", line 1952, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/lib/python3/dist-packages/flask/app.py", line 1821, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/lib/python3/dist-packages/flask/_compat.py", line 39, in reraise
raise value
File "/usr/lib/python3/dist-packages/flask/app.py", line 1950, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/lib/python3/dist-packages/flask/app.py", line 1936, in dispatch_request
return self.view_functionsrule.endpoint
File "/usr/local/lib/python3.9/dist-packages/psa_car_controller/web/view/api.py", line 48, in get_vehicle_info
response=json.dumps(APP.myp.get_vehicle_info(vin, from_cache).to_dict(), default=str),
File "/usr/local/lib/python3.9/dist-packages/psa_car_controller/psacc/application/psa_client.py", line 111, in get_vehicle_info
self.record_info(car)
File "/usr/local/lib/python3.9/dist-packages/psa_car_controller/psacc/application/psa_client.py", line 207, in record_info
Charging.record_charging(car, charging_status, charge_date, level, latitude, longitude,
File "/usr/local/lib/python3.9/dist-packages/psa_car_controller/psacc/application/charging.py", line 69, in record_charging
conn.execute("INSERT INTO battery(start_at,start_level,charging_mode,VIN,mileage) VALUES(?,?,?,?,?)",
sqlite3.IntegrityError: UNIQUE constraint failed: battery.start_at

as soon the charging is stopped, all sensors come back with actual data.

But the most important for using this Programm, it cant stop charging at given treshhold anymore :(

i saw that they have fixed this issue in #1096 , but i guess it needs an update of the Addon for Home assistant?

Am i right, that if i would install the programm on a Linux machine with pip3 all latest contributions, commits or fixes would be useable immediatelly by updating from git? (as you can see i am not so used to this world of programming, maybe someone could explain this to me)

I mostly wanted to let the programmers know, that i love this program, and i am using it heavily, and if i can assist with further information, i would love to help!

Thank you all so much!
Greetings from Austria

[Trebila]

same issue for me.
very annoying issue as it block the update of battery level during charging sessions, so no more limitation to 80%.
waiting for a new release, as I use PSACC in a docker on Debian.
#1096

[zazazouthecat]

same isssue

[tkroon89]

Same issue