[Spce-user] 500 Internal Server Error after uploading a .wave file
Irina Peshinskaya
ipeshinskaya at sipwise.com
Sun Nov 4 14:21:10 EST 2018
Hello Matthias,
I think now your 500 error on subscriber preferences page should disappear.
Could you please try to upload voicemailgreeting file that caused the issue?
If behavior will be the same, could you please share file with me?
Thank you again ).
Best regards,
Irina
On 2018-11-04 20:11, Hohl Matthias wrote:
>
> Hello again 😊
>
> MariaDB [(none)]> select id,from_unixtime(origtime),length(recording)
> from kamailio.voicemail_spool where
> dir='/var/spool/asterisk/voicemail/default/e893a9ab-28a3-48a0-8d5a-faebb297d286/unavail';
>
> +----+-------------------------+-------------------+
>
> | id | from_unixtime(origtime) | length(recording) |
>
> +----+-------------------------+-------------------+
>
> | 86 | 2018-10-10 19:43:27 | 3506 |
>
> | 87 | 2018-10-10 19:44:54 | 3506 |
>
> +----+-------------------------+-------------------+
>
> 2 rows in set (0.00 sec)
>
> MariaDB [(none)]>
>
> MariaDB [(none)]> delete from kamailio.voicemail_spool where id=87;
>
> Query OK, 1 row affected (0.01 sec)
>
> MariaDB [(none)]>
>
> MariaDB [(none)]> select id,from_unixtime(origtime),length(recording)
> from kamailio.voicemail_spool where
> dir='/var/spool/asterisk/voicemail/default/e893a9ab-28a3-48a0-8d5a-faebb297d286/unavail';
>
> +----+-------------------------+-------------------+
>
> | id | from_unixtime(origtime) | length(recording) |
>
> +----+-------------------------+-------------------+
>
> | 86 | 2018-10-10 19:43:27 | 3506 |
>
> +----+-------------------------+-------------------+
>
> 1 row in set (0.00 sec)
>
> MariaDB [(none)]>
>
> *Von:*Irina Peshinskaya <ipeshinskaya at sipwise.com>
> *Gesendet:* Sonntag, 4. November 2018 20:01
> *An:* Hohl Matthias <matthias.hohl at telematica.at>;
> spce-user at lists.sipwise.com
> *Betreff:* Re: AW: AW: [Spce-user] 500 Internal Server Error after
> uploading a .wave file
>
> 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>
> <mailto:ipeshinskaya at sipwise.com>
> *Gesendet:* Sonntag, 4. November 2018 10:29
> *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: 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/f146469c/attachment-0001.html>
More information about the Spce-user
mailing list