Hi ,please anyone can help check the logs , it is a paypal payment , buyer paid successfully, but order didn't confirm.
I added some logger out for paypal form and post, sensitive information has been replaced by xxxx or yyyy.
Hope someone can tell where maybe the problem.
2019-10-21 09:31:01,197 13367 ERROR myserver odoo.sql_db: bad query: b'UPDATE "sale_order" SET "fiscal_position_id"=3,"write_uid"=1,"write_date"=(now() at time zone \'UTC\') WHERE id IN (173)'
ERROR: could not serialize access due to concurrent update
2019-10-21 09:34:46,589 14179 WARNING myserver odoo.addons.payment_paypal.controllers.main: Beginning Paypal DPN form_feedback with post data
{'amt': '13.57',
'cc': 'EUR',
'cm': '{"return_url": "/payment/process"}',
'item_name': 'My Company: SO174-1',
'item_number': 'SO174-1',
'st': 'Completed',
'tx': '8Pxxxxxxxxx0T'}
2019-10-21 09:34:48,010 14179 WARNING myserver odoo.addons.payment_paypal.controllers.main: the resp message is -- SUCCESS
mc_gross=13.57
protection_eligibility=Eligible
address_status=confirmed
payer_id=P4xxxxxxxxxDN
tax=0.00
address_street=Gothaer+Str.+18
payment_date=02%3A34%3A38+Oct+21%2C+2019+PDT
payment_status=Completed
charset=windows-1252
address_zip=96487+
first_name=xxxx
mc_fee=0.95
address_country_code=DE
address_name=xxxx++yyyy
custom={%22return_url%22%3A+%22/payment/process%22}
payer_status=verified
business=xxxx%40hotmail.com
address_country=Germany
address_city=D%F6rfles-Esbach+
quantity=1
payer_email=xxxx%40web.de
txn_id=8Pxxxxxxxxx0T
payment_type=instant
last_name=yyyy
address_state=
receiver_email=xxxx%40hotmail.com
payment_fee=
shipping_discount=0.00
insurance_amount=0.00
receiver_id=NQxxxxxxxxxJ2
txn_type=web_accept
item_name=My+Company%3A+SO174-1
discount=0.00
mc_currency=EUR
item_number=SO174-1
residence_country=DE
shipping_method=Default
handling_amount=0.00
transaction_subject=
payment_gross=
shipping=0.00
2019-10-21 09:34:48,011 14179 WARNING myserver odoo.addons.payment_paypal.controllers.main: Paypal: validated data
2019-10-21 09:34:48,055 14179 ERROR myserver odoo.sql_db: bad query: b'UPDATE "payment_transaction" SET "state"=\'done\',"date"=\'2019-10-21 09:34:48\',"write_uid"=1,"write_date"=(now() at time zone \'UTC\') WHERE id IN (130)'
ERROR: could not serialize access due to concurrent update
2019-10-21 09:34:48,705 14179 WARNING myserver odoo.addons.payment_paypal.controllers.main: Beginning Paypal DPN form_feedback with post data
{'amt': '13.57',
'cc': 'EUR',
'cm': '{"return_url": "/payment/process"}',
'item_name': 'My Company: SO174-1',
'item_number': 'SO174-1',
'st': 'Completed',
'tx': '8Pxxxxxxxxx0T'}
2019-10-21 09:34:49,870 14179 WARNING myserver odoo.addons.payment_paypal.controllers.main: the resp message is -- SUCCESS
mc_gross=13.57
protection_eligibility=Eligible
address_status=confirmed
payer_id=P4xxxxxxxxxDN
tax=0.00
address_street=Gothaer+Str.+18
payment_date=02%3A34%3A38+Oct+21%2C+2019+PDT
payment_status=Completed
charset=windows-1252
address_zip=96487+
first_name=xxxx
mc_fee=0.95
address_country_code=DE
address_name=xxxx++yyyy
custom={%22return_url%22%3A+%22/payment/process%22}
payer_status=verified
business=david_zhongda%40hotmail.com
address_country=Germany
address_city=D%F6rfles-Esbach+
quantity=1
payer_email=xxxx%40web.de
txn_id=8Pxxxxxxxxx0T
payment_type=instant
last_name=Schmidt
address_state=
receiver_email=david_zhongda%40hotmail.com
payment_fee=
shipping_discount=0.00
insurance_amount=0.00
receiver_id=NQxxxxxxxxxJ2
txn_type=web_accept
item_name=My+Company%3A+SO174-1
discount=0.00
mc_currency=EUR
item_number=SO174-1
residence_country=DE
shipping_method=Default
handling_amount=0.00
transaction_subject=
payment_gross=
shipping=0.00
2019-10-21 09:34:49,871 14179 WARNING myserver odoo.addons.payment_paypal.controllers.main: Paypal: validated data
2019-10-21 09:34:49,905 14179 ERROR myserver odoo.addons.payment_paypal.controllers.main: Unable to validate the Paypal payment
Traceback (most recent call last):
File "/home/ubuntu/odoo/addons/payment_paypal/controllers/main.py", line 105, in paypal_dpn
res = self.paypal_validate_data(**post)
File "/home/ubuntu/odoo/addons/payment_paypal/controllers/main.py", line 79, in paypal_validate_data
res = request.env['payment.transaction'].sudo().form_feedback(post, 'paypal')
File "/home/ubuntu/odoo/addons/payment/models/payment_acquirer.py", line 952, in form_feedback
return getattr(tx, feedback_method_name)(data)
File "/home/ubuntu/odoo/addons/payment_paypal/models/payment.py", line 212, in _paypal_form_validate
self._set_transaction_done()
File "/home/ubuntu/odoo/addons/payment/models/payment_acquirer.py", line 726, in _set_transaction_done
raise ValidationError(_('Only draft/authorized transaction can be posted.'))
doo.exceptions.ValidationError: ('Only draft/authorized transaction can be posted.', None)
