[Spce-user] 500 Internal Server Error after uploading a .wave file
Irina Peshinskaya
ipeshinskaya at sipwise.com
Sun Nov 4 14:01:25 EST 2018
Dear Matthias,
The last line is the reason of of the 500 response code. Normally, there
shouldn't be two "unavail" or "busy" records for one user. Panel use
proper call for data creation, but seems like some error occurred in the
library that Panel use during recording creation.
Could you please inspect your data further with query:
select id,from_unixtime(origtime),length(recording) from
kamailio.voicemail_spool where
dir='/var/spool/asterisk/voicemail/default/e893a9ab-28a3-48a0-8d5a-faebb297d286/unavail';
You will see data like this:
+----+-------------------------+-------------------+
| id | from_unixtime(origtime) | length(recording) |
+----+-------------------------+-------------------+
| 5 | 2018-11-04 09:45:12 | 3636 |
| 9 | 2018-11-04 09:45:12 | 0 |
+----+-------------------------+-------------------+
If you can point wrong record, kindly remove it with proper query:
delete from kamailio.voicemail_spool where id=INCORRECT_RECORD_ID;
INCORRECT_RECORD_ID should be replaced with value from the "id" column.
Best regards,
Irina Peshinskaya
On 2018-11-04 19:23, Hohl Matthias wrote:
>
> Hello,
>
> this is the result:
>
> MariaDB [(none)]> select
> `dir`,`mailboxcontext`,`mailboxuser`,`msgnum`,`origtime`,count(*) as
> cnt from kamailio.voicemail_spool group by dir having cnt>1;
>
> +------------------------------------------------------------------------------------+----------------+--------------------------------------+--------+------------+-----+
>
> | dir | mailboxcontext | mailboxuser | msgnum
> | origtime | cnt |
>
> +------------------------------------------------------------------------------------+----------------+--------------------------------------+--------+------------+-----+
>
> |
> /var/spool/asterisk/voicemail/default/15d95e8d-38a9-4e1f-9504-f3808d265081/INBOX
> | default | 15d95e8d-38a9-4e1f-9504-f3808d265081 | 0 |
> 1527060205 | 17 |
>
> |
> /var/spool/asterisk/voicemail/default/15d95e8d-38a9-4e1f-9504-f3808d265081/Old
> | default | 15d95e8d-38a9-4e1f-9504-f3808d265081 | 0 |
> 1522754696 | 3 |
>
> |
> /var/spool/asterisk/voicemail/default/522f1f30-5317-46ee-a4ef-0f3b8fbbe52f/INBOX
> | default | 522f1f30-5317-46ee-a4ef-0f3b8fbbe52f | 0 |
> 1515516247 | 28 |
>
> |
> /var/spool/asterisk/voicemail/default/56850236-a35d-40ec-9448-276004b63da2/INBOX
> | default | 56850236-a35d-40ec-9448-276004b63da2 | 0 |
> 1478708840 | 11 |
>
> |
> /var/spool/asterisk/voicemail/default/e893a9ab-28a3-48a0-8d5a-faebb297d286/unavail
> | default | e893a9ab-28a3-48a0-8d5a-faebb297d286 | -1 |
> 1539193407 | 2 |
>
> +------------------------------------------------------------------------------------+----------------+--------------------------------------+--------+------------+-----+
>
> 5 rows in set (0.02 sec)
>
> MariaDB [(none)]>
>
> *Von:*Irina Peshinskaya <ipeshinskaya at sipwise.com>
> *Gesendet:* Sonntag, 4. November 2018 10:29
> *An:* Hohl Matthias <matthias.hohl at telematica.at>;
> spce-user at lists.sipwise.com
> *Betreff:* Re: AW: [Spce-user] 500 Internal Server Error after
> uploading a .wave file
>
> Dear Matthias,
>
> Could you please check if you have duplicates in voicemal_spool table:
>
> select
> `dir`,`mailboxcontext`,`mailboxuser`,`msgnum`,`origtime`,count(*) as
> cnt from kamailio.voicemail_spool group by dir having cnt>1;
>
> Thank you in advance.
>
> Best regards,
> Irina Peshinskaya
>
> On 2018-10-16 10:08, Hohl Matthias wrote:
>
> Hello,
>
> i sent it to you private J
>
> thank you for your help.
>
> *Von:*Irina Peshinskaya <ipeshinskaya at sipwise.com>
> <mailto:ipeshinskaya at sipwise.com>
> *Gesendet:* Montag, 15. Oktober 2018 11:21
> *An:* Hohl Matthias <matthias.hohl at telematica.at>
> <mailto:matthias.hohl at telematica.at>; spce-user at lists.sipwise.com
> <mailto:spce-user at lists.sipwise.com>
> *Betreff:* Re: [Spce-user] 500 Internal Server Error after
> uploading a .wave file
>
> Dear Matthias,
>
> Could you please send me your log files from dates, related to the
> situation
> "The upload started but failed and next the customer saw a 500
> Internal Server Error screen"
>
> Necessary log files you can find as:
>
> /var/log/ngcp/old/panel.log-2018*.gz
> /var/log/ngcp/old/panel-debug.log-2018*.gz
> /var/log/ngcp/old/api.log-2018*.gz
>
> Thank you in advance.
>
> Best regards,
> Irina Peshinskaya
>
>
> On 2018-10-11 11:06, Hohl Matthias wrote:
>
> Hello,
>
> Server: mr5.5.5
>
> One of our customers wanted to upload a .wave file for the
> voicebox over his customer care panel.
>
> The upload started but failed and next the customer saw a 500
> Internal Server Error screen.
>
> The customer report this issue to us and we also get now a 500
> Internal Server Error if we want to open the subscriber
> preferences page.
>
> It is the only subscriber witch has this Error by accessing
> the prefences page. All other once work fine.
>
> In the panel.log and panel-debug.log I see this entries:
>
> 1.Oct1110:57:24spce ngcp-panel: ERROR: fatal error,
> id=155C821F96E17CC0, timestamp=2018-10-11T08:57:24.840824000Z,
> error=Caughtexception
> inNGCP::Panel::Controller::Subscriber->preferences "Not a HASH
> reference at
> /usr/share/perl5/NGCP/Panel/Controller/Subscriber.pm line 651."
>
> 2.
>
> 3.Oct1110:57:24spce ngcp-panel: DEBUG: *** Root::autogrant
> access forauthenticated user
>
> 4.Oct1110:57:24spce ngcp-panel: DEBUG:
> NGCP::Panel::Controller::Subscriber::auto
>
> 5.Oct1110:57:24spce ngcp-panel: DEBUG: catchup contract
> 324contract_balances (now = 2018-10-1110:57:24)
>
> Anybody an idea what is going on there and how to fix it?
>
> Mit freundlichen Grüßen,
>
> Matthias Hohl
>
>
>
>
>
> _______________________________________________
>
> Spce-user mailing list
>
> Spce-user at lists.sipwise.com <mailto:Spce-user at lists.sipwise.com>
>
> https://lists.sipwise.com/listinfo/spce-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20181104/108f41aa/attachment-0001.html>
More information about the Spce-user
mailing list