Author Topic: Database Errors  (Read 655 times)

PHAZE FM

  • Jr. Member

  • Offline
  • **
  • 99
    • PHAZE FM
Database Errors
« on: January 11, 2019, 02:15:44 PM »
Hey Folks,

Can someone point me in the right direction to fix this issue, i have checked permissions and its not that so it has to be something from when i dumped the database and moved it to another server and re-imported it.

Database Insert Error: Illegal argument to a regular expression. (CALL UpdateTracks(8398,0,0,0,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[:<:]]David Guetta[[:>:]]';UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[:<:]]Sia[[:>:]]';)
Regards,

Matthew Matters
Station Manager
PHAZE FM Radio Network

info@phazefm.com.au
+61 (3) 53105953

LISTEN LIVE --> http://player.phazefm.com.au
Website --> http://www.phazefm.com.au
Network Website: -->
http://www.phazern.com.au

PHAZE FM

  • Jr. Member

  • Offline
  • **
  • 99
    • PHAZE FM
Re: Database Errors
« Reply #1 on: January 12, 2019, 12:12:26 AM »
Hey,

The issue is the error keeps changing but it resolves all around "Database Insert Error: Illegal argument to a regular expression. "

What tipped me off to this is there is gaps in the audio, loike RDJ freezes and becomes unresponsive and then will continue. All of our tracks have been manually edited re cross fades etc (for the most part)

This seems to be only music tracks, every other file is fine.

Here is the latest error from this minutes ago

