Devart Forums

Hi,
I'm now using MyDac v3.30.2.15 Delphi 5.
Sometimes I encountered the error when open the query. Why?

Net Packets out of order : received[0], expected[1]

Thanks

Please send us complete small sample to demonstrate it and include script to create server objects.

I also have this error with your newest build. Do you still need sample?

Dear all,

I also this error with last version 3.30.2.15 under Builder C++ 5.0.
This occured apparently only on Win98 client but not under XP.

I try also to uncheck compressed protocol but no result.


Serveur Mysql 4-0-16-standard log under linux.

Thanks for your support


Query :

INSERT INTO TUB (DESIGNATION, REF_FOUR, REF_SEIHE, FOURN, `PRIX U_HT`, CONDT, DELAIS, PAIEMENT) values(
'COLONNE D EXHAURE INOX DN150 DE 50ML AVEC DECHARDE DE 6ML A BRIDE/BRIDE + PLATEAU DN300',
'DEVIS W04/GC/0096',
'TUB-DEVIS W04/GC/0096',
'JOHNSON SCREENS DIVISION TUBAFOR',
5930.00,
'1',
'15',
'60JFDM'
)



CREATE TABLE `TUB` (
`DESIGNATION` char(255) NOT NULL default '',
`REF_FOUR` char(255) NOT NULL default '',
`REF_SEIHE` char(255) NOT NULL default '',
`FOURN` char(255) NOT NULL default '',
`PRIX U_HT` decimal(14,4) NOT NULL default '0.0000',
`CONDT` float NOT NULL default '0',
`DELAIS` smallint(6) NOT NULL default '0',
`PAIEMENT` char(50) NOT NULL default '',
PRIMARY KEY (`DESIGNATION`)
) TYPE=MyISAM

Sorry, we cannot reproduce this problem. Small Delphi project will be appreciated.

We couldn't reproduce the problem. It seems its appearance depends on transfering data. Please follow the next steps:

1. Stop the server and create a reserve copy of mysql\data\test\TUB.* at the server.
2. Send us these files. If data volume is too large or it is impossible by some reasons, try to decrease a number of records.
3. Send us your configuration file of MySQL Server (my.ini).
4. Attach simplest Delphi-project to demonstrate the problem.

Dear ALL
I also got this type of error.

the following TMyQuery sould work without problem
but as [Alias] add in SQL.String SQL Statement this problem will be trigger.

SQL.Strings = (
'SELECT'
' *'
'FROM RVS'
'reference_van_sales'
'ORDER BY Ref_Prefix'
'')

object sReferenceCounterSQL: TMyQuery
SQLInsert.Strings = (
'INSERT INTO referenceCounter'
' (Itemno, CASH, DO, INV, SIN, SOT, IsLOCK, Timestamp_)'
'VALUES'
' (:Itemno, :CASH, :DO, :INV, :SIN, :SOT, :IsLOCK, :Timestamp_)')
SQLDelete.Strings = (
'DELETE FROM referenceCounter'
'WHERE'
' Itemno = :Old_Itemno')
SQLUpdate.Strings = (
'UPDATE referenceCounter'
'SET'

' Itemno = :Itemno, CASH = :CASH, DO = :DO, INV = :INV, SIN = :S' +
'IN, SOT = :SOT, IsLOCK = :IsLOCK, Timestamp_ = :Timestamp_'
'WHERE'
' Itemno = :Old_Itemno')
SQLRefresh.Strings = (

'SELECT referenceCounter.Itemno, referenceCounter.CASH, reference' +
'Counter.DO, referenceCounter.INV, referenceCounter.SIN, referenc' +
'eCounter.SOT, referenceCounter.IsLOCK, referenceCounter.Timestam' +
'p_ FROM referenceCounter'
'WHERE'
' referenceCounter.Itemno = :Old_Itemno')
Connection = nData.dConnection
SQL.Strings = (
'select * from referenceCounter')
CachedUpdates = True
FetchAll = True
CommandTimeout = 30
Left = 16
Top = 88
end
object sRef_VanSalesSQL: TMyQuery
SQLInsert.Strings = (
'INSERT INTO reference_van_sales'

' (Ref_Prefix, Ref_Number, Reference_Type, Saleman_ID, Descripti' +
'ons, Status, Locked)'
'SELECT'
' :Ref_Prefix,'
' :Ref_Number, '
' RPT.Reference_Type, '
' :Saleman_ID, '
' :Descriptions, '
' :Status, '
' :Locked'
'FROM'
' reference_prefix_type RPT'
'WHERE'
' RPT.Ref_Prefix = :Ref_Prefix')
SQLDelete.Strings = (
'DELETE FROM reference_van_sales'
'WHERE'
' Ref_Prefix = :Old_Ref_Prefix')
SQLUpdate.Strings = (
'UPDATE reference_van_sales RVS, reference_prefix_type RPT'
'SET'
' RVS.Ref_Prefix = :Ref_Prefix, '
' RVS.Ref_Number = :Ref_Number, '
' RVS.Reference_Type = RPT.Reference_Type, '
' RVS.Saleman_ID = :Saleman_ID, '
' RVS.Descriptions = :Descriptions, '
' RVS.Status = :Status, '
' RVS.Locked = :Locked'
'WHERE'
' RVS.Ref_Prefix = :Old_Ref_Prefix AND'
' RPT.Ref_Prefix = :Ref_Prefix')
SQLRefresh.Strings = (

'SELECT reference_van_sales.Ref_Prefix, reference_van_sales.Ref_N' +
'umber, reference_van_sales.Reference_Type, reference_van_sales.S' +
'aleman_ID, reference_van_sales.Descriptions, reference_van_sales' +
'.Status, reference_van_sales.Locked FROM reference_van_sales'
'WHERE'
' reference_van_sales.Ref_Prefix = :Old_Ref_Prefix')
Connection = nData.dConnection
SQL.Strings = (
'SELECT'
' *'
'FROM'
'reference_van_sales'
'ORDER BY Ref_Prefix'
'')
FetchRows = 1
CachedUpdates = True
FetchAll = True
CommandTimeout = 30
Left = 56
Top = 88
end

The example you sent us doesn't make any sense without a script to create and fill tables. Beside that we need to know the next:

1. Do you use compression (MyConnection.Options.Compress)?
2. What MyDAC version (3.XX.XX.XX) do you use?
3. What MySQL version (4.X.XX) do you use?

Hi,
Just checking if the cause of this problem has been found, as I am intermittently getting it with MyDac 3.50.0.16 under BCB 6 and mysql 3.23.55 running on win 2k

Are you using multiple threads in your application?
I ran into this issue because I was running multiple threads using the same Connections/Tables

Having just updated to 3.50.20 for D7 I now get the net packets out of sequence using a project and database that were working previously.
Not server version (4.17 and 5.03), not compression. My platform win2k

What is the previous version of MyDAC that you use?

I also had this problem. Was caused by a thread and a form using the same connection. I created a new connection in the thread instead and this seemed to solve the problem.