Code: [Select]
Database Insert Error: Illegal argument to a regular expression. (CALL UpdateTracks(9087,0,0,0,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[:<:]]Maroon 5[[:>:]]';)
Regards,

Matthew Matters
Station Manager
PHAZE FM Radio Network

info@phazefm.com.au
+61 (3) 53105953

LISTEN LIVE --> http://player.phazefm.com.au
Website --> http://www.phazefm.com.au
Network Website: -->
http://www.phazern.com.au

OnePlayRadio

  • Full Member

  • Offline
  • ***
  • 100
    • One Play Radio
Re: Database Errors
« Reply #2 on: January 12, 2019, 04:13:20 AM »
hello, we too have had and continue to present this error in the database:

PI001 ERROR: Can't connect to MySQL server on '127.0.0.1' (10061):
There was an exception of type 'System.OutOfMemoryException'. (CALL UpdateTracks(1020,0,0,365,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[[:<:]]Evanescence[[:>:]]'; )

like you, all the songs have been edited in the cue points manually, but every so often we have generated this error. This last one corresponds to the 6th of January of this year.

regrads.
One Play Radio
www.oneplayradio.com
Tw: @oneplayradio
Fb: oneplayfm
-- Un nuevo concepto en Rock --

Marius

  • Administrator
  • Hero Member

  • Offline
  • *****
  • 5440
    • Radio DJ Romania
Re: Database Errors
« Reply #3 on: January 12, 2019, 08:38:04 AM »
Which version of RadioDJ?
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

PHAZE FM

  • Jr. Member

  • Offline
  • **
  • 99
    • PHAZE FM
Re: Database Errors
« Reply #4 on: January 12, 2019, 06:56:33 PM »
PI001 ERROR: Can't connect to MySQL server on '127.0.0.1' (10061):
There was an exception of type 'System.OutOfMemoryException'. (CALL UpdateTracks(1020,0,0,365,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[[:<:]]Evanescence[[:>:]]'; )

Your error is your file server / database server is out of system memory or the swap is full. Is your database server linux or Windows?

Which version of RadioDJ?

Hi Marius - 2.0.0.6, Windows 10 Pro x64 Netframework 4.5 (Patched), As you know we have made several adjustments to the database to get our now playing script to work properly with it, however it has been working flawlessly until we had to upgrade from CentOS6 to CentOS 7. I am presuming mysql was upgraded as well
Regards,

Matthew Matters
Station Manager
PHAZE FM Radio Network

info@phazefm.com.au
+61 (3) 53105953

LISTEN LIVE --> http://player.phazefm.com.au
Website --> http://www.phazefm.com.au
Network Website: -->
http://www.phazern.com.au

OnePlayRadio

  • Full Member

  • Offline
  • ***
  • 100
    • One Play Radio
Re: Database Errors
« Reply #5 on: January 12, 2019, 09:45:22 PM »
Which version of RadioDJ?

in my case is radiodj 2.0.0.1 on an inter i5-3470 equipment of 2,90 GHz and 8 GB of RAM with windows 7 professional and mariadb database of 64bits.
One Play Radio
www.oneplayradio.com
Tw: @oneplayradio
Fb: oneplayfm
-- Un nuevo concepto en Rock --

OnePlayRadio

  • Full Member

  • Offline
  • ***
  • 100
    • One Play Radio
Re: Database Errors
« Reply #6 on: January 15, 2019, 02:28:42 AM »
This error would seem to be a DB error of some description and not a rdj error.
Have a look at the database logs, also have a look at the windows event logs.

is correct, the error is database and not radiodj, but affects the operation of rdj. We know the effect, but not the cause, in windows events (in my case) I have several errors but the one shown directly as database is:

PI001 ERROR: Can't connect to MySQL server on '127.0.0.1' (10061):
There was an exception of type 'System.OutOfMemoryException'.  (CALL UpdateTracks(1020,0,0,365,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[[:<:]]Evanescence[[:>:]]'; )

I have investigated before because it is not the first time that it happens to me, but I have not been able to find a solution. Some time ago Marius recommended me to use MariaDB and that's what I did, but I still have this kind of events from time to time.

One Play Radio
www.oneplayradio.com
Tw: @oneplayradio
Fb: oneplayfm
-- Un nuevo concepto en Rock --

PHAZE FM

  • Jr. Member

  • Offline
  • **
  • 99
    • PHAZE FM
Re: Database Errors
« Reply #7 on: January 16, 2019, 03:09:41 AM »
Guys,

I have said form the start that my issue is with the database, however i am not sure what the error is exactly and how to fix it. I have tried to run a database check from MYSQL and all tables are reporting that they are fine.

I dont want to just overwrite the database as there is some customization for our web player in it.

I dont know how a SQL dump and a SQL import could cause this issue as its a straight export and import
Regards,

Matthew Matters
Station Manager
PHAZE FM Radio Network

info@phazefm.com.au
+61 (3) 53105953

LISTEN LIVE --> http://player.phazefm.com.au
Website --> http://www.phazefm.com.au
Network Website: -->
http://www.phazern.com.au

rkriggs

  • Sr. Member

  • Offline
  • ****
  • 351
Re: Database Errors
« Reply #8 on: January 16, 2019, 04:41:18 AM »
Make sure the old system and new system have the exact same version of radio dj.

Randy

Marius

  • Administrator
  • Hero Member

  • Offline
  • *****
  • 5440
    • Radio DJ Romania
Re: Database Errors
« Reply #9 on: January 16, 2019, 12:03:31 PM »
One thing I note is that there a 3 [[[.

I noticed too. What is confusing is that the query it doesn't have 3 items. It looks like this:

Code: [Select]
"UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[:<:]]" & rdjInterface.Utils.QueryFixRegex(sWord.Trim) & "[[:>:]]';"
Even if the "sWord.Trim" variable would contain a bracket, it would not be placed there.

@PHAZE FM:
If you play the track from Maroon 5 which was caused the error, can you reproduce it again? Which version of MySQL do you use?
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

PHAZE FM

  • Jr. Member

  • Offline
  • **
  • 99
    • PHAZE FM
Re: Database Errors
« Reply #10 on: January 17, 2019, 10:10:39 AM »
Evening Marius,

Please see the specs of our File Server / Database Server below. Admitted the server is overkill for what it does but its better to have to much then not enough for the 4 studios we operate:

CPU:
2x Intel Xeon D-2191 @ 1.60GHZ
18 Cores
36 Threads
24 MB Cache

RAM:
24GB DDR4 1633MHZ ECC

Disks:
10x Seagate Ironwolf Pro NAS 10TB Disks (Raid 10)

Operating System:
CentOS 7.5 x64

Network:
2x Intel Gigabit Ethernet Cards

Database Engine:
Server version: 8.0.13 MySQL Community Server - GPL

Its important that we did a dump from MYSQL 5.x and imported into this SQL version. Mysql is not natively supported on CentOS 7

P.S - It should be noted that we are streaming .wav files across the network live between file server and which ever studio is on air. All studios are spitting our the same error. All studios are on 2.0.0.6

Marius, If you would like me to send you a copy of the database for you to have a look at please let me know and i will send you a DM with a link to download the database to have a look at.

At a guess, i would say that RDJ is NOT compatible with MYSQL 8.X - MYSQL did change alot in this version, so i would not be suprised if the table struture or the way it handles its data has changed between version 5 and version 8.

I did message the MYSQL list and they said that it should not matter, it should be backwards compatible
Regards,

Matthew Matters
Station Manager
PHAZE FM Radio Network

info@phazefm.com.au
+61 (3) 53105953

LISTEN LIVE --> http://player.phazefm.com.au
Website --> http://www.phazefm.com.au
Network Website: -->
http://www.phazern.com.au

PHAZE FM

  • Jr. Member

  • Offline
  • **
  • 99
    • PHAZE FM
Re: Database Errors
« Reply #11 on: January 22, 2019, 04:46:16 AM »
Have you looked at the mysql server logs? and while there have you looked for any other logs?

There isnt any other errors, MYSQL on the linux server isnt reporting any of the issues.

Have you tried running the query from the mysql client on the linux server?

No i haven't. If you read my previous reply this issue only happened when we upgraded the database engine (mysql) or the exporting and importing of the database

I would more likely say that the issue is the MYSQL version thats causing issues.

Maruis do you have any ideas as this is a really serious issue that i need fixed
Regards,

Matthew Matters
Station Manager
PHAZE FM Radio Network

info@phazefm.com.au
+61 (3) 53105953

LISTEN LIVE --> http://player.phazefm.com.au
Website --> http://www.phazefm.com.au
Network Website: -->
http://www.phazern.com.au

PHAZE FM

  • Jr. Member

  • Offline
  • **
  • 99
    • PHAZE FM
Re: Database Errors
« Reply #12 on: January 24, 2019, 01:49:16 PM »
Marius that was all provided a few posts back....
Regards,

Matthew Matters
Station Manager
PHAZE FM Radio Network

info@phazefm.com.au
+61 (3) 53105953

LISTEN LIVE --> http://player.phazefm.com.au
Website --> http://www.phazefm.com.au
Network Website: -->
http://www.phazern.com.au

PHAZE FM

  • Jr. Member

  • Offline
  • **
  • 99
    • PHAZE FM
Re: Database Errors
« Reply #13 on: January 28, 2019, 03:50:47 AM »
Hi All,

Do we have any answers for this?
Regards,

Matthew Matters
Station Manager
PHAZE FM Radio Network

info@phazefm.com.au
+61 (3) 53105953

LISTEN LIVE --> http://player.phazefm.com.au
Website --> http://www.phazefm.com.au
Network Website: -->
http://www.phazern.com.au

PHAZE FM

  • Jr. Member

  • Offline
  • **
  • 99
    • PHAZE FM
Re: Database Errors
« Reply #14 on: January 28, 2019, 04:21:57 AM »
On every song change the following error gets spit out into the windows event log:

Code: [Select]
Database Insert Error: Illegal argument to a regular expression. (CALL UpdateTracks(8157,0,0,0,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[:<:]]Blink 182[[:>:]]';)

Where "Blink 182" is the only part that seems to change

There is nothing of significance in the mysql log, just complaining about dns resolution failure for the host name of a server at our backup studio which is switched off
Regards,

Matthew Matters
Station Manager
PHAZE FM Radio Network

info@phazefm.com.au
+61 (3) 53105953

LISTEN LIVE --> http://player.phazefm.com.au
Website --> http://www.phazefm.com.au
Network Website: -->
http://www.phazern.com.au